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_DIMENSION_UTIL_PKG dependencies on FND_LOG

Line 125: c_log_level_1 CONSTANT NUMBER := fnd_log.level_statement;

121: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FEM_DIMENSION_UTIL_PKG';
122:
123: f_set_status BOOLEAN;
124:
125: c_log_level_1 CONSTANT NUMBER := fnd_log.level_statement;
126: c_log_level_2 CONSTANT NUMBER := fnd_log.level_procedure;
127: c_log_level_3 CONSTANT NUMBER := fnd_log.level_event;
128: c_log_level_4 CONSTANT NUMBER := fnd_log.level_exception;
129: c_log_level_5 CONSTANT NUMBER := fnd_log.level_error;

Line 126: c_log_level_2 CONSTANT NUMBER := fnd_log.level_procedure;

122:
123: f_set_status BOOLEAN;
124:
125: c_log_level_1 CONSTANT NUMBER := fnd_log.level_statement;
126: c_log_level_2 CONSTANT NUMBER := fnd_log.level_procedure;
127: c_log_level_3 CONSTANT NUMBER := fnd_log.level_event;
128: c_log_level_4 CONSTANT NUMBER := fnd_log.level_exception;
129: c_log_level_5 CONSTANT NUMBER := fnd_log.level_error;
130: c_log_level_6 CONSTANT NUMBER := fnd_log.level_unexpected;

Line 127: c_log_level_3 CONSTANT NUMBER := fnd_log.level_event;

123: f_set_status BOOLEAN;
124:
125: c_log_level_1 CONSTANT NUMBER := fnd_log.level_statement;
126: c_log_level_2 CONSTANT NUMBER := fnd_log.level_procedure;
127: c_log_level_3 CONSTANT NUMBER := fnd_log.level_event;
128: c_log_level_4 CONSTANT NUMBER := fnd_log.level_exception;
129: c_log_level_5 CONSTANT NUMBER := fnd_log.level_error;
130: c_log_level_6 CONSTANT NUMBER := fnd_log.level_unexpected;
131:

Line 128: c_log_level_4 CONSTANT NUMBER := fnd_log.level_exception;

124:
125: c_log_level_1 CONSTANT NUMBER := fnd_log.level_statement;
126: c_log_level_2 CONSTANT NUMBER := fnd_log.level_procedure;
127: c_log_level_3 CONSTANT NUMBER := fnd_log.level_event;
128: c_log_level_4 CONSTANT NUMBER := fnd_log.level_exception;
129: c_log_level_5 CONSTANT NUMBER := fnd_log.level_error;
130: c_log_level_6 CONSTANT NUMBER := fnd_log.level_unexpected;
131:
132: -----------------------

Line 129: c_log_level_5 CONSTANT NUMBER := fnd_log.level_error;

125: c_log_level_1 CONSTANT NUMBER := fnd_log.level_statement;
126: c_log_level_2 CONSTANT NUMBER := fnd_log.level_procedure;
127: c_log_level_3 CONSTANT NUMBER := fnd_log.level_event;
128: c_log_level_4 CONSTANT NUMBER := fnd_log.level_exception;
129: c_log_level_5 CONSTANT NUMBER := fnd_log.level_error;
130: c_log_level_6 CONSTANT NUMBER := fnd_log.level_unexpected;
131:
132: -----------------------
133: -- Package Variables --

Line 130: c_log_level_6 CONSTANT NUMBER := fnd_log.level_unexpected;

126: c_log_level_2 CONSTANT NUMBER := fnd_log.level_procedure;
127: c_log_level_3 CONSTANT NUMBER := fnd_log.level_event;
128: c_log_level_4 CONSTANT NUMBER := fnd_log.level_exception;
129: c_log_level_5 CONSTANT NUMBER := fnd_log.level_error;
130: c_log_level_6 CONSTANT NUMBER := fnd_log.level_unexpected;
131:
132: -----------------------
133: -- Package Variables --
134: -----------------------

Line 1105: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

1101: p_per_num_offset IN NUMBER,
1102: p_base_cal_period_id IN NUMBER
1103: ) RETURN NUMBER
1104: IS
1105: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1106: 'fem.plsql.fem_dimension_util_pkg.relative_cal_period_id';
1107: C_LIMIT CONSTANT NUMBER := 10000; -- fetch limit
1108: e_unexp EXCEPTION;
1109:

Line 1134: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1130: v_index NUMBER;
1131: v_fetches_needed NUMBER;
1132: BEGIN
1133:
1134: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1135: FEM_ENGINES_PKG.TECH_MESSAGE(
1136: p_severity => FND_LOG.level_procedure,
1137: p_module => C_MODULE,
1138: p_msg_text => 'Begin Procedure');

Line 1136: p_severity => FND_LOG.level_procedure,

1132: BEGIN
1133:
1134: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1135: FEM_ENGINES_PKG.TECH_MESSAGE(
1136: p_severity => FND_LOG.level_procedure,
1137: p_module => C_MODULE,
1138: p_msg_text => 'Begin Procedure');
1139: END IF;
1140:

Line 1159: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1155: p_data => x_msg_data);
1156: RETURN -1;
1157: END IF;
1158:
1159: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1160: FEM_ENGINES_PKG.TECH_MESSAGE(
1161: p_severity => FND_LOG.level_statement,
1162: p_module => C_MODULE,
1163: p_msg_text => 'p_per_num_offset = '||to_char(p_per_num_offset));

Line 1161: p_severity => FND_LOG.level_statement,

1157: END IF;
1158:
1159: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1160: FEM_ENGINES_PKG.TECH_MESSAGE(
1161: p_severity => FND_LOG.level_statement,
1162: p_module => C_MODULE,
1163: p_msg_text => 'p_per_num_offset = '||to_char(p_per_num_offset));
1164: FEM_ENGINES_PKG.TECH_MESSAGE(
1165: p_severity => FND_LOG.level_statement,

Line 1165: p_severity => FND_LOG.level_statement,

1161: p_severity => FND_LOG.level_statement,
1162: p_module => C_MODULE,
1163: p_msg_text => 'p_per_num_offset = '||to_char(p_per_num_offset));
1164: FEM_ENGINES_PKG.TECH_MESSAGE(
1165: p_severity => FND_LOG.level_statement,
1166: p_module => C_MODULE,
1167: p_msg_text => 'p_base_cal_period_id = '||to_char(p_base_cal_period_id));
1168: END IF;
1169:

Line 1178: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1174: INTO v_base_calendar_id, v_base_dimgrp_id
1175: FROM fem_cal_periods_b
1176: WHERE cal_period_id = p_base_cal_period_id;
1177:
1178: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1179: FEM_ENGINES_PKG.TECH_MESSAGE(
1180: p_severity => FND_LOG.level_statement,
1181: p_module => C_MODULE,
1182: p_msg_text => 'v_base_calendar_id = '||to_char(v_base_calendar_id));

Line 1180: p_severity => FND_LOG.level_statement,

1176: WHERE cal_period_id = p_base_cal_period_id;
1177:
1178: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1179: FEM_ENGINES_PKG.TECH_MESSAGE(
1180: p_severity => FND_LOG.level_statement,
1181: p_module => C_MODULE,
1182: p_msg_text => 'v_base_calendar_id = '||to_char(v_base_calendar_id));
1183: FEM_ENGINES_PKG.TECH_MESSAGE(
1184: p_severity => FND_LOG.level_statement,

Line 1184: p_severity => FND_LOG.level_statement,

1180: p_severity => FND_LOG.level_statement,
1181: p_module => C_MODULE,
1182: p_msg_text => 'v_base_calendar_id = '||to_char(v_base_calendar_id));
1183: FEM_ENGINES_PKG.TECH_MESSAGE(
1184: p_severity => FND_LOG.level_statement,
1185: p_module => C_MODULE,
1186: p_msg_text => 'v_base_dimgrp_id = '||to_char(v_base_dimgrp_id));
1187: END IF;
1188: EXCEPTION

Line 1190: IF FND_LOG.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1186: p_msg_text => 'v_base_dimgrp_id = '||to_char(v_base_dimgrp_id));
1187: END IF;
1188: EXCEPTION
1189: WHEN OTHERS THEN
1190: IF FND_LOG.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1191: FEM_ENGINES_PKG.TECH_MESSAGE(
1192: p_severity => FND_LOG.level_error,
1193: p_module => C_MODULE,
1194: p_msg_text => 'Calendar period '||to_char(p_base_cal_period_id)

Line 1192: p_severity => FND_LOG.level_error,

1188: EXCEPTION
1189: WHEN OTHERS THEN
1190: IF FND_LOG.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1191: FEM_ENGINES_PKG.TECH_MESSAGE(
1192: p_severity => FND_LOG.level_error,
1193: p_module => C_MODULE,
1194: p_msg_text => 'Calendar period '||to_char(p_base_cal_period_id)
1195: ||' cannot be found.');
1196: END IF;

Line 1220: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1216: INTO v_dim_id, v_dim_name
1217: FROM fem_dimensions_vl
1218: WHERE dimension_varchar_label = 'CALENDAR';
1219:
1220: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1221: FEM_ENGINES_PKG.TECH_MESSAGE(
1222: p_severity => FND_LOG.level_statement,
1223: p_module => C_MODULE,
1224: p_msg_text => 'Dimension ID of Calendar dimenions is '

Line 1222: p_severity => FND_LOG.level_statement,

1218: WHERE dimension_varchar_label = 'CALENDAR';
1219:
1220: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1221: FEM_ENGINES_PKG.TECH_MESSAGE(
1222: p_severity => FND_LOG.level_statement,
1223: p_module => C_MODULE,
1224: p_msg_text => 'Dimension ID of Calendar dimenions is '
1225: ||to_char(v_dim_id));
1226: END IF;

Line 1229: IF FND_LOG.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1225: ||to_char(v_dim_id));
1226: END IF;
1227: EXCEPTION
1228: WHEN others THEN
1229: IF FND_LOG.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1230: FEM_ENGINES_PKG.TECH_MESSAGE(
1231: p_severity => FND_LOG.level_error,
1232: p_module => C_MODULE,
1233: p_msg_text => 'CALENDAR dimension does not exist!');

Line 1231: p_severity => FND_LOG.level_error,

1227: EXCEPTION
1228: WHEN others THEN
1229: IF FND_LOG.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1230: FEM_ENGINES_PKG.TECH_MESSAGE(
1231: p_severity => FND_LOG.level_error,
1232: p_module => C_MODULE,
1233: p_msg_text => 'CALENDAR dimension does not exist!');
1234: END IF;
1235: RAISE e_error;

Line 1247: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1243: x_attr_id => v_cal_attr_id,
1244: x_ver_id => v_cal_attr_ver_id,
1245: x_err_code => v_return_code);
1246:
1247: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1248: FEM_ENGINES_PKG.TECH_MESSAGE(
1249: p_severity => FND_LOG.level_statement,
1250: p_module => C_MODULE,
1251: p_msg_text => 'FEM_Dimension_Util_Pkg.get_dim_attr_id_ver_id'

Line 1249: p_severity => FND_LOG.level_statement,

1245: x_err_code => v_return_code);
1246:
1247: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1248: FEM_ENGINES_PKG.TECH_MESSAGE(
1249: p_severity => FND_LOG.level_statement,
1250: p_module => C_MODULE,
1251: p_msg_text => 'FEM_Dimension_Util_Pkg.get_dim_attr_id_ver_id'
1252: ||'(INCLUDE_ADJ_PERIOD_FLAG) returned with return code of '
1253: ||to_char(v_return_code));

Line 1264: IF FND_LOG.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1260: -- Administrator for assistance.
1261: -- Dimension: DIMENSION_VARCHAR_LABEL
1262: -- Attribute: ATTRIBUTE_VARCHAR_LABEL
1263:
1264: IF FND_LOG.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1265: FEM_ENGINES_PKG.TECH_MESSAGE(
1266: p_severity => FND_LOG.level_error,
1267: p_module => C_MODULE,
1268: p_app_name => 'FEM',

Line 1266: p_severity => FND_LOG.level_error,

1262: -- Attribute: ATTRIBUTE_VARCHAR_LABEL
1263:
1264: IF FND_LOG.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1265: FEM_ENGINES_PKG.TECH_MESSAGE(
1266: p_severity => FND_LOG.level_error,
1267: p_module => C_MODULE,
1268: p_app_name => 'FEM',
1269: p_msg_name => 'FEM_ENG_NO_DIM_ATTR_VER_ERR',
1270: p_token1 => 'DIMENSION_VARCHAR_LABEL',

Line 1298: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1294: WHERE attribute_id = v_cal_attr_id
1295: AND version_id = v_cal_attr_ver_id
1296: AND calendar_id = v_base_calendar_id;
1297:
1298: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1299: FEM_ENGINES_PKG.TECH_MESSAGE(
1300: p_severity => FND_LOG.level_statement,
1301: p_module => C_MODULE,
1302: p_msg_text => 'Calendar attribute INCLUDE_ADJ_PERIOD_FLAG is set to '

Line 1300: p_severity => FND_LOG.level_statement,

1296: AND calendar_id = v_base_calendar_id;
1297:
1298: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1299: FEM_ENGINES_PKG.TECH_MESSAGE(
1300: p_severity => FND_LOG.level_statement,
1301: p_module => C_MODULE,
1302: p_msg_text => 'Calendar attribute INCLUDE_ADJ_PERIOD_FLAG is set to '
1303: ||v_incl_adj_period);
1304: END IF;

Line 1308: IF FND_LOG.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1304: END IF;
1305: EXCEPTION
1306: WHEN others THEN
1307:
1308: IF FND_LOG.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1309: FEM_ENGINES_PKG.TECH_MESSAGE(
1310: p_severity => FND_LOG.level_error,
1311: p_module => C_MODULE,
1312: p_msg_text => 'Calendar does not have attribute value for '

Line 1310: p_severity => FND_LOG.level_error,

1306: WHEN others THEN
1307:
1308: IF FND_LOG.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1309: FEM_ENGINES_PKG.TECH_MESSAGE(
1310: p_severity => FND_LOG.level_error,
1311: p_module => C_MODULE,
1312: p_msg_text => 'Calendar does not have attribute value for '
1313: ||'attribute INCLUDE_ADJ_PERIOD_FLAG');
1314: END IF;

Line 1349: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1345: INTO v_dim_id, v_dim_name
1346: FROM fem_dimensions_vl
1347: WHERE dimension_varchar_label = 'CAL_PERIOD';
1348:
1349: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1350: FEM_ENGINES_PKG.TECH_MESSAGE(
1351: p_severity => FND_LOG.level_statement,
1352: p_module => C_MODULE,
1353: p_msg_text => 'Dimension ID of Calendar Period dimenions is '

Line 1351: p_severity => FND_LOG.level_statement,

1347: WHERE dimension_varchar_label = 'CAL_PERIOD';
1348:
1349: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1350: FEM_ENGINES_PKG.TECH_MESSAGE(
1351: p_severity => FND_LOG.level_statement,
1352: p_module => C_MODULE,
1353: p_msg_text => 'Dimension ID of Calendar Period dimenions is '
1354: ||to_char(v_dim_id));
1355: END IF;

Line 1358: IF FND_LOG.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1354: ||to_char(v_dim_id));
1355: END IF;
1356: EXCEPTION
1357: WHEN others THEN
1358: IF FND_LOG.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1359: FEM_ENGINES_PKG.TECH_MESSAGE(
1360: p_severity => FND_LOG.level_error,
1361: p_module => C_MODULE,
1362: p_msg_text => 'CAL_PERIOD dimension does not exist!');

Line 1360: p_severity => FND_LOG.level_error,

1356: EXCEPTION
1357: WHEN others THEN
1358: IF FND_LOG.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1359: FEM_ENGINES_PKG.TECH_MESSAGE(
1360: p_severity => FND_LOG.level_error,
1361: p_module => C_MODULE,
1362: p_msg_text => 'CAL_PERIOD dimension does not exist!');
1363: END IF;
1364: RAISE e_error;

Line 1376: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1372: x_attr_id => v_dim_attr_id,
1373: x_ver_id => v_dim_attr_ver_id,
1374: x_err_code => v_return_code);
1375:
1376: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1377: FEM_ENGINES_PKG.TECH_MESSAGE(
1378: p_severity => FND_LOG.level_statement,
1379: p_module => C_MODULE,
1380: p_msg_text => 'FEM_Dimension_Util_Pkg.get_dim_attr_id_ver_id '

Line 1378: p_severity => FND_LOG.level_statement,

1374: x_err_code => v_return_code);
1375:
1376: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1377: FEM_ENGINES_PKG.TECH_MESSAGE(
1378: p_severity => FND_LOG.level_statement,
1379: p_module => C_MODULE,
1380: p_msg_text => 'FEM_Dimension_Util_Pkg.get_dim_attr_id_ver_id '
1381: ||'(INCLUDE_ADJ_PERIOD_FLAG) returned with error code of '
1382: ||to_char(v_return_code));

Line 1394: p_severity => FND_LOG.level_error,

1390: -- Dimension: DIMENSION_VARCHAR_LABEL
1391: -- Attribute: ATTRIBUTE_VARCHAR_LABEL
1392:
1393: FEM_ENGINES_PKG.TECH_MESSAGE(
1394: p_severity => FND_LOG.level_error,
1395: p_module => C_MODULE,
1396: p_app_name => 'FEM',
1397: p_msg_name => 'FEM_ENG_NO_DIM_ATTR_VER_ERR',
1398: p_token1 => 'DIMENSION_VARCHAR_LABEL',

Line 1470: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1466: ELSE
1467: v_sql := v_sql||' ORDER BY cal_period_id asc';
1468: END IF;
1469:
1470: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1471: FEM_ENGINES_PKG.TECH_MESSAGE(
1472: p_severity => FND_LOG.level_statement,
1473: p_module => C_MODULE,
1474: p_msg_text => 'Dynamic sql is '||v_sql);

Line 1472: p_severity => FND_LOG.level_statement,

1468: END IF;
1469:
1470: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1471: FEM_ENGINES_PKG.TECH_MESSAGE(
1472: p_severity => FND_LOG.level_statement,
1473: p_module => C_MODULE,
1474: p_msg_text => 'Dynamic sql is '||v_sql);
1475: END IF;
1476:

Line 1526: p_severity => FND_LOG.level_error,

1522: FROM fem_dim_attributes_vl
1523: WHERE attribute_id = v_cal_attr_id;
1524:
1525: FEM_ENGINES_PKG.TECH_MESSAGE(
1526: p_severity => FND_LOG.level_error,
1527: p_module => C_MODULE,
1528: p_app_name => 'FEM',
1529: p_msg_name => 'FEM_INVALID_PERIOD_OFFSET',
1530: p_token1 => 'CAL_PERIOD_OFFSET',

Line 1545: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1541: ELSE
1542: v_return_code := v_cal_period_tbl(v_index);
1543: END IF;
1544:
1545: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1546: FEM_ENGINES_PKG.TECH_MESSAGE(
1547: p_severity => FND_LOG.level_statement,
1548: p_module => C_MODULE,
1549: p_msg_text => 'v_fetch_count = '||to_char(v_fetch_count));

Line 1547: p_severity => FND_LOG.level_statement,

1543: END IF;
1544:
1545: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1546: FEM_ENGINES_PKG.TECH_MESSAGE(
1547: p_severity => FND_LOG.level_statement,
1548: p_module => C_MODULE,
1549: p_msg_text => 'v_fetch_count = '||to_char(v_fetch_count));
1550: FEM_ENGINES_PKG.TECH_MESSAGE(
1551: p_severity => FND_LOG.level_statement,

Line 1551: p_severity => FND_LOG.level_statement,

1547: p_severity => FND_LOG.level_statement,
1548: p_module => C_MODULE,
1549: p_msg_text => 'v_fetch_count = '||to_char(v_fetch_count));
1550: FEM_ENGINES_PKG.TECH_MESSAGE(
1551: p_severity => FND_LOG.level_statement,
1552: p_module => C_MODULE,
1553: p_msg_text => 'v_fetches_needed = '||to_char(v_fetches_needed));
1554: FEM_ENGINES_PKG.TECH_MESSAGE(
1555: p_severity => FND_LOG.level_statement,

Line 1555: p_severity => FND_LOG.level_statement,

1551: p_severity => FND_LOG.level_statement,
1552: p_module => C_MODULE,
1553: p_msg_text => 'v_fetches_needed = '||to_char(v_fetches_needed));
1554: FEM_ENGINES_PKG.TECH_MESSAGE(
1555: p_severity => FND_LOG.level_statement,
1556: p_module => C_MODULE,
1557: p_msg_text => 'v_index = '||to_char(v_index));
1558: FEM_ENGINES_PKG.TECH_MESSAGE(
1559: p_severity => FND_LOG.level_statement,

Line 1559: p_severity => FND_LOG.level_statement,

1555: p_severity => FND_LOG.level_statement,
1556: p_module => C_MODULE,
1557: p_msg_text => 'v_index = '||to_char(v_index));
1558: FEM_ENGINES_PKG.TECH_MESSAGE(
1559: p_severity => FND_LOG.level_statement,
1560: p_module => C_MODULE,
1561: p_msg_text => 'v_cal_period_tbl.count = '||to_char(v_cal_period_tbl.count));
1562: FEM_ENGINES_PKG.TECH_MESSAGE(
1563: p_severity => FND_LOG.level_statement,

Line 1563: p_severity => FND_LOG.level_statement,

1559: p_severity => FND_LOG.level_statement,
1560: p_module => C_MODULE,
1561: p_msg_text => 'v_cal_period_tbl.count = '||to_char(v_cal_period_tbl.count));
1562: FEM_ENGINES_PKG.TECH_MESSAGE(
1563: p_severity => FND_LOG.level_statement,
1564: p_module => C_MODULE,
1565: p_msg_text => 'Returning value = '||to_char(v_return_code));
1566: END IF;
1567: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1567: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1563: p_severity => FND_LOG.level_statement,
1564: p_module => C_MODULE,
1565: p_msg_text => 'Returning value = '||to_char(v_return_code));
1566: END IF;
1567: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1568: FEM_ENGINES_PKG.TECH_MESSAGE(
1569: p_severity => FND_LOG.level_procedure,
1570: p_module => C_MODULE,
1571: p_msg_text => 'End Procedure');

Line 1569: p_severity => FND_LOG.level_procedure,

1565: p_msg_text => 'Returning value = '||to_char(v_return_code));
1566: END IF;
1567: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1568: FEM_ENGINES_PKG.TECH_MESSAGE(
1569: p_severity => FND_LOG.level_procedure,
1570: p_module => C_MODULE,
1571: p_msg_text => 'End Procedure');
1572: END IF;
1573:

Line 1592: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1588: p_encoded => p_encoded,
1589: p_count => x_msg_count,
1590: p_data => x_msg_data);
1591:
1592: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1593: FEM_ENGINES_PKG.TECH_MESSAGE(
1594: p_severity => FND_LOG.level_procedure,
1595: p_module => C_MODULE,
1596: p_msg_text => 'End Procedure');

Line 1594: p_severity => FND_LOG.level_procedure,

1590: p_data => x_msg_data);
1591:
1592: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1593: FEM_ENGINES_PKG.TECH_MESSAGE(
1594: p_severity => FND_LOG.level_procedure,
1595: p_module => C_MODULE,
1596: p_msg_text => 'End Procedure');
1597: END IF;
1598:

Line 3065: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

3061: x_member_code OUT NOCOPY VARCHAR2
3062: )
3063: IS
3064:
3065: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
3066: 'fem.plsql.fem_dimension_util_pkg.generate_default_load_member(1)';
3067: C_API_NAME CONSTANT VARCHAR2(30) := 'Genereate_Default_Load_Member';
3068:
3069: v_sql VARCHAR2(8191);

Line 3113: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3109:
3110: -- Standard Start of API savepoint
3111: SAVEPOINT gen_default_load_member1_pub;
3112:
3113: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3114: FEM_ENGINES_PKG.TECH_MESSAGE(
3115: p_severity => FND_LOG.level_procedure,
3116: p_module => C_MODULE,
3117: p_msg_text => 'Begin Procedure');

Line 3115: p_severity => FND_LOG.level_procedure,

3111: SAVEPOINT gen_default_load_member1_pub;
3112:
3113: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3114: FEM_ENGINES_PKG.TECH_MESSAGE(
3115: p_severity => FND_LOG.level_procedure,
3116: p_module => C_MODULE,
3117: p_msg_text => 'Begin Procedure');
3118: END IF;
3119:

Line 3129: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3125: p_api_version,
3126: C_API_NAME,
3127: G_PKG_NAME)
3128: THEN
3129: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3130: FEM_ENGINES_PKG.TECH_MESSAGE(
3131: p_severity => FND_LOG.level_statement,
3132: p_module => C_MODULE,
3133: p_msg_text => 'API Version ('||C_API_VERSION||') not compatible with '

Line 3131: p_severity => FND_LOG.level_statement,

3127: G_PKG_NAME)
3128: THEN
3129: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3130: FEM_ENGINES_PKG.TECH_MESSAGE(
3131: p_severity => FND_LOG.level_statement,
3132: p_module => C_MODULE,
3133: p_msg_text => 'API Version ('||C_API_VERSION||') not compatible with '
3134: ||'passed in version ('||p_api_version||')');
3135: END IF;

Line 3150: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3146: IF (x_return_status <> c_success) THEN
3147: RAISE e_error;
3148: END IF;
3149:
3150: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3151: FEM_ENGINES_PKG.TECH_MESSAGE(
3152: p_severity => FND_LOG.level_statement,
3153: p_module => C_MODULE,
3154: p_msg_text => 'p_dim_label = '||p_dim_label);

Line 3152: p_severity => FND_LOG.level_statement,

3148: END IF;
3149:
3150: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3151: FEM_ENGINES_PKG.TECH_MESSAGE(
3152: p_severity => FND_LOG.level_statement,
3153: p_module => C_MODULE,
3154: p_msg_text => 'p_dim_label = '||p_dim_label);
3155: FEM_ENGINES_PKG.TECH_MESSAGE(
3156: p_severity => FND_LOG.level_statement,

Line 3156: p_severity => FND_LOG.level_statement,

3152: p_severity => FND_LOG.level_statement,
3153: p_module => C_MODULE,
3154: p_msg_text => 'p_dim_label = '||p_dim_label);
3155: FEM_ENGINES_PKG.TECH_MESSAGE(
3156: p_severity => FND_LOG.level_statement,
3157: p_module => C_MODULE,
3158: p_msg_text => 'p_vs_id = '||to_char(p_vs_id));
3159: END IF;
3160:

Line 3248: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3244: v_sql := v_sql||' WHERE '||v_member_col||' = :1'
3245: ||' AND value_set_id = :2';
3246: END IF;
3247:
3248: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3249: FEM_ENGINES_PKG.TECH_MESSAGE(
3250: p_severity => FND_LOG.level_statement,
3251: p_module => C_MODULE,
3252: p_msg_text => 'v_sql = '||v_sql);

Line 3250: p_severity => FND_LOG.level_statement,

3246: END IF;
3247:
3248: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3249: FEM_ENGINES_PKG.TECH_MESSAGE(
3250: p_severity => FND_LOG.level_statement,
3251: p_module => C_MODULE,
3252: p_msg_text => 'v_sql = '||v_sql);
3253: END IF;
3254:

Line 3280: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3276: IF v_vsr_flag = 'Y' THEN
3277: v_sql := v_sql||' WHERE value_set_id = :1';
3278: END IF;
3279:
3280: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3281: FEM_ENGINES_PKG.TECH_MESSAGE(
3282: p_severity => FND_LOG.level_statement,
3283: p_module => C_MODULE,
3284: p_msg_text => 'v_sql = '||v_sql);

Line 3282: p_severity => FND_LOG.level_statement,

3278: END IF;
3279:
3280: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3281: FEM_ENGINES_PKG.TECH_MESSAGE(
3282: p_severity => FND_LOG.level_statement,
3283: p_module => C_MODULE,
3284: p_msg_text => 'v_sql = '||v_sql);
3285: END IF;
3286:

Line 3321: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3317: -- is a surrogate key column (which should have a NUMBER data type).
3318: -- IF that is not the case, this API does not know what value to
3319: -- use to default the display code column and errors.
3320: IF v_member_col <> v_member_dc_col THEN
3321: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3322: FEM_ENGINES_PKG.TECH_MESSAGE(
3323: p_severity => FND_LOG.level_exception,
3324: p_module => C_MODULE,
3325: p_msg_text => 'Dimension member display code column ('||v_member_dc_col

Line 3323: p_severity => FND_LOG.level_exception,

3319: -- use to default the display code column and errors.
3320: IF v_member_col <> v_member_dc_col THEN
3321: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3322: FEM_ENGINES_PKG.TECH_MESSAGE(
3323: p_severity => FND_LOG.level_exception,
3324: p_module => C_MODULE,
3325: p_msg_text => 'Dimension member display code column ('||v_member_dc_col
3326: ||') must be same as member code column ('||v_member_col
3327: ||') if member data type is VARCHAR.');

Line 3336: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3332: v_member_code := v_member_dc;
3333: ELSE
3334: -- If member data type is not VARCHAR, this API
3335: -- does not know what value to default so it errors.
3336: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3337: FEM_ENGINES_PKG.TECH_MESSAGE(
3338: p_severity => FND_LOG.level_exception,
3339: p_module => C_MODULE,
3340: p_msg_text => 'Dimension member data type ('||v_member_data_type_code

Line 3338: p_severity => FND_LOG.level_exception,

3334: -- If member data type is not VARCHAR, this API
3335: -- does not know what value to default so it errors.
3336: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3337: FEM_ENGINES_PKG.TECH_MESSAGE(
3338: p_severity => FND_LOG.level_exception,
3339: p_module => C_MODULE,
3340: p_msg_text => 'Dimension member data type ('||v_member_data_type_code
3341: ||') has to be VARCHAR if the member ID source code is not FUNCTION');
3342: END IF;

Line 3368: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3364: v_sql := v_sql||'x_'||substr(v_member_col,1,28)||' => '||v_member_code||',';
3365: ELSIF v_member_data_type_code = 'VARCHAR' THEN
3366: v_sql := v_sql||'x_'||substr(v_member_col,1,28)||' => '''||v_member_code||''',';
3367: ELSE
3368: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3369: FEM_ENGINES_PKG.TECH_MESSAGE(
3370: p_severity => FND_LOG.level_exception,
3371: p_module => C_MODULE,
3372: p_msg_text => 'Member data type ('||v_member_data_type_code

Line 3370: p_severity => FND_LOG.level_exception,

3366: v_sql := v_sql||'x_'||substr(v_member_col,1,28)||' => '''||v_member_code||''',';
3367: ELSE
3368: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3369: FEM_ENGINES_PKG.TECH_MESSAGE(
3370: p_severity => FND_LOG.level_exception,
3371: p_module => C_MODULE,
3372: p_msg_text => 'Member data type ('||v_member_data_type_code
3373: ||') must be is not NUMBER or VARCHAR.');
3374: END IF;

Line 3404: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3400: 'x_last_updated_by => '||c_user_id||','||
3401: 'x_last_update_login => null);'||
3402: ' END;';
3403:
3404: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3405: FEM_ENGINES_PKG.TECH_MESSAGE(
3406: p_severity => FND_LOG.level_statement,
3407: p_module => C_MODULE,
3408: p_msg_text => 'v_sql = '||v_sql);

Line 3406: p_severity => FND_LOG.level_statement,

3402: ' END;';
3403:
3404: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3405: FEM_ENGINES_PKG.TECH_MESSAGE(
3406: p_severity => FND_LOG.level_statement,
3407: p_module => C_MODULE,
3408: p_msg_text => 'v_sql = '||v_sql);
3409: END IF;
3410:

Line 3494: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3490: ','||c_login_id||
3491: ','||1||
3492: ','||'''N'' from dual';
3493:
3494: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3495: FEM_ENGINES_PKG.TECH_MESSAGE(
3496: p_severity => FND_LOG.level_statement,
3497: p_module => C_MODULE,
3498: p_msg_text => 'v_sql = '||v_sql);

Line 3496: p_severity => FND_LOG.level_statement,

3492: ','||'''N'' from dual';
3493:
3494: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3495: FEM_ENGINES_PKG.TECH_MESSAGE(
3496: p_severity => FND_LOG.level_statement,
3497: p_module => C_MODULE,
3498: p_msg_text => 'v_sql = '||v_sql);
3499: END IF;
3500:

Line 3516: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3512: last_update_date = sysdate,
3513: last_updated_by = c_user_id
3514: WHERE value_set_id = p_vs_id;
3515:
3516: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3517: FEM_ENGINES_PKG.TECH_MESSAGE(
3518: p_severity => FND_LOG.level_statement,
3519: p_module => C_MODULE,
3520: p_msg_text => 'Updated FEM_VALUE_SETS_B.default_load_member_id = '

Line 3518: p_severity => FND_LOG.level_statement,

3514: WHERE value_set_id = p_vs_id;
3515:
3516: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3517: FEM_ENGINES_PKG.TECH_MESSAGE(
3518: p_severity => FND_LOG.level_statement,
3519: p_module => C_MODULE,
3520: p_msg_text => 'Updated FEM_VALUE_SETS_B.default_load_member_id = '
3521: ||v_member_code);
3522: END IF;

Line 3532: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3528: last_update_date = sysdate,
3529: last_updated_by = c_user_id
3530: WHERE dimension_id = v_dim_id;
3531:
3532: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3533: FEM_ENGINES_PKG.TECH_MESSAGE(
3534: p_severity => FND_LOG.level_statement,
3535: p_module => C_MODULE,
3536: p_msg_text => 'Updated FEM_XDIM_DIMENSIONS.default_member_display_code = '

Line 3534: p_severity => FND_LOG.level_statement,

3530: WHERE dimension_id = v_dim_id;
3531:
3532: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3533: FEM_ENGINES_PKG.TECH_MESSAGE(
3534: p_severity => FND_LOG.level_statement,
3535: p_module => C_MODULE,
3536: p_msg_text => 'Updated FEM_XDIM_DIMENSIONS.default_member_display_code = '
3537: ||v_member_dc);
3538: END IF;

Line 3549: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3545:
3546: x_member_code := v_member_code;
3547: x_return_status := c_success;
3548:
3549: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3550: FEM_ENGINES_PKG.TECH_MESSAGE(
3551: p_severity => FND_LOG.level_statement,
3552: p_module => C_MODULE,
3553: p_msg_text => 'x_member_code = '||x_member_code);

Line 3551: p_severity => FND_LOG.level_statement,

3547: x_return_status := c_success;
3548:
3549: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3550: FEM_ENGINES_PKG.TECH_MESSAGE(
3551: p_severity => FND_LOG.level_statement,
3552: p_module => C_MODULE,
3553: p_msg_text => 'x_member_code = '||x_member_code);
3554: END IF;
3555: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 3555: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3551: p_severity => FND_LOG.level_statement,
3552: p_module => C_MODULE,
3553: p_msg_text => 'x_member_code = '||x_member_code);
3554: END IF;
3555: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3556: FEM_ENGINES_PKG.TECH_MESSAGE(
3557: p_severity => FND_LOG.level_procedure,
3558: p_module => C_MODULE,
3559: p_msg_text => 'End Procedure');

Line 3557: p_severity => FND_LOG.level_procedure,

3553: p_msg_text => 'x_member_code = '||x_member_code);
3554: END IF;
3555: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3556: FEM_ENGINES_PKG.TECH_MESSAGE(
3557: p_severity => FND_LOG.level_procedure,
3558: p_module => C_MODULE,
3559: p_msg_text => 'End Procedure');
3560: END IF;
3561:

Line 3564: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3560: END IF;
3561:
3562: EXCEPTION
3563: WHEN e_error THEN
3564: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3565: FEM_ENGINES_PKG.TECH_MESSAGE(
3566: p_severity => FND_LOG.level_procedure,
3567: p_module => C_MODULE,
3568: p_msg_text => 'End Procedure');

Line 3566: p_severity => FND_LOG.level_procedure,

3562: EXCEPTION
3563: WHEN e_error THEN
3564: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3565: FEM_ENGINES_PKG.TECH_MESSAGE(
3566: p_severity => FND_LOG.level_procedure,
3567: p_module => C_MODULE,
3568: p_msg_text => 'End Procedure');
3569: END IF;
3570: FND_MSG_PUB.Count_And_Get(p_encoded => p_encoded,

Line 3577: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3573: ROLLBACK TO gen_default_load_member1_pub;
3574: x_return_status := c_error;
3575:
3576: WHEN others THEN
3577: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3578: FEM_ENGINES_PKG.TECH_MESSAGE(
3579: p_severity => FND_LOG.level_statement,
3580: p_module => C_MODULE,
3581: p_msg_text => 'Unexpected error.');

Line 3579: p_severity => FND_LOG.level_statement,

3575:
3576: WHEN others THEN
3577: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3578: FEM_ENGINES_PKG.TECH_MESSAGE(
3579: p_severity => FND_LOG.level_statement,
3580: p_module => C_MODULE,
3581: p_msg_text => 'Unexpected error.');
3582: FEM_ENGINES_PKG.TECH_MESSAGE(
3583: p_severity => FND_LOG.level_statement,

Line 3583: p_severity => FND_LOG.level_statement,

3579: p_severity => FND_LOG.level_statement,
3580: p_module => C_MODULE,
3581: p_msg_text => 'Unexpected error.');
3582: FEM_ENGINES_PKG.TECH_MESSAGE(
3583: p_severity => FND_LOG.level_statement,
3584: p_module => C_MODULE,
3585: p_msg_text => SQLERRM);
3586: END IF;
3587: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 3587: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3583: p_severity => FND_LOG.level_statement,
3584: p_module => C_MODULE,
3585: p_msg_text => SQLERRM);
3586: END IF;
3587: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3588: FEM_ENGINES_PKG.TECH_MESSAGE(
3589: p_severity => FND_LOG.level_procedure,
3590: p_module => C_MODULE,
3591: p_msg_text => 'End Procedure');

Line 3589: p_severity => FND_LOG.level_procedure,

3585: p_msg_text => SQLERRM);
3586: END IF;
3587: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3588: FEM_ENGINES_PKG.TECH_MESSAGE(
3589: p_severity => FND_LOG.level_procedure,
3590: p_module => C_MODULE,
3591: p_msg_text => 'End Procedure');
3592: END IF;
3593: FND_MSG_PUB.Count_And_Get(p_encoded => p_encoded,

Line 3612: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

3608: x_msg_data OUT NOCOPY VARCHAR2,
3609: p_vs_id IN NUMBER
3610: )
3611: IS
3612: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
3613: 'fem.plsql.fem_dimension_util_pkg.generate_default_load_member(2)';
3614: C_API_NAME CONSTANT VARCHAR2(30) := 'Genereate_Default_Load_Member';
3615:
3616: v_dim_label FEM_DIMENSIONS_B.dimension_varchar_label%TYPE;

Line 3624: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3620:
3621: -- Standard Start of API savepoint
3622: SAVEPOINT gen_default_load_member2_pub;
3623:
3624: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3625: FEM_ENGINES_PKG.TECH_MESSAGE(
3626: p_severity => FND_LOG.level_procedure,
3627: p_module => C_MODULE,
3628: p_msg_text => 'Begin Procedure');

Line 3626: p_severity => FND_LOG.level_procedure,

3622: SAVEPOINT gen_default_load_member2_pub;
3623:
3624: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3625: FEM_ENGINES_PKG.TECH_MESSAGE(
3626: p_severity => FND_LOG.level_procedure,
3627: p_module => C_MODULE,
3628: p_msg_text => 'Begin Procedure');
3629: END IF;
3630:

Line 3640: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3636: p_api_version,
3637: C_API_NAME,
3638: G_PKG_NAME)
3639: THEN
3640: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3641: FEM_ENGINES_PKG.TECH_MESSAGE(
3642: p_severity => FND_LOG.level_statement,
3643: p_module => C_MODULE,
3644: p_msg_text => 'API Version ('||C_API_VERSION||') not compatible with '

Line 3642: p_severity => FND_LOG.level_statement,

3638: G_PKG_NAME)
3639: THEN
3640: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3641: FEM_ENGINES_PKG.TECH_MESSAGE(
3642: p_severity => FND_LOG.level_statement,
3643: p_module => C_MODULE,
3644: p_msg_text => 'API Version ('||C_API_VERSION||') not compatible with '
3645: ||'passed in version ('||p_api_version||')');
3646: END IF;

Line 3661: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3657: IF (x_return_status <> c_success) THEN
3658: RAISE e_error;
3659: END IF;
3660:
3661: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3662: FEM_ENGINES_PKG.TECH_MESSAGE(
3663: p_severity => FND_LOG.level_statement,
3664: p_module => C_MODULE,
3665: p_msg_text => 'p_vs_id = '||to_char(p_vs_id));

Line 3663: p_severity => FND_LOG.level_statement,

3659: END IF;
3660:
3661: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3662: FEM_ENGINES_PKG.TECH_MESSAGE(
3663: p_severity => FND_LOG.level_statement,
3664: p_module => C_MODULE,
3665: p_msg_text => 'p_vs_id = '||to_char(p_vs_id));
3666: END IF;
3667:

Line 3722: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3718: p_vs_id => p_vs_id,
3719: x_member_code => v_member_code);
3720:
3721: IF (x_return_status <> c_success) THEN
3722: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3723: FEM_ENGINES_PKG.TECH_MESSAGE(
3724: p_severity => FND_LOG.level_statement,
3725: p_module => C_MODULE,
3726: p_msg_text => 'Call to FEM_Dimension_Util_Pkg.Generate_Default_Load_Member(1)'

Line 3724: p_severity => FND_LOG.level_statement,

3720:
3721: IF (x_return_status <> c_success) THEN
3722: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3723: FEM_ENGINES_PKG.TECH_MESSAGE(
3724: p_severity => FND_LOG.level_statement,
3725: p_module => C_MODULE,
3726: p_msg_text => 'Call to FEM_Dimension_Util_Pkg.Generate_Default_Load_Member(1)'
3727: ||' returned with status: '||x_return_status);
3728: END IF;

Line 3739: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3735: END IF;
3736:
3737: x_return_status := c_success;
3738:
3739: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3740: FEM_ENGINES_PKG.TECH_MESSAGE(
3741: p_severity => FND_LOG.level_procedure,
3742: p_module => C_MODULE,
3743: p_msg_text => 'End Procedure');

Line 3741: p_severity => FND_LOG.level_procedure,

3737: x_return_status := c_success;
3738:
3739: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3740: FEM_ENGINES_PKG.TECH_MESSAGE(
3741: p_severity => FND_LOG.level_procedure,
3742: p_module => C_MODULE,
3743: p_msg_text => 'End Procedure');
3744: END IF;
3745:

Line 3748: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3744: END IF;
3745:
3746: EXCEPTION
3747: WHEN e_error THEN
3748: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3749: FEM_ENGINES_PKG.TECH_MESSAGE(
3750: p_severity => FND_LOG.level_procedure,
3751: p_module => C_MODULE,
3752: p_msg_text => 'End Procedure');

Line 3750: p_severity => FND_LOG.level_procedure,

3746: EXCEPTION
3747: WHEN e_error THEN
3748: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3749: FEM_ENGINES_PKG.TECH_MESSAGE(
3750: p_severity => FND_LOG.level_procedure,
3751: p_module => C_MODULE,
3752: p_msg_text => 'End Procedure');
3753: END IF;
3754: FND_MSG_PUB.Count_And_Get(p_encoded => p_encoded,

Line 3761: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3757: ROLLBACK TO gen_default_load_member2_pub;
3758: x_return_status := c_error;
3759:
3760: WHEN others THEN
3761: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3762: FEM_ENGINES_PKG.TECH_MESSAGE(
3763: p_severity => FND_LOG.level_statement,
3764: p_module => C_MODULE,
3765: p_msg_text => 'Unexpected error.');

Line 3763: p_severity => FND_LOG.level_statement,

3759:
3760: WHEN others THEN
3761: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3762: FEM_ENGINES_PKG.TECH_MESSAGE(
3763: p_severity => FND_LOG.level_statement,
3764: p_module => C_MODULE,
3765: p_msg_text => 'Unexpected error.');
3766: END IF;
3767: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 3767: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3763: p_severity => FND_LOG.level_statement,
3764: p_module => C_MODULE,
3765: p_msg_text => 'Unexpected error.');
3766: END IF;
3767: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3768: FEM_ENGINES_PKG.TECH_MESSAGE(
3769: p_severity => FND_LOG.level_procedure,
3770: p_module => C_MODULE,
3771: p_msg_text => 'End Procedure');

Line 3769: p_severity => FND_LOG.level_procedure,

3765: p_msg_text => 'Unexpected error.');
3766: END IF;
3767: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3768: FEM_ENGINES_PKG.TECH_MESSAGE(
3769: p_severity => FND_LOG.level_procedure,
3770: p_module => C_MODULE,
3771: p_msg_text => 'End Procedure');
3772: END IF;
3773: FND_MSG_PUB.Count_And_Get(p_encoded => p_encoded,

Line 3793: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

3789: x_msg_count OUT NOCOPY NUMBER,
3790: x_msg_data OUT NOCOPY VARCHAR2
3791: )
3792: IS
3793: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
3794: 'fem.plsql.fem_dimension_util_pkg.generate_default_load_member(3)';
3795: C_API_NAME CONSTANT VARCHAR2(30) := 'Genereate_Default_Load_Member';
3796:
3797: v_member_code VARCHAR2(250);

Line 3825: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3821:
3822: -- Standard Start of API savepoint
3823: SAVEPOINT gen_default_load_member3_pub;
3824:
3825: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3826: FEM_ENGINES_PKG.TECH_MESSAGE(
3827: p_severity => FND_LOG.level_procedure,
3828: p_module => C_MODULE,
3829: p_msg_text => 'Begin Procedure');

Line 3827: p_severity => FND_LOG.level_procedure,

3823: SAVEPOINT gen_default_load_member3_pub;
3824:
3825: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3826: FEM_ENGINES_PKG.TECH_MESSAGE(
3827: p_severity => FND_LOG.level_procedure,
3828: p_module => C_MODULE,
3829: p_msg_text => 'Begin Procedure');
3830: END IF;
3831:

Line 3842: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3838: p_api_version,
3839: C_API_NAME,
3840: G_PKG_NAME)
3841: THEN
3842: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3843: FEM_ENGINES_PKG.TECH_MESSAGE(
3844: p_severity => FND_LOG.level_statement,
3845: p_module => C_MODULE,
3846: p_msg_text => 'API Version ('||C_API_VERSION||') not compatible with '

Line 3844: p_severity => FND_LOG.level_statement,

3840: G_PKG_NAME)
3841: THEN
3842: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3843: FEM_ENGINES_PKG.TECH_MESSAGE(
3844: p_severity => FND_LOG.level_statement,
3845: p_module => C_MODULE,
3846: p_msg_text => 'API Version ('||C_API_VERSION||') not compatible with '
3847: ||'passed in version ('||p_api_version||')');
3848: END IF;

Line 3879: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3875: p_vs_id => value_sets.value_set_id,
3876: x_member_code => v_member_code);
3877:
3878: IF x_return_status <> c_success THEN
3879: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3880: v_exception_flag := TRUE;
3881: FEM_ENGINES_PKG.TECH_MESSAGE(
3882: p_severity => FND_LOG.level_exception,
3883: p_module => C_MODULE,

Line 3882: p_severity => FND_LOG.level_exception,

3878: IF x_return_status <> c_success THEN
3879: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3880: v_exception_flag := TRUE;
3881: FEM_ENGINES_PKG.TECH_MESSAGE(
3882: p_severity => FND_LOG.level_exception,
3883: p_module => C_MODULE,
3884: p_msg_text => 'Generate_Default_Load_Member returned with error for'
3885: ||' dim_label = '||dims.dimension_varchar_label
3886: ||', value_set_id = '||value_sets.value_set_id);

Line 3904: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3900: x_member_code => v_member_code);
3901:
3902: IF x_return_status <> c_success THEN
3903: v_exception_flag := TRUE;
3904: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3905: FEM_ENGINES_PKG.TECH_MESSAGE(
3906: p_severity => FND_LOG.level_exception,
3907: p_module => C_MODULE,
3908: p_msg_text => 'Generate_Default_Load_Member returned with error for'

Line 3906: p_severity => FND_LOG.level_exception,

3902: IF x_return_status <> c_success THEN
3903: v_exception_flag := TRUE;
3904: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3905: FEM_ENGINES_PKG.TECH_MESSAGE(
3906: p_severity => FND_LOG.level_exception,
3907: p_module => C_MODULE,
3908: p_msg_text => 'Generate_Default_Load_Member returned with error for'
3909: ||' dim_label = '||dims.dimension_varchar_label);
3910: END IF;

Line 3925: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3921: ELSE
3922: x_return_status := c_success;
3923: END IF;
3924:
3925: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3926: FEM_ENGINES_PKG.TECH_MESSAGE(
3927: p_severity => FND_LOG.level_procedure,
3928: p_module => C_MODULE,
3929: p_msg_text => 'End Procedure');

Line 3927: p_severity => FND_LOG.level_procedure,

3923: END IF;
3924:
3925: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3926: FEM_ENGINES_PKG.TECH_MESSAGE(
3927: p_severity => FND_LOG.level_procedure,
3928: p_module => C_MODULE,
3929: p_msg_text => 'End Procedure');
3930: END IF;
3931:

Line 3934: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3930: END IF;
3931:
3932: EXCEPTION
3933: WHEN others THEN
3934: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3935: FEM_ENGINES_PKG.TECH_MESSAGE(
3936: p_severity => FND_LOG.level_statement,
3937: p_module => C_MODULE,
3938: p_msg_text => 'Unexpected error.');

Line 3936: p_severity => FND_LOG.level_statement,

3932: EXCEPTION
3933: WHEN others THEN
3934: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3935: FEM_ENGINES_PKG.TECH_MESSAGE(
3936: p_severity => FND_LOG.level_statement,
3937: p_module => C_MODULE,
3938: p_msg_text => 'Unexpected error.');
3939: END IF;
3940: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 3940: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3936: p_severity => FND_LOG.level_statement,
3937: p_module => C_MODULE,
3938: p_msg_text => 'Unexpected error.');
3939: END IF;
3940: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3941: FEM_ENGINES_PKG.TECH_MESSAGE(
3942: p_severity => FND_LOG.level_procedure,
3943: p_module => C_MODULE,
3944: p_msg_text => 'End Procedure');

Line 3942: p_severity => FND_LOG.level_procedure,

3938: p_msg_text => 'Unexpected error.');
3939: END IF;
3940: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3941: FEM_ENGINES_PKG.TECH_MESSAGE(
3942: p_severity => FND_LOG.level_procedure,
3943: p_module => C_MODULE,
3944: p_msg_text => 'End Procedure');
3945: END IF;
3946: FND_MSG_PUB.Count_And_Get(p_encoded => p_encoded,

Line 8757: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

8753: p_member_vs_display_code IN VARCHAR2
8754: ) RETURN VARCHAR2
8755: IS
8756:
8757: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
8758: 'fem.plsql.fem_dimension_util_pkg.get_dim_member_id';
8759:
8760: v_dim_id NUMBER;
8761: v_vs_id NUMBER;

Line 8969: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

8965: x_return_status := c_error;
8966: RETURN -1;
8967:
8968: WHEN others THEN
8969: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8970: FEM_ENGINES_PKG.TECH_MESSAGE(
8971: p_severity => FND_LOG.level_statement,
8972: p_module => C_MODULE,
8973: p_msg_text => 'Unexpected error.');

Line 8971: p_severity => FND_LOG.level_statement,

8967:
8968: WHEN others THEN
8969: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8970: FEM_ENGINES_PKG.TECH_MESSAGE(
8971: p_severity => FND_LOG.level_statement,
8972: p_module => C_MODULE,
8973: p_msg_text => 'Unexpected error.');
8974: END IF;
8975: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 8975: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

8971: p_severity => FND_LOG.level_statement,
8972: p_module => C_MODULE,
8973: p_msg_text => 'Unexpected error.');
8974: END IF;
8975: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8976: FEM_ENGINES_PKG.TECH_MESSAGE(
8977: p_severity => FND_LOG.level_procedure,
8978: p_module => C_MODULE,
8979: p_msg_text => 'End Procedure');

Line 8977: p_severity => FND_LOG.level_procedure,

8973: p_msg_text => 'Unexpected error.');
8974: END IF;
8975: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8976: FEM_ENGINES_PKG.TECH_MESSAGE(
8977: p_severity => FND_LOG.level_procedure,
8978: p_module => C_MODULE,
8979: p_msg_text => 'End Procedure');
8980: END IF;
8981: x_return_status := c_unexp;

Line 9240: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

9236: x_msg_data OUT NOCOPY VARCHAR2
9237: )
9238: IS
9239:
9240: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
9241: 'fem.plsql.fem_dimension_util_pkg.get_default_dim_member';
9242: C_API_VERSION CONSTANT NUMBER := 1.0;
9243: C_API_NAME CONSTANT VARCHAR2(30) := 'Get_Default_Dim_Member';
9244: e_no_member EXCEPTION;

Line 9258: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

9254: v_sql VARCHAR2(4000);
9255:
9256: BEGIN
9257:
9258: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9259: FEM_ENGINES_PKG.TECH_MESSAGE(
9260: p_severity => FND_LOG.level_procedure,
9261: p_module => C_MODULE,
9262: p_msg_text => 'Begin Procedure');

Line 9260: p_severity => FND_LOG.level_procedure,

9256: BEGIN
9257:
9258: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9259: FEM_ENGINES_PKG.TECH_MESSAGE(
9260: p_severity => FND_LOG.level_procedure,
9261: p_module => C_MODULE,
9262: p_msg_text => 'Begin Procedure');
9263: END IF;
9264:

Line 9274: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

9270: p_api_version,
9271: C_API_NAME,
9272: G_PKG_NAME)
9273: THEN
9274: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9275: FEM_ENGINES_PKG.TECH_MESSAGE(
9276: p_severity => FND_LOG.level_statement,
9277: p_module => C_MODULE,
9278: p_msg_text => 'API Version ('||C_API_VERSION||') not compatible with '

Line 9276: p_severity => FND_LOG.level_statement,

9272: G_PKG_NAME)
9273: THEN
9274: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9275: FEM_ENGINES_PKG.TECH_MESSAGE(
9276: p_severity => FND_LOG.level_statement,
9277: p_module => C_MODULE,
9278: p_msg_text => 'API Version ('||C_API_VERSION||') not compatible with '
9279: ||'passed in version ('||p_api_version||')');
9280: END IF;

Line 9301: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

9297: p_data => x_msg_data);
9298: RETURN;
9299: END IF;
9300:
9301: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9302: FEM_ENGINES_PKG.TECH_MESSAGE(
9303: p_severity => FND_LOG.level_statement,
9304: p_module => C_MODULE,
9305: p_msg_text => 'p_ledger_id = '||to_char(p_ledger_id));

Line 9303: p_severity => FND_LOG.level_statement,

9299: END IF;
9300:
9301: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9302: FEM_ENGINES_PKG.TECH_MESSAGE(
9303: p_severity => FND_LOG.level_statement,
9304: p_module => C_MODULE,
9305: p_msg_text => 'p_ledger_id = '||to_char(p_ledger_id));
9306: FEM_ENGINES_PKG.TECH_MESSAGE(
9307: p_severity => FND_LOG.level_statement,

Line 9307: p_severity => FND_LOG.level_statement,

9303: p_severity => FND_LOG.level_statement,
9304: p_module => C_MODULE,
9305: p_msg_text => 'p_ledger_id = '||to_char(p_ledger_id));
9306: FEM_ENGINES_PKG.TECH_MESSAGE(
9307: p_severity => FND_LOG.level_statement,
9308: p_module => C_MODULE,
9309: p_msg_text => 'p_dimension_id = '||to_char(p_dimension_id));
9310: FEM_ENGINES_PKG.TECH_MESSAGE(
9311: p_severity => FND_LOG.level_statement,

Line 9311: p_severity => FND_LOG.level_statement,

9307: p_severity => FND_LOG.level_statement,
9308: p_module => C_MODULE,
9309: p_msg_text => 'p_dimension_id = '||to_char(p_dimension_id));
9310: FEM_ENGINES_PKG.TECH_MESSAGE(
9311: p_severity => FND_LOG.level_statement,
9312: p_module => C_MODULE,
9313: p_msg_text => 'p_dimension_varchar_label = '||p_dimension_varchar_label);
9314: END IF;
9315:

Line 9318: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

9314: END IF;
9315:
9316: -- Make sure at least one dimension parameter is provided
9317: IF p_dimension_id IS NULL AND p_dimension_varchar_label IS NULL THEN
9318: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9319: FEM_ENGINES_PKG.TECH_MESSAGE(
9320: p_severity => FND_LOG.level_statement,
9321: p_module => C_MODULE,
9322: p_msg_text => 'At least one of the dimension parameters must be provided');

Line 9320: p_severity => FND_LOG.level_statement,

9316: -- Make sure at least one dimension parameter is provided
9317: IF p_dimension_id IS NULL AND p_dimension_varchar_label IS NULL THEN
9318: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9319: FEM_ENGINES_PKG.TECH_MESSAGE(
9320: p_severity => FND_LOG.level_statement,
9321: p_module => C_MODULE,
9322: p_msg_text => 'At least one of the dimension parameters must be provided');
9323: END IF;
9324: RAISE e_unexp;

Line 9353: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

9349: v_default_member_dc
9350: FROM fem_xdim_dimensions
9351: WHERE dimension_id = v_dim_id;
9352:
9353: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9354: FEM_ENGINES_PKG.TECH_MESSAGE(
9355: p_severity => FND_LOG.level_statement,
9356: p_module => C_MODULE,
9357: p_msg_text => 'XDIM Info for dim '||v_dim_id

Line 9355: p_severity => FND_LOG.level_statement,

9351: WHERE dimension_id = v_dim_id;
9352:
9353: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9354: FEM_ENGINES_PKG.TECH_MESSAGE(
9355: p_severity => FND_LOG.level_statement,
9356: p_module => C_MODULE,
9357: p_msg_text => 'XDIM Info for dim '||v_dim_id
9358: ||': v_member_table = '||v_member_table
9359: ||', v_member_col = '||v_member_col

Line 9366: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

9362: ||', v_default_member_dc = '||v_default_member_dc);
9363: END IF;
9364:
9365: EXCEPTION WHEN no_data_found THEN
9366: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9367: FEM_ENGINES_PKG.TECH_MESSAGE(
9368: p_severity => FND_LOG.level_statement,
9369: p_module => C_MODULE,
9370: p_msg_text => 'Dimension is not registered in FEM_DIMENSIONS_B or FEM_XDIM_DIMENSIONS');

Line 9368: p_severity => FND_LOG.level_statement,

9364:
9365: EXCEPTION WHEN no_data_found THEN
9366: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9367: FEM_ENGINES_PKG.TECH_MESSAGE(
9368: p_severity => FND_LOG.level_statement,
9369: p_module => C_MODULE,
9370: p_msg_text => 'Dimension is not registered in FEM_DIMENSIONS_B or FEM_XDIM_DIMENSIONS');
9371: END IF;
9372: RAISE e_unexp;

Line 9391: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

9387: x_msg_count => x_msg_count,
9388: x_msg_data => x_msg_data);
9389:
9390: IF x_return_status <> c_success THEN
9391: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9392: FEM_ENGINES_PKG.TECH_MESSAGE(
9393: p_severity => FND_LOG.level_statement,
9394: p_module => C_MODULE,
9395: p_msg_text => 'Call to Dimension_Value_Set_ID failed');

Line 9393: p_severity => FND_LOG.level_statement,

9389:
9390: IF x_return_status <> c_success THEN
9391: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9392: FEM_ENGINES_PKG.TECH_MESSAGE(
9393: p_severity => FND_LOG.level_statement,
9394: p_module => C_MODULE,
9395: p_msg_text => 'Call to Dimension_Value_Set_ID failed');
9396: END IF;
9397: raise e_unexp;

Line 9420: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

9416: EXECUTE IMMEDIATE v_sql
9417: INTO v_default_member_dc
9418: USING v_default_member, v_vs_id;
9419: EXCEPTION WHEN no_data_found THEN
9420: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9421: FEM_ENGINES_PKG.TECH_MESSAGE(
9422: p_severity => FND_LOG.level_statement,
9423: p_module => C_MODULE,
9424: p_msg_text => 'Following SQL failed to return rows: '||v_sql);

Line 9422: p_severity => FND_LOG.level_statement,

9418: USING v_default_member, v_vs_id;
9419: EXCEPTION WHEN no_data_found THEN
9420: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9421: FEM_ENGINES_PKG.TECH_MESSAGE(
9422: p_severity => FND_LOG.level_statement,
9423: p_module => C_MODULE,
9424: p_msg_text => 'Following SQL failed to return rows: '||v_sql);
9425: FEM_ENGINES_PKG.TECH_MESSAGE(
9426: p_severity => FND_LOG.level_statement,

Line 9426: p_severity => FND_LOG.level_statement,

9422: p_severity => FND_LOG.level_statement,
9423: p_module => C_MODULE,
9424: p_msg_text => 'Following SQL failed to return rows: '||v_sql);
9425: FEM_ENGINES_PKG.TECH_MESSAGE(
9426: p_severity => FND_LOG.level_statement,
9427: p_module => C_MODULE,
9428: p_msg_text => 'Cannot find the dimension member (ID) = '||to_char(v_default_member)
9429: ||' in '||v_member_table||' where vaset set ID = '||to_char(v_vs_id));
9430: END IF;

Line 9435: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

9431: RAISE e_no_member;
9432: END;
9433: END IF; -- v_default_member IS NOT NULL
9434: EXCEPTION WHEN no_data_found THEN
9435: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9436: FEM_ENGINES_PKG.TECH_MESSAGE(
9437: p_severity => FND_LOG.level_statement,
9438: p_module => C_MODULE,
9439: p_msg_text => 'Cannot find value set ID = '||to_char(v_vs_id));

Line 9437: p_severity => FND_LOG.level_statement,

9433: END IF; -- v_default_member IS NOT NULL
9434: EXCEPTION WHEN no_data_found THEN
9435: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9436: FEM_ENGINES_PKG.TECH_MESSAGE(
9437: p_severity => FND_LOG.level_statement,
9438: p_module => C_MODULE,
9439: p_msg_text => 'Cannot find value set ID = '||to_char(v_vs_id));
9440: END IF;
9441: RAISE e_unexp;

Line 9455: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

9451: EXECUTE IMMEDIATE v_sql
9452: INTO v_default_member
9453: USING v_default_member_dc;
9454: EXCEPTION WHEN no_data_found THEN
9455: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9456: FEM_ENGINES_PKG.TECH_MESSAGE(
9457: p_severity => FND_LOG.level_statement,
9458: p_module => C_MODULE,
9459: p_msg_text => 'Following SQL failed to return rows: '||v_sql);

Line 9457: p_severity => FND_LOG.level_statement,

9453: USING v_default_member_dc;
9454: EXCEPTION WHEN no_data_found THEN
9455: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9456: FEM_ENGINES_PKG.TECH_MESSAGE(
9457: p_severity => FND_LOG.level_statement,
9458: p_module => C_MODULE,
9459: p_msg_text => 'Following SQL failed to return rows: '||v_sql);
9460: FEM_ENGINES_PKG.TECH_MESSAGE(
9461: p_severity => FND_LOG.level_statement,

Line 9461: p_severity => FND_LOG.level_statement,

9457: p_severity => FND_LOG.level_statement,
9458: p_module => C_MODULE,
9459: p_msg_text => 'Following SQL failed to return rows: '||v_sql);
9460: FEM_ENGINES_PKG.TECH_MESSAGE(
9461: p_severity => FND_LOG.level_statement,
9462: p_module => C_MODULE,
9463: p_msg_text => 'Cannot find the dimension member (display code) '
9464: ||v_default_member_dc||' in '||v_member_table);
9465: END IF;

Line 9481: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

9477: ELSE
9478: x_return_status := c_success;
9479: END IF;
9480:
9481: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9482: FEM_ENGINES_PKG.TECH_MESSAGE(
9483: p_severity => FND_LOG.level_statement,
9484: p_module => C_MODULE,
9485: p_msg_text => 'x_member_code = '||x_member_code);

Line 9483: p_severity => FND_LOG.level_statement,

9479: END IF;
9480:
9481: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9482: FEM_ENGINES_PKG.TECH_MESSAGE(
9483: p_severity => FND_LOG.level_statement,
9484: p_module => C_MODULE,
9485: p_msg_text => 'x_member_code = '||x_member_code);
9486: FEM_ENGINES_PKG.TECH_MESSAGE(
9487: p_severity => FND_LOG.level_statement,

Line 9487: p_severity => FND_LOG.level_statement,

9483: p_severity => FND_LOG.level_statement,
9484: p_module => C_MODULE,
9485: p_msg_text => 'x_member_code = '||x_member_code);
9486: FEM_ENGINES_PKG.TECH_MESSAGE(
9487: p_severity => FND_LOG.level_statement,
9488: p_module => C_MODULE,
9489: p_msg_text => 'x_member_data_type = '||x_member_data_type);
9490: FEM_ENGINES_PKG.TECH_MESSAGE(
9491: p_severity => FND_LOG.level_statement,

Line 9491: p_severity => FND_LOG.level_statement,

9487: p_severity => FND_LOG.level_statement,
9488: p_module => C_MODULE,
9489: p_msg_text => 'x_member_data_type = '||x_member_data_type);
9490: FEM_ENGINES_PKG.TECH_MESSAGE(
9491: p_severity => FND_LOG.level_statement,
9492: p_module => C_MODULE,
9493: p_msg_text => 'x_member_display_code = '||x_member_display_code);
9494: FEM_ENGINES_PKG.TECH_MESSAGE(
9495: p_severity => FND_LOG.level_statement,

Line 9495: p_severity => FND_LOG.level_statement,

9491: p_severity => FND_LOG.level_statement,
9492: p_module => C_MODULE,
9493: p_msg_text => 'x_member_display_code = '||x_member_display_code);
9494: FEM_ENGINES_PKG.TECH_MESSAGE(
9495: p_severity => FND_LOG.level_statement,
9496: p_module => C_MODULE,
9497: p_msg_text => 'x_return_status = '||x_return_status);
9498: END IF;
9499: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 9499: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

9495: p_severity => FND_LOG.level_statement,
9496: p_module => C_MODULE,
9497: p_msg_text => 'x_return_status = '||x_return_status);
9498: END IF;
9499: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9500: FEM_ENGINES_PKG.TECH_MESSAGE(
9501: p_severity => FND_LOG.level_procedure,
9502: p_module => C_MODULE,
9503: p_msg_text => 'End Procedure');

Line 9501: p_severity => FND_LOG.level_procedure,

9497: p_msg_text => 'x_return_status = '||x_return_status);
9498: END IF;
9499: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9500: FEM_ENGINES_PKG.TECH_MESSAGE(
9501: p_severity => FND_LOG.level_procedure,
9502: p_module => C_MODULE,
9503: p_msg_text => 'End Procedure');
9504: END IF;
9505:

Line 9508: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

9504: END IF;
9505:
9506: EXCEPTION
9507: WHEN e_no_member THEN
9508: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9509: FEM_ENGINES_PKG.TECH_MESSAGE(
9510: p_severity => FND_LOG.level_procedure,
9511: p_module => C_MODULE,
9512: p_msg_text => 'End Procedure');

Line 9510: p_severity => FND_LOG.level_procedure,

9506: EXCEPTION
9507: WHEN e_no_member THEN
9508: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9509: FEM_ENGINES_PKG.TECH_MESSAGE(
9510: p_severity => FND_LOG.level_procedure,
9511: p_module => C_MODULE,
9512: p_msg_text => 'End Procedure');
9513: END IF;
9514: x_member_code := NULL;

Line 9519: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

9515: x_member_data_type := NULL;
9516: x_member_display_code := NULL;
9517: x_return_status := c_error;
9518: WHEN others THEN
9519: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9520: FEM_ENGINES_PKG.TECH_MESSAGE(
9521: p_severity => FND_LOG.level_statement,
9522: p_module => C_MODULE,
9523: p_msg_text => 'Unexpected error.');

Line 9521: p_severity => FND_LOG.level_statement,

9517: x_return_status := c_error;
9518: WHEN others THEN
9519: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9520: FEM_ENGINES_PKG.TECH_MESSAGE(
9521: p_severity => FND_LOG.level_statement,
9522: p_module => C_MODULE,
9523: p_msg_text => 'Unexpected error.');
9524: END IF;
9525: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 9525: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

9521: p_severity => FND_LOG.level_statement,
9522: p_module => C_MODULE,
9523: p_msg_text => 'Unexpected error.');
9524: END IF;
9525: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9526: FEM_ENGINES_PKG.TECH_MESSAGE(
9527: p_severity => FND_LOG.level_procedure,
9528: p_module => C_MODULE,
9529: p_msg_text => 'End Procedure');

Line 9527: p_severity => FND_LOG.level_procedure,

9523: p_msg_text => 'Unexpected error.');
9524: END IF;
9525: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9526: FEM_ENGINES_PKG.TECH_MESSAGE(
9527: p_severity => FND_LOG.level_procedure,
9528: p_module => C_MODULE,
9529: p_msg_text => 'End Procedure');
9530: END IF;
9531: x_return_status := c_unexp;

Line 9579: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

9575: x_msg_data OUT NOCOPY VARCHAR2
9576: )
9577: IS
9578:
9579: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
9580: 'fem.plsql.fem_dimension_util_pkg.get_default_dim_member.table';
9581: C_API_VERSION CONSTANT NUMBER := 1.0;
9582: C_API_NAME CONSTANT VARCHAR2(30) := 'Get_Default_Dim_Member';
9583:

Line 9588: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

9584: v_dim_id FEM_DIMENSIONS_B.dimension_id%TYPE;
9585:
9586: BEGIN
9587:
9588: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9589: FEM_ENGINES_PKG.TECH_MESSAGE(
9590: p_severity => FND_LOG.level_procedure,
9591: p_module => C_MODULE,
9592: p_msg_text => 'Begin Procedure');

Line 9590: p_severity => FND_LOG.level_procedure,

9586: BEGIN
9587:
9588: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9589: FEM_ENGINES_PKG.TECH_MESSAGE(
9590: p_severity => FND_LOG.level_procedure,
9591: p_module => C_MODULE,
9592: p_msg_text => 'Begin Procedure');
9593: END IF;
9594:

Line 9604: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

9600: p_api_version,
9601: C_API_NAME,
9602: G_PKG_NAME)
9603: THEN
9604: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9605: FEM_ENGINES_PKG.TECH_MESSAGE(
9606: p_severity => FND_LOG.level_statement,
9607: p_module => C_MODULE,
9608: p_msg_text => 'API Version ('||C_API_VERSION||') not compatible with '

Line 9606: p_severity => FND_LOG.level_statement,

9602: G_PKG_NAME)
9603: THEN
9604: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9605: FEM_ENGINES_PKG.TECH_MESSAGE(
9606: p_severity => FND_LOG.level_statement,
9607: p_module => C_MODULE,
9608: p_msg_text => 'API Version ('||C_API_VERSION||') not compatible with '
9609: ||'passed in version ('||p_api_version||')');
9610: END IF;

Line 9631: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

9627: p_data => x_msg_data);
9628: RETURN;
9629: END IF;
9630:
9631: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9632: FEM_ENGINES_PKG.TECH_MESSAGE(
9633: p_severity => FND_LOG.level_statement,
9634: p_module => C_MODULE,
9635: p_msg_text => 'p_ledger_id = '||to_char(p_ledger_id));

Line 9633: p_severity => FND_LOG.level_statement,

9629: END IF;
9630:
9631: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9632: FEM_ENGINES_PKG.TECH_MESSAGE(
9633: p_severity => FND_LOG.level_statement,
9634: p_module => C_MODULE,
9635: p_msg_text => 'p_ledger_id = '||to_char(p_ledger_id));
9636: FEM_ENGINES_PKG.TECH_MESSAGE(
9637: p_severity => FND_LOG.level_statement,

Line 9637: p_severity => FND_LOG.level_statement,

9633: p_severity => FND_LOG.level_statement,
9634: p_module => C_MODULE,
9635: p_msg_text => 'p_ledger_id = '||to_char(p_ledger_id));
9636: FEM_ENGINES_PKG.TECH_MESSAGE(
9637: p_severity => FND_LOG.level_statement,
9638: p_module => C_MODULE,
9639: p_msg_text => 'p_table_name = '||p_table_name);
9640: FEM_ENGINES_PKG.TECH_MESSAGE(
9641: p_severity => FND_LOG.level_statement,

Line 9641: p_severity => FND_LOG.level_statement,

9637: p_severity => FND_LOG.level_statement,
9638: p_module => C_MODULE,
9639: p_msg_text => 'p_table_name = '||p_table_name);
9640: FEM_ENGINES_PKG.TECH_MESSAGE(
9641: p_severity => FND_LOG.level_statement,
9642: p_module => C_MODULE,
9643: p_msg_text => 'p_column_name = '||p_column_name);
9644: END IF;
9645:

Line 9655: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

9651: WHERE table_name = Upper(p_table_name)
9652: AND column_name = Upper(p_column_name);
9653:
9654: IF v_dim_id IS NULL THEN
9655: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9656: FEM_ENGINES_PKG.TECH_MESSAGE(
9657: p_severity => FND_LOG.level_statement,
9658: p_module => C_MODULE,
9659: p_msg_text => 'Column does not point to a dimension');

Line 9657: p_severity => FND_LOG.level_statement,

9653:
9654: IF v_dim_id IS NULL THEN
9655: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9656: FEM_ENGINES_PKG.TECH_MESSAGE(
9657: p_severity => FND_LOG.level_statement,
9658: p_module => C_MODULE,
9659: p_msg_text => 'Column does not point to a dimension');
9660: END IF;
9661: RAISE e_unexp;

Line 9665: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

9661: RAISE e_unexp;
9662: END IF;
9663:
9664: EXCEPTION WHEN no_data_found THEN
9665: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9666: FEM_ENGINES_PKG.TECH_MESSAGE(
9667: p_severity => FND_LOG.level_statement,
9668: p_module => C_MODULE,
9669: p_msg_text => 'Column is not registered in FEM_TAB_COLUMNS_B');

Line 9667: p_severity => FND_LOG.level_statement,

9663:
9664: EXCEPTION WHEN no_data_found THEN
9665: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9666: FEM_ENGINES_PKG.TECH_MESSAGE(
9667: p_severity => FND_LOG.level_statement,
9668: p_module => C_MODULE,
9669: p_msg_text => 'Column is not registered in FEM_TAB_COLUMNS_B');
9670: END IF;
9671: RAISE e_unexp;

Line 9690: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

9686: x_member_code => x_member_code,
9687: x_member_data_type => x_member_data_type,
9688: x_member_display_code => x_member_display_code);
9689:
9690: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9691: FEM_ENGINES_PKG.TECH_MESSAGE(
9692: p_severity => FND_LOG.level_procedure,
9693: p_module => C_MODULE,
9694: p_msg_text => 'End Procedure');

Line 9692: p_severity => FND_LOG.level_procedure,

9688: x_member_display_code => x_member_display_code);
9689:
9690: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9691: FEM_ENGINES_PKG.TECH_MESSAGE(
9692: p_severity => FND_LOG.level_procedure,
9693: p_module => C_MODULE,
9694: p_msg_text => 'End Procedure');
9695: END IF;
9696:

Line 9699: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

9695: END IF;
9696:
9697: EXCEPTION
9698: WHEN others THEN
9699: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9700: FEM_ENGINES_PKG.TECH_MESSAGE(
9701: p_severity => FND_LOG.level_statement,
9702: p_module => C_MODULE,
9703: p_msg_text => 'Unexpected error.');

Line 9701: p_severity => FND_LOG.level_statement,

9697: EXCEPTION
9698: WHEN others THEN
9699: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9700: FEM_ENGINES_PKG.TECH_MESSAGE(
9701: p_severity => FND_LOG.level_statement,
9702: p_module => C_MODULE,
9703: p_msg_text => 'Unexpected error.');
9704: END IF;
9705: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 9705: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

9701: p_severity => FND_LOG.level_statement,
9702: p_module => C_MODULE,
9703: p_msg_text => 'Unexpected error.');
9704: END IF;
9705: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9706: FEM_ENGINES_PKG.TECH_MESSAGE(
9707: p_severity => FND_LOG.level_procedure,
9708: p_module => C_MODULE,
9709: p_msg_text => 'End Procedure');

Line 9707: p_severity => FND_LOG.level_procedure,

9703: p_msg_text => 'Unexpected error.');
9704: END IF;
9705: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
9706: FEM_ENGINES_PKG.TECH_MESSAGE(
9707: p_severity => FND_LOG.level_procedure,
9708: p_module => C_MODULE,
9709: p_msg_text => 'End Procedure');
9710: END IF;
9711: x_return_status := c_unexp;