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_SOO_PVT dependencies on FND_LOG

Line 70: -- Variables used in FND Log

66: p_mod_name in varchar2,
67: p_severity_level in number
68: ) IS
69:
70: -- Variables used in FND Log
71: l_stat_level number := FND_LOG.LEVEL_STATEMENT;
72: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
73: l_event_level number := FND_LOG.LEVEL_EVENT;
74: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;

Line 71: l_stat_level number := FND_LOG.LEVEL_STATEMENT;

67: p_severity_level in number
68: ) IS
69:
70: -- Variables used in FND Log
71: l_stat_level number := FND_LOG.LEVEL_STATEMENT;
72: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
73: l_event_level number := FND_LOG.LEVEL_EVENT;
74: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
75: l_error_level number := FND_LOG.LEVEL_ERROR;

Line 72: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;

68: ) IS
69:
70: -- Variables used in FND Log
71: l_stat_level number := FND_LOG.LEVEL_STATEMENT;
72: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
73: l_event_level number := FND_LOG.LEVEL_EVENT;
74: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
75: l_error_level number := FND_LOG.LEVEL_ERROR;
76: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;

Line 73: l_event_level number := FND_LOG.LEVEL_EVENT;

69:
70: -- Variables used in FND Log
71: l_stat_level number := FND_LOG.LEVEL_STATEMENT;
72: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
73: l_event_level number := FND_LOG.LEVEL_EVENT;
74: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
75: l_error_level number := FND_LOG.LEVEL_ERROR;
76: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
77:

Line 74: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;

70: -- Variables used in FND Log
71: l_stat_level number := FND_LOG.LEVEL_STATEMENT;
72: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
73: l_event_level number := FND_LOG.LEVEL_EVENT;
74: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
75: l_error_level number := FND_LOG.LEVEL_ERROR;
76: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
77:
78: BEGIN

Line 75: l_error_level number := FND_LOG.LEVEL_ERROR;

71: l_stat_level number := FND_LOG.LEVEL_STATEMENT;
72: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
73: l_event_level number := FND_LOG.LEVEL_EVENT;
74: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
75: l_error_level number := FND_LOG.LEVEL_ERROR;
76: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
77:
78: BEGIN
79:

Line 76: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;

72: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
73: l_event_level number := FND_LOG.LEVEL_EVENT;
74: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
75: l_error_level number := FND_LOG.LEVEL_ERROR;
76: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
77:
78: BEGIN
79:
80: IF p_severity_level = 1 THEN

Line 82: FND_LOG.STRING(l_stat_level,p_mod_name,p_message);

78: BEGIN
79:
80: IF p_severity_level = 1 THEN
81: IF ( l_stat_level >= G_debug_level) THEN
82: FND_LOG.STRING(l_stat_level,p_mod_name,p_message);
83: END IF;
84: ELSIF p_severity_level = 2 THEN
85: IF ( l_proc_level >= G_debug_level) THEN
86: FND_LOG.STRING(l_proc_level,p_mod_name,p_message);

Line 86: FND_LOG.STRING(l_proc_level,p_mod_name,p_message);

82: FND_LOG.STRING(l_stat_level,p_mod_name,p_message);
83: END IF;
84: ELSIF p_severity_level = 2 THEN
85: IF ( l_proc_level >= G_debug_level) THEN
86: FND_LOG.STRING(l_proc_level,p_mod_name,p_message);
87: END IF;
88: ELSIF p_severity_level = 3 THEN
89: IF ( l_event_level >= G_debug_level) THEN
90: FND_LOG.STRING(l_event_level,p_mod_name,p_message);

Line 90: FND_LOG.STRING(l_event_level,p_mod_name,p_message);

86: FND_LOG.STRING(l_proc_level,p_mod_name,p_message);
87: END IF;
88: ELSIF p_severity_level = 3 THEN
89: IF ( l_event_level >= G_debug_level) THEN
90: FND_LOG.STRING(l_event_level,p_mod_name,p_message);
91: END IF;
92: ELSIF p_severity_level = 4 THEN
93: IF ( l_excep_level >= G_debug_level) THEN
94: FND_LOG.STRING(l_excep_level,p_mod_name,p_message);

Line 94: FND_LOG.STRING(l_excep_level,p_mod_name,p_message);

90: FND_LOG.STRING(l_event_level,p_mod_name,p_message);
91: END IF;
92: ELSIF p_severity_level = 4 THEN
93: IF ( l_excep_level >= G_debug_level) THEN
94: FND_LOG.STRING(l_excep_level,p_mod_name,p_message);
95: END IF;
96: ELSIF p_severity_level = 5 THEN
97: IF ( l_error_level >= G_debug_level) THEN
98: FND_LOG.STRING(l_error_level,p_mod_name,p_message);

Line 98: FND_LOG.STRING(l_error_level,p_mod_name,p_message);

94: FND_LOG.STRING(l_excep_level,p_mod_name,p_message);
95: END IF;
96: ELSIF p_severity_level = 5 THEN
97: IF ( l_error_level >= G_debug_level) THEN
98: FND_LOG.STRING(l_error_level,p_mod_name,p_message);
99: END IF;
100: ELSIF p_severity_level = 6 THEN
101: IF ( l_unexp_level >= G_debug_level) THEN
102: FND_LOG.STRING(l_unexp_level,p_mod_name,p_message);

Line 102: FND_LOG.STRING(l_unexp_level,p_mod_name,p_message);

98: FND_LOG.STRING(l_error_level,p_mod_name,p_message);
99: END IF;
100: ELSIF p_severity_level = 6 THEN
101: IF ( l_unexp_level >= G_debug_level) THEN
102: FND_LOG.STRING(l_unexp_level,p_mod_name,p_message);
103: END IF;
104: END IF;
105:
106: END DEBUG;

Line 155: -- Variables used in FND Log

151: -- Standard Variables
152: l_api_name CONSTANT VARCHAR2(20) := 'GET_DOCUMENT_STATUS';
153: l_api_version CONSTANT NUMBER := 1.0;
154:
155: -- Variables used in FND Log
156: l_error_level number := FND_LOG.LEVEL_ERROR;
157: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.get_document_status';
158:
159: l_status_name varchar2(500);

Line 156: l_error_level number := FND_LOG.LEVEL_ERROR;

152: l_api_name CONSTANT VARCHAR2(20) := 'GET_DOCUMENT_STATUS';
153: l_api_version CONSTANT NUMBER := 1.0;
154:
155: -- Variables used in FND Log
156: l_error_level number := FND_LOG.LEVEL_ERROR;
157: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.get_document_status';
158:
159: l_status_name varchar2(500);
160:

Line 337: -- Variables in FND log

333: -- Standard Variables
334: l_api_name CONSTANT VARCHAR2(30) := 'REFRESH_JOB';
335: l_api_version CONSTANT NUMBER := 1.0;
336:
337: -- Variables in FND log
338: l_error_level number := FND_LOG.LEVEL_ERROR;
339: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh_job';
340:
341: l_user_id NUMBER;

Line 338: l_error_level number := FND_LOG.LEVEL_ERROR;

334: l_api_name CONSTANT VARCHAR2(30) := 'REFRESH_JOB';
335: l_api_version CONSTANT NUMBER := 1.0;
336:
337: -- Variables in FND log
338: l_error_level number := FND_LOG.LEVEL_ERROR;
339: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh_job';
340:
341: l_user_id NUMBER;
342: l_login_id NUMBER;

Line 590: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

586: IF ( l_error_level >= G_debug_level) THEN
587: fnd_message.set_name('CSD','CSD_SQL_ERROR');
588: fnd_message.set_token('SQLERRM',SQLERRM);
589: fnd_message.set_token('SQLCODE',SQLCODE);
590: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
591: END If;
592: ROLLBACK TO REFRESH_JOB;
593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
594: x_msg_count := fnd_msg_pub.count_msg;

Line 601: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

597: IF ( l_error_level >= G_debug_level) THEN
598: fnd_message.set_name('CSD','CSD_SQL_ERROR');
599: fnd_message.set_token('SQLERRM',SQLERRM);
600: fnd_message.set_token('SQLCODE',SQLCODE);
601: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
602: END If;
603: ROLLBACK TO REFRESH_JOB;
604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
605: IF FND_MSG_PUB.Check_Msg_Level

Line 638: -- Variables in FND log

634: -- Standard Variables
635: l_api_name CONSTANT VARCHAR2(30) := 'REFRESH_SR';
636: l_api_version CONSTANT NUMBER := 1.0;
637:
638: -- Variables in FND log
639: l_error_level number := FND_LOG.LEVEL_ERROR;
640: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh_sr';
641:
642: l_user_id NUMBER;

Line 639: l_error_level number := FND_LOG.LEVEL_ERROR;

635: l_api_name CONSTANT VARCHAR2(30) := 'REFRESH_SR';
636: l_api_version CONSTANT NUMBER := 1.0;
637:
638: -- Variables in FND log
639: l_error_level number := FND_LOG.LEVEL_ERROR;
640: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh_sr';
641:
642: l_user_id NUMBER;
643: l_login_id NUMBER;

Line 883: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

879: IF ( l_error_level >= G_debug_level) THEN
880: fnd_message.set_name('CSD','CSD_SQL_ERROR');
881: fnd_message.set_token('SQLERRM',SQLERRM);
882: fnd_message.set_token('SQLCODE',SQLCODE);
883: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
884: END If;
885: ROLLBACK TO REFRESH_SR;
886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
887: x_msg_count := fnd_msg_pub.count_msg;

Line 894: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

890: IF ( l_error_level >= G_debug_level) THEN
891: fnd_message.set_name('CSD','CSD_SQL_ERROR');
892: fnd_message.set_token('SQLERRM',SQLERRM);
893: fnd_message.set_token('SQLCODE',SQLCODE);
894: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
895: END If;
896: ROLLBACK TO REFRESH_SR;
897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
898: IF FND_MSG_PUB.Check_Msg_Level

Line 932: -- Variables in FND log

928: -- Standard Variables
929: l_api_name CONSTANT VARCHAR2(30) := 'REFRESH_SR_TASK';
930: l_api_version CONSTANT NUMBER := 1.0;
931:
932: -- Variables in FND log
933: l_error_level number := FND_LOG.LEVEL_ERROR;
934: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh_sr_task';
935:
936: l_user_id NUMBER;

Line 933: l_error_level number := FND_LOG.LEVEL_ERROR;

929: l_api_name CONSTANT VARCHAR2(30) := 'REFRESH_SR_TASK';
930: l_api_version CONSTANT NUMBER := 1.0;
931:
932: -- Variables in FND log
933: l_error_level number := FND_LOG.LEVEL_ERROR;
934: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh_sr_task';
935:
936: l_user_id NUMBER;
937: l_login_id NUMBER;

Line 1181: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

1177: IF ( l_error_level >= G_debug_level) THEN
1178: fnd_message.set_name('CSD','CSD_SQL_ERROR');
1179: fnd_message.set_token('SQLERRM',SQLERRM);
1180: fnd_message.set_token('SQLCODE',SQLCODE);
1181: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
1182: END If;
1183: ROLLBACK TO REFRESH_SR_TASK;
1184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1185: x_msg_count := fnd_msg_pub.count_msg;

Line 1192: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

1188: IF ( l_error_level >= G_debug_level) THEN
1189: fnd_message.set_name('CSD','CSD_SQL_ERROR');
1190: fnd_message.set_token('SQLERRM',SQLERRM);
1191: fnd_message.set_token('SQLCODE',SQLCODE);
1192: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
1193: END If;
1194: ROLLBACK TO REFRESH_SR_TASK;
1195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1196: IF FND_MSG_PUB.Check_Msg_Level

Line 1230: -- Variables in FND log

1226: -- Standard Variables
1227: l_api_name CONSTANT VARCHAR2(30) := 'REFRESH_PURCHASE_REQ';
1228: l_api_version CONSTANT NUMBER := 1.0;
1229:
1230: -- Variables in FND log
1231: l_error_level number := FND_LOG.LEVEL_ERROR;
1232: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh_purchase_req';
1233:
1234: l_user_id NUMBER;

Line 1231: l_error_level number := FND_LOG.LEVEL_ERROR;

1227: l_api_name CONSTANT VARCHAR2(30) := 'REFRESH_PURCHASE_REQ';
1228: l_api_version CONSTANT NUMBER := 1.0;
1229:
1230: -- Variables in FND log
1231: l_error_level number := FND_LOG.LEVEL_ERROR;
1232: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh_purchase_req';
1233:
1234: l_user_id NUMBER;
1235: l_login_id NUMBER;

Line 1493: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

1489: IF ( l_error_level >= G_debug_level) THEN
1490: fnd_message.set_name('CSD','CSD_SQL_ERROR');
1491: fnd_message.set_token('SQLERRM',SQLERRM);
1492: fnd_message.set_token('SQLCODE',SQLCODE);
1493: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
1494: END If;
1495: ROLLBACK TO REFRESH_PURCHASE_REQ;
1496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1497: x_msg_count := fnd_msg_pub.count_msg;

Line 1504: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

1500: IF ( l_error_level >= G_debug_level) THEN
1501: fnd_message.set_name('CSD','CSD_SQL_ERROR');
1502: fnd_message.set_token('SQLERRM',SQLERRM);
1503: fnd_message.set_token('SQLCODE',SQLCODE);
1504: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
1505: END If;
1506: ROLLBACK TO REFRESH_PURCHASE_REQ;
1507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1508: IF FND_MSG_PUB.Check_Msg_Level

Line 1542: -- Variables in FND log

1538: -- Standard Variables
1539: l_api_name CONSTANT VARCHAR2(30) := 'REFRESH_INTERNAL_REQ';
1540: l_api_version CONSTANT NUMBER := 1.0;
1541:
1542: -- Variables in FND log
1543: l_error_level number := FND_LOG.LEVEL_ERROR;
1544: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh_internal_req';
1545:
1546: l_user_id NUMBER;

Line 1543: l_error_level number := FND_LOG.LEVEL_ERROR;

1539: l_api_name CONSTANT VARCHAR2(30) := 'REFRESH_INTERNAL_REQ';
1540: l_api_version CONSTANT NUMBER := 1.0;
1541:
1542: -- Variables in FND log
1543: l_error_level number := FND_LOG.LEVEL_ERROR;
1544: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh_internal_req';
1545:
1546: l_user_id NUMBER;
1547: l_login_id NUMBER;

Line 1820: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

1816: IF ( l_error_level >= G_debug_level) THEN
1817: fnd_message.set_name('CSD','CSD_SQL_ERROR');
1818: fnd_message.set_token('SQLERRM',SQLERRM);
1819: fnd_message.set_token('SQLCODE',SQLCODE);
1820: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
1821: END If;
1822: ROLLBACK TO REFRESH_INTERNAL_REQ;
1823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1824: x_msg_count := fnd_msg_pub.count_msg;

Line 1831: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

1827: IF ( l_error_level >= G_debug_level) THEN
1828: fnd_message.set_name('CSD','CSD_SQL_ERROR');
1829: fnd_message.set_token('SQLERRM',SQLERRM);
1830: fnd_message.set_token('SQLCODE',SQLCODE);
1831: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
1832: END If;
1833: ROLLBACK TO REFRESH_INTERNAL_REQ;
1834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1835: IF FND_MSG_PUB.Check_Msg_Level

Line 1869: -- Variables in FND log

1865: -- Standard Variables
1866: l_api_name CONSTANT VARCHAR2(30) := 'REFRESH_INT_SALES_ORDER';
1867: l_api_version CONSTANT NUMBER := 1.0;
1868:
1869: -- Variables in FND log
1870: l_error_level number := FND_LOG.LEVEL_ERROR;
1871: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh_int_sales_order';
1872:
1873: l_user_id NUMBER;

Line 1870: l_error_level number := FND_LOG.LEVEL_ERROR;

1866: l_api_name CONSTANT VARCHAR2(30) := 'REFRESH_INT_SALES_ORDER';
1867: l_api_version CONSTANT NUMBER := 1.0;
1868:
1869: -- Variables in FND log
1870: l_error_level number := FND_LOG.LEVEL_ERROR;
1871: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh_int_sales_order';
1872:
1873: l_user_id NUMBER;
1874: l_login_id NUMBER;

Line 2123: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

2119: IF ( l_error_level >= G_debug_level) THEN
2120: fnd_message.set_name('CSD','CSD_SQL_ERROR');
2121: fnd_message.set_token('SQLERRM',SQLERRM);
2122: fnd_message.set_token('SQLCODE',SQLCODE);
2123: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
2124: END If;
2125: ROLLBACK TO REFRESH_ISO;
2126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2127: x_msg_count := fnd_msg_pub.count_msg;

Line 2134: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

2130: IF ( l_error_level >= G_debug_level) THEN
2131: fnd_message.set_name('CSD','CSD_SQL_ERROR');
2132: fnd_message.set_token('SQLERRM',SQLERRM);
2133: fnd_message.set_token('SQLCODE',SQLCODE);
2134: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
2135: END If;
2136: ROLLBACK TO REFRESH_ISO;
2137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2138: IF FND_MSG_PUB.Check_Msg_Level

Line 2173: -- Variables in FND log

2169: -- Standard Variables
2170: l_api_name CONSTANT VARCHAR2(30) := 'REFRESH_RMA';
2171: l_api_version CONSTANT NUMBER := 1.0;
2172:
2173: -- Variables in FND log
2174: l_error_level number := FND_LOG.LEVEL_ERROR;
2175: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh_rma';
2176:
2177: l_user_id NUMBER;

Line 2174: l_error_level number := FND_LOG.LEVEL_ERROR;

2170: l_api_name CONSTANT VARCHAR2(30) := 'REFRESH_RMA';
2171: l_api_version CONSTANT NUMBER := 1.0;
2172:
2173: -- Variables in FND log
2174: l_error_level number := FND_LOG.LEVEL_ERROR;
2175: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh_rma';
2176:
2177: l_user_id NUMBER;
2178: l_login_id NUMBER;

Line 2426: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

2422: IF ( l_error_level >= G_debug_level) THEN
2423: fnd_message.set_name('CSD','CSD_SQL_ERROR');
2424: fnd_message.set_token('SQLERRM',SQLERRM);
2425: fnd_message.set_token('SQLCODE',SQLCODE);
2426: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
2427: END If;
2428: ROLLBACK TO REFRESH_RMA;
2429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2430: x_msg_count := fnd_msg_pub.count_msg;

Line 2437: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

2433: IF ( l_error_level >= G_debug_level) THEN
2434: fnd_message.set_name('CSD','CSD_SQL_ERROR');
2435: fnd_message.set_token('SQLERRM',SQLERRM);
2436: fnd_message.set_token('SQLCODE',SQLCODE);
2437: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
2438: END If;
2439: ROLLBACK TO REFRESH_RMA;
2440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2441: IF FND_MSG_PUB.Check_Msg_Level

Line 2475: -- Variables in FND log

2471: -- Standard Variables
2472: l_api_name CONSTANT VARCHAR2(30) := 'REFRESH_RMA_THIRD_PARTY';
2473: l_api_version CONSTANT NUMBER := 1.0;
2474:
2475: -- Variables in FND log
2476: l_error_level number := FND_LOG.LEVEL_ERROR;
2477: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh_rma_third_party';
2478:
2479: l_user_id NUMBER;

Line 2476: l_error_level number := FND_LOG.LEVEL_ERROR;

2472: l_api_name CONSTANT VARCHAR2(30) := 'REFRESH_RMA_THIRD_PARTY';
2473: l_api_version CONSTANT NUMBER := 1.0;
2474:
2475: -- Variables in FND log
2476: l_error_level number := FND_LOG.LEVEL_ERROR;
2477: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh_rma_third_party';
2478:
2479: l_user_id NUMBER;
2480: l_login_id NUMBER;

Line 2730: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

2726: IF ( l_error_level >= G_debug_level) THEN
2727: fnd_message.set_name('CSD','CSD_SQL_ERROR');
2728: fnd_message.set_token('SQLERRM',SQLERRM);
2729: fnd_message.set_token('SQLCODE',SQLCODE);
2730: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
2731: END If;
2732: ROLLBACK TO REFRESH_RMA_TP;
2733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2734: x_msg_count := fnd_msg_pub.count_msg;

Line 2741: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

2737: IF ( l_error_level >= G_debug_level) THEN
2738: fnd_message.set_name('CSD','CSD_SQL_ERROR');
2739: fnd_message.set_token('SQLERRM',SQLERRM);
2740: fnd_message.set_token('SQLCODE',SQLCODE);
2741: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
2742: END If;
2743: ROLLBACK TO REFRESH_RMA_TP;
2744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2745: IF FND_MSG_PUB.Check_Msg_Level

Line 2779: -- Variables in FND log

2775: -- Standard Variables
2776: l_api_name CONSTANT VARCHAR2(30) := 'REFRESH_SHIP';
2777: l_api_version CONSTANT NUMBER := 1.0;
2778:
2779: -- Variables in FND log
2780: l_error_level number := FND_LOG.LEVEL_ERROR;
2781: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh_ship';
2782:
2783: l_user_id NUMBER;

Line 2780: l_error_level number := FND_LOG.LEVEL_ERROR;

2776: l_api_name CONSTANT VARCHAR2(30) := 'REFRESH_SHIP';
2777: l_api_version CONSTANT NUMBER := 1.0;
2778:
2779: -- Variables in FND log
2780: l_error_level number := FND_LOG.LEVEL_ERROR;
2781: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh_ship';
2782:
2783: l_user_id NUMBER;
2784: l_login_id NUMBER;

Line 3034: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

3030: IF ( l_error_level >= G_debug_level) THEN
3031: fnd_message.set_name('CSD','CSD_SQL_ERROR');
3032: fnd_message.set_token('SQLERRM',SQLERRM);
3033: fnd_message.set_token('SQLCODE',SQLCODE);
3034: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
3035: END If;
3036: ROLLBACK TO REFRESH_SHIP;
3037: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3038: x_msg_count := fnd_msg_pub.count_msg;

Line 3045: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

3041: IF ( l_error_level >= G_debug_level) THEN
3042: fnd_message.set_name('CSD','CSD_SQL_ERROR');
3043: fnd_message.set_token('SQLERRM',SQLERRM);
3044: fnd_message.set_token('SQLCODE',SQLCODE);
3045: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
3046: END If;
3047: ROLLBACK TO REFRESH_SHIP;
3048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3049: IF FND_MSG_PUB.Check_Msg_Level

Line 3083: -- Variables in FND log

3079: -- Standard Variables
3080: l_api_name CONSTANT VARCHAR2(30) := 'REFRESH_SHIP_THIRD_PARTY';
3081: l_api_version CONSTANT NUMBER := 1.0;
3082:
3083: -- Variables in FND log
3084: l_error_level number := FND_LOG.LEVEL_ERROR;
3085: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh_ship_third_party';
3086:
3087: l_user_id NUMBER;

Line 3084: l_error_level number := FND_LOG.LEVEL_ERROR;

3080: l_api_name CONSTANT VARCHAR2(30) := 'REFRESH_SHIP_THIRD_PARTY';
3081: l_api_version CONSTANT NUMBER := 1.0;
3082:
3083: -- Variables in FND log
3084: l_error_level number := FND_LOG.LEVEL_ERROR;
3085: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh_ship_third_party';
3086:
3087: l_user_id NUMBER;
3088: l_login_id NUMBER;

Line 3338: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

3334: IF ( l_error_level >= G_debug_level) THEN
3335: fnd_message.set_name('CSD','CSD_SQL_ERROR');
3336: fnd_message.set_token('SQLERRM',SQLERRM);
3337: fnd_message.set_token('SQLCODE',SQLCODE);
3338: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
3339: END If;
3340: ROLLBACK TO REFRESH_SHIP_TP;
3341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3342: x_msg_count := fnd_msg_pub.count_msg;

Line 3349: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

3345: IF ( l_error_level >= G_debug_level) THEN
3346: fnd_message.set_name('CSD','CSD_SQL_ERROR');
3347: fnd_message.set_token('SQLERRM',SQLERRM);
3348: fnd_message.set_token('SQLCODE',SQLCODE);
3349: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
3350: END If;
3351: ROLLBACK TO REFRESH_SHIP_TP;
3352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3353: IF FND_MSG_PUB.Check_Msg_Level

Line 3387: -- Variables in FND log

3383: -- Standard Variables
3384: l_api_name CONSTANT VARCHAR2(30) := 'REFRESH_DELIVERY';
3385: l_api_version CONSTANT NUMBER := 1.0;
3386:
3387: -- Variables in FND log
3388: l_error_level number := FND_LOG.LEVEL_ERROR;
3389: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh_delivery';
3390:
3391: l_user_id NUMBER;

Line 3388: l_error_level number := FND_LOG.LEVEL_ERROR;

3384: l_api_name CONSTANT VARCHAR2(30) := 'REFRESH_DELIVERY';
3385: l_api_version CONSTANT NUMBER := 1.0;
3386:
3387: -- Variables in FND log
3388: l_error_level number := FND_LOG.LEVEL_ERROR;
3389: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh_delivery';
3390:
3391: l_user_id NUMBER;
3392: l_login_id NUMBER;

Line 3646: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

3642: IF ( l_error_level >= G_debug_level) THEN
3643: fnd_message.set_name('CSD','CSD_SQL_ERROR');
3644: fnd_message.set_token('SQLERRM',SQLERRM);
3645: fnd_message.set_token('SQLCODE',SQLCODE);
3646: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
3647: END If;
3648: ROLLBACK TO REFRESH_DELIVERY;
3649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3650: x_msg_count := fnd_msg_pub.count_msg;

Line 3657: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

3653: IF ( l_error_level >= G_debug_level) THEN
3654: fnd_message.set_name('CSD','CSD_SQL_ERROR');
3655: fnd_message.set_token('SQLERRM',SQLERRM);
3656: fnd_message.set_token('SQLCODE',SQLCODE);
3657: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
3658: END If;
3659: ROLLBACK TO REFRESH_DELIVERY;
3660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3661: IF FND_MSG_PUB.Check_Msg_Level

Line 3701: -- Variables in FND log

3697: -- Standard Variables
3698: l_api_name CONSTANT VARCHAR2(30) := 'REFRESH';
3699: l_api_version CONSTANT NUMBER := 1.0;
3700:
3701: -- Variables in FND log
3702: l_error_level number := FND_LOG.LEVEL_ERROR;
3703: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh';
3704:
3705: CURSOR c_so_orchestration_row(c_orchestration_id NUMBER) IS

Line 3702: l_error_level number := FND_LOG.LEVEL_ERROR;

3698: l_api_name CONSTANT VARCHAR2(30) := 'REFRESH';
3699: l_api_version CONSTANT NUMBER := 1.0;
3700:
3701: -- Variables in FND log
3702: l_error_level number := FND_LOG.LEVEL_ERROR;
3703: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.refresh';
3704:
3705: CURSOR c_so_orchestration_row(c_orchestration_id NUMBER) IS
3706: SELECT repair_line_id, document_type, document_header_id, document_line_id

Line 4372: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

4368: IF ( l_error_level >= G_debug_level) THEN
4369: fnd_message.set_name('CSD','CSD_SQL_ERROR');
4370: fnd_message.set_token('SQLERRM',SQLERRM);
4371: fnd_message.set_token('SQLCODE',SQLCODE);
4372: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
4373: END If;
4374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4375: x_msg_count := fnd_msg_pub.count_msg;
4376: WHEN OTHERS THEN

Line 4382: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);

4378: IF ( l_error_level >= G_debug_level) THEN
4379: fnd_message.set_name('CSD','CSD_SQL_ERROR');
4380: fnd_message.set_token('SQLERRM',SQLERRM);
4381: fnd_message.set_token('SQLCODE',SQLCODE);
4382: FND_LOG.MESSAGE(l_error_level,l_mod_name,FALSE);
4383: END If;
4384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4385: IF FND_MSG_PUB.Check_Msg_Level
4386: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 4424: l_error_level number := FND_LOG.LEVEL_ERROR;

4420: l_msg_count NUMBER;
4421: l_msg_data VARCHAR2(30000);
4422: l_msg_text VARCHAR2(2000);
4423:
4424: l_error_level number := FND_LOG.LEVEL_ERROR;
4425: l_mod_name varchar2(2000) := 'csd.plsql.csd_soo_pvt.Soo_Driver_Main';
4426:
4427: l_so_orchestration_key_tbl so_orchestration_key_tbl_type;
4428: l_repair_line_id NUMBER;