DBA Data[Home] [Help]

APPS.ICX_POR_TRACK_VALIDATE_JOB_S dependencies on ICX_POR_TRACK_VALIDATE_JOB_S

Line 1: package body icx_por_track_validate_job_s as

1: package body icx_por_track_validate_job_s as
2: /* $Header: ICXVALJB.pls 115.33 2004/03/31 21:43:36 vkartik ship $ */
3:
4: g_error_message varchar2(1000) := '';
5:

Line 43: (-20000, 'Exception at icx_por_track_validate_job_s.update_job_status(ErrLoc = ' || l_progress ||') ' ||

39: exception
40: when others then
41: Debug('[update_job_status-'||l_progress||'] '||SQLERRM);
42: RAISE_APPLICATION_ERROR
43: (-20000, 'Exception at icx_por_track_validate_job_s.update_job_status(ErrLoc = ' || l_progress ||') ' ||
44: 'SQL Error : ' || SQLERRM);
45: end;
46:
47: FUNCTION create_job(p_supplier_id IN NUMBER,

Line 119: (-20000, 'Exception at icx_por_track_validate_job_s.create_job(ErrLoc = ' || l_progress ||') ' ||

115: exception
116: when others then
117: Debug('[create_job-'||l_progress||'] '||SQLERRM);
118: RAISE_APPLICATION_ERROR
119: (-20000, 'Exception at icx_por_track_validate_job_s.create_job(ErrLoc = ' || l_progress ||') ' ||
120: 'SQL Error : ' || SQLERRM);
121: END create_job;
122:
123: FUNCTION create_job(p_supplier_id IN NUMBER,

Line 180: (-20000, 'Exception at icx_por_track_validate_job_s.create_job(ErrLoc = ' || l_progress ||') ' ||

176: exception
177: when others then
178: Debug('[create_job-'||l_progress||'] '||SQLERRM);
179: RAISE_APPLICATION_ERROR
180: (-20000, 'Exception at icx_por_track_validate_job_s.create_job(ErrLoc = ' || l_progress ||') ' ||
181: 'SQL Error : ' || SQLERRM);
182: END create_job;
183:
184: FUNCTION delete_job(p_jobno in number) return varchar2 is

Line 240: 'Exception at icx_por_track_validate_job_s.log(' || xErrLoc || '): ' || SQLERRM);

236: ICX_POR_EXT_UTL.closeLog;
237: end if;
238:
239: RAISE_APPLICATION_ERROR(-20000,
240: 'Exception at icx_por_track_validate_job_s.log(' || xErrLoc || '): ' || SQLERRM);
241: END log;
242:
243:
244: /* Procedure to set the debug channel*/

Line 274: 'Exception at icx_por_track_validate_job_s.init_fnd_debug('

270: WHEN OTHERS THEN
271: ROLLBACK;
272:
273: RAISE_APPLICATION_ERROR(-20000,
274: 'Exception at icx_por_track_validate_job_s.init_fnd_debug('
275: || xErrLoc || '): ' || SQLERRM);
276: END init_fnd_debug;
277:
278: end icx_por_track_validate_job_s;

Line 278: end icx_por_track_validate_job_s;

274: 'Exception at icx_por_track_validate_job_s.init_fnd_debug('
275: || xErrLoc || '): ' || SQLERRM);
276: END init_fnd_debug;
277:
278: end icx_por_track_validate_job_s;