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 145: IF (FND_PROFILE.value('WSH_OTM_INSTALLED') IN ('Y', 'P')) THEN

141: END IF;
142:
143: d_progress := '100';
144:
145: IF (FND_PROFILE.value('WSH_OTM_INSTALLED') IN ('Y', 'P')) THEN
146: d_progress := '110';
147: l_is_otm_installed := TRUE;
148: ELSE
149: d_progress := '120';

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

682: IF (g_po_wf_debug = 'Y') THEN
683: PO_WF_DEBUG_PKG.debug_begin(d_module);
684: END IF;
685:
686: x_otm_doc.otm_domain := FND_PROFILE.value('WSH_OTM_DOMAIN_NAME');
687: x_otm_doc.otm_user := FND_PROFILE.value('WSH_OTM_USER_ID');
688: x_otm_doc.otm_password := FND_PROFILE.value('WSH_OTM_PASSWORD');
689:
690: -- get server timezone

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

683: PO_WF_DEBUG_PKG.debug_begin(d_module);
684: END IF;
685:
686: x_otm_doc.otm_domain := FND_PROFILE.value('WSH_OTM_DOMAIN_NAME');
687: x_otm_doc.otm_user := FND_PROFILE.value('WSH_OTM_USER_ID');
688: x_otm_doc.otm_password := FND_PROFILE.value('WSH_OTM_PASSWORD');
689:
690: -- get server timezone
691: SELECT ftb.timezone_code

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

684: END IF;
685:
686: x_otm_doc.otm_domain := FND_PROFILE.value('WSH_OTM_DOMAIN_NAME');
687: x_otm_doc.otm_user := FND_PROFILE.value('WSH_OTM_USER_ID');
688: x_otm_doc.otm_password := FND_PROFILE.value('WSH_OTM_PASSWORD');
689:
690: -- get server timezone
691: SELECT ftb.timezone_code
692: INTO x_otm_doc.server_timezone_code

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

690: -- get server timezone
691: SELECT ftb.timezone_code
692: INTO x_otm_doc.server_timezone_code
693: FROM fnd_timezones_b ftb
694: WHERE ftb.upgrade_tz_id = FND_PROFILE.value('SERVER_TIMEZONE_ID');
695:
696: x_otm_doc.action := p_action;
697:
698: d_progress := '100';