APPS.HZ_MATCH_RULE_COMPILE dependencies on FND_MESSAGE

Line 543: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_NO_RULE');

539: WHERE match_rule_id = l_rule_id;
540:
541: EXCEPTION
542: WHEN NO_DATA_FOUND THEN
543: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_NO_RULE');
544: FND_MSG_PUB.ADD;
545: RAISE FND_API.G_EXC_ERROR;
546: END;
547:

Line 555: FND_MESSAGE.SET_NAME('AR', 'HZ_RULE_SET_UNCOMP_RULE_EXISTS');

551:
552: --Start of Code Change for Match Rule Set
553: IF (l_match_rule_type = 'SET') THEN
554: IF (has_uncompiled_childern(l_rule_id)) THEN
555: FND_MESSAGE.SET_NAME('AR', 'HZ_RULE_SET_UNCOMP_RULE_EXISTS');
556: FND_MSG_PUB.ADD;
557: RAISE FND_API.G_EXC_ERROR;
558: END IF;
559: --Populate the match rule set primary and secondary attributes

Line 589: fnd_message.set_name('AR','HZ_SCORING_NO_ACQUISITION');

585: EXCEPTION
586: WHEN OTHERS THEN
587: NULL;
588: END;
589: fnd_message.set_name('AR','HZ_SCORING_NO_ACQUISITION');
590: FND_MSG_PUB.ADD;
591: RAISE FND_API.G_EXC_ERROR;
592: END IF;
593: CLOSE check_null_set;

Line 607: fnd_message.set_name('AR','HZ_MR_HAS_INACTIVE_TX');

603: WHEN OTHERS THEN
604: NULL;
605: END;
606:
607: fnd_message.set_name('AR','HZ_MR_HAS_INACTIVE_TX');
608: FND_MSG_PUB.ADD;
609: RAISE FND_API.G_EXC_ERROR;
610: END IF;
611: CLOSE check_inactive;

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

687: UPDATE HZ_MATCH_RULES_B SET COMPILATION_FLAG = 'U' WHERE MATCH_RULE_ID = l_rule_id;
688: COMMIT;
689: WHEN OTHERS THEN
690:
691: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
692: FND_MESSAGE.SET_TOKEN('PROC','compile_match_rule');
693: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
694: FND_MSG_PUB.ADD;
695:

Line 692: FND_MESSAGE.SET_TOKEN('PROC','compile_match_rule');

688: COMMIT;
689: WHEN OTHERS THEN
690:
691: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
692: FND_MESSAGE.SET_TOKEN('PROC','compile_match_rule');
693: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
694: FND_MSG_PUB.ADD;
695:
696: FND_MSG_PUB.Count_And_Get(

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

689: WHEN OTHERS THEN
690:
691: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
692: FND_MESSAGE.SET_TOKEN('PROC','compile_match_rule');
693: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
694: FND_MSG_PUB.ADD;
695:
696: FND_MSG_PUB.Count_And_Get(
697: p_encoded => FND_API.G_FALSE,

Line 840: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');

836: l(' -- Find the match rule');
837: l(' null;');
838: l('');
839: l(' -- No MATCH RULE FOUND');
840: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');
841: l(' FND_MSG_PUB.ADD;');
842: l(' RAISE FND_API.G_EXC_ERROR;');
843: l(' END IF;');
844:

Line 848: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');

844:
845: l(' OPEN c_match_rule;');
846: l(' FETCH c_match_rule INTO l_cmp_flag;');
847: l(' IF c_match_rule%NOTFOUND OR l_cmp_flag <> ''C'' THEN');
848: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
849: l(' FND_MSG_PUB.ADD;');
850: l(' RAISE FND_API.G_EXC_ERROR;');
851: l(' END IF;');
852:

Line 867: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');

863: ELSE
864: l(' ELSIF p_rule_id='||RULE.MATCH_RULE_ID||' THEN ');
865: END IF;
866: l(' IF NOT HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.check_staged THEN');
867: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');
868: l(' FND_MSG_PUB.ADD;');
869: l(' RAISE FND_API.G_EXC_ERROR;');
870: l(' END IF;');
871:

Line 926: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');

922: l(' -- Find the match rule');
923: l(' null;');
924: l('');
925: l(' -- No MATCH RULE FOUND');
926: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');
927: l(' FND_MSG_PUB.ADD;');
928: l(' RAISE FND_API.G_EXC_ERROR;');
929: l(' END IF;');
930:

Line 934: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');

930:
931: l(' OPEN c_match_rule;');
932: l(' FETCH c_match_rule INTO l_cmp_flag;');
933: l(' IF c_match_rule%NOTFOUND OR l_cmp_flag <> ''C'' THEN');
934: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
935: l(' FND_MSG_PUB.ADD;');
936: l(' RAISE FND_API.G_EXC_ERROR;');
937: l(' END IF;');
938: ---Bug:5261867, additional parameter null in place of p_search_merged

Line 959: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');

955: l(' ELSIF p_rule_id='||RULE.MATCH_RULE_ID||' THEN ');
956: END IF;
957: IF check_proc(RULE.MATCH_RULE_ID) THEN
958: l(' IF NOT HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.check_staged THEN');
959: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');
960: l(' FND_MSG_PUB.ADD;');
961: l(' RAISE FND_API.G_EXC_ERROR;');
962: l(' END IF;');
963: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.find_persons(');

Line 967: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');

963: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.find_persons(');
964: l(' p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,');
965: l(' p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,''N'',x_search_ctx_id,x_num_matches);');
966: ELSE
967: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
968: l(' FND_MSG_PUB.ADD;');
969: l(' RAISE FND_API.G_EXC_ERROR;');
970: END IF;
971:

Line 1046: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');

1042: l(' -- Find the match rule');
1043: l(' null;');
1044: l('');
1045: l(' -- No MATCH RULE FOUND');
1046: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');
1047: l(' FND_MSG_PUB.ADD;');
1048: l(' RAISE FND_API.G_EXC_ERROR;');
1049: l(' END IF;');
1050:

Line 1054: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');

1050:
1051: l(' OPEN c_match_rule;');
1052: l(' FETCH c_match_rule INTO l_cmp_flag;');
1053: l(' IF c_match_rule%NOTFOUND OR l_cmp_flag <> ''C'' THEN');
1054: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
1055: l(' FND_MSG_PUB.ADD;');
1056: l(' RAISE FND_API.G_EXC_ERROR;');
1057: l(' END IF;');
1058:

Line 1073: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');

1069: ELSE
1070: l(' ELSIF p_rule_id='||RULE.MATCH_RULE_ID||' THEN ');
1071: END IF;
1072: l(' IF NOT HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.check_staged THEN');
1073: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');
1074: l(' FND_MSG_PUB.ADD;');
1075: l(' RAISE FND_API.G_EXC_ERROR;');
1076: l(' END IF;');
1077:

Line 1125: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');

1121: l(' -- Find the match rule');
1122: l(' null;');
1123: l('');
1124: l(' -- No MATCH RULE FOUND');
1125: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');
1126: l(' FND_MSG_PUB.ADD;');
1127: l(' RAISE FND_API.G_EXC_ERROR;');
1128: l(' END IF;');
1129:

Line 1134: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');

1130: l(' IF g_last_rule<>p_rule_id OR NOT g_last_rule_valid THEN');
1131: l(' OPEN c_match_rule;');
1132: l(' FETCH c_match_rule INTO l_cmp_flag;');
1133: l(' IF c_match_rule%NOTFOUND OR l_cmp_flag <> ''C'' THEN');
1134: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
1135: l(' FND_MSG_PUB.ADD;');
1136: l(' RAISE FND_API.G_EXC_ERROR;');
1137: l(' END IF;');
1138: l(' g_last_rule := p_rule_id;');

Line 1156: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');

1152: ELSE
1153: l(' ELSIF p_rule_id='||RULE.MATCH_RULE_ID||' THEN ');
1154: END IF;
1155: l(' IF NOT HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.check_staged THEN');
1156: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');
1157: l(' FND_MSG_PUB.ADD;');
1158: l(' RAISE FND_API.G_EXC_ERROR;');
1159: l(' END IF;');
1160:

Line 1209: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');

1205: l(' -- Find the match rule');
1206: l(' null;');
1207: l('');
1208: l(' -- No MATCH RULE FOUND');
1209: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');
1210: l(' FND_MSG_PUB.ADD;');
1211: l(' RAISE FND_API.G_EXC_ERROR;');
1212: l(' END IF;');
1213:

Line 1217: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');

1213:
1214: l(' OPEN c_match_rule;');
1215: l(' FETCH c_match_rule INTO l_cmp_flag;');
1216: l(' IF c_match_rule%NOTFOUND OR l_cmp_flag <> ''C'' THEN');
1217: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
1218: l(' FND_MSG_PUB.ADD;');
1219: l(' RAISE FND_API.G_EXC_ERROR;');
1220: l(' END IF;');
1221:

Line 1236: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');

1232: ELSE
1233: l(' ELSIF p_rule_id='||RULE.MATCH_RULE_ID||' THEN ');
1234: END IF;
1235: l(' IF NOT HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.check_staged THEN');
1236: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');
1237: l(' FND_MSG_PUB.ADD;');
1238: l(' RAISE FND_API.G_EXC_ERROR;');
1239: l(' END IF;');
1240:

Line 1288: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');

1284: l(' -- Find the match rule');
1285: l(' null;');
1286: l('');
1287: l(' -- No MATCH RULE FOUND');
1288: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');
1289: l(' FND_MSG_PUB.ADD;');
1290: l(' RAISE FND_API.G_EXC_ERROR;');
1291: l(' END IF;');
1292:

Line 1296: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');

1292:
1293: l(' OPEN c_match_rule;');
1294: l(' FETCH c_match_rule INTO l_cmp_flag;');
1295: l(' IF c_match_rule%NOTFOUND OR l_cmp_flag <> ''C'' THEN');
1296: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
1297: l(' FND_MSG_PUB.ADD;');
1298: l(' RAISE FND_API.G_EXC_ERROR;');
1299: l(' END IF;');
1300:

Line 1315: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');

1311: ELSE
1312: l(' ELSIF p_rule_id='||RULE.MATCH_RULE_ID||' THEN ');
1313: END IF;
1314: l(' IF NOT HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.check_staged THEN');
1315: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');
1316: l(' FND_MSG_PUB.ADD;');
1317: l(' RAISE FND_API.G_EXC_ERROR;');
1318: l(' END IF;');
1319:

Line 1367: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');

1363: l(' -- Find the match rule');
1364: l(' null;');
1365: l('');
1366: l(' -- No MATCH RULE FOUND');
1367: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');
1368: l(' FND_MSG_PUB.ADD;');
1369: l(' RAISE FND_API.G_EXC_ERROR;');
1370: l(' END IF;');
1371:

Line 1375: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');

1371:
1372: l(' OPEN c_match_rule;');
1373: l(' FETCH c_match_rule INTO l_cmp_flag;');
1374: l(' IF c_match_rule%NOTFOUND OR l_cmp_flag <> ''C'' THEN');
1375: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
1376: l(' FND_MSG_PUB.ADD;');
1377: l(' RAISE FND_API.G_EXC_ERROR;');
1378: l(' END IF;');
1379:

Line 1394: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');

1390: ELSE
1391: l(' ELSIF p_rule_id='||RULE.MATCH_RULE_ID||' THEN ');
1392: END IF;
1393: l(' IF NOT HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.check_staged THEN');
1394: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');
1395: l(' FND_MSG_PUB.ADD;');
1396: l(' RAISE FND_API.G_EXC_ERROR;');
1397: l(' END IF;');
1398:

Line 1485: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');

1481: l(' -- Find the match rule');
1482: l(' null;');
1483: l('');
1484: l(' -- No MATCH RULE FOUND');
1485: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');
1486: l(' FND_MSG_PUB.ADD;');
1487: l(' RAISE FND_API.G_EXC_ERROR;');
1488: l(' END IF;');
1489:

Line 1493: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');

1489:
1490: l(' OPEN c_match_rule;');
1491: l(' FETCH c_match_rule INTO l_cmp_flag;');
1492: l(' IF c_match_rule%NOTFOUND OR l_cmp_flag <> ''C'' THEN');
1493: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
1494: l(' FND_MSG_PUB.ADD;');
1495: l(' RAISE FND_API.G_EXC_ERROR;');
1496: l(' END IF;');
1497:

Line 1512: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');

1508: ELSE
1509: l(' ELSIF p_rule_id='||RULE.MATCH_RULE_ID||' THEN ');
1510: END IF;
1511: l(' IF NOT HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.check_staged THEN');
1512: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');
1513: l(' FND_MSG_PUB.ADD;');
1514: l(' RAISE FND_API.G_EXC_ERROR;');
1515: l(' END IF;');
1516:

Line 1612: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');

1608: l(' -- Find the match rule');
1609: l(' null;');
1610: l('');
1611: l(' -- No MATCH RULE FOUND');
1612: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');
1613: l(' FND_MSG_PUB.ADD;');
1614: l(' RAISE FND_API.G_EXC_ERROR;');
1615: l(' END IF;');
1616:

Line 1620: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');

1616:
1617: l(' OPEN c_match_rule;');
1618: l(' FETCH c_match_rule INTO l_cmp_flag;');
1619: l(' IF c_match_rule%NOTFOUND OR l_cmp_flag <> ''C'' THEN');
1620: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
1621: l(' FND_MSG_PUB.ADD;');
1622: l(' RAISE FND_API.G_EXC_ERROR;');
1623: l(' END IF;');
1624:

Line 1647: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');

1643: END IF;
1644: IF check_proc(RULE.MATCH_RULE_ID) THEN
1645:
1646: l(' IF NOT HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.check_staged THEN');
1647: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');
1648: l(' FND_MSG_PUB.ADD;');
1649: l(' RAISE FND_API.G_EXC_ERROR;');
1650: l(' END IF;');
1651:

Line 1664: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');

1660: l(' p_attrib_val11,p_attrib_val12,p_attrib_val13,p_attrib_val14,p_attrib_val15,');
1661: l(' p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,');
1662: l(' p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);');
1663: ELSE
1664: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
1665: l(' FND_MSG_PUB.ADD;');
1666: l(' RAISE FND_API.G_EXC_ERROR;');
1667: END IF;
1668:

Line 1740: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');

1736: l(' END IF;');
1737: l('');
1738: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');
1739: l(' -- No MATCH RULE FOUND');
1740: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');
1741: l(' FND_MSG_PUB.ADD;');
1742: l(' RAISE FND_API.G_EXC_ERROR;');
1743: l(' END IF;');
1744:

Line 1748: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');

1744:
1745: l(' OPEN c_match_rule;');
1746: l(' FETCH c_match_rule INTO l_cmp_flag;');
1747: l(' IF c_match_rule%NOTFOUND OR l_cmp_flag <> ''C'' THEN');
1748: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
1749: l(' FND_MSG_PUB.ADD;');
1750: l(' RAISE FND_API.G_EXC_ERROR;');
1751: l(' END IF;');
1752:

Line 1767: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');

1763: ELSE
1764: l(' ELSIF p_rule_id='||RULE.MATCH_RULE_ID||' THEN ');
1765: END IF;
1766: l(' IF NOT HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.check_staged THEN');
1767: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');
1768: l(' FND_MSG_PUB.ADD;');
1769: l(' RAISE FND_API.G_EXC_ERROR;');
1770: l(' END IF;');
1771: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.get_matching_party_sites(');

Line 1843: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');

1839: l(' END IF;');
1840: l('');
1841: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');
1842: l(' -- No MATCH RULE FOUND');
1843: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');
1844: l(' FND_MSG_PUB.ADD;');
1845: l(' RAISE FND_API.G_EXC_ERROR;');
1846: l(' END IF;');
1847:

Line 1851: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');

1847:
1848: l(' OPEN c_match_rule;');
1849: l(' FETCH c_match_rule INTO l_cmp_flag;');
1850: l(' IF c_match_rule%NOTFOUND OR l_cmp_flag <> ''C'' THEN');
1851: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
1852: l(' FND_MSG_PUB.ADD;');
1853: l(' RAISE FND_API.G_EXC_ERROR;');
1854: l(' END IF;');
1855:

Line 1870: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');

1866: ELSE
1867: l(' ELSIF p_rule_id='||RULE.MATCH_RULE_ID||' THEN ');
1868: END IF;
1869: l(' IF NOT HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.check_staged THEN');
1870: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');
1871: l(' FND_MSG_PUB.ADD;');
1872: l(' RAISE FND_API.G_EXC_ERROR;');
1873: l(' END IF;');
1874: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.get_matching_contacts(');

Line 1942: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');

1938: l(' END IF;');
1939: l('');
1940: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');
1941: l(' -- No MATCH RULE FOUND');
1942: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');
1943: l(' FND_MSG_PUB.ADD;');
1944: l(' RAISE FND_API.G_EXC_ERROR;');
1945: l(' END IF;');
1946:

Line 1950: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');

1946:
1947: l(' OPEN c_match_rule;');
1948: l(' FETCH c_match_rule INTO l_cmp_flag;');
1949: l(' IF c_match_rule%NOTFOUND OR l_cmp_flag <> ''C'' THEN');
1950: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
1951: l(' FND_MSG_PUB.ADD;');
1952: l(' RAISE FND_API.G_EXC_ERROR;');
1953: l(' END IF;');
1954:

Line 1969: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');

1965: ELSE
1966: l(' ELSIF p_rule_id='||RULE.MATCH_RULE_ID||' THEN ');
1967: END IF;
1968: l(' IF NOT HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.check_staged THEN');
1969: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');
1970: l(' FND_MSG_PUB.ADD;');
1971: l(' RAISE FND_API.G_EXC_ERROR;');
1972: l(' END IF;');
1973:

Line 2047: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');

2043: l(' END IF;');
2044: l('');
2045: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');
2046: l(' -- No MATCH RULE FOUND');
2047: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');
2048: l(' FND_MSG_PUB.ADD;');
2049: l(' RAISE FND_API.G_EXC_ERROR;');
2050: l(' END IF;');
2051:

Line 2055: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');

2051:
2052: l(' OPEN c_match_rule;');
2053: l(' FETCH c_match_rule INTO l_cmp_flag;');
2054: l(' IF c_match_rule%NOTFOUND OR l_cmp_flag <> ''C'' THEN');
2055: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
2056: l(' FND_MSG_PUB.ADD;');
2057: l(' RAISE FND_API.G_EXC_ERROR;');
2058: l(' END IF;');
2059:

Line 2074: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');

2070: ELSE
2071: l(' ELSIF p_rule_id='||RULE.MATCH_RULE_ID||' THEN ');
2072: END IF;
2073: l(' IF NOT HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.check_staged THEN');
2074: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');
2075: l(' FND_MSG_PUB.ADD;');
2076: l(' RAISE FND_API.G_EXC_ERROR;');
2077: l(' END IF;');
2078: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.get_score_details(');

Line 2120: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');

2116: l(' END IF;');
2117: l('');
2118: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');
2119: l(' -- No MATCH RULE FOUND');
2120: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');
2121: l(' FND_MSG_PUB.ADD;');
2122: l(' RAISE FND_API.G_EXC_ERROR;');
2123: l(' END IF;');
2124:

Line 2128: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');

2124:
2125: l(' OPEN c_match_rule;');
2126: l(' FETCH c_match_rule INTO l_cmp_flag;');
2127: l(' IF c_match_rule%NOTFOUND OR l_cmp_flag <> ''C'' THEN');
2128: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
2129: l(' FND_MSG_PUB.ADD;');
2130: l(' RAISE FND_API.G_EXC_ERROR;');
2131: l(' END IF;');
2132:

Line 2147: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');

2143: ELSE
2144: l(' ELSIF p_rule_id='||RULE.MATCH_RULE_ID||' THEN ');
2145: END IF;
2146: l(' IF NOT HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.check_staged THEN');
2147: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');
2148: l(' FND_MSG_PUB.ADD;');
2149: l(' RAISE FND_API.G_EXC_ERROR;');
2150: l(' END IF;');
2151: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.get_party_for_search(');

Line 2195: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');

2191: l(' END IF;');
2192: l('');
2193: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');
2194: l(' -- No MATCH RULE FOUND');
2195: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');
2196: l(' FND_MSG_PUB.ADD;');
2197: l(' RAISE FND_API.G_EXC_ERROR;');
2198: l(' END IF;');
2199:

Line 2203: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');

2199:
2200: l(' OPEN c_match_rule;');
2201: l(' FETCH c_match_rule INTO l_cmp_flag;');
2202: l(' IF c_match_rule%NOTFOUND OR l_cmp_flag <> ''C'' THEN');
2203: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
2204: l(' FND_MSG_PUB.ADD;');
2205: l(' RAISE FND_API.G_EXC_ERROR;');
2206: l(' END IF;');
2207:

Line 2222: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');

2218: ELSE
2219: l(' ELSIF p_rule_id='||RULE.MATCH_RULE_ID||' THEN ');
2220: END IF;
2221: l(' IF NOT HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.check_staged THEN');
2222: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');
2223: l(' FND_MSG_PUB.ADD;');
2224: l(' RAISE FND_API.G_EXC_ERROR;');
2225: l(' END IF;');
2226: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.get_search_criteria(');

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

2813:
2814: l(' END LOOP;');
2815: l(' -- Add the search criteria to query string');
2816: l(' IF lengthb(l_contains_str) > 4000 THEN');
2817: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_SEARCH_CRIT_LARGE_ERROR'');');
2818: l(' FND_MESSAGE.SET_TOKEN(''ENTITY'','''||p_entity||''');');
2819: l(' FND_MSG_PUB.ADD;');
2820: l(' RAISE FND_API.G_EXC_ERROR;');
2821: l(' END IF;');

Line 2818: l(' FND_MESSAGE.SET_TOKEN(''ENTITY'','''||p_entity||''');');

2814: l(' END LOOP;');
2815: l(' -- Add the search criteria to query string');
2816: l(' IF lengthb(l_contains_str) > 4000 THEN');
2817: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_SEARCH_CRIT_LARGE_ERROR'');');
2818: l(' FND_MESSAGE.SET_TOKEN(''ENTITY'','''||p_entity||''');');
2819: l(' FND_MSG_PUB.ADD;');
2820: l(' RAISE FND_API.G_EXC_ERROR;');
2821: l(' END IF;');
2822: l(' x_denorm_str := l_den_contains_str;');

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

3057: --bug 4959719 start
3058: l(' exception');
3059: l(' when others then');
3060: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
3061: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
3062: l(' FND_MSG_PUB.ADD;');
3063: l(' RAISE FND_API.G_EXC_ERROR;');
3064: --Start Bug No: 3032742.
3065: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');

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

3062: l(' FND_MSG_PUB.ADD;');
3063: l(' RAISE FND_API.G_EXC_ERROR;');
3064: --Start Bug No: 3032742.
3065: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
3066: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
3067: l(' FND_MSG_PUB.ADD;');
3068: l(' RAISE FND_API.G_EXC_ERROR;');
3069: --End Bug No : 3032742.
3070: l(' else ');

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

3307: l(' IF NOT check_prim_cond (p_party_search_rec,');
3308: l(' p_party_site_list,');
3309: l(' p_contact_list,');
3310: l(' p_contact_point_list) THEN');
3311: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_PRIMARY_COND'');');
3312: l(' FND_MSG_PUB.ADD;');
3313: l(' RAISE FND_API.G_EXC_ERROR;');
3314: l(' END IF;');
3315: IF l_max_score=1 THEN

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

3555: l(' END IF;');
3556: END IF;
3557: END LOOP;
3558: l(' IF lengthb(l_party_contains_str) > 4000 THEN');
3559: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_SEARCH_CRIT_LARGE_ERROR'');');
3560: l(' FND_MESSAGE.SET_TOKEN(''ENTITY'',''PARTY'');');
3561: l(' FND_MSG_PUB.ADD;');
3562: l(' RAISE FND_API.G_EXC_ERROR;');
3563: l(' END IF;');

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

3556: END IF;
3557: END LOOP;
3558: l(' IF lengthb(l_party_contains_str) > 4000 THEN');
3559: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_SEARCH_CRIT_LARGE_ERROR'');');
3560: l(' FND_MESSAGE.SET_TOKEN(''ENTITY'',''PARTY'');');
3561: l(' FND_MSG_PUB.ADD;');
3562: l(' RAISE FND_API.G_EXC_ERROR;');
3563: l(' END IF;');
3564: l(' IF (p_match_str = '' AND '' OR p_party_max_score

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

3969: l(' END IF;');
3970: l(' exception');
3971: l(' when others then');
3972: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
3973: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
3974: l(' FND_MSG_PUB.ADD;');
3975: l(' RAISE FND_API.G_EXC_ERROR;');
3976: --Start Bug No: 3032742.
3977: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');

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

3974: l(' FND_MSG_PUB.ADD;');
3975: l(' RAISE FND_API.G_EXC_ERROR;');
3976: --Start Bug No: 3032742.
3977: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
3978: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
3979: l(' FND_MSG_PUB.ADD;');
3980: l(' RAISE FND_API.G_EXC_ERROR;');
3981: --Bug: 3392837
3982: l(' elsif (instrb(SQLERRM,''ORA-20000'')>0) then ');

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

3979: l(' FND_MSG_PUB.ADD;');
3980: l(' RAISE FND_API.G_EXC_ERROR;');
3981: --Bug: 3392837
3982: l(' elsif (instrb(SQLERRM,''ORA-20000'')>0) then ');
3983: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
3984: l(' FND_MSG_PUB.ADD;');
3985: l(' RAISE FND_API.G_EXC_ERROR;');
3986: --End Bug No : 3032742.
3987: l(' else ');

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

3984: l(' FND_MSG_PUB.ADD;');
3985: l(' RAISE FND_API.G_EXC_ERROR;');
3986: --End Bug No : 3032742.
3987: l(' else ');
3988: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_API_OTHERS_EXCEP'');');
3989: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
3990: l(' FND_MSG_PUB.ADD;');
3991: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
3992: l(' end if;');

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

3985: l(' RAISE FND_API.G_EXC_ERROR;');
3986: --End Bug No : 3032742.
3987: l(' else ');
3988: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_API_OTHERS_EXCEP'');');
3989: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
3990: l(' FND_MSG_PUB.ADD;');
3991: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
3992: l(' end if;');
3993: l(' END;');

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

4249: l(' output_long_strings(''Restrict Sql = ''||p_restrict_sql);');
4250: l(' exception');
4251: l(' when others then');
4252: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
4253: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
4254: l(' FND_MSG_PUB.ADD;');
4255: l(' RAISE FND_API.G_EXC_ERROR;');
4256: --Start Bug No: 3032742.
4257: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');

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

4254: l(' FND_MSG_PUB.ADD;');
4255: l(' RAISE FND_API.G_EXC_ERROR;');
4256: --Start Bug No: 3032742.
4257: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
4258: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
4259: l(' FND_MSG_PUB.ADD;');
4260: l(' RAISE FND_API.G_EXC_ERROR;');
4261: --Bug: 3392837
4262: l(' elsif (instrb(SQLERRM,''ORA-20000'')>0) then ');

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

4259: l(' FND_MSG_PUB.ADD;');
4260: l(' RAISE FND_API.G_EXC_ERROR;');
4261: --Bug: 3392837
4262: l(' elsif (instrb(SQLERRM,''ORA-20000'')>0) then ');
4263: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
4264: l(' FND_MSG_PUB.ADD;');
4265: l(' RAISE FND_API.G_EXC_ERROR;');
4266: --End Bug No : 3032742.
4267: l(' else ');

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

4264: l(' FND_MSG_PUB.ADD;');
4265: l(' RAISE FND_API.G_EXC_ERROR;');
4266: --End Bug No : 3032742.
4267: l(' else ');
4268: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_API_OTHERS_EXCEP'');');
4269: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
4270: l(' FND_MSG_PUB.ADD;');
4271: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
4272: l(' end if;');

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

4265: l(' RAISE FND_API.G_EXC_ERROR;');
4266: --End Bug No : 3032742.
4267: l(' else ');
4268: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_API_OTHERS_EXCEP'');');
4269: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
4270: l(' FND_MSG_PUB.ADD;');
4271: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
4272: l(' end if;');
4273: l(' END;');

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

4417: l(' output_long_strings(''Restrict Sql = ''||p_restrict_sql);');
4418: l(' exception');
4419: l(' when others then');
4420: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
4421: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
4422: l(' FND_MSG_PUB.ADD;');
4423: l(' RAISE FND_API.G_EXC_ERROR;');
4424: --Start Bug No: 3032742.
4425: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');

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

4422: l(' FND_MSG_PUB.ADD;');
4423: l(' RAISE FND_API.G_EXC_ERROR;');
4424: --Start Bug No: 3032742.
4425: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
4426: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
4427: l(' FND_MSG_PUB.ADD;');
4428: l(' RAISE FND_API.G_EXC_ERROR;');
4429: --Bug: 3392837
4430: l(' elsif (instrb(SQLERRM,''ORA-20000'')>0) then ');

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

4427: l(' FND_MSG_PUB.ADD;');
4428: l(' RAISE FND_API.G_EXC_ERROR;');
4429: --Bug: 3392837
4430: l(' elsif (instrb(SQLERRM,''ORA-20000'')>0) then ');
4431: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
4432: l(' FND_MSG_PUB.ADD;');
4433: l(' RAISE FND_API.G_EXC_ERROR;');
4434: --End Bug No : 3032742.
4435: l(' else ');

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

4432: l(' FND_MSG_PUB.ADD;');
4433: l(' RAISE FND_API.G_EXC_ERROR;');
4434: --End Bug No : 3032742.
4435: l(' else ');
4436: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_API_OTHERS_EXCEP'');');
4437: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
4438: l(' FND_MSG_PUB.ADD;');
4439: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
4440: l(' end if;');

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

4433: l(' RAISE FND_API.G_EXC_ERROR;');
4434: --End Bug No : 3032742.
4435: l(' else ');
4436: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_API_OTHERS_EXCEP'');');
4437: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
4438: l(' FND_MSG_PUB.ADD;');
4439: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
4440: l(' end if;');
4441: l(' END;');

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

4729: l(' output_long_strings(''Restrict Sql = ''||p_restrict_sql);');
4730: l(' exception');
4731: l(' when others then');
4732: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
4733: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
4734: l(' FND_MSG_PUB.ADD;');
4735: l(' RAISE FND_API.G_EXC_ERROR;');
4736: --Start Bug No: 3032742.
4737: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');

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

4734: l(' FND_MSG_PUB.ADD;');
4735: l(' RAISE FND_API.G_EXC_ERROR;');
4736: --Start Bug No: 3032742.
4737: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
4738: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
4739: l(' FND_MSG_PUB.ADD;');
4740: l(' RAISE FND_API.G_EXC_ERROR;');
4741: --Bug: 3392837
4742: l(' elsif (instrb(SQLERRM,''ORA-20000'')>0) then ');

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

4739: l(' FND_MSG_PUB.ADD;');
4740: l(' RAISE FND_API.G_EXC_ERROR;');
4741: --Bug: 3392837
4742: l(' elsif (instrb(SQLERRM,''ORA-20000'')>0) then ');
4743: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
4744: l(' FND_MSG_PUB.ADD;');
4745: l(' RAISE FND_API.G_EXC_ERROR;');
4746: --End Bug No : 3032742.
4747: l(' else ');

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

4744: l(' FND_MSG_PUB.ADD;');
4745: l(' RAISE FND_API.G_EXC_ERROR;');
4746: --End Bug No : 3032742.
4747: l(' else ');
4748: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_API_OTHERS_EXCEP'');');
4749: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
4750: l(' FND_MSG_PUB.ADD;');
4751: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
4752: l(' end if;');

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

4745: l(' RAISE FND_API.G_EXC_ERROR;');
4746: --End Bug No : 3032742.
4747: l(' else ');
4748: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_API_OTHERS_EXCEP'');');
4749: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
4750: l(' FND_MSG_PUB.ADD;');
4751: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
4752: l(' end if;');
4753: l(' END;');

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

4993: l(' END IF;');
4994: l(' ELSE');
4995: l(' IF p_index>1 THEN');
4996: ldbg_s('In eval party level number of matches found exceeded threshold');
4997: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
4998: l(' FND_MSG_PUB.ADD;');
4999: l(' RAISE FND_API.G_EXC_ERROR;');
5000: l(' ELSE');
5001: l(' push_eval;');

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

5043: l(' END IF;');
5044: l(' CLOSE l_party_cur;'); --Bug No: 3872745
5045: l(' IF p_index>1 THEN');
5046: ldbg_s('In eval party level estimated hits exceed threshold');
5047: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
5048: l(' FND_MSG_PUB.ADD;');
5049: l(' RAISE FND_API.G_EXC_ERROR;');
5050: l(' ELSE');
5051: l(' push_eval;');

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

5105: l(' and check_estimate_hits(''PARTY_SITES'',p_party_site_contains_str)>l_max_thresh THEN');
5106: ldbg_s('In eval party site level estimated hits exceed threshold');
5107: l(' IF p_index>1 THEN');
5108: ldbg_s('In eval party site level number of matches found exceeded threshold');
5109: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
5110: l(' FND_MSG_PUB.ADD;');
5111: l(' RAISE FND_API.G_EXC_ERROR;');
5112: l(' ELSE');
5113: l(' push_eval;');

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

5202: l(' and check_estimate_hits(''CONTACTS'',p_contact_contains_str)>l_max_thresh THEN');
5203: ldbg_s('In eval contact level estimated hits exceed threshold');
5204: l(' IF p_index>1 THEN');
5205: ldbg_s('In eval contact level number of matches found exceeded threshold');
5206: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
5207: l(' FND_MSG_PUB.ADD;');
5208: l(' RAISE FND_API.G_EXC_ERROR;');
5209: l(' ELSE');
5210: l(' push_eval;');

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

5299: l(' and check_estimate_hits(''CONTACT_POINTS'',p_contact_pt_contains_str)>l_max_thresh THEN');
5300: ldbg_s('In eval contact point level estimated hits exceed threshold');
5301: l(' IF p_index>1 THEN');
5302: ldbg_s('In eval contact point level number of matches found exceeded threshold');
5303: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
5304: l(' FND_MSG_PUB.ADD;');
5305: l(' RAISE FND_API.G_EXC_ERROR;');
5306: l(' ELSE');
5307: l(' push_eval;');

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

5504: ldbg_s('When max score of entity level 5505: l(' RETURN; ');
5506: l(' ELSE ');
5507: ldbg_s('In do eval number of matches found exceeded threshold');
5508: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED''); ');
5509: l(' FND_MSG_PUB.ADD; ');
5510: l(' RAISE FND_API.G_EXC_ERROR; ');
5511: l(' END IF; ');
5512: --end of Bug No:5218095

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

5511: l(' END IF; ');
5512: --end of Bug No:5218095
5513: l(' ELSE');
5514: ldbg_s('In do eval number of matches found exceeded threshold');
5515: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
5516: l(' FND_MSG_PUB.ADD;');
5517: l(' RAISE FND_API.G_EXC_ERROR;');
5518: l(' END IF; ');
5519: l(' END IF;');

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

5518: l(' END IF; ');
5519: l(' END IF;');
5520: --End of Bug No: 4407425
5521: /*l(' IF p_index=5 AND call_order(5) <> ''NONE'' AND H_PARTY_ID.COUNT=0 THEN');
5522: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
5523: l(' FND_MSG_PUB.ADD;');
5524: l(' RAISE FND_API.G_EXC_ERROR;');
5525: l(' END IF;');
5526: */

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

5810: l(' RAISE FND_API.G_EXC_ERROR;');
5811: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
5812: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
5813: l(' WHEN OTHERS THEN');
5814: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
5815: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_parties'');');
5816: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
5817: l(' FND_MSG_PUB.ADD;');
5818: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 5815: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_parties'');');

5811: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
5812: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
5813: l(' WHEN OTHERS THEN');
5814: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
5815: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_parties'');');
5816: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
5817: l(' FND_MSG_PUB.ADD;');
5818: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
5819: l('END find_parties;');

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

5812: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
5813: l(' WHEN OTHERS THEN');
5814: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
5815: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_parties'');');
5816: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
5817: l(' FND_MSG_PUB.ADD;');
5818: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
5819: l('END find_parties;');
5820: l('');

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

6017: l(' END IF;');
6018: l(' ELSE');
6019: l(' IF p_index>1 THEN');
6020: ldbg_s('In eval party level number of matches found exceeded threshold');
6021: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
6022: l(' FND_MSG_PUB.ADD;');
6023: l(' RAISE FND_API.G_EXC_ERROR;');
6024: l(' ELSE');
6025: l(' push_eval;');

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

6070:
6071: l(' CLOSE l_party_cur;'); --Bug No: 3872745
6072: l(' IF p_index>1 THEN');
6073: ldbg_s('In eval party level number of matches found exceeded threshold');
6074: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
6075: l(' FND_MSG_PUB.ADD;');
6076: l(' RAISE FND_API.G_EXC_ERROR;');
6077: l(' ELSE');
6078: l(' push_eval;');

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

6107: --bug 4959719 start
6108: l(' exception');
6109: l(' when others then');
6110: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
6111: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
6112: l(' FND_MSG_PUB.ADD;');
6113: l(' RAISE FND_API.G_EXC_ERROR;');
6114: --Start Bug No: 3032742.
6115: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');

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

6112: l(' FND_MSG_PUB.ADD;');
6113: l(' RAISE FND_API.G_EXC_ERROR;');
6114: --Start Bug No: 3032742.
6115: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
6116: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
6117: l(' FND_MSG_PUB.ADD;');
6118: l(' RAISE FND_API.G_EXC_ERROR;');
6119: --End Bug No : 3032742.
6120: l(' else ');

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

6189: l(' IF (l_party_id_idx-1)>l_max_thresh THEN');
6190: l(' CLOSE l_party_site_cur;'); --Bug No: 3872745
6191: l(' IF p_index>1 THEN');
6192: ldbg_s('In eval party site level number of matches found exceeded threshold');
6193: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
6194: l(' FND_MSG_PUB.ADD;');
6195: l(' RAISE FND_API.G_EXC_ERROR;');
6196: l(' ELSE');
6197: l(' push_eval;');

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

6411: l(' IF (l_party_id_idx-1)>l_max_thresh THEN');
6412: l(' CLOSE l_contact_pt_cur;'); --Bug No: 3872745
6413: l(' IF p_index>1 THEN');
6414: ldbg_s('In eval contact point level number of matches found exceeded threshold');
6415: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
6416: l(' FND_MSG_PUB.ADD;');
6417: l(' RAISE FND_API.G_EXC_ERROR;');
6418: l(' ELSE');
6419: l(' push_eval;');

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

6527: ldbg_s('When max score of entity level 6528: l(' RETURN; ');
6529: l(' ELSE ');
6530: ldbg_s('In do eval number of matches found exceeded threshold');
6531: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED''); ');
6532: l(' FND_MSG_PUB.ADD; ');
6533: l(' RAISE FND_API.G_EXC_ERROR; ');
6534: l(' END IF; ');
6535: --end of Bug No:5218095

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

6534: l(' END IF; ');
6535: --end of Bug No:5218095
6536: l(' ELSE');
6537: ldbg_s('In do eval number of matches found exceeded threshold');
6538: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
6539: l(' FND_MSG_PUB.ADD;');
6540: l(' RAISE FND_API.G_EXC_ERROR;');
6541: l(' END IF; ');
6542: l(' END IF;');

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

6541: l(' END IF; ');
6542: l(' END IF;');
6543: --End of Bug No: 4407425
6544: /*l(' IF p_index=5 AND call_order(5) <> ''NONE'' AND H_PARTY_ID.COUNT=0 THEN');
6545: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
6546: l(' FND_MSG_PUB.ADD;');
6547: l(' RAISE FND_API.G_EXC_ERROR;');
6548: l(' END IF;');
6549: */

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

6720: l(' RAISE FND_API.G_EXC_ERROR;');
6721: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
6722: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6723: l(' WHEN OTHERS THEN');
6724: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6725: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_persons'');');
6726: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
6727: l(' FND_MSG_PUB.ADD;');
6728: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 6725: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_persons'');');

6721: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
6722: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6723: l(' WHEN OTHERS THEN');
6724: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6725: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_persons'');');
6726: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
6727: l(' FND_MSG_PUB.ADD;');
6728: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6729: l('END find_persons;');

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

6722: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6723: l(' WHEN OTHERS THEN');
6724: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6725: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_persons'');');
6726: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
6727: l(' FND_MSG_PUB.ADD;');
6728: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6729: l('END find_persons;');
6730: l('');

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

6743: l(' RAISE FND_API.G_EXC_ERROR;');
6744: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
6745: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6746: l(' WHEN OTHERS THEN');
6747: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6748: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_persons'');');
6749: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
6750: l(' FND_MSG_PUB.ADD;');
6751: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 6748: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_persons'');');

6744: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
6745: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6746: l(' WHEN OTHERS THEN');
6747: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6748: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_persons'');');
6749: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
6750: l(' FND_MSG_PUB.ADD;');
6751: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6752: l('END find_persons;');

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

6745: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6746: l(' WHEN OTHERS THEN');
6747: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6748: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_persons'');');
6749: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
6750: l(' FND_MSG_PUB.ADD;');
6751: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6752: l('END find_persons;');
6753: END IF; ---End of Code Change for Match Rule Set

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

6817: l(' RAISE FND_API.G_EXC_ERROR;');
6818: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
6819: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6820: l(' WHEN OTHERS THEN');
6821: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6822: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_party_details'');');
6823: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
6824: l(' FND_MSG_PUB.ADD;');
6825: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 6822: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_party_details'');');

6818: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
6819: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6820: l(' WHEN OTHERS THEN');
6821: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6822: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_party_details'');');
6823: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
6824: l(' FND_MSG_PUB.ADD;');
6825: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6826: l('END find_party_details;');

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

6819: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6820: l(' WHEN OTHERS THEN');
6821: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6822: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_party_details'');');
6823: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
6824: l(' FND_MSG_PUB.ADD;');
6825: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6826: l('END find_party_details;');
6827: l('');

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

6935: l(' RAISE FND_API.G_EXC_ERROR;');
6936: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
6937: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6938: l(' WHEN OTHERS THEN');
6939: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6940: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_parties'');');
6941: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
6942: l(' FND_MSG_PUB.ADD;');
6943: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 6940: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_parties'');');

6936: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
6937: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6938: l(' WHEN OTHERS THEN');
6939: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6940: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_parties'');');
6941: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
6942: l(' FND_MSG_PUB.ADD;');
6943: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6944: l('END find_duplicate_parties;');

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

6937: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6938: l(' WHEN OTHERS THEN');
6939: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6940: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_parties'');');
6941: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
6942: l(' FND_MSG_PUB.ADD;');
6943: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6944: l('END find_duplicate_parties;');
6945:

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

7028: l(' RAISE FND_API.G_EXC_ERROR;');
7029: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
7030: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7031: l(' WHEN OTHERS THEN');
7032: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7033: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_party_sites'');');
7034: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7035: l(' FND_MSG_PUB.ADD;');
7036: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 7033: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_party_sites'');');

7029: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
7030: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7031: l(' WHEN OTHERS THEN');
7032: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7033: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_party_sites'');');
7034: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7035: l(' FND_MSG_PUB.ADD;');
7036: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7037: l('END find_duplicate_party_sites; ');

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

7030: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7031: l(' WHEN OTHERS THEN');
7032: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7033: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_party_sites'');');
7034: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7035: l(' FND_MSG_PUB.ADD;');
7036: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7037: l('END find_duplicate_party_sites; ');
7038: l(' ');

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

7124: l(' RAISE FND_API.G_EXC_ERROR;');
7125: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
7126: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7127: l(' WHEN OTHERS THEN');
7128: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7129: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contacts'');');
7130: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7131: l(' FND_MSG_PUB.ADD;');
7132: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 7129: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contacts'');');

7125: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
7126: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7127: l(' WHEN OTHERS THEN');
7128: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7129: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contacts'');');
7130: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7131: l(' FND_MSG_PUB.ADD;');
7132: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7133: l('END find_duplicate_contacts; ');

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

7126: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7127: l(' WHEN OTHERS THEN');
7128: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7129: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contacts'');');
7130: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7131: l(' FND_MSG_PUB.ADD;');
7132: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7133: l('END find_duplicate_contacts; ');
7134: l('');

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

7200: l(' RAISE FND_API.G_EXC_ERROR;');
7201: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
7202: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7203: l(' WHEN OTHERS THEN');
7204: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7205: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contact_points'');');
7206: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7207: l(' FND_MSG_PUB.ADD;');
7208: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 7205: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contact_points'');');

7201: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
7202: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7203: l(' WHEN OTHERS THEN');
7204: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7205: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contact_points'');');
7206: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7207: l(' FND_MSG_PUB.ADD;');
7208: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7209: l('END find_duplicate_contact_points;');

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

7202: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7203: l(' WHEN OTHERS THEN');
7204: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7205: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contact_points'');');
7206: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7207: l(' FND_MSG_PUB.ADD;');
7208: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7209: l('END find_duplicate_contact_points;');
7210: l('');

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

7442: l(' RAISE FND_API.G_EXC_ERROR;');
7443: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
7444: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7445: l(' WHEN OTHERS THEN');
7446: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7447: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.call_api_dynamic'');');
7448: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7449: l(' FND_MSG_PUB.ADD;');
7450: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 7447: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.call_api_dynamic'');');

7443: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
7444: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7445: l(' WHEN OTHERS THEN');
7446: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7447: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.call_api_dynamic'');');
7448: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7449: l(' FND_MSG_PUB.ADD;');
7450: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7451:

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

7444: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7445: l(' WHEN OTHERS THEN');
7446: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7447: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.call_api_dynamic'');');
7448: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7449: l(' FND_MSG_PUB.ADD;');
7450: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7451:
7452:

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

7715: l(' RAISE FND_API.G_EXC_ERROR;');
7716: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
7717: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7718: l(' WHEN OTHERS THEN');
7719: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7720: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_party_sites'');');
7721: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7722: l(' FND_MSG_PUB.ADD;');
7723: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 7720: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_party_sites'');');

7716: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
7717: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7718: l(' WHEN OTHERS THEN');
7719: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7720: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_party_sites'');');
7721: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7722: l(' FND_MSG_PUB.ADD;');
7723: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7724: l('END get_matching_party_sites;');

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

7717: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7718: l(' WHEN OTHERS THEN');
7719: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7720: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_party_sites'');');
7721: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7722: l(' FND_MSG_PUB.ADD;');
7723: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7724: l('END get_matching_party_sites;');
7725: l('');

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

7991: l(' RAISE FND_API.G_EXC_ERROR;');
7992: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
7993: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7994: l(' WHEN OTHERS THEN');
7995: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7996: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contacts'');');
7997: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7998: l(' FND_MSG_PUB.ADD;');
7999: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 7996: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contacts'');');

7992: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
7993: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7994: l(' WHEN OTHERS THEN');
7995: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7996: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contacts'');');
7997: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7998: l(' FND_MSG_PUB.ADD;');
7999: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8000: l('END get_matching_contacts;');

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

7993: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7994: l(' WHEN OTHERS THEN');
7995: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7996: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contacts'');');
7997: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7998: l(' FND_MSG_PUB.ADD;');
7999: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8000: l('END get_matching_contacts;');
8001: l('');

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

8173: l(' RAISE FND_API.G_EXC_ERROR;');
8174: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
8175: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8176: l(' WHEN OTHERS THEN');
8177: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8178: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contact_points'');');
8179: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8180: l(' FND_MSG_PUB.ADD;');
8181: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 8178: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contact_points'');');

8174: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
8175: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8176: l(' WHEN OTHERS THEN');
8177: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8178: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contact_points'');');
8179: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8180: l(' FND_MSG_PUB.ADD;');
8181: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8182: l('END get_matching_contact_points;');

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

8175: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8176: l(' WHEN OTHERS THEN');
8177: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8178: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contact_points'');');
8179: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8180: l(' FND_MSG_PUB.ADD;');
8181: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8182: l('END get_matching_contact_points;');
8183:

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

8423: l(' RAISE FND_API.G_EXC_ERROR;');
8424: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
8425: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8426: l(' WHEN OTHERS THEN');
8427: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8428: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_score_details'');');
8429: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8430: l(' FND_MSG_PUB.ADD;');
8431: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 8428: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_score_details'');');

8424: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
8425: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8426: l(' WHEN OTHERS THEN');
8427: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8428: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_score_details'');');
8429: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8430: l(' FND_MSG_PUB.ADD;');
8431: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8432: l('END get_score_details;');

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

8425: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8426: l(' WHEN OTHERS THEN');
8427: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8428: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_score_details'');');
8429: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8430: l(' FND_MSG_PUB.ADD;');
8431: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8432: l('END get_score_details;');
8433: l('');

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

8521: l('RETURN null;');
8522:
8523: l('EXCEPTION');
8524: l(' WHEN OTHERS THEN');
8525: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8526: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_parties_bulk'');');
8527: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8528: l(' FND_MSG_PUB.ADD;');
8529: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 8526: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_parties_bulk'');');

8522:
8523: l('EXCEPTION');
8524: l(' WHEN OTHERS THEN');
8525: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8526: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_parties_bulk'');');
8527: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8528: l(' FND_MSG_PUB.ADD;');
8529: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8530: l(' END check_parties_bulk ;');

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

8523: l('EXCEPTION');
8524: l(' WHEN OTHERS THEN');
8525: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8526: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_parties_bulk'');');
8527: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8528: l(' FND_MSG_PUB.ADD;');
8529: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8530: l(' END check_parties_bulk ;');
8531: l('');

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

8583:
8584: l(' IF x_primary = TRUE THEN RETURN ''Y''; ELSE RETURN null; END IF; ');
8585: l('EXCEPTION');
8586: l(' WHEN OTHERS THEN');
8587: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8588: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_party_sites_bulk'');');
8589: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8590: l(' FND_MSG_PUB.ADD;');
8591: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 8588: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_party_sites_bulk'');');

8584: l(' IF x_primary = TRUE THEN RETURN ''Y''; ELSE RETURN null; END IF; ');
8585: l('EXCEPTION');
8586: l(' WHEN OTHERS THEN');
8587: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8588: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_party_sites_bulk'');');
8589: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8590: l(' FND_MSG_PUB.ADD;');
8591: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8592: l(' END check_party_sites_bulk ;');

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

8585: l('EXCEPTION');
8586: l(' WHEN OTHERS THEN');
8587: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8588: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_party_sites_bulk'');');
8589: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8590: l(' FND_MSG_PUB.ADD;');
8591: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8592: l(' END check_party_sites_bulk ;');
8593: l('');

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

8647:
8648: l(' IF x_primary = TRUE THEN RETURN ''Y''; ELSE RETURN null; END IF; ');
8649: l('EXCEPTION');
8650: l(' WHEN OTHERS THEN');
8651: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8652: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_contacts_bulk'');');
8653: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8654: l(' FND_MSG_PUB.ADD;');
8655: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 8652: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_contacts_bulk'');');

8648: l(' IF x_primary = TRUE THEN RETURN ''Y''; ELSE RETURN null; END IF; ');
8649: l('EXCEPTION');
8650: l(' WHEN OTHERS THEN');
8651: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8652: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_contacts_bulk'');');
8653: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8654: l(' FND_MSG_PUB.ADD;');
8655: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8656: l(' END check_contacts_bulk ;');

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

8649: l('EXCEPTION');
8650: l(' WHEN OTHERS THEN');
8651: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8652: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_contacts_bulk'');');
8653: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8654: l(' FND_MSG_PUB.ADD;');
8655: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8656: l(' END check_contacts_bulk ;');
8657: l('');

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

8709:
8710: l(' IF x_primary = TRUE THEN RETURN ''Y''; ELSE RETURN null; END IF; ');
8711: l('EXCEPTION');
8712: l(' WHEN OTHERS THEN');
8713: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8714: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_cpts_bulk'');');
8715: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8716: l(' FND_MSG_PUB.ADD;');
8717: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 8714: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_cpts_bulk'');');

8710: l(' IF x_primary = TRUE THEN RETURN ''Y''; ELSE RETURN null; END IF; ');
8711: l('EXCEPTION');
8712: l(' WHEN OTHERS THEN');
8713: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8714: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_cpts_bulk'');');
8715: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8716: l(' FND_MSG_PUB.ADD;');
8717: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8718: l(' END check_cpts_bulk ;');

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

8711: l('EXCEPTION');
8712: l(' WHEN OTHERS THEN');
8713: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8714: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_cpts_bulk'');');
8715: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8716: l(' FND_MSG_PUB.ADD;');
8717: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8718: l(' END check_cpts_bulk ;');
8719: l('');

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

9012: l(' IF NOT check_prim_cond (p_party_search_rec,');
9013: l(' p_party_site_list,');
9014: l(' p_contact_list,');
9015: l(' p_contact_point_list) THEN');
9016: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_PRIMARY_COND'');');
9017: l(' FND_MSG_PUB.ADD;');
9018: l(' RAISE FND_API.G_EXC_ERROR;');
9019: l(' END IF;');
9020: IF l_max_score=1 THEN

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

9335: l(' END IF;');
9336: l(' exception');
9337: l(' when others then');
9338: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
9339: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
9340: l(' FND_MSG_PUB.ADD;');
9341: l(' RAISE FND_API.G_EXC_ERROR;');
9342: l(' else ');
9343: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

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

9448: l(' END IF;');
9449: l(' exception');
9450: l(' when others then');
9451: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
9452: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
9453: l(' FND_MSG_PUB.ADD;');
9454: l(' RAISE FND_API.G_EXC_ERROR;');
9455: l(' else ');
9456: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

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

9549: l(' END IF;');
9550: l(' exception');
9551: l(' when others then');
9552: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
9553: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
9554: l(' FND_MSG_PUB.ADD;');
9555: l(' RAISE FND_API.G_EXC_ERROR;');
9556: l(' else ');
9557: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

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

9656: l(' END IF;');
9657: l(' exception');
9658: l(' when others then');
9659: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
9660: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
9661: l(' FND_MSG_PUB.ADD;');
9662: l(' RAISE FND_API.G_EXC_ERROR;');
9663: l(' else ');
9664: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

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

9875: l(' IF l_party_id_idx>l_max_thresh THEN');
9876: l(' CLOSE l_party_cur;'); --Bug No: 3872745
9877: l(' IF p_index>1 THEN');
9878: ldbg_s('In eval party level number of matches found exceeded threshold');
9879: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
9880: l(' FND_MSG_PUB.ADD;');
9881: l(' RAISE FND_API.G_EXC_ERROR;');
9882: l(' ELSE');
9883: l(' push_eval;');

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

9947: l(' IF l_party_id_idx>l_max_thresh THEN');
9948: l(' CLOSE l_party_site_cur;'); --Bug No: 3872745
9949: l(' IF p_index>1 THEN');
9950: ldbg_s('In eval party site level number of matches found exceeded threshold');
9951: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
9952: l(' FND_MSG_PUB.ADD;');
9953: l(' RAISE FND_API.G_EXC_ERROR;');
9954: l(' ELSE');
9955: l(' push_eval;');

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

10031: l(' IF l_party_id_idx>l_max_thresh THEN');
10032: l(' CLOSE l_contact_cur;'); --Bug No: 3872745
10033: l(' IF p_index>1 THEN');
10034: ldbg_s('In eval contact level number of matches found exceeded threshold');
10035: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
10036: l(' FND_MSG_PUB.ADD;');
10037: l(' RAISE FND_API.G_EXC_ERROR;');
10038: l(' ELSE');
10039: l(' push_eval;');

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

10115: l(' IF l_party_id_idx>l_max_thresh THEN');
10116: l(' CLOSE l_contact_pt_cur;'); --Bug No: 3872745
10117: l(' IF p_index>1 THEN');
10118: ldbg_s('In eval contact point level number of matches found exceeded threshold');
10119: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
10120: l(' FND_MSG_PUB.ADD;');
10121: l(' RAISE FND_API.G_EXC_ERROR;');
10122: l(' ELSE');
10123: l(' push_eval;');

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

10163: l(' IF( (l_match_str = '' AND '' AND other_criteria_exists) OR ( call_max_score(p_index) < l_threshold) )THEN');
10164: l(' RETURN; ');
10165: l(' ELSE');
10166: ldbg_s('In do eval number of matches found exceeded threshold');
10167: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
10168: l(' FND_MSG_PUB.ADD;');
10169: l(' RAISE FND_API.G_EXC_ERROR;');
10170: l(' END IF; ');
10171: l(' END IF;');

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

10170: l(' END IF; ');
10171: l(' END IF;');
10172: --End of Bug No: 4407425
10173: /*l(' IF p_index=5 AND call_order(5) <> ''NONE'' AND H_PARTY_ID.COUNT=0 THEN');
10174: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
10175: l(' FND_MSG_PUB.ADD;');
10176: l(' RAISE FND_API.G_EXC_ERROR;');
10177: l(' END IF;');
10178: */

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

10444: l(' ROLLBACK to find_parties;');
10445: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
10446: l(' WHEN OTHERS THEN');
10447: l(' ROLLBACK to find_parties;');
10448: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
10449: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_parties'');');
10450: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
10451: l(' FND_MSG_PUB.ADD;');
10452: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 10449: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_parties'');');

10445: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
10446: l(' WHEN OTHERS THEN');
10447: l(' ROLLBACK to find_parties;');
10448: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
10449: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_parties'');');
10450: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
10451: l(' FND_MSG_PUB.ADD;');
10452: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
10453: l('END find_parties;');

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

10446: l(' WHEN OTHERS THEN');
10447: l(' ROLLBACK to find_parties;');
10448: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
10449: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_parties'');');
10450: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
10451: l(' FND_MSG_PUB.ADD;');
10452: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
10453: l('END find_parties;');
10454: l('');

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

10670: l(' IF l_party_id_idx>l_max_thresh THEN');
10671: l(' CLOSE l_party_cur;'); --Bug No: 3872745
10672: l(' IF p_index>1 THEN');
10673: ldbg_s('In eval party level number of matches found exceeded threshold');
10674: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
10675: l(' FND_MSG_PUB.ADD;');
10676: l(' RAISE FND_API.G_EXC_ERROR;');
10677: l(' ELSE');
10678: l(' push_eval;');

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

10707: --bug 4959719 start
10708: l(' exception');
10709: l(' when others then');
10710: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
10711: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
10712: l(' FND_MSG_PUB.ADD;');
10713: l(' RAISE FND_API.G_EXC_ERROR;');
10714: --Start Bug No: 3032742.
10715: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');

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

10712: l(' FND_MSG_PUB.ADD;');
10713: l(' RAISE FND_API.G_EXC_ERROR;');
10714: --Start Bug No: 3032742.
10715: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
10716: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
10717: l(' FND_MSG_PUB.ADD;');
10718: l(' RAISE FND_API.G_EXC_ERROR;');
10719: --End Bug No : 3032742.
10720: l(' else ');

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

10794: l(' IF l_party_id_idx>l_max_thresh THEN');
10795: l(' CLOSE l_party_site_cur;'); --Bug No: 3872745
10796: l(' IF p_index>1 THEN');
10797: ldbg_s('In eval party site level number of matches found exceeded threshold');
10798: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
10799: l(' FND_MSG_PUB.ADD;');
10800: l(' RAISE FND_API.G_EXC_ERROR;');
10801: l(' ELSE');
10802: l(' push_eval;');

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

10950: l(' IF l_party_id_idx>l_max_thresh THEN');
10951: l(' CLOSE l_contact_pt_cur;'); --Bug No: 3872745
10952: l(' IF p_index>1 THEN');
10953: ldbg_s('In eval contact point level number of matches found exceeded threshold');
10954: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
10955: l(' FND_MSG_PUB.ADD;');
10956: l(' RAISE FND_API.G_EXC_ERROR;');
10957: l(' ELSE');
10958: l(' push_eval;');

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

10998: l(' IF( (l_match_str = '' AND '' AND other_criteria_exists) OR ( call_max_score(p_index) < l_threshold) )THEN');
10999: l(' RETURN; ');
11000: l(' ELSE');
11001: ldbg_s('In do eval number of matches found exceeded threshold');
11002: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
11003: l(' FND_MSG_PUB.ADD;');
11004: l(' RAISE FND_API.G_EXC_ERROR;');
11005: l(' END IF; ');
11006: l(' END IF;');

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

11006: l(' END IF;');
11007: --End of Bug No: 4407425
11008: /*
11009: l(' IF p_index=5 AND call_order(5) <> ''NONE'' AND H_PARTY_ID.COUNT=0 THEN');
11010: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
11011: l(' FND_MSG_PUB.ADD;');
11012: l(' RAISE FND_API.G_EXC_ERROR;');
11013: l(' END IF;');
11014: */

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

11157: l(' ROLLBACK to find_persons;');
11158: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11159: l(' WHEN OTHERS THEN');
11160: l(' ROLLBACK to find_persons;');
11161: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11162: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_persons'');');
11163: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11164: l(' FND_MSG_PUB.ADD;');
11165: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 11162: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_persons'');');

11158: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11159: l(' WHEN OTHERS THEN');
11160: l(' ROLLBACK to find_persons;');
11161: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11162: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_persons'');');
11163: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11164: l(' FND_MSG_PUB.ADD;');
11165: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11166: l('END find_persons;');

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

11159: l(' WHEN OTHERS THEN');
11160: l(' ROLLBACK to find_persons;');
11161: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11162: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_persons'');');
11163: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11164: l(' FND_MSG_PUB.ADD;');
11165: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11166: l('END find_persons;');
11167: ELSE

Line 11169: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');

11165: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11166: l('END find_persons;');
11167: ELSE
11168: l('BEGIN');
11169: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
11170: l(' FND_MSG_PUB.ADD;');
11171: l(' RAISE FND_API.G_EXC_ERROR;');
11172: l('END find_persons;');
11173: l('');

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

11237: l(' RAISE FND_API.G_EXC_ERROR;');
11238: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11239: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11240: l(' WHEN OTHERS THEN');
11241: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11242: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_party_details'');');
11243: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11244: l(' FND_MSG_PUB.ADD;');
11245: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 11242: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_party_details'');');

11238: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11239: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11240: l(' WHEN OTHERS THEN');
11241: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11242: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_party_details'');');
11243: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11244: l(' FND_MSG_PUB.ADD;');
11245: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11246: l('END find_party_details;');

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

11239: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11240: l(' WHEN OTHERS THEN');
11241: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11242: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_party_details'');');
11243: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11244: l(' FND_MSG_PUB.ADD;');
11245: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11246: l('END find_party_details;');
11247: l('');

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

11329: l(' RAISE FND_API.G_EXC_ERROR;');
11330: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11331: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11332: l(' WHEN OTHERS THEN');
11333: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11334: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_parties'');');
11335: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11336: l(' FND_MSG_PUB.ADD;');
11337: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 11334: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_parties'');');

11330: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11331: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11332: l(' WHEN OTHERS THEN');
11333: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11334: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_parties'');');
11335: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11336: l(' FND_MSG_PUB.ADD;');
11337: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11338: l('END find_duplicate_parties;');

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

11331: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11332: l(' WHEN OTHERS THEN');
11333: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11334: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_parties'');');
11335: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11336: l(' FND_MSG_PUB.ADD;');
11337: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11338: l('END find_duplicate_parties;');
11339:

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

11424: l(' RAISE FND_API.G_EXC_ERROR;');
11425: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11426: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11427: l(' WHEN OTHERS THEN');
11428: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11429: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_party_sites'');');
11430: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11431: l(' FND_MSG_PUB.ADD;');
11432: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 11429: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_party_sites'');');

11425: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11426: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11427: l(' WHEN OTHERS THEN');
11428: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11429: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_party_sites'');');
11430: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11431: l(' FND_MSG_PUB.ADD;');
11432: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11433: l('END find_duplicate_party_sites; ');

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

11426: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11427: l(' WHEN OTHERS THEN');
11428: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11429: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_party_sites'');');
11430: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11431: l(' FND_MSG_PUB.ADD;');
11432: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11433: l('END find_duplicate_party_sites; ');
11434: l(' ');

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

11522: l(' RAISE FND_API.G_EXC_ERROR;');
11523: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11524: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11525: l(' WHEN OTHERS THEN');
11526: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11527: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contacts'');');
11528: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11529: l(' FND_MSG_PUB.ADD;');
11530: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 11527: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contacts'');');

11523: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11524: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11525: l(' WHEN OTHERS THEN');
11526: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11527: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contacts'');');
11528: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11529: l(' FND_MSG_PUB.ADD;');
11530: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11531: l('END find_duplicate_contacts; ');

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

11524: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11525: l(' WHEN OTHERS THEN');
11526: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11527: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contacts'');');
11528: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11529: l(' FND_MSG_PUB.ADD;');
11530: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11531: l('END find_duplicate_contacts; ');
11532: l('');

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

11600: l(' RAISE FND_API.G_EXC_ERROR;');
11601: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11602: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11603: l(' WHEN OTHERS THEN');
11604: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11605: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contact_points'');');
11606: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11607: l(' FND_MSG_PUB.ADD;');
11608: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 11605: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contact_points'');');

11601: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11602: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11603: l(' WHEN OTHERS THEN');
11604: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11605: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contact_points'');');
11606: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11607: l(' FND_MSG_PUB.ADD;');
11608: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11609: l('END find_duplicate_contact_points;');

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

11602: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11603: l(' WHEN OTHERS THEN');
11604: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11605: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contact_points'');');
11606: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11607: l(' FND_MSG_PUB.ADD;');
11608: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11609: l('END find_duplicate_contact_points;');
11610: l('');

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

11843: l(' RAISE FND_API.G_EXC_ERROR;');
11844: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11845: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11846: l(' WHEN OTHERS THEN');
11847: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11848: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.call_api_dynamic'');');
11849: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11850: l(' FND_MSG_PUB.ADD;');
11851: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 11848: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.call_api_dynamic'');');

11844: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11845: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11846: l(' WHEN OTHERS THEN');
11847: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11848: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.call_api_dynamic'');');
11849: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11850: l(' FND_MSG_PUB.ADD;');
11851: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11852:

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

11845: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11846: l(' WHEN OTHERS THEN');
11847: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11848: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.call_api_dynamic'');');
11849: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11850: l(' FND_MSG_PUB.ADD;');
11851: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11852:
11853:

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

12084: l(' ROLLBACK to get_matching_party_sites ;');
12085: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12086: l(' WHEN OTHERS THEN');
12087: l(' ROLLBACK to get_matching_party_sites ;');
12088: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
12089: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_party_sites'');');
12090: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
12091: l(' FND_MSG_PUB.ADD;');
12092: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 12089: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_party_sites'');');

12085: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12086: l(' WHEN OTHERS THEN');
12087: l(' ROLLBACK to get_matching_party_sites ;');
12088: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
12089: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_party_sites'');');
12090: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
12091: l(' FND_MSG_PUB.ADD;');
12092: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12093: l('END get_matching_party_sites;');

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

12086: l(' WHEN OTHERS THEN');
12087: l(' ROLLBACK to get_matching_party_sites ;');
12088: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
12089: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_party_sites'');');
12090: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
12091: l(' FND_MSG_PUB.ADD;');
12092: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12093: l('END get_matching_party_sites;');
12094: l('');

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

12326: l(' ROLLBACK to get_matching_contacts ;');
12327: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12328: l(' WHEN OTHERS THEN');
12329: l(' ROLLBACK to get_matching_contacts ;');
12330: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
12331: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contacts'');');
12332: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
12333: l(' FND_MSG_PUB.ADD;');
12334: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 12331: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contacts'');');

12327: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12328: l(' WHEN OTHERS THEN');
12329: l(' ROLLBACK to get_matching_contacts ;');
12330: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
12331: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contacts'');');
12332: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
12333: l(' FND_MSG_PUB.ADD;');
12334: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12335: l('END get_matching_contacts;');

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

12328: l(' WHEN OTHERS THEN');
12329: l(' ROLLBACK to get_matching_contacts ;');
12330: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
12331: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contacts'');');
12332: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
12333: l(' FND_MSG_PUB.ADD;');
12334: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12335: l('END get_matching_contacts;');
12336: l('');

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

12487: l(' ROLLBACK to get_matching_contact_points ;');
12488: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12489: l(' WHEN OTHERS THEN');
12490: l(' ROLLBACK to get_matching_contact_points ;');
12491: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
12492: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contact_points'');');
12493: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
12494: l(' FND_MSG_PUB.ADD;');
12495: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 12492: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contact_points'');');

12488: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12489: l(' WHEN OTHERS THEN');
12490: l(' ROLLBACK to get_matching_contact_points ;');
12491: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
12492: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contact_points'');');
12493: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
12494: l(' FND_MSG_PUB.ADD;');
12495: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12496: l('END get_matching_contact_points;');

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

12489: l(' WHEN OTHERS THEN');
12490: l(' ROLLBACK to get_matching_contact_points ;');
12491: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
12492: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contact_points'');');
12493: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
12494: l(' FND_MSG_PUB.ADD;');
12495: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12496: l('END get_matching_contact_points;');
12497:

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

12729: l(' DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;');
12730: l(' DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;');
12731: l(' DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;');
12732: l(' DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;');
12733: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
12734: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_score_details'');');
12735: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
12736: l(' FND_MSG_PUB.ADD;');
12737: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 12734: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_score_details'');');

12730: l(' DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;');
12731: l(' DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;');
12732: l(' DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;');
12733: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
12734: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_score_details'');');
12735: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
12736: l(' FND_MSG_PUB.ADD;');
12737: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12738: l('END get_score_details;');

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

12731: l(' DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;');
12732: l(' DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;');
12733: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
12734: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_score_details'');');
12735: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
12736: l(' FND_MSG_PUB.ADD;');
12737: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12738: l('END get_score_details;');
12739: l('');

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

12962:
12963:
12964: l('EXCEPTION');
12965: l(' WHEN OTHERS THEN');
12966: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_TRANSFORM_PROC_ERROR'');');
12967: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');
12968: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
12969: l(' FND_MSG_PUB.ADD;');
12970: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 12967: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');

12963:
12964: l('EXCEPTION');
12965: l(' WHEN OTHERS THEN');
12966: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_TRANSFORM_PROC_ERROR'');');
12967: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');
12968: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
12969: l(' FND_MSG_PUB.ADD;');
12970: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12971: l('END;');

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

12964: l('EXCEPTION');
12965: l(' WHEN OTHERS THEN');
12966: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_TRANSFORM_PROC_ERROR'');');
12967: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');
12968: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
12969: l(' FND_MSG_PUB.ADD;');
12970: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12971: l('END;');
12972:

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

13154: END IF;
13155:
13156: l('EXCEPTION');
13157: l(' WHEN OTHERS THEN');
13158: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_TRANSFORM_PROC_ERROR'');');
13159: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');
13160: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
13161: l(' FND_MSG_PUB.ADD;');
13162: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 13159: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');

13155:
13156: l('EXCEPTION');
13157: l(' WHEN OTHERS THEN');
13158: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_TRANSFORM_PROC_ERROR'');');
13159: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');
13160: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
13161: l(' FND_MSG_PUB.ADD;');
13162: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
13163: l('END;');

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

13156: l('EXCEPTION');
13157: l(' WHEN OTHERS THEN');
13158: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_TRANSFORM_PROC_ERROR'');');
13159: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');
13160: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
13161: l(' FND_MSG_PUB.ADD;');
13162: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
13163: l('END;');
13164:

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

13254: END IF ;
13255:
13256: l('EXCEPTION');
13257: l(' WHEN OTHERS THEN');
13258: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_TRANSFORM_PROC_ERROR'');');
13259: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');
13260: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
13261: l(' FND_MSG_PUB.ADD;');
13262: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 13259: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');

13255:
13256: l('EXCEPTION');
13257: l(' WHEN OTHERS THEN');
13258: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_TRANSFORM_PROC_ERROR'');');
13259: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');
13260: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
13261: l(' FND_MSG_PUB.ADD;');
13262: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
13263: l('END;');

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

13256: l('EXCEPTION');
13257: l(' WHEN OTHERS THEN');
13258: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_TRANSFORM_PROC_ERROR'');');
13259: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');
13260: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
13261: l(' FND_MSG_PUB.ADD;');
13262: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
13263: l('END;');
13264:

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

13472: END IF;
13473:
13474: l('EXCEPTION');
13475: l(' WHEN OTHERS THEN');
13476: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_TRANSFORM_PROC_ERROR'');');
13477: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');
13478: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
13479: l(' FND_MSG_PUB.ADD;');
13480: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 13477: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');

13473:
13474: l('EXCEPTION');
13475: l(' WHEN OTHERS THEN');
13476: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_TRANSFORM_PROC_ERROR'');');
13477: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');
13478: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
13479: l(' FND_MSG_PUB.ADD;');
13480: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
13481: l('END;');

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

13474: l('EXCEPTION');
13475: l(' WHEN OTHERS THEN');
13476: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_TRANSFORM_PROC_ERROR'');');
13477: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');
13478: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
13479: l(' FND_MSG_PUB.ADD;');
13480: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
13481: l('END;');
13482:

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

13678:
13679:
13680: l('EXCEPTION');
13681: l(' WHEN OTHERS THEN');
13682: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_TRANSFORM_PROC_ERROR'');');
13683: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');
13684: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
13685: l(' FND_MSG_PUB.ADD;');
13686: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 13683: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');

13679:
13680: l('EXCEPTION');
13681: l(' WHEN OTHERS THEN');
13682: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_TRANSFORM_PROC_ERROR'');');
13683: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');
13684: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
13685: l(' FND_MSG_PUB.ADD;');
13686: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
13687: l('END;');

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

13680: l('EXCEPTION');
13681: l(' WHEN OTHERS THEN');
13682: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_TRANSFORM_PROC_ERROR'');');
13683: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');
13684: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
13685: l(' FND_MSG_PUB.ADD;');
13686: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
13687: l('END;');
13688:

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

13730: END IF;
13731: END LOOP;
13732: IF NOT FIRST THEN
13733: l(' ) THEN');
13734: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_CONTACT_POINT_TYPE'');');
13735: l(' FND_MSG_PUB.ADD;');
13736: l(' RAISE FND_API.G_EXC_ERROR;');
13737: l(' END IF;');
13738: l(' END LOOP;');

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

13781: l('EXCEPTION');
13782: l(' WHEN FND_API.G_EXC_ERROR THEN');
13783: l(' RAISE FND_API.G_EXC_ERROR;');
13784: l(' WHEN OTHERS THEN');
13785: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
13786: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_prim_cond'');');
13787: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
13788: l(' FND_MSG_PUB.ADD;');
13789: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

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

13782: l(' WHEN FND_API.G_EXC_ERROR THEN');
13783: l(' RAISE FND_API.G_EXC_ERROR;');
13784: l(' WHEN OTHERS THEN');
13785: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
13786: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_prim_cond'');');
13787: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
13788: l(' FND_MSG_PUB.ADD;');
13789: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
13790: l(' END check_prim_cond;');

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

13783: l(' RAISE FND_API.G_EXC_ERROR;');
13784: l(' WHEN OTHERS THEN');
13785: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
13786: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_prim_cond'');');
13787: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
13788: l(' FND_MSG_PUB.ADD;');
13789: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
13790: l(' END check_prim_cond;');
13791: l('');

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

13917: END IF;
13918: l(' END LOOP;');
13919: l('EXCEPTION');
13920: l(' WHEN OTHERS THEN');
13921: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
13922: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_party_site_cond'');');
13923: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
13924: l(' FND_MSG_PUB.ADD;');
13925: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

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

13918: l(' END LOOP;');
13919: l('EXCEPTION');
13920: l(' WHEN OTHERS THEN');
13921: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
13922: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_party_site_cond'');');
13923: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
13924: l(' FND_MSG_PUB.ADD;');
13925: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
13926: l(' END check_party_site_cond;');

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

13919: l('EXCEPTION');
13920: l(' WHEN OTHERS THEN');
13921: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
13922: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_party_site_cond'');');
13923: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
13924: l(' FND_MSG_PUB.ADD;');
13925: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
13926: l(' END check_party_site_cond;');
13927: l('');

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

14055: l(' END LOOP;');
14056:
14057: l('EXCEPTION');
14058: l(' WHEN OTHERS THEN');
14059: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
14060: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_contact_cond'');');
14061: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14062: l(' FND_MSG_PUB.ADD;');
14063: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

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

14056:
14057: l('EXCEPTION');
14058: l(' WHEN OTHERS THEN');
14059: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
14060: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_contact_cond'');');
14061: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14062: l(' FND_MSG_PUB.ADD;');
14063: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14064: l(' END check_contact_cond;');

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

14057: l('EXCEPTION');
14058: l(' WHEN OTHERS THEN');
14059: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
14060: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_contact_cond'');');
14061: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14062: l(' FND_MSG_PUB.ADD;');
14063: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14064: l(' END check_contact_cond;');
14065: l('');

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

14080: l(' x_secondary:= FALSE;');
14081: l('');
14082: l(' FOR I IN 1..p_contact_point_list.COUNT LOOP');
14083: l(' IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN ');
14084: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_CONTACT_POINT_TYPE'');');
14085: l(' FND_MSG_PUB.ADD;');
14086: l(' RAISE FND_API.G_EXC_ERROR;');
14087: l(' END IF;');
14088: l(' END LOOP;');

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

14142: END IF;
14143: l(' END LOOP;');
14144: l('EXCEPTION');
14145: l(' WHEN OTHERS THEN');
14146: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
14147: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_contact_point_cond'');');
14148: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14149: l(' FND_MSG_PUB.ADD;');
14150: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

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

14143: l(' END LOOP;');
14144: l('EXCEPTION');
14145: l(' WHEN OTHERS THEN');
14146: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
14147: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_contact_point_cond'');');
14148: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14149: l(' FND_MSG_PUB.ADD;');
14150: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14151: l(' END check_contact_point_cond;');

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

14144: l('EXCEPTION');
14145: l(' WHEN OTHERS THEN');
14146: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
14147: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_contact_point_cond'');');
14148: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14149: l(' FND_MSG_PUB.ADD;');
14150: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14151: l(' END check_contact_point_cond;');
14152: l('');

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

14424: l(' RAISE FND_API.G_EXC_ERROR;');
14425: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
14426: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14427: l(' WHEN OTHERS THEN');
14428: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
14429: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_party_for_search'');');
14430: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14431: l(' FND_MSG_PUB.ADD;');
14432: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

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

14425: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
14426: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14427: l(' WHEN OTHERS THEN');
14428: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
14429: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_party_for_search'');');
14430: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14431: l(' FND_MSG_PUB.ADD;');
14432: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14433: l('END get_party_for_search;');

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

14426: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14427: l(' WHEN OTHERS THEN');
14428: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
14429: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_party_for_search'');');
14430: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14431: l(' FND_MSG_PUB.ADD;');
14432: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14433: l('END get_party_for_search;');
14434: l('');

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

14559: l(' RAISE FND_API.G_EXC_ERROR;');
14560: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
14561: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14562: l(' WHEN OTHERS THEN');
14563: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
14564: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_search_criteria'');');
14565: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14566: l(' FND_MSG_PUB.ADD;');
14567: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

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

14560: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
14561: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14562: l(' WHEN OTHERS THEN');
14563: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
14564: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_search_criteria'');');
14565: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14566: l(' FND_MSG_PUB.ADD;');
14567: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14568: l('END get_search_criteria;');

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

14561: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14562: l(' WHEN OTHERS THEN');
14563: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
14564: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_search_criteria'');');
14565: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14566: l(' FND_MSG_PUB.ADD;');
14567: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14568: l('END get_search_criteria;');
14569: l('');

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

14807: generate_custom_code(p_rule_id, ' x_party_search_rec','PARTY','p_party_id');
14808: l('');
14809: l('EXCEPTION');
14810: l(' WHEN OTHERS THEN');
14811: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_PARTY_QUERY_ERROR'');');
14812: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_party_rec'');');
14813: l(' FND_MESSAGE.SET_TOKEN(''PARTY_ID'',p_party_id);');
14814: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14815: l(' FND_MSG_PUB.ADD;');

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

14808: l('');
14809: l('EXCEPTION');
14810: l(' WHEN OTHERS THEN');
14811: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_PARTY_QUERY_ERROR'');');
14812: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_party_rec'');');
14813: l(' FND_MESSAGE.SET_TOKEN(''PARTY_ID'',p_party_id);');
14814: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14815: l(' FND_MSG_PUB.ADD;');
14816: l(' RAISE FND_API.G_EXC_ERROR;');

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

14809: l('EXCEPTION');
14810: l(' WHEN OTHERS THEN');
14811: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_PARTY_QUERY_ERROR'');');
14812: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_party_rec'');');
14813: l(' FND_MESSAGE.SET_TOKEN(''PARTY_ID'',p_party_id);');
14814: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14815: l(' FND_MSG_PUB.ADD;');
14816: l(' RAISE FND_API.G_EXC_ERROR;');
14817: l('END get_party_rec;');

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

14810: l(' WHEN OTHERS THEN');
14811: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_PARTY_QUERY_ERROR'');');
14812: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_party_rec'');');
14813: l(' FND_MESSAGE.SET_TOKEN(''PARTY_ID'',p_party_id);');
14814: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14815: l(' FND_MSG_PUB.ADD;');
14816: l(' RAISE FND_API.G_EXC_ERROR;');
14817: l('END get_party_rec;');
14818: l('');

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

14896: l(' END LOOP;');
14897: l('');
14898: l('EXCEPTION');
14899: l(' WHEN OTHERS THEN');
14900: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_PARTY_QUERY_ERROR'');');
14901: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_party_site_rec'');');
14902: l(' FND_MESSAGE.SET_TOKEN(''PARTY_ID'',l_party_site_id);');
14903: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14904: l(' FND_MSG_PUB.ADD;');

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

14897: l('');
14898: l('EXCEPTION');
14899: l(' WHEN OTHERS THEN');
14900: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_PARTY_QUERY_ERROR'');');
14901: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_party_site_rec'');');
14902: l(' FND_MESSAGE.SET_TOKEN(''PARTY_ID'',l_party_site_id);');
14903: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14904: l(' FND_MSG_PUB.ADD;');
14905: l(' RAISE FND_API.G_EXC_ERROR;');

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

14898: l('EXCEPTION');
14899: l(' WHEN OTHERS THEN');
14900: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_PARTY_QUERY_ERROR'');');
14901: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_party_site_rec'');');
14902: l(' FND_MESSAGE.SET_TOKEN(''PARTY_ID'',l_party_site_id);');
14903: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14904: l(' FND_MSG_PUB.ADD;');
14905: l(' RAISE FND_API.G_EXC_ERROR;');
14906: l('END get_party_site_rec;');

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

14899: l(' WHEN OTHERS THEN');
14900: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_PARTY_QUERY_ERROR'');');
14901: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_party_site_rec'');');
14902: l(' FND_MESSAGE.SET_TOKEN(''PARTY_ID'',l_party_site_id);');
14903: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14904: l(' FND_MSG_PUB.ADD;');
14905: l(' RAISE FND_API.G_EXC_ERROR;');
14906: l('END get_party_site_rec;');
14907: l('');

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

14990: l(' END LOOP;');
14991: l('');
14992: l('EXCEPTION');
14993: l(' WHEN OTHERS THEN');
14994: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_PARTY_QUERY_ERROR'');');
14995: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_contact_rec'');');
14996: l(' FND_MESSAGE.SET_TOKEN(''PARTY_ID'',l_org_contact_id);');
14997: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14998: l(' FND_MSG_PUB.ADD;');

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

14991: l('');
14992: l('EXCEPTION');
14993: l(' WHEN OTHERS THEN');
14994: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_PARTY_QUERY_ERROR'');');
14995: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_contact_rec'');');
14996: l(' FND_MESSAGE.SET_TOKEN(''PARTY_ID'',l_org_contact_id);');
14997: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14998: l(' FND_MSG_PUB.ADD;');
14999: l(' RAISE FND_API.G_EXC_ERROR;');

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

14992: l('EXCEPTION');
14993: l(' WHEN OTHERS THEN');
14994: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_PARTY_QUERY_ERROR'');');
14995: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_contact_rec'');');
14996: l(' FND_MESSAGE.SET_TOKEN(''PARTY_ID'',l_org_contact_id);');
14997: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14998: l(' FND_MSG_PUB.ADD;');
14999: l(' RAISE FND_API.G_EXC_ERROR;');
15000: l('END get_contact_rec;');

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

14993: l(' WHEN OTHERS THEN');
14994: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_PARTY_QUERY_ERROR'');');
14995: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_contact_rec'');');
14996: l(' FND_MESSAGE.SET_TOKEN(''PARTY_ID'',l_org_contact_id);');
14997: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14998: l(' FND_MSG_PUB.ADD;');
14999: l(' RAISE FND_API.G_EXC_ERROR;');
15000: l('END get_contact_rec;');
15001: l('');

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

15085:
15086: l('');
15087: l('EXCEPTION');
15088: l(' WHEN OTHERS THEN');
15089: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_PARTY_QUERY_ERROR'');');
15090: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_contact_point_rec'');');
15091: l(' FND_MESSAGE.SET_TOKEN(''PARTY_ID'',l_contact_point_id);');
15092: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
15093: l(' FND_MSG_PUB.ADD;');

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

15086: l('');
15087: l('EXCEPTION');
15088: l(' WHEN OTHERS THEN');
15089: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_PARTY_QUERY_ERROR'');');
15090: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_contact_point_rec'');');
15091: l(' FND_MESSAGE.SET_TOKEN(''PARTY_ID'',l_contact_point_id);');
15092: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
15093: l(' FND_MSG_PUB.ADD;');
15094: l(' RAISE FND_API.G_EXC_ERROR;');

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

15087: l('EXCEPTION');
15088: l(' WHEN OTHERS THEN');
15089: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_PARTY_QUERY_ERROR'');');
15090: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_contact_point_rec'');');
15091: l(' FND_MESSAGE.SET_TOKEN(''PARTY_ID'',l_contact_point_id);');
15092: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
15093: l(' FND_MSG_PUB.ADD;');
15094: l(' RAISE FND_API.G_EXC_ERROR;');
15095: l('END get_contact_point_rec;');

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

15088: l(' WHEN OTHERS THEN');
15089: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_PARTY_QUERY_ERROR'');');
15090: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_contact_point_rec'');');
15091: l(' FND_MESSAGE.SET_TOKEN(''PARTY_ID'',l_contact_point_id);');
15092: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
15093: l(' FND_MSG_PUB.ADD;');
15094: l(' RAISE FND_API.G_EXC_ERROR;');
15095: l('END get_contact_point_rec;');
15096:

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

15600: l(' p_data => x_msg_data);');
15601: l('');
15602: l(' WHEN OTHERS THEN');
15603: l(' x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;');
15604: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
15605: l(' FND_MESSAGE.SET_TOKEN(''PROC'' ,''HZ_PARTY_SEARCH'');');
15606: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
15607: l(' FND_MSG_PUB.ADD;');
15608: l('');

Line 15605: l(' FND_MESSAGE.SET_TOKEN(''PROC'' ,''HZ_PARTY_SEARCH'');');

15601: l('');
15602: l(' WHEN OTHERS THEN');
15603: l(' x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;');
15604: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
15605: l(' FND_MESSAGE.SET_TOKEN(''PROC'' ,''HZ_PARTY_SEARCH'');');
15606: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
15607: l(' FND_MSG_PUB.ADD;');
15608: l('');
15609: l(' FND_MSG_PUB.Count_And_Get(');

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

15602: l(' WHEN OTHERS THEN');
15603: l(' x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;');
15604: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
15605: l(' FND_MESSAGE.SET_TOKEN(''PROC'' ,''HZ_PARTY_SEARCH'');');
15606: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
15607: l(' FND_MSG_PUB.ADD;');
15608: l('');
15609: l(' FND_MSG_PUB.Count_And_Get(');
15610: l(' p_encoded => FND_API.G_FALSE,');

Line 15854: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_NOATTRIB_ERROR'' ); ');

15850: l(' where entity_name = substrb(p_str, 0, l_pl - 1) ');
15851: l(' and ATTRIBUTE_NAME = substrb(p_str, l_pl + 1); ');
15852: l(' RETURN l_id; ');
15853: l(' EXCEPTION WHEN NO_DATA_FOUND THEN ');
15854: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_NOATTRIB_ERROR'' ); ');
15855: l(' FND_MESSAGE.SET_TOKEN(''ENTITY_ATTRIBUTE'' ,p_str); ');
15856: l(' FND_MSG_PUB.ADD; ');
15857: l(' RAISE FND_API.G_EXC_ERROR; ');
15858: l(' END get_attrib_id; ');

Line 15855: l(' FND_MESSAGE.SET_TOKEN(''ENTITY_ATTRIBUTE'' ,p_str); ');

15851: l(' and ATTRIBUTE_NAME = substrb(p_str, l_pl + 1); ');
15852: l(' RETURN l_id; ');
15853: l(' EXCEPTION WHEN NO_DATA_FOUND THEN ');
15854: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_NOATTRIB_ERROR'' ); ');
15855: l(' FND_MESSAGE.SET_TOKEN(''ENTITY_ATTRIBUTE'' ,p_str); ');
15856: l(' FND_MSG_PUB.ADD; ');
15857: l(' RAISE FND_API.G_EXC_ERROR; ');
15858: l(' END get_attrib_id; ');
15859:

Line 16258: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_SRCH_ERROR''); ');

16254: l(' WHEN OTHERS THEN') ;
16255: l(' OPEN c_rule_name(l_condition_match_rule_id);');
16256: l(' FETCH c_rule_name INTO l_cond_rule_name;');
16257: l(' CLOSE c_rule_name; ');
16258: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_SRCH_ERROR''); ');
16259: l(' FND_MESSAGE.SET_TOKEN(''MATCH_RULE'',l_cond_rule_name); ');
16260: l(' FND_MSG_PUB.ADD; ');
16261: l(' RAISE; ');
16262: l('END;');

Line 16259: l(' FND_MESSAGE.SET_TOKEN(''MATCH_RULE'',l_cond_rule_name); ');

16255: l(' OPEN c_rule_name(l_condition_match_rule_id);');
16256: l(' FETCH c_rule_name INTO l_cond_rule_name;');
16257: l(' CLOSE c_rule_name; ');
16258: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_SRCH_ERROR''); ');
16259: l(' FND_MESSAGE.SET_TOKEN(''MATCH_RULE'',l_cond_rule_name); ');
16260: l(' FND_MSG_PUB.ADD; ');
16261: l(' RAISE; ');
16262: l('END;');
16263: --End of Bug No: 4234203