68:
69: -- Initialize message list if p_init_msg_list is set to TRUE.
70: --
71: --
72: IF FND_API.to_Boolean( p_init_msg_list )
73: THEN
74: FND_MSG_PUB.initialize;
75: END IF;
76: --
787: (l_error_id, 'FTE_SHIPMEMT_STATUS_HEADERS',
788: p_transaction_id, 3, 'ERROR', 'NO CHILD DELIVERY FOUND',
789: p_carrier_id);
790:
791: x_return_status := FND_API.G_RET_STS_ERROR ;
792: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_TRACKING_INFO');
793: FND_MSG_PUB.ADD;
794: FND_MSG_PUB.Count_And_Get
795: (
794: FND_MSG_PUB.Count_And_Get
795: (
796: p_count => x_msg_count,
797: p_data => x_msg_data,
798: p_encoded => FND_API.G_FALSE
799: );
800: WHEN OTHERS THEN
801: ROLLBACK TO populate_child_legs_pub;
802: select wsh_interface_errors_s.nextval into l_error_id
813: l_exception_message :=
814: (l_sql_error_code||':'||l_sql_error_msg||' : '
815: ||' : '||l_procedure_name);
816: END IF;
817: x_return_status := FND_API.G_RET_STS_ERROR ;
818: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_TRACKING_INFO');
819: FND_MSG_PUB.ADD;
820: FND_MSG_PUB.Count_And_Get
821: (
820: FND_MSG_PUB.Count_And_Get
821: (
822: p_count => x_msg_count,
823: p_data => x_msg_data,
824: p_encoded => FND_API.G_FALSE
825: );
826: END populate_child_delivery_legs;
827:
828:
1075:
1076: -- populate child legs if any
1077: populate_child_delivery_legs
1078: (
1079: p_init_msg_list => FND_API.G_TRUE,
1080: p_delivery_leg_id => l_delivery_leg_id,
1081: p_transaction_id => p_transaction_id,
1082: p_carrier_id => l_carrier_id,
1083: x_return_status => l_return_statusp,
1166:
1167: -- populate child legs if any
1168: populate_child_delivery_legs
1169: (
1170: p_init_msg_list => FND_API.G_TRUE,
1171: p_delivery_leg_id => l_delivery_leg_id,
1172: p_transaction_id => p_transaction_id,
1173: p_carrier_id => l_carrier_id,
1174: x_return_status => l_return_statusp,
1255:
1256: -- populate child legs if any
1257: populate_child_delivery_legs
1258: (
1259: p_init_msg_list => FND_API.G_TRUE,
1260: p_delivery_leg_id => l_delivery_leg_id,
1261: p_transaction_id => p_transaction_id,
1262: p_carrier_id => l_carrier_id,
1263: x_return_status => l_return_statusp,
1322:
1323: -- populate child legs if any
1324: populate_child_delivery_legs
1325: (
1326: p_init_msg_list => FND_API.G_TRUE,
1327: p_delivery_leg_id => l_delivery_leg_id,
1328: p_transaction_id => p_transaction_id,
1329: p_carrier_id => l_carrier_id,
1330: x_return_status => l_return_statusp,
1404:
1405: -- populate child legs if any
1406: populate_child_delivery_legs
1407: (
1408: p_init_msg_list => FND_API.G_TRUE,
1409: p_delivery_leg_id => l_delivery_leg_id,
1410: p_transaction_id => p_transaction_id,
1411: p_carrier_id => l_carrier_id,
1412: x_return_status => l_return_statusp,
1505:
1506: -- populate child legs if any
1507: populate_child_delivery_legs
1508: (
1509: p_init_msg_list => FND_API.G_TRUE,
1510: p_delivery_leg_id => l_delivery_leg_id,
1511: p_transaction_id => p_transaction_id,
1512: p_carrier_id => l_carrier_id,
1513: x_return_status => l_return_statusp,
1930:
1931: BEGIN
1932:
1933: CALL_LAST_DELIVERY_LEG(p_api_version_number => 1,
1934: p_init_msg_list => FND_API.G_FALSE ,
1935: x_return_status => l_return_status,
1936: x_msg_count => l_msg_count,
1937: x_msg_data => l_msg_data,
1938: p_delivery_leg_id => p_delivery_leg_id,
2036:
2037: -- Initialize message list if p_init_msg_list is set to TRUE.
2038: --
2039: --
2040: IF FND_API.to_Boolean( p_init_msg_list )
2041: THEN
2042: FND_MSG_PUB.initialize;
2043: END IF;
2044:
2107:
2108:
2109: WSH_INTERFACE_GRP.Update_Delivery_Leg(
2110: p_api_version_number => 1.0,
2111: p_init_msg_list => FND_API.G_TRUE,
2112: p_commit => NULL,
2113: p_delivery_leg_tab => l_leg_Tab,
2114: p_in_rec => l_in_rec,
2115: x_out_rec => l_out_rec,
2156: --Do not handle the status
2157: ar_deferral_reasons_grp.record_proof_of_delivery
2158: (
2159: p_api_version => 1.0,
2160: p_init_msg_list => FND_API.G_FALSE,
2161: p_commit => FND_API.G_FALSE,
2162: p_delivery_id =>l_delivery_id,
2163: p_pod_date => p_received_date,
2164: x_return_status => l_ar_return_status,
2157: ar_deferral_reasons_grp.record_proof_of_delivery
2158: (
2159: p_api_version => 1.0,
2160: p_init_msg_list => FND_API.G_FALSE,
2161: p_commit => FND_API.G_FALSE,
2162: p_delivery_id =>l_delivery_id,
2163: p_pod_date => p_received_date,
2164: x_return_status => l_ar_return_status,
2165: x_msg_count => l_ar_msg_count,
2195:
2196:
2197: WSH_INTERFACE_GRP.Stop_Action
2198: ( p_api_version_number => p_api_version_number,
2199: p_init_msg_list => FND_API.G_FALSE,
2200: p_commit => 'F',
2201: p_entity_id_tab => p_entity_id_tab,
2202: p_action_prms => p_action_prms,
2203: x_stop_out_rec => x_stop_out_rec,
2252: IF l_debug_on THEN
2253: WSH_DEBUG_SV.pop(l_module_name);
2254: END IF;
2255: EXCEPTION
2256: WHEN FND_API.G_EXC_ERROR THEN
2257: ROLLBACK TO CALL_LAST_DELIVERY_LEG_PUB;
2258: x_return_status := FND_API.G_RET_STS_ERROR;
2259: FND_MSG_PUB.Count_And_Get
2260: (
2254: END IF;
2255: EXCEPTION
2256: WHEN FND_API.G_EXC_ERROR THEN
2257: ROLLBACK TO CALL_LAST_DELIVERY_LEG_PUB;
2258: x_return_status := FND_API.G_RET_STS_ERROR;
2259: FND_MSG_PUB.Count_And_Get
2260: (
2261: p_count => x_msg_count,
2262: p_data => x_msg_data,
2259: FND_MSG_PUB.Count_And_Get
2260: (
2261: p_count => x_msg_count,
2262: p_data => x_msg_data,
2263: p_encoded => FND_API.G_FALSE
2264: );
2265: IF l_debug_on THEN
2266: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
2267: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
2267: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
2268: WSH_DEBUG_SV.pop(l_module_name);
2269: END IF;
2270:
2271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2272: ROLLBACK TO CALL_LAST_DELIVERY_LEG_PUB;
2273: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2274: FND_MSG_PUB.Count_And_Get
2275: (
2274: FND_MSG_PUB.Count_And_Get
2275: (
2276: p_count => x_msg_count,
2277: p_data => x_msg_data,
2278: p_encoded => FND_API.G_FALSE
2279: );
2280: IF l_debug_on THEN
2281: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
2282: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
2294: FND_MSG_PUB.Count_And_Get
2295: (
2296: p_count => x_msg_count,
2297: p_data => x_msg_data,
2298: p_encoded => FND_API.G_FALSE
2299: );
2300:
2301: END call_last_delivery_leg;
2302: