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 1373: PJI_UTILS.WRITE2LOG(

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

Line 1397: PJI_UTILS.WRITE2LOG(

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

Line 1422: PJI_UTILS.WRITE2LOG(

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

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

1488: -- -------------------------------------------------------
1489: --Bug 4293903: In FULL mode if FPM upgrade is done treat as
1490: --incremental
1491: ----------------------------------------------------------
1492: l_fpm_upgrade := PJI_UTILS.GET_PARAMETER('PJI_FPM_UPGRADE');
1493:
1494: IF (nvl(l_fpm_upgrade,'P') = 'C' and
1495: l_extraction_type = 'FULL') THEN
1496:

Line 1599: PJI_UTILS.WRITE2LOG(

1595: end if;
1596:
1597: if g_pa_debug_mode = 'Y'
1598: then
1599: PJI_UTILS.WRITE2LOG(
1600: 'PJI_PJP - End: populate_rbs_denorm',
1601: null,
1602: g_msg_level_proc_call
1603: );

Line 1662: PJI_UTILS.WRITE2LOG(

1658:
1659:
1660: if g_pa_debug_mode = 'Y'
1661: then
1662: PJI_UTILS.WRITE2LOG(
1663: 'PJI_PJP - Begin: populate_rbs_denorm_upgrade -'
1664: || ' p_rbs_version_id = '
1665: || p_rbs_version_id,
1666: null,

Line 1760: PJI_UTILS.WRITE2LOG(

1756:
1757: -- -----------------------------------------------------
1758: if g_pa_debug_mode = 'Y'
1759: then
1760: PJI_UTILS.WRITE2LOG(
1761: 'PJI_PJP - End: populate_rbs_denorm_upgrade',
1762: null,
1763: g_msg_level_proc_call
1764: );

Line 1838: PJI_UTILS.WRITE2LOG(

1834:
1835:
1836: if g_pa_debug_mode = 'Y'
1837: then
1838: PJI_UTILS.WRITE2LOG(
1839: 'PJI_PJP - Begin: prg_denorm -'
1840: || ' p_worker_id = '
1841: || P_WORKER_ID
1842: || ' p_extraction_type = '

Line 2031: PJI_UTILS.WRITE2LOG(

2027:
2028: THEN
2029: if g_pa_debug_mode = 'Y'
2030: then
2031: PJI_UTILS.WRITE2LOG(
2032: 'PJI_PJP - PRG Group is null Data Bug - element_version_id = '
2033: || PRG_NODE.element_version_id,
2034: null,
2035: g_msg_level_data_bug

Line 2080: PJI_UTILS.WRITE2LOG(

2076:
2077:
2078: if g_pa_debug_mode = 'Y'
2079: then
2080: PJI_UTILS.WRITE2LOG(
2081: 'PJI_PJP - Inserting PRG node self -'
2082: || ' sup_id = '
2083: || PRG_NODE.element_version_id,
2084: null,

Line 2239: PJI_UTILS.WRITE2LOG(

2235:
2236:
2237: if g_pa_debug_mode = 'Y'
2238: then
2239: PJI_UTILS.WRITE2LOG(
2240: 'PJI_PJP - Inserting PRG node parent -'
2241: || ' element_version_id = '
2242: || PRG_NODE.element_version_id
2243: || ' sup_id = '

Line 2358: PJI_UTILS.WRITE2LOG(

2354:
2355:
2356: if g_pa_debug_mode = 'Y'
2357: then
2358: PJI_UTILS.WRITE2LOG(
2359: 'PJI_PJP - Inserting PRG node child -'
2360: || ' sup_id = '
2361: || l_prg_temp_parent
2362: || ' sub_emt_id = '

Line 2439: PJI_UTILS.WRITE2LOG(

2435: then
2436:
2437: if g_pa_debug_mode = 'Y'
2438: then
2439: PJI_UTILS.WRITE2LOG(
2440: 'PJI_PJP - Calling wbs_denorm - element_version_id = '
2441: || PRG_NODE.element_version_id,
2442: null,
2443: g_msg_level_low_detail

Line 2459: PJI_UTILS.WRITE2LOG(

2455: else
2456:
2457: if g_pa_debug_mode = 'Y'
2458: then
2459: PJI_UTILS.WRITE2LOG(
2460: 'PJI_PJP - Not calling wbs_denorm, because WBS node does not exist - element_version_id = '
2461: || PRG_NODE.element_version_id,
2462: null,
2463: g_msg_level_low_detail

Line 2485: PJI_UTILS.WRITE2LOG(

2481:
2482: -- ------------------------------------------
2483: if g_pa_debug_mode = 'Y'
2484: then
2485: PJI_UTILS.WRITE2LOG(
2486: 'PJI_PJP - End: prg_denorm',
2487: null,
2488: g_msg_level_proc_call
2489: );

Line 2557: PJI_UTILS.WRITE2LOG(

2553: -- (WBS node = task)
2554:
2555: if g_pa_debug_mode = 'Y'
2556: then
2557: PJI_UTILS.WRITE2LOG(
2558: 'PJI_PJP - Begin: wbs_denorm -'
2559: || ' p_worker_id = '
2560: || P_WORKER_ID
2561: || ' p_extraction_type = '

Line 2684: PJI_UTILS.WRITE2LOG(

2680:
2681:
2682: if g_pa_debug_mode = 'Y'
2683: then
2684: PJI_UTILS.WRITE2LOG(
2685: 'PJI_PJP - Inserting WBS node self - element_version_id = '
2686: || WBS_NODE.element_version_id,
2687: null,
2688: g_msg_level_low_detail

Line 2795: PJI_UTILS.WRITE2LOG(

2791:
2792:
2793: if g_pa_debug_mode = 'Y'
2794: then
2795: PJI_UTILS.WRITE2LOG(
2796: 'PJI_PJP - Inserting WBS node parent - l_wbs_temp_parent = '
2797: || l_wbs_temp_parent,
2798: null,
2799: g_msg_level_low_detail

Line 2909: PJI_UTILS.WRITE2LOG(

2905:
2906:
2907: if g_pa_debug_mode = 'Y'
2908: then
2909: PJI_UTILS.WRITE2LOG(
2910: 'PJI_PJP - Inserting WBS node child - sup_id = '
2911: || WBS_CHILDREN_NODE.sup_id,
2912: null,
2913: g_msg_level_low_detail

Line 2986: PJI_UTILS.WRITE2LOG(

2982:
2983:
2984: if g_pa_debug_mode = 'Y'
2985: then
2986: PJI_UTILS.WRITE2LOG(
2987: 'PJI_PJP - Inserting XBS node self - sup_id = '
2988: || P_WBS_VERSION_ID,
2989: null,
2990: g_msg_level_low_detail

Line 3052: PJI_UTILS.WRITE2LOG(

3048: -- ----------------------------------------------
3049:
3050: if g_pa_debug_mode = 'Y'
3051: then
3052: PJI_UTILS.WRITE2LOG(
3053: 'PJI_PJP - End: wbs_denorm',
3054: null,
3055: g_msg_level_proc_call
3056: );

Line 3130: PJI_UTILS.WRITE2LOG(

3126: -- (PRG node = program)
3127:
3128: if g_pa_debug_mode = 'Y'
3129: then
3130: PJI_UTILS.WRITE2LOG(
3131: 'PJI_PJP - Begin: prg_denorm_online -'
3132: || ' p_worker_id = '
3133: || P_WORKER_ID
3134: || ' p_extraction_type = '

Line 3183: PJI_UTILS.WRITE2LOG(

3179: LOOP
3180:
3181: if g_pa_debug_mode = 'Y'
3182: then
3183: PJI_UTILS.WRITE2LOG(
3184: 'PJI_PJP - PRG Inserts - l_prg_level_id = '
3185: || l_prg_level_id,
3186: null,
3187: g_msg_level_high_detail

Line 3221: PJI_UTILS.WRITE2LOG(

3217:
3218: THEN
3219: if g_pa_debug_mode = 'Y'
3220: then
3221: PJI_UTILS.WRITE2LOG(
3222: 'PJI_PJP - PRG Group is null Data Bug - element_version_id = '
3223: || PRG_NODE.element_version_id,
3224: null,
3225: g_msg_level_data_bug

Line 3268: PJI_UTILS.WRITE2LOG(

3264:
3265:
3266: if g_pa_debug_mode = 'Y'
3267: then
3268: PJI_UTILS.WRITE2LOG(
3269: 'PJI_PJP - Inserting PRG node self - sup_id = '
3270: || PRG_NODE.element_version_id,
3271: null,
3272: g_msg_level_low_detail

Line 3419: PJI_UTILS.WRITE2LOG(

3415:
3416:
3417: if g_pa_debug_mode = 'Y'
3418: then
3419: PJI_UTILS.WRITE2LOG(
3420: 'PJI_PJP - Inserting PRG node parent -'
3421: || ' element_version_id = '
3422: || PRG_NODE.element_version_id
3423: || ' sup_id = '

Line 3540: PJI_UTILS.WRITE2LOG(

3536:
3537:
3538: if g_pa_debug_mode = 'Y'
3539: then
3540: PJI_UTILS.WRITE2LOG(
3541: 'PJI_PJP - Inserting PRG node child -'
3542: || ' element_version_id = '
3543: || PRG_NODE.element_version_id
3544: || ' sup_id = '

Line 3621: PJI_UTILS.WRITE2LOG(

3617: -- -----------------------------------------
3618:
3619: if g_pa_debug_mode = 'Y'
3620: then
3621: PJI_UTILS.WRITE2LOG(
3622: 'PJI_PJP - End: prg_denorm_online',
3623: null,
3624: g_msg_level_proc_call
3625: );

Line 3696: PJI_UTILS.WRITE2LOG(

3692: -- (WBS node = task)
3693:
3694: if g_pa_debug_mode = 'Y'
3695: then
3696: PJI_UTILS.WRITE2LOG(
3697: 'PJI_PJP - Begin wbs_denorm_online -'
3698: || ' p_worker_id = '
3699: || P_WORKER_ID
3700: || ' p_extraction_type = '

Line 3734: PJI_UTILS.WRITE2LOG(

3730: THEN
3731:
3732: if g_pa_debug_mode = 'Y'
3733: then
3734: PJI_UTILS.WRITE2LOG(
3735: 'PJI_PJP - Wbs node as task does not exist - p_wbs_version_id = '
3736: || P_WBS_VERSION_ID,
3737: null,
3738: g_msg_level_low_detail

Line 3772: PJI_UTILS.WRITE2LOG(

3768: then
3769:
3770: if g_pa_debug_mode = 'Y'
3771: then
3772: PJI_UTILS.WRITE2LOG(
3773: 'PJI_PJP - Level is null Data Corruption - p_wbs_version_id = '
3774: || P_WBS_VERSION_ID,
3775: null,
3776: g_msg_level_data_corruption

Line 3827: PJI_UTILS.WRITE2LOG(

3823: LOOP
3824:
3825: if g_pa_debug_mode = 'Y'
3826: then
3827: PJI_UTILS.WRITE2LOG(
3828: 'PJI_PJP - WBS Inserts - l_wbs_level_id = '
3829: || l_wbs_level_id,
3830: null,
3831: g_msg_level_high_detail

Line 3898: PJI_UTILS.WRITE2LOG(

3894:
3895:
3896: if g_pa_debug_mode = 'Y'
3897: then
3898: PJI_UTILS.WRITE2LOG(
3899: 'PJI_PJP - Inserting WBS node self - element_version_id = '
3900: || WBS_NODE.element_version_id,
3901: null,
3902: g_msg_level_low_detail

Line 4034: PJI_UTILS.WRITE2LOG(

4030:
4031:
4032: if g_pa_debug_mode = 'Y'
4033: then
4034: PJI_UTILS.WRITE2LOG(
4035: 'PJI_PJP - Inserting WBS node parent - l_wbs_temp_parent = '
4036: || l_wbs_temp_parent,
4037: null,
4038: g_msg_level_low_detail

Line 4148: PJI_UTILS.WRITE2LOG(

4144:
4145:
4146: if g_pa_debug_mode = 'Y'
4147: then
4148: PJI_UTILS.WRITE2LOG(
4149: 'PJI_PJP - Inserting WBS node child - sup_id = '
4150: || WBS_CHILDREN_NODE.sup_id,
4151: null,
4152: g_msg_level_low_detail

Line 4213: PJI_UTILS.WRITE2LOG(

4209: ELSE
4210:
4211: if g_pa_debug_mode = 'Y'
4212: then
4213: PJI_UTILS.WRITE2LOG(
4214: 'PJI_PJP - Parent Data Corruption - element_version_id = '
4215: || WBS_NODE.element_version_id,
4216: null,
4217: g_msg_level_data_corruption

Line 4260: PJI_UTILS.WRITE2LOG(

4256:
4257:
4258: if g_pa_debug_mode = 'Y'
4259: then
4260: PJI_UTILS.WRITE2LOG(
4261: 'PJI_PJP - Inserting XBS node self - sup_id = '
4262: || P_WBS_VERSION_ID,
4263: null,
4264: g_msg_level_low_detail

Line 4319: PJI_UTILS.WRITE2LOG(

4315: else
4316:
4317: if g_pa_debug_mode = 'Y'
4318: then
4319: PJI_UTILS.WRITE2LOG(
4320: 'PJI_PJP - DATA BUG - element_version_id = '
4321: || WBS_NODE.element_version_id
4322: || ' struct_version_id = '
4323: || P_WBS_VERSION_ID,

Line 4346: PJI_UTILS.WRITE2LOG(

4342:
4343: -- -------------------------------------------------
4344: if g_pa_debug_mode = 'Y'
4345: then
4346: PJI_UTILS.WRITE2LOG(
4347: 'PJI_PJP - End: wbs_denorm_online',
4348: null,
4349: g_msg_level_proc_call
4350: );

Line 4408: PJI_UTILS.WRITE2LOG(

4404: -- (RBS node = resource)
4405:
4406: if g_pa_debug_mode = 'Y'
4407: then
4408: PJI_UTILS.WRITE2LOG(
4409: 'PJI_PJP - Begin: rbs_denorm -'
4410: || ' p_worker_id = '
4411: || P_WORKER_ID
4412: || ' p_extraction_type = '

Line 4469: PJI_UTILS.WRITE2LOG(

4465:
4466: else
4467: if g_pa_debug_mode = 'Y'
4468: then
4469: PJI_UTILS.WRITE2LOG(
4470: 'PJI_PJP - No maximum level found - p_rbs_version_id = '
4471: || P_RBS_VERSION_ID,
4472: null,
4473: g_msg_level_data_corruption

Line 4488: PJI_UTILS.WRITE2LOG(

4484: if l_rbs_level_id is null -- ###level_is_null###
4485: then
4486: if g_pa_debug_mode = 'Y'
4487: then
4488: PJI_UTILS.WRITE2LOG(
4489: 'PJI_PJP - Level is null Data Corruption - p_rbs_version_id = '
4490: || P_RBS_VERSION_ID,
4491: null,
4492: g_msg_level_data_corruption

Line 4509: PJI_UTILS.WRITE2LOG(

4505: LOOP
4506:
4507: if g_pa_debug_mode = 'Y'
4508: then
4509: PJI_UTILS.WRITE2LOG(
4510: 'PJI_PJP - RBS Inserts - l_rbs_level_id = '
4511: || l_rbs_level_id,
4512: null,
4513: g_msg_level_high_detail

Line 4642: PJI_UTILS.WRITE2LOG(

4638:
4639:
4640: if g_pa_debug_mode = 'Y'
4641: then
4642: PJI_UTILS.WRITE2LOG(
4643: 'PJI_PJP - Inserting RBS node self - rbs_element_id = '
4644: || RBS_NODE.rbs_element_id,
4645: null,
4646: g_msg_level_low_detail

Line 4721: PJI_UTILS.WRITE2LOG(

4717: end if;
4718:
4719: if g_pa_debug_mode = 'Y'
4720: then
4721: PJI_UTILS.WRITE2LOG(
4722: 'PJI_PJP - Inserting RBS node parent - l_rbs_temp_parent - = '
4723: || l_rbs_temp_parent,
4724: null,
4725: g_msg_level_low_detail

Line 4800: PJI_UTILS.WRITE2LOG(

4796:
4797:
4798: if g_pa_debug_mode = 'Y'
4799: then
4800: PJI_UTILS.WRITE2LOG(
4801: 'PJI_PJP - Inserting RBS node child - sup_id = '
4802: || RBS_CHILDREN_NODE.sup_id,
4803: null,
4804: g_msg_level_low_detail

Line 4842: PJI_UTILS.WRITE2LOG(

4838: ELSE
4839:
4840: if g_pa_debug_mode = 'Y'
4841: then
4842: PJI_UTILS.WRITE2LOG(
4843: 'PJI_PJP - Parent Data Corruption - rbs_element_id = '
4844: || RBS_NODE.rbs_element_id,
4845: null,
4846: g_msg_level_data_corruption

Line 4867: PJI_UTILS.WRITE2LOG(

4863:
4864: -- -----------------------------------------
4865: if g_pa_debug_mode = 'Y'
4866: then
4867: PJI_UTILS.WRITE2LOG(
4868: 'PJI_PJP - End: rbs_denorm',
4869: null,
4870: g_msg_level_proc_call
4871: );

Line 4930: PJI_UTILS.WRITE2LOG(

4926: -- (RBS node = resource)
4927:
4928: if g_pa_debug_mode = 'Y'
4929: then
4930: PJI_UTILS.WRITE2LOG(
4931: 'PJI_PJP - Begin: rbs_denorm_online -'
4932: || ' p_worker_id = '
4933: || P_WORKER_ID
4934: || ' p_extraction_type = '

Line 4962: PJI_UTILS.WRITE2LOG(

4958: if l_rbs_level_id is null -- ###level_is_null###
4959: then
4960: if g_pa_debug_mode = 'Y'
4961: then
4962: PJI_UTILS.WRITE2LOG(
4963: 'PJI_PJP - Level is null Data Corruption - p_rbs_version_id = '
4964: || P_RBS_VERSION_ID,
4965: null,
4966: g_msg_level_data_corruption

Line 4983: PJI_UTILS.WRITE2LOG(

4979: LOOP
4980:
4981: if g_pa_debug_mode = 'Y'
4982: then
4983: PJI_UTILS.WRITE2LOG(
4984: 'PJI_PJP - RBS Inserts - l_rbs_level_id = '
4985: || l_rbs_level_id,
4986: null,
4987: g_msg_level_high_detail

Line 5056: PJI_UTILS.WRITE2LOG(

5052:
5053:
5054: if g_pa_debug_mode = 'Y'
5055: then
5056: PJI_UTILS.WRITE2LOG(
5057: 'PJI_PJP - Inserting RBS node self - rbs_element_id = '
5058: || RBS_NODE.rbs_element_id,
5059: null,
5060: g_msg_level_low_detail

Line 5135: PJI_UTILS.WRITE2LOG(

5131: end if;
5132:
5133: if g_pa_debug_mode = 'Y'
5134: then
5135: PJI_UTILS.WRITE2LOG(
5136: 'PJI_PJP - Inserting RBS node parent - l_rbs_temp_parent - = '
5137: || l_rbs_temp_parent,
5138: null,
5139: g_msg_level_low_detail

Line 5214: PJI_UTILS.WRITE2LOG(

5210:
5211:
5212: if g_pa_debug_mode = 'Y'
5213: then
5214: PJI_UTILS.WRITE2LOG(
5215: 'PJI_PJP - Inserting RBS node child - sup_id = '
5216: || RBS_CHILDREN_NODE.sup_id,
5217: null,
5218: g_msg_level_low_detail

Line 5256: PJI_UTILS.WRITE2LOG(

5252: ELSE
5253:
5254: if g_pa_debug_mode = 'Y'
5255: then
5256: PJI_UTILS.WRITE2LOG(
5257: 'PJI_PJP - Parent Data Corruption - rbs_element_id = '
5258: || RBS_NODE.rbs_element_id,
5259: null,
5260: g_msg_level_data_corruption

Line 5281: PJI_UTILS.WRITE2LOG(

5277:
5278: -- -------------------------------------------------
5279: if g_pa_debug_mode = 'Y'
5280: then
5281: PJI_UTILS.WRITE2LOG(
5282: 'PJI_PJP - End: rbs_denorm_online',
5283: null,
5284: g_msg_level_proc_call
5285: );

Line 5335: PJI_UTILS.WRITE2LOG(

5331: begin
5332:
5333: if g_pa_debug_mode = 'Y'
5334: then
5335: PJI_UTILS.WRITE2LOG(
5336: 'PJI_PJP - Begin: merge_xbs_denorm -'
5337: || ' p_worker_id = '
5338: || P_WORKER_ID
5339: || ' p_extraction_type = '

Line 5555: PJI_UTILS.WRITE2LOG(

5551:
5552: -- -----------------------------------------------------
5553: if g_pa_debug_mode = 'Y'
5554: then
5555: PJI_UTILS.WRITE2LOG(
5556: 'PJI_PJP - End: merge_xbs_denorm',
5557: null,
5558: g_msg_level_proc_call
5559: );

Line 5609: PJI_UTILS.WRITE2LOG(

5605: begin
5606:
5607: if g_pa_debug_mode = 'Y'
5608: then
5609: PJI_UTILS.WRITE2LOG(
5610: 'PJI_PJP - Begin: merge_rbs_denorm -'
5611: || ' p_worker_id = '
5612: || P_WORKER_ID
5613: || ' p_extraction_type = '

Line 5758: PJI_UTILS.WRITE2LOG(

5754:
5755: -- -----------------------------------------------------
5756: if g_pa_debug_mode = 'Y'
5757: then
5758: PJI_UTILS.WRITE2LOG(
5759: 'PJI_PJP - End: merge_rbs_denorm',
5760: null,
5761: g_msg_level_proc_call
5762: );

Line 5787: PJI_UTILS.WRITE2LOG(

5783: begin
5784:
5785: if g_pa_debug_mode = 'Y'
5786: then
5787: PJI_UTILS.WRITE2LOG(
5788: 'PJI_PJP - Begin: cleanup_xbs_denorm -'
5789: || ' p_worker_id = '
5790: || P_WORKER_ID
5791: || ' p_extraction_type = '

Line 5819: PJI_UTILS.WRITE2LOG(

5815:
5816: -- -----------------------------------------------------
5817: if g_pa_debug_mode = 'Y'
5818: then
5819: PJI_UTILS.WRITE2LOG(
5820: 'PJI_PJP - End: cleanup_xbs_denorm',
5821: null,
5822: g_msg_level_proc_call
5823: );

Line 5849: PJI_UTILS.WRITE2LOG(

5845: begin
5846:
5847: if g_pa_debug_mode = 'Y'
5848: then
5849: PJI_UTILS.WRITE2LOG(
5850: 'PJI_PJP - Begin: cleanup_rbs_denorm -'
5851: || ' p_worker_id = '
5852: || P_WORKER_ID
5853: || ' p_extraction_type = '

Line 5880: PJI_UTILS.WRITE2LOG(

5876:
5877: -- -----------------------------------------------------
5878: if g_pa_debug_mode = 'Y'
5879: then
5880: PJI_UTILS.WRITE2LOG(
5881: 'PJI_PJP - End: cleanup_rbs_denorm',
5882: null,
5883: g_msg_level_proc_call
5884: );