DBA Data[Home] [Help]

APPS.ARH_ADDR_PKG dependencies on FND_MESSAGE

Line 738: fnd_message.set_name('AR','AR_CUST_ADDR_REF_EXISTS');

734: where addr.orig_system_reference = p_orig_system_reference;
735: --
736: --
737: if ( dummy >=1 ) then
738: fnd_message.set_name('AR','AR_CUST_ADDR_REF_EXISTS');
739: app_exception.raise_exception;
740: end if;
741: --
742:

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

1505: l_rowid ,
1506: l_object_version_number,
1507: l_last_update_date ;
1508: IF cu_version_location%NOTFOUND THEN
1509: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
1510: FND_MESSAGE.SET_TOKEN('RECORD','hz_locations');
1511: FND_MESSAGE.SET_TOKEN('ID',x_location_id);
1512: FND_MSG_PUB.ADD;
1513: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1510: FND_MESSAGE.SET_TOKEN('RECORD','hz_locations');

1506: l_object_version_number,
1507: l_last_update_date ;
1508: IF cu_version_location%NOTFOUND THEN
1509: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
1510: FND_MESSAGE.SET_TOKEN('RECORD','hz_locations');
1511: FND_MESSAGE.SET_TOKEN('ID',x_location_id);
1512: FND_MSG_PUB.ADD;
1513: x_return_status := FND_API.G_RET_STS_ERROR;
1514: ELSE

Line 1511: FND_MESSAGE.SET_TOKEN('ID',x_location_id);

1507: l_last_update_date ;
1508: IF cu_version_location%NOTFOUND THEN
1509: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
1510: FND_MESSAGE.SET_TOKEN('RECORD','hz_locations');
1511: FND_MESSAGE.SET_TOKEN('ID',x_location_id);
1512: FND_MSG_PUB.ADD;
1513: x_return_status := FND_API.G_RET_STS_ERROR;
1514: ELSE
1515: l_object_version_location := l_object_version_number;

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

1518: --
1519: IF TO_CHAR(X_loc_Last_Update_Date,'DD-MON-YYYY HH:MI:SS') <>
1520: TO_CHAR(l_last_update_date,'DD-MON-YYYY HH:MI:SS')
1521: THEN
1522: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1523: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_locations');
1524: FND_MSG_PUB.ADD;
1525: x_return_status := FND_API.G_RET_STS_ERROR;
1526: END IF;

Line 1523: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_locations');

1519: IF TO_CHAR(X_loc_Last_Update_Date,'DD-MON-YYYY HH:MI:SS') <>
1520: TO_CHAR(l_last_update_date,'DD-MON-YYYY HH:MI:SS')
1521: THEN
1522: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1523: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_locations');
1524: FND_MSG_PUB.ADD;
1525: x_return_status := FND_API.G_RET_STS_ERROR;
1526: END IF;
1527: ELSE

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

1543: l_rowid ,
1544: l_object_version_number,
1545: l_last_update_date ;
1546: IF cu_version_party_site%NOTFOUND THEN
1547: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
1548: FND_MESSAGE.SET_TOKEN('RECORD','hz_party_sites');
1549: FND_MESSAGE.SET_TOKEN('ID',x_party_site_id);
1550: FND_MSG_PUB.ADD;
1551: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1548: FND_MESSAGE.SET_TOKEN('RECORD','hz_party_sites');

1544: l_object_version_number,
1545: l_last_update_date ;
1546: IF cu_version_party_site%NOTFOUND THEN
1547: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
1548: FND_MESSAGE.SET_TOKEN('RECORD','hz_party_sites');
1549: FND_MESSAGE.SET_TOKEN('ID',x_party_site_id);
1550: FND_MSG_PUB.ADD;
1551: x_return_status := FND_API.G_RET_STS_ERROR;
1552: ELSE

Line 1549: FND_MESSAGE.SET_TOKEN('ID',x_party_site_id);

1545: l_last_update_date ;
1546: IF cu_version_party_site%NOTFOUND THEN
1547: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
1548: FND_MESSAGE.SET_TOKEN('RECORD','hz_party_sites');
1549: FND_MESSAGE.SET_TOKEN('ID',x_party_site_id);
1550: FND_MSG_PUB.ADD;
1551: x_return_status := FND_API.G_RET_STS_ERROR;
1552: ELSE
1553: l_object_version_party_site := l_object_version_number;

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

1556: --
1557: IF TO_CHAR(X_party_site_Last_Update_Date,'DD-MON-YYYY HH:MI:SS') <>
1558: TO_CHAR(l_last_update_date,'DD-MON-YYYY HH:MI:SS')
1559: THEN
1560: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1561: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_party_sites');
1562: FND_MSG_PUB.ADD;
1563: x_return_status := FND_API.G_RET_STS_ERROR;
1564: END IF;

Line 1561: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_party_sites');

1557: IF TO_CHAR(X_party_site_Last_Update_Date,'DD-MON-YYYY HH:MI:SS') <>
1558: TO_CHAR(l_last_update_date,'DD-MON-YYYY HH:MI:SS')
1559: THEN
1560: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1561: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_party_sites');
1562: FND_MSG_PUB.ADD;
1563: x_return_status := FND_API.G_RET_STS_ERROR;
1564: END IF;
1565: ELSE

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

1590: l_rowid ,
1591: l_object_version_number,
1592: l_last_update_date ;
1593: IF cu_version_account_site%NOTFOUND THEN
1594: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
1595: FND_MESSAGE.SET_TOKEN('RECORD','hz_cust_acct_sites');
1596: FND_MESSAGE.SET_TOKEN('ID',x_cust_acct_site_id);
1597: FND_MSG_PUB.ADD;
1598: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1595: FND_MESSAGE.SET_TOKEN('RECORD','hz_cust_acct_sites');

1591: l_object_version_number,
1592: l_last_update_date ;
1593: IF cu_version_account_site%NOTFOUND THEN
1594: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
1595: FND_MESSAGE.SET_TOKEN('RECORD','hz_cust_acct_sites');
1596: FND_MESSAGE.SET_TOKEN('ID',x_cust_acct_site_id);
1597: FND_MSG_PUB.ADD;
1598: x_return_status := FND_API.G_RET_STS_ERROR;
1599: ELSE

Line 1596: FND_MESSAGE.SET_TOKEN('ID',x_cust_acct_site_id);

1592: l_last_update_date ;
1593: IF cu_version_account_site%NOTFOUND THEN
1594: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
1595: FND_MESSAGE.SET_TOKEN('RECORD','hz_cust_acct_sites');
1596: FND_MESSAGE.SET_TOKEN('ID',x_cust_acct_site_id);
1597: FND_MSG_PUB.ADD;
1598: x_return_status := FND_API.G_RET_STS_ERROR;
1599: ELSE
1600: l_object_version_account_site := l_object_version_number;

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

1603: --
1604: IF TO_CHAR(X_Last_Update_Date,'DD-MON-YYYY HH:MI:SS') <>
1605: TO_CHAR(l_last_update_date,'DD-MON-YYYY HH:MI:SS')
1606: THEN
1607: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1608: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_account_sites');
1609: FND_MSG_PUB.ADD;
1610: x_return_status := FND_API.G_RET_STS_ERROR;
1611: END IF;

Line 1608: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_account_sites');

1604: IF TO_CHAR(X_Last_Update_Date,'DD-MON-YYYY HH:MI:SS') <>
1605: TO_CHAR(l_last_update_date,'DD-MON-YYYY HH:MI:SS')
1606: THEN
1607: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1608: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_account_sites');
1609: FND_MSG_PUB.ADD;
1610: x_return_status := FND_API.G_RET_STS_ERROR;
1611: END IF;
1612: ELSE

Line 2064: FND_MESSAGE.SET_NAME( 'AR','AR_NO_ROW_IN_SYSTEM_PARAMETERS');

2060:
2061: --Bug fix 2183072 Handled the exception.
2062: EXCEPTION
2063: WHEN NO_DATA_FOUND THEN
2064: FND_MESSAGE.SET_NAME( 'AR','AR_NO_ROW_IN_SYSTEM_PARAMETERS');
2065: FND_MSG_PUB.ADD;
2066: END ;
2067:
2068: if check_value = 'Y' then

Line 2218: FND_MESSAGE.SET_NAME( 'AR','AR_NO_ROW_IN_SYSTEM_PARAMETERS');

2214:
2215: --Bug fix 2183072 Handled the exception.
2216: EXCEPTION
2217: WHEN NO_DATA_FOUND THEN
2218: FND_MESSAGE.SET_NAME( 'AR','AR_NO_ROW_IN_SYSTEM_PARAMETERS');
2219: FND_MSG_PUB.ADD;
2220: arp_debug.debug(' EXCEPTION AR_NO_ROW_IN_SYSTEM_PARAMETERS in transaction_morg_exists ');
2221: END ;
2222: arp_debug.debug(' check_value :'||check_value);

Line 2458: FND_MESSAGE.SET_NAME( 'AR','4600');

2454: -- changed to call transaction_morg_exists
2455: IF transaction_morg_exists(l_address_id,l_customer_id) THEN
2456: -- transaction existing printed
2457: x_return_status := fnd_api.g_ret_sts_error;
2458: FND_MESSAGE.SET_NAME( 'AR','4600');
2459: FND_MSG_PUB.ADD;
2460: FND_MSG_PUB.Count_And_Get(
2461: p_encoded => FND_API.G_FALSE,
2462: p_count => x_msg_count,

Line 2480: FND_MESSAGE.SET_NAME( 'AR','AR_NO_ROW_IN_SYSTEM_PARAMETERS');

2476: EXCEPTION
2477: WHEN AR_NO_ROW_IN_SYSTEM_PARAMETERS THEN
2478: IF c_org_for_loc%ISOPEN THEN CLOSE c_org_for_loc; END IF;
2479: x_return_status := fnd_api.g_ret_sts_error;
2480: FND_MESSAGE.SET_NAME( 'AR','AR_NO_ROW_IN_SYSTEM_PARAMETERS');
2481: FND_MSG_PUB.ADD;
2482: FND_MSG_PUB.Count_And_Get(
2483: p_encoded => FND_API.G_FALSE,
2484: p_count => x_msg_count,

Line 2489: FND_MESSAGE.SET_NAME( 'FND','FND_GENERIC_MESSAGE');

2485: p_data => x_msg_data);
2486: WHEN OTHERS THEN
2487: IF c_org_for_loc%ISOPEN THEN CLOSE c_org_for_loc; END IF;
2488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2489: FND_MESSAGE.SET_NAME( 'FND','FND_GENERIC_MESSAGE');
2490: FND_MESSAGE.SET_TOKEN('MESSAGE',SQLERRM);
2491: FND_MSG_PUB.ADD;
2492: FND_MSG_PUB.Count_And_Get(
2493: p_encoded => FND_API.G_FALSE,

Line 2490: FND_MESSAGE.SET_TOKEN('MESSAGE',SQLERRM);

2486: WHEN OTHERS THEN
2487: IF c_org_for_loc%ISOPEN THEN CLOSE c_org_for_loc; END IF;
2488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2489: FND_MESSAGE.SET_NAME( 'FND','FND_GENERIC_MESSAGE');
2490: FND_MESSAGE.SET_TOKEN('MESSAGE',SQLERRM);
2491: FND_MSG_PUB.ADD;
2492: FND_MSG_PUB.Count_And_Get(
2493: p_encoded => FND_API.G_FALSE,
2494: p_count => x_msg_count,

Line 2686: FND_MESSAGE.SET_NAME( 'AR','AR_NO_ROW_IN_SYSTEM_PARAMETERS');

2682: EXCEPTION
2683: WHEN AR_NO_ROW_IN_SYSTEM_PARAMETERS THEN
2684: IF c_org_for_loc%ISOPEN THEN CLOSE c_org_for_loc; END IF;
2685: x_return_status := fnd_api.g_ret_sts_error;
2686: FND_MESSAGE.SET_NAME( 'AR','AR_NO_ROW_IN_SYSTEM_PARAMETERS');
2687: FND_MSG_PUB.ADD;
2688: FND_MSG_PUB.Count_And_Get(
2689: p_encoded => FND_API.G_FALSE,
2690: p_count => x_msg_count,

Line 2703: FND_MESSAGE.SET_NAME( 'FND','FND_GENERIC_MESSAGE');

2699: END IF;
2700: WHEN OTHERS THEN
2701: IF c_org_for_loc%ISOPEN THEN CLOSE c_org_for_loc; END IF;
2702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2703: FND_MESSAGE.SET_NAME( 'FND','FND_GENERIC_MESSAGE');
2704: FND_MESSAGE.SET_TOKEN('MESSAGE',SQLERRM);
2705: FND_MSG_PUB.ADD;
2706: FND_MSG_PUB.Count_And_Get(
2707: p_encoded => FND_API.G_FALSE,

Line 2704: FND_MESSAGE.SET_TOKEN('MESSAGE',SQLERRM);

2700: WHEN OTHERS THEN
2701: IF c_org_for_loc%ISOPEN THEN CLOSE c_org_for_loc; END IF;
2702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2703: FND_MESSAGE.SET_NAME( 'FND','FND_GENERIC_MESSAGE');
2704: FND_MESSAGE.SET_TOKEN('MESSAGE',SQLERRM);
2705: FND_MSG_PUB.ADD;
2706: FND_MSG_PUB.Count_And_Get(
2707: p_encoded => FND_API.G_FALSE,
2708: p_count => x_msg_count,

Line 2840: FND_MESSAGE.SET_NAME( 'AR','AR_NO_ROW_IN_SYSTEM_PARAMETERS');

2836: EXCEPTION
2837: WHEN AR_NO_ROW_IN_SYSTEM_PARAMETERS THEN
2838: IF c_org_for_loc%ISOPEN THEN CLOSE c_org_for_loc; END IF;
2839: x_return_status := fnd_api.g_ret_sts_error;
2840: FND_MESSAGE.SET_NAME( 'AR','AR_NO_ROW_IN_SYSTEM_PARAMETERS');
2841: FND_MSG_PUB.ADD;
2842: FND_MSG_PUB.Count_And_Get(
2843: p_encoded => FND_API.G_FALSE,
2844: p_count => x_msg_count,

Line 2857: FND_MESSAGE.SET_NAME( 'FND','FND_GENERIC_MESSAGE');

2853: END IF;
2854: WHEN OTHERS THEN
2855: IF c_org_for_loc%ISOPEN THEN CLOSE c_org_for_loc; END IF;
2856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2857: FND_MESSAGE.SET_NAME( 'FND','FND_GENERIC_MESSAGE');
2858: FND_MESSAGE.SET_TOKEN('MESSAGE',SQLERRM);
2859: FND_MSG_PUB.ADD;
2860: FND_MSG_PUB.Count_And_Get(
2861: p_encoded => FND_API.G_FALSE,

Line 2858: FND_MESSAGE.SET_TOKEN('MESSAGE',SQLERRM);

2854: WHEN OTHERS THEN
2855: IF c_org_for_loc%ISOPEN THEN CLOSE c_org_for_loc; END IF;
2856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2857: FND_MESSAGE.SET_NAME( 'FND','FND_GENERIC_MESSAGE');
2858: FND_MESSAGE.SET_TOKEN('MESSAGE',SQLERRM);
2859: FND_MSG_PUB.ADD;
2860: FND_MSG_PUB.Count_And_Get(
2861: p_encoded => FND_API.G_FALSE,
2862: p_count => x_msg_count,

Line 3460: FND_MESSAGE.SET_NAME( 'AR','AR_NO_ROW_IN_SYSTEM_PARAMETERS');

3456:
3457: --Bug fix 2183072 Handled the exception.
3458: EXCEPTION
3459: WHEN NO_DATA_FOUND THEN
3460: FND_MESSAGE.SET_NAME( 'AR','AR_NO_ROW_IN_SYSTEM_PARAMETERS');
3461: FND_MSG_PUB.ADD;
3462: END ;
3463:
3464: if check_value = 'N' then

Line 3525: fnd_message.set_name('AR','AR_CUST_ADDR_EDI_LOC_EXISTS');

3521: and addr.ece_tp_location_code = p_edi_location
3522: and addr.orig_system_reference <> p_orig_system_reference;
3523: --
3524: if ( dummy >=1 ) then
3525: fnd_message.set_name('AR','AR_CUST_ADDR_EDI_LOC_EXISTS');
3526: app_exception.raise_exception;
3527: end if;
3528: --
3529: end check_unique_edi_location;