DBA Data[Home] [Help]

APPS.MSD_COLLECT_FACT_DATA dependencies on MSD_CONC_LOG_UTIL

Line 1140: msd_conc_log_util.display_message('No order types found in the source', msd_conc_log_util.C_ERROR);

1136: l_order_type_table;
1137:
1138: IF l_order_type_table.COUNT = 0 THEN
1139: p_retcode := -1;
1140: msd_conc_log_util.display_message('No order types found in the source', msd_conc_log_util.C_ERROR);
1141: return -1;
1142: END IF;
1143:
1144: IF p_collect_all_order_types = SYS_NO THEN

Line 1149: msd_conc_log_util.display_message('Both the parameters include order types and exclude order types are null', msd_conc_log_util.C_ERROR);

1145:
1146: IF p_include_order_types is null AND
1147: p_exclude_order_types is null THEN
1148: p_retcode := -1;
1149: msd_conc_log_util.display_message('Both the parameters include order types and exclude order types are null', msd_conc_log_util.C_ERROR);
1150: return -1;
1151: ELSIF p_include_order_types is not null AND
1152: p_exclude_order_types is not null THEN
1153: p_retcode := -1;

Line 1154: msd_conc_log_util.display_message('Both the parameters include order types and exclude order types are not null', msd_conc_log_util.C_ERROR);

1150: return -1;
1151: ELSIF p_include_order_types is not null AND
1152: p_exclude_order_types is not null THEN
1153: p_retcode := -1;
1154: msd_conc_log_util.display_message('Both the parameters include order types and exclude order types are not null', msd_conc_log_util.C_ERROR);
1155: return -1;
1156: ELSIF p_include_order_types is not null THEN
1157: l_order_type_flag := C_INCLUDE;
1158: l_order_types := UPPER(p_include_order_types);

Line 1229: msd_conc_log_util.display_message('Demand Plan Order Types', msd_conc_log_util.C_SECTION);

1225: EXIT WHEN l_position = 0;
1226: l_start := l_position + 1;
1227: END LOOP;
1228:
1229: msd_conc_log_util.display_message('Demand Plan Order Types', msd_conc_log_util.C_SECTION);
1230: msd_conc_log_util.display_message(' ', msd_conc_log_util.C_HEADING);
1231:
1232: msd_conc_log_util.display_message('Valid Order Types', msd_conc_log_util.C_HEADING);
1233: msd_conc_log_util.display_message('------------------------------------------------', msd_conc_log_util.C_HEADING);

Line 1230: msd_conc_log_util.display_message(' ', msd_conc_log_util.C_HEADING);

1226: l_start := l_position + 1;
1227: END LOOP;
1228:
1229: msd_conc_log_util.display_message('Demand Plan Order Types', msd_conc_log_util.C_SECTION);
1230: msd_conc_log_util.display_message(' ', msd_conc_log_util.C_HEADING);
1231:
1232: msd_conc_log_util.display_message('Valid Order Types', msd_conc_log_util.C_HEADING);
1233: msd_conc_log_util.display_message('------------------------------------------------', msd_conc_log_util.C_HEADING);
1234:

Line 1232: msd_conc_log_util.display_message('Valid Order Types', msd_conc_log_util.C_HEADING);

1228:
1229: msd_conc_log_util.display_message('Demand Plan Order Types', msd_conc_log_util.C_SECTION);
1230: msd_conc_log_util.display_message(' ', msd_conc_log_util.C_HEADING);
1231:
1232: msd_conc_log_util.display_message('Valid Order Types', msd_conc_log_util.C_HEADING);
1233: msd_conc_log_util.display_message('------------------------------------------------', msd_conc_log_util.C_HEADING);
1234:
1235: IF l_valid_count <> 0 THEN
1236: FOR i in l_valid_order_type_table.FIRST..l_valid_order_type_table.LAST

Line 1233: msd_conc_log_util.display_message('------------------------------------------------', msd_conc_log_util.C_HEADING);

1229: msd_conc_log_util.display_message('Demand Plan Order Types', msd_conc_log_util.C_SECTION);
1230: msd_conc_log_util.display_message(' ', msd_conc_log_util.C_HEADING);
1231:
1232: msd_conc_log_util.display_message('Valid Order Types', msd_conc_log_util.C_HEADING);
1233: msd_conc_log_util.display_message('------------------------------------------------', msd_conc_log_util.C_HEADING);
1234:
1235: IF l_valid_count <> 0 THEN
1236: FOR i in l_valid_order_type_table.FIRST..l_valid_order_type_table.LAST
1237: LOOP

Line 1238: msd_conc_log_util.display_message(to_char(i) || ') ' || l_valid_order_type_table(i), msd_conc_log_util.C_INFORMATION);

1234:
1235: IF l_valid_count <> 0 THEN
1236: FOR i in l_valid_order_type_table.FIRST..l_valid_order_type_table.LAST
1237: LOOP
1238: msd_conc_log_util.display_message(to_char(i) || ') ' || l_valid_order_type_table(i), msd_conc_log_util.C_INFORMATION);
1239: END LOOP;
1240: ELSE
1241: p_retcode := -1;
1242: msd_conc_log_util.display_message('No valid order types found in user input', msd_conc_log_util.C_ERROR);

Line 1242: msd_conc_log_util.display_message('No valid order types found in user input', msd_conc_log_util.C_ERROR);

1238: msd_conc_log_util.display_message(to_char(i) || ') ' || l_valid_order_type_table(i), msd_conc_log_util.C_INFORMATION);
1239: END LOOP;
1240: ELSE
1241: p_retcode := -1;
1242: msd_conc_log_util.display_message('No valid order types found in user input', msd_conc_log_util.C_ERROR);
1243: END IF;
1244:
1245: msd_conc_log_util.display_message(' ', msd_conc_log_util.C_HEADING);
1246: msd_conc_log_util.display_message('Invalid Order Types', msd_conc_log_util.C_HEADING);

Line 1245: msd_conc_log_util.display_message(' ', msd_conc_log_util.C_HEADING);

1241: p_retcode := -1;
1242: msd_conc_log_util.display_message('No valid order types found in user input', msd_conc_log_util.C_ERROR);
1243: END IF;
1244:
1245: msd_conc_log_util.display_message(' ', msd_conc_log_util.C_HEADING);
1246: msd_conc_log_util.display_message('Invalid Order Types', msd_conc_log_util.C_HEADING);
1247: msd_conc_log_util.display_message('------------------------------------------------', msd_conc_log_util.C_HEADING);
1248:
1249: IF l_invalid_count <> 0 THEN

Line 1246: msd_conc_log_util.display_message('Invalid Order Types', msd_conc_log_util.C_HEADING);

1242: msd_conc_log_util.display_message('No valid order types found in user input', msd_conc_log_util.C_ERROR);
1243: END IF;
1244:
1245: msd_conc_log_util.display_message(' ', msd_conc_log_util.C_HEADING);
1246: msd_conc_log_util.display_message('Invalid Order Types', msd_conc_log_util.C_HEADING);
1247: msd_conc_log_util.display_message('------------------------------------------------', msd_conc_log_util.C_HEADING);
1248:
1249: IF l_invalid_count <> 0 THEN
1250: FOR i in l_invalid_order_type_table.FIRST..l_invalid_order_type_table.LAST

Line 1247: msd_conc_log_util.display_message('------------------------------------------------', msd_conc_log_util.C_HEADING);

1243: END IF;
1244:
1245: msd_conc_log_util.display_message(' ', msd_conc_log_util.C_HEADING);
1246: msd_conc_log_util.display_message('Invalid Order Types', msd_conc_log_util.C_HEADING);
1247: msd_conc_log_util.display_message('------------------------------------------------', msd_conc_log_util.C_HEADING);
1248:
1249: IF l_invalid_count <> 0 THEN
1250: FOR i in l_invalid_order_type_table.FIRST..l_invalid_order_type_table.LAST
1251: LOOP

Line 1252: msd_conc_log_util.display_message(to_char(i) || ') ' || l_invalid_order_type_table(i), msd_conc_log_util.C_WARNING);

1248:
1249: IF l_invalid_count <> 0 THEN
1250: FOR i in l_invalid_order_type_table.FIRST..l_invalid_order_type_table.LAST
1251: LOOP
1252: msd_conc_log_util.display_message(to_char(i) || ') ' || l_invalid_order_type_table(i), msd_conc_log_util.C_WARNING);
1253: END LOOP;
1254: END IF;
1255: msd_conc_log_util.display_message(' ', msd_conc_log_util.C_HEADING);
1256:

Line 1255: msd_conc_log_util.display_message(' ', msd_conc_log_util.C_HEADING);

1251: LOOP
1252: msd_conc_log_util.display_message(to_char(i) || ') ' || l_invalid_order_type_table(i), msd_conc_log_util.C_WARNING);
1253: END LOOP;
1254: END IF;
1255: msd_conc_log_util.display_message(' ', msd_conc_log_util.C_HEADING);
1256:
1257: IF l_valid_count = 0 THEN
1258: return -1;
1259: END IF;

Line 1267: msd_conc_log_util.display_message('Parameter(s) include/exclude order types not null when collect all order types is YES', msd_conc_log_util.C_ERROR);

1263: IF p_include_order_types is not null OR
1264: p_exclude_order_types is not null THEN
1265:
1266: p_retcode := -1;
1267: msd_conc_log_util.display_message('Parameter(s) include/exclude order types not null when collect all order types is YES', msd_conc_log_util.C_ERROR);
1268: return -1;
1269:
1270: ELSE
1271: