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

Line 255: FND_MSG_PUB.ADD;

251: WHEN NO_DATA_FOUND THEN
252: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
253: FND_MESSAGE.SET_TOKEN('RECORD', 'Release Name');
254: FND_MESSAGE.SET_TOKEN('VALUE', 'HZ_INACTIVATE_ACCOUNT_SITE_UI');
255: FND_MSG_PUB.ADD;
256: RAISE FND_API.G_EXC_ERROR;
257: END;
258: END IF;
259: IF g_message_name IS NOT NULL THEN

Line 275: FND_MSG_PUB.ADD;

271: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
272: FND_MESSAGE.SET_TOKEN( 'RECORD', 'party site' );
273: FND_MESSAGE.SET_TOKEN( 'VALUE',
274: NVL( TO_CHAR( p_cust_acct_site_rec.party_site_id ), 'null' ) );
275: FND_MSG_PUB.ADD;
276: RAISE FND_API.G_EXC_ERROR;
277: END;
278:
279: /*IF p_cust_acct_site_rec.status is NULL OR p_cust_acct_site_rec.status <> l_status THEN --Bug 3370870 */

Line 282: FND_MSG_PUB.ADD;

278:
279: /*IF p_cust_acct_site_rec.status is NULL OR p_cust_acct_site_rec.status <> l_status THEN --Bug 3370870 */
280: IF NVL(p_cust_acct_site_rec.status,'A') <> l_status THEN -- Bug 3805019
281: FND_MESSAGE.SET_NAME( 'AR', 'HZ_ACCT_SITE_INHERIT_STATUS' );
282: FND_MSG_PUB.ADD;
283: p_cust_acct_site_rec.status := l_status;
284: END IF;
285: END IF;
286: --end of party site account site status synch

Line 684: FND_MSG_PUB.ADD;

680: p_object_version_number = l_object_version_number ) )
681: THEN
682: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
683: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_acct_sites' );
684: FND_MSG_PUB.ADD;
685: RAISE FND_API.G_EXC_ERROR;
686: END IF;
687:
688: p_object_version_number := NVL( l_object_version_number, 1 ) + 1;

Line 696: FND_MSG_PUB.ADD;

692: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
693: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer account site' );
694: FND_MESSAGE.SET_TOKEN( 'VALUE',
695: NVL( TO_CHAR( p_cust_acct_site_rec.cust_acct_site_id ), 'null' ) );
696: FND_MSG_PUB.ADD;
697: RAISE FND_API.G_EXC_ERROR;
698: END;
699:
700:

Line 741: FND_MSG_PUB.ADD;

737: WHEN NO_DATA_FOUND THEN
738: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
739: FND_MESSAGE.SET_TOKEN('RECORD', 'Message Name');
740: FND_MESSAGE.SET_TOKEN('VALUE', 'HZ_INACTIVATE_ACCOUNT_SITE_UI');
741: FND_MSG_PUB.ADD;
742: RAISE FND_API.G_EXC_ERROR;
743: END;
744: END IF;
745: IF g_message_name IS NOT NULL THEN

Line 761: FND_MSG_PUB.ADD;

757: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
758: FND_MESSAGE.SET_TOKEN( 'RECORD', 'party site' );
759: FND_MESSAGE.SET_TOKEN( 'VALUE',
760: NVL( TO_CHAR( p_cust_acct_site_rec.party_site_id ), 'null' ) );
761: FND_MSG_PUB.ADD;
762: RAISE FND_API.G_EXC_ERROR;
763: END;
764: l_party_site_rec.party_site_id := l_party_site_id;
765: l_party_site_rec.status := p_cust_acct_site_rec.status;

Line 994: FND_MSG_PUB.ADD;

990: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer account site' );
991: FND_MESSAGE.SET_TOKEN( 'VALUE',
992: NVL( TO_CHAR(
993: p_cust_site_use_rec.cust_acct_site_id ), 'null' ) );
994: FND_MSG_PUB.ADD;
995: RAISE FND_API.G_EXC_ERROR;
996: END;
997: END IF;
998:

Line 1021: l_message_count := FND_MSG_PUB.Count_Msg();

1017: END IF;
1018:
1019: -- Create party site use of same type if one does not exist.
1020:
1021: l_message_count := FND_MSG_PUB.Count_Msg();
1022:
1023: HZ_UTILITY_V2PUB.validate_lookup (
1024: p_column => 'site_use_code',
1025: p_lookup_type => 'PARTY_SITE_USE_CODE',

Line 1039: FND_MSG_PUB.DELETE_MSG( l_message_count + 1 );

1035: END IF;
1036:
1037: -- site_use_code is not in a valid site_use_code in party level.
1038: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1039: FND_MSG_PUB.DELETE_MSG( l_message_count + 1 );
1040: x_return_status := FND_API.G_RET_STS_SUCCESS;
1041: ELSE
1042: -- Create party site use
1043: SELECT PARTY_SITE_ID INTO l_party_site_id

Line 1464: FND_MSG_PUB.ADD;

1460: p_object_version_number = l_object_version_number ) )
1461: THEN
1462: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
1463: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_site_uses' );
1464: FND_MSG_PUB.ADD;
1465: RAISE FND_API.G_EXC_ERROR;
1466: END IF;
1467:
1468: p_object_version_number := NVL( l_object_version_number, 1 ) + 1;

Line 1476: FND_MSG_PUB.ADD;

1472: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
1473: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer site use' );
1474: FND_MESSAGE.SET_TOKEN( 'VALUE',
1475: NVL( TO_CHAR( p_cust_site_use_rec.site_use_id ), 'null' ) );
1476: FND_MSG_PUB.ADD;
1477: RAISE FND_API.G_EXC_ERROR;
1478: END;
1479:
1480: -- Validate cust site use record

Line 1494: l_message_count := FND_MSG_PUB.Count_Msg();

1490:
1491: ---Create party site use of same type if one does not exist.
1492: --Bug No. 5036975
1493: IF p_cust_site_use_rec.status = 'A' THEN
1494: l_message_count := FND_MSG_PUB.Count_Msg();
1495: HZ_UTILITY_V2PUB.validate_lookup (
1496: p_column => 'site_use_code',
1497: p_lookup_type => 'PARTY_SITE_USE_CODE',
1498: p_column_value => p_cust_site_use_rec.site_use_code,

Line 1511: FND_MSG_PUB.DELETE_MSG( l_message_count + 1 );

1507: END IF;
1508:
1509: -- site_use_code is not in a valid site_use_code in party level.
1510: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1511: FND_MSG_PUB.DELETE_MSG( l_message_count + 1 );
1512: x_return_status := FND_API.G_RET_STS_SUCCESS;
1513: ELSE
1514: -- Create party site use
1515:

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 2068: FND_MSG_PUB.Count_And_Get(

2064: END IF;
2065: END IF;
2066:
2067: -- Standard call to get message count and if count is 1, get message info.
2068: FND_MSG_PUB.Count_And_Get(
2069: p_encoded => FND_API.G_FALSE,
2070: p_count => x_msg_count,
2071: p_data => x_msg_data );
2072:

Line 2094: FND_MSG_PUB.Count_And_Get(

2090: WHEN FND_API.G_EXC_ERROR THEN
2091: ROLLBACK TO create_cust_acct_site;
2092: x_return_status := FND_API.G_RET_STS_ERROR;
2093:
2094: FND_MSG_PUB.Count_And_Get(
2095: p_encoded => FND_API.G_FALSE,
2096: p_count => x_msg_count,
2097: p_data => x_msg_data );
2098:

Line 2119: FND_MSG_PUB.Count_And_Get(

2115: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2116: ROLLBACK TO create_cust_acct_site;
2117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2118:
2119: FND_MSG_PUB.Count_And_Get(
2120: p_encoded => FND_API.G_FALSE,
2121: p_count => x_msg_count,
2122: p_data => x_msg_data );
2123:

Line 2146: FND_MSG_PUB.ADD;

2142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2143:
2144: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2145: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2146: FND_MSG_PUB.ADD;
2147:
2148: FND_MSG_PUB.Count_And_Get(
2149: p_encoded => FND_API.G_FALSE,
2150: p_count => x_msg_count,

Line 2148: FND_MSG_PUB.Count_And_Get(

2144: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2145: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2146: FND_MSG_PUB.ADD;
2147:
2148: FND_MSG_PUB.Count_And_Get(
2149: p_encoded => FND_API.G_FALSE,
2150: p_count => x_msg_count,
2151: p_data => x_msg_data );
2152:

Line 2233: FND_MSG_PUB.initialize;

2229: END IF;
2230:
2231: -- Initialize message list if p_init_msg_list is set to TRUE.
2232: IF FND_API.to_Boolean(p_init_msg_list) THEN
2233: FND_MSG_PUB.initialize;
2234: END IF;
2235:
2236: -- Initialize API return status to success.
2237: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2307: FND_MSG_PUB.Count_And_Get(

2303: END IF;
2304: END IF;
2305:
2306: -- Standard call to get message count and if count is 1, get message info.
2307: FND_MSG_PUB.Count_And_Get(
2308: p_encoded => FND_API.G_FALSE,
2309: p_count => x_msg_count,
2310: p_data => x_msg_data );
2311:

Line 2333: FND_MSG_PUB.Count_And_Get(

2329: WHEN FND_API.G_EXC_ERROR THEN
2330: ROLLBACK TO update_cust_acct_site;
2331: x_return_status := FND_API.G_RET_STS_ERROR;
2332:
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 2358: FND_MSG_PUB.Count_And_Get(

2354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2355: ROLLBACK TO update_cust_acct_site;
2356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2357:
2358: FND_MSG_PUB.Count_And_Get(
2359: p_encoded => FND_API.G_FALSE,
2360: p_count => x_msg_count,
2361: p_data => x_msg_data );
2362:

Line 2385: FND_MSG_PUB.ADD;

2381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2382:
2383: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2384: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2385: FND_MSG_PUB.ADD;
2386:
2387: FND_MSG_PUB.Count_And_Get(
2388: p_encoded => FND_API.G_FALSE,
2389: p_count => x_msg_count,

Line 2387: FND_MSG_PUB.Count_And_Get(

2383: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2384: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2385: FND_MSG_PUB.ADD;
2386:
2387: FND_MSG_PUB.Count_And_Get(
2388: p_encoded => FND_API.G_FALSE,
2389: p_count => x_msg_count,
2390: p_data => x_msg_data );
2391:

Line 2465: FND_MSG_PUB.initialize;

2461: END IF;
2462:
2463: -- Initialize message list if p_init_msg_list is set to TRUE.
2464: IF FND_API.to_Boolean(p_init_msg_list) THEN
2465: FND_MSG_PUB.initialize;
2466: END IF;
2467:
2468: -- Initialize API return status to success.
2469: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2476: FND_MSG_PUB.ADD;

2472: IF p_cust_acct_site_id IS NULL OR
2473: p_cust_acct_site_id = FND_API.G_MISS_NUM THEN
2474: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2475: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_acct_site_id' );
2476: FND_MSG_PUB.ADD;
2477: RAISE FND_API.G_EXC_ERROR;
2478: END IF;
2479:
2480: x_cust_acct_site_rec.cust_acct_site_id := p_cust_acct_site_id;

Line 2561: FND_MSG_PUB.Count_And_Get(

2557: p_msg_level=>fnd_log.level_procedure);
2558: END IF;
2559:
2560: -- Standard call to get message count and if count is 1, get message info.
2561: FND_MSG_PUB.Count_And_Get(
2562: p_encoded => FND_API.G_FALSE,
2563: p_count => x_msg_count,
2564: p_data => x_msg_data );
2565:

Line 2586: FND_MSG_PUB.Count_And_Get(

2582: EXCEPTION
2583: WHEN FND_API.G_EXC_ERROR THEN
2584: x_return_status := FND_API.G_RET_STS_ERROR;
2585:
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 2610: FND_MSG_PUB.Count_And_Get(

2606:
2607: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2609:
2610: FND_MSG_PUB.Count_And_Get(
2611: p_encoded => FND_API.G_FALSE,
2612: p_count => x_msg_count,
2613: p_data => x_msg_data );
2614:

Line 2636: FND_MSG_PUB.ADD;

2632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2633:
2634: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2635: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2636: FND_MSG_PUB.ADD;
2637:
2638: FND_MSG_PUB.Count_And_Get(
2639: p_encoded => FND_API.G_FALSE,
2640: p_count => x_msg_count,

Line 2638: FND_MSG_PUB.Count_And_Get(

2634: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2635: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2636: FND_MSG_PUB.ADD;
2637:
2638: FND_MSG_PUB.Count_And_Get(
2639: p_encoded => FND_API.G_FALSE,
2640: p_count => x_msg_count,
2641: p_data => x_msg_data );
2642:

Line 2734: FND_MSG_PUB.initialize;

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

Line 2767: FND_MSG_PUB.Count_And_Get(

2763: END IF;
2764: END IF;
2765:
2766: -- Standard call to get message count and if count is 1, get message info.
2767: FND_MSG_PUB.Count_And_Get(
2768: p_encoded => FND_API.G_FALSE,
2769: p_count => x_msg_count,
2770: p_data => x_msg_data );
2771:

Line 2792: FND_MSG_PUB.Count_And_Get(

2788: WHEN FND_API.G_EXC_ERROR THEN
2789: ROLLBACK TO create_cust_site_use;
2790: x_return_status := FND_API.G_RET_STS_ERROR;
2791:
2792: FND_MSG_PUB.Count_And_Get(
2793: p_encoded => FND_API.G_FALSE,
2794: p_count => x_msg_count,
2795: p_data => x_msg_data );
2796:

Line 2817: FND_MSG_PUB.Count_And_Get(

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

Line 2844: FND_MSG_PUB.ADD;

2840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2841:
2842: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2843: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2844: FND_MSG_PUB.ADD;
2845:
2846: FND_MSG_PUB.Count_And_Get(
2847: p_encoded => FND_API.G_FALSE,
2848: p_count => x_msg_count,

Line 2846: FND_MSG_PUB.Count_And_Get(

2842: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2843: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2844: FND_MSG_PUB.ADD;
2845:
2846: FND_MSG_PUB.Count_And_Get(
2847: p_encoded => FND_API.G_FALSE,
2848: p_count => x_msg_count,
2849: p_data => x_msg_data );
2850:

Line 2932: FND_MSG_PUB.initialize;

2928: END IF;
2929:
2930: -- Initialize message list if p_init_msg_list is set to TRUE.
2931: IF FND_API.to_Boolean(p_init_msg_list) THEN
2932: FND_MSG_PUB.initialize;
2933: END IF;
2934:
2935: -- Initialize API return status to success.
2936: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2991: FND_MSG_PUB.Count_And_Get(

2987: END IF;
2988: END IF;
2989:
2990: -- Standard call to get message count and if count is 1, get message info.
2991: FND_MSG_PUB.Count_And_Get(
2992: p_encoded => FND_API.G_FALSE,
2993: p_count => x_msg_count,
2994: p_data => x_msg_data );
2995:

Line 3017: FND_MSG_PUB.Count_And_Get(

3013: WHEN FND_API.G_EXC_ERROR THEN
3014: ROLLBACK TO update_cust_site_use;
3015: x_return_status := FND_API.G_RET_STS_ERROR;
3016:
3017: FND_MSG_PUB.Count_And_Get(
3018: p_encoded => FND_API.G_FALSE,
3019: p_count => x_msg_count,
3020: p_data => x_msg_data );
3021:

Line 3042: FND_MSG_PUB.Count_And_Get(

3038: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3039: ROLLBACK TO update_cust_site_use;
3040: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3041:
3042: FND_MSG_PUB.Count_And_Get(
3043: p_encoded => FND_API.G_FALSE,
3044: p_count => x_msg_count,
3045: p_data => x_msg_data );
3046:

Line 3069: FND_MSG_PUB.ADD;

3065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3066:
3067: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3068: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3069: FND_MSG_PUB.ADD;
3070:
3071: FND_MSG_PUB.Count_And_Get(
3072: p_encoded => FND_API.G_FALSE,
3073: p_count => x_msg_count,

Line 3071: FND_MSG_PUB.Count_And_Get(

3067: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3068: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3069: FND_MSG_PUB.ADD;
3070:
3071: FND_MSG_PUB.Count_And_Get(
3072: p_encoded => FND_API.G_FALSE,
3073: p_count => x_msg_count,
3074: p_data => x_msg_data );
3075:

Line 3154: FND_MSG_PUB.initialize;

3150: END IF;
3151:
3152: -- Initialize message list if p_init_msg_list is set to TRUE.
3153: IF FND_API.to_Boolean(p_init_msg_list) THEN
3154: FND_MSG_PUB.initialize;
3155: END IF;
3156:
3157: -- Initialize API return status to success.
3158: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3165: FND_MSG_PUB.ADD;

3161: IF p_site_use_id IS NULL OR
3162: p_site_use_id = FND_API.G_MISS_NUM THEN
3163: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3164: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'site_use_id' );
3165: FND_MSG_PUB.ADD;
3166: RAISE FND_API.G_EXC_ERROR;
3167: END IF;
3168:
3169: x_cust_site_use_rec.site_use_id := p_site_use_id;

Line 3316: FND_MSG_PUB.Count_And_Get(

3312: NULL;
3313: END;
3314:
3315: -- Standard call to get message count and if count is 1, get message info.
3316: FND_MSG_PUB.Count_And_Get(
3317: p_encoded => FND_API.G_FALSE,
3318: p_count => x_msg_count,
3319: p_data => x_msg_data );
3320:

Line 3341: FND_MSG_PUB.Count_And_Get(

3337: EXCEPTION
3338: WHEN FND_API.G_EXC_ERROR THEN
3339: x_return_status := FND_API.G_RET_STS_ERROR;
3340:
3341: FND_MSG_PUB.Count_And_Get(
3342: p_encoded => FND_API.G_FALSE,
3343: p_count => x_msg_count,
3344: p_data => x_msg_data );
3345:

Line 3365: FND_MSG_PUB.Count_And_Get(

3361:
3362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3364:
3365: FND_MSG_PUB.Count_And_Get(
3366: p_encoded => FND_API.G_FALSE,
3367: p_count => x_msg_count,
3368: p_data => x_msg_data );
3369:

Line 3391: FND_MSG_PUB.ADD;

3387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3388:
3389: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3390: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3391: FND_MSG_PUB.ADD;
3392:
3393: FND_MSG_PUB.Count_And_Get(
3394: p_encoded => FND_API.G_FALSE,
3395: p_count => x_msg_count,

Line 3393: FND_MSG_PUB.Count_And_Get(

3389: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3390: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3391: FND_MSG_PUB.ADD;
3392:
3393: FND_MSG_PUB.Count_And_Get(
3394: p_encoded => FND_API.G_FALSE,
3395: p_count => x_msg_count,
3396: p_data => x_msg_data );
3397:

Line 3449: FND_MSG_PUB.ADD;

3445: p_account_site_rec.language <> p_old_account_site_rec.language)
3446: THEN
3447: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
3448: FND_MESSAGE.SET_TOKEN('COLUMN', 'language');
3449: FND_MSG_PUB.ADD;
3450: x_return_status := FND_API.G_RET_STS_ERROR;
3451: END IF;
3452:
3453: END check_obsolete_columns;