APPS.PO_OTM_INTEGRATION_PVT dependencies on FND_PROFILE

Line 7: g_po_wf_debug CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');

3:
4: -- Debugging booleans used to bypass logging when turned off
5: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
6: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
7: g_po_wf_debug CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');
8:
9: -- Logging constants
10: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_OTM_INTEGRATION_PVT';
11: g_module_prefix CONSTANT VARCHAR2(100) := 'po.plsql.' || g_pkg_name || '.';

Line 161: IF (FND_PROFILE.value('WSH_OTM_INSTALLED') IN ('Y', 'P')) THEN

157: END IF;
158:
159: d_progress := '100';
160:
161: IF (FND_PROFILE.value('WSH_OTM_INSTALLED') IN ('Y', 'P')) THEN
162: d_progress := '110';
163: l_is_otm_installed := TRUE;
164: ELSE
165: d_progress := '120';

Line 756: x_otm_doc.otm_domain := FND_PROFILE.value('WSH_OTM_DOMAIN_NAME');

752: IF (g_debug_stmt) THEN
753: PO_DEBUG.debug_begin(d_module);
754: END IF;
755:
756: x_otm_doc.otm_domain := FND_PROFILE.value('WSH_OTM_DOMAIN_NAME');
757: x_otm_doc.otm_user := FND_PROFILE.value('WSH_OTM_USER_ID');
758: x_otm_doc.otm_password := FND_PROFILE.value('WSH_OTM_PASSWORD');
759:
760: -- get server timezone

Line 757: x_otm_doc.otm_user := FND_PROFILE.value('WSH_OTM_USER_ID');

753: PO_DEBUG.debug_begin(d_module);
754: END IF;
755:
756: x_otm_doc.otm_domain := FND_PROFILE.value('WSH_OTM_DOMAIN_NAME');
757: x_otm_doc.otm_user := FND_PROFILE.value('WSH_OTM_USER_ID');
758: x_otm_doc.otm_password := FND_PROFILE.value('WSH_OTM_PASSWORD');
759:
760: -- get server timezone
761: SELECT ftb.timezone_code

Line 758: x_otm_doc.otm_password := FND_PROFILE.value('WSH_OTM_PASSWORD');

754: END IF;
755:
756: x_otm_doc.otm_domain := FND_PROFILE.value('WSH_OTM_DOMAIN_NAME');
757: x_otm_doc.otm_user := FND_PROFILE.value('WSH_OTM_USER_ID');
758: x_otm_doc.otm_password := FND_PROFILE.value('WSH_OTM_PASSWORD');
759:
760: -- get server timezone
761: SELECT ftb.timezone_code
762: INTO x_otm_doc.server_timezone_code

Line 764: WHERE ftb.upgrade_tz_id = FND_PROFILE.value('SERVER_TIMEZONE_ID');

760: -- get server timezone
761: SELECT ftb.timezone_code
762: INTO x_otm_doc.server_timezone_code
763: FROM fnd_timezones_b ftb
764: WHERE ftb.upgrade_tz_id = FND_PROFILE.value('SERVER_TIMEZONE_ID');
765:
766: x_otm_doc.action := p_action;
767:
768: d_progress := '100';