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_FORECASTITEM_PVT

Line 1: PACKAGE BODY PA_FORECASTITEM_PVT as

1: PACKAGE BODY PA_FORECASTITEM_PVT as
2: --/* $Header: PARFIGPB.pls 120.14 2007/11/07 15:01:47 rthumma ship $ */
3:
4: -- Procedure level variable declaration
5:

Line 22: pa_debug.write(x_module => 'pa.plsql.pa_forecastitem_pvt',

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,
24: x_log_level => 1);
25: pa_debug.write_file('print_message: ' || 'Log :'||p_msg);
26: END IF;

Line 96: 'PA_FORECASTITEM_PVT.Create_Forecast_Item');

92:
93: TmpErrHdrTab.Delete;
94: lv_return_status := FND_API.G_RET_STS_SUCCESS;
95: PA_DEBUG.Init_err_stack(
96: 'PA_FORECASTITEM_PVT.Create_Forecast_Item');
97:
98:
99: Print_message('1 Calling Get_Assignment_Dtls');
100:

Line 227: 'PA_FORECASTITEM_PVT.Create_Forecast_Item',

223: x_msg_count := 1;
224: x_msg_data := sqlerrm;
225: FND_MSG_PUB.add_exc_msg
226: (p_pkg_name =>
227: 'PA_FORECASTITEM_PVT.Create_Forecast_Item',
228: p_procedure_name => PA_DEBUG.G_Err_Stack);
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
230:
231: If x_msg_count = 1 THEN

Line 290: 'PA_FORECASTITEM_PVT.Create_Forecast_Item');

286:
287: TmpErrTab.Delete;
288:
289: PA_DEBUG.Init_err_stack(
290: 'PA_FORECASTITEM_PVT.Create_Forecast_Item');
291: lv_start_date := p_start_date;
292: lv_end_date := p_end_date;
293:
294: Print_message(

Line 325: 'PA_FORECASTITEM_PVT.Create_Forecast_Item',

321: x_msg_data := sqlerrm;
322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
323: FND_MSG_PUB.add_exc_msg
324: (p_pkg_name =>
325: 'PA_FORECASTITEM_PVT.Create_Forecast_Item',
326: p_procedure_name => PA_DEBUG.G_Err_Stack);
327:
328: If x_msg_count = 1 THEN
329: pa_interface_utils_pub.get_messages

Line 441: 'PA_FORECASTITEM_PVT.Create_Forecast_Item');

437:
438: lv_return_status := FND_API.G_RET_STS_SUCCESS;
439:
440: PA_DEBUG.Init_err_stack(
441: 'PA_FORECASTITEM_PVT.Create_Forecast_Item');
442:
443: -- 2275838: Set process mode correctly.
444: lv_process_mode := p_process_mode;
445: if (p_process_mode = 'GENERATE_ASGMT') then

Line 608: 'PA_FORECASTITEM_PVT.Create_Forecast_Item',

604: x_msg_data := sqlerrm;
605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
606: FND_MSG_PUB.add_exc_msg
607: (p_pkg_name =>
608: 'PA_FORECASTITEM_PVT.Create_Forecast_Item',
609: p_procedure_name => PA_DEBUG.G_Err_Stack);
610: Print_message(x_msg_data);
611:
612: --RAISE;

Line 648: 'PA_FORECASTITEM_PVT.Create_Forecast_Item');

644:
645: lv_return_status := FND_API.G_RET_STS_SUCCESS;
646:
647: PA_DEBUG.Init_err_stack(
648: 'PA_FORECASTITEM_PVT.Create_Forecast_Item');
649:
650: Print_message(
651: 'Calling Resource_Unasg_Error_Process');
652:

Line 675: 'PA_FORECASTITEM_PVT.Create_Forecast_Item',

671: x_msg_data := sqlerrm;
672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
673: FND_MSG_PUB.add_exc_msg
674: (p_pkg_name =>
675: 'PA_FORECASTITEM_PVT.Create_Forecast_Item',
676: p_procedure_name => PA_DEBUG.G_Err_Stack);
677: If x_msg_count = 1 THEN
678: pa_interface_utils_pub.get_messages
679: (p_encoded => FND_API.G_TRUE,

Line 725: 'PA_FORECASTITEM_PVT.Delete_Forecast_Item');

721:
722: lv_return_status := FND_API.G_RET_STS_SUCCESS;
723:
724: PA_DEBUG.Init_err_stack(
725: 'PA_FORECASTITEM_PVT.Delete_Forecast_Item');
726:
727: SELECT count(*) into lv_asg_count
728: FROM pa_project_assignments
729: WHERE assignment_id = p_assignment_id;

Line 793: 'PA_FORECASTITEM_PVT.Delete_Forecast_Item',

789: x_msg_data := sqlerrm;
790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
791: FND_MSG_PUB.add_exc_msg
792: (p_pkg_name =>
793: 'PA_FORECASTITEM_PVT.Delete_Forecast_Item',
794: p_procedure_name => PA_DEBUG.G_Err_Stack);
795:
796: If x_msg_count = 1 THEN
797: pa_interface_utils_pub.get_messages

Line 837: 'PA_FORECASTITEM_PVT.Get_Assignment_Dtls');

833:
834: lv_return_status := FND_API.G_RET_STS_SUCCESS;
835:
836: PA_DEBUG.Init_err_stack(
837: 'PA_FORECASTITEM_PVT.Get_Assignment_Dtls');
838:
839: Print_message(
840: 'Entering Get_Assignment_Dtls: ' || p_assignment_id);
841:

Line 912: 'PA_FORECASTITEM_PVT.Get_Assignment_Dtls',

908: x_msg_data := sqlerrm;
909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
910: FND_MSG_PUB.add_exc_msg
911: (p_pkg_name =>
912: 'PA_FORECASTITEM_PVT.Get_Assignment_Dtls',
913: p_procedure_name => PA_DEBUG.G_Err_Stack);
914:
915: If x_msg_count = 1 THEN
916: pa_interface_utils_pub.get_messages

Line 964: 'PA_FORECASTITEM_PVT.Get_Project_Dtls');

960:
961: lv_return_status := FND_API.G_RET_STS_SUCCESS;
962:
963: PA_DEBUG.Init_err_stack(
964: 'PA_FORECASTITEM_PVT.Get_Project_Dtls');
965:
966: Print_message('Entering Get_Project_Dtls: ' || p_project_id);
967:
968: -- 2196924: Adding case when p_project_id is null

Line 1019: 'PA_FORECASTITEM_PVT.Get_Project_Dtls',

1015: x_project_status_code := NULL ;
1016:
1017: FND_MSG_PUB.add_exc_msg
1018: (p_pkg_name =>
1019: 'PA_FORECASTITEM_PVT.Get_Project_Dtls',
1020: p_procedure_name => PA_DEBUG.G_Err_Stack);
1021: If x_msg_count = 1 THEN
1022: pa_interface_utils_pub.get_messages
1023: (p_encoded => FND_API.G_TRUE,

Line 1108: PA_DEBUG.Init_err_stack( 'PA_FORECASTITEM_PVT.Generate_Requirement_FI');

1104: BEGIN
1105:
1106: lv_return_status := FND_API.G_RET_STS_SUCCESS;
1107:
1108: PA_DEBUG.Init_err_stack( 'PA_FORECASTITEM_PVT.Generate_Requirement_FI');
1109:
1110: TmpDbFIDtlTab.Delete;
1111: TmpDbFIHdrTab.Delete;
1112: TmpFIDtlInsTab.Delete;

Line 1431: 'PA_FORECASTITEM_PVT.Generate_Requirement_FI',

1427: x_msg_data := 'No Schedule Records for Req ';
1428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1429: FND_MSG_PUB.add_exc_msg
1430: (p_pkg_name =>
1431: 'PA_FORECASTITEM_PVT.Generate_Requirement_FI',
1432: p_procedure_name => PA_DEBUG.G_Err_Stack);
1433:
1434: If x_msg_count = 1 THEN
1435: pa_interface_utils_pub.get_messages

Line 1457: 'PA_FORECASTITEM_PVT.Generate_Requirement_FI',

1453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1454:
1455: FND_MSG_PUB.add_exc_msg
1456: (p_pkg_name =>
1457: 'PA_FORECASTITEM_PVT.Generate_Requirement_FI',
1458: p_procedure_name => PA_DEBUG.G_Err_Stack);
1459:
1460: If x_msg_count = 1 THEN
1461: pa_interface_utils_pub.get_messages

Line 1487: 'PA_FORECASTITEM_PVT.Generate_Requirement_FI',

1483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1484:
1485: FND_MSG_PUB.add_exc_msg
1486: (p_pkg_name =>
1487: 'PA_FORECASTITEM_PVT.Generate_Requirement_FI',
1488: p_procedure_name => PA_DEBUG.G_Err_Stack);
1489:
1490: If x_msg_count = 1 THEN
1491: pa_interface_utils_pub.get_messages

Line 1598: 'PA_FORECASTITEM_PVT.Initialize_Day_FI');

1594:
1595: lv_return_status := FND_API.G_RET_STS_SUCCESS;
1596:
1597: PA_DEBUG.Init_err_stack(
1598: 'PA_FORECASTITEM_PVT.Initialize_Day_FI');
1599: TmpFIDayTab.Delete;
1600:
1601: Print_message('Entering Initialize_Day_FI');
1602:

Line 1755: 'PA_FORECASTITEM_PVT.Initialize_Day_FI',

1751: End If;
1752:
1753: FND_MSG_PUB.add_exc_msg
1754: (p_pkg_name =>
1755: 'PA_FORECASTITEM_PVT.Initialize_Day_FI',
1756: p_procedure_name => PA_DEBUG.G_Err_Stack);
1757:
1758: Print_message(x_msg_data);
1759:

Line 1819: PA_DEBUG.Init_err_stack( 'PA_FORECASTITEM_PVT.Build_Day_FI');

1815:
1816: lv_return_status := FND_API.G_RET_STS_SUCCESS;
1817: Print_message('Entering Build_Day_FI');
1818:
1819: PA_DEBUG.Init_err_stack( 'PA_FORECASTITEM_PVT.Build_Day_FI');
1820:
1821: TmpFIDayTab.Delete;
1822: TmpFIDayTab := p_FIDayTab;
1823:

Line 2059: 'PA_FORECASTITEM_PVT.Build_Day_FI',

2055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2056:
2057: FND_MSG_PUB.add_exc_msg
2058: (p_pkg_name =>
2059: 'PA_FORECASTITEM_PVT.Build_Day_FI',
2060: p_procedure_name => PA_DEBUG.G_Err_Stack);
2061:
2062: If x_msg_count = 1 THEN
2063: pa_interface_utils_pub.get_messages

Line 2162: 'PA_FORECASTITEM_PVT.Reverse_FI_Hdr');

2158:
2159: Print_message('Entering Reverse_FI_Hdr');
2160:
2161: PA_DEBUG.Init_err_stack(
2162: 'PA_FORECASTITEM_PVT.Reverse_FI_Hdr');
2163:
2164: forecast_item_id_tab.delete;
2165: forecast_item_type_tab.delete;
2166: project_org_id_tab.delete;

Line 2372: 'PA_FORECASTITEM_PVT.Reverse_FI_Hdr',

2368: x_old_end_date := NULL ;
2369:
2370: FND_MSG_PUB.add_exc_msg
2371: (p_pkg_name =>
2372: 'PA_FORECASTITEM_PVT.Reverse_FI_Hdr',
2373: p_procedure_name => PA_DEBUG.G_Err_Stack);
2374:
2375: If x_msg_count = 1 THEN
2376: pa_interface_utils_pub.get_messages

Line 2470: 'PA_FORECASTITEM_PVT.Reverse_FI_Dtl');

2466:
2467: Print_message('Entering Reverse_FI_Dtl');
2468:
2469: PA_DEBUG.Init_err_stack(
2470: 'PA_FORECASTITEM_PVT.Reverse_FI_Dtl');
2471:
2472: forecast_item_id_tab.delete;
2473: amount_type_id_tab.delete;
2474: line_num_tab.delete;

Line 2820: 'PA_FORECASTITEM_PVT.Reverse_FI_Dtl',

2816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2817:
2818: FND_MSG_PUB.add_exc_msg
2819: (p_pkg_name =>
2820: 'PA_FORECASTITEM_PVT.Reverse_FI_Dtl',
2821: p_procedure_name => PA_DEBUG.G_Err_Stack);
2822:
2823: If x_msg_count = 1 THEN
2824: pa_interface_utils_pub.get_messages

Line 2928: 'PA_FORECASTITEM_PVT.Fetch_FI_Hdr');

2924:
2925: Print_message('Entering Fetch_FI_Hdr');
2926:
2927: PA_DEBUG.Init_err_stack(
2928: 'PA_FORECASTITEM_PVT.Fetch_FI_Hdr');
2929:
2930: TmpHdrTab.delete;
2931: forecast_item_id_tab.delete;
2932: forecast_item_type_tab.delete;

Line 3119: 'PA_FORECASTITEM_PVT.Fetch_FI_Hdr',

3115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3116:
3117: FND_MSG_PUB.add_exc_msg
3118: (p_pkg_name =>
3119: 'PA_FORECASTITEM_PVT.Fetch_FI_Hdr',
3120: p_procedure_name => PA_DEBUG.G_Err_Stack);
3121:
3122: If x_msg_count = 1 THEN
3123: pa_interface_utils_pub.get_messages

Line 3224: 'PA_FORECASTITEM_PVT.Fetch_FI_Dtl');

3220:
3221: Print_message('Entering Fetch_FI_Dtl');
3222:
3223: PA_DEBUG.Init_err_stack(
3224: 'PA_FORECASTITEM_PVT.Fetch_FI_Dtl');
3225:
3226: TmpDtlTab.delete;
3227: forecast_item_id_tab.delete;
3228: amount_type_id_tab.delete;

Line 3424: 'PA_FORECASTITEM_PVT.Fetch_FI_Dtl',

3420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3421:
3422: FND_MSG_PUB.add_exc_msg
3423: (p_pkg_name =>
3424: 'PA_FORECASTITEM_PVT.Fetch_FI_Dtl',
3425: p_procedure_name => PA_DEBUG.G_Err_Stack);
3426:
3427: If x_msg_count = 1 THEN
3428: pa_interface_utils_pub.get_messages

Line 3564: 'PA_FORECASTITEM_PVT.Build_FI_Hdr_Req');

3560:
3561: Print_message('Entering Build_FI_Hdr_Req');
3562:
3563: PA_DEBUG.Init_err_stack(
3564: 'PA_FORECASTITEM_PVT.Build_FI_Hdr_Req');
3565:
3566: TmpDayTab.Delete;
3567: TmpInsTab.Delete;
3568: TmpUpdTab.Delete;

Line 4409: 'PA_FORECASTITEM_PVT.Build_FI_Hdr_Req',

4405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4406:
4407: FND_MSG_PUB.add_exc_msg
4408: (p_pkg_name =>
4409: 'PA_FORECASTITEM_PVT.Build_FI_Hdr_Req',
4410: p_procedure_name => PA_DEBUG.G_Err_Stack);
4411:
4412: If x_msg_count = 1 THEN
4413: pa_interface_utils_pub.get_messages

Line 4436: 'PA_FORECASTITEM_PVT.Build_FI_Hdr_Req',

4432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4433:
4434: FND_MSG_PUB.add_exc_msg
4435: (p_pkg_name =>
4436: 'PA_FORECASTITEM_PVT.Build_FI_Hdr_Req',
4437: p_procedure_name => PA_DEBUG.G_Err_Stack);
4438:
4439: If x_msg_count = 1 THEN
4440: pa_interface_utils_pub.get_messages

Line 4538: 'PA_FORECASTITEM_PVT.Build_FI_Dtl_Req');

4534: BEGIN
4535: lv_return_status := FND_API.G_RET_STS_SUCCESS;
4536:
4537: PA_DEBUG.Init_err_stack(
4538: 'PA_FORECASTITEM_PVT.Build_FI_Dtl_Req');
4539:
4540: Print_message( 'Entering Build_FI_Dtl_Req');
4541:
4542: TmpInsTab.Delete;

Line 5099: 'PA_FORECASTITEM_PVT.Build_FI_Dtl_Req',

5095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5096:
5097: FND_MSG_PUB.add_exc_msg
5098: (p_pkg_name =>
5099: 'PA_FORECASTITEM_PVT.Build_FI_Dtl_Req',
5100: p_procedure_name => PA_DEBUG.G_Err_Stack);
5101:
5102: If x_msg_count = 1 THEN
5103: pa_interface_utils_pub.get_messages

Line 5216: PA_DEBUG.Init_err_stack( 'PA_FORECASTITEM_PVT.Generate_Assignment_FI');

5212: TmpScheduleTab.delete;
5213: TmpFIDayTab.delete;
5214: TmpDumTab.delete;
5215:
5216: PA_DEBUG.Init_err_stack( 'PA_FORECASTITEM_PVT.Generate_Assignment_FI');
5217:
5218: IF p_AsgnDtlRec.resource_id is NOT NULL then
5219: open c_res_dates;
5220: fetch c_res_dates into ld_res_asgn_start_date, ld_res_asgn_end_date;

Line 5666: 'PA_FORECASTITEM_PVT.Generate_Assignment',

5662: x_res_end_date := NULL ;
5663:
5664: FND_MSG_PUB.add_exc_msg
5665: (p_pkg_name =>
5666: 'PA_FORECASTITEM_PVT.Generate_Assignment',
5667: p_procedure_name => PA_DEBUG.G_Err_Stack);
5668:
5669: If x_msg_count = 1 THEN
5670: pa_interface_utils_pub.get_messages

Line 5696: 'PA_FORECASTITEM_PVT.Generate_Assignment',

5692: x_res_end_date := NULL ;
5693:
5694: FND_MSG_PUB.add_exc_msg
5695: (p_pkg_name =>
5696: 'PA_FORECASTITEM_PVT.Generate_Assignment',
5697: p_procedure_name => PA_DEBUG.G_Err_Stack);
5698:
5699: If x_msg_count = 1 THEN
5700: pa_interface_utils_pub.get_messages

Line 5725: 'PA_FORECASTITEM_PVT.Generate_Assignment_FI',

5721: x_res_end_date := NULL ;
5722:
5723: FND_MSG_PUB.add_exc_msg
5724: (p_pkg_name =>
5725: 'PA_FORECASTITEM_PVT.Generate_Assignment_FI',
5726: p_procedure_name => PA_DEBUG.G_Err_Stack);
5727:
5728: If x_msg_count = 1 THEN
5729: pa_interface_utils_pub.get_messages

Line 5762: 'PA_FORECASTITEM_PVT.Generate_Assignment_FI',

5758: x_res_end_date := NULL ;
5759:
5760: FND_MSG_PUB.add_exc_msg
5761: (p_pkg_name =>
5762: 'PA_FORECASTITEM_PVT.Generate_Assignment_FI',
5763: p_procedure_name => PA_DEBUG.G_Err_Stack);
5764:
5765: If x_msg_count = 1 THEN
5766: pa_interface_utils_pub.get_messages

Line 5851: PA_DEBUG.Init_err_stack( 'PA_FORECASTITEM_PVT.Delete_FI');

5847: lv_return_status := FND_API.G_RET_STS_SUCCESS;
5848:
5849: Print_message( 'Entering Delete_FI');
5850:
5851: PA_DEBUG.Init_err_stack( 'PA_FORECASTITEM_PVT.Delete_FI');
5852:
5853: Delete_FI_Dtl( p_assignment_id=>p_assignment_id,
5854: x_return_status=>lv_return_status,
5855: x_msg_count=>x_msg_count,

Line 5885: 'PA_FORECASTITEM_PVT.Delete_FI',

5881: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5882:
5883: FND_MSG_PUB.add_exc_msg
5884: (p_pkg_name =>
5885: 'PA_FORECASTITEM_PVT.Delete_FI',
5886: p_procedure_name => PA_DEBUG.G_Err_Stack);
5887:
5888: If x_msg_count = 1 THEN
5889: pa_interface_utils_pub.get_messages

Line 6023: PA_DEBUG.Init_err_stack( 'PA_FORECASTITEM_PVT.Delete_FI_Hdr');

6019: availability_quantity_tab.delete;
6020: overcommitment_flag_tab.delete;
6021: availability_flag_tab.delete;
6022:
6023: PA_DEBUG.Init_err_stack( 'PA_FORECASTITEM_PVT.Delete_FI_Hdr');
6024:
6025: SELECT forecast_item_id, forecast_item_type,
6026: project_org_id , expenditure_org_id,
6027: project_organization_id, expenditure_organization_id ,

Line 6189: 'PA_FORECASTITEM_PVT.Delete_FI_Hdr',

6185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6186:
6187: FND_MSG_PUB.add_exc_msg
6188: (p_pkg_name =>
6189: 'PA_FORECASTITEM_PVT.Delete_FI_Hdr',
6190: p_procedure_name => PA_DEBUG.G_Err_Stack);
6191:
6192: If x_msg_count = 1 THEN
6193: pa_interface_utils_pub.get_messages

Line 6281: PA_DEBUG.Init_err_stack( 'PA_FORECASTITEM_PVT.Delete_FI_Dtl');

6277: lv_return_status := FND_API.G_RET_STS_SUCCESS;
6278:
6279: Print_message( 'Entering Delete_FI_Dtl');
6280:
6281: PA_DEBUG.Init_err_stack( 'PA_FORECASTITEM_PVT.Delete_FI_Dtl');
6282:
6283: TmpRevTab.Delete;
6284: TmpUpdTab.Delete;
6285: forecast_item_id_tab.delete;

Line 6629: 'PA_FORECASTITEM_PVT.Delete_FI_Dtl',

6625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6626:
6627: FND_MSG_PUB.add_exc_msg
6628: (p_pkg_name =>
6629: 'PA_FORECASTITEM_PVT.Delete_FI_Dtl',
6630: p_procedure_name => PA_DEBUG.G_Err_Stack);
6631:
6632: If x_msg_count = 1 THEN
6633: pa_interface_utils_pub.get_messages

Line 6670: PA_DEBUG.Init_err_stack( 'PA_FORECASTITEM_PVT.Delete_FI');

6666: lv_return_status := FND_API.G_RET_STS_SUCCESS;
6667:
6668: Print_message( 'Entering Delete_FI');
6669:
6670: PA_DEBUG.Init_err_stack( 'PA_FORECASTITEM_PVT.Delete_FI');
6671:
6672: Delete_FI_Dtl(
6673: p_resource_id => p_resource_id,
6674: x_return_status => lv_return_status,

Line 6707: 'PA_FORECASTITEM_PVT.Delete_FI',

6703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6704:
6705: FND_MSG_PUB.add_exc_msg
6706: (p_pkg_name =>
6707: 'PA_FORECASTITEM_PVT.Delete_FI',
6708: p_procedure_name => PA_DEBUG.G_Err_Stack);
6709:
6710: Print_message(x_msg_data);
6711:

Line 6808: PA_DEBUG.Init_err_stack( 'PA_FORECASTITEM_PVT.Delete_FI_Hdr');

6804: delete_flag_tab.delete;
6805: error_flag_tab.delete;
6806: provisional_flag_tab.delete;
6807:
6808: PA_DEBUG.Init_err_stack( 'PA_FORECASTITEM_PVT.Delete_FI_Hdr');
6809:
6810: SELECT forecast_item_id, forecast_item_type,
6811: project_org_id , expenditure_org_id,
6812: project_organization_id, expenditure_organization_id ,

Line 6951: 'PA_FORECASTITEM_PVT.Delete_FI_Hdr',

6947: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6948:
6949: FND_MSG_PUB.add_exc_msg
6950: (p_pkg_name =>
6951: 'PA_FORECASTITEM_PVT.Delete_FI_Hdr',
6952: p_procedure_name => PA_DEBUG.G_Err_Stack);
6953:
6954: Print_message(x_msg_data);
6955:

Line 7033: PA_DEBUG.Init_err_stack( 'PA_FORECASTITEM_PVT.Delete_FI_Dtl');

7029: lv_return_status := FND_API.G_RET_STS_SUCCESS;
7030:
7031: Print_message( 'Entering Delete_FI_Dtl');
7032:
7033: PA_DEBUG.Init_err_stack( 'PA_FORECASTITEM_PVT.Delete_FI_Dtl');
7034:
7035: TmpRevTab.Delete;
7036: TmpUpdTab.Delete;
7037: forecast_item_id_tab.delete;

Line 7390: 'PA_FORECASTITEM_PVT.Delete_FI_Dtl',

7386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7387:
7388: FND_MSG_PUB.add_exc_msg
7389: (p_pkg_name =>
7390: 'PA_FORECASTITEM_PVT.Delete_FI_Dtl',
7391: p_procedure_name => PA_DEBUG.G_Err_Stack);
7392:
7393: Print_message(x_msg_data);
7394:

Line 7560: 'PA_FORECASTITEM_PVT.Build_FI_Hdr_Asg');

7556:
7557: Print_message('Entering Build_FI_Hdr_Asg: ' || p_AsgnDtlRec.resource_id || ' ' || p_AsgnDtlRec.assignment_id);
7558:
7559: PA_DEBUG.Init_err_stack(
7560: 'PA_FORECASTITEM_PVT.Build_FI_Hdr_Asg');
7561:
7562: TmpDayTab.Delete;
7563: TmpInsTab.Delete;
7564: TmpUpdTab.Delete;

Line 8643: 'PA_FORECASTITEM_PVT.Build_FI_Hdr_Asg',

8639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8640:
8641: FND_MSG_PUB.add_exc_msg
8642: (p_pkg_name =>
8643: 'PA_FORECASTITEM_PVT.Build_FI_Hdr_Asg',
8644: p_procedure_name => PA_DEBUG.G_Err_Stack);
8645:
8646: If x_msg_count = 1 THEN
8647: pa_interface_utils_pub.get_messages

Line 8668: 'PA_FORECASTITEM_PVT.Build_FI_Hdr_Asg',

8664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8665:
8666: FND_MSG_PUB.add_exc_msg
8667: (p_pkg_name =>
8668: 'PA_FORECASTITEM_PVT.Build_FI_Hdr_Asg',
8669: p_procedure_name => PA_DEBUG.G_Err_Stack);
8670:
8671: If x_msg_count = 1 THEN
8672: pa_interface_utils_pub.get_messages

Line 8694: 'PA_FORECASTITEM_PVT.Build_FI_Hdr_Asg',

8690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8691:
8692: FND_MSG_PUB.add_exc_msg
8693: (p_pkg_name =>
8694: 'PA_FORECASTITEM_PVT.Build_FI_Hdr_Asg',
8695: p_procedure_name => PA_DEBUG.G_Err_Stack);
8696:
8697: If x_msg_count = 1 THEN
8698: pa_interface_utils_pub.get_messages

Line 8725: 'PA_FORECASTITEM_PVT.Build_FI_Hdr_Asg',

8721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8722:
8723: FND_MSG_PUB.add_exc_msg
8724: (p_pkg_name =>
8725: 'PA_FORECASTITEM_PVT.Build_FI_Hdr_Asg',
8726: p_procedure_name => PA_DEBUG.G_Err_Stack);
8727:
8728: If x_msg_count = 1 THEN
8729: pa_interface_utils_pub.get_messages

Line 8834: 'PA_FORECASTITEM_PVT.Build_FI_Dtl_Asg');

8830:
8831: lv_return_status := FND_API.G_RET_STS_SUCCESS;
8832:
8833: PA_DEBUG.Init_err_stack(
8834: 'PA_FORECASTITEM_PVT.Build_FI_Dtl_Asg');
8835:
8836: TmpDayTab.Delete;
8837: TmpInsTab.Delete;
8838: TmpUpdTab.Delete;

Line 9434: 'PA_FORECASTITEM_PVT.Build_FI_Dtl_Asg',

9430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9431:
9432: FND_MSG_PUB.add_exc_msg
9433: (p_pkg_name =>
9434: 'PA_FORECASTITEM_PVT.Build_FI_Dtl_Asg',
9435: p_procedure_name => PA_DEBUG.G_Err_Stack);
9436:
9437: If x_msg_count = 1 THEN
9438: pa_interface_utils_pub.get_messages

Line 9617: 'PA_FORECASTITEM_PVT.Regenerate_Res_Unassigned_FI');

9613: IF (PA_INSTALL.is_prm_licensed = 'Y' OR
9614: PA_INSTALL.is_utilization_implemented = 'Y') THEN
9615:
9616: PA_DEBUG.Init_err_stack(
9617: 'PA_FORECASTITEM_PVT.Regenerate_Res_Unassigned_FI');
9618:
9619: /* 2196924: Don't need this logic, because fis should be created wven when resource
9620: records are missing.
9621: open c_res_dates;

Line 10420: 'PA_FORECASTITEM_PVT.Regenerate_Res_Unassigned_FI',

10416: p_end_date := NULL ;
10417:
10418: FND_MSG_PUB.add_exc_msg
10419: (p_pkg_name =>
10420: 'PA_FORECASTITEM_PVT.Regenerate_Res_Unassigned_FI',
10421: p_procedure_name => PA_DEBUG.G_Err_Stack);
10422:
10423: If x_msg_count = 1 THEN
10424: pa_interface_utils_pub.get_messages

Line 10449: 'PA_FORECASTITEM_PVT.Regenerate_Res_Unassigned_FI',

10445: p_end_date := NULL ;
10446:
10447: FND_MSG_PUB.add_exc_msg
10448: (p_pkg_name =>
10449: 'PA_FORECASTITEM_PVT.Regenerate_Res_Unassigned_FI',
10450: p_procedure_name => PA_DEBUG.G_Err_Stack);
10451:
10452: If x_msg_count = 1 THEN
10453: pa_interface_utils_pub.get_messages

Line 10486: 'PA_FORECASTITEM_PVT.Regenerate_Res_Unassigned_FI',

10482: p_end_date := NULL ;
10483:
10484: FND_MSG_PUB.add_exc_msg
10485: (p_pkg_name =>
10486: 'PA_FORECASTITEM_PVT.Regenerate_Res_Unassigned_FI',
10487: p_procedure_name => PA_DEBUG.G_Err_Stack);
10488:
10489: If x_msg_count = 1 THEN
10490: pa_interface_utils_pub.get_messages

Line 10529: 'PA_FORECASTITEM_PVT.Regenerate_Res_Unassigned_FI',

10525: x_msg_data := l_data ; -- 4537865
10526: End If;
10527: FND_MSG_PUB.add_exc_msg
10528: (p_pkg_name =>
10529: 'PA_FORECASTITEM_PVT.Regenerate_Res_Unassigned_FI',
10530: p_procedure_name => PA_DEBUG.G_Err_Stack);
10531:
10532: RAISE;
10533:

Line 10618: PA_DEBUG.Init_err_stack( 'PA_FORECASTITEM_PVT.Fetch_FI_Hdr_Res');

10614: lv_return_status := FND_API.G_RET_STS_SUCCESS;
10615:
10616: Print_message('Entering Fetch_FI_Hdr_Res');
10617:
10618: PA_DEBUG.Init_err_stack( 'PA_FORECASTITEM_PVT.Fetch_FI_Hdr_Res');
10619:
10620: TmpHdrTab.delete;
10621: forecast_item_id_tab.delete;
10622: forecast_item_type_tab.delete;

Line 10815: 'PA_FORECASTITEM_PVT.Fetch_FI_Hdr_Res',

10811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10812:
10813: FND_MSG_PUB.add_exc_msg
10814: (p_pkg_name =>
10815: 'PA_FORECASTITEM_PVT.Fetch_FI_Hdr_Res',
10816: p_procedure_name => PA_DEBUG.G_Err_Stack);
10817:
10818: If x_msg_count = 1 THEN
10819: pa_interface_utils_pub.get_messages

Line 10918: 'PA_FORECASTITEM_PVT.Fetch_FI_Dtl_Res');

10914:
10915: Print_message('Entering Fetch_FI_Dtl_Res');
10916:
10917: PA_DEBUG.Init_err_stack(
10918: 'PA_FORECASTITEM_PVT.Fetch_FI_Dtl_Res');
10919:
10920: TmpDtlTab.delete;
10921: forecast_item_id_tab.delete;
10922: amount_type_id_tab.delete;

Line 11132: 'PA_FORECASTITEM_PVT.Fetch_FI_Dtl_Res',

11128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11129:
11130: FND_MSG_PUB.add_exc_msg
11131: (p_pkg_name =>
11132: 'PA_FORECASTITEM_PVT.Fetch_FI_Dtl_Res',
11133: p_procedure_name => PA_DEBUG.G_Err_Stack);
11134:
11135: If x_msg_count = 1 THEN
11136: pa_interface_utils_pub.get_messages

Line 11317: 'PA_FORECASTITEM_PVT.Build_FI_Hdr_Res');

11313:
11314: Print_message('Entering Build_FI_Hdr_Res');
11315:
11316: PA_DEBUG.Init_err_stack(
11317: 'PA_FORECASTITEM_PVT.Build_FI_Hdr_Res');
11318:
11319: TmpDayTab.Delete;
11320: TmpInsTab.Delete;
11321: TmpUpdTab.Delete;

Line 12521: 'PA_FORECASTITEM_PVT.Build_FI_Hdr_Res',

12517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12518:
12519: FND_MSG_PUB.add_exc_msg
12520: (p_pkg_name =>
12521: 'PA_FORECASTITEM_PVT.Build_FI_Hdr_Res',
12522: p_procedure_name => PA_DEBUG.G_Err_Stack);
12523:
12524: If x_msg_count = 1 THEN
12525: pa_interface_utils_pub.get_messages

Line 12546: 'PA_FORECASTITEM_PVT.Build_FI_Hdr_Res',

12542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12543:
12544: FND_MSG_PUB.add_exc_msg
12545: (p_pkg_name =>
12546: 'PA_FORECASTITEM_PVT.Build_FI_Hdr_Res',
12547: p_procedure_name => PA_DEBUG.G_Err_Stack);
12548:
12549: If x_msg_count = 1 THEN
12550: pa_interface_utils_pub.get_messages

Line 12572: 'PA_FORECASTITEM_PVT.Build_FI_Hdr_Res',

12568: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12569:
12570: FND_MSG_PUB.add_exc_msg
12571: (p_pkg_name =>
12572: 'PA_FORECASTITEM_PVT.Build_FI_Hdr_Res',
12573: p_procedure_name => PA_DEBUG.G_Err_Stack);
12574:
12575: If x_msg_count = 1 THEN
12576: pa_interface_utils_pub.get_messages

Line 12602: 'PA_FORECASTITEM_PVT.Build_FI_Hdr_Res',

12598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12599:
12600: FND_MSG_PUB.add_exc_msg
12601: (p_pkg_name =>
12602: 'PA_FORECASTITEM_PVT.Build_FI_Hdr_Res',
12603: p_procedure_name => PA_DEBUG.G_Err_Stack);
12604:
12605: If x_msg_count = 1 THEN
12606: pa_interface_utils_pub.get_messages

Line 12714: 'PA_FORECASTITEM_PVT.Build_FI_Dtl_Res');

12710:
12711: Print_message('Entering Build_FI_Dtl_Res');
12712:
12713: PA_DEBUG.Init_err_stack(
12714: 'PA_FORECASTITEM_PVT.Build_FI_Dtl_Res');
12715:
12716: TmpDayTab.Delete;
12717: TmpInsTab.Delete;
12718: TmpUpdTab.Delete;

Line 12798: Print_message('PA_FORECASTITEM_PVT.Build_FI_Dtl_Res : TmpDayTab(i).work_type_id not same as the previous value, get from the database');

12794: -- Added IF condition for Bug 5552078
12795: -- 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
12796: -- IF (nvl(TmpDayTab(i).work_type_id, -99) <> nvl(l_worktype_cache, -99)) THEN
12797: IF (nvl(TmpDayTab(i).work_type_id, -199) <> nvl(l_worktype_cache, -199)) THEN --Bug 6202828 Changed the nvl value from -99 to -199
12798: Print_message('PA_FORECASTITEM_PVT.Build_FI_Dtl_Res : TmpDayTab(i).work_type_id not same as the previous value, get from the database');
12799: PA_FORECAST_ITEMS_UTILS.get_work_type_details(
12800: TmpDayTab(i).work_type_id,
12801: lv_billable_flag,
12802: l_resutilweighted,

Line 13328: 'PA_FORECASTITEM_PVT.Build_FI_Dtl_Res',

13324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13325:
13326: FND_MSG_PUB.add_exc_msg
13327: (p_pkg_name =>
13328: 'PA_FORECASTITEM_PVT.Build_FI_Dtl_Res',
13329: p_procedure_name => PA_DEBUG.G_Err_Stack);
13330:
13331: If x_msg_count = 1 THEN
13332: pa_interface_utils_pub.get_messages

Line 13390: 'PA_FORECASTITEM_PVT.Resource_Unasg_Error_Process');

13386: Print_message(
13387: 'Entering Resource_Unasg_Error_Process');
13388:
13389: PA_DEBUG.Init_err_stack(
13390: 'PA_FORECASTITEM_PVT.Resource_Unasg_Error_Process');
13391:
13392: lv_prev_resource_id := p_ErrHdrTab(p_ErrHdrTab.FIRST).resource_id;
13393: lv_next_date := p_ErrHdrTab(p_ErrHdrTab.FIRST).item_date ;
13394: lv_start_date := p_ErrHdrTab(p_ErrHdrTab.FIRST).item_date ;

Line 13478: 'PA_FORECASTITEM_PVT.Resource_Unasg_Error_Process',

13474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13475:
13476: FND_MSG_PUB.add_exc_msg
13477: (p_pkg_name =>
13478: 'PA_FORECASTITEM_PVT.Resource_Unasg_Error_Process',
13479: p_procedure_name => PA_DEBUG.G_Err_Stack);
13480:
13481: If x_msg_count = 1 THEN
13482: pa_interface_utils_pub.get_messages

Line 13587: PA_DEBUG.Init_err_stack( 'PA_FORECASTITEM_PVT.FI_Error_Process');

13583: lv_return_status := FND_API.G_RET_STS_SUCCESS;
13584:
13585: Print_message ( 'Entering FI_Error_Process');
13586:
13587: PA_DEBUG.Init_err_stack( 'PA_FORECASTITEM_PVT.FI_Error_Process');
13588:
13589: forecast_item_id_tab.delete;
13590: forecast_item_type_tab.delete;
13591: project_org_id_tab.delete;

Line 13896: 'PA_FORECASTITEM_PVT.FI_Error_Process',

13892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13893:
13894: FND_MSG_PUB.add_exc_msg
13895: (p_pkg_name =>
13896: 'PA_FORECASTITEM_PVT.FI_Error_Process',
13897: p_procedure_name => PA_DEBUG.G_Err_Stack);
13898:
13899: If x_msg_count = 1 THEN
13900: pa_interface_utils_pub.get_messages

Line 14072: 'PA_FORECASTITEM_PVT.Regenrate_Asgn_Req');

14068:
14069: Print_message('Entering Regenrate_Asgn_Req');
14070:
14071: PA_DEBUG.Init_err_stack(
14072: 'PA_FORECASTITEM_PVT.Regenrate_Asgn_Req');
14073:
14074: OPEN asgmt_dtls;
14075:
14076: LOOP

Line 14134: PA_FORECASTITEM_PVT.Create_Forecast_Item(

14130:
14131: Print_message(
14132: 'Calling forecast item Regenrate_Asgn_Req');
14133:
14134: PA_FORECASTITEM_PVT.Create_Forecast_Item(
14135: p_assignment_id => l_AssignmentIdTab(i),
14136: p_start_date => l_StartDateTab(i) ,
14137: p_end_date => l_EndDateTab(i) ,
14138: p_process_mode => l_processModeTab(i) ,

Line 14161: 'PA_FORECASTITEM_PVT.Regenrate_Asgn_Req',

14157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14158:
14159: FND_MSG_PUB.add_exc_msg
14160: (p_pkg_name =>
14161: 'PA_FORECASTITEM_PVT.Regenrate_Asgn_Req',
14162: p_procedure_name => PA_DEBUG.G_Err_Stack);
14163:
14164: If x_msg_count = 1 THEN
14165: pa_interface_utils_pub.get_messages

Line 14206: (p_pkg_name => 'PA_FORECASTITEM_PVT.Regenrate_Asgn_Req',

14202: x_msg_count := 1;
14203: x_msg_data := SQLERRM;
14204:
14205: FND_MSG_PUB.add_exc_msg
14206: (p_pkg_name => 'PA_FORECASTITEM_PVT.Regenrate_Asgn_Req',
14207: p_procedure_name => PA_DEBUG.G_Err_Stack);
14208:
14209: If x_msg_count = 1 THEN
14210: pa_interface_utils_pub.get_messages

Line 14446: PA_DEBUG.Init_err_stack( 'PA_FORECASTITEM_PVT.Regenrate_Unassigned');

14442: lv_return_status := FND_API.G_RET_STS_SUCCESS;
14443:
14444: -- l_process_mode := p_process_mode;
14445:
14446: PA_DEBUG.Init_err_stack( 'PA_FORECASTITEM_PVT.Regenrate_Unassigned');
14447:
14448: l_process_mode := 'ERROR';
14449:
14450: Print_message( 'Entering Regenrate_Unassigned');

Line 14578: PA_FORECASTITEM_PVT.create_forecast_item(

14574: -- Call the Forecast Generation API.
14575: Print_message(
14576: 'calling create forecast_item from unasg');
14577:
14578: PA_FORECASTITEM_PVT.create_forecast_item(
14579: p_ErrHdrTab => l_forecast_item_hdr_tab,
14580: p_process_mode => l_process_mode,
14581: x_return_status => l_x_return_status,
14582: x_msg_count => l_x_msg_count,

Line 14657: 'PA_FORECASTITEM_PVT.Regenrate_Unassigned',

14653: x_msg_data := SQLERRM;
14654:
14655: FND_MSG_PUB.add_exc_msg
14656: (p_pkg_name =>
14657: 'PA_FORECASTITEM_PVT.Regenrate_Unassigned',
14658: p_procedure_name => PA_DEBUG.G_Err_Stack);
14659:
14660: If x_msg_count = 1 THEN
14661: pa_interface_utils_pub.get_messages

Line 14724: 'PA_FORECASTITEM_PVT.Regenrate_orgz_forecast');

14720:
14721: Print_message( 'Entering regenrate_orgz_forecast');
14722:
14723: PA_DEBUG.Init_err_stack(
14724: 'PA_FORECASTITEM_PVT.Regenrate_orgz_forecast');
14725:
14726: Regenrate_Asgn_Req(p_orgz_id => l_orgz_id,
14727: p_start_date => l_start_date,
14728: p_end_date => l_end_date,

Line 14764: 'PA_FORECASTITEM_PVT.regenrate_orgz_forecast',

14760: x_msg_data := SQLERRM;
14761:
14762: FND_MSG_PUB.add_exc_msg
14763: (p_pkg_name =>
14764: 'PA_FORECASTITEM_PVT.regenrate_orgz_forecast',
14765: p_procedure_name => PA_DEBUG.G_Err_Stack);
14766:
14767: If x_msg_count = 1 THEN
14768: pa_interface_utils_pub.get_messages

Line 14869: PA_FORECASTITEM_PVT.print_message('NO_DATA_FOUND ok, exception not raised');

14865: ORDER BY rou.resource_effective_start_date;
14866:
14867: EXCEPTION
14868: WHEN NO_DATA_FOUND THEN
14869: PA_FORECASTITEM_PVT.print_message('NO_DATA_FOUND ok, exception not raised');
14870: END;
14871:
14872: if (l_StartDateTab.count = 0) then
14873: x_Start_Date := TO_DATE('01/01/1950','MM/DD/YYYY');

Line 14931: (p_pkg_name => 'PA_FORECASTITEM_PVT.Check_Person_Billable',

14927: x_End_date := NULL ;
14928: x_billable_flag := NULL ;
14929:
14930: FND_MSG_PUB.add_exc_msg
14931: (p_pkg_name => 'PA_FORECASTITEM_PVT.Check_Person_Billable',
14932: p_procedure_name => PA_DEBUG.G_Err_Stack);
14933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14934:
14935: If x_msg_count = 1 THEN

Line 15000: PA_FORECASTITEM_PVT.print_message('NO_DATA_FOUND ok, exception not raised');

14996: ORDER BY rou.resource_effective_start_date;
14997:
14998: EXCEPTION
14999: WHEN NO_DATA_FOUND THEN
15000: PA_FORECASTITEM_PVT.print_message('NO_DATA_FOUND ok, exception not raised');
15001: END;
15002:
15003: if (l_StartDateTab.count = 0) then
15004: x_Start_Date := TO_DATE('01/01/1950','MM/DD/YYYY');

Line 15056: (p_pkg_name => 'PA_FORECASTITEM_PVT.Is_Include_Utilisation',

15052: WHEN OTHERS THEN
15053: x_msg_count := 1;
15054: x_msg_data := sqlerrm;
15055: FND_MSG_PUB.add_exc_msg
15056: (p_pkg_name => 'PA_FORECASTITEM_PVT.Is_Include_Utilisation',
15057: p_procedure_name => PA_DEBUG.G_Err_Stack);
15058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15059:
15060: -- 4537865

Line 15250: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_FORECASTITEM_PVT',

15246: WHEN OTHERS THEN
15247: x_msg_count := 1;
15248: x_msg_data := sqlerrm;
15249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15250: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_FORECASTITEM_PVT',
15251: p_procedure_name => 'Copy_Requirement_FI');
15252: If x_msg_count = 1 THEN
15253: pa_interface_utils_pub.get_messages
15254: (p_encoded => FND_API.G_TRUE,