DBA Data[Home] [Help]

APPS.AMS_PARTY_MERGE_PVT dependencies on ARP_MESSAGE

Line 124: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);

120: */
121: END IF;
122: EXCEPTION
123: WHEN OTHERS THEN
124: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
125: x_return_status := FND_API.G_RET_STS_ERROR;
126: raise;
127: END;
128: END IF;

Line 251: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);

247: */
248: END IF;
249: EXCEPTION
250: WHEN OTHERS THEN
251: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
252: x_return_status := FND_API.G_RET_STS_ERROR;
253: raise;
254: END;
255: END IF;

Line 359: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);

355:
356: END IF;
357: EXCEPTION
358: WHEN OTHERS THEN
359: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
360: x_return_status := FND_API.G_RET_STS_ERROR;
361: raise;
362: END;
363: END IF;

Line 467: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);

463:
464: END IF;
465: EXCEPTION
466: WHEN OTHERS THEN
467: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
468: x_return_status := FND_API.G_RET_STS_ERROR;
469: raise;
470: END;
471: END IF;

Line 575: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);

571:
572: END IF;
573: EXCEPTION
574: WHEN OTHERS THEN
575: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
576: x_return_status := FND_API.G_RET_STS_ERROR;
577: raise;
578: END;
579: END IF;

Line 683: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);

679:
680: END IF;
681: EXCEPTION
682: WHEN OTHERS THEN
683: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
684: x_return_status := FND_API.G_RET_STS_ERROR;
685: raise;
686: END;
687: END IF;

Line 791: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);

787:
788: END IF;
789: EXCEPTION
790: WHEN OTHERS THEN
791: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
792: x_return_status := FND_API.G_RET_STS_ERROR;
793: raise;
794: END;
795: END IF;

Line 861: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);

857:
858: END IF;
859: EXCEPTION
860: WHEN OTHERS THEN
861: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
862: x_return_status := FND_API.G_RET_STS_ERROR;
863: raise;
864: END;
865: END IF;

Line 930: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);

926:
927: END IF;
928: EXCEPTION
929: WHEN OTHERS THEN
930: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
931: x_return_status := FND_API.G_RET_STS_ERROR;
932: raise;
933: END;
934: END IF;

Line 999: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);

995:
996: END IF;
997: EXCEPTION
998: WHEN OTHERS THEN
999: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
1000: x_return_status := FND_API.G_RET_STS_ERROR;
1001: raise;
1002: END;
1003: END IF;

Line 1105: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);

1101:
1102: END IF;
1103: EXCEPTION
1104: WHEN OTHERS THEN
1105: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
1106: x_return_status := FND_API.G_RET_STS_ERROR;
1107: raise;
1108: END;
1109: END IF;

Line 1175: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);

1171:
1172: END IF;
1173: EXCEPTION
1174: WHEN OTHERS THEN
1175: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
1176: x_return_status := FND_API.G_RET_STS_ERROR;
1177: raise;
1178: END;
1179: END IF;

Line 1245: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);

1241:
1242: END IF;
1243: EXCEPTION
1244: WHEN OTHERS THEN
1245: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
1246: x_return_status := FND_API.G_RET_STS_ERROR;
1247: raise;
1248: END;
1249: END IF;

Line 1316: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);

1312:
1313: END IF;
1314: EXCEPTION
1315: WHEN OTHERS THEN
1316: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
1317: x_return_status := FND_API.G_RET_STS_ERROR;
1318: raise;
1319: END;
1320: END IF;

Line 1387: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);

1383:
1384: END IF;
1385: EXCEPTION
1386: WHEN OTHERS THEN
1387: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
1388: x_return_status := FND_API.G_RET_STS_ERROR;
1389: raise;
1390: END;
1391: END IF;

Line 1458: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);

1454:
1455: END IF;
1456: EXCEPTION
1457: WHEN OTHERS THEN
1458: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
1459: x_return_status := FND_API.G_RET_STS_ERROR;
1460: raise;
1461: END;
1462: END IF;

Line 1528: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);

1524:
1525: END IF;
1526: EXCEPTION
1527: WHEN OTHERS THEN
1528: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
1529: x_return_status := FND_API.G_RET_STS_ERROR;
1530: raise;
1531: END;
1532: END IF;

Line 1588: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);

1584:
1585: END IF;
1586: EXCEPTION
1587: WHEN OTHERS THEN
1588: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
1589: x_return_status := FND_API.G_RET_STS_ERROR;
1590: raise;
1591: END;
1592: END IF;

Line 1656: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);

1652:
1653: END IF;
1654: EXCEPTION
1655: WHEN OTHERS THEN
1656: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
1657: x_return_status := FND_API.G_RET_STS_ERROR;
1658: raise;
1659: END;
1660: END IF;

Line 1723: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);

1719:
1720: END IF;
1721: EXCEPTION
1722: WHEN OTHERS THEN
1723: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
1724: x_return_status := FND_API.G_RET_STS_ERROR;
1725: raise;
1726: END;
1727: END IF;

Line 1828: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);

1824:
1825: END IF;
1826: EXCEPTION
1827: WHEN OTHERS THEN
1828: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
1829: x_return_status := FND_API.G_RET_STS_ERROR;
1830: raise;
1831: END;
1832: END IF;

Line 1933: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);

1929:
1930: END IF;
1931: EXCEPTION
1932: WHEN OTHERS THEN
1933: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
1934: x_return_status := FND_API.G_RET_STS_ERROR;
1935: raise;
1936: END;
1937: END IF;

Line 2038: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);

2034:
2035: END IF;
2036: EXCEPTION
2037: WHEN OTHERS THEN
2038: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
2039: x_return_status := FND_API.G_RET_STS_ERROR;
2040: raise;
2041: END;
2042: END IF;

Line 2144: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);

2140:
2141: END IF;
2142: EXCEPTION
2143: WHEN OTHERS THEN
2144: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
2145: x_return_status := FND_API.G_RET_STS_ERROR;
2146: raise;
2147: END;
2148: END IF;

Line 2275: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);

2271: END LOOP;
2272: END IF;
2273: EXCEPTION
2274: WHEN OTHERS THEN
2275: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
2276: x_return_status := FND_API.G_RET_STS_ERROR;
2277: raise;
2278: END;
2279: END IF;

Line 2389: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': '|| sqlerrm);

2385:
2386: END IF;
2387: EXCEPTION
2388: WHEN OTHERS THEN
2389: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': '|| sqlerrm);
2390: x_return_status := FND_API.G_RET_STS_ERROR;
2391: raise;
2392: END;
2393: END IF;

Line 2499: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': '|| sqlerrm);

2495:
2496: END IF;
2497: EXCEPTION
2498: WHEN OTHERS THEN
2499: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': '|| sqlerrm);
2500: x_return_status := FND_API.G_RET_STS_ERROR;
2501: raise;
2502: END;
2503: END IF;

Line 2626: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': '|| sqlerrm);

2622: END IF;
2623: EXCEPTION
2624: WHEN OTHERS THEN
2625:
2626: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': '|| sqlerrm);
2627: x_return_status := FND_API.G_RET_STS_ERROR;
2628: raise;
2629: END;
2630: END IF;

Line 2754: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': '|| sqlerrm);

2750: END IF;
2751: EXCEPTION
2752: WHEN OTHERS THEN
2753:
2754: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': '|| sqlerrm);
2755: x_return_status := FND_API.G_RET_STS_ERROR;
2756: raise;
2757: END;
2758: END IF;

Line 2888: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': '|| sqlerrm);

2884:
2885: END IF;
2886: EXCEPTION
2887: WHEN OTHERS THEN
2888: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': '|| sqlerrm);
2889: x_return_status := FND_API.G_RET_STS_ERROR;
2890: raise;
2891: END;
2892: END IF;

Line 2999: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': '|| sqlerrm);

2995:
2996: END IF;
2997: EXCEPTION
2998: WHEN OTHERS THEN
2999: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': '|| sqlerrm);
3000: x_return_status := FND_API.G_RET_STS_ERROR;
3001: raise;
3002: END;
3003: END IF;

Line 3122: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': '|| sqlerrm);

3118: AND f.PREVIEW_ID = t.PREVIEW_ID);
3119: END IF;
3120: EXCEPTION
3121: WHEN OTHERS THEN
3122: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': '|| sqlerrm);
3123: x_return_status := FND_API.G_RET_STS_ERROR;
3124: raise;
3125: END;
3126: END IF;