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

Line 205: x_return_status := wsh_util_core.g_ret_sts_success;

201:
202: EXCEPTION
203: WHEN NO_DATA_FOUND THEN
204: --
205: x_return_status := wsh_util_core.g_ret_sts_success;
206: x_valid_doc := fnd_api.g_true;
207: --
208: WHEN TOO_MANY_ROWS THEN
209: --

Line 252: x_return_status := wsh_util_core.g_ret_sts_success;

248: END IF;
249:
250: IF (p_940_exists = 'X')
251: THEN
252: x_return_status := wsh_util_core.g_ret_sts_success;
253: x_valid_doc := fnd_api.g_true;
254: IF l_debug_on THEN
255: wsh_debug_sv.log(l_module_name, '940 Add Exists for the 940 Cancellation sent, Return Status',X_Return_Status );
256: END IF;

Line 291: x_return_status := wsh_util_core.g_ret_sts_success;

287: AND action_type = 'A';
288:
289: IF (p_940_exists = 'X')
290: THEN
291: x_return_status := wsh_util_core.g_ret_sts_success;
292: x_valid_doc := fnd_api.g_true;
293: END IF;
294: EXCEPTION
295: WHEN NO_DATA_FOUND

Line 316: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

312:
313: EXCEPTION
314: WHEN FND_API.G_EXC_ERROR THEN
315: --
316: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
317: x_Valid_Doc := FND_API.G_FALSE;
318: --
319: IF l_debug_on THEN
320: --

Line 331: x_return_status := wsh_util_core.g_ret_sts_error;

327: END IF;
328: --
329: WHEN invalid_doc_number
330: THEN
331: x_return_status := wsh_util_core.g_ret_sts_error;
332: x_valid_doc := fnd_api.g_false;
333: IF l_debug_on THEN
334: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_doc_number exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
335: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_doc_number');

Line 340: x_return_status := wsh_util_core.g_ret_sts_error;

336: END IF;
337: --R12.1.1 STANDALONE PROJECT
338: WHEN invalid_doc_revision
339: THEN
340: x_return_status := wsh_util_core.g_ret_sts_error;
341: x_valid_doc := fnd_api.g_false;
342: IF l_debug_on THEN
343: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_doc_revision exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
344: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_doc_revision');

Line 348: x_return_status := wsh_util_core.g_ret_sts_error;

344: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_doc_revision');
345: END IF;
346: WHEN invalid_tp
347: THEN
348: x_return_status := wsh_util_core.g_ret_sts_error;
349: x_valid_doc := fnd_api.g_false;
350: IF l_debug_on THEN
351: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_tp exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
352: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_tp');

Line 356: x_return_status := wsh_util_core.g_ret_sts_error;

352: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_tp');
353: END IF;
354: WHEN invalid_doc_direction
355: THEN
356: x_return_status := wsh_util_core.g_ret_sts_error;
357: x_valid_doc := fnd_api.g_false;
358: IF l_debug_on THEN
359: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_doc_direction exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
360: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_doc_direction');

Line 364: x_return_status := wsh_util_core.g_ret_sts_error;

360: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_doc_direction');
361: END IF;
362: WHEN invalid_doc_type
363: THEN
364: x_return_status := wsh_util_core.g_ret_sts_error;
365: x_valid_doc := fnd_api.g_false;
366: IF l_debug_on THEN
367: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_doc_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
368: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_doc_type');

Line 372: x_return_status := wsh_util_core.g_ret_sts_error;

368: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_doc_type');
369: END IF;
370: WHEN invalid_action_type
371: THEN
372: x_return_status := wsh_util_core.g_ret_sts_error;
373: x_valid_doc := fnd_api.g_false;
374: IF l_debug_on THEN
375: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_action_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
376: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_action_type');

Line 380: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

376: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_action_type');
377: END IF;
378: WHEN OTHERS
379: THEN
380: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
381: x_valid_doc := fnd_api.g_false;
382: IF l_debug_on THEN
383: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
384: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 422: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

418: wsh_debug_sv.log (l_module_name, 'P_trading_partner_site_id', P_trading_partner_site_id);
419: --
420: END IF;
421: --
422: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
423: --
424: IF WMS_DEPLOY.WMS_DEPLOYMENT_MODE = 'D' THEN --Bugfix 13427327
425: IF l_debug_on THEN
426: wsh_debug_sv.log (l_module_name, 'Distributed Mode');

Line 477: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

473: --
474: EXCEPTION
475: WHEN FND_API.G_EXC_ERROR THEN
476: --
477: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
478: --
479: IF l_debug_on THEN
480: --
481: WSH_DEBUG_SV.log(l_module_name, 'x_return_Status from Get_Client_details',X_Return_Status );

Line 489: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

485: --
486: END IF;
487: --
488: WHEN OTHERS THEN
489: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
490: IF l_debug_on THEN
491: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
492: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
493: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 584: x_return_status := wsh_util_core.g_ret_sts_success;

580: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
581: AND wdd.delivery_detail_id = delivery_detail_int_rec.delivery_detail_id
582: AND wda.delivery_id = p_delivery_id;
583:
584: x_return_status := wsh_util_core.g_ret_sts_success;
585: EXCEPTION
586: WHEN NO_DATA_FOUND
587: THEN
588: RAISE invalid_delivery_detail_id;

Line 595: x_return_status := wsh_util_core.g_ret_sts_error;

591: END;
592: END IF; -- End of if X_Delivery_Exists
593:
594: ELSIF (p_delivery_id IS NULL) THEN
595: x_return_status := wsh_util_core.g_ret_sts_error;
596: END IF; -- if p_delivery_id is null
597:
598: IF l_debug_on THEN
599: wsh_debug_sv.log (l_module_name,'940 Add Exists for the 940 Cancellation sent. Return Status',X_Return_Status );

Line 605: x_return_status := wsh_util_core.g_ret_sts_error;

601: END IF;
602: EXCEPTION
603: WHEN invalid_delivery_id
604: THEN
605: x_return_status := wsh_util_core.g_ret_sts_error;
606: IF l_debug_on THEN
607: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_delivery_id exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
608: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delivery_id');
609: END IF;

Line 612: x_return_status := wsh_util_core.g_ret_sts_error;

608: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delivery_id');
609: END IF;
610: WHEN invalid_delivery_detail_id
611: THEN
612: x_return_status := wsh_util_core.g_ret_sts_error;
613: IF l_debug_on THEN
614: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_delivery_detail_id exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
615: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delivery_detail_id');
616: END IF;

Line 619: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

615: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delivery_detail_id');
616: END IF;
617: WHEN OTHERS
618: THEN
619: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
620: IF l_debug_on THEN
621: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
622: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
623: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 718: x_return_status := wsh_util_core.g_ret_sts_success;

714: AND wth.document_type = 'SR'
715: AND wth.document_direction = 'O';
716: END IF;
717:
718: x_return_status := wsh_util_core.g_ret_sts_success;
719: EXCEPTION
720: WHEN NO_DATA_FOUND
721: THEN
722: RAISE invalid_delivery_detail_id;

Line 727: x_return_status := wsh_util_core.g_ret_sts_error;

723: END; -- End of Begin
724: END LOOP;
725:
726: ELSIF (p_delivery_interface_id IS NULL) THEN
727: x_return_status := wsh_util_core.g_ret_sts_error;
728: END IF; -- if p_delivery_interface_id is null
729:
730: IF l_debug_on THEN
731: wsh_debug_sv.log (l_module_name,'Return Status',X_Return_Status );

Line 737: x_return_status := wsh_util_core.g_ret_sts_error;

733: END IF;
734: EXCEPTION
735: WHEN invalid_delivery_detail_id
736: THEN
737: x_return_status := wsh_util_core.g_ret_sts_error;
738: IF l_debug_on THEN
739: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_delivery_detail_id exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
740: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delivery_detail_id');
741: END IF;

Line 744: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

740: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delivery_detail_id');
741: END IF;
742: WHEN OTHERS
743: THEN
744: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
745: IF l_debug_on THEN
746: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
747: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
748: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 896: x_return_status := wsh_util_core.g_ret_sts_success;

892: IF l_debug_on THEN
893: wsh_debug_sv.log (l_module_name, 'Compare Ship Request. Data Did Not Change for Delivery Details');
894: END IF;
895:
896: x_return_status := wsh_util_core.g_ret_sts_success;
897: END IF; -- if delivery_detail checks
898: END LOOP;
899: END LOOP;
900: END IF; -- if delivery checks

Line 929: x_return_status := wsh_util_core.g_ret_sts_error;

925:
926: EXCEPTION
927: WHEN invalid_delivery
928: THEN
929: x_return_status := wsh_util_core.g_ret_sts_error;
930: IF l_debug_on THEN
931: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_delivery exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
932: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delivery');
933: END IF;

Line 936: x_return_status := wsh_util_core.g_ret_sts_error;

932: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delivery');
933: END IF;
934: WHEN data_changed
935: THEN
936: x_return_status := wsh_util_core.g_ret_sts_error;
937: IF l_debug_on THEN
938: WSH_DEBUG_SV.logmsg(l_module_name,'data_changed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
939: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:data_changed');
940: END IF;

Line 943: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

939: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:data_changed');
940: END IF;
941: WHEN OTHERS
942: THEN
943: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
944: IF l_debug_on THEN
945: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
946: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
947: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1001: wsh_util_core.get_messages('Y', l_msg_data, l_msg_details, l_msg_count);

997: wsh_debug_sv.log (l_module_name, 'Message Name', p_interface_errors_rec.p_message_name);
998: END IF;
999:
1000: IF (p_msg_data IS NULL) THEN
1001: wsh_util_core.get_messages('Y', l_msg_data, l_msg_details, l_msg_count);
1002:
1003: IF (l_msg_data IS NULL) THEN
1004: fnd_message.set_name ('WSH', 'WSH_ERROR_IN_API');
1005: fnd_message.set_token ('API_NAME',p_api_name);

Line 1132: x_return_status := wsh_util_core.g_ret_sts_success;

1128: IF l_debug_on THEN
1129: wsh_debug_sv.log (l_module_name, 'Text for error_message is null');
1130: END IF;
1131: END IF; -- if l_text is not null
1132: x_return_status := wsh_util_core.g_ret_sts_success;
1133: ELSE
1134: RAISE invalid_parameters;
1135: END IF;
1136:

Line 1144: x_return_status := wsh_util_core.g_ret_sts_error;

1140: END IF;
1141: EXCEPTION
1142: WHEN invalid_parameters
1143: THEN
1144: x_return_status := wsh_util_core.g_ret_sts_error;
1145: IF l_debug_on THEN
1146: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1147: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
1148: END IF;

Line 1151: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

1147: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
1148: END IF;
1149: WHEN OTHERS
1150: THEN
1151: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
1152: IF l_debug_on THEN
1153: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
1154: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1155: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1183: l_interface_id_tab wsh_util_core.Id_Tab_Type;

1179: TYPE varchar30_Tab_Type IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
1180: TYPE varchar2000_Tab_Type IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
1181: l_interface_errors_rec_tab interface_errors_rec_tab;
1182: l_interface_table_name_tab varchar30_Tab_Type;
1183: l_interface_id_tab wsh_util_core.Id_Tab_Type;
1184: l_text_tab varchar2000_Tab_Type;
1185: --
1186: l_debug_on BOOLEAN;
1187: --

Line 1205: x_return_status := wsh_util_core.g_ret_sts_success;

1201: wsh_debug_sv.log (l_module_name, 'Message Count', p_interface_errors_rec_tab.COUNT);
1202: wsh_debug_sv.log (l_module_name, 'Interface Action Code', p_interface_action_code);
1203: END IF;
1204:
1205: x_return_status := wsh_util_core.g_ret_sts_success;
1206:
1207: IF (p_interface_errors_rec_tab.COUNT > 0) THEN
1208: FOR i in p_interface_errors_rec_tab.FIRST..p_interface_errors_rec_tab.LAST LOOP --{
1209:

Line 1382: x_return_status := wsh_util_core.g_ret_sts_error;

1378: END IF;
1379: EXCEPTION
1380: WHEN invalid_parameters
1381: THEN
1382: x_return_status := wsh_util_core.g_ret_sts_error;
1383: IF l_debug_on THEN
1384: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_PARAMETERS exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1385: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_PARAMETERS');
1386: END IF;

Line 1389: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

1385: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_PARAMETERS');
1386: END IF;
1387: WHEN OTHERS
1388: THEN
1389: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
1390: IF l_debug_on THEN
1391: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
1392: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1393: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');