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_API

Line 195: x_return_status := FND_API.G_RET_STS_SUCCESS;

191: l_active_party_name varchar2(360);
192: l_count number;
193:
194: begin
195: x_return_status := FND_API.G_RET_STS_SUCCESS;
196: open get_active_party_count_csr;
197: fetch get_active_party_count_csr into l_active_party_cnt;
198: close get_active_party_count_csr;
199: if l_active_party_cnt = 0

Line 263: x_return_status := fnd_api.g_ret_sts_error;

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

Line 264: RAISE FND_API.G_EXC_ERROR;

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:
267: end if;
268:

Line 314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

310:
311:
312: EXCEPTION
313: WHEN OTHERS THEN
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;

Line 321: p_encoded => FND_API.G_FALSE,

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:
325: END default_master;

Line 366: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
368: l_dup_batch_rec.dup_batch_name := dup_batch_name;
369: l_dup_batch_rec.match_rule_id := match_rule_id;
370: l_dup_batch_rec.application_id := application_id;

Line 398: WHEN FND_API.G_EXC_ERROR THEN

394: ,x_msg_data => x_msg_data );
395:
396: EXCEPTION
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,

Line 400: x_return_status := FND_API.G_RET_STS_ERROR;

396: EXCEPTION
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);

Line 402: p_encoded => FND_API.G_FALSE,

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:
406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

402: p_encoded => FND_API.G_FALSE,
403: p_count => x_msg_count,
404: p_data => x_msg_data);
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,

Line 408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

404: p_data => x_msg_data);
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);

Line 410: p_encoded => FND_API.G_FALSE,

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

Line 416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

412: p_data => x_msg_data);
413:
414: WHEN OTHERS THEN
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(

Line 421: p_encoded => FND_API.G_FALSE,

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:
425: END create_dup;

Line 469: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
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');

Line 471: IF(p_dup_set_id IS NULL OR p_dup_set_id = FND_API.G_MISS_NUM) THEN

467:
468: --Initialize API return status to success.
469: x_return_status := FND_API.G_RET_STS_SUCCESS;
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;

Line 475: RAISE FND_API.G_EXC_ERROR;

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
479: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

Line 478: IF(p_dup_set_party_id IS NULL OR p_dup_set_party_id = FND_API.G_MISS_NUM) THEN

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

Line 482: RAISE FND_API.G_EXC_ERROR;

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;
486: l_dup_set_party_id := p_dup_set_party_id;

Line 501: RAISE FND_API.G_EXC_ERROR;

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

Line 530: WHEN FND_API.G_EXC_ERROR THEN

526: );
527:
528: EXCEPTION
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,

Line 532: x_return_status := FND_API.G_RET_STS_ERROR;

528: EXCEPTION
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);

Line 534: p_encoded => FND_API.G_FALSE,

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:
538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

534: p_encoded => FND_API.G_FALSE,
535: p_count => x_msg_count,
536: p_data => x_msg_data);
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,

Line 540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

536: p_data => x_msg_data);
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);

Line 542: p_encoded => FND_API.G_FALSE,

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

Line 548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

544: p_data => x_msg_data);
545:
546: WHEN OTHERS THEN
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(

Line 553: p_encoded => FND_API.G_FALSE,

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:
557: END create_dup_set_party;

Line 591: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
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' );

Line 594: p_dup_batch_rec.match_rule_id = FND_API.G_MISS_NUM) THEN

590: --Initialize API return status to success.
591: x_return_status := FND_API.G_RET_STS_SUCCESS;
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;

Line 597: RAISE FND_API.G_EXC_ERROR;

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
601: p_dup_batch_rec.request_type = FND_API.G_MISS_CHAR) THEN

Line 601: p_dup_batch_rec.request_type = FND_API.G_MISS_CHAR) THEN

597: RAISE FND_API.G_EXC_ERROR;
598: END IF;
599:
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;

Line 605: RAISE FND_API.G_EXC_ERROR;

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
609: p_dup_set_rec.status = FND_API.G_MISS_CHAR) THEN

Line 609: p_dup_set_rec.status = FND_API.G_MISS_CHAR) THEN

605: RAISE FND_API.G_EXC_ERROR;
606: END IF;
607:
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;

Line 613: RAISE FND_API.G_EXC_ERROR;

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

Line 633: RAISE FND_API.G_EXC_ERROR;

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

Line 692: WHEN FND_API.G_EXC_ERROR THEN

688: END LOOP;
689:
690: EXCEPTION
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,

Line 694: x_return_status := FND_API.G_RET_STS_ERROR;

690: EXCEPTION
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);

Line 696: p_encoded => FND_API.G_FALSE,

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:
700: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 700: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

696: p_encoded => FND_API.G_FALSE,
697: p_count => x_msg_count,
698: p_data => x_msg_data);
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,

Line 702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

698: p_data => x_msg_data);
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);

Line 704: p_encoded => FND_API.G_FALSE,

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

Line 710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

706: p_data => x_msg_data);
707:
708: WHEN OTHERS THEN
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(

Line 715: p_encoded => FND_API.G_FALSE,

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:
719: END create_dup_batch;

Line 747: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
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' );

Line 750: p_dup_set_rec.dup_batch_id = FND_API.G_MISS_NUM) THEN

746: --Initialize API return status to success.
747: x_return_status := FND_API.G_RET_STS_SUCCESS;
748:
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;

Line 754: RAISE FND_API.G_EXC_ERROR;

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;
758: FETCH check_dup_batch_id INTO l_temp;

Line 762: RAISE FND_API.G_EXC_ERROR;

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
766: p_dup_set_rec.status = FND_API.G_MISS_CHAR) THEN

Line 766: p_dup_set_rec.status = FND_API.G_MISS_CHAR) THEN

762: RAISE FND_API.G_EXC_ERROR;
763: END IF;
764:
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;

Line 770: RAISE FND_API.G_EXC_ERROR;

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(
774: px_dup_set_id => l_dup_set_id

Line 811: WHEN FND_API.G_EXC_ERROR THEN

807: END LOOP;
808:
809: EXCEPTION
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,

Line 813: x_return_status := FND_API.G_RET_STS_ERROR;

809: EXCEPTION
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);

Line 815: p_encoded => FND_API.G_FALSE,

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:
819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

815: p_encoded => FND_API.G_FALSE,
816: p_count => x_msg_count,
817: p_data => x_msg_data);
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,

Line 821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

817: p_data => x_msg_data);
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);

Line 823: p_encoded => FND_API.G_FALSE,

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

Line 829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

825: p_data => x_msg_data);
826:
827: WHEN OTHERS THEN
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(

Line 834: p_encoded => FND_API.G_FALSE,

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:
838: END create_dup_set;

Line 873: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
876: FETCH check_winner_party_exist INTO l_temp;
877: IF check_winner_party_exist%NOTFOUND THEN

Line 882: RAISE FND_API.G_EXC_ERROR;

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

Line 901: RAISE FND_API.G_EXC_ERROR;

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

Line 961: WHEN FND_API.G_EXC_ERROR THEN

957: WHERE dup_set_id = p_dup_set_id;
958:
959: EXCEPTION
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,

Line 963: x_return_status := FND_API.G_RET_STS_ERROR;

959: EXCEPTION
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);

Line 965: p_encoded => FND_API.G_FALSE,

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:
969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

965: p_encoded => FND_API.G_FALSE,
966: p_count => x_msg_count,
967: p_data => x_msg_data);
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,

Line 971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

967: p_data => x_msg_data);
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);

Line 973: p_encoded => FND_API.G_FALSE,

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

Line 979: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

975: p_data => x_msg_data);
976:
977: WHEN OTHERS THEN
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(

Line 984: p_encoded => FND_API.G_FALSE,

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:
988: END update_winner_party;

Line 1027: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
1030: FETCH get_dup_sets_info into
1031: l_winner_party_id

Line 1043: RAISE FND_API.G_EXC_ERROR;

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

Line 1060: RAISE FND_API.G_EXC_ERROR;

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

Line 1090: RAISE FND_API.G_EXC_ERROR;

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

Line 1102: RAISE FND_API.G_EXC_ERROR;

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

Line 1142: WHEN FND_API.G_EXC_ERROR THEN

1138: END;
1139:
1140: EXCEPTION
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,

Line 1144: x_return_status := FND_API.G_RET_STS_ERROR;

1140: EXCEPTION
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);

Line 1146: p_encoded => FND_API.G_FALSE,

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:
1150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1146: p_encoded => FND_API.G_FALSE,
1147: p_count => x_msg_count,
1148: p_data => x_msg_data);
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,

Line 1152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1148: p_data => x_msg_data);
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);

Line 1154: p_encoded => FND_API.G_FALSE,

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

Line 1160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1156: p_data => x_msg_data);
1157:
1158: WHEN OTHERS THEN
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(

Line 1165: p_encoded => FND_API.G_FALSE,

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:
1169: END delete_dup_party;

Line 1221: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
1224: FETCH get_dup_sets_info into
1225: l_winner_party_id

Line 1237: RAISE FND_API.G_EXC_ERROR;

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

Line 1252: RAISE FND_API.G_EXC_ERROR;

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

Line 1279: WHEN FND_API.G_EXC_ERROR THEN

1275: END;
1276:
1277: EXCEPTION
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,

Line 1281: x_return_status := FND_API.G_RET_STS_ERROR;

1277: EXCEPTION
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);

Line 1283: p_encoded => FND_API.G_FALSE,

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:
1287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1283: p_encoded => FND_API.G_FALSE,
1284: p_count => x_msg_count,
1285: p_data => x_msg_data);
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,

Line 1289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1285: p_data => x_msg_data);
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);

Line 1291: p_encoded => FND_API.G_FALSE,

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

Line 1297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1293: p_data => x_msg_data);
1294:
1295: WHEN OTHERS THEN
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(

Line 1302: p_encoded => FND_API.G_FALSE,

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:
1306: END reset_merge_type;

Line 1329: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1325: BEGIN
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.

Line 1334: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
1335:
1336: OPEN get_dup_sets_info;
1337: FETCH get_dup_sets_info into
1338: l_winner_party_id

Line 1350: RAISE FND_API.G_EXC_ERROR;

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

Line 1382: WHEN FND_API.G_EXC_ERROR THEN

1378: where dup_set_id = p_dup_set_id;
1379:
1380: EXCEPTION
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,

Line 1384: x_return_status := FND_API.G_RET_STS_ERROR;

1380: EXCEPTION
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);

Line 1386: p_encoded => FND_API.G_FALSE,

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:
1390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1386: p_encoded => FND_API.G_FALSE,
1387: p_count => x_msg_count,
1388: p_data => x_msg_data);
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,

Line 1392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1388: p_data => x_msg_data);
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);

Line 1394: p_encoded => FND_API.G_FALSE,

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

Line 1400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1396: p_data => x_msg_data);
1397:
1398: WHEN OTHERS THEN
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(

Line 1405: p_encoded => FND_API.G_FALSE,

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:
1409: END reject_merge;

Line 1498: x_return_status := FND_API.G_RET_STS_SUCCESS;

1494: retcode number;
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:

Line 1520: RAISE FND_API.G_EXC_ERROR;

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'),
1524: FALSE,p_dup_set_id );

Line 1529: RAISE FND_API.G_EXC_ERROR;

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
1533: UPDATE HZ_DUP_SETS

Line 1545: RAISE FND_API.G_EXC_ERROR;

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
1549: l_request_id := fnd_request.submit_request('AR','ARHDUPB','Create Merge Batch',to_char(sysdate,'DD-MON-YY HH24:MI:SS')

Line 1555: RAISE FND_API.G_EXC_ERROR;

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
1559: UPDATE HZ_DUP_SETS

Line 1575: p_encoded => FND_API.G_FALSE,

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:
1579: EXCEPTION

Line 1580: WHEN FND_API.G_EXC_ERROR THEN

1576: p_count => x_msg_count,
1577: p_data => x_msg_data);
1578:
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,

Line 1582: x_return_status := FND_API.G_RET_STS_ERROR;

1578:
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);

Line 1584: p_encoded => FND_API.G_FALSE,

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:
1588: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1588: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1584: p_encoded => FND_API.G_FALSE,
1585: p_count => x_msg_count,
1586: p_data => x_msg_data);
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,

Line 1590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1586: p_data => x_msg_data);
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);

Line 1592: p_encoded => FND_API.G_FALSE,

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

Line 1598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1594: p_data => x_msg_data);
1595:
1596: WHEN OTHERS THEN
1597: ROLLBACK to submit_dup;
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;

Line 1605: p_encoded => FND_API.G_FALSE,

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:
1609: END submit_dup;

Line 1660: p_init_msg_list => FND_API.G_FALSE,

1656: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Start: validate_overlapping_merge_req');
1657: HZ_MERGE_DUP_PVT.validate_overlapping_merge_req(
1658: p_dup_set_id => p_dup_set_id,
1659: p_merge_batch_id => null,
1660: p_init_msg_list => FND_API.G_FALSE,
1661: p_reject_req_flag => 'Y',
1662: x_return_status => l_return_status,
1663: x_msg_count => l_msg_count,
1664: x_msg_data => l_msg_data);

Line 1671: RAISE FND_API.G_EXC_ERROR;

1667: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1668:
1669: /* error messages have been pushed into message stack in above procedure */
1670: IF l_return_status = 'E' THEN
1671: RAISE FND_API.G_EXC_ERROR;
1672: ELSIF l_return_status = 'U' THEN
1673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1674: END IF;
1675:

Line 1673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1669: /* error messages have been pushed into message stack in above procedure */
1670: IF l_return_status = 'E' THEN
1671: RAISE FND_API.G_EXC_ERROR;
1672: ELSIF l_return_status = 'U' THEN
1673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1674: END IF;
1675:
1676: l_dup_set_id := p_dup_set_id;
1677:

Line 1735: RAISE FND_API.G_EXC_ERROR;

1731: IF (l_return_status = 'E') THEN
1732: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1733: FND_FILE.PUT_LINE (FND_FILE.LOG, 'HZ_DUP_PVT.create_merge expected error. ');
1734: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1735: RAISE FND_API.G_EXC_ERROR;
1736: ELSIF (l_return_status = 'U') THEN
1737: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1738: FND_FILE.PUT_LINE (FND_FILE.LOG, 'HZ_DUP_PVT.create_merge unexpected error. ');
1739: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');

Line 1740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1736: ELSIF (l_return_status = 'U') THEN
1737: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1738: FND_FILE.PUT_LINE (FND_FILE.LOG, 'HZ_DUP_PVT.create_merge unexpected error. ');
1739: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1741: ELSIF (l_return_status = 'S') THEN
1742: UPDATE HZ_DUP_SETS
1743: set status = 'REQUESTED'
1744: , last_update_date = hz_utility_v2pub.last_update_date

Line 1757: RAISE FND_API.G_EXC_ERROR;

1753: else
1754: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1755: FND_FILE.PUT_LINE (FND_FILE.LOG, 'merge batch/parties exists. ');
1756: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1757: RAISE FND_API.G_EXC_ERROR;
1758: end if; -- check_merge_batch
1759: close check_merge_batch;
1760:
1761: FND_FILE.PUT_LINE (FND_FILE.LOG, 'validate_overlapping_merge_req second try');

Line 1765: p_init_msg_list => FND_API.G_FALSE,

1761: FND_FILE.PUT_LINE (FND_FILE.LOG, 'validate_overlapping_merge_req second try');
1762: HZ_MERGE_DUP_PVT.validate_overlapping_merge_req(
1763: p_dup_set_id => p_dup_set_id,
1764: p_merge_batch_id => null,
1765: p_init_msg_list => FND_API.G_FALSE,
1766: p_reject_req_flag => 'Y',
1767: x_return_status => l_return_status,
1768: x_msg_count => l_msg_count,
1769: x_msg_data => l_msg_data);

Line 1776: RAISE FND_API.G_EXC_ERROR;

1772: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1773:
1774: /* error messages have been pushed into message stack in above procedure */
1775: IF l_return_status = 'E' THEN
1776: RAISE FND_API.G_EXC_ERROR;
1777: ELSIF l_return_status = 'U' THEN
1778: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1779: END IF;
1780:

Line 1778: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1774: /* error messages have been pushed into message stack in above procedure */
1775: IF l_return_status = 'E' THEN
1776: RAISE FND_API.G_EXC_ERROR;
1777: ELSIF l_return_status = 'U' THEN
1778: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1779: END IF;
1780:
1781: EXCEPTION
1782:

Line 1783: WHEN FND_API.G_EXC_ERROR THEN

1779: END IF;
1780:
1781: EXCEPTION
1782:
1783: WHEN FND_API.G_EXC_ERROR THEN
1784: ROLLBACK TO create_merge_pvt;
1785: UPDATE HZ_DUP_SETS
1786: SET STATUS = 'ERROR'
1787: WHERE DUP_SET_ID = p_dup_set_id;

Line 1794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1790: log('HZ_DUP_PVT.create_merge - Expected Error Encountered');
1791: log(' ');
1792: Errbuf := logerror(SQLERRM);
1793:
1794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1795: ROLLBACK TO create_merge_pvt;
1796: UPDATE HZ_DUP_SETS
1797: SET STATUS = 'ERROR'
1798: WHERE DUP_SET_ID = p_dup_set_id;

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 1997: dss_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1993: where (party.party_id = mp.from_party_id or party.party_id = mp.to_party_id)
1994: and mp.batch_id = p_merge_batch_id;
1995:
1996: l_party_id number;
1997: dss_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1998: dss_msg_count NUMBER := 0;
1999: dss_msg_data VARCHAR2(2000):= null;
2000: l_test_security VARCHAR2(1):= 'F';
2001: l_dl_dss_prof VARCHAR2(1);

Line 2004: x_return_status := FND_API.G_RET_STS_SUCCESS;

2000: l_test_security VARCHAR2(1):= 'F';
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');

Line 2026: if dss_return_status <> fnd_api.g_ret_sts_success THEN

2022: x_return_status => dss_return_status,
2023: x_msg_count => dss_msg_count,
2024: x_msg_data => dss_msg_data);
2025:
2026: if dss_return_status <> fnd_api.g_ret_sts_success THEN
2027: x_dss_update_flag := 'N';
2028: RAISE FND_API.G_EXC_ERROR;
2029: end if;
2030:

Line 2028: RAISE FND_API.G_EXC_ERROR;

2024: x_msg_data => dss_msg_data);
2025:
2026: if dss_return_status <> fnd_api.g_ret_sts_success THEN
2027: x_dss_update_flag := 'N';
2028: RAISE FND_API.G_EXC_ERROR;
2029: end if;
2030:
2031: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then
2032:

Line 2031: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then

2027: x_dss_update_flag := 'N';
2028: RAISE FND_API.G_EXC_ERROR;
2029: end if;
2030:
2031: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then
2032:
2033: if l_dl_dss_prof = 'S'
2034: then -- show error at submission
2035: FND_MESSAGE.SET_NAME('AR', 'HZ_DL_MERGE_PROTECTION');

Line 2044: RAISE FND_API.G_EXC_ERROR;

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;
2046: END IF;
2047: end loop;
2048: close get_merge_parties_csr;

Line 2052: p_encoded => FND_API.G_FALSE,

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:
2056: EXCEPTION

Line 2057: WHEN FND_API.G_EXC_ERROR THEN

2053: p_count => x_msg_count,
2054: p_data => x_msg_data);
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,

Line 2058: x_return_status := FND_API.G_RET_STS_ERROR;

2054: p_data => x_msg_data);
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);

Line 2060: p_encoded => FND_API.G_FALSE,

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

Line 2065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2061: p_count => x_msg_count,
2062: p_data => x_msg_data);
2063: return; -- only find one is ok
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(

Line 2070: p_encoded => FND_API.G_FALSE,

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

Line 2117: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
2120: fetch validate_reprocess_req_csr into l_count;
2121: close validate_reprocess_req_csr;

Line 2127: RAISE FND_API.G_EXC_ERROR;

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
2131: -- clean up merge batch tables

Line 2154: WHEN FND_API.G_EXC_ERROR THEN

2150: ,x_msg_data => x_msg_data);
2151:
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,

Line 2155: x_return_status := FND_API.G_RET_STS_ERROR;

2151:
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);

Line 2157: p_encoded => FND_API.G_FALSE,

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:
2161: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2161: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2157: p_encoded => FND_API.G_FALSE,
2158: p_count => x_msg_count,
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,

Line 2162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2158: p_count => x_msg_count,
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);

Line 2164: p_encoded => FND_API.G_FALSE,

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

Line 2169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2165: p_count => x_msg_count,
2166: p_data => x_msg_data);
2167:
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(

Line 2174: p_encoded => FND_API.G_FALSE,

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