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_ITM_RESPONSE_PKG dependencies on OE_DEBUG_PUB

Line 95: OE_DEBUG_PUB.Add('Inside the procedure ONT_RESPONSE_ANALYSER');

91: AND vendor_id = p_vendor_id
92: ORDER BY error_code;
93:
94: BEGIN
95: OE_DEBUG_PUB.Add('***Inside the procedure ONT_RESPONSE_ANALYSER***');
96:
97: x_return_status := FND_API.G_RET_STS_SUCCESS;
98:
99: OPEN Get_Response_Header(p_request_control_id);

Line 110: OE_DEBUG_PUB.Add('Request Control is not Found');

106: l_exp_Compl_Resl,
107: l_service_type;
108:
109: IF Get_Response_Header%NOTFOUND THEN
110: OE_DEBUG_PUB.Add('Request Control is not Found');
111: --Invalid trans control
112: x_interpreted_value:= SYSTEM_ERROR;
113: CLOSE Get_Response_Header;
114: RETURN;

Line 118: OE_DEBUG_PUB.Add('Procesing Response Header :' || l_response_hdr_id);

114: RETURN;
115: END IF;
116: CLOSE Get_Response_Header;
117:
118: OE_DEBUG_PUB.Add('Procesing Response Header :' || l_response_hdr_id);
119: IF l_fetch_interpreted_code is NULL THEN
120:
121: IF l_fetch_error_type IS NULL AND
122: l_fetch_error_code IS NULL THEN

Line 127: OE_DEBUG_PUB.Add('Error code and Error Type is Response Headers is null');

123: ---------------------------------------------------------
124: -- Error Code and Error Type is NULL in Response Headers
125: -- Interpreted Value will be SUCCESS
126: ---------------------------------------------------------
127: OE_DEBUG_PUB.Add('Error code and Error Type is Response Headers is null');
128: x_interpreted_value := SUCCESS;
129: ELSE
130: --Bug 9277386:If response rule is not defined, default to SYSTEM ERROR
131: ---------------------------------------------------------------

Line 134: OE_DEBUG_PUB.Add('Error in the Request Control. There is no Rule Defined');

130: --Bug 9277386:If response rule is not defined, default to SYSTEM ERROR
131: ---------------------------------------------------------------
132: -- If not Response Rule is defined, then default in SYSTEM ERROR
133: ---------------------------------------------------------------
134: OE_DEBUG_PUB.Add('Error in the Request Control. There is no Rule Defined');
135: x_interpreted_value := SYSTEM_ERROR;
136: END IF;
137: ELSE
138:

Line 139: OE_DEBUG_PUB.Add('Interpreted Error from Get_Response_Headers Cursor - ' || l_fetch_interpreted_code );

135: x_interpreted_value := SYSTEM_ERROR;
136: END IF;
137: ELSE
138:
139: OE_DEBUG_PUB.Add('Interpreted Error from Get_Response_Headers Cursor - ' || l_fetch_interpreted_code );
140: OE_DEBUG_PUB.Add('Calling PROCEDURE Interpret_Error');
141:
142: interpret_error(l_fetch_interpreted_code, x_interpreted_value ) ;
143: IF(x_interpreted_value = SYSTEM_ERROR) THEN

Line 140: OE_DEBUG_PUB.Add('Calling PROCEDURE Interpret_Error');

136: END IF;
137: ELSE
138:
139: OE_DEBUG_PUB.Add('Interpreted Error from Get_Response_Headers Cursor - ' || l_fetch_interpreted_code );
140: OE_DEBUG_PUB.Add('Calling PROCEDURE Interpret_Error');
141:
142: interpret_error(l_fetch_interpreted_code, x_interpreted_value ) ;
143: IF(x_interpreted_value = SYSTEM_ERROR) THEN
144: OE_DEBUG_PUB.Add('Procedure Interpret_Error returned SYSTEM Error');

Line 144: OE_DEBUG_PUB.Add('Procedure Interpret_Error returned SYSTEM Error');

140: OE_DEBUG_PUB.Add('Calling PROCEDURE Interpret_Error');
141:
142: interpret_error(l_fetch_interpreted_code, x_interpreted_value ) ;
143: IF(x_interpreted_value = SYSTEM_ERROR) THEN
144: OE_DEBUG_PUB.Add('Procedure Interpret_Error returned SYSTEM Error');
145: RETURN;
146: END IF;
147:
148: END IF;

Line 153: OE_DEBUG_PUB.Add('For Service OM_EXPORT_COMPLIANCE');

149: i := 1;
150: --Added by AJPRABHA for OM_EXPORT_COMPLIANCE
151: IF (l_exp_Compl_Resl IS NOT NULL and l_service_type='OM_EXPORT_COMPLIANCE') THEN
152:
153: OE_DEBUG_PUB.Add('For Service OM_EXPORT_COMPLIANCE');
154: x_SrvTab(i).Service_Type := 'OM_EXPORT_COMPLIANCE';
155:
156: IF (l_exp_Compl_Resl = 'NOT_COMPLIANT') THEN
157: x_SrvTab(i).Service_Result := 'Y';

Line 158: OE_DEBUG_PUB.Add('Done with EXPORT_COMPLIANCE : ' || l_exp_Compl_Resl);

154: x_SrvTab(i).Service_Type := 'OM_EXPORT_COMPLIANCE';
155:
156: IF (l_exp_Compl_Resl = 'NOT_COMPLIANT') THEN
157: x_SrvTab(i).Service_Result := 'Y';
158: OE_DEBUG_PUB.Add('Done with EXPORT_COMPLIANCE : ' || l_exp_Compl_Resl);
159: RETURN;
160: END IF;
161:
162: END IF;

Line 170: OE_DEBUG_PUB.Add('Processing Line :' || resp.response_line_id);

166: --Fix for bug #3876344 for setting ServiceType to apply hold for DP.
167: l_service_type := 'X';
168: FOR resp IN Get_Response_Line(l_response_hdr_id) LOOP
169:
170: OE_DEBUG_PUB.Add('Processing Line :' || resp.response_line_id);
171:
172: IF ((resp.error_code is not NULL) OR (resp.error_type is not NULL)) THEN
173:
174: OPEN Get_Interpreted_code(resp.error_code, resp.error_type, l_vendor_id);

Line 179: OE_DEBUG_PUB.Add('Response Line Error, Rule Not Found for interrepted code '||l_fetch_interpreted_code);

175: FETCH Get_Interpreted_code INTO l_fetch_interpreted_code;
176:
177: IF l_fetch_interpreted_code is null THEN --Rule not found
178: x_interpreted_value := SYSTEM_ERROR; --Bug 9277386 : Default is SYSTEM ERROR
179: OE_DEBUG_PUB.Add('Response Line Error, Rule Not Found for interrepted code '||l_fetch_interpreted_code);
180: OE_DEBUG_PUB.Add(' -> Error Code : ' || resp.error_code);
181: OE_DEBUG_PUB.Add(' -> Error Type : '|| resp.error_type );
182: END IF;
183: CLOSE Get_Interpreted_Code;

Line 180: OE_DEBUG_PUB.Add(' -> Error Code : ' || resp.error_code);

176:
177: IF l_fetch_interpreted_code is null THEN --Rule not found
178: x_interpreted_value := SYSTEM_ERROR; --Bug 9277386 : Default is SYSTEM ERROR
179: OE_DEBUG_PUB.Add('Response Line Error, Rule Not Found for interrepted code '||l_fetch_interpreted_code);
180: OE_DEBUG_PUB.Add(' -> Error Code : ' || resp.error_code);
181: OE_DEBUG_PUB.Add(' -> Error Type : '|| resp.error_type );
182: END IF;
183: CLOSE Get_Interpreted_Code;
184:

Line 181: OE_DEBUG_PUB.Add(' -> Error Type : '|| resp.error_type );

177: IF l_fetch_interpreted_code is null THEN --Rule not found
178: x_interpreted_value := SYSTEM_ERROR; --Bug 9277386 : Default is SYSTEM ERROR
179: OE_DEBUG_PUB.Add('Response Line Error, Rule Not Found for interrepted code '||l_fetch_interpreted_code);
180: OE_DEBUG_PUB.Add(' -> Error Code : ' || resp.error_code);
181: OE_DEBUG_PUB.Add(' -> Error Type : '|| resp.error_type );
182: END IF;
183: CLOSE Get_Interpreted_Code;
184:
185: OE_DEBUG_PUB.Add('Reponse Line Error, Interpreted Code - ' || l_fetch_interpreted_code );

Line 185: OE_DEBUG_PUB.Add('Reponse Line Error, Interpreted Code - ' || l_fetch_interpreted_code );

181: OE_DEBUG_PUB.Add(' -> Error Type : '|| resp.error_type );
182: END IF;
183: CLOSE Get_Interpreted_Code;
184:
185: OE_DEBUG_PUB.Add('Reponse Line Error, Interpreted Code - ' || l_fetch_interpreted_code );
186: OE_DEBUG_PUB.Add('Calling PROCEDURE Interpret_Error');
187:
188: interpret_error(l_fetch_interpreted_code, x_interpreted_value);
189: --Bug9277386:When response Status is 'ERROR', and error code is not specified, default to SYSTEM_ERROR

Line 186: OE_DEBUG_PUB.Add('Calling PROCEDURE Interpret_Error');

182: END IF;
183: CLOSE Get_Interpreted_Code;
184:
185: OE_DEBUG_PUB.Add('Reponse Line Error, Interpreted Code - ' || l_fetch_interpreted_code );
186: OE_DEBUG_PUB.Add('Calling PROCEDURE Interpret_Error');
187:
188: interpret_error(l_fetch_interpreted_code, x_interpreted_value);
189: --Bug9277386:When response Status is 'ERROR', and error code is not specified, default to SYSTEM_ERROR
190: ELSE

Line 199: OE_DEBUG_PUB.Add('Service Type for Response Line ' || resp.response_line_id || ' is '|| resp.service_type_code);

195: END IF;
196:
197: IF (nvl(l_service_type,'X') <> resp.service_type_code and l_service_type <> 'WSH_EXPORT_COMPLIANCE') THEN
198:
199: OE_DEBUG_PUB.Add('Service Type for Response Line ' || resp.response_line_id || ' is '|| resp.service_type_code);
200: i := i + 1;
201: l_service_type := resp.service_type_code;
202: x_SrvTab(i).Service_Type := resp.service_type_code;
203: x_SrvTab(i).Service_Result := 'N';

Line 208: OE_DEBUG_PUB.Add('Denied Party is found' );

204: END IF;
205:
206: IF l_service_type = 'DP' AND
207: resp.denied_party_flag = 'Y' THEN
208: OE_DEBUG_PUB.Add('Denied Party is found' );
209: x_SrvTab(i).Service_Result := 'Y';
210: ELSIF
211: l_service_type = 'EM' AND
212: resp.embargo_flag = 'Y' THEN

Line 213: OE_DEBUG_PUB.Add('Embargo is found' );

209: x_SrvTab(i).Service_Result := 'Y';
210: ELSIF
211: l_service_type = 'EM' AND
212: resp.embargo_flag = 'Y' THEN
213: OE_DEBUG_PUB.Add('Embargo is found' );
214: x_SrvTab(i).Service_Result := 'Y';
215: END IF;
216:
217: IF(x_interpreted_value = SYSTEM_ERROR) THEN

Line 232: OE_DEBUG_PUB.Add('Processing Failed with an Error');

228:
229: EXCEPTION
230: WHEN OTHERS THEN
231: l_sql_error := SQLERRM;
232: OE_DEBUG_PUB.Add('Processing Failed with an Error');
233: OE_DEBUG_PUB.Add('The unexpected error is :' || l_sql_error);
234: x_interpreted_value := SYSTEM_ERROR;
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
236: END ONT_RESPONSE_ANALYSER;

Line 233: OE_DEBUG_PUB.Add('The unexpected error is :' || l_sql_error);

229: EXCEPTION
230: WHEN OTHERS THEN
231: l_sql_error := SQLERRM;
232: OE_DEBUG_PUB.Add('Processing Failed with an Error');
233: OE_DEBUG_PUB.Add('The unexpected error is :' || l_sql_error);
234: x_interpreted_value := SYSTEM_ERROR;
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
236: END ONT_RESPONSE_ANALYSER;
237:

Line 276: OE_DEBUG_PUB.Add('Inside ONT_RESPONSE_ANALYSER');

272: AND wrc.original_system_line_reference = nvl ( p_reference_line_id, wrc.original_system_line_reference)
273: AND wrc.process_flag IN (1,2);
274:
275: BEGIN
276: OE_DEBUG_PUB.Add('Inside ONT_RESPONSE_ANALYSER');
277: ------------------------------------------
278: -- Print the values of all the parameters.
279: ------------------------------------------
280: OE_DEBUG_PUB.Add('Reference ID ' || p_reference_id);

Line 280: OE_DEBUG_PUB.Add('Reference ID ' || p_reference_id);

276: OE_DEBUG_PUB.Add('Inside ONT_RESPONSE_ANALYSER');
277: ------------------------------------------
278: -- Print the values of all the parameters.
279: ------------------------------------------
280: OE_DEBUG_PUB.Add('Reference ID ' || p_reference_id);
281: OE_DEBUG_PUB.Add('Reference Line ID ' || p_reference_line_id);
282:
283: FOR cur_rec in Get_Request_Control LOOP
284: OE_DEBUG_PUB.Add(' Calling ONT_RESPONSE_ANALYSER for reqID' || cur_rec.request_control_id);

Line 281: OE_DEBUG_PUB.Add('Reference Line ID ' || p_reference_line_id);

277: ------------------------------------------
278: -- Print the values of all the parameters.
279: ------------------------------------------
280: OE_DEBUG_PUB.Add('Reference ID ' || p_reference_id);
281: OE_DEBUG_PUB.Add('Reference Line ID ' || p_reference_line_id);
282:
283: FOR cur_rec in Get_Request_Control LOOP
284: OE_DEBUG_PUB.Add(' Calling ONT_RESPONSE_ANALYSER for reqID' || cur_rec.request_control_id);
285:

Line 284: OE_DEBUG_PUB.Add(' Calling ONT_RESPONSE_ANALYSER for reqID' || cur_rec.request_control_id);

280: OE_DEBUG_PUB.Add('Reference ID ' || p_reference_id);
281: OE_DEBUG_PUB.Add('Reference Line ID ' || p_reference_line_id);
282:
283: FOR cur_rec in Get_Request_Control LOOP
284: OE_DEBUG_PUB.Add(' Calling ONT_RESPONSE_ANALYSER for reqID' || cur_rec.request_control_id);
285:
286: ONT_RESPONSE_ANALYSER (
287: p_request_control_id => cur_rec.request_control_id,
288: x_interpreted_value => x_interpreted_value,

Line 293: OE_DEBUG_PUB.Add(' Done with ONT_RESPONSE_ANALYSER');

289: x_return_status => x_return_status,
290: x_SrvTab => x_SrvTab
291: );
292: END LOOP;
293: OE_DEBUG_PUB.Add(' Done with ONT_RESPONSE_ANALYSER');
294:
295: END ONT_RESPONSE_ANALYSER;
296:
297: END WSH_ITM_RESPONSE_PKG;