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_ORIG_SYSTEM_REF_PVT dependencies on FND_MSG_PUB

Line 150: FND_MSG_PUB.initialize;

146: BEGIN
147:
148: --Initialize message list if p_init_msg_list is set to TRUE.
149: IF FND_API.To_Boolean(p_init_msg_list) THEN
150: FND_MSG_PUB.initialize;
151: END IF;
152:
153: --Initialize API return status to success.
154: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 162: FND_MSG_PUB.ADD;

158: p_orig_system_ref_id = FND_API.G_MISS_NUM)
159: THEN
160: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
161: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system_ref_id');
162: FND_MSG_PUB.ADD;
163: RAISE FND_API.G_EXC_ERROR;
164: END IF;
165:
166: HZ_ORIG_SYSTEM_REF_PKG.Select_Row (

Line 207: FND_MSG_PUB.Count_And_Get(

203: );
204: x_orig_sys_reference_rec.orig_system_ref_id := l_orig_system_ref_id;
205:
206: --Standard call to get message count and if count is 1, get message info.
207: FND_MSG_PUB.Count_And_Get(
208: p_encoded => FND_API.G_FALSE,
209: p_count => x_msg_count,
210: p_data => x_msg_data );
211:

Line 216: FND_MSG_PUB.Count_And_Get(

212: EXCEPTION
213: WHEN FND_API.G_EXC_ERROR THEN
214: x_return_status := FND_API.G_RET_STS_ERROR;
215:
216: FND_MSG_PUB.Count_And_Get(
217: p_encoded => FND_API.G_FALSE,
218: p_count => x_msg_count,
219: p_data => x_msg_data );
220:

Line 224: FND_MSG_PUB.Count_And_Get(

220:
221: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
223:
224: FND_MSG_PUB.Count_And_Get(
225: p_encoded => FND_API.G_FALSE,
226: p_count => x_msg_count,
227: p_data => x_msg_data );
228:

Line 234: FND_MSG_PUB.ADD;

230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
231:
232: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
233: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
234: FND_MSG_PUB.ADD;
235:
236: FND_MSG_PUB.Count_And_Get(
237: p_encoded => FND_API.G_FALSE,
238: p_count => x_msg_count,

Line 236: FND_MSG_PUB.Count_And_Get(

232: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
233: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
234: FND_MSG_PUB.ADD;
235:
236: FND_MSG_PUB.Count_And_Get(
237: p_encoded => FND_API.G_FALSE,
238: p_count => x_msg_count,
239: p_data => x_msg_data );
240:

Line 325: FND_MSG_PUB.ADD;

321: OR (p_object_version_number = l_object_version_number))
322: THEN
323: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
324: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_MAPPING');
325: FND_MSG_PUB.ADD;
326: x_return_status := FND_API.G_RET_STS_ERROR;
327: RAISE FND_API.G_EXC_ERROR;
328: END IF;
329:

Line 336: FND_MSG_PUB.ADD;

332: EXCEPTION WHEN NO_DATA_FOUND THEN
333: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
334: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_ORIG_SYS_MAPPING');
335: FND_MESSAGE.SET_TOKEN('VALUE', p_orig_sys_entity_map_rec.orig_system);
336: FND_MSG_PUB.ADD;
337: RAISE FND_API.G_EXC_ERROR;
338: END;
339: if p_validation_level = FND_API.G_VALID_LEVEL_FULL
340: then

Line 403: FND_MSG_PUB.initialize;

399: SAVEPOINT create_orig_sys_entity_mapping;
400:
401: -- initialize message list if p_init_msg_list is set to TRUE.
402: IF FND_API.to_Boolean(p_init_msg_list) THEN
403: FND_MSG_PUB.initialize;
404: END IF;
405:
406: -- initialize API return status to success.
407: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 417: FND_MSG_PUB.Count_And_Get(

413: x_return_status );
414:
415:
416: -- standard call to get message count and if count is 1, get message info.
417: FND_MSG_PUB.Count_And_Get(
418: p_encoded => FND_API.G_FALSE,
419: p_count => x_msg_count,
420: p_data => x_msg_data);
421:

Line 426: FND_MSG_PUB.Count_And_Get(

422: EXCEPTION
423: WHEN FND_API.G_EXC_ERROR THEN
424: ROLLBACK TO create_orig_sys_entity_mapping;
425: x_return_status := FND_API.G_RET_STS_ERROR;
426: FND_MSG_PUB.Count_And_Get(
427: p_encoded => FND_API.G_FALSE,
428: p_count => x_msg_count,
429: p_data => x_msg_data);
430:

Line 434: FND_MSG_PUB.Count_And_Get(

430:
431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
432: ROLLBACK TO create_orig_sys_entity_mapping;
433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
434: FND_MSG_PUB.Count_And_Get(
435: p_encoded => FND_API.G_FALSE,
436: p_count => x_msg_count,
437: p_data => x_msg_data);
438:

Line 444: FND_MSG_PUB.ADD;

440: ROLLBACK TO create_orig_sys_entity_mapping;
441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
442: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
443: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
444: FND_MSG_PUB.ADD;
445: FND_MSG_PUB.Count_And_Get(
446: p_encoded => FND_API.G_FALSE,
447: p_count => x_msg_count,
448: p_data => x_msg_data);

Line 445: FND_MSG_PUB.Count_And_Get(

441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
442: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
443: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
444: FND_MSG_PUB.ADD;
445: FND_MSG_PUB.Count_And_Get(
446: p_encoded => FND_API.G_FALSE,
447: p_count => x_msg_count,
448: p_data => x_msg_data);
449: end create_orig_sys_entity_mapping;

Line 469: FND_MSG_PUB.initialize;

465: SAVEPOINT update_orig_sys_entity_mapping;
466:
467: -- initialize message list if p_init_msg_list is set to TRUE.
468: IF FND_API.to_Boolean(p_init_msg_list) THEN
469: FND_MSG_PUB.initialize;
470: END IF;
471:
472: -- initialize API return status to success.
473: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 483: FND_MSG_PUB.Count_And_Get(

479: p_object_version_number,
480: x_return_status );
481:
482: -- standard call to get message count and if count is 1, get message info.
483: FND_MSG_PUB.Count_And_Get(
484: p_encoded => FND_API.G_FALSE,
485: p_count => x_msg_count,
486: p_data => x_msg_data);
487:

Line 492: FND_MSG_PUB.Count_And_Get(

488: EXCEPTION
489: WHEN FND_API.G_EXC_ERROR THEN
490: ROLLBACK TO update_orig_sys_entity_mapping;
491: x_return_status := FND_API.G_RET_STS_ERROR;
492: FND_MSG_PUB.Count_And_Get(
493: p_encoded => FND_API.G_FALSE,
494: p_count => x_msg_count,
495: p_data => x_msg_data);
496:

Line 500: FND_MSG_PUB.Count_And_Get(

496:
497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
498: ROLLBACK TO update_orig_sys_entity_mapping;
499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
500: FND_MSG_PUB.Count_And_Get(
501: p_encoded => FND_API.G_FALSE,
502: p_count => x_msg_count,
503: p_data => x_msg_data);
504:

Line 510: FND_MSG_PUB.ADD;

506: ROLLBACK TO update_orig_sys_entity_mapping;
507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
508: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
509: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
510: FND_MSG_PUB.ADD;
511: FND_MSG_PUB.Count_And_Get(
512: p_encoded => FND_API.G_FALSE,
513: p_count => x_msg_count,
514: p_data => x_msg_data);

Line 511: FND_MSG_PUB.Count_And_Get(

507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
508: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
509: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
510: FND_MSG_PUB.ADD;
511: FND_MSG_PUB.Count_And_Get(
512: p_encoded => FND_API.G_FALSE,
513: p_count => x_msg_count,
514: p_data => x_msg_data);
515:

Line 647: fnd_msg_pub.add;

643: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
644: fnd_message.set_token('FK', 'party_id');
645: fnd_message.set_token('COLUMN', 'party_id');
646: fnd_message.set_token('TABLE', 'hz_parties');
647: fnd_msg_pub.add;
648: x_return_status := fnd_api.g_ret_sts_error;
649:
650: END;
651:

Line 785: FND_MSG_PUB.ADD;

781: then
782: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
783: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference+owner_table_id');
784: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
785: FND_MSG_PUB.ADD;
786: x_return_status := FND_API.G_RET_STS_ERROR;
787: RAISE FND_API.G_EXC_ERROR;
788: end if;
789: end if;

Line 798: FND_MSG_PUB.ADD;

794: then
795: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
796: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference+owner_table_id+orig_system_ref_id');
797: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
798: FND_MSG_PUB.ADD;
799: x_return_status := FND_API.G_RET_STS_ERROR;
800: RAISE FND_API.G_EXC_ERROR;
801: end if;
802: l_orig_system_ref_id := p_orig_sys_reference_rec.orig_system_ref_id;

Line 813: FND_MSG_PUB.ADD;

809: if l_count > 1
810: then
811: FND_MESSAGE.SET_NAME('AR', 'HZ_MOSR_CANNOT_UPDATE');
812: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference');
813: FND_MSG_PUB.ADD;
814: x_return_status := FND_API.G_RET_STS_ERROR;
815: RAISE FND_API.G_EXC_ERROR;
816: elsif l_count = 0
817: then

Line 821: FND_MSG_PUB.ADD;

817: then
818: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
819: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference');
820: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
821: FND_MSG_PUB.ADD;
822: x_return_status := FND_API.G_RET_STS_ERROR;
823: RAISE FND_API.G_EXC_ERROR;
824: elsif l_count = 1
825: then

Line 849: FND_MSG_PUB.ADD;

845: OR (p_object_version_number = l_object_version_number))
846: THEN
847: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
848: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
849: FND_MSG_PUB.ADD;
850: x_return_status := FND_API.G_RET_STS_ERROR;
851: RAISE FND_API.G_EXC_ERROR;
852: END IF;
853:

Line 860: FND_MSG_PUB.ADD;

856: EXCEPTION WHEN NO_DATA_FOUND THEN
857: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
858: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_ORIG_SYS_REFERENCES');
859: FND_MESSAGE.SET_TOKEN('VALUE', l_orig_system_ref_id);
860: FND_MSG_PUB.ADD;
861: RAISE FND_API.G_EXC_ERROR;
862: END;
863:
864: -- Bug 4206884: Raise an error if orig_system_reference of a purchased content source is updated

Line 872: FND_MSG_PUB.ADD;

868: then
869: if HZ_UTILITY_V2PUB.is_purchased_content_source(l_orig_system) = 'Y'
870: then
871: FND_MESSAGE.SET_NAME('AR', 'HZ_SSM_NO_UPDATE_PUR');
872: FND_MSG_PUB.ADD;
873: RAISE FND_API.G_EXC_ERROR;
874: end if;
875: end if;
876:

Line 999: fnd_msg_pub.add;

995: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
996: fnd_message.set_token('FK', 'party_id');
997: fnd_message.set_token('COLUMN', 'party_id');
998: fnd_message.set_token('TABLE', 'hz_parties');
999: fnd_msg_pub.add;
1000: x_return_status := fnd_api.g_ret_sts_error;
1001:
1002: END;
1003:

Line 1096: FND_MSG_PUB.initialize;

1092: SAVEPOINT create_orig_sys_reference;
1093:
1094: -- initialize message list if p_init_msg_list is set to TRUE.
1095: IF FND_API.to_Boolean(p_init_msg_list) THEN
1096: FND_MSG_PUB.initialize;
1097: END IF;
1098:
1099: -- initialize API return status to success.
1100: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1138: FND_MSG_PUB.ADD;

1134: fetch get_orig_system_new into l_dummy ;
1135: if get_orig_system_new%FOUND then
1136: if p_validation_level = FND_API.G_VALID_LEVEL_FULL then
1137: FND_MESSAGE.SET_NAME( 'AR', 'HZ_MOSR_NO_MULTIPLE_ALLOWED' );
1138: FND_MSG_PUB.ADD;
1139: x_return_status := FND_API.G_RET_STS_ERROR;
1140: end if;
1141: else
1142: --//logic for populating party_id

Line 1173: FND_MSG_PUB.Count_And_Get(

1169: end if;
1170:
1171:
1172: -- standard call to get message count and if count is 1, get message info.
1173: FND_MSG_PUB.Count_And_Get(
1174: p_encoded => FND_API.G_FALSE,
1175: p_count => x_msg_count,
1176: p_data => x_msg_data);
1177:

Line 1182: FND_MSG_PUB.Count_And_Get(

1178: EXCEPTION
1179: WHEN FND_API.G_EXC_ERROR THEN
1180: ROLLBACK TO create_orig_sys_reference;
1181: x_return_status := FND_API.G_RET_STS_ERROR;
1182: FND_MSG_PUB.Count_And_Get(
1183: p_encoded => FND_API.G_FALSE,
1184: p_count => x_msg_count,
1185: p_data => x_msg_data);
1186:

Line 1190: FND_MSG_PUB.Count_And_Get(

1186:
1187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1188: ROLLBACK TO create_orig_sys_reference;
1189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1190: FND_MSG_PUB.Count_And_Get(
1191: p_encoded => FND_API.G_FALSE,
1192: p_count => x_msg_count,
1193: p_data => x_msg_data);
1194:

Line 1200: FND_MSG_PUB.ADD;

1196: ROLLBACK TO create_orig_sys_reference;
1197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1198: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1199: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1200: FND_MSG_PUB.ADD;
1201: FND_MSG_PUB.Count_And_Get(
1202: p_encoded => FND_API.G_FALSE,
1203: p_count => x_msg_count,
1204: p_data => x_msg_data);

Line 1201: FND_MSG_PUB.Count_And_Get(

1197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1198: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1199: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1200: FND_MSG_PUB.ADD;
1201: FND_MSG_PUB.Count_And_Get(
1202: p_encoded => FND_API.G_FALSE,
1203: p_count => x_msg_count,
1204: p_data => x_msg_data);
1205:

Line 1274: FND_MSG_PUB.initialize;

1270: SAVEPOINT update_orig_sys_reference;
1271:
1272: -- initialize message list if p_init_msg_list is set to TRUE.
1273: IF FND_API.to_Boolean(p_init_msg_list) THEN
1274: FND_MSG_PUB.initialize;
1275: END IF;
1276:
1277: -- initialize API return status to success.
1278: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1349: FND_MSG_PUB.ADD;

1345: x_return_status );
1346: else
1347: if p_validation_level = FND_API.G_VALID_LEVEL_FULL then
1348: FND_MESSAGE.SET_NAME( 'AR', 'HZ_MOSR_NO_MULTIPLE_ALLOWED' );
1349: FND_MSG_PUB.ADD;
1350: x_return_status := FND_API.G_RET_STS_ERROR;
1351: end if;
1352: end if;
1353: else

Line 1464: FND_MSG_PUB.ADD;

1460: fetch get_orig_system_new into l_dummy ;
1461: if get_orig_system_new%FOUND then
1462: if p_validation_level = FND_API.G_VALID_LEVEL_FULL then
1463: FND_MESSAGE.SET_NAME( 'AR', 'HZ_MOSR_NO_MULTIPLE_ALLOWED' );
1464: FND_MSG_PUB.ADD;
1465: x_return_status := FND_API.G_RET_STS_ERROR;
1466: end if;
1467: else
1468: --//logic for populating party_id

Line 1529: FND_MSG_PUB.Count_And_Get(

1525:
1526:
1527:
1528: -- standard call to get message count and if count is 1, get message info.
1529: FND_MSG_PUB.Count_And_Get(
1530: p_encoded => FND_API.G_FALSE,
1531: p_count => x_msg_count,
1532: p_data => x_msg_data);
1533:

Line 1538: FND_MSG_PUB.Count_And_Get(

1534: EXCEPTION
1535: WHEN FND_API.G_EXC_ERROR THEN
1536: ROLLBACK TO update_orig_sys_reference;
1537: x_return_status := FND_API.G_RET_STS_ERROR;
1538: FND_MSG_PUB.Count_And_Get(
1539: p_encoded => FND_API.G_FALSE,
1540: p_count => x_msg_count,
1541: p_data => x_msg_data);
1542:

Line 1546: FND_MSG_PUB.Count_And_Get(

1542:
1543: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1544: ROLLBACK TO update_orig_sys_reference;
1545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1546: FND_MSG_PUB.Count_And_Get(
1547: p_encoded => FND_API.G_FALSE,
1548: p_count => x_msg_count,
1549: p_data => x_msg_data);
1550:

Line 1556: FND_MSG_PUB.ADD;

1552: ROLLBACK TO update_orig_sys_reference;
1553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1554: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1555: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1556: FND_MSG_PUB.ADD;
1557: FND_MSG_PUB.Count_And_Get(
1558: p_encoded => FND_API.G_FALSE,
1559: p_count => x_msg_count,
1560: p_data => x_msg_data);

Line 1557: FND_MSG_PUB.Count_And_Get(

1553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1554: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1555: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1556: FND_MSG_PUB.ADD;
1557: FND_MSG_PUB.Count_And_Get(
1558: p_encoded => FND_API.G_FALSE,
1559: p_count => x_msg_count,
1560: p_data => x_msg_data);
1561:

Line 1817: FND_MSG_PUB.ADD;

1813: if p_validation_level = FND_API.G_VALID_LEVEL_FULL then--YES
1814: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
1815: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference+owner_table_id');
1816: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
1817: FND_MSG_PUB.ADD;
1818: x_return_status := FND_API.G_RET_STS_ERROR;
1819: end if;
1820: END IF;
1821: close get_orig_system_csr;

Line 1827: FND_MSG_PUB.Count_And_Get(

1823: EXCEPTION
1824: WHEN FND_API.G_EXC_ERROR THEN
1825: x_return_status := FND_API.G_RET_STS_ERROR;
1826:
1827: FND_MSG_PUB.Count_And_Get(
1828: p_encoded => FND_API.G_FALSE,
1829: p_count => x_msg_count,
1830: p_data => x_msg_data );
1831:

Line 1835: FND_MSG_PUB.Count_And_Get(

1831:
1832: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1834:
1835: FND_MSG_PUB.Count_And_Get(
1836: p_encoded => FND_API.G_FALSE,
1837: p_count => x_msg_count,
1838: p_data => x_msg_data );
1839:

Line 1845: FND_MSG_PUB.ADD;

1841: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1842:
1843: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1844: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1845: FND_MSG_PUB.ADD;
1846:
1847: FND_MSG_PUB.Count_And_Get(
1848: p_encoded => FND_API.G_FALSE,
1849: p_count => x_msg_count,

Line 1847: FND_MSG_PUB.Count_And_Get(

1843: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1844: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1845: FND_MSG_PUB.ADD;
1846:
1847: FND_MSG_PUB.Count_And_Get(
1848: p_encoded => FND_API.G_FALSE,
1849: p_count => x_msg_count,
1850: p_data => x_msg_data );
1851:

Line 1937: FND_MSG_PUB.Count_And_Get(

1933: EXCEPTION
1934: WHEN FND_API.G_EXC_ERROR THEN
1935: x_return_status := FND_API.G_RET_STS_ERROR;
1936:
1937: FND_MSG_PUB.Count_And_Get(
1938: p_encoded => FND_API.G_FALSE,
1939: p_count => x_msg_count,
1940: p_data => x_msg_data );
1941:

Line 1945: FND_MSG_PUB.Count_And_Get(

1941:
1942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1944:
1945: FND_MSG_PUB.Count_And_Get(
1946: p_encoded => FND_API.G_FALSE,
1947: p_count => x_msg_count,
1948: p_data => x_msg_data );
1949:

Line 1955: FND_MSG_PUB.ADD;

1951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1952:
1953: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1954: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1955: FND_MSG_PUB.ADD;
1956:
1957: FND_MSG_PUB.Count_And_Get(
1958: p_encoded => FND_API.G_FALSE,
1959: p_count => x_msg_count,

Line 1957: FND_MSG_PUB.Count_And_Get(

1953: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1954: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1955: FND_MSG_PUB.ADD;
1956:
1957: FND_MSG_PUB.Count_And_Get(
1958: p_encoded => FND_API.G_FALSE,
1959: p_count => x_msg_count,
1960: p_data => x_msg_data );
1961:

Line 2245: FND_MSG_PUB.ADD;

2241: OR (p_object_version_number = l_object_version_number))
2242: THEN
2243: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
2244: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYSTEMS_B');
2245: FND_MSG_PUB.ADD;
2246: x_return_status := FND_API.G_RET_STS_ERROR;
2247: RAISE FND_API.G_EXC_ERROR;
2248: END IF;
2249:

Line 2256: FND_MSG_PUB.ADD;

2252: EXCEPTION WHEN NO_DATA_FOUND THEN
2253: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
2254: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_ORIG_SYSTEMS_B');
2255: FND_MESSAGE.SET_TOKEN('VALUE', p_orig_sys_rec.orig_system_id);
2256: FND_MSG_PUB.ADD;
2257: RAISE FND_API.G_EXC_ERROR;
2258: END;
2259:
2260:

Line 2357: FND_MSG_PUB.initialize;

2353: SAVEPOINT create_orig_system;
2354:
2355: -- initialize message list if p_init_msg_list is set to TRUE.
2356: IF FND_API.to_Boolean(p_init_msg_list) THEN
2357: FND_MSG_PUB.initialize;
2358: END IF;
2359:
2360: -- initialize API return status to success.
2361: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2371: FND_MSG_PUB.Count_And_Get(

2367: x_return_status );
2368:
2369:
2370: -- standard call to get message count and if count is 1, get message info.
2371: FND_MSG_PUB.Count_And_Get(
2372: p_encoded => FND_API.G_FALSE,
2373: p_count => x_msg_count,
2374: p_data => x_msg_data);
2375:

Line 2380: FND_MSG_PUB.Count_And_Get(

2376: EXCEPTION
2377: WHEN FND_API.G_EXC_ERROR THEN
2378: ROLLBACK TO create_orig_system;
2379: x_return_status := FND_API.G_RET_STS_ERROR;
2380: FND_MSG_PUB.Count_And_Get(
2381: p_encoded => FND_API.G_FALSE,
2382: p_count => x_msg_count,
2383: p_data => x_msg_data);
2384:

Line 2388: FND_MSG_PUB.Count_And_Get(

2384:
2385: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2386: ROLLBACK TO create_orig_system;
2387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2388: FND_MSG_PUB.Count_And_Get(
2389: p_encoded => FND_API.G_FALSE,
2390: p_count => x_msg_count,
2391: p_data => x_msg_data);
2392:

Line 2398: FND_MSG_PUB.ADD;

2394: ROLLBACK TO create_orig_system;
2395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2396: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2397: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2398: FND_MSG_PUB.ADD;
2399: FND_MSG_PUB.Count_And_Get(
2400: p_encoded => FND_API.G_FALSE,
2401: p_count => x_msg_count,
2402: p_data => x_msg_data);

Line 2399: FND_MSG_PUB.Count_And_Get(

2395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2396: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2397: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2398: FND_MSG_PUB.ADD;
2399: FND_MSG_PUB.Count_And_Get(
2400: p_encoded => FND_API.G_FALSE,
2401: p_count => x_msg_count,
2402: p_data => x_msg_data);
2403: end create_orig_system;

Line 2423: FND_MSG_PUB.initialize;

2419: SAVEPOINT update_orig_system;
2420:
2421: -- initialize message list if p_init_msg_list is set to TRUE.
2422: IF FND_API.to_Boolean(p_init_msg_list) THEN
2423: FND_MSG_PUB.initialize;
2424: END IF;
2425:
2426: -- initialize API return status to success.
2427: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2438: FND_MSG_PUB.Count_And_Get(

2434: x_return_status );
2435:
2436:
2437: -- standard call to get message count and if count is 1, get message info.
2438: FND_MSG_PUB.Count_And_Get(
2439: p_encoded => FND_API.G_FALSE,
2440: p_count => x_msg_count,
2441: p_data => x_msg_data);
2442:

Line 2447: FND_MSG_PUB.Count_And_Get(

2443: EXCEPTION
2444: WHEN FND_API.G_EXC_ERROR THEN
2445: ROLLBACK TO update_orig_system;
2446: x_return_status := FND_API.G_RET_STS_ERROR;
2447: FND_MSG_PUB.Count_And_Get(
2448: p_encoded => FND_API.G_FALSE,
2449: p_count => x_msg_count,
2450: p_data => x_msg_data);
2451:

Line 2455: FND_MSG_PUB.Count_And_Get(

2451:
2452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2453: ROLLBACK TO update_orig_system;
2454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2455: FND_MSG_PUB.Count_And_Get(
2456: p_encoded => FND_API.G_FALSE,
2457: p_count => x_msg_count,
2458: p_data => x_msg_data);
2459:

Line 2465: FND_MSG_PUB.ADD;

2461: ROLLBACK TO update_orig_system;
2462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2463: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2464: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2465: FND_MSG_PUB.ADD;
2466: FND_MSG_PUB.Count_And_Get(
2467: p_encoded => FND_API.G_FALSE,
2468: p_count => x_msg_count,
2469: p_data => x_msg_data);

Line 2466: FND_MSG_PUB.Count_And_Get(

2462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2463: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2464: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2465: FND_MSG_PUB.ADD;
2466: FND_MSG_PUB.Count_And_Get(
2467: p_encoded => FND_API.G_FALSE,
2468: p_count => x_msg_count,
2469: p_data => x_msg_data);
2470: end update_orig_system;