DBA Data[Home] [Help]

APPS.WSH_SHIPPING_CONSTRAINTS_PKG dependencies on WSH_DEBUG_SV

Line 93: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

89: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
90: --
91: IF l_debug_on IS NULL
92: THEN
93: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
94: END IF;
95: --
96: IF l_debug_on THEN
97: WSH_DEBUG_SV.push(l_module_name);

Line 97: WSH_DEBUG_SV.push(l_module_name);

93: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
94: END IF;
95: --
96: IF l_debug_on THEN
97: WSH_DEBUG_SV.push(l_module_name);
98: --
99: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
100: WSH_DEBUG_SV.log(l_module_name,'action_flag',p_changed_attributes.action_flag);
101: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id',p_changed_attributes.delivery_detail_id);

Line 99: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);

95: --
96: IF l_debug_on THEN
97: WSH_DEBUG_SV.push(l_module_name);
98: --
99: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
100: WSH_DEBUG_SV.log(l_module_name,'action_flag',p_changed_attributes.action_flag);
101: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id',p_changed_attributes.delivery_detail_id);
102: WSH_DEBUG_SV.log(l_module_name,'original_source_line_id',p_changed_attributes.original_source_line_id);
103: WSH_DEBUG_SV.log(l_module_name,'source_header_id',p_changed_attributes.source_header_id);

Line 100: WSH_DEBUG_SV.log(l_module_name,'action_flag',p_changed_attributes.action_flag);

96: IF l_debug_on THEN
97: WSH_DEBUG_SV.push(l_module_name);
98: --
99: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
100: WSH_DEBUG_SV.log(l_module_name,'action_flag',p_changed_attributes.action_flag);
101: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id',p_changed_attributes.delivery_detail_id);
102: WSH_DEBUG_SV.log(l_module_name,'original_source_line_id',p_changed_attributes.original_source_line_id);
103: WSH_DEBUG_SV.log(l_module_name,'source_header_id',p_changed_attributes.source_header_id);
104: WSH_DEBUG_SV.log(l_module_name,'source_line_id',p_changed_attributes.source_line_id);

Line 101: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id',p_changed_attributes.delivery_detail_id);

97: WSH_DEBUG_SV.push(l_module_name);
98: --
99: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
100: WSH_DEBUG_SV.log(l_module_name,'action_flag',p_changed_attributes.action_flag);
101: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id',p_changed_attributes.delivery_detail_id);
102: WSH_DEBUG_SV.log(l_module_name,'original_source_line_id',p_changed_attributes.original_source_line_id);
103: WSH_DEBUG_SV.log(l_module_name,'source_header_id',p_changed_attributes.source_header_id);
104: WSH_DEBUG_SV.log(l_module_name,'source_line_id',p_changed_attributes.source_line_id);
105: WSH_DEBUG_SV.log(l_module_name,'sold_to_org_id',p_changed_attributes.sold_to_org_id);

Line 102: WSH_DEBUG_SV.log(l_module_name,'original_source_line_id',p_changed_attributes.original_source_line_id);

98: --
99: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
100: WSH_DEBUG_SV.log(l_module_name,'action_flag',p_changed_attributes.action_flag);
101: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id',p_changed_attributes.delivery_detail_id);
102: WSH_DEBUG_SV.log(l_module_name,'original_source_line_id',p_changed_attributes.original_source_line_id);
103: WSH_DEBUG_SV.log(l_module_name,'source_header_id',p_changed_attributes.source_header_id);
104: WSH_DEBUG_SV.log(l_module_name,'source_line_id',p_changed_attributes.source_line_id);
105: WSH_DEBUG_SV.log(l_module_name,'sold_to_org_id',p_changed_attributes.sold_to_org_id);
106: WSH_DEBUG_SV.log(l_module_name,'ship_from_org_id',p_changed_attributes.ship_from_org_id);

Line 103: WSH_DEBUG_SV.log(l_module_name,'source_header_id',p_changed_attributes.source_header_id);

99: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
100: WSH_DEBUG_SV.log(l_module_name,'action_flag',p_changed_attributes.action_flag);
101: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id',p_changed_attributes.delivery_detail_id);
102: WSH_DEBUG_SV.log(l_module_name,'original_source_line_id',p_changed_attributes.original_source_line_id);
103: WSH_DEBUG_SV.log(l_module_name,'source_header_id',p_changed_attributes.source_header_id);
104: WSH_DEBUG_SV.log(l_module_name,'source_line_id',p_changed_attributes.source_line_id);
105: WSH_DEBUG_SV.log(l_module_name,'sold_to_org_id',p_changed_attributes.sold_to_org_id);
106: WSH_DEBUG_SV.log(l_module_name,'ship_from_org_id',p_changed_attributes.ship_from_org_id);
107: WSH_DEBUG_SV.log(l_module_name,'ship_to_org_id',p_changed_attributes.ship_to_org_id);

Line 104: WSH_DEBUG_SV.log(l_module_name,'source_line_id',p_changed_attributes.source_line_id);

100: WSH_DEBUG_SV.log(l_module_name,'action_flag',p_changed_attributes.action_flag);
101: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id',p_changed_attributes.delivery_detail_id);
102: WSH_DEBUG_SV.log(l_module_name,'original_source_line_id',p_changed_attributes.original_source_line_id);
103: WSH_DEBUG_SV.log(l_module_name,'source_header_id',p_changed_attributes.source_header_id);
104: WSH_DEBUG_SV.log(l_module_name,'source_line_id',p_changed_attributes.source_line_id);
105: WSH_DEBUG_SV.log(l_module_name,'sold_to_org_id',p_changed_attributes.sold_to_org_id);
106: WSH_DEBUG_SV.log(l_module_name,'ship_from_org_id',p_changed_attributes.ship_from_org_id);
107: WSH_DEBUG_SV.log(l_module_name,'ship_to_org_id',p_changed_attributes.ship_to_org_id);
108: WSH_DEBUG_SV.log(l_module_name,'deliver_to_org_id',p_changed_attributes.deliver_to_org_id);

Line 105: WSH_DEBUG_SV.log(l_module_name,'sold_to_org_id',p_changed_attributes.sold_to_org_id);

101: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id',p_changed_attributes.delivery_detail_id);
102: WSH_DEBUG_SV.log(l_module_name,'original_source_line_id',p_changed_attributes.original_source_line_id);
103: WSH_DEBUG_SV.log(l_module_name,'source_header_id',p_changed_attributes.source_header_id);
104: WSH_DEBUG_SV.log(l_module_name,'source_line_id',p_changed_attributes.source_line_id);
105: WSH_DEBUG_SV.log(l_module_name,'sold_to_org_id',p_changed_attributes.sold_to_org_id);
106: WSH_DEBUG_SV.log(l_module_name,'ship_from_org_id',p_changed_attributes.ship_from_org_id);
107: WSH_DEBUG_SV.log(l_module_name,'ship_to_org_id',p_changed_attributes.ship_to_org_id);
108: WSH_DEBUG_SV.log(l_module_name,'deliver_to_org_id',p_changed_attributes.deliver_to_org_id);
109: WSH_DEBUG_SV.log(l_module_name,'intmed_ship_to_org_id',p_changed_attributes.intmed_ship_to_org_id);

Line 106: WSH_DEBUG_SV.log(l_module_name,'ship_from_org_id',p_changed_attributes.ship_from_org_id);

102: WSH_DEBUG_SV.log(l_module_name,'original_source_line_id',p_changed_attributes.original_source_line_id);
103: WSH_DEBUG_SV.log(l_module_name,'source_header_id',p_changed_attributes.source_header_id);
104: WSH_DEBUG_SV.log(l_module_name,'source_line_id',p_changed_attributes.source_line_id);
105: WSH_DEBUG_SV.log(l_module_name,'sold_to_org_id',p_changed_attributes.sold_to_org_id);
106: WSH_DEBUG_SV.log(l_module_name,'ship_from_org_id',p_changed_attributes.ship_from_org_id);
107: WSH_DEBUG_SV.log(l_module_name,'ship_to_org_id',p_changed_attributes.ship_to_org_id);
108: WSH_DEBUG_SV.log(l_module_name,'deliver_to_org_id',p_changed_attributes.deliver_to_org_id);
109: WSH_DEBUG_SV.log(l_module_name,'intmed_ship_to_org_id',p_changed_attributes.intmed_ship_to_org_id);
110: WSH_DEBUG_SV.log(l_module_name,'ordered_quantity',p_changed_attributes.ordered_quantity);

Line 107: WSH_DEBUG_SV.log(l_module_name,'ship_to_org_id',p_changed_attributes.ship_to_org_id);

103: WSH_DEBUG_SV.log(l_module_name,'source_header_id',p_changed_attributes.source_header_id);
104: WSH_DEBUG_SV.log(l_module_name,'source_line_id',p_changed_attributes.source_line_id);
105: WSH_DEBUG_SV.log(l_module_name,'sold_to_org_id',p_changed_attributes.sold_to_org_id);
106: WSH_DEBUG_SV.log(l_module_name,'ship_from_org_id',p_changed_attributes.ship_from_org_id);
107: WSH_DEBUG_SV.log(l_module_name,'ship_to_org_id',p_changed_attributes.ship_to_org_id);
108: WSH_DEBUG_SV.log(l_module_name,'deliver_to_org_id',p_changed_attributes.deliver_to_org_id);
109: WSH_DEBUG_SV.log(l_module_name,'intmed_ship_to_org_id',p_changed_attributes.intmed_ship_to_org_id);
110: WSH_DEBUG_SV.log(l_module_name,'ordered_quantity',p_changed_attributes.ordered_quantity);
111: WSH_DEBUG_SV.log(l_module_name,'released_status',p_changed_attributes.released_status);

Line 108: WSH_DEBUG_SV.log(l_module_name,'deliver_to_org_id',p_changed_attributes.deliver_to_org_id);

104: WSH_DEBUG_SV.log(l_module_name,'source_line_id',p_changed_attributes.source_line_id);
105: WSH_DEBUG_SV.log(l_module_name,'sold_to_org_id',p_changed_attributes.sold_to_org_id);
106: WSH_DEBUG_SV.log(l_module_name,'ship_from_org_id',p_changed_attributes.ship_from_org_id);
107: WSH_DEBUG_SV.log(l_module_name,'ship_to_org_id',p_changed_attributes.ship_to_org_id);
108: WSH_DEBUG_SV.log(l_module_name,'deliver_to_org_id',p_changed_attributes.deliver_to_org_id);
109: WSH_DEBUG_SV.log(l_module_name,'intmed_ship_to_org_id',p_changed_attributes.intmed_ship_to_org_id);
110: WSH_DEBUG_SV.log(l_module_name,'ordered_quantity',p_changed_attributes.ordered_quantity);
111: WSH_DEBUG_SV.log(l_module_name,'released_status',p_changed_attributes.released_status);
112: WSH_DEBUG_SV.log(l_module_name,'shipped_quantity',p_changed_attributes.shipped_quantity);

Line 109: WSH_DEBUG_SV.log(l_module_name,'intmed_ship_to_org_id',p_changed_attributes.intmed_ship_to_org_id);

105: WSH_DEBUG_SV.log(l_module_name,'sold_to_org_id',p_changed_attributes.sold_to_org_id);
106: WSH_DEBUG_SV.log(l_module_name,'ship_from_org_id',p_changed_attributes.ship_from_org_id);
107: WSH_DEBUG_SV.log(l_module_name,'ship_to_org_id',p_changed_attributes.ship_to_org_id);
108: WSH_DEBUG_SV.log(l_module_name,'deliver_to_org_id',p_changed_attributes.deliver_to_org_id);
109: WSH_DEBUG_SV.log(l_module_name,'intmed_ship_to_org_id',p_changed_attributes.intmed_ship_to_org_id);
110: WSH_DEBUG_SV.log(l_module_name,'ordered_quantity',p_changed_attributes.ordered_quantity);
111: WSH_DEBUG_SV.log(l_module_name,'released_status',p_changed_attributes.released_status);
112: WSH_DEBUG_SV.log(l_module_name,'shipped_quantity',p_changed_attributes.shipped_quantity);
113: WSH_DEBUG_SV.log(l_module_name,'customer_item_id',p_changed_attributes.customer_item_id);

Line 110: WSH_DEBUG_SV.log(l_module_name,'ordered_quantity',p_changed_attributes.ordered_quantity);

106: WSH_DEBUG_SV.log(l_module_name,'ship_from_org_id',p_changed_attributes.ship_from_org_id);
107: WSH_DEBUG_SV.log(l_module_name,'ship_to_org_id',p_changed_attributes.ship_to_org_id);
108: WSH_DEBUG_SV.log(l_module_name,'deliver_to_org_id',p_changed_attributes.deliver_to_org_id);
109: WSH_DEBUG_SV.log(l_module_name,'intmed_ship_to_org_id',p_changed_attributes.intmed_ship_to_org_id);
110: WSH_DEBUG_SV.log(l_module_name,'ordered_quantity',p_changed_attributes.ordered_quantity);
111: WSH_DEBUG_SV.log(l_module_name,'released_status',p_changed_attributes.released_status);
112: WSH_DEBUG_SV.log(l_module_name,'shipped_quantity',p_changed_attributes.shipped_quantity);
113: WSH_DEBUG_SV.log(l_module_name,'customer_item_id',p_changed_attributes.customer_item_id);
114: WSH_DEBUG_SV.log(l_module_name,'P_LOG_LEVEL',P_LOG_LEVEL);

Line 111: WSH_DEBUG_SV.log(l_module_name,'released_status',p_changed_attributes.released_status);

107: WSH_DEBUG_SV.log(l_module_name,'ship_to_org_id',p_changed_attributes.ship_to_org_id);
108: WSH_DEBUG_SV.log(l_module_name,'deliver_to_org_id',p_changed_attributes.deliver_to_org_id);
109: WSH_DEBUG_SV.log(l_module_name,'intmed_ship_to_org_id',p_changed_attributes.intmed_ship_to_org_id);
110: WSH_DEBUG_SV.log(l_module_name,'ordered_quantity',p_changed_attributes.ordered_quantity);
111: WSH_DEBUG_SV.log(l_module_name,'released_status',p_changed_attributes.released_status);
112: WSH_DEBUG_SV.log(l_module_name,'shipped_quantity',p_changed_attributes.shipped_quantity);
113: WSH_DEBUG_SV.log(l_module_name,'customer_item_id',p_changed_attributes.customer_item_id);
114: WSH_DEBUG_SV.log(l_module_name,'P_LOG_LEVEL',P_LOG_LEVEL);
115: END IF;

Line 112: WSH_DEBUG_SV.log(l_module_name,'shipped_quantity',p_changed_attributes.shipped_quantity);

108: WSH_DEBUG_SV.log(l_module_name,'deliver_to_org_id',p_changed_attributes.deliver_to_org_id);
109: WSH_DEBUG_SV.log(l_module_name,'intmed_ship_to_org_id',p_changed_attributes.intmed_ship_to_org_id);
110: WSH_DEBUG_SV.log(l_module_name,'ordered_quantity',p_changed_attributes.ordered_quantity);
111: WSH_DEBUG_SV.log(l_module_name,'released_status',p_changed_attributes.released_status);
112: WSH_DEBUG_SV.log(l_module_name,'shipped_quantity',p_changed_attributes.shipped_quantity);
113: WSH_DEBUG_SV.log(l_module_name,'customer_item_id',p_changed_attributes.customer_item_id);
114: WSH_DEBUG_SV.log(l_module_name,'P_LOG_LEVEL',P_LOG_LEVEL);
115: END IF;
116: --

Line 113: WSH_DEBUG_SV.log(l_module_name,'customer_item_id',p_changed_attributes.customer_item_id);

109: WSH_DEBUG_SV.log(l_module_name,'intmed_ship_to_org_id',p_changed_attributes.intmed_ship_to_org_id);
110: WSH_DEBUG_SV.log(l_module_name,'ordered_quantity',p_changed_attributes.ordered_quantity);
111: WSH_DEBUG_SV.log(l_module_name,'released_status',p_changed_attributes.released_status);
112: WSH_DEBUG_SV.log(l_module_name,'shipped_quantity',p_changed_attributes.shipped_quantity);
113: WSH_DEBUG_SV.log(l_module_name,'customer_item_id',p_changed_attributes.customer_item_id);
114: WSH_DEBUG_SV.log(l_module_name,'P_LOG_LEVEL',P_LOG_LEVEL);
115: END IF;
116: --
117:

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

110: WSH_DEBUG_SV.log(l_module_name,'ordered_quantity',p_changed_attributes.ordered_quantity);
111: WSH_DEBUG_SV.log(l_module_name,'released_status',p_changed_attributes.released_status);
112: WSH_DEBUG_SV.log(l_module_name,'shipped_quantity',p_changed_attributes.shipped_quantity);
113: WSH_DEBUG_SV.log(l_module_name,'customer_item_id',p_changed_attributes.customer_item_id);
114: WSH_DEBUG_SV.log(l_module_name,'P_LOG_LEVEL',P_LOG_LEVEL);
115: END IF;
116: --
117:
118: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 127: WSH_DEBUG_SV.logmsg(l_module_name, 'NULL PASSED FOR SOURCE LINE ID' );

123: --
124: -- Debug Statements
125: --
126: IF l_debug_on THEN
127: WSH_DEBUG_SV.logmsg(l_module_name, 'NULL PASSED FOR SOURCE LINE ID' );
128: END IF;
129: --
130: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
131: ELSE

Line 147: WSH_DEBUG_SV.logmsg(l_module_name, 'NO CORRESPONDING DATA FOUND FOR THE LINE ID' || P_CHANGED_ATTRIBUTES.SOURCE_LINE_ID );

143: --
144: -- Debug Statements
145: --
146: IF l_debug_on THEN
147: WSH_DEBUG_SV.logmsg(l_module_name, 'NO CORRESPONDING DATA FOUND FOR THE LINE ID' || P_CHANGED_ATTRIBUTES.SOURCE_LINE_ID );
148: END IF;
149: --
150: x_action_allowed := 'Y';
151: END IF;

Line 176: WSH_DEBUG_SV.logmsg(l_module_name, 'DELIVERY DETAIL RELEASED_STATUS = ' || L_DELIVERY_DETAILS_REC.RELEASED_STATUS );

172: --
173: -- Debug Statements
174: --
175: IF l_debug_on THEN
176: WSH_DEBUG_SV.logmsg(l_module_name, 'DELIVERY DETAIL RELEASED_STATUS = ' || L_DELIVERY_DETAILS_REC.RELEASED_STATUS );
177: END IF;
178: --
179: --
180: -- Debug Statements

Line 183: WSH_DEBUG_SV.logmsg(l_module_name, 'PARENT DELIVERY DETAIL = ' || L_DELIVERY_DETAILS_REC.PARENT_DELIVERY_DETAIL_ID );

179: --
180: -- Debug Statements
181: --
182: IF l_debug_on THEN
183: WSH_DEBUG_SV.logmsg(l_module_name, 'PARENT DELIVERY DETAIL = ' || L_DELIVERY_DETAILS_REC.PARENT_DELIVERY_DETAIL_ID );
184: END IF;
185: --
186: --
187: -- Debug Statements

Line 190: WSH_DEBUG_SV.logmsg(l_module_name, 'DELIVERY STATUS CODE = ' || L_DELIVERY_DETAILS_REC.STATUS_CODE );

186: --
187: -- Debug Statements
188: --
189: IF l_debug_on THEN
190: WSH_DEBUG_SV.logmsg(l_module_name, 'DELIVERY STATUS CODE = ' || L_DELIVERY_DETAILS_REC.STATUS_CODE );
191: END IF;
192: --
193: --
194: -- Debug Statements

Line 197: WSH_DEBUG_SV.logmsg(l_module_name, 'DELIVERY PLANNED FLAG = ' || L_DELIVERY_DETAILS_REC.PLANNED_FLAG );

193: --
194: -- Debug Statements
195: --
196: IF l_debug_on THEN
197: WSH_DEBUG_SV.logmsg(l_module_name, 'DELIVERY PLANNED FLAG = ' || L_DELIVERY_DETAILS_REC.PLANNED_FLAG );
198: END IF;
199: --
200: --
201: -- Debug Statements

Line 204: WSH_DEBUG_SV.logmsg(l_module_name, 'DELETE ACTION NOT ALLOWED FOR SOURCE LINE ID: ' || P_CHANGED_ATTRIBUTES.SOURCE_LINE_ID );

200: --
201: -- Debug Statements
202: --
203: IF l_debug_on THEN
204: WSH_DEBUG_SV.logmsg(l_module_name, 'DELETE ACTION NOT ALLOWED FOR SOURCE LINE ID: ' || P_CHANGED_ATTRIBUTES.SOURCE_LINE_ID );
205: END IF;
206: --
207:
208: exit;

Line 238: WSH_DEBUG_SV.logmsg(l_module_name, 'INVALID ACTION FLAG' );

234: --
235: -- Debug Statements
236: --
237: IF l_debug_on THEN
238: WSH_DEBUG_SV.logmsg(l_module_name, 'INVALID ACTION FLAG' );
239: END IF;
240: --
241: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
242:

Line 252: WSH_DEBUG_SV.pop(l_module_name);

248: --
249: -- Debug Statements
250: --
251: IF l_debug_on THEN
252: WSH_DEBUG_SV.pop(l_module_name);
253: END IF;
254: --
255: EXCEPTION
256:

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

264: --
265: -- Debug Statements
266: --
267: IF l_debug_on THEN
268: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
269: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
270: END IF;
271: --
272: END check_shipping_constraints;

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

265: -- Debug Statements
266: --
267: IF l_debug_on THEN
268: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
269: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
270: END IF;
271: --
272: END check_shipping_constraints;
273: