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_RATE_PVT_PKG dependencies on PA_DEBUG

Line 51: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

47: -- x_cost_rejct_reason VARCHAR2 YES Rejection reason for cost
48: -- x_burdened_rejct_reason VARCHAR2 YES Rejection reason for burden
49: -- x_others_rejct_reason VARCHAR2 YES Rejection reason for other error like pl/sql etc.
50:
51: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
52:
53: PROCEDURE get_item_amount(
54: p_calling_mode IN VARCHAR2 ,
55: p_rate_calc_date IN DATE ,

Line 273: PA_DEBUG.Set_Curr_Function( p_function => 'Get_Item_Amount');

269: /*Till here for LCE.*/
270:
271: BEGIN
272: IF g1_debug_mode = 'Y' THEN
273: PA_DEBUG.Set_Curr_Function( p_function => 'Get_Item_Amount');
274: PA_DEBUG.g_err_stage := 'RT10 : Before Validation Entering PA_RATE_PVT_PKG.Get_Item_Amount';
275: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
276: END IF;
277:

Line 274: PA_DEBUG.g_err_stage := 'RT10 : Before Validation Entering PA_RATE_PVT_PKG.Get_Item_Amount';

270:
271: BEGIN
272: IF g1_debug_mode = 'Y' THEN
273: PA_DEBUG.Set_Curr_Function( p_function => 'Get_Item_Amount');
274: PA_DEBUG.g_err_stage := 'RT10 : Before Validation Entering PA_RATE_PVT_PKG.Get_Item_Amount';
275: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
276: END IF;
277:
278: /* Validating that the required parameters should not be null */

Line 275: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

271: BEGIN
272: IF g1_debug_mode = 'Y' THEN
273: PA_DEBUG.Set_Curr_Function( p_function => 'Get_Item_Amount');
274: PA_DEBUG.g_err_stage := 'RT10 : Before Validation Entering PA_RATE_PVT_PKG.Get_Item_Amount';
275: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
276: END IF;
277:
278: /* Validating that the required parameters should not be null */
279: IF ( p_calling_mode IS NULL) OR (p_rate_calc_date IS NULL ) OR

Line 292: PA_DEBUG.g_err_stage := 'RTS10 : After sufficient parameter';

288: END IF;
289: END IF;
290:
291: IF g1_debug_mode = 'Y' THEN
292: PA_DEBUG.g_err_stage := 'RTS10 : After sufficient parameter';
293: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
294: END IF;
295: /* Selecting distribution_rule from project all table only if the passed value is null
296: otherwise storing passed values */

Line 293: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

289: END IF;
290:
291: IF g1_debug_mode = 'Y' THEN
292: PA_DEBUG.g_err_stage := 'RTS10 : After sufficient parameter';
293: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
294: END IF;
295: /* Selecting distribution_rule from project all table only if the passed value is null
296: otherwise storing passed values */
297: /*

Line 325: PA_DEBUG.g_err_stage := 'RTS11 : After Rule parameter'||to_char(p_rate_calc_date,'dd-mon-yyyy');

321: NULL;
322: END;
323:
324: IF g1_debug_mode = 'Y' THEN
325: PA_DEBUG.g_err_stage := 'RTS11 : After Rule parameter'||to_char(p_rate_calc_date,'dd-mon-yyyy');
326: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
327:
328: PA_DEBUG.g_err_stage := 'RTS11.1 : checking para Quantity '||p_quantity||' calling mode '||p_calling_mode;
329: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

Line 326: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

322: END;
323:
324: IF g1_debug_mode = 'Y' THEN
325: PA_DEBUG.g_err_stage := 'RTS11 : After Rule parameter'||to_char(p_rate_calc_date,'dd-mon-yyyy');
326: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
327:
328: PA_DEBUG.g_err_stage := 'RTS11.1 : checking para Quantity '||p_quantity||' calling mode '||p_calling_mode;
329: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
330: -- dbms_output.put_line('distribution_rule '||l_distribution_rule||'calling mode '||p_calling_mode||'item id' ||p_item_id||' proj id '||p_project_id||' p_person_id '||p_person_id||' date '||to_char(p_rate_calc_date,'dd-mon-yyyy'));

Line 328: PA_DEBUG.g_err_stage := 'RTS11.1 : checking para Quantity '||p_quantity||' calling mode '||p_calling_mode;

324: IF g1_debug_mode = 'Y' THEN
325: PA_DEBUG.g_err_stage := 'RTS11 : After Rule parameter'||to_char(p_rate_calc_date,'dd-mon-yyyy');
326: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
327:
328: PA_DEBUG.g_err_stage := 'RTS11.1 : checking para Quantity '||p_quantity||' calling mode '||p_calling_mode;
329: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
330: -- dbms_output.put_line('distribution_rule '||l_distribution_rule||'calling mode '||p_calling_mode||'item id' ||p_item_id||' proj id '||p_project_id||' p_person_id '||p_person_id||' date '||to_char(p_rate_calc_date,'dd-mon-yyyy'));
331: END IF;
332:

Line 329: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

325: PA_DEBUG.g_err_stage := 'RTS11 : After Rule parameter'||to_char(p_rate_calc_date,'dd-mon-yyyy');
326: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
327:
328: PA_DEBUG.g_err_stage := 'RTS11.1 : checking para Quantity '||p_quantity||' calling mode '||p_calling_mode;
329: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
330: -- dbms_output.put_line('distribution_rule '||l_distribution_rule||'calling mode '||p_calling_mode||'item id' ||p_item_id||' proj id '||p_project_id||' p_person_id '||p_person_id||' date '||to_char(p_rate_calc_date,'dd-mon-yyyy'));
331: END IF;
332:
333: /* Selecting expenditure org id , type ,organization id , forecast job id and forecast job group

Line 350: PA_DEBUG.g_err_stage := 'RTS12 : After Role expenditure org id/orgnz id , job,job grp id par';

346: WHERE project_id = p_project_id
347: AND assignment_id = p_item_id;
348:
349: IF g1_debug_mode = 'Y' THEN
350: PA_DEBUG.g_err_stage := 'RTS12 : After Role expenditure org id/orgnz id , job,job grp id par';
351: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
352: END IF;
353:
354: ELSIF ( p_calling_mode = 'ASSIGNMENT') THEN

Line 351: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

347: AND assignment_id = p_item_id;
348:
349: IF g1_debug_mode = 'Y' THEN
350: PA_DEBUG.g_err_stage := 'RTS12 : After Role expenditure org id/orgnz id , job,job grp id par';
351: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
352: END IF;
353:
354: ELSIF ( p_calling_mode = 'ASSIGNMENT') THEN
355: BEGIN -- Added for Bug 3877942

Line 367: PA_DEBUG.g_err_stage := 'RTS12 : No Record in PA_RESOURCES_DENORM for this period start date' || p_rate_calc_date;

363: NVL(TRUNC(Resource_effective_end_date),p_rate_calc_date));
364: EXCEPTION -- Added Exception block for Bug 3877942
365: WHEN NO_DATA_FOUND THEN
366: IF g1_debug_mode = 'Y' THEN
367: PA_DEBUG.g_err_stage := 'RTS12 : No Record in PA_RESOURCES_DENORM for this period start date' || p_rate_calc_date;
368: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
369: END IF;
370: PA_DEBUG.Reset_Curr_Function;
371: RETURN;

Line 368: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

364: EXCEPTION -- Added Exception block for Bug 3877942
365: WHEN NO_DATA_FOUND THEN
366: IF g1_debug_mode = 'Y' THEN
367: PA_DEBUG.g_err_stage := 'RTS12 : No Record in PA_RESOURCES_DENORM for this period start date' || p_rate_calc_date;
368: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
369: END IF;
370: PA_DEBUG.Reset_Curr_Function;
371: RETURN;
372: END;

Line 370: PA_DEBUG.Reset_Curr_Function;

366: IF g1_debug_mode = 'Y' THEN
367: PA_DEBUG.g_err_stage := 'RTS12 : No Record in PA_RESOURCES_DENORM for this period start date' || p_rate_calc_date;
368: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
369: END IF;
370: PA_DEBUG.Reset_Curr_Function;
371: RETURN;
372: END;
373:
374: IF g1_debug_mode = 'Y' THEN

Line 375: PA_DEBUG.g_err_stage := 'RTS12 : After Asgn resource org id/orgnz id , job id par';

371: RETURN;
372: END;
373:
374: IF g1_debug_mode = 'Y' THEN
375: PA_DEBUG.g_err_stage := 'RTS12 : After Asgn resource org id/orgnz id , job id par';
376: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
377: END IF;
378:
379: SELECT job_group_id

Line 376: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

372: END;
373:
374: IF g1_debug_mode = 'Y' THEN
375: PA_DEBUG.g_err_stage := 'RTS12 : After Asgn resource org id/orgnz id , job id par';
376: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
377: END IF;
378:
379: SELECT job_group_id
380: INTO l_forecast_job_group_id

Line 385: PA_DEBUG.g_err_stage := 'RTS13 : After Asgn job grp id par';

381: FROM per_jobs
382: WHERE job_id = l_forecast_job_id;
383:
384: IF g1_debug_mode = 'Y' THEN
385: PA_DEBUG.g_err_stage := 'RTS13 : After Asgn job grp id par';
386: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
387: END IF;
388:
389: SELECT expenditure_type

Line 386: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

382: WHERE job_id = l_forecast_job_id;
383:
384: IF g1_debug_mode = 'Y' THEN
385: PA_DEBUG.g_err_stage := 'RTS13 : After Asgn job grp id par';
386: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
387: END IF;
388:
389: SELECT expenditure_type
390: INTO l_expenditure_type

Line 400: PA_DEBUG.g_err_stage := 'RTS13.1 : Selecting override organization if any .';

396: ELSE /*for p_calling_mode <> 'ROLE' /'ASSIGNMENT'*/
397: /*LCE Changes : Selecting override organization if any. */
398:
399: IF g1_debug_mode = 'Y' THEN
400: PA_DEBUG.g_err_stage := 'RTS13.1 : Selecting override organization if any .';
401: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
402: END IF;
403:
404: PA_COST.override_exp_organization(P_item_date => p_rate_calc_date ,

Line 401: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

397: /*LCE Changes : Selecting override organization if any. */
398:
399: IF g1_debug_mode = 'Y' THEN
400: PA_DEBUG.g_err_stage := 'RTS13.1 : Selecting override organization if any .';
401: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
402: END IF;
403:
404: PA_COST.override_exp_organization(P_item_date => p_rate_calc_date ,
405: P_person_id => p_person_id ,

Line 416: PA_DEBUG.g_err_stage := 'RTS13.2 : No override ...selecting expenditure organization id ';

412: x_msg_data => l_msg_data
413: );
414:
415: IF g1_debug_mode = 'Y' THEN
416: PA_DEBUG.g_err_stage := 'RTS13.2 : No override ...selecting expenditure organization id ';
417: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
418: END IF;
419:
420: IF l_overr_to_organization_id is NULL THEN

Line 417: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

413: );
414:
415: IF g1_debug_mode = 'Y' THEN
416: PA_DEBUG.g_err_stage := 'RTS13.2 : No override ...selecting expenditure organization id ';
417: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
418: END IF;
419:
420: IF l_overr_to_organization_id is NULL THEN
421: BEGIN

Line 436: PA_DEBUG.g_err_stage :='RTS13.3 :No Expenditure organization id assigned to the person id :'||

432:
433: EXCEPTION
434: WHEN NO_DATA_FOUND THEN
435: IF g1_debug_mode = 'Y' THEN
436: PA_DEBUG.g_err_stage :='RTS13.3 :No Expenditure organization id assigned to the person id :'||
437: P_person_id;
438: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
439: END IF;
440: x_cost_rejct_reason :='NO_ASSIGN';

Line 438: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

434: WHEN NO_DATA_FOUND THEN
435: IF g1_debug_mode = 'Y' THEN
436: PA_DEBUG.g_err_stage :='RTS13.3 :No Expenditure organization id assigned to the person id :'||
437: P_person_id;
438: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
439: END IF;
440: x_cost_rejct_reason :='NO_ASSIGN';
441: END;
442: ELSE

Line 452: PA_DEBUG.g_err_stage := 'RTS14 : After Asgn expenditure_type par';

448:
449: END IF;
450:
451: IF g1_debug_mode = 'Y' THEN
452: PA_DEBUG.g_err_stage := 'RTS14 : After Asgn expenditure_type par';
453: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
454: END IF;
455:
456: IF p_expenditure_org_id IS NOT NULL THEN

Line 453: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

449: END IF;
450:
451: IF g1_debug_mode = 'Y' THEN
452: PA_DEBUG.g_err_stage := 'RTS14 : After Asgn expenditure_type par';
453: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
454: END IF;
455:
456: IF p_expenditure_org_id IS NOT NULL THEN
457: l_expenditure_org_id := p_expenditure_org_id ;

Line 503: PA_DEBUG.g_err_stage := 'RTS15 : After currency code par';

499:
500: l_expenditure_curr_code_burdn := l_expenditure_currency_code; /* Made for Org Forecasting */
501:
502: IF g1_debug_mode = 'Y' THEN
503: PA_DEBUG.g_err_stage := 'RTS15 : After currency code par';
504: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
505: END IF;
506: -- dbms_output.put_line('l_expenditure_currency_code '||l_expenditure_currency_code);
507:

Line 504: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

500: l_expenditure_curr_code_burdn := l_expenditure_currency_code; /* Made for Org Forecasting */
501:
502: IF g1_debug_mode = 'Y' THEN
503: PA_DEBUG.g_err_stage := 'RTS15 : After currency code par';
504: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
505: END IF;
506: -- dbms_output.put_line('l_expenditure_currency_code '||l_expenditure_currency_code);
507:
508:

Line 523: PA_DEBUG.g_err_stage := 'RTS16 : After task level cost multi name par - prj type '||p_project_type; --Bug 7423839

519: END IF;
520: END IF;
521:
522: IF g1_debug_mode = 'Y' THEN
523: PA_DEBUG.g_err_stage := 'RTS16 : After task level cost multi name par - prj type '||p_project_type; --Bug 7423839
524: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
525: END IF;
526: -- dbms_output.put_line('1');
527:

Line 524: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

520: END IF;
521:
522: IF g1_debug_mode = 'Y' THEN
523: PA_DEBUG.g_err_stage := 'RTS16 : After task level cost multi name par - prj type '||p_project_type; --Bug 7423839
524: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
525: END IF;
526: -- dbms_output.put_line('1');
527:
528: /* Selecting project type from project types table only if the

Line 544: PA_DEBUG.g_err_stage := 'RTS17 : After Project type par- prj type '||l_project_type; --Bug 7423839;

540: l_project_type := p_project_type;
541: END IF;
542:
543: IF g1_debug_mode = 'Y' THEN
544: PA_DEBUG.g_err_stage := 'RTS17 : After Project type par- prj type '||l_project_type; --Bug 7423839;
545: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
546: -- dbms_output.put_line('l_project_type '||l_project_type);
547: END IF;
548:

Line 545: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

541: END IF;
542:
543: IF g1_debug_mode = 'Y' THEN
544: PA_DEBUG.g_err_stage := 'RTS17 : After Project type par- prj type '||l_project_type; --Bug 7423839;
545: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
546: -- dbms_output.put_line('l_project_type '||l_project_type);
547: END IF;
548:
549: /* Selecting project org id, project currency code, project bill job

Line 606: PA_DEBUG.g_err_stage := 'RTS18 : After emp,job rate schedule , currency code and org id par';

602: WHERE project_id = p_project_id;
603:
604: IF g1_debug_mode = 'Y' THEN
605: -- dbms_output.put_line('projfunc currency '||l_projfunc_currency_code);
606: PA_DEBUG.g_err_stage := 'RTS18 : After emp,job rate schedule , currency code and org id par';
607: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
608: END IF;
609:
610: ELSE

Line 607: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

603:
604: IF g1_debug_mode = 'Y' THEN
605: -- dbms_output.put_line('projfunc currency '||l_projfunc_currency_code);
606: PA_DEBUG.g_err_stage := 'RTS18 : After emp,job rate schedule , currency code and org id par';
607: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
608: END IF;
609:
610: ELSE
611: IF p_projfunc_currency_code IS NOT NULL THEN

Line 723: PA_DEBUG.g_err_stage := 'RTS19 : After cost job group id and cost rate schedule id par';

719: l_job_cost_rate_schedule_id := p_job_cost_rate_schedule_id;
720: END IF;
721:
722: IF g1_debug_mode = 'Y' THEN
723: PA_DEBUG.g_err_stage := 'RTS19 : After cost job group id and cost rate schedule id par';
724: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
725: END IF;
726: -- dbms_output.put_line('l_proj_cost_job_grp_id '||to_char(l_proj_cost_job_grp_id));
727: -- dbms_output.put_line('l_job_cost_rate_schedule_id '||to_char(l_job_cost_rate_schedule_id));

Line 724: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

720: END IF;
721:
722: IF g1_debug_mode = 'Y' THEN
723: PA_DEBUG.g_err_stage := 'RTS19 : After cost job group id and cost rate schedule id par';
724: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
725: END IF;
726: -- dbms_output.put_line('l_proj_cost_job_grp_id '||to_char(l_proj_cost_job_grp_id));
727: -- dbms_output.put_line('l_job_cost_rate_schedule_id '||to_char(l_job_cost_rate_schedule_id));
728:

Line 753: PA_DEBUG.g_err_stage := 'RTS20 : After fixed date par';

749:
750: */
751:
752: IF g1_debug_mode = 'Y' THEN
753: PA_DEBUG.g_err_stage := 'RTS20 : After fixed date par';
754: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
755:
756: -- dbms_output.put_line('l_job_cost_rate_schedule_id '||to_char(l_job_cost_rate_schedule_id));
757:

Line 754: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

750: */
751:
752: IF g1_debug_mode = 'Y' THEN
753: PA_DEBUG.g_err_stage := 'RTS20 : After fixed date par';
754: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
755:
756: -- dbms_output.put_line('l_job_cost_rate_schedule_id '||to_char(l_job_cost_rate_schedule_id));
757:
758:

Line 759: PA_DEBUG.g_err_stage := 'RT11 : After Validation Entering PA_RATE_PVT_PKG.Get_Item_Amount';

755:
756: -- dbms_output.put_line('l_job_cost_rate_schedule_id '||to_char(l_job_cost_rate_schedule_id));
757:
758:
759: PA_DEBUG.g_err_stage := 'RT11 : After Validation Entering PA_RATE_PVT_PKG.Get_Item_Amount';
760: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
761:
762: -- dbms_output.put_line('l_labor_schedule_fixed_date '||to_char(l_labor_schedule_fixed_date,'dd-mon-yyyy'));
763:

Line 760: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

756: -- dbms_output.put_line('l_job_cost_rate_schedule_id '||to_char(l_job_cost_rate_schedule_id));
757:
758:
759: PA_DEBUG.g_err_stage := 'RT11 : After Validation Entering PA_RATE_PVT_PKG.Get_Item_Amount';
760: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
761:
762: -- dbms_output.put_line('l_labor_schedule_fixed_date '||to_char(l_labor_schedule_fixed_date,'dd-mon-yyyy'));
763:
764: END IF;

Line 798: PA_DEBUG.g_err_stage := 'RT12 : Entering PA_COST.get_raw_cost';

794:
795: IF ( (p_calling_mode = 'ASSIGNMENT') OR (p_calling_mode = 'UNASSIGNED') ) THEN
796:
797: IF g1_debug_mode = 'Y' THEN
798: PA_DEBUG.g_err_stage := 'RT12 : Entering PA_COST.get_raw_cost';
799: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
800: PA_DEBUG.Log_Message ('p_person_id '||p_person_id||'l_expenditure_org_id '||l_expenditure_org_id); --skkoppul
801: PA_DEBUG.Log_Message ('l_expenditure_organization_id '||l_expenditure_organization_id||' l_labor_cost_mult_name '||l_labor_cost_mult_name);
802: PA_DEBUG.Log_Message ('p_rate_calc_date '||p_rate_calc_date||' l_expenditure_curr_code_burdn '||l_expenditure_curr_code_burdn||' p_quantity'||p_quantity);

Line 799: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

795: IF ( (p_calling_mode = 'ASSIGNMENT') OR (p_calling_mode = 'UNASSIGNED') ) THEN
796:
797: IF g1_debug_mode = 'Y' THEN
798: PA_DEBUG.g_err_stage := 'RT12 : Entering PA_COST.get_raw_cost';
799: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
800: PA_DEBUG.Log_Message ('p_person_id '||p_person_id||'l_expenditure_org_id '||l_expenditure_org_id); --skkoppul
801: PA_DEBUG.Log_Message ('l_expenditure_organization_id '||l_expenditure_organization_id||' l_labor_cost_mult_name '||l_labor_cost_mult_name);
802: PA_DEBUG.Log_Message ('p_rate_calc_date '||p_rate_calc_date||' l_expenditure_curr_code_burdn '||l_expenditure_curr_code_burdn||' p_quantity'||p_quantity);
803: END IF;

Line 800: PA_DEBUG.Log_Message ('p_person_id '||p_person_id||'l_expenditure_org_id '||l_expenditure_org_id); --skkoppul

796:
797: IF g1_debug_mode = 'Y' THEN
798: PA_DEBUG.g_err_stage := 'RT12 : Entering PA_COST.get_raw_cost';
799: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
800: PA_DEBUG.Log_Message ('p_person_id '||p_person_id||'l_expenditure_org_id '||l_expenditure_org_id); --skkoppul
801: PA_DEBUG.Log_Message ('l_expenditure_organization_id '||l_expenditure_organization_id||' l_labor_cost_mult_name '||l_labor_cost_mult_name);
802: PA_DEBUG.Log_Message ('p_rate_calc_date '||p_rate_calc_date||' l_expenditure_curr_code_burdn '||l_expenditure_curr_code_burdn||' p_quantity'||p_quantity);
803: END IF;
804:

Line 801: PA_DEBUG.Log_Message ('l_expenditure_organization_id '||l_expenditure_organization_id||' l_labor_cost_mult_name '||l_labor_cost_mult_name);

797: IF g1_debug_mode = 'Y' THEN
798: PA_DEBUG.g_err_stage := 'RT12 : Entering PA_COST.get_raw_cost';
799: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
800: PA_DEBUG.Log_Message ('p_person_id '||p_person_id||'l_expenditure_org_id '||l_expenditure_org_id); --skkoppul
801: PA_DEBUG.Log_Message ('l_expenditure_organization_id '||l_expenditure_organization_id||' l_labor_cost_mult_name '||l_labor_cost_mult_name);
802: PA_DEBUG.Log_Message ('p_rate_calc_date '||p_rate_calc_date||' l_expenditure_curr_code_burdn '||l_expenditure_curr_code_burdn||' p_quantity'||p_quantity);
803: END IF;
804:
805:

Line 802: PA_DEBUG.Log_Message ('p_rate_calc_date '||p_rate_calc_date||' l_expenditure_curr_code_burdn '||l_expenditure_curr_code_burdn||' p_quantity'||p_quantity);

798: PA_DEBUG.g_err_stage := 'RT12 : Entering PA_COST.get_raw_cost';
799: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
800: PA_DEBUG.Log_Message ('p_person_id '||p_person_id||'l_expenditure_org_id '||l_expenditure_org_id); --skkoppul
801: PA_DEBUG.Log_Message ('l_expenditure_organization_id '||l_expenditure_organization_id||' l_labor_cost_mult_name '||l_labor_cost_mult_name);
802: PA_DEBUG.Log_Message ('p_rate_calc_date '||p_rate_calc_date||' l_expenditure_curr_code_burdn '||l_expenditure_curr_code_burdn||' p_quantity'||p_quantity);
803: END IF;
804:
805:
806: begin

Line 878: PA_DEBUG.g_err_stage := 'Error in PA_COST.get_raw_cost';

874: x_msg_data => l_msg_data
875: );
876: exception --Bug 7423839
877: when others then
878: PA_DEBUG.g_err_stage := 'Error in PA_COST.get_raw_cost';
879: IF g1_debug_mode = 'Y' THEN
880: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
881: PA_DEBUG.Log_Message(p_message => 'x_msg_count '||x_msg_count || ' l_msg_data '||substr(l_msg_data,1,300)||' ret status '||l_x_return_status);
882: PA_DEBUG.Log_Message(p_message => SQLERRM);

Line 880: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

876: exception --Bug 7423839
877: when others then
878: PA_DEBUG.g_err_stage := 'Error in PA_COST.get_raw_cost';
879: IF g1_debug_mode = 'Y' THEN
880: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
881: PA_DEBUG.Log_Message(p_message => 'x_msg_count '||x_msg_count || ' l_msg_data '||substr(l_msg_data,1,300)||' ret status '||l_x_return_status);
882: PA_DEBUG.Log_Message(p_message => SQLERRM);
883: END IF;
884: end;

Line 881: PA_DEBUG.Log_Message(p_message => 'x_msg_count '||x_msg_count || ' l_msg_data '||substr(l_msg_data,1,300)||' ret status '||l_x_return_status);

877: when others then
878: PA_DEBUG.g_err_stage := 'Error in PA_COST.get_raw_cost';
879: IF g1_debug_mode = 'Y' THEN
880: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
881: PA_DEBUG.Log_Message(p_message => 'x_msg_count '||x_msg_count || ' l_msg_data '||substr(l_msg_data,1,300)||' ret status '||l_x_return_status);
882: PA_DEBUG.Log_Message(p_message => SQLERRM);
883: END IF;
884: end;
885:

Line 882: PA_DEBUG.Log_Message(p_message => SQLERRM);

878: PA_DEBUG.g_err_stage := 'Error in PA_COST.get_raw_cost';
879: IF g1_debug_mode = 'Y' THEN
880: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
881: PA_DEBUG.Log_Message(p_message => 'x_msg_count '||x_msg_count || ' l_msg_data '||substr(l_msg_data,1,300)||' ret status '||l_x_return_status);
882: PA_DEBUG.Log_Message(p_message => SQLERRM);
883: END IF;
884: end;
885:
886:

Line 892: PA_DEBUG.g_err_stage := 'RT13 : Leaving PA_COST.get_raw_cost';

888: x_exp_func_raw_cost := l_exp_func_raw_cost; /* Added for Org Forecasting */
889: x_exp_func_curr_code := l_expenditure_curr_code_burdn; /* Added for Org Forecasting */
890:
891: IF g1_debug_mode = 'Y' THEN
892: PA_DEBUG.g_err_stage := 'RT13 : Leaving PA_COST.get_raw_cost';
893: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
894: END IF;
895:
896: -- dbms_output.put_line('end of get raw cost '||l_x_return_status||' rate '||x_exp_func_raw_cost_rate||' raw cost '||x_exp_func_raw_cost||' Currency '||l_expenditure_currency_code);

Line 893: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

889: x_exp_func_curr_code := l_expenditure_curr_code_burdn; /* Added for Org Forecasting */
890:
891: IF g1_debug_mode = 'Y' THEN
892: PA_DEBUG.g_err_stage := 'RT13 : Leaving PA_COST.get_raw_cost';
893: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
894: END IF;
895:
896: -- dbms_output.put_line('end of get raw cost '||l_x_return_status||' rate '||x_exp_func_raw_cost_rate||' raw cost '||x_exp_func_raw_cost||' Currency '||l_expenditure_currency_code);
897:

Line 905: PA_DEBUG.g_err_stage := 'RT12 : Entering PA_COST.requirement_raw_cost';

901: -- dbms_output.put_line('start of req raw cost '||l_x_return_status);
902:
903:
904: IF g1_debug_mode = 'Y' THEN
905: PA_DEBUG.g_err_stage := 'RT12 : Entering PA_COST.requirement_raw_cost';
906: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
907: END IF;
908:
909: PA_COST.requirement_raw_cost(

Line 906: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

902:
903:
904: IF g1_debug_mode = 'Y' THEN
905: PA_DEBUG.g_err_stage := 'RT12 : Entering PA_COST.requirement_raw_cost';
906: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
907: END IF;
908:
909: PA_COST.requirement_raw_cost(
910: p_forecast_cost_job_group_id => l_forecast_job_group_id ,

Line 935: PA_DEBUG.g_err_stage := 'RT13 : Leaving PA_COST.requirement_raw_cost';

931: x_exp_func_raw_cost := l_exp_func_raw_cost; /* Added for Org Forecasting */
932: x_exp_func_curr_code := l_expenditure_curr_code_burdn; /* Added for Org Forecasting */
933:
934: IF g1_debug_mode = 'Y' THEN
935: PA_DEBUG.g_err_stage := 'RT13 : Leaving PA_COST.requirement_raw_cost';
936: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
937: END IF;
938: -- dbms_output.put_line('end of req raw cost '||l_x_return_status||' : rate '||x_exp_func_raw_cost_rate||' cost '||x_exp_func_raw_cost||' Currency '||l_expenditure_currency_code);
939:

Line 936: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

932: x_exp_func_curr_code := l_expenditure_curr_code_burdn; /* Added for Org Forecasting */
933:
934: IF g1_debug_mode = 'Y' THEN
935: PA_DEBUG.g_err_stage := 'RT13 : Leaving PA_COST.requirement_raw_cost';
936: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
937: END IF;
938: -- dbms_output.put_line('end of req raw cost '||l_x_return_status||' : rate '||x_exp_func_raw_cost_rate||' cost '||x_exp_func_raw_cost||' Currency '||l_expenditure_currency_code);
939:
940: END IF;

Line 972: PA_DEBUG.g_err_stage := 'RT14 : Entering PA_COST.override_exp_organization';

968: IF (p_calling_mode = 'ASSIGNMENT') THEN
969:
970: -- dbms_output.put_line('start of override '||l_x_return_status);
971: IF g1_debug_mode = 'Y' THEN
972: PA_DEBUG.g_err_stage := 'RT14 : Entering PA_COST.override_exp_organization';
973: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
974: END IF;
975:
976: PA_COST.override_exp_organization(P_item_date => p_rate_calc_date ,

Line 973: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

969:
970: -- dbms_output.put_line('start of override '||l_x_return_status);
971: IF g1_debug_mode = 'Y' THEN
972: PA_DEBUG.g_err_stage := 'RT14 : Entering PA_COST.override_exp_organization';
973: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
974: END IF;
975:
976: PA_COST.override_exp_organization(P_item_date => p_rate_calc_date ,
977: P_person_id => p_person_id ,

Line 988: PA_DEBUG.g_err_stage := 'RT15 : Leaving PA_COST.override_exp_organization';

984: x_msg_data => l_msg_data
985: );
986:
987: IF g1_debug_mode = 'Y' THEN
988: PA_DEBUG.g_err_stage := 'RT15 : Leaving PA_COST.override_exp_organization';
989: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
990: END IF;
991:
992: -- dbms_output.put_line('end of override '||l_x_return_status ||' over id '||l_overr_to_organization_id);

Line 989: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

985: );
986:
987: IF g1_debug_mode = 'Y' THEN
988: PA_DEBUG.g_err_stage := 'RT15 : Leaving PA_COST.override_exp_organization';
989: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
990: END IF;
991:
992: -- dbms_output.put_line('end of override '||l_x_return_status ||' over id '||l_overr_to_organization_id);
993:

Line 1006: PA_DEBUG.g_err_stage := 'RT16 : Entering PA_COST.get_burdened_cost';

1002: IF (NVL(l_exp_func_raw_cost,0) <> 0) THEN
1003:
1004: /* Added for Org forecasting */
1005: IF g1_debug_mode = 'Y' THEN
1006: PA_DEBUG.g_err_stage := 'RT16 : Entering PA_COST.get_burdened_cost';
1007: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1008: END IF;
1009:
1010: PA_COST.get_burdened_cost(

Line 1007: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1003:
1004: /* Added for Org forecasting */
1005: IF g1_debug_mode = 'Y' THEN
1006: PA_DEBUG.g_err_stage := 'RT16 : Entering PA_COST.get_burdened_cost';
1007: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1008: END IF;
1009:
1010: PA_COST.get_burdened_cost(
1011: p_project_type => l_project_type ,

Line 1036: PA_DEBUG.g_err_stage := 'RT17 : Leaving PA_COST.get_burdened_cost';

1032: x_exp_func_burdened_cost := l_exp_func_burdened_cost; /* Added for Org Forecasting */
1033: x_exp_func_curr_code := l_expenditure_currency_code; /* Added for Org Forecasting */
1034:
1035: IF g1_debug_mode = 'Y' THEN
1036: PA_DEBUG.g_err_stage := 'RT17 : Leaving PA_COST.get_burdened_cost';
1037: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1038: END IF;
1039:
1040: -- dbms_output.put_line('end of get burden cost '||l_x_return_status||' burden cost '||x_exp_func_burdened_cost||' rate '||x_exp_func_burdened_cost_rate);

Line 1037: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1033: x_exp_func_curr_code := l_expenditure_currency_code; /* Added for Org Forecasting */
1034:
1035: IF g1_debug_mode = 'Y' THEN
1036: PA_DEBUG.g_err_stage := 'RT17 : Leaving PA_COST.get_burdened_cost';
1037: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1038: END IF;
1039:
1040: -- dbms_output.put_line('end of get burden cost '||l_x_return_status||' burden cost '||x_exp_func_burdened_cost||' rate '||x_exp_func_burdened_cost_rate);
1041:

Line 1067: PA_DEBUG.g_err_stage := 'RT18 : Entering PA_COST.get_proj_raw_burdened_cost';

1063:
1064: -- dbms_output.put_line('start of Get_Converted_Cost_Amounts '||l_x_return_status);
1065:
1066: IF g1_debug_mode = 'Y' THEN
1067: PA_DEBUG.g_err_stage := 'RT18 : Entering PA_COST.get_proj_raw_burdened_cost';
1068: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1069: END IF;
1070:
1071: -- dbms_output.put_line(' error in multi cost 2 '||x_cost_rejct_reason||' amount '||l_exp_func_raw_cost);

Line 1068: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1064: -- dbms_output.put_line('start of Get_Converted_Cost_Amounts '||l_x_return_status);
1065:
1066: IF g1_debug_mode = 'Y' THEN
1067: PA_DEBUG.g_err_stage := 'RT18 : Entering PA_COST.get_proj_raw_burdened_cost';
1068: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1069: END IF;
1070:
1071: -- dbms_output.put_line(' error in multi cost 2 '||x_cost_rejct_reason||' amount '||l_exp_func_raw_cost);
1072:

Line 1153: PA_DEBUG.g_err_stage := 'RT19 : Leaving PA_COST.get_proj_raw_burdened_cost';

1149: -- dbms_output.put_line(' Inside error in multi cost 3 '||x_cost_rejct_reason);
1150: /* Deleted this proc PA_COST.get_projfunc_raw_burdened_cost() for Org Forecasting */
1151:
1152: IF g1_debug_mode = 'Y' THEN
1153: PA_DEBUG.g_err_stage := 'RT19 : Leaving PA_COST.get_proj_raw_burdened_cost';
1154: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1155: END IF;
1156:
1157: -- dbms_output.put_line('end of Get_Converted_Cost_Amounts '||l_x_return_status||' proj cost '||x_projfunc_raw_cost||' proj rate '||x_projfunc_raw_cost_rate

Line 1154: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1150: /* Deleted this proc PA_COST.get_projfunc_raw_burdened_cost() for Org Forecasting */
1151:
1152: IF g1_debug_mode = 'Y' THEN
1153: PA_DEBUG.g_err_stage := 'RT19 : Leaving PA_COST.get_proj_raw_burdened_cost';
1154: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1155: END IF;
1156:
1157: -- dbms_output.put_line('end of Get_Converted_Cost_Amounts '||l_x_return_status||' proj cost '||x_projfunc_raw_cost||' proj rate '||x_projfunc_raw_cost_rate
1158: -- ||' proj bur co '||x_projfunc_burdened_cost||' proj bur rate '||x_projfunc_burdened_cost_rate||' PROJECT BURDEN COST '||x_project_burdned_cst);

Line 1244: PA_DEBUG.g_err_stage := 'RT20 : Entering PA_REVENUE.get_rev_amt';

1240:
1241: -- dbms_output.put_line('start of get rev amt '||l_x_return_status);
1242:
1243: IF g1_debug_mode = 'Y' THEN
1244: PA_DEBUG.g_err_stage := 'RT20 : Entering PA_REVENUE.get_rev_amt';
1245: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1246: END IF;
1247:
1248: PA_REVENUE.Assignment_Rev_Amt(

Line 1245: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1241: -- dbms_output.put_line('start of get rev amt '||l_x_return_status);
1242:
1243: IF g1_debug_mode = 'Y' THEN
1244: PA_DEBUG.g_err_stage := 'RT20 : Entering PA_REVENUE.get_rev_amt';
1245: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1246: END IF;
1247:
1248: PA_REVENUE.Assignment_Rev_Amt(
1249: p_project_id => p_project_id ,

Line 1298: PA_DEBUG.g_err_stage := 'RT21 : Leaving PA_REVENUE.get_rev_amt';

1294: x_txn_rev_raw_revenue := l_txn_rev_raw_revenue;
1295: x_rev_txn_curr_code := l_rev_txn_curr_code;
1296:
1297: IF g1_debug_mode = 'Y' THEN
1298: PA_DEBUG.g_err_stage := 'RT21 : Leaving PA_REVENUE.get_rev_amt';
1299: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1300: END IF;
1301: -- dbms_output.put_line('end of get rev amt '||l_x_return_status|| ' rate '||x_projfunc_bill_rate||' rev '||x_projfunc_raw_revenue);
1302: ELSIF (p_calling_mode= 'ROLE' ) THEN

Line 1299: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1295: x_rev_txn_curr_code := l_rev_txn_curr_code;
1296:
1297: IF g1_debug_mode = 'Y' THEN
1298: PA_DEBUG.g_err_stage := 'RT21 : Leaving PA_REVENUE.get_rev_amt';
1299: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1300: END IF;
1301: -- dbms_output.put_line('end of get rev amt '||l_x_return_status|| ' rate '||x_projfunc_bill_rate||' rev '||x_projfunc_raw_revenue);
1302: ELSIF (p_calling_mode= 'ROLE' ) THEN
1303:

Line 1307: PA_DEBUG.g_err_stage := 'RT20 : Entering PA_REVENUE.requirement_rev_amt';

1303:
1304: -- dbms_output.put_line('start of req rev amt '||l_x_return_status);
1305:
1306: IF g1_debug_mode = 'Y' THEN
1307: PA_DEBUG.g_err_stage := 'RT20 : Entering PA_REVENUE.requirement_rev_amt';
1308: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1309: END IF;
1310:
1311: PA_REVENUE.Requirement_Rev_Amt(

Line 1308: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1304: -- dbms_output.put_line('start of req rev amt '||l_x_return_status);
1305:
1306: IF g1_debug_mode = 'Y' THEN
1307: PA_DEBUG.g_err_stage := 'RT20 : Entering PA_REVENUE.requirement_rev_amt';
1308: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1309: END IF;
1310:
1311: PA_REVENUE.Requirement_Rev_Amt(
1312: p_project_id => p_project_id ,

Line 1358: PA_DEBUG.g_err_stage := 'RT21 : Leaving PA_REVENUE.requirement_rev_amt';

1354: x_txn_rev_raw_revenue := l_txn_rev_raw_revenue;
1355: x_rev_txn_curr_code := l_rev_txn_curr_code;
1356:
1357: IF g1_debug_mode = 'Y' THEN
1358: PA_DEBUG.g_err_stage := 'RT21 : Leaving PA_REVENUE.requirement_rev_amt';
1359: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1360: END IF;
1361:
1362: -- dbms_output.put_line('end of req rev amt '||l_x_return_status||' rate '||x_projfunc_bill_rate||' rev '||x_projfunc_raw_revenue);

Line 1359: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1355: x_rev_txn_curr_code := l_rev_txn_curr_code;
1356:
1357: IF g1_debug_mode = 'Y' THEN
1358: PA_DEBUG.g_err_stage := 'RT21 : Leaving PA_REVENUE.requirement_rev_amt';
1359: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1360: END IF;
1361:
1362: -- dbms_output.put_line('end of req rev amt '||l_x_return_status||' rate '||x_projfunc_bill_rate||' rev '||x_projfunc_raw_revenue);
1363:

Line 1468: PA_DEBUG.g_err_stage := 'RT22 : Leaving PA_RATE_PVT_PKG.get_item_amount';

1464:
1465: -- dbms_output.put_line(' End error in multi cost '||x_cost_rejct_reason);
1466: -- dbms_output.put_line('end of procs '||l_x_return_status);
1467: IF g1_debug_mode = 'Y' THEN
1468: PA_DEBUG.g_err_stage := 'RT22 : Leaving PA_RATE_PVT_PKG.get_item_amount';
1469: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1470: PA_DEBUG.Reset_Curr_Function;
1471: END IF;
1472:

Line 1469: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1465: -- dbms_output.put_line(' End error in multi cost '||x_cost_rejct_reason);
1466: -- dbms_output.put_line('end of procs '||l_x_return_status);
1467: IF g1_debug_mode = 'Y' THEN
1468: PA_DEBUG.g_err_stage := 'RT22 : Leaving PA_RATE_PVT_PKG.get_item_amount';
1469: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1470: PA_DEBUG.Reset_Curr_Function;
1471: END IF;
1472:
1473:

Line 1470: PA_DEBUG.Reset_Curr_Function;

1466: -- dbms_output.put_line('end of procs '||l_x_return_status);
1467: IF g1_debug_mode = 'Y' THEN
1468: PA_DEBUG.g_err_stage := 'RT22 : Leaving PA_RATE_PVT_PKG.get_item_amount';
1469: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1470: PA_DEBUG.Reset_Curr_Function;
1471: END IF;
1472:
1473:
1474: EXCEPTION

Line 1477: PA_DEBUG.Reset_Curr_Function;

1473:
1474: EXCEPTION
1475: WHEN l_insufficient_parameters THEN
1476: IF g1_debug_mode = 'Y' THEN
1477: PA_DEBUG.Reset_Curr_Function;
1478: END IF;
1479: x_return_status := FND_API.G_RET_STS_ERROR;
1480: x_msg_count := 1;
1481: x_msg_data := 'PA_FCST_INSUFFICIENT_PARA';

Line 1486: PA_DEBUG.Reset_Curr_Function;

1482: x_others_rejct_reason := 'PA_FCST_INSUFFICIENT_PARA';
1483:
1484: WHEN l_raw_cost_null THEN
1485: IF g1_debug_mode = 'Y' THEN
1486: PA_DEBUG.Reset_Curr_Function;
1487: END IF;
1488: x_return_status := FND_API.G_RET_STS_ERROR;
1489: x_cost_rejct_reason := 'PA_FCST_NO_COST_RATE';
1490: x_exp_func_raw_cost_rate := 0;

Line 1494: PA_DEBUG.Reset_Curr_Function;

1490: x_exp_func_raw_cost_rate := 0;
1491: x_exp_func_raw_cost := 0;
1492: WHEN l_raw_proj_cost_null THEN
1493: IF g1_debug_mode = 'Y' THEN
1494: PA_DEBUG.Reset_Curr_Function;
1495: END IF;
1496: x_return_status := FND_API.G_RET_STS_ERROR;
1497: x_cost_rejct_reason := 'PA_FCST_NO_COST_RATE';
1498: /* Added for Org Forecasting */

Line 1522: PA_DEBUG.Reset_Curr_Function;

1518:
1519: --dbms_output.put_line('exp2');
1520: WHEN l_raw_revenue_null THEN
1521: IF g1_debug_mode = 'Y' THEN
1522: PA_DEBUG.Reset_Curr_Function;
1523: END IF;
1524: x_return_status := FND_API.G_RET_STS_ERROR;
1525: x_rev_rejct_reason := 'PA_FCST_NO_BILL_RATE';
1526: x_txn_rev_bill_rt := 0;

Line 1533: PA_DEBUG.Reset_Curr_Function;

1529: --dbms_output.put_line('exp3');
1530:
1531: WHEN l_burdened_cost_null THEN
1532: IF g1_debug_mode = 'Y' THEN
1533: PA_DEBUG.Reset_Curr_Function;
1534: END IF;
1535: x_return_status := FND_API.G_RET_STS_ERROR;
1536: x_burdened_rejct_reason := 'PA_FCST_NO_COST_RATE';
1537: x_exp_func_burdened_cost_rate := 0;

Line 1544: PA_DEBUG.Reset_Curr_Function;

1540: --dbms_output.put_line('exp4');
1541:
1542: WHEN OTHERS THEN
1543: IF g1_debug_mode = 'Y' THEN
1544: PA_DEBUG.Reset_Curr_Function;
1545: END IF;
1546:
1547: --dbms_output.put_line('exp5'||SQLERRM);
1548:

Line 2212: PA_DEBUG.Set_Curr_Function( p_function => 'Get Initial Bill Rate');

2208:
2209: BEGIN
2210:
2211: IF g1_debug_mode = 'Y' THEN
2212: PA_DEBUG.Set_Curr_Function( p_function => 'Get Initial Bill Rate');
2213: PA_DEBUG.g_err_stage := 'RT50 : Before Validation PA_RATE_PVT_PKG.get_initial_bill_rate';
2214: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2215: END IF;
2216:

Line 2213: PA_DEBUG.g_err_stage := 'RT50 : Before Validation PA_RATE_PVT_PKG.get_initial_bill_rate';

2209: BEGIN
2210:
2211: IF g1_debug_mode = 'Y' THEN
2212: PA_DEBUG.Set_Curr_Function( p_function => 'Get Initial Bill Rate');
2213: PA_DEBUG.g_err_stage := 'RT50 : Before Validation PA_RATE_PVT_PKG.get_initial_bill_rate';
2214: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2215: END IF;
2216:
2217: /* Validating that the required parameters should not be null */

Line 2214: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

2210:
2211: IF g1_debug_mode = 'Y' THEN
2212: PA_DEBUG.Set_Curr_Function( p_function => 'Get Initial Bill Rate');
2213: PA_DEBUG.g_err_stage := 'RT50 : Before Validation PA_RATE_PVT_PKG.get_initial_bill_rate';
2214: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2215: END IF;
2216:
2217: /* Validating that the required parameters should not be null */
2218: IF ( p_assignment_type IS NULL) OR (p_asgn_start_date IS NULL ) OR (p_project_id IS NULL)

Line 2513: PA_DEBUG.g_err_stage := 'RT51 : After Validation PA_RATE_PVT_PKG.get_initial_bill_rate';

2509: l_calculate_cost_flag := p_calculate_cost_flag;
2510: END IF;
2511:
2512: IF g1_debug_mode = 'Y' THEN
2513: PA_DEBUG.g_err_stage := 'RT51 : After Validation PA_RATE_PVT_PKG.get_initial_bill_rate';
2514: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2515: END IF;
2516: /* Calling the rate calculation APIs */
2517:

Line 2514: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

2510: END IF;
2511:
2512: IF g1_debug_mode = 'Y' THEN
2513: PA_DEBUG.g_err_stage := 'RT51 : After Validation PA_RATE_PVT_PKG.get_initial_bill_rate';
2514: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2515: END IF;
2516: /* Calling the rate calculation APIs */
2517:
2518: --------------------------------------------

Line 2528: PA_DEBUG.g_err_stage := 'RT52 : Entering PA_COST.get_raw_cost';

2524:
2525: IF (l_calculate_cost_flag = 'Y') THEN /* Added this if to fix bug 2162965 */
2526: IF ( p_assignment_type = 'A') THEN
2527: IF g1_debug_mode = 'Y' THEN
2528: PA_DEBUG.g_err_stage := 'RT52 : Entering PA_COST.get_raw_cost';
2529: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2530: END IF;
2531:
2532: /* 12.2 payroll intg .. set the globals for HR rates .. */

Line 2529: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

2525: IF (l_calculate_cost_flag = 'Y') THEN /* Added this if to fix bug 2162965 */
2526: IF ( p_assignment_type = 'A') THEN
2527: IF g1_debug_mode = 'Y' THEN
2528: PA_DEBUG.g_err_stage := 'RT52 : Entering PA_COST.get_raw_cost';
2529: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2530: END IF;
2531:
2532: /* 12.2 payroll intg .. set the globals for HR rates .. */
2533:

Line 2607: PA_DEBUG.g_err_stage := 'RT53 : Leaving PA_COST.get_raw_cost';

2603: x_msg_data => x_msg_data
2604: );
2605:
2606: IF g1_debug_mode = 'Y' THEN
2607: PA_DEBUG.g_err_stage := 'RT53 : Leaving PA_COST.get_raw_cost';
2608: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2609: END IF;
2610:
2611: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 2608: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

2604: );
2605:
2606: IF g1_debug_mode = 'Y' THEN
2607: PA_DEBUG.g_err_stage := 'RT53 : Leaving PA_COST.get_raw_cost';
2608: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2609: END IF;
2610:
2611: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2612: IF g1_debug_mode = 'Y' THEN

Line 2613: PA_DEBUG.g_err_stage := 'RT54 : Entering PA_COST.override_exp_organization';

2609: END IF;
2610:
2611: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2612: IF g1_debug_mode = 'Y' THEN
2613: PA_DEBUG.g_err_stage := 'RT54 : Entering PA_COST.override_exp_organization';
2614: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2615: END IF;
2616:
2617: PA_COST.override_exp_organization(P_item_date => p_asgn_start_date ,

Line 2614: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

2610:
2611: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2612: IF g1_debug_mode = 'Y' THEN
2613: PA_DEBUG.g_err_stage := 'RT54 : Entering PA_COST.override_exp_organization';
2614: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2615: END IF;
2616:
2617: PA_COST.override_exp_organization(P_item_date => p_asgn_start_date ,
2618: P_person_id => p_person_id ,

Line 2629: PA_DEBUG.g_err_stage := 'RT55 : Leaving PA_COST.override_exp_organization';

2625: x_msg_data => x_msg_data
2626: );
2627:
2628: IF g1_debug_mode = 'Y' THEN
2629: PA_DEBUG.g_err_stage := 'RT55 : Leaving PA_COST.override_exp_organization';
2630: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2631: END IF;
2632:
2633: END IF;

Line 2630: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

2626: );
2627:
2628: IF g1_debug_mode = 'Y' THEN
2629: PA_DEBUG.g_err_stage := 'RT55 : Leaving PA_COST.override_exp_organization';
2630: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2631: END IF;
2632:
2633: END IF;
2634:

Line 2637: PA_DEBUG.g_err_stage := 'RT52 : Entering PA_COST.requirement_raw_cost';

2633: END IF;
2634:
2635: ELSIF (p_assignment_type = 'R') THEN
2636: IF g1_debug_mode = 'Y' THEN
2637: PA_DEBUG.g_err_stage := 'RT52 : Entering PA_COST.requirement_raw_cost';
2638: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2639: END IF;
2640: /* Four project functional attributes added for MCB2 */
2641: PA_COST.requirement_raw_cost( p_forecast_cost_job_group_id => l_forecast_job_group_id ,

Line 2638: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

2634:
2635: ELSIF (p_assignment_type = 'R') THEN
2636: IF g1_debug_mode = 'Y' THEN
2637: PA_DEBUG.g_err_stage := 'RT52 : Entering PA_COST.requirement_raw_cost';
2638: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2639: END IF;
2640: /* Four project functional attributes added for MCB2 */
2641: PA_COST.requirement_raw_cost( p_forecast_cost_job_group_id => l_forecast_job_group_id ,
2642: p_forecast_cost_job_id => l_forecast_job_id ,

Line 2734: PA_DEBUG.g_err_stage := 'RT56 : Entering PA_REVENUE.get_rev_amt';

2730:
2731: IF (SUBSTR(l_distribution_rule,1,4) = 'WORK' AND l_class_code = 'CONTRACT') THEN
2732: IF ( p_assignment_type = 'A') THEN
2733: IF g1_debug_mode = 'Y' THEN
2734: PA_DEBUG.g_err_stage := 'RT56 : Entering PA_REVENUE.get_rev_amt';
2735: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2736: END IF;
2737:
2738: PA_REVENUE.Assignment_Rev_Amt(

Line 2735: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

2731: IF (SUBSTR(l_distribution_rule,1,4) = 'WORK' AND l_class_code = 'CONTRACT') THEN
2732: IF ( p_assignment_type = 'A') THEN
2733: IF g1_debug_mode = 'Y' THEN
2734: PA_DEBUG.g_err_stage := 'RT56 : Entering PA_REVENUE.get_rev_amt';
2735: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2736: END IF;
2737:
2738: PA_REVENUE.Assignment_Rev_Amt(
2739: p_project_id => p_project_id ,

Line 2786: PA_DEBUG.g_err_stage := 'RT57 : Leaving PA_REVENUE.get_rev_amt';

2782: );
2783:
2784: -- dbms_output.put_line(' Get Ini rev : '||l_txn_rev_raw_revenue||' curr : '||l_rev_txn_curr_code);
2785: IF g1_debug_mode = 'Y' THEN
2786: PA_DEBUG.g_err_stage := 'RT57 : Leaving PA_REVENUE.get_rev_amt';
2787: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2788: END IF;
2789: /* IF ( x_projfunc_raw_revenue IS NULL OR x_projfunc_raw_revenue = 0 ) THEN
2790: x_projfunc_bill_rate := 0;

Line 2787: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

2783:
2784: -- dbms_output.put_line(' Get Ini rev : '||l_txn_rev_raw_revenue||' curr : '||l_rev_txn_curr_code);
2785: IF g1_debug_mode = 'Y' THEN
2786: PA_DEBUG.g_err_stage := 'RT57 : Leaving PA_REVENUE.get_rev_amt';
2787: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2788: END IF;
2789: /* IF ( x_projfunc_raw_revenue IS NULL OR x_projfunc_raw_revenue = 0 ) THEN
2790: x_projfunc_bill_rate := 0;
2791: x_projfunc_raw_revenue := 0;

Line 2797: PA_DEBUG.g_err_stage := 'RT53 : Leaving PA_COST.requirement_raw_cost';

2793:
2794:
2795: ELSIF (p_assignment_type = 'R') THEN
2796: IF g1_debug_mode = 'Y' THEN
2797: PA_DEBUG.g_err_stage := 'RT53 : Leaving PA_COST.requirement_raw_cost';
2798: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2799: END IF;
2800:
2801: PA_REVENUE.requirement_rev_amt(

Line 2798: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

2794:
2795: ELSIF (p_assignment_type = 'R') THEN
2796: IF g1_debug_mode = 'Y' THEN
2797: PA_DEBUG.g_err_stage := 'RT53 : Leaving PA_COST.requirement_raw_cost';
2798: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2799: END IF;
2800:
2801: PA_REVENUE.requirement_rev_amt(
2802: p_project_id => p_project_id ,

Line 2843: PA_DEBUG.g_err_stage := 'RT55 : Leaving PA_REVENUE.requirement_rev_amt';

2839: x_msg_data => x_msg_data
2840: );
2841:
2842: IF g1_debug_mode = 'Y' THEN
2843: PA_DEBUG.g_err_stage := 'RT55 : Leaving PA_REVENUE.requirement_rev_amt';
2844: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2845: END IF;
2846:
2847: END IF; /* End of assignment_type if */

Line 2844: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

2840: );
2841:
2842: IF g1_debug_mode = 'Y' THEN
2843: PA_DEBUG.g_err_stage := 'RT55 : Leaving PA_REVENUE.requirement_rev_amt';
2844: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2845: END IF;
2846:
2847: END IF; /* End of assignment_type if */
2848:

Line 2897: PA_DEBUG.g_err_stage := 'RT58 : Leaving PA_RATE_PVT_PKG.get_initial_bill_rate';

2893: x_rev_currency_code := l_projfunc_currency_code;
2894: x_markup_percentage := l_markup_percentage; /* Added for Asgmt overide */
2895:
2896: IF g1_debug_mode = 'Y' THEN
2897: PA_DEBUG.g_err_stage := 'RT58 : Leaving PA_RATE_PVT_PKG.get_initial_bill_rate';
2898: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2899: PA_DEBUG.Reset_Curr_Function;
2900: END IF;
2901:

Line 2898: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

2894: x_markup_percentage := l_markup_percentage; /* Added for Asgmt overide */
2895:
2896: IF g1_debug_mode = 'Y' THEN
2897: PA_DEBUG.g_err_stage := 'RT58 : Leaving PA_RATE_PVT_PKG.get_initial_bill_rate';
2898: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2899: PA_DEBUG.Reset_Curr_Function;
2900: END IF;
2901:
2902: EXCEPTION

Line 2899: PA_DEBUG.Reset_Curr_Function;

2895:
2896: IF g1_debug_mode = 'Y' THEN
2897: PA_DEBUG.g_err_stage := 'RT58 : Leaving PA_RATE_PVT_PKG.get_initial_bill_rate';
2898: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2899: PA_DEBUG.Reset_Curr_Function;
2900: END IF;
2901:
2902: EXCEPTION
2903: WHEN l_insufficient_parameters THEN

Line 2905: PA_DEBUG.Reset_Curr_Function;

2901:
2902: EXCEPTION
2903: WHEN l_insufficient_parameters THEN
2904: IF g1_debug_mode = 'Y' THEN
2905: PA_DEBUG.Reset_Curr_Function;
2906: END IF;
2907: x_return_status := FND_API.G_RET_STS_ERROR;
2908: x_msg_count := 1;
2909: x_msg_data := 'PA_FCST_INSUFFICIENT_PARA';

Line 2912: PA_DEBUG.Reset_Curr_Function;

2908: x_msg_count := 1;
2909: x_msg_data := 'PA_FCST_INSUFFICIENT_PARA';
2910: WHEN l_job_not_found THEN
2911: IF g1_debug_mode = 'Y' THEN
2912: PA_DEBUG.Reset_Curr_Function;
2913: END IF;
2914: x_return_status := FND_API.G_RET_STS_ERROR;
2915: x_msg_count := 1;
2916: x_msg_data := 'PA_FCST_NO_JOB_FOUND';

Line 2919: PA_DEBUG.Reset_Curr_Function;

2915: x_msg_count := 1;
2916: x_msg_data := 'PA_FCST_NO_JOB_FOUND';
2917: WHEN OTHERS THEN
2918: IF g1_debug_mode = 'Y' THEN
2919: PA_DEBUG.Reset_Curr_Function;
2920: END IF;
2921:
2922: /* ATG Changes */
2923:

Line 3165: PA_DEBUG.Set_Curr_Function( p_function => 'Calc Rate Amount');

3161:
3162: --dbms_output.put_line(' I am in CALC RATE AMOUNT ');
3163:
3164: IF g1_debug_mode = 'Y' THEN
3165: PA_DEBUG.Set_Curr_Function( p_function => 'Calc Rate Amount');
3166: PA_DEBUG.g_err_stage := 'RT40 : Entering PA_RATE_PVT_PKG.Calc_Rate_Amount';
3167: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3168: END IF;
3169:

Line 3166: PA_DEBUG.g_err_stage := 'RT40 : Entering PA_RATE_PVT_PKG.Calc_Rate_Amount';

3162: --dbms_output.put_line(' I am in CALC RATE AMOUNT ');
3163:
3164: IF g1_debug_mode = 'Y' THEN
3165: PA_DEBUG.Set_Curr_Function( p_function => 'Calc Rate Amount');
3166: PA_DEBUG.g_err_stage := 'RT40 : Entering PA_RATE_PVT_PKG.Calc_Rate_Amount';
3167: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3168: END IF;
3169:
3170: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3167: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

3163:
3164: IF g1_debug_mode = 'Y' THEN
3165: PA_DEBUG.Set_Curr_Function( p_function => 'Calc Rate Amount');
3166: PA_DEBUG.g_err_stage := 'RT40 : Entering PA_RATE_PVT_PKG.Calc_Rate_Amount';
3167: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3168: END IF;
3169:
3170: x_return_status := FND_API.G_RET_STS_SUCCESS;
3171: IF g1_debug_mode = 'Y' THEN

Line 3172: PA_DEBUG.g_err_stage := 'RTS1 : Checking tab count '||TO_CHAR(NVL(p_rate_calc_date_tab.count,0));

3168: END IF;
3169:
3170: x_return_status := FND_API.G_RET_STS_SUCCESS;
3171: IF g1_debug_mode = 'Y' THEN
3172: PA_DEBUG.g_err_stage := 'RTS1 : Checking tab count '||TO_CHAR(NVL(p_rate_calc_date_tab.count,0));
3173: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3174:
3175:
3176: PA_DEBUG.g_err_stage := ' Rate CALC Amt : Inside API project id '||p_project_id||' Item Id '||p_item_id;

Line 3173: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

3169:
3170: x_return_status := FND_API.G_RET_STS_SUCCESS;
3171: IF g1_debug_mode = 'Y' THEN
3172: PA_DEBUG.g_err_stage := 'RTS1 : Checking tab count '||TO_CHAR(NVL(p_rate_calc_date_tab.count,0));
3173: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3174:
3175:
3176: PA_DEBUG.g_err_stage := ' Rate CALC Amt : Inside API project id '||p_project_id||' Item Id '||p_item_id;
3177: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

Line 3176: PA_DEBUG.g_err_stage := ' Rate CALC Amt : Inside API project id '||p_project_id||' Item Id '||p_item_id;

3172: PA_DEBUG.g_err_stage := 'RTS1 : Checking tab count '||TO_CHAR(NVL(p_rate_calc_date_tab.count,0));
3173: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3174:
3175:
3176: PA_DEBUG.g_err_stage := ' Rate CALC Amt : Inside API project id '||p_project_id||' Item Id '||p_item_id;
3177: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3178: END IF;
3179:
3180: IF ((p_rate_calc_date_tab.count) >= 1 ) THEN

Line 3177: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

3173: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3174:
3175:
3176: PA_DEBUG.g_err_stage := ' Rate CALC Amt : Inside API project id '||p_project_id||' Item Id '||p_item_id;
3177: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3178: END IF;
3179:
3180: IF ((p_rate_calc_date_tab.count) >= 1 ) THEN
3181: --dbms_output.put_line(' First : '||p_rate_calc_date_tab.FIRST);

Line 3321: PA_DEBUG.g_err_stage := 'RT41 : Entering PA_RATE_PVT_PKG.get_item_amount';

3317: l_expenditure_orgz_id := p_expenditure_orgz_id_tab(l_J);
3318: l_forecast_item_id := p_forecast_item_id_tab(l_J); /* added for bug 2212852 */
3319:
3320: IF g1_debug_mode = 'Y' THEN
3321: PA_DEBUG.g_err_stage := 'RT41 : Entering PA_RATE_PVT_PKG.get_item_amount';
3322: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3323: PA_DEBUG.g_err_stage := 'prj type: '||p_project_type||' prj id:'||p_project_id;
3324: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3325: END IF;

Line 3322: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

3318: l_forecast_item_id := p_forecast_item_id_tab(l_J); /* added for bug 2212852 */
3319:
3320: IF g1_debug_mode = 'Y' THEN
3321: PA_DEBUG.g_err_stage := 'RT41 : Entering PA_RATE_PVT_PKG.get_item_amount';
3322: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3323: PA_DEBUG.g_err_stage := 'prj type: '||p_project_type||' prj id:'||p_project_id;
3324: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3325: END IF;
3326:

Line 3323: PA_DEBUG.g_err_stage := 'prj type: '||p_project_type||' prj id:'||p_project_id;

3319:
3320: IF g1_debug_mode = 'Y' THEN
3321: PA_DEBUG.g_err_stage := 'RT41 : Entering PA_RATE_PVT_PKG.get_item_amount';
3322: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3323: PA_DEBUG.g_err_stage := 'prj type: '||p_project_type||' prj id:'||p_project_id;
3324: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3325: END IF;
3326:
3327: -- dbms_output.put_line('before calling Get Item AMount the index is : '||l_J);

Line 3324: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

3320: IF g1_debug_mode = 'Y' THEN
3321: PA_DEBUG.g_err_stage := 'RT41 : Entering PA_RATE_PVT_PKG.get_item_amount';
3322: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3323: PA_DEBUG.g_err_stage := 'prj type: '||p_project_type||' prj id:'||p_project_id;
3324: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3325: END IF;
3326:
3327: -- dbms_output.put_line('before calling Get Item AMount the index is : '||l_J);
3328: PA_RATE_PVT_PKG.get_item_amount(

Line 3426: PA_DEBUG.g_err_stage := 'RT42 : Leaving PA_RATE_PVT_PKG.get_item_amount';

3422: x_msg_count => x_msg_count ,
3423: x_msg_data => x_msg_data );
3424:
3425: IF g1_debug_mode = 'Y' THEN
3426: PA_DEBUG.g_err_stage := 'RT42 : Leaving PA_RATE_PVT_PKG.get_item_amount';
3427: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3428: PA_DEBUG.g_err_stage := 'err msg '||substr(l_error_msg,1,300);
3429: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3430: PA_DEBUG.g_err_stage := 'ret sts '||l_return_status||' rrr '||l_rev_rejct_reason||' crr '||l_cost_rejct_reason||' brr '||l_burdened_rejct_reason||' orr '||l_others_rejct_reason;

Line 3427: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

3423: x_msg_data => x_msg_data );
3424:
3425: IF g1_debug_mode = 'Y' THEN
3426: PA_DEBUG.g_err_stage := 'RT42 : Leaving PA_RATE_PVT_PKG.get_item_amount';
3427: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3428: PA_DEBUG.g_err_stage := 'err msg '||substr(l_error_msg,1,300);
3429: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3430: PA_DEBUG.g_err_stage := 'ret sts '||l_return_status||' rrr '||l_rev_rejct_reason||' crr '||l_cost_rejct_reason||' brr '||l_burdened_rejct_reason||' orr '||l_others_rejct_reason;
3431: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

Line 3428: PA_DEBUG.g_err_stage := 'err msg '||substr(l_error_msg,1,300);

3424:
3425: IF g1_debug_mode = 'Y' THEN
3426: PA_DEBUG.g_err_stage := 'RT42 : Leaving PA_RATE_PVT_PKG.get_item_amount';
3427: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3428: PA_DEBUG.g_err_stage := 'err msg '||substr(l_error_msg,1,300);
3429: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3430: PA_DEBUG.g_err_stage := 'ret sts '||l_return_status||' rrr '||l_rev_rejct_reason||' crr '||l_cost_rejct_reason||' brr '||l_burdened_rejct_reason||' orr '||l_others_rejct_reason;
3431: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3432: PA_DEBUG.g_err_stage := 'msg cnt '||x_msg_count||' err msg '||substr(x_msg_data,1,300);

Line 3429: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

3425: IF g1_debug_mode = 'Y' THEN
3426: PA_DEBUG.g_err_stage := 'RT42 : Leaving PA_RATE_PVT_PKG.get_item_amount';
3427: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3428: PA_DEBUG.g_err_stage := 'err msg '||substr(l_error_msg,1,300);
3429: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3430: PA_DEBUG.g_err_stage := 'ret sts '||l_return_status||' rrr '||l_rev_rejct_reason||' crr '||l_cost_rejct_reason||' brr '||l_burdened_rejct_reason||' orr '||l_others_rejct_reason;
3431: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3432: PA_DEBUG.g_err_stage := 'msg cnt '||x_msg_count||' err msg '||substr(x_msg_data,1,300);
3433: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

Line 3430: PA_DEBUG.g_err_stage := 'ret sts '||l_return_status||' rrr '||l_rev_rejct_reason||' crr '||l_cost_rejct_reason||' brr '||l_burdened_rejct_reason||' orr '||l_others_rejct_reason;

3426: PA_DEBUG.g_err_stage := 'RT42 : Leaving PA_RATE_PVT_PKG.get_item_amount';
3427: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3428: PA_DEBUG.g_err_stage := 'err msg '||substr(l_error_msg,1,300);
3429: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3430: PA_DEBUG.g_err_stage := 'ret sts '||l_return_status||' rrr '||l_rev_rejct_reason||' crr '||l_cost_rejct_reason||' brr '||l_burdened_rejct_reason||' orr '||l_others_rejct_reason;
3431: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3432: PA_DEBUG.g_err_stage := 'msg cnt '||x_msg_count||' err msg '||substr(x_msg_data,1,300);
3433: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3434: END IF;

Line 3431: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

3427: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3428: PA_DEBUG.g_err_stage := 'err msg '||substr(l_error_msg,1,300);
3429: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3430: PA_DEBUG.g_err_stage := 'ret sts '||l_return_status||' rrr '||l_rev_rejct_reason||' crr '||l_cost_rejct_reason||' brr '||l_burdened_rejct_reason||' orr '||l_others_rejct_reason;
3431: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3432: PA_DEBUG.g_err_stage := 'msg cnt '||x_msg_count||' err msg '||substr(x_msg_data,1,300);
3433: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3434: END IF;
3435:

Line 3432: PA_DEBUG.g_err_stage := 'msg cnt '||x_msg_count||' err msg '||substr(x_msg_data,1,300);

3428: PA_DEBUG.g_err_stage := 'err msg '||substr(l_error_msg,1,300);
3429: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3430: PA_DEBUG.g_err_stage := 'ret sts '||l_return_status||' rrr '||l_rev_rejct_reason||' crr '||l_cost_rejct_reason||' brr '||l_burdened_rejct_reason||' orr '||l_others_rejct_reason;
3431: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3432: PA_DEBUG.g_err_stage := 'msg cnt '||x_msg_count||' err msg '||substr(x_msg_data,1,300);
3433: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3434: END IF;
3435:
3436: -- dbms_output.put_line(' I am in CALC RATE AMOUNT end of get_item_amount : '||l_J);

Line 3433: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

3429: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3430: PA_DEBUG.g_err_stage := 'ret sts '||l_return_status||' rrr '||l_rev_rejct_reason||' crr '||l_cost_rejct_reason||' brr '||l_burdened_rejct_reason||' orr '||l_others_rejct_reason;
3431: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3432: PA_DEBUG.g_err_stage := 'msg cnt '||x_msg_count||' err msg '||substr(x_msg_data,1,300);
3433: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3434: END IF;
3435:
3436: -- dbms_output.put_line(' I am in CALC RATE AMOUNT end of get_item_amount : '||l_J);
3437: -- dbms_output.put_line(' I am in CALC RATE AMOUNT end of get_item_amount l_cost_rejct_reason : '||l_J||l_cost_rejct_reason);

Line 3541: PA_DEBUG.g_err_stage := 'RT43 : Leaving PA_RATE_PVT_PKG.calc rate amount';

3537:
3538: -- dbms_output.put_line(' I am in CALC RATE AMT ERROR END : ');
3539:
3540: IF g1_debug_mode = 'Y' THEN
3541: PA_DEBUG.g_err_stage := 'RT43 : Leaving PA_RATE_PVT_PKG.calc rate amount';
3542: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3543: PA_DEBUG.Reset_Curr_Function;
3544: END IF;
3545:

Line 3542: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

3538: -- dbms_output.put_line(' I am in CALC RATE AMT ERROR END : ');
3539:
3540: IF g1_debug_mode = 'Y' THEN
3541: PA_DEBUG.g_err_stage := 'RT43 : Leaving PA_RATE_PVT_PKG.calc rate amount';
3542: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3543: PA_DEBUG.Reset_Curr_Function;
3544: END IF;
3545:
3546: EXCEPTION

Line 3543: PA_DEBUG.Reset_Curr_Function;

3539:
3540: IF g1_debug_mode = 'Y' THEN
3541: PA_DEBUG.g_err_stage := 'RT43 : Leaving PA_RATE_PVT_PKG.calc rate amount';
3542: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3543: PA_DEBUG.Reset_Curr_Function;
3544: END IF;
3545:
3546: EXCEPTION
3547: WHEN OTHERS THEN

Line 3549: PA_DEBUG.Reset_Curr_Function;

3545:
3546: EXCEPTION
3547: WHEN OTHERS THEN
3548: IF g1_debug_mode = 'Y' THEN
3549: PA_DEBUG.Reset_Curr_Function;
3550: END IF;
3551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3552: x_error_msg := SUBSTR(SQLERRM,1,30);
3553: /* Checking error condition. Added for bug 2218386 */

Line 3598: PA_DEBUG.Set_Curr_Function( p_function => 'get_rep_period_dates ');

3594:
3595: BEGIN
3596:
3597: IF g1_debug_mode = 'Y' THEN
3598: PA_DEBUG.Set_Curr_Function( p_function => 'get_rep_period_dates ');
3599: PA_DEBUG.g_err_stage := 'RT 101 : Entering PA_RATE_PVT_PKG.get_rep_period_dates';
3600: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3601: END IF;
3602:

Line 3599: PA_DEBUG.g_err_stage := 'RT 101 : Entering PA_RATE_PVT_PKG.get_rep_period_dates';

3595: BEGIN
3596:
3597: IF g1_debug_mode = 'Y' THEN
3598: PA_DEBUG.Set_Curr_Function( p_function => 'get_rep_period_dates ');
3599: PA_DEBUG.g_err_stage := 'RT 101 : Entering PA_RATE_PVT_PKG.get_rep_period_dates';
3600: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3601: END IF;
3602:
3603: x_error_value := 'NO_ERROR';

Line 3600: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

3596:
3597: IF g1_debug_mode = 'Y' THEN
3598: PA_DEBUG.Set_Curr_Function( p_function => 'get_rep_period_dates ');
3599: PA_DEBUG.g_err_stage := 'RT 101 : Entering PA_RATE_PVT_PKG.get_rep_period_dates';
3600: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3601: END IF;
3602:
3603: x_error_value := 'NO_ERROR';
3604:

Line 3608: PA_DEBUG.g_err_stage := 'RT 102 : get_rep_period_dates-> Inside GL select prd typ '||p_period_type;

3604:
3605: IF (p_period_type = 'GL' ) THEN
3606:
3607: IF g1_debug_mode = 'Y' THEN
3608: PA_DEBUG.g_err_stage := 'RT 102 : get_rep_period_dates-> Inside GL select prd typ '||p_period_type;
3609: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3610: END IF;
3611:
3612: SELECT

Line 3609: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

3605: IF (p_period_type = 'GL' ) THEN
3606:
3607: IF g1_debug_mode = 'Y' THEN
3608: PA_DEBUG.g_err_stage := 'RT 102 : get_rep_period_dates-> Inside GL select prd typ '||p_period_type;
3609: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3610: END IF;
3611:
3612: SELECT
3613: glper.period_year,

Line 3647: PA_DEBUG.g_err_stage := 'RT 103 : get_rep_period_dates-> Passed GL select prd nam '||l_period_name;

3643: AND prsts.lookup_type ='CLOSING_STATUS'
3644: AND glpersts.closing_status = prsts.lookup_code);
3645:
3646: IF g1_debug_mode = 'Y' THEN
3647: PA_DEBUG.g_err_stage := 'RT 103 : get_rep_period_dates-> Passed GL select prd nam '||l_period_name;
3648: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3649: END IF;
3650:
3651: ELSIF (p_period_type = 'PA' ) THEN

Line 3648: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

3644: AND glpersts.closing_status = prsts.lookup_code);
3645:
3646: IF g1_debug_mode = 'Y' THEN
3647: PA_DEBUG.g_err_stage := 'RT 103 : get_rep_period_dates-> Passed GL select prd nam '||l_period_name;
3648: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3649: END IF;
3650:
3651: ELSIF (p_period_type = 'PA' ) THEN
3652:

Line 3654: PA_DEBUG.g_err_stage := 'RT 104 : get_rep_period_dates-> Inside PA select prd typ '||p_period_type;

3650:
3651: ELSIF (p_period_type = 'PA' ) THEN
3652:
3653: IF g1_debug_mode = 'Y' THEN
3654: PA_DEBUG.g_err_stage := 'RT 104 : get_rep_period_dates-> Inside PA select prd typ '||p_period_type;
3655: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3656: END IF;
3657:
3658: SELECT

Line 3655: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

3651: ELSIF (p_period_type = 'PA' ) THEN
3652:
3653: IF g1_debug_mode = 'Y' THEN
3654: PA_DEBUG.g_err_stage := 'RT 104 : get_rep_period_dates-> Inside PA select prd typ '||p_period_type;
3655: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3656: END IF;
3657:
3658: SELECT
3659: glp.period_year

Line 3682: PA_DEBUG.g_err_stage := 'RT 104 : get_rep_period_dates-> Passed PA select prd nam '||l_period_name;

3678: WHERE pal.lookup_type = 'CLOSING STATUS'
3679: AND pal.lookup_code = pap.status);
3680:
3681: IF g1_debug_mode = 'Y' THEN
3682: PA_DEBUG.g_err_stage := 'RT 104 : get_rep_period_dates-> Passed PA select prd nam '||l_period_name;
3683: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3684: END IF;
3685:
3686: ELSIF (p_period_type = 'QR' ) THEN

Line 3683: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

3679: AND pal.lookup_code = pap.status);
3680:
3681: IF g1_debug_mode = 'Y' THEN
3682: PA_DEBUG.g_err_stage := 'RT 104 : get_rep_period_dates-> Passed PA select prd nam '||l_period_name;
3683: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3684: END IF;
3685:
3686: ELSIF (p_period_type = 'QR' ) THEN
3687:

Line 3689: PA_DEBUG.g_err_stage := 'RT 105 : get_rep_period_dates-> Inside QR select prd typ '||p_period_type;

3685:
3686: ELSIF (p_period_type = 'QR' ) THEN
3687:
3688: IF g1_debug_mode = 'Y' THEN
3689: PA_DEBUG.g_err_stage := 'RT 105 : get_rep_period_dates-> Inside QR select prd typ '||p_period_type;
3690: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3691: END IF;
3692:
3693: SELECT

Line 3690: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

3686: ELSIF (p_period_type = 'QR' ) THEN
3687:
3688: IF g1_debug_mode = 'Y' THEN
3689: PA_DEBUG.g_err_stage := 'RT 105 : get_rep_period_dates-> Inside QR select prd typ '||p_period_type;
3690: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3691: END IF;
3692:
3693: SELECT
3694: period_yr

Line 3736: PA_DEBUG.g_err_stage := 'RT 106 : get_rep_period_dates-> Passed QR select prd nam '||l_period_name;

3732: )
3733: WHERE p_completion_date BETWEEN start_dt AND end_dt;
3734:
3735: IF g1_debug_mode = 'Y' THEN
3736: PA_DEBUG.g_err_stage := 'RT 106 : get_rep_period_dates-> Passed QR select prd nam '||l_period_name;
3737: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3738: END IF;
3739:
3740: ELSIF (p_period_type = 'YR' ) THEN

Line 3737: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

3733: WHERE p_completion_date BETWEEN start_dt AND end_dt;
3734:
3735: IF g1_debug_mode = 'Y' THEN
3736: PA_DEBUG.g_err_stage := 'RT 106 : get_rep_period_dates-> Passed QR select prd nam '||l_period_name;
3737: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3738: END IF;
3739:
3740: ELSIF (p_period_type = 'YR' ) THEN
3741:

Line 3743: PA_DEBUG.g_err_stage := 'RT 107 : get_rep_period_dates-> Inside YR select prd typ '||p_period_type;

3739:
3740: ELSIF (p_period_type = 'YR' ) THEN
3741:
3742: IF g1_debug_mode = 'Y' THEN
3743: PA_DEBUG.g_err_stage := 'RT 107 : get_rep_period_dates-> Inside YR select prd typ '||p_period_type;
3744: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3745: END IF;
3746:
3747: SELECT

Line 3744: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

3740: ELSIF (p_period_type = 'YR' ) THEN
3741:
3742: IF g1_debug_mode = 'Y' THEN
3743: PA_DEBUG.g_err_stage := 'RT 107 : get_rep_period_dates-> Inside YR select prd typ '||p_period_type;
3744: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3745: END IF;
3746:
3747: SELECT
3748: period_yr

Line 3789: PA_DEBUG.g_err_stage := 'RT 108 : get_rep_period_dates-> Passed YR select prd nam '||l_period_name;

3785: )
3786: WHERE p_completion_date BETWEEN start_dt AND end_dt;
3787:
3788: IF g1_debug_mode = 'Y' THEN
3789: PA_DEBUG.g_err_stage := 'RT 108 : get_rep_period_dates-> Passed YR select prd nam '||l_period_name;
3790: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3791: END IF;
3792:
3793: ELSIF (p_period_type = 'GE' ) THEN

Line 3790: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

3786: WHERE p_completion_date BETWEEN start_dt AND end_dt;
3787:
3788: IF g1_debug_mode = 'Y' THEN
3789: PA_DEBUG.g_err_stage := 'RT 108 : get_rep_period_dates-> Passed YR select prd nam '||l_period_name;
3790: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3791: END IF;
3792:
3793: ELSIF (p_period_type = 'GE' ) THEN
3794:

Line 3796: PA_DEBUG.g_err_stage := 'RT 109 : get_rep_period_dates-> Inside GE select prd typ '||p_period_type;

3792:
3793: ELSIF (p_period_type = 'GE' ) THEN
3794:
3795: IF g1_debug_mode = 'Y' THEN
3796: PA_DEBUG.g_err_stage := 'RT 109 : get_rep_period_dates-> Inside GE select prd typ '||p_period_type;
3797: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3798: END IF;
3799:
3800: SELECT

Line 3797: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

3793: ELSIF (p_period_type = 'GE' ) THEN
3794:
3795: IF g1_debug_mode = 'Y' THEN
3796: PA_DEBUG.g_err_stage := 'RT 109 : get_rep_period_dates-> Inside GE select prd typ '||p_period_type;
3797: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3798: END IF;
3799:
3800: SELECT
3801: period_yr

Line 3826: PA_DEBUG.g_err_stage := 'RT 110 : get_rep_period_dates-> Passed GE select prd nam '||l_period_name;

3822: )
3823: WHERE p_completion_date BETWEEN start_dt AND end_dt;
3824:
3825: IF g1_debug_mode = 'Y' THEN
3826: PA_DEBUG.g_err_stage := 'RT 110 : get_rep_period_dates-> Passed GE select prd nam '||l_period_name;
3827: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3828: END IF;
3829:
3830: END IF;

Line 3827: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

3823: WHERE p_completion_date BETWEEN start_dt AND end_dt;
3824:
3825: IF g1_debug_mode = 'Y' THEN
3826: PA_DEBUG.g_err_stage := 'RT 110 : get_rep_period_dates-> Passed GE select prd nam '||l_period_name;
3827: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3828: END IF;
3829:
3830: END IF;
3831:

Line 3838: PA_DEBUG.g_err_stage := 'RT 111 : Leaving PA_RATE_PVT_PKG.get_rep_period_dates';

3834: x_start_date := l_start_date;
3835: x_end_date := l_end_date;
3836:
3837: IF g1_debug_mode = 'Y' THEN
3838: PA_DEBUG.g_err_stage := 'RT 111 : Leaving PA_RATE_PVT_PKG.get_rep_period_dates';
3839: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3840: PA_DEBUG.Reset_Curr_Function;
3841: END IF;
3842:

Line 3839: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

3835: x_end_date := l_end_date;
3836:
3837: IF g1_debug_mode = 'Y' THEN
3838: PA_DEBUG.g_err_stage := 'RT 111 : Leaving PA_RATE_PVT_PKG.get_rep_period_dates';
3839: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3840: PA_DEBUG.Reset_Curr_Function;
3841: END IF;
3842:
3843: EXCEPTION

Line 3840: PA_DEBUG.Reset_Curr_Function;

3836:
3837: IF g1_debug_mode = 'Y' THEN
3838: PA_DEBUG.g_err_stage := 'RT 111 : Leaving PA_RATE_PVT_PKG.get_rep_period_dates';
3839: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3840: PA_DEBUG.Reset_Curr_Function;
3841: END IF;
3842:
3843: EXCEPTION
3844: WHEN NO_DATA_FOUND THEN

Line 3847: PA_DEBUG.Reset_Curr_Function;

3843: EXCEPTION
3844: WHEN NO_DATA_FOUND THEN
3845: x_error_value := 'NO_DATA_FOUND';
3846: IF g1_debug_mode = 'Y' THEN
3847: PA_DEBUG.Reset_Curr_Function;
3848: END IF;
3849: NULL;
3850: WHEN TOO_MANY_ROWS THEN
3851: x_error_value := 'TOO_MANY_ROWS';

Line 3853: PA_DEBUG.Reset_Curr_Function;

3849: NULL;
3850: WHEN TOO_MANY_ROWS THEN
3851: x_error_value := 'TOO_MANY_ROWS';
3852: IF g1_debug_mode = 'Y' THEN
3853: PA_DEBUG.Reset_Curr_Function;
3854: END IF;
3855: NULL;
3856: WHEN OTHERS THEN
3857: IF g1_debug_mode = 'Y' THEN

Line 3858: PA_DEBUG.Reset_Curr_Function;

3854: END IF;
3855: NULL;
3856: WHEN OTHERS THEN
3857: IF g1_debug_mode = 'Y' THEN
3858: PA_DEBUG.Reset_Curr_Function;
3859: END IF;
3860:
3861: /* ATG Changes */
3862: