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_REQUEST_PUB dependencies on WSH_DEBUG_SV

Line 64: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

60: l_return_status VARCHAR2(100);
61: l_msg_count NUMBER;
62: l_msg_data VARCHAR2(1000);
63: --
64: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
65: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Shipment_Request';
66: l_invalid_inputs NUMBER;
67: --
68: l_api_version_number CONSTANT NUMBER := 1.0;

Line 75: wsh_debug_sv.push(l_module_name);

71:
72: BEGIN
73: --
74: IF l_debug_on THEN
75: wsh_debug_sv.push(l_module_name);
76: END IF;
77: -- Standard call to check for call compatibility
78: IF NOT FND_API.Compatible_API_Call
79: ( l_api_version_number

Line 95: WSH_DEBUG_SV.log(l_module_name,'p_action_code',p_action_code);

91: END IF;
92:
93: --
94: IF l_debug_on THEN
95: WSH_DEBUG_SV.log(l_module_name,'p_action_code',p_action_code);
96: WSH_DEBUG_SV.log(l_module_name,'Number of WDDI Records',p_shipment_request_info.shipment_details_tab.count);
97: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
98: WSH_DEBUG_SV.logmsg(l_module_name, '===============================================');
99: WSH_DEBUG_SV.logmsg(l_module_name, '| WNDI RECORD DETAILS |');

Line 96: WSH_DEBUG_SV.log(l_module_name,'Number of WDDI Records',p_shipment_request_info.shipment_details_tab.count);

92:
93: --
94: IF l_debug_on THEN
95: WSH_DEBUG_SV.log(l_module_name,'p_action_code',p_action_code);
96: WSH_DEBUG_SV.log(l_module_name,'Number of WDDI Records',p_shipment_request_info.shipment_details_tab.count);
97: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
98: WSH_DEBUG_SV.logmsg(l_module_name, '===============================================');
99: WSH_DEBUG_SV.logmsg(l_module_name, '| WNDI RECORD DETAILS |');
100: WSH_DEBUG_SV.logmsg(l_module_name, '===============================================');

Line 97: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);

93: --
94: IF l_debug_on THEN
95: WSH_DEBUG_SV.log(l_module_name,'p_action_code',p_action_code);
96: WSH_DEBUG_SV.log(l_module_name,'Number of WDDI Records',p_shipment_request_info.shipment_details_tab.count);
97: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
98: WSH_DEBUG_SV.logmsg(l_module_name, '===============================================');
99: WSH_DEBUG_SV.logmsg(l_module_name, '| WNDI RECORD DETAILS |');
100: WSH_DEBUG_SV.logmsg(l_module_name, '===============================================');
101: WSH_DEBUG_SV.log(l_module_name,'document_number', p_shipment_request_info.document_number);

Line 98: WSH_DEBUG_SV.logmsg(l_module_name, '===============================================');

94: IF l_debug_on THEN
95: WSH_DEBUG_SV.log(l_module_name,'p_action_code',p_action_code);
96: WSH_DEBUG_SV.log(l_module_name,'Number of WDDI Records',p_shipment_request_info.shipment_details_tab.count);
97: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
98: WSH_DEBUG_SV.logmsg(l_module_name, '===============================================');
99: WSH_DEBUG_SV.logmsg(l_module_name, '| WNDI RECORD DETAILS |');
100: WSH_DEBUG_SV.logmsg(l_module_name, '===============================================');
101: WSH_DEBUG_SV.log(l_module_name,'document_number', p_shipment_request_info.document_number);
102: WSH_DEBUG_SV.log(l_module_name,'document_revision', p_shipment_request_info.document_revision);

Line 99: WSH_DEBUG_SV.logmsg(l_module_name, '| WNDI RECORD DETAILS |');

95: WSH_DEBUG_SV.log(l_module_name,'p_action_code',p_action_code);
96: WSH_DEBUG_SV.log(l_module_name,'Number of WDDI Records',p_shipment_request_info.shipment_details_tab.count);
97: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
98: WSH_DEBUG_SV.logmsg(l_module_name, '===============================================');
99: WSH_DEBUG_SV.logmsg(l_module_name, '| WNDI RECORD DETAILS |');
100: WSH_DEBUG_SV.logmsg(l_module_name, '===============================================');
101: WSH_DEBUG_SV.log(l_module_name,'document_number', p_shipment_request_info.document_number);
102: WSH_DEBUG_SV.log(l_module_name,'document_revision', p_shipment_request_info.document_revision);
103: WSH_DEBUG_SV.log(l_module_name,'action_type', p_shipment_request_info.action_type);

Line 100: WSH_DEBUG_SV.logmsg(l_module_name, '===============================================');

96: WSH_DEBUG_SV.log(l_module_name,'Number of WDDI Records',p_shipment_request_info.shipment_details_tab.count);
97: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
98: WSH_DEBUG_SV.logmsg(l_module_name, '===============================================');
99: WSH_DEBUG_SV.logmsg(l_module_name, '| WNDI RECORD DETAILS |');
100: WSH_DEBUG_SV.logmsg(l_module_name, '===============================================');
101: WSH_DEBUG_SV.log(l_module_name,'document_number', p_shipment_request_info.document_number);
102: WSH_DEBUG_SV.log(l_module_name,'document_revision', p_shipment_request_info.document_revision);
103: WSH_DEBUG_SV.log(l_module_name,'action_type', p_shipment_request_info.action_type);
104: WSH_DEBUG_SV.log(l_module_name,'organization_code', p_shipment_request_info.organization_code);

Line 101: WSH_DEBUG_SV.log(l_module_name,'document_number', p_shipment_request_info.document_number);

97: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
98: WSH_DEBUG_SV.logmsg(l_module_name, '===============================================');
99: WSH_DEBUG_SV.logmsg(l_module_name, '| WNDI RECORD DETAILS |');
100: WSH_DEBUG_SV.logmsg(l_module_name, '===============================================');
101: WSH_DEBUG_SV.log(l_module_name,'document_number', p_shipment_request_info.document_number);
102: WSH_DEBUG_SV.log(l_module_name,'document_revision', p_shipment_request_info.document_revision);
103: WSH_DEBUG_SV.log(l_module_name,'action_type', p_shipment_request_info.action_type);
104: WSH_DEBUG_SV.log(l_module_name,'organization_code', p_shipment_request_info.organization_code);
105: WSH_DEBUG_SV.log(l_module_name,'customer_id', p_shipment_request_info.customer_id);

Line 102: WSH_DEBUG_SV.log(l_module_name,'document_revision', p_shipment_request_info.document_revision);

98: WSH_DEBUG_SV.logmsg(l_module_name, '===============================================');
99: WSH_DEBUG_SV.logmsg(l_module_name, '| WNDI RECORD DETAILS |');
100: WSH_DEBUG_SV.logmsg(l_module_name, '===============================================');
101: WSH_DEBUG_SV.log(l_module_name,'document_number', p_shipment_request_info.document_number);
102: WSH_DEBUG_SV.log(l_module_name,'document_revision', p_shipment_request_info.document_revision);
103: WSH_DEBUG_SV.log(l_module_name,'action_type', p_shipment_request_info.action_type);
104: WSH_DEBUG_SV.log(l_module_name,'organization_code', p_shipment_request_info.organization_code);
105: WSH_DEBUG_SV.log(l_module_name,'customer_id', p_shipment_request_info.customer_id);
106: WSH_DEBUG_SV.log(l_module_name,'customer_name', p_shipment_request_info.customer_name);

Line 103: WSH_DEBUG_SV.log(l_module_name,'action_type', p_shipment_request_info.action_type);

99: WSH_DEBUG_SV.logmsg(l_module_name, '| WNDI RECORD DETAILS |');
100: WSH_DEBUG_SV.logmsg(l_module_name, '===============================================');
101: WSH_DEBUG_SV.log(l_module_name,'document_number', p_shipment_request_info.document_number);
102: WSH_DEBUG_SV.log(l_module_name,'document_revision', p_shipment_request_info.document_revision);
103: WSH_DEBUG_SV.log(l_module_name,'action_type', p_shipment_request_info.action_type);
104: WSH_DEBUG_SV.log(l_module_name,'organization_code', p_shipment_request_info.organization_code);
105: WSH_DEBUG_SV.log(l_module_name,'customer_id', p_shipment_request_info.customer_id);
106: WSH_DEBUG_SV.log(l_module_name,'customer_name', p_shipment_request_info.customer_name);
107: WSH_DEBUG_SV.log(l_module_name,'ship_to_customer_id', p_shipment_request_info.ship_to_customer_id);

Line 104: WSH_DEBUG_SV.log(l_module_name,'organization_code', p_shipment_request_info.organization_code);

100: WSH_DEBUG_SV.logmsg(l_module_name, '===============================================');
101: WSH_DEBUG_SV.log(l_module_name,'document_number', p_shipment_request_info.document_number);
102: WSH_DEBUG_SV.log(l_module_name,'document_revision', p_shipment_request_info.document_revision);
103: WSH_DEBUG_SV.log(l_module_name,'action_type', p_shipment_request_info.action_type);
104: WSH_DEBUG_SV.log(l_module_name,'organization_code', p_shipment_request_info.organization_code);
105: WSH_DEBUG_SV.log(l_module_name,'customer_id', p_shipment_request_info.customer_id);
106: WSH_DEBUG_SV.log(l_module_name,'customer_name', p_shipment_request_info.customer_name);
107: WSH_DEBUG_SV.log(l_module_name,'ship_to_customer_id', p_shipment_request_info.ship_to_customer_id);
108: WSH_DEBUG_SV.log(l_module_name,'ship_to_customer_name', p_shipment_request_info.ship_to_customer_name);

Line 105: WSH_DEBUG_SV.log(l_module_name,'customer_id', p_shipment_request_info.customer_id);

101: WSH_DEBUG_SV.log(l_module_name,'document_number', p_shipment_request_info.document_number);
102: WSH_DEBUG_SV.log(l_module_name,'document_revision', p_shipment_request_info.document_revision);
103: WSH_DEBUG_SV.log(l_module_name,'action_type', p_shipment_request_info.action_type);
104: WSH_DEBUG_SV.log(l_module_name,'organization_code', p_shipment_request_info.organization_code);
105: WSH_DEBUG_SV.log(l_module_name,'customer_id', p_shipment_request_info.customer_id);
106: WSH_DEBUG_SV.log(l_module_name,'customer_name', p_shipment_request_info.customer_name);
107: WSH_DEBUG_SV.log(l_module_name,'ship_to_customer_id', p_shipment_request_info.ship_to_customer_id);
108: WSH_DEBUG_SV.log(l_module_name,'ship_to_customer_name', p_shipment_request_info.ship_to_customer_name);
109: WSH_DEBUG_SV.log(l_module_name,'ship_to_address_id', p_shipment_request_info.ship_to_address_id);

Line 106: WSH_DEBUG_SV.log(l_module_name,'customer_name', p_shipment_request_info.customer_name);

102: WSH_DEBUG_SV.log(l_module_name,'document_revision', p_shipment_request_info.document_revision);
103: WSH_DEBUG_SV.log(l_module_name,'action_type', p_shipment_request_info.action_type);
104: WSH_DEBUG_SV.log(l_module_name,'organization_code', p_shipment_request_info.organization_code);
105: WSH_DEBUG_SV.log(l_module_name,'customer_id', p_shipment_request_info.customer_id);
106: WSH_DEBUG_SV.log(l_module_name,'customer_name', p_shipment_request_info.customer_name);
107: WSH_DEBUG_SV.log(l_module_name,'ship_to_customer_id', p_shipment_request_info.ship_to_customer_id);
108: WSH_DEBUG_SV.log(l_module_name,'ship_to_customer_name', p_shipment_request_info.ship_to_customer_name);
109: WSH_DEBUG_SV.log(l_module_name,'ship_to_address_id', p_shipment_request_info.ship_to_address_id);
110: WSH_DEBUG_SV.log(l_module_name,'ship_to_address1', p_shipment_request_info.ship_to_address1);

Line 107: WSH_DEBUG_SV.log(l_module_name,'ship_to_customer_id', p_shipment_request_info.ship_to_customer_id);

103: WSH_DEBUG_SV.log(l_module_name,'action_type', p_shipment_request_info.action_type);
104: WSH_DEBUG_SV.log(l_module_name,'organization_code', p_shipment_request_info.organization_code);
105: WSH_DEBUG_SV.log(l_module_name,'customer_id', p_shipment_request_info.customer_id);
106: WSH_DEBUG_SV.log(l_module_name,'customer_name', p_shipment_request_info.customer_name);
107: WSH_DEBUG_SV.log(l_module_name,'ship_to_customer_id', p_shipment_request_info.ship_to_customer_id);
108: WSH_DEBUG_SV.log(l_module_name,'ship_to_customer_name', p_shipment_request_info.ship_to_customer_name);
109: WSH_DEBUG_SV.log(l_module_name,'ship_to_address_id', p_shipment_request_info.ship_to_address_id);
110: WSH_DEBUG_SV.log(l_module_name,'ship_to_address1', p_shipment_request_info.ship_to_address1);
111: WSH_DEBUG_SV.log(l_module_name,'ship_to_address2', p_shipment_request_info.ship_to_address2);

Line 108: WSH_DEBUG_SV.log(l_module_name,'ship_to_customer_name', p_shipment_request_info.ship_to_customer_name);

104: WSH_DEBUG_SV.log(l_module_name,'organization_code', p_shipment_request_info.organization_code);
105: WSH_DEBUG_SV.log(l_module_name,'customer_id', p_shipment_request_info.customer_id);
106: WSH_DEBUG_SV.log(l_module_name,'customer_name', p_shipment_request_info.customer_name);
107: WSH_DEBUG_SV.log(l_module_name,'ship_to_customer_id', p_shipment_request_info.ship_to_customer_id);
108: WSH_DEBUG_SV.log(l_module_name,'ship_to_customer_name', p_shipment_request_info.ship_to_customer_name);
109: WSH_DEBUG_SV.log(l_module_name,'ship_to_address_id', p_shipment_request_info.ship_to_address_id);
110: WSH_DEBUG_SV.log(l_module_name,'ship_to_address1', p_shipment_request_info.ship_to_address1);
111: WSH_DEBUG_SV.log(l_module_name,'ship_to_address2', p_shipment_request_info.ship_to_address2);
112: WSH_DEBUG_SV.log(l_module_name,'ship_to_address3', p_shipment_request_info.ship_to_address3);

Line 109: WSH_DEBUG_SV.log(l_module_name,'ship_to_address_id', p_shipment_request_info.ship_to_address_id);

105: WSH_DEBUG_SV.log(l_module_name,'customer_id', p_shipment_request_info.customer_id);
106: WSH_DEBUG_SV.log(l_module_name,'customer_name', p_shipment_request_info.customer_name);
107: WSH_DEBUG_SV.log(l_module_name,'ship_to_customer_id', p_shipment_request_info.ship_to_customer_id);
108: WSH_DEBUG_SV.log(l_module_name,'ship_to_customer_name', p_shipment_request_info.ship_to_customer_name);
109: WSH_DEBUG_SV.log(l_module_name,'ship_to_address_id', p_shipment_request_info.ship_to_address_id);
110: WSH_DEBUG_SV.log(l_module_name,'ship_to_address1', p_shipment_request_info.ship_to_address1);
111: WSH_DEBUG_SV.log(l_module_name,'ship_to_address2', p_shipment_request_info.ship_to_address2);
112: WSH_DEBUG_SV.log(l_module_name,'ship_to_address3', p_shipment_request_info.ship_to_address3);
113: WSH_DEBUG_SV.log(l_module_name,'ship_to_address4', p_shipment_request_info.ship_to_address4);

Line 110: WSH_DEBUG_SV.log(l_module_name,'ship_to_address1', p_shipment_request_info.ship_to_address1);

106: WSH_DEBUG_SV.log(l_module_name,'customer_name', p_shipment_request_info.customer_name);
107: WSH_DEBUG_SV.log(l_module_name,'ship_to_customer_id', p_shipment_request_info.ship_to_customer_id);
108: WSH_DEBUG_SV.log(l_module_name,'ship_to_customer_name', p_shipment_request_info.ship_to_customer_name);
109: WSH_DEBUG_SV.log(l_module_name,'ship_to_address_id', p_shipment_request_info.ship_to_address_id);
110: WSH_DEBUG_SV.log(l_module_name,'ship_to_address1', p_shipment_request_info.ship_to_address1);
111: WSH_DEBUG_SV.log(l_module_name,'ship_to_address2', p_shipment_request_info.ship_to_address2);
112: WSH_DEBUG_SV.log(l_module_name,'ship_to_address3', p_shipment_request_info.ship_to_address3);
113: WSH_DEBUG_SV.log(l_module_name,'ship_to_address4', p_shipment_request_info.ship_to_address4);
114: WSH_DEBUG_SV.log(l_module_name,'ship_to_city', p_shipment_request_info.ship_to_city);

Line 111: WSH_DEBUG_SV.log(l_module_name,'ship_to_address2', p_shipment_request_info.ship_to_address2);

107: WSH_DEBUG_SV.log(l_module_name,'ship_to_customer_id', p_shipment_request_info.ship_to_customer_id);
108: WSH_DEBUG_SV.log(l_module_name,'ship_to_customer_name', p_shipment_request_info.ship_to_customer_name);
109: WSH_DEBUG_SV.log(l_module_name,'ship_to_address_id', p_shipment_request_info.ship_to_address_id);
110: WSH_DEBUG_SV.log(l_module_name,'ship_to_address1', p_shipment_request_info.ship_to_address1);
111: WSH_DEBUG_SV.log(l_module_name,'ship_to_address2', p_shipment_request_info.ship_to_address2);
112: WSH_DEBUG_SV.log(l_module_name,'ship_to_address3', p_shipment_request_info.ship_to_address3);
113: WSH_DEBUG_SV.log(l_module_name,'ship_to_address4', p_shipment_request_info.ship_to_address4);
114: WSH_DEBUG_SV.log(l_module_name,'ship_to_city', p_shipment_request_info.ship_to_city);
115: WSH_DEBUG_SV.log(l_module_name,'ship_to_state', p_shipment_request_info.ship_to_state);

Line 112: WSH_DEBUG_SV.log(l_module_name,'ship_to_address3', p_shipment_request_info.ship_to_address3);

108: WSH_DEBUG_SV.log(l_module_name,'ship_to_customer_name', p_shipment_request_info.ship_to_customer_name);
109: WSH_DEBUG_SV.log(l_module_name,'ship_to_address_id', p_shipment_request_info.ship_to_address_id);
110: WSH_DEBUG_SV.log(l_module_name,'ship_to_address1', p_shipment_request_info.ship_to_address1);
111: WSH_DEBUG_SV.log(l_module_name,'ship_to_address2', p_shipment_request_info.ship_to_address2);
112: WSH_DEBUG_SV.log(l_module_name,'ship_to_address3', p_shipment_request_info.ship_to_address3);
113: WSH_DEBUG_SV.log(l_module_name,'ship_to_address4', p_shipment_request_info.ship_to_address4);
114: WSH_DEBUG_SV.log(l_module_name,'ship_to_city', p_shipment_request_info.ship_to_city);
115: WSH_DEBUG_SV.log(l_module_name,'ship_to_state', p_shipment_request_info.ship_to_state);
116: WSH_DEBUG_SV.log(l_module_name,'ship_to_country', p_shipment_request_info.ship_to_country);

Line 113: WSH_DEBUG_SV.log(l_module_name,'ship_to_address4', p_shipment_request_info.ship_to_address4);

109: WSH_DEBUG_SV.log(l_module_name,'ship_to_address_id', p_shipment_request_info.ship_to_address_id);
110: WSH_DEBUG_SV.log(l_module_name,'ship_to_address1', p_shipment_request_info.ship_to_address1);
111: WSH_DEBUG_SV.log(l_module_name,'ship_to_address2', p_shipment_request_info.ship_to_address2);
112: WSH_DEBUG_SV.log(l_module_name,'ship_to_address3', p_shipment_request_info.ship_to_address3);
113: WSH_DEBUG_SV.log(l_module_name,'ship_to_address4', p_shipment_request_info.ship_to_address4);
114: WSH_DEBUG_SV.log(l_module_name,'ship_to_city', p_shipment_request_info.ship_to_city);
115: WSH_DEBUG_SV.log(l_module_name,'ship_to_state', p_shipment_request_info.ship_to_state);
116: WSH_DEBUG_SV.log(l_module_name,'ship_to_country', p_shipment_request_info.ship_to_country);
117: WSH_DEBUG_SV.log(l_module_name,'ship_to_postal_code', p_shipment_request_info.ship_to_postal_code);

Line 114: WSH_DEBUG_SV.log(l_module_name,'ship_to_city', p_shipment_request_info.ship_to_city);

110: WSH_DEBUG_SV.log(l_module_name,'ship_to_address1', p_shipment_request_info.ship_to_address1);
111: WSH_DEBUG_SV.log(l_module_name,'ship_to_address2', p_shipment_request_info.ship_to_address2);
112: WSH_DEBUG_SV.log(l_module_name,'ship_to_address3', p_shipment_request_info.ship_to_address3);
113: WSH_DEBUG_SV.log(l_module_name,'ship_to_address4', p_shipment_request_info.ship_to_address4);
114: WSH_DEBUG_SV.log(l_module_name,'ship_to_city', p_shipment_request_info.ship_to_city);
115: WSH_DEBUG_SV.log(l_module_name,'ship_to_state', p_shipment_request_info.ship_to_state);
116: WSH_DEBUG_SV.log(l_module_name,'ship_to_country', p_shipment_request_info.ship_to_country);
117: WSH_DEBUG_SV.log(l_module_name,'ship_to_postal_code', p_shipment_request_info.ship_to_postal_code);
118: WSH_DEBUG_SV.log(l_module_name,'ship_to_contact_id', p_shipment_request_info.ship_to_contact_id);

Line 115: WSH_DEBUG_SV.log(l_module_name,'ship_to_state', p_shipment_request_info.ship_to_state);

111: WSH_DEBUG_SV.log(l_module_name,'ship_to_address2', p_shipment_request_info.ship_to_address2);
112: WSH_DEBUG_SV.log(l_module_name,'ship_to_address3', p_shipment_request_info.ship_to_address3);
113: WSH_DEBUG_SV.log(l_module_name,'ship_to_address4', p_shipment_request_info.ship_to_address4);
114: WSH_DEBUG_SV.log(l_module_name,'ship_to_city', p_shipment_request_info.ship_to_city);
115: WSH_DEBUG_SV.log(l_module_name,'ship_to_state', p_shipment_request_info.ship_to_state);
116: WSH_DEBUG_SV.log(l_module_name,'ship_to_country', p_shipment_request_info.ship_to_country);
117: WSH_DEBUG_SV.log(l_module_name,'ship_to_postal_code', p_shipment_request_info.ship_to_postal_code);
118: WSH_DEBUG_SV.log(l_module_name,'ship_to_contact_id', p_shipment_request_info.ship_to_contact_id);
119: WSH_DEBUG_SV.log(l_module_name,'ship_to_contact_name', p_shipment_request_info.ship_to_contact_name);

Line 116: WSH_DEBUG_SV.log(l_module_name,'ship_to_country', p_shipment_request_info.ship_to_country);

112: WSH_DEBUG_SV.log(l_module_name,'ship_to_address3', p_shipment_request_info.ship_to_address3);
113: WSH_DEBUG_SV.log(l_module_name,'ship_to_address4', p_shipment_request_info.ship_to_address4);
114: WSH_DEBUG_SV.log(l_module_name,'ship_to_city', p_shipment_request_info.ship_to_city);
115: WSH_DEBUG_SV.log(l_module_name,'ship_to_state', p_shipment_request_info.ship_to_state);
116: WSH_DEBUG_SV.log(l_module_name,'ship_to_country', p_shipment_request_info.ship_to_country);
117: WSH_DEBUG_SV.log(l_module_name,'ship_to_postal_code', p_shipment_request_info.ship_to_postal_code);
118: WSH_DEBUG_SV.log(l_module_name,'ship_to_contact_id', p_shipment_request_info.ship_to_contact_id);
119: WSH_DEBUG_SV.log(l_module_name,'ship_to_contact_name', p_shipment_request_info.ship_to_contact_name);
120: WSH_DEBUG_SV.log(l_module_name,'ship_to_contact_phone', p_shipment_request_info.ship_to_contact_phone);

Line 117: WSH_DEBUG_SV.log(l_module_name,'ship_to_postal_code', p_shipment_request_info.ship_to_postal_code);

113: WSH_DEBUG_SV.log(l_module_name,'ship_to_address4', p_shipment_request_info.ship_to_address4);
114: WSH_DEBUG_SV.log(l_module_name,'ship_to_city', p_shipment_request_info.ship_to_city);
115: WSH_DEBUG_SV.log(l_module_name,'ship_to_state', p_shipment_request_info.ship_to_state);
116: WSH_DEBUG_SV.log(l_module_name,'ship_to_country', p_shipment_request_info.ship_to_country);
117: WSH_DEBUG_SV.log(l_module_name,'ship_to_postal_code', p_shipment_request_info.ship_to_postal_code);
118: WSH_DEBUG_SV.log(l_module_name,'ship_to_contact_id', p_shipment_request_info.ship_to_contact_id);
119: WSH_DEBUG_SV.log(l_module_name,'ship_to_contact_name', p_shipment_request_info.ship_to_contact_name);
120: WSH_DEBUG_SV.log(l_module_name,'ship_to_contact_phone', p_shipment_request_info.ship_to_contact_phone);
121:

Line 118: WSH_DEBUG_SV.log(l_module_name,'ship_to_contact_id', p_shipment_request_info.ship_to_contact_id);

114: WSH_DEBUG_SV.log(l_module_name,'ship_to_city', p_shipment_request_info.ship_to_city);
115: WSH_DEBUG_SV.log(l_module_name,'ship_to_state', p_shipment_request_info.ship_to_state);
116: WSH_DEBUG_SV.log(l_module_name,'ship_to_country', p_shipment_request_info.ship_to_country);
117: WSH_DEBUG_SV.log(l_module_name,'ship_to_postal_code', p_shipment_request_info.ship_to_postal_code);
118: WSH_DEBUG_SV.log(l_module_name,'ship_to_contact_id', p_shipment_request_info.ship_to_contact_id);
119: WSH_DEBUG_SV.log(l_module_name,'ship_to_contact_name', p_shipment_request_info.ship_to_contact_name);
120: WSH_DEBUG_SV.log(l_module_name,'ship_to_contact_phone', p_shipment_request_info.ship_to_contact_phone);
121:
122: WSH_DEBUG_SV.log(l_module_name,'invoice_to_customer_id', p_shipment_request_info.invoice_to_customer_id);

Line 119: WSH_DEBUG_SV.log(l_module_name,'ship_to_contact_name', p_shipment_request_info.ship_to_contact_name);

115: WSH_DEBUG_SV.log(l_module_name,'ship_to_state', p_shipment_request_info.ship_to_state);
116: WSH_DEBUG_SV.log(l_module_name,'ship_to_country', p_shipment_request_info.ship_to_country);
117: WSH_DEBUG_SV.log(l_module_name,'ship_to_postal_code', p_shipment_request_info.ship_to_postal_code);
118: WSH_DEBUG_SV.log(l_module_name,'ship_to_contact_id', p_shipment_request_info.ship_to_contact_id);
119: WSH_DEBUG_SV.log(l_module_name,'ship_to_contact_name', p_shipment_request_info.ship_to_contact_name);
120: WSH_DEBUG_SV.log(l_module_name,'ship_to_contact_phone', p_shipment_request_info.ship_to_contact_phone);
121:
122: WSH_DEBUG_SV.log(l_module_name,'invoice_to_customer_id', p_shipment_request_info.invoice_to_customer_id);
123: WSH_DEBUG_SV.log(l_module_name,'invoice_to_customer_name', p_shipment_request_info.invoice_to_customer_name);

Line 120: WSH_DEBUG_SV.log(l_module_name,'ship_to_contact_phone', p_shipment_request_info.ship_to_contact_phone);

116: WSH_DEBUG_SV.log(l_module_name,'ship_to_country', p_shipment_request_info.ship_to_country);
117: WSH_DEBUG_SV.log(l_module_name,'ship_to_postal_code', p_shipment_request_info.ship_to_postal_code);
118: WSH_DEBUG_SV.log(l_module_name,'ship_to_contact_id', p_shipment_request_info.ship_to_contact_id);
119: WSH_DEBUG_SV.log(l_module_name,'ship_to_contact_name', p_shipment_request_info.ship_to_contact_name);
120: WSH_DEBUG_SV.log(l_module_name,'ship_to_contact_phone', p_shipment_request_info.ship_to_contact_phone);
121:
122: WSH_DEBUG_SV.log(l_module_name,'invoice_to_customer_id', p_shipment_request_info.invoice_to_customer_id);
123: WSH_DEBUG_SV.log(l_module_name,'invoice_to_customer_name', p_shipment_request_info.invoice_to_customer_name);
124: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address_id', p_shipment_request_info.invoice_to_address_id);

Line 122: WSH_DEBUG_SV.log(l_module_name,'invoice_to_customer_id', p_shipment_request_info.invoice_to_customer_id);

118: WSH_DEBUG_SV.log(l_module_name,'ship_to_contact_id', p_shipment_request_info.ship_to_contact_id);
119: WSH_DEBUG_SV.log(l_module_name,'ship_to_contact_name', p_shipment_request_info.ship_to_contact_name);
120: WSH_DEBUG_SV.log(l_module_name,'ship_to_contact_phone', p_shipment_request_info.ship_to_contact_phone);
121:
122: WSH_DEBUG_SV.log(l_module_name,'invoice_to_customer_id', p_shipment_request_info.invoice_to_customer_id);
123: WSH_DEBUG_SV.log(l_module_name,'invoice_to_customer_name', p_shipment_request_info.invoice_to_customer_name);
124: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address_id', p_shipment_request_info.invoice_to_address_id);
125: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address1', p_shipment_request_info.invoice_to_address1);
126: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address2', p_shipment_request_info.invoice_to_address2);

Line 123: WSH_DEBUG_SV.log(l_module_name,'invoice_to_customer_name', p_shipment_request_info.invoice_to_customer_name);

119: WSH_DEBUG_SV.log(l_module_name,'ship_to_contact_name', p_shipment_request_info.ship_to_contact_name);
120: WSH_DEBUG_SV.log(l_module_name,'ship_to_contact_phone', p_shipment_request_info.ship_to_contact_phone);
121:
122: WSH_DEBUG_SV.log(l_module_name,'invoice_to_customer_id', p_shipment_request_info.invoice_to_customer_id);
123: WSH_DEBUG_SV.log(l_module_name,'invoice_to_customer_name', p_shipment_request_info.invoice_to_customer_name);
124: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address_id', p_shipment_request_info.invoice_to_address_id);
125: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address1', p_shipment_request_info.invoice_to_address1);
126: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address2', p_shipment_request_info.invoice_to_address2);
127: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address3', p_shipment_request_info.invoice_to_address3);

Line 124: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address_id', p_shipment_request_info.invoice_to_address_id);

120: WSH_DEBUG_SV.log(l_module_name,'ship_to_contact_phone', p_shipment_request_info.ship_to_contact_phone);
121:
122: WSH_DEBUG_SV.log(l_module_name,'invoice_to_customer_id', p_shipment_request_info.invoice_to_customer_id);
123: WSH_DEBUG_SV.log(l_module_name,'invoice_to_customer_name', p_shipment_request_info.invoice_to_customer_name);
124: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address_id', p_shipment_request_info.invoice_to_address_id);
125: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address1', p_shipment_request_info.invoice_to_address1);
126: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address2', p_shipment_request_info.invoice_to_address2);
127: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address3', p_shipment_request_info.invoice_to_address3);
128: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address4', p_shipment_request_info.invoice_to_address4);

Line 125: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address1', p_shipment_request_info.invoice_to_address1);

121:
122: WSH_DEBUG_SV.log(l_module_name,'invoice_to_customer_id', p_shipment_request_info.invoice_to_customer_id);
123: WSH_DEBUG_SV.log(l_module_name,'invoice_to_customer_name', p_shipment_request_info.invoice_to_customer_name);
124: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address_id', p_shipment_request_info.invoice_to_address_id);
125: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address1', p_shipment_request_info.invoice_to_address1);
126: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address2', p_shipment_request_info.invoice_to_address2);
127: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address3', p_shipment_request_info.invoice_to_address3);
128: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address4', p_shipment_request_info.invoice_to_address4);
129: WSH_DEBUG_SV.log(l_module_name,'invoice_to_city', p_shipment_request_info.invoice_to_city);

Line 126: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address2', p_shipment_request_info.invoice_to_address2);

122: WSH_DEBUG_SV.log(l_module_name,'invoice_to_customer_id', p_shipment_request_info.invoice_to_customer_id);
123: WSH_DEBUG_SV.log(l_module_name,'invoice_to_customer_name', p_shipment_request_info.invoice_to_customer_name);
124: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address_id', p_shipment_request_info.invoice_to_address_id);
125: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address1', p_shipment_request_info.invoice_to_address1);
126: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address2', p_shipment_request_info.invoice_to_address2);
127: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address3', p_shipment_request_info.invoice_to_address3);
128: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address4', p_shipment_request_info.invoice_to_address4);
129: WSH_DEBUG_SV.log(l_module_name,'invoice_to_city', p_shipment_request_info.invoice_to_city);
130: WSH_DEBUG_SV.log(l_module_name,'invoice_to_state', p_shipment_request_info.invoice_to_state);

Line 127: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address3', p_shipment_request_info.invoice_to_address3);

123: WSH_DEBUG_SV.log(l_module_name,'invoice_to_customer_name', p_shipment_request_info.invoice_to_customer_name);
124: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address_id', p_shipment_request_info.invoice_to_address_id);
125: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address1', p_shipment_request_info.invoice_to_address1);
126: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address2', p_shipment_request_info.invoice_to_address2);
127: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address3', p_shipment_request_info.invoice_to_address3);
128: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address4', p_shipment_request_info.invoice_to_address4);
129: WSH_DEBUG_SV.log(l_module_name,'invoice_to_city', p_shipment_request_info.invoice_to_city);
130: WSH_DEBUG_SV.log(l_module_name,'invoice_to_state', p_shipment_request_info.invoice_to_state);
131: WSH_DEBUG_SV.log(l_module_name,'invoice_to_country', p_shipment_request_info.invoice_to_country);

Line 128: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address4', p_shipment_request_info.invoice_to_address4);

124: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address_id', p_shipment_request_info.invoice_to_address_id);
125: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address1', p_shipment_request_info.invoice_to_address1);
126: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address2', p_shipment_request_info.invoice_to_address2);
127: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address3', p_shipment_request_info.invoice_to_address3);
128: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address4', p_shipment_request_info.invoice_to_address4);
129: WSH_DEBUG_SV.log(l_module_name,'invoice_to_city', p_shipment_request_info.invoice_to_city);
130: WSH_DEBUG_SV.log(l_module_name,'invoice_to_state', p_shipment_request_info.invoice_to_state);
131: WSH_DEBUG_SV.log(l_module_name,'invoice_to_country', p_shipment_request_info.invoice_to_country);
132: WSH_DEBUG_SV.log(l_module_name,'invoice_to_postal_code', p_shipment_request_info.invoice_to_postal_code);

Line 129: WSH_DEBUG_SV.log(l_module_name,'invoice_to_city', p_shipment_request_info.invoice_to_city);

125: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address1', p_shipment_request_info.invoice_to_address1);
126: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address2', p_shipment_request_info.invoice_to_address2);
127: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address3', p_shipment_request_info.invoice_to_address3);
128: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address4', p_shipment_request_info.invoice_to_address4);
129: WSH_DEBUG_SV.log(l_module_name,'invoice_to_city', p_shipment_request_info.invoice_to_city);
130: WSH_DEBUG_SV.log(l_module_name,'invoice_to_state', p_shipment_request_info.invoice_to_state);
131: WSH_DEBUG_SV.log(l_module_name,'invoice_to_country', p_shipment_request_info.invoice_to_country);
132: WSH_DEBUG_SV.log(l_module_name,'invoice_to_postal_code', p_shipment_request_info.invoice_to_postal_code);
133: WSH_DEBUG_SV.log(l_module_name,'invoice_to_contact_id', p_shipment_request_info.invoice_to_contact_id);

Line 130: WSH_DEBUG_SV.log(l_module_name,'invoice_to_state', p_shipment_request_info.invoice_to_state);

126: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address2', p_shipment_request_info.invoice_to_address2);
127: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address3', p_shipment_request_info.invoice_to_address3);
128: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address4', p_shipment_request_info.invoice_to_address4);
129: WSH_DEBUG_SV.log(l_module_name,'invoice_to_city', p_shipment_request_info.invoice_to_city);
130: WSH_DEBUG_SV.log(l_module_name,'invoice_to_state', p_shipment_request_info.invoice_to_state);
131: WSH_DEBUG_SV.log(l_module_name,'invoice_to_country', p_shipment_request_info.invoice_to_country);
132: WSH_DEBUG_SV.log(l_module_name,'invoice_to_postal_code', p_shipment_request_info.invoice_to_postal_code);
133: WSH_DEBUG_SV.log(l_module_name,'invoice_to_contact_id', p_shipment_request_info.invoice_to_contact_id);
134: WSH_DEBUG_SV.log(l_module_name,'invoice_to_contact_name', p_shipment_request_info.invoice_to_contact_name);

Line 131: WSH_DEBUG_SV.log(l_module_name,'invoice_to_country', p_shipment_request_info.invoice_to_country);

127: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address3', p_shipment_request_info.invoice_to_address3);
128: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address4', p_shipment_request_info.invoice_to_address4);
129: WSH_DEBUG_SV.log(l_module_name,'invoice_to_city', p_shipment_request_info.invoice_to_city);
130: WSH_DEBUG_SV.log(l_module_name,'invoice_to_state', p_shipment_request_info.invoice_to_state);
131: WSH_DEBUG_SV.log(l_module_name,'invoice_to_country', p_shipment_request_info.invoice_to_country);
132: WSH_DEBUG_SV.log(l_module_name,'invoice_to_postal_code', p_shipment_request_info.invoice_to_postal_code);
133: WSH_DEBUG_SV.log(l_module_name,'invoice_to_contact_id', p_shipment_request_info.invoice_to_contact_id);
134: WSH_DEBUG_SV.log(l_module_name,'invoice_to_contact_name', p_shipment_request_info.invoice_to_contact_name);
135: WSH_DEBUG_SV.log(l_module_name,'invoice_to_contact_phone', p_shipment_request_info.invoice_to_contact_phone);

Line 132: WSH_DEBUG_SV.log(l_module_name,'invoice_to_postal_code', p_shipment_request_info.invoice_to_postal_code);

128: WSH_DEBUG_SV.log(l_module_name,'invoice_to_address4', p_shipment_request_info.invoice_to_address4);
129: WSH_DEBUG_SV.log(l_module_name,'invoice_to_city', p_shipment_request_info.invoice_to_city);
130: WSH_DEBUG_SV.log(l_module_name,'invoice_to_state', p_shipment_request_info.invoice_to_state);
131: WSH_DEBUG_SV.log(l_module_name,'invoice_to_country', p_shipment_request_info.invoice_to_country);
132: WSH_DEBUG_SV.log(l_module_name,'invoice_to_postal_code', p_shipment_request_info.invoice_to_postal_code);
133: WSH_DEBUG_SV.log(l_module_name,'invoice_to_contact_id', p_shipment_request_info.invoice_to_contact_id);
134: WSH_DEBUG_SV.log(l_module_name,'invoice_to_contact_name', p_shipment_request_info.invoice_to_contact_name);
135: WSH_DEBUG_SV.log(l_module_name,'invoice_to_contact_phone', p_shipment_request_info.invoice_to_contact_phone);
136:

Line 133: WSH_DEBUG_SV.log(l_module_name,'invoice_to_contact_id', p_shipment_request_info.invoice_to_contact_id);

129: WSH_DEBUG_SV.log(l_module_name,'invoice_to_city', p_shipment_request_info.invoice_to_city);
130: WSH_DEBUG_SV.log(l_module_name,'invoice_to_state', p_shipment_request_info.invoice_to_state);
131: WSH_DEBUG_SV.log(l_module_name,'invoice_to_country', p_shipment_request_info.invoice_to_country);
132: WSH_DEBUG_SV.log(l_module_name,'invoice_to_postal_code', p_shipment_request_info.invoice_to_postal_code);
133: WSH_DEBUG_SV.log(l_module_name,'invoice_to_contact_id', p_shipment_request_info.invoice_to_contact_id);
134: WSH_DEBUG_SV.log(l_module_name,'invoice_to_contact_name', p_shipment_request_info.invoice_to_contact_name);
135: WSH_DEBUG_SV.log(l_module_name,'invoice_to_contact_phone', p_shipment_request_info.invoice_to_contact_phone);
136:
137: WSH_DEBUG_SV.log(l_module_name,'deliver_to_customer_id', p_shipment_request_info.deliver_to_customer_id);

Line 134: WSH_DEBUG_SV.log(l_module_name,'invoice_to_contact_name', p_shipment_request_info.invoice_to_contact_name);

130: WSH_DEBUG_SV.log(l_module_name,'invoice_to_state', p_shipment_request_info.invoice_to_state);
131: WSH_DEBUG_SV.log(l_module_name,'invoice_to_country', p_shipment_request_info.invoice_to_country);
132: WSH_DEBUG_SV.log(l_module_name,'invoice_to_postal_code', p_shipment_request_info.invoice_to_postal_code);
133: WSH_DEBUG_SV.log(l_module_name,'invoice_to_contact_id', p_shipment_request_info.invoice_to_contact_id);
134: WSH_DEBUG_SV.log(l_module_name,'invoice_to_contact_name', p_shipment_request_info.invoice_to_contact_name);
135: WSH_DEBUG_SV.log(l_module_name,'invoice_to_contact_phone', p_shipment_request_info.invoice_to_contact_phone);
136:
137: WSH_DEBUG_SV.log(l_module_name,'deliver_to_customer_id', p_shipment_request_info.deliver_to_customer_id);
138: WSH_DEBUG_SV.log(l_module_name,'deliver_to_customer_name', p_shipment_request_info.deliver_to_customer_name);

Line 135: WSH_DEBUG_SV.log(l_module_name,'invoice_to_contact_phone', p_shipment_request_info.invoice_to_contact_phone);

131: WSH_DEBUG_SV.log(l_module_name,'invoice_to_country', p_shipment_request_info.invoice_to_country);
132: WSH_DEBUG_SV.log(l_module_name,'invoice_to_postal_code', p_shipment_request_info.invoice_to_postal_code);
133: WSH_DEBUG_SV.log(l_module_name,'invoice_to_contact_id', p_shipment_request_info.invoice_to_contact_id);
134: WSH_DEBUG_SV.log(l_module_name,'invoice_to_contact_name', p_shipment_request_info.invoice_to_contact_name);
135: WSH_DEBUG_SV.log(l_module_name,'invoice_to_contact_phone', p_shipment_request_info.invoice_to_contact_phone);
136:
137: WSH_DEBUG_SV.log(l_module_name,'deliver_to_customer_id', p_shipment_request_info.deliver_to_customer_id);
138: WSH_DEBUG_SV.log(l_module_name,'deliver_to_customer_name', p_shipment_request_info.deliver_to_customer_name);
139: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address_id', p_shipment_request_info.deliver_to_address_id);

Line 137: WSH_DEBUG_SV.log(l_module_name,'deliver_to_customer_id', p_shipment_request_info.deliver_to_customer_id);

133: WSH_DEBUG_SV.log(l_module_name,'invoice_to_contact_id', p_shipment_request_info.invoice_to_contact_id);
134: WSH_DEBUG_SV.log(l_module_name,'invoice_to_contact_name', p_shipment_request_info.invoice_to_contact_name);
135: WSH_DEBUG_SV.log(l_module_name,'invoice_to_contact_phone', p_shipment_request_info.invoice_to_contact_phone);
136:
137: WSH_DEBUG_SV.log(l_module_name,'deliver_to_customer_id', p_shipment_request_info.deliver_to_customer_id);
138: WSH_DEBUG_SV.log(l_module_name,'deliver_to_customer_name', p_shipment_request_info.deliver_to_customer_name);
139: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address_id', p_shipment_request_info.deliver_to_address_id);
140: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address1', p_shipment_request_info.deliver_to_address1);
141: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address2', p_shipment_request_info.deliver_to_address2);

Line 138: WSH_DEBUG_SV.log(l_module_name,'deliver_to_customer_name', p_shipment_request_info.deliver_to_customer_name);

134: WSH_DEBUG_SV.log(l_module_name,'invoice_to_contact_name', p_shipment_request_info.invoice_to_contact_name);
135: WSH_DEBUG_SV.log(l_module_name,'invoice_to_contact_phone', p_shipment_request_info.invoice_to_contact_phone);
136:
137: WSH_DEBUG_SV.log(l_module_name,'deliver_to_customer_id', p_shipment_request_info.deliver_to_customer_id);
138: WSH_DEBUG_SV.log(l_module_name,'deliver_to_customer_name', p_shipment_request_info.deliver_to_customer_name);
139: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address_id', p_shipment_request_info.deliver_to_address_id);
140: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address1', p_shipment_request_info.deliver_to_address1);
141: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address2', p_shipment_request_info.deliver_to_address2);
142: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address3', p_shipment_request_info.deliver_to_address3);

Line 139: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address_id', p_shipment_request_info.deliver_to_address_id);

135: WSH_DEBUG_SV.log(l_module_name,'invoice_to_contact_phone', p_shipment_request_info.invoice_to_contact_phone);
136:
137: WSH_DEBUG_SV.log(l_module_name,'deliver_to_customer_id', p_shipment_request_info.deliver_to_customer_id);
138: WSH_DEBUG_SV.log(l_module_name,'deliver_to_customer_name', p_shipment_request_info.deliver_to_customer_name);
139: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address_id', p_shipment_request_info.deliver_to_address_id);
140: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address1', p_shipment_request_info.deliver_to_address1);
141: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address2', p_shipment_request_info.deliver_to_address2);
142: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address3', p_shipment_request_info.deliver_to_address3);
143: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address4', p_shipment_request_info.deliver_to_address4);

Line 140: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address1', p_shipment_request_info.deliver_to_address1);

136:
137: WSH_DEBUG_SV.log(l_module_name,'deliver_to_customer_id', p_shipment_request_info.deliver_to_customer_id);
138: WSH_DEBUG_SV.log(l_module_name,'deliver_to_customer_name', p_shipment_request_info.deliver_to_customer_name);
139: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address_id', p_shipment_request_info.deliver_to_address_id);
140: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address1', p_shipment_request_info.deliver_to_address1);
141: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address2', p_shipment_request_info.deliver_to_address2);
142: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address3', p_shipment_request_info.deliver_to_address3);
143: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address4', p_shipment_request_info.deliver_to_address4);
144: WSH_DEBUG_SV.log(l_module_name,'deliver_to_city', p_shipment_request_info.deliver_to_city);

Line 141: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address2', p_shipment_request_info.deliver_to_address2);

137: WSH_DEBUG_SV.log(l_module_name,'deliver_to_customer_id', p_shipment_request_info.deliver_to_customer_id);
138: WSH_DEBUG_SV.log(l_module_name,'deliver_to_customer_name', p_shipment_request_info.deliver_to_customer_name);
139: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address_id', p_shipment_request_info.deliver_to_address_id);
140: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address1', p_shipment_request_info.deliver_to_address1);
141: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address2', p_shipment_request_info.deliver_to_address2);
142: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address3', p_shipment_request_info.deliver_to_address3);
143: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address4', p_shipment_request_info.deliver_to_address4);
144: WSH_DEBUG_SV.log(l_module_name,'deliver_to_city', p_shipment_request_info.deliver_to_city);
145: WSH_DEBUG_SV.log(l_module_name,'deliver_to_state', p_shipment_request_info.deliver_to_state);

Line 142: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address3', p_shipment_request_info.deliver_to_address3);

138: WSH_DEBUG_SV.log(l_module_name,'deliver_to_customer_name', p_shipment_request_info.deliver_to_customer_name);
139: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address_id', p_shipment_request_info.deliver_to_address_id);
140: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address1', p_shipment_request_info.deliver_to_address1);
141: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address2', p_shipment_request_info.deliver_to_address2);
142: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address3', p_shipment_request_info.deliver_to_address3);
143: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address4', p_shipment_request_info.deliver_to_address4);
144: WSH_DEBUG_SV.log(l_module_name,'deliver_to_city', p_shipment_request_info.deliver_to_city);
145: WSH_DEBUG_SV.log(l_module_name,'deliver_to_state', p_shipment_request_info.deliver_to_state);
146: WSH_DEBUG_SV.log(l_module_name,'deliver_to_country', p_shipment_request_info.deliver_to_country);

Line 143: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address4', p_shipment_request_info.deliver_to_address4);

139: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address_id', p_shipment_request_info.deliver_to_address_id);
140: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address1', p_shipment_request_info.deliver_to_address1);
141: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address2', p_shipment_request_info.deliver_to_address2);
142: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address3', p_shipment_request_info.deliver_to_address3);
143: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address4', p_shipment_request_info.deliver_to_address4);
144: WSH_DEBUG_SV.log(l_module_name,'deliver_to_city', p_shipment_request_info.deliver_to_city);
145: WSH_DEBUG_SV.log(l_module_name,'deliver_to_state', p_shipment_request_info.deliver_to_state);
146: WSH_DEBUG_SV.log(l_module_name,'deliver_to_country', p_shipment_request_info.deliver_to_country);
147: WSH_DEBUG_SV.log(l_module_name,'deliver_to_postal_code', p_shipment_request_info.deliver_to_postal_code);

Line 144: WSH_DEBUG_SV.log(l_module_name,'deliver_to_city', p_shipment_request_info.deliver_to_city);

140: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address1', p_shipment_request_info.deliver_to_address1);
141: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address2', p_shipment_request_info.deliver_to_address2);
142: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address3', p_shipment_request_info.deliver_to_address3);
143: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address4', p_shipment_request_info.deliver_to_address4);
144: WSH_DEBUG_SV.log(l_module_name,'deliver_to_city', p_shipment_request_info.deliver_to_city);
145: WSH_DEBUG_SV.log(l_module_name,'deliver_to_state', p_shipment_request_info.deliver_to_state);
146: WSH_DEBUG_SV.log(l_module_name,'deliver_to_country', p_shipment_request_info.deliver_to_country);
147: WSH_DEBUG_SV.log(l_module_name,'deliver_to_postal_code', p_shipment_request_info.deliver_to_postal_code);
148: WSH_DEBUG_SV.log(l_module_name,'deliver_to_contact_id', p_shipment_request_info.deliver_to_contact_id);

Line 145: WSH_DEBUG_SV.log(l_module_name,'deliver_to_state', p_shipment_request_info.deliver_to_state);

141: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address2', p_shipment_request_info.deliver_to_address2);
142: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address3', p_shipment_request_info.deliver_to_address3);
143: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address4', p_shipment_request_info.deliver_to_address4);
144: WSH_DEBUG_SV.log(l_module_name,'deliver_to_city', p_shipment_request_info.deliver_to_city);
145: WSH_DEBUG_SV.log(l_module_name,'deliver_to_state', p_shipment_request_info.deliver_to_state);
146: WSH_DEBUG_SV.log(l_module_name,'deliver_to_country', p_shipment_request_info.deliver_to_country);
147: WSH_DEBUG_SV.log(l_module_name,'deliver_to_postal_code', p_shipment_request_info.deliver_to_postal_code);
148: WSH_DEBUG_SV.log(l_module_name,'deliver_to_contact_id', p_shipment_request_info.deliver_to_contact_id);
149: WSH_DEBUG_SV.log(l_module_name,'deliver_to_contact_name', p_shipment_request_info.deliver_to_contact_name);

Line 146: WSH_DEBUG_SV.log(l_module_name,'deliver_to_country', p_shipment_request_info.deliver_to_country);

142: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address3', p_shipment_request_info.deliver_to_address3);
143: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address4', p_shipment_request_info.deliver_to_address4);
144: WSH_DEBUG_SV.log(l_module_name,'deliver_to_city', p_shipment_request_info.deliver_to_city);
145: WSH_DEBUG_SV.log(l_module_name,'deliver_to_state', p_shipment_request_info.deliver_to_state);
146: WSH_DEBUG_SV.log(l_module_name,'deliver_to_country', p_shipment_request_info.deliver_to_country);
147: WSH_DEBUG_SV.log(l_module_name,'deliver_to_postal_code', p_shipment_request_info.deliver_to_postal_code);
148: WSH_DEBUG_SV.log(l_module_name,'deliver_to_contact_id', p_shipment_request_info.deliver_to_contact_id);
149: WSH_DEBUG_SV.log(l_module_name,'deliver_to_contact_name', p_shipment_request_info.deliver_to_contact_name);
150: WSH_DEBUG_SV.log(l_module_name,'deliver_to_contact_phone', p_shipment_request_info.deliver_to_contact_phone);

Line 147: WSH_DEBUG_SV.log(l_module_name,'deliver_to_postal_code', p_shipment_request_info.deliver_to_postal_code);

143: WSH_DEBUG_SV.log(l_module_name,'deliver_to_address4', p_shipment_request_info.deliver_to_address4);
144: WSH_DEBUG_SV.log(l_module_name,'deliver_to_city', p_shipment_request_info.deliver_to_city);
145: WSH_DEBUG_SV.log(l_module_name,'deliver_to_state', p_shipment_request_info.deliver_to_state);
146: WSH_DEBUG_SV.log(l_module_name,'deliver_to_country', p_shipment_request_info.deliver_to_country);
147: WSH_DEBUG_SV.log(l_module_name,'deliver_to_postal_code', p_shipment_request_info.deliver_to_postal_code);
148: WSH_DEBUG_SV.log(l_module_name,'deliver_to_contact_id', p_shipment_request_info.deliver_to_contact_id);
149: WSH_DEBUG_SV.log(l_module_name,'deliver_to_contact_name', p_shipment_request_info.deliver_to_contact_name);
150: WSH_DEBUG_SV.log(l_module_name,'deliver_to_contact_phone', p_shipment_request_info.deliver_to_contact_phone);
151:

Line 148: WSH_DEBUG_SV.log(l_module_name,'deliver_to_contact_id', p_shipment_request_info.deliver_to_contact_id);

144: WSH_DEBUG_SV.log(l_module_name,'deliver_to_city', p_shipment_request_info.deliver_to_city);
145: WSH_DEBUG_SV.log(l_module_name,'deliver_to_state', p_shipment_request_info.deliver_to_state);
146: WSH_DEBUG_SV.log(l_module_name,'deliver_to_country', p_shipment_request_info.deliver_to_country);
147: WSH_DEBUG_SV.log(l_module_name,'deliver_to_postal_code', p_shipment_request_info.deliver_to_postal_code);
148: WSH_DEBUG_SV.log(l_module_name,'deliver_to_contact_id', p_shipment_request_info.deliver_to_contact_id);
149: WSH_DEBUG_SV.log(l_module_name,'deliver_to_contact_name', p_shipment_request_info.deliver_to_contact_name);
150: WSH_DEBUG_SV.log(l_module_name,'deliver_to_contact_phone', p_shipment_request_info.deliver_to_contact_phone);
151:
152: WSH_DEBUG_SV.log(l_module_name,'carrier_code', p_shipment_request_info.carrier_code);

Line 149: WSH_DEBUG_SV.log(l_module_name,'deliver_to_contact_name', p_shipment_request_info.deliver_to_contact_name);

145: WSH_DEBUG_SV.log(l_module_name,'deliver_to_state', p_shipment_request_info.deliver_to_state);
146: WSH_DEBUG_SV.log(l_module_name,'deliver_to_country', p_shipment_request_info.deliver_to_country);
147: WSH_DEBUG_SV.log(l_module_name,'deliver_to_postal_code', p_shipment_request_info.deliver_to_postal_code);
148: WSH_DEBUG_SV.log(l_module_name,'deliver_to_contact_id', p_shipment_request_info.deliver_to_contact_id);
149: WSH_DEBUG_SV.log(l_module_name,'deliver_to_contact_name', p_shipment_request_info.deliver_to_contact_name);
150: WSH_DEBUG_SV.log(l_module_name,'deliver_to_contact_phone', p_shipment_request_info.deliver_to_contact_phone);
151:
152: WSH_DEBUG_SV.log(l_module_name,'carrier_code', p_shipment_request_info.carrier_code);
153: WSH_DEBUG_SV.log(l_module_name,'service_level', p_shipment_request_info.service_level);

Line 150: WSH_DEBUG_SV.log(l_module_name,'deliver_to_contact_phone', p_shipment_request_info.deliver_to_contact_phone);

146: WSH_DEBUG_SV.log(l_module_name,'deliver_to_country', p_shipment_request_info.deliver_to_country);
147: WSH_DEBUG_SV.log(l_module_name,'deliver_to_postal_code', p_shipment_request_info.deliver_to_postal_code);
148: WSH_DEBUG_SV.log(l_module_name,'deliver_to_contact_id', p_shipment_request_info.deliver_to_contact_id);
149: WSH_DEBUG_SV.log(l_module_name,'deliver_to_contact_name', p_shipment_request_info.deliver_to_contact_name);
150: WSH_DEBUG_SV.log(l_module_name,'deliver_to_contact_phone', p_shipment_request_info.deliver_to_contact_phone);
151:
152: WSH_DEBUG_SV.log(l_module_name,'carrier_code', p_shipment_request_info.carrier_code);
153: WSH_DEBUG_SV.log(l_module_name,'service_level', p_shipment_request_info.service_level);
154: WSH_DEBUG_SV.log(l_module_name,'mode_of_transport', p_shipment_request_info.mode_of_transport);

Line 152: WSH_DEBUG_SV.log(l_module_name,'carrier_code', p_shipment_request_info.carrier_code);

148: WSH_DEBUG_SV.log(l_module_name,'deliver_to_contact_id', p_shipment_request_info.deliver_to_contact_id);
149: WSH_DEBUG_SV.log(l_module_name,'deliver_to_contact_name', p_shipment_request_info.deliver_to_contact_name);
150: WSH_DEBUG_SV.log(l_module_name,'deliver_to_contact_phone', p_shipment_request_info.deliver_to_contact_phone);
151:
152: WSH_DEBUG_SV.log(l_module_name,'carrier_code', p_shipment_request_info.carrier_code);
153: WSH_DEBUG_SV.log(l_module_name,'service_level', p_shipment_request_info.service_level);
154: WSH_DEBUG_SV.log(l_module_name,'mode_of_transport', p_shipment_request_info.mode_of_transport);
155: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code', p_shipment_request_info.freight_terms_code);
156: WSH_DEBUG_SV.log(l_module_name,'fob_code', p_shipment_request_info.fob_code);

Line 153: WSH_DEBUG_SV.log(l_module_name,'service_level', p_shipment_request_info.service_level);

149: WSH_DEBUG_SV.log(l_module_name,'deliver_to_contact_name', p_shipment_request_info.deliver_to_contact_name);
150: WSH_DEBUG_SV.log(l_module_name,'deliver_to_contact_phone', p_shipment_request_info.deliver_to_contact_phone);
151:
152: WSH_DEBUG_SV.log(l_module_name,'carrier_code', p_shipment_request_info.carrier_code);
153: WSH_DEBUG_SV.log(l_module_name,'service_level', p_shipment_request_info.service_level);
154: WSH_DEBUG_SV.log(l_module_name,'mode_of_transport', p_shipment_request_info.mode_of_transport);
155: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code', p_shipment_request_info.freight_terms_code);
156: WSH_DEBUG_SV.log(l_module_name,'fob_code', p_shipment_request_info.fob_code);
157: WSH_DEBUG_SV.log(l_module_name,'currency_code', p_shipment_request_info.currency_code);

Line 154: WSH_DEBUG_SV.log(l_module_name,'mode_of_transport', p_shipment_request_info.mode_of_transport);

150: WSH_DEBUG_SV.log(l_module_name,'deliver_to_contact_phone', p_shipment_request_info.deliver_to_contact_phone);
151:
152: WSH_DEBUG_SV.log(l_module_name,'carrier_code', p_shipment_request_info.carrier_code);
153: WSH_DEBUG_SV.log(l_module_name,'service_level', p_shipment_request_info.service_level);
154: WSH_DEBUG_SV.log(l_module_name,'mode_of_transport', p_shipment_request_info.mode_of_transport);
155: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code', p_shipment_request_info.freight_terms_code);
156: WSH_DEBUG_SV.log(l_module_name,'fob_code', p_shipment_request_info.fob_code);
157: WSH_DEBUG_SV.log(l_module_name,'currency_code', p_shipment_request_info.currency_code);
158: WSH_DEBUG_SV.log(l_module_name,'transaction_type_id', p_shipment_request_info.transaction_type_id);

Line 155: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code', p_shipment_request_info.freight_terms_code);

151:
152: WSH_DEBUG_SV.log(l_module_name,'carrier_code', p_shipment_request_info.carrier_code);
153: WSH_DEBUG_SV.log(l_module_name,'service_level', p_shipment_request_info.service_level);
154: WSH_DEBUG_SV.log(l_module_name,'mode_of_transport', p_shipment_request_info.mode_of_transport);
155: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code', p_shipment_request_info.freight_terms_code);
156: WSH_DEBUG_SV.log(l_module_name,'fob_code', p_shipment_request_info.fob_code);
157: WSH_DEBUG_SV.log(l_module_name,'currency_code', p_shipment_request_info.currency_code);
158: WSH_DEBUG_SV.log(l_module_name,'transaction_type_id', p_shipment_request_info.transaction_type_id);
159: WSH_DEBUG_SV.log(l_module_name,'price_list_id', p_shipment_request_info.price_list_id);

Line 156: WSH_DEBUG_SV.log(l_module_name,'fob_code', p_shipment_request_info.fob_code);

152: WSH_DEBUG_SV.log(l_module_name,'carrier_code', p_shipment_request_info.carrier_code);
153: WSH_DEBUG_SV.log(l_module_name,'service_level', p_shipment_request_info.service_level);
154: WSH_DEBUG_SV.log(l_module_name,'mode_of_transport', p_shipment_request_info.mode_of_transport);
155: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code', p_shipment_request_info.freight_terms_code);
156: WSH_DEBUG_SV.log(l_module_name,'fob_code', p_shipment_request_info.fob_code);
157: WSH_DEBUG_SV.log(l_module_name,'currency_code', p_shipment_request_info.currency_code);
158: WSH_DEBUG_SV.log(l_module_name,'transaction_type_id', p_shipment_request_info.transaction_type_id);
159: WSH_DEBUG_SV.log(l_module_name,'price_list_id', p_shipment_request_info.price_list_id);
160: WSH_DEBUG_SV.log(l_module_name,'client_code', p_shipment_request_info.client_code); -- LSP PROJECT

Line 157: WSH_DEBUG_SV.log(l_module_name,'currency_code', p_shipment_request_info.currency_code);

153: WSH_DEBUG_SV.log(l_module_name,'service_level', p_shipment_request_info.service_level);
154: WSH_DEBUG_SV.log(l_module_name,'mode_of_transport', p_shipment_request_info.mode_of_transport);
155: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code', p_shipment_request_info.freight_terms_code);
156: WSH_DEBUG_SV.log(l_module_name,'fob_code', p_shipment_request_info.fob_code);
157: WSH_DEBUG_SV.log(l_module_name,'currency_code', p_shipment_request_info.currency_code);
158: WSH_DEBUG_SV.log(l_module_name,'transaction_type_id', p_shipment_request_info.transaction_type_id);
159: WSH_DEBUG_SV.log(l_module_name,'price_list_id', p_shipment_request_info.price_list_id);
160: WSH_DEBUG_SV.log(l_module_name,'client_code', p_shipment_request_info.client_code); -- LSP PROJECT
161:

Line 158: WSH_DEBUG_SV.log(l_module_name,'transaction_type_id', p_shipment_request_info.transaction_type_id);

154: WSH_DEBUG_SV.log(l_module_name,'mode_of_transport', p_shipment_request_info.mode_of_transport);
155: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code', p_shipment_request_info.freight_terms_code);
156: WSH_DEBUG_SV.log(l_module_name,'fob_code', p_shipment_request_info.fob_code);
157: WSH_DEBUG_SV.log(l_module_name,'currency_code', p_shipment_request_info.currency_code);
158: WSH_DEBUG_SV.log(l_module_name,'transaction_type_id', p_shipment_request_info.transaction_type_id);
159: WSH_DEBUG_SV.log(l_module_name,'price_list_id', p_shipment_request_info.price_list_id);
160: WSH_DEBUG_SV.log(l_module_name,'client_code', p_shipment_request_info.client_code); -- LSP PROJECT
161:
162: IF p_shipment_request_info.shipment_details_tab.count>0 THEN

Line 159: WSH_DEBUG_SV.log(l_module_name,'price_list_id', p_shipment_request_info.price_list_id);

155: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code', p_shipment_request_info.freight_terms_code);
156: WSH_DEBUG_SV.log(l_module_name,'fob_code', p_shipment_request_info.fob_code);
157: WSH_DEBUG_SV.log(l_module_name,'currency_code', p_shipment_request_info.currency_code);
158: WSH_DEBUG_SV.log(l_module_name,'transaction_type_id', p_shipment_request_info.transaction_type_id);
159: WSH_DEBUG_SV.log(l_module_name,'price_list_id', p_shipment_request_info.price_list_id);
160: WSH_DEBUG_SV.log(l_module_name,'client_code', p_shipment_request_info.client_code); -- LSP PROJECT
161:
162: IF p_shipment_request_info.shipment_details_tab.count>0 THEN
163: FOR i in 1..p_shipment_request_info.shipment_details_tab.count LOOP

Line 160: WSH_DEBUG_SV.log(l_module_name,'client_code', p_shipment_request_info.client_code); -- LSP PROJECT

156: WSH_DEBUG_SV.log(l_module_name,'fob_code', p_shipment_request_info.fob_code);
157: WSH_DEBUG_SV.log(l_module_name,'currency_code', p_shipment_request_info.currency_code);
158: WSH_DEBUG_SV.log(l_module_name,'transaction_type_id', p_shipment_request_info.transaction_type_id);
159: WSH_DEBUG_SV.log(l_module_name,'price_list_id', p_shipment_request_info.price_list_id);
160: WSH_DEBUG_SV.log(l_module_name,'client_code', p_shipment_request_info.client_code); -- LSP PROJECT
161:
162: IF p_shipment_request_info.shipment_details_tab.count>0 THEN
163: FOR i in 1..p_shipment_request_info.shipment_details_tab.count LOOP
164: WSH_DEBUG_SV.logmsg(l_module_name, '===============================================');

Line 164: WSH_DEBUG_SV.logmsg(l_module_name, '===============================================');

160: WSH_DEBUG_SV.log(l_module_name,'client_code', p_shipment_request_info.client_code); -- LSP PROJECT
161:
162: IF p_shipment_request_info.shipment_details_tab.count>0 THEN
163: FOR i in 1..p_shipment_request_info.shipment_details_tab.count LOOP
164: WSH_DEBUG_SV.logmsg(l_module_name, '===============================================');
165: WSH_DEBUG_SV.logmsg(l_module_name, '| WDDI RECORD DETAILS - ' || i || ' |');
166: WSH_DEBUG_SV.logmsg(l_module_name, '===============================================');
167: WSH_DEBUG_SV.log(l_module_name,'line_number', p_shipment_request_info.shipment_details_tab(i).line_number);
168: WSH_DEBUG_SV.log(l_module_name,'item_number', p_shipment_request_info.shipment_details_tab(i).item_number);

Line 165: WSH_DEBUG_SV.logmsg(l_module_name, '| WDDI RECORD DETAILS - ' || i || ' |');

161:
162: IF p_shipment_request_info.shipment_details_tab.count>0 THEN
163: FOR i in 1..p_shipment_request_info.shipment_details_tab.count LOOP
164: WSH_DEBUG_SV.logmsg(l_module_name, '===============================================');
165: WSH_DEBUG_SV.logmsg(l_module_name, '| WDDI RECORD DETAILS - ' || i || ' |');
166: WSH_DEBUG_SV.logmsg(l_module_name, '===============================================');
167: WSH_DEBUG_SV.log(l_module_name,'line_number', p_shipment_request_info.shipment_details_tab(i).line_number);
168: WSH_DEBUG_SV.log(l_module_name,'item_number', p_shipment_request_info.shipment_details_tab(i).item_number);
169: WSH_DEBUG_SV.log(l_module_name,'inventory_item_id', p_shipment_request_info.shipment_details_tab(i).inventory_item_id);

Line 166: WSH_DEBUG_SV.logmsg(l_module_name, '===============================================');

162: IF p_shipment_request_info.shipment_details_tab.count>0 THEN
163: FOR i in 1..p_shipment_request_info.shipment_details_tab.count LOOP
164: WSH_DEBUG_SV.logmsg(l_module_name, '===============================================');
165: WSH_DEBUG_SV.logmsg(l_module_name, '| WDDI RECORD DETAILS - ' || i || ' |');
166: WSH_DEBUG_SV.logmsg(l_module_name, '===============================================');
167: WSH_DEBUG_SV.log(l_module_name,'line_number', p_shipment_request_info.shipment_details_tab(i).line_number);
168: WSH_DEBUG_SV.log(l_module_name,'item_number', p_shipment_request_info.shipment_details_tab(i).item_number);
169: WSH_DEBUG_SV.log(l_module_name,'inventory_item_id', p_shipment_request_info.shipment_details_tab(i).inventory_item_id);
170: WSH_DEBUG_SV.log(l_module_name,'item_description', p_shipment_request_info.shipment_details_tab(i).item_description);

Line 167: WSH_DEBUG_SV.log(l_module_name,'line_number', p_shipment_request_info.shipment_details_tab(i).line_number);

163: FOR i in 1..p_shipment_request_info.shipment_details_tab.count LOOP
164: WSH_DEBUG_SV.logmsg(l_module_name, '===============================================');
165: WSH_DEBUG_SV.logmsg(l_module_name, '| WDDI RECORD DETAILS - ' || i || ' |');
166: WSH_DEBUG_SV.logmsg(l_module_name, '===============================================');
167: WSH_DEBUG_SV.log(l_module_name,'line_number', p_shipment_request_info.shipment_details_tab(i).line_number);
168: WSH_DEBUG_SV.log(l_module_name,'item_number', p_shipment_request_info.shipment_details_tab(i).item_number);
169: WSH_DEBUG_SV.log(l_module_name,'inventory_item_id', p_shipment_request_info.shipment_details_tab(i).inventory_item_id);
170: WSH_DEBUG_SV.log(l_module_name,'item_description', p_shipment_request_info.shipment_details_tab(i).item_description);
171: WSH_DEBUG_SV.log(l_module_name,'requested_quantity', p_shipment_request_info.shipment_details_tab(i).requested_quantity);

Line 168: WSH_DEBUG_SV.log(l_module_name,'item_number', p_shipment_request_info.shipment_details_tab(i).item_number);

164: WSH_DEBUG_SV.logmsg(l_module_name, '===============================================');
165: WSH_DEBUG_SV.logmsg(l_module_name, '| WDDI RECORD DETAILS - ' || i || ' |');
166: WSH_DEBUG_SV.logmsg(l_module_name, '===============================================');
167: WSH_DEBUG_SV.log(l_module_name,'line_number', p_shipment_request_info.shipment_details_tab(i).line_number);
168: WSH_DEBUG_SV.log(l_module_name,'item_number', p_shipment_request_info.shipment_details_tab(i).item_number);
169: WSH_DEBUG_SV.log(l_module_name,'inventory_item_id', p_shipment_request_info.shipment_details_tab(i).inventory_item_id);
170: WSH_DEBUG_SV.log(l_module_name,'item_description', p_shipment_request_info.shipment_details_tab(i).item_description);
171: WSH_DEBUG_SV.log(l_module_name,'requested_quantity', p_shipment_request_info.shipment_details_tab(i).requested_quantity);
172: WSH_DEBUG_SV.log(l_module_name,'requested_quantity_uom', p_shipment_request_info.shipment_details_tab(i).requested_quantity_uom);

Line 169: WSH_DEBUG_SV.log(l_module_name,'inventory_item_id', p_shipment_request_info.shipment_details_tab(i).inventory_item_id);

165: WSH_DEBUG_SV.logmsg(l_module_name, '| WDDI RECORD DETAILS - ' || i || ' |');
166: WSH_DEBUG_SV.logmsg(l_module_name, '===============================================');
167: WSH_DEBUG_SV.log(l_module_name,'line_number', p_shipment_request_info.shipment_details_tab(i).line_number);
168: WSH_DEBUG_SV.log(l_module_name,'item_number', p_shipment_request_info.shipment_details_tab(i).item_number);
169: WSH_DEBUG_SV.log(l_module_name,'inventory_item_id', p_shipment_request_info.shipment_details_tab(i).inventory_item_id);
170: WSH_DEBUG_SV.log(l_module_name,'item_description', p_shipment_request_info.shipment_details_tab(i).item_description);
171: WSH_DEBUG_SV.log(l_module_name,'requested_quantity', p_shipment_request_info.shipment_details_tab(i).requested_quantity);
172: WSH_DEBUG_SV.log(l_module_name,'requested_quantity_uom', p_shipment_request_info.shipment_details_tab(i).requested_quantity_uom);
173: WSH_DEBUG_SV.log(l_module_name,'customer_item_id', p_shipment_request_info.shipment_details_tab(i).customer_item_id );

Line 170: WSH_DEBUG_SV.log(l_module_name,'item_description', p_shipment_request_info.shipment_details_tab(i).item_description);

166: WSH_DEBUG_SV.logmsg(l_module_name, '===============================================');
167: WSH_DEBUG_SV.log(l_module_name,'line_number', p_shipment_request_info.shipment_details_tab(i).line_number);
168: WSH_DEBUG_SV.log(l_module_name,'item_number', p_shipment_request_info.shipment_details_tab(i).item_number);
169: WSH_DEBUG_SV.log(l_module_name,'inventory_item_id', p_shipment_request_info.shipment_details_tab(i).inventory_item_id);
170: WSH_DEBUG_SV.log(l_module_name,'item_description', p_shipment_request_info.shipment_details_tab(i).item_description);
171: WSH_DEBUG_SV.log(l_module_name,'requested_quantity', p_shipment_request_info.shipment_details_tab(i).requested_quantity);
172: WSH_DEBUG_SV.log(l_module_name,'requested_quantity_uom', p_shipment_request_info.shipment_details_tab(i).requested_quantity_uom);
173: WSH_DEBUG_SV.log(l_module_name,'customer_item_id', p_shipment_request_info.shipment_details_tab(i).customer_item_id );
174: WSH_DEBUG_SV.log(l_module_name,'customer_item_number', p_shipment_request_info.shipment_details_tab(i).customer_item_number);

Line 171: WSH_DEBUG_SV.log(l_module_name,'requested_quantity', p_shipment_request_info.shipment_details_tab(i).requested_quantity);

167: WSH_DEBUG_SV.log(l_module_name,'line_number', p_shipment_request_info.shipment_details_tab(i).line_number);
168: WSH_DEBUG_SV.log(l_module_name,'item_number', p_shipment_request_info.shipment_details_tab(i).item_number);
169: WSH_DEBUG_SV.log(l_module_name,'inventory_item_id', p_shipment_request_info.shipment_details_tab(i).inventory_item_id);
170: WSH_DEBUG_SV.log(l_module_name,'item_description', p_shipment_request_info.shipment_details_tab(i).item_description);
171: WSH_DEBUG_SV.log(l_module_name,'requested_quantity', p_shipment_request_info.shipment_details_tab(i).requested_quantity);
172: WSH_DEBUG_SV.log(l_module_name,'requested_quantity_uom', p_shipment_request_info.shipment_details_tab(i).requested_quantity_uom);
173: WSH_DEBUG_SV.log(l_module_name,'customer_item_id', p_shipment_request_info.shipment_details_tab(i).customer_item_id );
174: WSH_DEBUG_SV.log(l_module_name,'customer_item_number', p_shipment_request_info.shipment_details_tab(i).customer_item_number);
175: WSH_DEBUG_SV.log(l_module_name,'date_requested', p_shipment_request_info.shipment_details_tab(i).date_requested);

Line 172: WSH_DEBUG_SV.log(l_module_name,'requested_quantity_uom', p_shipment_request_info.shipment_details_tab(i).requested_quantity_uom);

168: WSH_DEBUG_SV.log(l_module_name,'item_number', p_shipment_request_info.shipment_details_tab(i).item_number);
169: WSH_DEBUG_SV.log(l_module_name,'inventory_item_id', p_shipment_request_info.shipment_details_tab(i).inventory_item_id);
170: WSH_DEBUG_SV.log(l_module_name,'item_description', p_shipment_request_info.shipment_details_tab(i).item_description);
171: WSH_DEBUG_SV.log(l_module_name,'requested_quantity', p_shipment_request_info.shipment_details_tab(i).requested_quantity);
172: WSH_DEBUG_SV.log(l_module_name,'requested_quantity_uom', p_shipment_request_info.shipment_details_tab(i).requested_quantity_uom);
173: WSH_DEBUG_SV.log(l_module_name,'customer_item_id', p_shipment_request_info.shipment_details_tab(i).customer_item_id );
174: WSH_DEBUG_SV.log(l_module_name,'customer_item_number', p_shipment_request_info.shipment_details_tab(i).customer_item_number);
175: WSH_DEBUG_SV.log(l_module_name,'date_requested', p_shipment_request_info.shipment_details_tab(i).date_requested);
176: WSH_DEBUG_SV.log(l_module_name,'date_scheduled', p_shipment_request_info.shipment_details_tab(i).date_scheduled);

Line 173: WSH_DEBUG_SV.log(l_module_name,'customer_item_id', p_shipment_request_info.shipment_details_tab(i).customer_item_id );

169: WSH_DEBUG_SV.log(l_module_name,'inventory_item_id', p_shipment_request_info.shipment_details_tab(i).inventory_item_id);
170: WSH_DEBUG_SV.log(l_module_name,'item_description', p_shipment_request_info.shipment_details_tab(i).item_description);
171: WSH_DEBUG_SV.log(l_module_name,'requested_quantity', p_shipment_request_info.shipment_details_tab(i).requested_quantity);
172: WSH_DEBUG_SV.log(l_module_name,'requested_quantity_uom', p_shipment_request_info.shipment_details_tab(i).requested_quantity_uom);
173: WSH_DEBUG_SV.log(l_module_name,'customer_item_id', p_shipment_request_info.shipment_details_tab(i).customer_item_id );
174: WSH_DEBUG_SV.log(l_module_name,'customer_item_number', p_shipment_request_info.shipment_details_tab(i).customer_item_number);
175: WSH_DEBUG_SV.log(l_module_name,'date_requested', p_shipment_request_info.shipment_details_tab(i).date_requested);
176: WSH_DEBUG_SV.log(l_module_name,'date_scheduled', p_shipment_request_info.shipment_details_tab(i).date_scheduled);
177: WSH_DEBUG_SV.log(l_module_name,'ship_tolerance_above', p_shipment_request_info.shipment_details_tab(i).ship_tolerance_above);

Line 174: WSH_DEBUG_SV.log(l_module_name,'customer_item_number', p_shipment_request_info.shipment_details_tab(i).customer_item_number);

170: WSH_DEBUG_SV.log(l_module_name,'item_description', p_shipment_request_info.shipment_details_tab(i).item_description);
171: WSH_DEBUG_SV.log(l_module_name,'requested_quantity', p_shipment_request_info.shipment_details_tab(i).requested_quantity);
172: WSH_DEBUG_SV.log(l_module_name,'requested_quantity_uom', p_shipment_request_info.shipment_details_tab(i).requested_quantity_uom);
173: WSH_DEBUG_SV.log(l_module_name,'customer_item_id', p_shipment_request_info.shipment_details_tab(i).customer_item_id );
174: WSH_DEBUG_SV.log(l_module_name,'customer_item_number', p_shipment_request_info.shipment_details_tab(i).customer_item_number);
175: WSH_DEBUG_SV.log(l_module_name,'date_requested', p_shipment_request_info.shipment_details_tab(i).date_requested);
176: WSH_DEBUG_SV.log(l_module_name,'date_scheduled', p_shipment_request_info.shipment_details_tab(i).date_scheduled);
177: WSH_DEBUG_SV.log(l_module_name,'ship_tolerance_above', p_shipment_request_info.shipment_details_tab(i).ship_tolerance_above);
178: WSH_DEBUG_SV.log(l_module_name,'ship_tolerance_below', p_shipment_request_info.shipment_details_tab(i).ship_tolerance_below);

Line 175: WSH_DEBUG_SV.log(l_module_name,'date_requested', p_shipment_request_info.shipment_details_tab(i).date_requested);

171: WSH_DEBUG_SV.log(l_module_name,'requested_quantity', p_shipment_request_info.shipment_details_tab(i).requested_quantity);
172: WSH_DEBUG_SV.log(l_module_name,'requested_quantity_uom', p_shipment_request_info.shipment_details_tab(i).requested_quantity_uom);
173: WSH_DEBUG_SV.log(l_module_name,'customer_item_id', p_shipment_request_info.shipment_details_tab(i).customer_item_id );
174: WSH_DEBUG_SV.log(l_module_name,'customer_item_number', p_shipment_request_info.shipment_details_tab(i).customer_item_number);
175: WSH_DEBUG_SV.log(l_module_name,'date_requested', p_shipment_request_info.shipment_details_tab(i).date_requested);
176: WSH_DEBUG_SV.log(l_module_name,'date_scheduled', p_shipment_request_info.shipment_details_tab(i).date_scheduled);
177: WSH_DEBUG_SV.log(l_module_name,'ship_tolerance_above', p_shipment_request_info.shipment_details_tab(i).ship_tolerance_above);
178: WSH_DEBUG_SV.log(l_module_name,'ship_tolerance_below', p_shipment_request_info.shipment_details_tab(i).ship_tolerance_below);
179: WSH_DEBUG_SV.log(l_module_name,'packing_instructions', p_shipment_request_info.shipment_details_tab(i).packing_instructions);

Line 176: WSH_DEBUG_SV.log(l_module_name,'date_scheduled', p_shipment_request_info.shipment_details_tab(i).date_scheduled);

172: WSH_DEBUG_SV.log(l_module_name,'requested_quantity_uom', p_shipment_request_info.shipment_details_tab(i).requested_quantity_uom);
173: WSH_DEBUG_SV.log(l_module_name,'customer_item_id', p_shipment_request_info.shipment_details_tab(i).customer_item_id );
174: WSH_DEBUG_SV.log(l_module_name,'customer_item_number', p_shipment_request_info.shipment_details_tab(i).customer_item_number);
175: WSH_DEBUG_SV.log(l_module_name,'date_requested', p_shipment_request_info.shipment_details_tab(i).date_requested);
176: WSH_DEBUG_SV.log(l_module_name,'date_scheduled', p_shipment_request_info.shipment_details_tab(i).date_scheduled);
177: WSH_DEBUG_SV.log(l_module_name,'ship_tolerance_above', p_shipment_request_info.shipment_details_tab(i).ship_tolerance_above);
178: WSH_DEBUG_SV.log(l_module_name,'ship_tolerance_below', p_shipment_request_info.shipment_details_tab(i).ship_tolerance_below);
179: WSH_DEBUG_SV.log(l_module_name,'packing_instructions', p_shipment_request_info.shipment_details_tab(i).packing_instructions);
180: WSH_DEBUG_SV.log(l_module_name,'shipping_instructions', p_shipment_request_info.shipment_details_tab(i).shipping_instructions);

Line 177: WSH_DEBUG_SV.log(l_module_name,'ship_tolerance_above', p_shipment_request_info.shipment_details_tab(i).ship_tolerance_above);

173: WSH_DEBUG_SV.log(l_module_name,'customer_item_id', p_shipment_request_info.shipment_details_tab(i).customer_item_id );
174: WSH_DEBUG_SV.log(l_module_name,'customer_item_number', p_shipment_request_info.shipment_details_tab(i).customer_item_number);
175: WSH_DEBUG_SV.log(l_module_name,'date_requested', p_shipment_request_info.shipment_details_tab(i).date_requested);
176: WSH_DEBUG_SV.log(l_module_name,'date_scheduled', p_shipment_request_info.shipment_details_tab(i).date_scheduled);
177: WSH_DEBUG_SV.log(l_module_name,'ship_tolerance_above', p_shipment_request_info.shipment_details_tab(i).ship_tolerance_above);
178: WSH_DEBUG_SV.log(l_module_name,'ship_tolerance_below', p_shipment_request_info.shipment_details_tab(i).ship_tolerance_below);
179: WSH_DEBUG_SV.log(l_module_name,'packing_instructions', p_shipment_request_info.shipment_details_tab(i).packing_instructions);
180: WSH_DEBUG_SV.log(l_module_name,'shipping_instructions', p_shipment_request_info.shipment_details_tab(i).shipping_instructions);
181: WSH_DEBUG_SV.log(l_module_name,'shipment_priority_code', p_shipment_request_info.shipment_details_tab(i).shipment_priority_code);

Line 178: WSH_DEBUG_SV.log(l_module_name,'ship_tolerance_below', p_shipment_request_info.shipment_details_tab(i).ship_tolerance_below);

174: WSH_DEBUG_SV.log(l_module_name,'customer_item_number', p_shipment_request_info.shipment_details_tab(i).customer_item_number);
175: WSH_DEBUG_SV.log(l_module_name,'date_requested', p_shipment_request_info.shipment_details_tab(i).date_requested);
176: WSH_DEBUG_SV.log(l_module_name,'date_scheduled', p_shipment_request_info.shipment_details_tab(i).date_scheduled);
177: WSH_DEBUG_SV.log(l_module_name,'ship_tolerance_above', p_shipment_request_info.shipment_details_tab(i).ship_tolerance_above);
178: WSH_DEBUG_SV.log(l_module_name,'ship_tolerance_below', p_shipment_request_info.shipment_details_tab(i).ship_tolerance_below);
179: WSH_DEBUG_SV.log(l_module_name,'packing_instructions', p_shipment_request_info.shipment_details_tab(i).packing_instructions);
180: WSH_DEBUG_SV.log(l_module_name,'shipping_instructions', p_shipment_request_info.shipment_details_tab(i).shipping_instructions);
181: WSH_DEBUG_SV.log(l_module_name,'shipment_priority_code', p_shipment_request_info.shipment_details_tab(i).shipment_priority_code);
182: WSH_DEBUG_SV.log(l_module_name,'ship_set_name', p_shipment_request_info.shipment_details_tab(i).ship_set_name);

Line 179: WSH_DEBUG_SV.log(l_module_name,'packing_instructions', p_shipment_request_info.shipment_details_tab(i).packing_instructions);

175: WSH_DEBUG_SV.log(l_module_name,'date_requested', p_shipment_request_info.shipment_details_tab(i).date_requested);
176: WSH_DEBUG_SV.log(l_module_name,'date_scheduled', p_shipment_request_info.shipment_details_tab(i).date_scheduled);
177: WSH_DEBUG_SV.log(l_module_name,'ship_tolerance_above', p_shipment_request_info.shipment_details_tab(i).ship_tolerance_above);
178: WSH_DEBUG_SV.log(l_module_name,'ship_tolerance_below', p_shipment_request_info.shipment_details_tab(i).ship_tolerance_below);
179: WSH_DEBUG_SV.log(l_module_name,'packing_instructions', p_shipment_request_info.shipment_details_tab(i).packing_instructions);
180: WSH_DEBUG_SV.log(l_module_name,'shipping_instructions', p_shipment_request_info.shipment_details_tab(i).shipping_instructions);
181: WSH_DEBUG_SV.log(l_module_name,'shipment_priority_code', p_shipment_request_info.shipment_details_tab(i).shipment_priority_code);
182: WSH_DEBUG_SV.log(l_module_name,'ship_set_name', p_shipment_request_info.shipment_details_tab(i).ship_set_name);
183: WSH_DEBUG_SV.log(l_module_name,'subinventory', p_shipment_request_info.shipment_details_tab(i).subinventory );

Line 180: WSH_DEBUG_SV.log(l_module_name,'shipping_instructions', p_shipment_request_info.shipment_details_tab(i).shipping_instructions);

176: WSH_DEBUG_SV.log(l_module_name,'date_scheduled', p_shipment_request_info.shipment_details_tab(i).date_scheduled);
177: WSH_DEBUG_SV.log(l_module_name,'ship_tolerance_above', p_shipment_request_info.shipment_details_tab(i).ship_tolerance_above);
178: WSH_DEBUG_SV.log(l_module_name,'ship_tolerance_below', p_shipment_request_info.shipment_details_tab(i).ship_tolerance_below);
179: WSH_DEBUG_SV.log(l_module_name,'packing_instructions', p_shipment_request_info.shipment_details_tab(i).packing_instructions);
180: WSH_DEBUG_SV.log(l_module_name,'shipping_instructions', p_shipment_request_info.shipment_details_tab(i).shipping_instructions);
181: WSH_DEBUG_SV.log(l_module_name,'shipment_priority_code', p_shipment_request_info.shipment_details_tab(i).shipment_priority_code);
182: WSH_DEBUG_SV.log(l_module_name,'ship_set_name', p_shipment_request_info.shipment_details_tab(i).ship_set_name);
183: WSH_DEBUG_SV.log(l_module_name,'subinventory', p_shipment_request_info.shipment_details_tab(i).subinventory );
184: WSH_DEBUG_SV.log(l_module_name,'revision', p_shipment_request_info.shipment_details_tab(i).revision );

Line 181: WSH_DEBUG_SV.log(l_module_name,'shipment_priority_code', p_shipment_request_info.shipment_details_tab(i).shipment_priority_code);

177: WSH_DEBUG_SV.log(l_module_name,'ship_tolerance_above', p_shipment_request_info.shipment_details_tab(i).ship_tolerance_above);
178: WSH_DEBUG_SV.log(l_module_name,'ship_tolerance_below', p_shipment_request_info.shipment_details_tab(i).ship_tolerance_below);
179: WSH_DEBUG_SV.log(l_module_name,'packing_instructions', p_shipment_request_info.shipment_details_tab(i).packing_instructions);
180: WSH_DEBUG_SV.log(l_module_name,'shipping_instructions', p_shipment_request_info.shipment_details_tab(i).shipping_instructions);
181: WSH_DEBUG_SV.log(l_module_name,'shipment_priority_code', p_shipment_request_info.shipment_details_tab(i).shipment_priority_code);
182: WSH_DEBUG_SV.log(l_module_name,'ship_set_name', p_shipment_request_info.shipment_details_tab(i).ship_set_name);
183: WSH_DEBUG_SV.log(l_module_name,'subinventory', p_shipment_request_info.shipment_details_tab(i).subinventory );
184: WSH_DEBUG_SV.log(l_module_name,'revision', p_shipment_request_info.shipment_details_tab(i).revision );
185: WSH_DEBUG_SV.log(l_module_name,'locator_code', p_shipment_request_info.shipment_details_tab(i).locator_code );

Line 182: WSH_DEBUG_SV.log(l_module_name,'ship_set_name', p_shipment_request_info.shipment_details_tab(i).ship_set_name);

178: WSH_DEBUG_SV.log(l_module_name,'ship_tolerance_below', p_shipment_request_info.shipment_details_tab(i).ship_tolerance_below);
179: WSH_DEBUG_SV.log(l_module_name,'packing_instructions', p_shipment_request_info.shipment_details_tab(i).packing_instructions);
180: WSH_DEBUG_SV.log(l_module_name,'shipping_instructions', p_shipment_request_info.shipment_details_tab(i).shipping_instructions);
181: WSH_DEBUG_SV.log(l_module_name,'shipment_priority_code', p_shipment_request_info.shipment_details_tab(i).shipment_priority_code);
182: WSH_DEBUG_SV.log(l_module_name,'ship_set_name', p_shipment_request_info.shipment_details_tab(i).ship_set_name);
183: WSH_DEBUG_SV.log(l_module_name,'subinventory', p_shipment_request_info.shipment_details_tab(i).subinventory );
184: WSH_DEBUG_SV.log(l_module_name,'revision', p_shipment_request_info.shipment_details_tab(i).revision );
185: WSH_DEBUG_SV.log(l_module_name,'locator_code', p_shipment_request_info.shipment_details_tab(i).locator_code );
186: WSH_DEBUG_SV.log(l_module_name,'locator_id', p_shipment_request_info.shipment_details_tab(i).locator_id );

Line 183: WSH_DEBUG_SV.log(l_module_name,'subinventory', p_shipment_request_info.shipment_details_tab(i).subinventory );

179: WSH_DEBUG_SV.log(l_module_name,'packing_instructions', p_shipment_request_info.shipment_details_tab(i).packing_instructions);
180: WSH_DEBUG_SV.log(l_module_name,'shipping_instructions', p_shipment_request_info.shipment_details_tab(i).shipping_instructions);
181: WSH_DEBUG_SV.log(l_module_name,'shipment_priority_code', p_shipment_request_info.shipment_details_tab(i).shipment_priority_code);
182: WSH_DEBUG_SV.log(l_module_name,'ship_set_name', p_shipment_request_info.shipment_details_tab(i).ship_set_name);
183: WSH_DEBUG_SV.log(l_module_name,'subinventory', p_shipment_request_info.shipment_details_tab(i).subinventory );
184: WSH_DEBUG_SV.log(l_module_name,'revision', p_shipment_request_info.shipment_details_tab(i).revision );
185: WSH_DEBUG_SV.log(l_module_name,'locator_code', p_shipment_request_info.shipment_details_tab(i).locator_code );
186: WSH_DEBUG_SV.log(l_module_name,'locator_id', p_shipment_request_info.shipment_details_tab(i).locator_id );
187: WSH_DEBUG_SV.log(l_module_name,'lot_number', p_shipment_request_info.shipment_details_tab(i).lot_number );

Line 184: WSH_DEBUG_SV.log(l_module_name,'revision', p_shipment_request_info.shipment_details_tab(i).revision );

180: WSH_DEBUG_SV.log(l_module_name,'shipping_instructions', p_shipment_request_info.shipment_details_tab(i).shipping_instructions);
181: WSH_DEBUG_SV.log(l_module_name,'shipment_priority_code', p_shipment_request_info.shipment_details_tab(i).shipment_priority_code);
182: WSH_DEBUG_SV.log(l_module_name,'ship_set_name', p_shipment_request_info.shipment_details_tab(i).ship_set_name);
183: WSH_DEBUG_SV.log(l_module_name,'subinventory', p_shipment_request_info.shipment_details_tab(i).subinventory );
184: WSH_DEBUG_SV.log(l_module_name,'revision', p_shipment_request_info.shipment_details_tab(i).revision );
185: WSH_DEBUG_SV.log(l_module_name,'locator_code', p_shipment_request_info.shipment_details_tab(i).locator_code );
186: WSH_DEBUG_SV.log(l_module_name,'locator_id', p_shipment_request_info.shipment_details_tab(i).locator_id );
187: WSH_DEBUG_SV.log(l_module_name,'lot_number', p_shipment_request_info.shipment_details_tab(i).lot_number );
188: WSH_DEBUG_SV.log(l_module_name,'unit_selling_price', p_shipment_request_info.shipment_details_tab(i).unit_selling_price );

Line 185: WSH_DEBUG_SV.log(l_module_name,'locator_code', p_shipment_request_info.shipment_details_tab(i).locator_code );

181: WSH_DEBUG_SV.log(l_module_name,'shipment_priority_code', p_shipment_request_info.shipment_details_tab(i).shipment_priority_code);
182: WSH_DEBUG_SV.log(l_module_name,'ship_set_name', p_shipment_request_info.shipment_details_tab(i).ship_set_name);
183: WSH_DEBUG_SV.log(l_module_name,'subinventory', p_shipment_request_info.shipment_details_tab(i).subinventory );
184: WSH_DEBUG_SV.log(l_module_name,'revision', p_shipment_request_info.shipment_details_tab(i).revision );
185: WSH_DEBUG_SV.log(l_module_name,'locator_code', p_shipment_request_info.shipment_details_tab(i).locator_code );
186: WSH_DEBUG_SV.log(l_module_name,'locator_id', p_shipment_request_info.shipment_details_tab(i).locator_id );
187: WSH_DEBUG_SV.log(l_module_name,'lot_number', p_shipment_request_info.shipment_details_tab(i).lot_number );
188: WSH_DEBUG_SV.log(l_module_name,'unit_selling_price', p_shipment_request_info.shipment_details_tab(i).unit_selling_price );
189: WSH_DEBUG_SV.log(l_module_name,'currency_code', p_shipment_request_info.shipment_details_tab(i).currency_code );

Line 186: WSH_DEBUG_SV.log(l_module_name,'locator_id', p_shipment_request_info.shipment_details_tab(i).locator_id );

182: WSH_DEBUG_SV.log(l_module_name,'ship_set_name', p_shipment_request_info.shipment_details_tab(i).ship_set_name);
183: WSH_DEBUG_SV.log(l_module_name,'subinventory', p_shipment_request_info.shipment_details_tab(i).subinventory );
184: WSH_DEBUG_SV.log(l_module_name,'revision', p_shipment_request_info.shipment_details_tab(i).revision );
185: WSH_DEBUG_SV.log(l_module_name,'locator_code', p_shipment_request_info.shipment_details_tab(i).locator_code );
186: WSH_DEBUG_SV.log(l_module_name,'locator_id', p_shipment_request_info.shipment_details_tab(i).locator_id );
187: WSH_DEBUG_SV.log(l_module_name,'lot_number', p_shipment_request_info.shipment_details_tab(i).lot_number );
188: WSH_DEBUG_SV.log(l_module_name,'unit_selling_price', p_shipment_request_info.shipment_details_tab(i).unit_selling_price );
189: WSH_DEBUG_SV.log(l_module_name,'currency_code', p_shipment_request_info.shipment_details_tab(i).currency_code );
190: WSH_DEBUG_SV.log(l_module_name,'earliest_pickup_date', p_shipment_request_info.shipment_details_tab(i).earliest_pickup_date);

Line 187: WSH_DEBUG_SV.log(l_module_name,'lot_number', p_shipment_request_info.shipment_details_tab(i).lot_number );

183: WSH_DEBUG_SV.log(l_module_name,'subinventory', p_shipment_request_info.shipment_details_tab(i).subinventory );
184: WSH_DEBUG_SV.log(l_module_name,'revision', p_shipment_request_info.shipment_details_tab(i).revision );
185: WSH_DEBUG_SV.log(l_module_name,'locator_code', p_shipment_request_info.shipment_details_tab(i).locator_code );
186: WSH_DEBUG_SV.log(l_module_name,'locator_id', p_shipment_request_info.shipment_details_tab(i).locator_id );
187: WSH_DEBUG_SV.log(l_module_name,'lot_number', p_shipment_request_info.shipment_details_tab(i).lot_number );
188: WSH_DEBUG_SV.log(l_module_name,'unit_selling_price', p_shipment_request_info.shipment_details_tab(i).unit_selling_price );
189: WSH_DEBUG_SV.log(l_module_name,'currency_code', p_shipment_request_info.shipment_details_tab(i).currency_code );
190: WSH_DEBUG_SV.log(l_module_name,'earliest_pickup_date', p_shipment_request_info.shipment_details_tab(i).earliest_pickup_date);
191: WSH_DEBUG_SV.log(l_module_name,'latest_pickup_date', p_shipment_request_info.shipment_details_tab(i).latest_pickup_date );

Line 188: WSH_DEBUG_SV.log(l_module_name,'unit_selling_price', p_shipment_request_info.shipment_details_tab(i).unit_selling_price );

184: WSH_DEBUG_SV.log(l_module_name,'revision', p_shipment_request_info.shipment_details_tab(i).revision );
185: WSH_DEBUG_SV.log(l_module_name,'locator_code', p_shipment_request_info.shipment_details_tab(i).locator_code );
186: WSH_DEBUG_SV.log(l_module_name,'locator_id', p_shipment_request_info.shipment_details_tab(i).locator_id );
187: WSH_DEBUG_SV.log(l_module_name,'lot_number', p_shipment_request_info.shipment_details_tab(i).lot_number );
188: WSH_DEBUG_SV.log(l_module_name,'unit_selling_price', p_shipment_request_info.shipment_details_tab(i).unit_selling_price );
189: WSH_DEBUG_SV.log(l_module_name,'currency_code', p_shipment_request_info.shipment_details_tab(i).currency_code );
190: WSH_DEBUG_SV.log(l_module_name,'earliest_pickup_date', p_shipment_request_info.shipment_details_tab(i).earliest_pickup_date);
191: WSH_DEBUG_SV.log(l_module_name,'latest_pickup_date', p_shipment_request_info.shipment_details_tab(i).latest_pickup_date );
192: WSH_DEBUG_SV.log(l_module_name,'earliest_dropoff_date', p_shipment_request_info.shipment_details_tab(i).earliest_dropoff_date);

Line 189: WSH_DEBUG_SV.log(l_module_name,'currency_code', p_shipment_request_info.shipment_details_tab(i).currency_code );

185: WSH_DEBUG_SV.log(l_module_name,'locator_code', p_shipment_request_info.shipment_details_tab(i).locator_code );
186: WSH_DEBUG_SV.log(l_module_name,'locator_id', p_shipment_request_info.shipment_details_tab(i).locator_id );
187: WSH_DEBUG_SV.log(l_module_name,'lot_number', p_shipment_request_info.shipment_details_tab(i).lot_number );
188: WSH_DEBUG_SV.log(l_module_name,'unit_selling_price', p_shipment_request_info.shipment_details_tab(i).unit_selling_price );
189: WSH_DEBUG_SV.log(l_module_name,'currency_code', p_shipment_request_info.shipment_details_tab(i).currency_code );
190: WSH_DEBUG_SV.log(l_module_name,'earliest_pickup_date', p_shipment_request_info.shipment_details_tab(i).earliest_pickup_date);
191: WSH_DEBUG_SV.log(l_module_name,'latest_pickup_date', p_shipment_request_info.shipment_details_tab(i).latest_pickup_date );
192: WSH_DEBUG_SV.log(l_module_name,'earliest_dropoff_date', p_shipment_request_info.shipment_details_tab(i).earliest_dropoff_date);
193: WSH_DEBUG_SV.log(l_module_name,'latest_dropoff_date', p_shipment_request_info.shipment_details_tab(i).latest_dropoff_date);

Line 190: WSH_DEBUG_SV.log(l_module_name,'earliest_pickup_date', p_shipment_request_info.shipment_details_tab(i).earliest_pickup_date);

186: WSH_DEBUG_SV.log(l_module_name,'locator_id', p_shipment_request_info.shipment_details_tab(i).locator_id );
187: WSH_DEBUG_SV.log(l_module_name,'lot_number', p_shipment_request_info.shipment_details_tab(i).lot_number );
188: WSH_DEBUG_SV.log(l_module_name,'unit_selling_price', p_shipment_request_info.shipment_details_tab(i).unit_selling_price );
189: WSH_DEBUG_SV.log(l_module_name,'currency_code', p_shipment_request_info.shipment_details_tab(i).currency_code );
190: WSH_DEBUG_SV.log(l_module_name,'earliest_pickup_date', p_shipment_request_info.shipment_details_tab(i).earliest_pickup_date);
191: WSH_DEBUG_SV.log(l_module_name,'latest_pickup_date', p_shipment_request_info.shipment_details_tab(i).latest_pickup_date );
192: WSH_DEBUG_SV.log(l_module_name,'earliest_dropoff_date', p_shipment_request_info.shipment_details_tab(i).earliest_dropoff_date);
193: WSH_DEBUG_SV.log(l_module_name,'latest_dropoff_date', p_shipment_request_info.shipment_details_tab(i).latest_dropoff_date);
194: WSH_DEBUG_SV.log(l_module_name,'cust_po_number', p_shipment_request_info.shipment_details_tab(i).cust_po_number);

Line 191: WSH_DEBUG_SV.log(l_module_name,'latest_pickup_date', p_shipment_request_info.shipment_details_tab(i).latest_pickup_date );

187: WSH_DEBUG_SV.log(l_module_name,'lot_number', p_shipment_request_info.shipment_details_tab(i).lot_number );
188: WSH_DEBUG_SV.log(l_module_name,'unit_selling_price', p_shipment_request_info.shipment_details_tab(i).unit_selling_price );
189: WSH_DEBUG_SV.log(l_module_name,'currency_code', p_shipment_request_info.shipment_details_tab(i).currency_code );
190: WSH_DEBUG_SV.log(l_module_name,'earliest_pickup_date', p_shipment_request_info.shipment_details_tab(i).earliest_pickup_date);
191: WSH_DEBUG_SV.log(l_module_name,'latest_pickup_date', p_shipment_request_info.shipment_details_tab(i).latest_pickup_date );
192: WSH_DEBUG_SV.log(l_module_name,'earliest_dropoff_date', p_shipment_request_info.shipment_details_tab(i).earliest_dropoff_date);
193: WSH_DEBUG_SV.log(l_module_name,'latest_dropoff_date', p_shipment_request_info.shipment_details_tab(i).latest_dropoff_date);
194: WSH_DEBUG_SV.log(l_module_name,'cust_po_number', p_shipment_request_info.shipment_details_tab(i).cust_po_number);
195: WSH_DEBUG_SV.log(l_module_name,'source_header_number', p_shipment_request_info.shipment_details_tab(i).source_header_number);

Line 192: WSH_DEBUG_SV.log(l_module_name,'earliest_dropoff_date', p_shipment_request_info.shipment_details_tab(i).earliest_dropoff_date);

188: WSH_DEBUG_SV.log(l_module_name,'unit_selling_price', p_shipment_request_info.shipment_details_tab(i).unit_selling_price );
189: WSH_DEBUG_SV.log(l_module_name,'currency_code', p_shipment_request_info.shipment_details_tab(i).currency_code );
190: WSH_DEBUG_SV.log(l_module_name,'earliest_pickup_date', p_shipment_request_info.shipment_details_tab(i).earliest_pickup_date);
191: WSH_DEBUG_SV.log(l_module_name,'latest_pickup_date', p_shipment_request_info.shipment_details_tab(i).latest_pickup_date );
192: WSH_DEBUG_SV.log(l_module_name,'earliest_dropoff_date', p_shipment_request_info.shipment_details_tab(i).earliest_dropoff_date);
193: WSH_DEBUG_SV.log(l_module_name,'latest_dropoff_date', p_shipment_request_info.shipment_details_tab(i).latest_dropoff_date);
194: WSH_DEBUG_SV.log(l_module_name,'cust_po_number', p_shipment_request_info.shipment_details_tab(i).cust_po_number);
195: WSH_DEBUG_SV.log(l_module_name,'source_header_number', p_shipment_request_info.shipment_details_tab(i).source_header_number);
196: WSH_DEBUG_SV.log(l_module_name,'src_requested_quantity', p_shipment_request_info.shipment_details_tab(i).src_requested_quantity);

Line 193: WSH_DEBUG_SV.log(l_module_name,'latest_dropoff_date', p_shipment_request_info.shipment_details_tab(i).latest_dropoff_date);

189: WSH_DEBUG_SV.log(l_module_name,'currency_code', p_shipment_request_info.shipment_details_tab(i).currency_code );
190: WSH_DEBUG_SV.log(l_module_name,'earliest_pickup_date', p_shipment_request_info.shipment_details_tab(i).earliest_pickup_date);
191: WSH_DEBUG_SV.log(l_module_name,'latest_pickup_date', p_shipment_request_info.shipment_details_tab(i).latest_pickup_date );
192: WSH_DEBUG_SV.log(l_module_name,'earliest_dropoff_date', p_shipment_request_info.shipment_details_tab(i).earliest_dropoff_date);
193: WSH_DEBUG_SV.log(l_module_name,'latest_dropoff_date', p_shipment_request_info.shipment_details_tab(i).latest_dropoff_date);
194: WSH_DEBUG_SV.log(l_module_name,'cust_po_number', p_shipment_request_info.shipment_details_tab(i).cust_po_number);
195: WSH_DEBUG_SV.log(l_module_name,'source_header_number', p_shipment_request_info.shipment_details_tab(i).source_header_number);
196: WSH_DEBUG_SV.log(l_module_name,'src_requested_quantity', p_shipment_request_info.shipment_details_tab(i).src_requested_quantity);
197: WSH_DEBUG_SV.log(l_module_name,'src_requested_quantity_uom', p_shipment_request_info.shipment_details_tab(i).src_requested_quantity_uom);

Line 194: WSH_DEBUG_SV.log(l_module_name,'cust_po_number', p_shipment_request_info.shipment_details_tab(i).cust_po_number);

190: WSH_DEBUG_SV.log(l_module_name,'earliest_pickup_date', p_shipment_request_info.shipment_details_tab(i).earliest_pickup_date);
191: WSH_DEBUG_SV.log(l_module_name,'latest_pickup_date', p_shipment_request_info.shipment_details_tab(i).latest_pickup_date );
192: WSH_DEBUG_SV.log(l_module_name,'earliest_dropoff_date', p_shipment_request_info.shipment_details_tab(i).earliest_dropoff_date);
193: WSH_DEBUG_SV.log(l_module_name,'latest_dropoff_date', p_shipment_request_info.shipment_details_tab(i).latest_dropoff_date);
194: WSH_DEBUG_SV.log(l_module_name,'cust_po_number', p_shipment_request_info.shipment_details_tab(i).cust_po_number);
195: WSH_DEBUG_SV.log(l_module_name,'source_header_number', p_shipment_request_info.shipment_details_tab(i).source_header_number);
196: WSH_DEBUG_SV.log(l_module_name,'src_requested_quantity', p_shipment_request_info.shipment_details_tab(i).src_requested_quantity);
197: WSH_DEBUG_SV.log(l_module_name,'src_requested_quantity_uom', p_shipment_request_info.shipment_details_tab(i).src_requested_quantity_uom);
198: WSH_DEBUG_SV.log(l_module_name,'source_line_number', p_shipment_request_info.shipment_details_tab(i).source_line_number );

Line 195: WSH_DEBUG_SV.log(l_module_name,'source_header_number', p_shipment_request_info.shipment_details_tab(i).source_header_number);

191: WSH_DEBUG_SV.log(l_module_name,'latest_pickup_date', p_shipment_request_info.shipment_details_tab(i).latest_pickup_date );
192: WSH_DEBUG_SV.log(l_module_name,'earliest_dropoff_date', p_shipment_request_info.shipment_details_tab(i).earliest_dropoff_date);
193: WSH_DEBUG_SV.log(l_module_name,'latest_dropoff_date', p_shipment_request_info.shipment_details_tab(i).latest_dropoff_date);
194: WSH_DEBUG_SV.log(l_module_name,'cust_po_number', p_shipment_request_info.shipment_details_tab(i).cust_po_number);
195: WSH_DEBUG_SV.log(l_module_name,'source_header_number', p_shipment_request_info.shipment_details_tab(i).source_header_number);
196: WSH_DEBUG_SV.log(l_module_name,'src_requested_quantity', p_shipment_request_info.shipment_details_tab(i).src_requested_quantity);
197: WSH_DEBUG_SV.log(l_module_name,'src_requested_quantity_uom', p_shipment_request_info.shipment_details_tab(i).src_requested_quantity_uom);
198: WSH_DEBUG_SV.log(l_module_name,'source_line_number', p_shipment_request_info.shipment_details_tab(i).source_line_number );
199: END LOOP;

Line 196: WSH_DEBUG_SV.log(l_module_name,'src_requested_quantity', p_shipment_request_info.shipment_details_tab(i).src_requested_quantity);

192: WSH_DEBUG_SV.log(l_module_name,'earliest_dropoff_date', p_shipment_request_info.shipment_details_tab(i).earliest_dropoff_date);
193: WSH_DEBUG_SV.log(l_module_name,'latest_dropoff_date', p_shipment_request_info.shipment_details_tab(i).latest_dropoff_date);
194: WSH_DEBUG_SV.log(l_module_name,'cust_po_number', p_shipment_request_info.shipment_details_tab(i).cust_po_number);
195: WSH_DEBUG_SV.log(l_module_name,'source_header_number', p_shipment_request_info.shipment_details_tab(i).source_header_number);
196: WSH_DEBUG_SV.log(l_module_name,'src_requested_quantity', p_shipment_request_info.shipment_details_tab(i).src_requested_quantity);
197: WSH_DEBUG_SV.log(l_module_name,'src_requested_quantity_uom', p_shipment_request_info.shipment_details_tab(i).src_requested_quantity_uom);
198: WSH_DEBUG_SV.log(l_module_name,'source_line_number', p_shipment_request_info.shipment_details_tab(i).source_line_number );
199: END LOOP;
200: END IF;

Line 197: WSH_DEBUG_SV.log(l_module_name,'src_requested_quantity_uom', p_shipment_request_info.shipment_details_tab(i).src_requested_quantity_uom);

193: WSH_DEBUG_SV.log(l_module_name,'latest_dropoff_date', p_shipment_request_info.shipment_details_tab(i).latest_dropoff_date);
194: WSH_DEBUG_SV.log(l_module_name,'cust_po_number', p_shipment_request_info.shipment_details_tab(i).cust_po_number);
195: WSH_DEBUG_SV.log(l_module_name,'source_header_number', p_shipment_request_info.shipment_details_tab(i).source_header_number);
196: WSH_DEBUG_SV.log(l_module_name,'src_requested_quantity', p_shipment_request_info.shipment_details_tab(i).src_requested_quantity);
197: WSH_DEBUG_SV.log(l_module_name,'src_requested_quantity_uom', p_shipment_request_info.shipment_details_tab(i).src_requested_quantity_uom);
198: WSH_DEBUG_SV.log(l_module_name,'source_line_number', p_shipment_request_info.shipment_details_tab(i).source_line_number );
199: END LOOP;
200: END IF;
201:

Line 198: WSH_DEBUG_SV.log(l_module_name,'source_line_number', p_shipment_request_info.shipment_details_tab(i).source_line_number );

194: WSH_DEBUG_SV.log(l_module_name,'cust_po_number', p_shipment_request_info.shipment_details_tab(i).cust_po_number);
195: WSH_DEBUG_SV.log(l_module_name,'source_header_number', p_shipment_request_info.shipment_details_tab(i).source_header_number);
196: WSH_DEBUG_SV.log(l_module_name,'src_requested_quantity', p_shipment_request_info.shipment_details_tab(i).src_requested_quantity);
197: WSH_DEBUG_SV.log(l_module_name,'src_requested_quantity_uom', p_shipment_request_info.shipment_details_tab(i).src_requested_quantity_uom);
198: WSH_DEBUG_SV.log(l_module_name,'source_line_number', p_shipment_request_info.shipment_details_tab(i).source_line_number );
199: END LOOP;
200: END IF;
201:
202: END IF;

Line 213: WSH_DEBUG_SV.log(l_module_name, 'Mandatory input parameters have not been passed');

209: fnd_message.set_token('ATTRIBUTE','DOCUMENT_NUMBER and DOCUMENT_REVISION');
210: wsh_util_core.add_message(x_return_status);
211:
212: IF l_debug_on THEN
213: WSH_DEBUG_SV.log(l_module_name, 'Mandatory input parameters have not been passed');
214: END IF;
215: END IF;
216:
217: IF p_shipment_request_info.Document_Number <= 0 OR

Line 242: WSH_DEBUG_SV.log(l_module_name,'Action Type should be A or C or D. Action type',p_shipment_request_info.ACTION_TYPE);

238: fnd_message.set_name('WSH', 'WSH_OI_INVALID_ATTRIBUTE');
239: fnd_message.set_token('ATTRIBUTE', 'ACTION_TYPE');
240: wsh_util_core.add_message(x_return_status);
241: IF l_debug_on THEN
242: WSH_DEBUG_SV.log(l_module_name,'Action Type should be A or C or D. Action type',p_shipment_request_info.ACTION_TYPE);
243: END IF;
244: l_invalid_inputs := 1;
245: END IF;
246:

Line 254: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling Create_Shipment_Request with SHIPMENT_REQUEST', WSH_DEBUG_SV.C_PROC_LEVEL);

250:
251: IF p_action_code = 'CREATE' THEN
252: --
253: IF l_debug_on THEN
254: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling Create_Shipment_Request with SHIPMENT_REQUEST', WSH_DEBUG_SV.C_PROC_LEVEL);
255: END IF;
256: --
257: Create_Shipment_Request(p_shipment_request_info => p_shipment_request_info,
258: p_caller => 'SHIPMENT_REQUEST',

Line 263: WSH_DEBUG_SV.logmsg(l_module_name, 'The Action '||p_action_code||' failed');

259: x_return_status => l_return_status);
260:
261: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
262: IF l_debug_on THEN
263: WSH_DEBUG_SV.logmsg(l_module_name, 'The Action '||p_action_code||' failed');
264: END IF;
265: x_return_status := l_return_status;
266: RAISE FND_API.G_EXC_ERROR;
267: END IF;

Line 273: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling Query_Shipment_Request', WSH_DEBUG_SV.C_PROC_LEVEL);

269:
270: ELSIF p_action_code = 'QUERY' THEN
271: --
272: IF l_debug_on THEN
273: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling Query_Shipment_Request', WSH_DEBUG_SV.C_PROC_LEVEL);
274: END IF;
275: --
276: Query_Shipment_Request(p_shipment_request_info => p_shipment_request_info,
277: x_interface_errors_info => x_interface_errors_info ,

Line 281: WSH_DEBUG_SV.logmsg(l_module_name, 'The Action '||p_action_code||' failed');

277: x_interface_errors_info => x_interface_errors_info ,
278: x_return_status => l_return_status);
279: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
280: IF l_debug_on THEN
281: WSH_DEBUG_SV.logmsg(l_module_name, 'The Action '||p_action_code||' failed');
282: END IF;
283: x_return_status := l_return_status;
284: RAISE FND_API.G_EXC_ERROR;
285: END IF;

Line 290: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling Update_Delete_Shipment_Request', WSH_DEBUG_SV.C_PROC_LEVEL);

286:
287: ELSIF p_action_code = 'UPDATE' OR p_action_code ='DELETE' THEN
288: --
289: IF l_debug_on THEN
290: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling Update_Delete_Shipment_Request', WSH_DEBUG_SV.C_PROC_LEVEL);
291: END IF;
292: --
293: Update_Delete_Shipment_Request(
294: p_action_code => p_action_code,

Line 299: WSH_DEBUG_SV.logmsg(l_module_name, 'The Action '||p_action_code||' failed');

295: p_shipment_request_info => p_shipment_request_info,
296: x_return_status => l_return_status);
297: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
298: IF l_debug_on THEN
299: WSH_DEBUG_SV.logmsg(l_module_name, 'The Action '||p_action_code||' failed');
300: END IF;
301: x_return_status := l_return_status;
302: RAISE FND_API.G_EXC_ERROR;
303: END IF;

Line 310: WSH_DEBUG_SV.log(l_module_name, 'p_action_code should be CREATE/QUERY/UPDATE/DELETE.The current value is',p_action_code);

306: fnd_message.set_name('WSH', 'WSH_PUB_INVALID_ACTION');
307: fnd_message.set_token('ACTION_CODE', p_action_code);
308: wsh_util_core.add_message(x_return_status);
309: IF l_debug_on THEN
310: WSH_DEBUG_SV.log(l_module_name, 'p_action_code should be CREATE/QUERY/UPDATE/DELETE.The current value is',p_action_code);
311: END IF;
312: RAISE FND_API.G_EXC_ERROR;
313: END IF;
314:

Line 321: WSH_DEBUG_SV.log(l_module_name, 'Return Status', x_return_status);

317: END IF;
318:
319: --
320: IF l_debug_on THEN
321: WSH_DEBUG_SV.log(l_module_name, 'Return Status', x_return_status);
322: WSH_DEBUG_SV.pop(l_module_name);
323: END IF;
324: --
325: EXCEPTION

Line 322: WSH_DEBUG_SV.pop(l_module_name);

318:
319: --
320: IF l_debug_on THEN
321: WSH_DEBUG_SV.log(l_module_name, 'Return Status', x_return_status);
322: WSH_DEBUG_SV.pop(l_module_name);
323: END IF;
324: --
325: EXCEPTION
326: WHEN FND_API.G_EXC_ERROR THEN

Line 338: WSH_DEBUG_SV.logmsg(l_module_name,'Rolling back the transactions');

334: fnd_msg_pub.count_and_get(p_count => x_msg_count,
335: p_data => x_msg_data,
336: p_encoded => fnd_api.g_false);
337: IF l_debug_on THEN
338: WSH_DEBUG_SV.logmsg(l_module_name,'Rolling back the transactions');
339: END IF;
340: rollback;
341: IF l_debug_on THEN
342: WSH_DEBUG_SV.log(l_module_name, 'Error performing the action '''|| p_action_code ||''' on Document_Number',p_shipment_request_info.Document_Number);

Line 342: WSH_DEBUG_SV.log(l_module_name, 'Error performing the action '''|| p_action_code ||''' on Document_Number',p_shipment_request_info.Document_Number);

338: WSH_DEBUG_SV.logmsg(l_module_name,'Rolling back the transactions');
339: END IF;
340: rollback;
341: IF l_debug_on THEN
342: WSH_DEBUG_SV.log(l_module_name, 'Error performing the action '''|| p_action_code ||''' on Document_Number',p_shipment_request_info.Document_Number);
343: WSH_DEBUG_SV.pop(l_module_name,'FND_API.G_EXC_ERROR');
344: END IF;
345: WHEN others THEN
346: p_shipment_request_info.delivery_interface_id := NULL;

Line 343: WSH_DEBUG_SV.pop(l_module_name,'FND_API.G_EXC_ERROR');

339: END IF;
340: rollback;
341: IF l_debug_on THEN
342: WSH_DEBUG_SV.log(l_module_name, 'Error performing the action '''|| p_action_code ||''' on Document_Number',p_shipment_request_info.Document_Number);
343: WSH_DEBUG_SV.pop(l_module_name,'FND_API.G_EXC_ERROR');
344: END IF;
345: WHEN others THEN
346: p_shipment_request_info.delivery_interface_id := NULL;
347: p_shipment_request_info.transaction_id := null;

Line 354: WSH_DEBUG_SV.logmsg(l_module_name,'Rolling back the transactions');

350: p_shipment_request_info.shipment_details_tab(i).delivery_detail_interface_id := NULL;
351: END LOOP;
352: END IF;
353: IF l_debug_on THEN
354: WSH_DEBUG_SV.logmsg(l_module_name,'Rolling back the transactions');
355: END IF;
356: rollback;
357: fnd_msg_pub.count_and_get(p_count => x_msg_count,
358: p_data => x_msg_data,

Line 362: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

358: p_data => x_msg_data,
359: p_encoded => fnd_api.g_false);
360: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
361: IF l_debug_on THEN
362: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
363: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
364: END IF;
365: END Shipment_Request;
366:

Line 363: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

359: p_encoded => fnd_api.g_false);
360: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
361: IF l_debug_on THEN
362: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
363: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
364: END IF;
365: END Shipment_Request;
366:
367: --========================================================================

Line 399: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

395: x_msg_data OUT NOCOPY VARCHAR2) AS
396:
397: l_return_status VARCHAR2(100);
398: --
399: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
400: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Process_Shipment_Requests';
401: --
402: CURSOR c_get_date(p_date1 DATE,p_date2 DATE) IS
403: SELECT to_char(p_date1,'YYYY/MM/DD HH24:MI:SS'),to_char(p_date2,'YYYY/MM/DD HH24:MI:SS') FROM DUAL;

Line 416: wsh_debug_sv.push(l_module_name);

412:
413: BEGIN
414: --
415: IF l_debug_on THEN
416: wsh_debug_sv.push(l_module_name);
417: END IF;
418: -- Standard call to check for call compatibility
419: IF NOT FND_API.Compatible_API_Call
420: ( l_api_version_number

Line 436: WSH_DEBUG_SV.log(l_module_name,'p_process_mode',p_process_mode);

432: END IF;
433:
434: IF l_debug_on THEN
435: --
436: WSH_DEBUG_SV.log(l_module_name,'p_process_mode',p_process_mode);
437: WSH_DEBUG_SV.log(l_module_name,'p_log_level',p_log_level);
438: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
439: --
440: WSH_DEBUG_SV.log(l_module_name,'p_process_mode',p_process_mode);

Line 437: WSH_DEBUG_SV.log(l_module_name,'p_log_level',p_log_level);

433:
434: IF l_debug_on THEN
435: --
436: WSH_DEBUG_SV.log(l_module_name,'p_process_mode',p_process_mode);
437: WSH_DEBUG_SV.log(l_module_name,'p_log_level',p_log_level);
438: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
439: --
440: WSH_DEBUG_SV.log(l_module_name,'p_process_mode',p_process_mode);
441: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.shipment_request_status',p_criteria_info.shipment_request_status);

Line 438: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);

434: IF l_debug_on THEN
435: --
436: WSH_DEBUG_SV.log(l_module_name,'p_process_mode',p_process_mode);
437: WSH_DEBUG_SV.log(l_module_name,'p_log_level',p_log_level);
438: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
439: --
440: WSH_DEBUG_SV.log(l_module_name,'p_process_mode',p_process_mode);
441: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.shipment_request_status',p_criteria_info.shipment_request_status);
442: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.from_shipment_request_number',p_criteria_info.from_shipment_request_number);

Line 440: WSH_DEBUG_SV.log(l_module_name,'p_process_mode',p_process_mode);

436: WSH_DEBUG_SV.log(l_module_name,'p_process_mode',p_process_mode);
437: WSH_DEBUG_SV.log(l_module_name,'p_log_level',p_log_level);
438: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
439: --
440: WSH_DEBUG_SV.log(l_module_name,'p_process_mode',p_process_mode);
441: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.shipment_request_status',p_criteria_info.shipment_request_status);
442: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.from_shipment_request_number',p_criteria_info.from_shipment_request_number);
443: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.to_shipment_request_number',p_criteria_info.to_shipment_request_number);
444: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.from_shipment_request_date',p_criteria_info.from_shipment_request_date);

Line 441: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.shipment_request_status',p_criteria_info.shipment_request_status);

437: WSH_DEBUG_SV.log(l_module_name,'p_log_level',p_log_level);
438: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
439: --
440: WSH_DEBUG_SV.log(l_module_name,'p_process_mode',p_process_mode);
441: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.shipment_request_status',p_criteria_info.shipment_request_status);
442: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.from_shipment_request_number',p_criteria_info.from_shipment_request_number);
443: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.to_shipment_request_number',p_criteria_info.to_shipment_request_number);
444: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.from_shipment_request_date',p_criteria_info.from_shipment_request_date);
445: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.to_shipment_request_date',p_criteria_info.to_shipment_request_date);

Line 442: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.from_shipment_request_number',p_criteria_info.from_shipment_request_number);

438: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
439: --
440: WSH_DEBUG_SV.log(l_module_name,'p_process_mode',p_process_mode);
441: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.shipment_request_status',p_criteria_info.shipment_request_status);
442: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.from_shipment_request_number',p_criteria_info.from_shipment_request_number);
443: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.to_shipment_request_number',p_criteria_info.to_shipment_request_number);
444: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.from_shipment_request_date',p_criteria_info.from_shipment_request_date);
445: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.to_shipment_request_date',p_criteria_info.to_shipment_request_date);
446: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.transaction_id',p_criteria_info.transaction_id);

Line 443: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.to_shipment_request_number',p_criteria_info.to_shipment_request_number);

439: --
440: WSH_DEBUG_SV.log(l_module_name,'p_process_mode',p_process_mode);
441: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.shipment_request_status',p_criteria_info.shipment_request_status);
442: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.from_shipment_request_number',p_criteria_info.from_shipment_request_number);
443: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.to_shipment_request_number',p_criteria_info.to_shipment_request_number);
444: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.from_shipment_request_date',p_criteria_info.from_shipment_request_date);
445: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.to_shipment_request_date',p_criteria_info.to_shipment_request_date);
446: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.transaction_id',p_criteria_info.transaction_id);
447: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.client_code',p_criteria_info.client_code); -- LSP PROJECT

Line 444: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.from_shipment_request_date',p_criteria_info.from_shipment_request_date);

440: WSH_DEBUG_SV.log(l_module_name,'p_process_mode',p_process_mode);
441: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.shipment_request_status',p_criteria_info.shipment_request_status);
442: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.from_shipment_request_number',p_criteria_info.from_shipment_request_number);
443: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.to_shipment_request_number',p_criteria_info.to_shipment_request_number);
444: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.from_shipment_request_date',p_criteria_info.from_shipment_request_date);
445: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.to_shipment_request_date',p_criteria_info.to_shipment_request_date);
446: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.transaction_id',p_criteria_info.transaction_id);
447: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.client_code',p_criteria_info.client_code); -- LSP PROJECT
448: END IF;

Line 445: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.to_shipment_request_date',p_criteria_info.to_shipment_request_date);

441: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.shipment_request_status',p_criteria_info.shipment_request_status);
442: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.from_shipment_request_number',p_criteria_info.from_shipment_request_number);
443: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.to_shipment_request_number',p_criteria_info.to_shipment_request_number);
444: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.from_shipment_request_date',p_criteria_info.from_shipment_request_date);
445: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.to_shipment_request_date',p_criteria_info.to_shipment_request_date);
446: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.transaction_id',p_criteria_info.transaction_id);
447: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.client_code',p_criteria_info.client_code); -- LSP PROJECT
448: END IF;
449: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 446: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.transaction_id',p_criteria_info.transaction_id);

442: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.from_shipment_request_number',p_criteria_info.from_shipment_request_number);
443: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.to_shipment_request_number',p_criteria_info.to_shipment_request_number);
444: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.from_shipment_request_date',p_criteria_info.from_shipment_request_date);
445: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.to_shipment_request_date',p_criteria_info.to_shipment_request_date);
446: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.transaction_id',p_criteria_info.transaction_id);
447: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.client_code',p_criteria_info.client_code); -- LSP PROJECT
448: END IF;
449: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
450:

Line 447: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.client_code',p_criteria_info.client_code); -- LSP PROJECT

443: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.to_shipment_request_number',p_criteria_info.to_shipment_request_number);
444: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.from_shipment_request_date',p_criteria_info.from_shipment_request_date);
445: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.to_shipment_request_date',p_criteria_info.to_shipment_request_date);
446: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.transaction_id',p_criteria_info.transaction_id);
447: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.client_code',p_criteria_info.client_code); -- LSP PROJECT
448: END IF;
449: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
450:
451: IF p_process_mode = 'ONLINE' THEN

Line 458: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_SHIPMENT_REQUEST_PKG.Process_Shipment_Request', WSH_DEBUG_SV.C_PROC_LEVEL);

454: CLOSE c_get_date;
455:
456: --
457: IF l_debug_on THEN
458: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_SHIPMENT_REQUEST_PKG.Process_Shipment_Request', WSH_DEBUG_SV.C_PROC_LEVEL);
459: END IF;
460: --
461: -- Passing p_commit as TRUE, irrespective of the value passed to PUBLIC API
462: -- Issue if p_commit value passed FALSE:

Line 489: WSH_DEBUG_SV.logmsg(l_module_name, 'Process_Shipment_Request completed with error');

485: ,p_data => x_msg_data);
486: ELSE
487: --
488: IF l_debug_on THEN
489: WSH_DEBUG_SV.logmsg(l_module_name, 'Process_Shipment_Request completed with error');
490: END IF;
491: --
492: x_return_status := l_return_status;
493: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_SR_PROCESS_ERROR');

Line 502: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling FND_REQUEST.SUBMIT_REQUEST', WSH_DEBUG_SV.C_PROC_LEVEL);

498:
499: ELSIF p_process_mode = 'CONCURRENT' THEN
500: --
501: IF l_debug_on THEN
502: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling FND_REQUEST.SUBMIT_REQUEST', WSH_DEBUG_SV.C_PROC_LEVEL);
503: END IF;
504: --
505: x_request_id := FND_REQUEST.SUBMIT_REQUEST(
506: application => 'WSH',

Line 521: WSH_DEBUG_SV.log(l_module_name, 'Request Id returned from FND_REQUEST.SUBMIT_REQUEST', x_request_id);

517: argument7 => p_log_level );
518:
519: --
520: IF l_debug_on THEN
521: WSH_DEBUG_SV.log(l_module_name, 'Request Id returned from FND_REQUEST.SUBMIT_REQUEST', x_request_id);
522: END IF;
523: --
524: IF (nvl(x_request_id,0) <= 0) THEN
525: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 538: WSH_DEBUG_SV.logmsg(l_module_name, 'p_process_mode should be ONLINE/CONCURRENT');

534: fnd_message.set_name('WSH', 'WSH_OI_INVALID_ATTRIBUTE');
535: fnd_message.set_token('ATTRIBUTE', 'PROCESS_MODE');
536: wsh_util_core.add_message(x_return_status);
537: IF l_debug_on THEN
538: WSH_DEBUG_SV.logmsg(l_module_name, 'p_process_mode should be ONLINE/CONCURRENT');
539: END IF;
540: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
541: raise FND_API.G_EXC_ERROR;
542: END IF;

Line 551: WSH_DEBUG_SV.log(l_module_name, 'Return Status', x_return_status);

547: fnd_msg_pub.count_and_get(p_count => x_msg_count,
548: p_data => x_msg_data,
549: p_encoded => fnd_api.g_false);
550: IF l_debug_on THEN
551: WSH_DEBUG_SV.log(l_module_name, 'Return Status', x_return_status);
552: WSH_DEBUG_SV.pop(l_module_name);
553: END IF;
554:
555: EXCEPTION

Line 552: WSH_DEBUG_SV.pop(l_module_name);

548: p_data => x_msg_data,
549: p_encoded => fnd_api.g_false);
550: IF l_debug_on THEN
551: WSH_DEBUG_SV.log(l_module_name, 'Return Status', x_return_status);
552: WSH_DEBUG_SV.pop(l_module_name);
553: END IF;
554:
555: EXCEPTION
556: WHEN FND_API.G_EXC_ERROR THEN

Line 567: WSH_DEBUG_SV.logmsg(l_module_name,'Rolling back the transactions');

563: fnd_msg_pub.count_and_get( p_encoded => 'F'
564: ,p_count => x_msg_count
565: ,p_data => x_msg_data);
566: IF l_debug_on THEN
567: WSH_DEBUG_SV.logmsg(l_module_name,'Rolling back the transactions');
568: END IF;
569: rollback;
570: IF l_debug_on THEN
571: WSH_DEBUG_SV.log(l_module_name, 'Error occured while processing Shipment Request',p_criteria_info.transaction_id);

Line 571: WSH_DEBUG_SV.log(l_module_name, 'Error occured while processing Shipment Request',p_criteria_info.transaction_id);

567: WSH_DEBUG_SV.logmsg(l_module_name,'Rolling back the transactions');
568: END IF;
569: rollback;
570: IF l_debug_on THEN
571: WSH_DEBUG_SV.log(l_module_name, 'Error occured while processing Shipment Request',p_criteria_info.transaction_id);
572: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
573: END IF;
574: WHEN others THEN
575: IF c_get_date%ISOPEN THEN

Line 572: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

568: END IF;
569: rollback;
570: IF l_debug_on THEN
571: WSH_DEBUG_SV.log(l_module_name, 'Error occured while processing Shipment Request',p_criteria_info.transaction_id);
572: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
573: END IF;
574: WHEN others THEN
575: IF c_get_date%ISOPEN THEN
576: CLOSE c_get_date;

Line 579: WSH_DEBUG_SV.logmsg(l_module_name,'Rolling back the transactions');

575: IF c_get_date%ISOPEN THEN
576: CLOSE c_get_date;
577: END IF;
578: IF l_debug_on THEN
579: WSH_DEBUG_SV.logmsg(l_module_name,'Rolling back the transactions');
580: END IF;
581: rollback;
582:
583: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 585: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

581: rollback;
582:
583: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
584: IF l_debug_on THEN
585: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
586: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
587: END IF;
588: END Process_Shipment_Requests;
589: --========================================================================

Line 586: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

582:
583: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
584: IF l_debug_on THEN
585: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
586: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
587: END IF;
588: END Process_Shipment_Requests;
589: --========================================================================
590: -- PROCEDURE : Create_Shipment_Request PRIVATE

Line 608: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

604: x_return_status OUT NOCOPY VARCHAR2) AS
605:
606: l_ins_rows NUMBER;
607: l_exists NUMBER;
608: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
609: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Create_Shipment_Request';
610:
611: l_del_det_int_tab wsh_util_core.id_tab_type;
612: --Bug8784331

Line 648: WSH_DEBUG_SV.push(l_module_name);

644: BEGIN
645:
646: --
647: IF l_debug_on THEN
648: WSH_DEBUG_SV.push(l_module_name);
649: WSH_DEBUG_SV.log(l_module_name,'Caller',p_caller);
650: END IF;
651: --
652: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 649: WSH_DEBUG_SV.log(l_module_name,'Caller',p_caller);

645:
646: --
647: IF l_debug_on THEN
648: WSH_DEBUG_SV.push(l_module_name);
649: WSH_DEBUG_SV.log(l_module_name,'Caller',p_caller);
650: END IF;
651: --
652: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
653:

Line 670: wsh_debug_sv.logmsg(l_module_name, 'The document already exists');

666: fnd_message.set_token('DOCUMENT_NUMBER', p_shipment_request_info.document_number);
667: fnd_message.set_token('DOCUMENT_REVISION', p_shipment_request_info.document_revision);
668: wsh_util_core.add_message(x_return_status);
669: IF l_debug_on THEN
670: wsh_debug_sv.logmsg(l_module_name, 'The document already exists');
671: END IF;
672: RAISE FND_API.G_EXC_ERROR;
673: END IF;
674:

Line 678: wsh_debug_sv.logmsg(l_module_name, 'Inserting into WSH_NEW_DEL_INTERFACE');

674:
675:
676: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
677: IF l_debug_on THEN
678: wsh_debug_sv.logmsg(l_module_name, 'Inserting into WSH_NEW_DEL_INTERFACE');
679: END IF;
680:
681: INSERT INTO WSH_NEW_DEL_INTERFACE(
682: DELIVERY_INTERFACE_ID,

Line 823: WSH_DEBUG_SV.log(l_module_name, 'Number of records inserted into WSH_NEW_DEL_INTERFACE',l_ins_rows);

819: )
820: RETURNING DELIVERY_INTERFACE_ID INTO p_shipment_request_info.delivery_interface_id;
821: l_ins_rows := sql%rowcount;
822: IF l_debug_on THEN
823: WSH_DEBUG_SV.log(l_module_name, 'Number of records inserted into WSH_NEW_DEL_INTERFACE',l_ins_rows);
824: WSH_DEBUG_SV.log(l_module_name, 'Number of shipment details',p_shipment_request_info.shipment_details_tab.count);
825: END IF;
826: --}
827: END IF;

Line 824: WSH_DEBUG_SV.log(l_module_name, 'Number of shipment details',p_shipment_request_info.shipment_details_tab.count);

820: RETURNING DELIVERY_INTERFACE_ID INTO p_shipment_request_info.delivery_interface_id;
821: l_ins_rows := sql%rowcount;
822: IF l_debug_on THEN
823: WSH_DEBUG_SV.log(l_module_name, 'Number of records inserted into WSH_NEW_DEL_INTERFACE',l_ins_rows);
824: WSH_DEBUG_SV.log(l_module_name, 'Number of shipment details',p_shipment_request_info.shipment_details_tab.count);
825: END IF;
826: --}
827: END IF;
828:

Line 834: wsh_debug_sv.logmsg(l_module_name, 'Inserting into WSH_DEL_DETAILS_INTERFACE and WSH_DEL_ASSGN_INTERFACE');

830: IF p_shipment_request_info.shipment_details_tab.count > 0 AND
831: p_shipment_request_info.shipment_details_tab.count < 4 THEN
832: --{
833: IF l_debug_on THEN
834: wsh_debug_sv.logmsg(l_module_name, 'Inserting into WSH_DEL_DETAILS_INTERFACE and WSH_DEL_ASSGN_INTERFACE');
835: END IF;
836:
837: FOR i IN 1..p_shipment_request_info.shipment_details_tab.count LOOP
838: --{

Line 965: wsh_debug_sv.logmsg(l_module_name, 'Done Inserting into WSH_DEL_DETAILS_INTERFACE and WSH_DEL_ASSGN_INTERFACE'||p_shipment_request_info.shipment_details_tab(i).delivery_detail_interface_id);

961: '94X_STANDALONE'
962: );
963:
964: IF l_debug_on THEN
965: wsh_debug_sv.logmsg(l_module_name, 'Done Inserting into WSH_DEL_DETAILS_INTERFACE and WSH_DEL_ASSGN_INTERFACE'||p_shipment_request_info.shipment_details_tab(i).delivery_detail_interface_id);
966: END IF;
967:
968: --}
969: END LOOP;

Line 1105: WSH_DEBUG_SV.log(l_module_name, 'Number of records inserted into WSH_DEL_DETAILS_INTERFACE',l_ins_rows );

1101: '94X_STANDALONE')
1102: RETURNING DELIVERY_DETAIL_INTERFACE_ID BULK COLLECT INTO l_del_det_int_tab;
1103: l_ins_rows := sql%rowcount;
1104: IF l_debug_on THEN
1105: WSH_DEBUG_SV.log(l_module_name, 'Number of records inserted into WSH_DEL_DETAILS_INTERFACE',l_ins_rows );
1106: END IF;
1107:
1108: FOR I IN 1..l_del_det_int_tab.Count LOOP
1109: p_shipment_request_info.shipment_details_tab(i).delivery_detail_interface_id := l_del_det_int_tab(i);

Line 1144: WSH_DEBUG_SV.log(l_module_name, 'Number of records inserted into WSH_DEL_ASSGN_INTERFACE',l_ins_rows );

1140: '94X_STANDALONE'
1141: );
1142: l_ins_rows := sql%rowcount;
1143: IF l_debug_on THEN
1144: WSH_DEBUG_SV.log(l_module_name, 'Number of records inserted into WSH_DEL_ASSGN_INTERFACE',l_ins_rows );
1145: END IF;
1146: --}
1147: END IF;--(if count >0)
1148:

Line 1151: WSH_DEBUG_SV.log(l_module_name, 'Inserting into WSH_TRANSACTIONS_HISTORY' );

1147: END IF;--(if count >0)
1148:
1149: IF p_caller = 'SHIPMENT_REQUEST' THEN
1150: IF l_debug_on THEN
1151: WSH_DEBUG_SV.log(l_module_name, 'Inserting into WSH_TRANSACTIONS_HISTORY' );
1152: END IF;
1153: INSERT INTO WSH_TRANSACTIONS_HISTORY(
1154: TRANSACTION_ID,
1155: DOCUMENT_TYPE,

Line 1198: WSH_DEBUG_SV.log(l_module_name, 'Return Status', x_return_status);

1194: RETURNING TRANSACTION_ID INTO p_shipment_request_info.transaction_id;
1195: END IF;
1196:
1197: IF l_debug_on THEN
1198: WSH_DEBUG_SV.log(l_module_name, 'Return Status', x_return_status);
1199: WSH_DEBUG_SV.pop(l_module_name);
1200: END IF;
1201: EXCEPTION
1202: WHEN FND_API.G_EXC_ERROR THEN

Line 1199: WSH_DEBUG_SV.pop(l_module_name);

1195: END IF;
1196:
1197: IF l_debug_on THEN
1198: WSH_DEBUG_SV.log(l_module_name, 'Return Status', x_return_status);
1199: WSH_DEBUG_SV.pop(l_module_name);
1200: END IF;
1201: EXCEPTION
1202: WHEN FND_API.G_EXC_ERROR THEN
1203: p_shipment_request_info.delivery_interface_id := NULL;

Line 1211: WSH_DEBUG_SV.logmsg(l_module_name,'Rolling back the transactions');

1207: p_shipment_request_info.shipment_details_tab(i).delivery_detail_interface_id := NULL;
1208: END LOOP;
1209: END IF;
1210: IF l_debug_on THEN
1211: WSH_DEBUG_SV.logmsg(l_module_name,'Rolling back the transactions');
1212: END IF;
1213: rollback;
1214: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1215: IF l_debug_on THEN

Line 1216: WSH_DEBUG_SV.log(l_module_name, 'Error occured while creating shipment request with document number and revision',p_shipment_request_info.document_number||' and '||p_shipment_request_info.document_revision);

1212: END IF;
1213: rollback;
1214: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1215: IF l_debug_on THEN
1216: WSH_DEBUG_SV.log(l_module_name, 'Error occured while creating shipment request with document number and revision',p_shipment_request_info.document_number||' and '||p_shipment_request_info.document_revision);
1217: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1218: END IF;
1219:
1220: WHEN others THEN

Line 1217: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

1213: rollback;
1214: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1215: IF l_debug_on THEN
1216: WSH_DEBUG_SV.log(l_module_name, 'Error occured while creating shipment request with document number and revision',p_shipment_request_info.document_number||' and '||p_shipment_request_info.document_revision);
1217: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1218: END IF;
1219:
1220: WHEN others THEN
1221: p_shipment_request_info.delivery_interface_id := NULL;

Line 1229: WSH_DEBUG_SV.logmsg(l_module_name,'Rolling back the transactions');

1225: p_shipment_request_info.shipment_details_tab(i).delivery_detail_interface_id := NULL;
1226: END LOOP;
1227: END IF;
1228: IF l_debug_on THEN
1229: WSH_DEBUG_SV.logmsg(l_module_name,'Rolling back the transactions');
1230: END IF;
1231: rollback;
1232: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1233: IF l_debug_on THEN

Line 1234: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1230: END IF;
1231: rollback;
1232: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1233: IF l_debug_on THEN
1234: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1235: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1236: END IF;
1237: END Create_Shipment_Request;
1238: --========================================================================

Line 1235: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

1231: rollback;
1232: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1233: IF l_debug_on THEN
1234: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1235: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1236: END IF;
1237: END Create_Shipment_Request;
1238: --========================================================================
1239: -- PROCEDURE : Query_Shipment_Request PRIVATE

Line 1382: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

1378: AND WDDI.Interface_action_code = '94X_STANDALONE';
1379:
1380: l_ins_rows NUMBER;
1381:
1382: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
1383: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Query_Shipment_Request';
1384:
1385: BEGIN
1386: --

Line 1388: WSH_DEBUG_SV.push(l_module_name);

1384:
1385: BEGIN
1386: --
1387: IF l_debug_on THEN
1388: WSH_DEBUG_SV.push(l_module_name);
1389: WSH_DEBUG_SV.log(l_module_name, 'Document Number',p_shipment_request_info.document_number);
1390: WSH_DEBUG_SV.log(l_module_name, 'Document Revision',p_shipment_request_info.document_revision);
1391: END IF;
1392: --

Line 1389: WSH_DEBUG_SV.log(l_module_name, 'Document Number',p_shipment_request_info.document_number);

1385: BEGIN
1386: --
1387: IF l_debug_on THEN
1388: WSH_DEBUG_SV.push(l_module_name);
1389: WSH_DEBUG_SV.log(l_module_name, 'Document Number',p_shipment_request_info.document_number);
1390: WSH_DEBUG_SV.log(l_module_name, 'Document Revision',p_shipment_request_info.document_revision);
1391: END IF;
1392: --
1393: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 1390: WSH_DEBUG_SV.log(l_module_name, 'Document Revision',p_shipment_request_info.document_revision);

1386: --
1387: IF l_debug_on THEN
1388: WSH_DEBUG_SV.push(l_module_name);
1389: WSH_DEBUG_SV.log(l_module_name, 'Document Number',p_shipment_request_info.document_number);
1390: WSH_DEBUG_SV.log(l_module_name, 'Document Revision',p_shipment_request_info.document_revision);
1391: END IF;
1392: --
1393: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1394: OPEN c_get_WTH_WNDI_Rec;

Line 1463: WSH_DEBUG_SV.log(l_module_name, 'No Data found');

1459: fnd_message.set_token('DOCUMENT_REVISION', p_shipment_request_info.document_revision);
1460: wsh_util_core.add_message(x_return_status);
1461:
1462: IF l_debug_on THEN
1463: WSH_DEBUG_SV.log(l_module_name, 'No Data found');
1464: END IF;
1465: RAISE FND_API.G_EXC_ERROR;
1466: END IF;
1467:

Line 1470: WSH_DEBUG_SV.log(l_module_name, 'Number of records returned from WTH and WNDI',l_ins_rows);

1466: END IF;
1467:
1468: l_ins_rows := sql%rowcount;
1469: IF l_debug_on THEN
1470: WSH_DEBUG_SV.log(l_module_name, 'Number of records returned from WTH and WNDI',l_ins_rows);
1471: END IF;
1472: CLOSE c_get_WTH_WNDI_Rec;
1473:
1474:

Line 1480: WSH_DEBUG_SV.log(l_module_name, 'Number of records returned from WDDI',l_ins_rows);

1476: FETCH c_get_WDDI_Rec BULK COLLECT INTO p_shipment_request_info.shipment_details_tab;
1477: CLOSE c_get_WDDI_Rec;
1478: l_ins_rows := sql%rowcount;
1479: IF l_debug_on THEN
1480: WSH_DEBUG_SV.log(l_module_name, 'Number of records returned from WDDI',l_ins_rows);
1481: END IF;
1482:
1483: OPEN c_get_WIE_Rec;
1484: FETCH c_get_WIE_Rec BULK COLLECT INTO x_interface_errors_info ;

Line 1488: WSH_DEBUG_SV.log(l_module_name, 'Number of records returned from WIE',l_ins_rows);

1484: FETCH c_get_WIE_Rec BULK COLLECT INTO x_interface_errors_info ;
1485: CLOSE c_get_WIE_Rec;
1486: l_ins_rows := sql%rowcount;
1487: IF l_debug_on THEN
1488: WSH_DEBUG_SV.log(l_module_name, 'Number of records returned from WIE',l_ins_rows);
1489: END IF;
1490: --
1491: IF l_debug_on THEN
1492: WSH_DEBUG_SV.log(l_module_name, 'Return Status', x_return_status);

Line 1492: WSH_DEBUG_SV.log(l_module_name, 'Return Status', x_return_status);

1488: WSH_DEBUG_SV.log(l_module_name, 'Number of records returned from WIE',l_ins_rows);
1489: END IF;
1490: --
1491: IF l_debug_on THEN
1492: WSH_DEBUG_SV.log(l_module_name, 'Return Status', x_return_status);
1493: WSH_DEBUG_SV.pop(l_module_name);
1494: END IF;
1495: --
1496:

Line 1493: WSH_DEBUG_SV.pop(l_module_name);

1489: END IF;
1490: --
1491: IF l_debug_on THEN
1492: WSH_DEBUG_SV.log(l_module_name, 'Return Status', x_return_status);
1493: WSH_DEBUG_SV.pop(l_module_name);
1494: END IF;
1495: --
1496:
1497: EXCEPTION

Line 1517: WSH_DEBUG_SV.log(l_module_name, 'Error occured while querying shipment request with document number and revision',p_shipment_request_info.document_number||' and '||p_shipment_request_info.document_revision);

1513: CLOSE c_get_WDDI_Rec;
1514: END IF;
1515: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1516: IF l_debug_on THEN
1517: WSH_DEBUG_SV.log(l_module_name, 'Error occured while querying shipment request with document number and revision',p_shipment_request_info.document_number||' and '||p_shipment_request_info.document_revision);
1518: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1519: END IF;
1520:
1521: WHEN others THEN

Line 1518: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

1514: END IF;
1515: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1516: IF l_debug_on THEN
1517: WSH_DEBUG_SV.log(l_module_name, 'Error occured while querying shipment request with document number and revision',p_shipment_request_info.document_number||' and '||p_shipment_request_info.document_revision);
1518: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1519: END IF;
1520:
1521: WHEN others THEN
1522: IF c_get_WTH_WNDI_Rec%ISOPEN THEN

Line 1540: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1536: END LOOP;
1537: END IF;
1538: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1539: IF l_debug_on THEN
1540: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1541: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1542: END IF;
1543: END Query_Shipment_Request;
1544: --========================================================================

Line 1541: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

1537: END IF;
1538: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1539: IF l_debug_on THEN
1540: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1541: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1542: END IF;
1543: END Query_Shipment_Request;
1544: --========================================================================
1545: -- PROCEDURE : Update_Delete_Shipment_Request PRIVATE

Line 1620: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

1616: --
1617: l_insert_sr_info Shipment_Request_Rec_Type;
1618: l_update_sr_info Shipment_Request_Rec_Type;
1619: --
1620: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
1621: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Update_Delete_Shipment_Request';
1622: --
1623:
1624: --

Line 1666: WSH_DEBUG_SV.push(l_module_name);

1662:
1663: BEGIN
1664:
1665: IF l_debug_on THEN
1666: WSH_DEBUG_SV.push(l_module_name);
1667: WSH_DEBUG_SV.log(l_module_name,'p_action_code',p_action_code);
1668: WSH_DEBUG_SV.log(l_module_name,'WDDI count',p_shipment_request_info.shipment_details_tab.count);
1669: END IF;
1670:

Line 1667: WSH_DEBUG_SV.log(l_module_name,'p_action_code',p_action_code);

1663: BEGIN
1664:
1665: IF l_debug_on THEN
1666: WSH_DEBUG_SV.push(l_module_name);
1667: WSH_DEBUG_SV.log(l_module_name,'p_action_code',p_action_code);
1668: WSH_DEBUG_SV.log(l_module_name,'WDDI count',p_shipment_request_info.shipment_details_tab.count);
1669: END IF;
1670:
1671:

Line 1668: WSH_DEBUG_SV.log(l_module_name,'WDDI count',p_shipment_request_info.shipment_details_tab.count);

1664:
1665: IF l_debug_on THEN
1666: WSH_DEBUG_SV.push(l_module_name);
1667: WSH_DEBUG_SV.log(l_module_name,'p_action_code',p_action_code);
1668: WSH_DEBUG_SV.log(l_module_name,'WDDI count',p_shipment_request_info.shipment_details_tab.count);
1669: END IF;
1670:
1671:
1672: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 1676: wsh_debug_sv.logmsg(l_module_name, 'Taking locks on WTH,WNDI');

1672: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1673: l_tmp_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1674:
1675: IF l_debug_on THEN
1676: wsh_debug_sv.logmsg(l_module_name, 'Taking locks on WTH,WNDI');
1677: END IF;
1678:
1679: OPEN c_get_Details_DN;
1680: FETCH c_get_Details_DN INTO l_document_number,l_document_revision,l_delivery_interface_id,l_transaction_id;

Line 1688: wsh_debug_sv.logmsg(l_module_name, 'Invalid parameters have been passed');

1684: fnd_message.set_token('DOCUMENT_NUMBER', p_shipment_request_info.document_number);
1685: fnd_message.set_token('DOCUMENT_REVISION', p_shipment_request_info.document_revision);
1686: wsh_util_core.add_message(x_return_status);
1687: IF l_debug_on THEN
1688: wsh_debug_sv.logmsg(l_module_name, 'Invalid parameters have been passed');
1689: END IF;
1690: RAISE FND_API.G_EXC_ERROR;
1691: END IF;
1692: CLOSE c_get_Details_DN;

Line 1713: wsh_debug_sv.logmsg(l_module_name, 'Line number is a mandatory parameter for delivery_detail_interface records');

1709: fnd_message.set_name('WSH', 'WSH_STND_ATTR_MANDATORY');
1710: fnd_message.set_token('ATTRIBUTE','LINE_NUMBER');
1711: wsh_util_core.add_message(x_return_status);
1712: IF l_debug_on THEN
1713: wsh_debug_sv.logmsg(l_module_name, 'Line number is a mandatory parameter for delivery_detail_interface records');
1714: END IF;
1715: RAISE FND_API.G_EXC_ERROR;
1716: END IF;
1717: IF l_debug_on THEN

Line 1718: wsh_debug_sv.logmsg(l_module_name, 'Taking locks on WDDI and WDAI for line number :'||p_shipment_request_info.shipment_details_tab(i).line_number);

1714: END IF;
1715: RAISE FND_API.G_EXC_ERROR;
1716: END IF;
1717: IF l_debug_on THEN
1718: wsh_debug_sv.logmsg(l_module_name, 'Taking locks on WDDI and WDAI for line number :'||p_shipment_request_info.shipment_details_tab(i).line_number);
1719: END IF;
1720: OPEN c_get_del_det_interface_id(p_shipment_request_info.shipment_details_tab(i).line_number);
1721: FETCH c_get_del_det_interface_id INTO l_del_det_int_tab(i);
1722: IF c_get_del_det_interface_id%NOTFOUND THEN

Line 1726: wsh_debug_sv.logmsg(l_module_name, 'line number ' || p_shipment_request_info.shipment_details_tab(i).line_number || ' does not exist, so insert into WDDI');

1722: IF c_get_del_det_interface_id%NOTFOUND THEN
1723: IF p_action_code = 'UPDATE' THEN
1724: --
1725: IF l_debug_on THEN
1726: wsh_debug_sv.logmsg(l_module_name, 'line number ' || p_shipment_request_info.shipment_details_tab(i).line_number || ' does not exist, so insert into WDDI');
1727: END IF;
1728: --
1729: l_insert_sr_info.shipment_details_tab(l_ins_count):= p_shipment_request_info.shipment_details_tab(i);
1730: l_ins_count := l_ins_count + 1;

Line 1734: wsh_debug_sv.logmsg(l_module_name, 'Error: Line number ' || p_shipment_request_info.shipment_details_tab(i).line_number || ' does not exist');

1730: l_ins_count := l_ins_count + 1;
1731: ELSE
1732: --
1733: IF l_debug_on THEN
1734: wsh_debug_sv.logmsg(l_module_name, 'Error: Line number ' || p_shipment_request_info.shipment_details_tab(i).line_number || ' does not exist');
1735: END IF;
1736: --
1737: l_tmp_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1738: fnd_message.set_name('WSH', 'WSH_STND_INVALID_DOC_LINE');

Line 1752: wsh_debug_sv.logmsg(l_module_name, 'Taking locks on WDDI and WDAI');

1748: ELSE
1749: IF p_action_code ='DELETE' THEN
1750:
1751: IF l_debug_on THEN
1752: wsh_debug_sv.logmsg(l_module_name, 'Taking locks on WDDI and WDAI');
1753: END IF;
1754:
1755: OPEN c_get_all_del_det_interface_id;
1756: FETCH c_get_all_del_det_interface_id BULK COLLECT INTO l_del_det_int_tab;

Line 1766: wsh_debug_sv.logmsg(l_module_name, 'Successfully locked records of WTH,WNDI and WDDI');

1762: RAISE FND_API.G_EXC_ERROR;
1763: END IF;
1764:
1765: IF l_debug_on THEN
1766: wsh_debug_sv.logmsg(l_module_name, 'Successfully locked records of WTH,WNDI and WDDI');
1767: END IF;
1768:
1769: IF p_action_code ='UPDATE' THEN
1770: --{

Line 1772: wsh_debug_sv.logmsg(l_module_name, 'Updating WSH_NEW_DEL_INTERFACE');

1768:
1769: IF p_action_code ='UPDATE' THEN
1770: --{
1771: IF l_debug_on THEN
1772: wsh_debug_sv.logmsg(l_module_name, 'Updating WSH_NEW_DEL_INTERFACE');
1773: END IF;
1774: UPDATE WSH_NEW_DEL_INTERFACE
1775: SET last_update_date = sysdate,
1776: last_updated_by = FND_GLOBAL.USER_ID,

Line 1840: WSH_DEBUG_SV.log(l_module_name, 'WNDI : Number of records updated',l_ins_rows);

1836: WHERE delivery_interface_id = l_delivery_interface_id;
1837:
1838: l_ins_rows := sql%rowcount;
1839: IF l_debug_on THEN
1840: WSH_DEBUG_SV.log(l_module_name, 'WNDI : Number of records updated',l_ins_rows);
1841: END IF;
1842:
1843: IF l_update_sr_info.shipment_details_tab.count > 0 AND
1844: l_update_sr_info.shipment_details_tab.count < 4 THEN

Line 1847: WSH_DEBUG_SV.log(l_module_name, 'Updating in non-bulk mode', l_update_sr_info.shipment_details_tab.count);

1843: IF l_update_sr_info.shipment_details_tab.count > 0 AND
1844: l_update_sr_info.shipment_details_tab.count < 4 THEN
1845: --{
1846: IF l_debug_on THEN
1847: WSH_DEBUG_SV.log(l_module_name, 'Updating in non-bulk mode', l_update_sr_info.shipment_details_tab.count);
1848: END IF;
1849: --
1850: FOR i in 1..l_update_sr_info.shipment_details_tab.count LOOP
1851: --

Line 1853: WSH_DEBUG_SV.log(l_module_name, 'updating delivery_detail_interface_id',l_update_sr_info.shipment_details_tab(i).delivery_detail_interface_id );

1849: --
1850: FOR i in 1..l_update_sr_info.shipment_details_tab.count LOOP
1851: --
1852: IF l_debug_on THEN
1853: WSH_DEBUG_SV.log(l_module_name, 'updating delivery_detail_interface_id',l_update_sr_info.shipment_details_tab(i).delivery_detail_interface_id );
1854: END IF;
1855: --
1856: UPDATE WSH_DEL_DETAILS_INTERFACE
1857: SET last_update_date = sysdate,

Line 1899: WSH_DEBUG_SV.log(l_module_name, 'Updating in bulk mode', l_update_sr_info.shipment_details_tab.count);

1895: --}
1896: ELSIF l_update_sr_info.shipment_details_tab.count > 0 THEN
1897: --{
1898: IF l_debug_on THEN
1899: WSH_DEBUG_SV.log(l_module_name, 'Updating in bulk mode', l_update_sr_info.shipment_details_tab.count);
1900: END IF;
1901: --
1902: --Bug8784331
1903: FOR i in 1..l_update_sr_info.shipment_details_tab.count LOOP

Line 1983: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling Create_Shipment_Request with UPDATE', WSH_DEBUG_SV.C_PROC_LEVEL);

1979:
1980: IF l_insert_sr_info.shipment_details_tab.count > 0 THEN
1981: --
1982: IF l_debug_on THEN
1983: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling Create_Shipment_Request with UPDATE', WSH_DEBUG_SV.C_PROC_LEVEL);
1984: END IF;
1985: --
1986: Create_Shipment_Request(p_shipment_request_info => l_insert_sr_info,
1987: p_caller => 'UPDATE',

Line 1992: WSH_DEBUG_SV.log(l_module_name, 'The Action of inserting new del detail interface lines failed');

1988: x_return_status => l_return_status);
1989:
1990: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1991: IF l_debug_on THEN
1992: WSH_DEBUG_SV.log(l_module_name, 'The Action of inserting new del detail interface lines failed');
1993: END IF;
1994: RAISE FND_API.G_EXC_ERROR;
1995: END IF;
1996: IF l_debug_on THEN

Line 1997: WSH_DEBUG_SV.log(l_module_name, 'The Action of inserting new del detail interface lines is successful');

1993: END IF;
1994: RAISE FND_API.G_EXC_ERROR;
1995: END IF;
1996: IF l_debug_on THEN
1997: WSH_DEBUG_SV.log(l_module_name, 'The Action of inserting new del detail interface lines is successful');
1998: END IF;
1999: END IF;
2000: --}
2001: ELSE

Line 2004: wsh_debug_sv.logmsg(l_module_name, 'Deleting records from WTH,WDDI,WDAI,WNDI');

2000: --}
2001: ELSE
2002: --{
2003: IF l_debug_on THEN
2004: wsh_debug_sv.logmsg(l_module_name, 'Deleting records from WTH,WDDI,WDAI,WNDI');
2005: END IF;
2006: ---------
2007: IF l_del_det_int_tab.count > 0 AND l_del_det_int_tab.count < 4 THEN
2008: --

Line 2010: WSH_DEBUG_SV.log(l_module_name, 'Deleting in non-bulk mode', l_del_det_int_tab.count);

2006: ---------
2007: IF l_del_det_int_tab.count > 0 AND l_del_det_int_tab.count < 4 THEN
2008: --
2009: IF l_debug_on THEN
2010: WSH_DEBUG_SV.log(l_module_name, 'Deleting in non-bulk mode', l_del_det_int_tab.count);
2011: END IF;
2012: --
2013: FOR i in 1..l_del_det_int_tab.count LOOP
2014: delete from wsh_del_assgn_interface

Line 2018: WSH_DEBUG_SV.log(l_module_name,i||' WDAI : Number of records Deleted',l_ins_rows);

2014: delete from wsh_del_assgn_interface
2015: where delivery_detail_interface_id = l_del_det_int_tab(i);
2016: l_ins_rows := sql%rowcount;
2017: IF l_debug_on THEN
2018: WSH_DEBUG_SV.log(l_module_name,i||' WDAI : Number of records Deleted',l_ins_rows);
2019: END IF;
2020:
2021:
2022: delete from WSH_DEL_DETAILS_INTERFACE

Line 2026: WSH_DEBUG_SV.log(l_module_name,i||' WDDI : Number of records Deleted',l_ins_rows);

2022: delete from WSH_DEL_DETAILS_INTERFACE
2023: where delivery_detail_interface_id = l_del_det_int_tab(i);
2024: l_ins_rows := sql%rowcount;
2025: IF l_debug_on THEN
2026: WSH_DEBUG_SV.log(l_module_name,i||' WDDI : Number of records Deleted',l_ins_rows);
2027: END IF;
2028:
2029: delete from WSH_INTERFACE_ERRORS
2030: where interface_id = l_del_det_int_tab(i)

Line 2034: WSH_DEBUG_SV.log(l_module_name,i||' WIE : Number of records Deleted',l_ins_rows);

2030: where interface_id = l_del_det_int_tab(i)
2031: and interface_table_name = 'WSH_DEL_DETAILS_INTERFACE';
2032: l_ins_rows := sql%rowcount;
2033: IF l_debug_on THEN
2034: WSH_DEBUG_SV.log(l_module_name,i||' WIE : Number of records Deleted',l_ins_rows);
2035: END IF;
2036:
2037: END LOOP;
2038:

Line 2042: WSH_DEBUG_SV.log(l_module_name, 'Deleting in bulk mode', l_del_det_int_tab.count);

2038:
2039: ELSIF l_del_det_int_tab.count > 0 THEN
2040: --
2041: IF l_debug_on THEN
2042: WSH_DEBUG_SV.log(l_module_name, 'Deleting in bulk mode', l_del_det_int_tab.count);
2043: END IF;
2044: --
2045: FORALL i in 1..l_del_det_int_tab.count
2046: delete from wsh_del_assgn_interface

Line 2051: WSH_DEBUG_SV.log(l_module_name, 'WDAI : Number of records Deleted',l_ins_rows);

2047: where delivery_detail_interface_id = l_del_det_int_tab(i);
2048:
2049: l_ins_rows := sql%rowcount;
2050: IF l_debug_on THEN
2051: WSH_DEBUG_SV.log(l_module_name, 'WDAI : Number of records Deleted',l_ins_rows);
2052: END IF;
2053:
2054: FORALL i in 1..l_del_det_int_tab.count
2055: delete from WSH_DEL_DETAILS_INTERFACE

Line 2060: WSH_DEBUG_SV.log(l_module_name, 'WDDI : Number of records Deleted',l_ins_rows);

2056: where delivery_detail_interface_id = l_del_det_int_tab(i);
2057:
2058: l_ins_rows := sql%rowcount;
2059: IF l_debug_on THEN
2060: WSH_DEBUG_SV.log(l_module_name, 'WDDI : Number of records Deleted',l_ins_rows);
2061: END IF;
2062:
2063: FORALL i in 1..l_del_det_int_tab.count
2064: delete from WSH_INTERFACE_ERRORS

Line 2069: WSH_DEBUG_SV.log(l_module_name, 'WIE : Number of records Deleted',l_ins_rows);

2065: where interface_id = l_del_det_int_tab(i)
2066: and interface_table_name= 'WSH_DEL_DETAILS_INTERFACE';
2067: l_ins_rows := sql%rowcount;
2068: IF l_debug_on THEN
2069: WSH_DEBUG_SV.log(l_module_name, 'WIE : Number of records Deleted',l_ins_rows);
2070: END IF;
2071:
2072: END IF;
2073: ---------

Line 2083: WSH_DEBUG_SV.log(l_module_name, 'WNDI : Number of records Deleted',l_ins_rows);

2079: ---------
2080: delete from wsh_new_del_interface where delivery_interface_id = l_delivery_interface_id;
2081: l_ins_rows := sql%rowcount;
2082: IF l_debug_on THEN
2083: WSH_DEBUG_SV.log(l_module_name, 'WNDI : Number of records Deleted',l_ins_rows);
2084: END IF;
2085: ---------
2086: delete from wsh_transactions_history where transaction_id = l_transaction_id;
2087: l_ins_rows := sql%rowcount;

Line 2089: WSH_DEBUG_SV.log(l_module_name, 'WTH : Number of records Deleted',l_ins_rows);

2085: ---------
2086: delete from wsh_transactions_history where transaction_id = l_transaction_id;
2087: l_ins_rows := sql%rowcount;
2088: IF l_debug_on THEN
2089: WSH_DEBUG_SV.log(l_module_name, 'WTH : Number of records Deleted',l_ins_rows);
2090: END IF;
2091: ---------
2092: delete from wsh_interface_errors
2093: where interface_id = l_delivery_interface_id

Line 2097: WSH_DEBUG_SV.log(l_module_name, 'WIE : Number of records Deleted',l_ins_rows);

2093: where interface_id = l_delivery_interface_id
2094: and interface_table_name = 'WSH_NEW_DEL_INTERFACE';
2095: l_ins_rows := sql%rowcount;
2096: IF l_debug_on THEN
2097: WSH_DEBUG_SV.log(l_module_name, 'WIE : Number of records Deleted',l_ins_rows);
2098: END IF;
2099: END IF;
2100:
2101: IF l_debug_on THEN

Line 2102: wsh_debug_sv.logmsg(l_module_name, 'Successfully deleted records.');

2098: END IF;
2099: END IF;
2100:
2101: IF l_debug_on THEN
2102: wsh_debug_sv.logmsg(l_module_name, 'Successfully deleted records.');
2103: END IF;
2104: --}
2105: END IF;
2106:

Line 2108: WSH_DEBUG_SV.log(l_module_name, 'Return Status', x_return_status);

2104: --}
2105: END IF;
2106:
2107: IF l_debug_on THEN
2108: WSH_DEBUG_SV.log(l_module_name, 'Return Status', x_return_status);
2109: WSH_DEBUG_SV.pop(l_module_name);
2110: END IF;
2111: EXCEPTION
2112: WHEN RECORD_LOCKED THEN

Line 2109: WSH_DEBUG_SV.pop(l_module_name);

2105: END IF;
2106:
2107: IF l_debug_on THEN
2108: WSH_DEBUG_SV.log(l_module_name, 'Return Status', x_return_status);
2109: WSH_DEBUG_SV.pop(l_module_name);
2110: END IF;
2111: EXCEPTION
2112: WHEN RECORD_LOCKED THEN
2113: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 2116: WSH_DEBUG_SV.logmsg(l_module_name,'Rolling back the transactions');

2112: WHEN RECORD_LOCKED THEN
2113: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2114: FND_MESSAGE.SET_NAME('WSH','WSH_NO_LOCK');
2115: IF l_debug_on THEN
2116: WSH_DEBUG_SV.logmsg(l_module_name,'Rolling back the transactions');
2117: END IF;
2118: rollback;
2119: wsh_util_core.add_message(x_return_status,l_module_name);
2120: IF l_debug_on THEN

Line 2121: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2117: END IF;
2118: rollback;
2119: wsh_util_core.add_message(x_return_status,l_module_name);
2120: IF l_debug_on THEN
2121: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2122: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
2123: END IF;
2124: IF c_get_Details_DN%ISOPEN THEN
2125: CLOSE c_get_Details_DN;

Line 2122: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');

2118: rollback;
2119: wsh_util_core.add_message(x_return_status,l_module_name);
2120: IF l_debug_on THEN
2121: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2122: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
2123: END IF;
2124: IF c_get_Details_DN%ISOPEN THEN
2125: CLOSE c_get_Details_DN;
2126: END IF;

Line 2149: WSH_DEBUG_SV.logmsg(l_module_name,'Rolling back the transactions');

2145: IF c_get_del_det_interface_id%ISOPEN THEN
2146: CLOSE c_get_del_det_interface_id;
2147: END IF;
2148: IF l_debug_on THEN
2149: WSH_DEBUG_SV.logmsg(l_module_name,'Rolling back the transactions');
2150: END IF;
2151: rollback;
2152: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2153: IF l_debug_on THEN

Line 2154: WSH_DEBUG_SV.log(l_module_name, 'Error occured while updating shipment request with document number and revision',p_shipment_request_info.document_number||' and '||p_shipment_request_info.document_revision);

2150: END IF;
2151: rollback;
2152: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2153: IF l_debug_on THEN
2154: WSH_DEBUG_SV.log(l_module_name, 'Error occured while updating shipment request with document number and revision',p_shipment_request_info.document_number||' and '||p_shipment_request_info.document_revision);
2155: WSH_DEBUG_SV.pop(l_module_name,'FND_API.G_EXC_ERROR');
2156: END IF;
2157:
2158: WHEN others THEN

Line 2155: WSH_DEBUG_SV.pop(l_module_name,'FND_API.G_EXC_ERROR');

2151: rollback;
2152: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2153: IF l_debug_on THEN
2154: WSH_DEBUG_SV.log(l_module_name, 'Error occured while updating shipment request with document number and revision',p_shipment_request_info.document_number||' and '||p_shipment_request_info.document_revision);
2155: WSH_DEBUG_SV.pop(l_module_name,'FND_API.G_EXC_ERROR');
2156: END IF;
2157:
2158: WHEN others THEN
2159: IF c_get_Details_DN%ISOPEN THEN

Line 2163: WSH_DEBUG_SV.logmsg(l_module_name,'Rolling back the transactions');

2159: IF c_get_Details_DN%ISOPEN THEN
2160: CLOSE c_get_Details_DN;
2161: END IF;
2162: IF l_debug_on THEN
2163: WSH_DEBUG_SV.logmsg(l_module_name,'Rolling back the transactions');
2164: END IF;
2165: rollback;
2166: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2167: IF l_debug_on THEN

Line 2168: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

2164: END IF;
2165: rollback;
2166: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2167: IF l_debug_on THEN
2168: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2169: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2170: END IF;
2171:
2172: END Update_Delete_Shipment_Request;

Line 2169: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

2165: rollback;
2166: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2167: IF l_debug_on THEN
2168: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2169: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2170: END IF;
2171:
2172: END Update_Delete_Shipment_Request;
2173: