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.PA_BILLING dependencies on PA_BILLING

Line 1: PACKAGE BODY pa_billing AS

1: PACKAGE BODY pa_billing AS
2: /* $Header: PAXIBILB.pls 120.22.12020000.3 2012/08/14 05:22:02 rvadali ship $ */
3:
4: /* MCB related changes */
5:

Line 79: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.UpdEvtFlg :');

75: /* Added procedure for Bug 10353589 */
76: PROCEDURE UpdEvtFlg (x_project_id IN NUMBER)
77: IS
78: BEGIN
79: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.UpdEvtFlg :');
80: PA_MCB_INVOICE_PKG.log_message('pa_billing.UpdEvtFlg Project Id :'||to_char(X_project_id));
81: UPDATE pa_events e
82: set billed_flag='Y'
83: WHERE project_id=x_project_id

Line 80: PA_MCB_INVOICE_PKG.log_message('pa_billing.UpdEvtFlg Project Id :'||to_char(X_project_id));

76: PROCEDURE UpdEvtFlg (x_project_id IN NUMBER)
77: IS
78: BEGIN
79: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.UpdEvtFlg :');
80: PA_MCB_INVOICE_PKG.log_message('pa_billing.UpdEvtFlg Project Id :'||to_char(X_project_id));
81: UPDATE pa_events e
82: set billed_flag='Y'
83: WHERE project_id=x_project_id
84: AND billed_flag='N'

Line 101: PA_MCB_INVOICE_PKG.log_message('Done with update leaving pa_billing.UpdEvtFlg :');

97: and i.event_num = e.event_num
98: and di.draft_invoice_num = i.draft_invoice_num
99: and di.project_id = i.project_id
100: and nvl(di.write_off_flag,'N') <> 'Y' );
101: PA_MCB_INVOICE_PKG.log_message('Done with update leaving pa_billing.UpdEvtFlg :');
102: RETURN;
103:
104: END;
105:

Line 183: from pa_billing_extensions be, pa_billing_assignments bea -- , Commented for bug 3643409

179: bea.billing_extension_id be_id, bea.top_task_id task_id,
180: decode(be.amount_reqd_flag, 'Y', nvl(bea.amount, 0), 0) amt,
181: decode(be.percentage_reqd_flag, 'Y', nvl(bea.percentage, 0), 0)
182: percent
183: from pa_billing_extensions be, pa_billing_assignments bea -- , Commented for bug 3643409
184: -- pa_projects p Commented for bug 3643409
185: where -- p.project_id = x_project_id Commented for bug 3643409
186: -- and Commented for bug 3643409
187: to_date(x_rev_or_bill_date,'YYYY/MM/DD') between be.start_date_active and nvl(be.end_date_active,to_date(x_rev_or_bill_date,'YYYY/MM/DD')) --Added the condition for bug 8206153, added nvl for bug 8228460

Line 268: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.bill_ext_driver :');

264: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
265:
266: BEGIN
267: IF g1_debug_mode = 'Y' THEN
268: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.bill_ext_driver :');
269: END IF;
270: GlobVars.ProjectId := x_project_id;
271: GlobVars.ReqId := x_request_id;
272: GlobVars.CallingPlace := x_calling_place;

Line 276: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver project id :'||to_char(GlobVars.ProjectId));

272: GlobVars.CallingPlace := x_calling_place;
273: GlobVars.CallingProcess := x_calling_process;
274: GlobVars.AccrueThruDate := x_rev_or_bill_date;
275: IF g1_debug_mode = 'Y' THEN
276: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver project id :'||to_char(GlobVars.ProjectId));
277: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver Request id :'||to_char(GlobVars.ReqId));
278: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver Calling place :'||GlobVars.CallingPlace);
279: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver calling process :'||GlobVars.CallingProcess);
280: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver accru thru date :'||GlobVars.AccrueThruDate);

Line 277: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver Request id :'||to_char(GlobVars.ReqId));

273: GlobVars.CallingProcess := x_calling_process;
274: GlobVars.AccrueThruDate := x_rev_or_bill_date;
275: IF g1_debug_mode = 'Y' THEN
276: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver project id :'||to_char(GlobVars.ProjectId));
277: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver Request id :'||to_char(GlobVars.ReqId));
278: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver Calling place :'||GlobVars.CallingPlace);
279: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver calling process :'||GlobVars.CallingProcess);
280: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver accru thru date :'||GlobVars.AccrueThruDate);
281: END IF;

Line 278: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver Calling place :'||GlobVars.CallingPlace);

274: GlobVars.AccrueThruDate := x_rev_or_bill_date;
275: IF g1_debug_mode = 'Y' THEN
276: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver project id :'||to_char(GlobVars.ProjectId));
277: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver Request id :'||to_char(GlobVars.ReqId));
278: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver Calling place :'||GlobVars.CallingPlace);
279: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver calling process :'||GlobVars.CallingProcess);
280: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver accru thru date :'||GlobVars.AccrueThruDate);
281: END IF;
282:

Line 279: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver calling process :'||GlobVars.CallingProcess);

275: IF g1_debug_mode = 'Y' THEN
276: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver project id :'||to_char(GlobVars.ProjectId));
277: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver Request id :'||to_char(GlobVars.ReqId));
278: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver Calling place :'||GlobVars.CallingPlace);
279: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver calling process :'||GlobVars.CallingProcess);
280: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver accru thru date :'||GlobVars.AccrueThruDate);
281: END IF;
282:
283: -- DBMS_OUTPUT.ENABLE(1000000);

Line 280: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver accru thru date :'||GlobVars.AccrueThruDate);

276: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver project id :'||to_char(GlobVars.ProjectId));
277: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver Request id :'||to_char(GlobVars.ReqId));
278: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver Calling place :'||GlobVars.CallingPlace);
279: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver calling process :'||GlobVars.CallingProcess);
280: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver accru thru date :'||GlobVars.AccrueThruDate);
281: END IF;
282:
283: -- DBMS_OUTPUT.ENABLE(1000000);
284: fund_level := pa_billing_values.funding_level(X_project_id);

Line 284: fund_level := pa_billing_values.funding_level(X_project_id);

280: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver accru thru date :'||GlobVars.AccrueThruDate);
281: END IF;
282:
283: -- DBMS_OUTPUT.ENABLE(1000000);
284: fund_level := pa_billing_values.funding_level(X_project_id);
285: x_error_message := 'Error during opening the dbms_sql cursor.';
286: c := dbms_sql.open_cursor;
287:
288: x_error_message := 'Error during fetching the get_procedure cursor.';

Line 320: -- view pa_billing_extn_params_v ( all the newly added columns in pa_billing_assignments table)

316: IF (task_rec.tpid IS NULL) THEN
317: -- This will be the case for Project Level funding and Project
318: -- Level assignment.
319: -- Do not have to change this stmt for MCB, because user is going to select from the
320: -- view pa_billing_extn_params_v ( all the newly added columns in pa_billing_assignments table)
321:
322: proc_stmt := 'declare s varchar2(240):=null; begin ' ||
323: get_rec.proc_name || '(' || to_char(x_project_id) ||
324: ','''',''' || x_calling_process ||

Line 354: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver: before executing building the Pl/Sql block :'||proc_stmt);

350: get_rec.proc_name || '(:project_id,:task_id,:calling_process,:calling_place,
351: :amt,:percent,:rev_or_bill_date,:bea_id,:be_id,:request_id); end;'; /* Added for 3560805*/
352:
353: IF g1_debug_mode = 'Y' THEN
354: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver: before executing building the Pl/Sql block :'||proc_stmt);
355: END IF;
356: x_error_message := 'Error during parsing the dynamic PL/SQL.';
357: dbms_sql.parse(c, proc_stmt, dbms_sql.native);
358:

Line 381: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver: After building the Pl/Sql block :');

377: row_processed := dbms_sql.execute(c);
378:
379:
380: IF g1_debug_mode = 'Y' THEN
381: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver: After building the Pl/Sql block :');
382: END IF;
383: EXCEPTION
384: WHEN NO_FUNDING THEN
385: IF g1_debug_mode = 'Y' THEN

Line 386: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver: Inside the error :');

382: END IF;
383: EXCEPTION
384: WHEN NO_FUNDING THEN
385: IF g1_debug_mode = 'Y' THEN
386: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver: Inside the error :');
387: END IF;
388: X_error_message := 'There is no funding';
389: -- DBMS_OUTPUT.PUT_LINE(SQLERRM);
390: WHEN OTHERS THEN

Line 393: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver: Inside the others error :');

389: -- DBMS_OUTPUT.PUT_LINE(SQLERRM);
390: WHEN OTHERS THEN
391: -- DBMS_OUTPUT.PUT_LINE(SQLERRM);
392: IF g1_debug_mode = 'Y' THEN
393: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver: Inside the others error :');
394: END IF;
395: dbms_sql.close_cursor(c);
396: RAISE;
397: END;

Line 412: PA_MCB_INVOICE_PKG.log_message('Exiting from pa_billing.bill_ext_driver :');

408: x_error_message := 'OK';
409: end if;
410:
411: IF g1_debug_mode = 'Y' THEN
412: PA_MCB_INVOICE_PKG.log_message('Exiting from pa_billing.bill_ext_driver :');
413: END IF;
414: EXCEPTION
415: WHEN OTHERS THEN
416: -- DBMS_OUTPUT.PUT_LINE(SQLERRM);

Line 418: PA_MCB_INVOICE_PKG.log_message('Inside main others error pa_billing.bill_ext_driver :');

414: EXCEPTION
415: WHEN OTHERS THEN
416: -- DBMS_OUTPUT.PUT_LINE(SQLERRM);
417: IF g1_debug_mode = 'Y' THEN
418: PA_MCB_INVOICE_PKG.log_message('Inside main others error pa_billing.bill_ext_driver :');
419: END IF;
420: RAISE;
421: end bill_ext_driver;
422:

Line 453: -- The cost and revenue budget type codes used by the pa_billing_pub.get_budget_amount procedure

449: Amount_Left REAL := 0;
450:
451: event_description VARCHAR2(240);
452: --
453: -- The cost and revenue budget type codes used by the pa_billing_pub.get_budget_amount procedure
454: --
455: l_cost_budget_type_code VARCHAR2(30);
456: l_rev_budget_type_code VARCHAR2(30);
457: l_currency_code VARCHAR2(15);

Line 502: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.ccrev :');

498: --
499: l_status := 0;
500: l_error_message := NULL;
501: IF g1_debug_mode = 'Y' THEN
502: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.ccrev :');
503: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Project Id :'||to_char(X_project_id));
504: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Top Task Id :'||to_char(X_top_task_id));
505: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Calling process :'||X_calling_process);
506: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Calling place :'||X_calling_place);

Line 503: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Project Id :'||to_char(X_project_id));

499: l_status := 0;
500: l_error_message := NULL;
501: IF g1_debug_mode = 'Y' THEN
502: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.ccrev :');
503: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Project Id :'||to_char(X_project_id));
504: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Top Task Id :'||to_char(X_top_task_id));
505: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Calling process :'||X_calling_process);
506: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Calling place :'||X_calling_place);
507: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Amount :'||to_char(X_amount));

Line 504: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Top Task Id :'||to_char(X_top_task_id));

500: l_error_message := NULL;
501: IF g1_debug_mode = 'Y' THEN
502: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.ccrev :');
503: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Project Id :'||to_char(X_project_id));
504: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Top Task Id :'||to_char(X_top_task_id));
505: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Calling process :'||X_calling_process);
506: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Calling place :'||X_calling_place);
507: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Amount :'||to_char(X_amount));
508: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Percentage :'||to_char(X_percentage));

Line 505: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Calling process :'||X_calling_process);

501: IF g1_debug_mode = 'Y' THEN
502: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.ccrev :');
503: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Project Id :'||to_char(X_project_id));
504: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Top Task Id :'||to_char(X_top_task_id));
505: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Calling process :'||X_calling_process);
506: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Calling place :'||X_calling_place);
507: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Amount :'||to_char(X_amount));
508: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Percentage :'||to_char(X_percentage));
509: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev rev_or_bill_date :'||to_char(X_rev_or_bill_date,'YYYY/MM/DD'));

Line 506: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Calling place :'||X_calling_place);

502: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.ccrev :');
503: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Project Id :'||to_char(X_project_id));
504: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Top Task Id :'||to_char(X_top_task_id));
505: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Calling process :'||X_calling_process);
506: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Calling place :'||X_calling_place);
507: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Amount :'||to_char(X_amount));
508: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Percentage :'||to_char(X_percentage));
509: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev rev_or_bill_date :'||to_char(X_rev_or_bill_date,'YYYY/MM/DD'));
510: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev billing_assignment_id :'||to_char(X_billing_assignment_id));

Line 507: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Amount :'||to_char(X_amount));

503: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Project Id :'||to_char(X_project_id));
504: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Top Task Id :'||to_char(X_top_task_id));
505: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Calling process :'||X_calling_process);
506: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Calling place :'||X_calling_place);
507: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Amount :'||to_char(X_amount));
508: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Percentage :'||to_char(X_percentage));
509: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev rev_or_bill_date :'||to_char(X_rev_or_bill_date,'YYYY/MM/DD'));
510: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev billing_assignment_id :'||to_char(X_billing_assignment_id));
511: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev billing_extension_id :'||to_char(X_billing_extension_id));

Line 508: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Percentage :'||to_char(X_percentage));

504: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Top Task Id :'||to_char(X_top_task_id));
505: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Calling process :'||X_calling_process);
506: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Calling place :'||X_calling_place);
507: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Amount :'||to_char(X_amount));
508: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Percentage :'||to_char(X_percentage));
509: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev rev_or_bill_date :'||to_char(X_rev_or_bill_date,'YYYY/MM/DD'));
510: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev billing_assignment_id :'||to_char(X_billing_assignment_id));
511: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev billing_extension_id :'||to_char(X_billing_extension_id));
512: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev request_id :'||to_char(X_request_id));

Line 509: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev rev_or_bill_date :'||to_char(X_rev_or_bill_date,'YYYY/MM/DD'));

505: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Calling process :'||X_calling_process);
506: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Calling place :'||X_calling_place);
507: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Amount :'||to_char(X_amount));
508: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Percentage :'||to_char(X_percentage));
509: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev rev_or_bill_date :'||to_char(X_rev_or_bill_date,'YYYY/MM/DD'));
510: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev billing_assignment_id :'||to_char(X_billing_assignment_id));
511: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev billing_extension_id :'||to_char(X_billing_extension_id));
512: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev request_id :'||to_char(X_request_id));
513: END IF;

Line 510: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev billing_assignment_id :'||to_char(X_billing_assignment_id));

506: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Calling place :'||X_calling_place);
507: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Amount :'||to_char(X_amount));
508: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Percentage :'||to_char(X_percentage));
509: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev rev_or_bill_date :'||to_char(X_rev_or_bill_date,'YYYY/MM/DD'));
510: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev billing_assignment_id :'||to_char(X_billing_assignment_id));
511: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev billing_extension_id :'||to_char(X_billing_extension_id));
512: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev request_id :'||to_char(X_request_id));
513: END IF;
514: /*****

Line 511: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev billing_extension_id :'||to_char(X_billing_extension_id));

507: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Amount :'||to_char(X_amount));
508: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Percentage :'||to_char(X_percentage));
509: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev rev_or_bill_date :'||to_char(X_rev_or_bill_date,'YYYY/MM/DD'));
510: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev billing_assignment_id :'||to_char(X_billing_assignment_id));
511: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev billing_extension_id :'||to_char(X_billing_extension_id));
512: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev request_id :'||to_char(X_request_id));
513: END IF;
514: /*****
515: l_cost_budget_type_code := 'AC';

Line 512: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev request_id :'||to_char(X_request_id));

508: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Percentage :'||to_char(X_percentage));
509: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev rev_or_bill_date :'||to_char(X_rev_or_bill_date,'YYYY/MM/DD'));
510: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev billing_assignment_id :'||to_char(X_billing_assignment_id));
511: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev billing_extension_id :'||to_char(X_billing_extension_id));
512: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev request_id :'||to_char(X_request_id));
513: END IF;
514: /*****
515: l_cost_budget_type_code := 'AC';
516: l_rev_budget_type_code := 'AR';

Line 554: PA_MCB_INVOICE_PKG.log_message('Before select of pa billing params v pa_billing.ccrev :');

550: /* Till Here */
551:
552:
553: IF g1_debug_mode = 'Y' THEN
554: PA_MCB_INVOICE_PKG.log_message('Before select of pa billing params v pa_billing.ccrev :');
555: END IF;
556: /* Added for bug 2649456.Not handling exception intentionaly because if it is coming,
557: it will be data issue */
558: BEGIN

Line 561: FROM pa_billing_extn_params_v;

557: it will be data issue */
558: BEGIN
559: SELECT default_cost_plan_type_id,default_rev_plan_type_id
560: INTO l_cost_plan_type_id,l_rev_plan_type_id
561: FROM pa_billing_extn_params_v;
562: EXCEPTION
563: WHEN OTHERS THEN
564: IF g1_debug_mode = 'Y' THEN
565: PA_MCB_INVOICE_PKG.log_message('Error from pa_billing_extn_params_v pa_billing.ccrev :'||SQLERRM);

Line 565: PA_MCB_INVOICE_PKG.log_message('Error from pa_billing_extn_params_v pa_billing.ccrev :'||SQLERRM);

561: FROM pa_billing_extn_params_v;
562: EXCEPTION
563: WHEN OTHERS THEN
564: IF g1_debug_mode = 'Y' THEN
565: PA_MCB_INVOICE_PKG.log_message('Error from pa_billing_extn_params_v pa_billing.ccrev :'||SQLERRM);
566: END IF;
567: RAISE;
568: END;
569: /* till here */

Line 572: PA_MCB_INVOICE_PKG.log_message('pa billing params v.cost_plan_type_id pa_billing.ccrev :'||l_cost_plan_type_id);

568: END;
569: /* till here */
570:
571: IF g1_debug_mode = 'Y' THEN
572: PA_MCB_INVOICE_PKG.log_message('pa billing params v.cost_plan_type_id pa_billing.ccrev :'||l_cost_plan_type_id);
573: PA_MCB_INVOICE_PKG.log_message('pa billing params v.rev_plan_type_id pa_billing.ccrev :'||l_rev_plan_type_id);
574: PA_MCB_INVOICE_PKG.log_message('Before calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev :');
575: END IF;
576: pa_billing_pub.get_budget_amount(

Line 573: PA_MCB_INVOICE_PKG.log_message('pa billing params v.rev_plan_type_id pa_billing.ccrev :'||l_rev_plan_type_id);

569: /* till here */
570:
571: IF g1_debug_mode = 'Y' THEN
572: PA_MCB_INVOICE_PKG.log_message('pa billing params v.cost_plan_type_id pa_billing.ccrev :'||l_cost_plan_type_id);
573: PA_MCB_INVOICE_PKG.log_message('pa billing params v.rev_plan_type_id pa_billing.ccrev :'||l_rev_plan_type_id);
574: PA_MCB_INVOICE_PKG.log_message('Before calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev :');
575: END IF;
576: pa_billing_pub.get_budget_amount(
577: X2_project_id => X_project_id,

Line 574: PA_MCB_INVOICE_PKG.log_message('Before calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev :');

570:
571: IF g1_debug_mode = 'Y' THEN
572: PA_MCB_INVOICE_PKG.log_message('pa billing params v.cost_plan_type_id pa_billing.ccrev :'||l_cost_plan_type_id);
573: PA_MCB_INVOICE_PKG.log_message('pa billing params v.rev_plan_type_id pa_billing.ccrev :'||l_rev_plan_type_id);
574: PA_MCB_INVOICE_PKG.log_message('Before calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev :');
575: END IF;
576: pa_billing_pub.get_budget_amount(
577: X2_project_id => X_project_id,
578: X2_task_id => X_top_task_id,

Line 576: pa_billing_pub.get_budget_amount(

572: PA_MCB_INVOICE_PKG.log_message('pa billing params v.cost_plan_type_id pa_billing.ccrev :'||l_cost_plan_type_id);
573: PA_MCB_INVOICE_PKG.log_message('pa billing params v.rev_plan_type_id pa_billing.ccrev :'||l_rev_plan_type_id);
574: PA_MCB_INVOICE_PKG.log_message('Before calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev :');
575: END IF;
576: pa_billing_pub.get_budget_amount(
577: X2_project_id => X_project_id,
578: X2_task_id => X_top_task_id,
579: X2_revenue_amount => budget_revenue,
580: X2_cost_amount => budget_cost,

Line 589: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev budget_revenue :'||to_char(budget_revenue));

585: X_error_message => l_error_message,
586: X_status => l_status);
587:
588: IF g1_debug_mode = 'Y' THEN
589: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev budget_revenue :'||to_char(budget_revenue));
590: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev budget_cost :'||to_char(budget_cost));
591: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev l_cost_budget_type_code :'||l_cost_budget_type_code);
592: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev budget_cost l_rev_budget_type_code :'||l_rev_budget_type_code);
593: END IF;

Line 590: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev budget_cost :'||to_char(budget_cost));

586: X_status => l_status);
587:
588: IF g1_debug_mode = 'Y' THEN
589: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev budget_revenue :'||to_char(budget_revenue));
590: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev budget_cost :'||to_char(budget_cost));
591: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev l_cost_budget_type_code :'||l_cost_budget_type_code);
592: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev budget_cost l_rev_budget_type_code :'||l_rev_budget_type_code);
593: END IF;
594: -- If get budget amount return an error its fatal.

Line 591: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev l_cost_budget_type_code :'||l_cost_budget_type_code);

587:
588: IF g1_debug_mode = 'Y' THEN
589: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev budget_revenue :'||to_char(budget_revenue));
590: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev budget_cost :'||to_char(budget_cost));
591: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev l_cost_budget_type_code :'||l_cost_budget_type_code);
592: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev budget_cost l_rev_budget_type_code :'||l_rev_budget_type_code);
593: END IF;
594: -- If get budget amount return an error its fatal.
595:

Line 592: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev budget_cost l_rev_budget_type_code :'||l_rev_budget_type_code);

588: IF g1_debug_mode = 'Y' THEN
589: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev budget_revenue :'||to_char(budget_revenue));
590: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev budget_cost :'||to_char(budget_cost));
591: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev l_cost_budget_type_code :'||l_cost_budget_type_code);
592: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev budget_cost l_rev_budget_type_code :'||l_rev_budget_type_code);
593: END IF;
594: -- If get budget amount return an error its fatal.
595:
596: IF l_status <> 0 THEN

Line 601: PA_MCB_INVOICE_PKG.log_message('Before calling pa_billing_amount.PotEventAmount inside pa_billing.ccrev :');

597: raise ccrev_error;
598: END IF;
599:
600: IF g1_debug_mode = 'Y' THEN
601: PA_MCB_INVOICE_PKG.log_message('Before calling pa_billing_amount.PotEventAmount inside pa_billing.ccrev :');
602: END IF;
603: pa_billing_amount.PotEventAmount(
604: X2_project_id => X_project_id,
605: X2_task_id => X_top_task_id,

Line 603: pa_billing_amount.PotEventAmount(

599:
600: IF g1_debug_mode = 'Y' THEN
601: PA_MCB_INVOICE_PKG.log_message('Before calling pa_billing_amount.PotEventAmount inside pa_billing.ccrev :');
602: END IF;
603: pa_billing_amount.PotEventAmount(
604: X2_project_id => X_project_id,
605: X2_task_id => X_top_task_id,
606: X2_accrue_through_date => X_rev_or_bill_date,
607: X2_revenue_amount => event_revenue,

Line 611: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_amount.PotEventAmount inside pa_billing.ccrev event_revenue :'||to_char(event_revenue));

607: X2_revenue_amount => event_revenue,
608: X2_invoice_amount => event_invoice);
609:
610: IF g1_debug_mode = 'Y' THEN
611: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_amount.PotEventAmount inside pa_billing.ccrev event_revenue :'||to_char(event_revenue));
612: PA_MCB_INVOICE_PKG.log_message('Before calling pa_billing_amount.CostAmount inside pa_billing.ccrev event_invoice :'||to_char(event_invoice));
613: END IF;
614: pa_billing_amount.CostAmount(
615: X2_project_id => X_project_id,

Line 612: PA_MCB_INVOICE_PKG.log_message('Before calling pa_billing_amount.CostAmount inside pa_billing.ccrev event_invoice :'||to_char(event_invoice));

608: X2_invoice_amount => event_invoice);
609:
610: IF g1_debug_mode = 'Y' THEN
611: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_amount.PotEventAmount inside pa_billing.ccrev event_revenue :'||to_char(event_revenue));
612: PA_MCB_INVOICE_PKG.log_message('Before calling pa_billing_amount.CostAmount inside pa_billing.ccrev event_invoice :'||to_char(event_invoice));
613: END IF;
614: pa_billing_amount.CostAmount(
615: X2_project_id => X_project_id,
616: X2_task_id => X_top_task_id,

Line 614: pa_billing_amount.CostAmount(

610: IF g1_debug_mode = 'Y' THEN
611: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_amount.PotEventAmount inside pa_billing.ccrev event_revenue :'||to_char(event_revenue));
612: PA_MCB_INVOICE_PKG.log_message('Before calling pa_billing_amount.CostAmount inside pa_billing.ccrev event_invoice :'||to_char(event_invoice));
613: END IF;
614: pa_billing_amount.CostAmount(
615: X2_project_id => X_project_id,
616: X2_task_id => X_top_task_id,
617: X2_accrue_through_date => X_rev_or_bill_date,
618: X2_cost_amount => cost_amount);

Line 620: PA_MCB_INVOICE_PKG.log_message('After pa_billing_amount.CostAmount inside pa_billing.ccrev cost_amount :'||to_char(cost_amount));

616: X2_task_id => X_top_task_id,
617: X2_accrue_through_date => X_rev_or_bill_date,
618: X2_cost_amount => cost_amount);
619: IF g1_debug_mode = 'Y' THEN
620: PA_MCB_INVOICE_PKG.log_message('After pa_billing_amount.CostAmount inside pa_billing.ccrev cost_amount :'||to_char(cost_amount));
621: END IF;
622:
623: Amount_Left := pa_billing_amount.LowestAmountLeft(
624: X_project_id,

Line 623: Amount_Left := pa_billing_amount.LowestAmountLeft(

619: IF g1_debug_mode = 'Y' THEN
620: PA_MCB_INVOICE_PKG.log_message('After pa_billing_amount.CostAmount inside pa_billing.ccrev cost_amount :'||to_char(cost_amount));
621: END IF;
622:
623: Amount_Left := pa_billing_amount.LowestAmountLeft(
624: X_project_id,
625: X_top_task_id,
626: X_calling_process);
627:

Line 629: PA_MCB_INVOICE_PKG.log_message('After pa_billing_amount.LowestAmountLeft inside pa_billing.ccrev Amount_Left :'||to_char(Amount_Left));

625: X_top_task_id,
626: X_calling_process);
627:
628: IF g1_debug_mode = 'Y' THEN
629: PA_MCB_INVOICE_PKG.log_message('After pa_billing_amount.LowestAmountLeft inside pa_billing.ccrev Amount_Left :'||to_char(Amount_Left));
630: END IF;
631: -- DBMS_OUTPUT.PUT('Revenue =');
632: -- DBMS_OUTPUT.PUT_LINE(Revenue);
633: -- DBMS_OUTPUT.PUT('Amount_Left=');

Line 648: pa_billing_amount.RevenueAmount(

644: -- DBMS_OUTPUT.PUT_LINE(event_revenue);
645:
646:
647: IF (X_calling_process = 'Revenue') THEN
648: pa_billing_amount.RevenueAmount(
649: X2_project_id => x_project_id,
650: X2_task_id => X_top_task_id,
651: X2_revenue_amount => revenue_amount);
652:

Line 654: PA_MCB_INVOICE_PKG.log_message('After call of pa_billing_amount.RevenueAmount inside pa_billing.ccrev revenue_amount 1 :'||to_char(revenue_amount));

650: X2_task_id => X_top_task_id,
651: X2_revenue_amount => revenue_amount);
652:
653: IF g1_debug_mode = 'Y' THEN
654: PA_MCB_INVOICE_PKG.log_message('After call of pa_billing_amount.RevenueAmount inside pa_billing.ccrev revenue_amount 1 :'||to_char(revenue_amount));
655: END IF;
656: IF (budget_cost <> 0) THEN
657: -- Take the lower of what you should insert based on cost-cost algorithm,
658: -- of revenue = (cost/budget_cost) * (budget_revenue - event_revenue)

Line 673: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.ccrev calculating Revenue ( Least) Revenue 2 :'||to_char(Revenue));

669: Amount_Left
670: );
671:
672: IF g1_debug_mode = 'Y' THEN
673: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.ccrev calculating Revenue ( Least) Revenue 2 :'||to_char(Revenue));
674: END IF;
675:
676: /* Changed the length of the format mask for amount_left column from 15 to 22
677: to fix the bug 2124494 for MCB2 */

Line 680: Event_Description := pa_billing_values.get_message('CCREV_DESCRIPTION')|| '(' ||

676: /* Changed the length of the format mask for amount_left column from 15 to 22
677: to fix the bug 2124494 for MCB2 */
678: /* Changed the length of the format mask for all column from 15 to 22
679: to fix the bug 2162900 for MCB2 */
680: Event_Description := pa_billing_values.get_message('CCREV_DESCRIPTION')|| '(' ||
681: to_char(amount_left,fnd_currency.get_format_mask(l_currency_code,22))
682: || ' ,((' ||
683: to_char(cost_amount,fnd_currency.get_format_mask(l_currency_code,22))
684: || '/' ||

Line 694: PA_MCB_INVOICE_PKG.log_message('rev part Inside Revenue part pa_billing.ccrev Event desc :'||Event_Description);

690: || ')) - '||
691: to_char(nvl(revenue_amount,0),fnd_currency.get_format_mask(l_currency_code,22))
692: || ' ))';
693: IF g1_debug_mode = 'Y' THEN
694: PA_MCB_INVOICE_PKG.log_message('rev part Inside Revenue part pa_billing.ccrev Event desc :'||Event_Description);
695: PA_MCB_INVOICE_PKG.log_message('Rev part Before insert pa_billing.ccrev.insert_event 1 :'||to_char(Revenue));
696: END IF;
697: -- Modified to add new parameters for insert_event
698: pa_billing_pub.insert_event (

Line 695: PA_MCB_INVOICE_PKG.log_message('Rev part Before insert pa_billing.ccrev.insert_event 1 :'||to_char(Revenue));

691: to_char(nvl(revenue_amount,0),fnd_currency.get_format_mask(l_currency_code,22))
692: || ' ))';
693: IF g1_debug_mode = 'Y' THEN
694: PA_MCB_INVOICE_PKG.log_message('rev part Inside Revenue part pa_billing.ccrev Event desc :'||Event_Description);
695: PA_MCB_INVOICE_PKG.log_message('Rev part Before insert pa_billing.ccrev.insert_event 1 :'||to_char(Revenue));
696: END IF;
697: -- Modified to add new parameters for insert_event
698: pa_billing_pub.insert_event (
699: X_rev_amt => Revenue,

Line 698: pa_billing_pub.insert_event (

694: PA_MCB_INVOICE_PKG.log_message('rev part Inside Revenue part pa_billing.ccrev Event desc :'||Event_Description);
695: PA_MCB_INVOICE_PKG.log_message('Rev part Before insert pa_billing.ccrev.insert_event 1 :'||to_char(Revenue));
696: END IF;
697: -- Modified to add new parameters for insert_event
698: pa_billing_pub.insert_event (
699: X_rev_amt => Revenue,
700: X_bill_amt => 0,
701: X_event_description => event_description,
702: X_audit_amount1 => amount_left,

Line 717: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event rev :'||to_char(revenue_amount));

713: X_status => l_status
714: );
715:
716: IF g1_debug_mode = 'Y' THEN
717: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event rev :'||to_char(revenue_amount));
718: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event budget rev :'||to_char(budget_revenue));
719: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event amt left :'||to_char(amount_left));
720: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event evt rev :'||to_char(event_revenue));
721: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event budget cost :'||to_char(budget_cost));

Line 718: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event budget rev :'||to_char(budget_revenue));

714: );
715:
716: IF g1_debug_mode = 'Y' THEN
717: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event rev :'||to_char(revenue_amount));
718: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event budget rev :'||to_char(budget_revenue));
719: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event amt left :'||to_char(amount_left));
720: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event evt rev :'||to_char(event_revenue));
721: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event budget cost :'||to_char(budget_cost));
722: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event cst amt :'||to_char(cost_amount));

Line 719: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event amt left :'||to_char(amount_left));

715:
716: IF g1_debug_mode = 'Y' THEN
717: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event rev :'||to_char(revenue_amount));
718: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event budget rev :'||to_char(budget_revenue));
719: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event amt left :'||to_char(amount_left));
720: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event evt rev :'||to_char(event_revenue));
721: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event budget cost :'||to_char(budget_cost));
722: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event cst amt :'||to_char(cost_amount));
723: END IF;

Line 720: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event evt rev :'||to_char(event_revenue));

716: IF g1_debug_mode = 'Y' THEN
717: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event rev :'||to_char(revenue_amount));
718: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event budget rev :'||to_char(budget_revenue));
719: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event amt left :'||to_char(amount_left));
720: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event evt rev :'||to_char(event_revenue));
721: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event budget cost :'||to_char(budget_cost));
722: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event cst amt :'||to_char(cost_amount));
723: END IF;
724: IF l_status <> 0 THEN

Line 721: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event budget cost :'||to_char(budget_cost));

717: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event rev :'||to_char(revenue_amount));
718: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event budget rev :'||to_char(budget_revenue));
719: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event amt left :'||to_char(amount_left));
720: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event evt rev :'||to_char(event_revenue));
721: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event budget cost :'||to_char(budget_cost));
722: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event cst amt :'||to_char(cost_amount));
723: END IF;
724: IF l_status <> 0 THEN
725: raise ccrev_error;

Line 722: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event cst amt :'||to_char(cost_amount));

718: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event budget rev :'||to_char(budget_revenue));
719: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event amt left :'||to_char(amount_left));
720: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event evt rev :'||to_char(event_revenue));
721: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event budget cost :'||to_char(budget_cost));
722: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event cst amt :'||to_char(cost_amount));
723: END IF;
724: IF l_status <> 0 THEN
725: raise ccrev_error;
726: END IF;

Line 731: pa_billing_amount.InvoiceAmount(

727:
728: END IF;
729:
730: ELSE
731: pa_billing_amount.InvoiceAmount(
732: X2_project_id => X_project_id,
733: X2_task_id => X_top_task_id,
734: X2_invoice_amount => invoice_amount);
735:

Line 737: PA_MCB_INVOICE_PKG.log_message('After the call of pa_billing_amount.InvoiceAmount inside pa_billing.ccrev :'||to_char(invoice_amount));

733: X2_task_id => X_top_task_id,
734: X2_invoice_amount => invoice_amount);
735:
736: IF g1_debug_mode = 'Y' THEN
737: PA_MCB_INVOICE_PKG.log_message('After the call of pa_billing_amount.InvoiceAmount inside pa_billing.ccrev :'||to_char(invoice_amount));
738: END IF;
739: IF (budget_cost <> 0) THEN
740: Invoice := Least( ( (nvl(cost_amount,0)/budget_cost)
741: * greatest( (nvl(budget_revenue,0)

Line 748: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.ccrev calculating Invoice (Least) :'||to_char(Invoice));

744: nvl(Amount_Left,0)
745: );
746:
747: IF g1_debug_mode = 'Y' THEN
748: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.ccrev calculating Invoice (Least) :'||to_char(Invoice));
749: END IF;
750: /* Changed the length of the format mask for amount_left column from 15 to 22
751: to fix the bug 2124494 for MCB2 */
752: /* Changed the length of the format mask for all column from 15 to 22

Line 754: Event_Description := pa_billing_values.get_message('CCREV_DESCRIPTION')|| '(' ||

750: /* Changed the length of the format mask for amount_left column from 15 to 22
751: to fix the bug 2124494 for MCB2 */
752: /* Changed the length of the format mask for all column from 15 to 22
753: to fix the bug 2162900 for MCB2 */
754: Event_Description := pa_billing_values.get_message('CCREV_DESCRIPTION')|| '(' ||
755: to_char(amount_left,fnd_currency.get_format_mask(l_currency_code,22))
756: || ' ,((' ||
757: to_char(cost_amount,fnd_currency.get_format_mask(l_currency_code,22))
758: || '/' ||

Line 769: PA_MCB_INVOICE_PKG.log_message('inv part Inside Revenue part pa_billing.ccrev Event desc :'||Event_Description);

765: to_char(nvl(invoice_amount,0),fnd_currency.get_format_mask(l_currency_code,22))
766: || ' ))';
767:
768: IF g1_debug_mode = 'Y' THEN
769: PA_MCB_INVOICE_PKG.log_message('inv part Inside Revenue part pa_billing.ccrev Event desc :'||Event_Description);
770: PA_MCB_INVOICE_PKG.log_message('inv part before insert pa_billing.ccrev.insert_event inv 2 :'||to_char(Invoice));
771: END IF;
772: pa_billing_pub.insert_event (
773: X_rev_amt => 0,

Line 770: PA_MCB_INVOICE_PKG.log_message('inv part before insert pa_billing.ccrev.insert_event inv 2 :'||to_char(Invoice));

766: || ' ))';
767:
768: IF g1_debug_mode = 'Y' THEN
769: PA_MCB_INVOICE_PKG.log_message('inv part Inside Revenue part pa_billing.ccrev Event desc :'||Event_Description);
770: PA_MCB_INVOICE_PKG.log_message('inv part before insert pa_billing.ccrev.insert_event inv 2 :'||to_char(Invoice));
771: END IF;
772: pa_billing_pub.insert_event (
773: X_rev_amt => 0,
774: X_bill_amt => Invoice,

Line 772: pa_billing_pub.insert_event (

768: IF g1_debug_mode = 'Y' THEN
769: PA_MCB_INVOICE_PKG.log_message('inv part Inside Revenue part pa_billing.ccrev Event desc :'||Event_Description);
770: PA_MCB_INVOICE_PKG.log_message('inv part before insert pa_billing.ccrev.insert_event inv 2 :'||to_char(Invoice));
771: END IF;
772: pa_billing_pub.insert_event (
773: X_rev_amt => 0,
774: X_bill_amt => Invoice,
775: X_event_description => Event_Description,
776: X_audit_amount1 => amount_left,

Line 791: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event inv 2 :'||to_char(invoice_amount));

787: X_status => l_status
788: );
789:
790: IF g1_debug_mode = 'Y' THEN
791: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event inv 2 :'||to_char(invoice_amount));
792: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event bud rev 2 :'||to_char(budget_revenue));
793: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event amt lft 2 :'||to_char(amount_left));
794: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event evt inv 2 :'||to_char(event_invoice));
795: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event bd cst 2 :'||to_char(budget_cost));

Line 792: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event bud rev 2 :'||to_char(budget_revenue));

788: );
789:
790: IF g1_debug_mode = 'Y' THEN
791: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event inv 2 :'||to_char(invoice_amount));
792: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event bud rev 2 :'||to_char(budget_revenue));
793: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event amt lft 2 :'||to_char(amount_left));
794: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event evt inv 2 :'||to_char(event_invoice));
795: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event bd cst 2 :'||to_char(budget_cost));
796: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event cst amt 2 :'||to_char(cost_amount));

Line 793: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event amt lft 2 :'||to_char(amount_left));

789:
790: IF g1_debug_mode = 'Y' THEN
791: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event inv 2 :'||to_char(invoice_amount));
792: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event bud rev 2 :'||to_char(budget_revenue));
793: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event amt lft 2 :'||to_char(amount_left));
794: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event evt inv 2 :'||to_char(event_invoice));
795: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event bd cst 2 :'||to_char(budget_cost));
796: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event cst amt 2 :'||to_char(cost_amount));
797: END IF;

Line 794: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event evt inv 2 :'||to_char(event_invoice));

790: IF g1_debug_mode = 'Y' THEN
791: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event inv 2 :'||to_char(invoice_amount));
792: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event bud rev 2 :'||to_char(budget_revenue));
793: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event amt lft 2 :'||to_char(amount_left));
794: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event evt inv 2 :'||to_char(event_invoice));
795: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event bd cst 2 :'||to_char(budget_cost));
796: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event cst amt 2 :'||to_char(cost_amount));
797: END IF;
798: IF l_status <> 0 THEN

Line 795: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event bd cst 2 :'||to_char(budget_cost));

791: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event inv 2 :'||to_char(invoice_amount));
792: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event bud rev 2 :'||to_char(budget_revenue));
793: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event amt lft 2 :'||to_char(amount_left));
794: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event evt inv 2 :'||to_char(event_invoice));
795: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event bd cst 2 :'||to_char(budget_cost));
796: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event cst amt 2 :'||to_char(cost_amount));
797: END IF;
798: IF l_status <> 0 THEN
799: raise ccrev_error;

Line 796: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event cst amt 2 :'||to_char(cost_amount));

792: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event bud rev 2 :'||to_char(budget_revenue));
793: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event amt lft 2 :'||to_char(amount_left));
794: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event evt inv 2 :'||to_char(event_invoice));
795: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event bd cst 2 :'||to_char(budget_cost));
796: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event cst amt 2 :'||to_char(cost_amount));
797: END IF;
798: IF l_status <> 0 THEN
799: raise ccrev_error;
800: END IF;

Line 806: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing.ccrev :');

802: END IF;
803: END IF;
804:
805: IF g1_debug_mode = 'Y' THEN
806: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing.ccrev :');
807: END IF;
808: EXCEPTION
809: WHEN ccrev_error THEN
810: NULL;

Line 834: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.Delete_Automatic_Events :');

830:
831: -- Bug#1165176 Added condition line_num_reversed is null
832:
833: IF g1_debug_mode = 'Y' THEN
834: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.Delete_Automatic_Events :');
835: END IF;
836: IF (X_calling_Process = 'Revenue') THEN
837: DELETE from pa_events v
838: WHERE v.project_id = X_project_id

Line 853: PA_MCB_INVOICE_PKG.log_message('Deleted Revenue pa_billing.Delete_Automatic_Events :');

849: WHERE vt.event_type_classification||'' = 'AUTOMATIC'
850: AND vt.event_type = v.event_type)
851: AND v.calling_process = X_calling_process;
852: IF g1_debug_mode = 'Y' THEN
853: PA_MCB_INVOICE_PKG.log_message('Deleted Revenue pa_billing.Delete_Automatic_Events :');
854: END IF;
855: ELSE
856: -- DBMS_OUTPUT.PUT_LINE('Deleting Invoice Events');
857:

Line 873: PA_MCB_INVOICE_PKG.log_message('Deleted Invoice pa_billing.Delete_Automatic_Events :');

869: AND V.Bill_Amount <> 0
870: AND V.calling_process = X_calling_process;
871:
872: IF g1_debug_mode = 'Y' THEN
873: PA_MCB_INVOICE_PKG.log_message('Deleted Invoice pa_billing.Delete_Automatic_Events :');
874: END IF;
875: -- This last part is to ensure that we delete only events that were created
876: -- by Invoice as per the adjustment model for Billing Extensions.
877:

Line 883: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing.Delete_Automatic_Events :');

879:
880: -- commit;
881:
882: IF g1_debug_mode = 'Y' THEN
883: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing.Delete_Automatic_Events :');
884: END IF;
885: END Delete_Automatic_Events;
886:
887:

Line 906: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.Call_Calc_Bill_Amount :');

902:
903: BEGIN
904: /* Change the call and aded new paras in this procs. for MCB2 */
905: IF g1_debug_mode = 'Y' THEN
906: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.Call_Calc_Bill_Amount :');
907: END IF;
908: pa_client_extn_billing.Calc_Bill_Amount(
909: x_transaction_type => x_transaction_type,
910: x_expenditure_item_id => x_expenditure_item_id,

Line 930: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing.Call_Calc_Bill_Amount :');

926: currency
927: x_amount := pa_currency.round_currency_amt(x_amount);*/
928:
929: IF g1_debug_mode = 'Y' THEN
930: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing.Call_Calc_Bill_Amount :');
931: END IF;
932: EXCEPTION WHEN OTHERS THEN
933: -- DBMS_OUTPUT.PUT(SQLERRM);
934: RAISE;

Line 1159: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS :');

1155: dii.project_currency_code,dii.funding_currency_code; /* MCB related changes */
1156:
1157: BEGIN
1158: IF g1_debug_mode = 'Y' THEN
1159: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS :');
1160: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS X_option : '||X_option);
1161: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS X_proj_id : '||X_proj_id);
1162: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS X_start_proj_num : '||X_start_proj_num);
1163: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS X_end_proj_num : '||X_end_proj_num);

Line 1160: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS X_option : '||X_option);

1156:
1157: BEGIN
1158: IF g1_debug_mode = 'Y' THEN
1159: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS :');
1160: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS X_option : '||X_option);
1161: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS X_proj_id : '||X_proj_id);
1162: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS X_start_proj_num : '||X_start_proj_num);
1163: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS X_end_proj_num : '||X_end_proj_num);
1164: END IF;

Line 1161: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS X_proj_id : '||X_proj_id);

1157: BEGIN
1158: IF g1_debug_mode = 'Y' THEN
1159: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS :');
1160: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS X_option : '||X_option);
1161: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS X_proj_id : '||X_proj_id);
1162: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS X_start_proj_num : '||X_start_proj_num);
1163: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS X_end_proj_num : '||X_end_proj_num);
1164: END IF;
1165:

Line 1162: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS X_start_proj_num : '||X_start_proj_num);

1158: IF g1_debug_mode = 'Y' THEN
1159: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS :');
1160: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS X_option : '||X_option);
1161: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS X_proj_id : '||X_proj_id);
1162: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS X_start_proj_num : '||X_start_proj_num);
1163: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS X_end_proj_num : '||X_end_proj_num);
1164: END IF;
1165:
1166: -- OPEN sel_proj; Commented for bug 3372249

Line 1163: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS X_end_proj_num : '||X_end_proj_num);

1159: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS :');
1160: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS X_option : '||X_option);
1161: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS X_proj_id : '||X_proj_id);
1162: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS X_start_proj_num : '||X_start_proj_num);
1163: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS X_end_proj_num : '||X_end_proj_num);
1164: END IF;
1165:
1166: -- OPEN sel_proj; Commented for bug 3372249
1167:

Line 1189: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.CHECK_SPF_AMOUNTS cursor sel_proj : ');

1185: END IF;
1186: /* End of fix for bug 3372249 */
1187:
1188: IF g1_debug_mode = 'Y' THEN
1189: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.CHECK_SPF_AMOUNTS cursor sel_proj : ');
1190: END IF;
1191:
1192: -- EXIT WHEN sel_proj%NOTFOUND; Commented for bug 3372249
1193: /* Start of fix for bug 3372249 */

Line 1210: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.CHECK_SPF_AMOUNTS cursor spf_acc_0 : ');

1206: -----------------------------------------------------------------------*/
1207: FOR acc_0_rec in spf_acc_0 LOOP
1208:
1209: IF g1_debug_mode = 'Y' THEN
1210: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.CHECK_SPF_AMOUNTS cursor spf_acc_0 : ');
1211: END IF;
1212: UPDATE pa_summary_project_fundings pf
1213: SET pf.total_accrued_amount = 0,
1214: pf.revproc_accrued_amount = 0, /* MCB related changes */

Line 1232: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.CHECK_SPF_AMOUNTS cursor spf_acc_amt : ');

1228: FOR acc_amt_rec in spf_acc_amt LOOP
1229: /* This new currency procs. is being used which covers the MCB2 as well as old functionality */
1230:
1231: IF g1_debug_mode = 'Y' THEN
1232: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.CHECK_SPF_AMOUNTS cursor spf_acc_amt : ');
1233: END IF;
1234: UPDATE pa_summary_project_fundings pf
1235: SET pf.total_accrued_amount =
1236: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT

Line 1267: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.CHECK_SPF_AMOUNTS cursor spf_bill_0 : ');

1263:
1264: FOR bill_0_rec in spf_bill_0 LOOP
1265:
1266: IF g1_debug_mode = 'Y' THEN
1267: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.CHECK_SPF_AMOUNTS cursor spf_bill_0 : ');
1268: END IF;
1269: UPDATE pa_summary_project_fundings pf
1270: SET pf.total_billed_amount = 0,
1271: pf.invproc_billed_amount = 0, /* MCB related changes */

Line 1289: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.CHECK_SPF_AMOUNTS cursor spf_pl_bill_amt : ');

1285: FOR pl_bill_amt_rec in spf_pl_bill_amt LOOP
1286: /* This new currency procs. is being used which covers the MCB2 as well as old functionality */
1287:
1288: IF g1_debug_mode = 'Y' THEN
1289: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.CHECK_SPF_AMOUNTS cursor spf_pl_bill_amt : ');
1290: END IF;
1291: UPDATE pa_summary_project_fundings pf
1292: SET pf.total_billed_amount =
1293: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT

Line 1321: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.CHECK_SPF_AMOUNTS cursor spf_tl_bill_amt : ');

1317:
1318: /* This new currency procs. is being used which covers the MCB2 as well as old functionality */
1319:
1320: IF g1_debug_mode = 'Y' THEN
1321: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.CHECK_SPF_AMOUNTS cursor spf_tl_bill_amt : ');
1322: END IF;
1323:
1324: UPDATE pa_summary_project_fundings pf
1325: SET pf.total_billed_amount =

Line 1358: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing.CHECK_SPF_AMOUNTS :');

1354: END IF;
1355: /* End of fix for bug 3372249 */
1356:
1357: IF g1_debug_mode = 'Y' THEN
1358: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing.CHECK_SPF_AMOUNTS :');
1359: END IF;
1360: EXCEPTION
1361: WHEN OTHERS THEN
1362: -- CLOSE sel_proj; Commented for bug 3372249

Line 1404: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.Get_WriteOff_Revenue_Amount :');

1400:
1401: BEGIN
1402:
1403: IF g1_debug_mode = 'Y' THEN
1404: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.Get_WriteOff_Revenue_Amount :');
1405: END IF;
1406: BEGIN
1407:
1408: IF p_task_id IS NOT NULL THEN

Line 1605: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing.Get_WriteOff_Revenue_Amount :');

1601:
1602: END IF;
1603:
1604: IF g1_debug_mode = 'Y' THEN
1605: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing.Get_WriteOff_Revenue_Amount :');
1606: END IF;
1607: EXCEPTION
1608:
1609: WHEN OTHERS THEN

Line 1738: pa_billing.Call_Calc_Bill_Amount( 'ACTUAL',ei_id( j ),

1734: /* Indicator variables Bug# 634414 */
1735: NC := 1204;
1736: /* MCB Changes : Added the new param to the procedure Call_Calc_Bill_Amount
1737: */
1738: pa_billing.Call_Calc_Bill_Amount( 'ACTUAL',ei_id( j ),
1739: sys_linkage_func,
1740: amount,
1741: bill_rate_flag,
1742: status,

Line 2016: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.Get_WriteOff_Rep_Revenue_Amt :');

2012:
2013: BEGIN
2014:
2015: IF g1_debug_mode = 'Y' THEN
2016: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.Get_WriteOff_Rep_Revenue_Amt :');
2017: END IF;
2018:
2019: BEGIN
2020: IF p_task_id IS NOT NULL THEN

Line 2075: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing.Get_WriteOff_Rep_Revenue_Amt :');

2071:
2072: END IF;
2073:
2074: IF g1_debug_mode = 'Y' THEN
2075: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing.Get_WriteOff_Rep_Revenue_Amt :');
2076: END IF;
2077:
2078: EXCEPTION
2079: WHEN OTHERS THEN

Line 2114: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.Call_Calc_Non_Labor_Bill_Amt :');

2110:
2111: BEGIN
2112: /* Change the call and aded new paras in this procs. for MCB2 */
2113: IF g1_debug_mode = 'Y' THEN
2114: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.Call_Calc_Non_Labor_Bill_Amt :');
2115: END IF;
2116: PA_NON_LABOR_BILL_CLT_EXTN.Calc_Bill_Amount(
2117: x_transaction_type => x_transaction_type ,
2118: x_expenditure_item_id => x_expenditure_item_id ,

Line 2133: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing.Call_Calc_Non_Labor_Bill_Amt :');

2129: x_rate_source_id => x_rate_source_id
2130: );
2131:
2132: IF g1_debug_mode = 'Y' THEN
2133: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing.Call_Calc_Non_Labor_Bill_Amt :');
2134: END IF;
2135: EXCEPTION WHEN OTHERS THEN
2136: -- DBMS_OUTPUT.PUT(SQLERRM);
2137: x_amount := l_amount; --NOCOPY

Line 2283: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.globalAttrs proj_id : '||p_Proj_id);

2279: l_request_id := GetReqID();
2280: l_project_id := p_proj_id;
2281:
2282: IF g1_debug_mode = 'Y' THEN
2283: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.globalAttrs proj_id : '||p_Proj_id);
2284: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.globalAttrs start_proj_num : '||p_start_proj_num);
2285: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.globalAttrs end_proj_num : '||p_end_proj_num);
2286: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.globalAttrs Request_id :'|| l_request_id);
2287: END IF;

Line 2284: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.globalAttrs start_proj_num : '||p_start_proj_num);

2280: l_project_id := p_proj_id;
2281:
2282: IF g1_debug_mode = 'Y' THEN
2283: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.globalAttrs proj_id : '||p_Proj_id);
2284: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.globalAttrs start_proj_num : '||p_start_proj_num);
2285: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.globalAttrs end_proj_num : '||p_end_proj_num);
2286: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.globalAttrs Request_id :'|| l_request_id);
2287: END IF;
2288: IF(nvl(p_Proj_id,0) <> 0) THEN

Line 2285: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.globalAttrs end_proj_num : '||p_end_proj_num);

2281:
2282: IF g1_debug_mode = 'Y' THEN
2283: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.globalAttrs proj_id : '||p_Proj_id);
2284: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.globalAttrs start_proj_num : '||p_start_proj_num);
2285: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.globalAttrs end_proj_num : '||p_end_proj_num);
2286: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.globalAttrs Request_id :'|| l_request_id);
2287: END IF;
2288: IF(nvl(p_Proj_id,0) <> 0) THEN
2289:

Line 2286: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.globalAttrs Request_id :'|| l_request_id);

2282: IF g1_debug_mode = 'Y' THEN
2283: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.globalAttrs proj_id : '||p_Proj_id);
2284: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.globalAttrs start_proj_num : '||p_start_proj_num);
2285: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.globalAttrs end_proj_num : '||p_end_proj_num);
2286: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.globalAttrs Request_id :'|| l_request_id);
2287: END IF;
2288: IF(nvl(p_Proj_id,0) <> 0) THEN
2289:
2290: OPEN c_sel_proj;

Line 2306: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.globalAttrs cursor c_sel_proj : ');

2302: FETCH c_sel_proj_list into l_project_id,l_project_level_funding_flag;
2303: END IF;
2304:
2305: IF g1_debug_mode = 'Y' THEN
2306: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.globalAttrs cursor c_sel_proj : ');
2307: END IF;
2308:
2309: IF(nvl(p_Proj_id,0) <> 0) THEN
2310: EXIT WHEN c_sel_proj%NOTFOUND;

Line 2320: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.globalAttrs cursor c_proj_level : ');

2316:
2317: for rec_prjlvl in c_proj_level Loop
2318:
2319: IF g1_debug_mode = 'Y' THEN
2320: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.globalAttrs cursor c_proj_level : ');
2321: END IF;
2322: update Pa_Draft_Invoice_items dii
2323: set dii.global_attribute_category = rec_prjlvl.global_attribute_category,
2324: dii.GLOBAL_ATTRIBUTE1 = rec_prjlvl.GLOBAL_ATTRIBUTE1,

Line 2357: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.globalAttrs tasklvl cur');

2353: dii.GLOBAL_ATTRIBUTE30 = rec_prjlvl.GLOBAL_ATTRIBUTE30
2354: where dii.rowid = rec_prjlvl.rowid;
2355: end loop;
2356: else
2357: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.globalAttrs tasklvl cur');
2358:
2359: for rec_tasklvl in c_task_level Loop
2360:
2361: IF g1_debug_mode = 'Y' THEN

Line 2362: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.globalAttrs cursor c_task_level : ');

2358:
2359: for rec_tasklvl in c_task_level Loop
2360:
2361: IF g1_debug_mode = 'Y' THEN
2362: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.globalAttrs cursor c_task_level : ');
2363: END IF;
2364: update Pa_Draft_Invoice_items dii
2365: set
2366: dii.global_attribute_category = rec_tasklvl.global_attribute_category,

Line 2410: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing.globalAttrs :');

2406: CLOSE c_sel_proj_list;
2407: END IF;
2408:
2409: IF g1_debug_mode = 'Y' THEN
2410: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing.globalAttrs :');
2411: END IF;
2412:
2413: EXCEPTION
2414: WHEN OTHERS THEN

Line 2428: END pa_billing;

2424: /* Bug 13680810 END */
2425:
2426:
2427:
2428: END pa_billing;