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_V2PUB dependencies on FND_MESSAGE

Line 292: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_PARTY_TYPE' );

288: FROM HZ_PARTIES
289: WHERE PARTY_ID = l_party_id;
290:
291: IF l_party_type <> p_entity_type THEN
292: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_PARTY_TYPE' );
293: FND_MESSAGE.SET_TOKEN( 'PARTY_ID', l_party_id);
294: FND_MESSAGE.SET_TOKEN( 'TYPE', p_entity_type);
295: FND_MSG_PUB.ADD;
296: RAISE FND_API.G_EXC_ERROR;

Line 293: FND_MESSAGE.SET_TOKEN( 'PARTY_ID', l_party_id);

289: WHERE PARTY_ID = l_party_id;
290:
291: IF l_party_type <> p_entity_type THEN
292: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_PARTY_TYPE' );
293: FND_MESSAGE.SET_TOKEN( 'PARTY_ID', l_party_id);
294: FND_MESSAGE.SET_TOKEN( 'TYPE', p_entity_type);
295: FND_MSG_PUB.ADD;
296: RAISE FND_API.G_EXC_ERROR;
297: END IF;

Line 294: FND_MESSAGE.SET_TOKEN( 'TYPE', p_entity_type);

290:
291: IF l_party_type <> p_entity_type THEN
292: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_PARTY_TYPE' );
293: FND_MESSAGE.SET_TOKEN( 'PARTY_ID', l_party_id);
294: FND_MESSAGE.SET_TOKEN( 'TYPE', p_entity_type);
295: FND_MSG_PUB.ADD;
296: RAISE FND_API.G_EXC_ERROR;
297: END IF;
298:

Line 336: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_PARTY_TYPE' );

332: FROM HZ_PARTIES
333: WHERE PARTY_ID = l_party_id;
334:
335: IF l_party_type <> p_entity_type THEN
336: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_PARTY_TYPE' );
337: FND_MESSAGE.SET_TOKEN( 'PARTY_ID', l_party_id);
338: FND_MESSAGE.SET_TOKEN( 'TYPE', p_entity_type);
339: FND_MSG_PUB.ADD;
340: RAISE FND_API.G_EXC_ERROR;

Line 337: FND_MESSAGE.SET_TOKEN( 'PARTY_ID', l_party_id);

333: WHERE PARTY_ID = l_party_id;
334:
335: IF l_party_type <> p_entity_type THEN
336: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_PARTY_TYPE' );
337: FND_MESSAGE.SET_TOKEN( 'PARTY_ID', l_party_id);
338: FND_MESSAGE.SET_TOKEN( 'TYPE', p_entity_type);
339: FND_MSG_PUB.ADD;
340: RAISE FND_API.G_EXC_ERROR;
341: END IF;

Line 338: FND_MESSAGE.SET_TOKEN( 'TYPE', p_entity_type);

334:
335: IF l_party_type <> p_entity_type THEN
336: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_PARTY_TYPE' );
337: FND_MESSAGE.SET_TOKEN( 'PARTY_ID', l_party_id);
338: FND_MESSAGE.SET_TOKEN( 'TYPE', p_entity_type);
339: FND_MSG_PUB.ADD;
340: RAISE FND_API.G_EXC_ERROR;
341: END IF;
342: EXCEPTION

Line 374: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_PARTY_TYPE' );

370: FROM HZ_PARTIES
371: WHERE PARTY_ID = l_party_id;
372:
373: IF l_party_type <> p_entity_type THEN
374: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_PARTY_TYPE' );
375: FND_MESSAGE.SET_TOKEN( 'PARTY_ID', l_party_id);
376: FND_MESSAGE.SET_TOKEN( 'TYPE', p_entity_type);
377: FND_MSG_PUB.ADD;
378: RAISE FND_API.G_EXC_ERROR;

Line 375: FND_MESSAGE.SET_TOKEN( 'PARTY_ID', l_party_id);

371: WHERE PARTY_ID = l_party_id;
372:
373: IF l_party_type <> p_entity_type THEN
374: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_PARTY_TYPE' );
375: FND_MESSAGE.SET_TOKEN( 'PARTY_ID', l_party_id);
376: FND_MESSAGE.SET_TOKEN( 'TYPE', p_entity_type);
377: FND_MSG_PUB.ADD;
378: RAISE FND_API.G_EXC_ERROR;
379: END IF;

Line 376: FND_MESSAGE.SET_TOKEN( 'TYPE', p_entity_type);

372:
373: IF l_party_type <> p_entity_type THEN
374: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_PARTY_TYPE' );
375: FND_MESSAGE.SET_TOKEN( 'PARTY_ID', l_party_id);
376: FND_MESSAGE.SET_TOKEN( 'TYPE', p_entity_type);
377: FND_MSG_PUB.ADD;
378: RAISE FND_API.G_EXC_ERROR;
379: END IF;
380: EXCEPTION

Line 615: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_COLUMN_SHOULD_BE_NULL' );

611:
612: IF p_customer_profile_rec.site_use_id IS NOT NULL AND
613: p_customer_profile_rec.site_use_id <> FND_API.G_MISS_NUM
614: THEN
615: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_COLUMN_SHOULD_BE_NULL' );
616: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'site_use_id' );
617: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_customer_profiles' );
618: FND_MSG_PUB.ADD;
619: RAISE FND_API.G_EXC_ERROR;

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

612: IF p_customer_profile_rec.site_use_id IS NOT NULL AND
613: p_customer_profile_rec.site_use_id <> FND_API.G_MISS_NUM
614: THEN
615: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_COLUMN_SHOULD_BE_NULL' );
616: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'site_use_id' );
617: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_customer_profiles' );
618: FND_MSG_PUB.ADD;
619: RAISE FND_API.G_EXC_ERROR;
620: END IF;

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

613: p_customer_profile_rec.site_use_id <> FND_API.G_MISS_NUM
614: THEN
615: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_COLUMN_SHOULD_BE_NULL' );
616: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'site_use_id' );
617: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_customer_profiles' );
618: FND_MSG_PUB.ADD;
619: RAISE FND_API.G_EXC_ERROR;
620: END IF;
621:

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

775: ( p_object_version_number IS NOT NULL AND
776: l_object_version_number IS NOT NULL AND
777: p_object_version_number = l_object_version_number ) )
778: THEN
779: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
780: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_accounts' );
781: FND_MSG_PUB.ADD;
782: RAISE FND_API.G_EXC_ERROR;
783: END IF;

Line 780: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_accounts' );

776: l_object_version_number IS NOT NULL AND
777: p_object_version_number = l_object_version_number ) )
778: THEN
779: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
780: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_accounts' );
781: FND_MSG_PUB.ADD;
782: RAISE FND_API.G_EXC_ERROR;
783: END IF;
784:

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

785: p_object_version_number := NVL( l_object_version_number, 1 ) + 1;
786:
787: EXCEPTION
788: WHEN NO_DATA_FOUND THEN
789: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
790: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer account' );
791: FND_MESSAGE.SET_TOKEN( 'VALUE',
792: NVL( TO_CHAR( p_cust_account_rec.cust_account_id ), 'null' ) );
793: FND_MSG_PUB.ADD;

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

786:
787: EXCEPTION
788: WHEN NO_DATA_FOUND THEN
789: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
790: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer account' );
791: FND_MESSAGE.SET_TOKEN( 'VALUE',
792: NVL( TO_CHAR( p_cust_account_rec.cust_account_id ), 'null' ) );
793: FND_MSG_PUB.ADD;
794: RAISE FND_API.G_EXC_ERROR;

Line 791: FND_MESSAGE.SET_TOKEN( 'VALUE',

787: EXCEPTION
788: WHEN NO_DATA_FOUND THEN
789: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
790: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer account' );
791: FND_MESSAGE.SET_TOKEN( 'VALUE',
792: NVL( TO_CHAR( p_cust_account_rec.cust_account_id ), 'null' ) );
793: FND_MSG_PUB.ADD;
794: RAISE FND_API.G_EXC_ERROR;
795: END;

Line 1281: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_ACTIVE_RECORD');

1277: FOR UPDATE NOWAIT;
1278:
1279: EXCEPTION
1280: WHEN NO_DATA_FOUND THEN
1281: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_ACTIVE_RECORD');
1282: FND_MESSAGE.SET_TOKEN( 'ACCOUNT1',p_cust_acct_relate_rec.cust_account_id);
1283: FND_MESSAGE.SET_TOKEN( 'ACCOUNT2',p_cust_acct_relate_rec.related_cust_account_id);
1284: FND_MSG_PUB.ADD;
1285: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1282: FND_MESSAGE.SET_TOKEN( 'ACCOUNT1',p_cust_acct_relate_rec.cust_account_id);

1278:
1279: EXCEPTION
1280: WHEN NO_DATA_FOUND THEN
1281: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_ACTIVE_RECORD');
1282: FND_MESSAGE.SET_TOKEN( 'ACCOUNT1',p_cust_acct_relate_rec.cust_account_id);
1283: FND_MESSAGE.SET_TOKEN( 'ACCOUNT2',p_cust_acct_relate_rec.related_cust_account_id);
1284: FND_MSG_PUB.ADD;
1285: x_return_status := FND_API.G_RET_STS_ERROR;
1286: RAISE FND_API.G_EXC_ERROR;

Line 1283: FND_MESSAGE.SET_TOKEN( 'ACCOUNT2',p_cust_acct_relate_rec.related_cust_account_id);

1279: EXCEPTION
1280: WHEN NO_DATA_FOUND THEN
1281: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_ACTIVE_RECORD');
1282: FND_MESSAGE.SET_TOKEN( 'ACCOUNT1',p_cust_acct_relate_rec.cust_account_id);
1283: FND_MESSAGE.SET_TOKEN( 'ACCOUNT2',p_cust_acct_relate_rec.related_cust_account_id);
1284: FND_MSG_PUB.ADD;
1285: x_return_status := FND_API.G_RET_STS_ERROR;
1286: RAISE FND_API.G_EXC_ERROR;
1287: END;

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

1296: WHERE ROWID = p_rowid;
1297:
1298: EXCEPTION
1299: WHEN NO_DATA_FOUND THEN
1300: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
1301: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer account relate' );
1302: FND_MESSAGE.SET_TOKEN( 'VALUE',p_rowid);
1303: FND_MSG_PUB.ADD;
1304: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1301: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer account relate' );

1297:
1298: EXCEPTION
1299: WHEN NO_DATA_FOUND THEN
1300: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
1301: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer account relate' );
1302: FND_MESSAGE.SET_TOKEN( 'VALUE',p_rowid);
1303: FND_MSG_PUB.ADD;
1304: x_return_status := FND_API.G_RET_STS_ERROR;
1305: RAISE FND_API.G_EXC_ERROR;

Line 1302: FND_MESSAGE.SET_TOKEN( 'VALUE',p_rowid);

1298: EXCEPTION
1299: WHEN NO_DATA_FOUND THEN
1300: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
1301: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer account relate' );
1302: FND_MESSAGE.SET_TOKEN( 'VALUE',p_rowid);
1303: FND_MSG_PUB.ADD;
1304: x_return_status := FND_API.G_RET_STS_ERROR;
1305: RAISE FND_API.G_EXC_ERROR;
1306: END;

Line 1332: FND_MESSAGE.SET_NAME ('AR','HZ_API_NONUPDATEABLE_COLUMN');

1328: IF p_cust_acct_relate_rec.cust_account_id IS NOT NULL AND
1329: (p_cust_acct_relate_rec.cust_account_id = FND_API.G_MISS_NUM OR
1330: l_cust_account_id <> p_cust_acct_relate_rec.cust_account_id)
1331: THEN
1332: FND_MESSAGE.SET_NAME ('AR','HZ_API_NONUPDATEABLE_COLUMN');
1333: FND_MESSAGE.SET_TOKEN('COLUMN','CUST_ACCOUNT_ID');
1334: FND_MSG_PUB.ADD;
1335: x_return_status := FND_API.G_RET_STS_ERROR;
1336: END IF;

Line 1333: FND_MESSAGE.SET_TOKEN('COLUMN','CUST_ACCOUNT_ID');

1329: (p_cust_acct_relate_rec.cust_account_id = FND_API.G_MISS_NUM OR
1330: l_cust_account_id <> p_cust_acct_relate_rec.cust_account_id)
1331: THEN
1332: FND_MESSAGE.SET_NAME ('AR','HZ_API_NONUPDATEABLE_COLUMN');
1333: FND_MESSAGE.SET_TOKEN('COLUMN','CUST_ACCOUNT_ID');
1334: FND_MSG_PUB.ADD;
1335: x_return_status := FND_API.G_RET_STS_ERROR;
1336: END IF;
1337:

Line 1343: FND_MESSAGE.SET_NAME ('AR','HZ_API_NONUPDATEABLE_COLUMN');

1339: IF p_cust_acct_relate_rec.related_cust_account_id IS NOT NULL AND
1340: (p_cust_acct_relate_rec.related_cust_account_id = FND_API.G_MISS_NUM OR
1341: l_related_cust_account_id <> p_cust_acct_relate_rec.related_cust_account_id)
1342: THEN
1343: FND_MESSAGE.SET_NAME ('AR','HZ_API_NONUPDATEABLE_COLUMN');
1344: FND_MESSAGE.SET_TOKEN('COLUMN','RELATED_CUST_ACCOUNT_ID');
1345: FND_MSG_PUB.ADD;
1346: x_return_status := FND_API.G_RET_STS_ERROR;
1347: END IF;

Line 1344: FND_MESSAGE.SET_TOKEN('COLUMN','RELATED_CUST_ACCOUNT_ID');

1340: (p_cust_acct_relate_rec.related_cust_account_id = FND_API.G_MISS_NUM OR
1341: l_related_cust_account_id <> p_cust_acct_relate_rec.related_cust_account_id)
1342: THEN
1343: FND_MESSAGE.SET_NAME ('AR','HZ_API_NONUPDATEABLE_COLUMN');
1344: FND_MESSAGE.SET_TOKEN('COLUMN','RELATED_CUST_ACCOUNT_ID');
1345: FND_MSG_PUB.ADD;
1346: x_return_status := FND_API.G_RET_STS_ERROR;
1347: END IF;
1348:

Line 1363: FND_MESSAGE.SET_NAME ('AR','HZ_ACTIVE_CUST_ACCT_RELATE');

1359: STATUS = 'A' AND
1360: ORG_ID = p_cust_acct_relate_rec.org_id; -- Bug 3456489
1361:
1362: IF l_count <> 0 THEN
1363: FND_MESSAGE.SET_NAME ('AR','HZ_ACTIVE_CUST_ACCT_RELATE');
1364: FND_MESSAGE.SET_TOKEN('ACCOUNT1',l_cust_account_id);
1365: FND_MESSAGE.SET_TOKEN('ACCOUNT2',l_related_cust_account_id);
1366: FND_MSG_PUB.ADD;
1367: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1364: FND_MESSAGE.SET_TOKEN('ACCOUNT1',l_cust_account_id);

1360: ORG_ID = p_cust_acct_relate_rec.org_id; -- Bug 3456489
1361:
1362: IF l_count <> 0 THEN
1363: FND_MESSAGE.SET_NAME ('AR','HZ_ACTIVE_CUST_ACCT_RELATE');
1364: FND_MESSAGE.SET_TOKEN('ACCOUNT1',l_cust_account_id);
1365: FND_MESSAGE.SET_TOKEN('ACCOUNT2',l_related_cust_account_id);
1366: FND_MSG_PUB.ADD;
1367: x_return_status := FND_API.G_RET_STS_ERROR;
1368: END IF;

Line 1365: FND_MESSAGE.SET_TOKEN('ACCOUNT2',l_related_cust_account_id);

1361:
1362: IF l_count <> 0 THEN
1363: FND_MESSAGE.SET_NAME ('AR','HZ_ACTIVE_CUST_ACCT_RELATE');
1364: FND_MESSAGE.SET_TOKEN('ACCOUNT1',l_cust_account_id);
1365: FND_MESSAGE.SET_TOKEN('ACCOUNT2',l_related_cust_account_id);
1366: FND_MSG_PUB.ADD;
1367: x_return_status := FND_API.G_RET_STS_ERROR;
1368: END IF;
1369:

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

1370: END IF;
1371:
1372: EXCEPTION
1373: WHEN NO_DATA_FOUND THEN
1374: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
1375: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer account relate' );
1376: FND_MESSAGE.SET_TOKEN( 'VALUE', l_cust_acct_relate_id);
1377: FND_MSG_PUB.ADD;
1378: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1375: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer account relate' );

1371:
1372: EXCEPTION
1373: WHEN NO_DATA_FOUND THEN
1374: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
1375: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer account relate' );
1376: FND_MESSAGE.SET_TOKEN( 'VALUE', l_cust_acct_relate_id);
1377: FND_MSG_PUB.ADD;
1378: x_return_status := FND_API.G_RET_STS_ERROR;
1379: RAISE FND_API.G_EXC_ERROR;

Line 1376: FND_MESSAGE.SET_TOKEN( 'VALUE', l_cust_acct_relate_id);

1372: EXCEPTION
1373: WHEN NO_DATA_FOUND THEN
1374: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
1375: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer account relate' );
1376: FND_MESSAGE.SET_TOKEN( 'VALUE', l_cust_acct_relate_id);
1377: FND_MSG_PUB.ADD;
1378: x_return_status := FND_API.G_RET_STS_ERROR;
1379: RAISE FND_API.G_EXC_ERROR;
1380: END;

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

1385: ( p_object_version_number IS NOT NULL AND
1386: l_object_version_number IS NOT NULL AND
1387: p_object_version_number = l_object_version_number ) )
1388: THEN
1389: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
1390: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_acct_relate' );
1391: FND_MSG_PUB.ADD;
1392: RAISE FND_API.G_EXC_ERROR;
1393: END IF;

Line 1390: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_acct_relate' );

1386: l_object_version_number IS NOT NULL AND
1387: p_object_version_number = l_object_version_number ) )
1388: THEN
1389: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
1390: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_acct_relate' );
1391: FND_MSG_PUB.ADD;
1392: RAISE FND_API.G_EXC_ERROR;
1393: END IF;
1394:

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

1689: WHEN OTHERS THEN
1690: ROLLBACK TO create_cust_account;
1691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1692:
1693: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
1694: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1695: FND_MSG_PUB.ADD;
1696:
1697: FND_MSG_PUB.Count_And_Get(

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

1690: ROLLBACK TO create_cust_account;
1691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1692:
1693: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
1694: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1695: FND_MSG_PUB.ADD;
1696:
1697: FND_MSG_PUB.Count_And_Get(
1698: p_encoded => FND_API.G_FALSE,

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

1938: WHEN OTHERS THEN
1939: ROLLBACK TO create_cust_account;
1940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1941:
1942: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
1943: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1944: FND_MSG_PUB.ADD;
1945:
1946: FND_MSG_PUB.Count_And_Get(

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

1939: ROLLBACK TO create_cust_account;
1940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1941:
1942: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
1943: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1944: FND_MSG_PUB.ADD;
1945:
1946: FND_MSG_PUB.Count_And_Get(
1947: p_encoded => FND_API.G_FALSE,

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

2183: WHEN OTHERS THEN
2184: ROLLBACK TO update_cust_account;
2185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2186:
2187: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2188: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2189: FND_MSG_PUB.ADD;
2190:
2191: FND_MSG_PUB.Count_And_Get(

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

2184: ROLLBACK TO update_cust_account;
2185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2186:
2187: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2188: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2189: FND_MSG_PUB.ADD;
2190:
2191: FND_MSG_PUB.Count_And_Get(
2192: p_encoded => FND_API.G_FALSE,

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

2285:
2286: -- Check whether primary key has been passed in.
2287: IF p_cust_account_id IS NULL OR
2288: p_cust_account_id = FND_API.G_MISS_NUM THEN
2289: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2290: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_account_id' );
2291: FND_MSG_PUB.ADD;
2292: RAISE FND_API.G_EXC_ERROR;
2293: END IF;

Line 2290: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_account_id' );

2286: -- Check whether primary key has been passed in.
2287: IF p_cust_account_id IS NULL OR
2288: p_cust_account_id = FND_API.G_MISS_NUM THEN
2289: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2290: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_account_id' );
2291: FND_MSG_PUB.ADD;
2292: RAISE FND_API.G_EXC_ERROR;
2293: END IF;
2294:

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

2507:
2508: WHEN OTHERS THEN
2509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2510:
2511: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2512: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2513: FND_MSG_PUB.ADD;
2514:
2515: FND_MSG_PUB.Count_And_Get(

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

2508: WHEN OTHERS THEN
2509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2510:
2511: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2512: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2513: FND_MSG_PUB.ADD;
2514:
2515: FND_MSG_PUB.Count_And_Get(
2516: p_encoded => FND_API.G_FALSE,

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

2750: WHEN OTHERS THEN
2751: ROLLBACK TO create_cust_acct_relate;
2752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2753:
2754: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2755: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2756: FND_MSG_PUB.ADD;
2757:
2758: FND_MSG_PUB.Count_And_Get(

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

2751: ROLLBACK TO create_cust_acct_relate;
2752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2753:
2754: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2755: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2756: FND_MSG_PUB.ADD;
2757:
2758: FND_MSG_PUB.Count_And_Get(
2759: p_encoded => FND_API.G_FALSE,

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

2971: WHEN OTHERS THEN
2972: ROLLBACK TO update_cust_acct_relate;
2973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2974:
2975: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2976: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2977: FND_MSG_PUB.ADD;
2978:
2979: FND_MSG_PUB.Count_And_Get(

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

2972: ROLLBACK TO update_cust_acct_relate;
2973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2974:
2975: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2976: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2977: FND_MSG_PUB.ADD;
2978:
2979: FND_MSG_PUB.Count_And_Get(
2980: p_encoded => FND_API.G_FALSE,

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

3197: WHEN OTHERS THEN
3198: ROLLBACK TO update_cust_acct_relate;
3199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3200:
3201: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3202: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3203: FND_MSG_PUB.ADD;
3204:
3205: FND_MSG_PUB.Count_And_Get(

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

3198: ROLLBACK TO update_cust_acct_relate;
3199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3200:
3201: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3202: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3203: FND_MSG_PUB.ADD;
3204:
3205: FND_MSG_PUB.Count_And_Get(
3206: p_encoded => FND_API.G_FALSE,

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

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

Line 3306: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_account_id' );

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

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

3309: END IF;
3310:
3311: IF p_related_cust_account_id IS NULL OR
3312: p_related_cust_account_id = FND_API.G_MISS_NUM THEN
3313: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3314: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'related_cust_account_id' );
3315: FND_MSG_PUB.ADD;
3316: RAISE FND_API.G_EXC_ERROR;
3317: END IF;

Line 3314: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'related_cust_account_id' );

3310:
3311: IF p_related_cust_account_id IS NULL OR
3312: p_related_cust_account_id = FND_API.G_MISS_NUM THEN
3313: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3314: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'related_cust_account_id' );
3315: FND_MSG_PUB.ADD;
3316: RAISE FND_API.G_EXC_ERROR;
3317: END IF;
3318: END IF;

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

3481:
3482: WHEN OTHERS THEN
3483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3484:
3485: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3486: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3487: FND_MSG_PUB.ADD;
3488:
3489: FND_MSG_PUB.Count_And_Get(

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

3482: WHEN OTHERS THEN
3483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3484:
3485: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3486: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3487: FND_MSG_PUB.ADD;
3488:
3489: FND_MSG_PUB.Count_And_Get(
3490: p_encoded => FND_API.G_FALSE,

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

3542: (p_create_update_flag = 'U' AND
3543: p_cust_account_rec.account_activation_date IS NOT NULL AND
3544: p_cust_account_rec.account_activation_date <> p_old_cust_account_rec.account_activation_date)
3545: THEN
3546: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
3547: FND_MESSAGE.SET_TOKEN('COLUMN', 'account_activation_date');
3548: FND_MSG_PUB.ADD;
3549: x_return_status := FND_API.G_RET_STS_ERROR;
3550: END IF;

Line 3547: FND_MESSAGE.SET_TOKEN('COLUMN', 'account_activation_date');

3543: p_cust_account_rec.account_activation_date IS NOT NULL AND
3544: p_cust_account_rec.account_activation_date <> p_old_cust_account_rec.account_activation_date)
3545: THEN
3546: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
3547: FND_MESSAGE.SET_TOKEN('COLUMN', 'account_activation_date');
3548: FND_MSG_PUB.ADD;
3549: x_return_status := FND_API.G_RET_STS_ERROR;
3550: END IF;
3551:

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

3556: (p_create_update_flag = 'U' AND
3557: p_cust_account_rec.account_liable_flag IS NOT NULL AND
3558: p_cust_account_rec.account_liable_flag <> p_old_cust_account_rec.account_liable_flag)
3559: THEN
3560: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
3561: FND_MESSAGE.SET_TOKEN('COLUMN', 'account_liable_flag');
3562: FND_MSG_PUB.ADD;
3563: x_return_status := FND_API.G_RET_STS_ERROR;
3564: END IF;

Line 3561: FND_MESSAGE.SET_TOKEN('COLUMN', 'account_liable_flag');

3557: p_cust_account_rec.account_liable_flag IS NOT NULL AND
3558: p_cust_account_rec.account_liable_flag <> p_old_cust_account_rec.account_liable_flag)
3559: THEN
3560: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
3561: FND_MESSAGE.SET_TOKEN('COLUMN', 'account_liable_flag');
3562: FND_MSG_PUB.ADD;
3563: x_return_status := FND_API.G_RET_STS_ERROR;
3564: END IF;
3565:

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

3570: (p_create_update_flag = 'U' AND
3571: p_cust_account_rec.account_termination_date IS NOT NULL AND
3572: p_cust_account_rec.account_termination_date <> p_old_cust_account_rec.account_termination_date)
3573: THEN
3574: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
3575: FND_MESSAGE.SET_TOKEN('COLUMN', 'account_termination_date');
3576: FND_MSG_PUB.ADD;
3577: x_return_status := FND_API.G_RET_STS_ERROR;
3578: END IF;

Line 3575: FND_MESSAGE.SET_TOKEN('COLUMN', 'account_termination_date');

3571: p_cust_account_rec.account_termination_date IS NOT NULL AND
3572: p_cust_account_rec.account_termination_date <> p_old_cust_account_rec.account_termination_date)
3573: THEN
3574: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
3575: FND_MESSAGE.SET_TOKEN('COLUMN', 'account_termination_date');
3576: FND_MSG_PUB.ADD;
3577: x_return_status := FND_API.G_RET_STS_ERROR;
3578: END IF;
3579:

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

3584: (p_create_update_flag = 'U' AND
3585: p_cust_account_rec.acct_life_cycle_status IS NOT NULL AND
3586: p_cust_account_rec.acct_life_cycle_status <> p_old_cust_account_rec.acct_life_cycle_status)
3587: THEN
3588: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
3589: FND_MESSAGE.SET_TOKEN('COLUMN', 'acct_life_cycle_status');
3590: FND_MSG_PUB.ADD;
3591: x_return_status := FND_API.G_RET_STS_ERROR;
3592: END IF;

Line 3589: FND_MESSAGE.SET_TOKEN('COLUMN', 'acct_life_cycle_status');

3585: p_cust_account_rec.acct_life_cycle_status IS NOT NULL AND
3586: p_cust_account_rec.acct_life_cycle_status <> p_old_cust_account_rec.acct_life_cycle_status)
3587: THEN
3588: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
3589: FND_MESSAGE.SET_TOKEN('COLUMN', 'acct_life_cycle_status');
3590: FND_MSG_PUB.ADD;
3591: x_return_status := FND_API.G_RET_STS_ERROR;
3592: END IF;
3593:

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

3598: (p_create_update_flag = 'U' AND
3599: p_cust_account_rec.current_balance IS NOT NULL AND
3600: p_cust_account_rec.current_balance <> p_old_cust_account_rec.current_balance)
3601: THEN
3602: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
3603: FND_MESSAGE.SET_TOKEN('COLUMN', 'current_balance');
3604: FND_MSG_PUB.ADD;
3605: x_return_status := FND_API.G_RET_STS_ERROR;
3606: END IF;

Line 3603: FND_MESSAGE.SET_TOKEN('COLUMN', 'current_balance');

3599: p_cust_account_rec.current_balance IS NOT NULL AND
3600: p_cust_account_rec.current_balance <> p_old_cust_account_rec.current_balance)
3601: THEN
3602: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
3603: FND_MESSAGE.SET_TOKEN('COLUMN', 'current_balance');
3604: FND_MSG_PUB.ADD;
3605: x_return_status := FND_API.G_RET_STS_ERROR;
3606: END IF;
3607:

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

3612: (p_create_update_flag = 'U' AND
3613: p_cust_account_rec.department IS NOT NULL AND
3614: p_cust_account_rec.department <> p_old_cust_account_rec.department)
3615: THEN
3616: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
3617: FND_MESSAGE.SET_TOKEN('COLUMN', 'department');
3618: FND_MSG_PUB.ADD;
3619: x_return_status := FND_API.G_RET_STS_ERROR;
3620: END IF;

Line 3617: FND_MESSAGE.SET_TOKEN('COLUMN', 'department');

3613: p_cust_account_rec.department IS NOT NULL AND
3614: p_cust_account_rec.department <> p_old_cust_account_rec.department)
3615: THEN
3616: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
3617: FND_MESSAGE.SET_TOKEN('COLUMN', 'department');
3618: FND_MSG_PUB.ADD;
3619: x_return_status := FND_API.G_RET_STS_ERROR;
3620: END IF;
3621:

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

3626: (p_create_update_flag = 'U' AND
3627: p_cust_account_rec.dormant_account_flag IS NOT NULL AND
3628: p_cust_account_rec.dormant_account_flag <> p_old_cust_account_rec.dormant_account_flag)
3629: THEN
3630: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
3631: FND_MESSAGE.SET_TOKEN('COLUMN', 'dormant_account_flag');
3632: FND_MSG_PUB.ADD;
3633: x_return_status := FND_API.G_RET_STS_ERROR;
3634: END IF;

Line 3631: FND_MESSAGE.SET_TOKEN('COLUMN', 'dormant_account_flag');

3627: p_cust_account_rec.dormant_account_flag IS NOT NULL AND
3628: p_cust_account_rec.dormant_account_flag <> p_old_cust_account_rec.dormant_account_flag)
3629: THEN
3630: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
3631: FND_MESSAGE.SET_TOKEN('COLUMN', 'dormant_account_flag');
3632: FND_MSG_PUB.ADD;
3633: x_return_status := FND_API.G_RET_STS_ERROR;
3634: END IF;
3635:

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

3640: (p_create_update_flag = 'U' AND
3641: p_cust_account_rec.notify_flag IS NOT NULL AND
3642: p_cust_account_rec.notify_flag <> p_old_cust_account_rec.notify_flag)
3643: THEN
3644: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
3645: FND_MESSAGE.SET_TOKEN('COLUMN', 'notify_flag');
3646: FND_MSG_PUB.ADD;
3647: x_return_status := FND_API.G_RET_STS_ERROR;
3648: END IF;

Line 3645: FND_MESSAGE.SET_TOKEN('COLUMN', 'notify_flag');

3641: p_cust_account_rec.notify_flag IS NOT NULL AND
3642: p_cust_account_rec.notify_flag <> p_old_cust_account_rec.notify_flag)
3643: THEN
3644: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
3645: FND_MESSAGE.SET_TOKEN('COLUMN', 'notify_flag');
3646: FND_MSG_PUB.ADD;
3647: x_return_status := FND_API.G_RET_STS_ERROR;
3648: END IF;
3649:

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

3654: (p_create_update_flag = 'U' AND
3655: p_cust_account_rec.order_type_id IS NOT NULL AND
3656: p_cust_account_rec.order_type_id <> p_old_cust_account_rec.order_type_id)
3657: THEN
3658: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
3659: FND_MESSAGE.SET_TOKEN('COLUMN', 'order_type_id');
3660: FND_MSG_PUB.ADD;
3661: x_return_status := FND_API.G_RET_STS_ERROR;
3662: END IF;

Line 3659: FND_MESSAGE.SET_TOKEN('COLUMN', 'order_type_id');

3655: p_cust_account_rec.order_type_id IS NOT NULL AND
3656: p_cust_account_rec.order_type_id <> p_old_cust_account_rec.order_type_id)
3657: THEN
3658: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
3659: FND_MESSAGE.SET_TOKEN('COLUMN', 'order_type_id');
3660: FND_MSG_PUB.ADD;
3661: x_return_status := FND_API.G_RET_STS_ERROR;
3662: END IF;
3663:

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

3668: (p_create_update_flag = 'U' AND
3669: p_cust_account_rec.primary_salesrep_id IS NOT NULL AND
3670: p_cust_account_rec.primary_salesrep_id <> p_old_cust_account_rec.primary_salesrep_id)
3671: THEN
3672: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
3673: FND_MESSAGE.SET_TOKEN('COLUMN', 'primary_salesrep_id');
3674: FND_MSG_PUB.ADD;
3675: x_return_status := FND_API.G_RET_STS_ERROR;
3676: END IF;

Line 3673: FND_MESSAGE.SET_TOKEN('COLUMN', 'primary_salesrep_id');

3669: p_cust_account_rec.primary_salesrep_id IS NOT NULL AND
3670: p_cust_account_rec.primary_salesrep_id <> p_old_cust_account_rec.primary_salesrep_id)
3671: THEN
3672: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
3673: FND_MESSAGE.SET_TOKEN('COLUMN', 'primary_salesrep_id');
3674: FND_MSG_PUB.ADD;
3675: x_return_status := FND_API.G_RET_STS_ERROR;
3676: END IF;
3677:

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

3682: (p_create_update_flag = 'U' AND
3683: p_cust_account_rec.realtime_rate_flag IS NOT NULL AND
3684: p_cust_account_rec.realtime_rate_flag <> p_old_cust_account_rec.realtime_rate_flag)
3685: THEN
3686: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
3687: FND_MESSAGE.SET_TOKEN('COLUMN', 'realtime_rate_flag');
3688: FND_MSG_PUB.ADD;
3689: x_return_status := FND_API.G_RET_STS_ERROR;
3690: END IF;

Line 3687: FND_MESSAGE.SET_TOKEN('COLUMN', 'realtime_rate_flag');

3683: p_cust_account_rec.realtime_rate_flag IS NOT NULL AND
3684: p_cust_account_rec.realtime_rate_flag <> p_old_cust_account_rec.realtime_rate_flag)
3685: THEN
3686: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
3687: FND_MESSAGE.SET_TOKEN('COLUMN', 'realtime_rate_flag');
3688: FND_MSG_PUB.ADD;
3689: x_return_status := FND_API.G_RET_STS_ERROR;
3690: END IF;
3691:

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

3696: (p_create_update_flag = 'U' AND
3697: p_cust_account_rec.suspension_date IS NOT NULL AND
3698: p_cust_account_rec.suspension_date <> p_old_cust_account_rec.suspension_date)
3699: THEN
3700: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
3701: FND_MESSAGE.SET_TOKEN('COLUMN', 'suspension_date');
3702: FND_MSG_PUB.ADD;
3703: x_return_status := FND_API.G_RET_STS_ERROR;
3704: END IF;

Line 3701: FND_MESSAGE.SET_TOKEN('COLUMN', 'suspension_date');

3697: p_cust_account_rec.suspension_date IS NOT NULL AND
3698: p_cust_account_rec.suspension_date <> p_old_cust_account_rec.suspension_date)
3699: THEN
3700: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
3701: FND_MESSAGE.SET_TOKEN('COLUMN', 'suspension_date');
3702: FND_MSG_PUB.ADD;
3703: x_return_status := FND_API.G_RET_STS_ERROR;
3704: END IF;
3705:

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

3711: (p_create_update_flag = 'U' AND
3712: p_cust_account_rec.tax_code IS NOT NULL AND
3713: p_cust_account_rec.tax_code <> p_old_cust_account_rec.tax_code)
3714: THEN
3715: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
3716: FND_MESSAGE.SET_TOKEN('COLUMN', 'tax_code');
3717: FND_MSG_PUB.ADD;
3718: x_return_status := FND_API.G_RET_STS_ERROR;
3719: END IF;

Line 3716: FND_MESSAGE.SET_TOKEN('COLUMN', 'tax_code');

3712: p_cust_account_rec.tax_code IS NOT NULL AND
3713: p_cust_account_rec.tax_code <> p_old_cust_account_rec.tax_code)
3714: THEN
3715: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
3716: FND_MESSAGE.SET_TOKEN('COLUMN', 'tax_code');
3717: FND_MSG_PUB.ADD;
3718: x_return_status := FND_API.G_RET_STS_ERROR;
3719: END IF;
3720: */