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

Line 86: oe_debug_pub.add('Inside the procedure WSH_ITM_UTIL.GET_SERVICE_DETAILS');

82:
83: BEGIN
84: --
85: x_return_status := FND_API.G_RET_STS_SUCCESS;
86: oe_debug_pub.add('***Inside the procedure WSH_ITM_UTIL.GET_SERVICE_DETAILS***');
87: oe_debug_pub.add('Application Id ' || p_application_id);
88: oe_debug_pub.add('Master Organization Id ' || p_master_organization_id);
89: oe_debug_pub.add('Organization Id ' || p_organization_id);
90:

Line 87: oe_debug_pub.add('Application Id ' || p_application_id);

83: BEGIN
84: --
85: x_return_status := FND_API.G_RET_STS_SUCCESS;
86: oe_debug_pub.add('***Inside the procedure WSH_ITM_UTIL.GET_SERVICE_DETAILS***');
87: oe_debug_pub.add('Application Id ' || p_application_id);
88: oe_debug_pub.add('Master Organization Id ' || p_master_organization_id);
89: oe_debug_pub.add('Organization Id ' || p_organization_id);
90:
91: service_tbl := G_MISS_SERVICE_TBL;

Line 88: oe_debug_pub.add('Master Organization Id ' || p_master_organization_id);

84: --
85: x_return_status := FND_API.G_RET_STS_SUCCESS;
86: oe_debug_pub.add('***Inside the procedure WSH_ITM_UTIL.GET_SERVICE_DETAILS***');
87: oe_debug_pub.add('Application Id ' || p_application_id);
88: oe_debug_pub.add('Master Organization Id ' || p_master_organization_id);
89: oe_debug_pub.add('Organization Id ' || p_organization_id);
90:
91: service_tbl := G_MISS_SERVICE_TBL;
92:

Line 89: oe_debug_pub.add('Organization Id ' || p_organization_id);

85: x_return_status := FND_API.G_RET_STS_SUCCESS;
86: oe_debug_pub.add('***Inside the procedure WSH_ITM_UTIL.GET_SERVICE_DETAILS***');
87: oe_debug_pub.add('Application Id ' || p_application_id);
88: oe_debug_pub.add('Master Organization Id ' || p_master_organization_id);
89: oe_debug_pub.add('Organization Id ' || p_organization_id);
90:
91: service_tbl := G_MISS_SERVICE_TBL;
92:
93: BEGIN

Line 103: oe_debug_pub.add('Additional Country Code is ' || l_addl_country_code);

99: WHEN NO_DATA_FOUND THEN
100: l_addl_country_code := '';
101: END;
102:
103: oe_debug_pub.add('Additional Country Code is ' || l_addl_country_code);
104:
105: FOR ser_details IN Get_Services(p_application_id, p_master_organization_id)
106: LOOP
107:

Line 121: oe_debug_pub.add('Service Type ' || service_tbl(i).service_type_code);

117: ELSE
118: service_tbl(i).addl_country_code := '';
119: END IF;
120:
121: oe_debug_pub.add('Service Type ' || service_tbl(i).service_type_code);
122: oe_debug_pub.add('Additional Country Code ' || service_tbl(i).addl_country_code );
123:
124: i := i + 1;
125:

Line 122: oe_debug_pub.add('Additional Country Code ' || service_tbl(i).addl_country_code );

118: service_tbl(i).addl_country_code := '';
119: END IF;
120:
121: oe_debug_pub.add('Service Type ' || service_tbl(i).service_type_code);
122: oe_debug_pub.add('Additional Country Code ' || service_tbl(i).addl_country_code );
123:
124: i := i + 1;
125:
126: IF vendor_id = 0 then

Line 138: oe_debug_pub.add('Supports Combination Flag ' || comb_flag );

134: vendor_id := ser_details.vendor_id;
135:
136: END LOOP;
137:
138: oe_debug_pub.add('Supports Combination Flag ' || comb_flag );
139: x_supports_combination_flag := comb_flag;
140: x_service_tbl := service_tbl;
141: oe_debug_pub.add('***End of the procedure WSH_ITM_UTIL.GET_SERVICE_DETAILS***');
142:

Line 141: oe_debug_pub.add('End of the procedure WSH_ITM_UTIL.GET_SERVICE_DETAILS');

137:
138: oe_debug_pub.add('Supports Combination Flag ' || comb_flag );
139: x_supports_combination_flag := comb_flag;
140: x_service_tbl := service_tbl;
141: oe_debug_pub.add('***End of the procedure WSH_ITM_UTIL.GET_SERVICE_DETAILS***');
142:
143:
144: EXCEPTION
145:

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

144: EXCEPTION
145:
146: WHEN OTHERS THEN
147: l_sql_error := SQLERRM;
148: OE_DEBUG_PUB.Add('Processing Failed with an Error');
149: OE_DEBUG_PUB.Add('The unexpected error is :' || l_sql_error);
150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
151:
152: END GET_SERVICE_DETAILS;

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

145:
146: WHEN OTHERS THEN
147: l_sql_error := SQLERRM;
148: OE_DEBUG_PUB.Add('Processing Failed with an Error');
149: OE_DEBUG_PUB.Add('The unexpected error is :' || l_sql_error);
150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
151:
152: END GET_SERVICE_DETAILS;
153:

Line 177: oe_debug_pub.add('In the procedure WSH_ITM_UTIL.UPDATE_PROCESS_FLAG');

173: BEGIN
174:
175: --
176: x_return_status := FND_API.G_RET_STS_SUCCESS;
177: oe_debug_pub.add('In the procedure WSH_ITM_UTIL.UPDATE_PROCESS_FLAG');
178:
179: FORALL i IN p_control_id_list.FIRST..p_control_id_list.LAST
180: UPDATE WSH_ITM_REQUEST_CONTROL
181: SET

Line 185: oe_debug_pub.add('End of the procedure WSH_ITM_UTIL.UPDATE_PROCESS_FLAG');

181: SET
182: PROCESS_FLAG = p_process_flag
183: WHERE REQUEST_CONTROL_ID = p_control_id_list(i);
184:
185: oe_debug_pub.add('End of the procedure WSH_ITM_UTIL.UPDATE_PROCESS_FLAG');
186:
187: EXCEPTION
188:
189: WHEN OTHERS THEN

Line 191: oe_debug_pub.add('Processing Failed with an Error');

187: EXCEPTION
188:
189: WHEN OTHERS THEN
190: l_sql_error := SQLERRM;
191: oe_debug_pub.add('Processing Failed with an Error');
192: oe_debug_pub.add('The unexpected error is :' || l_sql_error);
193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
194:
195: END UPDATE_PROCESS_FLAG;

Line 192: oe_debug_pub.add('The unexpected error is :' || l_sql_error);

188:
189: WHEN OTHERS THEN
190: l_sql_error := SQLERRM;
191: oe_debug_pub.add('Processing Failed with an Error');
192: oe_debug_pub.add('The unexpected error is :' || l_sql_error);
193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
194:
195: END UPDATE_PROCESS_FLAG;
196:

Line 300: oe_debug_pub.add('In the procedure WSH_ITM_UTIL.GET_COMPLIANCE_STATUS');

296: BEGIN
297:
298: --
299: x_return_status := FND_API.G_RET_STS_SUCCESS;
300: oe_debug_pub.add('In the procedure WSH_ITM_UTIL.GET_COMPLIANCE_STATUS');
301: oe_debug_pub.add('p_appliciation_id :' || p_appliciation_id );
302: oe_debug_pub.add('p_original_sys_reference :' || p_original_sys_reference );
303: oe_debug_pub.add('p_original_sys_line_reference :' || p_original_sys_line_reference );
304:

Line 301: oe_debug_pub.add('p_appliciation_id :' || p_appliciation_id );

297:
298: --
299: x_return_status := FND_API.G_RET_STS_SUCCESS;
300: oe_debug_pub.add('In the procedure WSH_ITM_UTIL.GET_COMPLIANCE_STATUS');
301: oe_debug_pub.add('p_appliciation_id :' || p_appliciation_id );
302: oe_debug_pub.add('p_original_sys_reference :' || p_original_sys_reference );
303: oe_debug_pub.add('p_original_sys_line_reference :' || p_original_sys_line_reference );
304:
305: IF p_appliciation_id IS NOT NULL THEN

Line 302: oe_debug_pub.add('p_original_sys_reference :' || p_original_sys_reference );

298: --
299: x_return_status := FND_API.G_RET_STS_SUCCESS;
300: oe_debug_pub.add('In the procedure WSH_ITM_UTIL.GET_COMPLIANCE_STATUS');
301: oe_debug_pub.add('p_appliciation_id :' || p_appliciation_id );
302: oe_debug_pub.add('p_original_sys_reference :' || p_original_sys_reference );
303: oe_debug_pub.add('p_original_sys_line_reference :' || p_original_sys_line_reference );
304:
305: IF p_appliciation_id IS NOT NULL THEN
306: --{

Line 303: oe_debug_pub.add('p_original_sys_line_reference :' || p_original_sys_line_reference );

299: x_return_status := FND_API.G_RET_STS_SUCCESS;
300: oe_debug_pub.add('In the procedure WSH_ITM_UTIL.GET_COMPLIANCE_STATUS');
301: oe_debug_pub.add('p_appliciation_id :' || p_appliciation_id );
302: oe_debug_pub.add('p_original_sys_reference :' || p_original_sys_reference );
303: oe_debug_pub.add('p_original_sys_line_reference :' || p_original_sys_line_reference );
304:
305: IF p_appliciation_id IS NOT NULL THEN
306: --{
307:

Line 312: oe_debug_pub.add('P_original_sys_reference and p_original_sys_line_reference are mandatory parameter for appplication_id 660');

308: IF p_appliciation_id = 660 THEN
309: --{
310: IF ( p_original_sys_reference IS NULL OR p_original_sys_line_reference IS NULL ) THEN
311: --{
312: oe_debug_pub.add('P_original_sys_reference and p_original_sys_line_reference are mandatory parameter for appplication_id 660');
313: RAISE MISSING_INPUT ;
314: --}
315: END IF;
316:

Line 325: oe_debug_pub.add('Applciation_id is invalid');

321: CLOSE c_get_compliance_details;
322: --}
323: ELSE
324: --{
325: oe_debug_pub.add('Applciation_id is invalid');
326: RAISE INVALID_APPLICATION;
327: --}
328: END IF;
329: --}

Line 332: oe_debug_pub.add('Application_id is mandatory');

328: END IF;
329: --}
330: ELSE
331: --{
332: oe_debug_pub.add('Application_id is mandatory');
333: RAISE MISSING_INPUT ;
334: --}
335: END IF;
336:

Line 341: oe_debug_pub.add('End of the procedure WSH_ITM_UTIL.GET_COMPLIANCE_STATUS');

337: x_process_flag := l_process_flag;
338: x_request_control_id := l_request_control_id;
339: x_request_set_id := l_request_set_id;
340:
341: oe_debug_pub.add('End of the procedure WSH_ITM_UTIL.GET_COMPLIANCE_STATUS');
342: --
343: EXCEPTION
344:
345: WHEN INVALID_APPLICATION THEN

Line 346: oe_debug_pub.add('Processing Failed as application_id provided is invalid ');

342: --
343: EXCEPTION
344:
345: WHEN INVALID_APPLICATION THEN
346: oe_debug_pub.add('Processing Failed as application_id provided is invalid ');
347: x_return_status := FND_API.G_RET_STS_ERROR;
348:
349: WHEN MISSING_INPUT THEN
350: oe_debug_pub.add('Processing Failed as some mandatory parameters are missing ');

Line 350: oe_debug_pub.add('Processing Failed as some mandatory parameters are missing ');

346: oe_debug_pub.add('Processing Failed as application_id provided is invalid ');
347: x_return_status := FND_API.G_RET_STS_ERROR;
348:
349: WHEN MISSING_INPUT THEN
350: oe_debug_pub.add('Processing Failed as some mandatory parameters are missing ');
351: x_return_status := FND_API.G_RET_STS_ERROR;
352:
353: WHEN OTHERS THEN
354:

Line 359: oe_debug_pub.add('Processing Failed with an Error');

355: IF c_get_compliance_details%ISOPEN THEN
356: CLOSE c_get_compliance_details;
357: END IF;
358: l_sql_error := SQLERRM;
359: oe_debug_pub.add('Processing Failed with an Error');
360: oe_debug_pub.add('The unexpected error is :' || l_sql_error);
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
362:
363: END GET_COMPLIANCE_STATUS;

Line 360: oe_debug_pub.add('The unexpected error is :' || l_sql_error);

356: CLOSE c_get_compliance_details;
357: END IF;
358: l_sql_error := SQLERRM;
359: oe_debug_pub.add('Processing Failed with an Error');
360: oe_debug_pub.add('The unexpected error is :' || l_sql_error);
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
362:
363: END GET_COMPLIANCE_STATUS;
364: