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_MSG_PUB

Line 295: FND_MSG_PUB.ADD;

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:
299: -- can go ahead and create an account for this existing party.

Line 339: FND_MSG_PUB.ADD;

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
343: WHEN NO_DATA_FOUND THEN

Line 377: FND_MSG_PUB.ADD;

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
381: WHEN NO_DATA_FOUND THEN

Line 618: FND_MSG_PUB.ADD;

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:
622: p_customer_profile_rec.created_by_module := p_cust_account_rec.created_by_module;

Line 781: FND_MSG_PUB.ADD;

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:
785: p_object_version_number := NVL( l_object_version_number, 1 ) + 1;

Line 793: FND_MSG_PUB.ADD;

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;
796:
797:

Line 1284: FND_MSG_PUB.ADD;

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;
1288: ELSE --- Bug 3449118.

Line 1303: FND_MSG_PUB.ADD;

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

Line 1334: FND_MSG_PUB.ADD;

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:
1338: -- related_cust_account_id is not updateable.

Line 1345: FND_MSG_PUB.ADD;

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:
1349: -- If status is updated to Active

Line 1366: FND_MSG_PUB.ADD;

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:
1370: END IF;

Line 1377: FND_MSG_PUB.ADD;

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;
1381: END IF;

Line 1391: FND_MSG_PUB.ADD;

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:
1395: p_object_version_number := NVL( l_object_version_number, 1 ) + 1;

Line 1558: FND_MSG_PUB.initialize;

1554: END IF;
1555:
1556: -- Initialize message list if p_init_msg_list is set to TRUE.
1557: IF FND_API.to_Boolean(p_init_msg_list) THEN
1558: FND_MSG_PUB.initialize;
1559: END IF;
1560:
1561: -- Initialize API return status to success.
1562: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1615: FND_MSG_PUB.Count_And_Get(

1611: -- Call to indicate account creation to DQM
1612: HZ_DQM_SYNC.sync_cust_account(l_cust_account_rec.CUST_ACCOUNT_ID,'C');
1613:
1614: -- Standard call to get message count and if count is 1, get message info.
1615: FND_MSG_PUB.Count_And_Get(
1616: p_encoded => FND_API.G_FALSE,
1617: p_count => x_msg_count,
1618: p_data => x_msg_data );
1619:

Line 1641: FND_MSG_PUB.Count_And_Get(

1637: WHEN FND_API.G_EXC_ERROR THEN
1638: ROLLBACK TO create_cust_account;
1639: x_return_status := FND_API.G_RET_STS_ERROR;
1640:
1641: FND_MSG_PUB.Count_And_Get(
1642: p_encoded => FND_API.G_FALSE,
1643: p_count => x_msg_count,
1644: p_data => x_msg_data );
1645:

Line 1667: FND_MSG_PUB.Count_And_Get(

1663: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1664: ROLLBACK TO create_cust_account;
1665: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1666:
1667: FND_MSG_PUB.Count_And_Get(
1668: p_encoded => FND_API.G_FALSE,
1669: p_count => x_msg_count,
1670: p_data => x_msg_data );
1671:

Line 1695: FND_MSG_PUB.ADD;

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,
1699: p_count => x_msg_count,

Line 1697: FND_MSG_PUB.Count_And_Get(

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,
1699: p_count => x_msg_count,
1700: p_data => x_msg_data );
1701:

Line 1807: FND_MSG_PUB.initialize;

1803: END IF;
1804:
1805: -- Initialize message list if p_init_msg_list is set to TRUE.
1806: IF FND_API.to_Boolean(p_init_msg_list) THEN
1807: FND_MSG_PUB.initialize;
1808: END IF;
1809:
1810: -- Initialize API return status to success.
1811: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1863: FND_MSG_PUB.Count_And_Get(

1859: -- Call to indicate account creation to DQM
1860: HZ_DQM_SYNC.sync_cust_account(l_cust_account_rec.CUST_ACCOUNT_ID,'C');
1861:
1862: -- Standard call to get message count and if count is 1, get message info.
1863: FND_MSG_PUB.Count_And_Get(
1864: p_encoded => FND_API.G_FALSE,
1865: p_count => x_msg_count,
1866: p_data => x_msg_data );
1867:

Line 1890: FND_MSG_PUB.Count_And_Get(

1886: WHEN FND_API.G_EXC_ERROR THEN
1887: ROLLBACK TO create_cust_account;
1888: x_return_status := FND_API.G_RET_STS_ERROR;
1889:
1890: FND_MSG_PUB.Count_And_Get(
1891: p_encoded => FND_API.G_FALSE,
1892: p_count => x_msg_count,
1893: p_data => x_msg_data );
1894:

Line 1916: FND_MSG_PUB.Count_And_Get(

1912: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1913: ROLLBACK TO create_cust_account;
1914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1915:
1916: FND_MSG_PUB.Count_And_Get(
1917: p_encoded => FND_API.G_FALSE,
1918: p_count => x_msg_count,
1919: p_data => x_msg_data );
1920:

Line 1944: FND_MSG_PUB.ADD;

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,
1948: p_count => x_msg_count,

Line 1946: FND_MSG_PUB.Count_And_Get(

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,
1948: p_count => x_msg_count,
1949: p_data => x_msg_data );
1950:

Line 2034: FND_MSG_PUB.initialize;

2030: END IF;
2031:
2032: -- Initialize message list if p_init_msg_list is set to TRUE.
2033: IF FND_API.to_Boolean(p_init_msg_list) THEN
2034: FND_MSG_PUB.initialize;
2035: END IF;
2036:
2037: -- Initialize API return status to success.
2038: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2109: FND_MSG_PUB.Count_And_Get(

2105: -- Call to indicate account update to DQM
2106: HZ_DQM_SYNC.sync_cust_account(l_cust_account_rec.CUST_ACCOUNT_ID,'U');
2107:
2108: -- Standard call to get message count and if count is 1, get message info.
2109: FND_MSG_PUB.Count_And_Get(
2110: p_encoded => FND_API.G_FALSE,
2111: p_count => x_msg_count,
2112: p_data => x_msg_data );
2113:

Line 2135: FND_MSG_PUB.Count_And_Get(

2131: WHEN FND_API.G_EXC_ERROR THEN
2132: ROLLBACK TO update_cust_account;
2133: x_return_status := FND_API.G_RET_STS_ERROR;
2134:
2135: FND_MSG_PUB.Count_And_Get(
2136: p_encoded => FND_API.G_FALSE,
2137: p_count => x_msg_count,
2138: p_data => x_msg_data );
2139:

Line 2161: FND_MSG_PUB.Count_And_Get(

2157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2158: ROLLBACK TO update_cust_account;
2159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2160:
2161: FND_MSG_PUB.Count_And_Get(
2162: p_encoded => FND_API.G_FALSE,
2163: p_count => x_msg_count,
2164: p_data => x_msg_data );
2165:

Line 2189: FND_MSG_PUB.ADD;

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,
2193: p_count => x_msg_count,

Line 2191: FND_MSG_PUB.Count_And_Get(

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,
2193: p_count => x_msg_count,
2194: p_data => x_msg_data );
2195:

Line 2275: FND_MSG_PUB.initialize;

2271: END IF;
2272:
2273: -- Initialize message list if p_init_msg_list is set to TRUE.
2274: IF FND_API.to_Boolean(p_init_msg_list) THEN
2275: FND_MSG_PUB.initialize;
2276: END IF;
2277:
2278: -- Initialize message list if p_init_msg_list is set to TRUE.
2279: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 2280: FND_MSG_PUB.initialize;

2276: END IF;
2277:
2278: -- Initialize message list if p_init_msg_list is set to TRUE.
2279: IF FND_API.to_Boolean(p_init_msg_list) THEN
2280: FND_MSG_PUB.initialize;
2281: END IF;
2282:
2283: -- Initialize API return status to success.
2284: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2291: FND_MSG_PUB.ADD;

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:
2295: x_cust_account_rec.cust_account_id := p_cust_account_id;

Line 2435: FND_MSG_PUB.Count_And_Get(

2431: END IF;
2432: END IF;
2433:
2434: -- Standard call to get message count and if count is 1, get message info.
2435: FND_MSG_PUB.Count_And_Get(
2436: p_encoded => FND_API.G_FALSE,
2437: p_count => x_msg_count,
2438: p_data => x_msg_data );
2439:

Line 2460: FND_MSG_PUB.Count_And_Get(

2456: EXCEPTION
2457: WHEN FND_API.G_EXC_ERROR THEN
2458: x_return_status := FND_API.G_RET_STS_ERROR;
2459:
2460: FND_MSG_PUB.Count_And_Get(
2461: p_encoded => FND_API.G_FALSE,
2462: p_count => x_msg_count,
2463: p_data => x_msg_data );
2464:

Line 2485: FND_MSG_PUB.Count_And_Get(

2481:
2482: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2484:
2485: FND_MSG_PUB.Count_And_Get(
2486: p_encoded => FND_API.G_FALSE,
2487: p_count => x_msg_count,
2488: p_data => x_msg_data );
2489:

Line 2513: FND_MSG_PUB.ADD;

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,
2517: p_count => x_msg_count,

Line 2515: FND_MSG_PUB.Count_And_Get(

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,
2517: p_count => x_msg_count,
2518: p_data => x_msg_data );
2519:

Line 2647: FND_MSG_PUB.initialize;

2643: END IF;
2644:
2645: -- Initialize message list if p_init_msg_list is set to TRUE.
2646: IF FND_API.to_Boolean(p_init_msg_list) THEN
2647: FND_MSG_PUB.initialize;
2648: END IF;
2649:
2650: -- Initialize API return status to success.
2651: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2676: FND_MSG_PUB.Count_And_Get(

2672: END IF;
2673: END IF;
2674:
2675: -- Standard call to get message count and if count is 1, get message info.
2676: FND_MSG_PUB.Count_And_Get(
2677: p_encoded => FND_API.G_FALSE,
2678: p_count => x_msg_count,
2679: p_data => x_msg_data );
2680:

Line 2702: FND_MSG_PUB.Count_And_Get(

2698: WHEN FND_API.G_EXC_ERROR THEN
2699: ROLLBACK TO create_cust_acct_relate;
2700: x_return_status := FND_API.G_RET_STS_ERROR;
2701:
2702: FND_MSG_PUB.Count_And_Get(
2703: p_encoded => FND_API.G_FALSE,
2704: p_count => x_msg_count,
2705: p_data => x_msg_data );
2706:

Line 2728: FND_MSG_PUB.Count_And_Get(

2724: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2725: ROLLBACK TO create_cust_acct_relate;
2726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2727:
2728: FND_MSG_PUB.Count_And_Get(
2729: p_encoded => FND_API.G_FALSE,
2730: p_count => x_msg_count,
2731: p_data => x_msg_data );
2732:

Line 2756: FND_MSG_PUB.ADD;

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,
2760: p_count => x_msg_count,

Line 2758: FND_MSG_PUB.Count_And_Get(

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,
2760: p_count => x_msg_count,
2761: p_data => x_msg_data );
2762:

Line 2847: FND_MSG_PUB.initialize;

2843: END IF;
2844:
2845: -- Initialize message list if p_init_msg_list is set to TRUE.
2846: IF FND_API.to_Boolean(p_init_msg_list) THEN
2847: FND_MSG_PUB.initialize;
2848: END IF;
2849:
2850: -- Initialize API return status to success.
2851: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2897: FND_MSG_PUB.Count_And_Get(

2893: END IF;
2894: END IF;
2895:
2896: -- Standard call to get message count and if count is 1, get message info.
2897: FND_MSG_PUB.Count_And_Get(
2898: p_encoded => FND_API.G_FALSE,
2899: p_count => x_msg_count,
2900: p_data => x_msg_data );
2901:

Line 2923: FND_MSG_PUB.Count_And_Get(

2919: WHEN FND_API.G_EXC_ERROR THEN
2920: ROLLBACK TO update_cust_acct_relate;
2921: x_return_status := FND_API.G_RET_STS_ERROR;
2922:
2923: FND_MSG_PUB.Count_And_Get(
2924: p_encoded => FND_API.G_FALSE,
2925: p_count => x_msg_count,
2926: p_data => x_msg_data );
2927:

Line 2949: FND_MSG_PUB.Count_And_Get(

2945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2946: ROLLBACK TO update_cust_acct_relate;
2947: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2948:
2949: FND_MSG_PUB.Count_And_Get(
2950: p_encoded => FND_API.G_FALSE,
2951: p_count => x_msg_count,
2952: p_data => x_msg_data );
2953:

Line 2977: FND_MSG_PUB.ADD;

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,
2981: p_count => x_msg_count,

Line 2979: FND_MSG_PUB.Count_And_Get(

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,
2981: p_count => x_msg_count,
2982: p_data => x_msg_data );
2983:

Line 3074: FND_MSG_PUB.initialize;

3070: END IF;
3071:
3072: -- Initialize message list if p_init_msg_list is set to TRUE.
3073: IF FND_API.to_Boolean(p_init_msg_list) THEN
3074: FND_MSG_PUB.initialize;
3075: END IF;
3076:
3077: -- Initialize API return status to success.
3078: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3123: FND_MSG_PUB.Count_And_Get(

3119: END IF;
3120: END IF;
3121:
3122: -- Standard call to get message count and if count is 1, get message info.
3123: FND_MSG_PUB.Count_And_Get(
3124: p_encoded => FND_API.G_FALSE,
3125: p_count => x_msg_count,
3126: p_data => x_msg_data );
3127:

Line 3149: FND_MSG_PUB.Count_And_Get(

3145: WHEN FND_API.G_EXC_ERROR THEN
3146: ROLLBACK TO update_cust_acct_relate;
3147: x_return_status := FND_API.G_RET_STS_ERROR;
3148:
3149: FND_MSG_PUB.Count_And_Get(
3150: p_encoded => FND_API.G_FALSE,
3151: p_count => x_msg_count,
3152: p_data => x_msg_data );
3153:

Line 3175: FND_MSG_PUB.Count_And_Get(

3171: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3172: ROLLBACK TO update_cust_acct_relate;
3173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3174:
3175: FND_MSG_PUB.Count_And_Get(
3176: p_encoded => FND_API.G_FALSE,
3177: p_count => x_msg_count,
3178: p_data => x_msg_data );
3179:

Line 3203: FND_MSG_PUB.ADD;

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,
3207: p_count => x_msg_count,

Line 3205: FND_MSG_PUB.Count_And_Get(

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,
3207: p_count => x_msg_count,
3208: p_data => x_msg_data );
3209:

Line 3294: FND_MSG_PUB.initialize;

3290: END IF;
3291:
3292: -- Initialize message list if p_init_msg_list is set to TRUE.
3293: IF FND_API.to_Boolean(p_init_msg_list) THEN
3294: FND_MSG_PUB.initialize;
3295: END IF;
3296:
3297: -- Initialize API return status to success.
3298: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3307: FND_MSG_PUB.ADD;

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:
3311: IF p_related_cust_account_id IS NULL OR

Line 3315: FND_MSG_PUB.ADD;

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

Line 3409: FND_MSG_PUB.Count_And_Get(

3405: p_msg_level=>fnd_log.level_procedure);
3406: END IF;
3407:
3408: -- Standard call to get message count and if count is 1, get message info.
3409: FND_MSG_PUB.Count_And_Get(
3410: p_encoded => FND_API.G_FALSE,
3411: p_count => x_msg_count,
3412: p_data => x_msg_data );
3413:

Line 3435: FND_MSG_PUB.Count_And_Get(

3431: EXCEPTION
3432: WHEN FND_API.G_EXC_ERROR THEN
3433: x_return_status := FND_API.G_RET_STS_ERROR;
3434:
3435: FND_MSG_PUB.Count_And_Get(
3436: p_encoded => FND_API.G_FALSE,
3437: p_count => x_msg_count,
3438: p_data => x_msg_data );
3439:

Line 3460: FND_MSG_PUB.Count_And_Get(

3456:
3457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3459:
3460: FND_MSG_PUB.Count_And_Get(
3461: p_encoded => FND_API.G_FALSE,
3462: p_count => x_msg_count,
3463: p_data => x_msg_data );
3464:

Line 3487: FND_MSG_PUB.ADD;

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,
3491: p_count => x_msg_count,

Line 3489: FND_MSG_PUB.Count_And_Get(

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,
3491: p_count => x_msg_count,
3492: p_data => x_msg_data );
3493:

Line 3548: FND_MSG_PUB.ADD;

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:
3552: -- check account_liable_flag

Line 3562: FND_MSG_PUB.ADD;

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:
3566: -- check account_termination_date

Line 3576: FND_MSG_PUB.ADD;

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:
3580: -- check acct_life_cycle_status

Line 3590: FND_MSG_PUB.ADD;

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:
3594: -- check current_balance

Line 3604: FND_MSG_PUB.ADD;

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:
3608: -- check department

Line 3618: FND_MSG_PUB.ADD;

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:
3622: -- check dormant_account_flag

Line 3632: FND_MSG_PUB.ADD;

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:
3636: -- check notify_flag

Line 3646: FND_MSG_PUB.ADD;

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:
3650: -- check order_type_id

Line 3660: FND_MSG_PUB.ADD;

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:
3664: -- check primary_salesrep_id

Line 3674: FND_MSG_PUB.ADD;

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:
3678: -- check realtime_rate_flag

Line 3688: FND_MSG_PUB.ADD;

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:
3692: -- check suspension_date

Line 3702: FND_MSG_PUB.ADD;

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:
3706: -- check tax_code

Line 3717: FND_MSG_PUB.ADD;

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: */
3721: END check_obsolete_columns;