DBA Data[Home] [Help]

APPS.OKL_CS_WF dependencies on OKC_API

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

1794: l_msg_data VARCHAR2(2000);
1795: l_error VARCHAR2(2000);
1796: l_trx_id NUMBER;
1797: l_init_msg_list VARCHAR2(1) := 'T';
1798: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1799: ERR EXCEPTION;
1800: l_batch_id NUMBER;
1801: l_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
1802: lx_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;

Line 1871: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

1867: ,p_xmp_rec => l_xmp_rec
1868: ,x_xmp_rec => lx_xmp_rec
1869: );
1870:
1871: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
1872: l_batch_id := lx_xmp_rec.batch_id;
1873: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1874: itemkey => itemkey,
1875: aname => 'BATCH_ID',

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

2109: l_error VARCHAR2(2000);
2110: l_sts_code VARCHAR2(30);
2111:
2112: l_init_msg_list VARCHAR2(1) := 'T';
2113: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2114: ERR EXCEPTION;
2115: l_batch_id NUMBER;
2116: l_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;
2117: lx_xmp_rec OKL_XMLP_PARAMS_PVT.xmp_rec_type;

Line 2193: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

2189: ,p_xmp_rec => l_xmp_rec
2190: ,x_xmp_rec => lx_xmp_rec
2191: );
2192:
2193: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2194: l_batch_id := lx_xmp_rec.batch_id;
2195: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2196: itemkey => itemkey,
2197: aname => 'BATCH_ID',

Line 2785: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

2781: END LOOP;
2782: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2783: EXCEPTION
2784: WHEN OTHERS THEN
2785: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
2786: ,p_msg_name => G_UNEXPECTED_ERROR
2787: ,p_token1 => G_SQLCODE_TOKEN
2788: ,p_token1_value => SQLCODE
2789: ,p_token2 => G_SQLERRM_TOKEN

Line 2791: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

2787: ,p_token1 => G_SQLCODE_TOKEN
2788: ,p_token1_value => SQLCODE
2789: ,p_token2 => G_SQLERRM_TOKEN
2790: ,p_token2_value => SQLERRM);
2791: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2792: END days_cust_balance_overdue;
2793:
2794: ------------------------------------------------------------------
2795: -- The following API gets the outstanding Balance for a

Line 2817: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

2813: CLOSE outstanding_rcvble_csr;
2814: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2815: EXCEPTION
2816: WHEN OTHERS THEN
2817: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
2818: ,p_msg_name => G_UNEXPECTED_ERROR
2819: ,p_token1 => G_SQLCODE_TOKEN
2820: ,p_token1_value => SQLCODE
2821: ,p_token2 => G_SQLERRM_TOKEN

Line 2823: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

2819: ,p_token1 => G_SQLCODE_TOKEN
2820: ,p_token1_value => SQLCODE
2821: ,p_token2 => G_SQLERRM_TOKEN
2822: ,p_token2_value => SQLERRM);
2823: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2824: END get_contract_balance;
2825:
2826: ------------------------------------------------------------------
2827: -- The following API gets the outstanding Balance for a

Line 2880: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

2876: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2877:
2878: EXCEPTION
2879: WHEN OTHERS THEN
2880: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
2881: ,p_msg_name => G_UNEXPECTED_ERROR
2882: ,p_token1 => G_SQLCODE_TOKEN
2883: ,p_token1_value => SQLCODE
2884: ,p_token2 => G_SQLERRM_TOKEN

Line 2916: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

2912: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2913:
2914: EXCEPTION
2915: WHEN OTHERS THEN
2916: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
2917: ,p_msg_name => G_UNEXPECTED_ERROR
2918: ,p_token1 => G_SQLCODE_TOKEN
2919: ,p_token1_value => SQLCODE
2920: ,p_token2 => G_SQLERRM_TOKEN

Line 2988: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

2984: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2985:
2986: EXCEPTION
2987: WHEN OTHERS THEN
2988: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
2989: ,p_msg_name => G_UNEXPECTED_ERROR
2990: ,p_token1 => G_SQLCODE_TOKEN
2991: ,p_token1_value => SQLCODE
2992: ,p_token2 => G_SQLERRM_TOKEN