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_SHIPMENT_ADVICE_PUB dependencies on WSH_UTIL_CORE

Line 59: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

55: END IF;
56: IF FND_API.to_Boolean(p_init_msg_list) THEN
57: FND_MSG_PUB.initialize;
58: END IF;
59: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
60: IF NOT FND_API.Compatible_API_Call
61: ( l_api_version_number
62: , p_api_version_number
63: , l_api_name

Line 77: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

73: END IF;
74: Create_Shipment_Advice(
75: p_delivery_rec => p_delivery_rec,
76: x_return_status => l_return_status);
77: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
78: RAISE FND_API.G_EXC_ERROR;
79: END IF;
80: IF p_commit = FND_API.G_TRUE THEN
81: COMMIT;

Line 84: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

80: IF p_commit = FND_API.G_TRUE THEN
81: COMMIT;
82: END IF;
83: ELSE
84: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
85: fnd_message.set_name('WSH', 'WSH_PUB_INVALID_ACTION');
86: fnd_message.set_token('ACTION_CODE', p_action);
87: wsh_util_core.add_message(x_return_status);
88: IF l_debug_on THEN

Line 87: wsh_util_core.add_message(x_return_status);

83: ELSE
84: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
85: fnd_message.set_name('WSH', 'WSH_PUB_INVALID_ACTION');
86: fnd_message.set_token('ACTION_CODE', p_action);
87: wsh_util_core.add_message(x_return_status);
88: IF l_debug_on THEN
89: WSH_DEBUG_SV.log(l_module_name, 'p_action_code should be CREATE.The current value is',p_action);
90: END IF;
91: RAISE FND_API.G_EXC_ERROR;

Line 100: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

96: END IF;
97:
98: EXCEPTION
99: WHEN FND_API.G_EXC_ERROR THEN
100: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
101: IF l_debug_on THEN
102: WSH_DEBUG_SV.logmsg(l_module_name,'Rolling back the transactions');
103: END IF;
104: rollback;

Line 112: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

108: IF l_debug_on THEN
109: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
110: END IF;
111: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
112: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
113: IF l_debug_on THEN
114: WSH_DEBUG_SV.logmsg(l_module_name,'Rolling back the transactions');
115: END IF;
116: rollback;

Line 125: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

121: IF l_debug_on THEN
122: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
123: END IF;
124: WHEN OTHERS THEN
125: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
126: IF l_debug_on THEN
127: WSH_DEBUG_SV.logmsg(l_module_name,'Rolling back the transactions');
128: END IF;
129: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 163: l_wdai_del_interface_id WSH_UTIL_CORE.ID_TAB_TYPE;

159: l_pickup_stop_interface_id NUMBER;
160: l_dropoff_stop_interface_id NUMBER;
161: l_trip_interface_id NUMBER;
162: l_del_assgn_cnt NUMBER :=0;
163: l_wdai_del_interface_id WSH_UTIL_CORE.ID_TAB_TYPE;
164: l_wdai_del_det_interface_id WSH_UTIL_CORE.ID_TAB_TYPE;
165: l_wdai_del_detail_id WSH_UTIL_CORE.ID_TAB_TYPE;
166: l_wdai_parent_del_detail_id WSH_UTIL_CORE.ID_TAB_TYPE;
167: --

Line 164: l_wdai_del_det_interface_id WSH_UTIL_CORE.ID_TAB_TYPE;

160: l_dropoff_stop_interface_id NUMBER;
161: l_trip_interface_id NUMBER;
162: l_del_assgn_cnt NUMBER :=0;
163: l_wdai_del_interface_id WSH_UTIL_CORE.ID_TAB_TYPE;
164: l_wdai_del_det_interface_id WSH_UTIL_CORE.ID_TAB_TYPE;
165: l_wdai_del_detail_id WSH_UTIL_CORE.ID_TAB_TYPE;
166: l_wdai_parent_del_detail_id WSH_UTIL_CORE.ID_TAB_TYPE;
167: --
168: l_return_status VARCHAR2(100);

Line 165: l_wdai_del_detail_id WSH_UTIL_CORE.ID_TAB_TYPE;

161: l_trip_interface_id NUMBER;
162: l_del_assgn_cnt NUMBER :=0;
163: l_wdai_del_interface_id WSH_UTIL_CORE.ID_TAB_TYPE;
164: l_wdai_del_det_interface_id WSH_UTIL_CORE.ID_TAB_TYPE;
165: l_wdai_del_detail_id WSH_UTIL_CORE.ID_TAB_TYPE;
166: l_wdai_parent_del_detail_id WSH_UTIL_CORE.ID_TAB_TYPE;
167: --
168: l_return_status VARCHAR2(100);
169: l_exists NUMBER;

Line 166: l_wdai_parent_del_detail_id WSH_UTIL_CORE.ID_TAB_TYPE;

162: l_del_assgn_cnt NUMBER :=0;
163: l_wdai_del_interface_id WSH_UTIL_CORE.ID_TAB_TYPE;
164: l_wdai_del_det_interface_id WSH_UTIL_CORE.ID_TAB_TYPE;
165: l_wdai_del_detail_id WSH_UTIL_CORE.ID_TAB_TYPE;
166: l_wdai_parent_del_detail_id WSH_UTIL_CORE.ID_TAB_TYPE;
167: --
168: l_return_status VARCHAR2(100);
169: l_exists NUMBER;
170: l_ins_rows NUMBER;

Line 183: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

179: --WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit Debug_Shipment_Advice', WSH_DEBUG_SV.C_PROC_LEVEL);
180: --Debug_Shipment_Advice(p_delivery_rec);
181: END IF;
182: --
183: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
184: --
185: IF p_delivery_rec.document_number IS NULL THEN
186: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
187: fnd_message.set_name('WSH', 'WSH_SA_ATTR_MANDATORY');

Line 186: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

182: --
183: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
184: --
185: IF p_delivery_rec.document_number IS NULL THEN
186: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
187: fnd_message.set_name('WSH', 'WSH_SA_ATTR_MANDATORY');
188: fnd_message.set_token('ATTRIBUTE','DOCUMENT_NUMBER ');
189: wsh_util_core.add_message(x_return_status);
190:

Line 189: wsh_util_core.add_message(x_return_status);

185: IF p_delivery_rec.document_number IS NULL THEN
186: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
187: fnd_message.set_name('WSH', 'WSH_SA_ATTR_MANDATORY');
188: fnd_message.set_token('ATTRIBUTE','DOCUMENT_NUMBER ');
189: wsh_util_core.add_message(x_return_status);
190:
191: IF l_debug_on THEN
192: WSH_DEBUG_SV.log(l_module_name, 'Mandatory input parameters have not been passed');
193: END IF;

Line 203: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

199: AND document_type = 'SA'
200: AND document_direction = 'I';
201:
202: if l_exists >0 THEN
203: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
204: fnd_message.set_name('WSH', 'WSH_SA_DUP_DOCUMENT');
205: fnd_message.set_token('DOCUMENT_NUMBER', p_delivery_rec.document_number);
206: wsh_util_core.add_message(x_return_status);
207: IF l_debug_on THEN

Line 206: wsh_util_core.add_message(x_return_status);

202: if l_exists >0 THEN
203: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
204: fnd_message.set_name('WSH', 'WSH_SA_DUP_DOCUMENT');
205: fnd_message.set_token('DOCUMENT_NUMBER', p_delivery_rec.document_number);
206: wsh_util_core.add_message(x_return_status);
207: IF l_debug_on THEN
208: wsh_debug_sv.logmsg(l_module_name, 'The document already exists');
209: END IF;
210: RAISE FND_API.G_EXC_ERROR;

Line 441: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

437: wsh_debug_sv.logmsg(l_module_name, 'Inserting Rec'||i||' into WSH_DEL_DETAILS_INTERFACE (validating source_line_id)');
438: END IF;
439: IF p_delivery_rec.delivery_details_tab(i).source_line_id IS NULL THEN
440:
441: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
442: fnd_message.set_name('WSH', 'WSH_SA_ATTR_MANDATORY');
443: fnd_message.set_token('ATTRIBUTE','LINE_NUMBER');
444: wsh_util_core.add_message(x_return_status);
445: IF l_debug_on THEN

Line 444: wsh_util_core.add_message(x_return_status);

440:
441: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
442: fnd_message.set_name('WSH', 'WSH_SA_ATTR_MANDATORY');
443: fnd_message.set_token('ATTRIBUTE','LINE_NUMBER');
444: wsh_util_core.add_message(x_return_status);
445: IF l_debug_on THEN
446: wsh_debug_sv.logmsg(l_module_name, 'Line number is a mandatory parameter for delivery_detail_interface records');
447: END IF;
448: RAISE FND_API.G_EXC_ERROR;

Line 1103: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1099: p_trip_route_id => p_delivery_rec.route_id,
1100: p_trip_routing_ins => p_delivery_rec.routing_instructions,
1101: p_operator => p_delivery_rec.operator ,
1102: x_return_status => l_return_status);
1103: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1104: RAISE FND_API.G_EXC_ERROR;
1105: END IF;
1106:
1107: INSERT INTO wsh_transactions_history (

Line 1157: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1153:
1154: EXCEPTION
1155:
1156: WHEN FND_API.G_EXC_ERROR THEN
1157: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1158: IF l_debug_on THEN
1159: WSH_DEBUG_SV.log(l_module_name, 'Error Creating Shipment advance with Document_Number',p_delivery_rec.Document_Number);
1160: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1161: END IF;

Line 1163: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1159: WSH_DEBUG_SV.log(l_module_name, 'Error Creating Shipment advance with Document_Number',p_delivery_rec.Document_Number);
1160: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1161: END IF;
1162: WHEN OTHERS THEN
1163: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1164: IF l_debug_on THEN
1165: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1166: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1167: END IF;

Line 1218: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1214: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Process_Shipmemt_Advice';
1215: --
1216:
1217: BEGIN
1218: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1219: IF l_debug_on then
1220: wsh_debug_sv.push(l_module_name);
1221: --
1222: WSH_DEBUG_SV.log(l_module_name,'p_process_mode',p_process_mode);

Line 1264: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

1260: p_to_creation_date => to_date(p_to_creation_date,'yy-mm-dd'),
1261: p_transaction_id => p_transaction_id,
1262: x_return_status => l_return_status);
1263:
1264: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1265: --
1266: IF l_debug_on THEN
1267: WSH_DEBUG_SV.logmsg(l_module_name, 'Process_Shipment_Advice completed with error');
1268: END IF;

Line 1272: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);

1268: END IF;
1269: --
1270: x_return_status := l_return_status;
1271: FND_MESSAGE.Set_Name('WSH', 'WSH_SA_PROCESS_ERROR');
1272: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
1273: raise FND_API.G_EXC_ERROR;
1274: END IF;
1275:
1276: ELSIF p_process_mode = 'CONCURRENT' THEN

Line 1305: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1301: IF (nvl(x_request_id,0) <= 0) THEN
1302: raise FND_API.G_EXC_ERROR;
1303: END IF;
1304: ELSE
1305: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1306: fnd_message.set_name('WSH', 'WSH_OI_INVALID_ATTRIBUTE');
1307: fnd_message.set_token('ATTRIBUTE', 'PROCESS_MODE');
1308: wsh_util_core.add_message(x_return_status);
1309: IF l_debug_on THEN

Line 1308: wsh_util_core.add_message(x_return_status);

1304: ELSE
1305: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1306: fnd_message.set_name('WSH', 'WSH_OI_INVALID_ATTRIBUTE');
1307: fnd_message.set_token('ATTRIBUTE', 'PROCESS_MODE');
1308: wsh_util_core.add_message(x_return_status);
1309: IF l_debug_on THEN
1310: WSH_DEBUG_SV.logmsg(l_module_name, 'p_process_mode should be ONLINE/CONCURRENT');
1311: END IF;
1312: raise FND_API.G_EXC_ERROR;

Line 1325: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1321: wsh_debug_sv.pop(l_module_name);
1322: END IF;
1323: EXCEPTION
1324: WHEN FND_API.G_EXC_ERROR THEN
1325: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1326: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1327: p_data => x_msg_data,
1328: p_encoded => fnd_api.g_false);
1329: IF l_debug_on THEN

Line 1334: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1330: WSH_DEBUG_SV.log(l_module_name, 'Error Processing Shipment Advice ');
1331: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1332: END IF;
1333: WHEN OTHERS THEN
1334: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1335: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1336: p_data => x_msg_data,
1337: p_encoded => fnd_api.g_false);
1338: IF l_debug_on THEN