DBA Data[Home] [Help]

APPS.OKS_ARFEEDER_PUB dependencies on OKC_API

Line 1806: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1802: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1803: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in insert RA_INTERFACE_SALESCREDITS ' || sqlerrm);
1804:
1805: When Others Then
1806: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1807: FND_FILE.PUT_LINE(FND_FILE.LOG,
1808: 'OKS_ARFEEDER_PUB.insert_ra_interface_sc => Exception in insert into RA_INTERFACE_SALESCREDITS'||' SQLCODE = '||SQLCODE ||' SQLERRM = '||SQLERRM);
1809:
1810: End insert_ra_interface_sc;

Line 2908: IF l_ret_stat = OKC_API.G_RET_STS_SUCCESS

2904: x_msg_data => l_msg_data,
2905: x_cc_id => v_clean_cc);
2906:
2907:
2908: IF l_ret_stat = OKC_API.G_RET_STS_SUCCESS
2909: THEN
2910: iby_cc_validate.getcctype( p_api_version => 1.0,
2911: p_init_msg_list => 'T',
2912: p_cc_id => v_clean_cc,

Line 2917: IF l_ret_stat = OKC_API.G_RET_STS_SUCCESS

2913: x_return_status => l_ret_stat,
2914: x_msg_count => l_msg_cnt,
2915: x_msg_data => l_msg_data,
2916: x_cc_type => v_cc_type);
2917: IF l_ret_stat = OKC_API.G_RET_STS_SUCCESS
2918: THEN
2919: IF v_cc_type=IBY_CC_VALIDATE.c_InvalidCC THEN
2920: IF G_LOG_YES_NO = 'YES' THEN
2921: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Credit card number Format is invalid.');

Line 2974: x_return_status := OKC_API.G_RET_STS_SUCCESS;

2970: /* GET THE CONCURRENT PROCESS ID */
2971:
2972: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2973:
2974: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2975:
2976: --Fix for bug#4198616
2977: --declared global variable G_LOG_YES_NO and using this variable
2978: --in place OKS_BILLING_PUB.l_write_log to decide whether to log

Line 4779: x_return_status := OKC_API.G_RET_STS_ERROR;

4775:
4776: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert Failed IN ARFEEDER MAIN_CUR_EXCEPTION RAISED '||sqlerrm);
4777: l_reject_counter := l_reject_counter + 1;
4778: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4779: x_return_status := OKC_API.G_RET_STS_ERROR;
4780: WHEN OTHERS THEN
4781:
4782: /*FOR BILLING REPORT*/
4783: --This is done to retrieve the profile value

Line 4839: x_return_status := OKC_API.G_RET_STS_ERROR;

4835: END IF; -- l_bill_profile = G_SUM
4836: END IF; -- bcl_rec.lse_id = 46
4837: END IF; -- P_PRV <> 3
4838:
4839: x_return_status := OKC_API.G_RET_STS_ERROR;
4840: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert Failed IN ARFEEDER OTHERS EXCEPTION RAISED'||sqlerrm);
4841: l_reject_counter := l_reject_counter + 1;
4842: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4843:

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

4901:
4902:
4903: EXCEPTION
4904: WHEN G_EXCEPTION_BILLING THEN
4905: --x_return_status := OKC_API.G_RET_STS_ERROR;
4906: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert Failed IN ARFEEDER G_BILLING_EXCEPTION RAISED '||sqlerrm);
4907: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4908: WHEN OTHERS THEN
4909: --x_return_status := OKC_API.G_RET_STS_ERROR;

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

4905: --x_return_status := OKC_API.G_RET_STS_ERROR;
4906: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert Failed IN ARFEEDER G_BILLING_EXCEPTION RAISED '||sqlerrm);
4907: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4908: WHEN OTHERS THEN
4909: --x_return_status := OKC_API.G_RET_STS_ERROR;
4910: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert Failed IN ARFEEDER WHEN OTHERS EXCEPTION RAISED'||sqlerrm);
4911: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4912:
4913: End Get_REC_FEEDER;