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 287: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 302: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 376: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

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

Line 384: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

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

Line 405: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

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

Line 428: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

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

Line 449: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 466: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 489: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 504: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 518: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

514: -- Step 4: Handle Rollup of Amounts
515: ELSIF p_rollup_flag = 'Y' THEN
516:
517: IF p_pa_debug_mode = 'Y' THEN
518: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
519: P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.' ||
520: 'ROLLUP_AMOUNTS',
521: P_CALLED_MODE => p_called_mode,
522: 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 871: pa_fp_gen_amount_utils.fp_debug

867:
868: x_return_status := FND_API.G_RET_STS_ERROR;
869:
870: IF P_PA_DEBUG_MODE = 'Y' THEN
871: pa_fp_gen_amount_utils.fp_debug
872: ( p_msg => 'Invalid Arguments Passed',
873: p_called_mode => p_called_mode,
874: p_module_name => l_module_name,
875: p_log_level => l_log_level );

Line 891: pa_fp_gen_amount_utils.fp_debug

887: ( p_pkg_name => 'PA_RES_ASG_CURRENCY_PUB',
888: p_procedure_name => 'DELETE_TABLE_RECORDS',
889: p_error_text => substr(sqlerrm,1,240));
890: IF P_PA_DEBUG_MODE = 'Y' THEN
891: pa_fp_gen_amount_utils.fp_debug
892: ( p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
893: p_called_mode => p_called_mode,
894: p_module_name => l_module_name,
895: p_log_level => l_log_level);

Line 904: ( P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

900: END DELETE_TABLE_RECORDS;
901:
902:
903: PROCEDURE COPY_TABLE_RECORDS
904: ( P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
905: P_SRC_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
906: P_COPY_MODE IN VARCHAR2,
907: P_CALLING_MODULE IN VARCHAR2,
908: P_VERSION_LEVEL_FLAG IN VARCHAR2,

Line 1096: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

1092: FROM pa_budget_versions
1093: WHERE budget_version_id = p_fp_cols_rec.x_budget_version_id;
1094: EXCEPTION WHEN NO_DATA_FOUND THEN
1095: IF p_pa_debug_mode = 'Y' THEN
1096: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1097: ( P_MSG => 'Invalid p_fp_cols_rec.x_budget_version_id value: '
1098: || p_fp_cols_rec.x_budget_version_id
1099: || '. Budget version does not exist.',
1100: P_CALLED_MODE => p_called_mode,

Line 1169: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

1165:
1166: IF p_copy_mode = G_COPY_ALL THEN
1167: -- This case is currently NOT supported.
1168: IF p_pa_debug_mode = 'Y' THEN
1169: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1170: ( P_MSG => 'The '''||G_COPY_ALL||''' copy mode is not supported '
1171: || 'when p_version_level_flag is '
1172: || p_version_level_flag,
1173: P_CALLED_MODE => p_called_mode,

Line 1299: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

1295: l_ra_id_tab(i),
1296: l_txn_currency_code_tab(i) );
1297:
1298: IF p_pa_debug_mode = 'Y' THEN
1299: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1300: ( P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.'
1301: || 'DELETE_TABLE_RECORDS',
1302: P_CALLED_MODE => p_called_mode,
1303: P_MODULE_NAME => l_module_name,

Line 1315: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

1311: X_RETURN_STATUS => x_return_status,
1312: X_MSG_COUNT => x_msg_count,
1313: X_MSG_DATA => x_msg_data );
1314: IF p_pa_debug_mode = 'Y' THEN
1315: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1316: ( P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.'
1317: || 'DELETE_TABLE_RECORDS: ' || x_return_status,
1318: P_CALLED_MODE => p_called_mode,
1319: P_MODULE_NAME => l_module_name,

Line 1472: pa_fp_gen_amount_utils.fp_debug

1468:
1469: x_return_status := FND_API.G_RET_STS_ERROR;
1470:
1471: IF P_PA_DEBUG_MODE = 'Y' THEN
1472: pa_fp_gen_amount_utils.fp_debug
1473: ( p_msg => 'Invalid Arguments Passed',
1474: p_called_mode => p_called_mode,
1475: p_module_name => l_module_name,
1476: p_log_level => l_log_level );

Line 1492: pa_fp_gen_amount_utils.fp_debug

1488: ( p_pkg_name => 'PA_RES_ASG_CURRENCY_PUB',
1489: p_procedure_name => 'COPY_TABLE_RECORDS',
1490: p_error_text => substr(sqlerrm,1,240));
1491: IF P_PA_DEBUG_MODE = 'Y' THEN
1492: pa_fp_gen_amount_utils.fp_debug
1493: ( p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1494: p_called_mode => p_called_mode,
1495: p_module_name => l_module_name,
1496: p_log_level => l_log_level);

Line 1505: ( P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

1501: END COPY_TABLE_RECORDS;
1502:
1503:
1504: PROCEDURE INSERT_TABLE_RECORDS
1505: ( P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1506: P_CALLING_MODULE IN VARCHAR2,
1507: P_VERSION_LEVEL_FLAG IN VARCHAR2,
1508: P_CALLED_MODE IN VARCHAR2,
1509: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 1609: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

1605: -- Delete and then Insert the records specified by the temp table
1606: -- into the PA_RESOURCE_ASGN_CURR table.
1607:
1608: IF p_pa_debug_mode = 'Y' THEN
1609: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1610: ( P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.'
1611: || 'DELETE_TABLE_RECORDS',
1612: P_CALLED_MODE => p_called_mode,
1613: P_MODULE_NAME => l_module_name,

Line 1625: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

1621: X_RETURN_STATUS => x_return_status,
1622: X_MSG_COUNT => x_msg_count,
1623: X_MSG_DATA => x_msg_data );
1624: IF p_pa_debug_mode = 'Y' THEN
1625: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1626: ( P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.'
1627: || 'DELETE_TABLE_RECORDS: ' || x_return_status,
1628: P_CALLED_MODE => p_called_mode,
1629: P_MODULE_NAME => l_module_name,

Line 1697: pa_fp_gen_amount_utils.fp_debug

1693:
1694: x_return_status := FND_API.G_RET_STS_ERROR;
1695:
1696: IF P_PA_DEBUG_MODE = 'Y' THEN
1697: pa_fp_gen_amount_utils.fp_debug
1698: ( p_msg => 'Invalid Arguments Passed',
1699: p_called_mode => p_called_mode,
1700: p_module_name => l_module_name,
1701: p_log_level => l_log_level );

Line 1717: pa_fp_gen_amount_utils.fp_debug

1713: ( p_pkg_name => 'PA_RES_ASG_CURRENCY_PUB',
1714: p_procedure_name => 'INSERT_TABLE_RECORDS',
1715: p_error_text => substr(sqlerrm,1,240));
1716: IF P_PA_DEBUG_MODE = 'Y' THEN
1717: pa_fp_gen_amount_utils.fp_debug
1718: ( p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1719: p_called_mode => p_called_mode,
1720: p_module_name => l_module_name,
1721: p_log_level => l_log_level);

Line 1730: ( P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

1726: END INSERT_TABLE_RECORDS;
1727:
1728:
1729: PROCEDURE ROLLUP_AMOUNTS
1730: ( P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1731: P_CALLING_MODULE IN VARCHAR2,
1732: P_VERSION_LEVEL_FLAG IN VARCHAR2,
1733: P_CALLED_MODE IN VARCHAR2,
1734: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 2109: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

2105: FROM pa_budget_versions
2106: WHERE budget_version_id = p_fp_cols_rec.x_budget_version_id;
2107: EXCEPTION WHEN NO_DATA_FOUND THEN
2108: IF p_pa_debug_mode = 'Y' THEN
2109: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
2110: ( P_MSG => 'Invalid p_fp_cols_rec.x_budget_version_id value: '
2111: || p_fp_cols_rec.x_budget_version_id
2112: || '. Budget version does not exist.',
2113: P_CALLED_MODE => p_called_mode,

Line 2281: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

2277:
2278: -- Step 3: Delete records from the PA_RESOURCE_ASGN_CURR table.
2279:
2280: IF p_pa_debug_mode = 'Y' THEN
2281: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
2282: ( P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.'
2283: || 'DELETE_TABLE_RECORDS',
2284: P_CALLED_MODE => p_called_mode,
2285: P_MODULE_NAME => l_module_name,

Line 2297: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

2293: X_RETURN_STATUS => x_return_status,
2294: X_MSG_COUNT => x_msg_count,
2295: X_MSG_DATA => x_msg_data );
2296: IF p_pa_debug_mode = 'Y' THEN
2297: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
2298: ( P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.'
2299: || 'DELETE_TABLE_RECORDS: ' || x_return_status,
2300: P_CALLED_MODE => p_called_mode,
2301: P_MODULE_NAME => l_module_name,

Line 2497: pa_fp_gen_amount_utils.fp_debug

2493:
2494: x_return_status := FND_API.G_RET_STS_ERROR;
2495:
2496: IF P_PA_DEBUG_MODE = 'Y' THEN
2497: pa_fp_gen_amount_utils.fp_debug
2498: ( p_msg => 'Invalid Arguments Passed',
2499: p_called_mode => p_called_mode,
2500: p_module_name => l_module_name,
2501: p_log_level => l_log_level );

Line 2517: pa_fp_gen_amount_utils.fp_debug

2513: ( p_pkg_name => 'PA_RES_ASG_CURRENCY_PUB',
2514: p_procedure_name => 'ROLLUP_AMOUNTS',
2515: p_error_text => substr(sqlerrm,1,240));
2516: IF P_PA_DEBUG_MODE = 'Y' THEN
2517: pa_fp_gen_amount_utils.fp_debug
2518: ( p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
2519: p_called_mode => p_called_mode,
2520: p_module_name => l_module_name,
2521: p_log_level => l_log_level);