eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_CONTACT_POINT_V2PUB dependencies on FND_MESSAGE

Line 1122: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');

1118: (p_object_version_number IS NOT NULL AND
1119: l_object_version_number IS NOT NULL AND
1120: p_object_version_number = l_object_version_number))
1121: THEN
1122: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
1123: fnd_message.set_token('TABLE', 'hz_contact_points');
1124: fnd_msg_pub.add;
1125: RAISE fnd_api.g_exc_error;
1126: END IF;

Line 1123: fnd_message.set_token('TABLE', 'hz_contact_points');

1119: l_object_version_number IS NOT NULL AND
1120: p_object_version_number = l_object_version_number))
1121: THEN
1122: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
1123: fnd_message.set_token('TABLE', 'hz_contact_points');
1124: fnd_msg_pub.add;
1125: RAISE fnd_api.g_exc_error;
1126: END IF;
1127:

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

1128: p_object_version_number := NVL(l_object_version_number, 1) + 1;
1129:
1130: EXCEPTION
1131: WHEN NO_DATA_FOUND THEN
1132: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1133: fnd_message.set_token('RECORD', 'contact point');
1134: fnd_message.set_token('VALUE',
1135: NVL(TO_CHAR(p_contact_point_rec.contact_point_id), 'null'));
1136: fnd_msg_pub.add;

Line 1133: fnd_message.set_token('RECORD', 'contact point');

1129:
1130: EXCEPTION
1131: WHEN NO_DATA_FOUND THEN
1132: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1133: fnd_message.set_token('RECORD', 'contact point');
1134: fnd_message.set_token('VALUE',
1135: NVL(TO_CHAR(p_contact_point_rec.contact_point_id), 'null'));
1136: fnd_msg_pub.add;
1137: RAISE fnd_api.g_exc_error;

Line 1134: fnd_message.set_token('VALUE',

1130: EXCEPTION
1131: WHEN NO_DATA_FOUND THEN
1132: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1133: fnd_message.set_token('RECORD', 'contact point');
1134: fnd_message.set_token('VALUE',
1135: NVL(TO_CHAR(p_contact_point_rec.contact_point_id), 'null'));
1136: fnd_msg_pub.add;
1137: RAISE fnd_api.g_exc_error;
1138: END;

Line 2608: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');

2604:
2605: -- Check whether primary key has been passed in.
2606: IF p_contact_point_id IS NULL OR
2607: p_contact_point_id = fnd_api.g_miss_num THEN
2608: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
2609: fnd_message.set_token('COLUMN', 'contact_point_id');
2610: fnd_msg_pub.add;
2611: RAISE fnd_api.g_exc_error;
2612: END IF;

Line 2609: fnd_message.set_token('COLUMN', 'contact_point_id');

2605: -- Check whether primary key has been passed in.
2606: IF p_contact_point_id IS NULL OR
2607: p_contact_point_id = fnd_api.g_miss_num THEN
2608: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
2609: fnd_message.set_token('COLUMN', 'contact_point_id');
2610: fnd_msg_pub.add;
2611: RAISE fnd_api.g_exc_error;
2612: END IF;
2613:

Line 2869: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_INSERT_PRIVILEGE');

2865: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then
2866: --
2867: -- Bug 3835601: replaced the dss message with a more user friendly message
2868: --
2869: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_INSERT_PRIVILEGE');
2870: IF l_contact_point_rec.owner_table_name = 'HZ_PARTIES' THEN
2871: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
2872: hz_dss_util_pub.get_display_name(null, 'PARTY_CONTACT_POINTS'));
2873: ELSIF l_contact_point_rec.owner_table_name = 'HZ_PARTY_SITES' THEN

Line 2871: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',

2867: -- Bug 3835601: replaced the dss message with a more user friendly message
2868: --
2869: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_INSERT_PRIVILEGE');
2870: IF l_contact_point_rec.owner_table_name = 'HZ_PARTIES' THEN
2871: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
2872: hz_dss_util_pub.get_display_name(null, 'PARTY_CONTACT_POINTS'));
2873: ELSIF l_contact_point_rec.owner_table_name = 'HZ_PARTY_SITES' THEN
2874: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
2875: hz_dss_util_pub.get_display_name(null, 'PARTY_SITE_CONTACT_POINTS'));

Line 2874: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',

2870: IF l_contact_point_rec.owner_table_name = 'HZ_PARTIES' THEN
2871: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
2872: hz_dss_util_pub.get_display_name(null, 'PARTY_CONTACT_POINTS'));
2873: ELSIF l_contact_point_rec.owner_table_name = 'HZ_PARTY_SITES' THEN
2874: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
2875: hz_dss_util_pub.get_display_name(null, 'PARTY_SITE_CONTACT_POINTS'));
2876: END IF;
2877: FND_MSG_PUB.ADD;
2878: RAISE FND_API.G_EXC_ERROR;

Line 3106: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');

3102: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then
3103: --
3104: -- Bug 3835601: replaced the dss message with a more user friendly message
3105: --
3106: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
3107: IF l_old_contact_point_rec.owner_table_name = 'HZ_PARTIES' THEN
3108: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
3109: hz_dss_util_pub.get_display_name(null, 'PARTY_CONTACT_POINTS'));
3110: ELSIF l_old_contact_point_rec.owner_table_name = 'HZ_PARTY_SITES' THEN

Line 3108: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',

3104: -- Bug 3835601: replaced the dss message with a more user friendly message
3105: --
3106: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
3107: IF l_old_contact_point_rec.owner_table_name = 'HZ_PARTIES' THEN
3108: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
3109: hz_dss_util_pub.get_display_name(null, 'PARTY_CONTACT_POINTS'));
3110: ELSIF l_old_contact_point_rec.owner_table_name = 'HZ_PARTY_SITES' THEN
3111: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
3112: hz_dss_util_pub.get_display_name(null, 'PARTY_SITE_CONTACT_POINTS'));

Line 3111: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',

3107: IF l_old_contact_point_rec.owner_table_name = 'HZ_PARTIES' THEN
3108: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
3109: hz_dss_util_pub.get_display_name(null, 'PARTY_CONTACT_POINTS'));
3110: ELSIF l_old_contact_point_rec.owner_table_name = 'HZ_PARTY_SITES' THEN
3111: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
3112: hz_dss_util_pub.get_display_name(null, 'PARTY_SITE_CONTACT_POINTS'));
3113: END IF;
3114: FND_MSG_PUB.ADD;
3115: RAISE FND_API.G_EXC_ERROR;

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

3420: WHEN OTHERS THEN
3421: ROLLBACK TO create_contact_point;
3422: x_return_status := fnd_api.g_ret_sts_unexp_error;
3423:
3424: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3425: fnd_message.set_token('ERROR' ,SQLERRM);
3426: fnd_msg_pub.add;
3427:
3428: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

3421: ROLLBACK TO create_contact_point;
3422: x_return_status := fnd_api.g_ret_sts_unexp_error;
3423:
3424: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3425: fnd_message.set_token('ERROR' ,SQLERRM);
3426: fnd_msg_pub.add;
3427:
3428: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3429: p_count => x_msg_count,

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

3586: WHEN OTHERS THEN
3587: ROLLBACK TO create_edi_contact_point;
3588: x_return_status := fnd_api.g_ret_sts_unexp_error;
3589:
3590: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3591: fnd_message.set_token('ERROR' ,SQLERRM);
3592: fnd_msg_pub.add;
3593:
3594: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

3587: ROLLBACK TO create_edi_contact_point;
3588: x_return_status := fnd_api.g_ret_sts_unexp_error;
3589:
3590: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3591: fnd_message.set_token('ERROR' ,SQLERRM);
3592: fnd_msg_pub.add;
3593:
3594: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3595: p_count => x_msg_count,

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

3752: WHEN OTHERS THEN
3753: ROLLBACK TO create_web_contact_point;
3754: x_return_status := fnd_api.g_ret_sts_unexp_error;
3755:
3756: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3757: fnd_message.set_token('ERROR' ,SQLERRM);
3758: fnd_msg_pub.add;
3759:
3760: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

3753: ROLLBACK TO create_web_contact_point;
3754: x_return_status := fnd_api.g_ret_sts_unexp_error;
3755:
3756: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3757: fnd_message.set_token('ERROR' ,SQLERRM);
3758: fnd_msg_pub.add;
3759:
3760: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3761: p_count => x_msg_count,

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

3921: WHEN OTHERS THEN
3922: ROLLBACK TO create_eft_contact_point;
3923: x_return_status := fnd_api.g_ret_sts_unexp_error;
3924:
3925: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3926: fnd_message.set_token('ERROR' ,SQLERRM);
3927: fnd_msg_pub.add;
3928:
3929: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

3922: ROLLBACK TO create_eft_contact_point;
3923: x_return_status := fnd_api.g_ret_sts_unexp_error;
3924:
3925: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3926: fnd_message.set_token('ERROR' ,SQLERRM);
3927: fnd_msg_pub.add;
3928:
3929: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3930: p_count => x_msg_count,

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

4088: WHEN OTHERS THEN
4089: ROLLBACK TO create_phone_contact_point;
4090: x_return_status := fnd_api.g_ret_sts_unexp_error;
4091:
4092: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4093: fnd_message.set_token('ERROR' ,SQLERRM);
4094: fnd_msg_pub.add;
4095:
4096: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

4089: ROLLBACK TO create_phone_contact_point;
4090: x_return_status := fnd_api.g_ret_sts_unexp_error;
4091:
4092: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4093: fnd_message.set_token('ERROR' ,SQLERRM);
4094: fnd_msg_pub.add;
4095:
4096: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4097: p_count => x_msg_count,

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

4255: WHEN OTHERS THEN
4256: ROLLBACK TO create_telex_contact_point;
4257: x_return_status := fnd_api.g_ret_sts_unexp_error;
4258:
4259: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4260: fnd_message.set_token('ERROR' ,SQLERRM);
4261: fnd_msg_pub.add;
4262:
4263: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

4256: ROLLBACK TO create_telex_contact_point;
4257: x_return_status := fnd_api.g_ret_sts_unexp_error;
4258:
4259: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4260: fnd_message.set_token('ERROR' ,SQLERRM);
4261: fnd_msg_pub.add;
4262:
4263: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4264: p_count => x_msg_count,

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

4422: WHEN OTHERS THEN
4423: ROLLBACK TO create_email_contact_point;
4424: x_return_status := fnd_api.g_ret_sts_unexp_error;
4425:
4426: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4427: fnd_message.set_token('ERROR' ,SQLERRM);
4428: fnd_msg_pub.add;
4429:
4430: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

4423: ROLLBACK TO create_email_contact_point;
4424: x_return_status := fnd_api.g_ret_sts_unexp_error;
4425:
4426: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4427: fnd_message.set_token('ERROR' ,SQLERRM);
4428: fnd_msg_pub.add;
4429:
4430: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4431: p_count => x_msg_count,

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

4606: ROLLBACK TO update_contact_point;
4607: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
4608: x_return_status := fnd_api.g_ret_sts_unexp_error;
4609:
4610: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4611: fnd_message.set_token('ERROR' ,SQLERRM);
4612: fnd_msg_pub.add;
4613:
4614: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

4607: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
4608: x_return_status := fnd_api.g_ret_sts_unexp_error;
4609:
4610: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4611: fnd_message.set_token('ERROR' ,SQLERRM);
4612: fnd_msg_pub.add;
4613:
4614: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4615: p_count => x_msg_count,

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

4771: WHEN OTHERS THEN
4772: ROLLBACK TO update_edi_contact_point;
4773: x_return_status := fnd_api.g_ret_sts_unexp_error;
4774:
4775: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4776: fnd_message.set_token('ERROR' ,SQLERRM);
4777: fnd_msg_pub.add;
4778:
4779: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

4772: ROLLBACK TO update_edi_contact_point;
4773: x_return_status := fnd_api.g_ret_sts_unexp_error;
4774:
4775: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4776: fnd_message.set_token('ERROR' ,SQLERRM);
4777: fnd_msg_pub.add;
4778:
4779: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4780: p_count => x_msg_count,

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

4941: ROLLBACK TO update_web_contact_point;
4942: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
4943: x_return_status := fnd_api.g_ret_sts_unexp_error;
4944:
4945: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4946: fnd_message.set_token('ERROR' ,SQLERRM);
4947: fnd_msg_pub.add;
4948:
4949: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

4942: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
4943: x_return_status := fnd_api.g_ret_sts_unexp_error;
4944:
4945: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4946: fnd_message.set_token('ERROR' ,SQLERRM);
4947: fnd_msg_pub.add;
4948:
4949: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4950: p_count => x_msg_count,

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

5109: WHEN OTHERS THEN
5110: ROLLBACK TO update_eft_contact_point;
5111: x_return_status := fnd_api.g_ret_sts_unexp_error;
5112:
5113: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5114: fnd_message.set_token('ERROR' ,SQLERRM);
5115: fnd_msg_pub.add;
5116:
5117: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

5110: ROLLBACK TO update_eft_contact_point;
5111: x_return_status := fnd_api.g_ret_sts_unexp_error;
5112:
5113: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5114: fnd_message.set_token('ERROR' ,SQLERRM);
5115: fnd_msg_pub.add;
5116:
5117: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5118: p_count => x_msg_count,

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

5279: ROLLBACK TO update_phone_contact_point;
5280: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5281: x_return_status := fnd_api.g_ret_sts_unexp_error;
5282:
5283: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5284: fnd_message.set_token('ERROR' ,SQLERRM);
5285: fnd_msg_pub.add;
5286:
5287: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

5280: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5281: x_return_status := fnd_api.g_ret_sts_unexp_error;
5282:
5283: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5284: fnd_message.set_token('ERROR' ,SQLERRM);
5285: fnd_msg_pub.add;
5286:
5287: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5288: p_count => x_msg_count,

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

5451: ROLLBACK TO update_telex_contact_point;
5452: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5453: x_return_status := fnd_api.g_ret_sts_unexp_error;
5454:
5455: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5456: fnd_message.set_token('ERROR' ,SQLERRM);
5457: fnd_msg_pub.add;
5458:
5459: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

5452: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5453: x_return_status := fnd_api.g_ret_sts_unexp_error;
5454:
5455: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5456: fnd_message.set_token('ERROR' ,SQLERRM);
5457: fnd_msg_pub.add;
5458:
5459: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5460: p_count => x_msg_count,

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

5620: ROLLBACK TO update_email_contact_point;
5621: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5622: x_return_status := fnd_api.g_ret_sts_unexp_error;
5623:
5624: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5625: fnd_message.set_token('ERROR' ,SQLERRM);
5626: fnd_msg_pub.add;
5627:
5628: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

5621: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5622: x_return_status := fnd_api.g_ret_sts_unexp_error;
5623:
5624: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5625: fnd_message.set_token('ERROR' ,SQLERRM);
5626: fnd_msg_pub.add;
5627:
5628: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5629: p_count => x_msg_count,

Line 5759: fnd_message.set_name('AR', 'HZ_INVALID_PHONE_PARAMETER');

5755: -- formatted, error out NOCOPY
5756: IF (l_format_raw_phone AND l_format_area_phone) OR
5757: (NOT l_format_raw_phone AND NOT l_format_area_phone)
5758: THEN
5759: fnd_message.set_name('AR', 'HZ_INVALID_PHONE_PARAMETER');
5760: fnd_msg_pub.add;
5761: RAISE fnd_api.g_exc_error;
5762: END IF;
5763:

Line 5830: | fnd_message.set_name('AR', 'HZ_COUNTRY_CODE_NOT_DEFINED');

5826: x_msg_data );
5827:
5828: /* -- Cannot get territory code, error out NOCOPY
5829: | IF l_territory_code IS NULL THEN
5830: | fnd_message.set_name('AR', 'HZ_COUNTRY_CODE_NOT_DEFINED');
5831: | fnd_msg_pub.add;
5832: | RAISE fnd_api.g_exc_error;
5833: | END IF;
5834: |

Line 5849: | fnd_message.set_name('AR', l_msg_name);

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

5946:
5947: WHEN OTHERS THEN
5948: x_return_status := fnd_api.g_ret_sts_unexp_error;
5949:
5950: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5951: fnd_message.set_token('ERROR' ,SQLERRM);
5952: fnd_msg_pub.add;
5953:
5954: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

5947: WHEN OTHERS THEN
5948: x_return_status := fnd_api.g_ret_sts_unexp_error;
5949:
5950: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5951: fnd_message.set_token('ERROR' ,SQLERRM);
5952: fnd_msg_pub.add;
5953:
5954: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5955: p_count => x_msg_count,

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

6118:
6119: WHEN OTHERS THEN
6120: x_return_status := fnd_api.g_ret_sts_unexp_error;
6121:
6122: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6123: fnd_message.set_token('ERROR' ,SQLERRM);
6124: fnd_msg_pub.add;
6125:
6126: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

6119: WHEN OTHERS THEN
6120: x_return_status := fnd_api.g_ret_sts_unexp_error;
6121:
6122: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6123: fnd_message.set_token('ERROR' ,SQLERRM);
6124: fnd_msg_pub.add;
6125:
6126: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6127: p_count => x_msg_count,

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

6284:
6285: WHEN OTHERS THEN
6286: x_return_status := fnd_api.g_ret_sts_unexp_error;
6287:
6288: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6289: fnd_message.set_token('ERROR' ,SQLERRM);
6290: fnd_msg_pub.add;
6291:
6292: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

6285: WHEN OTHERS THEN
6286: x_return_status := fnd_api.g_ret_sts_unexp_error;
6287:
6288: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6289: fnd_message.set_token('ERROR' ,SQLERRM);
6290: fnd_msg_pub.add;
6291:
6292: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6293: p_count => x_msg_count,

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

6451:
6452: WHEN OTHERS THEN
6453: x_return_status := fnd_api.g_ret_sts_unexp_error;
6454:
6455: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6456: fnd_message.set_token('ERROR' ,SQLERRM);
6457: fnd_msg_pub.add;
6458:
6459: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

6452: WHEN OTHERS THEN
6453: x_return_status := fnd_api.g_ret_sts_unexp_error;
6454:
6455: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6456: fnd_message.set_token('ERROR' ,SQLERRM);
6457: fnd_msg_pub.add;
6458:
6459: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6460: p_count => x_msg_count,

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

6619:
6620: WHEN OTHERS THEN
6621: x_return_status := fnd_api.g_ret_sts_unexp_error;
6622:
6623: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6624: fnd_message.set_token('ERROR' ,SQLERRM);
6625: fnd_msg_pub.add;
6626:
6627: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

6620: WHEN OTHERS THEN
6621: x_return_status := fnd_api.g_ret_sts_unexp_error;
6622:
6623: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6624: fnd_message.set_token('ERROR' ,SQLERRM);
6625: fnd_msg_pub.add;
6626:
6627: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6628: p_count => x_msg_count,

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

6785:
6786: WHEN OTHERS THEN
6787: x_return_status := fnd_api.g_ret_sts_unexp_error;
6788:
6789: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6790: fnd_message.set_token('ERROR' ,SQLERRM);
6791: fnd_msg_pub.add;
6792:
6793: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

6786: WHEN OTHERS THEN
6787: x_return_status := fnd_api.g_ret_sts_unexp_error;
6788:
6789: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6790: fnd_message.set_token('ERROR' ,SQLERRM);
6791: fnd_msg_pub.add;
6792:
6793: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6794: p_count => x_msg_count,

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

6951:
6952: WHEN OTHERS THEN
6953: x_return_status := fnd_api.g_ret_sts_unexp_error;
6954:
6955: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6956: fnd_message.set_token('ERROR' ,SQLERRM);
6957: fnd_msg_pub.add;
6958:
6959: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

6952: WHEN OTHERS THEN
6953: x_return_status := fnd_api.g_ret_sts_unexp_error;
6954:
6955: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6956: fnd_message.set_token('ERROR' ,SQLERRM);
6957: fnd_msg_pub.add;
6958:
6959: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6960: p_count => x_msg_count,

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

7118:
7119: WHEN OTHERS THEN
7120: x_return_status := fnd_api.g_ret_sts_unexp_error;
7121:
7122: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
7123: fnd_message.set_token('ERROR' ,SQLERRM);
7124: fnd_msg_pub.add;
7125:
7126: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

7119: WHEN OTHERS THEN
7120: x_return_status := fnd_api.g_ret_sts_unexp_error;
7121:
7122: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
7123: fnd_message.set_token('ERROR' ,SQLERRM);
7124: fnd_msg_pub.add;
7125:
7126: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
7127: p_count => x_msg_count,