eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_DELIVERY_DETAILS_GRP dependencies on FND_MSG_PUB

Line 285: fnd_msg_pub.initialize;

281: END IF;
282:
283: -- Check p_init_msg_list
284: IF fnd_api.to_boolean(p_init_msg_list) THEN
285: fnd_msg_pub.initialize;
286: END IF;
287:
288: x_return_status := wsh_util_core.g_ret_sts_success;
289:

Line 481: fnd_msg_pub.count_and_get(

477:
478: RAISE wsh_util_core.g_exc_warning;
479: END IF;
480:
481: fnd_msg_pub.count_and_get(
482: p_count => x_msg_count,
483: p_data => x_msg_data,
484: p_encoded => fnd_api.g_false);
485:

Line 499: fnd_msg_pub.count_and_get(

495: EXCEPTION
496: WHEN fnd_api.g_exc_error THEN
497: ROLLBACK TO detail_to_delivery_grp;
498: x_return_status := fnd_api.g_ret_sts_error;
499: fnd_msg_pub.count_and_get(
500: p_count => x_msg_count,
501: p_data => x_msg_data,
502: p_encoded => fnd_api.g_false);
503:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 821: fnd_msg_pub.initialize;

817: END IF;
818:
819: -- Check p_init_msg_list
820: IF fnd_api.to_boolean(p_init_msg_list) THEN
821: fnd_msg_pub.initialize;
822: END IF;
823:
824: x_return_status := wsh_util_core.g_ret_sts_success;
825: --

Line 942: fnd_msg_pub.count_and_get(

938:
939: RAISE wsh_util_core.g_exc_warning;
940: END IF;
941:
942: fnd_msg_pub.count_and_get(
943: p_count => x_msg_count,
944: p_data => x_msg_data,
945: p_encoded => fnd_api.g_false);
946:

Line 957: fnd_msg_pub.count_and_get(

953: EXCEPTION
954: WHEN fnd_api.g_exc_error THEN
955: ROLLBACK TO split_line_grp;
956: x_return_status := fnd_api.g_ret_sts_error;
957: fnd_msg_pub.count_and_get(
958: p_count => x_msg_count,
959: p_data => x_msg_data,
960: p_encoded => fnd_api.g_false);
961:

Line 971: fnd_msg_pub.count_and_get(

967: --
968: WHEN fnd_api.g_exc_unexpected_error THEN
969: ROLLBACK TO split_line_grp;
970: x_return_status := fnd_api.g_ret_sts_unexp_error;
971: fnd_msg_pub.count_and_get(
972: p_count => x_msg_count,
973: p_data => x_msg_data,
974: p_encoded => fnd_api.g_false);
975:

Line 984: fnd_msg_pub.count_and_get(

980: END IF;
981: --
982: WHEN wsh_util_core.g_exc_warning THEN
983: x_return_status := wsh_util_core.g_ret_sts_warning;
984: fnd_msg_pub.count_and_get(
985: p_count => x_msg_count,
986: p_data => x_msg_data,
987: p_encoded => fnd_api.g_false);
988:

Line 1005: fnd_msg_pub.count_and_get(

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

Line 1021: fnd_msg_pub.count_and_get(

1017: x_return_status := wsh_util_core.g_ret_sts_error;
1018: fnd_message.set_name('WSH', 'WSH_DET_SPLIT_EXCEED');
1019: wsh_util_core.add_message(x_return_status);
1020:
1021: fnd_msg_pub.count_and_get(
1022: p_count => x_msg_count,
1023: p_data => x_msg_data,
1024: p_encoded => fnd_api.g_false);
1025:

Line 1037: fnd_msg_pub.count_and_get(

1033: x_return_status := wsh_util_core.g_ret_sts_error;
1034: fnd_message.set_name('WSH', 'WSH_PUB_INVALID_SPLIT_QTY');
1035: wsh_util_core.add_message(x_return_status);
1036:
1037: fnd_msg_pub.count_and_get(
1038: p_count => x_msg_count,
1039: p_data => x_msg_data,
1040: p_encoded => fnd_api.g_false);
1041:

Line 1053: fnd_msg_pub.count_and_get(

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

Line 1185: FND_MSG_PUB.initialize;

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

Line 1403: FND_MSG_PUB.Count_And_Get

1399: COMMIT WORK;
1400: END IF;
1401:
1402: x_return_status := FND_API.G_RET_STS_SUCCESS;
1403: FND_MSG_PUB.Count_And_Get
1404: ( p_count => x_msg_count,
1405: p_data => x_msg_data,
1406: p_encoded => FND_API.G_FALSE
1407: );

Line 1421: FND_MSG_PUB.Count_And_Get

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

Line 1439: FND_MSG_PUB.Count_And_Get

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

Line 1460: FND_MSG_PUB.Count_And_Get

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

Line 1476: FND_MSG_PUB.Count_And_Get

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

Line 1496: FND_MSG_PUB.Count_And_Get

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

Line 1672: FND_MSG_PUB.initialize;

1668: END IF;
1669:
1670: -- Check p_init_msg_list
1671: IF FND_API.to_boolean(p_init_msg_list) THEN
1672: FND_MSG_PUB.initialize;
1673: END IF;
1674: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1675:
1676: IF l_debug_on THEN

Line 1787: FND_MSG_PUB.Count_And_Get

1783: END IF;
1784:
1785: --bug 4070732
1786: --
1787: FND_MSG_PUB.Count_And_Get
1788: (
1789: p_count => x_msg_count,
1790: p_data => x_msg_data,
1791: p_encoded => FND_API.G_FALSE

Line 1833: FND_MSG_PUB.Count_And_Get

1829: END IF;
1830: --
1831: -- End of Code Bugfix 4070732
1832: --
1833: FND_MSG_PUB.Count_And_Get
1834: (
1835: p_count => x_msg_count,
1836: p_data => x_msg_data,
1837: p_encoded => FND_API.G_FALSE

Line 1881: FND_MSG_PUB.Count_And_Get

1877: --
1878: -- End of Code Bugfix 4070732
1879: --
1880:
1881: FND_MSG_PUB.Count_And_Get
1882: (
1883: p_count => x_msg_count,
1884: p_data => x_msg_data,
1885: p_encoded => FND_API.G_FALSE

Line 1929: FND_MSG_PUB.Count_And_Get

1925: --
1926: -- End of Code Bugfix 4070732
1927: --
1928:
1929: FND_MSG_PUB.Count_And_Get
1930: (
1931: p_count => x_msg_count,
1932: p_data => x_msg_data,
1933: p_encoded => FND_API.G_FALSE

Line 1967: FND_MSG_PUB.Count_And_Get

1963: END IF;
1964: --
1965: -- End of code for Bugfix 4070732
1966: --
1967: FND_MSG_PUB.Count_And_Get
1968: (
1969: p_count => x_msg_count,
1970: p_data => x_msg_data,
1971: p_encoded => FND_API.G_FALSE

Line 2006: FND_MSG_PUB.Count_And_Get

2002: END IF;
2003: --
2004: -- End of code for Bugfix 4070732
2005: --
2006: FND_MSG_PUB.Count_And_Get
2007: (
2008: p_count => x_msg_count,
2009: p_data => x_msg_data,
2010: p_encoded => FND_API.G_FALSE

Line 2080: FND_MSG_PUB.initialize;

2076: END IF;
2077:
2078: -- Check p_init_msg_list
2079: IF FND_API.to_boolean(p_init_msg_list) THEN
2080: FND_MSG_PUB.initialize;
2081: END IF;
2082: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2083:
2084: IF l_debug_on THEN

Line 2111: FND_MSG_PUB.Count_And_Get

2107: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
2108: END IF;
2109:
2110:
2111: FND_MSG_PUB.Count_And_Get
2112: (
2113: p_count => x_msg_count,
2114: p_data => x_msg_data,
2115: p_encoded => FND_API.G_FALSE

Line 2132: FND_MSG_PUB.Count_And_Get

2128: EXCEPTION
2129: WHEN FND_API.G_EXC_ERROR THEN
2130: ROLLBACK TO AUTOCREATE_TRIP_GRP;
2131: x_return_status := FND_API.G_RET_STS_ERROR ;
2132: FND_MSG_PUB.Count_And_Get
2133: (
2134: p_count => x_msg_count,
2135: p_data => x_msg_data,
2136: p_encoded => FND_API.G_FALSE

Line 2148: FND_MSG_PUB.Count_And_Get

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

Line 2161: FND_MSG_PUB.Count_And_Get

2157: END IF;
2158: --
2159: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2160: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2161: FND_MSG_PUB.Count_And_Get
2162: (
2163: p_count => x_msg_count,
2164: p_data => x_msg_data,
2165: p_encoded => FND_API.G_FALSE

Line 2176: FND_MSG_PUB.Count_And_Get

2172: --
2173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2174: ROLLBACK TO AUTOCREATE_TRIP_GRP;
2175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2176: FND_MSG_PUB.Count_And_Get
2177: (
2178: p_count => x_msg_count,
2179: p_data => x_msg_data,
2180: p_encoded => FND_API.G_FALSE

Line 2194: FND_MSG_PUB.Count_And_Get

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

Line 2513: FND_MSG_PUB.initialize;

2509: -- Initialize message list if p_init_msg_list is set to TRUE.
2510: --
2511: IF FND_API.to_Boolean( p_init_msg_list )
2512: THEN
2513: FND_MSG_PUB.initialize;
2514: ELSE
2515: IF nvl(l_check_dcp, -99) IN (1,2) THEN
2516: WSH_DCP_PVT.G_INIT_MSG_COUNT := fnd_msg_pub.count_msg;
2517: END IF;

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

2512: THEN
2513: FND_MSG_PUB.initialize;
2514: ELSE
2515: IF nvl(l_check_dcp, -99) IN (1,2) THEN
2516: WSH_DCP_PVT.G_INIT_MSG_COUNT := fnd_msg_pub.count_msg;
2517: END IF;
2518: END IF;
2519: --
2520: -- Initialize API return status to success

Line 4342: FND_MSG_PUB.Count_And_Get

4338:
4339: x_return_status := l1_return_status;
4340: --bug 4070732
4341:
4342: FND_MSG_PUB.Count_And_Get
4343: (
4344: p_count => x_msg_count,
4345: p_data => x_msg_data,
4346: p_encoded => FND_API.G_FALSE

Line 4421: FND_MSG_PUB.Count_And_Get

4417: END IF;
4418: --
4419: -- End of Code Bugfix 4070732
4420: --
4421: FND_MSG_PUB.Count_And_Get
4422: (
4423: p_count => x_msg_count,
4424: p_data => x_msg_data,
4425: p_encoded => FND_API.G_FALSE

Line 4495: FND_MSG_PUB.Count_And_Get

4491: END IF;
4492: --
4493: -- End of Code Bugfix 4070732
4494: --
4495: FND_MSG_PUB.Count_And_Get
4496: (
4497: p_count => x_msg_count,
4498: p_data => x_msg_data,
4499: p_encoded => FND_API.G_FALSE

Line 4576: FND_MSG_PUB.Count_And_Get

4572: END IF;
4573: --
4574: -- End of Code Bugfix 4070732
4575: --
4576: FND_MSG_PUB.Count_And_Get
4577: (
4578: p_count => x_msg_count,
4579: p_data => x_msg_data,
4580: p_encoded => FND_API.G_FALSE

Line 4653: FND_MSG_PUB.Count_And_Get

4649: END IF;
4650: --
4651: -- End of Code Bugfix 4070732
4652: --
4653: FND_MSG_PUB.Count_And_Get
4654: (
4655: p_count => x_msg_count,
4656: p_data => x_msg_data,
4657: p_encoded => FND_API.G_FALSE

Line 4767: FND_MSG_PUB.initialize;

4763:
4764: -- Initialize message list if p_init_msg_list is set to TRUE.
4765: IF FND_API.to_Boolean( p_init_msg_list )
4766: THEN
4767: FND_MSG_PUB.initialize;
4768: END IF;
4769:
4770: -- Initialize API return status to success
4771: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 4811: FND_MSG_PUB.Count_And_Get

4807: END IF;
4808: COMMIT WORK;
4809: END IF;
4810:
4811: FND_MSG_PUB.Count_And_Get
4812: (
4813: p_count => x_msg_count,
4814: p_data => x_msg_data,
4815: p_encoded => FND_API.G_FALSE

Line 4826: FND_MSG_PUB.Count_And_Get

4822: EXCEPTION
4823: WHEN FND_API.G_EXC_ERROR THEN
4824: ROLLBACK TO CREATE_UPDATE_DEL_DETAIL_GRP;
4825: x_return_status := FND_API.G_RET_STS_ERROR ;
4826: FND_MSG_PUB.Count_And_Get
4827: (
4828: p_count => x_msg_count,
4829: p_data => x_msg_data,
4830: p_encoded => FND_API.G_FALSE

Line 4841: FND_MSG_PUB.Count_And_Get

4837: --
4838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4839: ROLLBACK TO CREATE_UPDATE_DEL_DETAIL_GRP;
4840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4841: FND_MSG_PUB.Count_And_Get
4842: (
4843: p_count => x_msg_count,
4844: p_data => x_msg_data,
4845: p_encoded => FND_API.G_FALSE

Line 4856: FND_MSG_PUB.Count_And_Get

4852: END IF;
4853: --
4854: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
4855: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4856: FND_MSG_PUB.Count_And_Get
4857: (
4858: p_count => x_msg_count,
4859: p_data => x_msg_data,
4860: p_encoded => FND_API.G_FALSE

Line 4872: FND_MSG_PUB.Count_And_Get

4868: WHEN mark_reprice_error then
4869: FND_MESSAGE.Set_Name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
4870: wsh_util_core.add_message(x_return_status, l_module_name);
4871: x_return_status := l_return_status;
4872: FND_MSG_PUB.Count_And_Get
4873: (
4874: p_count => x_msg_count,
4875: p_data => x_msg_data,
4876: p_encoded => FND_API.G_FALSE

Line 4891: FND_MSG_PUB.Count_And_Get

4887: ROLLBACK TO CREATE_UPDATE_DEL_DETAIL_GRP;
4888: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4889: wsh_util_core.add_message(x_return_status, l_module_name);
4890: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Create_Update_Delivery_Detail');
4891: FND_MSG_PUB.Count_And_Get
4892: (
4893: p_count => x_msg_count,
4894: p_data => x_msg_data,
4895: p_encoded => FND_API.G_FALSE

Line 6017: FND_MSG_PUB.Count_And_Get

6013: END IF;
6014: END IF;
6015: --END OTM R12
6016: END IF; --}
6017: FND_MSG_PUB.Count_And_Get
6018: (
6019: p_count => x_msg_count,
6020: p_data => x_msg_data,
6021: p_encoded => FND_API.G_FALSE

Line 6034: FND_MSG_PUB.Count_And_Get

6030: EXCEPTION
6031: WHEN FND_API.G_EXC_ERROR THEN
6032: ROLLBACK to CREATE_DEL_DETAIL_GRP;
6033: x_return_status := FND_API.G_RET_STS_ERROR ;
6034: FND_MSG_PUB.Count_And_Get
6035: (
6036: p_count => x_msg_count,
6037: p_data => x_msg_data,
6038: p_encoded => FND_API.G_FALSE

Line 6049: FND_MSG_PUB.Count_And_Get

6045: --
6046: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6047: ROLLBACK to CREATE_DEL_DETAIL_GRP;
6048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6049: FND_MSG_PUB.Count_And_Get
6050: (
6051: p_count => x_msg_count,
6052: p_data => x_msg_data,
6053: p_encoded => FND_API.G_FALSE

Line 6063: FND_MSG_PUB.Count_And_Get

6059: END IF;
6060: --
6061: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
6062: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6063: FND_MSG_PUB.Count_And_Get
6064: (
6065: p_count => x_msg_count,
6066: p_data => x_msg_data,
6067: p_encoded => FND_API.G_FALSE

Line 6081: FND_MSG_PUB.Count_And_Get

6077: ROLLBACK to CREATE_DEL_DETAIL_GRP;
6078: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6079: wsh_util_core.add_message(x_return_status, l_module_name);
6080: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Create_Delivery_Detail');
6081: FND_MSG_PUB.Count_And_Get
6082: (
6083: p_count => x_msg_count,
6084: p_data => x_msg_data,
6085: p_encoded => FND_API.G_FALSE

Line 6785: FND_MSG_PUB.Count_And_Get

6781: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
6782: END IF;
6783: END IF;
6784:
6785: FND_MSG_PUB.Count_And_Get
6786: (
6787: p_count => x_msg_count,
6788: p_data => x_msg_data,
6789: p_encoded => FND_API.G_FALSE

Line 6800: FND_MSG_PUB.Count_And_Get

6796: EXCEPTION
6797: WHEN FND_API.G_EXC_ERROR THEN
6798: ROLLBACK to VALIDATE_DEL_DETAIL_GRP;
6799: x_return_status := FND_API.G_RET_STS_ERROR ;
6800: FND_MSG_PUB.Count_And_Get
6801: (
6802: p_count => x_msg_count,
6803: p_data => x_msg_data,
6804: p_encoded => FND_API.G_FALSE

Line 6816: FND_MSG_PUB.Count_And_Get

6812: --
6813: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6814: ROLLBACK to VALIDATE_DEL_DETAIL_GRP;
6815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6816: FND_MSG_PUB.Count_And_Get
6817: (
6818: p_count => x_msg_count,
6819: p_data => x_msg_data,
6820: p_encoded => FND_API.G_FALSE

Line 6831: FND_MSG_PUB.Count_And_Get

6827: --
6828: --
6829: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
6830: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6831: FND_MSG_PUB.Count_And_Get
6832: (
6833: p_count => x_msg_count,
6834: p_data => x_msg_data,
6835: p_encoded => FND_API.G_FALSE

Line 6852: FND_MSG_PUB.Count_And_Get

6848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6849: wsh_util_core.add_message(x_return_status, l_module_name);
6850: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Validate_Delivery_Detail');
6851:
6852: FND_MSG_PUB.Count_And_Get
6853: (
6854: p_count => x_msg_count,
6855: p_data => x_msg_data,
6856: p_encoded => FND_API.G_FALSE

Line 7014: FND_MSG_PUB.Count_And_Get

7010:
7011: END IF;
7012: --} lpn conv
7013:
7014: FND_MSG_PUB.Count_And_Get
7015: (
7016: p_count => x_msg_count,
7017: p_data => x_msg_data,
7018: p_encoded => FND_API.G_FALSE

Line 7032: FND_MSG_PUB.Count_And_Get

7028: ROLLBACK to UPDATE_DEL_DETAIL_GRP;
7029: x_return_status := FND_API.G_RET_STS_ERROR ;
7030: WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED := 'Y';
7031: WSH_WMS_LPN_GRP.g_update_to_container := 'N';
7032: FND_MSG_PUB.Count_And_Get
7033: (
7034: p_count => x_msg_count,
7035: p_data => x_msg_data,
7036: p_encoded => FND_API.G_FALSE

Line 7053: FND_MSG_PUB.Count_And_Get

7049: ROLLBACK to UPDATE_DEL_DETAIL_GRP;
7050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7051: WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED := 'Y';
7052: WSH_WMS_LPN_GRP.g_update_to_container := 'N';
7053: FND_MSG_PUB.Count_And_Get
7054: (
7055: p_count => x_msg_count,
7056: p_data => x_msg_data,
7057: p_encoded => FND_API.G_FALSE

Line 7105: FND_MSG_PUB.Count_And_Get

7101: -- K LPN CONV. rv
7102: --
7103: WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED := 'Y';
7104: WSH_WMS_LPN_GRP.g_update_to_container := 'N';
7105: FND_MSG_PUB.Count_And_Get
7106: (
7107: p_count => x_msg_count,
7108: p_data => x_msg_data,
7109: p_encoded => FND_API.G_FALSE

Line 7174: FND_MSG_PUB.Count_And_Get

7170: WSH_WMS_LPN_GRP.g_update_to_container := 'N';
7171: wsh_util_core.add_message(x_return_status, l_module_name);
7172: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Update_Delivery_Detail');
7173:
7174: FND_MSG_PUB.Count_And_Get
7175: (
7176: p_count => x_msg_count,
7177: p_data => x_msg_data,
7178: p_encoded => FND_API.G_FALSE

Line 7314: FND_MSG_PUB.Count_And_Get

7310: END IF;
7311:
7312:
7313:
7314: FND_MSG_PUB.Count_And_Get
7315: (
7316: p_count => x_msg_count,
7317: p_data => x_msg_data,
7318: p_encoded => FND_API.G_FALSE

Line 7334: FND_MSG_PUB.Count_And_Get

7330: EXCEPTION
7331: WHEN FND_API.G_EXC_ERROR THEN
7332: ROLLBACK to CANCEL_DEL_DETAIL_GRP;
7333: x_return_status := FND_API.G_RET_STS_ERROR ;
7334: FND_MSG_PUB.Count_And_Get
7335: (
7336: p_count => x_msg_count,
7337: p_data => x_msg_data,
7338: p_encoded => FND_API.G_FALSE

Line 7349: FND_MSG_PUB.Count_And_Get

7345: --
7346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7347: ROLLBACK to CANCEL_DEL_DETAIL_GRP;
7348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7349: FND_MSG_PUB.Count_And_Get
7350: (
7351: p_count => x_msg_count,
7352: p_data => x_msg_data,
7353: p_encoded => FND_API.G_FALSE

Line 7363: FND_MSG_PUB.Count_And_Get

7359: END IF;
7360: --
7361: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
7362: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7363: FND_MSG_PUB.Count_And_Get
7364: (
7365: p_count => x_msg_count,
7366: p_data => x_msg_data,
7367: p_encoded => FND_API.G_FALSE

Line 7381: FND_MSG_PUB.Count_And_Get

7377: ROLLBACK to CANCEL_DEL_DETAIL_GRP;
7378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7379: wsh_util_core.add_message(x_return_status, l_module_name);
7380: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Delete_Delivery_Detail');
7381: FND_MSG_PUB.Count_And_Get
7382: (
7383: p_count => x_msg_count,
7384: p_data => x_msg_data,
7385: p_encoded => FND_API.G_FALSE

Line 9164: fnd_msg_pub.count_and_get(

9160: WSH_DEBUG_SV.log(l_module_name, 'to_serial_number', x_detail_rec.to_serial_number);
9161: END IF;
9162: END IF; -- if check for validation level
9163:
9164: fnd_msg_pub.count_and_get(
9165: p_count => x_msg_count,
9166: p_data => x_msg_data,
9167: p_encoded => fnd_api.g_false);
9168:

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

9173: EXCEPTION
9174: WHEN fnd_api.g_exc_error THEN
9175: ROLLBACK TO validate_det_line_grp;
9176: x_return_status := fnd_api.g_ret_sts_error;
9177: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
9178: p_encoded => fnd_api.g_false);
9179:
9180: --
9181: IF l_debug_on THEN

Line 9189: fnd_msg_pub.count_and_get(

9185: --
9186: WHEN fnd_api.g_exc_unexpected_error THEN
9187: ROLLBACK TO validate_det_line_grp;
9188: x_return_status := fnd_api.g_ret_sts_unexp_error;
9189: fnd_msg_pub.count_and_get(
9190: p_count => x_msg_count,
9191: p_data => x_msg_data,
9192: p_encoded => fnd_api.g_false);
9193:

Line 9203: fnd_msg_pub.count_and_get(

9199: END IF;
9200: --
9201: WHEN wsh_util_core.g_exc_warning THEN
9202: x_return_status := wsh_util_core.g_ret_sts_warning;
9203: fnd_msg_pub.count_and_get(
9204: p_count => x_msg_count,
9205: p_data => x_msg_data,
9206: p_encoded => fnd_api.g_false);
9207:

Line 9222: fnd_msg_pub.count_and_get(

9218: ROLLBACK TO validate_det_line_grp;
9219: x_return_status := fnd_api.g_ret_sts_unexp_error;
9220: wsh_util_core.add_message(x_return_status, l_module_name);
9221: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_GRP.Validate_Detail_Line');
9222: fnd_msg_pub.count_and_get(
9223: p_count => x_msg_count,
9224: p_data => x_msg_data,
9225: p_encoded => fnd_api.g_false);
9226:

Line 9349: FND_MSG_PUB.Count_And_Get

9345: END IF;
9346: END IF;
9347: END IF;
9348: --
9349: FND_MSG_PUB.Count_And_Get
9350: (
9351: p_count => x_msg_count,
9352: p_data => x_msg_data,
9353: p_encoded => FND_API.G_FALSE

Line 9366: FND_MSG_PUB.Count_And_Get

9362: ROLLBACK TO VALIDATE_DET_CONTAINER_GRP;
9363: x_return_status := FND_API.G_RET_STS_ERROR ;
9364: FND_MESSAGE.SET_NAME('WSH', 'WSH_INVALID_DELIVERED_QTY');
9365: WSH_UTIL_CORE.ADD_MESSAGE(wsh_util_core.g_ret_sts_error, l_module_name);
9366: FND_MSG_PUB.Count_And_Get
9367: (
9368: p_count => x_msg_count,
9369: p_data => x_msg_data,
9370: p_encoded => FND_API.G_FALSE

Line 9381: FND_MSG_PUB.Count_And_Get

9377:
9378: WHEN FND_API.G_EXC_ERROR THEN
9379: ROLLBACK TO VALIDATE_DET_CONTAINER_GRP;
9380: x_return_status := FND_API.G_RET_STS_ERROR ;
9381: FND_MSG_PUB.Count_And_Get
9382: (
9383: p_count => x_msg_count,
9384: p_data => x_msg_data,
9385: p_encoded => FND_API.G_FALSE

Line 9397: FND_MSG_PUB.Count_And_Get

9393:
9394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9395: ROLLBACK TO VALIDATE_DET_CONTAINER_GRP;
9396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9397: FND_MSG_PUB.Count_And_Get
9398: (
9399: p_count => x_msg_count,
9400: p_data => x_msg_data,
9401: p_encoded => FND_API.G_FALSE

Line 9412: FND_MSG_PUB.Count_And_Get

9408: END IF;
9409: --
9410: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
9411: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
9412: FND_MSG_PUB.Count_And_Get
9413: (
9414: p_count => x_msg_count,
9415: p_data => x_msg_data,
9416: p_encoded => FND_API.G_FALSE

Line 9429: FND_MSG_PUB.Count_And_Get

9425: ROLLBACK TO VALIDATE_DET_CONTAINER_GRP;
9426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9427: wsh_util_core.add_message(x_return_status, l_module_name);
9428: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Validate_Detail_Container');
9429: FND_MSG_PUB.Count_And_Get
9430: (
9431: p_count => x_msg_count,
9432: p_data => x_msg_data,
9433: p_encoded => FND_API.G_FALSE

Line 9703: FND_MSG_PUB.Count_And_Get

9699: --}
9700:
9701:
9702:
9703: FND_MSG_PUB.Count_And_Get
9704: (
9705: p_count => x_msg_count,
9706: p_data => x_msg_data,
9707: p_encoded => FND_API.G_FALSE

Line 9718: FND_MSG_PUB.Count_And_Get

9714: EXCEPTION
9715: WHEN FND_API.G_EXC_ERROR THEN
9716: ROLLBACK TO VALIDATE_DET_COMMON_GRP;
9717: x_return_status := FND_API.G_RET_STS_ERROR ;
9718: FND_MSG_PUB.Count_And_Get
9719: (
9720: p_count => x_msg_count,
9721: p_data => x_msg_data,
9722: p_encoded => FND_API.G_FALSE

Line 9733: FND_MSG_PUB.Count_And_Get

9729:
9730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9731: ROLLBACK TO VALIDATE_DET_COMMON_GRP;
9732: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9733: FND_MSG_PUB.Count_And_Get
9734: (
9735: p_count => x_msg_count,
9736: p_data => x_msg_data,
9737: p_encoded => FND_API.G_FALSE

Line 9748: FND_MSG_PUB.Count_And_Get

9744: END IF;
9745:
9746: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
9747: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
9748: FND_MSG_PUB.Count_And_Get
9749: (
9750: p_count => x_msg_count,
9751: p_data => x_msg_data,
9752: p_encoded => FND_API.G_FALSE

Line 9765: FND_MSG_PUB.Count_And_Get

9761: ROLLBACK TO VALIDATE_DET_COMMON_GRP;
9762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9763: wsh_util_core.add_message(x_return_status, l_module_name);
9764: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Validate_Detail_Common');
9765: FND_MSG_PUB.Count_And_Get
9766: (
9767: p_count => x_msg_count,
9768: p_data => x_msg_data,
9769: p_encoded => FND_API.G_FALSE

Line 10007: FND_MSG_PUB.initialize;

10003: --
10004: --
10005: IF FND_API.to_Boolean( p_init_msg_list )
10006: THEN
10007: FND_MSG_PUB.initialize;
10008: END IF;
10009: --
10010: --
10011: -- Initialize API return status to success

Line 10490: FND_MSG_PUB.Count_And_Get

10486: --}
10487: END IF;
10488:
10489: --bug 4070732
10490: FND_MSG_PUB.Count_And_Get
10491: (
10492: p_count => x_msg_count,
10493: p_data => x_msg_data,
10494: p_encoded => FND_API.G_FALSE

Line 10535: FND_MSG_PUB.Count_And_Get

10531: END IF;
10532: --
10533: -- End of Code Bugfix 4070732
10534: --
10535: FND_MSG_PUB.Count_And_Get
10536: (
10537: p_count => x_msg_count,
10538: p_data => x_msg_data,
10539: p_encoded => FND_API.G_FALSE

Line 10578: FND_MSG_PUB.Count_And_Get

10574: END IF;
10575: --
10576: -- End of Code Bugfix 4070732
10577: --
10578: FND_MSG_PUB.Count_And_Get
10579: (
10580: p_count => x_msg_count,
10581: p_data => x_msg_data,
10582: p_encoded => FND_API.G_FALSE

Line 10626: FND_MSG_PUB.Count_And_Get

10622: END IF;
10623: --
10624: -- End of Code Bugfix 4070732
10625: --
10626: FND_MSG_PUB.Count_And_Get
10627: (
10628: p_count => x_msg_count,
10629: p_data => x_msg_data,
10630: p_encoded => FND_API.G_FALSE

Line 10685: FND_MSG_PUB.Count_And_Get

10681: END IF;
10682: --
10683: -- End of Code Bugfix 4070732
10684: --
10685: FND_MSG_PUB.Count_And_Get
10686: (
10687: p_count => x_msg_count,
10688: p_data => x_msg_data,
10689: p_encoded => FND_API.G_FALSE

Line 10729: FND_MSG_PUB.Count_And_Get

10725: END IF;
10726: --
10727: -- End of Code Bugfix 4070732
10728: --
10729: FND_MSG_PUB.Count_And_Get
10730: (
10731: p_count => x_msg_count,
10732: p_data => x_msg_data,
10733: p_encoded => FND_API.G_FALSE