eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_WF_SYNCH dependencies on WF_EVENT

Line 22: | p_event in out NOCOPY wf_event_t |

18: | |
19: | OUT: |
20: | |
21: | IN/ OUT: |
22: | p_event in out NOCOPY wf_event_t |
23: | |
24: | |
25: | |
26: | RETURNS : VARCHAR2 |

Line 43: p_event IN OUT NOCOPY wf_event_t)

39: +===========================================================================*/
40:
41: FUNCTION propagate_user_role(
42: p_subscription_guid IN RAW,
43: p_event IN OUT NOCOPY wf_event_t)
44: RETURN VARCHAR2
45: IS
46: l_key VARCHAR2(240) := p_event.GetEventKey();
47: l_user_orig_system VARCHAR2(100) := 'HZ_PARTY';

Line 87: WF_EVENT.setErrorInfo(p_event, 'ERROR');

83: WF_CORE.CONTEXT('HZ_WF_SYNCH',
84: 'propagate_user_role',
85: p_event.getEventName(),
86: p_subscription_guid);
87: WF_EVENT.setErrorInfo(p_event, 'ERROR');
88: ROLLBACK TO propagate_user_role;
89: RETURN 'ERROR';
90: END; -- propagate_user_role()
91:

Line 111: | p_event in out NOCOPY wf_event_t | |

107: | |
108: | OUT: |
109: | |
110: | IN/ OUT: |
111: | p_event in out NOCOPY wf_event_t | |
112: | |
113: | |
114: | |
115: | RETURNS : NONE |

Line 133: p_event IN OUT NOCOPY wf_event_t)

129: +===========================================================================*/
130:
131: FUNCTION propagate_role(
132: p_subscription_guid IN RAW,
133: p_event IN OUT NOCOPY wf_event_t)
134: RETURN VARCHAR2
135: IS
136: l_key VARCHAR2(240) := p_event.GetEventKey();
137: l_orig_system VARCHAR2(100) := 'HZ_PARTY';

Line 678: WF_EVENT.setErrorInfo(p_event, 'ERROR');

674: WF_CORE.CONTEXT('HZ_WF_SYNCH',
675: 'propagate_user_role',
676: p_event.getEventName(),
677: p_subscription_guid);
678: WF_EVENT.setErrorInfo(p_event, 'ERROR');
679: ROLLBACK TO propagate_role;
680: RETURN 'ERROR';
681: END; -- end of propagate_role()
682:

Line 829: -- Add the TCA registry Data as parameters to wf_event

825: p_prefix =>l_debug_prefix,
826: p_msg_level=>fnd_log.level_statement);
827: END IF;
828:
829: -- Add the TCA registry Data as parameters to wf_event
830: -- This is needed as the WF API access the wf_event structure for
831: -- the information passed.
832:
833: wf_event.AddParameterToList('User_Name', user_name, List);

Line 830: -- This is needed as the WF API access the wf_event structure for

826: p_msg_level=>fnd_log.level_statement);
827: END IF;
828:
829: -- Add the TCA registry Data as parameters to wf_event
830: -- This is needed as the WF API access the wf_event structure for
831: -- the information passed.
832:
833: wf_event.AddParameterToList('User_Name', user_name, List);
834: wf_event.AddParameterToList('DisplayName', display_name, List);

Line 833: wf_event.AddParameterToList('User_Name', user_name, List);

829: -- Add the TCA registry Data as parameters to wf_event
830: -- This is needed as the WF API access the wf_event structure for
831: -- the information passed.
832:
833: wf_event.AddParameterToList('User_Name', user_name, List);
834: wf_event.AddParameterToList('DisplayName', display_name, List);
835: wf_event.AddParameterToList('Description', description, List);
836: wf_event.AddParameterToList('orclWorkFlowNotificationPref', notification_pref, List);
837: wf_event.AddParameterToList('preferredLanguage', language, List);

Line 834: wf_event.AddParameterToList('DisplayName', display_name, List);

830: -- This is needed as the WF API access the wf_event structure for
831: -- the information passed.
832:
833: wf_event.AddParameterToList('User_Name', user_name, List);
834: wf_event.AddParameterToList('DisplayName', display_name, List);
835: wf_event.AddParameterToList('Description', description, List);
836: wf_event.AddParameterToList('orclWorkFlowNotificationPref', notification_pref, List);
837: wf_event.AddParameterToList('preferredLanguage', language, List);
838: wf_event.AddParameterToList('OrclNLSTerritory', territory, List);

Line 835: wf_event.AddParameterToList('Description', description, List);

831: -- the information passed.
832:
833: wf_event.AddParameterToList('User_Name', user_name, List);
834: wf_event.AddParameterToList('DisplayName', display_name, List);
835: wf_event.AddParameterToList('Description', description, List);
836: wf_event.AddParameterToList('orclWorkFlowNotificationPref', notification_pref, List);
837: wf_event.AddParameterToList('preferredLanguage', language, List);
838: wf_event.AddParameterToList('OrclNLSTerritory', territory, List);
839: wf_event.AddParameterToList('Mail', email_address, List);

Line 836: wf_event.AddParameterToList('orclWorkFlowNotificationPref', notification_pref, List);

832:
833: wf_event.AddParameterToList('User_Name', user_name, List);
834: wf_event.AddParameterToList('DisplayName', display_name, List);
835: wf_event.AddParameterToList('Description', description, List);
836: wf_event.AddParameterToList('orclWorkFlowNotificationPref', notification_pref, List);
837: wf_event.AddParameterToList('preferredLanguage', language, List);
838: wf_event.AddParameterToList('OrclNLSTerritory', territory, List);
839: wf_event.AddParameterToList('Mail', email_address, List);
840: wf_event.AddParameterToList('FacsimileTelephoneNumber', fax, List);

Line 837: wf_event.AddParameterToList('preferredLanguage', language, List);

833: wf_event.AddParameterToList('User_Name', user_name, List);
834: wf_event.AddParameterToList('DisplayName', display_name, List);
835: wf_event.AddParameterToList('Description', description, List);
836: wf_event.AddParameterToList('orclWorkFlowNotificationPref', notification_pref, List);
837: wf_event.AddParameterToList('preferredLanguage', language, List);
838: wf_event.AddParameterToList('OrclNLSTerritory', territory, List);
839: wf_event.AddParameterToList('Mail', email_address, List);
840: wf_event.AddParameterToList('FacsimileTelephoneNumber', fax, List);
841: wf_event.AddParameterToList('orclisEnabled', status, List);

Line 838: wf_event.AddParameterToList('OrclNLSTerritory', territory, List);

834: wf_event.AddParameterToList('DisplayName', display_name, List);
835: wf_event.AddParameterToList('Description', description, List);
836: wf_event.AddParameterToList('orclWorkFlowNotificationPref', notification_pref, List);
837: wf_event.AddParameterToList('preferredLanguage', language, List);
838: wf_event.AddParameterToList('OrclNLSTerritory', territory, List);
839: wf_event.AddParameterToList('Mail', email_address, List);
840: wf_event.AddParameterToList('FacsimileTelephoneNumber', fax, List);
841: wf_event.AddParameterToList('orclisEnabled', status, List);
842: wf_event.AddParameterToList('ExpirationDate', expiration_date, List);

Line 839: wf_event.AddParameterToList('Mail', email_address, List);

835: wf_event.AddParameterToList('Description', description, List);
836: wf_event.AddParameterToList('orclWorkFlowNotificationPref', notification_pref, List);
837: wf_event.AddParameterToList('preferredLanguage', language, List);
838: wf_event.AddParameterToList('OrclNLSTerritory', territory, List);
839: wf_event.AddParameterToList('Mail', email_address, List);
840: wf_event.AddParameterToList('FacsimileTelephoneNumber', fax, List);
841: wf_event.AddParameterToList('orclisEnabled', status, List);
842: wf_event.AddParameterToList('ExpirationDate', expiration_date, List);
843: wf_event.AddParameterToList('orclWFOrigSystem',system, List);

Line 840: wf_event.AddParameterToList('FacsimileTelephoneNumber', fax, List);

836: wf_event.AddParameterToList('orclWorkFlowNotificationPref', notification_pref, List);
837: wf_event.AddParameterToList('preferredLanguage', language, List);
838: wf_event.AddParameterToList('OrclNLSTerritory', territory, List);
839: wf_event.AddParameterToList('Mail', email_address, List);
840: wf_event.AddParameterToList('FacsimileTelephoneNumber', fax, List);
841: wf_event.AddParameterToList('orclisEnabled', status, List);
842: wf_event.AddParameterToList('ExpirationDate', expiration_date, List);
843: wf_event.AddParameterToList('orclWFOrigSystem',system, List);
844: wf_event.AddParameterToList('orclWFOrigSystemID',system_id, List);

Line 841: wf_event.AddParameterToList('orclisEnabled', status, List);

837: wf_event.AddParameterToList('preferredLanguage', language, List);
838: wf_event.AddParameterToList('OrclNLSTerritory', territory, List);
839: wf_event.AddParameterToList('Mail', email_address, List);
840: wf_event.AddParameterToList('FacsimileTelephoneNumber', fax, List);
841: wf_event.AddParameterToList('orclisEnabled', status, List);
842: wf_event.AddParameterToList('ExpirationDate', expiration_date, List);
843: wf_event.AddParameterToList('orclWFOrigSystem',system, List);
844: wf_event.AddParameterToList('orclWFOrigSystemID',system_id, List);
845:

Line 842: wf_event.AddParameterToList('ExpirationDate', expiration_date, List);

838: wf_event.AddParameterToList('OrclNLSTerritory', territory, List);
839: wf_event.AddParameterToList('Mail', email_address, List);
840: wf_event.AddParameterToList('FacsimileTelephoneNumber', fax, List);
841: wf_event.AddParameterToList('orclisEnabled', status, List);
842: wf_event.AddParameterToList('ExpirationDate', expiration_date, List);
843: wf_event.AddParameterToList('orclWFOrigSystem',system, List);
844: wf_event.AddParameterToList('orclWFOrigSystemID',system_id, List);
845:
846: if (p_update = TRUE) then

Line 843: wf_event.AddParameterToList('orclWFOrigSystem',system, List);

839: wf_event.AddParameterToList('Mail', email_address, List);
840: wf_event.AddParameterToList('FacsimileTelephoneNumber', fax, List);
841: wf_event.AddParameterToList('orclisEnabled', status, List);
842: wf_event.AddParameterToList('ExpirationDate', expiration_date, List);
843: wf_event.AddParameterToList('orclWFOrigSystem',system, List);
844: wf_event.AddParameterToList('orclWFOrigSystemID',system_id, List);
845:
846: if (p_update = TRUE) then
847: wf_event.AddParameterToList('UpdateOnly', 'TRUE' , List);

Line 844: wf_event.AddParameterToList('orclWFOrigSystemID',system_id, List);

840: wf_event.AddParameterToList('FacsimileTelephoneNumber', fax, List);
841: wf_event.AddParameterToList('orclisEnabled', status, List);
842: wf_event.AddParameterToList('ExpirationDate', expiration_date, List);
843: wf_event.AddParameterToList('orclWFOrigSystem',system, List);
844: wf_event.AddParameterToList('orclWFOrigSystemID',system_id, List);
845:
846: if (p_update = TRUE) then
847: wf_event.AddParameterToList('UpdateOnly', 'TRUE' , List);
848: end if;

Line 847: wf_event.AddParameterToList('UpdateOnly', 'TRUE' , List);

843: wf_event.AddParameterToList('orclWFOrigSystem',system, List);
844: wf_event.AddParameterToList('orclWFOrigSystemID',system_id, List);
845:
846: if (p_update = TRUE) then
847: wf_event.AddParameterToList('UpdateOnly', 'TRUE' , List);
848: end if;
849:
850: if (p_overwrite = TRUE) then
851: wf_event.AddParameterToList('WFSYNCH_OVERWRITE', 'TRUE', List);

Line 851: wf_event.AddParameterToList('WFSYNCH_OVERWRITE', 'TRUE', List);

847: wf_event.AddParameterToList('UpdateOnly', 'TRUE' , List);
848: end if;
849:
850: if (p_overwrite = TRUE) then
851: wf_event.AddParameterToList('WFSYNCH_OVERWRITE', 'TRUE', List);
852: end if;
853:
854: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
855: hz_utility_v2pub.DEBUG

Line 938: 1, Added wf_event.AddParameterToList('StartDate', start_date, List);

934: are relationship records that must sync up (unlike the previous
935: design). Hence need to re-write the SQL as a cursor.
936:
937: Param changes:
938: 1, Added wf_event.AddParameterToList('StartDate', start_date, List);
939:
940: BUG 4957312 changes
941: 1. email_format a.k.a Notification Preference defaulting was re-inroduced.
942:

Line 1061: -- Add the TCA registry Data as parameters to wf_event

1057: p_prefix =>l_debug_prefix,
1058: p_msg_level=>fnd_log.level_statement);
1059: END IF;
1060:
1061: -- Add the TCA registry Data as parameters to wf_event
1062: -- This is needed as the WF API access the wf_event structure for
1063: -- the information passed.
1064:
1065: wf_event.AddParameterToList('User_Name', l_tbl(i).user_name, List);

Line 1062: -- This is needed as the WF API access the wf_event structure for

1058: p_msg_level=>fnd_log.level_statement);
1059: END IF;
1060:
1061: -- Add the TCA registry Data as parameters to wf_event
1062: -- This is needed as the WF API access the wf_event structure for
1063: -- the information passed.
1064:
1065: wf_event.AddParameterToList('User_Name', l_tbl(i).user_name, List);
1066: wf_event.AddParameterToList('DisplayName', l_tbl(i).display_name, List);

Line 1065: wf_event.AddParameterToList('User_Name', l_tbl(i).user_name, List);

1061: -- Add the TCA registry Data as parameters to wf_event
1062: -- This is needed as the WF API access the wf_event structure for
1063: -- the information passed.
1064:
1065: wf_event.AddParameterToList('User_Name', l_tbl(i).user_name, List);
1066: wf_event.AddParameterToList('DisplayName', l_tbl(i).display_name, List);
1067: wf_event.AddParameterToList('Description', l_tbl(i).description, List);
1068: wf_event.AddParameterToList('orclWorkFlowNotificationPref', l_tbl(i).notification_pref, List);
1069: wf_event.AddParameterToList('preferredLanguage', l_tbl(i).language, List);

Line 1066: wf_event.AddParameterToList('DisplayName', l_tbl(i).display_name, List);

1062: -- This is needed as the WF API access the wf_event structure for
1063: -- the information passed.
1064:
1065: wf_event.AddParameterToList('User_Name', l_tbl(i).user_name, List);
1066: wf_event.AddParameterToList('DisplayName', l_tbl(i).display_name, List);
1067: wf_event.AddParameterToList('Description', l_tbl(i).description, List);
1068: wf_event.AddParameterToList('orclWorkFlowNotificationPref', l_tbl(i).notification_pref, List);
1069: wf_event.AddParameterToList('preferredLanguage', l_tbl(i).language, List);
1070: wf_event.AddParameterToList('OrclNLSTerritory', l_tbl(i).territory, List);

Line 1067: wf_event.AddParameterToList('Description', l_tbl(i).description, List);

1063: -- the information passed.
1064:
1065: wf_event.AddParameterToList('User_Name', l_tbl(i).user_name, List);
1066: wf_event.AddParameterToList('DisplayName', l_tbl(i).display_name, List);
1067: wf_event.AddParameterToList('Description', l_tbl(i).description, List);
1068: wf_event.AddParameterToList('orclWorkFlowNotificationPref', l_tbl(i).notification_pref, List);
1069: wf_event.AddParameterToList('preferredLanguage', l_tbl(i).language, List);
1070: wf_event.AddParameterToList('OrclNLSTerritory', l_tbl(i).territory, List);
1071: wf_event.AddParameterToList('Mail', l_tbl(i).email_address, List);

Line 1068: wf_event.AddParameterToList('orclWorkFlowNotificationPref', l_tbl(i).notification_pref, List);

1064:
1065: wf_event.AddParameterToList('User_Name', l_tbl(i).user_name, List);
1066: wf_event.AddParameterToList('DisplayName', l_tbl(i).display_name, List);
1067: wf_event.AddParameterToList('Description', l_tbl(i).description, List);
1068: wf_event.AddParameterToList('orclWorkFlowNotificationPref', l_tbl(i).notification_pref, List);
1069: wf_event.AddParameterToList('preferredLanguage', l_tbl(i).language, List);
1070: wf_event.AddParameterToList('OrclNLSTerritory', l_tbl(i).territory, List);
1071: wf_event.AddParameterToList('Mail', l_tbl(i).email_address, List);
1072: wf_event.AddParameterToList('FacsimileTelephoneNumber', l_tbl(i).fax, List);

Line 1069: wf_event.AddParameterToList('preferredLanguage', l_tbl(i).language, List);

1065: wf_event.AddParameterToList('User_Name', l_tbl(i).user_name, List);
1066: wf_event.AddParameterToList('DisplayName', l_tbl(i).display_name, List);
1067: wf_event.AddParameterToList('Description', l_tbl(i).description, List);
1068: wf_event.AddParameterToList('orclWorkFlowNotificationPref', l_tbl(i).notification_pref, List);
1069: wf_event.AddParameterToList('preferredLanguage', l_tbl(i).language, List);
1070: wf_event.AddParameterToList('OrclNLSTerritory', l_tbl(i).territory, List);
1071: wf_event.AddParameterToList('Mail', l_tbl(i).email_address, List);
1072: wf_event.AddParameterToList('FacsimileTelephoneNumber', l_tbl(i).fax, List);
1073: wf_event.AddParameterToList('orclisEnabled', l_tbl(i).status, List);

Line 1070: wf_event.AddParameterToList('OrclNLSTerritory', l_tbl(i).territory, List);

1066: wf_event.AddParameterToList('DisplayName', l_tbl(i).display_name, List);
1067: wf_event.AddParameterToList('Description', l_tbl(i).description, List);
1068: wf_event.AddParameterToList('orclWorkFlowNotificationPref', l_tbl(i).notification_pref, List);
1069: wf_event.AddParameterToList('preferredLanguage', l_tbl(i).language, List);
1070: wf_event.AddParameterToList('OrclNLSTerritory', l_tbl(i).territory, List);
1071: wf_event.AddParameterToList('Mail', l_tbl(i).email_address, List);
1072: wf_event.AddParameterToList('FacsimileTelephoneNumber', l_tbl(i).fax, List);
1073: wf_event.AddParameterToList('orclisEnabled', l_tbl(i).status, List);
1074: wf_event.AddParameterToList('StartDate', l_tbl(i).start_date, List);

Line 1071: wf_event.AddParameterToList('Mail', l_tbl(i).email_address, List);

1067: wf_event.AddParameterToList('Description', l_tbl(i).description, List);
1068: wf_event.AddParameterToList('orclWorkFlowNotificationPref', l_tbl(i).notification_pref, List);
1069: wf_event.AddParameterToList('preferredLanguage', l_tbl(i).language, List);
1070: wf_event.AddParameterToList('OrclNLSTerritory', l_tbl(i).territory, List);
1071: wf_event.AddParameterToList('Mail', l_tbl(i).email_address, List);
1072: wf_event.AddParameterToList('FacsimileTelephoneNumber', l_tbl(i).fax, List);
1073: wf_event.AddParameterToList('orclisEnabled', l_tbl(i).status, List);
1074: wf_event.AddParameterToList('StartDate', l_tbl(i).start_date, List);
1075: wf_event.AddParameterToList('ExpirationDate', l_tbl(i).expiration_date, List);

Line 1072: wf_event.AddParameterToList('FacsimileTelephoneNumber', l_tbl(i).fax, List);

1068: wf_event.AddParameterToList('orclWorkFlowNotificationPref', l_tbl(i).notification_pref, List);
1069: wf_event.AddParameterToList('preferredLanguage', l_tbl(i).language, List);
1070: wf_event.AddParameterToList('OrclNLSTerritory', l_tbl(i).territory, List);
1071: wf_event.AddParameterToList('Mail', l_tbl(i).email_address, List);
1072: wf_event.AddParameterToList('FacsimileTelephoneNumber', l_tbl(i).fax, List);
1073: wf_event.AddParameterToList('orclisEnabled', l_tbl(i).status, List);
1074: wf_event.AddParameterToList('StartDate', l_tbl(i).start_date, List);
1075: wf_event.AddParameterToList('ExpirationDate', l_tbl(i).expiration_date, List);
1076: wf_event.AddParameterToList('orclWFOrigSystem',system, List);

Line 1073: wf_event.AddParameterToList('orclisEnabled', l_tbl(i).status, List);

1069: wf_event.AddParameterToList('preferredLanguage', l_tbl(i).language, List);
1070: wf_event.AddParameterToList('OrclNLSTerritory', l_tbl(i).territory, List);
1071: wf_event.AddParameterToList('Mail', l_tbl(i).email_address, List);
1072: wf_event.AddParameterToList('FacsimileTelephoneNumber', l_tbl(i).fax, List);
1073: wf_event.AddParameterToList('orclisEnabled', l_tbl(i).status, List);
1074: wf_event.AddParameterToList('StartDate', l_tbl(i).start_date, List);
1075: wf_event.AddParameterToList('ExpirationDate', l_tbl(i).expiration_date, List);
1076: wf_event.AddParameterToList('orclWFOrigSystem',system, List);
1077: wf_event.AddParameterToList('orclWFOrigSystemID',l_tbl(i).system_id, List);

Line 1074: wf_event.AddParameterToList('StartDate', l_tbl(i).start_date, List);

1070: wf_event.AddParameterToList('OrclNLSTerritory', l_tbl(i).territory, List);
1071: wf_event.AddParameterToList('Mail', l_tbl(i).email_address, List);
1072: wf_event.AddParameterToList('FacsimileTelephoneNumber', l_tbl(i).fax, List);
1073: wf_event.AddParameterToList('orclisEnabled', l_tbl(i).status, List);
1074: wf_event.AddParameterToList('StartDate', l_tbl(i).start_date, List);
1075: wf_event.AddParameterToList('ExpirationDate', l_tbl(i).expiration_date, List);
1076: wf_event.AddParameterToList('orclWFOrigSystem',system, List);
1077: wf_event.AddParameterToList('orclWFOrigSystemID',l_tbl(i).system_id, List);
1078:

Line 1075: wf_event.AddParameterToList('ExpirationDate', l_tbl(i).expiration_date, List);

1071: wf_event.AddParameterToList('Mail', l_tbl(i).email_address, List);
1072: wf_event.AddParameterToList('FacsimileTelephoneNumber', l_tbl(i).fax, List);
1073: wf_event.AddParameterToList('orclisEnabled', l_tbl(i).status, List);
1074: wf_event.AddParameterToList('StartDate', l_tbl(i).start_date, List);
1075: wf_event.AddParameterToList('ExpirationDate', l_tbl(i).expiration_date, List);
1076: wf_event.AddParameterToList('orclWFOrigSystem',system, List);
1077: wf_event.AddParameterToList('orclWFOrigSystemID',l_tbl(i).system_id, List);
1078:
1079: IF (p_update = TRUE) then

Line 1076: wf_event.AddParameterToList('orclWFOrigSystem',system, List);

1072: wf_event.AddParameterToList('FacsimileTelephoneNumber', l_tbl(i).fax, List);
1073: wf_event.AddParameterToList('orclisEnabled', l_tbl(i).status, List);
1074: wf_event.AddParameterToList('StartDate', l_tbl(i).start_date, List);
1075: wf_event.AddParameterToList('ExpirationDate', l_tbl(i).expiration_date, List);
1076: wf_event.AddParameterToList('orclWFOrigSystem',system, List);
1077: wf_event.AddParameterToList('orclWFOrigSystemID',l_tbl(i).system_id, List);
1078:
1079: IF (p_update = TRUE) then
1080: wf_event.AddParameterToList('UpdateOnly', 'TRUE', List);

Line 1077: wf_event.AddParameterToList('orclWFOrigSystemID',l_tbl(i).system_id, List);

1073: wf_event.AddParameterToList('orclisEnabled', l_tbl(i).status, List);
1074: wf_event.AddParameterToList('StartDate', l_tbl(i).start_date, List);
1075: wf_event.AddParameterToList('ExpirationDate', l_tbl(i).expiration_date, List);
1076: wf_event.AddParameterToList('orclWFOrigSystem',system, List);
1077: wf_event.AddParameterToList('orclWFOrigSystemID',l_tbl(i).system_id, List);
1078:
1079: IF (p_update = TRUE) then
1080: wf_event.AddParameterToList('UpdateOnly', 'TRUE', List);
1081: END IF;

Line 1080: wf_event.AddParameterToList('UpdateOnly', 'TRUE', List);

1076: wf_event.AddParameterToList('orclWFOrigSystem',system, List);
1077: wf_event.AddParameterToList('orclWFOrigSystemID',l_tbl(i).system_id, List);
1078:
1079: IF (p_update = TRUE) then
1080: wf_event.AddParameterToList('UpdateOnly', 'TRUE', List);
1081: END IF;
1082:
1083: IF (p_overwrite = TRUE) THEN
1084: wf_event.AddParameterToList('WFSYNCH_OVERWRITE', 'TRUE', List);

Line 1084: wf_event.AddParameterToList('WFSYNCH_OVERWRITE', 'TRUE', List);

1080: wf_event.AddParameterToList('UpdateOnly', 'TRUE', List);
1081: END IF;
1082:
1083: IF (p_overwrite = TRUE) THEN
1084: wf_event.AddParameterToList('WFSYNCH_OVERWRITE', 'TRUE', List);
1085: END IF;
1086:
1087: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1088: hz_utility_v2pub.DEBUG

Line 1283: -- Add the TCA registry Data as parameters to wf_event

1279: p_prefix =>l_debug_prefix,
1280: p_msg_level=>fnd_log.level_statement);
1281: END IF;
1282:
1283: -- Add the TCA registry Data as parameters to wf_event
1284: -- This is needed as the WF API access the wf_event structure for
1285: -- the information passed.
1286:
1287: wf_event.AddParameterToList('User_Name', user_name, List);

Line 1284: -- This is needed as the WF API access the wf_event structure for

1280: p_msg_level=>fnd_log.level_statement);
1281: END IF;
1282:
1283: -- Add the TCA registry Data as parameters to wf_event
1284: -- This is needed as the WF API access the wf_event structure for
1285: -- the information passed.
1286:
1287: wf_event.AddParameterToList('User_Name', user_name, List);
1288: wf_event.AddParameterToList('DisplayName', display_name, List);

Line 1287: wf_event.AddParameterToList('User_Name', user_name, List);

1283: -- Add the TCA registry Data as parameters to wf_event
1284: -- This is needed as the WF API access the wf_event structure for
1285: -- the information passed.
1286:
1287: wf_event.AddParameterToList('User_Name', user_name, List);
1288: wf_event.AddParameterToList('DisplayName', display_name, List);
1289: wf_event.AddParameterToList('Description', description, List);
1290: wf_event.AddParameterToList('orclWorkFlowNotificationPref', notification_pref, List);
1291: wf_event.AddParameterToList('preferredLanguage', language, List);

Line 1288: wf_event.AddParameterToList('DisplayName', display_name, List);

1284: -- This is needed as the WF API access the wf_event structure for
1285: -- the information passed.
1286:
1287: wf_event.AddParameterToList('User_Name', user_name, List);
1288: wf_event.AddParameterToList('DisplayName', display_name, List);
1289: wf_event.AddParameterToList('Description', description, List);
1290: wf_event.AddParameterToList('orclWorkFlowNotificationPref', notification_pref, List);
1291: wf_event.AddParameterToList('preferredLanguage', language, List);
1292: wf_event.AddParameterToList('OrclNLSTerritory', territory, List);

Line 1289: wf_event.AddParameterToList('Description', description, List);

1285: -- the information passed.
1286:
1287: wf_event.AddParameterToList('User_Name', user_name, List);
1288: wf_event.AddParameterToList('DisplayName', display_name, List);
1289: wf_event.AddParameterToList('Description', description, List);
1290: wf_event.AddParameterToList('orclWorkFlowNotificationPref', notification_pref, List);
1291: wf_event.AddParameterToList('preferredLanguage', language, List);
1292: wf_event.AddParameterToList('OrclNLSTerritory', territory, List);
1293: wf_event.AddParameterToList('Mail', email_address, List);

Line 1290: wf_event.AddParameterToList('orclWorkFlowNotificationPref', notification_pref, List);

1286:
1287: wf_event.AddParameterToList('User_Name', user_name, List);
1288: wf_event.AddParameterToList('DisplayName', display_name, List);
1289: wf_event.AddParameterToList('Description', description, List);
1290: wf_event.AddParameterToList('orclWorkFlowNotificationPref', notification_pref, List);
1291: wf_event.AddParameterToList('preferredLanguage', language, List);
1292: wf_event.AddParameterToList('OrclNLSTerritory', territory, List);
1293: wf_event.AddParameterToList('Mail', email_address, List);
1294: wf_event.AddParameterToList('FacsimileTelephoneNumber', fax, List);

Line 1291: wf_event.AddParameterToList('preferredLanguage', language, List);

1287: wf_event.AddParameterToList('User_Name', user_name, List);
1288: wf_event.AddParameterToList('DisplayName', display_name, List);
1289: wf_event.AddParameterToList('Description', description, List);
1290: wf_event.AddParameterToList('orclWorkFlowNotificationPref', notification_pref, List);
1291: wf_event.AddParameterToList('preferredLanguage', language, List);
1292: wf_event.AddParameterToList('OrclNLSTerritory', territory, List);
1293: wf_event.AddParameterToList('Mail', email_address, List);
1294: wf_event.AddParameterToList('FacsimileTelephoneNumber', fax, List);
1295: wf_event.AddParameterToList('orclisEnabled', status, List);

Line 1292: wf_event.AddParameterToList('OrclNLSTerritory', territory, List);

1288: wf_event.AddParameterToList('DisplayName', display_name, List);
1289: wf_event.AddParameterToList('Description', description, List);
1290: wf_event.AddParameterToList('orclWorkFlowNotificationPref', notification_pref, List);
1291: wf_event.AddParameterToList('preferredLanguage', language, List);
1292: wf_event.AddParameterToList('OrclNLSTerritory', territory, List);
1293: wf_event.AddParameterToList('Mail', email_address, List);
1294: wf_event.AddParameterToList('FacsimileTelephoneNumber', fax, List);
1295: wf_event.AddParameterToList('orclisEnabled', status, List);
1296: wf_event.AddParameterToList('ExpirationDate', expiration_date, List);

Line 1293: wf_event.AddParameterToList('Mail', email_address, List);

1289: wf_event.AddParameterToList('Description', description, List);
1290: wf_event.AddParameterToList('orclWorkFlowNotificationPref', notification_pref, List);
1291: wf_event.AddParameterToList('preferredLanguage', language, List);
1292: wf_event.AddParameterToList('OrclNLSTerritory', territory, List);
1293: wf_event.AddParameterToList('Mail', email_address, List);
1294: wf_event.AddParameterToList('FacsimileTelephoneNumber', fax, List);
1295: wf_event.AddParameterToList('orclisEnabled', status, List);
1296: wf_event.AddParameterToList('ExpirationDate', expiration_date, List);
1297: wf_event.AddParameterToList('orclWFOrigSystem',system, List);

Line 1294: wf_event.AddParameterToList('FacsimileTelephoneNumber', fax, List);

1290: wf_event.AddParameterToList('orclWorkFlowNotificationPref', notification_pref, List);
1291: wf_event.AddParameterToList('preferredLanguage', language, List);
1292: wf_event.AddParameterToList('OrclNLSTerritory', territory, List);
1293: wf_event.AddParameterToList('Mail', email_address, List);
1294: wf_event.AddParameterToList('FacsimileTelephoneNumber', fax, List);
1295: wf_event.AddParameterToList('orclisEnabled', status, List);
1296: wf_event.AddParameterToList('ExpirationDate', expiration_date, List);
1297: wf_event.AddParameterToList('orclWFOrigSystem',system, List);
1298: wf_event.AddParameterToList('orclWFOrigSystemID',system_id, List);

Line 1295: wf_event.AddParameterToList('orclisEnabled', status, List);

1291: wf_event.AddParameterToList('preferredLanguage', language, List);
1292: wf_event.AddParameterToList('OrclNLSTerritory', territory, List);
1293: wf_event.AddParameterToList('Mail', email_address, List);
1294: wf_event.AddParameterToList('FacsimileTelephoneNumber', fax, List);
1295: wf_event.AddParameterToList('orclisEnabled', status, List);
1296: wf_event.AddParameterToList('ExpirationDate', expiration_date, List);
1297: wf_event.AddParameterToList('orclWFOrigSystem',system, List);
1298: wf_event.AddParameterToList('orclWFOrigSystemID',system_id, List);
1299:

Line 1296: wf_event.AddParameterToList('ExpirationDate', expiration_date, List);

1292: wf_event.AddParameterToList('OrclNLSTerritory', territory, List);
1293: wf_event.AddParameterToList('Mail', email_address, List);
1294: wf_event.AddParameterToList('FacsimileTelephoneNumber', fax, List);
1295: wf_event.AddParameterToList('orclisEnabled', status, List);
1296: wf_event.AddParameterToList('ExpirationDate', expiration_date, List);
1297: wf_event.AddParameterToList('orclWFOrigSystem',system, List);
1298: wf_event.AddParameterToList('orclWFOrigSystemID',system_id, List);
1299:
1300: IF (p_update = TRUE) then

Line 1297: wf_event.AddParameterToList('orclWFOrigSystem',system, List);

1293: wf_event.AddParameterToList('Mail', email_address, List);
1294: wf_event.AddParameterToList('FacsimileTelephoneNumber', fax, List);
1295: wf_event.AddParameterToList('orclisEnabled', status, List);
1296: wf_event.AddParameterToList('ExpirationDate', expiration_date, List);
1297: wf_event.AddParameterToList('orclWFOrigSystem',system, List);
1298: wf_event.AddParameterToList('orclWFOrigSystemID',system_id, List);
1299:
1300: IF (p_update = TRUE) then
1301: wf_event.AddParameterToList('UpdateOnly', 'TRUE', List);

Line 1298: wf_event.AddParameterToList('orclWFOrigSystemID',system_id, List);

1294: wf_event.AddParameterToList('FacsimileTelephoneNumber', fax, List);
1295: wf_event.AddParameterToList('orclisEnabled', status, List);
1296: wf_event.AddParameterToList('ExpirationDate', expiration_date, List);
1297: wf_event.AddParameterToList('orclWFOrigSystem',system, List);
1298: wf_event.AddParameterToList('orclWFOrigSystemID',system_id, List);
1299:
1300: IF (p_update = TRUE) then
1301: wf_event.AddParameterToList('UpdateOnly', 'TRUE', List);
1302: END IF;

Line 1301: wf_event.AddParameterToList('UpdateOnly', 'TRUE', List);

1297: wf_event.AddParameterToList('orclWFOrigSystem',system, List);
1298: wf_event.AddParameterToList('orclWFOrigSystemID',system_id, List);
1299:
1300: IF (p_update = TRUE) then
1301: wf_event.AddParameterToList('UpdateOnly', 'TRUE', List);
1302: END IF;
1303:
1304: IF (p_overwrite = TRUE) then
1305: wf_event.AddParameterToList('WFSYNCH_OVERWRITE', 'TRUE', List);

Line 1305: wf_event.AddParameterToList('WFSYNCH_OVERWRITE', 'TRUE', List);

1301: wf_event.AddParameterToList('UpdateOnly', 'TRUE', List);
1302: END IF;
1303:
1304: IF (p_overwrite = TRUE) then
1305: wf_event.AddParameterToList('WFSYNCH_OVERWRITE', 'TRUE', List);
1306: END IF;
1307:
1308: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1309: hz_utility_v2pub.DEBUG