DBA Data[Home] [Help]

APPS.AR_AUTOREM_API dependencies on FND_API

Line 3659: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

3655: -- rct_info rct_info_cur%ROWTYPE;
3656: l_cr_rec ar_cash_receipts_all%ROWTYPE;
3657: l_org_type HR_ALL_ORGANIZATION_UNITS.TYPE%TYPE;
3658: l_action VARCHAR2(80);
3659: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3660: l_msg_count NUMBER;
3661: l_msg_data VARCHAR2(2000);
3662:
3663: l_payment_trxn_extension_id NUMBER;

Line 3687: ls_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

3683:
3684:
3685: /* declare variables for settlement */
3686:
3687: ls_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3688: ls_msg_count NUMBER;
3689: ls_msg_data VARCHAR2(2000);
3690: ls_response_rec_tab IBY_FNDCPT_TRXN_PUB.SettlementResult_tbl_type;
3691: ls_iby_msg_data VARCHAR2(2000);

Line 3704: lc_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

3700:
3701:
3702: lc_payer_rec IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
3703: lc_amount_rec IBY_FNDCPT_TRXN_PUB.Amount_rec_type;
3704: lc_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3705: lc_msg_count NUMBER;
3706: lc_msg_data VARCHAR2(2000);
3707: lc_iby_msg_data VARCHAR2(2000);
3708: lc_response_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;

Line 3872: p_init_msg_list => FND_API.G_TRUE,

3868:
3869: BEGIN
3870: IBY_FNDCPT_TRXN_PUB.Create_Authorization(
3871: p_api_version => 1.0,
3872: p_init_msg_list => FND_API.G_TRUE,
3873: x_return_status => l_return_status,
3874: x_msg_count => l_msg_count,
3875: x_msg_data => l_msg_data,
3876: p_payer => l_payer_rec,

Line 3894: SUBSTR(fnd_msg_pub.get(p_msg_index => i,p_encoded => FND_API.G_FALSE),1,150) || '>');

3890: fnd_file.put_line(FND_FILE.LOG,'x_msg_count :<' || l_msg_count || '>');
3891:
3892: FOR i IN 1..l_msg_count LOOP
3893: fnd_file.put_line(FND_FILE.LOG,'x_msg #' || TO_CHAR(i) || ' = <' ||
3894: SUBSTR(fnd_msg_pub.get(p_msg_index => i,p_encoded => FND_API.G_FALSE),1,150) || '>');
3895: END LOOP;
3896:
3897: IF PG_DEBUG in ('Y', 'C') THEN
3898: fnd_file.put_line(FND_FILE.LOG, '-------------------------------------');

Line 3912: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

3908: fnd_file.put_line(FND_FILE.LOG, 'l_authresult_rec.PaymentSys_Msg: ' || l_authresult_rec.PaymentSys_Msg);
3909:
3910: END IF;
3911:
3912: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3913:
3914: fnd_file.put_line(FND_FILE.LOG,'the value of auth_id is = ' || (l_authresult_rec.Auth_Id));
3915:
3916: END IF;

Line 3919: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

3915:
3916: END IF;
3917:
3918:
3919: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3920: G_ERROR := 'Y' ;
3921:
3922: FND_MESSAGE.set_name('AR', 'AR_CC_AUTH_FAILED');
3923: FND_MSG_PUB.Add;

Line 4075: p_init_msg_list => FND_API.G_TRUE,

4071:
4072: BEGIN
4073: IBY_FNDCPT_TRXN_PUB.Create_Return(
4074: p_api_version => 1.0,
4075: p_init_msg_list => FND_API.G_TRUE,
4076: x_return_status => lc_return_status,
4077: x_msg_count => lc_msg_count,
4078: x_msg_data => lc_msg_data,
4079: p_payer => lc_payer_rec,

Line 4094: SUBSTR(fnd_msg_pub.get(p_msg_index => i,p_encoded => FND_API.G_FALSE),1,150) || '>');

4090: fnd_file.put_line(FND_FILE.LOG,'x_msg_count :<' || lc_msg_count || '>');
4091:
4092: FOR i IN 1..lc_msg_count LOOP
4093: fnd_file.put_line(FND_FILE.LOG,'x_msg #' || TO_CHAR(i) || ' = <' ||
4094: SUBSTR(fnd_msg_pub.get(p_msg_index => i,p_encoded => FND_API.G_FALSE),1,150) || '>');
4095: END LOOP;
4096:
4097: IF PG_DEBUG in ('Y', 'C') THEN
4098: fnd_file.put_line(FND_FILE.LOG, '-------------------------------------');

Line 4104: IF (lc_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

4100: fnd_file.put_line(FND_FILE.LOG, 'l_response_rec.Result_Category: ' || lc_response_rec.Result_Category);
4101: fnd_file.put_line(FND_FILE.LOG, 'l_response_rec.Result_message : ' || lc_response_rec.Result_message );
4102: END IF;
4103:
4104: IF (lc_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4105:
4106:
4107: G_ERROR := 'Y' ;
4108:

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

4145: program_id = l_program_id,
4146: program_update_date = sysdate
4147: WHERE cash_receipt_id = rct_info.cash_receipt_id;
4148:
4149: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
4150: p_count => x_msg_count,
4151: p_data => x_msg_data );
4152:
4153: x_return_status := lc_return_status;

Line 4214: p_init_msg_list => FND_API.G_TRUE,

4210: END IF;
4211:
4212: IBY_FNDCPT_TRXN_PUB.Create_Settlements(
4213: p_api_version => 1.0,
4214: p_init_msg_list => FND_API.G_TRUE,
4215: p_calling_app_id => l_program_application_id,
4216: p_calling_app_request_code => 'AR_'||p_batch_id||'_'||WORKER_NUMBER,
4217: p_order_view_name => 'AR_FUNDS_CAPTURE_ORDERS_V',
4218: x_return_status => ls_return_status,

Line 4229: SUBSTR(fnd_msg_pub.get(p_msg_index => i,p_encoded => FND_API.G_FALSE),1,150) || '>');

4225: fnd_file.put_line(FND_FILE.LOG,'x_msg_count :<' || ls_msg_count || '>');
4226:
4227: FOR i IN 1..ls_msg_count LOOP
4228: fnd_file.put_line(FND_FILE.LOG,'x_msg #' || TO_CHAR(i) || ' = <' ||
4229: SUBSTR(fnd_msg_pub.get(p_msg_index => i,p_encoded => FND_API.G_FALSE),1,150) || '>');
4230: END LOOP;
4231:
4232: IF PG_DEBUG in ('Y', 'C') THEN
4233:

Line 4248: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

4244:
4245: END IF;
4246:
4247:
4248: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4249:
4250: FOR i IN ls_response_rec_tab.FIRST..ls_response_rec_tab.LAST LOOP
4251:
4252: fnd_file.put_line(FND_FILE.LOG,'the value of ls_response_rec.Trxn_Extension_Id = ' || (ls_response_rec_tab(i).Trxn_Extension_Id ));

Line 4413: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

4409: -- rct_info rct_info_cur%ROWTYPE;
4410: l_cr_rec ar_cash_receipts_all%ROWTYPE;
4411: l_org_type HR_ALL_ORGANIZATION_UNITS.TYPE%TYPE;
4412: l_action VARCHAR2(80);
4413: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4414: l_msg_count NUMBER;
4415: l_msg_data VARCHAR2(2000);
4416:
4417: l_payment_trxn_extension_id NUMBER;

Line 4442: ls_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

4438:
4439:
4440: /* declare variables for settlement */
4441:
4442: ls_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4443: ls_msg_count NUMBER;
4444: ls_msg_data VARCHAR2(2000);
4445: ls_response_rec_tab IBY_FNDCPT_TRXN_PUB.SettlementResult_tbl_type;
4446: ls_iby_msg_data VARCHAR2(2000);

Line 4460: lc_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

4456: lcr_receipt_attr IBY_FNDCPT_TRXN_PUB.receiptattribs_rec_type;
4457:
4458: lc_payer_rec IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
4459: lc_amount_rec IBY_FNDCPT_TRXN_PUB.Amount_rec_type;
4460: lc_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4461: lc_msg_count NUMBER;
4462: lc_msg_data VARCHAR2(2000);
4463: lc_iby_msg_data VARCHAR2(2000);
4464: lc_response_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;

Line 4618: p_init_msg_list => FND_API.G_TRUE,

4614:
4615: BEGIN
4616: IBY_FNDCPT_TRXN_PUB.Create_Authorization(
4617: p_api_version => 1.0,
4618: p_init_msg_list => FND_API.G_TRUE,
4619: x_return_status => l_return_status,
4620: x_msg_count => l_msg_count,
4621: x_msg_data => l_msg_data,
4622: p_payer => l_payer_rec,

Line 4642: SUBSTR(fnd_msg_pub.get(p_msg_index => i,p_encoded => FND_API.G_FALSE),1,150) || '>');

4638: END IF;
4639:
4640: FOR i IN 1..l_msg_count LOOP
4641: fnd_file.put_line(FND_FILE.LOG,'x_msg #' || TO_CHAR(i) || ' = <' ||
4642: SUBSTR(fnd_msg_pub.get(p_msg_index => i,p_encoded => FND_API.G_FALSE),1,150) || '>');
4643: END LOOP;
4644:
4645: IF PG_DEBUG in ('Y', 'C') THEN
4646: fnd_file.put_line(FND_FILE.LOG, '-------------------------------------');

Line 4660: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

4656: fnd_file.put_line(FND_FILE.LOG, 'l_authresult_rec.PaymentSys_Msg: ' || l_authresult_rec.PaymentSys_Msg);
4657:
4658: END IF;
4659:
4660: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4661:
4662: IF PG_DEBUG in ('Y', 'C') THEN
4663: fnd_file.put_line(FND_FILE.LOG,'the value of auth_id is = ' || (l_authresult_rec.Auth_Id));
4664: END IF;

Line 4669: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

4665:
4666: END IF;
4667:
4668:
4669: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4670: G_ERROR := 'Y' ;
4671:
4672: FND_MESSAGE.set_name('AR', 'AR_CC_AUTH_FAILED');
4673: FND_MSG_PUB.Add;

Line 4839: p_init_msg_list => FND_API.G_TRUE,

4835:
4836: BEGIN
4837: IBY_FNDCPT_TRXN_PUB.Create_Return(
4838: p_api_version => 1.0,
4839: p_init_msg_list => FND_API.G_TRUE,
4840: x_return_status => lc_return_status,
4841: x_msg_count => lc_msg_count,
4842: x_msg_data => lc_msg_data,
4843: p_payer => lc_payer_rec,

Line 4859: SUBSTR(fnd_msg_pub.get(p_msg_index => i,p_encoded => FND_API.G_FALSE),1,150) || '>');

4855: fnd_file.put_line(FND_FILE.LOG,'x_msg_count :<' || lc_msg_count || '>');
4856:
4857: FOR i IN 1..lc_msg_count LOOP
4858: fnd_file.put_line(FND_FILE.LOG,'x_msg #' || TO_CHAR(i) || ' = <' ||
4859: SUBSTR(fnd_msg_pub.get(p_msg_index => i,p_encoded => FND_API.G_FALSE),1,150) || '>');
4860: END LOOP;
4861: END IF;
4862:
4863: IF PG_DEBUG in ('Y', 'C') THEN

Line 4870: IF (lc_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

4866: fnd_file.put_line(FND_FILE.LOG, 'l_response_rec.Result_Category: ' || lc_response_rec.Result_Category);
4867: fnd_file.put_line(FND_FILE.LOG, 'l_response_rec.Result_message : ' || lc_response_rec.Result_message );
4868: END IF;
4869:
4870: IF (lc_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4871:
4872:
4873: G_ERROR := 'Y' ;
4874:

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

4917: program_id = l_program_id,
4918: program_update_date = sysdate
4919: WHERE cash_receipt_id = rct_info.cash_receipt_id;
4920:
4921: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
4922: p_count => x_msg_count,
4923: p_data => x_msg_data );
4924:
4925: x_return_status := lc_return_status;

Line 4990: p_init_msg_list => FND_API.G_TRUE,

4986: END IF;
4987:
4988: IBY_FNDCPT_TRXN_PUB.Create_Settlements(
4989: p_api_version => 1.0,
4990: p_init_msg_list => FND_API.G_TRUE,
4991: p_calling_app_id => l_program_application_id,
4992: p_calling_app_request_code => 'AR_'||p_batch_id||'_'||WORKER_NUMBER,
4993: p_order_view_name => 'AR_FUNDS_CAPTURE_ORDERS_V',
4994: x_return_status => ls_return_status,

Line 5006: SUBSTR(fnd_msg_pub.get(p_msg_index => i,p_encoded => FND_API.G_FALSE),1,150) || '>');

5002: fnd_file.put_line(FND_FILE.LOG,'x_msg_count :<' || ls_msg_count || '>');
5003:
5004: FOR i IN 1..ls_msg_count LOOP
5005: fnd_file.put_line(FND_FILE.LOG,'x_msg #' || TO_CHAR(i) || ' = <' ||
5006: SUBSTR(fnd_msg_pub.get(p_msg_index => i,p_encoded => FND_API.G_FALSE),1,150) || '>');
5007: END LOOP;
5008: END IF;
5009:
5010: IF PG_DEBUG in ('Y', 'C') THEN

Line 5026: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

5022:
5023: END IF;
5024:
5025:
5026: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5027:
5028: FOR i IN ls_response_rec_tab.FIRST..ls_response_rec_tab.LAST LOOP
5029: IF PG_DEBUG in ('Y', 'C') THEN
5030: fnd_file.put_line(FND_FILE.LOG,'the value of ls_response_rec.Trxn_Extension_Id = ' || (ls_response_rec_tab(i).Trxn_Extension_Id ));