[Home] [Help]
1: PACKAGE BODY asg_helper AS
2: /*$Header: asghlpb.pls 120.7 2008/05/16 09:54:37 saradhak ship $*/
3:
4: -- DESCRIPTION
5: -- This package is used for miscellaneous chores
140: END IF;
141: IF(check_is_log_enabled(g_stmt_level))
142: THEN
143: log('Calling populate_access_records for user: ' || p_user_name ||
144: ' and publication: ' || p_pub_name,'asg_helper',g_stmt_level);
145: END IF;
146:
147: OPEN c_wrapper_name(p_pub_name);
148: FETCH c_wrapper_name into l_wrapper_name;
150: IF l_wrapper_name IS NULL THEN
151: IF(check_is_log_enabled(g_err_level))
152: THEN
153: log('Wrapper for publication: ' || p_pub_name || ' is null',
154: 'asg_helper',g_err_level);
155: END IF;
156: RAISE_APPLICATION_ERROR(-20989, 'Callback package missing for ' ||
157: 'publication: ' || p_pub_name);
158: END IF;
163: '.populate_access_records( :1 ); END;';
164: IF(check_is_log_enabled(g_stmt_level))
165: THEN
166: log('Callback SQLCommand: ' || l_callback_string,
167: 'asg_helper',g_stmt_level);
168: END IF;
169: EXECUTE IMMEDIATE l_callback_string
170: USING l_user_id;
171: EXCEPTION
172: WHEN OTHERS THEN
173: IF(check_is_log_enabled(g_err_level))
174: THEN
175: log('Exception in call to populate access records: ' ||
176: SQLERRM, 'asg_helper',g_err_level);
177: END IF;
178: RAISE;
179: END;
180:
211: END IF;
212: IF(check_is_log_enabled(g_stmt_level))
213: THEN
214: log('Calling delete_access_records for user: ' || p_user_name ||
215: ' and publication: ' || p_pub_name,'asg_helper',g_stmt_level);
216: END IF;
217: OPEN c_wrapper_name(p_pub_name);
218: FETCH c_wrapper_name into l_wrapper_name;
219: CLOSE c_wrapper_name;
220: IF l_wrapper_name IS NULL THEN
221: IF(check_is_log_enabled(g_err_level))
222: THEN
223: log('Wrapper for publication: ' || p_pub_name || ' is null',
224: 'asg_helper',g_err_level);
225: END IF;
226: RAISE_APPLICATION_ERROR(-20989, 'Callback package missing for ' ||
227: 'publication: ' || p_pub_name);
228: END IF;
233: '.delete_access_records(:2); END;';
234: IF(check_is_log_enabled(g_stmt_level))
235: THEN
236: log('Callback SQLCommand: ' || l_callback_string,
237: 'asg_helper',g_stmt_level);
238: END IF;
239: EXECUTE IMMEDIATE l_callback_string
240: USING l_user_id;
241: EXCEPTION
242: WHEN OTHERS THEN
243: IF(check_is_log_enabled(g_err_level))
244: THEN
245: log('Exception in call to delete access records: ' ||
246: SQLERRM, 'asg_helper',g_err_level);
247: END IF;
248: RAISE;
249: END;
250:
285: THEN
286: log('Created Sequence Partition for user: ' || p_user_name ||
287: ' and sequence: ' || p_seq_name || ' with start value: ' ||
288: p_start_value || ' and next value: ' || p_next_value,
289: 'asg_helper',g_stmt_level);
290: END IF;
291:
292: END create_seq_partition;
293:
303: COMMIT;
304: IF(check_is_log_enabled(g_stmt_level))
305: THEN
306: log('Dropped Sequence Partition for user: ' || p_user_name ||
307: ' and sequence: ' || p_seq_name,'asg_helper',g_stmt_level);
308: END IF;
309: END drop_seq_partition;
310:
311: -- insert pub responsibilities
345: IF(check_is_log_enabled(g_stmt_level))
346: THEN
347: log('Created user pub responsibility record for user: ' || p_user_name ||
348: ' and publication: ' || p_pub_name || ' and responsibility id: ' ||
349: p_resp_id || ' and app id: ' || p_app_id,'asg_helper',g_stmt_level);
350: END IF;
351:
352: END insert_user_pub_resp;
353:
374: COMMIT;
375: IF(check_is_log_enabled(g_stmt_level))
376: THEN
377: log('Deleted user pub record for user: ' || p_user_name ||
378: ' and publication: ' || p_pub_name,'asg_helper',g_stmt_level);
379: END IF;
380: END delete_user_pub;
381:
382:
396: IF(check_is_log_enabled(g_stmt_level))
397: THEN
398: log('Deleted user pub responsibility record for user: ' || p_user_name ||
399: ' and publication: ' || p_pub_name || ' and responsibility id: ' ||
400: p_resp_id,'asg_helper',g_stmt_level);
401: END IF;
402: END delete_user_pub_resp;
403:
404: -- wrapper on fnd_log
489: WHEN OTHERS THEN
490: IF(check_is_log_enabled(g_err_level))
491: THEN
492: log('Exception in purgesdq during drop_user: ' || l_user_name,
493: 'asg_helper',g_err_level);
494: END IF;
495: END;
496:
497: --delete from asg_purge_sdq and asg_complete_refresh
511: COMMIT;
512: IF(check_is_log_enabled(g_stmt_level))
513: THEN
514: log('Done cleaning up user meta data during drop user: ' || p_user_name,
515: 'asg_helper',g_stmt_level);
516: END IF;
517: EXCEPTION
518: WHEN OTHERS THEN
519: IF(check_is_log_enabled(g_err_level))
518: WHEN OTHERS THEN
519: IF(check_is_log_enabled(g_err_level))
520: THEN
521: log('Exception in drop_user ' || SQLERRM,
522: 'asg_helper',g_err_level);
523: END IF;
524: RAISE;
525: END drop_user;
526:
622: enabled = 'N';
623:
624: IF l_disabled_user > 0 THEN
625: l_synch_enabled := FND_API.G_FALSE;
626: p_disabled_synch_message := asg_helper.get_param_value(
627: 'DISABLED_SYNCH_MESSAGE_UC');
628: return l_synch_enabled;
629: END IF;
630:
645: USING p_user_name;
646:
647: IF (l_disabled_pubs >0) THEN
648: l_synch_enabled := FND_API.G_FALSE;
649: p_disabled_synch_message := asg_helper.get_param_value(
650: 'DISABLED_SYNCH_MESSAGE_ACC');
651: return l_synch_enabled;
652: END IF;
653:
670: USING p_user_name;
671:
672: IF (l_disabled_pubs >0) THEN
673: l_synch_enabled := FND_API.G_FALSE;
674: p_disabled_synch_message := asg_helper.get_param_value(
675: 'DISABLED_SYNCH_MESSAGE_PATCH');
676: END IF;
677:
678: return l_synch_enabled;
984: OPEN get_pub(p_device_type);
985: LOOP
986: FETCH get_pub INTO l_pub_name;
987: EXIT WHEN get_pub%NOTFOUND;
988: log('Setting synch time for pub_name: '||l_pub_name,'asg_helper',g_stmt_level);
989: UPDATE asg_user_pub_resps
990: SET synch_date = sysdate
991: WHERE user_name = p_user_name
992: AND pub_name = l_pub_name;
1460: END enable_olite_privs;
1461:
1462:
1463:
1464: END asg_helper;