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.5.12000000.3 2007/04/23 10:00:27 abjacob ship $ */
3:
4: /* MCB related changes */
5:

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

119: bea.billing_extension_id be_id, bea.top_task_id task_id,
120: decode(be.amount_reqd_flag, 'Y', nvl(bea.amount, 0), 0) amt,
121: decode(be.percentage_reqd_flag, 'Y', nvl(bea.percentage, 0), 0)
122: percent
123: from pa_billing_extensions be, pa_billing_assignments bea -- , Commented for bug 3643409
124: -- pa_projects p Commented for bug 3643409
125: where -- p.project_id = x_project_id Commented for bug 3643409
126: -- and Commented for bug 3643409
127: bea.active_flag = 'Y'

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

203: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
204:
205: BEGIN
206: IF g1_debug_mode = 'Y' THEN
207: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.bill_ext_driver :');
208: END IF;
209: GlobVars.ProjectId := x_project_id;
210: GlobVars.ReqId := x_request_id;
211: GlobVars.CallingPlace := x_calling_place;

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

211: GlobVars.CallingPlace := x_calling_place;
212: GlobVars.CallingProcess := x_calling_process;
213: GlobVars.AccrueThruDate := x_rev_or_bill_date;
214: IF g1_debug_mode = 'Y' THEN
215: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver project id :'||to_char(GlobVars.ProjectId));
216: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver Request id :'||to_char(GlobVars.ReqId));
217: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver Calling place :'||GlobVars.CallingPlace);
218: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver calling process :'||GlobVars.CallingProcess);
219: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver accru thru date :'||GlobVars.AccrueThruDate);

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

212: GlobVars.CallingProcess := x_calling_process;
213: GlobVars.AccrueThruDate := x_rev_or_bill_date;
214: IF g1_debug_mode = 'Y' THEN
215: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver project id :'||to_char(GlobVars.ProjectId));
216: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver Request id :'||to_char(GlobVars.ReqId));
217: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver Calling place :'||GlobVars.CallingPlace);
218: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver calling process :'||GlobVars.CallingProcess);
219: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver accru thru date :'||GlobVars.AccrueThruDate);
220: END IF;

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

213: GlobVars.AccrueThruDate := x_rev_or_bill_date;
214: IF g1_debug_mode = 'Y' THEN
215: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver project id :'||to_char(GlobVars.ProjectId));
216: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver Request id :'||to_char(GlobVars.ReqId));
217: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver Calling place :'||GlobVars.CallingPlace);
218: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver calling process :'||GlobVars.CallingProcess);
219: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver accru thru date :'||GlobVars.AccrueThruDate);
220: END IF;
221:

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

214: IF g1_debug_mode = 'Y' THEN
215: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver project id :'||to_char(GlobVars.ProjectId));
216: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver Request id :'||to_char(GlobVars.ReqId));
217: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver Calling place :'||GlobVars.CallingPlace);
218: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver calling process :'||GlobVars.CallingProcess);
219: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver accru thru date :'||GlobVars.AccrueThruDate);
220: END IF;
221:
222: -- DBMS_OUTPUT.ENABLE(1000000);

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

215: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver project id :'||to_char(GlobVars.ProjectId));
216: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver Request id :'||to_char(GlobVars.ReqId));
217: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver Calling place :'||GlobVars.CallingPlace);
218: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver calling process :'||GlobVars.CallingProcess);
219: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver accru thru date :'||GlobVars.AccrueThruDate);
220: END IF;
221:
222: -- DBMS_OUTPUT.ENABLE(1000000);
223: fund_level := pa_billing_values.funding_level(X_project_id);

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

219: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver accru thru date :'||GlobVars.AccrueThruDate);
220: END IF;
221:
222: -- DBMS_OUTPUT.ENABLE(1000000);
223: fund_level := pa_billing_values.funding_level(X_project_id);
224: x_error_message := 'Error during opening the dbms_sql cursor.';
225: c := dbms_sql.open_cursor;
226:
227: x_error_message := 'Error during fetching the get_procedure cursor.';

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

255: IF (task_rec.tpid IS NULL) THEN
256: -- This will be the case for Project Level funding and Project
257: -- Level assignment.
258: -- Do not have to change this stmt for MCB, because user is going to select from the
259: -- view pa_billing_extn_params_v ( all the newly added columns in pa_billing_assignments table)
260:
261: proc_stmt := 'declare s varchar2(240):=null; begin ' ||
262: get_rec.proc_name || '(' || to_char(x_project_id) ||
263: ','''',''' || x_calling_process ||

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

289: get_rec.proc_name || '(:project_id,:task_id,:calling_process,:calling_place,
290: :amt,:percent,:rev_or_bill_date,:bea_id,:be_id,:request_id); end;'; /* Added for 3560805*/
291:
292: IF g1_debug_mode = 'Y' THEN
293: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver: before executing building the Pl/Sql block :'||proc_stmt);
294: END IF;
295: x_error_message := 'Error during parsing the dynamic PL/SQL.';
296: dbms_sql.parse(c, proc_stmt, dbms_sql.native);
297:

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

316: row_processed := dbms_sql.execute(c);
317:
318:
319: IF g1_debug_mode = 'Y' THEN
320: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver: After building the Pl/Sql block :');
321: END IF;
322: EXCEPTION
323: WHEN NO_FUNDING THEN
324: IF g1_debug_mode = 'Y' THEN

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

321: END IF;
322: EXCEPTION
323: WHEN NO_FUNDING THEN
324: IF g1_debug_mode = 'Y' THEN
325: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver: Inside the error :');
326: END IF;
327: X_error_message := 'There is no funding';
328: -- DBMS_OUTPUT.PUT_LINE(SQLERRM);
329: WHEN OTHERS THEN

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

328: -- DBMS_OUTPUT.PUT_LINE(SQLERRM);
329: WHEN OTHERS THEN
330: -- DBMS_OUTPUT.PUT_LINE(SQLERRM);
331: IF g1_debug_mode = 'Y' THEN
332: PA_MCB_INVOICE_PKG.log_message('pa_billing.bill_ext_driver: Inside the others error :');
333: END IF;
334: dbms_sql.close_cursor(c);
335: RAISE;
336: END;

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

347: x_error_message := 'OK';
348: end if;
349:
350: IF g1_debug_mode = 'Y' THEN
351: PA_MCB_INVOICE_PKG.log_message('Exiting from pa_billing.bill_ext_driver :');
352: END IF;
353: EXCEPTION
354: WHEN OTHERS THEN
355: -- DBMS_OUTPUT.PUT_LINE(SQLERRM);

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

353: EXCEPTION
354: WHEN OTHERS THEN
355: -- DBMS_OUTPUT.PUT_LINE(SQLERRM);
356: IF g1_debug_mode = 'Y' THEN
357: PA_MCB_INVOICE_PKG.log_message('Inside main others error pa_billing.bill_ext_driver :');
358: END IF;
359: RAISE;
360: end bill_ext_driver;
361:

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

388: Amount_Left REAL := 0;
389:
390: event_description VARCHAR2(240);
391: --
392: -- The cost and revenue budget type codes used by the pa_billing_pub.get_budget_amount procedure
393: --
394: l_cost_budget_type_code VARCHAR2(30);
395: l_rev_budget_type_code VARCHAR2(30);
396: l_currency_code VARCHAR2(15);

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

437: --
438: l_status := 0;
439: l_error_message := NULL;
440: IF g1_debug_mode = 'Y' THEN
441: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.ccrev :');
442: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Project Id :'||to_char(X_project_id));
443: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Top Task Id :'||to_char(X_top_task_id));
444: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Calling process :'||X_calling_process);
445: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Calling place :'||X_calling_place);

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

438: l_status := 0;
439: l_error_message := NULL;
440: IF g1_debug_mode = 'Y' THEN
441: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.ccrev :');
442: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Project Id :'||to_char(X_project_id));
443: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Top Task Id :'||to_char(X_top_task_id));
444: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Calling process :'||X_calling_process);
445: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Calling place :'||X_calling_place);
446: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Amount :'||to_char(X_amount));

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

439: l_error_message := NULL;
440: IF g1_debug_mode = 'Y' THEN
441: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.ccrev :');
442: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Project Id :'||to_char(X_project_id));
443: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Top Task Id :'||to_char(X_top_task_id));
444: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Calling process :'||X_calling_process);
445: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Calling place :'||X_calling_place);
446: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Amount :'||to_char(X_amount));
447: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Percentage :'||to_char(X_percentage));

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

440: IF g1_debug_mode = 'Y' THEN
441: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.ccrev :');
442: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Project Id :'||to_char(X_project_id));
443: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Top Task Id :'||to_char(X_top_task_id));
444: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Calling process :'||X_calling_process);
445: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Calling place :'||X_calling_place);
446: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Amount :'||to_char(X_amount));
447: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Percentage :'||to_char(X_percentage));
448: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev rev_or_bill_date :'||to_char(X_rev_or_bill_date,'YYYY/MM/DD'));

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

441: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.ccrev :');
442: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Project Id :'||to_char(X_project_id));
443: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Top Task Id :'||to_char(X_top_task_id));
444: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Calling process :'||X_calling_process);
445: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Calling place :'||X_calling_place);
446: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Amount :'||to_char(X_amount));
447: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Percentage :'||to_char(X_percentage));
448: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev rev_or_bill_date :'||to_char(X_rev_or_bill_date,'YYYY/MM/DD'));
449: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev billing_assignment_id :'||to_char(X_billing_assignment_id));

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

442: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Project Id :'||to_char(X_project_id));
443: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Top Task Id :'||to_char(X_top_task_id));
444: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Calling process :'||X_calling_process);
445: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Calling place :'||X_calling_place);
446: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Amount :'||to_char(X_amount));
447: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Percentage :'||to_char(X_percentage));
448: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev rev_or_bill_date :'||to_char(X_rev_or_bill_date,'YYYY/MM/DD'));
449: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev billing_assignment_id :'||to_char(X_billing_assignment_id));
450: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev billing_extension_id :'||to_char(X_billing_extension_id));

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

443: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Top Task Id :'||to_char(X_top_task_id));
444: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Calling process :'||X_calling_process);
445: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Calling place :'||X_calling_place);
446: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Amount :'||to_char(X_amount));
447: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Percentage :'||to_char(X_percentage));
448: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev rev_or_bill_date :'||to_char(X_rev_or_bill_date,'YYYY/MM/DD'));
449: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev billing_assignment_id :'||to_char(X_billing_assignment_id));
450: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev billing_extension_id :'||to_char(X_billing_extension_id));
451: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev request_id :'||to_char(X_request_id));

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

444: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Calling process :'||X_calling_process);
445: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Calling place :'||X_calling_place);
446: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Amount :'||to_char(X_amount));
447: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Percentage :'||to_char(X_percentage));
448: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev rev_or_bill_date :'||to_char(X_rev_or_bill_date,'YYYY/MM/DD'));
449: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev billing_assignment_id :'||to_char(X_billing_assignment_id));
450: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev billing_extension_id :'||to_char(X_billing_extension_id));
451: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev request_id :'||to_char(X_request_id));
452: END IF;

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

445: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Calling place :'||X_calling_place);
446: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Amount :'||to_char(X_amount));
447: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Percentage :'||to_char(X_percentage));
448: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev rev_or_bill_date :'||to_char(X_rev_or_bill_date,'YYYY/MM/DD'));
449: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev billing_assignment_id :'||to_char(X_billing_assignment_id));
450: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev billing_extension_id :'||to_char(X_billing_extension_id));
451: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev request_id :'||to_char(X_request_id));
452: END IF;
453: /*****

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

446: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Amount :'||to_char(X_amount));
447: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Percentage :'||to_char(X_percentage));
448: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev rev_or_bill_date :'||to_char(X_rev_or_bill_date,'YYYY/MM/DD'));
449: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev billing_assignment_id :'||to_char(X_billing_assignment_id));
450: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev billing_extension_id :'||to_char(X_billing_extension_id));
451: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev request_id :'||to_char(X_request_id));
452: END IF;
453: /*****
454: l_cost_budget_type_code := 'AC';

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

447: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev Percentage :'||to_char(X_percentage));
448: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev rev_or_bill_date :'||to_char(X_rev_or_bill_date,'YYYY/MM/DD'));
449: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev billing_assignment_id :'||to_char(X_billing_assignment_id));
450: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev billing_extension_id :'||to_char(X_billing_extension_id));
451: PA_MCB_INVOICE_PKG.log_message('pa_billing.ccrev request_id :'||to_char(X_request_id));
452: END IF;
453: /*****
454: l_cost_budget_type_code := 'AC';
455: l_rev_budget_type_code := 'AR';

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

489: /* Till Here */
490:
491:
492: IF g1_debug_mode = 'Y' THEN
493: PA_MCB_INVOICE_PKG.log_message('Before select of pa billing params v pa_billing.ccrev :');
494: END IF;
495: /* Added for bug 2649456.Not handling exception intentionaly because if it is coming,
496: it will be data issue */
497: BEGIN

Line 500: FROM pa_billing_extn_params_v;

496: it will be data issue */
497: BEGIN
498: SELECT default_cost_plan_type_id,default_rev_plan_type_id
499: INTO l_cost_plan_type_id,l_rev_plan_type_id
500: FROM pa_billing_extn_params_v;
501: EXCEPTION
502: WHEN OTHERS THEN
503: IF g1_debug_mode = 'Y' THEN
504: PA_MCB_INVOICE_PKG.log_message('Error from pa_billing_extn_params_v pa_billing.ccrev :'||SQLERRM);

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

500: FROM pa_billing_extn_params_v;
501: EXCEPTION
502: WHEN OTHERS THEN
503: IF g1_debug_mode = 'Y' THEN
504: PA_MCB_INVOICE_PKG.log_message('Error from pa_billing_extn_params_v pa_billing.ccrev :'||SQLERRM);
505: END IF;
506: RAISE;
507: END;
508: /* till here */

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

507: END;
508: /* till here */
509:
510: IF g1_debug_mode = 'Y' THEN
511: PA_MCB_INVOICE_PKG.log_message('pa billing params v.cost_plan_type_id pa_billing.ccrev :'||l_cost_plan_type_id);
512: PA_MCB_INVOICE_PKG.log_message('pa billing params v.rev_plan_type_id pa_billing.ccrev :'||l_rev_plan_type_id);
513: PA_MCB_INVOICE_PKG.log_message('Before calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev :');
514: END IF;
515: pa_billing_pub.get_budget_amount(

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

508: /* till here */
509:
510: IF g1_debug_mode = 'Y' THEN
511: PA_MCB_INVOICE_PKG.log_message('pa billing params v.cost_plan_type_id pa_billing.ccrev :'||l_cost_plan_type_id);
512: PA_MCB_INVOICE_PKG.log_message('pa billing params v.rev_plan_type_id pa_billing.ccrev :'||l_rev_plan_type_id);
513: PA_MCB_INVOICE_PKG.log_message('Before calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev :');
514: END IF;
515: pa_billing_pub.get_budget_amount(
516: X2_project_id => X_project_id,

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

509:
510: IF g1_debug_mode = 'Y' THEN
511: PA_MCB_INVOICE_PKG.log_message('pa billing params v.cost_plan_type_id pa_billing.ccrev :'||l_cost_plan_type_id);
512: PA_MCB_INVOICE_PKG.log_message('pa billing params v.rev_plan_type_id pa_billing.ccrev :'||l_rev_plan_type_id);
513: PA_MCB_INVOICE_PKG.log_message('Before calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev :');
514: END IF;
515: pa_billing_pub.get_budget_amount(
516: X2_project_id => X_project_id,
517: X2_task_id => X_top_task_id,

Line 515: pa_billing_pub.get_budget_amount(

511: PA_MCB_INVOICE_PKG.log_message('pa billing params v.cost_plan_type_id pa_billing.ccrev :'||l_cost_plan_type_id);
512: PA_MCB_INVOICE_PKG.log_message('pa billing params v.rev_plan_type_id pa_billing.ccrev :'||l_rev_plan_type_id);
513: PA_MCB_INVOICE_PKG.log_message('Before calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev :');
514: END IF;
515: pa_billing_pub.get_budget_amount(
516: X2_project_id => X_project_id,
517: X2_task_id => X_top_task_id,
518: X2_revenue_amount => budget_revenue,
519: X2_cost_amount => budget_cost,

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

524: X_error_message => l_error_message,
525: X_status => l_status);
526:
527: IF g1_debug_mode = 'Y' THEN
528: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev budget_revenue :'||to_char(budget_revenue));
529: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev budget_cost :'||to_char(budget_cost));
530: 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);
531: 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);
532: END IF;

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

525: X_status => l_status);
526:
527: IF g1_debug_mode = 'Y' THEN
528: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev budget_revenue :'||to_char(budget_revenue));
529: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev budget_cost :'||to_char(budget_cost));
530: 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);
531: 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);
532: END IF;
533: -- If get budget amount return an error its fatal.

Line 530: 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);

526:
527: IF g1_debug_mode = 'Y' THEN
528: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev budget_revenue :'||to_char(budget_revenue));
529: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev budget_cost :'||to_char(budget_cost));
530: 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);
531: 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);
532: END IF;
533: -- If get budget amount return an error its fatal.
534:

Line 531: 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);

527: IF g1_debug_mode = 'Y' THEN
528: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev budget_revenue :'||to_char(budget_revenue));
529: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev budget_cost :'||to_char(budget_cost));
530: 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);
531: 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);
532: END IF;
533: -- If get budget amount return an error its fatal.
534:
535: IF l_status <> 0 THEN

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

536: raise ccrev_error;
537: END IF;
538:
539: IF g1_debug_mode = 'Y' THEN
540: PA_MCB_INVOICE_PKG.log_message('Before calling pa_billing_amount.PotEventAmount inside pa_billing.ccrev :');
541: END IF;
542: pa_billing_amount.PotEventAmount(
543: X2_project_id => X_project_id,
544: X2_task_id => X_top_task_id,

Line 542: pa_billing_amount.PotEventAmount(

538:
539: IF g1_debug_mode = 'Y' THEN
540: PA_MCB_INVOICE_PKG.log_message('Before calling pa_billing_amount.PotEventAmount inside pa_billing.ccrev :');
541: END IF;
542: pa_billing_amount.PotEventAmount(
543: X2_project_id => X_project_id,
544: X2_task_id => X_top_task_id,
545: X2_accrue_through_date => X_rev_or_bill_date,
546: X2_revenue_amount => event_revenue,

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

546: X2_revenue_amount => event_revenue,
547: X2_invoice_amount => event_invoice);
548:
549: IF g1_debug_mode = 'Y' THEN
550: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_amount.PotEventAmount inside pa_billing.ccrev event_revenue :'||to_char(event_revenue));
551: PA_MCB_INVOICE_PKG.log_message('Before calling pa_billing_amount.CostAmount inside pa_billing.ccrev event_invoice :'||to_char(event_invoice));
552: END IF;
553: pa_billing_amount.CostAmount(
554: X2_project_id => X_project_id,

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

547: X2_invoice_amount => event_invoice);
548:
549: IF g1_debug_mode = 'Y' THEN
550: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_amount.PotEventAmount inside pa_billing.ccrev event_revenue :'||to_char(event_revenue));
551: PA_MCB_INVOICE_PKG.log_message('Before calling pa_billing_amount.CostAmount inside pa_billing.ccrev event_invoice :'||to_char(event_invoice));
552: END IF;
553: pa_billing_amount.CostAmount(
554: X2_project_id => X_project_id,
555: X2_task_id => X_top_task_id,

Line 553: pa_billing_amount.CostAmount(

549: IF g1_debug_mode = 'Y' THEN
550: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_amount.PotEventAmount inside pa_billing.ccrev event_revenue :'||to_char(event_revenue));
551: PA_MCB_INVOICE_PKG.log_message('Before calling pa_billing_amount.CostAmount inside pa_billing.ccrev event_invoice :'||to_char(event_invoice));
552: END IF;
553: pa_billing_amount.CostAmount(
554: X2_project_id => X_project_id,
555: X2_task_id => X_top_task_id,
556: X2_accrue_through_date => X_rev_or_bill_date,
557: X2_cost_amount => cost_amount);

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

555: X2_task_id => X_top_task_id,
556: X2_accrue_through_date => X_rev_or_bill_date,
557: X2_cost_amount => cost_amount);
558: IF g1_debug_mode = 'Y' THEN
559: PA_MCB_INVOICE_PKG.log_message('After pa_billing_amount.CostAmount inside pa_billing.ccrev cost_amount :'||to_char(cost_amount));
560: END IF;
561:
562: Amount_Left := pa_billing_amount.LowestAmountLeft(
563: X_project_id,

Line 562: Amount_Left := pa_billing_amount.LowestAmountLeft(

558: IF g1_debug_mode = 'Y' THEN
559: PA_MCB_INVOICE_PKG.log_message('After pa_billing_amount.CostAmount inside pa_billing.ccrev cost_amount :'||to_char(cost_amount));
560: END IF;
561:
562: Amount_Left := pa_billing_amount.LowestAmountLeft(
563: X_project_id,
564: X_top_task_id,
565: X_calling_process);
566:

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

564: X_top_task_id,
565: X_calling_process);
566:
567: IF g1_debug_mode = 'Y' THEN
568: PA_MCB_INVOICE_PKG.log_message('After pa_billing_amount.LowestAmountLeft inside pa_billing.ccrev Amount_Left :'||to_char(Amount_Left));
569: END IF;
570: -- DBMS_OUTPUT.PUT('Revenue =');
571: -- DBMS_OUTPUT.PUT_LINE(Revenue);
572: -- DBMS_OUTPUT.PUT('Amount_Left=');

Line 587: pa_billing_amount.RevenueAmount(

583: -- DBMS_OUTPUT.PUT_LINE(event_revenue);
584:
585:
586: IF (X_calling_process = 'Revenue') THEN
587: pa_billing_amount.RevenueAmount(
588: X2_project_id => x_project_id,
589: X2_task_id => X_top_task_id,
590: X2_revenue_amount => revenue_amount);
591:

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

589: X2_task_id => X_top_task_id,
590: X2_revenue_amount => revenue_amount);
591:
592: IF g1_debug_mode = 'Y' THEN
593: PA_MCB_INVOICE_PKG.log_message('After call of pa_billing_amount.RevenueAmount inside pa_billing.ccrev revenue_amount 1 :'||to_char(revenue_amount));
594: END IF;
595: IF (budget_cost <> 0) THEN
596: -- Take the lower of what you should insert based on cost-cost algorithm,
597: -- of revenue = (cost/budget_cost) * (budget_revenue - event_revenue)

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

608: Amount_Left
609: );
610:
611: IF g1_debug_mode = 'Y' THEN
612: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.ccrev calculating Revenue ( Least) Revenue 2 :'||to_char(Revenue));
613: END IF;
614:
615: /* Changed the length of the format mask for amount_left column from 15 to 22
616: to fix the bug 2124494 for MCB2 */

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

615: /* Changed the length of the format mask for amount_left column from 15 to 22
616: to fix the bug 2124494 for MCB2 */
617: /* Changed the length of the format mask for all column from 15 to 22
618: to fix the bug 2162900 for MCB2 */
619: Event_Description := pa_billing_values.get_message('CCREV_DESCRIPTION')|| '(' ||
620: to_char(amount_left,fnd_currency.get_format_mask(l_currency_code,22))
621: || ' ,((' ||
622: to_char(cost_amount,fnd_currency.get_format_mask(l_currency_code,22))
623: || '/' ||

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

629: || ')) - '||
630: to_char(nvl(revenue_amount,0),fnd_currency.get_format_mask(l_currency_code,22))
631: || ' ))';
632: IF g1_debug_mode = 'Y' THEN
633: PA_MCB_INVOICE_PKG.log_message('rev part Inside Revenue part pa_billing.ccrev Event desc :'||Event_Description);
634: PA_MCB_INVOICE_PKG.log_message('Rev part Before insert pa_billing.ccrev.insert_event 1 :'||to_char(Revenue));
635: END IF;
636: -- Modified to add new parameters for insert_event
637: pa_billing_pub.insert_event (

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

630: to_char(nvl(revenue_amount,0),fnd_currency.get_format_mask(l_currency_code,22))
631: || ' ))';
632: IF g1_debug_mode = 'Y' THEN
633: PA_MCB_INVOICE_PKG.log_message('rev part Inside Revenue part pa_billing.ccrev Event desc :'||Event_Description);
634: PA_MCB_INVOICE_PKG.log_message('Rev part Before insert pa_billing.ccrev.insert_event 1 :'||to_char(Revenue));
635: END IF;
636: -- Modified to add new parameters for insert_event
637: pa_billing_pub.insert_event (
638: X_rev_amt => Revenue,

Line 637: pa_billing_pub.insert_event (

633: PA_MCB_INVOICE_PKG.log_message('rev part Inside Revenue part pa_billing.ccrev Event desc :'||Event_Description);
634: PA_MCB_INVOICE_PKG.log_message('Rev part Before insert pa_billing.ccrev.insert_event 1 :'||to_char(Revenue));
635: END IF;
636: -- Modified to add new parameters for insert_event
637: pa_billing_pub.insert_event (
638: X_rev_amt => Revenue,
639: X_bill_amt => 0,
640: X_event_description => event_description,
641: X_audit_amount1 => amount_left,

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

652: X_status => l_status
653: );
654:
655: IF g1_debug_mode = 'Y' THEN
656: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event rev :'||to_char(revenue_amount));
657: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event budget rev :'||to_char(budget_revenue));
658: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event amt left :'||to_char(amount_left));
659: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event evt rev :'||to_char(event_revenue));
660: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event budget cost :'||to_char(budget_cost));

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

653: );
654:
655: IF g1_debug_mode = 'Y' THEN
656: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event rev :'||to_char(revenue_amount));
657: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event budget rev :'||to_char(budget_revenue));
658: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event amt left :'||to_char(amount_left));
659: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event evt rev :'||to_char(event_revenue));
660: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event budget cost :'||to_char(budget_cost));
661: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event cst amt :'||to_char(cost_amount));

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

654:
655: IF g1_debug_mode = 'Y' THEN
656: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event rev :'||to_char(revenue_amount));
657: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event budget rev :'||to_char(budget_revenue));
658: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event amt left :'||to_char(amount_left));
659: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event evt rev :'||to_char(event_revenue));
660: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event budget cost :'||to_char(budget_cost));
661: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event cst amt :'||to_char(cost_amount));
662: END IF;

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

655: IF g1_debug_mode = 'Y' THEN
656: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event rev :'||to_char(revenue_amount));
657: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event budget rev :'||to_char(budget_revenue));
658: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event amt left :'||to_char(amount_left));
659: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event evt rev :'||to_char(event_revenue));
660: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event budget cost :'||to_char(budget_cost));
661: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event cst amt :'||to_char(cost_amount));
662: END IF;
663: IF l_status <> 0 THEN

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

656: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event rev :'||to_char(revenue_amount));
657: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event budget rev :'||to_char(budget_revenue));
658: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event amt left :'||to_char(amount_left));
659: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event evt rev :'||to_char(event_revenue));
660: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event budget cost :'||to_char(budget_cost));
661: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event cst amt :'||to_char(cost_amount));
662: END IF;
663: IF l_status <> 0 THEN
664: raise ccrev_error;

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

657: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event budget rev :'||to_char(budget_revenue));
658: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event amt left :'||to_char(amount_left));
659: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event evt rev :'||to_char(event_revenue));
660: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event budget cost :'||to_char(budget_cost));
661: PA_MCB_INVOICE_PKG.log_message('rev part after insert pa_billing.ccrev.insert_event cst amt :'||to_char(cost_amount));
662: END IF;
663: IF l_status <> 0 THEN
664: raise ccrev_error;
665: END IF;

Line 670: pa_billing_amount.InvoiceAmount(

666:
667: END IF;
668:
669: ELSE
670: pa_billing_amount.InvoiceAmount(
671: X2_project_id => X_project_id,
672: X2_task_id => X_top_task_id,
673: X2_invoice_amount => invoice_amount);
674:

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

672: X2_task_id => X_top_task_id,
673: X2_invoice_amount => invoice_amount);
674:
675: IF g1_debug_mode = 'Y' THEN
676: PA_MCB_INVOICE_PKG.log_message('After the call of pa_billing_amount.InvoiceAmount inside pa_billing.ccrev :'||to_char(invoice_amount));
677: END IF;
678: IF (budget_cost <> 0) THEN
679: Invoice := Least( ( (nvl(cost_amount,0)/budget_cost)
680: * greatest( (nvl(budget_revenue,0)

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

683: nvl(Amount_Left,0)
684: );
685:
686: IF g1_debug_mode = 'Y' THEN
687: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.ccrev calculating Invoice (Least) :'||to_char(Invoice));
688: END IF;
689: /* Changed the length of the format mask for amount_left column from 15 to 22
690: to fix the bug 2124494 for MCB2 */
691: /* Changed the length of the format mask for all column from 15 to 22

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

689: /* Changed the length of the format mask for amount_left column from 15 to 22
690: to fix the bug 2124494 for MCB2 */
691: /* Changed the length of the format mask for all column from 15 to 22
692: to fix the bug 2162900 for MCB2 */
693: Event_Description := pa_billing_values.get_message('CCREV_DESCRIPTION')|| '(' ||
694: to_char(amount_left,fnd_currency.get_format_mask(l_currency_code,22))
695: || ' ,((' ||
696: to_char(cost_amount,fnd_currency.get_format_mask(l_currency_code,22))
697: || '/' ||

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

704: to_char(nvl(invoice_amount,0),fnd_currency.get_format_mask(l_currency_code,22))
705: || ' ))';
706:
707: IF g1_debug_mode = 'Y' THEN
708: PA_MCB_INVOICE_PKG.log_message('inv part Inside Revenue part pa_billing.ccrev Event desc :'||Event_Description);
709: PA_MCB_INVOICE_PKG.log_message('inv part before insert pa_billing.ccrev.insert_event inv 2 :'||to_char(Invoice));
710: END IF;
711: pa_billing_pub.insert_event (
712: X_rev_amt => 0,

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

705: || ' ))';
706:
707: IF g1_debug_mode = 'Y' THEN
708: PA_MCB_INVOICE_PKG.log_message('inv part Inside Revenue part pa_billing.ccrev Event desc :'||Event_Description);
709: PA_MCB_INVOICE_PKG.log_message('inv part before insert pa_billing.ccrev.insert_event inv 2 :'||to_char(Invoice));
710: END IF;
711: pa_billing_pub.insert_event (
712: X_rev_amt => 0,
713: X_bill_amt => Invoice,

Line 711: pa_billing_pub.insert_event (

707: IF g1_debug_mode = 'Y' THEN
708: PA_MCB_INVOICE_PKG.log_message('inv part Inside Revenue part pa_billing.ccrev Event desc :'||Event_Description);
709: PA_MCB_INVOICE_PKG.log_message('inv part before insert pa_billing.ccrev.insert_event inv 2 :'||to_char(Invoice));
710: END IF;
711: pa_billing_pub.insert_event (
712: X_rev_amt => 0,
713: X_bill_amt => Invoice,
714: X_event_description => Event_Description,
715: X_audit_amount1 => amount_left,

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

726: X_status => l_status
727: );
728:
729: IF g1_debug_mode = 'Y' THEN
730: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event inv 2 :'||to_char(invoice_amount));
731: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event bud rev 2 :'||to_char(budget_revenue));
732: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event amt lft 2 :'||to_char(amount_left));
733: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event evt inv 2 :'||to_char(event_invoice));
734: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event bd cst 2 :'||to_char(budget_cost));

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

727: );
728:
729: IF g1_debug_mode = 'Y' THEN
730: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event inv 2 :'||to_char(invoice_amount));
731: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event bud rev 2 :'||to_char(budget_revenue));
732: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event amt lft 2 :'||to_char(amount_left));
733: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event evt inv 2 :'||to_char(event_invoice));
734: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event bd cst 2 :'||to_char(budget_cost));
735: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event cst amt 2 :'||to_char(cost_amount));

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

728:
729: IF g1_debug_mode = 'Y' THEN
730: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event inv 2 :'||to_char(invoice_amount));
731: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event bud rev 2 :'||to_char(budget_revenue));
732: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event amt lft 2 :'||to_char(amount_left));
733: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event evt inv 2 :'||to_char(event_invoice));
734: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event bd cst 2 :'||to_char(budget_cost));
735: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event cst amt 2 :'||to_char(cost_amount));
736: END IF;

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

729: IF g1_debug_mode = 'Y' THEN
730: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event inv 2 :'||to_char(invoice_amount));
731: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event bud rev 2 :'||to_char(budget_revenue));
732: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event amt lft 2 :'||to_char(amount_left));
733: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event evt inv 2 :'||to_char(event_invoice));
734: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event bd cst 2 :'||to_char(budget_cost));
735: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event cst amt 2 :'||to_char(cost_amount));
736: END IF;
737: IF l_status <> 0 THEN

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

730: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event inv 2 :'||to_char(invoice_amount));
731: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event bud rev 2 :'||to_char(budget_revenue));
732: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event amt lft 2 :'||to_char(amount_left));
733: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event evt inv 2 :'||to_char(event_invoice));
734: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event bd cst 2 :'||to_char(budget_cost));
735: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event cst amt 2 :'||to_char(cost_amount));
736: END IF;
737: IF l_status <> 0 THEN
738: raise ccrev_error;

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

731: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event bud rev 2 :'||to_char(budget_revenue));
732: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event amt lft 2 :'||to_char(amount_left));
733: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event evt inv 2 :'||to_char(event_invoice));
734: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event bd cst 2 :'||to_char(budget_cost));
735: PA_MCB_INVOICE_PKG.log_message('inv part after insert pa_billing.ccrev.insert_event cst amt 2 :'||to_char(cost_amount));
736: END IF;
737: IF l_status <> 0 THEN
738: raise ccrev_error;
739: END IF;

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

741: END IF;
742: END IF;
743:
744: IF g1_debug_mode = 'Y' THEN
745: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing.ccrev :');
746: END IF;
747: EXCEPTION
748: WHEN ccrev_error THEN
749: NULL;

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

769:
770: -- Bug#1165176 Added condition line_num_reversed is null
771:
772: IF g1_debug_mode = 'Y' THEN
773: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.Delete_Automatic_Events :');
774: END IF;
775: IF (X_calling_Process = 'Revenue') THEN
776: DELETE from pa_events v
777: WHERE v.project_id = X_project_id

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

788: WHERE vt.event_type_classification||'' = 'AUTOMATIC'
789: AND vt.event_type = v.event_type)
790: AND v.calling_process = X_calling_process;
791: IF g1_debug_mode = 'Y' THEN
792: PA_MCB_INVOICE_PKG.log_message('Deleted Revenue pa_billing.Delete_Automatic_Events :');
793: END IF;
794: ELSE
795: -- DBMS_OUTPUT.PUT_LINE('Deleting Invoice Events');
796:

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

807: AND V.Bill_Amount <> 0
808: AND V.calling_process = X_calling_process;
809:
810: IF g1_debug_mode = 'Y' THEN
811: PA_MCB_INVOICE_PKG.log_message('Deleted Invoice pa_billing.Delete_Automatic_Events :');
812: END IF;
813: -- This last part is to ensure that we delete only events that were created
814: -- by Invoice as per the adjustment model for Billing Extensions.
815:

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

817:
818: -- commit;
819:
820: IF g1_debug_mode = 'Y' THEN
821: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing.Delete_Automatic_Events :');
822: END IF;
823: END Delete_Automatic_Events;
824:
825:

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

840:
841: BEGIN
842: /* Change the call and aded new paras in this procs. for MCB2 */
843: IF g1_debug_mode = 'Y' THEN
844: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.Call_Calc_Bill_Amount :');
845: END IF;
846: pa_client_extn_billing.Calc_Bill_Amount(
847: x_transaction_type => x_transaction_type,
848: x_expenditure_item_id => x_expenditure_item_id,

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

864: currency
865: x_amount := pa_currency.round_currency_amt(x_amount);*/
866:
867: IF g1_debug_mode = 'Y' THEN
868: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing.Call_Calc_Bill_Amount :');
869: END IF;
870: EXCEPTION WHEN OTHERS THEN
871: -- DBMS_OUTPUT.PUT(SQLERRM);
872: RAISE;

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

1086: dii.project_currency_code,dii.funding_currency_code; /* MCB related changes */
1087:
1088: BEGIN
1089: IF g1_debug_mode = 'Y' THEN
1090: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS :');
1091: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS X_option : '||X_option);
1092: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS X_proj_id : '||X_proj_id);
1093: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS X_start_proj_num : '||X_start_proj_num);
1094: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS X_end_proj_num : '||X_end_proj_num);

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

1087:
1088: BEGIN
1089: IF g1_debug_mode = 'Y' THEN
1090: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS :');
1091: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS X_option : '||X_option);
1092: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS X_proj_id : '||X_proj_id);
1093: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS X_start_proj_num : '||X_start_proj_num);
1094: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS X_end_proj_num : '||X_end_proj_num);
1095: END IF;

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

1088: BEGIN
1089: IF g1_debug_mode = 'Y' THEN
1090: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS :');
1091: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS X_option : '||X_option);
1092: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS X_proj_id : '||X_proj_id);
1093: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS X_start_proj_num : '||X_start_proj_num);
1094: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS X_end_proj_num : '||X_end_proj_num);
1095: END IF;
1096:

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

1089: IF g1_debug_mode = 'Y' THEN
1090: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS :');
1091: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS X_option : '||X_option);
1092: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS X_proj_id : '||X_proj_id);
1093: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS X_start_proj_num : '||X_start_proj_num);
1094: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS X_end_proj_num : '||X_end_proj_num);
1095: END IF;
1096:
1097: -- OPEN sel_proj; Commented for bug 3372249

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

1090: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS :');
1091: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS X_option : '||X_option);
1092: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS X_proj_id : '||X_proj_id);
1093: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS X_start_proj_num : '||X_start_proj_num);
1094: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.CHECK_SPF_AMOUNTS X_end_proj_num : '||X_end_proj_num);
1095: END IF;
1096:
1097: -- OPEN sel_proj; Commented for bug 3372249
1098:

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

1116: END IF;
1117: /* End of fix for bug 3372249 */
1118:
1119: IF g1_debug_mode = 'Y' THEN
1120: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.CHECK_SPF_AMOUNTS cursor sel_proj : ');
1121: END IF;
1122:
1123: -- EXIT WHEN sel_proj%NOTFOUND; Commented for bug 3372249
1124: /* Start of fix for bug 3372249 */

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

1137: -----------------------------------------------------------------------*/
1138: FOR acc_0_rec in spf_acc_0 LOOP
1139:
1140: IF g1_debug_mode = 'Y' THEN
1141: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.CHECK_SPF_AMOUNTS cursor spf_acc_0 : ');
1142: END IF;
1143: UPDATE pa_summary_project_fundings pf
1144: SET pf.total_accrued_amount = 0,
1145: pf.revproc_accrued_amount = 0, /* MCB related changes */

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

1159: FOR acc_amt_rec in spf_acc_amt LOOP
1160: /* This new currency procs. is being used which covers the MCB2 as well as old functionality */
1161:
1162: IF g1_debug_mode = 'Y' THEN
1163: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.CHECK_SPF_AMOUNTS cursor spf_acc_amt : ');
1164: END IF;
1165: UPDATE pa_summary_project_fundings pf
1166: SET pf.total_accrued_amount =
1167: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT

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

1194:
1195: FOR bill_0_rec in spf_bill_0 LOOP
1196:
1197: IF g1_debug_mode = 'Y' THEN
1198: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.CHECK_SPF_AMOUNTS cursor spf_bill_0 : ');
1199: END IF;
1200: UPDATE pa_summary_project_fundings pf
1201: SET pf.total_billed_amount = 0,
1202: pf.invproc_billed_amount = 0, /* MCB related changes */

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

1216: FOR pl_bill_amt_rec in spf_pl_bill_amt LOOP
1217: /* This new currency procs. is being used which covers the MCB2 as well as old functionality */
1218:
1219: IF g1_debug_mode = 'Y' THEN
1220: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.CHECK_SPF_AMOUNTS cursor spf_pl_bill_amt : ');
1221: END IF;
1222: UPDATE pa_summary_project_fundings pf
1223: SET pf.total_billed_amount =
1224: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT

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

1247:
1248: /* This new currency procs. is being used which covers the MCB2 as well as old functionality */
1249:
1250: IF g1_debug_mode = 'Y' THEN
1251: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.CHECK_SPF_AMOUNTS cursor spf_tl_bill_amt : ');
1252: END IF;
1253:
1254: UPDATE pa_summary_project_fundings pf
1255: SET pf.total_billed_amount =

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

1283: END IF;
1284: /* End of fix for bug 3372249 */
1285:
1286: IF g1_debug_mode = 'Y' THEN
1287: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing.CHECK_SPF_AMOUNTS :');
1288: END IF;
1289: EXCEPTION
1290: WHEN OTHERS THEN
1291: -- CLOSE sel_proj; Commented for bug 3372249

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

1329:
1330: BEGIN
1331:
1332: IF g1_debug_mode = 'Y' THEN
1333: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.Get_WriteOff_Revenue_Amount :');
1334: END IF;
1335: BEGIN
1336:
1337: IF p_task_id IS NOT NULL THEN

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

1530:
1531: END IF;
1532:
1533: IF g1_debug_mode = 'Y' THEN
1534: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing.Get_WriteOff_Revenue_Amount :');
1535: END IF;
1536: EXCEPTION
1537:
1538: WHEN OTHERS THEN

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

1663: /* Indicator variables Bug# 634414 */
1664: NC := 1204;
1665: /* MCB Changes : Added the new param to the procedure Call_Calc_Bill_Amount
1666: */
1667: pa_billing.Call_Calc_Bill_Amount( 'ACTUAL',ei_id( j ),
1668: sys_linkage_func,
1669: amount,
1670: bill_rate_flag,
1671: status,

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

1941:
1942: BEGIN
1943:
1944: IF g1_debug_mode = 'Y' THEN
1945: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.Get_WriteOff_Rep_Revenue_Amt :');
1946: END IF;
1947:
1948: BEGIN
1949: IF p_task_id IS NOT NULL THEN

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

2000:
2001: END IF;
2002:
2003: IF g1_debug_mode = 'Y' THEN
2004: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing.Get_WriteOff_Rep_Revenue_Amt :');
2005: END IF;
2006:
2007: EXCEPTION
2008: WHEN OTHERS THEN

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

2039:
2040: BEGIN
2041: /* Change the call and aded new paras in this procs. for MCB2 */
2042: IF g1_debug_mode = 'Y' THEN
2043: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.Call_Calc_Non_Labor_Bill_Amt :');
2044: END IF;
2045: PA_NON_LABOR_BILL_CLT_EXTN.Calc_Bill_Amount(
2046: x_transaction_type => x_transaction_type ,
2047: x_expenditure_item_id => x_expenditure_item_id ,

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

2058: x_rate_source_id => x_rate_source_id
2059: );
2060:
2061: IF g1_debug_mode = 'Y' THEN
2062: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing.Call_Calc_Non_Labor_Bill_Amt :');
2063: END IF;
2064: EXCEPTION WHEN OTHERS THEN
2065: -- DBMS_OUTPUT.PUT(SQLERRM);
2066: x_amount := l_amount; --NOCOPY

Line 2108: END pa_billing;

2104: Exception When others Then
2105: Return 'N';
2106: End Validate_Task_Customer;
2107:
2108: END pa_billing;