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

Line 361: FND_MSG_PUB.ADD;

357:
358: IF l_status = 'I' THEN
359: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INACTIVE_PROFILE_CLASS' );
360: FND_MESSAGE.SET_TOKEN( 'NAME', l_profile_class_name );
361: FND_MSG_PUB.ADD;
362: RAISE FND_API.G_EXC_ERROR;
363: END IF;
364:
365: -- Setup profile_class_id.

Line 371: FND_MSG_PUB.ADD;

367:
368: EXCEPTION
369: WHEN NO_DATA_FOUND THEN
370: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_DEFAULT_PROF_CLASS' );
371: FND_MSG_PUB.ADD;
372: RAISE FND_API.G_EXC_ERROR;
373: END;
374: END IF;
375:

Line 408: FND_MSG_PUB.ADD;

404: IF ( p_customer_profile_rec.cust_account_id IS NULL OR
405: p_customer_profile_rec.cust_account_id = FND_API.G_MISS_NUM )
406: THEN
407: FND_MESSAGE.SET_NAME('AR','HZ_API_CF_ASS_PTY_OR_ACCT');
408: FND_MSG_PUB.ADD;
409: x_return_status := FND_API.G_RET_STS_ERROR;
410: ELSE
411: l_party_id := party_id_value(p_customer_profile_rec.cust_account_id, 'A');
412: IF l_party_id = -99999 THEN

Line 415: FND_MSG_PUB.ADD;

411: l_party_id := party_id_value(p_customer_profile_rec.cust_account_id, 'A');
412: IF l_party_id = -99999 THEN
413: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_A_PTY_ASS_ACCT');
414: FND_MESSAGE.SET_TOKEN('ACCT_ID',p_customer_profile_rec.cust_account_id);
415: FND_MSG_PUB.ADD;
416: x_return_status := FND_API.G_RET_STS_ERROR;
417: END IF;
418: p_customer_profile_rec.party_id := l_party_id;
419: END IF;

Line 426: FND_MSG_PUB.ADD;

422:
423: IF party_exist( p_customer_profile_rec.party_id, 'A' ) <> 'Y' THEN
424: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_A_PTY');
425: FND_MESSAGE.SET_TOKEN( 'PARTY_ID', p_customer_profile_rec.party_id);
426: FND_MSG_PUB.ADD;
427: x_return_status := FND_API.G_RET_STS_ERROR;
428: END IF;
429:
430: IF ( p_customer_profile_rec.cust_account_id IS NULL OR

Line 441: FND_MSG_PUB.ADD;

437: THEN
438: FND_MESSAGE.SET_NAME('AR','HZ_API_ACCT_NOT_ASS_PTY');
439: FND_MESSAGE.SET_TOKEN( 'ACCT_ID', p_customer_profile_rec.cust_account_id );
440: FND_MESSAGE.SET_TOKEN( 'PARTY_ID', p_customer_profile_rec.party_id);
441: FND_MSG_PUB.ADD;
442: x_return_status := FND_API.G_RET_STS_ERROR;
443: END IF;
444: END IF;
445:

Line 462: FND_MSG_PUB.ADD;

458: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
459: FND_MESSAGE.SET_TOKEN( 'RECORD', 'Customer Profile Class' );
460: FND_MESSAGE.SET_TOKEN( 'VALUE',
461: NVL( TO_CHAR( p_customer_profile_rec.profile_class_id ), 'null' ) );
462: FND_MSG_PUB.ADD;
463: RAISE FND_API.G_EXC_ERROR;
464: END;
465: -- if cons_inv_flag is NULL, get it defaulted from profile class
466: -- if it is still NULL, assign it as 'N'

Line 488: FND_MSG_PUB.ADD;

484: if p_customer_profile_rec.site_use_id is NOT NULL then
485: /*
486: if p_customer_profile_rec.cons_bill_level is NOT NULL then
487: FND_MESSAGE.SET_NAME('AR', 'HZ_API_SITE_BILL_LVL_NULL');
488: FND_MSG_PUB.ADD;
489: x_return_status := FND_API.G_RET_STS_ERROR;
490: end if;
491: */
492: OPEN c_acct_use_profile_dtls;

Line 496: FND_MSG_PUB.ADD;

492: OPEN c_acct_use_profile_dtls;
493: FETCH c_acct_use_profile_dtls INTO l_cons_bill_level, l_cons_inv_type;
494: IF c_acct_use_profile_dtls%NOTFOUND THEN
495: FND_MESSAGE.SET_NAME('AR', 'HZ_API_ENABLE_ACC_BAL_FWD_BILL');
496: FND_MSG_PUB.ADD;
497: x_return_status := FND_API.G_RET_STS_ERROR;
498: END IF;
499: p_customer_profile_rec.cons_bill_level := l_cons_bill_level;
500: if p_customer_profile_rec.cons_inv_type is NULL then

Line 1076: FND_MSG_PUB.ADD;

1072: p_object_version_number = l_object_version_number ) )
1073: THEN
1074: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
1075: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_customer_profiles' );
1076: FND_MSG_PUB.ADD;
1077: RAISE FND_API.G_EXC_ERROR;
1078: END IF;
1079:
1080: p_object_version_number := NVL( l_object_version_number, 1 ) + 1;

Line 1088: FND_MSG_PUB.ADD;

1084: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
1085: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer profile' );
1086: FND_MESSAGE.SET_TOKEN( 'VALUE',
1087: NVL( TO_CHAR( p_customer_profile_rec.cust_account_profile_id ), 'null' ) );
1088: FND_MSG_PUB.ADD;
1089: RAISE FND_API.G_EXC_ERROR;
1090: END;
1091:
1092: l_profile_class_changed := 'N';

Line 1138: FND_MSG_PUB.ADD;

1134: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
1135: FND_MESSAGE.SET_TOKEN( 'RECORD', 'Customer Profile Class' );
1136: FND_MESSAGE.SET_TOKEN( 'VALUE',
1137: NVL( TO_CHAR( p_customer_profile_rec.profile_class_id ), 'null' ) );
1138: FND_MSG_PUB.ADD;
1139: RAISE FND_API.G_EXC_ERROR;
1140: END;
1141: -- Value for cons_inv_flag should be Y or N
1142: if p_customer_profile_rec.cons_inv_flag is NULL then

Line 1165: FND_MSG_PUB.ADD;

1161: if l_site_use_id is NOT NULL AND
1162: p_customer_profile_rec.cons_bill_level <> FND_API.G_MISS_CHAR AND
1163: p_customer_profile_rec.cons_bill_level <> NVL(l_cons_bill_level, FND_API.G_MISS_CHAR) then
1164: FND_MESSAGE.SET_NAME('AR', 'HZ_API_SITE_BILL_LVL_NULL');
1165: FND_MSG_PUB.ADD;
1166: x_return_status := FND_API.G_RET_STS_ERROR;
1167: end if;
1168: */
1169:

Line 1181: FND_MSG_PUB.ADD;

1177: OPEN c_acct_use_profile_dtls;
1178: FETCH c_acct_use_profile_dtls INTO ll_cons_bill_level, ll_cons_inv_type;
1179: IF c_acct_use_profile_dtls%NOTFOUND THEN
1180: FND_MESSAGE.SET_NAME('AR', 'HZ_API_ENABLE_ACC_BAL_FWD_BILL');
1181: FND_MSG_PUB.ADD;
1182: x_return_status := FND_API.G_RET_STS_ERROR;
1183: END IF;
1184: p_customer_profile_rec.cons_bill_level := ll_cons_bill_level;
1185: if ( p_customer_profile_rec.cons_inv_type is NULL OR

Line 1996: FND_MSG_PUB.ADD;

1992: p_object_version_number = l_object_version_number ) )
1993: THEN
1994: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
1995: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_profile_amts' );
1996: FND_MSG_PUB.ADD;
1997: RAISE FND_API.G_EXC_ERROR;
1998: END IF;
1999:
2000: p_object_version_number := NVL( l_object_version_number, 1 ) + 1;

Line 2008: FND_MSG_PUB.ADD;

2004: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
2005: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer account profile amount' );
2006: FND_MESSAGE.SET_TOKEN( 'VALUE',
2007: NVL( TO_CHAR( p_cust_profile_amt_rec.cust_acct_profile_amt_id ), 'null' ) );
2008: FND_MSG_PUB.ADD;
2009: RAISE FND_API.G_EXC_ERROR;
2010: END;
2011:
2012: -- Validate cust profile amt record

Line 2315: FND_MSG_PUB.initialize;

2311: END IF;
2312:
2313: -- Initialize message list if p_init_msg_list is set to TRUE.
2314: IF FND_API.to_Boolean(p_init_msg_list) THEN
2315: FND_MSG_PUB.initialize;
2316: END IF;
2317:
2318: -- Initialize API return status to success.
2319: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2344: FND_MSG_PUB.Count_And_Get(

2340: END IF;
2341: END IF;
2342:
2343: -- Standard call to get message count and if count is 1, get message info.
2344: FND_MSG_PUB.Count_And_Get(
2345: p_encoded => FND_API.G_FALSE,
2346: p_count => x_msg_count,
2347: p_data => x_msg_data );
2348:

Line 2370: FND_MSG_PUB.Count_And_Get(

2366: WHEN FND_API.G_EXC_ERROR THEN
2367: ROLLBACK TO create_customer_profile;
2368: x_return_status := FND_API.G_RET_STS_ERROR;
2369:
2370: FND_MSG_PUB.Count_And_Get(
2371: p_encoded => FND_API.G_FALSE,
2372: p_count => x_msg_count,
2373: p_data => x_msg_data );
2374:

Line 2394: FND_MSG_PUB.Count_And_Get(

2390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2391: ROLLBACK TO create_customer_profile;
2392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2393:
2394: FND_MSG_PUB.Count_And_Get(
2395: p_encoded => FND_API.G_FALSE,
2396: p_count => x_msg_count,
2397: p_data => x_msg_data );
2398:

Line 2420: FND_MSG_PUB.ADD;

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

Line 2422: FND_MSG_PUB.Count_And_Get(

2418: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2419: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2420: FND_MSG_PUB.ADD;
2421:
2422: FND_MSG_PUB.Count_And_Get(
2423: p_encoded => FND_API.G_FALSE,
2424: p_count => x_msg_count,
2425: p_data => x_msg_data );
2426:

Line 2508: FND_MSG_PUB.initialize;

2504: END IF;
2505:
2506: -- Initialize message list if p_init_msg_list is set to TRUE.
2507: IF FND_API.to_Boolean(p_init_msg_list) THEN
2508: FND_MSG_PUB.initialize;
2509: END IF;
2510:
2511: -- Initialize API return status to success.
2512: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2549: FND_MSG_PUB.Count_And_Get(

2545: END IF;
2546: END IF;
2547:
2548: -- Standard call to get message count and if count is 1, get message info.
2549: FND_MSG_PUB.Count_And_Get(
2550: p_encoded => FND_API.G_FALSE,
2551: p_count => x_msg_count,
2552: p_data => x_msg_data );
2553:

Line 2574: FND_MSG_PUB.Count_And_Get(

2570: WHEN FND_API.G_EXC_ERROR THEN
2571: ROLLBACK TO update_customer_profile;
2572: x_return_status := FND_API.G_RET_STS_ERROR;
2573:
2574: FND_MSG_PUB.Count_And_Get(
2575: p_encoded => FND_API.G_FALSE,
2576: p_count => x_msg_count,
2577: p_data => x_msg_data );
2578:

Line 2598: FND_MSG_PUB.Count_And_Get(

2594: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2595: ROLLBACK TO update_customer_profile;
2596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2597:
2598: FND_MSG_PUB.Count_And_Get(
2599: p_encoded => FND_API.G_FALSE,
2600: p_count => x_msg_count,
2601: p_data => x_msg_data );
2602:

Line 2624: FND_MSG_PUB.ADD;

2620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2621:
2622: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2623: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2624: FND_MSG_PUB.ADD;
2625:
2626: FND_MSG_PUB.Count_And_Get(
2627: p_encoded => FND_API.G_FALSE,
2628: p_count => x_msg_count,

Line 2626: FND_MSG_PUB.Count_And_Get(

2622: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2623: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2624: FND_MSG_PUB.ADD;
2625:
2626: FND_MSG_PUB.Count_And_Get(
2627: p_encoded => FND_API.G_FALSE,
2628: p_count => x_msg_count,
2629: p_data => x_msg_data );
2630:

Line 2703: FND_MSG_PUB.initialize;

2699: END IF;
2700:
2701: -- Initialize message list if p_init_msg_list is set to TRUE.
2702: IF FND_API.to_Boolean(p_init_msg_list) THEN
2703: FND_MSG_PUB.initialize;
2704: END IF;
2705:
2706: -- Initialize API return status to success.
2707: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2714: FND_MSG_PUB.ADD;

2710: IF p_cust_account_profile_id IS NULL OR
2711: p_cust_account_profile_id = FND_API.G_MISS_NUM THEN
2712: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2713: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_account_profile_id' );
2714: FND_MSG_PUB.ADD;
2715: RAISE FND_API.G_EXC_ERROR;
2716: END IF;
2717:
2718: x_customer_profile_rec.cust_account_profile_id := p_cust_account_profile_id;

Line 2849: FND_MSG_PUB.Count_And_Get(

2845: p_msg_level=>fnd_log.level_procedure);
2846: END IF;
2847:
2848: -- Standard call to get message count and if count is 1, get message info.
2849: FND_MSG_PUB.Count_And_Get(
2850: p_encoded => FND_API.G_FALSE,
2851: p_count => x_msg_count,
2852: p_data => x_msg_data );
2853:

Line 2874: FND_MSG_PUB.Count_And_Get(

2870: EXCEPTION
2871: WHEN FND_API.G_EXC_ERROR THEN
2872: x_return_status := FND_API.G_RET_STS_ERROR;
2873:
2874: FND_MSG_PUB.Count_And_Get(
2875: p_encoded => FND_API.G_FALSE,
2876: p_count => x_msg_count,
2877: p_data => x_msg_data );
2878:

Line 2898: FND_MSG_PUB.Count_And_Get(

2894:
2895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2896: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2897:
2898: FND_MSG_PUB.Count_And_Get(
2899: p_encoded => FND_API.G_FALSE,
2900: p_count => x_msg_count,
2901: p_data => x_msg_data );
2902:

Line 2924: FND_MSG_PUB.ADD;

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

Line 2926: FND_MSG_PUB.Count_And_Get(

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

Line 3016: FND_MSG_PUB.initialize;

3012: END IF;
3013:
3014: -- Initialize message list if p_init_msg_list is set to TRUE.
3015: IF FND_API.to_Boolean(p_init_msg_list) THEN
3016: FND_MSG_PUB.initialize;
3017: END IF;
3018:
3019: -- Initialize API return status to success.
3020: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3044: FND_MSG_PUB.Count_And_Get(

3040: END IF;
3041: END IF;
3042:
3043: -- Standard call to get message count and if count is 1, get message info.
3044: FND_MSG_PUB.Count_And_Get(
3045: p_encoded => FND_API.G_FALSE,
3046: p_count => x_msg_count,
3047: p_data => x_msg_data );
3048:

Line 3070: FND_MSG_PUB.Count_And_Get(

3066: WHEN FND_API.G_EXC_ERROR THEN
3067: ROLLBACK TO create_cust_profile_amt;
3068: x_return_status := FND_API.G_RET_STS_ERROR;
3069:
3070: FND_MSG_PUB.Count_And_Get(
3071: p_encoded => FND_API.G_FALSE,
3072: p_count => x_msg_count,
3073: p_data => x_msg_data );
3074:

Line 3095: FND_MSG_PUB.Count_And_Get(

3091: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3092: ROLLBACK TO create_cust_profile_amt;
3093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3094:
3095: FND_MSG_PUB.Count_And_Get(
3096: p_encoded => FND_API.G_FALSE,
3097: p_count => x_msg_count,
3098: p_data => x_msg_data );
3099:

Line 3122: FND_MSG_PUB.ADD;

3118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3119:
3120: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3121: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3122: FND_MSG_PUB.ADD;
3123:
3124: FND_MSG_PUB.Count_And_Get(
3125: p_encoded => FND_API.G_FALSE,
3126: p_count => x_msg_count,

Line 3124: FND_MSG_PUB.Count_And_Get(

3120: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3121: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3122: FND_MSG_PUB.ADD;
3123:
3124: FND_MSG_PUB.Count_And_Get(
3125: p_encoded => FND_API.G_FALSE,
3126: p_count => x_msg_count,
3127: p_data => x_msg_data );
3128:

Line 3210: FND_MSG_PUB.initialize;

3206: END IF;
3207:
3208: -- Initialize message list if p_init_msg_list is set to TRUE.
3209: IF FND_API.to_Boolean(p_init_msg_list) THEN
3210: FND_MSG_PUB.initialize;
3211: END IF;
3212:
3213: -- Initialize API return status to success.
3214: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3251: FND_MSG_PUB.Count_And_Get(

3247: END IF;
3248: END IF;
3249:
3250: -- Standard call to get message count and if count is 1, get message info.
3251: FND_MSG_PUB.Count_And_Get(
3252: p_encoded => FND_API.G_FALSE,
3253: p_count => x_msg_count,
3254: p_data => x_msg_data );
3255:

Line 3278: FND_MSG_PUB.Count_And_Get(

3274: WHEN FND_API.G_EXC_ERROR THEN
3275: ROLLBACK TO update_cust_profile_amt;
3276: x_return_status := FND_API.G_RET_STS_ERROR;
3277:
3278: FND_MSG_PUB.Count_And_Get(
3279: p_encoded => FND_API.G_FALSE,
3280: p_count => x_msg_count,
3281: p_data => x_msg_data );
3282:

Line 3303: FND_MSG_PUB.Count_And_Get(

3299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3300: ROLLBACK TO update_cust_profile_amt;
3301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3302:
3303: FND_MSG_PUB.Count_And_Get(
3304: p_encoded => FND_API.G_FALSE,
3305: p_count => x_msg_count,
3306: p_data => x_msg_data );
3307:

Line 3330: FND_MSG_PUB.ADD;

3326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3327:
3328: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3329: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3330: FND_MSG_PUB.ADD;
3331:
3332: FND_MSG_PUB.Count_And_Get(
3333: p_encoded => FND_API.G_FALSE,
3334: p_count => x_msg_count,

Line 3332: FND_MSG_PUB.Count_And_Get(

3328: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3329: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3330: FND_MSG_PUB.ADD;
3331:
3332: FND_MSG_PUB.Count_And_Get(
3333: p_encoded => FND_API.G_FALSE,
3334: p_count => x_msg_count,
3335: p_data => x_msg_data );
3336:

Line 3410: FND_MSG_PUB.initialize;

3406: END IF;
3407:
3408: -- Initialize message list if p_init_msg_list is set to TRUE.
3409: IF FND_API.to_Boolean(p_init_msg_list) THEN
3410: FND_MSG_PUB.initialize;
3411: END IF;
3412:
3413: -- Initialize API return status to success.
3414: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3421: FND_MSG_PUB.ADD;

3417: IF p_cust_acct_profile_amt_id IS NULL OR
3418: p_cust_acct_profile_amt_id = FND_API.G_MISS_NUM THEN
3419: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3420: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_acct_profile_amt_id' );
3421: FND_MSG_PUB.ADD;
3422: RAISE FND_API.G_EXC_ERROR;
3423: END IF;
3424:
3425: x_cust_profile_amt_rec.cust_acct_profile_amt_id := p_cust_acct_profile_amt_id;

Line 3530: FND_MSG_PUB.Count_And_Get(

3526: p_msg_level=>fnd_log.level_procedure);
3527: END IF;
3528:
3529: -- Standard call to get message count and if count is 1, get message info.
3530: FND_MSG_PUB.Count_And_Get(
3531: p_encoded => FND_API.G_FALSE,
3532: p_count => x_msg_count,
3533: p_data => x_msg_data );
3534:

Line 3555: FND_MSG_PUB.Count_And_Get(

3551: EXCEPTION
3552: WHEN FND_API.G_EXC_ERROR THEN
3553: x_return_status := FND_API.G_RET_STS_ERROR;
3554:
3555: FND_MSG_PUB.Count_And_Get(
3556: p_encoded => FND_API.G_FALSE,
3557: p_count => x_msg_count,
3558: p_data => x_msg_data );
3559:

Line 3579: FND_MSG_PUB.Count_And_Get(

3575:
3576: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3578:
3579: FND_MSG_PUB.Count_And_Get(
3580: p_encoded => FND_API.G_FALSE,
3581: p_count => x_msg_count,
3582: p_data => x_msg_data );
3583:

Line 3605: FND_MSG_PUB.ADD;

3601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3602:
3603: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3604: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3605: FND_MSG_PUB.ADD;
3606:
3607: FND_MSG_PUB.Count_And_Get(
3608: p_encoded => FND_API.G_FALSE,
3609: p_count => x_msg_count,

Line 3607: FND_MSG_PUB.Count_And_Get(

3603: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3604: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3605: FND_MSG_PUB.ADD;
3606:
3607: FND_MSG_PUB.Count_And_Get(
3608: p_encoded => FND_API.G_FALSE,
3609: p_count => x_msg_count,
3610: p_data => x_msg_data );
3611: