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_DEL_OI_CORE dependencies on WSH_DEL_OI_CORE

Line 1: PACKAGE BODY WSH_DEL_OI_CORE as

1: PACKAGE BODY WSH_DEL_OI_CORE as
2: /* $Header: WSHSDVAB.pls 115.8 99/08/09 15:28:53 porting sh $ */
3:
4: -- Name Get_order_info
5: -- Purpose Obtain order info for the picking_header_id

Line 27: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.get_order_info');

23: into X_order_currency, X_order_category;
24: close order_info;
25: exception when others then
26: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
27: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.get_order_info');
28: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
29: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
30: APP_EXCEPTION.Raise_Exception;
31:

Line 63: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.pickslip_closed');

59: RETURN (FALSE);
60: END IF;
61: EXCEPTION WHEN OTHERS THEN
62: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
63: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.pickslip_closed');
64: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
65: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
66: APP_EXCEPTION.Raise_Exception;
67:

Line 115: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.get_item_control_codes');

111:
112:
113: exception when others then
114: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
115: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.get_item_control_codes');
116: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
117: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
118: APP_EXCEPTION.Raise_Exception;
119: end;

Line 188: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.valid_subinventory');

184:
185: return (TRUE);
186: exception when others then
187: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
188: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.valid_subinventory');
189: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
190: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
191: APP_EXCEPTION.Raise_Exception;
192: end;

Line 240: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.default_subinventory');

236: RETURN (dflt_subinventory);
237:
238: exception when others then
239: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
240: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.default_subinventory');
241: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
242: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
243: APP_EXCEPTION.Raise_Exception;
244:

Line 305: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.get_locator_controls');

301: end if;
302: close locator_controls;
303: exception when others then
304: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
305: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.get_locator_controls');
306: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
307: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
308: APP_EXCEPTION.Raise_Exception;
309: end;

Line 354: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.valid_lot_number');

350: return (TRUE);
351:
352: exception when others then
353: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
354: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.valid_lot_number');
355: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
356: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
357: APP_EXCEPTION.Raise_Exception;
358:

Line 401: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.valid_revision');

397: return (TRUE);
398:
399: exception when others then
400: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
401: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.valid_revision');
402: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
403: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
404: APP_EXCEPTION.Raise_Exception;
405: end;

Line 461: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.valid_locator_id');

457: end if;
458:
459: exception when others then
460: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
461: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.valid_locator_id');
462: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
463: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
464: APP_EXCEPTION.Raise_Exception;
465:

Line 493: wsh_del_oi_core.println('inside DEFAULT_LOCATOR');

489: X_location_restricted_flag in varchar2) return number is
490:
491: BEGIN
492:
493: wsh_del_oi_core.println('inside DEFAULT_LOCATOR');
494:
495: declare
496: cursor default_locator is
497: select mtldl.locator_id

Line 516: wsh_del_oi_core.println('inside DEFAULT_LOCATOR');

512: dflt_locator_id number;
513:
514: begin
515:
516: wsh_del_oi_core.println('inside DEFAULT_LOCATOR');
517: open default_locator;
518: fetch default_locator into dflt_locator_id;
519: close default_locator;
520:

Line 525: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.default_locator');

521: return (dflt_locator_id);
522:
523: exception when others then
524: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
525: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.default_locator');
526: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
527: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
528: APP_EXCEPTION.Raise_Exception;
529: end;

Line 621: wsh_del_oi_core.println('Valid_srl_no:'||msg_string);

617: return TRUE ;
618: elsif (( cur_stat = 1 ) or ( cur_stat = 3 )) Then
619: return TRUE;
620: else
621: wsh_del_oi_core.println('Valid_srl_no:'||msg_string);
622: wsh_del_oi_core.println('Dynamic Srl controlled but status !=(1 or 3)');
623: return FALSE;
624: end if;
625: elsif sql_string is null then

Line 622: wsh_del_oi_core.println('Dynamic Srl controlled but status !=(1 or 3)');

618: elsif (( cur_stat = 1 ) or ( cur_stat = 3 )) Then
619: return TRUE;
620: else
621: wsh_del_oi_core.println('Valid_srl_no:'||msg_string);
622: wsh_del_oi_core.println('Dynamic Srl controlled but status !=(1 or 3)');
623: return FALSE;
624: end if;
625: elsif sql_string is null then
626: wsh_del_oi_core.println('valid_srl_no:'||msg_string);

Line 626: wsh_del_oi_core.println('valid_srl_no:'||msg_string);

622: wsh_del_oi_core.println('Dynamic Srl controlled but status !=(1 or 3)');
623: return FALSE;
624: end if;
625: elsif sql_string is null then
626: wsh_del_oi_core.println('valid_srl_no:'||msg_string);
627: wsh_del_oi_core.println('Predefined Srl nos but srlno does not exist.');
628: return (FALSE);
629: end if;
630: return (TRUE);

Line 627: wsh_del_oi_core.println('Predefined Srl nos but srlno does not exist.');

623: return FALSE;
624: end if;
625: elsif sql_string is null then
626: wsh_del_oi_core.println('valid_srl_no:'||msg_string);
627: wsh_del_oi_core.println('Predefined Srl nos but srlno does not exist.');
628: return (FALSE);
629: end if;
630: return (TRUE);
631:

Line 634: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.valid_serial_number');

630: return (TRUE);
631:
632: exception when others then
633: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
634: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.valid_serial_number');
635: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
636: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
637: APP_EXCEPTION.Raise_Exception;
638:

Line 671: wsh_del_oi_core.println('Its not AR_interfaced');

667: close ar_valid;
668: RETURN (TRUE);
669: else
670: close ar_valid;
671: wsh_del_oi_core.println('Its not AR_interfaced');
672: RETURN (FALSE);
673: end if;
674: exception when others then
675: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');

Line 676: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.AR_INTERFACED');

672: RETURN (FALSE);
673: end if;
674: exception when others then
675: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
676: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.AR_INTERFACED');
677: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
678: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
679: APP_EXCEPTION.Raise_Exception;
680: end;

Line 716: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.valid_freight_type');

712: return (x_out_id);
713:
714: exception when others then
715: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
716: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.valid_freight_type');
717: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
718: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
719: APP_EXCEPTION.Raise_Exception;
720: end;

Line 751: wsh_del_oi_core.println('Invalid Carrier code.');

747:
748: if sql_dummy = 'valid' then
749: return (TRUE);
750: else
751: wsh_del_oi_core.println('Invalid Carrier code.');
752: return(FALSE);
753: end if;
754:
755: exception when others then

Line 757: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.valid_freight_type');

753: end if;
754:
755: exception when others then
756: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
757: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.valid_freight_type');
758: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
759: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
760: APP_EXCEPTION.Raise_Exception;
761: end;

Line 798: wsh_del_oi_core.println('Validate_container_id - container_lookup Cursor not found');

794: open container_lookup;
795: fetch container_lookup into container_id;
796:
797: if container_lookup%NOTFOUND THEN
798: wsh_del_oi_core.println('Validate_container_id - container_lookup Cursor not found');
799:
800: close container_lookup;
801:
802: if x_container_id is not null then

Line 803: wsh_del_oi_core.println('Validate_container_id container_id is not null');

799:
800: close container_lookup;
801:
802: if x_container_id is not null then
803: wsh_del_oi_core.println('Validate_container_id container_id is not null');
804: error_code := 'WSH_OI_INVALID_CONTAINER';
805: return (container_id);
806: end if;
807:

Line 819: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.validate_container_id');

815:
816: exception
817: when others then
818: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
819: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.validate_container_id');
820: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
821: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
822: APP_EXCEPTION.Raise_Exception;
823: end;

Line 886: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.validate_currency');

882: end if;
883: end if;
884: exception when others then
885: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
886: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.validate_currency');
887: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
888: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
889: APP_EXCEPTION.Raise_Exception;
890: end;

Line 930: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.validate_uom');

926: close uom_cursor;
927: end if;
928: exception when others then
929: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
930: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.validate_uom');
931: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
932: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
933: APP_EXCEPTION.Raise_Exception;
934: end;

Line 973: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.validate_user');

969: close user_lookup;
970: end if;
971: exception when others then
972: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
973: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.validate_user');
974: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
975: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
976: APP_EXCEPTION.Raise_Exception;
977: end;

Line 1008: wsh_del_oi_core.println('OEBSCO Returned with status '||x_dummy||' msg '||x_return_msg

1004: arg_6 => to_char(x_batch_id),
1005: arg_7 => chr(0));
1006:
1007:
1008: wsh_del_oi_core.println('OEBSCO Returned with status '||x_dummy||' msg '||x_return_msg
1009: ||' and code = '||to_char(error_code_num));
1010:
1011: IF (error_code_num = 2) THEN
1012: FND_MESSAGE.Set_Name('OE','OE_SH_PROCESS_ONLINE_NO_MGR');

Line 1073: wsh_del_oi_core.println('Multi_org_check returns FALSE');

1069: CLOSE multi_org_check;
1070: return(FALSE);
1071: ELSE
1072: CLOSE multi_org_check;
1073: wsh_del_oi_core.println('Multi_org_check returns FALSE');
1074: return(TRUE);
1075: END IF;
1076: end;
1077: END SHIP_MULTI_ORG;

Line 1149: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.validate_so_code');

1145: close so_code_lookup;
1146:
1147: exception when others then
1148: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
1149: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.validate_so_code');
1150: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
1151: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
1152: APP_EXCEPTION.Raise_Exception;
1153: end;

Line 1157: end WSH_DEL_OI_CORE;

1153: end;
1154: END Validate_so_code;
1155:
1156:
1157: end WSH_DEL_OI_CORE;