30: -- when FND User Name Changes
31: FUNCTION Update_User_Name
32: (
33: p_subscription_guid IN RAW,
34: p_event IN OUT NOCOPY WF_EVENT_T
35: ) RETURN VARCHAR2
36: IS
37: l_api_name CONSTANT VARCHAR2(30) := 'Update_User_Name';
38: l_return_status VARCHAR2(1);
139: 'User Name Update Failed with Error: ' || l_error_string
140: );
141: END IF;
142:
143: -- Set the Context for the WF Event
144: WF_CORE.Context
145: (
146: g_pkg_name,
147: l_api_name,
148: p_event.getEventName(),
149: p_subscription_guid
150: );
151:
152: -- Set the Error Info for the WF Event
153: WF_EVENT.setErrorInfo( p_event, 'ERROR' );
154:
155: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
156: FND_LOG.string
149: p_subscription_guid
150: );
151:
152: -- Set the Error Info for the WF Event
153: WF_EVENT.setErrorInfo( p_event, 'ERROR' );
154:
155: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
156: FND_LOG.string
157: (
160: 'Exiting Procedure: Error'
161: );
162: END IF;
163:
164: -- Return value expected by WF Event in case of error
165: RETURN 'ERROR';
166:
167: END IF;
168:
174: 'Exiting Procedure: Success'
175: );
176: END IF;
177:
178: -- Return value expected by WF Event in case of success
179: RETURN 'SUCCESS';
180:
181: EXCEPTION
182: WHEN OTHERS THEN
196: 'User Name Update Failed with Error: ' || SQLERRM
197: );
198: END IF;
199:
200: -- Set the Context for the WF Event
201: WF_CORE.Context
202: (
203: g_pkg_name,
204: l_api_name,
205: p_event.getEventName(),
206: p_subscription_guid
207: );
208:
209: -- Set the Error Info for the WF Event
210: WF_EVENT.setErrorInfo( p_event, 'ERROR' );
211:
212: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
213: FND_LOG.string
206: p_subscription_guid
207: );
208:
209: -- Set the Error Info for the WF Event
210: WF_EVENT.setErrorInfo( p_event, 'ERROR' );
211:
212: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
213: FND_LOG.string
214: (
217: 'Exiting Procedure: Error'
218: );
219: END IF;
220:
221: -- Return value expected by WF Event in case of error
222: RETURN 'ERROR';
223:
224: END Update_User_Name;
225: