DBA Data[Home] [Help]

APPS.PN_LEASE_PUB dependencies on FND_MESSAGE

Line 79: fnd_message.set_name ('MO', 'MO_ORG_INVALID');

75: -- ------dbms_output.put_line('Login Id:'||g_login_id);
76: IF NVL (mo_global.check_valid_org (g_org_id), 'N') <> 'Y'
77: THEN
78:
79: fnd_message.set_name ('MO', 'MO_ORG_INVALID');
80: fnd_msg_pub.ADD;
81: RAISE fnd_api.g_exc_error;
82: END IF;
83:

Line 368: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');

364: --RAISE;
365: WHEN OTHERS
366: THEN
367: --ROLLBACK TO update_lease_pub;
368: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
369: fnd_message.set_token ('P_TEXT', SQLERRM);
370: fnd_msg_pub.ADD;
371: x_return_status := fnd_api.g_ret_sts_error;
372: --RAISE;

Line 369: fnd_message.set_token ('P_TEXT', SQLERRM);

365: WHEN OTHERS
366: THEN
367: --ROLLBACK TO update_lease_pub;
368: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
369: fnd_message.set_token ('P_TEXT', SQLERRM);
370: fnd_msg_pub.ADD;
371: x_return_status := fnd_api.g_ret_sts_error;
372: --RAISE;
373: END create_lease;

Line 456: fnd_message.set_name ('PN', 'PN_API_ALL_NULL_PARAMETER');

452:
453: EXCEPTION
454: WHEN NO_DATA_FOUND THEN
455: p_lease_rec.lease_id := NULL;
456: fnd_message.set_name ('PN', 'PN_API_ALL_NULL_PARAMETER');
457: fnd_message.set_token ('API_NAME', l_api_name_full);
458: fnd_message.set_token ('NULL_PARAM', 'LEASE NAME:NULL');
459: fnd_msg_pub.ADD;
460: RAISE fnd_api.g_exc_error;

Line 457: fnd_message.set_token ('API_NAME', l_api_name_full);

453: EXCEPTION
454: WHEN NO_DATA_FOUND THEN
455: p_lease_rec.lease_id := NULL;
456: fnd_message.set_name ('PN', 'PN_API_ALL_NULL_PARAMETER');
457: fnd_message.set_token ('API_NAME', l_api_name_full);
458: fnd_message.set_token ('NULL_PARAM', 'LEASE NAME:NULL');
459: fnd_msg_pub.ADD;
460: RAISE fnd_api.g_exc_error;
461: WHEN TOO_MANY_ROWS THEN

Line 458: fnd_message.set_token ('NULL_PARAM', 'LEASE NAME:NULL');

454: WHEN NO_DATA_FOUND THEN
455: p_lease_rec.lease_id := NULL;
456: fnd_message.set_name ('PN', 'PN_API_ALL_NULL_PARAMETER');
457: fnd_message.set_token ('API_NAME', l_api_name_full);
458: fnd_message.set_token ('NULL_PARAM', 'LEASE NAME:NULL');
459: fnd_msg_pub.ADD;
460: RAISE fnd_api.g_exc_error;
461: WHEN TOO_MANY_ROWS THEN
462: fnd_message.set_name ('PN', 'PN_API_ALL_NULL_PARAMETER');

Line 462: fnd_message.set_name ('PN', 'PN_API_ALL_NULL_PARAMETER');

458: fnd_message.set_token ('NULL_PARAM', 'LEASE NAME:NULL');
459: fnd_msg_pub.ADD;
460: RAISE fnd_api.g_exc_error;
461: WHEN TOO_MANY_ROWS THEN
462: fnd_message.set_name ('PN', 'PN_API_ALL_NULL_PARAMETER');
463: fnd_message.set_token ('API_NAME', l_api_name_full);
464: fnd_message.set_token ('NULL_PARAM', 'LEASE NAME:NOT UNIQUE');
465: fnd_msg_pub.ADD;
466: RAISE fnd_api.g_exc_error;

Line 463: fnd_message.set_token ('API_NAME', l_api_name_full);

459: fnd_msg_pub.ADD;
460: RAISE fnd_api.g_exc_error;
461: WHEN TOO_MANY_ROWS THEN
462: fnd_message.set_name ('PN', 'PN_API_ALL_NULL_PARAMETER');
463: fnd_message.set_token ('API_NAME', l_api_name_full);
464: fnd_message.set_token ('NULL_PARAM', 'LEASE NAME:NOT UNIQUE');
465: fnd_msg_pub.ADD;
466: RAISE fnd_api.g_exc_error;
467: END;

Line 464: fnd_message.set_token ('NULL_PARAM', 'LEASE NAME:NOT UNIQUE');

460: RAISE fnd_api.g_exc_error;
461: WHEN TOO_MANY_ROWS THEN
462: fnd_message.set_name ('PN', 'PN_API_ALL_NULL_PARAMETER');
463: fnd_message.set_token ('API_NAME', l_api_name_full);
464: fnd_message.set_token ('NULL_PARAM', 'LEASE NAME:NOT UNIQUE');
465: fnd_msg_pub.ADD;
466: RAISE fnd_api.g_exc_error;
467: END;
468: ELSIF(p_lease_rec.lease_num IS NOT NULL AND p_lease_rec.lease_num <> pn_lease_utils.g_pn_miss_char) THEN

Line 478: fnd_message.set_name ('PN', 'PN_API_ALL_NULL_PARAMETER');

474: AND org_id = g_org_id;
475: EXCEPTION
476: WHEN NO_DATA_FOUND THEN
477: p_lease_rec.lease_id := NULL;
478: fnd_message.set_name ('PN', 'PN_API_ALL_NULL_PARAMETER');
479: fnd_message.set_token ('API_NAME', l_api_name_full);
480: fnd_message.set_token ('NULL_PARAM', 'LEASE NAME:NULL');
481: fnd_msg_pub.ADD;
482: RAISE fnd_api.g_exc_error;

Line 479: fnd_message.set_token ('API_NAME', l_api_name_full);

475: EXCEPTION
476: WHEN NO_DATA_FOUND THEN
477: p_lease_rec.lease_id := NULL;
478: fnd_message.set_name ('PN', 'PN_API_ALL_NULL_PARAMETER');
479: fnd_message.set_token ('API_NAME', l_api_name_full);
480: fnd_message.set_token ('NULL_PARAM', 'LEASE NAME:NULL');
481: fnd_msg_pub.ADD;
482: RAISE fnd_api.g_exc_error;
483: END;

Line 480: fnd_message.set_token ('NULL_PARAM', 'LEASE NAME:NULL');

476: WHEN NO_DATA_FOUND THEN
477: p_lease_rec.lease_id := NULL;
478: fnd_message.set_name ('PN', 'PN_API_ALL_NULL_PARAMETER');
479: fnd_message.set_token ('API_NAME', l_api_name_full);
480: fnd_message.set_token ('NULL_PARAM', 'LEASE NAME:NULL');
481: fnd_msg_pub.ADD;
482: RAISE fnd_api.g_exc_error;
483: END;
484: END IF;

Line 549: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');

545: --RAISE;
546: WHEN OTHERS
547: THEN
548: --ROLLBACK TO update_lease_pub;
549: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
550: fnd_message.set_token ('P_TEXT', SQLERRM);
551: fnd_msg_pub.ADD;
552: x_return_status := fnd_api.g_ret_sts_error;
553: --RAISE;

Line 550: fnd_message.set_token ('P_TEXT', SQLERRM);

546: WHEN OTHERS
547: THEN
548: --ROLLBACK TO update_lease_pub;
549: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
550: fnd_message.set_token ('P_TEXT', SQLERRM);
551: fnd_msg_pub.ADD;
552: x_return_status := fnd_api.g_ret_sts_error;
553: --RAISE;
554: END update_lease;

Line 657: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');

653: , p_count => x_msg_count
654: , p_data => x_msg_data
655: );
656:
657: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
658: fnd_message.set_token ('P_TEXT', SQLERRM);
659: fnd_msg_pub.ADD;
660: --RAISE;
661: END create_terms;

Line 658: fnd_message.set_token ('P_TEXT', SQLERRM);

654: , p_data => x_msg_data
655: );
656:
657: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
658: fnd_message.set_token ('P_TEXT', SQLERRM);
659: fnd_msg_pub.ADD;
660: --RAISE;
661: END create_terms;
662:

Line 764: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');

760: , p_count => x_msg_count
761: , p_data => x_msg_data
762: );
763:
764: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
765: fnd_message.set_token ('P_TEXT', SQLERRM);
766: fnd_msg_pub.ADD;
767: --RAISE;
768: ------dbms_output.put_line (' EXCEPTION:IN Public :update_lease'||SQLERRM);

Line 765: fnd_message.set_token ('P_TEXT', SQLERRM);

761: , p_data => x_msg_data
762: );
763:
764: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
765: fnd_message.set_token ('P_TEXT', SQLERRM);
766: fnd_msg_pub.ADD;
767: --RAISE;
768: ------dbms_output.put_line (' EXCEPTION:IN Public :update_lease'||SQLERRM);
769: END update_terms;

Line 831: fnd_message.set_name ('MO', 'MO_ORG_INVALID');

827: -- Check if passed org_id is valid or not
828: IF NVL (mo_global.check_valid_org (g_org_id), 'N') <> 'Y'
829: THEN
830:
831: fnd_message.set_name ('MO', 'MO_ORG_INVALID');
832: fnd_msg_pub.ADD;
833: RAISE fnd_api.g_exc_error;
834: END IF;
835:

Line 927: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');

923: RAISE;
924: WHEN OTHERS
925: THEN
926: --ROLLBACK TO update_status;
927: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
928: fnd_message.set_token ('P_TEXT', SQLERRM);
929: fnd_msg_pub.ADD;
930: x_return_status := fnd_api.g_ret_sts_error;
931: pn_lease_pvt.pvt_debug (g_pkg_name||'.'|| g_program_unit || ' - In public update_status api: unknown error '||x_return_status, 3);

Line 928: fnd_message.set_token ('P_TEXT', SQLERRM);

924: WHEN OTHERS
925: THEN
926: --ROLLBACK TO update_status;
927: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
928: fnd_message.set_token ('P_TEXT', SQLERRM);
929: fnd_msg_pub.ADD;
930: x_return_status := fnd_api.g_ret_sts_error;
931: pn_lease_pvt.pvt_debug (g_pkg_name||'.'|| g_program_unit || ' - In public update_status api: unknown error '||x_return_status, 3);
932: RAISE;