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 343: FND_MSG_PUB.initialize;

339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
340: END IF;
341: -- Check p_init_msg_list
342: IF FND_API.to_boolean(p_init_msg_list) THEN
343: FND_MSG_PUB.initialize;
344: END IF;
345: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
346:
347:

Line 397: FND_MSG_PUB.Count_And_Get

393: -- dbms_output.put_line('commit');
394: COMMIT WORK;
395: END IF;
396:
397: FND_MSG_PUB.Count_And_Get
398: (
399: p_count => x_msg_count,
400: p_data => x_msg_data,
401: p_encoded => FND_API.G_FALSE

Line 413: FND_MSG_PUB.Count_And_Get

409: WHEN FND_API.G_EXC_ERROR THEN
410: ROLLBACK TO SPLIT_LINE_PUB;
411: x_return_status := FND_API.G_RET_STS_ERROR ;
412: wsh_util_core.add_message(x_return_status);
413: FND_MSG_PUB.Count_And_Get
414: (
415: p_count => x_msg_count,
416: p_data => x_msg_data,
417: p_encoded => FND_API.G_FALSE

Line 429: FND_MSG_PUB.Count_And_Get

425: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
426: ROLLBACK TO SPLIT_LINE_PUB;
427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
428: wsh_util_core.add_message(x_return_status, l_module_name);
429: FND_MSG_PUB.Count_And_Get
430: (
431: p_count => x_msg_count,
432: p_data => x_msg_data,
433: p_encoded => FND_API.G_FALSE

Line 446: FND_MSG_PUB.Count_And_Get

442: ROLLBACK TO SPLIT_LINE_PUB;
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
444: wsh_util_core.add_message(x_return_status, l_module_name);
445: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Split_Line');
446: FND_MSG_PUB.Count_And_Get
447: (
448: p_count => x_msg_count,
449: p_data => x_msg_data,
450: p_encoded => FND_API.G_FALSE

Line 708: FND_MSG_PUB.initialize;

704: END IF;
705:
706: -- Initialize message stack if required
707: IF FND_API.to_Boolean(p_init_msg_list) THEN
708: FND_MSG_PUB.initialize;
709: END IF;
710:
711: --
712: -- sperera source_code has to be 'OE' or 'WSH'

Line 764: FND_MSG_PUB.Count_And_Get (

760: IF FND_API.TO_BOOLEAN(p_commit) THEN
761: COMMIT WORK;
762: END IF;
763:
764: FND_MSG_PUB.Count_And_Get (
765: p_count => x_msg_count,
766: p_data => x_msg_data,
767: p_encoded => FND_API.G_FALSE
768: );

Line 779: FND_MSG_PUB.Count_And_Get

775: WHEN FND_API.G_EXC_ERROR THEN
776: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB;
777: x_return_status := FND_API.G_RET_STS_ERROR ;
778: wsh_util_core.add_message(x_return_status);
779: FND_MSG_PUB.Count_And_Get
780: (
781: p_count => x_msg_count,
782: p_data => x_msg_data,
783: p_encoded => FND_API.G_FALSE

Line 795: FND_MSG_PUB.Count_And_Get

791: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
792: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB;
793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
794: wsh_util_core.add_message(x_return_status, l_module_name);
795: FND_MSG_PUB.Count_And_Get
796: (
797: p_count => x_msg_count,
798: p_data => x_msg_data,
799: p_encoded => FND_API.G_FALSE

Line 815: FND_MSG_PUB.Count_And_Get

811: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_SOURCE_CODE');
812: FND_MESSAGE.SET_TOKEN('SOURCE_CODE',p_source_code );
813: WSH_UTIL_CORE.Add_Message(x_return_status);
814:
815: FND_MSG_PUB.Count_And_Get
816: (
817: p_count => x_msg_count,
818: p_data => x_msg_data,
819: p_encoded => FND_API.G_FALSE

Line 834: FND_MSG_PUB.Count_And_Get

830: WSH_UTIL_CORE.add_message (x_return_status);
831: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes')
832: ;
833:
834: FND_MSG_PUB.Count_And_Get
835: (
836: p_count => x_msg_count,
837: p_data => x_msg_data,
838: p_encoded => FND_API.G_FALSE

Line 954: FND_MSG_PUB.initialize;

950: END IF;
951:
952: -- Initialize message stack if required
953: IF FND_API.to_Boolean(p_init_msg_list) THEN
954: FND_MSG_PUB.initialize;
955: END IF;
956:
957: --
958: -- sperera source_code has to be 'OE' or 'WSH'

Line 1022: FND_MSG_PUB.Count_And_Get (

1018: IF FND_API.TO_BOOLEAN(p_commit) THEN
1019: COMMIT WORK;
1020: END IF;
1021:
1022: FND_MSG_PUB.Count_And_Get (
1023: p_count => x_msg_count,
1024: p_data => x_msg_data,
1025: p_encoded => FND_API.G_FALSE
1026: );

Line 1037: FND_MSG_PUB.Count_And_Get

1033: WHEN FND_API.G_EXC_ERROR THEN
1034: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB2;
1035: x_return_status := FND_API.G_RET_STS_ERROR ;
1036: wsh_util_core.add_message(x_return_status);
1037: FND_MSG_PUB.Count_And_Get
1038: (
1039: p_count => x_msg_count,
1040: p_data => x_msg_data,
1041: p_encoded => FND_API.G_FALSE

Line 1053: FND_MSG_PUB.Count_And_Get

1049: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1050: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB2;
1051: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1052: wsh_util_core.add_message(x_return_status, l_module_name);
1053: FND_MSG_PUB.Count_And_Get
1054: (
1055: p_count => x_msg_count,
1056: p_data => x_msg_data,
1057: p_encoded => FND_API.G_FALSE

Line 1073: FND_MSG_PUB.Count_And_Get

1069: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_SOURCE_CODE');
1070: FND_MESSAGE.SET_TOKEN('SOURCE_CODE',p_source_code );
1071: WSH_UTIL_CORE.Add_Message(x_return_status);
1072:
1073: FND_MSG_PUB.Count_And_Get
1074: (
1075: p_count => x_msg_count,
1076: p_data => x_msg_data,
1077: p_encoded => FND_API.G_FALSE

Line 1092: FND_MSG_PUB.Count_And_Get

1088: WSH_UTIL_CORE.add_message (x_return_status);
1089: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes')
1090: ;
1091:
1092: FND_MSG_PUB.Count_And_Get
1093: (
1094: p_count => x_msg_count,
1095: p_data => x_msg_data,
1096: p_encoded => FND_API.G_FALSE

Line 1259: FND_MSG_PUB.initialize;

1255: END IF;
1256:
1257: -- Check p_init_msg_list
1258: IF FND_API.to_boolean(p_init_msg_list) THEN
1259: FND_MSG_PUB.initialize;
1260: END IF;
1261: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1262:
1263: l_action_prms.caller := 'WSH_PUB';

Line 1302: FND_MSG_PUB.Count_And_Get

1298: x_return_status := wsh_util_core.g_ret_sts_warning;
1299: END IF;
1300:
1301:
1302: FND_MSG_PUB.Count_And_Get
1303: (
1304: p_count => x_msg_count,
1305: p_data => x_msg_data,
1306: p_encoded => FND_API.G_FALSE

Line 1324: FND_MSG_PUB.Count_And_Get

1320: WHEN FND_API.G_EXC_ERROR THEN
1321: ROLLBACK TO AUTOCREATE_DEL_PUB;
1322: x_return_status := FND_API.G_RET_STS_ERROR ;
1323: wsh_util_core.add_message(x_return_status);
1324: FND_MSG_PUB.Count_And_Get
1325: (
1326: p_count => x_msg_count,
1327: p_data => x_msg_data,
1328: p_encoded => FND_API.G_FALSE

Line 1339: FND_MSG_PUB.Count_And_Get

1335:
1336: WHEN autocreate_delivery_failed THEN
1337: ROLLBACK TO AUTOCREATE_DEL_PUB;
1338: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1339: FND_MSG_PUB.Count_And_Get
1340: (
1341: p_count => x_msg_count,
1342: p_data => x_msg_data,
1343: p_encoded => FND_API.G_FALSE

Line 1355: FND_MSG_PUB.Count_And_Get

1351: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1352: ROLLBACK TO AUTOCREATE_DEL_PUB;
1353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1354: wsh_util_core.add_message(x_return_status, l_module_name);
1355: FND_MSG_PUB.Count_And_Get
1356: (
1357: p_count => x_msg_count,
1358: p_data => x_msg_data,
1359: p_encoded => FND_API.G_FALSE

Line 1372: FND_MSG_PUB.Count_And_Get

1368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1369: ROLLBACK TO AUTOCREATE_DEL_PUB;
1370: wsh_util_core.add_message(x_return_status, l_module_name);
1371: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Autocreate_Deliveries');
1372: FND_MSG_PUB.Count_And_Get
1373: (
1374: p_count => x_msg_count,
1375: p_data => x_msg_data,
1376: p_encoded => FND_API.G_FALSE

Line 1467: FND_MSG_PUB.Count_And_Get

1463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1464: ROLLBACK TO AUTOCREATE_TRIP_PUB;
1465: wsh_util_core.add_message(x_return_status, l_module_name);
1466: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Autocreate_Del_Trip');
1467: FND_MSG_PUB.Count_And_Get
1468: (
1469: p_count => x_msg_count,
1470: p_data => x_msg_data,
1471: p_encoded => FND_API.G_FALSE

Line 1549: FND_MSG_PUB.initialize;

1545: END IF;
1546:
1547: -- Check p_init_msg_list
1548: IF FND_API.to_boolean(p_init_msg_list) THEN
1549: FND_MSG_PUB.initialize;
1550: END IF;
1551: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1552:
1553: l_action_prms.caller := 'WSH_PUB';

Line 1596: FND_MSG_PUB.Count_And_Get

1592: IF FND_API.TO_BOOLEAN(p_commit) THEN
1593: COMMIT WORK;
1594: END IF;
1595:
1596: FND_MSG_PUB.Count_And_Get
1597: (
1598: p_count => x_msg_count,
1599: p_data => x_msg_data,
1600: p_encoded => FND_API.G_FALSE

Line 1613: FND_MSG_PUB.Count_And_Get

1609: WHEN FND_API.G_EXC_ERROR THEN
1610: ROLLBACK TO AUTOCREATE_TRIP_PUB;
1611: x_return_status := FND_API.G_RET_STS_ERROR ;
1612: wsh_util_core.add_message(x_return_status);
1613: FND_MSG_PUB.Count_And_Get
1614: (
1615: p_count => x_msg_count,
1616: p_data => x_msg_data,
1617: p_encoded => FND_API.G_FALSE

Line 1629: FND_MSG_PUB.Count_And_Get

1625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1626: ROLLBACK TO AUTOCREATE_TRIP_PUB;
1627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1628: wsh_util_core.add_message(x_return_status, l_module_name);
1629: FND_MSG_PUB.Count_And_Get
1630: (
1631: p_count => x_msg_count,
1632: p_data => x_msg_data,
1633: p_encoded => FND_API.G_FALSE

Line 1646: FND_MSG_PUB.Count_And_Get

1642:
1643: WHEN autocreate_trip_failed THEN
1644: ROLLBACK TO AUTOCREATE_TRIP_PUB;
1645: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1646: FND_MSG_PUB.Count_And_Get
1647: (
1648: p_count => x_msg_count,
1649: p_data => x_msg_data,
1650: p_encoded => FND_API.G_FALSE

Line 1664: FND_MSG_PUB.Count_And_Get

1660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1661: ROLLBACK TO AUTOCREATE_TRIP_PUB;
1662: wsh_util_core.add_message(x_return_status, l_module_name);
1663: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Autocreate_Del_Trip');
1664: FND_MSG_PUB.Count_And_Get
1665: (
1666: p_count => x_msg_count,
1667: p_data => x_msg_data,
1668: p_encoded => FND_API.G_FALSE