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_FORECASTITEM_PVT dependencies on PA_FORECAST_ITEMS_UTILS

Line 19: --PA_FORECAST_ITEMS_UTILS.log_message(p_msg);

15: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
16:
17: PROCEDURE print_message(p_msg IN varchar2) IS
18: BEGIN
19: --PA_FORECAST_ITEMS_UTILS.log_message(p_msg);
20: if (p_msg is not null) then
21: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
22: pa_debug.write(x_module => 'pa.plsql.pa_forecastitem_pvt',
23: x_msg => p_msg,

Line 456: lv_resource_id := PA_FORECAST_ITEMS_UTILS.get_resource_id(

452:
453: print_message('lv_start_date: ' || lv_start_date);
454: print_message('lv_end_date: ' || lv_end_date);
455:
456: lv_resource_id := PA_FORECAST_ITEMS_UTILS.get_resource_id(
457: p_person_id);
458:
459: OPEN asgmt_dtls(lv_resource_id);
460:

Line 1194: PA_FORECAST_ITEMS_UTILS.Get_assignment_Schedule(

1190:
1191: -- Get schedule data AND build day fI Records
1192: Print_message( 'Req - Calling Get_Assignment_Schedule');
1193:
1194: PA_FORECAST_ITEMS_UTILS.Get_assignment_Schedule(
1195: p_AsgnDtlRec.assignment_id,
1196: lv_start_date, lv_end_date,p_process_mode,
1197: Tmpscheduletab,
1198: lv_return_status, x_msg_count, x_msg_data);

Line 3589: PA_FORECAST_ITEMS_UTILS.get_period_set_name

3585: Print_message(
3586: 'Req - Get_period_set_name (pvdr) ');
3587:
3588: lv_pvdr_period_set_name :=
3589: PA_FORECAST_ITEMS_UTILS.get_period_set_name
3590: (p_AsgnDtlRec.expenditure_org_id);
3591:
3592: if lv_pvdr_period_set_name = 'NO_DATA_FOUND' THEN
3593:

Line 3621: PA_FORECAST_ITEMS_UTILS.get_period_set_name (

3617: 'Req - Get_period_set_name (rcvr) ');
3618:
3619: Print_message('lv_project_org_id: ' || lv_project_org_id);
3620: lv_rcvr_period_set_name :=
3621: PA_FORECAST_ITEMS_UTILS.get_period_set_name (
3622: lv_project_org_id);
3623:
3624: if lv_rcvr_period_set_name = 'NO_DATA_FOUND' THEN
3625:

Line 3642: PA_FORECAST_ITEMS_UTILS.get_pa_period_name(

3638:
3639: Print_message(
3640: 'Req - Get_pa_period_name (pvdr) ');
3641:
3642: PA_FORECAST_ITEMS_UTILS.get_pa_period_name(
3643: p_AsgnDtlRec.expenditure_org_id,
3644: p_AsgnDtlRec.start_date,
3645: p_AsgnDtlRec.end_date,
3646: ld_pvdrpa_startdate_tab,

Line 3654: PA_FORECAST_ITEMS_UTILS.get_gl_period_name(

3650:
3651: Print_message(
3652: 'Req - Get_gl_period_name (pvdr) ');
3653:
3654: PA_FORECAST_ITEMS_UTILS.get_gl_period_name(
3655: p_AsgnDtlRec.expenditure_org_id,
3656: p_AsgnDtlRec.start_date,
3657: p_AsgnDtlRec.end_date,
3658: ld_pvdrgl_startdate_tab,

Line 3666: PA_FORECAST_ITEMS_UTILS.get_pa_period_name(

3662:
3663: Print_message(
3664: 'Req - Get_pa_period_name (rcvr) ');
3665: Print_message('lv_project_org_id: ' || lv_project_org_id);
3666: PA_FORECAST_ITEMS_UTILS.get_pa_period_name(
3667: lv_project_org_id,
3668: p_AsgnDtlRec.start_date,
3669: p_AsgnDtlRec.end_date,
3670: ld_rcvrpa_startdate_tab,

Line 3678: PA_FORECAST_ITEMS_UTILS.get_gl_period_name(

3674:
3675: Print_message(
3676: 'Req - Get_gl_period_name (rcvr) ');
3677: Print_message('lv_project_org_id: ' || lv_project_org_id);
3678: PA_FORECAST_ITEMS_UTILS.get_gl_period_name(
3679: lv_project_org_id,
3680: p_AsgnDtlRec.start_date,
3681: p_AsgnDtlRec.end_date,
3682: ld_rcvrgl_startdate_tab,

Line 3691: PA_FORECAST_ITEMS_UTILS.get_Week_Dates_Range_Fc(

3687:
3688: Print_message(
3689: 'Req - Get_week_dates_range_fc ');
3690:
3691: PA_FORECAST_ITEMS_UTILS.get_Week_Dates_Range_Fc(
3692: p_AsgnDtlRec.start_date,
3693: p_AsgnDtlRec.end_date,
3694: lv_WeekDateRange_Tab,
3695: x_return_status,

Line 3959: PA_FORECAST_ITEMS_UTILS.get_next_forecast_item_id;

3955: lv_call_pos := 'Req : in if data create';
3956: IF TmpDayTab(i).action_flag <> 'E' THEN
3957:
3958: lv_forecast_item_id :=
3959: PA_FORECAST_ITEMS_UTILS.get_next_forecast_item_id;
3960:
3961: TmpDayTab(i).forecast_item_id := lv_forecast_item_id;
3962:
3963: ELSE

Line 4550: PA_FORECAST_ITEMS_UTILS.get_work_type_details(

4546:
4547: Print_message(
4548: 'Req - Get_work_type_details');
4549:
4550: PA_FORECAST_ITEMS_UTILS.get_work_type_details(
4551: p_AsgnDtlRec.work_type_id,
4552: lv_billable_flag,
4553: l_resutilweighted,
4554: l_orgutilweighted,

Line 5249: IF (PA_FORECAST_ITEMS_UTILS.Set_User_Lock(

5245: -- print_message('Assignment is outside of HR assignment');
5246: -- raise l_no_fis_to_create;
5247: --end if;
5248:
5249: IF (PA_FORECAST_ITEMS_UTILS.Set_User_Lock(
5250: p_AsgnDtlRec.resource_id, 'RES') <> 0) THEN
5251: RAISE l_cannot_acquire_lock;
5252:
5253: END IF;

Line 5393: PA_FORECAST_ITEMS_UTILS.Get_assignment_Schedule(

5389:
5390: Print_message(
5391: 'Asg - Calling Get_Assignment_Schedule');
5392:
5393: PA_FORECAST_ITEMS_UTILS.Get_assignment_Schedule(
5394: p_AsgnDtlRec.assignment_id,
5395: lv_start_date,
5396: lv_end_date,
5397: p_process_mode,

Line 5639: li_lock_status := PA_FORECAST_ITEMS_UTILS.Release_User_lock(p_AsgnDtlRec.resource_id, 'RES');

5635:
5636: PA_DEBUG.Reset_Err_Stack;
5637:
5638: /** Release the lock once process is completed **/
5639: li_lock_status := PA_FORECAST_ITEMS_UTILS.Release_User_lock(p_AsgnDtlRec.resource_id, 'RES');
5640: Print_message('Resource lock released');
5641:
5642: x_return_status := lv_return_status;
5643:

Line 5745: li_lock_status := PA_FORECAST_ITEMS_UTILS.Release_User_lock(p_AsgnDtlRec.resource_id, 'RES');

5741:
5742:
5743: END IF;
5744: /** lock must be released once process completes or errors out **/
5745: li_lock_status := PA_FORECAST_ITEMS_UTILS.Release_User_lock(p_AsgnDtlRec.resource_id, 'RES');
5746: Print_message('Resource lock released ');
5747:
5748: WHEN OTHERS THEN
5749: print_message('Failed in Generate_Assignemnt api');

Line 5778: li_lock_status := PA_FORECAST_ITEMS_UTILS.Release_User_lock(p_AsgnDtlRec.resource_id, 'RES');

5774: End If;
5775: Print_message(x_msg_data);
5776:
5777: /** lock must be released once process completes or errors out **/
5778: li_lock_status := PA_FORECAST_ITEMS_UTILS.Release_User_lock(p_AsgnDtlRec.resource_id, 'RES');
5779: Print_message('Resource lock released ');
5780:
5781: RAISE;
5782:

Line 7591: PA_FORECAST_ITEMS_UTILS.get_resource_ou(

7587:
7588:
7589: Print_message( 'Asg - Get_resource_ou');
7590:
7591: PA_FORECAST_ITEMS_UTILS.get_resource_ou(
7592: p_AsgnDtlRec.resource_id,
7593: p_AsgnDtlRec.start_date,
7594: p_AsgnDtlRec.end_date,
7595: ld_resou_startdate_tab,ld_resou_enddate_tab,

Line 7614: lv_person_id := PA_FORECAST_ITEMS_UTILS.get_person_id(

7610:
7611:
7612: Print_message( 'Asg - Get_person_id');
7613:
7614: lv_person_id := PA_FORECAST_ITEMS_UTILS.get_person_id(
7615: p_AsgnDtlRec.resource_id);
7616:
7617: Print_message('Asg - Get_res_org_and_job');
7618:

Line 7619: PA_FORECAST_ITEMS_UTILS.get_res_org_and_job(

7615: p_AsgnDtlRec.resource_id);
7616:
7617: Print_message('Asg - Get_res_org_and_job');
7618:
7619: PA_FORECAST_ITEMS_UTILS.get_res_org_and_job(
7620: lv_person_id, p_AsgnDtlRec.start_date,
7621: p_AsgnDtlRec.end_date,
7622: ld_orgn_startdate_tab, ld_orgn_enddate_tab,
7623: l_orgn_tab, l_jobid_tab);

Line 7655: PA_FORECAST_ITEMS_UTILS.get_period_set_name (

7651:
7652: Print_message('Asg - Get_period_set_name (rcvr)');
7653: Print_message('lv_project_org_id: ' || lv_project_org_id);
7654: lv_rcvr_period_set_name :=
7655: PA_FORECAST_ITEMS_UTILS.get_period_set_name (
7656: lv_project_org_id);
7657:
7658: if lv_rcvr_period_set_name = 'NO_DATA_FOUND' THEN
7659:

Line 7671: PA_FORECAST_ITEMS_UTILS.get_pa_period_name(

7667: Print_message(
7668: 'Asg - Get_pa_period_name (rcvr)');
7669:
7670: Print_message('lv_project_org_id: ' || lv_project_org_id);
7671: PA_FORECAST_ITEMS_UTILS.get_pa_period_name(
7672: lv_project_org_id,
7673: p_AsgnDtlRec.start_date,
7674: p_AsgnDtlRec.end_date,
7675: ld_rcvrpa_startdate_tab,

Line 7686: PA_FORECAST_ITEMS_UTILS.get_gl_period_name(

7682: Print_message(
7683: 'Asg - Get_gl_period_name (rcvr)');
7684:
7685: Print_message('lv_project_org_id: ' || lv_project_org_id);
7686: PA_FORECAST_ITEMS_UTILS.get_gl_period_name(
7687: lv_project_org_id,
7688: p_AsgnDtlRec.start_date,
7689: p_AsgnDtlRec.end_date,
7690: ld_rcvrgl_startdate_tab,

Line 7699: PA_FORECAST_ITEMS_UTILS.get_Week_Dates_Range_Fc(

7695:
7696: Print_message(
7697: 'Asg - Get_week_dates_range_fc ');
7698:
7699: PA_FORECAST_ITEMS_UTILS.get_Week_Dates_Range_Fc(
7700: p_AsgnDtlRec.start_date,
7701: p_AsgnDtlRec.end_date,
7702: lv_WeekDateRange_Tab,
7703: x_return_status,

Line 7839: PA_FORECAST_ITEMS_UTILS.get_period_set_name(

7835: Print_message(
7836: 'Asg - Get_period_set_name (pvdr) ');
7837:
7838: lv_pvdr_period_set_name :=
7839: PA_FORECAST_ITEMS_UTILS.get_period_set_name(
7840: lv_resou);
7841:
7842: if lv_pvdr_period_set_name = 'NO_DATA_FOUND' THEN
7843: lv_pvdr_period_set_name := '-99';

Line 7857: PA_FORECAST_ITEMS_UTILS.get_pa_period_name(

7853:
7854: Print_message(
7855: 'Asg - Get_pa_period_name (pvdr)');
7856:
7857: PA_FORECAST_ITEMS_UTILS.get_pa_period_name(
7858: lv_resou,
7859: p_AsgnDtlRec.start_date,
7860: p_AsgnDtlRec.end_date,
7861: ld_pvdrpa_startdate_tab,

Line 7870: PA_FORECAST_ITEMS_UTILS.get_gl_period_name(

7866:
7867: Print_message(
7868: 'Asg - Get_gl_period_name (pvdr)');
7869:
7870: PA_FORECAST_ITEMS_UTILS.get_gl_period_name(
7871: lv_resou,
7872: p_AsgnDtlRec.start_date,
7873: p_AsgnDtlRec.end_date,
7874: ld_pvdrgl_startdate_tab,

Line 7885: PA_FORECAST_ITEMS_UTILS.get_forecastoptions(

7881: Print_message(
7882: 'Asg - Get_forecastoptions');
7883:
7884: -- dbms_output.put_line(l_resou_tab(lv_res_index));
7885: PA_FORECAST_ITEMS_UTILS.get_forecastoptions(
7886: lv_resou,
7887: -- lv_include_admin_proj_flag, Bug 4576715
7888: lv_util_cal_method,
7889: lv_bill_unasg_proj_id,

Line 8195: PA_FORECAST_ITEMS_UTILS.get_next_forecast_item_id;

8191: lv_call_pos := 'Asg : in if data create ';
8192: IF TmpDayTab(i).action_flag <> 'E' THEN
8193:
8194: lv_forecast_item_id :=
8195: PA_FORECAST_ITEMS_UTILS.get_next_forecast_item_id;
8196:
8197: TmpDayTab(i).forecast_item_id := lv_forecast_item_id;
8198:
8199: ELSE

Line 8848: lv_resource_type := PA_FORECAST_ITEMS_UTILS.get_resource_type(

8844:
8845:
8846: Print_message( 'Asg - Get_resource_type');
8847:
8848: lv_resource_type := PA_FORECAST_ITEMS_UTILS.get_resource_type(
8849: p_AsgnDtlRec.resource_id);
8850:
8851: lv_amount_type_id := get_AmountTypeID;
8852:

Line 8853: lv_person_id := PA_FORECAST_ITEMS_UTILS.get_person_id(

8849: p_AsgnDtlRec.resource_id);
8850:
8851: lv_amount_type_id := get_AmountTypeID;
8852:
8853: lv_person_id := PA_FORECAST_ITEMS_UTILS.get_person_id(
8854: p_AsgnDtlRec.resource_id);
8855:
8856: Print_message('Asg - Get_work_type_details');
8857: PA_FORECAST_ITEMS_UTILS.get_work_type_details(

Line 8857: PA_FORECAST_ITEMS_UTILS.get_work_type_details(

8853: lv_person_id := PA_FORECAST_ITEMS_UTILS.get_person_id(
8854: p_AsgnDtlRec.resource_id);
8855:
8856: Print_message('Asg - Get_work_type_details');
8857: PA_FORECAST_ITEMS_UTILS.get_work_type_details(
8858: p_AsgnDtlRec.work_type_id,
8859: lv_billable_flag,
8860: l_resutilweighted,
8861: l_orgutilweighted,

Line 9685: IF (PA_FORECAST_ITEMS_UTILS.Set_User_Lock(

9681:
9682: Print_message(
9683: 'Entering Regenerate_Res_Unassigned_FI');
9684:
9685: IF (PA_FORECAST_ITEMS_UTILS.Set_User_Lock(
9686: p_resource_id, 'RES') <> 0) THEN
9687: RAISE l_cannot_acquire_lock;
9688:
9689: END IF;

Line 9912: li_lock_status := PA_FORECAST_ITEMS_UTILS.Release_User_lock(p_resource_id, 'RES');

9908: END IF;
9909:
9910: If TmpScheduleTab.count = 0 then
9911: /** if the schedule tab is zero then release the lock and return **/
9912: li_lock_status := PA_FORECAST_ITEMS_UTILS.Release_User_lock(p_resource_id, 'RES');
9913: Print_message('Resource lock released ');
9914: Return;
9915: End if;
9916:

Line 9984: PA_FORECAST_ITEMS_UTILS.Get_Resource_Asgn_Schedules (

9980: IF lv_return_status = FND_API.G_RET_STS_SUCCESS THEN
9981:
9982: Print_message( 'Calling Get_Resource_Asgn_Schedule');
9983:
9984: PA_FORECAST_ITEMS_UTILS.Get_Resource_Asgn_Schedules (
9985: p_resource_id,
9986: p_start_date,
9987: p_end_date ,
9988: TmpAsgnScheduleTab,

Line 10381: li_lock_status := PA_FORECAST_ITEMS_UTILS.Release_User_lock(p_resource_id, 'RES');

10377: ------------------END AVAILABILITY SUMMARY TABLE POPULATION-----------------
10378: ----------------------------------------------------------------------------
10379:
10380: /** once the process is completed release the lock **/
10381: li_lock_status := PA_FORECAST_ITEMS_UTILS.Release_User_lock(p_resource_id, 'RES');
10382: Print_message('Resource lock released ');
10383:
10384: END IF;
10385:

Line 10400: li_lock_status := PA_FORECAST_ITEMS_UTILS.Release_User_lock(p_resource_id, 'RES');

10396: -- There are no FIs to create.
10397: PA_DEBUG.Reset_Err_Stack;
10398: x_return_status := lv_return_status;
10399: -- release the lock
10400: li_lock_status := PA_FORECAST_ITEMS_UTILS.Release_User_lock(p_resource_id, 'RES');
10401: Print_message('Resource lock released ');
10402:
10403: WHEN NO_DATA_FOUND THEN
10404:

Line 10468: li_lock_status := PA_FORECAST_ITEMS_UTILS.Release_User_lock(p_resource_id, 'RES');

10464: RAISE;
10465:
10466: END IF;
10467: /** lock should be released if the process fails **/
10468: li_lock_status := PA_FORECAST_ITEMS_UTILS.Release_User_lock(p_resource_id, 'RES');
10469: Print_message('Resouce lock released ');
10470:
10471: WHEN l_cannot_acquire_lock THEN
10472:

Line 10510: li_lock_status := PA_FORECAST_ITEMS_UTILS.Release_User_lock(p_resource_id, 'RES');

10506: x_msg_count := 1;
10507: x_msg_data := sqlerrm;
10508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10509: /** release the lock if the process fails **/
10510: li_lock_status := PA_FORECAST_ITEMS_UTILS.Release_User_lock(p_resource_id, 'RES');
10511: Print_message('Resource lock released ');
10512:
10513: -- 4537865
10514: p_start_date := NULL ;

Line 11352: PA_FORECAST_ITEMS_UTILS.get_resource_ou(

11348:
11349: Print_message(
11350: 'Res - Get_resource_ou ');
11351:
11352: PA_FORECAST_ITEMS_UTILS.get_resource_ou(
11353: p_resource_id,p_start_date, p_end_date,
11354: ld_resou_startdate_tab,ld_resou_enddate_tab,
11355: l_resou_tab);
11356:

Line 11374: PA_FORECAST_ITEMS_UTILS.get_person_id(p_resource_id);

11370:
11371: Print_message( 'Res - Get_Person_id ');
11372:
11373: lv_person_id :=
11374: PA_FORECAST_ITEMS_UTILS.get_person_id(p_resource_id);
11375:
11376:
11377: Print_message(
11378: 'Res - Get_res_org_and_job ');

Line 11380: PA_FORECAST_ITEMS_UTILS.get_res_org_and_job(

11376:
11377: Print_message(
11378: 'Res - Get_res_org_and_job ');
11379:
11380: PA_FORECAST_ITEMS_UTILS.get_res_org_and_job(
11381: lv_person_id, p_start_date, p_end_date,
11382: ld_orgn_startdate_tab, ld_orgn_enddate_tab,
11383: l_orgn_tab, l_jobid_tab);
11384:

Line 11401: PA_FORECAST_ITEMS_UTILS.get_Week_Dates_Range_Fc(

11397:
11398: Print_message(
11399: 'Res - Get_week_dates_range_fc ');
11400:
11401: PA_FORECAST_ITEMS_UTILS.get_Week_Dates_Range_Fc(
11402: p_start_date,
11403: p_end_date,
11404: lv_WeekDateRange_Tab,
11405: lv_return_status,

Line 11514: PA_FORECAST_ITEMS_UTILS.get_period_set_name(

11510: Print_message(
11511: 'Res - Get_period_set_name (pvdr) ');
11512:
11513: lv_pvdr_period_set_name :=
11514: PA_FORECAST_ITEMS_UTILS.get_period_set_name(
11515: lv_resou);
11516:
11517: if lv_pvdr_period_set_name = 'NO_DATA_FOUND' THEN
11518:

Line 11534: PA_FORECAST_ITEMS_UTILS.get_pa_period_name(

11530:
11531: Print_message(
11532: 'Res - Get_pa_period_name (pvdr) ');
11533:
11534: PA_FORECAST_ITEMS_UTILS.get_pa_period_name(
11535: lv_resou,p_start_date,
11536: p_end_date,
11537: ld_pvdrpa_startdate_tab,
11538: ld_pvdrpa_enddate_tab,

Line 11553: PA_FORECAST_ITEMS_UTILS.get_gl_period_name(

11549:
11550: Print_message(
11551: 'Res - Get_gl_period_name (pvdr) ');
11552:
11553: PA_FORECAST_ITEMS_UTILS.get_gl_period_name(
11554: lv_resou,p_start_date,
11555: p_end_date,
11556: ld_pvdrgl_startdate_tab,
11557: ld_pvdrgl_enddate_tab,

Line 11572: PA_FORECAST_ITEMS_UTILS.get_forecastoptions(

11568:
11569: Print_message(
11570: 'Res - Get_forecastoptions ');
11571:
11572: PA_FORECAST_ITEMS_UTILS.get_forecastoptions(
11573: lv_resou,
11574: -- lv_include_admin_proj_flag, Bug 4576715
11575: lv_util_cal_method,
11576: lv_bill_unasg_proj_id,

Line 11647: PA_FORECAST_ITEMS_UTILS.get_period_set_name (

11643: 'Res - Get_Period_set_name (rcvr) ');
11644:
11645: Print_message('lv_project_org_id: ' || lv_project_org_id);
11646: lv_rcvr_period_set_name :=
11647: PA_FORECAST_ITEMS_UTILS.get_period_set_name (
11648: lv_project_org_id);
11649:
11650: if lv_rcvr_period_set_name = 'NO_DATA_FOUND' THEN
11651:

Line 11662: PA_FORECAST_ITEMS_UTILS.get_pa_period_name(

11658: Print_message(
11659: 'Res - Get_PA_Period_name (rcvr) ');
11660:
11661: Print_message('lv_project_org_id: ' || lv_project_org_id);
11662: PA_FORECAST_ITEMS_UTILS.get_pa_period_name(
11663: lv_project_org_id,
11664: p_start_date,
11665: p_end_date,
11666: ld_rcvrpa_startdate_tab,

Line 11683: PA_FORECAST_ITEMS_UTILS.get_gl_period_name(

11679: Print_message(
11680: 'Res - Get_gl_Period_name (rcvr) ');
11681:
11682: Print_message('lv_project_org_id: ' || lv_project_org_id);
11683: PA_FORECAST_ITEMS_UTILS.get_gl_period_name(
11684: lv_project_org_id,
11685: p_start_date,
11686: p_end_date,
11687: ld_rcvrgl_startdate_tab,

Line 12055: PA_FORECAST_ITEMS_UTILS.get_next_forecast_item_id;

12051: --print_message('JM: 115');
12052: IF TmpDayTab(i).action_flag <> 'E' THEN
12053:
12054: lv_forecast_item_id :=
12055: PA_FORECAST_ITEMS_UTILS.get_next_forecast_item_id;
12056:
12057: TmpDayTab(i).forecast_item_id := lv_forecast_item_id;
12058:
12059: ELSE

Line 12730: lv_resource_type := PA_FORECAST_ITEMS_UTILS.get_resource_type(

12726:
12727: Print_message(
12728: 'Res - Get_resource_type');
12729:
12730: lv_resource_type := PA_FORECAST_ITEMS_UTILS.get_resource_type(
12731: p_resource_id);
12732:
12733: lv_amount_type_id := get_AmountTypeID;
12734:

Line 12735: lv_person_id := PA_FORECAST_ITEMS_UTILS.get_person_id(

12731: p_resource_id);
12732:
12733: lv_amount_type_id := get_AmountTypeID;
12734:
12735: lv_person_id := PA_FORECAST_ITEMS_UTILS.get_person_id(
12736: p_resource_id);
12737:
12738:
12739: if (TmpDayTab.count <> 0) then

Line 12802: PA_FORECAST_ITEMS_UTILS.get_work_type_details(

12798: -- If the work_type_id is same as the previous loop iteration then no need to fetch it from the database. NVL check added since work_type_id may be passed as null
12799: -- IF (nvl(TmpDayTab(i).work_type_id, -99) <> nvl(l_worktype_cache, -99)) THEN
12800: IF (nvl(TmpDayTab(i).work_type_id, -199) <> nvl(l_worktype_cache, -199)) THEN --Bug 6202828 Changed the nvl value from -99 to -199
12801: Print_message('PA_FORECASTITEM_PVT.Build_FI_Dtl_Res : TmpDayTab(i).work_type_id not same as the previous value, get from the database');
12802: PA_FORECAST_ITEMS_UTILS.get_work_type_details(
12803: TmpDayTab(i).work_type_id,
12804: lv_billable_flag,
12805: l_resutilweighted,
12806: l_orgutilweighted,

Line 14177: IF (PA_FORECAST_ITEMS_UTILS.Set_User_Lock

14173: -- should be in sink if the same time same assignment id
14174: -- is going to be used for processing
14175: lv_lock_type := 'ASGMT';
14176:
14177: IF (PA_FORECAST_ITEMS_UTILS.Set_User_Lock
14178: (l_AssignmentIdTab(i), 'ASG') <> 0) THEN
14179:
14180: RAISE l_cannot_acquire_lock;
14181:

Line 14198: l_lock_status := PA_FORECAST_ITEMS_UTILS.Release_User_Lock

14194: x_return_status => l_x_return_status,
14195: x_msg_count => l_x_msg_count,
14196: x_msg_data => l_x_msg_data );
14197:
14198: l_lock_status := PA_FORECAST_ITEMS_UTILS.Release_User_Lock
14199: (l_AssignmentIdTab(i), 'ASG');
14200: -- This commit is safe: called from a report.
14201: commit;
14202:

Line 15000: PA_FORECAST_ITEMS_UTILS.log_message(x_msg_data);

14996: p_data => l_data, -- 4537865
14997: p_msg_index_out => l_msg_index_out );
14998: x_msg_data := l_data ; -- 4537865
14999: End If;
15000: PA_FORECAST_ITEMS_UTILS.log_message(x_msg_data);
15001: raise;
15002: END Check_Person_Billable;
15003:
15004: /* ---------------------------------------------------------------------

Line 15130: PA_FORECAST_ITEMS_UTILS.log_message(x_msg_data);

15126: p_data => l_data , -- 4537865
15127: p_msg_index_out => l_msg_index_out );
15128: x_msg_data := l_data ; -- 4537865
15129: End If;
15130: PA_FORECAST_ITEMS_UTILS.log_message(x_msg_data);
15131: raise;
15132:
15133:
15134: END Is_Include_Utilisation;