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_34 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 1404: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

1400: BEGIN
1401: NULL ;
1402: EXCEPTION
1403: WHEN OTHERS THEN
1404: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1405: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
1406: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1407: FND_MSG_PUB.ADD;
1408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1401: NULL ;
1402: EXCEPTION
1403: WHEN OTHERS THEN
1404: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1405: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
1406: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1407: FND_MSG_PUB.ADD;
1408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1409: END;

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

1402: EXCEPTION
1403: WHEN OTHERS THEN
1404: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1405: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
1406: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1407: FND_MSG_PUB.ADD;
1408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1409: END;
1410:

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

1425: HZ_WORD_CONDITIONS_PKG.set_gbl_condition_rec (36,p_search_list(1).COUNTRY);
1426: END IF ;
1427: EXCEPTION
1428: WHEN OTHERS THEN
1429: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1430: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
1431: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1432: FND_MSG_PUB.ADD;
1433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1426: END IF ;
1427: EXCEPTION
1428: WHEN OTHERS THEN
1429: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1430: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
1431: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1432: FND_MSG_PUB.ADD;
1433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1434: END;

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

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

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

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

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

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

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

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

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

1465: BEGIN
1466: NULL ;
1467: EXCEPTION
1468: WHEN OTHERS THEN
1469: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1470: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
1471: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1472: FND_MSG_PUB.ADD;
1473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1466: NULL ;
1467: EXCEPTION
1468: WHEN OTHERS THEN
1469: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1470: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
1471: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1472: FND_MSG_PUB.ADD;
1473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1474: END;

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

1467: EXCEPTION
1468: WHEN OTHERS THEN
1469: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1470: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
1471: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1472: FND_MSG_PUB.ADD;
1473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1474: END;
1475:

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

1534: IF NOT check_prim_cond (p_party_search_rec,
1535: p_party_site_list,
1536: p_contact_list,
1537: p_contact_point_list) THEN
1538: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
1539: FND_MSG_PUB.ADD;
1540: RAISE FND_API.G_EXC_ERROR;
1541: END IF;
1542: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

1923: ELSE
1924: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1925: END IF;
1926: IF lengthb(l_party_contains_str) > 4000 THEN
1927: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1928: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1929: FND_MSG_PUB.ADD;
1930: RAISE FND_API.G_EXC_ERROR;
1931: END IF;

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

1924: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1925: END IF;
1926: IF lengthb(l_party_contains_str) > 4000 THEN
1927: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1928: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1929: FND_MSG_PUB.ADD;
1930: RAISE FND_API.G_EXC_ERROR;
1931: END IF;
1932: IF (p_match_str = ' AND ' OR p_party_max_score

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

2035: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
2036: END LOOP;
2037: -- Add the search criteria to query string
2038: IF lengthb(l_contains_str) > 4000 THEN
2039: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
2040: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
2041: FND_MSG_PUB.ADD;
2042: RAISE FND_API.G_EXC_ERROR;
2043: END IF;

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

2036: END LOOP;
2037: -- Add the search criteria to query string
2038: IF lengthb(l_contains_str) > 4000 THEN
2039: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
2040: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
2041: FND_MSG_PUB.ADD;
2042: RAISE FND_API.G_EXC_ERROR;
2043: END IF;
2044: x_denorm_str := l_den_contains_str;

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

2125: END IF;
2126: END LOOP;
2127: -- Add the search criteria to query string
2128: IF lengthb(l_contains_str) > 4000 THEN
2129: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
2130: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
2131: FND_MSG_PUB.ADD;
2132: RAISE FND_API.G_EXC_ERROR;
2133: END IF;

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

2126: END LOOP;
2127: -- Add the search criteria to query string
2128: IF lengthb(l_contains_str) > 4000 THEN
2129: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
2130: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
2131: FND_MSG_PUB.ADD;
2132: RAISE FND_API.G_EXC_ERROR;
2133: END IF;
2134: x_denorm_str := l_den_contains_str;

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

2461: END IF;
2462: exception
2463: when others then
2464: if (instrb(SQLERRM,'DRG-51030')>0) then
2465: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2466: FND_MSG_PUB.ADD;
2467: RAISE FND_API.G_EXC_ERROR;
2468: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2469: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2465: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2466: FND_MSG_PUB.ADD;
2467: RAISE FND_API.G_EXC_ERROR;
2468: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2469: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2470: FND_MSG_PUB.ADD;
2471: RAISE FND_API.G_EXC_ERROR;
2472: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2473: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2469: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2470: FND_MSG_PUB.ADD;
2471: RAISE FND_API.G_EXC_ERROR;
2472: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2473: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2474: FND_MSG_PUB.ADD;
2475: RAISE FND_API.G_EXC_ERROR;
2476: else
2477: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

2473: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2474: FND_MSG_PUB.ADD;
2475: RAISE FND_API.G_EXC_ERROR;
2476: else
2477: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2478: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2479: FND_MSG_PUB.ADD;
2480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2481: end if;

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

2474: FND_MSG_PUB.ADD;
2475: RAISE FND_API.G_EXC_ERROR;
2476: else
2477: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2478: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2479: FND_MSG_PUB.ADD;
2480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2481: end if;
2482: END;

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

2706: output_long_strings('Restrict Sql = '||p_restrict_sql);
2707: exception
2708: when others then
2709: if (instrb(SQLERRM,'DRG-51030')>0) then
2710: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2711: FND_MSG_PUB.ADD;
2712: RAISE FND_API.G_EXC_ERROR;
2713: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2714: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2710: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2711: FND_MSG_PUB.ADD;
2712: RAISE FND_API.G_EXC_ERROR;
2713: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2714: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2715: FND_MSG_PUB.ADD;
2716: RAISE FND_API.G_EXC_ERROR;
2717: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2718: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2714: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2715: FND_MSG_PUB.ADD;
2716: RAISE FND_API.G_EXC_ERROR;
2717: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2718: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2719: FND_MSG_PUB.ADD;
2720: RAISE FND_API.G_EXC_ERROR;
2721: else
2722: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

2718: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2719: FND_MSG_PUB.ADD;
2720: RAISE FND_API.G_EXC_ERROR;
2721: else
2722: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2723: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2724: FND_MSG_PUB.ADD;
2725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2726: end if;

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

2719: FND_MSG_PUB.ADD;
2720: RAISE FND_API.G_EXC_ERROR;
2721: else
2722: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2723: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2724: FND_MSG_PUB.ADD;
2725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2726: end if;
2727: END;

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

2853: output_long_strings('Restrict Sql = '||p_restrict_sql);
2854: exception
2855: when others then
2856: if (instrb(SQLERRM,'DRG-51030')>0) then
2857: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2858: FND_MSG_PUB.ADD;
2859: RAISE FND_API.G_EXC_ERROR;
2860: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2861: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2857: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2858: FND_MSG_PUB.ADD;
2859: RAISE FND_API.G_EXC_ERROR;
2860: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2861: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2862: FND_MSG_PUB.ADD;
2863: RAISE FND_API.G_EXC_ERROR;
2864: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2865: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2861: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2862: FND_MSG_PUB.ADD;
2863: RAISE FND_API.G_EXC_ERROR;
2864: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2865: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2866: FND_MSG_PUB.ADD;
2867: RAISE FND_API.G_EXC_ERROR;
2868: else
2869: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

2865: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2866: FND_MSG_PUB.ADD;
2867: RAISE FND_API.G_EXC_ERROR;
2868: else
2869: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2870: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2871: FND_MSG_PUB.ADD;
2872: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2873: end if;

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

2866: FND_MSG_PUB.ADD;
2867: RAISE FND_API.G_EXC_ERROR;
2868: else
2869: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2870: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2871: FND_MSG_PUB.ADD;
2872: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2873: end if;
2874: END;

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

3126: output_long_strings('Restrict Sql = '||p_restrict_sql);
3127: exception
3128: when others then
3129: if (instrb(SQLERRM,'DRG-51030')>0) then
3130: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3131: FND_MSG_PUB.ADD;
3132: RAISE FND_API.G_EXC_ERROR;
3133: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3134: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

3130: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3131: FND_MSG_PUB.ADD;
3132: RAISE FND_API.G_EXC_ERROR;
3133: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3134: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3135: FND_MSG_PUB.ADD;
3136: RAISE FND_API.G_EXC_ERROR;
3137: elsif (instrb(SQLERRM,'ORA-20000')>0) then
3138: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

3134: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3135: FND_MSG_PUB.ADD;
3136: RAISE FND_API.G_EXC_ERROR;
3137: elsif (instrb(SQLERRM,'ORA-20000')>0) then
3138: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3139: FND_MSG_PUB.ADD;
3140: RAISE FND_API.G_EXC_ERROR;
3141: else
3142: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

3138: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3139: FND_MSG_PUB.ADD;
3140: RAISE FND_API.G_EXC_ERROR;
3141: else
3142: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3143: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3144: FND_MSG_PUB.ADD;
3145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3146: end if;

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

3139: FND_MSG_PUB.ADD;
3140: RAISE FND_API.G_EXC_ERROR;
3141: else
3142: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3143: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3144: FND_MSG_PUB.ADD;
3145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3146: end if;
3147: END;

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

3409: IF p_index>1 THEN
3410: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3411: 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);
3412: END IF;
3413: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3414: FND_MSG_PUB.ADD;
3415: RAISE FND_API.G_EXC_ERROR;
3416: ELSE
3417: push_eval;

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

3459: IF p_index>1 THEN
3460: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3461: 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);
3462: END IF;
3463: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3464: FND_MSG_PUB.ADD;
3465: RAISE FND_API.G_EXC_ERROR;
3466: ELSE
3467: push_eval;

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

3532: IF p_index>1 THEN
3533: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3534: 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);
3535: END IF;
3536: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3537: FND_MSG_PUB.ADD;
3538: RAISE FND_API.G_EXC_ERROR;
3539: ELSE
3540: push_eval;

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

3644: IF p_index>1 THEN
3645: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3646: 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);
3647: END IF;
3648: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3649: FND_MSG_PUB.ADD;
3650: RAISE FND_API.G_EXC_ERROR;
3651: ELSE
3652: push_eval;

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

3755: IF p_index>1 THEN
3756: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3757: 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);
3758: END IF;
3759: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3760: FND_MSG_PUB.ADD;
3761: RAISE FND_API.G_EXC_ERROR;
3762: ELSE
3763: push_eval;

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

3980: ELSE
3981: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3982: 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);
3983: END IF;
3984: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3985: FND_MSG_PUB.ADD;
3986: RAISE FND_API.G_EXC_ERROR;
3987: END IF;
3988: ELSE

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

3988: ELSE
3989: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3990: 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);
3991: END IF;
3992: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3993: FND_MSG_PUB.ADD;
3994: RAISE FND_API.G_EXC_ERROR;
3995: END IF;
3996: END IF;

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

4194: RAISE FND_API.G_EXC_ERROR;
4195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4197: WHEN OTHERS THEN
4198: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4199: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_parties');
4200: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4201: FND_MSG_PUB.ADD;
4202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4199: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_parties');

4195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4197: WHEN OTHERS THEN
4198: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4199: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_parties');
4200: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4201: FND_MSG_PUB.ADD;
4202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4203: END find_parties;

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

4196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4197: WHEN OTHERS THEN
4198: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4199: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_parties');
4200: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4201: FND_MSG_PUB.ADD;
4202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4203: END find_parties;
4204:

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

4406: IF p_index>1 THEN
4407: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4408: 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);
4409: END IF;
4410: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4411: FND_MSG_PUB.ADD;
4412: RAISE FND_API.G_EXC_ERROR;
4413: ELSE
4414: push_eval;

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

4456: IF p_index>1 THEN
4457: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4458: 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);
4459: END IF;
4460: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4461: FND_MSG_PUB.ADD;
4462: RAISE FND_API.G_EXC_ERROR;
4463: ELSE
4464: push_eval;

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

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

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

4496: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
4497: FND_MSG_PUB.ADD;
4498: RAISE FND_API.G_EXC_ERROR;
4499: elsif (instrb(SQLERRM,'DRG-50943')>0) then
4500: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
4501: FND_MSG_PUB.ADD;
4502: RAISE FND_API.G_EXC_ERROR;
4503: else
4504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4568: IF p_index>1 THEN
4569: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4570: 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);
4571: END IF;
4572: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4573: FND_MSG_PUB.ADD;
4574: RAISE FND_API.G_EXC_ERROR;
4575: ELSE
4576: push_eval;

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

4827: IF p_index>1 THEN
4828: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4829: 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);
4830: END IF;
4831: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4832: FND_MSG_PUB.ADD;
4833: RAISE FND_API.G_EXC_ERROR;
4834: ELSE
4835: push_eval;

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

4940: ELSE
4941: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4942: 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);
4943: END IF;
4944: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4945: FND_MSG_PUB.ADD;
4946: RAISE FND_API.G_EXC_ERROR;
4947: END IF;
4948: ELSE

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

4948: ELSE
4949: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4950: 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);
4951: END IF;
4952: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4953: FND_MSG_PUB.ADD;
4954: RAISE FND_API.G_EXC_ERROR;
4955: END IF;
4956: END IF;

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

5069: RAISE FND_API.G_EXC_ERROR;
5070: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5072: WHEN OTHERS THEN
5073: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5074: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_persons');
5075: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5076: FND_MSG_PUB.ADD;
5077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5074: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_persons');

5070: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5072: WHEN OTHERS THEN
5073: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5074: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_persons');
5075: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5076: FND_MSG_PUB.ADD;
5077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5078: END find_persons;

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

5071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5072: WHEN OTHERS THEN
5073: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5074: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_persons');
5075: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5076: FND_MSG_PUB.ADD;
5077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5078: END find_persons;
5079:

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

5137: RAISE FND_API.G_EXC_ERROR;
5138: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5140: WHEN OTHERS THEN
5141: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5142: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_party_details');
5143: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5144: FND_MSG_PUB.ADD;
5145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5142: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_party_details');

5138: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5140: WHEN OTHERS THEN
5141: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5142: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_party_details');
5143: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5144: FND_MSG_PUB.ADD;
5145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5146: END find_party_details;

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

5139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5140: WHEN OTHERS THEN
5141: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5142: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_party_details');
5143: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5144: FND_MSG_PUB.ADD;
5145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5146: END find_party_details;
5147:

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

5254: RAISE FND_API.G_EXC_ERROR;
5255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5257: WHEN OTHERS THEN
5258: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5259: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_parties');
5260: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5261: FND_MSG_PUB.ADD;
5262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5259: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_parties');

5255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5257: WHEN OTHERS THEN
5258: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5259: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_parties');
5260: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5261: FND_MSG_PUB.ADD;
5262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5263: END find_duplicate_parties;

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

5256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5257: WHEN OTHERS THEN
5258: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5259: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_parties');
5260: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5261: FND_MSG_PUB.ADD;
5262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5263: END find_duplicate_parties;
5264:

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

5339: RAISE FND_API.G_EXC_ERROR;
5340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5342: WHEN OTHERS THEN
5343: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5344: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_party_sites');
5345: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5346: FND_MSG_PUB.ADD;
5347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5344: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_party_sites');

5340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5342: WHEN OTHERS THEN
5343: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5344: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_party_sites');
5345: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5346: FND_MSG_PUB.ADD;
5347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5348: END find_duplicate_party_sites;

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

5341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5342: WHEN OTHERS THEN
5343: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5344: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_party_sites');
5345: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5346: FND_MSG_PUB.ADD;
5347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5348: END find_duplicate_party_sites;
5349:

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

5428: RAISE FND_API.G_EXC_ERROR;
5429: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5431: WHEN OTHERS THEN
5432: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5433: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_contacts');
5434: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5435: FND_MSG_PUB.ADD;
5436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5433: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_contacts');

5429: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5431: WHEN OTHERS THEN
5432: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5433: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_contacts');
5434: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5435: FND_MSG_PUB.ADD;
5436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5437: END find_duplicate_contacts;

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

5430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5431: WHEN OTHERS THEN
5432: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5433: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_contacts');
5434: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5435: FND_MSG_PUB.ADD;
5436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5437: END find_duplicate_contacts;
5438:

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

5501: RAISE FND_API.G_EXC_ERROR;
5502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5504: WHEN OTHERS THEN
5505: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5506: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_contact_points');
5507: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5508: FND_MSG_PUB.ADD;
5509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5506: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_contact_points');

5502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5504: WHEN OTHERS THEN
5505: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5506: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_contact_points');
5507: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5508: FND_MSG_PUB.ADD;
5509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5510: END find_duplicate_contact_points;

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

5503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5504: WHEN OTHERS THEN
5505: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5506: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_contact_points');
5507: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5508: FND_MSG_PUB.ADD;
5509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5510: END find_duplicate_contact_points;
5511:

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

5931: RAISE FND_API.G_EXC_ERROR;
5932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5934: WHEN OTHERS THEN
5935: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5936: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.call_api_dynamic');
5937: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5938: FND_MSG_PUB.ADD;
5939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5936: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.call_api_dynamic');

5932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5934: WHEN OTHERS THEN
5935: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5936: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.call_api_dynamic');
5937: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5938: FND_MSG_PUB.ADD;
5939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5940: END call_api_dynamic;

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

5933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5934: WHEN OTHERS THEN
5935: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5936: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.call_api_dynamic');
5937: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5938: FND_MSG_PUB.ADD;
5939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5940: END call_api_dynamic;
5941:

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

6175: RAISE FND_API.G_EXC_ERROR;
6176: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6178: WHEN OTHERS THEN
6179: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6180: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_matching_party_sites');
6181: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6182: FND_MSG_PUB.ADD;
6183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6180: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_matching_party_sites');

6176: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6178: WHEN OTHERS THEN
6179: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6180: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_matching_party_sites');
6181: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6182: FND_MSG_PUB.ADD;
6183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6184: END get_matching_party_sites;

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

6177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6178: WHEN OTHERS THEN
6179: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6180: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_matching_party_sites');
6181: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6182: FND_MSG_PUB.ADD;
6183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6184: END get_matching_party_sites;
6185:

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

6403: RAISE FND_API.G_EXC_ERROR;
6404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6406: WHEN OTHERS THEN
6407: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6408: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_matching_contacts');
6409: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6410: FND_MSG_PUB.ADD;
6411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6408: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_matching_contacts');

6404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6406: WHEN OTHERS THEN
6407: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6408: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_matching_contacts');
6409: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6410: FND_MSG_PUB.ADD;
6411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6412: END get_matching_contacts;

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

6405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6406: WHEN OTHERS THEN
6407: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6408: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_matching_contacts');
6409: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6410: FND_MSG_PUB.ADD;
6411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6412: END get_matching_contacts;
6413:

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

6545: RAISE FND_API.G_EXC_ERROR;
6546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6548: WHEN OTHERS THEN
6549: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6550: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_matching_contact_points');
6551: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6552: FND_MSG_PUB.ADD;
6553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6550: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_matching_contact_points');

6546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6548: WHEN OTHERS THEN
6549: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6550: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_matching_contact_points');
6551: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6552: FND_MSG_PUB.ADD;
6553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6554: END get_matching_contact_points;

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

6547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6548: WHEN OTHERS THEN
6549: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6550: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_matching_contact_points');
6551: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6552: FND_MSG_PUB.ADD;
6553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6554: END get_matching_contact_points;
6555:

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

6800: RAISE FND_API.G_EXC_ERROR;
6801: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6803: WHEN OTHERS THEN
6804: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6805: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_score_details');
6806: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6807: FND_MSG_PUB.ADD;
6808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6805: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_score_details');

6801: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6803: WHEN OTHERS THEN
6804: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6805: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_score_details');
6806: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6807: FND_MSG_PUB.ADD;
6808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6809: END get_score_details;

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

6802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6803: WHEN OTHERS THEN
6804: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6805: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_score_details');
6806: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6807: FND_MSG_PUB.ADD;
6808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6809: END get_score_details;
6810:

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

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

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

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

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

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

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

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

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

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

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

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

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

7044: HZ_PARTY_ACQUIRE.get_known_as(p_party_id , 'PARTY','PARTY_ALL_NAMES');
7045:
7046: EXCEPTION
7047: WHEN OTHERS THEN
7048: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7049: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
7050: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
7051: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7052: FND_MSG_PUB.ADD;

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

7045:
7046: EXCEPTION
7047: WHEN OTHERS THEN
7048: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7049: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
7050: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
7051: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7052: FND_MSG_PUB.ADD;
7053: RAISE FND_API.G_EXC_ERROR;

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

7046: EXCEPTION
7047: WHEN OTHERS THEN
7048: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7049: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
7050: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
7051: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7052: FND_MSG_PUB.ADD;
7053: RAISE FND_API.G_EXC_ERROR;
7054: END get_party_rec;

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

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

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

7108: END LOOP;
7109:
7110: EXCEPTION
7111: WHEN OTHERS THEN
7112: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7113: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
7114: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
7115: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7116: FND_MSG_PUB.ADD;

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

7109:
7110: EXCEPTION
7111: WHEN OTHERS THEN
7112: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7113: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
7114: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
7115: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7116: FND_MSG_PUB.ADD;
7117: RAISE FND_API.G_EXC_ERROR;

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

7110: EXCEPTION
7111: WHEN OTHERS THEN
7112: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7113: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
7114: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
7115: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7116: FND_MSG_PUB.ADD;
7117: RAISE FND_API.G_EXC_ERROR;
7118: END get_party_site_rec;

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

7111: WHEN OTHERS THEN
7112: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7113: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
7114: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
7115: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7116: FND_MSG_PUB.ADD;
7117: RAISE FND_API.G_EXC_ERROR;
7118: END get_party_site_rec;
7119:

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

7164: END LOOP;
7165:
7166: EXCEPTION
7167: WHEN OTHERS THEN
7168: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7169: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
7170: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
7171: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7172: FND_MSG_PUB.ADD;

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

7165:
7166: EXCEPTION
7167: WHEN OTHERS THEN
7168: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7169: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
7170: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
7171: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7172: FND_MSG_PUB.ADD;
7173: RAISE FND_API.G_EXC_ERROR;

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

7166: EXCEPTION
7167: WHEN OTHERS THEN
7168: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7169: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
7170: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
7171: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7172: FND_MSG_PUB.ADD;
7173: RAISE FND_API.G_EXC_ERROR;
7174: END get_contact_rec;

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

7167: WHEN OTHERS THEN
7168: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7169: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
7170: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
7171: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7172: FND_MSG_PUB.ADD;
7173: RAISE FND_API.G_EXC_ERROR;
7174: END get_contact_rec;
7175:

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

7222: END LOOP;
7223:
7224: EXCEPTION
7225: WHEN OTHERS THEN
7226: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7227: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
7228: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
7229: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7230: FND_MSG_PUB.ADD;

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

7223:
7224: EXCEPTION
7225: WHEN OTHERS THEN
7226: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7227: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
7228: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
7229: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7230: FND_MSG_PUB.ADD;
7231: RAISE FND_API.G_EXC_ERROR;

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

7224: EXCEPTION
7225: WHEN OTHERS THEN
7226: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7227: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
7228: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
7229: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7230: FND_MSG_PUB.ADD;
7231: RAISE FND_API.G_EXC_ERROR;
7232: END get_contact_point_rec;

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

7225: WHEN OTHERS THEN
7226: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7227: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
7228: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
7229: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7230: FND_MSG_PUB.ADD;
7231: RAISE FND_API.G_EXC_ERROR;
7232: END get_contact_point_rec;
7233:

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

7553: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
7554: END IF;
7555: EXCEPTION
7556: WHEN OTHERS THEN
7557: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7558: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
7559: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7560: FND_MSG_PUB.ADD;
7561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7554: END IF;
7555: EXCEPTION
7556: WHEN OTHERS THEN
7557: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7558: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
7559: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7560: FND_MSG_PUB.ADD;
7561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7562: END;

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

7555: EXCEPTION
7556: WHEN OTHERS THEN
7557: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7558: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
7559: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7560: FND_MSG_PUB.ADD;
7561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7562: END;
7563:

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

7760: END IF;
7761: END LOOP;
7762: EXCEPTION
7763: WHEN OTHERS THEN
7764: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7765: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
7766: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7767: FND_MSG_PUB.ADD;
7768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7761: END LOOP;
7762: EXCEPTION
7763: WHEN OTHERS THEN
7764: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7765: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
7766: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7767: FND_MSG_PUB.ADD;
7768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7769: END;

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

7762: EXCEPTION
7763: WHEN OTHERS THEN
7764: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7765: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
7766: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7767: FND_MSG_PUB.ADD;
7768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7769: END;
7770:

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

7802: END IF;
7803: NULL;
7804: EXCEPTION
7805: WHEN OTHERS THEN
7806: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7807: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7808: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7809: FND_MSG_PUB.ADD;
7810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7803: NULL;
7804: EXCEPTION
7805: WHEN OTHERS THEN
7806: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7807: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7808: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7809: FND_MSG_PUB.ADD;
7810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7811: END;

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

7804: EXCEPTION
7805: WHEN OTHERS THEN
7806: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7807: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7808: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7809: FND_MSG_PUB.ADD;
7810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7811: END;
7812:

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

7946: END IF;
7947: END LOOP;
7948: EXCEPTION
7949: WHEN OTHERS THEN
7950: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7951: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7952: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7953: FND_MSG_PUB.ADD;
7954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7947: END LOOP;
7948: EXCEPTION
7949: WHEN OTHERS THEN
7950: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7951: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7952: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7953: FND_MSG_PUB.ADD;
7954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7955: END;

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

7948: EXCEPTION
7949: WHEN OTHERS THEN
7950: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7951: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7952: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7953: FND_MSG_PUB.ADD;
7954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7955: END;
7956:

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

7972: FOR I IN 1..p_contact_point_list.COUNT LOOP
7973: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
7974: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
7975: ) THEN
7976: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7977: FND_MSG_PUB.ADD;
7978: RAISE FND_API.G_EXC_ERROR;
7979: END IF;
7980: END LOOP;

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

8051: EXCEPTION
8052: WHEN FND_API.G_EXC_ERROR THEN
8053: RAISE FND_API.G_EXC_ERROR;
8054: WHEN OTHERS THEN
8055: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8056: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
8057: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8058: FND_MSG_PUB.ADD;
8059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

8052: WHEN FND_API.G_EXC_ERROR THEN
8053: RAISE FND_API.G_EXC_ERROR;
8054: WHEN OTHERS THEN
8055: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8056: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
8057: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8058: FND_MSG_PUB.ADD;
8059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8060: END check_prim_cond;

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

8053: RAISE FND_API.G_EXC_ERROR;
8054: WHEN OTHERS THEN
8055: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8056: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
8057: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8058: FND_MSG_PUB.ADD;
8059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8060: END check_prim_cond;
8061:

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

8115: EXIT WHEN x_secondary;
8116: END LOOP;
8117: EXCEPTION
8118: WHEN OTHERS THEN
8119: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8120: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
8121: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8122: FND_MSG_PUB.ADD;
8123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

8116: END LOOP;
8117: EXCEPTION
8118: WHEN OTHERS THEN
8119: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8120: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
8121: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8122: FND_MSG_PUB.ADD;
8123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8124: END check_party_site_cond;

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

8117: EXCEPTION
8118: WHEN OTHERS THEN
8119: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8120: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
8121: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8122: FND_MSG_PUB.ADD;
8123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8124: END check_party_site_cond;
8125:

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

8163: EXIT WHEN x_secondary;
8164: END LOOP;
8165: EXCEPTION
8166: WHEN OTHERS THEN
8167: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8168: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
8169: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8170: FND_MSG_PUB.ADD;
8171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

8164: END LOOP;
8165: EXCEPTION
8166: WHEN OTHERS THEN
8167: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8168: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
8169: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8170: FND_MSG_PUB.ADD;
8171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8172: END check_contact_cond;

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

8165: EXCEPTION
8166: WHEN OTHERS THEN
8167: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8168: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
8169: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8170: FND_MSG_PUB.ADD;
8171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8172: END check_contact_cond;
8173:

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

8186: x_secondary:= FALSE;
8187:
8188: FOR I IN 1..p_contact_point_list.COUNT LOOP
8189: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
8190: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
8191: FND_MSG_PUB.ADD;
8192: RAISE FND_API.G_EXC_ERROR;
8193: END IF;
8194: END LOOP;

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

8210: EXIT WHEN x_secondary;
8211: END LOOP;
8212: EXCEPTION
8213: WHEN OTHERS THEN
8214: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8215: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
8216: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8217: FND_MSG_PUB.ADD;
8218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

8211: END LOOP;
8212: EXCEPTION
8213: WHEN OTHERS THEN
8214: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8215: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
8216: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8217: FND_MSG_PUB.ADD;
8218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8219: END check_contact_point_cond;

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

8212: EXCEPTION
8213: WHEN OTHERS THEN
8214: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8215: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
8216: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8217: FND_MSG_PUB.ADD;
8218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8219: END check_contact_point_cond;
8220: