eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_RECEIPTS_PVT dependencies on OKC_API

Line 97: OKC_API.set_message( p_app_name => G_APP_NAME,

93:
94: IF c_get_gl_date%NOTFOUND THEN
95: CLOSE c_get_gl_date;
96:
97: OKC_API.set_message( p_app_name => G_APP_NAME,
98: p_msg_name =>'OKL_BPD_GL_PERIOD_ERROR',
99: p_token1 => 'TRX_DATE',
100: p_token1_value => TRUNC(p_gl_date));
101:

Line 102: l_return_status := OKC_API.G_RET_STS_ERROR;

98: p_msg_name =>'OKL_BPD_GL_PERIOD_ERROR',
99: p_token1 => 'TRX_DATE',
100: p_token1_value => TRUNC(p_gl_date));
101:
102: l_return_status := OKC_API.G_RET_STS_ERROR;
103: RAISE G_EXCEPTION_HALT_VALIDATION;
104: END IF;
105: CLOSE c_get_gl_date;
106:

Line 240: l_receipt_currency_code = OKC_API.G_MISS_CHAR OR

236:
237: -- check for mandatory fields
238:
239: IF l_receipt_currency_code IS NULL OR
240: l_receipt_currency_code = OKC_API.G_MISS_CHAR OR
241: l_irm_id IS NULL OR
242: l_irm_id = OKC_API.G_MISS_NUM OR
243: l_rcpt_date IS NULL OR
244: l_rcpt_date = OKC_API.G_MISS_DATE OR

Line 242: l_irm_id = OKC_API.G_MISS_NUM OR

238:
239: IF l_receipt_currency_code IS NULL OR
240: l_receipt_currency_code = OKC_API.G_MISS_CHAR OR
241: l_irm_id IS NULL OR
242: l_irm_id = OKC_API.G_MISS_NUM OR
243: l_rcpt_date IS NULL OR
244: l_rcpt_date = OKC_API.G_MISS_DATE OR
245: l_gl_date IS NULL OR
246: l_gl_date = OKC_API.G_MISS_DATE OR

Line 244: l_rcpt_date = OKC_API.G_MISS_DATE OR

240: l_receipt_currency_code = OKC_API.G_MISS_CHAR OR
241: l_irm_id IS NULL OR
242: l_irm_id = OKC_API.G_MISS_NUM OR
243: l_rcpt_date IS NULL OR
244: l_rcpt_date = OKC_API.G_MISS_DATE OR
245: l_gl_date IS NULL OR
246: l_gl_date = OKC_API.G_MISS_DATE OR
247: l_org_id IS NULL OR
248: l_org_id = OKC_API.G_MISS_NUM OR

Line 246: l_gl_date = OKC_API.G_MISS_DATE OR

242: l_irm_id = OKC_API.G_MISS_NUM OR
243: l_rcpt_date IS NULL OR
244: l_rcpt_date = OKC_API.G_MISS_DATE OR
245: l_gl_date IS NULL OR
246: l_gl_date = OKC_API.G_MISS_DATE OR
247: l_org_id IS NULL OR
248: l_org_id = OKC_API.G_MISS_NUM OR
249: l_rcpt_amount = 0 OR
250: l_rcpt_amount = OKC_API.G_MISS_NUM OR

Line 248: l_org_id = OKC_API.G_MISS_NUM OR

244: l_rcpt_date = OKC_API.G_MISS_DATE OR
245: l_gl_date IS NULL OR
246: l_gl_date = OKC_API.G_MISS_DATE OR
247: l_org_id IS NULL OR
248: l_org_id = OKC_API.G_MISS_NUM OR
249: l_rcpt_amount = 0 OR
250: l_rcpt_amount = OKC_API.G_MISS_NUM OR
251: l_remittance_bank_account_id = OKC_API.G_MISS_NUM OR
252: l_remittance_bank_account_id IS NULL THEN

Line 250: l_rcpt_amount = OKC_API.G_MISS_NUM OR

246: l_gl_date = OKC_API.G_MISS_DATE OR
247: l_org_id IS NULL OR
248: l_org_id = OKC_API.G_MISS_NUM OR
249: l_rcpt_amount = 0 OR
250: l_rcpt_amount = OKC_API.G_MISS_NUM OR
251: l_remittance_bank_account_id = OKC_API.G_MISS_NUM OR
252: l_remittance_bank_account_id IS NULL THEN
253:
254: -- Message Text: Please enter all mandatory fields

Line 251: l_remittance_bank_account_id = OKC_API.G_MISS_NUM OR

247: l_org_id IS NULL OR
248: l_org_id = OKC_API.G_MISS_NUM OR
249: l_rcpt_amount = 0 OR
250: l_rcpt_amount = OKC_API.G_MISS_NUM OR
251: l_remittance_bank_account_id = OKC_API.G_MISS_NUM OR
252: l_remittance_bank_account_id IS NULL THEN
253:
254: -- Message Text: Please enter all mandatory fields
255: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 255: x_return_status := OKC_API.G_RET_STS_ERROR;

251: l_remittance_bank_account_id = OKC_API.G_MISS_NUM OR
252: l_remittance_bank_account_id IS NULL THEN
253:
254: -- Message Text: Please enter all mandatory fields
255: x_return_status := OKC_API.G_RET_STS_ERROR;
256: OKC_API.set_message( p_app_name => G_APP_NAME,
257: p_msg_name =>'OKL_BPD_MISSING_FIELDS');
258:
259: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 256: OKC_API.set_message( p_app_name => G_APP_NAME,

252: l_remittance_bank_account_id IS NULL THEN
253:
254: -- Message Text: Please enter all mandatory fields
255: x_return_status := OKC_API.G_RET_STS_ERROR;
256: OKC_API.set_message( p_app_name => G_APP_NAME,
257: p_msg_name =>'OKL_BPD_MISSING_FIELDS');
258:
259: RAISE G_EXCEPTION_HALT_VALIDATION;
260: -- Begin - varangan - Bug#6353486 - Sprint3 -Receipts

Line 266: x_return_status := OKC_API.G_RET_STS_ERROR;

262: (l_customer_num IS NULL OR l_customer_num = okl_api.g_miss_char) AND
263: (l_rcpt_rec.create_mode <> 'UNAPPLIED' ) ) then
264:
265: -- Message Text: A value must be entered for - COL_NAME.
266: x_return_status := OKC_API.G_RET_STS_ERROR;
267: OKC_API.set_message( p_app_name => G_APP_NAME,
268: p_msg_name =>'OKL_LLA_INCOMPLETE_RULE',
269: p_token1 => 'COL_NAME',
270: p_token1_value => 'Customer Name');

Line 267: OKC_API.set_message( p_app_name => G_APP_NAME,

263: (l_rcpt_rec.create_mode <> 'UNAPPLIED' ) ) then
264:
265: -- Message Text: A value must be entered for - COL_NAME.
266: x_return_status := OKC_API.G_RET_STS_ERROR;
267: OKC_API.set_message( p_app_name => G_APP_NAME,
268: p_msg_name =>'OKL_LLA_INCOMPLETE_RULE',
269: p_token1 => 'COL_NAME',
270: p_token1_value => 'Customer Name');
271: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 279: x_return_status := OKC_API.G_RET_STS_ERROR;

275: log_debug('Mandatory fieldss validations done');
276: -- Check for exceptions
277: IF l_rcpt_amount = 0 OR l_rcpt_amount IS NULL THEN
278: -- Message Text: The receipt cannot have a value of zero
279: x_return_status := OKC_API.G_RET_STS_ERROR;
280: OKC_API.set_message( p_app_name => G_APP_NAME,
281: p_msg_name => 'OKL_BPD_ZERO_RECEIPT');
282: RAISE G_EXCEPTION_HALT_VALIDATION;
283: END IF;

Line 280: OKC_API.set_message( p_app_name => G_APP_NAME,

276: -- Check for exceptions
277: IF l_rcpt_amount = 0 OR l_rcpt_amount IS NULL THEN
278: -- Message Text: The receipt cannot have a value of zero
279: x_return_status := OKC_API.G_RET_STS_ERROR;
280: OKC_API.set_message( p_app_name => G_APP_NAME,
281: p_msg_name => 'OKL_BPD_ZERO_RECEIPT');
282: RAISE G_EXCEPTION_HALT_VALIDATION;
283: END IF;
284: log_debug('Receipt Amount validations are done');

Line 342: l_return_status := OKC_API.G_RET_STS_ERROR;

338: log_debug('CCV - 1');
339: IF l_functional_currency <> l_receipt_currency_code AND
340: l_currency_conv_type IS NULL THEN
341: -- Message Text: Please enter a currency type.
342: l_return_status := OKC_API.G_RET_STS_ERROR;
343: OKC_API.set_message( p_app_name => G_APP_NAME,
344: p_msg_name => 'OKL_BPD_PLS_ENT_CUR_TYPE');
345: RAISE G_EXCEPTION_HALT_VALIDATION;
346: END IF;

Line 343: OKC_API.set_message( p_app_name => G_APP_NAME,

339: IF l_functional_currency <> l_receipt_currency_code AND
340: l_currency_conv_type IS NULL THEN
341: -- Message Text: Please enter a currency type.
342: l_return_status := OKC_API.G_RET_STS_ERROR;
343: OKC_API.set_message( p_app_name => G_APP_NAME,
344: p_msg_name => 'OKL_BPD_PLS_ENT_CUR_TYPE');
345: RAISE G_EXCEPTION_HALT_VALIDATION;
346: END IF;
347: log_debug('CCV - 2');

Line 353: l_return_status := OKC_API.G_RET_STS_ERROR;

349: IF l_currency_conv_type IS NOT NULL OR
350: nvl(l_currency_conv_rate,0) <> '0' THEN
351:
352: -- Message Text: Currency conversion values are not required when the receipt and invoice currency's are the same.
353: l_return_status := OKC_API.G_RET_STS_ERROR;
354: OKC_API.set_message( p_app_name => G_APP_NAME,
355: p_msg_name => 'OKL_BPD_SAME_CURRENCY');
356: RAISE G_EXCEPTION_HALT_VALIDATION;
357: END IF;

Line 354: OKC_API.set_message( p_app_name => G_APP_NAME,

350: nvl(l_currency_conv_rate,0) <> '0' THEN
351:
352: -- Message Text: Currency conversion values are not required when the receipt and invoice currency's are the same.
353: l_return_status := OKC_API.G_RET_STS_ERROR;
354: OKC_API.set_message( p_app_name => G_APP_NAME,
355: p_msg_name => 'OKL_BPD_SAME_CURRENCY');
356: RAISE G_EXCEPTION_HALT_VALIDATION;
357: END IF;
358: END IF;

Line 386: l_return_status := OKC_API.G_RET_STS_ERROR;

382: );
383:
384: IF l_functional_conversion_rate IN (0,-1) THEN
385: --No exchange rate defined
386: l_return_status := OKC_API.G_RET_STS_ERROR;
387: OKC_API.set_message( p_app_name => G_APP_NAME,
388: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
389: RAISE G_EXCEPTION_HALT_VALIDATION;
390: END IF;

Line 387: OKC_API.set_message( p_app_name => G_APP_NAME,

383:
384: IF l_functional_conversion_rate IN (0,-1) THEN
385: --No exchange rate defined
386: l_return_status := OKC_API.G_RET_STS_ERROR;
387: OKC_API.set_message( p_app_name => G_APP_NAME,
388: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
389: RAISE G_EXCEPTION_HALT_VALIDATION;
390: END IF;
391:

Line 399: l_return_status := OKC_API.G_RET_STS_ERROR;

395: l_currency_conv_type IN ('User') THEN
396: log_debug('CCV - 4');
397: IF l_currency_conv_rate IS NULL OR l_currency_conv_rate = '0' THEN
398: -- Message Text: No exchange rate defined for currency conversion type USER.
399: l_return_status := OKC_API.G_RET_STS_ERROR;
400: OKC_API.set_message( p_app_name => G_APP_NAME,
401: p_msg_name => 'OKL_BPD_USR_RTE_SUPPLIED');
402: RAISE G_EXCEPTION_HALT_VALIDATION;
403: ELSE

Line 400: OKC_API.set_message( p_app_name => G_APP_NAME,

396: log_debug('CCV - 4');
397: IF l_currency_conv_rate IS NULL OR l_currency_conv_rate = '0' THEN
398: -- Message Text: No exchange rate defined for currency conversion type USER.
399: l_return_status := OKC_API.G_RET_STS_ERROR;
400: OKC_API.set_message( p_app_name => G_APP_NAME,
401: p_msg_name => 'OKL_BPD_USR_RTE_SUPPLIED');
402: RAISE G_EXCEPTION_HALT_VALIDATION;
403: ELSE
404: l_functional_conversion_rate := l_currency_conv_rate;

Line 680: x_return_status := OKC_API.G_RET_STS_ERROR;

676:
677: IF l_conversion_rate IN (0,-1) THEN
678:
679: -- Message Text: No exchange rate defined
680: x_return_status := OKC_API.G_RET_STS_ERROR;
681: OKC_API.set_message( p_app_name => G_APP_NAME,
682: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
683:
684: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 681: OKC_API.set_message( p_app_name => G_APP_NAME,

677: IF l_conversion_rate IN (0,-1) THEN
678:
679: -- Message Text: No exchange rate defined
680: x_return_status := OKC_API.G_RET_STS_ERROR;
681: OKC_API.set_message( p_app_name => G_APP_NAME,
682: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
683:
684: RAISE G_EXCEPTION_HALT_VALIDATION;
685:

Line 697: x_return_status := OKC_API.G_RET_STS_ERROR;

693:
694: IF l_receipt_amount = 0 OR l_receipt_amount IS NULL THEN
695:
696: -- Message Text: The receipt cannot have a value of zero
697: x_return_status := OKC_API.G_RET_STS_ERROR;
698: OKC_API.set_message( p_app_name => G_APP_NAME,
699: p_msg_name => 'OKL_BPD_ZERO_RECEIPT');
700:
701: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 698: OKC_API.set_message( p_app_name => G_APP_NAME,

694: IF l_receipt_amount = 0 OR l_receipt_amount IS NULL THEN
695:
696: -- Message Text: The receipt cannot have a value of zero
697: x_return_status := OKC_API.G_RET_STS_ERROR;
698: OKC_API.set_message( p_app_name => G_APP_NAME,
699: p_msg_name => 'OKL_BPD_ZERO_RECEIPT');
700:
701: RAISE G_EXCEPTION_HALT_VALIDATION;
702: END IF;

Line 2319: x_return_status := okc_api.g_ret_sts_error;

2315: );
2316: IF l_trans_to_receipt_rate IN (0, -1)
2317: THEN
2318: -- Message Text: No exchange rate defined
2319: x_return_status := okc_api.g_ret_sts_error;
2320: okc_api.set_message
2321: (p_app_name => g_app_name,
2322: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE'
2323: );

Line 2320: okc_api.set_message

2316: IF l_trans_to_receipt_rate IN (0, -1)
2317: THEN
2318: -- Message Text: No exchange rate defined
2319: x_return_status := okc_api.g_ret_sts_error;
2320: okc_api.set_message
2321: (p_app_name => g_app_name,
2322: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE'
2323: );
2324: RAISE g_exception_halt_validation;