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_MERGE_DUP_PVT dependencies on FND_MSG_PUB

Line 135: fnd_msg_pub.initialize;

131: BEGIN
132:
133: x_return_status := FND_API.G_RET_STS_SUCCESS;
134:
135: fnd_msg_pub.initialize;
136: l_batch_id := null;
137:
138: SAVEPOINT create_merge_batch;
139:

Line 146: FND_MSG_PUB.ADD;

142: FETCH c_batch_name INTO l_batch_name, l_merge_to, l_merge_type;
143: IF c_batch_name%NOTFOUND THEN
144: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_BATCH_PARAM');
145: FND_MESSAGE.SET_TOKEN('PARAMETER','DUP_SET_ID' );
146: FND_MSG_PUB.ADD;
147: RAISE FND_API.G_EXC_ERROR;
148: END IF;
149: CLOSE c_batch_name;
150:

Line 350: FND_MSG_PUB.ADD;

346: p_object_version_number := l_object_version_number;
347: ELSE
348: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
349: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_dup_sets');
350: FND_MSG_PUB.ADD;
351: RAISE FND_API.G_EXC_ERROR;
352: END IF;
353:
354: ---Default mapping of the entities

Line 363: FND_MSG_PUB.Count_And_Get(

359:
360: x_merge_batch_id := l_batch_id;
361:
362: -- standard call to get message count and if count is 1, get message info.
363: FND_MSG_PUB.Count_And_Get(
364: p_encoded => FND_API.G_FALSE,
365: p_count => x_msg_count,
366: p_data => x_msg_data);
367:

Line 372: FND_MSG_PUB.Count_And_Get(

368: EXCEPTION
369: WHEN FND_API.G_EXC_ERROR THEN
370: ROLLBACK to create_merge_batch;
371: x_return_status := FND_API.G_RET_STS_ERROR;
372: FND_MSG_PUB.Count_And_Get(
373: p_encoded => FND_API.G_FALSE,
374: p_count => x_msg_count,
375: p_data => x_msg_data);
376:

Line 380: FND_MSG_PUB.Count_And_Get(

376:
377: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
378: ROLLBACK to create_merge_batch;
379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
380: FND_MSG_PUB.Count_And_Get(
381: p_encoded => FND_API.G_FALSE,
382: p_count => x_msg_count,
383: p_data => x_msg_data);
384:

Line 391: FND_MSG_PUB.ADD;

387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
388:
389: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
390: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
391: FND_MSG_PUB.ADD;
392:
393: FND_MSG_PUB.Count_And_Get(
394: p_encoded => FND_API.G_FALSE,
395: p_count => x_msg_count,

Line 393: FND_MSG_PUB.Count_And_Get(

389: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
390: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
391: FND_MSG_PUB.ADD;
392:
393: FND_MSG_PUB.Count_And_Get(
394: p_encoded => FND_API.G_FALSE,
395: p_count => x_msg_count,
396: p_data => x_msg_data);
397:

Line 559: fnd_msg_pub.initialize;

555: --End of DLProject Changes
556:
557: BEGIN
558:
559: fnd_msg_pub.initialize;
560: x_return_status := FND_API.G_RET_STS_SUCCESS;
561:
562: SAVEPOINT map_detail_record;
563:

Line 573: FND_MSG_PUB.ADD;

569: IF (p_batch_party_id is null) OR (l_batch_id IS NULL )
570: OR (p_entity is null) OR (p_from_entity_id IS NULL) THEN
571: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_BATCH_PARAM');
572: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BATCH_PARTY_ID');
573: FND_MSG_PUB.ADD;
574: RAISE FND_API.G_EXC_ERROR;
575: END IF;
576:
577: BEGIN

Line 588: FND_MSG_PUB.ADD;

584: IF l_mm = 'Y' THEN
585: FND_MESSAGE.set_name('AR','HZ_MAND_MERGE_ERROR');
586: FND_MESSAGE.set_token('ENTITY1',p_from_entity_id);
587: FND_MESSAGE.set_token('ENTITY2',p_to_entity_id);
588: FND_MSG_PUB.ADD;
589: RAISE FND_API.G_EXC_ERROR;
590: END IF;
591:
592: IF p_from_entity_id = l_merge_to THEN

Line 619: FND_MSG_PUB.ADD;

615: AND md2.merge_to_entity_id<>p_to_entity_id;
616:
617: IF l_tmp>0 OR l_tmp2>0 THEN
618: FND_MESSAGE.set_name('AR','HZ_CANNOT_UNMAP_ERROR');
619: FND_MSG_PUB.ADD;
620: RAISE FND_API.G_EXC_ERROR;
621: END IF;
622: END IF;
623:

Line 628: FND_MSG_PUB.ADD;

624: EXCEPTION
625: WHEN NO_DATA_FOUND THEN
626: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_BATCH_PARAM');
627: FND_MESSAGE.SET_TOKEN('PARAMETER', 'MERGE_FROM_ENTITY_ID');
628: FND_MSG_PUB.ADD;
629: RAISE FND_API.G_EXC_ERROR;
630: END;
631:
632: ---Validation for locations/Party sites

Line 653: FND_MSG_PUB.ADD;

649:
650: if l_from_ps_status = 'A' and l_to_ps_status = 'I'
651: then
652: FND_MESSAGE.set_name('AR','HZ_DL_ADDR_MASTER_ERR');
653: FND_MSG_PUB.ADD;
654: RAISE FND_API.G_EXC_ERROR;
655: end if;
656: --bug 4569674
657: l_merge_yn := null;

Line 668: FND_MSG_PUB.ADD;

664: x_msg_count,
665: x_msg_data);
666: IF l_merge_yn = 'N' THEN
667: FND_MESSAGE.set_name('AR','HZ_PS_LOC_ASSIGN_ERROR');
668: FND_MSG_PUB.ADD;
669: RAISE FND_API.G_EXC_ERROR;
670: END IF;
671:
672: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 723: FND_MSG_PUB.ADD;

719: --Don't raise the error , If both the relationships are in the contact relationship group
720:
721: IF(NOT isContactGroupRelType(p_from_entity_id,p_to_entity_id)) THEN
722: FND_MESSAGE.set_name('AR','HZ_REL_NOT_SIMILAR');
723: FND_MSG_PUB.ADD;
724: RAISE FND_API.G_EXC_ERROR;
725: END IF;
726:
727: END IF;

Line 835: FND_MSG_PUB.ADD;

831:
832: ELSE
833: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
834: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_merge_party_details');
835: FND_MSG_PUB.ADD;
836: RAISE FND_API.G_EXC_ERROR;
837: END IF;
838:
839:

Line 841: FND_MSG_PUB.Count_And_Get(

837: END IF;
838:
839:
840: -- standard call to get message count and if count is 1, get message info.
841: FND_MSG_PUB.Count_And_Get(
842: p_encoded => FND_API.G_FALSE,
843: p_count => x_msg_count,
844: p_data => x_msg_data);
845:

Line 850: FND_MSG_PUB.Count_And_Get(

846: EXCEPTION
847: WHEN FND_API.G_EXC_ERROR THEN
848: ROLLBACK to map_detail_record ;
849: x_return_status := FND_API.G_RET_STS_ERROR;
850: FND_MSG_PUB.Count_And_Get(
851: p_encoded => FND_API.G_FALSE,
852: p_count => x_msg_count,
853: p_data => x_msg_data);
854:

Line 858: FND_MSG_PUB.Count_And_Get(

854:
855: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
856: ROLLBACK to map_detail_record ;
857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
858: FND_MSG_PUB.Count_And_Get(
859: p_encoded => FND_API.G_FALSE,
860: p_count => x_msg_count,
861: p_data => x_msg_data);
862:

Line 869: FND_MSG_PUB.ADD;

865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
866:
867: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
868: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
869: FND_MSG_PUB.ADD;
870:
871:
872: FND_MSG_PUB.Count_And_Get(
873: p_encoded => FND_API.G_FALSE,

Line 872: FND_MSG_PUB.Count_And_Get(

868: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
869: FND_MSG_PUB.ADD;
870:
871:
872: FND_MSG_PUB.Count_And_Get(
873: p_encoded => FND_API.G_FALSE,
874: p_count => x_msg_count,
875: p_data => x_msg_data);
876:

Line 1012: fnd_msg_pub.initialize;

1008:
1009: BEGIN
1010:
1011: x_return_status := FND_API.G_RET_STS_SUCCESS;
1012: fnd_msg_pub.initialize;
1013: SAVEPOINT map_within_party;
1014:
1015: --Get the batch_id and party_id for the same party merge
1016: SELECT DISTINCT batch_id, from_party_id, to_party_id ,merge_type

Line 1026: FND_MSG_PUB.ADD;

1022: IF (p_batch_party_id is null) or (l_batch_id is null )
1023: OR (p_entity is null) or (p_from_entity_id is null) THEN
1024: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_BATCH_PARAM');
1025: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BATCH_PARTY_ID');
1026: FND_MSG_PUB.ADD;
1027: RAISE FND_API.G_EXC_ERROR;
1028: end if;
1029:
1030: --check if the from and to_party are the same

Line 1034: FND_MSG_PUB.ADD;

1030: --check if the from and to_party are the same
1031: IF l_from_party_id <> l_to_party_id then
1032: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_BATCH_PARAM');
1033: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BATCH_PARTY_ID');
1034: FND_MSG_PUB.ADD;
1035: RAISE FND_API.G_EXC_ERROR;
1036: END IF;
1037:
1038:

Line 1042: FND_MSG_PUB.ADD;

1038:
1039: IF l_merge_type <> 'SAME_PARTY_MERGE' THEN
1040: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_BATCH_PARAM');
1041: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BATCH_PARTY_ID');
1042: FND_MSG_PUB.ADD;
1043: RAISE FND_API.G_EXC_ERROR;
1044: END IF;
1045:
1046: --check if the record already exists

Line 1054: FND_MSG_PUB.ADD;

1050:
1051: IF l_map_dtl_count > 0 AND p_to_entity_id IS NOT NULL THEN
1052: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_REC_PRESENT');
1053: FND_MESSAGE.SET_TOKEN('ID', p_from_entity_id);
1054: FND_MSG_PUB.ADD;
1055: RAISE FND_API.G_EXC_ERROR;
1056: END IF;
1057:
1058:

Line 1070: FND_MSG_PUB.ADD;

1066: FETCH c_loc_assignments INTO l_loc, l_org;
1067: IF c_loc_assignments%FOUND THEN
1068: CLOSE c_loc_assignments;
1069: FND_MESSAGE.set_name('AR','HZ_PS_LOC_ASSIGN_ERROR');
1070: FND_MSG_PUB.ADD;
1071: RAISE FND_API.G_EXC_ERROR;
1072: END IF;
1073: */
1074: OPEN c_cust_site_check;

Line 1092: FND_MSG_PUB.ADD;

1088:
1089: if l_from_ps_status = 'A' and l_to_ps_status = 'I'
1090: then
1091: FND_MESSAGE.set_name('AR','HZ_DL_ADDR_MASTER_ERR');
1092: FND_MSG_PUB.ADD;
1093: RAISE FND_API.G_EXC_ERROR;
1094: end if;
1095:
1096: --bug 4569674

Line 1108: FND_MSG_PUB.ADD;

1104: x_msg_count,
1105: x_msg_data);
1106: IF l_merge_yn = 'N' THEN
1107: FND_MESSAGE.set_name('AR','HZ_PS_LOC_ASSIGN_ERROR');
1108: FND_MSG_PUB.ADD;
1109: RAISE FND_API.G_EXC_ERROR;
1110: END IF;
1111:
1112:

Line 1135: FND_MSG_PUB.ADD;

1131: IF ( (l_from_site_party_id <> l_to_site_party_id) AND
1132: (l_from_site_party_id <> l_from_party_id) ) THEN
1133: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_BATCH_PARAM');
1134: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BATCH_PARTY_ID');
1135: FND_MSG_PUB.ADD;
1136: RAISE FND_API.G_EXC_ERROR;
1137: END IF;
1138: END IF;
1139: CLOSE c_cust_site_check;

Line 1178: FND_MSG_PUB.ADD;

1174:
1175: IF l_from_rel_type <> l_to_rel_type OR l_from_dflag <> l_to_dflag THEN
1176: IF(NOT isContactGroupRelType(p_from_entity_id,p_to_entity_id)) THEN
1177: FND_MESSAGE.set_name('AR','HZ_REL_NOT_SIMILAR');
1178: FND_MSG_PUB.ADD;
1179: RAISE FND_API.G_EXC_ERROR;
1180: END IF;
1181: END IF;
1182:

Line 1293: FND_MSG_PUB.Count_And_Get(

1289: WHERE batch_party_id = p_batch_party_id
1290: AND ROWNUM = 1);
1291:
1292: -- standard call to get message count and if count is 1, get message info.
1293: FND_MSG_PUB.Count_And_Get(
1294: p_encoded => FND_API.G_FALSE,
1295: p_count => x_msg_count,
1296: p_data => x_msg_data);
1297:

Line 1302: FND_MSG_PUB.Count_And_Get(

1298: EXCEPTION
1299: WHEN FND_API.G_EXC_ERROR THEN
1300: ROLLBACK to map_within_party;
1301: x_return_status := FND_API.G_RET_STS_ERROR;
1302: FND_MSG_PUB.Count_And_Get(
1303: p_encoded => FND_API.G_FALSE,
1304: p_count => x_msg_count,
1305: p_data => x_msg_data);
1306:

Line 1310: FND_MSG_PUB.Count_And_Get(

1306:
1307: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1308: ROLLBACK to map_within_party;
1309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1310: FND_MSG_PUB.Count_And_Get(
1311: p_encoded => FND_API.G_FALSE,
1312: p_count => x_msg_count,
1313: p_data => x_msg_data);
1314:

Line 1321: FND_MSG_PUB.ADD;

1317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1318:
1319: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1320: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1321: FND_MSG_PUB.ADD;
1322:
1323:
1324: FND_MSG_PUB.Count_And_Get(
1325: p_encoded => FND_API.G_FALSE,

Line 1324: FND_MSG_PUB.Count_And_Get(

1320: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1321: FND_MSG_PUB.ADD;
1322:
1323:
1324: FND_MSG_PUB.Count_And_Get(
1325: p_encoded => FND_API.G_FALSE,
1326: p_count => x_msg_count,
1327: p_data => x_msg_data);
1328:

Line 1387: fnd_msg_pub.initialize;

1383:
1384: BEGIN
1385:
1386: x_return_status := FND_API.G_RET_STS_SUCCESS;
1387: fnd_msg_pub.initialize;
1388:
1389: SAVEPOINT submit_batch;
1390:
1391: IF p_preview is null THEN

Line 1420: FND_MSG_PUB.ADD;

1416: message => l_message ) ;
1417:
1418: IF l_conc_dev_phase <> 'COMPLETE' THEN
1419: FND_MESSAGE.set_name('AR', 'HZ_CANNOT_SUBMIT_PROCESSING');
1420: FND_MSG_PUB.ADD;
1421: RAISE FND_API.G_EXC_ERROR;
1422: ELSE
1423: IF l_conc_dev_status <>'NORMAL' THEN
1424: l_request_id := fnd_request.submit_request('AR',

Line 1434: FND_MSG_PUB.ADD;

1430:
1431: IF l_request_id = 0 THEN
1432: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_CONC_ERROR');
1433: -- FND_MESSAGE.RETRIEVE(l_message);
1434: FND_MSG_PUB.ADD;
1435: RAISE FND_API.G_EXC_ERROR;
1436: retcode := 2;
1437: RETURN;
1438: END IF;

Line 1451: FND_MSG_PUB.ADD;

1447: FALSE,
1448: p_batch_id, l_preview );
1449: IF l_request_id = 0 THEN
1450: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_CONC_ERROR');
1451: FND_MSG_PUB.ADD;
1452: RAISE FND_API.G_EXC_ERROR;
1453: retcode := 2;
1454: RETURN;
1455: END IF;

Line 1458: FND_MSG_PUB.ADD;

1454: RETURN;
1455: END IF;
1456: ELSE
1457: FND_MESSAGE.set_name('AR', 'HZ_CANNOT_SUBMIT_REQUEST');
1458: FND_MSG_PUB.ADD;
1459: RAISE FND_API.G_EXC_ERROR;
1460: END IF;
1461: END IF; --l_conc_status
1462: END IF; --l_conc_dev_phase

Line 1475: FND_MSG_PUB.ADD;

1471:
1472: IF l_request_id = 0 THEN
1473: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_CONC_ERROR');
1474: -- FND_MESSAGE.RETRIEVE(l_message);
1475: FND_MSG_PUB.ADD;
1476: RAISE FND_API.G_EXC_ERROR;
1477: -- retcode := 2;
1478: -- RETURN;
1479: END IF;

Line 1505: FND_MSG_PUB.Count_And_Get(

1501:
1502: x_request_id := l_request_id;
1503:
1504: -- standard call to get message count and if count is 1, get message info.
1505: FND_MSG_PUB.Count_And_Get(
1506: p_encoded => FND_API.G_FALSE,
1507: p_count => x_msg_count,
1508: p_data => x_msg_data);
1509:

Line 1514: FND_MSG_PUB.Count_And_Get(

1510: EXCEPTION
1511: WHEN FND_API.G_EXC_ERROR THEN
1512: ROLLBACK to submit_batch;
1513: x_return_status := FND_API.G_RET_STS_ERROR;
1514: FND_MSG_PUB.Count_And_Get(
1515: p_encoded => FND_API.G_FALSE,
1516: p_count => x_msg_count,
1517: p_data => x_msg_data);
1518:

Line 1522: FND_MSG_PUB.Count_And_Get(

1518:
1519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1520: ROLLBACK to submit_batch;
1521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1522: FND_MSG_PUB.Count_And_Get(
1523: p_encoded => FND_API.G_FALSE,
1524: p_count => x_msg_count,
1525: p_data => x_msg_data);
1526:

Line 1533: FND_MSG_PUB.ADD;

1529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1530:
1531: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1532: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1533: FND_MSG_PUB.ADD;
1534:
1535: FND_MSG_PUB.Count_And_Get(
1536: p_encoded => FND_API.G_FALSE,
1537: p_count => x_msg_count,

Line 1535: FND_MSG_PUB.Count_And_Get(

1531: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1532: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1533: FND_MSG_PUB.ADD;
1534:
1535: FND_MSG_PUB.Count_And_Get(
1536: p_encoded => FND_API.G_FALSE,
1537: p_count => x_msg_count,
1538: p_data => x_msg_data);
1539: END submit_batch;

Line 2164: fnd_msg_pub.initialize;

2160: BEGIN
2161:
2162: savepoint suggested_defaults;
2163:
2164: fnd_msg_pub.initialize;
2165: --Initialize API return status to success.
2166: x_return_status := FND_API.G_RET_STS_SUCCESS;
2167:
2168: IF(p_batch_id IS NULL OR

Line 2172: FND_MSG_PUB.ADD;

2168: IF(p_batch_id IS NULL OR
2169: p_batch_id = FND_API.G_MISS_NUM) THEN
2170: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2171: FND_MESSAGE.SET_TOKEN('COLUMN' ,'DUP_SET_ID');
2172: FND_MSG_PUB.ADD;
2173: RAISE FND_API.G_EXC_ERROR;
2174: END IF;
2175:
2176: open get_dup_sets_info(p_batch_id);

Line 2268: FND_MSG_PUB.ADD;

2264: l_reln_match_rule := nvl(fnd_profile.value('HZ_SUGG_RELN_MATCH_RULE'),l_default_relat_rule);
2265:
2266: if((l_addr_match_rule = 0) OR (l_reln_match_rule = 0)) then
2267: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_MATCH_RULE');
2268: FND_MSG_PUB.ADD;
2269: RAISE FND_API.G_EXC_ERROR;
2270: end if;
2271:
2272: -- call suggested defaults for address and relationship

Line 2281: FND_MSG_PUB.Count_And_Get(

2277:
2278: WHEN FND_API.G_EXC_ERROR THEN
2279: ROLLBACK TO suggested_defaults;
2280: x_return_status := FND_API.G_RET_STS_ERROR;
2281: FND_MSG_PUB.Count_And_Get(
2282: p_encoded => FND_API.G_FALSE,
2283: p_count => x_msg_count,
2284: p_data => x_msg_data);
2285:

Line 2289: FND_MSG_PUB.Count_And_Get(

2285:
2286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2287: ROLLBACK TO suggested_defaults;
2288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2289: FND_MSG_PUB.Count_And_Get(
2290: p_encoded => FND_API.G_FALSE,
2291: p_count => x_msg_count,
2292: p_data => x_msg_data);
2293:

Line 2299: FND_MSG_PUB.ADD;

2295: ROLLBACK TO suggested_defaults;
2296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2297: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2298: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2299: FND_MSG_PUB.ADD;
2300: FND_MSG_PUB.Count_And_Get(
2301: p_encoded => FND_API.G_FALSE,
2302: p_count => x_msg_count,
2303: p_data => x_msg_data);

Line 2300: FND_MSG_PUB.Count_And_Get(

2296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2297: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2298: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2299: FND_MSG_PUB.ADD;
2300: FND_MSG_PUB.Count_And_Get(
2301: p_encoded => FND_API.G_FALSE,
2302: p_count => x_msg_count,
2303: p_data => x_msg_data);
2304:

Line 3494: FND_MSG_PUB.Count_And_Get(

3490:
3491: WHEN FND_API.G_EXC_ERROR THEN
3492: ROLLBACK TO apply_suggested_default;
3493: x_return_status := FND_API.G_RET_STS_ERROR;
3494: FND_MSG_PUB.Count_And_Get(
3495: p_encoded => FND_API.G_FALSE,
3496: p_count => x_msg_count,
3497: p_data => x_msg_data);
3498:

Line 3502: FND_MSG_PUB.Count_And_Get(

3498:
3499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3500: ROLLBACK TO apply_suggested_default;
3501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3502: FND_MSG_PUB.Count_And_Get(
3503: p_encoded => FND_API.G_FALSE,
3504: p_count => x_msg_count,
3505: p_data => x_msg_data);
3506:

Line 3512: FND_MSG_PUB.ADD;

3508: ROLLBACK TO apply_suggested_default;
3509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3510: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3511: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3512: FND_MSG_PUB.ADD;
3513: FND_MSG_PUB.Count_And_Get(
3514: p_encoded => FND_API.G_FALSE,
3515: p_count => x_msg_count,
3516: p_data => x_msg_data);

Line 3513: FND_MSG_PUB.Count_And_Get(

3509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3510: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3511: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3512: FND_MSG_PUB.ADD;
3513: FND_MSG_PUB.Count_And_Get(
3514: p_encoded => FND_API.G_FALSE,
3515: p_count => x_msg_count,
3516: p_data => x_msg_data);
3517:

Line 3710: FND_MSG_PUB.Count_And_Get(

3706:
3707: WHEN FND_API.G_EXC_ERROR THEN
3708: ROLLBACK TO clear_suggested_default;
3709: x_return_status := FND_API.G_RET_STS_ERROR;
3710: FND_MSG_PUB.Count_And_Get(
3711: p_encoded => FND_API.G_FALSE,
3712: p_count => x_msg_count,
3713: p_data => x_msg_data);
3714:

Line 3718: FND_MSG_PUB.Count_And_Get(

3714:
3715: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3716: ROLLBACK TO clear_suggested_default;
3717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3718: FND_MSG_PUB.Count_And_Get(
3719: p_encoded => FND_API.G_FALSE,
3720: p_count => x_msg_count,
3721: p_data => x_msg_data);
3722:

Line 3728: FND_MSG_PUB.ADD;

3724: ROLLBACK TO clear_suggested_default;
3725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3726: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3727: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3728: FND_MSG_PUB.ADD;
3729: FND_MSG_PUB.Count_And_Get(
3730: p_encoded => FND_API.G_FALSE,
3731: p_count => x_msg_count,
3732: p_data => x_msg_data);

Line 3729: FND_MSG_PUB.Count_And_Get(

3725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3726: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3727: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3728: FND_MSG_PUB.ADD;
3729: FND_MSG_PUB.Count_And_Get(
3730: p_encoded => FND_API.G_FALSE,
3731: p_count => x_msg_count,
3732: p_data => x_msg_data);
3733:

Line 3918: fnd_msg_pub.initialize;

3914: if l_count <>0
3915: then return;
3916: end if;
3917:
3918: fnd_msg_pub.initialize;
3919:
3920: savepoint create_reln_sysbatch;
3921:
3922: update hz_merge_batch

Line 4078: FND_MSG_PUB.Count_And_Get(

4074:
4075: WHEN FND_API.G_EXC_ERROR THEN
4076: ROLLBACK TO create_reln_sysbatch;
4077: x_return_status := FND_API.G_RET_STS_ERROR;
4078: FND_MSG_PUB.Count_And_Get(
4079: p_encoded => FND_API.G_FALSE,
4080: p_count => x_msg_count,
4081: p_data => x_msg_data);
4082:

Line 4086: FND_MSG_PUB.Count_And_Get(

4082:
4083: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4084: ROLLBACK TO create_reln_sysbatch;
4085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4086: FND_MSG_PUB.Count_And_Get(
4087: p_encoded => FND_API.G_FALSE,
4088: p_count => x_msg_count,
4089: p_data => x_msg_data);
4090:

Line 4096: FND_MSG_PUB.ADD;

4092: ROLLBACK TO create_reln_sysbatch;
4093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4094: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4095: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4096: FND_MSG_PUB.ADD;
4097: FND_MSG_PUB.Count_And_Get(
4098: p_encoded => FND_API.G_FALSE,
4099: p_count => x_msg_count,
4100: p_data => x_msg_data);

Line 4097: FND_MSG_PUB.Count_And_Get(

4093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4094: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4095: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4096: FND_MSG_PUB.ADD;
4097: FND_MSG_PUB.Count_And_Get(
4098: p_encoded => FND_API.G_FALSE,
4099: p_count => x_msg_count,
4100: p_data => x_msg_data);
4101:

Line 4149: fnd_msg_pub.initialize;

4145:
4146: BEGIN
4147:
4148: x_return_status := FND_API.G_RET_STS_SUCCESS;
4149: fnd_msg_pub.initialize;
4150:
4151: savepoint delete_mapping;
4152:
4153: l_batch_id := p_batch_id;

Line 4214: FND_MSG_PUB.Count_And_Get(

4210:
4211: WHEN FND_API.G_EXC_ERROR THEN
4212: ROLLBACK TO delete_mapping;
4213: x_return_status := FND_API.G_RET_STS_ERROR;
4214: FND_MSG_PUB.Count_And_Get(
4215: p_encoded => FND_API.G_FALSE,
4216: p_count => x_msg_count,
4217: p_data => x_msg_data);
4218:

Line 4222: FND_MSG_PUB.Count_And_Get(

4218:
4219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4220: ROLLBACK TO delete_mapping;
4221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4222: FND_MSG_PUB.Count_And_Get(
4223: p_encoded => FND_API.G_FALSE,
4224: p_count => x_msg_count,
4225: p_data => x_msg_data);
4226:

Line 4232: FND_MSG_PUB.ADD;

4228: ROLLBACK TO delete_mapping;
4229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4230: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4231: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4232: FND_MSG_PUB.ADD;
4233: FND_MSG_PUB.Count_And_Get(
4234: p_encoded => FND_API.G_FALSE,
4235: p_count => x_msg_count,
4236: p_data => x_msg_data);

Line 4233: FND_MSG_PUB.Count_And_Get(

4229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4230: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4231: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4232: FND_MSG_PUB.ADD;
4233: FND_MSG_PUB.Count_And_Get(
4234: p_encoded => FND_API.G_FALSE,
4235: p_count => x_msg_count,
4236: p_data => x_msg_data);
4237:

Line 4298: fnd_msg_pub.initialize;

4294: AND mpd.merge_to_entity_id = cp_entity_id;
4295:
4296: BEGIN
4297:
4298: fnd_msg_pub.initialize;
4299: x_return_status := FND_API.G_RET_STS_SUCCESS;
4300:
4301: SAVEPOINT unmap_child_records;
4302:

Line 4307: FND_MSG_PUB.ADD;

4303: IF (p_merge_batch_id is null) OR (p_merge_type IS NULL )
4304: OR (p_entity is null) OR (p_entity_id IS NULL) THEN
4305: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_BATCH_PARAM');
4306: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BATCH_PARTY_ID');
4307: FND_MSG_PUB.ADD;
4308: RAISE FND_API.G_EXC_ERROR;
4309: END IF;
4310:
4311: OPEN c_children(p_merge_batch_id, p_entity, p_entity_id);

Line 4348: FND_MSG_PUB.Count_And_Get(

4344:
4345: END IF;
4346:
4347: -- standard call to get message count and if count is 1, get message info.
4348: FND_MSG_PUB.Count_And_Get(
4349: p_encoded => FND_API.G_FALSE,
4350: p_count => x_msg_count,
4351: p_data => x_msg_data);
4352:

Line 4357: FND_MSG_PUB.Count_And_Get(

4353: EXCEPTION
4354: WHEN FND_API.G_EXC_ERROR THEN
4355: ROLLBACK to unmap_child_records ;
4356: x_return_status := FND_API.G_RET_STS_ERROR;
4357: FND_MSG_PUB.Count_And_Get(
4358: p_encoded => FND_API.G_FALSE,
4359: p_count => x_msg_count,
4360: p_data => x_msg_data);
4361:

Line 4365: FND_MSG_PUB.Count_And_Get(

4361:
4362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4363: ROLLBACK to unmap_child_records ;
4364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4365: FND_MSG_PUB.Count_And_Get(
4366: p_encoded => FND_API.G_FALSE,
4367: p_count => x_msg_count,
4368: p_data => x_msg_data);
4369:

Line 4376: FND_MSG_PUB.ADD;

4372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4373:
4374: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4375: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4376: FND_MSG_PUB.ADD;
4377:
4378:
4379: FND_MSG_PUB.Count_And_Get(
4380: p_encoded => FND_API.G_FALSE,

Line 4379: FND_MSG_PUB.Count_And_Get(

4375: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4376: FND_MSG_PUB.ADD;
4377:
4378:
4379: FND_MSG_PUB.Count_And_Get(
4380: p_encoded => FND_API.G_FALSE,
4381: p_count => x_msg_count,
4382: p_data => x_msg_data);
4383:

Line 4504: FND_MSG_PUB.initialize;

4500:
4501: -- Initialize message list if p_init_msg_list is set to TRUE.
4502: IF FND_API.to_Boolean( p_init_msg_list )
4503: THEN
4504: FND_MSG_PUB.initialize;
4505: END IF;
4506: if HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE <> 'BO_API' -- BO API handled overlapping logic already. Skip it here.
4507: then
4508: if p_dup_set_id is not null -- data passed in from Data librarian(DL) UI

Line 4521: FND_MSG_PUB.ADD;

4517: then
4518: x_return_status := FND_API.G_RET_STS_ERROR;
4519: FND_MESSAGE.SET_NAME('AR', 'HZ_DL_PARTY_ALREADY_MERGED');
4520: FND_MESSAGE.SET_TOKEN('ID', l_party_number );
4521: FND_MSG_PUB.ADD;
4522: end if;
4523: end loop;
4524: close dset_overlap_merged_party_csr;
4525:

Line 4539: FND_MSG_PUB.ADD;

4535: then
4536: FND_MESSAGE.SET_NAME('AR', 'HZ_PM_MR_EXIST_DL');
4537: FND_MESSAGE.SET_TOKEN('ID', l_party_number );
4538: FND_MESSAGE.SET_TOKEN('REQUEST_ID', l_batch_id);
4539: FND_MSG_PUB.ADD;
4540: else -- from FORM UI
4541: FND_MESSAGE.SET_NAME('AR', 'HZ_DL_MR_EXIST_FORM_WARNING');
4542: FND_MESSAGE.SET_TOKEN('ID', l_party_number );
4543: FND_MESSAGE.SET_TOKEN('BATCH_ID', l_batch_id);

Line 4544: FND_MSG_PUB.ADD;

4540: else -- from FORM UI
4541: FND_MESSAGE.SET_NAME('AR', 'HZ_DL_MR_EXIST_FORM_WARNING');
4542: FND_MESSAGE.SET_TOKEN('ID', l_party_number );
4543: FND_MESSAGE.SET_TOKEN('BATCH_ID', l_batch_id);
4544: FND_MSG_PUB.ADD;
4545: end if;
4546: end if;
4547: end loop;
4548: close dset_overlap_req_party_csr;

Line 4575: FND_MSG_PUB.Count_And_Get(

4571:
4572: x_return_status := FND_API.G_RET_STS_ERROR;
4573: end if;
4574:
4575: FND_MSG_PUB.Count_And_Get(
4576: p_encoded => FND_API.G_FALSE,
4577: p_count => x_msg_count,
4578: p_data => x_msg_data);
4579:

Line 4611: FND_MSG_PUB.ADD;

4607: if l_err_reported = 0 then
4608: x_return_status := FND_API.G_RET_STS_ERROR;
4609: FND_MESSAGE.SET_NAME('AR', 'HZ_DL_PARTY_ALREADY_MERGED');
4610: FND_MESSAGE.SET_TOKEN('ID', l_party_number );
4611: FND_MSG_PUB.ADD;
4612: l_err_reported := 1;
4613: end if;
4614: end if;
4615: end loop;

Line 4625: FND_MSG_PUB.ADD;

4621: WHEN OTHERS THEN
4622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4623: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4624: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4625: FND_MSG_PUB.ADD;
4626: FND_MSG_PUB.Count_And_Get(
4627: p_encoded => FND_API.G_FALSE,
4628: p_count => x_msg_count,
4629: p_data => x_msg_data);

Line 4626: FND_MSG_PUB.Count_And_Get(

4622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4623: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4624: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4625: FND_MSG_PUB.ADD;
4626: FND_MSG_PUB.Count_And_Get(
4627: p_encoded => FND_API.G_FALSE,
4628: p_count => x_msg_count,
4629: p_data => x_msg_data);
4630:

Line 4777: FND_MSG_PUB.initialize; -- make sure only show warning messages

4773: l_msg varchar2(2000);
4774: l_messages varchar2(2000) :='';
4775:
4776: begin
4777: FND_MSG_PUB.initialize; -- make sure only show warning messages
4778: x_return_status := FND_API.G_RET_STS_SUCCESS;
4779: open check_site_merge_csr;
4780: loop
4781: fetch check_site_merge_csr into l_account_number, l_to_entity_id;

Line 4792: FND_MSG_PUB.ADD;

4788:
4789: FND_MESSAGE.SET_NAME('AR', 'HZ_DL_ACCTSITEDUP_INFO');
4790: FND_MESSAGE.SET_TOKEN('ACCTNUM', l_account_number);
4791: FND_MESSAGE.SET_TOKEN('CONCAT_DUP_ADDR', l_concat_addr);
4792: FND_MSG_PUB.ADD;
4793:
4794: elsif p_generate_note_flag = 'Y'
4795: then
4796: l_to_addr := get_addresses(l_to_entity_id,'N');

Line 4798: FND_MSG_PUB.initialize;-- only want the current message

4794: elsif p_generate_note_flag = 'Y'
4795: then
4796: l_to_addr := get_addresses(l_to_entity_id,'N');
4797:
4798: FND_MSG_PUB.initialize;-- only want the current message
4799: FND_MESSAGE.SET_NAME('AR', 'HZ_DL_ACCTSITEDUP_NOTE');
4800: FND_MESSAGE.SET_TOKEN('ACCTNUM', l_account_number);
4801: FND_MESSAGE.SET_TOKEN('MERGETO_ADDR', l_to_addr);
4802: FND_MSG_PUB.ADD;

Line 4802: FND_MSG_PUB.ADD;

4798: FND_MSG_PUB.initialize;-- only want the current message
4799: FND_MESSAGE.SET_NAME('AR', 'HZ_DL_ACCTSITEDUP_NOTE');
4800: FND_MESSAGE.SET_TOKEN('ACCTNUM', l_account_number);
4801: FND_MESSAGE.SET_TOKEN('MERGETO_ADDR', l_to_addr);
4802: FND_MSG_PUB.ADD;
4803:
4804: l_note_text := fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);
4805:
4806: str := 'BEGIN '||

Line 4804: l_note_text := fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);

4800: FND_MESSAGE.SET_TOKEN('ACCTNUM', l_account_number);
4801: FND_MESSAGE.SET_TOKEN('MERGETO_ADDR', l_to_addr);
4802: FND_MSG_PUB.ADD;
4803:
4804: l_note_text := fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);
4805:
4806: str := 'BEGIN '||
4807: 'JTF_NOTES_PUB.Create_note(null,null,1,FND_API.g_false,FND_API.g_true,100,'
4808: ||':x_return_status,:x_msg_count,:x_msg_data,'||'null,'||':p_merge_batch_id,'

Line 4823: FND_MSG_PUB.Count_And_Get(

4819: close check_site_merge_csr;
4820:
4821: if p_generate_note_flag = 'N'
4822: then
4823: FND_MSG_PUB.Count_And_Get(
4824: p_encoded => FND_API.G_FALSE,
4825: p_count => x_msg_count,
4826: p_data => x_msg_data);
4827:

Line 4830: l_messages := fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);

4826: p_data => x_msg_data);
4827:
4828: if x_msg_count = 1
4829: then
4830: l_messages := fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);
4831: else
4832: FOR l_index IN 1..x_msg_count LOOP
4833: l_msg := FND_MSG_PUB.Get(
4834: p_msg_index => l_index,

Line 4833: l_msg := FND_MSG_PUB.Get(

4829: then
4830: l_messages := fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);
4831: else
4832: FOR l_index IN 1..x_msg_count LOOP
4833: l_msg := FND_MSG_PUB.Get(
4834: p_msg_index => l_index,
4835: p_encoded => FND_API.G_FALSE);
4836: --l_messages:=l_messages||fnd_global.local_chr(10)||l_msg||fnd_global.local_chr(10);
4837: l_messages:=l_messages||'
'||l_msg||'
';

Line 4849: FND_MSG_PUB.ADD;

4845: WHEN OTHERS THEN
4846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4847: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4848: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4849: FND_MSG_PUB.ADD;
4850: FND_MSG_PUB.Count_And_Get(
4851: p_encoded => FND_API.G_FALSE,
4852: p_count => x_msg_count,
4853: p_data => x_msg_data);

Line 4850: FND_MSG_PUB.Count_And_Get(

4846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4847: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4848: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4849: FND_MSG_PUB.ADD;
4850: FND_MSG_PUB.Count_And_Get(
4851: p_encoded => FND_API.G_FALSE,
4852: p_count => x_msg_count,
4853: p_data => x_msg_data);
4854: