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_SUM_INIT dependencies on FII_UTIL

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

73: l_stmt VARCHAR2(100);
74: BEGIN
75: l_stmt := 'TRUNCATE table '||g_fii_schema||'.'||p_table_name;
76: if g_debug_flag = 'Y' then
77: FII_UTIL.put_line('g_fii_schema '||g_fii_schema);
78: FII_UTIL.put_line('');
79: FII_UTIL.put_line(l_stmt);
80: end if;
81: EXECUTE IMMEDIATE l_stmt;

Line 78: FII_UTIL.put_line('');

74: BEGIN
75: l_stmt := 'TRUNCATE table '||g_fii_schema||'.'||p_table_name;
76: if g_debug_flag = 'Y' then
77: FII_UTIL.put_line('g_fii_schema '||g_fii_schema);
78: FII_UTIL.put_line('');
79: FII_UTIL.put_line(l_stmt);
80: end if;
81: EXECUTE IMMEDIATE l_stmt;
82:

Line 79: FII_UTIL.put_line(l_stmt);

75: l_stmt := 'TRUNCATE table '||g_fii_schema||'.'||p_table_name;
76: if g_debug_flag = 'Y' then
77: FII_UTIL.put_line('g_fii_schema '||g_fii_schema);
78: FII_UTIL.put_line('');
79: FII_UTIL.put_line(l_stmt);
80: end if;
81: EXECUTE IMMEDIATE l_stmt;
82:
83: EXCEPTION

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

111:
112: IF (FND_INSTALLATION.GET_APP_INFO('FII', l_status, l_industry, g_fii_schema)) THEN
113: NULL;
114: if g_debug_flag = 'Y' then
115: FII_UTIL.put_line('g_fii_schema is '||g_fii_schema);
116: end if;
117: END IF;
118:
119: -- --------------------------------------------------------

Line 123: g_ap_schema := FII_UTIL.get_schema_name('SQLAP');

119: -- --------------------------------------------------------
120: -- Find the schema owner (AP)
121: -- --------------------------------------------------------
122:
123: g_ap_schema := FII_UTIL.get_schema_name('SQLAP');
124: if g_debug_flag = 'Y' then
125: FII_UTIL.put_line('g_ap_schema is '||g_ap_schema);
126: end if;
127:

Line 125: FII_UTIL.put_line('g_ap_schema is '||g_ap_schema);

121: -- --------------------------------------------------------
122:
123: g_ap_schema := FII_UTIL.get_schema_name('SQLAP');
124: if g_debug_flag = 'Y' then
125: FII_UTIL.put_line('g_ap_schema is '||g_ap_schema);
126: end if;
127:
128:
129: if g_debug_flag = 'Y' then

Line 130: FII_UTIL.put_line('Initializing the Global Currency Precision');

126: end if;
127:
128:
129: if g_debug_flag = 'Y' then
130: FII_UTIL.put_line('Initializing the Global Currency Precision');
131: end if;
132:
133: g_primary_mau := nvl(fii_currency.get_mau_primary, 0.01 );
134: g_secondary_mau:= nvl(fii_currency.get_mau_secondary, 0.01);

Line 137: FII_UTIL.put_line('Initializing the Global Currencies');

133: g_primary_mau := nvl(fii_currency.get_mau_primary, 0.01 );
134: g_secondary_mau:= nvl(fii_currency.get_mau_secondary, 0.01);
135:
136: if g_debug_flag = 'Y' then
137: FII_UTIL.put_line('Initializing the Global Currencies');
138: end if;
139:
140: g_prim_currency := bis_common_parameters.get_currency_code;
141: g_sec_currency := bis_common_parameters.get_secondary_currency_code;

Line 144: FII_UTIL.put_line('Initializing Global Currency Rate Types');

140: g_prim_currency := bis_common_parameters.get_currency_code;
141: g_sec_currency := bis_common_parameters.get_secondary_currency_code;
142:
143: if g_debug_flag = 'Y' then
144: FII_UTIL.put_line('Initializing Global Currency Rate Types');
145: end if;
146:
147: g_prim_rate_type := bis_common_parameters.get_rate_type;
148: g_sec_rate_type := bis_common_parameters.get_secondary_rate_type;

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

166: RAISE G_LOGIN_INFO_NOT_AVABLE;
167: END IF;
168:
169: if g_debug_flag = 'Y' then
170: FII_UTIL.put_line('User ID: ' || g_fii_user_id || ' Login ID: ' || g_fii_login_id);
171: end if;
172:
173: EXCEPTION
174: WHEN G_LOGIN_INFO_NOT_AVABLE THEN

Line 209: FII_UTIL.put_line(g_state);

205: l_stmt VARCHAR2(100);
206: BEGIN
207: g_state := 'Inside the procedure CHILD_SETUP';
208: if g_debug_flag = 'Y' then
209: FII_UTIL.put_line(g_state);
210: end if;
211:
212: ------------------------------------------------------
213: -- Set default directory in case if the profile option

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

215: ------------------------------------------------------
216: l_dir:='/sqlcom/log';
217:
218: ----------------------------------------------------------------
219: -- fii_util.initialize will get profile options FII_DEBUG_MODE
220: -- and BIS_DEBUG_LOG_DIRECTORY and set up the directory where
221: -- the log files and output files are written to
222: ----------------------------------------------------------------
223: FII_UTIL.initialize(p_object_name||'.log',p_object_name||'.out',l_dir,'FII_AP_INV_SUM_INIT_Worker');

Line 223: FII_UTIL.initialize(p_object_name||'.log',p_object_name||'.out',l_dir,'FII_AP_INV_SUM_INIT_Worker');

219: -- fii_util.initialize will get profile options FII_DEBUG_MODE
220: -- and BIS_DEBUG_LOG_DIRECTORY and set up the directory where
221: -- the log files and output files are written to
222: ----------------------------------------------------------------
223: FII_UTIL.initialize(p_object_name||'.log',p_object_name||'.out',l_dir,'FII_AP_INV_SUM_INIT_Worker');
224:
225: g_fii_user_id := FND_GLOBAL.User_Id;
226: g_fii_login_id := FND_GLOBAL.Login_Id;
227:

Line 257: FII_UTIL.put_line('Register jobs for workers');

253: BEGIN
254:
255: g_state := 'Register jobs for workers';
256: if g_debug_flag = 'Y' then
257: FII_UTIL.put_line('Register jobs for workers');
258: end if;
259:
260: SELECT max(invoice_ID), min(invoice_ID), COUNT(*)
261: INTO l_max_number, l_start_number, l_inv_count

Line 296: FII_UTIL.put_line('Inserted ' || l_count || ' jobs into FII_AP_PS_WORK_JOBS table');

292: l_start_number := least(l_end_number, l_max_number) + 1;
293: END LOOP;
294:
295: if g_debug_flag = 'Y' then
296: FII_UTIL.put_line('Inserted ' || l_count || ' jobs into FII_AP_PS_WORK_JOBS table');
297: end if;
298:
299: EXCEPTION
300: WHEN OTHERS THEN

Line 325: FII_UTIL.put_line(g_state);

321:
322:
323: g_state := 'Inside Launch Worker procedure for worker ' || p_worker_no;
324: if g_debug_flag = 'Y' then
325: FII_UTIL.put_line(g_state);
326: end if;
327:
328: l_request_id := FND_REQUEST.SUBMIT_REQUEST
329: ('FII',

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

351:
352: EXCEPTION
353: WHEN G_NO_CHILD_PROCESS THEN
354: g_retcode := -1;
355: FII_UTIL.put_line('No child process launched');
356: RAISE;
357: WHEN OTHERS THEN
358: ROLLBACK;
359: g_retcode := -2;

Line 390: FII_UTIL.put_line('Register jobs for workers');

386: BEGIN
387:
388: g_state := 'Inside Monitor Workers';
389: if g_debug_flag = 'Y' then
390: FII_UTIL.put_line('Register jobs for workers');
391: end if;
392:
393: LOOP
394:

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

404: l_tot_cnt
405: FROM FII_AP_PS_WORK_JOBS;
406:
407: if g_debug_flag = 'Y' then
408: FII_UTIL.put_line('Job status - Unassigned:'||l_unassigned_cnt||
409: ' In Process:'||l_wip_cnt||
410: ' Completed:'||l_completed_cnt||
411: ' Failed:'||l_failed_cnt);
412: end if;

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

428:
429: IF l_tot_cnt = l_completed_cnt THEN
430:
431: if g_debug_flag = 'Y' then
432: FII_UTIL.put_line('Job status - Total: '|| l_tot_cnt);
433: end if;
434: EXIT;
435: END IF;
436:

Line 477: FII_UTIL.stop_timer;

473:
474: END LOOP;
475:
476: if g_debug_flag = 'Y' then
477: FII_UTIL.stop_timer;
478: FII_UTIL.print_timer('Duration');
479: end if;
480:
481:

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

474: END LOOP;
475:
476: if g_debug_flag = 'Y' then
477: FII_UTIL.stop_timer;
478: FII_UTIL.print_timer('Duration');
479: end if;
480:
481:
482: EXCEPTION

Line 510: FII_UTIL.put_line('');

506: BEGIN
507:
508: g_state := 'Inserting records into the FII_AP_WH_TAX_T table';
509: if g_debug_flag = 'Y' then
510: FII_UTIL.put_line('');
511: FII_UTIL.put_line(g_state);
512: fii_util.start_timer;
513: fii_util.put_line('');
514: end if;

Line 511: FII_UTIL.put_line(g_state);

507:
508: g_state := 'Inserting records into the FII_AP_WH_TAX_T table';
509: if g_debug_flag = 'Y' then
510: FII_UTIL.put_line('');
511: FII_UTIL.put_line(g_state);
512: fii_util.start_timer;
513: fii_util.put_line('');
514: end if;
515:

Line 512: fii_util.start_timer;

508: g_state := 'Inserting records into the FII_AP_WH_TAX_T table';
509: if g_debug_flag = 'Y' then
510: FII_UTIL.put_line('');
511: FII_UTIL.put_line(g_state);
512: fii_util.start_timer;
513: fii_util.put_line('');
514: end if;
515:
516:

Line 513: fii_util.put_line('');

509: if g_debug_flag = 'Y' then
510: FII_UTIL.put_line('');
511: FII_UTIL.put_line(g_state);
512: fii_util.start_timer;
513: fii_util.put_line('');
514: end if;
515:
516:
517: /* Selecting the prorated prepayment and withholding amount for a

Line 581: fii_util.put_line('Inserted '||SQL%ROWCOUNT||' records into FII_AP_WH_TAX_T');

577: FC.Minimum_Accountable_Unit;
578:
579:
580: if g_debug_flag = 'Y' then
581: fii_util.put_line('Inserted '||SQL%ROWCOUNT||' records into FII_AP_WH_TAX_T');
582: fii_util.stop_timer;
583: fii_util.print_timer('Duration');
584: end if;
585:

Line 582: fii_util.stop_timer;

578:
579:
580: if g_debug_flag = 'Y' then
581: fii_util.put_line('Inserted '||SQL%ROWCOUNT||' records into FII_AP_WH_TAX_T');
582: fii_util.stop_timer;
583: fii_util.print_timer('Duration');
584: end if;
585:
586: FND_STATS.GATHER_TABLE_STATS(OWNNAME => 'FII', TABNAME => 'FII_AP_WH_TAX_T');

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

579:
580: if g_debug_flag = 'Y' then
581: fii_util.put_line('Inserted '||SQL%ROWCOUNT||' records into FII_AP_WH_TAX_T');
582: fii_util.stop_timer;
583: fii_util.print_timer('Duration');
584: end if;
585:
586: FND_STATS.GATHER_TABLE_STATS(OWNNAME => 'FII', TABNAME => 'FII_AP_WH_TAX_T');
587: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';

Line 595: FII_UTIL.put_line('');

591:
592:
593: g_state := 'Inserting records into the FII_AP_Prepay_T table';
594: if g_debug_flag = 'Y' then
595: FII_UTIL.put_line('');
596: FII_UTIL.put_line(g_state);
597: fii_util.start_timer;
598: fii_util.put_line('');
599: end if;

Line 596: FII_UTIL.put_line(g_state);

592:
593: g_state := 'Inserting records into the FII_AP_Prepay_T table';
594: if g_debug_flag = 'Y' then
595: FII_UTIL.put_line('');
596: FII_UTIL.put_line(g_state);
597: fii_util.start_timer;
598: fii_util.put_line('');
599: end if;
600:

Line 597: fii_util.start_timer;

593: g_state := 'Inserting records into the FII_AP_Prepay_T table';
594: if g_debug_flag = 'Y' then
595: FII_UTIL.put_line('');
596: FII_UTIL.put_line(g_state);
597: fii_util.start_timer;
598: fii_util.put_line('');
599: end if;
600:
601: INSERT /*+ append parallel(T) */ INTO fii_ap_prepay_t T

Line 598: fii_util.put_line('');

594: if g_debug_flag = 'Y' then
595: FII_UTIL.put_line('');
596: FII_UTIL.put_line(g_state);
597: fii_util.start_timer;
598: fii_util.put_line('');
599: end if;
600:
601: INSERT /*+ append parallel(T) */ INTO fii_ap_prepay_t T
602: (Invoice_ID,

Line 725: fii_util.put_line('Inserted '||SQL%ROWCOUNT||' records into FII_AP_Prepay_T');

721: (AID_Prepay.First + 1 <= PS_Prepay.First_PP + 1 AND PS_Prepay.First_PP + 1 <= AID_Prepay.Last));
722:
723:
724: if g_debug_flag = 'Y' then
725: fii_util.put_line('Inserted '||SQL%ROWCOUNT||' records into FII_AP_Prepay_T');
726: fii_util.stop_timer;
727: fii_util.print_timer('Duration');
728: end if;
729:

Line 726: fii_util.stop_timer;

722:
723:
724: if g_debug_flag = 'Y' then
725: fii_util.put_line('Inserted '||SQL%ROWCOUNT||' records into FII_AP_Prepay_T');
726: fii_util.stop_timer;
727: fii_util.print_timer('Duration');
728: end if;
729:
730:

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

723:
724: if g_debug_flag = 'Y' then
725: fii_util.put_line('Inserted '||SQL%ROWCOUNT||' records into FII_AP_Prepay_T');
726: fii_util.stop_timer;
727: fii_util.print_timer('Duration');
728: end if;
729:
730:
731: FND_STATS.GATHER_TABLE_STATS(OWNNAME => 'FII', TABNAME => 'FII_AP_PREPAY_T');

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

738: WHEN OTHERS THEN
739: g_errbuf:=sqlerrm;
740: g_retcode:= -1;
741: g_exception_msg := g_retcode || ':' || g_errbuf;
742: FII_UTIL.put_line('Error occured while ' || g_state);
743: FII_UTIL.put_line(g_exception_msg);
744: RAISE;
745:
746: END Insert_WH_Prepay_Amount;

Line 743: FII_UTIL.put_line(g_exception_msg);

739: g_errbuf:=sqlerrm;
740: g_retcode:= -1;
741: g_exception_msg := g_retcode || ':' || g_errbuf;
742: FII_UTIL.put_line('Error occured while ' || g_state);
743: FII_UTIL.put_line(g_exception_msg);
744: RAISE;
745:
746: END Insert_WH_Prepay_Amount;
747:

Line 761: FII_UTIL.put_line('');

757: BEGIN
758:
759: g_state := 'Inserting records into the FII_AP_PAY_CHK_STG table';
760: if g_debug_flag = 'Y' then
761: FII_UTIL.put_line('');
762: FII_UTIL.put_line(g_state);
763: fii_util.start_timer;
764: fii_util.put_line('');
765: end if;

Line 762: FII_UTIL.put_line(g_state);

758:
759: g_state := 'Inserting records into the FII_AP_PAY_CHK_STG table';
760: if g_debug_flag = 'Y' then
761: FII_UTIL.put_line('');
762: FII_UTIL.put_line(g_state);
763: fii_util.start_timer;
764: fii_util.put_line('');
765: end if;
766:

Line 763: fii_util.start_timer;

759: g_state := 'Inserting records into the FII_AP_PAY_CHK_STG table';
760: if g_debug_flag = 'Y' then
761: FII_UTIL.put_line('');
762: FII_UTIL.put_line(g_state);
763: fii_util.start_timer;
764: fii_util.put_line('');
765: end if;
766:
767:

Line 764: fii_util.put_line('');

760: if g_debug_flag = 'Y' then
761: FII_UTIL.put_line('');
762: FII_UTIL.put_line(g_state);
763: fii_util.start_timer;
764: fii_util.put_line('');
765: end if;
766:
767:
768: INSERT /*+ append parallel(S) */ INTO FII_AP_PAY_CHK_STG S

Line 805: fii_util.put_line('Inserted '||SQL%ROWCOUNT||' records into FII_AP_PAY_CHK_STG');

801: AND AC.Check_ID = AIP.Check_ID
802: AND AC.Void_Date IS NULL;
803:
804: if g_debug_flag = 'Y' then
805: fii_util.put_line('Inserted '||SQL%ROWCOUNT||' records into FII_AP_PAY_CHK_STG');
806: fii_util.stop_timer;
807: fii_util.print_timer('Duration');
808: end if;
809:

Line 806: fii_util.stop_timer;

802: AND AC.Void_Date IS NULL;
803:
804: if g_debug_flag = 'Y' then
805: fii_util.put_line('Inserted '||SQL%ROWCOUNT||' records into FII_AP_PAY_CHK_STG');
806: fii_util.stop_timer;
807: fii_util.print_timer('Duration');
808: end if;
809:
810: FND_STATS.GATHER_TABLE_STATS(OWNNAME => 'FII', TABNAME => 'FII_AP_PAY_CHK_STG');

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

803:
804: if g_debug_flag = 'Y' then
805: fii_util.put_line('Inserted '||SQL%ROWCOUNT||' records into FII_AP_PAY_CHK_STG');
806: fii_util.stop_timer;
807: fii_util.print_timer('Duration');
808: end if;
809:
810: FND_STATS.GATHER_TABLE_STATS(OWNNAME => 'FII', TABNAME => 'FII_AP_PAY_CHK_STG');
811: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';

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

816: WHEN OTHERS THEN
817: g_errbuf:=sqlerrm;
818: g_retcode:= -1;
819: g_exception_msg := g_retcode || ':' || g_errbuf;
820: FII_UTIL.put_line('Error occured while ' || g_state);
821: FII_UTIL.put_line(g_exception_msg);
822: RAISE;
823:
824: END Insert_Payment_Check_Info;

Line 821: FII_UTIL.put_line(g_exception_msg);

817: g_errbuf:=sqlerrm;
818: g_retcode:= -1;
819: g_exception_msg := g_retcode || ':' || g_errbuf;
820: FII_UTIL.put_line('Error occured while ' || g_state);
821: FII_UTIL.put_line(g_exception_msg);
822: RAISE;
823:
824: END Insert_Payment_Check_Info;
825:

Line 871: fii_util.put_line(' ');

867: BEGIN
868: g_state := 'Checking to see which additional rates need to be defined, if any';
869:
870: if g_debug_flag = 'Y' then
871: fii_util.put_line(' ');
872: fii_util.put_line(g_state);
873: fii_util.start_timer;
874: fii_util.put_line('');
875: end if;

Line 872: fii_util.put_line(g_state);

868: g_state := 'Checking to see which additional rates need to be defined, if any';
869:
870: if g_debug_flag = 'Y' then
871: fii_util.put_line(' ');
872: fii_util.put_line(g_state);
873: fii_util.start_timer;
874: fii_util.put_line('');
875: end if;
876:

Line 873: fii_util.start_timer;

869:
870: if g_debug_flag = 'Y' then
871: fii_util.put_line(' ');
872: fii_util.put_line(g_state);
873: fii_util.start_timer;
874: fii_util.put_line('');
875: end if;
876:
877: BEGIN

Line 874: fii_util.put_line('');

870: if g_debug_flag = 'Y' then
871: fii_util.put_line(' ');
872: fii_util.put_line(g_state);
873: fii_util.start_timer;
874: fii_util.put_line('');
875: end if;
876:
877: BEGIN
878: SELECT 1

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

953: WHEN OTHERS THEN
954: g_errbuf:=sqlerrm;
955: g_retcode:= -1;
956: g_exception_msg := g_retcode || ':' || g_errbuf;
957: FII_UTIL.put_line('Error occured while ' || g_state);
958: FII_UTIL.put_line(g_exception_msg);
959: RAISE;
960: END Verify_Missing_Rates;
961:

Line 958: FII_UTIL.put_line(g_exception_msg);

954: g_errbuf:=sqlerrm;
955: g_retcode:= -1;
956: g_exception_msg := g_retcode || ':' || g_errbuf;
957: FII_UTIL.put_line('Error occured while ' || g_state);
958: FII_UTIL.put_line(g_exception_msg);
959: RAISE;
960: END Verify_Missing_Rates;
961:
962:

Line 975: fii_util.put_line(' ');

971:
972: g_state := 'Loading data into rates table';
973:
974: if g_debug_flag = 'Y' then
975: fii_util.put_line(' ');
976: fii_util.put_line(g_state);
977: fii_util.start_timer;
978: fii_util.put_line('');
979: end if;

Line 976: fii_util.put_line(g_state);

972: g_state := 'Loading data into rates table';
973:
974: if g_debug_flag = 'Y' then
975: fii_util.put_line(' ');
976: fii_util.put_line(g_state);
977: fii_util.start_timer;
978: fii_util.put_line('');
979: end if;
980:

Line 977: fii_util.start_timer;

973:
974: if g_debug_flag = 'Y' then
975: fii_util.put_line(' ');
976: fii_util.put_line(g_state);
977: fii_util.start_timer;
978: fii_util.put_line('');
979: end if;
980:
981: INSERT /*+ append parallel(T) */

Line 978: fii_util.put_line('');

974: if g_debug_flag = 'Y' then
975: fii_util.put_line(' ');
976: fii_util.put_line(g_state);
977: fii_util.start_timer;
978: fii_util.put_line('');
979: end if;
980:
981: INSERT /*+ append parallel(T) */
982: INTO FII_AP_PS_RATES_TEMP T

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

1004: AND TRUNC(AI.Creation_Date) >= g_start_date
1005: AND TRUNC(AI.Creation_Date) + 0 <= g_end_date + 0.99999);
1006:
1007: if g_debug_flag = 'Y' then
1008: fii_util.put_line('Processed '||SQL%ROWCOUNT||' rows');
1009: fii_util.stop_timer;
1010: fii_util.print_timer('Duration');
1011: end if;
1012:

Line 1009: fii_util.stop_timer;

1005: AND TRUNC(AI.Creation_Date) + 0 <= g_end_date + 0.99999);
1006:
1007: if g_debug_flag = 'Y' then
1008: fii_util.put_line('Processed '||SQL%ROWCOUNT||' rows');
1009: fii_util.stop_timer;
1010: fii_util.print_timer('Duration');
1011: end if;
1012:
1013: COMMIT;

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

1006:
1007: if g_debug_flag = 'Y' then
1008: fii_util.put_line('Processed '||SQL%ROWCOUNT||' rows');
1009: fii_util.stop_timer;
1010: fii_util.print_timer('Duration');
1011: end if;
1012:
1013: COMMIT;
1014:

Line 1016: fii_util.put_line(' ');

1012:
1013: COMMIT;
1014:
1015: if g_debug_flag = 'Y' then
1016: fii_util.put_line(' ');
1017: fii_util.put_line('Loading data into functional rates table');
1018: fii_util.start_timer;
1019: fii_util.put_line('');
1020: end if;

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

1013: COMMIT;
1014:
1015: if g_debug_flag = 'Y' then
1016: fii_util.put_line(' ');
1017: fii_util.put_line('Loading data into functional rates table');
1018: fii_util.start_timer;
1019: fii_util.put_line('');
1020: end if;
1021:

Line 1018: fii_util.start_timer;

1014:
1015: if g_debug_flag = 'Y' then
1016: fii_util.put_line(' ');
1017: fii_util.put_line('Loading data into functional rates table');
1018: fii_util.start_timer;
1019: fii_util.put_line('');
1020: end if;
1021:
1022:

Line 1019: fii_util.put_line('');

1015: if g_debug_flag = 'Y' then
1016: fii_util.put_line(' ');
1017: fii_util.put_line('Loading data into functional rates table');
1018: fii_util.start_timer;
1019: fii_util.put_line('');
1020: end if;
1021:
1022:
1023: INSERT /*+ append parallel(T)*/

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

1058: AND ASP.Base_Currency_Code = FC.Currency_Code);
1059:
1060:
1061: if g_debug_flag = 'Y' then
1062: fii_util.put_line('Processed '||SQL%ROWCOUNT||' rows');
1063: fii_util.stop_timer;
1064: fii_util.print_timer('Duration');
1065: end if;
1066:

Line 1063: fii_util.stop_timer;

1059:
1060:
1061: if g_debug_flag = 'Y' then
1062: fii_util.put_line('Processed '||SQL%ROWCOUNT||' rows');
1063: fii_util.stop_timer;
1064: fii_util.print_timer('Duration');
1065: end if;
1066:
1067: COMMIT;

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

1060:
1061: if g_debug_flag = 'Y' then
1062: fii_util.put_line('Processed '||SQL%ROWCOUNT||' rows');
1063: fii_util.stop_timer;
1064: fii_util.print_timer('Duration');
1065: end if;
1066:
1067: COMMIT;
1068:

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

1076: WHEN OTHERS THEN
1077: g_errbuf:=sqlerrm;
1078: g_retcode:= -1;
1079: g_exception_msg := g_retcode || ':' || g_errbuf;
1080: FII_UTIL.put_line('Error occured while ' || g_state);
1081: FII_UTIL.put_line(g_exception_msg);
1082: RAISE;
1083:
1084: END Insert_Rates;

Line 1081: FII_UTIL.put_line(g_exception_msg);

1077: g_errbuf:=sqlerrm;
1078: g_retcode:= -1;
1079: g_exception_msg := g_retcode || ':' || g_errbuf;
1080: FII_UTIL.put_line('Error occured while ' || g_state);
1081: FII_UTIL.put_line(g_exception_msg);
1082: RAISE;
1083:
1084: END Insert_Rates;
1085:

Line 1099: FII_UTIL.put_line('');

1095: BEGIN
1096:
1097: g_state := 'Deleting records from FII_AP_INV_HOLDS_B that are already existing';
1098: if g_debug_flag = 'Y' then
1099: FII_UTIL.put_line('');
1100: FII_UTIL.put_line(g_state);
1101: end if;
1102:
1103: /* For Initial Load we will truncate the data in the holds summary table

Line 1100: FII_UTIL.put_line(g_state);

1096:
1097: g_state := 'Deleting records from FII_AP_INV_HOLDS_B that are already existing';
1098: if g_debug_flag = 'Y' then
1099: FII_UTIL.put_line('');
1100: FII_UTIL.put_line(g_state);
1101: end if;
1102:
1103: /* For Initial Load we will truncate the data in the holds summary table
1104: and re-populate this table */

Line 1111: FII_UTIL.put_line(g_state);

1107:
1108:
1109: g_state := 'Populating FII_AP_INV_HOLDS_B FROM AP_HOLDS_ALL table';
1110: if g_debug_flag = 'Y' then
1111: FII_UTIL.put_line(g_state);
1112: FII_UTIL.start_timer;
1113: FII_UTIL.put_line('');
1114: end if;
1115:

Line 1112: FII_UTIL.start_timer;

1108:
1109: g_state := 'Populating FII_AP_INV_HOLDS_B FROM AP_HOLDS_ALL table';
1110: if g_debug_flag = 'Y' then
1111: FII_UTIL.put_line(g_state);
1112: FII_UTIL.start_timer;
1113: FII_UTIL.put_line('');
1114: end if;
1115:
1116: INSERT /*+ append parallel(S) */ INTO FII_AP_INV_HOLDS_B S

Line 1113: FII_UTIL.put_line('');

1109: g_state := 'Populating FII_AP_INV_HOLDS_B FROM AP_HOLDS_ALL table';
1110: if g_debug_flag = 'Y' then
1111: FII_UTIL.put_line(g_state);
1112: FII_UTIL.start_timer;
1113: FII_UTIL.put_line('');
1114: end if;
1115:
1116: INSERT /*+ append parallel(S) */ INTO FII_AP_INV_HOLDS_B S
1117: (Time_ID,

Line 1180: FII_UTIL.put_line('Inserted '|| SQL%ROWCOUNT ||' records into FII_AP_INV_HOLDS_B');

1176: AND TRUNC(AH.Hold_Date) >= g_start_date
1177: AND TRUNC(AH.Hold_Date) + 0 <= g_end_date + 0.99999;
1178:
1179: if g_debug_flag = 'Y' then
1180: FII_UTIL.put_line('Inserted '|| SQL%ROWCOUNT ||' records into FII_AP_INV_HOLDS_B');
1181: FII_UTIL.put_line('');
1182: FII_UTIL.stop_timer;
1183: FII_UTIL.print_timer('Duration');
1184: end if;

Line 1181: FII_UTIL.put_line('');

1177: AND TRUNC(AH.Hold_Date) + 0 <= g_end_date + 0.99999;
1178:
1179: if g_debug_flag = 'Y' then
1180: FII_UTIL.put_line('Inserted '|| SQL%ROWCOUNT ||' records into FII_AP_INV_HOLDS_B');
1181: FII_UTIL.put_line('');
1182: FII_UTIL.stop_timer;
1183: FII_UTIL.print_timer('Duration');
1184: end if;
1185:

Line 1182: FII_UTIL.stop_timer;

1178:
1179: if g_debug_flag = 'Y' then
1180: FII_UTIL.put_line('Inserted '|| SQL%ROWCOUNT ||' records into FII_AP_INV_HOLDS_B');
1181: FII_UTIL.put_line('');
1182: FII_UTIL.stop_timer;
1183: FII_UTIL.print_timer('Duration');
1184: end if;
1185:
1186: COMMIT;

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

1179: if g_debug_flag = 'Y' then
1180: FII_UTIL.put_line('Inserted '|| SQL%ROWCOUNT ||' records into FII_AP_INV_HOLDS_B');
1181: FII_UTIL.put_line('');
1182: FII_UTIL.stop_timer;
1183: FII_UTIL.print_timer('Duration');
1184: end if;
1185:
1186: COMMIT;
1187:

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

1190: WHEN OTHERS THEN
1191: g_errbuf:=sqlerrm;
1192: g_retcode:= -1;
1193: g_exception_msg := g_retcode || ':' || g_errbuf;
1194: FII_UTIL.put_line('Error occured while ' || g_state);
1195: FII_UTIL.put_line(g_exception_msg);
1196: RAISE;
1197:
1198: END;

Line 1195: FII_UTIL.put_line(g_exception_msg);

1191: g_errbuf:=sqlerrm;
1192: g_retcode:= -1;
1193: g_exception_msg := g_retcode || ':' || g_errbuf;
1194: FII_UTIL.put_line('Error occured while ' || g_state);
1195: FII_UTIL.put_line(g_exception_msg);
1196: RAISE;
1197:
1198: END;
1199:

Line 1222: FII_UTIL.put_line(g_state);

1218: TRUNCATE_TABLE('FII_AP_INVOICE_B');
1219:
1220: g_state := 'Populating FII_AP_INVOICE_B FROM AP_INVOICES_ALL table';
1221: if g_debug_flag = 'Y' then
1222: FII_UTIL.put_line(g_state);
1223: FII_UTIL.start_timer;
1224: FII_UTIL.put_line('');
1225: end if;
1226:

Line 1223: FII_UTIL.start_timer;

1219:
1220: g_state := 'Populating FII_AP_INVOICE_B FROM AP_INVOICES_ALL table';
1221: if g_debug_flag = 'Y' then
1222: FII_UTIL.put_line(g_state);
1223: FII_UTIL.start_timer;
1224: FII_UTIL.put_line('');
1225: end if;
1226:
1227: /* Enhancement 4227813: Manual invoice sources are defined by the profile option

Line 1224: FII_UTIL.put_line('');

1220: g_state := 'Populating FII_AP_INVOICE_B FROM AP_INVOICES_ALL table';
1221: if g_debug_flag = 'Y' then
1222: FII_UTIL.put_line(g_state);
1223: FII_UTIL.start_timer;
1224: FII_UTIL.put_line('');
1225: end if;
1226:
1227: /* Enhancement 4227813: Manual invoice sources are defined by the profile option
1228: 'FII: Manual Invoice Sources'. Do dummy select in order to verify that the

Line 1460: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' records into FII_AP_INVOICE_B');

1456: AND IB.Base_Currency_Code = FRATES.To_Currency;
1457:
1458:
1459: if g_debug_flag = 'Y' then
1460: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' records into FII_AP_INVOICE_B');
1461: FII_UTIL.stop_timer;
1462: FII_UTIL.print_timer('Duration');
1463: FII_UTIL.put_line('');
1464: end if;

Line 1461: FII_UTIL.stop_timer;

1457:
1458:
1459: if g_debug_flag = 'Y' then
1460: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' records into FII_AP_INVOICE_B');
1461: FII_UTIL.stop_timer;
1462: FII_UTIL.print_timer('Duration');
1463: FII_UTIL.put_line('');
1464: end if;
1465:

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

1458:
1459: if g_debug_flag = 'Y' then
1460: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' records into FII_AP_INVOICE_B');
1461: FII_UTIL.stop_timer;
1462: FII_UTIL.print_timer('Duration');
1463: FII_UTIL.put_line('');
1464: end if;
1465:
1466: COMMIT;

Line 1463: FII_UTIL.put_line('');

1459: if g_debug_flag = 'Y' then
1460: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' records into FII_AP_INVOICE_B');
1461: FII_UTIL.stop_timer;
1462: FII_UTIL.print_timer('Duration');
1463: FII_UTIL.put_line('');
1464: end if;
1465:
1466: COMMIT;
1467:

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

1477: WHEN OTHERS THEN
1478: g_errbuf:=sqlerrm;
1479: g_retcode:= -1;
1480: g_exception_msg := g_retcode || ':' || g_errbuf;
1481: FII_UTIL.put_line('Error occured while ' || g_state);
1482: FII_UTIL.put_line(g_exception_msg);
1483: RAISE;
1484:
1485: END;

Line 1482: FII_UTIL.put_line(g_exception_msg);

1478: g_errbuf:=sqlerrm;
1479: g_retcode:= -1;
1480: g_exception_msg := g_retcode || ':' || g_errbuf;
1481: FII_UTIL.put_line('Error occured while ' || g_state);
1482: FII_UTIL.put_line(g_exception_msg);
1483: RAISE;
1484:
1485: END;
1486:

Line 1503: FII_UTIL.put_line('');

1499: BEGIN
1500:
1501: g_state := 'Inside the procedure POPULATE_PS_PAYMENT_ACTION';
1502: if g_debug_flag = 'Y' then
1503: FII_UTIL.put_line('');
1504: FII_UTIL.put_line(g_state);
1505: end if;
1506:
1507: g_state := 'Populating Payment Creation records';

Line 1504: FII_UTIL.put_line(g_state);

1500:
1501: g_state := 'Inside the procedure POPULATE_PS_PAYMENT_ACTION';
1502: if g_debug_flag = 'Y' then
1503: FII_UTIL.put_line('');
1504: FII_UTIL.put_line(g_state);
1505: end if;
1506:
1507: g_state := 'Populating Payment Creation records';
1508: if g_debug_flag = 'Y' then

Line 1509: FII_UTIL.put_line(g_state);

1505: end if;
1506:
1507: g_state := 'Populating Payment Creation records';
1508: if g_debug_flag = 'Y' then
1509: FII_UTIL.put_line(g_state);
1510: FII_UTIL.put_timestamp('Start Timestamp');
1511: FII_UTIL.start_timer;
1512: FII_UTIL.put_line('');
1513: end if;

Line 1510: FII_UTIL.put_timestamp('Start Timestamp');

1506:
1507: g_state := 'Populating Payment Creation records';
1508: if g_debug_flag = 'Y' then
1509: FII_UTIL.put_line(g_state);
1510: FII_UTIL.put_timestamp('Start Timestamp');
1511: FII_UTIL.start_timer;
1512: FII_UTIL.put_line('');
1513: end if;
1514:

Line 1511: FII_UTIL.start_timer;

1507: g_state := 'Populating Payment Creation records';
1508: if g_debug_flag = 'Y' then
1509: FII_UTIL.put_line(g_state);
1510: FII_UTIL.put_timestamp('Start Timestamp');
1511: FII_UTIL.start_timer;
1512: FII_UTIL.put_line('');
1513: end if;
1514:
1515: /* Insert statement to insert all the payment information into the summary

Line 1512: FII_UTIL.put_line('');

1508: if g_debug_flag = 'Y' then
1509: FII_UTIL.put_line(g_state);
1510: FII_UTIL.put_timestamp('Start Timestamp');
1511: FII_UTIL.start_timer;
1512: FII_UTIL.put_line('');
1513: end if;
1514:
1515: /* Insert statement to insert all the payment information into the summary
1516: table including the payments made for a prepayment invoice.

Line 1918: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Payment records into FII_AP_PAY_SCHED_B');

1914: AND RATES.Trx_Date = PSUM.Invoice_Date;
1915:
1916:
1917: if g_debug_flag = 'Y' then
1918: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Payment records into FII_AP_PAY_SCHED_B');
1919: FII_UTIL.put_timestamp('End Timestamp');
1920: FII_UTIL.stop_timer;
1921: FII_UTIL.print_timer('Duration');
1922: FII_UTIL.put_line('');

Line 1919: FII_UTIL.put_timestamp('End Timestamp');

1915:
1916:
1917: if g_debug_flag = 'Y' then
1918: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Payment records into FII_AP_PAY_SCHED_B');
1919: FII_UTIL.put_timestamp('End Timestamp');
1920: FII_UTIL.stop_timer;
1921: FII_UTIL.print_timer('Duration');
1922: FII_UTIL.put_line('');
1923: end if;

Line 1920: FII_UTIL.stop_timer;

1916:
1917: if g_debug_flag = 'Y' then
1918: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Payment records into FII_AP_PAY_SCHED_B');
1919: FII_UTIL.put_timestamp('End Timestamp');
1920: FII_UTIL.stop_timer;
1921: FII_UTIL.print_timer('Duration');
1922: FII_UTIL.put_line('');
1923: end if;
1924:

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

1917: if g_debug_flag = 'Y' then
1918: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Payment records into FII_AP_PAY_SCHED_B');
1919: FII_UTIL.put_timestamp('End Timestamp');
1920: FII_UTIL.stop_timer;
1921: FII_UTIL.print_timer('Duration');
1922: FII_UTIL.put_line('');
1923: end if;
1924:
1925: commit;

Line 1922: FII_UTIL.put_line('');

1918: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Payment records into FII_AP_PAY_SCHED_B');
1919: FII_UTIL.put_timestamp('End Timestamp');
1920: FII_UTIL.stop_timer;
1921: FII_UTIL.print_timer('Duration');
1922: FII_UTIL.put_line('');
1923: end if;
1924:
1925: commit;
1926:

Line 1932: FII_UTIL.put_line(g_state);

1928:
1929:
1930: g_state := 'Populating Payment Creation records into temp table';
1931: if g_debug_flag = 'Y' then
1932: FII_UTIL.put_line(g_state);
1933: FII_UTIL.put_timestamp('Start Timestamp');
1934: FII_UTIL.start_timer;
1935: FII_UTIL.put_line('');
1936: end if;

Line 1933: FII_UTIL.put_timestamp('Start Timestamp');

1929:
1930: g_state := 'Populating Payment Creation records into temp table';
1931: if g_debug_flag = 'Y' then
1932: FII_UTIL.put_line(g_state);
1933: FII_UTIL.put_timestamp('Start Timestamp');
1934: FII_UTIL.start_timer;
1935: FII_UTIL.put_line('');
1936: end if;
1937:

Line 1934: FII_UTIL.start_timer;

1930: g_state := 'Populating Payment Creation records into temp table';
1931: if g_debug_flag = 'Y' then
1932: FII_UTIL.put_line(g_state);
1933: FII_UTIL.put_timestamp('Start Timestamp');
1934: FII_UTIL.start_timer;
1935: FII_UTIL.put_line('');
1936: end if;
1937:
1938:

Line 1935: FII_UTIL.put_line('');

1931: if g_debug_flag = 'Y' then
1932: FII_UTIL.put_line(g_state);
1933: FII_UTIL.put_timestamp('Start Timestamp');
1934: FII_UTIL.start_timer;
1935: FII_UTIL.put_line('');
1936: end if;
1937:
1938:
1939: /* We will first insert the last payment of a payment schedule into a temp table

Line 2176: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Last Payment records into FII_AP_PAY_SCHED_TEMP ');

2172: AIP.Invoice_Payment_ID;
2173:
2174:
2175: if g_debug_flag = 'Y' then
2176: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Last Payment records into FII_AP_PAY_SCHED_TEMP ');
2177: FII_UTIL.put_timestamp('End Timestamp');
2178: FII_UTIL.stop_timer;
2179: FII_UTIL.print_timer('Duration');
2180: FII_UTIL.put_line('');

Line 2177: FII_UTIL.put_timestamp('End Timestamp');

2173:
2174:
2175: if g_debug_flag = 'Y' then
2176: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Last Payment records into FII_AP_PAY_SCHED_TEMP ');
2177: FII_UTIL.put_timestamp('End Timestamp');
2178: FII_UTIL.stop_timer;
2179: FII_UTIL.print_timer('Duration');
2180: FII_UTIL.put_line('');
2181: end if;

Line 2178: FII_UTIL.stop_timer;

2174:
2175: if g_debug_flag = 'Y' then
2176: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Last Payment records into FII_AP_PAY_SCHED_TEMP ');
2177: FII_UTIL.put_timestamp('End Timestamp');
2178: FII_UTIL.stop_timer;
2179: FII_UTIL.print_timer('Duration');
2180: FII_UTIL.put_line('');
2181: end if;
2182:

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

2175: if g_debug_flag = 'Y' then
2176: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Last Payment records into FII_AP_PAY_SCHED_TEMP ');
2177: FII_UTIL.put_timestamp('End Timestamp');
2178: FII_UTIL.stop_timer;
2179: FII_UTIL.print_timer('Duration');
2180: FII_UTIL.put_line('');
2181: end if;
2182:
2183: commit;

Line 2180: FII_UTIL.put_line('');

2176: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Last Payment records into FII_AP_PAY_SCHED_TEMP ');
2177: FII_UTIL.put_timestamp('End Timestamp');
2178: FII_UTIL.stop_timer;
2179: FII_UTIL.print_timer('Duration');
2180: FII_UTIL.put_line('');
2181: end if;
2182:
2183: commit;
2184:

Line 2190: FII_UTIL.put_line(g_state);

2186:
2187:
2188: g_state := 'Populating Last Payment Creation records from temp table';
2189: if g_debug_flag = 'Y' then
2190: FII_UTIL.put_line(g_state);
2191: FII_UTIL.put_timestamp('Start Timestamp');
2192: FII_UTIL.start_timer;
2193: FII_UTIL.put_line('');
2194: end if;

Line 2191: FII_UTIL.put_timestamp('Start Timestamp');

2187:
2188: g_state := 'Populating Last Payment Creation records from temp table';
2189: if g_debug_flag = 'Y' then
2190: FII_UTIL.put_line(g_state);
2191: FII_UTIL.put_timestamp('Start Timestamp');
2192: FII_UTIL.start_timer;
2193: FII_UTIL.put_line('');
2194: end if;
2195:

Line 2192: FII_UTIL.start_timer;

2188: g_state := 'Populating Last Payment Creation records from temp table';
2189: if g_debug_flag = 'Y' then
2190: FII_UTIL.put_line(g_state);
2191: FII_UTIL.put_timestamp('Start Timestamp');
2192: FII_UTIL.start_timer;
2193: FII_UTIL.put_line('');
2194: end if;
2195:
2196: INSERT INTO FII_AP_PAY_SCHED_B b

Line 2193: FII_UTIL.put_line('');

2189: if g_debug_flag = 'Y' then
2190: FII_UTIL.put_line(g_state);
2191: FII_UTIL.put_timestamp('Start Timestamp');
2192: FII_UTIL.start_timer;
2193: FII_UTIL.put_line('');
2194: end if;
2195:
2196: INSERT INTO FII_AP_PAY_SCHED_B b
2197: (Time_ID,

Line 2431: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Payment records into FII_AP_PAY_SCHED_B from Temp table');

2427: AND RATES.Trx_Date = TEMP.Trx_Date;
2428:
2429:
2430: if g_debug_flag = 'Y' then
2431: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Payment records into FII_AP_PAY_SCHED_B from Temp table');
2432: FII_UTIL.put_timestamp('End Timestamp');
2433: FII_UTIL.stop_timer;
2434: FII_UTIL.print_timer('Duration');
2435: FII_UTIL.put_line('');

Line 2432: FII_UTIL.put_timestamp('End Timestamp');

2428:
2429:
2430: if g_debug_flag = 'Y' then
2431: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Payment records into FII_AP_PAY_SCHED_B from Temp table');
2432: FII_UTIL.put_timestamp('End Timestamp');
2433: FII_UTIL.stop_timer;
2434: FII_UTIL.print_timer('Duration');
2435: FII_UTIL.put_line('');
2436: end if;

Line 2433: FII_UTIL.stop_timer;

2429:
2430: if g_debug_flag = 'Y' then
2431: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Payment records into FII_AP_PAY_SCHED_B from Temp table');
2432: FII_UTIL.put_timestamp('End Timestamp');
2433: FII_UTIL.stop_timer;
2434: FII_UTIL.print_timer('Duration');
2435: FII_UTIL.put_line('');
2436: end if;
2437:

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

2430: if g_debug_flag = 'Y' then
2431: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Payment records into FII_AP_PAY_SCHED_B from Temp table');
2432: FII_UTIL.put_timestamp('End Timestamp');
2433: FII_UTIL.stop_timer;
2434: FII_UTIL.print_timer('Duration');
2435: FII_UTIL.put_line('');
2436: end if;
2437:
2438: commit;

Line 2435: FII_UTIL.put_line('');

2431: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Payment records into FII_AP_PAY_SCHED_B from Temp table');
2432: FII_UTIL.put_timestamp('End Timestamp');
2433: FII_UTIL.stop_timer;
2434: FII_UTIL.print_timer('Duration');
2435: FII_UTIL.put_line('');
2436: end if;
2437:
2438: commit;
2439:

Line 2442: FII_UTIL.put_line(g_state);

2438: commit;
2439:
2440: g_state := 'Populating Withholding Action records';
2441: if g_debug_flag = 'Y' then
2442: FII_UTIL.put_line(g_state);
2443: FII_UTIL.put_timestamp('Start Timestamp');
2444: FII_UTIL.start_timer;
2445: FII_UTIL.put_line('');
2446: end if;

Line 2443: FII_UTIL.put_timestamp('Start Timestamp');

2439:
2440: g_state := 'Populating Withholding Action records';
2441: if g_debug_flag = 'Y' then
2442: FII_UTIL.put_line(g_state);
2443: FII_UTIL.put_timestamp('Start Timestamp');
2444: FII_UTIL.start_timer;
2445: FII_UTIL.put_line('');
2446: end if;
2447:

Line 2444: FII_UTIL.start_timer;

2440: g_state := 'Populating Withholding Action records';
2441: if g_debug_flag = 'Y' then
2442: FII_UTIL.put_line(g_state);
2443: FII_UTIL.put_timestamp('Start Timestamp');
2444: FII_UTIL.start_timer;
2445: FII_UTIL.put_line('');
2446: end if;
2447:
2448: /* Insert statement to insert prepayment information into the summary tables.

Line 2445: FII_UTIL.put_line('');

2441: if g_debug_flag = 'Y' then
2442: FII_UTIL.put_line(g_state);
2443: FII_UTIL.put_timestamp('Start Timestamp');
2444: FII_UTIL.start_timer;
2445: FII_UTIL.put_line('');
2446: end if;
2447:
2448: /* Insert statement to insert prepayment information into the summary tables.
2449: Discount information is not recorded as the discounts taken and lost are

Line 2855: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Withholding records into FII_AP_PAY_SCHED_B');

2851:
2852:
2853:
2854: if g_debug_flag = 'Y' then
2855: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Withholding records into FII_AP_PAY_SCHED_B');
2856: FII_UTIL.put_timestamp('End Timestamp');
2857: FII_UTIL.stop_timer;
2858: FII_UTIL.print_timer('Duration');
2859: FII_UTIL.put_line('');

Line 2856: FII_UTIL.put_timestamp('End Timestamp');

2852:
2853:
2854: if g_debug_flag = 'Y' then
2855: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Withholding records into FII_AP_PAY_SCHED_B');
2856: FII_UTIL.put_timestamp('End Timestamp');
2857: FII_UTIL.stop_timer;
2858: FII_UTIL.print_timer('Duration');
2859: FII_UTIL.put_line('');
2860: end if;

Line 2857: FII_UTIL.stop_timer;

2853:
2854: if g_debug_flag = 'Y' then
2855: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Withholding records into FII_AP_PAY_SCHED_B');
2856: FII_UTIL.put_timestamp('End Timestamp');
2857: FII_UTIL.stop_timer;
2858: FII_UTIL.print_timer('Duration');
2859: FII_UTIL.put_line('');
2860: end if;
2861:

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

2854: if g_debug_flag = 'Y' then
2855: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Withholding records into FII_AP_PAY_SCHED_B');
2856: FII_UTIL.put_timestamp('End Timestamp');
2857: FII_UTIL.stop_timer;
2858: FII_UTIL.print_timer('Duration');
2859: FII_UTIL.put_line('');
2860: end if;
2861:
2862: commit;

Line 2859: FII_UTIL.put_line('');

2855: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Withholding records into FII_AP_PAY_SCHED_B');
2856: FII_UTIL.put_timestamp('End Timestamp');
2857: FII_UTIL.stop_timer;
2858: FII_UTIL.print_timer('Duration');
2859: FII_UTIL.put_line('');
2860: end if;
2861:
2862: commit;
2863:

Line 2866: FII_UTIL.put_line(g_state);

2862: commit;
2863:
2864: g_state := 'Populating Prepayment Action records';
2865: if g_debug_flag = 'Y' then
2866: FII_UTIL.put_line(g_state);
2867: FII_UTIL.put_timestamp('Start Timestamp');
2868: FII_UTIL.start_timer;
2869: FII_UTIL.put_line('');
2870: end if;

Line 2867: FII_UTIL.put_timestamp('Start Timestamp');

2863:
2864: g_state := 'Populating Prepayment Action records';
2865: if g_debug_flag = 'Y' then
2866: FII_UTIL.put_line(g_state);
2867: FII_UTIL.put_timestamp('Start Timestamp');
2868: FII_UTIL.start_timer;
2869: FII_UTIL.put_line('');
2870: end if;
2871:

Line 2868: FII_UTIL.start_timer;

2864: g_state := 'Populating Prepayment Action records';
2865: if g_debug_flag = 'Y' then
2866: FII_UTIL.put_line(g_state);
2867: FII_UTIL.put_timestamp('Start Timestamp');
2868: FII_UTIL.start_timer;
2869: FII_UTIL.put_line('');
2870: end if;
2871:
2872: INSERT INTO FII_AP_PAY_SCHED_B b

Line 2869: FII_UTIL.put_line('');

2865: if g_debug_flag = 'Y' then
2866: FII_UTIL.put_line(g_state);
2867: FII_UTIL.put_timestamp('Start Timestamp');
2868: FII_UTIL.start_timer;
2869: FII_UTIL.put_line('');
2870: end if;
2871:
2872: INSERT INTO FII_AP_PAY_SCHED_B b
2873: (Time_ID,

Line 3312: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Prepayment records into FII_AP_PAY_SCHED_B ');

3308: AND RATES.Trx_Date = AI.Invoice_Date
3309: AND AI.Payment_Currency_Code = FC.Currency_Code;
3310:
3311: if g_debug_flag = 'Y' then
3312: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Prepayment records into FII_AP_PAY_SCHED_B ');
3313: FII_UTIL.put_timestamp('End Timestamp');
3314: FII_UTIL.stop_timer;
3315: FII_UTIL.print_timer('Duration');
3316: FII_UTIL.put_line('');

Line 3313: FII_UTIL.put_timestamp('End Timestamp');

3309: AND AI.Payment_Currency_Code = FC.Currency_Code;
3310:
3311: if g_debug_flag = 'Y' then
3312: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Prepayment records into FII_AP_PAY_SCHED_B ');
3313: FII_UTIL.put_timestamp('End Timestamp');
3314: FII_UTIL.stop_timer;
3315: FII_UTIL.print_timer('Duration');
3316: FII_UTIL.put_line('');
3317: end if;

Line 3314: FII_UTIL.stop_timer;

3310:
3311: if g_debug_flag = 'Y' then
3312: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Prepayment records into FII_AP_PAY_SCHED_B ');
3313: FII_UTIL.put_timestamp('End Timestamp');
3314: FII_UTIL.stop_timer;
3315: FII_UTIL.print_timer('Duration');
3316: FII_UTIL.put_line('');
3317: end if;
3318:

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

3311: if g_debug_flag = 'Y' then
3312: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Prepayment records into FII_AP_PAY_SCHED_B ');
3313: FII_UTIL.put_timestamp('End Timestamp');
3314: FII_UTIL.stop_timer;
3315: FII_UTIL.print_timer('Duration');
3316: FII_UTIL.put_line('');
3317: end if;
3318:
3319: commit;

Line 3316: FII_UTIL.put_line('');

3312: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Prepayment records into FII_AP_PAY_SCHED_B ');
3313: FII_UTIL.put_timestamp('End Timestamp');
3314: FII_UTIL.stop_timer;
3315: FII_UTIL.print_timer('Duration');
3316: FII_UTIL.put_line('');
3317: end if;
3318:
3319: commit;
3320:

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

3325: WHEN OTHERS THEN
3326: g_errbuf:=sqlerrm;
3327: g_retcode:= -1;
3328: g_exception_msg := g_retcode || ':' || g_errbuf;
3329: FII_UTIL.put_line('Error occured while ' || g_state);
3330: FII_UTIL.put_line(g_exception_msg);
3331: RAISE;
3332: END;
3333:

Line 3330: FII_UTIL.put_line(g_exception_msg);

3326: g_errbuf:=sqlerrm;
3327: g_retcode:= -1;
3328: g_exception_msg := g_retcode || ':' || g_errbuf;
3329: FII_UTIL.put_line('Error occured while ' || g_state);
3330: FII_UTIL.put_line(g_exception_msg);
3331: RAISE;
3332: END;
3333:
3334:

Line 3348: FII_UTIL.put_line('');

3344: BEGIN
3345:
3346: g_state := 'Inside the procedure POPULATE_PS_DISC_ACTION';
3347: if g_debug_flag = 'Y' then
3348: FII_UTIL.put_line('');
3349: FII_UTIL.put_line(g_state);
3350: end if;
3351:
3352: g_state := 'Inserting the Payment Schedules Discount Action';

Line 3349: FII_UTIL.put_line(g_state);

3345:
3346: g_state := 'Inside the procedure POPULATE_PS_DISC_ACTION';
3347: if g_debug_flag = 'Y' then
3348: FII_UTIL.put_line('');
3349: FII_UTIL.put_line(g_state);
3350: end if;
3351:
3352: g_state := 'Inserting the Payment Schedules Discount Action';
3353: if g_debug_flag = 'Y' then

Line 3354: FII_UTIL.put_line('');

3350: end if;
3351:
3352: g_state := 'Inserting the Payment Schedules Discount Action';
3353: if g_debug_flag = 'Y' then
3354: FII_UTIL.put_line('');
3355: FII_UTIL.put_line(g_state);
3356: FII_UTIL.put_timestamp('Start Timestamp');
3357: FII_UTIL.start_timer;
3358: FII_UTIL.put_line('');

Line 3355: FII_UTIL.put_line(g_state);

3351:
3352: g_state := 'Inserting the Payment Schedules Discount Action';
3353: if g_debug_flag = 'Y' then
3354: FII_UTIL.put_line('');
3355: FII_UTIL.put_line(g_state);
3356: FII_UTIL.put_timestamp('Start Timestamp');
3357: FII_UTIL.start_timer;
3358: FII_UTIL.put_line('');
3359: end if;

Line 3356: FII_UTIL.put_timestamp('Start Timestamp');

3352: g_state := 'Inserting the Payment Schedules Discount Action';
3353: if g_debug_flag = 'Y' then
3354: FII_UTIL.put_line('');
3355: FII_UTIL.put_line(g_state);
3356: FII_UTIL.put_timestamp('Start Timestamp');
3357: FII_UTIL.start_timer;
3358: FII_UTIL.put_line('');
3359: end if;
3360:

Line 3357: FII_UTIL.start_timer;

3353: if g_debug_flag = 'Y' then
3354: FII_UTIL.put_line('');
3355: FII_UTIL.put_line(g_state);
3356: FII_UTIL.put_timestamp('Start Timestamp');
3357: FII_UTIL.start_timer;
3358: FII_UTIL.put_line('');
3359: end if;
3360:
3361: /* For Discount and Due actions we will select the payment schedules whose

Line 3358: FII_UTIL.put_line('');

3354: FII_UTIL.put_line('');
3355: FII_UTIL.put_line(g_state);
3356: FII_UTIL.put_timestamp('Start Timestamp');
3357: FII_UTIL.start_timer;
3358: FII_UTIL.put_line('');
3359: end if;
3360:
3361: /* For Discount and Due actions we will select the payment schedules whose
3362: discount or due date falls between the given from date and the least of

Line 3610: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Discount records into FII_AP_PAY_SCHED_B');

3606: + NVL(PP.Prepay_Amount,0)) < ABS(PS.Gross_Amount);
3607:
3608:
3609: if g_debug_flag = 'Y' then
3610: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Discount records into FII_AP_PAY_SCHED_B');
3611: FII_UTIL.put_timestamp('End Timestamp');
3612: FII_UTIL.stop_timer;
3613: FII_UTIL.print_timer('Duration');
3614: FII_UTIL.put_line('');

Line 3611: FII_UTIL.put_timestamp('End Timestamp');

3607:
3608:
3609: if g_debug_flag = 'Y' then
3610: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Discount records into FII_AP_PAY_SCHED_B');
3611: FII_UTIL.put_timestamp('End Timestamp');
3612: FII_UTIL.stop_timer;
3613: FII_UTIL.print_timer('Duration');
3614: FII_UTIL.put_line('');
3615: end if;

Line 3612: FII_UTIL.stop_timer;

3608:
3609: if g_debug_flag = 'Y' then
3610: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Discount records into FII_AP_PAY_SCHED_B');
3611: FII_UTIL.put_timestamp('End Timestamp');
3612: FII_UTIL.stop_timer;
3613: FII_UTIL.print_timer('Duration');
3614: FII_UTIL.put_line('');
3615: end if;
3616:

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

3609: if g_debug_flag = 'Y' then
3610: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Discount records into FII_AP_PAY_SCHED_B');
3611: FII_UTIL.put_timestamp('End Timestamp');
3612: FII_UTIL.stop_timer;
3613: FII_UTIL.print_timer('Duration');
3614: FII_UTIL.put_line('');
3615: end if;
3616:
3617: commit;

Line 3614: FII_UTIL.put_line('');

3610: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Discount records into FII_AP_PAY_SCHED_B');
3611: FII_UTIL.put_timestamp('End Timestamp');
3612: FII_UTIL.stop_timer;
3613: FII_UTIL.print_timer('Duration');
3614: FII_UTIL.put_line('');
3615: end if;
3616:
3617: commit;
3618:

Line 3621: FII_UTIL.put_line('');

3617: commit;
3618:
3619: g_state := 'Inserting the Payment Schedules Second Discount Records';
3620: if g_debug_flag = 'Y' then
3621: FII_UTIL.put_line('');
3622: FII_UTIL.put_line(g_state);
3623: FII_UTIL.put_timestamp('Start Timestamp');
3624: FII_UTIL.start_timer;
3625: FII_UTIL.put_line('');

Line 3622: FII_UTIL.put_line(g_state);

3618:
3619: g_state := 'Inserting the Payment Schedules Second Discount Records';
3620: if g_debug_flag = 'Y' then
3621: FII_UTIL.put_line('');
3622: FII_UTIL.put_line(g_state);
3623: FII_UTIL.put_timestamp('Start Timestamp');
3624: FII_UTIL.start_timer;
3625: FII_UTIL.put_line('');
3626: end if;

Line 3623: FII_UTIL.put_timestamp('Start Timestamp');

3619: g_state := 'Inserting the Payment Schedules Second Discount Records';
3620: if g_debug_flag = 'Y' then
3621: FII_UTIL.put_line('');
3622: FII_UTIL.put_line(g_state);
3623: FII_UTIL.put_timestamp('Start Timestamp');
3624: FII_UTIL.start_timer;
3625: FII_UTIL.put_line('');
3626: end if;
3627:

Line 3624: FII_UTIL.start_timer;

3620: if g_debug_flag = 'Y' then
3621: FII_UTIL.put_line('');
3622: FII_UTIL.put_line(g_state);
3623: FII_UTIL.put_timestamp('Start Timestamp');
3624: FII_UTIL.start_timer;
3625: FII_UTIL.put_line('');
3626: end if;
3627:
3628:

Line 3625: FII_UTIL.put_line('');

3621: FII_UTIL.put_line('');
3622: FII_UTIL.put_line(g_state);
3623: FII_UTIL.put_timestamp('Start Timestamp');
3624: FII_UTIL.start_timer;
3625: FII_UTIL.put_line('');
3626: end if;
3627:
3628:
3629: /* Inserting the Discount Date passed records into the summary table.

Line 3884: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Discount records into FII_AP_PAY_SCHED_B');

3880: + NVL(PP.Prepay_Amount,0)) < ABS(PS.Gross_Amount);
3881:
3882:
3883: if g_debug_flag = 'Y' then
3884: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Discount records into FII_AP_PAY_SCHED_B');
3885: FII_UTIL.put_timestamp('End Timestamp');
3886: FII_UTIL.stop_timer;
3887: FII_UTIL.print_timer('Duration');
3888: FII_UTIL.put_line('');

Line 3885: FII_UTIL.put_timestamp('End Timestamp');

3881:
3882:
3883: if g_debug_flag = 'Y' then
3884: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Discount records into FII_AP_PAY_SCHED_B');
3885: FII_UTIL.put_timestamp('End Timestamp');
3886: FII_UTIL.stop_timer;
3887: FII_UTIL.print_timer('Duration');
3888: FII_UTIL.put_line('');
3889: end if;

Line 3886: FII_UTIL.stop_timer;

3882:
3883: if g_debug_flag = 'Y' then
3884: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Discount records into FII_AP_PAY_SCHED_B');
3885: FII_UTIL.put_timestamp('End Timestamp');
3886: FII_UTIL.stop_timer;
3887: FII_UTIL.print_timer('Duration');
3888: FII_UTIL.put_line('');
3889: end if;
3890:

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

3883: if g_debug_flag = 'Y' then
3884: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Discount records into FII_AP_PAY_SCHED_B');
3885: FII_UTIL.put_timestamp('End Timestamp');
3886: FII_UTIL.stop_timer;
3887: FII_UTIL.print_timer('Duration');
3888: FII_UTIL.put_line('');
3889: end if;
3890:
3891: commit;

Line 3888: FII_UTIL.put_line('');

3884: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Discount records into FII_AP_PAY_SCHED_B');
3885: FII_UTIL.put_timestamp('End Timestamp');
3886: FII_UTIL.stop_timer;
3887: FII_UTIL.print_timer('Duration');
3888: FII_UTIL.put_line('');
3889: end if;
3890:
3891: commit;
3892:

Line 3895: FII_UTIL.put_line('');

3891: commit;
3892:
3893: g_state := 'Inserting the Payment Schedules Third Discount Records';
3894: if g_debug_flag = 'Y' then
3895: FII_UTIL.put_line('');
3896: FII_UTIL.put_line(g_state);
3897: FII_UTIL.put_timestamp('Start Timestamp');
3898: FII_UTIL.start_timer;
3899: FII_UTIL.put_line('');

Line 3896: FII_UTIL.put_line(g_state);

3892:
3893: g_state := 'Inserting the Payment Schedules Third Discount Records';
3894: if g_debug_flag = 'Y' then
3895: FII_UTIL.put_line('');
3896: FII_UTIL.put_line(g_state);
3897: FII_UTIL.put_timestamp('Start Timestamp');
3898: FII_UTIL.start_timer;
3899: FII_UTIL.put_line('');
3900: end if;

Line 3897: FII_UTIL.put_timestamp('Start Timestamp');

3893: g_state := 'Inserting the Payment Schedules Third Discount Records';
3894: if g_debug_flag = 'Y' then
3895: FII_UTIL.put_line('');
3896: FII_UTIL.put_line(g_state);
3897: FII_UTIL.put_timestamp('Start Timestamp');
3898: FII_UTIL.start_timer;
3899: FII_UTIL.put_line('');
3900: end if;
3901:

Line 3898: FII_UTIL.start_timer;

3894: if g_debug_flag = 'Y' then
3895: FII_UTIL.put_line('');
3896: FII_UTIL.put_line(g_state);
3897: FII_UTIL.put_timestamp('Start Timestamp');
3898: FII_UTIL.start_timer;
3899: FII_UTIL.put_line('');
3900: end if;
3901:
3902:

Line 3899: FII_UTIL.put_line('');

3895: FII_UTIL.put_line('');
3896: FII_UTIL.put_line(g_state);
3897: FII_UTIL.put_timestamp('Start Timestamp');
3898: FII_UTIL.start_timer;
3899: FII_UTIL.put_line('');
3900: end if;
3901:
3902:
3903: /* Inserting the Discount Date passed records into the summary table.

Line 4149: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Discount records into FII_AP_PAY_SCHED_B');

4145: + NVL(PP.Prepay_Amount,0)) < ABS(PS.Gross_Amount);
4146:
4147:
4148: if g_debug_flag = 'Y' then
4149: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Discount records into FII_AP_PAY_SCHED_B');
4150: FII_UTIL.put_timestamp('End Timestamp');
4151: FII_UTIL.stop_timer;
4152: FII_UTIL.print_timer('Duration');
4153: FII_UTIL.put_line('');

Line 4150: FII_UTIL.put_timestamp('End Timestamp');

4146:
4147:
4148: if g_debug_flag = 'Y' then
4149: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Discount records into FII_AP_PAY_SCHED_B');
4150: FII_UTIL.put_timestamp('End Timestamp');
4151: FII_UTIL.stop_timer;
4152: FII_UTIL.print_timer('Duration');
4153: FII_UTIL.put_line('');
4154: end if;

Line 4151: FII_UTIL.stop_timer;

4147:
4148: if g_debug_flag = 'Y' then
4149: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Discount records into FII_AP_PAY_SCHED_B');
4150: FII_UTIL.put_timestamp('End Timestamp');
4151: FII_UTIL.stop_timer;
4152: FII_UTIL.print_timer('Duration');
4153: FII_UTIL.put_line('');
4154: end if;
4155:

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

4148: if g_debug_flag = 'Y' then
4149: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Discount records into FII_AP_PAY_SCHED_B');
4150: FII_UTIL.put_timestamp('End Timestamp');
4151: FII_UTIL.stop_timer;
4152: FII_UTIL.print_timer('Duration');
4153: FII_UTIL.put_line('');
4154: end if;
4155:
4156: commit;

Line 4153: FII_UTIL.put_line('');

4149: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Discount records into FII_AP_PAY_SCHED_B');
4150: FII_UTIL.put_timestamp('End Timestamp');
4151: FII_UTIL.stop_timer;
4152: FII_UTIL.print_timer('Duration');
4153: FII_UTIL.put_line('');
4154: end if;
4155:
4156: commit;
4157:

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

4159: WHEN OTHERS THEN
4160: g_errbuf:=sqlerrm;
4161: g_retcode:= -1;
4162: g_exception_msg := g_retcode || ':' || g_errbuf;
4163: FII_UTIL.put_line('Error occured while ' || g_state);
4164: FII_UTIL.put_line(g_exception_msg);
4165: RAISE;
4166: END;
4167:

Line 4164: FII_UTIL.put_line(g_exception_msg);

4160: g_errbuf:=sqlerrm;
4161: g_retcode:= -1;
4162: g_exception_msg := g_retcode || ':' || g_errbuf;
4163: FII_UTIL.put_line('Error occured while ' || g_state);
4164: FII_UTIL.put_line(g_exception_msg);
4165: RAISE;
4166: END;
4167:
4168:

Line 4183: FII_UTIL.put_line('');

4179: BEGIN
4180:
4181: g_state := 'Inside the procedure POPULATE_PS_DUE_ACTION';
4182: if g_debug_flag = 'Y' then
4183: FII_UTIL.put_line('');
4184: FII_UTIL.put_line(g_state);
4185: end if;
4186:
4187: g_state := 'Inserting the Payment Schedules Due Action';

Line 4184: FII_UTIL.put_line(g_state);

4180:
4181: g_state := 'Inside the procedure POPULATE_PS_DUE_ACTION';
4182: if g_debug_flag = 'Y' then
4183: FII_UTIL.put_line('');
4184: FII_UTIL.put_line(g_state);
4185: end if;
4186:
4187: g_state := 'Inserting the Payment Schedules Due Action';
4188: if g_debug_flag = 'Y' then

Line 4189: FII_UTIL.put_line('');

4185: end if;
4186:
4187: g_state := 'Inserting the Payment Schedules Due Action';
4188: if g_debug_flag = 'Y' then
4189: FII_UTIL.put_line('');
4190: FII_UTIL.put_line(g_state);
4191: FII_UTIL.put_timestamp('Start Timestamp');
4192: FII_UTIL.start_timer;
4193: FII_UTIL.put_line('');

Line 4190: FII_UTIL.put_line(g_state);

4186:
4187: g_state := 'Inserting the Payment Schedules Due Action';
4188: if g_debug_flag = 'Y' then
4189: FII_UTIL.put_line('');
4190: FII_UTIL.put_line(g_state);
4191: FII_UTIL.put_timestamp('Start Timestamp');
4192: FII_UTIL.start_timer;
4193: FII_UTIL.put_line('');
4194: end if;

Line 4191: FII_UTIL.put_timestamp('Start Timestamp');

4187: g_state := 'Inserting the Payment Schedules Due Action';
4188: if g_debug_flag = 'Y' then
4189: FII_UTIL.put_line('');
4190: FII_UTIL.put_line(g_state);
4191: FII_UTIL.put_timestamp('Start Timestamp');
4192: FII_UTIL.start_timer;
4193: FII_UTIL.put_line('');
4194: end if;
4195:

Line 4192: FII_UTIL.start_timer;

4188: if g_debug_flag = 'Y' then
4189: FII_UTIL.put_line('');
4190: FII_UTIL.put_line(g_state);
4191: FII_UTIL.put_timestamp('Start Timestamp');
4192: FII_UTIL.start_timer;
4193: FII_UTIL.put_line('');
4194: end if;
4195:
4196:

Line 4193: FII_UTIL.put_line('');

4189: FII_UTIL.put_line('');
4190: FII_UTIL.put_line(g_state);
4191: FII_UTIL.put_timestamp('Start Timestamp');
4192: FII_UTIL.start_timer;
4193: FII_UTIL.put_line('');
4194: end if;
4195:
4196:
4197: /* Inserting the Due Date passed records into the summary table.

Line 4474: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Due records into FII_AP_PAY_SCHED_B');

4470: + NVL(PP.Prepay_Amount,0)) < ABS(PS.Gross_Amount);
4471:
4472:
4473: if g_debug_flag = 'Y' then
4474: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Due records into FII_AP_PAY_SCHED_B');
4475: FII_UTIL.put_timestamp('End Timestamp');
4476: FII_UTIL.stop_timer;
4477: FII_UTIL.print_timer('Duration');
4478: FII_UTIL.put_line('');

Line 4475: FII_UTIL.put_timestamp('End Timestamp');

4471:
4472:
4473: if g_debug_flag = 'Y' then
4474: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Due records into FII_AP_PAY_SCHED_B');
4475: FII_UTIL.put_timestamp('End Timestamp');
4476: FII_UTIL.stop_timer;
4477: FII_UTIL.print_timer('Duration');
4478: FII_UTIL.put_line('');
4479: end if;

Line 4476: FII_UTIL.stop_timer;

4472:
4473: if g_debug_flag = 'Y' then
4474: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Due records into FII_AP_PAY_SCHED_B');
4475: FII_UTIL.put_timestamp('End Timestamp');
4476: FII_UTIL.stop_timer;
4477: FII_UTIL.print_timer('Duration');
4478: FII_UTIL.put_line('');
4479: end if;
4480:

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

4473: if g_debug_flag = 'Y' then
4474: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Due records into FII_AP_PAY_SCHED_B');
4475: FII_UTIL.put_timestamp('End Timestamp');
4476: FII_UTIL.stop_timer;
4477: FII_UTIL.print_timer('Duration');
4478: FII_UTIL.put_line('');
4479: end if;
4480:
4481: commit;

Line 4478: FII_UTIL.put_line('');

4474: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Due records into FII_AP_PAY_SCHED_B');
4475: FII_UTIL.put_timestamp('End Timestamp');
4476: FII_UTIL.stop_timer;
4477: FII_UTIL.print_timer('Duration');
4478: FII_UTIL.put_line('');
4479: end if;
4480:
4481: commit;
4482:

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

4484: WHEN OTHERS THEN
4485: g_errbuf:=sqlerrm;
4486: g_retcode:= -1;
4487: g_exception_msg := g_retcode || ':' || g_errbuf;
4488: FII_UTIL.put_line('Error occured while ' || g_state);
4489: FII_UTIL.put_line(g_exception_msg);
4490: RAISE;
4491: END;
4492:

Line 4489: FII_UTIL.put_line(g_exception_msg);

4485: g_errbuf:=sqlerrm;
4486: g_retcode:= -1;
4487: g_exception_msg := g_retcode || ':' || g_errbuf;
4488: FII_UTIL.put_line('Error occured while ' || g_state);
4489: FII_UTIL.put_line(g_exception_msg);
4490: RAISE;
4491: END;
4492:
4493:

Line 4507: FII_UTIL.put_line('');

4503: BEGIN
4504:
4505: g_state := 'Inside the procedure POPULATE_PS_BUCKET_ACTION';
4506: if g_debug_flag = 'Y' then
4507: FII_UTIL.put_line('');
4508: FII_UTIL.put_line(g_state);
4509: end if;
4510:
4511: g_state := 'Inserting the Payment Schedules Due Bucket2 Action';

Line 4508: FII_UTIL.put_line(g_state);

4504:
4505: g_state := 'Inside the procedure POPULATE_PS_BUCKET_ACTION';
4506: if g_debug_flag = 'Y' then
4507: FII_UTIL.put_line('');
4508: FII_UTIL.put_line(g_state);
4509: end if;
4510:
4511: g_state := 'Inserting the Payment Schedules Due Bucket2 Action';
4512: if g_debug_flag = 'Y' then

Line 4513: FII_UTIL.put_line('');

4509: end if;
4510:
4511: g_state := 'Inserting the Payment Schedules Due Bucket2 Action';
4512: if g_debug_flag = 'Y' then
4513: FII_UTIL.put_line('');
4514: FII_UTIL.put_line(g_state);
4515: FII_UTIL.put_timestamp('Start Timestamp');
4516: FII_UTIL.start_timer;
4517: FII_UTIL.put_line('');

Line 4514: FII_UTIL.put_line(g_state);

4510:
4511: g_state := 'Inserting the Payment Schedules Due Bucket2 Action';
4512: if g_debug_flag = 'Y' then
4513: FII_UTIL.put_line('');
4514: FII_UTIL.put_line(g_state);
4515: FII_UTIL.put_timestamp('Start Timestamp');
4516: FII_UTIL.start_timer;
4517: FII_UTIL.put_line('');
4518: end if;

Line 4515: FII_UTIL.put_timestamp('Start Timestamp');

4511: g_state := 'Inserting the Payment Schedules Due Bucket2 Action';
4512: if g_debug_flag = 'Y' then
4513: FII_UTIL.put_line('');
4514: FII_UTIL.put_line(g_state);
4515: FII_UTIL.put_timestamp('Start Timestamp');
4516: FII_UTIL.start_timer;
4517: FII_UTIL.put_line('');
4518: end if;
4519:

Line 4516: FII_UTIL.start_timer;

4512: if g_debug_flag = 'Y' then
4513: FII_UTIL.put_line('');
4514: FII_UTIL.put_line(g_state);
4515: FII_UTIL.put_timestamp('Start Timestamp');
4516: FII_UTIL.start_timer;
4517: FII_UTIL.put_line('');
4518: end if;
4519:
4520:

Line 4517: FII_UTIL.put_line('');

4513: FII_UTIL.put_line('');
4514: FII_UTIL.put_line(g_state);
4515: FII_UTIL.put_timestamp('Start Timestamp');
4516: FII_UTIL.start_timer;
4517: FII_UTIL.put_line('');
4518: end if;
4519:
4520:
4521: /* Inserting the Due Bucket records into the summary table.

Line 4776: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Due Bucket2 records into FII_AP_PAY_SCHED_B');

4772: + NVL(PP.Prepay_Amount,0)) < ABS(PS.Gross_Amount);
4773:
4774:
4775: if g_debug_flag = 'Y' then
4776: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Due Bucket2 records into FII_AP_PAY_SCHED_B');
4777: FII_UTIL.put_timestamp('End Timestamp');
4778: FII_UTIL.stop_timer;
4779: FII_UTIL.print_timer('Duration');
4780: FII_UTIL.put_line('');

Line 4777: FII_UTIL.put_timestamp('End Timestamp');

4773:
4774:
4775: if g_debug_flag = 'Y' then
4776: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Due Bucket2 records into FII_AP_PAY_SCHED_B');
4777: FII_UTIL.put_timestamp('End Timestamp');
4778: FII_UTIL.stop_timer;
4779: FII_UTIL.print_timer('Duration');
4780: FII_UTIL.put_line('');
4781: FII_UTIL.start_timer;

Line 4778: FII_UTIL.stop_timer;

4774:
4775: if g_debug_flag = 'Y' then
4776: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Due Bucket2 records into FII_AP_PAY_SCHED_B');
4777: FII_UTIL.put_timestamp('End Timestamp');
4778: FII_UTIL.stop_timer;
4779: FII_UTIL.print_timer('Duration');
4780: FII_UTIL.put_line('');
4781: FII_UTIL.start_timer;
4782: FII_UTIL.put_line('');

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

4775: if g_debug_flag = 'Y' then
4776: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Due Bucket2 records into FII_AP_PAY_SCHED_B');
4777: FII_UTIL.put_timestamp('End Timestamp');
4778: FII_UTIL.stop_timer;
4779: FII_UTIL.print_timer('Duration');
4780: FII_UTIL.put_line('');
4781: FII_UTIL.start_timer;
4782: FII_UTIL.put_line('');
4783: end if;

Line 4780: FII_UTIL.put_line('');

4776: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Due Bucket2 records into FII_AP_PAY_SCHED_B');
4777: FII_UTIL.put_timestamp('End Timestamp');
4778: FII_UTIL.stop_timer;
4779: FII_UTIL.print_timer('Duration');
4780: FII_UTIL.put_line('');
4781: FII_UTIL.start_timer;
4782: FII_UTIL.put_line('');
4783: end if;
4784:

Line 4781: FII_UTIL.start_timer;

4777: FII_UTIL.put_timestamp('End Timestamp');
4778: FII_UTIL.stop_timer;
4779: FII_UTIL.print_timer('Duration');
4780: FII_UTIL.put_line('');
4781: FII_UTIL.start_timer;
4782: FII_UTIL.put_line('');
4783: end if;
4784:
4785: commit;

Line 4782: FII_UTIL.put_line('');

4778: FII_UTIL.stop_timer;
4779: FII_UTIL.print_timer('Duration');
4780: FII_UTIL.put_line('');
4781: FII_UTIL.start_timer;
4782: FII_UTIL.put_line('');
4783: end if;
4784:
4785: commit;
4786:

Line 4789: FII_UTIL.put_line('');

4785: commit;
4786:
4787: g_state := 'Inserting the Payment Schedules Due Bucket3 Action';
4788: if g_debug_flag = 'Y' then
4789: FII_UTIL.put_line('');
4790: FII_UTIL.put_line(g_state);
4791: FII_UTIL.put_timestamp('Start Timestamp');
4792: FII_UTIL.start_timer;
4793: FII_UTIL.put_line('');

Line 4790: FII_UTIL.put_line(g_state);

4786:
4787: g_state := 'Inserting the Payment Schedules Due Bucket3 Action';
4788: if g_debug_flag = 'Y' then
4789: FII_UTIL.put_line('');
4790: FII_UTIL.put_line(g_state);
4791: FII_UTIL.put_timestamp('Start Timestamp');
4792: FII_UTIL.start_timer;
4793: FII_UTIL.put_line('');
4794: end if;

Line 4791: FII_UTIL.put_timestamp('Start Timestamp');

4787: g_state := 'Inserting the Payment Schedules Due Bucket3 Action';
4788: if g_debug_flag = 'Y' then
4789: FII_UTIL.put_line('');
4790: FII_UTIL.put_line(g_state);
4791: FII_UTIL.put_timestamp('Start Timestamp');
4792: FII_UTIL.start_timer;
4793: FII_UTIL.put_line('');
4794: end if;
4795:

Line 4792: FII_UTIL.start_timer;

4788: if g_debug_flag = 'Y' then
4789: FII_UTIL.put_line('');
4790: FII_UTIL.put_line(g_state);
4791: FII_UTIL.put_timestamp('Start Timestamp');
4792: FII_UTIL.start_timer;
4793: FII_UTIL.put_line('');
4794: end if;
4795:
4796: /* Inserting the Due Bucket records into the summary table.

Line 4793: FII_UTIL.put_line('');

4789: FII_UTIL.put_line('');
4790: FII_UTIL.put_line(g_state);
4791: FII_UTIL.put_timestamp('Start Timestamp');
4792: FII_UTIL.start_timer;
4793: FII_UTIL.put_line('');
4794: end if;
4795:
4796: /* Inserting the Due Bucket records into the summary table.
4797: We will insert only those payment schedules which have not been paid

Line 5051: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Due Bucket3 records into FII_AP_PAY_SCHED_B');

5047: + NVL(PP.Prepay_Amount,0)) < ABS(PS.Gross_Amount);
5048:
5049:
5050: if g_debug_flag = 'Y' then
5051: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Due Bucket3 records into FII_AP_PAY_SCHED_B');
5052: FII_UTIL.put_timestamp('End Timestamp');
5053: FII_UTIL.stop_timer;
5054: FII_UTIL.print_timer('Duration');
5055: FII_UTIL.put_line('');

Line 5052: FII_UTIL.put_timestamp('End Timestamp');

5048:
5049:
5050: if g_debug_flag = 'Y' then
5051: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Due Bucket3 records into FII_AP_PAY_SCHED_B');
5052: FII_UTIL.put_timestamp('End Timestamp');
5053: FII_UTIL.stop_timer;
5054: FII_UTIL.print_timer('Duration');
5055: FII_UTIL.put_line('');
5056: end if;

Line 5053: FII_UTIL.stop_timer;

5049:
5050: if g_debug_flag = 'Y' then
5051: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Due Bucket3 records into FII_AP_PAY_SCHED_B');
5052: FII_UTIL.put_timestamp('End Timestamp');
5053: FII_UTIL.stop_timer;
5054: FII_UTIL.print_timer('Duration');
5055: FII_UTIL.put_line('');
5056: end if;
5057:

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

5050: if g_debug_flag = 'Y' then
5051: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Due Bucket3 records into FII_AP_PAY_SCHED_B');
5052: FII_UTIL.put_timestamp('End Timestamp');
5053: FII_UTIL.stop_timer;
5054: FII_UTIL.print_timer('Duration');
5055: FII_UTIL.put_line('');
5056: end if;
5057:
5058: commit;

Line 5055: FII_UTIL.put_line('');

5051: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Due Bucket3 records into FII_AP_PAY_SCHED_B');
5052: FII_UTIL.put_timestamp('End Timestamp');
5053: FII_UTIL.stop_timer;
5054: FII_UTIL.print_timer('Duration');
5055: FII_UTIL.put_line('');
5056: end if;
5057:
5058: commit;
5059:

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

5061: WHEN OTHERS THEN
5062: g_errbuf:=sqlerrm;
5063: g_retcode:= -1;
5064: g_exception_msg := g_retcode || ':' || g_errbuf;
5065: FII_UTIL.put_line('Error occured while ' || g_state);
5066: FII_UTIL.put_line(g_exception_msg);
5067: RAISE;
5068: END;
5069:

Line 5066: FII_UTIL.put_line(g_exception_msg);

5062: g_errbuf:=sqlerrm;
5063: g_retcode:= -1;
5064: g_exception_msg := g_retcode || ':' || g_errbuf;
5065: FII_UTIL.put_line('Error occured while ' || g_state);
5066: FII_UTIL.put_line(g_exception_msg);
5067: RAISE;
5068: END;
5069:
5070:

Line 5084: FII_UTIL.put_line('');

5080: BEGIN
5081:
5082: g_state := 'Inside the procedure POPULATE_PS_PAST_BUCKET_ACTION';
5083: if g_debug_flag = 'Y' then
5084: FII_UTIL.put_line('');
5085: FII_UTIL.put_line(g_state);
5086: end if;
5087:
5088: g_state := 'Inserting the Payment Schedules Past Due Bucket2 Action';

Line 5085: FII_UTIL.put_line(g_state);

5081:
5082: g_state := 'Inside the procedure POPULATE_PS_PAST_BUCKET_ACTION';
5083: if g_debug_flag = 'Y' then
5084: FII_UTIL.put_line('');
5085: FII_UTIL.put_line(g_state);
5086: end if;
5087:
5088: g_state := 'Inserting the Payment Schedules Past Due Bucket2 Action';
5089: if g_debug_flag = 'Y' then

Line 5090: FII_UTIL.put_line('');

5086: end if;
5087:
5088: g_state := 'Inserting the Payment Schedules Past Due Bucket2 Action';
5089: if g_debug_flag = 'Y' then
5090: FII_UTIL.put_line('');
5091: FII_UTIL.put_line(g_state);
5092: FII_UTIL.put_timestamp('Start Timestamp');
5093: FII_UTIL.start_timer;
5094: FII_UTIL.put_line('');

Line 5091: FII_UTIL.put_line(g_state);

5087:
5088: g_state := 'Inserting the Payment Schedules Past Due Bucket2 Action';
5089: if g_debug_flag = 'Y' then
5090: FII_UTIL.put_line('');
5091: FII_UTIL.put_line(g_state);
5092: FII_UTIL.put_timestamp('Start Timestamp');
5093: FII_UTIL.start_timer;
5094: FII_UTIL.put_line('');
5095: end if;

Line 5092: FII_UTIL.put_timestamp('Start Timestamp');

5088: g_state := 'Inserting the Payment Schedules Past Due Bucket2 Action';
5089: if g_debug_flag = 'Y' then
5090: FII_UTIL.put_line('');
5091: FII_UTIL.put_line(g_state);
5092: FII_UTIL.put_timestamp('Start Timestamp');
5093: FII_UTIL.start_timer;
5094: FII_UTIL.put_line('');
5095: end if;
5096:

Line 5093: FII_UTIL.start_timer;

5089: if g_debug_flag = 'Y' then
5090: FII_UTIL.put_line('');
5091: FII_UTIL.put_line(g_state);
5092: FII_UTIL.put_timestamp('Start Timestamp');
5093: FII_UTIL.start_timer;
5094: FII_UTIL.put_line('');
5095: end if;
5096:
5097:

Line 5094: FII_UTIL.put_line('');

5090: FII_UTIL.put_line('');
5091: FII_UTIL.put_line(g_state);
5092: FII_UTIL.put_timestamp('Start Timestamp');
5093: FII_UTIL.start_timer;
5094: FII_UTIL.put_line('');
5095: end if;
5096:
5097:
5098: /* Inserting the Past Due Bucket records into the summary table.

Line 5353: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Past Due Bucket2 records into FII_AP_PAY_SCHED_B');

5349: + NVL(PP.Prepay_Amount,0)) < ABS(PS.Gross_Amount);
5350:
5351:
5352: if g_debug_flag = 'Y' then
5353: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Past Due Bucket2 records into FII_AP_PAY_SCHED_B');
5354: FII_UTIL.put_timestamp('End Timestamp');
5355: FII_UTIL.stop_timer;
5356: FII_UTIL.print_timer('Duration');
5357: end if;

Line 5354: FII_UTIL.put_timestamp('End Timestamp');

5350:
5351:
5352: if g_debug_flag = 'Y' then
5353: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Past Due Bucket2 records into FII_AP_PAY_SCHED_B');
5354: FII_UTIL.put_timestamp('End Timestamp');
5355: FII_UTIL.stop_timer;
5356: FII_UTIL.print_timer('Duration');
5357: end if;
5358:

Line 5355: FII_UTIL.stop_timer;

5351:
5352: if g_debug_flag = 'Y' then
5353: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Past Due Bucket2 records into FII_AP_PAY_SCHED_B');
5354: FII_UTIL.put_timestamp('End Timestamp');
5355: FII_UTIL.stop_timer;
5356: FII_UTIL.print_timer('Duration');
5357: end if;
5358:
5359: commit;

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

5352: if g_debug_flag = 'Y' then
5353: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Past Due Bucket2 records into FII_AP_PAY_SCHED_B');
5354: FII_UTIL.put_timestamp('End Timestamp');
5355: FII_UTIL.stop_timer;
5356: FII_UTIL.print_timer('Duration');
5357: end if;
5358:
5359: commit;
5360:

Line 5363: FII_UTIL.put_line('');

5359: commit;
5360:
5361: g_state := 'Inserting the Payment Schedules Past Due Bucket1 Action';
5362: if g_debug_flag = 'Y' then
5363: FII_UTIL.put_line('');
5364: FII_UTIL.put_line(g_state);
5365: FII_UTIL.put_timestamp('Start Timestamp');
5366: FII_UTIL.start_timer;
5367: FII_UTIL.put_line('');

Line 5364: FII_UTIL.put_line(g_state);

5360:
5361: g_state := 'Inserting the Payment Schedules Past Due Bucket1 Action';
5362: if g_debug_flag = 'Y' then
5363: FII_UTIL.put_line('');
5364: FII_UTIL.put_line(g_state);
5365: FII_UTIL.put_timestamp('Start Timestamp');
5366: FII_UTIL.start_timer;
5367: FII_UTIL.put_line('');
5368: end if;

Line 5365: FII_UTIL.put_timestamp('Start Timestamp');

5361: g_state := 'Inserting the Payment Schedules Past Due Bucket1 Action';
5362: if g_debug_flag = 'Y' then
5363: FII_UTIL.put_line('');
5364: FII_UTIL.put_line(g_state);
5365: FII_UTIL.put_timestamp('Start Timestamp');
5366: FII_UTIL.start_timer;
5367: FII_UTIL.put_line('');
5368: end if;
5369:

Line 5366: FII_UTIL.start_timer;

5362: if g_debug_flag = 'Y' then
5363: FII_UTIL.put_line('');
5364: FII_UTIL.put_line(g_state);
5365: FII_UTIL.put_timestamp('Start Timestamp');
5366: FII_UTIL.start_timer;
5367: FII_UTIL.put_line('');
5368: end if;
5369:
5370:

Line 5367: FII_UTIL.put_line('');

5363: FII_UTIL.put_line('');
5364: FII_UTIL.put_line(g_state);
5365: FII_UTIL.put_timestamp('Start Timestamp');
5366: FII_UTIL.start_timer;
5367: FII_UTIL.put_line('');
5368: end if;
5369:
5370:
5371: /* Inserting the Past Due Bucket records into the summary table.

Line 5626: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Past Due Bucket1 records into FII_AP_PAY_SCHED_B');

5622: + NVL(PP.Prepay_Amount,0)) < ABS(PS.Gross_Amount);
5623:
5624:
5625: if g_debug_flag = 'Y' then
5626: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Past Due Bucket1 records into FII_AP_PAY_SCHED_B');
5627: FII_UTIL.put_timestamp('End Timestamp');
5628: FII_UTIL.stop_timer;
5629: FII_UTIL.print_timer('Duration');
5630: FII_UTIL.put_line('');

Line 5627: FII_UTIL.put_timestamp('End Timestamp');

5623:
5624:
5625: if g_debug_flag = 'Y' then
5626: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Past Due Bucket1 records into FII_AP_PAY_SCHED_B');
5627: FII_UTIL.put_timestamp('End Timestamp');
5628: FII_UTIL.stop_timer;
5629: FII_UTIL.print_timer('Duration');
5630: FII_UTIL.put_line('');
5631: end if;

Line 5628: FII_UTIL.stop_timer;

5624:
5625: if g_debug_flag = 'Y' then
5626: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Past Due Bucket1 records into FII_AP_PAY_SCHED_B');
5627: FII_UTIL.put_timestamp('End Timestamp');
5628: FII_UTIL.stop_timer;
5629: FII_UTIL.print_timer('Duration');
5630: FII_UTIL.put_line('');
5631: end if;
5632:

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

5625: if g_debug_flag = 'Y' then
5626: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Past Due Bucket1 records into FII_AP_PAY_SCHED_B');
5627: FII_UTIL.put_timestamp('End Timestamp');
5628: FII_UTIL.stop_timer;
5629: FII_UTIL.print_timer('Duration');
5630: FII_UTIL.put_line('');
5631: end if;
5632:
5633: commit;

Line 5630: FII_UTIL.put_line('');

5626: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Past Due Bucket1 records into FII_AP_PAY_SCHED_B');
5627: FII_UTIL.put_timestamp('End Timestamp');
5628: FII_UTIL.stop_timer;
5629: FII_UTIL.print_timer('Duration');
5630: FII_UTIL.put_line('');
5631: end if;
5632:
5633: commit;
5634:

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

5637: WHEN OTHERS THEN
5638: g_errbuf:=sqlerrm;
5639: g_retcode:= -1;
5640: g_exception_msg := g_retcode || ':' || g_errbuf;
5641: FII_UTIL.put_line('Error occured while ' || g_state);
5642: FII_UTIL.put_line(g_exception_msg);
5643: RAISE;
5644: END;
5645:

Line 5642: FII_UTIL.put_line(g_exception_msg);

5638: g_errbuf:=sqlerrm;
5639: g_retcode:= -1;
5640: g_exception_msg := g_retcode || ':' || g_errbuf;
5641: FII_UTIL.put_line('Error occured while ' || g_state);
5642: FII_UTIL.put_line(g_exception_msg);
5643: RAISE;
5644: END;
5645:
5646:

Line 5662: FII_UTIL.put_line('');

5658: BEGIN
5659:
5660: g_state := 'Inside the procedure POPULATE_PAY_SCHED_SUM';
5661: if g_debug_flag = 'Y' then
5662: FII_UTIL.put_line('');
5663: FII_UTIL.put_line(g_state);
5664: end if;
5665:
5666: g_start_range := p_start_range;

Line 5663: FII_UTIL.put_line(g_state);

5659:
5660: g_state := 'Inside the procedure POPULATE_PAY_SCHED_SUM';
5661: if g_debug_flag = 'Y' then
5662: FII_UTIL.put_line('');
5663: FII_UTIL.put_line(g_state);
5664: end if;
5665:
5666: g_start_range := p_start_range;
5667: g_end_range := p_end_range;

Line 5670: FII_UTIL.put_line('g_start_date is '|| g_start_date);

5666: g_start_range := p_start_range;
5667: g_end_range := p_end_range;
5668:
5669: if g_debug_flag = 'Y' then
5670: FII_UTIL.put_line('g_start_date is '|| g_start_date);
5671: FII_UTIL.put_line('g_end_date is '|| g_end_date);
5672: FII_UTIL.put_line('g_start_range is '|| g_start_range);
5673: FII_UTIL.put_line('g_end_range is '|| g_end_range);
5674: end if;

Line 5671: FII_UTIL.put_line('g_end_date is '|| g_end_date);

5667: g_end_range := p_end_range;
5668:
5669: if g_debug_flag = 'Y' then
5670: FII_UTIL.put_line('g_start_date is '|| g_start_date);
5671: FII_UTIL.put_line('g_end_date is '|| g_end_date);
5672: FII_UTIL.put_line('g_start_range is '|| g_start_range);
5673: FII_UTIL.put_line('g_end_range is '|| g_end_range);
5674: end if;
5675:

Line 5672: FII_UTIL.put_line('g_start_range is '|| g_start_range);

5668:
5669: if g_debug_flag = 'Y' then
5670: FII_UTIL.put_line('g_start_date is '|| g_start_date);
5671: FII_UTIL.put_line('g_end_date is '|| g_end_date);
5672: FII_UTIL.put_line('g_start_range is '|| g_start_range);
5673: FII_UTIL.put_line('g_end_range is '|| g_end_range);
5674: end if;
5675:
5676: SELECT fii_ap_pay_sched_b_s.nextval

Line 5673: FII_UTIL.put_line('g_end_range is '|| g_end_range);

5669: if g_debug_flag = 'Y' then
5670: FII_UTIL.put_line('g_start_date is '|| g_start_date);
5671: FII_UTIL.put_line('g_end_date is '|| g_end_date);
5672: FII_UTIL.put_line('g_start_range is '|| g_start_range);
5673: FII_UTIL.put_line('g_end_range is '|| g_end_range);
5674: end if;
5675:
5676: SELECT fii_ap_pay_sched_b_s.nextval
5677: INTO g_seq_id

Line 5682: FII_UTIL.put_line(g_state);

5678: FROM dual;
5679:
5680: g_state := 'Populating FII_AP_PAY_SCHED_B FROM AP_PAYMENT_SCHEDULES_ALL table';
5681: if g_debug_flag = 'Y' then
5682: FII_UTIL.put_line(g_state);
5683: end if;
5684:
5685: g_state := 'Populating Payment Schedules Creation records';
5686: if g_debug_flag = 'Y' then

Line 5687: FII_UTIL.put_line(g_state);

5683: end if;
5684:
5685: g_state := 'Populating Payment Schedules Creation records';
5686: if g_debug_flag = 'Y' then
5687: FII_UTIL.put_line(g_state);
5688: FII_UTIL.put_timestamp('Start Timestamp');
5689: FII_UTIL.start_timer;
5690: FII_UTIL.put_line('');
5691: end if;

Line 5688: FII_UTIL.put_timestamp('Start Timestamp');

5684:
5685: g_state := 'Populating Payment Schedules Creation records';
5686: if g_debug_flag = 'Y' then
5687: FII_UTIL.put_line(g_state);
5688: FII_UTIL.put_timestamp('Start Timestamp');
5689: FII_UTIL.start_timer;
5690: FII_UTIL.put_line('');
5691: end if;
5692:

Line 5689: FII_UTIL.start_timer;

5685: g_state := 'Populating Payment Schedules Creation records';
5686: if g_debug_flag = 'Y' then
5687: FII_UTIL.put_line(g_state);
5688: FII_UTIL.put_timestamp('Start Timestamp');
5689: FII_UTIL.start_timer;
5690: FII_UTIL.put_line('');
5691: end if;
5692:
5693: INSERT INTO FII_AP_PAY_SCHED_B b

Line 5690: FII_UTIL.put_line('');

5686: if g_debug_flag = 'Y' then
5687: FII_UTIL.put_line(g_state);
5688: FII_UTIL.put_timestamp('Start Timestamp');
5689: FII_UTIL.start_timer;
5690: FII_UTIL.put_line('');
5691: end if;
5692:
5693: INSERT INTO FII_AP_PAY_SCHED_B b
5694: (Time_ID,

Line 5977: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Creation records into FII_AP_PAY_SCHED_B');

5973: AND RATES.Trx_Date = PSUM.Invoice_Date;
5974:
5975:
5976: if g_debug_flag = 'Y' then
5977: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Creation records into FII_AP_PAY_SCHED_B');
5978: FII_UTIL.put_timestamp('End Timestamp');
5979: FII_UTIL.stop_timer;
5980: FII_UTIL.print_timer('Duration');
5981: FII_UTIL.put_line('');

Line 5978: FII_UTIL.put_timestamp('End Timestamp');

5974:
5975:
5976: if g_debug_flag = 'Y' then
5977: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Creation records into FII_AP_PAY_SCHED_B');
5978: FII_UTIL.put_timestamp('End Timestamp');
5979: FII_UTIL.stop_timer;
5980: FII_UTIL.print_timer('Duration');
5981: FII_UTIL.put_line('');
5982: end if;

Line 5979: FII_UTIL.stop_timer;

5975:
5976: if g_debug_flag = 'Y' then
5977: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Creation records into FII_AP_PAY_SCHED_B');
5978: FII_UTIL.put_timestamp('End Timestamp');
5979: FII_UTIL.stop_timer;
5980: FII_UTIL.print_timer('Duration');
5981: FII_UTIL.put_line('');
5982: end if;
5983:

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

5976: if g_debug_flag = 'Y' then
5977: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Creation records into FII_AP_PAY_SCHED_B');
5978: FII_UTIL.put_timestamp('End Timestamp');
5979: FII_UTIL.stop_timer;
5980: FII_UTIL.print_timer('Duration');
5981: FII_UTIL.put_line('');
5982: end if;
5983:
5984: COMMIT;

Line 5981: FII_UTIL.put_line('');

5977: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Creation records into FII_AP_PAY_SCHED_B');
5978: FII_UTIL.put_timestamp('End Timestamp');
5979: FII_UTIL.stop_timer;
5980: FII_UTIL.print_timer('Duration');
5981: FII_UTIL.put_line('');
5982: end if;
5983:
5984: COMMIT;
5985:

Line 5987: FII_UTIL.put_line('Calling procedure POPULATE_PS_DISC_ACTION');

5983:
5984: COMMIT;
5985:
5986: if g_debug_flag = 'Y' then
5987: FII_UTIL.put_line('Calling procedure POPULATE_PS_DISC_ACTION');
5988: FII_UTIL.put_line('');
5989: end if;
5990:
5991: POPULATE_PS_DISCOUNT_ACTION;

Line 5988: FII_UTIL.put_line('');

5984: COMMIT;
5985:
5986: if g_debug_flag = 'Y' then
5987: FII_UTIL.put_line('Calling procedure POPULATE_PS_DISC_ACTION');
5988: FII_UTIL.put_line('');
5989: end if;
5990:
5991: POPULATE_PS_DISCOUNT_ACTION;
5992:

Line 5995: FII_UTIL.put_line('Calling procedure POPULATE_PS_PAYMENT_ACTION');

5991: POPULATE_PS_DISCOUNT_ACTION;
5992:
5993:
5994: if g_debug_flag = 'Y' then
5995: FII_UTIL.put_line('Calling procedure POPULATE_PS_PAYMENT_ACTION');
5996: FII_UTIL.put_line('');
5997: end if;
5998:
5999: POPULATE_PS_PAYMENT_ACTION;

Line 5996: FII_UTIL.put_line('');

5992:
5993:
5994: if g_debug_flag = 'Y' then
5995: FII_UTIL.put_line('Calling procedure POPULATE_PS_PAYMENT_ACTION');
5996: FII_UTIL.put_line('');
5997: end if;
5998:
5999: POPULATE_PS_PAYMENT_ACTION;
6000:

Line 6003: FII_UTIL.put_line('Calling procedure POPULATE_PS_DUE_ACTION');

5999: POPULATE_PS_PAYMENT_ACTION;
6000:
6001:
6002: if g_debug_flag = 'Y' then
6003: FII_UTIL.put_line('Calling procedure POPULATE_PS_DUE_ACTION');
6004: FII_UTIL.put_line('');
6005: end if;
6006:
6007: POPULATE_PS_DUE_ACTION;

Line 6004: FII_UTIL.put_line('');

6000:
6001:
6002: if g_debug_flag = 'Y' then
6003: FII_UTIL.put_line('Calling procedure POPULATE_PS_DUE_ACTION');
6004: FII_UTIL.put_line('');
6005: end if;
6006:
6007: POPULATE_PS_DUE_ACTION;
6008:

Line 6011: FII_UTIL.put_line('Calling procedure POPULATE_PS_BUCKET_ACTION');

6007: POPULATE_PS_DUE_ACTION;
6008:
6009:
6010: if g_debug_flag = 'Y' then
6011: FII_UTIL.put_line('Calling procedure POPULATE_PS_BUCKET_ACTION');
6012: FII_UTIL.put_line('');
6013: end if;
6014:
6015: POPULATE_PS_BUCKET_ACTION;

Line 6012: FII_UTIL.put_line('');

6008:
6009:
6010: if g_debug_flag = 'Y' then
6011: FII_UTIL.put_line('Calling procedure POPULATE_PS_BUCKET_ACTION');
6012: FII_UTIL.put_line('');
6013: end if;
6014:
6015: POPULATE_PS_BUCKET_ACTION;
6016:

Line 6019: FII_UTIL.put_line('Calling procedure POPULATE_PS_PAST_BUCKET_ACTION');

6015: POPULATE_PS_BUCKET_ACTION;
6016:
6017:
6018: if g_debug_flag = 'Y' then
6019: FII_UTIL.put_line('Calling procedure POPULATE_PS_PAST_BUCKET_ACTION');
6020: FII_UTIL.put_line('');
6021: end if;
6022:
6023: POPULATE_PS_PAST_BUCKET_ACTION;

Line 6020: FII_UTIL.put_line('');

6016:
6017:
6018: if g_debug_flag = 'Y' then
6019: FII_UTIL.put_line('Calling procedure POPULATE_PS_PAST_BUCKET_ACTION');
6020: FII_UTIL.put_line('');
6021: end if;
6022:
6023: POPULATE_PS_PAST_BUCKET_ACTION;
6024:

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

6026: WHEN OTHERS THEN
6027: g_errbuf:=sqlerrm;
6028: g_retcode:= -1;
6029: g_exception_msg := g_retcode || ':' || g_errbuf;
6030: FII_UTIL.put_line('Error occured while ' || g_state);
6031: FII_UTIL.put_line(g_exception_msg);
6032: RAISE;
6033: END;
6034:

Line 6031: FII_UTIL.put_line(g_exception_msg);

6027: g_errbuf:=sqlerrm;
6028: g_retcode:= -1;
6029: g_exception_msg := g_retcode || ':' || g_errbuf;
6030: FII_UTIL.put_line('Error occured while ' || g_state);
6031: FII_UTIL.put_line(g_exception_msg);
6032: RAISE;
6033: END;
6034:
6035:

Line 6054: FII_UTIL.put_line('');

6050: BEGIN
6051:
6052: g_state := 'Inside the procedure POPULATE_PS_BUCKET_COUNT';
6053: if g_debug_flag = 'Y' then
6054: FII_UTIL.put_line('');
6055: FII_UTIL.put_line(g_state);
6056: end if;
6057:
6058: /* **************************************************************************

Line 6055: FII_UTIL.put_line(g_state);

6051:
6052: g_state := 'Inside the procedure POPULATE_PS_BUCKET_COUNT';
6053: if g_debug_flag = 'Y' then
6054: FII_UTIL.put_line('');
6055: FII_UTIL.put_line(g_state);
6056: end if;
6057:
6058: /* **************************************************************************
6059: Steps to populate FII_AP_AGING_BKTS_B and FII_AP_DUE_COUNTS_B:

Line 6117: FII_UTIL.put_line('');

6113: ************************************************************************** */
6114:
6115: g_state := 'Deleting records from FII_AP_INV_BUCKETS that are already existing';
6116: if g_debug_flag = 'Y' then
6117: FII_UTIL.put_line('');
6118: FII_UTIL.put_line(g_state);
6119: end if;
6120:
6121:

Line 6118: FII_UTIL.put_line(g_state);

6114:
6115: g_state := 'Deleting records from FII_AP_INV_BUCKETS that are already existing';
6116: if g_debug_flag = 'Y' then
6117: FII_UTIL.put_line('');
6118: FII_UTIL.put_line(g_state);
6119: end if;
6120:
6121:
6122: /* For Initial Load we will truncate the data in the count table

Line 6132: FII_UTIL.put_line(g_state);

6128: TRUNCATE_TABLE('FII_AP_DUE_COUNTS_B');
6129:
6130: g_state := 'Populating FII_AP_AGING_BKTS_B and FII_AP_DUE_COUNTS_B table';
6131: if g_debug_flag = 'Y' then
6132: FII_UTIL.put_line(g_state);
6133: FII_UTIL.start_timer;
6134: FII_UTIL.put_line('');
6135: end if;
6136:

Line 6133: FII_UTIL.start_timer;

6129:
6130: g_state := 'Populating FII_AP_AGING_BKTS_B and FII_AP_DUE_COUNTS_B table';
6131: if g_debug_flag = 'Y' then
6132: FII_UTIL.put_line(g_state);
6133: FII_UTIL.start_timer;
6134: FII_UTIL.put_line('');
6135: end if;
6136:
6137:

Line 6134: FII_UTIL.put_line('');

6130: g_state := 'Populating FII_AP_AGING_BKTS_B and FII_AP_DUE_COUNTS_B table';
6131: if g_debug_flag = 'Y' then
6132: FII_UTIL.put_line(g_state);
6133: FII_UTIL.start_timer;
6134: FII_UTIL.put_line('');
6135: end if;
6136:
6137:
6138: INSERT /*+ append parallel(fii_ap_aging_bkts_b) parallel(fii_ap_due_counts_b) */ ALL

Line 6437: FII_UTIL.put_line('Inserted '|| SQL%ROWCOUNT ||' records into FII_AP_AGING_BKTS_B and FII_AP_DUE_COUNTS_B');

6433: COMMIT;
6434:
6435:
6436: if g_debug_flag = 'Y' then
6437: FII_UTIL.put_line('Inserted '|| SQL%ROWCOUNT ||' records into FII_AP_AGING_BKTS_B and FII_AP_DUE_COUNTS_B');
6438: FII_UTIL.stop_timer;
6439: FII_UTIL.print_timer('Duration');
6440: FII_UTIL.put_line('');
6441: end if;

Line 6438: FII_UTIL.stop_timer;

6434:
6435:
6436: if g_debug_flag = 'Y' then
6437: FII_UTIL.put_line('Inserted '|| SQL%ROWCOUNT ||' records into FII_AP_AGING_BKTS_B and FII_AP_DUE_COUNTS_B');
6438: FII_UTIL.stop_timer;
6439: FII_UTIL.print_timer('Duration');
6440: FII_UTIL.put_line('');
6441: end if;
6442:

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

6435:
6436: if g_debug_flag = 'Y' then
6437: FII_UTIL.put_line('Inserted '|| SQL%ROWCOUNT ||' records into FII_AP_AGING_BKTS_B and FII_AP_DUE_COUNTS_B');
6438: FII_UTIL.stop_timer;
6439: FII_UTIL.print_timer('Duration');
6440: FII_UTIL.put_line('');
6441: end if;
6442:
6443: -- g_state := 'Truncating temp tables used to populate FII_AP_AGING_BKTS_B and FII_AP_DUE_COUNTS_B';

Line 6440: FII_UTIL.put_line('');

6436: if g_debug_flag = 'Y' then
6437: FII_UTIL.put_line('Inserted '|| SQL%ROWCOUNT ||' records into FII_AP_AGING_BKTS_B and FII_AP_DUE_COUNTS_B');
6438: FII_UTIL.stop_timer;
6439: FII_UTIL.print_timer('Duration');
6440: FII_UTIL.put_line('');
6441: end if;
6442:
6443: -- g_state := 'Truncating temp tables used to populate FII_AP_AGING_BKTS_B and FII_AP_DUE_COUNTS_B';
6444: -- TRUNCATE_TABLE('FII_AP_BUCKET_CALCS');

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

6449: WHEN OTHERS THEN
6450: g_errbuf:=sqlerrm;
6451: g_retcode:= -1;
6452: g_exception_msg := g_retcode || ':' || g_errbuf;
6453: FII_UTIL.put_line('Error occured while ' || g_state);
6454: FII_UTIL.put_line(g_exception_msg);
6455: RAISE;
6456:
6457: END POPULATE_PS_BUCKET_COUNT;

Line 6454: FII_UTIL.put_line(g_exception_msg);

6450: g_errbuf:=sqlerrm;
6451: g_retcode:= -1;
6452: g_exception_msg := g_retcode || ':' || g_errbuf;
6453: FII_UTIL.put_line('Error occured while ' || g_state);
6454: FII_UTIL.put_line(g_exception_msg);
6455: RAISE;
6456:
6457: END POPULATE_PS_BUCKET_COUNT;
6458:

Line 6474: FII_UTIL.put_line('');

6470: BEGIN
6471:
6472: g_state := 'Inside the procedure POPULATE_HOLD_HISTORY';
6473: if g_debug_flag = 'Y' then
6474: FII_UTIL.put_line('');
6475: FII_UTIL.put_line(g_state);
6476: end if;
6477:
6478: g_state := 'Deleting records from FII_AP_HOLD_HIST_B that are already existing';

Line 6475: FII_UTIL.put_line(g_state);

6471:
6472: g_state := 'Inside the procedure POPULATE_HOLD_HISTORY';
6473: if g_debug_flag = 'Y' then
6474: FII_UTIL.put_line('');
6475: FII_UTIL.put_line(g_state);
6476: end if;
6477:
6478: g_state := 'Deleting records from FII_AP_HOLD_HIST_B that are already existing';
6479: if g_debug_flag = 'Y' then

Line 6480: FII_UTIL.put_line('');

6476: end if;
6477:
6478: g_state := 'Deleting records from FII_AP_HOLD_HIST_B that are already existing';
6479: if g_debug_flag = 'Y' then
6480: FII_UTIL.put_line('');
6481: FII_UTIL.put_line(g_state);
6482: end if;
6483:
6484:

Line 6481: FII_UTIL.put_line(g_state);

6477:
6478: g_state := 'Deleting records from FII_AP_HOLD_HIST_B that are already existing';
6479: if g_debug_flag = 'Y' then
6480: FII_UTIL.put_line('');
6481: FII_UTIL.put_line(g_state);
6482: end if;
6483:
6484:
6485: /* For Initial Load we will truncate the data in the hold history table

Line 6493: FII_UTIL.put_line(g_state);

6489:
6490:
6491: g_state := 'Populating FII_AP_HOLD_HIST_B FROM AP_HOLDS_ALL table';
6492: if g_debug_flag = 'Y' then
6493: FII_UTIL.put_line(g_state);
6494: end if;
6495:
6496: g_state := 'Populating Hold and Release Records';
6497: if g_debug_flag = 'Y' then

Line 6498: FII_UTIL.put_line(g_state);

6494: end if;
6495:
6496: g_state := 'Populating Hold and Release Records';
6497: if g_debug_flag = 'Y' then
6498: FII_UTIL.put_line(g_state);
6499: FII_UTIL.start_timer;
6500: FII_UTIL.put_line('');
6501: end if;
6502:

Line 6499: FII_UTIL.start_timer;

6495:
6496: g_state := 'Populating Hold and Release Records';
6497: if g_debug_flag = 'Y' then
6498: FII_UTIL.put_line(g_state);
6499: FII_UTIL.start_timer;
6500: FII_UTIL.put_line('');
6501: end if;
6502:
6503: /* Only insert a 'H' record for the first hold in a series of overlapping

Line 6500: FII_UTIL.put_line('');

6496: g_state := 'Populating Hold and Release Records';
6497: if g_debug_flag = 'Y' then
6498: FII_UTIL.put_line(g_state);
6499: FII_UTIL.start_timer;
6500: FII_UTIL.put_line('');
6501: end if;
6502:
6503: /* Only insert a 'H' record for the first hold in a series of overlapping
6504: holds. The first part of the union does this by checking if this hold is

Line 6598: FII_UTIL.put_line('Inserted '|| SQL%ROWCOUNT ||' Hold and Release records into FII_AP_HOLD_HIST_B');

6594: AND AI.Invoice_Type NOT IN ('PREPAYMENT'));
6595:
6596:
6597: if g_debug_flag = 'Y' then
6598: FII_UTIL.put_line('Inserted '|| SQL%ROWCOUNT ||' Hold and Release records into FII_AP_HOLD_HIST_B');
6599: FII_UTIL.stop_timer;
6600: FII_UTIL.print_timer('Duration');
6601: FII_UTIL.put_line('');
6602: end if;

Line 6599: FII_UTIL.stop_timer;

6595:
6596:
6597: if g_debug_flag = 'Y' then
6598: FII_UTIL.put_line('Inserted '|| SQL%ROWCOUNT ||' Hold and Release records into FII_AP_HOLD_HIST_B');
6599: FII_UTIL.stop_timer;
6600: FII_UTIL.print_timer('Duration');
6601: FII_UTIL.put_line('');
6602: end if;
6603:

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

6596:
6597: if g_debug_flag = 'Y' then
6598: FII_UTIL.put_line('Inserted '|| SQL%ROWCOUNT ||' Hold and Release records into FII_AP_HOLD_HIST_B');
6599: FII_UTIL.stop_timer;
6600: FII_UTIL.print_timer('Duration');
6601: FII_UTIL.put_line('');
6602: end if;
6603:
6604: COMMIT;

Line 6601: FII_UTIL.put_line('');

6597: if g_debug_flag = 'Y' then
6598: FII_UTIL.put_line('Inserted '|| SQL%ROWCOUNT ||' Hold and Release records into FII_AP_HOLD_HIST_B');
6599: FII_UTIL.stop_timer;
6600: FII_UTIL.print_timer('Duration');
6601: FII_UTIL.put_line('');
6602: end if;
6603:
6604: COMMIT;
6605:

Line 6608: FII_UTIL.put_line(g_state);

6604: COMMIT;
6605:
6606: g_state := 'Updating Seq_ID for the Release Records';
6607: if g_debug_flag = 'Y' then
6608: FII_UTIL.put_line(g_state);
6609: FII_UTIL.start_timer;
6610: FII_UTIL.put_line('');
6611: end if;
6612:

Line 6609: FII_UTIL.start_timer;

6605:
6606: g_state := 'Updating Seq_ID for the Release Records';
6607: if g_debug_flag = 'Y' then
6608: FII_UTIL.put_line(g_state);
6609: FII_UTIL.start_timer;
6610: FII_UTIL.put_line('');
6611: end if;
6612:
6613: UPDATE FII_AP_Hold_Hist_B HH

Line 6610: FII_UTIL.put_line('');

6606: g_state := 'Updating Seq_ID for the Release Records';
6607: if g_debug_flag = 'Y' then
6608: FII_UTIL.put_line(g_state);
6609: FII_UTIL.start_timer;
6610: FII_UTIL.put_line('');
6611: end if;
6612:
6613: UPDATE FII_AP_Hold_Hist_B HH
6614: SET Seq_ID = (SELECT HH1.Seq_ID

Line 6634: FII_UTIL.put_line('Updated '|| SQL%ROWCOUNT ||' Release records in the FII_AP_HOLD_HIST_B');

6630: AND HH.Seq_ID IS NULL;
6631:
6632:
6633: if g_debug_flag = 'Y' then
6634: FII_UTIL.put_line('Updated '|| SQL%ROWCOUNT ||' Release records in the FII_AP_HOLD_HIST_B');
6635: FII_UTIL.stop_timer;
6636: FII_UTIL.print_timer('Duration');
6637: FII_UTIL.put_line('');
6638: end if;

Line 6635: FII_UTIL.stop_timer;

6631:
6632:
6633: if g_debug_flag = 'Y' then
6634: FII_UTIL.put_line('Updated '|| SQL%ROWCOUNT ||' Release records in the FII_AP_HOLD_HIST_B');
6635: FII_UTIL.stop_timer;
6636: FII_UTIL.print_timer('Duration');
6637: FII_UTIL.put_line('');
6638: end if;
6639:

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

6632:
6633: if g_debug_flag = 'Y' then
6634: FII_UTIL.put_line('Updated '|| SQL%ROWCOUNT ||' Release records in the FII_AP_HOLD_HIST_B');
6635: FII_UTIL.stop_timer;
6636: FII_UTIL.print_timer('Duration');
6637: FII_UTIL.put_line('');
6638: end if;
6639:
6640: /* We currently do not use hold_count in any mv or detail report,

Line 6637: FII_UTIL.put_line('');

6633: if g_debug_flag = 'Y' then
6634: FII_UTIL.put_line('Updated '|| SQL%ROWCOUNT ||' Release records in the FII_AP_HOLD_HIST_B');
6635: FII_UTIL.stop_timer;
6636: FII_UTIL.print_timer('Duration');
6637: FII_UTIL.put_line('');
6638: end if;
6639:
6640: /* We currently do not use hold_count in any mv or detail report,
6641: so it is safe to remove this update.

Line 6645: FII_UTIL.put_line(g_state);

6641: so it is safe to remove this update.
6642:
6643: g_state := 'Updating the Hold Count on the Hold and Release records';
6644: if g_debug_flag = 'Y' then
6645: FII_UTIL.put_line(g_state);
6646: FII_UTIL.start_timer;
6647: FII_UTIL.put_line('');
6648: end if;
6649:

Line 6646: FII_UTIL.start_timer;

6642:
6643: g_state := 'Updating the Hold Count on the Hold and Release records';
6644: if g_debug_flag = 'Y' then
6645: FII_UTIL.put_line(g_state);
6646: FII_UTIL.start_timer;
6647: FII_UTIL.put_line('');
6648: end if;
6649:
6650: UPDATE FII_AP_Hold_Hist_B HH

Line 6647: FII_UTIL.put_line('');

6643: g_state := 'Updating the Hold Count on the Hold and Release records';
6644: if g_debug_flag = 'Y' then
6645: FII_UTIL.put_line(g_state);
6646: FII_UTIL.start_timer;
6647: FII_UTIL.put_line('');
6648: end if;
6649:
6650: UPDATE FII_AP_Hold_Hist_B HH
6651: SET Hold_Count = (SELECT DECODE(HH.Action,'H', COUNT(*), -1 * COUNT(*))

Line 6674: FII_UTIL.put_line('Updated '|| SQL%ROWCOUNT ||' Hold Counts in the FII_AP_HOLD_HIST_B');

6670: WHERE HH.Hold_Count IS NULL;
6671:
6672:
6673: if g_debug_flag = 'Y' then
6674: FII_UTIL.put_line('Updated '|| SQL%ROWCOUNT ||' Hold Counts in the FII_AP_HOLD_HIST_B');
6675: FII_UTIL.stop_timer;
6676: FII_UTIL.print_timer('Duration');
6677: FII_UTIL.put_line('');
6678: end if;

Line 6675: FII_UTIL.stop_timer;

6671:
6672:
6673: if g_debug_flag = 'Y' then
6674: FII_UTIL.put_line('Updated '|| SQL%ROWCOUNT ||' Hold Counts in the FII_AP_HOLD_HIST_B');
6675: FII_UTIL.stop_timer;
6676: FII_UTIL.print_timer('Duration');
6677: FII_UTIL.put_line('');
6678: end if;
6679: */

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

6672:
6673: if g_debug_flag = 'Y' then
6674: FII_UTIL.put_line('Updated '|| SQL%ROWCOUNT ||' Hold Counts in the FII_AP_HOLD_HIST_B');
6675: FII_UTIL.stop_timer;
6676: FII_UTIL.print_timer('Duration');
6677: FII_UTIL.put_line('');
6678: end if;
6679: */
6680:

Line 6677: FII_UTIL.put_line('');

6673: if g_debug_flag = 'Y' then
6674: FII_UTIL.put_line('Updated '|| SQL%ROWCOUNT ||' Hold Counts in the FII_AP_HOLD_HIST_B');
6675: FII_UTIL.stop_timer;
6676: FII_UTIL.print_timer('Duration');
6677: FII_UTIL.put_line('');
6678: end if;
6679: */
6680:
6681: EXCEPTION

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

6682: WHEN OTHERS THEN
6683: g_errbuf:=sqlerrm;
6684: g_retcode:= -1;
6685: g_exception_msg := g_retcode || ':' || g_errbuf;
6686: FII_UTIL.put_line('Error occured while ' || g_state);
6687: FII_UTIL.put_line(g_exception_msg);
6688: RAISE;
6689:
6690: END POPULATE_HOLD_HISTORY;

Line 6687: FII_UTIL.put_line(g_exception_msg);

6683: g_errbuf:=sqlerrm;
6684: g_retcode:= -1;
6685: g_exception_msg := g_retcode || ':' || g_errbuf;
6686: FII_UTIL.put_line('Error occured while ' || g_state);
6687: FII_UTIL.put_line(g_exception_msg);
6688: RAISE;
6689:
6690: END POPULATE_HOLD_HISTORY;
6691:

Line 6724: FII_UTIL.put_line(g_state);

6720:
6721: BEGIN
6722: g_state := 'Inside the procedure WORKER';
6723: if g_debug_flag = 'Y' then
6724: FII_UTIL.put_line(g_state);
6725: end if;
6726:
6727: Errbuf := NULL;
6728: Retcode:= 0;

Line 6750: FII_UTIL.put_line(' ');

6746:
6747: g_end_date := p_to_date;
6748:
6749: if g_debug_flag = 'Y' then
6750: FII_UTIL.put_line(' ');
6751: FII_UTIL.put_timestamp;
6752: FII_UTIL.put_line('Worker '||p_worker_no||' Starting');
6753: end if;
6754:

Line 6751: FII_UTIL.put_timestamp;

6747: g_end_date := p_to_date;
6748:
6749: if g_debug_flag = 'Y' then
6750: FII_UTIL.put_line(' ');
6751: FII_UTIL.put_timestamp;
6752: FII_UTIL.put_line('Worker '||p_worker_no||' Starting');
6753: end if;
6754:
6755: -- ------------------------------------------

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

6748:
6749: if g_debug_flag = 'Y' then
6750: FII_UTIL.put_line(' ');
6751: FII_UTIL.put_timestamp;
6752: FII_UTIL.put_line('Worker '||p_worker_no||' Starting');
6753: end if;
6754:
6755: -- ------------------------------------------
6756: -- Initalization

Line 6759: FII_UTIL.put_line(' ');

6755: -- ------------------------------------------
6756: -- Initalization
6757: -- ------------------------------------------
6758: if g_debug_flag = 'Y' then
6759: FII_UTIL.put_line(' ');
6760: FII_UTIL.put_line('Initialization');
6761: end if;
6762:
6763: INIT;

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

6756: -- Initalization
6757: -- ------------------------------------------
6758: if g_debug_flag = 'Y' then
6759: FII_UTIL.put_line(' ');
6760: FII_UTIL.put_line('Initialization');
6761: end if;
6762:
6763: INIT;
6764:

Line 6793: FII_UTIL.put_line('');

6789: WHERE status = 'FAILED'
6790: AND rownum = 1;
6791: IF l_failed_cnt > 0 THEN
6792: if g_debug_flag = 'Y' then
6793: FII_UTIL.put_line('');
6794: FII_UTIL.put_line('Another worker have errored out. Stop processing.');
6795: end if;
6796: EXIT;
6797: ELSIF l_unassigned_cnt = 0 THEN

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

6790: AND rownum = 1;
6791: IF l_failed_cnt > 0 THEN
6792: if g_debug_flag = 'Y' then
6793: FII_UTIL.put_line('');
6794: FII_UTIL.put_line('Another worker have errored out. Stop processing.');
6795: end if;
6796: EXIT;
6797: ELSIF l_unassigned_cnt = 0 THEN
6798: if g_debug_flag = 'Y' then

Line 6799: FII_UTIL.put_line('');

6795: end if;
6796: EXIT;
6797: ELSIF l_unassigned_cnt = 0 THEN
6798: if g_debug_flag = 'Y' then
6799: FII_UTIL.put_line('');
6800: FII_UTIL.put_line('No more jobs left. Terminating.');
6801: end if;
6802: EXIT;
6803: ELSIF l_unassigned_cnt > 0 THEN

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

6796: EXIT;
6797: ELSIF l_unassigned_cnt = 0 THEN
6798: if g_debug_flag = 'Y' then
6799: FII_UTIL.put_line('');
6800: FII_UTIL.put_line('No more jobs left. Terminating.');
6801: end if;
6802: EXIT;
6803: ELSIF l_unassigned_cnt > 0 THEN
6804: UPDATE FII_AP_PS_WORK_JOBS

Line 6834: FII_UTIL.start_timer;

6830: ---------------------------------------------------------
6831: --Do summarization using the start_range and end_range
6832: ---------------------------------------------------------
6833: if g_debug_flag = 'Y' then
6834: FII_UTIL.start_timer;
6835: end if;
6836: POPULATE_PAY_SCHED_SUM(l_start_range, l_end_range);
6837: if g_debug_flag = 'Y' then
6838: FII_UTIL.stop_timer;

Line 6838: FII_UTIL.stop_timer;

6834: FII_UTIL.start_timer;
6835: end if;
6836: POPULATE_PAY_SCHED_SUM(l_start_range, l_end_range);
6837: if g_debug_flag = 'Y' then
6838: FII_UTIL.stop_timer;
6839: FII_UTIL.print_timer('Duration');
6840: end if;
6841: UPDATE FII_AP_PS_WORK_JOBS jobs
6842: SET jobs.status = 'COMPLETED'

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

6835: end if;
6836: POPULATE_PAY_SCHED_SUM(l_start_range, l_end_range);
6837: if g_debug_flag = 'Y' then
6838: FII_UTIL.stop_timer;
6839: FII_UTIL.print_timer('Duration');
6840: end if;
6841: UPDATE FII_AP_PS_WORK_JOBS jobs
6842: SET jobs.status = 'COMPLETED'
6843: WHERE jobs.status = 'IN PROCESS'

Line 6868: FII_UTIL.put_line(Errbuf);

6864: Retcode:= -1;
6865: Errbuf := '
6866: Error in Procedure: WORKER
6867: Message: '||sqlerrm;
6868: FII_UTIL.put_line(Errbuf);
6869:
6870: -------------------------------------------
6871: -------------------------------------------
6872: -- Update the WORKER_JOBS table to indicate

Line 6914: FII_UTIL.put_line(g_state);

6910: l_period_to DATE;
6911: BEGIN
6912: g_state := 'Inside the procedure COLLECT';
6913: if g_debug_flag = 'Y' then
6914: FII_UTIL.put_line(g_state);
6915: end if;
6916:
6917: Retcode := 0;
6918:

Line 6923: l_dir:=FII_UTIL.get_utl_file_dir;

6919: ------------------------------------------------------
6920: -- Set default directory in case if the profile option
6921: -- BIS_DEBUG_LOG_DIRECTORY is not set up
6922: ------------------------------------------------------
6923: l_dir:=FII_UTIL.get_utl_file_dir;
6924: -- l_dir := '/sqlcom/log';
6925: ----------------------------------------------------------------
6926: -- FII_UTIL.initialize will get profile options FII_DEBUG_MODE
6927: -- and BIS_DEBUG_LOG_DIRECTORY and set up the directory where

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

6922: ------------------------------------------------------
6923: l_dir:=FII_UTIL.get_utl_file_dir;
6924: -- l_dir := '/sqlcom/log';
6925: ----------------------------------------------------------------
6926: -- FII_UTIL.initialize will get profile options FII_DEBUG_MODE
6927: -- and BIS_DEBUG_LOG_DIRECTORY and set up the directory where
6928: -- the log files and output files are written to
6929: ----------------------------------------------------------------
6930: FII_UTIL.initialize('FII_AP_INV_SUM_INIT.log','FII_AP_INV_SUM_INIT.out',l_dir, 'FII_AP_INV_SUM_INIT');

Line 6930: FII_UTIL.initialize('FII_AP_INV_SUM_INIT.log','FII_AP_INV_SUM_INIT.out',l_dir, 'FII_AP_INV_SUM_INIT');

6926: -- FII_UTIL.initialize will get profile options FII_DEBUG_MODE
6927: -- and BIS_DEBUG_LOG_DIRECTORY and set up the directory where
6928: -- the log files and output files are written to
6929: ----------------------------------------------------------------
6930: FII_UTIL.initialize('FII_AP_INV_SUM_INIT.log','FII_AP_INV_SUM_INIT.out',l_dir, 'FII_AP_INV_SUM_INIT');
6931:
6932: -------------------------------------------------------------
6933: -- Check if FII: DBI Payables Operations Implementation profile
6934: -- is turned on. If yes, continue, otherwise, error out. User

Line 6972: FII_UTIL.put_line('');

6968: --g_timestamp3 - last Payables Expenses load.
6969: -------------------------------------------------------------
6970: g_state := 'Defining timestamps to maintain ap_dbi_log.';
6971: IF g_debug_flag = 'Y' then
6972: FII_UTIL.put_line('');
6973: FII_UTIL.put_line(g_state);
6974: fii_util.put_line('');
6975: END IF;
6976:

Line 6973: FII_UTIL.put_line(g_state);

6969: -------------------------------------------------------------
6970: g_state := 'Defining timestamps to maintain ap_dbi_log.';
6971: IF g_debug_flag = 'Y' then
6972: FII_UTIL.put_line('');
6973: FII_UTIL.put_line(g_state);
6974: fii_util.put_line('');
6975: END IF;
6976:
6977: g_timestamp1 := BIS_COLLECTION_UTILITIES.G_Start_Date;

Line 6974: fii_util.put_line('');

6970: g_state := 'Defining timestamps to maintain ap_dbi_log.';
6971: IF g_debug_flag = 'Y' then
6972: FII_UTIL.put_line('');
6973: FII_UTIL.put_line(g_state);
6974: fii_util.put_line('');
6975: END IF;
6976:
6977: g_timestamp1 := BIS_COLLECTION_UTILITIES.G_Start_Date;
6978:

Line 7016: FII_UTIL.put_line('Current Load Timestamp is: ' || to_char(g_timestamp1, 'YYYY/MM/DD HH24:MI:SS'));

7012: EXECUTE IMMEDIATE('TRUNCATE TABLE ' || g_ap_schema || '.AP_DBI_LOG');
7013: END IF;
7014:
7015: if g_debug_flag = 'Y' then
7016: FII_UTIL.put_line('Current Load Timestamp is: ' || to_char(g_timestamp1, 'YYYY/MM/DD HH24:MI:SS'));
7017: FII_UTIL.put_line('Previous Payables Load Timestamp is: ' || to_char(g_timestamp2, 'YYYY/MM/DD HH24:MI:SS'));
7018: FII_UTIL.put_line('Previous Payables Expenses Load Timestamp is: ' || to_char(g_timestamp3, 'YYYY/MM/DD HH24:MI:SS'));
7019: end if;
7020:

Line 7017: FII_UTIL.put_line('Previous Payables Load Timestamp is: ' || to_char(g_timestamp2, 'YYYY/MM/DD HH24:MI:SS'));

7013: END IF;
7014:
7015: if g_debug_flag = 'Y' then
7016: FII_UTIL.put_line('Current Load Timestamp is: ' || to_char(g_timestamp1, 'YYYY/MM/DD HH24:MI:SS'));
7017: FII_UTIL.put_line('Previous Payables Load Timestamp is: ' || to_char(g_timestamp2, 'YYYY/MM/DD HH24:MI:SS'));
7018: FII_UTIL.put_line('Previous Payables Expenses Load Timestamp is: ' || to_char(g_timestamp3, 'YYYY/MM/DD HH24:MI:SS'));
7019: end if;
7020:
7021: if g_debug_flag = 'Y' then

Line 7018: FII_UTIL.put_line('Previous Payables Expenses Load Timestamp is: ' || to_char(g_timestamp3, 'YYYY/MM/DD HH24:MI:SS'));

7014:
7015: if g_debug_flag = 'Y' then
7016: FII_UTIL.put_line('Current Load Timestamp is: ' || to_char(g_timestamp1, 'YYYY/MM/DD HH24:MI:SS'));
7017: FII_UTIL.put_line('Previous Payables Load Timestamp is: ' || to_char(g_timestamp2, 'YYYY/MM/DD HH24:MI:SS'));
7018: FII_UTIL.put_line('Previous Payables Expenses Load Timestamp is: ' || to_char(g_timestamp3, 'YYYY/MM/DD HH24:MI:SS'));
7019: end if;
7020:
7021: if g_debug_flag = 'Y' then
7022: FII_UTIL.put_line('-------------------------------------------------');

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

7018: FII_UTIL.put_line('Previous Payables Expenses Load Timestamp is: ' || to_char(g_timestamp3, 'YYYY/MM/DD HH24:MI:SS'));
7019: end if;
7020:
7021: if g_debug_flag = 'Y' then
7022: FII_UTIL.put_line('-------------------------------------------------');
7023: FII_UTIL.put_line('Calling the Init procedure to initialize the global variables');
7024: FII_UTIL.put_line('-------------------------------------------------');
7025: end if;
7026:

Line 7023: FII_UTIL.put_line('Calling the Init procedure to initialize the global variables');

7019: end if;
7020:
7021: if g_debug_flag = 'Y' then
7022: FII_UTIL.put_line('-------------------------------------------------');
7023: FII_UTIL.put_line('Calling the Init procedure to initialize the global variables');
7024: FII_UTIL.put_line('-------------------------------------------------');
7025: end if;
7026:
7027: INIT;

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

7020:
7021: if g_debug_flag = 'Y' then
7022: FII_UTIL.put_line('-------------------------------------------------');
7023: FII_UTIL.put_line('Calling the Init procedure to initialize the global variables');
7024: FII_UTIL.put_line('-------------------------------------------------');
7025: end if;
7026:
7027: INIT;
7028:

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

7037:
7038: COMMIT;
7039:
7040: if g_debug_flag = 'Y' then
7041: FII_UTIL.put_line('-------------------------------------------------');
7042: FII_UTIL.put_line('Calling the Insert_Rates procedure to insert the missing rate info');
7043: FII_UTIL.put_line('-------------------------------------------------');
7044: end if;
7045:

Line 7042: FII_UTIL.put_line('Calling the Insert_Rates procedure to insert the missing rate info');

7038: COMMIT;
7039:
7040: if g_debug_flag = 'Y' then
7041: FII_UTIL.put_line('-------------------------------------------------');
7042: FII_UTIL.put_line('Calling the Insert_Rates procedure to insert the missing rate info');
7043: FII_UTIL.put_line('-------------------------------------------------');
7044: end if;
7045:
7046: INSERT_RATES;

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

7039:
7040: if g_debug_flag = 'Y' then
7041: FII_UTIL.put_line('-------------------------------------------------');
7042: FII_UTIL.put_line('Calling the Insert_Rates procedure to insert the missing rate info');
7043: FII_UTIL.put_line('-------------------------------------------------');
7044: end if;
7045:
7046: INSERT_RATES;
7047:

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

7045:
7046: INSERT_RATES;
7047:
7048: if g_debug_flag = 'Y' then
7049: FII_UTIL.put_line('-------------------------------------------------');
7050: FII_UTIL.put_line('Calling the Verify_Missing_Rates procedure');
7051: FII_UTIL.put_line('-------------------------------------------------');
7052: end if;
7053:

Line 7050: FII_UTIL.put_line('Calling the Verify_Missing_Rates procedure');

7046: INSERT_RATES;
7047:
7048: if g_debug_flag = 'Y' then
7049: FII_UTIL.put_line('-------------------------------------------------');
7050: FII_UTIL.put_line('Calling the Verify_Missing_Rates procedure');
7051: FII_UTIL.put_line('-------------------------------------------------');
7052: end if;
7053:
7054:

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

7047:
7048: if g_debug_flag = 'Y' then
7049: FII_UTIL.put_line('-------------------------------------------------');
7050: FII_UTIL.put_line('Calling the Verify_Missing_Rates procedure');
7051: FII_UTIL.put_line('-------------------------------------------------');
7052: end if;
7053:
7054:
7055: IF (VERIFY_MISSING_RATES = -1) THEN

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

7064: -----------------------------------------------------------------------
7065: ELSE
7066:
7067: if g_debug_flag = 'Y' then
7068: FII_UTIL.put_line('-------------------------------------------------');
7069: FII_UTIL.put_line('Calling procedure POPULATE_INV_BASE_SUM');
7070: FII_UTIL.put_line('-------------------------------------------------');
7071: end if;
7072:

Line 7069: FII_UTIL.put_line('Calling procedure POPULATE_INV_BASE_SUM');

7065: ELSE
7066:
7067: if g_debug_flag = 'Y' then
7068: FII_UTIL.put_line('-------------------------------------------------');
7069: FII_UTIL.put_line('Calling procedure POPULATE_INV_BASE_SUM');
7070: FII_UTIL.put_line('-------------------------------------------------');
7071: end if;
7072:
7073: POPULATE_INV_BASE_SUM;

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

7066:
7067: if g_debug_flag = 'Y' then
7068: FII_UTIL.put_line('-------------------------------------------------');
7069: FII_UTIL.put_line('Calling procedure POPULATE_INV_BASE_SUM');
7070: FII_UTIL.put_line('-------------------------------------------------');
7071: end if;
7072:
7073: POPULATE_INV_BASE_SUM;
7074: g_retcode := 0;

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

7073: POPULATE_INV_BASE_SUM;
7074: g_retcode := 0;
7075:
7076: if g_debug_flag = 'Y' then
7077: FII_UTIL.put_line('-------------------------------------------------');
7078: FII_UTIL.put_line('Calling procedure POPULATE_HOLDS_SUM');
7079: FII_UTIL.put_line('-------------------------------------------------');
7080: end if;
7081:

Line 7078: FII_UTIL.put_line('Calling procedure POPULATE_HOLDS_SUM');

7074: g_retcode := 0;
7075:
7076: if g_debug_flag = 'Y' then
7077: FII_UTIL.put_line('-------------------------------------------------');
7078: FII_UTIL.put_line('Calling procedure POPULATE_HOLDS_SUM');
7079: FII_UTIL.put_line('-------------------------------------------------');
7080: end if;
7081:
7082: POPULATE_HOLDS_SUM;

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

7075:
7076: if g_debug_flag = 'Y' then
7077: FII_UTIL.put_line('-------------------------------------------------');
7078: FII_UTIL.put_line('Calling procedure POPULATE_HOLDS_SUM');
7079: FII_UTIL.put_line('-------------------------------------------------');
7080: end if;
7081:
7082: POPULATE_HOLDS_SUM;
7083: g_retcode := 0;

Line 7096: FII_UTIL.put_line(' ');

7092: --------------------------------------------
7093: -- Register jobs
7094: --------------------------------------------
7095: if g_debug_flag = 'Y' then
7096: FII_UTIL.put_line(' ');
7097: FII_UTIL.put_line('Populating Jobs Table');
7098: FII_UTIL.put_timestamp;
7099: end if;
7100:

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

7093: -- Register jobs
7094: --------------------------------------------
7095: if g_debug_flag = 'Y' then
7096: FII_UTIL.put_line(' ');
7097: FII_UTIL.put_line('Populating Jobs Table');
7098: FII_UTIL.put_timestamp;
7099: end if;
7100:
7101: REGISTER_JOBS;

Line 7098: FII_UTIL.put_timestamp;

7094: --------------------------------------------
7095: if g_debug_flag = 'Y' then
7096: FII_UTIL.put_line(' ');
7097: FII_UTIL.put_line('Populating Jobs Table');
7098: FII_UTIL.put_timestamp;
7099: end if;
7100:
7101: REGISTER_JOBS;
7102: COMMIT;

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

7113: -- Launch worker
7114: --------------------------------------------------------
7115: g_state := 'Launching Workers';
7116: if g_debug_flag = 'Y' then
7117: FII_UTIL.put_line('Launching Workers');
7118: end if;
7119:
7120: /* p_no_worker is the parameter user submitted to specify how many
7121: workers they want to submit */

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

7123: FOR i IN 1..p_no_worker
7124: LOOP
7125: l_worker(i) := LAUNCH_WORKER(i);
7126: if g_debug_flag = 'Y' then
7127: FII_UTIL.put_line('Worker '||i||' request id: '||l_worker(i));
7128: end if;
7129: END LOOP;
7130:
7131: COMMIT;

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

7141:
7142: FND_PROFILE.PUT('CONC_SINGLE_THREAD','Y');
7143:
7144: if g_debug_flag = 'Y' then
7145: FII_UTIL.put_line('-------------------------------------------------');
7146: FII_UTIL.put_line('Calling procedure POPULATE_PS_BUCKET_COUNT');
7147: FII_UTIL.put_line('-------------------------------------------------');
7148: end if;
7149:

Line 7146: FII_UTIL.put_line('Calling procedure POPULATE_PS_BUCKET_COUNT');

7142: FND_PROFILE.PUT('CONC_SINGLE_THREAD','Y');
7143:
7144: if g_debug_flag = 'Y' then
7145: FII_UTIL.put_line('-------------------------------------------------');
7146: FII_UTIL.put_line('Calling procedure POPULATE_PS_BUCKET_COUNT');
7147: FII_UTIL.put_line('-------------------------------------------------');
7148: end if;
7149:
7150: POPULATE_PS_BUCKET_COUNT;

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

7143:
7144: if g_debug_flag = 'Y' then
7145: FII_UTIL.put_line('-------------------------------------------------');
7146: FII_UTIL.put_line('Calling procedure POPULATE_PS_BUCKET_COUNT');
7147: FII_UTIL.put_line('-------------------------------------------------');
7148: end if;
7149:
7150: POPULATE_PS_BUCKET_COUNT;
7151: g_retcode := 0;

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

7151: g_retcode := 0;
7152:
7153:
7154: if g_debug_flag = 'Y' then
7155: FII_UTIL.put_line('-------------------------------------------------');
7156: FII_UTIL.put_line('Calling procedure POPULATE_HOLD_HISTORY');
7157: FII_UTIL.put_line('-------------------------------------------------');
7158: end if;
7159:

Line 7156: FII_UTIL.put_line('Calling procedure POPULATE_HOLD_HISTORY');

7152:
7153:
7154: if g_debug_flag = 'Y' then
7155: FII_UTIL.put_line('-------------------------------------------------');
7156: FII_UTIL.put_line('Calling procedure POPULATE_HOLD_HISTORY');
7157: FII_UTIL.put_line('-------------------------------------------------');
7158: end if;
7159:
7160: POPULATE_HOLD_HISTORY;

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

7153:
7154: if g_debug_flag = 'Y' then
7155: FII_UTIL.put_line('-------------------------------------------------');
7156: FII_UTIL.put_line('Calling procedure POPULATE_HOLD_HISTORY');
7157: FII_UTIL.put_line('-------------------------------------------------');
7158: end if;
7159:
7160: POPULATE_HOLD_HISTORY;
7161: g_retcode := 0;

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

7213:
7214: COMMIT;
7215:
7216: if g_debug_flag = 'Y' then
7217: FII_UTIL.put_line('return code is ' || retcode);
7218: end if;
7219: Retcode := g_retcode;
7220:
7221: g_state := 'Calling BIS_COLLECTION_UTILITIES.wrapup';

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

7231: WHEN OTHERS THEN
7232: g_retcode:= -1;
7233: retcode:=g_retcode;
7234: g_exception_msg := g_retcode || ':' || g_errbuf;
7235: FII_UTIL.put_line('Error occured while ' || g_state);
7236: FII_UTIL.put_line(g_exception_msg);
7237:
7238: END;
7239:

Line 7236: FII_UTIL.put_line(g_exception_msg);

7232: g_retcode:= -1;
7233: retcode:=g_retcode;
7234: g_exception_msg := g_retcode || ':' || g_errbuf;
7235: FII_UTIL.put_line('Error occured while ' || g_state);
7236: FII_UTIL.put_line(g_exception_msg);
7237:
7238: END;
7239:
7240: END FII_AP_INV_SUM_INIT;