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

Line 254: FND_MSG_PUB.ADD;

250: WHERE PARTY_SITE_ID = l_party_site_id;
251:
252: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
253: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_site_id');
254: FND_MSG_PUB.ADD;
255: RAISE FND_API.G_EXC_ERROR;
256:
257: EXCEPTION
258: WHEN NO_DATA_FOUND THEN

Line 277: FND_MSG_PUB.ADD;

273: l_party_site_number IS NULL
274: THEN
275: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
276: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_site_number');
277: FND_MSG_PUB.ADD;
278: RAISE FND_API.G_EXC_ERROR;
279: END IF;
280:
281: BEGIN

Line 289: FND_MSG_PUB.ADD;

285: WHERE PARTY_SITE_NUMBER = l_party_site_number;
286:
287: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
288: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_site_number');
289: FND_MSG_PUB.ADD;
290: RAISE FND_API.G_EXC_ERROR;
291:
292: EXCEPTION
293: WHEN NO_DATA_FOUND THEN

Line 307: FND_MSG_PUB.ADD;

303: AND
304: l_party_site_number IS NOT NULL
305: THEN
306: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PARTY_SITE_NUM_AUTO_ON');
307: FND_MSG_PUB.ADD;
308: RAISE FND_API.G_EXC_ERROR;
309: END IF;
310:
311: END IF;

Line 697: FND_MSG_PUB.ADD;

693: )
694: THEN
695: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
696: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_party_sites');
697: FND_MSG_PUB.ADD;
698: RAISE FND_API.G_EXC_ERROR;
699: END IF;
700:
701: p_object_version_number := nvl(l_object_version_number, 1) + 1;

Line 707: FND_MSG_PUB.ADD;

703: EXCEPTION WHEN NO_DATA_FOUND THEN
704: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
705: FND_MESSAGE.SET_TOKEN('RECORD', 'party site');
706: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_rec.party_site_id), 'null'));
707: FND_MSG_PUB.ADD;
708: RAISE FND_API.G_EXC_ERROR;
709: END;
710:
711: -- Bug 2197181: added for mix-n-match project.

Line 940: FND_MSG_PUB.ADD;

936: WHEN NO_DATA_FOUND THEN
937: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
938: FND_MESSAGE.SET_TOKEN('RECORD', 'Message Name');
939: --FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_use_rec.party_site_id), 'null'));
940: FND_MSG_PUB.ADD;
941: RAISE FND_API.G_EXC_ERROR;
942: END;
943: END IF;
944: IF g_message_name IS NOT NULL THEN

Line 1035: FND_MSG_PUB.ADD;

1031: WHERE PARTY_SITE_USE_ID = l_party_site_use_id;
1032:
1033: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
1034: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_site_use_id');
1035: FND_MSG_PUB.ADD;
1036: RAISE FND_API.G_EXC_ERROR;
1037:
1038: EXCEPTION
1039: WHEN NO_DATA_FOUND THEN

Line 1219: FND_MSG_PUB.ADD;

1215: )
1216: THEN
1217: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1218: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTY_SITE_USES');
1219: FND_MSG_PUB.ADD;
1220: RAISE FND_API.G_EXC_ERROR;
1221: END IF;
1222:
1223: p_object_version_number := nvl(l_object_version_number, 1) + 1;

Line 1229: FND_MSG_PUB.ADD;

1225: EXCEPTION WHEN NO_DATA_FOUND THEN
1226: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
1227: FND_MESSAGE.SET_TOKEN('RECORD', 'party site use');
1228: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_use_rec.party_site_use_id), 'null'));
1229: FND_MSG_PUB.ADD;
1230: RAISE FND_API.G_EXC_ERROR;
1231: END;
1232:
1233: -- unmark the previous site uses whose primary_per_type = 'Y'.

Line 1316: FND_MSG_PUB.ADD;

1312: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
1313: FND_MESSAGE.SET_TOKEN('FK', 'party site id');
1314: FND_MESSAGE.SET_TOKEN('COLUMN', 'party site id');
1315: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_party_sites');
1316: FND_MSG_PUB.ADD;
1317: RAISE FND_API.G_EXC_ERROR;
1318: END;
1319:
1320: -- call for validations.

Line 1427: FND_MSG_PUB.ADD;

1423: EXCEPTION
1424: WHEN OTHERS THEN
1425: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1426: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTIES');
1427: FND_MSG_PUB.ADD;
1428: RAISE FND_API.G_EXC_ERROR;
1429: END;
1430:
1431: -- if location_id is null, we will null out NOCOPY the location

Line 1549: FND_MSG_PUB.ADD;

1545: EXCEPTION
1546: WHEN OTHERS THEN
1547: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1548: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTY_SITES');
1549: FND_MSG_PUB.ADD;
1550: RAISE FND_API.G_EXC_ERROR;
1551: END;
1552:
1553: IF l_rowid IS NOT NULL THEN

Line 1645: FND_MSG_PUB.ADD;

1641: EXCEPTION
1642: WHEN OTHERS THEN
1643: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1644: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTY_SITE_USES');
1645: FND_MSG_PUB.ADD;
1646: RAISE FND_API.G_EXC_ERROR;
1647: END;
1648:
1649: IF l_rowid IS NOT NULL THEN

Line 1747: FND_MSG_PUB.initialize;

1743: END IF;
1744:
1745: -- initialize message list if p_init_msg_list is set to TRUE.
1746: IF FND_API.to_Boolean(p_init_msg_list) THEN
1747: FND_MSG_PUB.initialize;
1748: END IF;
1749:
1750: -- initialize API return status to success.
1751: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1816: FND_MSG_PUB.ADD;

1812: --
1813: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_INSERT_PRIVILEGE');
1814: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
1815: fnd_message.get_string('AR', 'HZ_DSS_PARTY_ADDRESSES'));
1816: FND_MSG_PUB.ADD;
1817: RAISE FND_API.G_EXC_ERROR;
1818: end if;
1819: END IF;
1820:

Line 1852: FND_MSG_PUB.Count_And_Get(

1848: END IF;
1849: END IF;
1850:
1851: -- standard call to get message count and if count is 1, get message info.
1852: FND_MSG_PUB.Count_And_Get(
1853: p_encoded => FND_API.G_FALSE,
1854: p_count => x_msg_count,
1855: p_data => x_msg_data);
1856:

Line 1877: FND_MSG_PUB.Count_And_Get(

1873: EXCEPTION
1874: WHEN FND_API.G_EXC_ERROR THEN
1875: ROLLBACK TO create_party_site;
1876: x_return_status := FND_API.G_RET_STS_ERROR;
1877: FND_MSG_PUB.Count_And_Get(
1878: p_encoded => FND_API.G_FALSE,
1879: p_count => x_msg_count,
1880: p_data => x_msg_data);
1881:

Line 1901: FND_MSG_PUB.Count_And_Get(

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

Line 1927: FND_MSG_PUB.ADD;

1923: ROLLBACK TO create_party_site;
1924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1925: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1926: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1927: FND_MSG_PUB.ADD;
1928: FND_MSG_PUB.Count_And_Get(
1929: p_encoded => FND_API.G_FALSE,
1930: p_count => x_msg_count,
1931: p_data => x_msg_data);

Line 1928: FND_MSG_PUB.Count_And_Get(

1924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1925: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1926: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1927: FND_MSG_PUB.ADD;
1928: FND_MSG_PUB.Count_And_Get(
1929: p_encoded => FND_API.G_FALSE,
1930: p_count => x_msg_count,
1931: p_data => x_msg_data);
1932:

Line 2020: FND_MSG_PUB.initialize;

2016: END IF;
2017:
2018: -- initialize message list if p_init_msg_list is set to TRUE.
2019: IF FND_API.to_Boolean(p_init_msg_list) THEN
2020: FND_MSG_PUB.initialize;
2021: END IF;
2022:
2023: -- initialize API return status to success.
2024: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2085: FND_MSG_PUB.ADD;

2081: --
2082: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
2083: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
2084: fnd_message.get_string('AR', 'HZ_DSS_PARTY_ADDRESSES'));
2085: FND_MSG_PUB.ADD;
2086: RAISE FND_API.G_EXC_ERROR;
2087: end if;
2088: END IF;
2089:

Line 2174: FND_MSG_PUB.ADD;

2170: WHEN NO_DATA_FOUND THEN
2171: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
2172: FND_MESSAGE.SET_TOKEN('RECORD', 'Message Name');
2173: --FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_use_rec.party_site_id), 'null'));
2174: FND_MSG_PUB.ADD;
2175: RAISE FND_API.G_EXC_ERROR;
2176: END;
2177: END IF;
2178: --IF l_release_name not in ( '11.5.1','11.5.2','11.5.3','11.5.4','11.5.5','11.5.6','11.5.7','11.5.8','11.5.9') THEN

Line 2192: FND_MSG_PUB.Count_And_Get(

2188: END IF;
2189: END IF;
2190:
2191: -- standard call to get message count and if count is 1, get message info.
2192: FND_MSG_PUB.Count_And_Get(
2193: p_encoded => FND_API.G_FALSE,
2194: p_count => x_msg_count,
2195: p_data => x_msg_data);
2196:

Line 2218: FND_MSG_PUB.Count_And_Get(

2214: EXCEPTION
2215: WHEN FND_API.G_EXC_ERROR THEN
2216: ROLLBACK TO update_party_site;
2217: x_return_status := FND_API.G_RET_STS_ERROR;
2218: FND_MSG_PUB.Count_And_Get(
2219: p_encoded => FND_API.G_FALSE,
2220: p_count => x_msg_count,
2221: p_data => x_msg_data);
2222:

Line 2243: FND_MSG_PUB.Count_And_Get(

2239:
2240: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2241: ROLLBACK TO update_party_site;
2242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2243: FND_MSG_PUB.Count_And_Get(
2244: p_encoded => FND_API.G_FALSE,
2245: p_count => x_msg_count,
2246: p_data => x_msg_data);
2247:

Line 2269: FND_MSG_PUB.ADD;

2265: ROLLBACK TO update_party_site;
2266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2267: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2268: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2269: FND_MSG_PUB.ADD;
2270: FND_MSG_PUB.Count_And_Get(
2271: p_encoded => FND_API.G_FALSE,
2272: p_count => x_msg_count,
2273: p_data => x_msg_data);

Line 2270: FND_MSG_PUB.Count_And_Get(

2266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2267: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2268: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2269: FND_MSG_PUB.ADD;
2270: FND_MSG_PUB.Count_And_Get(
2271: p_encoded => FND_API.G_FALSE,
2272: p_count => x_msg_count,
2273: p_data => x_msg_data);
2274:

Line 2355: FND_MSG_PUB.initialize;

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

Line 2384: FND_MSG_PUB.Count_And_Get(

2380: END IF;
2381: END IF;
2382:
2383: -- standard call to get message count and if count is 1, get message info.
2384: FND_MSG_PUB.Count_And_Get(
2385: p_encoded => FND_API.G_FALSE,
2386: p_count => x_msg_count,
2387: p_data => x_msg_data);
2388:

Line 2409: FND_MSG_PUB.Count_And_Get(

2405: EXCEPTION
2406: WHEN FND_API.G_EXC_ERROR THEN
2407: ROLLBACK TO create_party_site_use;
2408: x_return_status := FND_API.G_RET_STS_ERROR;
2409: FND_MSG_PUB.Count_And_Get(
2410: p_encoded => FND_API.G_FALSE,
2411: p_count => x_msg_count,
2412: p_data => x_msg_data);
2413:

Line 2433: FND_MSG_PUB.Count_And_Get(

2429:
2430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2431: ROLLBACK TO create_party_site_use;
2432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2433: FND_MSG_PUB.Count_And_Get(
2434: p_encoded => FND_API.G_FALSE,
2435: p_count => x_msg_count,
2436: p_data => x_msg_data);
2437:

Line 2459: FND_MSG_PUB.ADD;

2455: ROLLBACK TO create_party_site_use;
2456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2457: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2458: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2459: FND_MSG_PUB.ADD;
2460: FND_MSG_PUB.Count_And_Get(
2461: p_encoded => FND_API.G_FALSE,
2462: p_count => x_msg_count,
2463: p_data => x_msg_data);

Line 2460: FND_MSG_PUB.Count_And_Get(

2456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2457: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2458: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2459: FND_MSG_PUB.ADD;
2460: FND_MSG_PUB.Count_And_Get(
2461: p_encoded => FND_API.G_FALSE,
2462: p_count => x_msg_count,
2463: p_data => x_msg_data);
2464:

Line 2543: FND_MSG_PUB.initialize;

2539: END IF;
2540:
2541: -- initialize message list if p_init_msg_list is set to TRUE.
2542: IF FND_API.to_Boolean(p_init_msg_list) THEN
2543: FND_MSG_PUB.initialize;
2544: END IF;
2545:
2546: -- initialize API return status to success.
2547: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2586: FND_MSG_PUB.Count_And_Get(

2582: END IF;
2583: END IF;
2584:
2585: -- standard call to get message count and if count is 1, get message info.
2586: FND_MSG_PUB.Count_And_Get(
2587: p_encoded => FND_API.G_FALSE,
2588: p_count => x_msg_count,
2589: p_data => x_msg_data);
2590:

Line 2611: FND_MSG_PUB.Count_And_Get(

2607: EXCEPTION
2608: WHEN FND_API.G_EXC_ERROR THEN
2609: ROLLBACK TO update_party_site_use;
2610: x_return_status := FND_API.G_RET_STS_ERROR;
2611: FND_MSG_PUB.Count_And_Get(
2612: p_encoded => FND_API.G_FALSE,
2613: p_count => x_msg_count,
2614: p_data => x_msg_data);
2615:

Line 2635: FND_MSG_PUB.Count_And_Get(

2631:
2632: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2633: ROLLBACK TO update_party_site_use;
2634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2635: FND_MSG_PUB.Count_And_Get(
2636: p_encoded => FND_API.G_FALSE,
2637: p_count => x_msg_count,
2638: p_data => x_msg_data);
2639:

Line 2661: FND_MSG_PUB.ADD;

2657: ROLLBACK TO update_party_site_use;
2658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2659: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2660: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2661: FND_MSG_PUB.ADD;
2662: FND_MSG_PUB.Count_And_Get(
2663: p_encoded => FND_API.G_FALSE,
2664: p_count => x_msg_count,
2665: p_data => x_msg_data);

Line 2662: FND_MSG_PUB.Count_And_Get(

2658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2659: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2660: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2661: FND_MSG_PUB.ADD;
2662: FND_MSG_PUB.Count_And_Get(
2663: p_encoded => FND_API.G_FALSE,
2664: p_count => x_msg_count,
2665: p_data => x_msg_data);
2666:

Line 2733: FND_MSG_PUB.initialize;

2729: BEGIN
2730:
2731: --Initialize message list if p_init_msg_list is set to TRUE.
2732: IF FND_API.to_Boolean(p_init_msg_list) THEN
2733: FND_MSG_PUB.initialize;
2734: END IF;
2735:
2736: --Initialize API return status to success.
2737: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2744: FND_MSG_PUB.ADD;

2740: IF p_party_site_id IS NULL OR
2741: p_party_site_id = FND_API.G_MISS_NUM THEN
2742: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2743: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'party_site_id' );
2744: FND_MSG_PUB.ADD;
2745: RAISE FND_API.G_EXC_ERROR;
2746: END IF;
2747:
2748: x_party_site_rec.party_site_id := p_party_site_id;

Line 2791: FND_MSG_PUB.Count_And_Get(

2787: X_DUNS_NUMBER_C => x_party_site_rec.duns_number_c
2788: );
2789:
2790: --Standard call to get message count and if count is 1, get message info.
2791: FND_MSG_PUB.Count_And_Get(
2792: p_encoded => FND_API.G_FALSE,
2793: p_count => x_msg_count,
2794: p_data => x_msg_data );
2795:

Line 2800: FND_MSG_PUB.Count_And_Get(

2796: EXCEPTION
2797: WHEN FND_API.G_EXC_ERROR THEN
2798: x_return_status := FND_API.G_RET_STS_ERROR;
2799:
2800: FND_MSG_PUB.Count_And_Get(
2801: p_encoded => FND_API.G_FALSE,
2802: p_count => x_msg_count,
2803: p_data => x_msg_data );
2804:

Line 2808: FND_MSG_PUB.Count_And_Get(

2804:
2805: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2807:
2808: FND_MSG_PUB.Count_And_Get(
2809: p_encoded => FND_API.G_FALSE,
2810: p_count => x_msg_count,
2811: p_data => x_msg_data );
2812:

Line 2817: FND_MSG_PUB.ADD;

2813: WHEN OTHERS THEN
2814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2815: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2816: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2817: FND_MSG_PUB.ADD;
2818: FND_MSG_PUB.Count_And_Get(
2819: p_encoded => FND_API.G_FALSE,
2820: p_count => x_msg_count,
2821: p_data => x_msg_data );

Line 2818: FND_MSG_PUB.Count_And_Get(

2814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2815: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2816: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2817: FND_MSG_PUB.ADD;
2818: FND_MSG_PUB.Count_And_Get(
2819: p_encoded => FND_API.G_FALSE,
2820: p_count => x_msg_count,
2821: p_data => x_msg_data );
2822:

Line 2871: FND_MSG_PUB.initialize;

2867: BEGIN
2868:
2869: --Initialize message list if p_init_msg_list is set to TRUE.
2870: IF FND_API.to_Boolean(p_init_msg_list) THEN
2871: FND_MSG_PUB.initialize;
2872: END IF;
2873:
2874: --Initialize API return status to success.
2875: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2882: FND_MSG_PUB.ADD;

2878: IF p_party_site_use_id IS NULL OR
2879: p_party_site_use_id = FND_API.G_MISS_NUM THEN
2880: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2881: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'p_party_site_use_id' );
2882: FND_MSG_PUB.ADD;
2883: RAISE FND_API.G_EXC_ERROR;
2884: END IF;
2885:
2886: x_party_site_use_rec.party_site_use_id := p_party_site_use_id;

Line 2900: FND_MSG_PUB.Count_And_Get(

2896: X_APPLICATION_ID => x_party_site_use_rec.application_id
2897: );
2898:
2899: --Standard call to get message count and if count is 1, get message info.
2900: FND_MSG_PUB.Count_And_Get(
2901: p_encoded => FND_API.G_FALSE,
2902: p_count => x_msg_count,
2903: p_data => x_msg_data );
2904:

Line 2909: FND_MSG_PUB.Count_And_Get(

2905: EXCEPTION
2906: WHEN FND_API.G_EXC_ERROR THEN
2907: x_return_status := FND_API.G_RET_STS_ERROR;
2908:
2909: FND_MSG_PUB.Count_And_Get(
2910: p_encoded => FND_API.G_FALSE,
2911: p_count => x_msg_count,
2912: p_data => x_msg_data );
2913:

Line 2917: FND_MSG_PUB.Count_And_Get(

2913:
2914: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2915: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2916:
2917: FND_MSG_PUB.Count_And_Get(
2918: p_encoded => FND_API.G_FALSE,
2919: p_count => x_msg_count,
2920: p_data => x_msg_data );
2921:

Line 2926: FND_MSG_PUB.ADD;

2922: WHEN OTHERS THEN
2923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2924: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2925: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2926: FND_MSG_PUB.ADD;
2927: FND_MSG_PUB.Count_And_Get(
2928: p_encoded => FND_API.G_FALSE,
2929: p_count => x_msg_count,
2930: p_data => x_msg_data );

Line 2927: FND_MSG_PUB.Count_And_Get(

2923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2924: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2925: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2926: FND_MSG_PUB.ADD;
2927: FND_MSG_PUB.Count_And_Get(
2928: p_encoded => FND_API.G_FALSE,
2929: p_count => x_msg_count,
2930: p_data => x_msg_data );
2931:

Line 3005: FND_MSG_PUB.ADD;

3001: x_return_status := FND_API.G_RET_STS_ERROR;
3002: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
3003: FND_MESSAGE.SET_TOKEN('RECORD', 'Account sites');
3004: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_id), 'null'));
3005: FND_MSG_PUB.ADD;
3006: RAISE FND_API.G_EXC_ERROR;
3007: END;
3008:
3009: -- Debug info.

Line 3112: FND_MSG_PUB.ADD;

3108: x_return_status := FND_API.G_RET_STS_ERROR;
3109: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
3110: FND_MESSAGE.SET_TOKEN('RECORD', 'party site use');
3111: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_id), 'null'));
3112: FND_MSG_PUB.ADD;
3113: RAISE FND_API.G_EXC_ERROR;
3114: END;
3115:
3116: -- Debug info.

Line 3325: FND_MSG_PUB.ADD;

3321: EXCEPTION WHEN NO_DATA_FOUND THEN
3322: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
3323: FND_MESSAGE.SET_TOKEN('RECORD', 'Party site use');
3324: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_id), 'null'));
3325: FND_MSG_PUB.ADD;
3326: RAISE FND_API.G_EXC_ERROR;
3327: END;
3328:
3329: -- Debug info.

Line 3420: -- FND_MSG_PUB.Count_And_Get(

3416: EXCEPTION
3417: WHEN FND_API.G_EXC_ERROR THEN
3418: x_return_status := FND_API.G_RET_STS_ERROR;
3419:
3420: -- FND_MSG_PUB.Count_And_Get(
3421: -- p_encoded => FND_API.G_FALSE,
3422: -- p_count => x_msg_count,
3423: -- p_data => x_msg_data );
3424:

Line 3428: -- FND_MSG_PUB.Count_And_Get(

3424:
3425: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3427:
3428: -- FND_MSG_PUB.Count_And_Get(
3429: -- p_encoded => FND_API.G_FALSE,
3430: -- p_count => x_msg_count,
3431: -- p_data => x_msg_data );
3432:

Line 3437: -- FND_MSG_PUB.ADD;

3433: WHEN OTHERS THEN
3434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3435: -- FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3436: -- FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3437: -- FND_MSG_PUB.ADD;
3438: -- FND_MSG_PUB.Count_And_Get(
3439: -- p_encoded => FND_API.G_FALSE,
3440: -- p_count => x_msg_count,
3441: -- p_data => x_msg_data );

Line 3438: -- FND_MSG_PUB.Count_And_Get(

3434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3435: -- FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3436: -- FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3437: -- FND_MSG_PUB.ADD;
3438: -- FND_MSG_PUB.Count_And_Get(
3439: -- p_encoded => FND_API.G_FALSE,
3440: -- p_count => x_msg_count,
3441: -- p_data => x_msg_data );
3442:

Line 3478: FND_MSG_PUB.ADD;

3474: p_party_site_rec.language <> p_old_party_site_rec.language)
3475: THEN
3476: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
3477: FND_MESSAGE.SET_TOKEN('COLUMN', 'language');
3478: FND_MSG_PUB.ADD;
3479: x_return_status := FND_API.G_RET_STS_ERROR;
3480: END IF;
3481:
3482: END check_obsolete_columns;