eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKE_BILLING_EVENT_PUB dependencies on OKE_API

Line 10: G_FND_APP CONSTANT VARCHAR2(200) := OKE_API.G_FND_APP;

6:
7:
8: -- GLOBAL MESSAGE CONSTANTS
9:
10: G_FND_APP CONSTANT VARCHAR2(200) := OKE_API.G_FND_APP;
11:
12: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKE_API.G_FORM_UNABLE_TO_RESERVE_REC;
13: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_DELETED;
14:

Line 12: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKE_API.G_FORM_UNABLE_TO_RESERVE_REC;

8: -- GLOBAL MESSAGE CONSTANTS
9:
10: G_FND_APP CONSTANT VARCHAR2(200) := OKE_API.G_FND_APP;
11:
12: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKE_API.G_FORM_UNABLE_TO_RESERVE_REC;
13: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_DELETED;
14:
15: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_CHANGED;
16:

Line 13: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_DELETED;

9:
10: G_FND_APP CONSTANT VARCHAR2(200) := OKE_API.G_FND_APP;
11:
12: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKE_API.G_FORM_UNABLE_TO_RESERVE_REC;
13: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_DELETED;
14:
15: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_CHANGED;
16:
17: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_RECORD_LOGICALLY_DELETED;

Line 15: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_CHANGED;

11:
12: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKE_API.G_FORM_UNABLE_TO_RESERVE_REC;
13: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_DELETED;
14:
15: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_CHANGED;
16:
17: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_RECORD_LOGICALLY_DELETED;
18: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_REQUIRED_VALUE;
19: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_INVALID_VALUE;

Line 17: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_RECORD_LOGICALLY_DELETED;

13: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_DELETED;
14:
15: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_CHANGED;
16:
17: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_RECORD_LOGICALLY_DELETED;
18: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_REQUIRED_VALUE;
19: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_INVALID_VALUE;
20: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_COL_NAME_TOKEN;
21: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_PARENT_TABLE_TOKEN;

Line 18: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_REQUIRED_VALUE;

14:
15: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_CHANGED;
16:
17: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_RECORD_LOGICALLY_DELETED;
18: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_REQUIRED_VALUE;
19: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_INVALID_VALUE;
20: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_COL_NAME_TOKEN;
21: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_PARENT_TABLE_TOKEN;
22: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_TABLE_TOKEN;

Line 19: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_INVALID_VALUE;

15: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_CHANGED;
16:
17: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_RECORD_LOGICALLY_DELETED;
18: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_REQUIRED_VALUE;
19: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_INVALID_VALUE;
20: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_COL_NAME_TOKEN;
21: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_PARENT_TABLE_TOKEN;
22: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_TABLE_TOKEN;
23:

Line 20: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_COL_NAME_TOKEN;

16:
17: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_RECORD_LOGICALLY_DELETED;
18: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_REQUIRED_VALUE;
19: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_INVALID_VALUE;
20: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_COL_NAME_TOKEN;
21: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_PARENT_TABLE_TOKEN;
22: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_TABLE_TOKEN;
23:
24: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKE_NO_PARENT_RECORD';

Line 21: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_PARENT_TABLE_TOKEN;

17: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_RECORD_LOGICALLY_DELETED;
18: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_REQUIRED_VALUE;
19: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_INVALID_VALUE;
20: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_COL_NAME_TOKEN;
21: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_PARENT_TABLE_TOKEN;
22: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_TABLE_TOKEN;
23:
24: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKE_NO_PARENT_RECORD';
25: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKE_CONTRACTS_UNEXPECTED_ERROR';

Line 22: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_TABLE_TOKEN;

18: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_REQUIRED_VALUE;
19: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_INVALID_VALUE;
20: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_COL_NAME_TOKEN;
21: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_PARENT_TABLE_TOKEN;
22: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_TABLE_TOKEN;
23:
24: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKE_NO_PARENT_RECORD';
25: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKE_CONTRACTS_UNEXPECTED_ERROR';
26:

Line 38: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

34:
35: Function validate_billing_attributes(p_k_billing_event_rec IN OKE_BILLING_EVENT_PUB.k_billing_event_rec_type )
36: RETURN VARCHAR2 IS
37:
38: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
39: x_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
40:
41:
42: PROCEDURE Validate_Header_ID (X_Return_Status OUT NOCOPY VARCHAR2,

Line 39: x_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

35: Function validate_billing_attributes(p_k_billing_event_rec IN OKE_BILLING_EVENT_PUB.k_billing_event_rec_type )
36: RETURN VARCHAR2 IS
37:
38: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
39: x_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
40:
41:
42: PROCEDURE Validate_Header_ID (X_Return_Status OUT NOCOPY VARCHAR2,
43: p_k_billing_event_rec IN OKE_BILLING_EVENT_PUB.k_billing_event_rec_type) IS

Line 54: X_Return_Status := OKE_API.G_RET_STS_SUCCESS;

50: WHERE ID = P_ID;
51:
52: Begin
53:
54: X_Return_Status := OKE_API.G_RET_STS_SUCCESS;
55:
56: IF p_k_billing_event_rec.K_Header_ID IS NOT null THEN
57:
58:

Line 65: OKE_API.SET_MESSAGE(p_app_name => g_app_name,

61: CLOSE C;
62:
63: IF L_Value <> 'X' THEN
64:
65: OKE_API.SET_MESSAGE(p_app_name => g_app_name,
66: p_msg_name => g_invalid_value,
67: p_token1 => g_col_name_token,
68: p_token1_value => 'K_Header_ID');
69: -- notify caller of an error

Line 70: X_Return_Status := OKE_API.G_RET_STS_ERROR;

66: p_msg_name => g_invalid_value,
67: p_token1 => g_col_name_token,
68: p_token1_value => 'K_Header_ID');
69: -- notify caller of an error
70: X_Return_Status := OKE_API.G_RET_STS_ERROR;
71:
72: -- halt validation
73: RAISE G_EXCEPTION_HALT_VALIDATION;
74:

Line 88: OKE_API.SET_MESSAGE(p_app_name => g_app_name,

84:
85: WHEN OTHERS THEN
86:
87: -- store SQL error message on message stack
88: OKE_API.SET_MESSAGE(p_app_name => g_app_name,
89: p_msg_name => g_unexpected_error,
90: p_token1 => g_sqlcode_token,
91: p_token1_value=> sqlcode,
92: p_token2 => g_sqlerrm_token,

Line 95: X_Return_Status := OKE_API.G_RET_STS_UNEXP_ERROR;

91: p_token1_value=> sqlcode,
92: p_token2 => g_sqlerrm_token,
93: p_token2_value=> sqlerrm);
94: -- notify caller of an error as UNEXPETED error
95: X_Return_Status := OKE_API.G_RET_STS_UNEXP_ERROR;
96:
97: End Validate_Header_ID;
98:
99: PROCEDURE Validate_Line_ID (X_Return_Status OUT NOCOPY VARCHAR2,

Line 112: X_Return_Status := OKE_API.G_RET_STS_SUCCESS;

108:
109:
110: Begin
111:
112: X_Return_Status := OKE_API.G_RET_STS_SUCCESS;
113:
114: IF p_k_billing_event_rec.K_Line_ID IS NOT null THEN
115:
116: OPEN C ( p_k_billing_event_rec.K_Line_ID);

Line 124: OKE_API.SET_MESSAGE(p_app_name => g_app_name,

120:
121:
122: IF L_Value <> 'X' THEN
123:
124: OKE_API.SET_MESSAGE(p_app_name => g_app_name,
125: p_msg_name => g_invalid_value,
126: p_token1 => g_col_name_token,
127: p_token1_value => 'K_Line_ID');
128: -- notify caller of an error

Line 129: X_Return_Status := OKE_API.G_RET_STS_ERROR;

125: p_msg_name => g_invalid_value,
126: p_token1 => g_col_name_token,
127: p_token1_value => 'K_Line_ID');
128: -- notify caller of an error
129: X_Return_Status := OKE_API.G_RET_STS_ERROR;
130:
131: -- halt validation
132: RAISE G_EXCEPTION_HALT_VALIDATION;
133:

Line 148: OKE_API.SET_MESSAGE(p_app_name => g_app_name,

144:
145:
146: IF L_Value <> 'X' THEN
147:
148: OKE_API.SET_MESSAGE(p_app_name => g_app_name,
149: p_msg_name => g_invalid_value,
150: p_token1 => g_col_name_token,
151: p_token1_value => 'Bill_Line_Id');
152: -- notify caller of an error

Line 153: X_Return_Status := OKE_API.G_RET_STS_ERROR;

149: p_msg_name => g_invalid_value,
150: p_token1 => g_col_name_token,
151: p_token1_value => 'Bill_Line_Id');
152: -- notify caller of an error
153: X_Return_Status := OKE_API.G_RET_STS_ERROR;
154:
155: -- halt validation
156: RAISE G_EXCEPTION_HALT_VALIDATION;
157:

Line 170: OKE_API.SET_MESSAGE(p_app_name => g_app_name,

166:
167: WHEN OTHERS THEN
168:
169: -- store SQL error message on message stack
170: OKE_API.SET_MESSAGE(p_app_name => g_app_name,
171: p_msg_name => g_unexpected_error,
172: p_token1 => g_sqlcode_token,
173: p_token1_value=> sqlcode,
174: p_token2 => g_sqlerrm_token,

Line 177: X_Return_Status := OKE_API.G_RET_STS_UNEXP_ERROR;

173: p_token1_value=> sqlcode,
174: p_token2 => g_sqlerrm_token,
175: p_token2_value=> sqlerrm);
176: -- notify caller of an error as UNEXPETED error
177: X_Return_Status := OKE_API.G_RET_STS_UNEXP_ERROR;
178:
179: End Validate_Line_ID;
180:
181:

Line 196: X_Return_Status := OKE_API.G_RET_STS_SUCCESS;

192: AND Nvl(ready_to_bill,'N')='Y' ;
193:
194: Begin
195:
196: X_Return_Status := OKE_API.G_RET_STS_SUCCESS;
197:
198: IF p_k_billing_event_rec.Deliverable_ID IS NOT null THEN
199:
200: OPEN C ( p_k_billing_event_rec.K_Line_ID, p_k_billing_event_rec.Deliverable_ID );

Line 208: OKE_API.SET_MESSAGE(p_app_name => g_app_name,

204:
205:
206: IF L_Value <> 'X' THEN
207:
208: OKE_API.SET_MESSAGE(p_app_name => g_app_name,
209: p_msg_name => g_invalid_value,
210: p_token1 => g_col_name_token,
211: p_token1_value => 'Deliverable_ID');
212: -- notify caller of an error

Line 213: X_Return_Status := OKE_API.G_RET_STS_ERROR;

209: p_msg_name => g_invalid_value,
210: p_token1 => g_col_name_token,
211: p_token1_value => 'Deliverable_ID');
212: -- notify caller of an error
213: X_Return_Status := OKE_API.G_RET_STS_ERROR;
214:
215: -- halt validation
216: RAISE G_EXCEPTION_HALT_VALIDATION;
217:

Line 230: OKE_API.SET_MESSAGE(p_app_name => g_app_name,

226:
227: WHEN OTHERS THEN
228:
229: -- store SQL error message on message stack
230: OKE_API.SET_MESSAGE(p_app_name => g_app_name,
231: p_msg_name => g_unexpected_error,
232: p_token1 => g_sqlcode_token,
233: p_token1_value=> sqlcode,
234: p_token2 => g_sqlerrm_token,

Line 237: X_Return_Status := OKE_API.G_RET_STS_UNEXP_ERROR;

233: p_token1_value=> sqlcode,
234: p_token2 => g_sqlerrm_token,
235: p_token2_value=> sqlerrm);
236: -- notify caller of an error as UNEXPETED error
237: X_Return_Status := OKE_API.G_RET_STS_UNEXP_ERROR;
238:
239: End Validate_Deliverable_Id;
240:
241: PROCEDURE Validate_Project_ID (X_Return_Status OUT NOCOPY VARCHAR2,

Line 290: X_Return_Status := OKE_API.G_RET_STS_SUCCESS;

286: WHERE CLE_ID = P_ID;
287:
288: Begin
289:
290: X_Return_Status := OKE_API.G_RET_STS_SUCCESS;
291:
292: IF p_k_billing_event_rec.bill_Project_ID IS NOT null THEN
293:
294: L_Line_Id := p_k_billing_event_rec.K_Line_ID;

Line 343: OKE_API.SET_MESSAGE(p_app_name => g_app_name,

339:
340:
341: IF L_Value <> 'X' THEN
342:
343: OKE_API.SET_MESSAGE(p_app_name => g_app_name,
344: p_msg_name => g_invalid_value,
345: p_token1 => g_col_name_token,
346: p_token1_value => 'Project_ID');
347: -- notify caller of an error

Line 348: X_Return_Status := OKE_API.G_RET_STS_ERROR;

344: p_msg_name => g_invalid_value,
345: p_token1 => g_col_name_token,
346: p_token1_value => 'Project_ID');
347: -- notify caller of an error
348: X_Return_Status := OKE_API.G_RET_STS_ERROR;
349:
350: -- halt validation
351: RAISE G_EXCEPTION_HALT_VALIDATION;
352:

Line 366: OKE_API.SET_MESSAGE(p_app_name => g_app_name,

362:
363: WHEN OTHERS THEN
364:
365: -- store SQL error message on message stack
366: OKE_API.SET_MESSAGE(p_app_name => g_app_name,
367: p_msg_name => g_unexpected_error,
368: p_token1 => g_sqlcode_token,
369: p_token1_value=> sqlcode,
370: p_token2 => g_sqlerrm_token,

Line 373: X_Return_Status := OKE_API.G_RET_STS_UNEXP_ERROR;

369: p_token1_value=> sqlcode,
370: p_token2 => g_sqlerrm_token,
371: p_token2_value=> sqlerrm);
372: -- notify caller of an error as UNEXPETED error
373: X_Return_Status := OKE_API.G_RET_STS_UNEXP_ERROR;
374:
375: End Validate_Project_ID;
376:
377: PROCEDURE Validate_Task_ID (X_Return_Status OUT NOCOPY VARCHAR2,

Line 389: X_Return_Status := OKE_API.G_RET_STS_SUCCESS;

385: AND Project_ID = P_ID2;
386:
387: Begin
388:
389: X_Return_Status := OKE_API.G_RET_STS_SUCCESS;
390:
391: IF p_k_billing_event_rec.BILL_TASK_ID IS NOT NULL THEN
392:
393: IF p_k_billing_event_rec.BILL_Project_ID IS NULL OR p_k_billing_event_rec.BILL_Project_ID=OKE_API.G_MISS_NUM THEN

Line 393: IF p_k_billing_event_rec.BILL_Project_ID IS NULL OR p_k_billing_event_rec.BILL_Project_ID=OKE_API.G_MISS_NUM THEN

389: X_Return_Status := OKE_API.G_RET_STS_SUCCESS;
390:
391: IF p_k_billing_event_rec.BILL_TASK_ID IS NOT NULL THEN
392:
393: IF p_k_billing_event_rec.BILL_Project_ID IS NULL OR p_k_billing_event_rec.BILL_Project_ID=OKE_API.G_MISS_NUM THEN
394:
395: OKE_API.SET_MESSAGE(p_app_name => g_app_name,
396: p_msg_name => g_required_value,
397: p_token1 => g_col_name_token,

Line 395: OKE_API.SET_MESSAGE(p_app_name => g_app_name,

391: IF p_k_billing_event_rec.BILL_TASK_ID IS NOT NULL THEN
392:
393: IF p_k_billing_event_rec.BILL_Project_ID IS NULL OR p_k_billing_event_rec.BILL_Project_ID=OKE_API.G_MISS_NUM THEN
394:
395: OKE_API.SET_MESSAGE(p_app_name => g_app_name,
396: p_msg_name => g_required_value,
397: p_token1 => g_col_name_token,
398: p_token1_value => 'Project_ID');
399: -- notify caller of an error

Line 400: X_Return_Status := OKE_API.G_RET_STS_ERROR;

396: p_msg_name => g_required_value,
397: p_token1 => g_col_name_token,
398: p_token1_value => 'Project_ID');
399: -- notify caller of an error
400: X_Return_Status := OKE_API.G_RET_STS_ERROR;
401:
402: -- halt validation
403: RAISE G_EXCEPTION_HALT_VALIDATION;
404:

Line 413: OKE_API.SET_MESSAGE(p_app_name => g_app_name,

409: CLOSE C;
410:
411: IF L_Value <> 'X' THEN
412:
413: OKE_API.SET_MESSAGE(p_app_name => g_app_name,
414: p_msg_name => g_invalid_value,
415: p_token1 => g_col_name_token,
416: p_token1_value => 'Task_ID');
417: -- notify caller of an error

Line 418: X_Return_Status := OKE_API.G_RET_STS_ERROR;

414: p_msg_name => g_invalid_value,
415: p_token1 => g_col_name_token,
416: p_token1_value => 'Task_ID');
417: -- notify caller of an error
418: X_Return_Status := OKE_API.G_RET_STS_ERROR;
419:
420: -- halt validation
421: RAISE G_EXCEPTION_HALT_VALIDATION;
422:

Line 437: OKE_API.SET_MESSAGE(p_app_name => g_app_name,

433:
434: WHEN OTHERS THEN
435:
436: -- store SQL error message on message stack
437: OKE_API.SET_MESSAGE(p_app_name => g_app_name,
438: p_msg_name => g_unexpected_error,
439: p_token1 => g_sqlcode_token,
440: p_token1_value=> sqlcode,
441: p_token2 => g_sqlerrm_token,

Line 444: X_Return_Status := OKE_API.G_RET_STS_UNEXP_ERROR;

440: p_token1_value=> sqlcode,
441: p_token2 => g_sqlerrm_token,
442: p_token2_value=> sqlerrm);
443: -- notify caller of an error as UNEXPETED error
444: X_Return_Status := OKE_API.G_RET_STS_UNEXP_ERROR;
445:
446: End Validate_Task_ID;
447:
448: PROCEDURE Validate_BILL_EVENT_TYPE (X_Return_Status OUT NOCOPY VARCHAR2,

Line 462: X_Return_Status := OKE_API.G_RET_STS_SUCCESS;

458:
459:
460: Begin
461:
462: X_Return_Status := OKE_API.G_RET_STS_SUCCESS;
463:
464: IF p_k_billing_event_rec.BILL_EVENT_TYPE IS NOT NULL THEN
465:
466: OPEN C ( p_k_billing_event_rec.BILL_EVENT_TYPE );

Line 472: OKE_API.SET_MESSAGE(p_app_name => g_app_name,

468: CLOSE C;
469:
470: IF L_Value <> 'X' THEN
471:
472: OKE_API.SET_MESSAGE(p_app_name => g_app_name,
473: p_msg_name => g_invalid_value,
474: p_token1 => g_col_name_token,
475: p_token1_value => 'BILL_EVENT_TYPE');
476: -- notify caller of an error

Line 477: X_Return_Status := OKE_API.G_RET_STS_ERROR;

473: p_msg_name => g_invalid_value,
474: p_token1 => g_col_name_token,
475: p_token1_value => 'BILL_EVENT_TYPE');
476: -- notify caller of an error
477: X_Return_Status := OKE_API.G_RET_STS_ERROR;
478:
479: -- halt validation
480: RAISE G_EXCEPTION_HALT_VALIDATION;
481:

Line 496: OKE_API.SET_MESSAGE(p_app_name => g_app_name,

492:
493: WHEN OTHERS THEN
494:
495: -- store SQL error message on message stack
496: OKE_API.SET_MESSAGE(p_app_name => g_app_name,
497: p_msg_name => g_unexpected_error,
498: p_token1 => g_sqlcode_token,
499: p_token1_value=> sqlcode,
500: p_token2 => g_sqlerrm_token,

Line 503: X_Return_Status := OKE_API.G_RET_STS_UNEXP_ERROR;

499: p_token1_value=> sqlcode,
500: p_token2 => g_sqlerrm_token,
501: p_token2_value=> sqlerrm);
502: -- notify caller of an error as UNEXPETED error
503: X_Return_Status := OKE_API.G_RET_STS_UNEXP_ERROR;
504:
505: End Validate_BILL_EVENT_TYPE;
506:
507: PROCEDURE Validate_item (X_Return_Status OUT NOCOPY VARCHAR2,

Line 522: X_Return_Status := OKE_API.G_RET_STS_SUCCESS;

518:
519: l_Inv_Organization_ID NUMBER;
520: Begin
521:
522: X_Return_Status := OKE_API.G_RET_STS_SUCCESS;
523:
524: IF p_k_billing_event_rec.Bill_Item_Id IS NOT NULL THEN
525:
526: OPEN inv_org ;

Line 537: OKE_API.SET_MESSAGE(p_app_name => g_app_name,

533:
534:
535: IF L_Value <> 'X' THEN
536:
537: OKE_API.SET_MESSAGE(p_app_name => g_app_name,
538: p_msg_name => g_invalid_value,
539: p_token1 => g_col_name_token,
540: p_token1_value => 'Bill_Item_Id');
541: -- notify caller of an error

Line 542: X_Return_Status := OKE_API.G_RET_STS_ERROR;

538: p_msg_name => g_invalid_value,
539: p_token1 => g_col_name_token,
540: p_token1_value => 'Bill_Item_Id');
541: -- notify caller of an error
542: X_Return_Status := OKE_API.G_RET_STS_ERROR;
543:
544: -- halt validation
545: RAISE G_EXCEPTION_HALT_VALIDATION;
546:

Line 561: OKE_API.SET_MESSAGE(p_app_name => g_app_name,

557:
558: WHEN OTHERS THEN
559:
560: -- store SQL error message on message stack
561: OKE_API.SET_MESSAGE(p_app_name => g_app_name,
562: p_msg_name => g_unexpected_error,
563: p_token1 => g_sqlcode_token,
564: p_token1_value=> sqlcode,
565: p_token2 => g_sqlerrm_token,

Line 568: X_Return_Status := OKE_API.G_RET_STS_UNEXP_ERROR;

564: p_token1_value=> sqlcode,
565: p_token2 => g_sqlerrm_token,
566: p_token2_value=> sqlerrm);
567: -- notify caller of an error as UNEXPETED error
568: X_Return_Status := OKE_API.G_RET_STS_UNEXP_ERROR;
569:
570: End Validate_item;
571:
572: PROCEDURE Validate_CHANGE_REQUEST_ID (X_Return_Status OUT NOCOPY VARCHAR2,

Line 583: X_Return_Status := OKE_API.G_RET_STS_SUCCESS;

579:
580:
581: Begin
582:
583: X_Return_Status := OKE_API.G_RET_STS_SUCCESS;
584:
585: IF p_k_billing_event_rec.BILL_CHG_REQ_ID IS NOT null THEN
586:
587:

Line 595: OKE_API.SET_MESSAGE(p_app_name => g_app_name,

591:
592:
593: IF L_Value <> 'X' THEN
594:
595: OKE_API.SET_MESSAGE(p_app_name => g_app_name,
596: p_msg_name => g_invalid_value,
597: p_token1 => g_col_name_token,
598: p_token1_value => 'BILL_CHG_REQ_ID');
599: -- notify caller of an error

Line 600: X_Return_Status := OKE_API.G_RET_STS_ERROR;

596: p_msg_name => g_invalid_value,
597: p_token1 => g_col_name_token,
598: p_token1_value => 'BILL_CHG_REQ_ID');
599: -- notify caller of an error
600: X_Return_Status := OKE_API.G_RET_STS_ERROR;
601:
602: -- halt validation
603: RAISE G_EXCEPTION_HALT_VALIDATION;
604:

Line 619: OKE_API.SET_MESSAGE(p_app_name => g_app_name,

615:
616: WHEN OTHERS THEN
617:
618: -- store SQL error message on message stack
619: OKE_API.SET_MESSAGE(p_app_name => g_app_name,
620: p_msg_name => g_unexpected_error,
621: p_token1 => g_sqlcode_token,
622: p_token1_value=> sqlcode,
623: p_token2 => g_sqlerrm_token,

Line 626: X_Return_Status := OKE_API.G_RET_STS_UNEXP_ERROR;

622: p_token1_value=> sqlcode,
623: p_token2 => g_sqlerrm_token,
624: p_token2_value=> sqlerrm);
625: -- notify caller of an error as UNEXPETED error
626: X_Return_Status := OKE_API.G_RET_STS_UNEXP_ERROR;
627:
628: End Validate_CHANGE_REQUEST_ID;
629:
630: PROCEDURE Validate_bill_org (X_Return_Status OUT NOCOPY VARCHAR2,

Line 650: X_Return_Status := OKE_API.G_RET_STS_SUCCESS;

646:
647: l_bill_ou NUMBER;
648: Begin
649:
650: X_Return_Status := OKE_API.G_RET_STS_SUCCESS;
651:
652: IF p_k_billing_event_rec.BILL_ORGANIZATION_ID IS NOT NULL THEN
653:
654: OPEN bill_ou ;

Line 665: OKE_API.SET_MESSAGE(p_app_name => g_app_name,

661:
662:
663: IF L_Value <> 'X' THEN
664:
665: OKE_API.SET_MESSAGE(p_app_name => g_app_name,
666: p_msg_name => g_invalid_value,
667: p_token1 => g_col_name_token,
668: p_token1_value => 'BILL_ORGANIZATION_ID');
669: -- notify caller of an error

Line 670: X_Return_Status := OKE_API.G_RET_STS_ERROR;

666: p_msg_name => g_invalid_value,
667: p_token1 => g_col_name_token,
668: p_token1_value => 'BILL_ORGANIZATION_ID');
669: -- notify caller of an error
670: X_Return_Status := OKE_API.G_RET_STS_ERROR;
671:
672: -- halt validation
673: RAISE G_EXCEPTION_HALT_VALIDATION;
674:

Line 689: OKE_API.SET_MESSAGE(p_app_name => g_app_name,

685:
686: WHEN OTHERS THEN
687:
688: -- store SQL error message on message stack
689: OKE_API.SET_MESSAGE(p_app_name => g_app_name,
690: p_msg_name => g_unexpected_error,
691: p_token1 => g_sqlcode_token,
692: p_token1_value=> sqlcode,
693: p_token2 => g_sqlerrm_token,

Line 696: X_Return_Status := OKE_API.G_RET_STS_UNEXP_ERROR;

692: p_token1_value=> sqlcode,
693: p_token2 => g_sqlerrm_token,
694: p_token2_value=> sqlerrm);
695: -- notify caller of an error as UNEXPETED error
696: X_Return_Status := OKE_API.G_RET_STS_UNEXP_ERROR;
697:
698: End Validate_bill_org;
699:
700: PROCEDURE Validate_bill_fund_ref (X_Return_Status OUT NOCOPY VARCHAR2,

Line 717: X_Return_Status := OKE_API.G_RET_STS_SUCCESS;

713:
714:
715: Begin
716:
717: X_Return_Status := OKE_API.G_RET_STS_SUCCESS;
718:
719: IF p_k_billing_event_rec.BILL_FUND_REF1 IS NOT null OR p_k_billing_event_rec.BILL_FUND_REF2 IS NOT null OR p_k_billing_event_rec.BILL_FUND_REF3 IS NOT null THEN
720:
721:

Line 729: OKE_API.SET_MESSAGE(p_app_name => g_app_name,

725:
726:
727: IF L_Value <> 'X' THEN
728:
729: OKE_API.SET_MESSAGE(p_app_name => g_app_name,
730: p_msg_name => g_invalid_value,
731: p_token1 => g_col_name_token,
732: p_token1_value => 'BILL_FUND_REF1/REF2/REF3');
733: -- notify caller of an error

Line 734: X_Return_Status := OKE_API.G_RET_STS_ERROR;

730: p_msg_name => g_invalid_value,
731: p_token1 => g_col_name_token,
732: p_token1_value => 'BILL_FUND_REF1/REF2/REF3');
733: -- notify caller of an error
734: X_Return_Status := OKE_API.G_RET_STS_ERROR;
735:
736: -- halt validation
737: RAISE G_EXCEPTION_HALT_VALIDATION;
738:

Line 753: OKE_API.SET_MESSAGE(p_app_name => g_app_name,

749:
750: WHEN OTHERS THEN
751:
752: -- store SQL error message on message stack
753: OKE_API.SET_MESSAGE(p_app_name => g_app_name,
754: p_msg_name => g_unexpected_error,
755: p_token1 => g_sqlcode_token,
756: p_token1_value=> sqlcode,
757: p_token2 => g_sqlerrm_token,

Line 760: X_Return_Status := OKE_API.G_RET_STS_UNEXP_ERROR;

756: p_token1_value=> sqlcode,
757: p_token2 => g_sqlerrm_token,
758: p_token2_value=> sqlerrm);
759: -- notify caller of an error as UNEXPETED error
760: X_Return_Status := OKE_API.G_RET_STS_UNEXP_ERROR;
761:
762: End Validate_bill_fund_ref;
763:
764: PROCEDURE Validate_currency (X_Return_Status OUT NOCOPY VARCHAR2,

Line 792: X_Return_Status := OKE_API.G_RET_STS_SUCCESS;

788: L_Multi_Currency varchar2(2);
789: l_bill_currency VARCHAR2(30);
790: Begin
791:
792: X_Return_Status := OKE_API.G_RET_STS_SUCCESS;
793:
794:
795:
796: OPEN multi_currency_billing_project(p_k_billing_event_rec.bill_project_id);

Line 802: IF ( p_k_billing_event_rec.BILL_CURRENCY_CODE IS NULL OR p_k_billing_event_rec.BILL_CURRENCY_CODE=OKE_API.G_MISS_CHAR ) THEN

798: CLOSE multi_currency_billing_project;
799:
800:
801:
802: IF ( p_k_billing_event_rec.BILL_CURRENCY_CODE IS NULL OR p_k_billing_event_rec.BILL_CURRENCY_CODE=OKE_API.G_MISS_CHAR ) THEN
803: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,
804: p_msg_name =>G_REQUIRED_VALUE,
805: p_token1 =>G_COL_NAME_TOKEN,
806: p_token1_value =>'BILL_CURRENCY_CODE');

Line 803: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,

799:
800:
801:
802: IF ( p_k_billing_event_rec.BILL_CURRENCY_CODE IS NULL OR p_k_billing_event_rec.BILL_CURRENCY_CODE=OKE_API.G_MISS_CHAR ) THEN
803: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,
804: p_msg_name =>G_REQUIRED_VALUE,
805: p_token1 =>G_COL_NAME_TOKEN,
806: p_token1_value =>'BILL_CURRENCY_CODE');
807: x_return_status := OKE_API.G_RET_STS_ERROR;

Line 807: x_return_status := OKE_API.G_RET_STS_ERROR;

803: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,
804: p_msg_name =>G_REQUIRED_VALUE,
805: p_token1 =>G_COL_NAME_TOKEN,
806: p_token1_value =>'BILL_CURRENCY_CODE');
807: x_return_status := OKE_API.G_RET_STS_ERROR;
808: END IF ;
809:
810:
811:

Line 819: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,

815:
816: IF Nvl(L_Multi_Currency,'N')= 'N' THEN
817: IF ( p_k_billing_event_rec.BILL_CURRENCY_CODE IS NOT null ) THEN
818: IF l_bill_currency <> p_k_billing_event_rec.BILL_CURRENCY_CODE THEN
819: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,
820: p_msg_name =>G_INVALID_VALUE,
821: p_token1 =>G_COL_NAME_TOKEN,
822: p_token1_value =>'BILL_CURRENCY_CODE');
823: x_return_status := OKE_API.G_RET_STS_ERROR;

Line 823: x_return_status := OKE_API.G_RET_STS_ERROR;

819: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,
820: p_msg_name =>G_INVALID_VALUE,
821: p_token1 =>G_COL_NAME_TOKEN,
822: p_token1_value =>'BILL_CURRENCY_CODE');
823: x_return_status := OKE_API.G_RET_STS_ERROR;
824:
825: END IF;
826: END IF;
827: END IF;

Line 839: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,

835: FETCH get_cur_code INTO l_value;
836: CLOSE get_cur_code;
837:
838: IF l_value <>'X' THEN
839: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,
840: p_msg_name =>G_INVALID_VALUE,
841: p_token1 =>G_COL_NAME_TOKEN,
842: p_token1_value =>'BILL_CURRENCY_CODE');
843: x_return_status := OKE_API.G_RET_STS_ERROR;

Line 843: x_return_status := OKE_API.G_RET_STS_ERROR;

839: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,
840: p_msg_name =>G_INVALID_VALUE,
841: p_token1 =>G_COL_NAME_TOKEN,
842: p_token1_value =>'BILL_CURRENCY_CODE');
843: x_return_status := OKE_API.G_RET_STS_ERROR;
844:
845: END IF;
846:
847:

Line 852: IF ( p_k_billing_event_rec.BILL_RATE_TYPE IS NULL OR p_k_billing_event_rec.BILL_RATE_TYPE=OKE_API.G_MISS_CHAR ) THEN

848: IF l_bill_currency <> p_k_billing_event_rec.BILL_CURRENCY_CODE THEN
849:
850:
851:
852: IF ( p_k_billing_event_rec.BILL_RATE_TYPE IS NULL OR p_k_billing_event_rec.BILL_RATE_TYPE=OKE_API.G_MISS_CHAR ) THEN
853: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,
854: p_msg_name =>G_REQUIRED_VALUE,
855: p_token1 =>G_COL_NAME_TOKEN,
856: p_token1_value =>'BILL_RATE_TYPE');

Line 853: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,

849:
850:
851:
852: IF ( p_k_billing_event_rec.BILL_RATE_TYPE IS NULL OR p_k_billing_event_rec.BILL_RATE_TYPE=OKE_API.G_MISS_CHAR ) THEN
853: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,
854: p_msg_name =>G_REQUIRED_VALUE,
855: p_token1 =>G_COL_NAME_TOKEN,
856: p_token1_value =>'BILL_RATE_TYPE');
857: x_return_status := OKE_API.G_RET_STS_ERROR;

Line 857: x_return_status := OKE_API.G_RET_STS_ERROR;

853: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,
854: p_msg_name =>G_REQUIRED_VALUE,
855: p_token1 =>G_COL_NAME_TOKEN,
856: p_token1_value =>'BILL_RATE_TYPE');
857: x_return_status := OKE_API.G_RET_STS_ERROR;
858: END IF ;
859:
860: IF ( p_k_billing_event_rec.BILL_RATE_DATE IS NULL OR p_k_billing_event_rec.BILL_RATE_DATE=OKE_API.G_MISS_DATE ) THEN
861: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,

Line 860: IF ( p_k_billing_event_rec.BILL_RATE_DATE IS NULL OR p_k_billing_event_rec.BILL_RATE_DATE=OKE_API.G_MISS_DATE ) THEN

856: p_token1_value =>'BILL_RATE_TYPE');
857: x_return_status := OKE_API.G_RET_STS_ERROR;
858: END IF ;
859:
860: IF ( p_k_billing_event_rec.BILL_RATE_DATE IS NULL OR p_k_billing_event_rec.BILL_RATE_DATE=OKE_API.G_MISS_DATE ) THEN
861: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,
862: p_msg_name =>G_REQUIRED_VALUE,
863: p_token1 =>G_COL_NAME_TOKEN,
864: p_token1_value =>'BILL_RATE_DATE');

Line 861: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,

857: x_return_status := OKE_API.G_RET_STS_ERROR;
858: END IF ;
859:
860: IF ( p_k_billing_event_rec.BILL_RATE_DATE IS NULL OR p_k_billing_event_rec.BILL_RATE_DATE=OKE_API.G_MISS_DATE ) THEN
861: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,
862: p_msg_name =>G_REQUIRED_VALUE,
863: p_token1 =>G_COL_NAME_TOKEN,
864: p_token1_value =>'BILL_RATE_DATE');
865: x_return_status := OKE_API.G_RET_STS_ERROR;

Line 865: x_return_status := OKE_API.G_RET_STS_ERROR;

861: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,
862: p_msg_name =>G_REQUIRED_VALUE,
863: p_token1 =>G_COL_NAME_TOKEN,
864: p_token1_value =>'BILL_RATE_DATE');
865: x_return_status := OKE_API.G_RET_STS_ERROR;
866: END IF ;
867:
868: IF Upper(p_k_billing_event_rec.BILL_RATE_TYPE) = 'USER' AND p_k_billing_event_rec.BILL_EXCHANGE_RATE IS null THEN
869: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,

Line 869: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,

865: x_return_status := OKE_API.G_RET_STS_ERROR;
866: END IF ;
867:
868: IF Upper(p_k_billing_event_rec.BILL_RATE_TYPE) = 'USER' AND p_k_billing_event_rec.BILL_EXCHANGE_RATE IS null THEN
869: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,
870: p_msg_name =>G_REQUIRED_VALUE,
871: p_token1 =>G_COL_NAME_TOKEN,
872: p_token1_value =>'BILL_EXCHANGE_RATE');
873: x_return_status := OKE_API.G_RET_STS_ERROR;

Line 873: x_return_status := OKE_API.G_RET_STS_ERROR;

869: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,
870: p_msg_name =>G_REQUIRED_VALUE,
871: p_token1 =>G_COL_NAME_TOKEN,
872: p_token1_value =>'BILL_EXCHANGE_RATE');
873: x_return_status := OKE_API.G_RET_STS_ERROR;
874: END IF;
875:
876: IF p_k_billing_event_rec.BILL_RATE_TYPE IS NOT NULL THEN
877:

Line 884: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,

880: Close RateType;
881:
882: IF L_VALUE<>'X' THEN
883:
884: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,
885: p_msg_name =>G_INVALID_VALUE,
886: p_token1 =>G_COL_NAME_TOKEN,
887: p_token1_value =>'BILL_RATE_TYPE');
888:

Line 889: x_return_status := OKE_API.G_RET_STS_ERROR;

885: p_msg_name =>G_INVALID_VALUE,
886: p_token1 =>G_COL_NAME_TOKEN,
887: p_token1_value =>'BILL_RATE_TYPE');
888:
889: x_return_status := OKE_API.G_RET_STS_ERROR;
890:
891: END IF;
892:
893: END IF;

Line 897: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,

893: END IF;
894:
895: ELSE
896: IF p_k_billing_event_rec.BILL_RATE_TYPE IS NOT NULL THEN
897: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,
898: p_msg_name =>G_INVALID_VALUE,
899: p_token1 =>G_COL_NAME_TOKEN,
900: p_token1_value =>'BILL_RATE_TYPE');
901: END IF;

Line 904: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,

900: p_token1_value =>'BILL_RATE_TYPE');
901: END IF;
902:
903: IF p_k_billing_event_rec.BILL_RATE_DATE IS NOT NULL THEN
904: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,
905: p_msg_name =>G_INVALID_VALUE,
906: p_token1 =>G_COL_NAME_TOKEN,
907: p_token1_value =>'BILL_RATE_DATE');
908: END IF;

Line 911: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,

907: p_token1_value =>'BILL_RATE_DATE');
908: END IF;
909:
910: IF p_k_billing_event_rec.BILL_EXCHANGE_RATE IS NOT NULL THEN
911: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,
912: p_msg_name =>G_INVALID_VALUE,
913: p_token1 =>G_COL_NAME_TOKEN,
914: p_token1_value =>'BILL_EXCHANGE_RATE');
915: END IF;

Line 931: OKE_API.SET_MESSAGE(p_app_name => g_app_name,

927:
928: WHEN OTHERS THEN
929:
930: -- store SQL error message on message stack
931: OKE_API.SET_MESSAGE(p_app_name => g_app_name,
932: p_msg_name => g_unexpected_error,
933: p_token1 => g_sqlcode_token,
934: p_token1_value=> sqlcode,
935: p_token2 => g_sqlerrm_token,

Line 938: X_Return_Status := OKE_API.G_RET_STS_UNEXP_ERROR;

934: p_token1_value=> sqlcode,
935: p_token2 => g_sqlerrm_token,
936: p_token2_value=> sqlerrm);
937: -- notify caller of an error as UNEXPETED error
938: X_Return_Status := OKE_API.G_RET_STS_UNEXP_ERROR;
939:
940: End Validate_currency;
941:
942:

Line 948: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,

944: BEGIN
945:
946: --validate mandatory fields
947: IF ( p_k_billing_event_rec.k_header_id IS NULL ) THEN
948: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,
949: p_msg_name =>G_REQUIRED_VALUE,
950: p_token1 =>G_COL_NAME_TOKEN,
951: p_token1_value =>'CONTRACT_HEADER_ID');
952: x_return_status := OKE_API.G_RET_STS_ERROR;

Line 952: x_return_status := OKE_API.G_RET_STS_ERROR;

948: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,
949: p_msg_name =>G_REQUIRED_VALUE,
950: p_token1 =>G_COL_NAME_TOKEN,
951: p_token1_value =>'CONTRACT_HEADER_ID');
952: x_return_status := OKE_API.G_RET_STS_ERROR;
953: END IF ;
954:
955: IF ( p_k_billing_event_rec.K_LINE_ID IS NULL ) THEN
956: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,

Line 956: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,

952: x_return_status := OKE_API.G_RET_STS_ERROR;
953: END IF ;
954:
955: IF ( p_k_billing_event_rec.K_LINE_ID IS NULL ) THEN
956: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,
957: p_msg_name =>G_REQUIRED_VALUE,
958: p_token1 =>G_COL_NAME_TOKEN,
959: p_token1_value =>'CONTRACT_LINE_ID');
960: x_return_status := OKE_API.G_RET_STS_ERROR;

Line 960: x_return_status := OKE_API.G_RET_STS_ERROR;

956: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,
957: p_msg_name =>G_REQUIRED_VALUE,
958: p_token1 =>G_COL_NAME_TOKEN,
959: p_token1_value =>'CONTRACT_LINE_ID');
960: x_return_status := OKE_API.G_RET_STS_ERROR;
961: END IF ;
962:
963: IF ( p_k_billing_event_rec.DELIVERABLE_ID IS NULL ) THEN
964: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,

Line 964: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,

960: x_return_status := OKE_API.G_RET_STS_ERROR;
961: END IF ;
962:
963: IF ( p_k_billing_event_rec.DELIVERABLE_ID IS NULL ) THEN
964: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,
965: p_msg_name =>G_REQUIRED_VALUE,
966: p_token1 =>G_COL_NAME_TOKEN,
967: p_token1_value =>'CONTRACT_DELIVERABLE_ID');
968: x_return_status := OKE_API.G_RET_STS_ERROR;

Line 968: x_return_status := OKE_API.G_RET_STS_ERROR;

964: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,
965: p_msg_name =>G_REQUIRED_VALUE,
966: p_token1 =>G_COL_NAME_TOKEN,
967: p_token1_value =>'CONTRACT_DELIVERABLE_ID');
968: x_return_status := OKE_API.G_RET_STS_ERROR;
969: END IF ;
970:
971: IF ( p_k_billing_event_rec.BILL_EVENT_TYPE IS NULL ) THEN
972: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,

Line 972: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,

968: x_return_status := OKE_API.G_RET_STS_ERROR;
969: END IF ;
970:
971: IF ( p_k_billing_event_rec.BILL_EVENT_TYPE IS NULL ) THEN
972: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,
973: p_msg_name =>G_REQUIRED_VALUE,
974: p_token1 =>G_COL_NAME_TOKEN,
975: p_token1_value =>'BILL_EVENT_TYPE');
976: x_return_status := OKE_API.G_RET_STS_ERROR;

Line 976: x_return_status := OKE_API.G_RET_STS_ERROR;

972: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,
973: p_msg_name =>G_REQUIRED_VALUE,
974: p_token1 =>G_COL_NAME_TOKEN,
975: p_token1_value =>'BILL_EVENT_TYPE');
976: x_return_status := OKE_API.G_RET_STS_ERROR;
977: END IF ;
978:
979:
980: Validate_Header_ID( x_return_status => l_return_status,

Line 983: If l_return_status <> OKE_API.G_RET_STS_SUCCESS Then

979:
980: Validate_Header_ID( x_return_status => l_return_status,
981: p_k_billing_event_rec => p_k_billing_event_rec);
982:
983: If l_return_status <> OKE_API.G_RET_STS_SUCCESS Then
984: If x_return_status <> OKE_API.G_RET_STS_UNEXP_ERROR Then
985: x_return_status := l_return_status;
986: End If;
987: End If;

Line 984: If x_return_status <> OKE_API.G_RET_STS_UNEXP_ERROR Then

980: Validate_Header_ID( x_return_status => l_return_status,
981: p_k_billing_event_rec => p_k_billing_event_rec);
982:
983: If l_return_status <> OKE_API.G_RET_STS_SUCCESS Then
984: If x_return_status <> OKE_API.G_RET_STS_UNEXP_ERROR Then
985: x_return_status := l_return_status;
986: End If;
987: End If;
988:

Line 993: If l_return_status <> OKE_API.G_RET_STS_SUCCESS Then

989:
990: Validate_Line_ID( x_return_status => l_return_status,
991: p_k_billing_event_rec => p_k_billing_event_rec);
992:
993: If l_return_status <> OKE_API.G_RET_STS_SUCCESS Then
994: If x_return_status <> OKE_API.G_RET_STS_UNEXP_ERROR Then
995: x_return_status := l_return_status;
996: End If;
997: End If;

Line 994: If x_return_status <> OKE_API.G_RET_STS_UNEXP_ERROR Then

990: Validate_Line_ID( x_return_status => l_return_status,
991: p_k_billing_event_rec => p_k_billing_event_rec);
992:
993: If l_return_status <> OKE_API.G_RET_STS_SUCCESS Then
994: If x_return_status <> OKE_API.G_RET_STS_UNEXP_ERROR Then
995: x_return_status := l_return_status;
996: End If;
997: End If;
998:

Line 1002: If l_return_status <> OKE_API.G_RET_STS_SUCCESS Then

998:
999: Validate_Deliverable_Id( x_return_status => l_return_status,
1000: p_k_billing_event_rec => p_k_billing_event_rec);
1001:
1002: If l_return_status <> OKE_API.G_RET_STS_SUCCESS Then
1003: If x_return_status <> OKE_API.G_RET_STS_UNEXP_ERROR Then
1004: x_return_status := l_return_status;
1005: End If;
1006: End If;

Line 1003: If x_return_status <> OKE_API.G_RET_STS_UNEXP_ERROR Then

999: Validate_Deliverable_Id( x_return_status => l_return_status,
1000: p_k_billing_event_rec => p_k_billing_event_rec);
1001:
1002: If l_return_status <> OKE_API.G_RET_STS_SUCCESS Then
1003: If x_return_status <> OKE_API.G_RET_STS_UNEXP_ERROR Then
1004: x_return_status := l_return_status;
1005: End If;
1006: End If;
1007:

Line 1011: If l_return_status <> OKE_API.G_RET_STS_SUCCESS Then

1007:
1008: Validate_Project_ID( x_return_status => l_return_status,
1009: p_k_billing_event_rec => p_k_billing_event_rec);
1010:
1011: If l_return_status <> OKE_API.G_RET_STS_SUCCESS Then
1012: If x_return_status <> OKE_API.G_RET_STS_UNEXP_ERROR Then
1013: x_return_status := l_return_status;
1014: End If;
1015: End If;

Line 1012: If x_return_status <> OKE_API.G_RET_STS_UNEXP_ERROR Then

1008: Validate_Project_ID( x_return_status => l_return_status,
1009: p_k_billing_event_rec => p_k_billing_event_rec);
1010:
1011: If l_return_status <> OKE_API.G_RET_STS_SUCCESS Then
1012: If x_return_status <> OKE_API.G_RET_STS_UNEXP_ERROR Then
1013: x_return_status := l_return_status;
1014: End If;
1015: End If;
1016:

Line 1020: If l_return_status <> OKE_API.G_RET_STS_SUCCESS Then

1016:
1017: Validate_Task_ID ( x_return_status => l_return_status,
1018: p_k_billing_event_rec => p_k_billing_event_rec);
1019:
1020: If l_return_status <> OKE_API.G_RET_STS_SUCCESS Then
1021: If x_return_status <> OKE_API.G_RET_STS_UNEXP_ERROR Then
1022: x_return_status := l_return_status;
1023: End If;
1024: End If;

Line 1021: If x_return_status <> OKE_API.G_RET_STS_UNEXP_ERROR Then

1017: Validate_Task_ID ( x_return_status => l_return_status,
1018: p_k_billing_event_rec => p_k_billing_event_rec);
1019:
1020: If l_return_status <> OKE_API.G_RET_STS_SUCCESS Then
1021: If x_return_status <> OKE_API.G_RET_STS_UNEXP_ERROR Then
1022: x_return_status := l_return_status;
1023: End If;
1024: End If;
1025:

Line 1029: If l_return_status <> OKE_API.G_RET_STS_SUCCESS Then

1025:
1026: Validate_BILL_EVENT_TYPE ( x_return_status => l_return_status,
1027: p_k_billing_event_rec => p_k_billing_event_rec);
1028:
1029: If l_return_status <> OKE_API.G_RET_STS_SUCCESS Then
1030: If x_return_status <> OKE_API.G_RET_STS_UNEXP_ERROR Then
1031: x_return_status := l_return_status;
1032: End If;
1033: End If;

Line 1030: If x_return_status <> OKE_API.G_RET_STS_UNEXP_ERROR Then

1026: Validate_BILL_EVENT_TYPE ( x_return_status => l_return_status,
1027: p_k_billing_event_rec => p_k_billing_event_rec);
1028:
1029: If l_return_status <> OKE_API.G_RET_STS_SUCCESS Then
1030: If x_return_status <> OKE_API.G_RET_STS_UNEXP_ERROR Then
1031: x_return_status := l_return_status;
1032: End If;
1033: End If;
1034:

Line 1038: If l_return_status <> OKE_API.G_RET_STS_SUCCESS Then

1034:
1035: Validate_item ( x_return_status => l_return_status,
1036: p_k_billing_event_rec => p_k_billing_event_rec);
1037:
1038: If l_return_status <> OKE_API.G_RET_STS_SUCCESS Then
1039: If x_return_status <> OKE_API.G_RET_STS_UNEXP_ERROR Then
1040: x_return_status := l_return_status;
1041: End If;
1042: End If;

Line 1039: If x_return_status <> OKE_API.G_RET_STS_UNEXP_ERROR Then

1035: Validate_item ( x_return_status => l_return_status,
1036: p_k_billing_event_rec => p_k_billing_event_rec);
1037:
1038: If l_return_status <> OKE_API.G_RET_STS_SUCCESS Then
1039: If x_return_status <> OKE_API.G_RET_STS_UNEXP_ERROR Then
1040: x_return_status := l_return_status;
1041: End If;
1042: End If;
1043:

Line 1047: If l_return_status <> OKE_API.G_RET_STS_SUCCESS Then

1043:
1044: Validate_CHANGE_REQUEST_ID( x_return_status => l_return_status,
1045: p_k_billing_event_rec => p_k_billing_event_rec);
1046:
1047: If l_return_status <> OKE_API.G_RET_STS_SUCCESS Then
1048: If x_return_status <> OKE_API.G_RET_STS_UNEXP_ERROR Then
1049: x_return_status := l_return_status;
1050: End If;
1051: End If;

Line 1048: If x_return_status <> OKE_API.G_RET_STS_UNEXP_ERROR Then

1044: Validate_CHANGE_REQUEST_ID( x_return_status => l_return_status,
1045: p_k_billing_event_rec => p_k_billing_event_rec);
1046:
1047: If l_return_status <> OKE_API.G_RET_STS_SUCCESS Then
1048: If x_return_status <> OKE_API.G_RET_STS_UNEXP_ERROR Then
1049: x_return_status := l_return_status;
1050: End If;
1051: End If;
1052:

Line 1056: If l_return_status <> OKE_API.G_RET_STS_SUCCESS Then

1052:
1053: Validate_bill_org ( x_return_status => l_return_status,
1054: p_k_billing_event_rec => p_k_billing_event_rec);
1055:
1056: If l_return_status <> OKE_API.G_RET_STS_SUCCESS Then
1057: If x_return_status <> OKE_API.G_RET_STS_UNEXP_ERROR Then
1058: x_return_status := l_return_status;
1059: End If;
1060: End If;

Line 1057: If x_return_status <> OKE_API.G_RET_STS_UNEXP_ERROR Then

1053: Validate_bill_org ( x_return_status => l_return_status,
1054: p_k_billing_event_rec => p_k_billing_event_rec);
1055:
1056: If l_return_status <> OKE_API.G_RET_STS_SUCCESS Then
1057: If x_return_status <> OKE_API.G_RET_STS_UNEXP_ERROR Then
1058: x_return_status := l_return_status;
1059: End If;
1060: End If;
1061:

Line 1065: If l_return_status <> OKE_API.G_RET_STS_SUCCESS Then

1061:
1062: Validate_bill_fund_ref( x_return_status => l_return_status,
1063: p_k_billing_event_rec => p_k_billing_event_rec);
1064:
1065: If l_return_status <> OKE_API.G_RET_STS_SUCCESS Then
1066: If x_return_status <> OKE_API.G_RET_STS_UNEXP_ERROR Then
1067: x_return_status := l_return_status;
1068: End If;
1069: End If;

Line 1066: If x_return_status <> OKE_API.G_RET_STS_UNEXP_ERROR Then

1062: Validate_bill_fund_ref( x_return_status => l_return_status,
1063: p_k_billing_event_rec => p_k_billing_event_rec);
1064:
1065: If l_return_status <> OKE_API.G_RET_STS_SUCCESS Then
1066: If x_return_status <> OKE_API.G_RET_STS_UNEXP_ERROR Then
1067: x_return_status := l_return_status;
1068: End If;
1069: End If;
1070:

Line 1074: If l_return_status <> OKE_API.G_RET_STS_SUCCESS Then

1070:
1071: Validate_currency ( x_return_status => l_return_status,
1072: p_k_billing_event_rec => p_k_billing_event_rec);
1073:
1074: If l_return_status <> OKE_API.G_RET_STS_SUCCESS Then
1075: If x_return_status <> OKE_API.G_RET_STS_UNEXP_ERROR Then
1076: x_return_status := l_return_status;
1077: End If;
1078: End If;

Line 1075: If x_return_status <> OKE_API.G_RET_STS_UNEXP_ERROR Then

1071: Validate_currency ( x_return_status => l_return_status,
1072: p_k_billing_event_rec => p_k_billing_event_rec);
1073:
1074: If l_return_status <> OKE_API.G_RET_STS_SUCCESS Then
1075: If x_return_status <> OKE_API.G_RET_STS_UNEXP_ERROR Then
1076: x_return_status := l_return_status;
1077: End If;
1078: End If;
1079:

Line 1085: OKE_API.SET_MESSAGE(

1081:
1082: exception
1083: WHEN OTHERS THEN
1084: -- store SQL error message on message stack
1085: OKE_API.SET_MESSAGE(
1086: p_app_name =>g_app_name,
1087: p_msg_name =>G_UNEXPECTED_ERROR,
1088: p_token1 =>G_SQLCODE_TOKEN,
1089: p_token1_value =>SQLCODE,

Line 1093: x_return_status := OKE_API.G_RET_STS_UNEXP_ERROR;

1089: p_token1_value =>SQLCODE,
1090: p_token2 =>G_SQLERRM_TOKEN,
1091: p_token2_value =>SQLERRM);
1092:
1093: x_return_status := OKE_API.G_RET_STS_UNEXP_ERROR;
1094:
1095: RETURN(x_return_status);
1096:
1097: END validate_billing_attributes;

Line 1170: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

1166:
1167: END Recalculate_price;
1168:
1169: PROCEDURE create_k_billing_event(p_api_version IN NUMBER,
1170: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
1171: p_k_billing_event_rec IN OKE_BILLING_EVENT_PUB.k_billing_event_rec_type,
1172: x_k_billing_event_rec OUT NOCOPY OKE_BILLING_EVENT_PUB.k_billing_event_rec_type,
1173: x_return_status OUT NOCOPY VARCHAR2,
1174: x_msg_count OUT NOCOPY NUMBER,

Line 1181: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

1177: IS
1178: l_event_id NUMBER;
1179: l_api_name CONSTANT VARCHAR2(30) := 'create_k_billing_event';
1180: l_api_version CONSTANT NUMBER := 1.0;
1181: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
1182: l_k_billing_event_rec OKE_BILLING_EVENT_PUB.k_billing_event_rec_type;
1183: l_bill_unit_price NUMBER;
1184: l_REVENUE_AMOUNT NUMBER;
1185: l_exchange_rate NUMBER;

Line 1280: IF l_k_billing_event_rec.deliverable_id<> OKE_API.G_MISS_NUM then

1276:
1277:
1278: BEGIN
1279:
1280: IF l_k_billing_event_rec.deliverable_id<> OKE_API.G_MISS_NUM then
1281: Open Dlv_C ( l_k_billing_event_rec.deliverable_id );
1282: Fetch Dlv_C Into L_Project_Id, L_Line_Id, L_Inventory_Org_Id, L_Item_Id, L_Currency_Code, L_Quantity, L_Unit_Price, L_Deliverable_Description;
1283: Close Dlv_C;
1284:

Line 1302: IF l_k_billing_event_rec.deliverable_id<> OKE_API.G_MISS_NUM then

1298: END IF;
1299:
1300:
1301: -- BILL_QUANTITY
1302: IF l_k_billing_event_rec.deliverable_id<> OKE_API.G_MISS_NUM then
1303: Open Qty_C ( l_k_billing_event_rec.deliverable_id );
1304: Fetch Qty_C Into L_Billed_Quantity;
1305: Close Qty_C;
1306:

Line 1326: IF l_k_billing_event_rec.BILLING_EVENT_ID = OKE_API.G_MISS_NUM THEN

1322: Close BillLading;
1323:
1324: END IF;
1325:
1326: IF l_k_billing_event_rec.BILLING_EVENT_ID = OKE_API.G_MISS_NUM THEN
1327: l_k_billing_event_rec.BILLING_EVENT_ID := NULL;
1328: END IF;
1329:
1330: IF l_k_billing_event_rec.CREATION_DATE = OKE_API.G_MISS_DATE THEN

Line 1330: IF l_k_billing_event_rec.CREATION_DATE = OKE_API.G_MISS_DATE THEN

1326: IF l_k_billing_event_rec.BILLING_EVENT_ID = OKE_API.G_MISS_NUM THEN
1327: l_k_billing_event_rec.BILLING_EVENT_ID := NULL;
1328: END IF;
1329:
1330: IF l_k_billing_event_rec.CREATION_DATE = OKE_API.G_MISS_DATE THEN
1331: l_k_billing_event_rec.CREATION_DATE := sysdate;
1332: END IF;
1333:
1334: IF l_k_billing_event_rec.CREATED_BY = OKE_API.G_MISS_NUM THEN

Line 1334: IF l_k_billing_event_rec.CREATED_BY = OKE_API.G_MISS_NUM THEN

1330: IF l_k_billing_event_rec.CREATION_DATE = OKE_API.G_MISS_DATE THEN
1331: l_k_billing_event_rec.CREATION_DATE := sysdate;
1332: END IF;
1333:
1334: IF l_k_billing_event_rec.CREATED_BY = OKE_API.G_MISS_NUM THEN
1335: l_k_billing_event_rec.CREATED_BY := Fnd_Profile.Value('USER_ID');
1336: END IF;
1337:
1338: IF l_k_billing_event_rec.LAST_UPDATE_DATE = OKE_API.G_MISS_DATE THEN

Line 1338: IF l_k_billing_event_rec.LAST_UPDATE_DATE = OKE_API.G_MISS_DATE THEN

1334: IF l_k_billing_event_rec.CREATED_BY = OKE_API.G_MISS_NUM THEN
1335: l_k_billing_event_rec.CREATED_BY := Fnd_Profile.Value('USER_ID');
1336: END IF;
1337:
1338: IF l_k_billing_event_rec.LAST_UPDATE_DATE = OKE_API.G_MISS_DATE THEN
1339: l_k_billing_event_rec.LAST_UPDATE_DATE := sysdate;
1340: END IF;
1341:
1342: IF l_k_billing_event_rec.LAST_UPDATED_BY = OKE_API.G_MISS_NUM THEN

Line 1342: IF l_k_billing_event_rec.LAST_UPDATED_BY = OKE_API.G_MISS_NUM THEN

1338: IF l_k_billing_event_rec.LAST_UPDATE_DATE = OKE_API.G_MISS_DATE THEN
1339: l_k_billing_event_rec.LAST_UPDATE_DATE := sysdate;
1340: END IF;
1341:
1342: IF l_k_billing_event_rec.LAST_UPDATED_BY = OKE_API.G_MISS_NUM THEN
1343: l_k_billing_event_rec.LAST_UPDATED_BY := Fnd_Profile.Value('USER_ID');
1344:
1345: END IF;
1346:

Line 1347: IF l_k_billing_event_rec.LAST_UPDATE_LOGIN = OKE_API.G_MISS_NUM THEN

1343: l_k_billing_event_rec.LAST_UPDATED_BY := Fnd_Profile.Value('USER_ID');
1344:
1345: END IF;
1346:
1347: IF l_k_billing_event_rec.LAST_UPDATE_LOGIN = OKE_API.G_MISS_NUM THEN
1348: l_k_billing_event_rec.LAST_UPDATE_LOGIN := Fnd_Profile.Value('LOGIN_ID');
1349: END IF;
1350:
1351: IF l_k_billing_event_rec.K_HEADER_ID = OKE_API.G_MISS_NUM THEN

Line 1351: IF l_k_billing_event_rec.K_HEADER_ID = OKE_API.G_MISS_NUM THEN

1347: IF l_k_billing_event_rec.LAST_UPDATE_LOGIN = OKE_API.G_MISS_NUM THEN
1348: l_k_billing_event_rec.LAST_UPDATE_LOGIN := Fnd_Profile.Value('LOGIN_ID');
1349: END IF;
1350:
1351: IF l_k_billing_event_rec.K_HEADER_ID = OKE_API.G_MISS_NUM THEN
1352: l_k_billing_event_rec.K_HEADER_ID := NULL;
1353: END IF;
1354:
1355: IF l_k_billing_event_rec.K_LINE_ID = OKE_API.G_MISS_NUM THEN

Line 1355: IF l_k_billing_event_rec.K_LINE_ID = OKE_API.G_MISS_NUM THEN

1351: IF l_k_billing_event_rec.K_HEADER_ID = OKE_API.G_MISS_NUM THEN
1352: l_k_billing_event_rec.K_HEADER_ID := NULL;
1353: END IF;
1354:
1355: IF l_k_billing_event_rec.K_LINE_ID = OKE_API.G_MISS_NUM THEN
1356: l_k_billing_event_rec.K_LINE_ID := L_Line_Id;
1357: END IF;
1358:
1359: IF l_k_billing_event_rec.DELIVERABLE_ID = OKE_API.G_MISS_NUM THEN

Line 1359: IF l_k_billing_event_rec.DELIVERABLE_ID = OKE_API.G_MISS_NUM THEN

1355: IF l_k_billing_event_rec.K_LINE_ID = OKE_API.G_MISS_NUM THEN
1356: l_k_billing_event_rec.K_LINE_ID := L_Line_Id;
1357: END IF;
1358:
1359: IF l_k_billing_event_rec.DELIVERABLE_ID = OKE_API.G_MISS_NUM THEN
1360: l_k_billing_event_rec.DELIVERABLE_ID:= NULL;
1361: END IF;
1362:
1363: IF l_k_billing_event_rec.BILL_EVENT_DATE = OKE_API.G_MISS_DATE THEN

Line 1363: IF l_k_billing_event_rec.BILL_EVENT_DATE = OKE_API.G_MISS_DATE THEN

1359: IF l_k_billing_event_rec.DELIVERABLE_ID = OKE_API.G_MISS_NUM THEN
1360: l_k_billing_event_rec.DELIVERABLE_ID:= NULL;
1361: END IF;
1362:
1363: IF l_k_billing_event_rec.BILL_EVENT_DATE = OKE_API.G_MISS_DATE THEN
1364: l_k_billing_event_rec.BILL_EVENT_DATE := sysdate;
1365: END IF;
1366:
1367: IF l_k_billing_event_rec.BILL_EVENT_TYPE = OKE_API.G_MISS_CHAR THEN

Line 1367: IF l_k_billing_event_rec.BILL_EVENT_TYPE = OKE_API.G_MISS_CHAR THEN

1363: IF l_k_billing_event_rec.BILL_EVENT_DATE = OKE_API.G_MISS_DATE THEN
1364: l_k_billing_event_rec.BILL_EVENT_DATE := sysdate;
1365: END IF;
1366:
1367: IF l_k_billing_event_rec.BILL_EVENT_TYPE = OKE_API.G_MISS_CHAR THEN
1368: l_k_billing_event_rec.BILL_EVENT_TYPE := NULL;
1369: END IF;
1370:
1371: IF l_k_billing_event_rec.PA_EVENT_ID = OKE_API.G_MISS_NUM THEN

Line 1371: IF l_k_billing_event_rec.PA_EVENT_ID = OKE_API.G_MISS_NUM THEN

1367: IF l_k_billing_event_rec.BILL_EVENT_TYPE = OKE_API.G_MISS_CHAR THEN
1368: l_k_billing_event_rec.BILL_EVENT_TYPE := NULL;
1369: END IF;
1370:
1371: IF l_k_billing_event_rec.PA_EVENT_ID = OKE_API.G_MISS_NUM THEN
1372: l_k_billing_event_rec.PA_EVENT_ID := NULL;
1373: END IF;
1374:
1375: IF l_k_billing_event_rec.BILL_ITEM_ID = OKE_API.G_MISS_NUM THEN

Line 1375: IF l_k_billing_event_rec.BILL_ITEM_ID = OKE_API.G_MISS_NUM THEN

1371: IF l_k_billing_event_rec.PA_EVENT_ID = OKE_API.G_MISS_NUM THEN
1372: l_k_billing_event_rec.PA_EVENT_ID := NULL;
1373: END IF;
1374:
1375: IF l_k_billing_event_rec.BILL_ITEM_ID = OKE_API.G_MISS_NUM THEN
1376: l_k_billing_event_rec.BILL_ITEM_ID := L_Item_Id;
1377: END IF;
1378:
1379: IF l_k_billing_event_rec.BILL_LINE_ID = OKE_API.G_MISS_NUM THEN

Line 1379: IF l_k_billing_event_rec.BILL_LINE_ID = OKE_API.G_MISS_NUM THEN

1375: IF l_k_billing_event_rec.BILL_ITEM_ID = OKE_API.G_MISS_NUM THEN
1376: l_k_billing_event_rec.BILL_ITEM_ID := L_Item_Id;
1377: END IF;
1378:
1379: IF l_k_billing_event_rec.BILL_LINE_ID = OKE_API.G_MISS_NUM THEN
1380: l_k_billing_event_rec.BILL_LINE_ID := L_Line_Id;
1381: END IF;
1382:
1383: IF l_k_billing_event_rec.BILL_CHG_REQ_ID = OKE_API.G_MISS_NUM THEN

Line 1383: IF l_k_billing_event_rec.BILL_CHG_REQ_ID = OKE_API.G_MISS_NUM THEN

1379: IF l_k_billing_event_rec.BILL_LINE_ID = OKE_API.G_MISS_NUM THEN
1380: l_k_billing_event_rec.BILL_LINE_ID := L_Line_Id;
1381: END IF;
1382:
1383: IF l_k_billing_event_rec.BILL_CHG_REQ_ID = OKE_API.G_MISS_NUM THEN
1384: l_k_billing_event_rec.BILL_CHG_REQ_ID := NULL;
1385: END IF;
1386:
1387: IF l_k_billing_event_rec.BILL_PROJECT_ID = OKE_API.G_MISS_NUM THEN

Line 1387: IF l_k_billing_event_rec.BILL_PROJECT_ID = OKE_API.G_MISS_NUM THEN

1383: IF l_k_billing_event_rec.BILL_CHG_REQ_ID = OKE_API.G_MISS_NUM THEN
1384: l_k_billing_event_rec.BILL_CHG_REQ_ID := NULL;
1385: END IF;
1386:
1387: IF l_k_billing_event_rec.BILL_PROJECT_ID = OKE_API.G_MISS_NUM THEN
1388: l_k_billing_event_rec.BILL_PROJECT_ID := L_Project_Id;
1389: END IF;
1390:
1391: IF l_k_billing_event_rec.BILL_TASK_ID = OKE_API.G_MISS_NUM THEN

Line 1391: IF l_k_billing_event_rec.BILL_TASK_ID = OKE_API.G_MISS_NUM THEN

1387: IF l_k_billing_event_rec.BILL_PROJECT_ID = OKE_API.G_MISS_NUM THEN
1388: l_k_billing_event_rec.BILL_PROJECT_ID := L_Project_Id;
1389: END IF;
1390:
1391: IF l_k_billing_event_rec.BILL_TASK_ID = OKE_API.G_MISS_NUM THEN
1392: l_k_billing_event_rec.BILL_TASK_ID := NULL;
1393: END IF;
1394:
1395: IF l_k_billing_event_rec.BILL_ORGANIZATION_ID = OKE_API.G_MISS_NUM THEN

Line 1395: IF l_k_billing_event_rec.BILL_ORGANIZATION_ID = OKE_API.G_MISS_NUM THEN

1391: IF l_k_billing_event_rec.BILL_TASK_ID = OKE_API.G_MISS_NUM THEN
1392: l_k_billing_event_rec.BILL_TASK_ID := NULL;
1393: END IF;
1394:
1395: IF l_k_billing_event_rec.BILL_ORGANIZATION_ID = OKE_API.G_MISS_NUM THEN
1396: l_k_billing_event_rec.BILL_ORGANIZATION_ID := L_Org_Id;
1397: END IF;
1398:
1399: IF l_k_billing_event_rec.BILL_FUND_REF1 = OKE_API.G_MISS_CHAR THEN

Line 1399: IF l_k_billing_event_rec.BILL_FUND_REF1 = OKE_API.G_MISS_CHAR THEN

1395: IF l_k_billing_event_rec.BILL_ORGANIZATION_ID = OKE_API.G_MISS_NUM THEN
1396: l_k_billing_event_rec.BILL_ORGANIZATION_ID := L_Org_Id;
1397: END IF;
1398:
1399: IF l_k_billing_event_rec.BILL_FUND_REF1 = OKE_API.G_MISS_CHAR THEN
1400: l_k_billing_event_rec.BILL_FUND_REF1 := NULL;
1401: END IF;
1402:
1403: IF l_k_billing_event_rec.BILL_FUND_REF2 = OKE_API.G_MISS_CHAR THEN

Line 1403: IF l_k_billing_event_rec.BILL_FUND_REF2 = OKE_API.G_MISS_CHAR THEN

1399: IF l_k_billing_event_rec.BILL_FUND_REF1 = OKE_API.G_MISS_CHAR THEN
1400: l_k_billing_event_rec.BILL_FUND_REF1 := NULL;
1401: END IF;
1402:
1403: IF l_k_billing_event_rec.BILL_FUND_REF2 = OKE_API.G_MISS_CHAR THEN
1404: l_k_billing_event_rec.BILL_FUND_REF2 := NULL;
1405: END IF;
1406:
1407: IF l_k_billing_event_rec.BILL_FUND_REF3 = OKE_API.G_MISS_CHAR THEN

Line 1407: IF l_k_billing_event_rec.BILL_FUND_REF3 = OKE_API.G_MISS_CHAR THEN

1403: IF l_k_billing_event_rec.BILL_FUND_REF2 = OKE_API.G_MISS_CHAR THEN
1404: l_k_billing_event_rec.BILL_FUND_REF2 := NULL;
1405: END IF;
1406:
1407: IF l_k_billing_event_rec.BILL_FUND_REF3 = OKE_API.G_MISS_CHAR THEN
1408: l_k_billing_event_rec.BILL_FUND_REF3 := NULL;
1409: END IF;
1410:
1411: IF l_k_billing_event_rec.BILL_BILL_OF_LADING = OKE_API.G_MISS_CHAR THEN

Line 1411: IF l_k_billing_event_rec.BILL_BILL_OF_LADING = OKE_API.G_MISS_CHAR THEN

1407: IF l_k_billing_event_rec.BILL_FUND_REF3 = OKE_API.G_MISS_CHAR THEN
1408: l_k_billing_event_rec.BILL_FUND_REF3 := NULL;
1409: END IF;
1410:
1411: IF l_k_billing_event_rec.BILL_BILL_OF_LADING = OKE_API.G_MISS_CHAR THEN
1412: l_k_billing_event_rec.BILL_BILL_OF_LADING := L_Bill_Lading;
1413: END IF;
1414:
1415: IF l_k_billing_event_rec.BILL_SERIAL_NUM = OKE_API.G_MISS_CHAR THEN

Line 1415: IF l_k_billing_event_rec.BILL_SERIAL_NUM = OKE_API.G_MISS_CHAR THEN

1411: IF l_k_billing_event_rec.BILL_BILL_OF_LADING = OKE_API.G_MISS_CHAR THEN
1412: l_k_billing_event_rec.BILL_BILL_OF_LADING := L_Bill_Lading;
1413: END IF;
1414:
1415: IF l_k_billing_event_rec.BILL_SERIAL_NUM = OKE_API.G_MISS_CHAR THEN
1416: l_k_billing_event_rec.BILL_SERIAL_NUM:= NULL;
1417: END IF;
1418:
1419: IF l_k_billing_event_rec.BILL_CURRENCY_CODE = OKE_API.G_MISS_CHAR THEN

Line 1419: IF l_k_billing_event_rec.BILL_CURRENCY_CODE = OKE_API.G_MISS_CHAR THEN

1415: IF l_k_billing_event_rec.BILL_SERIAL_NUM = OKE_API.G_MISS_CHAR THEN
1416: l_k_billing_event_rec.BILL_SERIAL_NUM:= NULL;
1417: END IF;
1418:
1419: IF l_k_billing_event_rec.BILL_CURRENCY_CODE = OKE_API.G_MISS_CHAR THEN
1420: l_k_billing_event_rec.BILL_CURRENCY_CODE:= L_Currency_Code;
1421: END IF;
1422:
1423: IF l_k_billing_event_rec.BILL_RATE_TYPE = OKE_API.G_MISS_CHAR THEN

Line 1423: IF l_k_billing_event_rec.BILL_RATE_TYPE = OKE_API.G_MISS_CHAR THEN

1419: IF l_k_billing_event_rec.BILL_CURRENCY_CODE = OKE_API.G_MISS_CHAR THEN
1420: l_k_billing_event_rec.BILL_CURRENCY_CODE:= L_Currency_Code;
1421: END IF;
1422:
1423: IF l_k_billing_event_rec.BILL_RATE_TYPE = OKE_API.G_MISS_CHAR THEN
1424: l_k_billing_event_rec.BILL_RATE_TYPE:= NULL;
1425: END IF;
1426:
1427: IF l_k_billing_event_rec.BILL_RATE_DATE = OKE_API.G_MISS_DATE THEN

Line 1427: IF l_k_billing_event_rec.BILL_RATE_DATE = OKE_API.G_MISS_DATE THEN

1423: IF l_k_billing_event_rec.BILL_RATE_TYPE = OKE_API.G_MISS_CHAR THEN
1424: l_k_billing_event_rec.BILL_RATE_TYPE:= NULL;
1425: END IF;
1426:
1427: IF l_k_billing_event_rec.BILL_RATE_DATE = OKE_API.G_MISS_DATE THEN
1428: l_k_billing_event_rec.BILL_RATE_DATE:= NULL;
1429: END IF;
1430:
1431: IF l_k_billing_event_rec.BILL_EXCHANGE_RATE = OKE_API.G_MISS_NUM THEN

Line 1431: IF l_k_billing_event_rec.BILL_EXCHANGE_RATE = OKE_API.G_MISS_NUM THEN

1427: IF l_k_billing_event_rec.BILL_RATE_DATE = OKE_API.G_MISS_DATE THEN
1428: l_k_billing_event_rec.BILL_RATE_DATE:= NULL;
1429: END IF;
1430:
1431: IF l_k_billing_event_rec.BILL_EXCHANGE_RATE = OKE_API.G_MISS_NUM THEN
1432: l_k_billing_event_rec.BILL_EXCHANGE_RATE:= NULL;
1433: END IF;
1434:
1435: IF l_k_billing_event_rec.BILL_DESCRIPTION = OKE_API.G_MISS_CHAR THEN

Line 1435: IF l_k_billing_event_rec.BILL_DESCRIPTION = OKE_API.G_MISS_CHAR THEN

1431: IF l_k_billing_event_rec.BILL_EXCHANGE_RATE = OKE_API.G_MISS_NUM THEN
1432: l_k_billing_event_rec.BILL_EXCHANGE_RATE:= NULL;
1433: END IF;
1434:
1435: IF l_k_billing_event_rec.BILL_DESCRIPTION = OKE_API.G_MISS_CHAR THEN
1436:
1437: -- Default description
1438:
1439: IF l_deliverable_description IS NOT NULL THEN

Line 1447: IF l_k_billing_event_rec.BILL_QUANTITY = OKE_API.G_MISS_NUM THEN

1443: END IF;
1444:
1445: END IF;
1446:
1447: IF l_k_billing_event_rec.BILL_QUANTITY = OKE_API.G_MISS_NUM THEN
1448: l_k_billing_event_rec.BILL_QUANTITY:= L_Bill_Quantity;
1449: END IF;
1450:
1451: IF l_k_billing_event_rec.BILL_UNIT_PRICE = OKE_API.G_MISS_NUM THEN

Line 1451: IF l_k_billing_event_rec.BILL_UNIT_PRICE = OKE_API.G_MISS_NUM THEN

1447: IF l_k_billing_event_rec.BILL_QUANTITY = OKE_API.G_MISS_NUM THEN
1448: l_k_billing_event_rec.BILL_QUANTITY:= L_Bill_Quantity;
1449: END IF;
1450:
1451: IF l_k_billing_event_rec.BILL_UNIT_PRICE = OKE_API.G_MISS_NUM THEN
1452: l_k_billing_event_rec.BILL_UNIT_PRICE:= null;
1453: END IF;
1454:
1455: IF l_k_billing_event_rec.REVENUE_AMOUNT = OKE_API.G_MISS_NUM THEN

Line 1455: IF l_k_billing_event_rec.REVENUE_AMOUNT = OKE_API.G_MISS_NUM THEN

1451: IF l_k_billing_event_rec.BILL_UNIT_PRICE = OKE_API.G_MISS_NUM THEN
1452: l_k_billing_event_rec.BILL_UNIT_PRICE:= null;
1453: END IF;
1454:
1455: IF l_k_billing_event_rec.REVENUE_AMOUNT = OKE_API.G_MISS_NUM THEN
1456: l_k_billing_event_rec.REVENUE_AMOUNT:=null ;
1457: END IF;
1458:
1459: IF l_k_billing_event_rec.ATTRIBUTE_CATEGORY = OKE_API.G_MISS_CHAR THEN

Line 1459: IF l_k_billing_event_rec.ATTRIBUTE_CATEGORY = OKE_API.G_MISS_CHAR THEN

1455: IF l_k_billing_event_rec.REVENUE_AMOUNT = OKE_API.G_MISS_NUM THEN
1456: l_k_billing_event_rec.REVENUE_AMOUNT:=null ;
1457: END IF;
1458:
1459: IF l_k_billing_event_rec.ATTRIBUTE_CATEGORY = OKE_API.G_MISS_CHAR THEN
1460: l_k_billing_event_rec.ATTRIBUTE_CATEGORY:= NULL;
1461: END IF;
1462:
1463: IF l_k_billing_event_rec.ATTRIBUTE1 = OKE_API.G_MISS_CHAR THEN

Line 1463: IF l_k_billing_event_rec.ATTRIBUTE1 = OKE_API.G_MISS_CHAR THEN

1459: IF l_k_billing_event_rec.ATTRIBUTE_CATEGORY = OKE_API.G_MISS_CHAR THEN
1460: l_k_billing_event_rec.ATTRIBUTE_CATEGORY:= NULL;
1461: END IF;
1462:
1463: IF l_k_billing_event_rec.ATTRIBUTE1 = OKE_API.G_MISS_CHAR THEN
1464: l_k_billing_event_rec.ATTRIBUTE1:= NULL;
1465: END IF;
1466:
1467: IF l_k_billing_event_rec.ATTRIBUTE2 = OKE_API.G_MISS_CHAR THEN

Line 1467: IF l_k_billing_event_rec.ATTRIBUTE2 = OKE_API.G_MISS_CHAR THEN

1463: IF l_k_billing_event_rec.ATTRIBUTE1 = OKE_API.G_MISS_CHAR THEN
1464: l_k_billing_event_rec.ATTRIBUTE1:= NULL;
1465: END IF;
1466:
1467: IF l_k_billing_event_rec.ATTRIBUTE2 = OKE_API.G_MISS_CHAR THEN
1468: l_k_billing_event_rec.ATTRIBUTE2:= NULL;
1469: END IF;
1470: IF l_k_billing_event_rec.ATTRIBUTE3 = OKE_API.G_MISS_CHAR THEN
1471: l_k_billing_event_rec.ATTRIBUTE3:= NULL;

Line 1470: IF l_k_billing_event_rec.ATTRIBUTE3 = OKE_API.G_MISS_CHAR THEN

1466:
1467: IF l_k_billing_event_rec.ATTRIBUTE2 = OKE_API.G_MISS_CHAR THEN
1468: l_k_billing_event_rec.ATTRIBUTE2:= NULL;
1469: END IF;
1470: IF l_k_billing_event_rec.ATTRIBUTE3 = OKE_API.G_MISS_CHAR THEN
1471: l_k_billing_event_rec.ATTRIBUTE3:= NULL;
1472: END IF;
1473: IF l_k_billing_event_rec.ATTRIBUTE4 = OKE_API.G_MISS_CHAR THEN
1474: l_k_billing_event_rec.ATTRIBUTE4:= NULL;

Line 1473: IF l_k_billing_event_rec.ATTRIBUTE4 = OKE_API.G_MISS_CHAR THEN

1469: END IF;
1470: IF l_k_billing_event_rec.ATTRIBUTE3 = OKE_API.G_MISS_CHAR THEN
1471: l_k_billing_event_rec.ATTRIBUTE3:= NULL;
1472: END IF;
1473: IF l_k_billing_event_rec.ATTRIBUTE4 = OKE_API.G_MISS_CHAR THEN
1474: l_k_billing_event_rec.ATTRIBUTE4:= NULL;
1475: END IF;
1476:
1477: IF l_k_billing_event_rec.ATTRIBUTE5 = OKE_API.G_MISS_CHAR THEN

Line 1477: IF l_k_billing_event_rec.ATTRIBUTE5 = OKE_API.G_MISS_CHAR THEN

1473: IF l_k_billing_event_rec.ATTRIBUTE4 = OKE_API.G_MISS_CHAR THEN
1474: l_k_billing_event_rec.ATTRIBUTE4:= NULL;
1475: END IF;
1476:
1477: IF l_k_billing_event_rec.ATTRIBUTE5 = OKE_API.G_MISS_CHAR THEN
1478: l_k_billing_event_rec.ATTRIBUTE5:= NULL;
1479: END IF;
1480:
1481: IF l_k_billing_event_rec.ATTRIBUTE6 = OKE_API.G_MISS_CHAR THEN

Line 1481: IF l_k_billing_event_rec.ATTRIBUTE6 = OKE_API.G_MISS_CHAR THEN

1477: IF l_k_billing_event_rec.ATTRIBUTE5 = OKE_API.G_MISS_CHAR THEN
1478: l_k_billing_event_rec.ATTRIBUTE5:= NULL;
1479: END IF;
1480:
1481: IF l_k_billing_event_rec.ATTRIBUTE6 = OKE_API.G_MISS_CHAR THEN
1482: l_k_billing_event_rec.ATTRIBUTE6:= NULL;
1483: END IF;
1484:
1485: IF l_k_billing_event_rec.ATTRIBUTE7 = OKE_API.G_MISS_CHAR THEN

Line 1485: IF l_k_billing_event_rec.ATTRIBUTE7 = OKE_API.G_MISS_CHAR THEN

1481: IF l_k_billing_event_rec.ATTRIBUTE6 = OKE_API.G_MISS_CHAR THEN
1482: l_k_billing_event_rec.ATTRIBUTE6:= NULL;
1483: END IF;
1484:
1485: IF l_k_billing_event_rec.ATTRIBUTE7 = OKE_API.G_MISS_CHAR THEN
1486: l_k_billing_event_rec.ATTRIBUTE7:= NULL;
1487: END IF;
1488:
1489: IF l_k_billing_event_rec.ATTRIBUTE8 = OKE_API.G_MISS_CHAR THEN

Line 1489: IF l_k_billing_event_rec.ATTRIBUTE8 = OKE_API.G_MISS_CHAR THEN

1485: IF l_k_billing_event_rec.ATTRIBUTE7 = OKE_API.G_MISS_CHAR THEN
1486: l_k_billing_event_rec.ATTRIBUTE7:= NULL;
1487: END IF;
1488:
1489: IF l_k_billing_event_rec.ATTRIBUTE8 = OKE_API.G_MISS_CHAR THEN
1490: l_k_billing_event_rec.ATTRIBUTE8:= NULL;
1491: END IF;
1492:
1493: IF l_k_billing_event_rec.ATTRIBUTE9 = OKE_API.G_MISS_CHAR THEN

Line 1493: IF l_k_billing_event_rec.ATTRIBUTE9 = OKE_API.G_MISS_CHAR THEN

1489: IF l_k_billing_event_rec.ATTRIBUTE8 = OKE_API.G_MISS_CHAR THEN
1490: l_k_billing_event_rec.ATTRIBUTE8:= NULL;
1491: END IF;
1492:
1493: IF l_k_billing_event_rec.ATTRIBUTE9 = OKE_API.G_MISS_CHAR THEN
1494: l_k_billing_event_rec.ATTRIBUTE9:= NULL;
1495: END IF;
1496:
1497: IF l_k_billing_event_rec.ATTRIBUTE10 = OKE_API.G_MISS_CHAR THEN

Line 1497: IF l_k_billing_event_rec.ATTRIBUTE10 = OKE_API.G_MISS_CHAR THEN

1493: IF l_k_billing_event_rec.ATTRIBUTE9 = OKE_API.G_MISS_CHAR THEN
1494: l_k_billing_event_rec.ATTRIBUTE9:= NULL;
1495: END IF;
1496:
1497: IF l_k_billing_event_rec.ATTRIBUTE10 = OKE_API.G_MISS_CHAR THEN
1498: l_k_billing_event_rec.ATTRIBUTE10:= NULL;
1499: END IF;
1500:
1501: IF l_k_billing_event_rec.ATTRIBUTE11 = OKE_API.G_MISS_CHAR THEN

Line 1501: IF l_k_billing_event_rec.ATTRIBUTE11 = OKE_API.G_MISS_CHAR THEN

1497: IF l_k_billing_event_rec.ATTRIBUTE10 = OKE_API.G_MISS_CHAR THEN
1498: l_k_billing_event_rec.ATTRIBUTE10:= NULL;
1499: END IF;
1500:
1501: IF l_k_billing_event_rec.ATTRIBUTE11 = OKE_API.G_MISS_CHAR THEN
1502: l_k_billing_event_rec.ATTRIBUTE11:= NULL;
1503: END IF;
1504:
1505: IF l_k_billing_event_rec.ATTRIBUTE12 = OKE_API.G_MISS_CHAR THEN

Line 1505: IF l_k_billing_event_rec.ATTRIBUTE12 = OKE_API.G_MISS_CHAR THEN

1501: IF l_k_billing_event_rec.ATTRIBUTE11 = OKE_API.G_MISS_CHAR THEN
1502: l_k_billing_event_rec.ATTRIBUTE11:= NULL;
1503: END IF;
1504:
1505: IF l_k_billing_event_rec.ATTRIBUTE12 = OKE_API.G_MISS_CHAR THEN
1506: l_k_billing_event_rec.ATTRIBUTE12:= NULL;
1507: END IF;
1508:
1509: IF l_k_billing_event_rec.ATTRIBUTE13 = OKE_API.G_MISS_CHAR THEN

Line 1509: IF l_k_billing_event_rec.ATTRIBUTE13 = OKE_API.G_MISS_CHAR THEN

1505: IF l_k_billing_event_rec.ATTRIBUTE12 = OKE_API.G_MISS_CHAR THEN
1506: l_k_billing_event_rec.ATTRIBUTE12:= NULL;
1507: END IF;
1508:
1509: IF l_k_billing_event_rec.ATTRIBUTE13 = OKE_API.G_MISS_CHAR THEN
1510: l_k_billing_event_rec.ATTRIBUTE13:= NULL;
1511: END IF;
1512:
1513: IF l_k_billing_event_rec.ATTRIBUTE14 = OKE_API.G_MISS_CHAR THEN

Line 1513: IF l_k_billing_event_rec.ATTRIBUTE14 = OKE_API.G_MISS_CHAR THEN

1509: IF l_k_billing_event_rec.ATTRIBUTE13 = OKE_API.G_MISS_CHAR THEN
1510: l_k_billing_event_rec.ATTRIBUTE13:= NULL;
1511: END IF;
1512:
1513: IF l_k_billing_event_rec.ATTRIBUTE14 = OKE_API.G_MISS_CHAR THEN
1514: l_k_billing_event_rec.ATTRIBUTE14:= NULL;
1515: END IF;
1516:
1517: IF l_k_billing_event_rec.ATTRIBUTE15 = OKE_API.G_MISS_CHAR THEN

Line 1517: IF l_k_billing_event_rec.ATTRIBUTE15 = OKE_API.G_MISS_CHAR THEN

1513: IF l_k_billing_event_rec.ATTRIBUTE14 = OKE_API.G_MISS_CHAR THEN
1514: l_k_billing_event_rec.ATTRIBUTE14:= NULL;
1515: END IF;
1516:
1517: IF l_k_billing_event_rec.ATTRIBUTE15 = OKE_API.G_MISS_CHAR THEN
1518: l_k_billing_event_rec.ATTRIBUTE15:= NULL;
1519: END IF;
1520:
1521: IF l_k_billing_event_rec.INITIATED_FLAG = OKE_API.G_MISS_CHAR THEN

Line 1521: IF l_k_billing_event_rec.INITIATED_FLAG = OKE_API.G_MISS_CHAR THEN

1517: IF l_k_billing_event_rec.ATTRIBUTE15 = OKE_API.G_MISS_CHAR THEN
1518: l_k_billing_event_rec.ATTRIBUTE15:= NULL;
1519: END IF;
1520:
1521: IF l_k_billing_event_rec.INITIATED_FLAG = OKE_API.G_MISS_CHAR THEN
1522: l_k_billing_event_rec.INITIATED_FLAG:= NULL;
1523: END IF;
1524:
1525:

Line 1535: l_return_status := OKE_API.START_ACTIVITY(

1531:
1532: BEGIN
1533: -- call START_ACTIVITY to create savepoint, check compatibility
1534: -- and initialize message list
1535: l_return_status := OKE_API.START_ACTIVITY(
1536: p_api_name => l_api_name,
1537: p_pkg_name => g_pkg_name,
1538: p_init_msg_list => p_init_msg_list,
1539: l_api_version => l_api_version,

Line 1545: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then

1541: p_api_type => g_api_type,
1542: x_return_status => x_return_status);
1543:
1544: -- Check if activity started successfully
1545: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1546: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1547: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1548: raise OKE_API.G_EXCEPTION_ERROR;
1549: End If;

Line 1546: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1542: x_return_status => x_return_status);
1543:
1544: -- Check if activity started successfully
1545: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1546: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1547: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1548: raise OKE_API.G_EXCEPTION_ERROR;
1549: End If;
1550:

Line 1547: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then

1543:
1544: -- Check if activity started successfully
1545: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1546: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1547: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1548: raise OKE_API.G_EXCEPTION_ERROR;
1549: End If;
1550:
1551: l_k_billing_event_rec := null_out_defaults(p_k_billing_event_rec);

Line 1548: raise OKE_API.G_EXCEPTION_ERROR;

1544: -- Check if activity started successfully
1545: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1546: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1547: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1548: raise OKE_API.G_EXCEPTION_ERROR;
1549: End If;
1550:
1551: l_k_billing_event_rec := null_out_defaults(p_k_billing_event_rec);
1552:

Line 1558: If ( l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then

1554: ---validations
1555: l_return_status:=validate_billing_attributes(p_k_billing_event_rec => l_k_billing_event_rec
1556: );
1557:
1558: If ( l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1559: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1560: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1561: raise OKE_API.G_EXCEPTION_ERROR;
1562: End If;

Line 1559: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1555: l_return_status:=validate_billing_attributes(p_k_billing_event_rec => l_k_billing_event_rec
1556: );
1557:
1558: If ( l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1559: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1560: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1561: raise OKE_API.G_EXCEPTION_ERROR;
1562: End If;
1563:

Line 1560: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then

1556: );
1557:
1558: If ( l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1559: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1560: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1561: raise OKE_API.G_EXCEPTION_ERROR;
1562: End If;
1563:
1564: Recalculate_price(l_k_billing_event_rec,l_bill_unit_price,l_REVENUE_AMOUNT,l_exchange_rate);

Line 1561: raise OKE_API.G_EXCEPTION_ERROR;

1557:
1558: If ( l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1559: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1560: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1561: raise OKE_API.G_EXCEPTION_ERROR;
1562: End If;
1563:
1564: Recalculate_price(l_k_billing_event_rec,l_bill_unit_price,l_REVENUE_AMOUNT,l_exchange_rate);
1565: l_k_billing_event_rec.bill_unit_price:= l_bill_unit_price;

Line 1606: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,

1602: , P_Last_Update_Date => SYSDATE);
1603:
1604: x_k_billing_event_rec:=l_k_billing_event_rec;
1605:
1606: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
1607: x_msg_data => x_msg_data);
1608:
1609: EXCEPTION
1610: when OKE_API.G_EXCEPTION_ERROR then

Line 1610: when OKE_API.G_EXCEPTION_ERROR then

1606: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
1607: x_msg_data => x_msg_data);
1608:
1609: EXCEPTION
1610: when OKE_API.G_EXCEPTION_ERROR then
1611: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1612: p_api_name => l_api_name,
1613: p_pkg_name => g_pkg_name,
1614: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

Line 1611: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

1607: x_msg_data => x_msg_data);
1608:
1609: EXCEPTION
1610: when OKE_API.G_EXCEPTION_ERROR then
1611: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1612: p_api_name => l_api_name,
1613: p_pkg_name => g_pkg_name,
1614: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
1615: x_msg_count => x_msg_count,

Line 1614: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

1610: when OKE_API.G_EXCEPTION_ERROR then
1611: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1612: p_api_name => l_api_name,
1613: p_pkg_name => g_pkg_name,
1614: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
1615: x_msg_count => x_msg_count,
1616: x_msg_data => x_msg_data,
1617: p_api_type => g_api_type);
1618:

Line 1619: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then

1615: x_msg_count => x_msg_count,
1616: x_msg_data => x_msg_data,
1617: p_api_type => g_api_type);
1618:
1619: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
1620: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1621: p_api_name => l_api_name,
1622: p_pkg_name => g_pkg_name,
1623: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 1620: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

1616: x_msg_data => x_msg_data,
1617: p_api_type => g_api_type);
1618:
1619: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
1620: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1621: p_api_name => l_api_name,
1622: p_pkg_name => g_pkg_name,
1623: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
1624: x_msg_count => x_msg_count,

Line 1623: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

1619: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
1620: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1621: p_api_name => l_api_name,
1622: p_pkg_name => g_pkg_name,
1623: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
1624: x_msg_count => x_msg_count,
1625: x_msg_data => x_msg_data,
1626: p_api_type => g_api_type);
1627:

Line 1629: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

1625: x_msg_data => x_msg_data,
1626: p_api_type => g_api_type);
1627:
1628: when OTHERS then
1629: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1630: p_api_name => l_api_name,
1631: p_pkg_name => g_pkg_name,
1632: p_exc_name => 'OTHERS',
1633: x_msg_count => x_msg_count,

Line 1649: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

1645: x_k_billing_event_rec OUT NOCOPY OKE_BILLING_EVENT_PUB.k_billing_event_rec_type
1646: ) RETURN VARCHAR2 IS
1647:
1648:
1649: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
1650:
1651: CURSOR bill_evnt_csr is
1652: SELECT
1653: billing_event_id ,

Line 1768: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,

1764: l_no_data_found := bill_evnt_csr%NOTFOUND;
1765: CLOSE bill_evnt_csr;
1766:
1767: IF l_no_data_found THEN
1768: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,
1769: p_msg_name =>G_REQUIRED_VALUE,
1770: p_token1 =>G_COL_NAME_TOKEN,
1771: p_token1_value =>'billing_event_id');
1772: l_return_status := OKE_API.G_RET_STS_ERROR;

Line 1772: l_return_status := OKE_API.G_RET_STS_ERROR;

1768: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,
1769: p_msg_name =>G_REQUIRED_VALUE,
1770: p_token1 =>G_COL_NAME_TOKEN,
1771: p_token1_value =>'billing_event_id');
1772: l_return_status := OKE_API.G_RET_STS_ERROR;
1773:
1774: else
1775:
1776:

Line 1778: IF X_k_billing_event_rec.BILLING_EVENT_ID = OKE_API.G_MISS_num THEN

1774: else
1775:
1776:
1777:
1778: IF X_k_billing_event_rec.BILLING_EVENT_ID = OKE_API.G_MISS_num THEN
1779: X_k_billing_event_rec.BILLING_EVENT_ID := l_k_billing_event_rec.BILLING_EVENT_ID;
1780: END IF;
1781:
1782:

Line 1784: IF X_k_billing_event_rec.BILL_PROJECT_ID = OKE_API.G_MISS_NUM THEN

1780: END IF;
1781:
1782:
1783:
1784: IF X_k_billing_event_rec.BILL_PROJECT_ID = OKE_API.G_MISS_NUM THEN
1785: X_k_billing_event_rec.BILL_PROJECT_ID := l_k_billing_event_rec.BILL_PROJECT_ID;
1786: END IF;
1787:
1788: IF X_k_billing_event_rec.BILL_TASK_ID = OKE_API.G_MISS_NUM THEN

Line 1788: IF X_k_billing_event_rec.BILL_TASK_ID = OKE_API.G_MISS_NUM THEN

1784: IF X_k_billing_event_rec.BILL_PROJECT_ID = OKE_API.G_MISS_NUM THEN
1785: X_k_billing_event_rec.BILL_PROJECT_ID := l_k_billing_event_rec.BILL_PROJECT_ID;
1786: END IF;
1787:
1788: IF X_k_billing_event_rec.BILL_TASK_ID = OKE_API.G_MISS_NUM THEN
1789: X_k_billing_event_rec.BILL_TASK_ID := l_k_billing_event_rec.BILL_TASK_ID;
1790: END IF;
1791:
1792: IF X_k_billing_event_rec.BILL_ITEM_ID = OKE_API.G_MISS_NUM THEN

Line 1792: IF X_k_billing_event_rec.BILL_ITEM_ID = OKE_API.G_MISS_NUM THEN

1788: IF X_k_billing_event_rec.BILL_TASK_ID = OKE_API.G_MISS_NUM THEN
1789: X_k_billing_event_rec.BILL_TASK_ID := l_k_billing_event_rec.BILL_TASK_ID;
1790: END IF;
1791:
1792: IF X_k_billing_event_rec.BILL_ITEM_ID = OKE_API.G_MISS_NUM THEN
1793: X_k_billing_event_rec.BILL_ITEM_ID := l_k_billing_event_rec.BILL_ITEM_ID;
1794: END IF;
1795:
1796: IF X_k_billing_event_rec.K_HEADER_ID = OKE_API.G_MISS_NUM THEN

Line 1796: IF X_k_billing_event_rec.K_HEADER_ID = OKE_API.G_MISS_NUM THEN

1792: IF X_k_billing_event_rec.BILL_ITEM_ID = OKE_API.G_MISS_NUM THEN
1793: X_k_billing_event_rec.BILL_ITEM_ID := l_k_billing_event_rec.BILL_ITEM_ID;
1794: END IF;
1795:
1796: IF X_k_billing_event_rec.K_HEADER_ID = OKE_API.G_MISS_NUM THEN
1797: X_k_billing_event_rec.K_HEADER_ID := l_k_billing_event_rec.K_HEADER_ID;
1798: END IF;
1799:
1800: IF X_k_billing_event_rec.K_LINE_ID = OKE_API.G_MISS_NUM THEN

Line 1800: IF X_k_billing_event_rec.K_LINE_ID = OKE_API.G_MISS_NUM THEN

1796: IF X_k_billing_event_rec.K_HEADER_ID = OKE_API.G_MISS_NUM THEN
1797: X_k_billing_event_rec.K_HEADER_ID := l_k_billing_event_rec.K_HEADER_ID;
1798: END IF;
1799:
1800: IF X_k_billing_event_rec.K_LINE_ID = OKE_API.G_MISS_NUM THEN
1801: X_k_billing_event_rec.K_LINE_ID := l_k_billing_event_rec.K_LINE_ID;
1802: END IF;
1803:
1804: IF X_k_billing_event_rec.DELIVERABLE_ID = OKE_API.G_MISS_NUM THEN

Line 1804: IF X_k_billing_event_rec.DELIVERABLE_ID = OKE_API.G_MISS_NUM THEN

1800: IF X_k_billing_event_rec.K_LINE_ID = OKE_API.G_MISS_NUM THEN
1801: X_k_billing_event_rec.K_LINE_ID := l_k_billing_event_rec.K_LINE_ID;
1802: END IF;
1803:
1804: IF X_k_billing_event_rec.DELIVERABLE_ID = OKE_API.G_MISS_NUM THEN
1805: X_k_billing_event_rec.DELIVERABLE_ID := l_k_billing_event_rec.DELIVERABLE_ID;
1806: END IF;
1807:
1808: IF X_k_billing_event_rec.BILL_EVENT_DATE = OKE_API.G_MISS_DATE THEN

Line 1808: IF X_k_billing_event_rec.BILL_EVENT_DATE = OKE_API.G_MISS_DATE THEN

1804: IF X_k_billing_event_rec.DELIVERABLE_ID = OKE_API.G_MISS_NUM THEN
1805: X_k_billing_event_rec.DELIVERABLE_ID := l_k_billing_event_rec.DELIVERABLE_ID;
1806: END IF;
1807:
1808: IF X_k_billing_event_rec.BILL_EVENT_DATE = OKE_API.G_MISS_DATE THEN
1809: X_k_billing_event_rec.BILL_EVENT_DATE := l_k_billing_event_rec.BILL_EVENT_DATE;
1810: END IF;
1811:
1812: IF X_k_billing_event_rec.BILL_EVENT_TYPE = OKE_API.G_MISS_CHAR THEN

Line 1812: IF X_k_billing_event_rec.BILL_EVENT_TYPE = OKE_API.G_MISS_CHAR THEN

1808: IF X_k_billing_event_rec.BILL_EVENT_DATE = OKE_API.G_MISS_DATE THEN
1809: X_k_billing_event_rec.BILL_EVENT_DATE := l_k_billing_event_rec.BILL_EVENT_DATE;
1810: END IF;
1811:
1812: IF X_k_billing_event_rec.BILL_EVENT_TYPE = OKE_API.G_MISS_CHAR THEN
1813: X_k_billing_event_rec.BILL_EVENT_TYPE := l_k_billing_event_rec.BILL_EVENT_TYPE;
1814: END IF;
1815:
1816:

Line 1818: IF X_k_billing_event_rec.PA_EVENT_ID = OKE_API.G_MISS_NUM THEN

1814: END IF;
1815:
1816:
1817:
1818: IF X_k_billing_event_rec.PA_EVENT_ID = OKE_API.G_MISS_NUM THEN
1819: X_k_billing_event_rec.PA_EVENT_ID := l_k_billing_event_rec.PA_EVENT_ID;
1820: END IF;
1821:
1822: IF X_k_billing_event_rec.BILL_LINE_ID = OKE_API.G_MISS_NUM THEN

Line 1822: IF X_k_billing_event_rec.BILL_LINE_ID = OKE_API.G_MISS_NUM THEN

1818: IF X_k_billing_event_rec.PA_EVENT_ID = OKE_API.G_MISS_NUM THEN
1819: X_k_billing_event_rec.PA_EVENT_ID := l_k_billing_event_rec.PA_EVENT_ID;
1820: END IF;
1821:
1822: IF X_k_billing_event_rec.BILL_LINE_ID = OKE_API.G_MISS_NUM THEN
1823: X_k_billing_event_rec.BILL_LINE_ID := l_k_billing_event_rec.BILL_LINE_ID;
1824: END IF;
1825:
1826:

Line 1827: IF X_k_billing_event_rec.BILL_CHG_REQ_ID = OKE_API.G_MISS_NUM THEN

1823: X_k_billing_event_rec.BILL_LINE_ID := l_k_billing_event_rec.BILL_LINE_ID;
1824: END IF;
1825:
1826:
1827: IF X_k_billing_event_rec.BILL_CHG_REQ_ID = OKE_API.G_MISS_NUM THEN
1828: X_k_billing_event_rec.BILL_CHG_REQ_ID := l_k_billing_event_rec.BILL_CHG_REQ_ID;
1829: END IF;
1830:
1831:

Line 1833: IF X_k_billing_event_rec.BILL_ORGANIZATION_ID = OKE_API.G_MISS_NUM THEN

1829: END IF;
1830:
1831:
1832:
1833: IF X_k_billing_event_rec.BILL_ORGANIZATION_ID = OKE_API.G_MISS_NUM THEN
1834: X_k_billing_event_rec.BILL_ORGANIZATION_ID := l_k_billing_event_rec.BILL_ORGANIZATION_ID;
1835: END IF;
1836:
1837:

Line 1838: IF X_k_billing_event_rec.BILL_FUND_REF1 = OKE_API.G_MISS_CHAR THEN

1834: X_k_billing_event_rec.BILL_ORGANIZATION_ID := l_k_billing_event_rec.BILL_ORGANIZATION_ID;
1835: END IF;
1836:
1837:
1838: IF X_k_billing_event_rec.BILL_FUND_REF1 = OKE_API.G_MISS_CHAR THEN
1839: X_k_billing_event_rec.BILL_FUND_REF1 := l_k_billing_event_rec.BILL_FUND_REF1;
1840: END IF;
1841:
1842: IF X_k_billing_event_rec.BILL_FUND_REF2 = OKE_API.G_MISS_CHAR THEN

Line 1842: IF X_k_billing_event_rec.BILL_FUND_REF2 = OKE_API.G_MISS_CHAR THEN

1838: IF X_k_billing_event_rec.BILL_FUND_REF1 = OKE_API.G_MISS_CHAR THEN
1839: X_k_billing_event_rec.BILL_FUND_REF1 := l_k_billing_event_rec.BILL_FUND_REF1;
1840: END IF;
1841:
1842: IF X_k_billing_event_rec.BILL_FUND_REF2 = OKE_API.G_MISS_CHAR THEN
1843: X_k_billing_event_rec.BILL_FUND_REF2 := l_k_billing_event_rec.BILL_FUND_REF2;
1844: END IF;
1845:
1846:

Line 1847: IF X_k_billing_event_rec.BILL_FUND_REF3 = OKE_API.G_MISS_CHAR THEN

1843: X_k_billing_event_rec.BILL_FUND_REF2 := l_k_billing_event_rec.BILL_FUND_REF2;
1844: END IF;
1845:
1846:
1847: IF X_k_billing_event_rec.BILL_FUND_REF3 = OKE_API.G_MISS_CHAR THEN
1848: X_k_billing_event_rec.BILL_FUND_REF3 := l_k_billing_event_rec.BILL_FUND_REF3;
1849: END IF;
1850:
1851:

Line 1853: IF X_k_billing_event_rec.BILL_BILL_OF_LADING = OKE_API.G_MISS_CHAR THEN

1849: END IF;
1850:
1851:
1852:
1853: IF X_k_billing_event_rec.BILL_BILL_OF_LADING = OKE_API.G_MISS_CHAR THEN
1854: X_k_billing_event_rec.BILL_BILL_OF_LADING := l_k_billing_event_rec.BILL_BILL_OF_LADING;
1855: END IF;
1856:
1857:

Line 1859: IF X_k_billing_event_rec.BILL_SERIAL_NUM = OKE_API.G_MISS_CHAR THEN

1855: END IF;
1856:
1857:
1858:
1859: IF X_k_billing_event_rec.BILL_SERIAL_NUM = OKE_API.G_MISS_CHAR THEN
1860: X_k_billing_event_rec.BILL_SERIAL_NUM := l_k_billing_event_rec.BILL_SERIAL_NUM;
1861: END IF;
1862:
1863:

Line 1864: IF X_k_billing_event_rec.BILL_CURRENCY_CODE = OKE_API.G_MISS_CHAR THEN

1860: X_k_billing_event_rec.BILL_SERIAL_NUM := l_k_billing_event_rec.BILL_SERIAL_NUM;
1861: END IF;
1862:
1863:
1864: IF X_k_billing_event_rec.BILL_CURRENCY_CODE = OKE_API.G_MISS_CHAR THEN
1865: X_k_billing_event_rec.BILL_CURRENCY_CODE := l_k_billing_event_rec.BILL_CURRENCY_CODE;
1866: END IF;
1867:
1868: SELECT currency_code INTO l_bill_currency

Line 1874: IF X_k_billing_event_rec.BILL_RATE_TYPE = OKE_API.G_MISS_CHAR THEN

1870: WHERE id = x_k_billing_event_rec.k_header_id;
1871:
1872:
1873:
1874: IF X_k_billing_event_rec.BILL_RATE_TYPE = OKE_API.G_MISS_CHAR THEN
1875: IF l_bill_currency<> X_k_billing_event_rec.BILL_CURRENCY_CODE then
1876: X_k_billing_event_rec.BILL_RATE_TYPE := l_k_billing_event_rec.BILL_RATE_TYPE;
1877: ELSE
1878: X_k_billing_event_rec.BILL_RATE_TYPE :=NULL;

Line 1884: IF X_k_billing_event_rec.BILL_RATE_DATE = OKE_API.G_MISS_DATE THEN

1880: END IF;
1881:
1882:
1883:
1884: IF X_k_billing_event_rec.BILL_RATE_DATE = OKE_API.G_MISS_DATE THEN
1885:
1886: IF l_bill_currency<> X_k_billing_event_rec.BILL_CURRENCY_CODE then
1887: X_k_billing_event_rec.BILL_RATE_DATE := l_k_billing_event_rec.BILL_RATE_DATE;
1888: ELSE

Line 1895: IF X_k_billing_event_rec.BILL_EXCHANGE_RATE = OKE_API.G_MISS_NUM THEN

1891:
1892: END IF;
1893:
1894:
1895: IF X_k_billing_event_rec.BILL_EXCHANGE_RATE = OKE_API.G_MISS_NUM THEN
1896:
1897: IF l_bill_currency<> X_k_billing_event_rec.BILL_CURRENCY_CODE then
1898: X_k_billing_event_rec.BILL_EXCHANGE_RATE := l_k_billing_event_rec.BILL_EXCHANGE_RATE;
1899: ELSE

Line 1911: IF X_k_billing_event_rec.BILL_DESCRIPTION = OKE_API.G_MISS_CHAR THEN

1907: X_k_billing_event_rec.BILL_RATE_DATE :=NULL;
1908: X_k_billing_event_rec.BILL_EXCHANGE_RATE :=NULL;
1909: END IF;
1910:
1911: IF X_k_billing_event_rec.BILL_DESCRIPTION = OKE_API.G_MISS_CHAR THEN
1912: X_k_billing_event_rec.BILL_DESCRIPTION := l_k_billing_event_rec.BILL_DESCRIPTION;
1913: END IF;
1914:
1915:

Line 1916: IF X_k_billing_event_rec.BILL_QUANTITY = OKE_API.G_MISS_NUM THEN

1912: X_k_billing_event_rec.BILL_DESCRIPTION := l_k_billing_event_rec.BILL_DESCRIPTION;
1913: END IF;
1914:
1915:
1916: IF X_k_billing_event_rec.BILL_QUANTITY = OKE_API.G_MISS_NUM THEN
1917: X_k_billing_event_rec.BILL_QUANTITY := l_k_billing_event_rec.BILL_QUANTITY;
1918: END IF;
1919:
1920: IF X_k_billing_event_rec.BILL_UNIT_PRICE = OKE_API.G_MISS_NUM THEN

Line 1920: IF X_k_billing_event_rec.BILL_UNIT_PRICE = OKE_API.G_MISS_NUM THEN

1916: IF X_k_billing_event_rec.BILL_QUANTITY = OKE_API.G_MISS_NUM THEN
1917: X_k_billing_event_rec.BILL_QUANTITY := l_k_billing_event_rec.BILL_QUANTITY;
1918: END IF;
1919:
1920: IF X_k_billing_event_rec.BILL_UNIT_PRICE = OKE_API.G_MISS_NUM THEN
1921: X_k_billing_event_rec.BILL_UNIT_PRICE := null;
1922: END IF;
1923:
1924: IF X_k_billing_event_rec.REVENUE_AMOUNT = OKE_API.G_MISS_NUM THEN

Line 1924: IF X_k_billing_event_rec.REVENUE_AMOUNT = OKE_API.G_MISS_NUM THEN

1920: IF X_k_billing_event_rec.BILL_UNIT_PRICE = OKE_API.G_MISS_NUM THEN
1921: X_k_billing_event_rec.BILL_UNIT_PRICE := null;
1922: END IF;
1923:
1924: IF X_k_billing_event_rec.REVENUE_AMOUNT = OKE_API.G_MISS_NUM THEN
1925: X_k_billing_event_rec.REVENUE_AMOUNT := l_k_billing_event_rec.REVENUE_AMOUNT;
1926: END IF;
1927:
1928:

Line 1929: IF X_k_billing_event_rec.CREATED_BY = OKE_API.G_MISS_NUM THEN

1925: X_k_billing_event_rec.REVENUE_AMOUNT := l_k_billing_event_rec.REVENUE_AMOUNT;
1926: END IF;
1927:
1928:
1929: IF X_k_billing_event_rec.CREATED_BY = OKE_API.G_MISS_NUM THEN
1930: X_k_billing_event_rec.CREATED_BY := l_k_billing_event_rec.CREATED_BY;
1931: END IF;
1932:
1933: IF X_k_billing_event_rec.CREATION_DATE = OKE_API.G_MISS_DATE THEN

Line 1933: IF X_k_billing_event_rec.CREATION_DATE = OKE_API.G_MISS_DATE THEN

1929: IF X_k_billing_event_rec.CREATED_BY = OKE_API.G_MISS_NUM THEN
1930: X_k_billing_event_rec.CREATED_BY := l_k_billing_event_rec.CREATED_BY;
1931: END IF;
1932:
1933: IF X_k_billing_event_rec.CREATION_DATE = OKE_API.G_MISS_DATE THEN
1934: X_k_billing_event_rec.CREATION_DATE := l_k_billing_event_rec.CREATION_DATE;
1935: END IF;
1936:
1937: IF X_k_billing_event_rec.LAST_UPDATED_BY = OKE_API.G_MISS_NUM THEN

Line 1937: IF X_k_billing_event_rec.LAST_UPDATED_BY = OKE_API.G_MISS_NUM THEN

1933: IF X_k_billing_event_rec.CREATION_DATE = OKE_API.G_MISS_DATE THEN
1934: X_k_billing_event_rec.CREATION_DATE := l_k_billing_event_rec.CREATION_DATE;
1935: END IF;
1936:
1937: IF X_k_billing_event_rec.LAST_UPDATED_BY = OKE_API.G_MISS_NUM THEN
1938: X_k_billing_event_rec.LAST_UPDATED_BY := l_k_billing_event_rec.LAST_UPDATED_BY;
1939: END IF;
1940:
1941: IF X_k_billing_event_rec.LAST_UPDATE_LOGIN = OKE_API.G_MISS_NUM THEN

Line 1941: IF X_k_billing_event_rec.LAST_UPDATE_LOGIN = OKE_API.G_MISS_NUM THEN

1937: IF X_k_billing_event_rec.LAST_UPDATED_BY = OKE_API.G_MISS_NUM THEN
1938: X_k_billing_event_rec.LAST_UPDATED_BY := l_k_billing_event_rec.LAST_UPDATED_BY;
1939: END IF;
1940:
1941: IF X_k_billing_event_rec.LAST_UPDATE_LOGIN = OKE_API.G_MISS_NUM THEN
1942: X_k_billing_event_rec.LAST_UPDATE_LOGIN := l_k_billing_event_rec.LAST_UPDATE_LOGIN;
1943: END IF;
1944:
1945: IF X_k_billing_event_rec.LAST_UPDATE_DATE = OKE_API.G_MISS_DATE THEN

Line 1945: IF X_k_billing_event_rec.LAST_UPDATE_DATE = OKE_API.G_MISS_DATE THEN

1941: IF X_k_billing_event_rec.LAST_UPDATE_LOGIN = OKE_API.G_MISS_NUM THEN
1942: X_k_billing_event_rec.LAST_UPDATE_LOGIN := l_k_billing_event_rec.LAST_UPDATE_LOGIN;
1943: END IF;
1944:
1945: IF X_k_billing_event_rec.LAST_UPDATE_DATE = OKE_API.G_MISS_DATE THEN
1946: X_k_billing_event_rec.LAST_UPDATE_DATE := l_k_billing_event_rec.LAST_UPDATE_DATE;
1947: END IF;
1948:
1949: IF X_k_billing_event_rec.ATTRIBUTE_CATEGORY = OKE_API.G_MISS_CHAR THEN

Line 1949: IF X_k_billing_event_rec.ATTRIBUTE_CATEGORY = OKE_API.G_MISS_CHAR THEN

1945: IF X_k_billing_event_rec.LAST_UPDATE_DATE = OKE_API.G_MISS_DATE THEN
1946: X_k_billing_event_rec.LAST_UPDATE_DATE := l_k_billing_event_rec.LAST_UPDATE_DATE;
1947: END IF;
1948:
1949: IF X_k_billing_event_rec.ATTRIBUTE_CATEGORY = OKE_API.G_MISS_CHAR THEN
1950: X_k_billing_event_rec.ATTRIBUTE_CATEGORY := l_k_billing_event_rec.ATTRIBUTE_CATEGORY;
1951: END IF;
1952:
1953: IF X_k_billing_event_rec.ATTRIBUTE1 = OKE_API.G_MISS_CHAR THEN

Line 1953: IF X_k_billing_event_rec.ATTRIBUTE1 = OKE_API.G_MISS_CHAR THEN

1949: IF X_k_billing_event_rec.ATTRIBUTE_CATEGORY = OKE_API.G_MISS_CHAR THEN
1950: X_k_billing_event_rec.ATTRIBUTE_CATEGORY := l_k_billing_event_rec.ATTRIBUTE_CATEGORY;
1951: END IF;
1952:
1953: IF X_k_billing_event_rec.ATTRIBUTE1 = OKE_API.G_MISS_CHAR THEN
1954: X_k_billing_event_rec.ATTRIBUTE1 := l_k_billing_event_rec.ATTRIBUTE1;
1955: END IF;
1956:
1957: IF X_k_billing_event_rec.ATTRIBUTE2 = OKE_API.G_MISS_CHAR THEN

Line 1957: IF X_k_billing_event_rec.ATTRIBUTE2 = OKE_API.G_MISS_CHAR THEN

1953: IF X_k_billing_event_rec.ATTRIBUTE1 = OKE_API.G_MISS_CHAR THEN
1954: X_k_billing_event_rec.ATTRIBUTE1 := l_k_billing_event_rec.ATTRIBUTE1;
1955: END IF;
1956:
1957: IF X_k_billing_event_rec.ATTRIBUTE2 = OKE_API.G_MISS_CHAR THEN
1958: X_k_billing_event_rec.ATTRIBUTE2 := l_k_billing_event_rec.ATTRIBUTE2;
1959: END IF;
1960:
1961: IF X_k_billing_event_rec.ATTRIBUTE3 = OKE_API.G_MISS_CHAR THEN

Line 1961: IF X_k_billing_event_rec.ATTRIBUTE3 = OKE_API.G_MISS_CHAR THEN

1957: IF X_k_billing_event_rec.ATTRIBUTE2 = OKE_API.G_MISS_CHAR THEN
1958: X_k_billing_event_rec.ATTRIBUTE2 := l_k_billing_event_rec.ATTRIBUTE2;
1959: END IF;
1960:
1961: IF X_k_billing_event_rec.ATTRIBUTE3 = OKE_API.G_MISS_CHAR THEN
1962: X_k_billing_event_rec.ATTRIBUTE3 := l_k_billing_event_rec.ATTRIBUTE3;
1963: END IF;
1964:
1965: IF X_k_billing_event_rec.ATTRIBUTE4 = OKE_API.G_MISS_CHAR THEN

Line 1965: IF X_k_billing_event_rec.ATTRIBUTE4 = OKE_API.G_MISS_CHAR THEN

1961: IF X_k_billing_event_rec.ATTRIBUTE3 = OKE_API.G_MISS_CHAR THEN
1962: X_k_billing_event_rec.ATTRIBUTE3 := l_k_billing_event_rec.ATTRIBUTE3;
1963: END IF;
1964:
1965: IF X_k_billing_event_rec.ATTRIBUTE4 = OKE_API.G_MISS_CHAR THEN
1966: X_k_billing_event_rec.ATTRIBUTE4 := l_k_billing_event_rec.ATTRIBUTE4;
1967: END IF;
1968:
1969: IF X_k_billing_event_rec.ATTRIBUTE5 = OKE_API.G_MISS_CHAR THEN

Line 1969: IF X_k_billing_event_rec.ATTRIBUTE5 = OKE_API.G_MISS_CHAR THEN

1965: IF X_k_billing_event_rec.ATTRIBUTE4 = OKE_API.G_MISS_CHAR THEN
1966: X_k_billing_event_rec.ATTRIBUTE4 := l_k_billing_event_rec.ATTRIBUTE4;
1967: END IF;
1968:
1969: IF X_k_billing_event_rec.ATTRIBUTE5 = OKE_API.G_MISS_CHAR THEN
1970: X_k_billing_event_rec.ATTRIBUTE5 := l_k_billing_event_rec.ATTRIBUTE5;
1971: END IF;
1972:
1973: IF X_k_billing_event_rec.ATTRIBUTE6 = OKE_API.G_MISS_CHAR THEN

Line 1973: IF X_k_billing_event_rec.ATTRIBUTE6 = OKE_API.G_MISS_CHAR THEN

1969: IF X_k_billing_event_rec.ATTRIBUTE5 = OKE_API.G_MISS_CHAR THEN
1970: X_k_billing_event_rec.ATTRIBUTE5 := l_k_billing_event_rec.ATTRIBUTE5;
1971: END IF;
1972:
1973: IF X_k_billing_event_rec.ATTRIBUTE6 = OKE_API.G_MISS_CHAR THEN
1974: X_k_billing_event_rec.ATTRIBUTE6 := l_k_billing_event_rec.ATTRIBUTE6;
1975: END IF;
1976:
1977: IF X_k_billing_event_rec.ATTRIBUTE7 = OKE_API.G_MISS_CHAR THEN

Line 1977: IF X_k_billing_event_rec.ATTRIBUTE7 = OKE_API.G_MISS_CHAR THEN

1973: IF X_k_billing_event_rec.ATTRIBUTE6 = OKE_API.G_MISS_CHAR THEN
1974: X_k_billing_event_rec.ATTRIBUTE6 := l_k_billing_event_rec.ATTRIBUTE6;
1975: END IF;
1976:
1977: IF X_k_billing_event_rec.ATTRIBUTE7 = OKE_API.G_MISS_CHAR THEN
1978: X_k_billing_event_rec.ATTRIBUTE7 := l_k_billing_event_rec.ATTRIBUTE7;
1979: END IF;
1980:
1981: IF X_k_billing_event_rec.ATTRIBUTE8 = OKE_API.G_MISS_CHAR THEN

Line 1981: IF X_k_billing_event_rec.ATTRIBUTE8 = OKE_API.G_MISS_CHAR THEN

1977: IF X_k_billing_event_rec.ATTRIBUTE7 = OKE_API.G_MISS_CHAR THEN
1978: X_k_billing_event_rec.ATTRIBUTE7 := l_k_billing_event_rec.ATTRIBUTE7;
1979: END IF;
1980:
1981: IF X_k_billing_event_rec.ATTRIBUTE8 = OKE_API.G_MISS_CHAR THEN
1982: X_k_billing_event_rec.ATTRIBUTE8 := l_k_billing_event_rec.ATTRIBUTE8;
1983: END IF;
1984:
1985: IF X_k_billing_event_rec.ATTRIBUTE9 = OKE_API.G_MISS_CHAR THEN

Line 1985: IF X_k_billing_event_rec.ATTRIBUTE9 = OKE_API.G_MISS_CHAR THEN

1981: IF X_k_billing_event_rec.ATTRIBUTE8 = OKE_API.G_MISS_CHAR THEN
1982: X_k_billing_event_rec.ATTRIBUTE8 := l_k_billing_event_rec.ATTRIBUTE8;
1983: END IF;
1984:
1985: IF X_k_billing_event_rec.ATTRIBUTE9 = OKE_API.G_MISS_CHAR THEN
1986: X_k_billing_event_rec.ATTRIBUTE9 := l_k_billing_event_rec.ATTRIBUTE9;
1987: END IF;
1988:
1989: IF X_k_billing_event_rec.ATTRIBUTE10 = OKE_API.G_MISS_CHAR THEN

Line 1989: IF X_k_billing_event_rec.ATTRIBUTE10 = OKE_API.G_MISS_CHAR THEN

1985: IF X_k_billing_event_rec.ATTRIBUTE9 = OKE_API.G_MISS_CHAR THEN
1986: X_k_billing_event_rec.ATTRIBUTE9 := l_k_billing_event_rec.ATTRIBUTE9;
1987: END IF;
1988:
1989: IF X_k_billing_event_rec.ATTRIBUTE10 = OKE_API.G_MISS_CHAR THEN
1990: X_k_billing_event_rec.ATTRIBUTE10 := l_k_billing_event_rec.ATTRIBUTE10;
1991: END IF;
1992:
1993: IF X_k_billing_event_rec.ATTRIBUTE11 = OKE_API.G_MISS_CHAR THEN

Line 1993: IF X_k_billing_event_rec.ATTRIBUTE11 = OKE_API.G_MISS_CHAR THEN

1989: IF X_k_billing_event_rec.ATTRIBUTE10 = OKE_API.G_MISS_CHAR THEN
1990: X_k_billing_event_rec.ATTRIBUTE10 := l_k_billing_event_rec.ATTRIBUTE10;
1991: END IF;
1992:
1993: IF X_k_billing_event_rec.ATTRIBUTE11 = OKE_API.G_MISS_CHAR THEN
1994: X_k_billing_event_rec.ATTRIBUTE11 := l_k_billing_event_rec.ATTRIBUTE11;
1995: END IF;
1996:
1997: IF X_k_billing_event_rec.ATTRIBUTE12 = OKE_API.G_MISS_CHAR THEN

Line 1997: IF X_k_billing_event_rec.ATTRIBUTE12 = OKE_API.G_MISS_CHAR THEN

1993: IF X_k_billing_event_rec.ATTRIBUTE11 = OKE_API.G_MISS_CHAR THEN
1994: X_k_billing_event_rec.ATTRIBUTE11 := l_k_billing_event_rec.ATTRIBUTE11;
1995: END IF;
1996:
1997: IF X_k_billing_event_rec.ATTRIBUTE12 = OKE_API.G_MISS_CHAR THEN
1998: X_k_billing_event_rec.ATTRIBUTE12 := l_k_billing_event_rec.ATTRIBUTE12;
1999: END IF;
2000:
2001: IF X_k_billing_event_rec.ATTRIBUTE13 = OKE_API.G_MISS_CHAR THEN

Line 2001: IF X_k_billing_event_rec.ATTRIBUTE13 = OKE_API.G_MISS_CHAR THEN

1997: IF X_k_billing_event_rec.ATTRIBUTE12 = OKE_API.G_MISS_CHAR THEN
1998: X_k_billing_event_rec.ATTRIBUTE12 := l_k_billing_event_rec.ATTRIBUTE12;
1999: END IF;
2000:
2001: IF X_k_billing_event_rec.ATTRIBUTE13 = OKE_API.G_MISS_CHAR THEN
2002: X_k_billing_event_rec.ATTRIBUTE13 := l_k_billing_event_rec.ATTRIBUTE13;
2003: END IF;
2004:
2005: IF X_k_billing_event_rec.ATTRIBUTE14 = OKE_API.G_MISS_CHAR THEN

Line 2005: IF X_k_billing_event_rec.ATTRIBUTE14 = OKE_API.G_MISS_CHAR THEN

2001: IF X_k_billing_event_rec.ATTRIBUTE13 = OKE_API.G_MISS_CHAR THEN
2002: X_k_billing_event_rec.ATTRIBUTE13 := l_k_billing_event_rec.ATTRIBUTE13;
2003: END IF;
2004:
2005: IF X_k_billing_event_rec.ATTRIBUTE14 = OKE_API.G_MISS_CHAR THEN
2006: X_k_billing_event_rec.ATTRIBUTE14 := l_k_billing_event_rec.ATTRIBUTE14;
2007: END IF;
2008:
2009: IF X_k_billing_event_rec.ATTRIBUTE15 = OKE_API.G_MISS_CHAR THEN

Line 2009: IF X_k_billing_event_rec.ATTRIBUTE15 = OKE_API.G_MISS_CHAR THEN

2005: IF X_k_billing_event_rec.ATTRIBUTE14 = OKE_API.G_MISS_CHAR THEN
2006: X_k_billing_event_rec.ATTRIBUTE14 := l_k_billing_event_rec.ATTRIBUTE14;
2007: END IF;
2008:
2009: IF X_k_billing_event_rec.ATTRIBUTE15 = OKE_API.G_MISS_CHAR THEN
2010: X_k_billing_event_rec.ATTRIBUTE15 := l_k_billing_event_rec.ATTRIBUTE15;
2011: END IF;
2012:
2013: END IF;

Line 2021: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

2017: END populate_new_record;
2018:
2019:
2020: PROCEDURE update_k_billing_event(p_api_version IN NUMBER,
2021: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
2022: p_k_billing_event_rec IN OKE_BILLING_EVENT_PUB.k_billing_event_rec_type,
2023: x_return_status OUT NOCOPY VARCHAR2,
2024: x_msg_count OUT NOCOPY NUMBER,
2025: x_msg_data OUT NOCOPY VARCHAR2

Line 2032: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

2028:
2029: l_event_id NUMBER;
2030: l_api_name CONSTANT VARCHAR2(30) := 'update_k_billing_event';
2031: l_api_version CONSTANT NUMBER := 1.0;
2032: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
2033: l_k_billing_event_rec OKE_BILLING_EVENT_PUB.k_billing_event_rec_type;
2034: l_bill_unit_price NUMBER;
2035: l_REVENUE_AMOUNT NUMBER;
2036: l_exchange_rate NUMBER;

Line 2040: l_return_status := OKE_API.START_ACTIVITY(

2036: l_exchange_rate NUMBER;
2037: BEGIN
2038: -- call START_ACTIVITY to create savepoint, check compatibility
2039: -- and initialize message list
2040: l_return_status := OKE_API.START_ACTIVITY(
2041: p_api_name => l_api_name,
2042: p_pkg_name => g_pkg_name,
2043: p_init_msg_list => p_init_msg_list,
2044: l_api_version => l_api_version,

Line 2050: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then

2046: p_api_type => g_api_type,
2047: x_return_status => x_return_status);
2048:
2049: -- Check if activity started successfully
2050: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
2051: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2052: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
2053: raise OKE_API.G_EXCEPTION_ERROR;
2054: End If;

Line 2051: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

2047: x_return_status => x_return_status);
2048:
2049: -- Check if activity started successfully
2050: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
2051: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2052: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
2053: raise OKE_API.G_EXCEPTION_ERROR;
2054: End If;
2055:

Line 2052: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then

2048:
2049: -- Check if activity started successfully
2050: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
2051: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2052: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
2053: raise OKE_API.G_EXCEPTION_ERROR;
2054: End If;
2055:
2056: ---populate the

Line 2053: raise OKE_API.G_EXCEPTION_ERROR;

2049: -- Check if activity started successfully
2050: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
2051: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2052: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
2053: raise OKE_API.G_EXCEPTION_ERROR;
2054: End If;
2055:
2056: ---populate the
2057: l_return_status:= populate_new_record(p_k_billing_event_rec => p_k_billing_event_rec ,

Line 2062: If ( l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then

2058: x_k_billing_event_rec => l_k_billing_event_rec) ;
2059: ---validations
2060:
2061:
2062: If ( l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
2063: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2064: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
2065: raise OKE_API.G_EXCEPTION_ERROR;
2066: End If;

Line 2063: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

2059: ---validations
2060:
2061:
2062: If ( l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
2063: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2064: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
2065: raise OKE_API.G_EXCEPTION_ERROR;
2066: End If;
2067:

Line 2064: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then

2060:
2061:
2062: If ( l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
2063: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2064: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
2065: raise OKE_API.G_EXCEPTION_ERROR;
2066: End If;
2067:
2068: l_return_status:=validate_billing_attributes(p_k_billing_event_rec => l_k_billing_event_rec);

Line 2065: raise OKE_API.G_EXCEPTION_ERROR;

2061:
2062: If ( l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
2063: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2064: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
2065: raise OKE_API.G_EXCEPTION_ERROR;
2066: End If;
2067:
2068: l_return_status:=validate_billing_attributes(p_k_billing_event_rec => l_k_billing_event_rec);
2069:

Line 2071: If ( l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then

2067:
2068: l_return_status:=validate_billing_attributes(p_k_billing_event_rec => l_k_billing_event_rec);
2069:
2070:
2071: If ( l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
2072: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2073: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
2074: raise OKE_API.G_EXCEPTION_ERROR;
2075: End If;

Line 2072: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

2068: l_return_status:=validate_billing_attributes(p_k_billing_event_rec => l_k_billing_event_rec);
2069:
2070:
2071: If ( l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
2072: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2073: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
2074: raise OKE_API.G_EXCEPTION_ERROR;
2075: End If;
2076:

Line 2073: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then

2069:
2070:
2071: If ( l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
2072: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2073: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
2074: raise OKE_API.G_EXCEPTION_ERROR;
2075: End If;
2076:
2077:

Line 2074: raise OKE_API.G_EXCEPTION_ERROR;

2070:
2071: If ( l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
2072: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2073: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
2074: raise OKE_API.G_EXCEPTION_ERROR;
2075: End If;
2076:
2077:
2078: Recalculate_price(l_k_billing_event_rec,l_bill_unit_price,l_REVENUE_AMOUNT,l_exchange_rate);

Line 2116: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,

2112: );
2113:
2114:
2115:
2116: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
2117: x_msg_data => x_msg_data);
2118:
2119: EXCEPTION
2120: when OKE_API.G_EXCEPTION_ERROR then

Line 2120: when OKE_API.G_EXCEPTION_ERROR then

2116: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
2117: x_msg_data => x_msg_data);
2118:
2119: EXCEPTION
2120: when OKE_API.G_EXCEPTION_ERROR then
2121: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
2122: p_api_name => l_api_name,
2123: p_pkg_name => g_pkg_name,
2124: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

Line 2121: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

2117: x_msg_data => x_msg_data);
2118:
2119: EXCEPTION
2120: when OKE_API.G_EXCEPTION_ERROR then
2121: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
2122: p_api_name => l_api_name,
2123: p_pkg_name => g_pkg_name,
2124: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
2125: x_msg_count => x_msg_count,

Line 2124: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

2120: when OKE_API.G_EXCEPTION_ERROR then
2121: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
2122: p_api_name => l_api_name,
2123: p_pkg_name => g_pkg_name,
2124: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
2125: x_msg_count => x_msg_count,
2126: x_msg_data => x_msg_data,
2127: p_api_type => g_api_type);
2128:

Line 2129: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then

2125: x_msg_count => x_msg_count,
2126: x_msg_data => x_msg_data,
2127: p_api_type => g_api_type);
2128:
2129: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
2130: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
2131: p_api_name => l_api_name,
2132: p_pkg_name => g_pkg_name,
2133: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 2130: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

2126: x_msg_data => x_msg_data,
2127: p_api_type => g_api_type);
2128:
2129: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
2130: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
2131: p_api_name => l_api_name,
2132: p_pkg_name => g_pkg_name,
2133: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
2134: x_msg_count => x_msg_count,

Line 2133: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

2129: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
2130: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
2131: p_api_name => l_api_name,
2132: p_pkg_name => g_pkg_name,
2133: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
2134: x_msg_count => x_msg_count,
2135: x_msg_data => x_msg_data,
2136: p_api_type => g_api_type);
2137:

Line 2139: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

2135: x_msg_data => x_msg_data,
2136: p_api_type => g_api_type);
2137:
2138: when OTHERS then
2139: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
2140: p_api_name => l_api_name,
2141: p_pkg_name => g_pkg_name,
2142: p_exc_name => 'OTHERS',
2143: x_msg_count => x_msg_count,

Line 2152: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

2148: END update_k_billing_event;
2149:
2150:
2151: PROCEDURE delete_k_billing_event(p_api_version IN NUMBER,
2152: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
2153: p_billing_event_id IN NUMBER,
2154: x_return_status OUT NOCOPY VARCHAR2,
2155: x_msg_count OUT NOCOPY NUMBER,
2156: x_msg_data OUT NOCOPY VARCHAR2

Line 2161: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

2157: )
2158: IS
2159: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_K_BILLING_EVENT';
2160: l_api_version CONSTANT NUMBER := 1.0;
2161: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
2162: l_msg_count NUMBER;
2163: l_msg_data VARCHAR2(2000);
2164:
2165: L_sts_code VARCHAR2(30);

Line 2195: l_return_status := OKE_API.START_ACTIVITY(

2191: BEGIN
2192:
2193: -- call START_ACTIVITY to create savepoint, check compatibility
2194: -- and initialize message list
2195: l_return_status := OKE_API.START_ACTIVITY(
2196: p_api_name => l_api_name,
2197: p_pkg_name => g_pkg_name,
2198: p_init_msg_list => p_init_msg_list,
2199: l_api_version => l_api_version,

Line 2205: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then

2201: p_api_type => g_api_type,
2202: x_return_status => x_return_status);
2203:
2204: -- Check if activity started successfully
2205: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
2206: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2207: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
2208: raise OKE_API.G_EXCEPTION_ERROR;
2209: End If;

Line 2206: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

2202: x_return_status => x_return_status);
2203:
2204: -- Check if activity started successfully
2205: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
2206: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2207: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
2208: raise OKE_API.G_EXCEPTION_ERROR;
2209: End If;
2210:

Line 2207: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then

2203:
2204: -- Check if activity started successfully
2205: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
2206: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2207: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
2208: raise OKE_API.G_EXCEPTION_ERROR;
2209: End If;
2210:
2211: -- Validate Event id

Line 2208: raise OKE_API.G_EXCEPTION_ERROR;

2204: -- Check if activity started successfully
2205: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
2206: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2207: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
2208: raise OKE_API.G_EXCEPTION_ERROR;
2209: End If;
2210:
2211: -- Validate Event id
2212: OPEN cur_get_event_info(p_billing_event_id);

Line 2216: OKE_API.SET_MESSAGE

2212: OPEN cur_get_event_info(p_billing_event_id);
2213: FETCH cur_get_event_info INTO l_pa_event_id;
2214: IF cur_get_event_info%NOTFOUND THEN
2215: CLOSE cur_get_event_info;
2216: OKE_API.SET_MESSAGE
2217: (p_app_name => g_app_name,
2218: p_msg_name => g_invalid_value,
2219: p_token1 => g_col_name_token,
2220: p_token1_value => 'Billing_Event_Id');

Line 2222: raise OKE_API.G_EXCEPTION_ERROR;

2218: p_msg_name => g_invalid_value,
2219: p_token1 => g_col_name_token,
2220: p_token1_value => 'Billing_Event_Id');
2221:
2222: raise OKE_API.G_EXCEPTION_ERROR;
2223: END IF;
2224: CLOSE cur_get_event_info;
2225:
2226: IF l_pa_event_id IS NOT NULL THEN

Line 2239: OKE_API.SET_MESSAGE

2235: , L_Task_ID
2236: , L_Event_Num
2237: , L_Bill_Amount ) = 'Y')
2238: THEN
2239: OKE_API.SET_MESSAGE
2240: (p_app_name => g_app_name,
2241: p_msg_name => 'OKE_BILL_EVENT_PROCESSED_DEL'
2242: );
2243: raise OKE_API.G_EXCEPTION_ERROR;

Line 2243: raise OKE_API.G_EXCEPTION_ERROR;

2239: OKE_API.SET_MESSAGE
2240: (p_app_name => g_app_name,
2241: p_msg_name => 'OKE_BILL_EVENT_PROCESSED_DEL'
2242: );
2243: raise OKE_API.G_EXCEPTION_ERROR;
2244: END IF; -- PA_EVENTS_PKG.Is_Event_Billed
2245: END IF; -- L_RowID is not null
2246: END IF; -- l_pa_event_id is not null
2247:

Line 2254: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,

2250: P_Billing_Event_ID => p_billing_event_id
2251: );
2252:
2253: -- delete billing info
2254: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
2255: x_msg_data => x_msg_data);
2256:
2257: EXCEPTION
2258: when OKE_API.G_EXCEPTION_ERROR then

Line 2258: when OKE_API.G_EXCEPTION_ERROR then

2254: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
2255: x_msg_data => x_msg_data);
2256:
2257: EXCEPTION
2258: when OKE_API.G_EXCEPTION_ERROR then
2259: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
2260: p_api_name => l_api_name,
2261: p_pkg_name => g_pkg_name,
2262: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

Line 2259: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

2255: x_msg_data => x_msg_data);
2256:
2257: EXCEPTION
2258: when OKE_API.G_EXCEPTION_ERROR then
2259: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
2260: p_api_name => l_api_name,
2261: p_pkg_name => g_pkg_name,
2262: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
2263: x_msg_count => x_msg_count,

Line 2262: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

2258: when OKE_API.G_EXCEPTION_ERROR then
2259: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
2260: p_api_name => l_api_name,
2261: p_pkg_name => g_pkg_name,
2262: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
2263: x_msg_count => x_msg_count,
2264: x_msg_data => x_msg_data,
2265: p_api_type => g_api_type);
2266:

Line 2267: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then

2263: x_msg_count => x_msg_count,
2264: x_msg_data => x_msg_data,
2265: p_api_type => g_api_type);
2266:
2267: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
2268: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
2269: p_api_name => l_api_name,
2270: p_pkg_name => g_pkg_name,
2271: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 2268: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

2264: x_msg_data => x_msg_data,
2265: p_api_type => g_api_type);
2266:
2267: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
2268: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
2269: p_api_name => l_api_name,
2270: p_pkg_name => g_pkg_name,
2271: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
2272: x_msg_count => x_msg_count,

Line 2271: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

2267: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
2268: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
2269: p_api_name => l_api_name,
2270: p_pkg_name => g_pkg_name,
2271: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
2272: x_msg_count => x_msg_count,
2273: x_msg_data => x_msg_data,
2274: p_api_type => g_api_type);
2275:

Line 2277: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

2273: x_msg_data => x_msg_data,
2274: p_api_type => g_api_type);
2275:
2276: when OTHERS then
2277: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
2278: p_api_name => l_api_name,
2279: p_pkg_name => g_pkg_name,
2280: p_exc_name => 'OTHERS',
2281: x_msg_count => x_msg_count,