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

Line 70: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

66: -----------------------------------------------------------------------
67:
68: PROCEDURE PRINT_INPUT_PARAMS
69: ( P_CALLING_API IN VARCHAR2 DEFAULT NULL,
70: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
71: P_CALLING_MODULE IN VARCHAR2 DEFAULT NULL,
72: P_DELETE_FLAG IN VARCHAR2 DEFAULT NULL,
73: P_COPY_FLAG IN VARCHAR2 DEFAULT NULL,
74: P_SRC_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE DEFAULT NULL,

Line 81: ( P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

77: P_VERSION_LEVEL_FLAG IN VARCHAR2 DEFAULT NULL,
78: P_CALLED_MODE IN VARCHAR2 DEFAULT NULL );
79:
80: PROCEDURE DELETE_TABLE_RECORDS
81: ( P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
82: P_CALLING_MODULE IN VARCHAR2,
83: P_VERSION_LEVEL_FLAG IN VARCHAR2 DEFAULT 'N',
84: P_CALLED_MODE IN VARCHAR2 DEFAULT 'SELF_SERVICE',
85: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 90: ( P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

86: X_MSG_COUNT OUT NOCOPY NUMBER,
87: X_MSG_DATA OUT NOCOPY VARCHAR2);
88:
89: PROCEDURE COPY_TABLE_RECORDS
90: ( P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
91: P_SRC_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE DEFAULT NULL,
92: P_COPY_MODE IN VARCHAR2 DEFAULT 'COPY_OVERRIDES',
93: P_CALLING_MODULE IN VARCHAR2,
94: P_VERSION_LEVEL_FLAG IN VARCHAR2 DEFAULT 'N',

Line 101: ( P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

97: X_MSG_COUNT OUT NOCOPY NUMBER,
98: X_MSG_DATA OUT NOCOPY VARCHAR2);
99:
100: PROCEDURE INSERT_TABLE_RECORDS
101: ( P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
102: P_CALLING_MODULE IN VARCHAR2,
103: P_VERSION_LEVEL_FLAG IN VARCHAR2 DEFAULT 'N',
104: P_CALLED_MODE IN VARCHAR2 DEFAULT 'SELF_SERVICE',
105: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 110: ( P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

106: X_MSG_COUNT OUT NOCOPY NUMBER,
107: X_MSG_DATA OUT NOCOPY VARCHAR2);
108:
109: PROCEDURE ROLLUP_AMOUNTS
110: ( P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
111: P_CALLING_MODULE IN VARCHAR2,
112: P_VERSION_LEVEL_FLAG IN VARCHAR2 DEFAULT 'N',
113: P_CALLED_MODE IN VARCHAR2 DEFAULT 'SELF_SERVICE',
114: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 127: ( P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

123: --------- Public Procedures ------------
124: ----------------------------------------
125:
126: PROCEDURE MAINTAIN_DATA
127: ( P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
128: P_CALLING_MODULE IN VARCHAR2,
129: P_DELETE_FLAG IN VARCHAR2,
130: P_COPY_FLAG IN VARCHAR2,
131: P_SRC_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

Line 183: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

179: l_parameters_valid_flag := 'Y';
180:
181: IF p_fp_cols_rec.x_budget_version_id IS NULL THEN
182: IF p_pa_debug_mode = 'Y' THEN
183: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
184: ( P_MSG => 'P_fp_cols_rec.x_budget_version_id should not be null.',
185: P_CALLED_MODE => p_called_mode,
186: P_MODULE_NAME => l_module_name,
187: P_LOG_LEVEL => l_log_level );

Line 194: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

190: END IF; -- minimum p_fp_cols_rec validation
191:
192: IF NOT is_public_calling_module(p_calling_module) THEN
193: IF p_pa_debug_mode = 'Y' THEN
194: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
195: ( P_MSG => 'Invalid p_calling_module value: '
196: || p_calling_module,
197: P_CALLED_MODE => p_called_mode,
198: P_MODULE_NAME => l_module_name,

Line 206: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

202: END IF; -- p_calling_module validation
203:
204: IF NOT is_valid_flag(p_delete_flag) THEN
205: IF p_pa_debug_mode = 'Y' THEN
206: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
207: ( P_MSG => 'Invalid p_delete_flag value: '
208: || p_delete_flag,
209: P_CALLED_MODE => p_called_mode,
210: P_MODULE_NAME => l_module_name,

Line 218: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

214: END IF; -- p_delete_flag validation
215:
216: IF NOT is_valid_flag(p_copy_flag) THEN
217: IF p_pa_debug_mode = 'Y' THEN
218: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
219: ( P_MSG => 'Invalid p_copy_flag value: '
220: || p_copy_flag,
221: P_CALLED_MODE => p_called_mode,
222: P_MODULE_NAME => l_module_name,

Line 231: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

227:
228: IF p_copy_flag = 'Y' AND
229: p_src_version_id IS NULL THEN
230: IF p_pa_debug_mode = 'Y' THEN
231: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
232: ( P_MSG => 'Since p_copy_flag is Y, p_src_version_id cannot be Null',
233: P_CALLED_MODE => p_called_mode,
234: P_MODULE_NAME => l_module_name,
235: P_LOG_LEVEL => l_log_level );

Line 243: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

239:
240: IF p_copy_flag = 'Y' AND
241: NOT IS_VALID_COPY_MODE(p_copy_mode) THEN
242: IF p_pa_debug_mode = 'Y' THEN
243: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
244: ( P_MSG => 'Since p_copy_flag is Y, invalid p_copy_mode value: '
245: || p_copy_mode,
246: P_CALLED_MODE => p_called_mode,
247: P_MODULE_NAME => l_module_name,

Line 255: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

251: END IF; -- p_copy_flag validation
252:
253: IF NOT is_valid_flag(p_rollup_flag) THEN
254: IF p_pa_debug_mode = 'Y' THEN
255: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
256: ( P_MSG => 'Invalid p_rollup_flag value: '
257: || p_rollup_flag,
258: P_CALLED_MODE => p_called_mode,
259: P_MODULE_NAME => l_module_name,

Line 267: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

263: END IF; -- p_rollup_flag validation
264:
265: IF NOT is_valid_flag(p_version_level_flag) THEN
266: IF p_pa_debug_mode = 'Y' THEN
267: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
268: ( P_MSG => 'Invalid p_version_level_flag value: '
269: || p_version_level_flag,
270: P_CALLED_MODE => p_called_mode,
271: P_MODULE_NAME => l_module_name,

Line 288: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

284: -- Step 1: Handle Deletion
285: IF p_delete_flag = 'Y' THEN
286:
287: IF p_pa_debug_mode = 'Y' THEN
288: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
289: P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.' ||
290: 'DELETE_TABLE_RECORDS',
291: P_CALLED_MODE => p_called_mode,
292: P_MODULE_NAME => l_module_name);

Line 303: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

299: X_RETURN_STATUS => x_return_status,
300: X_MSG_COUNT => x_msg_count,
301: X_MSG_DATA => x_msg_data );
302: IF p_pa_debug_mode = 'Y' THEN
303: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
304: P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.' ||
305: 'DELETE_TABLE_RECORDS: '||x_return_status,
306: P_CALLED_MODE => p_called_mode,
307: P_MODULE_NAME => l_module_name);

Line 377: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

373:
374: -- Raise an error if duplicates are found.
375: IF l_ra_id_tab.count > 0 THEN
376: IF p_pa_debug_mode = 'Y' THEN
377: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
378: ( p_msg => 'Duplicate records found in '
379: || 'PA_RESOURCE_ASGN_CURR_TMP '
380: || '(count='||l_ra_id_tab.count||'):',
381: p_called_mode => p_called_mode,

Line 385: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

381: p_called_mode => p_called_mode,
382: p_module_name => l_module_name,
383: p_log_level => l_log_level );
384: FOR i IN 1..l_ra_id_tab.count LOOP
385: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
386: ( p_msg => 'Record'||i||': '
387: || 'resource_assignment_id:['||l_ra_id_tab(i)||'], '
388: || 'txn_currency_code:['||l_txn_currency_code_tab(i)||'], '
389: || 'number_of_duplicates:['||l_duplicate_count_tab(i)||'] ',

Line 406: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

402: WHERE resource_assignment_id IS NULL;
403:
404: IF l_null_record_count > 0 THEN
405: IF p_pa_debug_mode = 'Y' THEN
406: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
407: ( p_msg => 'Records with null resource_assignment_id found in '
408: || 'PA_RESOURCE_ASGN_CURR_TMP '
409: || '(count='||l_null_record_count||'):',
410: p_called_mode => p_called_mode,

Line 429: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

425: WHERE txn_currency_code IS NULL;
426:
427: IF l_null_record_count > 0 THEN
428: IF p_pa_debug_mode = 'Y' THEN
429: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
430: ( p_msg => 'Records with null txn_currency_code found in '
431: || 'PA_RESOURCE_ASGN_CURR_TMP '
432: || '(count='||l_null_record_count||'):',
433: p_called_mode => p_called_mode,

Line 450: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

446: -- Step 2: Handle Copy
447: IF p_copy_flag = 'Y' THEN
448:
449: IF p_pa_debug_mode = 'Y' THEN
450: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
451: P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.' ||
452: 'COPY_TABLE_RECORDS',
453: P_CALLED_MODE => p_called_mode,
454: P_MODULE_NAME => l_module_name);

Line 467: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

463: X_RETURN_STATUS => x_return_status,
464: X_MSG_COUNT => x_msg_count,
465: X_MSG_DATA => x_msg_data );
466: IF p_pa_debug_mode = 'Y' THEN
467: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
468: P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.' ||
469: 'COPY_TABLE_RECORDS: '||x_return_status,
470: P_CALLED_MODE => p_called_mode,
471: P_MODULE_NAME => l_module_name);

Line 490: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

486: -- Step 3: Handle Insertion
487: IF p_rollup_flag = 'N' THEN
488:
489: IF p_pa_debug_mode = 'Y' THEN
490: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
491: P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.' ||
492: 'INSERT_TABLE_RECORDS',
493: P_CALLED_MODE => p_called_mode,
494: P_MODULE_NAME => l_module_name);

Line 505: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

501: X_RETURN_STATUS => x_return_status,
502: X_MSG_COUNT => x_msg_count,
503: X_MSG_DATA => x_msg_data );
504: IF p_pa_debug_mode = 'Y' THEN
505: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
506: P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.' ||
507: 'INSERT_TABLE_RECORDS: '||x_return_status,
508: P_CALLED_MODE => p_called_mode,
509: P_MODULE_NAME => l_module_name);

Line 519: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

515: -- Step 4: Handle Rollup of Amounts
516: ELSIF p_rollup_flag = 'Y' THEN
517:
518: IF p_pa_debug_mode = 'Y' THEN
519: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
520: P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.' ||
521: 'ROLLUP_AMOUNTS',
522: P_CALLED_MODE => p_called_mode,
523: P_MODULE_NAME => l_module_name);

Line 534: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

530: X_RETURN_STATUS => x_return_status,
531: X_MSG_COUNT => x_msg_count,
532: X_MSG_DATA => x_msg_data );
533: IF p_pa_debug_mode = 'Y' THEN
534: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
535: P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.' ||
536: 'ROLLUP_AMOUNTS: '||x_return_status,
537: P_CALLED_MODE => p_called_mode,
538: P_MODULE_NAME => l_module_name);

Line 574: pa_fp_gen_amount_utils.fp_debug

570:
571: x_return_status := FND_API.G_RET_STS_ERROR;
572:
573: IF P_PA_DEBUG_MODE = 'Y' THEN
574: pa_fp_gen_amount_utils.fp_debug
575: ( p_msg => 'Invalid Arguments Passed',
576: p_called_mode => p_called_mode,
577: p_module_name => l_module_name,
578: p_log_level => l_log_level );

Line 595: pa_fp_gen_amount_utils.fp_debug

591: ( p_pkg_name => 'PA_RES_ASG_CURRENCY_PUB',
592: p_procedure_name => 'MAINTAIN_DATA',
593: p_error_text => substr(sqlerrm,1,240));
594: IF P_PA_DEBUG_MODE = 'Y' THEN
595: pa_fp_gen_amount_utils.fp_debug
596: ( p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
597: p_called_mode => p_called_mode,
598: p_module_name => l_module_name,
599: p_log_level => l_log_level);

Line 613: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

609: -----------------------------------------
610:
611: PROCEDURE PRINT_INPUT_PARAMS
612: ( P_CALLING_API IN VARCHAR2,
613: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
614: P_CALLING_MODULE IN VARCHAR2,
615: P_DELETE_FLAG IN VARCHAR2,
616: P_COPY_FLAG IN VARCHAR2,
617: P_SRC_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

Line 631: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

627: RETURN;
628: END IF; -- IF p_pa_debug_mode = 'N' THEN
629:
630: -- Print values of Input Parameters based on p_calling_module
631: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
632: ( p_msg => 'Input Parameters to '
633: || p_calling_api || '():',
634: p_called_mode => p_called_mode,
635: p_module_name => l_module_name,

Line 637: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

633: || p_calling_api || '():',
634: p_called_mode => p_called_mode,
635: p_module_name => l_module_name,
636: p_log_level => l_log_level );
637: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
638: ( p_msg => 'P_FP_COLS_REC.X_BUDGET_VERSION_ID:['
639: || P_FP_COLS_REC.X_BUDGET_VERSION_ID||']',
640: p_called_mode => p_called_mode,
641: p_module_name => l_module_name,

Line 643: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

639: || P_FP_COLS_REC.X_BUDGET_VERSION_ID||']',
640: p_called_mode => p_called_mode,
641: p_module_name => l_module_name,
642: p_log_level => l_log_level );
643: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
644: ( p_msg => 'P_FP_COLS_REC.X_VERSION_TYPE:['
645: || P_FP_COLS_REC.X_VERSION_TYPE||']',
646: p_called_mode => p_called_mode,
647: p_module_name => l_module_name,

Line 649: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

645: || P_FP_COLS_REC.X_VERSION_TYPE||']',
646: p_called_mode => p_called_mode,
647: p_module_name => l_module_name,
648: p_log_level => l_log_level );
649: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
650: ( p_msg => 'P_FP_COLS_REC.X_PLAN_CLASS_CODE:['
651: || P_FP_COLS_REC.X_PLAN_CLASS_CODE||']',
652: p_called_mode => p_called_mode,
653: p_module_name => l_module_name,

Line 655: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

651: || P_FP_COLS_REC.X_PLAN_CLASS_CODE||']',
652: p_called_mode => p_called_mode,
653: p_module_name => l_module_name,
654: p_log_level => l_log_level );
655: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
656: ( p_msg => 'P_CALLING_MODULE:['||P_CALLING_MODULE||']',
657: p_called_mode => p_called_mode,
658: p_module_name => l_module_name,
659: p_log_level => l_log_level );

Line 662: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

658: p_module_name => l_module_name,
659: p_log_level => l_log_level );
660:
661: IF p_calling_api = G_PVT_MAINTAIN THEN
662: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
663: ( p_msg => 'P_DELETE_FLAG:['||P_DELETE_FLAG||']',
664: p_called_mode => p_called_mode,
665: p_module_name => l_module_name,
666: p_log_level => l_log_level );

Line 667: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

663: ( p_msg => 'P_DELETE_FLAG:['||P_DELETE_FLAG||']',
664: p_called_mode => p_called_mode,
665: p_module_name => l_module_name,
666: p_log_level => l_log_level );
667: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
668: ( p_msg => 'P_COPY_FLAG:['||P_COPY_FLAG||']',
669: p_called_mode => p_called_mode,
670: p_module_name => l_module_name,
671: p_log_level => l_log_level );

Line 672: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

668: ( p_msg => 'P_COPY_FLAG:['||P_COPY_FLAG||']',
669: p_called_mode => p_called_mode,
670: p_module_name => l_module_name,
671: p_log_level => l_log_level );
672: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
673: ( p_msg => 'P_ROLLUP_FLAG:['||P_ROLLUP_FLAG||']',
674: p_called_mode => p_called_mode,
675: p_module_name => l_module_name,
676: p_log_level => l_log_level );

Line 680: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

676: p_log_level => l_log_level );
677: END IF; -- IF p_calling_api = G_PVT_MAINTAIN THEN
678:
679: IF p_calling_api IN ( G_PVT_MAINTAIN, G_PVT_COPY ) THEN
680: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
681: ( p_msg => 'P_SRC_VERSION_ID:['||P_SRC_VERSION_ID||']',
682: p_called_mode => p_called_mode,
683: p_module_name => l_module_name,
684: p_log_level => l_log_level );

Line 685: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

681: ( p_msg => 'P_SRC_VERSION_ID:['||P_SRC_VERSION_ID||']',
682: p_called_mode => p_called_mode,
683: p_module_name => l_module_name,
684: p_log_level => l_log_level );
685: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
686: ( p_msg => 'P_COPY_MODE:['||P_COPY_MODE||']',
687: p_called_mode => p_called_mode,
688: p_module_name => l_module_name,
689: p_log_level => l_log_level );

Line 692: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

688: p_module_name => l_module_name,
689: p_log_level => l_log_level );
690: END IF; --IF p_calling_api IN ( G_PVT_MAINTAIN, G_PVT_COPY ) THEN
691:
692: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
693: ( p_msg => 'P_VERSION_LEVEL_FLAG:['||P_VERSION_LEVEL_FLAG||']',
694: p_called_mode => p_called_mode,
695: p_module_name => l_module_name,
696: p_log_level => l_log_level );

Line 697: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

693: ( p_msg => 'P_VERSION_LEVEL_FLAG:['||P_VERSION_LEVEL_FLAG||']',
694: p_called_mode => p_called_mode,
695: p_module_name => l_module_name,
696: p_log_level => l_log_level );
697: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
698: ( p_msg => 'P_CALLED_MODE:['||P_CALLED_MODE||']',
699: p_called_mode => p_called_mode,
700: p_module_name => l_module_name,
701: p_log_level => l_log_level );

Line 731: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

727: l_dbg_delete_flag_tab
728: FROM pa_resource_asgn_curr_tmp
729: ORDER BY resource_assignment_id, txn_currency_code;
730:
731: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
732: ( p_msg => 'Printing PA_RESOURCE_ASGN_CURR_TMP table data '
733: || '(count='||l_dbg_ra_id_tab.count||'):',
734: p_called_mode => p_called_mode,
735: p_module_name => l_module_name,

Line 739: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

735: p_module_name => l_module_name,
736: p_log_level => l_log_level );
737:
738: FOR i IN 1..l_dbg_ra_id_tab.count LOOP
739: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
740: ( p_msg => 'Record'||i||': '
741: || 'resource_assignment_id:['||l_dbg_ra_id_tab(i)||'], '
742: || 'txn_currency_code:['||l_dbg_txn_currency_code_tab(i)||'], '
743: || 'txn_raw_cost_rate_override:['||l_dbg_rc_rate_override_tab(i)||'], '

Line 758: ( P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

754: END PRINT_INPUT_PARAMS;
755:
756:
757: PROCEDURE DELETE_TABLE_RECORDS
758: ( P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
759: P_CALLING_MODULE IN VARCHAR2,
760: P_VERSION_LEVEL_FLAG IN VARCHAR2,
761: P_CALLED_MODE IN VARCHAR2,
762: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 862: pa_fp_gen_amount_utils.fp_debug

858:
859: x_return_status := FND_API.G_RET_STS_ERROR;
860:
861: IF P_PA_DEBUG_MODE = 'Y' THEN
862: pa_fp_gen_amount_utils.fp_debug
863: ( p_msg => 'Invalid Arguments Passed',
864: p_called_mode => p_called_mode,
865: p_module_name => l_module_name,
866: p_log_level => l_log_level );

Line 882: pa_fp_gen_amount_utils.fp_debug

878: ( p_pkg_name => 'PA_RES_ASG_CURRENCY_PUB',
879: p_procedure_name => 'DELETE_TABLE_RECORDS',
880: p_error_text => substr(sqlerrm,1,240));
881: IF P_PA_DEBUG_MODE = 'Y' THEN
882: pa_fp_gen_amount_utils.fp_debug
883: ( p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
884: p_called_mode => p_called_mode,
885: p_module_name => l_module_name,
886: p_log_level => l_log_level);

Line 895: ( P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

891: END DELETE_TABLE_RECORDS;
892:
893:
894: PROCEDURE COPY_TABLE_RECORDS
895: ( P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
896: P_SRC_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
897: P_COPY_MODE IN VARCHAR2,
898: P_CALLING_MODULE IN VARCHAR2,
899: P_VERSION_LEVEL_FLAG IN VARCHAR2,

Line 1084: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

1080: FROM pa_budget_versions
1081: WHERE budget_version_id = p_fp_cols_rec.x_budget_version_id;
1082: EXCEPTION WHEN NO_DATA_FOUND THEN
1083: IF p_pa_debug_mode = 'Y' THEN
1084: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1085: ( P_MSG => 'Invalid p_fp_cols_rec.x_budget_version_id value: '
1086: || p_fp_cols_rec.x_budget_version_id
1087: || '. Budget version does not exist.',
1088: P_CALLED_MODE => p_called_mode,

Line 1157: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

1153:
1154: IF p_copy_mode = G_COPY_ALL THEN
1155: -- This case is currently NOT supported.
1156: IF p_pa_debug_mode = 'Y' THEN
1157: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1158: ( P_MSG => 'The '''||G_COPY_ALL||''' copy mode is not supported '
1159: || 'when p_version_level_flag is '
1160: || p_version_level_flag,
1161: P_CALLED_MODE => p_called_mode,

Line 1287: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

1283: l_ra_id_tab(i),
1284: l_txn_currency_code_tab(i) );
1285:
1286: IF p_pa_debug_mode = 'Y' THEN
1287: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1288: ( P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.'
1289: || 'DELETE_TABLE_RECORDS',
1290: P_CALLED_MODE => p_called_mode,
1291: P_MODULE_NAME => l_module_name,

Line 1303: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

1299: X_RETURN_STATUS => x_return_status,
1300: X_MSG_COUNT => x_msg_count,
1301: X_MSG_DATA => x_msg_data );
1302: IF p_pa_debug_mode = 'Y' THEN
1303: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1304: ( P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.'
1305: || 'DELETE_TABLE_RECORDS: ' || x_return_status,
1306: P_CALLED_MODE => p_called_mode,
1307: P_MODULE_NAME => l_module_name,

Line 1460: pa_fp_gen_amount_utils.fp_debug

1456:
1457: x_return_status := FND_API.G_RET_STS_ERROR;
1458:
1459: IF P_PA_DEBUG_MODE = 'Y' THEN
1460: pa_fp_gen_amount_utils.fp_debug
1461: ( p_msg => 'Invalid Arguments Passed',
1462: p_called_mode => p_called_mode,
1463: p_module_name => l_module_name,
1464: p_log_level => l_log_level );

Line 1480: pa_fp_gen_amount_utils.fp_debug

1476: ( p_pkg_name => 'PA_RES_ASG_CURRENCY_PUB',
1477: p_procedure_name => 'COPY_TABLE_RECORDS',
1478: p_error_text => substr(sqlerrm,1,240));
1479: IF P_PA_DEBUG_MODE = 'Y' THEN
1480: pa_fp_gen_amount_utils.fp_debug
1481: ( p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1482: p_called_mode => p_called_mode,
1483: p_module_name => l_module_name,
1484: p_log_level => l_log_level);

Line 1493: ( P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

1489: END COPY_TABLE_RECORDS;
1490:
1491:
1492: PROCEDURE INSERT_TABLE_RECORDS
1493: ( P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1494: P_CALLING_MODULE IN VARCHAR2,
1495: P_VERSION_LEVEL_FLAG IN VARCHAR2,
1496: P_CALLED_MODE IN VARCHAR2,
1497: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 1597: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

1593: -- Delete and then Insert the records specified by the temp table
1594: -- into the PA_RESOURCE_ASGN_CURR table.
1595:
1596: IF p_pa_debug_mode = 'Y' THEN
1597: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1598: ( P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.'
1599: || 'DELETE_TABLE_RECORDS',
1600: P_CALLED_MODE => p_called_mode,
1601: P_MODULE_NAME => l_module_name,

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 => 'After calling PA_RES_ASG_CURRENCY_PUB.'
1615: || 'DELETE_TABLE_RECORDS: ' || x_return_status,
1616: P_CALLED_MODE => p_called_mode,
1617: P_MODULE_NAME => l_module_name,

Line 1683: pa_fp_gen_amount_utils.fp_debug

1679:
1680: x_return_status := FND_API.G_RET_STS_ERROR;
1681:
1682: IF P_PA_DEBUG_MODE = 'Y' THEN
1683: pa_fp_gen_amount_utils.fp_debug
1684: ( p_msg => 'Invalid Arguments Passed',
1685: p_called_mode => p_called_mode,
1686: p_module_name => l_module_name,
1687: p_log_level => l_log_level );

Line 1703: pa_fp_gen_amount_utils.fp_debug

1699: ( p_pkg_name => 'PA_RES_ASG_CURRENCY_PUB',
1700: p_procedure_name => 'INSERT_TABLE_RECORDS',
1701: p_error_text => substr(sqlerrm,1,240));
1702: IF P_PA_DEBUG_MODE = 'Y' THEN
1703: pa_fp_gen_amount_utils.fp_debug
1704: ( p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1705: p_called_mode => p_called_mode,
1706: p_module_name => l_module_name,
1707: p_log_level => l_log_level);

Line 1716: ( P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

1712: END INSERT_TABLE_RECORDS;
1713:
1714:
1715: PROCEDURE ROLLUP_AMOUNTS
1716: ( P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1717: P_CALLING_MODULE IN VARCHAR2,
1718: P_VERSION_LEVEL_FLAG IN VARCHAR2,
1719: P_CALLED_MODE IN VARCHAR2,
1720: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 2084: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

2080: FROM pa_budget_versions
2081: WHERE budget_version_id = p_fp_cols_rec.x_budget_version_id;
2082: EXCEPTION WHEN NO_DATA_FOUND THEN
2083: IF p_pa_debug_mode = 'Y' THEN
2084: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
2085: ( P_MSG => 'Invalid p_fp_cols_rec.x_budget_version_id value: '
2086: || p_fp_cols_rec.x_budget_version_id
2087: || '. Budget version does not exist.',
2088: P_CALLED_MODE => p_called_mode,

Line 2254: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

2250:
2251: -- Step 3: Delete records from the PA_RESOURCE_ASGN_CURR table.
2252:
2253: IF p_pa_debug_mode = 'Y' THEN
2254: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
2255: ( P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.'
2256: || 'DELETE_TABLE_RECORDS',
2257: P_CALLED_MODE => p_called_mode,
2258: P_MODULE_NAME => l_module_name,

Line 2270: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

2266: X_RETURN_STATUS => x_return_status,
2267: X_MSG_COUNT => x_msg_count,
2268: X_MSG_DATA => x_msg_data );
2269: IF p_pa_debug_mode = 'Y' THEN
2270: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
2271: ( P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.'
2272: || 'DELETE_TABLE_RECORDS: ' || x_return_status,
2273: P_CALLED_MODE => p_called_mode,
2274: P_MODULE_NAME => l_module_name,

Line 2393: pa_fp_gen_amount_utils.fp_debug

2389:
2390: x_return_status := FND_API.G_RET_STS_ERROR;
2391:
2392: IF P_PA_DEBUG_MODE = 'Y' THEN
2393: pa_fp_gen_amount_utils.fp_debug
2394: ( p_msg => 'Invalid Arguments Passed',
2395: p_called_mode => p_called_mode,
2396: p_module_name => l_module_name,
2397: p_log_level => l_log_level );

Line 2413: pa_fp_gen_amount_utils.fp_debug

2409: ( p_pkg_name => 'PA_RES_ASG_CURRENCY_PUB',
2410: p_procedure_name => 'ROLLUP_AMOUNTS',
2411: p_error_text => substr(sqlerrm,1,240));
2412: IF P_PA_DEBUG_MODE = 'Y' THEN
2413: pa_fp_gen_amount_utils.fp_debug
2414: ( p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
2415: p_called_mode => p_called_mode,
2416: p_module_name => l_module_name,
2417: p_log_level => l_log_level);