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.IEU_WORK_SOURCE_PVT dependencies on FND_API

Line 72: x_return_status := fnd_api.g_ret_sts_success;

68: l_no := 'N';
69: l_ws_not_valid_flag := 'Y';
70: l_deactive_time := sysdate-1;
71: fnd_msg_pub.delete_msg();
72: x_return_status := fnd_api.g_ret_sts_success;
73: FND_MSG_PUB.initialize;
74: x_msg_data := '';
75: select to_char(sysdate, 'yyyy/mm/dd') into l_temp_date from dual;
76: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

Line 212: x_return_status := fnd_api.g_ret_sts_error;

208: END IF ;-- props table
209:
210: END if;
211: else
212: x_return_status := fnd_api.g_ret_sts_error;
213: x_msg_count := x_msg_count+1;
214: x_msg_data := x_msg_data||'IEU_PROV_WS_CREATE_ERROR$';
215: END if;
216: commit;

Line 218: WHEN fnd_api.g_exc_error THEN

214: x_msg_data := x_msg_data||'IEU_PROV_WS_CREATE_ERROR$';
215: END if;
216: commit;
217: EXCEPTION
218: WHEN fnd_api.g_exc_error THEN
219: ROLLBACK;
220: x_return_status := fnd_api.g_ret_sts_error;
221: x_msg_data := x_msg_data || ' , fnd_api.g_exc_error.';
222:

Line 220: x_return_status := fnd_api.g_ret_sts_error;

216: commit;
217: EXCEPTION
218: WHEN fnd_api.g_exc_error THEN
219: ROLLBACK;
220: x_return_status := fnd_api.g_ret_sts_error;
221: x_msg_data := x_msg_data || ' , fnd_api.g_exc_error.';
222:
223:
224: WHEN fnd_api.g_exc_unexpected_error THEN

Line 221: x_msg_data := x_msg_data || ' , fnd_api.g_exc_error.';

217: EXCEPTION
218: WHEN fnd_api.g_exc_error THEN
219: ROLLBACK;
220: x_return_status := fnd_api.g_ret_sts_error;
221: x_msg_data := x_msg_data || ' , fnd_api.g_exc_error.';
222:
223:
224: WHEN fnd_api.g_exc_unexpected_error THEN
225: ROLLBACK;

Line 224: WHEN fnd_api.g_exc_unexpected_error THEN

220: x_return_status := fnd_api.g_ret_sts_error;
221: x_msg_data := x_msg_data || ' , fnd_api.g_exc_error.';
222:
223:
224: WHEN fnd_api.g_exc_unexpected_error THEN
225: ROLLBACK;
226: x_return_status := fnd_api.g_ret_sts_unexp_error;
227: x_msg_data := x_msg_data || ' , fnd_api.g_exc_unexpected_error.';
228:

Line 226: x_return_status := fnd_api.g_ret_sts_unexp_error;

222:
223:
224: WHEN fnd_api.g_exc_unexpected_error THEN
225: ROLLBACK;
226: x_return_status := fnd_api.g_ret_sts_unexp_error;
227: x_msg_data := x_msg_data || ' , fnd_api.g_exc_unexpected_error.';
228:
229: WHEN no_data_found THEN
230: ROLLBACK;

Line 227: x_msg_data := x_msg_data || ' , fnd_api.g_exc_unexpected_error.';

223:
224: WHEN fnd_api.g_exc_unexpected_error THEN
225: ROLLBACK;
226: x_return_status := fnd_api.g_ret_sts_unexp_error;
227: x_msg_data := x_msg_data || ' , fnd_api.g_exc_unexpected_error.';
228:
229: WHEN no_data_found THEN
230: ROLLBACK;
231: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 231: x_return_status := fnd_api.g_ret_sts_unexp_error;

227: x_msg_data := x_msg_data || ' , fnd_api.g_exc_unexpected_error.';
228:
229: WHEN no_data_found THEN
230: ROLLBACK;
231: x_return_status := fnd_api.g_ret_sts_unexp_error;
232: x_msg_data := x_msg_data || ' , no_data_found.';
233:
234:
235: WHEN OTHERS THEN

Line 237: x_return_status := fnd_api.g_ret_sts_unexp_error;

233:
234:
235: WHEN OTHERS THEN
236: ROLLBACK;
237: x_return_status := fnd_api.g_ret_sts_unexp_error;
238: x_msg_data := x_msg_data || ' , others.'|| sqlerrm;
239:
240: END loadWorkSource;
241:

Line 258: x_return_status := fnd_api.g_ret_sts_success;

254:
255: begin
256: l_not_valid_flag := 'N';
257: fnd_msg_pub.delete_msg();
258: x_return_status := fnd_api.g_ret_sts_success;
259: FND_MSG_PUB.initialize;
260: x_msg_data := '';
261: -- nothing need to check here since distribution function already be checked in javabean
262: -- check work source name and work source code

Line 266: x_return_status := fnd_api.g_ret_sts_error;

262: -- check work source name and work source code
263: EXECUTE IMMEDIATE ' select count(*) from ieu_uwqm_work_sources_b where upper(ws_code) = upper(:1) and not_valid_flag=:2 '
264: INTO l_count USING p_ws_code, l_not_valid_flag ;
265: IF (l_count > 0) then
266: x_return_status := fnd_api.g_ret_sts_error;
267: x_msg_count := x_msg_count+1;
268: x_msg_data := 'IEU_PROV_WS_CODE_INVALID$';
269: END if;
270: IF (r_mode = 'create') then

Line 276: x_return_status := fnd_api.g_ret_sts_error;

272: ' where upper(tl.ws_name) = upper(:1) and b.not_valid_flag=:2 ' ||
273: ' and b.ws_id = tl.ws_id and tl.language = :3 '
274: INTO l_count USING p_ws_name, l_not_valid_flag, FND_GLOBAL.CURRENT_LANGUAGE ;
275: IF (l_count > 0) then
276: x_return_status := fnd_api.g_ret_sts_error;
277: x_msg_count := x_msg_count+1;
278: x_msg_data :=x_msg_data||'IEU_PROV_WS_NAME_INVALID$';
279: END if;
280: IF (p_ws_parent_id <> '0') then

Line 284: x_return_status := fnd_api.g_ret_sts_error;

280: IF (p_ws_parent_id <> '0') then
281: EXECUTE IMMEDIATE ' select count(*) from ieu_uwqm_ws_assct_props where parent_ws_id = :1 and child_ws_id = :2 '
282: INTO l_count USING p_ws_parent_id, p_ws_child_id;
283: IF (l_count > 0) then
284: x_return_status := fnd_api.g_ret_sts_error;
285: x_msg_count := x_msg_count+1;
286: x_msg_data := x_msg_data||'IEU_PROV_WS_COMB_INVALID$';
287: END if;
288: END if;

Line 292: WHEN fnd_api.g_exc_error THEN

288: END if;
289: END if;
290: EXCEPTION
291:
292: WHEN fnd_api.g_exc_error THEN
293: ROLLBACK;
294: x_return_status := fnd_api.g_ret_sts_error;
295:
296: WHEN fnd_api.g_exc_unexpected_error THEN

Line 294: x_return_status := fnd_api.g_ret_sts_error;

290: EXCEPTION
291:
292: WHEN fnd_api.g_exc_error THEN
293: ROLLBACK;
294: x_return_status := fnd_api.g_ret_sts_error;
295:
296: WHEN fnd_api.g_exc_unexpected_error THEN
297: ROLLBACK;
298: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 296: WHEN fnd_api.g_exc_unexpected_error THEN

292: WHEN fnd_api.g_exc_error THEN
293: ROLLBACK;
294: x_return_status := fnd_api.g_ret_sts_error;
295:
296: WHEN fnd_api.g_exc_unexpected_error THEN
297: ROLLBACK;
298: x_return_status := fnd_api.g_ret_sts_unexp_error;
299:
300: WHEN NO_DATA_FOUND THEN

Line 298: x_return_status := fnd_api.g_ret_sts_unexp_error;

294: x_return_status := fnd_api.g_ret_sts_error;
295:
296: WHEN fnd_api.g_exc_unexpected_error THEN
297: ROLLBACK;
298: x_return_status := fnd_api.g_ret_sts_unexp_error;
299:
300: WHEN NO_DATA_FOUND THEN
301: null;
302:

Line 305: x_return_status := fnd_api.g_ret_sts_unexp_error;

301: null;
302:
303: WHEN OTHERS THEN
304: ROLLBACK;
305: x_return_status := fnd_api.g_ret_sts_unexp_error;
306:
307:
308: commit;
309: END validateObj;