DBA Data[Home] [Help]

APPS.HZ_FORMAT_PHONE_V2PUB dependencies on FND_MESSAGE

Line 506: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

502:
503: WHEN OTHERS THEN
504: x_return_status := fnd_api.g_ret_sts_unexp_error;
505:
506: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
507: fnd_message.set_token('ERROR' ,SQLERRM);
508: fnd_msg_pub.add;
509:
510: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 507: fnd_message.set_token('ERROR' ,SQLERRM);

503: WHEN OTHERS THEN
504: x_return_status := fnd_api.g_ret_sts_unexp_error;
505:
506: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
507: fnd_message.set_token('ERROR' ,SQLERRM);
508: fnd_msg_pub.add;
509:
510: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
511: p_count => x_msg_count,

Line 657: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');

653: from HZ_CONTACT_POINTS
654: where CONTACT_POINT_ID = p_contact_point_id;
655: EXCEPTION
656: WHEN NO_DATA_FOUND THEN
657: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
658: fnd_message.set_token('RECORD', 'Contact Point');
659: fnd_message.set_token('VALUE', TO_CHAR(p_contact_point_id));
660: fnd_msg_pub.add;
661: RAISE fnd_api.g_exc_error;

Line 658: fnd_message.set_token('RECORD', 'Contact Point');

654: where CONTACT_POINT_ID = p_contact_point_id;
655: EXCEPTION
656: WHEN NO_DATA_FOUND THEN
657: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
658: fnd_message.set_token('RECORD', 'Contact Point');
659: fnd_message.set_token('VALUE', TO_CHAR(p_contact_point_id));
660: fnd_msg_pub.add;
661: RAISE fnd_api.g_exc_error;
662: END ;

Line 659: fnd_message.set_token('VALUE', TO_CHAR(p_contact_point_id));

655: EXCEPTION
656: WHEN NO_DATA_FOUND THEN
657: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
658: fnd_message.set_token('RECORD', 'Contact Point');
659: fnd_message.set_token('VALUE', TO_CHAR(p_contact_point_id));
660: fnd_msg_pub.add;
661: RAISE fnd_api.g_exc_error;
662: END ;
663:

Line 666: fnd_message.set_name('AR', 'HZ_WRONG_CONTACT_POINT_TYPE');

662: END ;
663:
664:
665: IF l_contact_point_type <> 'PHONE' THEN
666: fnd_message.set_name('AR', 'HZ_WRONG_CONTACT_POINT_TYPE');
667: fnd_msg_pub.add;
668: RAISE fnd_api.g_exc_error;
669: END IF;
670:

Line 711: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');

707: where CONTACT_POINT_ID = p_contact_point_id
708: and CONTACT_POINT_TYPE = 'PHONE';
709: EXCEPTION
710: WHEN NO_DATA_FOUND THEN
711: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
712: fnd_message.set_token('RECORD', 'Contact Point');
713: fnd_message.set_token('VALUE', TO_CHAR(p_contact_point_id));
714: fnd_msg_pub.add;
715: RAISE fnd_api.g_exc_error;

Line 712: fnd_message.set_token('RECORD', 'Contact Point');

708: and CONTACT_POINT_TYPE = 'PHONE';
709: EXCEPTION
710: WHEN NO_DATA_FOUND THEN
711: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
712: fnd_message.set_token('RECORD', 'Contact Point');
713: fnd_message.set_token('VALUE', TO_CHAR(p_contact_point_id));
714: fnd_msg_pub.add;
715: RAISE fnd_api.g_exc_error;
716: END ;

Line 713: fnd_message.set_token('VALUE', TO_CHAR(p_contact_point_id));

709: EXCEPTION
710: WHEN NO_DATA_FOUND THEN
711: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
712: fnd_message.set_token('RECORD', 'Contact Point');
713: fnd_message.set_token('VALUE', TO_CHAR(p_contact_point_id));
714: fnd_msg_pub.add;
715: RAISE fnd_api.g_exc_error;
716: END ;
717:

Line 925: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

921:
922: WHEN OTHERS THEN
923: x_return_status := fnd_api.g_ret_sts_unexp_error;
924:
925: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
926: fnd_message.set_token('ERROR' ,SQLERRM);
927: fnd_msg_pub.add;
928:
929: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 926: fnd_message.set_token('ERROR' ,SQLERRM);

922: WHEN OTHERS THEN
923: x_return_status := fnd_api.g_ret_sts_unexp_error;
924:
925: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
926: fnd_message.set_token('ERROR' ,SQLERRM);
927: fnd_msg_pub.add;
928:
929: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
930: p_count => x_msg_count,

Line 1292: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

1288:
1289: WHEN OTHERS THEN
1290: x_return_status := fnd_api.g_ret_sts_unexp_error;
1291:
1292: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1293: fnd_message.set_token('ERROR' ,SQLERRM);
1294: fnd_msg_pub.add;
1295:
1296: fnd_msg_pub.count_and_get(

Line 1293: fnd_message.set_token('ERROR' ,SQLERRM);

1289: WHEN OTHERS THEN
1290: x_return_status := fnd_api.g_ret_sts_unexp_error;
1291:
1292: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1293: fnd_message.set_token('ERROR' ,SQLERRM);
1294: fnd_msg_pub.add;
1295:
1296: fnd_msg_pub.count_and_get(
1297: p_encoded => fnd_api.g_false,

Line 1519: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

1515:
1516: WHEN OTHERS THEN
1517: x_return_status := fnd_api.g_ret_sts_unexp_error;
1518:
1519: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1520: fnd_message.set_token('ERROR' ,SQLERRM);
1521: fnd_msg_pub.add;
1522:
1523: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 1520: fnd_message.set_token('ERROR' ,SQLERRM);

1516: WHEN OTHERS THEN
1517: x_return_status := fnd_api.g_ret_sts_unexp_error;
1518:
1519: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1520: fnd_message.set_token('ERROR' ,SQLERRM);
1521: fnd_msg_pub.add;
1522:
1523: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1524: p_count => x_msg_count,