DBA Data[Home] [Help]

APPS.JTF_RS_CONC_WF_PUB dependencies on WF_CORE

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

92: error_name VARCHAR2(30);
93: error_message VARCHAR2(2000);
94: error_stack VARCHAR2(32000);
95: BEGIN
96: wf_core.get_error(error_name, error_message, error_stack);
97: fnd_file.put_line (fnd_file.log,error_message);
98: fnd_file.new_line (fnd_file.log,1);
99: fnd_file.put_line (fnd_file.log,error_stack);
100: fnd_file.new_line (fnd_file.log,1);

Line 101: wf_core.clear;

97: fnd_file.put_line (fnd_file.log,error_message);
98: fnd_file.new_line (fnd_file.log,1);
99: fnd_file.put_line (fnd_file.log,error_stack);
100: fnd_file.new_line (fnd_file.log,1);
101: wf_core.clear;
102: END call_exception;
103:
104: PROCEDURE synchronize_teams_wf AS
105:

Line 211: wf_core.clear;

207: --fnd_file.put_line (fnd_file.log,'Beginning of Resource Workflow Synchronization for Resource Teams');
208: fnd_file.put_line (fnd_file.log,'-----------------------------------------------------------------');
209: fnd_file.new_line (fnd_file.log,1);
210:
211: wf_core.clear;
212:
213: -- Inactivate Workflow User Roles (Self and Member) for corresponding Inactive Resource Teams
214: FOR i IN c_team_wf_ur_del LOOP
215: BEGIN

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

224: p_overwrite => TRUE);
225:
226: EXCEPTION
227: WHEN OTHERS THEN
228: wf_core.get_error(error_name, error_message, error_stack);
229: fnd_file.put_line (fnd_file.log,error_message);
230: fnd_file.new_line (fnd_file.log,1);
231: fnd_file.put_line (fnd_file.log,error_stack);
232: fnd_file.new_line (fnd_file.log,1);

Line 233: wf_core.clear;

229: fnd_file.put_line (fnd_file.log,error_message);
230: fnd_file.new_line (fnd_file.log,1);
231: fnd_file.put_line (fnd_file.log,error_stack);
232: fnd_file.new_line (fnd_file.log,1);
233: wf_core.clear;
234: END;
235: END LOOP;
236:
237: fnd_file.put_line (fnd_file.log,log_message36);

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

260:
261: EXCEPTION
262: WHEN OTHERS THEN
263: l_list.DELETE;
264: wf_core.get_error(error_name, error_message, error_stack);
265: fnd_file.put_line (fnd_file.log,error_message);
266: fnd_file.new_line (fnd_file.log,1);
267: fnd_file.put_line (fnd_file.log,error_stack);
268: fnd_file.new_line (fnd_file.log,1);

Line 269: wf_core.clear;

265: fnd_file.put_line (fnd_file.log,error_message);
266: fnd_file.new_line (fnd_file.log,1);
267: fnd_file.put_line (fnd_file.log,error_stack);
268: fnd_file.new_line (fnd_file.log,1);
269: wf_core.clear;
270: END;
271: END LOOP;
272:
273: fnd_file.put_line (fnd_file.log,log_message12);

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

299:
300: EXCEPTION
301: WHEN OTHERS THEN
302: l_list.DELETE;
303: wf_core.get_error(error_name, error_message, error_stack);
304: fnd_file.put_line (fnd_file.log,error_message);
305: fnd_file.new_line (fnd_file.log,1);
306: fnd_file.put_line (fnd_file.log,error_stack);
307: fnd_file.new_line (fnd_file.log,1);

Line 308: wf_core.clear;

304: fnd_file.put_line (fnd_file.log,error_message);
305: fnd_file.new_line (fnd_file.log,1);
306: fnd_file.put_line (fnd_file.log,error_stack);
307: fnd_file.new_line (fnd_file.log,1);
308: wf_core.clear;
309: END;
310:
311: IF (i.wlr_start_date IS NULL OR
312: i.start_date_active <> i.wlr_start_date OR

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

326: p_overwrite => TRUE);
327:
328: EXCEPTION
329: WHEN OTHERS THEN
330: wf_core.get_error(error_name, error_message, error_stack);
331: fnd_file.put_line (fnd_file.log,error_message);
332: fnd_file.new_line (fnd_file.log,1);
333: fnd_file.put_line (fnd_file.log,error_stack);
334: fnd_file.new_line (fnd_file.log,1);

Line 335: wf_core.clear;

331: fnd_file.put_line (fnd_file.log,error_message);
332: fnd_file.new_line (fnd_file.log,1);
333: fnd_file.put_line (fnd_file.log,error_stack);
334: fnd_file.new_line (fnd_file.log,1);
335: wf_core.clear;
336: END;
337: END IF;
338:
339: END LOOP;

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

357: p_overwrite => TRUE);
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_message37);

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

392:
393: EXCEPTION
394: WHEN OTHERS THEN
395: l_list.DELETE;
396: wf_core.get_error(error_name, error_message, error_stack);
397: fnd_file.put_line (fnd_file.log,error_message);
398: fnd_file.new_line (fnd_file.log,1);
399: fnd_file.put_line (fnd_file.log,error_stack);
400: fnd_file.new_line (fnd_file.log,1);

Line 401: wf_core.clear;

397: fnd_file.put_line (fnd_file.log,error_message);
398: fnd_file.new_line (fnd_file.log,1);
399: fnd_file.put_line (fnd_file.log,error_stack);
400: fnd_file.new_line (fnd_file.log,1);
401: wf_core.clear;
402: END;
403:
404: -- Create Self-Record in wf_local_user_roles for the above record
405: BEGIN

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

413: p_expiration_date => i.end_date_active);
414:
415: EXCEPTION
416: WHEN OTHERS THEN
417: wf_core.get_error(error_name, error_message, error_stack);
418: fnd_file.put_line (fnd_file.log,error_message);
419: fnd_file.new_line (fnd_file.log,1);
420: fnd_file.put_line (fnd_file.log,error_stack);
421: fnd_file.new_line (fnd_file.log,1);

Line 422: wf_core.clear;

418: fnd_file.put_line (fnd_file.log,error_message);
419: fnd_file.new_line (fnd_file.log,1);
420: fnd_file.put_line (fnd_file.log,error_stack);
421: fnd_file.new_line (fnd_file.log,1);
422: wf_core.clear;
423: END;
424: END LOOP;
425:
426: fnd_file.put_line (fnd_file.log,log_message14);

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

429: fnd_file.new_line (fnd_file.log,1);
430:
431: EXCEPTION
432: WHEN OTHERS THEN
433: wf_core.get_error(error_name, error_message, error_stack);
434: fnd_file.put_line (fnd_file.log,error_message);
435: fnd_file.new_line (fnd_file.log,1);
436: fnd_file.put_line (fnd_file.log,error_stack);
437: fnd_file.new_line (fnd_file.log,1);

Line 438: wf_core.clear;

434: fnd_file.put_line (fnd_file.log,error_message);
435: fnd_file.new_line (fnd_file.log,1);
436: fnd_file.put_line (fnd_file.log,error_stack);
437: fnd_file.new_line (fnd_file.log,1);
438: wf_core.clear;
439:
440: END synchronize_teams_wf;
441:
442:

Line 564: wf_core.clear;

560: --fnd_file.put_line (fnd_file.log,'Beginning of Resource Workflow Synchronization for Resource Groups');
561: fnd_file.put_line (fnd_file.log,'------------------------------------------------------------------');
562: fnd_file.new_line (fnd_file.log,1);
563:
564: wf_core.clear;
565:
566: -- Inactivate Workflow User Roles (Self-Records) for corresponding Inactive Resource Groups
567: FOR i IN c_grp_wf_ur_del LOOP
568: BEGIN

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

577: p_overwrite => TRUE);
578:
579: EXCEPTION
580: WHEN OTHERS THEN
581: wf_core.get_error(error_name, error_message, error_stack);
582: fnd_file.put_line (fnd_file.log,error_message);
583: fnd_file.new_line (fnd_file.log,1);
584: fnd_file.put_line (fnd_file.log,error_stack);
585: fnd_file.new_line (fnd_file.log,1);

Line 586: wf_core.clear;

582: fnd_file.put_line (fnd_file.log,error_message);
583: fnd_file.new_line (fnd_file.log,1);
584: fnd_file.put_line (fnd_file.log,error_stack);
585: fnd_file.new_line (fnd_file.log,1);
586: wf_core.clear;
587: END;
588: END LOOP;
589:
590: fnd_file.put_line (fnd_file.log,log_message38);

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

613:
614: EXCEPTION
615: WHEN OTHERS THEN
616: l_list.DELETE;
617: wf_core.get_error(error_name, error_message, error_stack);
618: fnd_file.put_line (fnd_file.log,error_message);
619: fnd_file.new_line (fnd_file.log,1);
620: fnd_file.put_line (fnd_file.log,error_stack);
621: fnd_file.new_line (fnd_file.log,1);

Line 622: wf_core.clear;

618: fnd_file.put_line (fnd_file.log,error_message);
619: fnd_file.new_line (fnd_file.log,1);
620: fnd_file.put_line (fnd_file.log,error_stack);
621: fnd_file.new_line (fnd_file.log,1);
622: wf_core.clear;
623: END;
624: END LOOP;
625:
626: fnd_file.put_line (fnd_file.log,log_message1);

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

652:
653: EXCEPTION
654: WHEN OTHERS THEN
655: l_list.DELETE;
656: wf_core.get_error(error_name, error_message, error_stack);
657: fnd_file.put_line (fnd_file.log,error_message);
658: fnd_file.new_line (fnd_file.log,1);
659: fnd_file.put_line (fnd_file.log,error_stack);
660: fnd_file.new_line (fnd_file.log,1);

Line 661: wf_core.clear;

657: fnd_file.put_line (fnd_file.log,error_message);
658: fnd_file.new_line (fnd_file.log,1);
659: fnd_file.put_line (fnd_file.log,error_stack);
660: fnd_file.new_line (fnd_file.log,1);
661: wf_core.clear;
662: END;
663:
664: IF (i.wlr_start_date IS NULL OR
665: i.start_date_active <> i.wlr_start_date OR

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

679: p_overwrite => TRUE);
680:
681: EXCEPTION
682: WHEN OTHERS THEN
683: wf_core.get_error(error_name, error_message, error_stack);
684: fnd_file.put_line (fnd_file.log,error_message);
685: fnd_file.new_line (fnd_file.log,1);
686: fnd_file.put_line (fnd_file.log,error_stack);
687: fnd_file.new_line (fnd_file.log,1);

Line 688: wf_core.clear;

684: fnd_file.put_line (fnd_file.log,error_message);
685: fnd_file.new_line (fnd_file.log,1);
686: fnd_file.put_line (fnd_file.log,error_stack);
687: fnd_file.new_line (fnd_file.log,1);
688: wf_core.clear;
689: END;
690: END IF;
691:
692: END LOOP;

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

710: p_overwrite => TRUE);
711:
712: EXCEPTION
713: WHEN OTHERS THEN
714: wf_core.get_error(error_name, error_message, error_stack);
715: fnd_file.put_line (fnd_file.log,error_message);
716: fnd_file.new_line (fnd_file.log,1);
717: fnd_file.put_line (fnd_file.log,error_stack);
718: fnd_file.new_line (fnd_file.log,1);

Line 719: wf_core.clear;

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

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

744:
745: EXCEPTION
746: WHEN OTHERS THEN
747: l_list.DELETE;
748: wf_core.get_error(error_name, error_message, error_stack);
749: fnd_file.put_line (fnd_file.log,error_message);
750: fnd_file.new_line (fnd_file.log,1);
751: fnd_file.put_line (fnd_file.log,error_stack);
752: fnd_file.new_line (fnd_file.log,1);

Line 753: wf_core.clear;

749: fnd_file.put_line (fnd_file.log,error_message);
750: fnd_file.new_line (fnd_file.log,1);
751: fnd_file.put_line (fnd_file.log,error_stack);
752: fnd_file.new_line (fnd_file.log,1);
753: wf_core.clear;
754: END;
755:
756: -- Create Self-Record in wf_local_user_roles for the above record
757: BEGIN

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

764: p_start_date => i.start_date_active,
765: p_expiration_date => i.end_date_active);
766: EXCEPTION
767: WHEN OTHERS THEN
768: wf_core.get_error(error_name, error_message, error_stack);
769: fnd_file.put_line (fnd_file.log,error_message);
770: fnd_file.new_line (fnd_file.log,1);
771: fnd_file.put_line (fnd_file.log,error_stack);
772: fnd_file.new_line (fnd_file.log,1);

Line 773: wf_core.clear;

769: fnd_file.put_line (fnd_file.log,error_message);
770: fnd_file.new_line (fnd_file.log,1);
771: fnd_file.put_line (fnd_file.log,error_stack);
772: fnd_file.new_line (fnd_file.log,1);
773: wf_core.clear;
774: END;
775: END LOOP;
776:
777: fnd_file.put_line (fnd_file.log,log_message3);

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

780: fnd_file.new_line (fnd_file.log,1);
781:
782: EXCEPTION
783: WHEN OTHERS THEN
784: wf_core.get_error(error_name, error_message, error_stack);
785: fnd_file.put_line (fnd_file.log,error_message);
786: fnd_file.new_line (fnd_file.log,1);
787: fnd_file.put_line (fnd_file.log,error_stack);
788: fnd_file.new_line (fnd_file.log,1);

Line 789: wf_core.clear;

785: fnd_file.put_line (fnd_file.log,error_message);
786: fnd_file.new_line (fnd_file.log,1);
787: fnd_file.put_line (fnd_file.log,error_stack);
788: fnd_file.new_line (fnd_file.log,1);
789: wf_core.clear;
790:
791: END synchronize_groups_wf;
792:
793:

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

866: p_expiration_date => l_sysdate-1,
867: p_overwrite => TRUE);
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: -- Get all wf roles still defined as JRES_IND and Active.
879: FOR n in c_wf_role_details (i.resource_id, l_ind_orig_system, l_ind_user_name) LOOP

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

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

Line 905: wf_core.clear;

901: fnd_file.put_line (fnd_file.log,error_message);
902: fnd_file.new_line (fnd_file.log,1);
903: fnd_file.put_line (fnd_file.log,error_stack);
904: fnd_file.new_line (fnd_file.log,1);
905: wf_core.clear;
906: END;
907: END IF;
908: END LOOP;
909: -- Check if the Resources of category OTHER and TBH are inactive

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

922: p_overwrite => TRUE);
923:
924: EXCEPTION
925: WHEN OTHERS THEN
926: wf_core.get_error(error_name, error_message, error_stack);
927: fnd_file.put_line (fnd_file.log,error_message);
928: fnd_file.new_line (fnd_file.log,1);
929: fnd_file.put_line (fnd_file.log,error_stack);
930: fnd_file.new_line (fnd_file.log,1);

Line 931: wf_core.clear;

927: fnd_file.put_line (fnd_file.log,error_message);
928: fnd_file.new_line (fnd_file.log,1);
929: fnd_file.put_line (fnd_file.log,error_stack);
930: fnd_file.new_line (fnd_file.log,1);
931: wf_core.clear;
932: END;
933: END LOOP;
934: -- Inactivate corresponding wf roles with resource dates
935: FOR p in c_wf_role_details (i.resource_id, l_ind_orig_system , l_ind_user_name) LOOP

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

951: l_list.DELETE;
952: EXCEPTION
953: WHEN OTHERS THEN
954: l_list.DELETE;
955: wf_core.get_error(error_name, error_message, error_stack);
956: fnd_file.put_line (fnd_file.log,error_message);
957: fnd_file.new_line (fnd_file.log,1);
958: fnd_file.put_line (fnd_file.log,error_stack);
959: fnd_file.new_line (fnd_file.log,1);

Line 960: wf_core.clear;

956: fnd_file.put_line (fnd_file.log,error_message);
957: fnd_file.new_line (fnd_file.log,1);
958: fnd_file.put_line (fnd_file.log,error_stack);
959: fnd_file.new_line (fnd_file.log,1);
960: wf_core.clear;
961: END;
962: END IF;
963: END LOOP;
964: END IF;

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

1002: p_expiration_date => l_end_date,
1003: p_overwrite => TRUE);
1004: EXCEPTION
1005: WHEN OTHERS THEN
1006: wf_core.get_error(error_name, error_message, error_stack);
1007: fnd_file.put_line (fnd_file.log,error_message);
1008: fnd_file.new_line (fnd_file.log,1);
1009: fnd_file.put_line (fnd_file.log,error_stack);
1010: fnd_file.new_line (fnd_file.log,1);

Line 1011: wf_core.clear;

1007: fnd_file.put_line (fnd_file.log,error_message);
1008: fnd_file.new_line (fnd_file.log,1);
1009: fnd_file.put_line (fnd_file.log,error_stack);
1010: fnd_file.new_line (fnd_file.log,1);
1011: wf_core.clear;
1012: END;
1013: END IF;
1014: END IF;
1015: END LOOP;

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

1051: IF c_wf_role_details%ISOPEN THEN
1052: CLOSE c_wf_role_details;
1053: END IF;
1054: l_list.DELETE;
1055: wf_core.get_error(error_name, error_message, error_stack);
1056: fnd_file.put_line (fnd_file.log,error_message);
1057: fnd_file.new_line (fnd_file.log,1);
1058: fnd_file.put_line (fnd_file.log,error_stack);
1059: fnd_file.new_line (fnd_file.log,1);

Line 1060: wf_core.clear;

1056: fnd_file.put_line (fnd_file.log,error_message);
1057: fnd_file.new_line (fnd_file.log,1);
1058: fnd_file.put_line (fnd_file.log,error_stack);
1059: fnd_file.new_line (fnd_file.log,1);
1060: wf_core.clear;
1061: END;
1062: END IF;
1063: END IF;
1064: ELSE

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

1079: l_list.DELETE;
1080: EXCEPTION
1081: WHEN OTHERS THEN
1082: l_list.DELETE;
1083: wf_core.get_error(error_name, error_message, error_stack);
1084: fnd_file.put_line (fnd_file.log,error_message);
1085: fnd_file.new_line (fnd_file.log,1);
1086: fnd_file.put_line (fnd_file.log,error_stack);
1087: fnd_file.new_line (fnd_file.log,1);

Line 1088: wf_core.clear;

1084: fnd_file.put_line (fnd_file.log,error_message);
1085: fnd_file.new_line (fnd_file.log,1);
1086: fnd_file.put_line (fnd_file.log,error_stack);
1087: fnd_file.new_line (fnd_file.log,1);
1088: wf_core.clear;
1089: END;
1090: -- Create Self-Record in wf_local_user_roles for the above record
1091: BEGIN
1092: Wf_local_synch.propagate_user_role(

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

1098: p_start_date => i.start_date_active,
1099: p_expiration_date => i.end_date_active);
1100: EXCEPTION
1101: WHEN OTHERS THEN
1102: wf_core.get_error(error_name, error_message, error_stack);
1103: fnd_file.put_line (fnd_file.log,error_message);
1104: fnd_file.new_line (fnd_file.log,1);
1105: fnd_file.put_line (fnd_file.log,error_stack);
1106: fnd_file.new_line (fnd_file.log,1);

Line 1107: wf_core.clear;

1103: fnd_file.put_line (fnd_file.log,error_message);
1104: fnd_file.new_line (fnd_file.log,1);
1105: fnd_file.put_line (fnd_file.log,error_stack);
1106: fnd_file.new_line (fnd_file.log,1);
1107: wf_core.clear;
1108: END;
1109: END IF;
1110: END IF;
1111: CLOSE c_wf_role_details;

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

1282: p_expiration_date => sysdate-1,
1283: p_overwrite => TRUE);
1284: EXCEPTION
1285: WHEN OTHERS THEN
1286: wf_core.get_error(error_name, error_message, error_stack);
1287: fnd_file.put_line (fnd_file.log,error_message);
1288: fnd_file.new_line (fnd_file.log,1);
1289: fnd_file.put_line (fnd_file.log,error_stack);
1290: fnd_file.new_line (fnd_file.log,1);

Line 1291: wf_core.clear;

1287: fnd_file.put_line (fnd_file.log,error_message);
1288: fnd_file.new_line (fnd_file.log,1);
1289: fnd_file.put_line (fnd_file.log,error_stack);
1290: fnd_file.new_line (fnd_file.log,1);
1291: wf_core.clear;
1292: END;
1293: END IF;
1294: END;
1295: END LOOP;

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

1318: p_start_date => i.m_start_date_active,
1319: p_expiration_date => l_end_date_active);
1320: EXCEPTION
1321: WHEN OTHERS THEN
1322: wf_core.get_error(error_name, error_message, error_stack);
1323: fnd_file.put_line (fnd_file.log,error_message);
1324: fnd_file.new_line (fnd_file.log,1);
1325: fnd_file.put_line (fnd_file.log,error_stack);
1326: fnd_file.new_line (fnd_file.log,1);

Line 1327: wf_core.clear;

1323: fnd_file.put_line (fnd_file.log,error_message);
1324: fnd_file.new_line (fnd_file.log,1);
1325: fnd_file.put_line (fnd_file.log,error_stack);
1326: fnd_file.new_line (fnd_file.log,1);
1327: wf_core.clear;
1328: END;
1329: END LOOP;
1330:
1331: fnd_file.put_line (fnd_file.log,log_message30);

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

1363: p_start_date => i.m_start_date_active,
1364: p_expiration_date => l_end_date_active);
1365: EXCEPTION
1366: WHEN OTHERS THEN
1367: wf_core.get_error(error_name, error_message, error_stack);
1368: fnd_file.put_line (fnd_file.log,error_message);
1369: fnd_file.new_line (fnd_file.log,1);
1370: fnd_file.put_line (fnd_file.log,error_stack);
1371: fnd_file.new_line (fnd_file.log,1);

Line 1372: wf_core.clear;

1368: fnd_file.put_line (fnd_file.log,error_message);
1369: fnd_file.new_line (fnd_file.log,1);
1370: fnd_file.put_line (fnd_file.log,error_stack);
1371: fnd_file.new_line (fnd_file.log,1);
1372: wf_core.clear;
1373: END;
1374: END IF;
1375: END LOOP;
1376:

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

1386: END IF;
1387:
1388: EXCEPTION
1389: WHEN OTHERS THEN
1390: wf_core.get_error(error_name, error_message, error_stack);
1391: fnd_file.put_line (fnd_file.log,error_message);
1392: fnd_file.new_line (fnd_file.log,1);
1393: fnd_file.put_line (fnd_file.log,error_stack);
1394: fnd_file.new_line (fnd_file.log,1);

Line 1395: wf_core.clear;

1391: fnd_file.put_line (fnd_file.log,error_message);
1392: fnd_file.new_line (fnd_file.log,1);
1393: fnd_file.put_line (fnd_file.log,error_stack);
1394: fnd_file.new_line (fnd_file.log,1);
1395: wf_core.clear;
1396:
1397: END synchronize_group_members_wf;
1398:
1399:

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

1553: p_expiration_date => sysdate-1,
1554: p_overwrite => TRUE);
1555: EXCEPTION
1556: WHEN OTHERS THEN
1557: wf_core.get_error(error_name, error_message, error_stack);
1558: fnd_file.put_line (fnd_file.log,error_message);
1559: fnd_file.new_line (fnd_file.log,1);
1560: fnd_file.put_line (fnd_file.log,error_stack);
1561: fnd_file.new_line (fnd_file.log,1);

Line 1562: wf_core.clear;

1558: fnd_file.put_line (fnd_file.log,error_message);
1559: fnd_file.new_line (fnd_file.log,1);
1560: fnd_file.put_line (fnd_file.log,error_stack);
1561: fnd_file.new_line (fnd_file.log,1);
1562: wf_core.clear;
1563: END;
1564: END LOOP;
1565:
1566: fnd_file.put_line (fnd_file.log,log_message32);

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

1587: p_start_date => i.m_start_date_active,
1588: p_expiration_date => l_end_date_active);
1589: EXCEPTION
1590: WHEN OTHERS THEN
1591: wf_core.get_error(error_name, error_message, error_stack);
1592: fnd_file.put_line (fnd_file.log,error_message);
1593: fnd_file.new_line (fnd_file.log,1);
1594: fnd_file.put_line (fnd_file.log,error_stack);
1595: fnd_file.new_line (fnd_file.log,1);

Line 1596: wf_core.clear;

1592: fnd_file.put_line (fnd_file.log,error_message);
1593: fnd_file.new_line (fnd_file.log,1);
1594: fnd_file.put_line (fnd_file.log,error_stack);
1595: fnd_file.new_line (fnd_file.log,1);
1596: wf_core.clear;
1597: END;
1598: END LOOP;
1599:
1600: fnd_file.put_line (fnd_file.log,log_message33);

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

1632: p_start_date => i.m_start_date_active,
1633: p_expiration_date => l_end_date_active);
1634: EXCEPTION
1635: WHEN OTHERS THEN
1636: wf_core.get_error(error_name, error_message, error_stack);
1637: fnd_file.put_line (fnd_file.log,error_message);
1638: fnd_file.new_line (fnd_file.log,1);
1639: fnd_file.put_line (fnd_file.log,error_stack);
1640: fnd_file.new_line (fnd_file.log,1);

Line 1641: wf_core.clear;

1637: fnd_file.put_line (fnd_file.log,error_message);
1638: fnd_file.new_line (fnd_file.log,1);
1639: fnd_file.put_line (fnd_file.log,error_stack);
1640: fnd_file.new_line (fnd_file.log,1);
1641: wf_core.clear;
1642: END;
1643: END IF;
1644: END LOOP;
1645:

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

1666: p_start_date => i.m_start_date_active,
1667: p_expiration_date => l_end_date_active);
1668: EXCEPTION
1669: WHEN OTHERS THEN
1670: wf_core.get_error(error_name, error_message, error_stack);
1671: fnd_file.put_line (fnd_file.log,error_message);
1672: fnd_file.new_line (fnd_file.log,1);
1673: fnd_file.put_line (fnd_file.log,error_stack);
1674: fnd_file.new_line (fnd_file.log,1);

Line 1675: wf_core.clear;

1671: fnd_file.put_line (fnd_file.log,error_message);
1672: fnd_file.new_line (fnd_file.log,1);
1673: fnd_file.put_line (fnd_file.log,error_stack);
1674: fnd_file.new_line (fnd_file.log,1);
1675: wf_core.clear;
1676: END;
1677: END LOOP;
1678:
1679: fnd_file.put_line (fnd_file.log,log_message35);

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

1682: fnd_file.new_line (fnd_file.log,1);
1683:
1684: EXCEPTION
1685: WHEN OTHERS THEN
1686: wf_core.get_error(error_name, error_message, error_stack);
1687: fnd_file.put_line (fnd_file.log,error_message);
1688: fnd_file.new_line (fnd_file.log,1);
1689: fnd_file.put_line (fnd_file.log,error_stack);
1690: fnd_file.new_line (fnd_file.log,1);

Line 1691: wf_core.clear;

1687: fnd_file.put_line (fnd_file.log,error_message);
1688: fnd_file.new_line (fnd_file.log,1);
1689: fnd_file.put_line (fnd_file.log,error_stack);
1690: fnd_file.new_line (fnd_file.log,1);
1691: wf_core.clear;
1692:
1693: END synchronize_team_members_wf;
1694:
1695: BEGIN