DBA Data[Home] [Help]

APPS.OKS_ARFEEDER_PUB dependencies on OKC_API

Line 1792: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1788: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1789: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in insert RA_INTERFACE_SALESCREDITS ' || sqlerrm);
1790:
1791: When Others Then
1792: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1793: FND_FILE.PUT_LINE(FND_FILE.LOG,
1794: 'OKS_ARFEEDER_PUB.insert_ra_interface_sc => Exception in insert into RA_INTERFACE_SALESCREDITS'||' SQLCODE = '||SQLCODE ||' SQLERRM = '||SQLERRM);
1795:
1796: End insert_ra_interface_sc;

Line 2867: IF l_ret_stat = OKC_API.G_RET_STS_SUCCESS

2863: x_msg_data => l_msg_data,
2864: x_cc_id => v_clean_cc);
2865:
2866:
2867: IF l_ret_stat = OKC_API.G_RET_STS_SUCCESS
2868: THEN
2869: iby_cc_validate.getcctype( p_api_version => 1.0,
2870: p_init_msg_list => 'T',
2871: p_cc_id => v_clean_cc,

Line 2876: IF l_ret_stat = OKC_API.G_RET_STS_SUCCESS

2872: x_return_status => l_ret_stat,
2873: x_msg_count => l_msg_cnt,
2874: x_msg_data => l_msg_data,
2875: x_cc_type => v_cc_type);
2876: IF l_ret_stat = OKC_API.G_RET_STS_SUCCESS
2877: THEN
2878: IF v_cc_type=IBY_CC_VALIDATE.c_InvalidCC THEN
2879: IF G_LOG_YES_NO = 'YES' THEN
2880: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Credit card number Format is invalid.');

Line 2931: x_return_status := OKC_API.G_RET_STS_SUCCESS;

2927: /* GET THE CONCURRENT PROCESS ID */
2928:
2929: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2930:
2931: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2932:
2933: --Fix for bug#4198616
2934: --declared global variable G_LOG_YES_NO and using this variable
2935: --in place OKS_BILLING_PUB.l_write_log to decide whether to log

Line 4627: x_return_status := OKC_API.G_RET_STS_ERROR;

4623:
4624: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert Failed IN ARFEEDER MAIN_CUR_EXCEPTION RAISED '||sqlerrm);
4625: l_reject_counter := l_reject_counter + 1;
4626: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4627: x_return_status := OKC_API.G_RET_STS_ERROR;
4628: WHEN OTHERS THEN
4629:
4630: /*FOR BILLING REPORT*/
4631: --This is done to retrieve the profile value

Line 4687: x_return_status := OKC_API.G_RET_STS_ERROR;

4683: END IF; -- l_bill_profile = G_SUM
4684: END IF; -- bcl_rec.lse_id = 46
4685: END IF; -- P_PRV <> 3
4686:
4687: x_return_status := OKC_API.G_RET_STS_ERROR;
4688: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert Failed IN ARFEEDER OTHERS EXCEPTION RAISED'||sqlerrm);
4689: l_reject_counter := l_reject_counter + 1;
4690: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4691:

Line 4753: --x_return_status := OKC_API.G_RET_STS_ERROR;

4749:
4750:
4751: EXCEPTION
4752: WHEN G_EXCEPTION_BILLING THEN
4753: --x_return_status := OKC_API.G_RET_STS_ERROR;
4754: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert Failed IN ARFEEDER G_BILLING_EXCEPTION RAISED '||sqlerrm);
4755: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4756: WHEN OTHERS THEN
4757: --x_return_status := OKC_API.G_RET_STS_ERROR;

Line 4757: --x_return_status := OKC_API.G_RET_STS_ERROR;

4753: --x_return_status := OKC_API.G_RET_STS_ERROR;
4754: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert Failed IN ARFEEDER G_BILLING_EXCEPTION RAISED '||sqlerrm);
4755: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4756: WHEN OTHERS THEN
4757: --x_return_status := OKC_API.G_RET_STS_ERROR;
4758: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert Failed IN ARFEEDER WHEN OTHERS EXCEPTION RAISED'||sqlerrm);
4759: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4760:
4761: End Get_REC_FEEDER;