APPS.ICX_POR_JOB_TRACK_VALIDATION_S dependencies on ICX_POR_JOB_TRACK_VALIDATION_S

Line 1: package body icx_por_job_track_validation_s as

1: package body icx_por_job_track_validation_s as
2: /* $Header: ICXJVALB.pls 115.5 2001/06/29 18:03:56 pkm ship $ */
3:
4: g_error_message varchar2(1000) := '';
5:

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

26: exception
27: when others then
28: Debug('[update_job_status-'||l_progress||'] '||SQLERRM);
29: RAISE_APPLICATION_ERROR
30: (-20000, 'Exception at icx_por_job_track_validation_s.update_job_status(ErrLoc = ' || l_progress ||') ' ||
31: 'SQL Error : ' || SQLERRM);
32: end;
33:
34: procedure complete_job(p_jobno in number) is

Line 48: (-20000, 'Exception at icx_por_job_track_validation_s.complete_job(ErrLoc = ' || l_progress ||') ' ||

44: exception
45: when others then
46: Debug('[complete_job-'||l_progress||'] '||SQLERRM);
47: RAISE_APPLICATION_ERROR
48: (-20000, 'Exception at icx_por_job_track_validation_s.complete_job(ErrLoc = ' || l_progress ||') ' ||
49: 'SQL Error : ' || SQLERRM);
50: end;
51:
52: procedure fail_job(p_jobno in number,

Line 73: (-20000, 'Exception at icx_por_job_track_validation_s.fail_job(ErrLoc = ' || l_progress ||') ' ||

69: exception
70: when others then
71: Debug('[fail_job-'||l_progress||'] '||SQLERRM);
72: RAISE_APPLICATION_ERROR
73: (-20000, 'Exception at icx_por_job_track_validation_s.fail_job(ErrLoc = ' || l_progress ||') ' ||
74: 'SQL Error : ' || SQLERRM);
75: end;
76:
77: procedure InsertError(p_jobno in out number,

Line 110: (-20000, 'Exception at icx_por_job_track_validation_s.InsertError(ErrLoc = ' || l_progress ||') ' ||

106: exception
107: when others then
108: Debug('[InsertError-'||l_progress||'] '||SQLERRM);
109: RAISE_APPLICATION_ERROR
110: (-20000, 'Exception at icx_por_job_track_validation_s.InsertError(ErrLoc = ' || l_progress ||') ' ||
111: 'SQL Error : ' || SQLERRM);
112: end;
113:
114: function validate_item_price(p_jobno in out number,

Line 546: (-20000, 'Exception at icx_por_job_track_validation_s.validate_item_price(ErrLoc = ' || l_progress ||') ' ||

542: exception
543: when others then
544: Debug('[validate_item_price-'||l_progress||'] '||SQLERRM);
545: RAISE_APPLICATION_ERROR
546: (-20000, 'Exception at icx_por_job_track_validation_s.validate_item_price(ErrLoc = ' || l_progress ||') ' ||
547: 'SQL Error : ' || SQLERRM);
548: end;
549:
550: procedure get_next_job(p_jobno out number,

Line 597: (-20000, 'Exception at icx_por_job_track_validation_s.get_next_job(E

593: exception
594: when others then
595: Debug('[get_next_job-'||l_progress||'] '||SQLERRM);
596: RAISE_APPLICATION_ERROR
597: (-20000, 'Exception at icx_por_job_track_validation_s.get_next_job(E
598: rrLoc = ' || l_progress ||') ' ||
599: 'SQL Error : ' || SQLERRM);
600: end;
601:

Line 654: (-20000, 'Exception at icx_por_job_track_validation_s.create_job(Err

650: exception
651: when others then
652: Debug('[create_job-'||l_progress||'] '||SQLERRM);
653: RAISE_APPLICATION_ERROR
654: (-20000, 'Exception at icx_por_job_track_validation_s.create_job(Err
655: Loc = ' || l_progress ||') ' ||
656: 'SQL Error : ' || SQLERRM);
657: end;
658:

Line 659: end icx_por_job_track_validation_s;

655: Loc = ' || l_progress ||') ' ||
656: 'SQL Error : ' || SQLERRM);
657: end;
658:
659: end icx_por_job_track_validation_s;