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.18 2010/10/16 08:28:27 nisinha 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 11318: 'PA_FORECASTITEM_PVT.Build_FI_Hdr_Res');

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

Line 12524: 'PA_FORECASTITEM_PVT.Build_FI_Hdr_Res',

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

Line 12549: 'PA_FORECASTITEM_PVT.Build_FI_Hdr_Res',

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

Line 12575: 'PA_FORECASTITEM_PVT.Build_FI_Hdr_Res',

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

Line 12605: 'PA_FORECASTITEM_PVT.Build_FI_Hdr_Res',

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

Line 12717: 'PA_FORECASTITEM_PVT.Build_FI_Dtl_Res');

12713:
12714: Print_message('Entering Build_FI_Dtl_Res');
12715:
12716: PA_DEBUG.Init_err_stack(
12717: 'PA_FORECASTITEM_PVT.Build_FI_Dtl_Res');
12718:
12719: TmpDayTab.Delete;
12720: TmpInsTab.Delete;
12721: TmpUpdTab.Delete;

Line 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');

12797: -- Added IF condition for Bug 5552078
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,

Line 13331: 'PA_FORECASTITEM_PVT.Build_FI_Dtl_Res',

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

Line 13393: 'PA_FORECASTITEM_PVT.Resource_Unasg_Error_Process');

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

Line 13481: 'PA_FORECASTITEM_PVT.Resource_Unasg_Error_Process',

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

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

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

Line 13899: 'PA_FORECASTITEM_PVT.FI_Error_Process',

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

Line 14127: 'PA_FORECASTITEM_PVT.Regenrate_Asgn_Req');

14123:
14124: Print_message('Entering Regenrate_Asgn_Req');
14125:
14126: PA_DEBUG.Init_err_stack(
14127: 'PA_FORECASTITEM_PVT.Regenrate_Asgn_Req');
14128:
14129: OPEN asgmt_dtls;
14130:
14131: LOOP

Line 14189: PA_FORECASTITEM_PVT.Create_Forecast_Item(

14185:
14186: Print_message(
14187: 'Calling forecast item Regenrate_Asgn_Req');
14188:
14189: PA_FORECASTITEM_PVT.Create_Forecast_Item(
14190: p_assignment_id => l_AssignmentIdTab(i),
14191: p_start_date => l_StartDateTab(i) ,
14192: p_end_date => l_EndDateTab(i) ,
14193: p_process_mode => l_processModeTab(i) ,

Line 14216: 'PA_FORECASTITEM_PVT.Regenrate_Asgn_Req',

14212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14213:
14214: FND_MSG_PUB.add_exc_msg
14215: (p_pkg_name =>
14216: 'PA_FORECASTITEM_PVT.Regenrate_Asgn_Req',
14217: p_procedure_name => PA_DEBUG.G_Err_Stack);
14218:
14219: If x_msg_count = 1 THEN
14220: pa_interface_utils_pub.get_messages

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

14257: x_msg_count := 1;
14258: x_msg_data := SQLERRM;
14259:
14260: FND_MSG_PUB.add_exc_msg
14261: (p_pkg_name => 'PA_FORECASTITEM_PVT.Regenrate_Asgn_Req',
14262: p_procedure_name => PA_DEBUG.G_Err_Stack);
14263:
14264: If x_msg_count = 1 THEN
14265: pa_interface_utils_pub.get_messages

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

14497: lv_return_status := FND_API.G_RET_STS_SUCCESS;
14498:
14499: -- l_process_mode := p_process_mode;
14500:
14501: PA_DEBUG.Init_err_stack( 'PA_FORECASTITEM_PVT.Regenrate_Unassigned');
14502:
14503: l_process_mode := 'ERROR';
14504:
14505: Print_message( 'Entering Regenrate_Unassigned');

Line 14633: PA_FORECASTITEM_PVT.create_forecast_item(

14629: -- Call the Forecast Generation API.
14630: Print_message(
14631: 'calling create forecast_item from unasg');
14632:
14633: PA_FORECASTITEM_PVT.create_forecast_item(
14634: p_ErrHdrTab => l_forecast_item_hdr_tab,
14635: p_process_mode => l_process_mode,
14636: x_return_status => l_x_return_status,
14637: x_msg_count => l_x_msg_count,

Line 14712: 'PA_FORECASTITEM_PVT.Regenrate_Unassigned',

14708: x_msg_data := SQLERRM;
14709:
14710: FND_MSG_PUB.add_exc_msg
14711: (p_pkg_name =>
14712: 'PA_FORECASTITEM_PVT.Regenrate_Unassigned',
14713: p_procedure_name => PA_DEBUG.G_Err_Stack);
14714:
14715: If x_msg_count = 1 THEN
14716: pa_interface_utils_pub.get_messages

Line 14779: 'PA_FORECASTITEM_PVT.Regenrate_orgz_forecast');

14775:
14776: Print_message( 'Entering regenrate_orgz_forecast');
14777:
14778: PA_DEBUG.Init_err_stack(
14779: 'PA_FORECASTITEM_PVT.Regenrate_orgz_forecast');
14780:
14781: Regenrate_Asgn_Req(p_orgz_id => l_orgz_id,
14782: p_start_date => l_start_date,
14783: p_end_date => l_end_date,

Line 14819: 'PA_FORECASTITEM_PVT.regenrate_orgz_forecast',

14815: x_msg_data := SQLERRM;
14816:
14817: FND_MSG_PUB.add_exc_msg
14818: (p_pkg_name =>
14819: 'PA_FORECASTITEM_PVT.regenrate_orgz_forecast',
14820: p_procedure_name => PA_DEBUG.G_Err_Stack);
14821:
14822: If x_msg_count = 1 THEN
14823: pa_interface_utils_pub.get_messages

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

14920: ORDER BY rou.resource_effective_start_date;
14921:
14922: EXCEPTION
14923: WHEN NO_DATA_FOUND THEN
14924: PA_FORECASTITEM_PVT.print_message('NO_DATA_FOUND ok, exception not raised');
14925: END;
14926:
14927: if (l_StartDateTab.count = 0) then
14928: x_Start_Date := TO_DATE('01/01/1950','MM/DD/YYYY');

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

14982: x_End_date := NULL ;
14983: x_billable_flag := NULL ;
14984:
14985: FND_MSG_PUB.add_exc_msg
14986: (p_pkg_name => 'PA_FORECASTITEM_PVT.Check_Person_Billable',
14987: p_procedure_name => PA_DEBUG.G_Err_Stack);
14988: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14989:
14990: If x_msg_count = 1 THEN

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

15051: ORDER BY rou.resource_effective_start_date;
15052:
15053: EXCEPTION
15054: WHEN NO_DATA_FOUND THEN
15055: PA_FORECASTITEM_PVT.print_message('NO_DATA_FOUND ok, exception not raised');
15056: END;
15057:
15058: if (l_StartDateTab.count = 0) then
15059: x_Start_Date := TO_DATE('01/01/1950','MM/DD/YYYY');

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

15107: WHEN OTHERS THEN
15108: x_msg_count := 1;
15109: x_msg_data := sqlerrm;
15110: FND_MSG_PUB.add_exc_msg
15111: (p_pkg_name => 'PA_FORECASTITEM_PVT.Is_Include_Utilisation',
15112: p_procedure_name => PA_DEBUG.G_Err_Stack);
15113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15114:
15115: -- 4537865

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

15301: WHEN OTHERS THEN
15302: x_msg_count := 1;
15303: x_msg_data := sqlerrm;
15304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15305: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_FORECASTITEM_PVT',
15306: p_procedure_name => 'Copy_Requirement_FI');
15307: If x_msg_count = 1 THEN
15308: pa_interface_utils_pub.get_messages
15309: (p_encoded => FND_API.G_TRUE,