DBA Data[Home] [Help]

APPS.AR_AUTOREM_API dependencies on FND_API

Line 2874: p_return_status := FND_API.G_RET_STS_SUCCESS;

2870: IF PG_DEBUG in ('Y','C')
2871: THEN
2872: fnd_file.put_line(FND_FILE.LOG,'No rows to process. Ending worker');
2873: END IF;
2874: p_return_status := FND_API.G_RET_STS_SUCCESS;
2875: RETURN;
2876: END IF;
2877:
2878: -- Bulk Insert into AR_REMIT_GT

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

3950: -- rct_info rct_info_cur%ROWTYPE;
3951: l_cr_rec ar_cash_receipts_all%ROWTYPE;
3952: l_org_type HR_ALL_ORGANIZATION_UNITS.TYPE%TYPE;
3953: l_action VARCHAR2(80);
3954: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3955: l_msg_count NUMBER;
3956: l_msg_data VARCHAR2(2000);
3957: pl_msg_data VARCHAR2(240);
3958: l_payment_trxn_extension_id NUMBER;

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

3978:
3979:
3980: /* declare variables for settlement */
3981:
3982: ls_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3983: ls_msg_count NUMBER;
3984: ls_msg_data VARCHAR2(2000);
3985: ls_response_rec_tab IBY_FNDCPT_TRXN_PUB.SettlementResult_tbl_type;
3986: ls_iby_msg_data VARCHAR2(2000);

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

3995:
3996:
3997: lc_payer_rec IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
3998: lc_amount_rec IBY_FNDCPT_TRXN_PUB.Amount_rec_type;
3999: lc_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4000: lc_msg_count NUMBER;
4001: lc_msg_data VARCHAR2(2000);
4002: lc_iby_msg_data VARCHAR2(2000);
4003: lc_response_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;

Line 4144: p_init_msg_list => FND_API.G_TRUE,

4140: fnd_file.put_line(FND_FILE.LOG, 'Before Call Create_Authorization()+');
4141:
4142: IBY_FNDCPT_TRXN_PUB.Create_Authorization(
4143: p_api_version => 1.0,
4144: p_init_msg_list => FND_API.G_TRUE,
4145: x_return_status => l_return_status,
4146: x_msg_count => l_msg_count,
4147: x_msg_data => l_msg_data,
4148: p_payer => l_payer_rec,

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

4164:
4165: FOR i IN 1..l_msg_count LOOP
4166:
4167: fnd_file.put_line(FND_FILE.LOG,'x_msg #' || TO_CHAR(i) || ' = <' ||
4168: SUBSTR(fnd_msg_pub.get(p_msg_index => i,p_encoded => FND_API.G_FALSE),1,150) || '>');
4169:
4170: IF i <= 2 THEN
4171: pl_msg_data := SUBSTR(fnd_msg_pub.get(p_msg_index => i,p_encoded => FND_API.G_FALSE),1,240) ;
4172: END if;

Line 4171: pl_msg_data := SUBSTR(fnd_msg_pub.get(p_msg_index => i,p_encoded => FND_API.G_FALSE),1,240) ;

4167: fnd_file.put_line(FND_FILE.LOG,'x_msg #' || TO_CHAR(i) || ' = <' ||
4168: SUBSTR(fnd_msg_pub.get(p_msg_index => i,p_encoded => FND_API.G_FALSE),1,150) || '>');
4169:
4170: IF i <= 2 THEN
4171: pl_msg_data := SUBSTR(fnd_msg_pub.get(p_msg_index => i,p_encoded => FND_API.G_FALSE),1,240) ;
4172: END if;
4173:
4174: END LOOP;
4175:

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

4187: fnd_file.put_line(FND_FILE.LOG, 'l_authresult_rec.PaymentSys_Msg: ' || l_authresult_rec.PaymentSys_Msg);
4188:
4189: END IF;
4190:
4191: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4192:
4193: fnd_file.put_line(FND_FILE.LOG,'the value of auth_id is = ' || (l_authresult_rec.Auth_Id));
4194:
4195: END IF;

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

4194:
4195: END IF;
4196:
4197:
4198: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4199: G_ERROR := 'Y' ;
4200:
4201: FND_MESSAGE.set_name('AR', 'AR_CC_AUTH_FAILED');
4202: FND_MSG_PUB.Add;

Line 4354: p_init_msg_list => FND_API.G_TRUE,

4350:
4351: BEGIN
4352: IBY_FNDCPT_TRXN_PUB.Create_Return(
4353: p_api_version => 1.0,
4354: p_init_msg_list => FND_API.G_TRUE,
4355: x_return_status => lc_return_status,
4356: x_msg_count => lc_msg_count,
4357: x_msg_data => lc_msg_data,
4358: p_payer => lc_payer_rec,

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

4369: fnd_file.put_line(FND_FILE.LOG,'x_msg_count :<' || lc_msg_count || '>');
4370:
4371: FOR i IN 1..lc_msg_count LOOP
4372: fnd_file.put_line(FND_FILE.LOG,'x_msg #' || TO_CHAR(i) || ' = <' ||
4373: SUBSTR(fnd_msg_pub.get(p_msg_index => i,p_encoded => FND_API.G_FALSE),1,150) || '>');
4374:
4375: IF i <= 2 THEN
4376: pl_msg_data := SUBSTR(fnd_msg_pub.get(p_msg_index => i,p_encoded => FND_API.G_FALSE),1,240) ;
4377: END if;

Line 4376: pl_msg_data := SUBSTR(fnd_msg_pub.get(p_msg_index => i,p_encoded => FND_API.G_FALSE),1,240) ;

4372: fnd_file.put_line(FND_FILE.LOG,'x_msg #' || TO_CHAR(i) || ' = <' ||
4373: SUBSTR(fnd_msg_pub.get(p_msg_index => i,p_encoded => FND_API.G_FALSE),1,150) || '>');
4374:
4375: IF i <= 2 THEN
4376: pl_msg_data := SUBSTR(fnd_msg_pub.get(p_msg_index => i,p_encoded => FND_API.G_FALSE),1,240) ;
4377: END if;
4378:
4379: END LOOP;
4380:

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

4384: fnd_file.put_line(FND_FILE.LOG, 'l_response_rec.Result_Category: ' || lc_response_rec.Result_Category);
4385: fnd_file.put_line(FND_FILE.LOG, 'l_response_rec.Result_message : ' || lc_response_rec.Result_message );
4386: END IF;
4387:
4388: IF (lc_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4389:
4390:
4391: G_ERROR := 'Y' ;
4392:

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

4429: program_id = l_program_id,
4430: program_update_date = sysdate
4431: WHERE cash_receipt_id = rct_info.cash_receipt_id;
4432:
4433: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
4434: p_count => x_msg_count,
4435: p_data => x_msg_data );
4436:
4437: x_return_status := lc_return_status;

Line 4498: p_init_msg_list => FND_API.G_TRUE,

4494: END IF;
4495:
4496: IBY_FNDCPT_TRXN_PUB.Create_Settlements(
4497: p_api_version => 1.0,
4498: p_init_msg_list => FND_API.G_TRUE,
4499: p_calling_app_id => l_program_application_id,
4500: p_calling_app_request_code => 'AR_'||p_batch_id||'_'||WORKER_NUMBER,
4501: p_order_view_name => 'AR_FUNDS_CAPTURE_ORDERS_V',
4502: x_return_status => ls_return_status,

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

4509: fnd_file.put_line(FND_FILE.LOG,'x_msg_count :<' || ls_msg_count || '>');
4510:
4511: FOR i IN 1..ls_msg_count LOOP
4512: fnd_file.put_line(FND_FILE.LOG,'x_msg #' || TO_CHAR(i) || ' = <' ||
4513: SUBSTR(fnd_msg_pub.get(p_msg_index => i,p_encoded => FND_API.G_FALSE),1,150) || '>');
4514: END LOOP;
4515:
4516: IF PG_DEBUG in ('Y', 'C') THEN
4517:

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

4528:
4529: END IF;
4530:
4531:
4532: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4533:
4534: FOR i IN ls_response_rec_tab.FIRST..ls_response_rec_tab.LAST LOOP
4535:
4536: 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 4711: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

4707: -- rct_info rct_info_cur%ROWTYPE;
4708: l_cr_rec ar_cash_receipts_all%ROWTYPE;
4709: l_org_type HR_ALL_ORGANIZATION_UNITS.TYPE%TYPE;
4710: l_action VARCHAR2(80);
4711: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4712: l_msg_count NUMBER;
4713: l_msg_data VARCHAR2(2000);
4714: pl_msg_data VARCHAR2(240);
4715: l_payment_trxn_extension_id NUMBER;

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

4736:
4737:
4738: /* declare variables for settlement */
4739:
4740: ls_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4741: ls_msg_count NUMBER;
4742: ls_msg_data VARCHAR2(2000);
4743: ls_response_rec_tab IBY_FNDCPT_TRXN_PUB.SettlementResult_tbl_type;
4744: ls_iby_msg_data VARCHAR2(2000);

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

4754: lcr_receipt_attr IBY_FNDCPT_TRXN_PUB.receiptattribs_rec_type;
4755:
4756: lc_payer_rec IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
4757: lc_amount_rec IBY_FNDCPT_TRXN_PUB.Amount_rec_type;
4758: lc_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4759: lc_msg_count NUMBER;
4760: lc_msg_data VARCHAR2(2000);
4761: lc_iby_msg_data VARCHAR2(2000);
4762: lc_response_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;

Line 4889: p_init_msg_list => FND_API.G_TRUE,

4885:
4886: BEGIN
4887: IBY_FNDCPT_TRXN_PUB.Create_Authorization(
4888: p_api_version => 1.0,
4889: p_init_msg_list => FND_API.G_TRUE,
4890: x_return_status => l_return_status,
4891: x_msg_count => l_msg_count,
4892: x_msg_data => l_msg_data,
4893: p_payer => l_payer_rec,

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

4909: END IF;
4910:
4911: FOR i IN 1..l_msg_count LOOP
4912: fnd_file.put_line(FND_FILE.LOG,'x_msg #' || TO_CHAR(i) || ' = <' ||
4913: SUBSTR(fnd_msg_pub.get(p_msg_index => i,p_encoded => FND_API.G_FALSE),1,150) || '>');
4914:
4915: IF i <= 2 THEN
4916: pl_msg_data := SUBSTR(fnd_msg_pub.get(p_msg_index => i,p_encoded => FND_API.G_FALSE),1,240) ;
4917: END if;

Line 4916: pl_msg_data := SUBSTR(fnd_msg_pub.get(p_msg_index => i,p_encoded => FND_API.G_FALSE),1,240) ;

4912: fnd_file.put_line(FND_FILE.LOG,'x_msg #' || TO_CHAR(i) || ' = <' ||
4913: SUBSTR(fnd_msg_pub.get(p_msg_index => i,p_encoded => FND_API.G_FALSE),1,150) || '>');
4914:
4915: IF i <= 2 THEN
4916: pl_msg_data := SUBSTR(fnd_msg_pub.get(p_msg_index => i,p_encoded => FND_API.G_FALSE),1,240) ;
4917: END if;
4918:
4919: END LOOP;
4920:

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

4932: fnd_file.put_line(FND_FILE.LOG, 'l_authresult_rec.PaymentSys_Msg: ' || l_authresult_rec.PaymentSys_Msg);
4933:
4934: END IF;
4935:
4936: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4937:
4938: IF PG_DEBUG in ('Y', 'C') THEN
4939: fnd_file.put_line(FND_FILE.LOG,'the value of auth_id is = ' || (l_authresult_rec.Auth_Id));
4940: END IF;

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

4941:
4942: END IF;
4943:
4944:
4945: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4946: G_ERROR := 'Y' ;
4947:
4948: FND_MESSAGE.set_name('AR', 'AR_CC_AUTH_FAILED');
4949: FND_MSG_PUB.Add;

Line 5115: p_init_msg_list => FND_API.G_TRUE,

5111:
5112: BEGIN
5113: IBY_FNDCPT_TRXN_PUB.Create_Return(
5114: p_api_version => 1.0,
5115: p_init_msg_list => FND_API.G_TRUE,
5116: x_return_status => lc_return_status,
5117: x_msg_count => lc_msg_count,
5118: x_msg_data => lc_msg_data,
5119: p_payer => lc_payer_rec,

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

5131: fnd_file.put_line(FND_FILE.LOG,'x_msg_count :<' || lc_msg_count || '>');
5132:
5133: FOR i IN 1..lc_msg_count LOOP
5134: fnd_file.put_line(FND_FILE.LOG,'x_msg #' || TO_CHAR(i) || ' = <' ||
5135: SUBSTR(fnd_msg_pub.get(p_msg_index => i,p_encoded => FND_API.G_FALSE),1,150) || '>');
5136: END LOOP;
5137: END IF;
5138:
5139: IF PG_DEBUG in ('Y', 'C') THEN

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

5142: fnd_file.put_line(FND_FILE.LOG, 'l_response_rec.Result_Category: ' || lc_response_rec.Result_Category);
5143: fnd_file.put_line(FND_FILE.LOG, 'l_response_rec.Result_message : ' || lc_response_rec.Result_message );
5144: END IF;
5145:
5146: IF (lc_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5147:
5148:
5149: G_ERROR := 'Y' ;
5150:

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

5193: program_id = l_program_id,
5194: program_update_date = sysdate
5195: WHERE cash_receipt_id = rct_info.cash_receipt_id;
5196:
5197: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
5198: p_count => x_msg_count,
5199: p_data => x_msg_data );
5200:
5201: x_return_status := lc_return_status;

Line 5266: p_init_msg_list => FND_API.G_TRUE,

5262: END IF;
5263:
5264: IBY_FNDCPT_TRXN_PUB.Create_Settlements(
5265: p_api_version => 1.0,
5266: p_init_msg_list => FND_API.G_TRUE,
5267: p_calling_app_id => l_program_application_id,
5268: p_calling_app_request_code => 'AR_'||p_batch_id||'_'||WORKER_NUMBER,
5269: p_order_view_name => 'AR_FUNDS_CAPTURE_ORDERS_V',
5270: x_return_status => ls_return_status,

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

5278: fnd_file.put_line(FND_FILE.LOG,'x_msg_count :<' || ls_msg_count || '>');
5279:
5280: FOR i IN 1..ls_msg_count LOOP
5281: fnd_file.put_line(FND_FILE.LOG,'x_msg #' || TO_CHAR(i) || ' = <' ||
5282: SUBSTR(fnd_msg_pub.get(p_msg_index => i,p_encoded => FND_API.G_FALSE),1,150) || '>');
5283: END LOOP;
5284: END IF;
5285:
5286: IF PG_DEBUG in ('Y', 'C') THEN

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

5298:
5299: END IF;
5300:
5301:
5302: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5303:
5304: FOR i IN ls_response_rec_tab.FIRST..ls_response_rec_tab.LAST LOOP
5305: IF PG_DEBUG in ('Y', 'C') THEN
5306: fnd_file.put_line(FND_FILE.LOG,'the value of ls_response_rec.Trxn_Extension_Id = ' || (ls_response_rec_tab(i).Trxn_Extension_Id ));