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_DEBUG

Line 15: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */

11: /** The follwing Api prints the message to
12: * different places . this is the centralized api
13: * created by Ranga Iyengar
14: **/
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);

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 25: pa_debug.write_file('print_message: ' || 'Log :'||p_msg);

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;
27: --r_msg('Log :'||p_msg);
28: --dbms_output.put_line('Log:'||p_msg);
29: end if;

Line 95: PA_DEBUG.Init_err_stack(

91: BEGIN
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');

Line 215: PA_DEBUG.Reset_Err_Stack;

211: END IF;
212:
213: x_return_status := lv_return_status;
214:
215: PA_DEBUG.Reset_Err_Stack;
216:
217: EXCEPTION
218:
219: WHEN OTHERS THEN

Line 228: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
232: pa_interface_utils_pub.get_messages

Line 289: PA_DEBUG.Init_err_stack(

285: lv_return_status := FND_API.G_RET_STS_SUCCESS;
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:

Line 308: PA_DEBUG.Reset_Err_Stack;

304: x_msg_count => x_msg_count,
305: x_msg_data => x_msg_data );
306:
307: PRINT_MESSAGE(x_return_status || ' ' || lv_return_status);
308: PA_DEBUG.Reset_Err_Stack;
309: PRINT_MESSAGE(x_return_status || ' ' || lv_return_status);
310:
311: x_return_status := lv_return_status;
312: PRINT_MESSAGE(x_return_status || ' ' || lv_return_status);

Line 326: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
330: (p_encoded => FND_API.G_TRUE,

Line 440: PA_DEBUG.Init_err_stack(

436: BEGIN
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;

Line 594: PA_DEBUG.Reset_Err_Stack;

590: END IF;
591:
592: x_return_status := lv_return_status;
593:
594: PA_DEBUG.Reset_Err_Stack;
595:
596: EXCEPTION
597: -- 2275838: Removed code to handle locking exception
598: -- because locking occurs in sub procedures.

Line 609: p_procedure_name => PA_DEBUG.G_Err_Stack);

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;
613:

Line 647: PA_DEBUG.Init_err_stack(

643: BEGIN
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');

Line 660: PA_DEBUG.Reset_Err_Stack;

656: x_return_status => lv_return_status,
657: x_msg_count => x_msg_count,
658: x_msg_data => x_msg_data );
659:
660: PA_DEBUG.Reset_Err_Stack;
661:
662: x_return_status := lv_return_status;
663:
664: EXCEPTION

Line 676: p_procedure_name => PA_DEBUG.G_Err_Stack);

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,
680: p_msg_index => 1,

Line 724: PA_DEBUG.Init_err_stack(

720: BEGIN
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

Line 780: PA_DEBUG.Reset_Err_Stack;

776: END IF;
777:
778: x_return_status := lv_return_status;
779:
780: PA_DEBUG.Reset_Err_Stack;
781:
782: EXCEPTION
783:
784: WHEN OTHERS THEN

Line 794: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
798: (p_encoded => FND_API.G_TRUE,

Line 836: PA_DEBUG.Init_err_stack(

832: BEGIN
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);

Line 897: PA_DEBUG.Reset_Err_Stack;

893:
894: Print_message(
895: 'Leaving Get_Assignment_Dtls');
896:
897: PA_DEBUG.Reset_Err_Stack;
898:
899: x_return_status := lv_return_status;
900:
901: EXCEPTION

Line 913: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
917: (p_encoded => FND_API.G_TRUE,

Line 963: PA_DEBUG.Init_err_stack(

959: BEGIN
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:

Line 996: PA_DEBUG.Reset_Err_Stack;

992: end if;
993:
994: Print_message('Leaving Get_Project_Dtls');
995:
996: PA_DEBUG.Reset_Err_Stack;
997:
998: x_return_status := lv_return_status;
999:
1000: EXCEPTION

Line 1020: p_procedure_name => PA_DEBUG.G_Err_Stack);

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,
1024: p_msg_index => 1,

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 1416: PA_DEBUG.Reset_Err_Stack;

1412: 'Leaving Generate_Requirement_FI');
1413:
1414: x_return_status := lv_return_status;
1415:
1416: PA_DEBUG.Reset_Err_Stack;
1417:
1418: EXCEPTION
1419:
1420: WHEN NO_DATA_FOUND THEN

Line 1432: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
1436: (p_encoded => FND_API.G_TRUE,

Line 1458: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
1462: (p_encoded => FND_API.G_TRUE,

Line 1488: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
1492: (p_encoded => FND_API.G_TRUE,

Line 1597: PA_DEBUG.Init_err_stack(

1593: BEGIN
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');

Line 1728: PA_DEBUG.Reset_Err_Stack;

1724:
1725:
1726: x_return_status := lv_return_status;
1727:
1728: PA_DEBUG.Reset_Err_Stack;
1729:
1730: Print_message('Leaving Initialize_Day_FI');
1731:
1732: EXCEPTION

Line 1756: p_procedure_name => PA_DEBUG.G_Err_Stack);

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:
1760: RAISE;

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 2044: PA_DEBUG.Reset_Err_Stack;

2040: p_FIDayTab := TmpFIDayTab;
2041:
2042: Print_message('Leaving Build_Day_FI');
2043:
2044: PA_DEBUG.Reset_Err_Stack;
2045:
2046: x_return_status := lv_return_status;
2047:
2048: EXCEPTION

Line 2060: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
2064: (p_encoded => FND_API.G_TRUE,

Line 2161: PA_DEBUG.Init_err_stack(

2157: lv_return_status := FND_API.G_RET_STS_SUCCESS;
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;

Line 2354: PA_DEBUG.Reset_Err_Stack;

2350: Print_message('Leaving Reverse_FI_Hdr');
2351:
2352: x_return_status := lv_return_status;
2353:
2354: PA_DEBUG.Reset_Err_Stack;
2355:
2356: EXCEPTION
2357:
2358: WHEN OTHERS THEN

Line 2373: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
2377: (p_encoded => FND_API.G_TRUE,

Line 2469: PA_DEBUG.Init_err_stack(

2465: lv_return_status := FND_API.G_RET_STS_SUCCESS;
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;

Line 2802: PA_DEBUG.Reset_Err_Stack;

2798: END IF;
2799:
2800: END IF;
2801:
2802: PA_DEBUG.Reset_Err_Stack;
2803:
2804: Print_message('Leaving Reverse_FI_Dtl');
2805:
2806: x_return_status := lv_return_status;

Line 2821: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
2825: (p_encoded => FND_API.G_TRUE,

Line 2927: PA_DEBUG.Init_err_stack(

2923: lv_return_status := FND_API.G_RET_STS_SUCCESS;
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;

Line 3103: PA_DEBUG.Reset_Err_Stack;

3099: --Print_message('!!!x_dbFIHdrTab(1).provisional_flag: ' || x_dbFIHdrTab(1).provisional_flag);
3100: --Print_message('!!!x_dbFIHdrTab(1).item_date: ' || x_dbFIHdrTab(1).provisional_flag);
3101: Print_message('Leaving Fetch_FI_Hdr');
3102:
3103: PA_DEBUG.Reset_Err_Stack;
3104:
3105: x_return_status := lv_return_status;
3106:
3107: EXCEPTION

Line 3120: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
3124: (p_encoded => FND_API.G_TRUE,

Line 3223: PA_DEBUG.Init_err_stack(

3219: lv_return_status := FND_API.G_RET_STS_SUCCESS;
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;

Line 3408: PA_DEBUG.Reset_Err_Stack;

3404: x_dbFIDtlTab := TmpDtlTab;
3405:
3406: Print_message('Leaving Fetch_FI_Dtl');
3407:
3408: PA_DEBUG.Reset_Err_Stack;
3409:
3410: x_return_status := lv_return_status;
3411:
3412: EXCEPTION

Line 3425: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
3429: (p_encoded => FND_API.G_TRUE,

Line 3563: PA_DEBUG.Init_err_stack(

3559: lv_return_status := FND_API.G_RET_STS_SUCCESS;
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;

Line 4392: PA_DEBUG.Reset_Err_Stack;

4388: p_FIDayTab := TmpDayTab;
4389:
4390: Print_message('Leaving Build_FI_Hdr_Req');
4391:
4392: PA_DEBUG.Reset_Err_Stack;
4393:
4394: x_return_status := lv_return_status;
4395:
4396: EXCEPTION

Line 4410: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
4414: (p_encoded => FND_API.G_TRUE,

Line 4437: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
4441: (p_encoded => FND_API.G_TRUE,

Line 4537: PA_DEBUG.Init_err_stack(

4533:
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:

Line 5083: PA_DEBUG.Reset_Err_Stack;

5079:
5080:
5081: Print_message('Leaving Build_FI_Dtl_Req');
5082:
5083: PA_DEBUG.Reset_Err_Stack;
5084:
5085: x_return_status := lv_return_status;
5086:
5087: EXCEPTION

Line 5100: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
5104: (p_encoded => FND_API.G_TRUE,

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 5636: PA_DEBUG.Reset_Err_Stack;

5632:
5633:
5634: Print_message( 'Leaving Generate_Assignment_FI');
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');

Line 5667: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
5671: (p_encoded => FND_API.G_TRUE,

Line 5697: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
5701: (p_encoded => FND_API.G_TRUE,

Line 5726: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
5730: (p_encoded => FND_API.G_TRUE,

Line 5763: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
5767: (p_encoded => FND_API.G_TRUE,

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 5869: PA_DEBUG.Reset_Err_Stack;

5865:
5866: Print_message(
5867: 'Leaving Delete_FI');
5868:
5869: PA_DEBUG.Reset_Err_Stack;
5870:
5871: x_return_status := lv_return_status;
5872:
5873: EXCEPTION

Line 5886: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
5890: (p_encoded => FND_API.G_TRUE,

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 6173: PA_DEBUG.Reset_Err_Stack;

6169:
6170: Print_message(
6171: 'Leaving Delete_FI_Hdr');
6172:
6173: PA_DEBUG.Reset_Err_Stack;
6174:
6175: x_return_status := lv_return_status;
6176:
6177: EXCEPTION

Line 6190: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
6194: (p_encoded => FND_API.G_TRUE,

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 6613: PA_DEBUG.Reset_Err_Stack;

6609:
6610:
6611: Print_message( 'Leaving Delete_FI_Dtl');
6612:
6613: PA_DEBUG.Reset_Err_Stack;
6614:
6615: x_return_status := lv_return_status;
6616:
6617: EXCEPTION

Line 6630: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
6634: (p_encoded => FND_API.G_TRUE,

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 6691: PA_DEBUG.Reset_Err_Stack;

6687:
6688: Print_message(
6689: 'Leaving Delete_FI');
6690:
6691: PA_DEBUG.Reset_Err_Stack;
6692:
6693: x_return_status := lv_return_status;
6694:
6695: EXCEPTION

Line 6708: p_procedure_name => PA_DEBUG.G_Err_Stack);

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:
6712: --RAISE;

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 6929: PA_DEBUG.Reset_Err_Stack;

6925:
6926: Print_message(
6927: 'Leaving Delete_FI_Hdr');
6928:
6929: PA_DEBUG.Reset_Err_Stack;
6930:
6931: x_return_status := lv_return_status;
6932:
6933: EXCEPTION

Line 6952: p_procedure_name => PA_DEBUG.G_Err_Stack);

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:
6956: --RAISE;

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 7368: PA_DEBUG.Reset_Err_Stack;

7364:
7365:
7366: Print_message( 'Leaving Delete_FI_Dtl');
7367:
7368: PA_DEBUG.Reset_Err_Stack;
7369:
7370: x_return_status := lv_return_status;
7371:
7372: EXCEPTION

Line 7391: p_procedure_name => PA_DEBUG.G_Err_Stack);

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:
7395: --RAISE;

Line 7559: PA_DEBUG.Init_err_stack(

7555: lv_return_status := FND_API.G_RET_STS_SUCCESS;
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;

Line 8627: PA_DEBUG.Reset_Err_Stack;

8623:
8624: Print_message(
8625: 'Leaving Build_FI_Hdr_Asg');
8626:
8627: PA_DEBUG.Reset_Err_Stack;
8628:
8629: x_return_status := lv_return_status;
8630:
8631: EXCEPTION

Line 8644: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
8648: (p_encoded => FND_API.G_TRUE,

Line 8669: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
8673: (p_encoded => FND_API.G_TRUE,

Line 8695: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
8699: (p_encoded => FND_API.G_TRUE,

Line 8726: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
8730: (p_encoded => FND_API.G_TRUE,

Line 8833: PA_DEBUG.Init_err_stack(

8829: BEGIN
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;

Line 9418: PA_DEBUG.Reset_Err_Stack;

9414:
9415:
9416: Print_message('Leaving build_fi_dtl_asg');
9417:
9418: PA_DEBUG.Reset_Err_Stack;
9419:
9420: x_return_status := lv_return_status;
9421:
9422: EXCEPTION

Line 9435: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
9439: (p_encoded => FND_API.G_TRUE,

Line 9616: PA_DEBUG.Init_err_stack(

9612:
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.

Line 10389: PA_DEBUG.Reset_Err_Stack;

10385:
10386: Print_message('Leaving Regenerate_Res_Unassigned_FI');
10387:
10388: PRINT_MESSAGE(x_return_status || ' ' || lv_return_status);
10389: PA_DEBUG.Reset_Err_Stack;
10390:
10391: PRINT_MESSAGE(x_return_status || ' ' || lv_return_status);
10392: x_return_status := lv_return_status;
10393:

Line 10397: PA_DEBUG.Reset_Err_Stack;

10393:
10394: EXCEPTION
10395: WHEN l_no_fis_to_create THEN
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 ');

Line 10421: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
10425: (p_encoded => FND_API.G_TRUE,

Line 10450: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
10454: (p_encoded => FND_API.G_TRUE,

Line 10487: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
10491: (p_encoded => FND_API.G_TRUE,

Line 10530: p_procedure_name => PA_DEBUG.G_Err_Stack);

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:
10534:

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 10798: PA_DEBUG.Reset_Err_Stack;

10794:
10795:
10796: Print_message('Leaving Fetch_FI_Hdr_Res');
10797:
10798: PA_DEBUG.Reset_Err_Stack;
10799:
10800: x_return_status := lv_return_status;
10801:
10802:

Line 10816: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
10820: (p_encoded => FND_API.G_TRUE,

Line 10917: PA_DEBUG.Init_err_stack(

10913: lv_return_status := FND_API.G_RET_STS_SUCCESS;
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;

Line 11116: PA_DEBUG.Reset_Err_Stack;

11112: x_dbFIDtlTab := TmpDtlTab;
11113:
11114: Print_message('Leaving Fetch_FI_Dtl_Res');
11115:
11116: PA_DEBUG.Reset_Err_Stack;
11117:
11118: x_return_status := lv_return_status;
11119:
11120: EXCEPTION

Line 11133: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
11137: (p_encoded => FND_API.G_TRUE,

Line 11317: PA_DEBUG.Init_err_stack(

11313: lv_return_status := FND_API.G_RET_STS_SUCCESS;
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:

Line 12508: PA_DEBUG.Reset_Err_Stack;

12504: x_FIHdrUpdTab := TmpUpdTab;
12505:
12506: Print_message('Leaving Build_FI_Hdr_Res');
12507:
12508: PA_DEBUG.Reset_Err_Stack;
12509:
12510: x_return_status := lv_return_status;
12511:
12512: EXCEPTION

Line 12525: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
12529: (p_encoded => FND_API.G_TRUE,

Line 12550: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
12554: (p_encoded => FND_API.G_TRUE,

Line 12576: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
12580: (p_encoded => FND_API.G_TRUE,

Line 12606: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
12610: (p_encoded => FND_API.G_TRUE,

Line 12716: PA_DEBUG.Init_err_stack(

12712: lv_return_status := FND_API.G_RET_STS_SUCCESS;
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;

Line 13315: PA_DEBUG.Reset_Err_Stack;

13311: Print_message('Leaving Build_FI_Dtl_Res');
13312:
13313: x_return_status := FND_API.G_RET_STS_SUCCESS;
13314:
13315: PA_DEBUG.Reset_Err_Stack;
13316:
13317: x_return_status := lv_return_status;
13318:
13319: EXCEPTION

Line 13332: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
13336: (p_encoded => FND_API.G_TRUE,

Line 13392: PA_DEBUG.Init_err_stack(

13388:
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 ;

Line 13465: PA_DEBUG.Reset_Err_Stack;

13461:
13462: Print_message(
13463: 'Leaving Resource_Unasg_Error_Process');
13464:
13465: PA_DEBUG.Reset_Err_Stack;
13466:
13467: x_return_status := lv_return_status;
13468:
13469: EXCEPTION

Line 13482: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
13486: (p_encoded => FND_API.G_TRUE,

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 13884: PA_DEBUG.Reset_Err_Stack;

13880:
13881: Print_message (
13882: 'Leaving FI_Error_Process');
13883:
13884: PA_DEBUG.Reset_Err_Stack;
13885:
13886: x_return_status := lv_return_status;
13887:
13888: EXCEPTION

Line 13900: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
13904: (p_encoded => FND_API.G_TRUE,

Line 14126: PA_DEBUG.Init_err_stack(

14122: lv_return_status := FND_API.G_RET_STS_SUCCESS;
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:

Line 14217: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
14221: (p_encoded => FND_API.G_TRUE,

Line 14248: PA_DEBUG.Reset_Err_Stack;

14244: CLOSE asgmt_dtls;
14245:
14246: Print_message('Leaving Regenrate_Asgn_Req');
14247:
14248: PA_DEBUG.Reset_Err_Stack;
14249:
14250: EXCEPTION
14251:
14252: WHEN OTHERS THEN

Line 14262: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
14266: (p_encoded => FND_API.G_TRUE,

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 14696: PA_DEBUG.Reset_Err_Stack;

14692: 'Leaving Regenrate_Unassigned');
14693:
14694: CLOSE unasgn_tim;
14695:
14696: PA_DEBUG.Reset_Err_Stack;
14697:
14698: x_return_status := lv_return_status;
14699:
14700: EXCEPTION

Line 14713: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
14717: (p_encoded => FND_API.G_TRUE,

Line 14758: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

14754:
14755: g_process_mode VARCHAR2(30);
14756: BEGIN
14757:
14758: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
14759: l_debug_mode := NVL(l_debug_mode, 'N');
14760:
14761: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'
14762: ,x_write_file => 'LOG'

Line 14761: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'

14757:
14758: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
14759: l_debug_mode := NVL(l_debug_mode, 'N');
14760:
14761: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'
14762: ,x_write_file => 'LOG'
14763: ,x_debug_mode => l_debug_mode
14764: );
14765:

Line 14778: PA_DEBUG.Init_err_stack(

14774: g_process_mode := p_process_mode;
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,

Line 14804: PA_DEBUG.Reset_Err_Stack;

14800:
14801: /** Reset the global param to null **/
14802: g_process_mode := Null;
14803:
14804: PA_DEBUG.Reset_Err_Stack;
14805:
14806: EXCEPTION
14807:
14808: WHEN OTHERS THEN

Line 14820: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
14824: (p_encoded => FND_API.G_TRUE,

Line 14987: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
14991: pa_interface_utils_pub.get_messages

Line 15112: p_procedure_name => PA_DEBUG.G_Err_Stack);

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
15116: x_start_date := NULL ;