APPS.CSD_SOO_PVT dependencies on FND_MSG_PUB

Line 231: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)

227: END IF;
228:
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;

Line 234: Fnd_Msg_Pub.ADD;

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;
238: end if;

Line 242: FND_MSG_PUB.initialize;

238: end if;
239:
240: -- Initialize message list if p_init_msg_list is set to TRUE.
241: IF FND_API.to_Boolean( p_init_msg_list ) THEN
242: FND_MSG_PUB.initialize;
243: END IF;
244:
245: -- see CSD_DOCUMENT_TYPES lookup for codes
246: if p_document_type = 'SR' THEN

Line 279: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)

275:
276: x_status_name := l_status_name;
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;

Line 282: Fnd_Msg_Pub.ADD;

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;
286: end if;

Line 288: x_msg_count := fnd_msg_pub.count_msg;

284:
285: RAISE FND_API.G_EXC_ERROR;
286: end if;
287:
288: x_msg_count := fnd_msg_pub.count_msg;
289:
290: EXCEPTION
291: WHEN FND_API.G_EXC_ERROR THEN
292: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4);

Line 293: x_msg_count := fnd_msg_pub.count_msg;

289:
290: EXCEPTION
291: WHEN FND_API.G_EXC_ERROR THEN
292: Debug('In FND_API.G_EXC_ERROR exception',l_mod_name,4);
293: x_msg_count := fnd_msg_pub.count_msg;
294: x_return_status := FND_API.G_RET_STS_ERROR ;
295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
296: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);
297: x_msg_count := fnd_msg_pub.count_msg;

Line 297: x_msg_count := fnd_msg_pub.count_msg;

293: x_msg_count := fnd_msg_pub.count_msg;
294: x_return_status := FND_API.G_RET_STS_ERROR ;
295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
296: Debug('In FND_API.G_EXC_UNEXPECTED_ERROR exception',l_mod_name,4);
297: x_msg_count := fnd_msg_pub.count_msg;
298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
299: WHEN OTHERS THEN
300: Debug('In OTHERS exception',l_mod_name,4);
301:

Line 303: IF FND_MSG_PUB.Check_Msg_Level

299: WHEN OTHERS THEN
300: Debug('In OTHERS exception',l_mod_name,4);
301:
302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
303: IF FND_MSG_PUB.Check_Msg_Level
304: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
305: THEN
306: FND_MSG_PUB.Add_Exc_Msg
307: (G_PKG_NAME ,

Line 304: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

300: Debug('In OTHERS exception',l_mod_name,4);
301:
302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
303: IF FND_MSG_PUB.Check_Msg_Level
304: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
305: THEN
306: FND_MSG_PUB.Add_Exc_Msg
307: (G_PKG_NAME ,
308: l_api_name );

Line 306: FND_MSG_PUB.Add_Exc_Msg

302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
303: IF FND_MSG_PUB.Check_Msg_Level
304: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
305: THEN
306: FND_MSG_PUB.Add_Exc_Msg
307: (G_PKG_NAME ,
308: l_api_name );
309: END IF;
310: x_msg_count := fnd_msg_pub.count_msg;

Line 310: x_msg_count := fnd_msg_pub.count_msg;

306: FND_MSG_PUB.Add_Exc_Msg
307: (G_PKG_NAME ,
308: l_api_name );
309: END IF;
310: x_msg_count := fnd_msg_pub.count_msg;
311:
312: END Get_Document_Status;
313:
314:

Line 378: FND_MSG_PUB.initialize;

374: END IF;
375:
376: -- Initialize message list if p_init_msg_list is set to TRUE.
377: IF FND_API.to_Boolean(p_init_msg_list) THEN
378: FND_MSG_PUB.initialize;
379: END IF;
380:
381: -- Api body starts
382: l_user_id := NVL(fnd_global.USER_ID, -1);

Line 576: x_msg_count := fnd_msg_pub.count_msg;

572: IF FND_API.To_Boolean( p_commit ) THEN
573: COMMIT WORK;
574: END IF;
575:
576: x_msg_count := fnd_msg_pub.count_msg;
577:
578: EXCEPTION
579: WHEN FND_API.G_EXC_ERROR THEN
580: Debug('In FND_API.G_EXC_ERROR Exception ',l_mod_name,4);

Line 583: x_msg_count := fnd_msg_pub.count_msg;

579: WHEN FND_API.G_EXC_ERROR THEN
580: Debug('In FND_API.G_EXC_ERROR Exception ',l_mod_name,4);
581: ROLLBACK TO REFRESH_JOB;
582: x_return_status := FND_API.G_RET_STS_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');

Line 594: x_msg_count := fnd_msg_pub.count_msg;

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;
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');

Line 605: IF FND_MSG_PUB.Check_Msg_Level

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
606: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
607: THEN
608: FND_MSG_PUB.Add_Exc_Msg
609: (G_PKG_NAME ,

Line 606: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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
606: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
607: THEN
608: FND_MSG_PUB.Add_Exc_Msg
609: (G_PKG_NAME ,
610: l_api_name );

Line 608: FND_MSG_PUB.Add_Exc_Msg

604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
605: IF FND_MSG_PUB.Check_Msg_Level
606: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
607: THEN
608: FND_MSG_PUB.Add_Exc_Msg
609: (G_PKG_NAME ,
610: l_api_name );
611: END IF;
612: x_msg_count := fnd_msg_pub.count_msg;

Line 612: x_msg_count := fnd_msg_pub.count_msg;

608: FND_MSG_PUB.Add_Exc_Msg
609: (G_PKG_NAME ,
610: l_api_name );
611: END IF;
612: x_msg_count := fnd_msg_pub.count_msg;
613:
614: END Refresh_Job;
615:
616: PROCEDURE Refresh_SR (p_api_version IN NUMBER,

Line 678: FND_MSG_PUB.initialize;

674: END IF;
675:
676: -- Initialize message list if p_init_msg_list is set to TRUE.
677: IF FND_API.to_Boolean(p_init_msg_list) THEN
678: FND_MSG_PUB.initialize;
679: END IF;
680:
681: -- Api body starts
682: l_user_id := NVL(fnd_global.USER_ID, -1);

Line 869: x_msg_count := fnd_msg_pub.count_msg;

865: IF FND_API.To_Boolean( p_commit ) THEN
866: COMMIT WORK;
867: END IF;
868:
869: x_msg_count := fnd_msg_pub.count_msg;
870:
871: EXCEPTION
872: WHEN FND_API.G_EXC_ERROR THEN
873: Debug('In FND_API.G_EXC_ERROR Exception ',l_mod_name,4);

Line 876: x_msg_count := fnd_msg_pub.count_msg;

872: WHEN FND_API.G_EXC_ERROR THEN
873: Debug('In FND_API.G_EXC_ERROR Exception ',l_mod_name,4);
874: ROLLBACK TO REFRESH_SR;
875: x_return_status := FND_API.G_RET_STS_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');

Line 887: x_msg_count := fnd_msg_pub.count_msg;

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;
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');

Line 898: IF FND_MSG_PUB.Check_Msg_Level

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
899: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
900: THEN
901: FND_MSG_PUB.Add_Exc_Msg
902: (G_PKG_NAME ,

Line 899: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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
899: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
900: THEN
901: FND_MSG_PUB.Add_Exc_Msg
902: (G_PKG_NAME ,
903: l_api_name );

Line 901: FND_MSG_PUB.Add_Exc_Msg

897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
898: IF FND_MSG_PUB.Check_Msg_Level
899: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
900: THEN
901: FND_MSG_PUB.Add_Exc_Msg
902: (G_PKG_NAME ,
903: l_api_name );
904: END IF;
905: x_msg_count := fnd_msg_pub.count_msg;

Line 905: x_msg_count := fnd_msg_pub.count_msg;

901: FND_MSG_PUB.Add_Exc_Msg
902: (G_PKG_NAME ,
903: l_api_name );
904: END IF;
905: x_msg_count := fnd_msg_pub.count_msg;
906:
907: END Refresh_SR;
908:
909: PROCEDURE Refresh_SR_Task

Line 972: FND_MSG_PUB.initialize;

968: END IF;
969:
970: -- Initialize message list if p_init_msg_list is set to TRUE.
971: IF FND_API.to_Boolean(p_init_msg_list) THEN
972: FND_MSG_PUB.initialize;
973: END IF;
974:
975: -- Api body starts
976: l_user_id := NVL(fnd_global.USER_ID, -1);

Line 1167: x_msg_count := fnd_msg_pub.count_msg;

1163: IF FND_API.To_Boolean( p_commit ) THEN
1164: COMMIT WORK;
1165: END IF;
1166:
1167: x_msg_count := fnd_msg_pub.count_msg;
1168:
1169: EXCEPTION
1170: WHEN FND_API.G_EXC_ERROR THEN
1171: Debug('In FND_API.G_EXC_ERROR Exception ',l_mod_name,4);

Line 1174: x_msg_count := fnd_msg_pub.count_msg;

1170: WHEN FND_API.G_EXC_ERROR THEN
1171: Debug('In FND_API.G_EXC_ERROR Exception ',l_mod_name,4);
1172: ROLLBACK TO REFRESH_SR_TASK;
1173: x_return_status := FND_API.G_RET_STS_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');

Line 1185: x_msg_count := fnd_msg_pub.count_msg;

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;
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');

Line 1196: IF FND_MSG_PUB.Check_Msg_Level

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
1197: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1198: THEN
1199: FND_MSG_PUB.Add_Exc_Msg
1200: (G_PKG_NAME ,

Line 1197: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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
1197: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1198: THEN
1199: FND_MSG_PUB.Add_Exc_Msg
1200: (G_PKG_NAME ,
1201: l_api_name );

Line 1199: FND_MSG_PUB.Add_Exc_Msg

1195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1196: IF FND_MSG_PUB.Check_Msg_Level
1197: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1198: THEN
1199: FND_MSG_PUB.Add_Exc_Msg
1200: (G_PKG_NAME ,
1201: l_api_name );
1202: END IF;
1203: x_msg_count := fnd_msg_pub.count_msg;

Line 1203: x_msg_count := fnd_msg_pub.count_msg;

1199: FND_MSG_PUB.Add_Exc_Msg
1200: (G_PKG_NAME ,
1201: l_api_name );
1202: END IF;
1203: x_msg_count := fnd_msg_pub.count_msg;
1204:
1205: END Refresh_SR_Task;
1206:
1207: PROCEDURE Refresh_Purchase_Req

Line 1277: FND_MSG_PUB.initialize;

1273: END IF;
1274:
1275: -- Initialize message list if p_init_msg_list is set to TRUE.
1276: IF FND_API.to_Boolean(p_init_msg_list) THEN
1277: FND_MSG_PUB.initialize;
1278: END IF;
1279:
1280: -- Api body starts
1281: l_user_id := NVL(fnd_global.USER_ID, -1);

Line 1479: x_msg_count := fnd_msg_pub.count_msg;

1475: IF FND_API.To_Boolean( p_commit ) THEN
1476: COMMIT WORK;
1477: END IF;
1478:
1479: x_msg_count := fnd_msg_pub.count_msg;
1480:
1481: EXCEPTION
1482: WHEN FND_API.G_EXC_ERROR THEN
1483: Debug('In FND_API.G_EXC_ERROR Exception ',l_mod_name,4);

Line 1486: x_msg_count := fnd_msg_pub.count_msg;

1482: WHEN FND_API.G_EXC_ERROR THEN
1483: Debug('In FND_API.G_EXC_ERROR Exception ',l_mod_name,4);
1484: ROLLBACK TO REFRESH_PURCHASE_REQ;
1485: x_return_status := FND_API.G_RET_STS_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');

Line 1497: x_msg_count := fnd_msg_pub.count_msg;

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;
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');

Line 1508: IF FND_MSG_PUB.Check_Msg_Level

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
1509: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1510: THEN
1511: FND_MSG_PUB.Add_Exc_Msg
1512: (G_PKG_NAME ,

Line 1509: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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
1509: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1510: THEN
1511: FND_MSG_PUB.Add_Exc_Msg
1512: (G_PKG_NAME ,
1513: l_api_name );

Line 1511: FND_MSG_PUB.Add_Exc_Msg

1507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1508: IF FND_MSG_PUB.Check_Msg_Level
1509: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1510: THEN
1511: FND_MSG_PUB.Add_Exc_Msg
1512: (G_PKG_NAME ,
1513: l_api_name );
1514: END IF;
1515: x_msg_count := fnd_msg_pub.count_msg;

Line 1515: x_msg_count := fnd_msg_pub.count_msg;

1511: FND_MSG_PUB.Add_Exc_Msg
1512: (G_PKG_NAME ,
1513: l_api_name );
1514: END IF;
1515: x_msg_count := fnd_msg_pub.count_msg;
1516:
1517: END Refresh_Purchase_Req;
1518:
1519: PROCEDURE Refresh_Internal_Req

Line 1599: FND_MSG_PUB.initialize;

1595: END IF;
1596:
1597: -- Initialize message list if p_init_msg_list is set to TRUE.
1598: IF FND_API.to_Boolean(p_init_msg_list) THEN
1599: FND_MSG_PUB.initialize;
1600: END IF;
1601:
1602: -- Api body starts
1603: l_user_id := NVL(fnd_global.USER_ID, -1);

Line 1806: x_msg_count := fnd_msg_pub.count_msg;

1802: IF FND_API.To_Boolean( p_commit ) THEN
1803: COMMIT WORK;
1804: END IF;
1805:
1806: x_msg_count := fnd_msg_pub.count_msg;
1807:
1808: EXCEPTION
1809: WHEN FND_API.G_EXC_ERROR THEN
1810: Debug('In FND_API.G_EXC_ERROR Exception ',l_mod_name,4);

Line 1813: x_msg_count := fnd_msg_pub.count_msg;

1809: WHEN FND_API.G_EXC_ERROR THEN
1810: Debug('In FND_API.G_EXC_ERROR Exception ',l_mod_name,4);
1811: ROLLBACK TO REFRESH_INTERNAL_REQ;
1812: x_return_status := FND_API.G_RET_STS_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');

Line 1824: x_msg_count := fnd_msg_pub.count_msg;

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;
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');

Line 1835: IF FND_MSG_PUB.Check_Msg_Level

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
1836: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1837: THEN
1838: FND_MSG_PUB.Add_Exc_Msg
1839: (G_PKG_NAME ,

Line 1836: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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
1836: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1837: THEN
1838: FND_MSG_PUB.Add_Exc_Msg
1839: (G_PKG_NAME ,
1840: l_api_name );

Line 1838: FND_MSG_PUB.Add_Exc_Msg

1834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1835: IF FND_MSG_PUB.Check_Msg_Level
1836: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1837: THEN
1838: FND_MSG_PUB.Add_Exc_Msg
1839: (G_PKG_NAME ,
1840: l_api_name );
1841: END IF;
1842: x_msg_count := fnd_msg_pub.count_msg;

Line 1842: x_msg_count := fnd_msg_pub.count_msg;

1838: FND_MSG_PUB.Add_Exc_Msg
1839: (G_PKG_NAME ,
1840: l_api_name );
1841: END IF;
1842: x_msg_count := fnd_msg_pub.count_msg;
1843:
1844: END Refresh_Internal_Req;
1845:
1846: PROCEDURE Refresh_Int_Sales_Order

Line 1910: FND_MSG_PUB.initialize;

1906: END IF;
1907:
1908: -- Initialize message list if p_init_msg_list is set to TRUE.
1909: IF FND_API.to_Boolean(p_init_msg_list) THEN
1910: FND_MSG_PUB.initialize;
1911: END IF;
1912:
1913: -- Api body starts
1914: l_user_id := NVL(fnd_global.USER_ID, -1);

Line 2110: x_msg_count := fnd_msg_pub.count_msg;

2106: IF FND_API.To_Boolean( p_commit ) THEN
2107: COMMIT WORK;
2108: END IF;
2109:
2110: x_msg_count := fnd_msg_pub.count_msg;
2111: EXCEPTION
2112: WHEN FND_API.G_EXC_ERROR THEN
2113: Debug('In FND_API.G_EXC_ERROR Exception ',l_mod_name,4);
2114: ROLLBACK TO REFRESH_ISO;

Line 2116: x_msg_count := fnd_msg_pub.count_msg;

2112: WHEN FND_API.G_EXC_ERROR THEN
2113: Debug('In FND_API.G_EXC_ERROR Exception ',l_mod_name,4);
2114: ROLLBACK TO REFRESH_ISO;
2115: x_return_status := FND_API.G_RET_STS_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');

Line 2127: x_msg_count := fnd_msg_pub.count_msg;

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;
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');

Line 2138: IF FND_MSG_PUB.Check_Msg_Level

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
2139: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2140: THEN
2141: FND_MSG_PUB.Add_Exc_Msg
2142: (G_PKG_NAME ,

Line 2139: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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
2139: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2140: THEN
2141: FND_MSG_PUB.Add_Exc_Msg
2142: (G_PKG_NAME ,
2143: l_api_name );

Line 2141: FND_MSG_PUB.Add_Exc_Msg

2137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2138: IF FND_MSG_PUB.Check_Msg_Level
2139: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2140: THEN
2141: FND_MSG_PUB.Add_Exc_Msg
2142: (G_PKG_NAME ,
2143: l_api_name );
2144: END IF;
2145: x_msg_count := fnd_msg_pub.count_msg;

Line 2145: x_msg_count := fnd_msg_pub.count_msg;

2141: FND_MSG_PUB.Add_Exc_Msg
2142: (G_PKG_NAME ,
2143: l_api_name );
2144: END IF;
2145: x_msg_count := fnd_msg_pub.count_msg;
2146:
2147:
2148: END Refresh_Int_Sales_Order;
2149:

Line 2213: FND_MSG_PUB.initialize;

2209: END IF;
2210:
2211: -- Initialize message list if p_init_msg_list is set to TRUE.
2212: IF FND_API.to_Boolean(p_init_msg_list) THEN
2213: FND_MSG_PUB.initialize;
2214: END IF;
2215:
2216: -- Api body starts
2217: l_user_id := NVL(fnd_global.USER_ID, -1);

Line 2413: x_msg_count := fnd_msg_pub.count_msg;

2409: IF FND_API.To_Boolean( p_commit ) THEN
2410: COMMIT WORK;
2411: END IF;
2412:
2413: x_msg_count := fnd_msg_pub.count_msg;
2414: EXCEPTION
2415: WHEN FND_API.G_EXC_ERROR THEN
2416: Debug('In FND_API.G_EXC_ERROR Exception ',l_mod_name,4);
2417: ROLLBACK TO REFRESH_RMA;

Line 2419: x_msg_count := fnd_msg_pub.count_msg;

2415: WHEN FND_API.G_EXC_ERROR THEN
2416: Debug('In FND_API.G_EXC_ERROR Exception ',l_mod_name,4);
2417: ROLLBACK TO REFRESH_RMA;
2418: x_return_status := FND_API.G_RET_STS_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');

Line 2430: x_msg_count := fnd_msg_pub.count_msg;

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;
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');

Line 2441: IF FND_MSG_PUB.Check_Msg_Level

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
2442: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2443: THEN
2444: FND_MSG_PUB.Add_Exc_Msg
2445: (G_PKG_NAME ,

Line 2442: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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
2442: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2443: THEN
2444: FND_MSG_PUB.Add_Exc_Msg
2445: (G_PKG_NAME ,
2446: l_api_name );

Line 2444: FND_MSG_PUB.Add_Exc_Msg

2440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2441: IF FND_MSG_PUB.Check_Msg_Level
2442: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2443: THEN
2444: FND_MSG_PUB.Add_Exc_Msg
2445: (G_PKG_NAME ,
2446: l_api_name );
2447: END IF;
2448: x_msg_count := fnd_msg_pub.count_msg;

Line 2448: x_msg_count := fnd_msg_pub.count_msg;

2444: FND_MSG_PUB.Add_Exc_Msg
2445: (G_PKG_NAME ,
2446: l_api_name );
2447: END IF;
2448: x_msg_count := fnd_msg_pub.count_msg;
2449:
2450: END Refresh_RMA;
2451:
2452: PROCEDURE Refresh_RMA_Third_Party

Line 2515: FND_MSG_PUB.initialize;

2511: END IF;
2512:
2513: -- Initialize message list if p_init_msg_list is set to TRUE.
2514: IF FND_API.to_Boolean(p_init_msg_list) THEN
2515: FND_MSG_PUB.initialize;
2516: END IF;
2517:
2518: -- Api body starts
2519: l_user_id := NVL(fnd_global.USER_ID, -1);

Line 2716: x_msg_count := fnd_msg_pub.count_msg;

2712: IF FND_API.To_Boolean( p_commit ) THEN
2713: COMMIT WORK;
2714: END IF;
2715:
2716: x_msg_count := fnd_msg_pub.count_msg;
2717:
2718: EXCEPTION
2719: WHEN FND_API.G_EXC_ERROR THEN
2720: Debug('In FND_API.G_EXC_ERROR Exception ',l_mod_name,4);

Line 2723: x_msg_count := fnd_msg_pub.count_msg;

2719: WHEN FND_API.G_EXC_ERROR THEN
2720: Debug('In FND_API.G_EXC_ERROR Exception ',l_mod_name,4);
2721: ROLLBACK TO REFRESH_RMA_TP;
2722: x_return_status := FND_API.G_RET_STS_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');

Line 2734: x_msg_count := fnd_msg_pub.count_msg;

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;
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');

Line 2745: IF FND_MSG_PUB.Check_Msg_Level

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
2746: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2747: THEN
2748: FND_MSG_PUB.Add_Exc_Msg
2749: (G_PKG_NAME ,

Line 2746: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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
2746: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2747: THEN
2748: FND_MSG_PUB.Add_Exc_Msg
2749: (G_PKG_NAME ,
2750: l_api_name );

Line 2748: FND_MSG_PUB.Add_Exc_Msg

2744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2745: IF FND_MSG_PUB.Check_Msg_Level
2746: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2747: THEN
2748: FND_MSG_PUB.Add_Exc_Msg
2749: (G_PKG_NAME ,
2750: l_api_name );
2751: END IF;
2752: x_msg_count := fnd_msg_pub.count_msg;

Line 2752: x_msg_count := fnd_msg_pub.count_msg;

2748: FND_MSG_PUB.Add_Exc_Msg
2749: (G_PKG_NAME ,
2750: l_api_name );
2751: END IF;
2752: x_msg_count := fnd_msg_pub.count_msg;
2753:
2754: END Refresh_RMA_Third_Party;
2755:
2756: PROCEDURE Refresh_Ship

Line 2819: FND_MSG_PUB.initialize;

2815: END IF;
2816:
2817: -- Initialize message list if p_init_msg_list is set to TRUE.
2818: IF FND_API.to_Boolean(p_init_msg_list) THEN
2819: FND_MSG_PUB.initialize;
2820: END IF;
2821:
2822: -- Api body starts
2823: l_user_id := NVL(fnd_global.USER_ID, -1);

Line 3020: x_msg_count := fnd_msg_pub.count_msg;

3016: IF FND_API.To_Boolean( p_commit ) THEN
3017: COMMIT WORK;
3018: END IF;
3019:
3020: x_msg_count := fnd_msg_pub.count_msg;
3021:
3022: EXCEPTION
3023: WHEN FND_API.G_EXC_ERROR THEN
3024: Debug('In FND_API.G_EXC_ERROR Exception ',l_mod_name,4);

Line 3027: x_msg_count := fnd_msg_pub.count_msg;

3023: WHEN FND_API.G_EXC_ERROR THEN
3024: Debug('In FND_API.G_EXC_ERROR Exception ',l_mod_name,4);
3025: ROLLBACK TO REFRESH_SHIP;
3026: x_return_status := FND_API.G_RET_STS_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');

Line 3038: x_msg_count := fnd_msg_pub.count_msg;

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;
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');

Line 3049: IF FND_MSG_PUB.Check_Msg_Level

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
3050: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3051: THEN
3052: FND_MSG_PUB.Add_Exc_Msg
3053: (G_PKG_NAME ,

Line 3050: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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
3050: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3051: THEN
3052: FND_MSG_PUB.Add_Exc_Msg
3053: (G_PKG_NAME ,
3054: l_api_name );

Line 3052: FND_MSG_PUB.Add_Exc_Msg

3048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3049: IF FND_MSG_PUB.Check_Msg_Level
3050: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3051: THEN
3052: FND_MSG_PUB.Add_Exc_Msg
3053: (G_PKG_NAME ,
3054: l_api_name );
3055: END IF;
3056: x_msg_count := fnd_msg_pub.count_msg;

Line 3056: x_msg_count := fnd_msg_pub.count_msg;

3052: FND_MSG_PUB.Add_Exc_Msg
3053: (G_PKG_NAME ,
3054: l_api_name );
3055: END IF;
3056: x_msg_count := fnd_msg_pub.count_msg;
3057:
3058: END Refresh_Ship;
3059:
3060: PROCEDURE Refresh_Ship_Third_Party

Line 3123: FND_MSG_PUB.initialize;

3119: END IF;
3120:
3121: -- Initialize message list if p_init_msg_list is set to TRUE.
3122: IF FND_API.to_Boolean(p_init_msg_list) THEN
3123: FND_MSG_PUB.initialize;
3124: END IF;
3125:
3126: -- Api body starts
3127: l_user_id := NVL(fnd_global.USER_ID, -1);

Line 3324: x_msg_count := fnd_msg_pub.count_msg;

3320: IF FND_API.To_Boolean( p_commit ) THEN
3321: COMMIT WORK;
3322: END IF;
3323:
3324: x_msg_count := fnd_msg_pub.count_msg;
3325:
3326: EXCEPTION
3327: WHEN FND_API.G_EXC_ERROR THEN
3328: Debug('In FND_API.G_EXC_ERROR Exception ',l_mod_name,4);

Line 3331: x_msg_count := fnd_msg_pub.count_msg;

3327: WHEN FND_API.G_EXC_ERROR THEN
3328: Debug('In FND_API.G_EXC_ERROR Exception ',l_mod_name,4);
3329: ROLLBACK TO REFRESH_SHIP_TP;
3330: x_return_status := FND_API.G_RET_STS_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');

Line 3342: x_msg_count := fnd_msg_pub.count_msg;

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;
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');

Line 3353: IF FND_MSG_PUB.Check_Msg_Level

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
3354: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3355: THEN
3356: FND_MSG_PUB.Add_Exc_Msg
3357: (G_PKG_NAME ,

Line 3354: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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
3354: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3355: THEN
3356: FND_MSG_PUB.Add_Exc_Msg
3357: (G_PKG_NAME ,
3358: l_api_name );

Line 3356: FND_MSG_PUB.Add_Exc_Msg

3352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3353: IF FND_MSG_PUB.Check_Msg_Level
3354: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3355: THEN
3356: FND_MSG_PUB.Add_Exc_Msg
3357: (G_PKG_NAME ,
3358: l_api_name );
3359: END IF;
3360: x_msg_count := fnd_msg_pub.count_msg;

Line 3360: x_msg_count := fnd_msg_pub.count_msg;

3356: FND_MSG_PUB.Add_Exc_Msg
3357: (G_PKG_NAME ,
3358: l_api_name );
3359: END IF;
3360: x_msg_count := fnd_msg_pub.count_msg;
3361:
3362: END Refresh_Ship_Third_Party;
3363:
3364: PROCEDURE Refresh_Delivery

Line 3427: FND_MSG_PUB.initialize;

3423: END IF;
3424:
3425: -- Initialize message list if p_init_msg_list is set to TRUE.
3426: IF FND_API.to_Boolean(p_init_msg_list) THEN
3427: FND_MSG_PUB.initialize;
3428: END IF;
3429:
3430: -- Api body starts
3431: l_user_id := NVL(fnd_global.USER_ID, -1);

Line 3632: x_msg_count := fnd_msg_pub.count_msg;

3628: IF FND_API.To_Boolean( p_commit ) THEN
3629: COMMIT WORK;
3630: END IF;
3631:
3632: x_msg_count := fnd_msg_pub.count_msg;
3633:
3634: EXCEPTION
3635: WHEN FND_API.G_EXC_ERROR THEN
3636: Debug('In FND_API.G_EXC_ERROR Exception ',l_mod_name,4);

Line 3639: x_msg_count := fnd_msg_pub.count_msg;

3635: WHEN FND_API.G_EXC_ERROR THEN
3636: Debug('In FND_API.G_EXC_ERROR Exception ',l_mod_name,4);
3637: ROLLBACK TO REFRESH_DELIVERY;
3638: x_return_status := FND_API.G_RET_STS_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');

Line 3650: x_msg_count := fnd_msg_pub.count_msg;

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;
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');

Line 3661: IF FND_MSG_PUB.Check_Msg_Level

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
3662: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3663: THEN
3664: FND_MSG_PUB.Add_Exc_Msg
3665: (G_PKG_NAME ,

Line 3662: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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
3662: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3663: THEN
3664: FND_MSG_PUB.Add_Exc_Msg
3665: (G_PKG_NAME ,
3666: l_api_name );

Line 3664: FND_MSG_PUB.Add_Exc_Msg

3660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3661: IF FND_MSG_PUB.Check_Msg_Level
3662: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3663: THEN
3664: FND_MSG_PUB.Add_Exc_Msg
3665: (G_PKG_NAME ,
3666: l_api_name );
3667: END IF;
3668: x_msg_count := fnd_msg_pub.count_msg;

Line 3668: x_msg_count := fnd_msg_pub.count_msg;

3664: FND_MSG_PUB.Add_Exc_Msg
3665: (G_PKG_NAME ,
3666: l_api_name );
3667: END IF;
3668: x_msg_count := fnd_msg_pub.count_msg;
3669:
3670: END Refresh_Delivery;
3671:
3672: /*--------------------------------------------------*/

Line 3755: FND_MSG_PUB.initialize;

3751: END IF;
3752:
3753: -- Initialize message list if p_init_msg_list is set to TRUE.
3754: IF FND_API.to_Boolean(p_init_msg_list) THEN
3755: FND_MSG_PUB.initialize;
3756: END IF;
3757:
3758: -- Api body starts
3759:

Line 4359: x_msg_count := fnd_msg_pub.count_msg;

4355: IF FND_API.To_Boolean( p_commit ) THEN
4356: COMMIT WORK;
4357: END IF;
4358:
4359: x_msg_count := fnd_msg_pub.count_msg;
4360:
4361: EXCEPTION
4362: WHEN FND_API.G_EXC_ERROR THEN
4363: Debug('In FND_API.G_EXC_ERROR Exception ',l_mod_name,4);

Line 4365: x_msg_count := fnd_msg_pub.count_msg;

4361: EXCEPTION
4362: WHEN FND_API.G_EXC_ERROR THEN
4363: Debug('In FND_API.G_EXC_ERROR Exception ',l_mod_name,4);
4364: x_return_status := FND_API.G_RET_STS_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');

Line 4375: x_msg_count := fnd_msg_pub.count_msg;

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
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');

Line 4385: IF FND_MSG_PUB.Check_Msg_Level

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)
4387: THEN
4388: FND_MSG_PUB.Add_Exc_Msg
4389: (G_PKG_NAME ,

Line 4386: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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)
4387: THEN
4388: FND_MSG_PUB.Add_Exc_Msg
4389: (G_PKG_NAME ,
4390: l_api_name );

Line 4388: FND_MSG_PUB.Add_Exc_Msg

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)
4387: THEN
4388: FND_MSG_PUB.Add_Exc_Msg
4389: (G_PKG_NAME ,
4390: l_api_name );
4391: END IF;
4392: x_msg_count := fnd_msg_pub.count_msg;

Line 4392: x_msg_count := fnd_msg_pub.count_msg;

4388: FND_MSG_PUB.Add_Exc_Msg
4389: (G_PKG_NAME ,
4390: l_api_name );
4391: END IF;
4392: x_msg_count := fnd_msg_pub.count_msg;
4393:
4394: End Refresh;
4395:
4396:

Line 4479: ' || FND_MSG_PUB.Get(i,FND_API.G_FALSE) ;

4475:
4476: IF l_msg_count > 1 then
4477: FOR i IN 1..l_msg_count LOOP
4478: l_msg_data := l_msg_data || '
4479: ' || FND_MSG_PUB.Get(i,FND_API.G_FALSE) ;
4480: END LOOP ;
4481: fnd_file.put_line(fnd_file.log, '');
4482: fnd_file.put_line(fnd_file.log, l_msg_data);
4483: END IF ;