DBA Data[Home] [Help]

APPS.WF_LOCAL_SYNCH dependencies on FND_LOG

Line 332: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

328: i number;
329: l_modulePkg varchar2(240) := g_modulePkg||'.update_entmgr';
330:
331: begin
332: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
333:
334: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_modulePkg,
335: 'Begin update_entmgr('|| p_entity_type||', '||
336: p_entity_key_value||', '||

Line 357: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

353: p_entity_key_value,
354: p_source);
355: end if;
356:
357: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
358:
359: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_modulePkg,
360: 'End update_entmgr('||p_entity_type||', '||
361: p_entity_key_value||', '||

Line 442: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

438: l_storage VARCHAR2(4000);
439:
440: begin
441:
442: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
443: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
444: l_modulePkg,
445: 'Begin Create_Stage_Indexes('||p_sourceTable||', '||
446: p_targetTable||')');

Line 559: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

555: end loop; -- IndParts (index partitions) Loop
556: end loop; --Index (l_owners index) Loop
557: end if; -- (l_owners.COUNT > 0);
558:
559: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
560: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
561: l_modulePkg,
562: 'End Create_Stage_Indexes('||p_sourceTable||', '||
563: p_targetTable||')');

Line 569: if (wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then

565:
566: exception
567: when OTHERS then
568:
569: if (wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
570: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED, l_modulePkg,
571: 'Exception: '||sqlerrm);
572:
573: end if;

Line 910: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

906: p_aux_exp_date date;
907:
908: BEGIN
909:
910: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
911: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
912: l_modulePkg,
913: 'Begin propagate_user('||p_orig_system||', '||
914: p_orig_system_id||','||

Line 1529: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

1525:
1526: end if;
1527: end if;
1528:
1529: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1530: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
1531: l_modulePkg,
1532: 'End propagate_user('||p_orig_system||', '||
1533: p_orig_system_id||','||

Line 1543: if (wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then

1539:
1540:
1541: exception
1542: when OTHERS then
1543: if (wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
1544: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED, l_modulePkg,
1545: 'Exception: '||sqlerrm);
1546:
1547: end if;

Line 1588: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

1584: AND ORIG_SYSTEM_ID = c_orig_system_id;
1585:
1586: begin
1587:
1588: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1589: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
1590: l_modulePkg,
1591: 'Begin propagate_role('||p_orig_system||', '||
1592: p_orig_system_id||','||

Line 1894: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

1890:
1891: end if;
1892: end;
1893: end if;
1894: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1895: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
1896: l_modulePkg,
1897: 'End propagate_role('||p_orig_system||', '||
1898: p_orig_system_id||','||

Line 1907: if (wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then

1903: end if;
1904:
1905: exception
1906: when OTHERS then
1907: if (wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
1908: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,l_modulePkg,
1909: 'Exception: '||sqlerrm);
1910:
1911: end if;