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_FP_GEN_FCST_PG_PKG dependencies on PA_FP_GEN_AMOUNT_UTILS

Line 27: pa_fp_gen_amount_utils.fp_debug

23: -- the distribution_rule has been removed to improve performance.
24:
25: --Calling the get rev gen method to get the value for l_rev_gen_method
26: IF p_pa_debug_mode = 'Y' THEN
27: pa_fp_gen_amount_utils.fp_debug
28: (p_msg => 'Before calling
29: PA_RATE_PVT_PKG.Get_Revenue_Generation_Method',
30: p_module_name => l_module_name,
31: p_log_level => 5);

Line 39: pa_fp_gen_amount_utils.fp_debug

35: P_DISTRIBUTION_RULE => null, -- Modified for Bug 4711164
36: X_REV_GEN_METHOD => x_rev_gen_method,
37: X_ERROR_MSG => l_error_msg );
38: IF p_pa_debug_mode = 'Y' THEN
39: pa_fp_gen_amount_utils.fp_debug
40: (p_msg => 'After calling
41: PA_RATE_PVT_PKG.Get_Revenue_Generation_Method',
42: p_module_name => l_module_name,
43: p_log_level => 5);

Line 71: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

67: x_period_name PA_PERIODS_ALL.PERIOD_NAME%TYPE;
68: l_end_date PA_PERIODS_ALL.END_DATE%TYPE;
69: l_end_date1 PA_PERIODS_ALL.END_DATE%TYPE;
70: l_end_date2 PA_PERIODS_ALL.END_DATE%TYPE;
71: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
72: l_ret_status VARCHAR2(100);
73: l_msg_count NUMBER;
74: l_msg_data VARCHAR2(2000);
75: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.GET_ACTUALS_THRU_PERIOD_DTLS';

Line 84: pa_fp_gen_amount_utils.fp_debug

80: p_debug_mode => p_pa_debug_mode);
81: END IF;
82: --Calling the Util API
83: IF p_pa_debug_mode = 'Y' THEN
84: pa_fp_gen_amount_utils.fp_debug
85: (p_msg => 'Before calling
86: pa_fp_gen_amount_utils.get_plan_version_dtls',
87: p_module_name => l_module_name,
88: p_log_level => 5);

Line 86: pa_fp_gen_amount_utils.get_plan_version_dtls',

82: --Calling the Util API
83: IF p_pa_debug_mode = 'Y' THEN
84: pa_fp_gen_amount_utils.fp_debug
85: (p_msg => 'Before calling
86: pa_fp_gen_amount_utils.get_plan_version_dtls',
87: p_module_name => l_module_name,
88: p_log_level => 5);
89: END IF;
90: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

Line 90: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

86: pa_fp_gen_amount_utils.get_plan_version_dtls',
87: p_module_name => l_module_name,
88: p_log_level => 5);
89: END IF;
90: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS
91: (P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
92: X_FP_COLS_REC => l_fp_cols_rec,
93: X_RETURN_STATUS => L_RET_STATUS,
94: X_MSG_COUNT => L_MSG_COUNT,

Line 100: pa_fp_gen_amount_utils.fp_debug

96: IF L_RET_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
97: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
98: END IF;
99: IF p_pa_debug_mode = 'Y' THEN
100: pa_fp_gen_amount_utils.fp_debug
101: (p_msg => 'Status after calling
102: pa_fp_gen_amount_utils.get_plan_version_dtls: '
103: ||L_RET_STATUS,
104: p_module_name => l_module_name,

Line 102: pa_fp_gen_amount_utils.get_plan_version_dtls: '

98: END IF;
99: IF p_pa_debug_mode = 'Y' THEN
100: pa_fp_gen_amount_utils.fp_debug
101: (p_msg => 'Status after calling
102: pa_fp_gen_amount_utils.get_plan_version_dtls: '
103: ||L_RET_STATUS,
104: p_module_name => l_module_name,
105: p_log_level => 5);
106: END IF;

Line 293: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

289: RETURN VARCHAR2 IS
290: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.GET_ACT_FRM_PERIOD';
291:
292:
293: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
294: l_return_status VARCHAR2(10);
295: l_msg_count NUMBER;
296: l_msg_data VARCHAR2(2000);
297: l_data VARCHAR2(2000);

Line 308: pa_fp_gen_amount_utils.fp_debug

304: p_debug_mode => p_pa_debug_mode);
305: END IF;
306: --Calling the Util API
307: IF p_pa_debug_mode = 'Y' THEN
308: pa_fp_gen_amount_utils.fp_debug
309: (p_msg => 'Before calling
310: pa_fp_gen_amount_utils.get_plan_version_dtls',
311: p_module_name => l_module_name,
312: p_log_level => 5);

Line 310: pa_fp_gen_amount_utils.get_plan_version_dtls',

306: --Calling the Util API
307: IF p_pa_debug_mode = 'Y' THEN
308: pa_fp_gen_amount_utils.fp_debug
309: (p_msg => 'Before calling
310: pa_fp_gen_amount_utils.get_plan_version_dtls',
311: p_module_name => l_module_name,
312: p_log_level => 5);
313: END IF;
314: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

Line 314: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

310: pa_fp_gen_amount_utils.get_plan_version_dtls',
311: p_module_name => l_module_name,
312: p_log_level => 5);
313: END IF;
314: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS
315: (P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
316: X_FP_COLS_REC => l_fp_cols_rec,
317: X_RETURN_STATUS => l_RETURN_STATUS,
318: X_MSG_COUNT => l_MSG_COUNT,

Line 324: pa_fp_gen_amount_utils.fp_debug

320: IF l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
321: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
322: END IF;
323: IF p_pa_debug_mode = 'Y' THEN
324: pa_fp_gen_amount_utils.fp_debug
325: (p_msg => 'Status after calling
326: pa_fp_gen_amount_utils.get_plan_version_dtls: '
327: ||l_RETURN_STATUS,
328: p_module_name => l_module_name,

Line 326: pa_fp_gen_amount_utils.get_plan_version_dtls: '

322: END IF;
323: IF p_pa_debug_mode = 'Y' THEN
324: pa_fp_gen_amount_utils.fp_debug
325: (p_msg => 'Status after calling
326: pa_fp_gen_amount_utils.get_plan_version_dtls: '
327: ||l_RETURN_STATUS,
328: p_module_name => l_module_name,
329: p_log_level => 5);
330: END IF;

Line 383: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

379:
380: FUNCTION GET_ACT_TO_PERIOD(P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE)
381: RETURN VARCHAR2 IS
382: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.GET_ACT_TO_PERIOD';
383: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
384: l_return_status VARCHAR2(10);
385: l_msg_count NUMBER;
386: l_msg_data VARCHAR2(2000);
387: l_data VARCHAR2(2000);

Line 400: pa_fp_gen_amount_utils.fp_debug

396: p_debug_mode => p_pa_debug_mode);
397: END IF;
398: --Calling the Util API
399: IF p_pa_debug_mode = 'Y' THEN
400: pa_fp_gen_amount_utils.fp_debug
401: (p_msg => 'Before calling
402: pa_fp_gen_amount_utils.get_plan_version_dtls',
403: p_module_name => l_module_name,
404: p_log_level => 5);

Line 402: pa_fp_gen_amount_utils.get_plan_version_dtls',

398: --Calling the Util API
399: IF p_pa_debug_mode = 'Y' THEN
400: pa_fp_gen_amount_utils.fp_debug
401: (p_msg => 'Before calling
402: pa_fp_gen_amount_utils.get_plan_version_dtls',
403: p_module_name => l_module_name,
404: p_log_level => 5);
405: END IF;
406: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

Line 406: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

402: pa_fp_gen_amount_utils.get_plan_version_dtls',
403: p_module_name => l_module_name,
404: p_log_level => 5);
405: END IF;
406: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS
407: (P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
408: X_FP_COLS_REC => l_fp_cols_rec,
409: X_RETURN_STATUS => l_RETURN_STATUS,
410: X_MSG_COUNT => l_MSG_COUNT,

Line 417: pa_fp_gen_amount_utils.fp_debug

413: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
414: END IF;
415:
416: IF p_pa_debug_mode = 'Y' THEN
417: pa_fp_gen_amount_utils.fp_debug
418: (p_msg => 'Status after calling
419: pa_fp_gen_amount_utils.get_plan_version_dtls: '
420: ||l_RETURN_STATUS,
421: p_module_name => l_module_name,

Line 419: pa_fp_gen_amount_utils.get_plan_version_dtls: '

415:
416: IF p_pa_debug_mode = 'Y' THEN
417: pa_fp_gen_amount_utils.fp_debug
418: (p_msg => 'Status after calling
419: pa_fp_gen_amount_utils.get_plan_version_dtls: '
420: ||l_RETURN_STATUS,
421: p_module_name => l_module_name,
422: p_log_level => 5);
423: END IF;

Line 500: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

496:
497: FUNCTION GET_ETC_FRM_PERIOD(P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE)
498: RETURN VARCHAR2 IS
499: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.GET_ETC_FRM_PERIOD';
500: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
501: l_return_status VARCHAR2(10);
502: l_msg_count NUMBER;
503: l_msg_data VARCHAR2(2000);
504: l_data VARCHAR2(2000);

Line 517: pa_fp_gen_amount_utils.fp_debug

513: p_debug_mode => p_pa_debug_mode);
514: END IF;
515: --Calling the Util API
516: IF p_pa_debug_mode = 'Y' THEN
517: pa_fp_gen_amount_utils.fp_debug
518: (p_msg => 'Before calling
519: pa_fp_gen_amount_utils.get_plan_version_dtls',
520: p_module_name => l_module_name,
521: p_log_level => 5);

Line 519: pa_fp_gen_amount_utils.get_plan_version_dtls',

515: --Calling the Util API
516: IF p_pa_debug_mode = 'Y' THEN
517: pa_fp_gen_amount_utils.fp_debug
518: (p_msg => 'Before calling
519: pa_fp_gen_amount_utils.get_plan_version_dtls',
520: p_module_name => l_module_name,
521: p_log_level => 5);
522: END IF;
523: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

Line 523: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

519: pa_fp_gen_amount_utils.get_plan_version_dtls',
520: p_module_name => l_module_name,
521: p_log_level => 5);
522: END IF;
523: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS
524: (P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
525: X_FP_COLS_REC => l_fp_cols_rec,
526: X_RETURN_STATUS => l_RETURN_STATUS,
527: X_MSG_COUNT => l_MSG_COUNT,

Line 534: pa_fp_gen_amount_utils.fp_debug

530: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
531: END IF;
532:
533: IF p_pa_debug_mode = 'Y' THEN
534: pa_fp_gen_amount_utils.fp_debug
535: (p_msg => 'Status after calling
536: pa_fp_gen_amount_utils.get_plan_version_dtls: '
537: ||l_RETURN_STATUS,
538: p_module_name => l_module_name,

Line 536: pa_fp_gen_amount_utils.get_plan_version_dtls: '

532:
533: IF p_pa_debug_mode = 'Y' THEN
534: pa_fp_gen_amount_utils.fp_debug
535: (p_msg => 'Status after calling
536: pa_fp_gen_amount_utils.get_plan_version_dtls: '
537: ||l_RETURN_STATUS,
538: p_module_name => l_module_name,
539: p_log_level => 5);
540: END IF;

Line 620: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

616: FUNCTION GET_ETC_TO_PERIOD(P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE)
617: RETURN VARCHAR2 IS
618: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.GET_ETC_TO_PERIOD';
619:
620: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
621: l_return_status VARCHAR2(10);
622: l_msg_count NUMBER;
623: l_msg_data VARCHAR2(2000);
624: l_data VARCHAR2(2000);

Line 636: pa_fp_gen_amount_utils.fp_debug

632: p_debug_mode => p_pa_debug_mode);
633: END IF;
634: --Calling the Util API
635: IF p_pa_debug_mode = 'Y' THEN
636: pa_fp_gen_amount_utils.fp_debug
637: (p_msg => 'Before calling
638: pa_fp_gen_amount_utils.get_plan_version_dtls',
639: p_module_name => l_module_name,
640: p_log_level => 5);

Line 638: pa_fp_gen_amount_utils.get_plan_version_dtls',

634: --Calling the Util API
635: IF p_pa_debug_mode = 'Y' THEN
636: pa_fp_gen_amount_utils.fp_debug
637: (p_msg => 'Before calling
638: pa_fp_gen_amount_utils.get_plan_version_dtls',
639: p_module_name => l_module_name,
640: p_log_level => 5);
641: END IF;
642: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

Line 642: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

638: pa_fp_gen_amount_utils.get_plan_version_dtls',
639: p_module_name => l_module_name,
640: p_log_level => 5);
641: END IF;
642: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS
643: (P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
644: X_FP_COLS_REC => l_fp_cols_rec,
645: X_RETURN_STATUS => l_RETURN_STATUS,
646: X_MSG_COUNT => l_MSG_COUNT,

Line 652: pa_fp_gen_amount_utils.fp_debug

648: IF l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
649: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
650: END IF;
651: IF p_pa_debug_mode = 'Y' THEN
652: pa_fp_gen_amount_utils.fp_debug
653: (p_msg => 'Status after calling
654: pa_fp_gen_amount_utils.get_plan_version_dtls: '
655: ||l_RETURN_STATUS,
656: p_module_name => l_module_name,

Line 654: pa_fp_gen_amount_utils.get_plan_version_dtls: '

650: END IF;
651: IF p_pa_debug_mode = 'Y' THEN
652: pa_fp_gen_amount_utils.fp_debug
653: (p_msg => 'Status after calling
654: pa_fp_gen_amount_utils.get_plan_version_dtls: '
655: ||l_RETURN_STATUS,
656: p_module_name => l_module_name,
657: p_log_level => 5);
658: END IF;

Line 785: pa_fp_gen_amount_utils.fp_debug

781: ROLLBACK;
782:
783: x_return_status := FND_API.G_RET_STS_ERROR;
784: IF P_PA_DEBUG_MODE = 'Y' THEN
785: pa_fp_gen_amount_utils.fp_debug
786: (p_msg => 'Invalid Arguments Passed',
787: p_module_name => l_module_name,
788: p_log_level => 5);
789: PA_DEBUG.Reset_Curr_Function;

Line 800: pa_fp_gen_amount_utils.fp_debug

796: FND_MSG_PUB.add_exc_msg
797: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'
798: ,p_procedure_name => 'GET_VERSION_DETAILS');
799: IF P_PA_DEBUG_MODE = 'Y' THEN
800: pa_fp_gen_amount_utils.fp_debug
801: (p_msg => 'Unexpected Error'||SUBSTR(SQLERRM,1,240),
802: p_module_name => l_module_name,
803: p_log_level => 5);
804: PA_DEBUG.Reset_Curr_Function;

Line 829: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

825: l_msg_count NUMBER;
826: l_msg_data VARCHAR2(2000);
827: l_data VARCHAR2(2000);
828: l_msg_index_out NUMBER:=0;
829: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
830:
831: CURSOR get_etc_source_code_csr
832: IS
833: SELECT GEN_ETC_SOURCE_CODE,TASK_NAME

Line 851: pa_fp_gen_amount_utils.fp_debug

847: -- Get the work plan details by calling the following method
848: -- with work plan version id
849: IF P_WP_VERSION_ID IS NOT NULL THEN
850: IF p_pa_debug_mode = 'Y' THEN
851: pa_fp_gen_amount_utils.fp_debug
852: (p_msg => 'Before calling
853: pa_fp_gen_amount_utils.get_plan_version_dtls(p_budget_version_id)',
854: p_module_name => l_module_name,
855: p_log_level => 5);

Line 853: pa_fp_gen_amount_utils.get_plan_version_dtls(p_budget_version_id)',

849: IF P_WP_VERSION_ID IS NOT NULL THEN
850: IF p_pa_debug_mode = 'Y' THEN
851: pa_fp_gen_amount_utils.fp_debug
852: (p_msg => 'Before calling
853: pa_fp_gen_amount_utils.get_plan_version_dtls(p_budget_version_id)',
854: p_module_name => l_module_name,
855: p_log_level => 5);
856: END IF;
857: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

Line 857: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

853: pa_fp_gen_amount_utils.get_plan_version_dtls(p_budget_version_id)',
854: p_module_name => l_module_name,
855: p_log_level => 5);
856: END IF;
857: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS
858: (P_BUDGET_VERSION_ID => P_WP_VERSION_ID,
859: X_FP_COLS_REC => l_fp_cols_rec,
860: X_RETURN_STATUS => X_RETURN_STATUS,
861: X_MSG_COUNT => X_MSG_COUNT,

Line 867: pa_fp_gen_amount_utils.fp_debug

863: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
864: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
865: END IF;
866: IF p_pa_debug_mode = 'Y' THEN
867: pa_fp_gen_amount_utils.fp_debug
868: (p_msg => 'Status after calling
869: pa_fp_gen_amount_utils.get_plan_version_dtls(p_budget_version_id): '
870: ||x_return_status,
871: p_module_name => l_module_name,

Line 869: pa_fp_gen_amount_utils.get_plan_version_dtls(p_budget_version_id): '

865: END IF;
866: IF p_pa_debug_mode = 'Y' THEN
867: pa_fp_gen_amount_utils.fp_debug
868: (p_msg => 'Status after calling
869: pa_fp_gen_amount_utils.get_plan_version_dtls(p_budget_version_id): '
870: ||x_return_status,
871: p_module_name => l_module_name,
872: p_log_level => 5);
873: END IF;

Line 892: pa_fp_gen_amount_utils.fp_debug

888: -- Get the financial plan details by calling the following
889: -- method with financial paln id
890: IF P_ETC_PLAN_VERSION_ID IS NOT NULL THEN
891: IF p_pa_debug_mode = 'Y' THEN
892: pa_fp_gen_amount_utils.fp_debug
893: (p_msg => 'Before calling
894: pa_fp_gen_amount_utils.get_plan_version_dtls(p_budget_version_id)',
895: p_module_name => l_module_name,
896: p_log_level => 5);

Line 894: pa_fp_gen_amount_utils.get_plan_version_dtls(p_budget_version_id)',

890: IF P_ETC_PLAN_VERSION_ID IS NOT NULL THEN
891: IF p_pa_debug_mode = 'Y' THEN
892: pa_fp_gen_amount_utils.fp_debug
893: (p_msg => 'Before calling
894: pa_fp_gen_amount_utils.get_plan_version_dtls(p_budget_version_id)',
895: p_module_name => l_module_name,
896: p_log_level => 5);
897: END IF;
898: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

Line 898: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

894: pa_fp_gen_amount_utils.get_plan_version_dtls(p_budget_version_id)',
895: p_module_name => l_module_name,
896: p_log_level => 5);
897: END IF;
898: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS
899: (P_BUDGET_VERSION_ID => P_ETC_PLAN_VERSION_ID,
900: X_FP_COLS_REC => l_fp_cols_rec,
901: X_RETURN_STATUS => X_RETURN_STATUS,
902: X_MSG_COUNT => X_MSG_COUNT,

Line 908: pa_fp_gen_amount_utils.fp_debug

904: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
905: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
906: END IF;
907: IF p_pa_debug_mode = 'Y' THEN
908: pa_fp_gen_amount_utils.fp_debug
909: (p_msg => 'Status after calling
910: pa_fp_gen_amount_utils.get_plan_version_dtls(p_budget_version_id): '
911: ||x_return_status,
912: p_module_name => l_module_name,

Line 910: pa_fp_gen_amount_utils.get_plan_version_dtls(p_budget_version_id): '

906: END IF;
907: IF p_pa_debug_mode = 'Y' THEN
908: pa_fp_gen_amount_utils.fp_debug
909: (p_msg => 'Status after calling
910: pa_fp_gen_amount_utils.get_plan_version_dtls(p_budget_version_id): '
911: ||x_return_status,
912: p_module_name => l_module_name,
913: p_log_level => 5);
914: END IF;

Line 969: pa_fp_gen_amount_utils.fp_debug

965: ROLLBACK;
966:
967: x_return_status := FND_API.G_RET_STS_ERROR;
968: IF P_PA_DEBUG_MODE = 'Y' THEN
969: pa_fp_gen_amount_utils.fp_debug
970: (p_msg => 'Validation failed',
971: p_module_name => l_module_name,
972: p_log_level => 5);
973: PA_DEBUG.Reset_Curr_Function;

Line 983: pa_fp_gen_amount_utils.fp_debug

979: FND_MSG_PUB.add_exc_msg
980: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'
981: ,p_procedure_name => 'VALIDATE_PLAN_TYPE_OR_VERSION');
982: IF P_PA_DEBUG_MODE = 'Y' THEN
983: pa_fp_gen_amount_utils.fp_debug
984: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
985: p_module_name => l_module_name,
986: p_log_level => 5);
987: PA_DEBUG.Reset_Curr_Function;

Line 1028: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

1024: X_MSG_COUNT OUT NOCOPY NUMBER,
1025: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
1026:
1027: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.upd_ver_dtls_and_gen_amt';
1028: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
1029: l_PLAN_VERSION_ID PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE;
1030: l_ETC_PLAN_VERSION_ID PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE;
1031: l_return_status VARCHAR2(10);
1032: l_msg_count NUMBER;

Line 1111: pa_fp_gen_amount_utils.fp_debug

1107: INTO l_record_version_number
1108: FROM pa_budget_versions
1109: WHERE budget_version_id = p_budget_version_id;
1110: IF p_pa_debug_mode = 'Y' THEN
1111: pa_fp_gen_amount_utils.fp_debug
1112: (p_msg => 'Before calling pa_fin_plan_pvt.lock_unlock_version',
1113: p_module_name => l_module_name);
1114: END IF;
1115: pa_fin_plan_pvt.lock_unlock_version

Line 1125: pa_fp_gen_amount_utils.fp_debug

1121: x_return_status => x_return_status,
1122: x_msg_count => x_msg_count,
1123: x_msg_data => x_msg_data);
1124: IF p_pa_debug_mode = 'Y' THEN
1125: pa_fp_gen_amount_utils.fp_debug
1126: (p_msg => 'Status after calling pa_fin_plan_pvt.lock_unlock_version:'
1127: ||x_return_status,
1128: p_module_name => l_module_name);
1129: END IF;

Line 1145: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

1141: will be available for other sessions. */
1142:
1143: --acquire lock for copy_actual
1144: IF p_pa_debug_mode = 'Y' THEN
1145: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1146: P_MSG => 'Before calling PA_FP_COPY_FROM_PKG.'
1147: ||'ACQUIRE_LOCKS_FOR_COPY_ACTUAL',
1148: P_MODULE_NAME => l_module_name);
1149: END IF;

Line 1166: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

1162: RETURN;
1163: END IF;
1164:
1165: IF p_pa_debug_mode = 'Y' THEN
1166: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1167: P_MSG => 'After calling PA_FP_COPY_FROM_PKG.'
1168: ||'ACQUIRE_LOCKS_FOR_COPY_ACTUAL: '
1169: ||x_return_status,
1170: P_MODULE_NAME => l_module_name);

Line 1180: pa_fp_gen_amount_utils.fp_debug

1176: l_ETC_PLAN_VERSION_ID := P_ETC_PLAN_VERSION_ID;
1177:
1178: --Calling the Util API
1179: IF p_pa_debug_mode = 'Y' THEN
1180: pa_fp_gen_amount_utils.fp_debug
1181: (p_msg => 'Before calling
1182: pa_fp_gen_amount_utils.get_plan_version_dtls(p_budget_version_id)',
1183: p_module_name => l_module_name,
1184: p_log_level => 5);

Line 1182: pa_fp_gen_amount_utils.get_plan_version_dtls(p_budget_version_id)',

1178: --Calling the Util API
1179: IF p_pa_debug_mode = 'Y' THEN
1180: pa_fp_gen_amount_utils.fp_debug
1181: (p_msg => 'Before calling
1182: pa_fp_gen_amount_utils.get_plan_version_dtls(p_budget_version_id)',
1183: p_module_name => l_module_name,
1184: p_log_level => 5);
1185: END IF;
1186: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

Line 1186: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

1182: pa_fp_gen_amount_utils.get_plan_version_dtls(p_budget_version_id)',
1183: p_module_name => l_module_name,
1184: p_log_level => 5);
1185: END IF;
1186: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS
1187: (P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
1188: X_FP_COLS_REC => l_fp_cols_rec,
1189: X_RETURN_STATUS => X_RETURN_STATUS,
1190: X_MSG_COUNT => X_MSG_COUNT,

Line 1196: pa_fp_gen_amount_utils.fp_debug

1192: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1193: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1194: END IF;
1195: IF p_pa_debug_mode = 'Y' THEN
1196: pa_fp_gen_amount_utils.fp_debug
1197: (p_msg => 'Status after calling
1198: pa_fp_gen_amount_utils.get_plan_version_dtls(p_budget_version_id): '
1199: ||x_return_status,
1200: p_module_name => l_module_name,

Line 1198: pa_fp_gen_amount_utils.get_plan_version_dtls(p_budget_version_id): '

1194: END IF;
1195: IF p_pa_debug_mode = 'Y' THEN
1196: pa_fp_gen_amount_utils.fp_debug
1197: (p_msg => 'Status after calling
1198: pa_fp_gen_amount_utils.get_plan_version_dtls(p_budget_version_id): '
1199: ||x_return_status,
1200: p_module_name => l_module_name,
1201: p_log_level => 5);
1202: END IF;

Line 1247: pa_fp_gen_amount_utils.fp_debug

1243: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1244: END IF;
1245:
1246: IF p_pa_debug_mode = 'Y' THEN
1247: pa_fp_gen_amount_utils.fp_debug
1248: (p_msg => 'Before calling
1249: pa_fp_gen_fcst_pg_pkg.validation_for_copy_etc_flag',
1250: p_module_name => l_module_name,
1251: p_log_level => 5);

Line 1266: pa_fp_gen_amount_utils.fp_debug

1262: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1263: l_return_status := X_RETURN_STATUS;
1264: END IF;
1265: IF p_pa_debug_mode = 'Y' THEN
1266: pa_fp_gen_amount_utils.fp_debug
1267: (p_msg => 'Status after calling
1268: pa_fp_gen_fcst_pg_pkg.validation_for_copy_etc_flag: '
1269: ||x_return_status,
1270: p_module_name => l_module_name,

Line 1283: pa_fp_gen_amount_utils.fp_debug

1279: RESOURCE SCHEDULE. */
1280:
1281: IF L_FP_COLS_REC.X_GEN_ETC_SRC_CODE <> 'RESOURCE_SCHEDULE' THEN
1282: IF p_pa_debug_mode = 'Y' THEN
1283: pa_fp_gen_amount_utils.fp_debug
1284: (p_msg => 'Before calling
1285: pa_fp_gen_fcst_pg_pkg.validate_periods',
1286: p_module_name => l_module_name,
1287: p_log_level => 5);

Line 1306: pa_fp_gen_amount_utils.fp_debug

1302: l_return_status := X_RETURN_STATUS;
1303: --RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1304: END IF;
1305: IF p_pa_debug_mode = 'Y' THEN
1306: pa_fp_gen_amount_utils.fp_debug
1307: (p_msg => 'Status after calling
1308: pa_fp_gen_fcst_pg_pkg.validate_periods: '
1309: ||x_return_status,
1310: p_module_name => l_module_name,

Line 1320: pa_fp_gen_amount_utils.fp_debug

1316: IF P_ETC_PLAN_TYPE_ID IS NOT NULL AND
1317: P_ETC_PLAN_VERSION_NAME IS NOT NULL AND
1318: l_ETC_PLAN_VERSION_ID IS NULL THEN
1319: IF p_pa_debug_mode = 'Y' THEN
1320: pa_fp_gen_amount_utils.fp_debug
1321: (p_msg => 'Before calling
1322: pa_fp_gen_fcst_pg_pkg.validate_plan_type_or_version',
1323: p_module_name => l_module_name,
1324: p_log_level => 5);

Line 1340: pa_fp_gen_amount_utils.fp_debug

1336: l_return_status := X_RETURN_STATUS;
1337: --RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1338: END IF;
1339: IF p_pa_debug_mode = 'Y' THEN
1340: pa_fp_gen_amount_utils.fp_debug
1341: ( p_msg => 'Status after calling
1342: pa_fp_gen_fcst_pg_pkg.validate_plan_type_or_version for etc_generation_source: '
1343: ||x_return_status,
1344: p_module_name => l_module_name,

Line 1364: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

1360:
1361: -- IPM: New Entity ER ------------------------------------------
1362: -- Call the maintenance api in DELETE mode
1363: IF p_pa_debug_mode = 'Y' THEN
1364: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1365: ( P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.'
1366: || 'MAINTAIN_DATA',
1367: --P_CALLED_MODE => p_called_mode,
1368: P_MODULE_NAME => l_module_name,

Line 1381: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

1377: X_RETURN_STATUS => x_return_status,
1378: X_MSG_COUNT => x_msg_count,
1379: X_MSG_DATA => x_msg_data );
1380: IF p_pa_debug_mode = 'Y' THEN
1381: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1382: ( P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.'
1383: || 'MAINTAIN_DATA: ' || x_return_status,
1384: --P_CALLED_MODE => p_called_mode,
1385: P_MODULE_NAME => l_module_name,

Line 1445: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

1441: 'Y' );
1442:
1443: -- Call the maintenance api in DELETE mode
1444: IF p_pa_debug_mode = 'Y' THEN
1445: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1446: ( P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.'
1447: || 'MAINTAIN_DATA',
1448: --P_CALLED_MODE => p_called_mode,
1449: P_MODULE_NAME => l_module_name,

Line 1462: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

1458: X_RETURN_STATUS => x_return_status,
1459: X_MSG_COUNT => x_msg_count,
1460: X_MSG_DATA => x_msg_data );
1461: IF p_pa_debug_mode = 'Y' THEN
1462: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1463: ( P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.'
1464: || 'MAINTAIN_DATA: ' || x_return_status,
1465: --P_CALLED_MODE => p_called_mode,
1466: P_MODULE_NAME => l_module_name,

Line 1566: pa_fp_gen_amount_utils.fp_debug

1562: /* We need to get version details again after validation logic and
1563: * updates to the budget version so that we pass the most current
1564: * information to lower level APIs via the l_fp_cols_rec parameter. */
1565: IF p_pa_debug_mode = 'Y' THEN
1566: pa_fp_gen_amount_utils.fp_debug
1567: ( p_msg => 'Before calling
1568: pa_fp_gen_amount_utils.get_plan_version_dtls',
1569: p_module_name => l_module_name,
1570: p_log_level => 5 );

Line 1568: pa_fp_gen_amount_utils.get_plan_version_dtls',

1564: * information to lower level APIs via the l_fp_cols_rec parameter. */
1565: IF p_pa_debug_mode = 'Y' THEN
1566: pa_fp_gen_amount_utils.fp_debug
1567: ( p_msg => 'Before calling
1568: pa_fp_gen_amount_utils.get_plan_version_dtls',
1569: p_module_name => l_module_name,
1570: p_log_level => 5 );
1571: END IF;
1572: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

Line 1572: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

1568: pa_fp_gen_amount_utils.get_plan_version_dtls',
1569: p_module_name => l_module_name,
1570: p_log_level => 5 );
1571: END IF;
1572: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS
1573: ( P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
1574: X_FP_COLS_REC => l_fp_cols_rec,
1575: X_RETURN_STATUS => X_RETURN_STATUS,
1576: X_MSG_COUNT => X_MSG_COUNT,

Line 1583: pa_fp_gen_amount_utils.fp_debug

1579: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1580: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1581: END IF;
1582: IF p_pa_debug_mode = 'Y' THEN
1583: pa_fp_gen_amount_utils.fp_debug
1584: ( p_msg => 'Status after calling
1585: pa_fp_gen_amount_utils.get_plan_version_dtls: '
1586: ||x_return_status,
1587: p_module_name => l_module_name,

Line 1585: pa_fp_gen_amount_utils.get_plan_version_dtls: '

1581: END IF;
1582: IF p_pa_debug_mode = 'Y' THEN
1583: pa_fp_gen_amount_utils.fp_debug
1584: ( p_msg => 'Status after calling
1585: pa_fp_gen_amount_utils.get_plan_version_dtls: '
1586: ||x_return_status,
1587: p_module_name => l_module_name,
1588: p_log_level => 5 );
1589: END IF;

Line 1596: pa_fp_gen_amount_utils.fp_debug

1592: * For a list of unsupported cases, please see comments at the
1593: * beginning of the VALIDATE_SUPPORT_CASES API (PAFPGAUB.pls) */
1594:
1595: IF p_pa_debug_mode = 'Y' THEN
1596: pa_fp_gen_amount_utils.fp_debug
1597: ( p_msg => 'Before calling
1598: pa_fp_gen_amount_utils.validate_support_cases',
1599: p_module_name => l_module_name,
1600: p_log_level => 5 );

Line 1598: pa_fp_gen_amount_utils.validate_support_cases',

1594:
1595: IF p_pa_debug_mode = 'Y' THEN
1596: pa_fp_gen_amount_utils.fp_debug
1597: ( p_msg => 'Before calling
1598: pa_fp_gen_amount_utils.validate_support_cases',
1599: p_module_name => l_module_name,
1600: p_log_level => 5 );
1601: END IF;
1602: PA_FP_GEN_AMOUNT_UTILS.VALIDATE_SUPPORT_CASES (

Line 1602: PA_FP_GEN_AMOUNT_UTILS.VALIDATE_SUPPORT_CASES (

1598: pa_fp_gen_amount_utils.validate_support_cases',
1599: p_module_name => l_module_name,
1600: p_log_level => 5 );
1601: END IF;
1602: PA_FP_GEN_AMOUNT_UTILS.VALIDATE_SUPPORT_CASES (
1603: P_FP_COLS_REC_TGT => l_fp_cols_rec,
1604: P_CHECK_SRC_ERRORS_FLAG => P_CHECK_SRC_ERRORS_FLAG,
1605: X_WARNING_MESSAGE => X_WARNING_MESSAGE,
1606: X_RETURN_STATUS => X_RETURN_STATUS,

Line 1610: pa_fp_gen_amount_utils.fp_debug

1606: X_RETURN_STATUS => X_RETURN_STATUS,
1607: X_MSG_COUNT => X_MSG_COUNT,
1608: X_MSG_DATA => X_MSG_DATA );
1609: IF p_pa_debug_mode = 'Y' THEN
1610: pa_fp_gen_amount_utils.fp_debug
1611: ( p_msg => 'Status after calling
1612: pa_fp_gen_amount_utils.validate_support_cases: '
1613: ||x_return_status,
1614: p_module_name => l_module_name,

Line 1612: pa_fp_gen_amount_utils.validate_support_cases: '

1608: X_MSG_DATA => X_MSG_DATA );
1609: IF p_pa_debug_mode = 'Y' THEN
1610: pa_fp_gen_amount_utils.fp_debug
1611: ( p_msg => 'Status after calling
1612: pa_fp_gen_amount_utils.validate_support_cases: '
1613: ||x_return_status,
1614: p_module_name => l_module_name,
1615: p_log_level => 5 );
1616: END IF;

Line 1640: pa_fp_gen_amount_utils.fp_debug

1636: END IF;
1637:
1638: --Calling Gen FCST Amt Wrapper API
1639: IF p_pa_debug_mode = 'Y' THEN
1640: pa_fp_gen_amount_utils.fp_debug
1641: (p_msg => 'Before calling
1642: pa_fp_gen_fcst_amt_pub.generate_fcst_amt_wrp',
1643: p_module_name => l_module_name,
1644: p_log_level => 5);

Line 1678: pa_fp_gen_amount_utils.fp_debug

1674: l_return_status := X_RETURN_STATUS;
1675: --RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1676: END IF;
1677: IF p_pa_debug_mode = 'Y' THEN
1678: pa_fp_gen_amount_utils.fp_debug
1679: (p_msg => 'Status after calling
1680: pa_fp_gen_fcst_amt_pub.generate_fcst_amt_wrp: '
1681: ||x_return_status,
1682: p_module_name => l_module_name,

Line 1720: pa_fp_gen_amount_utils.fp_debug

1716:
1717: x_return_status := FND_API.G_RET_STS_ERROR;
1718:
1719: IF P_PA_DEBUG_MODE = 'Y' THEN
1720: pa_fp_gen_amount_utils.fp_debug
1721: (p_msg => 'Invalid Arguments Passed',
1722: p_module_name => l_module_name,
1723: p_log_level => 5);
1724: PA_DEBUG.Reset_Curr_Function;

Line 1738: pa_fp_gen_amount_utils.fp_debug

1734: FND_MSG_PUB.add_exc_msg
1735: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'
1736: ,p_procedure_name => 'UPD_VER_DTLS_AND_GEN_AMT');
1737: IF P_PA_DEBUG_MODE = 'Y' THEN
1738: pa_fp_gen_amount_utils.fp_debug
1739: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1740: p_module_name => l_module_name,
1741: p_log_level => 5);
1742: PA_DEBUG.Reset_Curr_Function;

Line 1751: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

1747:
1748:
1749: PROCEDURE VALIDATE_PERIODS
1750: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1751: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1752: P_UNSPENT_AMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_UNSPENT_AMT_FLAG%TYPE,
1753: P_UNSPENT_AMT_PERIOD IN VARCHAR2,
1754: P_ACTUALS_FROM_PERIOD IN VARCHAR2,
1755: P_ACTUALS_TO_PERIOD IN VARCHAR2,

Line 1804: pa_fp_gen_amount_utils.fp_debug

1800:
1801: IF P_UNSPENT_AMT_FLAG = 'Y' AND P_UNSPENT_AMT_PERIOD IS NOT NULL THEN
1802: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(unspent date) api
1803: IF p_pa_debug_mode = 'Y' THEN
1804: pa_fp_gen_amount_utils.fp_debug
1805: (p_msg => 'Before calling
1806: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(unspent date)',
1807: p_module_name => l_module_name,
1808: p_log_level => 5);

Line 1820: pa_fp_gen_amount_utils.fp_debug

1816: X_MSG_COUNT => X_MSG_COUNT,
1817: X_MSG_DATA => X_MSG_DATA);
1818: l_return_status := X_RETURN_STATUS;
1819: IF p_pa_debug_mode = 'Y' THEN
1820: pa_fp_gen_amount_utils.fp_debug
1821: (p_msg => 'Status after calling
1822: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(unspent date): '
1823: ||x_return_status,
1824: p_module_name => l_module_name,

Line 1839: pa_fp_gen_amount_utils.fp_debug

1835:
1836: IF P_ACTUALS_FROM_PERIOD IS NOT NULL THEN
1837: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals from) api
1838: IF p_pa_debug_mode = 'Y' THEN
1839: pa_fp_gen_amount_utils.fp_debug
1840: (p_msg => 'Before calling
1841: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals from)',
1842: p_module_name => l_module_name,
1843: p_log_level => 5);

Line 1854: pa_fp_gen_amount_utils.fp_debug

1850: X_RETURN_STATUS => X_RETURN_STATUS,
1851: X_MSG_COUNT => X_MSG_COUNT,
1852: X_MSG_DATA => X_MSG_DATA);
1853: IF p_pa_debug_mode = 'Y' THEN
1854: pa_fp_gen_amount_utils.fp_debug
1855: (p_msg => 'Status after calling
1856: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals from): '
1857: ||x_return_status,
1858: p_module_name => l_module_name,

Line 1879: pa_fp_gen_amount_utils.fp_debug

1875:
1876: IF P_ACTUALS_TO_PERIOD IS NOT NULL THEN
1877: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals to) api
1878: IF p_pa_debug_mode = 'Y' THEN
1879: pa_fp_gen_amount_utils.fp_debug
1880: (p_msg => 'Before calling
1881: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals to)',
1882: p_module_name => l_module_name,
1883: p_log_level => 5);

Line 1894: pa_fp_gen_amount_utils.fp_debug

1890: X_RETURN_STATUS => X_RETURN_STATUS,
1891: X_MSG_COUNT => X_MSG_COUNT,
1892: X_MSG_DATA => X_MSG_DATA);
1893: IF p_pa_debug_mode = 'Y' THEN
1894: pa_fp_gen_amount_utils.fp_debug
1895: ( p_msg => 'Status after calling
1896: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals to): '
1897: ||x_return_status,
1898: p_module_name => l_module_name,

Line 1918: pa_fp_gen_amount_utils.fp_debug

1914: ELSE*/
1915: IF P_ETC_FROM_PERIOD IS NOT NULL THEN
1916: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc from) api
1917: IF p_pa_debug_mode = 'Y' THEN
1918: pa_fp_gen_amount_utils.fp_debug
1919: (p_msg => 'Before calling
1920: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc from)',
1921: p_module_name => l_module_name,
1922: p_log_level => 5);

Line 1933: pa_fp_gen_amount_utils.fp_debug

1929: X_RETURN_STATUS => X_RETURN_STATUS,
1930: X_MSG_COUNT => X_MSG_COUNT,
1931: X_MSG_DATA => X_MSG_DATA);
1932: IF p_pa_debug_mode = 'Y' THEN
1933: pa_fp_gen_amount_utils.fp_debug
1934: (p_msg => 'Status after calling
1935: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc from): '
1936: ||x_return_status,
1937: p_module_name => l_module_name,

Line 1958: pa_fp_gen_amount_utils.fp_debug

1954: ELSE */
1955: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc to) api
1956: IF P_ETC_TO_PERIOD IS NOT NULL THEN
1957: IF p_pa_debug_mode = 'Y' THEN
1958: pa_fp_gen_amount_utils.fp_debug
1959: (p_msg => 'Before calling
1960: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc to)',
1961: p_module_name => l_module_name,
1962: p_log_level => 5);

Line 1973: pa_fp_gen_amount_utils.fp_debug

1969: X_RETURN_STATUS => X_RETURN_STATUS,
1970: X_MSG_COUNT => X_MSG_COUNT,
1971: X_MSG_DATA => X_MSG_DATA);
1972: IF p_pa_debug_mode = 'Y' THEN
1973: pa_fp_gen_amount_utils.fp_debug
1974: (p_msg => 'Status after calling
1975: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc to): '
1976: ||x_return_status,
1977: p_module_name => l_module_name,

Line 2067: pa_fp_gen_amount_utils.fp_debug

2063: ROLLBACK;
2064:
2065: x_return_status := FND_API.G_RET_STS_ERROR;
2066: IF P_PA_DEBUG_MODE = 'Y' THEN
2067: pa_fp_gen_amount_utils.fp_debug
2068: (p_msg => 'Invalid Arguments Passed',
2069: p_module_name => l_module_name,
2070: p_log_level => 5);
2071: PA_DEBUG.Reset_Curr_Function;

Line 2082: pa_fp_gen_amount_utils.fp_debug

2078: FND_MSG_PUB.add_exc_msg
2079: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'
2080: ,p_procedure_name => 'VALIDATE_PERIODS');
2081: IF P_PA_DEBUG_MODE = 'Y' THEN
2082: pa_fp_gen_amount_utils.fp_debug
2083: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
2084: p_module_name => l_module_name,
2085: p_log_level => 5);
2086: PA_DEBUG.Reset_Curr_Function;

Line 2094: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

2090:
2091:
2092: PROCEDURE VALIDATE_PA_GL_PERIODS
2093: (P_PERIOD_NAME IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
2094: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
2095: P_CONTEXT IN VARCHAR2,
2096: P_ERROR_MSG_CODE IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE,
2097: X_END_DATE OUT NOCOPY DATE,
2098: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 2186: pa_fp_gen_amount_utils.fp_debug

2182: ROLLBACK;
2183:
2184: x_return_status := FND_API.G_RET_STS_ERROR;
2185: IF P_PA_DEBUG_MODE = 'Y' THEN
2186: pa_fp_gen_amount_utils.fp_debug
2187: (p_msg => 'Invalid periods',
2188: p_module_name => l_module_name,
2189: p_log_level => 5);
2190: PA_DEBUG.Reset_Curr_Function;

Line 2216: pa_fp_gen_amount_utils.fp_debug

2212: ROLLBACK;
2213:
2214: x_return_status := FND_API.G_RET_STS_ERROR;
2215: IF P_PA_DEBUG_MODE = 'Y' THEN
2216: pa_fp_gen_amount_utils.fp_debug
2217: (p_msg => 'Invalid Arguments Passed',
2218: p_module_name => l_module_name,
2219: p_log_level => 5);
2220: PA_DEBUG.Reset_Curr_Function;

Line 2231: pa_fp_gen_amount_utils.fp_debug

2227: FND_MSG_PUB.add_exc_msg
2228: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'
2229: ,p_procedure_name => 'VALIDATE_PA_GL_PERIODS');
2230: IF P_PA_DEBUG_MODE = 'Y' THEN
2231: pa_fp_gen_amount_utils.fp_debug
2232: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
2233: p_module_name => l_module_name,
2234: p_log_level => 5);
2235: PA_DEBUG.Reset_Curr_Function;

Line 2322: pa_fp_gen_amount_utils.fp_debug

2318: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2319: p_msg_name => 'PA_FP_INV_ETC_BV');
2320: END IF;
2321: IF P_PA_DEBUG_MODE = 'Y' THEN
2322: pa_fp_gen_amount_utils.fp_debug
2323: (p_msg => 'Invalid source',
2324: p_module_name => l_module_name,
2325: p_log_level => 5);
2326: PA_DEBUG.Reset_Curr_Function;

Line 2349: pa_fp_gen_amount_utils.fp_debug

2345: ROLLBACK;
2346:
2347: x_return_status := FND_API.G_RET_STS_ERROR;
2348: IF P_PA_DEBUG_MODE = 'Y' THEN
2349: pa_fp_gen_amount_utils.fp_debug
2350: (p_msg => 'Invalid Arguments Passed',
2351: p_module_name => l_module_name,
2352: p_log_level => 5);
2353: PA_DEBUG.Reset_Curr_Function;

Line 2364: pa_fp_gen_amount_utils.fp_debug

2360: FND_MSG_PUB.add_exc_msg
2361: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'
2362: ,p_procedure_name => 'VALIDATE_PLAN_TYPE_OR_VERSION');
2363: IF P_PA_DEBUG_MODE = 'Y' THEN
2364: pa_fp_gen_amount_utils.fp_debug
2365: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
2366: p_module_name => l_module_name,
2367: p_log_level => 5);
2368: PA_DEBUG.Reset_Curr_Function;