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_ASSET_RETURN_PVT dependencies on OKL_AM_UTIL_PVT

Line 143: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');

139: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_kle_id: '||p_kle_id);
140: END IF;
141:
142: IF (is_debug_statement_on) THEN
143: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');
144: END IF;
145:
146: okl_am_util_pvt.get_rule_record( p_rgd_code => 'AMLARL'
147: ,p_rdf_code => 'AMCFPR'

Line 146: okl_am_util_pvt.get_rule_record( p_rgd_code => 'AMLARL'

142: IF (is_debug_statement_on) THEN
143: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');
144: END IF;
145:
146: okl_am_util_pvt.get_rule_record( p_rgd_code => 'AMLARL'
147: ,p_rdf_code => 'AMCFPR'
148: ,p_chr_id => p_chr_id
149: ,p_cle_id => NULL
150: ,p_message_yn => FALSE

Line 156: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called okl_am_util_pvt.get_rule_record, return status :'||x_return_status);

152: ,x_return_status => x_return_status
153: ,x_msg_count => x_msg_count
154: ,x_msg_data => x_msg_data);
155: IF (is_debug_statement_on) THEN
156: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called okl_am_util_pvt.get_rule_record, return status :'||x_return_status);
157: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_rulv_rec.rule_information1 :'||l_rulv_rec.rule_information1);
158: END IF;
159:
160: IF (x_return_status = OKL_API.G_RET_STS_SUCCESS) THEN

Line 170: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_formula_value');

166: END IF;
167: END IF;
168:
169: IF (is_debug_statement_on) THEN
170: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_formula_value');
171: END IF;
172:
173: okl_am_util_pvt.get_formula_value(
174: p_formula_name => l_formula_name,

Line 173: okl_am_util_pvt.get_formula_value(

169: IF (is_debug_statement_on) THEN
170: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_formula_value');
171: END IF;
172:
173: okl_am_util_pvt.get_formula_value(
174: p_formula_name => l_formula_name,
175: p_chr_id => p_chr_id,
176: p_cle_id => p_kle_id,
177: x_formula_value => l_floor_price,

Line 180: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called okl_am_util_pvt.get_formula_value, return status :'||x_return_status);

176: p_cle_id => p_kle_id,
177: x_formula_value => l_floor_price,
178: x_return_status => x_return_status);
179: IF (is_debug_statement_on) THEN
180: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called okl_am_util_pvt.get_formula_value, return status :'||x_return_status);
181: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_floor_price :'||l_floor_price);
182: END IF;
183:
184: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

Line 260: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');

256: END IF;
257: IF (is_debug_statement_on) THEN
258: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
259: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_kle_id: '||p_kle_id);
260: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');
261: END IF;
262: okl_am_util_pvt.get_rule_record( p_rgd_code => 'AMLARL'
263: ,p_rdf_code => 'AMCFPR'
264: ,p_chr_id => p_chr_id

Line 262: okl_am_util_pvt.get_rule_record( p_rgd_code => 'AMLARL'

258: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_chr_id: '||p_chr_id);
259: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_kle_id: '||p_kle_id);
260: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');
261: END IF;
262: okl_am_util_pvt.get_rule_record( p_rgd_code => 'AMLARL'
263: ,p_rdf_code => 'AMCFPR'
264: ,p_chr_id => p_chr_id
265: ,p_cle_id => NULL
266: ,p_message_yn => FALSE

Line 272: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record, return status: ' || x_return_status);

268: ,x_return_status => x_return_status
269: ,x_msg_count => x_msg_count
270: ,x_msg_data => x_msg_data);
271: IF (is_debug_statement_on) THEN
272: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record, return status: ' || x_return_status);
273: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_rulv_rec.rule_information2: ' || l_rulv_rec.rule_information2);
274: END IF;
275:
276: IF (x_return_status = OKL_API.G_RET_STS_SUCCESS) THEN

Line 289: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_formula_value');

285: RETURN NULL;
286: END IF;
287:
288: IF (is_debug_statement_on) THEN
289: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_formula_value');
290: END IF;
291: okl_am_util_pvt.get_formula_value(
292: p_formula_name => l_rulv_rec.rule_information2,
293: p_chr_id => p_chr_id,

Line 291: okl_am_util_pvt.get_formula_value(

287:
288: IF (is_debug_statement_on) THEN
289: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_formula_value');
290: END IF;
291: okl_am_util_pvt.get_formula_value(
292: p_formula_name => l_rulv_rec.rule_information2,
293: p_chr_id => p_chr_id,
294: p_cle_id => p_kle_id,
295: x_formula_value => l_item_price,

Line 298: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_formula_value, return status: ' || x_return_status);

294: p_cle_id => p_kle_id,
295: x_formula_value => l_item_price,
296: x_return_status => x_return_status);
297: IF (is_debug_statement_on) THEN
298: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_formula_value, return status: ' || x_return_status);
299: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'l_item_price: ' || l_item_price);
300: END IF;
301: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
302: RETURN NULL;

Line 385: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');

381: RAISE repurchase_agreement_error;
382: END IF;
383:
384: IF (is_debug_statement_on) THEN
385: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');
386: END IF;
387: okl_am_util_pvt.get_rule_record( p_rgd_code => 'AMREPQ'
388: ,p_rdf_code => 'AMARQC'
389: ,p_chr_id => p_chr_id

Line 387: okl_am_util_pvt.get_rule_record( p_rgd_code => 'AMREPQ'

383:
384: IF (is_debug_statement_on) THEN
385: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling okl_am_util_pvt.get_rule_record');
386: END IF;
387: okl_am_util_pvt.get_rule_record( p_rgd_code => 'AMREPQ'
388: ,p_rdf_code => 'AMARQC'
389: ,p_chr_id => p_chr_id
390: ,p_cle_id => NULL
391: ,p_message_yn => FALSE

Line 398: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record, x_return_status: ' || x_return_status);

394: ,x_msg_count => x_msg_count
395: ,x_msg_data => x_msg_data);
396:
397: IF (is_debug_statement_on) THEN
398: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record, x_return_status: ' || x_return_status);
399: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record, l_rulv_rec.rule_information1: ' || l_rulv_rec.rule_information1);
400: END IF;
401:
402: IF (x_return_status = OKL_API.G_RET_STS_SUCCESS) THEN

Line 399: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record, l_rulv_rec.rule_information1: ' || l_rulv_rec.rule_information1);

395: ,x_msg_data => x_msg_data);
396:
397: IF (is_debug_statement_on) THEN
398: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record, x_return_status: ' || x_return_status);
399: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record, l_rulv_rec.rule_information1: ' || l_rulv_rec.rule_information1);
400: END IF;
401:
402: IF (x_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
403: -- Rule instance is found, but formula not found

Line 932: l_func_curr_code := okl_am_util_pvt.get_functional_currency;

928:
929: -- SECHAWLA Bug # 2667636 : get the functional and contract currency
930:
931: -- get the functional currency
932: l_func_curr_code := okl_am_util_pvt.get_functional_currency;
933: -- get the contract currency
934: l_contract_curr_code := okl_am_util_pvt.get_chr_currency( p_chr_id => l_chr_id);
935:
936:

Line 934: l_contract_curr_code := okl_am_util_pvt.get_chr_currency( p_chr_id => l_chr_id);

930:
931: -- get the functional currency
932: l_func_curr_code := okl_am_util_pvt.get_functional_currency;
933: -- get the contract currency
934: l_contract_curr_code := okl_am_util_pvt.get_chr_currency( p_chr_id => l_chr_id);
935:
936:
937: -- get the floor price
938:

Line 1113: l_user_profile_name := okl_am_util_pvt.get_user_profile_option_name(

1109: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
1110:
1111: --SECHAWLA 16-JAN-03 Bug# 2754280: Added the following code to display user profile option name in messages
1112: -- instead of profile option name
1113: l_user_profile_name := okl_am_util_pvt.get_user_profile_option_name(
1114: p_profile_option_name => 'OKL_DEFAULT_REMARKETER',
1115: x_return_status => x_return_status);
1116: IF (is_debug_statement_on) THEN
1117: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'x_return_status of okl_am_util_pvt.get_user_profile_option_name: ' || x_return_status);

Line 1117: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'x_return_status of okl_am_util_pvt.get_user_profile_option_name: ' || x_return_status);

1113: l_user_profile_name := okl_am_util_pvt.get_user_profile_option_name(
1114: p_profile_option_name => 'OKL_DEFAULT_REMARKETER',
1115: x_return_status => x_return_status);
1116: IF (is_debug_statement_on) THEN
1117: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'x_return_status of okl_am_util_pvt.get_user_profile_option_name: ' || x_return_status);
1118: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'l_user_profile_name: ' || l_user_profile_name);
1119: END IF;
1120:
1121: IF x_return_status = OKL_API.G_RET_STS_ERROR THEN

Line 1239: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'calling okl_am_util_pvt.get_rule_record');

1235: OKL_AM_WF.raise_business_event(lx_artv_rec.id,'oracle.apps.okl.am.notifyremarketer');
1236:
1237:
1238: IF (is_debug_statement_on) THEN
1239: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'calling okl_am_util_pvt.get_rule_record');
1240: END IF;
1241: -- First get the party id from the rule if the custodian is a 3rd party
1242: okl_am_util_pvt.get_rule_record (
1243: p_rgd_code => 'LAAFLG',

Line 1242: okl_am_util_pvt.get_rule_record (

1238: IF (is_debug_statement_on) THEN
1239: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'calling okl_am_util_pvt.get_rule_record');
1240: END IF;
1241: -- First get the party id from the rule if the custodian is a 3rd party
1242: okl_am_util_pvt.get_rule_record (
1243: p_rgd_code => 'LAAFLG',
1244: p_rdf_code => 'LAFLTL',
1245: p_chr_id => l_chr_id,
1246: p_cle_id => lp_artv_rec.kle_id,

Line 1252: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called okl_am_util_pvt.get_rule_record, l_return_status: ' || l_return_status);

1248: x_return_status => l_return_status,
1249: p_message_yn => FALSE); -- put error message on stack if there is no rule
1250:
1251: IF (is_debug_statement_on) THEN
1252: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called okl_am_util_pvt.get_rule_record, l_return_status: ' || l_return_status);
1253: END IF;
1254:
1255: IF l_return_status = OKL_API.G_RET_STS_SUCCESS AND l_rulv_rec.object2_id1 IS NOT NULL AND l_rulv_rec.object2_id1 <> OKL_API.G_MISS_NUM THEN
1256: IF (is_debug_statement_on) THEN

Line 1820: l_meaning := okl_am_util_pvt.get_lookup_meaning(

1816: IF l_current_db_status = 'AVAILABLE_FOR_SALE' THEN
1817: IF lp_artv_rec.ARS_CODE NOT IN ('AVAILABLE_FOR_SALE', 'REMARKETED') THEN
1818: x_return_status := OKL_API.G_RET_STS_ERROR;
1819:
1820: l_meaning := okl_am_util_pvt.get_lookup_meaning(
1821: p_lookup_type => 'OKL_ASSET_RETURN_STATUS',
1822: p_lookup_code => l_current_db_status);
1823:
1824: --Can not change the asset status when it is already Available For Sale.

Line 1838: l_meaning := okl_am_util_pvt.get_lookup_meaning(

1834: IF l_current_db_status = 'SCRAPPED' THEN
1835: IF lp_artv_rec.ARS_CODE <> 'SCRAPPED' THEN
1836: x_return_status := OKL_API.G_RET_STS_ERROR;
1837:
1838: l_meaning := okl_am_util_pvt.get_lookup_meaning(
1839: p_lookup_type => 'OKL_ASSET_RETURN_STATUS',
1840: p_lookup_code => l_current_db_status);
1841:
1842: --Can not change the asset status when it is SCRAPPED.

Line 1856: l_meaning := okl_am_util_pvt.get_lookup_meaning(

1852: IF l_current_db_status = 'CANCELLED' THEN
1853: IF lp_artv_rec.ARS_CODE <> 'CANCELLED' THEN
1854: x_return_status := OKL_API.G_RET_STS_ERROR;
1855:
1856: l_meaning := okl_am_util_pvt.get_lookup_meaning(
1857: p_lookup_type => 'OKL_ASSET_RETURN_STATUS',
1858: p_lookup_code => l_current_db_status);
1859:
1860:

Line 1875: l_meaning := okl_am_util_pvt.get_lookup_meaning(

1871: IF l_current_db_status = 'REMARKETED' THEN
1872: IF lp_artv_rec.ARS_CODE <> 'REMARKETED' THEN
1873: x_return_status := OKL_API.G_RET_STS_ERROR;
1874:
1875: l_meaning := okl_am_util_pvt.get_lookup_meaning(
1876: p_lookup_type => 'OKL_ASSET_RETURN_STATUS',
1877: p_lookup_code => l_current_db_status);
1878:
1879:

Line 1894: l_meaning := okl_am_util_pvt.get_lookup_meaning(

1890: IF l_current_db_status = 'REPURCHASE' THEN
1891: IF lp_artv_rec.ARS_CODE <> 'REPURCHASE' THEN
1892: x_return_status := OKL_API.G_RET_STS_ERROR;
1893:
1894: l_meaning := okl_am_util_pvt.get_lookup_meaning(
1895: p_lookup_type => 'OKL_ASSET_RETURN_STATUS',
1896: p_lookup_code => l_current_db_status);
1897:
1898: --Can not change the asset status when it is 'REPURCHASE'