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_MSG_PUB

Line 409: fnd_msg_pub.add;

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:
413: END party_exists;

Line 757: fnd_msg_pub.add;

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:
761: UPDATE hz_parties

Line 1131: fnd_msg_pub.add;

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:
1135: -- the sic_code_type ='OTHER' is allowed only when

Line 1142: fnd_msg_pub.add;

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:
1146: -- call hz_classification_v2pub.set_primary_code_assignment.

Line 1488: fnd_msg_pub.add;

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;
1492:

Line 1726: fnd_msg_pub.add;

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;
1730:

Line 2050: fnd_msg_pub.add;

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;
2054:

Line 2344: fnd_msg_pub.add;

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;
2348:

Line 2816: fnd_msg_pub.add;

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:
2820: OPEN c_party_number_exists(l_party_rec.party_number);

Line 2826: fnd_msg_pub.add;

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;
2830:

Line 2837: fnd_msg_pub.add;

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:
2841: END IF;

Line 2856: fnd_msg_pub.add;

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
2860: l_party_object_version_number IS NULL) OR

Line 2867: fnd_msg_pub.add;

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;
2871:

Line 3455: fnd_msg_pub.add;

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:
3459: ZX_PARTY_TAX_PROFILE_PKG.update_row (

Line 3566: fnd_msg_pub.add;

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;
3570:

Line 3767: fnd_msg_pub.add;

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:
3771: -- Validate group record.

Line 3820: fnd_msg_pub.add;

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:
3824: -- party does not exist, create new party.

Line 3892: fnd_msg_pub.add;

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;
3896: x_party_number := l_party_number;

Line 4897: FND_MSG_PUB.initialize;

4893:
4894:
4895: -- initialize message list if p_init_msg_list is set to TRUE.
4896: IF FND_API.to_Boolean(p_init_msg_list) THEN
4897: FND_MSG_PUB.initialize;
4898: END IF;
4899:
4900: -- initialize API return status to success.
4901: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4955: FND_MSG_PUB.ADD;

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;
4958: END IF;
4959:

Line 4968: fnd_msg_pub.count_and_get(

4964: hz_common_pub.enable_cont_source_security;
4965: END IF;
4966:
4967: --Standard call to get message count and if count is 1, get message info.
4968: fnd_msg_pub.count_and_get(
4969: p_encoded => fnd_api.g_false,
4970: p_count => x_msg_count,
4971: p_data => x_msg_data);
4972:

Line 5004: fnd_msg_pub.count_and_get(

5000: END IF;
5001:
5002: x_return_status := fnd_api.g_ret_sts_error;
5003:
5004: fnd_msg_pub.count_and_get(
5005: p_encoded => fnd_api.g_false,
5006: p_count => x_msg_count,
5007: p_data => x_msg_data);
5008:

Line 5040: fnd_msg_pub.count_and_get(

5036: END IF;
5037:
5038: x_return_status := fnd_api.g_ret_sts_unexp_error;
5039:
5040: fnd_msg_pub.count_and_get(
5041: p_encoded => fnd_api.g_false,
5042: p_count => x_msg_count,
5043: p_data => x_msg_data);
5044:

Line 5078: fnd_msg_pub.add;

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,
5082: p_count => x_msg_count,

Line 5080: fnd_msg_pub.count_and_get(

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,
5082: p_count => x_msg_count,
5083: p_data => x_msg_data);
5084:

Line 5246: FND_MSG_PUB.initialize;

5242: END IF;
5243:
5244: -- initialize message list if p_init_msg_list is set to TRUE.
5245: IF FND_API.to_Boolean(p_init_msg_list) THEN
5246: FND_MSG_PUB.initialize;
5247: END IF;
5248:
5249: -- initialize API return status to success.
5250: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5275: fnd_msg_pub.add;

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: **/
5279:

Line 5349: FND_MSG_PUB.ADD;

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;
5352: END IF;
5353:

Line 5373: fnd_msg_pub.count_and_get(

5369: hz_common_pub.enable_cont_source_security;
5370: END IF;
5371:
5372: --Standard call to get message count and if count is 1, get message info.
5373: fnd_msg_pub.count_and_get(
5374: p_encoded => fnd_api.g_false,
5375: p_count => x_msg_count,
5376: p_data => x_msg_data);
5377:

Line 5410: fnd_msg_pub.count_and_get(

5406: END IF;
5407:
5408: x_return_status := fnd_api.g_ret_sts_error;
5409:
5410: fnd_msg_pub.count_and_get(
5411: p_encoded => fnd_api.g_false,
5412: p_count => x_msg_count,
5413: p_data => x_msg_data);
5414:

Line 5447: fnd_msg_pub.count_and_get(

5443: END IF;
5444:
5445: x_return_status := fnd_api.g_ret_sts_unexp_error;
5446:
5447: fnd_msg_pub.count_and_get(
5448: p_encoded => fnd_api.g_false,
5449: p_count => x_msg_count,
5450: p_data => x_msg_data);
5451:

Line 5484: fnd_msg_pub.add;

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,
5488: p_count => x_msg_count,

Line 5486: fnd_msg_pub.count_and_get(

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,
5488: p_count => x_msg_count,
5489: p_data => x_msg_data);
5490:

Line 5587: FND_MSG_PUB.initialize;

5583: END IF;
5584:
5585: -- initialize message list if p_init_msg_list is set to TRUE.
5586: IF FND_API.to_Boolean(p_init_msg_list) THEN
5587: FND_MSG_PUB.initialize;
5588: END IF;
5589:
5590: -- initialize API return status to success.
5591: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5637: FND_MSG_PUB.ADD;

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;
5640: END IF;
5641:

Line 5655: fnd_msg_pub.count_and_get(

5651: hz_common_pub.enable_cont_source_security;
5652: END IF;
5653:
5654: --Standard call to get message count and if count is 1, get message info.
5655: fnd_msg_pub.count_and_get(
5656: p_encoded => fnd_api.g_false,
5657: p_count => x_msg_count,
5658: p_data => x_msg_data);
5659:

Line 5692: fnd_msg_pub.count_and_get(

5688: END IF;
5689:
5690: x_return_status := fnd_api.g_ret_sts_error;
5691:
5692: fnd_msg_pub.count_and_get(
5693: p_encoded => fnd_api.g_false,
5694: p_count => x_msg_count,
5695: p_data => x_msg_data);
5696:

Line 5728: fnd_msg_pub.count_and_get(

5724: END IF;
5725:
5726: x_return_status := fnd_api.g_ret_sts_unexp_error;
5727:
5728: fnd_msg_pub.count_and_get(
5729: p_encoded => fnd_api.g_false,
5730: p_count => x_msg_count,
5731: p_data => x_msg_data);
5732:

Line 5766: fnd_msg_pub.add;

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,
5770: p_count => x_msg_count,

Line 5768: fnd_msg_pub.count_and_get(

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,
5770: p_count => x_msg_count,
5771: p_data => x_msg_data);
5772:

Line 5871: FND_MSG_PUB.initialize;

5867:
5868:
5869: -- initialize message list if p_init_msg_list is set to TRUE.
5870: IF FND_API.to_Boolean(p_init_msg_list) THEN
5871: FND_MSG_PUB.initialize;
5872: END IF;
5873:
5874: -- initialize API return status to success.
5875: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5899: fnd_msg_pub.add;

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: **/
5903:

Line 5961: FND_MSG_PUB.ADD;

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;
5964: END IF;
5965:

Line 5990: fnd_msg_pub.count_and_get(

5986: hz_common_pub.enable_cont_source_security;
5987: END IF;
5988:
5989: --Standard call to get message count and if count is 1, get message info.
5990: fnd_msg_pub.count_and_get(
5991: p_encoded => fnd_api.g_false,
5992: p_count => x_msg_count,
5993: p_data => x_msg_data);
5994:

Line 6026: fnd_msg_pub.count_and_get(

6022: END IF;
6023:
6024: x_return_status := fnd_api.g_ret_sts_error;
6025:
6026: fnd_msg_pub.count_and_get(
6027: p_encoded => fnd_api.g_false,
6028: p_count => x_msg_count,
6029: p_data => x_msg_data);
6030:

Line 6062: fnd_msg_pub.count_and_get(

6058: END IF;
6059:
6060: x_return_status := fnd_api.g_ret_sts_unexp_error;
6061:
6062: fnd_msg_pub.count_and_get(
6063: p_encoded => fnd_api.g_false,
6064: p_count => x_msg_count,
6065: p_data => x_msg_data);
6066:

Line 6100: fnd_msg_pub.add;

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,
6104: p_count => x_msg_count,

Line 6102: fnd_msg_pub.count_and_get(

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,
6104: p_count => x_msg_count,
6105: p_data => x_msg_data);
6106:

Line 6214: fnd_msg_pub.initialize;

6210:
6211:
6212: -- initialize message list if p_init_msg_list is set to TRUE.
6213: IF fnd_api.to_boolean(p_init_msg_list) THEN
6214: fnd_msg_pub.initialize;
6215: END IF;
6216:
6217: -- initialize API return status to success.
6218: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6307: FND_MSG_PUB.ADD;

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;
6310: END IF;
6311:

Line 6320: fnd_msg_pub.count_and_get(

6316: hz_common_pub.enable_cont_source_security;
6317: END IF;
6318:
6319: --Standard call to get message count and if count is 1, get message info.
6320: fnd_msg_pub.count_and_get(
6321: p_encoded => fnd_api.g_false,
6322: p_count => x_msg_count,
6323: p_data => x_msg_data);
6324:

Line 6357: fnd_msg_pub.count_and_get(

6353: END IF;
6354:
6355: x_return_status := fnd_api.g_ret_sts_error;
6356:
6357: fnd_msg_pub.count_and_get(
6358: p_encoded => fnd_api.g_false,
6359: p_count => x_msg_count,
6360: p_data => x_msg_data);
6361:

Line 6393: fnd_msg_pub.count_and_get(

6389: END IF;
6390:
6391: x_return_status := fnd_api.g_ret_sts_unexp_error;
6392:
6393: fnd_msg_pub.count_and_get(
6394: p_encoded => fnd_api.g_false,
6395: p_count => x_msg_count,
6396: p_data => x_msg_data);
6397:

Line 6431: fnd_msg_pub.add;

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,
6435: p_count => x_msg_count,

Line 6433: fnd_msg_pub.count_and_get(

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,
6435: p_count => x_msg_count,
6436: p_data => x_msg_data);
6437:

Line 6614: fnd_msg_pub.initialize;

6610:
6611:
6612: -- initialize message list if p_init_msg_list is set to TRUE.
6613: IF fnd_api.to_boolean(p_init_msg_list) THEN
6614: fnd_msg_pub.initialize;
6615: END IF;
6616:
6617: -- initialize API return status to success.
6618: x_return_status := fnd_api.g_ret_sts_success;

Line 6639: fnd_msg_pub.add;

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;
6643: **/

Line 6716: FND_MSG_PUB.ADD;

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;
6719: END IF;
6720:

Line 6790: fnd_msg_pub.count_and_get(

6786: hz_common_pub.enable_cont_source_security;
6787: END IF;
6788:
6789: --Standard call to get message count and if count is 1, get message info.
6790: fnd_msg_pub.count_and_get(
6791: p_encoded => fnd_api.g_false,
6792: p_count => x_msg_count,
6793: p_data => x_msg_data);
6794:

Line 6826: fnd_msg_pub.count_and_get(

6822: END IF;
6823:
6824: x_return_status := fnd_api.g_ret_sts_error;
6825:
6826: fnd_msg_pub.count_and_get(
6827: p_encoded => fnd_api.g_false,
6828: p_count => x_msg_count,
6829: p_data => x_msg_data);
6830:

Line 6862: fnd_msg_pub.count_and_get(

6858: END IF;
6859:
6860: x_return_status := fnd_api.g_ret_sts_unexp_error;
6861:
6862: fnd_msg_pub.count_and_get(
6863: p_encoded => fnd_api.g_false,
6864: p_count => x_msg_count,
6865: p_data => x_msg_data);
6866:

Line 6901: fnd_msg_pub.add;

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,
6905: p_count => x_msg_count,

Line 6903: fnd_msg_pub.count_and_get(

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,
6905: p_count => x_msg_count,
6906: p_data => x_msg_data);
6907:

Line 7021: fnd_msg_pub.initialize;

7017: BEGIN
7018:
7019: --Initialize message list if p_init_msg_list is set to TRUE.
7020: IF fnd_api.to_boolean(p_init_msg_list) THEN
7021: fnd_msg_pub.initialize;
7022: END IF;
7023:
7024: --Initialize API return status to success.
7025: x_return_status := fnd_api.g_ret_sts_success;

Line 7040: fnd_msg_pub.add;

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:
7044: IF p_content_source_type IS NULL OR

Line 7049: fnd_msg_pub.add;

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:
7053: IF p_content_source_type = G_MISS_CONTENT_SOURCE_TYPE THEN

Line 7075: fnd_msg_pub.add;

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:
7079: hz_organization_profiles_pkg.Select_Row (

Line 7244: fnd_msg_pub.count_and_get(

7240: hz_common_pub.enable_cont_source_security;
7241: END IF;
7242:
7243: --Standard call to get message count and if count is 1, get message info.
7244: fnd_msg_pub.count_and_get(
7245: p_encoded => fnd_api.g_false,
7246: p_count => x_msg_count,
7247: p_data => x_msg_data);
7248:

Line 7257: fnd_msg_pub.count_and_get(

7253: END IF;
7254:
7255: x_return_status := fnd_api.g_ret_sts_error;
7256:
7257: fnd_msg_pub.count_and_get(
7258: p_encoded => fnd_api.g_false,
7259: p_count => x_msg_count,
7260: p_data => x_msg_data);
7261:

Line 7269: fnd_msg_pub.count_and_get(

7265: END IF;
7266:
7267: x_return_status := fnd_api.g_ret_sts_unexp_error;
7268:
7269: fnd_msg_pub.count_and_get(
7270: p_encoded => fnd_api.g_false,
7271: p_count => x_msg_count,
7272: p_data => x_msg_data);
7273:

Line 7283: fnd_msg_pub.add;

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,
7287: p_count => x_msg_count,

Line 7285: fnd_msg_pub.count_and_get(

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,
7287: p_count => x_msg_count,
7288: p_data => x_msg_data);
7289:

Line 7371: fnd_msg_pub.initialize;

7367: BEGIN
7368:
7369: --Initialize message list if p_init_msg_list is set to TRUE.
7370: IF fnd_api.to_boolean(p_init_msg_list) THEN
7371: fnd_msg_pub.initialize;
7372: END IF;
7373:
7374: --Initialize API return status to success.
7375: x_return_status := fnd_api.g_ret_sts_success;

Line 7390: fnd_msg_pub.add;

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:
7394: IF p_content_source_type IS NULL OR

Line 7399: fnd_msg_pub.add;

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:
7403: IF p_content_source_type = G_MISS_CONTENT_SOURCE_TYPE THEN

Line 7425: fnd_msg_pub.add;

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:
7429: HZ_person_profiles_pkg.Select_Row (

Line 7514: fnd_msg_pub.count_and_get(

7510: hz_common_pub.enable_cont_source_security;
7511: END IF;
7512:
7513: --Standard call to get message count and if count is 1, get message info.
7514: fnd_msg_pub.count_and_get(
7515: p_encoded => fnd_api.g_false,
7516: p_count => x_msg_count,
7517: p_data => x_msg_data);
7518:

Line 7527: fnd_msg_pub.count_and_get(

7523: END IF;
7524:
7525: x_return_status := fnd_api.g_ret_sts_error;
7526:
7527: fnd_msg_pub.count_and_get(
7528: p_encoded => fnd_api.g_false,
7529: p_count => x_msg_count,
7530: p_data => x_msg_data);
7531:

Line 7539: fnd_msg_pub.count_and_get(

7535: END IF;
7536:
7537: x_return_status := fnd_api.g_ret_sts_unexp_error;
7538:
7539: fnd_msg_pub.count_and_get(
7540: p_encoded => fnd_api.g_false,
7541: p_count => x_msg_count,
7542: p_data => x_msg_data);
7543:

Line 7553: fnd_msg_pub.add;

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,
7557: p_count => x_msg_count,

Line 7555: fnd_msg_pub.count_and_get(

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,
7557: p_count => x_msg_count,
7558: p_data => x_msg_data);
7559:

Line 7636: fnd_msg_pub.initialize;

7632: BEGIN
7633:
7634: --Initialize message list if p_init_msg_list is set to TRUE.
7635: IF fnd_api.to_boolean(p_init_msg_list) THEN
7636: fnd_msg_pub.initialize;
7637: END IF;
7638:
7639: --Initialize API return status to success.
7640: x_return_status := fnd_api.g_ret_sts_success;

Line 7648: fnd_msg_pub.add;

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:
7652: OPEN c_group;

Line 7663: fnd_msg_pub.add;

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:
7667: x_group_rec.party_rec.party_id := p_party_id;

Line 7757: fnd_msg_pub.count_and_get(

7753: x_application_id => x_group_rec.application_id
7754: );
7755:
7756: --Standard call to get message count and if count is 1, get message info.
7757: fnd_msg_pub.count_and_get(
7758: p_encoded => fnd_api.g_false,
7759: p_count => x_msg_count,
7760: p_data => x_msg_data);
7761:

Line 7766: fnd_msg_pub.count_and_get(

7762: EXCEPTION
7763: WHEN fnd_api.g_exc_error THEN
7764: x_return_status := fnd_api.g_ret_sts_error;
7765:
7766: fnd_msg_pub.count_and_get(
7767: p_encoded => fnd_api.g_false,
7768: p_count => x_msg_count,
7769: p_data => x_msg_data);
7770:

Line 7774: fnd_msg_pub.count_and_get(

7770:
7771: WHEN fnd_api.g_exc_unexpected_error THEN
7772: x_return_status := fnd_api.g_ret_sts_unexp_error;
7773:
7774: fnd_msg_pub.count_and_get(
7775: p_encoded => fnd_api.g_false,
7776: p_count => x_msg_count,
7777: p_data => x_msg_data);
7778:

Line 7784: fnd_msg_pub.add;

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,
7788: p_count => x_msg_count,

Line 7786: fnd_msg_pub.count_and_get(

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,
7788: p_count => x_msg_count,
7789: p_data => x_msg_data);
7790:

Line 7860: fnd_msg_pub.initialize;

7856: BEGIN
7857:
7858: --Initialize message list if p_init_msg_list is set to TRUE.
7859: IF fnd_api.to_boolean(p_init_msg_list) THEN
7860: fnd_msg_pub.initialize;
7861: END IF;
7862:
7863: --Initialize API return status to success.
7864: x_return_status := fnd_api.g_ret_sts_success;

Line 7872: fnd_msg_pub.add;

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:
7876: x_party_rec.party_id := p_party_id;

Line 7965: fnd_msg_pub.count_and_get(

7961: x_application_id => l_application_id
7962: );
7963:
7964: --Standard call to get message count and if count is 1, get message info.
7965: fnd_msg_pub.count_and_get(
7966: p_encoded => fnd_api.g_false,
7967: p_count => x_msg_count,
7968: p_data => x_msg_data);
7969:

Line 7974: fnd_msg_pub.count_and_get(

7970: EXCEPTION
7971: WHEN fnd_api.g_exc_error THEN
7972: x_return_status := fnd_api.g_ret_sts_error;
7973:
7974: fnd_msg_pub.count_and_get(
7975: p_encoded => fnd_api.g_false,
7976: p_count => x_msg_count,
7977: p_data => x_msg_data);
7978:

Line 7982: fnd_msg_pub.count_and_get(

7978:
7979: WHEN fnd_api.g_exc_unexpected_error THEN
7980: x_return_status := fnd_api.g_ret_sts_unexp_error;
7981:
7982: fnd_msg_pub.count_and_get(
7983: p_encoded => fnd_api.g_false,
7984: p_count => x_msg_count,
7985: p_data => x_msg_data);
7986:

Line 7992: fnd_msg_pub.add;

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,
7996: p_count => x_msg_count,

Line 7994: fnd_msg_pub.count_and_get(

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,
7996: p_count => x_msg_count,
7997: p_data => x_msg_data);
7998: