DBA Data[Home] [Help]

APPS.GL_COA_SEG_VAL_IMP_PUB dependencies on FND_GLOBAL

Line 173: x_msg_data := x_msg_data || 'Start of error messages for Import of Segment values'||FND_GLOBAL.newline;

169: --Populate the x_msg_data
170: --get the error messages from stack for l_gl_flex_values_tbl
171: IF x_return_status = 'E' THEN
172: l_err_msg:= NULL;
173: x_msg_data := x_msg_data || 'Start of error messages for Import of Segment values'||FND_GLOBAL.newline;
174: IF l_gl_flex_values_tbl.COUNT > 0 THEN
175: FOR i IN 1..l_gl_flex_values_tbl.LAST
176: LOOP
177: IF l_gl_flex_values_tbl.EXISTS(I) THEN

Line 180: 'AND' || l_gl_flex_values_tbl(I).flex_value || FND_GLOBAL.newline;

176: LOOP
177: IF l_gl_flex_values_tbl.EXISTS(I) THEN
178: IF l_gl_flex_values_tbl(i).status = 'E' THEN
179: l_err_msg := l_err_msg || 'Error for '|| l_gl_flex_values_tbl(I).value_set_name ||
180: 'AND' || l_gl_flex_values_tbl(I).flex_value || FND_GLOBAL.newline;
181: FOR l_curr_num IN l_gl_flex_values_tbl(i).msg_from..l_gl_flex_values_tbl(i).msg_to
182: LOOP
183: l_c_msg_name := get_msg_from_stack(l_curr_num);
184: get_message(l_c_msg_name,l_n_msg_num,l_c_msg_txt);

Line 188: x_msg_data := x_msg_data ||l_err_msg||FND_GLOBAL.newline;

184: get_message(l_c_msg_name,l_n_msg_num,l_c_msg_txt);
185: l_c_msg_txt := fnd_msg_pub.get(l_curr_num,'F');
186: l_err_msg := l_err_msg || 'Message No. '|| I ||' ' || l_c_msg_txt;
187: IF length(l_err_msg) + length(x_msg_data) < 32000 THEN
188: x_msg_data := x_msg_data ||l_err_msg||FND_GLOBAL.newline;
189: END IF;
190: END LOOP;
191: l_err_msg:= NULL;
192: END IF;

Line 201: x_msg_data := x_msg_data || 'Start of error messages for Import of child ranges for parent values'||FND_GLOBAL.newline;

197:
198: --get the error messages from stack for l_gl_flex_values_nh_tbl
199: IF x_return_status = 'E' THEN
200: l_err_msg:= NULL;
201: x_msg_data := x_msg_data || 'Start of error messages for Import of child ranges for parent values'||FND_GLOBAL.newline;
202: IF l_gl_flex_values_nh_tbl.COUNT > 0 THEN
203: FOR i IN 1..l_gl_flex_values_nh_tbl.LAST
204: LOOP
205: IF l_gl_flex_values_tbl.EXISTS(I) THEN

Line 211: 'AND '|| l_gl_flex_values_nh_tbl(I).child_flex_value_high || FND_GLOBAL.newline;

207: l_err_msg := l_err_msg || 'Error for '|| l_gl_flex_values_nh_tbl(I).value_set_name ||
208: 'AND '|| l_gl_flex_values_nh_tbl(I).parent_flex_value ||
209: 'AND '|| l_gl_flex_values_nh_tbl(I).range_attribute ||
210: 'AND '|| l_gl_flex_values_nh_tbl(I).child_flex_value_low ||
211: 'AND '|| l_gl_flex_values_nh_tbl(I).child_flex_value_high || FND_GLOBAL.newline;
212: FOR l_curr_num IN l_gl_flex_values_nh_tbl(i).msg_from..l_gl_flex_values_nh_tbl(i).msg_to
213: LOOP
214: l_c_msg_name := get_msg_from_stack(l_curr_num);
215: get_message(l_c_msg_name,l_n_msg_num,l_c_msg_txt);

Line 219: x_msg_data := x_msg_data ||l_err_msg||FND_GLOBAL.newline;

215: get_message(l_c_msg_name,l_n_msg_num,l_c_msg_txt);
216: l_c_msg_txt := fnd_msg_pub.get(l_curr_num,'F');
217: l_err_msg := l_err_msg || 'Message No. '|| I ||' ' || l_c_msg_txt;
218: IF length(l_err_msg) + length(x_msg_data) < 32000 THEN
219: x_msg_data := x_msg_data ||l_err_msg||FND_GLOBAL.newline;
220: END IF;
221: END LOOP;
222: l_err_msg:= NULL;
223: END IF;

Line 229: l_user_id := fnd_global.user_id;

225: END LOOP;
226: END IF;
227: END IF;
228:
229: l_user_id := fnd_global.user_id;
230: l_resp_id := fnd_global.resp_id;
231: l_apps_id := fnd_global.resp_appl_id;
232: fnd_global.apps_initialize (l_user_id, l_resp_id, l_apps_id);
233: fnd_profile.get('GL_ACCESS_SET_ID', l_acc_set_id);

Line 230: l_resp_id := fnd_global.resp_id;

226: END IF;
227: END IF;
228:
229: l_user_id := fnd_global.user_id;
230: l_resp_id := fnd_global.resp_id;
231: l_apps_id := fnd_global.resp_appl_id;
232: fnd_global.apps_initialize (l_user_id, l_resp_id, l_apps_id);
233: fnd_profile.get('GL_ACCESS_SET_ID', l_acc_set_id);
234: --Submit the Request for "Program - Inherit Segment Value Attributes"

Line 231: l_apps_id := fnd_global.resp_appl_id;

227: END IF;
228:
229: l_user_id := fnd_global.user_id;
230: l_resp_id := fnd_global.resp_id;
231: l_apps_id := fnd_global.resp_appl_id;
232: fnd_global.apps_initialize (l_user_id, l_resp_id, l_apps_id);
233: fnd_profile.get('GL_ACCESS_SET_ID', l_acc_set_id);
234: --Submit the Request for "Program - Inherit Segment Value Attributes"
235: l_req_id :=fnd_request.submit_request('SQLGL', 'GLNSVI', '', '', FALSE,l_acc_set_id,'Y',

Line 232: fnd_global.apps_initialize (l_user_id, l_resp_id, l_apps_id);

228:
229: l_user_id := fnd_global.user_id;
230: l_resp_id := fnd_global.resp_id;
231: l_apps_id := fnd_global.resp_appl_id;
232: fnd_global.apps_initialize (l_user_id, l_resp_id, l_apps_id);
233: fnd_profile.get('GL_ACCESS_SET_ID', l_acc_set_id);
234: --Submit the Request for "Program - Inherit Segment Value Attributes"
235: l_req_id :=fnd_request.submit_request('SQLGL', 'GLNSVI', '', '', FALSE,l_acc_set_id,'Y',
236: CHR(0), '', '', '', '', '', '',