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

Line 262: fnd_msg_pub.add;

258: close check_set_party_exist_csr;
259:
260: IF l_count = 0 or l_master_party_id is null or x_master_party_name is null THEN
261: fnd_message.set_name('AR', 'HZ_DL_USER_HOOK_ERR');
262: fnd_msg_pub.add;
263: x_return_status := fnd_api.g_ret_sts_error;
264: RAISE FND_API.G_EXC_ERROR;
265: end if;
266:

Line 318: FND_MSG_PUB.ADD;

314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
315:
316: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
317: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
318: FND_MSG_PUB.ADD;
319:
320: FND_MSG_PUB.Count_And_Get(
321: p_encoded => FND_API.G_FALSE,
322: p_count => x_msg_count,

Line 320: FND_MSG_PUB.Count_And_Get(

316: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
317: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
318: FND_MSG_PUB.ADD;
319:
320: FND_MSG_PUB.Count_And_Get(
321: p_encoded => FND_API.G_FALSE,
322: p_count => x_msg_count,
323: p_data => x_msg_data);
324:

Line 363: FND_MSG_PUB.initialize;

359:
360: BEGIN
361:
362: savepoint create_dup_pvt;
363: FND_MSG_PUB.initialize;
364:
365: --Initialize API return status to success.
366: x_return_status := FND_API.G_RET_STS_SUCCESS;
367:

Line 401: FND_MSG_PUB.Count_And_Get(

397:
398: WHEN FND_API.G_EXC_ERROR THEN
399: ROLLBACK TO create_dup_pvt;
400: x_return_status := FND_API.G_RET_STS_ERROR;
401: FND_MSG_PUB.Count_And_Get(
402: p_encoded => FND_API.G_FALSE,
403: p_count => x_msg_count,
404: p_data => x_msg_data);
405:

Line 409: FND_MSG_PUB.Count_And_Get(

405:
406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
407: ROLLBACK TO create_dup_pvt;
408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
409: FND_MSG_PUB.Count_And_Get(
410: p_encoded => FND_API.G_FALSE,
411: p_count => x_msg_count,
412: p_data => x_msg_data);
413:

Line 419: FND_MSG_PUB.ADD;

415: ROLLBACK TO create_dup_pvt;
416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
417: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
418: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
419: FND_MSG_PUB.ADD;
420: FND_MSG_PUB.Count_And_Get(
421: p_encoded => FND_API.G_FALSE,
422: p_count => x_msg_count,
423: p_data => x_msg_data);

Line 420: FND_MSG_PUB.Count_And_Get(

416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
417: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
418: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
419: FND_MSG_PUB.ADD;
420: FND_MSG_PUB.Count_And_Get(
421: p_encoded => FND_API.G_FALSE,
422: p_count => x_msg_count,
423: p_data => x_msg_data);
424:

Line 466: FND_MSG_PUB.initialize;

462:
463: BEGIN
464:
465: savepoint create_dup_set_party_pvt;
466: FND_MSG_PUB.initialize;
467:
468: --Initialize API return status to success.
469: x_return_status := FND_API.G_RET_STS_SUCCESS;
470:

Line 474: FND_MSG_PUB.ADD;

470:
471: IF(p_dup_set_id IS NULL OR p_dup_set_id = FND_API.G_MISS_NUM) THEN
472: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
473: FND_MESSAGE.SET_TOKEN('COLUMN' ,'DUP_SET_ID');
474: FND_MSG_PUB.ADD;
475: RAISE FND_API.G_EXC_ERROR;
476: END IF;
477:
478: IF(p_dup_set_party_id IS NULL OR p_dup_set_party_id = FND_API.G_MISS_NUM) THEN

Line 481: FND_MSG_PUB.ADD;

477:
478: IF(p_dup_set_party_id IS NULL OR p_dup_set_party_id = FND_API.G_MISS_NUM) THEN
479: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
480: FND_MESSAGE.SET_TOKEN('COLUMN' ,'DUP_SET_PARTY_ID');
481: FND_MSG_PUB.ADD;
482: RAISE FND_API.G_EXC_ERROR;
483: END IF;
484:
485: l_dup_set_id := p_dup_set_id;

Line 497: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

493: FETCH get_party_type into l_cand_type;
494: CLOSE get_party_type;
495:
496: IF NOT (l_winner_type = l_cand_type) THEN
497: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
498: -- parties have different type in a merge request
499: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_PARTIES');
500: FND_MSG_PUB.ADD;
501: RAISE FND_API.G_EXC_ERROR;

Line 500: FND_MSG_PUB.ADD;

496: IF NOT (l_winner_type = l_cand_type) THEN
497: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
498: -- parties have different type in a merge request
499: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_PARTIES');
500: FND_MSG_PUB.ADD;
501: RAISE FND_API.G_EXC_ERROR;
502: END IF;
503: END IF;*/
504: ----Commented for Bug 5552118

Line 533: FND_MSG_PUB.Count_And_Get(

529:
530: WHEN FND_API.G_EXC_ERROR THEN
531: ROLLBACK TO create_dup_set_party_pvt;
532: x_return_status := FND_API.G_RET_STS_ERROR;
533: FND_MSG_PUB.Count_And_Get(
534: p_encoded => FND_API.G_FALSE,
535: p_count => x_msg_count,
536: p_data => x_msg_data);
537:

Line 541: FND_MSG_PUB.Count_And_Get(

537:
538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
539: ROLLBACK TO create_dup_set_party_pvt;
540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
541: FND_MSG_PUB.Count_And_Get(
542: p_encoded => FND_API.G_FALSE,
543: p_count => x_msg_count,
544: p_data => x_msg_data);
545:

Line 551: FND_MSG_PUB.ADD;

547: ROLLBACK TO create_dup_set_party_pvt;
548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
549: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
550: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
551: FND_MSG_PUB.ADD;
552: FND_MSG_PUB.Count_And_Get(
553: p_encoded => FND_API.G_FALSE,
554: p_count => x_msg_count,
555: p_data => x_msg_data);

Line 552: FND_MSG_PUB.Count_And_Get(

548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
549: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
550: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
551: FND_MSG_PUB.ADD;
552: FND_MSG_PUB.Count_And_Get(
553: p_encoded => FND_API.G_FALSE,
554: p_count => x_msg_count,
555: p_data => x_msg_data);
556:

Line 588: FND_MSG_PUB.initialize;

584: BEGIN
585:
586: savepoint create_dup_batch_pvt;
587:
588: FND_MSG_PUB.initialize;
589:
590: --Initialize API return status to success.
591: x_return_status := FND_API.G_RET_STS_SUCCESS;
592:

Line 596: FND_MSG_PUB.ADD;

592:
593: IF(p_dup_batch_rec.match_rule_id IS NULL OR
594: p_dup_batch_rec.match_rule_id = FND_API.G_MISS_NUM) THEN
595: FND_MESSAGE.SET_NAME( 'AR', 'HZ_NO_MATCH_RULE' );
596: FND_MSG_PUB.ADD;
597: RAISE FND_API.G_EXC_ERROR;
598: END IF;
599:
600: IF(p_dup_batch_rec.request_type IS NULL OR

Line 604: FND_MSG_PUB.ADD;

600: IF(p_dup_batch_rec.request_type IS NULL OR
601: p_dup_batch_rec.request_type = FND_API.G_MISS_CHAR) THEN
602: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
603: FND_MESSAGE.SET_TOKEN('COLUMN' ,'REQUEST_TYPE');
604: FND_MSG_PUB.ADD;
605: RAISE FND_API.G_EXC_ERROR;
606: END IF;
607:
608: IF(p_dup_set_rec.status IS NULL OR

Line 612: FND_MSG_PUB.ADD;

608: IF(p_dup_set_rec.status IS NULL OR
609: p_dup_set_rec.status = FND_API.G_MISS_CHAR) THEN
610: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
611: FND_MESSAGE.SET_TOKEN('COLUMN' ,'STATUS');
612: FND_MSG_PUB.ADD;
613: RAISE FND_API.G_EXC_ERROR;
614: END IF;
615:
616: IF(p_dup_set_rec.merge_type = 'PARTY_MERGE') THEN

Line 629: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

625: OPEN get_party_type(p_dup_party_tbl(i).party_id);
626: FETCH get_party_type INTO l_temp_type;
627: CLOSE get_party_type;
628: IF NOT (l_party_type = l_temp_type) THEN
629: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
630: -- parties have different type in a merge request
631: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_PARTIES');
632: FND_MSG_PUB.ADD;
633: RAISE FND_API.G_EXC_ERROR;

Line 632: FND_MSG_PUB.ADD;

628: IF NOT (l_party_type = l_temp_type) THEN
629: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
630: -- parties have different type in a merge request
631: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_PARTIES');
632: FND_MSG_PUB.ADD;
633: RAISE FND_API.G_EXC_ERROR;
634: END IF;
635: END IF;
636: END LOOP;

Line 695: FND_MSG_PUB.Count_And_Get(

691:
692: WHEN FND_API.G_EXC_ERROR THEN
693: ROLLBACK TO create_dup_batch_pvt;
694: x_return_status := FND_API.G_RET_STS_ERROR;
695: FND_MSG_PUB.Count_And_Get(
696: p_encoded => FND_API.G_FALSE,
697: p_count => x_msg_count,
698: p_data => x_msg_data);
699:

Line 703: FND_MSG_PUB.Count_And_Get(

699:
700: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
701: ROLLBACK TO create_dup_batch_pvt;
702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
703: FND_MSG_PUB.Count_And_Get(
704: p_encoded => FND_API.G_FALSE,
705: p_count => x_msg_count,
706: p_data => x_msg_data);
707:

Line 713: FND_MSG_PUB.ADD;

709: ROLLBACK TO create_dup_batch_pvt;
710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
711: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
712: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
713: FND_MSG_PUB.ADD;
714: FND_MSG_PUB.Count_And_Get(
715: p_encoded => FND_API.G_FALSE,
716: p_count => x_msg_count,
717: p_data => x_msg_data);

Line 714: FND_MSG_PUB.Count_And_Get(

710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
711: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
712: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
713: FND_MSG_PUB.ADD;
714: FND_MSG_PUB.Count_And_Get(
715: p_encoded => FND_API.G_FALSE,
716: p_count => x_msg_count,
717: p_data => x_msg_data);
718:

Line 744: FND_MSG_PUB.initialize;

740: BEGIN
741:
742: savepoint create_dup_set_pvt;
743:
744: FND_MSG_PUB.initialize;
745:
746: --Initialize API return status to success.
747: x_return_status := FND_API.G_RET_STS_SUCCESS;
748:

Line 753: FND_MSG_PUB.ADD;

749: IF(p_dup_set_rec.dup_batch_id IS NULL OR
750: p_dup_set_rec.dup_batch_id = FND_API.G_MISS_NUM) THEN
751: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
752: FND_MESSAGE.SET_TOKEN('COLUMN' ,'DUP_BATCH_ID');
753: FND_MSG_PUB.ADD;
754: RAISE FND_API.G_EXC_ERROR;
755: END IF;
756:
757: OPEN check_dup_batch_id;

Line 761: FND_MSG_PUB.ADD;

757: OPEN check_dup_batch_id;
758: FETCH check_dup_batch_id INTO l_temp;
759: IF(check_dup_batch_id%NOTFOUND) THEN
760: FND_MESSAGE.SET_NAME( 'AR', 'HZ_INVALID_DUP_BATCH' );
761: FND_MSG_PUB.ADD;
762: RAISE FND_API.G_EXC_ERROR;
763: END IF;
764:
765: IF(p_dup_set_rec.status IS NULL OR

Line 769: FND_MSG_PUB.ADD;

765: IF(p_dup_set_rec.status IS NULL OR
766: p_dup_set_rec.status = FND_API.G_MISS_CHAR) THEN
767: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
768: FND_MESSAGE.SET_TOKEN('COLUMN' ,'STATUS');
769: FND_MSG_PUB.ADD;
770: RAISE FND_API.G_EXC_ERROR;
771: END IF;
772:
773: HZ_DUP_SETS_PKG.Insert_Row(

Line 814: FND_MSG_PUB.Count_And_Get(

810:
811: WHEN FND_API.G_EXC_ERROR THEN
812: ROLLBACK TO create_dup_set_pvt;
813: x_return_status := FND_API.G_RET_STS_ERROR;
814: FND_MSG_PUB.Count_And_Get(
815: p_encoded => FND_API.G_FALSE,
816: p_count => x_msg_count,
817: p_data => x_msg_data);
818:

Line 822: FND_MSG_PUB.Count_And_Get(

818:
819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
820: ROLLBACK TO create_dup_set_pvt;
821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
822: FND_MSG_PUB.Count_And_Get(
823: p_encoded => FND_API.G_FALSE,
824: p_count => x_msg_count,
825: p_data => x_msg_data);
826:

Line 832: FND_MSG_PUB.ADD;

828: ROLLBACK TO create_dup_set_pvt;
829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
830: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
831: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
832: FND_MSG_PUB.ADD;
833: FND_MSG_PUB.Count_And_Get(
834: p_encoded => FND_API.G_FALSE,
835: p_count => x_msg_count,
836: p_data => x_msg_data);

Line 833: FND_MSG_PUB.Count_And_Get(

829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
830: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
831: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
832: FND_MSG_PUB.ADD;
833: FND_MSG_PUB.Count_And_Get(
834: p_encoded => FND_API.G_FALSE,
835: p_count => x_msg_count,
836: p_data => x_msg_data);
837:

Line 871: FND_MSG_PUB.initialize;

867: BEGIN
868:
869: savepoint update_winner_party_pvt;
870:
871: FND_MSG_PUB.initialize;
872: --Initialize API return status to success.
873: x_return_status := FND_API.G_RET_STS_SUCCESS;
874:
875: OPEN check_winner_party_exist;

Line 878: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

874:
875: OPEN check_winner_party_exist;
876: FETCH check_winner_party_exist INTO l_temp;
877: IF check_winner_party_exist%NOTFOUND THEN
878: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
879: -- new winner party_id cannot be found in dup_set_parties
880: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_WINNER_PARTY');
881: FND_MSG_PUB.ADD;
882: RAISE FND_API.G_EXC_ERROR;

Line 881: FND_MSG_PUB.ADD;

877: IF check_winner_party_exist%NOTFOUND THEN
878: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
879: -- new winner party_id cannot be found in dup_set_parties
880: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_WINNER_PARTY');
881: FND_MSG_PUB.ADD;
882: RAISE FND_API.G_EXC_ERROR;
883: END IF;
884: END IF;
885: CLOSE check_winner_party_exist;

Line 896: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

892:
893: -- check last_update_date of hz_dup_sets, not hz_dup_set_parties
894: IF (l_set_obj_version_number IS NOT NULL) THEN
895: IF (l_set_obj_version_number <> px_set_obj_version_number) THEN
896: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
897: -- row has been changed by another user.
898: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
899: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DUP_SETS');
900: FND_MSG_PUB.ADD;

Line 900: FND_MSG_PUB.ADD;

896: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
897: -- row has been changed by another user.
898: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
899: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DUP_SETS');
900: FND_MSG_PUB.ADD;
901: RAISE FND_API.G_EXC_ERROR;
902: END IF;
903: END IF;
904: END IF;

Line 964: FND_MSG_PUB.Count_And_Get(

960:
961: WHEN FND_API.G_EXC_ERROR THEN
962: ROLLBACK TO update_winner_party_pvt;
963: x_return_status := FND_API.G_RET_STS_ERROR;
964: FND_MSG_PUB.Count_And_Get(
965: p_encoded => FND_API.G_FALSE,
966: p_count => x_msg_count,
967: p_data => x_msg_data);
968:

Line 972: FND_MSG_PUB.Count_And_Get(

968:
969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
970: ROLLBACK TO update_winner_party_pvt;
971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
972: FND_MSG_PUB.Count_And_Get(
973: p_encoded => FND_API.G_FALSE,
974: p_count => x_msg_count,
975: p_data => x_msg_data);
976:

Line 982: FND_MSG_PUB.ADD;

978: ROLLBACK TO update_winner_party_pvt;
979: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
980: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
981: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
982: FND_MSG_PUB.ADD;
983: FND_MSG_PUB.Count_And_Get(
984: p_encoded => FND_API.G_FALSE,
985: p_count => x_msg_count,
986: p_data => x_msg_data);

Line 983: FND_MSG_PUB.Count_And_Get(

979: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
980: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
981: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
982: FND_MSG_PUB.ADD;
983: FND_MSG_PUB.Count_And_Get(
984: p_encoded => FND_API.G_FALSE,
985: p_count => x_msg_count,
986: p_data => x_msg_data);
987:

Line 1025: FND_MSG_PUB.initialize;

1021: BEGIN
1022:
1023: savepoint delete_dup_party_pvt;
1024:
1025: FND_MSG_PUB.initialize;
1026: --Initialize API return status to success.
1027: x_return_status := FND_API.G_RET_STS_SUCCESS;
1028:
1029: OPEN get_dup_sets_info;

Line 1038: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1034:
1035: -- check last_update_date of hz_dup_sets, not hz_dup_set_parties
1036: IF (l_set_obj_version_number IS NOT NULL) THEN
1037: IF (l_set_obj_version_number <> px_set_obj_version_number) THEN
1038: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1039: -- row has been changed by another user.
1040: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1041: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DUP_SETS');
1042: FND_MSG_PUB.ADD;

Line 1042: FND_MSG_PUB.ADD;

1038: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1039: -- row has been changed by another user.
1040: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1041: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DUP_SETS');
1042: FND_MSG_PUB.ADD;
1043: RAISE FND_API.G_EXC_ERROR;
1044: END IF;
1045: END IF;
1046: END IF;

Line 1055: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1051: -- delete candidate only
1052: OPEN check_winner_party(p_dup_party_id);
1053: FETCH check_winner_party INTO l_check;
1054: IF check_winner_party%FOUND THEN
1055: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1056: -- cannot remove winner party without specifying a new winner party
1057: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1058: FND_MESSAGE.SET_TOKEN('COLUMN' ,'NEW_WINNER_PARTY_ID');
1059: FND_MSG_PUB.ADD;

Line 1059: FND_MSG_PUB.ADD;

1055: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1056: -- cannot remove winner party without specifying a new winner party
1057: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1058: FND_MESSAGE.SET_TOKEN('COLUMN' ,'NEW_WINNER_PARTY_ID');
1059: FND_MSG_PUB.ADD;
1060: RAISE FND_API.G_EXC_ERROR;
1061: END IF;
1062: END IF;
1063: CLOSE check_winner_party;

Line 1086: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1082: -- delete winner party and specify new winner party also
1083: OPEN check_winner_party(p_dup_party_id);
1084: FETCH check_winner_party INTO l_check;
1085: IF check_winner_party%FOUND THEN
1086: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1087: -- cannot remove winner party without specifying a new winner party
1088: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_WINNER_PARTY');
1089: FND_MSG_PUB.ADD;
1090: RAISE FND_API.G_EXC_ERROR;

Line 1089: FND_MSG_PUB.ADD;

1085: IF check_winner_party%FOUND THEN
1086: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1087: -- cannot remove winner party without specifying a new winner party
1088: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_WINNER_PARTY');
1089: FND_MSG_PUB.ADD;
1090: RAISE FND_API.G_EXC_ERROR;
1091: END IF;
1092: END IF;
1093: CLOSE check_winner_party;

Line 1098: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1094:
1095: OPEN check_dup_party(p_new_winner_party_id);
1096: FETCH check_dup_party INTO l_check;
1097: IF check_dup_party%NOTFOUND THEN
1098: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1099: -- cannot remove winner party without specifying a new winner party
1100: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DUP_PARTY');
1101: FND_MSG_PUB.ADD;
1102: RAISE FND_API.G_EXC_ERROR;

Line 1101: FND_MSG_PUB.ADD;

1097: IF check_dup_party%NOTFOUND THEN
1098: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1099: -- cannot remove winner party without specifying a new winner party
1100: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DUP_PARTY');
1101: FND_MSG_PUB.ADD;
1102: RAISE FND_API.G_EXC_ERROR;
1103: END IF;
1104: END IF;
1105: CLOSE check_dup_party;

Line 1145: FND_MSG_PUB.Count_And_Get(

1141:
1142: WHEN FND_API.G_EXC_ERROR THEN
1143: ROLLBACK TO delete_dup_party_pvt;
1144: x_return_status := FND_API.G_RET_STS_ERROR;
1145: FND_MSG_PUB.Count_And_Get(
1146: p_encoded => FND_API.G_FALSE,
1147: p_count => x_msg_count,
1148: p_data => x_msg_data);
1149:

Line 1153: FND_MSG_PUB.Count_And_Get(

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

Line 1163: FND_MSG_PUB.ADD;

1159: ROLLBACK TO delete_dup_party_pvt;
1160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1161: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1162: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1163: FND_MSG_PUB.ADD;
1164: FND_MSG_PUB.Count_And_Get(
1165: p_encoded => FND_API.G_FALSE,
1166: p_count => x_msg_count,
1167: p_data => x_msg_data);

Line 1164: FND_MSG_PUB.Count_And_Get(

1160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1161: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1162: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1163: FND_MSG_PUB.ADD;
1164: FND_MSG_PUB.Count_And_Get(
1165: p_encoded => FND_API.G_FALSE,
1166: p_count => x_msg_count,
1167: p_data => x_msg_data);
1168:

Line 1219: FND_MSG_PUB.initialize;

1215: BEGIN
1216:
1217: savepoint reset_merge_type_pvt;
1218:
1219: FND_MSG_PUB.initialize;
1220: --Initialize API return status to success.
1221: x_return_status := FND_API.G_RET_STS_SUCCESS;
1222:
1223: OPEN get_dup_sets_info;

Line 1232: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1228:
1229: -- check last_update_date of hz_dup_sets, not hz_dup_set_parties
1230: IF (l_set_obj_version_number IS NOT NULL) THEN
1231: IF (l_set_obj_version_number <> px_set_obj_version_number) THEN
1232: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1233: -- row has been changed by another user.
1234: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1235: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DUP_SETS');
1236: FND_MSG_PUB.ADD;

Line 1236: FND_MSG_PUB.ADD;

1232: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1233: -- row has been changed by another user.
1234: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1235: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DUP_SETS');
1236: FND_MSG_PUB.ADD;
1237: RAISE FND_API.G_EXC_ERROR;
1238: END IF;
1239: END IF;
1240: END IF;

Line 1247: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1243:
1244: OPEN check_winner_party;
1245: FETCH check_winner_party INTO l_check;
1246: IF check_winner_party%NOTFOUND THEN
1247: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1248: -- the remain party in HZ_DUP_SET_PARTIES which has merge_flag <> 'N'
1249: -- is not the same as the winner_party_id in HZ_DUP_SETS
1250: FND_MESSAGE.SET_NAME('AR', 'HZ_DL_SEL_MASTER');
1251: FND_MSG_PUB.ADD;

Line 1251: FND_MSG_PUB.ADD;

1247: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1248: -- the remain party in HZ_DUP_SET_PARTIES which has merge_flag <> 'N'
1249: -- is not the same as the winner_party_id in HZ_DUP_SETS
1250: FND_MESSAGE.SET_NAME('AR', 'HZ_DL_SEL_MASTER');
1251: FND_MSG_PUB.ADD;
1252: RAISE FND_API.G_EXC_ERROR;
1253: END IF;
1254: END IF;
1255: CLOSE check_winner_party;

Line 1282: FND_MSG_PUB.Count_And_Get(

1278:
1279: WHEN FND_API.G_EXC_ERROR THEN
1280: ROLLBACK TO reset_merge_type_pvt;
1281: x_return_status := FND_API.G_RET_STS_ERROR;
1282: FND_MSG_PUB.Count_And_Get(
1283: p_encoded => FND_API.G_FALSE,
1284: p_count => x_msg_count,
1285: p_data => x_msg_data);
1286:

Line 1290: FND_MSG_PUB.Count_And_Get(

1286:
1287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1288: ROLLBACK TO reset_merge_type_pvt;
1289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1290: FND_MSG_PUB.Count_And_Get(
1291: p_encoded => FND_API.G_FALSE,
1292: p_count => x_msg_count,
1293: p_data => x_msg_data);
1294:

Line 1300: FND_MSG_PUB.ADD;

1296: ROLLBACK TO reset_merge_type_pvt;
1297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1298: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1299: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1300: FND_MSG_PUB.ADD;
1301: FND_MSG_PUB.Count_And_Get(
1302: p_encoded => FND_API.G_FALSE,
1303: p_count => x_msg_count,
1304: p_data => x_msg_data);

Line 1301: FND_MSG_PUB.Count_And_Get(

1297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1298: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1299: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1300: FND_MSG_PUB.ADD;
1301: FND_MSG_PUB.Count_And_Get(
1302: p_encoded => FND_API.G_FALSE,
1303: p_count => x_msg_count,
1304: p_data => x_msg_data);
1305:

Line 1330: FND_MSG_PUB.initialize;

1326:
1327: savepoint reject_merge_pvt;
1328:
1329: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1330: FND_MSG_PUB.initialize;
1331: END IF;
1332:
1333: --Initialize API return status to success.
1334: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1345: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1341:
1342: -- check last_update_date of hz_dup_sets, not hz_dup_set_parties
1343: IF (l_set_obj_version_number IS NOT NULL) THEN
1344: IF (l_set_obj_version_number <> px_set_obj_version_number) THEN
1345: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1346: -- row has been changed by another user.
1347: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1348: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DUP_SETS');
1349: FND_MSG_PUB.ADD;

Line 1349: FND_MSG_PUB.ADD;

1345: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1346: -- row has been changed by another user.
1347: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1348: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DUP_SETS');
1349: FND_MSG_PUB.ADD;
1350: RAISE FND_API.G_EXC_ERROR;
1351: END IF;
1352: END IF;
1353: END IF;

Line 1385: FND_MSG_PUB.Count_And_Get(

1381:
1382: WHEN FND_API.G_EXC_ERROR THEN
1383: ROLLBACK TO reject_merge_pvt;
1384: x_return_status := FND_API.G_RET_STS_ERROR;
1385: FND_MSG_PUB.Count_And_Get(
1386: p_encoded => FND_API.G_FALSE,
1387: p_count => x_msg_count,
1388: p_data => x_msg_data);
1389:

Line 1393: FND_MSG_PUB.Count_And_Get(

1389:
1390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1391: ROLLBACK TO reject_merge_pvt;
1392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1393: FND_MSG_PUB.Count_And_Get(
1394: p_encoded => FND_API.G_FALSE,
1395: p_count => x_msg_count,
1396: p_data => x_msg_data);
1397:

Line 1403: FND_MSG_PUB.ADD;

1399: ROLLBACK TO reject_merge_pvt;
1400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1401: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1402: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1403: FND_MSG_PUB.ADD;
1404: FND_MSG_PUB.Count_And_Get(
1405: p_encoded => FND_API.G_FALSE,
1406: p_count => x_msg_count,
1407: p_data => x_msg_data);

Line 1404: FND_MSG_PUB.Count_And_Get(

1400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1401: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1402: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1403: FND_MSG_PUB.ADD;
1404: FND_MSG_PUB.Count_And_Get(
1405: p_encoded => FND_API.G_FALSE,
1406: p_count => x_msg_count,
1407: p_data => x_msg_data);
1408:

Line 1499: fnd_msg_pub.initialize;

1495:
1496: BEGIN
1497:
1498: x_return_status := FND_API.G_RET_STS_SUCCESS;
1499: fnd_msg_pub.initialize;
1500:
1501: SAVEPOINT submit_dup;
1502:
1503: SELECT status , request_id

Line 1519: FND_MSG_PUB.ADD;

1515: message => l_message ) ;
1516:
1517: IF l_conc_dev_phase <> 'COMPLETE' THEN
1518: FND_MESSAGE.set_name('AR', 'HZ_CANNOT_SUBMIT_PROCESSING');
1519: FND_MSG_PUB.ADD;
1520: RAISE FND_API.G_EXC_ERROR;
1521: ELSE
1522: IF l_conc_status <>'NORMAL' THEN
1523: l_request_id := fnd_request.submit_request('AR','ARHDUPB','Create Merge Batch',to_char(sysdate,'DD-MON-YY HH24:MI:SS'),

Line 1528: FND_MSG_PUB.ADD;

1524: FALSE,p_dup_set_id );
1525:
1526: IF l_request_id = 0 THEN
1527: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_CONC_ERROR');
1528: FND_MSG_PUB.ADD;
1529: RAISE FND_API.G_EXC_ERROR;
1530: END IF;
1531:
1532: IF l_request_id is not null Then

Line 1544: FND_MSG_PUB.ADD;

1540: END IF;
1541:
1542: ELSE --if completed normally
1543: FND_MESSAGE.set_name('AR', 'HZ_CANNOT_SUBMIT_REQUEST');
1544: FND_MSG_PUB.ADD;
1545: RAISE FND_API.G_EXC_ERROR;
1546: END IF; --l_conc_status
1547: END IF; --l_conc_dev_phase
1548: ELSE ---last_request_id is null

Line 1554: FND_MSG_PUB.ADD;

1550: ,FALSE,p_dup_set_id );
1551:
1552: IF l_request_id = 0 THEN
1553: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_CONC_ERROR');
1554: FND_MSG_PUB.ADD;
1555: RAISE FND_API.G_EXC_ERROR;
1556: END IF;
1557:
1558: IF l_request_id is not null Then

Line 1574: FND_MSG_PUB.Count_And_Get(

1570:
1571: x_request_id := l_request_id;
1572:
1573: -- standard call to get message count and if count is 1, get message info.
1574: FND_MSG_PUB.Count_And_Get(
1575: p_encoded => FND_API.G_FALSE,
1576: p_count => x_msg_count,
1577: p_data => x_msg_data);
1578:

Line 1583: FND_MSG_PUB.Count_And_Get(

1579: EXCEPTION
1580: WHEN FND_API.G_EXC_ERROR THEN
1581: ROLLBACK to submit_dup;
1582: x_return_status := FND_API.G_RET_STS_ERROR;
1583: FND_MSG_PUB.Count_And_Get(
1584: p_encoded => FND_API.G_FALSE,
1585: p_count => x_msg_count,
1586: p_data => x_msg_data);
1587:

Line 1591: FND_MSG_PUB.Count_And_Get(

1587:
1588: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1589: ROLLBACK to submit_dup;
1590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1591: FND_MSG_PUB.Count_And_Get(
1592: p_encoded => FND_API.G_FALSE,
1593: p_count => x_msg_count,
1594: p_data => x_msg_data);
1595:

Line 1602: FND_MSG_PUB.ADD;

1598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1599:
1600: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1601: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1602: FND_MSG_PUB.ADD;
1603:
1604: FND_MSG_PUB.Count_And_Get(
1605: p_encoded => FND_API.G_FALSE,
1606: p_count => x_msg_count,

Line 1604: FND_MSG_PUB.Count_And_Get(

1600: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1601: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1602: FND_MSG_PUB.ADD;
1603:
1604: FND_MSG_PUB.Count_And_Get(
1605: p_encoded => FND_API.G_FALSE,
1606: p_count => x_msg_count,
1607: p_data => x_msg_data);
1608:

Line 1648: FND_MSG_PUB.initialize;

1644: COMMIT;
1645:
1646: savepoint create_merge_pvt;
1647:
1648: FND_MSG_PUB.initialize;
1649:
1650: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Create Merge Batch concurrent program');
1651: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1652: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Parameters - ');

Line 1840: FND_MSG_PUB.Reset;

1836: FUNCTION logerror(SQLERRM VARCHAR2 DEFAULT NULL)
1837: RETURN VARCHAR2 IS
1838: l_msg_data VARCHAR2(2000);
1839: BEGIN
1840: FND_MSG_PUB.Reset;
1841:
1842: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1843: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
1844: END LOOP;

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

1838: l_msg_data VARCHAR2(2000);
1839: BEGIN
1840: FND_MSG_PUB.Reset;
1841:
1842: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1843: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
1844: END LOOP;
1845: IF (SQLERRM IS NOT NULL) THEN
1846: l_msg_data := l_msg_data || SQLERRM;

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

1839: BEGIN
1840: FND_MSG_PUB.Reset;
1841:
1842: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1843: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
1844: END LOOP;
1845: IF (SQLERRM IS NOT NULL) THEN
1846: l_msg_data := l_msg_data || SQLERRM;
1847: END IF;

Line 2005: FND_MSG_PUB.initialize;

2001: l_dl_dss_prof VARCHAR2(1);
2002:
2003: begin
2004: x_return_status := FND_API.G_RET_STS_SUCCESS;
2005: FND_MSG_PUB.initialize;
2006:
2007: x_dss_update_flag := 'Y';
2008: l_dl_dss_prof := NVL(fnd_profile.value('HZ_DL_DISPLAY_LOCK'), 'N');
2009: open get_merge_parties_csr;

Line 2041: FND_MSG_PUB.ADD;

2037: else -- show error at mapping
2038: FND_MESSAGE.SET_NAME('AR', 'HZ_DL_DSS_NO_PRIVILEGE');
2039: end if;
2040:
2041: FND_MSG_PUB.ADD;
2042: x_dss_update_flag := 'N';
2043: close get_merge_parties_csr;
2044: RAISE FND_API.G_EXC_ERROR;
2045: end if;

Line 2051: FND_MSG_PUB.Count_And_Get(

2047: end loop;
2048: close get_merge_parties_csr;
2049:
2050: -- standard call to get message count and if count is 1, get message info.
2051: FND_MSG_PUB.Count_And_Get(
2052: p_encoded => FND_API.G_FALSE,
2053: p_count => x_msg_count,
2054: p_data => x_msg_data);
2055:

Line 2059: FND_MSG_PUB.Count_And_Get(

2055:
2056: EXCEPTION
2057: WHEN FND_API.G_EXC_ERROR THEN
2058: x_return_status := FND_API.G_RET_STS_ERROR;
2059: FND_MSG_PUB.Count_And_Get(
2060: p_encoded => FND_API.G_FALSE,
2061: p_count => x_msg_count,
2062: p_data => x_msg_data);
2063: return; -- only find one is ok

Line 2068: FND_MSG_PUB.ADD;

2064: WHEN OTHERS THEN
2065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2066: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2067: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2068: FND_MSG_PUB.ADD;
2069: FND_MSG_PUB.Count_And_Get(
2070: p_encoded => FND_API.G_FALSE,
2071: p_count => x_msg_count,
2072: p_data => x_msg_data);

Line 2069: FND_MSG_PUB.Count_And_Get(

2065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2066: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2067: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2068: FND_MSG_PUB.ADD;
2069: FND_MSG_PUB.Count_And_Get(
2070: p_encoded => FND_API.G_FALSE,
2071: p_count => x_msg_count,
2072: p_data => x_msg_data);
2073: end party_merge_dss_check;

Line 2115: FND_MSG_PUB.initialize;

2111: and dup_set_id = p_dup_set_id;
2112: l_count number;
2113: begin
2114:
2115: FND_MSG_PUB.initialize;
2116: --Initialize API return status to success.
2117: x_return_status := FND_API.G_RET_STS_SUCCESS;
2118:
2119: open validate_reprocess_req_csr;

Line 2126: FND_MSG_PUB.ADD;

2122:
2123: if l_count > 0
2124: then
2125: FND_MESSAGE.SET_NAME( 'AR', 'HZ_MRQ_REPROCESS_ERR' );
2126: FND_MSG_PUB.ADD;
2127: RAISE FND_API.G_EXC_ERROR;
2128: end if;
2129:
2130: begin

Line 2156: FND_MSG_PUB.Count_And_Get(

2152: EXCEPTION
2153:
2154: WHEN FND_API.G_EXC_ERROR THEN
2155: x_return_status := FND_API.G_RET_STS_ERROR;
2156: FND_MSG_PUB.Count_And_Get(
2157: p_encoded => FND_API.G_FALSE,
2158: p_count => x_msg_count,
2159: p_data => x_msg_data);
2160:

Line 2163: FND_MSG_PUB.Count_And_Get(

2159: p_data => x_msg_data);
2160:
2161: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2163: FND_MSG_PUB.Count_And_Get(
2164: p_encoded => FND_API.G_FALSE,
2165: p_count => x_msg_count,
2166: p_data => x_msg_data);
2167:

Line 2172: FND_MSG_PUB.ADD;

2168: WHEN OTHERS THEN
2169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2170: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2171: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2172: FND_MSG_PUB.ADD;
2173: FND_MSG_PUB.Count_And_Get(
2174: p_encoded => FND_API.G_FALSE,
2175: p_count => x_msg_count,
2176: p_data => x_msg_data);

Line 2173: FND_MSG_PUB.Count_And_Get(

2169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2170: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2171: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2172: FND_MSG_PUB.ADD;
2173: FND_MSG_PUB.Count_And_Get(
2174: p_encoded => FND_API.G_FALSE,
2175: p_count => x_msg_count,
2176: p_data => x_msg_data);
2177: