DBA Data[Home] [Help]

APPS.FEM_SIGNAGE_PKG dependencies on FEM_ENGINES_PKG

Line 85: FEM_ENGINES_PKG.TECH_MESSAGE

81: e_type_vers EXCEPTION;
82:
83: BEGIN
84:
85: FEM_ENGINES_PKG.TECH_MESSAGE
86: (p_severity => c_log_level_3,
87: p_module => v_block,
88: p_msg_text => 'Begin');
89:

Line 93: FEM_ENGINES_PKG.TECH_MESSAGE

89:
90: ---------------------------------------------
91: -- Set Signage Values based on Signage Method
92: ---------------------------------------------
93: FEM_ENGINES_PKG.TECH_MESSAGE
94: (p_severity => c_log_level_2,
95: p_module => v_block||'.signage_method',
96: p_msg_text => c_signage_method);
97:

Line 133: FEM_ENGINES_PKG.TECH_MESSAGE

129: ELSE
130: RAISE e_bad_sign_val;
131: END IF;
132:
133: FEM_ENGINES_PKG.TECH_MESSAGE
134: (p_severity => c_log_level_3,
135: p_module => v_block||'.equity_sign',
136: p_msg_text => v_equity_sign);
137: FEM_ENGINES_PKG.TECH_MESSAGE

Line 137: FEM_ENGINES_PKG.TECH_MESSAGE

133: FEM_ENGINES_PKG.TECH_MESSAGE
134: (p_severity => c_log_level_3,
135: p_module => v_block||'.equity_sign',
136: p_msg_text => v_equity_sign);
137: FEM_ENGINES_PKG.TECH_MESSAGE
138: (p_severity => c_log_level_3,
139: p_module => v_block||'.asset_sign',
140: p_msg_text => v_asset_sign);
141: FEM_ENGINES_PKG.TECH_MESSAGE

Line 141: FEM_ENGINES_PKG.TECH_MESSAGE

137: FEM_ENGINES_PKG.TECH_MESSAGE
138: (p_severity => c_log_level_3,
139: p_module => v_block||'.asset_sign',
140: p_msg_text => v_asset_sign);
141: FEM_ENGINES_PKG.TECH_MESSAGE
142: (p_severity => c_log_level_3,
143: p_module => v_block||'.liab_sign',
144: p_msg_text => v_liab_sign);
145: FEM_ENGINES_PKG.TECH_MESSAGE

Line 145: FEM_ENGINES_PKG.TECH_MESSAGE

141: FEM_ENGINES_PKG.TECH_MESSAGE
142: (p_severity => c_log_level_3,
143: p_module => v_block||'.liab_sign',
144: p_msg_text => v_liab_sign);
145: FEM_ENGINES_PKG.TECH_MESSAGE
146: (p_severity => c_log_level_3,
147: p_module => v_block||'.expense_sign',
148: p_msg_text => v_expense_sign);
149: FEM_ENGINES_PKG.TECH_MESSAGE

Line 149: FEM_ENGINES_PKG.TECH_MESSAGE

145: FEM_ENGINES_PKG.TECH_MESSAGE
146: (p_severity => c_log_level_3,
147: p_module => v_block||'.expense_sign',
148: p_msg_text => v_expense_sign);
149: FEM_ENGINES_PKG.TECH_MESSAGE
150: (p_severity => c_log_level_3,
151: p_module => v_block||'.revenue_sign',
152: p_msg_text => v_revenue_sign);
153: FEM_ENGINES_PKG.TECH_MESSAGE

Line 153: FEM_ENGINES_PKG.TECH_MESSAGE

149: FEM_ENGINES_PKG.TECH_MESSAGE
150: (p_severity => c_log_level_3,
151: p_module => v_block||'.revenue_sign',
152: p_msg_text => v_revenue_sign);
153: FEM_ENGINES_PKG.TECH_MESSAGE
154: (p_severity => c_log_level_3,
155: p_module => v_block||'.na_sign',
156: p_msg_text => v_na_sign);
157:

Line 180: FEM_ENGINES_PKG.TECH_MESSAGE

176: FROM fem_dimensions_b A
177: WHERE A.dimension_varchar_label = 'EXTENDED_ACCOUNT_TYPE'))
178: AND default_version_flag='Y';
179:
180: FEM_ENGINES_PKG.TECH_MESSAGE
181: (p_severity => c_log_level_2,
182: p_module => v_block||'.sign_aw_snapshot_flag',
183: p_msg_text => v_aw_flag);
184: FEM_ENGINES_PKG.TECH_MESSAGE

Line 184: FEM_ENGINES_PKG.TECH_MESSAGE

180: FEM_ENGINES_PKG.TECH_MESSAGE
181: (p_severity => c_log_level_2,
182: p_module => v_block||'.sign_aw_snapshot_flag',
183: p_msg_text => v_aw_flag);
184: FEM_ENGINES_PKG.TECH_MESSAGE
185: (p_severity => c_log_level_2,
186: p_module => v_block||'.sign_attribute_id',
187: p_msg_text => v_sign_attr);
188: FEM_ENGINES_PKG.TECH_MESSAGE

Line 188: FEM_ENGINES_PKG.TECH_MESSAGE

184: FEM_ENGINES_PKG.TECH_MESSAGE
185: (p_severity => c_log_level_2,
186: p_module => v_block||'.sign_attribute_id',
187: p_msg_text => v_sign_attr);
188: FEM_ENGINES_PKG.TECH_MESSAGE
189: (p_severity => c_log_level_2,
190: p_module => v_block||'.sign_version_id',
191: p_msg_text => v_sign_vers);
192: FEM_ENGINES_PKG.TECH_MESSAGE

Line 192: FEM_ENGINES_PKG.TECH_MESSAGE

188: FEM_ENGINES_PKG.TECH_MESSAGE
189: (p_severity => c_log_level_2,
190: p_module => v_block||'.sign_version_id',
191: p_msg_text => v_sign_vers);
192: FEM_ENGINES_PKG.TECH_MESSAGE
193: (p_severity => c_log_level_2,
194: p_module => v_block||'.sign_version_count',
195: p_msg_text => v_count);
196:

Line 225: FEM_ENGINES_PKG.TECH_MESSAGE

221: FROM fem_dimensions_b A
222: WHERE A.dimension_varchar_label = 'EXTENDED_ACCOUNT_TYPE'))
223: AND default_version_flag='Y';
224:
225: FEM_ENGINES_PKG.TECH_MESSAGE
226: (p_severity => c_log_level_2,
227: p_module => v_block||'.type_attribute_id',
228: p_msg_text => v_type_attr);
229: FEM_ENGINES_PKG.TECH_MESSAGE

Line 229: FEM_ENGINES_PKG.TECH_MESSAGE

225: FEM_ENGINES_PKG.TECH_MESSAGE
226: (p_severity => c_log_level_2,
227: p_module => v_block||'.type_attribute_id',
228: p_msg_text => v_type_attr);
229: FEM_ENGINES_PKG.TECH_MESSAGE
230: (p_severity => c_log_level_2,
231: p_module => v_block||'.type_version_id',
232: p_msg_text => v_type_vers);
233: FEM_ENGINES_PKG.TECH_MESSAGE

Line 233: FEM_ENGINES_PKG.TECH_MESSAGE

229: FEM_ENGINES_PKG.TECH_MESSAGE
230: (p_severity => c_log_level_2,
231: p_module => v_block||'.type_version_id',
232: p_msg_text => v_type_vers);
233: FEM_ENGINES_PKG.TECH_MESSAGE
234: (p_severity => c_log_level_2,
235: p_module => v_block||'.type_version_count',
236: p_msg_text => v_count);
237:

Line 254: FEM_ENGINES_PKG.TECH_MESSAGE

250: 'DELETE FROM fem_ext_acct_types_attr'||
251: ' WHERE attribute_id = :b_sign_attr'||
252: ' AND version_id = :b_sign_vers';
253:
254: FEM_ENGINES_PKG.TECH_MESSAGE
255: (p_severity => c_log_level_1,
256: p_module => v_block||'.delete_sql_stmt',
257: p_msg_text => v_sql_cmd);
258:

Line 271: FEM_ENGINES_PKG.TECH_MESSAGE

267: LOOP
268: v_mem_code := r_member.ext_account_type_code;
269: v_mem_attr := r_member.dim_attribute_varchar_member;
270:
271: FEM_ENGINES_PKG.TECH_MESSAGE
272: (p_severity => c_log_level_1,
273: p_module => v_block||'.acct_type_code',
274: p_msg_text => v_mem_code);
275: FEM_ENGINES_PKG.TECH_MESSAGE

Line 275: FEM_ENGINES_PKG.TECH_MESSAGE

271: FEM_ENGINES_PKG.TECH_MESSAGE
272: (p_severity => c_log_level_1,
273: p_module => v_block||'.acct_type_code',
274: p_msg_text => v_mem_code);
275: FEM_ENGINES_PKG.TECH_MESSAGE
276: (p_severity => c_log_level_1,
277: p_module => v_block||'.varchar_member',
278: p_msg_text => v_mem_attr);
279:

Line 291: FEM_ENGINES_PKG.TECH_MESSAGE

287: WHEN 'STATISTICAL' THEN v_sign_val := 1;
288: ELSE null;
289: END CASE;
290:
291: FEM_ENGINES_PKG.TECH_MESSAGE
292: (p_severity => c_log_level_1,
293: p_module => v_block||'.sign_value',
294: p_msg_text => v_sign_val);
295:

Line 307: FEM_ENGINES_PKG.TECH_MESSAGE

303: ','||v_sign_val||','''||sysdate||''','||c_user_id||
304: ','||c_user_id||','''||sysdate||''''||
305: ',1,'''||v_aw_flag||''')';
306:
307: FEM_ENGINES_PKG.TECH_MESSAGE
308: (p_severity => c_log_level_1,
309: p_module => v_block||'.insert_sql_stmt',
310: p_msg_text => v_sql_cmd);
311:

Line 321: FEM_ENGINES_PKG.PUT_MESSAGE

317:
318: --------------------------
319: -- Post Completion Message
320: --------------------------
321: FEM_ENGINES_PKG.PUT_MESSAGE
322: (p_app_name => 'FEM',
323: p_msg_name => 'FEM_SIGN_COMPLETION_TXT');
324: v_message :=FND_MSG_PUB.GET(p_encoded => c_false);
325:

Line 326: FEM_ENGINES_PKG.TECH_MESSAGE

322: (p_app_name => 'FEM',
323: p_msg_name => 'FEM_SIGN_COMPLETION_TXT');
324: v_message :=FND_MSG_PUB.GET(p_encoded => c_false);
325:
326: FEM_ENGINES_PKG.TECH_MESSAGE
327: (p_severity => c_log_level_3,
328: p_module => v_block||'.Complete',
329: p_msg_text => v_message);
330:

Line 331: FEM_ENGINES_PKG.USER_MESSAGE

327: (p_severity => c_log_level_3,
328: p_module => v_block||'.Complete',
329: p_msg_text => v_message);
330:
331: FEM_ENGINES_PKG.USER_MESSAGE
332: (p_msg_text => v_message);
333:
334: ----------------
335: -- Exceptions --

Line 341: FEM_ENGINES_PKG.PUT_MESSAGE

337: EXCEPTION
338:
339: WHEN e_no_sign_val THEN
340:
341: FEM_ENGINES_PKG.PUT_MESSAGE
342: (p_app_name => 'FEM',
343: p_msg_name => 'FEM_SIGN_NO_SIGN_VAL_ERR');
344:
345: v_message := FND_MSG_PUB.GET(p_encoded => c_false);

Line 347: FEM_ENGINES_PKG.TECH_MESSAGE

343: p_msg_name => 'FEM_SIGN_NO_SIGN_VAL_ERR');
344:
345: v_message := FND_MSG_PUB.GET(p_encoded => c_false);
346:
347: FEM_ENGINES_PKG.TECH_MESSAGE
348: (p_severity => c_log_level_2,
349: p_module => v_block||'.no_sign_val',
350: p_msg_text => v_message);
351:

Line 352: FEM_ENGINES_PKG.USER_MESSAGE

348: (p_severity => c_log_level_2,
349: p_module => v_block||'.no_sign_val',
350: p_msg_text => v_message);
351:
352: FEM_ENGINES_PKG.USER_MESSAGE
353: (p_msg_text => v_message);
354:
355: f_set_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',null);
356:

Line 359: FEM_ENGINES_PKG.PUT_MESSAGE

355: f_set_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',null);
356:
357: WHEN e_bad_sign_val THEN
358:
359: FEM_ENGINES_PKG.PUT_MESSAGE
360: (p_app_name => 'FEM',
361: p_msg_name => 'FEM_SIGN_BAD_SIGN_VAL_ERR',
362: p_token1 => 'SIGN',
363: p_value1 => c_signage_method);

Line 367: FEM_ENGINES_PKG.TECH_MESSAGE

363: p_value1 => c_signage_method);
364:
365: v_message := FND_MSG_PUB.GET(p_encoded => c_false);
366:
367: FEM_ENGINES_PKG.TECH_MESSAGE
368: (p_severity => c_log_level_2,
369: p_module => v_block||'.bad_sign_val',
370: p_msg_text => v_message);
371:

Line 372: FEM_ENGINES_PKG.USER_MESSAGE

368: (p_severity => c_log_level_2,
369: p_module => v_block||'.bad_sign_val',
370: p_msg_text => v_message);
371:
372: FEM_ENGINES_PKG.USER_MESSAGE
373: (p_msg_text => v_message);
374:
375: f_set_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',null);
376:

Line 379: FEM_ENGINES_PKG.PUT_MESSAGE

375: f_set_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',null);
376:
377: WHEN e_sign_vers THEN
378:
379: FEM_ENGINES_PKG.PUT_MESSAGE
380: (p_app_name => 'FEM',
381: p_msg_name => 'FEM_SIGN_BAD_SIGN_VER_ERR');
382:
383: v_message := FND_MSG_PUB.GET(p_encoded => c_false);

Line 385: FEM_ENGINES_PKG.TECH_MESSAGE

381: p_msg_name => 'FEM_SIGN_BAD_SIGN_VER_ERR');
382:
383: v_message := FND_MSG_PUB.GET(p_encoded => c_false);
384:
385: FEM_ENGINES_PKG.TECH_MESSAGE
386: (p_severity => c_log_level_2,
387: p_module => v_block||'.bad_sign_ver',
388: p_msg_text => v_message);
389:

Line 390: FEM_ENGINES_PKG.USER_MESSAGE

386: (p_severity => c_log_level_2,
387: p_module => v_block||'.bad_sign_ver',
388: p_msg_text => v_message);
389:
390: FEM_ENGINES_PKG.USER_MESSAGE
391: (p_msg_text => v_message);
392:
393: f_set_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',null);
394:

Line 397: FEM_ENGINES_PKG.PUT_MESSAGE

393: f_set_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',null);
394:
395: WHEN e_type_vers THEN
396:
397: FEM_ENGINES_PKG.PUT_MESSAGE
398: (p_app_name => 'FEM',
399: p_msg_name => 'FEM_SIGN_BAD_TYPE_VER_ERR');
400:
401: v_message := FND_MSG_PUB.GET(p_encoded => c_false);

Line 403: FEM_ENGINES_PKG.TECH_MESSAGE

399: p_msg_name => 'FEM_SIGN_BAD_TYPE_VER_ERR');
400:
401: v_message := FND_MSG_PUB.GET(p_encoded => c_false);
402:
403: FEM_ENGINES_PKG.TECH_MESSAGE
404: (p_severity => c_log_level_2,
405: p_module => v_block||'.bad_type_ver',
406: p_msg_text => v_message);
407:

Line 408: FEM_ENGINES_PKG.USER_MESSAGE

404: (p_severity => c_log_level_2,
405: p_module => v_block||'.bad_type_ver',
406: p_msg_text => v_message);
407:
408: FEM_ENGINES_PKG.USER_MESSAGE
409: (p_msg_text => v_message);
410:
411: f_set_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',null);
412:

Line 417: FEM_ENGINES_PKG.TECH_MESSAGE

413: WHEN others THEN
414:
415: v_message := sqlerrm;
416:
417: FEM_ENGINES_PKG.TECH_MESSAGE
418: (p_severity => c_log_level_6,
419: p_module => v_block||'.Exception',
420: p_msg_text => sqlerrm);
421:

Line 422: FEM_ENGINES_PKG.USER_MESSAGE

418: (p_severity => c_log_level_6,
419: p_module => v_block||'.Exception',
420: p_msg_text => sqlerrm);
421:
422: FEM_ENGINES_PKG.USER_MESSAGE
423: (p_msg_text => v_message);
424:
425: END Sign_Ext_Acct_Types;
426: