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: