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 1109: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');

1105: (p_object_version_number IS NOT NULL AND
1106: l_object_version_number IS NOT NULL AND
1107: p_object_version_number = l_object_version_number))
1108: THEN
1109: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
1110: fnd_message.set_token('TABLE', 'hz_contact_points');
1111: fnd_msg_pub.add;
1112: RAISE fnd_api.g_exc_error;
1113: END IF;

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

1106: l_object_version_number IS NOT NULL AND
1107: p_object_version_number = l_object_version_number))
1108: THEN
1109: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
1110: fnd_message.set_token('TABLE', 'hz_contact_points');
1111: fnd_msg_pub.add;
1112: RAISE fnd_api.g_exc_error;
1113: END IF;
1114:

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

1115: p_object_version_number := NVL(l_object_version_number, 1) + 1;
1116:
1117: EXCEPTION
1118: WHEN NO_DATA_FOUND THEN
1119: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1120: fnd_message.set_token('RECORD', 'contact point');
1121: fnd_message.set_token('VALUE',
1122: NVL(TO_CHAR(p_contact_point_rec.contact_point_id), 'null'));
1123: fnd_msg_pub.add;

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

1116:
1117: EXCEPTION
1118: WHEN NO_DATA_FOUND THEN
1119: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1120: fnd_message.set_token('RECORD', 'contact point');
1121: fnd_message.set_token('VALUE',
1122: NVL(TO_CHAR(p_contact_point_rec.contact_point_id), 'null'));
1123: fnd_msg_pub.add;
1124: RAISE fnd_api.g_exc_error;

Line 1121: fnd_message.set_token('VALUE',

1117: EXCEPTION
1118: WHEN NO_DATA_FOUND THEN
1119: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1120: fnd_message.set_token('RECORD', 'contact point');
1121: fnd_message.set_token('VALUE',
1122: NVL(TO_CHAR(p_contact_point_rec.contact_point_id), 'null'));
1123: fnd_msg_pub.add;
1124: RAISE fnd_api.g_exc_error;
1125: END;

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

2451:
2452: -- Check whether primary key has been passed in.
2453: IF p_contact_point_id IS NULL OR
2454: p_contact_point_id = fnd_api.g_miss_num THEN
2455: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
2456: fnd_message.set_token('COLUMN', 'contact_point_id');
2457: fnd_msg_pub.add;
2458: RAISE fnd_api.g_exc_error;
2459: END IF;

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

2452: -- Check whether primary key has been passed in.
2453: IF p_contact_point_id IS NULL OR
2454: p_contact_point_id = fnd_api.g_miss_num THEN
2455: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
2456: fnd_message.set_token('COLUMN', 'contact_point_id');
2457: fnd_msg_pub.add;
2458: RAISE fnd_api.g_exc_error;
2459: END IF;
2460:

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

2712: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then
2713: --
2714: -- Bug 3835601: replaced the dss message with a more user friendly message
2715: --
2716: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_INSERT_PRIVILEGE');
2717: IF l_contact_point_rec.owner_table_name = 'HZ_PARTIES' THEN
2718: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
2719: hz_dss_util_pub.get_display_name(null, 'PARTY_CONTACT_POINTS'));
2720: ELSIF l_contact_point_rec.owner_table_name = 'HZ_PARTY_SITES' THEN

Line 2718: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',

2714: -- Bug 3835601: replaced the dss message with a more user friendly message
2715: --
2716: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_INSERT_PRIVILEGE');
2717: IF l_contact_point_rec.owner_table_name = 'HZ_PARTIES' THEN
2718: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
2719: hz_dss_util_pub.get_display_name(null, 'PARTY_CONTACT_POINTS'));
2720: ELSIF l_contact_point_rec.owner_table_name = 'HZ_PARTY_SITES' THEN
2721: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
2722: hz_dss_util_pub.get_display_name(null, 'PARTY_SITE_CONTACT_POINTS'));

Line 2721: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',

2717: IF l_contact_point_rec.owner_table_name = 'HZ_PARTIES' THEN
2718: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
2719: hz_dss_util_pub.get_display_name(null, 'PARTY_CONTACT_POINTS'));
2720: ELSIF l_contact_point_rec.owner_table_name = 'HZ_PARTY_SITES' THEN
2721: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
2722: hz_dss_util_pub.get_display_name(null, 'PARTY_SITE_CONTACT_POINTS'));
2723: END IF;
2724: FND_MSG_PUB.ADD;
2725: RAISE FND_API.G_EXC_ERROR;

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

2946: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then
2947: --
2948: -- Bug 3835601: replaced the dss message with a more user friendly message
2949: --
2950: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
2951: IF l_old_contact_point_rec.owner_table_name = 'HZ_PARTIES' THEN
2952: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
2953: hz_dss_util_pub.get_display_name(null, 'PARTY_CONTACT_POINTS'));
2954: ELSIF l_old_contact_point_rec.owner_table_name = 'HZ_PARTY_SITES' THEN

Line 2952: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',

2948: -- Bug 3835601: replaced the dss message with a more user friendly message
2949: --
2950: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
2951: IF l_old_contact_point_rec.owner_table_name = 'HZ_PARTIES' THEN
2952: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
2953: hz_dss_util_pub.get_display_name(null, 'PARTY_CONTACT_POINTS'));
2954: ELSIF l_old_contact_point_rec.owner_table_name = 'HZ_PARTY_SITES' THEN
2955: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
2956: hz_dss_util_pub.get_display_name(null, 'PARTY_SITE_CONTACT_POINTS'));

Line 2955: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',

2951: IF l_old_contact_point_rec.owner_table_name = 'HZ_PARTIES' THEN
2952: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
2953: hz_dss_util_pub.get_display_name(null, 'PARTY_CONTACT_POINTS'));
2954: ELSIF l_old_contact_point_rec.owner_table_name = 'HZ_PARTY_SITES' THEN
2955: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
2956: hz_dss_util_pub.get_display_name(null, 'PARTY_SITE_CONTACT_POINTS'));
2957: END IF;
2958: FND_MSG_PUB.ADD;
2959: RAISE FND_API.G_EXC_ERROR;

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

3264: WHEN OTHERS THEN
3265: ROLLBACK TO create_contact_point;
3266: x_return_status := fnd_api.g_ret_sts_unexp_error;
3267:
3268: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3269: fnd_message.set_token('ERROR' ,SQLERRM);
3270: fnd_msg_pub.add;
3271:
3272: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

3265: ROLLBACK TO create_contact_point;
3266: x_return_status := fnd_api.g_ret_sts_unexp_error;
3267:
3268: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3269: fnd_message.set_token('ERROR' ,SQLERRM);
3270: fnd_msg_pub.add;
3271:
3272: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3273: p_count => x_msg_count,

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

3430: WHEN OTHERS THEN
3431: ROLLBACK TO create_edi_contact_point;
3432: x_return_status := fnd_api.g_ret_sts_unexp_error;
3433:
3434: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3435: fnd_message.set_token('ERROR' ,SQLERRM);
3436: fnd_msg_pub.add;
3437:
3438: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

3431: ROLLBACK TO create_edi_contact_point;
3432: x_return_status := fnd_api.g_ret_sts_unexp_error;
3433:
3434: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3435: fnd_message.set_token('ERROR' ,SQLERRM);
3436: fnd_msg_pub.add;
3437:
3438: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3439: p_count => x_msg_count,

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

3596: WHEN OTHERS THEN
3597: ROLLBACK TO create_web_contact_point;
3598: x_return_status := fnd_api.g_ret_sts_unexp_error;
3599:
3600: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3601: fnd_message.set_token('ERROR' ,SQLERRM);
3602: fnd_msg_pub.add;
3603:
3604: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

3597: ROLLBACK TO create_web_contact_point;
3598: x_return_status := fnd_api.g_ret_sts_unexp_error;
3599:
3600: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3601: fnd_message.set_token('ERROR' ,SQLERRM);
3602: fnd_msg_pub.add;
3603:
3604: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3605: p_count => x_msg_count,

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

3765: WHEN OTHERS THEN
3766: ROLLBACK TO create_eft_contact_point;
3767: x_return_status := fnd_api.g_ret_sts_unexp_error;
3768:
3769: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3770: fnd_message.set_token('ERROR' ,SQLERRM);
3771: fnd_msg_pub.add;
3772:
3773: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

3766: ROLLBACK TO create_eft_contact_point;
3767: x_return_status := fnd_api.g_ret_sts_unexp_error;
3768:
3769: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3770: fnd_message.set_token('ERROR' ,SQLERRM);
3771: fnd_msg_pub.add;
3772:
3773: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3774: p_count => x_msg_count,

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

3932: WHEN OTHERS THEN
3933: ROLLBACK TO create_phone_contact_point;
3934: x_return_status := fnd_api.g_ret_sts_unexp_error;
3935:
3936: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3937: fnd_message.set_token('ERROR' ,SQLERRM);
3938: fnd_msg_pub.add;
3939:
3940: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

3933: ROLLBACK TO create_phone_contact_point;
3934: x_return_status := fnd_api.g_ret_sts_unexp_error;
3935:
3936: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3937: fnd_message.set_token('ERROR' ,SQLERRM);
3938: fnd_msg_pub.add;
3939:
3940: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3941: p_count => x_msg_count,

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

4099: WHEN OTHERS THEN
4100: ROLLBACK TO create_telex_contact_point;
4101: x_return_status := fnd_api.g_ret_sts_unexp_error;
4102:
4103: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4104: fnd_message.set_token('ERROR' ,SQLERRM);
4105: fnd_msg_pub.add;
4106:
4107: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

4100: ROLLBACK TO create_telex_contact_point;
4101: x_return_status := fnd_api.g_ret_sts_unexp_error;
4102:
4103: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4104: fnd_message.set_token('ERROR' ,SQLERRM);
4105: fnd_msg_pub.add;
4106:
4107: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4108: p_count => x_msg_count,

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

4266: WHEN OTHERS THEN
4267: ROLLBACK TO create_email_contact_point;
4268: x_return_status := fnd_api.g_ret_sts_unexp_error;
4269:
4270: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4271: fnd_message.set_token('ERROR' ,SQLERRM);
4272: fnd_msg_pub.add;
4273:
4274: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

4267: ROLLBACK TO create_email_contact_point;
4268: x_return_status := fnd_api.g_ret_sts_unexp_error;
4269:
4270: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4271: fnd_message.set_token('ERROR' ,SQLERRM);
4272: fnd_msg_pub.add;
4273:
4274: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4275: p_count => x_msg_count,

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

4450: ROLLBACK TO update_contact_point;
4451: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
4452: x_return_status := fnd_api.g_ret_sts_unexp_error;
4453:
4454: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4455: fnd_message.set_token('ERROR' ,SQLERRM);
4456: fnd_msg_pub.add;
4457:
4458: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

4451: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
4452: x_return_status := fnd_api.g_ret_sts_unexp_error;
4453:
4454: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4455: fnd_message.set_token('ERROR' ,SQLERRM);
4456: fnd_msg_pub.add;
4457:
4458: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4459: p_count => x_msg_count,

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

4615: WHEN OTHERS THEN
4616: ROLLBACK TO update_edi_contact_point;
4617: x_return_status := fnd_api.g_ret_sts_unexp_error;
4618:
4619: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4620: fnd_message.set_token('ERROR' ,SQLERRM);
4621: fnd_msg_pub.add;
4622:
4623: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

4616: ROLLBACK TO update_edi_contact_point;
4617: x_return_status := fnd_api.g_ret_sts_unexp_error;
4618:
4619: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4620: fnd_message.set_token('ERROR' ,SQLERRM);
4621: fnd_msg_pub.add;
4622:
4623: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4624: p_count => x_msg_count,

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

4785: ROLLBACK TO update_web_contact_point;
4786: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
4787: x_return_status := fnd_api.g_ret_sts_unexp_error;
4788:
4789: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4790: fnd_message.set_token('ERROR' ,SQLERRM);
4791: fnd_msg_pub.add;
4792:
4793: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

4786: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
4787: x_return_status := fnd_api.g_ret_sts_unexp_error;
4788:
4789: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4790: fnd_message.set_token('ERROR' ,SQLERRM);
4791: fnd_msg_pub.add;
4792:
4793: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4794: p_count => x_msg_count,

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

4953: WHEN OTHERS THEN
4954: ROLLBACK TO update_eft_contact_point;
4955: x_return_status := fnd_api.g_ret_sts_unexp_error;
4956:
4957: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4958: fnd_message.set_token('ERROR' ,SQLERRM);
4959: fnd_msg_pub.add;
4960:
4961: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

4954: ROLLBACK TO update_eft_contact_point;
4955: x_return_status := fnd_api.g_ret_sts_unexp_error;
4956:
4957: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4958: fnd_message.set_token('ERROR' ,SQLERRM);
4959: fnd_msg_pub.add;
4960:
4961: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4962: p_count => x_msg_count,

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

5123: ROLLBACK TO update_phone_contact_point;
5124: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5125: x_return_status := fnd_api.g_ret_sts_unexp_error;
5126:
5127: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5128: fnd_message.set_token('ERROR' ,SQLERRM);
5129: fnd_msg_pub.add;
5130:
5131: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

5124: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5125: x_return_status := fnd_api.g_ret_sts_unexp_error;
5126:
5127: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5128: fnd_message.set_token('ERROR' ,SQLERRM);
5129: fnd_msg_pub.add;
5130:
5131: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5132: p_count => x_msg_count,

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

5295: ROLLBACK TO update_telex_contact_point;
5296: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5297: x_return_status := fnd_api.g_ret_sts_unexp_error;
5298:
5299: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5300: fnd_message.set_token('ERROR' ,SQLERRM);
5301: fnd_msg_pub.add;
5302:
5303: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

5296: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5297: x_return_status := fnd_api.g_ret_sts_unexp_error;
5298:
5299: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5300: fnd_message.set_token('ERROR' ,SQLERRM);
5301: fnd_msg_pub.add;
5302:
5303: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5304: p_count => x_msg_count,

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

5464: ROLLBACK TO update_email_contact_point;
5465: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5466: x_return_status := fnd_api.g_ret_sts_unexp_error;
5467:
5468: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5469: fnd_message.set_token('ERROR' ,SQLERRM);
5470: fnd_msg_pub.add;
5471:
5472: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

5465: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
5466: x_return_status := fnd_api.g_ret_sts_unexp_error;
5467:
5468: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5469: fnd_message.set_token('ERROR' ,SQLERRM);
5470: fnd_msg_pub.add;
5471:
5472: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5473: p_count => x_msg_count,

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

5599: -- formatted, error out NOCOPY
5600: IF (l_format_raw_phone AND l_format_area_phone) OR
5601: (NOT l_format_raw_phone AND NOT l_format_area_phone)
5602: THEN
5603: fnd_message.set_name('AR', 'HZ_INVALID_PHONE_PARAMETER');
5604: fnd_msg_pub.add;
5605: RAISE fnd_api.g_exc_error;
5606: END IF;
5607:

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

5670: x_msg_data );
5671:
5672: /* -- Cannot get territory code, error out NOCOPY
5673: | IF l_territory_code IS NULL THEN
5674: | fnd_message.set_name('AR', 'HZ_COUNTRY_CODE_NOT_DEFINED');
5675: | fnd_msg_pub.add;
5676: | RAISE fnd_api.g_exc_error;
5677: | END IF;
5678: |

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

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

5790:
5791: WHEN OTHERS THEN
5792: x_return_status := fnd_api.g_ret_sts_unexp_error;
5793:
5794: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5795: fnd_message.set_token('ERROR' ,SQLERRM);
5796: fnd_msg_pub.add;
5797:
5798: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

5791: WHEN OTHERS THEN
5792: x_return_status := fnd_api.g_ret_sts_unexp_error;
5793:
5794: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5795: fnd_message.set_token('ERROR' ,SQLERRM);
5796: fnd_msg_pub.add;
5797:
5798: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5799: p_count => x_msg_count,

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

5962:
5963: WHEN OTHERS THEN
5964: x_return_status := fnd_api.g_ret_sts_unexp_error;
5965:
5966: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5967: fnd_message.set_token('ERROR' ,SQLERRM);
5968: fnd_msg_pub.add;
5969:
5970: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

5963: WHEN OTHERS THEN
5964: x_return_status := fnd_api.g_ret_sts_unexp_error;
5965:
5966: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5967: fnd_message.set_token('ERROR' ,SQLERRM);
5968: fnd_msg_pub.add;
5969:
5970: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
5971: p_count => x_msg_count,

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

6128:
6129: WHEN OTHERS THEN
6130: x_return_status := fnd_api.g_ret_sts_unexp_error;
6131:
6132: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6133: fnd_message.set_token('ERROR' ,SQLERRM);
6134: fnd_msg_pub.add;
6135:
6136: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

6129: WHEN OTHERS THEN
6130: x_return_status := fnd_api.g_ret_sts_unexp_error;
6131:
6132: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6133: fnd_message.set_token('ERROR' ,SQLERRM);
6134: fnd_msg_pub.add;
6135:
6136: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6137: p_count => x_msg_count,

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

6295:
6296: WHEN OTHERS THEN
6297: x_return_status := fnd_api.g_ret_sts_unexp_error;
6298:
6299: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6300: fnd_message.set_token('ERROR' ,SQLERRM);
6301: fnd_msg_pub.add;
6302:
6303: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

6296: WHEN OTHERS THEN
6297: x_return_status := fnd_api.g_ret_sts_unexp_error;
6298:
6299: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6300: fnd_message.set_token('ERROR' ,SQLERRM);
6301: fnd_msg_pub.add;
6302:
6303: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6304: p_count => x_msg_count,

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

6463:
6464: WHEN OTHERS THEN
6465: x_return_status := fnd_api.g_ret_sts_unexp_error;
6466:
6467: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6468: fnd_message.set_token('ERROR' ,SQLERRM);
6469: fnd_msg_pub.add;
6470:
6471: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

6464: WHEN OTHERS THEN
6465: x_return_status := fnd_api.g_ret_sts_unexp_error;
6466:
6467: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6468: fnd_message.set_token('ERROR' ,SQLERRM);
6469: fnd_msg_pub.add;
6470:
6471: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6472: p_count => x_msg_count,

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

6629:
6630: WHEN OTHERS THEN
6631: x_return_status := fnd_api.g_ret_sts_unexp_error;
6632:
6633: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6634: fnd_message.set_token('ERROR' ,SQLERRM);
6635: fnd_msg_pub.add;
6636:
6637: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

6630: WHEN OTHERS THEN
6631: x_return_status := fnd_api.g_ret_sts_unexp_error;
6632:
6633: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6634: fnd_message.set_token('ERROR' ,SQLERRM);
6635: fnd_msg_pub.add;
6636:
6637: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6638: p_count => x_msg_count,

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

6795:
6796: WHEN OTHERS THEN
6797: x_return_status := fnd_api.g_ret_sts_unexp_error;
6798:
6799: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6800: fnd_message.set_token('ERROR' ,SQLERRM);
6801: fnd_msg_pub.add;
6802:
6803: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

6796: WHEN OTHERS THEN
6797: x_return_status := fnd_api.g_ret_sts_unexp_error;
6798:
6799: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6800: fnd_message.set_token('ERROR' ,SQLERRM);
6801: fnd_msg_pub.add;
6802:
6803: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6804: p_count => x_msg_count,

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

6962:
6963: WHEN OTHERS THEN
6964: x_return_status := fnd_api.g_ret_sts_unexp_error;
6965:
6966: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6967: fnd_message.set_token('ERROR' ,SQLERRM);
6968: fnd_msg_pub.add;
6969:
6970: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

6963: WHEN OTHERS THEN
6964: x_return_status := fnd_api.g_ret_sts_unexp_error;
6965:
6966: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6967: fnd_message.set_token('ERROR' ,SQLERRM);
6968: fnd_msg_pub.add;
6969:
6970: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
6971: p_count => x_msg_count,