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 416: fnd_msg_pub.add;

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

Line 764: fnd_msg_pub.add;

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

Line 1138: fnd_msg_pub.add;

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

Line 1149: fnd_msg_pub.add;

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

Line 1495: fnd_msg_pub.add;

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

Line 1733: fnd_msg_pub.add;

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

Line 2091: fnd_msg_pub.add;

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

Line 2385: fnd_msg_pub.add;

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

Line 2867: fnd_msg_pub.add;

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

Line 2877: fnd_msg_pub.add;

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

Line 2888: fnd_msg_pub.add;

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

Line 2907: fnd_msg_pub.add;

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

Line 2918: fnd_msg_pub.add;

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

Line 3506: fnd_msg_pub.add;

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

Line 3617: fnd_msg_pub.add;

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

Line 3821: fnd_msg_pub.add;

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

Line 3874: fnd_msg_pub.add;

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

Line 3947: fnd_msg_pub.add;

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

Line 4957: FND_MSG_PUB.initialize;

4953:
4954:
4955: -- initialize message list if p_init_msg_list is set to TRUE.
4956: IF FND_API.to_Boolean(p_init_msg_list) THEN
4957: FND_MSG_PUB.initialize;
4958: END IF;
4959:
4960: -- initialize API return status to success.
4961: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5015: FND_MSG_PUB.ADD;

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

Line 5028: fnd_msg_pub.count_and_get(

5024: hz_common_pub.enable_cont_source_security;
5025: END IF;
5026:
5027: --Standard call to get message count and if count is 1, get message info.
5028: fnd_msg_pub.count_and_get(
5029: p_encoded => fnd_api.g_false,
5030: p_count => x_msg_count,
5031: p_data => x_msg_data);
5032:

Line 5064: fnd_msg_pub.count_and_get(

5060: END IF;
5061:
5062: x_return_status := fnd_api.g_ret_sts_error;
5063:
5064: fnd_msg_pub.count_and_get(
5065: p_encoded => fnd_api.g_false,
5066: p_count => x_msg_count,
5067: p_data => x_msg_data);
5068:

Line 5100: fnd_msg_pub.count_and_get(

5096: END IF;
5097:
5098: x_return_status := fnd_api.g_ret_sts_unexp_error;
5099:
5100: fnd_msg_pub.count_and_get(
5101: p_encoded => fnd_api.g_false,
5102: p_count => x_msg_count,
5103: p_data => x_msg_data);
5104:

Line 5138: fnd_msg_pub.add;

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

Line 5140: fnd_msg_pub.count_and_get(

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,
5142: p_count => x_msg_count,
5143: p_data => x_msg_data);
5144:

Line 5317: FND_MSG_PUB.initialize;

5313: END IF;
5314:
5315: -- initialize message list if p_init_msg_list is set to TRUE.
5316: IF FND_API.to_Boolean(p_init_msg_list) THEN
5317: FND_MSG_PUB.initialize;
5318: END IF;
5319:
5320: -- initialize API return status to success.
5321: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5346: fnd_msg_pub.add;

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

Line 5420: FND_MSG_PUB.ADD;

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

Line 5444: fnd_msg_pub.count_and_get(

5440: hz_common_pub.enable_cont_source_security;
5441: END IF;
5442:
5443: --Standard call to get message count and if count is 1, get message info.
5444: fnd_msg_pub.count_and_get(
5445: p_encoded => fnd_api.g_false,
5446: p_count => x_msg_count,
5447: p_data => x_msg_data);
5448:

Line 5481: fnd_msg_pub.count_and_get(

5477: END IF;
5478:
5479: x_return_status := fnd_api.g_ret_sts_error;
5480:
5481: fnd_msg_pub.count_and_get(
5482: p_encoded => fnd_api.g_false,
5483: p_count => x_msg_count,
5484: p_data => x_msg_data);
5485:

Line 5518: fnd_msg_pub.count_and_get(

5514: END IF;
5515:
5516: x_return_status := fnd_api.g_ret_sts_unexp_error;
5517:
5518: fnd_msg_pub.count_and_get(
5519: p_encoded => fnd_api.g_false,
5520: p_count => x_msg_count,
5521: p_data => x_msg_data);
5522:

Line 5555: fnd_msg_pub.add;

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

Line 5557: fnd_msg_pub.count_and_get(

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,
5559: p_count => x_msg_count,
5560: p_data => x_msg_data);
5561:

Line 5658: FND_MSG_PUB.initialize;

5654: END IF;
5655:
5656: -- initialize message list if p_init_msg_list is set to TRUE.
5657: IF FND_API.to_Boolean(p_init_msg_list) THEN
5658: FND_MSG_PUB.initialize;
5659: END IF;
5660:
5661: -- initialize API return status to success.
5662: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5708: FND_MSG_PUB.ADD;

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

Line 5726: fnd_msg_pub.count_and_get(

5722: hz_common_pub.enable_cont_source_security;
5723: END IF;
5724:
5725: --Standard call to get message count and if count is 1, get message info.
5726: fnd_msg_pub.count_and_get(
5727: p_encoded => fnd_api.g_false,
5728: p_count => x_msg_count,
5729: p_data => x_msg_data);
5730:

Line 5763: fnd_msg_pub.count_and_get(

5759: END IF;
5760:
5761: x_return_status := fnd_api.g_ret_sts_error;
5762:
5763: fnd_msg_pub.count_and_get(
5764: p_encoded => fnd_api.g_false,
5765: p_count => x_msg_count,
5766: p_data => x_msg_data);
5767:

Line 5799: fnd_msg_pub.count_and_get(

5795: END IF;
5796:
5797: x_return_status := fnd_api.g_ret_sts_unexp_error;
5798:
5799: fnd_msg_pub.count_and_get(
5800: p_encoded => fnd_api.g_false,
5801: p_count => x_msg_count,
5802: p_data => x_msg_data);
5803:

Line 5837: fnd_msg_pub.add;

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

Line 5839: fnd_msg_pub.count_and_get(

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,
5841: p_count => x_msg_count,
5842: p_data => x_msg_data);
5843:

Line 5942: FND_MSG_PUB.initialize;

5938:
5939:
5940: -- initialize message list if p_init_msg_list is set to TRUE.
5941: IF FND_API.to_Boolean(p_init_msg_list) THEN
5942: FND_MSG_PUB.initialize;
5943: END IF;
5944:
5945: -- initialize API return status to success.
5946: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5970: fnd_msg_pub.add;

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

Line 6032: FND_MSG_PUB.ADD;

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

Line 6061: fnd_msg_pub.count_and_get(

6057: hz_common_pub.enable_cont_source_security;
6058: END IF;
6059:
6060: --Standard call to get message count and if count is 1, get message info.
6061: fnd_msg_pub.count_and_get(
6062: p_encoded => fnd_api.g_false,
6063: p_count => x_msg_count,
6064: p_data => x_msg_data);
6065:

Line 6097: fnd_msg_pub.count_and_get(

6093: END IF;
6094:
6095: x_return_status := fnd_api.g_ret_sts_error;
6096:
6097: fnd_msg_pub.count_and_get(
6098: p_encoded => fnd_api.g_false,
6099: p_count => x_msg_count,
6100: p_data => x_msg_data);
6101:

Line 6133: fnd_msg_pub.count_and_get(

6129: END IF;
6130:
6131: x_return_status := fnd_api.g_ret_sts_unexp_error;
6132:
6133: fnd_msg_pub.count_and_get(
6134: p_encoded => fnd_api.g_false,
6135: p_count => x_msg_count,
6136: p_data => x_msg_data);
6137:

Line 6171: fnd_msg_pub.add;

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

Line 6173: fnd_msg_pub.count_and_get(

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,
6175: p_count => x_msg_count,
6176: p_data => x_msg_data);
6177:

Line 6285: fnd_msg_pub.initialize;

6281:
6282:
6283: -- initialize message list if p_init_msg_list is set to TRUE.
6284: IF fnd_api.to_boolean(p_init_msg_list) THEN
6285: fnd_msg_pub.initialize;
6286: END IF;
6287:
6288: -- initialize API return status to success.
6289: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6378: FND_MSG_PUB.ADD;

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

Line 6391: fnd_msg_pub.count_and_get(

6387: hz_common_pub.enable_cont_source_security;
6388: END IF;
6389:
6390: --Standard call to get message count and if count is 1, get message info.
6391: fnd_msg_pub.count_and_get(
6392: p_encoded => fnd_api.g_false,
6393: p_count => x_msg_count,
6394: p_data => x_msg_data);
6395:

Line 6428: fnd_msg_pub.count_and_get(

6424: END IF;
6425:
6426: x_return_status := fnd_api.g_ret_sts_error;
6427:
6428: fnd_msg_pub.count_and_get(
6429: p_encoded => fnd_api.g_false,
6430: p_count => x_msg_count,
6431: p_data => x_msg_data);
6432:

Line 6464: fnd_msg_pub.count_and_get(

6460: END IF;
6461:
6462: x_return_status := fnd_api.g_ret_sts_unexp_error;
6463:
6464: fnd_msg_pub.count_and_get(
6465: p_encoded => fnd_api.g_false,
6466: p_count => x_msg_count,
6467: p_data => x_msg_data);
6468:

Line 6502: fnd_msg_pub.add;

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

Line 6504: fnd_msg_pub.count_and_get(

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,
6506: p_count => x_msg_count,
6507: p_data => x_msg_data);
6508:

Line 6695: fnd_msg_pub.initialize;

6691: END IF;
6692:
6693: -- initialize message list if p_init_msg_list is set to TRUE.
6694: IF fnd_api.to_boolean(p_init_msg_list) THEN
6695: fnd_msg_pub.initialize;
6696: END IF;
6697:
6698: -- initialize API return status to success.
6699: x_return_status := fnd_api.g_ret_sts_success;

Line 6720: fnd_msg_pub.add;

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

Line 6797: FND_MSG_PUB.ADD;

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

Line 6871: fnd_msg_pub.count_and_get(

6867: hz_common_pub.enable_cont_source_security;
6868: END IF;
6869:
6870: --Standard call to get message count and if count is 1, get message info.
6871: fnd_msg_pub.count_and_get(
6872: p_encoded => fnd_api.g_false,
6873: p_count => x_msg_count,
6874: p_data => x_msg_data);
6875:

Line 6907: fnd_msg_pub.count_and_get(

6903: END IF;
6904:
6905: x_return_status := fnd_api.g_ret_sts_error;
6906:
6907: fnd_msg_pub.count_and_get(
6908: p_encoded => fnd_api.g_false,
6909: p_count => x_msg_count,
6910: p_data => x_msg_data);
6911:

Line 6943: fnd_msg_pub.count_and_get(

6939: END IF;
6940:
6941: x_return_status := fnd_api.g_ret_sts_unexp_error;
6942:
6943: fnd_msg_pub.count_and_get(
6944: p_encoded => fnd_api.g_false,
6945: p_count => x_msg_count,
6946: p_data => x_msg_data);
6947:

Line 6982: fnd_msg_pub.add;

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

Line 6984: fnd_msg_pub.count_and_get(

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,
6986: p_count => x_msg_count,
6987: p_data => x_msg_data);
6988:

Line 7102: fnd_msg_pub.initialize;

7098: BEGIN
7099:
7100: --Initialize message list if p_init_msg_list is set to TRUE.
7101: IF fnd_api.to_boolean(p_init_msg_list) THEN
7102: fnd_msg_pub.initialize;
7103: END IF;
7104:
7105: --Initialize API return status to success.
7106: x_return_status := fnd_api.g_ret_sts_success;

Line 7121: fnd_msg_pub.add;

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

Line 7130: fnd_msg_pub.add;

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

Line 7156: fnd_msg_pub.add;

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:
7160:

Line 7356: fnd_msg_pub.count_and_get(

7352: hz_common_pub.enable_cont_source_security;
7353: END IF;
7354:
7355: --Standard call to get message count and if count is 1, get message info.
7356: fnd_msg_pub.count_and_get(
7357: p_encoded => fnd_api.g_false,
7358: p_count => x_msg_count,
7359: p_data => x_msg_data);
7360:

Line 7369: fnd_msg_pub.count_and_get(

7365: END IF;
7366:
7367: x_return_status := fnd_api.g_ret_sts_error;
7368:
7369: fnd_msg_pub.count_and_get(
7370: p_encoded => fnd_api.g_false,
7371: p_count => x_msg_count,
7372: p_data => x_msg_data);
7373:

Line 7381: fnd_msg_pub.count_and_get(

7377: END IF;
7378:
7379: x_return_status := fnd_api.g_ret_sts_unexp_error;
7380:
7381: fnd_msg_pub.count_and_get(
7382: p_encoded => fnd_api.g_false,
7383: p_count => x_msg_count,
7384: p_data => x_msg_data);
7385:

Line 7395: fnd_msg_pub.add;

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

Line 7397: fnd_msg_pub.count_and_get(

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,
7399: p_count => x_msg_count,
7400: p_data => x_msg_data);
7401:

Line 7483: fnd_msg_pub.initialize;

7479: BEGIN
7480:
7481: --Initialize message list if p_init_msg_list is set to TRUE.
7482: IF fnd_api.to_boolean(p_init_msg_list) THEN
7483: fnd_msg_pub.initialize;
7484: END IF;
7485:
7486: --Initialize API return status to success.
7487: x_return_status := fnd_api.g_ret_sts_success;

Line 7502: fnd_msg_pub.add;

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

Line 7511: fnd_msg_pub.add;

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

Line 7537: fnd_msg_pub.add;

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

Line 7626: fnd_msg_pub.count_and_get(

7622: hz_common_pub.enable_cont_source_security;
7623: END IF;
7624:
7625: --Standard call to get message count and if count is 1, get message info.
7626: fnd_msg_pub.count_and_get(
7627: p_encoded => fnd_api.g_false,
7628: p_count => x_msg_count,
7629: p_data => x_msg_data);
7630:

Line 7639: fnd_msg_pub.count_and_get(

7635: END IF;
7636:
7637: x_return_status := fnd_api.g_ret_sts_error;
7638:
7639: fnd_msg_pub.count_and_get(
7640: p_encoded => fnd_api.g_false,
7641: p_count => x_msg_count,
7642: p_data => x_msg_data);
7643:

Line 7651: fnd_msg_pub.count_and_get(

7647: END IF;
7648:
7649: x_return_status := fnd_api.g_ret_sts_unexp_error;
7650:
7651: fnd_msg_pub.count_and_get(
7652: p_encoded => fnd_api.g_false,
7653: p_count => x_msg_count,
7654: p_data => x_msg_data);
7655:

Line 7665: fnd_msg_pub.add;

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

Line 7667: fnd_msg_pub.count_and_get(

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,
7669: p_count => x_msg_count,
7670: p_data => x_msg_data);
7671:

Line 7748: fnd_msg_pub.initialize;

7744: BEGIN
7745:
7746: --Initialize message list if p_init_msg_list is set to TRUE.
7747: IF fnd_api.to_boolean(p_init_msg_list) THEN
7748: fnd_msg_pub.initialize;
7749: END IF;
7750:
7751: --Initialize API return status to success.
7752: x_return_status := fnd_api.g_ret_sts_success;

Line 7760: fnd_msg_pub.add;

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

Line 7775: fnd_msg_pub.add;

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

Line 7869: fnd_msg_pub.count_and_get(

7865: x_application_id => x_group_rec.application_id
7866: );
7867:
7868: --Standard call to get message count and if count is 1, get message info.
7869: fnd_msg_pub.count_and_get(
7870: p_encoded => fnd_api.g_false,
7871: p_count => x_msg_count,
7872: p_data => x_msg_data);
7873:

Line 7878: fnd_msg_pub.count_and_get(

7874: EXCEPTION
7875: WHEN fnd_api.g_exc_error THEN
7876: x_return_status := fnd_api.g_ret_sts_error;
7877:
7878: fnd_msg_pub.count_and_get(
7879: p_encoded => fnd_api.g_false,
7880: p_count => x_msg_count,
7881: p_data => x_msg_data);
7882:

Line 7886: fnd_msg_pub.count_and_get(

7882:
7883: WHEN fnd_api.g_exc_unexpected_error THEN
7884: x_return_status := fnd_api.g_ret_sts_unexp_error;
7885:
7886: fnd_msg_pub.count_and_get(
7887: p_encoded => fnd_api.g_false,
7888: p_count => x_msg_count,
7889: p_data => x_msg_data);
7890:

Line 7896: fnd_msg_pub.add;

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

Line 7898: fnd_msg_pub.count_and_get(

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,
7900: p_count => x_msg_count,
7901: p_data => x_msg_data);
7902:

Line 7972: fnd_msg_pub.initialize;

7968: BEGIN
7969:
7970: --Initialize message list if p_init_msg_list is set to TRUE.
7971: IF fnd_api.to_boolean(p_init_msg_list) THEN
7972: fnd_msg_pub.initialize;
7973: END IF;
7974:
7975: --Initialize API return status to success.
7976: x_return_status := fnd_api.g_ret_sts_success;

Line 7984: fnd_msg_pub.add;

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

Line 8077: fnd_msg_pub.count_and_get(

8073: x_application_id => l_application_id
8074: );
8075:
8076: --Standard call to get message count and if count is 1, get message info.
8077: fnd_msg_pub.count_and_get(
8078: p_encoded => fnd_api.g_false,
8079: p_count => x_msg_count,
8080: p_data => x_msg_data);
8081:

Line 8086: fnd_msg_pub.count_and_get(

8082: EXCEPTION
8083: WHEN fnd_api.g_exc_error THEN
8084: x_return_status := fnd_api.g_ret_sts_error;
8085:
8086: fnd_msg_pub.count_and_get(
8087: p_encoded => fnd_api.g_false,
8088: p_count => x_msg_count,
8089: p_data => x_msg_data);
8090:

Line 8094: fnd_msg_pub.count_and_get(

8090:
8091: WHEN fnd_api.g_exc_unexpected_error THEN
8092: x_return_status := fnd_api.g_ret_sts_unexp_error;
8093:
8094: fnd_msg_pub.count_and_get(
8095: p_encoded => fnd_api.g_false,
8096: p_count => x_msg_count,
8097: p_data => x_msg_data);
8098:

Line 8104: fnd_msg_pub.add;

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

Line 8106: fnd_msg_pub.count_and_get(

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,
8108: p_count => x_msg_count,
8109: p_data => x_msg_data);
8110: