APPS.PA_RBS_MAPPING dependencies on PA_DEBUG

Line 9: g_debug_mode VARCHAR2(10) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

5: --global variables
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;

Line 55: PA_DEBUG.set_curr_function( p_function => 'get_sorted_rules'

51: l_precedence PA_PLSQL_DATATYPES.Char30TabTyp;
52:
53: BEGIN
54: IF g_debug_mode = 'Y' THEN
55: PA_DEBUG.set_curr_function( p_function => 'get_sorted_rules'
56: ,p_debug_mode => g_debug_mode );
57: pa_debug.g_err_stage:= 'Inside get_sorted_rules . - p_struct_version_id : ' ||p_struct_version_id || ' - p_res_class_id: ' || p_res_class_id ;
58: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
59: END IF;

Line 57: pa_debug.g_err_stage:= 'Inside get_sorted_rules . - p_struct_version_id : ' ||p_struct_version_id || ' - p_res_class_id: ' || p_res_class_id ;

53: BEGIN
54: IF g_debug_mode = 'Y' THEN
55: PA_DEBUG.set_curr_function( p_function => 'get_sorted_rules'
56: ,p_debug_mode => g_debug_mode );
57: pa_debug.g_err_stage:= 'Inside get_sorted_rules . - p_struct_version_id : ' ||p_struct_version_id || ' - p_res_class_id: ' || p_res_class_id ;
58: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
59: END IF;
60:
61: PA_RBS_PREC_PUB.g_rbs_version_id := p_struct_version_id; -- cbs change

Line 58: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

54: IF g_debug_mode = 'Y' THEN
55: PA_DEBUG.set_curr_function( p_function => 'get_sorted_rules'
56: ,p_debug_mode => g_debug_mode );
57: pa_debug.g_err_stage:= 'Inside get_sorted_rules . - p_struct_version_id : ' ||p_struct_version_id || ' - p_res_class_id: ' || p_res_class_id ;
58: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
59: END IF;
60:
61: PA_RBS_PREC_PUB.g_rbs_version_id := p_struct_version_id; -- cbs change
62:

Line 106: pa_debug.g_err_stage:= 'Exiting get_sorted_rules' ;

102: decode(substr(level3,1,1),'I',2,'R',1,0) desc,
103: decode(substr(level2,1,1),'I',2,'R',1,0) desc;
104:
105: IF g_debug_mode = 'Y' THEN
106: pa_debug.g_err_stage:= 'Exiting get_sorted_rules' ;
107: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
108: pa_debug.reset_curr_function;
109: END IF;
110: RETURN l_sorted_rules ;

Line 107: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

103: decode(substr(level2,1,1),'I',2,'R',1,0) desc;
104:
105: IF g_debug_mode = 'Y' THEN
106: pa_debug.g_err_stage:= 'Exiting get_sorted_rules' ;
107: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
108: pa_debug.reset_curr_function;
109: END IF;
110: RETURN l_sorted_rules ;
111: END ;

Line 108: pa_debug.reset_curr_function;

104:
105: IF g_debug_mode = 'Y' THEN
106: pa_debug.g_err_stage:= 'Exiting get_sorted_rules' ;
107: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
108: pa_debug.reset_curr_function;
109: END IF;
110: RETURN l_sorted_rules ;
111: END ;
112:

Line 257: PA_DEBUG.set_curr_function( p_function => 'get_level'

253:
254:
255: BEGIN
256: IF g_debug_mode = 'Y' THEN
257: PA_DEBUG.set_curr_function( p_function => 'get_level'
258: ,p_debug_mode => g_debug_mode );
259: pa_debug.g_err_stage:= 'Inside get_level : - p_rule_id: ' || p_rule_id || ' - p_level :' || p_level ;
260: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
261: END IF;

Line 259: pa_debug.g_err_stage:= 'Inside get_level : - p_rule_id: ' || p_rule_id || ' - p_level :' || p_level ;

255: BEGIN
256: IF g_debug_mode = 'Y' THEN
257: PA_DEBUG.set_curr_function( p_function => 'get_level'
258: ,p_debug_mode => g_debug_mode );
259: pa_debug.g_err_stage:= 'Inside get_level : - p_rule_id: ' || p_rule_id || ' - p_level :' || p_level ;
260: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
261: END IF;
262:
263: CASE p_level

Line 260: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

256: IF g_debug_mode = 'Y' THEN
257: PA_DEBUG.set_curr_function( p_function => 'get_level'
258: ,p_debug_mode => g_debug_mode );
259: pa_debug.g_err_stage:= 'Inside get_level : - p_rule_id: ' || p_rule_id || ' - p_level :' || p_level ;
260: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
261: END IF;
262:
263: CASE p_level
264: WHEN 1 THEN

Line 300: pa_debug.g_err_stage:= 'Exiting get_level - l_level :' || l_value ;

296: END CASE;
297:
298:
299: IF g_debug_mode = 'Y' THEN
300: pa_debug.g_err_stage:= 'Exiting get_level - l_level :' || l_value ;
301: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
302: pa_debug.reset_curr_function;
303: END IF;
304: RETURN l_value;

Line 301: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

297:
298:
299: IF g_debug_mode = 'Y' THEN
300: pa_debug.g_err_stage:= 'Exiting get_level - l_level :' || l_value ;
301: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
302: pa_debug.reset_curr_function;
303: END IF;
304: RETURN l_value;
305: END;

Line 302: pa_debug.reset_curr_function;

298:
299: IF g_debug_mode = 'Y' THEN
300: pa_debug.g_err_stage:= 'Exiting get_level - l_level :' || l_value ;
301: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
302: pa_debug.reset_curr_function;
303: END IF;
304: RETURN l_value;
305: END;
306:

Line 319: PA_DEBUG.set_curr_function( p_function => 'Delete Tmp Tables'

315: IS
316:
317: BEGIN
318: IF g_debug_mode = 'Y' THEN
319: PA_DEBUG.set_curr_function( p_function => 'Delete Tmp Tables'
320: ,p_debug_mode => g_debug_mode );
321: pa_debug.g_err_stage:= 'Inside Delete Tmp Tables - p_max_level : '|| p_max_level;
322: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
323: END IF;

Line 321: pa_debug.g_err_stage:= 'Inside Delete Tmp Tables - p_max_level : '|| p_max_level;

317: BEGIN
318: IF g_debug_mode = 'Y' THEN
319: PA_DEBUG.set_curr_function( p_function => 'Delete Tmp Tables'
320: ,p_debug_mode => g_debug_mode );
321: pa_debug.g_err_stage:= 'Inside Delete Tmp Tables - p_max_level : '|| p_max_level;
322: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
323: END IF;
324:
325: FOR l IN 3..p_max_level+3 LOOP

Line 322: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

318: IF g_debug_mode = 'Y' THEN
319: PA_DEBUG.set_curr_function( p_function => 'Delete Tmp Tables'
320: ,p_debug_mode => g_debug_mode );
321: pa_debug.g_err_stage:= 'Inside Delete Tmp Tables - p_max_level : '|| p_max_level;
322: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
323: END IF;
324:
325: FOR l IN 3..p_max_level+3 LOOP
326: CASE l

Line 361: pa_debug.g_err_stage:= 'Exiting Delete Tmp Tables' ;

357:
358:
359:
360: IF g_debug_mode = 'Y' THEN
361: pa_debug.g_err_stage:= 'Exiting Delete Tmp Tables' ;
362: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
363: pa_debug.reset_curr_function;
364: END IF;
365: END;

Line 362: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

358:
359:
360: IF g_debug_mode = 'Y' THEN
361: pa_debug.g_err_stage:= 'Exiting Delete Tmp Tables' ;
362: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
363: pa_debug.reset_curr_function;
364: END IF;
365: END;
366:

Line 363: pa_debug.reset_curr_function;

359:
360: IF g_debug_mode = 'Y' THEN
361: pa_debug.g_err_stage:= 'Exiting Delete Tmp Tables' ;
362: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
363: pa_debug.reset_curr_function;
364: END IF;
365: END;
366:
367: ---------------------------------------------

Line 385: PA_DEBUG.set_curr_function( p_function => 'get_res_type_cols'

381: j NUMBER;
382:
383: BEGIN
384: IF g_debug_mode = 'Y' THEN
385: PA_DEBUG.set_curr_function( p_function => 'get_res_type_cols'
386: ,p_debug_mode => g_debug_mode );
387: pa_debug.g_err_stage:= 'Inside get_res_type_cols';
388: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
389: END IF;

Line 387: pa_debug.g_err_stage:= 'Inside get_res_type_cols';

383: BEGIN
384: IF g_debug_mode = 'Y' THEN
385: PA_DEBUG.set_curr_function( p_function => 'get_res_type_cols'
386: ,p_debug_mode => g_debug_mode );
387: pa_debug.g_err_stage:= 'Inside get_res_type_cols';
388: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
389: END IF;
390:
391:

Line 388: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

384: IF g_debug_mode = 'Y' THEN
385: PA_DEBUG.set_curr_function( p_function => 'get_res_type_cols'
386: ,p_debug_mode => g_debug_mode );
387: pa_debug.g_err_stage:= 'Inside get_res_type_cols';
388: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
389: END IF;
390:
391:
392: j := 1;

Line 404: pa_debug.g_err_stage:= 'Exiting get_res_type_cols' ;

400: --END IF;
401:
402: END LOOP;
403: IF g_debug_mode = 'Y' THEN
404: pa_debug.g_err_stage:= 'Exiting get_res_type_cols' ;
405: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
406: pa_debug.reset_curr_function;
407: END IF;
408: RETURN l_res_type_cols ;

Line 405: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

401:
402: END LOOP;
403: IF g_debug_mode = 'Y' THEN
404: pa_debug.g_err_stage:= 'Exiting get_res_type_cols' ;
405: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
406: pa_debug.reset_curr_function;
407: END IF;
408: RETURN l_res_type_cols ;
409: END ;

Line 406: pa_debug.reset_curr_function;

402: END LOOP;
403: IF g_debug_mode = 'Y' THEN
404: pa_debug.g_err_stage:= 'Exiting get_res_type_cols' ;
405: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
406: pa_debug.reset_curr_function;
407: END IF;
408: RETURN l_res_type_cols ;
409: END ;
410:

Line 433: PA_DEBUG.set_curr_function( p_function => 'get_res_type_cols_inst'

429: l_prev_token VARCHAR2(30);
430:
431: BEGIN
432: IF g_debug_mode = 'Y' THEN
433: PA_DEBUG.set_curr_function( p_function => 'get_res_type_cols_inst'
434: ,p_debug_mode => g_debug_mode );
435: pa_debug.g_err_stage:= 'Inside get_res_type_cols_inst';
436: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
437: END IF;

Line 435: pa_debug.g_err_stage:= 'Inside get_res_type_cols_inst';

431: BEGIN
432: IF g_debug_mode = 'Y' THEN
433: PA_DEBUG.set_curr_function( p_function => 'get_res_type_cols_inst'
434: ,p_debug_mode => g_debug_mode );
435: pa_debug.g_err_stage:= 'Inside get_res_type_cols_inst';
436: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
437: END IF;
438:
439: j := 1 ;

Line 436: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

432: IF g_debug_mode = 'Y' THEN
433: PA_DEBUG.set_curr_function( p_function => 'get_res_type_cols_inst'
434: ,p_debug_mode => g_debug_mode );
435: pa_debug.g_err_stage:= 'Inside get_res_type_cols_inst';
436: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
437: END IF;
438:
439: j := 1 ;
440: l_prev_token := 'NULL' ;

Line 455: pa_debug.g_err_stage:= 'Exiting get_res_type_cols_inst' ;

451: END LOOP;
452:
453:
454: IF g_debug_mode = 'Y' THEN
455: pa_debug.g_err_stage:= 'Exiting get_res_type_cols_inst' ;
456: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
457: pa_debug.reset_curr_function;
458: END IF;
459:

Line 456: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

452:
453:
454: IF g_debug_mode = 'Y' THEN
455: pa_debug.g_err_stage:= 'Exiting get_res_type_cols_inst' ;
456: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
457: pa_debug.reset_curr_function;
458: END IF;
459:
460: RETURN l_res_type_cols ;

Line 457: pa_debug.reset_curr_function;

453:
454: IF g_debug_mode = 'Y' THEN
455: pa_debug.g_err_stage:= 'Exiting get_res_type_cols_inst' ;
456: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
457: pa_debug.reset_curr_function;
458: END IF;
459:
460: RETURN l_res_type_cols ;
461: END;

Line 493: PA_DEBUG.set_curr_function( p_function => 'get_sql_clause_unmap'

489: l_sql_clause VARCHAR2 (1000);
490:
491: BEGIN
492: IF g_debug_mode = 'Y' THEN
493: PA_DEBUG.set_curr_function( p_function => 'get_sql_clause_unmap'
494: ,p_debug_mode => g_debug_mode );
495: pa_debug.g_err_stage:= 'Inside get_sql_clause_unmap - p_operation_type :'|| p_operation_type;
496: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
497: END IF;

Line 495: pa_debug.g_err_stage:= 'Inside get_sql_clause_unmap - p_operation_type :'|| p_operation_type;

491: BEGIN
492: IF g_debug_mode = 'Y' THEN
493: PA_DEBUG.set_curr_function( p_function => 'get_sql_clause_unmap'
494: ,p_debug_mode => g_debug_mode );
495: pa_debug.g_err_stage:= 'Inside get_sql_clause_unmap - p_operation_type :'|| p_operation_type;
496: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
497: END IF;
498:
499: j := 1 ;

Line 496: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

492: IF g_debug_mode = 'Y' THEN
493: PA_DEBUG.set_curr_function( p_function => 'get_sql_clause_unmap'
494: ,p_debug_mode => g_debug_mode );
495: pa_debug.g_err_stage:= 'Inside get_sql_clause_unmap - p_operation_type :'|| p_operation_type;
496: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
497: END IF;
498:
499: j := 1 ;
500: l_prev_token := 'NULL' ;

Line 542: pa_debug.g_err_stage:= 'Exiting get_sql_clause_unmap - l_sql_clause : ' || l_sql_clause;

538: l_sql_clause := ' 1 = 1 ' ;
539: END IF;
540:
541: IF g_debug_mode = 'Y' THEN
542: pa_debug.g_err_stage:= 'Exiting get_sql_clause_unmap - l_sql_clause : ' || l_sql_clause;
543: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
544: pa_debug.reset_curr_function;
545: END IF;
546:

Line 543: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

539: END IF;
540:
541: IF g_debug_mode = 'Y' THEN
542: pa_debug.g_err_stage:= 'Exiting get_sql_clause_unmap - l_sql_clause : ' || l_sql_clause;
543: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
544: pa_debug.reset_curr_function;
545: END IF;
546:
547: RETURN l_sql_clause ;

Line 544: pa_debug.reset_curr_function;

540:
541: IF g_debug_mode = 'Y' THEN
542: pa_debug.g_err_stage:= 'Exiting get_sql_clause_unmap - l_sql_clause : ' || l_sql_clause;
543: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
544: pa_debug.reset_curr_function;
545: END IF;
546:
547: RETURN l_sql_clause ;
548: END;

Line 570: PA_DEBUG.set_curr_function( p_function => 'get_sql_clause_rule'

566: l_sql_clause VARCHAR2 (1000);
567:
568: BEGIN
569: IF g_debug_mode = 'Y' THEN
570: PA_DEBUG.set_curr_function( p_function => 'get_sql_clause_rule'
571: ,p_debug_mode => g_debug_mode );
572: pa_debug.g_err_stage:= 'Inside get_sql_clause_rule - p_operation_type :'|| p_operation_type;
573: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
574: END IF;

Line 572: pa_debug.g_err_stage:= 'Inside get_sql_clause_rule - p_operation_type :'|| p_operation_type;

568: BEGIN
569: IF g_debug_mode = 'Y' THEN
570: PA_DEBUG.set_curr_function( p_function => 'get_sql_clause_rule'
571: ,p_debug_mode => g_debug_mode );
572: pa_debug.g_err_stage:= 'Inside get_sql_clause_rule - p_operation_type :'|| p_operation_type;
573: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
574: END IF;
575:
576: j := 1 ;

Line 573: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

569: IF g_debug_mode = 'Y' THEN
570: PA_DEBUG.set_curr_function( p_function => 'get_sql_clause_rule'
571: ,p_debug_mode => g_debug_mode );
572: pa_debug.g_err_stage:= 'Inside get_sql_clause_rule - p_operation_type :'|| p_operation_type;
573: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
574: END IF;
575:
576: j := 1 ;
577: FOR i IN REVERSE 2..p_level LOOP

Line 603: pa_debug.g_err_stage:= 'Exiting get_sql_clause_rule- l_sql_clause : ' || l_sql_clause;

599: l_sql_clause := ' 1=1 ';
600: END IF;
601:
602: IF g_debug_mode = 'Y' THEN
603: pa_debug.g_err_stage:= 'Exiting get_sql_clause_rule- l_sql_clause : ' || l_sql_clause;
604: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
605: pa_debug.reset_curr_function;
606: END IF;
607:

Line 604: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

600: END IF;
601:
602: IF g_debug_mode = 'Y' THEN
603: pa_debug.g_err_stage:= 'Exiting get_sql_clause_rule- l_sql_clause : ' || l_sql_clause;
604: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
605: pa_debug.reset_curr_function;
606: END IF;
607:
608: RETURN l_sql_clause ;

Line 605: pa_debug.reset_curr_function;

601:
602: IF g_debug_mode = 'Y' THEN
603: pa_debug.g_err_stage:= 'Exiting get_sql_clause_rule- l_sql_clause : ' || l_sql_clause;
604: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
605: pa_debug.reset_curr_function;
606: END IF;
607:
608: RETURN l_sql_clause ;
609: END;

Line 635: PA_DEBUG.set_curr_function( p_function => 'get_sql_clause'

631: l_prev_res_col VARCHAR2 (240);
632:
633: BEGIN
634: IF g_debug_mode = 'Y' THEN
635: PA_DEBUG.set_curr_function( p_function => 'get_sql_clause'
636: ,p_debug_mode => g_debug_mode );
637: pa_debug.g_err_stage:= 'Inside get_sql_clause - p_operation_type:'|| p_operation_type;
638: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
639: END IF;

Line 637: pa_debug.g_err_stage:= 'Inside get_sql_clause - p_operation_type:'|| p_operation_type;

633: BEGIN
634: IF g_debug_mode = 'Y' THEN
635: PA_DEBUG.set_curr_function( p_function => 'get_sql_clause'
636: ,p_debug_mode => g_debug_mode );
637: pa_debug.g_err_stage:= 'Inside get_sql_clause - p_operation_type:'|| p_operation_type;
638: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
639: END IF;
640:
641: -- implement caching, bug#3995697

Line 638: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

634: IF g_debug_mode = 'Y' THEN
635: PA_DEBUG.set_curr_function( p_function => 'get_sql_clause'
636: ,p_debug_mode => g_debug_mode );
637: pa_debug.g_err_stage:= 'Inside get_sql_clause - p_operation_type:'|| p_operation_type;
638: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
639: END IF;
640:
641: -- implement caching, bug#3995697
642: IF p_rule_id = g_rule_id AND g_res_type_cols_flag IS NOT NULL THEN

Line 730: pa_debug.g_err_stage:= 'Exiting get_sql_clause - l_sql_clause' || l_sql_clause;

726: IF p_level = 1 AND ( p_operation_type = 'EQUAL' OR p_operation_type = 'EQUAL2') THEN
727: l_sql_clause := ' 1 = 1 ' ;
728: END IF;
729: IF g_debug_mode = 'Y' THEN
730: pa_debug.g_err_stage:= 'Exiting get_sql_clause - l_sql_clause' || l_sql_clause;
731: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
732: pa_debug.reset_curr_function;
733: END IF;
734: RETURN l_sql_clause;

Line 731: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

727: l_sql_clause := ' 1 = 1 ' ;
728: END IF;
729: IF g_debug_mode = 'Y' THEN
730: pa_debug.g_err_stage:= 'Exiting get_sql_clause - l_sql_clause' || l_sql_clause;
731: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
732: pa_debug.reset_curr_function;
733: END IF;
734: RETURN l_sql_clause;
735: END;

Line 732: pa_debug.reset_curr_function;

728: END IF;
729: IF g_debug_mode = 'Y' THEN
730: pa_debug.g_err_stage:= 'Exiting get_sql_clause - l_sql_clause' || l_sql_clause;
731: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
732: pa_debug.reset_curr_function;
733: END IF;
734: RETURN l_sql_clause;
735: END;
736:

Line 763: PA_DEBUG.set_curr_function( p_function => 'get_sql_clause_inst'

759: l_rbs_element_id NUMBER;
760:
761: BEGIN
762: IF g_debug_mode = 'Y' THEN
763: PA_DEBUG.set_curr_function( p_function => 'get_sql_clause_inst'
764: ,p_debug_mode => g_debug_mode );
765: pa_debug.g_err_stage:= 'Inside get_sql_clause_inst- p_struct_version_id :'|| p_struct_version_id || ' p_level: ' || p_level;
766: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
767: END IF;

Line 765: pa_debug.g_err_stage:= 'Inside get_sql_clause_inst- p_struct_version_id :'|| p_struct_version_id || ' p_level: ' || p_level;

761: BEGIN
762: IF g_debug_mode = 'Y' THEN
763: PA_DEBUG.set_curr_function( p_function => 'get_sql_clause_inst'
764: ,p_debug_mode => g_debug_mode );
765: pa_debug.g_err_stage:= 'Inside get_sql_clause_inst- p_struct_version_id :'|| p_struct_version_id || ' p_level: ' || p_level;
766: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
767: END IF;
768:
769: l_res_type_cols := get_res_type_cols_inst(p_rule_id, p_level);

Line 766: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

762: IF g_debug_mode = 'Y' THEN
763: PA_DEBUG.set_curr_function( p_function => 'get_sql_clause_inst'
764: ,p_debug_mode => g_debug_mode );
765: pa_debug.g_err_stage:= 'Inside get_sql_clause_inst- p_struct_version_id :'|| p_struct_version_id || ' p_level: ' || p_level;
766: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
767: END IF;
768:
769: l_res_type_cols := get_res_type_cols_inst(p_rule_id, p_level);
770: l_sql_clause := '';

Line 802: pa_debug.g_err_stage:= 'Exiting get_sql_clause_inst - l_sql_clause' || l_sql_clause;

798: IF p_level = 1 or l_sql_clause is null THEN --bug#3749017
799: l_sql_clause := ' 1 = 1 ' ;
800: END IF;
801: IF g_debug_mode = 'Y' THEN
802: pa_debug.g_err_stage:= 'Exiting get_sql_clause_inst - l_sql_clause' || l_sql_clause;
803: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
804: pa_debug.reset_curr_function;
805: END IF;
806: RETURN l_sql_clause;

Line 803: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

799: l_sql_clause := ' 1 = 1 ' ;
800: END IF;
801: IF g_debug_mode = 'Y' THEN
802: pa_debug.g_err_stage:= 'Exiting get_sql_clause_inst - l_sql_clause' || l_sql_clause;
803: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
804: pa_debug.reset_curr_function;
805: END IF;
806: RETURN l_sql_clause;
807: END;

Line 804: pa_debug.reset_curr_function;

800: END IF;
801: IF g_debug_mode = 'Y' THEN
802: pa_debug.g_err_stage:= 'Exiting get_sql_clause_inst - l_sql_clause' || l_sql_clause;
803: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
804: pa_debug.reset_curr_function;
805: END IF;
806: RETURN l_sql_clause;
807: END;
808:

Line 864: PA_DEBUG.set_curr_function( p_function => 'mapped_header'

860: --bug#3995697 l_rule_type VARCHAR2 (1);
861:
862: BEGIN
863: IF g_debug_mode = 'Y' THEN
864: PA_DEBUG.set_curr_function( p_function => 'mapped_header'
865: ,p_debug_mode => g_debug_mode );
866: pa_debug.g_err_stage:= 'Inside mapped_header- p_struct_version_id :'|| p_struct_version_id || ' p_level: ' || p_level || ' p_res_class_id:'||p_res_class_id||' p_rule_id:'||p_rule_id;
867: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
868: END IF;

Line 866: pa_debug.g_err_stage:= 'Inside mapped_header- p_struct_version_id :'|| p_struct_version_id || ' p_level: ' || p_level || ' p_res_class_id:'||p_res_class_id||' p_rule_id:'||p_rule_id;

862: BEGIN
863: IF g_debug_mode = 'Y' THEN
864: PA_DEBUG.set_curr_function( p_function => 'mapped_header'
865: ,p_debug_mode => g_debug_mode );
866: pa_debug.g_err_stage:= 'Inside mapped_header- p_struct_version_id :'|| p_struct_version_id || ' p_level: ' || p_level || ' p_res_class_id:'||p_res_class_id||' p_rule_id:'||p_rule_id;
867: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
868: END IF;
869:
870:

Line 867: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

863: IF g_debug_mode = 'Y' THEN
864: PA_DEBUG.set_curr_function( p_function => 'mapped_header'
865: ,p_debug_mode => g_debug_mode );
866: pa_debug.g_err_stage:= 'Inside mapped_header- p_struct_version_id :'|| p_struct_version_id || ' p_level: ' || p_level || ' p_res_class_id:'||p_res_class_id||' p_rule_id:'||p_rule_id;
867: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
868: END IF;
869:
870:
871: x_return_status := 0;

Line 944: pa_debug.g_err_stage:= 'Exiting mapped_header- Inserts in pa_rbs_map_tmp :'||SQL%ROWCOUNT ;

940: END IF;
941:
942:
943: IF g_debug_mode = 'Y' THEN
944: pa_debug.g_err_stage:= 'Exiting mapped_header- Inserts in pa_rbs_map_tmp :'||SQL%ROWCOUNT ;
945: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
946: pa_debug.reset_curr_function;
947: END IF;
948: END;

Line 945: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

941:
942:
943: IF g_debug_mode = 'Y' THEN
944: pa_debug.g_err_stage:= 'Exiting mapped_header- Inserts in pa_rbs_map_tmp :'||SQL%ROWCOUNT ;
945: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
946: pa_debug.reset_curr_function;
947: END IF;
948: END;
949:

Line 946: pa_debug.reset_curr_function;

942:
943: IF g_debug_mode = 'Y' THEN
944: pa_debug.g_err_stage:= 'Exiting mapped_header- Inserts in pa_rbs_map_tmp :'||SQL%ROWCOUNT ;
945: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
946: pa_debug.reset_curr_function;
947: END IF;
948: END;
949:
950: --------------------------------------------------------

Line 975: PA_DEBUG.set_curr_function( p_function => 'unmapped_header'

971: --bug#3995697 l_rule_type VARCHAR2 (1);
972:
973: BEGIN
974: IF g_debug_mode = 'Y' THEN
975: PA_DEBUG.set_curr_function( p_function => 'unmapped_header'
976: ,p_debug_mode => g_debug_mode );
977: pa_debug.g_err_stage:= 'Inside unmapped_header- p_struct_version_id :'|| p_struct_version_id || ' p_level: ' || p_level || ' p_counter:'||p_counter;
978: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
979: END IF;

Line 977: pa_debug.g_err_stage:= 'Inside unmapped_header- p_struct_version_id :'|| p_struct_version_id || ' p_level: ' || p_level || ' p_counter:'||p_counter;

973: BEGIN
974: IF g_debug_mode = 'Y' THEN
975: PA_DEBUG.set_curr_function( p_function => 'unmapped_header'
976: ,p_debug_mode => g_debug_mode );
977: pa_debug.g_err_stage:= 'Inside unmapped_header- p_struct_version_id :'|| p_struct_version_id || ' p_level: ' || p_level || ' p_counter:'||p_counter;
978: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
979: END IF;
980:
981: l_tmp := 3 + p_counter ;

Line 978: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

974: IF g_debug_mode = 'Y' THEN
975: PA_DEBUG.set_curr_function( p_function => 'unmapped_header'
976: ,p_debug_mode => g_debug_mode );
977: pa_debug.g_err_stage:= 'Inside unmapped_header- p_struct_version_id :'|| p_struct_version_id || ' p_level: ' || p_level || ' p_counter:'||p_counter;
978: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
979: END IF;
980:
981: l_tmp := 3 + p_counter ;
982:

Line 1042: pa_debug.g_err_stage:= 'Exiting unmapped_header- Inserts in pa_rbs_map_tmp :'||SQL%ROWCOUNT ;

1038: EXECUTE IMMEDIATE 'BEGIN ' ||l_SQL_statement || ' END;' USING p_struct_version_id, l_tmp;
1039:
1040:
1041: IF g_debug_mode = 'Y' THEN
1042: pa_debug.g_err_stage:= 'Exiting unmapped_header- Inserts in pa_rbs_map_tmp :'||SQL%ROWCOUNT ;
1043: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1044: pa_debug.reset_curr_function;
1045: END IF;
1046:

Line 1043: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

1039:
1040:
1041: IF g_debug_mode = 'Y' THEN
1042: pa_debug.g_err_stage:= 'Exiting unmapped_header- Inserts in pa_rbs_map_tmp :'||SQL%ROWCOUNT ;
1043: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1044: pa_debug.reset_curr_function;
1045: END IF;
1046:
1047:

Line 1044: pa_debug.reset_curr_function;

1040:
1041: IF g_debug_mode = 'Y' THEN
1042: pa_debug.g_err_stage:= 'Exiting unmapped_header- Inserts in pa_rbs_map_tmp :'||SQL%ROWCOUNT ;
1043: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1044: pa_debug.reset_curr_function;
1045: END IF;
1046:
1047:
1048: END;

Line 1074: PA_DEBUG.set_curr_function( p_function => 'unmapped_header_laststep'

1070: l_temp NUMBER;
1071: BEGIN
1072:
1073: IF g_debug_mode = 'Y' THEN
1074: PA_DEBUG.set_curr_function( p_function => 'unmapped_header_laststep'
1075: ,p_debug_mode => g_debug_mode );
1076: pa_debug.g_err_stage:= 'Inside unmapped_header_laststep- p_struct_version_id :'|| p_struct_version_id || ' p_level: ' || p_level || ' p_rule_id:'||p_rule_id;
1077: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1078: END IF;

Line 1076: pa_debug.g_err_stage:= 'Inside unmapped_header_laststep- p_struct_version_id :'|| p_struct_version_id || ' p_level: ' || p_level || ' p_rule_id:'||p_rule_id;

1072:
1073: IF g_debug_mode = 'Y' THEN
1074: PA_DEBUG.set_curr_function( p_function => 'unmapped_header_laststep'
1075: ,p_debug_mode => g_debug_mode );
1076: pa_debug.g_err_stage:= 'Inside unmapped_header_laststep- p_struct_version_id :'|| p_struct_version_id || ' p_level: ' || p_level || ' p_rule_id:'||p_rule_id;
1077: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1078: END IF;
1079:
1080: l_temp := 3+p_level ;

Line 1077: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

1073: IF g_debug_mode = 'Y' THEN
1074: PA_DEBUG.set_curr_function( p_function => 'unmapped_header_laststep'
1075: ,p_debug_mode => g_debug_mode );
1076: pa_debug.g_err_stage:= 'Inside unmapped_header_laststep- p_struct_version_id :'|| p_struct_version_id || ' p_level: ' || p_level || ' p_rule_id:'||p_rule_id;
1077: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1078: END IF;
1079:
1080: l_temp := 3+p_level ;
1081: --EXECUTE IMMEDIATE 'DELETE pa_rbs_map_tmp' || l_temp;

Line 1112: pa_debug.g_err_stage:= 'Exiting unmapped_header_laststep- Inserts in pa_rbs_map_tmp :'||SQL%ROWCOUNT ;

1108: EXECUTE IMMEDIATE 'BEGIN ' ||l_SQL_statement || ' END;' USING p_struct_version_id;
1109:
1110:
1111: IF g_debug_mode = 'Y' THEN
1112: pa_debug.g_err_stage:= 'Exiting unmapped_header_laststep- Inserts in pa_rbs_map_tmp :'||SQL%ROWCOUNT ;
1113: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1114: pa_debug.reset_curr_function;
1115: END IF;
1116:

Line 1113: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

1109:
1110:
1111: IF g_debug_mode = 'Y' THEN
1112: pa_debug.g_err_stage:= 'Exiting unmapped_header_laststep- Inserts in pa_rbs_map_tmp :'||SQL%ROWCOUNT ;
1113: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1114: pa_debug.reset_curr_function;
1115: END IF;
1116:
1117:

Line 1114: pa_debug.reset_curr_function;

1110:
1111: IF g_debug_mode = 'Y' THEN
1112: pa_debug.g_err_stage:= 'Exiting unmapped_header_laststep- Inserts in pa_rbs_map_tmp :'||SQL%ROWCOUNT ;
1113: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1114: pa_debug.reset_curr_function;
1115: END IF;
1116:
1117:
1118:

Line 1147: PA_DEBUG.set_curr_function( p_function => 'create_top_rbs_element'

1143: x_return_status Varchar2(30);
1144:
1145: BEGIN
1146: IF g_debug_mode = 'Y' THEN
1147: PA_DEBUG.set_curr_function( p_function => 'create_top_rbs_element'
1148: ,p_debug_mode => g_debug_mode );
1149: pa_debug.g_err_stage:= 'Inside create_top_rbs_element';
1150: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1151: END IF;

Line 1149: pa_debug.g_err_stage:= 'Inside create_top_rbs_element';

1145: BEGIN
1146: IF g_debug_mode = 'Y' THEN
1147: PA_DEBUG.set_curr_function( p_function => 'create_top_rbs_element'
1148: ,p_debug_mode => g_debug_mode );
1149: pa_debug.g_err_stage:= 'Inside create_top_rbs_element';
1150: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1151: END IF;
1152:
1153: PA_RBS_UTILS.Populate_RBS_Element_Name(p_struct_version_id,-1,x_rbs_element_name_id,x_return_status);

Line 1150: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

1146: IF g_debug_mode = 'Y' THEN
1147: PA_DEBUG.set_curr_function( p_function => 'create_top_rbs_element'
1148: ,p_debug_mode => g_debug_mode );
1149: pa_debug.g_err_stage:= 'Inside create_top_rbs_element';
1150: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1151: END IF;
1152:
1153: PA_RBS_UTILS.Populate_RBS_Element_Name(p_struct_version_id,-1,x_rbs_element_name_id,x_return_status);
1154:

Line 1208: pa_debug.g_err_stage:= 'Exiting create_top_rbs_element- Inserts in pa_rbs_elements :'||SQL%ROWCOUNT ;

1204:
1205:
1206:
1207: IF g_debug_mode = 'Y' THEN
1208: pa_debug.g_err_stage:= 'Exiting create_top_rbs_element- Inserts in pa_rbs_elements :'||SQL%ROWCOUNT ;
1209: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1210: pa_debug.reset_curr_function;
1211: END IF;
1212:

Line 1209: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

1205:
1206:
1207: IF g_debug_mode = 'Y' THEN
1208: pa_debug.g_err_stage:= 'Exiting create_top_rbs_element- Inserts in pa_rbs_elements :'||SQL%ROWCOUNT ;
1209: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1210: pa_debug.reset_curr_function;
1211: END IF;
1212:
1213:

Line 1210: pa_debug.reset_curr_function;

1206:
1207: IF g_debug_mode = 'Y' THEN
1208: pa_debug.g_err_stage:= 'Exiting create_top_rbs_element- Inserts in pa_rbs_elements :'||SQL%ROWCOUNT ;
1209: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1210: pa_debug.reset_curr_function;
1211: END IF;
1212:
1213:
1214: END ;

Line 1249: PA_DEBUG.set_curr_function( p_function => 'create_rbs_element'

1245: x_msg_count NUMBER;
1246: x_error_msg_data Varchar2(500);
1247: BEGIN
1248: IF g_debug_mode = 'Y' THEN
1249: PA_DEBUG.set_curr_function( p_function => 'create_rbs_element'
1250: ,p_debug_mode => g_debug_mode );
1251: pa_debug.g_err_stage:= 'Inside create_rbs_element';
1252: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1253: END IF;

Line 1251: pa_debug.g_err_stage:= 'Inside create_rbs_element';

1247: BEGIN
1248: IF g_debug_mode = 'Y' THEN
1249: PA_DEBUG.set_curr_function( p_function => 'create_rbs_element'
1250: ,p_debug_mode => g_debug_mode );
1251: pa_debug.g_err_stage:= 'Inside create_rbs_element';
1252: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1253: END IF;
1254:
1255: -- to get element_names start here

Line 1252: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

1248: IF g_debug_mode = 'Y' THEN
1249: PA_DEBUG.set_curr_function( p_function => 'create_rbs_element'
1250: ,p_debug_mode => g_debug_mode );
1251: pa_debug.g_err_stage:= 'Inside create_rbs_element';
1252: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1253: END IF;
1254:
1255: -- to get element_names start here
1256: delete pa_rbs_elem_in_temp;

Line 1359: pa_debug.g_err_stage:= 'Exiting create_rbs_element- Inserts in pa_rbs_elements :'||SQL%ROWCOUNT ;

1355:
1356: g_denorm_refresh := 'Y';
1357:
1358: IF g_debug_mode = 'Y' THEN
1359: pa_debug.g_err_stage:= 'Exiting create_rbs_element- Inserts in pa_rbs_elements :'||SQL%ROWCOUNT ;
1360: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1361: pa_debug.reset_curr_function;
1362: END IF;
1363:

Line 1360: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

1356: g_denorm_refresh := 'Y';
1357:
1358: IF g_debug_mode = 'Y' THEN
1359: pa_debug.g_err_stage:= 'Exiting create_rbs_element- Inserts in pa_rbs_elements :'||SQL%ROWCOUNT ;
1360: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1361: pa_debug.reset_curr_function;
1362: END IF;
1363:
1364:

Line 1361: pa_debug.reset_curr_function;

1357:
1358: IF g_debug_mode = 'Y' THEN
1359: pa_debug.g_err_stage:= 'Exiting create_rbs_element- Inserts in pa_rbs_elements :'||SQL%ROWCOUNT ;
1360: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1361: pa_debug.reset_curr_function;
1362: END IF;
1363:
1364:
1365:

Line 1392: PA_DEBUG.set_curr_function( p_function => 'populate_txn_map'

1388: l_WHERE_clause VARCHAR2 (1000); --bug#3888373 increased size from 500 to 1000
1389: l_max_level NUMBER;
1390: BEGIN
1391: IF g_debug_mode = 'Y' THEN
1392: PA_DEBUG.set_curr_function( p_function => 'populate_txn_map'
1393: ,p_debug_mode => g_debug_mode );
1394: pa_debug.g_err_stage:= 'Inside populate_txn_map- p_struct_version_id :'|| p_struct_version_id || ' p_max_level: ' || p_max_level || ' p_rule_id:'||p_rule_id;
1395: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1396: END IF;

Line 1394: pa_debug.g_err_stage:= 'Inside populate_txn_map- p_struct_version_id :'|| p_struct_version_id || ' p_max_level: ' || p_max_level || ' p_rule_id:'||p_rule_id;

1390: BEGIN
1391: IF g_debug_mode = 'Y' THEN
1392: PA_DEBUG.set_curr_function( p_function => 'populate_txn_map'
1393: ,p_debug_mode => g_debug_mode );
1394: pa_debug.g_err_stage:= 'Inside populate_txn_map- p_struct_version_id :'|| p_struct_version_id || ' p_max_level: ' || p_max_level || ' p_rule_id:'||p_rule_id;
1395: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1396: END IF;
1397:
1398: l_INSERT_clause := 'INSERT INTO pa_rbs_txn_accum_map ('

Line 1395: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

1391: IF g_debug_mode = 'Y' THEN
1392: PA_DEBUG.set_curr_function( p_function => 'populate_txn_map'
1393: ,p_debug_mode => g_debug_mode );
1394: pa_debug.g_err_stage:= 'Inside populate_txn_map- p_struct_version_id :'|| p_struct_version_id || ' p_max_level: ' || p_max_level || ' p_rule_id:'||p_rule_id;
1395: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1396: END IF;
1397:
1398: l_INSERT_clause := 'INSERT INTO pa_rbs_txn_accum_map ('
1399: || 'txn_accum_header_id,'

Line 1459: pa_debug.g_err_stage:= 'Exiting populate_txn_map- Inserts in Txn_accum_map :'||SQL%ROWCOUNT ;

1455:
1456:
1457:
1458: IF g_debug_mode = 'Y' THEN
1459: pa_debug.g_err_stage:= 'Exiting populate_txn_map- Inserts in Txn_accum_map :'||SQL%ROWCOUNT ;
1460: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1461: pa_debug.reset_curr_function;
1462: END IF;
1463:

Line 1460: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

1456:
1457:
1458: IF g_debug_mode = 'Y' THEN
1459: pa_debug.g_err_stage:= 'Exiting populate_txn_map- Inserts in Txn_accum_map :'||SQL%ROWCOUNT ;
1460: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1461: pa_debug.reset_curr_function;
1462: END IF;
1463:
1464: END ;

Line 1461: pa_debug.reset_curr_function;

1457:
1458: IF g_debug_mode = 'Y' THEN
1459: pa_debug.g_err_stage:= 'Exiting populate_txn_map- Inserts in Txn_accum_map :'||SQL%ROWCOUNT ;
1460: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1461: pa_debug.reset_curr_function;
1462: END IF;
1463:
1464: END ;
1465:

Line 1482: PA_DEBUG.set_curr_function( p_function => 'populate_custom_columns'

1478: --bug#3995697 l_rbs_element_id NUMBER;
1479: l_sql_cols VARCHAR2(200);
1480: BEGIN
1481: IF g_debug_mode = 'Y' THEN
1482: PA_DEBUG.set_curr_function( p_function => 'populate_custom_columns'
1483: ,p_debug_mode => g_debug_mode );
1484: pa_debug.g_err_stage:= 'Inside populate_custom_columns';
1485: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1486: END IF;

Line 1484: pa_debug.g_err_stage:= 'Inside populate_custom_columns';

1480: BEGIN
1481: IF g_debug_mode = 'Y' THEN
1482: PA_DEBUG.set_curr_function( p_function => 'populate_custom_columns'
1483: ,p_debug_mode => g_debug_mode );
1484: pa_debug.g_err_stage:= 'Inside populate_custom_columns';
1485: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1486: END IF;
1487:
1488: j := 1;

Line 1485: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

1481: IF g_debug_mode = 'Y' THEN
1482: PA_DEBUG.set_curr_function( p_function => 'populate_custom_columns'
1483: ,p_debug_mode => g_debug_mode );
1484: pa_debug.g_err_stage:= 'Inside populate_custom_columns';
1485: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1486: END IF;
1487:
1488: j := 1;
1489: FOR i IN 2..g_max_level LOOP

Line 1514: pa_debug.g_err_stage:= 'Exiting populate_custom_columns - Columns Inserted :'|| l_sql_cols;

1510:
1511: END IF;
1512:
1513: IF g_debug_mode = 'Y' THEN
1514: pa_debug.g_err_stage:= 'Exiting populate_custom_columns - Columns Inserted :'|| l_sql_cols;
1515: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1516: pa_debug.reset_curr_function;
1517: END IF;
1518:

Line 1515: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

1511: END IF;
1512:
1513: IF g_debug_mode = 'Y' THEN
1514: pa_debug.g_err_stage:= 'Exiting populate_custom_columns - Columns Inserted :'|| l_sql_cols;
1515: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1516: pa_debug.reset_curr_function;
1517: END IF;
1518:
1519: END ;

Line 1516: pa_debug.reset_curr_function;

1512:
1513: IF g_debug_mode = 'Y' THEN
1514: pa_debug.g_err_stage:= 'Exiting populate_custom_columns - Columns Inserted :'|| l_sql_cols;
1515: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1516: pa_debug.reset_curr_function;
1517: END IF;
1518:
1519: END ;
1520:

Line 1541: PA_DEBUG.set_curr_function( p_function => 'process_top_rule'

1537: x_rbs_element_name_id NUMBER;
1538: x_return_status VARCHAR2(30);
1539: BEGIN
1540: IF g_debug_mode = 'Y' THEN
1541: PA_DEBUG.set_curr_function( p_function => 'process_top_rule'
1542: ,p_debug_mode => g_debug_mode );
1543: pa_debug.g_err_stage:= 'Inside process_top_rule';
1544: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1545: END IF;

Line 1543: pa_debug.g_err_stage:= 'Inside process_top_rule';

1539: BEGIN
1540: IF g_debug_mode = 'Y' THEN
1541: PA_DEBUG.set_curr_function( p_function => 'process_top_rule'
1542: ,p_debug_mode => g_debug_mode );
1543: pa_debug.g_err_stage:= 'Inside process_top_rule';
1544: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1545: END IF;
1546:
1547: SELECT distinct txn_accum_header_id

Line 1544: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

1540: IF g_debug_mode = 'Y' THEN
1541: PA_DEBUG.set_curr_function( p_function => 'process_top_rule'
1542: ,p_debug_mode => g_debug_mode );
1543: pa_debug.g_err_stage:= 'Inside process_top_rule';
1544: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1545: END IF;
1546:
1547: SELECT distinct txn_accum_header_id
1548: bulk collect into l_txn_header_id

Line 1638: pa_debug.g_err_stage:= 'Exiting process_top_rule' ;

1634: g_login_id);
1635: END IF;
1636:
1637: IF g_debug_mode = 'Y' THEN
1638: pa_debug.g_err_stage:= 'Exiting process_top_rule' ;
1639: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1640: pa_debug.reset_curr_function;
1641: END IF;
1642: END;

Line 1639: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

1635: END IF;
1636:
1637: IF g_debug_mode = 'Y' THEN
1638: pa_debug.g_err_stage:= 'Exiting process_top_rule' ;
1639: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1640: pa_debug.reset_curr_function;
1641: END IF;
1642: END;
1643:

Line 1640: pa_debug.reset_curr_function;

1636:
1637: IF g_debug_mode = 'Y' THEN
1638: pa_debug.g_err_stage:= 'Exiting process_top_rule' ;
1639: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1640: pa_debug.reset_curr_function;
1641: END IF;
1642: END;
1643:
1644: ---------------------------------------------------

Line 1681: PA_DEBUG.set_curr_function( p_function => 'map_rbs_txn'

1677:
1678: x_return_status := FND_API.G_RET_STS_SUCCESS;
1679:
1680: IF g_debug_mode = 'Y' THEN
1681: PA_DEBUG.set_curr_function( p_function => 'map_rbs_txn'
1682: ,p_debug_mode => g_debug_mode );
1683: pa_debug.g_err_stage:= 'Inside map_rbs_txn- p_rbs_struct_version_id :'|| p_rbs_struct_version_id;
1684: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1685: END IF;

Line 1683: pa_debug.g_err_stage:= 'Inside map_rbs_txn- p_rbs_struct_version_id :'|| p_rbs_struct_version_id;

1679:
1680: IF g_debug_mode = 'Y' THEN
1681: PA_DEBUG.set_curr_function( p_function => 'map_rbs_txn'
1682: ,p_debug_mode => g_debug_mode );
1683: pa_debug.g_err_stage:= 'Inside map_rbs_txn- p_rbs_struct_version_id :'|| p_rbs_struct_version_id;
1684: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1685: END IF;
1686:
1687:

Line 1684: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

1680: IF g_debug_mode = 'Y' THEN
1681: PA_DEBUG.set_curr_function( p_function => 'map_rbs_txn'
1682: ,p_debug_mode => g_debug_mode );
1683: pa_debug.g_err_stage:= 'Inside map_rbs_txn- p_rbs_struct_version_id :'|| p_rbs_struct_version_id;
1684: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1685: END IF;
1686:
1687:
1688: /* added for bug#4101364 */

Line 1788: pa_debug.g_err_stage:= 'Exiting map_rbs_txn' ;

1784: where rbs_version_id = p_rbs_struct_version_id;
1785: /* Added for Bug 9099240 End */
1786:
1787: IF g_debug_mode = 'Y' THEN
1788: pa_debug.g_err_stage:= 'Exiting map_rbs_txn' ;
1789: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1790: pa_debug.reset_curr_function;
1791: END IF;
1792:

Line 1789: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

1785: /* Added for Bug 9099240 End */
1786:
1787: IF g_debug_mode = 'Y' THEN
1788: pa_debug.g_err_stage:= 'Exiting map_rbs_txn' ;
1789: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1790: pa_debug.reset_curr_function;
1791: END IF;
1792:
1793: EXCEPTION WHEN OTHERS THEN /* Added the exception block for bug #6377425 */

Line 1790: pa_debug.reset_curr_function;

1786:
1787: IF g_debug_mode = 'Y' THEN
1788: pa_debug.g_err_stage:= 'Exiting map_rbs_txn' ;
1789: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1790: pa_debug.reset_curr_function;
1791: END IF;
1792:
1793: EXCEPTION WHEN OTHERS THEN /* Added the exception block for bug #6377425 */
1794:

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 1804: Pa_Debug.WRITE(g_module_name, Pa_Debug.g_err_stage,5);

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:
1808: RAISE;

Line 1805: Pa_Debug.reset_curr_function;

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:
1808: RAISE;
1809:

Line 1862: PA_DEBUG.set_curr_function( p_function => 'map_rbs_actuals'

1858: Pji_Pjp_Fp_Curr_Wrap.print_time( ' l_process = ' || l_process );
1859: Pji_Pjp_Fp_Curr_Wrap.print_time( ' l_extraction_type = ' || l_extraction_type );
1860:
1861: IF g_debug_mode = 'Y' THEN
1862: PA_DEBUG.set_curr_function( p_function => 'map_rbs_actuals'
1863: ,p_debug_mode => g_debug_mode );
1864: pa_debug.g_err_stage:= 'Inside map_rbs_actuals : extrn type = ' || l_extraction_type ;
1865: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1866: END IF;

Line 1864: pa_debug.g_err_stage:= 'Inside map_rbs_actuals : extrn type = ' || l_extraction_type ;

1860:
1861: IF g_debug_mode = 'Y' THEN
1862: PA_DEBUG.set_curr_function( p_function => 'map_rbs_actuals'
1863: ,p_debug_mode => g_debug_mode );
1864: pa_debug.g_err_stage:= 'Inside map_rbs_actuals : extrn type = ' || l_extraction_type ;
1865: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1866: END IF;
1867:
1868: /* Added for bug 11843445 */

Line 1865: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

1861: IF g_debug_mode = 'Y' THEN
1862: PA_DEBUG.set_curr_function( p_function => 'map_rbs_actuals'
1863: ,p_debug_mode => g_debug_mode );
1864: pa_debug.g_err_stage:= 'Inside map_rbs_actuals : extrn type = ' || l_extraction_type ;
1865: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1866: END IF;
1867:
1868: /* Added for bug 11843445 */
1869: fnd_stats.gather_table_stats('PA','PA_RBS_ELEMENTS');

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 2228: Pa_Debug.WRITE(g_module_name, Pa_Debug.g_err_stage,5);

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:
2232: ROLLBACK TO map_rbs_txn;

Line 2229: Pa_Debug.reset_curr_function;

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:
2232: ROLLBACK TO map_rbs_txn;
2233: RAISE; -- Bug#5223360 - RBS mapping Errors will not get suppressed

Line 2242: pa_debug.g_err_stage:= ' Number of rows in plans_out after map_rbs_txn ' ||l_out;

2238:
2239: IF g_debug_mode = 'Y' THEN
2240:
2241: select count(*) into l_out from PA_RBS_PLANS_OUT_TMP;
2242: pa_debug.g_err_stage:= ' Number of rows in plans_out after map_rbs_txn ' ||l_out;
2243: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2244:
2245: pa_debug.g_err_stage:= 'Exiting map_rbs_actuals' ;
2246: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

Line 2243: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

2239: IF g_debug_mode = 'Y' THEN
2240:
2241: select count(*) into l_out from PA_RBS_PLANS_OUT_TMP;
2242: pa_debug.g_err_stage:= ' Number of rows in plans_out after map_rbs_txn ' ||l_out;
2243: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2244:
2245: pa_debug.g_err_stage:= 'Exiting map_rbs_actuals' ;
2246: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2247: pa_debug.reset_curr_function;

Line 2245: pa_debug.g_err_stage:= 'Exiting map_rbs_actuals' ;

2241: select count(*) into l_out from PA_RBS_PLANS_OUT_TMP;
2242: pa_debug.g_err_stage:= ' Number of rows in plans_out after map_rbs_txn ' ||l_out;
2243: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2244:
2245: pa_debug.g_err_stage:= 'Exiting map_rbs_actuals' ;
2246: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2247: pa_debug.reset_curr_function;
2248:
2249:

Line 2246: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

2242: pa_debug.g_err_stage:= ' Number of rows in plans_out after map_rbs_txn ' ||l_out;
2243: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2244:
2245: pa_debug.g_err_stage:= 'Exiting map_rbs_actuals' ;
2246: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2247: pa_debug.reset_curr_function;
2248:
2249:
2250: END IF;

Line 2247: pa_debug.reset_curr_function;

2243: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2244:
2245: pa_debug.g_err_stage:= 'Exiting map_rbs_actuals' ;
2246: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2247: pa_debug.reset_curr_function;
2248:
2249:
2250: END IF;
2251:

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 2263: pa_debug.write(g_module_name, pa_debug.g_err_stage,5);

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;
2267: END;

Line 2264: pa_debug.reset_curr_function;

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;
2267: END;
2268:

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 2539: -- Pa_Debug.WRITE(g_module_name, Pa_Debug.g_err_stage,5);

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:
2543: ROLLBACK TO map_rbs_txn;

Line 2540: -- Pa_Debug.reset_curr_function;

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:
2543: ROLLBACK TO map_rbs_txn;
2544: RAISE;

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 2567: -- pa_debug.write(g_module_name, pa_debug.g_err_stage,5);

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;
2571: END map_rbs_actuals_new ;

Line 2568: -- pa_debug.reset_curr_function;

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;
2571: END map_rbs_actuals_new ;
2572:

Line 2608: PA_DEBUG.set_curr_function( p_function => 'map_rbs_plans'

2604:
2605: x_return_status := FND_API.G_RET_STS_SUCCESS;
2606:
2607: IF g_debug_mode = 'Y' THEN
2608: PA_DEBUG.set_curr_function( p_function => 'map_rbs_plans'
2609: ,p_debug_mode => g_debug_mode );
2610: pa_debug.g_err_stage:= 'Inside map_rbs_plans : p_rbs_version_id = ' || p_rbs_version_id ;
2611: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2612: END IF;

Line 2610: pa_debug.g_err_stage:= 'Inside map_rbs_plans : p_rbs_version_id = ' || p_rbs_version_id ;

2606:
2607: IF g_debug_mode = 'Y' THEN
2608: PA_DEBUG.set_curr_function( p_function => 'map_rbs_plans'
2609: ,p_debug_mode => g_debug_mode );
2610: pa_debug.g_err_stage:= 'Inside map_rbs_plans : p_rbs_version_id = ' || p_rbs_version_id ;
2611: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2612: END IF;
2613:
2614: l_tmpcnt :=0;

Line 2611: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

2607: IF g_debug_mode = 'Y' THEN
2608: PA_DEBUG.set_curr_function( p_function => 'map_rbs_plans'
2609: ,p_debug_mode => g_debug_mode );
2610: pa_debug.g_err_stage:= 'Inside map_rbs_plans : p_rbs_version_id = ' || p_rbs_version_id ;
2611: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2612: END IF;
2613:
2614: l_tmpcnt :=0;
2615:

Line 2619: pa_debug.g_err_stage:= 'rbs version is provided';

2615:
2616: IF p_rbs_version_id IS NOT NULL THEN
2617:
2618: IF g_debug_mode = 'Y' THEN
2619: pa_debug.g_err_stage:= 'rbs version is provided';
2620: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2621: END IF;
2622:
2623: --check whether headers are present in pji_fp_txn_accum_header or not, if not then create them in pji_fp_txn_accum_header

Line 2620: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

2616: IF p_rbs_version_id IS NOT NULL THEN
2617:
2618: IF g_debug_mode = 'Y' THEN
2619: pa_debug.g_err_stage:= 'rbs version is provided';
2620: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2621: END IF;
2622:
2623: --check whether headers are present in pji_fp_txn_accum_header or not, if not then create them in pji_fp_txn_accum_header
2624: --assuming that source_id is populated in pji_fp_txn_accum_header

Line 2792: pa_debug.g_err_stage:= 'accum headers are inserted';

2788: END IF;
2789: /*bug#4770784, end here */
2790:
2791: IF g_debug_mode = 'Y' THEN
2792: pa_debug.g_err_stage:= 'accum headers are inserted';
2793: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2794: END IF;
2795:
2796: DELETE PA_RBS_PLANS_OUT_TMP;

Line 2793: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

2789: /*bug#4770784, end here */
2790:
2791: IF g_debug_mode = 'Y' THEN
2792: pa_debug.g_err_stage:= 'accum headers are inserted';
2793: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2794: END IF;
2795:
2796: DELETE PA_RBS_PLANS_OUT_TMP;
2797: INSERT INTO PA_RBS_PLANS_OUT_TMP

Line 2953: pa_debug.g_err_stage:= 'calling map_rbs_txn for rbs version = '||p_rbs_version_id;

2949:
2950:
2951:
2952: IF g_debug_mode = 'Y' THEN
2953: pa_debug.g_err_stage:= 'calling map_rbs_txn for rbs version = '||p_rbs_version_id;
2954: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2955: END IF;
2956:
2957: -- Bug#5503706 Start

Line 2954: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

2950:
2951:
2952: IF g_debug_mode = 'Y' THEN
2953: pa_debug.g_err_stage:= 'calling map_rbs_txn for rbs version = '||p_rbs_version_id;
2954: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2955: END IF;
2956:
2957: -- Bug#5503706 Start
2958: select count(*) into l_tmpcnt from PA_RBS_MAP_TMP2;

Line 2961: pa_debug.g_err_stage:= 'The number of rows in pa_rbs_map_tmp2 table = '||l_tmpcnt;

2957: -- Bug#5503706 Start
2958: select count(*) into l_tmpcnt from PA_RBS_MAP_TMP2;
2959:
2960: IF g_debug_mode = 'Y' THEN
2961: pa_debug.g_err_stage:= 'The number of rows in pa_rbs_map_tmp2 table = '||l_tmpcnt;
2962: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2963: END IF;
2964:
2965: if l_tmpcnt >0 then

Line 2962: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

2958: select count(*) into l_tmpcnt from PA_RBS_MAP_TMP2;
2959:
2960: IF g_debug_mode = 'Y' THEN
2961: pa_debug.g_err_stage:= 'The number of rows in pa_rbs_map_tmp2 table = '||l_tmpcnt;
2962: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2963: END IF;
2964:
2965: if l_tmpcnt >0 then
2966: map_rbs_txn(p_rbs_version_id,l_return_status,l_msg_count,l_msg_data);

Line 2977: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Denorm.POPULATE_RBS_DENORM' ;

2973: AND g_denorm_refresh = 'Y'
2974: THEN
2975:
2976: IF g_debug_mode = 'Y' THEN
2977: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Denorm.POPULATE_RBS_DENORM' ;
2978: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2979: pa_debug.reset_curr_function;
2980: END IF;
2981:

Line 2978: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

2974: THEN
2975:
2976: IF g_debug_mode = 'Y' THEN
2977: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Denorm.POPULATE_RBS_DENORM' ;
2978: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2979: pa_debug.reset_curr_function;
2980: END IF;
2981:
2982: Pji_Pjp_Sum_Denorm.POPULATE_RBS_DENORM(

Line 2979: pa_debug.reset_curr_function;

2975:
2976: IF g_debug_mode = 'Y' THEN
2977: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Denorm.POPULATE_RBS_DENORM' ;
2978: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2979: pa_debug.reset_curr_function;
2980: END IF;
2981:
2982: Pji_Pjp_Sum_Denorm.POPULATE_RBS_DENORM(
2983: p_worker_id => 1,

Line 2988: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Rollup.set_online_context' ;

2984: p_denorm_type => 'RBS',
2985: p_rbs_version_id => p_rbs_version_id) ;
2986:
2987: IF g_debug_mode = 'Y' THEN
2988: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Rollup.set_online_context' ;
2989: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2990: pa_debug.reset_curr_function;
2991: END IF;
2992:

Line 2989: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

2985: p_rbs_version_id => p_rbs_version_id) ;
2986:
2987: IF g_debug_mode = 'Y' THEN
2988: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Rollup.set_online_context' ;
2989: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2990: pa_debug.reset_curr_function;
2991: END IF;
2992:
2993: Pji_Pjp_Sum_Rollup.set_online_context (

Line 2990: pa_debug.reset_curr_function;

2986:
2987: IF g_debug_mode = 'Y' THEN
2988: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Rollup.set_online_context' ;
2989: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2990: pa_debug.reset_curr_function;
2991: END IF;
2992:
2993: Pji_Pjp_Sum_Rollup.set_online_context (
2994: p_event_id => NULL,

Line 3006: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Rollup.UPDATE_RBS_DENORM' ;

3002: p_new_struct_version => NULL,
3003: p_rbs_version => p_rbs_version_id );
3004:
3005: IF g_debug_mode = 'Y' THEN
3006: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Rollup.UPDATE_RBS_DENORM' ;
3007: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3008: pa_debug.reset_curr_function;
3009: END IF;
3010:

Line 3007: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

3003: p_rbs_version => p_rbs_version_id );
3004:
3005: IF g_debug_mode = 'Y' THEN
3006: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Rollup.UPDATE_RBS_DENORM' ;
3007: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3008: pa_debug.reset_curr_function;
3009: END IF;
3010:
3011: Pji_Pjp_Sum_Rollup.UPDATE_RBS_DENORM;

Line 3008: pa_debug.reset_curr_function;

3004:
3005: IF g_debug_mode = 'Y' THEN
3006: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Rollup.UPDATE_RBS_DENORM' ;
3007: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3008: pa_debug.reset_curr_function;
3009: END IF;
3010:
3011: Pji_Pjp_Sum_Rollup.UPDATE_RBS_DENORM;
3012:

Line 3014: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Denorm.cleanup_rbs_denorm' ;

3010:
3011: Pji_Pjp_Sum_Rollup.UPDATE_RBS_DENORM;
3012:
3013: IF g_debug_mode = 'Y' THEN
3014: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Denorm.cleanup_rbs_denorm' ;
3015: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3016: pa_debug.reset_curr_function;
3017: END IF;
3018:

Line 3015: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

3011: Pji_Pjp_Sum_Rollup.UPDATE_RBS_DENORM;
3012:
3013: IF g_debug_mode = 'Y' THEN
3014: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Denorm.cleanup_rbs_denorm' ;
3015: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3016: pa_debug.reset_curr_function;
3017: END IF;
3018:
3019: Pji_Pjp_Sum_Denorm.cleanup_rbs_denorm(

Line 3016: pa_debug.reset_curr_function;

3012:
3013: IF g_debug_mode = 'Y' THEN
3014: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Denorm.cleanup_rbs_denorm' ;
3015: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3016: pa_debug.reset_curr_function;
3017: END IF;
3018:
3019: Pji_Pjp_Sum_Denorm.cleanup_rbs_denorm(
3020: p_worker_id => 1,

Line 3039: pa_debug.g_err_stage:= 'rbs version is not provided';

3035:
3036: ELSE ---------------------- if rbs structure version id is not provided, header and source_id is populated
3037:
3038: IF g_debug_mode = 'Y' THEN
3039: pa_debug.g_err_stage:= 'rbs version is not provided';
3040: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3041: END IF;
3042:
3043: DELETE pa_rbs_map_tmp1 ;

Line 3040: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

3036: ELSE ---------------------- if rbs structure version id is not provided, header and source_id is populated
3037:
3038: IF g_debug_mode = 'Y' THEN
3039: pa_debug.g_err_stage:= 'rbs version is not provided';
3040: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3041: END IF;
3042:
3043: DELETE pa_rbs_map_tmp1 ;
3044:

Line 3114: pa_debug.g_err_stage:= 'calling map_rbs_txn for rbs version = '||l_rbs_struct_version_id(i) ;

3110: tmp1.txn_accum_header_id = tmp.txn_accum_header_id AND
3111: tmp.rowid = (select max(rowid) from PA_RBS_PLANS_IN_TMP where txn_accum_header_id = tmp.txn_accum_header_id);
3112:
3113: IF g_debug_mode = 'Y' THEN
3114: pa_debug.g_err_stage:= 'calling map_rbs_txn for rbs version = '||l_rbs_struct_version_id(i) ;
3115: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3116: END IF;
3117:
3118: -- Bug#5503706 Start

Line 3115: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

3111: tmp.rowid = (select max(rowid) from PA_RBS_PLANS_IN_TMP where txn_accum_header_id = tmp.txn_accum_header_id);
3112:
3113: IF g_debug_mode = 'Y' THEN
3114: pa_debug.g_err_stage:= 'calling map_rbs_txn for rbs version = '||l_rbs_struct_version_id(i) ;
3115: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3116: END IF;
3117:
3118: -- Bug#5503706 Start
3119: select count(*) into l_tmpcnt from PA_RBS_MAP_TMP2;

Line 3122: pa_debug.g_err_stage:= 'The number of rows in pa_rbs_map_tmp2 table = '||l_tmpcnt;

3118: -- Bug#5503706 Start
3119: select count(*) into l_tmpcnt from PA_RBS_MAP_TMP2;
3120:
3121: IF g_debug_mode = 'Y' THEN
3122: pa_debug.g_err_stage:= 'The number of rows in pa_rbs_map_tmp2 table = '||l_tmpcnt;
3123: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3124: END IF;
3125:
3126: if l_tmpcnt >0 then

Line 3123: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

3119: select count(*) into l_tmpcnt from PA_RBS_MAP_TMP2;
3120:
3121: IF g_debug_mode = 'Y' THEN
3122: pa_debug.g_err_stage:= 'The number of rows in pa_rbs_map_tmp2 table = '||l_tmpcnt;
3123: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3124: END IF;
3125:
3126: if l_tmpcnt >0 then
3127: map_rbs_txn(l_rbs_struct_version_id(i),l_return_status,l_msg_count,l_msg_data);

Line 3137: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Denorm.POPULATE_RBS_DENORM' ;

3133: IF NVL(PJI_UTILS.GET_PARAMETER('PJI_FPM_UPGRADE'), 'P') = 'C'
3134: AND g_denorm_refresh = 'Y' THEN
3135:
3136: IF g_debug_mode = 'Y' THEN
3137: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Denorm.POPULATE_RBS_DENORM' ;
3138: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3139: pa_debug.reset_curr_function;
3140: END IF;
3141:

Line 3138: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

3134: AND g_denorm_refresh = 'Y' THEN
3135:
3136: IF g_debug_mode = 'Y' THEN
3137: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Denorm.POPULATE_RBS_DENORM' ;
3138: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3139: pa_debug.reset_curr_function;
3140: END IF;
3141:
3142: Pji_Pjp_Sum_Denorm.POPULATE_RBS_DENORM(

Line 3139: pa_debug.reset_curr_function;

3135:
3136: IF g_debug_mode = 'Y' THEN
3137: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Denorm.POPULATE_RBS_DENORM' ;
3138: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3139: pa_debug.reset_curr_function;
3140: END IF;
3141:
3142: Pji_Pjp_Sum_Denorm.POPULATE_RBS_DENORM(
3143: p_worker_id => 1,

Line 3148: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Rollup.set_online_context' ;

3144: p_denorm_type => 'RBS',
3145: p_rbs_version_id => p_rbs_version_id) ;
3146:
3147: IF g_debug_mode = 'Y' THEN
3148: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Rollup.set_online_context' ;
3149: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3150: pa_debug.reset_curr_function;
3151: END IF;
3152:

Line 3149: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

3145: p_rbs_version_id => p_rbs_version_id) ;
3146:
3147: IF g_debug_mode = 'Y' THEN
3148: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Rollup.set_online_context' ;
3149: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3150: pa_debug.reset_curr_function;
3151: END IF;
3152:
3153: Pji_Pjp_Sum_Rollup.set_online_context (

Line 3150: pa_debug.reset_curr_function;

3146:
3147: IF g_debug_mode = 'Y' THEN
3148: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Rollup.set_online_context' ;
3149: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3150: pa_debug.reset_curr_function;
3151: END IF;
3152:
3153: Pji_Pjp_Sum_Rollup.set_online_context (
3154: p_event_id => NULL,

Line 3166: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Rollup.UPDATE_RBS_DENORM' ;

3162: p_new_struct_version => NULL,
3163: p_rbs_version => p_rbs_version_id );
3164:
3165: IF g_debug_mode = 'Y' THEN
3166: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Rollup.UPDATE_RBS_DENORM' ;
3167: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3168: pa_debug.reset_curr_function;
3169: END IF;
3170:

Line 3167: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

3163: p_rbs_version => p_rbs_version_id );
3164:
3165: IF g_debug_mode = 'Y' THEN
3166: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Rollup.UPDATE_RBS_DENORM' ;
3167: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3168: pa_debug.reset_curr_function;
3169: END IF;
3170:
3171: Pji_Pjp_Sum_Rollup.UPDATE_RBS_DENORM;

Line 3168: pa_debug.reset_curr_function;

3164:
3165: IF g_debug_mode = 'Y' THEN
3166: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Rollup.UPDATE_RBS_DENORM' ;
3167: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3168: pa_debug.reset_curr_function;
3169: END IF;
3170:
3171: Pji_Pjp_Sum_Rollup.UPDATE_RBS_DENORM;
3172:

Line 3174: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Denorm.cleanup_rbs_denorm' ;

3170:
3171: Pji_Pjp_Sum_Rollup.UPDATE_RBS_DENORM;
3172:
3173: IF g_debug_mode = 'Y' THEN
3174: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Denorm.cleanup_rbs_denorm' ;
3175: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3176: pa_debug.reset_curr_function;
3177: END IF;
3178:

Line 3175: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

3171: Pji_Pjp_Sum_Rollup.UPDATE_RBS_DENORM;
3172:
3173: IF g_debug_mode = 'Y' THEN
3174: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Denorm.cleanup_rbs_denorm' ;
3175: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3176: pa_debug.reset_curr_function;
3177: END IF;
3178:
3179: Pji_Pjp_Sum_Denorm.cleanup_rbs_denorm(

Line 3176: pa_debug.reset_curr_function;

3172:
3173: IF g_debug_mode = 'Y' THEN
3174: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Denorm.cleanup_rbs_denorm' ;
3175: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3176: pa_debug.reset_curr_function;
3177: END IF;
3178:
3179: Pji_Pjp_Sum_Denorm.cleanup_rbs_denorm(
3180: p_worker_id => 1,

Line 3193: pa_debug.g_err_stage:= 'Exiting map_rbs_plans ' ;

3189:
3190: END IF;
3191:
3192: IF g_debug_mode = 'Y' THEN
3193: pa_debug.g_err_stage:= 'Exiting map_rbs_plans ' ;
3194: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3195: pa_debug.reset_curr_function;
3196:
3197: select count(*) into l_out from PA_RBS_PLANS_OUT_TMP;

Line 3194: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

3190: END IF;
3191:
3192: IF g_debug_mode = 'Y' THEN
3193: pa_debug.g_err_stage:= 'Exiting map_rbs_plans ' ;
3194: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3195: pa_debug.reset_curr_function;
3196:
3197: select count(*) into l_out from PA_RBS_PLANS_OUT_TMP;
3198: pa_debug.g_err_stage:= ' Number of rows in plans_out after map_rbs_txn ' ||l_out;

Line 3195: pa_debug.reset_curr_function;

3191:
3192: IF g_debug_mode = 'Y' THEN
3193: pa_debug.g_err_stage:= 'Exiting map_rbs_plans ' ;
3194: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3195: pa_debug.reset_curr_function;
3196:
3197: select count(*) into l_out from PA_RBS_PLANS_OUT_TMP;
3198: pa_debug.g_err_stage:= ' Number of rows in plans_out after map_rbs_txn ' ||l_out;
3199: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

Line 3198: pa_debug.g_err_stage:= ' Number of rows in plans_out after map_rbs_txn ' ||l_out;

3194: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3195: pa_debug.reset_curr_function;
3196:
3197: select count(*) into l_out from PA_RBS_PLANS_OUT_TMP;
3198: pa_debug.g_err_stage:= ' Number of rows in plans_out after map_rbs_txn ' ||l_out;
3199: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3200: pa_debug.reset_curr_function;
3201:
3202: END IF;

Line 3199: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

3195: pa_debug.reset_curr_function;
3196:
3197: select count(*) into l_out from PA_RBS_PLANS_OUT_TMP;
3198: pa_debug.g_err_stage:= ' Number of rows in plans_out after map_rbs_txn ' ||l_out;
3199: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3200: pa_debug.reset_curr_function;
3201:
3202: END IF;
3203:

Line 3200: pa_debug.reset_curr_function;

3196:
3197: select count(*) into l_out from PA_RBS_PLANS_OUT_TMP;
3198: pa_debug.g_err_stage:= ' Number of rows in plans_out after map_rbs_txn ' ||l_out;
3199: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3200: pa_debug.reset_curr_function;
3201:
3202: END IF;
3203:
3204: EXCEPTION

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 3214: pa_debug.write(g_module_name, pa_debug.g_err_stage,5);

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;
3218: END;

Line 3215: pa_debug.reset_curr_function;

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;
3218: END;
3219:

Line 3236: PA_DEBUG.set_curr_function( p_function => 'create_res_type_numeric_id'

3232:
3233: x_return_status := FND_API.G_RET_STS_SUCCESS;
3234:
3235: IF g_debug_mode = 'Y' THEN
3236: PA_DEBUG.set_curr_function( p_function => 'create_res_type_numeric_id'
3237: ,p_debug_mode => g_debug_mode );
3238: pa_debug.g_err_stage:= 'Inside create_res_type_numeric_id';
3239: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3240: END IF;

Line 3238: pa_debug.g_err_stage:= 'Inside create_res_type_numeric_id';

3234:
3235: IF g_debug_mode = 'Y' THEN
3236: PA_DEBUG.set_curr_function( p_function => 'create_res_type_numeric_id'
3237: ,p_debug_mode => g_debug_mode );
3238: pa_debug.g_err_stage:= 'Inside create_res_type_numeric_id';
3239: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3240: END IF;
3241:
3242: IF l_resource_name = 'EMP_APL' THEN

Line 3239: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

3235: IF g_debug_mode = 'Y' THEN
3236: PA_DEBUG.set_curr_function( p_function => 'create_res_type_numeric_id'
3237: ,p_debug_mode => g_debug_mode );
3238: pa_debug.g_err_stage:= 'Inside create_res_type_numeric_id';
3239: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3240: END IF;
3241:
3242: IF l_resource_name = 'EMP_APL' THEN
3243: l_resource_name := 'EMP' ;

Line 3286: pa_debug.g_err_stage:= 'Exiting create_res_type_numeric_id' ;

3282: sysdate) ;
3283: END IF;
3284:
3285: IF g_debug_mode = 'Y' THEN
3286: pa_debug.g_err_stage:= 'Exiting create_res_type_numeric_id' ;
3287: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3288: pa_debug.reset_curr_function;
3289: END IF;
3290:

Line 3287: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

3283: END IF;
3284:
3285: IF g_debug_mode = 'Y' THEN
3286: pa_debug.g_err_stage:= 'Exiting create_res_type_numeric_id' ;
3287: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3288: pa_debug.reset_curr_function;
3289: END IF;
3290:
3291: EXCEPTION

Line 3288: pa_debug.reset_curr_function;

3284:
3285: IF g_debug_mode = 'Y' THEN
3286: pa_debug.g_err_stage:= 'Exiting create_res_type_numeric_id' ;
3287: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3288: pa_debug.reset_curr_function;
3289: END IF;
3290:
3291: EXCEPTION
3292: WHEN OTHERS THEN

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 3300: pa_debug.write(g_module_name, pa_debug.g_err_stage,5);

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;
3304: END;

Line 3301: pa_debug.reset_curr_function;

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;
3304: END;
3305:

Line 3356: PA_DEBUG.set_curr_function( p_function => 'insert_rule'

3352: BEGIN
3353:
3354:
3355: IF g_debug_mode = 'Y' THEN
3356: PA_DEBUG.set_curr_function( p_function => 'insert_rule'
3357: ,p_debug_mode => g_debug_mode );
3358: pa_debug.g_err_stage:= 'Inside insert_rule';
3359: pa_debug.g_err_stage:= 'Inside insert_rule- rbs_version_id :'|| rbs_version_id||' depth:'||depth;
3360: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

Line 3358: pa_debug.g_err_stage:= 'Inside insert_rule';

3354:
3355: IF g_debug_mode = 'Y' THEN
3356: PA_DEBUG.set_curr_function( p_function => 'insert_rule'
3357: ,p_debug_mode => g_debug_mode );
3358: pa_debug.g_err_stage:= 'Inside insert_rule';
3359: pa_debug.g_err_stage:= 'Inside insert_rule- rbs_version_id :'|| rbs_version_id||' depth:'||depth;
3360: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3361: END IF;
3362:

Line 3359: pa_debug.g_err_stage:= 'Inside insert_rule- rbs_version_id :'|| rbs_version_id||' depth:'||depth;

3355: IF g_debug_mode = 'Y' THEN
3356: PA_DEBUG.set_curr_function( p_function => 'insert_rule'
3357: ,p_debug_mode => g_debug_mode );
3358: pa_debug.g_err_stage:= 'Inside insert_rule';
3359: pa_debug.g_err_stage:= 'Inside insert_rule- rbs_version_id :'|| rbs_version_id||' depth:'||depth;
3360: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3361: END IF;
3362:
3363: col_sql_clause := '' ;

Line 3360: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

3356: PA_DEBUG.set_curr_function( p_function => 'insert_rule'
3357: ,p_debug_mode => g_debug_mode );
3358: pa_debug.g_err_stage:= 'Inside insert_rule';
3359: pa_debug.g_err_stage:= 'Inside insert_rule- rbs_version_id :'|| rbs_version_id||' depth:'||depth;
3360: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3361: END IF;
3362:
3363: col_sql_clause := '' ;
3364: for i in 1..depth loop

Line 3438: pa_debug.g_err_stage:= 'Exiting insert_rule' ;

3434:
3435:
3436:
3437: IF g_debug_mode = 'Y' THEN
3438: pa_debug.g_err_stage:= 'Exiting insert_rule' ;
3439: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3440: pa_debug.reset_curr_function;
3441: END IF;
3442:

Line 3439: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

3435:
3436:
3437: IF g_debug_mode = 'Y' THEN
3438: pa_debug.g_err_stage:= 'Exiting insert_rule' ;
3439: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3440: pa_debug.reset_curr_function;
3441: END IF;
3442:
3443:

Line 3440: pa_debug.reset_curr_function;

3436:
3437: IF g_debug_mode = 'Y' THEN
3438: pa_debug.g_err_stage:= 'Exiting insert_rule' ;
3439: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3440: pa_debug.reset_curr_function;
3441: END IF;
3442:
3443:
3444: END;

Line 3641: PA_DEBUG.set_curr_function( p_function => 'traverse_tree'

3637: called again and again without reset_curr_function to give rise to
3638: ORA-06502: PL/SQL: numeric or value error
3639:
3640: IF g_debug_mode = 'Y' THEN
3641: PA_DEBUG.set_curr_function( p_function => 'traverse_tree'
3642: ,p_debug_mode => g_debug_mode );
3643: pa_debug.g_err_stage:= 'Inside traverse_tree';
3644: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3645: END IF;

Line 3643: pa_debug.g_err_stage:= 'Inside traverse_tree';

3639:
3640: IF g_debug_mode = 'Y' THEN
3641: PA_DEBUG.set_curr_function( p_function => 'traverse_tree'
3642: ,p_debug_mode => g_debug_mode );
3643: pa_debug.g_err_stage:= 'Inside traverse_tree';
3644: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3645: END IF;
3646:
3647: */

Line 3644: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

3640: IF g_debug_mode = 'Y' THEN
3641: PA_DEBUG.set_curr_function( p_function => 'traverse_tree'
3642: ,p_debug_mode => g_debug_mode );
3643: pa_debug.g_err_stage:= 'Inside traverse_tree';
3644: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3645: END IF;
3646:
3647: */
3648:

Line 3687: pa_debug.g_err_stage:= 'Exiting traverse_tree' ;

3683:
3684: end loop;
3685:
3686: IF g_debug_mode = 'Y' THEN
3687: pa_debug.g_err_stage:= 'Exiting traverse_tree' ;
3688: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3689: pa_debug.reset_curr_function;
3690: END IF;
3691:

Line 3688: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

3684: end loop;
3685:
3686: IF g_debug_mode = 'Y' THEN
3687: pa_debug.g_err_stage:= 'Exiting traverse_tree' ;
3688: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3689: pa_debug.reset_curr_function;
3690: END IF;
3691:
3692: END;

Line 3689: pa_debug.reset_curr_function;

3685:
3686: IF g_debug_mode = 'Y' THEN
3687: pa_debug.g_err_stage:= 'Exiting traverse_tree' ;
3688: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3689: pa_debug.reset_curr_function;
3690: END IF;
3691:
3692: END;
3693:

Line 3720: PA_DEBUG.set_curr_function( p_function => 'create_mapping_rules'

3716:
3717: x_return_status := FND_API.G_RET_STS_SUCCESS;
3718:
3719: IF g_debug_mode = 'Y' THEN
3720: PA_DEBUG.set_curr_function( p_function => 'create_mapping_rules'
3721: ,p_debug_mode => g_debug_mode );
3722: pa_debug.g_err_stage:= 'Inside create_mapping_rules- p_rbs_version_id :'|| p_rbs_version_id;
3723: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3724: END IF;

Line 3722: pa_debug.g_err_stage:= 'Inside create_mapping_rules- p_rbs_version_id :'|| p_rbs_version_id;

3718:
3719: IF g_debug_mode = 'Y' THEN
3720: PA_DEBUG.set_curr_function( p_function => 'create_mapping_rules'
3721: ,p_debug_mode => g_debug_mode );
3722: pa_debug.g_err_stage:= 'Inside create_mapping_rules- p_rbs_version_id :'|| p_rbs_version_id;
3723: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3724: END IF;
3725:
3726: select count(1) into l_count from dual

Line 3723: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

3719: IF g_debug_mode = 'Y' THEN
3720: PA_DEBUG.set_curr_function( p_function => 'create_mapping_rules'
3721: ,p_debug_mode => g_debug_mode );
3722: pa_debug.g_err_stage:= 'Inside create_mapping_rules- p_rbs_version_id :'|| p_rbs_version_id;
3723: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3724: END IF;
3725:
3726: select count(1) into l_count from dual
3727: where exists

Line 3798: PA_DEBUG.set_curr_function( p_function => 'create_mapping_rules'

3794:
3795: l_count_tmp1:=SQL%ROWCOUNT; --Bug#5248414
3796:
3797: IF g_debug_mode = 'Y' THEN
3798: PA_DEBUG.set_curr_function( p_function => 'create_mapping_rules'
3799: ,p_debug_mode => g_debug_mode );
3800: pa_debug.g_err_stage:= 'Inside create_mapping_rules- Inserts in Tmp1 :'||l_count_tmp1 ;
3801: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3802: END IF;

Line 3800: pa_debug.g_err_stage:= 'Inside create_mapping_rules- Inserts in Tmp1 :'||l_count_tmp1 ;

3796:
3797: IF g_debug_mode = 'Y' THEN
3798: PA_DEBUG.set_curr_function( p_function => 'create_mapping_rules'
3799: ,p_debug_mode => g_debug_mode );
3800: pa_debug.g_err_stage:= 'Inside create_mapping_rules- Inserts in Tmp1 :'||l_count_tmp1 ;
3801: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3802: END IF;
3803:
3804: IF l_count_tmp1 > 0 THEN --Bug#5248414

Line 3801: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

3797: IF g_debug_mode = 'Y' THEN
3798: PA_DEBUG.set_curr_function( p_function => 'create_mapping_rules'
3799: ,p_debug_mode => g_debug_mode );
3800: pa_debug.g_err_stage:= 'Inside create_mapping_rules- Inserts in Tmp1 :'||l_count_tmp1 ;
3801: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3802: END IF;
3803:
3804: IF l_count_tmp1 > 0 THEN --Bug#5248414
3805:

Line 3829: pa_debug.g_err_stage:= 'Exiting create_mapping_rules' ;

3825:
3826: END IF;
3827:
3828: IF g_debug_mode = 'Y' THEN
3829: pa_debug.g_err_stage:= 'Exiting create_mapping_rules' ;
3830: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3831: pa_debug.reset_curr_function;
3832: END IF;
3833:

Line 3830: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

3826: END IF;
3827:
3828: IF g_debug_mode = 'Y' THEN
3829: pa_debug.g_err_stage:= 'Exiting create_mapping_rules' ;
3830: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3831: pa_debug.reset_curr_function;
3832: END IF;
3833:
3834: EXCEPTION

Line 3831: pa_debug.reset_curr_function;

3827:
3828: IF g_debug_mode = 'Y' THEN
3829: pa_debug.g_err_stage:= 'Exiting create_mapping_rules' ;
3830: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3831: pa_debug.reset_curr_function;
3832: END IF;
3833:
3834: EXCEPTION
3835: WHEN OTHERS THEN

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 3843: pa_debug.write(g_module_name, pa_debug.g_err_stage,5);

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;
3847: raise;

Line 3844: pa_debug.reset_curr_function;

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;
3847: raise;
3848: END;