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_BATCH_DUPLICATE dependencies on FND_API

Line 131: RAISE FND_API.G_EXC_ERROR;

127:
128: IF l_staged_var='N' THEN
129: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
130: FND_MSG_PUB.ADD;
131: RAISE FND_API.G_EXC_ERROR;
132: END IF;
133:
134: -- End bug 4736139
135:

Line 269: RAISE FND_API.G_EXC_ERROR;

265:
266: -- No MATCH RULE FOUND
267: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_MATCH_RULE');
268: FND_MSG_PUB.ADD;
269: RAISE FND_API.G_EXC_ERROR;
270: END IF;
271:
272: IF p_batch_name IS NULL OR p_batch_name = '' THEN
273: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_BATCH_NAME');

Line 275: RAISE FND_API.G_EXC_ERROR;

271:
272: IF p_batch_name IS NULL OR p_batch_name = '' THEN
273: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_BATCH_NAME');
274: FND_MSG_PUB.ADD;
275: RAISE FND_API.G_EXC_ERROR;
276: END IF;
277:
278: --- VJN INTRODUCED CODE FOR QUICK DUPLICATE IDENTIFICATION
279:

Line 448: WHEN FND_API.G_EXC_ERROR THEN

444: outandlog('End Time : '|| TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));
445: END IF;
446:
447: EXCEPTION
448: WHEN FND_API.G_EXC_ERROR THEN
449: outandlog('Expected Error section in Parent concurrent program. Aborting duplicate batch.' ||SQLERRM);
450: retcode := 2;
451: errbuf := errbuf || logerror;
452: FND_FILE.close;

Line 453: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

449: outandlog('Expected Error section in Parent concurrent program. Aborting duplicate batch.' ||SQLERRM);
450: retcode := 2;
451: errbuf := errbuf || logerror;
452: FND_FILE.close;
453: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
454: outandlog('UnExpected Error section in Parent concurrent program. Aborting duplicate batch.' ||SQLERRM);
455: retcode := 2;
456: errbuf := errbuf || logerror;
457: FND_FILE.close;

Line 466: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,

462: FND_FILE.close;
463: END;
464:
465: PROCEDURE find_party_dups (
466: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
467: p_rule_id IN NUMBER,
468: p_party_id IN NUMBER,
469: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
470: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,

Line 491: FND_API.G_FALSE,l_rule_id, p_party_id, x_party_search_rec,

487: BEGIN
488: l_rule_id := p_rule_id;
489:
490: HZ_PARTY_SEARCH.get_party_for_search(
491: FND_API.G_FALSE,l_rule_id, p_party_id, x_party_search_rec,
492: x_party_site_list, x_contact_list, x_contact_point_list,
493: l_return_status, l_msg_count, l_msg_data);
494:
495: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 495: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

491: FND_API.G_FALSE,l_rule_id, p_party_id, x_party_search_rec,
492: x_party_site_list, x_contact_list, x_contact_point_list,
493: l_return_status, l_msg_count, l_msg_data);
494:
495: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
496: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
497: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_ACQUIRE_ERROR');
498: FND_MESSAGE.SET_TOKEN('PARTY_ID', TO_CHAR(p_party_id));
499: FND_MSG_PUB.ADD;

Line 496: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

492: x_party_site_list, x_contact_list, x_contact_point_list,
493: l_return_status, l_msg_count, l_msg_data);
494:
495: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
496: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
497: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_ACQUIRE_ERROR');
498: FND_MESSAGE.SET_TOKEN('PARTY_ID', TO_CHAR(p_party_id));
499: FND_MSG_PUB.ADD;
500: RAISE FND_API.G_EXC_ERROR;

Line 500: RAISE FND_API.G_EXC_ERROR;

496: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
497: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_ACQUIRE_ERROR');
498: FND_MESSAGE.SET_TOKEN('PARTY_ID', TO_CHAR(p_party_id));
499: FND_MSG_PUB.ADD;
500: RAISE FND_API.G_EXC_ERROR;
501: ELSE
502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
503: END IF;
504: ELSE

Line 502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

498: FND_MESSAGE.SET_TOKEN('PARTY_ID', TO_CHAR(p_party_id));
499: FND_MSG_PUB.ADD;
500: RAISE FND_API.G_EXC_ERROR;
501: ELSE
502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
503: END IF;
504: ELSE
505: HZ_PARTY_SEARCH.find_duplicate_parties(
506: FND_API.G_FALSE,l_rule_id, p_party_id, NULL,

Line 506: FND_API.G_FALSE,l_rule_id, p_party_id, NULL,

502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
503: END IF;
504: ELSE
505: HZ_PARTY_SEARCH.find_duplicate_parties(
506: FND_API.G_FALSE,l_rule_id, p_party_id, NULL,
507: NULL, null, null, l_dup_set_id,x_search_ctx_id, l_num_matches,
508: l_return_status, l_msg_count, l_msg_data);
509: END IF;
510:

Line 512: WHEN FND_API.G_EXC_ERROR THEN

508: l_return_status, l_msg_count, l_msg_data);
509: END IF;
510:
511: EXCEPTION
512: WHEN FND_API.G_EXC_ERROR THEN
513: x_return_status := FND_API.G_RET_STS_ERROR;
514: FND_MSG_PUB.Count_And_Get(
515: p_encoded => FND_API.G_FALSE,
516: p_count => x_msg_count,

Line 513: x_return_status := FND_API.G_RET_STS_ERROR;

509: END IF;
510:
511: EXCEPTION
512: WHEN FND_API.G_EXC_ERROR THEN
513: x_return_status := FND_API.G_RET_STS_ERROR;
514: FND_MSG_PUB.Count_And_Get(
515: p_encoded => FND_API.G_FALSE,
516: p_count => x_msg_count,
517: p_data => x_msg_data);

Line 515: p_encoded => FND_API.G_FALSE,

511: EXCEPTION
512: WHEN FND_API.G_EXC_ERROR THEN
513: x_return_status := FND_API.G_RET_STS_ERROR;
514: FND_MSG_PUB.Count_And_Get(
515: p_encoded => FND_API.G_FALSE,
516: p_count => x_msg_count,
517: p_data => x_msg_data);
518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

514: FND_MSG_PUB.Count_And_Get(
515: p_encoded => FND_API.G_FALSE,
516: p_count => x_msg_count,
517: p_data => x_msg_data);
518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
520: FND_MSG_PUB.Count_And_Get(
521: p_encoded => FND_API.G_FALSE,
522: p_count => x_msg_count,

Line 519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

515: p_encoded => FND_API.G_FALSE,
516: p_count => x_msg_count,
517: p_data => x_msg_data);
518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
520: FND_MSG_PUB.Count_And_Get(
521: p_encoded => FND_API.G_FALSE,
522: p_count => x_msg_count,
523: p_data => x_msg_data);

Line 521: p_encoded => FND_API.G_FALSE,

517: p_data => x_msg_data);
518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
520: FND_MSG_PUB.Count_And_Get(
521: p_encoded => FND_API.G_FALSE,
522: p_count => x_msg_count,
523: p_data => x_msg_data);
524: WHEN OTHERS THEN
525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

521: p_encoded => FND_API.G_FALSE,
522: p_count => x_msg_count,
523: p_data => x_msg_data);
524: WHEN OTHERS THEN
525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
526: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SQL_EXCEP');
527: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
528: FND_MSG_PUB.ADD;
529:

Line 531: p_encoded => FND_API.G_FALSE,

527: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
528: FND_MSG_PUB.ADD;
529:
530: FND_MSG_PUB.Count_And_Get(
531: p_encoded => FND_API.G_FALSE,
532: p_count => x_msg_count,
533: p_data => x_msg_data);
534: END;
535:

Line 537: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,

533: p_data => x_msg_data);
534: END;
535:
536: PROCEDURE find_party_dups (
537: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
538: p_rule_id IN NUMBER,
539: p_party_id IN NUMBER,
540: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
541: p_contact_ids IN HZ_PARTY_SEARCH.IDList,

Line 564: FND_API.G_FALSE,l_rule_id, p_party_id, p_party_site_ids,p_contact_ids,

560: BEGIN
561: l_rule_id := p_rule_id;
562:
563: HZ_PARTY_SEARCH.get_search_criteria(
564: FND_API.G_FALSE,l_rule_id, p_party_id, p_party_site_ids,p_contact_ids,
565: p_contact_pt_ids, x_party_search_rec,
566: x_party_site_list, x_contact_list, x_contact_point_list,
567: l_return_status, l_msg_count, l_msg_data);
568:

Line 569: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

565: p_contact_pt_ids, x_party_search_rec,
566: x_party_site_list, x_contact_list, x_contact_point_list,
567: l_return_status, l_msg_count, l_msg_data);
568:
569: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
570: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
571: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_ACQUIRE_ERROR');
572: FND_MESSAGE.SET_TOKEN('PARTY_ID', TO_CHAR(p_party_id));
573: FND_MSG_PUB.ADD;

Line 570: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

566: x_party_site_list, x_contact_list, x_contact_point_list,
567: l_return_status, l_msg_count, l_msg_data);
568:
569: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
570: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
571: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_ACQUIRE_ERROR');
572: FND_MESSAGE.SET_TOKEN('PARTY_ID', TO_CHAR(p_party_id));
573: FND_MSG_PUB.ADD;
574: RAISE FND_API.G_EXC_ERROR;

Line 574: RAISE FND_API.G_EXC_ERROR;

570: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
571: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_ACQUIRE_ERROR');
572: FND_MESSAGE.SET_TOKEN('PARTY_ID', TO_CHAR(p_party_id));
573: FND_MSG_PUB.ADD;
574: RAISE FND_API.G_EXC_ERROR;
575: ELSE
576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
577: END IF;
578: ELSE

Line 576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

572: FND_MESSAGE.SET_TOKEN('PARTY_ID', TO_CHAR(p_party_id));
573: FND_MSG_PUB.ADD;
574: RAISE FND_API.G_EXC_ERROR;
575: ELSE
576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
577: END IF;
578: ELSE
579: HZ_PARTY_SEARCH.find_parties(
580: FND_API.G_FALSE,l_rule_id,

Line 580: FND_API.G_FALSE,l_rule_id,

576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
577: END IF;
578: ELSE
579: HZ_PARTY_SEARCH.find_parties(
580: FND_API.G_FALSE,l_rule_id,
581: x_party_search_rec, x_party_site_list,x_contact_list, x_contact_point_list,
582: 'party_id <> '||p_party_id || ' and ROWNUM < 1000',
583: 'N', x_search_ctx_id,x_num_matches,x_return_status,
584: x_msg_count, x_msg_data);

Line 588: WHEN FND_API.G_EXC_ERROR THEN

584: x_msg_count, x_msg_data);
585: END IF;
586:
587: EXCEPTION
588: WHEN FND_API.G_EXC_ERROR THEN
589: x_return_status := FND_API.G_RET_STS_ERROR;
590: FND_MSG_PUB.Count_And_Get(
591: p_encoded => FND_API.G_FALSE,
592: p_count => x_msg_count,

Line 589: x_return_status := FND_API.G_RET_STS_ERROR;

585: END IF;
586:
587: EXCEPTION
588: WHEN FND_API.G_EXC_ERROR THEN
589: x_return_status := FND_API.G_RET_STS_ERROR;
590: FND_MSG_PUB.Count_And_Get(
591: p_encoded => FND_API.G_FALSE,
592: p_count => x_msg_count,
593: p_data => x_msg_data);

Line 591: p_encoded => FND_API.G_FALSE,

587: EXCEPTION
588: WHEN FND_API.G_EXC_ERROR THEN
589: x_return_status := FND_API.G_RET_STS_ERROR;
590: FND_MSG_PUB.Count_And_Get(
591: p_encoded => FND_API.G_FALSE,
592: p_count => x_msg_count,
593: p_data => x_msg_data);
594: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 594: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

590: FND_MSG_PUB.Count_And_Get(
591: p_encoded => FND_API.G_FALSE,
592: p_count => x_msg_count,
593: p_data => x_msg_data);
594: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
596: FND_MSG_PUB.Count_And_Get(
597: p_encoded => FND_API.G_FALSE,
598: p_count => x_msg_count,

Line 595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

591: p_encoded => FND_API.G_FALSE,
592: p_count => x_msg_count,
593: p_data => x_msg_data);
594: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
596: FND_MSG_PUB.Count_And_Get(
597: p_encoded => FND_API.G_FALSE,
598: p_count => x_msg_count,
599: p_data => x_msg_data);

Line 597: p_encoded => FND_API.G_FALSE,

593: p_data => x_msg_data);
594: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
596: FND_MSG_PUB.Count_And_Get(
597: p_encoded => FND_API.G_FALSE,
598: p_count => x_msg_count,
599: p_data => x_msg_data);
600: WHEN OTHERS THEN
601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

597: p_encoded => FND_API.G_FALSE,
598: p_count => x_msg_count,
599: p_data => x_msg_data);
600: WHEN OTHERS THEN
601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
602: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SQL_EXCEP');
603: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
604: FND_MSG_PUB.ADD;
605:

Line 607: p_encoded => FND_API.G_FALSE,

603: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
604: FND_MSG_PUB.ADD;
605:
606: FND_MSG_PUB.Count_And_Get(
607: p_encoded => FND_API.G_FALSE,
608: p_count => x_msg_count,
609: p_data => x_msg_data);
610: END;
611:

Line 797: FND_API.G_TRUE,l_rule_id, l_cur_party_id, l_subset_defn,

793: l_subset_defn := 'EXISTS (select 1 FROM HZ_PARTIES parties '||
794: 'where parties.party_id = stage.party_id ' ||
795: 'and '||p_subset_defn||')';
796: HZ_PARTY_SEARCH.find_duplicate_parties(
797: FND_API.G_TRUE,l_rule_id, l_cur_party_id, l_subset_defn,
798: NULL, l_batch_id, p_search_merged, l_dup_set_id,l_search_ctx_id, l_num_matches,
799: l_return_status, l_msg_count, l_msg_data);
800: ELSE
801: HZ_PARTY_SEARCH.find_duplicate_parties(

Line 802: FND_API.G_TRUE,l_rule_id, l_cur_party_id, NULL,

798: NULL, l_batch_id, p_search_merged, l_dup_set_id,l_search_ctx_id, l_num_matches,
799: l_return_status, l_msg_count, l_msg_data);
800: ELSE
801: HZ_PARTY_SEARCH.find_duplicate_parties(
802: FND_API.G_TRUE,l_rule_id, l_cur_party_id, NULL,
803: NULL, l_batch_id, p_search_merged, l_dup_set_id,l_search_ctx_id, l_num_matches,
804: l_return_status, l_msg_count, l_msg_data);
805: END IF;
806:

Line 811: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

807: -- Search is not Successful
808: -- EXPECTED ERRORS :: continue to the next iteration of the loop, log errors,
809: -- until a threshold of errors.
810: -- UNEXPECTED ERRORS :: log error and exit batch.
811: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
812: THEN
813: -- Count Errors
814: error_count := error_count+1;
815: IF(error_count = error_limit)

Line 819: RAISE FND_API.G_EXC_ERROR ;

815: IF(error_count = error_limit)
816: THEN
817: log('Errors exceeded the threshold of errors');
818: log('Exiting ..');
819: RAISE FND_API.G_EXC_ERROR ;
820: END IF;
821:
822: -- Expected Errors
823: IF l_return_status = FND_API.G_RET_STS_ERROR

Line 823: IF l_return_status = FND_API.G_RET_STS_ERROR

819: RAISE FND_API.G_EXC_ERROR ;
820: END IF;
821:
822: -- Expected Errors
823: IF l_return_status = FND_API.G_RET_STS_ERROR
824: THEN
825: log('Expected Error during party_id '||l_cur_party_id);
826: log('Error is '||l_msg_data);
827: log('Continuing ..');

Line 833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

829: ELSE
830: log('Unexpected Error during party_id '||l_cur_party_id);
831: log('Error is '||l_msg_data);
832: log('Exiting ..');
833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
834: END IF;
835: -- Search is Successful
836: ELSE
837: IF l_num_matches>0 THEN

Line 891: WHEN FND_API.G_EXC_ERROR THEN

887:
888: END IF;
889:
890: EXCEPTION
891: WHEN FND_API.G_EXC_ERROR THEN
892: log('--------------------------------');
893: log('Expected Error ' || l_cur_party_id);
894: log('Error: Aborting duplicate batch');
895: log('THIS WORKER ERRORED OUT');

Line 897: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));

893: log('Expected Error ' || l_cur_party_id);
894: log('Error: Aborting duplicate batch');
895: log('THIS WORKER ERRORED OUT');
896: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
897: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
898: END LOOP;
899: FND_MESSAGE.CLEAR;
900:
901: retcode := 2;

Line 904: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

900:
901: retcode := 2;
902: errbuf := 'Expected Error ' || l_cur_party_id;
903: FND_FILE.close;
904: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
905: log('--------------------------------');
906: log('Unexpected Error ' || l_cur_party_id);
907: log('Error: Aborting duplicate batch');
908: log('THIS WORKER ERRORED OUT');

Line 910: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));

906: log('Unexpected Error ' || l_cur_party_id);
907: log('Error: Aborting duplicate batch');
908: log('THIS WORKER ERRORED OUT');
909: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
910: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
911: END LOOP;
912: FND_MESSAGE.CLEAR;
913:
914: errbuf := 'UnExpected Error ' || l_cur_party_id;

Line 923: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));

919: log('Unknown Error ' || l_cur_party_id || ' : ' || SQLERRM);
920: log('Error: Aborting duplicate batch');
921: log('THIS WORKER ERRORED OUT');
922: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
923: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
924: END LOOP;
925:
926: retcode := 2;
927: errbuf := 'UnExpected SQL Error ' || l_cur_party_id;

Line 963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

959: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_SQL_ERROR');
960: FND_MESSAGE.SET_TOKEN('PROC' ,'check_party_in_dupset');
961: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
962: FND_MSG_PUB.ADD;
963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
964: END;
965:
966: -- Remove mathes that have been indicated as non-duplicates in the
967: -- HZ_DUP_EXCLUSIONS table

Line 1010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1006: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_SQL_ERROR');
1007: FND_MESSAGE.SET_TOKEN('PROC' ,'remove_non_duplicates');
1008: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1009: FND_MSG_PUB.ADD;
1010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1011: END remove_non_duplicates;
1012:
1013: PROCEDURE insert_match_details (
1014: p_search_ctx_id IN NUMBER,

Line 1055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1051: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_SQL_ERROR');
1052: FND_MESSAGE.SET_TOKEN('PROC' ,'create_dup_set');
1053: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1054: FND_MSG_PUB.ADD;
1055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1056: END insert_match_details;
1057:
1058: PROCEDURE get_dup_match_details (
1059: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

Line 1059: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1056: END insert_match_details;
1057:
1058: PROCEDURE get_dup_match_details (
1059: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1060: p_rule_id IN NUMBER,
1061: p_dup_set_id IN NUMBER,
1062: x_return_status OUT NOCOPY VARCHAR2,
1063: x_msg_count OUT NOCOPY NUMBER,

Line 1089: x_return_status := FND_API.G_RET_STS_SUCCESS;

1085: l_mr_comp_flag VARCHAR2(1);
1086:
1087: BEGIN
1088: -- Initialize return status and message stack
1089: x_return_status := FND_API.G_RET_STS_SUCCESS;
1090: IF FND_API.to_Boolean(p_init_msg_list) THEN
1091: FND_MSG_PUB.initialize;
1092: END IF;
1093:

Line 1090: IF FND_API.to_Boolean(p_init_msg_list) THEN

1086:
1087: BEGIN
1088: -- Initialize return status and message stack
1089: x_return_status := FND_API.G_RET_STS_SUCCESS;
1090: IF FND_API.to_Boolean(p_init_msg_list) THEN
1091: FND_MSG_PUB.initialize;
1092: END IF;
1093:
1094: SELECT count(1)

Line 1115: RAISE FND_API.G_EXC_ERROR;

1111:
1112: IF l_mr_comp_flag <> 'C' OR l_mr_last_updated_date > l_dup_set_creation_date THEN
1113: FND_MESSAGE.SET_NAME('AR', 'HZ_CDL_NO_MATCH_DETAILS');
1114: FND_MSG_PUB.ADD;
1115: RAISE FND_API.G_EXC_ERROR;
1116: END IF;
1117:
1118: HZ_PARTY_SEARCH.get_party_for_search(
1119: FND_API.G_FALSE,p_rule_id, l_winner_party_id, l_party_rec,

Line 1119: FND_API.G_FALSE,p_rule_id, l_winner_party_id, l_party_rec,

1115: RAISE FND_API.G_EXC_ERROR;
1116: END IF;
1117:
1118: HZ_PARTY_SEARCH.get_party_for_search(
1119: FND_API.G_FALSE,p_rule_id, l_winner_party_id, l_party_rec,
1120: l_party_site_list, l_contact_list, l_cpt_list,
1121: l_return_status, l_msg_count, l_msg_data);
1122:
1123: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1123: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1119: FND_API.G_FALSE,p_rule_id, l_winner_party_id, l_party_rec,
1120: l_party_site_list, l_contact_list, l_cpt_list,
1121: l_return_status, l_msg_count, l_msg_data);
1122:
1123: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1124: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_ACQUIRE_ERROR');
1125: FND_MESSAGE.SET_TOKEN('PARTY_ID', TO_CHAR(l_winner_party_id));
1126: FND_MSG_PUB.ADD;
1127: RAISE FND_API.G_EXC_ERROR;

Line 1127: RAISE FND_API.G_EXC_ERROR;

1123: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1124: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_ACQUIRE_ERROR');
1125: FND_MESSAGE.SET_TOKEN('PARTY_ID', TO_CHAR(l_winner_party_id));
1126: FND_MSG_PUB.ADD;
1127: RAISE FND_API.G_EXC_ERROR;
1128: ELSE
1129:
1130: FOR DUP IN (SELECT DUP_PARTY_ID
1131: FROM HZ_DUP_SET_PARTIES

Line 1134: FND_API.G_FALSE,p_rule_id, DUP.DUP_PARTY_ID,

1130: FOR DUP IN (SELECT DUP_PARTY_ID
1131: FROM HZ_DUP_SET_PARTIES
1132: WHERE DUP_SET_ID = p_dup_set_id and dup_party_id <> l_winner_party_id) LOOP
1133: HZ_PARTY_SEARCH.get_score_details (
1134: FND_API.G_FALSE,p_rule_id, DUP.DUP_PARTY_ID,
1135: l_party_rec, l_party_site_list,l_contact_list, l_cpt_list,
1136: l_search_ctx_id, l_return_status, l_msg_count, l_msg_data);
1137: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1138: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_SEARCH_ERROR');

Line 1137: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1133: HZ_PARTY_SEARCH.get_score_details (
1134: FND_API.G_FALSE,p_rule_id, DUP.DUP_PARTY_ID,
1135: l_party_rec, l_party_site_list,l_contact_list, l_cpt_list,
1136: l_search_ctx_id, l_return_status, l_msg_count, l_msg_data);
1137: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1138: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_SEARCH_ERROR');
1139: FND_MESSAGE.SET_TOKEN('PARTY_ID', TO_CHAR(DUP.DUP_PARTY_ID));
1140: FND_MSG_PUB.ADD;
1141: RAISE FND_API.G_EXC_ERROR;

Line 1141: RAISE FND_API.G_EXC_ERROR;

1137: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1138: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_SEARCH_ERROR');
1139: FND_MESSAGE.SET_TOKEN('PARTY_ID', TO_CHAR(DUP.DUP_PARTY_ID));
1140: FND_MSG_PUB.ADD;
1141: RAISE FND_API.G_EXC_ERROR;
1142: ELSE
1143: insert_match_details (l_search_ctx_id, p_dup_set_id, DUP.DUP_PARTY_ID);
1144: END IF;
1145: END LOOP;

Line 1149: WHEN FND_API.G_EXC_ERROR THEN

1145: END LOOP;
1146: END IF;
1147:
1148: EXCEPTION
1149: WHEN FND_API.G_EXC_ERROR THEN
1150: x_return_status := FND_API.G_RET_STS_ERROR;
1151: FND_MSG_PUB.Count_And_Get(
1152: p_encoded => FND_API.G_FALSE,
1153: p_count => x_msg_count,

Line 1150: x_return_status := FND_API.G_RET_STS_ERROR;

1146: END IF;
1147:
1148: EXCEPTION
1149: WHEN FND_API.G_EXC_ERROR THEN
1150: x_return_status := FND_API.G_RET_STS_ERROR;
1151: FND_MSG_PUB.Count_And_Get(
1152: p_encoded => FND_API.G_FALSE,
1153: p_count => x_msg_count,
1154: p_data => x_msg_data);

Line 1152: p_encoded => FND_API.G_FALSE,

1148: EXCEPTION
1149: WHEN FND_API.G_EXC_ERROR THEN
1150: x_return_status := FND_API.G_RET_STS_ERROR;
1151: FND_MSG_PUB.Count_And_Get(
1152: p_encoded => FND_API.G_FALSE,
1153: p_count => x_msg_count,
1154: p_data => x_msg_data);
1155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1151: FND_MSG_PUB.Count_And_Get(
1152: p_encoded => FND_API.G_FALSE,
1153: p_count => x_msg_count,
1154: p_data => x_msg_data);
1155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1157: FND_MSG_PUB.Count_And_Get(
1158: p_encoded => FND_API.G_FALSE,
1159: p_count => x_msg_count,

Line 1156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1152: p_encoded => FND_API.G_FALSE,
1153: p_count => x_msg_count,
1154: p_data => x_msg_data);
1155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1157: FND_MSG_PUB.Count_And_Get(
1158: p_encoded => FND_API.G_FALSE,
1159: p_count => x_msg_count,
1160: p_data => x_msg_data);

Line 1158: p_encoded => FND_API.G_FALSE,

1154: p_data => x_msg_data);
1155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1157: FND_MSG_PUB.Count_And_Get(
1158: p_encoded => FND_API.G_FALSE,
1159: p_count => x_msg_count,
1160: p_data => x_msg_data);
1161: WHEN OTHERS THEN
1162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1158: p_encoded => FND_API.G_FALSE,
1159: p_count => x_msg_count,
1160: p_data => x_msg_data);
1161: WHEN OTHERS THEN
1162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1163: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SQL_EXCEP');
1164: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1165: FND_MSG_PUB.ADD;
1166:

Line 1168: p_encoded => FND_API.G_FALSE,

1164: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1165: FND_MSG_PUB.ADD;
1166:
1167: FND_MSG_PUB.Count_And_Get(
1168: p_encoded => FND_API.G_FALSE,
1169: p_count => x_msg_count,
1170: p_data => x_msg_data);
1171: END;
1172:

Line 1231: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));

1227: BEGIN
1228: FND_MSG_PUB.Reset;
1229:
1230: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1231: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1232: END LOOP;
1233: FND_MSG_PUB.Delete_Msg;
1234: END logerror;
1235:

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

1238: BEGIN
1239: FND_MSG_PUB.Reset;
1240:
1241: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1242: l_msg_data := l_msg_data || ' ' || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
1243: END LOOP;
1244: log(l_msg_data);
1245: RETURN l_msg_data;
1246: