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

473: if p_customer_profile_rec.site_use_id is NOT NULL then
474: /*
475: if p_customer_profile_rec.cons_bill_level is NOT NULL then
476: FND_MESSAGE.SET_NAME('AR', 'HZ_API_SITE_BILL_LVL_NULL');
477: FND_MSG_PUB.ADD;
478: x_return_status := FND_API.G_RET_STS_ERROR;
479: end if;
480: */
481: OPEN c_acct_use_profile_dtls;

Line 485: FND_MSG_PUB.ADD;

481: OPEN c_acct_use_profile_dtls;
482: FETCH c_acct_use_profile_dtls INTO l_cons_bill_level, l_cons_inv_type;
483: IF c_acct_use_profile_dtls%NOTFOUND THEN
484: FND_MESSAGE.SET_NAME('AR', 'HZ_API_ENABLE_ACC_BAL_FWD_BILL');
485: FND_MSG_PUB.ADD;
486: x_return_status := FND_API.G_RET_STS_ERROR;
487: END IF;
488: p_customer_profile_rec.cons_bill_level := l_cons_bill_level;
489: if p_customer_profile_rec.cons_inv_type is NULL then

Line 1042: FND_MSG_PUB.ADD;

1038: p_object_version_number = l_object_version_number ) )
1039: THEN
1040: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
1041: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_customer_profiles' );
1042: FND_MSG_PUB.ADD;
1043: RAISE FND_API.G_EXC_ERROR;
1044: END IF;
1045:
1046: p_object_version_number := NVL( l_object_version_number, 1 ) + 1;

Line 1054: FND_MSG_PUB.ADD;

1050: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
1051: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer profile' );
1052: FND_MESSAGE.SET_TOKEN( 'VALUE',
1053: NVL( TO_CHAR( p_customer_profile_rec.cust_account_profile_id ), 'null' ) );
1054: FND_MSG_PUB.ADD;
1055: RAISE FND_API.G_EXC_ERROR;
1056: END;
1057:
1058: l_profile_class_changed := 'N';

Line 1116: FND_MSG_PUB.ADD;

1112: if l_site_use_id is NOT NULL AND
1113: p_customer_profile_rec.cons_bill_level <> FND_API.G_MISS_CHAR AND
1114: p_customer_profile_rec.cons_bill_level <> NVL(l_cons_bill_level, FND_API.G_MISS_CHAR) then
1115: FND_MESSAGE.SET_NAME('AR', 'HZ_API_SITE_BILL_LVL_NULL');
1116: FND_MSG_PUB.ADD;
1117: x_return_status := FND_API.G_RET_STS_ERROR;
1118: end if;
1119: */
1120:

Line 1132: FND_MSG_PUB.ADD;

1128: OPEN c_acct_use_profile_dtls;
1129: FETCH c_acct_use_profile_dtls INTO ll_cons_bill_level, ll_cons_inv_type;
1130: IF c_acct_use_profile_dtls%NOTFOUND THEN
1131: FND_MESSAGE.SET_NAME('AR', 'HZ_API_ENABLE_ACC_BAL_FWD_BILL');
1132: FND_MSG_PUB.ADD;
1133: x_return_status := FND_API.G_RET_STS_ERROR;
1134: END IF;
1135: p_customer_profile_rec.cons_bill_level := ll_cons_bill_level;
1136: if ( p_customer_profile_rec.cons_inv_type is NULL OR

Line 1933: FND_MSG_PUB.ADD;

1929: p_object_version_number = l_object_version_number ) )
1930: THEN
1931: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
1932: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_profile_amts' );
1933: FND_MSG_PUB.ADD;
1934: RAISE FND_API.G_EXC_ERROR;
1935: END IF;
1936:
1937: p_object_version_number := NVL( l_object_version_number, 1 ) + 1;

Line 1945: FND_MSG_PUB.ADD;

1941: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
1942: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer account profile amount' );
1943: FND_MESSAGE.SET_TOKEN( 'VALUE',
1944: NVL( TO_CHAR( p_cust_profile_amt_rec.cust_acct_profile_amt_id ), 'null' ) );
1945: FND_MSG_PUB.ADD;
1946: RAISE FND_API.G_EXC_ERROR;
1947: END;
1948:
1949: -- Validate cust profile amt record

Line 2252: FND_MSG_PUB.initialize;

2248: END IF;
2249:
2250: -- Initialize message list if p_init_msg_list is set to TRUE.
2251: IF FND_API.to_Boolean(p_init_msg_list) THEN
2252: FND_MSG_PUB.initialize;
2253: END IF;
2254:
2255: -- Initialize API return status to success.
2256: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2281: FND_MSG_PUB.Count_And_Get(

2277: END IF;
2278: END IF;
2279:
2280: -- Standard call to get message count and if count is 1, get message info.
2281: FND_MSG_PUB.Count_And_Get(
2282: p_encoded => FND_API.G_FALSE,
2283: p_count => x_msg_count,
2284: p_data => x_msg_data );
2285:

Line 2307: FND_MSG_PUB.Count_And_Get(

2303: WHEN FND_API.G_EXC_ERROR THEN
2304: ROLLBACK TO create_customer_profile;
2305: x_return_status := FND_API.G_RET_STS_ERROR;
2306:
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 2331: FND_MSG_PUB.Count_And_Get(

2327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2328: ROLLBACK TO create_customer_profile;
2329: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2330:
2331: FND_MSG_PUB.Count_And_Get(
2332: p_encoded => FND_API.G_FALSE,
2333: p_count => x_msg_count,
2334: p_data => x_msg_data );
2335:

Line 2357: FND_MSG_PUB.ADD;

2353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2354:
2355: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2356: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2357: FND_MSG_PUB.ADD;
2358:
2359: FND_MSG_PUB.Count_And_Get(
2360: p_encoded => FND_API.G_FALSE,
2361: p_count => x_msg_count,

Line 2359: FND_MSG_PUB.Count_And_Get(

2355: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2356: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2357: FND_MSG_PUB.ADD;
2358:
2359: FND_MSG_PUB.Count_And_Get(
2360: p_encoded => FND_API.G_FALSE,
2361: p_count => x_msg_count,
2362: p_data => x_msg_data );
2363:

Line 2445: FND_MSG_PUB.initialize;

2441: END IF;
2442:
2443: -- Initialize message list if p_init_msg_list is set to TRUE.
2444: IF FND_API.to_Boolean(p_init_msg_list) THEN
2445: FND_MSG_PUB.initialize;
2446: END IF;
2447:
2448: -- Initialize API return status to success.
2449: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2486: FND_MSG_PUB.Count_And_Get(

2482: END IF;
2483: END IF;
2484:
2485: -- Standard call to get message count and if count is 1, get message info.
2486: FND_MSG_PUB.Count_And_Get(
2487: p_encoded => FND_API.G_FALSE,
2488: p_count => x_msg_count,
2489: p_data => x_msg_data );
2490:

Line 2511: FND_MSG_PUB.Count_And_Get(

2507: WHEN FND_API.G_EXC_ERROR THEN
2508: ROLLBACK TO update_customer_profile;
2509: x_return_status := FND_API.G_RET_STS_ERROR;
2510:
2511: FND_MSG_PUB.Count_And_Get(
2512: p_encoded => FND_API.G_FALSE,
2513: p_count => x_msg_count,
2514: p_data => x_msg_data );
2515:

Line 2535: FND_MSG_PUB.Count_And_Get(

2531: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2532: ROLLBACK TO update_customer_profile;
2533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2534:
2535: FND_MSG_PUB.Count_And_Get(
2536: p_encoded => FND_API.G_FALSE,
2537: p_count => x_msg_count,
2538: p_data => x_msg_data );
2539:

Line 2561: FND_MSG_PUB.ADD;

2557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2558:
2559: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2560: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2561: FND_MSG_PUB.ADD;
2562:
2563: FND_MSG_PUB.Count_And_Get(
2564: p_encoded => FND_API.G_FALSE,
2565: p_count => x_msg_count,

Line 2563: FND_MSG_PUB.Count_And_Get(

2559: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2560: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2561: FND_MSG_PUB.ADD;
2562:
2563: FND_MSG_PUB.Count_And_Get(
2564: p_encoded => FND_API.G_FALSE,
2565: p_count => x_msg_count,
2566: p_data => x_msg_data );
2567:

Line 2640: FND_MSG_PUB.initialize;

2636: END IF;
2637:
2638: -- Initialize message list if p_init_msg_list is set to TRUE.
2639: IF FND_API.to_Boolean(p_init_msg_list) THEN
2640: FND_MSG_PUB.initialize;
2641: END IF;
2642:
2643: -- Initialize API return status to success.
2644: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2651: FND_MSG_PUB.ADD;

2647: IF p_cust_account_profile_id IS NULL OR
2648: p_cust_account_profile_id = FND_API.G_MISS_NUM THEN
2649: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2650: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_account_profile_id' );
2651: FND_MSG_PUB.ADD;
2652: RAISE FND_API.G_EXC_ERROR;
2653: END IF;
2654:
2655: x_customer_profile_rec.cust_account_profile_id := p_cust_account_profile_id;

Line 2785: FND_MSG_PUB.Count_And_Get(

2781: p_msg_level=>fnd_log.level_procedure);
2782: END IF;
2783:
2784: -- Standard call to get message count and if count is 1, get message info.
2785: FND_MSG_PUB.Count_And_Get(
2786: p_encoded => FND_API.G_FALSE,
2787: p_count => x_msg_count,
2788: p_data => x_msg_data );
2789:

Line 2810: FND_MSG_PUB.Count_And_Get(

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

Line 2834: FND_MSG_PUB.Count_And_Get(

2830:
2831: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2833:
2834: FND_MSG_PUB.Count_And_Get(
2835: p_encoded => FND_API.G_FALSE,
2836: p_count => x_msg_count,
2837: p_data => x_msg_data );
2838:

Line 2860: FND_MSG_PUB.ADD;

2856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2857:
2858: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2859: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2860: FND_MSG_PUB.ADD;
2861:
2862: FND_MSG_PUB.Count_And_Get(
2863: p_encoded => FND_API.G_FALSE,
2864: p_count => x_msg_count,

Line 2862: FND_MSG_PUB.Count_And_Get(

2858: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2859: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2860: FND_MSG_PUB.ADD;
2861:
2862: FND_MSG_PUB.Count_And_Get(
2863: p_encoded => FND_API.G_FALSE,
2864: p_count => x_msg_count,
2865: p_data => x_msg_data );
2866:

Line 2952: FND_MSG_PUB.initialize;

2948: END IF;
2949:
2950: -- Initialize message list if p_init_msg_list is set to TRUE.
2951: IF FND_API.to_Boolean(p_init_msg_list) THEN
2952: FND_MSG_PUB.initialize;
2953: END IF;
2954:
2955: -- Initialize API return status to success.
2956: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2980: FND_MSG_PUB.Count_And_Get(

2976: END IF;
2977: END IF;
2978:
2979: -- Standard call to get message count and if count is 1, get message info.
2980: FND_MSG_PUB.Count_And_Get(
2981: p_encoded => FND_API.G_FALSE,
2982: p_count => x_msg_count,
2983: p_data => x_msg_data );
2984:

Line 3006: FND_MSG_PUB.Count_And_Get(

3002: WHEN FND_API.G_EXC_ERROR THEN
3003: ROLLBACK TO create_cust_profile_amt;
3004: x_return_status := FND_API.G_RET_STS_ERROR;
3005:
3006: FND_MSG_PUB.Count_And_Get(
3007: p_encoded => FND_API.G_FALSE,
3008: p_count => x_msg_count,
3009: p_data => x_msg_data );
3010:

Line 3031: FND_MSG_PUB.Count_And_Get(

3027: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3028: ROLLBACK TO create_cust_profile_amt;
3029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3030:
3031: FND_MSG_PUB.Count_And_Get(
3032: p_encoded => FND_API.G_FALSE,
3033: p_count => x_msg_count,
3034: p_data => x_msg_data );
3035:

Line 3058: FND_MSG_PUB.ADD;

3054: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3055:
3056: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3057: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3058: FND_MSG_PUB.ADD;
3059:
3060: FND_MSG_PUB.Count_And_Get(
3061: p_encoded => FND_API.G_FALSE,
3062: p_count => x_msg_count,

Line 3060: FND_MSG_PUB.Count_And_Get(

3056: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3057: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3058: FND_MSG_PUB.ADD;
3059:
3060: FND_MSG_PUB.Count_And_Get(
3061: p_encoded => FND_API.G_FALSE,
3062: p_count => x_msg_count,
3063: p_data => x_msg_data );
3064:

Line 3146: FND_MSG_PUB.initialize;

3142: END IF;
3143:
3144: -- Initialize message list if p_init_msg_list is set to TRUE.
3145: IF FND_API.to_Boolean(p_init_msg_list) THEN
3146: FND_MSG_PUB.initialize;
3147: END IF;
3148:
3149: -- Initialize API return status to success.
3150: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3187: FND_MSG_PUB.Count_And_Get(

3183: END IF;
3184: END IF;
3185:
3186: -- Standard call to get message count and if count is 1, get message info.
3187: FND_MSG_PUB.Count_And_Get(
3188: p_encoded => FND_API.G_FALSE,
3189: p_count => x_msg_count,
3190: p_data => x_msg_data );
3191:

Line 3214: FND_MSG_PUB.Count_And_Get(

3210: WHEN FND_API.G_EXC_ERROR THEN
3211: ROLLBACK TO update_cust_profile_amt;
3212: x_return_status := FND_API.G_RET_STS_ERROR;
3213:
3214: FND_MSG_PUB.Count_And_Get(
3215: p_encoded => FND_API.G_FALSE,
3216: p_count => x_msg_count,
3217: p_data => x_msg_data );
3218:

Line 3239: FND_MSG_PUB.Count_And_Get(

3235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3236: ROLLBACK TO update_cust_profile_amt;
3237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3238:
3239: FND_MSG_PUB.Count_And_Get(
3240: p_encoded => FND_API.G_FALSE,
3241: p_count => x_msg_count,
3242: p_data => x_msg_data );
3243:

Line 3266: FND_MSG_PUB.ADD;

3262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3263:
3264: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3265: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3266: FND_MSG_PUB.ADD;
3267:
3268: FND_MSG_PUB.Count_And_Get(
3269: p_encoded => FND_API.G_FALSE,
3270: p_count => x_msg_count,

Line 3268: FND_MSG_PUB.Count_And_Get(

3264: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3265: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3266: FND_MSG_PUB.ADD;
3267:
3268: FND_MSG_PUB.Count_And_Get(
3269: p_encoded => FND_API.G_FALSE,
3270: p_count => x_msg_count,
3271: p_data => x_msg_data );
3272:

Line 3346: FND_MSG_PUB.initialize;

3342: END IF;
3343:
3344: -- Initialize message list if p_init_msg_list is set to TRUE.
3345: IF FND_API.to_Boolean(p_init_msg_list) THEN
3346: FND_MSG_PUB.initialize;
3347: END IF;
3348:
3349: -- Initialize API return status to success.
3350: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3357: FND_MSG_PUB.ADD;

3353: IF p_cust_acct_profile_amt_id IS NULL OR
3354: p_cust_acct_profile_amt_id = FND_API.G_MISS_NUM THEN
3355: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3356: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_acct_profile_amt_id' );
3357: FND_MSG_PUB.ADD;
3358: RAISE FND_API.G_EXC_ERROR;
3359: END IF;
3360:
3361: x_cust_profile_amt_rec.cust_acct_profile_amt_id := p_cust_acct_profile_amt_id;

Line 3466: FND_MSG_PUB.Count_And_Get(

3462: p_msg_level=>fnd_log.level_procedure);
3463: END IF;
3464:
3465: -- Standard call to get message count and if count is 1, get message info.
3466: FND_MSG_PUB.Count_And_Get(
3467: p_encoded => FND_API.G_FALSE,
3468: p_count => x_msg_count,
3469: p_data => x_msg_data );
3470:

Line 3491: FND_MSG_PUB.Count_And_Get(

3487: EXCEPTION
3488: WHEN FND_API.G_EXC_ERROR THEN
3489: x_return_status := FND_API.G_RET_STS_ERROR;
3490:
3491: FND_MSG_PUB.Count_And_Get(
3492: p_encoded => FND_API.G_FALSE,
3493: p_count => x_msg_count,
3494: p_data => x_msg_data );
3495:

Line 3515: FND_MSG_PUB.Count_And_Get(

3511:
3512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3514:
3515: FND_MSG_PUB.Count_And_Get(
3516: p_encoded => FND_API.G_FALSE,
3517: p_count => x_msg_count,
3518: p_data => x_msg_data );
3519:

Line 3541: FND_MSG_PUB.ADD;

3537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3538:
3539: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3540: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3541: FND_MSG_PUB.ADD;
3542:
3543: FND_MSG_PUB.Count_And_Get(
3544: p_encoded => FND_API.G_FALSE,
3545: p_count => x_msg_count,

Line 3543: FND_MSG_PUB.Count_And_Get(

3539: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3540: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3541: FND_MSG_PUB.ADD;
3542:
3543: FND_MSG_PUB.Count_And_Get(
3544: p_encoded => FND_API.G_FALSE,
3545: p_count => x_msg_count,
3546: p_data => x_msg_data );
3547: