DBA Data[Home] [Help]

APPS.ARH_ADDR_PKG dependencies on FND_MSG_PUB

Line 1172: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1168: x_msg_data => x_msg_data );
1169:
1170: IF x_msg_count > 1 THEN
1171: FOR i IN 1..x_msg_count LOOP
1172: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1173: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1174: END LOOP;
1175: x_msg_data := tmp_var1;
1176: END IF;

Line 1193: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1189: x_msg_data => x_msg_data );
1190:
1191: IF x_msg_count > 1 THEN
1192: FOR i IN 1..x_msg_count LOOP
1193: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1194: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1195: END LOOP;
1196: x_msg_data := tmp_var1;
1197: END IF;

Line 1225: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1221: x_loc_id => x_loc_id );
1222:
1223: IF x_msg_count > 1 THEN
1224: FOR i IN 1..x_msg_count LOOP
1225: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1226: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1227: END LOOP;
1228: x_msg_data := tmp_var1;
1229: END IF;

Line 1262: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1258: x_msg_data => x_msg_data );
1259:
1260: IF x_msg_count > 1 THEN
1261: FOR i IN 1..x_msg_count LOOP
1262: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1263: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1264: END LOOP;
1265: x_msg_data := tmp_var1;
1266: END IF;

Line 1512: FND_MSG_PUB.ADD;

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

Line 1524: FND_MSG_PUB.ADD;

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
1528: l_object_version_location := x_object_version_location;

Line 1550: FND_MSG_PUB.ADD;

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

Line 1562: FND_MSG_PUB.ADD;

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
1566: l_object_version_party_site := x_object_version_party_site;

Line 1572: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1568: --
1569:
1570: IF x_msg_count > 1 THEN
1571: FOR i IN 1..x_msg_count LOOP
1572: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1573: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1574: END LOOP;
1575: x_msg_data := tmp_var1;
1576: END IF;

Line 1597: FND_MSG_PUB.ADD;

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

Line 1609: FND_MSG_PUB.ADD;

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
1613: l_object_version_account_site := x_object_version;

Line 1618: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1614: END IF;
1615: --
1616: IF x_msg_count > 1 THEN
1617: FOR i IN 1..x_msg_count LOOP
1618: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1619: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1620: END LOOP;
1621: x_msg_data := tmp_var1;
1622: END IF;

Line 1707: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1703: x_msg_count => x_msg_count);
1704:
1705: IF x_msg_count > 1 THEN
1706: FOR i IN 1..x_msg_count LOOP
1707: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1708: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1709: END LOOP;
1710: x_msg_data := tmp_var1;
1711: END IF;

Line 1832: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1828: x_msg_data => x_msg_data );
1829:
1830: IF x_msg_count > 1 THEN
1831: FOR i IN 1..x_msg_count LOOP
1832: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1833: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1834: END LOOP;
1835: x_msg_data := tmp_var1;
1836: END IF;

Line 1859: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1855: x_msg_data => x_msg_data );
1856:
1857: IF x_msg_count > 1 THEN
1858: FOR i IN 1..x_msg_count LOOP
1859: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1860: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1861: END LOOP;
1862: x_msg_data := tmp_var1;
1863: END IF;

Line 1886: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1882: x_msg_data => x_msg_data );
1883:
1884: IF x_msg_count > 1 THEN
1885: FOR i IN 1..x_msg_count LOOP
1886: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1887: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1888: END LOOP;
1889: x_msg_data := tmp_var1;
1890: END IF;

Line 2065: FND_MSG_PUB.ADD;

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
2069: RETURN (FALSE);

Line 2219: FND_MSG_PUB.ADD;

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);
2223:

Line 2459: FND_MSG_PUB.ADD;

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,
2463: p_data => x_msg_data);

Line 2460: FND_MSG_PUB.Count_And_Get(

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,
2463: p_data => x_msg_data);
2464: EXIT;

Line 2481: FND_MSG_PUB.ADD;

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,
2485: p_data => x_msg_data);

Line 2482: FND_MSG_PUB.Count_And_Get(

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,
2485: p_data => x_msg_data);
2486: WHEN OTHERS THEN

Line 2491: FND_MSG_PUB.ADD;

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,
2495: p_data => x_msg_data);

Line 2492: FND_MSG_PUB.Count_And_Get(

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,
2495: p_data => x_msg_data);
2496: END check_printed_trx;

Line 2687: FND_MSG_PUB.ADD;

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,
2691: p_data => x_msg_data);

Line 2688: FND_MSG_PUB.Count_And_Get(

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,
2691: p_data => x_msg_data);
2692: arp_standard.debug('EXCEPTION AR_NO_ROW_IN_SYSTEM_PARAMETERS in check_printed_trx');

Line 2695: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

2691: p_data => x_msg_data);
2692: arp_standard.debug('EXCEPTION AR_NO_ROW_IN_SYSTEM_PARAMETERS in check_printed_trx');
2693: IF x_msg_count > 1 THEN
2694: FOR i IN 1..x_msg_count LOOP
2695: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
2696: tmp_var1 := tmp_var1 || ' '|| tmp_var;
2697: END LOOP;
2698: x_msg_data := tmp_var1;
2699: END IF;

Line 2705: FND_MSG_PUB.ADD;

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,
2709: p_data => x_msg_data);

Line 2706: FND_MSG_PUB.Count_And_Get(

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,
2709: p_data => x_msg_data);
2710: arp_standard.debug('EXCEPTION OTHERS in check_printed_trx :'||SQLERRM);

Line 2713: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

2709: p_data => x_msg_data);
2710: arp_standard.debug('EXCEPTION OTHERS in check_printed_trx :'||SQLERRM);
2711: IF x_msg_count > 1 THEN
2712: FOR i IN 1..x_msg_count LOOP
2713: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
2714: tmp_var1 := tmp_var1 || ' '|| tmp_var;
2715: END LOOP;
2716: x_msg_data := tmp_var1;
2717: END IF;

Line 2841: FND_MSG_PUB.ADD;

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,
2845: p_data => x_msg_data);

Line 2842: FND_MSG_PUB.Count_And_Get(

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,
2845: p_data => x_msg_data);
2846: arp_standard.debug('EXCEPTION AR_NO_ROW_IN_SYSTEM_PARAMETERS in check_addr_modif_allowed');

Line 2849: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

2845: p_data => x_msg_data);
2846: arp_standard.debug('EXCEPTION AR_NO_ROW_IN_SYSTEM_PARAMETERS in check_addr_modif_allowed');
2847: IF x_msg_count > 1 THEN
2848: FOR i IN 1..x_msg_count LOOP
2849: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
2850: tmp_var1 := tmp_var1 || ' '|| tmp_var;
2851: END LOOP;
2852: x_msg_data := tmp_var1;
2853: END IF;

Line 2859: FND_MSG_PUB.ADD;

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,
2863: p_data => x_msg_data);

Line 2860: FND_MSG_PUB.Count_And_Get(

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,
2863: p_data => x_msg_data);
2864: arp_standard.debug('EXCEPTION OTHERS in check_addr_modif_allowed :'||SQLERRM);

Line 2867: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

2863: p_data => x_msg_data);
2864: arp_standard.debug('EXCEPTION OTHERS in check_addr_modif_allowed :'||SQLERRM);
2865: IF x_msg_count > 1 THEN
2866: FOR i IN 1..x_msg_count LOOP
2867: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
2868: tmp_var1 := tmp_var1 || ' '|| tmp_var;
2869: END LOOP;
2870: x_msg_data := tmp_var1;
2871: END IF;

Line 3348: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

3344: x_msg_data => x_msg_data);
3345:
3346: IF x_msg_count > 1 THEN
3347: FOR i IN 1..x_msg_count LOOP
3348: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
3349: tmp_var1 := tmp_var1 || ' '|| tmp_var;
3350: END LOOP;
3351: x_msg_data := tmp_var1;
3352: END IF;

Line 3461: FND_MSG_PUB.ADD;

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
3465: exit;