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 834: -- Add the TCA registry Data as parameters to wf_event

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

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

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

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

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

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

835: -- This is needed as the WF API access the wf_event structure for
836: -- the information passed.
837:
838: wf_event.AddParameterToList('User_Name', user_name, List);
839: wf_event.AddParameterToList('DisplayName', display_name, List);
840: wf_event.AddParameterToList('Description', description, List);
841: wf_event.AddParameterToList('orclWorkFlowNotificationPref', notification_pref, List);
842: wf_event.AddParameterToList('preferredLanguage', language, List);
843: wf_event.AddParameterToList('OrclNLSTerritory', territory, List);

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

836: -- the information passed.
837:
838: wf_event.AddParameterToList('User_Name', user_name, List);
839: wf_event.AddParameterToList('DisplayName', display_name, List);
840: wf_event.AddParameterToList('Description', description, List);
841: wf_event.AddParameterToList('orclWorkFlowNotificationPref', notification_pref, List);
842: wf_event.AddParameterToList('preferredLanguage', language, List);
843: wf_event.AddParameterToList('OrclNLSTerritory', territory, List);
844: wf_event.AddParameterToList('Mail', email_address, List);

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

837:
838: wf_event.AddParameterToList('User_Name', user_name, List);
839: wf_event.AddParameterToList('DisplayName', display_name, List);
840: wf_event.AddParameterToList('Description', description, List);
841: wf_event.AddParameterToList('orclWorkFlowNotificationPref', notification_pref, List);
842: wf_event.AddParameterToList('preferredLanguage', language, List);
843: wf_event.AddParameterToList('OrclNLSTerritory', territory, List);
844: wf_event.AddParameterToList('Mail', email_address, List);
845: wf_event.AddParameterToList('FacsimileTelephoneNumber', fax, List);

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

838: wf_event.AddParameterToList('User_Name', user_name, List);
839: wf_event.AddParameterToList('DisplayName', display_name, List);
840: wf_event.AddParameterToList('Description', description, List);
841: wf_event.AddParameterToList('orclWorkFlowNotificationPref', notification_pref, List);
842: wf_event.AddParameterToList('preferredLanguage', language, List);
843: wf_event.AddParameterToList('OrclNLSTerritory', territory, List);
844: wf_event.AddParameterToList('Mail', email_address, List);
845: wf_event.AddParameterToList('FacsimileTelephoneNumber', fax, List);
846: wf_event.AddParameterToList('orclisEnabled', status, List);

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

839: wf_event.AddParameterToList('DisplayName', display_name, List);
840: wf_event.AddParameterToList('Description', description, List);
841: wf_event.AddParameterToList('orclWorkFlowNotificationPref', notification_pref, List);
842: wf_event.AddParameterToList('preferredLanguage', language, List);
843: wf_event.AddParameterToList('OrclNLSTerritory', territory, List);
844: wf_event.AddParameterToList('Mail', email_address, List);
845: wf_event.AddParameterToList('FacsimileTelephoneNumber', fax, List);
846: wf_event.AddParameterToList('orclisEnabled', status, List);
847: wf_event.AddParameterToList('ExpirationDate', expiration_date, List);

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

840: wf_event.AddParameterToList('Description', description, List);
841: wf_event.AddParameterToList('orclWorkFlowNotificationPref', notification_pref, List);
842: wf_event.AddParameterToList('preferredLanguage', language, List);
843: wf_event.AddParameterToList('OrclNLSTerritory', territory, List);
844: wf_event.AddParameterToList('Mail', email_address, List);
845: wf_event.AddParameterToList('FacsimileTelephoneNumber', fax, List);
846: wf_event.AddParameterToList('orclisEnabled', status, List);
847: wf_event.AddParameterToList('ExpirationDate', expiration_date, List);
848: wf_event.AddParameterToList('orclWFOrigSystem',system, List);

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

841: wf_event.AddParameterToList('orclWorkFlowNotificationPref', notification_pref, List);
842: wf_event.AddParameterToList('preferredLanguage', language, List);
843: wf_event.AddParameterToList('OrclNLSTerritory', territory, List);
844: wf_event.AddParameterToList('Mail', email_address, List);
845: wf_event.AddParameterToList('FacsimileTelephoneNumber', fax, List);
846: wf_event.AddParameterToList('orclisEnabled', status, List);
847: wf_event.AddParameterToList('ExpirationDate', expiration_date, List);
848: wf_event.AddParameterToList('orclWFOrigSystem',system, List);
849: wf_event.AddParameterToList('orclWFOrigSystemID',system_id, List);

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

842: wf_event.AddParameterToList('preferredLanguage', language, List);
843: wf_event.AddParameterToList('OrclNLSTerritory', territory, List);
844: wf_event.AddParameterToList('Mail', email_address, List);
845: wf_event.AddParameterToList('FacsimileTelephoneNumber', fax, List);
846: wf_event.AddParameterToList('orclisEnabled', status, List);
847: wf_event.AddParameterToList('ExpirationDate', expiration_date, List);
848: wf_event.AddParameterToList('orclWFOrigSystem',system, List);
849: wf_event.AddParameterToList('orclWFOrigSystemID',system_id, List);
850:

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

843: wf_event.AddParameterToList('OrclNLSTerritory', territory, List);
844: wf_event.AddParameterToList('Mail', email_address, List);
845: wf_event.AddParameterToList('FacsimileTelephoneNumber', fax, List);
846: wf_event.AddParameterToList('orclisEnabled', status, List);
847: wf_event.AddParameterToList('ExpirationDate', expiration_date, List);
848: wf_event.AddParameterToList('orclWFOrigSystem',system, List);
849: wf_event.AddParameterToList('orclWFOrigSystemID',system_id, List);
850:
851: if (p_update = TRUE) then

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

844: wf_event.AddParameterToList('Mail', email_address, List);
845: wf_event.AddParameterToList('FacsimileTelephoneNumber', fax, List);
846: wf_event.AddParameterToList('orclisEnabled', status, List);
847: wf_event.AddParameterToList('ExpirationDate', expiration_date, List);
848: wf_event.AddParameterToList('orclWFOrigSystem',system, List);
849: wf_event.AddParameterToList('orclWFOrigSystemID',system_id, List);
850:
851: if (p_update = TRUE) then
852: wf_event.AddParameterToList('UpdateOnly', 'TRUE' , List);

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

845: wf_event.AddParameterToList('FacsimileTelephoneNumber', fax, List);
846: wf_event.AddParameterToList('orclisEnabled', status, List);
847: wf_event.AddParameterToList('ExpirationDate', expiration_date, List);
848: wf_event.AddParameterToList('orclWFOrigSystem',system, List);
849: wf_event.AddParameterToList('orclWFOrigSystemID',system_id, List);
850:
851: if (p_update = TRUE) then
852: wf_event.AddParameterToList('UpdateOnly', 'TRUE' , List);
853: end if;

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

848: wf_event.AddParameterToList('orclWFOrigSystem',system, List);
849: wf_event.AddParameterToList('orclWFOrigSystemID',system_id, List);
850:
851: if (p_update = TRUE) then
852: wf_event.AddParameterToList('UpdateOnly', 'TRUE' , List);
853: end if;
854:
855: if (p_overwrite = TRUE) then
856: wf_event.AddParameterToList('WFSYNCH_OVERWRITE', 'TRUE', List);

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

852: wf_event.AddParameterToList('UpdateOnly', 'TRUE' , List);
853: end if;
854:
855: if (p_overwrite = TRUE) then
856: wf_event.AddParameterToList('WFSYNCH_OVERWRITE', 'TRUE', List);
857: end if;
858:
859: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
860: hz_utility_v2pub.DEBUG

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

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

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

1067: p_prefix =>l_debug_prefix,
1068: p_msg_level=>fnd_log.level_statement);
1069: END IF;
1070:
1071: -- Add the TCA registry Data as parameters to wf_event
1072: -- This is needed as the WF API access the wf_event structure for
1073: -- the information passed.
1074:
1075: wf_event.AddParameterToList('User_Name', l_tbl(i).user_name, List);

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

1068: p_msg_level=>fnd_log.level_statement);
1069: END IF;
1070:
1071: -- Add the TCA registry Data as parameters to wf_event
1072: -- This is needed as the WF API access the wf_event structure for
1073: -- the information passed.
1074:
1075: wf_event.AddParameterToList('User_Name', l_tbl(i).user_name, List);
1076: wf_event.AddParameterToList('DisplayName', l_tbl(i).display_name, List);

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

1071: -- Add the TCA registry Data as parameters to wf_event
1072: -- This is needed as the WF API access the wf_event structure for
1073: -- the information passed.
1074:
1075: wf_event.AddParameterToList('User_Name', l_tbl(i).user_name, List);
1076: wf_event.AddParameterToList('DisplayName', l_tbl(i).display_name, List);
1077: wf_event.AddParameterToList('Description', l_tbl(i).description, List);
1078: wf_event.AddParameterToList('orclWorkFlowNotificationPref', l_tbl(i).notification_pref, List);
1079: wf_event.AddParameterToList('preferredLanguage', l_tbl(i).language, List);

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

1072: -- This is needed as the WF API access the wf_event structure for
1073: -- the information passed.
1074:
1075: wf_event.AddParameterToList('User_Name', l_tbl(i).user_name, List);
1076: wf_event.AddParameterToList('DisplayName', l_tbl(i).display_name, List);
1077: wf_event.AddParameterToList('Description', l_tbl(i).description, List);
1078: wf_event.AddParameterToList('orclWorkFlowNotificationPref', l_tbl(i).notification_pref, List);
1079: wf_event.AddParameterToList('preferredLanguage', l_tbl(i).language, List);
1080: wf_event.AddParameterToList('OrclNLSTerritory', l_tbl(i).territory, List);

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

1073: -- the information passed.
1074:
1075: wf_event.AddParameterToList('User_Name', l_tbl(i).user_name, List);
1076: wf_event.AddParameterToList('DisplayName', l_tbl(i).display_name, List);
1077: wf_event.AddParameterToList('Description', l_tbl(i).description, List);
1078: wf_event.AddParameterToList('orclWorkFlowNotificationPref', l_tbl(i).notification_pref, List);
1079: wf_event.AddParameterToList('preferredLanguage', l_tbl(i).language, List);
1080: wf_event.AddParameterToList('OrclNLSTerritory', l_tbl(i).territory, List);
1081: wf_event.AddParameterToList('Mail', l_tbl(i).email_address, List);

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

1074:
1075: wf_event.AddParameterToList('User_Name', l_tbl(i).user_name, List);
1076: wf_event.AddParameterToList('DisplayName', l_tbl(i).display_name, List);
1077: wf_event.AddParameterToList('Description', l_tbl(i).description, List);
1078: wf_event.AddParameterToList('orclWorkFlowNotificationPref', l_tbl(i).notification_pref, List);
1079: wf_event.AddParameterToList('preferredLanguage', l_tbl(i).language, List);
1080: wf_event.AddParameterToList('OrclNLSTerritory', l_tbl(i).territory, List);
1081: wf_event.AddParameterToList('Mail', l_tbl(i).email_address, List);
1082: wf_event.AddParameterToList('FacsimileTelephoneNumber', l_tbl(i).fax, List);

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

1075: wf_event.AddParameterToList('User_Name', l_tbl(i).user_name, List);
1076: wf_event.AddParameterToList('DisplayName', l_tbl(i).display_name, List);
1077: wf_event.AddParameterToList('Description', l_tbl(i).description, List);
1078: wf_event.AddParameterToList('orclWorkFlowNotificationPref', l_tbl(i).notification_pref, List);
1079: wf_event.AddParameterToList('preferredLanguage', l_tbl(i).language, List);
1080: wf_event.AddParameterToList('OrclNLSTerritory', l_tbl(i).territory, List);
1081: wf_event.AddParameterToList('Mail', l_tbl(i).email_address, List);
1082: wf_event.AddParameterToList('FacsimileTelephoneNumber', l_tbl(i).fax, List);
1083: wf_event.AddParameterToList('orclisEnabled', l_tbl(i).status, List);

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

1076: wf_event.AddParameterToList('DisplayName', l_tbl(i).display_name, List);
1077: wf_event.AddParameterToList('Description', l_tbl(i).description, List);
1078: wf_event.AddParameterToList('orclWorkFlowNotificationPref', l_tbl(i).notification_pref, List);
1079: wf_event.AddParameterToList('preferredLanguage', l_tbl(i).language, List);
1080: wf_event.AddParameterToList('OrclNLSTerritory', l_tbl(i).territory, List);
1081: wf_event.AddParameterToList('Mail', l_tbl(i).email_address, List);
1082: wf_event.AddParameterToList('FacsimileTelephoneNumber', l_tbl(i).fax, List);
1083: wf_event.AddParameterToList('orclisEnabled', l_tbl(i).status, List);
1084: wf_event.AddParameterToList('StartDate', l_tbl(i).start_date, List);

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

1077: wf_event.AddParameterToList('Description', l_tbl(i).description, List);
1078: wf_event.AddParameterToList('orclWorkFlowNotificationPref', l_tbl(i).notification_pref, List);
1079: wf_event.AddParameterToList('preferredLanguage', l_tbl(i).language, List);
1080: wf_event.AddParameterToList('OrclNLSTerritory', l_tbl(i).territory, List);
1081: wf_event.AddParameterToList('Mail', l_tbl(i).email_address, List);
1082: wf_event.AddParameterToList('FacsimileTelephoneNumber', l_tbl(i).fax, List);
1083: wf_event.AddParameterToList('orclisEnabled', l_tbl(i).status, List);
1084: wf_event.AddParameterToList('StartDate', l_tbl(i).start_date, List);
1085: wf_event.AddParameterToList('ExpirationDate', l_tbl(i).expiration_date, List);

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

1078: wf_event.AddParameterToList('orclWorkFlowNotificationPref', l_tbl(i).notification_pref, List);
1079: wf_event.AddParameterToList('preferredLanguage', l_tbl(i).language, List);
1080: wf_event.AddParameterToList('OrclNLSTerritory', l_tbl(i).territory, List);
1081: wf_event.AddParameterToList('Mail', l_tbl(i).email_address, List);
1082: wf_event.AddParameterToList('FacsimileTelephoneNumber', l_tbl(i).fax, List);
1083: wf_event.AddParameterToList('orclisEnabled', l_tbl(i).status, List);
1084: wf_event.AddParameterToList('StartDate', l_tbl(i).start_date, List);
1085: wf_event.AddParameterToList('ExpirationDate', l_tbl(i).expiration_date, List);
1086: wf_event.AddParameterToList('orclWFOrigSystem',system, List);

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

1079: wf_event.AddParameterToList('preferredLanguage', l_tbl(i).language, List);
1080: wf_event.AddParameterToList('OrclNLSTerritory', l_tbl(i).territory, List);
1081: wf_event.AddParameterToList('Mail', l_tbl(i).email_address, List);
1082: wf_event.AddParameterToList('FacsimileTelephoneNumber', l_tbl(i).fax, List);
1083: wf_event.AddParameterToList('orclisEnabled', l_tbl(i).status, List);
1084: wf_event.AddParameterToList('StartDate', l_tbl(i).start_date, List);
1085: wf_event.AddParameterToList('ExpirationDate', l_tbl(i).expiration_date, List);
1086: wf_event.AddParameterToList('orclWFOrigSystem',system, List);
1087: wf_event.AddParameterToList('orclWFOrigSystemID',l_tbl(i).system_id, List);

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

1080: wf_event.AddParameterToList('OrclNLSTerritory', l_tbl(i).territory, List);
1081: wf_event.AddParameterToList('Mail', l_tbl(i).email_address, List);
1082: wf_event.AddParameterToList('FacsimileTelephoneNumber', l_tbl(i).fax, List);
1083: wf_event.AddParameterToList('orclisEnabled', l_tbl(i).status, List);
1084: wf_event.AddParameterToList('StartDate', l_tbl(i).start_date, List);
1085: wf_event.AddParameterToList('ExpirationDate', l_tbl(i).expiration_date, List);
1086: wf_event.AddParameterToList('orclWFOrigSystem',system, List);
1087: wf_event.AddParameterToList('orclWFOrigSystemID',l_tbl(i).system_id, List);
1088:

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

1081: wf_event.AddParameterToList('Mail', l_tbl(i).email_address, List);
1082: wf_event.AddParameterToList('FacsimileTelephoneNumber', l_tbl(i).fax, List);
1083: wf_event.AddParameterToList('orclisEnabled', l_tbl(i).status, List);
1084: wf_event.AddParameterToList('StartDate', l_tbl(i).start_date, List);
1085: wf_event.AddParameterToList('ExpirationDate', l_tbl(i).expiration_date, List);
1086: wf_event.AddParameterToList('orclWFOrigSystem',system, List);
1087: wf_event.AddParameterToList('orclWFOrigSystemID',l_tbl(i).system_id, List);
1088:
1089: IF (p_update = TRUE) then

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

1082: wf_event.AddParameterToList('FacsimileTelephoneNumber', l_tbl(i).fax, List);
1083: wf_event.AddParameterToList('orclisEnabled', l_tbl(i).status, List);
1084: wf_event.AddParameterToList('StartDate', l_tbl(i).start_date, List);
1085: wf_event.AddParameterToList('ExpirationDate', l_tbl(i).expiration_date, List);
1086: wf_event.AddParameterToList('orclWFOrigSystem',system, List);
1087: wf_event.AddParameterToList('orclWFOrigSystemID',l_tbl(i).system_id, List);
1088:
1089: IF (p_update = TRUE) then
1090: wf_event.AddParameterToList('UpdateOnly', 'TRUE', List);

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

1083: wf_event.AddParameterToList('orclisEnabled', l_tbl(i).status, List);
1084: wf_event.AddParameterToList('StartDate', l_tbl(i).start_date, List);
1085: wf_event.AddParameterToList('ExpirationDate', l_tbl(i).expiration_date, List);
1086: wf_event.AddParameterToList('orclWFOrigSystem',system, List);
1087: wf_event.AddParameterToList('orclWFOrigSystemID',l_tbl(i).system_id, List);
1088:
1089: IF (p_update = TRUE) then
1090: wf_event.AddParameterToList('UpdateOnly', 'TRUE', List);
1091: END IF;

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

1086: wf_event.AddParameterToList('orclWFOrigSystem',system, List);
1087: wf_event.AddParameterToList('orclWFOrigSystemID',l_tbl(i).system_id, List);
1088:
1089: IF (p_update = TRUE) then
1090: wf_event.AddParameterToList('UpdateOnly', 'TRUE', List);
1091: END IF;
1092:
1093: IF (p_overwrite = TRUE) THEN
1094: wf_event.AddParameterToList('WFSYNCH_OVERWRITE', 'TRUE', List);

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

1090: wf_event.AddParameterToList('UpdateOnly', 'TRUE', List);
1091: END IF;
1092:
1093: IF (p_overwrite = TRUE) THEN
1094: wf_event.AddParameterToList('WFSYNCH_OVERWRITE', 'TRUE', List);
1095: END IF;
1096:
1097: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1098: hz_utility_v2pub.DEBUG

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

1304: p_prefix =>l_debug_prefix,
1305: p_msg_level=>fnd_log.level_statement);
1306: END IF;
1307:
1308: -- Add the TCA registry Data as parameters to wf_event
1309: -- This is needed as the WF API access the wf_event structure for
1310: -- the information passed.
1311:
1312: wf_event.AddParameterToList('User_Name', user_name, List);

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

1305: p_msg_level=>fnd_log.level_statement);
1306: END IF;
1307:
1308: -- Add the TCA registry Data as parameters to wf_event
1309: -- This is needed as the WF API access the wf_event structure for
1310: -- the information passed.
1311:
1312: wf_event.AddParameterToList('User_Name', user_name, List);
1313: wf_event.AddParameterToList('DisplayName', display_name, List);

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

1308: -- Add the TCA registry Data as parameters to wf_event
1309: -- This is needed as the WF API access the wf_event structure for
1310: -- the information passed.
1311:
1312: wf_event.AddParameterToList('User_Name', user_name, List);
1313: wf_event.AddParameterToList('DisplayName', display_name, List);
1314: wf_event.AddParameterToList('Description', description, List);
1315: wf_event.AddParameterToList('orclWorkFlowNotificationPref', notification_pref, List);
1316: wf_event.AddParameterToList('preferredLanguage', language, List);

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

1309: -- This is needed as the WF API access the wf_event structure for
1310: -- the information passed.
1311:
1312: wf_event.AddParameterToList('User_Name', user_name, List);
1313: wf_event.AddParameterToList('DisplayName', display_name, List);
1314: wf_event.AddParameterToList('Description', description, List);
1315: wf_event.AddParameterToList('orclWorkFlowNotificationPref', notification_pref, List);
1316: wf_event.AddParameterToList('preferredLanguage', language, List);
1317: wf_event.AddParameterToList('OrclNLSTerritory', territory, List);

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

1310: -- the information passed.
1311:
1312: wf_event.AddParameterToList('User_Name', user_name, List);
1313: wf_event.AddParameterToList('DisplayName', display_name, List);
1314: wf_event.AddParameterToList('Description', description, List);
1315: wf_event.AddParameterToList('orclWorkFlowNotificationPref', notification_pref, List);
1316: wf_event.AddParameterToList('preferredLanguage', language, List);
1317: wf_event.AddParameterToList('OrclNLSTerritory', territory, List);
1318: wf_event.AddParameterToList('Mail', email_address, List);

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

1311:
1312: wf_event.AddParameterToList('User_Name', user_name, List);
1313: wf_event.AddParameterToList('DisplayName', display_name, List);
1314: wf_event.AddParameterToList('Description', description, List);
1315: wf_event.AddParameterToList('orclWorkFlowNotificationPref', notification_pref, List);
1316: wf_event.AddParameterToList('preferredLanguage', language, List);
1317: wf_event.AddParameterToList('OrclNLSTerritory', territory, List);
1318: wf_event.AddParameterToList('Mail', email_address, List);
1319: wf_event.AddParameterToList('FacsimileTelephoneNumber', fax, List);

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

1312: wf_event.AddParameterToList('User_Name', user_name, List);
1313: wf_event.AddParameterToList('DisplayName', display_name, List);
1314: wf_event.AddParameterToList('Description', description, List);
1315: wf_event.AddParameterToList('orclWorkFlowNotificationPref', notification_pref, List);
1316: wf_event.AddParameterToList('preferredLanguage', language, List);
1317: wf_event.AddParameterToList('OrclNLSTerritory', territory, List);
1318: wf_event.AddParameterToList('Mail', email_address, List);
1319: wf_event.AddParameterToList('FacsimileTelephoneNumber', fax, List);
1320: wf_event.AddParameterToList('orclisEnabled', status, List);

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

1313: wf_event.AddParameterToList('DisplayName', display_name, List);
1314: wf_event.AddParameterToList('Description', description, List);
1315: wf_event.AddParameterToList('orclWorkFlowNotificationPref', notification_pref, List);
1316: wf_event.AddParameterToList('preferredLanguage', language, List);
1317: wf_event.AddParameterToList('OrclNLSTerritory', territory, List);
1318: wf_event.AddParameterToList('Mail', email_address, List);
1319: wf_event.AddParameterToList('FacsimileTelephoneNumber', fax, List);
1320: wf_event.AddParameterToList('orclisEnabled', status, List);
1321: wf_event.AddParameterToList('ExpirationDate', expiration_date, List);

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

1314: wf_event.AddParameterToList('Description', description, List);
1315: wf_event.AddParameterToList('orclWorkFlowNotificationPref', notification_pref, List);
1316: wf_event.AddParameterToList('preferredLanguage', language, List);
1317: wf_event.AddParameterToList('OrclNLSTerritory', territory, List);
1318: wf_event.AddParameterToList('Mail', email_address, List);
1319: wf_event.AddParameterToList('FacsimileTelephoneNumber', fax, List);
1320: wf_event.AddParameterToList('orclisEnabled', status, List);
1321: wf_event.AddParameterToList('ExpirationDate', expiration_date, List);
1322: wf_event.AddParameterToList('orclWFOrigSystem',system, List);

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

1315: wf_event.AddParameterToList('orclWorkFlowNotificationPref', notification_pref, List);
1316: wf_event.AddParameterToList('preferredLanguage', language, List);
1317: wf_event.AddParameterToList('OrclNLSTerritory', territory, List);
1318: wf_event.AddParameterToList('Mail', email_address, List);
1319: wf_event.AddParameterToList('FacsimileTelephoneNumber', fax, List);
1320: wf_event.AddParameterToList('orclisEnabled', status, List);
1321: wf_event.AddParameterToList('ExpirationDate', expiration_date, List);
1322: wf_event.AddParameterToList('orclWFOrigSystem',system, List);
1323: wf_event.AddParameterToList('orclWFOrigSystemID',system_id, List);

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

1316: wf_event.AddParameterToList('preferredLanguage', language, List);
1317: wf_event.AddParameterToList('OrclNLSTerritory', territory, List);
1318: wf_event.AddParameterToList('Mail', email_address, List);
1319: wf_event.AddParameterToList('FacsimileTelephoneNumber', fax, List);
1320: wf_event.AddParameterToList('orclisEnabled', status, List);
1321: wf_event.AddParameterToList('ExpirationDate', expiration_date, List);
1322: wf_event.AddParameterToList('orclWFOrigSystem',system, List);
1323: wf_event.AddParameterToList('orclWFOrigSystemID',system_id, List);
1324:

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

1317: wf_event.AddParameterToList('OrclNLSTerritory', territory, List);
1318: wf_event.AddParameterToList('Mail', email_address, List);
1319: wf_event.AddParameterToList('FacsimileTelephoneNumber', fax, List);
1320: wf_event.AddParameterToList('orclisEnabled', status, List);
1321: wf_event.AddParameterToList('ExpirationDate', expiration_date, List);
1322: wf_event.AddParameterToList('orclWFOrigSystem',system, List);
1323: wf_event.AddParameterToList('orclWFOrigSystemID',system_id, List);
1324:
1325: IF (p_update = TRUE) then

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

1318: wf_event.AddParameterToList('Mail', email_address, List);
1319: wf_event.AddParameterToList('FacsimileTelephoneNumber', fax, List);
1320: wf_event.AddParameterToList('orclisEnabled', status, List);
1321: wf_event.AddParameterToList('ExpirationDate', expiration_date, List);
1322: wf_event.AddParameterToList('orclWFOrigSystem',system, List);
1323: wf_event.AddParameterToList('orclWFOrigSystemID',system_id, List);
1324:
1325: IF (p_update = TRUE) then
1326: wf_event.AddParameterToList('UpdateOnly', 'TRUE', List);

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

1319: wf_event.AddParameterToList('FacsimileTelephoneNumber', fax, List);
1320: wf_event.AddParameterToList('orclisEnabled', status, List);
1321: wf_event.AddParameterToList('ExpirationDate', expiration_date, List);
1322: wf_event.AddParameterToList('orclWFOrigSystem',system, List);
1323: wf_event.AddParameterToList('orclWFOrigSystemID',system_id, List);
1324:
1325: IF (p_update = TRUE) then
1326: wf_event.AddParameterToList('UpdateOnly', 'TRUE', List);
1327: END IF;

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

1322: wf_event.AddParameterToList('orclWFOrigSystem',system, List);
1323: wf_event.AddParameterToList('orclWFOrigSystemID',system_id, List);
1324:
1325: IF (p_update = TRUE) then
1326: wf_event.AddParameterToList('UpdateOnly', 'TRUE', List);
1327: END IF;
1328:
1329: IF (p_overwrite = TRUE) then
1330: wf_event.AddParameterToList('WFSYNCH_OVERWRITE', 'TRUE', List);

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

1326: wf_event.AddParameterToList('UpdateOnly', 'TRUE', List);
1327: END IF;
1328:
1329: IF (p_overwrite = TRUE) then
1330: wf_event.AddParameterToList('WFSYNCH_OVERWRITE', 'TRUE', List);
1331: END IF;
1332:
1333: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1334: hz_utility_v2pub.DEBUG