eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_MATCH_RULE_COMPILE dependencies on FND_MSG_PUB

Line 533: FND_MSG_PUB.initialize;

529: l_rule_id := TO_NUMBER(p_rule_id);
530: l_package_name := 'HZ_MATCH_RULE_'||p_rule_id;
531:
532: -- Initialize message stack
533: FND_MSG_PUB.initialize;
534:
535: BEGIN
536: -- Verify that the match rule exists
537: SELECT 1 INTO l_batch_flag

Line 544: FND_MSG_PUB.ADD;

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:
548:

Line 556: FND_MSG_PUB.ADD;

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
560: HZ_POP_MRULE_SET_ATTR_V2PUB.pop_mrule_set_attributes(l_rule_id);

Line 590: FND_MSG_PUB.ADD;

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;
594:

Line 608: FND_MSG_PUB.ADD;

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;
612:

Line 650: FND_MSG_PUB.Count_And_Get(

646:
647: EXECUTE IMMEDIATE 'ALTER PACKAGE ' || l_package_name || ' COMPILE SPECIFICATION'; --bug 5622345
648:
649: --Standard call to get message count and if count is 1, get message info.
650: FND_MSG_PUB.Count_And_Get(
651: p_encoded => FND_API.G_FALSE,
652: p_count => x_msg_count,
653: p_data => x_msg_data);
654:

Line 674: FND_MSG_PUB.Count_And_Get(

670: END IF;
671:
672: EXCEPTION
673: WHEN FND_API.G_EXC_ERROR THEN
674: FND_MSG_PUB.Count_And_Get(
675: p_encoded => FND_API.G_FALSE,
676: p_count => x_msg_count,
677: p_data => x_msg_data);
678: x_return_status := FND_API.G_RET_STS_ERROR;

Line 682: FND_MSG_PUB.Count_And_Get(

678: x_return_status := FND_API.G_RET_STS_ERROR;
679: UPDATE HZ_MATCH_RULES_B SET COMPILATION_FLAG = 'U' WHERE MATCH_RULE_ID = l_rule_id;
680: COMMIT;
681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
682: FND_MSG_PUB.Count_And_Get(
683: p_encoded => FND_API.G_FALSE,
684: p_count => x_msg_count,
685: p_data => x_msg_data);
686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 694: FND_MSG_PUB.ADD;

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,
698: p_count => x_msg_count,

Line 696: FND_MSG_PUB.Count_And_Get(

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,
698: p_count => x_msg_count,
699: p_data => x_msg_data);
700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 832: l(' FND_MSG_PUB.initialize;');

828: d(fnd_log.level_statement,'Rule ID','p_rule_id');
829: l(' -- Initialize return status and message stack');
830: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
831: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
832: l(' FND_MSG_PUB.initialize;');
833: l(' END IF;');
834: l('');
835: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');
836: l(' -- Find the match rule');

Line 841: l(' FND_MSG_PUB.ADD;');

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:
845: l(' OPEN c_match_rule;');

Line 849: l(' FND_MSG_PUB.ADD;');

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:
853: FIRST := TRUE;

Line 868: l(' FND_MSG_PUB.ADD;');

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:
872: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.find_parties(');

Line 918: l(' FND_MSG_PUB.initialize;');

914: d(fnd_log.level_statement,'Rule ID','p_rule_id');
915: l(' -- Initialize return status and message stack');
916: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
917: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
918: l(' FND_MSG_PUB.initialize;');
919: l(' END IF;');
920: l('');
921: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');
922: l(' -- Find the match rule');

Line 927: l(' FND_MSG_PUB.ADD;');

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:
931: l(' OPEN c_match_rule;');

Line 935: l(' FND_MSG_PUB.ADD;');

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
939: l_sql := 'declare x number; y number; begin HZ_MATCH_RULE_RULEID.find_persons(-1,'||

Line 960: l(' FND_MSG_PUB.ADD;');

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(');
964: l(' p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,');

Line 968: l(' FND_MSG_PUB.ADD;');

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:
972: END LOOP;

Line 1038: l(' FND_MSG_PUB.initialize;');

1034: l('');
1035: l(' -- Initialize return status and message stack');
1036: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
1037: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
1038: l(' FND_MSG_PUB.initialize;');
1039: l(' END IF;');
1040: l('');
1041: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');
1042: l(' -- Find the match rule');

Line 1047: l(' FND_MSG_PUB.ADD;');

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:
1051: l(' OPEN c_match_rule;');

Line 1055: l(' FND_MSG_PUB.ADD;');

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:
1059: FIRST := TRUE;

Line 1074: l(' FND_MSG_PUB.ADD;');

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:
1078: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.find_party_details(');

Line 1117: l(' FND_MSG_PUB.initialize;');

1113: l('');
1114: l(' -- Initialize return status and message stack');
1115: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
1116: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
1117: l(' FND_MSG_PUB.initialize;');
1118: l(' END IF;');
1119: l('');
1120: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');
1121: l(' -- Find the match rule');

Line 1126: l(' FND_MSG_PUB.ADD;');

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:
1130: l(' IF g_last_rule<>p_rule_id OR NOT g_last_rule_valid THEN');

Line 1135: l(' FND_MSG_PUB.ADD;');

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;');
1139: l(' g_last_rule_valid := TRUE;');

Line 1157: l(' FND_MSG_PUB.ADD;');

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:
1161: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.find_duplicate_parties(');

Line 1201: l(' FND_MSG_PUB.initialize;');

1197: l('');
1198: l(' -- Initialize return status and message stack');
1199: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
1200: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
1201: l(' FND_MSG_PUB.initialize;');
1202: l(' END IF;');
1203: l('');
1204: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');
1205: l(' -- Find the match rule');

Line 1210: l(' FND_MSG_PUB.ADD;');

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:
1214: l(' OPEN c_match_rule;');

Line 1218: l(' FND_MSG_PUB.ADD;');

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:
1222: FIRST := TRUE;

Line 1237: l(' FND_MSG_PUB.ADD;');

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:
1241: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.find_duplicate_party_sites(');

Line 1280: l(' FND_MSG_PUB.initialize;');

1276: l('');
1277: l(' -- Initialize return status and message stack');
1278: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
1279: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
1280: l(' FND_MSG_PUB.initialize;');
1281: l(' END IF;');
1282: l('');
1283: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');
1284: l(' -- Find the match rule');

Line 1289: l(' FND_MSG_PUB.ADD;');

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:
1293: l(' OPEN c_match_rule;');

Line 1297: l(' FND_MSG_PUB.ADD;');

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:
1301: FIRST := TRUE;

Line 1316: l(' FND_MSG_PUB.ADD;');

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:
1320: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.find_duplicate_contacts(');

Line 1359: l(' FND_MSG_PUB.initialize;');

1355: l('');
1356: l(' -- Initialize return status and message stack');
1357: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
1358: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
1359: l(' FND_MSG_PUB.initialize;');
1360: l(' END IF;');
1361: l('');
1362: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');
1363: l(' -- Find the match rule');

Line 1368: l(' FND_MSG_PUB.ADD;');

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:
1372: l(' OPEN c_match_rule;');

Line 1376: l(' FND_MSG_PUB.ADD;');

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:
1380: FIRST := TRUE;

Line 1395: l(' FND_MSG_PUB.ADD;');

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:
1399: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.find_duplicate_contact_points(');

Line 1477: l(' FND_MSG_PUB.initialize;');

1473: l('');
1474: l(' -- Initialize return status and message stack');
1475: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
1476: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
1477: l(' FND_MSG_PUB.initialize;');
1478: l(' END IF;');
1479: l('');
1480: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');
1481: l(' -- Find the match rule');

Line 1486: l(' FND_MSG_PUB.ADD;');

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:
1490: l(' OPEN c_match_rule;');

Line 1494: l(' FND_MSG_PUB.ADD;');

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:
1498: FIRST := TRUE;

Line 1513: l(' FND_MSG_PUB.ADD;');

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:
1517: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.find_parties_dynamic(');

Line 1604: l(' FND_MSG_PUB.initialize;');

1600: l('');
1601: l(' -- Initialize return status and message stack');
1602: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
1603: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
1604: l(' FND_MSG_PUB.initialize;');
1605: l(' END IF;');
1606: l('');
1607: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');
1608: l(' -- Find the match rule');

Line 1613: l(' FND_MSG_PUB.ADD;');

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:
1617: l(' OPEN c_match_rule;');

Line 1621: l(' FND_MSG_PUB.ADD;');

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:
1625: l_sql := 'declare x number; y number; begin HZ_MATCH_RULE_RULEID.call_api_dynamic(null,null,'||

Line 1648: l(' FND_MSG_PUB.ADD;');

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:
1652: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.call_api_dynamic(');

Line 1665: l(' FND_MSG_PUB.ADD;');

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:
1669: END LOOP;

Line 1735: l(' FND_MSG_PUB.initialize;');

1731: l('');
1732: l(' -- Initialize return status and message stack');
1733: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
1734: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
1735: l(' FND_MSG_PUB.initialize;');
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');

Line 1741: l(' FND_MSG_PUB.ADD;');

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:
1745: l(' OPEN c_match_rule;');

Line 1749: l(' FND_MSG_PUB.ADD;');

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:
1753: FIRST := TRUE;

Line 1768: l(' FND_MSG_PUB.ADD;');

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(');
1772: l(' p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,');

Line 1838: l(' FND_MSG_PUB.initialize;');

1834: l('');
1835: l(' -- Initialize return status and message stack');
1836: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
1837: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
1838: l(' FND_MSG_PUB.initialize;');
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');

Line 1844: l(' FND_MSG_PUB.ADD;');

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:
1848: l(' OPEN c_match_rule;');

Line 1852: l(' FND_MSG_PUB.ADD;');

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:
1856: FIRST := TRUE;

Line 1871: l(' FND_MSG_PUB.ADD;');

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(');
1875: l(' p_rule_id, p_party_id,p_contact_list, p_contact_point_list,');

Line 1937: l(' FND_MSG_PUB.initialize;');

1933: l('');
1934: l(' -- Initialize return status and message stack');
1935: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
1936: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
1937: l(' FND_MSG_PUB.initialize;');
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');

Line 1943: l(' FND_MSG_PUB.ADD;');

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:
1947: l(' OPEN c_match_rule;');

Line 1951: l(' FND_MSG_PUB.ADD;');

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:
1955: FIRST := TRUE;

Line 1970: l(' FND_MSG_PUB.ADD;');

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:
1974: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.get_matching_contact_points(');

Line 2042: l(' FND_MSG_PUB.initialize;');

2038: l('');
2039: l(' -- Initialize return status and message stack');
2040: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
2041: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
2042: l(' FND_MSG_PUB.initialize;');
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');

Line 2048: l(' FND_MSG_PUB.ADD;');

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:
2052: l(' OPEN c_match_rule;');

Line 2056: l(' FND_MSG_PUB.ADD;');

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:
2060: FIRST := TRUE;

Line 2075: l(' FND_MSG_PUB.ADD;');

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(');
2079: l(' p_rule_id,');

Line 2115: l(' FND_MSG_PUB.initialize;');

2111: l('');
2112: l(' -- Initialize return status and message stack');
2113: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
2114: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
2115: l(' FND_MSG_PUB.initialize;');
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');

Line 2121: l(' FND_MSG_PUB.ADD;');

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:
2125: l(' OPEN c_match_rule;');

Line 2129: l(' FND_MSG_PUB.ADD;');

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:
2133: FIRST := TRUE;

Line 2148: l(' FND_MSG_PUB.ADD;');

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(');
2152: l(' p_party_id, x_party_search_rec,x_party_site_list,');

Line 2190: l(' FND_MSG_PUB.initialize;');

2186: l('');
2187: l(' -- Initialize return status and message stack');
2188: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
2189: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
2190: l(' FND_MSG_PUB.initialize;');
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');

Line 2196: l(' FND_MSG_PUB.ADD;');

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:
2200: l(' OPEN c_match_rule;');

Line 2204: l(' FND_MSG_PUB.ADD;');

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:
2208: FIRST := TRUE;

Line 2223: l(' FND_MSG_PUB.ADD;');

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(');
2227: l(' p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,');

Line 2819: l(' FND_MSG_PUB.ADD;');

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;');
2823: l(' RETURN l_contains_str;');

Line 3055: l(' FND_MSG_PUB.ADD;');

3051: l(' exception');
3052: l(' when others then');
3053: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
3054: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
3055: l(' FND_MSG_PUB.ADD;');
3056: l(' RAISE FND_API.G_EXC_ERROR;');
3057: --Start Bug No: 3032742.
3058: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
3059: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');

Line 3060: l(' FND_MSG_PUB.ADD;');

3056: l(' RAISE FND_API.G_EXC_ERROR;');
3057: --Start Bug No: 3032742.
3058: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
3059: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
3060: l(' FND_MSG_PUB.ADD;');
3061: l(' RAISE FND_API.G_EXC_ERROR;');
3062: --End Bug No : 3032742.
3063: l(' else ');
3064: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 3305: l(' FND_MSG_PUB.ADD;');

3301: l(' p_party_site_list,');
3302: l(' p_contact_list,');
3303: l(' p_contact_point_list) THEN');
3304: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_PRIMARY_COND'');');
3305: l(' FND_MSG_PUB.ADD;');
3306: l(' RAISE FND_API.G_EXC_ERROR;');
3307: l(' END IF;');
3308: IF l_max_score=1 THEN
3309: ldbg_s('In init_search calling util package set_no_score');

Line 3554: l(' FND_MSG_PUB.ADD;');

3550: END LOOP;
3551: l(' IF lengthb(l_party_contains_str) > 4000 THEN');
3552: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_SEARCH_CRIT_LARGE_ERROR'');');
3553: l(' FND_MESSAGE.SET_TOKEN(''ENTITY'',''PARTY'');');
3554: l(' FND_MSG_PUB.ADD;');
3555: l(' RAISE FND_API.G_EXC_ERROR;');
3556: l(' END IF;');
3557: l(' IF (p_match_str = '' AND '' OR p_party_max_score 3558: ldbg_s('party contains string returned by init_search is an AND between these strings ');

Line 3965: l(' FND_MSG_PUB.ADD;');

3961: l(' exception');
3962: l(' when others then');
3963: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
3964: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
3965: l(' FND_MSG_PUB.ADD;');
3966: l(' RAISE FND_API.G_EXC_ERROR;');
3967: --Start Bug No: 3032742.
3968: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
3969: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');

Line 3970: l(' FND_MSG_PUB.ADD;');

3966: l(' RAISE FND_API.G_EXC_ERROR;');
3967: --Start Bug No: 3032742.
3968: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
3969: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
3970: l(' FND_MSG_PUB.ADD;');
3971: l(' RAISE FND_API.G_EXC_ERROR;');
3972: --Bug: 3392837
3973: l(' elsif (instrb(SQLERRM,''ORA-20000'')>0) then ');
3974: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');

Line 3975: l(' FND_MSG_PUB.ADD;');

3971: l(' RAISE FND_API.G_EXC_ERROR;');
3972: --Bug: 3392837
3973: l(' elsif (instrb(SQLERRM,''ORA-20000'')>0) then ');
3974: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
3975: l(' FND_MSG_PUB.ADD;');
3976: l(' RAISE FND_API.G_EXC_ERROR;');
3977: --End Bug No : 3032742.
3978: l(' else ');
3979: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_API_OTHERS_EXCEP'');');

Line 3981: l(' FND_MSG_PUB.ADD;');

3977: --End Bug No : 3032742.
3978: l(' else ');
3979: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_API_OTHERS_EXCEP'');');
3980: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
3981: l(' FND_MSG_PUB.ADD;');
3982: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
3983: l(' end if;');
3984: l(' END;');
3985: l('');

Line 4245: l(' FND_MSG_PUB.ADD;');

4241: l(' exception');
4242: l(' when others then');
4243: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
4244: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
4245: l(' FND_MSG_PUB.ADD;');
4246: l(' RAISE FND_API.G_EXC_ERROR;');
4247: --Start Bug No: 3032742.
4248: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
4249: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');

Line 4250: l(' FND_MSG_PUB.ADD;');

4246: l(' RAISE FND_API.G_EXC_ERROR;');
4247: --Start Bug No: 3032742.
4248: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
4249: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
4250: l(' FND_MSG_PUB.ADD;');
4251: l(' RAISE FND_API.G_EXC_ERROR;');
4252: --Bug: 3392837
4253: l(' elsif (instrb(SQLERRM,''ORA-20000'')>0) then ');
4254: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');

Line 4255: l(' FND_MSG_PUB.ADD;');

4251: l(' RAISE FND_API.G_EXC_ERROR;');
4252: --Bug: 3392837
4253: l(' elsif (instrb(SQLERRM,''ORA-20000'')>0) then ');
4254: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
4255: l(' FND_MSG_PUB.ADD;');
4256: l(' RAISE FND_API.G_EXC_ERROR;');
4257: --End Bug No : 3032742.
4258: l(' else ');
4259: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_API_OTHERS_EXCEP'');');

Line 4261: l(' FND_MSG_PUB.ADD;');

4257: --End Bug No : 3032742.
4258: l(' else ');
4259: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_API_OTHERS_EXCEP'');');
4260: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
4261: l(' FND_MSG_PUB.ADD;');
4262: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
4263: l(' end if;');
4264: l(' END;');
4265: l('');

Line 4413: l(' FND_MSG_PUB.ADD;');

4409: l(' exception');
4410: l(' when others then');
4411: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
4412: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
4413: l(' FND_MSG_PUB.ADD;');
4414: l(' RAISE FND_API.G_EXC_ERROR;');
4415: --Start Bug No: 3032742.
4416: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
4417: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');

Line 4418: l(' FND_MSG_PUB.ADD;');

4414: l(' RAISE FND_API.G_EXC_ERROR;');
4415: --Start Bug No: 3032742.
4416: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
4417: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
4418: l(' FND_MSG_PUB.ADD;');
4419: l(' RAISE FND_API.G_EXC_ERROR;');
4420: --Bug: 3392837
4421: l(' elsif (instrb(SQLERRM,''ORA-20000'')>0) then ');
4422: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');

Line 4423: l(' FND_MSG_PUB.ADD;');

4419: l(' RAISE FND_API.G_EXC_ERROR;');
4420: --Bug: 3392837
4421: l(' elsif (instrb(SQLERRM,''ORA-20000'')>0) then ');
4422: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
4423: l(' FND_MSG_PUB.ADD;');
4424: l(' RAISE FND_API.G_EXC_ERROR;');
4425: --End Bug No : 3032742.
4426: l(' else ');
4427: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_API_OTHERS_EXCEP'');');

Line 4429: l(' FND_MSG_PUB.ADD;');

4425: --End Bug No : 3032742.
4426: l(' else ');
4427: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_API_OTHERS_EXCEP'');');
4428: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
4429: l(' FND_MSG_PUB.ADD;');
4430: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
4431: l(' end if;');
4432: l(' END;');
4433: l('');

Line 4725: l(' FND_MSG_PUB.ADD;');

4721: l(' exception');
4722: l(' when others then');
4723: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
4724: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
4725: l(' FND_MSG_PUB.ADD;');
4726: l(' RAISE FND_API.G_EXC_ERROR;');
4727: --Start Bug No: 3032742.
4728: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
4729: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');

Line 4730: l(' FND_MSG_PUB.ADD;');

4726: l(' RAISE FND_API.G_EXC_ERROR;');
4727: --Start Bug No: 3032742.
4728: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
4729: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
4730: l(' FND_MSG_PUB.ADD;');
4731: l(' RAISE FND_API.G_EXC_ERROR;');
4732: --Bug: 3392837
4733: l(' elsif (instrb(SQLERRM,''ORA-20000'')>0) then ');
4734: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');

Line 4735: l(' FND_MSG_PUB.ADD;');

4731: l(' RAISE FND_API.G_EXC_ERROR;');
4732: --Bug: 3392837
4733: l(' elsif (instrb(SQLERRM,''ORA-20000'')>0) then ');
4734: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
4735: l(' FND_MSG_PUB.ADD;');
4736: l(' RAISE FND_API.G_EXC_ERROR;');
4737: --End Bug No : 3032742.
4738: l(' else ');
4739: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_API_OTHERS_EXCEP'');');

Line 4741: l(' FND_MSG_PUB.ADD;');

4737: --End Bug No : 3032742.
4738: l(' else ');
4739: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_API_OTHERS_EXCEP'');');
4740: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
4741: l(' FND_MSG_PUB.ADD;');
4742: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
4743: l(' end if;');
4744: l(' END;');
4745: l('');

Line 4988: l(' FND_MSG_PUB.ADD;');

4984: l(' ELSE');
4985: l(' IF p_index>1 THEN');
4986: ldbg_s('In eval party level number of matches found exceeded threshold');
4987: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
4988: l(' FND_MSG_PUB.ADD;');
4989: l(' RAISE FND_API.G_EXC_ERROR;');
4990: l(' ELSE');
4991: l(' push_eval;');
4992: l(' RETURN;');

Line 5033: l(' FND_MSG_PUB.ADD;');

5029: l(' CLOSE l_party_cur;'); --Bug No: 3872745
5030: l(' IF p_index>1 THEN');
5031: ldbg_s('In eval party level estimated hits exceed threshold');
5032: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
5033: l(' FND_MSG_PUB.ADD;');
5034: l(' RAISE FND_API.G_EXC_ERROR;');
5035: l(' ELSE');
5036: l(' push_eval;');
5037: l(' RETURN;');

Line 5095: l(' FND_MSG_PUB.ADD;');

5091: ldbg_s('In eval party site level estimated hits exceed threshold');
5092: l(' IF p_index>1 THEN');
5093: ldbg_s('In eval party site level number of matches found exceeded threshold');
5094: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
5095: l(' FND_MSG_PUB.ADD;');
5096: l(' RAISE FND_API.G_EXC_ERROR;');
5097: l(' ELSE');
5098: l(' push_eval;');
5099: l(' RETURN;');

Line 5192: l(' FND_MSG_PUB.ADD;');

5188: ldbg_s('In eval contact level estimated hits exceed threshold');
5189: l(' IF p_index>1 THEN');
5190: ldbg_s('In eval contact level number of matches found exceeded threshold');
5191: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
5192: l(' FND_MSG_PUB.ADD;');
5193: l(' RAISE FND_API.G_EXC_ERROR;');
5194: l(' ELSE');
5195: l(' push_eval;');
5196: l(' RETURN;');

Line 5289: l(' FND_MSG_PUB.ADD;');

5285: ldbg_s('In eval contact point level estimated hits exceed threshold');
5286: l(' IF p_index>1 THEN');
5287: ldbg_s('In eval contact point level number of matches found exceeded threshold');
5288: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
5289: l(' FND_MSG_PUB.ADD;');
5290: l(' RAISE FND_API.G_EXC_ERROR;');
5291: l(' ELSE');
5292: l(' push_eval;');
5293: l(' RETURN;');

Line 5494: l(' FND_MSG_PUB.ADD; ');

5490: l(' RETURN; ');
5491: l(' ELSE ');
5492: ldbg_s('In do eval number of matches found exceeded threshold');
5493: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED''); ');
5494: l(' FND_MSG_PUB.ADD; ');
5495: l(' RAISE FND_API.G_EXC_ERROR; ');
5496: l(' END IF; ');
5497: --end of Bug No:5218095
5498: l(' ELSE');

Line 5501: l(' FND_MSG_PUB.ADD;');

5497: --end of Bug No:5218095
5498: l(' ELSE');
5499: ldbg_s('In do eval number of matches found exceeded threshold');
5500: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
5501: l(' FND_MSG_PUB.ADD;');
5502: l(' RAISE FND_API.G_EXC_ERROR;');
5503: l(' END IF; ');
5504: l(' END IF;');
5505: --End of Bug No: 4407425

Line 5508: l(' FND_MSG_PUB.ADD;');

5504: l(' END IF;');
5505: --End of Bug No: 4407425
5506: /*l(' IF p_index=5 AND call_order(5) <> ''NONE'' AND H_PARTY_ID.COUNT=0 THEN');
5507: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
5508: l(' FND_MSG_PUB.ADD;');
5509: l(' RAISE FND_API.G_EXC_ERROR;');
5510: l(' END IF;');
5511: */
5512: l(' IF call_order(p_index) = ''PARTY'' AND l_party_contains_str IS NOT NULL THEN');

Line 5794: l(' FND_MSG_PUB.ADD;');

5790: l(' WHEN OTHERS THEN');
5791: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
5792: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_parties'');');
5793: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
5794: l(' FND_MSG_PUB.ADD;');
5795: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
5796: l('END find_parties;');
5797: l('');
5798:

Line 5998: l(' FND_MSG_PUB.ADD;');

5994: l(' ELSE');
5995: l(' IF p_index>1 THEN');
5996: ldbg_s('In eval party level number of matches found exceeded threshold');
5997: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
5998: l(' FND_MSG_PUB.ADD;');
5999: l(' RAISE FND_API.G_EXC_ERROR;');
6000: l(' ELSE');
6001: l(' push_eval;');
6002: l(' RETURN;');

Line 6046: l(' FND_MSG_PUB.ADD;');

6042: l(' CLOSE l_party_cur;'); --Bug No: 3872745
6043: l(' IF p_index>1 THEN');
6044: ldbg_s('In eval party level number of matches found exceeded threshold');
6045: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
6046: l(' FND_MSG_PUB.ADD;');
6047: l(' RAISE FND_API.G_EXC_ERROR;');
6048: l(' ELSE');
6049: l(' push_eval;');
6050: l(' RETURN;');

Line 6083: l(' FND_MSG_PUB.ADD;');

6079: l(' exception');
6080: l(' when others then');
6081: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
6082: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
6083: l(' FND_MSG_PUB.ADD;');
6084: l(' RAISE FND_API.G_EXC_ERROR;');
6085: --Start Bug No: 3032742.
6086: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
6087: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');

Line 6088: l(' FND_MSG_PUB.ADD;');

6084: l(' RAISE FND_API.G_EXC_ERROR;');
6085: --Start Bug No: 3032742.
6086: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
6087: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
6088: l(' FND_MSG_PUB.ADD;');
6089: l(' RAISE FND_API.G_EXC_ERROR;');
6090: --End Bug No : 3032742.
6091: l(' else ');
6092: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 6165: l(' FND_MSG_PUB.ADD;');

6161: l(' CLOSE l_party_site_cur;'); --Bug No: 3872745
6162: l(' IF p_index>1 THEN');
6163: ldbg_s('In eval party site level number of matches found exceeded threshold');
6164: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
6165: l(' FND_MSG_PUB.ADD;');
6166: l(' RAISE FND_API.G_EXC_ERROR;');
6167: l(' ELSE');
6168: l(' push_eval;');
6169: l(' RETURN;');

Line 6387: l(' FND_MSG_PUB.ADD;');

6383: l(' CLOSE l_contact_pt_cur;'); --Bug No: 3872745
6384: l(' IF p_index>1 THEN');
6385: ldbg_s('In eval contact point level number of matches found exceeded threshold');
6386: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
6387: l(' FND_MSG_PUB.ADD;');
6388: l(' RAISE FND_API.G_EXC_ERROR;');
6389: l(' ELSE');
6390: l(' push_eval;');
6391: l(' RETURN;');

Line 6503: l(' FND_MSG_PUB.ADD; ');

6499: l(' RETURN; ');
6500: l(' ELSE ');
6501: ldbg_s('In do eval number of matches found exceeded threshold');
6502: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED''); ');
6503: l(' FND_MSG_PUB.ADD; ');
6504: l(' RAISE FND_API.G_EXC_ERROR; ');
6505: l(' END IF; ');
6506: --end of Bug No:5218095
6507: l(' ELSE');

Line 6510: l(' FND_MSG_PUB.ADD;');

6506: --end of Bug No:5218095
6507: l(' ELSE');
6508: ldbg_s('In do eval number of matches found exceeded threshold');
6509: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
6510: l(' FND_MSG_PUB.ADD;');
6511: l(' RAISE FND_API.G_EXC_ERROR;');
6512: l(' END IF; ');
6513: l(' END IF;');
6514: --End of Bug No: 4407425

Line 6517: l(' FND_MSG_PUB.ADD;');

6513: l(' END IF;');
6514: --End of Bug No: 4407425
6515: /*l(' IF p_index=5 AND call_order(5) <> ''NONE'' AND H_PARTY_ID.COUNT=0 THEN');
6516: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
6517: l(' FND_MSG_PUB.ADD;');
6518: l(' RAISE FND_API.G_EXC_ERROR;');
6519: l(' END IF;');
6520: */
6521: l(' IF call_order(p_index) = ''PARTY'' AND l_party_contains_str IS NOT NULL THEN');

Line 6688: l(' FND_MSG_PUB.ADD;');

6684: l(' WHEN OTHERS THEN');
6685: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6686: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_persons'');');
6687: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
6688: l(' FND_MSG_PUB.ADD;');
6689: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6690: l('END find_persons;');
6691: l('');
6692: ELSE ---Start of Code Change for Match Rule Set

Line 6711: l(' FND_MSG_PUB.ADD;');

6707: l(' WHEN OTHERS THEN');
6708: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6709: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_persons'');');
6710: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
6711: l(' FND_MSG_PUB.ADD;');
6712: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6713: l('END find_persons;');
6714: END IF; ---End of Code Change for Match Rule Set
6715:

Line 6785: l(' FND_MSG_PUB.ADD;');

6781: l(' WHEN OTHERS THEN');
6782: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6783: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_party_details'');');
6784: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
6785: l(' FND_MSG_PUB.ADD;');
6786: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6787: l('END find_party_details;');
6788: l('');
6789: /************** find_duplicate_parties API ***************/

Line 6903: l(' FND_MSG_PUB.ADD;');

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

Line 6996: l(' FND_MSG_PUB.ADD;');

6992: l(' WHEN OTHERS THEN');
6993: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6994: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_party_sites'');');
6995: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
6996: l(' FND_MSG_PUB.ADD;');
6997: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6998: l('END find_duplicate_party_sites; ');
6999: l(' ');
7000:

Line 7092: l(' FND_MSG_PUB.ADD;');

7088: l(' WHEN OTHERS THEN');
7089: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7090: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contacts'');');
7091: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7092: l(' FND_MSG_PUB.ADD;');
7093: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7094: l('END find_duplicate_contacts; ');
7095: l('');
7096: /************** find_duplicate_contact_points API ***************/

Line 7168: l(' FND_MSG_PUB.ADD;');

7164: l(' WHEN OTHERS THEN');
7165: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7166: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contact_points'');');
7167: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7168: l(' FND_MSG_PUB.ADD;');
7169: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7170: l('END find_duplicate_contact_points;');
7171: l('');
7172: l('PROCEDURE find_parties_dynamic (');

Line 7410: l(' FND_MSG_PUB.ADD;');

7406: l(' WHEN OTHERS THEN');
7407: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7408: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.call_api_dynamic'');');
7409: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7410: l(' FND_MSG_PUB.ADD;');
7411: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7412:
7413:
7414: l('END call_api_dynamic; ');

Line 7683: l(' FND_MSG_PUB.ADD;');

7679: l(' WHEN OTHERS THEN');
7680: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7681: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_party_sites'');');
7682: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7683: l(' FND_MSG_PUB.ADD;');
7684: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7685: l('END get_matching_party_sites;');
7686: l('');
7687:

Line 7959: l(' FND_MSG_PUB.ADD;');

7955: l(' WHEN OTHERS THEN');
7956: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7957: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contacts'');');
7958: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7959: l(' FND_MSG_PUB.ADD;');
7960: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7961: l('END get_matching_contacts;');
7962: l('');
7963:

Line 8141: l(' FND_MSG_PUB.ADD;');

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

Line 8384: l(' FND_MSG_PUB.ADD;');

8380: l(' WHEN OTHERS THEN');
8381: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8382: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_score_details'');');
8383: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8384: l(' FND_MSG_PUB.ADD;');
8385: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8386: l('END get_score_details;');
8387: l('');
8388:

Line 8482: l(' FND_MSG_PUB.ADD;');

8478: l(' WHEN OTHERS THEN');
8479: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8480: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_parties_bulk'');');
8481: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8482: l(' FND_MSG_PUB.ADD;');
8483: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8484: l(' END check_parties_bulk ;');
8485: l('');
8486: END generate_check_parties_bulk ;

Line 8544: l(' FND_MSG_PUB.ADD;');

8540: l(' WHEN OTHERS THEN');
8541: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8542: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_party_sites_bulk'');');
8543: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8544: l(' FND_MSG_PUB.ADD;');
8545: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8546: l(' END check_party_sites_bulk ;');
8547: l('');
8548:

Line 8608: l(' FND_MSG_PUB.ADD;');

8604: l(' WHEN OTHERS THEN');
8605: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8606: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_contacts_bulk'');');
8607: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8608: l(' FND_MSG_PUB.ADD;');
8609: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8610: l(' END check_contacts_bulk ;');
8611: l('');
8612:

Line 8670: l(' FND_MSG_PUB.ADD;');

8666: l(' WHEN OTHERS THEN');
8667: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8668: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_cpts_bulk'');');
8669: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8670: l(' FND_MSG_PUB.ADD;');
8671: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8672: l(' END check_cpts_bulk ;');
8673: l('');
8674:

Line 8971: l(' FND_MSG_PUB.ADD;');

8967: l(' p_party_site_list,');
8968: l(' p_contact_list,');
8969: l(' p_contact_point_list) THEN');
8970: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_PRIMARY_COND'');');
8971: l(' FND_MSG_PUB.ADD;');
8972: l(' RAISE FND_API.G_EXC_ERROR;');
8973: l(' END IF;');
8974: IF l_max_score=1 THEN
8975: l(' HZ_DQM_SEARCH_UTIL.set_no_score;');

Line 9294: l(' FND_MSG_PUB.ADD;');

9290: l(' exception');
9291: l(' when others then');
9292: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
9293: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
9294: l(' FND_MSG_PUB.ADD;');
9295: l(' RAISE FND_API.G_EXC_ERROR;');
9296: l(' else ');
9297: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
9298: l(' end if;');

Line 9407: l(' FND_MSG_PUB.ADD;');

9403: l(' exception');
9404: l(' when others then');
9405: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
9406: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
9407: l(' FND_MSG_PUB.ADD;');
9408: l(' RAISE FND_API.G_EXC_ERROR;');
9409: l(' else ');
9410: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
9411: l(' end if;');

Line 9508: l(' FND_MSG_PUB.ADD;');

9504: l(' exception');
9505: l(' when others then');
9506: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
9507: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
9508: l(' FND_MSG_PUB.ADD;');
9509: l(' RAISE FND_API.G_EXC_ERROR;');
9510: l(' else ');
9511: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
9512: l(' end if;');

Line 9615: l(' FND_MSG_PUB.ADD;');

9611: l(' exception');
9612: l(' when others then');
9613: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
9614: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
9615: l(' FND_MSG_PUB.ADD;');
9616: l(' RAISE FND_API.G_EXC_ERROR;');
9617: l(' else ');
9618: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
9619: l(' end if;');

Line 9834: l(' FND_MSG_PUB.ADD;');

9830: l(' CLOSE l_party_cur;'); --Bug No: 3872745
9831: l(' IF p_index>1 THEN');
9832: ldbg_s('In eval party level number of matches found exceeded threshold');
9833: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
9834: l(' FND_MSG_PUB.ADD;');
9835: l(' RAISE FND_API.G_EXC_ERROR;');
9836: l(' ELSE');
9837: l(' push_eval;');
9838: l(' RETURN;');

Line 9906: l(' FND_MSG_PUB.ADD;');

9902: l(' CLOSE l_party_site_cur;'); --Bug No: 3872745
9903: l(' IF p_index>1 THEN');
9904: ldbg_s('In eval party site level number of matches found exceeded threshold');
9905: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
9906: l(' FND_MSG_PUB.ADD;');
9907: l(' RAISE FND_API.G_EXC_ERROR;');
9908: l(' ELSE');
9909: l(' push_eval;');
9910: l(' RETURN;');

Line 9990: l(' FND_MSG_PUB.ADD;');

9986: l(' CLOSE l_contact_cur;'); --Bug No: 3872745
9987: l(' IF p_index>1 THEN');
9988: ldbg_s('In eval contact level number of matches found exceeded threshold');
9989: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
9990: l(' FND_MSG_PUB.ADD;');
9991: l(' RAISE FND_API.G_EXC_ERROR;');
9992: l(' ELSE');
9993: l(' push_eval;');
9994: l(' RETURN;');

Line 10074: l(' FND_MSG_PUB.ADD;');

10070: l(' CLOSE l_contact_pt_cur;'); --Bug No: 3872745
10071: l(' IF p_index>1 THEN');
10072: ldbg_s('In eval contact point level number of matches found exceeded threshold');
10073: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
10074: l(' FND_MSG_PUB.ADD;');
10075: l(' RAISE FND_API.G_EXC_ERROR;');
10076: l(' ELSE');
10077: l(' push_eval;');
10078: l(' RETURN;');

Line 10122: l(' FND_MSG_PUB.ADD;');

10118: l(' RETURN; ');
10119: l(' ELSE');
10120: ldbg_s('In do eval number of matches found exceeded threshold');
10121: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
10122: l(' FND_MSG_PUB.ADD;');
10123: l(' RAISE FND_API.G_EXC_ERROR;');
10124: l(' END IF; ');
10125: l(' END IF;');
10126: --End of Bug No: 4407425

Line 10129: l(' FND_MSG_PUB.ADD;');

10125: l(' END IF;');
10126: --End of Bug No: 4407425
10127: /*l(' IF p_index=5 AND call_order(5) <> ''NONE'' AND H_PARTY_ID.COUNT=0 THEN');
10128: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
10129: l(' FND_MSG_PUB.ADD;');
10130: l(' RAISE FND_API.G_EXC_ERROR;');
10131: l(' END IF;');
10132: */
10133: l(' IF call_order(p_index) = ''PARTY'' AND l_party_contains_str IS NOT NULL THEN');

Line 10395: l(' FND_MSG_PUB.ADD;');

10391: l(' ROLLBACK to find_parties;');
10392: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
10393: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_parties'');');
10394: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
10395: l(' FND_MSG_PUB.ADD;');
10396: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
10397: l('END find_parties;');
10398: l('');
10399:

Line 10619: l(' FND_MSG_PUB.ADD;');

10615: l(' CLOSE l_party_cur;'); --Bug No: 3872745
10616: l(' IF p_index>1 THEN');
10617: ldbg_s('In eval party level number of matches found exceeded threshold');
10618: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
10619: l(' FND_MSG_PUB.ADD;');
10620: l(' RAISE FND_API.G_EXC_ERROR;');
10621: l(' ELSE');
10622: l(' push_eval;');
10623: l(' RETURN;');

Line 10656: l(' FND_MSG_PUB.ADD;');

10652: l(' exception');
10653: l(' when others then');
10654: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
10655: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
10656: l(' FND_MSG_PUB.ADD;');
10657: l(' RAISE FND_API.G_EXC_ERROR;');
10658: --Start Bug No: 3032742.
10659: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
10660: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');

Line 10661: l(' FND_MSG_PUB.ADD;');

10657: l(' RAISE FND_API.G_EXC_ERROR;');
10658: --Start Bug No: 3032742.
10659: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
10660: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
10661: l(' FND_MSG_PUB.ADD;');
10662: l(' RAISE FND_API.G_EXC_ERROR;');
10663: --End Bug No : 3032742.
10664: l(' else ');
10665: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 10743: l(' FND_MSG_PUB.ADD;');

10739: l(' CLOSE l_party_site_cur;'); --Bug No: 3872745
10740: l(' IF p_index>1 THEN');
10741: ldbg_s('In eval party site level number of matches found exceeded threshold');
10742: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
10743: l(' FND_MSG_PUB.ADD;');
10744: l(' RAISE FND_API.G_EXC_ERROR;');
10745: l(' ELSE');
10746: l(' push_eval;');
10747: l(' RETURN;');

Line 10899: l(' FND_MSG_PUB.ADD;');

10895: l(' CLOSE l_contact_pt_cur;'); --Bug No: 3872745
10896: l(' IF p_index>1 THEN');
10897: ldbg_s('In eval contact point level number of matches found exceeded threshold');
10898: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
10899: l(' FND_MSG_PUB.ADD;');
10900: l(' RAISE FND_API.G_EXC_ERROR;');
10901: l(' ELSE');
10902: l(' push_eval;');
10903: l(' RETURN;');

Line 10947: l(' FND_MSG_PUB.ADD;');

10943: l(' RETURN; ');
10944: l(' ELSE');
10945: ldbg_s('In do eval number of matches found exceeded threshold');
10946: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
10947: l(' FND_MSG_PUB.ADD;');
10948: l(' RAISE FND_API.G_EXC_ERROR;');
10949: l(' END IF; ');
10950: l(' END IF;');
10951: --End of Bug No: 4407425

Line 10955: l(' FND_MSG_PUB.ADD;');

10951: --End of Bug No: 4407425
10952: /*
10953: l(' IF p_index=5 AND call_order(5) <> ''NONE'' AND H_PARTY_ID.COUNT=0 THEN');
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(' END IF;');
10958: */
10959: l(' IF call_order(p_index) = ''PARTY'' AND l_party_contains_str IS NOT NULL THEN');

Line 11108: l(' FND_MSG_PUB.ADD;');

11104: l(' ROLLBACK to find_persons;');
11105: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11106: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_persons'');');
11107: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11108: l(' FND_MSG_PUB.ADD;');
11109: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11110: l('END find_persons;');
11111: ELSE
11112: l('BEGIN');

Line 11114: l(' FND_MSG_PUB.ADD;');

11110: l('END find_persons;');
11111: ELSE
11112: l('BEGIN');
11113: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
11114: l(' FND_MSG_PUB.ADD;');
11115: l(' RAISE FND_API.G_EXC_ERROR;');
11116: l('END find_persons;');
11117: l('');
11118: END IF;

Line 11188: l(' FND_MSG_PUB.ADD;');

11184: l(' WHEN OTHERS THEN');
11185: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11186: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_party_details'');');
11187: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11188: l(' FND_MSG_PUB.ADD;');
11189: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11190: l('END find_party_details;');
11191: l('');
11192: l('-------------------------------------------------------------------------------------');

Line 11280: l(' FND_MSG_PUB.ADD;');

11276: l(' WHEN OTHERS THEN');
11277: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11278: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_parties'');');
11279: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11280: l(' FND_MSG_PUB.ADD;');
11281: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11282: l('END find_duplicate_parties;');
11283:
11284:

Line 11375: l(' FND_MSG_PUB.ADD;');

11371: l(' WHEN OTHERS THEN');
11372: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11373: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_party_sites'');');
11374: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11375: l(' FND_MSG_PUB.ADD;');
11376: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11377: l('END find_duplicate_party_sites; ');
11378: l(' ');
11379:

Line 11473: l(' FND_MSG_PUB.ADD;');

11469: l(' WHEN OTHERS THEN');
11470: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11471: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contacts'');');
11472: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11473: l(' FND_MSG_PUB.ADD;');
11474: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11475: l('END find_duplicate_contacts; ');
11476: l('');
11477: l('-------------------------------------------------------------------------------------');

Line 11551: l(' FND_MSG_PUB.ADD;');

11547: l(' WHEN OTHERS THEN');
11548: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11549: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contact_points'');');
11550: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11551: l(' FND_MSG_PUB.ADD;');
11552: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11553: l('END find_duplicate_contact_points;');
11554: l('');
11555:

Line 11794: l(' FND_MSG_PUB.ADD;');

11790: l(' WHEN OTHERS THEN');
11791: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11792: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.call_api_dynamic'');');
11793: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11794: l(' FND_MSG_PUB.ADD;');
11795: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11796:
11797:
11798: l('END call_api_dynamic;');

Line 12035: l(' FND_MSG_PUB.ADD;');

12031: l(' ROLLBACK to get_matching_party_sites ;');
12032: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
12033: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_party_sites'');');
12034: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
12035: l(' FND_MSG_PUB.ADD;');
12036: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12037: l('END get_matching_party_sites;');
12038: l('');
12039:

Line 12277: l(' FND_MSG_PUB.ADD;');

12273: l(' ROLLBACK to get_matching_contacts ;');
12274: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
12275: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contacts'');');
12276: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
12277: l(' FND_MSG_PUB.ADD;');
12278: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12279: l('END get_matching_contacts;');
12280: l('');
12281: l('-------------------------------------------------------------------------------------');

Line 12438: l(' FND_MSG_PUB.ADD;');

12434: l(' ROLLBACK to get_matching_contact_points ;');
12435: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
12436: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contact_points'');');
12437: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
12438: l(' FND_MSG_PUB.ADD;');
12439: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12440: l('END get_matching_contact_points;');
12441:
12442: l('');

Line 12680: l(' FND_MSG_PUB.ADD;');

12676: l(' DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;');
12677: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
12678: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_score_details'');');
12679: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
12680: l(' FND_MSG_PUB.ADD;');
12681: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12682: l('END get_score_details;');
12683: l('');
12684:

Line 12913: l(' FND_MSG_PUB.ADD;');

12909: l(' WHEN OTHERS THEN');
12910: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_TRANSFORM_PROC_ERROR'');');
12911: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');
12912: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
12913: l(' FND_MSG_PUB.ADD;');
12914: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12915: l('END;');
12916:
12917: END generate_party_map_proc_bulk ;

Line 13105: l(' FND_MSG_PUB.ADD;');

13101: l(' WHEN OTHERS THEN');
13102: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_TRANSFORM_PROC_ERROR'');');
13103: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');
13104: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
13105: l(' FND_MSG_PUB.ADD;');
13106: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
13107: l('END;');
13108:
13109: END generate_map_proc;

Line 13205: l(' FND_MSG_PUB.ADD;');

13201: l(' WHEN OTHERS THEN');
13202: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_TRANSFORM_PROC_ERROR'');');
13203: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');
13204: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
13205: l(' FND_MSG_PUB.ADD;');
13206: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
13207: l('END;');
13208:
13209: END ;

Line 13423: l(' FND_MSG_PUB.ADD;');

13419: l(' WHEN OTHERS THEN');
13420: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_TRANSFORM_PROC_ERROR'');');
13421: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');
13422: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
13423: l(' FND_MSG_PUB.ADD;');
13424: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
13425: l('END;');
13426:
13427: END generate_map_proc_bulk ;

Line 13629: l(' FND_MSG_PUB.ADD;');

13625: l(' WHEN OTHERS THEN');
13626: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_TRANSFORM_PROC_ERROR'');');
13627: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');
13628: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
13629: l(' FND_MSG_PUB.ADD;');
13630: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
13631: l('END;');
13632:
13633: END generate_party_map_proc;

Line 13679: l(' FND_MSG_PUB.ADD;');

13675: END LOOP;
13676: IF NOT FIRST THEN
13677: l(' ) THEN');
13678: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_CONTACT_POINT_TYPE'');');
13679: l(' FND_MSG_PUB.ADD;');
13680: l(' RAISE FND_API.G_EXC_ERROR;');
13681: l(' END IF;');
13682: l(' END LOOP;');
13683: l('');

Line 13732: l(' FND_MSG_PUB.ADD;');

13728: l(' WHEN OTHERS THEN');
13729: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
13730: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_prim_cond'');');
13731: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
13732: l(' FND_MSG_PUB.ADD;');
13733: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
13734: l(' END check_prim_cond;');
13735: l('');
13736:

Line 13868: l(' FND_MSG_PUB.ADD;');

13864: l(' WHEN OTHERS THEN');
13865: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
13866: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_party_site_cond'');');
13867: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
13868: l(' FND_MSG_PUB.ADD;');
13869: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
13870: l(' END check_party_site_cond;');
13871: l('');
13872:

Line 14006: l(' FND_MSG_PUB.ADD;');

14002: l(' WHEN OTHERS THEN');
14003: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
14004: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_contact_cond'');');
14005: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14006: l(' FND_MSG_PUB.ADD;');
14007: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14008: l(' END check_contact_cond;');
14009: l('');
14010:

Line 14029: l(' FND_MSG_PUB.ADD;');

14025: l('');
14026: l(' FOR I IN 1..p_contact_point_list.COUNT LOOP');
14027: l(' IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN ');
14028: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_CONTACT_POINT_TYPE'');');
14029: l(' FND_MSG_PUB.ADD;');
14030: l(' RAISE FND_API.G_EXC_ERROR;');
14031: l(' END IF;');
14032: l(' END LOOP;');
14033: l('');

Line 14093: l(' FND_MSG_PUB.ADD;');

14089: l(' WHEN OTHERS THEN');
14090: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
14091: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_contact_point_cond'');');
14092: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14093: l(' FND_MSG_PUB.ADD;');
14094: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14095: l(' END check_contact_point_cond;');
14096: l('');
14097:

Line 14375: l(' FND_MSG_PUB.ADD;');

14371: l(' WHEN OTHERS THEN');
14372: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
14373: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_party_for_search'');');
14374: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14375: l(' FND_MSG_PUB.ADD;');
14376: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14377: l('END get_party_for_search;');
14378: l('');
14379:

Line 14510: l(' FND_MSG_PUB.ADD;');

14506: l(' WHEN OTHERS THEN');
14507: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
14508: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_search_criteria'');');
14509: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14510: l(' FND_MSG_PUB.ADD;');
14511: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14512: l('END get_search_criteria;');
14513: l('');
14514:

Line 14759: l(' FND_MSG_PUB.ADD;');

14755: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_PARTY_QUERY_ERROR'');');
14756: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_party_rec'');');
14757: l(' FND_MESSAGE.SET_TOKEN(''PARTY_ID'',p_party_id);');
14758: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14759: l(' FND_MSG_PUB.ADD;');
14760: l(' RAISE FND_API.G_EXC_ERROR;');
14761: l('END get_party_rec;');
14762: l('');
14763: l('/************************************************');

Line 14848: l(' FND_MSG_PUB.ADD;');

14844: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_PARTY_QUERY_ERROR'');');
14845: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_party_site_rec'');');
14846: l(' FND_MESSAGE.SET_TOKEN(''PARTY_ID'',l_party_site_id);');
14847: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14848: l(' FND_MSG_PUB.ADD;');
14849: l(' RAISE FND_API.G_EXC_ERROR;');
14850: l('END get_party_site_rec;');
14851: l('');
14852:

Line 14942: l(' FND_MSG_PUB.ADD;');

14938: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_PARTY_QUERY_ERROR'');');
14939: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_contact_rec'');');
14940: l(' FND_MESSAGE.SET_TOKEN(''PARTY_ID'',l_org_contact_id);');
14941: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14942: l(' FND_MSG_PUB.ADD;');
14943: l(' RAISE FND_API.G_EXC_ERROR;');
14944: l('END get_contact_rec;');
14945: l('');
14946: l('/************************************************');

Line 15037: l(' FND_MSG_PUB.ADD;');

15033: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_PARTY_QUERY_ERROR'');');
15034: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_contact_point_rec'');');
15035: l(' FND_MESSAGE.SET_TOKEN(''PARTY_ID'',l_contact_point_id);');
15036: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
15037: l(' FND_MSG_PUB.ADD;');
15038: l(' RAISE FND_API.G_EXC_ERROR;');
15039: l('END get_contact_point_rec;');
15040:
15041: END;

Line 15528: l(' FND_MSG_PUB.Count_And_Get(');

15524: PROCEDURE gen_exception_block IS
15525:
15526: BEGIN
15527: l(' --Standard call to get message count and if count is 1, get message info');
15528: l(' FND_MSG_PUB.Count_And_Get(');
15529: l(' p_encoded => FND_API.G_FALSE,');
15530: l(' p_count => x_msg_count,');
15531: l(' p_data => x_msg_data);');
15532: l(' EXCEPTION');

Line 15535: l(' FND_MSG_PUB.Count_And_Get(');

15531: l(' p_data => x_msg_data);');
15532: l(' EXCEPTION');
15533: l(' WHEN FND_API.G_EXC_ERROR THEN');
15534: l(' x_return_status := FND_API.G_RET_STS_ERROR;');
15535: l(' FND_MSG_PUB.Count_And_Get(');
15536: l(' p_encoded => FND_API.G_FALSE,');
15537: l(' p_count => x_msg_count,');
15538: l(' p_data => x_msg_data);');
15539: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');

Line 15541: l(' FND_MSG_PUB.Count_And_Get(');

15537: l(' p_count => x_msg_count,');
15538: l(' p_data => x_msg_data);');
15539: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
15540: l(' x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;');
15541: l(' FND_MSG_PUB.Count_And_Get(');
15542: l(' p_encoded => FND_API.G_FALSE,');
15543: l(' p_count => x_msg_count,');
15544: l(' p_data => x_msg_data);');
15545: l('');

Line 15551: l(' FND_MSG_PUB.ADD;');

15547: l(' x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;');
15548: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
15549: l(' FND_MESSAGE.SET_TOKEN(''PROC'' ,''HZ_PARTY_SEARCH'');');
15550: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
15551: l(' FND_MSG_PUB.ADD;');
15552: l('');
15553: l(' FND_MSG_PUB.Count_And_Get(');
15554: l(' p_encoded => FND_API.G_FALSE,');
15555: l(' p_count => x_msg_count,');

Line 15553: l(' FND_MSG_PUB.Count_And_Get(');

15549: l(' FND_MESSAGE.SET_TOKEN(''PROC'' ,''HZ_PARTY_SEARCH'');');
15550: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
15551: l(' FND_MSG_PUB.ADD;');
15552: l('');
15553: l(' FND_MSG_PUB.Count_And_Get(');
15554: l(' p_encoded => FND_API.G_FALSE,');
15555: l(' p_count => x_msg_count,');
15556: l(' p_data => x_msg_data);');
15557: END;

Line 15589: FND_MSG_PUB.initialize;

15585:
15586: BEGIN
15587:
15588: -- Initialize return status and message stack
15589: FND_MSG_PUB.initialize;
15590:
15591: l_cur_date := SYSDATE;
15592:
15593: UPDATE HZ_MATCH_RULES_B SET compilation_flag = 'U'

Line 15657: FND_MSG_PUB.initialize;

15653: outandlog('Start Time ' || TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));
15654: outandlog('NEWLINE');
15655:
15656: -- Initialize return status and message stack
15657: FND_MSG_PUB.initialize;
15658:
15659: l_cur_date := SYSDATE;
15660:
15661: log('');

Line 15766: FND_MSG_PUB.Reset;

15762: RETURN VARCHAR2 IS
15763:
15764: l_msg_data VARCHAR2(2000);
15765: BEGIN
15766: FND_MSG_PUB.Reset;
15767:
15768: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
15769: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
15770: END LOOP;

Line 15768: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

15764: l_msg_data VARCHAR2(2000);
15765: BEGIN
15766: FND_MSG_PUB.Reset;
15767:
15768: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
15769: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
15770: END LOOP;
15771: IF (SQLERRM IS NOT NULL) THEN
15772: l_msg_data := l_msg_data || SQLERRM;

Line 15769: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );

15765: BEGIN
15766: FND_MSG_PUB.Reset;
15767:
15768: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
15769: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
15770: END LOOP;
15771: IF (SQLERRM IS NOT NULL) THEN
15772: l_msg_data := l_msg_data || SQLERRM;
15773: END IF;

Line 15798: l(' FND_MSG_PUB.ADD; ');

15794: l(' RETURN l_id; ');
15795: l(' EXCEPTION WHEN NO_DATA_FOUND THEN ');
15796: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_NOATTRIB_ERROR'' ); ');
15797: l(' FND_MESSAGE.SET_TOKEN(''ENTITY_ATTRIBUTE'' ,p_str); ');
15798: l(' FND_MSG_PUB.ADD; ');
15799: l(' RAISE FND_API.G_EXC_ERROR; ');
15800: l(' END get_attrib_id; ');
15801:
15802: l(' PROCEDURE call_api_dynamic_names (');

Line 16006: FND_MSG_PUB.initialize;

16002: l_has_errors BOOLEAN := FALSE;
16003: BEGIN
16004:
16005: -- Initialize return status and message stack
16006: FND_MSG_PUB.initialize;
16007:
16008: log('');
16009:
16010: OPEN c_rulesets_for_compile ;

Line 16202: l(' FND_MSG_PUB.ADD; ');

16198: l(' FETCH c_rule_name INTO l_cond_rule_name;');
16199: l(' CLOSE c_rule_name; ');
16200: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_SRCH_ERROR''); ');
16201: l(' FND_MESSAGE.SET_TOKEN(''MATCH_RULE'',l_cond_rule_name); ');
16202: l(' FND_MSG_PUB.ADD; ');
16203: l(' RAISE; ');
16204: l('END;');
16205: --End of Bug No: 4234203
16206: END pop_conditions;