eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FEM_COL_TMPLT_DEFN_API_PUB dependencies on FEM_ENGINES_PKG

Line 21: fem_engines_pkg.tech_message (p_severity => g_log_level_1

17: l_tab_name VARCHAR2(30);
18:
19: BEGIN
20:
21: fem_engines_pkg.tech_message (p_severity => g_log_level_1
22: ,p_module => g_block||'.get_alias(FUNCTION)'
23: ,p_msg_text => 'BEGIN..for table ' || p_tab_name);
24:
25: l_alias := p_alias || SUBSTR(p_tab_name,1,1);

Line 32: fem_engines_pkg.tech_message (p_severity => g_log_level_1

28: l_tab_name := SUBSTR(p_tab_name,INSTR(p_tab_name,'_')+1,LENGTH(p_tab_name));
29: l_alias := get_alias(l_tab_name,l_alias);
30: END IF;
31:
32: fem_engines_pkg.tech_message (p_severity => g_log_level_1
33: ,p_module => g_block||'.get_alias(FUNCTION)'
34: ,p_msg_text => 'END..alias ' || p_alias);
35:
36: RETURN l_alias;

Line 62: fem_engines_pkg.tech_message (p_severity => g_log_level_2

58: l_where NUMBER;
59:
60: BEGIN
61:
62: fem_engines_pkg.tech_message (p_severity => g_log_level_2
63: ,p_module => g_block||'.get_alias(PROCEDURE)'
64: ,p_msg_text => 'BEGIN..for table ' || p_tab_name);
65:
66: i := 0;

Line 88: fem_engines_pkg.tech_message (p_severity => g_log_level_2

84: p_attr_detail_rec(l_where).attribute_tab_count := l_count;
85:
86: p_alias := get_alias(p_attr_detail_rec(l_where).attribute_tab_name,'') || TO_CHAR(l_count);
87:
88: fem_engines_pkg.tech_message (p_severity => g_log_level_2
89: ,p_module => g_block||'.get_alias(PROCEDURE)'
90: ,p_msg_text => 'END..alias ' || p_alias);
91:
92: END get_alias;

Line 118: fem_engines_pkg.tech_message (p_severity => g_log_level_2

114: l_ret_type VARCHAR2(100);
115:
116: BEGIN
117:
118: fem_engines_pkg.tech_message (p_severity => g_log_level_2
119: ,p_module => g_block||'.get_param_value'
120: ,p_msg_text => 'BEGIN');
121:
122: OPEN get_db_data_type_cur;

Line 132: fem_engines_pkg.tech_message (p_severity => g_log_level_2

128: ELSE
129: l_ret_type := '''' || p_param_val || '''';
130: END IF;
131:
132: fem_engines_pkg.tech_message (p_severity => g_log_level_2
133: ,p_module => g_block||'.get_param_value'
134: ,p_msg_text => 'END');
135:
136: RETURN l_ret_type;

Line 310: fem_engines_pkg.tech_message (p_severity => g_log_level_2

306: l_op_dataset_code_error EXCEPTION;
307: l_acct_ownership_error EXCEPTION;
308:
309: BEGIN
310: fem_engines_pkg.tech_message (p_severity => g_log_level_2
311: ,p_module => g_block||'.get_from_where_clause.initialize'
312: ,p_msg_text => 'BEGIN');
313:
314: g_src_alias := get_alias(g_src_tab_name,'');

Line 332: fem_engines_pkg.tech_message (p_severity => g_log_level_2

328: OPEN get_table_id_cur(g_src_tab_name);
329: FETCH get_table_id_cur INTO g_table_id;
330: CLOSE get_table_id_cur;
331:
332: fem_engines_pkg.tech_message (p_severity => g_log_level_2
333: ,p_module => g_block||'.get_from_where_clause.initialize'
334: ,p_msg_text => 'Retieved alias and table_id');
335:
336: -----------------------------------------------------------

Line 347: fem_engines_pkg.user_message (

343: ,fnd_global.resp_id
344: ,fnd_global.prog_appl_id);
345:
346: IF (g_curr_conv_type IS NULL) THEN
347: fem_engines_pkg.user_message (
348: p_app_name => 'FEM'
349: ,p_msg_name => G_INV_EXCHG_RATE_TYPE_ERR);
350: RAISE l_no_exch_prof_val;
351: END IF;

Line 353: fem_engines_pkg.tech_message (

349: ,p_msg_name => G_INV_EXCHG_RATE_TYPE_ERR);
350: RAISE l_no_exch_prof_val;
351: END IF;
352:
353: fem_engines_pkg.tech_message (
354: p_severity => g_log_level_2
355: ,p_module => g_block||'.get_from_where_clause.initialize'
356: ,p_msg_text => 'Retieved currency conversion type..type '
357: || g_curr_conv_type);

Line 391: fem_engines_pkg.user_message(

387: AND ver.default_version_flag = 'Y';
388:
389: EXCEPTION
390: WHEN OTHERS THEN
391: fem_engines_pkg.user_message(
392: p_app_name => 'FEM'
393: ,p_msg_name => G_NO_ATTR_VER_ERR
394: ,p_token1 => 'DIMENSION_ID'
395: ,p_value1 => dim_rec.dimension_id

Line 403: fem_engines_pkg.tech_message (

399: ,p_value3 => l_attribute_varchar_label);
400: RAISE l_get_dim_attr_error;
401: END;
402:
403: fem_engines_pkg.tech_message (
404: p_severity => g_log_level_2
405: ,p_module => g_block||'.get_from_where_clause.initialize'
406: ,p_msg_text => 'Retrieved attribute and version for.. '
407: || l_attribute_varchar_label);

Line 421: fem_engines_pkg.user_message(

417: AND cal_period_id = l_member_id;
418:
419: EXCEPTION
420: WHEN OTHERS THEN
421: fem_engines_pkg.user_message(
422: p_app_name => 'FEM'
423: ,p_msg_name => G_NO_EXCHG_RATE_ERR);
424:
425: RAISE l_get_exch_rate_error;

Line 440: fem_engines_pkg.user_message (

436: AND ledger_id = l_member_id;
437:
438: EXCEPTION
439: WHEN OTHERS THEN
440: fem_engines_pkg.user_message (
441: p_app_name => 'FEM'
442: ,p_msg_name => G_NO_FUNCTIONAL_CURR_ERR);
443:
444: RAISE l_get_ledger_curr_error;

Line 451: fem_engines_pkg.tech_message (

447: END IF;
448:
449: END LOOP;
450:
451: fem_engines_pkg.tech_message (
452: p_severity => g_log_level_2
453: ,p_module => g_block||'.get_from_where_clause.initialize'
454: ,p_msg_text => 'Retrieved currency exchange date '
455: || g_exch_rate_date|| ' and functional currency '

Line 470: fem_engines_pkg.user_message (

466: WHERE dataset_io_obj_def_id = p_dataset_grp_obj_def_id;
467:
468: EXCEPTION
469: WHEN OTHERS THEN
470: fem_engines_pkg.user_message (
471: p_app_name => 'FEM'
472: ,p_msg_name => G_INVALID_DATASET_GRP_ERR
473: ,p_token1 => 'DATASET_IO_OBJ_DEF_ID'
474: ,p_value1 => p_dataset_grp_obj_def_id);

Line 479: fem_engines_pkg.tech_message (

475: RAISE l_op_dataset_code_error;
476:
477: END;
478:
479: fem_engines_pkg.tech_message (
480: p_severity => g_log_level_2
481: ,p_module => g_block||'.get_from_where_clause.initialize'
482: ,p_msg_text => 'Retrieved dataset code ');
483:

Line 507: fem_engines_pkg.tech_message (

503: WHERE acct_ownership_display_code = l_disp_code;
504:
505: EXCEPTION
506: WHEN OTHERS THEN
507: fem_engines_pkg.tech_message (
508: p_severity => g_log_level_6
509: ,p_module => g_block||'.get_from_where_clause.initialize'
510: ,p_msg_text => 'Error fetching account ownership
511: display code for ' || l_disp_code);

Line 513: fem_engines_pkg.user_message (

509: ,p_module => g_block||'.get_from_where_clause.initialize'
510: ,p_msg_text => 'Error fetching account ownership
511: display code for ' || l_disp_code);
512:
513: fem_engines_pkg.user_message (
514: p_app_name => 'FEM'
515: ,p_msg_name => G_INVALID_ACCT_OWNER_ID_ERR
516: ,p_token1 => 'ACCOUNT_OWNERSHIP_DISPLAY_CODE'
517: ,p_value1 => l_disp_code);

Line 524: fem_engines_pkg.tech_message (

520: END;
521:
522: l_disp_code := NULL;
523:
524: fem_engines_pkg.tech_message (
525: p_severity => g_log_level_2
526: ,p_module => g_block||'.get_from_where_clause.initialize'
527: ,p_msg_text => 'Retrieved acct_ownshp_id '
528: || TO_CHAR(l_acct_ownership_id) );

Line 530: fem_engines_pkg.tech_message (

526: ,p_module => g_block||'.get_from_where_clause.initialize'
527: ,p_msg_text => 'Retrieved acct_ownshp_id '
528: || TO_CHAR(l_acct_ownership_id) );
529:
530: fem_engines_pkg.tech_message (
531: p_severity => g_log_level_2
532: ,p_module => g_block||'.get_from_where_clause.initialize'
533: ,p_msg_text => 'END');
534:

Line 539: fem_engines_pkg.tech_message (

535: EXCEPTION
536:
537: WHEN l_no_exch_prof_val THEN
538: x_return_status := c_error;
539: fem_engines_pkg.tech_message (
540: p_severity => g_log_level_6
541: ,p_module => g_block||'.initialize'
542: ,p_msg_text => 'Initialize Exception - no exch rate type');
543:

Line 546: fem_engines_pkg.tech_message (

542: ,p_msg_text => 'Initialize Exception - no exch rate type');
543:
544: WHEN l_get_dim_attr_error THEN
545: x_return_status := c_error;
546: fem_engines_pkg.tech_message (
547: p_severity => g_log_level_6
548: ,p_module => g_block||'.initialize'
549: ,p_msg_text => 'Initialize Exception - no attributes');
550:

Line 553: fem_engines_pkg.tech_message (

549: ,p_msg_text => 'Initialize Exception - no attributes');
550:
551: WHEN l_get_exch_rate_error THEN
552: x_return_status := c_error;
553: fem_engines_pkg.tech_message (
554: p_severity => g_log_level_6
555: ,p_module => g_block||'.initialize'
556: ,p_msg_text => 'Initialize Exception: getting the exch rate');
557:

Line 560: fem_engines_pkg.tech_message (

556: ,p_msg_text => 'Initialize Exception: getting the exch rate');
557:
558: WHEN l_get_ledger_curr_error THEN
559: x_return_status := c_error;
560: fem_engines_pkg.tech_message (
561: p_severity => g_log_level_6
562: ,p_module => g_block||'.initialize'
563: ,p_msg_text => 'Initialize Exception: getting the func curr');
564:

Line 567: fem_engines_pkg.tech_message (

563: ,p_msg_text => 'Initialize Exception: getting the func curr');
564:
565: WHEN l_op_dataset_code_error THEN
566: x_return_status := c_error;
567: fem_engines_pkg.tech_message (
568: p_severity => g_log_level_6
569: ,p_module => g_block||'.initialize'
570: ,p_msg_text => 'Initialize Exception: Invalid dataset group');
571:

Line 574: fem_engines_pkg.tech_message (

570: ,p_msg_text => 'Initialize Exception: Invalid dataset group');
571:
572: WHEN l_acct_ownership_error THEN
573: x_return_status := c_error;
574: fem_engines_pkg.tech_message (
575: p_severity => g_log_level_6
576: ,p_module => g_block||'.initialize'
577: ,p_msg_text => 'Initialize Exception:Account ownership code');
578:

Line 583: fem_engines_pkg.tech_message (

579: END initialize;
580:
581: BEGIN
582:
583: fem_engines_pkg.tech_message (
584: p_severity => g_log_level_2
585: ,p_module => g_block||'.get_from_where_clause'
586: ,p_msg_text => 'BEGIN');
587:

Line 622: fem_engines_pkg.tech_message (

618:
619: -- The currency exch rate,type need to be evaluated
620: -- as well
621:
622: fem_engines_pkg.tech_message (
623: p_severity => g_log_level_2
624: ,p_module => g_block||'.get_from_where_clause'
625: ,p_msg_text => 'Initializing global variables');
626:

Line 631: fem_engines_pkg.tech_message (

627: g_src_tab_name := get_table_list_rec.source_table_name;
628: g_tgt_tab_name := get_table_list_rec.target_table_name;
629: initialize;
630:
631: fem_engines_pkg.tech_message (
632: p_severity => g_log_level_2
633: ,p_module => g_block||'.get_from_where_clause'
634: ,p_msg_text => 'After initializing global variables');
635:

Line 642: fem_engines_pkg.tech_message (

638: IF agg_present THEN
639: l_agg_method := NVL(get_table_list_rec.agg_method,'MIN');
640: END IF;
641:
642: fem_engines_pkg.tech_message (
643: p_severity => g_log_level_1
644: ,p_module => g_block||'.get_from_where_clause'
645: ,p_msg_text => 'Return status after initialize = '||x_return_status);
646:

Line 651: fem_engines_pkg.tech_message(

647: IF x_return_status = c_success THEN
648:
649: IF get_table_list_rec.parameter_flag = 'N' THEN
650:
651: fem_engines_pkg.tech_message(
652: p_severity => g_log_level_1
653: ,p_module => g_block||'.get_from_where_clause'
654: ,p_msg_text => 'Inside While, Parameter = N, Population Method = '
655: ||l_data_pop_method||' for column = '

Line 755: fem_engines_pkg.tech_message (p_severity => g_log_level_1

751: -- done manually.
752:
753: IF NOT eng_proc_where_generated THEN
754:
755: fem_engines_pkg.tech_message (p_severity => g_log_level_1
756: ,p_module => g_block||'.get_from_where_clause'
757: ,p_msg_text => 'Before generating the where ');
758:
759: fem_ds_where_clause_generator.fem_gen_ds_wclause_pvt(p_api_version => l_api_version

Line 778: FEM_ENGINES_PKG.User_Message (

774: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
775:
776: eng_proc_where_generated := FALSE;
777:
778: FEM_ENGINES_PKG.User_Message (
779: p_app_name => 'FEM'
780: ,p_msg_name => G_DS_WHERE_PREDICATE_ERR);
781:
782: IF (l_where IS NULL) THEN

Line 783: FEM_ENGINES_PKG.User_Message (

779: p_app_name => 'FEM'
780: ,p_msg_name => G_DS_WHERE_PREDICATE_ERR);
781:
782: IF (l_where IS NULL) THEN
783: FEM_ENGINES_PKG.User_Message (
784: p_app_name => 'FEM'
785: ,p_msg_name => G_DS_WHERE_PREDICATE_ERR);
786: END IF;
787: RAISE e_ds_wclause_error;

Line 791: fem_engines_pkg.tech_message (p_severity => g_log_level_1

787: RAISE e_ds_wclause_error;
788:
789: END IF;
790:
791: fem_engines_pkg.tech_message (p_severity => g_log_level_1
792: ,p_module => g_block||'.get_from_where_clause'
793: ,p_msg_text => 'DS WHERE clause generated, where = ' || l_where);
794:
795: p_where_clause := p_where_clause || ' AND ' || l_where;

Line 856: fem_engines_pkg.tech_message (p_severity => g_log_level_1

852: END IF; -- dimension_lookup
853:
854: ELSE -- parameter_flag
855:
856: fem_engines_pkg.tech_message (p_severity => g_log_level_1
857: ,p_module => g_block||'.get_from_where_clause'
858: ,p_msg_text => 'Step1: Parameter = Y, for column = ' || l_source_col_name );
859:
860: -- Implies value derived at runtime

Line 975: fem_engines_pkg.tech_message (p_severity => g_log_level_1

971: p_from_clause := NULL;
972: p_where_clause := NULL;
973: END IF;
974:
975: fem_engines_pkg.tech_message (p_severity => g_log_level_1
976: ,p_module => g_block||'.get_from_where_clause'
977: ,p_msg_text => 'p_insert_list ' || p_insert_list);
978:
979: fem_engines_pkg.tech_message (p_severity => g_log_level_1

Line 979: fem_engines_pkg.tech_message (p_severity => g_log_level_1

975: fem_engines_pkg.tech_message (p_severity => g_log_level_1
976: ,p_module => g_block||'.get_from_where_clause'
977: ,p_msg_text => 'p_insert_list ' || p_insert_list);
978:
979: fem_engines_pkg.tech_message (p_severity => g_log_level_1
980: ,p_module => g_block||'.get_from_where_clause'
981: ,p_msg_text => 'p_select_list ' || p_select_list);
982:
983: fem_engines_pkg.tech_message (p_severity => g_log_level_1

Line 983: fem_engines_pkg.tech_message (p_severity => g_log_level_1

979: fem_engines_pkg.tech_message (p_severity => g_log_level_1
980: ,p_module => g_block||'.get_from_where_clause'
981: ,p_msg_text => 'p_select_list ' || p_select_list);
982:
983: fem_engines_pkg.tech_message (p_severity => g_log_level_1
984: ,p_module => g_block||'.get_from_where_clause'
985: ,p_msg_text => 'p_from_clause ' || p_from_clause);
986:
987: fem_engines_pkg.tech_message (p_severity => g_log_level_1

Line 987: fem_engines_pkg.tech_message (p_severity => g_log_level_1

983: fem_engines_pkg.tech_message (p_severity => g_log_level_1
984: ,p_module => g_block||'.get_from_where_clause'
985: ,p_msg_text => 'p_from_clause ' || p_from_clause);
986:
987: fem_engines_pkg.tech_message (p_severity => g_log_level_1
988: ,p_module => g_block||'.get_from_where_clause'
989: ,p_msg_text => 'p_where_clause ' || p_where_clause);
990:
991: EXCEPTION

Line 996: fem_engines_pkg.tech_message (p_severity => g_log_level_5

992:
993: WHEN e_ds_wclause_error THEN
994: x_return_status := c_error;
995:
996: fem_engines_pkg.tech_message (p_severity => g_log_level_5
997: ,p_module => g_block||'.get_from_where_clause'
998: ,p_msg_text => 'Dataset Where Clause Generate Exception');
999: FEM_ENGINES_PKG.User_Message (
1000: p_app_name => 'FEM'

Line 999: FEM_ENGINES_PKG.User_Message (

995:
996: fem_engines_pkg.tech_message (p_severity => g_log_level_5
997: ,p_module => g_block||'.get_from_where_clause'
998: ,p_msg_text => 'Dataset Where Clause Generate Exception');
999: FEM_ENGINES_PKG.User_Message (
1000: p_app_name => 'FEM'
1001: ,p_msg_name => G_GENERATE_WHERE_CLAUSE_ERR);
1002:
1003: fnd_msg_pub.count_and_get(p_encoded => p_encoded,

Line 1010: fem_engines_pkg.tech_message (p_severity => g_log_level_5

1006:
1007: WHEN OTHERS THEN
1008: x_return_status := c_error;
1009:
1010: fem_engines_pkg.tech_message (p_severity => g_log_level_5
1011: ,p_module => g_block||'.get_from_where_clause'
1012: ,p_msg_text => 'get_from_where_clause: General_Exception');
1013: FEM_ENGINES_PKG.User_Message (
1014: p_app_name => 'FEM'

Line 1013: FEM_ENGINES_PKG.User_Message (

1009:
1010: fem_engines_pkg.tech_message (p_severity => g_log_level_5
1011: ,p_module => g_block||'.get_from_where_clause'
1012: ,p_msg_text => 'get_from_where_clause: General_Exception');
1013: FEM_ENGINES_PKG.User_Message (
1014: p_app_name => 'FEM'
1015: ,p_msg_name => G_GENERATE_WHERE_CLAUSE_ERR);
1016:
1017: fnd_msg_pub.count_and_get(p_encoded => p_encoded,

Line 1049: fem_engines_pkg.tech_message (p_severity => g_log_level_2

1045: WHERE col_pop_templt_obj_def_id = p_object_def_id
1046: AND aggregation_method <> 'NOAGG');
1047: BEGIN
1048:
1049: fem_engines_pkg.tech_message (p_severity => g_log_level_2
1050: ,p_module => g_block||'.is_aggregation_present'
1051: ,p_msg_text => 'BEGIN');
1052:
1053: retval := TRUE;

Line 1064: fem_engines_pkg.tech_message (p_severity => g_log_level_2

1060: END IF;
1061:
1062: CLOSE chk_for_agg_cur;
1063:
1064: fem_engines_pkg.tech_message (p_severity => g_log_level_2
1065: ,p_module => g_block||'.is_aggregation_present'
1066: ,p_msg_text => 'END');
1067:
1068: RETURN retval;

Line 1133: fem_engines_pkg.tech_message (p_severity => g_log_level_2

1129:
1130: e_cond_wclause_error EXCEPTION;
1131: BEGIN
1132:
1133: fem_engines_pkg.tech_message (p_severity => g_log_level_2
1134: ,p_module => g_block||'.'||l_api_name
1135: ,p_msg_text => 'BEGIN');
1136:
1137: l_api_version := NVL(p_api_version, c_api_version);

Line 1148: fem_engines_pkg.tech_message (

1144: --g_effective_date := fnd_profile.value('FEM_EFFECTIVE_DATE');
1145:
1146: g_obj_def_id := p_object_def_id;
1147:
1148: fem_engines_pkg.tech_message (
1149: p_severity => g_log_level_1
1150: ,p_module => g_block||'.'||l_api_name
1151: ,p_msg_text => 'Calling get_from_where_clause procedure');
1152:

Line 1187: fem_engines_pkg.tech_message (p_severity => g_log_level_1

1183: p_select_list := 'SELECT ' || l_select_list;
1184:
1185: IF p_selection_param = 0 THEN
1186:
1187: fem_engines_pkg.tech_message (p_severity => g_log_level_1
1188: ,p_module => g_block||'.'||l_api_name
1189: ,p_msg_text => 'Step 2: Condition Predicate Preparation');
1190:
1191: Fem_Conditions_Api.Generate_Condition_Predicate

Line 1211: FEM_ENGINES_PKG.User_Message (

1207:
1208: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
1209:
1210: IF (p_con_where_clause IS NULL) THEN
1211: FEM_ENGINES_PKG.User_Message (
1212: p_app_name => 'FEM'
1213: ,p_msg_name => G_CONDITION_PREDICATE_ERR
1214: ,p_token1 => 'COND_OBJ_ID'
1215: ,p_value1 => p_condition_obj_id);

Line 1222: fem_engines_pkg.tech_message (p_severity => g_log_level_1

1218: RAISE e_cond_wclause_error;
1219:
1220: END IF;
1221:
1222: fem_engines_pkg.tech_message (p_severity => g_log_level_1
1223: ,p_module => g_block||'.'||l_api_name
1224: ,p_msg_text => 'Condition Predicate: ' || p_con_where_clause);
1225:
1226: fem_engines_pkg.tech_message (p_severity => g_log_level_1

Line 1226: fem_engines_pkg.tech_message (p_severity => g_log_level_1

1222: fem_engines_pkg.tech_message (p_severity => g_log_level_1
1223: ,p_module => g_block||'.'||l_api_name
1224: ,p_msg_text => 'Condition Predicate: ' || p_con_where_clause);
1225:
1226: fem_engines_pkg.tech_message (p_severity => g_log_level_1
1227: ,p_module => g_block||'.'||l_api_name
1228: ,p_msg_text => 'Step 2: After Condition Predicate Preparation');
1229: END IF;
1230:

Line 1237: fem_engines_pkg.tech_message (p_severity => g_log_level_2

1233: p_data => x_msg_data);
1234:
1235: END IF;
1236:
1237: fem_engines_pkg.tech_message (p_severity => g_log_level_2
1238: ,p_module => g_block||'.'||l_api_name
1239: ,p_msg_text => 'END');
1240:
1241: EXCEPTION

Line 1244: fem_engines_pkg.tech_message (p_severity => g_log_level_5

1240:
1241: EXCEPTION
1242:
1243: WHEN e_cond_wclause_error THEN
1244: fem_engines_pkg.tech_message (p_severity => g_log_level_5
1245: ,p_module => g_block||'.'||l_api_name
1246: ,p_msg_text => 'Condition Where Clause Exception');
1247: FEM_ENGINES_PKG.User_Message (
1248: p_app_name => 'FEM'

Line 1247: FEM_ENGINES_PKG.User_Message (

1243: WHEN e_cond_wclause_error THEN
1244: fem_engines_pkg.tech_message (p_severity => g_log_level_5
1245: ,p_module => g_block||'.'||l_api_name
1246: ,p_msg_text => 'Condition Where Clause Exception');
1247: FEM_ENGINES_PKG.User_Message (
1248: p_app_name => 'FEM'
1249: ,p_msg_name => G_GENERATE_PREDICATES_ERR);
1250:
1251: fnd_msg_pub.count_and_get(p_encoded => p_encoded,

Line 1258: fem_engines_pkg.tech_message (p_severity => g_log_level_5

1254:
1255: x_return_status := fnd_api.g_ret_sts_error;
1256:
1257: WHEN OTHERS THEN
1258: fem_engines_pkg.tech_message (p_severity => g_log_level_5
1259: ,p_module => g_block||'.'||l_api_name
1260: ,p_msg_text => 'Generate_predicates: General_Exception');
1261:
1262: FEM_ENGINES_PKG.User_Message (

Line 1262: FEM_ENGINES_PKG.User_Message (

1258: fem_engines_pkg.tech_message (p_severity => g_log_level_5
1259: ,p_module => g_block||'.'||l_api_name
1260: ,p_msg_text => 'Generate_predicates: General_Exception');
1261:
1262: FEM_ENGINES_PKG.User_Message (
1263: p_app_name => 'FEM'
1264: ,p_msg_name => G_GENERATE_PREDICATES_ERR);
1265:
1266: fnd_msg_pub.count_and_get(p_encoded => p_encoded,