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

Line 78: x_return_status := okc_api.g_ret_sts_success;

74: 'p_qte_id =' || p_qte_id
75: );
76: END IF;
77:
78: x_return_status := okc_api.g_ret_sts_success;
79:
80: -- Select existing db values.
81: OPEN l_qtev_csr (p_qte_id);
82:

Line 93: okc_api.set_message (p_app_name => 'OKC',

89: x_qtp_code;
90:
91: -- Invalid Value for the column COL_NAME
92: IF (l_qtev_csr%NOTFOUND) THEN
93: okc_api.set_message (p_app_name => 'OKC',
94: p_msg_name => g_invalid_value,
95: p_token1 => g_col_name_token,
96: p_token1_value => 'qte_id'
97: );

Line 98: x_return_status := okc_api.g_ret_sts_error;

94: p_msg_name => g_invalid_value,
95: p_token1 => g_col_name_token,
96: p_token1_value => 'qte_id'
97: );
98: x_return_status := okc_api.g_ret_sts_error;
99: END IF;
100:
101: CLOSE l_qtev_csr;
102:

Line 119: okc_api.set_message (p_app_name => 'OKC',

115: IF (l_qtev_csr%ISOPEN) THEN
116: CLOSE l_qtev_csr;
117: END IF;
118:
119: okc_api.set_message (p_app_name => 'OKC',
120: p_msg_name => g_unexpected_error,
121: p_token1 => g_sqlcode_token,
122: p_token1_value => SQLCODE,
123: p_token2 => g_sqlerrm_token,

Line 126: x_return_status := okc_api.g_ret_sts_unexp_error;

122: p_token1_value => SQLCODE,
123: p_token2 => g_sqlerrm_token,
124: p_token2_value => SQLERRM
125: );
126: x_return_status := okc_api.g_ret_sts_unexp_error;
127: END get_db_values;
128:
129: -- Start of comments
130: --

Line 156: okc_api.set_message (p_app_name => 'OKC',

152: IF (l_db_date_csr%ISOPEN) THEN
153: CLOSE l_db_date_csr;
154: END IF;
155:
156: okc_api.set_message (p_app_name => 'OKC',
157: p_msg_name => g_unexpected_error,
158: p_token1 => g_sqlcode_token,
159: p_token1_value => SQLCODE,
160: p_token2 => g_sqlerrm_token,

Line 179: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_error;

175: x_quote_eff_days OUT NOCOPY NUMBER,
176: x_quote_eff_max_days OUT NOCOPY NUMBER,
177: x_return_status OUT NOCOPY VARCHAR2
178: ) IS
179: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_error;
180: l_rule_found BOOLEAN := FALSE;
181: l_rulv_rec rulv_rec_type;
182: l_rule_code CONSTANT VARCHAR2 (30) := 'AMQTEF';
183: l_rule_group_code CONSTANT VARCHAR2 (30) := 'AMTQPR';

Line 248: IF (l_return_status = okc_api.g_ret_sts_success) THEN

244: 'l_return_status =' || l_return_status
245: );
246: END IF;
247:
248: IF (l_return_status = okc_api.g_ret_sts_success) THEN
249: x_quote_eff_days := l_rulv_rec.rule_information1;
250: x_quote_eff_max_days := l_rulv_rec.rule_information2;
251: l_return_status := okc_api.g_ret_sts_success;
252: END IF;

Line 251: l_return_status := okc_api.g_ret_sts_success;

247:
248: IF (l_return_status = okc_api.g_ret_sts_success) THEN
249: x_quote_eff_days := l_rulv_rec.rule_information1;
250: x_quote_eff_max_days := l_rulv_rec.rule_information2;
251: l_return_status := okc_api.g_ret_sts_success;
252: END IF;
253:
254: x_return_status := l_return_status;
255:

Line 261: okc_api.set_message (p_app_name => 'OKC',

257: okl_debug_pub.log_debug (g_level_procedure, l_module_name, 'End(-)');
258: END IF;
259: EXCEPTION
260: WHEN OTHERS THEN
261: okc_api.set_message (p_app_name => 'OKC',
262: p_msg_name => g_unexpected_error,
263: p_token1 => g_sqlcode_token,
264: p_token1_value => SQLCODE,
265: p_token2 => g_sqlerrm_token,

Line 268: x_return_status := okc_api.g_ret_sts_unexp_error;

264: p_token1_value => SQLCODE,
265: p_token2 => g_sqlerrm_token,
266: p_token2_value => SQLERRM
267: );
268: x_return_status := okc_api.g_ret_sts_unexp_error;
269: END quote_effectivity;
270:
271: -- Start of comments
272: --

Line 283: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_error;

279: PROCEDURE quote_type_check (
280: p_qtp_code IN VARCHAR2,
281: x_return_status OUT NOCOPY VARCHAR2
282: ) IS
283: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_error;
284: -- akrangan added for debug feature start
285: l_module_name VARCHAR2 (500)
286: := g_module_name || 'quote_type_check';
287: is_debug_exception_on BOOLEAN

Line 303: l_return_status := okc_api.g_ret_sts_success;

299: );
300: END IF;
301:
302: IF ((p_qtp_code IS NOT NULL) AND (p_qtp_code = 'REP_STANDARD')) THEN
303: l_return_status := okc_api.g_ret_sts_success;
304: END IF;
305:
306: x_return_status := l_return_status;
307:

Line 313: okc_api.set_message (p_app_name => 'OKC',

309: okl_debug_pub.log_debug (g_level_procedure, l_module_name, 'End(-)');
310: END IF;
311: EXCEPTION
312: WHEN OTHERS THEN
313: okc_api.set_message (p_app_name => 'OKC',
314: p_msg_name => g_unexpected_error,
315: p_token1 => g_sqlcode_token,
316: p_token1_value => SQLCODE,
317: p_token2 => g_sqlerrm_token,

Line 320: x_return_status := okc_api.g_ret_sts_unexp_error;

316: p_token1_value => SQLCODE,
317: p_token2 => g_sqlerrm_token,
318: p_token2_value => SQLERRM
319: );
320: x_return_status := okc_api.g_ret_sts_unexp_error;
321: END quote_type_check;
322:
323: -- Start of comments
324: --

Line 340: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;

336: l_quote_eff_max_days NUMBER;
337: l_db_date DATE;
338: l_quote_status VARCHAR2 (200) := 'DRAFTED';
339: l_quote_reason VARCHAR2 (200) := 'EOT';
340: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
341: -- akrangan added for debug feature start
342: l_module_name VARCHAR2 (500)
343: := g_module_name || 'set_quote_defaults';
344: is_debug_exception_on BOOLEAN

Line 542: OR (px_qtev_rec.date_effective_from = okc_api.g_miss_date)

538: );
539: END IF;
540:
541: IF ( (px_qtev_rec.date_effective_from IS NULL)
542: OR (px_qtev_rec.date_effective_from = okc_api.g_miss_date)
543: ) THEN
544: -- get the sysdate
545: get_sysdate (l_db_date);
546: px_qtev_rec.date_effective_from := l_db_date;

Line 550: OR (px_qtev_rec.date_effective_to = okc_api.g_miss_date)

546: px_qtev_rec.date_effective_from := l_db_date;
547: END IF;
548:
549: IF ( (px_qtev_rec.date_effective_to IS NULL)
550: OR (px_qtev_rec.date_effective_to = okc_api.g_miss_date)
551: ) THEN
552: IF (is_debug_statement_on) THEN
553: okl_debug_pub.log_debug (g_level_statement,
554: l_module_name,

Line 582: IF (l_return_status = okc_api.g_ret_sts_success) THEN

578: 'l_return_status: ' || l_return_status
579: );
580: END IF;
581:
582: IF (l_return_status = okc_api.g_ret_sts_success) THEN
583: px_qtev_rec.date_effective_to :=
584: px_qtev_rec.date_effective_from + l_quote_eff_days;
585: ELSE
586: RAISE g_exception_halt_validation;

Line 591: OR (px_qtev_rec.qst_code = okc_api.g_miss_char)

587: END IF;
588: END IF;
589:
590: IF ( (px_qtev_rec.qst_code IS NULL)
591: OR (px_qtev_rec.qst_code = okc_api.g_miss_char)
592: ) THEN
593: px_qtev_rec.qst_code := l_quote_status;
594: END IF;
595:

Line 597: OR (px_qtev_rec.qrs_code = okc_api.g_miss_char)

593: px_qtev_rec.qst_code := l_quote_status;
594: END IF;
595:
596: IF ( (px_qtev_rec.qrs_code IS NULL)
597: OR (px_qtev_rec.qrs_code = okc_api.g_miss_char)
598: ) THEN
599: px_qtev_rec.qrs_code := l_quote_reason;
600: END IF;
601:

Line 615: okc_api.set_message (p_app_name => 'OKC',

611: WHEN g_exception_halt_validation THEN
612: x_return_status := l_return_status;
613: WHEN OTHERS THEN
614: x_return_status := l_return_status;
615: okc_api.set_message (p_app_name => 'OKC',
616: p_msg_name => g_unexpected_error,
617: p_token1 => g_sqlcode_token,
618: p_token1_value => SQLCODE,
619: p_token2 => g_sqlerrm_token,

Line 912: x_return_status := okc_api.g_ret_sts_success;

908: || p_qtev_rec.repo_quote_indicator_yn
909: );
910: END IF;
911:
912: x_return_status := okc_api.g_ret_sts_success;
913:
914: -- SECHAWLA 22-JAN-03 Bug # 2762419 :Moved the quote header level validations to the beginning
915: IF p_call_flag = 'UPDATE' THEN
916: OPEN l_acpt_csr (p_qtev_rec.ID);

Line 923: okc_api.set_message (p_app_name => 'OKC',

919: INTO db_accepted_yn;
920:
921: -- SECHAWLA 22-JAN-03 Bug # 2762419 : Added the following exception handling code
922: IF l_acpt_csr%NOTFOUND THEN
923: okc_api.set_message (p_app_name => 'OKC',
924: p_msg_name => g_invalid_value,
925: p_token1 => g_col_name_token,
926: p_token1_value => 'qte_id'
927: );

Line 962: IF x_return_status = okc_api.g_ret_sts_error THEN

958: 'x_return_status: ' || x_return_status
959: );
960: END IF;
961:
962: IF x_return_status = okc_api.g_ret_sts_error THEN
963: --Please select a valid Quote Type.
964: okc_api.set_message (p_app_name => g_app_name,
965: p_msg_name => 'OKL_AM_QTP_CODE_INVALID'
966: );

Line 964: okc_api.set_message (p_app_name => g_app_name,

960: END IF;
961:
962: IF x_return_status = okc_api.g_ret_sts_error THEN
963: --Please select a valid Quote Type.
964: okc_api.set_message (p_app_name => g_app_name,
965: p_msg_name => 'OKL_AM_QTP_CODE_INVALID'
966: );
967: RAISE g_exception_halt_validation;
968: END IF;

Line 972: AND (p_qtev_rec.art_id <> okc_api.g_miss_num)

968: END IF;
969:
970: -- check asset return id is populated and valid
971: IF ( (p_qtev_rec.art_id IS NOT NULL)
972: AND (p_qtev_rec.art_id <> okc_api.g_miss_num)
973: ) THEN
974: -- select the asset return id to see if valid
975: OPEN l_artv_csr (p_qtev_rec.art_id);
976:

Line 987: okc_api.set_message (p_app_name => 'OKC',

983: CLOSE l_artv_csr;
984: END IF;
985:
986: IF (l_art_id = 1) THEN
987: okc_api.set_message (p_app_name => 'OKC',
988: p_msg_name => g_invalid_value,
989: p_token1 => g_col_name_token,
990: p_token1_value => 'art_id'
991: );

Line 996: IF (l_legal_entity_id IS NULL OR l_legal_entity_id = okc_api.g_miss_num

992: RAISE g_exception_halt_validation;
993: END IF;
994:
995: -- RRAVIKIR Legal Entity Changes
996: IF (l_legal_entity_id IS NULL OR l_legal_entity_id = okc_api.g_miss_num
997: ) THEN
998: okl_api.set_message (p_app_name => g_app_name,
999: p_msg_name => g_required_value,
1000: p_token1 => g_col_name_token,

Line 1003: RAISE okc_api.g_exception_error;

999: p_msg_name => g_required_value,
1000: p_token1 => g_col_name_token,
1001: p_token1_value => 'legal_entity_id'
1002: );
1003: RAISE okc_api.g_exception_error;
1004: ELSE
1005: p_qtev_rec.legal_entity_id := l_legal_entity_id;
1006: END IF;
1007:

Line 1021: okc_api.set_message (p_app_name => g_app_name,

1017:
1018: CLOSE l_chr_csr;
1019:
1020: -- No repurchase agreement exists for contract CONTRACT_NUMBER.
1021: okc_api.set_message (p_app_name => g_app_name,
1022: p_msg_name => 'OKL_AM_NO_REPURCHASE_AGMT',
1023: p_token1 => 'CONTRACT_NUMBER',
1024: p_token1_value => l_contract_number
1025: );

Line 1037: OR (p_tqlv_tbl (i).kle_id = okc_api.g_miss_num)

1033: i := p_tqlv_tbl.FIRST;
1034:
1035: LOOP
1036: IF ( (p_tqlv_tbl (i).kle_id IS NULL)
1037: OR (p_tqlv_tbl (i).kle_id = okc_api.g_miss_num)
1038: ) THEN
1039: l_missing_lines := TRUE;
1040: --SECHAWLA 22-JAN-03 Bug # 2762419 : Added the EXIT statement
1041: EXIT;

Line 1052: okc_api.set_message (p_app_name => 'OKC',

1048: l_missing_lines := TRUE;
1049: END IF;
1050:
1051: IF (l_missing_lines) THEN
1052: okc_api.set_message (p_app_name => 'OKC',
1053: p_msg_name => g_required_value,
1054: p_token1 => g_col_name_token,
1055: p_token1_value => 'kle_id'
1056: );

Line 1063: AND (p_qtev_rec.khr_id <> okc_api.g_miss_num)

1059:
1060: -- validate that the contract line ids are valid and belong to the same contract
1061: IF ( (p_tqlv_tbl.COUNT > 0)
1062: AND ( (p_qtev_rec.khr_id IS NOT NULL)
1063: AND (p_qtev_rec.khr_id <> okc_api.g_miss_num)
1064: )
1065: ) THEN
1066: i := p_tqlv_tbl.FIRST;
1067: l_contract_mismatch := FALSE;

Line 1089: okc_api.set_message (p_app_name => 'OKC',

1085: i := p_tqlv_tbl.NEXT (i);
1086: END LOOP;
1087:
1088: IF (l_contract_mismatch) THEN
1089: okc_api.set_message (p_app_name => 'OKC',
1090: p_msg_name => g_invalid_value,
1091: p_token1 => g_col_name_token,
1092: p_token1_value => 'kle_id'
1093: );

Line 1098: okc_api.set_message (p_app_name => 'OKC',

1094: RAISE g_exception_halt_validation;
1095: END IF;
1096: ELSE
1097: -- Either no lines selected (which is not needed here since done earlier) or khr_id is invalid
1098: okc_api.set_message (p_app_name => 'OKC',
1099: p_msg_name => g_required_value,
1100: p_token1 => g_col_name_token,
1101: p_token1_value => 'khr_id'
1102: );

Line 1157: OKC_API.SET_MESSAGE (

1153: -- check if contract active
1154: IF check_contract_active_yn ( p_qtev_rec,l_contract_number) = TRUE THEN
1155: -- Contract CONTRACT_NUMBER is still Active. Unable to generate the quote
1156: -- until the contract has been terminated.
1157: OKC_API.SET_MESSAGE (
1158: p_app_name => G_APP_NAME
1159: ,p_msg_name => 'OKL_AM_CONTRACT_STILL_ACTIVE'
1160: ,p_token1 => 'CONTRACT_NUMBER'
1161: ,p_token1_value => l_contract_number);

Line 1189: okc_api.set_message (p_app_name => g_app_name,

1185: CLOSE l_qtev_csr;
1186:
1187: IF (l_quote_number <> 1) THEN
1188: -- Repurchase quote (QUOTE_NUMBER) already exists for this Asset.
1189: okc_api.set_message (p_app_name => g_app_name,
1190: p_msg_name => 'OKL_AM_REP_QUOTE_ALREADY_EXIST',
1191: p_token1 => 'QUOTE_NUMBER',
1192: p_token1_value => TO_CHAR (l_quote_number)
1193: );

Line 1227: x_return_status := okc_api.g_ret_sts_error;

1223: IF l_okclines_csr%ISOPEN THEN
1224: CLOSE l_okclines_csr;
1225: END IF;
1226:
1227: x_return_status := okc_api.g_ret_sts_error;
1228: WHEN OTHERS THEN
1229: IF (l_clev_csr%ISOPEN) THEN
1230: CLOSE l_clev_csr;
1231: END IF;

Line 1254: okc_api.set_message (p_app_name => okc_api.g_app_name,

1250: IF l_okclines_csr%ISOPEN THEN
1251: CLOSE l_okclines_csr;
1252: END IF;
1253:
1254: okc_api.set_message (p_app_name => okc_api.g_app_name,
1255: p_msg_name => g_unexpected_error,
1256: p_token1 => g_sqlcode_token,
1257: p_token1_value => SQLCODE,
1258: p_token2 => g_sqlerrm_token,

Line 1261: x_return_status := okc_api.g_ret_sts_unexp_error;

1257: p_token1_value => SQLCODE,
1258: p_token2 => g_sqlerrm_token,
1259: p_token2_value => SQLERRM
1260: );
1261: x_return_status := okc_api.g_ret_sts_unexp_error;
1262: END validate_quote;
1263:
1264: -- Start of comments
1265: --

Line 1296: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;

1292: lx_qpyv_tbl qpyv_tbl_type;
1293: l_quote_number NUMBER;
1294: l_api_version CONSTANT NUMBER := 1;
1295: l_api_name CONSTANT VARCHAR2 (30) := 'create_repurchase_quote';
1296: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
1297: -- akrangan added for debug feature start
1298: l_module_name VARCHAR2 (500)
1299: := g_module_name || 'create_repurchase_quote';
1300: is_debug_exception_on BOOLEAN

Line 1553: IF (l_return_status = okc_api.g_ret_sts_unexp_error) THEN

1549: 'l_return_status: ' || l_return_status
1550: );
1551: END IF;
1552:
1553: IF (l_return_status = okc_api.g_ret_sts_unexp_error) THEN
1554: RAISE okc_api.g_exception_unexpected_error;
1555: ELSIF (l_return_status = okc_api.g_ret_sts_error) THEN
1556: RAISE okc_api.g_exception_error;
1557: END IF;

Line 1554: RAISE okc_api.g_exception_unexpected_error;

1550: );
1551: END IF;
1552:
1553: IF (l_return_status = okc_api.g_ret_sts_unexp_error) THEN
1554: RAISE okc_api.g_exception_unexpected_error;
1555: ELSIF (l_return_status = okc_api.g_ret_sts_error) THEN
1556: RAISE okc_api.g_exception_error;
1557: END IF;
1558:

Line 1555: ELSIF (l_return_status = okc_api.g_ret_sts_error) THEN

1551: END IF;
1552:
1553: IF (l_return_status = okc_api.g_ret_sts_unexp_error) THEN
1554: RAISE okc_api.g_exception_unexpected_error;
1555: ELSIF (l_return_status = okc_api.g_ret_sts_error) THEN
1556: RAISE okc_api.g_exception_error;
1557: END IF;
1558:
1559: IF (is_debug_statement_on) THEN

Line 1556: RAISE okc_api.g_exception_error;

1552:
1553: IF (l_return_status = okc_api.g_ret_sts_unexp_error) THEN
1554: RAISE okc_api.g_exception_unexpected_error;
1555: ELSIF (l_return_status = okc_api.g_ret_sts_error) THEN
1556: RAISE okc_api.g_exception_error;
1557: END IF;
1558:
1559: IF (is_debug_statement_on) THEN
1560: okl_debug_pub.log_debug (g_level_statement,

Line 1587: IF (l_return_status = okc_api.g_ret_sts_unexp_error) THEN

1583: 'l_return_status: ' || l_return_status
1584: );
1585: END IF;
1586:
1587: IF (l_return_status = okc_api.g_ret_sts_unexp_error) THEN
1588: RAISE okc_api.g_exception_unexpected_error;
1589: ELSIF (l_return_status = okc_api.g_ret_sts_error) THEN
1590: RAISE okc_api.g_exception_error;
1591: END IF;

Line 1588: RAISE okc_api.g_exception_unexpected_error;

1584: );
1585: END IF;
1586:
1587: IF (l_return_status = okc_api.g_ret_sts_unexp_error) THEN
1588: RAISE okc_api.g_exception_unexpected_error;
1589: ELSIF (l_return_status = okc_api.g_ret_sts_error) THEN
1590: RAISE okc_api.g_exception_error;
1591: END IF;
1592:

Line 1589: ELSIF (l_return_status = okc_api.g_ret_sts_error) THEN

1585: END IF;
1586:
1587: IF (l_return_status = okc_api.g_ret_sts_unexp_error) THEN
1588: RAISE okc_api.g_exception_unexpected_error;
1589: ELSIF (l_return_status = okc_api.g_ret_sts_error) THEN
1590: RAISE okc_api.g_exception_error;
1591: END IF;
1592:
1593: IF (is_debug_statement_on) THEN

Line 1590: RAISE okc_api.g_exception_error;

1586:
1587: IF (l_return_status = okc_api.g_ret_sts_unexp_error) THEN
1588: RAISE okc_api.g_exception_unexpected_error;
1589: ELSIF (l_return_status = okc_api.g_ret_sts_error) THEN
1590: RAISE okc_api.g_exception_error;
1591: END IF;
1592:
1593: IF (is_debug_statement_on) THEN
1594: okl_debug_pub.log_debug

Line 1629: IF (l_return_status = okc_api.g_ret_sts_unexp_error) THEN

1625: 'l_return_status: ' || l_return_status
1626: );
1627: END IF;
1628:
1629: IF (l_return_status = okc_api.g_ret_sts_unexp_error) THEN
1630: RAISE okc_api.g_exception_unexpected_error;
1631: ELSIF (l_return_status = okc_api.g_ret_sts_error) THEN
1632: RAISE okc_api.g_exception_error;
1633: END IF;

Line 1630: RAISE okc_api.g_exception_unexpected_error;

1626: );
1627: END IF;
1628:
1629: IF (l_return_status = okc_api.g_ret_sts_unexp_error) THEN
1630: RAISE okc_api.g_exception_unexpected_error;
1631: ELSIF (l_return_status = okc_api.g_ret_sts_error) THEN
1632: RAISE okc_api.g_exception_error;
1633: END IF;
1634:

Line 1631: ELSIF (l_return_status = okc_api.g_ret_sts_error) THEN

1627: END IF;
1628:
1629: IF (l_return_status = okc_api.g_ret_sts_unexp_error) THEN
1630: RAISE okc_api.g_exception_unexpected_error;
1631: ELSIF (l_return_status = okc_api.g_ret_sts_error) THEN
1632: RAISE okc_api.g_exception_error;
1633: END IF;
1634:
1635: IF (is_debug_statement_on) THEN

Line 1632: RAISE okc_api.g_exception_error;

1628:
1629: IF (l_return_status = okc_api.g_ret_sts_unexp_error) THEN
1630: RAISE okc_api.g_exception_unexpected_error;
1631: ELSIF (l_return_status = okc_api.g_ret_sts_error) THEN
1632: RAISE okc_api.g_exception_error;
1633: END IF;
1634:
1635: IF (is_debug_statement_on) THEN
1636: okl_debug_pub.log_debug

Line 1682: okc_api.set_message (p_app_name => 'OKC',

1678: EXIT WHEN (i = lp_tqlv_tbl.LAST);
1679: i := lp_tqlv_tbl.NEXT (i);
1680: END LOOP;
1681: ELSE -- No assets selected for quote
1682: okc_api.set_message (p_app_name => 'OKC',
1683: p_msg_name => g_required_value,
1684: p_token1 => g_col_name_token,
1685: p_token1_value => 'p_tqlv_tbl'
1686: );

Line 1726: IF (l_return_status = okc_api.g_ret_sts_unexp_error) THEN

1722: 'l_return_status: ' || l_return_status
1723: );
1724: END IF;
1725:
1726: IF (l_return_status = okc_api.g_ret_sts_unexp_error) THEN
1727: RAISE okc_api.g_exception_unexpected_error;
1728: ELSIF (l_return_status = okc_api.g_ret_sts_error) THEN
1729: RAISE okc_api.g_exception_error;
1730: END IF;

Line 1727: RAISE okc_api.g_exception_unexpected_error;

1723: );
1724: END IF;
1725:
1726: IF (l_return_status = okc_api.g_ret_sts_unexp_error) THEN
1727: RAISE okc_api.g_exception_unexpected_error;
1728: ELSIF (l_return_status = okc_api.g_ret_sts_error) THEN
1729: RAISE okc_api.g_exception_error;
1730: END IF;
1731:

Line 1728: ELSIF (l_return_status = okc_api.g_ret_sts_error) THEN

1724: END IF;
1725:
1726: IF (l_return_status = okc_api.g_ret_sts_unexp_error) THEN
1727: RAISE okc_api.g_exception_unexpected_error;
1728: ELSIF (l_return_status = okc_api.g_ret_sts_error) THEN
1729: RAISE okc_api.g_exception_error;
1730: END IF;
1731:
1732: -- set the return status and out variables

Line 1729: RAISE okc_api.g_exception_error;

1725:
1726: IF (l_return_status = okc_api.g_ret_sts_unexp_error) THEN
1727: RAISE okc_api.g_exception_unexpected_error;
1728: ELSIF (l_return_status = okc_api.g_ret_sts_error) THEN
1729: RAISE okc_api.g_exception_error;
1730: END IF;
1731:
1732: -- set the return status and out variables
1733: x_return_status := l_return_status;

Line 1737: okc_api.end_activity (x_msg_count, x_msg_data);

1733: x_return_status := l_return_status;
1734: x_qtev_rec := lx_qtev_rec;
1735: x_tqlv_tbl := lx_tqlv_tbl;
1736: -- end the transaction
1737: okc_api.end_activity (x_msg_count, x_msg_data);
1738:
1739: IF (is_debug_procedure_on) THEN
1740: okl_debug_pub.log_debug (g_level_procedure, l_module_name, 'End(-)');
1741: END IF;

Line 1743: WHEN okc_api.g_exception_error THEN

1739: IF (is_debug_procedure_on) THEN
1740: okl_debug_pub.log_debug (g_level_procedure, l_module_name, 'End(-)');
1741: END IF;
1742: EXCEPTION
1743: WHEN okc_api.g_exception_error THEN
1744: x_return_status :=
1745: okc_api.handle_exceptions (l_api_name,
1746: g_pkg_name,
1747: 'OKC_API.G_RET_STS_ERROR',

Line 1745: okc_api.handle_exceptions (l_api_name,

1741: END IF;
1742: EXCEPTION
1743: WHEN okc_api.g_exception_error THEN
1744: x_return_status :=
1745: okc_api.handle_exceptions (l_api_name,
1746: g_pkg_name,
1747: 'OKC_API.G_RET_STS_ERROR',
1748: x_msg_count,
1749: x_msg_data,

Line 1747: 'OKC_API.G_RET_STS_ERROR',

1743: WHEN okc_api.g_exception_error THEN
1744: x_return_status :=
1745: okc_api.handle_exceptions (l_api_name,
1746: g_pkg_name,
1747: 'OKC_API.G_RET_STS_ERROR',
1748: x_msg_count,
1749: x_msg_data,
1750: '_PVT'
1751: );

Line 1752: WHEN okc_api.g_exception_unexpected_error THEN

1748: x_msg_count,
1749: x_msg_data,
1750: '_PVT'
1751: );
1752: WHEN okc_api.g_exception_unexpected_error THEN
1753: x_return_status :=
1754: okc_api.handle_exceptions (l_api_name,
1755: g_pkg_name,
1756: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1754: okc_api.handle_exceptions (l_api_name,

1750: '_PVT'
1751: );
1752: WHEN okc_api.g_exception_unexpected_error THEN
1753: x_return_status :=
1754: okc_api.handle_exceptions (l_api_name,
1755: g_pkg_name,
1756: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1757: x_msg_count,
1758: x_msg_data,

Line 1756: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1752: WHEN okc_api.g_exception_unexpected_error THEN
1753: x_return_status :=
1754: okc_api.handle_exceptions (l_api_name,
1755: g_pkg_name,
1756: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1757: x_msg_count,
1758: x_msg_data,
1759: '_PVT'
1760: );

Line 1763: okc_api.handle_exceptions (l_api_name,

1759: '_PVT'
1760: );
1761: WHEN OTHERS THEN
1762: x_return_status :=
1763: okc_api.handle_exceptions (l_api_name,
1764: g_pkg_name,
1765: 'OTHERS',
1766: x_msg_count,
1767: x_msg_data,

Line 1810: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;

1806: l_quote_eff_max_days NUMBER;
1807: l_max_quote_eff_to_dt DATE;
1808: l_api_version CONSTANT NUMBER := 1;
1809: l_api_name CONSTANT VARCHAR2 (30) := 'update_repurchase_quote';
1810: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;
1811: l_event_name VARCHAR2 (200)
1812: := 'oracle.apps.okl.am.repurchasequote';
1813: l_event_desc VARCHAR2 (2000);
1814: l_date_eff_from DATE;

Line 2040: x_return_status := okc_api.g_ret_sts_success;

2036: RAISE okl_api.g_exception_error;
2037: END IF;
2038:
2039: -- initialize return variables
2040: x_return_status := okc_api.g_ret_sts_success;
2041:
2042: IF (is_debug_statement_on) THEN
2043: okl_debug_pub.log_debug (g_level_statement,
2044: l_module_name,

Line 2075: IF (l_return_status = okc_api.g_ret_sts_unexp_error) THEN

2071: 'l_return_status: ' || l_return_status
2072: );
2073: END IF;
2074:
2075: IF (l_return_status = okc_api.g_ret_sts_unexp_error) THEN
2076: RAISE okc_api.g_exception_unexpected_error;
2077: ELSIF (l_return_status = okc_api.g_ret_sts_error) THEN
2078: RAISE okc_api.g_exception_error;
2079: END IF;

Line 2076: RAISE okc_api.g_exception_unexpected_error;

2072: );
2073: END IF;
2074:
2075: IF (l_return_status = okc_api.g_ret_sts_unexp_error) THEN
2076: RAISE okc_api.g_exception_unexpected_error;
2077: ELSIF (l_return_status = okc_api.g_ret_sts_error) THEN
2078: RAISE okc_api.g_exception_error;
2079: END IF;
2080:

Line 2077: ELSIF (l_return_status = okc_api.g_ret_sts_error) THEN

2073: END IF;
2074:
2075: IF (l_return_status = okc_api.g_ret_sts_unexp_error) THEN
2076: RAISE okc_api.g_exception_unexpected_error;
2077: ELSIF (l_return_status = okc_api.g_ret_sts_error) THEN
2078: RAISE okc_api.g_exception_error;
2079: END IF;
2080:
2081: IF ( (lp_qtev_rec.khr_id IS NOT NULL)

Line 2078: RAISE okc_api.g_exception_error;

2074:
2075: IF (l_return_status = okc_api.g_ret_sts_unexp_error) THEN
2076: RAISE okc_api.g_exception_unexpected_error;
2077: ELSIF (l_return_status = okc_api.g_ret_sts_error) THEN
2078: RAISE okc_api.g_exception_error;
2079: END IF;
2080:
2081: IF ( (lp_qtev_rec.khr_id IS NOT NULL)
2082: AND (p_qtev_rec.khr_id <> okc_api.g_miss_num)

Line 2082: AND (p_qtev_rec.khr_id <> okc_api.g_miss_num)

2078: RAISE okc_api.g_exception_error;
2079: END IF;
2080:
2081: IF ( (lp_qtev_rec.khr_id IS NOT NULL)
2082: AND (p_qtev_rec.khr_id <> okc_api.g_miss_num)
2083: AND (l_db_khr_id <> p_qtev_rec.khr_id)
2084: ) THEN
2085: okc_api.set_message (p_app_name => 'OKC',
2086: p_msg_name => g_invalid_value,

Line 2085: okc_api.set_message (p_app_name => 'OKC',

2081: IF ( (lp_qtev_rec.khr_id IS NOT NULL)
2082: AND (p_qtev_rec.khr_id <> okc_api.g_miss_num)
2083: AND (l_db_khr_id <> p_qtev_rec.khr_id)
2084: ) THEN
2085: okc_api.set_message (p_app_name => 'OKC',
2086: p_msg_name => g_invalid_value,
2087: p_token1 => g_col_name_token,
2088: p_token1_value => 'kle_id'
2089: );

Line 2162: AND (lp_qtev_rec.date_effective_to <> okc_api.g_miss_date)

2158: END IF;
2159:
2160: -- if date effective to changed then
2161: IF ( (lp_qtev_rec.date_effective_to IS NOT NULL)
2162: AND (lp_qtev_rec.date_effective_to <> okc_api.g_miss_date)
2163: AND (lp_qtev_rec.date_effective_to <> l_db_date_effective_to)
2164: ) THEN
2165: IF (is_debug_statement_on) THEN
2166: okl_debug_pub.log_debug (g_level_statement,

Line 2194: IF (l_return_status = okc_api.g_ret_sts_unexp_error) THEN

2190: 'l_return_status: ' || l_return_status
2191: );
2192: END IF;
2193:
2194: IF (l_return_status = okc_api.g_ret_sts_unexp_error) THEN
2195: RAISE okc_api.g_exception_unexpected_error;
2196: ELSIF (l_return_status = okc_api.g_ret_sts_error) THEN
2197: RAISE okc_api.g_exception_error;
2198: END IF;

Line 2195: RAISE okc_api.g_exception_unexpected_error;

2191: );
2192: END IF;
2193:
2194: IF (l_return_status = okc_api.g_ret_sts_unexp_error) THEN
2195: RAISE okc_api.g_exception_unexpected_error;
2196: ELSIF (l_return_status = okc_api.g_ret_sts_error) THEN
2197: RAISE okc_api.g_exception_error;
2198: END IF;
2199:

Line 2196: ELSIF (l_return_status = okc_api.g_ret_sts_error) THEN

2192: END IF;
2193:
2194: IF (l_return_status = okc_api.g_ret_sts_unexp_error) THEN
2195: RAISE okc_api.g_exception_unexpected_error;
2196: ELSIF (l_return_status = okc_api.g_ret_sts_error) THEN
2197: RAISE okc_api.g_exception_error;
2198: END IF;
2199:
2200: l_max_quote_eff_to_dt :=

Line 2197: RAISE okc_api.g_exception_error;

2193:
2194: IF (l_return_status = okc_api.g_ret_sts_unexp_error) THEN
2195: RAISE okc_api.g_exception_unexpected_error;
2196: ELSIF (l_return_status = okc_api.g_ret_sts_error) THEN
2197: RAISE okc_api.g_exception_error;
2198: END IF;
2199:
2200: l_max_quote_eff_to_dt :=
2201: l_db_date_effective_from + l_quote_eff_max_days;

Line 2239: AND (lp_qtev_rec.accepted_yn <> okc_api.g_miss_char)

2235: END IF;
2236:
2237: -- Accepted YN Flag Validation
2238: IF ( (lp_qtev_rec.accepted_yn IS NOT NULL)
2239: AND (lp_qtev_rec.accepted_yn <> okc_api.g_miss_char)
2240: ) THEN
2241: -- if accepting now then check that quote is still effective
2242: IF (l_db_accepted_yn = g_no) AND (lp_qtev_rec.accepted_yn = g_yes) THEN
2243: -- If date_eff_to is not passed

Line 2318: IF (l_return_status = okc_api.g_ret_sts_unexp_error) THEN

2314: 'l_return_status: ' || l_return_status
2315: );
2316: END IF;
2317:
2318: IF (l_return_status = okc_api.g_ret_sts_unexp_error) THEN
2319: RAISE okc_api.g_exception_unexpected_error;
2320: ELSIF (l_return_status = okc_api.g_ret_sts_error) THEN
2321: RAISE okc_api.g_exception_error;
2322: END IF;

Line 2319: RAISE okc_api.g_exception_unexpected_error;

2315: );
2316: END IF;
2317:
2318: IF (l_return_status = okc_api.g_ret_sts_unexp_error) THEN
2319: RAISE okc_api.g_exception_unexpected_error;
2320: ELSIF (l_return_status = okc_api.g_ret_sts_error) THEN
2321: RAISE okc_api.g_exception_error;
2322: END IF;
2323:

Line 2320: ELSIF (l_return_status = okc_api.g_ret_sts_error) THEN

2316: END IF;
2317:
2318: IF (l_return_status = okc_api.g_ret_sts_unexp_error) THEN
2319: RAISE okc_api.g_exception_unexpected_error;
2320: ELSIF (l_return_status = okc_api.g_ret_sts_error) THEN
2321: RAISE okc_api.g_exception_error;
2322: END IF;
2323:
2324: -- update lines if necessary

Line 2321: RAISE okc_api.g_exception_error;

2317:
2318: IF (l_return_status = okc_api.g_ret_sts_unexp_error) THEN
2319: RAISE okc_api.g_exception_unexpected_error;
2320: ELSIF (l_return_status = okc_api.g_ret_sts_error) THEN
2321: RAISE okc_api.g_exception_error;
2322: END IF;
2323:
2324: -- update lines if necessary
2325: IF (lp_tqlv_tbl.COUNT > 0) THEN

Line 2377: IF (l_return_status = okc_api.g_ret_sts_unexp_error) THEN

2373: 'l_return_status: ' || l_return_status
2374: );
2375: END IF;
2376:
2377: IF (l_return_status = okc_api.g_ret_sts_unexp_error) THEN
2378: RAISE okc_api.g_exception_unexpected_error;
2379: ELSIF (l_return_status = okc_api.g_ret_sts_error) THEN
2380: RAISE okc_api.g_exception_error;
2381: END IF;

Line 2378: RAISE okc_api.g_exception_unexpected_error;

2374: );
2375: END IF;
2376:
2377: IF (l_return_status = okc_api.g_ret_sts_unexp_error) THEN
2378: RAISE okc_api.g_exception_unexpected_error;
2379: ELSIF (l_return_status = okc_api.g_ret_sts_error) THEN
2380: RAISE okc_api.g_exception_error;
2381: END IF;
2382: END IF;

Line 2379: ELSIF (l_return_status = okc_api.g_ret_sts_error) THEN

2375: END IF;
2376:
2377: IF (l_return_status = okc_api.g_ret_sts_unexp_error) THEN
2378: RAISE okc_api.g_exception_unexpected_error;
2379: ELSIF (l_return_status = okc_api.g_ret_sts_error) THEN
2380: RAISE okc_api.g_exception_error;
2381: END IF;
2382: END IF;
2383:

Line 2380: RAISE okc_api.g_exception_error;

2376:
2377: IF (l_return_status = okc_api.g_ret_sts_unexp_error) THEN
2378: RAISE okc_api.g_exception_unexpected_error;
2379: ELSIF (l_return_status = okc_api.g_ret_sts_error) THEN
2380: RAISE okc_api.g_exception_error;
2381: END IF;
2382: END IF;
2383:
2384: IF (is_debug_statement_on) THEN

Line 2442: IF (l_return_status = okc_api.g_ret_sts_unexp_error) THEN

2438: );
2439: END IF;
2440:
2441: -- raise exception if error
2442: IF (l_return_status = okc_api.g_ret_sts_unexp_error) THEN
2443: RAISE okc_api.g_exception_unexpected_error;
2444: ELSIF (l_return_status = okc_api.g_ret_sts_error) THEN
2445: RAISE okc_api.g_exception_error;
2446: END IF;

Line 2443: RAISE okc_api.g_exception_unexpected_error;

2439: END IF;
2440:
2441: -- raise exception if error
2442: IF (l_return_status = okc_api.g_ret_sts_unexp_error) THEN
2443: RAISE okc_api.g_exception_unexpected_error;
2444: ELSIF (l_return_status = okc_api.g_ret_sts_error) THEN
2445: RAISE okc_api.g_exception_error;
2446: END IF;
2447:

Line 2444: ELSIF (l_return_status = okc_api.g_ret_sts_error) THEN

2440:
2441: -- raise exception if error
2442: IF (l_return_status = okc_api.g_ret_sts_unexp_error) THEN
2443: RAISE okc_api.g_exception_unexpected_error;
2444: ELSIF (l_return_status = okc_api.g_ret_sts_error) THEN
2445: RAISE okc_api.g_exception_error;
2446: END IF;
2447:
2448: -- raise repurchase quote workflow if the quote is accepted now

Line 2445: RAISE okc_api.g_exception_error;

2441: -- raise exception if error
2442: IF (l_return_status = okc_api.g_ret_sts_unexp_error) THEN
2443: RAISE okc_api.g_exception_unexpected_error;
2444: ELSIF (l_return_status = okc_api.g_ret_sts_error) THEN
2445: RAISE okc_api.g_exception_error;
2446: END IF;
2447:
2448: -- raise repurchase quote workflow if the quote is accepted now
2449: IF (lp_qtev_rec.accepted_yn = g_yes AND l_db_accepted_yn = g_no) THEN

Line 2464: RAISE okc_api.g_exception_unexpected_error;

2460: );
2461:
2462: -- raise exception if error
2463: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2464: RAISE okc_api.g_exception_unexpected_error;
2465: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2466: RAISE okc_api.g_exception_error;
2467: END IF;
2468:

Line 2466: RAISE okc_api.g_exception_error;

2462: -- raise exception if error
2463: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2464: RAISE okc_api.g_exception_unexpected_error;
2465: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2466: RAISE okc_api.g_exception_error;
2467: END IF;
2468:
2469: -- Set message on stack
2470: -- Workflow event EVENT_NAME has been requested.

Line 2485: RAISE okc_api.g_exception_unexpected_error;

2481: );
2482:
2483: -- raise exception if error
2484: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2485: RAISE okc_api.g_exception_unexpected_error;
2486: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2487: RAISE okc_api.g_exception_error;
2488: END IF;
2489: END IF;

Line 2487: RAISE okc_api.g_exception_error;

2483: -- raise exception if error
2484: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2485: RAISE okc_api.g_exception_unexpected_error;
2486: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2487: RAISE okc_api.g_exception_error;
2488: END IF;
2489: END IF;
2490:
2491: -- set the return status and out variables

Line 2496: okc_api.end_activity (x_msg_count, x_msg_data);

2492: x_return_status := l_return_status;
2493: x_qtev_rec := lx_qtev_rec;
2494: x_tqlv_tbl := lx_tqlv_tbl;
2495: -- end the transaction
2496: okc_api.end_activity (x_msg_count, x_msg_data);
2497:
2498: IF (is_debug_procedure_on) THEN
2499: okl_debug_pub.log_debug (g_level_procedure, l_module_name, 'End(-)');
2500: END IF;

Line 2503: x_return_status := okc_api.g_ret_sts_error;

2499: okl_debug_pub.log_debug (g_level_procedure, l_module_name, 'End(-)');
2500: END IF;
2501: EXCEPTION
2502: WHEN g_exception_halt_validation THEN
2503: x_return_status := okc_api.g_ret_sts_error;
2504: WHEN okc_api.g_exception_error THEN
2505: x_return_status :=
2506: okc_api.handle_exceptions (l_api_name,
2507: g_pkg_name,

Line 2504: WHEN okc_api.g_exception_error THEN

2500: END IF;
2501: EXCEPTION
2502: WHEN g_exception_halt_validation THEN
2503: x_return_status := okc_api.g_ret_sts_error;
2504: WHEN okc_api.g_exception_error THEN
2505: x_return_status :=
2506: okc_api.handle_exceptions (l_api_name,
2507: g_pkg_name,
2508: 'OKC_API.G_RET_STS_ERROR',

Line 2506: okc_api.handle_exceptions (l_api_name,

2502: WHEN g_exception_halt_validation THEN
2503: x_return_status := okc_api.g_ret_sts_error;
2504: WHEN okc_api.g_exception_error THEN
2505: x_return_status :=
2506: okc_api.handle_exceptions (l_api_name,
2507: g_pkg_name,
2508: 'OKC_API.G_RET_STS_ERROR',
2509: x_msg_count,
2510: x_msg_data,

Line 2508: 'OKC_API.G_RET_STS_ERROR',

2504: WHEN okc_api.g_exception_error THEN
2505: x_return_status :=
2506: okc_api.handle_exceptions (l_api_name,
2507: g_pkg_name,
2508: 'OKC_API.G_RET_STS_ERROR',
2509: x_msg_count,
2510: x_msg_data,
2511: '_PVT'
2512: );

Line 2513: WHEN okc_api.g_exception_unexpected_error THEN

2509: x_msg_count,
2510: x_msg_data,
2511: '_PVT'
2512: );
2513: WHEN okc_api.g_exception_unexpected_error THEN
2514: x_return_status :=
2515: okc_api.handle_exceptions (l_api_name,
2516: g_pkg_name,
2517: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2515: okc_api.handle_exceptions (l_api_name,

2511: '_PVT'
2512: );
2513: WHEN okc_api.g_exception_unexpected_error THEN
2514: x_return_status :=
2515: okc_api.handle_exceptions (l_api_name,
2516: g_pkg_name,
2517: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2518: x_msg_count,
2519: x_msg_data,

Line 2517: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2513: WHEN okc_api.g_exception_unexpected_error THEN
2514: x_return_status :=
2515: okc_api.handle_exceptions (l_api_name,
2516: g_pkg_name,
2517: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2518: x_msg_count,
2519: x_msg_data,
2520: '_PVT'
2521: );

Line 2524: okc_api.handle_exceptions (l_api_name,

2520: '_PVT'
2521: );
2522: WHEN OTHERS THEN
2523: x_return_status :=
2524: okc_api.handle_exceptions (l_api_name,
2525: g_pkg_name,
2526: 'OTHERS',
2527: x_msg_count,
2528: x_msg_data,