APPS.AMW_PROCCERT_REMINDER_PKG dependencies on FND_API

Line 340: x_return_status := FND_API.G_RET_STS_SUCCESS;

336: update amw_certification_b
337: set LAST_REMINDER_DATE= sysdate
338: where CERTIFICATION_ID = p_certificaion_id;
339:
340: x_return_status := FND_API.G_RET_STS_SUCCESS;
341:
342: fnd_file.put_line(fnd_file.LOG,
343: 'Updates LAST_REMINDER_DATE for '||p_certificaion_id);
344: EXCEPTION

Line 389: x_return_status := FND_API.G_RET_STS_SUCCESS;

385: fnd_file.put_line(fnd_file.LOG, 'process_owner_id:'||to_char(p_process_owner_id));
386: fnd_file.put_line(fnd_file.LOG, 'organization_id:'||p_organization_id);
387: fnd_file.put_line(fnd_file.LOG, 'process_id:'||p_process_id);
388:
389: x_return_status := FND_API.G_RET_STS_SUCCESS;
390:
391: open c_certification(p_certification_id);
392: fetch c_certification into l_cert_name;
393: close c_certification;

Line 405: p_encoded => fnd_api.g_false);

401: FND_MESSAGE.set_token('CERTIFICATION_NAME', l_cert_name, TRUE);
402: FND_MSG_PUB.add;
403: l_subject := fnd_msg_pub.get(
404: p_msg_index => fnd_msg_pub.G_LAST,
405: p_encoded => fnd_api.g_false);
406:
407:
408:
409: WF_DIRECTORY.getrolename

Line 417: x_return_status := FND_API.G_RET_STS_ERROR;

413: p_display_name => l_display_role_name );
414:
415:
416: IF l_to_role_name IS NULL THEN
417: x_return_status := FND_API.G_RET_STS_ERROR;
418: FND_MESSAGE.set_name('AMW','AMW_APPR_INVALID_ROLE');
419: FND_MSG_PUB.ADD;
420: fnd_file.put_line(fnd_file.LOG, 'to_role is null');
421: ELSE

Line 474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

470: EXCEPTION
471: WHEN OTHERS THEN
472: fnd_file.put_line(fnd_file.LOG,
473: 'unexpected error in send_reminder_to_owner: '||sqlerrm);
474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
475: END send_reminder_to_owner;
476:
477: -------------------------- ********************************************** ---------------------
478: -- Sends reminder to all Process Owners in Procecss Hierarchy based on a selction in UI by user

Line 555: x_return_status := FND_API.G_RET_STS_SUCCESS;

551:
552: begin
553: fnd_file.put_line(fnd_file.LOG, 'Getting Data from Cursor Get_Proc_Owner_To_Notify ');
554:
555: x_return_status := FND_API.G_RET_STS_SUCCESS;
556:
557: g_proc_owner_tbl.delete;
558: g_ownerlist_tbl.delete; /* hyuen bug 5098058 */
559:

Line 610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

606: EXCEPTION
607: WHEN OTHERS THEN
608: fnd_file.put_line(fnd_file.LOG,
609: 'unexpected error in send_reminder_to_owner: '||sqlerrm);
610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
611: END send_reminder_selected_procs;
612:
613:
614: END AMW_PROCCERT_REMINDER_PKG ;