DBA Data[Home] [Help]

APPS.GMF_SYNC_VENDOR dependencies on GMF_SESSION_VARS

Line 53: v_gl_log_trigger_cache:=gmf_session_vars.gl_log_trigger_error;

49: /*-----------------------------------------------------------------
50: -- Cache the value of GL_LOG_TRIGGER_EXCEPTION to reset it in end.
51: -----------------------------------------------------------------*/
52: Gmf_sync_init.Glsynch_Initialize;
53: v_gl_log_trigger_cache:=gmf_session_vars.gl_log_trigger_error;
54: gmf_session_vars.gl_log_trigger_error:=1;
55:
56: --Begin Bug 1677297 Mohit Kapoor
57: PRINT_LINE ('Starting concurrent program execution ' ||to_char(sysdate, 'dd-mon-yyyy hh24:mi:ss'));

Line 54: gmf_session_vars.gl_log_trigger_error:=1;

50: -- Cache the value of GL_LOG_TRIGGER_EXCEPTION to reset it in end.
51: -----------------------------------------------------------------*/
52: Gmf_sync_init.Glsynch_Initialize;
53: v_gl_log_trigger_cache:=gmf_session_vars.gl_log_trigger_error;
54: gmf_session_vars.gl_log_trigger_error:=1;
55:
56: --Begin Bug 1677297 Mohit Kapoor
57: PRINT_LINE ('Starting concurrent program execution ' ||to_char(sysdate, 'dd-mon-yyyy hh24:mi:ss'));
58: PRINT_LINE ('COMPANY : '||p_co_code);

Line 79: Gmf_Session_Vars.FOUND_ERRORS := 'N';

75:
76: open c_po_vendor_sites_all(v_org_id);
77: loop
78: --Begin Bug1677297 Mohit Kapoor
79: Gmf_Session_Vars.FOUND_ERRORS := 'N';
80:
81: -- Modified Fetch statement 1677297
82: fetch c_po_vendor_sites_all into v_last_update_date,v_vendor_id ,v_vendor_site_code ;
83: exit when c_po_vendor_sites_all%NOTFOUND;

Line 85: GMF_Session_Vars.GL$VEND_DELIMITER := nvl(FND_PROFILE.VALUE('GL$VEND_DELIMITER'),'-');

81: -- Modified Fetch statement 1677297
82: fetch c_po_vendor_sites_all into v_last_update_date,v_vendor_id ,v_vendor_site_code ;
83: exit when c_po_vendor_sites_all%NOTFOUND;
84:
85: GMF_Session_Vars.GL$VEND_DELIMITER := nvl(FND_PROFILE.VALUE('GL$VEND_DELIMITER'),'-');
86:
87: open c_po_vendors(v_vendor_id);
88: fetch c_po_vendors into v_segment1;
89: close c_po_vendors;

Line 91: PRINT (' '|| v_segment1 || GMF_Session_Vars.GL$VEND_DELIMITER || v_vendor_site_code );

87: open c_po_vendors(v_vendor_id);
88: fetch c_po_vendors into v_segment1;
89: close c_po_vendors;
90:
91: PRINT (' '|| v_segment1 || GMF_Session_Vars.GL$VEND_DELIMITER || v_vendor_site_code );
92: v_total_vendors:=v_total_vendors+1;
93: --End Bug 1677297
94:
95: /*---------------------------------------------------

Line 104: if Gmf_Session_Vars.FOUND_ERRORS = 'N' then

100: where current of c_po_vendor_sites_all;
101:
102: --Begin Bug1677297 Mohit Kapoor
103: -- Added code
104: if Gmf_Session_Vars.FOUND_ERRORS = 'N' then
105: PRINT_LINE ('- Processed - Success ! '||to_char(sysdate, 'dd-mon-yyyy hh24:mi:ss'));
106: v_total_vendors_synched := v_total_vendors_synched + 1;
107: elsif Gmf_Session_Vars.FOUND_ERRORS = 'Y' then
108: PRINT_LINE ('- Failed '||to_char(sysdate, 'dd-mon-yyyy hh24:mi:ss'));

Line 107: elsif Gmf_Session_Vars.FOUND_ERRORS = 'Y' then

103: -- Added code
104: if Gmf_Session_Vars.FOUND_ERRORS = 'N' then
105: PRINT_LINE ('- Processed - Success ! '||to_char(sysdate, 'dd-mon-yyyy hh24:mi:ss'));
106: v_total_vendors_synched := v_total_vendors_synched + 1;
107: elsif Gmf_Session_Vars.FOUND_ERRORS = 'Y' then
108: PRINT_LINE ('- Failed '||to_char(sysdate, 'dd-mon-yyyy hh24:mi:ss'));
109: v_total_vendors_failed := v_total_vendors_failed+1;
110: end if;
111: --End Bug 1677297

Line 125: gmf_session_vars.gl_log_trigger_error:=v_gl_log_trigger_cache;

121:
122: /*--------------------------------------------------------
123: -- Reset the Global pkg variable back to the cached value
124: --------------------------------------------------------*/
125: gmf_session_vars.gl_log_trigger_error:=v_gl_log_trigger_cache;
126: retcode:=0;
127: exception
128: when others then
129: fnd_message.set_name('GMF','GL_TRIGGER_ERROR');