139: UPDATE_DATE ;
140:
141: commit;
142:
143: g_concurrent_id:=FND_GLOBAL.conc_request_id;
144: return true;
145: Exception when others then
146: g_status_message:=sqlerrm;
147: log('Exception in SETUP '||sqlerrm,0);
174: TYPE curtyp IS REF CURSOR;
175: cv curtyp;
176: BEGIN
177:
178: g_concurrent_id:=FND_GLOBAL.conc_program_id;
179: g_request_id:=FND_GLOBAL.conc_request_id;
180: g_user_id := fnd_global.user_id;
181: g_login_id := fnd_global.login_id;
182: if p_status then l_status:='SUCCESS';
175: cv curtyp;
176: BEGIN
177:
178: g_concurrent_id:=FND_GLOBAL.conc_program_id;
179: g_request_id:=FND_GLOBAL.conc_request_id;
180: g_user_id := fnd_global.user_id;
181: g_login_id := fnd_global.login_id;
182: if p_status then l_status:='SUCCESS';
183: else l_status:='FAILURE';
176: BEGIN
177:
178: g_concurrent_id:=FND_GLOBAL.conc_program_id;
179: g_request_id:=FND_GLOBAL.conc_request_id;
180: g_user_id := fnd_global.user_id;
181: g_login_id := fnd_global.login_id;
182: if p_status then l_status:='SUCCESS';
183: else l_status:='FAILURE';
184: end if;
177:
178: g_concurrent_id:=FND_GLOBAL.conc_program_id;
179: g_request_id:=FND_GLOBAL.conc_request_id;
180: g_user_id := fnd_global.user_id;
181: g_login_id := fnd_global.login_id;
182: if p_status then l_status:='SUCCESS';
183: else l_status:='FAILURE';
184: end if;
185: