DBA Data[Home] [Help]

APPS.AP_WEB_PROXY_ASSIGN_PKG dependencies on FND_MESSAGE

Line 262: FND_MESSAGE.SET_NAME ('SQLAP', 'OIE_PROXY_NOTIF_SUB');

258: where fu.employee_id = hre.employee_id
259: and user_name = p_assignor_name;
260:
261: -- Fetch the message used as the confirmation message subject
262: FND_MESSAGE.SET_NAME ('SQLAP', 'OIE_PROXY_NOTIF_SUB');
263: FND_MESSAGE.SET_TOKEN ('ASSIGNOR_NAME', l_full_name);
264: l_subject := FND_MESSAGE.get;
265:
266: -- Fetch the message used as the confirmation message body

Line 263: FND_MESSAGE.SET_TOKEN ('ASSIGNOR_NAME', l_full_name);

259: and user_name = p_assignor_name;
260:
261: -- Fetch the message used as the confirmation message subject
262: FND_MESSAGE.SET_NAME ('SQLAP', 'OIE_PROXY_NOTIF_SUB');
263: FND_MESSAGE.SET_TOKEN ('ASSIGNOR_NAME', l_full_name);
264: l_subject := FND_MESSAGE.get;
265:
266: -- Fetch the message used as the confirmation message body
267: -- if end date is null which means forever get a different message.

Line 264: l_subject := FND_MESSAGE.get;

260:
261: -- Fetch the message used as the confirmation message subject
262: FND_MESSAGE.SET_NAME ('SQLAP', 'OIE_PROXY_NOTIF_SUB');
263: FND_MESSAGE.SET_TOKEN ('ASSIGNOR_NAME', l_full_name);
264: l_subject := FND_MESSAGE.get;
265:
266: -- Fetch the message used as the confirmation message body
267: -- if end date is null which means forever get a different message.
268: if (p_end_date is not null) then

Line 269: FND_MESSAGE.SET_NAME ('SQLAP', 'OIE_PROXY_NOTIF_BODY');

265:
266: -- Fetch the message used as the confirmation message body
267: -- if end date is null which means forever get a different message.
268: if (p_end_date is not null) then
269: FND_MESSAGE.SET_NAME ('SQLAP', 'OIE_PROXY_NOTIF_BODY');
270: FND_MESSAGE.SET_TOKEN ('END_DATE', p_end_Date);
271: else
272: FND_MESSAGE.SET_NAME ('SQLAP', 'OIE_PROXY_NOEND_DATE');
273: end if;

Line 270: FND_MESSAGE.SET_TOKEN ('END_DATE', p_end_Date);

266: -- Fetch the message used as the confirmation message body
267: -- if end date is null which means forever get a different message.
268: if (p_end_date is not null) then
269: FND_MESSAGE.SET_NAME ('SQLAP', 'OIE_PROXY_NOTIF_BODY');
270: FND_MESSAGE.SET_TOKEN ('END_DATE', p_end_Date);
271: else
272: FND_MESSAGE.SET_NAME ('SQLAP', 'OIE_PROXY_NOEND_DATE');
273: end if;
274: FND_MESSAGE.SET_TOKEN ('RESP_NAME', p_resp_name);

Line 272: FND_MESSAGE.SET_NAME ('SQLAP', 'OIE_PROXY_NOEND_DATE');

268: if (p_end_date is not null) then
269: FND_MESSAGE.SET_NAME ('SQLAP', 'OIE_PROXY_NOTIF_BODY');
270: FND_MESSAGE.SET_TOKEN ('END_DATE', p_end_Date);
271: else
272: FND_MESSAGE.SET_NAME ('SQLAP', 'OIE_PROXY_NOEND_DATE');
273: end if;
274: FND_MESSAGE.SET_TOKEN ('RESP_NAME', p_resp_name);
275: FND_MESSAGE.SET_TOKEN ('START_DATE', p_start_date);
276: l_body := FND_MESSAGE.get;

Line 274: FND_MESSAGE.SET_TOKEN ('RESP_NAME', p_resp_name);

270: FND_MESSAGE.SET_TOKEN ('END_DATE', p_end_Date);
271: else
272: FND_MESSAGE.SET_NAME ('SQLAP', 'OIE_PROXY_NOEND_DATE');
273: end if;
274: FND_MESSAGE.SET_TOKEN ('RESP_NAME', p_resp_name);
275: FND_MESSAGE.SET_TOKEN ('START_DATE', p_start_date);
276: l_body := FND_MESSAGE.get;
277:
278: -- Create a process using the WF definition for sending AP emails(APWPROXY)

Line 275: FND_MESSAGE.SET_TOKEN ('START_DATE', p_start_date);

271: else
272: FND_MESSAGE.SET_NAME ('SQLAP', 'OIE_PROXY_NOEND_DATE');
273: end if;
274: FND_MESSAGE.SET_TOKEN ('RESP_NAME', p_resp_name);
275: FND_MESSAGE.SET_TOKEN ('START_DATE', p_start_date);
276: l_body := FND_MESSAGE.get;
277:
278: -- Create a process using the WF definition for sending AP emails(APWPROXY)
279: iText := 0;

Line 276: l_body := FND_MESSAGE.get;

272: FND_MESSAGE.SET_NAME ('SQLAP', 'OIE_PROXY_NOEND_DATE');
273: end if;
274: FND_MESSAGE.SET_TOKEN ('RESP_NAME', p_resp_name);
275: FND_MESSAGE.SET_TOKEN ('START_DATE', p_start_date);
276: l_body := FND_MESSAGE.get;
277:
278: -- Create a process using the WF definition for sending AP emails(APWPROXY)
279: iText := 0;
280: WF_ENGINE.CREATEPROCESS('APWPROXY', l_request_id, 'AP_WEB_PROXY_PROCESS');