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 458: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );

454: WHERE PROFILE_CLASS_ID = p_customer_profile_rec.profile_class_id;
455:
456: EXCEPTION
457: WHEN NO_DATA_FOUND THEN
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;

Line 459: FND_MESSAGE.SET_TOKEN( 'RECORD', 'Customer Profile Class' );

455:
456: EXCEPTION
457: WHEN NO_DATA_FOUND THEN
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;

Line 460: FND_MESSAGE.SET_TOKEN( 'VALUE',

456: EXCEPTION
457: WHEN NO_DATA_FOUND THEN
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;

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

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

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

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

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

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

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

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

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

1080: p_object_version_number := NVL( l_object_version_number, 1 ) + 1;
1081:
1082: EXCEPTION
1083: WHEN NO_DATA_FOUND THEN
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;

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

1081:
1082: EXCEPTION
1083: WHEN NO_DATA_FOUND THEN
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;

Line 1086: FND_MESSAGE.SET_TOKEN( 'VALUE',

1082: EXCEPTION
1083: WHEN NO_DATA_FOUND THEN
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;

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

1130: end if;
1131: END IF;
1132: EXCEPTION
1133: WHEN NO_DATA_FOUND THEN
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;

Line 1135: FND_MESSAGE.SET_TOKEN( 'RECORD', 'Customer Profile Class' );

1131: END IF;
1132: EXCEPTION
1133: WHEN NO_DATA_FOUND THEN
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;

Line 1136: FND_MESSAGE.SET_TOKEN( 'VALUE',

1132: EXCEPTION
1133: WHEN NO_DATA_FOUND THEN
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;

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

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

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

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

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

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

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

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

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

2000: p_object_version_number := NVL( l_object_version_number, 1 ) + 1;
2001:
2002: EXCEPTION
2003: WHEN NO_DATA_FOUND THEN
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;

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

2001:
2002: EXCEPTION
2003: WHEN NO_DATA_FOUND THEN
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;

Line 2006: FND_MESSAGE.SET_TOKEN( 'VALUE',

2002: EXCEPTION
2003: WHEN NO_DATA_FOUND THEN
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;

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

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

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

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

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

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

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

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

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

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

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

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

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

2918:
2919: WHEN OTHERS THEN
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(

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3599:
3600: WHEN OTHERS THEN
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(

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

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