[Home] [Help]
51: IF FND_API.to_Boolean( p_init_msg_list ) THEN
52: FND_MSG_PUB.initialize;
53: END IF;
54: IF FND_GLOBAL.User_Id IS NULL THEN
55: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
56: RAISE FND_API.G_EXC_ERROR;
57: END IF;
58:
59: if ( (p_Object_Type = 'PROCESS_VARIANT_ADD') AND (p_Transaction_Type = 'DELETE_EXIST') ) then
151: G_USER_ID,
152: sysdate,
153: G_USER_ID,
154: G_LOGIN_ID,
155: decode(p_Object_Type,'PROCESS',decode(p_Old_pk3, 'IamNull', null, amw_utility_pvt.get_process_name(p_Old_pk3)),null),
156: decode(p_Object_Type,'PROCESS',decode(p_New_pk3, 'IamNull', null, amw_utility_pvt.get_process_name(p_New_pk3)),null)
157: from FND_LANGUAGES L
158: where L.INSTALLED_FLAG in ('I', 'B')
159: and not exists
152: sysdate,
153: G_USER_ID,
154: G_LOGIN_ID,
155: decode(p_Object_Type,'PROCESS',decode(p_Old_pk3, 'IamNull', null, amw_utility_pvt.get_process_name(p_Old_pk3)),null),
156: decode(p_Object_Type,'PROCESS',decode(p_New_pk3, 'IamNull', null, amw_utility_pvt.get_process_name(p_New_pk3)),null)
157: from FND_LANGUAGES L
158: where L.INSTALLED_FLAG in ('I', 'B')
159: and not exists
160: (select NULL
208: fnd_message.set_token('STD', l_sp_disp_name);
209: fnd_message.set_token('NSTD', l_nsp_disp_name);
210: l_body := fnd_message.get;
211:
212: AMW_Utility_PVT.send_wf_standalone_message( p_subject => l_header,
213: p_body => l_body,
214: p_send_to_person_id => l_person_id,
215: x_notif_id => l_notif_id,
216: x_return_status => l_ret_status);
264: IF FND_API.to_Boolean( p_init_msg_list ) THEN
265: FND_MSG_PUB.initialize;
266: END IF;
267: IF FND_GLOBAL.User_Id IS NULL THEN
268: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
269: RAISE FND_API.G_EXC_ERROR;
270: END IF;
271:
272: if p_existing_ex_id <> 0 then