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.GMF_GLSYNCH dependencies on GMF_SESSION_VARS

Line 24: Gmf_Session_Vars.FOUND_ERRORS := 'Y';

20: message_id number;
21: message_text varchar2(512);
22: error_status number;
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,

Line 26: IF Gmf_Session_Vars.GL_LOG_TRIGGER_ERROR = 1 THEN

22: error_status number;
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 ,

Line 55: Gmf_session_vars.last_updated_by,

51: substrb(pi_col3, 1, 64),
52: substrb(pi_col4, 1, 64),
53: substrb(pi_col5, 1, 64),
54: sysdate,
55: Gmf_session_vars.last_updated_by,
56: Gmf_session_vars.last_updated_by,
57: sysdate,
58: -99,
59: decode(pi_table_code, 'Customers', Gmf_Session_Vars.GL_EXCP_CO_CODE, NULL),

Line 56: Gmf_session_vars.last_updated_by,

52: substrb(pi_col4, 1, 64),
53: substrb(pi_col5, 1, 64),
54: sysdate,
55: Gmf_session_vars.last_updated_by,
56: Gmf_session_vars.last_updated_by,
57: sysdate,
58: -99,
59: decode(pi_table_code, 'Customers', Gmf_Session_Vars.GL_EXCP_CO_CODE, NULL),
60: substrb(pi_key_value, 1, 256));

Line 59: decode(pi_table_code, 'Customers', Gmf_Session_Vars.GL_EXCP_CO_CODE, NULL),

55: Gmf_session_vars.last_updated_by,
56: Gmf_session_vars.last_updated_by,
57: sysdate,
58: -99,
59: decode(pi_table_code, 'Customers', Gmf_Session_Vars.GL_EXCP_CO_CODE, NULL),
60: substrb(pi_key_value, 1, 256));
61: ELSE
62: BEGIN
63: message_args (1) := substrb(pi_key_name || ' ''' || pi_key_value || '''', 1, 64);

Line 72: gmf_session_vars.last_updated_by,

68:
69: GMF_MSG_PKG.get_msg_from_code(message_id,
70: pi_message_code,
71: message_text,
72: gmf_session_vars.last_updated_by,
73: message_args,
74: error_status);
75:
76: Gmf_Session_Vars.ERROR_TEXT := substrb(message_text,1,512);

Line 76: Gmf_Session_Vars.ERROR_TEXT := substrb(message_text,1,512);

72: gmf_session_vars.last_updated_by,
73: message_args,
74: error_status);
75:
76: Gmf_Session_Vars.ERROR_TEXT := substrb(message_text,1,512);
77:
78: EXCEPTION
79: /*
80: When there is no user defined in the GEMMS for the

Line 96: Gmf_Session_Vars.ERROR_TEXT := substrb(message_text,1,512);

92: 'ORAF',
93: message_args,
94: error_status);
95:
96: Gmf_Session_Vars.ERROR_TEXT := substrb(message_text,1,512);
97: EXCEPTION
98: When others THEN
99: Gmf_Session_Vars.ERROR_TEXT:=pi_message_code;
100: END;

Line 99: Gmf_Session_Vars.ERROR_TEXT:=pi_message_code;

95:
96: Gmf_Session_Vars.ERROR_TEXT := substrb(message_text,1,512);
97: EXCEPTION
98: When others THEN
99: Gmf_Session_Vars.ERROR_TEXT:=pi_message_code;
100: END;
101: END;
102: END IF; /*GL_LOG_TRIGGER_ERROR*/
103: EXCEPTION

Line 140: RAISE Gmf_Session_Vars.ex_error_found;

136: write_exception(pi_table_name, pi_key_name,
137: 'GL_MISSING_VAL', ' ',
138: pi_field_name, pi_field_value,
139: ' ', ' ', pi_key_value);
140: RAISE Gmf_Session_Vars.ex_error_found;
141: END IF;
142: END; /* Check_Required */
143:
144:

Line 161: RAISE Gmf_Session_Vars.ex_error_found;

157: write_exception(pi_table_name, pi_key_name,
158: 'GL_INVALID_CASE', ' ',
159: pi_field_value, pi_field_name,
160: ' ', ' ',pi_key_value);
161: RAISE Gmf_Session_Vars.ex_error_found;
162: END IF;
163: END; /* Check_Case */
164:
165:

Line 183: RAISE Gmf_Session_Vars.ex_error_found;

179: write_exception(pi_table_name, pi_key_name,
180: 'GL_INVALID_LEN', ' ',
181: pi_field_value, pi_field_name,
182: pi_field_length, ' ', pi_key_value);
183: RAISE Gmf_Session_Vars.ex_error_found;
184: END IF;
185: END; /* Check_Length */
186:
187:

Line 217: RAISE Gmf_Session_Vars.ex_error_found;

213: ' ', ' ',pi_key_value);
214: IF C_Val_Currency%ISOPEN THEN
215: CLOSE C_Val_Currency;
216: END IF;
217: RAISE Gmf_Session_Vars.ex_error_found;
218: END IF;
219: IF C_Val_Currency%ISOPEN THEN
220: CLOSE C_Val_Currency;
221: END IF;

Line 243: RAISE Gmf_Session_Vars.ex_error_found;

239: write_exception(pi_table_name, pi_key_name,
240: 'GL_INVALID_DELIM', ' ',
241: pi_field_value, pi_field_name,
242: ' ', ' ',pi_key_value);
243: RAISE Gmf_Session_Vars.ex_error_found;
244: END IF;
245: END; /* Check_Multiple_delimiters */
246:
247: /* This function validates that the Rate Type Codes

Line 272: RAISE Gmf_Session_Vars.ex_error_found;

268: write_exception(pi_table_name, pi_key_name,
269: 'GL_INVALID_VAL', ' ',
270: pi_field_value, pi_field_name,
271: ' ', ' ',pi_key_value);
272: RAISE Gmf_Session_Vars.ex_error_found;
273: IF C_Val_Rate_Type%ISOPEN THEN
274: CLOSE C_Val_Rate_Type;
275: END IF;
276: END IF;

Line 313: RAISE Gmf_Session_Vars.ex_error_found;

309: ' ', ' ',pi_key_value);
310: IF C_Val_Terms_Code%ISOPEN THEN
311: CLOSE C_Val_Terms_Code;
312: END IF;
313: RAISE Gmf_Session_Vars.ex_error_found;
314: END IF;
315: pi_field_value := v_temp_terms_code;
316: IF C_Val_Terms_Code%ISOPEN THEN
317: CLOSE C_Val_Terms_Code;

Line 352: RAISE Gmf_Session_Vars.ex_error_found;

348: ' ', ' ',pi_key_value);
349: IF C_Val_Shipper_Code%ISOPEN THEN
350: CLOSE C_Val_Shipper_Code;
351: END IF;
352: RAISE Gmf_Session_Vars.ex_error_found;
353: END IF;
354: pi_field_value := v_temp_shipper_code;
355: IF C_Val_Shipper_Code%ISOPEN THEN
356: CLOSE C_Val_Shipper_Code;

Line 391: RAISE Gmf_Session_Vars.ex_error_found;

387: ' ', ' ',pi_key_value);
388: IF C_Val_FOB_Code%ISOPEN THEN
389: CLOSE C_Val_FOB_Code;
390: END IF;
391: RAISE Gmf_Session_Vars.ex_error_found;
392: END IF;
393: pi_field_value := v_temp_fob_code;
394: IF C_Val_FOB_Code%ISOPEN THEN
395: CLOSE C_Val_FOB_Code;

Line 430: RAISE Gmf_Session_Vars.ex_error_found;

426: ' ', ' ',pi_key_value);
427: IF C_Val_Frtbill_Mthd%ISOPEN THEN
428: CLOSE C_Val_Frtbill_Mthd;
429: END IF;
430: RAISE Gmf_Session_Vars.ex_error_found;
431: END IF;
432: pi_field_value := v_temp_Frtbill_Mthd;
433: IF C_Val_Frtbill_Mthd%ISOPEN THEN
434: CLOSE C_Val_Frtbill_Mthd;

Line 467: RAISE Gmf_Session_Vars.ex_error_found;

463: ' ', ' ',pi_key_value);
464: IF C_Val_Vendgl_Class%ISOPEN THEN
465: CLOSE C_Val_Vendgl_Class;
466: END IF;
467: RAISE Gmf_Session_Vars.ex_error_found;
468: END IF;
469: IF C_Val_Vendgl_Class%ISOPEN THEN
470: CLOSE C_Val_Vendgl_Class;
471: END IF;

Line 503: RAISE Gmf_Session_Vars.ex_error_found;

499: ' ', ' ',pi_key_value);
500: IF C_Val_Slsrep_Code%ISOPEN THEN
501: CLOSE C_Val_Slsrep_Code;
502: END IF;
503: RAISE Gmf_Session_Vars.ex_error_found;
504: END IF;
505: IF C_Val_Slsrep_Code%ISOPEN THEN
506: CLOSE C_Val_Slsrep_Code;
507: END IF;

Line 539: RAISE Gmf_Session_Vars.ex_error_found;

535: ' ', ' ',pi_key_value);
536: IF C_Val_Cust_Class%ISOPEN THEN
537: CLOSE C_Val_Cust_Class;
538: END IF;
539: RAISE Gmf_Session_Vars.ex_error_found;
540: END IF;
541: IF C_Val_Cust_Class%ISOPEN THEN
542: CLOSE C_Val_Cust_Class;
543: END IF;

Line 575: RAISE Gmf_Session_Vars.ex_error_found;

571: ' ', ' ',pi_key_value);
572: IF C_Val_Custgl_Class%ISOPEN THEN
573: CLOSE C_Val_Custgl_Class;
574: END IF;
575: RAISE Gmf_Session_Vars.ex_error_found;
576: END IF;
577: IF C_Val_Custgl_Class%ISOPEN THEN
578: CLOSE C_Val_Custgl_Class;
579: END IF;

Line 611: RAISE Gmf_Session_Vars.ex_error_found;

607: ' ', ' ',pi_key_value);
608: IF C_Val_Custprice_Class%ISOPEN THEN
609: CLOSE C_Val_Custprice_Class;
610: END IF;
611: RAISE Gmf_Session_Vars.ex_error_found;
612: END IF;
613: IF C_Val_Custprice_Class%ISOPEN THEN
614: CLOSE C_Val_Custprice_Class;
615: END IF;

Line 647: RAISE Gmf_Session_Vars.ex_error_found;

643: ' ', ' ',pi_key_value);
644: IF C_Val_Taxloc_Code%ISOPEN THEN
645: CLOSE C_Val_Taxloc_Code;
646: END IF;
647: RAISE Gmf_Session_Vars.ex_error_found;
648: END IF;
649: IF C_Val_Taxloc_Code%ISOPEN THEN
650: CLOSE C_Val_Taxloc_Code;
651: END IF;

Line 683: RAISE Gmf_Session_Vars.ex_error_found;

679: ' ', ' ',pi_key_value);
680: IF C_Val_Taxcalc_Code%ISOPEN THEN
681: CLOSE C_Val_Taxcalc_Code;
682: END IF;
683: RAISE Gmf_Session_Vars.ex_error_found;
684: END IF;
685: IF C_Val_Taxcalc_Code%ISOPEN THEN
686: CLOSE C_Val_Taxcalc_Code;
687: END IF;

Line 719: RAISE Gmf_Session_Vars.ex_error_found;

715: ' ', ' ',pi_key_value);
716: IF C_Val_Whse_Code%ISOPEN THEN
717: CLOSE C_Val_Whse_Code;
718: END IF;
719: RAISE Gmf_Session_Vars.ex_error_found;
720: END IF;
721: IF C_Val_Whse_Code%ISOPEN THEN
722: CLOSE C_Val_Whse_Code;
723: END IF;