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 2463: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3454: IF p_index>1 THEN
3455: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3456: 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);
3457: END IF;
3458: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3459: FND_MSG_PUB.ADD;
3460: RAISE FND_API.G_EXC_ERROR;
3461: ELSE
3462: push_eval;

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

3527: IF p_index>1 THEN
3528: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3529: 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);
3530: END IF;
3531: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3532: FND_MSG_PUB.ADD;
3533: RAISE FND_API.G_EXC_ERROR;
3534: ELSE
3535: push_eval;

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

3639: IF p_index>1 THEN
3640: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3641: 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);
3642: END IF;
3643: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3644: FND_MSG_PUB.ADD;
3645: RAISE FND_API.G_EXC_ERROR;
3646: ELSE
3647: push_eval;

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

3750: IF p_index>1 THEN
3751: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3752: 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);
3753: END IF;
3754: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3755: FND_MSG_PUB.ADD;
3756: RAISE FND_API.G_EXC_ERROR;
3757: ELSE
3758: push_eval;

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

3975: ELSE
3976: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3977: 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);
3978: END IF;
3979: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3980: FND_MSG_PUB.ADD;
3981: RAISE FND_API.G_EXC_ERROR;
3982: END IF;
3983: ELSE

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

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

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

4189: RAISE FND_API.G_EXC_ERROR;
4190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4192: WHEN OTHERS THEN
4193: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4194: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_parties');
4195: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4196: FND_MSG_PUB.ADD;
4197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4192: WHEN OTHERS THEN
4193: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4194: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_parties');
4195: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4196: FND_MSG_PUB.ADD;
4197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4198: END find_parties;

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

4191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4192: WHEN OTHERS THEN
4193: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4194: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_parties');
4195: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4196: FND_MSG_PUB.ADD;
4197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4198: END find_parties;
4199:

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

4400: IF p_index>1 THEN
4401: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4402: 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);
4403: END IF;
4404: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4405: FND_MSG_PUB.ADD;
4406: RAISE FND_API.G_EXC_ERROR;
4407: ELSE
4408: push_eval;

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

4448: IF p_index>1 THEN
4449: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4450: 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);
4451: END IF;
4452: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4453: FND_MSG_PUB.ADD;
4454: RAISE FND_API.G_EXC_ERROR;
4455: ELSE
4456: push_eval;

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

4484: and d.search_context_id = p_search_ctx_id);
4485: exception
4486: when others then
4487: if (instrb(SQLERRM,'DRG-51030')>0) then
4488: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
4489: FND_MSG_PUB.ADD;
4490: RAISE FND_API.G_EXC_ERROR;
4491: elsif (instrb(SQLERRM,'DRG-50943')>0) then
4492: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

4488: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
4489: FND_MSG_PUB.ADD;
4490: RAISE FND_API.G_EXC_ERROR;
4491: elsif (instrb(SQLERRM,'DRG-50943')>0) then
4492: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
4493: FND_MSG_PUB.ADD;
4494: RAISE FND_API.G_EXC_ERROR;
4495: else
4496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4560: IF p_index>1 THEN
4561: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4562: 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);
4563: END IF;
4564: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4565: FND_MSG_PUB.ADD;
4566: RAISE FND_API.G_EXC_ERROR;
4567: ELSE
4568: push_eval;

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

4819: IF p_index>1 THEN
4820: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4821: 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);
4822: END IF;
4823: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4824: FND_MSG_PUB.ADD;
4825: RAISE FND_API.G_EXC_ERROR;
4826: ELSE
4827: push_eval;

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

4932: ELSE
4933: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4934: 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);
4935: END IF;
4936: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4937: FND_MSG_PUB.ADD;
4938: RAISE FND_API.G_EXC_ERROR;
4939: END IF;
4940: ELSE

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

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

5061: RAISE FND_API.G_EXC_ERROR;
5062: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5064: WHEN OTHERS THEN
5065: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5066: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_persons');
5067: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5068: FND_MSG_PUB.ADD;
5069: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5062: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5064: WHEN OTHERS THEN
5065: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5066: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_persons');
5067: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5068: FND_MSG_PUB.ADD;
5069: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5070: END find_persons;

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

5063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5064: WHEN OTHERS THEN
5065: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5066: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_persons');
5067: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5068: FND_MSG_PUB.ADD;
5069: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5070: END find_persons;
5071:

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

5129: RAISE FND_API.G_EXC_ERROR;
5130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5132: WHEN OTHERS THEN
5133: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5134: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_party_details');
5135: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5136: FND_MSG_PUB.ADD;
5137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5132: WHEN OTHERS THEN
5133: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5134: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_party_details');
5135: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5136: FND_MSG_PUB.ADD;
5137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5138: END find_party_details;

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

5131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5132: WHEN OTHERS THEN
5133: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5134: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_party_details');
5135: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5136: FND_MSG_PUB.ADD;
5137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5138: END find_party_details;
5139:

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

5246: RAISE FND_API.G_EXC_ERROR;
5247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5249: WHEN OTHERS THEN
5250: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5251: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_parties');
5252: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5253: FND_MSG_PUB.ADD;
5254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5249: WHEN OTHERS THEN
5250: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5251: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_parties');
5252: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5253: FND_MSG_PUB.ADD;
5254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5255: END find_duplicate_parties;

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

5248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5249: WHEN OTHERS THEN
5250: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5251: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_parties');
5252: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5253: FND_MSG_PUB.ADD;
5254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5255: END find_duplicate_parties;
5256:

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

5331: RAISE FND_API.G_EXC_ERROR;
5332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5334: WHEN OTHERS THEN
5335: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5336: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_party_sites');
5337: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5338: FND_MSG_PUB.ADD;
5339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5334: WHEN OTHERS THEN
5335: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5336: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_party_sites');
5337: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5338: FND_MSG_PUB.ADD;
5339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5340: END find_duplicate_party_sites;

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

5333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5334: WHEN OTHERS THEN
5335: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5336: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_party_sites');
5337: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5338: FND_MSG_PUB.ADD;
5339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5340: END find_duplicate_party_sites;
5341:

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

5420: RAISE FND_API.G_EXC_ERROR;
5421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5423: WHEN OTHERS THEN
5424: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5425: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_contacts');
5426: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5427: FND_MSG_PUB.ADD;
5428: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5423: WHEN OTHERS THEN
5424: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5425: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_contacts');
5426: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5427: FND_MSG_PUB.ADD;
5428: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5429: END find_duplicate_contacts;

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

5422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5423: WHEN OTHERS THEN
5424: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5425: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_contacts');
5426: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5427: FND_MSG_PUB.ADD;
5428: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5429: END find_duplicate_contacts;
5430:

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

5493: RAISE FND_API.G_EXC_ERROR;
5494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5496: WHEN OTHERS THEN
5497: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5498: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_contact_points');
5499: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5500: FND_MSG_PUB.ADD;
5501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5496: WHEN OTHERS THEN
5497: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5498: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_contact_points');
5499: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5500: FND_MSG_PUB.ADD;
5501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5502: END find_duplicate_contact_points;

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

5495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5496: WHEN OTHERS THEN
5497: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5498: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_contact_points');
5499: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5500: FND_MSG_PUB.ADD;
5501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5502: END find_duplicate_contact_points;
5503:

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

5923: RAISE FND_API.G_EXC_ERROR;
5924: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5925: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5926: WHEN OTHERS THEN
5927: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5928: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.call_api_dynamic');
5929: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5930: FND_MSG_PUB.ADD;
5931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5924: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5925: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5926: WHEN OTHERS THEN
5927: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5928: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.call_api_dynamic');
5929: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5930: FND_MSG_PUB.ADD;
5931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5932: END call_api_dynamic;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

6789: RAISE FND_API.G_EXC_ERROR;
6790: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6792: WHEN OTHERS THEN
6793: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6794: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_score_details');
6795: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6796: FND_MSG_PUB.ADD;
6797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6790: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6792: WHEN OTHERS THEN
6793: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6794: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_score_details');
6795: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6796: FND_MSG_PUB.ADD;
6797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6798: END get_score_details;

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

6791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6792: WHEN OTHERS THEN
6793: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6794: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_score_details');
6795: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6796: FND_MSG_PUB.ADD;
6797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6798: END get_score_details;
6799:

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

6899: RAISE FND_API.G_EXC_ERROR;
6900: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6901: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6902: WHEN OTHERS THEN
6903: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6904: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6905: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6906: FND_MSG_PUB.ADD;
6907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6900: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6901: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6902: WHEN OTHERS THEN
6903: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6904: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6905: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6906: FND_MSG_PUB.ADD;
6907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6908: END get_party_for_search;

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

6901: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6902: WHEN OTHERS THEN
6903: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6904: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6905: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6906: FND_MSG_PUB.ADD;
6907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6908: END get_party_for_search;
6909:

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

6945: RAISE FND_API.G_EXC_ERROR;
6946: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6947: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6948: WHEN OTHERS THEN
6949: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6950: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6951: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6952: FND_MSG_PUB.ADD;
6953: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6946: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6947: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6948: WHEN OTHERS THEN
6949: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6950: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6951: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6952: FND_MSG_PUB.ADD;
6953: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6954: END get_search_criteria;

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

6947: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6948: WHEN OTHERS THEN
6949: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6950: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6951: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6952: FND_MSG_PUB.ADD;
6953: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6954: END get_search_criteria;
6955:

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

7033: HZ_PARTY_ACQUIRE.get_known_as(p_party_id , 'PARTY','PARTY_ALL_NAMES');
7034:
7035: EXCEPTION
7036: WHEN OTHERS THEN
7037: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7038: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
7039: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
7040: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7041: FND_MSG_PUB.ADD;

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

7034:
7035: EXCEPTION
7036: WHEN OTHERS THEN
7037: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7038: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
7039: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
7040: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7041: FND_MSG_PUB.ADD;
7042: RAISE FND_API.G_EXC_ERROR;

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

7035: EXCEPTION
7036: WHEN OTHERS THEN
7037: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7038: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
7039: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
7040: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7041: FND_MSG_PUB.ADD;
7042: RAISE FND_API.G_EXC_ERROR;
7043: END get_party_rec;

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

7036: WHEN OTHERS THEN
7037: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7038: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
7039: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
7040: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7041: FND_MSG_PUB.ADD;
7042: RAISE FND_API.G_EXC_ERROR;
7043: END get_party_rec;
7044:

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

7097: END LOOP;
7098:
7099: EXCEPTION
7100: WHEN OTHERS THEN
7101: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7102: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
7103: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
7104: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7105: FND_MSG_PUB.ADD;

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

7098:
7099: EXCEPTION
7100: WHEN OTHERS THEN
7101: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7102: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
7103: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
7104: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7105: FND_MSG_PUB.ADD;
7106: RAISE FND_API.G_EXC_ERROR;

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

7099: EXCEPTION
7100: WHEN OTHERS THEN
7101: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7102: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
7103: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
7104: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7105: FND_MSG_PUB.ADD;
7106: RAISE FND_API.G_EXC_ERROR;
7107: END get_party_site_rec;

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

7100: WHEN OTHERS THEN
7101: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7102: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
7103: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
7104: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7105: FND_MSG_PUB.ADD;
7106: RAISE FND_API.G_EXC_ERROR;
7107: END get_party_site_rec;
7108:

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

7153: END LOOP;
7154:
7155: EXCEPTION
7156: WHEN OTHERS THEN
7157: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7158: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
7159: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
7160: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7161: FND_MSG_PUB.ADD;

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

7154:
7155: EXCEPTION
7156: WHEN OTHERS THEN
7157: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7158: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
7159: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
7160: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7161: FND_MSG_PUB.ADD;
7162: RAISE FND_API.G_EXC_ERROR;

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

7155: EXCEPTION
7156: WHEN OTHERS THEN
7157: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7158: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
7159: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
7160: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7161: FND_MSG_PUB.ADD;
7162: RAISE FND_API.G_EXC_ERROR;
7163: END get_contact_rec;

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

7156: WHEN OTHERS THEN
7157: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7158: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
7159: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
7160: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7161: FND_MSG_PUB.ADD;
7162: RAISE FND_API.G_EXC_ERROR;
7163: END get_contact_rec;
7164:

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

7211: END LOOP;
7212:
7213: EXCEPTION
7214: WHEN OTHERS THEN
7215: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7216: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
7217: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
7218: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7219: FND_MSG_PUB.ADD;

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

7212:
7213: EXCEPTION
7214: WHEN OTHERS THEN
7215: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7216: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
7217: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
7218: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7219: FND_MSG_PUB.ADD;
7220: RAISE FND_API.G_EXC_ERROR;

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

7213: EXCEPTION
7214: WHEN OTHERS THEN
7215: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7216: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
7217: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
7218: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7219: FND_MSG_PUB.ADD;
7220: RAISE FND_API.G_EXC_ERROR;
7221: END get_contact_point_rec;

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

7214: WHEN OTHERS THEN
7215: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7216: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
7217: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
7218: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7219: FND_MSG_PUB.ADD;
7220: RAISE FND_API.G_EXC_ERROR;
7221: END get_contact_point_rec;
7222:

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

7542: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
7543: END IF;
7544: EXCEPTION
7545: WHEN OTHERS THEN
7546: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7547: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
7548: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7549: FND_MSG_PUB.ADD;
7550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7543: END IF;
7544: EXCEPTION
7545: WHEN OTHERS THEN
7546: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7547: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
7548: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7549: FND_MSG_PUB.ADD;
7550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7551: END;

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

7544: EXCEPTION
7545: WHEN OTHERS THEN
7546: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7547: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
7548: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7549: FND_MSG_PUB.ADD;
7550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7551: END;
7552:

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

7749: END IF;
7750: END LOOP;
7751: EXCEPTION
7752: WHEN OTHERS THEN
7753: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7754: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
7755: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7756: FND_MSG_PUB.ADD;
7757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7750: END LOOP;
7751: EXCEPTION
7752: WHEN OTHERS THEN
7753: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7754: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
7755: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7756: FND_MSG_PUB.ADD;
7757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7758: END;

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

7751: EXCEPTION
7752: WHEN OTHERS THEN
7753: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7754: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
7755: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7756: FND_MSG_PUB.ADD;
7757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7758: END;
7759:

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

7791: END IF;
7792: NULL;
7793: EXCEPTION
7794: WHEN OTHERS THEN
7795: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7796: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7797: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7798: FND_MSG_PUB.ADD;
7799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7792: NULL;
7793: EXCEPTION
7794: WHEN OTHERS THEN
7795: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7796: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7797: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7798: FND_MSG_PUB.ADD;
7799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7800: END;

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

7793: EXCEPTION
7794: WHEN OTHERS THEN
7795: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7796: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7797: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7798: FND_MSG_PUB.ADD;
7799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7800: END;
7801:

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

7935: END IF;
7936: END LOOP;
7937: EXCEPTION
7938: WHEN OTHERS THEN
7939: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7940: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7941: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7942: FND_MSG_PUB.ADD;
7943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7936: END LOOP;
7937: EXCEPTION
7938: WHEN OTHERS THEN
7939: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7940: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7941: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7942: FND_MSG_PUB.ADD;
7943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7944: END;

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

7937: EXCEPTION
7938: WHEN OTHERS THEN
7939: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7940: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7941: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7942: FND_MSG_PUB.ADD;
7943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7944: END;
7945:

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

7961: FOR I IN 1..p_contact_point_list.COUNT LOOP
7962: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
7963: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
7964: ) THEN
7965: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7966: FND_MSG_PUB.ADD;
7967: RAISE FND_API.G_EXC_ERROR;
7968: END IF;
7969: END LOOP;

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

8040: EXCEPTION
8041: WHEN FND_API.G_EXC_ERROR THEN
8042: RAISE FND_API.G_EXC_ERROR;
8043: WHEN OTHERS THEN
8044: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8045: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
8046: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8047: FND_MSG_PUB.ADD;
8048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

8041: WHEN FND_API.G_EXC_ERROR THEN
8042: RAISE FND_API.G_EXC_ERROR;
8043: WHEN OTHERS THEN
8044: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8045: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
8046: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8047: FND_MSG_PUB.ADD;
8048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8049: END check_prim_cond;

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

8042: RAISE FND_API.G_EXC_ERROR;
8043: WHEN OTHERS THEN
8044: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8045: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
8046: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8047: FND_MSG_PUB.ADD;
8048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8049: END check_prim_cond;
8050:

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

8104: EXIT WHEN x_secondary;
8105: END LOOP;
8106: EXCEPTION
8107: WHEN OTHERS THEN
8108: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8109: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
8110: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8111: FND_MSG_PUB.ADD;
8112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

8105: END LOOP;
8106: EXCEPTION
8107: WHEN OTHERS THEN
8108: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8109: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
8110: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8111: FND_MSG_PUB.ADD;
8112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8113: END check_party_site_cond;

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

8106: EXCEPTION
8107: WHEN OTHERS THEN
8108: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8109: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
8110: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8111: FND_MSG_PUB.ADD;
8112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8113: END check_party_site_cond;
8114:

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

8152: EXIT WHEN x_secondary;
8153: END LOOP;
8154: EXCEPTION
8155: WHEN OTHERS THEN
8156: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8157: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
8158: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8159: FND_MSG_PUB.ADD;
8160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

8153: END LOOP;
8154: EXCEPTION
8155: WHEN OTHERS THEN
8156: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8157: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
8158: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8159: FND_MSG_PUB.ADD;
8160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8161: END check_contact_cond;

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

8154: EXCEPTION
8155: WHEN OTHERS THEN
8156: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8157: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
8158: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8159: FND_MSG_PUB.ADD;
8160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8161: END check_contact_cond;
8162:

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

8175: x_secondary:= FALSE;
8176:
8177: FOR I IN 1..p_contact_point_list.COUNT LOOP
8178: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
8179: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
8180: FND_MSG_PUB.ADD;
8181: RAISE FND_API.G_EXC_ERROR;
8182: END IF;
8183: END LOOP;

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

8199: EXIT WHEN x_secondary;
8200: END LOOP;
8201: EXCEPTION
8202: WHEN OTHERS THEN
8203: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8204: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
8205: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8206: FND_MSG_PUB.ADD;
8207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

8200: END LOOP;
8201: EXCEPTION
8202: WHEN OTHERS THEN
8203: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8204: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
8205: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8206: FND_MSG_PUB.ADD;
8207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8208: END check_contact_point_cond;

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

8201: EXCEPTION
8202: WHEN OTHERS THEN
8203: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8204: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
8205: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8206: FND_MSG_PUB.ADD;
8207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8208: END check_contact_point_cond;
8209: