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 93: OE_DEBUG_PUB.Add('Inside the procedure ONT_RESPONSE_ANALYSER');

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

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

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

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

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

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

121: ---------------------------------------------------------
122: -- Error Code and Error Type is NULL in Response Headers
123: -- Interpreted Value will be SUCCESS
124: ---------------------------------------------------------
125: OE_DEBUG_PUB.Add('Error code and Error Type is Response Headers is null');
126: x_interpreted_value := SUCCESS;
127: ELSE
128: ---------------------------------------------------------------
129: -- If not Response Rule is defined, then default in DATA ERROR

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

127: ELSE
128: ---------------------------------------------------------------
129: -- If not Response Rule is defined, then default in DATA ERROR
130: ---------------------------------------------------------------
131: OE_DEBUG_PUB.Add('Error in the Request Control. There is no Rule Defined');
132: x_interpreted_value := DATA_ERROR;
133: END IF;
134: ELSE
135:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

173:
174: IF l_fetch_interpreted_code is null THEN --Rule not found
175: x_interpreted_value := DATA_ERROR; --Default is DATA ERROR
176: OE_DEBUG_PUB.Add('Response Line Error, Rule Not Found for interrepted code '||l_fetch_interpreted_code);
177: OE_DEBUG_PUB.Add(' -> Error Code : ' || resp.error_code);
178: OE_DEBUG_PUB.Add(' -> Error Type : '|| resp.error_type );
179: END IF;
180: CLOSE Get_Interpreted_Code;
181:

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

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

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

178: OE_DEBUG_PUB.Add(' -> Error Type : '|| resp.error_type );
179: END IF;
180: CLOSE Get_Interpreted_Code;
181:
182: OE_DEBUG_PUB.Add('Reponse Line Error, Interpreted Code - ' || l_fetch_interpreted_code );
183: OE_DEBUG_PUB.Add('Calling PROCEDURE Interpret_Error');
184:
185: interpret_error(l_fetch_interpreted_code, x_interpreted_value);
186: END IF;

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

179: END IF;
180: CLOSE Get_Interpreted_Code;
181:
182: OE_DEBUG_PUB.Add('Reponse Line Error, Interpreted Code - ' || l_fetch_interpreted_code );
183: OE_DEBUG_PUB.Add('Calling PROCEDURE Interpret_Error');
184:
185: interpret_error(l_fetch_interpreted_code, x_interpreted_value);
186: END IF;
187:

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

186: END IF;
187:
188: IF (nvl(l_service_type,'X') <> resp.service_type_code and l_service_type <> 'WSH_EXPORT_COMPLIANCE') THEN
189:
190: OE_DEBUG_PUB.Add('Service Type for Response Line ' || resp.response_line_id || ' is '|| resp.service_type_code);
191: i := i + 1;
192: l_service_type := resp.service_type_code;
193: x_SrvTab(i).Service_Type := resp.service_type_code;
194: x_SrvTab(i).Service_Result := 'N';

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

195: END IF;
196:
197: IF l_service_type = 'DP' AND
198: resp.denied_party_flag = 'Y' THEN
199: OE_DEBUG_PUB.Add('Denied Party is found' );
200: x_SrvTab(i).Service_Result := 'Y';
201: ELSIF
202: l_service_type = 'EM' AND
203: resp.embargo_flag = 'Y' THEN

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

200: x_SrvTab(i).Service_Result := 'Y';
201: ELSIF
202: l_service_type = 'EM' AND
203: resp.embargo_flag = 'Y' THEN
204: OE_DEBUG_PUB.Add('Embargo is found' );
205: x_SrvTab(i).Service_Result := 'Y';
206: END IF;
207:
208: IF(x_interpreted_value = SYSTEM_ERROR) THEN

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

219:
220: EXCEPTION
221: WHEN OTHERS THEN
222: l_sql_error := SQLERRM;
223: OE_DEBUG_PUB.Add('Processing Failed with an Error');
224: OE_DEBUG_PUB.Add('The unexpected error is :' || l_sql_error);
225: x_interpreted_value := SYSTEM_ERROR;
226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
227: END ONT_RESPONSE_ANALYSER;

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

220: EXCEPTION
221: WHEN OTHERS THEN
222: l_sql_error := SQLERRM;
223: OE_DEBUG_PUB.Add('Processing Failed with an Error');
224: OE_DEBUG_PUB.Add('The unexpected error is :' || l_sql_error);
225: x_interpreted_value := SYSTEM_ERROR;
226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
227: END ONT_RESPONSE_ANALYSER;
228:

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

263: AND wrc.original_system_line_reference = nvl ( p_reference_line_id, wrc.original_system_line_reference)
264: AND wrc.process_flag IN (1,2);
265:
266: BEGIN
267: OE_DEBUG_PUB.Add('Inside ONT_RESPONSE_ANALYSER');
268: ------------------------------------------
269: -- Print the values of all the parameters.
270: ------------------------------------------
271: OE_DEBUG_PUB.Add('Reference ID ' || p_reference_id);

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

267: OE_DEBUG_PUB.Add('Inside ONT_RESPONSE_ANALYSER');
268: ------------------------------------------
269: -- Print the values of all the parameters.
270: ------------------------------------------
271: OE_DEBUG_PUB.Add('Reference ID ' || p_reference_id);
272: OE_DEBUG_PUB.Add('Reference Line ID ' || p_reference_line_id);
273:
274: FOR cur_rec in Get_Request_Control LOOP
275: OE_DEBUG_PUB.Add(' Calling ONT_RESPONSE_ANALYSER for reqID' || cur_rec.request_control_id);

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

268: ------------------------------------------
269: -- Print the values of all the parameters.
270: ------------------------------------------
271: OE_DEBUG_PUB.Add('Reference ID ' || p_reference_id);
272: OE_DEBUG_PUB.Add('Reference Line ID ' || p_reference_line_id);
273:
274: FOR cur_rec in Get_Request_Control LOOP
275: OE_DEBUG_PUB.Add(' Calling ONT_RESPONSE_ANALYSER for reqID' || cur_rec.request_control_id);
276:

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

271: OE_DEBUG_PUB.Add('Reference ID ' || p_reference_id);
272: OE_DEBUG_PUB.Add('Reference Line ID ' || p_reference_line_id);
273:
274: FOR cur_rec in Get_Request_Control LOOP
275: OE_DEBUG_PUB.Add(' Calling ONT_RESPONSE_ANALYSER for reqID' || cur_rec.request_control_id);
276:
277: ONT_RESPONSE_ANALYSER (
278: p_request_control_id => cur_rec.request_control_id,
279: x_interpreted_value => x_interpreted_value,

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

280: x_return_status => x_return_status,
281: x_SrvTab => x_SrvTab
282: );
283: END LOOP;
284: OE_DEBUG_PUB.Add(' Done with ONT_RESPONSE_ANALYSER');
285:
286: END ONT_RESPONSE_ANALYSER;
287:
288: END WSH_ITM_RESPONSE_PKG;