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 OKL_API

Line 636: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false,

632: -- asset line instead of a terminated/expired contract
633: -- End of comments
634: PROCEDURE validate_quote (
635: p_api_version IN NUMBER,
636: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false,
637: x_return_status OUT NOCOPY VARCHAR2,
638: x_msg_count OUT NOCOPY NUMBER,
639: x_msg_data OUT NOCOPY VARCHAR2,
640: p_qtev_rec IN OUT NOCOPY qtev_rec_type,

Line 998: okl_api.set_message (p_app_name => g_app_name,

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,
1001: p_token1_value => 'legal_entity_id'
1002: );

Line 1119: x_return_status := okl_api.g_ret_sts_error;

1115: FETCH l_okclines_csr
1116: INTO l_sts_code;
1117:
1118: IF l_okclines_csr%NOTFOUND THEN
1119: x_return_status := okl_api.g_ret_sts_error;
1120: -- Kle ID is invalid
1121: okl_api.set_message (p_app_name => 'OKC',
1122: p_msg_name => g_invalid_value,
1123: p_token1 => g_col_name_token,

Line 1121: okl_api.set_message (p_app_name => 'OKC',

1117:
1118: IF l_okclines_csr%NOTFOUND THEN
1119: x_return_status := okl_api.g_ret_sts_error;
1120: -- Kle ID is invalid
1121: okl_api.set_message (p_app_name => 'OKC',
1122: p_msg_name => g_invalid_value,
1123: p_token1 => g_col_name_token,
1124: p_token1_value => 'KLE_ID'
1125: );

Line 1132: x_return_status := okl_api.g_ret_sts_error;

1128:
1129: CLOSE l_okclines_csr;
1130:
1131: IF l_sts_code NOT IN ('TERMINATED', 'EXPIRED') THEN
1132: x_return_status := okl_api.g_ret_sts_error;
1133: -- Asset ASSET_NUMBER is still STATUS. Asset should be terminated or expired.
1134: okl_api.set_message
1135: (p_app_name => 'OKL',
1136: p_msg_name => 'OKL_AM_ASSET_NOT_TERMINATED',

Line 1134: okl_api.set_message

1130:
1131: IF l_sts_code NOT IN ('TERMINATED', 'EXPIRED') THEN
1132: x_return_status := okl_api.g_ret_sts_error;
1133: -- Asset ASSET_NUMBER is still STATUS. Asset should be terminated or expired.
1134: okl_api.set_message
1135: (p_app_name => 'OKL',
1136: p_msg_name => 'OKL_AM_ASSET_NOT_TERMINATED',
1137: p_token1 => 'ASSET_NUMBER',
1138: p_token1_value => l_asset_number,

Line 1175: IF x_return_status <> okl_api.g_ret_sts_success THEN

1171: x_return_status => x_return_status
1172: );
1173:
1174: -- If error then above api will set the message, so exit now
1175: IF x_return_status <> okl_api.g_ret_sts_success THEN
1176: RAISE g_exception_halt_validation;
1177: END IF;
1178:
1179: -- see if any quotes already exist for this asset return id

Line 1503: okl_api.start_activity (l_api_name,

1499: END IF;
1500:
1501: --Check API version, initialize message list and create savepoint.
1502: l_return_status :=
1503: okl_api.start_activity (l_api_name,
1504: g_pkg_name,
1505: p_init_msg_list,
1506: l_api_version,
1507: p_api_version,

Line 1512: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1508: '_PVT',
1509: x_return_status
1510: );
1511:
1512: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1513: RAISE okl_api.g_exception_unexpected_error;
1514: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1515: RAISE okl_api.g_exception_error;
1516: END IF;

Line 1513: RAISE okl_api.g_exception_unexpected_error;

1509: x_return_status
1510: );
1511:
1512: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1513: RAISE okl_api.g_exception_unexpected_error;
1514: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1515: RAISE okl_api.g_exception_error;
1516: END IF;
1517:

Line 1514: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1510: );
1511:
1512: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1513: RAISE okl_api.g_exception_unexpected_error;
1514: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1515: RAISE okl_api.g_exception_error;
1516: END IF;
1517:
1518: IF (is_debug_statement_on) THEN

Line 1515: RAISE okl_api.g_exception_error;

1511:
1512: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1513: RAISE okl_api.g_exception_unexpected_error;
1514: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1515: RAISE okl_api.g_exception_error;
1516: END IF;
1517:
1518: IF (is_debug_statement_on) THEN
1519: okl_debug_pub.log_debug (g_level_statement,

Line 1666: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1662: 'l_return_status: ' || l_return_status
1663: );
1664: END IF;
1665:
1666: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1667: RAISE okl_api.g_exception_unexpected_error;
1668: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1669: RAISE okl_api.g_exception_error;
1670: END IF;

Line 1667: RAISE okl_api.g_exception_unexpected_error;

1663: );
1664: END IF;
1665:
1666: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1667: RAISE okl_api.g_exception_unexpected_error;
1668: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1669: RAISE okl_api.g_exception_error;
1670: END IF;
1671:

Line 1668: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1664: END IF;
1665:
1666: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1667: RAISE okl_api.g_exception_unexpected_error;
1668: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1669: RAISE okl_api.g_exception_error;
1670: END IF;
1671:
1672: -- set the asset table to be passed to the calculate quote api

Line 1669: RAISE okl_api.g_exception_error;

1665:
1666: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1667: RAISE okl_api.g_exception_unexpected_error;
1668: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1669: RAISE okl_api.g_exception_error;
1670: END IF;
1671:
1672: -- set the asset table to be passed to the calculate quote api
1673: IF (lp_tqlv_tbl.COUNT > 0) THEN

Line 2024: okl_api.start_activity (l_api_name,

2020: END IF;
2021:
2022: --Check API version, initialize message list and create savepoint.
2023: l_return_status :=
2024: okl_api.start_activity (l_api_name,
2025: g_pkg_name,
2026: p_init_msg_list,
2027: l_api_version,
2028: p_api_version,

Line 2033: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

2029: '_PVT',
2030: x_return_status
2031: );
2032:
2033: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2034: RAISE okl_api.g_exception_unexpected_error;
2035: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2036: RAISE okl_api.g_exception_error;
2037: END IF;

Line 2034: RAISE okl_api.g_exception_unexpected_error;

2030: x_return_status
2031: );
2032:
2033: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2034: RAISE okl_api.g_exception_unexpected_error;
2035: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2036: RAISE okl_api.g_exception_error;
2037: END IF;
2038:

Line 2035: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

2031: );
2032:
2033: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2034: RAISE okl_api.g_exception_unexpected_error;
2035: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2036: RAISE okl_api.g_exception_error;
2037: END IF;
2038:
2039: -- initialize return variables

Line 2036: RAISE okl_api.g_exception_error;

2032:
2033: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2034: RAISE okl_api.g_exception_unexpected_error;
2035: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
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;

Line 2098: AND lp_qtev_rec.qtp_code <> okl_api.g_miss_char

2094: get_sysdate (l_db_date);
2095:
2096: -- IF qtp_code not null then check if valid
2097: IF lp_qtev_rec.qtp_code IS NOT NULL
2098: AND lp_qtev_rec.qtp_code <> okl_api.g_miss_char
2099: AND lp_qtev_rec.qtp_code NOT LIKE 'REP_STANDARD' THEN
2100: -- Please select a valid Quote Type.
2101: okl_api.set_message (p_app_name => okl_api.g_app_name,
2102: p_msg_name => 'OKL_AM_QTP_CODE_INVALID'

Line 2101: okl_api.set_message (p_app_name => okl_api.g_app_name,

2097: IF lp_qtev_rec.qtp_code IS NOT NULL
2098: AND lp_qtev_rec.qtp_code <> okl_api.g_miss_char
2099: AND lp_qtev_rec.qtp_code NOT LIKE 'REP_STANDARD' THEN
2100: -- Please select a valid Quote Type.
2101: okl_api.set_message (p_app_name => okl_api.g_app_name,
2102: p_msg_name => 'OKL_AM_QTP_CODE_INVALID'
2103: );
2104: RAISE g_exception_halt_validation;
2105: -- if qtp_code is null then get from db and check

Line 2107: OR lp_qtev_rec.qtp_code = okl_api.g_miss_char

2103: );
2104: RAISE g_exception_halt_validation;
2105: -- if qtp_code is null then get from db and check
2106: ELSIF ( lp_qtev_rec.qtp_code IS NULL
2107: OR lp_qtev_rec.qtp_code = okl_api.g_miss_char
2108: )
2109: AND l_db_qtp_code NOT LIKE 'REP_STANDARD' THEN
2110: -- Please select a valid Quote Type.
2111: okl_api.set_message (p_app_name => okl_api.g_app_name,

Line 2111: okl_api.set_message (p_app_name => okl_api.g_app_name,

2107: OR lp_qtev_rec.qtp_code = okl_api.g_miss_char
2108: )
2109: AND l_db_qtp_code NOT LIKE 'REP_STANDARD' THEN
2110: -- Please select a valid Quote Type.
2111: okl_api.set_message (p_app_name => okl_api.g_app_name,
2112: p_msg_name => 'OKL_AM_QTP_CODE_INVALID'
2113: );
2114: RAISE g_exception_halt_validation;
2115: END IF;

Line 2119: OR lp_qtev_rec.date_effective_to = okl_api.g_miss_date THEN

2115: END IF;
2116:
2117: -- Check if date_effective_to is NULL
2118: IF lp_qtev_rec.date_effective_to IS NULL
2119: OR lp_qtev_rec.date_effective_to = okl_api.g_miss_date THEN
2120: -- You must enter a value for PROMPT
2121: okl_api.set_message
2122: (p_app_name => okl_api.g_app_name,
2123: p_msg_name => 'OKL_AM_REQ_FIELD_ERR',

Line 2121: okl_api.set_message

2117: -- Check if date_effective_to is NULL
2118: IF lp_qtev_rec.date_effective_to IS NULL
2119: OR lp_qtev_rec.date_effective_to = okl_api.g_miss_date THEN
2120: -- You must enter a value for PROMPT
2121: okl_api.set_message
2122: (p_app_name => okl_api.g_app_name,
2123: p_msg_name => 'OKL_AM_REQ_FIELD_ERR',
2124: p_token1 => 'PROMPT',
2125: p_token1_value => okl_am_util_pvt.get_ak_attribute

Line 2122: (p_app_name => okl_api.g_app_name,

2118: IF lp_qtev_rec.date_effective_to IS NULL
2119: OR lp_qtev_rec.date_effective_to = okl_api.g_miss_date THEN
2120: -- You must enter a value for PROMPT
2121: okl_api.set_message
2122: (p_app_name => okl_api.g_app_name,
2123: p_msg_name => 'OKL_AM_REQ_FIELD_ERR',
2124: p_token1 => 'PROMPT',
2125: p_token1_value => okl_am_util_pvt.get_ak_attribute
2126: ('OKL_EFFECTIVE_TO')

Line 2133: AND (lp_qtev_rec.date_effective_from <> okl_api.g_miss_date) THEN

2129: END IF;
2130:
2131: -- Get the date_eff_from from database if not passed
2132: IF (lp_qtev_rec.date_effective_from IS NOT NULL)
2133: AND (lp_qtev_rec.date_effective_from <> okl_api.g_miss_date) THEN
2134: l_date_eff_from := lp_qtev_rec.date_effective_from;
2135: ELSE
2136: l_date_eff_from := l_db_date_effective_from;
2137: END IF;

Line 2141: AND (l_date_eff_from <> okl_api.g_miss_date)

2137: END IF;
2138:
2139: -- Check date_eff_to > date_eff_from
2140: IF (l_date_eff_from IS NOT NULL)
2141: AND (l_date_eff_from <> okl_api.g_miss_date)
2142: AND (lp_qtev_rec.date_effective_to IS NOT NULL)
2143: AND (lp_qtev_rec.date_effective_to <> okl_api.g_miss_date) THEN
2144: IF (TRUNC (lp_qtev_rec.date_effective_to) <= TRUNC (l_date_eff_from)
2145: ) THEN

Line 2143: AND (lp_qtev_rec.date_effective_to <> okl_api.g_miss_date) THEN

2139: -- Check date_eff_to > date_eff_from
2140: IF (l_date_eff_from IS NOT NULL)
2141: AND (l_date_eff_from <> okl_api.g_miss_date)
2142: AND (lp_qtev_rec.date_effective_to IS NOT NULL)
2143: AND (lp_qtev_rec.date_effective_to <> okl_api.g_miss_date) THEN
2144: IF (TRUNC (lp_qtev_rec.date_effective_to) <= TRUNC (l_date_eff_from)
2145: ) THEN
2146: -- Message : Date Effective To DATE_EFFECTIVE_TO cannot be before
2147: -- Date Effective From DATE_EFFECTIVE_FROM.

Line 2148: okl_api.set_message

2144: IF (TRUNC (lp_qtev_rec.date_effective_to) <= TRUNC (l_date_eff_from)
2145: ) THEN
2146: -- Message : Date Effective To DATE_EFFECTIVE_TO cannot be before
2147: -- Date Effective From DATE_EFFECTIVE_FROM.
2148: okl_api.set_message
2149: (p_app_name => 'OKL',
2150: p_msg_name => 'OKL_AM_DATE_EFF_FROM_LESS_TO',
2151: p_token1 => 'DATE_EFFECTIVE_TO',
2152: p_token1_value => lp_qtev_rec.date_effective_to,

Line 2206: okl_api.set_message (p_app_name => g_app_name,

2202:
2203: -- if max quote eff to date is less than sysdate then error
2204: IF (TRUNC (l_max_quote_eff_to_dt) < TRUNC (l_db_date)) THEN
2205: --Quote QUOTE_NUMBER is already expired.
2206: okl_api.set_message (p_app_name => g_app_name,
2207: p_msg_name => 'OKL_AM_QUOTE_ALREADY_EXP',
2208: p_token1 => g_quote_number_token,
2209: p_token1_value => l_quote_number
2210: );

Line 2217: okl_api.set_message (p_app_name => g_app_name,

2213:
2214: -- if date is less than sysdate then error
2215: IF (TRUNC (lp_qtev_rec.date_effective_to) < TRUNC (l_db_date)) THEN
2216: --Please enter an Effective To date that occurs after the current system date.
2217: okl_api.set_message (p_app_name => g_app_name,
2218: p_msg_name => 'OKL_AM_DATE_EFF_TO_PAST'
2219: );
2220: RAISE g_exception_halt_validation;
2221: END IF;

Line 2228: okl_api.set_message (p_app_name => g_app_name,

2224: IF (TRUNC (lp_qtev_rec.date_effective_to) >
2225: TRUNC (l_max_quote_eff_to_dt)
2226: ) THEN
2227: --Please enter Effective To date before DATE_EFF_TO_MAX.
2228: okl_api.set_message (p_app_name => g_app_name,
2229: p_msg_name => 'OKL_AM_DATE_EFF_TO_ERR',
2230: p_token1 => g_max_date_token,
2231: p_token1_value => l_max_quote_eff_to_dt
2232: );

Line 2245: OR (lp_qtev_rec.date_effective_to = okl_api.g_miss_date)

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
2244: IF ( (lp_qtev_rec.date_effective_to IS NULL)
2245: OR (lp_qtev_rec.date_effective_to = okl_api.g_miss_date)
2246: ) THEN
2247: --Has quote expired
2248: IF TRUNC (l_db_date) > TRUNC (l_db_date_effective_to) THEN
2249: --Quote QUOTE_NUMBER is already expired.

Line 2250: okl_api.set_message

2246: ) THEN
2247: --Has quote expired
2248: IF TRUNC (l_db_date) > TRUNC (l_db_date_effective_to) THEN
2249: --Quote QUOTE_NUMBER is already expired.
2250: okl_api.set_message
2251: (p_app_name => g_app_name,
2252: p_msg_name => 'OKL_AM_QUOTE_ALREADY_EXP',
2253: p_token1 => g_quote_number_token,
2254: p_token1_value => l_quote_number

Line 2266: okl_api.set_message (p_app_name => g_app_name,

2262: -- if already accepted and trying to change then raise error
2263: ELSIF (l_db_accepted_yn = g_yes)
2264: AND (lp_qtev_rec.accepted_yn = g_no) THEN
2265: --Quote QUOTE_NUMBER is already accepted.
2266: okl_api.set_message (p_app_name => g_app_name,
2267: p_msg_name => 'OKL_AM_QUOTE_ALREADY_ACCP',
2268: p_token1 => g_quote_number_token,
2269: p_token1_value => l_quote_number
2270: );

Line 2333: AND lp_tqlv_tbl (i).ID <> okl_api.g_miss_num

2329: -- rmunjulu Sales_Tax_Enhancement -- Do not take tax quote line for update as that does not have the ID
2330: FOR i IN lp_tqlv_tbl.FIRST .. lp_tqlv_tbl.LAST
2331: LOOP
2332: IF ( lp_tqlv_tbl (i).ID IS NOT NULL
2333: AND lp_tqlv_tbl (i).ID <> okl_api.g_miss_num
2334: )
2335: AND lp_tqlv_tbl (i).qlt_code <> 'AMCTAX' THEN
2336: llp_tqlv_tbl (j) := lp_tqlv_tbl (i);
2337: j := j + 1;

Line 2412: p_init_msg_list => okl_api.g_false,

2408: END IF;
2409:
2410: okl_process_sales_tax_pub.calculate_sales_tax
2411: (p_api_version => l_api_version,
2412: p_init_msg_list => okl_api.g_false,
2413: x_return_status => l_return_status,
2414: x_msg_count => x_msg_count,
2415: x_msg_data => x_msg_data,
2416: p_source_trx_id => lp_qtev_rec.ID,

Line 2434: IF (l_return_status <> okl_api.g_ret_sts_success) THEN

2430: 'l_return_status: ' || l_return_status
2431: );
2432: END IF;
2433:
2434: IF (l_return_status <> okl_api.g_ret_sts_success) THEN
2435: -- Tax Processing failed.
2436: okl_api.set_message (p_app_name => g_app_name,
2437: p_msg_name => 'OKL_AM_PROCESS_TAX_ERR'
2438: );

Line 2436: okl_api.set_message (p_app_name => g_app_name,

2432: END IF;
2433:
2434: IF (l_return_status <> okl_api.g_ret_sts_success) THEN
2435: -- Tax Processing failed.
2436: okl_api.set_message (p_app_name => g_app_name,
2437: p_msg_name => 'OKL_AM_PROCESS_TAX_ERR'
2438: );
2439: END IF;
2440:

Line 2463: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

2459: x_return_status => l_return_status
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;

Line 2465: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

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:
2469: -- Set message on stack

Line 2471: okl_api.set_message (p_app_name => g_app_name,

2467: END IF;
2468:
2469: -- Set message on stack
2470: -- Workflow event EVENT_NAME has been requested.
2471: okl_api.set_message (p_app_name => g_app_name,
2472: p_msg_name => 'OKL_AM_WF_EVENT_MSG',
2473: p_token1 => 'EVENT_NAME',
2474: p_token1_value => l_event_desc
2475: );

Line 2484: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

2480: x_return_status => l_return_status
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;

Line 2486: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

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;
2490: