DBA Data[Home] [Help]

APPS.CSI_INV_DISCREPANCY_PKG dependencies on FND_GLOBAL

Line 1052: NL VARCHAR2(1) := fnd_global.newline;

1048:
1049: l_document_type VARCHAR2(25);
1050: l_document VARCHAR2(32000) := '';
1051:
1052: NL VARCHAR2(1) := fnd_global.newline;
1053: l_header_id number;
1054: l_file varchar2(100);
1055: l_amt number;
1056: l_pos number;

Line 1292: NL VARCHAR2(1) := fnd_global.newline;

1288: l_count NUMBER;
1289: l_disc_count NUMBER;
1290: l_exists VARCHAR2(1);
1291: l_errbuf VARCHAR2(2000);
1292: NL VARCHAR2(1) := fnd_global.newline;
1293: l_request_id NUMBER;
1294:
1295: l_schema_name varchar2(30);
1296: l_object_name varchar2(80);

Line 1369: Launch_Workflow( ''|| fnd_global.local_chr(10) ||

1365: --
1366: --Launch the workflow to send a notification to the end user in case of discrepancies
1367: --between IB and INV
1368:
1369: Launch_Workflow( ''|| fnd_global.local_chr(10) ||
1370: 'Hello Install Base User, '|| fnd_global.local_chr(10)||
1371: ''||fnd_global.local_chr(10)||
1372: 'Installed Base has detected that there are some discrepancies in the data between ' || --fnd_global.local_chr(10) ||
1373: 'Installed Base and Inventory. For more information on these discrepancies please '|| --fnd_global.local_chr(10) ||

Line 1370: 'Hello Install Base User, '|| fnd_global.local_chr(10)||

1366: --Launch the workflow to send a notification to the end user in case of discrepancies
1367: --between IB and INV
1368:
1369: Launch_Workflow( ''|| fnd_global.local_chr(10) ||
1370: 'Hello Install Base User, '|| fnd_global.local_chr(10)||
1371: ''||fnd_global.local_chr(10)||
1372: 'Installed Base has detected that there are some discrepancies in the data between ' || --fnd_global.local_chr(10) ||
1373: 'Installed Base and Inventory. For more information on these discrepancies please '|| --fnd_global.local_chr(10) ||
1374: 'see the IB - INV Discrepancy Report.'||fnd_global.local_chr(10)||

Line 1371: ''||fnd_global.local_chr(10)||

1367: --between IB and INV
1368:
1369: Launch_Workflow( ''|| fnd_global.local_chr(10) ||
1370: 'Hello Install Base User, '|| fnd_global.local_chr(10)||
1371: ''||fnd_global.local_chr(10)||
1372: 'Installed Base has detected that there are some discrepancies in the data between ' || --fnd_global.local_chr(10) ||
1373: 'Installed Base and Inventory. For more information on these discrepancies please '|| --fnd_global.local_chr(10) ||
1374: 'see the IB - INV Discrepancy Report.'||fnd_global.local_chr(10)||
1375: ''||fnd_global.local_chr(10)||

Line 1372: 'Installed Base has detected that there are some discrepancies in the data between ' || --fnd_global.local_chr(10) ||

1368:
1369: Launch_Workflow( ''|| fnd_global.local_chr(10) ||
1370: 'Hello Install Base User, '|| fnd_global.local_chr(10)||
1371: ''||fnd_global.local_chr(10)||
1372: 'Installed Base has detected that there are some discrepancies in the data between ' || --fnd_global.local_chr(10) ||
1373: 'Installed Base and Inventory. For more information on these discrepancies please '|| --fnd_global.local_chr(10) ||
1374: 'see the IB - INV Discrepancy Report.'||fnd_global.local_chr(10)||
1375: ''||fnd_global.local_chr(10)||
1376: 'The details of the report output can be viewed in the concurrent request output' ||

Line 1373: 'Installed Base and Inventory. For more information on these discrepancies please '|| --fnd_global.local_chr(10) ||

1369: Launch_Workflow( ''|| fnd_global.local_chr(10) ||
1370: 'Hello Install Base User, '|| fnd_global.local_chr(10)||
1371: ''||fnd_global.local_chr(10)||
1372: 'Installed Base has detected that there are some discrepancies in the data between ' || --fnd_global.local_chr(10) ||
1373: 'Installed Base and Inventory. For more information on these discrepancies please '|| --fnd_global.local_chr(10) ||
1374: 'see the IB - INV Discrepancy Report.'||fnd_global.local_chr(10)||
1375: ''||fnd_global.local_chr(10)||
1376: 'The details of the report output can be viewed in the concurrent request output' ||
1377: 'under the Oracle Installed Base Admin responsibility. Query for the following' ||

Line 1374: 'see the IB - INV Discrepancy Report.'||fnd_global.local_chr(10)||

1370: 'Hello Install Base User, '|| fnd_global.local_chr(10)||
1371: ''||fnd_global.local_chr(10)||
1372: 'Installed Base has detected that there are some discrepancies in the data between ' || --fnd_global.local_chr(10) ||
1373: 'Installed Base and Inventory. For more information on these discrepancies please '|| --fnd_global.local_chr(10) ||
1374: 'see the IB - INV Discrepancy Report.'||fnd_global.local_chr(10)||
1375: ''||fnd_global.local_chr(10)||
1376: 'The details of the report output can be viewed in the concurrent request output' ||
1377: 'under the Oracle Installed Base Admin responsibility. Query for the following' ||
1378: 'Concurrent Request Id: '||l_request_id ||

Line 1375: ''||fnd_global.local_chr(10)||

1371: ''||fnd_global.local_chr(10)||
1372: 'Installed Base has detected that there are some discrepancies in the data between ' || --fnd_global.local_chr(10) ||
1373: 'Installed Base and Inventory. For more information on these discrepancies please '|| --fnd_global.local_chr(10) ||
1374: 'see the IB - INV Discrepancy Report.'||fnd_global.local_chr(10)||
1375: ''||fnd_global.local_chr(10)||
1376: 'The details of the report output can be viewed in the concurrent request output' ||
1377: 'under the Oracle Installed Base Admin responsibility. Query for the following' ||
1378: 'Concurrent Request Id: '||l_request_id ||
1379: ''||fnd_global.local_chr(10)||

Line 1379: ''||fnd_global.local_chr(10)||

1375: ''||fnd_global.local_chr(10)||
1376: 'The details of the report output can be viewed in the concurrent request output' ||
1377: 'under the Oracle Installed Base Admin responsibility. Query for the following' ||
1378: 'Concurrent Request Id: '||l_request_id ||
1379: ''||fnd_global.local_chr(10)||
1380: ''||fnd_global.local_chr(10)||
1381: ''||fnd_global.local_chr(10)||
1382: 'Thank You'|| fnd_global.local_chr(10) ||
1383: ''||fnd_global.local_chr(10)||

Line 1380: ''||fnd_global.local_chr(10)||

1376: 'The details of the report output can be viewed in the concurrent request output' ||
1377: 'under the Oracle Installed Base Admin responsibility. Query for the following' ||
1378: 'Concurrent Request Id: '||l_request_id ||
1379: ''||fnd_global.local_chr(10)||
1380: ''||fnd_global.local_chr(10)||
1381: ''||fnd_global.local_chr(10)||
1382: 'Thank You'|| fnd_global.local_chr(10) ||
1383: ''||fnd_global.local_chr(10)||
1384: 'Oracle Install Base', l_request_id);

Line 1381: ''||fnd_global.local_chr(10)||

1377: 'under the Oracle Installed Base Admin responsibility. Query for the following' ||
1378: 'Concurrent Request Id: '||l_request_id ||
1379: ''||fnd_global.local_chr(10)||
1380: ''||fnd_global.local_chr(10)||
1381: ''||fnd_global.local_chr(10)||
1382: 'Thank You'|| fnd_global.local_chr(10) ||
1383: ''||fnd_global.local_chr(10)||
1384: 'Oracle Install Base', l_request_id);
1385:

Line 1382: 'Thank You'|| fnd_global.local_chr(10) ||

1378: 'Concurrent Request Id: '||l_request_id ||
1379: ''||fnd_global.local_chr(10)||
1380: ''||fnd_global.local_chr(10)||
1381: ''||fnd_global.local_chr(10)||
1382: 'Thank You'|| fnd_global.local_chr(10) ||
1383: ''||fnd_global.local_chr(10)||
1384: 'Oracle Install Base', l_request_id);
1385:
1386: END IF;

Line 1383: ''||fnd_global.local_chr(10)||

1379: ''||fnd_global.local_chr(10)||
1380: ''||fnd_global.local_chr(10)||
1381: ''||fnd_global.local_chr(10)||
1382: 'Thank You'|| fnd_global.local_chr(10) ||
1383: ''||fnd_global.local_chr(10)||
1384: 'Oracle Install Base', l_request_id);
1385:
1386: END IF;
1387: