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_EXECUTE_FORMULA_PVT dependencies on OKC_API

Line 19: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

15: -- End of comments
16:
17:
18: PROCEDURE execute_eligibility_Criteria(p_api_version IN NUMBER
19: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
20: ,x_return_status OUT NOCOPY VARCHAR2
21: ,x_msg_count OUT NOCOPY NUMBER
22: ,x_msg_data OUT NOCOPY VARCHAR2
23: ,p_function_name IN okl_data_src_fnctns_v.name%TYPE

Line 33: l_init_msg_list VARCHAR2(1) DEFAULT OKC_API.G_FALSE;

29: FUNCTION_RETURNS_NULL EXCEPTION;
30:
31: -- Local Variable Declarations
32: l_value NUMBER;
33: l_init_msg_list VARCHAR2(1) DEFAULT OKC_API.G_FALSE;
34: l_return_status VARCHAR2(1);
35: l_msg_count NUMBER;
36: l_msg_data VARCHAR2(2000);
37: l_evaluated_string okl_formulae_v.formula_string%TYPE;

Line 91: x_return_status := OKC_API.G_RET_STS_SUCCESS;

87:
88: IF l_value IS NULL THEN
89: RAISE FUNCTION_RETURNS_NULL;
90: ELSE
91: x_return_status := OKC_API.G_RET_STS_SUCCESS;
92: x_value := l_value;
93: END IF;
94:
95: EXCEPTION

Line 97: OKC_API.SET_MESSAGE(p_app_name => g_app_name

93: END IF;
94:
95: EXCEPTION
96: WHEN FUNCTION_RETURNS_NULL THEN
97: OKC_API.SET_MESSAGE(p_app_name => g_app_name
98: ,p_msg_name => 'OKL_FUNCTION_RETURNS_NULL'
99: ,p_token1 => 'FUNCTION'
100: ,p_token1_value => l_function_name );
101: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 101: x_return_status := OKC_API.G_RET_STS_ERROR;

97: OKC_API.SET_MESSAGE(p_app_name => g_app_name
98: ,p_msg_name => 'OKL_FUNCTION_RETURNS_NULL'
99: ,p_token1 => 'FUNCTION'
100: ,p_token1_value => l_function_name );
101: x_return_status := OKC_API.G_RET_STS_ERROR;
102:
103: WHEN FUNCTION_DATA_INVALID THEN
104: OKC_API.SET_MESSAGE(p_app_name => g_app_name
105: ,p_msg_name => g_function_data_invalid

Line 104: OKC_API.SET_MESSAGE(p_app_name => g_app_name

100: ,p_token1_value => l_function_name );
101: x_return_status := OKC_API.G_RET_STS_ERROR;
102:
103: WHEN FUNCTION_DATA_INVALID THEN
104: OKC_API.SET_MESSAGE(p_app_name => g_app_name
105: ,p_msg_name => g_function_data_invalid
106: ,p_token1 => 'FUNCTION'
107: ,p_token1_value => l_function_name );
108: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 108: x_return_status := OKC_API.G_RET_STS_ERROR;

104: OKC_API.SET_MESSAGE(p_app_name => g_app_name
105: ,p_msg_name => g_function_data_invalid
106: ,p_token1 => 'FUNCTION'
107: ,p_token1_value => l_function_name );
108: x_return_status := OKC_API.G_RET_STS_ERROR;
109:
110: WHEN NO_DATA_FOUND THEN
111: OKC_API.SET_MESSAGE(p_app_name => g_app_name
112: ,p_msg_name => g_invalid_function

Line 111: OKC_API.SET_MESSAGE(p_app_name => g_app_name

107: ,p_token1_value => l_function_name );
108: x_return_status := OKC_API.G_RET_STS_ERROR;
109:
110: WHEN NO_DATA_FOUND THEN
111: OKC_API.SET_MESSAGE(p_app_name => g_app_name
112: ,p_msg_name => g_invalid_function
113: ,p_token1 => 'FUNCTION'
114: ,p_token1_value => l_function_name );
115: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 115: x_return_status := OKC_API.G_RET_STS_ERROR;

111: OKC_API.SET_MESSAGE(p_app_name => g_app_name
112: ,p_msg_name => g_invalid_function
113: ,p_token1 => 'FUNCTION'
114: ,p_token1_value => l_function_name );
115: x_return_status := OKC_API.G_RET_STS_ERROR;
116:
117: WHEN OTHERS THEN
118: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
119: p_msg_name => G_DB_ERROR,

Line 127: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

123: p_token2_value => sqlcode,
124: p_token3 => G_SQLERRM_TOKEN,
125: p_token3_value => sqlerrm);
126:
127: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
128: END execute_eligibility_Criteria;
129:
130:
131: -- Start of comments

Line 141: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

137: -- Version : 1.0
138: -- End of comments
139:
140: PROCEDURE execute_function(p_api_version IN NUMBER
141: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
142: ,x_return_status OUT NOCOPY VARCHAR2
143:
144: ,x_msg_count OUT NOCOPY NUMBER
145: ,x_msg_data OUT NOCOPY VARCHAR2

Line 177: l_init_msg_list VARCHAR2(1) DEFAULT OKC_API.G_FALSE;

173: l_formula_id okl_formulae_v.id%TYPE;
174: l_contract_id okl_k_headers_v.id%TYPE;
175: l_line_id okl_k_lines_v.id%TYPE;
176: l_value NUMBER;
177: l_init_msg_list VARCHAR2(1) DEFAULT OKC_API.G_FALSE;
178: l_return_status VARCHAR2(1);
179: l_msg_count NUMBER;
180: l_msg_data VARCHAR2(2000);
181: l_formula_string okl_formulae_v.formula_string%TYPE;

Line 363: x_return_status := OKC_API.G_RET_STS_SUCCESS;

359:
360: IF l_value IS NULL THEN
361: RAISE FUNCTION_RETURNS_NULL;
362: ELSE
363: x_return_status := OKC_API.G_RET_STS_SUCCESS;
364: x_value := l_value;
365: END IF;
366:
367: EXCEPTION

Line 369: OKC_API.SET_MESSAGE(p_app_name => g_app_name

365: END IF;
366:
367: EXCEPTION
368: WHEN FUNCTION_RETURNS_NULL THEN
369: OKC_API.SET_MESSAGE(p_app_name => g_app_name
370: ,p_msg_name => 'OKL_FUNCTION_RETURNS_NULL'
371: ,p_token1 => 'FUNCTION'
372: ,p_token1_value => l_function_name );
373: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 373: x_return_status := OKC_API.G_RET_STS_ERROR;

369: OKC_API.SET_MESSAGE(p_app_name => g_app_name
370: ,p_msg_name => 'OKL_FUNCTION_RETURNS_NULL'
371: ,p_token1 => 'FUNCTION'
372: ,p_token1_value => l_function_name );
373: x_return_status := OKC_API.G_RET_STS_ERROR;
374:
375: WHEN NO_DML_EXCEPTION THEN
376: OKC_API.SET_MESSAGE(p_app_name => g_app_name
377: ,p_msg_name => g_formulae_no_dml

Line 376: OKC_API.SET_MESSAGE(p_app_name => g_app_name

372: ,p_token1_value => l_function_name );
373: x_return_status := OKC_API.G_RET_STS_ERROR;
374:
375: WHEN NO_DML_EXCEPTION THEN
376: OKC_API.SET_MESSAGE(p_app_name => g_app_name
377: ,p_msg_name => g_formulae_no_dml
378: ,p_token1 => 'FUNCTION'
379: ,p_token1_value => l_function_name );
380: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 380: x_return_status := OKC_API.G_RET_STS_ERROR;

376: OKC_API.SET_MESSAGE(p_app_name => g_app_name
377: ,p_msg_name => g_formulae_no_dml
378: ,p_token1 => 'FUNCTION'
379: ,p_token1_value => l_function_name );
380: x_return_status := OKC_API.G_RET_STS_ERROR;
381:
382: WHEN FUNCTION_DOES_NOT_EXIST THEN
383: OKC_API.SET_MESSAGE(p_app_name => g_app_name
384: ,p_msg_name => g_function_does_not_exist

Line 383: OKC_API.SET_MESSAGE(p_app_name => g_app_name

379: ,p_token1_value => l_function_name );
380: x_return_status := OKC_API.G_RET_STS_ERROR;
381:
382: WHEN FUNCTION_DOES_NOT_EXIST THEN
383: OKC_API.SET_MESSAGE(p_app_name => g_app_name
384: ,p_msg_name => g_function_does_not_exist
385: ,p_token1 => 'FUNCTION'
386: ,p_token1_value => l_function_name );
387: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 387: x_return_status := OKC_API.G_RET_STS_ERROR;

383: OKC_API.SET_MESSAGE(p_app_name => g_app_name
384: ,p_msg_name => g_function_does_not_exist
385: ,p_token1 => 'FUNCTION'
386: ,p_token1_value => l_function_name );
387: x_return_status := OKC_API.G_RET_STS_ERROR;
388:
389: WHEN FUNCTION_DATA_INVALID THEN
390: OKC_API.SET_MESSAGE(p_app_name => g_app_name
391: ,p_msg_name => g_function_data_invalid

Line 390: OKC_API.SET_MESSAGE(p_app_name => g_app_name

386: ,p_token1_value => l_function_name );
387: x_return_status := OKC_API.G_RET_STS_ERROR;
388:
389: WHEN FUNCTION_DATA_INVALID THEN
390: OKC_API.SET_MESSAGE(p_app_name => g_app_name
391: ,p_msg_name => g_function_data_invalid
392: ,p_token1 => 'FUNCTION'
393: ,p_token1_value => l_function_name );
394: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 394: x_return_status := OKC_API.G_RET_STS_ERROR;

390: OKC_API.SET_MESSAGE(p_app_name => g_app_name
391: ,p_msg_name => g_function_data_invalid
392: ,p_token1 => 'FUNCTION'
393: ,p_token1_value => l_function_name );
394: x_return_status := OKC_API.G_RET_STS_ERROR;
395:
396: WHEN G_EXCEPTION_HALT_PROCESSING THEN
397: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
398:

Line 397: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

393: ,p_token1_value => l_function_name );
394: x_return_status := OKC_API.G_RET_STS_ERROR;
395:
396: WHEN G_EXCEPTION_HALT_PROCESSING THEN
397: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
398:
399: WHEN G_EXCEPTION_ERROR THEN
400: x_return_status := OKC_API.G_RET_STS_ERROR;
401:

Line 400: x_return_status := OKC_API.G_RET_STS_ERROR;

396: WHEN G_EXCEPTION_HALT_PROCESSING THEN
397: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
398:
399: WHEN G_EXCEPTION_ERROR THEN
400: x_return_status := OKC_API.G_RET_STS_ERROR;
401:
402: WHEN NO_CONSTANT_SPECIFIED THEN
403: OKC_API.SET_MESSAGE(p_app_name => g_app_name
404: ,p_msg_name => g_no_constant_function

Line 403: OKC_API.SET_MESSAGE(p_app_name => g_app_name

399: WHEN G_EXCEPTION_ERROR THEN
400: x_return_status := OKC_API.G_RET_STS_ERROR;
401:
402: WHEN NO_CONSTANT_SPECIFIED THEN
403: OKC_API.SET_MESSAGE(p_app_name => g_app_name
404: ,p_msg_name => g_no_constant_function
405: ,p_token1 => 'FUNCTION'
406: ,p_token1_value => l_function_name );
407: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 407: x_return_status := OKC_API.G_RET_STS_ERROR;

403: OKC_API.SET_MESSAGE(p_app_name => g_app_name
404: ,p_msg_name => g_no_constant_function
405: ,p_token1 => 'FUNCTION'
406: ,p_token1_value => l_function_name );
407: x_return_status := OKC_API.G_RET_STS_ERROR;
408:
409: WHEN NO_DATA_FOUND THEN
410:
411: OKC_API.SET_MESSAGE(p_app_name => g_app_name

Line 411: OKC_API.SET_MESSAGE(p_app_name => g_app_name

407: x_return_status := OKC_API.G_RET_STS_ERROR;
408:
409: WHEN NO_DATA_FOUND THEN
410:
411: OKC_API.SET_MESSAGE(p_app_name => g_app_name
412: ,p_msg_name => g_invalid_function
413: ,p_token1 => 'FUNCTION'
414: ,p_token1_value => l_function_name );
415: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 415: x_return_status := OKC_API.G_RET_STS_ERROR;

411: OKC_API.SET_MESSAGE(p_app_name => g_app_name
412: ,p_msg_name => g_invalid_function
413: ,p_token1 => 'FUNCTION'
414: ,p_token1_value => l_function_name );
415: x_return_status := OKC_API.G_RET_STS_ERROR;
416:
417: WHEN VALUE_ERROR THEN
418: OKC_API.SET_MESSAGE(p_app_name => g_app_name
419: ,p_msg_name => 'OKL_FUNCTION_VALUE_ERROR'

Line 418: OKC_API.SET_MESSAGE(p_app_name => g_app_name

414: ,p_token1_value => l_function_name );
415: x_return_status := OKC_API.G_RET_STS_ERROR;
416:
417: WHEN VALUE_ERROR THEN
418: OKC_API.SET_MESSAGE(p_app_name => g_app_name
419: ,p_msg_name => 'OKL_FUNCTION_VALUE_ERROR'
420: ,p_token1 => 'FUNCTION'
421: ,p_token1_value => l_function_name );
422: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 422: x_return_status := OKC_API.G_RET_STS_ERROR;

418: OKC_API.SET_MESSAGE(p_app_name => g_app_name
419: ,p_msg_name => 'OKL_FUNCTION_VALUE_ERROR'
420: ,p_token1 => 'FUNCTION'
421: ,p_token1_value => l_function_name );
422: x_return_status := OKC_API.G_RET_STS_ERROR;
423:
424: WHEN OTHERS THEN
425: OKC_API.SET_MESSAGE(p_app_name => g_app_name
426: ,p_msg_name => g_unexpected_error

Line 425: OKC_API.SET_MESSAGE(p_app_name => g_app_name

421: ,p_token1_value => l_function_name );
422: x_return_status := OKC_API.G_RET_STS_ERROR;
423:
424: WHEN OTHERS THEN
425: OKC_API.SET_MESSAGE(p_app_name => g_app_name
426: ,p_msg_name => g_unexpected_error
427: ,p_token1 => g_sqlcode_token
428: ,p_token1_value => sqlcode
429: ,p_token2 => g_sqlerrm_token

Line 431: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

427: ,p_token1 => g_sqlcode_token
428: ,p_token1_value => sqlcode
429: ,p_token2 => g_sqlerrm_token
430: ,p_token2_value => sqlerrm);
431: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
432: END execute_function;
433:
434: -- Start of comments
435: --

Line 446: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

442: -- Version : 1.0
443: -- End of comments
444:
445: PROCEDURE execute_formula(p_api_version IN NUMBER
446: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
447: ,x_return_status OUT NOCOPY VARCHAR2
448: ,x_msg_count OUT NOCOPY NUMBER
449: ,x_msg_data OUT NOCOPY VARCHAR2
450: ,p_formula_id IN okl_formulae_v.id%TYPE

Line 469: l_init_msg_list VARCHAR2(1) DEFAULT OKC_API.G_FALSE;

465: l_formula_name okl_formulae_v.name%TYPE;
466: l_contract_id okl_k_headers_v.id%TYPE;
467: l_line_id okl_k_lines_v.id%TYPE;
468: l_value NUMBER;
469: l_init_msg_list VARCHAR2(1) DEFAULT OKC_API.G_FALSE;
470: l_return_status VARCHAR2(1);
471: l_msg_count NUMBER;
472: l_msg_data VARCHAR2(2000);
473: l_formula_string okl_formulae_v.formula_string%TYPE;

Line 587: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

583: ,p_contract_id => l_contract_id
584: ,p_line_id => l_line_id
585: ,x_value => l_value
586: );
587: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
588: RAISE G_EXCEPTION_HALT_PROCESSING;
589: ELSE
590: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
591: x_return_status := l_return_status;

Line 590: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

586: );
587: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
588: RAISE G_EXCEPTION_HALT_PROCESSING;
589: ELSE
590: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
591: x_return_status := l_return_status;
592: -- commented by prasjain for bug #5951213
593: -- l_operand_val_tbl(i).value := l_value;
594: -- added by prasjain for bug #5951213

Line 625: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

621: ,p_line_id => l_line_id
622: ,p_ctx_parameter_tbl => l_ctxt_parameter_tbl
623: ,x_operand_val_tbl => l_operand_val_tbl_null
624: ,x_value => l_value);
625: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
626: RAISE G_EXCEPTION_HALT_PROCESSING;
627: ELSE
628: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
629: x_return_status := l_return_status;

Line 628: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

624: ,x_value => l_value);
625: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
626: RAISE G_EXCEPTION_HALT_PROCESSING;
627: ELSE
628: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
629: x_return_status := l_return_status;
630: -- commented by prasjain for bug #5951213
631: -- l_operand_val_tbl(i).value := l_value;
632: -- added by prasjain for bug #5951213

Line 724: x_return_status := OKC_API.G_RET_STS_SUCCESS;

720: l_evaluated_string := 'BEGIN :l_output_value := ' || l_evaluated_string || '; END;';
721: EXECUTE IMMEDIATE l_evaluated_string USING OUT l_value;
722:
723: x_operand_val_tbl := l_operand_val_tbl;
724: x_return_status := OKC_API.G_RET_STS_SUCCESS;
725: x_value := l_value;
726:
727: EXCEPTION
728: WHEN NO_FORMULA_OPERAND_FOUND THEN

Line 729: OKC_API.SET_MESSAGE(p_app_name => g_app_name

725: x_value := l_value;
726:
727: EXCEPTION
728: WHEN NO_FORMULA_OPERAND_FOUND THEN
729: OKC_API.SET_MESSAGE(p_app_name => g_app_name
730: ,p_msg_name => g_invalid_formula_operand
731: ,p_token1 => 'FORMULA'
732: ,p_token1_value => l_formula_name );
733:

Line 735: x_return_status := OKC_API.G_RET_STS_ERROR;

731: ,p_token1 => 'FORMULA'
732: ,p_token1_value => l_formula_name );
733:
734:
735: x_return_status := OKC_API.G_RET_STS_ERROR;
736:
737: WHEN NO_OPERAND_FOUND THEN
738: OKC_API.SET_MESSAGE(p_app_name => g_app_name
739: ,p_msg_name => g_invalid_operand

Line 738: OKC_API.SET_MESSAGE(p_app_name => g_app_name

734:
735: x_return_status := OKC_API.G_RET_STS_ERROR;
736:
737: WHEN NO_OPERAND_FOUND THEN
738: OKC_API.SET_MESSAGE(p_app_name => g_app_name
739: ,p_msg_name => g_invalid_operand
740: ,p_token1 => 'FORMULA'
741: ,p_token1_value => l_formula_name );
742: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 742: x_return_status := OKC_API.G_RET_STS_ERROR;

738: OKC_API.SET_MESSAGE(p_app_name => g_app_name
739: ,p_msg_name => g_invalid_operand
740: ,p_token1 => 'FORMULA'
741: ,p_token1_value => l_formula_name );
742: x_return_status := OKC_API.G_RET_STS_ERROR;
743:
744: WHEN NO_CONSTANT_SPECIFIED THEN
745: OKC_API.SET_MESSAGE(p_app_name => g_app_name
746: ,p_msg_name => g_no_constant_operand

Line 745: OKC_API.SET_MESSAGE(p_app_name => g_app_name

741: ,p_token1_value => l_formula_name );
742: x_return_status := OKC_API.G_RET_STS_ERROR;
743:
744: WHEN NO_CONSTANT_SPECIFIED THEN
745: OKC_API.SET_MESSAGE(p_app_name => g_app_name
746: ,p_msg_name => g_no_constant_operand
747: ,p_token1 => 'OPERAND'
748: ,p_token1_value => l_operand_name );
749: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 749: x_return_status := OKC_API.G_RET_STS_ERROR;

745: OKC_API.SET_MESSAGE(p_app_name => g_app_name
746: ,p_msg_name => g_no_constant_operand
747: ,p_token1 => 'OPERAND'
748: ,p_token1_value => l_operand_name );
749: x_return_status := OKC_API.G_RET_STS_ERROR;
750:
751: WHEN OPERAND_DATA_INVALID THEN
752: OKC_API.SET_MESSAGE(p_app_name => g_app_name
753: ,p_msg_name => g_operand_data_invalid

Line 752: OKC_API.SET_MESSAGE(p_app_name => g_app_name

748: ,p_token1_value => l_operand_name );
749: x_return_status := OKC_API.G_RET_STS_ERROR;
750:
751: WHEN OPERAND_DATA_INVALID THEN
752: OKC_API.SET_MESSAGE(p_app_name => g_app_name
753: ,p_msg_name => g_operand_data_invalid
754: ,p_token1 => 'OPERAND'
755: ,p_token1_value => l_operand_name );
756: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 756: x_return_status := OKC_API.G_RET_STS_ERROR;

752: OKC_API.SET_MESSAGE(p_app_name => g_app_name
753: ,p_msg_name => g_operand_data_invalid
754: ,p_token1 => 'OPERAND'
755: ,p_token1_value => l_operand_name );
756: x_return_status := OKC_API.G_RET_STS_ERROR;
757:
758: WHEN G_EXCEPTION_HALT_PROCESSING THEN
759: IF formula_csr%ISOPEN THEN
760: CLOSE formula_csr;

Line 762: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

758: WHEN G_EXCEPTION_HALT_PROCESSING THEN
759: IF formula_csr%ISOPEN THEN
760: CLOSE formula_csr;
761: END IF;
762: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
763:
764: WHEN G_EXCEPTION_ERROR THEN
765: x_return_status := OKC_API.G_RET_STS_ERROR;
766:

Line 765: x_return_status := OKC_API.G_RET_STS_ERROR;

761: END IF;
762: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
763:
764: WHEN G_EXCEPTION_ERROR THEN
765: x_return_status := OKC_API.G_RET_STS_ERROR;
766:
767: WHEN NO_DATA_FOUND THEN
768: IF formula_csr%ISOPEN THEN
769: CLOSE formula_csr;

Line 771: OKC_API.SET_MESSAGE(p_app_name => g_app_name

767: WHEN NO_DATA_FOUND THEN
768: IF formula_csr%ISOPEN THEN
769: CLOSE formula_csr;
770: END IF;
771: OKC_API.SET_MESSAGE(p_app_name => g_app_name
772: ,p_msg_name => g_invalid_fmla_in_operand
773: ,p_token1 => 'OPERAND'
774: ,p_token1_value => l_operand_name );
775: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 775: x_return_status := OKC_API.G_RET_STS_ERROR;

771: OKC_API.SET_MESSAGE(p_app_name => g_app_name
772: ,p_msg_name => g_invalid_fmla_in_operand
773: ,p_token1 => 'OPERAND'
774: ,p_token1_value => l_operand_name );
775: x_return_status := OKC_API.G_RET_STS_ERROR;
776:
777:
778: WHEN VALUE_ERROR THEN
779: IF formula_csr%ISOPEN THEN

Line 782: OKC_API.SET_MESSAGE(p_app_name => g_app_name

778: WHEN VALUE_ERROR THEN
779: IF formula_csr%ISOPEN THEN
780: CLOSE formula_csr;
781: END IF;
782: OKC_API.SET_MESSAGE(p_app_name => g_app_name
783: ,p_msg_name => g_value_error
784: ,p_token1 => 'FORMULA'
785: ,p_token1_value => l_formula_name );
786: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 786: x_return_status := OKC_API.G_RET_STS_ERROR;

782: OKC_API.SET_MESSAGE(p_app_name => g_app_name
783: ,p_msg_name => g_value_error
784: ,p_token1 => 'FORMULA'
785: ,p_token1_value => l_formula_name );
786: x_return_status := OKC_API.G_RET_STS_ERROR;
787:
788: WHEN OTHERS THEN
789: IF formula_csr%ISOPEN THEN
790: CLOSE formula_csr;

Line 792: OKC_API.SET_MESSAGE(p_app_name => g_app_name

788: WHEN OTHERS THEN
789: IF formula_csr%ISOPEN THEN
790: CLOSE formula_csr;
791: END IF;
792: OKC_API.SET_MESSAGE(p_app_name => g_app_name
793: ,p_msg_name => g_unexpected_error
794: ,p_token1 => g_sqlcode_token
795: ,p_token1_value => sqlcode
796: ,p_token2 => g_sqlerrm_token

Line 798: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

794: ,p_token1 => g_sqlcode_token
795: ,p_token1_value => sqlcode
796: ,p_token2 => g_sqlerrm_token
797: ,p_token2_value => sqlerrm);
798: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
799: END execute_formula;
800:
801: -- Start of comments
802: --

Line 813: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

809: -- Version : 1.0
810: -- End of comments
811:
812: PROCEDURE execute(p_api_version IN NUMBER
813: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
814:
815: ,x_return_status OUT NOCOPY VARCHAR2
816: ,x_msg_count OUT NOCOPY NUMBER
817: ,x_msg_data OUT NOCOPY VARCHAR2

Line 839: l_init_msg_list VARCHAR2(1) DEFAULT OKC_API.G_FALSE;

835:
836: l_contract_id okl_k_headers_v.id%TYPE;
837: l_line_id okl_k_lines_v.id%TYPE;
838: l_value NUMBER;
839: l_init_msg_list VARCHAR2(1) DEFAULT OKC_API.G_FALSE;
840: l_return_status VARCHAR2(1);
841: l_msg_count NUMBER;
842: l_msg_data VARCHAR2(2000);
843: i PLS_INTEGER DEFAULT 1;

Line 892: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

888: ,p_line_id => l_line_id
889: ,x_ctx_parameter_tbl => l_ctxt_parameter_tbl
890: );
891:
892: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
893: RAISE ERROR_IN_EVALUATE_PARAM;
894: ELSE
895: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
896: x_return_status := l_return_status;

Line 895: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

891:
892: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
893: RAISE ERROR_IN_EVALUATE_PARAM;
894: ELSE
895: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
896: x_return_status := l_return_status;
897: ELSE
898: RAISE ERROR_IN_EVALUATE_PARAM;
899: END IF;

Line 919: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

915: ,x_operand_val_tbl => l_operand_val_tbl
916: ,x_value => l_value
917: );
918:
919: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
920: RAISE G_EXCEPTION_HALT_PROCESSING;
921: ELSIF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
922: x_return_status := l_return_status;
923: x_value := l_value;

Line 921: ELSIF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

917: );
918:
919: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
920: RAISE G_EXCEPTION_HALT_PROCESSING;
921: ELSIF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
922: x_return_status := l_return_status;
923: x_value := l_value;
924: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
925: RAISE G_EXCEPTION_ERROR;

Line 924: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

920: RAISE G_EXCEPTION_HALT_PROCESSING;
921: ELSIF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
922: x_return_status := l_return_status;
923: x_value := l_value;
924: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
925: RAISE G_EXCEPTION_ERROR;
926:
927: ELSE
928: RAISE G_EXCEPTION_HALT_PROCESSING;

Line 935: OKC_API.SET_MESSAGE(p_app_name => g_app_name

931: WHEN ERROR_IN_EVALUATE_PARAM THEN
932: IF formula_csr%ISOPEN THEN
933: CLOSE formula_csr;
934: END IF;
935: OKC_API.SET_MESSAGE(p_app_name => g_app_name
936: ,p_msg_name => g_error_in_evaluate_param
937: ,p_token1 => 'FORMULA'
938: ,p_token1_value => l_formula_name );
939: x_return_status := l_return_status;

Line 945: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

941: WHEN G_EXCEPTION_HALT_PROCESSING THEN
942: IF formula_csr%ISOPEN THEN
943: CLOSE formula_csr;
944: END IF;
945: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
946:
947:
948: WHEN G_EXCEPTION_ERROR THEN
949: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 949: x_return_status := OKC_API.G_RET_STS_ERROR;

945: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
946:
947:
948: WHEN G_EXCEPTION_ERROR THEN
949: x_return_status := OKC_API.G_RET_STS_ERROR;
950:
951: WHEN NO_DATA_FOUND THEN
952: IF formula_csr%ISOPEN THEN
953: CLOSE formula_csr;

Line 955: OKC_API.SET_MESSAGE(p_app_name => g_app_name

951: WHEN NO_DATA_FOUND THEN
952: IF formula_csr%ISOPEN THEN
953: CLOSE formula_csr;
954: END IF;
955: OKC_API.SET_MESSAGE(p_app_name => g_app_name
956: ,p_msg_name => g_invalid_formula
957: ,p_token1 => 'FORMULA'
958: ,p_token1_value => l_formula_name );
959: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 959: x_return_status := OKC_API.G_RET_STS_ERROR;

955: OKC_API.SET_MESSAGE(p_app_name => g_app_name
956: ,p_msg_name => g_invalid_formula
957: ,p_token1 => 'FORMULA'
958: ,p_token1_value => l_formula_name );
959: x_return_status := OKC_API.G_RET_STS_ERROR;
960:
961:
962: WHEN OTHERS THEN
963: IF formula_csr%ISOPEN THEN

Line 966: OKC_API.SET_MESSAGE(p_app_name => g_app_name

962: WHEN OTHERS THEN
963: IF formula_csr%ISOPEN THEN
964: CLOSE formula_csr;
965: END IF;
966: OKC_API.SET_MESSAGE(p_app_name => g_app_name
967: ,p_msg_name => g_unexpected_error
968: ,p_token1 => g_sqlcode_token
969: ,p_token1_value => sqlcode
970: ,p_token2 => g_sqlerrm_token

Line 972: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

968: ,p_token1 => g_sqlcode_token
969: ,p_token1_value => sqlcode
970: ,p_token2 => g_sqlerrm_token
971: ,p_token2_value => sqlerrm);
972: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
973: END execute;
974:
975: -- Start of comments
976: --

Line 991: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

987: -- Version : 1.0
988: -- End of comments
989:
990: PROCEDURE execute(p_api_version IN NUMBER
991: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
992: ,x_return_status OUT NOCOPY VARCHAR2
993: ,x_msg_count OUT NOCOPY NUMBER
994: ,x_msg_data OUT NOCOPY VARCHAR2
995: ,p_formula_name IN okl_formulae_v.name%TYPE

Line 1016: l_init_msg_list VARCHAR2(1) DEFAULT OKC_API.G_FALSE;

1012: l_formula_name okl_formulae_v.name%TYPE;
1013: l_contract_id okl_k_headers_v.id%TYPE;
1014: l_line_id okl_k_lines_v.id%TYPE;
1015: l_value NUMBER;
1016: l_init_msg_list VARCHAR2(1) DEFAULT OKC_API.G_FALSE;
1017: l_return_status VARCHAR2(1);
1018: l_msg_count NUMBER;
1019: l_msg_data VARCHAR2(2000);
1020: i PLS_INTEGER DEFAULT 1;

Line 1069: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

1065: ,p_contract_id => l_contract_id
1066: ,p_line_id => l_line_id
1067: ,x_ctx_parameter_tbl => l_ctxt_parameter_tbl
1068: );
1069: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1070: RAISE ERROR_IN_EVALUATE_PARAM;
1071: ELSE
1072: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
1073: x_return_status := l_return_status;

Line 1072: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

1068: );
1069: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1070: RAISE ERROR_IN_EVALUATE_PARAM;
1071: ELSE
1072: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
1073: x_return_status := l_return_status;
1074: ELSE
1075: RAISE ERROR_IN_EVALUATE_PARAM;
1076: END IF;

Line 1092: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

1088:
1089: ,x_operand_val_tbl => l_operand_val_tbl
1090: ,x_value => l_value
1091: );
1092: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1093: RAISE G_EXCEPTION_HALT_PROCESSING;
1094: ELSIF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
1095: x_operand_val_tbl := l_operand_val_tbl;
1096: x_return_status := l_return_status;

Line 1094: ELSIF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

1090: ,x_value => l_value
1091: );
1092: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1093: RAISE G_EXCEPTION_HALT_PROCESSING;
1094: ELSIF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
1095: x_operand_val_tbl := l_operand_val_tbl;
1096: x_return_status := l_return_status;
1097: x_value := l_value;
1098: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

Line 1098: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

1094: ELSIF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
1095: x_operand_val_tbl := l_operand_val_tbl;
1096: x_return_status := l_return_status;
1097: x_value := l_value;
1098: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1099: RAISE G_EXCEPTION_ERROR;
1100: ELSE
1101: RAISE G_EXCEPTION_HALT_PROCESSING;
1102: END IF;

Line 1108: OKC_API.SET_MESSAGE(p_app_name => g_app_name

1104: WHEN ERROR_IN_EVALUATE_PARAM THEN
1105: IF formula_csr%ISOPEN THEN
1106: CLOSE formula_csr;
1107: END IF;
1108: OKC_API.SET_MESSAGE(p_app_name => g_app_name
1109: ,p_msg_name => g_error_in_evaluate_param
1110: ,p_token1 => 'FORMULA'
1111: ,p_token1_value => l_formula_name );
1112: x_return_status := l_return_status;

Line 1118: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1114: WHEN G_EXCEPTION_HALT_PROCESSING THEN
1115: IF formula_csr%ISOPEN THEN
1116: CLOSE formula_csr;
1117: END IF;
1118: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1119:
1120: WHEN G_EXCEPTION_ERROR THEN
1121: x_return_status := OKC_API.G_RET_STS_ERROR;
1122:

Line 1121: x_return_status := OKC_API.G_RET_STS_ERROR;

1117: END IF;
1118: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1119:
1120: WHEN G_EXCEPTION_ERROR THEN
1121: x_return_status := OKC_API.G_RET_STS_ERROR;
1122:
1123: WHEN NO_DATA_FOUND THEN
1124: IF formula_csr%ISOPEN THEN
1125: CLOSE formula_csr;

Line 1127: OKC_API.SET_MESSAGE(p_app_name => g_app_name

1123: WHEN NO_DATA_FOUND THEN
1124: IF formula_csr%ISOPEN THEN
1125: CLOSE formula_csr;
1126: END IF;
1127: OKC_API.SET_MESSAGE(p_app_name => g_app_name
1128: ,p_msg_name => g_invalid_formula
1129: ,p_token1 => 'FORMULA'
1130: ,p_token1_value => l_formula_name );
1131: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 1131: x_return_status := OKC_API.G_RET_STS_ERROR;

1127: OKC_API.SET_MESSAGE(p_app_name => g_app_name
1128: ,p_msg_name => g_invalid_formula
1129: ,p_token1 => 'FORMULA'
1130: ,p_token1_value => l_formula_name );
1131: x_return_status := OKC_API.G_RET_STS_ERROR;
1132:
1133:
1134: WHEN OTHERS THEN
1135: IF formula_csr%ISOPEN THEN

Line 1139: OKC_API.SET_MESSAGE(p_app_name => g_app_name

1135: IF formula_csr%ISOPEN THEN
1136:
1137: CLOSE formula_csr;
1138: END IF;
1139: OKC_API.SET_MESSAGE(p_app_name => g_app_name
1140: ,p_msg_name => g_unexpected_error
1141: ,p_token1 => g_sqlcode_token
1142: ,p_token1_value => sqlcode
1143: ,p_token2 => g_sqlerrm_token

Line 1145: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1141: ,p_token1 => g_sqlcode_token
1142: ,p_token1_value => sqlcode
1143: ,p_token2 => g_sqlerrm_token
1144: ,p_token2_value => sqlerrm);
1145: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1146: END execute;
1147:
1148: END OKL_EXECUTE_FORMULA_PVT;