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_MESSAGE

Line 144: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_BATCH_PARAM');

140: --check if the dup_set_id is valid
141: OPEN c_batch_name;
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;

Line 145: FND_MESSAGE.SET_TOKEN('PARAMETER','DUP_SET_ID' );

141: OPEN c_batch_name;
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;

Line 348: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');

344: WHERE dup_set_id = p_dup_set_id;
345:
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;

Line 349: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_dup_sets');

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

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

385: WHEN OTHERS THEN
386: ROLLBACK to create_merge_batch;
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(

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

386: ROLLBACK to create_merge_batch;
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,

Line 571: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_BATCH_PARAM');

567: WHERE batch_party_id = p_batch_party_id;
568:
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;

Line 572: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BATCH_PARTY_ID');

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

Line 585: FND_MESSAGE.set_name('AR','HZ_MAND_MERGE_ERROR');

581: AND entity_name = p_entity
582: AND merge_from_entity_id = p_from_entity_id;
583:
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;

Line 586: FND_MESSAGE.set_token('ENTITY1',p_from_entity_id);

582: AND merge_from_entity_id = p_from_entity_id;
583:
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;

Line 587: FND_MESSAGE.set_token('ENTITY2',p_to_entity_id);

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

Line 618: FND_MESSAGE.set_name('AR','HZ_CANNOT_UNMAP_ERROR');

614: AND md2.merge_from_entity_id = p_to_entity_id
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;

Line 626: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_BATCH_PARAM');

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

Line 627: FND_MESSAGE.SET_TOKEN('PARAMETER', 'MERGE_FROM_ENTITY_ID');

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

Line 652: FND_MESSAGE.set_name('AR','HZ_DL_ADDR_MASTER_ERR');

648: CLOSE c_address;
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

Line 667: FND_MESSAGE.set_name('AR','HZ_PS_LOC_ASSIGN_ERROR');

663: x_return_status,
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:

Line 722: FND_MESSAGE.set_name('AR','HZ_REL_NOT_SIMILAR');

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

Line 833: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');

829: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
830: WHERE BATCH_ID = l_dup_set_id;
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;

Line 834: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_merge_party_details');

830: WHERE BATCH_ID = l_dup_set_id;
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:

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

863: WHEN OTHERS THEN
864: ROLLBACK to map_detail_record;
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:

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

864: ROLLBACK to map_detail_record;
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(

Line 1024: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_BATCH_PARAM');

1020:
1021: ---Check for valid batch id
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;

Line 1025: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BATCH_PARTY_ID');

1021: ---Check for valid batch id
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:

Line 1032: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_BATCH_PARAM');

1028: end if;
1029:
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;

Line 1033: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BATCH_PARTY_ID');

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

Line 1040: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_BATCH_PARAM');

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

Line 1041: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BATCH_PARTY_ID');

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

Line 1052: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_REC_PRESENT');

1048: FETCH c_map_detail_record_exist into l_map_dtl_count;
1049: CLOSE c_map_detail_record_exist;
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;

Line 1053: FND_MESSAGE.SET_TOKEN('ID', p_from_entity_id);

1049: CLOSE c_map_detail_record_exist;
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:

Line 1069: FND_MESSAGE.set_name('AR','HZ_PS_LOC_ASSIGN_ERROR');

1065: /*OPEN c_loc_assignments(p_from_entity_id,p_to_entity_id);
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: */

Line 1091: FND_MESSAGE.set_name('AR','HZ_DL_ADDR_MASTER_ERR');

1087: CLOSE c_address;
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:

Line 1107: FND_MESSAGE.set_name('AR','HZ_PS_LOC_ASSIGN_ERROR');

1103: x_return_status,
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:

Line 1133: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_BATCH_PARAM');

1129: --Both from and to party_site_id's should point to same party_id
1130: --and that party should be the one that is getting merged
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;

Line 1134: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BATCH_PARTY_ID');

1130: --and that party should be the one that is getting merged
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;

Line 1177: FND_MESSAGE.set_name('AR','HZ_REL_NOT_SIMILAR');

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

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

1315: WHEN OTHERS THEN
1316: ROLLBACK to map_within_party;
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:

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

1316: ROLLBACK to map_within_party;
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(

Line 1419: FND_MESSAGE.set_name('AR', 'HZ_CANNOT_SUBMIT_PROCESSING');

1415: dev_status => l_conc_dev_status,
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

Line 1432: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_CONC_ERROR');

1428: FALSE,
1429: p_batch_id, l_preview );
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;

Line 1433: -- FND_MESSAGE.RETRIEVE(l_message);

1429: p_batch_id, l_preview );
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;

Line 1450: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_CONC_ERROR');

1446: to_char(sysdate,'DD-MON-YY HH24:MI:SS'),
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;

Line 1457: FND_MESSAGE.set_name('AR', 'HZ_CANNOT_SUBMIT_REQUEST');

1453: retcode := 2;
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

Line 1473: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_CONC_ERROR');

1469: ,FALSE,
1470: to_char(p_batch_id), l_preview );
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;

Line 1474: -- FND_MESSAGE.RETRIEVE(l_message);

1470: to_char(p_batch_id), l_preview );
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;

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

1527: WHEN OTHERS THEN
1528: ROLLBACK to submit_batch;
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(

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

1528: ROLLBACK to submit_batch;
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,

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

1646: CLOSE merged_relns;
1647:
1648: EXCEPTION
1649: WHEN OTHERS THEN
1650: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1651: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1652: APP_EXCEPTION.RAISE_EXCEPTION;
1653: END insert_reln_parties;
1654:

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

1647:
1648: EXCEPTION
1649: WHEN OTHERS THEN
1650: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1651: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1652: APP_EXCEPTION.RAISE_EXCEPTION;
1653: END insert_reln_parties;
1654:
1655:

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

1753: END LOOP;
1754: CLOSE c_from_ps_loc;
1755: EXCEPTION
1756: WHEN OTHERS THEN
1757: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1758: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1759: APP_EXCEPTION.RAISE_EXCEPTION;
1760: END insert_party_site_details;
1761:

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

1754: CLOSE c_from_ps_loc;
1755: EXCEPTION
1756: WHEN OTHERS THEN
1757: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1758: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1759: APP_EXCEPTION.RAISE_EXCEPTION;
1760: END insert_party_site_details;
1761:
1762:

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

2124: END LOOP;
2125: CLOSE c_from_reln;
2126: EXCEPTION
2127: WHEN OTHERS THEN
2128: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2129: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2130: APP_EXCEPTION.RAISE_EXCEPTION;
2131: END insert_party_reln_details;
2132:

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

2125: CLOSE c_from_reln;
2126: EXCEPTION
2127: WHEN OTHERS THEN
2128: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2129: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2130: APP_EXCEPTION.RAISE_EXCEPTION;
2131: END insert_party_reln_details;
2132:
2133: /*=======================================================================+

Line 2170: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

2166: x_return_status := FND_API.G_RET_STS_SUCCESS;
2167:
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;

Line 2171: FND_MESSAGE.SET_TOKEN('COLUMN' ,'DUP_SET_ID');

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

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

2263: l_addr_match_rule := nvl(fnd_profile.value('HZ_SUGG_ADDR_MATCH_RULE'),l_default_addr_rule);
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:

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

2293:
2294: WHEN OTHERS THEN
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,

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

2294: WHEN OTHERS THEN
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,

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

2732:
2733: EXCEPTION
2734:
2735: WHEN OTHERS THEN
2736: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2737: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2738: APP_EXCEPTION.RAISE_EXCEPTION;
2739:
2740: END suggested_party_sites;

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

2733: EXCEPTION
2734:
2735: WHEN OTHERS THEN
2736: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2737: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2738: APP_EXCEPTION.RAISE_EXCEPTION;
2739:
2740: END suggested_party_sites;
2741:

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

3160:
3161: EXCEPTION
3162:
3163: WHEN OTHERS THEN
3164: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3165: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3166: APP_EXCEPTION.RAISE_EXCEPTION;
3167:
3168: END suggested_party_reln;

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

3161: EXCEPTION
3162:
3163: WHEN OTHERS THEN
3164: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3165: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3166: APP_EXCEPTION.RAISE_EXCEPTION;
3167:
3168: END suggested_party_reln;
3169:

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

3304: END LOOP;
3305: CLOSE c_from_ps_loc;
3306: EXCEPTION
3307: WHEN OTHERS THEN
3308: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3309: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3310: APP_EXCEPTION.RAISE_EXCEPTION;
3311: END insert_sugg_reln_ps_details;
3312:

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

3305: CLOSE c_from_ps_loc;
3306: EXCEPTION
3307: WHEN OTHERS THEN
3308: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3309: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3310: APP_EXCEPTION.RAISE_EXCEPTION;
3311: END insert_sugg_reln_ps_details;
3312:
3313: PROCEDURE insert_sugg_reln_party(

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

3354: );
3355:
3356: EXCEPTION
3357: WHEN OTHERS THEN
3358: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3359: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3360: APP_EXCEPTION.RAISE_EXCEPTION;
3361: END insert_sugg_reln_party;
3362:

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

3355:
3356: EXCEPTION
3357: WHEN OTHERS THEN
3358: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3359: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3360: APP_EXCEPTION.RAISE_EXCEPTION;
3361: END insert_sugg_reln_party;
3362:
3363: --

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

3506:
3507: WHEN OTHERS THEN
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,

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

3507: WHEN OTHERS THEN
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,

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

3722:
3723: WHEN OTHERS THEN
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,

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

3723: WHEN OTHERS THEN
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,

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

4090:
4091: WHEN OTHERS THEN
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,

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

4091: WHEN OTHERS THEN
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,

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

4226:
4227: WHEN OTHERS THEN
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,

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

4227: WHEN OTHERS THEN
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,

Line 4305: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_BATCH_PARAM');

4301: SAVEPOINT unmap_child_records;
4302:
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;

Line 4306: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BATCH_PARTY_ID');

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

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

4370: WHEN OTHERS THEN
4371: ROLLBACK to unmap_child_records;
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:

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

4371: ROLLBACK to unmap_child_records;
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(

Line 4519: FND_MESSAGE.SET_NAME('AR', 'HZ_DL_PARTY_ALREADY_MERGED');

4515: exit when dset_overlap_merged_party_csr%NOTFOUND;
4516: if l_party_number is not null
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;

Line 4520: FND_MESSAGE.SET_TOKEN('ID', l_party_number );

4516: if l_party_number is not null
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;

Line 4536: FND_MESSAGE.SET_NAME('AR', 'HZ_PM_MR_EXIST_DL');

4532: l_party_number := get_party_number(l_party_id);
4533: x_return_status := FND_API.G_RET_STS_ERROR;
4534: if get_merge_batch_data_source(l_batch_id) = 'D' -- from DL UI
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

Line 4537: FND_MESSAGE.SET_TOKEN('ID', l_party_number );

4533: x_return_status := FND_API.G_RET_STS_ERROR;
4534: if get_merge_batch_data_source(l_batch_id) = 'D' -- from DL UI
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');

Line 4538: FND_MESSAGE.SET_TOKEN('REQUEST_ID', l_batch_id);

4534: if get_merge_batch_data_source(l_batch_id) = 'D' -- from DL UI
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 );

Line 4541: FND_MESSAGE.SET_NAME('AR', 'HZ_DL_MR_EXIST_FORM_WARNING');

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);
4544: FND_MSG_PUB.ADD;
4545: end if;

Line 4542: 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);
4544: FND_MSG_PUB.ADD;
4545: end if;
4546: end if;

Line 4543: FND_MESSAGE.SET_TOKEN('BATCH_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);
4544: FND_MSG_PUB.ADD;
4545: end if;
4546: end if;
4547: end loop;

Line 4609: FND_MESSAGE.SET_NAME('AR', 'HZ_DL_PARTY_ALREADY_MERGED');

4605: FND_FILE.put_line(fnd_file.log,'The Party with Registry ID ' || l_party_number || ' has already been merged.');
4606:
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;

Line 4610: FND_MESSAGE.SET_TOKEN('ID', l_party_number );

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

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

4619: end if; --HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE <> 'BO_API'
4620: EXCEPTION
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,

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

4620: EXCEPTION
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,

Line 4789: FND_MESSAGE.SET_NAME('AR', 'HZ_DL_ACCTSITEDUP_INFO');

4785: if p_generate_note_flag = 'N'
4786: then
4787: l_concat_addr := get_addresses(l_to_entity_id,'Y');
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:

Line 4790: FND_MESSAGE.SET_TOKEN('ACCTNUM', l_account_number);

4786: then
4787: l_concat_addr := get_addresses(l_to_entity_id,'Y');
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'

Line 4791: FND_MESSAGE.SET_TOKEN('CONCAT_DUP_ADDR', l_concat_addr);

4787: l_concat_addr := get_addresses(l_to_entity_id,'Y');
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

Line 4799: FND_MESSAGE.SET_NAME('AR', 'HZ_DL_ACCTSITEDUP_NOTE');

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

Line 4800: FND_MESSAGE.SET_TOKEN('ACCTNUM', l_account_number);

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;
4803:
4804: l_note_text := fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);

Line 4801: FND_MESSAGE.SET_TOKEN('MERGETO_ADDR', l_to_addr);

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;
4803:
4804: l_note_text := fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);
4805:

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

4843:
4844: EXCEPTION
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,

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

4844: EXCEPTION
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,