APPS.IBY_SUPP_BANK_MERGE_PUB dependencies on FND_API

Line 365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

361:
362: FND_MESSAGE.SET_NAME('IBY', 'IBY_9999');
363: FND_MESSAGE.SET_TOKEN('MESSAGE_TEXT' ,SQLERRM);
364: FND_MSG_PUB.ADD;
365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
366: END MERGE_BANKS;
367:
368: PROCEDURE INSERT_PAYEE_ROW(ext_payee_rec IN IBY_EXTERNAL_PAYEES_ALL%ROWTYPE,
369: P_EXT_PAYEE_ID IN OUT NOCOPY NUMBER,

Line 380: x_return_status := FND_API.G_RET_STS_SUCCESS;

376: SELECT IBY_EXTERNAL_PAYEES_ALL_S.NEXTVAL
377: FROM DUAL;
378:
379: BEGIN
380: x_return_status := FND_API.G_RET_STS_SUCCESS;
381:
382: OPEN get_next_ext_payee_id;
383: FETCH get_next_ext_payee_id INTO P_EXT_PAYEE_ID;
384: CLOSE get_next_ext_payee_id;

Line 456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

452:
453: EXCEPTION
454: WHEN OTHERS THEN
455: fnd_file.put_line(fnd_file.log, 'Exception: insert_payee_row: '||SQLERRM);
456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
457: X_MSG_DATA := 'Exception: insert_payee_row: '||SQLERRM;
458:
459: END INSERT_PAYEE_ROW;
460:

Line 488: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

484: l_pay_msg_data VARCHAR2(1000);
485: g_mesg VARCHAR2(1000) := '';
486:
487: BEGIN
488: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
489:
490: OPEN cur_get_payee_dtls(P_SITE_EXT_PAYEE_ID);
491: FETCH cur_get_payee_dtls INTO l_Ext_payee_rec;
492: CLOSE cur_get_payee_dtls;

Line 600: X_return_status := FND_API.G_RET_STS_SUCCESS;

596: L_TO_PARTY_SITE_ID NUMBER;
597: l_site_payee_id NUMBER;
598:
599: BEGIN
600: X_return_status := FND_API.G_RET_STS_SUCCESS;
601:
602: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
603: -- Log All Parameters
604: g_mesg := 'Entering IBY_SUPP_BANK_MERGE.BANK_ACCOUNTS_MERGE ';

Line 725: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

721:
722: -- If external Payee record is not available and there are bank accounts associated to From Supplier Address-OU Then create External payee at address-OU level.
723: IF l_to_ext_payee_id IS NULL AND from_instr_pmt_use_list.Count > 0 THEN
724: Create_external_payee(l_site_payee_id, 'ADDRESS_OU', l_to_ext_payee_id, X_RETURN_STATUS, X_MSG_COUNT, X_MSG_DATA);
725: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
726: fnd_file.put_line(fnd_file.log, 'Exception: '||X_MSG_DATA);
727: END IF;
728: END IF;
729:

Line 762: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

758:
759: -- If external Payee record is not available and there are bank accounts associated to 'From Supplier' Address Then create External payee at address level.
760: IF l_to_ext_payee_id IS NULL AND from_instr_pmt_use_list.Count > 0 THEN
761: Create_external_payee(l_site_payee_id, 'ADDRESS', l_to_ext_payee_id, X_RETURN_STATUS, X_MSG_COUNT, X_MSG_DATA);
762: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
763: fnd_file.put_line(fnd_file.log, 'Exception: '||X_MSG_DATA);
764: END IF;
765: END IF;
766:

Line 800: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

796:
797: -- If external Payee record is not available and there are bank accounts associated to 'From Supplier' Then create External payee at Supplier level.
798: IF l_to_ext_payee_id IS NULL AND from_instr_pmt_use_list.Count > 0 THEN
799: Create_external_payee(l_site_payee_id, 'SUPPLIER', l_to_ext_payee_id, X_RETURN_STATUS, X_MSG_COUNT, X_MSG_DATA);
800: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
801: fnd_file.put_line(fnd_file.log, 'Exception: '||X_MSG_DATA);
802: END IF;
803: END IF;
804:

Line 851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

847:
848: FND_MESSAGE.SET_NAME('IBY', 'IBY_9999');
849: FND_MESSAGE.SET_TOKEN('MESSAGE_TEXT' ,SQLERRM);
850: FND_MSG_PUB.ADD;
851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
852:
853: END BANK_ACCOUNTS_MERGE;
854:
855: END IBY_SUPP_BANK_MERGE_PUB;