APPS.AR_RECEIPT_API_PUB dependencies on STANDARD

Line 85: -- Standard API parameters.

81: END initialize_profile_globals;
82:
83:
84: PROCEDURE Create_cash_1(
85: -- Standard API parameters.
86: p_api_version IN NUMBER,
87: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
88: p_commit IN VARCHAR2 := FND_API.G_FALSE,
89: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

Line 253: | Standard start of API savepoint |

249: l_org_id := p_org_id;
250: l_default_site_use := p_default_site_use; --bug4448307-4509459
251:
252: /*------------------------------------+
253: | Standard start of API savepoint |
254: +------------------------------------*/
255:
256: SAVEPOINT Create_cash_PVT;
257:

Line 259: | Standard call to check for call compatibility |

255:
256: SAVEPOINT Create_cash_PVT;
257:
258: /*--------------------------------------------------+
259: | Standard call to check for call compatibility |
260: +--------------------------------------------------*/
261:
262: IF NOT FND_API.Compatible_API_Call(
263: l_api_version,

Line 557: arp_standard.debug ('x_return_status (' || x_return_status ||')');

553: END IF;
554: END IF;
555:
556: /* Bug 5364287 */
557: arp_standard.debug ('x_return_status (' || x_return_status ||')');
558: arp_standard.debug ('l_doc_seq_status (' || l_doc_seq_status ||')');
559: IF (
560: x_return_status <> FND_API.G_RET_STS_SUCCESS
561: OR l_doc_seq_status <> FND_API.G_RET_STS_SUCCESS

Line 558: arp_standard.debug ('l_doc_seq_status (' || l_doc_seq_status ||')');

554: END IF;
555:
556: /* Bug 5364287 */
557: arp_standard.debug ('x_return_status (' || x_return_status ||')');
558: arp_standard.debug ('l_doc_seq_status (' || l_doc_seq_status ||')');
559: IF (
560: x_return_status <> FND_API.G_RET_STS_SUCCESS
561: OR l_doc_seq_status <> FND_API.G_RET_STS_SUCCESS
562: )

Line 605: arp_standard.debug('calling copy Extension....');

601: IF nvl(p_installment,1) = 1 THEN
602:
603:
604: IF l_creation_method = 'A' THEN
605: arp_standard.debug('calling copy Extension....');
606:
607: Copy_payment_extension (
608: p_payment_trxn_extension_id => l_payment_trxn_extension_id,
609: p_customer_id => l_customer_id,

Line 631: arp_standard.debug('calling copy Extension end ....');

627: END IF;
628:
629: l_payment_trxn_extension_id := l_copy_pmt_trxn_extension_id;
630:
631: arp_standard.debug('calling copy Extension end ....');
632: arp_standard.debug('calling copy Extension end ...2'|| to_char(l_copy_pmt_trxn_extension_id));
633: END IF;
634:
635: ELSE

Line 632: arp_standard.debug('calling copy Extension end ...2'|| to_char(l_copy_pmt_trxn_extension_id));

628:
629: l_payment_trxn_extension_id := l_copy_pmt_trxn_extension_id;
630:
631: arp_standard.debug('calling copy Extension end ....');
632: arp_standard.debug('calling copy Extension end ...2'|| to_char(l_copy_pmt_trxn_extension_id));
633: END IF;
634:
635: ELSE
636: arp_util.debug ('Create_cash -- CHECK2' || p_installment );

Line 638: arp_standard.debug('calling CREATE Extension....');

634:
635: ELSE
636: arp_util.debug ('Create_cash -- CHECK2' || p_installment );
637: IF l_creation_method = 'A' THEN
638: arp_standard.debug('calling CREATE Extension....');
639: Create_payment_extension (
640: p_payment_trxn_extension_id => l_payment_trxn_extension_id,
641: p_customer_id => l_customer_id,
642: p_receipt_method_id =>l_receipt_method_id,

Line 663: arp_standard.debug('calling create Extension end ....');

659: END IF;
660:
661: l_payment_trxn_extension_id := l_create_pmt_trxn_extension_id;
662:
663: arp_standard.debug('calling create Extension end ....');
664: arp_standard.debug('calling create Extension end ...2'||
665: to_char(l_create_pmt_trxn_extension_id));
666:
667:

Line 664: arp_standard.debug('calling create Extension end ...2'||

660:
661: l_payment_trxn_extension_id := l_create_pmt_trxn_extension_id;
662:
663: arp_standard.debug('calling create Extension end ....');
664: arp_standard.debug('calling create Extension end ...2'||
665: to_char(l_create_pmt_trxn_extension_id));
666:
667:
668: END IF;

Line 858: | Standard check of p_commit |

854: );
855:
856:
857: /*--------------------------------+
858: | Standard check of p_commit |
859: +--------------------------------*/
860:
861: IF FND_API.To_Boolean( p_commit )
862: THEN

Line 961: -- Standard API parameters.

957:
958: END Create_cash_1;
959:
960: PROCEDURE Create_cash(
961: -- Standard API parameters.
962: p_api_version IN NUMBER,
963: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
964: p_commit IN VARCHAR2 := FND_API.G_FALSE,
965: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

Line 1062: -- Standard API parameters.

1058: l_default_site_use VARCHAR2(1); --bug4448307-4509459
1059: BEGIN
1060: --call the internal routine
1061: Create_cash_1(
1062: -- Standard API parameters.
1063: p_api_version ,
1064: p_init_msg_list,
1065: p_commit,
1066: p_validation_level,

Line 1129: -- Standard API parameters.

1125: END Create_cash;
1126:
1127:
1128: PROCEDURE Apply(
1129: -- Standard API parameters.
1130: p_api_version IN NUMBER,
1131: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1132: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1133: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

Line 1258: | Standard start of API savepoint |

1254:
1255: BEGIN
1256:
1257: /*------------------------------------+
1258: | Standard start of API savepoint |
1259: +------------------------------------*/
1260:
1261: SAVEPOINT Apply_PVT;
1262:

Line 1264: | Standard call to check for call compatibility |

1260:
1261: SAVEPOINT Apply_PVT;
1262:
1263: /*--------------------------------------------------+
1264: | Standard call to check for call compatibility |
1265: +--------------------------------------------------*/
1266:
1267: IF NOT FND_API.Compatible_API_Call(
1268: l_api_version,

Line 1796: | Standard check of p_commit |

1792: p_global_attribute19 => l_global_attribute_rec.global_attribute19,
1793: p_global_attribute20 => l_global_attribute_rec.global_attribute20,
1794: p_return_status => l_gdflex_return_status);
1795: /*--------------------------------+
1796: | Standard check of p_commit |
1797: +--------------------------------*/
1798:
1799: IF FND_API.To_Boolean( p_commit )
1800: THEN

Line 1901: -- Standard API parameters.

1897:
1898: END Apply;
1899:
1900: PROCEDURE Apply_In_Detail(
1901: -- Standard API parameters.
1902: p_api_version IN NUMBER,
1903: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1904: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1905: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

Line 2055: | Standard start of API savepoint |

2051: l_line_attribute_rec attribute_rec_type;
2052: BEGIN
2053:
2054: /*------------------------------------+
2055: | Standard start of API savepoint |
2056: +------------------------------------*/
2057: SAVEPOINT Apply_In_Detail_PVT;
2058:
2059: /*--------------------------------------------------+

Line 2060: | Standard call to check for call compatibility |

2056: +------------------------------------*/
2057: SAVEPOINT Apply_In_Detail_PVT;
2058:
2059: /*--------------------------------------------------+
2060: | Standard call to check for call compatibility |
2061: +--------------------------------------------------*/
2062: IF NOT FND_API.Compatible_API_Call(
2063: l_api_version,
2064: p_api_version,

Line 2112: IF NOT arp_standard.is_llca_allowed(l_org_id,p_customer_trx_id) THEN

2108: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2109: x_return_status := FND_API.G_RET_STS_ERROR;
2110: ELSE
2111: --Verify whether LLCA is allowed for given invoice
2112: IF NOT arp_standard.is_llca_allowed(l_org_id,p_customer_trx_id) THEN
2113: FND_MESSAGE.set_name('AR', 'AR_SUMMARIZED_DIST_NO_LLCA_RCT');
2114: FND_MSG_PUB.Add;
2115: x_return_status := FND_API.G_RET_STS_ERROR;
2116: RAISE FND_API.G_EXC_ERROR;

Line 2813: | Standard check of p_commit |

2809: Return;
2810: END IF;
2811:
2812: /*--------------------------------+
2813: | Standard check of p_commit |
2814: +--------------------------------*/
2815:
2816: IF FND_API.To_Boolean( p_commit )
2817: THEN

Line 2917: -- Standard API parameters.

2913: );
2914: END Apply_In_Detail;
2915:
2916: PROCEDURE Unapply(
2917: -- Standard API parameters.
2918: p_api_version IN NUMBER,
2919: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2920: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2921: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

Line 2961: | Standard start of API savepoint |

2957: l_org_return_status VARCHAR2(1);
2958: l_org_id NUMBER;
2959: BEGIN
2960: /*------------------------------------+
2961: | Standard start of API savepoint |
2962: +------------------------------------*/
2963:
2964: SAVEPOINT Unapply_PVT;
2965:

Line 2967: | Standard call to check for call compatibility |

2963:
2964: SAVEPOINT Unapply_PVT;
2965:
2966: /*--------------------------------------------------+
2967: | Standard call to check for call compatibility |
2968: +--------------------------------------------------*/
2969:
2970: IF NOT FND_API.Compatible_API_Call(
2971: l_api_version,

Line 3307: | Standard check of p_commit |

3303: END IF;
3304:
3305: END;
3306: /*--------------------------------+
3307: | Standard check of p_commit |
3308: +--------------------------------*/
3309:
3310: IF FND_API.To_Boolean( p_commit )
3311: THEN

Line 3491: arp_standard.debug('Apply: ' || 'Entering credit card processing...');

3487:
3488:
3489: /*
3490: IF PG_DEBUG in ('Y', 'C') THEN
3491: arp_standard.debug('Apply: ' || 'Entering credit card processing...');
3492: END IF;
3493:
3494: OPEN rct_info_cur;
3495: FETCH rct_info_cur INTO rct_info;

Line 3506: arp_standard.debug('Apply: ' || 'credit card bank branch is ' ||

3502:
3503: IF rct_info.bank_branch_id = arp_global.CC_BANK_BRANCH_ID THEN
3504:
3505: IF PG_DEBUG in ('Y', 'C') THEN
3506: arp_standard.debug('Apply: ' || 'credit card bank branch is ' ||
3507: arp_global.CC_BANK_BRANCH_ID || ' --> CC acct');
3508: END IF;
3509:
3510: -- determine whether to AUTHORIZE only or to

Line 3525: arp_standard.debug('Apply: ' || 'ERROR: Creation status is ' || rct_info.creation_status);

3521: elsif rct_info.creation_status = 'CONFIRMED' THEN
3522: l_action := 'AUTHONLY';
3523: else
3524: IF PG_DEBUG in ('Y', 'C') THEN
3525: arp_standard.debug('Apply: ' || 'ERROR: Creation status is ' || rct_info.creation_status);
3526: END IF;
3527:
3528: FND_MESSAGE.set_name('AR', 'AR_PAY_PROCESS_INVALID_STATUS');
3529: FND_MSG_PUB.Add;

Line 3580: arp_standard.debug('Apply: ' || 'Calling OraPmtReq');

3576:
3577: -- call to iPayment API OraPmtReq to authorize funds
3578:
3579: IF PG_DEBUG in ('Y', 'C') THEN
3580: arp_standard.debug('Apply: ' || 'Calling OraPmtReq');
3581: arp_standard.debug('Apply: ' || 'l_pmtreqtrxn_rec.pmtmode: ' || l_pmtreqtrxn_rec.pmtmode);
3582: arp_standard.debug('Apply: ' || 'l_pmtreqtrxn_rec.auth_type: ' || l_pmtreqtrxn_rec.auth_type);
3583:
3584: arp_standard.debug( 'l_pmtreqtrxn_rec.TrxnRef: ' || l_pmtreqtrxn_rec.TrxnRef);

Line 3581: arp_standard.debug('Apply: ' || 'l_pmtreqtrxn_rec.pmtmode: ' || l_pmtreqtrxn_rec.pmtmode);

3577: -- call to iPayment API OraPmtReq to authorize funds
3578:
3579: IF PG_DEBUG in ('Y', 'C') THEN
3580: arp_standard.debug('Apply: ' || 'Calling OraPmtReq');
3581: arp_standard.debug('Apply: ' || 'l_pmtreqtrxn_rec.pmtmode: ' || l_pmtreqtrxn_rec.pmtmode);
3582: arp_standard.debug('Apply: ' || 'l_pmtreqtrxn_rec.auth_type: ' || l_pmtreqtrxn_rec.auth_type);
3583:
3584: arp_standard.debug( 'l_pmtreqtrxn_rec.TrxnRef: ' || l_pmtreqtrxn_rec.TrxnRef);
3585:

Line 3582: arp_standard.debug('Apply: ' || 'l_pmtreqtrxn_rec.auth_type: ' || l_pmtreqtrxn_rec.auth_type);

3578:
3579: IF PG_DEBUG in ('Y', 'C') THEN
3580: arp_standard.debug('Apply: ' || 'Calling OraPmtReq');
3581: arp_standard.debug('Apply: ' || 'l_pmtreqtrxn_rec.pmtmode: ' || l_pmtreqtrxn_rec.pmtmode);
3582: arp_standard.debug('Apply: ' || 'l_pmtreqtrxn_rec.auth_type: ' || l_pmtreqtrxn_rec.auth_type);
3583:
3584: arp_standard.debug( 'l_pmtreqtrxn_rec.TrxnRef: ' || l_pmtreqtrxn_rec.TrxnRef);
3585:
3586: arp_standard.debug('Apply: ' || 'l_tangible_rec.tangible_id: ' || l_payment_server_order_num);

Line 3584: arp_standard.debug( 'l_pmtreqtrxn_rec.TrxnRef: ' || l_pmtreqtrxn_rec.TrxnRef);

3580: arp_standard.debug('Apply: ' || 'Calling OraPmtReq');
3581: arp_standard.debug('Apply: ' || 'l_pmtreqtrxn_rec.pmtmode: ' || l_pmtreqtrxn_rec.pmtmode);
3582: arp_standard.debug('Apply: ' || 'l_pmtreqtrxn_rec.auth_type: ' || l_pmtreqtrxn_rec.auth_type);
3583:
3584: arp_standard.debug( 'l_pmtreqtrxn_rec.TrxnRef: ' || l_pmtreqtrxn_rec.TrxnRef);
3585:
3586: arp_standard.debug('Apply: ' || 'l_tangible_rec.tangible_id: ' || l_payment_server_order_num);
3587: arp_standard.debug('Apply: ' || 'l_tangible_rec.tangible_amount: ' || to_char(l_tangible_rec.tangible_amount) );
3588: arp_standard.debug('Apply: ' || 'l_tangible_rec.currency_code: ' ||l_tangible_rec.currency_code );

Line 3586: arp_standard.debug('Apply: ' || 'l_tangible_rec.tangible_id: ' || l_payment_server_order_num);

3582: arp_standard.debug('Apply: ' || 'l_pmtreqtrxn_rec.auth_type: ' || l_pmtreqtrxn_rec.auth_type);
3583:
3584: arp_standard.debug( 'l_pmtreqtrxn_rec.TrxnRef: ' || l_pmtreqtrxn_rec.TrxnRef);
3585:
3586: arp_standard.debug('Apply: ' || 'l_tangible_rec.tangible_id: ' || l_payment_server_order_num);
3587: arp_standard.debug('Apply: ' || 'l_tangible_rec.tangible_amount: ' || to_char(l_tangible_rec.tangible_amount) );
3588: arp_standard.debug('Apply: ' || 'l_tangible_rec.currency_code: ' ||l_tangible_rec.currency_code );
3589: arp_standard.debug('Apply: ' || 'l_tangible_rec.refinfo: ' || l_tangible_rec.refinfo);
3590: arp_standard.debug('Apply: ' || 'l_cc_instr_rec.cc_num: ' ||l_cc_instr_rec.cc_num );

Line 3587: arp_standard.debug('Apply: ' || 'l_tangible_rec.tangible_amount: ' || to_char(l_tangible_rec.tangible_amount) );

3583:
3584: arp_standard.debug( 'l_pmtreqtrxn_rec.TrxnRef: ' || l_pmtreqtrxn_rec.TrxnRef);
3585:
3586: arp_standard.debug('Apply: ' || 'l_tangible_rec.tangible_id: ' || l_payment_server_order_num);
3587: arp_standard.debug('Apply: ' || 'l_tangible_rec.tangible_amount: ' || to_char(l_tangible_rec.tangible_amount) );
3588: arp_standard.debug('Apply: ' || 'l_tangible_rec.currency_code: ' ||l_tangible_rec.currency_code );
3589: arp_standard.debug('Apply: ' || 'l_tangible_rec.refinfo: ' || l_tangible_rec.refinfo);
3590: arp_standard.debug('Apply: ' || 'l_cc_instr_rec.cc_num: ' ||l_cc_instr_rec.cc_num );
3591: arp_standard.debug('Apply: ' || 'l_cc_instr_rec.cc_ExpDate: ' || to_char(l_cc_instr_rec.cc_ExpDate));

Line 3588: arp_standard.debug('Apply: ' || 'l_tangible_rec.currency_code: ' ||l_tangible_rec.currency_code );

3584: arp_standard.debug( 'l_pmtreqtrxn_rec.TrxnRef: ' || l_pmtreqtrxn_rec.TrxnRef);
3585:
3586: arp_standard.debug('Apply: ' || 'l_tangible_rec.tangible_id: ' || l_payment_server_order_num);
3587: arp_standard.debug('Apply: ' || 'l_tangible_rec.tangible_amount: ' || to_char(l_tangible_rec.tangible_amount) );
3588: arp_standard.debug('Apply: ' || 'l_tangible_rec.currency_code: ' ||l_tangible_rec.currency_code );
3589: arp_standard.debug('Apply: ' || 'l_tangible_rec.refinfo: ' || l_tangible_rec.refinfo);
3590: arp_standard.debug('Apply: ' || 'l_cc_instr_rec.cc_num: ' ||l_cc_instr_rec.cc_num );
3591: arp_standard.debug('Apply: ' || 'l_cc_instr_rec.cc_ExpDate: ' || to_char(l_cc_instr_rec.cc_ExpDate));
3592: arp_standard.debug('Apply: ' || 'l_cc_instr_rec.cc_HolderName: ' || l_cc_instr_rec.cc_HolderName );

Line 3589: arp_standard.debug('Apply: ' || 'l_tangible_rec.refinfo: ' || l_tangible_rec.refinfo);

3585:
3586: arp_standard.debug('Apply: ' || 'l_tangible_rec.tangible_id: ' || l_payment_server_order_num);
3587: arp_standard.debug('Apply: ' || 'l_tangible_rec.tangible_amount: ' || to_char(l_tangible_rec.tangible_amount) );
3588: arp_standard.debug('Apply: ' || 'l_tangible_rec.currency_code: ' ||l_tangible_rec.currency_code );
3589: arp_standard.debug('Apply: ' || 'l_tangible_rec.refinfo: ' || l_tangible_rec.refinfo);
3590: arp_standard.debug('Apply: ' || 'l_cc_instr_rec.cc_num: ' ||l_cc_instr_rec.cc_num );
3591: arp_standard.debug('Apply: ' || 'l_cc_instr_rec.cc_ExpDate: ' || to_char(l_cc_instr_rec.cc_ExpDate));
3592: arp_standard.debug('Apply: ' || 'l_cc_instr_rec.cc_HolderName: ' || l_cc_instr_rec.cc_HolderName );
3593: arp_standard.debug('Apply: ' || 'l_payee_rec.payee_id: ' ||l_payee_rec.payee_id );

Line 3590: arp_standard.debug('Apply: ' || 'l_cc_instr_rec.cc_num: ' ||l_cc_instr_rec.cc_num );

3586: arp_standard.debug('Apply: ' || 'l_tangible_rec.tangible_id: ' || l_payment_server_order_num);
3587: arp_standard.debug('Apply: ' || 'l_tangible_rec.tangible_amount: ' || to_char(l_tangible_rec.tangible_amount) );
3588: arp_standard.debug('Apply: ' || 'l_tangible_rec.currency_code: ' ||l_tangible_rec.currency_code );
3589: arp_standard.debug('Apply: ' || 'l_tangible_rec.refinfo: ' || l_tangible_rec.refinfo);
3590: arp_standard.debug('Apply: ' || 'l_cc_instr_rec.cc_num: ' ||l_cc_instr_rec.cc_num );
3591: arp_standard.debug('Apply: ' || 'l_cc_instr_rec.cc_ExpDate: ' || to_char(l_cc_instr_rec.cc_ExpDate));
3592: arp_standard.debug('Apply: ' || 'l_cc_instr_rec.cc_HolderName: ' || l_cc_instr_rec.cc_HolderName );
3593: arp_standard.debug('Apply: ' || 'l_payee_rec.payee_id: ' ||l_payee_rec.payee_id );
3594: arp_standard.debug('Apply: ' || 'l_customer_rec.payer_name: ' || l_customer_rec.payer_name);

Line 3591: arp_standard.debug('Apply: ' || 'l_cc_instr_rec.cc_ExpDate: ' || to_char(l_cc_instr_rec.cc_ExpDate));

3587: arp_standard.debug('Apply: ' || 'l_tangible_rec.tangible_amount: ' || to_char(l_tangible_rec.tangible_amount) );
3588: arp_standard.debug('Apply: ' || 'l_tangible_rec.currency_code: ' ||l_tangible_rec.currency_code );
3589: arp_standard.debug('Apply: ' || 'l_tangible_rec.refinfo: ' || l_tangible_rec.refinfo);
3590: arp_standard.debug('Apply: ' || 'l_cc_instr_rec.cc_num: ' ||l_cc_instr_rec.cc_num );
3591: arp_standard.debug('Apply: ' || 'l_cc_instr_rec.cc_ExpDate: ' || to_char(l_cc_instr_rec.cc_ExpDate));
3592: arp_standard.debug('Apply: ' || 'l_cc_instr_rec.cc_HolderName: ' || l_cc_instr_rec.cc_HolderName );
3593: arp_standard.debug('Apply: ' || 'l_payee_rec.payee_id: ' ||l_payee_rec.payee_id );
3594: arp_standard.debug('Apply: ' || 'l_customer_rec.payer_name: ' || l_customer_rec.payer_name);
3595: END IF;

Line 3592: arp_standard.debug('Apply: ' || 'l_cc_instr_rec.cc_HolderName: ' || l_cc_instr_rec.cc_HolderName );

3588: arp_standard.debug('Apply: ' || 'l_tangible_rec.currency_code: ' ||l_tangible_rec.currency_code );
3589: arp_standard.debug('Apply: ' || 'l_tangible_rec.refinfo: ' || l_tangible_rec.refinfo);
3590: arp_standard.debug('Apply: ' || 'l_cc_instr_rec.cc_num: ' ||l_cc_instr_rec.cc_num );
3591: arp_standard.debug('Apply: ' || 'l_cc_instr_rec.cc_ExpDate: ' || to_char(l_cc_instr_rec.cc_ExpDate));
3592: arp_standard.debug('Apply: ' || 'l_cc_instr_rec.cc_HolderName: ' || l_cc_instr_rec.cc_HolderName );
3593: arp_standard.debug('Apply: ' || 'l_payee_rec.payee_id: ' ||l_payee_rec.payee_id );
3594: arp_standard.debug('Apply: ' || 'l_customer_rec.payer_name: ' || l_customer_rec.payer_name);
3595: END IF;
3596:

Line 3593: arp_standard.debug('Apply: ' || 'l_payee_rec.payee_id: ' ||l_payee_rec.payee_id );

3589: arp_standard.debug('Apply: ' || 'l_tangible_rec.refinfo: ' || l_tangible_rec.refinfo);
3590: arp_standard.debug('Apply: ' || 'l_cc_instr_rec.cc_num: ' ||l_cc_instr_rec.cc_num );
3591: arp_standard.debug('Apply: ' || 'l_cc_instr_rec.cc_ExpDate: ' || to_char(l_cc_instr_rec.cc_ExpDate));
3592: arp_standard.debug('Apply: ' || 'l_cc_instr_rec.cc_HolderName: ' || l_cc_instr_rec.cc_HolderName );
3593: arp_standard.debug('Apply: ' || 'l_payee_rec.payee_id: ' ||l_payee_rec.payee_id );
3594: arp_standard.debug('Apply: ' || 'l_customer_rec.payer_name: ' || l_customer_rec.payer_name);
3595: END IF;
3596:
3597: IBY_Payment_Adapter_pub.OraPmtReq(

Line 3594: arp_standard.debug('Apply: ' || 'l_customer_rec.payer_name: ' || l_customer_rec.payer_name);

3590: arp_standard.debug('Apply: ' || 'l_cc_instr_rec.cc_num: ' ||l_cc_instr_rec.cc_num );
3591: arp_standard.debug('Apply: ' || 'l_cc_instr_rec.cc_ExpDate: ' || to_char(l_cc_instr_rec.cc_ExpDate));
3592: arp_standard.debug('Apply: ' || 'l_cc_instr_rec.cc_HolderName: ' || l_cc_instr_rec.cc_HolderName );
3593: arp_standard.debug('Apply: ' || 'l_payee_rec.payee_id: ' ||l_payee_rec.payee_id );
3594: arp_standard.debug('Apply: ' || 'l_customer_rec.payer_name: ' || l_customer_rec.payer_name);
3595: END IF;
3596:
3597: IBY_Payment_Adapter_pub.OraPmtReq(
3598: p_api_version => 1.0,

Line 3615: arp_standard.debug('Apply: ' || 'l_return_status: ' || l_return_status);

3611: p_riskinfo_rec => l_riskinfo_rec,
3612: x_reqresp_rec => l_reqresp_rec);
3613:
3614: IF PG_DEBUG in ('Y', 'C') THEN
3615: arp_standard.debug('Apply: ' || 'l_return_status: ' || l_return_status);
3616: END IF;
3617:
3618: x_msg_count := l_msg_count;
3619: x_msg_data := l_msg_data;

Line 3623: arp_standard.debug('Apply: ' || '-------------------------------------');

3619: x_msg_data := l_msg_data;
3620: p_response_error_code := l_reqresp_rec.response.errcode;
3621:
3622: IF PG_DEBUG in ('Y', 'C') THEN
3623: arp_standard.debug('Apply: ' || '-------------------------------------');
3624: arp_standard.debug('Apply: ' || 'l_reqresp_rec.response.errcode: ' || l_reqresp_rec.response.errcode);
3625: arp_standard.debug('Apply: ' || 'l_reqresp_rec.response.errmessage: ' || l_reqresp_rec.response.errmessage);
3626: arp_standard.debug('Apply: ' || 'l_reqresp_rec.errorlocation: ' || l_reqresp_rec.errorlocation);
3627: arp_standard.debug('Apply: ' || 'l_reqresp_rec.beperrcode: ' || l_reqresp_rec.beperrcode);

Line 3624: arp_standard.debug('Apply: ' || 'l_reqresp_rec.response.errcode: ' || l_reqresp_rec.response.errcode);

3620: p_response_error_code := l_reqresp_rec.response.errcode;
3621:
3622: IF PG_DEBUG in ('Y', 'C') THEN
3623: arp_standard.debug('Apply: ' || '-------------------------------------');
3624: arp_standard.debug('Apply: ' || 'l_reqresp_rec.response.errcode: ' || l_reqresp_rec.response.errcode);
3625: arp_standard.debug('Apply: ' || 'l_reqresp_rec.response.errmessage: ' || l_reqresp_rec.response.errmessage);
3626: arp_standard.debug('Apply: ' || 'l_reqresp_rec.errorlocation: ' || l_reqresp_rec.errorlocation);
3627: arp_standard.debug('Apply: ' || 'l_reqresp_rec.beperrcode: ' || l_reqresp_rec.beperrcode);
3628: arp_standard.debug('Apply: ' || 'l_reqresp_rec.beperrmessage: ' || l_reqresp_rec.beperrmessage);

Line 3625: arp_standard.debug('Apply: ' || 'l_reqresp_rec.response.errmessage: ' || l_reqresp_rec.response.errmessage);

3621:
3622: IF PG_DEBUG in ('Y', 'C') THEN
3623: arp_standard.debug('Apply: ' || '-------------------------------------');
3624: arp_standard.debug('Apply: ' || 'l_reqresp_rec.response.errcode: ' || l_reqresp_rec.response.errcode);
3625: arp_standard.debug('Apply: ' || 'l_reqresp_rec.response.errmessage: ' || l_reqresp_rec.response.errmessage);
3626: arp_standard.debug('Apply: ' || 'l_reqresp_rec.errorlocation: ' || l_reqresp_rec.errorlocation);
3627: arp_standard.debug('Apply: ' || 'l_reqresp_rec.beperrcode: ' || l_reqresp_rec.beperrcode);
3628: arp_standard.debug('Apply: ' || 'l_reqresp_rec.beperrmessage: ' || l_reqresp_rec.beperrmessage);
3629: arp_standard.debug('Apply: ' || 'NVL(l_reqresp_rec.response.status,0): ' || to_char(NVL(l_reqresp_rec.response.status,0)));

Line 3626: arp_standard.debug('Apply: ' || 'l_reqresp_rec.errorlocation: ' || l_reqresp_rec.errorlocation);

3622: IF PG_DEBUG in ('Y', 'C') THEN
3623: arp_standard.debug('Apply: ' || '-------------------------------------');
3624: arp_standard.debug('Apply: ' || 'l_reqresp_rec.response.errcode: ' || l_reqresp_rec.response.errcode);
3625: arp_standard.debug('Apply: ' || 'l_reqresp_rec.response.errmessage: ' || l_reqresp_rec.response.errmessage);
3626: arp_standard.debug('Apply: ' || 'l_reqresp_rec.errorlocation: ' || l_reqresp_rec.errorlocation);
3627: arp_standard.debug('Apply: ' || 'l_reqresp_rec.beperrcode: ' || l_reqresp_rec.beperrcode);
3628: arp_standard.debug('Apply: ' || 'l_reqresp_rec.beperrmessage: ' || l_reqresp_rec.beperrmessage);
3629: arp_standard.debug('Apply: ' || 'NVL(l_reqresp_rec.response.status,0): ' || to_char(NVL(l_reqresp_rec.response.status,0)));
3630: arp_standard.debug('Apply: ' || 'Authcode: ' || l_reqresp_rec.authcode);

Line 3627: arp_standard.debug('Apply: ' || 'l_reqresp_rec.beperrcode: ' || l_reqresp_rec.beperrcode);

3623: arp_standard.debug('Apply: ' || '-------------------------------------');
3624: arp_standard.debug('Apply: ' || 'l_reqresp_rec.response.errcode: ' || l_reqresp_rec.response.errcode);
3625: arp_standard.debug('Apply: ' || 'l_reqresp_rec.response.errmessage: ' || l_reqresp_rec.response.errmessage);
3626: arp_standard.debug('Apply: ' || 'l_reqresp_rec.errorlocation: ' || l_reqresp_rec.errorlocation);
3627: arp_standard.debug('Apply: ' || 'l_reqresp_rec.beperrcode: ' || l_reqresp_rec.beperrcode);
3628: arp_standard.debug('Apply: ' || 'l_reqresp_rec.beperrmessage: ' || l_reqresp_rec.beperrmessage);
3629: arp_standard.debug('Apply: ' || 'NVL(l_reqresp_rec.response.status,0): ' || to_char(NVL(l_reqresp_rec.response.status,0)));
3630: arp_standard.debug('Apply: ' || 'Authcode: ' || l_reqresp_rec.authcode);
3631: arp_standard.debug('Apply: ' || 'Trxn ID: ' || l_reqresp_rec.Trxn_ID);

Line 3628: arp_standard.debug('Apply: ' || 'l_reqresp_rec.beperrmessage: ' || l_reqresp_rec.beperrmessage);

3624: arp_standard.debug('Apply: ' || 'l_reqresp_rec.response.errcode: ' || l_reqresp_rec.response.errcode);
3625: arp_standard.debug('Apply: ' || 'l_reqresp_rec.response.errmessage: ' || l_reqresp_rec.response.errmessage);
3626: arp_standard.debug('Apply: ' || 'l_reqresp_rec.errorlocation: ' || l_reqresp_rec.errorlocation);
3627: arp_standard.debug('Apply: ' || 'l_reqresp_rec.beperrcode: ' || l_reqresp_rec.beperrcode);
3628: arp_standard.debug('Apply: ' || 'l_reqresp_rec.beperrmessage: ' || l_reqresp_rec.beperrmessage);
3629: arp_standard.debug('Apply: ' || 'NVL(l_reqresp_rec.response.status,0): ' || to_char(NVL(l_reqresp_rec.response.status,0)));
3630: arp_standard.debug('Apply: ' || 'Authcode: ' || l_reqresp_rec.authcode);
3631: arp_standard.debug('Apply: ' || 'Trxn ID: ' || l_reqresp_rec.Trxn_ID);
3632: arp_standard.debug('Apply: ' || '-------------------------------------');

Line 3629: arp_standard.debug('Apply: ' || 'NVL(l_reqresp_rec.response.status,0): ' || to_char(NVL(l_reqresp_rec.response.status,0)));

3625: arp_standard.debug('Apply: ' || 'l_reqresp_rec.response.errmessage: ' || l_reqresp_rec.response.errmessage);
3626: arp_standard.debug('Apply: ' || 'l_reqresp_rec.errorlocation: ' || l_reqresp_rec.errorlocation);
3627: arp_standard.debug('Apply: ' || 'l_reqresp_rec.beperrcode: ' || l_reqresp_rec.beperrcode);
3628: arp_standard.debug('Apply: ' || 'l_reqresp_rec.beperrmessage: ' || l_reqresp_rec.beperrmessage);
3629: arp_standard.debug('Apply: ' || 'NVL(l_reqresp_rec.response.status,0): ' || to_char(NVL(l_reqresp_rec.response.status,0)));
3630: arp_standard.debug('Apply: ' || 'Authcode: ' || l_reqresp_rec.authcode);
3631: arp_standard.debug('Apply: ' || 'Trxn ID: ' || l_reqresp_rec.Trxn_ID);
3632: arp_standard.debug('Apply: ' || '-------------------------------------');
3633: END IF;

Line 3630: arp_standard.debug('Apply: ' || 'Authcode: ' || l_reqresp_rec.authcode);

3626: arp_standard.debug('Apply: ' || 'l_reqresp_rec.errorlocation: ' || l_reqresp_rec.errorlocation);
3627: arp_standard.debug('Apply: ' || 'l_reqresp_rec.beperrcode: ' || l_reqresp_rec.beperrcode);
3628: arp_standard.debug('Apply: ' || 'l_reqresp_rec.beperrmessage: ' || l_reqresp_rec.beperrmessage);
3629: arp_standard.debug('Apply: ' || 'NVL(l_reqresp_rec.response.status,0): ' || to_char(NVL(l_reqresp_rec.response.status,0)));
3630: arp_standard.debug('Apply: ' || 'Authcode: ' || l_reqresp_rec.authcode);
3631: arp_standard.debug('Apply: ' || 'Trxn ID: ' || l_reqresp_rec.Trxn_ID);
3632: arp_standard.debug('Apply: ' || '-------------------------------------');
3633: END IF;
3634:

Line 3631: arp_standard.debug('Apply: ' || 'Trxn ID: ' || l_reqresp_rec.Trxn_ID);

3627: arp_standard.debug('Apply: ' || 'l_reqresp_rec.beperrcode: ' || l_reqresp_rec.beperrcode);
3628: arp_standard.debug('Apply: ' || 'l_reqresp_rec.beperrmessage: ' || l_reqresp_rec.beperrmessage);
3629: arp_standard.debug('Apply: ' || 'NVL(l_reqresp_rec.response.status,0): ' || to_char(NVL(l_reqresp_rec.response.status,0)));
3630: arp_standard.debug('Apply: ' || 'Authcode: ' || l_reqresp_rec.authcode);
3631: arp_standard.debug('Apply: ' || 'Trxn ID: ' || l_reqresp_rec.Trxn_ID);
3632: arp_standard.debug('Apply: ' || '-------------------------------------');
3633: END IF;
3634:
3635: -- check if call was successful

Line 3632: arp_standard.debug('Apply: ' || '-------------------------------------');

3628: arp_standard.debug('Apply: ' || 'l_reqresp_rec.beperrmessage: ' || l_reqresp_rec.beperrmessage);
3629: arp_standard.debug('Apply: ' || 'NVL(l_reqresp_rec.response.status,0): ' || to_char(NVL(l_reqresp_rec.response.status,0)));
3630: arp_standard.debug('Apply: ' || 'Authcode: ' || l_reqresp_rec.authcode);
3631: arp_standard.debug('Apply: ' || 'Trxn ID: ' || l_reqresp_rec.Trxn_ID);
3632: arp_standard.debug('Apply: ' || '-------------------------------------');
3633: END IF;
3634:
3635: -- check if call was successful
3636: --Add message to message stack only it it is called from iReceivables

Line 3641: arp_standard.debug('Apply: ' || 'l_MSG_COUNT=>'||to_char(l_MSG_COUNT));

3637: --if not pass the message stack received from iPayment
3638:
3639: IF (NVL(p_called_from,'NONE') = 'IREC') THEN
3640: IF PG_DEBUG in ('Y', 'C') THEN
3641: arp_standard.debug('Apply: ' || 'l_MSG_COUNT=>'||to_char(l_MSG_COUNT));
3642: END IF;
3643: fnd_msg_pub.dump_list;
3644: IF PG_DEBUG in ('Y', 'C') THEN
3645: arp_standard.debug('Apply: ' || 'Errors: ');

Line 3645: arp_standard.debug('Apply: ' || 'Errors: ');

3641: arp_standard.debug('Apply: ' || 'l_MSG_COUNT=>'||to_char(l_MSG_COUNT));
3642: END IF;
3643: fnd_msg_pub.dump_list;
3644: IF PG_DEBUG in ('Y', 'C') THEN
3645: arp_standard.debug('Apply: ' || 'Errors: ');
3646: END IF;
3647: IF(l_MSG_COUNT=1) THEN
3648: IF PG_DEBUG in ('Y', 'C') THEN
3649: arp_standard.debug('Apply: ' || l_MSG_DATA);

Line 3649: arp_standard.debug('Apply: ' || l_MSG_DATA);

3645: arp_standard.debug('Apply: ' || 'Errors: ');
3646: END IF;
3647: IF(l_MSG_COUNT=1) THEN
3648: IF PG_DEBUG in ('Y', 'C') THEN
3649: arp_standard.debug('Apply: ' || l_MSG_DATA);
3650: END IF;
3651: ELSIF(l_MSG_COUNT>1)THEN
3652: LOOP
3653: l_MSG_DATA:=FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);

Line 3658: arp_standard.debug('Apply: ' || l_MSG_DATA);

3654: IF (l_MSG_DATA IS NULL)THEN
3655: EXIT;
3656: END IF;
3657: IF PG_DEBUG in ('Y', 'C') THEN
3658: arp_standard.debug('Apply: ' || l_MSG_DATA);
3659: END IF;
3660: END LOOP;
3661: END IF;
3662: END IF;

Line 3690: arp_standard.debug('Apply: ' || 'CR rec updated with payment server auth code');

3686: l_cr_rec.payment_server_order_num := l_tangible_rec.tangible_id;
3687: ARP_CASH_RECEIPTS_PKG.update_p(l_cr_rec, p_cash_receipt_id);
3688:
3689: IF PG_DEBUG in ('Y', 'C') THEN
3690: arp_standard.debug('Apply: ' || 'CR rec updated with payment server auth code');
3691: END IF;
3692:
3693: -- see if capture is also required
3694:

Line 3698: arp_standard.debug('Apply: ' || 'starting capture...');

3694:
3695: if (l_action = 'AUTHANDCAPTURE') then
3696:
3697: IF PG_DEBUG in ('Y', 'C') THEN
3698: arp_standard.debug('Apply: ' || 'starting capture...');
3699: END IF;
3700:
3701: -- Step 2: (optional): capture funds
3702:

Line 3728: arp_standard.debug('Apply: ' || 'l_return_status: ' || l_return_status);

3724: p_capturetrxn_rec => l_capturetrxn_rec,
3725: x_capresp_rec => l_capresp_rec);
3726:
3727: IF PG_DEBUG in ('Y', 'C') THEN
3728: arp_standard.debug('Apply: ' || 'l_return_status: ' || l_return_status);
3729: END IF;
3730:
3731: x_msg_count := l_msg_count;
3732: x_msg_data := l_msg_data;

Line 3737: arp_standard.debug('Apply: ' || 'l_MSG_COUNT=>'||to_char(l_MSG_COUNT));

3733: p_response_error_code := l_capresp_rec.response.errcode;
3734:
3735: IF (NVL(p_called_from,'NONE') = 'IREC') THEN
3736: IF PG_DEBUG in ('Y', 'C') THEN
3737: arp_standard.debug('Apply: ' || 'l_MSG_COUNT=>'||to_char(l_MSG_COUNT));
3738: END IF;
3739: fnd_msg_pub.dump_list;
3740: IF PG_DEBUG in ('Y', 'C') THEN
3741: arp_standard.debug('Apply: ' || 'Errors: ');

Line 3741: arp_standard.debug('Apply: ' || 'Errors: ');

3737: arp_standard.debug('Apply: ' || 'l_MSG_COUNT=>'||to_char(l_MSG_COUNT));
3738: END IF;
3739: fnd_msg_pub.dump_list;
3740: IF PG_DEBUG in ('Y', 'C') THEN
3741: arp_standard.debug('Apply: ' || 'Errors: ');
3742: END IF;
3743: IF(l_MSG_COUNT=1) THEN
3744: IF PG_DEBUG in ('Y', 'C') THEN
3745: arp_standard.debug('Apply: ' || l_MSG_DATA);

Line 3745: arp_standard.debug('Apply: ' || l_MSG_DATA);

3741: arp_standard.debug('Apply: ' || 'Errors: ');
3742: END IF;
3743: IF(l_MSG_COUNT=1) THEN
3744: IF PG_DEBUG in ('Y', 'C') THEN
3745: arp_standard.debug('Apply: ' || l_MSG_DATA);
3746: END IF;
3747: ELSIF(l_MSG_COUNT>1)THEN
3748: LOOP
3749: l_MSG_DATA:=FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);

Line 3754: arp_standard.debug('Apply: ' || l_MSG_DATA);

3750: IF (l_MSG_DATA IS NULL)THEN
3751: EXIT;
3752: END IF;
3753: IF PG_DEBUG in ('Y', 'C') THEN
3754: arp_standard.debug('Apply: ' || l_MSG_DATA);
3755: END IF;
3756: END LOOP;
3757: END IF;
3758: END IF;

Line 3761: arp_standard.debug('Apply: ' || '-------------------------------------');

3757: END IF;
3758: END IF;
3759:
3760: IF PG_DEBUG in ('Y', 'C') THEN
3761: arp_standard.debug('Apply: ' || '-------------------------------------');
3762: arp_standard.debug('Apply: ' || 'l_capresp_rec.response.errcode: ' || l_capresp_rec.response.errcode);
3763: arp_standard.debug('Apply: ' || 'l_capresp_rec.response.errmessage: ' || l_capresp_rec.response.errmessage);
3764: arp_standard.debug('Apply: ' || 'l_capresp_rec.errorlocation: ' || l_capresp_rec.errorlocation);
3765: arp_standard.debug('Apply: ' || 'l_capresp_rec.beperrcode: ' || l_capresp_rec.beperrcode);

Line 3762: arp_standard.debug('Apply: ' || 'l_capresp_rec.response.errcode: ' || l_capresp_rec.response.errcode);

3758: END IF;
3759:
3760: IF PG_DEBUG in ('Y', 'C') THEN
3761: arp_standard.debug('Apply: ' || '-------------------------------------');
3762: arp_standard.debug('Apply: ' || 'l_capresp_rec.response.errcode: ' || l_capresp_rec.response.errcode);
3763: arp_standard.debug('Apply: ' || 'l_capresp_rec.response.errmessage: ' || l_capresp_rec.response.errmessage);
3764: arp_standard.debug('Apply: ' || 'l_capresp_rec.errorlocation: ' || l_capresp_rec.errorlocation);
3765: arp_standard.debug('Apply: ' || 'l_capresp_rec.beperrcode: ' || l_capresp_rec.beperrcode);
3766: arp_standard.debug('Apply: ' || 'l_capresp_rec.beperrmessage: ' || l_capresp_rec.beperrmessage);

Line 3763: arp_standard.debug('Apply: ' || 'l_capresp_rec.response.errmessage: ' || l_capresp_rec.response.errmessage);

3759:
3760: IF PG_DEBUG in ('Y', 'C') THEN
3761: arp_standard.debug('Apply: ' || '-------------------------------------');
3762: arp_standard.debug('Apply: ' || 'l_capresp_rec.response.errcode: ' || l_capresp_rec.response.errcode);
3763: arp_standard.debug('Apply: ' || 'l_capresp_rec.response.errmessage: ' || l_capresp_rec.response.errmessage);
3764: arp_standard.debug('Apply: ' || 'l_capresp_rec.errorlocation: ' || l_capresp_rec.errorlocation);
3765: arp_standard.debug('Apply: ' || 'l_capresp_rec.beperrcode: ' || l_capresp_rec.beperrcode);
3766: arp_standard.debug('Apply: ' || 'l_capresp_rec.beperrmessage: ' || l_capresp_rec.beperrmessage);
3767: arp_standard.debug('Apply: ' || 'NVL(l_capresp_rec.response.status,0): ' || to_char(NVL(l_capresp_rec.response.status,0)));

Line 3764: arp_standard.debug('Apply: ' || 'l_capresp_rec.errorlocation: ' || l_capresp_rec.errorlocation);

3760: IF PG_DEBUG in ('Y', 'C') THEN
3761: arp_standard.debug('Apply: ' || '-------------------------------------');
3762: arp_standard.debug('Apply: ' || 'l_capresp_rec.response.errcode: ' || l_capresp_rec.response.errcode);
3763: arp_standard.debug('Apply: ' || 'l_capresp_rec.response.errmessage: ' || l_capresp_rec.response.errmessage);
3764: arp_standard.debug('Apply: ' || 'l_capresp_rec.errorlocation: ' || l_capresp_rec.errorlocation);
3765: arp_standard.debug('Apply: ' || 'l_capresp_rec.beperrcode: ' || l_capresp_rec.beperrcode);
3766: arp_standard.debug('Apply: ' || 'l_capresp_rec.beperrmessage: ' || l_capresp_rec.beperrmessage);
3767: arp_standard.debug('Apply: ' || 'NVL(l_capresp_rec.response.status,0): ' || to_char(NVL(l_capresp_rec.response.status,0)));
3768: arp_standard.debug('Apply: ' || 'PmtInstr_Type: ' || l_capresp_rec.PmtInstr_Type);

Line 3765: arp_standard.debug('Apply: ' || 'l_capresp_rec.beperrcode: ' || l_capresp_rec.beperrcode);

3761: arp_standard.debug('Apply: ' || '-------------------------------------');
3762: arp_standard.debug('Apply: ' || 'l_capresp_rec.response.errcode: ' || l_capresp_rec.response.errcode);
3763: arp_standard.debug('Apply: ' || 'l_capresp_rec.response.errmessage: ' || l_capresp_rec.response.errmessage);
3764: arp_standard.debug('Apply: ' || 'l_capresp_rec.errorlocation: ' || l_capresp_rec.errorlocation);
3765: arp_standard.debug('Apply: ' || 'l_capresp_rec.beperrcode: ' || l_capresp_rec.beperrcode);
3766: arp_standard.debug('Apply: ' || 'l_capresp_rec.beperrmessage: ' || l_capresp_rec.beperrmessage);
3767: arp_standard.debug('Apply: ' || 'NVL(l_capresp_rec.response.status,0): ' || to_char(NVL(l_capresp_rec.response.status,0)));
3768: arp_standard.debug('Apply: ' || 'PmtInstr_Type: ' || l_capresp_rec.PmtInstr_Type);
3769: arp_standard.debug('Apply: ' || 'Trxn ID: ' || l_capresp_rec.Trxn_ID);

Line 3766: arp_standard.debug('Apply: ' || 'l_capresp_rec.beperrmessage: ' || l_capresp_rec.beperrmessage);

3762: arp_standard.debug('Apply: ' || 'l_capresp_rec.response.errcode: ' || l_capresp_rec.response.errcode);
3763: arp_standard.debug('Apply: ' || 'l_capresp_rec.response.errmessage: ' || l_capresp_rec.response.errmessage);
3764: arp_standard.debug('Apply: ' || 'l_capresp_rec.errorlocation: ' || l_capresp_rec.errorlocation);
3765: arp_standard.debug('Apply: ' || 'l_capresp_rec.beperrcode: ' || l_capresp_rec.beperrcode);
3766: arp_standard.debug('Apply: ' || 'l_capresp_rec.beperrmessage: ' || l_capresp_rec.beperrmessage);
3767: arp_standard.debug('Apply: ' || 'NVL(l_capresp_rec.response.status,0): ' || to_char(NVL(l_capresp_rec.response.status,0)));
3768: arp_standard.debug('Apply: ' || 'PmtInstr_Type: ' || l_capresp_rec.PmtInstr_Type);
3769: arp_standard.debug('Apply: ' || 'Trxn ID: ' || l_capresp_rec.Trxn_ID);
3770: arp_standard.debug('Apply: ' || '-------------------------------------');

Line 3767: arp_standard.debug('Apply: ' || 'NVL(l_capresp_rec.response.status,0): ' || to_char(NVL(l_capresp_rec.response.status,0)));

3763: arp_standard.debug('Apply: ' || 'l_capresp_rec.response.errmessage: ' || l_capresp_rec.response.errmessage);
3764: arp_standard.debug('Apply: ' || 'l_capresp_rec.errorlocation: ' || l_capresp_rec.errorlocation);
3765: arp_standard.debug('Apply: ' || 'l_capresp_rec.beperrcode: ' || l_capresp_rec.beperrcode);
3766: arp_standard.debug('Apply: ' || 'l_capresp_rec.beperrmessage: ' || l_capresp_rec.beperrmessage);
3767: arp_standard.debug('Apply: ' || 'NVL(l_capresp_rec.response.status,0): ' || to_char(NVL(l_capresp_rec.response.status,0)));
3768: arp_standard.debug('Apply: ' || 'PmtInstr_Type: ' || l_capresp_rec.PmtInstr_Type);
3769: arp_standard.debug('Apply: ' || 'Trxn ID: ' || l_capresp_rec.Trxn_ID);
3770: arp_standard.debug('Apply: ' || '-------------------------------------');
3771: END IF;

Line 3768: arp_standard.debug('Apply: ' || 'PmtInstr_Type: ' || l_capresp_rec.PmtInstr_Type);

3764: arp_standard.debug('Apply: ' || 'l_capresp_rec.errorlocation: ' || l_capresp_rec.errorlocation);
3765: arp_standard.debug('Apply: ' || 'l_capresp_rec.beperrcode: ' || l_capresp_rec.beperrcode);
3766: arp_standard.debug('Apply: ' || 'l_capresp_rec.beperrmessage: ' || l_capresp_rec.beperrmessage);
3767: arp_standard.debug('Apply: ' || 'NVL(l_capresp_rec.response.status,0): ' || to_char(NVL(l_capresp_rec.response.status,0)));
3768: arp_standard.debug('Apply: ' || 'PmtInstr_Type: ' || l_capresp_rec.PmtInstr_Type);
3769: arp_standard.debug('Apply: ' || 'Trxn ID: ' || l_capresp_rec.Trxn_ID);
3770: arp_standard.debug('Apply: ' || '-------------------------------------');
3771: END IF;
3772:

Line 3769: arp_standard.debug('Apply: ' || 'Trxn ID: ' || l_capresp_rec.Trxn_ID);

3765: arp_standard.debug('Apply: ' || 'l_capresp_rec.beperrcode: ' || l_capresp_rec.beperrcode);
3766: arp_standard.debug('Apply: ' || 'l_capresp_rec.beperrmessage: ' || l_capresp_rec.beperrmessage);
3767: arp_standard.debug('Apply: ' || 'NVL(l_capresp_rec.response.status,0): ' || to_char(NVL(l_capresp_rec.response.status,0)));
3768: arp_standard.debug('Apply: ' || 'PmtInstr_Type: ' || l_capresp_rec.PmtInstr_Type);
3769: arp_standard.debug('Apply: ' || 'Trxn ID: ' || l_capresp_rec.Trxn_ID);
3770: arp_standard.debug('Apply: ' || '-------------------------------------');
3771: END IF;
3772:
3773: --Add message to message stack only it it is called from iReceivables

Line 3770: arp_standard.debug('Apply: ' || '-------------------------------------');

3766: arp_standard.debug('Apply: ' || 'l_capresp_rec.beperrmessage: ' || l_capresp_rec.beperrmessage);
3767: arp_standard.debug('Apply: ' || 'NVL(l_capresp_rec.response.status,0): ' || to_char(NVL(l_capresp_rec.response.status,0)));
3768: arp_standard.debug('Apply: ' || 'PmtInstr_Type: ' || l_capresp_rec.PmtInstr_Type);
3769: arp_standard.debug('Apply: ' || 'Trxn ID: ' || l_capresp_rec.Trxn_ID);
3770: arp_standard.debug('Apply: ' || '-------------------------------------');
3771: END IF;
3772:
3773: --Add message to message stack only it it is called from iReceivables
3774: --if not pass the message stack received from iPayment

Line 3791: arp_standard.debug('Apply: ' || 'credit card bank branch is not 1 --> no CC acct');

3787:
3788: ELSE
3789:
3790: IF PG_DEBUG in ('Y', 'C') THEN
3791: arp_standard.debug('Apply: ' || 'credit card bank branch is not 1 --> no CC acct');
3792: END IF;
3793:
3794: -- currently no processing required
3795:

Line 3903: arp_standard.debug( 'Entering payment processing...');

3899: BEGIN
3900:
3901:
3902: IF PG_DEBUG in ('Y', 'C') THEN
3903: arp_standard.debug( 'Entering payment processing...');
3904: END IF;
3905:
3906:
3907: OPEN rct_info_cur;

Line 3920: arp_standard.debug('Apply: ' || 'ERROR: Creation status is ' || rct_info.creation_status);

3916: elsif rct_info.creation_status = 'CONFIRMED' THEN
3917: l_action := 'AUTHONLY';
3918: else
3919: IF PG_DEBUG in ('Y', 'C') THEN
3920: arp_standard.debug('Apply: ' || 'ERROR: Creation status is ' || rct_info.creation_status);
3921: END IF;
3922:
3923: FND_MESSAGE.set_name('AR', 'AR_PAY_PROCESS_INVALID_STATUS');
3924: FND_MSG_PUB.Add;

Line 3959: l_trxn_attribs_rec.Originating_Application_Id := arp_standard.application_id;

3955: -- set up auth_attribs record:
3956: l_auth_attribs_rec.RiskEval_Enable_Flag := 'N';
3957:
3958: -- set up trxn_attribs record:
3959: l_trxn_attribs_rec.Originating_Application_Id := arp_standard.application_id;
3960: l_trxn_attribs_rec.order_id := rct_info.receipt_number;
3961: l_trxn_attribs_rec.Trxn_Ref_Number1 := 'RECEIPT';
3962: l_trxn_attribs_rec.Trxn_Ref_Number2 := p_cash_receipt_id;
3963:

Line 3974: arp_standard.debug( 'check and then call Auth');

3970: lcr_receipt_attr.settlement_date := rct_info.receipt_date;
3971:
3972:
3973: IF PG_DEBUG in ('Y', 'C') THEN
3974: arp_standard.debug( 'check and then call Auth');
3975: END IF;
3976:
3977: -- determine whether to AUTHORIZE
3978:

Line 3984: arp_standard.debug( 'Calling get auth for pmt_trxn_extn_id ');

3980:
3981: l_trxn_entity_id := rct_info.payment_trxn_extension_id;
3982:
3983: IF PG_DEBUG in ('Y', 'C') THEN
3984: arp_standard.debug( 'Calling get auth for pmt_trxn_extn_id ');
3985: arp_standard.debug( 'l_trxn_entity_id ' || to_char(l_trxn_entity_id ) );
3986:
3987: END IF;
3988:

Line 3985: arp_standard.debug( 'l_trxn_entity_id ' || to_char(l_trxn_entity_id ) );

3981: l_trxn_entity_id := rct_info.payment_trxn_extension_id;
3982:
3983: IF PG_DEBUG in ('Y', 'C') THEN
3984: arp_standard.debug( 'Calling get auth for pmt_trxn_extn_id ');
3985: arp_standard.debug( 'l_trxn_entity_id ' || to_char(l_trxn_entity_id ) );
3986:
3987: END IF;
3988:
3989: Begin

Line 4011: arp_standard.debug ( 'the value of auth_flag is = ' || l_auth_flag);

4007: when others then
4008: l_auth_flag := 'N';
4009: End;
4010:
4011: arp_standard.debug ( 'the value of auth_flag is = ' || l_auth_flag);
4012:
4013: If l_auth_flag = 'Y' then
4014:
4015: select AUTHORIZATION_ID

Line 4020: arp_standard.debug ( 'the value of auth_id is = ' || l_auth_id);

4016: into l_auth_id
4017: from IBY_TRXN_EXT_AUTHS_V
4018: where TRXN_EXTENSION_ID = p_payment_trxn_extension_id;
4019:
4020: arp_standard.debug ( 'the value of auth_id is = ' || l_auth_id);
4021:
4022: ARP_CASH_RECEIPTS_PKG.set_to_dummy(l_cr_rec);
4023:
4024: l_cr_rec.approval_code := 'AR'||to_char(l_auth_Id);

Line 4028: arp_standard.debug('CR rec updated with auth_id and auth code ');

4024: l_cr_rec.approval_code := 'AR'||to_char(l_auth_Id);
4025:
4026: ARP_CASH_RECEIPTS_PKG.update_p(l_cr_rec, p_cash_receipt_id);
4027:
4028: arp_standard.debug('CR rec updated with auth_id and auth code ');
4029: end if;
4030:
4031:
4032:

Line 4035: arp_standard.debug('auth needs to called');

4031:
4032:
4033:
4034: IF l_auth_flag <> 'Y' then
4035: arp_standard.debug('auth needs to called');
4036:
4037: IF PG_DEBUG in ('Y', 'C') THEN
4038: arp_standard.debug( 'Calling get auth for pmt_trxn_extn_id ');
4039: arp_standard.debug( ' l_payee_rec.org_id ' || to_char(l_payee_rec.org_id) );

Line 4038: arp_standard.debug( 'Calling get auth for pmt_trxn_extn_id ');

4034: IF l_auth_flag <> 'Y' then
4035: arp_standard.debug('auth needs to called');
4036:
4037: IF PG_DEBUG in ('Y', 'C') THEN
4038: arp_standard.debug( 'Calling get auth for pmt_trxn_extn_id ');
4039: arp_standard.debug( ' l_payee_rec.org_id ' || to_char(l_payee_rec.org_id) );
4040: arp_standard.debug( ' l_payee_rec.org_type ' || to_char( l_payee_rec.org_type) );
4041: arp_standard.debug( ' l_payer_rec.Payment_Function ' || to_char( l_payer_rec.Payment_Function) );
4042: arp_standard.debug( ' l_payer_rec.Party_Id ' || to_char( l_payer_rec.Party_Id) );

Line 4039: arp_standard.debug( ' l_payee_rec.org_id ' || to_char(l_payee_rec.org_id) );

4035: arp_standard.debug('auth needs to called');
4036:
4037: IF PG_DEBUG in ('Y', 'C') THEN
4038: arp_standard.debug( 'Calling get auth for pmt_trxn_extn_id ');
4039: arp_standard.debug( ' l_payee_rec.org_id ' || to_char(l_payee_rec.org_id) );
4040: arp_standard.debug( ' l_payee_rec.org_type ' || to_char( l_payee_rec.org_type) );
4041: arp_standard.debug( ' l_payer_rec.Payment_Function ' || to_char( l_payer_rec.Payment_Function) );
4042: arp_standard.debug( ' l_payer_rec.Party_Id ' || to_char( l_payer_rec.Party_Id) );
4043: arp_standard.debug( ' l_payer_rec.org_id ' || to_char(l_payer_rec.org_id) );

Line 4040: arp_standard.debug( ' l_payee_rec.org_type ' || to_char( l_payee_rec.org_type) );

4036:
4037: IF PG_DEBUG in ('Y', 'C') THEN
4038: arp_standard.debug( 'Calling get auth for pmt_trxn_extn_id ');
4039: arp_standard.debug( ' l_payee_rec.org_id ' || to_char(l_payee_rec.org_id) );
4040: arp_standard.debug( ' l_payee_rec.org_type ' || to_char( l_payee_rec.org_type) );
4041: arp_standard.debug( ' l_payer_rec.Payment_Function ' || to_char( l_payer_rec.Payment_Function) );
4042: arp_standard.debug( ' l_payer_rec.Party_Id ' || to_char( l_payer_rec.Party_Id) );
4043: arp_standard.debug( ' l_payer_rec.org_id ' || to_char(l_payer_rec.org_id) );
4044: arp_standard.debug( ' l_payer_rec.org_type ' || to_char( l_payer_rec.org_type) );

Line 4041: arp_standard.debug( ' l_payer_rec.Payment_Function ' || to_char( l_payer_rec.Payment_Function) );

4037: IF PG_DEBUG in ('Y', 'C') THEN
4038: arp_standard.debug( 'Calling get auth for pmt_trxn_extn_id ');
4039: arp_standard.debug( ' l_payee_rec.org_id ' || to_char(l_payee_rec.org_id) );
4040: arp_standard.debug( ' l_payee_rec.org_type ' || to_char( l_payee_rec.org_type) );
4041: arp_standard.debug( ' l_payer_rec.Payment_Function ' || to_char( l_payer_rec.Payment_Function) );
4042: arp_standard.debug( ' l_payer_rec.Party_Id ' || to_char( l_payer_rec.Party_Id) );
4043: arp_standard.debug( ' l_payer_rec.org_id ' || to_char(l_payer_rec.org_id) );
4044: arp_standard.debug( ' l_payer_rec.org_type ' || to_char( l_payer_rec.org_type) );
4045: arp_standard.debug( 'l_payer_rec.Cust_Account_Id ' || to_char(l_payer_rec.Cust_Account_Id) );

Line 4042: arp_standard.debug( ' l_payer_rec.Party_Id ' || to_char( l_payer_rec.Party_Id) );

4038: arp_standard.debug( 'Calling get auth for pmt_trxn_extn_id ');
4039: arp_standard.debug( ' l_payee_rec.org_id ' || to_char(l_payee_rec.org_id) );
4040: arp_standard.debug( ' l_payee_rec.org_type ' || to_char( l_payee_rec.org_type) );
4041: arp_standard.debug( ' l_payer_rec.Payment_Function ' || to_char( l_payer_rec.Payment_Function) );
4042: arp_standard.debug( ' l_payer_rec.Party_Id ' || to_char( l_payer_rec.Party_Id) );
4043: arp_standard.debug( ' l_payer_rec.org_id ' || to_char(l_payer_rec.org_id) );
4044: arp_standard.debug( ' l_payer_rec.org_type ' || to_char( l_payer_rec.org_type) );
4045: arp_standard.debug( 'l_payer_rec.Cust_Account_Id ' || to_char(l_payer_rec.Cust_Account_Id) );
4046: arp_standard.debug( 'l_payer_rec.Account_Site_Id ' || to_char(l_payer_rec.Account_Site_Id) );

Line 4043: arp_standard.debug( ' l_payer_rec.org_id ' || to_char(l_payer_rec.org_id) );

4039: arp_standard.debug( ' l_payee_rec.org_id ' || to_char(l_payee_rec.org_id) );
4040: arp_standard.debug( ' l_payee_rec.org_type ' || to_char( l_payee_rec.org_type) );
4041: arp_standard.debug( ' l_payer_rec.Payment_Function ' || to_char( l_payer_rec.Payment_Function) );
4042: arp_standard.debug( ' l_payer_rec.Party_Id ' || to_char( l_payer_rec.Party_Id) );
4043: arp_standard.debug( ' l_payer_rec.org_id ' || to_char(l_payer_rec.org_id) );
4044: arp_standard.debug( ' l_payer_rec.org_type ' || to_char( l_payer_rec.org_type) );
4045: arp_standard.debug( 'l_payer_rec.Cust_Account_Id ' || to_char(l_payer_rec.Cust_Account_Id) );
4046: arp_standard.debug( 'l_payer_rec.Account_Site_Id ' || to_char(l_payer_rec.Account_Site_Id) );
4047: arp_standard.debug( 'l_trxn_entity_id ' || to_char(l_trxn_entity_id ) );

Line 4044: arp_standard.debug( ' l_payer_rec.org_type ' || to_char( l_payer_rec.org_type) );

4040: arp_standard.debug( ' l_payee_rec.org_type ' || to_char( l_payee_rec.org_type) );
4041: arp_standard.debug( ' l_payer_rec.Payment_Function ' || to_char( l_payer_rec.Payment_Function) );
4042: arp_standard.debug( ' l_payer_rec.Party_Id ' || to_char( l_payer_rec.Party_Id) );
4043: arp_standard.debug( ' l_payer_rec.org_id ' || to_char(l_payer_rec.org_id) );
4044: arp_standard.debug( ' l_payer_rec.org_type ' || to_char( l_payer_rec.org_type) );
4045: arp_standard.debug( 'l_payer_rec.Cust_Account_Id ' || to_char(l_payer_rec.Cust_Account_Id) );
4046: arp_standard.debug( 'l_payer_rec.Account_Site_Id ' || to_char(l_payer_rec.Account_Site_Id) );
4047: arp_standard.debug( 'l_trxn_entity_id ' || to_char(l_trxn_entity_id ) );
4048: arp_standard.debug( 'l_amount_rec.value: ' || to_char(l_amount_rec.value) );

Line 4045: arp_standard.debug( 'l_payer_rec.Cust_Account_Id ' || to_char(l_payer_rec.Cust_Account_Id) );

4041: arp_standard.debug( ' l_payer_rec.Payment_Function ' || to_char( l_payer_rec.Payment_Function) );
4042: arp_standard.debug( ' l_payer_rec.Party_Id ' || to_char( l_payer_rec.Party_Id) );
4043: arp_standard.debug( ' l_payer_rec.org_id ' || to_char(l_payer_rec.org_id) );
4044: arp_standard.debug( ' l_payer_rec.org_type ' || to_char( l_payer_rec.org_type) );
4045: arp_standard.debug( 'l_payer_rec.Cust_Account_Id ' || to_char(l_payer_rec.Cust_Account_Id) );
4046: arp_standard.debug( 'l_payer_rec.Account_Site_Id ' || to_char(l_payer_rec.Account_Site_Id) );
4047: arp_standard.debug( 'l_trxn_entity_id ' || to_char(l_trxn_entity_id ) );
4048: arp_standard.debug( 'l_amount_rec.value: ' || to_char(l_amount_rec.value) );
4049: arp_standard.debug( 'l_amount_rec.currency_code: ' || l_amount_rec.currency_code );

Line 4046: arp_standard.debug( 'l_payer_rec.Account_Site_Id ' || to_char(l_payer_rec.Account_Site_Id) );

4042: arp_standard.debug( ' l_payer_rec.Party_Id ' || to_char( l_payer_rec.Party_Id) );
4043: arp_standard.debug( ' l_payer_rec.org_id ' || to_char(l_payer_rec.org_id) );
4044: arp_standard.debug( ' l_payer_rec.org_type ' || to_char( l_payer_rec.org_type) );
4045: arp_standard.debug( 'l_payer_rec.Cust_Account_Id ' || to_char(l_payer_rec.Cust_Account_Id) );
4046: arp_standard.debug( 'l_payer_rec.Account_Site_Id ' || to_char(l_payer_rec.Account_Site_Id) );
4047: arp_standard.debug( 'l_trxn_entity_id ' || to_char(l_trxn_entity_id ) );
4048: arp_standard.debug( 'l_amount_rec.value: ' || to_char(l_amount_rec.value) );
4049: arp_standard.debug( 'l_amount_rec.currency_code: ' || l_amount_rec.currency_code );
4050:

Line 4047: arp_standard.debug( 'l_trxn_entity_id ' || to_char(l_trxn_entity_id ) );

4043: arp_standard.debug( ' l_payer_rec.org_id ' || to_char(l_payer_rec.org_id) );
4044: arp_standard.debug( ' l_payer_rec.org_type ' || to_char( l_payer_rec.org_type) );
4045: arp_standard.debug( 'l_payer_rec.Cust_Account_Id ' || to_char(l_payer_rec.Cust_Account_Id) );
4046: arp_standard.debug( 'l_payer_rec.Account_Site_Id ' || to_char(l_payer_rec.Account_Site_Id) );
4047: arp_standard.debug( 'l_trxn_entity_id ' || to_char(l_trxn_entity_id ) );
4048: arp_standard.debug( 'l_amount_rec.value: ' || to_char(l_amount_rec.value) );
4049: arp_standard.debug( 'l_amount_rec.currency_code: ' || l_amount_rec.currency_code );
4050:
4051: arp_standard.debug( 'Calling get_auth for pmt_trxn_extn_id ');

Line 4048: arp_standard.debug( 'l_amount_rec.value: ' || to_char(l_amount_rec.value) );

4044: arp_standard.debug( ' l_payer_rec.org_type ' || to_char( l_payer_rec.org_type) );
4045: arp_standard.debug( 'l_payer_rec.Cust_Account_Id ' || to_char(l_payer_rec.Cust_Account_Id) );
4046: arp_standard.debug( 'l_payer_rec.Account_Site_Id ' || to_char(l_payer_rec.Account_Site_Id) );
4047: arp_standard.debug( 'l_trxn_entity_id ' || to_char(l_trxn_entity_id ) );
4048: arp_standard.debug( 'l_amount_rec.value: ' || to_char(l_amount_rec.value) );
4049: arp_standard.debug( 'l_amount_rec.currency_code: ' || l_amount_rec.currency_code );
4050:
4051: arp_standard.debug( 'Calling get_auth for pmt_trxn_extn_id ');
4052: END IF;

Line 4049: arp_standard.debug( 'l_amount_rec.currency_code: ' || l_amount_rec.currency_code );

4045: arp_standard.debug( 'l_payer_rec.Cust_Account_Id ' || to_char(l_payer_rec.Cust_Account_Id) );
4046: arp_standard.debug( 'l_payer_rec.Account_Site_Id ' || to_char(l_payer_rec.Account_Site_Id) );
4047: arp_standard.debug( 'l_trxn_entity_id ' || to_char(l_trxn_entity_id ) );
4048: arp_standard.debug( 'l_amount_rec.value: ' || to_char(l_amount_rec.value) );
4049: arp_standard.debug( 'l_amount_rec.currency_code: ' || l_amount_rec.currency_code );
4050:
4051: arp_standard.debug( 'Calling get_auth for pmt_trxn_extn_id ');
4052: END IF;
4053:

Line 4051: arp_standard.debug( 'Calling get_auth for pmt_trxn_extn_id ');

4047: arp_standard.debug( 'l_trxn_entity_id ' || to_char(l_trxn_entity_id ) );
4048: arp_standard.debug( 'l_amount_rec.value: ' || to_char(l_amount_rec.value) );
4049: arp_standard.debug( 'l_amount_rec.currency_code: ' || l_amount_rec.currency_code );
4050:
4051: arp_standard.debug( 'Calling get_auth for pmt_trxn_extn_id ');
4052: END IF;
4053:
4054: BEGIN
4055: IBY_FNDCPT_TRXN_PUB.Create_Authorization(

Line 4071: arp_standard.debug('Exception IBY_FNDCPT_TRXN_PUB.Create_Authorization ');

4067: x_auth_result => l_authresult_rec, -- out auth result struct
4068: x_response => l_response_rec ); -- out response struct
4069: EXCEPTION
4070: WHEN OTHERS THEN
4071: arp_standard.debug('Exception IBY_FNDCPT_TRXN_PUB.Create_Authorization ');
4072: null;
4073: END;
4074:
4075: x_msg_count := l_msg_count;

Line 4079: arp_standard.debug('x_return_status :<' || l_return_status || '>');

4075: x_msg_count := l_msg_count;
4076: x_msg_data := substrb(l_msg_data, 1, 240);
4077:
4078:
4079: arp_standard.debug('x_return_status :<' || l_return_status || '>');
4080: arp_standard.debug('x_msg_count :<' || l_msg_count || '>');
4081:
4082: FOR i IN 1..l_msg_count LOOP
4083: arp_standard.debug('x_msg #' || TO_CHAR(i) || ' = <' ||

Line 4080: arp_standard.debug('x_msg_count :<' || l_msg_count || '>');

4076: x_msg_data := substrb(l_msg_data, 1, 240);
4077:
4078:
4079: arp_standard.debug('x_return_status :<' || l_return_status || '>');
4080: arp_standard.debug('x_msg_count :<' || l_msg_count || '>');
4081:
4082: FOR i IN 1..l_msg_count LOOP
4083: arp_standard.debug('x_msg #' || TO_CHAR(i) || ' = <' ||
4084: SUBSTR(fnd_msg_pub.get(p_msg_index => i,p_encoded => FND_API.G_FALSE),1,150) || '>');

Line 4083: arp_standard.debug('x_msg #' || TO_CHAR(i) || ' = <' ||

4079: arp_standard.debug('x_return_status :<' || l_return_status || '>');
4080: arp_standard.debug('x_msg_count :<' || l_msg_count || '>');
4081:
4082: FOR i IN 1..l_msg_count LOOP
4083: arp_standard.debug('x_msg #' || TO_CHAR(i) || ' = <' ||
4084: SUBSTR(fnd_msg_pub.get(p_msg_index => i,p_encoded => FND_API.G_FALSE),1,150) || '>');
4085: END LOOP;
4086:
4087: IF PG_DEBUG in ('Y', 'C') THEN

Line 4088: arp_standard.debug( '-------------------------------------');

4084: SUBSTR(fnd_msg_pub.get(p_msg_index => i,p_encoded => FND_API.G_FALSE),1,150) || '>');
4085: END LOOP;
4086:
4087: IF PG_DEBUG in ('Y', 'C') THEN
4088: arp_standard.debug( '-------------------------------------');
4089: arp_standard.debug( 'l_response_rec.Result_Code: ' || l_response_rec.Result_Code);
4090: arp_standard.debug( 'l_response_rec.Result_Category: ' || l_response_rec.Result_Category);
4091: arp_standard.debug( 'l_response_rec.Result_message : ' || l_response_rec.Result_message );
4092: arp_standard.debug( 'l_authresult_rec.Auth_Id: ' || l_authresult_rec.Auth_Id);

Line 4089: arp_standard.debug( 'l_response_rec.Result_Code: ' || l_response_rec.Result_Code);

4085: END LOOP;
4086:
4087: IF PG_DEBUG in ('Y', 'C') THEN
4088: arp_standard.debug( '-------------------------------------');
4089: arp_standard.debug( 'l_response_rec.Result_Code: ' || l_response_rec.Result_Code);
4090: arp_standard.debug( 'l_response_rec.Result_Category: ' || l_response_rec.Result_Category);
4091: arp_standard.debug( 'l_response_rec.Result_message : ' || l_response_rec.Result_message );
4092: arp_standard.debug( 'l_authresult_rec.Auth_Id: ' || l_authresult_rec.Auth_Id);
4093: arp_standard.debug( 'l_authresult_rec.Auth_Date: ' || l_authresult_rec.Auth_Date);

Line 4090: arp_standard.debug( 'l_response_rec.Result_Category: ' || l_response_rec.Result_Category);

4086:
4087: IF PG_DEBUG in ('Y', 'C') THEN
4088: arp_standard.debug( '-------------------------------------');
4089: arp_standard.debug( 'l_response_rec.Result_Code: ' || l_response_rec.Result_Code);
4090: arp_standard.debug( 'l_response_rec.Result_Category: ' || l_response_rec.Result_Category);
4091: arp_standard.debug( 'l_response_rec.Result_message : ' || l_response_rec.Result_message );
4092: arp_standard.debug( 'l_authresult_rec.Auth_Id: ' || l_authresult_rec.Auth_Id);
4093: arp_standard.debug( 'l_authresult_rec.Auth_Date: ' || l_authresult_rec.Auth_Date);
4094: arp_standard.debug( 'l_authresult_rec.Auth_Code: ' || l_authresult_rec.Auth_Code);

Line 4091: arp_standard.debug( 'l_response_rec.Result_message : ' || l_response_rec.Result_message );

4087: IF PG_DEBUG in ('Y', 'C') THEN
4088: arp_standard.debug( '-------------------------------------');
4089: arp_standard.debug( 'l_response_rec.Result_Code: ' || l_response_rec.Result_Code);
4090: arp_standard.debug( 'l_response_rec.Result_Category: ' || l_response_rec.Result_Category);
4091: arp_standard.debug( 'l_response_rec.Result_message : ' || l_response_rec.Result_message );
4092: arp_standard.debug( 'l_authresult_rec.Auth_Id: ' || l_authresult_rec.Auth_Id);
4093: arp_standard.debug( 'l_authresult_rec.Auth_Date: ' || l_authresult_rec.Auth_Date);
4094: arp_standard.debug( 'l_authresult_rec.Auth_Code: ' || l_authresult_rec.Auth_Code);
4095: arp_standard.debug( 'l_authresult_rec.AVS_Code: ' || l_authresult_rec.AVS_Code);

Line 4092: arp_standard.debug( 'l_authresult_rec.Auth_Id: ' || l_authresult_rec.Auth_Id);

4088: arp_standard.debug( '-------------------------------------');
4089: arp_standard.debug( 'l_response_rec.Result_Code: ' || l_response_rec.Result_Code);
4090: arp_standard.debug( 'l_response_rec.Result_Category: ' || l_response_rec.Result_Category);
4091: arp_standard.debug( 'l_response_rec.Result_message : ' || l_response_rec.Result_message );
4092: arp_standard.debug( 'l_authresult_rec.Auth_Id: ' || l_authresult_rec.Auth_Id);
4093: arp_standard.debug( 'l_authresult_rec.Auth_Date: ' || l_authresult_rec.Auth_Date);
4094: arp_standard.debug( 'l_authresult_rec.Auth_Code: ' || l_authresult_rec.Auth_Code);
4095: arp_standard.debug( 'l_authresult_rec.AVS_Code: ' || l_authresult_rec.AVS_Code);
4096: arp_standard.debug( 'l_authresult_rec.Instr_SecCode_Check:'|| l_authresult_rec.Instr_SecCode_Check);

Line 4093: arp_standard.debug( 'l_authresult_rec.Auth_Date: ' || l_authresult_rec.Auth_Date);

4089: arp_standard.debug( 'l_response_rec.Result_Code: ' || l_response_rec.Result_Code);
4090: arp_standard.debug( 'l_response_rec.Result_Category: ' || l_response_rec.Result_Category);
4091: arp_standard.debug( 'l_response_rec.Result_message : ' || l_response_rec.Result_message );
4092: arp_standard.debug( 'l_authresult_rec.Auth_Id: ' || l_authresult_rec.Auth_Id);
4093: arp_standard.debug( 'l_authresult_rec.Auth_Date: ' || l_authresult_rec.Auth_Date);
4094: arp_standard.debug( 'l_authresult_rec.Auth_Code: ' || l_authresult_rec.Auth_Code);
4095: arp_standard.debug( 'l_authresult_rec.AVS_Code: ' || l_authresult_rec.AVS_Code);
4096: arp_standard.debug( 'l_authresult_rec.Instr_SecCode_Check:'|| l_authresult_rec.Instr_SecCode_Check);
4097: arp_standard.debug( 'l_authresult_rec.PaymentSys_Code: ' || l_authresult_rec.PaymentSys_Code);

Line 4094: arp_standard.debug( 'l_authresult_rec.Auth_Code: ' || l_authresult_rec.Auth_Code);

4090: arp_standard.debug( 'l_response_rec.Result_Category: ' || l_response_rec.Result_Category);
4091: arp_standard.debug( 'l_response_rec.Result_message : ' || l_response_rec.Result_message );
4092: arp_standard.debug( 'l_authresult_rec.Auth_Id: ' || l_authresult_rec.Auth_Id);
4093: arp_standard.debug( 'l_authresult_rec.Auth_Date: ' || l_authresult_rec.Auth_Date);
4094: arp_standard.debug( 'l_authresult_rec.Auth_Code: ' || l_authresult_rec.Auth_Code);
4095: arp_standard.debug( 'l_authresult_rec.AVS_Code: ' || l_authresult_rec.AVS_Code);
4096: arp_standard.debug( 'l_authresult_rec.Instr_SecCode_Check:'|| l_authresult_rec.Instr_SecCode_Check);
4097: arp_standard.debug( 'l_authresult_rec.PaymentSys_Code: ' || l_authresult_rec.PaymentSys_Code);
4098: arp_standard.debug( 'l_authresult_rec.PaymentSys_Msg: ' || l_authresult_rec.PaymentSys_Msg);

Line 4095: arp_standard.debug( 'l_authresult_rec.AVS_Code: ' || l_authresult_rec.AVS_Code);

4091: arp_standard.debug( 'l_response_rec.Result_message : ' || l_response_rec.Result_message );
4092: arp_standard.debug( 'l_authresult_rec.Auth_Id: ' || l_authresult_rec.Auth_Id);
4093: arp_standard.debug( 'l_authresult_rec.Auth_Date: ' || l_authresult_rec.Auth_Date);
4094: arp_standard.debug( 'l_authresult_rec.Auth_Code: ' || l_authresult_rec.Auth_Code);
4095: arp_standard.debug( 'l_authresult_rec.AVS_Code: ' || l_authresult_rec.AVS_Code);
4096: arp_standard.debug( 'l_authresult_rec.Instr_SecCode_Check:'|| l_authresult_rec.Instr_SecCode_Check);
4097: arp_standard.debug( 'l_authresult_rec.PaymentSys_Code: ' || l_authresult_rec.PaymentSys_Code);
4098: arp_standard.debug( 'l_authresult_rec.PaymentSys_Msg: ' || l_authresult_rec.PaymentSys_Msg);
4099: -- arp_standard.debug( 'l_authresult_rec.Risk_Result: ' || l_authresult_rec.Risk_Result);

Line 4096: arp_standard.debug( 'l_authresult_rec.Instr_SecCode_Check:'|| l_authresult_rec.Instr_SecCode_Check);

4092: arp_standard.debug( 'l_authresult_rec.Auth_Id: ' || l_authresult_rec.Auth_Id);
4093: arp_standard.debug( 'l_authresult_rec.Auth_Date: ' || l_authresult_rec.Auth_Date);
4094: arp_standard.debug( 'l_authresult_rec.Auth_Code: ' || l_authresult_rec.Auth_Code);
4095: arp_standard.debug( 'l_authresult_rec.AVS_Code: ' || l_authresult_rec.AVS_Code);
4096: arp_standard.debug( 'l_authresult_rec.Instr_SecCode_Check:'|| l_authresult_rec.Instr_SecCode_Check);
4097: arp_standard.debug( 'l_authresult_rec.PaymentSys_Code: ' || l_authresult_rec.PaymentSys_Code);
4098: arp_standard.debug( 'l_authresult_rec.PaymentSys_Msg: ' || l_authresult_rec.PaymentSys_Msg);
4099: -- arp_standard.debug( 'l_authresult_rec.Risk_Result: ' || l_authresult_rec.Risk_Result);
4100:

Line 4097: arp_standard.debug( 'l_authresult_rec.PaymentSys_Code: ' || l_authresult_rec.PaymentSys_Code);

4093: arp_standard.debug( 'l_authresult_rec.Auth_Date: ' || l_authresult_rec.Auth_Date);
4094: arp_standard.debug( 'l_authresult_rec.Auth_Code: ' || l_authresult_rec.Auth_Code);
4095: arp_standard.debug( 'l_authresult_rec.AVS_Code: ' || l_authresult_rec.AVS_Code);
4096: arp_standard.debug( 'l_authresult_rec.Instr_SecCode_Check:'|| l_authresult_rec.Instr_SecCode_Check);
4097: arp_standard.debug( 'l_authresult_rec.PaymentSys_Code: ' || l_authresult_rec.PaymentSys_Code);
4098: arp_standard.debug( 'l_authresult_rec.PaymentSys_Msg: ' || l_authresult_rec.PaymentSys_Msg);
4099: -- arp_standard.debug( 'l_authresult_rec.Risk_Result: ' || l_authresult_rec.Risk_Result);
4100:
4101: END IF;

Line 4098: arp_standard.debug( 'l_authresult_rec.PaymentSys_Msg: ' || l_authresult_rec.PaymentSys_Msg);

4094: arp_standard.debug( 'l_authresult_rec.Auth_Code: ' || l_authresult_rec.Auth_Code);
4095: arp_standard.debug( 'l_authresult_rec.AVS_Code: ' || l_authresult_rec.AVS_Code);
4096: arp_standard.debug( 'l_authresult_rec.Instr_SecCode_Check:'|| l_authresult_rec.Instr_SecCode_Check);
4097: arp_standard.debug( 'l_authresult_rec.PaymentSys_Code: ' || l_authresult_rec.PaymentSys_Code);
4098: arp_standard.debug( 'l_authresult_rec.PaymentSys_Msg: ' || l_authresult_rec.PaymentSys_Msg);
4099: -- arp_standard.debug( 'l_authresult_rec.Risk_Result: ' || l_authresult_rec.Risk_Result);
4100:
4101: END IF;
4102:

Line 4099: -- arp_standard.debug( 'l_authresult_rec.Risk_Result: ' || l_authresult_rec.Risk_Result);

4095: arp_standard.debug( 'l_authresult_rec.AVS_Code: ' || l_authresult_rec.AVS_Code);
4096: arp_standard.debug( 'l_authresult_rec.Instr_SecCode_Check:'|| l_authresult_rec.Instr_SecCode_Check);
4097: arp_standard.debug( 'l_authresult_rec.PaymentSys_Code: ' || l_authresult_rec.PaymentSys_Code);
4098: arp_standard.debug( 'l_authresult_rec.PaymentSys_Msg: ' || l_authresult_rec.PaymentSys_Msg);
4099: -- arp_standard.debug( 'l_authresult_rec.Risk_Result: ' || l_authresult_rec.Risk_Result);
4100:
4101: END IF;
4102:
4103: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 4112: arp_standard.debug('CR rec updated with auth_id and auth code ');

4108:
4109: ARP_CASH_RECEIPTS_PKG.update_p(l_cr_rec, p_cash_receipt_id);
4110:
4111: IF PG_DEBUG in ('Y', 'C') THEN
4112: arp_standard.debug('CR rec updated with auth_id and auth code ');
4113: END IF;
4114:
4115: END IF;
4116:

Line 4123: arp_standard.debug( 'l_MSG_COUNT=>'||to_char(l_MSG_COUNT));

4119: --if not pass the message stack received from iPayment
4120:
4121: IF (NVL(p_called_from,'NONE') = 'IREC') THEN
4122: IF PG_DEBUG in ('Y', 'C') THEN
4123: arp_standard.debug( 'l_MSG_COUNT=>'||to_char(l_MSG_COUNT));
4124: END IF;
4125: fnd_msg_pub.dump_list;
4126: IF PG_DEBUG in ('Y', 'C') THEN
4127: arp_standard.debug( 'Errors: ');

Line 4127: arp_standard.debug( 'Errors: ');

4123: arp_standard.debug( 'l_MSG_COUNT=>'||to_char(l_MSG_COUNT));
4124: END IF;
4125: fnd_msg_pub.dump_list;
4126: IF PG_DEBUG in ('Y', 'C') THEN
4127: arp_standard.debug( 'Errors: ');
4128: END IF;
4129: IF(l_MSG_COUNT=1) THEN
4130: IF PG_DEBUG in ('Y', 'C') THEN
4131: arp_standard.debug( l_MSG_DATA);

Line 4131: arp_standard.debug( l_MSG_DATA);

4127: arp_standard.debug( 'Errors: ');
4128: END IF;
4129: IF(l_MSG_COUNT=1) THEN
4130: IF PG_DEBUG in ('Y', 'C') THEN
4131: arp_standard.debug( l_MSG_DATA);
4132: END IF;
4133: ELSIF(l_MSG_COUNT>1)THEN
4134: LOOP
4135: l_MSG_DATA:=FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);

Line 4140: arp_standard.debug( l_MSG_DATA);

4136: IF (l_MSG_DATA IS NULL)THEN
4137: EXIT;
4138: END IF;
4139: IF PG_DEBUG in ('Y', 'C') THEN
4140: arp_standard.debug( l_MSG_DATA);
4141: END IF;
4142: END LOOP;
4143: END IF;
4144: END IF;

Line 4156: arp_standard.debug('create_cash_126');

4152: RETURN;
4153:
4154: ELSIF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4155:
4156: arp_standard.debug('create_cash_126');
4157: FND_MESSAGE.set_name('AR', 'AR_CC_AUTH_FAILED');
4158: FND_MSG_PUB.Add;
4159:
4160: IF l_response_rec.Result_Code is NOT NULL THEN

Line 4169: arp_standard.debug( 'l_iby_msg_data: ' || l_iby_msg_data);

4165:
4166: l_iby_msg_data := substrb( l_response_rec.Result_Code || ': '||
4167: l_response_rec.Result_Message , 1, 240);
4168:
4169: arp_standard.debug( 'l_iby_msg_data: ' || l_iby_msg_data);
4170: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4171: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',l_iby_msg_data);
4172:
4173: FND_MSG_PUB.Add;

Line 4208: arp_standard.debug ( 'CALL THE SETTLEMENT API');

4204:
4205:
4206: IF l_action = 'AUTHANDCAPTURE' THEN
4207:
4208: arp_standard.debug ( 'CALL THE SETTLEMENT API');
4209: IF PG_DEBUG in ('Y', 'C') THEN
4210: arp_standard.debug( 'Calling settlement for pmt_trxn_extn_id ');
4211: arp_standard.debug( ' l_payer_rec.Payment_Function ' || to_char( l_payer_rec.Payment_Function) );
4212: arp_standard.debug( ' l_payer_rec.Party_Id ' || to_char( l_payer_rec.Party_Id) );

Line 4210: arp_standard.debug( 'Calling settlement for pmt_trxn_extn_id ');

4206: IF l_action = 'AUTHANDCAPTURE' THEN
4207:
4208: arp_standard.debug ( 'CALL THE SETTLEMENT API');
4209: IF PG_DEBUG in ('Y', 'C') THEN
4210: arp_standard.debug( 'Calling settlement for pmt_trxn_extn_id ');
4211: arp_standard.debug( ' l_payer_rec.Payment_Function ' || to_char( l_payer_rec.Payment_Function) );
4212: arp_standard.debug( ' l_payer_rec.Party_Id ' || to_char( l_payer_rec.Party_Id) );
4213: arp_standard.debug( ' l_payer_rec.org_id ' || to_char(l_payer_rec.org_id) );
4214: arp_standard.debug( ' l_payer_rec.org_type ' || to_char( l_payer_rec.org_type) );

Line 4211: arp_standard.debug( ' l_payer_rec.Payment_Function ' || to_char( l_payer_rec.Payment_Function) );

4207:
4208: arp_standard.debug ( 'CALL THE SETTLEMENT API');
4209: IF PG_DEBUG in ('Y', 'C') THEN
4210: arp_standard.debug( 'Calling settlement for pmt_trxn_extn_id ');
4211: arp_standard.debug( ' l_payer_rec.Payment_Function ' || to_char( l_payer_rec.Payment_Function) );
4212: arp_standard.debug( ' l_payer_rec.Party_Id ' || to_char( l_payer_rec.Party_Id) );
4213: arp_standard.debug( ' l_payer_rec.org_id ' || to_char(l_payer_rec.org_id) );
4214: arp_standard.debug( ' l_payer_rec.org_type ' || to_char( l_payer_rec.org_type) );
4215: arp_standard.debug( ' l_payer_rec.Cust_Account_Id ' || to_char(l_payer_rec.Cust_Account_Id) );

Line 4212: arp_standard.debug( ' l_payer_rec.Party_Id ' || to_char( l_payer_rec.Party_Id) );

4208: arp_standard.debug ( 'CALL THE SETTLEMENT API');
4209: IF PG_DEBUG in ('Y', 'C') THEN
4210: arp_standard.debug( 'Calling settlement for pmt_trxn_extn_id ');
4211: arp_standard.debug( ' l_payer_rec.Payment_Function ' || to_char( l_payer_rec.Payment_Function) );
4212: arp_standard.debug( ' l_payer_rec.Party_Id ' || to_char( l_payer_rec.Party_Id) );
4213: arp_standard.debug( ' l_payer_rec.org_id ' || to_char(l_payer_rec.org_id) );
4214: arp_standard.debug( ' l_payer_rec.org_type ' || to_char( l_payer_rec.org_type) );
4215: arp_standard.debug( ' l_payer_rec.Cust_Account_Id ' || to_char(l_payer_rec.Cust_Account_Id) );
4216: arp_standard.debug( ' l_payer_rec.Account_Site_Id ' || to_char(l_payer_rec.Account_Site_Id) );

Line 4213: arp_standard.debug( ' l_payer_rec.org_id ' || to_char(l_payer_rec.org_id) );

4209: IF PG_DEBUG in ('Y', 'C') THEN
4210: arp_standard.debug( 'Calling settlement for pmt_trxn_extn_id ');
4211: arp_standard.debug( ' l_payer_rec.Payment_Function ' || to_char( l_payer_rec.Payment_Function) );
4212: arp_standard.debug( ' l_payer_rec.Party_Id ' || to_char( l_payer_rec.Party_Id) );
4213: arp_standard.debug( ' l_payer_rec.org_id ' || to_char(l_payer_rec.org_id) );
4214: arp_standard.debug( ' l_payer_rec.org_type ' || to_char( l_payer_rec.org_type) );
4215: arp_standard.debug( ' l_payer_rec.Cust_Account_Id ' || to_char(l_payer_rec.Cust_Account_Id) );
4216: arp_standard.debug( ' l_payer_rec.Account_Site_Id ' || to_char(l_payer_rec.Account_Site_Id) );
4217: arp_standard.debug( ' l_trxn_entity_id ' || to_char(l_trxn_entity_id ) );

Line 4214: arp_standard.debug( ' l_payer_rec.org_type ' || to_char( l_payer_rec.org_type) );

4210: arp_standard.debug( 'Calling settlement for pmt_trxn_extn_id ');
4211: arp_standard.debug( ' l_payer_rec.Payment_Function ' || to_char( l_payer_rec.Payment_Function) );
4212: arp_standard.debug( ' l_payer_rec.Party_Id ' || to_char( l_payer_rec.Party_Id) );
4213: arp_standard.debug( ' l_payer_rec.org_id ' || to_char(l_payer_rec.org_id) );
4214: arp_standard.debug( ' l_payer_rec.org_type ' || to_char( l_payer_rec.org_type) );
4215: arp_standard.debug( ' l_payer_rec.Cust_Account_Id ' || to_char(l_payer_rec.Cust_Account_Id) );
4216: arp_standard.debug( ' l_payer_rec.Account_Site_Id ' || to_char(l_payer_rec.Account_Site_Id) );
4217: arp_standard.debug( ' l_trxn_entity_id ' || to_char(l_trxn_entity_id ) );
4218: arp_standard.debug( ' l_amount_rec.value ' || to_char(l_amount_rec.value) );

Line 4215: arp_standard.debug( ' l_payer_rec.Cust_Account_Id ' || to_char(l_payer_rec.Cust_Account_Id) );

4211: arp_standard.debug( ' l_payer_rec.Payment_Function ' || to_char( l_payer_rec.Payment_Function) );
4212: arp_standard.debug( ' l_payer_rec.Party_Id ' || to_char( l_payer_rec.Party_Id) );
4213: arp_standard.debug( ' l_payer_rec.org_id ' || to_char(l_payer_rec.org_id) );
4214: arp_standard.debug( ' l_payer_rec.org_type ' || to_char( l_payer_rec.org_type) );
4215: arp_standard.debug( ' l_payer_rec.Cust_Account_Id ' || to_char(l_payer_rec.Cust_Account_Id) );
4216: arp_standard.debug( ' l_payer_rec.Account_Site_Id ' || to_char(l_payer_rec.Account_Site_Id) );
4217: arp_standard.debug( ' l_trxn_entity_id ' || to_char(l_trxn_entity_id ) );
4218: arp_standard.debug( ' l_amount_rec.value ' || to_char(l_amount_rec.value) );
4219: arp_standard.debug( ' l_amount_rec.currency_code ' || l_amount_rec.currency_code );

Line 4216: arp_standard.debug( ' l_payer_rec.Account_Site_Id ' || to_char(l_payer_rec.Account_Site_Id) );

4212: arp_standard.debug( ' l_payer_rec.Party_Id ' || to_char( l_payer_rec.Party_Id) );
4213: arp_standard.debug( ' l_payer_rec.org_id ' || to_char(l_payer_rec.org_id) );
4214: arp_standard.debug( ' l_payer_rec.org_type ' || to_char( l_payer_rec.org_type) );
4215: arp_standard.debug( ' l_payer_rec.Cust_Account_Id ' || to_char(l_payer_rec.Cust_Account_Id) );
4216: arp_standard.debug( ' l_payer_rec.Account_Site_Id ' || to_char(l_payer_rec.Account_Site_Id) );
4217: arp_standard.debug( ' l_trxn_entity_id ' || to_char(l_trxn_entity_id ) );
4218: arp_standard.debug( ' l_amount_rec.value ' || to_char(l_amount_rec.value) );
4219: arp_standard.debug( ' l_amount_rec.currency_code ' || l_amount_rec.currency_code );
4220: arp_standard.debug( ' lcr_receipt_attr.settlement_date ' || lcr_receipt_attr.settlement_date );

Line 4217: arp_standard.debug( ' l_trxn_entity_id ' || to_char(l_trxn_entity_id ) );

4213: arp_standard.debug( ' l_payer_rec.org_id ' || to_char(l_payer_rec.org_id) );
4214: arp_standard.debug( ' l_payer_rec.org_type ' || to_char( l_payer_rec.org_type) );
4215: arp_standard.debug( ' l_payer_rec.Cust_Account_Id ' || to_char(l_payer_rec.Cust_Account_Id) );
4216: arp_standard.debug( ' l_payer_rec.Account_Site_Id ' || to_char(l_payer_rec.Account_Site_Id) );
4217: arp_standard.debug( ' l_trxn_entity_id ' || to_char(l_trxn_entity_id ) );
4218: arp_standard.debug( ' l_amount_rec.value ' || to_char(l_amount_rec.value) );
4219: arp_standard.debug( ' l_amount_rec.currency_code ' || l_amount_rec.currency_code );
4220: arp_standard.debug( ' lcr_receipt_attr.settlement_date ' || lcr_receipt_attr.settlement_date );
4221: END IF;

Line 4218: arp_standard.debug( ' l_amount_rec.value ' || to_char(l_amount_rec.value) );

4214: arp_standard.debug( ' l_payer_rec.org_type ' || to_char( l_payer_rec.org_type) );
4215: arp_standard.debug( ' l_payer_rec.Cust_Account_Id ' || to_char(l_payer_rec.Cust_Account_Id) );
4216: arp_standard.debug( ' l_payer_rec.Account_Site_Id ' || to_char(l_payer_rec.Account_Site_Id) );
4217: arp_standard.debug( ' l_trxn_entity_id ' || to_char(l_trxn_entity_id ) );
4218: arp_standard.debug( ' l_amount_rec.value ' || to_char(l_amount_rec.value) );
4219: arp_standard.debug( ' l_amount_rec.currency_code ' || l_amount_rec.currency_code );
4220: arp_standard.debug( ' lcr_receipt_attr.settlement_date ' || lcr_receipt_attr.settlement_date );
4221: END IF;
4222:

Line 4219: arp_standard.debug( ' l_amount_rec.currency_code ' || l_amount_rec.currency_code );

4215: arp_standard.debug( ' l_payer_rec.Cust_Account_Id ' || to_char(l_payer_rec.Cust_Account_Id) );
4216: arp_standard.debug( ' l_payer_rec.Account_Site_Id ' || to_char(l_payer_rec.Account_Site_Id) );
4217: arp_standard.debug( ' l_trxn_entity_id ' || to_char(l_trxn_entity_id ) );
4218: arp_standard.debug( ' l_amount_rec.value ' || to_char(l_amount_rec.value) );
4219: arp_standard.debug( ' l_amount_rec.currency_code ' || l_amount_rec.currency_code );
4220: arp_standard.debug( ' lcr_receipt_attr.settlement_date ' || lcr_receipt_attr.settlement_date );
4221: END IF;
4222:
4223: IBY_FNDCPT_TRXN_PUB.Create_Settlement (

Line 4220: arp_standard.debug( ' lcr_receipt_attr.settlement_date ' || lcr_receipt_attr.settlement_date );

4216: arp_standard.debug( ' l_payer_rec.Account_Site_Id ' || to_char(l_payer_rec.Account_Site_Id) );
4217: arp_standard.debug( ' l_trxn_entity_id ' || to_char(l_trxn_entity_id ) );
4218: arp_standard.debug( ' l_amount_rec.value ' || to_char(l_amount_rec.value) );
4219: arp_standard.debug( ' l_amount_rec.currency_code ' || l_amount_rec.currency_code );
4220: arp_standard.debug( ' lcr_receipt_attr.settlement_date ' || lcr_receipt_attr.settlement_date );
4221: END IF;
4222:
4223: IBY_FNDCPT_TRXN_PUB.Create_Settlement (
4224: p_api_version => 1.0,

Line 4238: arp_standard.debug('x_return_status :<' || ls_return_status || '>');

4234: x_response => ls_response_rec ); -- out response struct
4235:
4236:
4237:
4238: arp_standard.debug('x_return_status :<' || ls_return_status || '>');
4239: arp_standard.debug('x_msg_count :<' || ls_msg_count || '>');
4240:
4241: FOR i IN 1..ls_msg_count LOOP
4242: arp_standard.debug('x_msg #' || TO_CHAR(i) || ' = <' ||

Line 4239: arp_standard.debug('x_msg_count :<' || ls_msg_count || '>');

4235:
4236:
4237:
4238: arp_standard.debug('x_return_status :<' || ls_return_status || '>');
4239: arp_standard.debug('x_msg_count :<' || ls_msg_count || '>');
4240:
4241: FOR i IN 1..ls_msg_count LOOP
4242: arp_standard.debug('x_msg #' || TO_CHAR(i) || ' = <' ||
4243: SUBSTR(fnd_msg_pub.get(p_msg_index => i,p_encoded => FND_API.G_FALSE),1,150) || '>');

Line 4242: arp_standard.debug('x_msg #' || TO_CHAR(i) || ' = <' ||

4238: arp_standard.debug('x_return_status :<' || ls_return_status || '>');
4239: arp_standard.debug('x_msg_count :<' || ls_msg_count || '>');
4240:
4241: FOR i IN 1..ls_msg_count LOOP
4242: arp_standard.debug('x_msg #' || TO_CHAR(i) || ' = <' ||
4243: SUBSTR(fnd_msg_pub.get(p_msg_index => i,p_encoded => FND_API.G_FALSE),1,150) || '>');
4244: END LOOP;
4245:
4246: IF PG_DEBUG in ('Y', 'C') THEN

Line 4247: arp_standard.debug( '-------------------------------------');

4243: SUBSTR(fnd_msg_pub.get(p_msg_index => i,p_encoded => FND_API.G_FALSE),1,150) || '>');
4244: END LOOP;
4245:
4246: IF PG_DEBUG in ('Y', 'C') THEN
4247: arp_standard.debug( '-------------------------------------');
4248: arp_standard.debug( 'ls_response_rec.Result_Code: ' || ls_response_rec.Result_Code);
4249: arp_standard.debug( 'ls_response_rec.Result_Category: ' || ls_response_rec.Result_Category);
4250: arp_standard.debug( 'ls_response_rec.Result_message : ' || ls_response_rec.Result_message );
4251:

Line 4248: arp_standard.debug( 'ls_response_rec.Result_Code: ' || ls_response_rec.Result_Code);

4244: END LOOP;
4245:
4246: IF PG_DEBUG in ('Y', 'C') THEN
4247: arp_standard.debug( '-------------------------------------');
4248: arp_standard.debug( 'ls_response_rec.Result_Code: ' || ls_response_rec.Result_Code);
4249: arp_standard.debug( 'ls_response_rec.Result_Category: ' || ls_response_rec.Result_Category);
4250: arp_standard.debug( 'ls_response_rec.Result_message : ' || ls_response_rec.Result_message );
4251:
4252: END IF;

Line 4249: arp_standard.debug( 'ls_response_rec.Result_Category: ' || ls_response_rec.Result_Category);

4245:
4246: IF PG_DEBUG in ('Y', 'C') THEN
4247: arp_standard.debug( '-------------------------------------');
4248: arp_standard.debug( 'ls_response_rec.Result_Code: ' || ls_response_rec.Result_Code);
4249: arp_standard.debug( 'ls_response_rec.Result_Category: ' || ls_response_rec.Result_Category);
4250: arp_standard.debug( 'ls_response_rec.Result_message : ' || ls_response_rec.Result_message );
4251:
4252: END IF;
4253:

Line 4250: arp_standard.debug( 'ls_response_rec.Result_message : ' || ls_response_rec.Result_message );

4246: IF PG_DEBUG in ('Y', 'C') THEN
4247: arp_standard.debug( '-------------------------------------');
4248: arp_standard.debug( 'ls_response_rec.Result_Code: ' || ls_response_rec.Result_Code);
4249: arp_standard.debug( 'ls_response_rec.Result_Category: ' || ls_response_rec.Result_Category);
4250: arp_standard.debug( 'ls_response_rec.Result_message : ' || ls_response_rec.Result_message );
4251:
4252: END IF;
4253:
4254:

Line 4257: arp_standard.debug( 'ls_MSG_COUNT=>'||to_char(ls_MSG_COUNT));

4253:
4254:
4255: IF (NVL(p_called_from,'NONE') = 'IREC') THEN
4256: IF PG_DEBUG in ('Y', 'C') THEN
4257: arp_standard.debug( 'ls_MSG_COUNT=>'||to_char(ls_MSG_COUNT));
4258: END IF;
4259: fnd_msg_pub.dump_list;
4260: IF PG_DEBUG in ('Y', 'C') THEN
4261: arp_standard.debug( 'Errors: ');

Line 4261: arp_standard.debug( 'Errors: ');

4257: arp_standard.debug( 'ls_MSG_COUNT=>'||to_char(ls_MSG_COUNT));
4258: END IF;
4259: fnd_msg_pub.dump_list;
4260: IF PG_DEBUG in ('Y', 'C') THEN
4261: arp_standard.debug( 'Errors: ');
4262: END IF;
4263: IF(ls_MSG_COUNT=1) THEN
4264: IF PG_DEBUG in ('Y', 'C') THEN
4265: arp_standard.debug( ls_MSG_DATA);

Line 4265: arp_standard.debug( ls_MSG_DATA);

4261: arp_standard.debug( 'Errors: ');
4262: END IF;
4263: IF(ls_MSG_COUNT=1) THEN
4264: IF PG_DEBUG in ('Y', 'C') THEN
4265: arp_standard.debug( ls_MSG_DATA);
4266: END IF;
4267: ELSIF(ls_MSG_COUNT>1)THEN
4268: LOOP
4269: ls_MSG_DATA:=FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);

Line 4274: arp_standard.debug( ls_MSG_DATA);

4270: IF (ls_MSG_DATA IS NULL)THEN
4271: EXIT;
4272: END IF;
4273: IF PG_DEBUG in ('Y', 'C') THEN
4274: arp_standard.debug( ls_MSG_DATA);
4275: END IF;
4276: END LOOP;
4277: END IF;
4278: END IF;

Line 4303: arp_standard.debug( 'ls_iby_msg_data: ' || ls_iby_msg_data);

4299:
4300: ls_iby_msg_data := substrb( ls_response_rec.Result_Code || ': '||
4301: ls_response_rec.Result_Message , 1, 240);
4302:
4303: arp_standard.debug( 'ls_iby_msg_data: ' || ls_iby_msg_data);
4304: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4305: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',ls_iby_msg_data);
4306:
4307: FND_MSG_PUB.Add;

Line 4381: arp_standard.debug ( 'inside Copy payment trxn ');

4377:
4378: BEGIN
4379:
4380:
4381: arp_standard.debug ( 'inside Copy payment trxn ');
4382:
4383: l_customer_id := p_customer_id;
4384: l_receipt_method_id := p_receipt_method_id;
4385: l_org_id := p_org_id;

Line 4426: arp_standard.debug ('p_payment_trxn_extension_id: '|| p_payment_trxn_extension_id);

4422: end if;
4423: If l_end_Date is not null then
4424: l_end_date := trunc(l_end_date);
4425: end if;
4426: arp_standard.debug ('p_payment_trxn_extension_id: '|| p_payment_trxn_extension_id);
4427: arp_standard.debug ('l_assignment_id: '|| l_assignment_id);
4428: arp_standard.debug ('l_start_date: '|| l_start_date);
4429: arp_standard.debug ('l_end_date: '|| l_end_date);
4430: arp_standard.debug ('p_receipt_date: '|| p_receipt_date);

Line 4427: arp_standard.debug ('l_assignment_id: '|| l_assignment_id);

4423: If l_end_Date is not null then
4424: l_end_date := trunc(l_end_date);
4425: end if;
4426: arp_standard.debug ('p_payment_trxn_extension_id: '|| p_payment_trxn_extension_id);
4427: arp_standard.debug ('l_assignment_id: '|| l_assignment_id);
4428: arp_standard.debug ('l_start_date: '|| l_start_date);
4429: arp_standard.debug ('l_end_date: '|| l_end_date);
4430: arp_standard.debug ('p_receipt_date: '|| p_receipt_date);
4431:

Line 4428: arp_standard.debug ('l_start_date: '|| l_start_date);

4424: l_end_date := trunc(l_end_date);
4425: end if;
4426: arp_standard.debug ('p_payment_trxn_extension_id: '|| p_payment_trxn_extension_id);
4427: arp_standard.debug ('l_assignment_id: '|| l_assignment_id);
4428: arp_standard.debug ('l_start_date: '|| l_start_date);
4429: arp_standard.debug ('l_end_date: '|| l_end_date);
4430: arp_standard.debug ('p_receipt_date: '|| p_receipt_date);
4431:
4432: IF p_receipt_date NOT BETWEEN l_start_date AND NVL(l_end_date, to_date('31-12-4712','DD-MM-YYYY')) THEN

Line 4429: arp_standard.debug ('l_end_date: '|| l_end_date);

4425: end if;
4426: arp_standard.debug ('p_payment_trxn_extension_id: '|| p_payment_trxn_extension_id);
4427: arp_standard.debug ('l_assignment_id: '|| l_assignment_id);
4428: arp_standard.debug ('l_start_date: '|| l_start_date);
4429: arp_standard.debug ('l_end_date: '|| l_end_date);
4430: arp_standard.debug ('p_receipt_date: '|| p_receipt_date);
4431:
4432: IF p_receipt_date NOT BETWEEN l_start_date AND NVL(l_end_date, to_date('31-12-4712','DD-MM-YYYY')) THEN
4433: arp_standard.debug ( 'Receipt date out of instrument assignment range. Receipt will not be created for this instrument.');

Line 4430: arp_standard.debug ('p_receipt_date: '|| p_receipt_date);

4426: arp_standard.debug ('p_payment_trxn_extension_id: '|| p_payment_trxn_extension_id);
4427: arp_standard.debug ('l_assignment_id: '|| l_assignment_id);
4428: arp_standard.debug ('l_start_date: '|| l_start_date);
4429: arp_standard.debug ('l_end_date: '|| l_end_date);
4430: arp_standard.debug ('p_receipt_date: '|| p_receipt_date);
4431:
4432: IF p_receipt_date NOT BETWEEN l_start_date AND NVL(l_end_date, to_date('31-12-4712','DD-MM-YYYY')) THEN
4433: arp_standard.debug ( 'Receipt date out of instrument assignment range. Receipt will not be created for this instrument.');
4434: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

Line 4433: arp_standard.debug ( 'Receipt date out of instrument assignment range. Receipt will not be created for this instrument.');

4429: arp_standard.debug ('l_end_date: '|| l_end_date);
4430: arp_standard.debug ('p_receipt_date: '|| p_receipt_date);
4431:
4432: IF p_receipt_date NOT BETWEEN l_start_date AND NVL(l_end_date, to_date('31-12-4712','DD-MM-YYYY')) THEN
4433: arp_standard.debug ( 'Receipt date out of instrument assignment range. Receipt will not be created for this instrument.');
4434: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4435: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Instrument assignment date range out of bound.');
4436: FND_MSG_PUB.Add;
4437: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4440: arp_standard.debug ('Receipt date is valid for instrument assignment.');

4436: FND_MSG_PUB.Add;
4437: x_return_status := FND_API.G_RET_STS_ERROR;
4438: RETURN;
4439: ELSE
4440: arp_standard.debug ('Receipt date is valid for instrument assignment.');
4441: END IF ;
4442:
4443: EXCEPTION WHEN NO_DATA_FOUND THEN
4444: arp_standard.debug ( 'No Data found while getting date range for instrument assignment '|| sqlerrm);

Line 4444: arp_standard.debug ( 'No Data found while getting date range for instrument assignment '|| sqlerrm);

4440: arp_standard.debug ('Receipt date is valid for instrument assignment.');
4441: END IF ;
4442:
4443: EXCEPTION WHEN NO_DATA_FOUND THEN
4444: arp_standard.debug ( 'No Data found while getting date range for instrument assignment '|| sqlerrm);
4445: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4446: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','No data range found for instrument assignment.');
4447: FND_MSG_PUB.Add;
4448: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4451: arp_standard.debug ( 'Exception while getting date range for instrument assignment '|| sqlerrm);

4447: FND_MSG_PUB.Add;
4448: x_return_status := FND_API.G_RET_STS_ERROR;
4449: RETURN;
4450: WHEN OTHERS THEN
4451: arp_standard.debug ( 'Exception while getting date range for instrument assignment '|| sqlerrm);
4452: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4453: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Error getting data range found for instrument assignment.');
4454: FND_MSG_PUB.Add;
4455: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4474: l_trxn_attribs_rec.Originating_Application_Id := arp_standard.application_id;

4470: l_payer_rec.org_type := NULL;
4471:
4472: end if;
4473:
4474: l_trxn_attribs_rec.Originating_Application_Id := arp_standard.application_id;
4475: l_trxn_attribs_rec.order_id := l_receipt_number;
4476: l_trxn_attribs_rec.Trxn_Ref_Number1 := 'RECEIPT';
4477: l_trxn_attribs_rec.Trxn_Ref_Number2 := l_receipt_number;
4478: l_assignment_id := l_assignment_id;

Line 4483: arp_standard.debug('l_payer.payment_function :<' || l_payer_rec.payment_function || '>');

4479: l_trxn_attribs_rec.copy_instr_assign_id := l_assignment_id;
4480: lc_trxn_entity_id(1):= l_payment_trxn_extension_id;
4481:
4482:
4483: arp_standard.debug('l_payer.payment_function :<' || l_payer_rec.payment_function || '>');
4484: arp_standard.debug('l_payer.Party_Id :<' || l_payer_rec.Party_Id || '>');
4485: arp_standard.debug('l_payer.Org_Type :<' || l_payer_rec.Org_Type || '>');
4486: arp_standard.debug('l_payer.Org_id :<' || l_payer_rec.Org_id || '>');
4487: arp_standard.debug('l_payer.Cust_Account_Id :<' || l_payer_rec.Cust_Account_Id || '>');

Line 4484: arp_standard.debug('l_payer.Party_Id :<' || l_payer_rec.Party_Id || '>');

4480: lc_trxn_entity_id(1):= l_payment_trxn_extension_id;
4481:
4482:
4483: arp_standard.debug('l_payer.payment_function :<' || l_payer_rec.payment_function || '>');
4484: arp_standard.debug('l_payer.Party_Id :<' || l_payer_rec.Party_Id || '>');
4485: arp_standard.debug('l_payer.Org_Type :<' || l_payer_rec.Org_Type || '>');
4486: arp_standard.debug('l_payer.Org_id :<' || l_payer_rec.Org_id || '>');
4487: arp_standard.debug('l_payer.Cust_Account_Id :<' || l_payer_rec.Cust_Account_Id || '>');
4488: arp_standard.debug('l_trxn_attribs.Originating_Application_Id :<'

Line 4485: arp_standard.debug('l_payer.Org_Type :<' || l_payer_rec.Org_Type || '>');

4481:
4482:
4483: arp_standard.debug('l_payer.payment_function :<' || l_payer_rec.payment_function || '>');
4484: arp_standard.debug('l_payer.Party_Id :<' || l_payer_rec.Party_Id || '>');
4485: arp_standard.debug('l_payer.Org_Type :<' || l_payer_rec.Org_Type || '>');
4486: arp_standard.debug('l_payer.Org_id :<' || l_payer_rec.Org_id || '>');
4487: arp_standard.debug('l_payer.Cust_Account_Id :<' || l_payer_rec.Cust_Account_Id || '>');
4488: arp_standard.debug('l_trxn_attribs.Originating_Application_Id :<'
4489: || l_trxn_attribs_rec.Originating_Application_Id || '>');

Line 4486: arp_standard.debug('l_payer.Org_id :<' || l_payer_rec.Org_id || '>');

4482:
4483: arp_standard.debug('l_payer.payment_function :<' || l_payer_rec.payment_function || '>');
4484: arp_standard.debug('l_payer.Party_Id :<' || l_payer_rec.Party_Id || '>');
4485: arp_standard.debug('l_payer.Org_Type :<' || l_payer_rec.Org_Type || '>');
4486: arp_standard.debug('l_payer.Org_id :<' || l_payer_rec.Org_id || '>');
4487: arp_standard.debug('l_payer.Cust_Account_Id :<' || l_payer_rec.Cust_Account_Id || '>');
4488: arp_standard.debug('l_trxn_attribs.Originating_Application_Id :<'
4489: || l_trxn_attribs_rec.Originating_Application_Id || '>');
4490: arp_standard.debug('l_trxn_attribs.order_id :<'|| l_trxn_attribs_rec.order_id || '>');

Line 4487: arp_standard.debug('l_payer.Cust_Account_Id :<' || l_payer_rec.Cust_Account_Id || '>');

4483: arp_standard.debug('l_payer.payment_function :<' || l_payer_rec.payment_function || '>');
4484: arp_standard.debug('l_payer.Party_Id :<' || l_payer_rec.Party_Id || '>');
4485: arp_standard.debug('l_payer.Org_Type :<' || l_payer_rec.Org_Type || '>');
4486: arp_standard.debug('l_payer.Org_id :<' || l_payer_rec.Org_id || '>');
4487: arp_standard.debug('l_payer.Cust_Account_Id :<' || l_payer_rec.Cust_Account_Id || '>');
4488: arp_standard.debug('l_trxn_attribs.Originating_Application_Id :<'
4489: || l_trxn_attribs_rec.Originating_Application_Id || '>');
4490: arp_standard.debug('l_trxn_attribs.order_id :<'|| l_trxn_attribs_rec.order_id || '>');
4491: arp_standard.debug('l_assignment_id :<'|| l_assignment_id || '>');

Line 4488: arp_standard.debug('l_trxn_attribs.Originating_Application_Id :<'

4484: arp_standard.debug('l_payer.Party_Id :<' || l_payer_rec.Party_Id || '>');
4485: arp_standard.debug('l_payer.Org_Type :<' || l_payer_rec.Org_Type || '>');
4486: arp_standard.debug('l_payer.Org_id :<' || l_payer_rec.Org_id || '>');
4487: arp_standard.debug('l_payer.Cust_Account_Id :<' || l_payer_rec.Cust_Account_Id || '>');
4488: arp_standard.debug('l_trxn_attribs.Originating_Application_Id :<'
4489: || l_trxn_attribs_rec.Originating_Application_Id || '>');
4490: arp_standard.debug('l_trxn_attribs.order_id :<'|| l_trxn_attribs_rec.order_id || '>');
4491: arp_standard.debug('l_assignment_id :<'|| l_assignment_id || '>');
4492: arp_standard.debug('payment_trx_extension_id :<'|| l_payment_trxn_extension_id || '>');

Line 4490: arp_standard.debug('l_trxn_attribs.order_id :<'|| l_trxn_attribs_rec.order_id || '>');

4486: arp_standard.debug('l_payer.Org_id :<' || l_payer_rec.Org_id || '>');
4487: arp_standard.debug('l_payer.Cust_Account_Id :<' || l_payer_rec.Cust_Account_Id || '>');
4488: arp_standard.debug('l_trxn_attribs.Originating_Application_Id :<'
4489: || l_trxn_attribs_rec.Originating_Application_Id || '>');
4490: arp_standard.debug('l_trxn_attribs.order_id :<'|| l_trxn_attribs_rec.order_id || '>');
4491: arp_standard.debug('l_assignment_id :<'|| l_assignment_id || '>');
4492: arp_standard.debug('payment_trx_extension_id :<'|| l_payment_trxn_extension_id || '>');
4493:
4494: IBY_FNDCPT_TRXN_PUB.Copy_Transaction_Extension

Line 4491: arp_standard.debug('l_assignment_id :<'|| l_assignment_id || '>');

4487: arp_standard.debug('l_payer.Cust_Account_Id :<' || l_payer_rec.Cust_Account_Id || '>');
4488: arp_standard.debug('l_trxn_attribs.Originating_Application_Id :<'
4489: || l_trxn_attribs_rec.Originating_Application_Id || '>');
4490: arp_standard.debug('l_trxn_attribs.order_id :<'|| l_trxn_attribs_rec.order_id || '>');
4491: arp_standard.debug('l_assignment_id :<'|| l_assignment_id || '>');
4492: arp_standard.debug('payment_trx_extension_id :<'|| l_payment_trxn_extension_id || '>');
4493:
4494: IBY_FNDCPT_TRXN_PUB.Copy_Transaction_Extension
4495: ( p_api_version => 1.0,

Line 4492: arp_standard.debug('payment_trx_extension_id :<'|| l_payment_trxn_extension_id || '>');

4488: arp_standard.debug('l_trxn_attribs.Originating_Application_Id :<'
4489: || l_trxn_attribs_rec.Originating_Application_Id || '>');
4490: arp_standard.debug('l_trxn_attribs.order_id :<'|| l_trxn_attribs_rec.order_id || '>');
4491: arp_standard.debug('l_assignment_id :<'|| l_assignment_id || '>');
4492: arp_standard.debug('payment_trx_extension_id :<'|| l_payment_trxn_extension_id || '>');
4493:
4494: IBY_FNDCPT_TRXN_PUB.Copy_Transaction_Extension
4495: ( p_api_version => 1.0,
4496: p_init_msg_list => FND_API.G_TRUE,

Line 4512: arp_standard.debug('the copied value of trx_entn is ' || o_payment_trxn_extension_id );

4508:
4509: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4510: o_payment_trxn_extension_id := p_trxn_entity_id ;
4511:
4512: arp_standard.debug('the copied value of trx_entn is ' || o_payment_trxn_extension_id );
4513: END IF;
4514:
4515:
4516: arp_standard.debug('x_return_status :<' || l_return_status || '>');

Line 4516: arp_standard.debug('x_return_status :<' || l_return_status || '>');

4512: arp_standard.debug('the copied value of trx_entn is ' || o_payment_trxn_extension_id );
4513: END IF;
4514:
4515:
4516: arp_standard.debug('x_return_status :<' || l_return_status || '>');
4517: arp_standard.debug('x_msg_count :<' || l_msg_count || '>');
4518:
4519: FOR i IN 1..l_msg_count LOOP
4520: arp_standard.debug('x_msg #' || TO_CHAR(i) || ' = <' ||

Line 4517: arp_standard.debug('x_msg_count :<' || l_msg_count || '>');

4513: END IF;
4514:
4515:
4516: arp_standard.debug('x_return_status :<' || l_return_status || '>');
4517: arp_standard.debug('x_msg_count :<' || l_msg_count || '>');
4518:
4519: FOR i IN 1..l_msg_count LOOP
4520: arp_standard.debug('x_msg #' || TO_CHAR(i) || ' = <' ||
4521: SUBSTR(fnd_msg_pub.get(p_msg_index => i,p_encoded => FND_API.G_FALSE),1,150) || '>');

Line 4520: arp_standard.debug('x_msg #' || TO_CHAR(i) || ' = <' ||

4516: arp_standard.debug('x_return_status :<' || l_return_status || '>');
4517: arp_standard.debug('x_msg_count :<' || l_msg_count || '>');
4518:
4519: FOR i IN 1..l_msg_count LOOP
4520: arp_standard.debug('x_msg #' || TO_CHAR(i) || ' = <' ||
4521: SUBSTR(fnd_msg_pub.get(p_msg_index => i,p_encoded => FND_API.G_FALSE),1,150) || '>');
4522: END LOOP;
4523:
4524:

Line 4527: arp_standard.debug('create_cash_127');

4523:
4524:
4525: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4526:
4527: arp_standard.debug('create_cash_127');
4528: FND_MESSAGE.set_name('AR', 'AR_CC_AUTH_FAILED');
4529: FND_MSG_PUB.Add;
4530:
4531: IF l_response_rec.result_Code is NOT NULL THEN

Line 4538: arp_standard.debug( 'l_cpy_msg_data: ' || l_cpy_msg_data);

4534:
4535: l_cpy_msg_data := substrb( l_response_rec.Result_Code || ': '||
4536: l_response_rec.Result_Message , 1, 240);
4537:
4538: arp_standard.debug( 'l_cpy_msg_data: ' || l_cpy_msg_data);
4539: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4540: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',l_cpy_msg_data);
4541:
4542: FND_MSG_PUB.Add;

Line 4631: arp_standard.debug ('p_payment_trxn_extension_id: '|| p_payment_trxn_extension_id);

4627: WHERE x.instr_assignment_id = i.instrument_payment_use_id
4628: AND x.trxn_extension_id = p_payment_trxn_extension_id
4629: AND x.INSTR_ASSIGNMENT_ID = l_assignment_id;
4630:
4631: arp_standard.debug ('p_payment_trxn_extension_id: '|| p_payment_trxn_extension_id);
4632: arp_standard.debug ('l_assignment_id: '|| l_assignment_id);
4633: arp_standard.debug ('l_start_date: '|| l_start_date);
4634: arp_standard.debug ('l_end_date: '|| l_end_date);
4635: arp_standard.debug ('p_receipt_date: '|| p_receipt_date);

Line 4632: arp_standard.debug ('l_assignment_id: '|| l_assignment_id);

4628: AND x.trxn_extension_id = p_payment_trxn_extension_id
4629: AND x.INSTR_ASSIGNMENT_ID = l_assignment_id;
4630:
4631: arp_standard.debug ('p_payment_trxn_extension_id: '|| p_payment_trxn_extension_id);
4632: arp_standard.debug ('l_assignment_id: '|| l_assignment_id);
4633: arp_standard.debug ('l_start_date: '|| l_start_date);
4634: arp_standard.debug ('l_end_date: '|| l_end_date);
4635: arp_standard.debug ('p_receipt_date: '|| p_receipt_date);
4636:

Line 4633: arp_standard.debug ('l_start_date: '|| l_start_date);

4629: AND x.INSTR_ASSIGNMENT_ID = l_assignment_id;
4630:
4631: arp_standard.debug ('p_payment_trxn_extension_id: '|| p_payment_trxn_extension_id);
4632: arp_standard.debug ('l_assignment_id: '|| l_assignment_id);
4633: arp_standard.debug ('l_start_date: '|| l_start_date);
4634: arp_standard.debug ('l_end_date: '|| l_end_date);
4635: arp_standard.debug ('p_receipt_date: '|| p_receipt_date);
4636:
4637: IF p_receipt_date NOT BETWEEN l_start_date AND NVL(l_end_date, to_date('31-12-4712','DD-MM-YYYY')) THEN

Line 4634: arp_standard.debug ('l_end_date: '|| l_end_date);

4630:
4631: arp_standard.debug ('p_payment_trxn_extension_id: '|| p_payment_trxn_extension_id);
4632: arp_standard.debug ('l_assignment_id: '|| l_assignment_id);
4633: arp_standard.debug ('l_start_date: '|| l_start_date);
4634: arp_standard.debug ('l_end_date: '|| l_end_date);
4635: arp_standard.debug ('p_receipt_date: '|| p_receipt_date);
4636:
4637: IF p_receipt_date NOT BETWEEN l_start_date AND NVL(l_end_date, to_date('31-12-4712','DD-MM-YYYY')) THEN
4638: arp_standard.debug ( 'Receipt date out of instrument assignment range. Receipt will not be created for this instrument.');

Line 4635: arp_standard.debug ('p_receipt_date: '|| p_receipt_date);

4631: arp_standard.debug ('p_payment_trxn_extension_id: '|| p_payment_trxn_extension_id);
4632: arp_standard.debug ('l_assignment_id: '|| l_assignment_id);
4633: arp_standard.debug ('l_start_date: '|| l_start_date);
4634: arp_standard.debug ('l_end_date: '|| l_end_date);
4635: arp_standard.debug ('p_receipt_date: '|| p_receipt_date);
4636:
4637: IF p_receipt_date NOT BETWEEN l_start_date AND NVL(l_end_date, to_date('31-12-4712','DD-MM-YYYY')) THEN
4638: arp_standard.debug ( 'Receipt date out of instrument assignment range. Receipt will not be created for this instrument.');
4639: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

Line 4638: arp_standard.debug ( 'Receipt date out of instrument assignment range. Receipt will not be created for this instrument.');

4634: arp_standard.debug ('l_end_date: '|| l_end_date);
4635: arp_standard.debug ('p_receipt_date: '|| p_receipt_date);
4636:
4637: IF p_receipt_date NOT BETWEEN l_start_date AND NVL(l_end_date, to_date('31-12-4712','DD-MM-YYYY')) THEN
4638: arp_standard.debug ( 'Receipt date out of instrument assignment range. Receipt will not be created for this instrument.');
4639: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4640: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Instrument assignment date range out of bound.');
4641: FND_MSG_PUB.Add;
4642: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4645: arp_standard.debug ('Receipt date is valid for instrument assignment.');

4641: FND_MSG_PUB.Add;
4642: x_return_status := FND_API.G_RET_STS_ERROR;
4643: RETURN;
4644: ELSE
4645: arp_standard.debug ('Receipt date is valid for instrument assignment.');
4646: END IF ;
4647:
4648: EXCEPTION WHEN NO_DATA_FOUND THEN
4649: arp_standard.debug ( 'No Data found while getting date range for instrument assignment '|| sqlerrm);

Line 4649: arp_standard.debug ( 'No Data found while getting date range for instrument assignment '|| sqlerrm);

4645: arp_standard.debug ('Receipt date is valid for instrument assignment.');
4646: END IF ;
4647:
4648: EXCEPTION WHEN NO_DATA_FOUND THEN
4649: arp_standard.debug ( 'No Data found while getting date range for instrument assignment '|| sqlerrm);
4650: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4651: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','No data range found for instrument assignment.');
4652: FND_MSG_PUB.Add;
4653: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4656: arp_standard.debug ( 'Exception while getting date range for instrument assignment '|| sqlerrm);

4652: FND_MSG_PUB.Add;
4653: x_return_status := FND_API.G_RET_STS_ERROR;
4654: RETURN;
4655: WHEN OTHERS THEN
4656: arp_standard.debug ( 'Exception while getting date range for instrument assignment '|| sqlerrm);
4657: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4658: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Error getting data range found for instrument assignment.');
4659: FND_MSG_PUB.Add;
4660: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4681: l_trxn_attribs_rec.Originating_Application_Id := arp_standard.application_id;

4677: l_payer_rec.org_id := NULL;
4678: l_payer_rec.org_type := NULL;
4679:
4680: end if;
4681: l_trxn_attribs_rec.Originating_Application_Id := arp_standard.application_id;
4682: l_trxn_attribs_rec.order_id := p_receipt_number ;
4683: l_trxn_attribs_rec.Trxn_Ref_Number1 := 'RECEIPT';
4684: l_trxn_attribs_rec.Trxn_Ref_Number2 := p_cash_receipt_id;
4685: l_assignment_id := l_assignment_id;

Line 4714: arp_standard.debug(to_char(SQL%ROWCOUNT) || 'PMT_EXTN_ID row(s) updated.');

4710: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4711:
4712: o_payment_trxn_extension_id := l_extension_id;
4713:
4714: arp_standard.debug(to_char(SQL%ROWCOUNT) || 'PMT_EXTN_ID row(s) updated.');
4715:
4716: END IF;
4717:
4718: FOR i IN 1..l_msg_count LOOP

Line 4719: arp_standard.debug('x_msg #' || TO_CHAR(i) || ' = <' ||

4715:
4716: END IF;
4717:
4718: FOR i IN 1..l_msg_count LOOP
4719: arp_standard.debug('x_msg #' || TO_CHAR(i) || ' = <' ||
4720: SUBSTR(fnd_msg_pub.get(p_msg_index => i,p_encoded => FND_API.G_FALSE),1,150) || '>');
4721: END LOOP;
4722:
4723:

Line 4725: arp_standard.debug('FAILED: ' ||l_result_rec.result_code);

4721: END LOOP;
4722:
4723:
4724: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4725: arp_standard.debug('FAILED: ' ||l_result_rec.result_code);
4726: arp_standard.debug('PARM-l_payer_rec.Payment_Function ' ||l_payer_rec.Payment_Function);
4727: arp_standard.debug('PARM-l_payer_rec.party_id ' ||l_payer_rec.Party_Id);
4728: arp_standard.debug('PARM-l_payer_rec.org_id ' ||l_payer_rec.org_id);
4729: arp_standard.debug('PARM-l_payer_rec.org_type ' ||l_payer_rec.org_type);

Line 4726: arp_standard.debug('PARM-l_payer_rec.Payment_Function ' ||l_payer_rec.Payment_Function);

4722:
4723:
4724: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4725: arp_standard.debug('FAILED: ' ||l_result_rec.result_code);
4726: arp_standard.debug('PARM-l_payer_rec.Payment_Function ' ||l_payer_rec.Payment_Function);
4727: arp_standard.debug('PARM-l_payer_rec.party_id ' ||l_payer_rec.Party_Id);
4728: arp_standard.debug('PARM-l_payer_rec.org_id ' ||l_payer_rec.org_id);
4729: arp_standard.debug('PARM-l_payer_rec.org_type ' ||l_payer_rec.org_type);
4730: arp_standard.debug('PARM-l_payer_rec.customer_id ' ||l_payer_rec.Cust_Account_Id);

Line 4727: arp_standard.debug('PARM-l_payer_rec.party_id ' ||l_payer_rec.Party_Id);

4723:
4724: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4725: arp_standard.debug('FAILED: ' ||l_result_rec.result_code);
4726: arp_standard.debug('PARM-l_payer_rec.Payment_Function ' ||l_payer_rec.Payment_Function);
4727: arp_standard.debug('PARM-l_payer_rec.party_id ' ||l_payer_rec.Party_Id);
4728: arp_standard.debug('PARM-l_payer_rec.org_id ' ||l_payer_rec.org_id);
4729: arp_standard.debug('PARM-l_payer_rec.org_type ' ||l_payer_rec.org_type);
4730: arp_standard.debug('PARM-l_payer_rec.customer_id ' ||l_payer_rec.Cust_Account_Id);
4731: arp_standard.debug('PARM-l_payer_rec.customer_site_id ' ||l_payer_rec.Account_Site_Id);

Line 4728: arp_standard.debug('PARM-l_payer_rec.org_id ' ||l_payer_rec.org_id);

4724: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4725: arp_standard.debug('FAILED: ' ||l_result_rec.result_code);
4726: arp_standard.debug('PARM-l_payer_rec.Payment_Function ' ||l_payer_rec.Payment_Function);
4727: arp_standard.debug('PARM-l_payer_rec.party_id ' ||l_payer_rec.Party_Id);
4728: arp_standard.debug('PARM-l_payer_rec.org_id ' ||l_payer_rec.org_id);
4729: arp_standard.debug('PARM-l_payer_rec.org_type ' ||l_payer_rec.org_type);
4730: arp_standard.debug('PARM-l_payer_rec.customer_id ' ||l_payer_rec.Cust_Account_Id);
4731: arp_standard.debug('PARM-l_payer_rec.customer_site_id ' ||l_payer_rec.Account_Site_Id);
4732: arp_standard.debug('PARM-l_trxn_attribs_rec.Originating_Application_Id ' ||l_trxn_attribs_rec.Originating_Application_Id);

Line 4729: arp_standard.debug('PARM-l_payer_rec.org_type ' ||l_payer_rec.org_type);

4725: arp_standard.debug('FAILED: ' ||l_result_rec.result_code);
4726: arp_standard.debug('PARM-l_payer_rec.Payment_Function ' ||l_payer_rec.Payment_Function);
4727: arp_standard.debug('PARM-l_payer_rec.party_id ' ||l_payer_rec.Party_Id);
4728: arp_standard.debug('PARM-l_payer_rec.org_id ' ||l_payer_rec.org_id);
4729: arp_standard.debug('PARM-l_payer_rec.org_type ' ||l_payer_rec.org_type);
4730: arp_standard.debug('PARM-l_payer_rec.customer_id ' ||l_payer_rec.Cust_Account_Id);
4731: arp_standard.debug('PARM-l_payer_rec.customer_site_id ' ||l_payer_rec.Account_Site_Id);
4732: arp_standard.debug('PARM-l_trxn_attribs_rec.Originating_Application_Id ' ||l_trxn_attribs_rec.Originating_Application_Id);
4733: arp_standard.debug('PARM- l_trxn_attribs_rec.order_id ' ||l_trxn_attribs_rec.order_id);

Line 4730: arp_standard.debug('PARM-l_payer_rec.customer_id ' ||l_payer_rec.Cust_Account_Id);

4726: arp_standard.debug('PARM-l_payer_rec.Payment_Function ' ||l_payer_rec.Payment_Function);
4727: arp_standard.debug('PARM-l_payer_rec.party_id ' ||l_payer_rec.Party_Id);
4728: arp_standard.debug('PARM-l_payer_rec.org_id ' ||l_payer_rec.org_id);
4729: arp_standard.debug('PARM-l_payer_rec.org_type ' ||l_payer_rec.org_type);
4730: arp_standard.debug('PARM-l_payer_rec.customer_id ' ||l_payer_rec.Cust_Account_Id);
4731: arp_standard.debug('PARM-l_payer_rec.customer_site_id ' ||l_payer_rec.Account_Site_Id);
4732: arp_standard.debug('PARM-l_trxn_attribs_rec.Originating_Application_Id ' ||l_trxn_attribs_rec.Originating_Application_Id);
4733: arp_standard.debug('PARM- l_trxn_attribs_rec.order_id ' ||l_trxn_attribs_rec.order_id);
4734: arp_standard.debug('PARM-l_trxn_attribs_rec.Trxn_Ref_Number1 ' ||l_trxn_attribs_rec.Trxn_Ref_Number1);

Line 4731: arp_standard.debug('PARM-l_payer_rec.customer_site_id ' ||l_payer_rec.Account_Site_Id);

4727: arp_standard.debug('PARM-l_payer_rec.party_id ' ||l_payer_rec.Party_Id);
4728: arp_standard.debug('PARM-l_payer_rec.org_id ' ||l_payer_rec.org_id);
4729: arp_standard.debug('PARM-l_payer_rec.org_type ' ||l_payer_rec.org_type);
4730: arp_standard.debug('PARM-l_payer_rec.customer_id ' ||l_payer_rec.Cust_Account_Id);
4731: arp_standard.debug('PARM-l_payer_rec.customer_site_id ' ||l_payer_rec.Account_Site_Id);
4732: arp_standard.debug('PARM-l_trxn_attribs_rec.Originating_Application_Id ' ||l_trxn_attribs_rec.Originating_Application_Id);
4733: arp_standard.debug('PARM- l_trxn_attribs_rec.order_id ' ||l_trxn_attribs_rec.order_id);
4734: arp_standard.debug('PARM-l_trxn_attribs_rec.Trxn_Ref_Number1 ' ||l_trxn_attribs_rec.Trxn_Ref_Number1);
4735: arp_standard.debug('PARM-l_assignment_id ' ||l_assignment_id);

Line 4732: arp_standard.debug('PARM-l_trxn_attribs_rec.Originating_Application_Id ' ||l_trxn_attribs_rec.Originating_Application_Id);

4728: arp_standard.debug('PARM-l_payer_rec.org_id ' ||l_payer_rec.org_id);
4729: arp_standard.debug('PARM-l_payer_rec.org_type ' ||l_payer_rec.org_type);
4730: arp_standard.debug('PARM-l_payer_rec.customer_id ' ||l_payer_rec.Cust_Account_Id);
4731: arp_standard.debug('PARM-l_payer_rec.customer_site_id ' ||l_payer_rec.Account_Site_Id);
4732: arp_standard.debug('PARM-l_trxn_attribs_rec.Originating_Application_Id ' ||l_trxn_attribs_rec.Originating_Application_Id);
4733: arp_standard.debug('PARM- l_trxn_attribs_rec.order_id ' ||l_trxn_attribs_rec.order_id);
4734: arp_standard.debug('PARM-l_trxn_attribs_rec.Trxn_Ref_Number1 ' ||l_trxn_attribs_rec.Trxn_Ref_Number1);
4735: arp_standard.debug('PARM-l_assignment_id ' ||l_assignment_id);
4736:

Line 4733: arp_standard.debug('PARM- l_trxn_attribs_rec.order_id ' ||l_trxn_attribs_rec.order_id);

4729: arp_standard.debug('PARM-l_payer_rec.org_type ' ||l_payer_rec.org_type);
4730: arp_standard.debug('PARM-l_payer_rec.customer_id ' ||l_payer_rec.Cust_Account_Id);
4731: arp_standard.debug('PARM-l_payer_rec.customer_site_id ' ||l_payer_rec.Account_Site_Id);
4732: arp_standard.debug('PARM-l_trxn_attribs_rec.Originating_Application_Id ' ||l_trxn_attribs_rec.Originating_Application_Id);
4733: arp_standard.debug('PARM- l_trxn_attribs_rec.order_id ' ||l_trxn_attribs_rec.order_id);
4734: arp_standard.debug('PARM-l_trxn_attribs_rec.Trxn_Ref_Number1 ' ||l_trxn_attribs_rec.Trxn_Ref_Number1);
4735: arp_standard.debug('PARM-l_assignment_id ' ||l_assignment_id);
4736:
4737:

Line 4734: arp_standard.debug('PARM-l_trxn_attribs_rec.Trxn_Ref_Number1 ' ||l_trxn_attribs_rec.Trxn_Ref_Number1);

4730: arp_standard.debug('PARM-l_payer_rec.customer_id ' ||l_payer_rec.Cust_Account_Id);
4731: arp_standard.debug('PARM-l_payer_rec.customer_site_id ' ||l_payer_rec.Account_Site_Id);
4732: arp_standard.debug('PARM-l_trxn_attribs_rec.Originating_Application_Id ' ||l_trxn_attribs_rec.Originating_Application_Id);
4733: arp_standard.debug('PARM- l_trxn_attribs_rec.order_id ' ||l_trxn_attribs_rec.order_id);
4734: arp_standard.debug('PARM-l_trxn_attribs_rec.Trxn_Ref_Number1 ' ||l_trxn_attribs_rec.Trxn_Ref_Number1);
4735: arp_standard.debug('PARM-l_assignment_id ' ||l_assignment_id);
4736:
4737:
4738: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 4735: arp_standard.debug('PARM-l_assignment_id ' ||l_assignment_id);

4731: arp_standard.debug('PARM-l_payer_rec.customer_site_id ' ||l_payer_rec.Account_Site_Id);
4732: arp_standard.debug('PARM-l_trxn_attribs_rec.Originating_Application_Id ' ||l_trxn_attribs_rec.Originating_Application_Id);
4733: arp_standard.debug('PARM- l_trxn_attribs_rec.order_id ' ||l_trxn_attribs_rec.order_id);
4734: arp_standard.debug('PARM-l_trxn_attribs_rec.Trxn_Ref_Number1 ' ||l_trxn_attribs_rec.Trxn_Ref_Number1);
4735: arp_standard.debug('PARM-l_assignment_id ' ||l_assignment_id);
4736:
4737:
4738: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
4739: p_count => x_msg_count,

Line 4753: arp_standard.debug('ERROR IN CREATION ');

4749: END IF; /* payment_trxn_extension_id is not null */
4750:
4751: EXCEPTION
4752: WHEN OTHERS THEN
4753: arp_standard.debug('ERROR IN CREATION ');
4754: RAISE;
4755: END Create_payment_extension;
4756:
4757:

Line 4761: -- Standard API parameters.

4757:
4758: -- bichatte payment uptake end
4759:
4760: PROCEDURE Create_and_apply(
4761: -- Standard API parameters.
4762: p_api_version IN NUMBER,
4763: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4764: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4765: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

Line 4853: arp_standard.debug('ar_receipt_api.Create_and_apply ()+');

4849: l_cc_return_status VARCHAR2(1); -- credit card return status
4850: l_response_error_code VARCHAR2(80);
4851: BEGIN
4852: IF PG_DEBUG in ('Y', 'C') THEN
4853: arp_standard.debug('ar_receipt_api.Create_and_apply ()+');
4854: END IF;
4855:
4856: /*------------------------------------+
4857: | Standard start of API savepoint |

Line 4857: | Standard start of API savepoint |

4853: arp_standard.debug('ar_receipt_api.Create_and_apply ()+');
4854: END IF;
4855:
4856: /*------------------------------------+
4857: | Standard start of API savepoint |
4858: +------------------------------------*/
4859:
4860: SAVEPOINT Create_Apply_PVT;
4861: --calling the internal create_cash routine

Line 4984: arp_standard.debug('Apply: ' || 'Checking p_call_payment_processor: ' || p_call_payment_processor);

4980: -- was successful. All relevant information for the
4981: -- payment can be derived from the cash receipt.
4982:
4983: IF PG_DEBUG in ('Y', 'C') THEN
4984: arp_standard.debug('Apply: ' || 'Checking p_call_payment_processor: ' || p_call_payment_processor);
4985: END IF;
4986:
4987: if (p_call_payment_processor = FND_API.G_TRUE) then
4988:

Line 5083: -- Standard API parameters.

5079: | Create_cash_cc_internal is being obsoleted.
5080: |
5081: *=======================================================================*/
5082: PROCEDURE Create_Apply_On_Acc(
5083: -- Standard API parameters.
5084: p_api_version IN NUMBER,
5085: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
5086: p_commit IN VARCHAR2 := FND_API.G_FALSE,
5087: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

Line 5195: arp_standard.debug('ar_receipt_api_pub.Create_Apply_On_Acc() +');

5191:
5192: BEGIN
5193:
5194: IF PG_DEBUG in ('Y', 'C') THEN
5195: arp_standard.debug('ar_receipt_api_pub.Create_Apply_On_Acc() +');
5196: END IF;
5197:
5198:
5199: /*------------------------------------+

Line 5200: | Standard start of API savepoint |

5196: END IF;
5197:
5198:
5199: /*------------------------------------+
5200: | Standard start of API savepoint |
5201: +------------------------------------*/
5202: SAVEPOINT Create_Apply_On_Acc;
5203:
5204: /*-----------------------------------------+

Line 5211: | Standard call to check for call compatibility |

5207:
5208: x_return_status := FND_API.G_RET_STS_SUCCESS;
5209:
5210: /*--------------------------------------------------+
5211: | Standard call to check for call compatibility |
5212: +--------------------------------------------------*/
5213: IF NOT FND_API.Compatible_API_Call(
5214: l_api_version,
5215: p_api_version,

Line 5243: -- Standard API parameters.

5239: | Call the internal routine to create receipt |
5240: +--------------------------------------------------*/
5241:
5242: Create_cash_1(
5243: -- Standard API parameters.
5244: p_api_version ,
5245: p_init_msg_list,
5246: p_commit,
5247: p_validation_level,

Line 5441: arp_standard.debug('ar_receipt_api_pub.Create_Apply_On_Acc()-');

5437: +------------------------------------------------------*/
5438: p_cr_id := l_cash_receipt_id;
5439:
5440: IF PG_DEBUG in ('Y', 'C') THEN
5441: arp_standard.debug('ar_receipt_api_pub.Create_Apply_On_Acc()-');
5442: END IF;
5443: EXCEPTION
5444: WHEN OTHERS THEN
5445:

Line 5487: Added apr_standard.sysparm.org_id as IN parameter while calling

5483: +-------------------------------------------------*/
5484: arp_global.init_global;
5485:
5486: /*
5487: Added apr_standard.sysparm.org_id as IN parameter while calling
5488: arp_standard.init_standard. Bug 10016914
5489: */
5490: arp_util.debug('Before calling ARP_STANDARD.INIT_STANDARD(), arp_standard.sysparm.org_id = ' || arp_standard.sysparm.org_id);
5491: arp_standard.init_standard(arp_standard.sysparm.org_id);

Line 5488: arp_standard.init_standard. Bug 10016914

5484: arp_global.init_global;
5485:
5486: /*
5487: Added apr_standard.sysparm.org_id as IN parameter while calling
5488: arp_standard.init_standard. Bug 10016914
5489: */
5490: arp_util.debug('Before calling ARP_STANDARD.INIT_STANDARD(), arp_standard.sysparm.org_id = ' || arp_standard.sysparm.org_id);
5491: arp_standard.init_standard(arp_standard.sysparm.org_id);
5492:

Line 5490: arp_util.debug('Before calling ARP_STANDARD.INIT_STANDARD(), arp_standard.sysparm.org_id = ' || arp_standard.sysparm.org_id);

5486: /*
5487: Added apr_standard.sysparm.org_id as IN parameter while calling
5488: arp_standard.init_standard. Bug 10016914
5489: */
5490: arp_util.debug('Before calling ARP_STANDARD.INIT_STANDARD(), arp_standard.sysparm.org_id = ' || arp_standard.sysparm.org_id);
5491: arp_standard.init_standard(arp_standard.sysparm.org_id);
5492:
5493: -- --------------------------------------------------------------
5494: -- First lock existing records from database for update

Line 5491: arp_standard.init_standard(arp_standard.sysparm.org_id);

5487: Added apr_standard.sysparm.org_id as IN parameter while calling
5488: arp_standard.init_standard. Bug 10016914
5489: */
5490: arp_util.debug('Before calling ARP_STANDARD.INIT_STANDARD(), arp_standard.sysparm.org_id = ' || arp_standard.sysparm.org_id);
5491: arp_standard.init_standard(arp_standard.sysparm.org_id);
5492:
5493: -- --------------------------------------------------------------
5494: -- First lock existing records from database for update
5495: -- --------------------------------------------------------------

Line 5580: /* This is standard reversal */

5576: raise;
5577: END reverse_cover;
5578:
5579:
5580: /* This is standard reversal */
5581: PROCEDURE Reverse(
5582: -- Standard API parameters.
5583: p_api_version IN NUMBER,
5584: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

Line 5582: -- Standard API parameters.

5578:
5579:
5580: /* This is standard reversal */
5581: PROCEDURE Reverse(
5582: -- Standard API parameters.
5583: p_api_version IN NUMBER,
5584: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
5585: p_commit IN VARCHAR2 := FND_API.G_FALSE,
5586: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

Line 5647: | Standard start of API savepoint |

5643: l_xla_ev_rec arp_xla_events.xla_events_type;
5644: BEGIN
5645:
5646: /*------------------------------------+
5647: | Standard start of API savepoint |
5648: +------------------------------------*/
5649:
5650: SAVEPOINT Reverse_PVT;
5651:

Line 5653: | Standard call to check for call compatibility |

5649:
5650: SAVEPOINT Reverse_PVT;
5651:
5652: /*--------------------------------------------------+
5653: | Standard call to check for call compatibility |
5654: +--------------------------------------------------*/
5655:
5656: IF NOT FND_API.Compatible_API_Call(
5657: l_api_version,

Line 5782: arp_util.debug('Apply: ' || 'Standard reversal not possible for this receipt');

5778: );
5779:
5780: IF l_std_reversal_possible <> 'Y' THEN
5781: IF PG_DEBUG in ('Y', 'C') THEN
5782: arp_util.debug('Apply: ' || 'Standard reversal not possible for this receipt');
5783: END IF;
5784: FND_MESSAGE.SET_NAME('AR','AR_RAPI_NON_REVERSIBLE');
5785: FND_MSG_PUB.Add;
5786: l_rev_return_status := FND_API.G_RET_STS_ERROR;

Line 6119: | Standard check of p_commit |

6115:
6116: --Bug 1847350: Added the check on p_commit and then the commit.
6117:
6118: /*--------------------------------+
6119: | Standard check of p_commit |
6120: +--------------------------------*/
6121:
6122: IF FND_API.To_Boolean( p_commit )
6123: THEN

Line 6224: -- Standard API parameters.

6220:
6221: END reverse;
6222:
6223: PROCEDURE Apply_on_account(
6224: -- Standard API parameters.
6225: p_api_version IN NUMBER,
6226: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
6227: p_commit IN VARCHAR2 := FND_API.G_FALSE,
6228: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

Line 6276: | Standard start of API savepoint |

6272: l_org_id NUMBER;
6273: BEGIN
6274:
6275: /*------------------------------------+
6276: | Standard start of API savepoint |
6277: +------------------------------------*/
6278:
6279: SAVEPOINT Apply_on_ac_PVT;
6280:

Line 6282: | Standard call to check for call compatibility |

6278:
6279: SAVEPOINT Apply_on_ac_PVT;
6280:
6281: /*--------------------------------------------------+
6282: | Standard call to check for call compatibility |
6283: +--------------------------------------------------*/
6284:
6285: IF NOT FND_API.Compatible_API_Call(
6286: l_api_version,

Line 6544: | Standard check of p_commit |

6540: RAISE;
6541: END IF;
6542: END;
6543: /*--------------------------------+
6544: | Standard check of p_commit |
6545: +--------------------------------*/
6546:
6547: IF FND_API.To_Boolean( p_commit )
6548: THEN

Line 6650: -- Standard API parameters.

6646: );
6647: END Apply_on_account;
6648:
6649: PROCEDURE Unapply_on_account(
6650: -- Standard API parameters.
6651: p_api_version IN NUMBER,
6652: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
6653: p_commit IN VARCHAR2 := FND_API.G_FALSE,
6654: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

Line 6681: | Standard start of API savepoint |

6677: l_org_id NUMBER;
6678: l_cr_unapp_amt NUMBER ; /* Bug fix 3569640 */
6679: BEGIN
6680: /*------------------------------------+
6681: | Standard start of API savepoint |
6682: +------------------------------------*/
6683:
6684: SAVEPOINT Unapply_on_ac_PVT;
6685:

Line 6687: | Standard call to check for call compatibility |

6683:
6684: SAVEPOINT Unapply_on_ac_PVT;
6685:
6686: /*--------------------------------------------------+
6687: | Standard call to check for call compatibility |
6688: +--------------------------------------------------*/
6689:
6690: IF NOT FND_API.Compatible_API_Call(
6691: l_api_version,

Line 6852: | Standard check of p_commit |

6848: END IF;
6849: END;
6850:
6851: /*--------------------------------+
6852: | Standard check of p_commit |
6853: +--------------------------------*/
6854:
6855: IF FND_API.To_Boolean( p_commit )
6856: THEN

Line 6958: -- Standard API parameters.

6954: );
6955: END Unapply_on_account;
6956:
6957: PROCEDURE Unapply_other_account(
6958: -- Standard API parameters.
6959: p_api_version IN NUMBER,
6960: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
6961: p_commit IN VARCHAR2 := FND_API.G_FALSE,
6962: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

Line 6999: | Standard start of API savepoint |

6995: l_org_id NUMBER;
6996: l_cr_unapp_amt NUMBER; /* Bug fix 3569640 */
6997: BEGIN
6998: /*------------------------------------+
6999: | Standard start of API savepoint |
7000: +------------------------------------*/
7001:
7002: SAVEPOINT Unapply_other_ac_PVT;
7003:

Line 7005: | Standard call to check for call compatibility |

7001:
7002: SAVEPOINT Unapply_other_ac_PVT;
7003:
7004: /*--------------------------------------------------+
7005: | Standard call to check for call compatibility |
7006: +--------------------------------------------------*/
7007:
7008: IF NOT FND_API.Compatible_API_Call(
7009: p_current_version_number => l_api_version,

Line 7236: | Standard check of p_commit |

7232: END IF;
7233: END;
7234:
7235: /*--------------------------------+
7236: | Standard check of p_commit |
7237: +--------------------------------*/
7238:
7239: IF FND_API.To_Boolean( p_commit )
7240: THEN

Line 7342: -- Standard API parameters.

7338: );
7339: END Unapply_other_account;
7340:
7341: PROCEDURE Activity_application(
7342: -- Standard API parameters.
7343: p_api_version IN NUMBER,
7344: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7345: p_commit IN VARCHAR2 := FND_API.G_FALSE,
7346: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

Line 7461: | Standard start of API savepoint |

7457: BEGIN
7458: l_called_from:=p_called_from; /*5444407*/
7459:
7460: /*------------------------------------+
7461: | Standard start of API savepoint |
7462: +------------------------------------*/
7463:
7464: SAVEPOINT Activity_app_PVT;
7465:

Line 7467: | Standard call to check for call compatibility |

7463:
7464: SAVEPOINT Activity_app_PVT;
7465:
7466: /*--------------------------------------------------+
7467: | Standard call to check for call compatibility |
7468: +--------------------------------------------------*/
7469:
7470: IF NOT FND_API.Compatible_API_Call(
7471: l_api_version,

Line 7915: | Standard check of p_commit |

7911: p_application_ref_id := l_application_ref_id;
7912: p_application_ref_num := l_application_ref_num;
7913: p_secondary_application_ref_id := l_secondary_application_ref_id;
7914: /*--------------------------------+
7915: | Standard check of p_commit |
7916: +--------------------------------*/
7917:
7918: IF FND_API.To_Boolean( p_commit )
7919: THEN

Line 8022: -- Standard API parameters.

8018: );
8019: END Activity_application;
8020:
8021: PROCEDURE Activity_Unapplication(
8022: -- Standard API parameters.
8023: p_api_version IN NUMBER,
8024: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8025: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8026: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

Line 8057: | Standard start of API savepoint |

8053: l_applied_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
8054: l_refund_return_status VARCHAR2(1);
8055: BEGIN
8056: /*------------------------------------+
8057: | Standard start of API savepoint |
8058: +------------------------------------*/
8059:
8060: SAVEPOINT Activity_unapplication_PVT;
8061:

Line 8063: | Standard call to check for call compatibility |

8059:
8060: SAVEPOINT Activity_unapplication_PVT;
8061:
8062: /*--------------------------------------------------+
8063: | Standard call to check for call compatibility |
8064: +--------------------------------------------------*/
8065:
8066: IF NOT FND_API.Compatible_API_Call(
8067: l_api_version,

Line 8255: | Standard check of p_commit |

8251: END IF;
8252: END;
8253:
8254: /*--------------------------------+
8255: | Standard check of p_commit |
8256: +--------------------------------*/
8257:
8258: IF FND_API.To_Boolean( p_commit )
8259: THEN

Line 8361: -- Standard API parameters.

8357: );
8358: END Activity_unapplication;
8359:
8360: PROCEDURE Apply_other_account(
8361: -- Standard API parameters.
8362: p_api_version IN NUMBER,
8363: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8364: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8365: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

Line 8427: | Standard start of API savepoint |

8423:
8424: BEGIN
8425:
8426: /*------------------------------------+
8427: | Standard start of API savepoint |
8428: +------------------------------------*/
8429:
8430: SAVEPOINT Apply_other_ac_PVT;
8431:

Line 8433: | Standard call to check for call compatibility |

8429:
8430: SAVEPOINT Apply_other_ac_PVT;
8431:
8432: /*--------------------------------------------------+
8433: | Standard call to check for call compatibility |
8434: +--------------------------------------------------*/
8435:
8436: IF NOT FND_API.Compatible_API_Call(
8437: l_api_version,

Line 8760: | Standard check of p_commit |

8756: RAISE;
8757: END IF;
8758: END;
8759: /*--------------------------------+
8760: | Standard check of p_commit |
8761: +--------------------------------*/
8762:
8763: IF FND_API.To_Boolean( p_commit )
8764: THEN

Line 8856: -- Standard API parameters.

8852: );
8853: END;
8854:
8855: PROCEDURE create_misc(
8856: -- Standard API parameters.
8857: p_api_version IN NUMBER,
8858: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8859: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8860: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

Line 8979: | Standard start of API savepoint |

8975: l_global_attribute_rec := p_global_attribute_record;
8976: l_payment_trxn_extension_id := p_payment_trxn_extension_id; /* payment uptake */
8977:
8978: /*------------------------------------+
8979: | Standard start of API savepoint |
8980: +------------------------------------*/
8981:
8982: SAVEPOINT Create_misc_PVT;
8983:

Line 8985: | Standard call to check for call compatibility |

8981:
8982: SAVEPOINT Create_misc_PVT;
8983:
8984: /*--------------------------------------------------+
8985: | Standard call to check for call compatibility |
8986: +--------------------------------------------------*/
8987:
8988: IF NOT FND_API.Compatible_API_Call(
8989: l_api_version,

Line 9281: arp_standard.debug('calling copy Extension....');

9277: x_return_status := FND_API.G_RET_STS_ERROR;
9278: END IF;
9279:
9280: IF l_creation_method = 'A' THEN
9281: arp_standard.debug('calling copy Extension....');
9282: /* 5955921 */
9283: select pay_from_customer,customer_site_use_id
9284: into l_customer_id,l_customer_site_use_id
9285: from ar_cash_receipts

Line 9321: arp_standard.debug('calling copy Extension end ....');

9317: x_return_status := FND_API.G_RET_STS_ERROR;
9318: END IF;
9319: l_payment_trxn_extension_id := l_copy_pmt_trxn_extension_id;
9320:
9321: arp_standard.debug('calling copy Extension end ....');
9322: arp_standard.debug('calling copy Extension end ...2'|| to_char(l_copy_pmt_trxn_extension_id));
9323:
9324: END IF;
9325:

Line 9322: arp_standard.debug('calling copy Extension end ...2'|| to_char(l_copy_pmt_trxn_extension_id));

9318: END IF;
9319: l_payment_trxn_extension_id := l_copy_pmt_trxn_extension_id;
9320:
9321: arp_standard.debug('calling copy Extension end ....');
9322: arp_standard.debug('calling copy Extension end ...2'|| to_char(l_copy_pmt_trxn_extension_id));
9323:
9324: END IF;
9325:
9326:

Line 9333: arp_standard.debug('calling copy Extension end ....');

9329: IF p_called_from = 'CC_CHARGEBACK' THEN
9330:
9331: l_copy_pmt_trxn_extension_id := null;
9332: IF PG_DEBUG in ('Y','C') THEN
9333: arp_standard.debug('calling copy Extension end ....');
9334: END IF;
9335:
9336: END IF;
9337:

Line 9527: | Standard check of p_commit |

9523: );
9524:
9525:
9526: /*--------------------------------+
9527: | Standard check of p_commit |
9528: +--------------------------------*/
9529:
9530: IF FND_API.To_Boolean( p_commit )
9531: THEN

Line 9660: -- Standard API parameters.

9656:
9657: END set_profile_for_testing;
9658:
9659: PROCEDURE Apply_Open_Receipt(
9660: -- Standard API parameters.
9661: p_api_version IN NUMBER,
9662: p_init_msg_list IN VARCHAR2,
9663: p_commit IN VARCHAR2,
9664: p_validation_level IN NUMBER,

Line 9757: | Standard start of API savepoint |

9753:
9754: BEGIN
9755:
9756: /*------------------------------------+
9757: | Standard start of API savepoint |
9758: +------------------------------------*/
9759:
9760: SAVEPOINT Apply_Open_Receipt_PVT;
9761:

Line 9763: | Standard call to check for call compatibility |

9759:
9760: SAVEPOINT Apply_Open_Receipt_PVT;
9761:
9762: /*--------------------------------------------------+
9763: | Standard call to check for call compatibility |
9764: +--------------------------------------------------*/
9765:
9766: IF NOT FND_API.Compatible_API_Call(
9767: l_api_version,

Line 10191: | Standard check of p_commit |

10187: x_receivable_application_id := l_net_rec_app_id;
10188: x_applied_rec_app_id := l_open_net_rec_app_id;
10189:
10190: /*--------------------------------+
10191: | Standard check of p_commit |
10192: +--------------------------------*/
10193:
10194: IF FND_API.To_Boolean( p_commit )
10195: THEN

Line 10296: -- Standard API parameters.

10292:
10293: END Apply_Open_Receipt;
10294:
10295: PROCEDURE Unapply_Open_Receipt(
10296: -- Standard API parameters.
10297: p_api_version IN NUMBER,
10298: p_init_msg_list IN VARCHAR2,
10299: p_commit IN VARCHAR2,
10300: p_validation_level IN NUMBER,

Line 10326: | Standard start of API savepoint |

10322: l_org_id NUMBER;
10323:
10324: BEGIN
10325: /*------------------------------------+
10326: | Standard start of API savepoint |
10327: +------------------------------------*/
10328:
10329: SAVEPOINT Unapply_Open_Receipt_PVT;
10330:

Line 10332: | Standard call to check for call compatibility |

10328:
10329: SAVEPOINT Unapply_Open_Receipt_PVT;
10330:
10331: /*--------------------------------------------------+
10332: | Standard call to check for call compatibility |
10333: +--------------------------------------------------*/
10334:
10335: IF NOT FND_API.Compatible_API_Call(
10336: p_current_version_number => l_api_version,

Line 10475: | Standard check of p_commit |

10471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10472: END IF;
10473:
10474: /*--------------------------------+
10475: | Standard check of p_commit |
10476: +--------------------------------*/
10477:
10478: IF FND_API.To_Boolean( p_commit )
10479: THEN

Line 10616: -- Standard API parameters.

10612: |
10613: |
10614: *=======================================================================*/
10615: PROCEDURE Reverse_Remittances_in_err(
10616: -- Standard API parameters.
10617: p_api_version IN NUMBER,
10618: p_cash_receipts_id IN CR_ID_TABLE,
10619: p_called_from IN VARCHAR2 DEFAULT NULL,
10620: p_commit IN VARCHAR2 := FND_API.G_FALSE,

Line 10720: l_last_updated_by := arp_standard.profile.last_update_login ;

10716:
10717:
10718: /*Caching variables for setting who columns*/
10719: l_request_id_set := 'Y';
10720: l_last_updated_by := arp_standard.profile.last_update_login ;
10721: l_created_by := arp_standard.profile.user_id ;
10722: l_last_update_login := arp_standard.profile.last_update_login ;
10723: l_program_application_id := arp_standard.application_id ;
10724: l_program_id := arp_standard.profile.program_id;

Line 10721: l_created_by := arp_standard.profile.user_id ;

10717:
10718: /*Caching variables for setting who columns*/
10719: l_request_id_set := 'Y';
10720: l_last_updated_by := arp_standard.profile.last_update_login ;
10721: l_created_by := arp_standard.profile.user_id ;
10722: l_last_update_login := arp_standard.profile.last_update_login ;
10723: l_program_application_id := arp_standard.application_id ;
10724: l_program_id := arp_standard.profile.program_id;
10725: l_request_id := fnd_global.conc_request_id;

Line 10722: l_last_update_login := arp_standard.profile.last_update_login ;

10718: /*Caching variables for setting who columns*/
10719: l_request_id_set := 'Y';
10720: l_last_updated_by := arp_standard.profile.last_update_login ;
10721: l_created_by := arp_standard.profile.user_id ;
10722: l_last_update_login := arp_standard.profile.last_update_login ;
10723: l_program_application_id := arp_standard.application_id ;
10724: l_program_id := arp_standard.profile.program_id;
10725: l_request_id := fnd_global.conc_request_id;
10726:

Line 10723: l_program_application_id := arp_standard.application_id ;

10719: l_request_id_set := 'Y';
10720: l_last_updated_by := arp_standard.profile.last_update_login ;
10721: l_created_by := arp_standard.profile.user_id ;
10722: l_last_update_login := arp_standard.profile.last_update_login ;
10723: l_program_application_id := arp_standard.application_id ;
10724: l_program_id := arp_standard.profile.program_id;
10725: l_request_id := fnd_global.conc_request_id;
10726:
10727: IF l_request_id = -1 THEN

Line 10724: l_program_id := arp_standard.profile.program_id;

10720: l_last_updated_by := arp_standard.profile.last_update_login ;
10721: l_created_by := arp_standard.profile.user_id ;
10722: l_last_update_login := arp_standard.profile.last_update_login ;
10723: l_program_application_id := arp_standard.application_id ;
10724: l_program_id := arp_standard.profile.program_id;
10725: l_request_id := fnd_global.conc_request_id;
10726:
10727: IF l_request_id = -1 THEN
10728: l_request_id_set := 'N';

Line 10884: arp_standard.debug('Records for update: ' || 'COUNT = 0 and LAST FETCH ');

10880: END IF;
10881:
10882: IF (l_crh_upd.cash_receipt_history_id.COUNT = 0) AND (l_last_fetch) THEN
10883: IF PG_DEBUG in ('Y', 'C') THEN
10884: arp_standard.debug('Records for update: ' || 'COUNT = 0 and LAST FETCH ');
10885: END IF;
10886: EXIT;
10887: END IF;
10888: /*

Line 11223: arp_standard.profile.user_id,

11219: decode(sign(nvl(ard.amount_dr,0)- nvl(ard.amount_cr,0)),-1,ard.amount_cr,NULL),
11220: decode(sign(nvl(ard.amount_cr,0)- nvl(ard.amount_dr,0)),-1,ard.amount_dr,NULL),
11221: decode(sign(nvl(ard.acctd_amount_dr,0)- nvl(ard.acctd_amount_cr,0)),-1,ard.acctd_amount_cr,NULL),
11222: decode(sign(nvl(ard.acctd_amount_cr,0)- nvl(ard.acctd_amount_dr,0)),-1,ard.acctd_amount_dr,NULL),
11223: arp_standard.profile.user_id,
11224: SYSDATE,
11225: arp_standard.profile.user_id,
11226: SYSDATE,
11227: arp_standard.profile.last_update_login,

Line 11225: arp_standard.profile.user_id,

11221: decode(sign(nvl(ard.acctd_amount_dr,0)- nvl(ard.acctd_amount_cr,0)),-1,ard.acctd_amount_cr,NULL),
11222: decode(sign(nvl(ard.acctd_amount_cr,0)- nvl(ard.acctd_amount_dr,0)),-1,ard.acctd_amount_dr,NULL),
11223: arp_standard.profile.user_id,
11224: SYSDATE,
11225: arp_standard.profile.user_id,
11226: SYSDATE,
11227: arp_standard.profile.last_update_login,
11228: ard.source_id_secondary,
11229: ard.source_table_secondary,

Line 11227: arp_standard.profile.last_update_login,

11223: arp_standard.profile.user_id,
11224: SYSDATE,
11225: arp_standard.profile.user_id,
11226: SYSDATE,
11227: arp_standard.profile.last_update_login,
11228: ard.source_id_secondary,
11229: ard.source_table_secondary,
11230: ard.currency_code ,
11231: ard.currency_conversion_rate,

Line 11327: arp_standard.debug('process_events()+');

11323:
11324: BEGIN
11325:
11326: IF PG_DEBUG in ('Y', 'C') THEN
11327: arp_standard.debug('process_events()+');
11328: END IF;
11329:
11330: update ar_cash_receipts
11331: SET last_update_date = sysdate,

Line 11343: arp_standard.debug ( 'NO of Receipts updated = '|| to_char(SQL%ROWCOUNT));

11339: and org_id = p_org_id );
11340:
11341:
11342: IF PG_DEBUG in ('Y','C') THEN
11343: arp_standard.debug ( 'NO of Receipts updated = '|| to_char(SQL%ROWCOUNT));
11344: END IF;
11345:
11346: update ar_cash_receipt_history SET
11347: last_update_date = sysdate,

Line 11358: arp_standard.debug ( 'NO of Receipts updated CRH = '|| to_char(SQL%ROWCOUNT));

11354: and return_error_status = 'S'
11355: and org_id = p_org_id );
11356:
11357: IF PG_DEBUG in ('Y','C') THEN
11358: arp_standard.debug ( 'NO of Receipts updated CRH = '|| to_char(SQL%ROWCOUNT));
11359: END IF;
11360:
11361: update AR_payment_schedules SET
11362: last_update_date = sysdate,

Line 11373: arp_standard.debug ( 'NO of Receipts updated PS = '|| to_char(SQL%ROWCOUNT));

11369: and return_error_status = 'S'
11370: and org_id = p_org_id );
11371:
11372: IF PG_DEBUG in ('Y','C') THEN
11373: arp_standard.debug ( 'NO of Receipts updated PS = '|| to_char(SQL%ROWCOUNT));
11374: END IF;
11375:
11376: update ar_receivable_applications SET
11377: last_update_date = sysdate,

Line 11388: arp_standard.debug ( 'NO of RA updated = '|| to_char(SQL%ROWCOUNT));

11384: and return_error_status = 'S'
11385: and org_id = p_org_id );
11386:
11387: IF PG_DEBUG in ('Y','C') THEN
11388: arp_standard.debug ( 'NO of RA updated = '|| to_char(SQL%ROWCOUNT));
11389: END IF;
11390:
11391:
11392: select /*+ LEADING (GT) INDEX (GT AR_CREATE_RECEIPTS_GT_N2) USE_NL(GT RA)

Line 11410: arp_standard.debug ( 'Calling XLA event creation procedures for');

11406: and return_error_status = 'S'
11407: and gt.org_id = p_org_id ;
11408:
11409: IF PG_DEBUG in ('Y','C') THEN
11410: arp_standard.debug ( 'Calling XLA event creation procedures for');
11411: arp_standard.debug ( 'xla_req_id '|| p_request_id);
11412: arp_standard.debug ( 'xla_from_doc_id '|| l_from_doc_id);
11413: arp_standard.debug ( 'xla_to_doc_id '|| l_to_doc_id);
11414: arp_standard.debug ( 'l_from_ra_doc_id '|| l_from_ra_doc_id);

Line 11411: arp_standard.debug ( 'xla_req_id '|| p_request_id);

11407: and gt.org_id = p_org_id ;
11408:
11409: IF PG_DEBUG in ('Y','C') THEN
11410: arp_standard.debug ( 'Calling XLA event creation procedures for');
11411: arp_standard.debug ( 'xla_req_id '|| p_request_id);
11412: arp_standard.debug ( 'xla_from_doc_id '|| l_from_doc_id);
11413: arp_standard.debug ( 'xla_to_doc_id '|| l_to_doc_id);
11414: arp_standard.debug ( 'l_from_ra_doc_id '|| l_from_ra_doc_id);
11415: arp_standard.debug ( 'l_to_ra_doc_id '|| l_to_ra_doc_id);

Line 11412: arp_standard.debug ( 'xla_from_doc_id '|| l_from_doc_id);

11408:
11409: IF PG_DEBUG in ('Y','C') THEN
11410: arp_standard.debug ( 'Calling XLA event creation procedures for');
11411: arp_standard.debug ( 'xla_req_id '|| p_request_id);
11412: arp_standard.debug ( 'xla_from_doc_id '|| l_from_doc_id);
11413: arp_standard.debug ( 'xla_to_doc_id '|| l_to_doc_id);
11414: arp_standard.debug ( 'l_from_ra_doc_id '|| l_from_ra_doc_id);
11415: arp_standard.debug ( 'l_to_ra_doc_id '|| l_to_ra_doc_id);
11416: END IF;

Line 11413: arp_standard.debug ( 'xla_to_doc_id '|| l_to_doc_id);

11409: IF PG_DEBUG in ('Y','C') THEN
11410: arp_standard.debug ( 'Calling XLA event creation procedures for');
11411: arp_standard.debug ( 'xla_req_id '|| p_request_id);
11412: arp_standard.debug ( 'xla_from_doc_id '|| l_from_doc_id);
11413: arp_standard.debug ( 'xla_to_doc_id '|| l_to_doc_id);
11414: arp_standard.debug ( 'l_from_ra_doc_id '|| l_from_ra_doc_id);
11415: arp_standard.debug ( 'l_to_ra_doc_id '|| l_to_ra_doc_id);
11416: END IF;
11417:

Line 11414: arp_standard.debug ( 'l_from_ra_doc_id '|| l_from_ra_doc_id);

11410: arp_standard.debug ( 'Calling XLA event creation procedures for');
11411: arp_standard.debug ( 'xla_req_id '|| p_request_id);
11412: arp_standard.debug ( 'xla_from_doc_id '|| l_from_doc_id);
11413: arp_standard.debug ( 'xla_to_doc_id '|| l_to_doc_id);
11414: arp_standard.debug ( 'l_from_ra_doc_id '|| l_from_ra_doc_id);
11415: arp_standard.debug ( 'l_to_ra_doc_id '|| l_to_ra_doc_id);
11416: END IF;
11417:
11418: /* Create events for the receipts associated to this request id and given range*/

Line 11415: arp_standard.debug ( 'l_to_ra_doc_id '|| l_to_ra_doc_id);

11411: arp_standard.debug ( 'xla_req_id '|| p_request_id);
11412: arp_standard.debug ( 'xla_from_doc_id '|| l_from_doc_id);
11413: arp_standard.debug ( 'xla_to_doc_id '|| l_to_doc_id);
11414: arp_standard.debug ( 'l_from_ra_doc_id '|| l_from_ra_doc_id);
11415: arp_standard.debug ( 'l_to_ra_doc_id '|| l_to_ra_doc_id);
11416: END IF;
11417:
11418: /* Create events for the receipts associated to this request id and given range*/
11419: l_xla_ev_rec.xla_doc_table := 'CRHAPP';

Line 11447: arp_standard.debug('process_events()-');

11443:
11444: arp_xla_events.Create_Events( l_xla_ev_rec );
11445:
11446: IF PG_DEBUG in ('Y', 'C') THEN
11447: arp_standard.debug('process_events()-');
11448: END IF;
11449:
11450: EXCEPTION
11451: WHEN others THEN

Line 11487: -- Standard API parameters.

11483: |
11484: |
11485: *=======================================================================*/
11486: PROCEDURE Create_Cash_Bulk(
11487: -- Standard API parameters.
11488: p_api_version IN NUMBER DEFAULT 1.0,
11489: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
11490: p_commit IN VARCHAR2 := FND_API.G_FALSE,
11491: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

Line 11575: arp_standard.debug('Create_Cash_Bulk()+');

11571: P_CALLED_FROM varchar2(30);
11572:
11573: BEGIN
11574: IF PG_DEBUG in ('Y', 'C') THEN
11575: arp_standard.debug('Create_Cash_Bulk()+');
11576: END IF;
11577:
11578: FOR org_rec IN org_cur LOOP
11579: /*code to set the org context for the batch,will avoid the org setting for

Line 11606: arp_standard.debug('Opening receipt cursor for org '||org_rec.org_id );

11602: l_bulk_count := MAX_ARRAY_SIZE ;
11603: END IF;
11604:
11605: IF PG_DEBUG in ('Y', 'C') THEN
11606: arp_standard.debug('Opening receipt cursor for org '||org_rec.org_id );
11607: END IF;
11608:
11609: OPEN create_rcpt_cursor( org_rec.org_id );
11610: LOOP

Line 11614: arp_standard.debug('current fetch count '|| l_rcpt_info_tab.count);

11610: LOOP
11611: FETCH create_rcpt_cursor BULK COLLECT INTO l_rcpt_info_tab LIMIT l_bulk_count;
11612:
11613: IF PG_DEBUG in ('Y', 'C') THEN
11614: arp_standard.debug('current fetch count '|| l_rcpt_info_tab.count);
11615: END IF;
11616:
11617: IF l_rcpt_info_tab.count = 0 THEN
11618: EXIT;

Line 11631: arp_standard.debug('Value of l_gt_id '|| l_gt_id );

11627: The field gt_id is used for logically seperating the data among different batches.*/
11628: l_gt_id := nvl(l_gt_id,0) + 1;
11629:
11630: IF PG_DEBUG in ('Y', 'C') THEN
11631: arp_standard.debug('Value of l_gt_id '|| l_gt_id );
11632: END IF;
11633:
11634:
11635: --reset the error index. Clearing all the junk data from record type

Line 11712: -- Standard API parameters.

11708: l_global_attribute_rec.global_attribute15 := l_rcpt_info_tab(i).GLOBAL_ATTRIBUTE15;
11709:
11710: --call the internal routine
11711: Create_cash_1(
11712: -- Standard API parameters.
11713: p_api_version ,
11714: p_init_msg_list,
11715: p_commit,
11716: p_validation_level,

Line 11776: arp_standard.debug('Return Status ' || l_return_status);

11772: l_cash_receipt_id
11773: );
11774:
11775: IF PG_DEBUG in ('Y', 'C') THEN
11776: arp_standard.debug('Return Status ' || l_return_status);
11777: arp_standard.debug('Cash Receipts ID '|| l_cash_receipt_id);
11778: END IF;
11779:
11780: l_cash_receipt_info_rec.receipt_number(l_cash_receipt_index) := l_rcpt_info_tab(i).receipt_number;

Line 11777: arp_standard.debug('Cash Receipts ID '|| l_cash_receipt_id);

11773: );
11774:
11775: IF PG_DEBUG in ('Y', 'C') THEN
11776: arp_standard.debug('Return Status ' || l_return_status);
11777: arp_standard.debug('Cash Receipts ID '|| l_cash_receipt_id);
11778: END IF;
11779:
11780: l_cash_receipt_info_rec.receipt_number(l_cash_receipt_index) := l_rcpt_info_tab(i).receipt_number;
11781: l_cash_receipt_info_rec.receipt_date(l_cash_receipt_index) := l_rcpt_info_tab(i).receipt_date;

Line 11800: arp_standard.debug ( 'the message data is ' || l_msg_data );

11796: IF l_msg_count = 1 THEN
11797:
11798: IF PG_DEBUG in ('Y', 'C') THEN
11799: arp_util.debug('l_msg_count '||l_msg_count);
11800: arp_standard.debug ( 'the message data is ' || l_msg_data );
11801: END IF;
11802:
11803: l_rcpt_error_info_tab.receipt_number(l_err_rcpt_index) := l_rcpt_info_tab(i).receipt_number;
11804: l_rcpt_error_info_tab.receipt_date(l_err_rcpt_index) := l_rcpt_info_tab(i).receipt_date;

Line 11821: arp_standard.debug ( 'the number is ' || l_count );

11817:
11818: l_msg_data :=FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
11819:
11820: IF PG_DEBUG in ('Y', 'C') THEN
11821: arp_standard.debug ( 'the number is ' || l_count );
11822: arp_standard.debug ( 'the message data is ' || l_msg_data );
11823: END IF;
11824:
11825: IF l_msg_data IS NOT NULL THEN

Line 11822: arp_standard.debug ( 'the message data is ' || l_msg_data );

11818: l_msg_data :=FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
11819:
11820: IF PG_DEBUG in ('Y', 'C') THEN
11821: arp_standard.debug ( 'the number is ' || l_count );
11822: arp_standard.debug ( 'the message data is ' || l_msg_data );
11823: END IF;
11824:
11825: IF l_msg_data IS NOT NULL THEN
11826: l_rcpt_error_info_tab.receipt_number(l_err_rcpt_index) := l_rcpt_info_tab(i).receipt_number;

Line 11896: arp_standard.debug('Create_Cash_Bulk()-');

11892: END LOOP;--main select cursor loop
11893: END LOOP; --org id cursor
11894:
11895: IF PG_DEBUG in ('Y', 'C') THEN
11896: arp_standard.debug('Create_Cash_Bulk()-');
11897: END IF;
11898:
11899: EXCEPTION
11900: WHEN others THEN

Line 11902: arp_standard.debug('Exception : Create_Cash_Bulk() '|| SQLERRM);

11898:
11899: EXCEPTION
11900: WHEN others THEN
11901: IF PG_DEBUG in ('Y', 'C') THEN
11902: arp_standard.debug('Exception : Create_Cash_Bulk() '|| SQLERRM);
11903: END IF;
11904: END Create_Cash_Bulk;
11905:
11906: /* Bug 5165826: Added following procedure for TM enhancement 4696620 */

Line 11909: -- Standard API parameters.

11905:
11906: /* Bug 5165826: Added following procedure for TM enhancement 4696620 */
11907:
11908: PROCEDURE Change_customer(
11909: -- Standard API parameters.
11910: p_api_version IN NUMBER,
11911: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
11912: p_commit IN VARCHAR2 := FND_API.G_FALSE,
11913: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

Line 11936: | Standard start of API savepoint |

11932:
11933: BEGIN
11934:
11935: /*------------------------------------+
11936: | Standard start of API savepoint |
11937: +------------------------------------*/
11938:
11939: SAVEPOINT Change_customer_PVT;
11940:

Line 11942: | Standard call to check for call compatibility |

11938:
11939: SAVEPOINT Change_customer_PVT;
11940:
11941: /*--------------------------------------------------+
11942: | Standard call to check for call compatibility |
11943: +--------------------------------------------------*/
11944:
11945: IF NOT FND_API.Compatible_API_Call(
11946: l_api_version,

Line 11979: arp_standard.init_standard;

11975: /*-------------------------------------------------+
11976: | Initialize SOB/org dependent variables |
11977: +-------------------------------------------------*/
11978: arp_global.init_global;
11979: arp_standard.init_standard;
11980:
11981: /*-----------------------------------------+
11982: | Initialize return status to SUCCESS |
11983: +-----------------------------------------*/

Line 12113: arp_standard.debug('Change_customer: ' || 'Unexpected error '||sqlerrm||

12109: AND receivable_application_id = l_receivable_application_id;
12110:
12111: EXCEPTION
12112: WHEN OTHERS THEN
12113: arp_standard.debug('Change_customer: ' || 'Unexpected error '||sqlerrm||
12114: ' at AR_RECEIPT_API_PUB.Change_customer()+');
12115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12116: IF FND_MSG_PUB.Check_Msg_Level
12117: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)