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

402: x_party_number := l_party_number;
403: RETURN 'Y';
404: ELSE
405: /* new message */
406: fnd_message.set_name('AR','HZ_DUP_PARTY_WITH_PARTY_TYPE');
407: fnd_message.set_token('PARTY_ID', p_party_id);
408: fnd_message.set_token('PARTY_TYPE', l_party_type);
409: fnd_msg_pub.add;
410: RAISE FND_API.G_EXC_ERROR;

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

403: RETURN 'Y';
404: ELSE
405: /* new message */
406: fnd_message.set_name('AR','HZ_DUP_PARTY_WITH_PARTY_TYPE');
407: fnd_message.set_token('PARTY_ID', p_party_id);
408: fnd_message.set_token('PARTY_TYPE', l_party_type);
409: fnd_msg_pub.add;
410: RAISE FND_API.G_EXC_ERROR;
411: END IF;

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

404: ELSE
405: /* new message */
406: fnd_message.set_name('AR','HZ_DUP_PARTY_WITH_PARTY_TYPE');
407: fnd_message.set_token('PARTY_ID', p_party_id);
408: fnd_message.set_token('PARTY_TYPE', l_party_type);
409: fnd_msg_pub.add;
410: RAISE FND_API.G_EXC_ERROR;
411: END IF;
412:

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

751: WHERE PARTY_ID = i_party_id(i)
752: FOR UPDATE NOWAIT;
753: EXCEPTION
754: WHEN OTHERS THEN
755: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
756: fnd_message.set_token('TABLE', 'HZ_PARTIES');
757: fnd_msg_pub.add;
758: RAISE FND_API.G_EXC_ERROR;
759: END;

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

752: FOR UPDATE NOWAIT;
753: EXCEPTION
754: WHEN OTHERS THEN
755: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
756: fnd_message.set_token('TABLE', 'HZ_PARTIES');
757: fnd_msg_pub.add;
758: RAISE FND_API.G_EXC_ERROR;
759: END;
760:

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

1126: l_sic_code <> FND_API.G_MISS_CHAR) OR
1127: (l_sic_code = FND_API.G_MISS_CHAR AND
1128: l_sic_code_type <> FND_API.G_MISS_CHAR)
1129: THEN
1130: fnd_message.set_name('AR', 'HZ_API_SIC_CODE_TYPE_REQUIRED');
1131: fnd_msg_pub.add;
1132: RAISE FND_API.G_EXC_ERROR;
1133: END IF;
1134:

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

1137:
1138: IF l_sic_code_type = 'OTHER' AND
1139: l_data_source_type <> G_MISS_CONTENT_SOURCE_TYPE
1140: THEN
1141: fnd_message.set_name('AR', 'HZ_API_SIC_CODE_TYPE_OTHER');
1142: fnd_msg_pub.add;
1143: RAISE FND_API.G_EXC_ERROR;
1144: END IF;
1145:

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

1481: l_person_profile_id, l_rowid,l_object_version_number,
1482: l_version_number, l_effective_start_date;
1483:
1484: IF c_person%NOTFOUND THEN
1485: fnd_message.set_name('AR', 'HZ_NO_PROFILE_PRESENT');
1486: fnd_message.set_token('PARTY_ID', TO_CHAR(p_person_rec.party_rec.party_id));
1487: fnd_message.set_token('CONTENT_SOURCE_TYPE', p_data_source_type);
1488: fnd_msg_pub.add;
1489: RAISE fnd_api.g_exc_error;

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

1482: l_version_number, l_effective_start_date;
1483:
1484: IF c_person%NOTFOUND THEN
1485: fnd_message.set_name('AR', 'HZ_NO_PROFILE_PRESENT');
1486: fnd_message.set_token('PARTY_ID', TO_CHAR(p_person_rec.party_rec.party_id));
1487: fnd_message.set_token('CONTENT_SOURCE_TYPE', p_data_source_type);
1488: fnd_msg_pub.add;
1489: RAISE fnd_api.g_exc_error;
1490: END IF;

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

1483:
1484: IF c_person%NOTFOUND THEN
1485: fnd_message.set_name('AR', 'HZ_NO_PROFILE_PRESENT');
1486: fnd_message.set_token('PARTY_ID', TO_CHAR(p_person_rec.party_rec.party_id));
1487: fnd_message.set_token('CONTENT_SOURCE_TYPE', p_data_source_type);
1488: fnd_msg_pub.add;
1489: RAISE fnd_api.g_exc_error;
1490: END IF;
1491: CLOSE c_person;

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

1720: END IF;
1721:
1722: EXCEPTION
1723: WHEN g_resource_busy THEN
1724: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
1725: fnd_message.set_token('TABLE', 'HZ_PERSON_PROFILES');
1726: fnd_msg_pub.add;
1727: RAISE fnd_api.g_exc_error;
1728:

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

1721:
1722: EXCEPTION
1723: WHEN g_resource_busy THEN
1724: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
1725: fnd_message.set_token('TABLE', 'HZ_PERSON_PROFILES');
1726: fnd_msg_pub.add;
1727: RAISE fnd_api.g_exc_error;
1728:
1729: END do_update_person_profile;

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

2043: l_rowid, l_organization_profile_id,l_object_version_number,
2044: l_version_number,l_effective_start_date;
2045:
2046: IF c_org%NOTFOUND THEN
2047: fnd_message.set_name('AR', 'HZ_NO_PROFILE_PRESENT');
2048: fnd_message.set_token('PARTY_ID', TO_CHAR(p_organization_rec.party_rec.party_id));
2049: fnd_message.set_token('CONTENT_SOURCE_TYPE', p_data_source_type);
2050: fnd_msg_pub.add;
2051: RAISE fnd_api.g_exc_error;

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

2044: l_version_number,l_effective_start_date;
2045:
2046: IF c_org%NOTFOUND THEN
2047: fnd_message.set_name('AR', 'HZ_NO_PROFILE_PRESENT');
2048: fnd_message.set_token('PARTY_ID', TO_CHAR(p_organization_rec.party_rec.party_id));
2049: fnd_message.set_token('CONTENT_SOURCE_TYPE', p_data_source_type);
2050: fnd_msg_pub.add;
2051: RAISE fnd_api.g_exc_error;
2052: END IF;

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

2045:
2046: IF c_org%NOTFOUND THEN
2047: fnd_message.set_name('AR', 'HZ_NO_PROFILE_PRESENT');
2048: fnd_message.set_token('PARTY_ID', TO_CHAR(p_organization_rec.party_rec.party_id));
2049: fnd_message.set_token('CONTENT_SOURCE_TYPE', p_data_source_type);
2050: fnd_msg_pub.add;
2051: RAISE fnd_api.g_exc_error;
2052: END IF;
2053: CLOSE c_org;

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

2338: END IF;
2339:
2340: EXCEPTION
2341: WHEN g_resource_busy THEN
2342: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
2343: fnd_message.set_token('TABLE', 'HZ_ORGANIZATION_PROFILES');
2344: fnd_msg_pub.add;
2345: RAISE fnd_api.g_exc_error;
2346:

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

2339:
2340: EXCEPTION
2341: WHEN g_resource_busy THEN
2342: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
2343: fnd_message.set_token('TABLE', 'HZ_ORGANIZATION_PROFILES');
2344: fnd_msg_pub.add;
2345: RAISE fnd_api.g_exc_error;
2346:
2347: END do_update_org_profile;

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

2810:
2811: IF l_party_rec.party_number = FND_API.G_MISS_CHAR OR
2812: l_party_rec.party_number IS NULL
2813: THEN
2814: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
2815: fnd_message.set_token('COLUMN', 'party number');
2816: fnd_msg_pub.add;
2817: RAISE FND_API.G_EXC_ERROR;
2818: END IF;

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

2811: IF l_party_rec.party_number = FND_API.G_MISS_CHAR OR
2812: l_party_rec.party_number IS NULL
2813: THEN
2814: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
2815: fnd_message.set_token('COLUMN', 'party number');
2816: fnd_msg_pub.add;
2817: RAISE FND_API.G_EXC_ERROR;
2818: END IF;
2819:

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

2820: OPEN c_party_number_exists(l_party_rec.party_number);
2821: FETCH c_party_number_exists INTO l_dummy;
2822:
2823: IF NOT c_party_number_exists%NOTFOUND THEN
2824: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
2825: fnd_message.set_token('COLUMN', 'party_number');
2826: fnd_msg_pub.add;
2827: RAISE FND_API.G_EXC_ERROR;
2828: END IF;

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

2821: FETCH c_party_number_exists INTO l_dummy;
2822:
2823: IF NOT c_party_number_exists%NOTFOUND THEN
2824: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
2825: fnd_message.set_token('COLUMN', 'party_number');
2826: fnd_msg_pub.add;
2827: RAISE FND_API.G_EXC_ERROR;
2828: END IF;
2829: CLOSE c_party_number_exists;

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

2832:
2833: IF l_party_rec.party_number <> FND_API.G_MISS_CHAR AND
2834: l_party_rec.party_number IS NOT NULL
2835: THEN
2836: fnd_message.set_name('AR', 'HZ_API_PARTY_NUMBER_AUTO_ON');
2837: fnd_msg_pub.add;
2838: RAISE FND_API.G_EXC_ERROR;
2839: END IF;
2840:

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

2849: FETCH c_party INTO
2850: db_party_name, l_party_object_version_number, l_rowid, db_created_by_module;
2851:
2852: IF c_party%NOTFOUND THEN
2853: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
2854: fnd_message.set_token('RECORD', 'party');
2855: fnd_message.set_token('VALUE', NVL(TO_CHAR(p_party_id), 'NULL'));
2856: fnd_msg_pub.add;
2857: RAISE fnd_api.g_exc_error;

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

2850: db_party_name, l_party_object_version_number, l_rowid, db_created_by_module;
2851:
2852: IF c_party%NOTFOUND THEN
2853: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
2854: fnd_message.set_token('RECORD', 'party');
2855: fnd_message.set_token('VALUE', NVL(TO_CHAR(p_party_id), 'NULL'));
2856: fnd_msg_pub.add;
2857: RAISE fnd_api.g_exc_error;
2858: ELSIF p_check_object_version_number = 'Y' AND

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

2851:
2852: IF c_party%NOTFOUND THEN
2853: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
2854: fnd_message.set_token('RECORD', 'party');
2855: fnd_message.set_token('VALUE', NVL(TO_CHAR(p_party_id), 'NULL'));
2856: fnd_msg_pub.add;
2857: RAISE fnd_api.g_exc_error;
2858: ELSIF p_check_object_version_number = 'Y' AND
2859: NOT ((p_party_object_version_number IS NULL AND

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

2861: (p_party_object_version_number IS NOT NULL AND
2862: l_party_object_version_number IS NOT NULL AND
2863: p_party_object_version_number = l_party_object_version_number))
2864: THEN
2865: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
2866: fnd_message.set_token('TABLE', 'HZ_PARTIES');
2867: fnd_msg_pub.add;
2868: RAISE fnd_api.g_exc_error;
2869: END IF;

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

2862: l_party_object_version_number IS NOT NULL AND
2863: p_party_object_version_number = l_party_object_version_number))
2864: THEN
2865: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
2866: fnd_message.set_token('TABLE', 'HZ_PARTIES');
2867: fnd_msg_pub.add;
2868: RAISE fnd_api.g_exc_error;
2869: END IF;
2870: CLOSE c_party;

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

3448: AND PARTY_TYPE_CODE = 'THIRD_PARTY'
3449: AND ROWNUM = 1;
3450: EXCEPTION
3451: WHEN NO_DATA_FOUND THEN
3452: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
3453: fnd_message.set_token('RECORD', 'ZX_PARTY_TAX_PROFILE');
3454: fnd_message.set_token('VALUE', to_char(p_party_id) || ', THIRD_PARTY');
3455: fnd_msg_pub.add;
3456: RAISE FND_API.G_EXC_ERROR;

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

3449: AND ROWNUM = 1;
3450: EXCEPTION
3451: WHEN NO_DATA_FOUND THEN
3452: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
3453: fnd_message.set_token('RECORD', 'ZX_PARTY_TAX_PROFILE');
3454: fnd_message.set_token('VALUE', to_char(p_party_id) || ', THIRD_PARTY');
3455: fnd_msg_pub.add;
3456: RAISE FND_API.G_EXC_ERROR;
3457: END;

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

3450: EXCEPTION
3451: WHEN NO_DATA_FOUND THEN
3452: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
3453: fnd_message.set_token('RECORD', 'ZX_PARTY_TAX_PROFILE');
3454: fnd_message.set_token('VALUE', to_char(p_party_id) || ', THIRD_PARTY');
3455: fnd_msg_pub.add;
3456: RAISE FND_API.G_EXC_ERROR;
3457: END;
3458:

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

3560:
3561:
3562: EXCEPTION
3563: WHEN g_resource_busy THEN
3564: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
3565: fnd_message.set_token('TABLE', 'hz_parties');
3566: fnd_msg_pub.add;
3567: RAISE fnd_api.g_exc_error;
3568:

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

3561:
3562: EXCEPTION
3563: WHEN g_resource_busy THEN
3564: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
3565: fnd_message.set_token('TABLE', 'hz_parties');
3566: fnd_msg_pub.add;
3567: RAISE fnd_api.g_exc_error;
3568:
3569: END do_create_update_party_only;

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

3761: IF p_group_rec.party_rec.party_id IS NOT NULL AND
3762: p_group_rec.party_rec.party_id <> FND_API.G_MISS_NUM AND
3763: party_exists(p_party_type, p_group_rec.party_rec.party_id, l_party_number) = 'Y'
3764: THEN
3765: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
3766: fnd_message.set_token('COLUMN', 'party_id');
3767: fnd_msg_pub.add;
3768: RAISE FND_API.G_EXC_ERROR;
3769: END IF;

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

3762: p_group_rec.party_rec.party_id <> FND_API.G_MISS_NUM AND
3763: party_exists(p_party_type, p_group_rec.party_rec.party_id, l_party_number) = 'Y'
3764: THEN
3765: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
3766: fnd_message.set_token('COLUMN', 'party_id');
3767: fnd_msg_pub.add;
3768: RAISE FND_API.G_EXC_ERROR;
3769: END IF;
3770:

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

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

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

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

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

3886: THEN
3887: IF party_profile_exists(
3888: p_party_type, l_party_id, l_data_source_type) = 'Y'
3889: THEN
3890: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
3891: fnd_message.set_token('COLUMN', 'party_id,'||l_data_source_from);
3892: fnd_msg_pub.add;
3893: RAISE FND_API.G_EXC_ERROR;
3894: ELSE

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

3887: IF party_profile_exists(
3888: p_party_type, l_party_id, l_data_source_type) = 'Y'
3889: THEN
3890: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
3891: fnd_message.set_token('COLUMN', 'party_id,'||l_data_source_from);
3892: fnd_msg_pub.add;
3893: RAISE FND_API.G_EXC_ERROR;
3894: ELSE
3895: x_party_id := l_party_id;

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

4948: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then
4949: --
4950: -- Bug 3835601: replaced the dss message with a more user friendly message
4951: --
4952: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_INSERT_PRIVILEGE');
4953: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
4954: hz_dss_util_pub.get_display_name(null, 'PERSON'));
4955: FND_MSG_PUB.ADD;
4956: RAISE FND_API.G_EXC_ERROR;

Line 4953: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',

4949: --
4950: -- Bug 3835601: replaced the dss message with a more user friendly message
4951: --
4952: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_INSERT_PRIVILEGE');
4953: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
4954: hz_dss_util_pub.get_display_name(null, 'PERSON'));
4955: FND_MSG_PUB.ADD;
4956: RAISE FND_API.G_EXC_ERROR;
4957: end if;

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

5072: END IF;
5073:
5074: x_return_status := fnd_api.g_ret_sts_unexp_error;
5075:
5076: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5077: fnd_message.set_token('ERROR',SQLERRM);
5078: fnd_msg_pub.add;
5079:
5080: fnd_msg_pub.count_and_get(

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

5073:
5074: x_return_status := fnd_api.g_ret_sts_unexp_error;
5075:
5076: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5077: fnd_message.set_token('ERROR',SQLERRM);
5078: fnd_msg_pub.add;
5079:
5080: fnd_msg_pub.count_and_get(
5081: p_encoded => fnd_api.g_false,

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

5268: WHERE PARTY_ID = p_person_rec.party_rec.party_id
5269: AND PARTY_TYPE = 'PERSON';
5270: EXCEPTION
5271: WHEN NO_DATA_FOUND THEN
5272: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
5273: fnd_message.set_token('RECORD', 'person');
5274: fnd_message.set_token('VALUE', to_char(p_person_rec.party_rec.party_id));
5275: fnd_msg_pub.add;
5276: RAISE FND_API.G_EXC_ERROR;

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

5269: AND PARTY_TYPE = 'PERSON';
5270: EXCEPTION
5271: WHEN NO_DATA_FOUND THEN
5272: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
5273: fnd_message.set_token('RECORD', 'person');
5274: fnd_message.set_token('VALUE', to_char(p_person_rec.party_rec.party_id));
5275: fnd_msg_pub.add;
5276: RAISE FND_API.G_EXC_ERROR;
5277: END;

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

5270: EXCEPTION
5271: WHEN NO_DATA_FOUND THEN
5272: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
5273: fnd_message.set_token('RECORD', 'person');
5274: fnd_message.set_token('VALUE', to_char(p_person_rec.party_rec.party_id));
5275: fnd_msg_pub.add;
5276: RAISE FND_API.G_EXC_ERROR;
5277: END;
5278: **/

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

5342: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then
5343: --
5344: -- Bug 3835601: replaced the dss message with a more user friendly message
5345: --
5346: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
5347: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
5348: hz_dss_util_pub.get_display_name(null, 'PERSON'));
5349: FND_MSG_PUB.ADD;
5350: RAISE FND_API.G_EXC_ERROR;

Line 5347: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',

5343: --
5344: -- Bug 3835601: replaced the dss message with a more user friendly message
5345: --
5346: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
5347: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
5348: hz_dss_util_pub.get_display_name(null, 'PERSON'));
5349: FND_MSG_PUB.ADD;
5350: RAISE FND_API.G_EXC_ERROR;
5351: end if;

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

5478: END IF;
5479:
5480: x_return_status := fnd_api.g_ret_sts_unexp_error;
5481:
5482: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5483: fnd_message.set_token('ERROR',SQLERRM);
5484: fnd_msg_pub.add;
5485:
5486: fnd_msg_pub.count_and_get(

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

5479:
5480: x_return_status := fnd_api.g_ret_sts_unexp_error;
5481:
5482: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5483: fnd_message.set_token('ERROR',SQLERRM);
5484: fnd_msg_pub.add;
5485:
5486: fnd_msg_pub.count_and_get(
5487: p_encoded => fnd_api.g_false,

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

5630: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then
5631: --
5632: -- Bug 3835601: replaced the dss message with a more user friendly message
5633: --
5634: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_INSERT_PRIVILEGE');
5635: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
5636: hz_dss_util_pub.get_display_name('HZ_PARTIES', null));
5637: FND_MSG_PUB.ADD;
5638: RAISE FND_API.G_EXC_ERROR;

Line 5635: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',

5631: --
5632: -- Bug 3835601: replaced the dss message with a more user friendly message
5633: --
5634: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_INSERT_PRIVILEGE');
5635: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
5636: hz_dss_util_pub.get_display_name('HZ_PARTIES', null));
5637: FND_MSG_PUB.ADD;
5638: RAISE FND_API.G_EXC_ERROR;
5639: end if;

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

5760: END IF;
5761:
5762: x_return_status := fnd_api.g_ret_sts_unexp_error;
5763:
5764: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5765: fnd_message.set_token('ERROR',SQLERRM);
5766: fnd_msg_pub.add;
5767:
5768: fnd_msg_pub.count_and_get(

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

5761:
5762: x_return_status := fnd_api.g_ret_sts_unexp_error;
5763:
5764: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5765: fnd_message.set_token('ERROR',SQLERRM);
5766: fnd_msg_pub.add;
5767:
5768: fnd_msg_pub.count_and_get(
5769: p_encoded => fnd_api.g_false,

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

5892: WHERE PARTY_ID = p_group_rec.party_rec.party_id
5893: AND PARTY_TYPE = 'GROUP';
5894: EXCEPTION
5895: WHEN NO_DATA_FOUND THEN
5896: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
5897: fnd_message.set_token('RECORD', 'group');
5898: fnd_message.set_token('VALUE', to_char(p_group_rec.party_rec.party_id));
5899: fnd_msg_pub.add;
5900: RAISE FND_API.G_EXC_ERROR;

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

5893: AND PARTY_TYPE = 'GROUP';
5894: EXCEPTION
5895: WHEN NO_DATA_FOUND THEN
5896: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
5897: fnd_message.set_token('RECORD', 'group');
5898: fnd_message.set_token('VALUE', to_char(p_group_rec.party_rec.party_id));
5899: fnd_msg_pub.add;
5900: RAISE FND_API.G_EXC_ERROR;
5901: END;

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

5894: EXCEPTION
5895: WHEN NO_DATA_FOUND THEN
5896: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
5897: fnd_message.set_token('RECORD', 'group');
5898: fnd_message.set_token('VALUE', to_char(p_group_rec.party_rec.party_id));
5899: fnd_msg_pub.add;
5900: RAISE FND_API.G_EXC_ERROR;
5901: END;
5902: **/

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

5954: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then
5955: --
5956: -- Bug 3835601: replaced the dss message with a more user friendly message
5957: --
5958: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
5959: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
5960: hz_dss_util_pub.get_display_name('HZ_PARTIES', null));
5961: FND_MSG_PUB.ADD;
5962: RAISE FND_API.G_EXC_ERROR;

Line 5959: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',

5955: --
5956: -- Bug 3835601: replaced the dss message with a more user friendly message
5957: --
5958: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
5959: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
5960: hz_dss_util_pub.get_display_name('HZ_PARTIES', null));
5961: FND_MSG_PUB.ADD;
5962: RAISE FND_API.G_EXC_ERROR;
5963: end if;

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

6094: END IF;
6095:
6096: x_return_status := fnd_api.g_ret_sts_unexp_error;
6097:
6098: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6099: fnd_message.set_token('ERROR',SQLERRM);
6100: fnd_msg_pub.add;
6101:
6102: fnd_msg_pub.count_and_get(

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

6095:
6096: x_return_status := fnd_api.g_ret_sts_unexp_error;
6097:
6098: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6099: fnd_message.set_token('ERROR',SQLERRM);
6100: fnd_msg_pub.add;
6101:
6102: fnd_msg_pub.count_and_get(
6103: p_encoded => fnd_api.g_false,

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

6300: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then
6301: --
6302: -- Bug 3835601: replaced the dss message with a more user friendly message
6303: --
6304: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_INSERT_PRIVILEGE');
6305: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
6306: hz_dss_util_pub.get_display_name(null, 'ORGANIZATION'));
6307: FND_MSG_PUB.ADD;
6308: RAISE FND_API.G_EXC_ERROR;

Line 6305: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',

6301: --
6302: -- Bug 3835601: replaced the dss message with a more user friendly message
6303: --
6304: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_INSERT_PRIVILEGE');
6305: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
6306: hz_dss_util_pub.get_display_name(null, 'ORGANIZATION'));
6307: FND_MSG_PUB.ADD;
6308: RAISE FND_API.G_EXC_ERROR;
6309: end if;

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

6425: END IF;
6426:
6427: x_return_status := fnd_api.g_ret_sts_unexp_error;
6428:
6429: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6430: fnd_message.set_token('ERROR',SQLERRM);
6431: fnd_msg_pub.add;
6432:
6433: fnd_msg_pub.count_and_get(

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

6426:
6427: x_return_status := fnd_api.g_ret_sts_unexp_error;
6428:
6429: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6430: fnd_message.set_token('ERROR',SQLERRM);
6431: fnd_msg_pub.add;
6432:
6433: fnd_msg_pub.count_and_get(
6434: p_encoded => fnd_api.g_false,

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

6632: OPEN c_orgchk;
6633: FETCH c_orgchk INTO l_count;
6634: IF c_orgchk%NOTFOUND THEN
6635: CLOSE c_orgchk;
6636: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
6637: fnd_message.set_token('RECORD', 'organization');
6638: fnd_message.set_token('VALUE',TO_CHAR(l_organization_rec.party_rec.party_id));
6639: fnd_msg_pub.add;
6640: RAISE fnd_api.g_exc_error;

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

6633: FETCH c_orgchk INTO l_count;
6634: IF c_orgchk%NOTFOUND THEN
6635: CLOSE c_orgchk;
6636: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
6637: fnd_message.set_token('RECORD', 'organization');
6638: fnd_message.set_token('VALUE',TO_CHAR(l_organization_rec.party_rec.party_id));
6639: fnd_msg_pub.add;
6640: RAISE fnd_api.g_exc_error;
6641: END IF;

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

6634: IF c_orgchk%NOTFOUND THEN
6635: CLOSE c_orgchk;
6636: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
6637: fnd_message.set_token('RECORD', 'organization');
6638: fnd_message.set_token('VALUE',TO_CHAR(l_organization_rec.party_rec.party_id));
6639: fnd_msg_pub.add;
6640: RAISE fnd_api.g_exc_error;
6641: END IF;
6642: CLOSE c_orgchk;

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

6709: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then
6710: --
6711: -- Bug 3835601: replaced the message with a more user friendly message
6712: --
6713: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
6714: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
6715: hz_dss_util_pub.get_display_name(null, 'ORGANIZATION'));
6716: FND_MSG_PUB.ADD;
6717: RAISE FND_API.G_EXC_ERROR;

Line 6714: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',

6710: --
6711: -- Bug 3835601: replaced the message with a more user friendly message
6712: --
6713: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
6714: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
6715: hz_dss_util_pub.get_display_name(null, 'ORGANIZATION'));
6716: FND_MSG_PUB.ADD;
6717: RAISE FND_API.G_EXC_ERROR;
6718: end if;

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

6895: END IF;
6896:
6897: x_return_status := fnd_api.g_ret_sts_unexp_error;
6898:
6899: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6900: fnd_message.set_token('ERROR',SQLERRM);
6901: fnd_msg_pub.add;
6902:
6903: fnd_msg_pub.count_and_get(

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

6896:
6897: x_return_status := fnd_api.g_ret_sts_unexp_error;
6898:
6899: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
6900: fnd_message.set_token('ERROR',SQLERRM);
6901: fnd_msg_pub.add;
6902:
6903: fnd_msg_pub.count_and_get(
6904: p_encoded => fnd_api.g_false,

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

7034: --Check whether primary key has been passed in.
7035: IF p_party_id IS NULL OR
7036: p_party_id = fnd_api.g_miss_num
7037: THEN
7038: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
7039: fnd_message.set_token('COLUMN', 'p_party_id');
7040: fnd_msg_pub.add;
7041: RAISE fnd_api.g_exc_error;
7042: END IF;

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

7035: IF p_party_id IS NULL OR
7036: p_party_id = fnd_api.g_miss_num
7037: THEN
7038: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
7039: fnd_message.set_token('COLUMN', 'p_party_id');
7040: fnd_msg_pub.add;
7041: RAISE fnd_api.g_exc_error;
7042: END IF;
7043:

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

7043:
7044: IF p_content_source_type IS NULL OR
7045: p_content_source_type = fnd_api.g_miss_char
7046: THEN
7047: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
7048: fnd_message.set_token('COLUMN', 'p_content_source_type');
7049: fnd_msg_pub.add;
7050: RAISE fnd_api.g_exc_error;
7051: END IF;

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

7044: IF p_content_source_type IS NULL OR
7045: p_content_source_type = fnd_api.g_miss_char
7046: THEN
7047: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
7048: fnd_message.set_token('COLUMN', 'p_content_source_type');
7049: fnd_msg_pub.add;
7050: RAISE fnd_api.g_exc_error;
7051: END IF;
7052:

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

7068: CLOSE c_org;
7069: END IF;
7070:
7071: IF l_error THEN
7072: fnd_message.set_name('AR', 'HZ_NO_PROFILE_PRESENT');
7073: fnd_message.set_token('PARTY_ID', TO_CHAR(p_party_id));
7074: fnd_message.set_token('CONTENT_SOURCE_TYPE', p_content_source_type);
7075: fnd_msg_pub.add;
7076: RAISE fnd_api.g_exc_error;

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

7069: END IF;
7070:
7071: IF l_error THEN
7072: fnd_message.set_name('AR', 'HZ_NO_PROFILE_PRESENT');
7073: fnd_message.set_token('PARTY_ID', TO_CHAR(p_party_id));
7074: fnd_message.set_token('CONTENT_SOURCE_TYPE', p_content_source_type);
7075: fnd_msg_pub.add;
7076: RAISE fnd_api.g_exc_error;
7077: END IF;

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

7070:
7071: IF l_error THEN
7072: fnd_message.set_name('AR', 'HZ_NO_PROFILE_PRESENT');
7073: fnd_message.set_token('PARTY_ID', TO_CHAR(p_party_id));
7074: fnd_message.set_token('CONTENT_SOURCE_TYPE', p_content_source_type);
7075: fnd_msg_pub.add;
7076: RAISE fnd_api.g_exc_error;
7077: END IF;
7078:

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

7277: END IF;
7278:
7279: x_return_status := fnd_api.g_ret_sts_unexp_error;
7280:
7281: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
7282: fnd_message.set_token('ERROR',SQLERRM);
7283: fnd_msg_pub.add;
7284:
7285: fnd_msg_pub.count_and_get(

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

7278:
7279: x_return_status := fnd_api.g_ret_sts_unexp_error;
7280:
7281: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
7282: fnd_message.set_token('ERROR',SQLERRM);
7283: fnd_msg_pub.add;
7284:
7285: fnd_msg_pub.count_and_get(
7286: p_encoded => fnd_api.g_false,

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

7384: --Check whether primary key has been passed in.
7385: IF p_party_id IS NULL OR
7386: p_party_id = fnd_api.g_miss_num
7387: THEN
7388: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
7389: fnd_message.set_token('COLUMN', 'p_party_id');
7390: fnd_msg_pub.add;
7391: RAISE fnd_api.g_exc_error;
7392: END IF;

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

7385: IF p_party_id IS NULL OR
7386: p_party_id = fnd_api.g_miss_num
7387: THEN
7388: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
7389: fnd_message.set_token('COLUMN', 'p_party_id');
7390: fnd_msg_pub.add;
7391: RAISE fnd_api.g_exc_error;
7392: END IF;
7393:

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

7393:
7394: IF p_content_source_type IS NULL OR
7395: p_content_source_type = FND_API.G_MISS_CHAR
7396: THEN
7397: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
7398: fnd_message.set_token('COLUMN', 'p_content_source_type');
7399: fnd_msg_pub.add;
7400: RAISE fnd_api.g_exc_error;
7401: END IF;

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

7394: IF p_content_source_type IS NULL OR
7395: p_content_source_type = FND_API.G_MISS_CHAR
7396: THEN
7397: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
7398: fnd_message.set_token('COLUMN', 'p_content_source_type');
7399: fnd_msg_pub.add;
7400: RAISE fnd_api.g_exc_error;
7401: END IF;
7402:

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

7418: CLOSE c_per;
7419: END IF;
7420:
7421: IF l_error THEN
7422: fnd_message.set_name('AR', 'HZ_NO_PROFILE_PRESENT');
7423: fnd_message.set_token('PARTY_ID', TO_CHAR(p_party_id));
7424: fnd_message.set_token('CONTENT_SOURCE_TYPE', p_content_source_type);
7425: fnd_msg_pub.add;
7426: RAISE fnd_api.g_exc_error;

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

7419: END IF;
7420:
7421: IF l_error THEN
7422: fnd_message.set_name('AR', 'HZ_NO_PROFILE_PRESENT');
7423: fnd_message.set_token('PARTY_ID', TO_CHAR(p_party_id));
7424: fnd_message.set_token('CONTENT_SOURCE_TYPE', p_content_source_type);
7425: fnd_msg_pub.add;
7426: RAISE fnd_api.g_exc_error;
7427: END IF;

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

7420:
7421: IF l_error THEN
7422: fnd_message.set_name('AR', 'HZ_NO_PROFILE_PRESENT');
7423: fnd_message.set_token('PARTY_ID', TO_CHAR(p_party_id));
7424: fnd_message.set_token('CONTENT_SOURCE_TYPE', p_content_source_type);
7425: fnd_msg_pub.add;
7426: RAISE fnd_api.g_exc_error;
7427: END IF;
7428:

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

7547: END IF;
7548:
7549: x_return_status := fnd_api.g_ret_sts_unexp_error;
7550:
7551: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
7552: fnd_message.set_token('ERROR',SQLERRM);
7553: fnd_msg_pub.add;
7554:
7555: fnd_msg_pub.count_and_get(

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

7548:
7549: x_return_status := fnd_api.g_ret_sts_unexp_error;
7550:
7551: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
7552: fnd_message.set_token('ERROR',SQLERRM);
7553: fnd_msg_pub.add;
7554:
7555: fnd_msg_pub.count_and_get(
7556: p_encoded => fnd_api.g_false,

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

7642: --Check whether primary key has been passed in.
7643: IF p_party_id IS NULL OR
7644: p_party_id = fnd_api.g_miss_num
7645: THEN
7646: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
7647: fnd_message.set_token('COLUMN', 'party_id');
7648: fnd_msg_pub.add;
7649: RAISE fnd_api.g_exc_error;
7650: END IF;

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

7643: IF p_party_id IS NULL OR
7644: p_party_id = fnd_api.g_miss_num
7645: THEN
7646: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
7647: fnd_message.set_token('COLUMN', 'party_id');
7648: fnd_msg_pub.add;
7649: RAISE fnd_api.g_exc_error;
7650: END IF;
7651:

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

7656: END IF;
7657: CLOSE c_group;
7658:
7659: IF l_error THEN
7660: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
7661: fnd_message.set_token('RECORD', 'group');
7662: fnd_message.set_token('VALUE', to_char(p_party_id));
7663: fnd_msg_pub.add;
7664: RAISE fnd_api.g_exc_error;

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

7657: CLOSE c_group;
7658:
7659: IF l_error THEN
7660: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
7661: fnd_message.set_token('RECORD', 'group');
7662: fnd_message.set_token('VALUE', to_char(p_party_id));
7663: fnd_msg_pub.add;
7664: RAISE fnd_api.g_exc_error;
7665: END IF;

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

7658:
7659: IF l_error THEN
7660: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
7661: fnd_message.set_token('RECORD', 'group');
7662: fnd_message.set_token('VALUE', to_char(p_party_id));
7663: fnd_msg_pub.add;
7664: RAISE fnd_api.g_exc_error;
7665: END IF;
7666:

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

7778:
7779: WHEN OTHERS THEN
7780: x_return_status := fnd_api.g_ret_sts_unexp_error;
7781:
7782: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
7783: fnd_message.set_token('ERROR',SQLERRM);
7784: fnd_msg_pub.add;
7785:
7786: fnd_msg_pub.count_and_get(

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

7779: WHEN OTHERS THEN
7780: x_return_status := fnd_api.g_ret_sts_unexp_error;
7781:
7782: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
7783: fnd_message.set_token('ERROR',SQLERRM);
7784: fnd_msg_pub.add;
7785:
7786: fnd_msg_pub.count_and_get(
7787: p_encoded => fnd_api.g_false,

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

7866: --Check whether primary key has been passed in.
7867: IF p_party_id IS NULL OR
7868: p_party_id = fnd_api.g_miss_num
7869: THEN
7870: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
7871: fnd_message.set_token('COLUMN', 'party_id');
7872: fnd_msg_pub.add;
7873: RAISE fnd_api.g_exc_error;
7874: END IF;

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

7867: IF p_party_id IS NULL OR
7868: p_party_id = fnd_api.g_miss_num
7869: THEN
7870: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
7871: fnd_message.set_token('COLUMN', 'party_id');
7872: fnd_msg_pub.add;
7873: RAISE fnd_api.g_exc_error;
7874: END IF;
7875:

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

7986:
7987: WHEN OTHERS THEN
7988: x_return_status := fnd_api.g_ret_sts_unexp_error;
7989:
7990: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
7991: fnd_message.set_token('ERROR',SQLERRM);
7992: fnd_msg_pub.add;
7993:
7994: fnd_msg_pub.count_and_get(

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

7987: WHEN OTHERS THEN
7988: x_return_status := fnd_api.g_ret_sts_unexp_error;
7989:
7990: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
7991: fnd_message.set_token('ERROR',SQLERRM);
7992: fnd_msg_pub.add;
7993:
7994: fnd_msg_pub.count_and_get(
7995: p_encoded => fnd_api.g_false,