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_MESSAGE

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

248: AND application_id = 222
249: AND rownum =1;
250: EXCEPTION
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;

Line 253: FND_MESSAGE.SET_TOKEN('RECORD', 'Release Name');

249: AND rownum =1;
250: EXCEPTION
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;

Line 254: FND_MESSAGE.SET_TOKEN('VALUE', 'HZ_INACTIVATE_ACCOUNT_SITE_UI');

250: EXCEPTION
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;

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

267:
268: --p_object_version_number := NVL( l_object_version_number, 1 ) + 1;
269: EXCEPTION
270: WHEN NO_DATA_FOUND THEN
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;

Line 272: FND_MESSAGE.SET_TOKEN( 'RECORD', 'party site' );

268: --p_object_version_number := NVL( l_object_version_number, 1 ) + 1;
269: EXCEPTION
270: WHEN NO_DATA_FOUND THEN
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;

Line 273: FND_MESSAGE.SET_TOKEN( 'VALUE',

269: EXCEPTION
270: WHEN NO_DATA_FOUND THEN
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;

Line 281: FND_MESSAGE.SET_NAME( 'AR', 'HZ_ACCT_SITE_INHERIT_STATUS' );

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

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

678: ( p_object_version_number IS NOT NULL AND
679: l_object_version_number IS NOT NULL AND
680: p_object_version_number = l_object_version_number ) )
681: THEN
682: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
683: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_acct_sites' );
684: FND_MSG_PUB.ADD;
685: RAISE FND_API.G_EXC_ERROR;
686: END IF;

Line 683: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_acct_sites' );

679: l_object_version_number IS NOT NULL AND
680: p_object_version_number = l_object_version_number ) )
681: THEN
682: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
683: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_acct_sites' );
684: FND_MSG_PUB.ADD;
685: RAISE FND_API.G_EXC_ERROR;
686: END IF;
687:

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

688: p_object_version_number := NVL( l_object_version_number, 1 ) + 1;
689:
690: EXCEPTION
691: WHEN NO_DATA_FOUND THEN
692: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
693: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer account site' );
694: FND_MESSAGE.SET_TOKEN( 'VALUE',
695: NVL( TO_CHAR( p_cust_acct_site_rec.cust_acct_site_id ), 'null' ) );
696: FND_MSG_PUB.ADD;

Line 693: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer account site' );

689:
690: EXCEPTION
691: WHEN NO_DATA_FOUND THEN
692: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
693: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer account site' );
694: FND_MESSAGE.SET_TOKEN( 'VALUE',
695: NVL( TO_CHAR( p_cust_acct_site_rec.cust_acct_site_id ), 'null' ) );
696: FND_MSG_PUB.ADD;
697: RAISE FND_API.G_EXC_ERROR;

Line 694: FND_MESSAGE.SET_TOKEN( 'VALUE',

690: EXCEPTION
691: WHEN NO_DATA_FOUND THEN
692: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
693: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer account site' );
694: FND_MESSAGE.SET_TOKEN( 'VALUE',
695: NVL( TO_CHAR( p_cust_acct_site_rec.cust_acct_site_id ), 'null' ) );
696: FND_MSG_PUB.ADD;
697: RAISE FND_API.G_EXC_ERROR;
698: END;

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

734: AND application_id = 222
735: AND rownum =1;
736: EXCEPTION
737: WHEN NO_DATA_FOUND THEN
738: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
739: FND_MESSAGE.SET_TOKEN('RECORD', 'Message Name');
740: FND_MESSAGE.SET_TOKEN('VALUE', 'HZ_INACTIVATE_ACCOUNT_SITE_UI');
741: FND_MSG_PUB.ADD;
742: RAISE FND_API.G_EXC_ERROR;

Line 739: FND_MESSAGE.SET_TOKEN('RECORD', 'Message Name');

735: AND rownum =1;
736: EXCEPTION
737: WHEN NO_DATA_FOUND THEN
738: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
739: FND_MESSAGE.SET_TOKEN('RECORD', 'Message Name');
740: FND_MESSAGE.SET_TOKEN('VALUE', 'HZ_INACTIVATE_ACCOUNT_SITE_UI');
741: FND_MSG_PUB.ADD;
742: RAISE FND_API.G_EXC_ERROR;
743: END;

Line 740: FND_MESSAGE.SET_TOKEN('VALUE', 'HZ_INACTIVATE_ACCOUNT_SITE_UI');

736: EXCEPTION
737: WHEN NO_DATA_FOUND THEN
738: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
739: FND_MESSAGE.SET_TOKEN('RECORD', 'Message Name');
740: FND_MESSAGE.SET_TOKEN('VALUE', 'HZ_INACTIVATE_ACCOUNT_SITE_UI');
741: FND_MSG_PUB.ADD;
742: RAISE FND_API.G_EXC_ERROR;
743: END;
744: END IF;

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

753:
754: --p_object_version_number := NVL( l_object_version_number, 1 ) + 1;
755: EXCEPTION
756: WHEN NO_DATA_FOUND THEN
757: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
758: FND_MESSAGE.SET_TOKEN( 'RECORD', 'party site' );
759: FND_MESSAGE.SET_TOKEN( 'VALUE',
760: NVL( TO_CHAR( p_cust_acct_site_rec.party_site_id ), 'null' ) );
761: FND_MSG_PUB.ADD;

Line 758: FND_MESSAGE.SET_TOKEN( 'RECORD', 'party site' );

754: --p_object_version_number := NVL( l_object_version_number, 1 ) + 1;
755: EXCEPTION
756: WHEN NO_DATA_FOUND THEN
757: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
758: FND_MESSAGE.SET_TOKEN( 'RECORD', 'party site' );
759: FND_MESSAGE.SET_TOKEN( 'VALUE',
760: NVL( TO_CHAR( p_cust_acct_site_rec.party_site_id ), 'null' ) );
761: FND_MSG_PUB.ADD;
762: RAISE FND_API.G_EXC_ERROR;

Line 759: FND_MESSAGE.SET_TOKEN( 'VALUE',

755: EXCEPTION
756: WHEN NO_DATA_FOUND THEN
757: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
758: FND_MESSAGE.SET_TOKEN( 'RECORD', 'party site' );
759: FND_MESSAGE.SET_TOKEN( 'VALUE',
760: NVL( TO_CHAR( p_cust_acct_site_rec.party_site_id ), 'null' ) );
761: FND_MSG_PUB.ADD;
762: RAISE FND_API.G_EXC_ERROR;
763: END;

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

985: WHERE cust_acct_site_id
986: = p_cust_site_use_rec.cust_acct_site_id;
987: EXCEPTION
988: WHEN NO_DATA_FOUND THEN
989: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
990: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer account site' );
991: FND_MESSAGE.SET_TOKEN( 'VALUE',
992: NVL( TO_CHAR(
993: p_cust_site_use_rec.cust_acct_site_id ), 'null' ) );

Line 990: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer account site' );

986: = p_cust_site_use_rec.cust_acct_site_id;
987: EXCEPTION
988: WHEN NO_DATA_FOUND THEN
989: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
990: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer account site' );
991: FND_MESSAGE.SET_TOKEN( 'VALUE',
992: NVL( TO_CHAR(
993: p_cust_site_use_rec.cust_acct_site_id ), 'null' ) );
994: FND_MSG_PUB.ADD;

Line 991: FND_MESSAGE.SET_TOKEN( 'VALUE',

987: EXCEPTION
988: WHEN NO_DATA_FOUND THEN
989: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
990: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer account site' );
991: FND_MESSAGE.SET_TOKEN( 'VALUE',
992: NVL( TO_CHAR(
993: p_cust_site_use_rec.cust_acct_site_id ), 'null' ) );
994: FND_MSG_PUB.ADD;
995: RAISE FND_API.G_EXC_ERROR;

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

1458: ( p_object_version_number IS NOT NULL AND
1459: l_object_version_number IS NOT NULL AND
1460: p_object_version_number = l_object_version_number ) )
1461: THEN
1462: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
1463: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_site_uses' );
1464: FND_MSG_PUB.ADD;
1465: RAISE FND_API.G_EXC_ERROR;
1466: END IF;

Line 1463: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_site_uses' );

1459: l_object_version_number IS NOT NULL AND
1460: p_object_version_number = l_object_version_number ) )
1461: THEN
1462: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
1463: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_site_uses' );
1464: FND_MSG_PUB.ADD;
1465: RAISE FND_API.G_EXC_ERROR;
1466: END IF;
1467:

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

1468: p_object_version_number := NVL( l_object_version_number, 1 ) + 1;
1469:
1470: EXCEPTION
1471: WHEN NO_DATA_FOUND THEN
1472: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
1473: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer site use' );
1474: FND_MESSAGE.SET_TOKEN( 'VALUE',
1475: NVL( TO_CHAR( p_cust_site_use_rec.site_use_id ), 'null' ) );
1476: FND_MSG_PUB.ADD;

Line 1473: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer site use' );

1469:
1470: EXCEPTION
1471: WHEN NO_DATA_FOUND THEN
1472: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
1473: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer site use' );
1474: FND_MESSAGE.SET_TOKEN( 'VALUE',
1475: NVL( TO_CHAR( p_cust_site_use_rec.site_use_id ), 'null' ) );
1476: FND_MSG_PUB.ADD;
1477: RAISE FND_API.G_EXC_ERROR;

Line 1474: FND_MESSAGE.SET_TOKEN( 'VALUE',

1470: EXCEPTION
1471: WHEN NO_DATA_FOUND THEN
1472: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
1473: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer site use' );
1474: FND_MESSAGE.SET_TOKEN( 'VALUE',
1475: NVL( TO_CHAR( p_cust_site_use_rec.site_use_id ), 'null' ) );
1476: FND_MSG_PUB.ADD;
1477: RAISE FND_API.G_EXC_ERROR;
1478: END;

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

2140: WHEN OTHERS THEN
2141: ROLLBACK TO create_cust_acct_site;
2142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2143:
2144: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2145: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2146: FND_MSG_PUB.ADD;
2147:
2148: FND_MSG_PUB.Count_And_Get(

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

2141: ROLLBACK TO create_cust_acct_site;
2142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2143:
2144: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2145: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2146: FND_MSG_PUB.ADD;
2147:
2148: FND_MSG_PUB.Count_And_Get(
2149: p_encoded => FND_API.G_FALSE,

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

2379: WHEN OTHERS THEN
2380: ROLLBACK TO update_cust_acct_site;
2381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2382:
2383: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2384: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2385: FND_MSG_PUB.ADD;
2386:
2387: FND_MSG_PUB.Count_And_Get(

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

2380: ROLLBACK TO update_cust_acct_site;
2381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2382:
2383: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2384: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2385: FND_MSG_PUB.ADD;
2386:
2387: FND_MSG_PUB.Count_And_Get(
2388: p_encoded => FND_API.G_FALSE,

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

2470:
2471: -- Check whether primary key has been passed in.
2472: IF p_cust_acct_site_id IS NULL OR
2473: p_cust_acct_site_id = FND_API.G_MISS_NUM THEN
2474: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2475: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_acct_site_id' );
2476: FND_MSG_PUB.ADD;
2477: RAISE FND_API.G_EXC_ERROR;
2478: END IF;

Line 2475: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_acct_site_id' );

2471: -- Check whether primary key has been passed in.
2472: IF p_cust_acct_site_id IS NULL OR
2473: p_cust_acct_site_id = FND_API.G_MISS_NUM THEN
2474: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2475: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_acct_site_id' );
2476: FND_MSG_PUB.ADD;
2477: RAISE FND_API.G_EXC_ERROR;
2478: END IF;
2479:

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

2630:
2631: WHEN OTHERS THEN
2632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2633:
2634: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2635: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2636: FND_MSG_PUB.ADD;
2637:
2638: FND_MSG_PUB.Count_And_Get(

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

2631: WHEN OTHERS THEN
2632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2633:
2634: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2635: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2636: FND_MSG_PUB.ADD;
2637:
2638: FND_MSG_PUB.Count_And_Get(
2639: p_encoded => FND_API.G_FALSE,

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

2838: WHEN OTHERS THEN
2839: ROLLBACK TO create_cust_site_use;
2840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2841:
2842: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2843: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2844: FND_MSG_PUB.ADD;
2845:
2846: FND_MSG_PUB.Count_And_Get(

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

2839: ROLLBACK TO create_cust_site_use;
2840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2841:
2842: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2843: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2844: FND_MSG_PUB.ADD;
2845:
2846: FND_MSG_PUB.Count_And_Get(
2847: p_encoded => FND_API.G_FALSE,

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

3063: WHEN OTHERS THEN
3064: ROLLBACK TO update_cust_site_use;
3065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3066:
3067: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3068: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3069: FND_MSG_PUB.ADD;
3070:
3071: FND_MSG_PUB.Count_And_Get(

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

3064: ROLLBACK TO update_cust_site_use;
3065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3066:
3067: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3068: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3069: FND_MSG_PUB.ADD;
3070:
3071: FND_MSG_PUB.Count_And_Get(
3072: p_encoded => FND_API.G_FALSE,

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

3159:
3160: -- Check whether primary key has been passed in.
3161: IF p_site_use_id IS NULL OR
3162: p_site_use_id = FND_API.G_MISS_NUM THEN
3163: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3164: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'site_use_id' );
3165: FND_MSG_PUB.ADD;
3166: RAISE FND_API.G_EXC_ERROR;
3167: END IF;

Line 3164: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'site_use_id' );

3160: -- Check whether primary key has been passed in.
3161: IF p_site_use_id IS NULL OR
3162: p_site_use_id = FND_API.G_MISS_NUM THEN
3163: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3164: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'site_use_id' );
3165: FND_MSG_PUB.ADD;
3166: RAISE FND_API.G_EXC_ERROR;
3167: END IF;
3168:

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

3385:
3386: WHEN OTHERS THEN
3387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3388:
3389: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3390: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3391: FND_MSG_PUB.ADD;
3392:
3393: FND_MSG_PUB.Count_And_Get(

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

3386: WHEN OTHERS THEN
3387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3388:
3389: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3390: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3391: FND_MSG_PUB.ADD;
3392:
3393: FND_MSG_PUB.Count_And_Get(
3394: p_encoded => FND_API.G_FALSE,

Line 3447: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');

3443: (p_create_update_flag = 'U' AND
3444: p_account_site_rec.language IS NOT NULL AND
3445: p_account_site_rec.language <> p_old_account_site_rec.language)
3446: THEN
3447: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
3448: FND_MESSAGE.SET_TOKEN('COLUMN', 'language');
3449: FND_MSG_PUB.ADD;
3450: x_return_status := FND_API.G_RET_STS_ERROR;
3451: END IF;

Line 3448: FND_MESSAGE.SET_TOKEN('COLUMN', 'language');

3444: p_account_site_rec.language IS NOT NULL AND
3445: p_account_site_rec.language <> p_old_account_site_rec.language)
3446: THEN
3447: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
3448: FND_MESSAGE.SET_TOKEN('COLUMN', 'language');
3449: FND_MSG_PUB.ADD;
3450: x_return_status := FND_API.G_RET_STS_ERROR;
3451: END IF;
3452: