DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_GRP dependencies on FND_MSG_PUB

Line 289: fnd_msg_pub.initialize;

285: END IF;
286:
287: -- Check p_init_msg_list
288: IF fnd_api.to_boolean(p_init_msg_list) THEN
289: fnd_msg_pub.initialize;
290: END IF;
291:
292: x_return_status := wsh_util_core.g_ret_sts_success;
293:

Line 485: fnd_msg_pub.count_and_get(

481:
482: RAISE wsh_util_core.g_exc_warning;
483: END IF;
484:
485: fnd_msg_pub.count_and_get(
486: p_count => x_msg_count,
487: p_data => x_msg_data,
488: p_encoded => fnd_api.g_false);
489:

Line 503: fnd_msg_pub.count_and_get(

499: EXCEPTION
500: WHEN fnd_api.g_exc_error THEN
501: ROLLBACK TO detail_to_delivery_grp;
502: x_return_status := fnd_api.g_ret_sts_error;
503: fnd_msg_pub.count_and_get(
504: p_count => x_msg_count,
505: p_data => x_msg_data,
506: p_encoded => fnd_api.g_false);
507:

Line 517: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,

513: --
514: WHEN fnd_api.g_exc_unexpected_error THEN
515: ROLLBACK TO detail_to_delivery_grp;
516: x_return_status := fnd_api.g_ret_sts_unexp_error;
517: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
518: p_encoded => fnd_api.g_false);
519:
520: --
521: IF l_debug_on THEN

Line 528: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,

524: END IF;
525: --
526: WHEN wsh_util_core.g_exc_warning THEN
527: x_return_status := wsh_util_core.g_ret_sts_warning;
528: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
529: p_encoded => fnd_api.g_false);
530:
531: --
532: IF l_debug_on THEN

Line 542: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,

538: ROLLBACK TO detail_to_delivery_grp;
539: x_return_status := wsh_util_core.g_ret_sts_error;
540: fnd_message.set_name('WSH', 'WSH_PUB_INVALID_ACTION');
541: wsh_util_core.add_message(x_return_status);
542: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
543: p_encoded => fnd_api.g_false);
544:
545: IF l_debug_on THEN
546: wsh_debug_sv.logmsg(l_module_name, 'WSH_INVALID_ACTION exception has occured.', wsh_debug_sv.c_excep_level);

Line 555: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,

551: ROLLBACK TO detail_to_delivery_grp;
552: x_return_status := wsh_util_core.g_ret_sts_error;
553: fnd_message.set_name('WSH', 'WSH_PUB_NO_DEL_DET_TBL');
554: wsh_util_core.add_message(x_return_status);
555: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
556: p_encoded => fnd_api.g_false);
557:
558: IF l_debug_on THEN
559: wsh_debug_sv.logmsg(l_module_name, 'WSH_NO_DEL_DET_TBL exception has occured.', wsh_debug_sv.c_excep_level);

Line 568: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,

564: ROLLBACK TO detail_to_delivery_grp;
565: x_return_status := wsh_util_core.g_ret_sts_error;
566: fnd_message.set_name('WSH', 'WSH_PUB_NO_DELIVERY');
567: wsh_util_core.add_message(x_return_status);
568: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
569: p_encoded => fnd_api.g_false);
570:
571: IF l_debug_on THEN
572: wsh_debug_sv.logmsg(l_module_name, 'WSH_NO_DELIVERY_ID exception has occured.', wsh_debug_sv.c_excep_level);

Line 585: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,

581: x_return_status := wsh_util_core.g_ret_sts_error;
582: fnd_message.set_name('WSH', 'WSH_DELIVERY_NOT_EXIST');
583: fnd_message.set_token('DELIVERY_NAME', p_delivery_name);
584: wsh_util_core.add_message(x_return_status);
585: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
586: p_encoded => fnd_api.g_false);
587:
588: IF l_debug_on THEN
589: wsh_debug_sv.logmsg(l_module_name, 'WSH_NO_DELIVERY exception has occured.', wsh_debug_sv.c_excep_level);

Line 599: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,

595: x_return_status := wsh_util_core.g_ret_sts_error;
596: fnd_message.set_name('WSH', 'WSH_INVALID_DELIVERY');
597: fnd_message.set_token('DELIVERY', p_delivery_id);
598: wsh_util_core.add_message(x_return_status);
599: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
600: p_encoded => fnd_api.g_false);
601:
602: IF l_debug_on THEN
603: wsh_debug_sv.logmsg(l_module_name, 'WSH_INVALID_DELIVERY_ID exception has occured.', wsh_debug_sv.c_excep_level);

Line 614: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,

610: WHEN OTHERS THEN
611: ROLLBACK TO detail_to_delivery_grp;
612: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
613: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_GRP.DETAIL_TO_DELIVERY');
614: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
615: p_encoded => fnd_api.g_false);
616:
617: IF l_debug_on THEN
618: wsh_debug_sv.logmsg(l_module_name, 'Unexpected error has occured. Oracle error message is ' || SQLERRM, wsh_debug_sv.c_unexpec_err_level);

Line 702: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,

698:
699: WHEN OTHERS THEN
700: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
701: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_GRP.DETAIL_TO_DELIVERY');
702: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
703: p_encoded => fnd_api.g_false);
704:
705: IF l_debug_on THEN
706: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:OTHERS');

Line 825: fnd_msg_pub.initialize;

821: END IF;
822:
823: -- Check p_init_msg_list
824: IF fnd_api.to_boolean(p_init_msg_list) THEN
825: fnd_msg_pub.initialize;
826: END IF;
827:
828: x_return_status := wsh_util_core.g_ret_sts_success;
829: --

Line 946: fnd_msg_pub.count_and_get(

942:
943: RAISE wsh_util_core.g_exc_warning;
944: END IF;
945:
946: fnd_msg_pub.count_and_get(
947: p_count => x_msg_count,
948: p_data => x_msg_data,
949: p_encoded => fnd_api.g_false);
950:

Line 961: fnd_msg_pub.count_and_get(

957: EXCEPTION
958: WHEN fnd_api.g_exc_error THEN
959: ROLLBACK TO split_line_grp;
960: x_return_status := fnd_api.g_ret_sts_error;
961: fnd_msg_pub.count_and_get(
962: p_count => x_msg_count,
963: p_data => x_msg_data,
964: p_encoded => fnd_api.g_false);
965:

Line 975: fnd_msg_pub.count_and_get(

971: --
972: WHEN fnd_api.g_exc_unexpected_error THEN
973: ROLLBACK TO split_line_grp;
974: x_return_status := fnd_api.g_ret_sts_unexp_error;
975: fnd_msg_pub.count_and_get(
976: p_count => x_msg_count,
977: p_data => x_msg_data,
978: p_encoded => fnd_api.g_false);
979:

Line 988: fnd_msg_pub.count_and_get(

984: END IF;
985: --
986: WHEN wsh_util_core.g_exc_warning THEN
987: x_return_status := wsh_util_core.g_ret_sts_warning;
988: fnd_msg_pub.count_and_get(
989: p_count => x_msg_count,
990: p_data => x_msg_data,
991: p_encoded => fnd_api.g_false);
992:

Line 1009: fnd_msg_pub.count_and_get(

1005: fnd_message.set_name('WSH', 'WSH_DET_INVALID_DETAIL');
1006: fnd_message.set_token('DETAIL_ID',p_from_detail_id);
1007: wsh_util_core.add_message(x_return_status);
1008:
1009: fnd_msg_pub.count_and_get(
1010: p_count => x_msg_count,
1011: p_data => x_msg_data,
1012: p_encoded => fnd_api.g_false);
1013:

Line 1025: fnd_msg_pub.count_and_get(

1021: x_return_status := wsh_util_core.g_ret_sts_error;
1022: fnd_message.set_name('WSH', 'WSH_DET_SPLIT_EXCEED');
1023: wsh_util_core.add_message(x_return_status);
1024:
1025: fnd_msg_pub.count_and_get(
1026: p_count => x_msg_count,
1027: p_data => x_msg_data,
1028: p_encoded => fnd_api.g_false);
1029:

Line 1041: fnd_msg_pub.count_and_get(

1037: x_return_status := wsh_util_core.g_ret_sts_error;
1038: fnd_message.set_name('WSH', 'WSH_PUB_INVALID_SPLIT_QTY');
1039: wsh_util_core.add_message(x_return_status);
1040:
1041: fnd_msg_pub.count_and_get(
1042: p_count => x_msg_count,
1043: p_data => x_msg_data,
1044: p_encoded => fnd_api.g_false);
1045:

Line 1057: fnd_msg_pub.count_and_get(

1053: x_return_status := fnd_api.g_ret_sts_unexp_error;
1054: wsh_util_core.add_message(x_return_status, l_module_name);
1055: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_GRP.Split_Line');
1056:
1057: fnd_msg_pub.count_and_get(
1058: p_count => x_msg_count,
1059: p_data => x_msg_data,
1060: p_encoded => fnd_api.g_false);
1061: --

Line 1189: FND_MSG_PUB.initialize;

1185: END IF;
1186:
1187: -- Initialize message stack if required
1188: IF FND_API.to_Boolean(p_init_msg_list) THEN
1189: FND_MSG_PUB.initialize;
1190: END IF;
1191:
1192: -- sperera source_code has to be 'OE' or 'WSH'
1193: IF (NVL(p_source_code, FND_API.G_MISS_CHAR)) NOT IN ('WSH', 'OE') THEN

Line 1407: FND_MSG_PUB.Count_And_Get

1403: COMMIT WORK;
1404: END IF;
1405:
1406: x_return_status := FND_API.G_RET_STS_SUCCESS;
1407: FND_MSG_PUB.Count_And_Get
1408: ( p_count => x_msg_count,
1409: p_data => x_msg_data,
1410: p_encoded => FND_API.G_FALSE
1411: );

Line 1425: FND_MSG_PUB.Count_And_Get

1421: ROLLBACK TO UPDATE_SHIPPING_ATTR_GRP;
1422: FND_MESSAGE.Set_Name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
1423: x_return_status := l_return_status;
1424: WSH_UTIL_CORE.add_message (x_return_status);
1425: FND_MSG_PUB.Count_And_Get
1426: ( p_count => x_msg_count,
1427: p_data => x_msg_data,
1428: p_encoded => FND_API.G_FALSE
1429: );

Line 1443: FND_MSG_PUB.Count_And_Get

1439: ROLLBACK TO UPDATE_SHIPPING_ATTR_GRP;
1440: x_return_status := FND_API.G_RET_STS_ERROR;
1441: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_SOURCE_CODE');
1442: WSH_UTIL_CORE.Add_Message(x_return_status);
1443: FND_MSG_PUB.Count_And_Get
1444: ( p_count => x_msg_count,
1445: p_data => x_msg_data,
1446: p_encoded => FND_API.G_FALSE
1447: );

Line 1464: FND_MSG_PUB.Count_And_Get

1460: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', l_error_attribute);
1461: FND_MESSAGE.SET_TOKEN('ATTRB_VALUE', l_error_attribute_value);
1462: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL', l_error_detail_id);
1463: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1464: FND_MSG_PUB.Count_And_Get
1465: ( p_count => x_msg_count,
1466: p_data => x_msg_data,
1467: p_encoded => FND_API.G_FALSE
1468: );

Line 1480: FND_MSG_PUB.Count_And_Get

1476: WHEN invalid_released_status THEN
1477: ROLLBACK TO UPDATE_SHIPPING_ATTR_GRP;
1478: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1479: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1480: FND_MSG_PUB.Count_And_Get
1481: ( p_count => x_msg_count,
1482: p_data => x_msg_data,
1483: p_encoded => FND_API.G_FALSE
1484: );

Line 1500: FND_MSG_PUB.Count_And_Get

1496: ROLLBACK TO UPDATE_SHIPPING_ATTR_GRP;
1497: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1498: WSH_UTIL_CORE.add_message (x_return_status);
1499: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Update_Shipping_Attributes');
1500: FND_MSG_PUB.Count_And_Get
1501: ( p_count => x_msg_count,
1502: p_data => x_msg_data,
1503: p_encoded => FND_API.G_FALSE
1504: );

Line 1676: FND_MSG_PUB.initialize;

1672: END IF;
1673:
1674: -- Check p_init_msg_list
1675: IF FND_API.to_boolean(p_init_msg_list) THEN
1676: FND_MSG_PUB.initialize;
1677: END IF;
1678: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1679:
1680: IF l_debug_on THEN

Line 1791: FND_MSG_PUB.Count_And_Get

1787: END IF;
1788:
1789: --bug 4070732
1790: --
1791: FND_MSG_PUB.Count_And_Get
1792: (
1793: p_count => x_msg_count,
1794: p_data => x_msg_data,
1795: p_encoded => FND_API.G_FALSE

Line 1837: FND_MSG_PUB.Count_And_Get

1833: END IF;
1834: --
1835: -- End of Code Bugfix 4070732
1836: --
1837: FND_MSG_PUB.Count_And_Get
1838: (
1839: p_count => x_msg_count,
1840: p_data => x_msg_data,
1841: p_encoded => FND_API.G_FALSE

Line 1885: FND_MSG_PUB.Count_And_Get

1881: --
1882: -- End of Code Bugfix 4070732
1883: --
1884:
1885: FND_MSG_PUB.Count_And_Get
1886: (
1887: p_count => x_msg_count,
1888: p_data => x_msg_data,
1889: p_encoded => FND_API.G_FALSE

Line 1933: FND_MSG_PUB.Count_And_Get

1929: --
1930: -- End of Code Bugfix 4070732
1931: --
1932:
1933: FND_MSG_PUB.Count_And_Get
1934: (
1935: p_count => x_msg_count,
1936: p_data => x_msg_data,
1937: p_encoded => FND_API.G_FALSE

Line 1971: FND_MSG_PUB.Count_And_Get

1967: END IF;
1968: --
1969: -- End of code for Bugfix 4070732
1970: --
1971: FND_MSG_PUB.Count_And_Get
1972: (
1973: p_count => x_msg_count,
1974: p_data => x_msg_data,
1975: p_encoded => FND_API.G_FALSE

Line 2010: FND_MSG_PUB.Count_And_Get

2006: END IF;
2007: --
2008: -- End of code for Bugfix 4070732
2009: --
2010: FND_MSG_PUB.Count_And_Get
2011: (
2012: p_count => x_msg_count,
2013: p_data => x_msg_data,
2014: p_encoded => FND_API.G_FALSE

Line 2084: FND_MSG_PUB.initialize;

2080: END IF;
2081:
2082: -- Check p_init_msg_list
2083: IF FND_API.to_boolean(p_init_msg_list) THEN
2084: FND_MSG_PUB.initialize;
2085: END IF;
2086: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2087:
2088: IF l_debug_on THEN

Line 2115: FND_MSG_PUB.Count_And_Get

2111: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
2112: END IF;
2113:
2114:
2115: FND_MSG_PUB.Count_And_Get
2116: (
2117: p_count => x_msg_count,
2118: p_data => x_msg_data,
2119: p_encoded => FND_API.G_FALSE

Line 2136: FND_MSG_PUB.Count_And_Get

2132: EXCEPTION
2133: WHEN FND_API.G_EXC_ERROR THEN
2134: ROLLBACK TO AUTOCREATE_TRIP_GRP;
2135: x_return_status := FND_API.G_RET_STS_ERROR ;
2136: FND_MSG_PUB.Count_And_Get
2137: (
2138: p_count => x_msg_count,
2139: p_data => x_msg_data,
2140: p_encoded => FND_API.G_FALSE

Line 2152: FND_MSG_PUB.Count_And_Get

2148: WHEN autocreate_trip_failed THEN
2149: ROLLBACK TO AUTOCREATE_TRIP_GRP;
2150: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2151: wsh_util_core.add_message(x_return_status);
2152: FND_MSG_PUB.Count_And_Get
2153: (
2154: p_count => x_msg_count,
2155: p_data => x_msg_data,
2156: p_encoded => FND_API.G_FALSE

Line 2165: FND_MSG_PUB.Count_And_Get

2161: END IF;
2162: --
2163: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2164: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2165: FND_MSG_PUB.Count_And_Get
2166: (
2167: p_count => x_msg_count,
2168: p_data => x_msg_data,
2169: p_encoded => FND_API.G_FALSE

Line 2180: FND_MSG_PUB.Count_And_Get

2176: --
2177: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2178: ROLLBACK TO AUTOCREATE_TRIP_GRP;
2179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2180: FND_MSG_PUB.Count_And_Get
2181: (
2182: p_count => x_msg_count,
2183: p_data => x_msg_data,
2184: p_encoded => FND_API.G_FALSE

Line 2198: FND_MSG_PUB.Count_And_Get

2194: ROLLBACK TO AUTOCREATE_TRIP_GRP;
2195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2196: wsh_util_core.add_message(x_return_status, l_module_name);
2197: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Autocreate_Del_Trip');
2198: FND_MSG_PUB.Count_And_Get
2199: (
2200: p_count => x_msg_count,
2201: p_data => x_msg_data,
2202: p_encoded => FND_API.G_FALSE

Line 2519: FND_MSG_PUB.initialize;

2515: -- Initialize message list if p_init_msg_list is set to TRUE.
2516: --
2517: IF FND_API.to_Boolean( p_init_msg_list )
2518: THEN
2519: FND_MSG_PUB.initialize;
2520: ELSE
2521: IF nvl(l_check_dcp, -99) IN (1,2) THEN
2522: WSH_DCP_PVT.G_INIT_MSG_COUNT := fnd_msg_pub.count_msg;
2523: END IF;

Line 2522: WSH_DCP_PVT.G_INIT_MSG_COUNT := fnd_msg_pub.count_msg;

2518: THEN
2519: FND_MSG_PUB.initialize;
2520: ELSE
2521: IF nvl(l_check_dcp, -99) IN (1,2) THEN
2522: WSH_DCP_PVT.G_INIT_MSG_COUNT := fnd_msg_pub.count_msg;
2523: END IF;
2524: END IF;
2525: --
2526: -- Initialize API return status to success

Line 4352: FND_MSG_PUB.Count_And_Get

4348:
4349: x_return_status := l1_return_status;
4350: --bug 4070732
4351:
4352: FND_MSG_PUB.Count_And_Get
4353: (
4354: p_count => x_msg_count,
4355: p_data => x_msg_data,
4356: p_encoded => FND_API.G_FALSE

Line 4431: FND_MSG_PUB.Count_And_Get

4427: END IF;
4428: --
4429: -- End of Code Bugfix 4070732
4430: --
4431: FND_MSG_PUB.Count_And_Get
4432: (
4433: p_count => x_msg_count,
4434: p_data => x_msg_data,
4435: p_encoded => FND_API.G_FALSE

Line 4505: FND_MSG_PUB.Count_And_Get

4501: END IF;
4502: --
4503: -- End of Code Bugfix 4070732
4504: --
4505: FND_MSG_PUB.Count_And_Get
4506: (
4507: p_count => x_msg_count,
4508: p_data => x_msg_data,
4509: p_encoded => FND_API.G_FALSE

Line 4586: FND_MSG_PUB.Count_And_Get

4582: END IF;
4583: --
4584: -- End of Code Bugfix 4070732
4585: --
4586: FND_MSG_PUB.Count_And_Get
4587: (
4588: p_count => x_msg_count,
4589: p_data => x_msg_data,
4590: p_encoded => FND_API.G_FALSE

Line 4663: FND_MSG_PUB.Count_And_Get

4659: END IF;
4660: --
4661: -- End of Code Bugfix 4070732
4662: --
4663: FND_MSG_PUB.Count_And_Get
4664: (
4665: p_count => x_msg_count,
4666: p_data => x_msg_data,
4667: p_encoded => FND_API.G_FALSE

Line 4777: FND_MSG_PUB.initialize;

4773:
4774: -- Initialize message list if p_init_msg_list is set to TRUE.
4775: IF FND_API.to_Boolean( p_init_msg_list )
4776: THEN
4777: FND_MSG_PUB.initialize;
4778: END IF;
4779:
4780: -- Initialize API return status to success
4781: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 4821: FND_MSG_PUB.Count_And_Get

4817: END IF;
4818: COMMIT WORK;
4819: END IF;
4820:
4821: FND_MSG_PUB.Count_And_Get
4822: (
4823: p_count => x_msg_count,
4824: p_data => x_msg_data,
4825: p_encoded => FND_API.G_FALSE

Line 4836: FND_MSG_PUB.Count_And_Get

4832: EXCEPTION
4833: WHEN FND_API.G_EXC_ERROR THEN
4834: ROLLBACK TO CREATE_UPDATE_DEL_DETAIL_GRP;
4835: x_return_status := FND_API.G_RET_STS_ERROR ;
4836: FND_MSG_PUB.Count_And_Get
4837: (
4838: p_count => x_msg_count,
4839: p_data => x_msg_data,
4840: p_encoded => FND_API.G_FALSE

Line 4851: FND_MSG_PUB.Count_And_Get

4847: --
4848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4849: ROLLBACK TO CREATE_UPDATE_DEL_DETAIL_GRP;
4850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4851: FND_MSG_PUB.Count_And_Get
4852: (
4853: p_count => x_msg_count,
4854: p_data => x_msg_data,
4855: p_encoded => FND_API.G_FALSE

Line 4866: FND_MSG_PUB.Count_And_Get

4862: END IF;
4863: --
4864: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
4865: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4866: FND_MSG_PUB.Count_And_Get
4867: (
4868: p_count => x_msg_count,
4869: p_data => x_msg_data,
4870: p_encoded => FND_API.G_FALSE

Line 4882: FND_MSG_PUB.Count_And_Get

4878: WHEN mark_reprice_error then
4879: FND_MESSAGE.Set_Name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
4880: wsh_util_core.add_message(x_return_status, l_module_name);
4881: x_return_status := l_return_status;
4882: FND_MSG_PUB.Count_And_Get
4883: (
4884: p_count => x_msg_count,
4885: p_data => x_msg_data,
4886: p_encoded => FND_API.G_FALSE

Line 4901: FND_MSG_PUB.Count_And_Get

4897: ROLLBACK TO CREATE_UPDATE_DEL_DETAIL_GRP;
4898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4899: wsh_util_core.add_message(x_return_status, l_module_name);
4900: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Create_Update_Delivery_Detail');
4901: FND_MSG_PUB.Count_And_Get
4902: (
4903: p_count => x_msg_count,
4904: p_data => x_msg_data,
4905: p_encoded => FND_API.G_FALSE

Line 6027: FND_MSG_PUB.Count_And_Get

6023: END IF;
6024: END IF;
6025: --END OTM R12
6026: END IF; --}
6027: FND_MSG_PUB.Count_And_Get
6028: (
6029: p_count => x_msg_count,
6030: p_data => x_msg_data,
6031: p_encoded => FND_API.G_FALSE

Line 6044: FND_MSG_PUB.Count_And_Get

6040: EXCEPTION
6041: WHEN FND_API.G_EXC_ERROR THEN
6042: ROLLBACK to CREATE_DEL_DETAIL_GRP;
6043: x_return_status := FND_API.G_RET_STS_ERROR ;
6044: FND_MSG_PUB.Count_And_Get
6045: (
6046: p_count => x_msg_count,
6047: p_data => x_msg_data,
6048: p_encoded => FND_API.G_FALSE

Line 6059: FND_MSG_PUB.Count_And_Get

6055: --
6056: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6057: ROLLBACK to CREATE_DEL_DETAIL_GRP;
6058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6059: FND_MSG_PUB.Count_And_Get
6060: (
6061: p_count => x_msg_count,
6062: p_data => x_msg_data,
6063: p_encoded => FND_API.G_FALSE

Line 6073: FND_MSG_PUB.Count_And_Get

6069: END IF;
6070: --
6071: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
6072: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6073: FND_MSG_PUB.Count_And_Get
6074: (
6075: p_count => x_msg_count,
6076: p_data => x_msg_data,
6077: p_encoded => FND_API.G_FALSE

Line 6091: FND_MSG_PUB.Count_And_Get

6087: ROLLBACK to CREATE_DEL_DETAIL_GRP;
6088: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6089: wsh_util_core.add_message(x_return_status, l_module_name);
6090: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Create_Delivery_Detail');
6091: FND_MSG_PUB.Count_And_Get
6092: (
6093: p_count => x_msg_count,
6094: p_data => x_msg_data,
6095: p_encoded => FND_API.G_FALSE

Line 6872: FND_MSG_PUB.Count_And_Get

6868: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
6869: END IF;
6870: END IF;
6871:
6872: FND_MSG_PUB.Count_And_Get
6873: (
6874: p_count => x_msg_count,
6875: p_data => x_msg_data,
6876: p_encoded => FND_API.G_FALSE

Line 6887: FND_MSG_PUB.Count_And_Get

6883: EXCEPTION
6884: WHEN FND_API.G_EXC_ERROR THEN
6885: ROLLBACK to VALIDATE_DEL_DETAIL_GRP;
6886: x_return_status := FND_API.G_RET_STS_ERROR ;
6887: FND_MSG_PUB.Count_And_Get
6888: (
6889: p_count => x_msg_count,
6890: p_data => x_msg_data,
6891: p_encoded => FND_API.G_FALSE

Line 6903: FND_MSG_PUB.Count_And_Get

6899: --
6900: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6901: ROLLBACK to VALIDATE_DEL_DETAIL_GRP;
6902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6903: FND_MSG_PUB.Count_And_Get
6904: (
6905: p_count => x_msg_count,
6906: p_data => x_msg_data,
6907: p_encoded => FND_API.G_FALSE

Line 6918: FND_MSG_PUB.Count_And_Get

6914: --
6915: --
6916: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
6917: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6918: FND_MSG_PUB.Count_And_Get
6919: (
6920: p_count => x_msg_count,
6921: p_data => x_msg_data,
6922: p_encoded => FND_API.G_FALSE

Line 6939: FND_MSG_PUB.Count_And_Get

6935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6936: wsh_util_core.add_message(x_return_status, l_module_name);
6937: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Validate_Delivery_Detail');
6938:
6939: FND_MSG_PUB.Count_And_Get
6940: (
6941: p_count => x_msg_count,
6942: p_data => x_msg_data,
6943: p_encoded => FND_API.G_FALSE

Line 7101: FND_MSG_PUB.Count_And_Get

7097:
7098: END IF;
7099: --} lpn conv
7100:
7101: FND_MSG_PUB.Count_And_Get
7102: (
7103: p_count => x_msg_count,
7104: p_data => x_msg_data,
7105: p_encoded => FND_API.G_FALSE

Line 7119: FND_MSG_PUB.Count_And_Get

7115: ROLLBACK to UPDATE_DEL_DETAIL_GRP;
7116: x_return_status := FND_API.G_RET_STS_ERROR ;
7117: WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED := 'Y';
7118: WSH_WMS_LPN_GRP.g_update_to_container := 'N';
7119: FND_MSG_PUB.Count_And_Get
7120: (
7121: p_count => x_msg_count,
7122: p_data => x_msg_data,
7123: p_encoded => FND_API.G_FALSE

Line 7140: FND_MSG_PUB.Count_And_Get

7136: ROLLBACK to UPDATE_DEL_DETAIL_GRP;
7137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7138: WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED := 'Y';
7139: WSH_WMS_LPN_GRP.g_update_to_container := 'N';
7140: FND_MSG_PUB.Count_And_Get
7141: (
7142: p_count => x_msg_count,
7143: p_data => x_msg_data,
7144: p_encoded => FND_API.G_FALSE

Line 7192: FND_MSG_PUB.Count_And_Get

7188: -- K LPN CONV. rv
7189: --
7190: WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED := 'Y';
7191: WSH_WMS_LPN_GRP.g_update_to_container := 'N';
7192: FND_MSG_PUB.Count_And_Get
7193: (
7194: p_count => x_msg_count,
7195: p_data => x_msg_data,
7196: p_encoded => FND_API.G_FALSE

Line 7261: FND_MSG_PUB.Count_And_Get

7257: WSH_WMS_LPN_GRP.g_update_to_container := 'N';
7258: wsh_util_core.add_message(x_return_status, l_module_name);
7259: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Update_Delivery_Detail');
7260:
7261: FND_MSG_PUB.Count_And_Get
7262: (
7263: p_count => x_msg_count,
7264: p_data => x_msg_data,
7265: p_encoded => FND_API.G_FALSE

Line 7401: FND_MSG_PUB.Count_And_Get

7397: END IF;
7398:
7399:
7400:
7401: FND_MSG_PUB.Count_And_Get
7402: (
7403: p_count => x_msg_count,
7404: p_data => x_msg_data,
7405: p_encoded => FND_API.G_FALSE

Line 7421: FND_MSG_PUB.Count_And_Get

7417: EXCEPTION
7418: WHEN FND_API.G_EXC_ERROR THEN
7419: ROLLBACK to CANCEL_DEL_DETAIL_GRP;
7420: x_return_status := FND_API.G_RET_STS_ERROR ;
7421: FND_MSG_PUB.Count_And_Get
7422: (
7423: p_count => x_msg_count,
7424: p_data => x_msg_data,
7425: p_encoded => FND_API.G_FALSE

Line 7436: FND_MSG_PUB.Count_And_Get

7432: --
7433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7434: ROLLBACK to CANCEL_DEL_DETAIL_GRP;
7435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7436: FND_MSG_PUB.Count_And_Get
7437: (
7438: p_count => x_msg_count,
7439: p_data => x_msg_data,
7440: p_encoded => FND_API.G_FALSE

Line 7450: FND_MSG_PUB.Count_And_Get

7446: END IF;
7447: --
7448: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
7449: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7450: FND_MSG_PUB.Count_And_Get
7451: (
7452: p_count => x_msg_count,
7453: p_data => x_msg_data,
7454: p_encoded => FND_API.G_FALSE

Line 7468: FND_MSG_PUB.Count_And_Get

7464: ROLLBACK to CANCEL_DEL_DETAIL_GRP;
7465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7466: wsh_util_core.add_message(x_return_status, l_module_name);
7467: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Delete_Delivery_Detail');
7468: FND_MSG_PUB.Count_And_Get
7469: (
7470: p_count => x_msg_count,
7471: p_data => x_msg_data,
7472: p_encoded => FND_API.G_FALSE

Line 9284: fnd_msg_pub.count_and_get(

9280: WSH_DEBUG_SV.log(l_module_name, 'to_serial_number', x_detail_rec.to_serial_number);
9281: END IF;
9282: END IF; -- if check for validation level
9283:
9284: fnd_msg_pub.count_and_get(
9285: p_count => x_msg_count,
9286: p_data => x_msg_data,
9287: p_encoded => fnd_api.g_false);
9288:

Line 9297: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,

9293: EXCEPTION
9294: WHEN fnd_api.g_exc_error THEN
9295: ROLLBACK TO validate_det_line_grp;
9296: x_return_status := fnd_api.g_ret_sts_error;
9297: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
9298: p_encoded => fnd_api.g_false);
9299:
9300: --
9301: IF l_debug_on THEN

Line 9309: fnd_msg_pub.count_and_get(

9305: --
9306: WHEN fnd_api.g_exc_unexpected_error THEN
9307: ROLLBACK TO validate_det_line_grp;
9308: x_return_status := fnd_api.g_ret_sts_unexp_error;
9309: fnd_msg_pub.count_and_get(
9310: p_count => x_msg_count,
9311: p_data => x_msg_data,
9312: p_encoded => fnd_api.g_false);
9313:

Line 9323: fnd_msg_pub.count_and_get(

9319: END IF;
9320: --
9321: WHEN wsh_util_core.g_exc_warning THEN
9322: x_return_status := wsh_util_core.g_ret_sts_warning;
9323: fnd_msg_pub.count_and_get(
9324: p_count => x_msg_count,
9325: p_data => x_msg_data,
9326: p_encoded => fnd_api.g_false);
9327:

Line 9342: fnd_msg_pub.count_and_get(

9338: ROLLBACK TO validate_det_line_grp;
9339: x_return_status := fnd_api.g_ret_sts_unexp_error;
9340: wsh_util_core.add_message(x_return_status, l_module_name);
9341: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_GRP.Validate_Detail_Line');
9342: fnd_msg_pub.count_and_get(
9343: p_count => x_msg_count,
9344: p_data => x_msg_data,
9345: p_encoded => fnd_api.g_false);
9346:

Line 9469: FND_MSG_PUB.Count_And_Get

9465: END IF;
9466: END IF;
9467: END IF;
9468: --
9469: FND_MSG_PUB.Count_And_Get
9470: (
9471: p_count => x_msg_count,
9472: p_data => x_msg_data,
9473: p_encoded => FND_API.G_FALSE

Line 9486: FND_MSG_PUB.Count_And_Get

9482: ROLLBACK TO VALIDATE_DET_CONTAINER_GRP;
9483: x_return_status := FND_API.G_RET_STS_ERROR ;
9484: FND_MESSAGE.SET_NAME('WSH', 'WSH_INVALID_DELIVERED_QTY');
9485: WSH_UTIL_CORE.ADD_MESSAGE(wsh_util_core.g_ret_sts_error, l_module_name);
9486: FND_MSG_PUB.Count_And_Get
9487: (
9488: p_count => x_msg_count,
9489: p_data => x_msg_data,
9490: p_encoded => FND_API.G_FALSE

Line 9501: FND_MSG_PUB.Count_And_Get

9497:
9498: WHEN FND_API.G_EXC_ERROR THEN
9499: ROLLBACK TO VALIDATE_DET_CONTAINER_GRP;
9500: x_return_status := FND_API.G_RET_STS_ERROR ;
9501: FND_MSG_PUB.Count_And_Get
9502: (
9503: p_count => x_msg_count,
9504: p_data => x_msg_data,
9505: p_encoded => FND_API.G_FALSE

Line 9517: FND_MSG_PUB.Count_And_Get

9513:
9514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9515: ROLLBACK TO VALIDATE_DET_CONTAINER_GRP;
9516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9517: FND_MSG_PUB.Count_And_Get
9518: (
9519: p_count => x_msg_count,
9520: p_data => x_msg_data,
9521: p_encoded => FND_API.G_FALSE

Line 9532: FND_MSG_PUB.Count_And_Get

9528: END IF;
9529: --
9530: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
9531: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
9532: FND_MSG_PUB.Count_And_Get
9533: (
9534: p_count => x_msg_count,
9535: p_data => x_msg_data,
9536: p_encoded => FND_API.G_FALSE

Line 9549: FND_MSG_PUB.Count_And_Get

9545: ROLLBACK TO VALIDATE_DET_CONTAINER_GRP;
9546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9547: wsh_util_core.add_message(x_return_status, l_module_name);
9548: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Validate_Detail_Container');
9549: FND_MSG_PUB.Count_And_Get
9550: (
9551: p_count => x_msg_count,
9552: p_data => x_msg_data,
9553: p_encoded => FND_API.G_FALSE

Line 9823: FND_MSG_PUB.Count_And_Get

9819: --}
9820:
9821:
9822:
9823: FND_MSG_PUB.Count_And_Get
9824: (
9825: p_count => x_msg_count,
9826: p_data => x_msg_data,
9827: p_encoded => FND_API.G_FALSE

Line 9838: FND_MSG_PUB.Count_And_Get

9834: EXCEPTION
9835: WHEN FND_API.G_EXC_ERROR THEN
9836: ROLLBACK TO VALIDATE_DET_COMMON_GRP;
9837: x_return_status := FND_API.G_RET_STS_ERROR ;
9838: FND_MSG_PUB.Count_And_Get
9839: (
9840: p_count => x_msg_count,
9841: p_data => x_msg_data,
9842: p_encoded => FND_API.G_FALSE

Line 9853: FND_MSG_PUB.Count_And_Get

9849:
9850: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9851: ROLLBACK TO VALIDATE_DET_COMMON_GRP;
9852: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9853: FND_MSG_PUB.Count_And_Get
9854: (
9855: p_count => x_msg_count,
9856: p_data => x_msg_data,
9857: p_encoded => FND_API.G_FALSE

Line 9868: FND_MSG_PUB.Count_And_Get

9864: END IF;
9865:
9866: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
9867: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
9868: FND_MSG_PUB.Count_And_Get
9869: (
9870: p_count => x_msg_count,
9871: p_data => x_msg_data,
9872: p_encoded => FND_API.G_FALSE

Line 9885: FND_MSG_PUB.Count_And_Get

9881: ROLLBACK TO VALIDATE_DET_COMMON_GRP;
9882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9883: wsh_util_core.add_message(x_return_status, l_module_name);
9884: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Validate_Detail_Common');
9885: FND_MSG_PUB.Count_And_Get
9886: (
9887: p_count => x_msg_count,
9888: p_data => x_msg_data,
9889: p_encoded => FND_API.G_FALSE

Line 10127: FND_MSG_PUB.initialize;

10123: --
10124: --
10125: IF FND_API.to_Boolean( p_init_msg_list )
10126: THEN
10127: FND_MSG_PUB.initialize;
10128: END IF;
10129: --
10130: --
10131: -- Initialize API return status to success

Line 10610: FND_MSG_PUB.Count_And_Get

10606: --}
10607: END IF;
10608:
10609: --bug 4070732
10610: FND_MSG_PUB.Count_And_Get
10611: (
10612: p_count => x_msg_count,
10613: p_data => x_msg_data,
10614: p_encoded => FND_API.G_FALSE

Line 10655: FND_MSG_PUB.Count_And_Get

10651: END IF;
10652: --
10653: -- End of Code Bugfix 4070732
10654: --
10655: FND_MSG_PUB.Count_And_Get
10656: (
10657: p_count => x_msg_count,
10658: p_data => x_msg_data,
10659: p_encoded => FND_API.G_FALSE

Line 10698: FND_MSG_PUB.Count_And_Get

10694: END IF;
10695: --
10696: -- End of Code Bugfix 4070732
10697: --
10698: FND_MSG_PUB.Count_And_Get
10699: (
10700: p_count => x_msg_count,
10701: p_data => x_msg_data,
10702: p_encoded => FND_API.G_FALSE

Line 10746: FND_MSG_PUB.Count_And_Get

10742: END IF;
10743: --
10744: -- End of Code Bugfix 4070732
10745: --
10746: FND_MSG_PUB.Count_And_Get
10747: (
10748: p_count => x_msg_count,
10749: p_data => x_msg_data,
10750: p_encoded => FND_API.G_FALSE

Line 10805: FND_MSG_PUB.Count_And_Get

10801: END IF;
10802: --
10803: -- End of Code Bugfix 4070732
10804: --
10805: FND_MSG_PUB.Count_And_Get
10806: (
10807: p_count => x_msg_count,
10808: p_data => x_msg_data,
10809: p_encoded => FND_API.G_FALSE

Line 10849: FND_MSG_PUB.Count_And_Get

10845: END IF;
10846: --
10847: -- End of Code Bugfix 4070732
10848: --
10849: FND_MSG_PUB.Count_And_Get
10850: (
10851: p_count => x_msg_count,
10852: p_data => x_msg_data,
10853: p_encoded => FND_API.G_FALSE