DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_PUB dependencies on FND_MSG_PUB

Line 115: FND_MSG_PUB.initialize;

111: END IF;
112:
113: -- Check p_init_msg_list
114: IF FND_API.to_boolean(p_init_msg_list) THEN
115: FND_MSG_PUB.initialize;
116: END IF;
117:
118: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
119:

Line 176: FND_MSG_PUB.Count_And_Get

172: -- dbms_output.put_line('commit');
173: COMMIT WORK;
174: END IF;
175:
176: FND_MSG_PUB.Count_And_Get
177: (
178: p_count => x_msg_count,
179: p_data => x_msg_data,
180: p_encoded => FND_API.G_FALSE

Line 192: FND_MSG_PUB.Count_And_Get

188: WHEN FND_API.G_EXC_ERROR THEN
189: ROLLBACK TO DETAIL_TO_DELIVERY_PUB;
190: x_return_status := FND_API.G_RET_STS_ERROR ;
191: wsh_util_core.add_message(x_return_status);
192: FND_MSG_PUB.Count_And_Get
193: (
194: p_count => x_msg_count,
195: p_data => x_msg_data,
196: p_encoded => FND_API.G_FALSE

Line 209: FND_MSG_PUB.Count_And_Get

205: ROLLBACK TO DETAIL_TO_DELIVERY_PUB;
206: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
207: fnd_message.set_name('WSH', 'WSH_PUB_NO_DEL_DET_TBL');
208: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
209: FND_MSG_PUB.Count_And_Get
210: (
211: p_count => x_msg_count,
212: p_data => x_msg_data,
213: p_encoded => FND_API.G_FALSE

Line 225: FND_MSG_PUB.Count_And_Get

221: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
222: ROLLBACK TO DETAIL_TO_DELIVERY_PUB;
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
224: wsh_util_core.add_message(x_return_status, l_module_name);
225: FND_MSG_PUB.Count_And_Get
226: (
227: p_count => x_msg_count,
228: p_data => x_msg_data,
229: p_encoded => FND_API.G_FALSE

Line 241: FND_MSG_PUB.Count_And_Get

237: WHEN others then
238: ROLLBACK TO DETAIL_TO_DELIVERY_PUB;
239: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PUB.DETAIL_TO_DELIVERY');
240: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
241: FND_MSG_PUB.Count_And_Get
242: (
243: p_count => x_msg_count,
244: p_data => x_msg_data,
245: p_encoded => FND_API.G_FALSE

Line 364: FND_MSG_PUB.initialize;

360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
361: END IF;
362: -- Check p_init_msg_list
363: IF FND_API.to_boolean(p_init_msg_list) THEN
364: FND_MSG_PUB.initialize;
365: END IF;
366: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
367:
368:

Line 455: FND_MSG_PUB.Count_And_Get

451: -- dbms_output.put_line('commit');
452: COMMIT WORK;
453: END IF;
454:
455: FND_MSG_PUB.Count_And_Get
456: (
457: p_count => x_msg_count,
458: p_data => x_msg_data,
459: p_encoded => FND_API.G_FALSE

Line 471: FND_MSG_PUB.Count_And_Get

467: WHEN FND_API.G_EXC_ERROR THEN
468: ROLLBACK TO SPLIT_LINE_PUB;
469: x_return_status := FND_API.G_RET_STS_ERROR ;
470: wsh_util_core.add_message(x_return_status);
471: FND_MSG_PUB.Count_And_Get
472: (
473: p_count => x_msg_count,
474: p_data => x_msg_data,
475: p_encoded => FND_API.G_FALSE

Line 487: FND_MSG_PUB.Count_And_Get

483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
484: ROLLBACK TO SPLIT_LINE_PUB;
485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
486: wsh_util_core.add_message(x_return_status, l_module_name);
487: FND_MSG_PUB.Count_And_Get
488: (
489: p_count => x_msg_count,
490: p_data => x_msg_data,
491: p_encoded => FND_API.G_FALSE

Line 504: FND_MSG_PUB.Count_And_Get

500: ROLLBACK TO SPLIT_LINE_PUB;
501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
502: wsh_util_core.add_message(x_return_status, l_module_name);
503: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Split_Line');
504: FND_MSG_PUB.Count_And_Get
505: (
506: p_count => x_msg_count,
507: p_data => x_msg_data,
508: p_encoded => FND_API.G_FALSE

Line 780: FND_MSG_PUB.initialize;

776: END IF;
777:
778: -- Initialize message stack if required
779: IF FND_API.to_Boolean(p_init_msg_list) THEN
780: FND_MSG_PUB.initialize;
781: END IF;
782:
783: --
784: -- sperera source_code has to be 'OE' or 'WSH'

Line 897: FND_MSG_PUB.Count_And_Get (

893: IF FND_API.TO_BOOLEAN(p_commit) THEN
894: COMMIT WORK;
895: END IF;
896:
897: FND_MSG_PUB.Count_And_Get (
898: p_count => x_msg_count,
899: p_data => x_msg_data,
900: p_encoded => FND_API.G_FALSE
901: );

Line 912: FND_MSG_PUB.Count_And_Get

908: WHEN FND_API.G_EXC_ERROR THEN
909: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB;
910: x_return_status := FND_API.G_RET_STS_ERROR ;
911: wsh_util_core.add_message(x_return_status);
912: FND_MSG_PUB.Count_And_Get
913: (
914: p_count => x_msg_count,
915: p_data => x_msg_data,
916: p_encoded => FND_API.G_FALSE

Line 928: FND_MSG_PUB.Count_And_Get

924: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
925: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB;
926: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
927: wsh_util_core.add_message(x_return_status, l_module_name);
928: FND_MSG_PUB.Count_And_Get
929: (
930: p_count => x_msg_count,
931: p_data => x_msg_data,
932: p_encoded => FND_API.G_FALSE

Line 952: FND_MSG_PUB.Count_And_Get

948: IF c_valid_source_code%ISOPEN THEN
949: CLOSE c_valid_source_code;
950: END IF;
951: --RTV changes
952: FND_MSG_PUB.Count_And_Get
953: (
954: p_count => x_msg_count,
955: p_data => x_msg_data,
956: p_encoded => FND_API.G_FALSE

Line 971: FND_MSG_PUB.Count_And_Get

967: WSH_UTIL_CORE.add_message (x_return_status);
968: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes')
969: ;
970:
971: FND_MSG_PUB.Count_And_Get
972: (
973: p_count => x_msg_count,
974: p_data => x_msg_data,
975: p_encoded => FND_API.G_FALSE

Line 1105: FND_MSG_PUB.initialize;

1101: END IF;
1102:
1103: -- Initialize message stack if required
1104: IF FND_API.to_Boolean(p_init_msg_list) THEN
1105: FND_MSG_PUB.initialize;
1106: END IF;
1107:
1108: --
1109: -- sperera source_code has to be 'OE' or 'WSH'

Line 1235: FND_MSG_PUB.Count_And_Get (

1231: IF FND_API.TO_BOOLEAN(p_commit) THEN
1232: COMMIT WORK;
1233: END IF;
1234:
1235: FND_MSG_PUB.Count_And_Get (
1236: p_count => x_msg_count,
1237: p_data => x_msg_data,
1238: p_encoded => FND_API.G_FALSE
1239: );

Line 1250: FND_MSG_PUB.Count_And_Get

1246: WHEN FND_API.G_EXC_ERROR THEN
1247: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB2;
1248: x_return_status := FND_API.G_RET_STS_ERROR ;
1249: wsh_util_core.add_message(x_return_status);
1250: FND_MSG_PUB.Count_And_Get
1251: (
1252: p_count => x_msg_count,
1253: p_data => x_msg_data,
1254: p_encoded => FND_API.G_FALSE

Line 1266: FND_MSG_PUB.Count_And_Get

1262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1263: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB2;
1264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1265: wsh_util_core.add_message(x_return_status, l_module_name);
1266: FND_MSG_PUB.Count_And_Get
1267: (
1268: p_count => x_msg_count,
1269: p_data => x_msg_data,
1270: p_encoded => FND_API.G_FALSE

Line 1291: FND_MSG_PUB.Count_And_Get

1287: CLOSE c_valid_source_code;
1288: END IF;
1289: --RTV changes
1290:
1291: FND_MSG_PUB.Count_And_Get
1292: (
1293: p_count => x_msg_count,
1294: p_data => x_msg_data,
1295: p_encoded => FND_API.G_FALSE

Line 1310: FND_MSG_PUB.Count_And_Get

1306: WSH_UTIL_CORE.add_message (x_return_status);
1307: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes')
1308: ;
1309:
1310: FND_MSG_PUB.Count_And_Get
1311: (
1312: p_count => x_msg_count,
1313: p_data => x_msg_data,
1314: p_encoded => FND_API.G_FALSE

Line 1477: FND_MSG_PUB.initialize;

1473: END IF;
1474:
1475: -- Check p_init_msg_list
1476: IF FND_API.to_boolean(p_init_msg_list) THEN
1477: FND_MSG_PUB.initialize;
1478: END IF;
1479: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1480:
1481: l_action_prms.caller := 'WSH_PUB';

Line 1520: FND_MSG_PUB.Count_And_Get

1516: x_return_status := wsh_util_core.g_ret_sts_warning;
1517: END IF;
1518:
1519:
1520: FND_MSG_PUB.Count_And_Get
1521: (
1522: p_count => x_msg_count,
1523: p_data => x_msg_data,
1524: p_encoded => FND_API.G_FALSE

Line 1542: FND_MSG_PUB.Count_And_Get

1538: WHEN FND_API.G_EXC_ERROR THEN
1539: ROLLBACK TO AUTOCREATE_DEL_PUB;
1540: x_return_status := FND_API.G_RET_STS_ERROR ;
1541: wsh_util_core.add_message(x_return_status);
1542: FND_MSG_PUB.Count_And_Get
1543: (
1544: p_count => x_msg_count,
1545: p_data => x_msg_data,
1546: p_encoded => FND_API.G_FALSE

Line 1557: FND_MSG_PUB.Count_And_Get

1553:
1554: WHEN autocreate_delivery_failed THEN
1555: ROLLBACK TO AUTOCREATE_DEL_PUB;
1556: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1557: FND_MSG_PUB.Count_And_Get
1558: (
1559: p_count => x_msg_count,
1560: p_data => x_msg_data,
1561: p_encoded => FND_API.G_FALSE

Line 1573: FND_MSG_PUB.Count_And_Get

1569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1570: ROLLBACK TO AUTOCREATE_DEL_PUB;
1571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1572: wsh_util_core.add_message(x_return_status, l_module_name);
1573: FND_MSG_PUB.Count_And_Get
1574: (
1575: p_count => x_msg_count,
1576: p_data => x_msg_data,
1577: p_encoded => FND_API.G_FALSE

Line 1590: FND_MSG_PUB.Count_And_Get

1586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1587: ROLLBACK TO AUTOCREATE_DEL_PUB;
1588: wsh_util_core.add_message(x_return_status, l_module_name);
1589: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Autocreate_Deliveries');
1590: FND_MSG_PUB.Count_And_Get
1591: (
1592: p_count => x_msg_count,
1593: p_data => x_msg_data,
1594: p_encoded => FND_API.G_FALSE

Line 1685: FND_MSG_PUB.Count_And_Get

1681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1682: ROLLBACK TO AUTOCREATE_TRIP_PUB;
1683: wsh_util_core.add_message(x_return_status, l_module_name);
1684: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Autocreate_Del_Trip');
1685: FND_MSG_PUB.Count_And_Get
1686: (
1687: p_count => x_msg_count,
1688: p_data => x_msg_data,
1689: p_encoded => FND_API.G_FALSE

Line 1767: FND_MSG_PUB.initialize;

1763: END IF;
1764:
1765: -- Check p_init_msg_list
1766: IF FND_API.to_boolean(p_init_msg_list) THEN
1767: FND_MSG_PUB.initialize;
1768: END IF;
1769: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1770:
1771: l_action_prms.caller := 'WSH_PUB';

Line 1814: FND_MSG_PUB.Count_And_Get

1810: IF FND_API.TO_BOOLEAN(p_commit) THEN
1811: COMMIT WORK;
1812: END IF;
1813:
1814: FND_MSG_PUB.Count_And_Get
1815: (
1816: p_count => x_msg_count,
1817: p_data => x_msg_data,
1818: p_encoded => FND_API.G_FALSE

Line 1831: FND_MSG_PUB.Count_And_Get

1827: WHEN FND_API.G_EXC_ERROR THEN
1828: ROLLBACK TO AUTOCREATE_TRIP_PUB;
1829: x_return_status := FND_API.G_RET_STS_ERROR ;
1830: wsh_util_core.add_message(x_return_status);
1831: FND_MSG_PUB.Count_And_Get
1832: (
1833: p_count => x_msg_count,
1834: p_data => x_msg_data,
1835: p_encoded => FND_API.G_FALSE

Line 1847: FND_MSG_PUB.Count_And_Get

1843: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1844: ROLLBACK TO AUTOCREATE_TRIP_PUB;
1845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1846: wsh_util_core.add_message(x_return_status, l_module_name);
1847: FND_MSG_PUB.Count_And_Get
1848: (
1849: p_count => x_msg_count,
1850: p_data => x_msg_data,
1851: p_encoded => FND_API.G_FALSE

Line 1864: FND_MSG_PUB.Count_And_Get

1860:
1861: WHEN autocreate_trip_failed THEN
1862: ROLLBACK TO AUTOCREATE_TRIP_PUB;
1863: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1864: FND_MSG_PUB.Count_And_Get
1865: (
1866: p_count => x_msg_count,
1867: p_data => x_msg_data,
1868: p_encoded => FND_API.G_FALSE

Line 1882: FND_MSG_PUB.Count_And_Get

1878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1879: ROLLBACK TO AUTOCREATE_TRIP_PUB;
1880: wsh_util_core.add_message(x_return_status, l_module_name);
1881: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Autocreate_Del_Trip');
1882: FND_MSG_PUB.Count_And_Get
1883: (
1884: p_count => x_msg_count,
1885: p_data => x_msg_data,
1886: p_encoded => FND_API.G_FALSE