17: IS
18: l_profile_option_id NUMBER;
19: l_application_id NUMBER;
20: BEGIN
21: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
22: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
23: g_api || '.set_single_option_value.begin',
24: '<
25: END IF;
18: l_profile_option_id NUMBER;
19: l_application_id NUMBER;
20: BEGIN
21: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
22: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
23: g_api || '.set_single_option_value.begin',
24: '<
25: END IF;
26:
68: fnd_global.user_id,
69: fnd_global.login_id,
70: p_option_value);
71:
72: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
73: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
74: g_api || '.set_single_option_value.end',
75: '<
76: END IF;
69: fnd_global.login_id,
70: p_option_value);
71:
72: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
73: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
74: g_api || '.set_single_option_value.end',
75: '<
76: END IF;
77:
76: END IF;
77:
78: EXCEPTION
79: WHEN OTHERS THEN
80: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
81: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
82: g_api || '.set_single_option_value.error',
83: SQLERRM);
84: END IF;
77:
78: EXCEPTION
79: WHEN OTHERS THEN
80: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
81: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
82: g_api || '.set_single_option_value.error',
83: SQLERRM);
84: END IF;
85:
96: x_retcode OUT NOCOPY VARCHAR2)
97: IS
98: l_vs_id VARCHAR2(100);
99: BEGIN
100: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
101: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
102: g_api || '.set_profile_option_values.begin',
103: '<
104: END IF;
97: IS
98: l_vs_id VARCHAR2(100);
99: BEGIN
100: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
101: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
102: g_api || '.set_profile_option_values.begin',
103: '<
104: END IF;
105:
118: set_single_option_value('AMW_FIN_ITEM_ACC_RELATIONS_VIEW', 'GCS_ITEMS_TO_NAT_ACCTS_V', 'N');
119: set_single_option_value('AMW_ACCOUNT_SOURCE_VIEW', 'GCS_NAT_ACCTS_HIER_V', 'N');
120: set_single_option_value('AMW_ACCOUNT_NAMES_VIEW', 'GCS_NAT_ACCTS_V', 'N');
121:
122: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
123: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
124: g_api || '.set_profile_option_values.end',
125: '<
126: END IF;
119: set_single_option_value('AMW_ACCOUNT_SOURCE_VIEW', 'GCS_NAT_ACCTS_HIER_V', 'N');
120: set_single_option_value('AMW_ACCOUNT_NAMES_VIEW', 'GCS_NAT_ACCTS_V', 'N');
121:
122: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
123: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
124: g_api || '.set_profile_option_values.end',
125: '<
126: END IF;
127:
126: END IF;
127:
128: EXCEPTION
129: WHEN OTHERS THEN
130: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
131: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
132: g_api || '.set_profile_option_values.error',
133: SQLERRM);
134: END IF;
127:
128: EXCEPTION
129: WHEN OTHERS THEN
130: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
131: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
132: g_api || '.set_profile_option_values.error',
133: SQLERRM);
134: END IF;
135: