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_AR_TRX_DIST_F_C dependencies on EDW_LOG

Line 30: edw_log.put_line('');

26:
27: l_stmt:='drop table '|| p_table_name;
28:
29: if g_debug_flag = 'Y' then
30: edw_log.put_line('');
31: edw_log.put_line('Dropping temp table '||p_table_name);
32: edw_log.debug_line('Going to execute statement:');
33: edw_log.debug_line(l_stmt);
34: end if;

Line 31: edw_log.put_line('Dropping temp table '||p_table_name);

27: l_stmt:='drop table '|| p_table_name;
28:
29: if g_debug_flag = 'Y' then
30: edw_log.put_line('');
31: edw_log.put_line('Dropping temp table '||p_table_name);
32: edw_log.debug_line('Going to execute statement:');
33: edw_log.debug_line(l_stmt);
34: end if;
35:

Line 32: edw_log.debug_line('Going to execute statement:');

28:
29: if g_debug_flag = 'Y' then
30: edw_log.put_line('');
31: edw_log.put_line('Dropping temp table '||p_table_name);
32: edw_log.debug_line('Going to execute statement:');
33: edw_log.debug_line(l_stmt);
34: end if;
35:
36: execute immediate l_stmt;

Line 33: edw_log.debug_line(l_stmt);

29: if g_debug_flag = 'Y' then
30: edw_log.put_line('');
31: edw_log.put_line('Dropping temp table '||p_table_name);
32: edw_log.debug_line('Going to execute statement:');
33: edw_log.debug_line(l_stmt);
34: end if;
35:
36: execute immediate l_stmt;
37:

Line 45: edw_log.put_line('Error in drop_table procedure');

41: WHEN OTHERS THEN
42: g_errbuf:=sqlerrm;
43: g_retcode:=sqlcode;
44: if g_debug_flag = 'Y' then
45: edw_log.put_line('Error in drop_table procedure');
46: end if;
47: raise;
48: End;
49:

Line 85: edw_log.put_line(' ');

81: END IF;
82: -- Generates "Warning" message in the Status column of Concurrent Manager "Requests" table
83:
84: if g_debug_flag = 'Y' then
85: edw_log.put_line(' ');
86: edw_log.put_line('INSERTING ' || to_char(sql%rowcount) || ' rows into fii_ar_trx_msng_rt temp table');
87: edw_log.put_line('g_retcode is '||g_retcode);
88: edw_log.put_line('g_missing_rates is '||g_missing_rates);
89: end if;

Line 86: edw_log.put_line('INSERTING ' || to_char(sql%rowcount) || ' rows into fii_ar_trx_msng_rt temp table');

82: -- Generates "Warning" message in the Status column of Concurrent Manager "Requests" table
83:
84: if g_debug_flag = 'Y' then
85: edw_log.put_line(' ');
86: edw_log.put_line('INSERTING ' || to_char(sql%rowcount) || ' rows into fii_ar_trx_msng_rt temp table');
87: edw_log.put_line('g_retcode is '||g_retcode);
88: edw_log.put_line('g_missing_rates is '||g_missing_rates);
89: end if;
90: END;

Line 87: edw_log.put_line('g_retcode is '||g_retcode);

83:
84: if g_debug_flag = 'Y' then
85: edw_log.put_line(' ');
86: edw_log.put_line('INSERTING ' || to_char(sql%rowcount) || ' rows into fii_ar_trx_msng_rt temp table');
87: edw_log.put_line('g_retcode is '||g_retcode);
88: edw_log.put_line('g_missing_rates is '||g_missing_rates);
89: end if;
90: END;
91:

Line 88: edw_log.put_line('g_missing_rates is '||g_missing_rates);

84: if g_debug_flag = 'Y' then
85: edw_log.put_line(' ');
86: edw_log.put_line('INSERTING ' || to_char(sql%rowcount) || ' rows into fii_ar_trx_msng_rt temp table');
87: edw_log.put_line('g_retcode is '||g_retcode);
88: edw_log.put_line('g_missing_rates is '||g_missing_rates);
89: end if;
90: END;
91:
92: ---------------------------------------------------

Line 141: edw_log.put_line('');

137: 'AND iim.item_no = msi.segment1 ' ||
138: 'AND iwm.mtl_organization_id = msi.organization_id';
139:
140: if g_debug_flag = 'Y' then
141: edw_log.put_line('');
142: edw_log.put_line('Creating temp table '||table_name);
143: edw_log.debug_line('Going to execute statement:');
144: edw_log.debug_line(l_stmt);
145: end if;

Line 142: edw_log.put_line('Creating temp table '||table_name);

138: 'AND iwm.mtl_organization_id = msi.organization_id';
139:
140: if g_debug_flag = 'Y' then
141: edw_log.put_line('');
142: edw_log.put_line('Creating temp table '||table_name);
143: edw_log.debug_line('Going to execute statement:');
144: edw_log.debug_line(l_stmt);
145: end if;
146:

Line 143: edw_log.debug_line('Going to execute statement:');

139:
140: if g_debug_flag = 'Y' then
141: edw_log.put_line('');
142: edw_log.put_line('Creating temp table '||table_name);
143: edw_log.debug_line('Going to execute statement:');
144: edw_log.debug_line(l_stmt);
145: end if;
146:
147: execute immediate l_stmt;

Line 144: edw_log.debug_line(l_stmt);

140: if g_debug_flag = 'Y' then
141: edw_log.put_line('');
142: edw_log.put_line('Creating temp table '||table_name);
143: edw_log.debug_line('Going to execute statement:');
144: edw_log.debug_line(l_stmt);
145: end if;
146:
147: execute immediate l_stmt;
148: commit;

Line 155: edw_log.put_line('');

151: l_stmt:='Create index ' || table_name || '_u' || ' on ' || table_name ||
152: '(inventory_item_id)';
153:
154: if g_debug_flag = 'Y' then
155: edw_log.put_line('');
156: edw_log.put_line('Creating index ' || table_name || '_u');
157: edw_log.debug_line('Going to execute statement: ');
158: edw_log.debug_line(l_stmt);
159: end if;

Line 156: edw_log.put_line('Creating index ' || table_name || '_u');

152: '(inventory_item_id)';
153:
154: if g_debug_flag = 'Y' then
155: edw_log.put_line('');
156: edw_log.put_line('Creating index ' || table_name || '_u');
157: edw_log.debug_line('Going to execute statement: ');
158: edw_log.debug_line(l_stmt);
159: end if;
160: execute immediate l_stmt;

Line 157: edw_log.debug_line('Going to execute statement: ');

153:
154: if g_debug_flag = 'Y' then
155: edw_log.put_line('');
156: edw_log.put_line('Creating index ' || table_name || '_u');
157: edw_log.debug_line('Going to execute statement: ');
158: edw_log.debug_line(l_stmt);
159: end if;
160: execute immediate l_stmt;
161: if g_debug_flag = 'Y' then

Line 158: edw_log.debug_line(l_stmt);

154: if g_debug_flag = 'Y' then
155: edw_log.put_line('');
156: edw_log.put_line('Creating index ' || table_name || '_u');
157: edw_log.debug_line('Going to execute statement: ');
158: edw_log.debug_line(l_stmt);
159: end if;
160: execute immediate l_stmt;
161: if g_debug_flag = 'Y' then
162: edw_log.debug_line('Create index ' || table_name || '_u successfully');

Line 162: edw_log.debug_line('Create index ' || table_name || '_u successfully');

158: edw_log.debug_line(l_stmt);
159: end if;
160: execute immediate l_stmt;
161: if g_debug_flag = 'Y' then
162: edw_log.debug_line('Create index ' || table_name || '_u successfully');
163: end if;
164:
165: l_stage:='Creating index for ';
166: l_stmt:='Create index ' || table_name || '_u2' || ' on ' || table_name ||

Line 170: edw_log.put_line('');

166: l_stmt:='Create index ' || table_name || '_u2' || ' on ' || table_name ||
167: '(order_line_id)';
168:
169: if g_debug_flag = 'Y' then
170: edw_log.put_line('');
171: edw_log.put_line('Creating index ' || table_name || '_u2');
172: edw_log.debug_line('Going to execute statement: ');
173: edw_log.debug_line(l_stmt);
174: end if;

Line 171: edw_log.put_line('Creating index ' || table_name || '_u2');

167: '(order_line_id)';
168:
169: if g_debug_flag = 'Y' then
170: edw_log.put_line('');
171: edw_log.put_line('Creating index ' || table_name || '_u2');
172: edw_log.debug_line('Going to execute statement: ');
173: edw_log.debug_line(l_stmt);
174: end if;
175: execute immediate l_stmt;

Line 172: edw_log.debug_line('Going to execute statement: ');

168:
169: if g_debug_flag = 'Y' then
170: edw_log.put_line('');
171: edw_log.put_line('Creating index ' || table_name || '_u2');
172: edw_log.debug_line('Going to execute statement: ');
173: edw_log.debug_line(l_stmt);
174: end if;
175: execute immediate l_stmt;
176: if g_debug_flag = 'Y' then

Line 173: edw_log.debug_line(l_stmt);

169: if g_debug_flag = 'Y' then
170: edw_log.put_line('');
171: edw_log.put_line('Creating index ' || table_name || '_u2');
172: edw_log.debug_line('Going to execute statement: ');
173: edw_log.debug_line(l_stmt);
174: end if;
175: execute immediate l_stmt;
176: if g_debug_flag = 'Y' then
177: edw_log.debug_line('Create index ' || table_name || '_u2 successfully');

Line 177: edw_log.debug_line('Create index ' || table_name || '_u2 successfully');

173: edw_log.debug_line(l_stmt);
174: end if;
175: execute immediate l_stmt;
176: if g_debug_flag = 'Y' then
177: edw_log.debug_line('Create index ' || table_name || '_u2 successfully');
178: end if;
179:
180: commit;
181:

Line 185: edw_log.put_line('error: '|| l_stage || table_name ||' table.');

181:
182: exception
183: when others then
184: if g_debug_flag = 'Y' then
185: edw_log.put_line('error: '|| l_stage || table_name ||' table.');
186: edw_log.put_line('Dropping table ' || table_name);
187: end if;
188: drop_table(table_name);
189: commit;

Line 186: edw_log.put_line('Dropping table ' || table_name);

182: exception
183: when others then
184: if g_debug_flag = 'Y' then
185: edw_log.put_line('error: '|| l_stage || table_name ||' table.');
186: edw_log.put_line('Dropping table ' || table_name);
187: end if;
188: drop_table(table_name);
189: commit;
190: raise;

Line 204: edw_log.debug_line('Ready to Update Item FK' );

200: Begin
201:
202: create_item_org_temp(l_table_name);
203: if g_debug_flag = 'Y' then
204: edw_log.debug_line('Ready to Update Item FK' );
205: end if;
206: l_stmt:= 'UPDATE FII_AR_TRX_DIST_FSTG rev ' ||
207: 'SET (rev.uom_fk, rev.item_fk, rev.parent_item_fk) = ' ||
208: ' (SELECT DECODE(rev.interface_line_context, ''GEMMS OP'', ' ||

Line 224: edw_log.put_line('');

220: 'AND rev.item_fk NOT LIKE ''%-IORG'' ';
221:
222:
223: if g_debug_flag = 'Y' then
224: edw_log.put_line('');
225: edw_log.put_line('Updating item_fk');
226: edw_log.debug_line('Going to execute statement: ');
227: edw_log.debug_line(l_stmt);
228: end if;

Line 225: edw_log.put_line('Updating item_fk');

221:
222:
223: if g_debug_flag = 'Y' then
224: edw_log.put_line('');
225: edw_log.put_line('Updating item_fk');
226: edw_log.debug_line('Going to execute statement: ');
227: edw_log.debug_line(l_stmt);
228: end if;
229:

Line 226: edw_log.debug_line('Going to execute statement: ');

222:
223: if g_debug_flag = 'Y' then
224: edw_log.put_line('');
225: edw_log.put_line('Updating item_fk');
226: edw_log.debug_line('Going to execute statement: ');
227: edw_log.debug_line(l_stmt);
228: end if;
229:
230: execute immediate l_stmt;

Line 227: edw_log.debug_line(l_stmt);

223: if g_debug_flag = 'Y' then
224: edw_log.put_line('');
225: edw_log.put_line('Updating item_fk');
226: edw_log.debug_line('Going to execute statement: ');
227: edw_log.debug_line(l_stmt);
228: end if;
229:
230: execute immediate l_stmt;
231: l_row := SQL%ROWCOUNT;

Line 328: edw_log.put_line(' ');

324: l_stmt := 'TRUNCATE TABLE ' || l_fii_schema ||'.'||table_name;
325: EXECUTE IMMEDIATE l_stmt;
326: END IF;
327: if g_debug_flag = 'Y' then
328: edw_log.put_line(' ');
329: edw_log.put_line('Truncating '|| table_name||' table');
330: end if;
331:
332: END;

Line 329: edw_log.put_line('Truncating '|| table_name||' table');

325: EXECUTE IMMEDIATE l_stmt;
326: END IF;
327: if g_debug_flag = 'Y' then
328: edw_log.put_line(' ');
329: edw_log.put_line('Truncating '|| table_name||' table');
330: end if;
331:
332: END;
333:

Line 1275: edw_log.g_debug := TRUE;

1271: dbms_session.set_sql_trace(TRUE);
1272: END IF; */ -- Commented for bug 3304365
1273:
1274: IF (fnd_profile.value('EDW_DEBUG') = 'Y') THEN
1275: edw_log.g_debug := TRUE;
1276: ENd IF;
1277:
1278: l_dir:=fnd_profile.value('EDW_LOGFILE_DIR');
1279: if l_dir is null then

Line 1278: l_dir:=fnd_profile.value('EDW_LOGFILE_DIR');

1274: IF (fnd_profile.value('EDW_DEBUG') = 'Y') THEN
1275: edw_log.g_debug := TRUE;
1276: ENd IF;
1277:
1278: l_dir:=fnd_profile.value('EDW_LOGFILE_DIR');
1279: if l_dir is null then
1280: l_dir:='/sqlcom/log';
1281: end if;
1282: if g_debug_flag = 'Y' then

Line 1283: edw_log.put_names(p_object_name||'.log',p_object_name||'.out',l_dir);

1279: if l_dir is null then
1280: l_dir:='/sqlcom/log';
1281: end if;
1282: if g_debug_flag = 'Y' then
1283: edw_log.put_names(p_object_name||'.log',p_object_name||'.out',l_dir);
1284: end if;
1285:
1286: END;
1287:

Line 1459: edw_log.put_line( 'The collection range is from '||

1455: FII_AR_TRX_DIST_F_C.g_push_to_date := nvl(l_to_date,
1456: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
1457:
1458: if g_debug_flag = 'Y' then
1459: edw_log.put_line( 'The collection range is from '||
1460: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||
1461: to_char(g_push_to_date,'MM/DD/YYYY HH24:MI:SS'));
1462: edw_log.put_line(' ');
1463: end if;

Line 1462: edw_log.put_line(' ');

1458: if g_debug_flag = 'Y' then
1459: edw_log.put_line( 'The collection range is from '||
1460: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||
1461: to_char(g_push_to_date,'MM/DD/YYYY HH24:MI:SS'));
1462: edw_log.put_line(' ');
1463: end if;
1464:
1465: IF (NOT LOCAL_SAME_AS_REMOTE) THEN
1466: TRUNCATE_TABLE('FII_AR_TRX_DIST_FSTG');

Line 1476: edw_log.put_line(' ');

1472: -- launching parallel request to push data for AR
1473: -- -----------------------------------------------
1474:
1475: if g_debug_flag = 'Y' then
1476: edw_log.put_line(' ');
1477: end if;
1478:
1479: l_request_id8 := SUBMIT_REQUEST('AR', -1);
1480: if g_debug_flag = 'Y' then

Line 1481: edw_log.put_line('Submitted following parallel request to push '||

1477: end if;
1478:
1479: l_request_id8 := SUBMIT_REQUEST('AR', -1);
1480: if g_debug_flag = 'Y' then
1481: edw_log.put_line('Submitted following parallel request to push '||
1482: 'AR revenue transactions '||l_request_id8);
1483: end if;
1484:
1485:

Line 1497: edw_log.put_line(' ');

1493: -- launching parallel request to push data AR ADJ
1494: -- -----------------------------------------------
1495:
1496: if g_debug_flag = 'Y' then
1497: edw_log.put_line(' ');
1498: end if;
1499:
1500: l_request_id3 := SUBMIT_REQUEST('AR ADJ',l_seq_id_adjust_line);
1501: if g_debug_flag = 'Y' then

Line 1502: edw_log.put_line('Submitted following parallel request to push '||

1498: end if;
1499:
1500: l_request_id3 := SUBMIT_REQUEST('AR ADJ',l_seq_id_adjust_line);
1501: if g_debug_flag = 'Y' then
1502: edw_log.put_line('Submitted following parallel request to push '||
1503: 'AR adjustments: '||l_request_id3);
1504: end if;
1505:
1506: IF (l_request_id3 = -1) THEN

Line 1517: edw_log.put_line(' ');

1513: -- launching parallel request to detect deleted invoices
1514: -- -----------------------------------------------
1515:
1516: if g_debug_flag = 'Y' then
1517: edw_log.put_line(' ');
1518: end if;
1519:
1520: l_request_id4 := SUBMIT_REQUEST('DELET',-1);
1521: if g_debug_flag = 'Y' then

Line 1522: edw_log.put_line('Submitted following parallel request to detect '||

1518: end if;
1519:
1520: l_request_id4 := SUBMIT_REQUEST('DELET',-1);
1521: if g_debug_flag = 'Y' then
1522: edw_log.put_line('Submitted following parallel request to detect '||
1523: 'deleted invoices: '||l_request_id4);
1524: end if;
1525:
1526: IF (l_request_id4 = -1) THEN

Line 1537: edw_log.put_line(' ');

1533: -- -------------------------------
1534: -- Waiting for requests to finish
1535: -- -------------------------------
1536: if g_debug_flag = 'Y' then
1537: edw_log.put_line(' ');
1538: edw_log.put_line('Waiting for child requests to finish');
1539:
1540: fii_util.start_timer;
1541: end if;

Line 1538: edw_log.put_line('Waiting for child requests to finish');

1534: -- Waiting for requests to finish
1535: -- -------------------------------
1536: if g_debug_flag = 'Y' then
1537: edw_log.put_line(' ');
1538: edw_log.put_line('Waiting for child requests to finish');
1539:
1540: fii_util.start_timer;
1541: end if;
1542:

Line 1552: edw_log.put_line(' ');

1548: l_dev_status4);
1549:
1550:
1551: if g_debug_flag = 'Y' then
1552: edw_log.put_line(' ');
1553: edw_log.put_line('All child requests have finished');
1554: fii_util.stop_timer;
1555: fii_util.print_timer('Duration');
1556:

Line 1553: edw_log.put_line('All child requests have finished');

1549:
1550:
1551: if g_debug_flag = 'Y' then
1552: edw_log.put_line(' ');
1553: edw_log.put_line('All child requests have finished');
1554: fii_util.stop_timer;
1555: fii_util.print_timer('Duration');
1556:
1557: edw_log.put_line('Before call to truncate_table msng_rt');

Line 1557: edw_log.put_line('Before call to truncate_table msng_rt');

1553: edw_log.put_line('All child requests have finished');
1554: fii_util.stop_timer;
1555: fii_util.print_timer('Duration');
1556:
1557: edw_log.put_line('Before call to truncate_table msng_rt');
1558: end if;
1559: TRUNCATE_TABLE('fii_ar_trx_msng_rt');
1560: --select count(*)into temp from fii_ar_trx_msng_rt;
1561: --edw_log.put_line('Rows in msng rt table after truncate'|| to_char(temp));

Line 1561: --edw_log.put_line('Rows in msng rt table after truncate'|| to_char(temp));

1557: edw_log.put_line('Before call to truncate_table msng_rt');
1558: end if;
1559: TRUNCATE_TABLE('fii_ar_trx_msng_rt');
1560: --select count(*)into temp from fii_ar_trx_msng_rt;
1561: --edw_log.put_line('Rows in msng rt table after truncate'|| to_char(temp));
1562: INSERT_INTO_MISSING_RATES;
1563:
1564: ----------------------------------------------------------------------------------------------------------
1565: -- Read the warehouse currency. Added for Currency Conversion Enhancement 14-APR-03

Line 1571: --edw_log.put_line('g_missing_rates is '||g_missing_rates);

1567: select /*+ FULL(SP) CACHE(SP) */
1568: warehouse_currency_code into l_to_currency
1569: from edw_local_system_parameters SP;
1570:
1571: --edw_log.put_line('g_missing_rates is '||g_missing_rates);
1572: if (g_missing_rates >0) then Retcode:=g_retcode;
1573:
1574: --------------------------------------------------------------------
1575: -- Print Records where conversion date is in past

Line 1612: edw_log.put_line('Inside cursor for loop');

1608: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, my_payment_currency||
1609: ' '||l_to_currency||' '||my_inv_date||' '||my_collection_status);
1610:
1611: if g_debug_flag = 'Y' then
1612: edw_log.put_line('Inside cursor for loop');
1613: end if;
1614: end loop;
1615:
1616: ------------------------------------------------------------------------------

Line 1649: edw_log.put_line('Inside cursor for loop1');

1645: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, my_payment_currency||
1646: ' '||l_to_currency||' '||my_inv_date||' '||my_collection_status);
1647:
1648: if g_debug_flag = 'Y' then
1649: edw_log.put_line('Inside cursor for loop1');
1650: end if;
1651: end loop;
1652:
1653:

Line 1672: edw_log.put_line(' ');

1668: -- Note, in update_item_fk, we run ddl
1669: -- which results in a commit.
1670: -- --------------------------------
1671: if g_debug_flag = 'Y' then
1672: edw_log.put_line(' ');
1673: edw_log.put_line('Updating Item foreign key with proper values');
1674: edw_log.put_line('in the local staging table');
1675:
1676: fii_util.start_timer;

Line 1673: edw_log.put_line('Updating Item foreign key with proper values');

1669: -- which results in a commit.
1670: -- --------------------------------
1671: if g_debug_flag = 'Y' then
1672: edw_log.put_line(' ');
1673: edw_log.put_line('Updating Item foreign key with proper values');
1674: edw_log.put_line('in the local staging table');
1675:
1676: fii_util.start_timer;
1677: end if;

Line 1674: edw_log.put_line('in the local staging table');

1670: -- --------------------------------
1671: if g_debug_flag = 'Y' then
1672: edw_log.put_line(' ');
1673: edw_log.put_line('Updating Item foreign key with proper values');
1674: edw_log.put_line('in the local staging table');
1675:
1676: fii_util.start_timer;
1677: end if;
1678: g_row_count := update_item_fk;

Line 1687: edw_log.put_line('Updated '||g_row_count||' records');

1683:
1684: IF (g_row_count = -1) THEN RAISE l_item_fk_failure; END IF;
1685:
1686: if g_debug_flag = 'Y' then
1687: edw_log.put_line('Updated '||g_row_count||' records');
1688: end if;
1689:
1690:
1691:

Line 1701: edw_log.put_line(' ');

1697: -- and clean up local staging
1698: -- -----------------------------------------------
1699:
1700: if g_debug_flag = 'Y' then
1701: edw_log.put_line(' ');
1702: edw_log.put_line('Moving data from local staging table to remote staging table');
1703: fii_util.start_timer;
1704: end if;
1705: g_row_count := PUSH_REMOTE;

Line 1702: edw_log.put_line('Moving data from local staging table to remote staging table');

1698: -- -----------------------------------------------
1699:
1700: if g_debug_flag = 'Y' then
1701: edw_log.put_line(' ');
1702: edw_log.put_line('Moving data from local staging table to remote staging table');
1703: fii_util.start_timer;
1704: end if;
1705: g_row_count := PUSH_REMOTE;
1706: if g_debug_flag = 'Y' then

Line 1713: edw_log.put_line(' ');

1709: end if;
1710:
1711: IF (g_row_count = -1) THEN RAISE l_push_remote_failure; END IF;
1712: if g_debug_flag = 'Y' then
1713: edw_log.put_line(' ');
1714: edw_log.put_line('Cleaning local staging table');
1715:
1716: fii_util.start_timer;
1717: end if;

Line 1714: edw_log.put_line('Cleaning local staging table');

1710:
1711: IF (g_row_count = -1) THEN RAISE l_push_remote_failure; END IF;
1712: if g_debug_flag = 'Y' then
1713: edw_log.put_line(' ');
1714: edw_log.put_line('Cleaning local staging table');
1715:
1716: fii_util.start_timer;
1717: end if;
1718: TRUNCATE_TABLE('FII_AR_TRX_DIST_FSTG');

Line 1732: edw_log.put_line(' ');

1728: -- records status 'LOCAL READY' to 'READY'
1729: -- -----------------------------------------------
1730:
1731: if g_debug_flag = 'Y' then
1732: edw_log.put_line(' ');
1733: edw_log.put_line('Marking records in staging table with READY status');
1734: fii_util.start_timer;
1735: end if;
1736: -- Bug 4689098. Moved the call to SET_STATUS_READY out of the if statement

Line 1733: edw_log.put_line('Marking records in staging table with READY status');

1729: -- -----------------------------------------------
1730:
1731: if g_debug_flag = 'Y' then
1732: edw_log.put_line(' ');
1733: edw_log.put_line('Marking records in staging table with READY status');
1734: fii_util.start_timer;
1735: end if;
1736: -- Bug 4689098. Moved the call to SET_STATUS_READY out of the if statement
1737: -- so that it gets called even when debug mode is set to No

Line 1760: edw_log.put_line(' ');

1756: -- No exception raised so far. Successful. Call
1757: -- wrapup to commit and insert messages into logs
1758: -- -----------------------------------------------
1759: if g_debug_flag = 'Y' then
1760: edw_log.put_line(' ');
1761: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
1762: ' rows into the staging table');
1763: edw_log.put_line(' ');
1764: end if;

Line 1761: edw_log.put_line('Inserted '||nvl(g_row_count,0)||

1757: -- wrapup to commit and insert messages into logs
1758: -- -----------------------------------------------
1759: if g_debug_flag = 'Y' then
1760: edw_log.put_line(' ');
1761: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
1762: ' rows into the staging table');
1763: edw_log.put_line(' ');
1764: end if;
1765: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, l_exception_msg, g_push_from_date, g_push_to_date);

Line 1763: edw_log.put_line(' ');

1759: if g_debug_flag = 'Y' then
1760: edw_log.put_line(' ');
1761: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
1762: ' rows into the staging table');
1763: edw_log.put_line(' ');
1764: end if;
1765: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, l_exception_msg, g_push_from_date, g_push_to_date);
1766:
1767:

Line 1781: edw_log.put_line(' ');

1777: -- Identify Change for AR Invoice Lines and
1778: -- launching parallel request to push data
1779: -- --------------------------------------------
1780: if g_debug_flag = 'Y' then
1781: edw_log.put_line(' ');
1782: edw_log.put_line('Identifying changed AR invoice lines');
1783: fii_util.start_timer;
1784: end if;
1785: l_seq_id_line := IDENTIFY_CHANGE('AR INVL',l_row_count);

Line 1782: edw_log.put_line('Identifying changed AR invoice lines');

1778: -- launching parallel request to push data
1779: -- --------------------------------------------
1780: if g_debug_flag = 'Y' then
1781: edw_log.put_line(' ');
1782: edw_log.put_line('Identifying changed AR invoice lines');
1783: fii_util.start_timer;
1784: end if;
1785: l_seq_id_line := IDENTIFY_CHANGE('AR INVL',l_row_count);
1786: if g_debug_flag = 'Y' then

Line 1797: edw_log.put_line('Submitted following parallel request to push '||

1793: end if;
1794:
1795: l_request_id2 := SUBMIT_REQUEST('AR INVL',l_seq_id_line);
1796: if g_debug_flag = 'Y' then
1797: edw_log.put_line('Submitted following parallel request to push '||
1798: 'AR invoice lines: '||l_request_id2);
1799: end if;
1800:
1801: l_request_id7 := SUBMIT_REQUEST('AR OE INVL',l_seq_id_line);

Line 1803: edw_log.put_line('Submitted following parallel request to push '||

1799: end if;
1800:
1801: l_request_id7 := SUBMIT_REQUEST('AR OE INVL',l_seq_id_line);
1802: if g_debug_flag = 'Y' then
1803: edw_log.put_line('Submitted following parallel request to push '||
1804: 'AR invoice lines (OE related invoices): '||
1805: l_request_id7);
1806: end if;
1807:

Line 1817: edw_log.put_line(' ');

1813: -- Identify Change for AR Invoice Distributions
1814: -- and launching parallel request to push data
1815: -- --------------------------------------------
1816: if g_debug_flag = 'Y' then
1817: edw_log.put_line(' ');
1818: edw_log.put_line('Identifying changed AR invoice distribution');
1819: fii_util.start_timer;
1820: end if;
1821: l_seq_id_dist_line := IDENTIFY_CHANGE('AR DL', l_row_count,l_seq_id_line);

Line 1818: edw_log.put_line('Identifying changed AR invoice distribution');

1814: -- and launching parallel request to push data
1815: -- --------------------------------------------
1816: if g_debug_flag = 'Y' then
1817: edw_log.put_line(' ');
1818: edw_log.put_line('Identifying changed AR invoice distribution');
1819: fii_util.start_timer;
1820: end if;
1821: l_seq_id_dist_line := IDENTIFY_CHANGE('AR DL', l_row_count,l_seq_id_line);
1822: fii_util.stop_timer;

Line 1831: edw_log.put_line('Submitted following parallel request to push '||

1827: end if;
1828:
1829: l_request_id1 := SUBMIT_REQUEST('AR DL',l_seq_id_dist_line);
1830: if g_debug_flag = 'Y' then
1831: edw_log.put_line('Submitted following parallel request to push '||
1832: 'AR invoice details: '||l_request_id1);
1833: end if;
1834:
1835: l_request_id6 := SUBMIT_REQUEST('AR OE DL',l_seq_id_dist_line);

Line 1837: edw_log.put_line('Submitted following parallel request to push '||

1833: end if;
1834:
1835: l_request_id6 := SUBMIT_REQUEST('AR OE DL',l_seq_id_dist_line);
1836: if g_debug_flag = 'Y' then
1837: edw_log.put_line('Submitted following parallel request to push '||
1838: 'AR invoice details (OE related invoices): '||
1839: l_request_id6);
1840: end if;
1841:

Line 1852: edw_log.put_line(' ');

1848: -- -------------------------------
1849: -- Waiting for AR requests to finish
1850: -- -------------------------------
1851: if g_debug_flag = 'Y' then
1852: edw_log.put_line(' ');
1853: edw_log.put_line('Waiting for AR child requests to finish');
1854:
1855: fii_util.start_timer;
1856: end if;

Line 1853: edw_log.put_line('Waiting for AR child requests to finish');

1849: -- Waiting for AR requests to finish
1850: -- -------------------------------
1851: if g_debug_flag = 'Y' then
1852: edw_log.put_line(' ');
1853: edw_log.put_line('Waiting for AR child requests to finish');
1854:
1855: fii_util.start_timer;
1856: end if;
1857:

Line 1868: edw_log.put_line(' ');

1864: l_call_status7 := WAIT_FOR_REQUEST(l_request_id7, l_dev_phase7,
1865: l_dev_status7);
1866:
1867: if g_debug_flag = 'Y' then
1868: edw_log.put_line(' ');
1869: edw_log.put_line('All child requests have finished');
1870: fii_util.stop_timer;
1871: fii_util.print_timer('Duration');
1872: end if;

Line 1869: edw_log.put_line('All child requests have finished');

1865: l_dev_status7);
1866:
1867: if g_debug_flag = 'Y' then
1868: edw_log.put_line(' ');
1869: edw_log.put_line('All child requests have finished');
1870: fii_util.stop_timer;
1871: fii_util.print_timer('Duration');
1872: end if;
1873:

Line 1882: edw_log.put_line(' ');

1878: -- -------------------------------------------------------------
1879:
1880: if g_debug_flag = 'Y' then
1881: fii_util.start_timer;
1882: edw_log.put_line(' ');
1883: edw_log.put_line('Cleaning tmp table');
1884: end if;
1885:
1886: delete fii_tmp_pk

Line 1883: edw_log.put_line('Cleaning tmp table');

1879:
1880: if g_debug_flag = 'Y' then
1881: fii_util.start_timer;
1882: edw_log.put_line(' ');
1883: edw_log.put_line('Cleaning tmp table');
1884: end if;
1885:
1886: delete fii_tmp_pk
1887: where seq_id IN ( l_seq_id_line,

Line 1939: edw_log.put_line(' ');

1935: -- Identify Changed Records
1936: -- --------------------------------------------
1937:
1938: if g_debug_flag = 'Y' then
1939: edw_log.put_line(' ');
1940:
1941: edw_log.put_line(p_mode);
1942:
1943: edw_log.put_line( 'The collection range is from '||

Line 1941: edw_log.put_line(p_mode);

1937:
1938: if g_debug_flag = 'Y' then
1939: edw_log.put_line(' ');
1940:
1941: edw_log.put_line(p_mode);
1942:
1943: edw_log.put_line( 'The collection range is from '||
1944: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||
1945: to_char(g_push_to_date,'MM/DD/YYYY HH24:MI:SS'));

Line 1943: edw_log.put_line( 'The collection range is from '||

1939: edw_log.put_line(' ');
1940:
1941: edw_log.put_line(p_mode);
1942:
1943: edw_log.put_line( 'The collection range is from '||
1944: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||
1945: to_char(g_push_to_date,'MM/DD/YYYY HH24:MI:SS'));
1946:
1947:

Line 1948: edw_log.put_line('Identifying changed records');

1944: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||
1945: to_char(g_push_to_date,'MM/DD/YYYY HH24:MI:SS'));
1946:
1947:
1948: edw_log.put_line('Identifying changed records');
1949: fii_util.start_timer;
1950: end if;
1951: g_seq_id := IDENTIFY_CHANGE(p_mode,l_row_count);
1952: if g_debug_flag = 'Y' then

Line 1964: edw_log.put_line(' ');

1960:
1961: END IF;
1962:
1963: if g_debug_flag = 'Y' then
1964: edw_log.put_line(' ');
1965: edw_log.put_line('Pushing to local staging table');
1966: fii_util.start_timer;
1967: end if;
1968: g_row_count := PUSH_TO_LOCAL(p_mode);

Line 1965: edw_log.put_line('Pushing to local staging table');

1961: END IF;
1962:
1963: if g_debug_flag = 'Y' then
1964: edw_log.put_line(' ');
1965: edw_log.put_line('Pushing to local staging table');
1966: fii_util.start_timer;
1967: end if;
1968: g_row_count := PUSH_TO_LOCAL(p_mode);
1969: if g_debug_flag = 'Y' then

Line 1983: edw_log.put_line(' ');

1979: -- Delete all temp tables' record
1980: -- --------------------------------------------
1981: if g_debug_flag = 'Y' then
1982: fii_util.start_timer;
1983: edw_log.put_line(' ');
1984: edw_log.put_line('Cleaning tmp table');
1985: end if;
1986:
1987: delete fii_tmp_pk

Line 1984: edw_log.put_line('Cleaning tmp table');

1980: -- --------------------------------------------
1981: if g_debug_flag = 'Y' then
1982: fii_util.start_timer;
1983: edw_log.put_line(' ');
1984: edw_log.put_line('Cleaning tmp table');
1985: end if;
1986:
1987: delete fii_tmp_pk
1988: where seq_id = g_seq_id;

Line 1996: edw_log.put_line('Inserted '||nvl(g_row_count,0)||

1992: fii_util.print_timer('Duration');
1993:
1994: END IF;
1995: if g_debug_flag = 'Y' then
1996: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
1997: ' rows into the local staging table');
1998: edw_log.put_line(' ');
1999: end if;
2000:

Line 1998: edw_log.put_line(' ');

1994: END IF;
1995: if g_debug_flag = 'Y' then
1996: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
1997: ' rows into the local staging table');
1998: edw_log.put_line(' ');
1999: end if;
2000:
2001: -- ---------------------------------------------------
2002: -- Commit records into local staging table. Needed

Line 2014: edw_log.put_line(' ');

2010:
2011: IF (p_mode = 'DELET') THEN
2012:
2013: if g_debug_flag = 'Y' then
2014: edw_log.put_line(' ');
2015: edw_log.put_line(p_mode);
2016:
2017: fii_util.put_timestamp;
2018: edw_log.put_line('We are detecting invoices deleting from AR but are in warehouse');

Line 2015: edw_log.put_line(p_mode);

2011: IF (p_mode = 'DELET') THEN
2012:
2013: if g_debug_flag = 'Y' then
2014: edw_log.put_line(' ');
2015: edw_log.put_line(p_mode);
2016:
2017: fii_util.put_timestamp;
2018: edw_log.put_line('We are detecting invoices deleting from AR but are in warehouse');
2019: edw_log.put_line(' ');

Line 2018: edw_log.put_line('We are detecting invoices deleting from AR but are in warehouse');

2014: edw_log.put_line(' ');
2015: edw_log.put_line(p_mode);
2016:
2017: fii_util.put_timestamp;
2018: edw_log.put_line('We are detecting invoices deleting from AR but are in warehouse');
2019: edw_log.put_line(' ');
2020: fii_util.put_timestamp;
2021: edw_log.put_line('Clean and set up environment');
2022: end if;

Line 2019: edw_log.put_line(' ');

2015: edw_log.put_line(p_mode);
2016:
2017: fii_util.put_timestamp;
2018: edw_log.put_line('We are detecting invoices deleting from AR but are in warehouse');
2019: edw_log.put_line(' ');
2020: fii_util.put_timestamp;
2021: edw_log.put_line('Clean and set up environment');
2022: end if;
2023: l_stmt := 'Begin FII_AR_TRX_DIST_F_D.Init@EDW_APPS_TO_WH (edw_instance.get_code); End; ';

Line 2021: edw_log.put_line('Clean and set up environment');

2017: fii_util.put_timestamp;
2018: edw_log.put_line('We are detecting invoices deleting from AR but are in warehouse');
2019: edw_log.put_line(' ');
2020: fii_util.put_timestamp;
2021: edw_log.put_line('Clean and set up environment');
2022: end if;
2023: l_stmt := 'Begin FII_AR_TRX_DIST_F_D.Init@EDW_APPS_TO_WH (edw_instance.get_code); End; ';
2024: execute immediate l_stmt ;
2025: if g_debug_flag = 'Y' then

Line 2026: edw_log.put_line('Dropping OLTP temp table ');

2022: end if;
2023: l_stmt := 'Begin FII_AR_TRX_DIST_F_D.Init@EDW_APPS_TO_WH (edw_instance.get_code); End; ';
2024: execute immediate l_stmt ;
2025: if g_debug_flag = 'Y' then
2026: edw_log.put_line('Dropping OLTP temp table ');
2027: end if;
2028: l_stmt := 'Begin FII_AR_TRX_DIST_F_D.Drop_Table@EDW_APPS_TO_WH(''FII_AR_OLTP_TMP_TRX_ID''); End; ';
2029: execute immediate l_stmt;
2030: if g_debug_flag = 'Y' then

Line 2031: edw_log.put_line('Dropping EDW temp table ');

2027: end if;
2028: l_stmt := 'Begin FII_AR_TRX_DIST_F_D.Drop_Table@EDW_APPS_TO_WH(''FII_AR_OLTP_TMP_TRX_ID''); End; ';
2029: execute immediate l_stmt;
2030: if g_debug_flag = 'Y' then
2031: edw_log.put_line('Dropping EDW temp table ');
2032: end if;
2033: l_stmt := 'Begin FII_AR_TRX_DIST_F_D.Drop_Table@EDW_APPS_TO_WH(''FII_AR_EDW_TMP_TRX_ID''); End; ';
2034: execute immediate l_stmt;
2035: l_stmt := 'Begin FII_AR_TRX_DIST_F_D.Drop_Table@EDW_APPS_TO_WH(''FII_AR_EDW_EXTRA_ID''); End; ';

Line 2038: edw_log.put_line(' ');

2034: execute immediate l_stmt;
2035: l_stmt := 'Begin FII_AR_TRX_DIST_F_D.Drop_Table@EDW_APPS_TO_WH(''FII_AR_EDW_EXTRA_ID''); End; ';
2036: execute immediate l_stmt;
2037: if g_debug_flag = 'Y' then
2038: edw_log.put_line(' ');
2039: fii_util.put_timestamp;
2040: edw_log.put_line('Generate list of invoices in AR subledger');
2041: fii_util.start_timer;
2042: end if;

Line 2040: edw_log.put_line('Generate list of invoices in AR subledger');

2036: execute immediate l_stmt;
2037: if g_debug_flag = 'Y' then
2038: edw_log.put_line(' ');
2039: fii_util.put_timestamp;
2040: edw_log.put_line('Generate list of invoices in AR subledger');
2041: fii_util.start_timer;
2042: end if;
2043: l_stmt := 'Begin FII_AR_TRX_DIST_F_D.Create_OLTP_TRX_TMP_TABLE@EDW_APPS_TO_WH; End; ';
2044: execute immediate l_stmt;

Line 2053: edw_log.put_line(' ');

2049: if g_debug_flag = 'Y' then
2050: fii_util.stop_timer;
2051: fii_util.print_timer('Duration');
2052:
2053: edw_log.put_line(' ');
2054: fii_util.put_timestamp;
2055: edw_log.put_line('Generate list of invoices in EDW');
2056: fii_util.start_timer;
2057: end if;

Line 2055: edw_log.put_line('Generate list of invoices in EDW');

2051: fii_util.print_timer('Duration');
2052:
2053: edw_log.put_line(' ');
2054: fii_util.put_timestamp;
2055: edw_log.put_line('Generate list of invoices in EDW');
2056: fii_util.start_timer;
2057: end if;
2058: l_stmt := 'Begin FII_AR_TRX_DIST_F_D.Create_EDW_TRX_TMP_TABLE@EDW_APPS_TO_WH; End; ';
2059: execute immediate l_stmt;

Line 2065: edw_log.put_line(' ');

2061: if g_debug_flag = 'Y' then
2062: fii_util.stop_timer;
2063: fii_util.print_timer('Duration');
2064:
2065: edw_log.put_line(' ');
2066: fii_util.put_timestamp;
2067: edw_log.put_line('Finding extra invoices in EDW which should be deleted');
2068: fii_util.start_timer;
2069: end if;

Line 2067: edw_log.put_line('Finding extra invoices in EDW which should be deleted');

2063: fii_util.print_timer('Duration');
2064:
2065: edw_log.put_line(' ');
2066: fii_util.put_timestamp;
2067: edw_log.put_line('Finding extra invoices in EDW which should be deleted');
2068: fii_util.start_timer;
2069: end if;
2070: l_stmt := 'Begin FII_AR_TRX_DIST_F_D.Find_Extra_Trx_EDW@EDW_APPS_TO_WH; End; ';
2071: execute immediate l_stmt;

Line 2077: edw_log.put_line('EDW has '||g_row_count||' extra invoices not found in OLTP');

2073: l_stmt := 'Begin FII_AR_TRX_DIST_F_D.Count_Extra_Trx_EDW@EDW_APPS_TO_WH(:g_row_count); End; ';
2074: execute immediate l_stmt using out g_row_count;
2075: commit;
2076: if g_debug_flag = 'Y' then
2077: edw_log.put_line('EDW has '||g_row_count||' extra invoices not found in OLTP');
2078: fii_util.stop_timer;
2079: fii_util.print_timer('Duration');
2080:
2081: edw_log.put_line(' ');

Line 2081: edw_log.put_line(' ');

2077: edw_log.put_line('EDW has '||g_row_count||' extra invoices not found in OLTP');
2078: fii_util.stop_timer;
2079: fii_util.print_timer('Duration');
2080:
2081: edw_log.put_line(' ');
2082: fii_util.put_timestamp;
2083: edw_log.put_line('Inserting into staging area');
2084: fii_util.start_timer;
2085: end if;

Line 2083: edw_log.put_line('Inserting into staging area');

2079: fii_util.print_timer('Duration');
2080:
2081: edw_log.put_line(' ');
2082: fii_util.put_timestamp;
2083: edw_log.put_line('Inserting into staging area');
2084: fii_util.start_timer;
2085: end if;
2086: l_stmt := 'Begin FII_AR_TRX_DIST_F_D.Insert_Staging@EDW_APPS_TO_WH(:g_row_count); End; ';
2087: execute immediate l_stmt using out g_row_count;

Line 2090: edw_log.put_line('Inserting '||g_row_count||' records marked for deletion');

2086: l_stmt := 'Begin FII_AR_TRX_DIST_F_D.Insert_Staging@EDW_APPS_TO_WH(:g_row_count); End; ';
2087: execute immediate l_stmt using out g_row_count;
2088: commit;
2089: if g_debug_flag = 'Y' then
2090: edw_log.put_line('Inserting '||g_row_count||' records marked for deletion');
2091: fii_util.stop_timer;
2092: fii_util.print_timer('Duration');
2093: end if;
2094:

Line 2128: edw_log.put_line('Failure when launching child requests');

2124: l_seq_id_dist_line,
2125: l_seq_id_adjust_line);
2126: commit;
2127: if g_debug_flag = 'Y' then
2128: edw_log.put_line('Failure when launching child requests');
2129: end if;
2130: /* Added the if condition. Wrapup should only be called by the
2131: main process not by the child processes. Bug#3077413 */
2132: if ( p_mode='INIT' ) then

Line 2135: edw_log.put_line('Failure occurred in mode : '||p_mode);

2131: main process not by the child processes. Bug#3077413 */
2132: if ( p_mode='INIT' ) then
2133: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_from_date, g_push_to_date);
2134: else
2135: edw_log.put_line('Failure occurred in mode : '||p_mode);
2136: end if;
2137:
2138: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);
2139: -- raise; /* commented out for bug#3052562 */

Line 2147: edw_log.put_line('One of the child requests have failed');

2143: Retcode:=g_retcode;
2144: l_exception_msg := Retcode || ':' || Errbuf;
2145: DELETE_STG; -- Cleanup local staging table
2146: if g_debug_flag = 'Y' then
2147: edw_log.put_line('One of the child requests have failed');
2148: end if;
2149: /* Added the if condition. Wrapup should only be called by the
2150: main process not by the child processes. Bug#3077413 */
2151: if ( p_mode='INIT' ) then

Line 2154: edw_log.put_line('Failure occurred in mode : '||p_mode);

2150: main process not by the child processes. Bug#3077413 */
2151: if ( p_mode='INIT' ) then
2152: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_from_date, g_push_to_date);
2153: else
2154: edw_log.put_line('Failure occurred in mode : '||p_mode);
2155: end if;
2156: /* Set the completion status to error. bug#3207823 */
2157: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);
2158: -- raise; /* commented out for bug#3052562 */

Line 2169: edw_log.put_line('Inserting into local staging have failed');

2165: delete fii_tmp_pk -- clean out fii_tmp_pk table
2166: where seq_id = g_seq_id;
2167: commit;
2168: if g_debug_flag = 'Y' then
2169: edw_log.put_line('Inserting into local staging have failed');
2170: end if;
2171: /* Added the if condition. Wrapup should only be called by the
2172: main process not by the child processes. Bug#3077413 */
2173: if ( p_mode='INIT' ) then

Line 2176: edw_log.put_line('Failure occurred in mode : '||p_mode);

2172: main process not by the child processes. Bug#3077413 */
2173: if ( p_mode='INIT' ) then
2174: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_from_date, g_push_to_date);
2175: else
2176: edw_log.put_line('Failure occurred in mode : '||p_mode);
2177: end if;
2178: /* Set the completion status to error. bug#3207823 */
2179: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);
2180: -- raise; /* commented out for bug#3052562 */

Line 2189: edw_log.put_line('Data migration from local to remote staging have failed');

2185: l_exception_msg := Retcode || ':' || Errbuf;
2186: rollback; -- rollback any insert into remote site
2187: TRUNCATE_TABLE('FII_AR_TRX_DIST_FSTG'); -- Cleanup local staging table
2188: if g_debug_flag = 'Y' then
2189: edw_log.put_line('Data migration from local to remote staging have failed');
2190: end if;
2191: /* Added the if condition. Wrapup should only be called by the
2192: main process not by the child processes. Bug#3077413 */
2193: if ( p_mode='INIT' ) then

Line 2196: edw_log.put_line('Failure occurred in mode : '||p_mode);

2192: main process not by the child processes. Bug#3077413 */
2193: if ( p_mode='INIT' ) then
2194: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_from_date, g_push_to_date);
2195: else
2196: edw_log.put_line('Failure occurred in mode : '||p_mode);
2197: end if;
2198: /* Set the completion status to error. bug#3207823 */
2199: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);
2200: -- raise; /* commented out for bug#3052562 */

Line 2210: edw_log.put_line('Setting status to READY have failed');

2206: rollback; -- Rollback the status to 'LOCAL READY'
2207: DELETE_STG; -- Delete records in staging with status 'LOCAL READY'
2208: commit;
2209: if g_debug_flag = 'Y' then
2210: edw_log.put_line('Setting status to READY have failed');
2211: end if;
2212: /* Added the if condition. Wrapup should only be called by the
2213: main process not by the child processes. Bug#3077413 */
2214: if ( p_mode='INIT' ) then

Line 2217: edw_log.put_line('Failure occurred in mode : '||p_mode);

2213: main process not by the child processes. Bug#3077413 */
2214: if ( p_mode='INIT' ) then
2215: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_from_date, g_push_to_date);
2216: else
2217: edw_log.put_line('Failure occurred in mode : '||p_mode);
2218: end if;
2219: /* Set the completion status to error. bug#3207823 */
2220: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);
2221: -- raise; /* commented out for bug#3052562 */

Line 2234: edw_log.put_line('Identifying changed records have Failed');

2230: l_seq_id_adjust_line,
2231: g_seq_id);
2232: commit;
2233: if g_debug_flag = 'Y' then
2234: edw_log.put_line('Identifying changed records have Failed');
2235: end if;
2236: /* Added the if condition. Wrapup should only be called by the
2237: main process not by the child processes. Bug#3077413 */
2238: if ( p_mode='INIT' ) then

Line 2241: edw_log.put_line('Failure occurred in mode : '||p_mode);

2237: main process not by the child processes. Bug#3077413 */
2238: if ( p_mode='INIT' ) then
2239: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_from_date, g_push_to_date);
2240: else
2241: edw_log.put_line('Failure occurred in mode : '||p_mode);
2242: end if;
2243: /* Set the completion status to error. bug#3207823 */
2244: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);
2245: -- raise; /* commented out for bug#3052562 */

Line 2253: edw_log.put_line('Error updating item foreign key');

2249: Retcode:=g_retcode;
2250: l_exception_msg := Retcode || ':' || Errbuf;
2251: DELETE_STG; -- Delete records in staging with status 'LOCAL READY'
2252: if g_debug_flag = 'Y' then
2253: edw_log.put_line('Error updating item foreign key');
2254: end if;
2255: /* Added the if condition. Wrapup should only be called by the
2256: main process not by the child processes. Bug#3077413 */
2257: if ( p_mode='INIT' ) then

Line 2260: edw_log.put_line('Failure occurred in mode : '||p_mode);

2256: main process not by the child processes. Bug#3077413 */
2257: if ( p_mode='INIT' ) then
2258: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_from_date, g_push_to_date);
2259: else
2260: edw_log.put_line('Failure occurred in mode : '||p_mode);
2261: end if;
2262: /* Set the completion status to error. bug#3207823 */
2263: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);
2264: -- raise; /* commented out for bug#3052562 */

Line 2279: edw_log.put_line('Other errors');

2275: l_seq_id_adjust_line,
2276: g_seq_id);
2277: commit;
2278: if g_debug_flag = 'Y' then
2279: edw_log.put_line('Other errors');
2280: end if;
2281: /* Added the if condition. Wrapup should only be called by the
2282: main process not by the child processes. Bug#3077413 */
2283: if ( p_mode='INIT' ) then

Line 2286: edw_log.put_line('Failure occurred in mode : '||p_mode);

2282: main process not by the child processes. Bug#3077413 */
2283: if ( p_mode='INIT' ) then
2284: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_from_date, g_push_to_date);
2285: else
2286: edw_log.put_line('Failure occurred in mode : '||p_mode);
2287: end if;
2288: /* Set the completion status to error. bug#3207823 */
2289: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);
2290: -- raise; /* commented out for bug#3052562 */