DBA Data[Home] [Help]

APPS.IBY_HZ_UNIFICATION_PKG dependencies on FND_API

Line 42: x_return_status := FND_API.G_RET_STS_SUCCESS;

38:
39: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.external_payer_merge';
40: BEGIN
41: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
42: x_return_status := FND_API.G_RET_STS_SUCCESS;
43:
44: IF (c_dupepayer%ISOPEN) THEN CLOSE c_dupepayer; END IF;
45:
46: IF (p_parent_entity_name = 'HZ_PARTIES') THEN

Line 83: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

79:
80: FND_MESSAGE.SET_NAME('IBY', 'IBY_9999');
81: FND_MESSAGE.SET_TOKEN('MESSAGE_TEXT' ,SQLERRM);
82: FND_MSG_PUB.ADD;
83: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
84: END external_payer_merge;
85:
86: PROCEDURE external_payee_merge
87: (p_entity_name IN VARCHAR2,

Line 148: x_return_status := FND_API.G_RET_STS_SUCCESS;

144:
145: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.external_payee_merge';
146: BEGIN
147: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
148: x_return_status := FND_API.G_RET_STS_SUCCESS;
149:
150: IF (c_dupeparty%ISOPEN) THEN CLOSE c_dupeparty; END IF;
151:
152: p_to_id := p_from_id;

Line 220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

216:
217: FND_MESSAGE.SET_NAME('IBY', 'IBY_9999');
218: FND_MESSAGE.SET_TOKEN('MESSAGE_TEXT' ,SQLERRM);
219: FND_MSG_PUB.ADD;
220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
221: END external_payee_merge;
222:
223: PROCEDURE credit_card_merge
224: (p_entity_name IN VARCHAR2,

Line 256: x_return_status := FND_API.G_RET_STS_SUCCESS;

252:
253: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.credit_card_merge';
254: BEGIN
255: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
256: x_return_status := FND_API.G_RET_STS_SUCCESS;
257:
258: IF (c_dupecc%ISOPEN) THEN CLOSE c_dupecc; END IF;
259:
260: iby_debug_pub.add('batch id:='|| p_batch_id,

Line 282: x_return_status := fnd_api.g_ret_sts_error;

278: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
279:
280: fnd_message.set_name('IBY','IBY_PARTY_UNIFY_CC_VETO');
281: fnd_msg_pub.ADD;
282: x_return_status := fnd_api.g_ret_sts_error;
283: END IF;
284:
285:
286: OPEN c_dupecc(p_from_id,p_to_fk_id);

Line 335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

331:
332: FND_MESSAGE.SET_NAME('IBY', 'IBY_9999');
333: FND_MESSAGE.SET_TOKEN('MESSAGE_TEXT' ,SQLERRM);
334: FND_MSG_PUB.ADD;
335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
336: END credit_card_merge;
337:
338: PROCEDURE pmt_instrument_use_merge
339: (p_entity_name IN VARCHAR2,

Line 390: x_return_status := FND_API.G_RET_STS_SUCCESS;

386:
387: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.pmt_instrument_use_merge';
388: BEGIN
389: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
390: x_return_status := FND_API.G_RET_STS_SUCCESS;
391:
392: IF (c_dupinstr%ISOPEN) THEN CLOSE c_dupinstr; END IF;
393:
394: IF (p_parent_entity_name = 'IBY_CREDITCARD') THEN

Line 468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

464:
465: FND_MESSAGE.SET_NAME('IBY', 'IBY_9999');
466: FND_MESSAGE.SET_TOKEN('MESSAGE_TEXT' ,SQLERRM);
467: FND_MSG_PUB.ADD;
468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
469: END pmt_instrument_use_merge;
470:
471: PROCEDURE bank_acct_owner_merge
472: (p_entity_name IN VARCHAR2,

Line 503: x_return_status := FND_API.G_RET_STS_SUCCESS;

499:
500: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.bank_acct_owner_merge';
501: BEGIN
502: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
503: x_return_status := FND_API.G_RET_STS_SUCCESS;
504:
505: IF c_dupeba%ISOPEN THEN CLOSE c_dupeba; END IF;
506:
507: IF (p_from_fk_id = p_to_fk_id) THEN

Line 523: x_return_status := fnd_api.g_ret_sts_error;

519: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
520:
521: fnd_message.set_name('IBY','IBY_PARTY_UNIFY_BA_VETO');
522: fnd_msg_pub.ADD;
523: x_return_status := fnd_api.g_ret_sts_error;
524: END IF;
525:
526: OPEN c_dupeba(p_from_id,p_to_fk_id);
527: FETCH c_dupeba INTO l_dup_id;

Line 556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

552:
553: FND_MESSAGE.SET_NAME('IBY', 'IBY_9999');
554: FND_MESSAGE.SET_TOKEN('MESSAGE_TEXT' ,SQLERRM);
555: FND_MSG_PUB.ADD;
556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
557: END bank_acct_owner_merge;
558:
559: PROCEDURE party_pmt_methods_merge
560: (p_entity_name IN VARCHAR2,

Line 593: x_return_status := FND_API.G_RET_STS_SUCCESS;

589:
590: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.party_pmt_methods_merge';
591: BEGIN
592: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
593: x_return_status := FND_API.G_RET_STS_SUCCESS;
594:
595: IF (p_from_fk_id = p_to_fk_id) THEN
596: p_to_id := p_from_id;
597: RETURN;

Line 636: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

632:
633: FND_MESSAGE.SET_NAME('IBY', 'IBY_9999');
634: FND_MESSAGE.SET_TOKEN('MESSAGE_TEXT' ,SQLERRM);
635: FND_MSG_PUB.ADD;
636: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
637: END party_pmt_methods_merge;
638:
639: PROCEDURE fc_tx_extensions_merge
640: (p_entity_name IN VARCHAR2,

Line 654: x_return_status := FND_API.G_RET_STS_SUCCESS;

650: IS
651: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.fc_tx_extensions_merge';
652: BEGIN
653: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
654: x_return_status := FND_API.G_RET_STS_SUCCESS;
655:
656: -- transactional entities never merged
657: p_to_id := p_from_id;
658:

Line 693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

689:
690: FND_MESSAGE.SET_NAME('IBY', 'IBY_9999');
691: FND_MESSAGE.SET_TOKEN('MESSAGE_TEXT' ,SQLERRM);
692: FND_MSG_PUB.ADD;
693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
694: END fc_tx_extensions_merge;
695:
696: PROCEDURE txn_summ_all_merge
697: (p_entity_name IN VARCHAR2,

Line 711: x_return_status := FND_API.G_RET_STS_SUCCESS;

707: IS
708: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.txn_summ_all_merge';
709: BEGIN
710: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
711: x_return_status := FND_API.G_RET_STS_SUCCESS;
712:
713: -- transactional entities never merged
714: p_to_id := p_from_id;
715:

Line 760: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

756:
757: FND_MESSAGE.SET_NAME('IBY', 'IBY_9999');
758: FND_MESSAGE.SET_TOKEN('MESSAGE_TEXT' ,SQLERRM);
759: FND_MSG_PUB.ADD;
760: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
761: END txn_summ_all_merge;
762:
763: PROCEDURE doc_payable_merge
764: (p_entity_name IN VARCHAR2,

Line 778: x_return_status := FND_API.G_RET_STS_SUCCESS;

774: IS
775: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.doc_payable_all_merge';
776: BEGIN
777: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
778: x_return_status := FND_API.G_RET_STS_SUCCESS;
779:
780: -- transactional entities never merged
781: p_to_id := p_from_id;
782:

Line 840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

836:
837: FND_MESSAGE.SET_NAME('IBY', 'IBY_9999');
838: FND_MESSAGE.SET_TOKEN('MESSAGE_TEXT' ,SQLERRM);
839: FND_MSG_PUB.ADD;
840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
841: END doc_payable_merge;
842:
843: PROCEDURE payments_all_merge
844: (p_entity_name IN VARCHAR2,

Line 858: x_return_status := FND_API.G_RET_STS_SUCCESS;

854: IS
855: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.payments_all_merge';
856: BEGIN
857: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
858: x_return_status := FND_API.G_RET_STS_SUCCESS;
859:
860: -- transactional entities never merged
861: p_to_id := p_from_id;
862:

Line 928: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

924:
925: FND_MESSAGE.SET_NAME('IBY', 'IBY_9999');
926: FND_MESSAGE.SET_TOKEN('MESSAGE_TEXT' ,SQLERRM);
927: FND_MSG_PUB.ADD;
928: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
929: END payments_all_merge;
930:
931: END IBY_HZ_UNIFICATION_PKG;
932: