DBA Data[Home] [Help]

APPS.OKL_CREDIT_MGNT_PVT dependencies on OKL_API

Line 9: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

5: -- submit_credit_request
6: ------------------------
7: PROCEDURE submit_credit_request
8: (p_api_version IN NUMBER
9: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
10: ,x_return_status OUT NOCOPY VARCHAR2
11: ,x_msg_count OUT NOCOPY NUMBER
12: ,x_msg_data OUT NOCOPY VARCHAR2
13: ,p_contract_id IN NUMBER

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

56: l_cm_installed := AR_CMGT_CREDIT_REQUEST_API.is_Credit_Management_Installed;
57:
58: IF NOT l_cm_installed THEN
59:
60: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,
61: p_msg_name => 'OKL_CM_NOTINSTALLED');
62:
63: RAISE G_EXCEPTION_ERROR;
64:

Line 73: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

69: CLOSE c_check_submitted;
70:
71: IF l_application_number IS NOT NULL THEN
72:
73: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
74: p_msg_name => 'OKL_CR_SUBMITTED',
75: p_token1 => 'REQ_ID',
76: p_token1_value => l_application_number,
77: p_token2 => 'REQ_STATUS',

Line 86: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

82: END IF;
83:
84: IF p_requested_amount <= 0 THEN
85:
86: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
87: p_msg_name => 'OKL_CR_AMT_ZERO');
88:
89: RAISE G_EXCEPTION_ERROR;
90:

Line 121: ,p_init_msg_list => OKL_API.G_FALSE

117: CLOSE c_credit_class;
118:
119: ar_cmgt_credit_request_api.create_credit_request
120: ( p_api_version => G_API_VERSION
121: ,p_init_msg_list => OKL_API.G_FALSE
122: ,p_commit => 'Y'
123: ,p_validation_level => ''
124: ,x_return_status => l_return_status
125: ,x_msg_count => x_msg_count

Line 159: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN

155: ,p_source_column3 => ''
156: ,p_credit_request_id => lx_credit_request_id
157: ,p_review_cycle => '');
158:
159: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
160: RAISE G_EXCEPTION_ERROR;
161: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
162: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
163: END IF;

Line 161: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

157: ,p_review_cycle => '');
158:
159: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
160: RAISE G_EXCEPTION_ERROR;
161: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
162: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
163: END IF;
164:
165: l_crqv_rec.quote_id := p_contract_id;

Line 180: ,p_init_msg_list => OKL_API.G_FALSE

176: l_crqv_rec.org_id := l_org_id;
177:
178: okl_credit_request_pub.insert_credit_request(
179: p_api_version => G_API_VERSION
180: ,p_init_msg_list => OKL_API.G_FALSE
181: ,x_return_status => l_return_status
182: ,x_msg_count => x_msg_count
183: ,x_msg_data => x_msg_data
184: ,p_crqv_rec => l_crqv_rec

Line 209: p_init_msg_list => OKL_API.G_FALSE,

205: l_interaction_rec.party_id := l_party_id;
206:
207: jtf_ih_pub.open_interaction(
208: p_api_version => G_API_VERSION,
209: p_init_msg_list => OKL_API.G_FALSE,
210: p_commit => OKL_API.G_TRUE,
211: p_user_id => fnd_global.USER_ID,
212: p_login_id => fnd_global.LOGIN_ID,
213: x_return_status => l_return_status,

Line 210: p_commit => OKL_API.G_TRUE,

206:
207: jtf_ih_pub.open_interaction(
208: p_api_version => G_API_VERSION,
209: p_init_msg_list => OKL_API.G_FALSE,
210: p_commit => OKL_API.G_TRUE,
211: p_user_id => fnd_global.USER_ID,
212: p_login_id => fnd_global.LOGIN_ID,
213: x_return_status => l_return_status,
214: x_msg_count => x_msg_count,

Line 219: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN

215: x_msg_data => x_msg_data,
216: p_interaction_rec => l_interaction_rec,
217: x_interaction_id => lx_interaction_id);
218:
219: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
220: RAISE G_EXCEPTION_ERROR;
221: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
222: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
223: END IF;

Line 221: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

217: x_interaction_id => lx_interaction_id);
218:
219: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
220: RAISE G_EXCEPTION_ERROR;
221: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
222: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
223: END IF;
224:
225: l_activity_rec.cust_account_id := p_chr_rec.cust_acct_id;

Line 235: p_init_msg_list => OKL_API.G_FALSE,

231: l_activity_rec.action_id := 1;
232:
233: jtf_ih_pub.add_activity(
234: p_api_version => G_API_VERSION,
235: p_init_msg_list => OKL_API.G_FALSE,
236: p_commit => OKL_API.G_TRUE,
237: p_user_id => fnd_global.USER_ID,
238: p_login_id => fnd_global.LOGIN_ID,
239: x_return_status => l_return_status,

Line 236: p_commit => OKL_API.G_TRUE,

232:
233: jtf_ih_pub.add_activity(
234: p_api_version => G_API_VERSION,
235: p_init_msg_list => OKL_API.G_FALSE,
236: p_commit => OKL_API.G_TRUE,
237: p_user_id => fnd_global.USER_ID,
238: p_login_id => fnd_global.LOGIN_ID,
239: x_return_status => l_return_status,
240: x_msg_count => x_msg_count,

Line 253: p_init_msg_list => OKL_API.G_FALSE,

249: END IF;
250:
251: jtf_ih_pub.CLOSE_INTERACTION (
252: p_api_version => G_API_VERSION,
253: p_init_msg_list => OKL_API.G_FALSE,
254: p_commit => OKL_API.G_TRUE,
255: P_RESP_APPL_ID => 540,
256: P_RESP_ID => fnd_global.RESP_ID,
257: p_user_id => fnd_global.USER_ID,

Line 254: p_commit => OKL_API.G_TRUE,

250:
251: jtf_ih_pub.CLOSE_INTERACTION (
252: p_api_version => G_API_VERSION,
253: p_init_msg_list => OKL_API.G_FALSE,
254: p_commit => OKL_API.G_TRUE,
255: P_RESP_APPL_ID => 540,
256: P_RESP_ID => fnd_global.RESP_ID,
257: p_user_id => fnd_global.USER_ID,
258: p_login_id => fnd_global.LOGIN_ID,

Line 264: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN

260: x_msg_count => x_msg_count,
261: x_msg_data => x_msg_data,
262: P_INTERACTION_ID => lx_interaction_id);
263:
264: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
265: RAISE G_EXCEPTION_ERROR;
266: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
267: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
268: END IF;

Line 266: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

262: P_INTERACTION_ID => lx_interaction_id);
263:
264: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
265: RAISE G_EXCEPTION_ERROR;
266: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
267: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
268: END IF;
269:
270: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN

Line 270: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN

266: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
267: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
268: END IF;
269:
270: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN
271:
272: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,
273: p_msg_name => 'OKL_CR_SUBMIT',
274: p_token1 => 'REQ_NUM',

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

268: END IF;
269:
270: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN
271:
272: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,
273: p_msg_name => 'OKL_CR_SUBMIT',
274: p_token1 => 'REQ_NUM',
275: p_token1_value => l_application_number);
276: END IF;

Line 290: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

286: x_return_status := G_RET_STS_UNEXP_ERROR;
287:
288: WHEN OTHERS THEN
289:
290: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
291: p_msg_name => G_UNEXPECTED_ERROR,
292: p_token1 => G_SQLCODE_TOKEN,
293: p_token1_value => SQLCODE,
294: p_token2 => G_SQLERRM_TOKEN,

Line 307: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

303: -- compile_credit_request
304: -------------------------
305: PROCEDURE compile_credit_request
306: (p_api_version IN NUMBER
307: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
308: ,x_return_status OUT NOCOPY VARCHAR2
309: ,x_msg_count OUT NOCOPY NUMBER
310: ,x_msg_data OUT NOCOPY VARCHAR2
311: ,p_contract_id IN NUMBER

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

330: l_cm_installed := AR_CMGT_CREDIT_REQUEST_API.is_Credit_Management_Installed;
331:
332: IF NOT l_cm_installed THEN
333:
334: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,
335: p_msg_name => 'OKL_CM_NOTINSTALLED');
336:
337: RAISE G_EXCEPTION_ERROR;
338:

Line 347: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

343: CLOSE c_check_submitted;
344:
345: IF l_application_number IS NOT NULL THEN
346:
347: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
348: p_msg_name => 'OKL_CR_SUBMITTED',
349: p_token1 => 'REQ_ID',
350: p_token1_value => l_application_number,
351: p_token2 => 'REQ_STATUS',

Line 359: p_init_msg_list => OKL_API.G_FALSE,

355:
356: END IF;
357:
358: okl_execute_formula_pub.execute(p_api_version => G_API_VERSION,
359: p_init_msg_list => OKL_API.G_FALSE,
360: x_return_status => l_return_status,
361: x_msg_count => x_msg_count,
362: x_msg_data => x_msg_data,
363: p_formula_name => 'CONTRACT_FINANCED_AMOUNT',

Line 410: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

406: x_return_status := G_RET_STS_UNEXP_ERROR;
407:
408: WHEN OTHERS THEN
409:
410: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
411: p_msg_name => G_UNEXPECTED_ERROR,
412: p_token1 => G_SQLCODE_TOKEN,
413: p_token1_value => SQLCODE,
414: p_token2 => G_SQLERRM_TOKEN,