APPS.FEM_MIR_PKG dependencies on FEM_ENGINES_PKG

Line 67: FEM_ENGINES_PKG.Tech_Message (

63: l_prg_msg VARCHAR2(2000);
64:
65: BEGIN
66:
67: FEM_ENGINES_PKG.Tech_Message (
68: p_severity => c_log_level_2
69: ,p_module => c_module_pkg||'.'||l_api_name
70: ,p_msg_text => 'Begining Function'
71: );

Line 82: FEM_ENGINES_PKG.Tech_Message (

78: WHERE A.DIMENSION_GROUP_ID = p_dimension_group_id
79: AND B.dimension_id = A.dimension_id
80: AND B.dimension_varchar_label = p_dimension_varchar_label;
81:
82: FEM_ENGINES_PKG.Tech_Message (
83: p_severity => c_log_level_2
84: ,p_module => c_module_pkg||'.'||l_api_name
85: ,p_msg_text => 'Ending Function'
86: );

Line 94: FEM_ENGINES_PKG.Tech_Message (

90: EXCEPTION
91:
92: WHEN NO_DATA_FOUND THEN
93:
94: FEM_ENGINES_PKG.Tech_Message (
95: p_severity => c_log_level_4
96: ,p_module => c_module_pkg||'.'||l_api_name
97: ,p_msg_text => 'Dimension Group Display Code does not Exists for '||
98: 'given Dimension Group ID and Dimension'

Line 101: FEM_ENGINES_PKG.User_Message (

97: ,p_msg_text => 'Dimension Group Display Code does not Exists for '||
98: 'given Dimension Group ID and Dimension'
99: );
100:
101: FEM_ENGINES_PKG.User_Message (
102: p_app_name => G_FEM
103: ,p_msg_name => c_exp_could_not_found_err
104: ,p_token1 => 'API_NAME'
105: ,p_value1 => l_api_name

Line 114: FEM_ENGINES_PKG.Tech_Message (

110: RETURN l_grp_display_code;
111:
112: WHEN TOO_MANY_ROWS THEN
113:
114: FEM_ENGINES_PKG.Tech_Message (
115: p_severity => c_log_level_4
116: ,p_module => c_module_pkg||'.'||l_api_name
117: ,p_msg_text => 'Dimension Group ID returned more than 1 '||
118: 'Dimension Group display code'

Line 121: FEM_ENGINES_PKG.User_Message (

117: ,p_msg_text => 'Dimension Group ID returned more than 1 '||
118: 'Dimension Group display code'
119: );
120:
121: FEM_ENGINES_PKG.User_Message (
122: p_app_name => G_FEM
123: ,p_msg_name => c_exp_more_rows_found_err
124: ,p_token1 => 'API_NAME'
125: ,p_value1 => l_api_name

Line 136: FEM_ENGINES_PKG.Tech_Message (

132: WHEN OTHERS THEN
133:
134: l_prg_msg := SQLERRM;
135:
136: FEM_ENGINES_PKG.Tech_Message (
137: p_severity => c_log_level_6
138: ,p_module => c_module_pkg||'.'||l_api_name
139: ,p_msg_text => l_prg_msg
140: );

Line 173: FEM_ENGINES_PKG.Tech_Message (

169: l_prg_msg VARCHAR2(2000);
170:
171: BEGIN
172:
173: FEM_ENGINES_PKG.Tech_Message (
174: p_severity => c_log_level_2
175: ,p_module => c_module_pkg||'.'||l_api_name
176: ,p_msg_text => 'Begining Function'
177: );

Line 188: FEM_ENGINES_PKG.Tech_Message (

184: WHERE A.DIMENSION_GROUP_ID = p_dimension_group_id
185: AND B.dimension_id = A.dimension_id
186: AND B.dimension_id = p_dimension_id;
187:
188: FEM_ENGINES_PKG.Tech_Message (
189: p_severity => c_log_level_2
190: ,p_module => c_module_pkg||'.'||l_api_name
191: ,p_msg_text => 'Ending function'
192: );

Line 200: FEM_ENGINES_PKG.Tech_Message (

196: EXCEPTION
197:
198: WHEN NO_DATA_FOUND THEN
199:
200: FEM_ENGINES_PKG.Tech_Message (
201: p_severity => c_log_level_4
202: ,p_module => c_module_pkg||'.'||l_api_name
203: ,p_msg_text => 'Dimension Group Display Code does not Exists for '||
204: 'given Dimension Group ID and Dimension'

Line 207: FEM_ENGINES_PKG.User_Message (

203: ,p_msg_text => 'Dimension Group Display Code does not Exists for '||
204: 'given Dimension Group ID and Dimension'
205: );
206:
207: FEM_ENGINES_PKG.User_Message (
208: p_app_name => G_FEM
209: ,p_msg_name => c_exp_could_not_found_err
210: ,p_token1 => 'API_NAME'
211: ,p_value1 => l_api_name

Line 220: FEM_ENGINES_PKG.Tech_Message (

216: RETURN l_grp_display_code;
217:
218: WHEN TOO_MANY_ROWS THEN
219:
220: FEM_ENGINES_PKG.Tech_Message (
221: p_severity => c_log_level_4
222: ,p_module => c_module_pkg||'.'||l_api_name
223: ,p_msg_text => 'Dimension Group ID returned more than 1 '||
224: 'Dimension Group display code'

Line 227: FEM_ENGINES_PKG.User_Message (

223: ,p_msg_text => 'Dimension Group ID returned more than 1 '||
224: 'Dimension Group display code'
225: );
226:
227: FEM_ENGINES_PKG.User_Message (
228: p_app_name => G_FEM
229: ,p_msg_name => c_exp_more_rows_found_err
230: ,p_token1 => 'API_NAME'
231: ,p_value1 => l_api_name

Line 242: FEM_ENGINES_PKG.Tech_Message (

238: WHEN OTHERS THEN
239:
240: l_prg_msg := SQLERRM;
241:
242: FEM_ENGINES_PKG.Tech_Message (
243: p_severity => c_log_level_6
244: ,p_module => c_module_pkg||'.'||l_api_name
245: ,p_msg_text => l_prg_msg
246: );

Line 284: FEM_ENGINES_PKG.Tech_Message (

280: l_prg_msg VARCHAR2(2000);
281:
282: BEGIN
283:
284: FEM_ENGINES_PKG.Tech_Message (
285: p_severity => c_log_level_2
286: ,p_module => c_module_pkg||'.'||l_api_name
287: ,p_msg_text => 'Begining Function'
288: );

Line 300: FEM_ENGINES_PKG.Tech_Message (

296: WHERE A.DIMENSION_GROUP_DISPLAY_CODE = p_dim_group_display_code
297: AND B.dimension_id = A.dimension_id
298: AND B.dimension_varchar_label = p_dimension_varchar_label;
299:
300: FEM_ENGINES_PKG.Tech_Message (
301: p_severity => c_log_level_2
302: ,p_module => c_module_pkg||'.'||l_api_name
303: ,p_msg_text => 'Ending Function'
304: );

Line 311: FEM_ENGINES_PKG.Tech_Message (

307:
308: EXCEPTION
309:
310: WHEN NO_DATA_FOUND THEN
311: FEM_ENGINES_PKG.Tech_Message (
312: p_severity => c_log_level_4
313: ,p_module => c_module_pkg||'.'||l_api_name
314: ,p_msg_text => 'Dimension Group ID does not Exists for '||
315: 'given Dimension Group display code and Dimension'

Line 318: FEM_ENGINES_PKG.User_Message (

314: ,p_msg_text => 'Dimension Group ID does not Exists for '||
315: 'given Dimension Group display code and Dimension'
316: );
317:
318: FEM_ENGINES_PKG.User_Message (
319: p_app_name => G_FEM
320: ,p_msg_name => c_imp_could_not_found_err
321: ,p_token1 => 'API_NAME'
322: ,p_value1 => l_api_name

Line 331: FEM_ENGINES_PKG.Tech_Message (

327: x_return_status := FND_API.G_RET_STS_ERROR;
328: RETURN l_dimension_group_id;
329:
330: WHEN TOO_MANY_ROWS THEN
331: FEM_ENGINES_PKG.Tech_Message (
332: p_severity => c_log_level_4
333: ,p_module => c_module_pkg||'.'||l_api_name
334: ,p_msg_text => 'Dimension Group display code returned more than 1 '||
335: 'Dimension Group Id'

Line 338: FEM_ENGINES_PKG.User_Message (

334: ,p_msg_text => 'Dimension Group display code returned more than 1 '||
335: 'Dimension Group Id'
336: );
337:
338: FEM_ENGINES_PKG.User_Message (
339: p_app_name => G_FEM
340: ,p_msg_name => c_imp_more_rows_found_err
341: ,p_token1 => 'API_NAME'
342: ,p_value1 => l_api_name

Line 354: FEM_ENGINES_PKG.Tech_Message (

350: WHEN OTHERS THEN
351:
352: l_prg_msg := SQLERRM;
353:
354: FEM_ENGINES_PKG.Tech_Message (
355: p_severity => c_log_level_6
356: ,p_module => c_module_pkg||'.'||l_api_name
357: ,p_msg_text => l_prg_msg
358: );

Line 396: FEM_ENGINES_PKG.Tech_Message (

392: l_prg_msg VARCHAR2(2000);
393:
394: BEGIN
395:
396: FEM_ENGINES_PKG.Tech_Message (
397: p_severity => c_log_level_2
398: ,p_module => c_module_pkg||'.'||l_api_name
399: ,p_msg_text => 'Begining Function'
400: );

Line 412: FEM_ENGINES_PKG.Tech_Message (

408: WHERE A.DIMENSION_GROUP_DISPLAY_CODE = p_dim_group_display_code
409: AND B.dimension_id = A.dimension_id
410: AND B.dimension_id = p_dimension_id;
411:
412: FEM_ENGINES_PKG.Tech_Message (
413: p_severity => c_log_level_2
414: ,p_module => c_module_pkg||'.'||l_api_name
415: ,p_msg_text => 'End'
416: );

Line 423: FEM_ENGINES_PKG.Tech_Message (

419:
420: EXCEPTION
421:
422: WHEN NO_DATA_FOUND THEN
423: FEM_ENGINES_PKG.Tech_Message (
424: p_severity => c_log_level_4
425: ,p_module => c_module_pkg||'.'||l_api_name
426: ,p_msg_text => 'Dimension Group ID does not Exists for '||
427: 'given Dimension Group display code and Dimension'

Line 430: FEM_ENGINES_PKG.User_Message (

426: ,p_msg_text => 'Dimension Group ID does not Exists for '||
427: 'given Dimension Group display code and Dimension'
428: );
429:
430: FEM_ENGINES_PKG.User_Message (
431: p_app_name => G_FEM
432: ,p_msg_name => c_imp_could_not_found_err
433: ,p_token1 => 'API_NAME'
434: ,p_value1 => l_api_name

Line 443: FEM_ENGINES_PKG.Tech_Message (

439: x_return_status := FND_API.G_RET_STS_ERROR;
440: RETURN l_dimension_group_id;
441:
442: WHEN TOO_MANY_ROWS THEN
443: FEM_ENGINES_PKG.Tech_Message (
444: p_severity => c_log_level_4
445: ,p_module => c_module_pkg||'.'||l_api_name
446: ,p_msg_text => 'Dimension Group display code returned more than 1 '||
447: 'Dimension Group Id'

Line 450: FEM_ENGINES_PKG.User_Message (

446: ,p_msg_text => 'Dimension Group display code returned more than 1 '||
447: 'Dimension Group Id'
448: );
449:
450: FEM_ENGINES_PKG.User_Message (
451: p_app_name => G_FEM
452: ,p_msg_name => c_imp_more_rows_found_err
453: ,p_token1 => 'API_NAME'
454: ,p_value1 => l_api_name

Line 466: FEM_ENGINES_PKG.Tech_Message (

462: WHEN OTHERS THEN
463:
464: l_prg_msg := SQLERRM;
465:
466: FEM_ENGINES_PKG.Tech_Message (
467: p_severity => c_log_level_6
468: ,p_module => c_module_pkg||'.'||l_api_name
469: ,p_msg_text => l_prg_msg
470: );

Line 513: FEM_ENGINES_PKG.Tech_Message (

509: l_hier_dim_grp_exists VARCHAR2(1) :='F';--Setting it To False
510: --------------------------------
511: BEGIN
512:
513: FEM_ENGINES_PKG.Tech_Message (
514: p_severity => c_log_level_2
515: ,p_module => c_module_pkg||'.'||l_api_name
516: ,p_msg_text => 'Begining Function'
517: );

Line 534: FEM_ENGINES_PKG.Tech_Message (

530: AND B.DIMENSION_GROUP_DISPLAY_CODE = p_dim_group_display_code
531: AND A.OBJECT_ID=C.HIERARCHY_OBJ_ID
532: AND B.DIMENSION_GROUP_ID=C.DIMENSION_GROUP_ID ;
533:
534: FEM_ENGINES_PKG.Tech_Message (
535: p_severity => c_log_level_2
536: ,p_module => c_module_pkg||'.'||l_api_name
537: ,p_msg_text => 'Ending Function'
538: );

Line 547: FEM_ENGINES_PKG.Tech_Message (

543: EXCEPTION
544:
545: WHEN NO_DATA_FOUND THEN
546:
547: FEM_ENGINES_PKG.Tech_Message (
548: p_severity => c_log_level_4
549: ,p_module => c_module_pkg||'.'||l_api_name
550: ,p_msg_text => 'Dimension Group Display Code does not exists for '||
551: 'given dimension varchar label and given hierarchy'

Line 553: FEM_ENGINES_PKG.User_Message (

549: ,p_module => c_module_pkg||'.'||l_api_name
550: ,p_msg_text => 'Dimension Group Display Code does not exists for '||
551: 'given dimension varchar label and given hierarchy'
552: );
553: FEM_ENGINES_PKG.User_Message (
554: p_app_name => G_FEM
555: ,p_msg_name => c_gdc_hier_dim_not_found_err
556: ,p_token1 => 'API_NAME'
557: ,p_value1 => l_api_name

Line 569: FEM_ENGINES_PKG.Tech_Message (

565: RETURN l_hier_dim_grp_exists;
566:
567: WHEN TOO_MANY_ROWS THEN
568:
569: FEM_ENGINES_PKG.Tech_Message (
570: p_severity => c_log_level_4
571: ,p_module => c_module_pkg||'.'||l_api_name
572: ,p_msg_text => 'More than 1 dim group display code exists with '||
573: 'given hierarchy and dimension '

Line 583: FEM_ENGINES_PKG.Tech_Message (

579: WHEN OTHERS THEN
580:
581: l_prg_msg := SQLERRM;
582:
583: FEM_ENGINES_PKG.Tech_Message (
584: p_severity => c_log_level_6
585: ,p_module => c_module_pkg||'.'||l_api_name
586: ,p_msg_text => l_prg_msg
587: );

Line 678: FEM_ENGINES_PKG.Tech_Message (

674: EXCEPTION
675:
676: WHEN NO_DATA_FOUND THEN
677:
678: FEM_ENGINES_PKG.Tech_Message (
679: p_severity => c_log_level_4
680: ,p_module => c_module_pkg||'.'||l_api_name
681: ,p_msg_text => 'Either of Parent or Child dimension group display code is '||
682: 'not associated with given Hierarchy for given dimension'

Line 684: FEM_ENGINES_PKG.User_Message (

680: ,p_module => c_module_pkg||'.'||l_api_name
681: ,p_msg_text => 'Either of Parent or Child dimension group display code is '||
682: 'not associated with given Hierarchy for given dimension'
683: );
684: FEM_ENGINES_PKG.User_Message (
685: p_app_name => G_FEM
686: ,p_msg_name => c_par_child_gdc_not_found_err
687: ,p_token1 => 'API_NAME'
688: ,p_value1 => l_api_name

Line 700: FEM_ENGINES_PKG.Tech_Message (

696: RETURN l_val_hier_dim_grps_order;
697:
698: WHEN TOO_MANY_ROWS THEN
699:
700: FEM_ENGINES_PKG.Tech_Message (
701: p_severity => c_log_level_4
702: ,p_module => c_module_pkg||'.'||l_api_name
703: ,p_msg_text => 'More than 1 row returned for the given main query'
704: );

Line 713: FEM_ENGINES_PKG.Tech_Message (

709: WHEN OTHERS THEN
710:
711: l_prg_msg := SQLERRM;
712:
713: FEM_ENGINES_PKG.Tech_Message (
714: p_severity => c_log_level_6
715: ,p_module => c_module_pkg||'.'||l_api_name
716: ,p_msg_text => l_prg_msg
717: );

Line 748: FEM_ENGINES_PKG.Tech_Message (

744: l_prg_msg VARCHAR2(2000);
745:
746: BEGIN
747:
748: FEM_ENGINES_PKG.Tech_Message (
749: p_severity => c_log_level_2
750: ,p_module => c_module_pkg||'.'||l_api_name
751: ,p_msg_text => 'Begining Function'
752: );

Line 759: FEM_ENGINES_PKG.Tech_Message (

755: INTO l_attribute_varchar_label
756: FROM fem_dim_attributes_b
757: WHERE attribute_id=p_attribute_id;
758:
759: FEM_ENGINES_PKG.Tech_Message (
760: p_severity => c_log_level_2
761: ,p_module => c_module_pkg||'.'||l_api_name
762: ,p_msg_text => 'Ending function'
763: );

Line 771: FEM_ENGINES_PKG.Tech_Message (

767: EXCEPTION
768:
769: WHEN NO_DATA_FOUND THEN
770:
771: FEM_ENGINES_PKG.Tech_Message (
772: p_severity => c_log_level_4
773: ,p_module => c_module_pkg||'.'||l_api_name
774: ,p_msg_text => 'Attribute varchar label does not'||
775: ' Exists for given attribute ID'

Line 778: FEM_ENGINES_PKG.User_Message (

774: ,p_msg_text => 'Attribute varchar label does not'||
775: ' Exists for given attribute ID'
776: );
777:
778: FEM_ENGINES_PKG.User_Message (
779: p_app_name => G_FEM
780: ,p_msg_name => c_exp_could_not_found_err
781: ,p_token1 => 'API_NAME'
782: ,p_value1 => l_api_name

Line 791: FEM_ENGINES_PKG.Tech_Message (

787: RETURN l_attribute_varchar_label;
788:
789: WHEN TOO_MANY_ROWS THEN
790:
791: FEM_ENGINES_PKG.Tech_Message (
792: p_severity => c_log_level_4
793: ,p_module => c_module_pkg||'.'||l_api_name
794: ,p_msg_text => 'Attribute ID returned more than 1 '||
795: 'Attribute varchar label'

Line 798: FEM_ENGINES_PKG.User_Message (

794: ,p_msg_text => 'Attribute ID returned more than 1 '||
795: 'Attribute varchar label'
796: );
797:
798: FEM_ENGINES_PKG.User_Message (
799: p_app_name => G_FEM
800: ,p_msg_name => c_exp_more_rows_found_err
801: ,p_token1 => 'API_NAME'
802: ,p_value1 => l_api_name

Line 813: FEM_ENGINES_PKG.Tech_Message (

809: WHEN OTHERS THEN
810:
811: l_prg_msg := SQLERRM;
812:
813: FEM_ENGINES_PKG.Tech_Message (
814: p_severity => c_log_level_6
815: ,p_module => c_module_pkg||'.'||l_api_name
816: ,p_msg_text => l_prg_msg
817: );

Line 854: FEM_ENGINES_PKG.Tech_Message (

850: l_prg_msg VARCHAR2(2000);
851:
852: BEGIN
853:
854: FEM_ENGINES_PKG.Tech_Message (
855: p_severity => c_log_level_2
856: ,p_module => c_module_pkg||'.'||l_api_name
857: ,p_msg_text => 'Begining Function'
858: );

Line 870: FEM_ENGINES_PKG.Tech_Message (

866: WHERE a.dimension_varchar_label = p_dimension_varchar_label
867: AND B.dimension_id = A.dimension_id
868: AND B.attribute_varchar_label = p_dim_attribute_varchar_label;
869:
870: FEM_ENGINES_PKG.Tech_Message (
871: p_severity => c_log_level_2
872: ,p_module => c_module_pkg||'.'||l_api_name
873: ,p_msg_text => 'End'
874: );

Line 882: FEM_ENGINES_PKG.Tech_Message (

878: EXCEPTION
879:
880: WHEN NO_DATA_FOUND THEN
881:
882: FEM_ENGINES_PKG.Tech_Message (
883: p_severity => c_log_level_4
884: ,p_module => c_module_pkg||'.'||l_api_name
885: ,p_msg_text => 'Attribute ID does not exists for given '||
886: 'attribute varchar label and dimension'

Line 889: FEM_ENGINES_PKG.User_Message (

885: ,p_msg_text => 'Attribute ID does not exists for given '||
886: 'attribute varchar label and dimension'
887: );
888:
889: FEM_ENGINES_PKG.User_Message (
890: p_app_name => G_FEM
891: ,p_msg_name => c_imp_could_not_found_err
892: ,p_token1 => 'API_NAME'
893: ,p_value1 => l_api_name

Line 903: FEM_ENGINES_PKG.Tech_Message (

899: RETURN l_dim_attribute_id;
900:
901: WHEN TOO_MANY_ROWS THEN
902:
903: FEM_ENGINES_PKG.Tech_Message (
904: p_severity => c_log_level_4
905: ,p_module => c_module_pkg||'.'||l_api_name
906: ,p_msg_text => 'Attribute varchar label returned more than 1 '||
907: 'attribute ID for given dimension'

Line 910: FEM_ENGINES_PKG.User_Message (

906: ,p_msg_text => 'Attribute varchar label returned more than 1 '||
907: 'attribute ID for given dimension'
908: );
909:
910: FEM_ENGINES_PKG.User_Message (
911: p_app_name => G_FEM
912: ,p_msg_name => c_imp_more_rows_found_err
913: ,p_token1 => 'API_NAME'
914: ,p_value1 => l_api_name

Line 926: FEM_ENGINES_PKG.Tech_Message (

922: WHEN OTHERS THEN
923:
924: l_prg_msg := SQLERRM;
925:
926: FEM_ENGINES_PKG.Tech_Message (
927: p_severity => c_log_level_6
928: ,p_module => c_module_pkg||'.'||l_api_name
929: ,p_msg_text => l_prg_msg
930: );

Line 967: FEM_ENGINES_PKG.Tech_Message (

963: l_prg_msg VARCHAR2(2000);
964:
965: BEGIN
966:
967: FEM_ENGINES_PKG.Tech_Message (
968: p_severity => c_log_level_2
969: ,p_module => c_module_pkg||'.'||l_api_name
970: ,p_msg_text => 'Begining Function'
971: );

Line 981: FEM_ENGINES_PKG.Tech_Message (

977: FROM fem_dim_attributes_b
978: WHERE dimension_id = p_dimension_id
979: AND attribute_varchar_label = p_dim_attribute_varchar_label;
980:
981: FEM_ENGINES_PKG.Tech_Message (
982: p_severity => c_log_level_2
983: ,p_module => c_module_pkg||'.'||l_api_name
984: ,p_msg_text => 'End'
985: );

Line 993: FEM_ENGINES_PKG.Tech_Message (

989: EXCEPTION
990:
991: WHEN NO_DATA_FOUND THEN
992:
993: FEM_ENGINES_PKG.Tech_Message (
994: p_severity => c_log_level_4
995: ,p_module => c_module_pkg||'.'||l_api_name
996: ,p_msg_text => 'Attribute ID does not Exists for given '||
997: ' attribute varchar label and dimension'

Line 1000: FEM_ENGINES_PKG.User_Message (

996: ,p_msg_text => 'Attribute ID does not Exists for given '||
997: ' attribute varchar label and dimension'
998: );
999:
1000: FEM_ENGINES_PKG.User_Message (
1001: p_app_name => G_FEM
1002: ,p_msg_name => c_imp_could_not_found_err
1003: ,p_token1 => 'API_NAME'
1004: ,p_value1 => l_api_name

Line 1014: FEM_ENGINES_PKG.Tech_Message (

1010: RETURN l_dim_attribute_id;
1011:
1012: WHEN TOO_MANY_ROWS THEN
1013:
1014: FEM_ENGINES_PKG.Tech_Message (
1015: p_severity => c_log_level_4
1016: ,p_module => c_module_pkg||'.'||l_api_name
1017: ,p_msg_text => 'Attribute varchar label returned more than 1 '||
1018: 'attribute id for given dimension'

Line 1021: FEM_ENGINES_PKG.User_Message (

1017: ,p_msg_text => 'Attribute varchar label returned more than 1 '||
1018: 'attribute id for given dimension'
1019: );
1020:
1021: FEM_ENGINES_PKG.User_Message (
1022: p_app_name => G_FEM
1023: ,p_msg_name => c_imp_more_rows_found_err
1024: ,p_token1 => 'API_NAME'
1025: ,p_value1 => l_api_name

Line 1037: FEM_ENGINES_PKG.Tech_Message (

1033: WHEN OTHERS THEN
1034:
1035: l_prg_msg := SQLERRM;
1036:
1037: FEM_ENGINES_PKG.Tech_Message (
1038: p_severity => c_log_level_6
1039: ,p_module => c_module_pkg||'.'||l_api_name
1040: ,p_msg_text => l_prg_msg
1041: );

Line 1073: FEM_ENGINES_PKG.Tech_Message (

1069: l_prg_msg VARCHAR2(2000);
1070:
1071: BEGIN
1072:
1073: FEM_ENGINES_PKG.Tech_Message (
1074: p_severity => c_log_level_2
1075: ,p_module => c_module_pkg||'.'||l_api_name
1076: ,p_msg_text => 'Begining Function'
1077: );

Line 1085: FEM_ENGINES_PKG.Tech_Message (

1081: FROM fem_dim_attr_versions_b
1082: WHERE attribute_id = p_attribute_id
1083: AND version_id = p_version_id;
1084:
1085: FEM_ENGINES_PKG.Tech_Message (
1086: p_severity => c_log_level_2
1087: ,p_module => c_module_pkg||'.'||l_api_name
1088: ,p_msg_text => 'End'
1089: );

Line 1097: FEM_ENGINES_PKG.Tech_Message (

1093: EXCEPTION
1094:
1095: WHEN NO_DATA_FOUND THEN
1096:
1097: FEM_ENGINES_PKG.Tech_Message (
1098: p_severity => c_log_level_4
1099: ,p_module => c_module_pkg||'.'||l_api_name
1100: ,p_msg_text => 'Attribute Version Display Code does not'||
1101: ' Exists for given Attribute ID and Attribute'

Line 1104: FEM_ENGINES_PKG.User_Message (

1100: ,p_msg_text => 'Attribute Version Display Code does not'||
1101: ' Exists for given Attribute ID and Attribute'
1102: );
1103:
1104: FEM_ENGINES_PKG.User_Message (
1105: p_app_name => G_FEM
1106: ,p_msg_name => c_exp_could_not_found_err
1107: ,p_token1 => 'API_NAME'
1108: ,p_value1 => l_api_name

Line 1117: FEM_ENGINES_PKG.Tech_Message (

1113: RETURN l_attr_ver_display_code;
1114:
1115: WHEN TOO_MANY_ROWS THEN
1116:
1117: FEM_ENGINES_PKG.Tech_Message (
1118: p_severity => c_log_level_4
1119: ,p_module => c_module_pkg||'.'||l_api_name
1120: ,p_msg_text => 'Version ID returned more than 1 '||
1121: 'Version display code for given Attribute'

Line 1124: FEM_ENGINES_PKG.User_Message (

1120: ,p_msg_text => 'Version ID returned more than 1 '||
1121: 'Version display code for given Attribute'
1122: );
1123:
1124: FEM_ENGINES_PKG.User_Message (
1125: p_app_name => G_FEM
1126: ,p_msg_name => c_exp_more_rows_found_err
1127: ,p_token1 => 'API_NAME'
1128: ,p_value1 => l_api_name

Line 1139: FEM_ENGINES_PKG.Tech_Message (

1135: WHEN OTHERS THEN
1136:
1137: l_prg_msg := SQLERRM;
1138:
1139: FEM_ENGINES_PKG.Tech_Message (
1140: p_severity => c_log_level_6
1141: ,p_module => c_module_pkg||'.'||l_api_name
1142: ,p_msg_text => l_prg_msg
1143: );

Line 1173: FEM_ENGINES_PKG.Tech_Message (

1169: l_api_name CONSTANT VARCHAR2(30) := 'Get_Dim_Attr_Ver_Display_Code';
1170: l_prg_msg VARCHAR2(2000);
1171: BEGIN
1172:
1173: FEM_ENGINES_PKG.Tech_Message (
1174: p_severity => c_log_level_2
1175: ,p_module => c_module_pkg||'.'||l_api_name
1176: ,p_msg_text => 'Begining Function'
1177: );

Line 1187: FEM_ENGINES_PKG.Tech_Message (

1183: WHERE b.attribute_varchar_label = p_dim_attr_varchar_label
1184: AND a.attribute_id = B.attribute_id
1185: AND a.version_id = p_version_id ;
1186:
1187: FEM_ENGINES_PKG.Tech_Message (
1188: p_severity => c_log_level_2
1189: ,p_module => c_module_pkg||'.'||l_api_name
1190: ,p_msg_text => 'End'
1191: );

Line 1199: FEM_ENGINES_PKG.Tech_Message (

1195: EXCEPTION
1196:
1197: WHEN NO_DATA_FOUND THEN
1198:
1199: FEM_ENGINES_PKG.Tech_Message (
1200: p_severity => c_log_level_4
1201: ,p_module => c_module_pkg||'.'||l_api_name
1202: ,p_msg_text => 'Attribute Version Display Code does not'||
1203: ' Exists for given Version Id and Attribute '

Line 1206: FEM_ENGINES_PKG.User_Message (

1202: ,p_msg_text => 'Attribute Version Display Code does not'||
1203: ' Exists for given Version Id and Attribute '
1204: );
1205:
1206: FEM_ENGINES_PKG.User_Message (
1207: p_app_name => G_FEM
1208: ,p_msg_name => c_exp_could_not_found_err
1209: ,p_token1 => 'API_NAME'
1210: ,p_value1 => l_api_name

Line 1219: FEM_ENGINES_PKG.Tech_Message (

1215: RETURN l_attr_ver_display_code;
1216:
1217: WHEN TOO_MANY_ROWS THEN
1218:
1219: FEM_ENGINES_PKG.Tech_Message (
1220: p_severity => c_log_level_4
1221: ,p_module => c_module_pkg||'.'||l_api_name
1222: ,p_msg_text => 'Attribute Version ID returned more than 1 '||
1223: 'version display code for given attribute'

Line 1226: FEM_ENGINES_PKG.User_Message (

1222: ,p_msg_text => 'Attribute Version ID returned more than 1 '||
1223: 'version display code for given attribute'
1224: );
1225:
1226: FEM_ENGINES_PKG.User_Message (
1227: p_app_name => G_FEM
1228: ,p_msg_name => c_exp_more_rows_found_err
1229: ,p_token1 => 'API_NAME'
1230: ,p_value1 => l_api_name

Line 1241: FEM_ENGINES_PKG.Tech_Message (

1237: WHEN OTHERS THEN
1238:
1239: l_prg_msg := SQLERRM;
1240:
1241: FEM_ENGINES_PKG.Tech_Message (
1242: p_severity => c_log_level_6
1243: ,p_module => c_module_pkg||'.'||l_api_name
1244: ,p_msg_text => l_prg_msg
1245: );

Line 1281: FEM_ENGINES_PKG.Tech_Message (

1277: l_prg_msg VARCHAR2(2000);
1278:
1279: BEGIN
1280:
1281: FEM_ENGINES_PKG.Tech_Message (
1282: p_severity => c_log_level_2
1283: ,p_module => c_module_pkg||'.'||l_api_name
1284: ,p_msg_text => 'Begining Function'
1285: );

Line 1297: FEM_ENGINES_PKG.Tech_Message (

1293: WHERE B.attribute_varchar_label = p_dim_attr_varchar_label
1294: AND A.attribute_id = B.attribute_id
1295: AND A.version_display_code = p_dim_attr_ver_display_code;
1296:
1297: FEM_ENGINES_PKG.Tech_Message (
1298: p_severity => c_log_level_2
1299: ,p_module => c_module_pkg||'.'||l_api_name
1300: ,p_msg_text => 'End'
1301: );

Line 1309: FEM_ENGINES_PKG.Tech_Message (

1305: EXCEPTION
1306:
1307: WHEN NO_DATA_FOUND THEN
1308:
1309: FEM_ENGINES_PKG.Tech_Message (
1310: p_severity => c_log_level_4
1311: ,p_module => c_module_pkg||'.'||l_api_name
1312: ,p_msg_text => 'Attribute Version ID does not Exists '||
1313: 'for given Version Display Code and Attribute'

Line 1316: FEM_ENGINES_PKG.User_Message (

1312: ,p_msg_text => 'Attribute Version ID does not Exists '||
1313: 'for given Version Display Code and Attribute'
1314: );
1315:
1316: FEM_ENGINES_PKG.User_Message (
1317: p_app_name => G_FEM
1318: ,p_msg_name => c_imp_could_not_found_err
1319: ,p_token1 => 'API_NAME'
1320: ,p_value1 => l_api_name

Line 1330: FEM_ENGINES_PKG.Tech_Message (

1326: RETURN l_dim_attr_version_id;
1327:
1328: WHEN TOO_MANY_ROWS THEN
1329:
1330: FEM_ENGINES_PKG.Tech_Message (
1331: p_severity => c_log_level_4
1332: ,p_module => c_module_pkg||'.'||l_api_name
1333: ,p_msg_text => 'Version Display code returned more than 1 '||
1334: 'Version ID for given Attribute '

Line 1337: FEM_ENGINES_PKG.User_Message (

1333: ,p_msg_text => 'Version Display code returned more than 1 '||
1334: 'Version ID for given Attribute '
1335: );
1336:
1337: FEM_ENGINES_PKG.User_Message (
1338: p_app_name => G_FEM
1339: ,p_msg_name => c_imp_more_rows_found_err
1340: ,p_token1 => 'API_NAME'
1341: ,p_value1 => l_api_name

Line 1353: FEM_ENGINES_PKG.Tech_Message (

1349: WHEN OTHERS THEN
1350:
1351: l_prg_msg := SQLERRM;
1352:
1353: FEM_ENGINES_PKG.Tech_Message (
1354: p_severity => c_log_level_6
1355: ,p_module => c_module_pkg||'.'||l_api_name
1356: ,p_msg_text => l_prg_msg
1357: );

Line 1394: FEM_ENGINES_PKG.Tech_Message (

1390: l_prg_msg VARCHAR2(2000);
1391:
1392: BEGIN
1393:
1394: FEM_ENGINES_PKG.Tech_Message (
1395: p_severity => c_log_level_2
1396: ,p_module => c_module_pkg||'.'||l_api_name
1397: ,p_msg_text => 'Begining Function'
1398: );

Line 1408: FEM_ENGINES_PKG.Tech_Message (

1404: FROM fem_dim_attr_versions_b
1405: WHERE attribute_id = p_dim_attribute_id
1406: AND version_display_code = p_dim_attr_ver_display_code;
1407:
1408: FEM_ENGINES_PKG.Tech_Message (
1409: p_severity => c_log_level_2
1410: ,p_module => c_module_pkg||'.'||l_api_name
1411: ,p_msg_text => 'End'
1412: );

Line 1420: FEM_ENGINES_PKG.Tech_Message (

1416: EXCEPTION
1417:
1418: WHEN NO_DATA_FOUND THEN
1419:
1420: FEM_ENGINES_PKG.Tech_Message (
1421: p_severity => c_log_level_4
1422: ,p_module => c_module_pkg||'.'||l_api_name
1423: ,p_msg_text => 'Attribute Version ID does not Exists for '||
1424: 'given Attribute Version Display Code and Attribute ID'

Line 1427: FEM_ENGINES_PKG.User_Message (

1423: ,p_msg_text => 'Attribute Version ID does not Exists for '||
1424: 'given Attribute Version Display Code and Attribute ID'
1425: );
1426:
1427: FEM_ENGINES_PKG.User_Message (
1428: p_app_name => G_FEM
1429: ,p_msg_name => c_imp_could_not_found_err
1430: ,p_token1 => 'API_NAME'
1431: ,p_value1 => l_api_name

Line 1441: FEM_ENGINES_PKG.Tech_Message (

1437: RETURN l_dim_attr_version_id;
1438:
1439: WHEN TOO_MANY_ROWS THEN
1440:
1441: FEM_ENGINES_PKG.Tech_Message (
1442: p_severity => c_log_level_4
1443: ,p_module => c_module_pkg||'.'||l_api_name
1444: ,p_msg_text => 'Attribute Version Display Code returned more than 1 '||
1445: 'Version ID for given Attribute ID'

Line 1448: FEM_ENGINES_PKG.User_Message (

1444: ,p_msg_text => 'Attribute Version Display Code returned more than 1 '||
1445: 'Version ID for given Attribute ID'
1446: );
1447:
1448: FEM_ENGINES_PKG.User_Message (
1449: p_app_name => G_FEM
1450: ,p_msg_name => c_imp_more_rows_found_err
1451: ,p_token1 => 'API_NAME'
1452: ,p_value1 => l_api_name

Line 1464: FEM_ENGINES_PKG.Tech_Message (

1460: WHEN OTHERS THEN
1461:
1462: l_prg_msg := SQLERRM;
1463:
1464: FEM_ENGINES_PKG.Tech_Message (
1465: p_severity => c_log_level_6
1466: ,p_module => c_module_pkg||'.'||l_api_name
1467: ,p_msg_text => l_prg_msg
1468: );

Line 1498: FEM_ENGINES_PKG.Tech_Message (

1494: l_api_name CONSTANT VARCHAR2(30) := 'Get_Dim_Member_Display_Code';
1495: l_prg_msg VARCHAR2(2000);
1496: BEGIN
1497:
1498: FEM_ENGINES_PKG.Tech_Message (
1499: p_severity => c_log_level_2
1500: ,p_module => c_module_pkg||'.'||l_api_name
1501: ,p_msg_text => 'Begining Function'
1502: );

Line 1516: FEM_ENGINES_PKG.Tech_Message (

1512: INTO l_member_display_code
1513: FROM fem_xdim_dimensions_vl XDIM
1514: WHERE XDIM.dimension_id = p_dimension_id;
1515:
1516: FEM_ENGINES_PKG.Tech_Message (
1517: p_severity => c_log_level_2
1518: ,p_module => c_module_pkg||'.'||l_api_name
1519: ,p_msg_text => 'Ending Function'
1520: );

Line 1528: FEM_ENGINES_PKG.Tech_Message (

1524: EXCEPTION
1525:
1526: WHEN NO_DATA_FOUND THEN
1527:
1528: FEM_ENGINES_PKG.Tech_Message (
1529: p_severity => c_log_level_4
1530: ,p_module => c_module_pkg||'.'||l_api_name
1531: ,p_msg_text => 'Dimension Member Display Code does not Exists'||
1532: 'for given Dimension member ID and Dimension'

Line 1535: FEM_ENGINES_PKG.User_Message (

1531: ,p_msg_text => 'Dimension Member Display Code does not Exists'||
1532: 'for given Dimension member ID and Dimension'
1533: );
1534:
1535: FEM_ENGINES_PKG.User_Message (
1536: p_app_name => G_FEM
1537: ,p_msg_name => c_exp_could_not_found_err
1538: ,p_token1 => 'API_NAME'
1539: ,p_value1 => l_api_name

Line 1548: FEM_ENGINES_PKG.Tech_Message (

1544: RETURN l_member_display_code;
1545:
1546: WHEN TOO_MANY_ROWS THEN
1547:
1548: FEM_ENGINES_PKG.Tech_Message (
1549: p_severity => c_log_level_4
1550: ,p_module => c_module_pkg||'.'||l_api_name
1551: ,p_msg_text => 'Dimension Member ID returned more than 1 '||
1552: 'Dimension Member display code'

Line 1555: FEM_ENGINES_PKG.User_Message (

1551: ,p_msg_text => 'Dimension Member ID returned more than 1 '||
1552: 'Dimension Member display code'
1553: );
1554:
1555: FEM_ENGINES_PKG.User_Message (
1556: p_app_name => G_FEM
1557: ,p_msg_name => c_exp_more_rows_found_err
1558: ,p_token1 => 'API_NAME'
1559: ,p_value1 => l_api_name

Line 1570: FEM_ENGINES_PKG.Tech_Message (

1566: WHEN OTHERS THEN
1567:
1568: l_prg_msg := SQLERRM;
1569:
1570: FEM_ENGINES_PKG.Tech_Message (
1571: p_severity => c_log_level_6
1572: ,p_module => c_module_pkg||'.'||l_api_name
1573: ,p_msg_text => l_prg_msg
1574: );

Line 1603: FEM_ENGINES_PKG.Tech_Message (

1599: l_api_name CONSTANT VARCHAR2(30) := 'Get_Dim_Member_Display_Code';
1600: l_prg_msg VARCHAR2(2000);
1601: BEGIN
1602:
1603: FEM_ENGINES_PKG.Tech_Message (
1604: p_severity => c_log_level_2
1605: ,p_module => c_module_pkg||'.'||l_api_name
1606: ,p_msg_text => 'Begining Function'
1607: );

Line 1621: FEM_ENGINES_PKG.Tech_Message (

1617: INTO l_member_display_code
1618: FROM fem_xdim_dimensions_vl XDIM
1619: WHERE XDIM.dimension_varchar_label = p_dimension_varchar_label;
1620:
1621: FEM_ENGINES_PKG.Tech_Message (
1622: p_severity => c_log_level_2
1623: ,p_module => c_module_pkg||'.'||l_api_name
1624: ,p_msg_text => 'Ending Function'
1625: );

Line 1633: FEM_ENGINES_PKG.Tech_Message (

1629: EXCEPTION
1630:
1631: WHEN NO_DATA_FOUND THEN
1632:
1633: FEM_ENGINES_PKG.Tech_Message (
1634: p_severity => c_log_level_4
1635: ,p_module => c_module_pkg||'.'||l_api_name
1636: ,p_msg_text => 'Dimension Member Display Code does not'||
1637: ' Exists for given Dimension member ID and Dimension'

Line 1640: FEM_ENGINES_PKG.User_Message (

1636: ,p_msg_text => 'Dimension Member Display Code does not'||
1637: ' Exists for given Dimension member ID and Dimension'
1638: );
1639:
1640: FEM_ENGINES_PKG.User_Message (
1641: p_app_name => G_FEM
1642: ,p_msg_name => c_exp_could_not_found_err
1643: ,p_token1 => 'API_NAME'
1644: ,p_value1 => l_api_name

Line 1653: FEM_ENGINES_PKG.Tech_Message (

1649: RETURN l_member_display_code;
1650:
1651: WHEN TOO_MANY_ROWS THEN
1652:
1653: FEM_ENGINES_PKG.Tech_Message (
1654: p_severity => c_log_level_4
1655: ,p_module => c_module_pkg||'.'||l_api_name
1656: ,p_msg_text => 'Dimension Member ID returned more than 1 '||
1657: 'Dimension Member display code'

Line 1660: FEM_ENGINES_PKG.User_Message (

1656: ,p_msg_text => 'Dimension Member ID returned more than 1 '||
1657: 'Dimension Member display code'
1658: );
1659:
1660: FEM_ENGINES_PKG.User_Message (
1661: p_app_name => G_FEM
1662: ,p_msg_name => c_exp_more_rows_found_err
1663: ,p_token1 => 'API_NAME'
1664: ,p_value1 => l_api_name

Line 1675: FEM_ENGINES_PKG.Tech_Message (

1671: WHEN OTHERS THEN
1672:
1673: l_prg_msg := SQLERRM;
1674:
1675: FEM_ENGINES_PKG.Tech_Message (
1676: p_severity => c_log_level_6
1677: ,p_module => c_module_pkg||'.'||l_api_name
1678: ,p_msg_text => l_prg_msg
1679: );

Line 1727: FEM_ENGINES_PKG.Tech_Message (

1723: l_value_set_display_code := NULL;
1724:
1725: x_return_status := FND_API.G_RET_STS_SUCCESS;
1726:
1727: FEM_ENGINES_PKG.Tech_Message (
1728: p_severity => c_log_level_2
1729: ,p_module => c_module_pkg||'.'||l_api_name
1730: ,p_msg_text => 'Begining Function'
1731: );

Line 1742: FEM_ENGINES_PKG.Tech_Message (

1738: INTO l_value_set_id
1739: FROM fem_xdim_dimensions_vl XDIM
1740: WHERE XDIM.dimension_varchar_label = p_dimension_varchar_label;
1741:
1742: FEM_ENGINES_PKG.Tech_Message (
1743: p_severity => c_log_level_1
1744: ,p_module => c_module_pkg||'.'||l_api_name
1745: ,p_msg_text => 'The Value Set ID is '||l_value_set_id
1746: );

Line 1757: FEM_ENGINES_PKG.Tech_Message (

1753: INTO l_value_set_display_code
1754: FROM fem_value_sets_b
1755: WHERE value_set_id = l_value_set_id;
1756:
1757: FEM_ENGINES_PKG.Tech_Message (
1758: p_severity => c_log_level_1
1759: ,p_module => c_module_pkg||'.'||l_api_name
1760: ,p_msg_text => ' The Value Set Display Code for '||l_value_set_id||
1761: ' is '||l_value_set_display_code

Line 1783: FEM_ENGINES_PKG.Tech_Message (

1779: );
1780:
1781: x_return_status:=l_return_status;
1782:
1783: FEM_ENGINES_PKG.Tech_Message (
1784: p_severity => c_log_level_2
1785: ,p_module => c_module_pkg||'.'||l_api_name
1786: ,p_msg_text => 'Ending Function'
1787: );

Line 1795: FEM_ENGINES_PKG.Tech_Message (

1791: EXCEPTION
1792:
1793: WHEN NO_DATA_FOUND THEN
1794:
1795: FEM_ENGINES_PKG.Tech_Message (
1796: p_severity => c_log_level_4
1797: ,p_module => c_module_pkg||'.'||l_api_name
1798: ,p_msg_text => 'Either of the Value Set ID or '||
1799: 'Value Set Code is null '

Line 1802: FEM_ENGINES_PKG.User_Message (

1798: ,p_msg_text => 'Either of the Value Set ID or '||
1799: 'Value Set Code is null '
1800: );
1801:
1802: FEM_ENGINES_PKG.User_Message (
1803: p_app_name => G_FEM
1804: ,p_msg_name => c_vsid_or_vscode_null
1805: ,p_token1 => 'API_NAME'
1806: ,p_value1 => l_api_name

Line 1814: FEM_ENGINES_PKG.Tech_Message (

1810: RETURN l_member_id;
1811:
1812: WHEN TOO_MANY_ROWS THEN
1813:
1814: FEM_ENGINES_PKG.Tech_Message (
1815: p_severity => c_log_level_4
1816: ,p_module => c_module_pkg||'.'||l_api_name
1817: ,p_msg_text => 'Value Set ID returned more than 1 '||
1818: 'Value Set display code or Vice Versa'

Line 1828: FEM_ENGINES_PKG.Tech_Message (

1824: WHEN OTHERS THEN
1825:
1826: l_prg_msg := SQLERRM;
1827:
1828: FEM_ENGINES_PKG.Tech_Message (
1829: p_severity => c_log_level_6
1830: ,p_module => c_module_pkg||'.'||l_api_name
1831: ,p_msg_text => l_prg_msg
1832: );

Line 1887: FEM_ENGINES_PKG.Tech_Message (

1883: l_value_set_display_code := NULL;
1884:
1885: x_return_status := FND_API.G_RET_STS_SUCCESS;
1886:
1887: FEM_ENGINES_PKG.Tech_Message (
1888: p_severity => c_log_level_2
1889: ,p_module => c_module_pkg||'.'||l_api_name
1890: ,p_msg_text => 'Begining Function'
1891: );

Line 1928: FEM_ENGINES_PKG.Tech_Message (

1924: RAISE e_bad_vs_dim_id;
1925:
1926: END;
1927:
1928: FEM_ENGINES_PKG.Tech_Message (
1929: p_severity => c_log_level_1
1930: ,p_module => c_module_pkg||'.'||l_api_name
1931: ,p_msg_text => 'The Value Set ID is '||l_value_set_id
1932: );

Line 1953: FEM_ENGINES_PKG.Tech_Message (

1949: WHEN TOO_MANY_ROWS THEN
1950: RAISE e_too_many_vs_codes;
1951:
1952: END;
1953: FEM_ENGINES_PKG.Tech_Message (
1954: p_severity => c_log_level_1
1955: ,p_module => c_module_pkg||'.'||l_api_name
1956: ,p_msg_text => 'The Value Set Code for '||l_value_set_id||
1957: ' is ' || l_value_set_display_code

Line 1980: FEM_ENGINES_PKG.Tech_Message (

1976: );
1977:
1978: x_return_status := l_return_status;
1979:
1980: FEM_ENGINES_PKG.Tech_Message (
1981: p_severity => c_log_level_2
1982: ,p_module => c_module_pkg||'.'||l_api_name
1983: ,p_msg_text => 'Ending Function'
1984: );

Line 1992: FEM_ENGINES_PKG.Tech_Message (

1988: EXCEPTION
1989:
1990: WHEN e_bad_dim_id THEN
1991:
1992: FEM_ENGINES_PKG.Tech_Message (
1993: p_severity => c_log_level_4
1994: ,p_module => c_module_pkg||'.'||l_api_name
1995: ,p_msg_text => 'Dimension Varchar Label Does NOT Exists '||
1996: 'for given Dimension ID '

Line 1999: FEM_ENGINES_PKG.User_Message (

1995: ,p_msg_text => 'Dimension Varchar Label Does NOT Exists '||
1996: 'for given Dimension ID '
1997: );
1998:
1999: FEM_ENGINES_PKG.User_Message (
2000: p_app_name => G_FEM
2001: ,p_msg_name => c_exp_could_not_found_err
2002: ,p_token1 => 'API_NAME'
2003: ,p_value1 => l_api_name

Line 2013: FEM_ENGINES_PKG.Tech_Message (

2009: RETURN l_member_id;
2010:
2011: WHEN e_bad_vs_id THEN
2012:
2013: FEM_ENGINES_PKG.Tech_Message (
2014: p_severity => c_log_level_4
2015: ,p_module => c_module_pkg||'.'||l_api_name
2016: ,p_msg_text => 'Value Set Code Does NOT Exists '||
2017: 'for given Value Set ID '

Line 2019: FEM_ENGINES_PKG.User_Message (

2015: ,p_module => c_module_pkg||'.'||l_api_name
2016: ,p_msg_text => 'Value Set Code Does NOT Exists '||
2017: 'for given Value Set ID '
2018: );
2019: FEM_ENGINES_PKG.User_Message (
2020: p_app_name => G_FEM
2021: ,p_msg_name => c_exp_could_not_found_err
2022: ,p_token1 => 'API_NAME'
2023: ,p_value1 => l_api_name

Line 2033: FEM_ENGINES_PKG.Tech_Message (

2029: RETURN l_member_id;
2030:
2031: WHEN e_bad_vs_dim_id THEN
2032:
2033: FEM_ENGINES_PKG.Tech_Message (
2034: p_severity => c_log_level_4
2035: ,p_module => c_module_pkg||'.'||l_api_name
2036: ,p_msg_text => 'Value Set ID does NOT exists for '||
2037: 'given Dimension ID '

Line 2040: FEM_ENGINES_PKG.User_Message (

2036: ,p_msg_text => 'Value Set ID does NOT exists for '||
2037: 'given Dimension ID '
2038: );
2039:
2040: FEM_ENGINES_PKG.User_Message (
2041: p_app_name => G_FEM
2042: ,p_msg_name => c_vsid_dim_not_found_err
2043: ,p_token1 => 'API_NAME'
2044: ,p_value1 => l_api_name

Line 2054: FEM_ENGINES_PKG.Tech_Message (

2050: RETURN l_member_id;
2051:
2052: WHEN e_too_many_vs_codes THEN
2053:
2054: FEM_ENGINES_PKG.Tech_Message (
2055: p_severity => c_log_level_4
2056: ,p_module => c_module_pkg||'.'||l_api_name
2057: ,p_msg_text => 'Value Set ID returned more than 1 '||
2058: 'Value Set display code '

Line 2068: FEM_ENGINES_PKG.Tech_Message (

2064: WHEN OTHERS THEN
2065:
2066: l_prg_msg := SQLERRM;
2067:
2068: FEM_ENGINES_PKG.Tech_Message (
2069: p_severity => c_log_level_6
2070: ,p_module => c_module_pkg||'.'||l_api_name
2071: ,p_msg_text => l_prg_msg
2072: );

Line 2103: FEM_ENGINES_PKG.Tech_Message (

2099: l_prg_msg VARCHAR2(2000);
2100:
2101: BEGIN
2102:
2103: FEM_ENGINES_PKG.Tech_Message (
2104: p_severity => c_log_level_2
2105: ,p_module => c_module_pkg||'.'||l_api_name
2106: ,p_msg_text => 'Begining Function'
2107: );

Line 2114: FEM_ENGINES_PKG.Tech_Message (

2110: INTO l_value_set_display_code
2111: FROM fem_value_sets_b
2112: WHERE value_set_id= p_value_set_id;
2113:
2114: FEM_ENGINES_PKG.Tech_Message (
2115: p_severity => c_log_level_2
2116: ,p_module => c_module_pkg||'.'||l_api_name
2117: ,p_msg_text => 'Ending Function'
2118: );

Line 2125: FEM_ENGINES_PKG.Tech_Message (

2121: EXCEPTION
2122:
2123: WHEN NO_DATA_FOUND THEN
2124:
2125: FEM_ENGINES_PKG.Tech_Message (
2126: p_severity => c_log_level_4
2127: ,p_module => c_module_pkg||'.'||l_api_name
2128: ,p_msg_text => 'Value Set Display Code does not'||
2129: ' Exists for given Value Set ID'

Line 2132: FEM_ENGINES_PKG.User_Message (

2128: ,p_msg_text => 'Value Set Display Code does not'||
2129: ' Exists for given Value Set ID'
2130: );
2131:
2132: FEM_ENGINES_PKG.User_Message (
2133: p_app_name => G_FEM
2134: ,p_msg_name => c_exp_could_not_found_err
2135: ,p_token1 => 'API_NAME'
2136: ,p_value1 => l_api_name

Line 2145: FEM_ENGINES_PKG.Tech_Message (

2141: RETURN l_value_set_display_code;
2142:
2143: WHEN TOO_MANY_ROWS THEN
2144:
2145: FEM_ENGINES_PKG.Tech_Message (
2146: p_severity => c_log_level_4
2147: ,p_module => c_module_pkg||'.'||l_api_name
2148: ,p_msg_text => 'Value Set ID returned more than 1 '||
2149: 'Value Set display code'

Line 2152: FEM_ENGINES_PKG.User_Message (

2148: ,p_msg_text => 'Value Set ID returned more than 1 '||
2149: 'Value Set display code'
2150: );
2151:
2152: FEM_ENGINES_PKG.User_Message (
2153: p_app_name => G_FEM
2154: ,p_msg_name => c_exp_more_rows_found_err
2155: ,p_token1 => 'API_NAME'
2156: ,p_value1 => l_api_name

Line 2167: FEM_ENGINES_PKG.Tech_Message (

2163: WHEN OTHERS THEN
2164:
2165: l_prg_msg := SQLERRM;
2166:
2167: FEM_ENGINES_PKG.Tech_Message (
2168: p_severity => c_log_level_6
2169: ,p_module => c_module_pkg||'.'||l_api_name
2170: ,p_msg_text => l_prg_msg
2171: );

Line 2207: FEM_ENGINES_PKG.Tech_Message (

2203: BEGIN
2204:
2205: x_return_status := FND_API.G_RET_STS_SUCCESS;
2206:
2207: FEM_ENGINES_PKG.Tech_Message (
2208: p_severity => c_log_level_2
2209: ,p_module => c_module_pkg||'.'||l_api_name
2210: ,p_msg_text => 'Begining Function'
2211: );

Line 2219: FEM_ENGINES_PKG.Tech_Message (

2215: INTO l_value_set_id
2216: FROM fem_value_sets_b
2217: WHERE value_set_display_code= p_value_set_display_code;
2218:
2219: FEM_ENGINES_PKG.Tech_Message (
2220: p_severity => c_log_level_2
2221: ,p_module => c_module_pkg||'.'||l_api_name
2222: ,p_msg_text => 'Ending Function'
2223: );

Line 2230: FEM_ENGINES_PKG.Tech_Message (

2226:
2227: EXCEPTION
2228:
2229: WHEN NO_DATA_FOUND THEN
2230: FEM_ENGINES_PKG.Tech_Message (
2231: p_severity => c_log_level_4
2232: ,p_module => c_module_pkg||'.'||l_api_name
2233: ,p_msg_text => 'Value Set Display Code does not'||
2234: ' Exists for given Value Set ID'

Line 2237: FEM_ENGINES_PKG.User_Message (

2233: ,p_msg_text => 'Value Set Display Code does not'||
2234: ' Exists for given Value Set ID'
2235: );
2236:
2237: FEM_ENGINES_PKG.User_Message (
2238: p_app_name => G_FEM
2239: ,p_msg_name => c_imp_could_not_found_err
2240: ,p_token1 => 'API_NAME'
2241: ,p_value1 => l_api_name

Line 2251: FEM_ENGINES_PKG.Tech_Message (

2247:
2248: RETURN l_value_set_id;
2249:
2250: WHEN TOO_MANY_ROWS THEN
2251: FEM_ENGINES_PKG.Tech_Message (
2252: p_severity => c_log_level_4
2253: ,p_module => c_module_pkg||'.'||l_api_name
2254: ,p_msg_text => 'Value Set Code returned more than 1 '||
2255: 'Value Set ID'

Line 2258: FEM_ENGINES_PKG.User_Message (

2254: ,p_msg_text => 'Value Set Code returned more than 1 '||
2255: 'Value Set ID'
2256: );
2257:
2258: FEM_ENGINES_PKG.User_Message (
2259: p_app_name => G_FEM
2260: ,p_msg_name => c_imp_more_rows_found_err
2261: ,p_token1 => 'API_NAME'
2262: ,p_value1 => l_api_name

Line 2275: FEM_ENGINES_PKG.Tech_Message (

2271: WHEN OTHERS THEN
2272:
2273: l_prg_msg := SQLERRM;
2274:
2275: FEM_ENGINES_PKG.Tech_Message (
2276: p_severity => c_log_level_6
2277: ,p_module => c_module_pkg||'.'||l_api_name
2278: ,p_msg_text => l_prg_msg
2279: );

Line 2310: FEM_ENGINES_PKG.Tech_Message (

2306: l_api_name CONSTANT VARCHAR2(30):= 'Get_Gl_Period_Num';
2307: l_prg_msg VARCHAR2(2000);
2308: BEGIN
2309:
2310: FEM_ENGINES_PKG.Tech_Message (
2311: p_severity => c_log_level_2
2312: ,p_module => c_module_pkg||'.'||l_api_name
2313: ,p_msg_text => 'Begining Function'
2314: );

Line 2331: FEM_ENGINES_PKG.Tech_Message (

2327: AND CALP_ATTR.cal_period_id = p_cal_period_id
2328: AND CALP_ATTR.attribute_id = ATTR.attribute_id
2329: AND CALP_ATTR.version_id = VER.version_id;
2330:
2331: FEM_ENGINES_PKG.Tech_Message (
2332: p_severity => c_log_level_2
2333: ,p_module => c_module_pkg||'.'||l_api_name
2334: ,p_msg_text => 'Ending Function'
2335: );

Line 2342: FEM_ENGINES_PKG.Tech_Message (

2338: EXCEPTION
2339:
2340: WHEN NO_DATA_FOUND THEN
2341:
2342: FEM_ENGINES_PKG.Tech_Message (
2343: p_severity => c_log_level_4
2344: ,p_module => c_module_pkg||'.'||l_api_name
2345: ,p_msg_text => 'GL Peroid number does not Exists for '||
2346: 'cal period ID'

Line 2349: FEM_ENGINES_PKG.User_Message (

2345: ,p_msg_text => 'GL Peroid number does not Exists for '||
2346: 'cal period ID'
2347: );
2348:
2349: FEM_ENGINES_PKG.User_Message (
2350: p_app_name => G_FEM
2351: ,p_msg_name => c_gl_period_num_not_found_err
2352: ,p_token1 => 'API_NAME'
2353: ,p_value1 => l_api_name

Line 2362: FEM_ENGINES_PKG.Tech_Message (

2358: RETURN l_gl_period_num;
2359:
2360: WHEN TOO_MANY_ROWS THEN
2361:
2362: FEM_ENGINES_PKG.Tech_Message (
2363: p_severity => c_log_level_4
2364: ,p_module => c_module_pkg||'.'||l_api_name
2365: ,p_msg_text => 'More than 1 records exists for given '||
2366: 'dimension and cal period ID'

Line 2374: FEM_ENGINES_PKG.Tech_Message (

2370: WHEN OTHERS THEN
2371:
2372: l_prg_msg := SQLERRM;
2373:
2374: FEM_ENGINES_PKG.Tech_Message (
2375: p_severity => c_log_level_6
2376: ,p_module => c_module_pkg||'.'||l_api_name
2377: ,p_msg_text => l_prg_msg
2378: );

Line 2406: FEM_ENGINES_PKG.Tech_Message (

2402: l_api_name CONSTANT VARCHAR2(30):= 'Get_Cal_Period_End_Date';
2403: l_prg_msg VARCHAR2(2000);
2404: BEGIN
2405:
2406: FEM_ENGINES_PKG.Tech_Message (
2407: p_severity => c_log_level_2
2408: ,p_module => c_module_pkg||'.'||l_api_name
2409: ,p_msg_text => 'Begining Function'
2410: );

Line 2427: FEM_ENGINES_PKG.Tech_Message (

2423: AND CALP_ATTR.cal_period_id = p_cal_period_id
2424: AND CALP_ATTR.attribute_id = ATTR.attribute_id
2425: AND CALP_ATTR.version_id = VER.version_id;
2426:
2427: FEM_ENGINES_PKG.Tech_Message (
2428: p_severity => c_log_level_2
2429: ,p_module => c_module_pkg||'.'||l_api_name
2430: ,p_msg_text => 'Ending Function'
2431: );

Line 2438: FEM_ENGINES_PKG.Tech_Message (

2434: EXCEPTION
2435:
2436: WHEN NO_DATA_FOUND THEN
2437:
2438: FEM_ENGINES_PKG.Tech_Message (
2439: p_severity => c_log_level_4
2440: ,p_module => c_module_pkg||'.'||l_api_name
2441: ,p_msg_text => 'Cal Peroid End Date does not Exists for '||
2442: 'given cal period ID'

Line 2445: FEM_ENGINES_PKG.User_Message (

2441: ,p_msg_text => 'Cal Peroid End Date does not Exists for '||
2442: 'given cal period ID'
2443: );
2444:
2445: FEM_ENGINES_PKG.User_Message (
2446: p_app_name => G_FEM
2447: ,p_msg_name => c_calp_end_date_not_found_err
2448: ,p_token1 => 'API_NAME'
2449: ,p_value1 => l_api_name

Line 2458: FEM_ENGINES_PKG.Tech_Message (

2454: RETURN l_cal_period_end_date;
2455:
2456: WHEN TOO_MANY_ROWS THEN
2457:
2458: FEM_ENGINES_PKG.Tech_Message (
2459: p_severity => c_log_level_4
2460: ,p_module => c_module_pkg||'.'||l_api_name
2461: ,p_msg_text => 'More than 1 records exists for given '||
2462: 'dimension and cal period ID'

Line 2470: FEM_ENGINES_PKG.Tech_Message (

2466: WHEN OTHERS THEN
2467:
2468: l_prg_msg := SQLERRM;
2469:
2470: FEM_ENGINES_PKG.Tech_Message (
2471: p_severity => c_log_level_6
2472: ,p_module => c_module_pkg||'.'||l_api_name
2473: ,p_msg_text => l_prg_msg
2474: );

Line 2511: FEM_ENGINES_PKG.Tech_Message (

2507: BEGIN
2508:
2509: x_return_status := FND_API.G_RET_STS_SUCCESS;
2510:
2511: FEM_ENGINES_PKG.Tech_Message (
2512: p_severity => c_log_level_2
2513: ,p_module => c_module_pkg||'.'||l_api_name
2514: ,p_msg_text => 'Begining Function'
2515: );

Line 2523: FEM_ENGINES_PKG.Tech_Message (

2519: INTO l_object_id
2520: FROM fem_object_definition_vl
2521: WHERE object_definition_id = p_object_def_id;
2522:
2523: FEM_ENGINES_PKG.Tech_Message (
2524: p_severity => c_log_level_2
2525: ,p_module => c_module_pkg||'.'||l_api_name
2526: ,p_msg_text => 'Ending Function'
2527: );

Line 2534: FEM_ENGINES_PKG.Tech_Message (

2530:
2531: EXCEPTION
2532:
2533: WHEN NO_DATA_FOUND THEN
2534: FEM_ENGINES_PKG.Tech_Message (
2535: p_severity => c_log_level_4
2536: ,p_module => c_module_pkg||'.'||l_api_name
2537: ,p_msg_text => 'Object ID does not'||
2538: ' Exists for given Object Def ID'

Line 2540: FEM_ENGINES_PKG.User_Message (

2536: ,p_module => c_module_pkg||'.'||l_api_name
2537: ,p_msg_text => 'Object ID does not'||
2538: ' Exists for given Object Def ID'
2539: );
2540: FEM_ENGINES_PKG.User_Message (
2541: p_app_name => G_FEM
2542: ,p_msg_name => c_obj_def_id_not_found_err
2543: ,p_token1 => 'API_NAME'
2544: ,p_value1 => l_api_name

Line 2553: FEM_ENGINES_PKG.Tech_Message (

2549:
2550: RETURN l_object_id;
2551:
2552: WHEN TOO_MANY_ROWS THEN
2553: FEM_ENGINES_PKG.Tech_Message (
2554: p_severity => c_log_level_4
2555: ,p_module => c_module_pkg||'.'||l_api_name
2556: ,p_msg_text => 'Object Def ID returned more than 1 '||
2557: 'Objects ID'

Line 2568: FEM_ENGINES_PKG.Tech_Message (

2564: WHEN OTHERS THEN
2565:
2566: l_prg_msg := SQLERRM;
2567:
2568: FEM_ENGINES_PKG.Tech_Message (
2569: p_severity => c_log_level_6
2570: ,p_module => c_module_pkg||'.'||l_api_name
2571: ,p_msg_text => l_prg_msg
2572: );

Line 2610: FEM_ENGINES_PKG.Tech_Message (

2606: l_prg_msg VARCHAR2(2000);
2607:
2608: BEGIN
2609:
2610: FEM_ENGINES_PKG.Tech_Message (
2611: p_severity => c_log_level_2
2612: ,p_module => c_module_pkg||'.'||l_api_name
2613: ,p_msg_text => 'Begining Function'
2614: );

Line 2622: FEM_ENGINES_PKG.Tech_Message (

2618: INTO l_dimension_id
2619: FROM fem_dimensions_vl
2620: WHERE dimension_varchar_label = p_dimension_varchar_label;
2621:
2622: FEM_ENGINES_PKG.Tech_Message (
2623: p_severity => c_log_level_2
2624: ,p_module => c_module_pkg||'.'||l_api_name
2625: ,p_msg_text => 'Ending Function'
2626: );

Line 2638: FEM_ENGINES_PKG.Tech_Message (

2634: WHEN OTHERS THEN
2635:
2636: l_prg_msg := SQLERRM;
2637:
2638: FEM_ENGINES_PKG.Tech_Message (
2639: p_severity => c_log_level_6
2640: ,p_module => c_module_pkg||'.'||l_api_name
2641: ,p_msg_text => l_prg_msg
2642: );