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.FII_AP_INV_B_C dependencies on FII_UTIL

Line 62: g_apps_schema_name VARCHAR2(50) := NVL(FII_UTIL.get_apps_schema_name, 'APPS');

58: g_usage_code CONSTANT VARCHAR2(10) := 'DBI'; --CHAR will fail join
59: g_table_name VARCHAR2(50) := 'FII_AP_INV_B';
60: g_ind_exp_classes VARCHAR2(1000);
61: g_xla_ret_code VARCHAR2(1) := NULL;
62: g_apps_schema_name VARCHAR2(50) := NVL(FII_UTIL.get_apps_schema_name, 'APPS');
63:
64: -- ---------------------------------------------------------------
65: -- PROCEDURE CHECK_XLA_CONVERSION_STATUS
66: --Bug 5437394

Line 90: FII_UTIL.put_line('Calling procedure: CHECK_XLA_CONVERSION_STATUS');

86:
87: BEGIN
88:
89: if g_debug_flag = 'Y' then
90: FII_UTIL.put_line('Calling procedure: CHECK_XLA_CONVERSION_STATUS');
91: FII_UTIL.put_line('');
92: end if;
93:
94: FOR ledger_record in c_non_upgraded_ledgers LOOP

Line 91: FII_UTIL.put_line('');

87: BEGIN
88:
89: if g_debug_flag = 'Y' then
90: FII_UTIL.put_line('Calling procedure: CHECK_XLA_CONVERSION_STATUS');
91: FII_UTIL.put_line('');
92: end if;
93:
94: FOR ledger_record in c_non_upgraded_ledgers LOOP
95: g_xla_ret_code := 'W';

Line 111: FII_UTIL.put_line('

107:
108: EXCEPTION
109: WHEN OTHERS THEN
110: g_retcode := -1;
111: FII_UTIL.put_line('
112: ---------------------------------
113: Error in Procedure: CHECK_XLA_CONVERSION_STATUS
114: Phase: '||g_phase||'
115: Message: '||sqlerrm);

Line 132: FII_UTIL.put_line('g_fii_schema '||g_fii_schema);

128: l_stmt VARCHAR2(100);
129: BEGIN
130: l_stmt := 'TRUNCATE table '||g_fii_schema||'.'||p_table_name;
131: if g_debug_flag = 'Y' then
132: FII_UTIL.put_line('g_fii_schema '||g_fii_schema);
133: FII_UTIL.put_line('');
134: FII_UTIL.put_line(l_stmt);
135: end if;
136: EXECUTE IMMEDIATE l_stmt;

Line 133: FII_UTIL.put_line('');

129: BEGIN
130: l_stmt := 'TRUNCATE table '||g_fii_schema||'.'||p_table_name;
131: if g_debug_flag = 'Y' then
132: FII_UTIL.put_line('g_fii_schema '||g_fii_schema);
133: FII_UTIL.put_line('');
134: FII_UTIL.put_line(l_stmt);
135: end if;
136: EXECUTE IMMEDIATE l_stmt;
137:

Line 134: FII_UTIL.put_line(l_stmt);

130: l_stmt := 'TRUNCATE table '||g_fii_schema||'.'||p_table_name;
131: if g_debug_flag = 'Y' then
132: FII_UTIL.put_line('g_fii_schema '||g_fii_schema);
133: FII_UTIL.put_line('');
134: FII_UTIL.put_line(l_stmt);
135: end if;
136: EXECUTE IMMEDIATE l_stmt;
137:
138: EXCEPTION

Line 154: FII_UTIL.put_line('');

150: l_stmt varchar2(400);
151: BEGIN
152: l_stmt:='DROP table '||g_fii_schema||'.'||p_table_name;
153: if g_debug_flag = 'Y' then
154: FII_UTIL.put_line('');
155: FII_UTIL.put_line(l_stmt);
156: end if;
157: EXECUTE IMMEDIATE l_stmt;
158:

Line 155: FII_UTIL.put_line(l_stmt);

151: BEGIN
152: l_stmt:='DROP table '||g_fii_schema||'.'||p_table_name;
153: if g_debug_flag = 'Y' then
154: FII_UTIL.put_line('');
155: FII_UTIL.put_line(l_stmt);
156: end if;
157: EXECUTE IMMEDIATE l_stmt;
158:
159: EXCEPTION

Line 177: FII_UTIL.put_line('Calling procedure CLEAN_UP');

173: BEGIN
174: g_state := 'Inside the procedure CLEAN_UP';
175:
176: if g_debug_flag = 'Y' then
177: FII_UTIL.put_line('Calling procedure CLEAN_UP');
178: FII_UTIL.put_line('');
179:
180: FII_UTIL.put_line('Truncate table FII_AP_SUM_WORK_JOBS');
181: end if;

Line 178: FII_UTIL.put_line('');

174: g_state := 'Inside the procedure CLEAN_UP';
175:
176: if g_debug_flag = 'Y' then
177: FII_UTIL.put_line('Calling procedure CLEAN_UP');
178: FII_UTIL.put_line('');
179:
180: FII_UTIL.put_line('Truncate table FII_AP_SUM_WORK_JOBS');
181: end if;
182: truncate_table('FII_AP_SUM_WORK_JOBS');

Line 180: FII_UTIL.put_line('Truncate table FII_AP_SUM_WORK_JOBS');

176: if g_debug_flag = 'Y' then
177: FII_UTIL.put_line('Calling procedure CLEAN_UP');
178: FII_UTIL.put_line('');
179:
180: FII_UTIL.put_line('Truncate table FII_AP_SUM_WORK_JOBS');
181: end if;
182: truncate_table('FII_AP_SUM_WORK_JOBS');
183:
184: IF (g_truncate_id = 'Y') THEN

Line 186: FII_UTIL.put_line('Truncate table FII_AP_Unpost_Headers_T');

182: truncate_table('FII_AP_SUM_WORK_JOBS');
183:
184: IF (g_truncate_id = 'Y') THEN
185: if g_debug_flag = 'Y' then
186: FII_UTIL.put_line('Truncate table FII_AP_Unpost_Headers_T');
187: end if;
188: truncate_table('FII_AP_Unpost_Headers_T');
189: END IF;
190:

Line 193: FII_UTIL.put_line('Truncate table FII_AP_INV_STG');

189: END IF;
190:
191: IF (g_truncate_staging = 'Y') THEN
192: if g_debug_flag = 'Y' then
193: FII_UTIL.put_line('Truncate table FII_AP_INV_STG');
194: end if;
195: truncate_table('FII_AP_INV_STG');
196: END IF;
197:

Line 201: FII_UTIL.put_line('Truncate table FII_AP_INV_RATES_TEMP');

197:
198: -- haritha
199: IF (g_truncate_rates = 'Y') THEN
200: if g_debug_flag = 'Y' then
201: FII_UTIL.put_line('Truncate table FII_AP_INV_RATES_TEMP');
202: end if;
203: truncate_table('FII_AP_INV_RATES_TEMP');
204: END IF;
205:

Line 230: FII_UTIL.put_line('');

226:
227: BEGIN
228: g_state := 'Check if Source Ledger Group set up has changed';
229: if g_debug_flag = 'Y' then
230: FII_UTIL.put_line('');
231: FII_UTIL.put_line( 'Check if Source Ledger Group set up has changed');
232: end if;
233:
234: SELECT DECODE(item_value, 'Y', 'TRUE', 'FALSE')

Line 231: FII_UTIL.put_line( 'Check if Source Ledger Group set up has changed');

227: BEGIN
228: g_state := 'Check if Source Ledger Group set up has changed';
229: if g_debug_flag = 'Y' then
230: FII_UTIL.put_line('');
231: FII_UTIL.put_line( 'Check if Source Ledger Group set up has changed');
232: end if;
233:
234: SELECT DECODE(item_value, 'Y', 'TRUE', 'FALSE')
235: INTO l_result

Line 303: FII_UTIL.put_line('');

299: --------------------------------------------------------------------------------
300:
301: g_state := 'Inserting records into FII_AP_UNPOST_HEADERS_T table';
302: IF g_debug_flag = 'Y' then
303: FII_UTIL.put_line('');
304: FII_UTIL.put_line(g_state);
305: fii_util.start_timer;
306: fii_util.put_line('');
307: END IF;

Line 304: FII_UTIL.put_line(g_state);

300:
301: g_state := 'Inserting records into FII_AP_UNPOST_HEADERS_T table';
302: IF g_debug_flag = 'Y' then
303: FII_UTIL.put_line('');
304: FII_UTIL.put_line(g_state);
305: fii_util.start_timer;
306: fii_util.put_line('');
307: END IF;
308:

Line 305: fii_util.start_timer;

301: g_state := 'Inserting records into FII_AP_UNPOST_HEADERS_T table';
302: IF g_debug_flag = 'Y' then
303: FII_UTIL.put_line('');
304: FII_UTIL.put_line(g_state);
305: fii_util.start_timer;
306: fii_util.put_line('');
307: END IF;
308:
309: INSERT INTO FII_AP_UNPOST_HEADERS_T (

Line 306: fii_util.put_line('');

302: IF g_debug_flag = 'Y' then
303: FII_UTIL.put_line('');
304: FII_UTIL.put_line(g_state);
305: fii_util.start_timer;
306: fii_util.put_line('');
307: END IF;
308:
309: INSERT INTO FII_AP_UNPOST_HEADERS_T (
310: AE_HEADER_ID,

Line 336: FII_UTIL.stop_timer;

332:
333: l_count := SQL%ROWCOUNT;
334:
335: IF g_debug_flag = 'Y' then
336: FII_UTIL.stop_timer;
337: FII_UTIL.put_line('Inserted ' || SQL%ROWCOUNT||' records in FII_AP_UNPOST_HEADERS_T');
338: FII_UTIL.print_timer('Duration');
339: END IF;
340:

Line 337: FII_UTIL.put_line('Inserted ' || SQL%ROWCOUNT||' records in FII_AP_UNPOST_HEADERS_T');

333: l_count := SQL%ROWCOUNT;
334:
335: IF g_debug_flag = 'Y' then
336: FII_UTIL.stop_timer;
337: FII_UTIL.put_line('Inserted ' || SQL%ROWCOUNT||' records in FII_AP_UNPOST_HEADERS_T');
338: FII_UTIL.print_timer('Duration');
339: END IF;
340:
341: RETURN l_count;

Line 338: FII_UTIL.print_timer('Duration');

334:
335: IF g_debug_flag = 'Y' then
336: FII_UTIL.stop_timer;
337: FII_UTIL.put_line('Inserted ' || SQL%ROWCOUNT||' records in FII_AP_UNPOST_HEADERS_T');
338: FII_UTIL.print_timer('Duration');
339: END IF;
340:
341: RETURN l_count;
342: EXCEPTION

Line 347: FII_UTIL.put_line('Error occured while ' || g_state);

343: WHEN OTHERS THEN
344: g_errbuf:=sqlerrm;
345: g_retcode:= -1;
346: g_exception_msg := g_retcode || ':' || g_errbuf;
347: FII_UTIL.put_line('Error occured while ' || g_state);
348: FII_UTIL.put_line(g_exception_msg);
349: RAISE;
350: END POPULATE_INV_ID_TEMP;
351:

Line 348: FII_UTIL.put_line(g_exception_msg);

344: g_errbuf:=sqlerrm;
345: g_retcode:= -1;
346: g_exception_msg := g_retcode || ':' || g_errbuf;
347: FII_UTIL.put_line('Error occured while ' || g_state);
348: FII_UTIL.put_line(g_exception_msg);
349: RAISE;
350: END POPULATE_INV_ID_TEMP;
351:
352: -----------------------------------------------------------

Line 365: FII_UTIL.put_line(g_state);

361: IF p_phase = 1 THEN
362:
363: g_state := 'Populating FII_AP_Inv_STG with updated data using the FII_AP_Unpost_Headers_T table';
364: if g_debug_flag = 'Y' then
365: FII_UTIL.put_line(g_state);
366: FII_UTIL.start_timer;
367: end if;
368:
369: INSERT INTO FII_AP_INV_STG (

Line 366: FII_UTIL.start_timer;

362:
363: g_state := 'Populating FII_AP_Inv_STG with updated data using the FII_AP_Unpost_Headers_T table';
364: if g_debug_flag = 'Y' then
365: FII_UTIL.put_line(g_state);
366: FII_UTIL.start_timer;
367: end if;
368:
369: INSERT INTO FII_AP_INV_STG (
370: AE_HEADER_ID,

Line 395: FII_UTIL.put_line('Inserted '||sql%rowcount||' rows INTO FII_AP_INV_STG table');

391: AND ID.sequence_id >= p_start_range
392: AND ID.sequence_id <= p_end_range;
393:
394: if g_debug_flag = 'Y' then
395: FII_UTIL.put_line('Inserted '||sql%rowcount||' rows INTO FII_AP_INV_STG table');
396: FII_UTIL.stop_timer;
397: FII_UTIL.print_timer('Duration');
398: end if;
399:

Line 396: FII_UTIL.stop_timer;

392: AND ID.sequence_id <= p_end_range;
393:
394: if g_debug_flag = 'Y' then
395: FII_UTIL.put_line('Inserted '||sql%rowcount||' rows INTO FII_AP_INV_STG table');
396: FII_UTIL.stop_timer;
397: FII_UTIL.print_timer('Duration');
398: end if;
399:
400:

Line 397: FII_UTIL.print_timer('Duration');

393:
394: if g_debug_flag = 'Y' then
395: FII_UTIL.put_line('Inserted '||sql%rowcount||' rows INTO FII_AP_INV_STG table');
396: FII_UTIL.stop_timer;
397: FII_UTIL.print_timer('Duration');
398: end if;
399:
400:
401: ELSE --This is a Phase 2 job.

Line 405: FII_UTIL.put_line(g_state);

401: ELSE --This is a Phase 2 job.
402:
403: g_state := 'Populating FII_AP_Inv_STG with new data using the header identifier. Header range is from ' || p_start_range || ' to ' || p_end_range || '.';
404: if g_debug_flag = 'Y' then
405: FII_UTIL.put_line(g_state);
406: FII_UTIL.start_timer;
407: end if;
408:
409: INSERT INTO FII_AP_INV_STG

Line 406: FII_UTIL.start_timer;

402:
403: g_state := 'Populating FII_AP_Inv_STG with new data using the header identifier. Header range is from ' || p_start_range || ' to ' || p_end_range || '.';
404: if g_debug_flag = 'Y' then
405: FII_UTIL.put_line(g_state);
406: FII_UTIL.start_timer;
407: end if;
408:
409: INSERT INTO FII_AP_INV_STG
410: (LEDGER_ID,

Line 600: FII_UTIL.put_line('Inserted '||sql%rowcount||' rows INTO FII_AP_INV_STG table');

596: AND xah.accounting_date >= g_start_date
597: AND ail.accounting_date >= g_start_date;
598:
599: if g_debug_flag = 'Y' then
600: FII_UTIL.put_line('Inserted '||sql%rowcount||' rows INTO FII_AP_INV_STG table');
601: FII_UTIL.stop_timer;
602: FII_UTIL.print_timer('Duration');
603: end if;
604:

Line 601: FII_UTIL.stop_timer;

597: AND ail.accounting_date >= g_start_date;
598:
599: if g_debug_flag = 'Y' then
600: FII_UTIL.put_line('Inserted '||sql%rowcount||' rows INTO FII_AP_INV_STG table');
601: FII_UTIL.stop_timer;
602: FII_UTIL.print_timer('Duration');
603: end if;
604:
605:

Line 602: FII_UTIL.print_timer('Duration');

598:
599: if g_debug_flag = 'Y' then
600: FII_UTIL.put_line('Inserted '||sql%rowcount||' rows INTO FII_AP_INV_STG table');
601: FII_UTIL.stop_timer;
602: FII_UTIL.print_timer('Duration');
603: end if;
604:
605:
606: END IF;

Line 622: FII_UTIL.put_line('Error occured while ' || g_state);

618: WHEN OTHERS THEN
619: g_errbuf:=sqlerrm;
620: g_retcode:= -1;
621: g_exception_msg := g_retcode || ':' || g_errbuf;
622: FII_UTIL.put_line('Error occured while ' || g_state);
623: FII_UTIL.put_line(g_exception_msg);
624: RAISE;
625:
626: END POPULATE_AP_SUM_STG;

Line 623: FII_UTIL.put_line(g_exception_msg);

619: g_errbuf:=sqlerrm;
620: g_retcode:= -1;
621: g_exception_msg := g_retcode || ':' || g_errbuf;
622: FII_UTIL.put_line('Error occured while ' || g_state);
623: FII_UTIL.put_line(g_exception_msg);
624: RAISE;
625:
626: END POPULATE_AP_SUM_STG;
627:

Line 666: FII_UTIL.put_line(g_state);

662:
663: g_phase := 'Register phase 1 jobs for workers';
664:
665: if g_debug_flag = 'Y' then
666: FII_UTIL.put_line(g_state);
667: end if;
668:
669: WHILE (l_start_number1 < (l_max_number1 + 1)) LOOP
670: l_end_number:= l_start_number1 + INTERVAL_SIZE;

Line 680: FII_UTIL.put_line('Inserted ' || l_count || ' jobs into FII_AP_SUM_WORK_JOBS table');

676: l_start_number1 := least(l_end_number, l_max_number1) + 1;
677: END LOOP;
678:
679: if g_debug_flag = 'Y' then
680: FII_UTIL.put_line('Inserted ' || l_count || ' jobs into FII_AP_SUM_WORK_JOBS table');
681: end if;
682:
683:
684: g_phase := 'Register phase 2 jobs for workers';

Line 687: FII_UTIL.put_line(g_state);

683:
684: g_phase := 'Register phase 2 jobs for workers';
685:
686: if g_debug_flag = 'Y' then
687: FII_UTIL.put_line(g_state);
688: end if;
689:
690:
691: if g_debug_flag = 'Y' then

Line 692: FII_UTIL.put_line('New data processed during this incremental load is from header ' || l_start_number2 || ' to ' || l_max_number2);

688: end if;
689:
690:
691: if g_debug_flag = 'Y' then
692: FII_UTIL.put_line('New data processed during this incremental load is from header ' || l_start_number2 || ' to ' || l_max_number2);
693: end if;
694:
695: WHILE (l_start_number2 < (l_max_number2 + 1)) LOOP
696: l_end_number:= l_start_number2 + INTERVAL_SIZE;

Line 706: FII_UTIL.put_line('Inserted ' || l_count || ' jobs into FII_AP_SUM_WORK_JOBS table');

702: l_start_number2 := least(l_end_number, l_max_number2) + 1;
703: END LOOP;
704:
705: if g_debug_flag = 'Y' then
706: FII_UTIL.put_line('Inserted ' || l_count || ' jobs into FII_AP_SUM_WORK_JOBS table');
707: end if;
708:
709: RETURN 1;
710:

Line 734: FII_UTIL.put_line(g_state);

730: BEGIN
731:
732: g_state := 'Inside Launch Worker procedure for worker ' || p_worker_no;
733: if g_debug_flag = 'Y' then
734: FII_UTIL.put_line(g_state);
735: end if;
736:
737:
738: l_request_id := FND_REQUEST.SUBMIT_REQUEST(

Line 764: FII_UTIL.put_line('No child process launched');

760:
761: EXCEPTION
762: WHEN G_NO_CHILD_PROCESS THEN
763: g_retcode := -1;
764: FII_UTIL.put_line('No child process launched');
765: raise;
766: WHEN OTHERS THEN
767: rollback;
768: g_retcode := -2;

Line 924: FII_UTIL.put_line('Error occured while ' || g_state);

920: WHEN OTHERS THEN
921: g_errbuf:=sqlerrm;
922: g_retcode:= -1;
923: g_exception_msg := g_retcode || ':' || g_errbuf;
924: FII_UTIL.put_line('Error occured while ' || g_state);
925: FII_UTIL.put_line(g_exception_msg);
926: RAISE;
927: END VERIFY_MISSING_RATES;
928:

Line 925: FII_UTIL.put_line(g_exception_msg);

921: g_errbuf:=sqlerrm;
922: g_retcode:= -1;
923: g_exception_msg := g_retcode || ':' || g_errbuf;
924: FII_UTIL.put_line('Error occured while ' || g_state);
925: FII_UTIL.put_line(g_exception_msg);
926: RAISE;
927: END VERIFY_MISSING_RATES;
928:
929: -----------------------------------------------------------

Line 939: FII_UTIL.put_line('');

935: BEGIN
936: SELECT FII_AP_INV_B_S.nextval INTO seq_id FROM dual;
937:
938: if g_debug_flag = 'Y' then
939: FII_UTIL.put_line('');
940: FII_UTIL.put_line('-------------------------------------------------');
941: FII_UTIL.put_line('Populating FII_AP_INV_B FROM FII_AP_INV_STG table');
942: end if;
943:

Line 940: FII_UTIL.put_line('-------------------------------------------------');

936: SELECT FII_AP_INV_B_S.nextval INTO seq_id FROM dual;
937:
938: if g_debug_flag = 'Y' then
939: FII_UTIL.put_line('');
940: FII_UTIL.put_line('-------------------------------------------------');
941: FII_UTIL.put_line('Populating FII_AP_INV_B FROM FII_AP_INV_STG table');
942: end if;
943:
944: g_state := 'Populating FII_AP_INV_B FROM FII_AP_INV_STG table';

Line 941: FII_UTIL.put_line('Populating FII_AP_INV_B FROM FII_AP_INV_STG table');

937:
938: if g_debug_flag = 'Y' then
939: FII_UTIL.put_line('');
940: FII_UTIL.put_line('-------------------------------------------------');
941: FII_UTIL.put_line('Populating FII_AP_INV_B FROM FII_AP_INV_STG table');
942: end if;
943:
944: g_state := 'Populating FII_AP_INV_B FROM FII_AP_INV_STG table';
945:

Line 1078: FII_UTIL.put_line('Merged ' || SQL%ROWCOUNT || ' records into FII_AP_INV_B');

1074: STG.Purchasing_Category_ID,
1075: STG.Item_Description);
1076:
1077: if g_debug_flag = 'Y' then
1078: FII_UTIL.put_line('Merged ' || SQL%ROWCOUNT || ' records into FII_AP_INV_B');
1079: FII_UTIL.put_line('');
1080: end if;
1081:
1082: COMMIT;

Line 1079: FII_UTIL.put_line('');

1075: STG.Item_Description);
1076:
1077: if g_debug_flag = 'Y' then
1078: FII_UTIL.put_line('Merged ' || SQL%ROWCOUNT || ' records into FII_AP_INV_B');
1079: FII_UTIL.put_line('');
1080: end if;
1081:
1082: COMMIT;
1083:

Line 1089: FII_UTIL.put_line('Error occured while ' || g_state);

1085: WHEN OTHERS THEN
1086: g_errbuf:=sqlerrm;
1087: g_retcode:= -1;
1088: g_exception_msg := g_retcode || ':' || g_errbuf;
1089: FII_UTIL.put_line('Error occured while ' || g_state);
1090: FII_UTIL.put_line(g_exception_msg);
1091: RAISE;
1092:
1093: END POPULATE_AP_BASE_SUM;

Line 1090: FII_UTIL.put_line(g_exception_msg);

1086: g_errbuf:=sqlerrm;
1087: g_retcode:= -1;
1088: g_exception_msg := g_retcode || ':' || g_errbuf;
1089: FII_UTIL.put_line('Error occured while ' || g_state);
1090: FII_UTIL.put_line(g_exception_msg);
1091: RAISE;
1092:
1093: END POPULATE_AP_BASE_SUM;
1094:

Line 1111: l_dir:=FII_UTIL.get_utl_file_dir;

1107: ------------------------------------------------------
1108: -- Set default directory in case if the profile option
1109: -- BIS_DEBUG_LOG_DIRECTORY is not set up
1110: ------------------------------------------------------
1111: l_dir:=FII_UTIL.get_utl_file_dir;
1112:
1113: ----------------------------------------------------------------
1114: -- fii_util.initialize will get profile options FII_DEBUG_MODE
1115: -- and BIS_DEBUG_LOG_DIRECTORY and set up the directory where

Line 1114: -- fii_util.initialize will get profile options FII_DEBUG_MODE

1110: ------------------------------------------------------
1111: l_dir:=FII_UTIL.get_utl_file_dir;
1112:
1113: ----------------------------------------------------------------
1114: -- fii_util.initialize will get profile options FII_DEBUG_MODE
1115: -- and BIS_DEBUG_LOG_DIRECTORY and set up the directory where
1116: -- the log files and output files are written to
1117: ----------------------------------------------------------------
1118: FII_UTIL.initialize(p_object_name||'.log',p_object_name||'.out',l_dir,'FII_AP_INV_B_Worker');

Line 1118: FII_UTIL.initialize(p_object_name||'.log',p_object_name||'.out',l_dir,'FII_AP_INV_B_Worker');

1114: -- fii_util.initialize will get profile options FII_DEBUG_MODE
1115: -- and BIS_DEBUG_LOG_DIRECTORY and set up the directory where
1116: -- the log files and output files are written to
1117: ----------------------------------------------------------------
1118: FII_UTIL.initialize(p_object_name||'.log',p_object_name||'.out',l_dir,'FII_AP_INV_B_Worker');
1119:
1120:
1121: g_fii_user_id := FND_GLOBAL.User_Id;
1122: g_fii_login_id := FND_GLOBAL.Login_Id;

Line 1149: FII_UTIL.put_line('Section 20');

1145: -- FII_AP_INV_B is using
1146: -- --------------------------------------------------------
1147: g_section := 'Section 20';
1148: if g_debug_flag = 'Y' then
1149: FII_UTIL.put_line('Section 20');
1150: end if;
1151:
1152: IF(FND_INSTALLATION.GET_APP_INFO('FII', l_status, l_industry, g_fii_schema))
1153: THEN NULL;

Line 1155: FII_UTIL.put_line('g_fii_schema is '||g_fii_schema);

1151:
1152: IF(FND_INSTALLATION.GET_APP_INFO('FII', l_status, l_industry, g_fii_schema))
1153: THEN NULL;
1154: if g_debug_flag = 'Y' then
1155: FII_UTIL.put_line('g_fii_schema is '||g_fii_schema);
1156: end if;
1157: END IF;
1158:
1159: g_section := 'Section 30';

Line 1161: FII_UTIL.put_line('Section 30');

1157: END IF;
1158:
1159: g_section := 'Section 30';
1160: if g_debug_flag = 'Y' then
1161: FII_UTIL.put_line('Section 30');
1162: end if;
1163:
1164: /* Commenting out as unncessary. Query affects performance.
1165:

Line 1175: FII_UTIL.put_line('g_tablespace is '||g_tablespace);

1171: WHERE table_name = g_table_name
1172: AND owner = g_fii_schema;
1173:
1174: if g_debug_flag = 'Y' then
1175: FII_UTIL.put_line('g_tablespace is '||g_tablespace);
1176: end if;
1177: g_section := 'Section 35';
1178: if g_debug_flag = 'Y' then
1179: FII_UTIL.put_line('Section 35');

Line 1179: FII_UTIL.put_line('Section 35');

1175: FII_UTIL.put_line('g_tablespace is '||g_tablespace);
1176: end if;
1177: g_section := 'Section 35';
1178: if g_debug_flag = 'Y' then
1179: FII_UTIL.put_line('Section 35');
1180: end if;
1181: */
1182: -- --------------------------------------------------------
1183: -- get minimum accountable unit of the warehouse currency

Line 1221: fii_util.write_log(

1217: g_sec_rate_type_name := null;
1218: end if;
1219: exception
1220: when others then
1221: fii_util.write_log(
1222: 'Failed to convert rate_type to rate_type_name' );
1223: raise;
1224: end;
1225:

Line 1231: FII_UTIL.put_line('User ID: ' || g_fii_user_id || ' Login ID: ' || g_fii_login_id);

1227: RAISE G_LOGIN_INFO_NOT_AVABLE;
1228: END IF;
1229:
1230: if g_debug_flag = 'Y' then
1231: FII_UTIL.put_line('User ID: ' || g_fii_user_id || ' Login ID: ' || g_fii_login_id);
1232: end if;
1233:
1234: EXCEPTION
1235: WHEN G_LOGIN_INFO_NOT_AVABLE THEN

Line 1272: FII_UTIL.put_line('Calling Procedure: VERIFY_CCID_UP_TO_DATE');

1268: l_message VARCHAR2(500) := NULL;
1269: BEGIN
1270: g_state := 'Calling Procedure: VERIFY_CCID_UP_TO_DATE';
1271: if g_debug_flag = 'Y' then
1272: FII_UTIL.put_line('Calling Procedure: VERIFY_CCID_UP_TO_DATE');
1273: FII_UTIL.put_line('');
1274: end if;
1275:
1276: g_phase := 'Verifying if CCID Dimension is up to date';

Line 1273: FII_UTIL.put_line('');

1269: BEGIN
1270: g_state := 'Calling Procedure: VERIFY_CCID_UP_TO_DATE';
1271: if g_debug_flag = 'Y' then
1272: FII_UTIL.put_line('Calling Procedure: VERIFY_CCID_UP_TO_DATE');
1273: FII_UTIL.put_line('');
1274: end if;
1275:
1276: g_phase := 'Verifying if CCID Dimension is up to date';
1277: if g_debug_flag = 'Y' then

Line 1278: FII_UTIL.put_line(g_phase);

1274: end if;
1275:
1276: g_phase := 'Verifying if CCID Dimension is up to date';
1277: if g_debug_flag = 'Y' then
1278: FII_UTIL.put_line(g_phase);
1279: end if;
1280:
1281: IF(FII_GL_CCID_C.NEW_CCID_IN_GL) THEN
1282: if g_debug_flag = 'Y' then

Line 1283: FII_UTIL.put_line('CCID Dimension is not up to date, calling CCID Dimension update

1279: end if;
1280:
1281: IF(FII_GL_CCID_C.NEW_CCID_IN_GL) THEN
1282: if g_debug_flag = 'Y' then
1283: FII_UTIL.put_line('CCID Dimension is not up to date, calling CCID Dimension update
1284: program');
1285: end if;
1286: g_phase := 'Calling CCID Dimension update program';
1287: l_request_id := FND_REQUEST.SUBMIT_REQUEST('FII',

Line 1309: FII_UTIL.put_line('CCID Dimension populated successfully');

1305: l_message);
1306:
1307: IF l_result THEN
1308: if g_debug_flag = 'Y' then
1309: FII_UTIL.put_line('CCID Dimension populated successfully');
1310: end if;
1311: ELSE
1312: FII_UTIL.put_line('CCID Dimension populated unsuccessfully');
1313: raise G_CCID_FAILED;

Line 1312: FII_UTIL.put_line('CCID Dimension populated unsuccessfully');

1308: if g_debug_flag = 'Y' then
1309: FII_UTIL.put_line('CCID Dimension populated successfully');
1310: end if;
1311: ELSE
1312: FII_UTIL.put_line('CCID Dimension populated unsuccessfully');
1313: raise G_CCID_FAILED;
1314: END IF;
1315:
1316: ELSE

Line 1318: FII_UTIL.put_line('CCID Dimension is up to date');

1314: END IF;
1315:
1316: ELSE
1317: if g_debug_flag = 'Y' then
1318: FII_UTIL.put_line('CCID Dimension is up to date');
1319: FII_UTIL.put_line('');
1320: end if;
1321: END IF;
1322:

Line 1319: FII_UTIL.put_line('');

1315:
1316: ELSE
1317: if g_debug_flag = 'Y' then
1318: FII_UTIL.put_line('CCID Dimension is up to date');
1319: FII_UTIL.put_line('');
1320: end if;
1321: END IF;
1322:
1323: Exception

Line 1367: fii_util.put_line(' ');

1363: execute immediate l_stmt;
1364:
1365: g_state := 'Loading data into staging table';
1366: if g_debug_flag = 'Y' then
1367: fii_util.put_line(' ');
1368: fii_util.put_line('Loading data into staging table');
1369: fii_util.start_timer;
1370: fii_util.put_line('');
1371: end if;

Line 1368: fii_util.put_line('Loading data into staging table');

1364:
1365: g_state := 'Loading data into staging table';
1366: if g_debug_flag = 'Y' then
1367: fii_util.put_line(' ');
1368: fii_util.put_line('Loading data into staging table');
1369: fii_util.start_timer;
1370: fii_util.put_line('');
1371: end if;
1372:

Line 1369: fii_util.start_timer;

1365: g_state := 'Loading data into staging table';
1366: if g_debug_flag = 'Y' then
1367: fii_util.put_line(' ');
1368: fii_util.put_line('Loading data into staging table');
1369: fii_util.start_timer;
1370: fii_util.put_line('');
1371: end if;
1372:
1373:

Line 1370: fii_util.put_line('');

1366: if g_debug_flag = 'Y' then
1367: fii_util.put_line(' ');
1368: fii_util.put_line('Loading data into staging table');
1369: fii_util.start_timer;
1370: fii_util.put_line('');
1371: end if;
1372:
1373:
1374: INSERT /*+ APPEND PARALLEL(F) */ INTO FII_AP_INV_STG F

Line 1565: fii_util.put_line('Processed '||SQL%ROWCOUNT||' rows');

1561: AND xah.accounting_date >= g_start_date;
1562:
1563:
1564: if g_debug_flag = 'Y' then
1565: fii_util.put_line('Processed '||SQL%ROWCOUNT||' rows');
1566: fii_util.stop_timer;
1567: fii_util.print_timer('Duration');
1568: end if;
1569:

Line 1566: fii_util.stop_timer;

1562:
1563:
1564: if g_debug_flag = 'Y' then
1565: fii_util.put_line('Processed '||SQL%ROWCOUNT||' rows');
1566: fii_util.stop_timer;
1567: fii_util.print_timer('Duration');
1568: end if;
1569:
1570: commit;

Line 1567: fii_util.print_timer('Duration');

1563:
1564: if g_debug_flag = 'Y' then
1565: fii_util.put_line('Processed '||SQL%ROWCOUNT||' rows');
1566: fii_util.stop_timer;
1567: fii_util.print_timer('Duration');
1568: end if;
1569:
1570: commit;
1571:

Line 1583: fii_util.put_line(' ');

1579:
1580: BEGIN
1581: g_state := 'Loading data into rates table';
1582: if g_debug_flag = 'Y' then
1583: fii_util.put_line(' ');
1584: fii_util.put_line('Loading data into rates table');
1585: fii_util.start_timer;
1586: fii_util.put_line('');
1587: end if;

Line 1584: fii_util.put_line('Loading data into rates table');

1580: BEGIN
1581: g_state := 'Loading data into rates table';
1582: if g_debug_flag = 'Y' then
1583: fii_util.put_line(' ');
1584: fii_util.put_line('Loading data into rates table');
1585: fii_util.start_timer;
1586: fii_util.put_line('');
1587: end if;
1588:

Line 1585: fii_util.start_timer;

1581: g_state := 'Loading data into rates table';
1582: if g_debug_flag = 'Y' then
1583: fii_util.put_line(' ');
1584: fii_util.put_line('Loading data into rates table');
1585: fii_util.start_timer;
1586: fii_util.put_line('');
1587: end if;
1588:
1589: --modified by ilavenil to handle future dated transaction. The change is usage of least(...,sysdate)

Line 1586: fii_util.put_line('');

1582: if g_debug_flag = 'Y' then
1583: fii_util.put_line(' ');
1584: fii_util.put_line('Loading data into rates table');
1585: fii_util.start_timer;
1586: fii_util.put_line('');
1587: end if;
1588:
1589: --modified by ilavenil to handle future dated transaction. The change is usage of least(...,sysdate)
1590: insert into fii_ap_inv_rates_temp

Line 1607: fii_util.put_line('Processed '||SQL%ROWCOUNT||' rows');

1603: from FII_AP_INV_STG
1604: );
1605:
1606: if g_debug_flag = 'Y' then
1607: fii_util.put_line('Processed '||SQL%ROWCOUNT||' rows');
1608: fii_util.stop_timer;
1609: fii_util.print_timer('Duration');
1610: end if;
1611:

Line 1608: fii_util.stop_timer;

1604: );
1605:
1606: if g_debug_flag = 'Y' then
1607: fii_util.put_line('Processed '||SQL%ROWCOUNT||' rows');
1608: fii_util.stop_timer;
1609: fii_util.print_timer('Duration');
1610: end if;
1611:
1612: END INSERT_RATES;

Line 1609: fii_util.print_timer('Duration');

1605:
1606: if g_debug_flag = 'Y' then
1607: fii_util.put_line('Processed '||SQL%ROWCOUNT||' rows');
1608: fii_util.stop_timer;
1609: fii_util.print_timer('Duration');
1610: end if;
1611:
1612: END INSERT_RATES;
1613:

Line 1626: fii_util.put_line(' ');

1622:
1623: BEGIN
1624: g_state := 'Loading data into base summary table';
1625: if g_debug_flag = 'Y' then
1626: fii_util.put_line(' ');
1627: fii_util.put_line('Loading data into base summary table');
1628: fii_util.start_timer;
1629: fii_util.put_line('');
1630: end if;

Line 1627: fii_util.put_line('Loading data into base summary table');

1623: BEGIN
1624: g_state := 'Loading data into base summary table';
1625: if g_debug_flag = 'Y' then
1626: fii_util.put_line(' ');
1627: fii_util.put_line('Loading data into base summary table');
1628: fii_util.start_timer;
1629: fii_util.put_line('');
1630: end if;
1631:

Line 1628: fii_util.start_timer;

1624: g_state := 'Loading data into base summary table';
1625: if g_debug_flag = 'Y' then
1626: fii_util.put_line(' ');
1627: fii_util.put_line('Loading data into base summary table');
1628: fii_util.start_timer;
1629: fii_util.put_line('');
1630: end if;
1631:
1632: SELECT FII_AP_INV_B_S.nextval INTO seq_id FROM dual;

Line 1629: fii_util.put_line('');

1625: if g_debug_flag = 'Y' then
1626: fii_util.put_line(' ');
1627: fii_util.put_line('Loading data into base summary table');
1628: fii_util.start_timer;
1629: fii_util.put_line('');
1630: end if;
1631:
1632: SELECT FII_AP_INV_B_S.nextval INTO seq_id FROM dual;
1633:

Line 1758: fii_util.put_line('Processed '||SQL%ROWCOUNT||' rows');

1754: where stg.account_date = rates.trx_date
1755: and stg.inv_currency_code = rates.functional_currency;
1756:
1757: if g_debug_flag = 'Y' then
1758: fii_util.put_line('Processed '||SQL%ROWCOUNT||' rows');
1759: fii_util.stop_timer;
1760: fii_util.print_timer('Duration');
1761: end if;
1762:

Line 1759: fii_util.stop_timer;

1755: and stg.inv_currency_code = rates.functional_currency;
1756:
1757: if g_debug_flag = 'Y' then
1758: fii_util.put_line('Processed '||SQL%ROWCOUNT||' rows');
1759: fii_util.stop_timer;
1760: fii_util.print_timer('Duration');
1761: end if;
1762:
1763: commit;

Line 1760: fii_util.print_timer('Duration');

1756:
1757: if g_debug_flag = 'Y' then
1758: fii_util.put_line('Processed '||SQL%ROWCOUNT||' rows');
1759: fii_util.stop_timer;
1760: fii_util.print_timer('Duration');
1761: end if;
1762:
1763: commit;
1764:

Line 1829: l_dir:=FII_UTIL.get_utl_file_dir;

1825: -- Set default directory in case if the profile option
1826: -- BIS_DEBUG_LOG_DIRECTORY is not set up
1827: ------------------------------------------------------
1828:
1829: l_dir:=FII_UTIL.get_utl_file_dir;
1830:
1831: ----------------------------------------------------------------
1832: -- FII_UTIL.initialize will get profile options FII_DEBUG_MODE
1833: -- and BIS_DEBUG_LOG_DIRECTORY and set up the directory where

Line 1832: -- FII_UTIL.initialize will get profile options FII_DEBUG_MODE

1828:
1829: l_dir:=FII_UTIL.get_utl_file_dir;
1830:
1831: ----------------------------------------------------------------
1832: -- FII_UTIL.initialize will get profile options FII_DEBUG_MODE
1833: -- and BIS_DEBUG_LOG_DIRECTORY and set up the directory where
1834: -- the log files and output files are written to
1835: ----------------------------------------------------------------
1836: IF g_program_type = 'L' THEN

Line 1837: FII_UTIL.initialize('FII_AP_INV_B.log','FII_AP_INV_B.out',l_dir,'FII_AP_INV_B_L');

1833: -- and BIS_DEBUG_LOG_DIRECTORY and set up the directory where
1834: -- the log files and output files are written to
1835: ----------------------------------------------------------------
1836: IF g_program_type = 'L' THEN
1837: FII_UTIL.initialize('FII_AP_INV_B.log','FII_AP_INV_B.out',l_dir,'FII_AP_INV_B_L');
1838: ELSE
1839: FII_UTIL.initialize('FII_AP_INV_B.log','FII_AP_INV_B.out',l_dir, 'FII_AP_INV_B_I');
1840: END IF;
1841:

Line 1839: FII_UTIL.initialize('FII_AP_INV_B.log','FII_AP_INV_B.out',l_dir, 'FII_AP_INV_B_I');

1835: ----------------------------------------------------------------
1836: IF g_program_type = 'L' THEN
1837: FII_UTIL.initialize('FII_AP_INV_B.log','FII_AP_INV_B.out',l_dir,'FII_AP_INV_B_L');
1838: ELSE
1839: FII_UTIL.initialize('FII_AP_INV_B.log','FII_AP_INV_B.out',l_dir, 'FII_AP_INV_B_I');
1840: END IF;
1841:
1842: -------------------------------------------------------------
1843: -- Check if FII: DBI Payables Invoice Distributions Implementation profile

Line 1868: FII_UTIL.put_line(fnd_message.get_string('FII', 'FII_BAD_GLOBAL_PARA'));

1864: l_global_param_list(1) := 'BIS_GLOBAL_START_DATE';
1865: l_global_param_list(2) := 'BIS_PRIMARY_CURRENCY_CODE';
1866: l_global_param_list(3) := 'BIS_PRIMARY_RATE_TYPE';
1867: IF (NOT bis_common_parameters.check_global_parameters(l_global_param_list)) THEN
1868: FII_UTIL.put_line(fnd_message.get_string('FII', 'FII_BAD_GLOBAL_PARA'));
1869: retcode := -1;
1870: return;
1871: END IF;
1872:

Line 1878: FII_UTIL.put_line(' ');

1874: -- ------------------------------------------
1875: -- Initalize other variables
1876: -- ------------------------------------------
1877: if g_debug_flag = 'Y' then
1878: FII_UTIL.put_line(' ');
1879: FII_UTIL.put_line('-------------------------------------------------');
1880: FII_UTIL.put_line('Initialization');
1881: end if;
1882: INIT;

Line 1879: FII_UTIL.put_line('-------------------------------------------------');

1875: -- Initalize other variables
1876: -- ------------------------------------------
1877: if g_debug_flag = 'Y' then
1878: FII_UTIL.put_line(' ');
1879: FII_UTIL.put_line('-------------------------------------------------');
1880: FII_UTIL.put_line('Initialization');
1881: end if;
1882: INIT;
1883: if g_debug_flag = 'Y' then

Line 1880: FII_UTIL.put_line('Initialization');

1876: -- ------------------------------------------
1877: if g_debug_flag = 'Y' then
1878: FII_UTIL.put_line(' ');
1879: FII_UTIL.put_line('-------------------------------------------------');
1880: FII_UTIL.put_line('Initialization');
1881: end if;
1882: INIT;
1883: if g_debug_flag = 'Y' then
1884: FII_UTIL.put_line('-------------------------------------------------');

Line 1884: FII_UTIL.put_line('-------------------------------------------------');

1880: FII_UTIL.put_line('Initialization');
1881: end if;
1882: INIT;
1883: if g_debug_flag = 'Y' then
1884: FII_UTIL.put_line('-------------------------------------------------');
1885: FII_UTIL.put_line(' ');
1886: end if;
1887:
1888: IF p_program_type = 'L' THEN

Line 1885: FII_UTIL.put_line(' ');

1881: end if;
1882: INIT;
1883: if g_debug_flag = 'Y' then
1884: FII_UTIL.put_line('-------------------------------------------------');
1885: FII_UTIL.put_line(' ');
1886: end if;
1887:
1888: IF p_program_type = 'L' THEN
1889: g_state := 'Running Initial Load, truncate staging and base summary table.';

Line 1891: FII_UTIL.put_line('Running Initial Load, truncate staging and base summary table.');

1887:
1888: IF p_program_type = 'L' THEN
1889: g_state := 'Running Initial Load, truncate staging and base summary table.';
1890: IF g_debug_flag = 'Y' then
1891: FII_UTIL.put_line('Running Initial Load, truncate staging and base summary table.');
1892: END IF;
1893: TRUNCATE_TABLE('FII_AP_INV_STG');
1894: TRUNCATE_TABLE('FII_AP_INV_B');
1895: COMMIT;

Line 1928: FII_UTIL.put_line(fnd_message.get_string('FII', 'FII_TRUNC_SUMMARY'));

1924: FII_MESSAGE.write_output(
1925: msg_name => 'FII_TRUNC_SUMMARY',
1926: token_num => 0);
1927:
1928: FII_UTIL.put_line(fnd_message.get_string('FII', 'FII_TRUNC_SUMMARY'));
1929: retcode := -1;
1930: RETURN;
1931: END IF;
1932: ELSIF (p_program_type = 'L') THEN

Line 1974: FII_UTIL.put_line(' ');

1970: g_end_date := l_end_date;
1971:
1972: END IF;
1973: if g_debug_flag = 'Y' then
1974: FII_UTIL.put_line(' ');
1975: FII_UTIL.put_line('-------------------------------------------------');
1976: FII_UTIL.put_line('The date range of collection is from ' || to_char(g_start_date, 'MM/DD/YYYY HH24:MI:SS') || '.');
1977: FII_UTIL.put_line('-------------------------------------------------');
1978: FII_UTIL.put_line(' ');

Line 1975: FII_UTIL.put_line('-------------------------------------------------');

1971:
1972: END IF;
1973: if g_debug_flag = 'Y' then
1974: FII_UTIL.put_line(' ');
1975: FII_UTIL.put_line('-------------------------------------------------');
1976: FII_UTIL.put_line('The date range of collection is from ' || to_char(g_start_date, 'MM/DD/YYYY HH24:MI:SS') || '.');
1977: FII_UTIL.put_line('-------------------------------------------------');
1978: FII_UTIL.put_line(' ');
1979: end if;

Line 1976: FII_UTIL.put_line('The date range of collection is from ' || to_char(g_start_date, 'MM/DD/YYYY HH24:MI:SS') || '.');

1972: END IF;
1973: if g_debug_flag = 'Y' then
1974: FII_UTIL.put_line(' ');
1975: FII_UTIL.put_line('-------------------------------------------------');
1976: FII_UTIL.put_line('The date range of collection is from ' || to_char(g_start_date, 'MM/DD/YYYY HH24:MI:SS') || '.');
1977: FII_UTIL.put_line('-------------------------------------------------');
1978: FII_UTIL.put_line(' ');
1979: end if;
1980:

Line 1977: FII_UTIL.put_line('-------------------------------------------------');

1973: if g_debug_flag = 'Y' then
1974: FII_UTIL.put_line(' ');
1975: FII_UTIL.put_line('-------------------------------------------------');
1976: FII_UTIL.put_line('The date range of collection is from ' || to_char(g_start_date, 'MM/DD/YYYY HH24:MI:SS') || '.');
1977: FII_UTIL.put_line('-------------------------------------------------');
1978: FII_UTIL.put_line(' ');
1979: end if;
1980:
1981: --Calling CHECK_XLA_CONVERSION_STATUS==Bug 5437394

Line 1978: FII_UTIL.put_line(' ');

1974: FII_UTIL.put_line(' ');
1975: FII_UTIL.put_line('-------------------------------------------------');
1976: FII_UTIL.put_line('The date range of collection is from ' || to_char(g_start_date, 'MM/DD/YYYY HH24:MI:SS') || '.');
1977: FII_UTIL.put_line('-------------------------------------------------');
1978: FII_UTIL.put_line(' ');
1979: end if;
1980:
1981: --Calling CHECK_XLA_CONVERSION_STATUS==Bug 5437394
1982:

Line 2060: FII_UTIL.put_line('Populating Invoice ID table');

2056: -------------------------------------------------
2057: IF g_program_type = 'I' THEN
2058:
2059: if g_debug_flag = 'Y' then
2060: FII_UTIL.put_line('Populating Invoice ID table');
2061: FII_UTIL.start_timer;
2062: end if;
2063: l_new_inv_id_count := POPULATE_INV_ID_TEMP;
2064: if g_debug_flag = 'Y' then

Line 2061: FII_UTIL.start_timer;

2057: IF g_program_type = 'I' THEN
2058:
2059: if g_debug_flag = 'Y' then
2060: FII_UTIL.put_line('Populating Invoice ID table');
2061: FII_UTIL.start_timer;
2062: end if;
2063: l_new_inv_id_count := POPULATE_INV_ID_TEMP;
2064: if g_debug_flag = 'Y' then
2065: FII_UTIL.stop_timer;

Line 2065: FII_UTIL.stop_timer;

2061: FII_UTIL.start_timer;
2062: end if;
2063: l_new_inv_id_count := POPULATE_INV_ID_TEMP;
2064: if g_debug_flag = 'Y' then
2065: FII_UTIL.stop_timer;
2066: FII_UTIL.print_timer('Duration');
2067: end if;
2068:
2069: END IF;

Line 2066: FII_UTIL.print_timer('Duration');

2062: end if;
2063: l_new_inv_id_count := POPULATE_INV_ID_TEMP;
2064: if g_debug_flag = 'Y' then
2065: FII_UTIL.stop_timer;
2066: FII_UTIL.print_timer('Duration');
2067: end if;
2068:
2069: END IF;
2070: ----------------------------------------------------------------

Line 2084: FII_UTIL.put_line(g_phase);

2080: -- CCID dimension.
2081: ----------------------------------------------------------------
2082: g_phase := 'Verifying if CCID Dimension is up to date';
2083: if g_debug_flag = 'Y' then
2084: FII_UTIL.put_line(g_phase);
2085: end if;
2086:
2087: VERIFY_CCID_UP_TO_DATE;
2088:

Line 2092: FII_UTIL.put_line(g_phase);

2088:
2089: IF p_program_type = 'L' THEN
2090: g_phase := 'Bypassing SLA security.';
2091: if g_debug_flag = 'Y' then
2092: FII_UTIL.put_line(g_phase);
2093: end if;
2094:
2095: xla_security_pkg.set_security_context(p_application_id => 602);
2096:

Line 2108: FII_UTIL.put_line(' ');

2104: --------------------------------------------
2105: -- Register jobs
2106: --------------------------------------------
2107: if g_debug_flag = 'Y' then
2108: FII_UTIL.put_line(' ');
2109: FII_UTIL.put_line('Populating Jobs Table');
2110: FII_UTIL.put_timestamp;
2111: end if;
2112: l_new_inv_id_count := REGISTER_JOBS;

Line 2109: FII_UTIL.put_line('Populating Jobs Table');

2105: -- Register jobs
2106: --------------------------------------------
2107: if g_debug_flag = 'Y' then
2108: FII_UTIL.put_line(' ');
2109: FII_UTIL.put_line('Populating Jobs Table');
2110: FII_UTIL.put_timestamp;
2111: end if;
2112: l_new_inv_id_count := REGISTER_JOBS;
2113: COMMIT;

Line 2110: FII_UTIL.put_timestamp;

2106: --------------------------------------------
2107: if g_debug_flag = 'Y' then
2108: FII_UTIL.put_line(' ');
2109: FII_UTIL.put_line('Populating Jobs Table');
2110: FII_UTIL.put_timestamp;
2111: end if;
2112: l_new_inv_id_count := REGISTER_JOBS;
2113: COMMIT;
2114:

Line 2124: FII_UTIL.put_line('No Records to Process, exit.');

2120: --------------------------------------------------------
2121: IF (l_new_inv_id_count = 0) THEN
2122:
2123: if g_debug_flag = 'Y' then
2124: FII_UTIL.put_line('No Records to Process, exit.');
2125: end if;
2126:
2127: ----------------------------------------------------------------
2128: -- Calling BIS API to record the range we collect. Only do this

Line 2143: FII_UTIL.put_line('Launching Workers');

2139: --------------------------------------------------------
2140: -- Launch worker
2141: --------------------------------------------------------
2142: if g_debug_flag = 'Y' then
2143: FII_UTIL.put_line('Launching Workers');
2144: end if;
2145: FOR i IN 1..p_no_worker
2146: LOOP /* p_no_worker is the parameter user submitted
2147: to specify how many workers they want to

Line 2151: FII_UTIL.put_line(' Worker '||i||' request id: '||l_worker(i));

2147: to specify how many workers they want to
2148: submit */
2149: l_worker(i) := LAUNCH_WORKER(i);
2150: if g_debug_flag = 'Y' then
2151: FII_UTIL.put_line(' Worker '||i||' request id: '||l_worker(i));
2152: end if;
2153: END LOOP;
2154:
2155: COMMIT;

Line 2186: FII_UTIL.put_line('Job status - Unassigned:'||l_unassigned_cnt||

2182: l_tot_cnt
2183: FROM FII_AP_SUM_WORK_JOBS;
2184:
2185: if g_debug_flag = 'Y' then
2186: FII_UTIL.put_line('Job status - Unassigned:'||l_unassigned_cnt||
2187: ' In Process:'||l_wip_cnt||
2188: ' Completed:'||l_completed_cnt||
2189: ' Failed:'||l_failed_cnt);
2190: end if;

Line 2206: FII_UTIL.put_line('Job status - Total: '|| l_tot_cnt);

2202: -- have completed. Then we can exit the loop
2203: ----------------------------------------------
2204: IF (l_tot_cnt = l_completed_cnt) THEN
2205: if g_debug_flag = 'Y' then
2206: FII_UTIL.put_line('Job status - Total: '|| l_tot_cnt);
2207: end if;
2208: EXIT;
2209: END IF;
2210:

Line 2249: FII_UTIL.stop_timer;

2245:
2246: END LOOP;
2247:
2248: if g_debug_flag = 'Y' then
2249: FII_UTIL.stop_timer;
2250: FII_UTIL.print_timer('Duration');
2251: end if;
2252: END;
2253:

Line 2250: FII_UTIL.print_timer('Duration');

2246: END LOOP;
2247:
2248: if g_debug_flag = 'Y' then
2249: FII_UTIL.stop_timer;
2250: FII_UTIL.print_timer('Duration');
2251: end if;
2252: END;
2253:
2254: END IF;

Line 2271: FII_UTIL.put_line('');

2267: g_truncate_staging := 'N';
2268:
2269: g_state := 'Updating records with missing primary rates in FII_AP_INV_STG table';
2270: if g_debug_flag = 'Y' then
2271: FII_UTIL.put_line('');
2272: FII_UTIL.put_line('---------------------------------------------------------------------');
2273: FII_UTIL.put_line('Updating records with missing primary rates in FII_AP_INV_STG table ');
2274: FII_UTIL.start_timer;
2275: end if;

Line 2272: FII_UTIL.put_line('---------------------------------------------------------------------');

2268:
2269: g_state := 'Updating records with missing primary rates in FII_AP_INV_STG table';
2270: if g_debug_flag = 'Y' then
2271: FII_UTIL.put_line('');
2272: FII_UTIL.put_line('---------------------------------------------------------------------');
2273: FII_UTIL.put_line('Updating records with missing primary rates in FII_AP_INV_STG table ');
2274: FII_UTIL.start_timer;
2275: end if;
2276:

Line 2273: FII_UTIL.put_line('Updating records with missing primary rates in FII_AP_INV_STG table ');

2269: g_state := 'Updating records with missing primary rates in FII_AP_INV_STG table';
2270: if g_debug_flag = 'Y' then
2271: FII_UTIL.put_line('');
2272: FII_UTIL.put_line('---------------------------------------------------------------------');
2273: FII_UTIL.put_line('Updating records with missing primary rates in FII_AP_INV_STG table ');
2274: FII_UTIL.start_timer;
2275: end if;
2276:
2277: --modified by ilavenil to handle future dated transaction. The change is usage of least(...,sysdate)

Line 2274: FII_UTIL.start_timer;

2270: if g_debug_flag = 'Y' then
2271: FII_UTIL.put_line('');
2272: FII_UTIL.put_line('---------------------------------------------------------------------');
2273: FII_UTIL.put_line('Updating records with missing primary rates in FII_AP_INV_STG table ');
2274: FII_UTIL.start_timer;
2275: end if;
2276:
2277: --modified by ilavenil to handle future dated transaction. The change is usage of least(...,sysdate)
2278: UPDATE FII_AP_INV_STG stg

Line 2286: FII_UTIL.put_line('');

2282: WHERE stg.PRIM_CONVERSION_RATE < 0;
2283:
2284: l_rowcount := SQL%ROWCOUNT;
2285: if g_debug_flag = 'Y' then
2286: FII_UTIL.put_line('');
2287: FII_UTIL.put_line('Updated ' || l_rowcount || ' records for primary conversion rate');
2288: FII_UTIL.stop_timer;
2289: FII_UTIL.print_timer('Duration');
2290:

Line 2287: FII_UTIL.put_line('Updated ' || l_rowcount || ' records for primary conversion rate');

2283:
2284: l_rowcount := SQL%ROWCOUNT;
2285: if g_debug_flag = 'Y' then
2286: FII_UTIL.put_line('');
2287: FII_UTIL.put_line('Updated ' || l_rowcount || ' records for primary conversion rate');
2288: FII_UTIL.stop_timer;
2289: FII_UTIL.print_timer('Duration');
2290:
2291: FII_UTIL.put_line('');

Line 2288: FII_UTIL.stop_timer;

2284: l_rowcount := SQL%ROWCOUNT;
2285: if g_debug_flag = 'Y' then
2286: FII_UTIL.put_line('');
2287: FII_UTIL.put_line('Updated ' || l_rowcount || ' records for primary conversion rate');
2288: FII_UTIL.stop_timer;
2289: FII_UTIL.print_timer('Duration');
2290:
2291: FII_UTIL.put_line('');
2292: FII_UTIL.put_line('---------------------------------------------------------------------');

Line 2289: FII_UTIL.print_timer('Duration');

2285: if g_debug_flag = 'Y' then
2286: FII_UTIL.put_line('');
2287: FII_UTIL.put_line('Updated ' || l_rowcount || ' records for primary conversion rate');
2288: FII_UTIL.stop_timer;
2289: FII_UTIL.print_timer('Duration');
2290:
2291: FII_UTIL.put_line('');
2292: FII_UTIL.put_line('---------------------------------------------------------------------');
2293: FII_UTIL.put_line('Updating records with missing secondary rates in FII_AP_INV_STG table ');

Line 2291: FII_UTIL.put_line('');

2287: FII_UTIL.put_line('Updated ' || l_rowcount || ' records for primary conversion rate');
2288: FII_UTIL.stop_timer;
2289: FII_UTIL.print_timer('Duration');
2290:
2291: FII_UTIL.put_line('');
2292: FII_UTIL.put_line('---------------------------------------------------------------------');
2293: FII_UTIL.put_line('Updating records with missing secondary rates in FII_AP_INV_STG table ');
2294: FII_UTIL.start_timer;
2295: end if;

Line 2292: FII_UTIL.put_line('---------------------------------------------------------------------');

2288: FII_UTIL.stop_timer;
2289: FII_UTIL.print_timer('Duration');
2290:
2291: FII_UTIL.put_line('');
2292: FII_UTIL.put_line('---------------------------------------------------------------------');
2293: FII_UTIL.put_line('Updating records with missing secondary rates in FII_AP_INV_STG table ');
2294: FII_UTIL.start_timer;
2295: end if;
2296: g_state := 'Updating records with missing secondary rates in FII_AP_INV_STG table ';

Line 2293: FII_UTIL.put_line('Updating records with missing secondary rates in FII_AP_INV_STG table ');

2289: FII_UTIL.print_timer('Duration');
2290:
2291: FII_UTIL.put_line('');
2292: FII_UTIL.put_line('---------------------------------------------------------------------');
2293: FII_UTIL.put_line('Updating records with missing secondary rates in FII_AP_INV_STG table ');
2294: FII_UTIL.start_timer;
2295: end if;
2296: g_state := 'Updating records with missing secondary rates in FII_AP_INV_STG table ';
2297:

Line 2294: FII_UTIL.start_timer;

2290:
2291: FII_UTIL.put_line('');
2292: FII_UTIL.put_line('---------------------------------------------------------------------');
2293: FII_UTIL.put_line('Updating records with missing secondary rates in FII_AP_INV_STG table ');
2294: FII_UTIL.start_timer;
2295: end if;
2296: g_state := 'Updating records with missing secondary rates in FII_AP_INV_STG table ';
2297:
2298: --modified by ilavenil to handle future dated transaction. The change is usage of least(...,sysdate)

Line 2307: FII_UTIL.put_line('');

2303: WHERE stg.SEC_CONVERSION_RATE < 0;
2304:
2305: l_rowcount := SQL%ROWCOUNT;
2306: if g_debug_flag = 'Y' then
2307: FII_UTIL.put_line('');
2308: FII_UTIL.put_line('Updated ' || l_rowcount || ' records for secondary conversion rate');
2309: FII_UTIL.stop_timer;
2310: FII_UTIL.print_timer('Duration');
2311: end if;

Line 2308: FII_UTIL.put_line('Updated ' || l_rowcount || ' records for secondary conversion rate');

2304:
2305: l_rowcount := SQL%ROWCOUNT;
2306: if g_debug_flag = 'Y' then
2307: FII_UTIL.put_line('');
2308: FII_UTIL.put_line('Updated ' || l_rowcount || ' records for secondary conversion rate');
2309: FII_UTIL.stop_timer;
2310: FII_UTIL.print_timer('Duration');
2311: end if;
2312:

Line 2309: FII_UTIL.stop_timer;

2305: l_rowcount := SQL%ROWCOUNT;
2306: if g_debug_flag = 'Y' then
2307: FII_UTIL.put_line('');
2308: FII_UTIL.put_line('Updated ' || l_rowcount || ' records for secondary conversion rate');
2309: FII_UTIL.stop_timer;
2310: FII_UTIL.print_timer('Duration');
2311: end if;
2312:
2313: COMMIT;

Line 2310: FII_UTIL.print_timer('Duration');

2306: if g_debug_flag = 'Y' then
2307: FII_UTIL.put_line('');
2308: FII_UTIL.put_line('Updated ' || l_rowcount || ' records for secondary conversion rate');
2309: FII_UTIL.stop_timer;
2310: FII_UTIL.print_timer('Duration');
2311: end if;
2312:
2313: COMMIT;
2314:

Line 2351: FII_UTIL.start_timer;

2347: -- records from the staging table into the summary table
2348: -----------------------------------------------------------------------
2349: ELSE
2350: if g_debug_flag = 'Y' then
2351: FII_UTIL.start_timer;
2352: end if;
2353:
2354: IF p_program_type = 'L' THEN --Initial Load
2355: INSERT_INTO_SUMMARY(p_parallel_query);

Line 2399: FII_UTIL.stop_timer;

2395:
2396: END IF;
2397:
2398: if g_debug_flag = 'Y' then
2399: FII_UTIL.stop_timer;
2400: end if;
2401:
2402: -------------------------------------------------------------------
2403: -- After we have merged the records from the staging table into the

Line 2427: FII_UTIL.put_line('return code is ' || retcode);

2423:
2424: END IF; /* IF (VERIFY_MISSING_RATES = -1) */
2425:
2426: if g_debug_flag = 'Y' then
2427: FII_UTIL.put_line('return code is ' || retcode);
2428: end if;
2429:
2430: Retcode := g_retcode;
2431:

Line 2442: FII_UTIL.put_line('Error occured while ' || g_state);

2438: EXCEPTION
2439: WHEN G_IMP_NOT_SET THEN
2440: retcode:=g_retcode;
2441: g_exception_msg := g_retcode || ':' || g_errbuf;
2442: FII_UTIL.put_line('Error occured while ' || g_state);
2443: FII_UTIL.put_line(g_exception_msg);
2444:
2445: WHEN G_MISSING_RATES THEN
2446: retcode := g_retcode;

Line 2443: FII_UTIL.put_line(g_exception_msg);

2439: WHEN G_IMP_NOT_SET THEN
2440: retcode:=g_retcode;
2441: g_exception_msg := g_retcode || ':' || g_errbuf;
2442: FII_UTIL.put_line('Error occured while ' || g_state);
2443: FII_UTIL.put_line(g_exception_msg);
2444:
2445: WHEN G_MISSING_RATES THEN
2446: retcode := g_retcode;
2447: g_exception_msg := g_retcode || ':' || g_errbuf;

Line 2448: FII_UTIL.put_line('Error occured while ' || g_state);

2444:
2445: WHEN G_MISSING_RATES THEN
2446: retcode := g_retcode;
2447: g_exception_msg := g_retcode || ':' || g_errbuf;
2448: FII_UTIL.put_line('Error occured while ' || g_state);
2449: FII_UTIL.put_line(g_exception_msg);
2450:
2451: WHEN OTHERS THEN
2452: g_errbuf:=g_errbuf;

Line 2449: FII_UTIL.put_line(g_exception_msg);

2445: WHEN G_MISSING_RATES THEN
2446: retcode := g_retcode;
2447: g_exception_msg := g_retcode || ':' || g_errbuf;
2448: FII_UTIL.put_line('Error occured while ' || g_state);
2449: FII_UTIL.put_line(g_exception_msg);
2450:
2451: WHEN OTHERS THEN
2452: g_errbuf:=g_errbuf;
2453: g_retcode:= -1;

Line 2456: FII_UTIL.put_line('Error occured while ' || g_state);

2452: g_errbuf:=g_errbuf;
2453: g_retcode:= -1;
2454: retcode:=g_retcode;
2455: g_exception_msg := g_retcode || ':' || g_errbuf;
2456: FII_UTIL.put_line('Error occured while ' || g_state);
2457: FII_UTIL.put_line(g_exception_msg);
2458:
2459: ---------------------------------------------------------------
2460: -- Truncating the staging table so the next time the program

Line 2457: FII_UTIL.put_line(g_exception_msg);

2453: g_retcode:= -1;
2454: retcode:=g_retcode;
2455: g_exception_msg := g_retcode || ':' || g_errbuf;
2456: FII_UTIL.put_line('Error occured while ' || g_state);
2457: FII_UTIL.put_line(g_exception_msg);
2458:
2459: ---------------------------------------------------------------
2460: -- Truncating the staging table so the next time the program
2461: -- is ran, the program will start from beginning. If we leave

Line 2477: FII_UTIL.put_line('Restoring AP_DBI_LOG table to its original state');

2473: -- When exception occurs, we need to restore the AP_DBI_LOG table
2474: -- to its original state by setting those records back to 'N'.
2475: -- THose records will be re-processed in the next run.
2476: -----------------------------------------------------------------
2477: FII_UTIL.put_line('Restoring AP_DBI_LOG table to its original state');
2478:
2479: IF p_program_type = 'L' THEN
2480: UPDATE ap_dbi_log log
2481: SET exp_processed_flag = 'N'

Line 2536: FII_UTIL.put_line(' ');

2532: g_start_date := nvl(l_last_period_from, bis_common_parameters.get_global_start_date);
2533:
2534:
2535: if g_debug_flag = 'Y' then
2536: FII_UTIL.put_line(' ');
2537: FII_UTIL.put_timestamp;
2538: FII_UTIL.put_line('Worker '||p_worker_no||' Starting');
2539: end if;
2540:

Line 2537: FII_UTIL.put_timestamp;

2533:
2534:
2535: if g_debug_flag = 'Y' then
2536: FII_UTIL.put_line(' ');
2537: FII_UTIL.put_timestamp;
2538: FII_UTIL.put_line('Worker '||p_worker_no||' Starting');
2539: end if;
2540:
2541: -- ------------------------------------------

Line 2538: FII_UTIL.put_line('Worker '||p_worker_no||' Starting');

2534:
2535: if g_debug_flag = 'Y' then
2536: FII_UTIL.put_line(' ');
2537: FII_UTIL.put_timestamp;
2538: FII_UTIL.put_line('Worker '||p_worker_no||' Starting');
2539: end if;
2540:
2541: -- ------------------------------------------
2542: -- Initalization

Line 2546: FII_UTIL.put_line(' ');

2542: -- Initalization
2543: -- ------------------------------------------
2544:
2545: if g_debug_flag = 'Y' then
2546: FII_UTIL.put_line(' ');
2547: FII_UTIL.put_line('Initialization');
2548: end if;
2549: INIT;
2550:

Line 2547: FII_UTIL.put_line('Initialization');

2543: -- ------------------------------------------
2544:
2545: if g_debug_flag = 'Y' then
2546: FII_UTIL.put_line(' ');
2547: FII_UTIL.put_line('Initialization');
2548: end if;
2549: INIT;
2550:
2551: --g_worker_num := p_worker_no;

Line 2573: FII_UTIL.put_line('');

2569: FROM FII_AP_SUM_WORK_JOBS;
2570:
2571: IF (l_failed_cnt > 0) THEN
2572: if g_debug_flag = 'Y' then
2573: FII_UTIL.put_line('');
2574: FII_UTIL.put_line('Another worker have errored out. Stop processing.');
2575: end if;
2576: EXIT;
2577: ELSIF (l_unassigned_cnt = 0) THEN

Line 2574: FII_UTIL.put_line('Another worker have errored out. Stop processing.');

2570:
2571: IF (l_failed_cnt > 0) THEN
2572: if g_debug_flag = 'Y' then
2573: FII_UTIL.put_line('');
2574: FII_UTIL.put_line('Another worker have errored out. Stop processing.');
2575: end if;
2576: EXIT;
2577: ELSIF (l_unassigned_cnt = 0) THEN
2578: if g_debug_flag = 'Y' then

Line 2579: FII_UTIL.put_line('');

2575: end if;
2576: EXIT;
2577: ELSIF (l_unassigned_cnt = 0) THEN
2578: if g_debug_flag = 'Y' then
2579: FII_UTIL.put_line('');
2580: FII_UTIL.put_line('No more jobs left. Terminating.');
2581: end if;
2582: EXIT;
2583: ELSIF (l_curr_comp_cnt = l_curr_tot_cnt) THEN

Line 2580: FII_UTIL.put_line('No more jobs left. Terminating.');

2576: EXIT;
2577: ELSIF (l_unassigned_cnt = 0) THEN
2578: if g_debug_flag = 'Y' then
2579: FII_UTIL.put_line('');
2580: FII_UTIL.put_line('No more jobs left. Terminating.');
2581: end if;
2582: EXIT;
2583: ELSIF (l_curr_comp_cnt = l_curr_tot_cnt) THEN
2584: if g_debug_flag = 'Y' then

Line 2585: FII_UTIL.put_line('');

2581: end if;
2582: EXIT;
2583: ELSIF (l_curr_comp_cnt = l_curr_tot_cnt) THEN
2584: if g_debug_flag = 'Y' then
2585: FII_UTIL.put_line('');
2586: FII_UTIL.put_line('All jobs completed, no more job. Terminating');
2587: end if;
2588: EXIT;
2589: ELSIF (l_curr_unasgn_cnt > 0) THEN

Line 2586: FII_UTIL.put_line('All jobs completed, no more job. Terminating');

2582: EXIT;
2583: ELSIF (l_curr_comp_cnt = l_curr_tot_cnt) THEN
2584: if g_debug_flag = 'Y' then
2585: FII_UTIL.put_line('');
2586: FII_UTIL.put_line('All jobs completed, no more job. Terminating');
2587: end if;
2588: EXIT;
2589: ELSIF (l_curr_unasgn_cnt > 0) THEN
2590: UPDATE FII_AP_SUM_WORK_JOBS

Line 2617: FII_UTIL.put_line(g_phase);

2613: AND jobs.status = 'IN PROCESS';
2614:
2615: g_phase := 'Bypassing SLA security.';
2616: if g_debug_flag = 'Y' then
2617: FII_UTIL.put_line(g_phase);
2618: end if;
2619:
2620: xla_security_pkg.set_security_context(p_application_id => 602);
2621:

Line 2626: FII_UTIL.start_timer;

2622: ---------------------------------------------------------
2623: --Do summarization using the start_range and end_range
2624: ---------------------------------------------------------
2625: if g_debug_flag = 'Y' then
2626: FII_UTIL.start_timer;
2627: end if;
2628: POPULATE_AP_SUM_STG (l_start_range, l_end_range, l_phase);
2629: if g_debug_flag = 'Y' then
2630: FII_UTIL.stop_timer;

Line 2630: FII_UTIL.stop_timer;

2626: FII_UTIL.start_timer;
2627: end if;
2628: POPULATE_AP_SUM_STG (l_start_range, l_end_range, l_phase);
2629: if g_debug_flag = 'Y' then
2630: FII_UTIL.stop_timer;
2631: FII_UTIL.print_timer('Duration');
2632: end if;
2633:
2634: UPDATE FII_AP_SUM_WORK_JOBS jobs

Line 2631: FII_UTIL.print_timer('Duration');

2627: end if;
2628: POPULATE_AP_SUM_STG (l_start_range, l_end_range, l_phase);
2629: if g_debug_flag = 'Y' then
2630: FII_UTIL.stop_timer;
2631: FII_UTIL.print_timer('Duration');
2632: end if;
2633:
2634: UPDATE FII_AP_SUM_WORK_JOBS jobs
2635: SET jobs.status = 'COMPLETED'

Line 2663: FII_UTIL.put_line(Errbuf);

2659: Errbuf := '
2660: ---------------------------------
2661: Error in Procedure: WORKER
2662: Message: '||sqlerrm;
2663: FII_UTIL.put_line(Errbuf);
2664:
2665: -------------------------------------------
2666: -- Update the WORKER_JOBS table to indicate
2667: -- this job has failed