DBA Data[Home] [Help]

APPS.JTF_RS_CONC_WF_PUB dependencies on WF_CORE

Line 40: wf_core.get_error(error_name, error_message, error_stack);

36: error_name VARCHAR2(30);
37: error_message VARCHAR2(2000);
38: error_stack VARCHAR2(32000);
39: BEGIN
40: wf_core.get_error(error_name, error_message, error_stack);
41: fnd_file.put_line (fnd_file.log,error_message);
42: fnd_file.new_line (fnd_file.log,1);
43: fnd_file.put_line (fnd_file.log,error_stack);
44: fnd_file.new_line (fnd_file.log,1);

Line 45: wf_core.clear;

41: fnd_file.put_line (fnd_file.log,error_message);
42: fnd_file.new_line (fnd_file.log,1);
43: fnd_file.put_line (fnd_file.log,error_stack);
44: fnd_file.new_line (fnd_file.log,1);
45: wf_core.clear;
46: END call_exception;
47:
48: PROCEDURE synchronize_teams_wf AS
49:

Line 155: wf_core.clear;

151: --fnd_file.put_line (fnd_file.log,'Beginning of Resource Workflow Synchronization for Resource Teams');
152: fnd_file.put_line (fnd_file.log,'-----------------------------------------------------------------');
153: fnd_file.new_line (fnd_file.log,1);
154:
155: wf_core.clear;
156:
157: -- Inactivate Workflow User Roles (Self and Member) for corresponding Inactive Resource Teams
158: FOR i IN c_team_wf_ur_del LOOP
159: BEGIN

Line 172: wf_core.get_error(error_name, error_message, error_stack);

168: p_overwrite => TRUE);
169:
170: EXCEPTION
171: WHEN OTHERS THEN
172: wf_core.get_error(error_name, error_message, error_stack);
173: fnd_file.put_line (fnd_file.log,error_message);
174: fnd_file.new_line (fnd_file.log,1);
175: fnd_file.put_line (fnd_file.log,error_stack);
176: fnd_file.new_line (fnd_file.log,1);

Line 177: wf_core.clear;

173: fnd_file.put_line (fnd_file.log,error_message);
174: fnd_file.new_line (fnd_file.log,1);
175: fnd_file.put_line (fnd_file.log,error_stack);
176: fnd_file.new_line (fnd_file.log,1);
177: wf_core.clear;
178: END;
179: END LOOP;
180:
181: fnd_file.put_line (fnd_file.log,log_message36);

Line 208: wf_core.get_error(error_name, error_message, error_stack);

204:
205: EXCEPTION
206: WHEN OTHERS THEN
207: l_list.DELETE;
208: wf_core.get_error(error_name, error_message, error_stack);
209: fnd_file.put_line (fnd_file.log,error_message);
210: fnd_file.new_line (fnd_file.log,1);
211: fnd_file.put_line (fnd_file.log,error_stack);
212: fnd_file.new_line (fnd_file.log,1);

Line 213: wf_core.clear;

209: fnd_file.put_line (fnd_file.log,error_message);
210: fnd_file.new_line (fnd_file.log,1);
211: fnd_file.put_line (fnd_file.log,error_stack);
212: fnd_file.new_line (fnd_file.log,1);
213: wf_core.clear;
214: END;
215: END LOOP;
216:
217: fnd_file.put_line (fnd_file.log,log_message12);

Line 247: wf_core.get_error(error_name, error_message, error_stack);

243:
244: EXCEPTION
245: WHEN OTHERS THEN
246: l_list.DELETE;
247: wf_core.get_error(error_name, error_message, error_stack);
248: fnd_file.put_line (fnd_file.log,error_message);
249: fnd_file.new_line (fnd_file.log,1);
250: fnd_file.put_line (fnd_file.log,error_stack);
251: fnd_file.new_line (fnd_file.log,1);

Line 252: wf_core.clear;

248: fnd_file.put_line (fnd_file.log,error_message);
249: fnd_file.new_line (fnd_file.log,1);
250: fnd_file.put_line (fnd_file.log,error_stack);
251: fnd_file.new_line (fnd_file.log,1);
252: wf_core.clear;
253: END;
254:
255: IF (i.wlr_start_date IS NULL OR
256: i.start_date_active <> i.wlr_start_date OR

Line 274: wf_core.get_error(error_name, error_message, error_stack);

270: p_overwrite => TRUE);
271:
272: EXCEPTION
273: WHEN OTHERS THEN
274: wf_core.get_error(error_name, error_message, error_stack);
275: fnd_file.put_line (fnd_file.log,error_message);
276: fnd_file.new_line (fnd_file.log,1);
277: fnd_file.put_line (fnd_file.log,error_stack);
278: fnd_file.new_line (fnd_file.log,1);

Line 279: wf_core.clear;

275: fnd_file.put_line (fnd_file.log,error_message);
276: fnd_file.new_line (fnd_file.log,1);
277: fnd_file.put_line (fnd_file.log,error_stack);
278: fnd_file.new_line (fnd_file.log,1);
279: wf_core.clear;
280: END;
281: END IF;
282:
283: END LOOP;

Line 305: wf_core.get_error(error_name, error_message, error_stack);

301: p_overwrite => TRUE);
302:
303: EXCEPTION
304: WHEN OTHERS THEN
305: wf_core.get_error(error_name, error_message, error_stack);
306: fnd_file.put_line (fnd_file.log,error_message);
307: fnd_file.new_line (fnd_file.log,1);
308: fnd_file.put_line (fnd_file.log,error_stack);
309: fnd_file.new_line (fnd_file.log,1);

Line 310: wf_core.clear;

306: fnd_file.put_line (fnd_file.log,error_message);
307: fnd_file.new_line (fnd_file.log,1);
308: fnd_file.put_line (fnd_file.log,error_stack);
309: fnd_file.new_line (fnd_file.log,1);
310: wf_core.clear;
311: END;
312: END LOOP;
313:
314: fnd_file.put_line (fnd_file.log,log_message37);

Line 340: wf_core.get_error(error_name, error_message, error_stack);

336:
337: EXCEPTION
338: WHEN OTHERS THEN
339: l_list.DELETE;
340: wf_core.get_error(error_name, error_message, error_stack);
341: fnd_file.put_line (fnd_file.log,error_message);
342: fnd_file.new_line (fnd_file.log,1);
343: fnd_file.put_line (fnd_file.log,error_stack);
344: fnd_file.new_line (fnd_file.log,1);

Line 345: wf_core.clear;

341: fnd_file.put_line (fnd_file.log,error_message);
342: fnd_file.new_line (fnd_file.log,1);
343: fnd_file.put_line (fnd_file.log,error_stack);
344: fnd_file.new_line (fnd_file.log,1);
345: wf_core.clear;
346: END;
347:
348: -- Create Self-Record in wf_local_user_roles for the above record
349: BEGIN

Line 361: wf_core.get_error(error_name, error_message, error_stack);

357: p_expiration_date => i.end_date_active);
358:
359: EXCEPTION
360: WHEN OTHERS THEN
361: wf_core.get_error(error_name, error_message, error_stack);
362: fnd_file.put_line (fnd_file.log,error_message);
363: fnd_file.new_line (fnd_file.log,1);
364: fnd_file.put_line (fnd_file.log,error_stack);
365: fnd_file.new_line (fnd_file.log,1);

Line 366: wf_core.clear;

362: fnd_file.put_line (fnd_file.log,error_message);
363: fnd_file.new_line (fnd_file.log,1);
364: fnd_file.put_line (fnd_file.log,error_stack);
365: fnd_file.new_line (fnd_file.log,1);
366: wf_core.clear;
367: END;
368: END LOOP;
369:
370: fnd_file.put_line (fnd_file.log,log_message14);

Line 377: wf_core.get_error(error_name, error_message, error_stack);

373: fnd_file.new_line (fnd_file.log,1);
374:
375: EXCEPTION
376: WHEN OTHERS THEN
377: wf_core.get_error(error_name, error_message, error_stack);
378: fnd_file.put_line (fnd_file.log,error_message);
379: fnd_file.new_line (fnd_file.log,1);
380: fnd_file.put_line (fnd_file.log,error_stack);
381: fnd_file.new_line (fnd_file.log,1);

Line 382: wf_core.clear;

378: fnd_file.put_line (fnd_file.log,error_message);
379: fnd_file.new_line (fnd_file.log,1);
380: fnd_file.put_line (fnd_file.log,error_stack);
381: fnd_file.new_line (fnd_file.log,1);
382: wf_core.clear;
383:
384: END synchronize_teams_wf;
385:
386:

Line 508: wf_core.clear;

504: --fnd_file.put_line (fnd_file.log,'Beginning of Resource Workflow Synchronization for Resource Groups');
505: fnd_file.put_line (fnd_file.log,'------------------------------------------------------------------');
506: fnd_file.new_line (fnd_file.log,1);
507:
508: wf_core.clear;
509:
510: -- Inactivate Workflow User Roles (Self-Records) for corresponding Inactive Resource Groups
511: FOR i IN c_grp_wf_ur_del LOOP
512: BEGIN

Line 525: wf_core.get_error(error_name, error_message, error_stack);

521: p_overwrite => TRUE);
522:
523: EXCEPTION
524: WHEN OTHERS THEN
525: wf_core.get_error(error_name, error_message, error_stack);
526: fnd_file.put_line (fnd_file.log,error_message);
527: fnd_file.new_line (fnd_file.log,1);
528: fnd_file.put_line (fnd_file.log,error_stack);
529: fnd_file.new_line (fnd_file.log,1);

Line 530: wf_core.clear;

526: fnd_file.put_line (fnd_file.log,error_message);
527: fnd_file.new_line (fnd_file.log,1);
528: fnd_file.put_line (fnd_file.log,error_stack);
529: fnd_file.new_line (fnd_file.log,1);
530: wf_core.clear;
531: END;
532: END LOOP;
533:
534: fnd_file.put_line (fnd_file.log,log_message38);

Line 561: wf_core.get_error(error_name, error_message, error_stack);

557:
558: EXCEPTION
559: WHEN OTHERS THEN
560: l_list.DELETE;
561: wf_core.get_error(error_name, error_message, error_stack);
562: fnd_file.put_line (fnd_file.log,error_message);
563: fnd_file.new_line (fnd_file.log,1);
564: fnd_file.put_line (fnd_file.log,error_stack);
565: fnd_file.new_line (fnd_file.log,1);

Line 566: wf_core.clear;

562: fnd_file.put_line (fnd_file.log,error_message);
563: fnd_file.new_line (fnd_file.log,1);
564: fnd_file.put_line (fnd_file.log,error_stack);
565: fnd_file.new_line (fnd_file.log,1);
566: wf_core.clear;
567: END;
568: END LOOP;
569:
570: fnd_file.put_line (fnd_file.log,log_message1);

Line 600: wf_core.get_error(error_name, error_message, error_stack);

596:
597: EXCEPTION
598: WHEN OTHERS THEN
599: l_list.DELETE;
600: wf_core.get_error(error_name, error_message, error_stack);
601: fnd_file.put_line (fnd_file.log,error_message);
602: fnd_file.new_line (fnd_file.log,1);
603: fnd_file.put_line (fnd_file.log,error_stack);
604: fnd_file.new_line (fnd_file.log,1);

Line 605: wf_core.clear;

601: fnd_file.put_line (fnd_file.log,error_message);
602: fnd_file.new_line (fnd_file.log,1);
603: fnd_file.put_line (fnd_file.log,error_stack);
604: fnd_file.new_line (fnd_file.log,1);
605: wf_core.clear;
606: END;
607:
608: IF (i.wlr_start_date IS NULL OR
609: i.start_date_active <> i.wlr_start_date OR

Line 627: wf_core.get_error(error_name, error_message, error_stack);

623: p_overwrite => TRUE);
624:
625: EXCEPTION
626: WHEN OTHERS THEN
627: wf_core.get_error(error_name, error_message, error_stack);
628: fnd_file.put_line (fnd_file.log,error_message);
629: fnd_file.new_line (fnd_file.log,1);
630: fnd_file.put_line (fnd_file.log,error_stack);
631: fnd_file.new_line (fnd_file.log,1);

Line 632: wf_core.clear;

628: fnd_file.put_line (fnd_file.log,error_message);
629: fnd_file.new_line (fnd_file.log,1);
630: fnd_file.put_line (fnd_file.log,error_stack);
631: fnd_file.new_line (fnd_file.log,1);
632: wf_core.clear;
633: END;
634: END IF;
635:
636: END LOOP;

Line 658: wf_core.get_error(error_name, error_message, error_stack);

654: p_overwrite => TRUE);
655:
656: EXCEPTION
657: WHEN OTHERS THEN
658: wf_core.get_error(error_name, error_message, error_stack);
659: fnd_file.put_line (fnd_file.log,error_message);
660: fnd_file.new_line (fnd_file.log,1);
661: fnd_file.put_line (fnd_file.log,error_stack);
662: fnd_file.new_line (fnd_file.log,1);

Line 663: wf_core.clear;

659: fnd_file.put_line (fnd_file.log,error_message);
660: fnd_file.new_line (fnd_file.log,1);
661: fnd_file.put_line (fnd_file.log,error_stack);
662: fnd_file.new_line (fnd_file.log,1);
663: wf_core.clear;
664: END;
665: END LOOP;
666:
667: fnd_file.put_line (fnd_file.log,log_message39);

Line 692: wf_core.get_error(error_name, error_message, error_stack);

688:
689: EXCEPTION
690: WHEN OTHERS THEN
691: l_list.DELETE;
692: wf_core.get_error(error_name, error_message, error_stack);
693: fnd_file.put_line (fnd_file.log,error_message);
694: fnd_file.new_line (fnd_file.log,1);
695: fnd_file.put_line (fnd_file.log,error_stack);
696: fnd_file.new_line (fnd_file.log,1);

Line 697: wf_core.clear;

693: fnd_file.put_line (fnd_file.log,error_message);
694: fnd_file.new_line (fnd_file.log,1);
695: fnd_file.put_line (fnd_file.log,error_stack);
696: fnd_file.new_line (fnd_file.log,1);
697: wf_core.clear;
698: END;
699:
700: -- Create Self-Record in wf_local_user_roles for the above record
701: BEGIN

Line 712: wf_core.get_error(error_name, error_message, error_stack);

708: p_start_date => i.start_date_active,
709: p_expiration_date => i.end_date_active);
710: EXCEPTION
711: WHEN OTHERS THEN
712: wf_core.get_error(error_name, error_message, error_stack);
713: fnd_file.put_line (fnd_file.log,error_message);
714: fnd_file.new_line (fnd_file.log,1);
715: fnd_file.put_line (fnd_file.log,error_stack);
716: fnd_file.new_line (fnd_file.log,1);

Line 717: wf_core.clear;

713: fnd_file.put_line (fnd_file.log,error_message);
714: fnd_file.new_line (fnd_file.log,1);
715: fnd_file.put_line (fnd_file.log,error_stack);
716: fnd_file.new_line (fnd_file.log,1);
717: wf_core.clear;
718: END;
719: END LOOP;
720:
721: fnd_file.put_line (fnd_file.log,log_message3);

Line 728: wf_core.get_error(error_name, error_message, error_stack);

724: fnd_file.new_line (fnd_file.log,1);
725:
726: EXCEPTION
727: WHEN OTHERS THEN
728: wf_core.get_error(error_name, error_message, error_stack);
729: fnd_file.put_line (fnd_file.log,error_message);
730: fnd_file.new_line (fnd_file.log,1);
731: fnd_file.put_line (fnd_file.log,error_stack);
732: fnd_file.new_line (fnd_file.log,1);

Line 733: wf_core.clear;

729: fnd_file.put_line (fnd_file.log,error_message);
730: fnd_file.new_line (fnd_file.log,1);
731: fnd_file.put_line (fnd_file.log,error_stack);
732: fnd_file.new_line (fnd_file.log,1);
733: wf_core.clear;
734:
735: END synchronize_groups_wf;
736:
737:

Line 814: wf_core.get_error(error_name, error_message, error_stack);

810: p_expiration_date => l_sysdate-1,
811: p_overwrite => TRUE);
812: EXCEPTION
813: WHEN OTHERS THEN
814: wf_core.get_error(error_name, error_message, error_stack);
815: fnd_file.put_line (fnd_file.log,error_message);
816: fnd_file.new_line (fnd_file.log,1);
817: fnd_file.put_line (fnd_file.log,error_stack);
818: fnd_file.new_line (fnd_file.log,1);

Line 819: wf_core.clear;

815: fnd_file.put_line (fnd_file.log,error_message);
816: fnd_file.new_line (fnd_file.log,1);
817: fnd_file.put_line (fnd_file.log,error_stack);
818: fnd_file.new_line (fnd_file.log,1);
819: wf_core.clear;
820: END;
821: END LOOP;
822: -- Get all wf roles still defined as JRES_IND and Active.
823: FOR n in c_wf_role_details (i.resource_id, l_ind_orig_system, l_ind_user_name) LOOP

Line 844: wf_core.get_error(error_name, error_message, error_stack);

840: l_list.DELETE;
841: EXCEPTION
842: WHEN OTHERS THEN
843: l_list.DELETE;
844: wf_core.get_error(error_name, error_message, error_stack);
845: fnd_file.put_line (fnd_file.log,error_message);
846: fnd_file.new_line (fnd_file.log,1);
847: fnd_file.put_line (fnd_file.log,error_stack);
848: fnd_file.new_line (fnd_file.log,1);

Line 849: wf_core.clear;

845: fnd_file.put_line (fnd_file.log,error_message);
846: fnd_file.new_line (fnd_file.log,1);
847: fnd_file.put_line (fnd_file.log,error_stack);
848: fnd_file.new_line (fnd_file.log,1);
849: wf_core.clear;
850: END;
851: END IF;
852: END LOOP;
853: -- Check if the Resources of category OTHER and TBH are inactive

Line 870: wf_core.get_error(error_name, error_message, error_stack);

866: p_overwrite => TRUE);
867:
868: EXCEPTION
869: WHEN OTHERS THEN
870: wf_core.get_error(error_name, error_message, error_stack);
871: fnd_file.put_line (fnd_file.log,error_message);
872: fnd_file.new_line (fnd_file.log,1);
873: fnd_file.put_line (fnd_file.log,error_stack);
874: fnd_file.new_line (fnd_file.log,1);

Line 875: wf_core.clear;

871: fnd_file.put_line (fnd_file.log,error_message);
872: fnd_file.new_line (fnd_file.log,1);
873: fnd_file.put_line (fnd_file.log,error_stack);
874: fnd_file.new_line (fnd_file.log,1);
875: wf_core.clear;
876: END;
877: END LOOP;
878: -- Inactivate corresponding wf roles with resource dates
879: FOR p in c_wf_role_details (i.resource_id, l_ind_orig_system , l_ind_user_name) LOOP

Line 899: wf_core.get_error(error_name, error_message, error_stack);

895: l_list.DELETE;
896: EXCEPTION
897: WHEN OTHERS THEN
898: l_list.DELETE;
899: wf_core.get_error(error_name, error_message, error_stack);
900: fnd_file.put_line (fnd_file.log,error_message);
901: fnd_file.new_line (fnd_file.log,1);
902: fnd_file.put_line (fnd_file.log,error_stack);
903: fnd_file.new_line (fnd_file.log,1);

Line 904: wf_core.clear;

900: fnd_file.put_line (fnd_file.log,error_message);
901: fnd_file.new_line (fnd_file.log,1);
902: fnd_file.put_line (fnd_file.log,error_stack);
903: fnd_file.new_line (fnd_file.log,1);
904: wf_core.clear;
905: END;
906: END IF;
907: END LOOP;
908: END IF;

Line 950: wf_core.get_error(error_name, error_message, error_stack);

946: p_expiration_date => l_end_date,
947: p_overwrite => TRUE);
948: EXCEPTION
949: WHEN OTHERS THEN
950: wf_core.get_error(error_name, error_message, error_stack);
951: fnd_file.put_line (fnd_file.log,error_message);
952: fnd_file.new_line (fnd_file.log,1);
953: fnd_file.put_line (fnd_file.log,error_stack);
954: fnd_file.new_line (fnd_file.log,1);

Line 955: wf_core.clear;

951: fnd_file.put_line (fnd_file.log,error_message);
952: fnd_file.new_line (fnd_file.log,1);
953: fnd_file.put_line (fnd_file.log,error_stack);
954: fnd_file.new_line (fnd_file.log,1);
955: wf_core.clear;
956: END;
957: END IF;
958: END IF;
959: END LOOP;

Line 999: wf_core.get_error(error_name, error_message, error_stack);

995: IF c_wf_role_details%ISOPEN THEN
996: CLOSE c_wf_role_details;
997: END IF;
998: l_list.DELETE;
999: wf_core.get_error(error_name, error_message, error_stack);
1000: fnd_file.put_line (fnd_file.log,error_message);
1001: fnd_file.new_line (fnd_file.log,1);
1002: fnd_file.put_line (fnd_file.log,error_stack);
1003: fnd_file.new_line (fnd_file.log,1);

Line 1004: wf_core.clear;

1000: fnd_file.put_line (fnd_file.log,error_message);
1001: fnd_file.new_line (fnd_file.log,1);
1002: fnd_file.put_line (fnd_file.log,error_stack);
1003: fnd_file.new_line (fnd_file.log,1);
1004: wf_core.clear;
1005: END;
1006: END IF;
1007: END IF;
1008: ELSE

Line 1027: wf_core.get_error(error_name, error_message, error_stack);

1023: l_list.DELETE;
1024: EXCEPTION
1025: WHEN OTHERS THEN
1026: l_list.DELETE;
1027: wf_core.get_error(error_name, error_message, error_stack);
1028: fnd_file.put_line (fnd_file.log,error_message);
1029: fnd_file.new_line (fnd_file.log,1);
1030: fnd_file.put_line (fnd_file.log,error_stack);
1031: fnd_file.new_line (fnd_file.log,1);

Line 1032: wf_core.clear;

1028: fnd_file.put_line (fnd_file.log,error_message);
1029: fnd_file.new_line (fnd_file.log,1);
1030: fnd_file.put_line (fnd_file.log,error_stack);
1031: fnd_file.new_line (fnd_file.log,1);
1032: wf_core.clear;
1033: END;
1034: -- Create Self-Record in wf_local_user_roles for the above record
1035: BEGIN
1036: Wf_local_synch.propagate_user_role(

Line 1046: wf_core.get_error(error_name, error_message, error_stack);

1042: p_start_date => i.start_date_active,
1043: p_expiration_date => i.end_date_active);
1044: EXCEPTION
1045: WHEN OTHERS THEN
1046: wf_core.get_error(error_name, error_message, error_stack);
1047: fnd_file.put_line (fnd_file.log,error_message);
1048: fnd_file.new_line (fnd_file.log,1);
1049: fnd_file.put_line (fnd_file.log,error_stack);
1050: fnd_file.new_line (fnd_file.log,1);

Line 1051: wf_core.clear;

1047: fnd_file.put_line (fnd_file.log,error_message);
1048: fnd_file.new_line (fnd_file.log,1);
1049: fnd_file.put_line (fnd_file.log,error_stack);
1050: fnd_file.new_line (fnd_file.log,1);
1051: wf_core.clear;
1052: END;
1053: END IF;
1054: END IF;
1055: CLOSE c_wf_role_details;

Line 1195: wf_core.get_error(error_name, error_message, error_stack);

1191: p_expiration_date => sysdate-1,
1192: p_overwrite => TRUE);
1193: EXCEPTION
1194: WHEN OTHERS THEN
1195: wf_core.get_error(error_name, error_message, error_stack);
1196: fnd_file.put_line (fnd_file.log,error_message);
1197: fnd_file.new_line (fnd_file.log,1);
1198: fnd_file.put_line (fnd_file.log,error_stack);
1199: fnd_file.new_line (fnd_file.log,1);

Line 1200: wf_core.clear;

1196: fnd_file.put_line (fnd_file.log,error_message);
1197: fnd_file.new_line (fnd_file.log,1);
1198: fnd_file.put_line (fnd_file.log,error_stack);
1199: fnd_file.new_line (fnd_file.log,1);
1200: wf_core.clear;
1201: END;
1202: END LOOP;
1203:
1204: fnd_file.put_line (fnd_file.log,log_message8);

Line 1229: wf_core.get_error(error_name, error_message, error_stack);

1225: p_start_date => i.m_start_date_active,
1226: p_expiration_date => l_end_date_active);
1227: EXCEPTION
1228: WHEN OTHERS THEN
1229: wf_core.get_error(error_name, error_message, error_stack);
1230: fnd_file.put_line (fnd_file.log,error_message);
1231: fnd_file.new_line (fnd_file.log,1);
1232: fnd_file.put_line (fnd_file.log,error_stack);
1233: fnd_file.new_line (fnd_file.log,1);

Line 1234: wf_core.clear;

1230: fnd_file.put_line (fnd_file.log,error_message);
1231: fnd_file.new_line (fnd_file.log,1);
1232: fnd_file.put_line (fnd_file.log,error_stack);
1233: fnd_file.new_line (fnd_file.log,1);
1234: wf_core.clear;
1235: END;
1236: END LOOP;
1237:
1238: fnd_file.put_line (fnd_file.log,log_message30);

Line 1274: wf_core.get_error(error_name, error_message, error_stack);

1270: p_start_date => i.m_start_date_active,
1271: p_expiration_date => l_end_date_active);
1272: EXCEPTION
1273: WHEN OTHERS THEN
1274: wf_core.get_error(error_name, error_message, error_stack);
1275: fnd_file.put_line (fnd_file.log,error_message);
1276: fnd_file.new_line (fnd_file.log,1);
1277: fnd_file.put_line (fnd_file.log,error_stack);
1278: fnd_file.new_line (fnd_file.log,1);

Line 1279: wf_core.clear;

1275: fnd_file.put_line (fnd_file.log,error_message);
1276: fnd_file.new_line (fnd_file.log,1);
1277: fnd_file.put_line (fnd_file.log,error_stack);
1278: fnd_file.new_line (fnd_file.log,1);
1279: wf_core.clear;
1280: END;
1281: END IF;
1282: END LOOP;
1283:

Line 1292: wf_core.get_error(error_name, error_message, error_stack);

1288:
1289:
1290: EXCEPTION
1291: WHEN OTHERS THEN
1292: wf_core.get_error(error_name, error_message, error_stack);
1293: fnd_file.put_line (fnd_file.log,error_message);
1294: fnd_file.new_line (fnd_file.log,1);
1295: fnd_file.put_line (fnd_file.log,error_stack);
1296: fnd_file.new_line (fnd_file.log,1);

Line 1297: wf_core.clear;

1293: fnd_file.put_line (fnd_file.log,error_message);
1294: fnd_file.new_line (fnd_file.log,1);
1295: fnd_file.put_line (fnd_file.log,error_stack);
1296: fnd_file.new_line (fnd_file.log,1);
1297: wf_core.clear;
1298:
1299: END synchronize_group_members_wf;
1300:
1301:

Line 1459: wf_core.get_error(error_name, error_message, error_stack);

1455: p_expiration_date => sysdate-1,
1456: p_overwrite => TRUE);
1457: EXCEPTION
1458: WHEN OTHERS THEN
1459: wf_core.get_error(error_name, error_message, error_stack);
1460: fnd_file.put_line (fnd_file.log,error_message);
1461: fnd_file.new_line (fnd_file.log,1);
1462: fnd_file.put_line (fnd_file.log,error_stack);
1463: fnd_file.new_line (fnd_file.log,1);

Line 1464: wf_core.clear;

1460: fnd_file.put_line (fnd_file.log,error_message);
1461: fnd_file.new_line (fnd_file.log,1);
1462: fnd_file.put_line (fnd_file.log,error_stack);
1463: fnd_file.new_line (fnd_file.log,1);
1464: wf_core.clear;
1465: END;
1466: END LOOP;
1467:
1468: fnd_file.put_line (fnd_file.log,log_message32);

Line 1493: wf_core.get_error(error_name, error_message, error_stack);

1489: p_start_date => i.m_start_date_active,
1490: p_expiration_date => l_end_date_active);
1491: EXCEPTION
1492: WHEN OTHERS THEN
1493: wf_core.get_error(error_name, error_message, error_stack);
1494: fnd_file.put_line (fnd_file.log,error_message);
1495: fnd_file.new_line (fnd_file.log,1);
1496: fnd_file.put_line (fnd_file.log,error_stack);
1497: fnd_file.new_line (fnd_file.log,1);

Line 1498: wf_core.clear;

1494: fnd_file.put_line (fnd_file.log,error_message);
1495: fnd_file.new_line (fnd_file.log,1);
1496: fnd_file.put_line (fnd_file.log,error_stack);
1497: fnd_file.new_line (fnd_file.log,1);
1498: wf_core.clear;
1499: END;
1500: END LOOP;
1501:
1502: fnd_file.put_line (fnd_file.log,log_message33);

Line 1538: wf_core.get_error(error_name, error_message, error_stack);

1534: p_start_date => i.m_start_date_active,
1535: p_expiration_date => l_end_date_active);
1536: EXCEPTION
1537: WHEN OTHERS THEN
1538: wf_core.get_error(error_name, error_message, error_stack);
1539: fnd_file.put_line (fnd_file.log,error_message);
1540: fnd_file.new_line (fnd_file.log,1);
1541: fnd_file.put_line (fnd_file.log,error_stack);
1542: fnd_file.new_line (fnd_file.log,1);

Line 1543: wf_core.clear;

1539: fnd_file.put_line (fnd_file.log,error_message);
1540: fnd_file.new_line (fnd_file.log,1);
1541: fnd_file.put_line (fnd_file.log,error_stack);
1542: fnd_file.new_line (fnd_file.log,1);
1543: wf_core.clear;
1544: END;
1545: END IF;
1546: END LOOP;
1547:

Line 1572: wf_core.get_error(error_name, error_message, error_stack);

1568: p_start_date => i.m_start_date_active,
1569: p_expiration_date => l_end_date_active);
1570: EXCEPTION
1571: WHEN OTHERS THEN
1572: wf_core.get_error(error_name, error_message, error_stack);
1573: fnd_file.put_line (fnd_file.log,error_message);
1574: fnd_file.new_line (fnd_file.log,1);
1575: fnd_file.put_line (fnd_file.log,error_stack);
1576: fnd_file.new_line (fnd_file.log,1);

Line 1577: wf_core.clear;

1573: fnd_file.put_line (fnd_file.log,error_message);
1574: fnd_file.new_line (fnd_file.log,1);
1575: fnd_file.put_line (fnd_file.log,error_stack);
1576: fnd_file.new_line (fnd_file.log,1);
1577: wf_core.clear;
1578: END;
1579: END LOOP;
1580:
1581: fnd_file.put_line (fnd_file.log,log_message35);

Line 1588: wf_core.get_error(error_name, error_message, error_stack);

1584: fnd_file.new_line (fnd_file.log,1);
1585:
1586: EXCEPTION
1587: WHEN OTHERS THEN
1588: wf_core.get_error(error_name, error_message, error_stack);
1589: fnd_file.put_line (fnd_file.log,error_message);
1590: fnd_file.new_line (fnd_file.log,1);
1591: fnd_file.put_line (fnd_file.log,error_stack);
1592: fnd_file.new_line (fnd_file.log,1);

Line 1593: wf_core.clear;

1589: fnd_file.put_line (fnd_file.log,error_message);
1590: fnd_file.new_line (fnd_file.log,1);
1591: fnd_file.put_line (fnd_file.log,error_stack);
1592: fnd_file.new_line (fnd_file.log,1);
1593: wf_core.clear;
1594:
1595: END synchronize_team_members_wf;
1596:
1597: BEGIN