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 701: FND_MSG_PUB.ADD;

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

Line 711: FND_MSG_PUB.ADD;

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

Line 944: FND_MSG_PUB.ADD;

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

Line 1039: FND_MSG_PUB.ADD;

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

Line 1223: FND_MSG_PUB.ADD;

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

Line 1233: FND_MSG_PUB.ADD;

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

Line 1320: FND_MSG_PUB.ADD;

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

Line 1431: FND_MSG_PUB.ADD;

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

Line 1553: FND_MSG_PUB.ADD;

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

Line 1649: FND_MSG_PUB.ADD;

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

Line 1751: FND_MSG_PUB.initialize;

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

Line 1820: FND_MSG_PUB.ADD;

1816: --
1817: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_INSERT_PRIVILEGE');
1818: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
1819: fnd_message.get_string('AR', 'HZ_DSS_PARTY_ADDRESSES'));
1820: FND_MSG_PUB.ADD;
1821: RAISE FND_API.G_EXC_ERROR;
1822: end if;
1823: END IF;
1824:

Line 1859: FND_MSG_PUB.Count_And_Get(

1855: */
1856: END IF;
1857:
1858: -- standard call to get message count and if count is 1, get message info.
1859: FND_MSG_PUB.Count_And_Get(
1860: p_encoded => FND_API.G_FALSE,
1861: p_count => x_msg_count,
1862: p_data => x_msg_data);
1863:

Line 1884: FND_MSG_PUB.Count_And_Get(

1880: EXCEPTION
1881: WHEN FND_API.G_EXC_ERROR THEN
1882: ROLLBACK TO create_party_site;
1883: x_return_status := FND_API.G_RET_STS_ERROR;
1884: FND_MSG_PUB.Count_And_Get(
1885: p_encoded => FND_API.G_FALSE,
1886: p_count => x_msg_count,
1887: p_data => x_msg_data);
1888:

Line 1908: FND_MSG_PUB.Count_And_Get(

1904:
1905: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1906: ROLLBACK TO create_party_site;
1907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1908: FND_MSG_PUB.Count_And_Get(
1909: p_encoded => FND_API.G_FALSE,
1910: p_count => x_msg_count,
1911: p_data => x_msg_data);
1912:

Line 1934: FND_MSG_PUB.ADD;

1930: ROLLBACK TO create_party_site;
1931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1932: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1933: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1934: FND_MSG_PUB.ADD;
1935: FND_MSG_PUB.Count_And_Get(
1936: p_encoded => FND_API.G_FALSE,
1937: p_count => x_msg_count,
1938: p_data => x_msg_data);

Line 1935: FND_MSG_PUB.Count_And_Get(

1931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1932: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1933: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1934: FND_MSG_PUB.ADD;
1935: FND_MSG_PUB.Count_And_Get(
1936: p_encoded => FND_API.G_FALSE,
1937: p_count => x_msg_count,
1938: p_data => x_msg_data);
1939:

Line 2027: FND_MSG_PUB.initialize;

2023: END IF;
2024:
2025: -- initialize message list if p_init_msg_list is set to TRUE.
2026: IF FND_API.to_Boolean(p_init_msg_list) THEN
2027: FND_MSG_PUB.initialize;
2028: END IF;
2029:
2030: -- initialize API return status to success.
2031: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2092: FND_MSG_PUB.ADD;

2088: --
2089: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
2090: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
2091: fnd_message.get_string('AR', 'HZ_DSS_PARTY_ADDRESSES'));
2092: FND_MSG_PUB.ADD;
2093: RAISE FND_API.G_EXC_ERROR;
2094: end if;
2095: END IF;
2096:

Line 2181: FND_MSG_PUB.ADD;

2177: WHEN NO_DATA_FOUND THEN
2178: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
2179: FND_MESSAGE.SET_TOKEN('RECORD', 'Message Name');
2180: --FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_use_rec.party_site_id), 'null'));
2181: FND_MSG_PUB.ADD;
2182: RAISE FND_API.G_EXC_ERROR;
2183: END;
2184: END IF;
2185: --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 2199: FND_MSG_PUB.Count_And_Get(

2195: END IF;
2196: END IF;
2197:
2198: -- standard call to get message count and if count is 1, get message info.
2199: FND_MSG_PUB.Count_And_Get(
2200: p_encoded => FND_API.G_FALSE,
2201: p_count => x_msg_count,
2202: p_data => x_msg_data);
2203:

Line 2225: FND_MSG_PUB.Count_And_Get(

2221: EXCEPTION
2222: WHEN FND_API.G_EXC_ERROR THEN
2223: ROLLBACK TO update_party_site;
2224: x_return_status := FND_API.G_RET_STS_ERROR;
2225: FND_MSG_PUB.Count_And_Get(
2226: p_encoded => FND_API.G_FALSE,
2227: p_count => x_msg_count,
2228: p_data => x_msg_data);
2229:

Line 2250: FND_MSG_PUB.Count_And_Get(

2246:
2247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2248: ROLLBACK TO update_party_site;
2249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2250: FND_MSG_PUB.Count_And_Get(
2251: p_encoded => FND_API.G_FALSE,
2252: p_count => x_msg_count,
2253: p_data => x_msg_data);
2254:

Line 2276: FND_MSG_PUB.ADD;

2272: ROLLBACK TO update_party_site;
2273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2274: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2275: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2276: FND_MSG_PUB.ADD;
2277: FND_MSG_PUB.Count_And_Get(
2278: p_encoded => FND_API.G_FALSE,
2279: p_count => x_msg_count,
2280: p_data => x_msg_data);

Line 2277: FND_MSG_PUB.Count_And_Get(

2273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2274: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2275: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2276: FND_MSG_PUB.ADD;
2277: FND_MSG_PUB.Count_And_Get(
2278: p_encoded => FND_API.G_FALSE,
2279: p_count => x_msg_count,
2280: p_data => x_msg_data);
2281:

Line 2362: FND_MSG_PUB.initialize;

2358:
2359:
2360: -- initialize message list if p_init_msg_list is set to TRUE.
2361: IF FND_API.to_Boolean(p_init_msg_list) THEN
2362: FND_MSG_PUB.initialize;
2363: END IF;
2364:
2365: -- initialize API return status to success.
2366: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2391: FND_MSG_PUB.Count_And_Get(

2387: END IF;
2388: END IF;
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 2416: FND_MSG_PUB.Count_And_Get(

2412: EXCEPTION
2413: WHEN FND_API.G_EXC_ERROR THEN
2414: ROLLBACK TO create_party_site_use;
2415: x_return_status := FND_API.G_RET_STS_ERROR;
2416: FND_MSG_PUB.Count_And_Get(
2417: p_encoded => FND_API.G_FALSE,
2418: p_count => x_msg_count,
2419: p_data => x_msg_data);
2420:

Line 2440: FND_MSG_PUB.Count_And_Get(

2436:
2437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2438: ROLLBACK TO create_party_site_use;
2439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2440: FND_MSG_PUB.Count_And_Get(
2441: p_encoded => FND_API.G_FALSE,
2442: p_count => x_msg_count,
2443: p_data => x_msg_data);
2444:

Line 2466: FND_MSG_PUB.ADD;

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

Line 2467: FND_MSG_PUB.Count_And_Get(

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

Line 2550: FND_MSG_PUB.initialize;

2546: END IF;
2547:
2548: -- initialize message list if p_init_msg_list is set to TRUE.
2549: IF FND_API.to_Boolean(p_init_msg_list) THEN
2550: FND_MSG_PUB.initialize;
2551: END IF;
2552:
2553: -- initialize API return status to success.
2554: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2593: FND_MSG_PUB.Count_And_Get(

2589: END IF;
2590: END IF;
2591:
2592: -- standard call to get message count and if count is 1, get message info.
2593: FND_MSG_PUB.Count_And_Get(
2594: p_encoded => FND_API.G_FALSE,
2595: p_count => x_msg_count,
2596: p_data => x_msg_data);
2597:

Line 2618: FND_MSG_PUB.Count_And_Get(

2614: EXCEPTION
2615: WHEN FND_API.G_EXC_ERROR THEN
2616: ROLLBACK TO update_party_site_use;
2617: x_return_status := FND_API.G_RET_STS_ERROR;
2618: FND_MSG_PUB.Count_And_Get(
2619: p_encoded => FND_API.G_FALSE,
2620: p_count => x_msg_count,
2621: p_data => x_msg_data);
2622:

Line 2642: FND_MSG_PUB.Count_And_Get(

2638:
2639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2640: ROLLBACK TO update_party_site_use;
2641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2642: FND_MSG_PUB.Count_And_Get(
2643: p_encoded => FND_API.G_FALSE,
2644: p_count => x_msg_count,
2645: p_data => x_msg_data);
2646:

Line 2668: FND_MSG_PUB.ADD;

2664: ROLLBACK TO update_party_site_use;
2665: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2666: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2667: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2668: FND_MSG_PUB.ADD;
2669: FND_MSG_PUB.Count_And_Get(
2670: p_encoded => FND_API.G_FALSE,
2671: p_count => x_msg_count,
2672: p_data => x_msg_data);

Line 2669: FND_MSG_PUB.Count_And_Get(

2665: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2666: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2667: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2668: FND_MSG_PUB.ADD;
2669: FND_MSG_PUB.Count_And_Get(
2670: p_encoded => FND_API.G_FALSE,
2671: p_count => x_msg_count,
2672: p_data => x_msg_data);
2673:

Line 2740: FND_MSG_PUB.initialize;

2736: BEGIN
2737:
2738: --Initialize message list if p_init_msg_list is set to TRUE.
2739: IF FND_API.to_Boolean(p_init_msg_list) THEN
2740: FND_MSG_PUB.initialize;
2741: END IF;
2742:
2743: --Initialize API return status to success.
2744: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2751: FND_MSG_PUB.ADD;

2747: IF p_party_site_id IS NULL OR
2748: p_party_site_id = FND_API.G_MISS_NUM THEN
2749: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2750: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'party_site_id' );
2751: FND_MSG_PUB.ADD;
2752: RAISE FND_API.G_EXC_ERROR;
2753: END IF;
2754:
2755: x_party_site_rec.party_site_id := p_party_site_id;

Line 2798: FND_MSG_PUB.Count_And_Get(

2794: X_DUNS_NUMBER_C => x_party_site_rec.duns_number_c
2795: );
2796:
2797: --Standard call to get message count and if count is 1, get message info.
2798: FND_MSG_PUB.Count_And_Get(
2799: p_encoded => FND_API.G_FALSE,
2800: p_count => x_msg_count,
2801: p_data => x_msg_data );
2802:

Line 2807: FND_MSG_PUB.Count_And_Get(

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

Line 2815: FND_MSG_PUB.Count_And_Get(

2811:
2812: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2814:
2815: FND_MSG_PUB.Count_And_Get(
2816: p_encoded => FND_API.G_FALSE,
2817: p_count => x_msg_count,
2818: p_data => x_msg_data );
2819:

Line 2824: FND_MSG_PUB.ADD;

2820: WHEN OTHERS THEN
2821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2822: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2823: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2824: FND_MSG_PUB.ADD;
2825: FND_MSG_PUB.Count_And_Get(
2826: p_encoded => FND_API.G_FALSE,
2827: p_count => x_msg_count,
2828: p_data => x_msg_data );

Line 2825: FND_MSG_PUB.Count_And_Get(

2821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2822: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2823: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2824: FND_MSG_PUB.ADD;
2825: FND_MSG_PUB.Count_And_Get(
2826: p_encoded => FND_API.G_FALSE,
2827: p_count => x_msg_count,
2828: p_data => x_msg_data );
2829:

Line 2878: FND_MSG_PUB.initialize;

2874: BEGIN
2875:
2876: --Initialize message list if p_init_msg_list is set to TRUE.
2877: IF FND_API.to_Boolean(p_init_msg_list) THEN
2878: FND_MSG_PUB.initialize;
2879: END IF;
2880:
2881: --Initialize API return status to success.
2882: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2889: FND_MSG_PUB.ADD;

2885: IF p_party_site_use_id IS NULL OR
2886: p_party_site_use_id = FND_API.G_MISS_NUM THEN
2887: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2888: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'p_party_site_use_id' );
2889: FND_MSG_PUB.ADD;
2890: RAISE FND_API.G_EXC_ERROR;
2891: END IF;
2892:
2893: x_party_site_use_rec.party_site_use_id := p_party_site_use_id;

Line 2907: FND_MSG_PUB.Count_And_Get(

2903: X_APPLICATION_ID => x_party_site_use_rec.application_id
2904: );
2905:
2906: --Standard call to get message count and if count is 1, get message info.
2907: FND_MSG_PUB.Count_And_Get(
2908: p_encoded => FND_API.G_FALSE,
2909: p_count => x_msg_count,
2910: p_data => x_msg_data );
2911:

Line 2916: FND_MSG_PUB.Count_And_Get(

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

Line 2924: FND_MSG_PUB.Count_And_Get(

2920:
2921: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2922: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2923:
2924: FND_MSG_PUB.Count_And_Get(
2925: p_encoded => FND_API.G_FALSE,
2926: p_count => x_msg_count,
2927: p_data => x_msg_data );
2928:

Line 2933: FND_MSG_PUB.ADD;

2929: WHEN OTHERS THEN
2930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2931: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2932: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2933: FND_MSG_PUB.ADD;
2934: FND_MSG_PUB.Count_And_Get(
2935: p_encoded => FND_API.G_FALSE,
2936: p_count => x_msg_count,
2937: p_data => x_msg_data );

Line 2934: FND_MSG_PUB.Count_And_Get(

2930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2931: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2932: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2933: FND_MSG_PUB.ADD;
2934: FND_MSG_PUB.Count_And_Get(
2935: p_encoded => FND_API.G_FALSE,
2936: p_count => x_msg_count,
2937: p_data => x_msg_data );
2938:

Line 3012: FND_MSG_PUB.ADD;

3008: x_return_status := FND_API.G_RET_STS_ERROR;
3009: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
3010: FND_MESSAGE.SET_TOKEN('RECORD', 'Account sites');
3011: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_id), 'null'));
3012: FND_MSG_PUB.ADD;
3013: RAISE FND_API.G_EXC_ERROR;
3014: END;
3015:
3016: -- Debug info.

Line 3119: FND_MSG_PUB.ADD;

3115: x_return_status := FND_API.G_RET_STS_ERROR;
3116: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
3117: FND_MESSAGE.SET_TOKEN('RECORD', 'party site use');
3118: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_id), 'null'));
3119: FND_MSG_PUB.ADD;
3120: RAISE FND_API.G_EXC_ERROR;
3121: END;
3122:
3123: -- Debug info.

Line 3332: FND_MSG_PUB.ADD;

3328: EXCEPTION WHEN NO_DATA_FOUND THEN
3329: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
3330: FND_MESSAGE.SET_TOKEN('RECORD', 'Party site use');
3331: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_party_site_id), 'null'));
3332: FND_MSG_PUB.ADD;
3333: RAISE FND_API.G_EXC_ERROR;
3334: END;
3335:
3336: -- Debug info.

Line 3427: -- FND_MSG_PUB.Count_And_Get(

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

Line 3435: -- FND_MSG_PUB.Count_And_Get(

3431:
3432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3434:
3435: -- FND_MSG_PUB.Count_And_Get(
3436: -- p_encoded => FND_API.G_FALSE,
3437: -- p_count => x_msg_count,
3438: -- p_data => x_msg_data );
3439:

Line 3444: -- FND_MSG_PUB.ADD;

3440: WHEN OTHERS THEN
3441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3442: -- FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3443: -- FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3444: -- FND_MSG_PUB.ADD;
3445: -- FND_MSG_PUB.Count_And_Get(
3446: -- p_encoded => FND_API.G_FALSE,
3447: -- p_count => x_msg_count,
3448: -- p_data => x_msg_data );

Line 3445: -- FND_MSG_PUB.Count_And_Get(

3441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3442: -- FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3443: -- FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3444: -- FND_MSG_PUB.ADD;
3445: -- FND_MSG_PUB.Count_And_Get(
3446: -- p_encoded => FND_API.G_FALSE,
3447: -- p_count => x_msg_count,
3448: -- p_data => x_msg_data );
3449:

Line 3485: FND_MSG_PUB.ADD;

3481: p_party_site_rec.language <> p_old_party_site_rec.language)
3482: THEN
3483: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
3484: FND_MESSAGE.SET_TOKEN('COLUMN', 'language');
3485: FND_MSG_PUB.ADD;
3486: x_return_status := FND_API.G_RET_STS_ERROR;
3487: END IF;
3488:
3489: END check_obsolete_columns;