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.CSD_WIP_JOB_PVT dependencies on FND_LOG

Line 49: -- variables used for FND_LOG debug messages

45:
46: l_job_header_rec wip_job_schedule_interface%ROWTYPE;
47:
48:
49: -- variables used for FND_LOG debug messages
50:
51: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
52: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
53: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_wip_job_pvt.insert_job_header.';

Line 51: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

47:
48:
49: -- variables used for FND_LOG debug messages
50:
51: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
52: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
53: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_wip_job_pvt.insert_job_header.';
54:
55:

Line 52: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

48:
49: -- variables used for FND_LOG debug messages
50:
51: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
52: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
53: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_wip_job_pvt.insert_job_header.';
54:
55:
56: -- Constants Used for Inserting into wip_job_schedule_interface,

Line 79: FND_LOG.STRING( l_proc_level,

75: BEGIN
76:
77:
78: IF ( l_proc_level >= l_debug_level ) then
79: FND_LOG.STRING( l_proc_level,
80: l_mod_name||'begin',
81: 'Entering procedure insert_job_header' );
82: END IF;
83:

Line 242: FND_LOG.STRING( l_proc_level,

238: END;
239:
240:
241: IF ( l_proc_level >= l_debug_level ) then
242: FND_LOG.STRING( l_proc_level,
243: l_mod_name||'end',
244: 'Leaving procedure insert_job_header');
245: END IF;
246:

Line 268: -- variables used for FND_LOG debug messages

264:
265: l_job_header_rec wip_job_schedule_interface%ROWTYPE := p_job_header_rec;
266:
267:
268: -- variables used for FND_LOG debug messages
269:
270: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
271: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
272: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_wip_job_pvt.insert_job_header.';

Line 270: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

266:
267:
268: -- variables used for FND_LOG debug messages
269:
270: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
271: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
272: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_wip_job_pvt.insert_job_header.';
273:
274:

Line 271: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

267:
268: -- variables used for FND_LOG debug messages
269:
270: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
271: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
272: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_wip_job_pvt.insert_job_header.';
273:
274:
275: -- Constants Used for Inserting into wip_job_schedule_interface,

Line 297: FND_LOG.STRING( l_proc_level,

293: BEGIN
294:
295:
296: IF ( l_proc_level >= l_debug_level ) then
297: FND_LOG.STRING( l_proc_level,
298: l_mod_name||'begin',
299: 'Entering procedure insert_job_header' );
300: END IF;
301:

Line 408: FND_LOG.STRING( l_proc_level,

404: END;
405:
406:
407: IF ( l_proc_level >= l_debug_level ) then
408: FND_LOG.STRING( l_proc_level,
409: l_mod_name||'end',
410: 'Leaving procedure insert_job_header');
411: END IF;
412:

Line 869: -- variables used for FND_LOG debug messages

865: -- Bill, routing information for the Job passed to insert_job_header
866: l_job_bill_routing_rec job_bill_routing_rec_type;
867:
868:
869: -- variables used for FND_LOG debug messages
870:
871: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
872: l_stat_level NUMBER := FND_LOG.LEVEL_STATEMENT;
873: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 871: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

867:
868:
869: -- variables used for FND_LOG debug messages
870:
871: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
872: l_stat_level NUMBER := FND_LOG.LEVEL_STATEMENT;
873: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
874: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
875: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_wip_job_pvt.submit_jobs.';

Line 872: l_stat_level NUMBER := FND_LOG.LEVEL_STATEMENT;

868:
869: -- variables used for FND_LOG debug messages
870:
871: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
872: l_stat_level NUMBER := FND_LOG.LEVEL_STATEMENT;
873: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
874: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
875: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_wip_job_pvt.submit_jobs.';
876:

Line 873: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

869: -- variables used for FND_LOG debug messages
870:
871: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
872: l_stat_level NUMBER := FND_LOG.LEVEL_STATEMENT;
873: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
874: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
875: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_wip_job_pvt.submit_jobs.';
876:
877: l_default_ro_item VARCHAR2(1);

Line 874: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;

870:
871: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
872: l_stat_level NUMBER := FND_LOG.LEVEL_STATEMENT;
873: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
874: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
875: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_wip_job_pvt.submit_jobs.';
876:
877: l_default_ro_item VARCHAR2(1);
878: l_wip_entity_id NUMBER;

Line 934: FND_LOG.STRING( l_proc_level,

930:
931: BEGIN
932:
933: IF ( l_proc_level >= l_debug_level ) THEN
934: FND_LOG.STRING( l_proc_level,
935: l_mod_name||'begin',
936: 'Entering Private API submit_jobs');
937: END IF;
938:

Line 1037: FND_LOG.STRING( l_event_level,

1033:
1034: p_x_job_bill_routing_tbl(0).job_name := l_job_bill_routing_rec.job_name;
1035:
1036: IF ( l_event_level >= l_debug_level ) then
1037: FND_LOG.STRING( l_event_level,
1038: l_mod_name||'beforecallinsert',
1039: 'Just before calling insert_job_header');
1040: END IF;
1041:

Line 1225: FND_LOG.STRING( l_event_level,

1221: END IF;
1222:
1223:
1224: IF ( l_event_level >= l_debug_level ) then
1225: FND_LOG.STRING( l_event_level,
1226: l_mod_name||'beforecallinsert',
1227: 'Just before calling insert_job_header');
1228: END IF;
1229:

Line 1385: FND_LOG.STRING( l_stat_level,

1381: argument1 => TO_CHAR(l_group_id),
1382: argument2 => p_repair_line_id ) ;
1383:
1384: IF ( l_stat_level >= l_debug_level ) then
1385: FND_LOG.STRING( l_stat_level,
1386: l_mod_name||'submitdata',
1387: 'When calling submit_request, the group_id is '||to_char(l_group_id));
1388: END IF;
1389:

Line 1402: FND_LOG.STRING( l_stat_level,

1398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1399:
1400:
1401: IF ( l_stat_level >= l_debug_level ) then
1402: FND_LOG.STRING( l_stat_level,
1403: l_mod_name||'requestfail',
1404: 'Submit request failed');
1405: END IF;
1406:

Line 1421: FND_LOG.STRING( l_proc_level,

1417: */
1418: COMMIT;
1419:
1420: IF ( l_proc_level >= l_debug_level ) then
1421: FND_LOG.STRING( l_proc_level,
1422: l_mod_name||'end',
1423: 'Leaving Private API submit_jobs');
1424: END IF;
1425:

Line 1434: IF ( FND_LOG.LEVEL_EXCEPTION >= l_debug_level ) then

1430: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1431: p_count => x_msg_count,
1432: p_data => x_msg_data);
1433:
1434: IF ( FND_LOG.LEVEL_EXCEPTION >= l_debug_level ) then
1435: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION,
1436: l_mod_name||'unx_exception',
1437: 'G_EXC_UNEXPECTED_ERROR Exception');
1438: END IF;

Line 1435: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION,

1431: p_count => x_msg_count,
1432: p_data => x_msg_data);
1433:
1434: IF ( FND_LOG.LEVEL_EXCEPTION >= l_debug_level ) then
1435: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION,
1436: l_mod_name||'unx_exception',
1437: 'G_EXC_UNEXPECTED_ERROR Exception');
1438: END IF;
1439:

Line 1448: IF ( FND_LOG.LEVEL_ERROR >= l_debug_level ) then

1444: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1445: p_count => x_msg_count,
1446: p_data => x_msg_data);
1447:
1448: IF ( FND_LOG.LEVEL_ERROR >= l_debug_level ) then
1449: FND_LOG.STRING( FND_LOG.LEVEL_ERROR,
1450: l_mod_name||'exc_exception',
1451: 'G_EXC_ERROR Exception');
1452: END IF;

Line 1449: FND_LOG.STRING( FND_LOG.LEVEL_ERROR,

1445: p_count => x_msg_count,
1446: p_data => x_msg_data);
1447:
1448: IF ( FND_LOG.LEVEL_ERROR >= l_debug_level ) then
1449: FND_LOG.STRING( FND_LOG.LEVEL_ERROR,
1450: l_mod_name||'exc_exception',
1451: 'G_EXC_ERROR Exception');
1452: END IF;
1453:

Line 1471: IF ( FND_LOG.LEVEL_EXCEPTION >= l_debug_level ) then

1467: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1468: p_count => x_msg_count,
1469: p_data => x_msg_data);
1470:
1471: IF ( FND_LOG.LEVEL_EXCEPTION >= l_debug_level ) then
1472: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION,
1473: l_mod_name||'others_exception',
1474: 'OTHERS Exception');
1475: END IF;

Line 1472: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION,

1468: p_count => x_msg_count,
1469: p_data => x_msg_data);
1470:
1471: IF ( FND_LOG.LEVEL_EXCEPTION >= l_debug_level ) then
1472: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION,
1473: l_mod_name||'others_exception',
1474: 'OTHERS Exception');
1475: END IF;
1476:

Line 1534: -- variables used for FND_LOG debug messages

1530: l_msg_count NUMBER;
1531: l_msg_data VARCHAR2(2000);
1532: l_return_status VARCHAR2(1);
1533:
1534: -- variables used for FND_LOG debug messages
1535:
1536: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1537: l_stat_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1538: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 1536: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1532: l_return_status VARCHAR2(1);
1533:
1534: -- variables used for FND_LOG debug messages
1535:
1536: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1537: l_stat_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1538: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1539: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
1540: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_wip_job_pvt.submit_wip_mass_load_conc.';

Line 1537: l_stat_level NUMBER := FND_LOG.LEVEL_STATEMENT;

1533:
1534: -- variables used for FND_LOG debug messages
1535:
1536: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1537: l_stat_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1538: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1539: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
1540: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_wip_job_pvt.submit_wip_mass_load_conc.';
1541: -- subhat, bug#13586864 changes.

Line 1538: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

1534: -- variables used for FND_LOG debug messages
1535:
1536: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1537: l_stat_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1538: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1539: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
1540: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_wip_job_pvt.submit_wip_mass_load_conc.';
1541: -- subhat, bug#13586864 changes.
1542: l_repair_line_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 1539: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;

1535:
1536: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1537: l_stat_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1538: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1539: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
1540: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_wip_job_pvt.submit_wip_mass_load_conc.';
1541: -- subhat, bug#13586864 changes.
1542: l_repair_line_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1543: l_operation_seq_num NUMBER := 0;

Line 1580: FND_LOG.STRING( l_proc_level,

1576: -- end changes bug#13586864
1577: BEGIN
1578:
1579: IF ( l_proc_level >= l_debug_level ) then
1580: FND_LOG.STRING( l_proc_level,
1581: l_mod_name||'begin',
1582: 'Entering procedure submit_wip_mass_load_conc' );
1583: END IF;
1584:

Line 1620: FND_LOG.STRING( l_stat_level,

1616: l_msg_data := FND_MESSAGE.GET_STRING('CSD','CSD_WICMLP_SUBMIT_FAILURE');
1617: fnd_file.put_line(fnd_file.log, l_msg_data );
1618:
1619: IF ( l_stat_level >= l_debug_level ) then
1620: FND_LOG.STRING( l_stat_level,
1621: l_mod_name||'requestfailure',
1622: 'WIP Mass Load Submit request failed' );
1623: END IF;
1624:

Line 1632: FND_LOG.STRING( l_stat_level,

1628:
1629: COMMIT; --This commit is a must for the completion of the concurrent request submission
1630:
1631: IF ( l_stat_level >= l_debug_level ) then
1632: FND_LOG.STRING( l_stat_level,
1633: l_mod_name||'beforewait',
1634: 'After commit and before wait for request' );
1635: END IF;
1636:

Line 1664: FND_LOG.STRING( l_stat_level,

1660: fnd_file.put_line(fnd_file.log, l_msg_data );
1661:
1662:
1663: IF ( l_stat_level >= l_debug_level ) then
1664: FND_LOG.STRING( l_stat_level,
1665: l_mod_name||'waitfailure',
1666: 'Wait for request failed');
1667: END IF;
1668:

Line 1677: FND_LOG.STRING( l_event_level,

1673:
1674: -- WIP Mass Load completed successfully
1675:
1676: IF ( l_event_level >= l_debug_level ) then
1677: FND_LOG.STRING( l_event_level,
1678: l_mod_name||'beforeupdatecall',
1679: 'Before Call to depot_wip_update');
1680: END IF;
1681:

Line 1733: FND_LOG.STRING( l_stat_level,

1729:
1730: END IF;
1731:
1732: IF ( l_stat_level >= l_debug_level ) then
1733: FND_LOG.STRING( l_stat_level,
1734: l_mod_name||'updatecallerror',
1735: 'CSD_UPDATE_PROGRAMS_PVT.WIP_UPDATE call returned error');
1736: END IF;
1737:

Line 1752: FND_LOG.STRING(l_stat_level,l_mod_name,

1748: -- after the mass load completion, we need to create repair item as default
1749: -- material on the job.
1750:
1751: IF ( l_stat_level >= l_debug_level ) then
1752: FND_LOG.STRING(l_stat_level,l_mod_name,
1753: 'Checking the profile to default repair item on the job. Profile value is :'||l_def_ro_item);
1754: END IF;
1755:
1756: IF l_def_ro_item = 'Y'

Line 1761: FND_LOG.STRING(l_stat_level,l_mod_name,

1757: THEN
1758: FOR i IN job_details
1759: LOOP
1760: IF ( l_stat_level >= l_debug_level ) then
1761: FND_LOG.STRING(l_stat_level,l_mod_name,
1762: 'Inside the cursor for loop');
1763: END IF;
1764: l_index := l_index + 1;
1765:

Line 1794: FND_LOG.STRING(l_stat_level,l_mod_name,

1790: END LOOP;
1791:
1792: -- call the API to save the mtl details.
1793: IF ( l_stat_level >= l_debug_level ) then
1794: FND_LOG.STRING(l_stat_level,l_mod_name,
1795: 'calling CSD_HV_WIP_JOB_PVT.process_save_mtl_txn_dtls to create the material requirements.');
1796: FND_LOG.STRING(l_stat_level,l_mod_name,
1797: 'The number of records to be processed is :'||l_mtl_details_tbl.COUNT);
1798: END IF;

Line 1796: FND_LOG.STRING(l_stat_level,l_mod_name,

1792: -- call the API to save the mtl details.
1793: IF ( l_stat_level >= l_debug_level ) then
1794: FND_LOG.STRING(l_stat_level,l_mod_name,
1795: 'calling CSD_HV_WIP_JOB_PVT.process_save_mtl_txn_dtls to create the material requirements.');
1796: FND_LOG.STRING(l_stat_level,l_mod_name,
1797: 'The number of records to be processed is :'||l_mtl_details_tbl.COUNT);
1798: END IF;
1799: IF l_mtl_details_tbl.COUNT > 0
1800: THEN

Line 1815: FND_LOG.STRING(l_stat_level,l_mod_name,

1811:
1812: -- we do not want to raise the error message, thus erroring out the CP.
1813: -- rather we should be possibly writing the errored records into the CP log.
1814: IF ( l_stat_level >= l_debug_level ) then
1815: FND_LOG.STRING(l_stat_level,l_mod_name,
1816: 'Return from CSD_HV_WIP_JOB_PVT.process_save_mtl_txn_dtls. Return status '||l_return_status);
1817: FND_LOG.STRING(l_stat_level,l_mod_name,
1818: 'Return message: '||l_msg_data);
1819: END IF;

Line 1817: FND_LOG.STRING(l_stat_level,l_mod_name,

1813: -- rather we should be possibly writing the errored records into the CP log.
1814: IF ( l_stat_level >= l_debug_level ) then
1815: FND_LOG.STRING(l_stat_level,l_mod_name,
1816: 'Return from CSD_HV_WIP_JOB_PVT.process_save_mtl_txn_dtls. Return status '||l_return_status);
1817: FND_LOG.STRING(l_stat_level,l_mod_name,
1818: 'Return message: '||l_msg_data);
1819: END IF;
1820: END IF;
1821: END IF;

Line 1834: FND_LOG.STRING( l_stat_level,

1830: l_msg_data := FND_MESSAGE.GET_STRING('CSD','CSD_WICMLP_COMPLETION_FAILURE');
1831: fnd_file.put_line(fnd_file.log,l_msg_data );
1832:
1833: IF ( l_stat_level >= l_debug_level ) then
1834: FND_LOG.STRING( l_stat_level,
1835: l_mod_name||'completionfailure',
1836: 'WIP Mass Load did not Complete Successfully');
1837: END IF;
1838:

Line 1845: FND_LOG.STRING( l_proc_level,

1841: END IF;
1842: END IF;
1843:
1844: IF ( l_proc_level >= l_debug_level ) then
1845: FND_LOG.STRING( l_proc_level,
1846: l_mod_name||'end',
1847: 'Leaving procedure submit_wip_mass_load_conc');
1848: END IF;
1849:

Line 1908: IF ( FND_LOG.LEVEL_EXCEPTION >= l_debug_level ) then

1904:
1905: errbuf := FND_MESSAGE.GET_STRING('CSD','CSD_CSDJSWIP_FAILURE');
1906: retcode := l_error ;
1907:
1908: IF ( FND_LOG.LEVEL_EXCEPTION >= l_debug_level ) then
1909: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION,
1910: l_mod_name||'others_exception',
1911: 'OTHERS Exception');
1912: END IF;

Line 1909: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION,

1905: errbuf := FND_MESSAGE.GET_STRING('CSD','CSD_CSDJSWIP_FAILURE');
1906: retcode := l_error ;
1907:
1908: IF ( FND_LOG.LEVEL_EXCEPTION >= l_debug_level ) then
1909: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION,
1910: l_mod_name||'others_exception',
1911: 'OTHERS Exception');
1912: END IF;
1913:

Line 1977: -- Constants used for FND_LOG debug messages

1973: -- Non Standard Discrete Job Load Type
1974: lc_non_standard_load_type CONSTANT NUMBER := 4;
1975:
1976:
1977: -- Constants used for FND_LOG debug messages
1978:
1979: lc_mod_name CONSTANT VARCHAR2(2000) := 'csd.plsql.csd_wip_job_pvt.create_job_from_estimate';
1980:
1981:

Line 1994: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1990:
1991:
1992: BEGIN
1993:
1994: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1995: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE,
1996: lc_mod_name||'begin',
1997: 'Entering Private API create_job_from_estimate');
1998: END IF;

Line 1995: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE,

1991:
1992: BEGIN
1993:
1994: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1995: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE,
1996: lc_mod_name||'begin',
1997: 'Entering Private API create_job_from_estimate');
1998: END IF;
1999:

Line 2142: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2138: NULL;
2139: END;
2140: END IF;
2141:
2142: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2143: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
2144: lc_mod_name||'beforecallinsert',
2145: 'Just before calling insert_job_header');
2146: END IF;

Line 2143: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,

2139: END;
2140: END IF;
2141:
2142: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2143: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
2144: lc_mod_name||'beforecallinsert',
2145: 'Just before calling insert_job_header');
2146: END IF;
2147:

Line 2169: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2165: --If API fails, Raise error, rollback and return
2166:
2167: -- Call WIP Mass Load API
2168:
2169: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2170: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
2171: lc_mod_name||'beforecallcreateonejob',
2172: 'Just before calling WIP_MASSLOAD_PUB.createOneJob');
2173: END IF;

Line 2170: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,

2166:
2167: -- Call WIP Mass Load API
2168:
2169: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2170: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
2171: lc_mod_name||'beforecallcreateonejob',
2172: 'Just before calling WIP_MASSLOAD_PUB.createOneJob');
2173: END IF;
2174:

Line 2218: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2214: -- and csd_repair_history tables for the job created.
2215:
2216: L_user_id := fnd_global.user_id;
2217:
2218: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2219: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
2220: lc_mod_name||'beforecallxrefwrite',
2221: 'Just before calling csd_to_form_repair_job_xref.validate_and_write');
2222: END IF;

Line 2219: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,

2215:
2216: L_user_id := fnd_global.user_id;
2217:
2218: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2219: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
2220: lc_mod_name||'beforecallxrefwrite',
2221: 'Just before calling csd_to_form_repair_job_xref.validate_and_write');
2222: END IF;
2223:

Line 2275: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2271:
2272: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2273: ROLLBACK to CREATE_WIP_JOB_PVT ;
2274:
2275: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2276: FND_LOG.STRING( FND_LOG.LEVEL_ERROR,
2277: lc_mod_name||'exc_exception',
2278: 'G_EXC_ERROR Exception');
2279: END IF;

Line 2276: FND_LOG.STRING( FND_LOG.LEVEL_ERROR,

2272: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2273: ROLLBACK to CREATE_WIP_JOB_PVT ;
2274:
2275: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2276: FND_LOG.STRING( FND_LOG.LEVEL_ERROR,
2277: lc_mod_name||'exc_exception',
2278: 'G_EXC_ERROR Exception');
2279: END IF;
2280:

Line 2286: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2282:
2283: END IF;
2284:
2285:
2286: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2287: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
2288: lc_mod_name||'beforecallhistwrite',
2289: 'Just before calling csd_to_form_repair_history.validate_and_write');
2290: END IF;

Line 2287: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,

2283: END IF;
2284:
2285:
2286: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2287: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
2288: lc_mod_name||'beforecallhistwrite',
2289: 'Just before calling csd_to_form_repair_history.validate_and_write');
2290: END IF;
2291:

Line 2367: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2363:
2364: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2365: ROLLBACK to CREATE_WIP_JOB_PVT ;
2366:
2367: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2368: FND_LOG.STRING( FND_LOG.LEVEL_ERROR,
2369: lc_mod_name||'exc_exception',
2370: 'G_EXC_ERROR Exception');
2371: END IF;

Line 2368: FND_LOG.STRING( FND_LOG.LEVEL_ERROR,

2364: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2365: ROLLBACK to CREATE_WIP_JOB_PVT ;
2366:
2367: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2368: FND_LOG.STRING( FND_LOG.LEVEL_ERROR,
2369: lc_mod_name||'exc_exception',
2370: 'G_EXC_ERROR Exception');
2371: END IF;
2372:

Line 2393: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2389: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2390: p_count => x_msg_count,
2391: p_data => x_msg_data);
2392:
2393: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2394: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION,
2395: lc_mod_name||'unx_exception',
2396: 'G_EXC_UNEXPECTED_ERROR Exception');
2397: END IF;

Line 2394: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION,

2390: p_count => x_msg_count,
2391: p_data => x_msg_data);
2392:
2393: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2394: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION,
2395: lc_mod_name||'unx_exception',
2396: 'G_EXC_UNEXPECTED_ERROR Exception');
2397: END IF;
2398:

Line 2409: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2405: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2406: p_count => x_msg_count,
2407: p_data => x_msg_data);
2408:
2409: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2410: FND_LOG.STRING( FND_LOG.LEVEL_ERROR,
2411: lc_mod_name||'exc_exception',
2412: 'G_EXC_ERROR Exception');
2413: END IF;

Line 2410: FND_LOG.STRING( FND_LOG.LEVEL_ERROR,

2406: p_count => x_msg_count,
2407: p_data => x_msg_data);
2408:
2409: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2410: FND_LOG.STRING( FND_LOG.LEVEL_ERROR,
2411: lc_mod_name||'exc_exception',
2412: 'G_EXC_ERROR Exception');
2413: END IF;
2414:

Line 2432: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2428: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2429: p_count => x_msg_count,
2430: p_data => x_msg_data);
2431:
2432: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2433: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION,
2434: lc_mod_name||'others_exception',
2435: 'OTHERS Exception');
2436: END IF;

Line 2433: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION,

2429: p_count => x_msg_count,
2430: p_data => x_msg_data);
2431:
2432: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2433: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION,
2434: lc_mod_name||'others_exception',
2435: 'OTHERS Exception');
2436: END IF;
2437:

Line 2467: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2463:
2464:
2465: BEGIN
2466:
2467: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2468: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE,
2469: lc_mod_name||'begin',
2470: 'Entering Private API create_job_from_estimate');
2471: END IF;

Line 2468: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE,

2464:
2465: BEGIN
2466:
2467: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2468: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE,
2469: lc_mod_name||'begin',
2470: 'Entering Private API create_job_from_estimate');
2471: END IF;
2472:

Line 2490: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2486: -- hvr API to create the material requirements(we just create material requirements, we dont issue -- materials).
2487:
2488: IF x_mtl_txn_dtls_tab_type.COUNT >= 1 THEN
2489:
2490: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2491: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE,
2492: lc_mod_name||'begin',
2493: 'Calling HVR API to create material requirements');
2494: END IF;

Line 2491: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE,

2487:
2488: IF x_mtl_txn_dtls_tab_type.COUNT >= 1 THEN
2489:
2490: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2491: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE,
2492: lc_mod_name||'begin',
2493: 'Calling HVR API to create material requirements');
2494: END IF;
2495:

Line 2582: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2578: l_mrp_net_qty_profile VARCHAR2(1) := nvl(fnd_profile.value('CSD_WIP_MRP_NET_QTY'),'N');
2579:
2580: BEGIN
2581:
2582: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2583: fnd_log.string(fnd_log.level_statement, lc_module_name,'Begin bulk_submit_jobs API');
2584: END IF;
2585:
2586: -- standard check for API compatibility.

Line 2583: fnd_log.string(fnd_log.level_statement, lc_module_name,'Begin bulk_submit_jobs API');

2579:
2580: BEGIN
2581:
2582: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2583: fnd_log.string(fnd_log.level_statement, lc_module_name,'Begin bulk_submit_jobs API');
2584: END IF;
2585:
2586: -- standard check for API compatibility.
2587: IF NOT Fnd_Api.Compatible_API_Call

Line 2610: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2606: x_return_status := fnd_api.g_ret_sts_success;
2607:
2608: -- Validation for approval required flag will not be done here, as the java layer does it.
2609: -- anybody calling this API should take care of the same.
2610: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2611: fnd_log.string(fnd_log.level_statement, lc_module_name,'Job status passed is: '||p_job_status);
2612: END IF;
2613:
2614: IF p_job_status IS NOT NULL THEN

Line 2611: fnd_log.string(fnd_log.level_statement, lc_module_name,'Job status passed is: '||p_job_status);

2607:
2608: -- Validation for approval required flag will not be done here, as the java layer does it.
2609: -- anybody calling this API should take care of the same.
2610: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2611: fnd_log.string(fnd_log.level_statement, lc_module_name,'Job status passed is: '||p_job_status);
2612: END IF;
2613:
2614: IF p_job_status IS NOT NULL THEN
2615: l_job_status := p_job_status;

Line 2629: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2625: END IF;
2626:
2627: END IF;
2628:
2629: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2630: fnd_log.string(fnd_log.level_statement, lc_module_name,'Final job status: '||l_job_status);
2631: END IF;
2632:
2633: FOR i IN 1 ..p_repair_line_ids.COUNT

Line 2630: fnd_log.string(fnd_log.level_statement, lc_module_name,'Final job status: '||l_job_status);

2626:
2627: END IF;
2628:
2629: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2630: fnd_log.string(fnd_log.level_statement, lc_module_name,'Final job status: '||l_job_status);
2631: END IF;
2632:
2633: FOR i IN 1 ..p_repair_line_ids.COUNT
2634: LOOP

Line 2636: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2632:
2633: FOR i IN 1 ..p_repair_line_ids.COUNT
2634: LOOP
2635:
2636: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2637: fnd_log.string(fnd_log.level_statement, lc_module_name,'Starting loop to process the repair lines. Repair line id being processed is:'||p_repair_line_ids(i));
2638: END IF;
2639:
2640: IF p_service_code_id IS NOT NULL AND p_service_code_id <> fnd_api.g_miss_num

Line 2637: fnd_log.string(fnd_log.level_statement, lc_module_name,'Starting loop to process the repair lines. Repair line id being processed is:'||p_repair_line_ids(i));

2633: FOR i IN 1 ..p_repair_line_ids.COUNT
2634: LOOP
2635:
2636: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2637: fnd_log.string(fnd_log.level_statement, lc_module_name,'Starting loop to process the repair lines. Repair line id being processed is:'||p_repair_line_ids(i));
2638: END IF;
2639:
2640: IF p_service_code_id IS NOT NULL AND p_service_code_id <> fnd_api.g_miss_num
2641: THEN

Line 2643: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2639:
2640: IF p_service_code_id IS NOT NULL AND p_service_code_id <> fnd_api.g_miss_num
2641: THEN
2642:
2643: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2644: fnd_log.string(fnd_log.level_statement, lc_module_name,'Inside the service code block:');
2645: END IF;
2646:
2647: IF NOT l_sc_sql_executed

Line 2644: fnd_log.string(fnd_log.level_statement, lc_module_name,'Inside the service code block:');

2640: IF p_service_code_id IS NOT NULL AND p_service_code_id <> fnd_api.g_miss_num
2641: THEN
2642:
2643: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2644: fnd_log.string(fnd_log.level_statement, lc_module_name,'Inside the service code block:');
2645: END IF;
2646:
2647: IF NOT l_sc_sql_executed
2648: THEN

Line 2676: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2672:
2673: END IF;
2674: END IF;
2675:
2676: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2677: fnd_log.string(fnd_log.level_statement, lc_module_name,'Found '||l_bill_ref_ids.COUNT||' number of bills/routings associated with SC id:'||p_service_code_id);
2678: END IF;
2679:
2680: IF l_bill_ref_ids.COUNT > 0 OR l_route_ref_ids.COUNT > 0

Line 2677: fnd_log.string(fnd_log.level_statement, lc_module_name,'Found '||l_bill_ref_ids.COUNT||' number of bills/routings associated with SC id:'||p_service_code_id);

2673: END IF;
2674: END IF;
2675:
2676: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2677: fnd_log.string(fnd_log.level_statement, lc_module_name,'Found '||l_bill_ref_ids.COUNT||' number of bills/routings associated with SC id:'||p_service_code_id);
2678: END IF;
2679:
2680: IF l_bill_ref_ids.COUNT > 0 OR l_route_ref_ids.COUNT > 0
2681: THEN

Line 2741: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2737: END LOOP;
2738:
2739: ELSE
2740:
2741: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2742: fnd_log.string(fnd_log.level_statement, lc_module_name,'Service code is not being passed in. Populating the job header table.');
2743: END IF;
2744:
2745: l_job_header_tbl(l_job_header_index).bom_reference_id := p_bill_reference_id;

Line 2742: fnd_log.string(fnd_log.level_statement, lc_module_name,'Service code is not being passed in. Populating the job header table.');

2738:
2739: ELSE
2740:
2741: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2742: fnd_log.string(fnd_log.level_statement, lc_module_name,'Service code is not being passed in. Populating the job header table.');
2743: END IF;
2744:
2745: l_job_header_tbl(l_job_header_index).bom_reference_id := p_bill_reference_id;
2746: l_job_header_tbl(l_job_header_index).routing_reference_id := p_route_reference_id;

Line 2794: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2790: l_job_header_index := l_job_header_index + 1;
2791:
2792: END IF;
2793:
2794: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2795: fnd_log.string(fnd_log.level_statement, lc_module_name,'End of iteration. Loop index='||i||' and generated job names are '||px_job_names(i));
2796: END IF;
2797:
2798: END LOOP;

Line 2795: fnd_log.string(fnd_log.level_statement, lc_module_name,'End of iteration. Loop index='||i||' and generated job names are '||px_job_names(i));

2791:
2792: END IF;
2793:
2794: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2795: fnd_log.string(fnd_log.level_statement, lc_module_name,'End of iteration. Loop index='||i||' and generated job names are '||px_job_names(i));
2796: END IF;
2797:
2798: END LOOP;
2799:

Line 2801: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2797:
2798: END LOOP;
2799:
2800: -- insert the job header rec into wip_job_schedule_interface_table and call the CP.
2801: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2802: fnd_log.string(fnd_log.level_statement, lc_module_name,'Bulk insert into wip_job_schedule_interface. Total number of records to be inserted is '||l_job_header_tbl.COUNT);
2803: fnd_log.string(fnd_log.level_statement, lc_module_name,'The group id for the batch is = '||l_group_id);
2804: END IF;
2805:

Line 2802: fnd_log.string(fnd_log.level_statement, lc_module_name,'Bulk insert into wip_job_schedule_interface. Total number of records to be inserted is '||l_job_header_tbl.COUNT);

2798: END LOOP;
2799:
2800: -- insert the job header rec into wip_job_schedule_interface_table and call the CP.
2801: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2802: fnd_log.string(fnd_log.level_statement, lc_module_name,'Bulk insert into wip_job_schedule_interface. Total number of records to be inserted is '||l_job_header_tbl.COUNT);
2803: fnd_log.string(fnd_log.level_statement, lc_module_name,'The group id for the batch is = '||l_group_id);
2804: END IF;
2805:
2806: FORALL j IN 1 ..l_job_header_tbl.COUNT

Line 2803: fnd_log.string(fnd_log.level_statement, lc_module_name,'The group id for the batch is = '||l_group_id);

2799:
2800: -- insert the job header rec into wip_job_schedule_interface_table and call the CP.
2801: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2802: fnd_log.string(fnd_log.level_statement, lc_module_name,'Bulk insert into wip_job_schedule_interface. Total number of records to be inserted is '||l_job_header_tbl.COUNT);
2803: fnd_log.string(fnd_log.level_statement, lc_module_name,'The group id for the batch is = '||l_group_id);
2804: END IF;
2805:
2806: FORALL j IN 1 ..l_job_header_tbl.COUNT
2807: INSERT INTO wip_job_schedule_interface VALUES l_job_header_tbl(j);

Line 2813: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2809: -- insert the records inot the csd xref table.
2810: -- instead of table handler, I am doing direct table update, since the table handlers
2811: -- process one row at a time. For an online batch processing, this is not ideal.
2812:
2813: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2814: fnd_log.string(fnd_log.level_statement, lc_module_name,'Bulk insert into csd_repair_job_xref. Total number of records to be inserted is '||l_job_header_tbl.COUNT);
2815:
2816: END IF;
2817:

Line 2814: fnd_log.string(fnd_log.level_statement, lc_module_name,'Bulk insert into csd_repair_job_xref. Total number of records to be inserted is '||l_job_header_tbl.COUNT);

2810: -- instead of table handler, I am doing direct table update, since the table handlers
2811: -- process one row at a time. For an online batch processing, this is not ideal.
2812:
2813: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2814: fnd_log.string(fnd_log.level_statement, lc_module_name,'Bulk insert into csd_repair_job_xref. Total number of records to be inserted is '||l_job_header_tbl.COUNT);
2815:
2816: END IF;
2817:
2818: FORALL k IN 1 ..l_job_header_tbl.COUNT

Line 2861: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2857: 1
2858: );
2859:
2860: -- submit concurrent request to process the mass load.
2861: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2862: fnd_log.string(fnd_log.level_statement, lc_module_name,'Launching the CSDJSWIP CP.');
2863:
2864: END IF;
2865:

Line 2862: fnd_log.string(fnd_log.level_statement, lc_module_name,'Launching the CSDJSWIP CP.');

2858: );
2859:
2860: -- submit concurrent request to process the mass load.
2861: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2862: fnd_log.string(fnd_log.level_statement, lc_module_name,'Launching the CSDJSWIP CP.');
2863:
2864: END IF;
2865:
2866: x_request_id := fnd_request.submit_request (

Line 2879: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2875: -- purposfully no exception block here. Any exception encountered will and should be raised.
2876: -- most likely a bug, or indication of something went nastily wrong.
2877:
2878: -- the caller of this API should decide what to do with x_request_id = -1 or a when others exception.
2879: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2880: fnd_log.string(fnd_log.level_statement, lc_module_name,'Return from fnd_request.submit_request. The request_id = '||x_request_id);
2881:
2882: END IF;
2883:

Line 2880: fnd_log.string(fnd_log.level_statement, lc_module_name,'Return from fnd_request.submit_request. The request_id = '||x_request_id);

2876: -- most likely a bug, or indication of something went nastily wrong.
2877:
2878: -- the caller of this API should decide what to do with x_request_id = -1 or a when others exception.
2879: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2880: fnd_log.string(fnd_log.level_statement, lc_module_name,'Return from fnd_request.submit_request. The request_id = '||x_request_id);
2881:
2882: END IF;
2883:
2884: EXCEPTION