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: SELECT decode(p_res_class_id,1,PERSON_RC_PRECEDENCE,
61: 2,EQUIPMENT_RC_PRECEDENCE,

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: SELECT decode(p_res_class_id,1,PERSON_RC_PRECEDENCE,
61: 2,EQUIPMENT_RC_PRECEDENCE,
62: 3,MATERIAL_RC_PRECEDENCE,

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

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

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

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

Line 105: pa_debug.reset_curr_function;

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

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

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

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

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

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

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

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

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

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

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

Line 299: pa_debug.reset_curr_function;

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

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

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

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

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

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

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

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

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

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

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

Line 360: pa_debug.reset_curr_function;

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

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

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

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

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

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

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

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

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

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

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

Line 403: pa_debug.reset_curr_function;

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

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

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

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

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

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

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

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

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

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

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

Line 454: pa_debug.reset_curr_function;

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

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

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

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

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

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

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

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

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

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

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

Line 541: pa_debug.reset_curr_function;

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

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

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

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

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

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

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

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

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

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

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

Line 602: pa_debug.reset_curr_function;

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

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

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

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

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

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

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

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

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

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

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

Line 729: pa_debug.reset_curr_function;

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

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

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

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

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

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

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

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

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

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

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

Line 801: pa_debug.reset_curr_function;

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

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

857: --bug#3995697 l_rule_type VARCHAR2 (1);
858:
859: BEGIN
860: IF g_debug_mode = 'Y' THEN
861: PA_DEBUG.set_curr_function( p_function => 'mapped_header'
862: ,p_debug_mode => g_debug_mode );
863: 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;
864: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
865: END IF;

Line 863: 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;

859: BEGIN
860: IF g_debug_mode = 'Y' THEN
861: PA_DEBUG.set_curr_function( p_function => 'mapped_header'
862: ,p_debug_mode => g_debug_mode );
863: 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;
864: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
865: END IF;
866:
867:

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

860: IF g_debug_mode = 'Y' THEN
861: PA_DEBUG.set_curr_function( p_function => 'mapped_header'
862: ,p_debug_mode => g_debug_mode );
863: 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;
864: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
865: END IF;
866:
867:
868: x_return_status := 0;

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

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

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

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

Line 943: pa_debug.reset_curr_function;

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

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

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

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

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

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

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

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

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

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

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

Line 1041: pa_debug.reset_curr_function;

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

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

1067: l_temp NUMBER;
1068: BEGIN
1069:
1070: IF g_debug_mode = 'Y' THEN
1071: PA_DEBUG.set_curr_function( p_function => 'unmapped_header_laststep'
1072: ,p_debug_mode => g_debug_mode );
1073: 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;
1074: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1075: END IF;

Line 1073: 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;

1069:
1070: IF g_debug_mode = 'Y' THEN
1071: PA_DEBUG.set_curr_function( p_function => 'unmapped_header_laststep'
1072: ,p_debug_mode => g_debug_mode );
1073: 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;
1074: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1075: END IF;
1076:
1077: l_temp := 3+p_level ;

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

1070: IF g_debug_mode = 'Y' THEN
1071: PA_DEBUG.set_curr_function( p_function => 'unmapped_header_laststep'
1072: ,p_debug_mode => g_debug_mode );
1073: 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;
1074: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1075: END IF;
1076:
1077: l_temp := 3+p_level ;
1078: --EXECUTE IMMEDIATE 'DELETE pa_rbs_map_tmp' || l_temp;

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

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

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

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

Line 1111: pa_debug.reset_curr_function;

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

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

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

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

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

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

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

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

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

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

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

Line 1207: pa_debug.reset_curr_function;

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

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

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

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

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

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

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

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

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

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

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

Line 1358: pa_debug.reset_curr_function;

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

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

1385: l_WHERE_clause VARCHAR2 (1000); --bug#3888373 increased size from 500 to 1000
1386: l_max_level NUMBER;
1387: BEGIN
1388: IF g_debug_mode = 'Y' THEN
1389: PA_DEBUG.set_curr_function( p_function => 'populate_txn_map'
1390: ,p_debug_mode => g_debug_mode );
1391: 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;
1392: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1393: END IF;

Line 1391: 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;

1387: BEGIN
1388: IF g_debug_mode = 'Y' THEN
1389: PA_DEBUG.set_curr_function( p_function => 'populate_txn_map'
1390: ,p_debug_mode => g_debug_mode );
1391: 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;
1392: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1393: END IF;
1394:
1395: l_INSERT_clause := 'INSERT INTO pa_rbs_txn_accum_map ('

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

1388: IF g_debug_mode = 'Y' THEN
1389: PA_DEBUG.set_curr_function( p_function => 'populate_txn_map'
1390: ,p_debug_mode => g_debug_mode );
1391: 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;
1392: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1393: END IF;
1394:
1395: l_INSERT_clause := 'INSERT INTO pa_rbs_txn_accum_map ('
1396: || 'txn_accum_header_id,'

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

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

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

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

Line 1458: pa_debug.reset_curr_function;

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

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

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

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

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

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

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

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

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

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

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

Line 1513: pa_debug.reset_curr_function;

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

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

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

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

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

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

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

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

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

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

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

Line 1637: pa_debug.reset_curr_function;

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

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

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

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

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

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

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

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

1774:
1775: END LOOP;
1776:
1777: IF g_debug_mode = 'Y' THEN
1778: pa_debug.g_err_stage:= 'Exiting map_rbs_txn' ;
1779: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1780: pa_debug.reset_curr_function;
1781: END IF;
1782:

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

1775: END LOOP;
1776:
1777: IF g_debug_mode = 'Y' THEN
1778: pa_debug.g_err_stage:= 'Exiting map_rbs_txn' ;
1779: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1780: pa_debug.reset_curr_function;
1781: END IF;
1782:
1783: EXCEPTION WHEN OTHERS THEN /* Added the exception block for bug #6377425 */

Line 1780: pa_debug.reset_curr_function;

1776:
1777: IF g_debug_mode = 'Y' THEN
1778: pa_debug.g_err_stage:= 'Exiting map_rbs_txn' ;
1779: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1780: pa_debug.reset_curr_function;
1781: END IF;
1782:
1783: EXCEPTION WHEN OTHERS THEN /* Added the exception block for bug #6377425 */
1784:

Line 1793: 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) ;

1789: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'
1790: ,p_procedure_name => 'map_rbs_txn');
1791:
1792: IF g_debug_mode = 'Y' THEN
1793: 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) ;
1794: Pa_Debug.WRITE(g_module_name, Pa_Debug.g_err_stage,5);
1795: Pa_Debug.reset_curr_function;
1796: END IF;
1797:

Line 1794: Pa_Debug.WRITE(g_module_name, Pa_Debug.g_err_stage,5);

1790: ,p_procedure_name => 'map_rbs_txn');
1791:
1792: IF g_debug_mode = 'Y' THEN
1793: 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) ;
1794: Pa_Debug.WRITE(g_module_name, Pa_Debug.g_err_stage,5);
1795: Pa_Debug.reset_curr_function;
1796: END IF;
1797:
1798: RAISE;

Line 1795: Pa_Debug.reset_curr_function;

1791:
1792: IF g_debug_mode = 'Y' THEN
1793: 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) ;
1794: Pa_Debug.WRITE(g_module_name, Pa_Debug.g_err_stage,5);
1795: Pa_Debug.reset_curr_function;
1796: END IF;
1797:
1798: RAISE;
1799:

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

1846: Pji_Pjp_Fp_Curr_Wrap.print_time( ' l_process = ' || l_process );
1847: Pji_Pjp_Fp_Curr_Wrap.print_time( ' l_extraction_type = ' || l_extraction_type );
1848:
1849: IF g_debug_mode = 'Y' THEN
1850: PA_DEBUG.set_curr_function( p_function => 'map_rbs_actuals'
1851: ,p_debug_mode => g_debug_mode );
1852: pa_debug.g_err_stage:= 'Inside map_rbs_actuals : extrn type = ' || l_extraction_type ;
1853: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1854: END IF;

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

1848:
1849: IF g_debug_mode = 'Y' THEN
1850: PA_DEBUG.set_curr_function( p_function => 'map_rbs_actuals'
1851: ,p_debug_mode => g_debug_mode );
1852: pa_debug.g_err_stage:= 'Inside map_rbs_actuals : extrn type = ' || l_extraction_type ;
1853: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1854: END IF;
1855:
1856: DELETE pa_rbs_map_tmp1 ;

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

1849: IF g_debug_mode = 'Y' THEN
1850: PA_DEBUG.set_curr_function( p_function => 'map_rbs_actuals'
1851: ,p_debug_mode => g_debug_mode );
1852: pa_debug.g_err_stage:= 'Inside map_rbs_actuals : extrn type = ' || l_extraction_type ;
1853: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1854: END IF;
1855:
1856: DELETE pa_rbs_map_tmp1 ;
1857:

Line 2198: 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) ;

2194: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'
2195: ,p_procedure_name => 'map_rbs_txn');
2196:
2197: IF g_debug_mode = 'Y' THEN
2198: 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) ;
2199: Pa_Debug.WRITE(g_module_name, Pa_Debug.g_err_stage,5);
2200: Pa_Debug.reset_curr_function;
2201: END IF;
2202:

Line 2199: Pa_Debug.WRITE(g_module_name, Pa_Debug.g_err_stage,5);

2195: ,p_procedure_name => 'map_rbs_txn');
2196:
2197: IF g_debug_mode = 'Y' THEN
2198: 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) ;
2199: Pa_Debug.WRITE(g_module_name, Pa_Debug.g_err_stage,5);
2200: Pa_Debug.reset_curr_function;
2201: END IF;
2202:
2203: ROLLBACK TO map_rbs_txn;

Line 2200: Pa_Debug.reset_curr_function;

2196:
2197: IF g_debug_mode = 'Y' THEN
2198: 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) ;
2199: Pa_Debug.WRITE(g_module_name, Pa_Debug.g_err_stage,5);
2200: Pa_Debug.reset_curr_function;
2201: END IF;
2202:
2203: ROLLBACK TO map_rbs_txn;
2204: RAISE; -- Bug#5223360 - RBS mapping Errors will not get suppressed

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

2209:
2210: IF g_debug_mode = 'Y' THEN
2211:
2212: select count(*) into l_out from PA_RBS_PLANS_OUT_TMP;
2213: pa_debug.g_err_stage:= ' Number of rows in plans_out after map_rbs_txn ' ||l_out;
2214: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2215:
2216: pa_debug.g_err_stage:= 'Exiting map_rbs_actuals' ;
2217: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

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

2210: IF g_debug_mode = 'Y' THEN
2211:
2212: select count(*) into l_out from PA_RBS_PLANS_OUT_TMP;
2213: pa_debug.g_err_stage:= ' Number of rows in plans_out after map_rbs_txn ' ||l_out;
2214: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2215:
2216: pa_debug.g_err_stage:= 'Exiting map_rbs_actuals' ;
2217: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2218: pa_debug.reset_curr_function;

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

2212: select count(*) into l_out from PA_RBS_PLANS_OUT_TMP;
2213: pa_debug.g_err_stage:= ' Number of rows in plans_out after map_rbs_txn ' ||l_out;
2214: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2215:
2216: pa_debug.g_err_stage:= 'Exiting map_rbs_actuals' ;
2217: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2218: pa_debug.reset_curr_function;
2219:
2220:

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

2213: pa_debug.g_err_stage:= ' Number of rows in plans_out after map_rbs_txn ' ||l_out;
2214: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2215:
2216: pa_debug.g_err_stage:= 'Exiting map_rbs_actuals' ;
2217: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2218: pa_debug.reset_curr_function;
2219:
2220:
2221: END IF;

Line 2218: pa_debug.reset_curr_function;

2214: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2215:
2216: pa_debug.g_err_stage:= 'Exiting map_rbs_actuals' ;
2217: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2218: pa_debug.reset_curr_function;
2219:
2220:
2221: END IF;
2222:

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

2229: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'
2230: ,p_procedure_name => 'map_rbs_actuals');
2231:
2232: IF g_debug_mode = 'Y' THEN
2233: pa_debug.g_err_stage:='Unexpected Error inside pa_rbs_mapping.map_rbs_actuals '|| nvl(l_msg_data, SQLERRM) ;
2234: pa_debug.write(g_module_name, pa_debug.g_err_stage,5);
2235: pa_debug.reset_curr_function;
2236: END IF;
2237: raise;

Line 2234: pa_debug.write(g_module_name, pa_debug.g_err_stage,5);

2230: ,p_procedure_name => 'map_rbs_actuals');
2231:
2232: IF g_debug_mode = 'Y' THEN
2233: pa_debug.g_err_stage:='Unexpected Error inside pa_rbs_mapping.map_rbs_actuals '|| nvl(l_msg_data, SQLERRM) ;
2234: pa_debug.write(g_module_name, pa_debug.g_err_stage,5);
2235: pa_debug.reset_curr_function;
2236: END IF;
2237: raise;
2238: END;

Line 2235: pa_debug.reset_curr_function;

2231:
2232: IF g_debug_mode = 'Y' THEN
2233: pa_debug.g_err_stage:='Unexpected Error inside pa_rbs_mapping.map_rbs_actuals '|| nvl(l_msg_data, SQLERRM) ;
2234: pa_debug.write(g_module_name, pa_debug.g_err_stage,5);
2235: pa_debug.reset_curr_function;
2236: END IF;
2237: raise;
2238: END;
2239:

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

2269:
2270: x_return_status := FND_API.G_RET_STS_SUCCESS;
2271:
2272: IF g_debug_mode = 'Y' THEN
2273: PA_DEBUG.set_curr_function( p_function => 'map_rbs_plans'
2274: ,p_debug_mode => g_debug_mode );
2275: pa_debug.g_err_stage:= 'Inside map_rbs_plans : p_rbs_version_id = ' || p_rbs_version_id ;
2276: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2277: END IF;

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

2271:
2272: IF g_debug_mode = 'Y' THEN
2273: PA_DEBUG.set_curr_function( p_function => 'map_rbs_plans'
2274: ,p_debug_mode => g_debug_mode );
2275: pa_debug.g_err_stage:= 'Inside map_rbs_plans : p_rbs_version_id = ' || p_rbs_version_id ;
2276: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2277: END IF;
2278:
2279: l_tmpcnt :=0;

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

2272: IF g_debug_mode = 'Y' THEN
2273: PA_DEBUG.set_curr_function( p_function => 'map_rbs_plans'
2274: ,p_debug_mode => g_debug_mode );
2275: pa_debug.g_err_stage:= 'Inside map_rbs_plans : p_rbs_version_id = ' || p_rbs_version_id ;
2276: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2277: END IF;
2278:
2279: l_tmpcnt :=0;
2280:

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

2280:
2281: IF p_rbs_version_id IS NOT NULL THEN
2282:
2283: IF g_debug_mode = 'Y' THEN
2284: pa_debug.g_err_stage:= 'rbs version is provided';
2285: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2286: END IF;
2287:
2288: --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 2285: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

2281: IF p_rbs_version_id IS NOT NULL THEN
2282:
2283: IF g_debug_mode = 'Y' THEN
2284: pa_debug.g_err_stage:= 'rbs version is provided';
2285: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2286: END IF;
2287:
2288: --check whether headers are present in pji_fp_txn_accum_header or not, if not then create them in pji_fp_txn_accum_header
2289: --assuming that source_id is populated in pji_fp_txn_accum_header

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

2453: END IF;
2454: /*bug#4770784, end here */
2455:
2456: IF g_debug_mode = 'Y' THEN
2457: pa_debug.g_err_stage:= 'accum headers are inserted';
2458: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2459: END IF;
2460:
2461: DELETE PA_RBS_PLANS_OUT_TMP;

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

2454: /*bug#4770784, end here */
2455:
2456: IF g_debug_mode = 'Y' THEN
2457: pa_debug.g_err_stage:= 'accum headers are inserted';
2458: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2459: END IF;
2460:
2461: DELETE PA_RBS_PLANS_OUT_TMP;
2462: INSERT INTO PA_RBS_PLANS_OUT_TMP

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

2614:
2615:
2616:
2617: IF g_debug_mode = 'Y' THEN
2618: pa_debug.g_err_stage:= 'calling map_rbs_txn for rbs version = '||p_rbs_version_id;
2619: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2620: END IF;
2621:
2622: -- Bug#5503706 Start

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

2615:
2616:
2617: IF g_debug_mode = 'Y' THEN
2618: pa_debug.g_err_stage:= 'calling map_rbs_txn for rbs version = '||p_rbs_version_id;
2619: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2620: END IF;
2621:
2622: -- Bug#5503706 Start
2623: select count(*) into l_tmpcnt from PA_RBS_MAP_TMP2;

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

2622: -- Bug#5503706 Start
2623: select count(*) into l_tmpcnt from PA_RBS_MAP_TMP2;
2624:
2625: IF g_debug_mode = 'Y' THEN
2626: pa_debug.g_err_stage:= 'The number of rows in pa_rbs_map_tmp2 table = '||l_tmpcnt;
2627: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2628: END IF;
2629:
2630: if l_tmpcnt >0 then

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

2623: select count(*) into l_tmpcnt from PA_RBS_MAP_TMP2;
2624:
2625: IF g_debug_mode = 'Y' THEN
2626: pa_debug.g_err_stage:= 'The number of rows in pa_rbs_map_tmp2 table = '||l_tmpcnt;
2627: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2628: END IF;
2629:
2630: if l_tmpcnt >0 then
2631: map_rbs_txn(p_rbs_version_id,l_return_status,l_msg_count,l_msg_data);

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

2638: AND g_denorm_refresh = 'Y'
2639: THEN
2640:
2641: IF g_debug_mode = 'Y' THEN
2642: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Denorm.POPULATE_RBS_DENORM' ;
2643: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2644: pa_debug.reset_curr_function;
2645: END IF;
2646:

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

2639: THEN
2640:
2641: IF g_debug_mode = 'Y' THEN
2642: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Denorm.POPULATE_RBS_DENORM' ;
2643: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2644: pa_debug.reset_curr_function;
2645: END IF;
2646:
2647: Pji_Pjp_Sum_Denorm.POPULATE_RBS_DENORM(

Line 2644: pa_debug.reset_curr_function;

2640:
2641: IF g_debug_mode = 'Y' THEN
2642: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Denorm.POPULATE_RBS_DENORM' ;
2643: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2644: pa_debug.reset_curr_function;
2645: END IF;
2646:
2647: Pji_Pjp_Sum_Denorm.POPULATE_RBS_DENORM(
2648: p_worker_id => 1,

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

2649: p_denorm_type => 'RBS',
2650: p_rbs_version_id => p_rbs_version_id) ;
2651:
2652: IF g_debug_mode = 'Y' THEN
2653: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Rollup.set_online_context' ;
2654: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2655: pa_debug.reset_curr_function;
2656: END IF;
2657:

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

2650: p_rbs_version_id => p_rbs_version_id) ;
2651:
2652: IF g_debug_mode = 'Y' THEN
2653: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Rollup.set_online_context' ;
2654: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2655: pa_debug.reset_curr_function;
2656: END IF;
2657:
2658: Pji_Pjp_Sum_Rollup.set_online_context (

Line 2655: pa_debug.reset_curr_function;

2651:
2652: IF g_debug_mode = 'Y' THEN
2653: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Rollup.set_online_context' ;
2654: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2655: pa_debug.reset_curr_function;
2656: END IF;
2657:
2658: Pji_Pjp_Sum_Rollup.set_online_context (
2659: p_event_id => NULL,

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

2667: p_new_struct_version => NULL,
2668: p_rbs_version => p_rbs_version_id );
2669:
2670: IF g_debug_mode = 'Y' THEN
2671: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Rollup.UPDATE_RBS_DENORM' ;
2672: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2673: pa_debug.reset_curr_function;
2674: END IF;
2675:

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

2668: p_rbs_version => p_rbs_version_id );
2669:
2670: IF g_debug_mode = 'Y' THEN
2671: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Rollup.UPDATE_RBS_DENORM' ;
2672: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2673: pa_debug.reset_curr_function;
2674: END IF;
2675:
2676: Pji_Pjp_Sum_Rollup.UPDATE_RBS_DENORM;

Line 2673: pa_debug.reset_curr_function;

2669:
2670: IF g_debug_mode = 'Y' THEN
2671: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Rollup.UPDATE_RBS_DENORM' ;
2672: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2673: pa_debug.reset_curr_function;
2674: END IF;
2675:
2676: Pji_Pjp_Sum_Rollup.UPDATE_RBS_DENORM;
2677:

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

2675:
2676: Pji_Pjp_Sum_Rollup.UPDATE_RBS_DENORM;
2677:
2678: IF g_debug_mode = 'Y' THEN
2679: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Denorm.cleanup_rbs_denorm' ;
2680: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2681: pa_debug.reset_curr_function;
2682: END IF;
2683:

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

2676: Pji_Pjp_Sum_Rollup.UPDATE_RBS_DENORM;
2677:
2678: IF g_debug_mode = 'Y' THEN
2679: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Denorm.cleanup_rbs_denorm' ;
2680: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2681: pa_debug.reset_curr_function;
2682: END IF;
2683:
2684: Pji_Pjp_Sum_Denorm.cleanup_rbs_denorm(

Line 2681: pa_debug.reset_curr_function;

2677:
2678: IF g_debug_mode = 'Y' THEN
2679: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Denorm.cleanup_rbs_denorm' ;
2680: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2681: pa_debug.reset_curr_function;
2682: END IF;
2683:
2684: Pji_Pjp_Sum_Denorm.cleanup_rbs_denorm(
2685: p_worker_id => 1,

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

2700:
2701: ELSE ---------------------- if rbs structure version id is not provided, header and source_id is populated
2702:
2703: IF g_debug_mode = 'Y' THEN
2704: pa_debug.g_err_stage:= 'rbs version is not provided';
2705: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2706: END IF;
2707:
2708: DELETE pa_rbs_map_tmp1 ;

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

2701: ELSE ---------------------- if rbs structure version id is not provided, header and source_id is populated
2702:
2703: IF g_debug_mode = 'Y' THEN
2704: pa_debug.g_err_stage:= 'rbs version is not provided';
2705: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2706: END IF;
2707:
2708: DELETE pa_rbs_map_tmp1 ;
2709:

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

2775: tmp1.txn_accum_header_id = tmp.txn_accum_header_id AND
2776: tmp.rowid = (select max(rowid) from PA_RBS_PLANS_IN_TMP where txn_accum_header_id = tmp.txn_accum_header_id);
2777:
2778: IF g_debug_mode = 'Y' THEN
2779: pa_debug.g_err_stage:= 'calling map_rbs_txn for rbs version = '||l_rbs_struct_version_id(i) ;
2780: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2781: END IF;
2782:
2783: -- Bug#5503706 Start

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

2776: tmp.rowid = (select max(rowid) from PA_RBS_PLANS_IN_TMP where txn_accum_header_id = tmp.txn_accum_header_id);
2777:
2778: IF g_debug_mode = 'Y' THEN
2779: pa_debug.g_err_stage:= 'calling map_rbs_txn for rbs version = '||l_rbs_struct_version_id(i) ;
2780: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2781: END IF;
2782:
2783: -- Bug#5503706 Start
2784: select count(*) into l_tmpcnt from PA_RBS_MAP_TMP2;

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

2783: -- Bug#5503706 Start
2784: select count(*) into l_tmpcnt from PA_RBS_MAP_TMP2;
2785:
2786: IF g_debug_mode = 'Y' THEN
2787: pa_debug.g_err_stage:= 'The number of rows in pa_rbs_map_tmp2 table = '||l_tmpcnt;
2788: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2789: END IF;
2790:
2791: if l_tmpcnt >0 then

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

2784: select count(*) into l_tmpcnt from PA_RBS_MAP_TMP2;
2785:
2786: IF g_debug_mode = 'Y' THEN
2787: pa_debug.g_err_stage:= 'The number of rows in pa_rbs_map_tmp2 table = '||l_tmpcnt;
2788: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2789: END IF;
2790:
2791: if l_tmpcnt >0 then
2792: map_rbs_txn(l_rbs_struct_version_id(i),l_return_status,l_msg_count,l_msg_data);

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

2798: IF NVL(PJI_UTILS.GET_PARAMETER('PJI_FPM_UPGRADE'), 'P') = 'C'
2799: AND g_denorm_refresh = 'Y' THEN
2800:
2801: IF g_debug_mode = 'Y' THEN
2802: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Denorm.POPULATE_RBS_DENORM' ;
2803: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2804: pa_debug.reset_curr_function;
2805: END IF;
2806:

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

2799: AND g_denorm_refresh = 'Y' THEN
2800:
2801: IF g_debug_mode = 'Y' THEN
2802: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Denorm.POPULATE_RBS_DENORM' ;
2803: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2804: pa_debug.reset_curr_function;
2805: END IF;
2806:
2807: Pji_Pjp_Sum_Denorm.POPULATE_RBS_DENORM(

Line 2804: pa_debug.reset_curr_function;

2800:
2801: IF g_debug_mode = 'Y' THEN
2802: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Denorm.POPULATE_RBS_DENORM' ;
2803: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2804: pa_debug.reset_curr_function;
2805: END IF;
2806:
2807: Pji_Pjp_Sum_Denorm.POPULATE_RBS_DENORM(
2808: p_worker_id => 1,

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

2809: p_denorm_type => 'RBS',
2810: p_rbs_version_id => p_rbs_version_id) ;
2811:
2812: IF g_debug_mode = 'Y' THEN
2813: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Rollup.set_online_context' ;
2814: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2815: pa_debug.reset_curr_function;
2816: END IF;
2817:

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

2810: p_rbs_version_id => p_rbs_version_id) ;
2811:
2812: IF g_debug_mode = 'Y' THEN
2813: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Rollup.set_online_context' ;
2814: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2815: pa_debug.reset_curr_function;
2816: END IF;
2817:
2818: Pji_Pjp_Sum_Rollup.set_online_context (

Line 2815: pa_debug.reset_curr_function;

2811:
2812: IF g_debug_mode = 'Y' THEN
2813: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Rollup.set_online_context' ;
2814: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2815: pa_debug.reset_curr_function;
2816: END IF;
2817:
2818: Pji_Pjp_Sum_Rollup.set_online_context (
2819: p_event_id => NULL,

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

2827: p_new_struct_version => NULL,
2828: p_rbs_version => p_rbs_version_id );
2829:
2830: IF g_debug_mode = 'Y' THEN
2831: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Rollup.UPDATE_RBS_DENORM' ;
2832: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2833: pa_debug.reset_curr_function;
2834: END IF;
2835:

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

2828: p_rbs_version => p_rbs_version_id );
2829:
2830: IF g_debug_mode = 'Y' THEN
2831: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Rollup.UPDATE_RBS_DENORM' ;
2832: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2833: pa_debug.reset_curr_function;
2834: END IF;
2835:
2836: Pji_Pjp_Sum_Rollup.UPDATE_RBS_DENORM;

Line 2833: pa_debug.reset_curr_function;

2829:
2830: IF g_debug_mode = 'Y' THEN
2831: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Rollup.UPDATE_RBS_DENORM' ;
2832: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2833: pa_debug.reset_curr_function;
2834: END IF;
2835:
2836: Pji_Pjp_Sum_Rollup.UPDATE_RBS_DENORM;
2837:

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

2835:
2836: Pji_Pjp_Sum_Rollup.UPDATE_RBS_DENORM;
2837:
2838: IF g_debug_mode = 'Y' THEN
2839: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Denorm.cleanup_rbs_denorm' ;
2840: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2841: pa_debug.reset_curr_function;
2842: END IF;
2843:

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

2836: Pji_Pjp_Sum_Rollup.UPDATE_RBS_DENORM;
2837:
2838: IF g_debug_mode = 'Y' THEN
2839: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Denorm.cleanup_rbs_denorm' ;
2840: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2841: pa_debug.reset_curr_function;
2842: END IF;
2843:
2844: Pji_Pjp_Sum_Denorm.cleanup_rbs_denorm(

Line 2841: pa_debug.reset_curr_function;

2837:
2838: IF g_debug_mode = 'Y' THEN
2839: pa_debug.g_err_stage:= 'Calling Pji_Pjp_Sum_Denorm.cleanup_rbs_denorm' ;
2840: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2841: pa_debug.reset_curr_function;
2842: END IF;
2843:
2844: Pji_Pjp_Sum_Denorm.cleanup_rbs_denorm(
2845: p_worker_id => 1,

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

2854:
2855: END IF;
2856:
2857: IF g_debug_mode = 'Y' THEN
2858: pa_debug.g_err_stage:= 'Exiting map_rbs_plans ' ;
2859: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2860: pa_debug.reset_curr_function;
2861:
2862: select count(*) into l_out from PA_RBS_PLANS_OUT_TMP;

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

2855: END IF;
2856:
2857: IF g_debug_mode = 'Y' THEN
2858: pa_debug.g_err_stage:= 'Exiting map_rbs_plans ' ;
2859: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2860: pa_debug.reset_curr_function;
2861:
2862: select count(*) into l_out from PA_RBS_PLANS_OUT_TMP;
2863: pa_debug.g_err_stage:= ' Number of rows in plans_out after map_rbs_txn ' ||l_out;

Line 2860: pa_debug.reset_curr_function;

2856:
2857: IF g_debug_mode = 'Y' THEN
2858: pa_debug.g_err_stage:= 'Exiting map_rbs_plans ' ;
2859: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2860: pa_debug.reset_curr_function;
2861:
2862: select count(*) into l_out from PA_RBS_PLANS_OUT_TMP;
2863: pa_debug.g_err_stage:= ' Number of rows in plans_out after map_rbs_txn ' ||l_out;
2864: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

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

2859: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2860: pa_debug.reset_curr_function;
2861:
2862: select count(*) into l_out from PA_RBS_PLANS_OUT_TMP;
2863: pa_debug.g_err_stage:= ' Number of rows in plans_out after map_rbs_txn ' ||l_out;
2864: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2865: pa_debug.reset_curr_function;
2866:
2867: END IF;

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

2860: pa_debug.reset_curr_function;
2861:
2862: select count(*) into l_out from PA_RBS_PLANS_OUT_TMP;
2863: pa_debug.g_err_stage:= ' Number of rows in plans_out after map_rbs_txn ' ||l_out;
2864: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2865: pa_debug.reset_curr_function;
2866:
2867: END IF;
2868:

Line 2865: pa_debug.reset_curr_function;

2861:
2862: select count(*) into l_out from PA_RBS_PLANS_OUT_TMP;
2863: pa_debug.g_err_stage:= ' Number of rows in plans_out after map_rbs_txn ' ||l_out;
2864: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2865: pa_debug.reset_curr_function;
2866:
2867: END IF;
2868:
2869: EXCEPTION

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

2874: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'
2875: ,p_procedure_name => 'map_rbs_plans');
2876:
2877: IF g_debug_mode = 'Y' THEN
2878: pa_debug.g_err_stage:='Unexpected Error inside pa_rbs_mapping.map_rbs_plans '|| nvl(l_msg_data, SQLERRM) ;
2879: pa_debug.write(g_module_name, pa_debug.g_err_stage,5);
2880: pa_debug.reset_curr_function;
2881: END IF;
2882: raise;

Line 2879: pa_debug.write(g_module_name, pa_debug.g_err_stage,5);

2875: ,p_procedure_name => 'map_rbs_plans');
2876:
2877: IF g_debug_mode = 'Y' THEN
2878: pa_debug.g_err_stage:='Unexpected Error inside pa_rbs_mapping.map_rbs_plans '|| nvl(l_msg_data, SQLERRM) ;
2879: pa_debug.write(g_module_name, pa_debug.g_err_stage,5);
2880: pa_debug.reset_curr_function;
2881: END IF;
2882: raise;
2883: END;

Line 2880: pa_debug.reset_curr_function;

2876:
2877: IF g_debug_mode = 'Y' THEN
2878: pa_debug.g_err_stage:='Unexpected Error inside pa_rbs_mapping.map_rbs_plans '|| nvl(l_msg_data, SQLERRM) ;
2879: pa_debug.write(g_module_name, pa_debug.g_err_stage,5);
2880: pa_debug.reset_curr_function;
2881: END IF;
2882: raise;
2883: END;
2884:

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

2897:
2898: x_return_status := FND_API.G_RET_STS_SUCCESS;
2899:
2900: IF g_debug_mode = 'Y' THEN
2901: PA_DEBUG.set_curr_function( p_function => 'create_res_type_numeric_id'
2902: ,p_debug_mode => g_debug_mode );
2903: pa_debug.g_err_stage:= 'Inside create_res_type_numeric_id';
2904: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2905: END IF;

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

2899:
2900: IF g_debug_mode = 'Y' THEN
2901: PA_DEBUG.set_curr_function( p_function => 'create_res_type_numeric_id'
2902: ,p_debug_mode => g_debug_mode );
2903: pa_debug.g_err_stage:= 'Inside create_res_type_numeric_id';
2904: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2905: END IF;
2906:
2907: IF l_resource_name = 'EMP_APL' THEN

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

2900: IF g_debug_mode = 'Y' THEN
2901: PA_DEBUG.set_curr_function( p_function => 'create_res_type_numeric_id'
2902: ,p_debug_mode => g_debug_mode );
2903: pa_debug.g_err_stage:= 'Inside create_res_type_numeric_id';
2904: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2905: END IF;
2906:
2907: IF l_resource_name = 'EMP_APL' THEN
2908: l_resource_name := 'EMP' ;

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

2947: sysdate) ;
2948: END IF;
2949:
2950: IF g_debug_mode = 'Y' THEN
2951: pa_debug.g_err_stage:= 'Exiting create_res_type_numeric_id' ;
2952: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2953: pa_debug.reset_curr_function;
2954: END IF;
2955:

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

2948: END IF;
2949:
2950: IF g_debug_mode = 'Y' THEN
2951: pa_debug.g_err_stage:= 'Exiting create_res_type_numeric_id' ;
2952: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2953: pa_debug.reset_curr_function;
2954: END IF;
2955:
2956: EXCEPTION

Line 2953: pa_debug.reset_curr_function;

2949:
2950: IF g_debug_mode = 'Y' THEN
2951: pa_debug.g_err_stage:= 'Exiting create_res_type_numeric_id' ;
2952: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2953: pa_debug.reset_curr_function;
2954: END IF;
2955:
2956: EXCEPTION
2957: WHEN OTHERS THEN

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

2960: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'
2961: ,p_procedure_name => 'create_res_type_numeric_id');
2962:
2963: IF g_debug_mode = 'Y' THEN
2964: pa_debug.g_err_stage:='Unexpected Error inside pa_rbs_mapping.create_res_type_numeric_id '||SQLERRM;
2965: pa_debug.write(g_module_name, pa_debug.g_err_stage,5);
2966: pa_debug.reset_curr_function;
2967: END IF;
2968: raise;

Line 2965: pa_debug.write(g_module_name, pa_debug.g_err_stage,5);

2961: ,p_procedure_name => 'create_res_type_numeric_id');
2962:
2963: IF g_debug_mode = 'Y' THEN
2964: pa_debug.g_err_stage:='Unexpected Error inside pa_rbs_mapping.create_res_type_numeric_id '||SQLERRM;
2965: pa_debug.write(g_module_name, pa_debug.g_err_stage,5);
2966: pa_debug.reset_curr_function;
2967: END IF;
2968: raise;
2969: END;

Line 2966: pa_debug.reset_curr_function;

2962:
2963: IF g_debug_mode = 'Y' THEN
2964: pa_debug.g_err_stage:='Unexpected Error inside pa_rbs_mapping.create_res_type_numeric_id '||SQLERRM;
2965: pa_debug.write(g_module_name, pa_debug.g_err_stage,5);
2966: pa_debug.reset_curr_function;
2967: END IF;
2968: raise;
2969: END;
2970:

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

3017: BEGIN
3018:
3019:
3020: IF g_debug_mode = 'Y' THEN
3021: PA_DEBUG.set_curr_function( p_function => 'insert_rule'
3022: ,p_debug_mode => g_debug_mode );
3023: pa_debug.g_err_stage:= 'Inside insert_rule';
3024: pa_debug.g_err_stage:= 'Inside insert_rule- rbs_version_id :'|| rbs_version_id||' depth:'||depth;
3025: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

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

3019:
3020: IF g_debug_mode = 'Y' THEN
3021: PA_DEBUG.set_curr_function( p_function => 'insert_rule'
3022: ,p_debug_mode => g_debug_mode );
3023: pa_debug.g_err_stage:= 'Inside insert_rule';
3024: pa_debug.g_err_stage:= 'Inside insert_rule- rbs_version_id :'|| rbs_version_id||' depth:'||depth;
3025: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3026: END IF;
3027:

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

3020: IF g_debug_mode = 'Y' THEN
3021: PA_DEBUG.set_curr_function( p_function => 'insert_rule'
3022: ,p_debug_mode => g_debug_mode );
3023: pa_debug.g_err_stage:= 'Inside insert_rule';
3024: pa_debug.g_err_stage:= 'Inside insert_rule- rbs_version_id :'|| rbs_version_id||' depth:'||depth;
3025: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3026: END IF;
3027:
3028: col_sql_clause := '' ;

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

3021: PA_DEBUG.set_curr_function( p_function => 'insert_rule'
3022: ,p_debug_mode => g_debug_mode );
3023: pa_debug.g_err_stage:= 'Inside insert_rule';
3024: pa_debug.g_err_stage:= 'Inside insert_rule- rbs_version_id :'|| rbs_version_id||' depth:'||depth;
3025: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3026: END IF;
3027:
3028: col_sql_clause := '' ;
3029: for i in 1..depth loop

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

3099:
3100:
3101:
3102: IF g_debug_mode = 'Y' THEN
3103: pa_debug.g_err_stage:= 'Exiting insert_rule' ;
3104: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3105: pa_debug.reset_curr_function;
3106: END IF;
3107:

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

3100:
3101:
3102: IF g_debug_mode = 'Y' THEN
3103: pa_debug.g_err_stage:= 'Exiting insert_rule' ;
3104: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3105: pa_debug.reset_curr_function;
3106: END IF;
3107:
3108:

Line 3105: pa_debug.reset_curr_function;

3101:
3102: IF g_debug_mode = 'Y' THEN
3103: pa_debug.g_err_stage:= 'Exiting insert_rule' ;
3104: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3105: pa_debug.reset_curr_function;
3106: END IF;
3107:
3108:
3109: END;

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

3302: called again and again without reset_curr_function to give rise to
3303: ORA-06502: PL/SQL: numeric or value error
3304:
3305: IF g_debug_mode = 'Y' THEN
3306: PA_DEBUG.set_curr_function( p_function => 'traverse_tree'
3307: ,p_debug_mode => g_debug_mode );
3308: pa_debug.g_err_stage:= 'Inside traverse_tree';
3309: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3310: END IF;

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

3304:
3305: IF g_debug_mode = 'Y' THEN
3306: PA_DEBUG.set_curr_function( p_function => 'traverse_tree'
3307: ,p_debug_mode => g_debug_mode );
3308: pa_debug.g_err_stage:= 'Inside traverse_tree';
3309: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3310: END IF;
3311:
3312: */

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

3305: IF g_debug_mode = 'Y' THEN
3306: PA_DEBUG.set_curr_function( p_function => 'traverse_tree'
3307: ,p_debug_mode => g_debug_mode );
3308: pa_debug.g_err_stage:= 'Inside traverse_tree';
3309: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3310: END IF;
3311:
3312: */
3313:

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

3346:
3347: end loop;
3348:
3349: IF g_debug_mode = 'Y' THEN
3350: pa_debug.g_err_stage:= 'Exiting traverse_tree' ;
3351: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3352: pa_debug.reset_curr_function;
3353: END IF;
3354:

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

3347: end loop;
3348:
3349: IF g_debug_mode = 'Y' THEN
3350: pa_debug.g_err_stage:= 'Exiting traverse_tree' ;
3351: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3352: pa_debug.reset_curr_function;
3353: END IF;
3354:
3355: END;

Line 3352: pa_debug.reset_curr_function;

3348:
3349: IF g_debug_mode = 'Y' THEN
3350: pa_debug.g_err_stage:= 'Exiting traverse_tree' ;
3351: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3352: pa_debug.reset_curr_function;
3353: END IF;
3354:
3355: END;
3356:

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

3379:
3380: x_return_status := FND_API.G_RET_STS_SUCCESS;
3381:
3382: IF g_debug_mode = 'Y' THEN
3383: PA_DEBUG.set_curr_function( p_function => 'create_mapping_rules'
3384: ,p_debug_mode => g_debug_mode );
3385: pa_debug.g_err_stage:= 'Inside create_mapping_rules- p_rbs_version_id :'|| p_rbs_version_id;
3386: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3387: END IF;

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

3381:
3382: IF g_debug_mode = 'Y' THEN
3383: PA_DEBUG.set_curr_function( p_function => 'create_mapping_rules'
3384: ,p_debug_mode => g_debug_mode );
3385: pa_debug.g_err_stage:= 'Inside create_mapping_rules- p_rbs_version_id :'|| p_rbs_version_id;
3386: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3387: END IF;
3388:
3389: select count(1) into l_count from dual

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

3382: IF g_debug_mode = 'Y' THEN
3383: PA_DEBUG.set_curr_function( p_function => 'create_mapping_rules'
3384: ,p_debug_mode => g_debug_mode );
3385: pa_debug.g_err_stage:= 'Inside create_mapping_rules- p_rbs_version_id :'|| p_rbs_version_id;
3386: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3387: END IF;
3388:
3389: select count(1) into l_count from dual
3390: where exists

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

3457:
3458: l_count_tmp1:=SQL%ROWCOUNT; --Bug#5248414
3459:
3460: IF g_debug_mode = 'Y' THEN
3461: PA_DEBUG.set_curr_function( p_function => 'create_mapping_rules'
3462: ,p_debug_mode => g_debug_mode );
3463: pa_debug.g_err_stage:= 'Inside create_mapping_rules- Inserts in Tmp1 :'||l_count_tmp1 ;
3464: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3465: END IF;

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

3459:
3460: IF g_debug_mode = 'Y' THEN
3461: PA_DEBUG.set_curr_function( p_function => 'create_mapping_rules'
3462: ,p_debug_mode => g_debug_mode );
3463: pa_debug.g_err_stage:= 'Inside create_mapping_rules- Inserts in Tmp1 :'||l_count_tmp1 ;
3464: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3465: END IF;
3466:
3467: IF l_count_tmp1 > 0 THEN --Bug#5248414

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

3460: IF g_debug_mode = 'Y' THEN
3461: PA_DEBUG.set_curr_function( p_function => 'create_mapping_rules'
3462: ,p_debug_mode => g_debug_mode );
3463: pa_debug.g_err_stage:= 'Inside create_mapping_rules- Inserts in Tmp1 :'||l_count_tmp1 ;
3464: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3465: END IF;
3466:
3467: IF l_count_tmp1 > 0 THEN --Bug#5248414
3468:

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

3488:
3489: END IF;
3490:
3491: IF g_debug_mode = 'Y' THEN
3492: pa_debug.g_err_stage:= 'Exiting create_mapping_rules' ;
3493: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3494: pa_debug.reset_curr_function;
3495: END IF;
3496:

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

3489: END IF;
3490:
3491: IF g_debug_mode = 'Y' THEN
3492: pa_debug.g_err_stage:= 'Exiting create_mapping_rules' ;
3493: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3494: pa_debug.reset_curr_function;
3495: END IF;
3496:
3497: EXCEPTION

Line 3494: pa_debug.reset_curr_function;

3490:
3491: IF g_debug_mode = 'Y' THEN
3492: pa_debug.g_err_stage:= 'Exiting create_mapping_rules' ;
3493: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3494: pa_debug.reset_curr_function;
3495: END IF;
3496:
3497: EXCEPTION
3498: WHEN OTHERS THEN

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

3501: x_msg_data := 'pa_rbs_mapping.create_mapping_rules.' || SQLERRM;
3502: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'
3503: ,p_procedure_name => 'create_mapping_rules');
3504: IF g_debug_mode = 'Y' THEN
3505: pa_debug.g_err_stage:='Unexpected Error inside pa_rbs_mapping.create_mapping_rules '||SQLERRM;
3506: pa_debug.write(g_module_name, pa_debug.g_err_stage,5);
3507: pa_debug.reset_curr_function;
3508:
3509: END IF;

Line 3506: pa_debug.write(g_module_name, pa_debug.g_err_stage,5);

3502: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'
3503: ,p_procedure_name => 'create_mapping_rules');
3504: IF g_debug_mode = 'Y' THEN
3505: pa_debug.g_err_stage:='Unexpected Error inside pa_rbs_mapping.create_mapping_rules '||SQLERRM;
3506: pa_debug.write(g_module_name, pa_debug.g_err_stage,5);
3507: pa_debug.reset_curr_function;
3508:
3509: END IF;
3510: raise;

Line 3507: pa_debug.reset_curr_function;

3503: ,p_procedure_name => 'create_mapping_rules');
3504: IF g_debug_mode = 'Y' THEN
3505: pa_debug.g_err_stage:='Unexpected Error inside pa_rbs_mapping.create_mapping_rules '||SQLERRM;
3506: pa_debug.write(g_module_name, pa_debug.g_err_stage,5);
3507: pa_debug.reset_curr_function;
3508:
3509: END IF;
3510: raise;
3511: END;