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.

[Home] [Help]

APPS.PA_RBS_MAPPING dependencies on PA_RBS_MAPPING

Line 1: PACKAGE BODY PA_RBS_MAPPING AS

1: PACKAGE BODY PA_RBS_MAPPING AS
2: /* $Header: PARBSMPB.pls 120.32.12020000.3 2013/03/07 23:24:16 sachandr ship $ */
3:
4: -------------------------------------------------
5: --global variables

Line 10: g_module_name VARCHAR2(100) := 'PA_RBS_MAPPING';

6: -------------------------------------------------
7: g_user_id NUMBER := fnd_global.user_id;
8: g_login_id NUMBER := fnd_global.login_id;
9: g_debug_mode VARCHAR2(10) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
10: g_module_name VARCHAR2(100) := 'PA_RBS_MAPPING';
11:
12: -- added for bug#3995697
13: g_rule_id NUMBER := NULL;
14: g_max_level NUMBER := NULL;

Line 41: --Gets the sorted rules from pa_rbs_mapping_rules

37: RETURN lockhndl;
38: END;
39:
40: --------------------------------------------------
41: --Gets the sorted rules from pa_rbs_mapping_rules
42: --given rbs structure version and resource class
43: --------------------------------------------------
44: FUNCTION get_sorted_rules
45: (

Line 71: FROM pa_rbs_mapping_rules

67: rule_id
68: BULK COLLECT INTO
69: l_precedence,
70: l_sorted_rules
71: FROM pa_rbs_mapping_rules
72: WHERE element_version_id = p_struct_version_id
73: ORDER BY
74: max_level desc ,
75: 1 ,

Line 239: -- Get the Level from the pa_rbs_mapping_rules for the Rule Id

235:
236: END ;
237:
238: -------------------------------------------------------------------
239: -- Get the Level from the pa_rbs_mapping_rules for the Rule Id
240: -------------------------------------------------------------------
241:
242: --modified function below for bug#4478902
243:

Line 265: Select Level1 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

261: END IF;
262:
263: CASE p_level
264: WHEN 1 THEN
265: Select Level1 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
266: WHEN 2 THEN
267: Select Level2 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
268: WHEN 3 THEN
269: Select Level3 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

Line 267: Select Level2 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

263: CASE p_level
264: WHEN 1 THEN
265: Select Level1 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
266: WHEN 2 THEN
267: Select Level2 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
268: WHEN 3 THEN
269: Select Level3 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
270: WHEN 4 THEN
271: Select Level4 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

Line 269: Select Level3 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

265: Select Level1 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
266: WHEN 2 THEN
267: Select Level2 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
268: WHEN 3 THEN
269: Select Level3 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
270: WHEN 4 THEN
271: Select Level4 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
272: WHEN 5 THEN
273: Select Level5 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

Line 271: Select Level4 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

267: Select Level2 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
268: WHEN 3 THEN
269: Select Level3 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
270: WHEN 4 THEN
271: Select Level4 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
272: WHEN 5 THEN
273: Select Level5 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
274: WHEN 6 THEN
275: Select Level6 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

Line 273: Select Level5 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

269: Select Level3 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
270: WHEN 4 THEN
271: Select Level4 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
272: WHEN 5 THEN
273: Select Level5 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
274: WHEN 6 THEN
275: Select Level6 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
276: WHEN 7 THEN
277: Select Level7 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

Line 275: Select Level6 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

271: Select Level4 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
272: WHEN 5 THEN
273: Select Level5 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
274: WHEN 6 THEN
275: Select Level6 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
276: WHEN 7 THEN
277: Select Level7 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
278: WHEN 8 THEN
279: Select Level8 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

Line 277: Select Level7 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

273: Select Level5 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
274: WHEN 6 THEN
275: Select Level6 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
276: WHEN 7 THEN
277: Select Level7 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
278: WHEN 8 THEN
279: Select Level8 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
280: WHEN 9 THEN
281: Select Level9 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

Line 279: Select Level8 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

275: Select Level6 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
276: WHEN 7 THEN
277: Select Level7 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
278: WHEN 8 THEN
279: Select Level8 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
280: WHEN 9 THEN
281: Select Level9 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
282: WHEN 10 THEN
283: Select Level10 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

Line 281: Select Level9 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

277: Select Level7 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
278: WHEN 8 THEN
279: Select Level8 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
280: WHEN 9 THEN
281: Select Level9 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
282: WHEN 10 THEN
283: Select Level10 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
284: WHEN 11 THEN
285: Select Level11 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

Line 283: Select Level10 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

279: Select Level8 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
280: WHEN 9 THEN
281: Select Level9 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
282: WHEN 10 THEN
283: Select Level10 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
284: WHEN 11 THEN
285: Select Level11 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
286: WHEN 12 THEN
287: Select Level12 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

Line 285: Select Level11 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

281: Select Level9 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
282: WHEN 10 THEN
283: Select Level10 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
284: WHEN 11 THEN
285: Select Level11 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
286: WHEN 12 THEN
287: Select Level12 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
288: WHEN 13 THEN
289: Select Level13 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

Line 287: Select Level12 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

283: Select Level10 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
284: WHEN 11 THEN
285: Select Level11 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
286: WHEN 12 THEN
287: Select Level12 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
288: WHEN 13 THEN
289: Select Level13 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
290: WHEN 14 THEN
291: Select Level14 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

Line 289: Select Level13 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

285: Select Level11 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
286: WHEN 12 THEN
287: Select Level12 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
288: WHEN 13 THEN
289: Select Level13 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
290: WHEN 14 THEN
291: Select Level14 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
292: WHEN 15 THEN
293: Select Level15 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

Line 291: Select Level14 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

287: Select Level12 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
288: WHEN 13 THEN
289: Select Level13 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
290: WHEN 14 THEN
291: Select Level14 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
292: WHEN 15 THEN
293: Select Level15 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
294: ELSE
295: l_value:=NULL;

Line 293: Select Level15 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;

289: Select Level13 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
290: WHEN 14 THEN
291: Select Level14 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
292: WHEN 15 THEN
293: Select Level15 into l_value from pa_rbs_mapping_rules where rule_id=p_rule_id;
294: ELSE
295: l_value:=NULL;
296: END CASE;
297:

Line 395: --EXECUTE IMMEDIATE 'SELECT LEVEL' || i || ' FROM pa_rbs_mapping_rules WHERE rule_id = ' || p_rule_id INTO l_token ;

391:
392: j := 1;
393: FOR i IN 2..g_max_level LOOP
394: l_token:= get_level(p_rule_id,i);
395: --EXECUTE IMMEDIATE 'SELECT LEVEL' || i || ' FROM pa_rbs_mapping_rules WHERE rule_id = ' || p_rule_id INTO l_token ;
396: --commented if and endif for custom nodes
397: --IF substr(l_token,1,1) = 'R' OR substr(l_token,1,1) = 'I' THEN -- condition should be false for custom based node
398: l_res_type_cols(j) := get_resource_type_cols(substr(l_token,3,3)); --bug#3759977
399: j := j+1;

Line 444: --EXECUTE IMMEDIATE 'SELECT LEVEL' || i || ' FROM pa_rbs_mapping_rules WHERE rule_id = ' || p_rule_id INTO l_token ;

440: l_prev_token := 'NULL' ;
441: FOR i IN REVERSE 2..p_level LOOP
442: l_token:= get_level(p_rule_id,i);
443:
444: --EXECUTE IMMEDIATE 'SELECT LEVEL' || i || ' FROM pa_rbs_mapping_rules WHERE rule_id = ' || p_rule_id INTO l_token ;
445: IF substr(l_token,0,1) = 'I' AND substr(l_token,3,3) <> l_prev_token THEN
446: l_res_type_cols(j) := ' TMP.' || get_resource_type_cols(substr(l_token,3,3));
447: l_res_type_cols(j) := l_res_type_cols(j) || ' = ' || substr(l_token,7);
448: j := j+1 ;

Line 503: --EXECUTE IMMEDIATE 'SELECT LEVEL' || i || ' FROM pa_rbs_mapping_rules WHERE rule_id = ' || p_rule_id INTO l_token ;

499: j := 1 ;
500: l_prev_token := 'NULL' ;
501: FOR i IN REVERSE 2..p_level LOOP
502: l_token:= get_level(p_rule_id,i);
503: --EXECUTE IMMEDIATE 'SELECT LEVEL' || i || ' FROM pa_rbs_mapping_rules WHERE rule_id = ' || p_rule_id INTO l_token ;
504: IF substr(l_token,0,1) <> 'I' THEN
505: l_res_type_cols(j) := get_resource_type_cols(substr(l_token,3,3));
506: l_res_type_cols2(j) := 'RBS.' || get_resource_type_cols(substr(l_token,3,3)) || ' (+) = TMP.' || get_resource_type_cols(substr(l_token,3,3));
507: j := j+1 ;

Line 580: --EXECUTE IMMEDIATE 'SELECT LEVEL' || i || ' FROM pa_rbs_mapping_rules WHERE rule_id = ' || p_rule_id INTO l_token ;

576: j := 1 ;
577: FOR i IN REVERSE 2..p_level LOOP
578: l_token:= get_level(p_rule_id,i);
579:
580: --EXECUTE IMMEDIATE 'SELECT LEVEL' || i || ' FROM pa_rbs_mapping_rules WHERE rule_id = ' || p_rule_id INTO l_token ;
581: IF substr(l_token,0,1) <> 'I' THEN
582: l_res_type_cols(j) := get_resource_type_cols(substr(l_token,3,3));
583: j := j+1 ;
584: END IF;

Line 776: from pa_rbs_mapping_rules

772: FOR i IN 1..l_res_type_cols.COUNT LOOP
773: /*
774: select rbs_element_id
775: into l_rbs_element_id
776: from pa_rbs_mapping_rules
777: where rule_id = p_rule_id ;
778:
779: --bug#3642329
780: l_sql_stmt := ' SELECT ' || l_res_type_cols(i) ||

Line 1493: --EXECUTE IMMEDIATE 'SELECT LEVEL' || i || ' FROM pa_rbs_mapping_rules WHERE rule_id = :p_rule_id' INTO l_token USING p_rule_id ;

1489: FOR i IN 2..g_max_level LOOP
1490:
1491: l_token:= get_level(p_rule_id,i);
1492:
1493: --EXECUTE IMMEDIATE 'SELECT LEVEL' || i || ' FROM pa_rbs_mapping_rules WHERE rule_id = :p_rule_id' INTO l_token USING p_rule_id ;
1494: IF substr(l_token,1,1) = 'C' THEN
1495: l_res_type_cols(j) := get_resource_type_cols(substr(l_token,3));
1496: j := j+1;
1497: END IF;

Line 1714: FROM pa_rbs_mapping_rules

1710:
1711: FOR k IN 1..l_sorted_rule_id.COUNT-1 LOOP
1712: SELECT rule_flag, max_level, rbs_element_id
1713: INTO g_rule_type, g_max_level, g_rbs_element_id
1714: FROM pa_rbs_mapping_rules
1715: WHERE rule_id = l_sorted_rule_id(k);
1716:
1717: -- checking for wheteher leaf node of the rule is custom then processing for the rule would be ignored
1718: l_sql_stmt := 'SELECT level' || g_max_level ||

Line 1719: ' FROM pa_rbs_mapping_rules ' ||

1715: WHERE rule_id = l_sorted_rule_id(k);
1716:
1717: -- checking for wheteher leaf node of the rule is custom then processing for the rule would be ignored
1718: l_sql_stmt := 'SELECT level' || g_max_level ||
1719: ' FROM pa_rbs_mapping_rules ' ||
1720: ' WHERE rule_id = :rule_id' ;
1721:
1722: l_leaf_type:= get_level(l_sorted_rule_id(k),g_max_level);
1723:

Line 1797: x_msg_data := 'pa_rbs_mapping.map_rbs_actuals.' || NVL(l_msg_data, SQLERRM);

1793: EXCEPTION WHEN OTHERS THEN /* Added the exception block for bug #6377425 */
1794:
1795: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1796: x_msg_count := 1;
1797: x_msg_data := 'pa_rbs_mapping.map_rbs_actuals.' || NVL(l_msg_data, SQLERRM);
1798:
1799: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'
1800: ,p_procedure_name => 'map_rbs_txn');
1801:

Line 1799: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'

1795: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1796: x_msg_count := 1;
1797: x_msg_data := 'pa_rbs_mapping.map_rbs_actuals.' || NVL(l_msg_data, SQLERRM);
1798:
1799: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'
1800: ,p_procedure_name => 'map_rbs_txn');
1801:
1802: IF g_debug_mode = 'Y' THEN
1803: Pa_Debug.g_err_stage:='Unexpected Error inside pa_rbs_mapping.map_rbs_actuals for Structure Version ='||p_rbs_struct_version_id||' '|| NVL(l_msg_data,SQLERRM) ;

Line 1803: Pa_Debug.g_err_stage:='Unexpected Error inside pa_rbs_mapping.map_rbs_actuals for Structure Version ='||p_rbs_struct_version_id||' '|| NVL(l_msg_data,SQLERRM) ;

1799: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'
1800: ,p_procedure_name => 'map_rbs_txn');
1801:
1802: IF g_debug_mode = 'Y' THEN
1803: Pa_Debug.g_err_stage:='Unexpected Error inside pa_rbs_mapping.map_rbs_actuals for Structure Version ='||p_rbs_struct_version_id||' '|| NVL(l_msg_data,SQLERRM) ;
1804: Pa_Debug.WRITE(g_module_name, Pa_Debug.g_err_stage,5);
1805: Pa_Debug.reset_curr_function;
1806: END IF;
1807:

Line 2221: x_msg_data := 'pa_rbs_mapping.map_rbs_actuals.' || NVL(l_msg_data, SQLERRM);

2217: EXCEPTION WHEN OTHERS THEN
2218:
2219: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2220: x_msg_count := 1;
2221: x_msg_data := 'pa_rbs_mapping.map_rbs_actuals.' || NVL(l_msg_data, SQLERRM);
2222:
2223: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'
2224: ,p_procedure_name => 'map_rbs_txn');
2225:

Line 2223: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'

2219: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2220: x_msg_count := 1;
2221: x_msg_data := 'pa_rbs_mapping.map_rbs_actuals.' || NVL(l_msg_data, SQLERRM);
2222:
2223: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'
2224: ,p_procedure_name => 'map_rbs_txn');
2225:
2226: IF g_debug_mode = 'Y' THEN
2227: Pa_Debug.g_err_stage:='Unexpected Error inside pa_rbs_mapping.map_rbs_actuals for Structure Version ='||l_rbs_struct_version_id(i)||' '|| NVL(l_msg_data,SQLERRM) ;

Line 2227: Pa_Debug.g_err_stage:='Unexpected Error inside pa_rbs_mapping.map_rbs_actuals for Structure Version ='||l_rbs_struct_version_id(i)||' '|| NVL(l_msg_data,SQLERRM) ;

2223: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'
2224: ,p_procedure_name => 'map_rbs_txn');
2225:
2226: IF g_debug_mode = 'Y' THEN
2227: Pa_Debug.g_err_stage:='Unexpected Error inside pa_rbs_mapping.map_rbs_actuals for Structure Version ='||l_rbs_struct_version_id(i)||' '|| NVL(l_msg_data,SQLERRM) ;
2228: Pa_Debug.WRITE(g_module_name, Pa_Debug.g_err_stage,5);
2229: Pa_Debug.reset_curr_function;
2230: END IF;
2231:

Line 2257: x_msg_data := 'pa_rbs_mapping.map_rbs_actuals.' || nvl(l_msg_data, SQLERRM);

2253: EXCEPTION
2254: WHEN OTHERS THEN
2255: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2256: x_msg_count := 1;
2257: x_msg_data := 'pa_rbs_mapping.map_rbs_actuals.' || nvl(l_msg_data, SQLERRM);
2258: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'
2259: ,p_procedure_name => 'map_rbs_actuals');
2260:
2261: IF g_debug_mode = 'Y' THEN

Line 2258: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'

2254: WHEN OTHERS THEN
2255: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2256: x_msg_count := 1;
2257: x_msg_data := 'pa_rbs_mapping.map_rbs_actuals.' || nvl(l_msg_data, SQLERRM);
2258: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'
2259: ,p_procedure_name => 'map_rbs_actuals');
2260:
2261: IF g_debug_mode = 'Y' THEN
2262: pa_debug.g_err_stage:='Unexpected Error inside pa_rbs_mapping.map_rbs_actuals '|| nvl(l_msg_data, SQLERRM) ;

Line 2262: pa_debug.g_err_stage:='Unexpected Error inside pa_rbs_mapping.map_rbs_actuals '|| nvl(l_msg_data, SQLERRM) ;

2258: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'
2259: ,p_procedure_name => 'map_rbs_actuals');
2260:
2261: IF g_debug_mode = 'Y' THEN
2262: pa_debug.g_err_stage:='Unexpected Error inside pa_rbs_mapping.map_rbs_actuals '|| nvl(l_msg_data, SQLERRM) ;
2263: pa_debug.write(g_module_name, pa_debug.g_err_stage,5);
2264: pa_debug.reset_curr_function;
2265: END IF;
2266: raise;

Line 2430: PA_RBS_MAPPING.create_res_type_numeric_id('EMP',11,l_res_id,l_return_status,l_msg_data);

2426: BULK COLLECT
2427: INTO l_rbs_struct_version_id
2428: FROM pa_rbs_map_tmp1 ;
2429:
2430: PA_RBS_MAPPING.create_res_type_numeric_id('EMP',11,l_res_id,l_return_status,l_msg_data);
2431: PA_RBS_MAPPING.create_res_type_numeric_id('CWK',11,l_res_id,l_return_status,l_msg_data);
2432:
2433: l_worker_id := p_worker_id;
2434:

Line 2431: PA_RBS_MAPPING.create_res_type_numeric_id('CWK',11,l_res_id,l_return_status,l_msg_data);

2427: INTO l_rbs_struct_version_id
2428: FROM pa_rbs_map_tmp1 ;
2429:
2430: PA_RBS_MAPPING.create_res_type_numeric_id('EMP',11,l_res_id,l_return_status,l_msg_data);
2431: PA_RBS_MAPPING.create_res_type_numeric_id('CWK',11,l_res_id,l_return_status,l_msg_data);
2432:
2433: l_worker_id := p_worker_id;
2434:
2435: FOR i IN 1..l_rbs_struct_version_id.COUNT LOOP

Line 2443: PA_RBS_MAPPING.g_max_rbs_id1 := l_rbs_max +1;

2439: into l_rbs_max
2440: from pa_rbs_elements
2441: where rbs_version_id = l_rbs_struct_version_id(i);
2442:
2443: PA_RBS_MAPPING.g_max_rbs_id1 := l_rbs_max +1;
2444: /* Added for Bug 9099240 End */
2445:
2446: SAVEPOINT map_rbs_txn;
2447:

Line 2459: PA_RBS_MAPPING.create_res_type_numeric_id(l_revenue_category(p), 14, l_res_id,l_return_status,l_msg_data);

2455: (select resource_name from pa_rbs_element_map where
2456: resource_type_id = 14);
2457:
2458: FOR p IN 1..l_revenue_category.COUNT LOOP
2459: PA_RBS_MAPPING.create_res_type_numeric_id(l_revenue_category(p), 14, l_res_id,l_return_status,l_msg_data);
2460: END LOOP;
2461:
2462:
2463: DELETE pa_rbs_map_tmp2 ;

Line 2503: decode(head.revenue_category,'PJI$NULL',null,PA_RBS_MAPPING.get_res_type_numeric_id(head.revenue_category,14)), --- revenue category

2499: head.txn_accum_header_id,
2500: l_rbs_struct_version_id(i),
2501: decode(head.vendor_id,-1,null,head.vendor_id), --- supplier
2502: decode(head.PROJECT_ROLE_ID,-1,null, head.project_role_id), --- role
2503: decode(head.revenue_category,'PJI$NULL',null,PA_RBS_MAPPING.get_res_type_numeric_id(head.revenue_category,14)), --- revenue category
2504: decode(head.resource_class_id,-1,null,head.resource_class_id), --- resource class
2505: decode(head.non_labor_resource_id,-1,null,head.non_labor_resource_id), --- non labor resource
2506: decode(head.person_type,'PJI$NULL',null,PA_RBS_MAPPING.get_res_type_numeric_id(head.person_type,11)), --- person type
2507: decode(head.expenditure_organization_id,-1,null,head.expenditure_organization_id), --- organization

Line 2506: decode(head.person_type,'PJI$NULL',null,PA_RBS_MAPPING.get_res_type_numeric_id(head.person_type,11)), --- person type

2502: decode(head.PROJECT_ROLE_ID,-1,null, head.project_role_id), --- role
2503: decode(head.revenue_category,'PJI$NULL',null,PA_RBS_MAPPING.get_res_type_numeric_id(head.revenue_category,14)), --- revenue category
2504: decode(head.resource_class_id,-1,null,head.resource_class_id), --- resource class
2505: decode(head.non_labor_resource_id,-1,null,head.non_labor_resource_id), --- non labor resource
2506: decode(head.person_type,'PJI$NULL',null,PA_RBS_MAPPING.get_res_type_numeric_id(head.person_type,11)), --- person type
2507: decode(head.expenditure_organization_id,-1,null,head.expenditure_organization_id), --- organization
2508: decode(head.job_id,-1,null,l_job_group_id,null,head.job_id,PA_Cross_Business_Grp.IsMappedToJob(head.job_id, l_job_group_id)), --- job, bug#4027727
2509: decode(head.inventory_item_id,-1,null,head.inventory_item_id), --- inventory item
2510: decode(head.item_category_id,-1,null,head.item_category_id), --- item category

Line 2532: x_msg_data := 'pa_rbs_mapping.map_rbs_actuals.' || NVL(l_msg_data, SQLERRM);

2528: EXCEPTION WHEN OTHERS THEN
2529:
2530: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2531: x_msg_count := 1;
2532: x_msg_data := 'pa_rbs_mapping.map_rbs_actuals.' || NVL(l_msg_data, SQLERRM);
2533:
2534: -- Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'
2535: -- ,p_procedure_name => 'map_rbs_txn');
2536:

Line 2534: -- Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'

2530: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2531: x_msg_count := 1;
2532: x_msg_data := 'pa_rbs_mapping.map_rbs_actuals.' || NVL(l_msg_data, SQLERRM);
2533:
2534: -- Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'
2535: -- ,p_procedure_name => 'map_rbs_txn');
2536:
2537: -- IF g_debug_mode = 'Y' THEN
2538: -- Pa_Debug.g_err_stage:='Unexpected Error inside pa_rbs_mapping.map_rbs_actuals for Structure Version ='||l_rbs_struct_version_id(i)||' '|| NVL(l_msg_data,SQLERRM) ;

Line 2538: -- Pa_Debug.g_err_stage:='Unexpected Error inside pa_rbs_mapping.map_rbs_actuals for Structure Version ='||l_rbs_struct_version_id(i)||' '|| NVL(l_msg_data,SQLERRM) ;

2534: -- Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'
2535: -- ,p_procedure_name => 'map_rbs_txn');
2536:
2537: -- IF g_debug_mode = 'Y' THEN
2538: -- Pa_Debug.g_err_stage:='Unexpected Error inside pa_rbs_mapping.map_rbs_actuals for Structure Version ='||l_rbs_struct_version_id(i)||' '|| NVL(l_msg_data,SQLERRM) ;
2539: -- Pa_Debug.WRITE(g_module_name, Pa_Debug.g_err_stage,5);
2540: -- Pa_Debug.reset_curr_function;
2541: -- END IF;
2542:

Line 2561: x_msg_data := 'pa_rbs_mapping.map_rbs_actuals.' || nvl(l_msg_data, SQLERRM);

2557: EXCEPTION
2558: WHEN OTHERS THEN
2559: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2560: x_msg_count := 1;
2561: x_msg_data := 'pa_rbs_mapping.map_rbs_actuals.' || nvl(l_msg_data, SQLERRM);
2562: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'
2563: ,p_procedure_name => 'map_rbs_actuals');
2564:
2565: --IF g_debug_mode = 'Y' THEN

Line 2562: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'

2558: WHEN OTHERS THEN
2559: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2560: x_msg_count := 1;
2561: x_msg_data := 'pa_rbs_mapping.map_rbs_actuals.' || nvl(l_msg_data, SQLERRM);
2562: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'
2563: ,p_procedure_name => 'map_rbs_actuals');
2564:
2565: --IF g_debug_mode = 'Y' THEN
2566: -- pa_debug.g_err_stage:='Unexpected Error inside pa_rbs_mapping.map_rbs_actuals '|| nvl(l_msg_data, SQLERRM) ;

Line 2566: -- pa_debug.g_err_stage:='Unexpected Error inside pa_rbs_mapping.map_rbs_actuals '|| nvl(l_msg_data, SQLERRM) ;

2562: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'
2563: ,p_procedure_name => 'map_rbs_actuals');
2564:
2565: --IF g_debug_mode = 'Y' THEN
2566: -- pa_debug.g_err_stage:='Unexpected Error inside pa_rbs_mapping.map_rbs_actuals '|| nvl(l_msg_data, SQLERRM) ;
2567: -- pa_debug.write(g_module_name, pa_debug.g_err_stage,5);
2568: -- pa_debug.reset_curr_function;
2569: --END IF;
2570: raise;

Line 3208: x_msg_data := 'pa_rbs_mapping.map_rbs_plans.' || nvl(l_msg_data, SQLERRM) ;

3204: EXCEPTION
3205: WHEN OTHERS THEN
3206: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3207: x_msg_count := 1;
3208: x_msg_data := 'pa_rbs_mapping.map_rbs_plans.' || nvl(l_msg_data, SQLERRM) ;
3209: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'
3210: ,p_procedure_name => 'map_rbs_plans');
3211:
3212: IF g_debug_mode = 'Y' THEN

Line 3209: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'

3205: WHEN OTHERS THEN
3206: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3207: x_msg_count := 1;
3208: x_msg_data := 'pa_rbs_mapping.map_rbs_plans.' || nvl(l_msg_data, SQLERRM) ;
3209: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'
3210: ,p_procedure_name => 'map_rbs_plans');
3211:
3212: IF g_debug_mode = 'Y' THEN
3213: pa_debug.g_err_stage:='Unexpected Error inside pa_rbs_mapping.map_rbs_plans '|| nvl(l_msg_data, SQLERRM) ;

Line 3213: pa_debug.g_err_stage:='Unexpected Error inside pa_rbs_mapping.map_rbs_plans '|| nvl(l_msg_data, SQLERRM) ;

3209: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'
3210: ,p_procedure_name => 'map_rbs_plans');
3211:
3212: IF g_debug_mode = 'Y' THEN
3213: pa_debug.g_err_stage:='Unexpected Error inside pa_rbs_mapping.map_rbs_plans '|| nvl(l_msg_data, SQLERRM) ;
3214: pa_debug.write(g_module_name, pa_debug.g_err_stage,5);
3215: pa_debug.reset_curr_function;
3216: END IF;
3217: raise;

Line 3294: x_msg_data := 'pa_rbs_mapping.create_res_type_numeric_id.' || SQLERRM;

3290:
3291: EXCEPTION
3292: WHEN OTHERS THEN
3293: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3294: x_msg_data := 'pa_rbs_mapping.create_res_type_numeric_id.' || SQLERRM;
3295: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'
3296: ,p_procedure_name => 'create_res_type_numeric_id');
3297:
3298: IF g_debug_mode = 'Y' THEN

Line 3295: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'

3291: EXCEPTION
3292: WHEN OTHERS THEN
3293: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3294: x_msg_data := 'pa_rbs_mapping.create_res_type_numeric_id.' || SQLERRM;
3295: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'
3296: ,p_procedure_name => 'create_res_type_numeric_id');
3297:
3298: IF g_debug_mode = 'Y' THEN
3299: pa_debug.g_err_stage:='Unexpected Error inside pa_rbs_mapping.create_res_type_numeric_id '||SQLERRM;

Line 3299: pa_debug.g_err_stage:='Unexpected Error inside pa_rbs_mapping.create_res_type_numeric_id '||SQLERRM;

3295: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'
3296: ,p_procedure_name => 'create_res_type_numeric_id');
3297:
3298: IF g_debug_mode = 'Y' THEN
3299: pa_debug.g_err_stage:='Unexpected Error inside pa_rbs_mapping.create_res_type_numeric_id '||SQLERRM;
3300: pa_debug.write(g_module_name, pa_debug.g_err_stage,5);
3301: pa_debug.reset_curr_function;
3302: END IF;
3303: raise;

Line 3330: --insert rule into pa_rbs_mapping_rules

3326:
3327: END;
3328:
3329: ---------------------------------------------------
3330: --insert rule into pa_rbs_mapping_rules
3331: ---------------------------------------------------
3332:
3333: PROCEDURE insert_rule
3334: (

Line 3387: select PA_RBS_MAPPING_RULE_S.nextval

3383: end loop;
3384:
3385:
3386:
3387: select PA_RBS_MAPPING_RULE_S.nextval
3388: into l_rule_id
3389: from dual;
3390:
3391: -- commented select below as its not required because rule_flag in pa_rbs_elements is not null column

Line 3395: l_SQL_statement := 'INSERT INTO PA_RBS_MAPPING_RULES' ||

3391: -- commented select below as its not required because rule_flag in pa_rbs_elements is not null column
3392: -- select decode(rule_flag,null,'null',''''||rule_flag||'''') into l_rule_flag from dual ;
3393:
3394: l_rule_flag := rule_flag; --l_rule_flag is redundant, we can remove and directly use rule_flag
3395: l_SQL_statement := 'INSERT INTO PA_RBS_MAPPING_RULES' ||
3396: ' (ELEMENT_VERSION_ID, ' ||
3397: ' RULE_ID, ' ||
3398: ' RBS_ELEMENT_ID, ' ||
3399: ' RULE_FLAG, ' ||

Line 3729: from pa_rbs_mapping_rules

3725:
3726: select count(1) into l_count from dual
3727: where exists
3728: (select 1
3729: from pa_rbs_mapping_rules
3730: where element_version_id = p_rbs_version_id);
3731:
3732:
3733: IF l_count =0 THEN

Line 3838: x_msg_data := 'pa_rbs_mapping.create_mapping_rules.' || SQLERRM;

3834: EXCEPTION
3835: WHEN OTHERS THEN
3836: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3837: x_msg_count := 1;
3838: x_msg_data := 'pa_rbs_mapping.create_mapping_rules.' || SQLERRM;
3839: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'
3840: ,p_procedure_name => 'create_mapping_rules');
3841: IF g_debug_mode = 'Y' THEN
3842: pa_debug.g_err_stage:='Unexpected Error inside pa_rbs_mapping.create_mapping_rules '||SQLERRM;

Line 3839: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'

3835: WHEN OTHERS THEN
3836: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3837: x_msg_count := 1;
3838: x_msg_data := 'pa_rbs_mapping.create_mapping_rules.' || SQLERRM;
3839: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'
3840: ,p_procedure_name => 'create_mapping_rules');
3841: IF g_debug_mode = 'Y' THEN
3842: pa_debug.g_err_stage:='Unexpected Error inside pa_rbs_mapping.create_mapping_rules '||SQLERRM;
3843: pa_debug.write(g_module_name, pa_debug.g_err_stage,5);

Line 3842: pa_debug.g_err_stage:='Unexpected Error inside pa_rbs_mapping.create_mapping_rules '||SQLERRM;

3838: x_msg_data := 'pa_rbs_mapping.create_mapping_rules.' || SQLERRM;
3839: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'
3840: ,p_procedure_name => 'create_mapping_rules');
3841: IF g_debug_mode = 'Y' THEN
3842: pa_debug.g_err_stage:='Unexpected Error inside pa_rbs_mapping.create_mapping_rules '||SQLERRM;
3843: pa_debug.write(g_module_name, pa_debug.g_err_stage,5);
3844: pa_debug.reset_curr_function;
3845:
3846: END IF;

Line 3852: END; --end package pa_rbs_mapping

3848: END;
3849:
3850:
3851:
3852: END; --end package pa_rbs_mapping