DBA Data[Home] [Help]

APPS.PJI_FM_CMT_EXTR dependencies on PJI_UTILS

Line 106: pji_utils.write2log('Enering accum_projperf_commit_txns');

102:
103: x_txn_accum_id :=0;
104: x_err_code :=0;
105:
106: pji_utils.write2log('Enering accum_projperf_commit_txns');
107: x_err_code :=0;
108: x_err_stage := 'Accumulating Commitment Txns';
109:
110: FOR cmtrec IN selcmts LOOP

Line 308: pji_utils.write2log('Leaving accum_projperf_commit_txns');

304: END IF;
305:
306: END LOOP;
307:
308: pji_utils.write2log('Leaving accum_projperf_commit_txns');
309: EXCEPTION
310: WHEN OTHERS THEN
311: x_err_code := SQLCODE;
312: pji_utils.write2log('within exception block of accum_projperf_commit_txns');

Line 312: pji_utils.write2log('within exception block of accum_projperf_commit_txns');

308: pji_utils.write2log('Leaving accum_projperf_commit_txns');
309: EXCEPTION
310: WHEN OTHERS THEN
311: x_err_code := SQLCODE;
312: pji_utils.write2log('within exception block of accum_projperf_commit_txns');
313: RAISE;
314:
315: END ACCUM_PROJPERF_COMMIT_TXNS;
316: */

Line 399: pji_utils.write2log('Enering accum_projperf_commitments');

395: l_PROJFUNC_COST_RATE_DATE DATE := NULL;
396: l_PROJFUNC_COST_EXCH_RATE NUMBER := NULL;
397:
398: BEGIN
399: pji_utils.write2log('Enering accum_projperf_commitments');
400: x_err_code :=0;
401: x_err_stage := 'Accumulating Commitments';
402:
403: row_processed :=0;

Line 535: pji_utils.write2log('Leaving accum_projperf_commitments');

531: END IF; -- UPDATE COMMITMENT ROW
532:
533: END LOOP; -- CMTREC Processing
534:
535: pji_utils.write2log('Leaving accum_projperf_commitments');
536: EXCEPTION
537: WHEN OTHERS THEN
538: x_err_code := SQLCODE;
539: pji_utils.write2log('within exception block of accum_projperf_commitments');

Line 539: pji_utils.write2log('within exception block of accum_projperf_commitments');

535: pji_utils.write2log('Leaving accum_projperf_commitments');
536: EXCEPTION
537: WHEN OTHERS THEN
538: x_err_code := SQLCODE;
539: pji_utils.write2log('within exception block of accum_projperf_commitments');
540: RAISE;
541:
542: END accum_projperf_commitments;
543:

Line 1041: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;

1037: commit;
1038: return;
1039: end if;
1040:
1041: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
1042:
1043: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
1044: 'PJI_FM_EXTR_DREVN',
1045: 'NORMAL',

Line 1094: pji_utils.write2log('Entering FIN_CMT_SUMMARY');

1090: commit;
1091: return;
1092: end if;
1093:
1094: pji_utils.write2log('Entering FIN_CMT_SUMMARY');
1095: l_transition_flag := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_FM_SUM_MAIN.g_process, 'TRANSITION');
1096:
1097: if (l_transition_flag = 'Y') then
1098: l_params_cost_flag := nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_FM_SUM_MAIN.g_process,'CONFIG_COST_FLAG'), 'N');

Line 1100: l_params_cost_flag := nvl(PJI_UTILS.GET_PARAMETER('CONFIG_COST_FLAG'), 'N');

1096:
1097: if (l_transition_flag = 'Y') then
1098: l_params_cost_flag := nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_FM_SUM_MAIN.g_process,'CONFIG_COST_FLAG'), 'N');
1099: else -- l_transition is null or 'N'
1100: l_params_cost_flag := nvl(PJI_UTILS.GET_PARAMETER('CONFIG_COST_FLAG'), 'N');
1101: end if;
1102:
1103: l_g2_currency_code := PJI_UTILS.GET_GLOBAL_SECONDARY_CURRENCY;
1104:

Line 1103: l_g2_currency_code := PJI_UTILS.GET_GLOBAL_SECONDARY_CURRENCY;

1099: else -- l_transition is null or 'N'
1100: l_params_cost_flag := nvl(PJI_UTILS.GET_PARAMETER('CONFIG_COST_FLAG'), 'N');
1101: end if;
1102:
1103: l_g2_currency_code := PJI_UTILS.GET_GLOBAL_SECONDARY_CURRENCY;
1104:
1105: if (l_g2_currency_code is not null) then
1106: l_g2_currency_code := 'Y';
1107: else

Line 1581: pji_utils.write2log('Leaving FIN_CMT_SUMMARY');

1577: PA_EXPENDITURE_TYPES et
1578: where
1579: tmp1.EXPENDITURE_TYPE = et.EXPENDITURE_TYPE;
1580:
1581: pji_utils.write2log('Leaving FIN_CMT_SUMMARY');
1582:
1583: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,
1584: 'PJI_FM_CMT_EXTR.FIN_CMT_SUMMARY(p_worker_id);');
1585: