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

Line 5: G_LOG_LEVEL CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;

1: PACKAGE BODY CST_SLA_UPDATE_PKG AS
2: /* $Header: CSTPUPGB.pls 120.31.12020000.2 2012/07/11 13:13:00 vkatakam ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CST_SLA_UPDATE_PKG';
5: G_LOG_LEVEL CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
6: gUserId NUMBER := nvl(fnd_global.user_id, -888);
7: gLoginId NUMBER := nvl(fnd_global.login_id, -888);
8: gRequestId NUMBER := nvl(fnd_global.conc_request_id, -1);
9: gUpdateDate DATE := SYSDATE;

Line 17: -- Function : Function to log messages into fnd_log_messages

13:
14: ------------------------------------------------------------------------------------
15: -- API name : log_message
16: -- Type : Private
17: -- Function : Function to log messages into fnd_log_messages
18: --
19: -- Pre-reqs :
20: -- Parameters :
21: -- IN : X_fndlevel IN NUMBER

Line 39: fnd_log.string( X_fndlevel, X_module, X_message);

35: X_message IN VARCHAR2)
36: IS
37: BEGIN
38: IF X_fndlevel >= G_LOG_LEVEL AND NOT gLogError THEN
39: fnd_log.string( X_fndlevel, X_module, X_message);
40: END IF;
41: EXCEPTION
42: WHEN OTHERS THEN
43: gLogError := TRUE;

Line 45: fnd_file.put_line(fnd_file.log, 'Disabling FND Logging..');

41: EXCEPTION
42: WHEN OTHERS THEN
43: gLogError := TRUE;
44: fnd_file.put_line(fnd_file.log, 'EXCEPTION: log_message: '||SQLERRM);
45: fnd_file.put_line(fnd_file.log, 'Disabling FND Logging..');
46: END log_message;
47:
48: ------------------------------------------------------------------------------------
49: -- API name : handle_error

Line 145: l_Log CONSTANT BOOLEAN := fnd_log.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);

141: X_Application_Id in number default null)
142: IS
143:
144: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.CST_Upgrade_Wrapper';
145: l_Log CONSTANT BOOLEAN := fnd_log.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
146:
147: l_api_version NUMBER := 1.0;
148: l_init_msg_list VARCHAR2(1) := 'T';
149:

Line 167: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');

163:
164: BEGIN
165:
166: IF l_Log THEN
167: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');
168: ELSE
169: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');
170: END IF;
171:

Line 169: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');

165:
166: IF l_Log THEN
167: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');
168: ELSE
169: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');
170: END IF;
171:
172: l_stmt_num :=0;
173: IF l_Log THEN

Line 175: fnd_log.level_procedure,

171:
172: l_stmt_num :=0;
173: IF l_Log THEN
174: log_message(
175: fnd_log.level_procedure,
176: l_module||'.begin',
177: 'Entering CST_SLA_UPDATE_PKG.CST_Upgrade_Wrapper with '||
178: 'X_batch_size = '||X_batch_size||','||
179: 'X_Num_Workers = '||X_Num_Workers||','||

Line 347: fnd_log.level_procedure,

343: COMMIT;
344:
345: IF l_Log THEN
346: log_message(
347: fnd_log.level_procedure,
348: l_module||'.end',
349: 'Exiting CST_SLA_UPDATE_PKG.CST_Upgrade_Wrapper with '||
350: 'X_errbuf = '||X_errbuf||','||
351: 'X_retcode = '||X_retcode

Line 419: l_Log CONSTANT BOOLEAN := fnd_log.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);

415: X_Argument10 in varchar2 default NULL)
416: IS
417:
418: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_Proc_MGR';
419: l_Log CONSTANT BOOLEAN := fnd_log.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
420:
421: l_stmt_num number;
422: l_api_name CONSTANT VARCHAR2(30) := 'Update_Proc_MGR';
423: l_api_version CONSTANT NUMBER := 1.0;

Line 442: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');

438:
439: BEGIN
440:
441: IF l_Log THEN
442: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');
443: ELSE
444: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');
445: END IF;
446:

Line 444: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');

440:
441: IF l_Log THEN
442: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');
443: ELSE
444: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');
445: END IF;
446:
447: l_stmt_num :=0;
448: IF l_Log THEN

Line 450: fnd_log.level_procedure,

446:
447: l_stmt_num :=0;
448: IF l_Log THEN
449: log_message(
450: fnd_log.level_procedure,
451: l_module||'.begin',
452: 'Entering CST_SLA_UPDATE_PKG.Update_Proc_MGR with '||
453: 'X_batch_size = '||X_batch_size||','||
454: 'X_Num_Workers = '||X_Num_Workers||','||

Line 609: fnd_log.level_procedure,

605: <>
606:
607: IF l_Log THEN
608: log_message(
609: fnd_log.level_procedure,
610: l_module||'.end',
611: 'Exiting CST_SLA_UPDATE_PKG.Update_Proc_MGR with '||
612: 'X_errbuf = '||X_errbuf||','||
613: 'X_retcode = '||X_retcode

Line 687: l_Log CONSTANT BOOLEAN := fnd_log.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);

683: l_retstatus boolean;
684: l_table_owner varchar2(30);
685:
686: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_Proc_INV_MGR';
687: l_Log CONSTANT BOOLEAN := fnd_log.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
688:
689: l_sub_reqtab fnd_concurrent.requests_tab_type;
690: req_data varchar2(10);
691: submit_req boolean;

Line 700: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');

696:
697: BEGIN
698:
699: IF l_Log THEN
700: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');
701: ELSE
702: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');
703: END IF;
704:

Line 702: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');

698:
699: IF l_Log THEN
700: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');
701: ELSE
702: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');
703: END IF;
704:
705: l_stmt_num :=0;
706: IF l_Log THEN

Line 708: fnd_log.level_procedure,

704:
705: l_stmt_num :=0;
706: IF l_Log THEN
707: log_message(
708: fnd_log.level_procedure,
709: l_module||'.begin',
710: 'Entering CST_SLA_UPDATE_PKG.Update_Proc_INV_MGR with '||
711: 'X_batch_size = '||X_batch_size||','||
712: 'X_Num_Workers = '||X_Num_Workers||','||

Line 849: fnd_log.level_procedure,

845: <>
846:
847: IF l_Log THEN
848: log_message(
849: fnd_log.level_procedure,
850: l_module||'.end',
851: 'Exiting CST_SLA_UPDATE_PKG.Update_Proc_INV_MGR with '||
852: 'X_errbuf = '||X_errbuf||','||
853: 'X_retcode = '||X_retcode

Line 926: l_Log CONSTANT BOOLEAN := fnd_log.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);

922: l_retstatus boolean;
923: l_table_owner varchar2(30);
924:
925: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_Proc_WIP_MGR';
926: l_Log CONSTANT BOOLEAN := fnd_log.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
927:
928: l_sub_reqtab fnd_concurrent.requests_tab_type;
929: req_data varchar2(10);
930: submit_req boolean;

Line 939: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');

935:
936: BEGIN
937:
938: IF l_Log THEN
939: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');
940: ELSE
941: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');
942: END IF;
943:

Line 941: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');

937:
938: IF l_Log THEN
939: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');
940: ELSE
941: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');
942: END IF;
943:
944: l_stmt_num :=0;
945: IF l_Log THEN

Line 947: fnd_log.level_procedure,

943:
944: l_stmt_num :=0;
945: IF l_Log THEN
946: log_message(
947: fnd_log.level_procedure,
948: l_module||'.begin',
949: 'Entering CST_SLA_UPDATE_PKG.Update_Proc_WIP_MGR with '||
950: 'X_batch_size = '||X_batch_size||','||
951: 'X_Num_Workers = '||X_Num_Workers||','||

Line 1087: fnd_log.level_procedure,

1083: <>
1084:
1085: IF l_Log THEN
1086: log_message(
1087: fnd_log.level_procedure,
1088: l_module||'.end',
1089: 'Exiting CST_SLA_UPDATE_PKG.Update_Proc_WIP_MGR with '||
1090: 'X_errbuf = '||X_errbuf||','||
1091: 'X_retcode = '||X_retcode

Line 1164: l_Log CONSTANT BOOLEAN := fnd_log.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);

1160: l_retstatus boolean;
1161: l_table_owner varchar2(30);
1162:
1163: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_Proc_RCV_MGR';
1164: l_Log CONSTANT BOOLEAN := fnd_log.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1165:
1166: l_sub_reqtab fnd_concurrent.requests_tab_type;
1167: req_data varchar2(10);
1168: submit_req boolean;

Line 1177: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');

1173:
1174: BEGIN
1175:
1176: IF l_Log THEN
1177: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');
1178: ELSE
1179: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');
1180: END IF;
1181:

Line 1179: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');

1175:
1176: IF l_Log THEN
1177: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');
1178: ELSE
1179: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');
1180: END IF;
1181:
1182: l_stmt_num :=0;
1183: IF l_Log THEN

Line 1185: fnd_log.level_procedure,

1181:
1182: l_stmt_num :=0;
1183: IF l_Log THEN
1184: log_message(
1185: fnd_log.level_procedure,
1186: l_module||'.begin',
1187: 'Entering CST_SLA_UPDATE_PKG.Update_Proc_RCV_MGR with '||
1188: 'X_batch_size = '||X_batch_size||','||
1189: 'X_Num_Workers = '||X_Num_Workers||','||

Line 1325: fnd_log.level_procedure,

1321: <>
1322:
1323: IF l_Log THEN
1324: log_message(
1325: fnd_log.level_procedure,
1326: l_module||'.end',
1327: 'Exiting CST_SLA_UPDATE_PKG.Update_Proc_RCV_MGR with '||
1328: 'X_errbuf = '||X_errbuf||','||
1329: 'X_retcode = '||X_retcode

Line 1413: l_Log CONSTANT BOOLEAN := fnd_log.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND gRequestId > 0;

1409: l_end_id number;
1410: l_rows_processed number;
1411:
1412: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_Proc_INV_WKR';
1413: l_Log CONSTANT BOOLEAN := fnd_log.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND gRequestId > 0;
1414:
1415: l_stmt_num number;
1416:
1417: BEGIN

Line 1420: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');

1416:
1417: BEGIN
1418:
1419: IF l_Log THEN
1420: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');
1421: ELSE
1422: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');
1423: END IF;
1424:

Line 1422: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');

1418:
1419: IF l_Log THEN
1420: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');
1421: ELSE
1422: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');
1423: END IF;
1424:
1425: l_stmt_num :=0;
1426:

Line 1429: fnd_log.level_procedure,

1425: l_stmt_num :=0;
1426:
1427: IF l_Log THEN
1428: log_message(
1429: fnd_log.level_procedure,
1430: l_module||'.begin',
1431: 'Entering CST_SLA_UPDATE_PKG.Update_Proc_INV_WKR with '||
1432: 'X_batch_size = '||X_batch_size||','||
1433: 'X_Worker_Id = '||X_Worker_Id||','||

Line 1479: fnd_log.level_procedure,

1475: TRUE);
1476:
1477: IF NOT l_any_rows_to_process AND l_Log THEN
1478: log_message(
1479: fnd_log.level_procedure,
1480: l_module||'.'||l_stmt_num,
1481: 'No Rows to Process in INV'
1482: );
1483: END IF;

Line 1493: fnd_log.level_procedure,

1489: -- Code CST SLA update logic here
1490: --
1491: IF l_Log THEN
1492: log_message(
1493: fnd_log.level_procedure,
1494: l_module||'.'||l_stmt_num,
1495: 'Processing INV Rows From '||l_start_id||' To '||l_end_id
1496: );
1497: END IF;

Line 1548: fnd_log.level_procedure,

1544: <>
1545:
1546: IF l_Log THEN
1547: log_message(
1548: fnd_log.level_procedure,
1549: l_module||'.end',
1550: 'Exiting CST_SLA_UPDATE_PKG.Update_Proc_INV_WKR with '||
1551: 'X_errbuf = '||X_errbuf||','||
1552: 'X_retcode = '||X_retcode

Line 1640: l_Log CONSTANT BOOLEAN := fnd_log.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND gRequestId > 0;

1636: l_end_id number;
1637: l_rows_processed number;
1638:
1639: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_Proc_WIP_WKR';
1640: l_Log CONSTANT BOOLEAN := fnd_log.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND gRequestId > 0;
1641:
1642: l_stmt_num number;
1643:
1644: BEGIN

Line 1647: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');

1643:
1644: BEGIN
1645:
1646: IF l_Log THEN
1647: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');
1648: ELSE
1649: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');
1650: END IF;
1651:

Line 1649: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');

1645:
1646: IF l_Log THEN
1647: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');
1648: ELSE
1649: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');
1650: END IF;
1651:
1652: l_stmt_num :=0;
1653:

Line 1656: fnd_log.level_procedure,

1652: l_stmt_num :=0;
1653:
1654: IF l_Log THEN
1655: log_message(
1656: fnd_log.level_procedure,
1657: l_module||'.begin',
1658: 'Entering CST_SLA_UPDATE_PKG.Update_Proc_WIP_WKR with '||
1659: 'X_batch_size = '||X_batch_size||','||
1660: 'X_Worker_Id = '||X_Worker_Id||','||

Line 1707: fnd_log.level_procedure,

1703:
1704: l_stmt_num :=25;
1705: IF NOT l_any_rows_to_process AND l_Log THEN
1706: log_message(
1707: fnd_log.level_procedure,
1708: l_module||'.'||l_stmt_num,
1709: 'No Rows to Process in WIP'
1710: );
1711: END IF;

Line 1720: fnd_log.level_procedure,

1716: -- Code CST SLA update logic here
1717: --
1718: IF l_Log THEN
1719: log_message(
1720: fnd_log.level_procedure,
1721: l_module||'.'||l_stmt_num,
1722: 'Processing WIP Rows From '||l_start_id||' To '||l_end_id
1723: );
1724: END IF;

Line 1774: fnd_log.level_procedure,

1770: <>
1771:
1772: IF l_Log THEN
1773: log_message(
1774: fnd_log.level_procedure,
1775: l_module||'.end',
1776: 'Exiting CST_SLA_UPDATE_PKG.Update_Proc_WIP_WKR with '||
1777: 'X_errbuf = '||X_errbuf||','||
1778: 'X_retcode = '||X_retcode

Line 1867: l_Log CONSTANT BOOLEAN := fnd_log.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND gRequestId > 0;

1863: l_end_id number;
1864: l_rows_processed number;
1865:
1866: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_Proc_RCV_WKR';
1867: l_Log CONSTANT BOOLEAN := fnd_log.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND gRequestId > 0;
1868:
1869: l_stmt_num number;
1870: l_mrc_temp number;
1871:

Line 1875: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');

1871:
1872: BEGIN
1873:
1874: IF l_Log THEN
1875: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');
1876: ELSE
1877: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');
1878: END IF;
1879:

Line 1877: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');

1873:
1874: IF l_Log THEN
1875: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled TRUE');
1876: ELSE
1877: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'>FND Logging Enabled FALSE');
1878: END IF;
1879:
1880: l_stmt_num :=0;
1881:

Line 1884: fnd_log.level_procedure,

1880: l_stmt_num :=0;
1881:
1882: IF l_Log THEN
1883: log_message(
1884: fnd_log.level_procedure,
1885: l_module||'.begin',
1886: 'Entering CST_SLA_UPDATE_PKG.Update_Proc_RCV_WKR with '||
1887: 'X_batch_size = '||X_batch_size||','||
1888: 'X_Worker_Id = '||X_Worker_Id||','||

Line 1956: fnd_log.level_procedure,

1952:
1953: l_stmt_num :=25;
1954: IF NOT l_any_rows_to_process AND l_Log THEN
1955: log_message(
1956: fnd_log.level_procedure,
1957: l_module||'.'||l_stmt_num,
1958: 'No Rows to Process in RCV'
1959: );
1960: END IF;

Line 1969: fnd_log.level_procedure,

1965: -- Code CST SLA update logic here
1966: --
1967: IF l_Log THEN
1968: log_message(
1969: fnd_log.level_procedure,
1970: l_module||'.'||l_stmt_num,
1971: 'Processing RCV Rows From '||l_start_id||' To '||l_end_id
1972: );
1973: END IF;

Line 2023: fnd_log.level_procedure,

2019: <>
2020:
2021: IF l_Log THEN
2022: log_message(
2023: fnd_log.level_procedure,
2024: l_module||'.end',
2025: 'Exiting CST_SLA_UPDATE_PKG.Update_Proc_RCV_WKR with '||
2026: 'X_errbuf = '||X_errbuf||','||
2027: 'X_retcode = '||X_retcode

Line 2081: l_Log CONSTANT BOOLEAN := fnd_log.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND gRequestId > 0;

2077: l_upg_batch_id number(15):=0;
2078: l_je_category_name varchar2(30);
2079:
2080: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_Inventory_Subledger';
2081: l_Log CONSTANT BOOLEAN := fnd_log.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND gRequestId > 0;
2082:
2083: l_stmt_num number;
2084: l_rows_processed number;
2085:

Line 2092: fnd_log.level_procedure,

2088: l_stmt_num :=0;
2089:
2090: IF l_Log THEN
2091: log_message(
2092: fnd_log.level_procedure,
2093: l_module||'.begin',
2094: 'Entering CST_SLA_UPDATE_PKG.Update_Inventory_Subledger with '||
2095: 'X_min_id = '||X_min_id||','||
2096: 'X_max_id = '||X_max_id

Line 2104: fnd_log.level_procedure,

2100: select XLA_UPG_BATCHES_S.nextval into l_upg_batch_id from dual;
2101:
2102: IF l_Log THEN
2103: log_message(
2104: fnd_log.level_procedure,
2105: l_module||'.'||l_stmt_num,
2106: 'Upgrade Batch ID = '||l_upg_batch_id
2107: );
2108: END IF;

Line 2202: fnd_log.level_procedure,

2198: l_rows_processed := SQL%ROWCOUNT;
2199: IF (l_rows_processed = 0) THEN
2200: IF l_Log THEN
2201: log_message(
2202: fnd_log.level_procedure,
2203: l_module||'.'||l_stmt_num,
2204: 'No rows to be upgraded. Exiting CST_SLA_UPDATE_PKG.Update_Inventory_Subledger with '||
2205: 'X_errbuf = '||X_errbuf||','||
2206: 'X_retcode = '||X_retcode

Line 2845: fnd_log.level_procedure,

2841: <>
2842:
2843: IF l_Log THEN
2844: log_message(
2845: fnd_log.level_procedure,
2846: l_module||'.end',
2847: 'Exiting CST_SLA_UPDATE_PKG.Update_Inventory_Subledger with '||
2848: 'X_errbuf = '||X_errbuf||','||
2849: 'X_retcode = '||X_retcode

Line 2900: l_Log CONSTANT BOOLEAN := fnd_log.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND gRequestId > 0;

2896: l_upg_batch_id number(15):=0;
2897: l_je_category_name varchar2(30);
2898:
2899: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_WIP_Subledger';
2900: l_Log CONSTANT BOOLEAN := fnd_log.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND gRequestId > 0;
2901:
2902: l_stmt_num number;
2903: l_rows_processed number;
2904: BEGIN

Line 2910: fnd_log.level_procedure,

2906: l_stmt_num :=0;
2907:
2908: IF l_Log THEN
2909: log_message(
2910: fnd_log.level_procedure,
2911: l_module||'.begin',
2912: 'Entering CST_SLA_UPDATE_PKG.Update_WIP_Subledger with '||
2913: 'X_min_id = '||X_min_id||','||
2914: 'X_max_id = '||X_max_id

Line 2922: fnd_log.level_procedure,

2918: select XLA_UPG_BATCHES_S.nextval into l_upg_batch_id from dual;
2919:
2920: IF l_Log THEN
2921: log_message(
2922: fnd_log.level_procedure,
2923: l_module||'.'||l_stmt_num,
2924: 'Upgrade Batch ID = '||l_upg_batch_id
2925: );
2926: END IF;

Line 2982: fnd_log.level_procedure,

2978: l_rows_processed := SQL%ROWCOUNT;
2979: IF (l_rows_processed = 0) THEN
2980: IF l_Log THEN
2981: log_message(
2982: fnd_log.level_procedure,
2983: l_module||'.'||l_stmt_num,
2984: 'No rows to be upgraded. Exiting CST_SLA_UPDATE_PKG.Update_WIP_Subledger with '||
2985: 'X_errbuf = '||X_errbuf||','||
2986: 'X_retcode = '||X_retcode

Line 3414: fnd_log.level_procedure,

3410: <>
3411:
3412: IF l_Log THEN
3413: log_message(
3414: fnd_log.level_procedure,
3415: l_module||'.end',
3416: 'Exiting CST_SLA_UPDATE_PKG.Update_WIP_Subledger with '||
3417: 'X_errbuf = '||X_errbuf||','||
3418: 'X_retcode = '||X_retcode

Line 3470: l_Log CONSTANT BOOLEAN := fnd_log.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND gRequestId > 0;

3466: l_upg_batch_id number(15):=0;
3467: l_je_category_name varchar2(30);
3468:
3469: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_Receiving_Subledger';
3470: l_Log CONSTANT BOOLEAN := fnd_log.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND gRequestId > 0;
3471:
3472: l_stmt_num number;
3473: l_multi_org_flag varchar2(1);
3474: l_rows_processed number;

Line 3483: fnd_log.level_procedure,

3479: l_stmt_num :=0;
3480:
3481: IF l_Log THEN
3482: log_message(
3483: fnd_log.level_procedure,
3484: l_module||'.'||l_stmt_num,
3485: 'Entering CST_SLA_UPDATE_PKG.Update_Receiving_Subledger with '||
3486: 'X_min_id = '||X_min_id||','||
3487: 'X_max_id = '||X_max_id

Line 3495: fnd_log.level_procedure,

3491: select XLA_UPG_BATCHES_S.nextval into l_upg_batch_id from dual;
3492:
3493: IF l_Log THEN
3494: log_message(
3495: fnd_log.level_procedure,
3496: l_module,
3497: 'Upgrade Batch ID = '||l_upg_batch_id
3498: );
3499: END IF;

Line 3573: fnd_log.level_procedure,

3569: l_rows_processed := SQL%ROWCOUNT;
3570: IF (l_rows_processed = 0) THEN
3571: IF l_Log THEN
3572: log_message(
3573: fnd_log.level_procedure,
3574: l_module||'.'||l_stmt_num,
3575: 'No rows to be upgraded. Exiting CST_SLA_UPDATE_PKG.Update_Receiving_Subledger with '||
3576: 'X_errbuf = '||X_errbuf||','||
3577: 'X_retcode = '||X_retcode

Line 3954: fnd_log.level_procedure,

3950: <>
3951:
3952: IF l_Log THEN
3953: log_message(
3954: fnd_log.level_procedure,
3955: l_module||'.end',
3956: 'Exiting CST_SLA_UPDATE_PKG.Update_Receiving_Subledger with '||
3957: 'X_errbuf = '||X_errbuf||','||
3958: 'X_retcode = '||X_retcode