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 292: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

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

Line 307: pa_fp_gen_amount_utils.fp_debug

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

Line 309: pa_fp_gen_amount_utils.get_plan_version_dtls',

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

Line 313: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

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

Line 323: pa_fp_gen_amount_utils.fp_debug

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

Line 325: pa_fp_gen_amount_utils.get_plan_version_dtls: '

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

Line 382: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

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

Line 399: pa_fp_gen_amount_utils.fp_debug

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

Line 401: pa_fp_gen_amount_utils.get_plan_version_dtls',

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

Line 405: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

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

Line 416: pa_fp_gen_amount_utils.fp_debug

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

Line 418: pa_fp_gen_amount_utils.get_plan_version_dtls: '

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

Line 499: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

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

Line 516: pa_fp_gen_amount_utils.fp_debug

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

Line 518: pa_fp_gen_amount_utils.get_plan_version_dtls',

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

Line 522: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

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

Line 533: pa_fp_gen_amount_utils.fp_debug

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

Line 535: pa_fp_gen_amount_utils.get_plan_version_dtls: '

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

Line 619: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

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

Line 635: pa_fp_gen_amount_utils.fp_debug

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

Line 637: pa_fp_gen_amount_utils.get_plan_version_dtls',

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

Line 641: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

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

Line 651: pa_fp_gen_amount_utils.fp_debug

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

Line 653: pa_fp_gen_amount_utils.get_plan_version_dtls: '

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

Line 784: pa_fp_gen_amount_utils.fp_debug

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

Line 799: pa_fp_gen_amount_utils.fp_debug

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

Line 843: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

839: X_MSG_COUNT OUT NOCOPY NUMBER,
840: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
841:
842: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.upd_ver_dtls_and_gen_amt';
843: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
844: l_PLAN_VERSION_ID PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE;
845: l_ETC_PLAN_VERSION_ID PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE;
846: l_return_status VARCHAR2(10);
847: l_msg_count NUMBER;

Line 902: pa_fp_gen_amount_utils.fp_debug

898: INTO l_record_version_number
899: FROM pa_budget_versions
900: WHERE budget_version_id = p_budget_version_id;
901: IF p_pa_debug_mode = 'Y' THEN
902: pa_fp_gen_amount_utils.fp_debug
903: (p_msg => 'Before calling pa_fin_plan_pvt.lock_unlock_version',
904: p_module_name => l_module_name);
905: END IF;
906: pa_fin_plan_pvt.lock_unlock_version

Line 916: pa_fp_gen_amount_utils.fp_debug

912: x_return_status => x_return_status,
913: x_msg_count => x_msg_count,
914: x_msg_data => x_msg_data);
915: IF p_pa_debug_mode = 'Y' THEN
916: pa_fp_gen_amount_utils.fp_debug
917: (p_msg => 'Status after calling pa_fin_plan_pvt.lock_unlock_version:'
918: ||x_return_status,
919: p_module_name => l_module_name);
920: END IF;

Line 936: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

932: will be available for other sessions. */
933:
934: --acquire lock for copy_actual
935: IF p_pa_debug_mode = 'Y' THEN
936: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
937: P_MSG => 'Before calling PA_FP_COPY_FROM_PKG.'
938: ||'ACQUIRE_LOCKS_FOR_COPY_ACTUAL',
939: P_MODULE_NAME => l_module_name);
940: END IF;

Line 957: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

953: RETURN;
954: END IF;
955:
956: IF p_pa_debug_mode = 'Y' THEN
957: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
958: P_MSG => 'After calling PA_FP_COPY_FROM_PKG.'
959: ||'ACQUIRE_LOCKS_FOR_COPY_ACTUAL: '
960: ||x_return_status,
961: P_MODULE_NAME => l_module_name);

Line 971: pa_fp_gen_amount_utils.fp_debug

967: l_ETC_PLAN_VERSION_ID := P_ETC_PLAN_VERSION_ID;
968:
969: --Calling the Util API
970: IF p_pa_debug_mode = 'Y' THEN
971: pa_fp_gen_amount_utils.fp_debug
972: (p_msg => 'Before calling
973: pa_fp_gen_amount_utils.get_plan_version_dtls(p_budget_version_id)',
974: p_module_name => l_module_name,
975: p_log_level => 5);

Line 973: pa_fp_gen_amount_utils.get_plan_version_dtls(p_budget_version_id)',

969: --Calling the Util API
970: IF p_pa_debug_mode = 'Y' THEN
971: pa_fp_gen_amount_utils.fp_debug
972: (p_msg => 'Before calling
973: pa_fp_gen_amount_utils.get_plan_version_dtls(p_budget_version_id)',
974: p_module_name => l_module_name,
975: p_log_level => 5);
976: END IF;
977: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

Line 977: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

973: pa_fp_gen_amount_utils.get_plan_version_dtls(p_budget_version_id)',
974: p_module_name => l_module_name,
975: p_log_level => 5);
976: END IF;
977: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS
978: (P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
979: X_FP_COLS_REC => l_fp_cols_rec,
980: X_RETURN_STATUS => X_RETURN_STATUS,
981: X_MSG_COUNT => X_MSG_COUNT,

Line 987: pa_fp_gen_amount_utils.fp_debug

983: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
984: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
985: END IF;
986: IF p_pa_debug_mode = 'Y' THEN
987: pa_fp_gen_amount_utils.fp_debug
988: (p_msg => 'Status after calling
989: pa_fp_gen_amount_utils.get_plan_version_dtls(p_budget_version_id): '
990: ||x_return_status,
991: p_module_name => l_module_name,

Line 989: pa_fp_gen_amount_utils.get_plan_version_dtls(p_budget_version_id): '

985: END IF;
986: IF p_pa_debug_mode = 'Y' THEN
987: pa_fp_gen_amount_utils.fp_debug
988: (p_msg => 'Status after calling
989: pa_fp_gen_amount_utils.get_plan_version_dtls(p_budget_version_id): '
990: ||x_return_status,
991: p_module_name => l_module_name,
992: p_log_level => 5);
993: END IF;

Line 1010: pa_fp_gen_amount_utils.fp_debug

1006: RESOURCE SCHEDULE. */
1007:
1008: IF L_FP_COLS_REC.X_GEN_ETC_SRC_CODE <> 'RESOURCE_SCHEDULE' THEN
1009: IF p_pa_debug_mode = 'Y' THEN
1010: pa_fp_gen_amount_utils.fp_debug
1011: (p_msg => 'Before calling
1012: pa_fp_gen_fcst_pg_pkg.validate_periods',
1013: p_module_name => l_module_name,
1014: p_log_level => 5);

Line 1033: pa_fp_gen_amount_utils.fp_debug

1029: l_return_status := X_RETURN_STATUS;
1030: --RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1031: END IF;
1032: IF p_pa_debug_mode = 'Y' THEN
1033: pa_fp_gen_amount_utils.fp_debug
1034: (p_msg => 'Status after calling
1035: pa_fp_gen_fcst_pg_pkg.validate_periods: '
1036: ||x_return_status,
1037: p_module_name => l_module_name,

Line 1047: pa_fp_gen_amount_utils.fp_debug

1043: IF P_ETC_PLAN_TYPE_ID IS NOT NULL AND
1044: P_ETC_PLAN_VERSION_NAME IS NOT NULL AND
1045: l_ETC_PLAN_VERSION_ID IS NULL THEN
1046: IF p_pa_debug_mode = 'Y' THEN
1047: pa_fp_gen_amount_utils.fp_debug
1048: (p_msg => 'Before calling
1049: pa_fp_gen_fcst_pg_pkg.validate_plan_type_or_version',
1050: p_module_name => l_module_name,
1051: p_log_level => 5);

Line 1067: pa_fp_gen_amount_utils.fp_debug

1063: l_return_status := X_RETURN_STATUS;
1064: --RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1065: END IF;
1066: IF p_pa_debug_mode = 'Y' THEN
1067: pa_fp_gen_amount_utils.fp_debug
1068: ( p_msg => 'Status after calling
1069: pa_fp_gen_fcst_pg_pkg.validate_plan_type_or_version for etc_generation_source: '
1070: ||x_return_status,
1071: p_module_name => l_module_name,

Line 1091: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

1087:
1088: -- IPM: New Entity ER ------------------------------------------
1089: -- Call the maintenance api in DELETE mode
1090: IF p_pa_debug_mode = 'Y' THEN
1091: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1092: ( P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.'
1093: || 'MAINTAIN_DATA',
1094: --P_CALLED_MODE => p_called_mode,
1095: P_MODULE_NAME => l_module_name,

Line 1108: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

1104: X_RETURN_STATUS => x_return_status,
1105: X_MSG_COUNT => x_msg_count,
1106: X_MSG_DATA => x_msg_data );
1107: IF p_pa_debug_mode = 'Y' THEN
1108: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1109: ( P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.'
1110: || 'MAINTAIN_DATA: ' || x_return_status,
1111: --P_CALLED_MODE => p_called_mode,
1112: P_MODULE_NAME => l_module_name,

Line 1164: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

1160: 'Y' );
1161:
1162: -- Call the maintenance api in DELETE mode
1163: IF p_pa_debug_mode = 'Y' THEN
1164: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1165: ( P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.'
1166: || 'MAINTAIN_DATA',
1167: --P_CALLED_MODE => p_called_mode,
1168: P_MODULE_NAME => l_module_name,

Line 1181: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

1177: X_RETURN_STATUS => x_return_status,
1178: X_MSG_COUNT => x_msg_count,
1179: X_MSG_DATA => x_msg_data );
1180: IF p_pa_debug_mode = 'Y' THEN
1181: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1182: ( P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.'
1183: || 'MAINTAIN_DATA: ' || x_return_status,
1184: --P_CALLED_MODE => p_called_mode,
1185: P_MODULE_NAME => l_module_name,

Line 1285: pa_fp_gen_amount_utils.fp_debug

1281: /* We need to get version details again after validation logic and
1282: * updates to the budget version so that we pass the most current
1283: * information to lower level APIs via the l_fp_cols_rec parameter. */
1284: IF p_pa_debug_mode = 'Y' THEN
1285: pa_fp_gen_amount_utils.fp_debug
1286: ( p_msg => 'Before calling
1287: pa_fp_gen_amount_utils.get_plan_version_dtls',
1288: p_module_name => l_module_name,
1289: p_log_level => 5 );

Line 1287: pa_fp_gen_amount_utils.get_plan_version_dtls',

1283: * information to lower level APIs via the l_fp_cols_rec parameter. */
1284: IF p_pa_debug_mode = 'Y' THEN
1285: pa_fp_gen_amount_utils.fp_debug
1286: ( p_msg => 'Before calling
1287: pa_fp_gen_amount_utils.get_plan_version_dtls',
1288: p_module_name => l_module_name,
1289: p_log_level => 5 );
1290: END IF;
1291: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

Line 1291: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

1287: pa_fp_gen_amount_utils.get_plan_version_dtls',
1288: p_module_name => l_module_name,
1289: p_log_level => 5 );
1290: END IF;
1291: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS
1292: ( P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
1293: X_FP_COLS_REC => l_fp_cols_rec,
1294: X_RETURN_STATUS => X_RETURN_STATUS,
1295: X_MSG_COUNT => X_MSG_COUNT,

Line 1302: pa_fp_gen_amount_utils.fp_debug

1298: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1299: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1300: END IF;
1301: IF p_pa_debug_mode = 'Y' THEN
1302: pa_fp_gen_amount_utils.fp_debug
1303: ( p_msg => 'Status after calling
1304: pa_fp_gen_amount_utils.get_plan_version_dtls: '
1305: ||x_return_status,
1306: p_module_name => l_module_name,

Line 1304: pa_fp_gen_amount_utils.get_plan_version_dtls: '

1300: END IF;
1301: IF p_pa_debug_mode = 'Y' THEN
1302: pa_fp_gen_amount_utils.fp_debug
1303: ( p_msg => 'Status after calling
1304: pa_fp_gen_amount_utils.get_plan_version_dtls: '
1305: ||x_return_status,
1306: p_module_name => l_module_name,
1307: p_log_level => 5 );
1308: END IF;

Line 1315: pa_fp_gen_amount_utils.fp_debug

1311: * For a list of unsupported cases, please see comments at the
1312: * beginning of the VALIDATE_SUPPORT_CASES API (PAFPGAUB.pls) */
1313:
1314: IF p_pa_debug_mode = 'Y' THEN
1315: pa_fp_gen_amount_utils.fp_debug
1316: ( p_msg => 'Before calling
1317: pa_fp_gen_amount_utils.validate_support_cases',
1318: p_module_name => l_module_name,
1319: p_log_level => 5 );

Line 1317: pa_fp_gen_amount_utils.validate_support_cases',

1313:
1314: IF p_pa_debug_mode = 'Y' THEN
1315: pa_fp_gen_amount_utils.fp_debug
1316: ( p_msg => 'Before calling
1317: pa_fp_gen_amount_utils.validate_support_cases',
1318: p_module_name => l_module_name,
1319: p_log_level => 5 );
1320: END IF;
1321: PA_FP_GEN_AMOUNT_UTILS.VALIDATE_SUPPORT_CASES (

Line 1321: PA_FP_GEN_AMOUNT_UTILS.VALIDATE_SUPPORT_CASES (

1317: pa_fp_gen_amount_utils.validate_support_cases',
1318: p_module_name => l_module_name,
1319: p_log_level => 5 );
1320: END IF;
1321: PA_FP_GEN_AMOUNT_UTILS.VALIDATE_SUPPORT_CASES (
1322: P_FP_COLS_REC_TGT => l_fp_cols_rec,
1323: P_CHECK_SRC_ERRORS_FLAG => P_CHECK_SRC_ERRORS_FLAG,
1324: X_WARNING_MESSAGE => X_WARNING_MESSAGE,
1325: X_RETURN_STATUS => X_RETURN_STATUS,

Line 1329: pa_fp_gen_amount_utils.fp_debug

1325: X_RETURN_STATUS => X_RETURN_STATUS,
1326: X_MSG_COUNT => X_MSG_COUNT,
1327: X_MSG_DATA => X_MSG_DATA );
1328: IF p_pa_debug_mode = 'Y' THEN
1329: pa_fp_gen_amount_utils.fp_debug
1330: ( p_msg => 'Status after calling
1331: pa_fp_gen_amount_utils.validate_support_cases: '
1332: ||x_return_status,
1333: p_module_name => l_module_name,

Line 1331: pa_fp_gen_amount_utils.validate_support_cases: '

1327: X_MSG_DATA => X_MSG_DATA );
1328: IF p_pa_debug_mode = 'Y' THEN
1329: pa_fp_gen_amount_utils.fp_debug
1330: ( p_msg => 'Status after calling
1331: pa_fp_gen_amount_utils.validate_support_cases: '
1332: ||x_return_status,
1333: p_module_name => l_module_name,
1334: p_log_level => 5 );
1335: END IF;

Line 1359: pa_fp_gen_amount_utils.fp_debug

1355: END IF;
1356:
1357: --Calling Gen FCST Amt Wrapper API
1358: IF p_pa_debug_mode = 'Y' THEN
1359: pa_fp_gen_amount_utils.fp_debug
1360: (p_msg => 'Before calling
1361: pa_fp_gen_fcst_amt_pub.generate_fcst_amt_wrp',
1362: p_module_name => l_module_name,
1363: p_log_level => 5);

Line 1397: pa_fp_gen_amount_utils.fp_debug

1393: l_return_status := X_RETURN_STATUS;
1394: --RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1395: END IF;
1396: IF p_pa_debug_mode = 'Y' THEN
1397: pa_fp_gen_amount_utils.fp_debug
1398: (p_msg => 'Status after calling
1399: pa_fp_gen_fcst_amt_pub.generate_fcst_amt_wrp: '
1400: ||x_return_status,
1401: p_module_name => l_module_name,

Line 1439: pa_fp_gen_amount_utils.fp_debug

1435:
1436: x_return_status := FND_API.G_RET_STS_ERROR;
1437:
1438: IF P_PA_DEBUG_MODE = 'Y' THEN
1439: pa_fp_gen_amount_utils.fp_debug
1440: (p_msg => 'Invalid Arguments Passed',
1441: p_module_name => l_module_name,
1442: p_log_level => 5);
1443: PA_DEBUG.Reset_Curr_Function;

Line 1457: pa_fp_gen_amount_utils.fp_debug

1453: FND_MSG_PUB.add_exc_msg
1454: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'
1455: ,p_procedure_name => 'UPD_VER_DTLS_AND_GEN_AMT');
1456: IF P_PA_DEBUG_MODE = 'Y' THEN
1457: pa_fp_gen_amount_utils.fp_debug
1458: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1459: p_module_name => l_module_name,
1460: p_log_level => 5);
1461: PA_DEBUG.Reset_Curr_Function;

Line 1470: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

1466:
1467:
1468: PROCEDURE VALIDATE_PERIODS
1469: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1470: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1471: P_UNSPENT_AMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_UNSPENT_AMT_FLAG%TYPE,
1472: P_UNSPENT_AMT_PERIOD IN VARCHAR2,
1473: P_ACTUALS_FROM_PERIOD IN VARCHAR2,
1474: P_ACTUALS_TO_PERIOD IN VARCHAR2,

Line 1523: pa_fp_gen_amount_utils.fp_debug

1519:
1520: IF P_UNSPENT_AMT_FLAG = 'Y' AND P_UNSPENT_AMT_PERIOD IS NOT NULL THEN
1521: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(unspent date) api
1522: IF p_pa_debug_mode = 'Y' THEN
1523: pa_fp_gen_amount_utils.fp_debug
1524: (p_msg => 'Before calling
1525: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(unspent date)',
1526: p_module_name => l_module_name,
1527: p_log_level => 5);

Line 1539: pa_fp_gen_amount_utils.fp_debug

1535: X_MSG_COUNT => X_MSG_COUNT,
1536: X_MSG_DATA => X_MSG_DATA);
1537: l_return_status := X_RETURN_STATUS;
1538: IF p_pa_debug_mode = 'Y' THEN
1539: pa_fp_gen_amount_utils.fp_debug
1540: (p_msg => 'Status after calling
1541: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(unspent date): '
1542: ||x_return_status,
1543: p_module_name => l_module_name,

Line 1558: pa_fp_gen_amount_utils.fp_debug

1554:
1555: IF P_ACTUALS_FROM_PERIOD IS NOT NULL THEN
1556: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals from) api
1557: IF p_pa_debug_mode = 'Y' THEN
1558: pa_fp_gen_amount_utils.fp_debug
1559: (p_msg => 'Before calling
1560: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals from)',
1561: p_module_name => l_module_name,
1562: p_log_level => 5);

Line 1573: pa_fp_gen_amount_utils.fp_debug

1569: X_RETURN_STATUS => X_RETURN_STATUS,
1570: X_MSG_COUNT => X_MSG_COUNT,
1571: X_MSG_DATA => X_MSG_DATA);
1572: IF p_pa_debug_mode = 'Y' THEN
1573: pa_fp_gen_amount_utils.fp_debug
1574: (p_msg => 'Status after calling
1575: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals from): '
1576: ||x_return_status,
1577: p_module_name => l_module_name,

Line 1598: pa_fp_gen_amount_utils.fp_debug

1594:
1595: IF P_ACTUALS_TO_PERIOD IS NOT NULL THEN
1596: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals to) api
1597: IF p_pa_debug_mode = 'Y' THEN
1598: pa_fp_gen_amount_utils.fp_debug
1599: (p_msg => 'Before calling
1600: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals to)',
1601: p_module_name => l_module_name,
1602: p_log_level => 5);

Line 1613: pa_fp_gen_amount_utils.fp_debug

1609: X_RETURN_STATUS => X_RETURN_STATUS,
1610: X_MSG_COUNT => X_MSG_COUNT,
1611: X_MSG_DATA => X_MSG_DATA);
1612: IF p_pa_debug_mode = 'Y' THEN
1613: pa_fp_gen_amount_utils.fp_debug
1614: ( p_msg => 'Status after calling
1615: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals to): '
1616: ||x_return_status,
1617: p_module_name => l_module_name,

Line 1637: pa_fp_gen_amount_utils.fp_debug

1633: ELSE*/
1634: IF P_ETC_FROM_PERIOD IS NOT NULL THEN
1635: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc from) api
1636: IF p_pa_debug_mode = 'Y' THEN
1637: pa_fp_gen_amount_utils.fp_debug
1638: (p_msg => 'Before calling
1639: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc from)',
1640: p_module_name => l_module_name,
1641: p_log_level => 5);

Line 1652: pa_fp_gen_amount_utils.fp_debug

1648: X_RETURN_STATUS => X_RETURN_STATUS,
1649: X_MSG_COUNT => X_MSG_COUNT,
1650: X_MSG_DATA => X_MSG_DATA);
1651: IF p_pa_debug_mode = 'Y' THEN
1652: pa_fp_gen_amount_utils.fp_debug
1653: (p_msg => 'Status after calling
1654: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc from): '
1655: ||x_return_status,
1656: p_module_name => l_module_name,

Line 1677: pa_fp_gen_amount_utils.fp_debug

1673: ELSE */
1674: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc to) api
1675: IF P_ETC_TO_PERIOD IS NOT NULL THEN
1676: IF p_pa_debug_mode = 'Y' THEN
1677: pa_fp_gen_amount_utils.fp_debug
1678: (p_msg => 'Before calling
1679: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc to)',
1680: p_module_name => l_module_name,
1681: p_log_level => 5);

Line 1692: pa_fp_gen_amount_utils.fp_debug

1688: X_RETURN_STATUS => X_RETURN_STATUS,
1689: X_MSG_COUNT => X_MSG_COUNT,
1690: X_MSG_DATA => X_MSG_DATA);
1691: IF p_pa_debug_mode = 'Y' THEN
1692: pa_fp_gen_amount_utils.fp_debug
1693: (p_msg => 'Status after calling
1694: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc to): '
1695: ||x_return_status,
1696: p_module_name => l_module_name,

Line 1786: pa_fp_gen_amount_utils.fp_debug

1782: ROLLBACK;
1783:
1784: x_return_status := FND_API.G_RET_STS_ERROR;
1785: IF P_PA_DEBUG_MODE = 'Y' THEN
1786: pa_fp_gen_amount_utils.fp_debug
1787: (p_msg => 'Invalid Arguments Passed',
1788: p_module_name => l_module_name,
1789: p_log_level => 5);
1790: PA_DEBUG.Reset_Curr_Function;

Line 1801: pa_fp_gen_amount_utils.fp_debug

1797: FND_MSG_PUB.add_exc_msg
1798: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'
1799: ,p_procedure_name => 'VALIDATE_PERIODS');
1800: IF P_PA_DEBUG_MODE = 'Y' THEN
1801: pa_fp_gen_amount_utils.fp_debug
1802: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1803: p_module_name => l_module_name,
1804: p_log_level => 5);
1805: PA_DEBUG.Reset_Curr_Function;

Line 1813: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

1809:
1810:
1811: PROCEDURE VALIDATE_PA_GL_PERIODS
1812: (P_PERIOD_NAME IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1813: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1814: P_CONTEXT IN VARCHAR2,
1815: P_ERROR_MSG_CODE IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE,
1816: X_END_DATE OUT NOCOPY DATE,
1817: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 1905: pa_fp_gen_amount_utils.fp_debug

1901: ROLLBACK;
1902:
1903: x_return_status := FND_API.G_RET_STS_ERROR;
1904: IF P_PA_DEBUG_MODE = 'Y' THEN
1905: pa_fp_gen_amount_utils.fp_debug
1906: (p_msg => 'Invalid periods',
1907: p_module_name => l_module_name,
1908: p_log_level => 5);
1909: PA_DEBUG.Reset_Curr_Function;

Line 1935: pa_fp_gen_amount_utils.fp_debug

1931: ROLLBACK;
1932:
1933: x_return_status := FND_API.G_RET_STS_ERROR;
1934: IF P_PA_DEBUG_MODE = 'Y' THEN
1935: pa_fp_gen_amount_utils.fp_debug
1936: (p_msg => 'Invalid Arguments Passed',
1937: p_module_name => l_module_name,
1938: p_log_level => 5);
1939: PA_DEBUG.Reset_Curr_Function;

Line 1950: pa_fp_gen_amount_utils.fp_debug

1946: FND_MSG_PUB.add_exc_msg
1947: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'
1948: ,p_procedure_name => 'VALIDATE_PA_GL_PERIODS');
1949: IF P_PA_DEBUG_MODE = 'Y' THEN
1950: pa_fp_gen_amount_utils.fp_debug
1951: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1952: p_module_name => l_module_name,
1953: p_log_level => 5);
1954: PA_DEBUG.Reset_Curr_Function;

Line 2041: pa_fp_gen_amount_utils.fp_debug

2037: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2038: p_msg_name => 'PA_FP_INV_ETC_BV');
2039: END IF;
2040: IF P_PA_DEBUG_MODE = 'Y' THEN
2041: pa_fp_gen_amount_utils.fp_debug
2042: (p_msg => 'Invalid source',
2043: p_module_name => l_module_name,
2044: p_log_level => 5);
2045: PA_DEBUG.Reset_Curr_Function;

Line 2068: pa_fp_gen_amount_utils.fp_debug

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

Line 2083: pa_fp_gen_amount_utils.fp_debug

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