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

757: ( p_object_version_number IS NOT NULL AND
758: l_object_version_number IS NOT NULL AND
759: p_object_version_number = l_object_version_number ) )
760: THEN
761: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
762: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_acct_sites' );
763: FND_MSG_PUB.ADD;
764: RAISE FND_API.G_EXC_ERROR;
765: END IF;

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

758: l_object_version_number IS NOT NULL AND
759: p_object_version_number = l_object_version_number ) )
760: THEN
761: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
762: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_acct_sites' );
763: FND_MSG_PUB.ADD;
764: RAISE FND_API.G_EXC_ERROR;
765: END IF;
766:

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

767: p_object_version_number := NVL( l_object_version_number, 1 ) + 1;
768:
769: EXCEPTION
770: WHEN NO_DATA_FOUND THEN
771: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
772: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer account site' );
773: FND_MESSAGE.SET_TOKEN( 'VALUE',
774: NVL( TO_CHAR( p_cust_acct_site_rec.cust_acct_site_id ), 'null' ) );
775: FND_MSG_PUB.ADD;

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

768:
769: EXCEPTION
770: WHEN NO_DATA_FOUND THEN
771: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
772: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer account site' );
773: FND_MESSAGE.SET_TOKEN( 'VALUE',
774: NVL( TO_CHAR( p_cust_acct_site_rec.cust_acct_site_id ), 'null' ) );
775: FND_MSG_PUB.ADD;
776: RAISE FND_API.G_EXC_ERROR;

Line 773: FND_MESSAGE.SET_TOKEN( 'VALUE',

769: EXCEPTION
770: WHEN NO_DATA_FOUND THEN
771: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
772: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer account site' );
773: FND_MESSAGE.SET_TOKEN( 'VALUE',
774: NVL( TO_CHAR( p_cust_acct_site_rec.cust_acct_site_id ), 'null' ) );
775: FND_MSG_PUB.ADD;
776: RAISE FND_API.G_EXC_ERROR;
777: END;

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

813: AND application_id = 222
814: AND rownum =1;
815: EXCEPTION
816: WHEN NO_DATA_FOUND THEN
817: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
818: FND_MESSAGE.SET_TOKEN('RECORD', 'Message Name');
819: FND_MESSAGE.SET_TOKEN('VALUE', 'HZ_INACTIVATE_ACCOUNT_SITE_UI');
820: FND_MSG_PUB.ADD;
821: RAISE FND_API.G_EXC_ERROR;

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

814: AND rownum =1;
815: EXCEPTION
816: WHEN NO_DATA_FOUND THEN
817: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
818: FND_MESSAGE.SET_TOKEN('RECORD', 'Message Name');
819: FND_MESSAGE.SET_TOKEN('VALUE', 'HZ_INACTIVATE_ACCOUNT_SITE_UI');
820: FND_MSG_PUB.ADD;
821: RAISE FND_API.G_EXC_ERROR;
822: END;

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

815: EXCEPTION
816: WHEN NO_DATA_FOUND THEN
817: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
818: FND_MESSAGE.SET_TOKEN('RECORD', 'Message Name');
819: FND_MESSAGE.SET_TOKEN('VALUE', 'HZ_INACTIVATE_ACCOUNT_SITE_UI');
820: FND_MSG_PUB.ADD;
821: RAISE FND_API.G_EXC_ERROR;
822: END;
823: END IF;

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

832:
833: --p_object_version_number := NVL( l_object_version_number, 1 ) + 1;
834: EXCEPTION
835: WHEN NO_DATA_FOUND THEN
836: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
837: FND_MESSAGE.SET_TOKEN( 'RECORD', 'party site' );
838: FND_MESSAGE.SET_TOKEN( 'VALUE',
839: NVL( TO_CHAR( p_cust_acct_site_rec.party_site_id ), 'null' ) );
840: FND_MSG_PUB.ADD;

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

833: --p_object_version_number := NVL( l_object_version_number, 1 ) + 1;
834: EXCEPTION
835: WHEN NO_DATA_FOUND THEN
836: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
837: FND_MESSAGE.SET_TOKEN( 'RECORD', 'party site' );
838: FND_MESSAGE.SET_TOKEN( 'VALUE',
839: NVL( TO_CHAR( p_cust_acct_site_rec.party_site_id ), 'null' ) );
840: FND_MSG_PUB.ADD;
841: RAISE FND_API.G_EXC_ERROR;

Line 838: FND_MESSAGE.SET_TOKEN( 'VALUE',

834: EXCEPTION
835: WHEN NO_DATA_FOUND THEN
836: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
837: FND_MESSAGE.SET_TOKEN( 'RECORD', 'party site' );
838: FND_MESSAGE.SET_TOKEN( 'VALUE',
839: NVL( TO_CHAR( p_cust_acct_site_rec.party_site_id ), 'null' ) );
840: FND_MSG_PUB.ADD;
841: RAISE FND_API.G_EXC_ERROR;
842: END;

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

1077: WHERE cust_acct_site_id
1078: = p_cust_site_use_rec.cust_acct_site_id;
1079: EXCEPTION
1080: WHEN NO_DATA_FOUND THEN
1081: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
1082: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer account site' );
1083: FND_MESSAGE.SET_TOKEN( 'VALUE',
1084: NVL( TO_CHAR(
1085: p_cust_site_use_rec.cust_acct_site_id ), 'null' ) );

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

1078: = p_cust_site_use_rec.cust_acct_site_id;
1079: EXCEPTION
1080: WHEN NO_DATA_FOUND THEN
1081: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
1082: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer account site' );
1083: FND_MESSAGE.SET_TOKEN( 'VALUE',
1084: NVL( TO_CHAR(
1085: p_cust_site_use_rec.cust_acct_site_id ), 'null' ) );
1086: FND_MSG_PUB.ADD;

Line 1083: FND_MESSAGE.SET_TOKEN( 'VALUE',

1079: EXCEPTION
1080: WHEN NO_DATA_FOUND THEN
1081: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
1082: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer account site' );
1083: FND_MESSAGE.SET_TOKEN( 'VALUE',
1084: NVL( TO_CHAR(
1085: p_cust_site_use_rec.cust_acct_site_id ), 'null' ) );
1086: FND_MSG_PUB.ADD;
1087: RAISE FND_API.G_EXC_ERROR;

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

1589: ( p_object_version_number IS NOT NULL AND
1590: l_object_version_number IS NOT NULL AND
1591: p_object_version_number = l_object_version_number ) )
1592: THEN
1593: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
1594: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_site_uses' );
1595: FND_MSG_PUB.ADD;
1596: RAISE FND_API.G_EXC_ERROR;
1597: END IF;

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

1590: l_object_version_number IS NOT NULL AND
1591: p_object_version_number = l_object_version_number ) )
1592: THEN
1593: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
1594: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_site_uses' );
1595: FND_MSG_PUB.ADD;
1596: RAISE FND_API.G_EXC_ERROR;
1597: END IF;
1598:

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

1599: p_object_version_number := NVL( l_object_version_number, 1 ) + 1;
1600:
1601: EXCEPTION
1602: WHEN NO_DATA_FOUND THEN
1603: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
1604: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer site use' );
1605: FND_MESSAGE.SET_TOKEN( 'VALUE',
1606: NVL( TO_CHAR( p_cust_site_use_rec.site_use_id ), 'null' ) );
1607: FND_MSG_PUB.ADD;

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

1600:
1601: EXCEPTION
1602: WHEN NO_DATA_FOUND THEN
1603: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
1604: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer site use' );
1605: FND_MESSAGE.SET_TOKEN( 'VALUE',
1606: NVL( TO_CHAR( p_cust_site_use_rec.site_use_id ), 'null' ) );
1607: FND_MSG_PUB.ADD;
1608: RAISE FND_API.G_EXC_ERROR;

Line 1605: FND_MESSAGE.SET_TOKEN( 'VALUE',

1601: EXCEPTION
1602: WHEN NO_DATA_FOUND THEN
1603: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
1604: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer site use' );
1605: FND_MESSAGE.SET_TOKEN( 'VALUE',
1606: NVL( TO_CHAR( p_cust_site_use_rec.site_use_id ), 'null' ) );
1607: FND_MSG_PUB.ADD;
1608: RAISE FND_API.G_EXC_ERROR;
1609: END;

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

2279: WHEN OTHERS THEN
2280: ROLLBACK TO create_cust_acct_site;
2281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2282:
2283: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2284: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2285: FND_MSG_PUB.ADD;
2286:
2287: FND_MSG_PUB.Count_And_Get(

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

2280: ROLLBACK TO create_cust_acct_site;
2281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2282:
2283: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2284: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2285: FND_MSG_PUB.ADD;
2286:
2287: FND_MSG_PUB.Count_And_Get(
2288: p_encoded => FND_API.G_FALSE,

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

2518: WHEN OTHERS THEN
2519: ROLLBACK TO update_cust_acct_site;
2520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2521:
2522: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2523: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2524: FND_MSG_PUB.ADD;
2525:
2526: FND_MSG_PUB.Count_And_Get(

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

2519: ROLLBACK TO update_cust_acct_site;
2520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2521:
2522: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2523: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2524: FND_MSG_PUB.ADD;
2525:
2526: FND_MSG_PUB.Count_And_Get(
2527: p_encoded => FND_API.G_FALSE,

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

2609:
2610: -- Check whether primary key has been passed in.
2611: IF p_cust_acct_site_id IS NULL OR
2612: p_cust_acct_site_id = FND_API.G_MISS_NUM THEN
2613: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2614: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_acct_site_id' );
2615: FND_MSG_PUB.ADD;
2616: RAISE FND_API.G_EXC_ERROR;
2617: END IF;

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

2610: -- Check whether primary key has been passed in.
2611: IF p_cust_acct_site_id IS NULL OR
2612: p_cust_acct_site_id = FND_API.G_MISS_NUM THEN
2613: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2614: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_acct_site_id' );
2615: FND_MSG_PUB.ADD;
2616: RAISE FND_API.G_EXC_ERROR;
2617: END IF;
2618:

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

2769:
2770: WHEN OTHERS THEN
2771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2772:
2773: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2774: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2775: FND_MSG_PUB.ADD;
2776:
2777: FND_MSG_PUB.Count_And_Get(

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

2770: WHEN OTHERS THEN
2771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2772:
2773: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2774: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2775: FND_MSG_PUB.ADD;
2776:
2777: FND_MSG_PUB.Count_And_Get(
2778: p_encoded => FND_API.G_FALSE,

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

2977: WHEN OTHERS THEN
2978: ROLLBACK TO create_cust_site_use;
2979: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2980:
2981: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2982: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2983: FND_MSG_PUB.ADD;
2984:
2985: FND_MSG_PUB.Count_And_Get(

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

2978: ROLLBACK TO create_cust_site_use;
2979: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2980:
2981: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2982: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2983: FND_MSG_PUB.ADD;
2984:
2985: FND_MSG_PUB.Count_And_Get(
2986: p_encoded => FND_API.G_FALSE,

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

3202: WHEN OTHERS THEN
3203: ROLLBACK TO update_cust_site_use;
3204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3205:
3206: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3207: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3208: FND_MSG_PUB.ADD;
3209:
3210: FND_MSG_PUB.Count_And_Get(

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

3203: ROLLBACK TO update_cust_site_use;
3204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3205:
3206: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3207: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3208: FND_MSG_PUB.ADD;
3209:
3210: FND_MSG_PUB.Count_And_Get(
3211: p_encoded => FND_API.G_FALSE,

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

3298:
3299: -- Check whether primary key has been passed in.
3300: IF p_site_use_id IS NULL OR
3301: p_site_use_id = FND_API.G_MISS_NUM THEN
3302: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3303: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'site_use_id' );
3304: FND_MSG_PUB.ADD;
3305: RAISE FND_API.G_EXC_ERROR;
3306: END IF;

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

3299: -- Check whether primary key has been passed in.
3300: IF p_site_use_id IS NULL OR
3301: p_site_use_id = FND_API.G_MISS_NUM THEN
3302: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3303: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'site_use_id' );
3304: FND_MSG_PUB.ADD;
3305: RAISE FND_API.G_EXC_ERROR;
3306: END IF;
3307:

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

3524:
3525: WHEN OTHERS THEN
3526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3527:
3528: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3529: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3530: FND_MSG_PUB.ADD;
3531:
3532: FND_MSG_PUB.Count_And_Get(

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

3525: WHEN OTHERS THEN
3526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3527:
3528: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3529: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3530: FND_MSG_PUB.ADD;
3531:
3532: FND_MSG_PUB.Count_And_Get(
3533: p_encoded => FND_API.G_FALSE,

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

3582: (p_create_update_flag = 'U' AND
3583: p_account_site_rec.language IS NOT NULL AND
3584: p_account_site_rec.language <> p_old_account_site_rec.language)
3585: THEN
3586: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
3587: FND_MESSAGE.SET_TOKEN('COLUMN', 'language');
3588: FND_MSG_PUB.ADD;
3589: x_return_status := FND_API.G_RET_STS_ERROR;
3590: END IF;

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

3583: p_account_site_rec.language IS NOT NULL AND
3584: p_account_site_rec.language <> p_old_account_site_rec.language)
3585: THEN
3586: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
3587: FND_MESSAGE.SET_TOKEN('COLUMN', 'language');
3588: FND_MSG_PUB.ADD;
3589: x_return_status := FND_API.G_RET_STS_ERROR;
3590: END IF;
3591: