APPS.OKL_CONVERT_INT_TYPE_WF dependencies on OKL_API

Line 87: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;

83: l_key varchar2(240);
84: l_event_name varchar2(240) := 'oracle.apps.okl.cs.convertinteresttype';
85:
86: l_seq NUMBER;
87: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
88: CURSOR okl_key_csr IS
89: SELECT okl_wf_item_s.nextval
90: FROM dual;
91: BEGIN

Line 110: x_return_status := OKL_API.G_RET_STS_ERROR;

106: x_return_status := l_return_status;
107: l_parameter_list.DELETE;
108: EXCEPTION
109: WHEN OTHERS THEN
110: x_return_status := OKL_API.G_RET_STS_ERROR;
111: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');
112: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
113: FND_MSG_PUB.ADD;
114: ROLLBACK TO raise_convert_interest_event;

Line 111: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');

107: l_parameter_list.DELETE;
108: EXCEPTION
109: WHEN OTHERS THEN
110: x_return_status := OKL_API.G_RET_STS_ERROR;
111: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');
112: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
113: FND_MSG_PUB.ADD;
114: ROLLBACK TO raise_convert_interest_event;
115: END raise_convert_interest_event;

Line 126: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;

122: actid in number,
123: funcmode in varchar2,
124: resultout out nocopy varchar2)
125: AS
126: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
127: l_api_version NUMBER := 1.0;
128: l_msg_count NUMBER;
129: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;
130: l_msg_data VARCHAR2(2000);

Line 129: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;

125: AS
126: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
127: l_api_version NUMBER := 1.0;
128: l_msg_count NUMBER;
129: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;
130: l_msg_data VARCHAR2(2000);
131:
132: l_request_num OKL_TRX_REQUESTS.REQUEST_NUMBER%TYPE;
133: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;

Line 636: WHEN OKL_API.G_EXCEPTION_ERROR THEN

632: resultout := 'COMPLETE:';
633: return;
634: END IF;
635: EXCEPTION
636: WHEN OKL_API.G_EXCEPTION_ERROR THEN
637: wf_core.context('OKL_CONVERT_INT_TYPE_WF',
638: 'Convert_Interest_Type',
639: itemtype,
640: itemkey,

Line 644: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

640: itemkey,
641: to_char(actid),
642: funcmode);
643: RAISE;
644: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
645: wf_core.context('OKL_CONVERT_INT_TYPE_WF',
646: 'Convert_Interest_Type',
647: itemtype,
648: itemkey,

Line 673: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;

669: actid in number,
670: funcmode in varchar2,
671: resultout out nocopy varchar2) AS
672:
673: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
674: l_api_version NUMBER := 1.0;
675: l_msg_count NUMBER;
676: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;
677: l_msg_data VARCHAR2(2000);

Line 676: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;

672:
673: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
674: l_api_version NUMBER := 1.0;
675: l_msg_count NUMBER;
676: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;
677: l_msg_data VARCHAR2(2000);
678:
679: l_request_num OKL_TRX_REQUESTS.REQUEST_NUMBER%TYPE;
680: l_trx_id NUMBER;

Line 767: WHEN OKL_API.G_EXCEPTION_ERROR THEN

763: resultout := 'COMPLETE:NO';
764: return;
765: END IF;
766: EXCEPTION
767: WHEN OKL_API.G_EXCEPTION_ERROR THEN
768: wf_core.context('OKL_CONVERT_INT_TYPE_WF',
769: 'Convert_Interest_Type',
770: itemtype,
771: itemkey,

Line 775: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

771: itemkey,
772: to_char(actid),
773: funcmode);
774: RAISE;
775: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
776: wf_core.context('OKL_CONVERT_INT_TYPE_WF',
777: 'Convert_Interest_Type',
778: itemtype,
779: itemkey,