eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_PJP_SUM_DENORM dependencies on PJI_UTILS

Line 66: Pji_Utils.WRITE2LOG(

62: l_denorm_type := nvl(p_denorm_type, 'ALL');
63:
64: if g_pa_debug_mode = 'Y'
65: then
66: Pji_Utils.WRITE2LOG(
67: 'PJI_PJP '
68: || '- Begin: populate_xbs_denorm '
69: || '- p_worker_id = '
70: || p_worker_id

Line 91: l_fpm_upgrade := PJI_UTILS.GET_PARAMETER(

87: l_process,
88: 'EXTRACTION_TYPE'
89: );
90:
91: l_fpm_upgrade := PJI_UTILS.GET_PARAMETER(
92: 'PJI_FPM_UPGRADE'
93: );
94:
95: -- ----------------------------------------

Line 99: PJI_UTILS.WRITE2LOG(

95: -- ----------------------------------------
96:
97: if g_pa_debug_mode = 'Y'
98: then
99: PJI_UTILS.WRITE2LOG(
100: 'PJI_PJP - Variables -'
101: || ' l_process = '
102: || l_process
103: || ' l_extraction_type = '

Line 131: PJI_UTILS.WRITE2LOG(

127: -- delete WBS/XBS slices for specific struct_version_id -- ###delete###
128:
129: if g_pa_debug_mode = 'Y'
130: then
131: PJI_UTILS.WRITE2LOG(
132: 'PJI_PJP - Delete specific WBS/XBS slices -'
133: || ' p_wbs_version_id = '
134: || p_wbs_version_id,
135: null,

Line 164: PJI_UTILS.WRITE2LOG(

160: end;
161:
162: if g_pa_debug_mode = 'Y'
163: then
164: PJI_UTILS.WRITE2LOG(
165: 'PJI_PJP - Deleted specific PRG slices -'
166: || ' p_wbs_version_id = '
167: || p_wbs_version_id
168: || ' prg_group_id = '

Line 344: PJI_UTILS.WRITE2LOG(

340: ) LOOP
341:
342: if g_pa_debug_mode = 'Y'
343: then
344: PJI_UTILS.WRITE2LOG(
345: 'PJI_PJP - Delete specific WBS/XBS slices -'
346: || ' struct_version_id = '
347: || WBS_DELETE_NODE.event_object_id,
348: null,

Line 388: PJI_UTILS.WRITE2LOG(

384: ) LOOP
385:
386: if g_pa_debug_mode = 'Y'
387: then
388: PJI_UTILS.WRITE2LOG(
389: 'PJI_PJP - Program groups to be deleted -'
390: || ' prg_group = '
391: || PRG_DELETE_NODE.event_object_id,
392: null,

Line 416: PJI_UTILS.WRITE2LOG(

412: -- to specific projects in a group
413:
414: if g_pa_debug_mode = 'Y'
415: then
416: PJI_UTILS.WRITE2LOG(
417: 'PJI_PJP - Delete -'
418: || ' sup_project_id = '
419: || PRG_PROJECT_NODE.project_id,
420: null,

Line 466: PJI_UTILS.WRITE2LOG(

462: ) LOOP
463:
464: if g_pa_debug_mode = 'Y'
465: then
466: PJI_UTILS.WRITE2LOG(
467: 'PJI_PJP - Delete specific ALL slices -'
468: || ' sup_project_id = '
469: || PRG_PROJECT_NODE.project_id,
470: null,

Line 536: PJI_UTILS.WRITE2LOG(

532: -- -----------------------------------------------------
533:
534: if g_pa_debug_mode = 'Y'
535: then
536: PJI_UTILS.WRITE2LOG(
537: 'PJI_PJP - End: populate_xbs_denorm',
538: null,
539: g_msg_level_proc_call
540: );

Line 599: Pji_Utils.WRITE2LOG(

595: begin
596:
597: if g_pa_debug_mode = 'Y'
598: then
599: Pji_Utils.WRITE2LOG(
600: 'PJI_PJP '
601: || '- Begin: copy_xbs_denorm '
602: || '- p_worker_id = '
603: || p_worker_id

Line 1308: PJI_UTILS.WRITE2LOG(

1304: end IF;
1305: close c_version_exists;
1306: if g_pa_debug_mode = 'Y'
1307: then
1308: PJI_UTILS.WRITE2LOG(
1309: 'PJI_PJP - End: copy_xbs_denorm',
1310: null,
1311: g_msg_level_proc_call
1312: );

Line 1374: PJI_UTILS.WRITE2LOG(

1370:
1371:
1372: if g_pa_debug_mode = 'Y'
1373: then
1374: PJI_UTILS.WRITE2LOG(
1375: 'PJI_PJP - Begin: populate_rbs_denorm -'
1376: || ' p_worker_id = '
1377: || p_worker_id,
1378: null,

Line 1398: PJI_UTILS.WRITE2LOG(

1394: -- ----------------------------------------
1395:
1396: if g_pa_debug_mode = 'Y'
1397: then
1398: PJI_UTILS.WRITE2LOG(
1399: 'PJI_PJP - Variables -'
1400: || ' l_process = '
1401: || l_process
1402: || ' l_extraction_type = '

Line 1423: PJI_UTILS.WRITE2LOG(

1419: -- delete RBS slices for specific struct_version_id -- ###delete###
1420:
1421: if g_pa_debug_mode = 'Y'
1422: then
1423: PJI_UTILS.WRITE2LOG(
1424: 'PJI_PJP - Delete specific RBS slices -'
1425: || ' p_rbs_version_id = '
1426: || p_rbs_version_id,
1427: null,

Line 1499: l_fpm_upgrade := PJI_UTILS.GET_PARAMETER('PJI_FPM_UPGRADE');

1495: -- -------------------------------------------------------
1496: --Bug 4293903: In FULL mode if FPM upgrade is done treat as
1497: --incremental
1498: ----------------------------------------------------------
1499: l_fpm_upgrade := PJI_UTILS.GET_PARAMETER('PJI_FPM_UPGRADE');
1500:
1501: IF (nvl(l_fpm_upgrade,'P') = 'C' and
1502: l_extraction_type = 'FULL') THEN
1503:

Line 1659: PJI_UTILS.WRITE2LOG(

1655: end if;
1656:
1657: if g_pa_debug_mode = 'Y'
1658: then
1659: PJI_UTILS.WRITE2LOG(
1660: 'PJI_PJP - End: populate_rbs_denorm',
1661: null,
1662: g_msg_level_proc_call
1663: );

Line 1722: PJI_UTILS.WRITE2LOG(

1718:
1719:
1720: if g_pa_debug_mode = 'Y'
1721: then
1722: PJI_UTILS.WRITE2LOG(
1723: 'PJI_PJP - Begin: populate_rbs_denorm_upgrade -'
1724: || ' p_rbs_version_id = '
1725: || p_rbs_version_id,
1726: null,

Line 1820: PJI_UTILS.WRITE2LOG(

1816:
1817: -- -----------------------------------------------------
1818: if g_pa_debug_mode = 'Y'
1819: then
1820: PJI_UTILS.WRITE2LOG(
1821: 'PJI_PJP - End: populate_rbs_denorm_upgrade',
1822: null,
1823: g_msg_level_proc_call
1824: );

Line 1898: PJI_UTILS.WRITE2LOG(

1894:
1895:
1896: if g_pa_debug_mode = 'Y'
1897: then
1898: PJI_UTILS.WRITE2LOG(
1899: 'PJI_PJP - Begin: prg_denorm -'
1900: || ' p_worker_id = '
1901: || P_WORKER_ID
1902: || ' p_extraction_type = '

Line 2091: PJI_UTILS.WRITE2LOG(

2087:
2088: THEN
2089: if g_pa_debug_mode = 'Y'
2090: then
2091: PJI_UTILS.WRITE2LOG(
2092: 'PJI_PJP - PRG Group is null Data Bug - element_version_id = '
2093: || PRG_NODE.element_version_id,
2094: null,
2095: g_msg_level_data_bug

Line 2140: PJI_UTILS.WRITE2LOG(

2136:
2137:
2138: if g_pa_debug_mode = 'Y'
2139: then
2140: PJI_UTILS.WRITE2LOG(
2141: 'PJI_PJP - Inserting PRG node self -'
2142: || ' sup_id = '
2143: || PRG_NODE.element_version_id,
2144: null,

Line 2299: PJI_UTILS.WRITE2LOG(

2295:
2296:
2297: if g_pa_debug_mode = 'Y'
2298: then
2299: PJI_UTILS.WRITE2LOG(
2300: 'PJI_PJP - Inserting PRG node parent -'
2301: || ' element_version_id = '
2302: || PRG_NODE.element_version_id
2303: || ' sup_id = '

Line 2418: PJI_UTILS.WRITE2LOG(

2414:
2415:
2416: if g_pa_debug_mode = 'Y'
2417: then
2418: PJI_UTILS.WRITE2LOG(
2419: 'PJI_PJP - Inserting PRG node child -'
2420: || ' sup_id = '
2421: || l_prg_temp_parent
2422: || ' sub_emt_id = '

Line 2499: PJI_UTILS.WRITE2LOG(

2495: then
2496:
2497: if g_pa_debug_mode = 'Y'
2498: then
2499: PJI_UTILS.WRITE2LOG(
2500: 'PJI_PJP - Calling wbs_denorm - element_version_id = '
2501: || PRG_NODE.element_version_id,
2502: null,
2503: g_msg_level_low_detail

Line 2519: PJI_UTILS.WRITE2LOG(

2515: else
2516:
2517: if g_pa_debug_mode = 'Y'
2518: then
2519: PJI_UTILS.WRITE2LOG(
2520: 'PJI_PJP - Not calling wbs_denorm, because WBS node does not exist - element_version_id = '
2521: || PRG_NODE.element_version_id,
2522: null,
2523: g_msg_level_low_detail

Line 2545: PJI_UTILS.WRITE2LOG(

2541:
2542: -- ------------------------------------------
2543: if g_pa_debug_mode = 'Y'
2544: then
2545: PJI_UTILS.WRITE2LOG(
2546: 'PJI_PJP - End: prg_denorm',
2547: null,
2548: g_msg_level_proc_call
2549: );

Line 2617: PJI_UTILS.WRITE2LOG(

2613: -- (WBS node = task)
2614:
2615: if g_pa_debug_mode = 'Y'
2616: then
2617: PJI_UTILS.WRITE2LOG(
2618: 'PJI_PJP - Begin: wbs_denorm -'
2619: || ' p_worker_id = '
2620: || P_WORKER_ID
2621: || ' p_extraction_type = '

Line 2749: PJI_UTILS.WRITE2LOG(

2745:
2746:
2747: if g_pa_debug_mode = 'Y'
2748: then
2749: PJI_UTILS.WRITE2LOG(
2750: 'PJI_PJP - Inserting WBS node self - element_version_id = '
2751: || WBS_NODE.element_version_id,
2752: null,
2753: g_msg_level_low_detail

Line 2860: PJI_UTILS.WRITE2LOG(

2856:
2857:
2858: if g_pa_debug_mode = 'Y'
2859: then
2860: PJI_UTILS.WRITE2LOG(
2861: 'PJI_PJP - Inserting WBS node parent - l_wbs_temp_parent = '
2862: || l_wbs_temp_parent,
2863: null,
2864: g_msg_level_low_detail

Line 2974: PJI_UTILS.WRITE2LOG(

2970:
2971:
2972: if g_pa_debug_mode = 'Y'
2973: then
2974: PJI_UTILS.WRITE2LOG(
2975: 'PJI_PJP - Inserting WBS node child - sup_id = '
2976: || WBS_CHILDREN_NODE.sup_id,
2977: null,
2978: g_msg_level_low_detail

Line 3051: PJI_UTILS.WRITE2LOG(

3047:
3048:
3049: if g_pa_debug_mode = 'Y'
3050: then
3051: PJI_UTILS.WRITE2LOG(
3052: 'PJI_PJP - Inserting XBS node self - sup_id = '
3053: || P_WBS_VERSION_ID,
3054: null,
3055: g_msg_level_low_detail

Line 3117: PJI_UTILS.WRITE2LOG(

3113: -- ----------------------------------------------
3114:
3115: if g_pa_debug_mode = 'Y'
3116: then
3117: PJI_UTILS.WRITE2LOG(
3118: 'PJI_PJP - End: wbs_denorm',
3119: null,
3120: g_msg_level_proc_call
3121: );

Line 3195: PJI_UTILS.WRITE2LOG(

3191: -- (PRG node = program)
3192:
3193: if g_pa_debug_mode = 'Y'
3194: then
3195: PJI_UTILS.WRITE2LOG(
3196: 'PJI_PJP - Begin: prg_denorm_online -'
3197: || ' p_worker_id = '
3198: || P_WORKER_ID
3199: || ' p_extraction_type = '

Line 3248: PJI_UTILS.WRITE2LOG(

3244: LOOP
3245:
3246: if g_pa_debug_mode = 'Y'
3247: then
3248: PJI_UTILS.WRITE2LOG(
3249: 'PJI_PJP - PRG Inserts - l_prg_level_id = '
3250: || l_prg_level_id,
3251: null,
3252: g_msg_level_high_detail

Line 3286: PJI_UTILS.WRITE2LOG(

3282:
3283: THEN
3284: if g_pa_debug_mode = 'Y'
3285: then
3286: PJI_UTILS.WRITE2LOG(
3287: 'PJI_PJP - PRG Group is null Data Bug - element_version_id = '
3288: || PRG_NODE.element_version_id,
3289: null,
3290: g_msg_level_data_bug

Line 3333: PJI_UTILS.WRITE2LOG(

3329:
3330:
3331: if g_pa_debug_mode = 'Y'
3332: then
3333: PJI_UTILS.WRITE2LOG(
3334: 'PJI_PJP - Inserting PRG node self - sup_id = '
3335: || PRG_NODE.element_version_id,
3336: null,
3337: g_msg_level_low_detail

Line 3484: PJI_UTILS.WRITE2LOG(

3480:
3481:
3482: if g_pa_debug_mode = 'Y'
3483: then
3484: PJI_UTILS.WRITE2LOG(
3485: 'PJI_PJP - Inserting PRG node parent -'
3486: || ' element_version_id = '
3487: || PRG_NODE.element_version_id
3488: || ' sup_id = '

Line 3605: PJI_UTILS.WRITE2LOG(

3601:
3602:
3603: if g_pa_debug_mode = 'Y'
3604: then
3605: PJI_UTILS.WRITE2LOG(
3606: 'PJI_PJP - Inserting PRG node child -'
3607: || ' element_version_id = '
3608: || PRG_NODE.element_version_id
3609: || ' sup_id = '

Line 3686: PJI_UTILS.WRITE2LOG(

3682: -- -----------------------------------------
3683:
3684: if g_pa_debug_mode = 'Y'
3685: then
3686: PJI_UTILS.WRITE2LOG(
3687: 'PJI_PJP - End: prg_denorm_online',
3688: null,
3689: g_msg_level_proc_call
3690: );

Line 3761: PJI_UTILS.WRITE2LOG(

3757: -- (WBS node = task)
3758:
3759: if g_pa_debug_mode = 'Y'
3760: then
3761: PJI_UTILS.WRITE2LOG(
3762: 'PJI_PJP - Begin wbs_denorm_online -'
3763: || ' p_worker_id = '
3764: || P_WORKER_ID
3765: || ' p_extraction_type = '

Line 3799: PJI_UTILS.WRITE2LOG(

3795: THEN
3796:
3797: if g_pa_debug_mode = 'Y'
3798: then
3799: PJI_UTILS.WRITE2LOG(
3800: 'PJI_PJP - Wbs node as task does not exist - p_wbs_version_id = '
3801: || P_WBS_VERSION_ID,
3802: null,
3803: g_msg_level_low_detail

Line 3837: PJI_UTILS.WRITE2LOG(

3833: then
3834:
3835: if g_pa_debug_mode = 'Y'
3836: then
3837: PJI_UTILS.WRITE2LOG(
3838: 'PJI_PJP - Level is null Data Corruption - p_wbs_version_id = '
3839: || P_WBS_VERSION_ID,
3840: null,
3841: g_msg_level_data_corruption

Line 3892: PJI_UTILS.WRITE2LOG(

3888: LOOP
3889:
3890: if g_pa_debug_mode = 'Y'
3891: then
3892: PJI_UTILS.WRITE2LOG(
3893: 'PJI_PJP - WBS Inserts - l_wbs_level_id = '
3894: || l_wbs_level_id,
3895: null,
3896: g_msg_level_high_detail

Line 3963: PJI_UTILS.WRITE2LOG(

3959:
3960:
3961: if g_pa_debug_mode = 'Y'
3962: then
3963: PJI_UTILS.WRITE2LOG(
3964: 'PJI_PJP - Inserting WBS node self - element_version_id = '
3965: || WBS_NODE.element_version_id,
3966: null,
3967: g_msg_level_low_detail

Line 4099: PJI_UTILS.WRITE2LOG(

4095:
4096:
4097: if g_pa_debug_mode = 'Y'
4098: then
4099: PJI_UTILS.WRITE2LOG(
4100: 'PJI_PJP - Inserting WBS node parent - l_wbs_temp_parent = '
4101: || l_wbs_temp_parent,
4102: null,
4103: g_msg_level_low_detail

Line 4214: PJI_UTILS.WRITE2LOG(

4210:
4211:
4212: if g_pa_debug_mode = 'Y'
4213: then
4214: PJI_UTILS.WRITE2LOG(
4215: 'PJI_PJP - Inserting WBS node child - sup_id = '
4216: || WBS_CHILDREN_NODE.sup_id,
4217: null,
4218: g_msg_level_low_detail

Line 4279: PJI_UTILS.WRITE2LOG(

4275: ELSE
4276:
4277: if g_pa_debug_mode = 'Y'
4278: then
4279: PJI_UTILS.WRITE2LOG(
4280: 'PJI_PJP - Parent Data Corruption - element_version_id = '
4281: || WBS_NODE.element_version_id,
4282: null,
4283: g_msg_level_data_corruption

Line 4326: PJI_UTILS.WRITE2LOG(

4322:
4323:
4324: if g_pa_debug_mode = 'Y'
4325: then
4326: PJI_UTILS.WRITE2LOG(
4327: 'PJI_PJP - Inserting XBS node self - sup_id = '
4328: || P_WBS_VERSION_ID,
4329: null,
4330: g_msg_level_low_detail

Line 4385: PJI_UTILS.WRITE2LOG(

4381: else
4382:
4383: if g_pa_debug_mode = 'Y'
4384: then
4385: PJI_UTILS.WRITE2LOG(
4386: 'PJI_PJP - DATA BUG - element_version_id = '
4387: || WBS_NODE.element_version_id
4388: || ' struct_version_id = '
4389: || P_WBS_VERSION_ID,

Line 4412: PJI_UTILS.WRITE2LOG(

4408:
4409: -- -------------------------------------------------
4410: if g_pa_debug_mode = 'Y'
4411: then
4412: PJI_UTILS.WRITE2LOG(
4413: 'PJI_PJP - End: wbs_denorm_online',
4414: null,
4415: g_msg_level_proc_call
4416: );

Line 4480: PJI_UTILS.WRITE2LOG(

4476: -- (RBS node = resource)
4477:
4478: if g_pa_debug_mode = 'Y'
4479: then
4480: PJI_UTILS.WRITE2LOG(
4481: 'PJI_PJP - Begin: rbs_denorm -'
4482: || ' p_worker_id = '
4483: || P_WORKER_ID
4484: || ' p_extraction_type = '

Line 4547: PJI_UTILS.WRITE2LOG(

4543:
4544: else
4545: if g_pa_debug_mode = 'Y'
4546: then
4547: PJI_UTILS.WRITE2LOG(
4548: 'PJI_PJP - No maximum level found - p_rbs_version_id = '
4549: || P_RBS_VERSION_ID,
4550: null,
4551: g_msg_level_data_corruption

Line 4566: PJI_UTILS.WRITE2LOG(

4562: if l_rbs_level_id is null -- ###level_is_null###
4563: then
4564: if g_pa_debug_mode = 'Y'
4565: then
4566: PJI_UTILS.WRITE2LOG(
4567: 'PJI_PJP - Level is null Data Corruption - p_rbs_version_id = '
4568: || P_RBS_VERSION_ID,
4569: null,
4570: g_msg_level_data_corruption

Line 4587: PJI_UTILS.WRITE2LOG(

4583: LOOP
4584:
4585: if g_pa_debug_mode = 'Y'
4586: then
4587: PJI_UTILS.WRITE2LOG(
4588: 'PJI_PJP - RBS Inserts - l_rbs_level_id = '
4589: || l_rbs_level_id,
4590: null,
4591: g_msg_level_high_detail

Line 4757: PJI_UTILS.WRITE2LOG(

4753:
4754:
4755: if g_pa_debug_mode = 'Y'
4756: then
4757: PJI_UTILS.WRITE2LOG(
4758: 'PJI_PJP - Inserting RBS node self - rbs_element_id = '
4759: || RBS_NODE.rbs_element_id,
4760: null,
4761: g_msg_level_low_detail

Line 4858: PJI_UTILS.WRITE2LOG(

4854: end if;
4855:
4856: if g_pa_debug_mode = 'Y'
4857: then
4858: PJI_UTILS.WRITE2LOG(
4859: 'PJI_PJP - Inserting RBS node parent - l_rbs_temp_parent - = '
4860: || l_rbs_temp_parent,
4861: null,
4862: g_msg_level_low_detail

Line 4959: PJI_UTILS.WRITE2LOG(

4955:
4956:
4957: if g_pa_debug_mode = 'Y'
4958: then
4959: PJI_UTILS.WRITE2LOG(
4960: 'PJI_PJP - Inserting RBS node child - sup_id = '
4961: || RBS_CHILDREN_NODE.sup_id,
4962: null,
4963: g_msg_level_low_detail

Line 5023: PJI_UTILS.WRITE2LOG(

5019: ELSE
5020:
5021: if g_pa_debug_mode = 'Y'
5022: then
5023: PJI_UTILS.WRITE2LOG(
5024: 'PJI_PJP - Parent Data Corruption - rbs_element_id = '
5025: || RBS_NODE.rbs_element_id,
5026: null,
5027: g_msg_level_data_corruption

Line 5048: PJI_UTILS.WRITE2LOG(

5044:
5045: -- -----------------------------------------
5046: if g_pa_debug_mode = 'Y'
5047: then
5048: PJI_UTILS.WRITE2LOG(
5049: 'PJI_PJP - End: rbs_denorm',
5050: null,
5051: g_msg_level_proc_call
5052: );

Line 5124: PJI_UTILS.WRITE2LOG(

5120: -- (RBS node = resource)
5121:
5122: if g_pa_debug_mode = 'Y'
5123: then
5124: PJI_UTILS.WRITE2LOG(
5125: 'PJI_PJP - Begin: rbs_denorm_online -'
5126: || ' p_worker_id = '
5127: || P_WORKER_ID
5128: || ' p_extraction_type = '

Line 5166: PJI_UTILS.WRITE2LOG(

5162: if l_rbs_level_id is null -- ###level_is_null###
5163: then
5164: if g_pa_debug_mode = 'Y'
5165: then
5166: PJI_UTILS.WRITE2LOG(
5167: 'PJI_PJP - Level is null Data Corruption - p_rbs_version_id = '
5168: || P_RBS_VERSION_ID,
5169: null,
5170: g_msg_level_data_corruption

Line 5187: PJI_UTILS.WRITE2LOG(

5183: LOOP
5184:
5185: if g_pa_debug_mode = 'Y'
5186: then
5187: PJI_UTILS.WRITE2LOG(
5188: 'PJI_PJP - RBS Inserts - l_rbs_level_id = '
5189: || l_rbs_level_id,
5190: null,
5191: g_msg_level_high_detail

Line 5285: PJI_UTILS.WRITE2LOG(

5281:
5282:
5283: if g_pa_debug_mode = 'Y'
5284: then
5285: PJI_UTILS.WRITE2LOG(
5286: 'PJI_PJP - Inserting RBS node self - rbs_element_id = '
5287: || RBS_NODE.rbs_element_id,
5288: null,
5289: g_msg_level_low_detail

Line 5380: PJI_UTILS.WRITE2LOG(

5376: end if;
5377:
5378: if g_pa_debug_mode = 'Y'
5379: then
5380: PJI_UTILS.WRITE2LOG(
5381: 'PJI_PJP - Inserting RBS node parent - l_rbs_temp_parent - = '
5382: || l_rbs_temp_parent,
5383: null,
5384: g_msg_level_low_detail

Line 5501: PJI_UTILS.WRITE2LOG(

5497:
5498:
5499: if g_pa_debug_mode = 'Y'
5500: then
5501: PJI_UTILS.WRITE2LOG(
5502: 'PJI_PJP - Inserting RBS node child - sup_id = '
5503: || RBS_CHILDREN_NODE.sup_id,
5504: null,
5505: g_msg_level_low_detail

Line 5560: PJI_UTILS.WRITE2LOG(

5556: ELSE
5557:
5558: if g_pa_debug_mode = 'Y'
5559: then
5560: PJI_UTILS.WRITE2LOG(
5561: 'PJI_PJP - Parent Data Corruption - rbs_element_id = '
5562: || RBS_NODE.rbs_element_id,
5563: null,
5564: g_msg_level_data_corruption

Line 5585: PJI_UTILS.WRITE2LOG(

5581:
5582: -- -------------------------------------------------
5583: if g_pa_debug_mode = 'Y'
5584: then
5585: PJI_UTILS.WRITE2LOG(
5586: 'PJI_PJP - End: rbs_denorm_online',
5587: null,
5588: g_msg_level_proc_call
5589: );

Line 5643: PJI_UTILS.WRITE2LOG(

5639: begin
5640:
5641: if g_pa_debug_mode = 'Y'
5642: then
5643: PJI_UTILS.WRITE2LOG(
5644: 'PJI_PJP - Begin: merge_xbs_denorm -'
5645: || ' p_worker_id = '
5646: || P_WORKER_ID
5647: || ' p_extraction_type = '

Line 5863: PJI_UTILS.WRITE2LOG(

5859:
5860: -- -----------------------------------------------------
5861: if g_pa_debug_mode = 'Y'
5862: then
5863: PJI_UTILS.WRITE2LOG(
5864: 'PJI_PJP - End: merge_xbs_denorm',
5865: null,
5866: g_msg_level_proc_call
5867: );

Line 5917: PJI_UTILS.WRITE2LOG(

5913: begin
5914:
5915: if g_pa_debug_mode = 'Y'
5916: then
5917: PJI_UTILS.WRITE2LOG(
5918: 'PJI_PJP - Begin: merge_rbs_denorm -'
5919: || ' p_worker_id = '
5920: || P_WORKER_ID
5921: || ' p_extraction_type = '

Line 6066: PJI_UTILS.WRITE2LOG(

6062:
6063: -- -----------------------------------------------------
6064: if g_pa_debug_mode = 'Y'
6065: then
6066: PJI_UTILS.WRITE2LOG(
6067: 'PJI_PJP - End: merge_rbs_denorm',
6068: null,
6069: g_msg_level_proc_call
6070: );

Line 6095: PJI_UTILS.WRITE2LOG(

6091: begin
6092:
6093: if g_pa_debug_mode = 'Y'
6094: then
6095: PJI_UTILS.WRITE2LOG(
6096: 'PJI_PJP - Begin: cleanup_xbs_denorm -'
6097: || ' p_worker_id = '
6098: || P_WORKER_ID
6099: || ' p_extraction_type = '

Line 6127: PJI_UTILS.WRITE2LOG(

6123:
6124: -- -----------------------------------------------------
6125: if g_pa_debug_mode = 'Y'
6126: then
6127: PJI_UTILS.WRITE2LOG(
6128: 'PJI_PJP - End: cleanup_xbs_denorm',
6129: null,
6130: g_msg_level_proc_call
6131: );

Line 6157: PJI_UTILS.WRITE2LOG(

6153: begin
6154:
6155: if g_pa_debug_mode = 'Y'
6156: then
6157: PJI_UTILS.WRITE2LOG(
6158: 'PJI_PJP - Begin: cleanup_rbs_denorm -'
6159: || ' p_worker_id = '
6160: || P_WORKER_ID
6161: || ' p_extraction_type = '

Line 6188: PJI_UTILS.WRITE2LOG(

6184:
6185: -- -----------------------------------------------------
6186: if g_pa_debug_mode = 'Y'
6187: then
6188: PJI_UTILS.WRITE2LOG(
6189: 'PJI_PJP - End: cleanup_rbs_denorm',
6190: null,
6191: g_msg_level_proc_call
6192: );

Line 6235: PJI_UTILS.WRITE2LOG(

6231:
6232: else
6233: if g_pa_debug_mode = 'Y'
6234: then
6235: PJI_UTILS.WRITE2LOG(
6236: 'PJI_PJP - No maximum level found - p_rbs_version_id = '
6237: || P_RBS_VERSION_ID,
6238: null,
6239: g_msg_level_data_corruption

Line 6254: PJI_UTILS.WRITE2LOG(

6250: if l_rbs_level_id is null -- ###level_is_null###
6251: then
6252: if g_pa_debug_mode = 'Y'
6253: then
6254: PJI_UTILS.WRITE2LOG(
6255: 'PJI_PJP - Level is null Data Corruption - p_rbs_version_id = '
6256: || P_RBS_VERSION_ID,
6257: null,
6258: g_msg_level_data_corruption

Line 6269: PJI_UTILS.WRITE2LOG(

6265: LOOP
6266:
6267: if g_pa_debug_mode = 'Y'
6268: then
6269: PJI_UTILS.WRITE2LOG(
6270: 'PJI_PJP - RBS Inserts - l_rbs_level_id = '
6271: || l_rbs_level_id,
6272: null,
6273: g_msg_level_high_detail

Line 6335: PJI_UTILS.WRITE2LOG(

6331:
6332:
6333: if g_pa_debug_mode = 'Y'
6334: then
6335: PJI_UTILS.WRITE2LOG(
6336: 'PJI_PJP - Inserting RBS node self - rbs_element_id = '
6337: || RBS_NODE.rbs_element_id,
6338: null,
6339: g_msg_level_low_detail

Line 6414: PJI_UTILS.WRITE2LOG(

6410: end if;
6411:
6412: if g_pa_debug_mode = 'Y'
6413: then
6414: PJI_UTILS.WRITE2LOG(
6415: 'PJI_PJP - Inserting RBS node parent - l_rbs_temp_parent - = '
6416: || l_rbs_temp_parent,
6417: null,
6418: g_msg_level_low_detail

Line 6493: PJI_UTILS.WRITE2LOG(

6489:
6490:
6491: if g_pa_debug_mode = 'Y'
6492: then
6493: PJI_UTILS.WRITE2LOG(
6494: 'PJI_PJP - Inserting RBS node child - sup_id = '
6495: || RBS_CHILDREN_NODE.sup_id,
6496: null,
6497: g_msg_level_low_detail

Line 6535: PJI_UTILS.WRITE2LOG(

6531: ELSE
6532:
6533: if g_pa_debug_mode = 'Y'
6534: then
6535: PJI_UTILS.WRITE2LOG(
6536: 'PJI_PJP - Parent Data Corruption - rbs_element_id = '
6537: || RBS_NODE.rbs_element_id,
6538: null,
6539: g_msg_level_data_corruption

Line 6560: PJI_UTILS.WRITE2LOG(

6556:
6557: -- -----------------------------------------
6558: if g_pa_debug_mode = 'Y'
6559: then
6560: PJI_UTILS.WRITE2LOG(
6561: 'PJI_PJP - End: rbs_denorm',
6562: null,
6563: g_msg_level_proc_call
6564: );