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_MESSAGE

Line 359: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INACTIVE_PROFILE_CLASS' );

355: FROM HZ_CUST_PROFILE_CLASSES
356: WHERE PROFILE_CLASS_ID = l_default_profile_class_id; -- Bug 3767719.
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;

Line 360: FND_MESSAGE.SET_TOKEN( 'NAME', l_profile_class_name );

356: WHERE PROFILE_CLASS_ID = l_default_profile_class_id; -- Bug 3767719.
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:

Line 370: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_DEFAULT_PROF_CLASS' );

366: p_customer_profile_rec.profile_class_id := 0;
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;

Line 407: FND_MESSAGE.SET_NAME('AR','HZ_API_CF_ASS_PTY_OR_ACCT');

403:
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');

Line 413: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_A_PTY_ASS_ACCT');

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
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;

Line 414: FND_MESSAGE.SET_TOKEN('ACCT_ID',p_customer_profile_rec.cust_account_id);

410: ELSE
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;

Line 424: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_A_PTY');

420:
421: ELSE
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;

Line 425: FND_MESSAGE.SET_TOKEN( 'PARTY_ID', p_customer_profile_rec.party_id);

421: ELSE
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:

Line 438: FND_MESSAGE.SET_NAME('AR','HZ_API_ACCT_NOT_ASS_PTY');

434: ELSE
435: IF party_id_value(p_customer_profile_rec.cust_account_id, 'A')
436: <> p_customer_profile_rec.party_id
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;

Line 439: FND_MESSAGE.SET_TOKEN( 'ACCT_ID', p_customer_profile_rec.cust_account_id );

435: IF party_id_value(p_customer_profile_rec.cust_account_id, 'A')
436: <> p_customer_profile_rec.party_id
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;

Line 440: FND_MESSAGE.SET_TOKEN( 'PARTY_ID', p_customer_profile_rec.party_id);

436: <> p_customer_profile_rec.party_id
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;

Line 476: FND_MESSAGE.SET_NAME('AR', 'HZ_API_SITE_BILL_LVL_NULL');

472: -- if cons_inv_type is NULL , it should get defaulted from account use profile.
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: */

Line 484: FND_MESSAGE.SET_NAME('AR', 'HZ_API_ENABLE_ACC_BAL_FWD_BILL');

480: */
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;

Line 1040: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );

1036: ( p_object_version_number IS NOT NULL AND
1037: l_object_version_number IS NOT NULL AND
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;

Line 1041: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_customer_profiles' );

1037: l_object_version_number IS NOT NULL AND
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:

Line 1050: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );

1046: p_object_version_number := NVL( l_object_version_number, 1 ) + 1;
1047:
1048: EXCEPTION
1049: WHEN NO_DATA_FOUND THEN
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;

Line 1051: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer profile' );

1047:
1048: EXCEPTION
1049: WHEN NO_DATA_FOUND THEN
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;

Line 1052: FND_MESSAGE.SET_TOKEN( 'VALUE',

1048: EXCEPTION
1049: WHEN NO_DATA_FOUND THEN
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;

Line 1115: FND_MESSAGE.SET_NAME('AR', 'HZ_API_SITE_BILL_LVL_NULL');

1111: /*
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: */

Line 1131: FND_MESSAGE.SET_NAME('AR', 'HZ_API_ENABLE_ACC_BAL_FWD_BILL');

1127: -- and it should get defaulted from account use profile.
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;

Line 1931: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );

1927: ( p_object_version_number IS NOT NULL AND
1928: l_object_version_number IS NOT NULL AND
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;

Line 1932: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_profile_amts' );

1928: l_object_version_number IS NOT NULL AND
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:

Line 1941: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );

1937: p_object_version_number := NVL( l_object_version_number, 1 ) + 1;
1938:
1939: EXCEPTION
1940: WHEN NO_DATA_FOUND THEN
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;

Line 1942: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer account profile amount' );

1938:
1939: EXCEPTION
1940: WHEN NO_DATA_FOUND THEN
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;

Line 1943: FND_MESSAGE.SET_TOKEN( 'VALUE',

1939: EXCEPTION
1940: WHEN NO_DATA_FOUND THEN
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;

Line 2355: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );

2351: WHEN OTHERS THEN
2352: ROLLBACK TO create_customer_profile;
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(

Line 2356: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );

2352: ROLLBACK TO create_customer_profile;
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,

Line 2559: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );

2555: WHEN OTHERS THEN
2556: ROLLBACK TO update_customer_profile;
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(

Line 2560: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );

2556: ROLLBACK TO update_customer_profile;
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,

Line 2649: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

2645:
2646: -- Check whether primary key has been passed in.
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;

Line 2650: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_account_profile_id' );

2646: -- Check whether primary key has been passed in.
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:

Line 2858: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );

2854:
2855: WHEN OTHERS THEN
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(

Line 2859: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );

2855: WHEN OTHERS THEN
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,

Line 3056: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );

3052: WHEN OTHERS THEN
3053: ROLLBACK TO create_cust_profile_amt;
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(

Line 3057: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );

3053: ROLLBACK TO create_cust_profile_amt;
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,

Line 3264: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );

3260: WHEN OTHERS THEN
3261: ROLLBACK TO update_cust_profile_amt;
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(

Line 3265: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );

3261: ROLLBACK TO update_cust_profile_amt;
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,

Line 3355: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

3351:
3352: -- Check whether primary key has been passed in.
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;

Line 3356: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_acct_profile_amt_id' );

3352: -- Check whether primary key has been passed in.
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:

Line 3539: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );

3535:
3536: WHEN OTHERS THEN
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(

Line 3540: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );

3536: WHEN OTHERS THEN
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,