DBA Data[Home] [Help]

APPS.CZ_CF_API dependencies on FND_PROFILE

Line 957: l_bv_profile := FND_PROFILE.VALUE('CZ_BV_DELTA');

953: FOR I IN 1..1
954: LOOP
955:
956: ----check profile setting
957: l_bv_profile := FND_PROFILE.VALUE('CZ_BV_DELTA');
958:
959: IF (NVL(UPPER(l_bv_profile), 'N') = 'N') THEN
960: EXIT;
961: END IF;

Line 1178: l_ssl_profile_option := FND_PROFILE.VALUE('APPS_SERVLET_AGENT');

1174: l_wallet_path VARCHAR2(2000); ----directory path of the wallet
1175: l_wallet_passwd VARCHAR2(2000) := NULL; ---- password is not necessary for the default wallet
1176:
1177: BEGIN
1178: l_ssl_profile_option := FND_PROFILE.VALUE('APPS_SERVLET_AGENT');
1179: l_wallet_path := FND_PROFILE.VALUE('FND_DB_WALLET_DIR');
1180: l_wallet_path := 'file:'||l_wallet_path ;
1181:
1182: IF (transferTimeout IS NOT NULL AND defaultTimeout IS NOT NULL) THEN

Line 1179: l_wallet_path := FND_PROFILE.VALUE('FND_DB_WALLET_DIR');

1175: l_wallet_passwd VARCHAR2(2000) := NULL; ---- password is not necessary for the default wallet
1176:
1177: BEGIN
1178: l_ssl_profile_option := FND_PROFILE.VALUE('APPS_SERVLET_AGENT');
1179: l_wallet_path := FND_PROFILE.VALUE('FND_DB_WALLET_DIR');
1180: l_wallet_path := 'file:'||l_wallet_path ;
1181:
1182: IF (transferTimeout IS NOT NULL AND defaultTimeout IS NOT NULL) THEN
1183: EXECUTE IMMEDIATE 'BEGIN UTL_HTTP.SET_TRANSFER_TIMEOUT(:1); END;' USING IN transferTimeout;

Line 1487: l_url := FND_PROFILE.Value('CZ_UIMGR_URL');

1483: END IF;
1484:
1485: l_url := p_url;
1486: IF l_url IS NULL THEN
1487: l_url := FND_PROFILE.Value('CZ_UIMGR_URL');
1488: END IF;
1489:
1490: l_log_stmt := FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1491: IF l_log_stmt AND p_init_msg IS NOT NULL THEN

Line 1970: URL IN VARCHAR2 DEFAULT FND_PROFILE.Value('CZ_UIMGR_URL'),

1966: PROCEDURE VALIDATE (config_input_list IN CFG_INPUT_LIST,
1967: init_message IN VARCHAR2,
1968: config_messages IN OUT NOCOPY CFG_OUTPUT_PIECES,
1969: validation_status IN OUT NOCOPY NUMBER,
1970: URL IN VARCHAR2 DEFAULT FND_PROFILE.Value('CZ_UIMGR_URL'),
1971: p_validation_type IN VARCHAR2 DEFAULT CZ_API_PUB.VALIDATE_ORDER)
1972:
1973: IS
1974: PRAGMA AUTONOMOUS_TRANSACTION;

Line 2394: l_return_ui_profile := FND_PROFILE.value('CZGENERICBOMUIPROFILE');

2390: config_creation_date, v_ui_type,
2391: calling_application_id, NULL);
2392: IF ( (l_return_ui_def_id IS NOT NULL)
2393: AND (l_return_ui_def_id = NATIVEBOM_UI_DEF) ) THEN
2394: l_return_ui_profile := FND_PROFILE.value('CZGENERICBOMUIPROFILE');
2395: IF (UPPER(l_return_ui_profile) IN ('N', 'NO') ) THEN
2396: l_return_ui_def_id := NULL;
2397: END IF;
2398: END IF;

Line 2831: fnd_profile.get('CZ_PUBLICATION_USAGE', v_usage_name);

2827: END IF;
2828:
2829: -- check usage_name: if null, get the profile option value from db
2830: IF v_usage_name IS NULL THEN
2831: fnd_profile.get('CZ_PUBLICATION_USAGE', v_usage_name);
2832: END IF;
2833:
2834: v_usage_id := usage_id_from_usage_name(v_usage_name);
2835:

Line 2847: fnd_profile.get('CZ_PUBLICATION_MODE', v_publication_mode);

2843:
2844: -- check publication mode: if null, get the profile option value from db.
2845: -- if still null, use the default 'P'.
2846: IF v_publication_mode IS NULL THEN
2847: fnd_profile.get('CZ_PUBLICATION_MODE', v_publication_mode);
2848: IF v_publication_mode IS NULL THEN
2849: v_publication_mode := 'P';
2850: END IF;
2851: END IF;

Line 3112: fnd_profile.get('CZ_PUBLICATION_USAGE', v_usage_name);

3108: END IF;
3109:
3110: -- check usage_name: if null, get the profile option value from db
3111: IF v_usage_name IS NULL THEN
3112: fnd_profile.get('CZ_PUBLICATION_USAGE', v_usage_name);
3113: END IF;
3114:
3115: v_usage_id := usage_id_from_usage_name(v_usage_name);
3116:

Line 3128: fnd_profile.get('CZ_PUBLICATION_MODE', v_publication_mode);

3124:
3125: -- check publication mode: if null, get the profile option value from db.
3126: -- if still null, use the default 'P'.
3127: IF v_publication_mode IS NULL THEN
3128: fnd_profile.get('CZ_PUBLICATION_MODE', v_publication_mode);
3129: IF v_publication_mode IS NULL THEN
3130: v_publication_mode := 'P';
3131: END IF;
3132: END IF;

Line 3281: l_user_id := fnd_profile.value('USER_ID');

3277: l_resp_appl_id NUMBER;
3278: l_session_id NUMBER;
3279: l_icx_exc EXCEPTION;
3280: BEGIN
3281: l_user_id := fnd_profile.value('USER_ID');
3282: l_resp_id := fnd_profile.value('RESP_ID');
3283: l_resp_appl_id := fnd_profile.value('RESP_APPL_ID');
3284: l_session_id := FND_SESSION_MANAGEMENT.g_session_id;
3285: IF (l_session_id = -1) THEN

Line 3282: l_resp_id := fnd_profile.value('RESP_ID');

3278: l_session_id NUMBER;
3279: l_icx_exc EXCEPTION;
3280: BEGIN
3281: l_user_id := fnd_profile.value('USER_ID');
3282: l_resp_id := fnd_profile.value('RESP_ID');
3283: l_resp_appl_id := fnd_profile.value('RESP_APPL_ID');
3284: l_session_id := FND_SESSION_MANAGEMENT.g_session_id;
3285: IF (l_session_id = -1) THEN
3286: IF l_user_id IS NULL OR l_resp_id IS NULL OR l_resp_appl_id IS NULL THEN

Line 3283: l_resp_appl_id := fnd_profile.value('RESP_APPL_ID');

3279: l_icx_exc EXCEPTION;
3280: BEGIN
3281: l_user_id := fnd_profile.value('USER_ID');
3282: l_resp_id := fnd_profile.value('RESP_ID');
3283: l_resp_appl_id := fnd_profile.value('RESP_APPL_ID');
3284: l_session_id := FND_SESSION_MANAGEMENT.g_session_id;
3285: IF (l_session_id = -1) THEN
3286: IF l_user_id IS NULL OR l_resp_id IS NULL OR l_resp_appl_id IS NULL THEN
3287: RAISE l_icx_exc;

Line 3437: fnd_profile.get('CZ_PUBLICATION_USAGE', l_usage_name);

3433: l_organization_id NUMBER;
3434:
3435: BEGIN
3436: IF l_usage_name IS NULL THEN
3437: fnd_profile.get('CZ_PUBLICATION_USAGE', l_usage_name);
3438: END IF;
3439: l_usage_id := usage_id_from_usage_name(l_usage_name);
3440:
3441: -- Keep these values to lookup common bill, if required