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_POPULATE_BOT_PKG dependencies on FND_API

Line 130: RAISE FND_API.G_EXC_ERROR;

126: ELSE
127: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_work_class',
128: p_prefix=>l_debug_prefix,
129: p_msg_level=>fnd_log.level_procedure);
130: RAISE FND_API.G_EXC_ERROR;
131: END IF;
132:
133: FOR c_child_rec IN c_child LOOP
134: -- collect the child info into variables

Line 193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

189: WHEN OTHERS THEN
190: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
191: p_prefix=>l_debug_prefix,
192: p_msg_level=>fnd_log.level_procedure);
193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
194: END pop_hz_work_class;
195:
196: -----------------------------------------------------------------
197: -- Procedure name: pop_hz_role_responsibility()

Line 247: RAISE FND_API.G_EXC_ERROR;

243: ELSE
244: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_role_responsibility',
245: p_prefix=>l_debug_prefix,
246: p_msg_level=>fnd_log.level_procedure);
247: RAISE FND_API.G_EXC_ERROR;
248: END IF;
249:
250: FOR c_child_rec IN C_child LOOP
251: -- collect the child info into variables

Line 303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

299: WHEN OTHERS THEN
300: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
301: p_prefix=>l_debug_prefix,
302: p_msg_level=>fnd_log.level_procedure);
303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
304: END pop_hz_role_responsibility;
305:
306: -----------------------------------------------------------------
307: -- Procedure name: pop_hz_relationships()

Line 364: RAISE FND_API.G_EXC_ERROR;

360: ELSE
361: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_relationships',
362: p_prefix=>l_debug_prefix,
363: p_msg_level=>fnd_log.level_procedure);
364: RAISE FND_API.G_EXC_ERROR;
365: END IF;
366:
367: FOR c_child_rec IN c_child LOOP
368: l_lud := c_child_rec.lud;

Line 447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

443: WHEN OTHERS THEN
444: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
445: p_prefix=>l_debug_prefix,
446: p_msg_level=>fnd_log.level_procedure);
447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
448: END pop_hz_relationships;
449:
450: -----------------------------------------------------------------
451: -- Procedure name: pop_hz_person_profiles()

Line 495: RAISE FND_API.G_EXC_ERROR;

491: ELSE
492: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_person_profiles',
493: p_prefix=>l_debug_prefix,
494: p_msg_level=>fnd_log.level_procedure);
495: RAISE FND_API.G_EXC_ERROR;
496: END IF;
497:
498: FOR c_child_rec IN c_child LOOP
499: -- collect the child info into variables

Line 548: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

544: WHEN OTHERS THEN
545: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
546: p_prefix=>l_debug_prefix,
547: p_msg_level=>fnd_log.level_procedure);
548: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
549: END pop_hz_person_profiles;
550:
551: -----------------------------------------------------------------
552: -- Procedure name: pop_hz_person_language()

Line 596: RAISE FND_API.G_EXC_ERROR;

592: ELSE
593: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_person_language',
594: p_prefix=>l_debug_prefix,
595: p_msg_level=>fnd_log.level_procedure);
596: RAISE FND_API.G_EXC_ERROR;
597: END IF;
598:
599: FOR c_child_rec IN c_child LOOP
600: -- collect the child info into variables

Line 649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

645: WHEN OTHERS THEN
646: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
647: p_prefix=>l_debug_prefix,
648: p_msg_level=>fnd_log.level_procedure);
649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
650: END pop_hz_person_language;
651:
652: -----------------------------------------------------------------
653: -- Procedure name: pop_hz_person_interest()

Line 697: RAISE FND_API.G_EXC_ERROR;

693: ELSE
694: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_person_interest',
695: p_prefix=>l_debug_prefix,
696: p_msg_level=>fnd_log.level_procedure);
697: RAISE FND_API.G_EXC_ERROR;
698: END IF;
699:
700: FOR c_child_rec IN c_child LOOP
701: -- collect the child info into variables

Line 750: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

746: WHEN OTHERS THEN
747: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
748: p_prefix=>l_debug_prefix,
749: p_msg_level=>fnd_log.level_procedure);
750: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
751: END pop_hz_person_interest;
752:
753: -----------------------------------------------------------------
754: -- Procedure name: pop_hz_party_site_uses()

Line 812: RAISE FND_API.G_EXC_ERROR;

808: ELSE
809: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_party_site_uses',
810: p_prefix=>l_debug_prefix,
811: p_msg_level=>fnd_log.level_procedure);
812: RAISE FND_API.G_EXC_ERROR;
813: END IF;
814:
815: FOR c_child_rec IN c_child LOOP
816: -- collect the child info into variables

Line 868: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

864: WHEN OTHERS THEN
865: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
866: p_prefix=>l_debug_prefix,
867: p_msg_level=>fnd_log.level_procedure);
868: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
869: END pop_hz_party_site_uses;
870:
871: -----------------------------------------------------------------
872: -- Procedure name: pop_hz_party_sites()

Line 937: RAISE FND_API.G_EXC_ERROR;

933: ELSE
934: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_party_sites',
935: p_prefix=>l_debug_prefix,
936: p_msg_level=>fnd_log.level_procedure);
937: RAISE FND_API.G_EXC_ERROR;
938: END IF;
939:
940: FOR c_child_rec IN c_child LOOP
941: -- collect the child info into variables

Line 995: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

991: WHEN OTHERS THEN
992: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
993: p_prefix=>l_debug_prefix,
994: p_msg_level=>fnd_log.level_procedure);
995: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
996: END pop_hz_party_sites;
997:
998: -----------------------------------------------------------------
999: -- Procedure name: pop_hz_party_preferences()

Line 1048: RAISE FND_API.G_EXC_ERROR;

1044: ELSE
1045: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_party_preferences',
1046: p_prefix=>l_debug_prefix,
1047: p_msg_level=>fnd_log.level_procedure);
1048: RAISE FND_API.G_EXC_ERROR;
1049: END IF;
1050:
1051: FOR c_child_rec IN c_child LOOP
1052: -- collect the child info into variables

Line 1103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1099: WHEN OTHERS THEN
1100: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
1101: p_prefix=>l_debug_prefix,
1102: p_msg_level=>fnd_log.level_procedure);
1103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1104: END pop_hz_party_preferences;
1105:
1106: -----------------------------------------------------------------
1107: -- Procedure name: pop_hz_org_contact_roles()

Line 1156: RAISE FND_API.G_EXC_ERROR;

1152: ELSE
1153: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_org_contact_roles',
1154: p_prefix=>l_debug_prefix,
1155: p_msg_level=>fnd_log.level_procedure);
1156: RAISE FND_API.G_EXC_ERROR;
1157: END IF;
1158:
1159: FOR c_child_rec IN c_child LOOP
1160: -- collect the child info into variables

Line 1210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1206: WHEN OTHERS THEN
1207: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
1208: p_prefix=>l_debug_prefix,
1209: p_msg_level=>fnd_log.level_procedure);
1210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1211: END pop_hz_org_contact_roles;
1212:
1213: -----------------------------------------------------------------
1214: -- Procedure name: pop_hz_org_contacts()

Line 1264: RAISE FND_API.G_EXC_ERROR;

1260: ELSE
1261: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_org_contacts',
1262: p_prefix=>l_debug_prefix,
1263: p_msg_level=>fnd_log.level_procedure);
1264: RAISE FND_API.G_EXC_ERROR;
1265: END IF;
1266:
1267: FOR c_child_rec IN c_child LOOP
1268: -- collect the child info into variables

Line 1336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1332: WHEN OTHERS THEN
1333: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
1334: p_prefix=>l_debug_prefix,
1335: p_msg_level=>fnd_log.level_procedure);
1336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1337: END pop_hz_org_contacts;
1338:
1339: -----------------------------------------------------------------
1340: -- Procedure name: pop_hz_organization_profiles()

Line 1382: RAISE FND_API.G_EXC_ERROR;

1378: ELSE
1379: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_organization_profiles',
1380: p_prefix=>l_debug_prefix,
1381: p_msg_level=>fnd_log.level_procedure);
1382: RAISE FND_API.G_EXC_ERROR;
1383: END IF;
1384:
1385: FOR c_child_rec IN c_child LOOP
1386: -- collect the child info into variables

Line 1435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1431: WHEN OTHERS THEN
1432: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
1433: p_prefix=>l_debug_prefix,
1434: p_msg_level=>fnd_log.level_procedure);
1435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1436: END pop_hz_organization_profiles;
1437:
1438: -----------------------------------------------------------------
1439: -- Procedure name: pop_hz_locations()

Line 1489: RAISE FND_API.G_EXC_ERROR;

1485: ELSE
1486: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_locations',
1487: p_prefix=>l_debug_prefix,
1488: p_msg_level=>fnd_log.level_procedure);
1489: RAISE FND_API.G_EXC_ERROR;
1490: END IF;
1491:
1492: FOR c_child_rec IN c_child LOOP
1493: l_lud := c_child_rec.lud;

Line 1538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1534: WHEN OTHERS THEN
1535: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
1536: p_prefix=>l_debug_prefix,
1537: p_msg_level=>fnd_log.level_procedure);
1538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1539: END pop_hz_locations;
1540:
1541: -----------------------------------------------------------------
1542: -- Procedure name: pop_hz_financial_reports()

Line 1590: RAISE FND_API.G_EXC_ERROR;

1586: ELSE
1587: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_financial_reports',
1588: p_prefix=>l_debug_prefix,
1589: p_msg_level=>fnd_log.level_procedure);
1590: RAISE FND_API.G_EXC_ERROR;
1591: END IF;
1592:
1593: FOR c_child_rec IN c_child LOOP
1594: -- collect the child info into variables

Line 1652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1648: WHEN OTHERS THEN
1649: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
1650: p_prefix=>l_debug_prefix,
1651: p_msg_level=>fnd_log.level_procedure);
1652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1653: END pop_hz_financial_reports;
1654:
1655: -----------------------------------------------------------------
1656: -- Procedure name: pop_hz_financial_profile()

Line 1704: RAISE FND_API.G_EXC_ERROR;

1700: ELSE
1701: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_financial_profile',
1702: p_prefix=>l_debug_prefix,
1703: p_msg_level=>fnd_log.level_procedure);
1704: RAISE FND_API.G_EXC_ERROR;
1705: END IF;
1706:
1707: FOR c_child_rec IN c_child LOOP
1708: -- collect the child info into variables

Line 1758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1754: WHEN OTHERS THEN
1755: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
1756: p_prefix=>l_debug_prefix,
1757: p_msg_level=>fnd_log.level_procedure);
1758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1759: END pop_hz_financial_profile;
1760:
1761: -----------------------------------------------------------------
1762: -- Procedure name: pop_hz_financial_numbers()

Line 1809: RAISE FND_API.G_EXC_ERROR;

1805: ELSE
1806: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_financial_numbers',
1807: p_prefix=>l_debug_prefix,
1808: p_msg_level=>fnd_log.level_procedure);
1809: RAISE FND_API.G_EXC_ERROR;
1810: END IF;
1811:
1812: FOR c_child_rec IN c_child LOOP
1813: -- collect the child info into variables

Line 1872: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1868: WHEN OTHERS THEN
1869: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
1870: p_prefix=>l_debug_prefix,
1871: p_msg_level=>fnd_log.level_procedure);
1872: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1873: END pop_hz_financial_numbers;
1874:
1875: -----------------------------------------------------------------
1876: -- Procedure name: pop_hz_employment_history()

Line 1922: RAISE FND_API.G_EXC_ERROR;

1918: ELSE
1919: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_employment_history',
1920: p_prefix=>l_debug_prefix,
1921: p_msg_level=>fnd_log.level_procedure);
1922: RAISE FND_API.G_EXC_ERROR;
1923: END IF;
1924:
1925: FOR c_child_rec IN c_child LOOP
1926: -- collect the child info into variables

Line 1983: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1979: WHEN OTHERS THEN
1980: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
1981: p_prefix=>l_debug_prefix,
1982: p_msg_level=>fnd_log.level_procedure);
1983: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1984: END pop_hz_employment_history;
1985:
1986: -----------------------------------------------------------------
1987: -- Procedure name: pop_hz_education()

Line 2031: RAISE FND_API.G_EXC_ERROR;

2027: ELSE
2028: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_education',
2029: p_prefix=>l_debug_prefix,
2030: p_msg_level=>fnd_log.level_procedure);
2031: RAISE FND_API.G_EXC_ERROR;
2032: END IF;
2033:
2034: FOR c_child_rec IN c_child LOOP
2035: -- collect the child info into variables

Line 2084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2080: WHEN OTHERS THEN
2081: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
2082: p_prefix=>l_debug_prefix,
2083: p_msg_level=>fnd_log.level_procedure);
2084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2085: END pop_hz_education;
2086:
2087: -----------------------------------------------------------------
2088: -- Procedure name: pop_hz_cust_site_uses_all()

Line 2134: RAISE FND_API.G_EXC_ERROR;

2130: ELSE
2131: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_cust_site_uses_all',
2132: p_prefix=>l_debug_prefix,
2133: p_msg_level=>fnd_log.level_procedure);
2134: RAISE FND_API.G_EXC_ERROR;
2135: END IF;
2136:
2137: FOR c_child_rec IN c_child LOOP
2138: -- collect the child info into variables

Line 2180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2176: WHEN OTHERS THEN
2177: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
2178: p_prefix=>l_debug_prefix,
2179: p_msg_level=>fnd_log.level_procedure);
2180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2181: END pop_hz_cust_site_uses_all;
2182:
2183: -----------------------------------------------------------------
2184: -- Procedure name: pop_hz_cust_profile_amts()

Line 2235: RAISE FND_API.G_EXC_ERROR;

2231: ELSE
2232: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_cust_profile_amts',
2233: p_prefix=>l_debug_prefix,
2234: p_msg_level=>fnd_log.level_procedure);
2235: RAISE FND_API.G_EXC_ERROR;
2236: END IF;
2237:
2238: FOR c_child_rec IN c_child LOOP
2239: -- collect the child info into variables

Line 2291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2287: WHEN OTHERS THEN
2288: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
2289: p_prefix=>l_debug_prefix,
2290: p_msg_level=>fnd_log.level_procedure);
2291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2292: END pop_hz_cust_profile_amts;
2293:
2294: -----------------------------------------------------------------
2295: -- Procedure name: pop_hz_cust_acct_sites_all()

Line 2346: RAISE FND_API.G_EXC_ERROR;

2342: ELSE
2343: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_cust_acct_sites_all',
2344: p_prefix=>l_debug_prefix,
2345: p_msg_level=>fnd_log.level_procedure);
2346: RAISE FND_API.G_EXC_ERROR;
2347: END IF;
2348:
2349: FOR c_child_rec IN c_child LOOP
2350: -- collect the child info into variables

Line 2400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2396: WHEN OTHERS THEN
2397: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
2398: p_prefix=>l_debug_prefix,
2399: p_msg_level=>fnd_log.level_procedure);
2400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2401: END pop_hz_cust_acct_sites_all;
2402:
2403: -----------------------------------------------------------------
2404: -- Procedure name: pop_hz_cust_acct_relate_all()

Line 2466: RAISE FND_API.G_EXC_ERROR;

2462: ELSE
2463: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_cust_acct_relate_all',
2464: p_prefix=>l_debug_prefix,
2465: p_msg_level=>fnd_log.level_procedure);
2466: RAISE FND_API.G_EXC_ERROR;
2467: END IF;
2468:
2469: FOR c_child_rec IN c_child LOOP
2470: -- collect the child info into variables

Line 2555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2551: WHEN OTHERS THEN
2552: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
2553: p_prefix=>l_debug_prefix,
2554: p_msg_level=>fnd_log.level_procedure);
2555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2556: END pop_hz_cust_acct_relate_all;
2557:
2558: -----------------------------------------------------------------
2559: -- Procedure name: pop_hz_cust_account_roles()

Line 2614: RAISE FND_API.G_EXC_ERROR;

2610: ELSE
2611: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_cust_account_roles',
2612: p_prefix=>l_debug_prefix,
2613: p_msg_level=>fnd_log.level_procedure);
2614: RAISE FND_API.G_EXC_ERROR;
2615: END IF;
2616:
2617: FOR c_child_rec IN c_child LOOP
2618: l_lud := c_child_rec.lud;

Line 2667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2663: WHEN OTHERS THEN
2664: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
2665: p_prefix=>l_debug_prefix,
2666: p_msg_level=>fnd_log.level_procedure);
2667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2668: END pop_hz_cust_account_roles;
2669:
2670: -----------------------------------------------------------------
2671: -- Procedure name: pop_hz_cust_accounts()

Line 2720: RAISE FND_API.G_EXC_ERROR;

2716: ELSE
2717: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_cust_accounts',
2718: p_prefix=>l_debug_prefix,
2719: p_msg_level=>fnd_log.level_procedure);
2720: RAISE FND_API.G_EXC_ERROR;
2721: END IF;
2722:
2723: FOR c_child_rec IN c_child LOOP
2724: -- collect the child info into variables

Line 2773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2769: WHEN OTHERS THEN
2770: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
2771: p_prefix=>l_debug_prefix,
2772: p_msg_level=>fnd_log.level_procedure);
2773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2774: END pop_hz_cust_accounts;
2775:
2776: -----------------------------------------------------------------
2777: -- Procedure name: pop_hz_customer_profiles()

Line 2828: RAISE FND_API.G_EXC_ERROR;

2824: ELSE
2825: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_customer_profiles',
2826: p_prefix=>l_debug_prefix,
2827: p_msg_level=>fnd_log.level_procedure);
2828: RAISE FND_API.G_EXC_ERROR;
2829: END IF;
2830:
2831: FOR c_child_rec IN c_child LOOP
2832: -- collect the child info into variables

Line 2886: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2882: WHEN OTHERS THEN
2883: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
2884: p_prefix=>l_debug_prefix,
2885: p_msg_level=>fnd_log.level_procedure);
2886: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2887: END pop_hz_customer_profiles;
2888:
2889: -----------------------------------------------------------------
2890: -- Procedure name: pop_hz_credit_ratings()

Line 2934: RAISE FND_API.G_EXC_ERROR;

2930: ELSE
2931: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_credit_ratings',
2932: p_prefix=>l_debug_prefix,
2933: p_msg_level=>fnd_log.level_procedure);
2934: RAISE FND_API.G_EXC_ERROR;
2935: END IF;
2936:
2937: FOR c_child_rec IN c_child LOOP
2938: -- collect the child info into variables

Line 2986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2982: WHEN OTHERS THEN
2983: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
2984: p_prefix=>l_debug_prefix,
2985: p_msg_level=>fnd_log.level_procedure);
2986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2987: END pop_hz_credit_ratings;
2988:
2989: -----------------------------------------------------------------
2990: -- Procedure name: pop_hz_contact_preferences()

Line 3072: RAISE FND_API.G_EXC_ERROR;

3068: ELSE
3069: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_contact_preferences',
3070: p_prefix=>l_debug_prefix,
3071: p_msg_level=>fnd_log.level_procedure);
3072: RAISE FND_API.G_EXC_ERROR;
3073: END IF;
3074:
3075: FOR c_child_rec IN c_child LOOP
3076: -- collect the child info into variables

Line 3161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3157: WHEN OTHERS THEN
3158: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
3159: p_prefix=>l_debug_prefix,
3160: p_msg_level=>fnd_log.level_procedure);
3161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3162: END pop_hz_contact_preferences;
3163:
3164: -----------------------------------------------------------------
3165: -- Procedure name: pop_hz_contact_points()

Line 3248: RAISE FND_API.G_EXC_ERROR;

3244: ELSE
3245: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_contact_points',
3246: p_prefix=>l_debug_prefix,
3247: p_msg_level=>fnd_log.level_procedure);
3248: RAISE FND_API.G_EXC_ERROR;
3249: END IF;
3250:
3251: FOR c_child_rec IN c_child LOOP
3252: -- collect the child info into variables

Line 3338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3334: WHEN OTHERS THEN
3335: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
3336: p_prefix=>l_debug_prefix,
3337: p_msg_level=>fnd_log.level_procedure);
3338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3339: END pop_hz_contact_points;
3340:
3341: -----------------------------------------------------------------
3342: -- Procedure name: pop_hz_code_assignments()

Line 3387: RAISE FND_API.G_EXC_ERROR;

3383: ELSE
3384: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_code_assignments',
3385: p_prefix=>l_debug_prefix,
3386: p_msg_level=>fnd_log.level_procedure);
3387: RAISE FND_API.G_EXC_ERROR;
3388: END IF;
3389:
3390: FOR c_child_rec IN c_child LOOP
3391: -- collect the child info into variables

Line 3440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3436: WHEN OTHERS THEN
3437: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
3438: p_prefix=>l_debug_prefix,
3439: p_msg_level=>fnd_log.level_procedure);
3440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3441: END pop_hz_code_assignments;
3442:
3443: -----------------------------------------------------------------
3444: -- Procedure name: pop_hz_citizenship()

Line 3488: RAISE FND_API.G_EXC_ERROR;

3484: ELSE
3485: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_citizenship',
3486: p_prefix=>l_debug_prefix,
3487: p_msg_level=>fnd_log.level_procedure);
3488: RAISE FND_API.G_EXC_ERROR;
3489: END IF;
3490:
3491: FOR c_child_rec IN c_child LOOP
3492: -- collect the child info into variables

Line 3540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3536: WHEN OTHERS THEN
3537: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
3538: p_prefix=>l_debug_prefix,
3539: p_msg_level=>fnd_log.level_procedure);
3540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3541: END pop_hz_citizenship;
3542:
3543: -----------------------------------------------------------------
3544: -- Procedure name: pop_hz_certifications()

Line 3591: RAISE FND_API.G_EXC_ERROR;

3587: ELSE
3588: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_certifications',
3589: p_prefix=>l_debug_prefix,
3590: p_msg_level=>fnd_log.level_procedure);
3591: RAISE FND_API.G_EXC_ERROR;
3592: END IF;
3593:
3594: FOR c_child_rec IN c_child LOOP
3595: l_lud := c_child_rec.lud;

Line 3643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3639: WHEN OTHERS THEN
3640: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
3641: p_prefix=>l_debug_prefix,
3642: p_msg_level=>fnd_log.level_procedure);
3643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3644: END pop_hz_certifications;
3645: -----------------------------------------------------------------
3646: -- Procedure name: pop_HZ_PARTY_USG_ASSIGNMENTS()
3647: -- Purpose: populates BOT for HZ_PARTY_USG_ASSIGNMENTS create or update

Line 3695: RAISE FND_API.G_EXC_ERROR;

3691: ELSE
3692: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_HZ_PARTY_USG_ASSIGNMENTS',
3693: p_prefix=>l_debug_prefix,
3694: p_msg_level=>fnd_log.level_procedure);
3695: RAISE FND_API.G_EXC_ERROR;
3696: END IF;
3697:
3698: FOR c_child_rec IN c_child LOOP
3699: l_lud := c_child_rec.lud;

Line 3747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3743: WHEN OTHERS THEN
3744: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
3745: p_prefix=>l_debug_prefix,
3746: p_msg_level=>fnd_log.level_procedure);
3747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3748: END pop_HZ_PARTY_USG_ASSIGNMENTS;
3749:
3750: -----------------------------------------------------------------
3751: -- Procedure name: pop_hz_extensibility()

Line 3819: RAISE FND_API.G_EXC_ERROR;

3815: ELSE
3816: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_extensibility',
3817: p_prefix=>l_debug_prefix,
3818: p_msg_level=>fnd_log.level_procedure);
3819: RAISE FND_API.G_EXC_ERROR;
3820: END IF;
3821:
3822: IF(p_object_type = 'ORG') THEN
3823: OPEN c_child_org;

Line 3890: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3886: WHEN OTHERS THEN
3887: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
3888: p_prefix=>l_debug_prefix,
3889: p_msg_level=>fnd_log.level_procedure);
3890: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3891: END pop_hz_extensibility;
3892:
3893: -----------------------------------------------------------------
3894: -- Procedure name: pop_ra_cust_receipt_methods()

Line 3953: RAISE FND_API.G_EXC_ERROR;

3949: ELSE
3950: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_ra_cust_receipt_methods',
3951: p_prefix=>l_debug_prefix,
3952: p_msg_level=>fnd_log.level_procedure);
3953: RAISE FND_API.G_EXC_ERROR;
3954: END IF;
3955:
3956: FOR c_child_rec IN c_child LOOP
3957: l_lud := c_child_rec.lud;

Line 4009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4005: WHEN OTHERS THEN
4006: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
4007: p_prefix=>l_debug_prefix,
4008: p_msg_level=>fnd_log.level_procedure);
4009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4010: END pop_ra_cust_receipt_methods;
4011:
4012: FUNCTION is_valid_ps(
4013: p_party_site_id IN NUMBER