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

626: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
627: fnd_message.set_token('FK', 'party_id');
628: fnd_message.set_token('COLUMN', 'party_id');
629: fnd_message.set_token('TABLE', 'hz_parties');
630: fnd_msg_pub.add;
631: x_return_status := fnd_api.g_ret_sts_error;
632:
633: END;
634:

Line 763: FND_MSG_PUB.ADD;

759: then
760: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
761: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference+owner_table_id');
762: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
763: FND_MSG_PUB.ADD;
764: x_return_status := FND_API.G_RET_STS_ERROR;
765: RAISE FND_API.G_EXC_ERROR;
766: end if;
767: end if;

Line 776: FND_MSG_PUB.ADD;

772: then
773: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
774: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference+owner_table_id+orig_system_ref_id');
775: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
776: FND_MSG_PUB.ADD;
777: x_return_status := FND_API.G_RET_STS_ERROR;
778: RAISE FND_API.G_EXC_ERROR;
779: end if;
780: l_orig_system_ref_id := p_orig_sys_reference_rec.orig_system_ref_id;

Line 791: FND_MSG_PUB.ADD;

787: if l_count > 1
788: then
789: FND_MESSAGE.SET_NAME('AR', 'HZ_MOSR_CANNOT_UPDATE');
790: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference');
791: FND_MSG_PUB.ADD;
792: x_return_status := FND_API.G_RET_STS_ERROR;
793: RAISE FND_API.G_EXC_ERROR;
794: elsif l_count = 0
795: then

Line 799: FND_MSG_PUB.ADD;

795: then
796: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
797: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference');
798: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
799: FND_MSG_PUB.ADD;
800: x_return_status := FND_API.G_RET_STS_ERROR;
801: RAISE FND_API.G_EXC_ERROR;
802: elsif l_count = 1
803: then

Line 827: FND_MSG_PUB.ADD;

823: OR (p_object_version_number = l_object_version_number))
824: THEN
825: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
826: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
827: FND_MSG_PUB.ADD;
828: x_return_status := FND_API.G_RET_STS_ERROR;
829: RAISE FND_API.G_EXC_ERROR;
830: END IF;
831:

Line 838: FND_MSG_PUB.ADD;

834: EXCEPTION WHEN NO_DATA_FOUND THEN
835: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
836: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_ORIG_SYS_REFERENCES');
837: FND_MESSAGE.SET_TOKEN('VALUE', l_orig_system_ref_id);
838: FND_MSG_PUB.ADD;
839: RAISE FND_API.G_EXC_ERROR;
840: END;
841:
842: -- Bug 4206884: Raise an error if orig_system_reference of a purchased content source is updated

Line 850: FND_MSG_PUB.ADD;

846: then
847: if HZ_UTILITY_V2PUB.is_purchased_content_source(l_orig_system) = 'Y'
848: then
849: FND_MESSAGE.SET_NAME('AR', 'HZ_SSM_NO_UPDATE_PUR');
850: FND_MSG_PUB.ADD;
851: RAISE FND_API.G_EXC_ERROR;
852: end if;
853: end if;
854:

Line 970: fnd_msg_pub.add;

966: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
967: fnd_message.set_token('FK', 'party_id');
968: fnd_message.set_token('COLUMN', 'party_id');
969: fnd_message.set_token('TABLE', 'hz_parties');
970: fnd_msg_pub.add;
971: x_return_status := fnd_api.g_ret_sts_error;
972:
973: END;
974:

Line 1067: FND_MSG_PUB.initialize;

1063: SAVEPOINT create_orig_sys_reference;
1064:
1065: -- initialize message list if p_init_msg_list is set to TRUE.
1066: IF FND_API.to_Boolean(p_init_msg_list) THEN
1067: FND_MSG_PUB.initialize;
1068: END IF;
1069:
1070: -- initialize API return status to success.
1071: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1109: FND_MSG_PUB.ADD;

1105: fetch get_orig_system_new into l_dummy ;
1106: if get_orig_system_new%FOUND then
1107: if p_validation_level = FND_API.G_VALID_LEVEL_FULL then
1108: FND_MESSAGE.SET_NAME( 'AR', 'HZ_MOSR_NO_MULTIPLE_ALLOWED' );
1109: FND_MSG_PUB.ADD;
1110: x_return_status := FND_API.G_RET_STS_ERROR;
1111: end if;
1112: else
1113: --//logic for populating party_id

Line 1144: FND_MSG_PUB.Count_And_Get(

1140: end if;
1141:
1142:
1143: -- standard call to get message count and if count is 1, get message info.
1144: FND_MSG_PUB.Count_And_Get(
1145: p_encoded => FND_API.G_FALSE,
1146: p_count => x_msg_count,
1147: p_data => x_msg_data);
1148:

Line 1153: FND_MSG_PUB.Count_And_Get(

1149: EXCEPTION
1150: WHEN FND_API.G_EXC_ERROR THEN
1151: ROLLBACK TO create_orig_sys_reference;
1152: x_return_status := FND_API.G_RET_STS_ERROR;
1153: FND_MSG_PUB.Count_And_Get(
1154: p_encoded => FND_API.G_FALSE,
1155: p_count => x_msg_count,
1156: p_data => x_msg_data);
1157:

Line 1161: FND_MSG_PUB.Count_And_Get(

1157:
1158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1159: ROLLBACK TO create_orig_sys_reference;
1160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1161: FND_MSG_PUB.Count_And_Get(
1162: p_encoded => FND_API.G_FALSE,
1163: p_count => x_msg_count,
1164: p_data => x_msg_data);
1165:

Line 1171: FND_MSG_PUB.ADD;

1167: ROLLBACK TO create_orig_sys_reference;
1168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1169: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1170: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1171: FND_MSG_PUB.ADD;
1172: FND_MSG_PUB.Count_And_Get(
1173: p_encoded => FND_API.G_FALSE,
1174: p_count => x_msg_count,
1175: p_data => x_msg_data);

Line 1172: FND_MSG_PUB.Count_And_Get(

1168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1169: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1170: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1171: FND_MSG_PUB.ADD;
1172: FND_MSG_PUB.Count_And_Get(
1173: p_encoded => FND_API.G_FALSE,
1174: p_count => x_msg_count,
1175: p_data => x_msg_data);
1176:

Line 1245: FND_MSG_PUB.initialize;

1241: SAVEPOINT update_orig_sys_reference;
1242:
1243: -- initialize message list if p_init_msg_list is set to TRUE.
1244: IF FND_API.to_Boolean(p_init_msg_list) THEN
1245: FND_MSG_PUB.initialize;
1246: END IF;
1247:
1248: -- initialize API return status to success.
1249: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1320: FND_MSG_PUB.ADD;

1316: x_return_status );
1317: else
1318: if p_validation_level = FND_API.G_VALID_LEVEL_FULL then
1319: FND_MESSAGE.SET_NAME( 'AR', 'HZ_MOSR_NO_MULTIPLE_ALLOWED' );
1320: FND_MSG_PUB.ADD;
1321: x_return_status := FND_API.G_RET_STS_ERROR;
1322: end if;
1323: end if;
1324: else

Line 1435: FND_MSG_PUB.ADD;

1431: fetch get_orig_system_new into l_dummy ;
1432: if get_orig_system_new%FOUND then
1433: if p_validation_level = FND_API.G_VALID_LEVEL_FULL then
1434: FND_MESSAGE.SET_NAME( 'AR', 'HZ_MOSR_NO_MULTIPLE_ALLOWED' );
1435: FND_MSG_PUB.ADD;
1436: x_return_status := FND_API.G_RET_STS_ERROR;
1437: end if;
1438: else
1439: --//logic for populating party_id

Line 1492: FND_MSG_PUB.Count_And_Get(

1488:
1489:
1490:
1491: -- standard call to get message count and if count is 1, get message info.
1492: FND_MSG_PUB.Count_And_Get(
1493: p_encoded => FND_API.G_FALSE,
1494: p_count => x_msg_count,
1495: p_data => x_msg_data);
1496:

Line 1501: FND_MSG_PUB.Count_And_Get(

1497: EXCEPTION
1498: WHEN FND_API.G_EXC_ERROR THEN
1499: ROLLBACK TO update_orig_sys_reference;
1500: x_return_status := FND_API.G_RET_STS_ERROR;
1501: FND_MSG_PUB.Count_And_Get(
1502: p_encoded => FND_API.G_FALSE,
1503: p_count => x_msg_count,
1504: p_data => x_msg_data);
1505:

Line 1509: FND_MSG_PUB.Count_And_Get(

1505:
1506: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1507: ROLLBACK TO update_orig_sys_reference;
1508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1509: FND_MSG_PUB.Count_And_Get(
1510: p_encoded => FND_API.G_FALSE,
1511: p_count => x_msg_count,
1512: p_data => x_msg_data);
1513:

Line 1519: FND_MSG_PUB.ADD;

1515: ROLLBACK TO update_orig_sys_reference;
1516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1517: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1518: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1519: FND_MSG_PUB.ADD;
1520: FND_MSG_PUB.Count_And_Get(
1521: p_encoded => FND_API.G_FALSE,
1522: p_count => x_msg_count,
1523: p_data => x_msg_data);

Line 1520: FND_MSG_PUB.Count_And_Get(

1516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1517: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1518: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1519: FND_MSG_PUB.ADD;
1520: FND_MSG_PUB.Count_And_Get(
1521: p_encoded => FND_API.G_FALSE,
1522: p_count => x_msg_count,
1523: p_data => x_msg_data);
1524:

Line 1772: FND_MSG_PUB.ADD;

1768: if p_validation_level = FND_API.G_VALID_LEVEL_FULL then--YES
1769: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
1770: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference+owner_table_id');
1771: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
1772: FND_MSG_PUB.ADD;
1773: x_return_status := FND_API.G_RET_STS_ERROR;
1774: end if;
1775: END IF;
1776: close get_orig_system_csr;

Line 1782: FND_MSG_PUB.Count_And_Get(

1778: EXCEPTION
1779: WHEN FND_API.G_EXC_ERROR THEN
1780: x_return_status := FND_API.G_RET_STS_ERROR;
1781:
1782: FND_MSG_PUB.Count_And_Get(
1783: p_encoded => FND_API.G_FALSE,
1784: p_count => x_msg_count,
1785: p_data => x_msg_data );
1786:

Line 1790: FND_MSG_PUB.Count_And_Get(

1786:
1787: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1789:
1790: FND_MSG_PUB.Count_And_Get(
1791: p_encoded => FND_API.G_FALSE,
1792: p_count => x_msg_count,
1793: p_data => x_msg_data );
1794:

Line 1800: FND_MSG_PUB.ADD;

1796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1797:
1798: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1799: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1800: FND_MSG_PUB.ADD;
1801:
1802: FND_MSG_PUB.Count_And_Get(
1803: p_encoded => FND_API.G_FALSE,
1804: p_count => x_msg_count,

Line 1802: FND_MSG_PUB.Count_And_Get(

1798: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1799: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1800: FND_MSG_PUB.ADD;
1801:
1802: FND_MSG_PUB.Count_And_Get(
1803: p_encoded => FND_API.G_FALSE,
1804: p_count => x_msg_count,
1805: p_data => x_msg_data );
1806:

Line 1892: FND_MSG_PUB.Count_And_Get(

1888: EXCEPTION
1889: WHEN FND_API.G_EXC_ERROR THEN
1890: x_return_status := FND_API.G_RET_STS_ERROR;
1891:
1892: FND_MSG_PUB.Count_And_Get(
1893: p_encoded => FND_API.G_FALSE,
1894: p_count => x_msg_count,
1895: p_data => x_msg_data );
1896:

Line 1900: FND_MSG_PUB.Count_And_Get(

1896:
1897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1899:
1900: FND_MSG_PUB.Count_And_Get(
1901: p_encoded => FND_API.G_FALSE,
1902: p_count => x_msg_count,
1903: p_data => x_msg_data );
1904:

Line 1910: FND_MSG_PUB.ADD;

1906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1907:
1908: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1909: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1910: FND_MSG_PUB.ADD;
1911:
1912: FND_MSG_PUB.Count_And_Get(
1913: p_encoded => FND_API.G_FALSE,
1914: p_count => x_msg_count,

Line 1912: FND_MSG_PUB.Count_And_Get(

1908: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1909: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1910: FND_MSG_PUB.ADD;
1911:
1912: FND_MSG_PUB.Count_And_Get(
1913: p_encoded => FND_API.G_FALSE,
1914: p_count => x_msg_count,
1915: p_data => x_msg_data );
1916:

Line 2198: FND_MSG_PUB.ADD;

2194: OR (p_object_version_number = l_object_version_number))
2195: THEN
2196: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
2197: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYSTEMS_B');
2198: FND_MSG_PUB.ADD;
2199: x_return_status := FND_API.G_RET_STS_ERROR;
2200: RAISE FND_API.G_EXC_ERROR;
2201: END IF;
2202:

Line 2209: FND_MSG_PUB.ADD;

2205: EXCEPTION WHEN NO_DATA_FOUND THEN
2206: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
2207: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_ORIG_SYSTEMS_B');
2208: FND_MESSAGE.SET_TOKEN('VALUE', p_orig_sys_rec.orig_system_id);
2209: FND_MSG_PUB.ADD;
2210: RAISE FND_API.G_EXC_ERROR;
2211: END;
2212:
2213:

Line 2310: FND_MSG_PUB.initialize;

2306: SAVEPOINT create_orig_system;
2307:
2308: -- initialize message list if p_init_msg_list is set to TRUE.
2309: IF FND_API.to_Boolean(p_init_msg_list) THEN
2310: FND_MSG_PUB.initialize;
2311: END IF;
2312:
2313: -- initialize API return status to success.
2314: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2324: FND_MSG_PUB.Count_And_Get(

2320: x_return_status );
2321:
2322:
2323: -- standard call to get message count and if count is 1, get message info.
2324: FND_MSG_PUB.Count_And_Get(
2325: p_encoded => FND_API.G_FALSE,
2326: p_count => x_msg_count,
2327: p_data => x_msg_data);
2328:

Line 2333: FND_MSG_PUB.Count_And_Get(

2329: EXCEPTION
2330: WHEN FND_API.G_EXC_ERROR THEN
2331: ROLLBACK TO create_orig_system;
2332: x_return_status := FND_API.G_RET_STS_ERROR;
2333: FND_MSG_PUB.Count_And_Get(
2334: p_encoded => FND_API.G_FALSE,
2335: p_count => x_msg_count,
2336: p_data => x_msg_data);
2337:

Line 2341: FND_MSG_PUB.Count_And_Get(

2337:
2338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2339: ROLLBACK TO create_orig_system;
2340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2341: FND_MSG_PUB.Count_And_Get(
2342: p_encoded => FND_API.G_FALSE,
2343: p_count => x_msg_count,
2344: p_data => x_msg_data);
2345:

Line 2351: FND_MSG_PUB.ADD;

2347: ROLLBACK TO create_orig_system;
2348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2349: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2350: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2351: FND_MSG_PUB.ADD;
2352: FND_MSG_PUB.Count_And_Get(
2353: p_encoded => FND_API.G_FALSE,
2354: p_count => x_msg_count,
2355: p_data => x_msg_data);

Line 2352: FND_MSG_PUB.Count_And_Get(

2348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2349: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2350: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2351: FND_MSG_PUB.ADD;
2352: FND_MSG_PUB.Count_And_Get(
2353: p_encoded => FND_API.G_FALSE,
2354: p_count => x_msg_count,
2355: p_data => x_msg_data);
2356: end create_orig_system;

Line 2376: FND_MSG_PUB.initialize;

2372: SAVEPOINT update_orig_system;
2373:
2374: -- initialize message list if p_init_msg_list is set to TRUE.
2375: IF FND_API.to_Boolean(p_init_msg_list) THEN
2376: FND_MSG_PUB.initialize;
2377: END IF;
2378:
2379: -- initialize API return status to success.
2380: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2391: FND_MSG_PUB.Count_And_Get(

2387: x_return_status );
2388:
2389:
2390: -- standard call to get message count and if count is 1, get message info.
2391: FND_MSG_PUB.Count_And_Get(
2392: p_encoded => FND_API.G_FALSE,
2393: p_count => x_msg_count,
2394: p_data => x_msg_data);
2395:

Line 2400: FND_MSG_PUB.Count_And_Get(

2396: EXCEPTION
2397: WHEN FND_API.G_EXC_ERROR THEN
2398: ROLLBACK TO update_orig_system;
2399: x_return_status := FND_API.G_RET_STS_ERROR;
2400: FND_MSG_PUB.Count_And_Get(
2401: p_encoded => FND_API.G_FALSE,
2402: p_count => x_msg_count,
2403: p_data => x_msg_data);
2404:

Line 2408: FND_MSG_PUB.Count_And_Get(

2404:
2405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2406: ROLLBACK TO update_orig_system;
2407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2408: FND_MSG_PUB.Count_And_Get(
2409: p_encoded => FND_API.G_FALSE,
2410: p_count => x_msg_count,
2411: p_data => x_msg_data);
2412:

Line 2418: FND_MSG_PUB.ADD;

2414: ROLLBACK TO update_orig_system;
2415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2416: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2417: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2418: FND_MSG_PUB.ADD;
2419: FND_MSG_PUB.Count_And_Get(
2420: p_encoded => FND_API.G_FALSE,
2421: p_count => x_msg_count,
2422: p_data => x_msg_data);

Line 2419: FND_MSG_PUB.Count_And_Get(

2415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2416: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2417: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2418: FND_MSG_PUB.ADD;
2419: FND_MSG_PUB.Count_And_Get(
2420: p_encoded => FND_API.G_FALSE,
2421: p_count => x_msg_count,
2422: p_data => x_msg_data);
2423: end update_orig_system;