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_MESSAGE

Line 233: Fnd_Message.Set_Name('CSD', 'CSD_STATUS_NOT_GIVEN');

229: if (p_status_id is null or p_status_id = FND_API.G_MISS_NUM) and
230: (p_status_code is null or p_status_code = FND_API.G_MISS_CHAR) THEN
231: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
232: THEN
233: Fnd_Message.Set_Name('CSD', 'CSD_STATUS_NOT_GIVEN');
234: Fnd_Msg_Pub.ADD;
235: END IF;
236:
237: RAISE FND_API.G_EXC_ERROR;

Line 281: Fnd_Message.Set_Name('CSD', 'CSD_WRONG_STATUS_GIVEN');

277:
278: if l_status_name is null or l_status_name = '' then
279: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
280: THEN
281: Fnd_Message.Set_Name('CSD', 'CSD_WRONG_STATUS_GIVEN');
282: Fnd_Msg_Pub.ADD;
283: END IF;
284:
285: RAISE FND_API.G_EXC_ERROR;

Line 587: fnd_message.set_name('CSD','CSD_SQL_ERROR');

583: x_msg_count := fnd_msg_pub.count_msg;
584: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
585: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
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;

Line 588: fnd_message.set_token('SQLERRM',SQLERRM);

584: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
585: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
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;

Line 589: fnd_message.set_token('SQLCODE',SQLCODE);

585: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
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 ;

Line 598: fnd_message.set_name('CSD','CSD_SQL_ERROR');

594: x_msg_count := fnd_msg_pub.count_msg;
595: WHEN OTHERS THEN
596: Debug('In OTHERS Exception',l_mod_name,4);
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;

Line 599: fnd_message.set_token('SQLERRM',SQLERRM);

595: WHEN OTHERS THEN
596: Debug('In OTHERS Exception',l_mod_name,4);
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;

Line 600: fnd_message.set_token('SQLCODE',SQLCODE);

596: Debug('In OTHERS Exception',l_mod_name,4);
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 ;

Line 880: fnd_message.set_name('CSD','CSD_SQL_ERROR');

876: x_msg_count := fnd_msg_pub.count_msg;
877: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
878: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
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;

Line 881: fnd_message.set_token('SQLERRM',SQLERRM);

877: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
878: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
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;

Line 882: fnd_message.set_token('SQLCODE',SQLCODE);

878: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
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 ;

Line 891: fnd_message.set_name('CSD','CSD_SQL_ERROR');

887: x_msg_count := fnd_msg_pub.count_msg;
888: WHEN OTHERS THEN
889: Debug('In OTHERS Exception',l_mod_name,4);
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;

Line 892: fnd_message.set_token('SQLERRM',SQLERRM);

888: WHEN OTHERS THEN
889: Debug('In OTHERS Exception',l_mod_name,4);
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;

Line 893: fnd_message.set_token('SQLCODE',SQLCODE);

889: Debug('In OTHERS Exception',l_mod_name,4);
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 ;

Line 1178: fnd_message.set_name('CSD','CSD_SQL_ERROR');

1174: x_msg_count := fnd_msg_pub.count_msg;
1175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1176: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
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;

Line 1179: fnd_message.set_token('SQLERRM',SQLERRM);

1175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1176: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
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;

Line 1180: fnd_message.set_token('SQLCODE',SQLCODE);

1176: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
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 ;

Line 1189: fnd_message.set_name('CSD','CSD_SQL_ERROR');

1185: x_msg_count := fnd_msg_pub.count_msg;
1186: WHEN OTHERS THEN
1187: Debug('In OTHERS Exception',l_mod_name,4);
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;

Line 1190: fnd_message.set_token('SQLERRM',SQLERRM);

1186: WHEN OTHERS THEN
1187: Debug('In OTHERS Exception',l_mod_name,4);
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;

Line 1191: fnd_message.set_token('SQLCODE',SQLCODE);

1187: Debug('In OTHERS Exception',l_mod_name,4);
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 ;

Line 1490: fnd_message.set_name('CSD','CSD_SQL_ERROR');

1486: x_msg_count := fnd_msg_pub.count_msg;
1487: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1488: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
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;

Line 1491: fnd_message.set_token('SQLERRM',SQLERRM);

1487: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1488: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
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;

Line 1492: fnd_message.set_token('SQLCODE',SQLCODE);

1488: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
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 ;

Line 1501: fnd_message.set_name('CSD','CSD_SQL_ERROR');

1497: x_msg_count := fnd_msg_pub.count_msg;
1498: WHEN OTHERS THEN
1499: Debug('In OTHERS Exception',l_mod_name,4);
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;

Line 1502: fnd_message.set_token('SQLERRM',SQLERRM);

1498: WHEN OTHERS THEN
1499: Debug('In OTHERS Exception',l_mod_name,4);
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;

Line 1503: fnd_message.set_token('SQLCODE',SQLCODE);

1499: Debug('In OTHERS Exception',l_mod_name,4);
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 ;

Line 1817: fnd_message.set_name('CSD','CSD_SQL_ERROR');

1813: x_msg_count := fnd_msg_pub.count_msg;
1814: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1815: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
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;

Line 1818: fnd_message.set_token('SQLERRM',SQLERRM);

1814: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1815: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
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;

Line 1819: fnd_message.set_token('SQLCODE',SQLCODE);

1815: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
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 ;

Line 1828: fnd_message.set_name('CSD','CSD_SQL_ERROR');

1824: x_msg_count := fnd_msg_pub.count_msg;
1825: WHEN OTHERS THEN
1826: Debug('In OTHERS Exception',l_mod_name,4);
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;

Line 1829: fnd_message.set_token('SQLERRM',SQLERRM);

1825: WHEN OTHERS THEN
1826: Debug('In OTHERS Exception',l_mod_name,4);
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;

Line 1830: fnd_message.set_token('SQLCODE',SQLCODE);

1826: Debug('In OTHERS Exception',l_mod_name,4);
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 ;

Line 2120: fnd_message.set_name('CSD','CSD_SQL_ERROR');

2116: x_msg_count := fnd_msg_pub.count_msg;
2117: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2118: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
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;

Line 2121: fnd_message.set_token('SQLERRM',SQLERRM);

2117: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2118: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
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;

Line 2122: fnd_message.set_token('SQLCODE',SQLCODE);

2118: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
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 ;

Line 2131: fnd_message.set_name('CSD','CSD_SQL_ERROR');

2127: x_msg_count := fnd_msg_pub.count_msg;
2128: WHEN OTHERS THEN
2129: Debug('In OTHERS Exception',l_mod_name,4);
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;

Line 2132: fnd_message.set_token('SQLERRM',SQLERRM);

2128: WHEN OTHERS THEN
2129: Debug('In OTHERS Exception',l_mod_name,4);
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;

Line 2133: fnd_message.set_token('SQLCODE',SQLCODE);

2129: Debug('In OTHERS Exception',l_mod_name,4);
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 ;

Line 2423: fnd_message.set_name('CSD','CSD_SQL_ERROR');

2419: x_msg_count := fnd_msg_pub.count_msg;
2420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2421: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
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;

Line 2424: fnd_message.set_token('SQLERRM',SQLERRM);

2420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2421: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
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;

Line 2425: fnd_message.set_token('SQLCODE',SQLCODE);

2421: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
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 ;

Line 2434: fnd_message.set_name('CSD','CSD_SQL_ERROR');

2430: x_msg_count := fnd_msg_pub.count_msg;
2431: WHEN OTHERS THEN
2432: Debug('In OTHERS Exception',l_mod_name,4);
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;

Line 2435: fnd_message.set_token('SQLERRM',SQLERRM);

2431: WHEN OTHERS THEN
2432: Debug('In OTHERS Exception',l_mod_name,4);
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;

Line 2436: fnd_message.set_token('SQLCODE',SQLCODE);

2432: Debug('In OTHERS Exception',l_mod_name,4);
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 ;

Line 2727: fnd_message.set_name('CSD','CSD_SQL_ERROR');

2723: x_msg_count := fnd_msg_pub.count_msg;
2724: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2725: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
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;

Line 2728: fnd_message.set_token('SQLERRM',SQLERRM);

2724: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2725: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
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;

Line 2729: fnd_message.set_token('SQLCODE',SQLCODE);

2725: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
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 ;

Line 2738: fnd_message.set_name('CSD','CSD_SQL_ERROR');

2734: x_msg_count := fnd_msg_pub.count_msg;
2735: WHEN OTHERS THEN
2736: Debug('In OTHERS Exception',l_mod_name,4);
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;

Line 2739: fnd_message.set_token('SQLERRM',SQLERRM);

2735: WHEN OTHERS THEN
2736: Debug('In OTHERS Exception',l_mod_name,4);
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;

Line 2740: fnd_message.set_token('SQLCODE',SQLCODE);

2736: Debug('In OTHERS Exception',l_mod_name,4);
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 ;

Line 3031: fnd_message.set_name('CSD','CSD_SQL_ERROR');

3027: x_msg_count := fnd_msg_pub.count_msg;
3028: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3029: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
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;

Line 3032: fnd_message.set_token('SQLERRM',SQLERRM);

3028: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3029: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
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;

Line 3033: fnd_message.set_token('SQLCODE',SQLCODE);

3029: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
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 ;

Line 3042: fnd_message.set_name('CSD','CSD_SQL_ERROR');

3038: x_msg_count := fnd_msg_pub.count_msg;
3039: WHEN OTHERS THEN
3040: Debug('In OTHERS Exception',l_mod_name,4);
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;

Line 3043: fnd_message.set_token('SQLERRM',SQLERRM);

3039: WHEN OTHERS THEN
3040: Debug('In OTHERS Exception',l_mod_name,4);
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;

Line 3044: fnd_message.set_token('SQLCODE',SQLCODE);

3040: Debug('In OTHERS Exception',l_mod_name,4);
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 ;

Line 3335: fnd_message.set_name('CSD','CSD_SQL_ERROR');

3331: x_msg_count := fnd_msg_pub.count_msg;
3332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3333: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
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;

Line 3336: fnd_message.set_token('SQLERRM',SQLERRM);

3332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3333: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
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;

Line 3337: fnd_message.set_token('SQLCODE',SQLCODE);

3333: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
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 ;

Line 3346: fnd_message.set_name('CSD','CSD_SQL_ERROR');

3342: x_msg_count := fnd_msg_pub.count_msg;
3343: WHEN OTHERS THEN
3344: Debug('In OTHERS Exception',l_mod_name,4);
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;

Line 3347: fnd_message.set_token('SQLERRM',SQLERRM);

3343: WHEN OTHERS THEN
3344: Debug('In OTHERS Exception',l_mod_name,4);
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;

Line 3348: fnd_message.set_token('SQLCODE',SQLCODE);

3344: Debug('In OTHERS Exception',l_mod_name,4);
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 ;

Line 3643: fnd_message.set_name('CSD','CSD_SQL_ERROR');

3639: x_msg_count := fnd_msg_pub.count_msg;
3640: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3641: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
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;

Line 3644: fnd_message.set_token('SQLERRM',SQLERRM);

3640: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3641: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
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;

Line 3645: fnd_message.set_token('SQLCODE',SQLCODE);

3641: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
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 ;

Line 3654: fnd_message.set_name('CSD','CSD_SQL_ERROR');

3650: x_msg_count := fnd_msg_pub.count_msg;
3651: WHEN OTHERS THEN
3652: Debug('In OTHERS Exception',l_mod_name,4);
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;

Line 3655: fnd_message.set_token('SQLERRM',SQLERRM);

3651: WHEN OTHERS THEN
3652: Debug('In OTHERS Exception',l_mod_name,4);
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;

Line 3656: fnd_message.set_token('SQLCODE',SQLCODE);

3652: Debug('In OTHERS Exception',l_mod_name,4);
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 ;

Line 4369: fnd_message.set_name('CSD','CSD_SQL_ERROR');

4365: x_msg_count := fnd_msg_pub.count_msg;
4366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4367: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
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;

Line 4370: fnd_message.set_token('SQLERRM',SQLERRM);

4366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4367: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
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 ;

Line 4371: fnd_message.set_token('SQLCODE',SQLCODE);

4367: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR Exception',l_mod_name,4);
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;

Line 4379: fnd_message.set_name('CSD','CSD_SQL_ERROR');

4375: x_msg_count := fnd_msg_pub.count_msg;
4376: WHEN OTHERS THEN
4377: Debug('In OTHERS Exception',l_mod_name,4);
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;

Line 4380: fnd_message.set_token('SQLERRM',SQLERRM);

4376: WHEN OTHERS THEN
4377: Debug('In OTHERS Exception',l_mod_name,4);
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 ;

Line 4381: fnd_message.set_token('SQLCODE',SQLCODE);

4377: Debug('In OTHERS Exception',l_mod_name,4);
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