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_MATCH_RULE_42 dependencies on FND_MESSAGE

Line 100: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');

96:
97: exception
98: when others then
99: if (instrb(SQLERRM,'DRG-51030')>0) then
100: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
101: FND_MSG_PUB.ADD;
102: RAISE FND_API.G_EXC_ERROR;
103: elsif (instrb(SQLERRM,'DRG-50943')>0) then
104: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 104: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

100: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
101: FND_MSG_PUB.ADD;
102: RAISE FND_API.G_EXC_ERROR;
103: elsif (instrb(SQLERRM,'DRG-50943')>0) then
104: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
105: FND_MSG_PUB.ADD;
106: RAISE FND_API.G_EXC_ERROR;
107: else
108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1387: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

1383: BEGIN
1384: NULL ;
1385: EXCEPTION
1386: WHEN OTHERS THEN
1387: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1388: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
1389: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1390: FND_MSG_PUB.ADD;
1391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1388: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');

1384: NULL ;
1385: EXCEPTION
1386: WHEN OTHERS THEN
1387: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1388: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
1389: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1390: FND_MSG_PUB.ADD;
1391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1392: END;

Line 1389: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

1385: EXCEPTION
1386: WHEN OTHERS THEN
1387: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1388: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
1389: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1390: FND_MSG_PUB.ADD;
1391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1392: END;
1393:

Line 1412: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

1408: HZ_WORD_CONDITIONS_PKG.set_gbl_condition_rec (36,p_search_list(1).COUNTRY);
1409: END IF ;
1410: EXCEPTION
1411: WHEN OTHERS THEN
1412: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1413: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
1414: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1415: FND_MSG_PUB.ADD;
1416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1413: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');

1409: END IF ;
1410: EXCEPTION
1411: WHEN OTHERS THEN
1412: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1413: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
1414: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1415: FND_MSG_PUB.ADD;
1416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1417: END;

Line 1414: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

1410: EXCEPTION
1411: WHEN OTHERS THEN
1412: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1413: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
1414: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1415: FND_MSG_PUB.ADD;
1416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1417: END;
1418:

Line 1432: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

1428: BEGIN
1429: NULL ;
1430: EXCEPTION
1431: WHEN OTHERS THEN
1432: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1433: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
1434: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1435: FND_MSG_PUB.ADD;
1436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1433: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');

1429: NULL ;
1430: EXCEPTION
1431: WHEN OTHERS THEN
1432: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1433: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
1434: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1435: FND_MSG_PUB.ADD;
1436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1437: END;

Line 1434: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

1430: EXCEPTION
1431: WHEN OTHERS THEN
1432: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1433: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
1434: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1435: FND_MSG_PUB.ADD;
1436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1437: END;
1438:

Line 1452: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

1448: BEGIN
1449: NULL ;
1450: EXCEPTION
1451: WHEN OTHERS THEN
1452: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1453: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
1454: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1455: FND_MSG_PUB.ADD;
1456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1453: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');

1449: NULL ;
1450: EXCEPTION
1451: WHEN OTHERS THEN
1452: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1453: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
1454: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1455: FND_MSG_PUB.ADD;
1456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1457: END;

Line 1454: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

1450: EXCEPTION
1451: WHEN OTHERS THEN
1452: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1453: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
1454: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1455: FND_MSG_PUB.ADD;
1456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1457: END;
1458:

Line 1521: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');

1517: IF NOT check_prim_cond (p_party_search_rec,
1518: p_party_site_list,
1519: p_contact_list,
1520: p_contact_point_list) THEN
1521: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
1522: FND_MSG_PUB.ADD;
1523: RAISE FND_API.G_EXC_ERROR;
1524: END IF;
1525: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1908: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

1904: ELSE
1905: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1906: END IF;
1907: IF lengthb(l_party_contains_str) > 4000 THEN
1908: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1909: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1910: FND_MSG_PUB.ADD;
1911: RAISE FND_API.G_EXC_ERROR;
1912: END IF;

Line 1909: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');

1905: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1906: END IF;
1907: IF lengthb(l_party_contains_str) > 4000 THEN
1908: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1909: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1910: FND_MSG_PUB.ADD;
1911: RAISE FND_API.G_EXC_ERROR;
1912: END IF;
1913: IF (p_match_str = ' AND ' OR p_party_max_score

Line 2027: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

2023: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
2024: END LOOP;
2025: -- Add the search criteria to query string
2026: IF lengthb(l_contains_str) > 4000 THEN
2027: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
2028: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
2029: FND_MSG_PUB.ADD;
2030: RAISE FND_API.G_EXC_ERROR;
2031: END IF;

Line 2028: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');

2024: END LOOP;
2025: -- Add the search criteria to query string
2026: IF lengthb(l_contains_str) > 4000 THEN
2027: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
2028: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
2029: FND_MSG_PUB.ADD;
2030: RAISE FND_API.G_EXC_ERROR;
2031: END IF;
2032: x_denorm_str := l_den_contains_str;

Line 2071: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

2067: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
2068: END LOOP;
2069: -- Add the search criteria to query string
2070: IF lengthb(l_contains_str) > 4000 THEN
2071: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
2072: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');
2073: FND_MSG_PUB.ADD;
2074: RAISE FND_API.G_EXC_ERROR;
2075: END IF;

Line 2072: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');

2068: END LOOP;
2069: -- Add the search criteria to query string
2070: IF lengthb(l_contains_str) > 4000 THEN
2071: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
2072: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');
2073: FND_MSG_PUB.ADD;
2074: RAISE FND_API.G_EXC_ERROR;
2075: END IF;
2076: x_denorm_str := l_den_contains_str;

Line 2152: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

2148: END IF;
2149: END LOOP;
2150: -- Add the search criteria to query string
2151: IF lengthb(l_contains_str) > 4000 THEN
2152: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
2153: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
2154: FND_MSG_PUB.ADD;
2155: RAISE FND_API.G_EXC_ERROR;
2156: END IF;

Line 2153: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');

2149: END LOOP;
2150: -- Add the search criteria to query string
2151: IF lengthb(l_contains_str) > 4000 THEN
2152: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
2153: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
2154: FND_MSG_PUB.ADD;
2155: RAISE FND_API.G_EXC_ERROR;
2156: END IF;
2157: x_denorm_str := l_den_contains_str;

Line 2478: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');

2474: END IF;
2475: exception
2476: when others then
2477: if (instrb(SQLERRM,'DRG-51030')>0) then
2478: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2479: FND_MSG_PUB.ADD;
2480: RAISE FND_API.G_EXC_ERROR;
2481: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2482: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 2482: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

2478: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2479: FND_MSG_PUB.ADD;
2480: RAISE FND_API.G_EXC_ERROR;
2481: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2482: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2483: FND_MSG_PUB.ADD;
2484: RAISE FND_API.G_EXC_ERROR;
2485: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2486: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 2486: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

2482: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2483: FND_MSG_PUB.ADD;
2484: RAISE FND_API.G_EXC_ERROR;
2485: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2486: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2487: FND_MSG_PUB.ADD;
2488: RAISE FND_API.G_EXC_ERROR;
2489: else
2490: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

Line 2490: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

2486: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2487: FND_MSG_PUB.ADD;
2488: RAISE FND_API.G_EXC_ERROR;
2489: else
2490: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2491: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2492: FND_MSG_PUB.ADD;
2493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2494: end if;

Line 2491: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

2487: FND_MSG_PUB.ADD;
2488: RAISE FND_API.G_EXC_ERROR;
2489: else
2490: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2491: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2492: FND_MSG_PUB.ADD;
2493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2494: end if;
2495: END;

Line 2723: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');

2719: output_long_strings('Restrict Sql = '||p_restrict_sql);
2720: exception
2721: when others then
2722: if (instrb(SQLERRM,'DRG-51030')>0) then
2723: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2724: FND_MSG_PUB.ADD;
2725: RAISE FND_API.G_EXC_ERROR;
2726: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2727: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 2727: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

2723: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2724: FND_MSG_PUB.ADD;
2725: RAISE FND_API.G_EXC_ERROR;
2726: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2727: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2728: FND_MSG_PUB.ADD;
2729: RAISE FND_API.G_EXC_ERROR;
2730: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2731: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 2731: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

2727: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2728: FND_MSG_PUB.ADD;
2729: RAISE FND_API.G_EXC_ERROR;
2730: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2731: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2732: FND_MSG_PUB.ADD;
2733: RAISE FND_API.G_EXC_ERROR;
2734: else
2735: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

Line 2735: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

2731: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2732: FND_MSG_PUB.ADD;
2733: RAISE FND_API.G_EXC_ERROR;
2734: else
2735: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2736: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2737: FND_MSG_PUB.ADD;
2738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2739: end if;

Line 2736: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

2732: FND_MSG_PUB.ADD;
2733: RAISE FND_API.G_EXC_ERROR;
2734: else
2735: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2736: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2737: FND_MSG_PUB.ADD;
2738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2739: end if;
2740: END;

Line 2870: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');

2866: output_long_strings('Restrict Sql = '||p_restrict_sql);
2867: exception
2868: when others then
2869: if (instrb(SQLERRM,'DRG-51030')>0) then
2870: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2871: FND_MSG_PUB.ADD;
2872: RAISE FND_API.G_EXC_ERROR;
2873: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2874: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 2874: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

2870: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2871: FND_MSG_PUB.ADD;
2872: RAISE FND_API.G_EXC_ERROR;
2873: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2874: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2875: FND_MSG_PUB.ADD;
2876: RAISE FND_API.G_EXC_ERROR;
2877: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2878: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 2878: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

2874: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2875: FND_MSG_PUB.ADD;
2876: RAISE FND_API.G_EXC_ERROR;
2877: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2878: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2879: FND_MSG_PUB.ADD;
2880: RAISE FND_API.G_EXC_ERROR;
2881: else
2882: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

Line 2882: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

2878: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2879: FND_MSG_PUB.ADD;
2880: RAISE FND_API.G_EXC_ERROR;
2881: else
2882: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2883: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2884: FND_MSG_PUB.ADD;
2885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2886: end if;

Line 2883: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

2879: FND_MSG_PUB.ADD;
2880: RAISE FND_API.G_EXC_ERROR;
2881: else
2882: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2883: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2884: FND_MSG_PUB.ADD;
2885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2886: end if;
2887: END;

Line 3143: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');

3139: output_long_strings('Restrict Sql = '||p_restrict_sql);
3140: exception
3141: when others then
3142: if (instrb(SQLERRM,'DRG-51030')>0) then
3143: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3144: FND_MSG_PUB.ADD;
3145: RAISE FND_API.G_EXC_ERROR;
3146: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3147: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 3147: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

3143: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3144: FND_MSG_PUB.ADD;
3145: RAISE FND_API.G_EXC_ERROR;
3146: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3147: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3148: FND_MSG_PUB.ADD;
3149: RAISE FND_API.G_EXC_ERROR;
3150: elsif (instrb(SQLERRM,'ORA-20000')>0) then
3151: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 3151: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

3147: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3148: FND_MSG_PUB.ADD;
3149: RAISE FND_API.G_EXC_ERROR;
3150: elsif (instrb(SQLERRM,'ORA-20000')>0) then
3151: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3152: FND_MSG_PUB.ADD;
3153: RAISE FND_API.G_EXC_ERROR;
3154: else
3155: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

Line 3155: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

3151: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3152: FND_MSG_PUB.ADD;
3153: RAISE FND_API.G_EXC_ERROR;
3154: else
3155: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3156: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3157: FND_MSG_PUB.ADD;
3158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3159: end if;

Line 3156: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

3152: FND_MSG_PUB.ADD;
3153: RAISE FND_API.G_EXC_ERROR;
3154: else
3155: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3156: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3157: FND_MSG_PUB.ADD;
3158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3159: end if;
3160: END;

Line 3422: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

3418: IF p_index>1 THEN
3419: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3420: hz_utility_v2pub.debug(p_message=>'In eval party level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3421: END IF;
3422: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3423: FND_MSG_PUB.ADD;
3424: RAISE FND_API.G_EXC_ERROR;
3425: ELSE
3426: push_eval;

Line 3472: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

3468: IF p_index>1 THEN
3469: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3470: hz_utility_v2pub.debug(p_message=>'In eval party level estimated hits exceed threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3471: END IF;
3472: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3473: FND_MSG_PUB.ADD;
3474: RAISE FND_API.G_EXC_ERROR;
3475: ELSE
3476: push_eval;

Line 3545: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

3541: IF p_index>1 THEN
3542: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3543: hz_utility_v2pub.debug(p_message=>'In eval party site level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3544: END IF;
3545: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3546: FND_MSG_PUB.ADD;
3547: RAISE FND_API.G_EXC_ERROR;
3548: ELSE
3549: push_eval;

Line 3657: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

3653: IF p_index>1 THEN
3654: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3655: hz_utility_v2pub.debug(p_message=>'In eval contact level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3656: END IF;
3657: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3658: FND_MSG_PUB.ADD;
3659: RAISE FND_API.G_EXC_ERROR;
3660: ELSE
3661: push_eval;

Line 3768: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

3764: IF p_index>1 THEN
3765: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3766: hz_utility_v2pub.debug(p_message=>'In eval contact point level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3767: END IF;
3768: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3769: FND_MSG_PUB.ADD;
3770: RAISE FND_API.G_EXC_ERROR;
3771: ELSE
3772: push_eval;

Line 3993: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

3989: ELSE
3990: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3991: hz_utility_v2pub.debug(p_message=>'In do eval number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3992: END IF;
3993: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3994: FND_MSG_PUB.ADD;
3995: RAISE FND_API.G_EXC_ERROR;
3996: END IF;
3997: ELSE

Line 4001: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

3997: ELSE
3998: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3999: hz_utility_v2pub.debug(p_message=>'In do eval number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4000: END IF;
4001: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4002: FND_MSG_PUB.ADD;
4003: RAISE FND_API.G_EXC_ERROR;
4004: END IF;
4005: END IF;

Line 4207: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

4203: RAISE FND_API.G_EXC_ERROR;
4204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4206: WHEN OTHERS THEN
4207: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4208: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_parties');
4209: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4210: FND_MSG_PUB.ADD;
4211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4208: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_parties');

4204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4206: WHEN OTHERS THEN
4207: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4208: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_parties');
4209: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4210: FND_MSG_PUB.ADD;
4211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4212: END find_parties;

Line 4209: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

4205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4206: WHEN OTHERS THEN
4207: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4208: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_parties');
4209: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4210: FND_MSG_PUB.ADD;
4211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4212: END find_parties;
4213:

Line 4415: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

4411: IF p_index>1 THEN
4412: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4413: hz_utility_v2pub.debug(p_message=>'In eval party level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4414: END IF;
4415: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4416: FND_MSG_PUB.ADD;
4417: RAISE FND_API.G_EXC_ERROR;
4418: ELSE
4419: push_eval;

Line 4465: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

4461: IF p_index>1 THEN
4462: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4463: hz_utility_v2pub.debug(p_message=>'In eval party level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4464: END IF;
4465: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4466: FND_MSG_PUB.ADD;
4467: RAISE FND_API.G_EXC_ERROR;
4468: ELSE
4469: push_eval;

Line 4501: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');

4497: and d.search_context_id = p_search_ctx_id);
4498: exception
4499: when others then
4500: if (instrb(SQLERRM,'DRG-51030')>0) then
4501: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
4502: FND_MSG_PUB.ADD;
4503: RAISE FND_API.G_EXC_ERROR;
4504: elsif (instrb(SQLERRM,'DRG-50943')>0) then
4505: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 4505: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

4501: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
4502: FND_MSG_PUB.ADD;
4503: RAISE FND_API.G_EXC_ERROR;
4504: elsif (instrb(SQLERRM,'DRG-50943')>0) then
4505: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
4506: FND_MSG_PUB.ADD;
4507: RAISE FND_API.G_EXC_ERROR;
4508: else
4509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4577: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

4573: IF p_index>1 THEN
4574: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4575: hz_utility_v2pub.debug(p_message=>'In eval party site level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4576: END IF;
4577: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4578: FND_MSG_PUB.ADD;
4579: RAISE FND_API.G_EXC_ERROR;
4580: ELSE
4581: push_eval;

Line 4836: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

4832: IF p_index>1 THEN
4833: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4834: hz_utility_v2pub.debug(p_message=>'In eval contact point level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4835: END IF;
4836: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4837: FND_MSG_PUB.ADD;
4838: RAISE FND_API.G_EXC_ERROR;
4839: ELSE
4840: push_eval;

Line 4949: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

4945: ELSE
4946: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4947: hz_utility_v2pub.debug(p_message=>'In do eval number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4948: END IF;
4949: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4950: FND_MSG_PUB.ADD;
4951: RAISE FND_API.G_EXC_ERROR;
4952: END IF;
4953: ELSE

Line 4957: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

4953: ELSE
4954: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4955: hz_utility_v2pub.debug(p_message=>'In do eval number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4956: END IF;
4957: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4958: FND_MSG_PUB.ADD;
4959: RAISE FND_API.G_EXC_ERROR;
4960: END IF;
4961: END IF;

Line 5078: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

5074: RAISE FND_API.G_EXC_ERROR;
5075: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5077: WHEN OTHERS THEN
5078: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5079: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_persons');
5080: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5081: FND_MSG_PUB.ADD;
5082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5079: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_persons');

5075: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5077: WHEN OTHERS THEN
5078: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5079: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_persons');
5080: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5081: FND_MSG_PUB.ADD;
5082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5083: END find_persons;

Line 5080: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

5076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5077: WHEN OTHERS THEN
5078: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5079: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_persons');
5080: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5081: FND_MSG_PUB.ADD;
5082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5083: END find_persons;
5084:

Line 5146: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

5142: RAISE FND_API.G_EXC_ERROR;
5143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5145: WHEN OTHERS THEN
5146: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5147: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_party_details');
5148: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5149: FND_MSG_PUB.ADD;
5150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5147: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_party_details');

5143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5145: WHEN OTHERS THEN
5146: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5147: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_party_details');
5148: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5149: FND_MSG_PUB.ADD;
5150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5151: END find_party_details;

Line 5148: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

5144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5145: WHEN OTHERS THEN
5146: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5147: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_party_details');
5148: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5149: FND_MSG_PUB.ADD;
5150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5151: END find_party_details;
5152:

Line 5263: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

5259: RAISE FND_API.G_EXC_ERROR;
5260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5262: WHEN OTHERS THEN
5263: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5264: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_parties');
5265: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5266: FND_MSG_PUB.ADD;
5267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5264: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_parties');

5260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5262: WHEN OTHERS THEN
5263: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5264: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_parties');
5265: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5266: FND_MSG_PUB.ADD;
5267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5268: END find_duplicate_parties;

Line 5265: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

5261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5262: WHEN OTHERS THEN
5263: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5264: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_parties');
5265: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5266: FND_MSG_PUB.ADD;
5267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5268: END find_duplicate_parties;
5269:

Line 5348: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

5344: RAISE FND_API.G_EXC_ERROR;
5345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5347: WHEN OTHERS THEN
5348: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5349: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_party_sites');
5350: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5351: FND_MSG_PUB.ADD;
5352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5349: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_party_sites');

5345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5347: WHEN OTHERS THEN
5348: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5349: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_party_sites');
5350: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5351: FND_MSG_PUB.ADD;
5352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5353: END find_duplicate_party_sites;

Line 5350: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

5346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5347: WHEN OTHERS THEN
5348: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5349: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_party_sites');
5350: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5351: FND_MSG_PUB.ADD;
5352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5353: END find_duplicate_party_sites;
5354:

Line 5437: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

5433: RAISE FND_API.G_EXC_ERROR;
5434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5436: WHEN OTHERS THEN
5437: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5438: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_contacts');
5439: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5440: FND_MSG_PUB.ADD;
5441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5438: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_contacts');

5434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5436: WHEN OTHERS THEN
5437: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5438: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_contacts');
5439: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5440: FND_MSG_PUB.ADD;
5441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5442: END find_duplicate_contacts;

Line 5439: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

5435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5436: WHEN OTHERS THEN
5437: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5438: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_contacts');
5439: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5440: FND_MSG_PUB.ADD;
5441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5442: END find_duplicate_contacts;
5443:

Line 5510: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

5506: RAISE FND_API.G_EXC_ERROR;
5507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5509: WHEN OTHERS THEN
5510: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5511: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_contact_points');
5512: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5513: FND_MSG_PUB.ADD;
5514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5511: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_contact_points');

5507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5509: WHEN OTHERS THEN
5510: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5511: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_contact_points');
5512: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5513: FND_MSG_PUB.ADD;
5514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5515: END find_duplicate_contact_points;

Line 5512: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

5508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5509: WHEN OTHERS THEN
5510: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5511: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_contact_points');
5512: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5513: FND_MSG_PUB.ADD;
5514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5515: END find_duplicate_contact_points;
5516:

Line 5930: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

5926: RAISE FND_API.G_EXC_ERROR;
5927: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5929: WHEN OTHERS THEN
5930: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5931: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.call_api_dynamic');
5932: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5933: FND_MSG_PUB.ADD;
5934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5931: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.call_api_dynamic');

5927: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5929: WHEN OTHERS THEN
5930: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5931: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.call_api_dynamic');
5932: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5933: FND_MSG_PUB.ADD;
5934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5935: END call_api_dynamic;

Line 5932: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

5928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5929: WHEN OTHERS THEN
5930: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5931: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.call_api_dynamic');
5932: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5933: FND_MSG_PUB.ADD;
5934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5935: END call_api_dynamic;
5936:

Line 6172: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

6168: RAISE FND_API.G_EXC_ERROR;
6169: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6171: WHEN OTHERS THEN
6172: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6173: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_matching_party_sites');
6174: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6175: FND_MSG_PUB.ADD;
6176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6173: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_matching_party_sites');

6169: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6171: WHEN OTHERS THEN
6172: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6173: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_matching_party_sites');
6174: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6175: FND_MSG_PUB.ADD;
6176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6177: END get_matching_party_sites;

Line 6174: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

6170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6171: WHEN OTHERS THEN
6172: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6173: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_matching_party_sites');
6174: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6175: FND_MSG_PUB.ADD;
6176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6177: END get_matching_party_sites;
6178:

Line 6400: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

6396: RAISE FND_API.G_EXC_ERROR;
6397: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6399: WHEN OTHERS THEN
6400: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6401: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_matching_contacts');
6402: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6403: FND_MSG_PUB.ADD;
6404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6401: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_matching_contacts');

6397: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6399: WHEN OTHERS THEN
6400: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6401: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_matching_contacts');
6402: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6403: FND_MSG_PUB.ADD;
6404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6405: END get_matching_contacts;

Line 6402: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

6398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6399: WHEN OTHERS THEN
6400: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6401: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_matching_contacts');
6402: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6403: FND_MSG_PUB.ADD;
6404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6405: END get_matching_contacts;
6406:

Line 6541: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

6537: RAISE FND_API.G_EXC_ERROR;
6538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6540: WHEN OTHERS THEN
6541: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6542: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_matching_contact_points');
6543: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6544: FND_MSG_PUB.ADD;
6545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6542: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_matching_contact_points');

6538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6540: WHEN OTHERS THEN
6541: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6542: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_matching_contact_points');
6543: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6544: FND_MSG_PUB.ADD;
6545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6546: END get_matching_contact_points;

Line 6543: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

6539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6540: WHEN OTHERS THEN
6541: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6542: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_matching_contact_points');
6543: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6544: FND_MSG_PUB.ADD;
6545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6546: END get_matching_contact_points;
6547:

Line 6788: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

6784: RAISE FND_API.G_EXC_ERROR;
6785: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6787: WHEN OTHERS THEN
6788: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6789: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_score_details');
6790: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6791: FND_MSG_PUB.ADD;
6792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6789: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_score_details');

6785: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6787: WHEN OTHERS THEN
6788: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6789: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_score_details');
6790: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6791: FND_MSG_PUB.ADD;
6792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6793: END get_score_details;

Line 6790: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

6786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6787: WHEN OTHERS THEN
6788: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6789: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_score_details');
6790: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6791: FND_MSG_PUB.ADD;
6792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6793: END get_score_details;
6794:

Line 6911: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

6907: RAISE FND_API.G_EXC_ERROR;
6908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6909: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6910: WHEN OTHERS THEN
6911: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6912: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6913: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6914: FND_MSG_PUB.ADD;
6915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6912: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

6908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6909: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6910: WHEN OTHERS THEN
6911: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6912: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6913: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6914: FND_MSG_PUB.ADD;
6915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6916: END get_party_for_search;

Line 6913: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

6909: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6910: WHEN OTHERS THEN
6911: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6912: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6913: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6914: FND_MSG_PUB.ADD;
6915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6916: END get_party_for_search;
6917:

Line 6963: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

6959: RAISE FND_API.G_EXC_ERROR;
6960: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6962: WHEN OTHERS THEN
6963: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6964: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6965: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6966: FND_MSG_PUB.ADD;
6967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6964: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

6960: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6962: WHEN OTHERS THEN
6963: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6964: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6965: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6966: FND_MSG_PUB.ADD;
6967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6968: END get_search_criteria;

Line 6965: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

6961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6962: WHEN OTHERS THEN
6963: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6964: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6965: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6966: FND_MSG_PUB.ADD;
6967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6968: END get_search_criteria;
6969:

Line 7053: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');

7049: HZ_PARTY_ACQUIRE.get_account_info(p_party_id , 'PARTY','ALL_ACCOUNT_NUMBERS');
7050:
7051: EXCEPTION
7052: WHEN OTHERS THEN
7053: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7054: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
7055: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
7056: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7057: FND_MSG_PUB.ADD;

Line 7054: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');

7050:
7051: EXCEPTION
7052: WHEN OTHERS THEN
7053: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7054: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
7055: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
7056: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7057: FND_MSG_PUB.ADD;
7058: RAISE FND_API.G_EXC_ERROR;

Line 7055: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);

7051: EXCEPTION
7052: WHEN OTHERS THEN
7053: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7054: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
7055: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
7056: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7057: FND_MSG_PUB.ADD;
7058: RAISE FND_API.G_EXC_ERROR;
7059: END get_party_rec;

Line 7056: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

7052: WHEN OTHERS THEN
7053: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7054: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
7055: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
7056: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7057: FND_MSG_PUB.ADD;
7058: RAISE FND_API.G_EXC_ERROR;
7059: END get_party_rec;
7060:

Line 7119: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');

7115: END LOOP;
7116:
7117: EXCEPTION
7118: WHEN OTHERS THEN
7119: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7120: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
7121: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
7122: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7123: FND_MSG_PUB.ADD;

Line 7120: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');

7116:
7117: EXCEPTION
7118: WHEN OTHERS THEN
7119: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7120: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
7121: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
7122: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7123: FND_MSG_PUB.ADD;
7124: RAISE FND_API.G_EXC_ERROR;

Line 7121: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);

7117: EXCEPTION
7118: WHEN OTHERS THEN
7119: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7120: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
7121: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
7122: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7123: FND_MSG_PUB.ADD;
7124: RAISE FND_API.G_EXC_ERROR;
7125: END get_party_site_rec;

Line 7122: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

7118: WHEN OTHERS THEN
7119: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7120: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
7121: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
7122: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7123: FND_MSG_PUB.ADD;
7124: RAISE FND_API.G_EXC_ERROR;
7125: END get_party_site_rec;
7126:

Line 7177: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');

7173: END LOOP;
7174:
7175: EXCEPTION
7176: WHEN OTHERS THEN
7177: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7178: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
7179: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
7180: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7181: FND_MSG_PUB.ADD;

Line 7178: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');

7174:
7175: EXCEPTION
7176: WHEN OTHERS THEN
7177: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7178: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
7179: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
7180: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7181: FND_MSG_PUB.ADD;
7182: RAISE FND_API.G_EXC_ERROR;

Line 7179: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);

7175: EXCEPTION
7176: WHEN OTHERS THEN
7177: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7178: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
7179: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
7180: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7181: FND_MSG_PUB.ADD;
7182: RAISE FND_API.G_EXC_ERROR;
7183: END get_contact_rec;

Line 7180: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

7176: WHEN OTHERS THEN
7177: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7178: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
7179: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
7180: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7181: FND_MSG_PUB.ADD;
7182: RAISE FND_API.G_EXC_ERROR;
7183: END get_contact_rec;
7184:

Line 7233: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');

7229: END LOOP;
7230:
7231: EXCEPTION
7232: WHEN OTHERS THEN
7233: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7234: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
7235: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
7236: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7237: FND_MSG_PUB.ADD;

Line 7234: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');

7230:
7231: EXCEPTION
7232: WHEN OTHERS THEN
7233: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7234: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
7235: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
7236: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7237: FND_MSG_PUB.ADD;
7238: RAISE FND_API.G_EXC_ERROR;

Line 7235: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);

7231: EXCEPTION
7232: WHEN OTHERS THEN
7233: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7234: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
7235: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
7236: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7237: FND_MSG_PUB.ADD;
7238: RAISE FND_API.G_EXC_ERROR;
7239: END get_contact_point_rec;

Line 7236: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

7232: WHEN OTHERS THEN
7233: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7234: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
7235: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
7236: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7237: FND_MSG_PUB.ADD;
7238: RAISE FND_API.G_EXC_ERROR;
7239: END get_contact_point_rec;
7240:

Line 7500: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

7496: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
7497: END IF;
7498: EXCEPTION
7499: WHEN OTHERS THEN
7500: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7501: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
7502: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7503: FND_MSG_PUB.ADD;
7504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7501: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');

7497: END IF;
7498: EXCEPTION
7499: WHEN OTHERS THEN
7500: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7501: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
7502: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7503: FND_MSG_PUB.ADD;
7504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7505: END;

Line 7502: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

7498: EXCEPTION
7499: WHEN OTHERS THEN
7500: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7501: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
7502: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7503: FND_MSG_PUB.ADD;
7504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7505: END;
7506:

Line 7708: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

7704: END IF;
7705: END LOOP;
7706: EXCEPTION
7707: WHEN OTHERS THEN
7708: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7709: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
7710: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7711: FND_MSG_PUB.ADD;
7712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7709: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');

7705: END LOOP;
7706: EXCEPTION
7707: WHEN OTHERS THEN
7708: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7709: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
7710: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7711: FND_MSG_PUB.ADD;
7712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7713: END;

Line 7710: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

7706: EXCEPTION
7707: WHEN OTHERS THEN
7708: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7709: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
7710: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7711: FND_MSG_PUB.ADD;
7712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7713: END;
7714:

Line 7788: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

7784: END IF;
7785: END LOOP;
7786: EXCEPTION
7787: WHEN OTHERS THEN
7788: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7789: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7790: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7791: FND_MSG_PUB.ADD;
7792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7789: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');

7785: END LOOP;
7786: EXCEPTION
7787: WHEN OTHERS THEN
7788: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7789: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7790: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7791: FND_MSG_PUB.ADD;
7792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7793: END;

Line 7790: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

7786: EXCEPTION
7787: WHEN OTHERS THEN
7788: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7789: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7790: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7791: FND_MSG_PUB.ADD;
7792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7793: END;
7794:

Line 7896: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

7892: END IF;
7893: END LOOP;
7894: EXCEPTION
7895: WHEN OTHERS THEN
7896: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7897: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7898: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7899: FND_MSG_PUB.ADD;
7900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7897: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');

7893: END LOOP;
7894: EXCEPTION
7895: WHEN OTHERS THEN
7896: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7897: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7898: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7899: FND_MSG_PUB.ADD;
7900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7901: END;

Line 7898: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

7894: EXCEPTION
7895: WHEN OTHERS THEN
7896: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7897: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7898: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7899: FND_MSG_PUB.ADD;
7900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7901: END;
7902:

Line 7923: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');

7919: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
7920: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
7921: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
7922: ) THEN
7923: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7924: FND_MSG_PUB.ADD;
7925: RAISE FND_API.G_EXC_ERROR;
7926: END IF;
7927: END LOOP;

Line 8017: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

8013: EXCEPTION
8014: WHEN FND_API.G_EXC_ERROR THEN
8015: RAISE FND_API.G_EXC_ERROR;
8016: WHEN OTHERS THEN
8017: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8018: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
8019: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8020: FND_MSG_PUB.ADD;
8021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8018: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

8014: WHEN FND_API.G_EXC_ERROR THEN
8015: RAISE FND_API.G_EXC_ERROR;
8016: WHEN OTHERS THEN
8017: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8018: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
8019: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8020: FND_MSG_PUB.ADD;
8021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8022: END check_prim_cond;

Line 8019: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

8015: RAISE FND_API.G_EXC_ERROR;
8016: WHEN OTHERS THEN
8017: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8018: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
8019: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8020: FND_MSG_PUB.ADD;
8021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8022: END check_prim_cond;
8023:

Line 8083: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

8079: EXIT WHEN x_secondary;
8080: END LOOP;
8081: EXCEPTION
8082: WHEN OTHERS THEN
8083: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8084: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
8085: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8086: FND_MSG_PUB.ADD;
8087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8084: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');

8080: END LOOP;
8081: EXCEPTION
8082: WHEN OTHERS THEN
8083: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8084: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
8085: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8086: FND_MSG_PUB.ADD;
8087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8088: END check_party_site_cond;

Line 8085: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

8081: EXCEPTION
8082: WHEN OTHERS THEN
8083: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8084: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
8085: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8086: FND_MSG_PUB.ADD;
8087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8088: END check_party_site_cond;
8089:

Line 8139: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

8135: EXIT WHEN x_secondary;
8136: END LOOP;
8137: EXCEPTION
8138: WHEN OTHERS THEN
8139: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8140: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
8141: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8142: FND_MSG_PUB.ADD;
8143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8140: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');

8136: END LOOP;
8137: EXCEPTION
8138: WHEN OTHERS THEN
8139: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8140: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
8141: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8142: FND_MSG_PUB.ADD;
8143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8144: END check_contact_cond;

Line 8141: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

8137: EXCEPTION
8138: WHEN OTHERS THEN
8139: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8140: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
8141: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8142: FND_MSG_PUB.ADD;
8143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8144: END check_contact_cond;
8145:

Line 8162: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');

8158: x_secondary:= FALSE;
8159:
8160: FOR I IN 1..p_contact_point_list.COUNT LOOP
8161: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
8162: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
8163: FND_MSG_PUB.ADD;
8164: RAISE FND_API.G_EXC_ERROR;
8165: END IF;
8166: END LOOP;

Line 8186: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

8182: EXIT WHEN x_secondary;
8183: END LOOP;
8184: EXCEPTION
8185: WHEN OTHERS THEN
8186: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8187: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
8188: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8189: FND_MSG_PUB.ADD;
8190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8187: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');

8183: END LOOP;
8184: EXCEPTION
8185: WHEN OTHERS THEN
8186: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8187: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
8188: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8189: FND_MSG_PUB.ADD;
8190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8191: END check_contact_point_cond;

Line 8188: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

8184: EXCEPTION
8185: WHEN OTHERS THEN
8186: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8187: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
8188: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8189: FND_MSG_PUB.ADD;
8190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8191: END check_contact_point_cond;
8192: