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

759: p_object_version_number = l_object_version_number ) )
760: THEN
761: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
762: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_acct_sites' );
763: FND_MSG_PUB.ADD;
764: RAISE FND_API.G_EXC_ERROR;
765: END IF;
766:
767: p_object_version_number := NVL( l_object_version_number, 1 ) + 1;

Line 775: FND_MSG_PUB.ADD;

771: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
772: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer account site' );
773: FND_MESSAGE.SET_TOKEN( 'VALUE',
774: NVL( TO_CHAR( p_cust_acct_site_rec.cust_acct_site_id ), 'null' ) );
775: FND_MSG_PUB.ADD;
776: RAISE FND_API.G_EXC_ERROR;
777: END;
778:
779:

Line 820: FND_MSG_PUB.ADD;

816: WHEN NO_DATA_FOUND THEN
817: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
818: FND_MESSAGE.SET_TOKEN('RECORD', 'Message Name');
819: FND_MESSAGE.SET_TOKEN('VALUE', 'HZ_INACTIVATE_ACCOUNT_SITE_UI');
820: FND_MSG_PUB.ADD;
821: RAISE FND_API.G_EXC_ERROR;
822: END;
823: END IF;
824: IF g_message_name IS NOT NULL THEN

Line 840: FND_MSG_PUB.ADD;

836: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
837: FND_MESSAGE.SET_TOKEN( 'RECORD', 'party site' );
838: FND_MESSAGE.SET_TOKEN( 'VALUE',
839: NVL( TO_CHAR( p_cust_acct_site_rec.party_site_id ), 'null' ) );
840: FND_MSG_PUB.ADD;
841: RAISE FND_API.G_EXC_ERROR;
842: END;
843: l_party_site_rec.party_site_id := l_party_site_id;
844: l_party_site_rec.status := p_cust_acct_site_rec.status;

Line 1086: FND_MSG_PUB.ADD;

1082: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer account site' );
1083: FND_MESSAGE.SET_TOKEN( 'VALUE',
1084: NVL( TO_CHAR(
1085: p_cust_site_use_rec.cust_acct_site_id ), 'null' ) );
1086: FND_MSG_PUB.ADD;
1087: RAISE FND_API.G_EXC_ERROR;
1088: END;
1089: END IF;
1090:

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

1109: END IF;
1110:
1111: -- Create party site use of same type if one does not exist.
1112:
1113: l_message_count := FND_MSG_PUB.Count_Msg();
1114:
1115: HZ_UTILITY_V2PUB.validate_lookup (
1116: p_column => 'site_use_code',
1117: p_lookup_type => 'PARTY_SITE_USE_CODE',

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

1127: END IF;
1128:
1129: -- site_use_code is not in a valid site_use_code in party level.
1130: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1131: FND_MSG_PUB.DELETE_MSG( l_message_count + 1 );
1132: x_return_status := FND_API.G_RET_STS_SUCCESS;
1133: ELSE
1134: -- Create party site use
1135: SELECT PARTY_SITE_ID INTO l_party_site_id

Line 1595: FND_MSG_PUB.ADD;

1591: p_object_version_number = l_object_version_number ) )
1592: THEN
1593: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
1594: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_site_uses' );
1595: FND_MSG_PUB.ADD;
1596: RAISE FND_API.G_EXC_ERROR;
1597: END IF;
1598:
1599: p_object_version_number := NVL( l_object_version_number, 1 ) + 1;

Line 1607: FND_MSG_PUB.ADD;

1603: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
1604: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer site use' );
1605: FND_MESSAGE.SET_TOKEN( 'VALUE',
1606: NVL( TO_CHAR( p_cust_site_use_rec.site_use_id ), 'null' ) );
1607: FND_MSG_PUB.ADD;
1608: RAISE FND_API.G_EXC_ERROR;
1609: END;
1610:
1611: -- Validate cust site use record

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

1621:
1622: ---Create party site use of same type if one does not exist.
1623: --Bug No. 5036975
1624: IF p_cust_site_use_rec.status = 'A' THEN
1625: l_message_count := FND_MSG_PUB.Count_Msg();
1626: HZ_UTILITY_V2PUB.validate_lookup (
1627: p_column => 'site_use_code',
1628: p_lookup_type => 'PARTY_SITE_USE_CODE',
1629: p_column_value => p_cust_site_use_rec.site_use_code,

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

1638: END IF;
1639:
1640: -- site_use_code is not in a valid site_use_code in party level.
1641: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1642: FND_MSG_PUB.DELETE_MSG( l_message_count + 1 );
1643: x_return_status := FND_API.G_RET_STS_SUCCESS;
1644: ELSE
1645: -- Create party site use
1646:

Line 2166: FND_MSG_PUB.initialize;

2162: END IF;
2163:
2164: -- Initialize message list if p_init_msg_list is set to TRUE.
2165: IF FND_API.to_Boolean(p_init_msg_list) THEN
2166: FND_MSG_PUB.initialize;
2167: END IF;
2168:
2169: -- Initialize API return status to success.
2170: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2207: FND_MSG_PUB.Count_And_Get(

2203: END IF;
2204: END IF;
2205:
2206: -- Standard call to get message count and if count is 1, get message info.
2207: FND_MSG_PUB.Count_And_Get(
2208: p_encoded => FND_API.G_FALSE,
2209: p_count => x_msg_count,
2210: p_data => x_msg_data );
2211:

Line 2233: FND_MSG_PUB.Count_And_Get(

2229: WHEN FND_API.G_EXC_ERROR THEN
2230: ROLLBACK TO create_cust_acct_site;
2231: x_return_status := FND_API.G_RET_STS_ERROR;
2232:
2233: FND_MSG_PUB.Count_And_Get(
2234: p_encoded => FND_API.G_FALSE,
2235: p_count => x_msg_count,
2236: p_data => x_msg_data );
2237:

Line 2258: FND_MSG_PUB.Count_And_Get(

2254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2255: ROLLBACK TO create_cust_acct_site;
2256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2257:
2258: FND_MSG_PUB.Count_And_Get(
2259: p_encoded => FND_API.G_FALSE,
2260: p_count => x_msg_count,
2261: p_data => x_msg_data );
2262:

Line 2285: FND_MSG_PUB.ADD;

2281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2282:
2283: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2284: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2285: FND_MSG_PUB.ADD;
2286:
2287: FND_MSG_PUB.Count_And_Get(
2288: p_encoded => FND_API.G_FALSE,
2289: p_count => x_msg_count,

Line 2287: FND_MSG_PUB.Count_And_Get(

2283: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2284: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2285: FND_MSG_PUB.ADD;
2286:
2287: FND_MSG_PUB.Count_And_Get(
2288: p_encoded => FND_API.G_FALSE,
2289: p_count => x_msg_count,
2290: p_data => x_msg_data );
2291:

Line 2372: FND_MSG_PUB.initialize;

2368: END IF;
2369:
2370: -- Initialize message list if p_init_msg_list is set to TRUE.
2371: IF FND_API.to_Boolean(p_init_msg_list) THEN
2372: FND_MSG_PUB.initialize;
2373: END IF;
2374:
2375: -- Initialize API return status to success.
2376: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2446: FND_MSG_PUB.Count_And_Get(

2442: END IF;
2443: END IF;
2444:
2445: -- Standard call to get message count and if count is 1, get message info.
2446: FND_MSG_PUB.Count_And_Get(
2447: p_encoded => FND_API.G_FALSE,
2448: p_count => x_msg_count,
2449: p_data => x_msg_data );
2450:

Line 2472: FND_MSG_PUB.Count_And_Get(

2468: WHEN FND_API.G_EXC_ERROR THEN
2469: ROLLBACK TO update_cust_acct_site;
2470: x_return_status := FND_API.G_RET_STS_ERROR;
2471:
2472: FND_MSG_PUB.Count_And_Get(
2473: p_encoded => FND_API.G_FALSE,
2474: p_count => x_msg_count,
2475: p_data => x_msg_data );
2476:

Line 2497: FND_MSG_PUB.Count_And_Get(

2493: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2494: ROLLBACK TO update_cust_acct_site;
2495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2496:
2497: FND_MSG_PUB.Count_And_Get(
2498: p_encoded => FND_API.G_FALSE,
2499: p_count => x_msg_count,
2500: p_data => x_msg_data );
2501:

Line 2524: FND_MSG_PUB.ADD;

2520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2521:
2522: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2523: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2524: FND_MSG_PUB.ADD;
2525:
2526: FND_MSG_PUB.Count_And_Get(
2527: p_encoded => FND_API.G_FALSE,
2528: p_count => x_msg_count,

Line 2526: FND_MSG_PUB.Count_And_Get(

2522: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2523: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2524: FND_MSG_PUB.ADD;
2525:
2526: FND_MSG_PUB.Count_And_Get(
2527: p_encoded => FND_API.G_FALSE,
2528: p_count => x_msg_count,
2529: p_data => x_msg_data );
2530:

Line 2604: FND_MSG_PUB.initialize;

2600: END IF;
2601:
2602: -- Initialize message list if p_init_msg_list is set to TRUE.
2603: IF FND_API.to_Boolean(p_init_msg_list) THEN
2604: FND_MSG_PUB.initialize;
2605: END IF;
2606:
2607: -- Initialize API return status to success.
2608: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2615: FND_MSG_PUB.ADD;

2611: IF p_cust_acct_site_id IS NULL OR
2612: p_cust_acct_site_id = FND_API.G_MISS_NUM THEN
2613: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2614: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_acct_site_id' );
2615: FND_MSG_PUB.ADD;
2616: RAISE FND_API.G_EXC_ERROR;
2617: END IF;
2618:
2619: x_cust_acct_site_rec.cust_acct_site_id := p_cust_acct_site_id;

Line 2700: FND_MSG_PUB.Count_And_Get(

2696: p_msg_level=>fnd_log.level_procedure);
2697: END IF;
2698:
2699: -- Standard call to get message count and if count is 1, get message info.
2700: FND_MSG_PUB.Count_And_Get(
2701: p_encoded => FND_API.G_FALSE,
2702: p_count => x_msg_count,
2703: p_data => x_msg_data );
2704:

Line 2725: FND_MSG_PUB.Count_And_Get(

2721: EXCEPTION
2722: WHEN FND_API.G_EXC_ERROR THEN
2723: x_return_status := FND_API.G_RET_STS_ERROR;
2724:
2725: FND_MSG_PUB.Count_And_Get(
2726: p_encoded => FND_API.G_FALSE,
2727: p_count => x_msg_count,
2728: p_data => x_msg_data );
2729:

Line 2749: FND_MSG_PUB.Count_And_Get(

2745:
2746: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2748:
2749: FND_MSG_PUB.Count_And_Get(
2750: p_encoded => FND_API.G_FALSE,
2751: p_count => x_msg_count,
2752: p_data => x_msg_data );
2753:

Line 2775: FND_MSG_PUB.ADD;

2771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2772:
2773: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2774: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2775: FND_MSG_PUB.ADD;
2776:
2777: FND_MSG_PUB.Count_And_Get(
2778: p_encoded => FND_API.G_FALSE,
2779: p_count => x_msg_count,

Line 2777: FND_MSG_PUB.Count_And_Get(

2773: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2774: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2775: FND_MSG_PUB.ADD;
2776:
2777: FND_MSG_PUB.Count_And_Get(
2778: p_encoded => FND_API.G_FALSE,
2779: p_count => x_msg_count,
2780: p_data => x_msg_data );
2781:

Line 2873: FND_MSG_PUB.initialize;

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

Line 2906: FND_MSG_PUB.Count_And_Get(

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

Line 2931: FND_MSG_PUB.Count_And_Get(

2927: WHEN FND_API.G_EXC_ERROR THEN
2928: ROLLBACK TO create_cust_site_use;
2929: x_return_status := FND_API.G_RET_STS_ERROR;
2930:
2931: FND_MSG_PUB.Count_And_Get(
2932: p_encoded => FND_API.G_FALSE,
2933: p_count => x_msg_count,
2934: p_data => x_msg_data );
2935:

Line 2956: FND_MSG_PUB.Count_And_Get(

2952: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2953: ROLLBACK TO create_cust_site_use;
2954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2955:
2956: FND_MSG_PUB.Count_And_Get(
2957: p_encoded => FND_API.G_FALSE,
2958: p_count => x_msg_count,
2959: p_data => x_msg_data );
2960:

Line 2983: FND_MSG_PUB.ADD;

2979: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2980:
2981: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2982: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2983: FND_MSG_PUB.ADD;
2984:
2985: FND_MSG_PUB.Count_And_Get(
2986: p_encoded => FND_API.G_FALSE,
2987: p_count => x_msg_count,

Line 2985: FND_MSG_PUB.Count_And_Get(

2981: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2982: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2983: FND_MSG_PUB.ADD;
2984:
2985: FND_MSG_PUB.Count_And_Get(
2986: p_encoded => FND_API.G_FALSE,
2987: p_count => x_msg_count,
2988: p_data => x_msg_data );
2989:

Line 3071: FND_MSG_PUB.initialize;

3067: END IF;
3068:
3069: -- Initialize message list if p_init_msg_list is set to TRUE.
3070: IF FND_API.to_Boolean(p_init_msg_list) THEN
3071: FND_MSG_PUB.initialize;
3072: END IF;
3073:
3074: -- Initialize API return status to success.
3075: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3130: FND_MSG_PUB.Count_And_Get(

3126: END IF;
3127: END IF;
3128:
3129: -- Standard call to get message count and if count is 1, get message info.
3130: FND_MSG_PUB.Count_And_Get(
3131: p_encoded => FND_API.G_FALSE,
3132: p_count => x_msg_count,
3133: p_data => x_msg_data );
3134:

Line 3156: FND_MSG_PUB.Count_And_Get(

3152: WHEN FND_API.G_EXC_ERROR THEN
3153: ROLLBACK TO update_cust_site_use;
3154: x_return_status := FND_API.G_RET_STS_ERROR;
3155:
3156: FND_MSG_PUB.Count_And_Get(
3157: p_encoded => FND_API.G_FALSE,
3158: p_count => x_msg_count,
3159: p_data => x_msg_data );
3160:

Line 3181: FND_MSG_PUB.Count_And_Get(

3177: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3178: ROLLBACK TO update_cust_site_use;
3179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3180:
3181: FND_MSG_PUB.Count_And_Get(
3182: p_encoded => FND_API.G_FALSE,
3183: p_count => x_msg_count,
3184: p_data => x_msg_data );
3185:

Line 3208: FND_MSG_PUB.ADD;

3204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3205:
3206: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3207: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3208: FND_MSG_PUB.ADD;
3209:
3210: FND_MSG_PUB.Count_And_Get(
3211: p_encoded => FND_API.G_FALSE,
3212: p_count => x_msg_count,

Line 3210: FND_MSG_PUB.Count_And_Get(

3206: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3207: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3208: FND_MSG_PUB.ADD;
3209:
3210: FND_MSG_PUB.Count_And_Get(
3211: p_encoded => FND_API.G_FALSE,
3212: p_count => x_msg_count,
3213: p_data => x_msg_data );
3214:

Line 3293: FND_MSG_PUB.initialize;

3289: END IF;
3290:
3291: -- Initialize message list if p_init_msg_list is set to TRUE.
3292: IF FND_API.to_Boolean(p_init_msg_list) THEN
3293: FND_MSG_PUB.initialize;
3294: END IF;
3295:
3296: -- Initialize API return status to success.
3297: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3304: FND_MSG_PUB.ADD;

3300: IF p_site_use_id IS NULL OR
3301: p_site_use_id = FND_API.G_MISS_NUM THEN
3302: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3303: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'site_use_id' );
3304: FND_MSG_PUB.ADD;
3305: RAISE FND_API.G_EXC_ERROR;
3306: END IF;
3307:
3308: x_cust_site_use_rec.site_use_id := p_site_use_id;

Line 3455: FND_MSG_PUB.Count_And_Get(

3451: NULL;
3452: END;
3453:
3454: -- Standard call to get message count and if count is 1, get message info.
3455: FND_MSG_PUB.Count_And_Get(
3456: p_encoded => FND_API.G_FALSE,
3457: p_count => x_msg_count,
3458: p_data => x_msg_data );
3459:

Line 3480: FND_MSG_PUB.Count_And_Get(

3476: EXCEPTION
3477: WHEN FND_API.G_EXC_ERROR THEN
3478: x_return_status := FND_API.G_RET_STS_ERROR;
3479:
3480: FND_MSG_PUB.Count_And_Get(
3481: p_encoded => FND_API.G_FALSE,
3482: p_count => x_msg_count,
3483: p_data => x_msg_data );
3484:

Line 3504: FND_MSG_PUB.Count_And_Get(

3500:
3501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3503:
3504: FND_MSG_PUB.Count_And_Get(
3505: p_encoded => FND_API.G_FALSE,
3506: p_count => x_msg_count,
3507: p_data => x_msg_data );
3508:

Line 3530: FND_MSG_PUB.ADD;

3526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3527:
3528: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3529: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3530: FND_MSG_PUB.ADD;
3531:
3532: FND_MSG_PUB.Count_And_Get(
3533: p_encoded => FND_API.G_FALSE,
3534: p_count => x_msg_count,

Line 3532: FND_MSG_PUB.Count_And_Get(

3528: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3529: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3530: FND_MSG_PUB.ADD;
3531:
3532: FND_MSG_PUB.Count_And_Get(
3533: p_encoded => FND_API.G_FALSE,
3534: p_count => x_msg_count,
3535: p_data => x_msg_data );
3536:

Line 3588: FND_MSG_PUB.ADD;

3584: p_account_site_rec.language <> p_old_account_site_rec.language)
3585: THEN
3586: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
3587: FND_MESSAGE.SET_TOKEN('COLUMN', 'language');
3588: FND_MSG_PUB.ADD;
3589: x_return_status := FND_API.G_RET_STS_ERROR;
3590: END IF;
3591:
3592: END check_obsolete_columns;