APPS.OKL_KBK_APPROVALS_WF dependencies on OKL_API

Line 5: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;

1: PACKAGE BODY Okl_Kbk_Approvals_Wf AS
2: /* $Header: OKLRBWFB.pls 120.11.12010000.2 2008/09/09 23:10:45 rkuttiya ship $ */
3:
4: G_NO_MATCHING_RECORD CONSTANT VARCHAR2(200) := 'OKL_LLA_NO_MATCHING_RECORD';
5: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
6: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
7: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
8: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
9: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;

Line 6: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;

2: /* $Header: OKLRBWFB.pls 120.11.12010000.2 2008/09/09 23:10:45 rkuttiya ship $ */
3:
4: G_NO_MATCHING_RECORD CONSTANT VARCHAR2(200) := 'OKL_LLA_NO_MATCHING_RECORD';
5: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
6: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
7: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
8: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
9: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
10: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';

Line 7: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

3:
4: G_NO_MATCHING_RECORD CONSTANT VARCHAR2(200) := 'OKL_LLA_NO_MATCHING_RECORD';
5: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
6: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
7: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
8: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
9: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
10: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
11: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

Line 8: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;

4: G_NO_MATCHING_RECORD CONSTANT VARCHAR2(200) := 'OKL_LLA_NO_MATCHING_RECORD';
5: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
6: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
7: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
8: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
9: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
10: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
11: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
12: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

Line 9: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;

5: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
6: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
7: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
8: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
9: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
10: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
11: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
12: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
13: G_API_TYPE CONSTANT VARCHAR2(200) := '_PVT';

Line 98: x_return_status := OKL_API.G_RET_STS_SUCCESS;

94: SELECT USER_NAME, DESCRIPTION
95: FROM FND_USER
96: WHERE user_id = c_user_id;
97: BEGIN
98: x_return_status := OKL_API.G_RET_STS_SUCCESS;
99: OPEN wf_users_csr(p_user_id);
100: FETCH wf_users_csr INTO x_name, x_description;
101: CLOSE wf_users_csr;
102: IF x_name IS NULL THEN

Line 113: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

109: END IF;
110: END IF;
111: EXCEPTION
112: WHEN OTHERS THEN
113: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
114: END l_get_agent;
115:
116: --------------------------------------------------------------------------------------------------
117: PROCEDURE l_change_k_status(p_api_version IN NUMBER,

Line 118: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

114: END l_get_agent;
115:
116: --------------------------------------------------------------------------------------------------
117: PROCEDURE l_change_k_status(p_api_version IN NUMBER,
118: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
119: x_return_status OUT NOCOPY VARCHAR2,
120: x_msg_count OUT NOCOPY NUMBER,
121: x_msg_data OUT NOCOPY VARCHAR2,
122: p_khr_status IN OKC_K_HEADERS_V.STS_CODE%TYPE,

Line 126: x_return_status := OKL_API.G_RET_STS_SUCCESS;

122: p_khr_status IN OKC_K_HEADERS_V.STS_CODE%TYPE,
123: p_chr_id IN NUMBER) IS
124: l_api_name CONSTANT VARCHAR2(30) := 'l_change_k_status';
125: BEGIN
126: x_return_status := OKL_API.G_RET_STS_SUCCESS;
127: -- Call start_activity to create savepoint, check compatibility
128: -- and initialize message list
129: x_return_status := OKL_API.START_ACTIVITY (
130: l_api_name,

Line 129: x_return_status := OKL_API.START_ACTIVITY (

125: BEGIN
126: x_return_status := OKL_API.G_RET_STS_SUCCESS;
127: -- Call start_activity to create savepoint, check compatibility
128: -- and initialize message list
129: x_return_status := OKL_API.START_ACTIVITY (
130: l_api_name,
131: p_init_msg_list,
132: '_PVT',
133: x_return_status);

Line 136: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

132: '_PVT',
133: x_return_status);
134:
135: -- Check if activity started successfully
136: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
137: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
138: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
139: RAISE OKL_API.G_EXCEPTION_ERROR;
140: END IF;

Line 137: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

133: x_return_status);
134:
135: -- Check if activity started successfully
136: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
137: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
138: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
139: RAISE OKL_API.G_EXCEPTION_ERROR;
140: END IF;
141: Okl_Contract_Status_Pub.update_contract_status(

Line 138: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

134:
135: -- Check if activity started successfully
136: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
137: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
138: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
139: RAISE OKL_API.G_EXCEPTION_ERROR;
140: END IF;
141: Okl_Contract_Status_Pub.update_contract_status(
142: p_api_version => p_api_version,

Line 139: RAISE OKL_API.G_EXCEPTION_ERROR;

135: -- Check if activity started successfully
136: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
137: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
138: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
139: RAISE OKL_API.G_EXCEPTION_ERROR;
140: END IF;
141: Okl_Contract_Status_Pub.update_contract_status(
142: p_api_version => p_api_version,
143: p_init_msg_list => p_init_msg_list,

Line 150: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

146: x_msg_data => x_msg_data,
147: p_khr_status => p_khr_status,
148: p_chr_id => p_chr_id);
149:
150: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
151: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
152: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
153: RAISE OKL_API.G_EXCEPTION_ERROR;
154: END IF;

Line 151: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

147: p_khr_status => p_khr_status,
148: p_chr_id => p_chr_id);
149:
150: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
151: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
152: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
153: RAISE OKL_API.G_EXCEPTION_ERROR;
154: END IF;
155:

Line 152: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN

148: p_chr_id => p_chr_id);
149:
150: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
151: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
152: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
153: RAISE OKL_API.G_EXCEPTION_ERROR;
154: END IF;
155:
156: --call to cascade status on to lines

Line 153: RAISE OKL_API.G_EXCEPTION_ERROR;

149:
150: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
151: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
152: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
153: RAISE OKL_API.G_EXCEPTION_ERROR;
154: END IF;
155:
156: --call to cascade status on to lines
157: Okl_Contract_Status_Pub.cascade_lease_status(

Line 165: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

161: x_msg_count => x_msg_count,
162: x_msg_data => x_msg_data,
163: p_chr_id => p_chr_id);
164:
165: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
166: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
167: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
168: RAISE OKL_API.G_EXCEPTION_ERROR;
169: END IF;

Line 166: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

162: x_msg_data => x_msg_data,
163: p_chr_id => p_chr_id);
164:
165: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
166: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
167: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
168: RAISE OKL_API.G_EXCEPTION_ERROR;
169: END IF;
170: OKL_API.END_ACTIVITY (x_msg_count,

Line 167: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN

163: p_chr_id => p_chr_id);
164:
165: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
166: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
167: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
168: RAISE OKL_API.G_EXCEPTION_ERROR;
169: END IF;
170: OKL_API.END_ACTIVITY (x_msg_count,
171: x_msg_data );

Line 168: RAISE OKL_API.G_EXCEPTION_ERROR;

164:
165: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
166: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
167: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
168: RAISE OKL_API.G_EXCEPTION_ERROR;
169: END IF;
170: OKL_API.END_ACTIVITY (x_msg_count,
171: x_msg_data );
172: EXCEPTION

Line 170: OKL_API.END_ACTIVITY (x_msg_count,

166: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
167: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
168: RAISE OKL_API.G_EXCEPTION_ERROR;
169: END IF;
170: OKL_API.END_ACTIVITY (x_msg_count,
171: x_msg_data );
172: EXCEPTION
173: WHEN OKL_API.G_EXCEPTION_ERROR THEN
174: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 173: WHEN OKL_API.G_EXCEPTION_ERROR THEN

169: END IF;
170: OKL_API.END_ACTIVITY (x_msg_count,
171: x_msg_data );
172: EXCEPTION
173: WHEN OKL_API.G_EXCEPTION_ERROR THEN
174: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
175: l_api_name,
176: G_PKG_NAME,
177: 'OKL_API.G_RET_STS_ERROR',

Line 174: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

170: OKL_API.END_ACTIVITY (x_msg_count,
171: x_msg_data );
172: EXCEPTION
173: WHEN OKL_API.G_EXCEPTION_ERROR THEN
174: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
175: l_api_name,
176: G_PKG_NAME,
177: 'OKL_API.G_RET_STS_ERROR',
178: x_msg_count,

Line 177: 'OKL_API.G_RET_STS_ERROR',

173: WHEN OKL_API.G_EXCEPTION_ERROR THEN
174: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
175: l_api_name,
176: G_PKG_NAME,
177: 'OKL_API.G_RET_STS_ERROR',
178: x_msg_count,
179: x_msg_data,
180: '_PVT');
181: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 181: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

177: 'OKL_API.G_RET_STS_ERROR',
178: x_msg_count,
179: x_msg_data,
180: '_PVT');
181: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
182: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
183: l_api_name,
184: G_PKG_NAME,
185: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 182: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

178: x_msg_count,
179: x_msg_data,
180: '_PVT');
181: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
182: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
183: l_api_name,
184: G_PKG_NAME,
185: 'OKL_API.G_RET_STS_UNEXP_ERROR',
186: x_msg_count,

Line 185: 'OKL_API.G_RET_STS_UNEXP_ERROR',

181: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
182: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
183: l_api_name,
184: G_PKG_NAME,
185: 'OKL_API.G_RET_STS_UNEXP_ERROR',
186: x_msg_count,
187: x_msg_data,
188: '_PVT');
189: WHEN OTHERS THEN

Line 190: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

186: x_msg_count,
187: x_msg_data,
188: '_PVT');
189: WHEN OTHERS THEN
190: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
191: l_api_name,
192: G_PKG_NAME,
193: 'OTHERS',
194: x_msg_count,

Line 222: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

218: --------------------------------------------------------------------------------------------------
219: ----------------------------------Rasing Business Event ------------------------------------------
220: --------------------------------------------------------------------------------------------------
221: PROCEDURE raise_approval_event (p_api_version IN NUMBER,
222: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
223: x_return_status OUT NOCOPY VARCHAR2,
224: x_msg_count OUT NOCOPY NUMBER,
225: x_msg_data OUT NOCOPY VARCHAR2,
226: p_contract_id IN OKC_K_HEADERS_B.ID%TYPE)

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

259: SELECT id
260: FROM okl_trx_types_b
261: WHERE trx_type_class = G_TRX_TYPE_CONTRACT_APPROVAL;
262:
263: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
264: l_api_version NUMBER := 1.0;
265: l_api_name CONSTANT VARCHAR2(30) := 'raise_approval_event';
266: l_msg_count NUMBER;
267: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;

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

263: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
264: l_api_version NUMBER := 1.0;
265: l_api_name CONSTANT VARCHAR2(30) := 'raise_approval_event';
266: l_msg_count NUMBER;
267: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;
268: l_msg_data VARCHAR2(2000);
269:
270: l_parameter_list wf_parameter_list_t;
271: l_key VARCHAR2(240);

Line 292: x_return_status := OKL_API.G_RET_STS_SUCCESS;

288: l_approval_option VARCHAR2(5);
289: --Added by dpsingh for LE Uptake
290: l_legal_entity_id NUMBER;
291: BEGIN
292: x_return_status := OKL_API.G_RET_STS_SUCCESS;
293: -- Call start_activity to create savepoint, check compatibility
294: -- and initialize message list
295: x_return_status := OKL_API.START_ACTIVITY(l_api_name,
296: p_init_msg_list,

Line 295: x_return_status := OKL_API.START_ACTIVITY(l_api_name,

291: BEGIN
292: x_return_status := OKL_API.G_RET_STS_SUCCESS;
293: -- Call start_activity to create savepoint, check compatibility
294: -- and initialize message list
295: x_return_status := OKL_API.START_ACTIVITY(l_api_name,
296: p_init_msg_list,
297: '_PVT',
298: x_return_status);
299: -- Check if activity started successfully

Line 300: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

296: p_init_msg_list,
297: '_PVT',
298: x_return_status);
299: -- Check if activity started successfully
300: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
301: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
302: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
303: RAISE OKL_API.G_EXCEPTION_ERROR;
304: END IF;

Line 301: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

297: '_PVT',
298: x_return_status);
299: -- Check if activity started successfully
300: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
301: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
302: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
303: RAISE OKL_API.G_EXCEPTION_ERROR;
304: END IF;
305:

Line 302: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

298: x_return_status);
299: -- Check if activity started successfully
300: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
301: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
302: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
303: RAISE OKL_API.G_EXCEPTION_ERROR;
304: END IF;
305:
306: -- mvasudev

Line 303: RAISE OKL_API.G_EXCEPTION_ERROR;

299: -- Check if activity started successfully
300: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
301: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
302: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
303: RAISE OKL_API.G_EXCEPTION_ERROR;
304: END IF;
305:
306: -- mvasudev
307: -- Create Internal Transaction

Line 317: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

313: x_return_status => x_return_status,
314: x_name => l_requester,
315: x_description => l_name);
316:
317: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
318: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
319: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
320: RAISE OKL_API.G_EXCEPTION_ERROR;
321: END IF;

Line 318: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

314: x_name => l_requester,
315: x_description => l_name);
316:
317: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
318: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
319: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
320: RAISE OKL_API.G_EXCEPTION_ERROR;
321: END IF;
322:

Line 319: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN

315: x_description => l_name);
316:
317: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
318: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
319: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
320: RAISE OKL_API.G_EXCEPTION_ERROR;
321: END IF;
322:
323: FOR l_wf_item_key_rec IN l_wf_item_key_csr

Line 320: RAISE OKL_API.G_EXCEPTION_ERROR;

316:
317: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
318: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
319: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
320: RAISE OKL_API.G_EXCEPTION_ERROR;
321: END IF;
322:
323: FOR l_wf_item_key_rec IN l_wf_item_key_csr
324: LOOP

Line 348: Okl_Api.set_message(p_app_name => g_app_name,

344: l_legal_entity_id := OKL_LEGAL_ENTITY_UTIL.get_khr_le_id(p_contract_id) ;
345: IF l_legal_entity_id IS NOT NULL THEN
346: l_trxH_in_rec.legal_entity_id := l_legal_entity_id;
347: ELSE
348: Okl_Api.set_message(p_app_name => g_app_name,
349: p_msg_name => 'OKL_LE_NOT_EXIST_CNTRCT',
350: p_token1 => 'CONTRACT_NUMBER',
351: p_token1_value => l_contract_num);
352: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 352: RAISE OKL_API.G_EXCEPTION_ERROR;

348: Okl_Api.set_message(p_app_name => g_app_name,
349: p_msg_name => 'OKL_LE_NOT_EXIST_CNTRCT',
350: p_token1 => 'CONTRACT_NUMBER',
351: p_token1_value => l_contract_num);
352: RAISE OKL_API.G_EXCEPTION_ERROR;
353: END IF;
354: -- Create Transaction Header
355: Okl_Trx_Contracts_Pub.create_trx_contracts(
356: p_api_version => l_api_version

Line 364: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

360: ,x_msg_data => l_msg_data
361: ,p_tcnv_rec => l_trxH_in_rec
362: ,x_tcnv_rec => l_trxH_out_rec);
363:
364: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
365: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
366: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
367: RAISE Okl_Api.G_EXCEPTION_ERROR;
368: END IF;

Line 365: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

361: ,p_tcnv_rec => l_trxH_in_rec
362: ,x_tcnv_rec => l_trxH_out_rec);
363:
364: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
365: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
366: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
367: RAISE Okl_Api.G_EXCEPTION_ERROR;
368: END IF;
369: -- end, mvasudev

Line 366: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN

362: ,x_tcnv_rec => l_trxH_out_rec);
363:
364: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
365: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
366: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
367: RAISE Okl_Api.G_EXCEPTION_ERROR;
368: END IF;
369: -- end, mvasudev
370:

Line 367: RAISE Okl_Api.G_EXCEPTION_ERROR;

363:
364: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
365: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
366: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
367: RAISE Okl_Api.G_EXCEPTION_ERROR;
368: END IF;
369: -- end, mvasudev
370:
371: l_approval_option := fnd_profile.value('OKL_LEASE_CONTRACT_APPROVAL_PROCESS');

Line 378: OKL_API.set_message(p_app_name => G_APP_NAME,

374: -- Get the Contract Number
375: OPEN c_fetch_k_number(l_chrv_id);
376: FETCH c_fetch_k_number INTO l_contract_num,l_sts_code;
377: IF c_fetch_k_number%NOTFOUND THEN
378: OKL_API.set_message(p_app_name => G_APP_NAME,
379: p_msg_name => G_NO_MATCHING_RECORD,
380: p_token1 => G_COL_NAME_TOKEN,
381: p_token1_value => 'OKC_K_HEADERS_V.ID');
382: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 382: RAISE OKL_API.G_EXCEPTION_ERROR;

378: OKL_API.set_message(p_app_name => G_APP_NAME,
379: p_msg_name => G_NO_MATCHING_RECORD,
380: p_token1 => G_COL_NAME_TOKEN,
381: p_token1_value => 'OKC_K_HEADERS_V.ID');
382: RAISE OKL_API.G_EXCEPTION_ERROR;
383: END IF;
384: CLOSE c_fetch_k_number;
385: IF l_sts_code <> G_KHR_STS_COMPLETE THEN
386: OKL_API.set_message(p_app_name => G_APP_NAME,

Line 386: OKL_API.set_message(p_app_name => G_APP_NAME,

382: RAISE OKL_API.G_EXCEPTION_ERROR;
383: END IF;
384: CLOSE c_fetch_k_number;
385: IF l_sts_code <> G_KHR_STS_COMPLETE THEN
386: OKL_API.set_message(p_app_name => G_APP_NAME,
387: p_msg_name => G_KHR_STATUS_NOT_COMPLETE);
388: RAISE OKL_API.G_EXCEPTION_ERROR;
389: END IF;
390:

Line 388: RAISE OKL_API.G_EXCEPTION_ERROR;

384: CLOSE c_fetch_k_number;
385: IF l_sts_code <> G_KHR_STS_COMPLETE THEN
386: OKL_API.set_message(p_app_name => G_APP_NAME,
387: p_msg_name => G_KHR_STATUS_NOT_COMPLETE);
388: RAISE OKL_API.G_EXCEPTION_ERROR;
389: END IF;
390:
391: -- Get the Application ID
392: OPEN c_get_app_id_csr;

Line 395: OKL_API.set_message(p_app_name => G_APP_NAME,

391: -- Get the Application ID
392: OPEN c_get_app_id_csr;
393: FETCH c_get_app_id_csr INTO l_application_id;
394: IF c_get_app_id_csr%NOTFOUND THEN
395: OKL_API.set_message(p_app_name => G_APP_NAME,
396: p_msg_name => G_NO_MATCHING_RECORD,
397: p_token1 => G_COL_NAME_TOKEN,
398: p_token1_value => 'Application id');
399: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 399: RAISE OKL_API.G_EXCEPTION_ERROR;

395: OKL_API.set_message(p_app_name => G_APP_NAME,
396: p_msg_name => G_NO_MATCHING_RECORD,
397: p_token1 => G_COL_NAME_TOKEN,
398: p_token1_value => 'Application id');
399: RAISE OKL_API.G_EXCEPTION_ERROR;
400: END IF;
401: CLOSE c_get_app_id_csr;
402:
403: -- Get the Transaction Type ID

Line 408: OKL_API.set_message(p_app_name => G_APP_NAME,

404: OPEN c_get_trx_type_csr(G_TRANS_APP_NAME);
405: FETCH c_get_trx_type_csr INTO l_trans_type_id,
406: l_trans_appl_id;
407: IF c_get_trx_type_csr%NOTFOUND THEN
408: OKL_API.set_message(p_app_name => G_APP_NAME,
409: p_msg_name => G_NO_MATCHING_RECORD,
410: p_token1 => G_COL_NAME_TOKEN,
411: p_token1_value => 'AME Transcation TYPE id, Application id');
412: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 412: RAISE OKL_API.G_EXCEPTION_ERROR;

408: OKL_API.set_message(p_app_name => G_APP_NAME,
409: p_msg_name => G_NO_MATCHING_RECORD,
410: p_token1 => G_COL_NAME_TOKEN,
411: p_token1_value => 'AME Transcation TYPE id, Application id');
412: RAISE OKL_API.G_EXCEPTION_ERROR;
413: END IF;
414: CLOSE c_get_trx_type_csr;
415:
416:

Line 432: OKL_API.set_message(p_app_name => G_APP_NAME,

428: --added by akrangan
429: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
430:
431: ELSE
432: OKL_API.set_message(p_app_name => G_APP_NAME,
433: p_msg_name => G_INVALID_APP);
434: RAISE OKL_API.G_EXCEPTION_ERROR;
435: END IF; -- l_application_id
436:

Line 434: RAISE OKL_API.G_EXCEPTION_ERROR;

430:
431: ELSE
432: OKL_API.set_message(p_app_name => G_APP_NAME,
433: p_msg_name => G_INVALID_APP);
434: RAISE OKL_API.G_EXCEPTION_ERROR;
435: END IF; -- l_application_id
436:
437: ELSIF l_approval_option = G_LEASE_CONTRACT_APPROVAL_WF THEN
438: l_event_name := G_EVENT_APPROVE_WF;

Line 453: RAISE OKL_API.G_EXCEPTION_ERROR;

449: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
450: --added by akrangan
451: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
452: ELSE
453: RAISE OKL_API.G_EXCEPTION_ERROR;
454: END IF; -- l_approval_option
455:
456: -- We need to status to Approved Pending since We are sending for approval
457: l_change_k_status(p_api_version => p_api_version,

Line 465: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

461: x_msg_data => x_msg_data,
462: p_khr_status => G_KHR_STS_PENDING_APPROVAL,
463: p_chr_id => l_chrv_id);
464:
465: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
466: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
467: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
468: RAISE OKL_API.G_EXCEPTION_ERROR;
469: END IF;

Line 466: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

462: p_khr_status => G_KHR_STS_PENDING_APPROVAL,
463: p_chr_id => l_chrv_id);
464:
465: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
466: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
467: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
468: RAISE OKL_API.G_EXCEPTION_ERROR;
469: END IF;
470:

Line 467: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN

463: p_chr_id => l_chrv_id);
464:
465: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
466: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
467: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
468: RAISE OKL_API.G_EXCEPTION_ERROR;
469: END IF;
470:
471: -- Raise Event

Line 468: RAISE OKL_API.G_EXCEPTION_ERROR;

464:
465: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
466: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
467: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
468: RAISE OKL_API.G_EXCEPTION_ERROR;
469: END IF;
470:
471: -- Raise Event
472: wf_event.RAISE(p_event_name => l_event_name,

Line 477: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

473: p_event_key => l_key,
474: p_parameters => l_parameter_list);
475: l_parameter_list.DELETE;
476:
477: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
478: x_msg_data => x_msg_data);
479: EXCEPTION
480: WHEN OKL_API.G_EXCEPTION_ERROR THEN
481: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 480: WHEN OKL_API.G_EXCEPTION_ERROR THEN

476:
477: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
478: x_msg_data => x_msg_data);
479: EXCEPTION
480: WHEN OKL_API.G_EXCEPTION_ERROR THEN
481: x_return_status := OKL_API.G_RET_STS_ERROR;
482: IF c_fetch_k_number%ISOPEN THEN
483: CLOSE c_fetch_k_number;
484: END IF;

Line 481: x_return_status := OKL_API.G_RET_STS_ERROR;

477: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
478: x_msg_data => x_msg_data);
479: EXCEPTION
480: WHEN OKL_API.G_EXCEPTION_ERROR THEN
481: x_return_status := OKL_API.G_RET_STS_ERROR;
482: IF c_fetch_k_number%ISOPEN THEN
483: CLOSE c_fetch_k_number;
484: END IF;
485: IF c_get_app_id_csr%ISOPEN THEN

Line 494: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

490: END IF;
491: IF l_wf_item_key_csr%ISOPEN THEN
492: CLOSE l_wf_item_key_csr;
493: END IF;
494: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
495: p_api_name => l_api_name,
496: p_pkg_name => G_PKG_NAME,
497: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
498: x_msg_count => x_msg_count,

Line 497: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

493: END IF;
494: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
495: p_api_name => l_api_name,
496: p_pkg_name => G_PKG_NAME,
497: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
498: x_msg_count => x_msg_count,
499: x_msg_data => x_msg_data,
500: p_api_type => G_API_TYPE);
501: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 501: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

497: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
498: x_msg_count => x_msg_count,
499: x_msg_data => x_msg_data,
500: p_api_type => G_API_TYPE);
501: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
502: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
503: IF c_fetch_k_number%ISOPEN THEN
504: CLOSE c_fetch_k_number;
505: END IF;

Line 502: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

498: x_msg_count => x_msg_count,
499: x_msg_data => x_msg_data,
500: p_api_type => G_API_TYPE);
501: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
502: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
503: IF c_fetch_k_number%ISOPEN THEN
504: CLOSE c_fetch_k_number;
505: END IF;
506: IF c_get_app_id_csr%ISOPEN THEN

Line 515: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

511: END IF;
512: IF l_wf_item_key_csr%ISOPEN THEN
513: CLOSE l_wf_item_key_csr;
514: END IF;
515: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
516: p_api_name => l_api_name,
517: p_pkg_name => G_PKG_NAME,
518: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
519: x_msg_count => x_msg_count,

Line 518: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

514: END IF;
515: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
516: p_api_name => l_api_name,
517: p_pkg_name => G_PKG_NAME,
518: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
519: x_msg_count => x_msg_count,
520: x_msg_data => x_msg_data,
521: p_api_type => G_API_TYPE);
522: WHEN OTHERS THEN

Line 536: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

532: IF l_wf_item_key_csr%ISOPEN THEN
533: CLOSE l_wf_item_key_csr;
534: END IF;
535: -- store SQL error message on message stack
536: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
537: p_api_name => l_api_name,
538: p_pkg_name => G_PKG_NAME,
539: p_exc_name => 'OTHERS',
540: x_msg_count => x_msg_count,

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

549: l_msg_count NUMBER;
550: l_msg_data VARCHAR2(2000);
551: l_api_version NUMBER := 1;
552: l_init_msg_list VARCHAR2(3) := OKC_API.G_TRUE;
553: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
554:
555: l_true_tax VARCHAR2(200);
556: l_cap_amt NUMBER;
557: l_res_value NUMBER;

Line 840: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

836: p_formula_name => 'CONTRACT_FINANCED_AMOUNT_BKG',
837: --fmiao end bug 5178182
838: p_contract_id => p_contract_id,
839: x_value => l_cap_amt);
840: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
841: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
842: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
843: RAISE OKL_API.G_EXCEPTION_ERROR;
844: END IF;

Line 841: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

837: --fmiao end bug 5178182
838: p_contract_id => p_contract_id,
839: x_value => l_cap_amt);
840: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
841: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
842: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
843: RAISE OKL_API.G_EXCEPTION_ERROR;
844: END IF;
845: l_message := l_message || '

Line 842: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN

838: p_contract_id => p_contract_id,
839: x_value => l_cap_amt);
840: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
841: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
842: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
843: RAISE OKL_API.G_EXCEPTION_ERROR;
844: END IF;
845: l_message := l_message || '
846:

Line 843: RAISE OKL_API.G_EXCEPTION_ERROR;

839: x_value => l_cap_amt);
840: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
841: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
842: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
843: RAISE OKL_API.G_EXCEPTION_ERROR;
844: END IF;
845: l_message := l_message || '
846:
847: '

Line 867: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

863: x_msg_data => l_msg_data,
864: p_formula_name => 'CONTRACT_RESIDUAL_VALUE',
865: p_contract_id => p_contract_id,
866: x_value => l_res_value);
867: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
868: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
869: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
870: RAISE OKL_API.G_EXCEPTION_ERROR;
871: END IF;

Line 868: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

864: p_formula_name => 'CONTRACT_RESIDUAL_VALUE',
865: p_contract_id => p_contract_id,
866: x_value => l_res_value);
867: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
868: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
869: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
870: RAISE OKL_API.G_EXCEPTION_ERROR;
871: END IF;
872: l_message := l_message || '

Line 869: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN

865: p_contract_id => p_contract_id,
866: x_value => l_res_value);
867: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
868: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
869: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
870: RAISE OKL_API.G_EXCEPTION_ERROR;
871: END IF;
872: l_message := l_message || '
873:

Line 870: RAISE OKL_API.G_EXCEPTION_ERROR;

866: x_value => l_res_value);
867: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
868: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
869: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
870: RAISE OKL_API.G_EXCEPTION_ERROR;
871: END IF;
872: l_message := l_message || '
873:
874: '

Line 1123: l_return_status := OKL_API.G_RET_STS_SUCCESS;

1119:
1120: l_return_status VARCHAR2(1);
1121:
1122: BEGIN
1123: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1124:
1125: -- "RUN"
1126: IF (funcmode = 'RUN') THEN
1127: --l_user_id := fnd_profile.value('OKL_LEASE_CONTRACT_APPROVER');

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

1267: --rkuttiya added for 12.1.1 Multi GAAP Project
1268: AND representation_type = 'PRIMARY';
1269: --
1270:
1271: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
1272: l_api_version NUMBER := 1.0;
1273: l_msg_count NUMBER;
1274: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;
1275: l_msg_data VARCHAR2(2000);

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

1270:
1271: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
1272: l_api_version NUMBER := 1.0;
1273: l_msg_count NUMBER;
1274: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;
1275: l_msg_data VARCHAR2(2000);
1276: l_api_name VARCHAR2(30) := 'update_approval_status';
1277:
1278: l_chrv_id OKC_K_HEADERS_V.ID%TYPE;

Line 1304: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1300: x_msg_count => l_msg_count,
1301: x_msg_data => l_msg_data,
1302: p_khr_status => G_KHR_STS_APPROVED,
1303: p_chr_id => l_chrv_id);
1304: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1305: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1306: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1307: RAISE OKL_API.G_EXCEPTION_ERROR;
1308: END IF;

Line 1305: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1301: x_msg_data => l_msg_data,
1302: p_khr_status => G_KHR_STS_APPROVED,
1303: p_chr_id => l_chrv_id);
1304: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1305: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1306: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1307: RAISE OKL_API.G_EXCEPTION_ERROR;
1308: END IF;
1309:

Line 1306: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN

1302: p_khr_status => G_KHR_STS_APPROVED,
1303: p_chr_id => l_chrv_id);
1304: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1305: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1306: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1307: RAISE OKL_API.G_EXCEPTION_ERROR;
1308: END IF;
1309:
1310: Okl_Contract_Book_Pvt.post_approval_process(p_api_version => l_api_version,

Line 1307: RAISE OKL_API.G_EXCEPTION_ERROR;

1303: p_chr_id => l_chrv_id);
1304: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1305: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1306: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1307: RAISE OKL_API.G_EXCEPTION_ERROR;
1308: END IF;
1309:
1310: Okl_Contract_Book_Pvt.post_approval_process(p_api_version => l_api_version,
1311: p_init_msg_list => l_init_msg_list,

Line 1317: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1313: x_msg_count => l_msg_count,
1314: x_msg_data => l_msg_data,
1315: p_chr_id => l_chrv_id);
1316:
1317: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1318: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1319: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1320: RAISE OKL_API.G_EXCEPTION_ERROR;
1321: END IF;

Line 1318: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1314: x_msg_data => l_msg_data,
1315: p_chr_id => l_chrv_id);
1316:
1317: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1318: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1319: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1320: RAISE OKL_API.G_EXCEPTION_ERROR;
1321: END IF;
1322: ELSE

Line 1319: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN

1315: p_chr_id => l_chrv_id);
1316:
1317: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1318: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1319: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1320: RAISE OKL_API.G_EXCEPTION_ERROR;
1321: END IF;
1322: ELSE
1323: l_change_k_status(p_api_version => l_api_version,

Line 1320: RAISE OKL_API.G_EXCEPTION_ERROR;

1316:
1317: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1318: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1319: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1320: RAISE OKL_API.G_EXCEPTION_ERROR;
1321: END IF;
1322: ELSE
1323: l_change_k_status(p_api_version => l_api_version,
1324: p_init_msg_list => l_init_msg_list,

Line 1330: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1326: x_msg_count => l_msg_count,
1327: x_msg_data => l_msg_data,
1328: p_khr_status => G_KHR_STS_INCOMPLETE,
1329: p_chr_id => l_chrv_id);
1330: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1331: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1332: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1333: RAISE OKL_API.G_EXCEPTION_ERROR;
1334: END IF;

Line 1331: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1327: x_msg_data => l_msg_data,
1328: p_khr_status => G_KHR_STS_INCOMPLETE,
1329: p_chr_id => l_chrv_id);
1330: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1331: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1332: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1333: RAISE OKL_API.G_EXCEPTION_ERROR;
1334: END IF;
1335: END IF;

Line 1332: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN

1328: p_khr_status => G_KHR_STS_INCOMPLETE,
1329: p_chr_id => l_chrv_id);
1330: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1331: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1332: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1333: RAISE OKL_API.G_EXCEPTION_ERROR;
1334: END IF;
1335: END IF;
1336:

Line 1333: RAISE OKL_API.G_EXCEPTION_ERROR;

1329: p_chr_id => l_chrv_id);
1330: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1331: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1332: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1333: RAISE OKL_API.G_EXCEPTION_ERROR;
1334: END IF;
1335: END IF;
1336:
1337: -- trx's trx_number IS wf's trx_id

Line 1358: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1354: ,x_msg_data => l_msg_data
1355: ,p_tcnv_rec => l_trxH_in_rec
1356: ,x_tcnv_rec => l_trxH_out_rec);
1357:
1358: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1359: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1360: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1361: RAISE Okl_Api.G_EXCEPTION_ERROR;
1362: END IF;

Line 1359: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1355: ,p_tcnv_rec => l_trxH_in_rec
1356: ,x_tcnv_rec => l_trxH_out_rec);
1357:
1358: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1359: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1360: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1361: RAISE Okl_Api.G_EXCEPTION_ERROR;
1362: END IF;
1363:

Line 1360: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN

1356: ,x_tcnv_rec => l_trxH_out_rec);
1357:
1358: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1359: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1360: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1361: RAISE Okl_Api.G_EXCEPTION_ERROR;
1362: END IF;
1363:
1364: resultout := 'COMPLETE:';

Line 1361: RAISE Okl_Api.G_EXCEPTION_ERROR;

1357:
1358: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1359: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1360: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1361: RAISE Okl_Api.G_EXCEPTION_ERROR;
1362: END IF;
1363:
1364: resultout := 'COMPLETE:';
1365: RETURN;

Line 1383: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1379: resultout := 'COMPLETE:';
1380: RETURN;
1381: END IF;
1382: EXCEPTION
1383: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1384: wf_core.context(G_PKG_NAME,
1385: l_api_name,
1386: itemtype,
1387: itemkey,

Line 1391: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1387: itemkey,
1388: TO_CHAR(actid),
1389: funcmode);
1390: RAISE;
1391: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1392: wf_core.context(G_PKG_NAME,
1393: l_api_name,
1394: itemtype,
1395: itemkey,