DBA Data[Home] [Help]

APPS.WF_MAINTENANCE dependencies on WF_LOG_PKG

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

231: begin
232: l_newname := upper(substrb(NewName,1,320));
233: l_oldname := upper(substrb(OldName,1,320));
234:
235: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
236: wf_log_pkg.string(wf_log_pkg.level_procedure, 'wf.plsql.wf_maintenance.propagateChangedName',
237: 'Changing old user '||l_oldname||' to new '||l_newname);
238: end if;
239:

Line 236: wf_log_pkg.string(wf_log_pkg.level_procedure, 'wf.plsql.wf_maintenance.propagateChangedName',

232: l_newname := upper(substrb(NewName,1,320));
233: l_oldname := upper(substrb(OldName,1,320));
234:
235: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
236: wf_log_pkg.string(wf_log_pkg.level_procedure, 'wf.plsql.wf_maintenance.propagateChangedName',
237: 'Changing old user '||l_oldname||' to new '||l_newname);
238: end if;
239:
240: g_docommit := docommit;

Line 283: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

279: -- This profile is shipped only for 12.1.X and above at this point. If not
280: -- available, continue to update all records as always.
281: if (l_pvalue is null or l_pvalue = 'Y') then
282:
283: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
284: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_maintenance.propagateChangedName',
285: 'Updating all WF data');
286: end if;
287:

Line 284: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_maintenance.propagateChangedName',

280: -- available, continue to update all records as always.
281: if (l_pvalue is null or l_pvalue = 'Y') then
282:
283: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
284: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_maintenance.propagateChangedName',
285: 'Updating all WF data');
286: end if;
287:
288: open cItems(l_oldname);

Line 411: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

407: close cRoleAttributes;
408:
409: else -- End profile = 'Y'
410:
411: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
412: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_maintenance.propagateChangedName',
413: 'Updating only Active WF data');
414: end if;
415:

Line 412: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_maintenance.propagateChangedName',

408:
409: else -- End profile = 'Y'
410:
411: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
412: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_maintenance.propagateChangedName',
413: 'Updating only Active WF data');
414: end if;
415:
416: open cItems2(l_oldname);

Line 623: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

619: end LOOP;
620: l_wa := cWorklistAccess%ROWCOUNT;
621: CLOSE cWorklistAccess;
622:
623: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
624: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_maintenance.propagateChangedName',
625: 'Updated Records: WF_ITEMS:'||l_items||', WF_IAS:'||l_ias||', WF_IASH:'
626: ||l_iash||', WF_NTFS:'||l_ntfs||', WF_COMMENTS:'||l_coms);
627: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_maintenance.propagateChangedName',

Line 624: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_maintenance.propagateChangedName',

620: l_wa := cWorklistAccess%ROWCOUNT;
621: CLOSE cWorklistAccess;
622:
623: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
624: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_maintenance.propagateChangedName',
625: 'Updated Records: WF_ITEMS:'||l_items||', WF_IAS:'||l_ias||', WF_IASH:'
626: ||l_iash||', WF_NTFS:'||l_ntfs||', WF_COMMENTS:'||l_coms);
627: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_maintenance.propagateChangedName',
628: 'Updated Records: WF_PROC_ACTS:'||l_pas||', WF_ROUTING_RULES:'||l_rr

Line 627: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_maintenance.propagateChangedName',

623: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
624: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_maintenance.propagateChangedName',
625: 'Updated Records: WF_ITEMS:'||l_items||', WF_IAS:'||l_ias||', WF_IASH:'
626: ||l_iash||', WF_NTFS:'||l_ntfs||', WF_COMMENTS:'||l_coms);
627: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_maintenance.propagateChangedName',
628: 'Updated Records: WF_PROC_ACTS:'||l_pas||', WF_ROUTING_RULES:'||l_rr
629: ||', WF_ROUTING_RULE_ATTRS:' ||l_rra||', WF_ITEM_ATTR_VALUES:'||l_ra
630: ||', WORKLIST_ACCESS:'||l_wa);
631: end if;

Line 1093: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_modulePkg,

1089:
1090: begin
1091: -- Log only
1092: -- BINDVAR_SCAN_IGNORE[2]
1093: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_modulePkg,
1094: 'Begin ValidateUserRoles('||p_batchSize||')');
1095: --First validate the inbound parameter(s)
1096: if (p_BatchSize is NULL or (p_BatchSize < 1)) then
1097: l_MaxRows := 10000;