DBA Data[Home] [Help]

APPS.FEM_BR_CONDITION_PVT dependencies on FEM_ENGINES_PKG

Line 70: FEM_ENGINES_PKG.Tech_Message (

66: l_callstack VARCHAR2(2000);
67:
68: BEGIN
69:
70: FEM_ENGINES_PKG.Tech_Message (
71: p_severity => G_LOG_LEVEL_3
72: ,p_module => G_BLOCK||'.'||l_api_name
73: ,p_msg_text => 'BEGIN'
74: );

Line 80: FEM_ENGINES_PKG.Tech_Message (

76: DeleteConditions(
77: p_obj_def_id => p_obj_def_id
78: );
79:
80: FEM_ENGINES_PKG.Tech_Message (
81: p_severity => G_LOG_LEVEL_3
82: ,p_module => G_BLOCK||'.'||l_api_name
83: ,p_msg_text => 'END'
84: );

Line 91: FEM_ENGINES_PKG.Tech_Message (

87:
88: when others then
89: l_callstack := DBMS_UTILITY.Format_Call_Stack;
90: l_prg_msg := SQLERRM;
91: FEM_ENGINES_PKG.Tech_Message (
92: p_severity => G_LOG_LEVEL_6
93: ,p_module => G_BLOCK||'.'||l_api_name
94: ,p_msg_text => 'others condition, l_callstack:' || l_callstack
95: );

Line 96: FEM_ENGINES_PKG.Tech_Message (

92: p_severity => G_LOG_LEVEL_6
93: ,p_module => G_BLOCK||'.'||l_api_name
94: ,p_msg_text => 'others condition, l_callstack:' || l_callstack
95: );
96: FEM_ENGINES_PKG.Tech_Message (
97: p_severity => G_LOG_LEVEL_6
98: ,p_module => G_BLOCK||'.'||l_api_name
99: ,p_msg_text => 'others condition, l_prg_msg:' || l_prg_msg
100: );

Line 188: FEM_ENGINES_PKG.Tech_Message (

184: l_callstack VARCHAR2(2000);
185:
186: BEGIN
187:
188: FEM_ENGINES_PKG.Tech_Message (
189: p_severity => G_LOG_LEVEL_3
190: ,p_module => G_BLOCK||'.'||g_api_name
191: ,p_msg_text => 'BEGIN'
192: );

Line 202: FEM_ENGINES_PKG.Tech_Message (

198:
199: -- Initialize API return status to success
200: x_return_status := FND_API.G_RET_STS_SUCCESS;
201:
202: FEM_ENGINES_PKG.Tech_Message (
203: p_severity => G_LOG_LEVEL_3
204: ,p_module => G_BLOCK||'.'||g_api_name
205: ,p_msg_text => 'Before DeleteCondComponentDtls'
206: );

Line 215: FEM_ENGINES_PKG.Tech_Message (

211: ,p_cond_component_obj_id => p_cond_component_obj_id
212: ,p_data_dim_flag => p_data_dim_flag
213: );
214:
215: FEM_ENGINES_PKG.Tech_Message (
216: p_severity => G_LOG_LEVEL_3
217: ,p_module => G_BLOCK||'.'||g_api_name
218: ,p_msg_text => 'After DeleteCondComponentDtls'
219: );

Line 226: FEM_ENGINES_PKG.Tech_Message (

222:
223: when FND_API.G_EXC_ERROR then
224: x_return_status := FND_API.G_RET_STS_ERROR;
225: l_callstack := DBMS_UTILITY.Format_Call_Stack;
226: FEM_ENGINES_PKG.Tech_Message (
227: p_severity => G_LOG_LEVEL_6
228: ,p_module => G_BLOCK||'.'||g_api_name
229: ,p_msg_text => 'G_EXC_ERROR, l_callstack:' || l_callstack
230: );

Line 239: FEM_ENGINES_PKG.Tech_Message (

235:
236: when FND_API.G_EXC_UNEXPECTED_ERROR then
237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
238: l_callstack := DBMS_UTILITY.Format_Call_Stack;
239: FEM_ENGINES_PKG.Tech_Message (
240: p_severity => G_LOG_LEVEL_6
241: ,p_module => G_BLOCK||'.'||g_api_name
242: ,p_msg_text => 'G_EXC_UNEXPECTED_ERROR, l_callstack:' || l_callstack
243: );

Line 253: FEM_ENGINES_PKG.Tech_Message (

249: when others then
250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
251: l_callstack := DBMS_UTILITY.Format_Call_Stack;
252: l_prg_msg := SQLERRM;
253: FEM_ENGINES_PKG.Tech_Message (
254: p_severity => G_LOG_LEVEL_6
255: ,p_module => G_BLOCK||'.'||g_api_name
256: ,p_msg_text => 'others, l_callstack:' || l_callstack
257: );

Line 258: FEM_ENGINES_PKG.Tech_Message (

254: p_severity => G_LOG_LEVEL_6
255: ,p_module => G_BLOCK||'.'||g_api_name
256: ,p_msg_text => 'others, l_callstack:' || l_callstack
257: );
258: FEM_ENGINES_PKG.Tech_Message (
259: p_severity => G_LOG_LEVEL_6
260: ,p_module => G_BLOCK||'.'||g_api_name
261: ,p_msg_text => 'others 1, l_prg_msg:' || l_prg_msg
262: );

Line 318: FEM_ENGINES_PKG.Tech_Message (

314:
315:
316: BEGIN
317:
318: FEM_ENGINES_PKG.Tech_Message (
319: p_severity => G_LOG_LEVEL_3
320: ,p_module => G_BLOCK||'.'||l_api_name
321: ,p_msg_text => 'BEGIN, p_obj_def_id:' || p_obj_def_id
322: );

Line 335: FEM_ENGINES_PKG.Tech_Message (

331: INTO v_component_rows_num
332: FROM fem_cond_components
333: WHERE cond_component_obj_id = v_cond_comp_obj_id;
334:
335: FEM_ENGINES_PKG.Tech_Message (
336: p_severity => G_LOG_LEVEL_3
337: ,p_module => G_BLOCK||'.'||l_api_name
338: ,p_msg_text => 'v_component_rows_num:' || v_component_rows_num
339: );

Line 345: FEM_ENGINES_PKG.Tech_Message (

341:
342: EXIT WHEN c1%NOTFOUND;
343:
344: IF (v_component_rows_num = 1) THEN
345: FEM_ENGINES_PKG.Tech_Message (
346: p_severity => G_LOG_LEVEL_3
347: ,p_module => G_BLOCK||'.'||l_api_name
348: ,p_msg_text => 'before calling DeleteCondComponent'
349: );

Line 359: FEM_ENGINES_PKG.Tech_Message (

355: ,x_return_status
356: ,x_msg_count
357: ,x_msg_data
358: );
359: FEM_ENGINES_PKG.Tech_Message (
360: p_severity => G_LOG_LEVEL_3
361: ,p_module => G_BLOCK||'.'||l_api_name
362: ,p_msg_text => 'after calling DeleteCondComponent'
363: );

Line 369: FEM_ENGINES_PKG.Tech_Message (

365:
366: END LOOP;
367:
368: CLOSE c1;
369: FEM_ENGINES_PKG.Tech_Message (
370: p_severity => G_LOG_LEVEL_3
371: ,p_module => G_BLOCK||'.'||l_api_name
372: ,p_msg_text => 'continue'
373: );

Line 379: FEM_ENGINES_PKG.Tech_Message (

375: delete from fem_cond_components
376: where condition_obj_def_id = p_obj_def_id;
377:
378: delete from fem_object_dependencies where object_definition_id = p_obj_def_id;
379: FEM_ENGINES_PKG.Tech_Message (
380: p_severity => G_LOG_LEVEL_3
381: ,p_module => G_BLOCK||'.'||l_api_name
382: ,p_msg_text => 'end'
383: );

Line 468: FEM_ENGINES_PKG.Tech_Message (

464: l_callstack VARCHAR2(2000);
465:
466:
467: BEGIN
468: FEM_ENGINES_PKG.Tech_Message (
469: p_severity => G_LOG_LEVEL_3
470: ,p_module => G_BLOCK||'.'||l_api_name
471: ,p_msg_text => 'BEGIN, p_condition_obj_def_id:' || p_condition_obj_def_id
472: || ' p_cond_component_obj_id:' || p_cond_component_obj_id

Line 482: FEM_ENGINES_PKG.Tech_Message (

478: FROM fem_cond_components
479: WHERE cond_component_obj_id = p_cond_component_obj_id
480: AND condition_obj_def_id <> p_condition_obj_def_id;
481:
482: FEM_ENGINES_PKG.Tech_Message (
483: p_severity => G_LOG_LEVEL_3
484: ,p_module => G_BLOCK||'.'||l_api_name
485: ,p_msg_text => 'v_component_rows_num:' || v_component_rows_num
486: );

Line 490: FEM_ENGINES_PKG.Tech_Message (

486: );
487:
488: IF (v_component_rows_num = 0) THEN
489:
490: FEM_ENGINES_PKG.Tech_Message (
491: p_severity => G_LOG_LEVEL_3
492: ,p_module => G_BLOCK||'.'||l_api_name
493: ,p_msg_text => 'v_component_rows_num = 0'
494: );

Line 501: FEM_ENGINES_PKG.Tech_Message (

497: INTO l_cond_component_obj_def_id
498: FROM FEM_OBJECT_DEFINITION_VL
499: WHERE OBJECT_ID = p_cond_component_obj_id;
500:
501: FEM_ENGINES_PKG.Tech_Message (
502: p_severity => G_LOG_LEVEL_3
503: ,p_module => G_BLOCK||'.'||l_api_name
504: ,p_msg_text => 'v_component_rows_num = 0, l_cond_component_obj_def_id:'
505: || l_cond_component_obj_def_id

Line 515: FEM_ENGINES_PKG.Tech_Message (

511: ,x_approval_edit_lock_exists => l_approval_edit_lock_exists
512: ,x_data_edit_lock_exists => l_data_edit_lock_exists
513: );
514:
515: FEM_ENGINES_PKG.Tech_Message (
516: p_severity => G_LOG_LEVEL_3
517: ,p_module => G_BLOCK||'.'||l_api_name
518: ,p_msg_text => 'v_component_rows_num = 0, l_approval_edit_lock_exists:'
519: || l_approval_edit_lock_exists || ' l_data_edit_lock_exists:'

Line 532: FEM_ENGINES_PKG.Tech_Message (

528: end if;
529: */
530:
531: IF (not FND_API.To_Boolean(l_data_edit_lock_exists)) THEN
532: FEM_ENGINES_PKG.Tech_Message (
533: p_severity => G_LOG_LEVEL_3
534: ,p_module => G_BLOCK||'.'||l_api_name
535: ,p_msg_text => 'not l_data_edit_lock_exists'
536: );

Line 540: FEM_ENGINES_PKG.Tech_Message (

536: );
537:
538: IF (p_data_dim_flag = 'T') THEN
539:
540: FEM_ENGINES_PKG.Tech_Message (
541: p_severity => G_LOG_LEVEL_3
542: ,p_module => G_BLOCK||'.'||l_api_name
543: ,p_msg_text => 'p_data_dim_flag = T'
544: );

Line 558: FEM_ENGINES_PKG.Tech_Message (

554:
555: ELSE
556:
557:
558: FEM_ENGINES_PKG.Tech_Message (
559: p_severity => G_LOG_LEVEL_3
560: ,p_module => G_BLOCK||'.'||l_api_name
561: ,p_msg_text => 'p_data_dim_flag <> T'
562: );

Line 572: FEM_ENGINES_PKG.Tech_Message (

568:
569: END IF;
570:
571:
572: FEM_ENGINES_PKG.Tech_Message (
573: p_severity => G_LOG_LEVEL_3
574: ,p_module => G_BLOCK||'.'||l_api_name
575: ,p_msg_text => 'Before delete from fem_object_dependencies'
576: );

Line 586: FEM_ENGINES_PKG.Tech_Message (

582:
583: delete from fem_object_catalog_vl
584: where object_id = p_cond_component_obj_id;
585:
586: FEM_ENGINES_PKG.Tech_Message (
587: p_severity => G_LOG_LEVEL_3
588: ,p_module => G_BLOCK||'.'||l_api_name
589: ,p_msg_text => 'After delete from fem_object_catalog_vl'
590: );

Line 596: FEM_ENGINES_PKG.Tech_Message (

592: END IF;
593:
594: END IF;
595:
596: FEM_ENGINES_PKG.Tech_Message (
597: p_severity => G_LOG_LEVEL_3
598: ,p_module => G_BLOCK||'.'||l_api_name
599: ,p_msg_text => 'END'
600: );

Line 606: FEM_ENGINES_PKG.Tech_Message (

602: EXCEPTION
603: when others then
604: l_callstack := DBMS_UTILITY.Format_Call_Stack;
605: l_prg_msg := SQLERRM;
606: FEM_ENGINES_PKG.Tech_Message (
607: p_severity => G_LOG_LEVEL_6
608: ,p_module => G_BLOCK||'.'||l_api_name
609: ,p_msg_text => 'others, l_callstack:' || l_callstack
610: );

Line 611: FEM_ENGINES_PKG.Tech_Message (

607: p_severity => G_LOG_LEVEL_6
608: ,p_module => G_BLOCK||'.'||l_api_name
609: ,p_msg_text => 'others, l_callstack:' || l_callstack
610: );
611: FEM_ENGINES_PKG.Tech_Message (
612: p_severity => G_LOG_LEVEL_6
613: ,p_module => G_BLOCK||'.'||l_api_name
614: ,p_msg_text => 'others 1, l_prg_msg:' || l_prg_msg
615: );