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_PARTY_V2PUB dependencies on FND_MESSAGE

Line 413: fnd_message.set_name('AR','HZ_DUP_PARTY_WITH_PARTY_TYPE');

409: x_party_number := l_party_number;
410: RETURN 'Y';
411: ELSE
412: /* new message */
413: fnd_message.set_name('AR','HZ_DUP_PARTY_WITH_PARTY_TYPE');
414: fnd_message.set_token('PARTY_ID', p_party_id);
415: fnd_message.set_token('PARTY_TYPE', l_party_type);
416: fnd_msg_pub.add;
417: RAISE FND_API.G_EXC_ERROR;

Line 414: fnd_message.set_token('PARTY_ID', p_party_id);

410: RETURN 'Y';
411: ELSE
412: /* new message */
413: fnd_message.set_name('AR','HZ_DUP_PARTY_WITH_PARTY_TYPE');
414: fnd_message.set_token('PARTY_ID', p_party_id);
415: fnd_message.set_token('PARTY_TYPE', l_party_type);
416: fnd_msg_pub.add;
417: RAISE FND_API.G_EXC_ERROR;
418: END IF;

Line 415: fnd_message.set_token('PARTY_TYPE', l_party_type);

411: ELSE
412: /* new message */
413: fnd_message.set_name('AR','HZ_DUP_PARTY_WITH_PARTY_TYPE');
414: fnd_message.set_token('PARTY_ID', p_party_id);
415: fnd_message.set_token('PARTY_TYPE', l_party_type);
416: fnd_msg_pub.add;
417: RAISE FND_API.G_EXC_ERROR;
418: END IF;
419:

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

758: WHERE PARTY_ID = i_party_id(i)
759: FOR UPDATE NOWAIT;
760: EXCEPTION
761: WHEN OTHERS THEN
762: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
763: fnd_message.set_token('TABLE', 'HZ_PARTIES');
764: fnd_msg_pub.add;
765: RAISE FND_API.G_EXC_ERROR;
766: END;

Line 763: fnd_message.set_token('TABLE', 'HZ_PARTIES');

759: FOR UPDATE NOWAIT;
760: EXCEPTION
761: WHEN OTHERS THEN
762: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
763: fnd_message.set_token('TABLE', 'HZ_PARTIES');
764: fnd_msg_pub.add;
765: RAISE FND_API.G_EXC_ERROR;
766: END;
767:

Line 1137: fnd_message.set_name('AR', 'HZ_API_SIC_CODE_TYPE_REQUIRED');

1133: l_sic_code <> FND_API.G_MISS_CHAR) OR
1134: (l_sic_code = FND_API.G_MISS_CHAR AND
1135: l_sic_code_type <> FND_API.G_MISS_CHAR)
1136: THEN
1137: fnd_message.set_name('AR', 'HZ_API_SIC_CODE_TYPE_REQUIRED');
1138: fnd_msg_pub.add;
1139: RAISE FND_API.G_EXC_ERROR;
1140: END IF;
1141:

Line 1148: fnd_message.set_name('AR', 'HZ_API_SIC_CODE_TYPE_OTHER');

1144:
1145: IF l_sic_code_type = 'OTHER' AND
1146: l_data_source_type <> G_MISS_CONTENT_SOURCE_TYPE
1147: THEN
1148: fnd_message.set_name('AR', 'HZ_API_SIC_CODE_TYPE_OTHER');
1149: fnd_msg_pub.add;
1150: RAISE FND_API.G_EXC_ERROR;
1151: END IF;
1152:

Line 1492: fnd_message.set_name('AR', 'HZ_NO_PROFILE_PRESENT');

1488: l_person_profile_id, l_rowid,l_object_version_number,
1489: l_version_number, l_effective_start_date;
1490:
1491: IF c_person%NOTFOUND THEN
1492: fnd_message.set_name('AR', 'HZ_NO_PROFILE_PRESENT');
1493: fnd_message.set_token('PARTY_ID', TO_CHAR(p_person_rec.party_rec.party_id));
1494: fnd_message.set_token('CONTENT_SOURCE_TYPE', p_data_source_type);
1495: fnd_msg_pub.add;
1496: RAISE fnd_api.g_exc_error;

Line 1493: fnd_message.set_token('PARTY_ID', TO_CHAR(p_person_rec.party_rec.party_id));

1489: l_version_number, l_effective_start_date;
1490:
1491: IF c_person%NOTFOUND THEN
1492: fnd_message.set_name('AR', 'HZ_NO_PROFILE_PRESENT');
1493: fnd_message.set_token('PARTY_ID', TO_CHAR(p_person_rec.party_rec.party_id));
1494: fnd_message.set_token('CONTENT_SOURCE_TYPE', p_data_source_type);
1495: fnd_msg_pub.add;
1496: RAISE fnd_api.g_exc_error;
1497: END IF;

Line 1494: fnd_message.set_token('CONTENT_SOURCE_TYPE', p_data_source_type);

1490:
1491: IF c_person%NOTFOUND THEN
1492: fnd_message.set_name('AR', 'HZ_NO_PROFILE_PRESENT');
1493: fnd_message.set_token('PARTY_ID', TO_CHAR(p_person_rec.party_rec.party_id));
1494: fnd_message.set_token('CONTENT_SOURCE_TYPE', p_data_source_type);
1495: fnd_msg_pub.add;
1496: RAISE fnd_api.g_exc_error;
1497: END IF;
1498: CLOSE c_person;

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

1727: END IF;
1728:
1729: EXCEPTION
1730: WHEN g_resource_busy THEN
1731: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
1732: fnd_message.set_token('TABLE', 'HZ_PERSON_PROFILES');
1733: fnd_msg_pub.add;
1734: RAISE fnd_api.g_exc_error;
1735:

Line 1732: fnd_message.set_token('TABLE', 'HZ_PERSON_PROFILES');

1728:
1729: EXCEPTION
1730: WHEN g_resource_busy THEN
1731: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
1732: fnd_message.set_token('TABLE', 'HZ_PERSON_PROFILES');
1733: fnd_msg_pub.add;
1734: RAISE fnd_api.g_exc_error;
1735:
1736: END do_update_person_profile;

Line 2088: fnd_message.set_name('AR', 'HZ_NO_PROFILE_PRESENT');

2084: l_rowid, l_organization_profile_id,l_object_version_number,
2085: l_version_number,l_effective_start_date;
2086:
2087: IF c_org%NOTFOUND THEN
2088: fnd_message.set_name('AR', 'HZ_NO_PROFILE_PRESENT');
2089: fnd_message.set_token('PARTY_ID', TO_CHAR(p_organization_rec.party_rec.party_id));
2090: fnd_message.set_token('CONTENT_SOURCE_TYPE', p_data_source_type);
2091: fnd_msg_pub.add;
2092: RAISE fnd_api.g_exc_error;

Line 2089: fnd_message.set_token('PARTY_ID', TO_CHAR(p_organization_rec.party_rec.party_id));

2085: l_version_number,l_effective_start_date;
2086:
2087: IF c_org%NOTFOUND THEN
2088: fnd_message.set_name('AR', 'HZ_NO_PROFILE_PRESENT');
2089: fnd_message.set_token('PARTY_ID', TO_CHAR(p_organization_rec.party_rec.party_id));
2090: fnd_message.set_token('CONTENT_SOURCE_TYPE', p_data_source_type);
2091: fnd_msg_pub.add;
2092: RAISE fnd_api.g_exc_error;
2093: END IF;

Line 2090: fnd_message.set_token('CONTENT_SOURCE_TYPE', p_data_source_type);

2086:
2087: IF c_org%NOTFOUND THEN
2088: fnd_message.set_name('AR', 'HZ_NO_PROFILE_PRESENT');
2089: fnd_message.set_token('PARTY_ID', TO_CHAR(p_organization_rec.party_rec.party_id));
2090: fnd_message.set_token('CONTENT_SOURCE_TYPE', p_data_source_type);
2091: fnd_msg_pub.add;
2092: RAISE fnd_api.g_exc_error;
2093: END IF;
2094: CLOSE c_org;

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

2379: END IF;
2380:
2381: EXCEPTION
2382: WHEN g_resource_busy THEN
2383: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
2384: fnd_message.set_token('TABLE', 'HZ_ORGANIZATION_PROFILES');
2385: fnd_msg_pub.add;
2386: RAISE fnd_api.g_exc_error;
2387:

Line 2384: fnd_message.set_token('TABLE', 'HZ_ORGANIZATION_PROFILES');

2380:
2381: EXCEPTION
2382: WHEN g_resource_busy THEN
2383: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
2384: fnd_message.set_token('TABLE', 'HZ_ORGANIZATION_PROFILES');
2385: fnd_msg_pub.add;
2386: RAISE fnd_api.g_exc_error;
2387:
2388: END do_update_org_profile;

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

2861:
2862: IF l_party_rec.party_number = FND_API.G_MISS_CHAR OR
2863: l_party_rec.party_number IS NULL
2864: THEN
2865: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
2866: fnd_message.set_token('COLUMN', 'party number');
2867: fnd_msg_pub.add;
2868: RAISE FND_API.G_EXC_ERROR;
2869: END IF;

Line 2866: fnd_message.set_token('COLUMN', 'party number');

2862: IF l_party_rec.party_number = FND_API.G_MISS_CHAR OR
2863: l_party_rec.party_number IS NULL
2864: THEN
2865: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
2866: fnd_message.set_token('COLUMN', 'party number');
2867: fnd_msg_pub.add;
2868: RAISE FND_API.G_EXC_ERROR;
2869: END IF;
2870:

Line 2875: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');

2871: OPEN c_party_number_exists(l_party_rec.party_number);
2872: FETCH c_party_number_exists INTO l_dummy;
2873:
2874: IF NOT c_party_number_exists%NOTFOUND THEN
2875: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
2876: fnd_message.set_token('COLUMN', 'party_number');
2877: fnd_msg_pub.add;
2878: RAISE FND_API.G_EXC_ERROR;
2879: END IF;

Line 2876: fnd_message.set_token('COLUMN', 'party_number');

2872: FETCH c_party_number_exists INTO l_dummy;
2873:
2874: IF NOT c_party_number_exists%NOTFOUND THEN
2875: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
2876: fnd_message.set_token('COLUMN', 'party_number');
2877: fnd_msg_pub.add;
2878: RAISE FND_API.G_EXC_ERROR;
2879: END IF;
2880: CLOSE c_party_number_exists;

Line 2887: fnd_message.set_name('AR', 'HZ_API_PARTY_NUMBER_AUTO_ON');

2883:
2884: IF l_party_rec.party_number <> FND_API.G_MISS_CHAR AND
2885: l_party_rec.party_number IS NOT NULL
2886: THEN
2887: fnd_message.set_name('AR', 'HZ_API_PARTY_NUMBER_AUTO_ON');
2888: fnd_msg_pub.add;
2889: RAISE FND_API.G_EXC_ERROR;
2890: END IF;
2891:

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

2900: FETCH c_party INTO
2901: db_party_name, l_party_object_version_number, l_rowid, db_created_by_module;
2902:
2903: IF c_party%NOTFOUND THEN
2904: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
2905: fnd_message.set_token('RECORD', 'party');
2906: fnd_message.set_token('VALUE', NVL(TO_CHAR(p_party_id), 'NULL'));
2907: fnd_msg_pub.add;
2908: RAISE fnd_api.g_exc_error;

Line 2905: fnd_message.set_token('RECORD', 'party');

2901: db_party_name, l_party_object_version_number, l_rowid, db_created_by_module;
2902:
2903: IF c_party%NOTFOUND THEN
2904: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
2905: fnd_message.set_token('RECORD', 'party');
2906: fnd_message.set_token('VALUE', NVL(TO_CHAR(p_party_id), 'NULL'));
2907: fnd_msg_pub.add;
2908: RAISE fnd_api.g_exc_error;
2909: ELSIF p_check_object_version_number = 'Y' AND

Line 2906: fnd_message.set_token('VALUE', NVL(TO_CHAR(p_party_id), 'NULL'));

2902:
2903: IF c_party%NOTFOUND THEN
2904: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
2905: fnd_message.set_token('RECORD', 'party');
2906: fnd_message.set_token('VALUE', NVL(TO_CHAR(p_party_id), 'NULL'));
2907: fnd_msg_pub.add;
2908: RAISE fnd_api.g_exc_error;
2909: ELSIF p_check_object_version_number = 'Y' AND
2910: NOT ((p_party_object_version_number IS NULL AND

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

2912: (p_party_object_version_number IS NOT NULL AND
2913: l_party_object_version_number IS NOT NULL AND
2914: p_party_object_version_number = l_party_object_version_number))
2915: THEN
2916: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
2917: fnd_message.set_token('TABLE', 'HZ_PARTIES');
2918: fnd_msg_pub.add;
2919: RAISE fnd_api.g_exc_error;
2920: END IF;

Line 2917: fnd_message.set_token('TABLE', 'HZ_PARTIES');

2913: l_party_object_version_number IS NOT NULL AND
2914: p_party_object_version_number = l_party_object_version_number))
2915: THEN
2916: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
2917: fnd_message.set_token('TABLE', 'HZ_PARTIES');
2918: fnd_msg_pub.add;
2919: RAISE fnd_api.g_exc_error;
2920: END IF;
2921: CLOSE c_party;

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

3499: AND PARTY_TYPE_CODE = 'THIRD_PARTY'
3500: AND ROWNUM = 1;
3501: EXCEPTION
3502: WHEN NO_DATA_FOUND THEN
3503: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
3504: fnd_message.set_token('RECORD', 'ZX_PARTY_TAX_PROFILE');
3505: fnd_message.set_token('VALUE', to_char(p_party_id) || ', THIRD_PARTY');
3506: fnd_msg_pub.add;
3507: RAISE FND_API.G_EXC_ERROR;

Line 3504: fnd_message.set_token('RECORD', 'ZX_PARTY_TAX_PROFILE');

3500: AND ROWNUM = 1;
3501: EXCEPTION
3502: WHEN NO_DATA_FOUND THEN
3503: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
3504: fnd_message.set_token('RECORD', 'ZX_PARTY_TAX_PROFILE');
3505: fnd_message.set_token('VALUE', to_char(p_party_id) || ', THIRD_PARTY');
3506: fnd_msg_pub.add;
3507: RAISE FND_API.G_EXC_ERROR;
3508: END;

Line 3505: fnd_message.set_token('VALUE', to_char(p_party_id) || ', THIRD_PARTY');

3501: EXCEPTION
3502: WHEN NO_DATA_FOUND THEN
3503: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
3504: fnd_message.set_token('RECORD', 'ZX_PARTY_TAX_PROFILE');
3505: fnd_message.set_token('VALUE', to_char(p_party_id) || ', THIRD_PARTY');
3506: fnd_msg_pub.add;
3507: RAISE FND_API.G_EXC_ERROR;
3508: END;
3509:

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

3611:
3612:
3613: EXCEPTION
3614: WHEN g_resource_busy THEN
3615: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
3616: fnd_message.set_token('TABLE', 'hz_parties');
3617: fnd_msg_pub.add;
3618: RAISE fnd_api.g_exc_error;
3619:

Line 3616: fnd_message.set_token('TABLE', 'hz_parties');

3612:
3613: EXCEPTION
3614: WHEN g_resource_busy THEN
3615: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
3616: fnd_message.set_token('TABLE', 'hz_parties');
3617: fnd_msg_pub.add;
3618: RAISE fnd_api.g_exc_error;
3619:
3620: END do_create_update_party_only;

Line 3819: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');

3815: IF p_group_rec.party_rec.party_id IS NOT NULL AND
3816: p_group_rec.party_rec.party_id <> FND_API.G_MISS_NUM AND
3817: party_exists(p_party_type, p_group_rec.party_rec.party_id, l_party_number) = 'Y'
3818: THEN
3819: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
3820: fnd_message.set_token('COLUMN', 'party_id');
3821: fnd_msg_pub.add;
3822: RAISE FND_API.G_EXC_ERROR;
3823: END IF;

Line 3820: fnd_message.set_token('COLUMN', 'party_id');

3816: p_group_rec.party_rec.party_id <> FND_API.G_MISS_NUM AND
3817: party_exists(p_party_type, p_group_rec.party_rec.party_id, l_party_number) = 'Y'
3818: THEN
3819: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
3820: fnd_message.set_token('COLUMN', 'party_id');
3821: fnd_msg_pub.add;
3822: RAISE FND_API.G_EXC_ERROR;
3823: END IF;
3824:

Line 3872: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');

3868: IF l_party_id IS NOT NULL AND
3869: l_party_id <> FND_API.G_MISS_NUM AND
3870: party_exists(p_party_type, l_party_id, l_party_number) = 'Y'
3871: THEN
3872: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
3873: fnd_message.set_token('COLUMN', 'party_id');
3874: fnd_msg_pub.add;
3875: RAISE FND_API.G_EXC_ERROR;
3876: END IF;

Line 3873: fnd_message.set_token('COLUMN', 'party_id');

3869: l_party_id <> FND_API.G_MISS_NUM AND
3870: party_exists(p_party_type, l_party_id, l_party_number) = 'Y'
3871: THEN
3872: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
3873: fnd_message.set_token('COLUMN', 'party_id');
3874: fnd_msg_pub.add;
3875: RAISE FND_API.G_EXC_ERROR;
3876: END IF;
3877:

Line 3945: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');

3941: THEN
3942: IF party_profile_exists(
3943: p_party_type, l_party_id, l_data_source_type) = 'Y'
3944: THEN
3945: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
3946: fnd_message.set_token('COLUMN', 'party_id,'||l_data_source_from);
3947: fnd_msg_pub.add;
3948: RAISE FND_API.G_EXC_ERROR;
3949: ELSE

Line 3946: fnd_message.set_token('COLUMN', 'party_id,'||l_data_source_from);

3942: IF party_profile_exists(
3943: p_party_type, l_party_id, l_data_source_type) = 'Y'
3944: THEN
3945: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
3946: fnd_message.set_token('COLUMN', 'party_id,'||l_data_source_from);
3947: fnd_msg_pub.add;
3948: RAISE FND_API.G_EXC_ERROR;
3949: ELSE
3950: x_party_id := l_party_id;

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

5008: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then
5009: --
5010: -- Bug 3835601: replaced the dss message with a more user friendly message
5011: --
5012: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_INSERT_PRIVILEGE');
5013: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
5014: hz_dss_util_pub.get_display_name(null, 'PERSON'));
5015: FND_MSG_PUB.ADD;
5016: RAISE FND_API.G_EXC_ERROR;

Line 5013: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',

5009: --
5010: -- Bug 3835601: replaced the dss message with a more user friendly message
5011: --
5012: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_INSERT_PRIVILEGE');
5013: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
5014: hz_dss_util_pub.get_display_name(null, 'PERSON'));
5015: FND_MSG_PUB.ADD;
5016: RAISE FND_API.G_EXC_ERROR;
5017: end if;

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

5132: END IF;
5133:
5134: x_return_status := fnd_api.g_ret_sts_unexp_error;
5135:
5136: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5137: fnd_message.set_token('ERROR',SQLERRM);
5138: fnd_msg_pub.add;
5139:
5140: fnd_msg_pub.count_and_get(

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

5133:
5134: x_return_status := fnd_api.g_ret_sts_unexp_error;
5135:
5136: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5137: fnd_message.set_token('ERROR',SQLERRM);
5138: fnd_msg_pub.add;
5139:
5140: fnd_msg_pub.count_and_get(
5141: p_encoded => fnd_api.g_false,

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

5339: WHERE PARTY_ID = p_person_rec.party_rec.party_id
5340: AND PARTY_TYPE = 'PERSON';
5341: EXCEPTION
5342: WHEN NO_DATA_FOUND THEN
5343: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
5344: fnd_message.set_token('RECORD', 'person');
5345: fnd_message.set_token('VALUE', to_char(p_person_rec.party_rec.party_id));
5346: fnd_msg_pub.add;
5347: RAISE FND_API.G_EXC_ERROR;

Line 5344: fnd_message.set_token('RECORD', 'person');

5340: AND PARTY_TYPE = 'PERSON';
5341: EXCEPTION
5342: WHEN NO_DATA_FOUND THEN
5343: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
5344: fnd_message.set_token('RECORD', 'person');
5345: fnd_message.set_token('VALUE', to_char(p_person_rec.party_rec.party_id));
5346: fnd_msg_pub.add;
5347: RAISE FND_API.G_EXC_ERROR;
5348: END;

Line 5345: fnd_message.set_token('VALUE', to_char(p_person_rec.party_rec.party_id));

5341: EXCEPTION
5342: WHEN NO_DATA_FOUND THEN
5343: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
5344: fnd_message.set_token('RECORD', 'person');
5345: fnd_message.set_token('VALUE', to_char(p_person_rec.party_rec.party_id));
5346: fnd_msg_pub.add;
5347: RAISE FND_API.G_EXC_ERROR;
5348: END;
5349: **/

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

5413: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then
5414: --
5415: -- Bug 3835601: replaced the dss message with a more user friendly message
5416: --
5417: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
5418: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
5419: hz_dss_util_pub.get_display_name(null, 'PERSON'));
5420: FND_MSG_PUB.ADD;
5421: RAISE FND_API.G_EXC_ERROR;

Line 5418: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',

5414: --
5415: -- Bug 3835601: replaced the dss message with a more user friendly message
5416: --
5417: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
5418: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
5419: hz_dss_util_pub.get_display_name(null, 'PERSON'));
5420: FND_MSG_PUB.ADD;
5421: RAISE FND_API.G_EXC_ERROR;
5422: end if;

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

5549: END IF;
5550:
5551: x_return_status := fnd_api.g_ret_sts_unexp_error;
5552:
5553: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5554: fnd_message.set_token('ERROR',SQLERRM);
5555: fnd_msg_pub.add;
5556:
5557: fnd_msg_pub.count_and_get(

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

5550:
5551: x_return_status := fnd_api.g_ret_sts_unexp_error;
5552:
5553: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5554: fnd_message.set_token('ERROR',SQLERRM);
5555: fnd_msg_pub.add;
5556:
5557: fnd_msg_pub.count_and_get(
5558: p_encoded => fnd_api.g_false,

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

5701: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then
5702: --
5703: -- Bug 3835601: replaced the dss message with a more user friendly message
5704: --
5705: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_INSERT_PRIVILEGE');
5706: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
5707: hz_dss_util_pub.get_display_name('HZ_PARTIES', null));
5708: FND_MSG_PUB.ADD;
5709: RAISE FND_API.G_EXC_ERROR;

Line 5706: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',

5702: --
5703: -- Bug 3835601: replaced the dss message with a more user friendly message
5704: --
5705: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_INSERT_PRIVILEGE');
5706: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
5707: hz_dss_util_pub.get_display_name('HZ_PARTIES', null));
5708: FND_MSG_PUB.ADD;
5709: RAISE FND_API.G_EXC_ERROR;
5710: end if;

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

5831: END IF;
5832:
5833: x_return_status := fnd_api.g_ret_sts_unexp_error;
5834:
5835: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5836: fnd_message.set_token('ERROR',SQLERRM);
5837: fnd_msg_pub.add;
5838:
5839: fnd_msg_pub.count_and_get(

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

5832:
5833: x_return_status := fnd_api.g_ret_sts_unexp_error;
5834:
5835: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5836: fnd_message.set_token('ERROR',SQLERRM);
5837: fnd_msg_pub.add;
5838:
5839: fnd_msg_pub.count_and_get(
5840: p_encoded => fnd_api.g_false,

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

5963: WHERE PARTY_ID = p_group_rec.party_rec.party_id
5964: AND PARTY_TYPE = 'GROUP';
5965: EXCEPTION
5966: WHEN NO_DATA_FOUND THEN
5967: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
5968: fnd_message.set_token('RECORD', 'group');
5969: fnd_message.set_token('VALUE', to_char(p_group_rec.party_rec.party_id));
5970: fnd_msg_pub.add;
5971: RAISE FND_API.G_EXC_ERROR;

Line 5968: fnd_message.set_token('RECORD', 'group');

5964: AND PARTY_TYPE = 'GROUP';
5965: EXCEPTION
5966: WHEN NO_DATA_FOUND THEN
5967: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
5968: fnd_message.set_token('RECORD', 'group');
5969: fnd_message.set_token('VALUE', to_char(p_group_rec.party_rec.party_id));
5970: fnd_msg_pub.add;
5971: RAISE FND_API.G_EXC_ERROR;
5972: END;

Line 5969: fnd_message.set_token('VALUE', to_char(p_group_rec.party_rec.party_id));

5965: EXCEPTION
5966: WHEN NO_DATA_FOUND THEN
5967: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
5968: fnd_message.set_token('RECORD', 'group');
5969: fnd_message.set_token('VALUE', to_char(p_group_rec.party_rec.party_id));
5970: fnd_msg_pub.add;
5971: RAISE FND_API.G_EXC_ERROR;
5972: END;
5973: **/

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

6025: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then
6026: --
6027: -- Bug 3835601: replaced the dss message with a more user friendly message
6028: --
6029: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
6030: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
6031: hz_dss_util_pub.get_display_name('HZ_PARTIES', null));
6032: FND_MSG_PUB.ADD;
6033: RAISE FND_API.G_EXC_ERROR;

Line 6030: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',

6026: --
6027: -- Bug 3835601: replaced the dss message with a more user friendly message
6028: --
6029: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
6030: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
6031: hz_dss_util_pub.get_display_name('HZ_PARTIES', null));
6032: FND_MSG_PUB.ADD;
6033: RAISE FND_API.G_EXC_ERROR;
6034: end if;

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

6165: END IF;
6166:
6167: x_return_status := fnd_api.g_ret_sts_unexp_error;
6168:
6169: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6170: fnd_message.set_token('ERROR',SQLERRM);
6171: fnd_msg_pub.add;
6172:
6173: fnd_msg_pub.count_and_get(

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

6166:
6167: x_return_status := fnd_api.g_ret_sts_unexp_error;
6168:
6169: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6170: fnd_message.set_token('ERROR',SQLERRM);
6171: fnd_msg_pub.add;
6172:
6173: fnd_msg_pub.count_and_get(
6174: p_encoded => fnd_api.g_false,

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

6371: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then
6372: --
6373: -- Bug 3835601: replaced the dss message with a more user friendly message
6374: --
6375: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_INSERT_PRIVILEGE');
6376: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
6377: hz_dss_util_pub.get_display_name(null, 'ORGANIZATION'));
6378: FND_MSG_PUB.ADD;
6379: RAISE FND_API.G_EXC_ERROR;

Line 6376: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',

6372: --
6373: -- Bug 3835601: replaced the dss message with a more user friendly message
6374: --
6375: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_INSERT_PRIVILEGE');
6376: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
6377: hz_dss_util_pub.get_display_name(null, 'ORGANIZATION'));
6378: FND_MSG_PUB.ADD;
6379: RAISE FND_API.G_EXC_ERROR;
6380: end if;

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

6496: END IF;
6497:
6498: x_return_status := fnd_api.g_ret_sts_unexp_error;
6499:
6500: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6501: fnd_message.set_token('ERROR',SQLERRM);
6502: fnd_msg_pub.add;
6503:
6504: fnd_msg_pub.count_and_get(

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

6497:
6498: x_return_status := fnd_api.g_ret_sts_unexp_error;
6499:
6500: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6501: fnd_message.set_token('ERROR',SQLERRM);
6502: fnd_msg_pub.add;
6503:
6504: fnd_msg_pub.count_and_get(
6505: p_encoded => fnd_api.g_false,

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

6713: OPEN c_orgchk;
6714: FETCH c_orgchk INTO l_count;
6715: IF c_orgchk%NOTFOUND THEN
6716: CLOSE c_orgchk;
6717: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
6718: fnd_message.set_token('RECORD', 'organization');
6719: fnd_message.set_token('VALUE',TO_CHAR(l_organization_rec.party_rec.party_id));
6720: fnd_msg_pub.add;
6721: RAISE fnd_api.g_exc_error;

Line 6718: fnd_message.set_token('RECORD', 'organization');

6714: FETCH c_orgchk INTO l_count;
6715: IF c_orgchk%NOTFOUND THEN
6716: CLOSE c_orgchk;
6717: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
6718: fnd_message.set_token('RECORD', 'organization');
6719: fnd_message.set_token('VALUE',TO_CHAR(l_organization_rec.party_rec.party_id));
6720: fnd_msg_pub.add;
6721: RAISE fnd_api.g_exc_error;
6722: END IF;

Line 6719: fnd_message.set_token('VALUE',TO_CHAR(l_organization_rec.party_rec.party_id));

6715: IF c_orgchk%NOTFOUND THEN
6716: CLOSE c_orgchk;
6717: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
6718: fnd_message.set_token('RECORD', 'organization');
6719: fnd_message.set_token('VALUE',TO_CHAR(l_organization_rec.party_rec.party_id));
6720: fnd_msg_pub.add;
6721: RAISE fnd_api.g_exc_error;
6722: END IF;
6723: CLOSE c_orgchk;

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

6790: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then
6791: --
6792: -- Bug 3835601: replaced the message with a more user friendly message
6793: --
6794: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
6795: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
6796: hz_dss_util_pub.get_display_name(null, 'ORGANIZATION'));
6797: FND_MSG_PUB.ADD;
6798: RAISE FND_API.G_EXC_ERROR;

Line 6795: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',

6791: --
6792: -- Bug 3835601: replaced the message with a more user friendly message
6793: --
6794: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
6795: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
6796: hz_dss_util_pub.get_display_name(null, 'ORGANIZATION'));
6797: FND_MSG_PUB.ADD;
6798: RAISE FND_API.G_EXC_ERROR;
6799: end if;

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

6976: END IF;
6977:
6978: x_return_status := fnd_api.g_ret_sts_unexp_error;
6979:
6980: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6981: fnd_message.set_token('ERROR',SQLERRM);
6982: fnd_msg_pub.add;
6983:
6984: fnd_msg_pub.count_and_get(

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

6977:
6978: x_return_status := fnd_api.g_ret_sts_unexp_error;
6979:
6980: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6981: fnd_message.set_token('ERROR',SQLERRM);
6982: fnd_msg_pub.add;
6983:
6984: fnd_msg_pub.count_and_get(
6985: p_encoded => fnd_api.g_false,

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

7115: --Check whether primary key has been passed in.
7116: IF p_party_id IS NULL OR
7117: p_party_id = fnd_api.g_miss_num
7118: THEN
7119: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
7120: fnd_message.set_token('COLUMN', 'p_party_id');
7121: fnd_msg_pub.add;
7122: RAISE fnd_api.g_exc_error;
7123: END IF;

Line 7120: fnd_message.set_token('COLUMN', 'p_party_id');

7116: IF p_party_id IS NULL OR
7117: p_party_id = fnd_api.g_miss_num
7118: THEN
7119: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
7120: fnd_message.set_token('COLUMN', 'p_party_id');
7121: fnd_msg_pub.add;
7122: RAISE fnd_api.g_exc_error;
7123: END IF;
7124:

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

7124:
7125: IF p_content_source_type IS NULL OR
7126: p_content_source_type = fnd_api.g_miss_char
7127: THEN
7128: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
7129: fnd_message.set_token('COLUMN', 'p_content_source_type');
7130: fnd_msg_pub.add;
7131: RAISE fnd_api.g_exc_error;
7132: END IF;

Line 7129: fnd_message.set_token('COLUMN', 'p_content_source_type');

7125: IF p_content_source_type IS NULL OR
7126: p_content_source_type = fnd_api.g_miss_char
7127: THEN
7128: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
7129: fnd_message.set_token('COLUMN', 'p_content_source_type');
7130: fnd_msg_pub.add;
7131: RAISE fnd_api.g_exc_error;
7132: END IF;
7133:

Line 7153: fnd_message.set_name('AR', 'HZ_NO_PROFILE_PRESENT');

7149: CLOSE c_org;
7150: END IF;
7151:
7152: IF l_error THEN
7153: fnd_message.set_name('AR', 'HZ_NO_PROFILE_PRESENT');
7154: fnd_message.set_token('PARTY_ID', TO_CHAR(p_party_id));
7155: fnd_message.set_token('CONTENT_SOURCE_TYPE', p_content_source_type);
7156: fnd_msg_pub.add;
7157: RAISE fnd_api.g_exc_error;

Line 7154: fnd_message.set_token('PARTY_ID', TO_CHAR(p_party_id));

7150: END IF;
7151:
7152: IF l_error THEN
7153: fnd_message.set_name('AR', 'HZ_NO_PROFILE_PRESENT');
7154: fnd_message.set_token('PARTY_ID', TO_CHAR(p_party_id));
7155: fnd_message.set_token('CONTENT_SOURCE_TYPE', p_content_source_type);
7156: fnd_msg_pub.add;
7157: RAISE fnd_api.g_exc_error;
7158: END IF;

Line 7155: fnd_message.set_token('CONTENT_SOURCE_TYPE', p_content_source_type);

7151:
7152: IF l_error THEN
7153: fnd_message.set_name('AR', 'HZ_NO_PROFILE_PRESENT');
7154: fnd_message.set_token('PARTY_ID', TO_CHAR(p_party_id));
7155: fnd_message.set_token('CONTENT_SOURCE_TYPE', p_content_source_type);
7156: fnd_msg_pub.add;
7157: RAISE fnd_api.g_exc_error;
7158: END IF;
7159:

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

7389: END IF;
7390:
7391: x_return_status := fnd_api.g_ret_sts_unexp_error;
7392:
7393: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
7394: fnd_message.set_token('ERROR',SQLERRM);
7395: fnd_msg_pub.add;
7396:
7397: fnd_msg_pub.count_and_get(

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

7390:
7391: x_return_status := fnd_api.g_ret_sts_unexp_error;
7392:
7393: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
7394: fnd_message.set_token('ERROR',SQLERRM);
7395: fnd_msg_pub.add;
7396:
7397: fnd_msg_pub.count_and_get(
7398: p_encoded => fnd_api.g_false,

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

7496: --Check whether primary key has been passed in.
7497: IF p_party_id IS NULL OR
7498: p_party_id = fnd_api.g_miss_num
7499: THEN
7500: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
7501: fnd_message.set_token('COLUMN', 'p_party_id');
7502: fnd_msg_pub.add;
7503: RAISE fnd_api.g_exc_error;
7504: END IF;

Line 7501: fnd_message.set_token('COLUMN', 'p_party_id');

7497: IF p_party_id IS NULL OR
7498: p_party_id = fnd_api.g_miss_num
7499: THEN
7500: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
7501: fnd_message.set_token('COLUMN', 'p_party_id');
7502: fnd_msg_pub.add;
7503: RAISE fnd_api.g_exc_error;
7504: END IF;
7505:

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

7505:
7506: IF p_content_source_type IS NULL OR
7507: p_content_source_type = FND_API.G_MISS_CHAR
7508: THEN
7509: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
7510: fnd_message.set_token('COLUMN', 'p_content_source_type');
7511: fnd_msg_pub.add;
7512: RAISE fnd_api.g_exc_error;
7513: END IF;

Line 7510: fnd_message.set_token('COLUMN', 'p_content_source_type');

7506: IF p_content_source_type IS NULL OR
7507: p_content_source_type = FND_API.G_MISS_CHAR
7508: THEN
7509: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
7510: fnd_message.set_token('COLUMN', 'p_content_source_type');
7511: fnd_msg_pub.add;
7512: RAISE fnd_api.g_exc_error;
7513: END IF;
7514:

Line 7534: fnd_message.set_name('AR', 'HZ_NO_PROFILE_PRESENT');

7530: CLOSE c_per;
7531: END IF;
7532:
7533: IF l_error THEN
7534: fnd_message.set_name('AR', 'HZ_NO_PROFILE_PRESENT');
7535: fnd_message.set_token('PARTY_ID', TO_CHAR(p_party_id));
7536: fnd_message.set_token('CONTENT_SOURCE_TYPE', p_content_source_type);
7537: fnd_msg_pub.add;
7538: RAISE fnd_api.g_exc_error;

Line 7535: fnd_message.set_token('PARTY_ID', TO_CHAR(p_party_id));

7531: END IF;
7532:
7533: IF l_error THEN
7534: fnd_message.set_name('AR', 'HZ_NO_PROFILE_PRESENT');
7535: fnd_message.set_token('PARTY_ID', TO_CHAR(p_party_id));
7536: fnd_message.set_token('CONTENT_SOURCE_TYPE', p_content_source_type);
7537: fnd_msg_pub.add;
7538: RAISE fnd_api.g_exc_error;
7539: END IF;

Line 7536: fnd_message.set_token('CONTENT_SOURCE_TYPE', p_content_source_type);

7532:
7533: IF l_error THEN
7534: fnd_message.set_name('AR', 'HZ_NO_PROFILE_PRESENT');
7535: fnd_message.set_token('PARTY_ID', TO_CHAR(p_party_id));
7536: fnd_message.set_token('CONTENT_SOURCE_TYPE', p_content_source_type);
7537: fnd_msg_pub.add;
7538: RAISE fnd_api.g_exc_error;
7539: END IF;
7540:

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

7659: END IF;
7660:
7661: x_return_status := fnd_api.g_ret_sts_unexp_error;
7662:
7663: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
7664: fnd_message.set_token('ERROR',SQLERRM);
7665: fnd_msg_pub.add;
7666:
7667: fnd_msg_pub.count_and_get(

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

7660:
7661: x_return_status := fnd_api.g_ret_sts_unexp_error;
7662:
7663: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
7664: fnd_message.set_token('ERROR',SQLERRM);
7665: fnd_msg_pub.add;
7666:
7667: fnd_msg_pub.count_and_get(
7668: p_encoded => fnd_api.g_false,

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

7754: --Check whether primary key has been passed in.
7755: IF p_party_id IS NULL OR
7756: p_party_id = fnd_api.g_miss_num
7757: THEN
7758: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
7759: fnd_message.set_token('COLUMN', 'party_id');
7760: fnd_msg_pub.add;
7761: RAISE fnd_api.g_exc_error;
7762: END IF;

Line 7759: fnd_message.set_token('COLUMN', 'party_id');

7755: IF p_party_id IS NULL OR
7756: p_party_id = fnd_api.g_miss_num
7757: THEN
7758: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
7759: fnd_message.set_token('COLUMN', 'party_id');
7760: fnd_msg_pub.add;
7761: RAISE fnd_api.g_exc_error;
7762: END IF;
7763:

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

7768: END IF;
7769: CLOSE c_group;
7770:
7771: IF l_error THEN
7772: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
7773: fnd_message.set_token('RECORD', 'group');
7774: fnd_message.set_token('VALUE', to_char(p_party_id));
7775: fnd_msg_pub.add;
7776: RAISE fnd_api.g_exc_error;

Line 7773: fnd_message.set_token('RECORD', 'group');

7769: CLOSE c_group;
7770:
7771: IF l_error THEN
7772: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
7773: fnd_message.set_token('RECORD', 'group');
7774: fnd_message.set_token('VALUE', to_char(p_party_id));
7775: fnd_msg_pub.add;
7776: RAISE fnd_api.g_exc_error;
7777: END IF;

Line 7774: fnd_message.set_token('VALUE', to_char(p_party_id));

7770:
7771: IF l_error THEN
7772: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
7773: fnd_message.set_token('RECORD', 'group');
7774: fnd_message.set_token('VALUE', to_char(p_party_id));
7775: fnd_msg_pub.add;
7776: RAISE fnd_api.g_exc_error;
7777: END IF;
7778:

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

7890:
7891: WHEN OTHERS THEN
7892: x_return_status := fnd_api.g_ret_sts_unexp_error;
7893:
7894: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
7895: fnd_message.set_token('ERROR',SQLERRM);
7896: fnd_msg_pub.add;
7897:
7898: fnd_msg_pub.count_and_get(

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

7891: WHEN OTHERS THEN
7892: x_return_status := fnd_api.g_ret_sts_unexp_error;
7893:
7894: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
7895: fnd_message.set_token('ERROR',SQLERRM);
7896: fnd_msg_pub.add;
7897:
7898: fnd_msg_pub.count_and_get(
7899: p_encoded => fnd_api.g_false,

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

7978: --Check whether primary key has been passed in.
7979: IF p_party_id IS NULL OR
7980: p_party_id = fnd_api.g_miss_num
7981: THEN
7982: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
7983: fnd_message.set_token('COLUMN', 'party_id');
7984: fnd_msg_pub.add;
7985: RAISE fnd_api.g_exc_error;
7986: END IF;

Line 7983: fnd_message.set_token('COLUMN', 'party_id');

7979: IF p_party_id IS NULL OR
7980: p_party_id = fnd_api.g_miss_num
7981: THEN
7982: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
7983: fnd_message.set_token('COLUMN', 'party_id');
7984: fnd_msg_pub.add;
7985: RAISE fnd_api.g_exc_error;
7986: END IF;
7987:

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

8098:
8099: WHEN OTHERS THEN
8100: x_return_status := fnd_api.g_ret_sts_unexp_error;
8101:
8102: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
8103: fnd_message.set_token('ERROR',SQLERRM);
8104: fnd_msg_pub.add;
8105:
8106: fnd_msg_pub.count_and_get(

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

8099: WHEN OTHERS THEN
8100: x_return_status := fnd_api.g_ret_sts_unexp_error;
8101:
8102: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
8103: fnd_message.set_token('ERROR',SQLERRM);
8104: fnd_msg_pub.add;
8105:
8106: fnd_msg_pub.count_and_get(
8107: p_encoded => fnd_api.g_false,