DBA Data[Home] [Help]

APPS.OKL_CS_WF dependencies on OKC_API

Line 1807: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1803: l_msg_data VARCHAR2(2000);
1804: l_error VARCHAR2(2000);
1805: l_trx_id NUMBER;
1806: l_init_msg_list VARCHAR2(1) := 'T';
1807: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1808: ERR EXCEPTION;
1809: l_batch_id NUMBER;
1810: l_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
1811: lx_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;

Line 1880: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

1876: ,p_xmp_rec => l_xmp_rec
1877: ,x_xmp_rec => lx_xmp_rec
1878: );
1879:
1880: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
1881: l_batch_id := lx_xmp_rec.batch_id;
1882: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1883: itemkey => itemkey,
1884: aname => 'BATCH_ID',

Line 2122: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

2118: l_error VARCHAR2(2000);
2119: l_sts_code VARCHAR2(30);
2120:
2121: l_init_msg_list VARCHAR2(1) := 'T';
2122: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2123: ERR EXCEPTION;
2124: l_batch_id NUMBER;
2125: l_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
2126: lx_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;

Line 2202: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

2198: ,p_xmp_rec => l_xmp_rec
2199: ,x_xmp_rec => lx_xmp_rec
2200: );
2201:
2202: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2203: l_batch_id := lx_xmp_rec.batch_id;
2204: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2205: itemkey => itemkey,
2206: aname => 'BATCH_ID',

Line 2794: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

2790: END LOOP;
2791: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2792: EXCEPTION
2793: WHEN OTHERS THEN
2794: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
2795: ,p_msg_name => G_UNEXPECTED_ERROR
2796: ,p_token1 => G_SQLCODE_TOKEN
2797: ,p_token1_value => SQLCODE
2798: ,p_token2 => G_SQLERRM_TOKEN

Line 2800: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

2796: ,p_token1 => G_SQLCODE_TOKEN
2797: ,p_token1_value => SQLCODE
2798: ,p_token2 => G_SQLERRM_TOKEN
2799: ,p_token2_value => SQLERRM);
2800: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2801: END days_cust_balance_overdue;
2802:
2803: ------------------------------------------------------------------
2804: -- The following API gets the outstanding Balance for a

Line 2826: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

2822: CLOSE outstanding_rcvble_csr;
2823: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2824: EXCEPTION
2825: WHEN OTHERS THEN
2826: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
2827: ,p_msg_name => G_UNEXPECTED_ERROR
2828: ,p_token1 => G_SQLCODE_TOKEN
2829: ,p_token1_value => SQLCODE
2830: ,p_token2 => G_SQLERRM_TOKEN

Line 2832: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

2828: ,p_token1 => G_SQLCODE_TOKEN
2829: ,p_token1_value => SQLCODE
2830: ,p_token2 => G_SQLERRM_TOKEN
2831: ,p_token2_value => SQLERRM);
2832: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2833: END get_contract_balance;
2834:
2835: ------------------------------------------------------------------
2836: -- The following API gets the outstanding Balance for a

Line 2889: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

2885: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2886:
2887: EXCEPTION
2888: WHEN OTHERS THEN
2889: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
2890: ,p_msg_name => G_UNEXPECTED_ERROR
2891: ,p_token1 => G_SQLCODE_TOKEN
2892: ,p_token1_value => SQLCODE
2893: ,p_token2 => G_SQLERRM_TOKEN

Line 2925: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

2921: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2922:
2923: EXCEPTION
2924: WHEN OTHERS THEN
2925: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
2926: ,p_msg_name => G_UNEXPECTED_ERROR
2927: ,p_token1 => G_SQLCODE_TOKEN
2928: ,p_token1_value => SQLCODE
2929: ,p_token2 => G_SQLERRM_TOKEN

Line 2997: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

2993: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2994:
2995: EXCEPTION
2996: WHEN OTHERS THEN
2997: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
2998: ,p_msg_name => G_UNEXPECTED_ERROR
2999: ,p_token1 => G_SQLCODE_TOKEN
3000: ,p_token1_value => SQLCODE
3001: ,p_token2 => G_SQLERRM_TOKEN