DBA Data[Home] [Help]

APPS.AR_BR_REMIT_IMPORT_API_PUB dependencies on FND_API

Line 52: x_return_status := FND_API.G_RET_STS_ERROR;

48: arp_standard.debug ('impremapi.dummy_remittance()-');
49:
50: EXCEPTION
51: WHEN OTHERS THEN
52: x_return_status := FND_API.G_RET_STS_ERROR;
53: ROLLBACK TO IMPORT_MAIN;
54: arp_standard.debug('EXCEPTION OTHERS: impremapi.Dummy_Remittance');
55: app_exception.raise_exception;
56: END;

Line 366: x_return_status := FND_API.G_RET_STS_ERROR;

362: arp_standard.debug ('impremapi.Existing_Remittance ()-');
363:
364: EXCEPTION
365: WHEN OTHERS THEN
366: x_return_status := FND_API.G_RET_STS_ERROR;
367: ROLLBACK TO IMPORT_MAIN;
368: arp_standard.debug ('EXCEPTION WHEN OTHERS impremapi.Existing_Remittance');
369: app_exception.raise_exception;
370:

Line 460: x_return_status := FND_API.G_RET_STS_ERROR;

456: CLOSE branch;
457:
458: EXCEPTION
459: WHEN NO_DATA_FOUND THEN
460: x_return_status := FND_API.G_RET_STS_ERROR;
461: ROLLBACK TO IMPORT_MAIN;
462: arp_standard.debug('EXCEPTION Branch no_data : ' ||
463: 'impremapi.New_Remittance');
464: fnd_message.set_name ( 'AR', 'AR_MUST_ENTER_REMIT_BANK');

Line 478: x_return_status := FND_API.G_RET_STS_ERROR;

474: CLOSE account;
475:
476: EXCEPTION
477: WHEN NO_DATA_FOUND THEN
478: x_return_status := FND_API.G_RET_STS_ERROR;
479: ROLLBACK TO IMPORT_MAIN;
480: arp_standard.debug('EXCEPTION Bank acc id no_data : ' ||
481: 'impremapi.New_Remittance');
482: fnd_message.set_name ( 'AR', 'Invalid Remittance Bank Branch');

Line 500: x_return_status := FND_API.G_RET_STS_ERROR;

496: where name = p_payment_method;
497:
498: EXCEPTION
499: WHEN NO_DATA_FOUND THEN
500: x_return_status := FND_API.G_RET_STS_ERROR;
501: ROLLBACK TO IMPORT_MAIN;
502: arp_standard.debug('EXCEPTION Receipt Method : impremapi.New_Remittance');
503: fnd_message.set_name('AR','AR_BR_INVALID_REMIT_PROGRAM');
504: app_exception.raise_exception;

Line 521: x_return_status := FND_API.G_RET_STS_ERROR;

517:
518:
519: EXCEPTION
520: WHEN NO_DATA_FOUND THEN
521: x_return_status := FND_API.G_RET_STS_ERROR;
522: ROLLBACK TO IMPORT_MAIN;
523: arp_standard.debug('EXCEPTION Receipt Method Progs : impremapi.New_Remittance');
524: fnd_message.set_name ( 'AR', 'AR_BR_INVALID_RECEIPT_METHOD');
525: app_exception.raise_exception;

Line 584: x_return_status := FND_API.G_RET_STS_ERROR;

580: arp_standard.debug ('impremapi.New_Remittance ()-');
581:
582: EXCEPTION
583: WHEN OTHERS THEN
584: x_return_status := FND_API.G_RET_STS_ERROR;
585: ROLLBACK TO IMPORT_MAIN;
586: arp_standard.debug('EXCEPTION OTHERS: impremapi.New_Remittance');
587: app_exception.raise_exception;
588: END;

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

653: |---------------------------------------------------------------------------------------------------------------------------*/
654:
655: PROCEDURE import_remittance_main (
656: p_api_version IN NUMBER,
657: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
658: p_commit IN VARCHAR2, -- := FND_API.G_FALSE,
659: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
660: x_return_status OUT NOCOPY VARCHAR2,
661: x_msg_count OUT NOCOPY NUMBER,

Line 658: p_commit IN VARCHAR2, -- := FND_API.G_FALSE,

654:
655: PROCEDURE import_remittance_main (
656: p_api_version IN NUMBER,
657: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
658: p_commit IN VARCHAR2, -- := FND_API.G_FALSE,
659: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
660: x_return_status OUT NOCOPY VARCHAR2,
661: x_msg_count OUT NOCOPY NUMBER,
662: x_msg_data OUT NOCOPY VARCHAR2,

Line 659: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

655: PROCEDURE import_remittance_main (
656: p_api_version IN NUMBER,
657: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
658: p_commit IN VARCHAR2, -- := FND_API.G_FALSE,
659: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
660: x_return_status OUT NOCOPY VARCHAR2,
661: x_msg_count OUT NOCOPY NUMBER,
662: x_msg_data OUT NOCOPY VARCHAR2,
663: p_remittance_bank_number IN ce_bank_branches_v.bank_number%TYPE,

Line 694: IF NOT FND_API.Compatible_API_Call(

690:
691: SAVEPOINT IMPORT_MAIN;
692:
693: -- Standard call to check for call compatibility
694: IF NOT FND_API.Compatible_API_Call(
695: l_api_version,
696: p_api_version,
697: l_api_name,
698: G_PKG_NAME )

Line 700: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

696: p_api_version,
697: l_api_name,
698: G_PKG_NAME )
699: THEN
700: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
701: END IF;
702:
703: -- Initialize message list if p_init_msg_list is set to TRUE
704:

Line 705: IF FND_API.to_Boolean( p_init_msg_list ) THEN

701: END IF;
702:
703: -- Initialize message list if p_init_msg_list is set to TRUE
704:
705: IF FND_API.to_Boolean( p_init_msg_list ) THEN
706: FND_MSG_PUB.initialize;
707: END IF;
708:
709:

Line 712: x_return_status := FND_API.G_RET_STS_SUCCESS;

708:
709:
710: -- Initialize return status to SUCCESS
711:
712: x_return_status := FND_API.G_RET_STS_SUCCESS;
713:
714:
715:
716: /* SSA change */

Line 718: l_org_return_status := FND_API.G_RET_STS_SUCCESS;

714:
715:
716: /* SSA change */
717: l_org_id := p_org_id;
718: l_org_return_status := FND_API.G_RET_STS_SUCCESS;
719: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,
720: p_return_status =>l_org_return_status);
721: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
722: x_return_status := FND_API.G_RET_STS_ERROR;

Line 721: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN

717: l_org_id := p_org_id;
718: l_org_return_status := FND_API.G_RET_STS_SUCCESS;
719: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,
720: p_return_status =>l_org_return_status);
721: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
722: x_return_status := FND_API.G_RET_STS_ERROR;
723: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
724: p_count => x_msg_count,
725: p_data => x_msg_data);

Line 722: x_return_status := FND_API.G_RET_STS_ERROR;

718: l_org_return_status := FND_API.G_RET_STS_SUCCESS;
719: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,
720: p_return_status =>l_org_return_status);
721: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
722: x_return_status := FND_API.G_RET_STS_ERROR;
723: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
724: p_count => x_msg_count,
725: p_data => x_msg_data);
726: ELSE

Line 723: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

719: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,
720: p_return_status =>l_org_return_status);
721: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
722: x_return_status := FND_API.G_RET_STS_ERROR;
723: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
724: p_count => x_msg_count,
725: p_data => x_msg_data);
726: ELSE
727: -- Start Of API Body

Line 735: x_return_status := FND_API.G_RET_STS_ERROR;

731: | Check whether the remittance exists |
732: ---------------------------------------------------------------------------------------*/
733:
734: IF p_media_reference is null THEN
735: x_return_status := FND_API.G_RET_STS_ERROR;
736: arp_standard.debug('Impremapi.Import_Remittance_Main media_ref null');
737: --bug 1644533
738: fnd_message.set_name('AR_BR','AR_BR_MEDIA_REF_NULL');
739: app_exception.raise_exception;

Line 764: IF FND_API.To_Boolean( p_commit ) THEN arp_standard.debug('committing');

760: /*-----------------------------------------------+
761: | Standard check of p_commit |
762: ------------------------------------------------*/
763:
764: IF FND_API.To_Boolean( p_commit ) THEN arp_standard.debug('committing');
765: Commit;
766: END IF;
767: END IF;
768: