221: print_message('SQLCODE'||sqlcode||sqlerrm);
222:
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;
319:
320: x_msg_count := 1;
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:
602:
603: x_msg_count := 1;
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);
669:
670: x_msg_count := 1;
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
787:
788: x_msg_count := 1;
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:
906:
907: x_msg_count := 1;
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:
1013: x_work_type_id := NULL ;
1014: x_project_type_class := NULL ;
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
1425:
1426: x_msg_count := 1;
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:
1451: x_msg_count := 1;
1452: x_msg_data := sqlerrm;
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:
1481: x_msg_count := 1;
1482: x_msg_data := sqlerrm;
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:
1749: p_msg_index_out => l_msg_index_out );
1750: x_msg_data := l_data ; -- 4537865
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:
2053: x_msg_count := 1;
2054: x_msg_data := sqlerrm;
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:
2366: -- 4537865
2367: x_old_start_date := NULL ;
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:
2814: x_msg_count := 1;
2815: x_msg_data := sqlerrm;
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:
3113: x_msg_count := 1;
3114: x_msg_data := sqlerrm;
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:
3418: x_msg_count := 1;
3419: x_msg_data := sqlerrm;
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:
4403: x_msg_count := 1;
4404: x_msg_data := sqlerrm ;
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:
4430: x_msg_count := 1;
4431: x_msg_data := sqlerrm;
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:
5093: x_msg_count := 1;
5094: x_msg_data := sqlerrm;
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:
5660: -- 4537865
5661: x_res_start_date := NULL ;
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:
5690: -- 4537865
5691: x_res_start_date := NULL ;
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:
5719: -- 4537865
5720: x_res_start_date := NULL ;
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:
5756: -- 4537865
5757: x_res_start_date := NULL ;
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:
5879: x_msg_count := 1;
5880: x_msg_data := sqlerrm;
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:
6183: x_msg_count := 1;
6184: x_msg_data := sqlerrm;
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:
6623: x_msg_count := 1;
6624: x_msg_data := sqlerrm;
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:
6701: x_msg_count := 1;
6702: x_msg_data := sqlerrm;
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:
6945: x_msg_count := 1;
6946: x_msg_data := sqlerrm;
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:
7384: x_msg_count := 1;
7385: x_msg_data := sqlerrm;
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:
8637: x_msg_count := 1;
8638: x_msg_data := 'ResOU not found';
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:
8662: x_msg_count := 1;
8663: x_msg_data := 'ResOrgn not found';
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:
8688: x_msg_count := 1;
8689: x_msg_data := sqlerrm ;
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:
8719: x_msg_count := 1;
8720: x_msg_data := sqlerrm;
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:
9428: x_msg_count := 1;
9429: x_msg_data := sqlerrm;
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:
10414: -- 4537865
10415: p_start_date := NULL ;
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:
10443: -- 4537865
10444: p_start_date := NULL ;
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:
10480: -- 4537865
10481: p_start_date := NULL ;
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:
10523: p_data => l_data, -- 4537865
10524: p_msg_index_out => l_msg_index_out );
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:
10809: x_msg_count := 1;
10810: x_msg_data := sqlerrm;
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:
11126: x_msg_count := 1;
11127: x_msg_data := sqlerrm;
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:
12515: x_msg_count := 1;
12516: x_msg_data := 'ResOU not found';
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:
12540: x_msg_count := 1;
12541: x_msg_data := 'ResOrgn not found';
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:
12566: x_msg_count := 1;
12567: x_msg_data := sqlerrm ;
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:
12596: x_msg_count := 1;
12597: x_msg_data := sqlerrm;
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:
13322: x_msg_count := 1;
13323: x_msg_data := sqlerrm;
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:
13472: x_msg_count := 1;
13473: x_msg_data := sqlerrm;
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:
13890: x_msg_count := 1;
13891: x_msg_data := sqlerrm;
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:
14155: x_msg_count := 1;
14156: x_msg_data := 'Assignment ID Lock Failure';
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:
14201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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
14651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14652: x_msg_count := 1;
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:
14758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14759: x_msg_count := 1;
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:
14926: x_start_date := NULL ;
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:
15051:
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:
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,