APPS.GMF_GLSYNCH dependencies on SY_EXCP_TBL

Line 6: /* This procedure will insert exceptions into the sy_excp_tbl.

2: /* $Header: gmfsyncb.pls 115.10 2002/11/11 00:46:04 rseshadr ship $ */
3: /* Package variable will be used in cursor fetches */
4: DummyN NUMBER := 0;
5:
6: /* This procedure will insert exceptions into the sy_excp_tbl.
7: The interface_id and co_code will always be -99 and ' ' respectively.*/
8:
9: PROCEDURE Write_Exception(
10: pi_table_code in varchar2,

Line 27: INSERT into sy_excp_tbl(

23: BEGIN
24: Gmf_Session_Vars.FOUND_ERRORS := 'Y';
25: <>
26: IF Gmf_Session_Vars.GL_LOG_TRIGGER_ERROR = 1 THEN
27: INSERT into sy_excp_tbl(
28: software_code,
29: table_code ,
30: message_code ,
31: exception_date ,

Line 108: /* This procedure will delete exceptions from the sy_excp_tbl. */

104: WHEN others THEN
105: null;
106: END; /*Write_Exception*/
107:
108: /* This procedure will delete exceptions from the sy_excp_tbl. */
109:
110: PROCEDURE Delete_Exception(
111: pi_table_code in varchar2,
112: pi_key_value in varchar2) IS

Line 114: DELETE FROM sy_excp_tbl

110: PROCEDURE Delete_Exception(
111: pi_table_code in varchar2,
112: pi_key_value in varchar2) IS
113: BEGIN
114: DELETE FROM sy_excp_tbl
115: WHERE key_value = pi_key_value
116: AND table_code = pi_table_code;
117:
118: EXCEPTION

Line 126: If it is NULL, it logs an error into the sy_excp_tbl. */

122:
123:
124:
125: /* This procedure will check if the field_value is NULL.
126: If it is NULL, it logs an error into the sy_excp_tbl. */
127:
128: PROCEDURE Check_Required(
129: pi_table_name in varchar2,
130: pi_key_name in varchar2,

Line 147: sy_excp_tbl. */

143:
144:
145: /* This procedure will check if the field_value is
146: in Upper case. If not, it logs an error into the
147: sy_excp_tbl. */
148:
149: PROCEDURE Check_Case(
150: pi_table_name in varchar2,
151: pi_key_name in varchar2,

Line 168: into the sy_excp_tbl. */

164:
165:
166: /* This procedure will check if the length the field_value
167: is greater than field_length. If yes, it logs an error
168: into the sy_excp_tbl. */
169:
170: PROCEDURE Check_Length(
171: pi_table_name in varchar2,
172: pi_key_name in varchar2,

Line 228: If yes, it logs an error into the sy_excp_tbl. */

224:
225:
226: /* This procedure will check if the field_value contains
227: multiple delimiters.
228: If yes, it logs an error into the sy_excp_tbl. */
229:
230: PROCEDURE Check_Multiple_Delim(
231: pi_table_name in varchar2,
232: pi_key_name in varchar2,