179: printlog(' ');
180: printlog(' ');
181: printLog(rpad('*',80,'*'));
182: printlog(' ');
183: fnd_message.set_name('IBE','IBE_BI_INVALID_ORG_MSITE_ERR');
184: l_temp_msg := fnd_message.get;
185:
186: printLog(l_temp_msg);
187: printlog(' ');
180: printlog(' ');
181: printLog(rpad('*',80,'*'));
182: printlog(' ');
183: fnd_message.set_name('IBE','IBE_BI_INVALID_ORG_MSITE_ERR');
184: l_temp_msg := fnd_message.get;
185:
186: printLog(l_temp_msg);
187: printlog(' ');
188: printLog(rpad('*',80,'*'));
289: printlog(' ');
290: printlog(' ');
291: printLog(rpad('*',80,'*'));
292: printlog(' ');
293: fnd_message.set_name('IBE','IBE_BI_OPR_NOT_VALID');
294: l_temp_msg := fnd_message.get;
295:
296: FOR q in v_mapping_tab.first ..v_mapping_tab.last LOOP
297:
290: printlog(' ');
291: printLog(rpad('*',80,'*'));
292: printlog(' ');
293: fnd_message.set_name('IBE','IBE_BI_OPR_NOT_VALID');
294: l_temp_msg := fnd_message.get;
295:
296: FOR q in v_mapping_tab.first ..v_mapping_tab.last LOOP
297:
298: IF v_mapping_tab.EXISTS(q) AND v_mapping_tab(q).is_valid_org = 'N' THEN
305: END IF;
306: END LOOP;
307:
308:
309: fnd_message.set_name('IBE','IBE_BI_STR_NOT_VALID');
310: l_temp_msg := fnd_message.get;
311:
312: FOR r in v_mapping_tab.first ..v_mapping_tab.last LOOP
313:
306: END LOOP;
307:
308:
309: fnd_message.set_name('IBE','IBE_BI_STR_NOT_VALID');
310: l_temp_msg := fnd_message.get;
311:
312: FOR r in v_mapping_tab.first ..v_mapping_tab.last LOOP
313:
314: IF v_mapping_tab.EXISTS(r) AND v_mapping_tab(r).is_valid_str = 'N' THEN
320:
321: END IF;
322: END LOOP;
323:
324: fnd_message.set_name('IBE','IBE_BI_OPR_DUPLICATE');
325:
326:
327: FOR s in v_mapping_tab.first ..v_mapping_tab.last LOOP
328:
326:
327: FOR s in v_mapping_tab.first ..v_mapping_tab.last LOOP
328:
329: IF v_mapping_tab.EXISTS(s) AND v_mapping_tab(s).is_duplicate_org = 'Y' THEN
330: fnd_message.set_token('1',v_mapping_tab(s).org_id);
331: l_temp_msg := fnd_message.get;
332: printlog(l_temp_msg);
333: printlog(v_mapping_tab(s).org_id || ':' ||v_mapping_tab(s).minisite_id);
334: END IF;
327: FOR s in v_mapping_tab.first ..v_mapping_tab.last LOOP
328:
329: IF v_mapping_tab.EXISTS(s) AND v_mapping_tab(s).is_duplicate_org = 'Y' THEN
330: fnd_message.set_token('1',v_mapping_tab(s).org_id);
331: l_temp_msg := fnd_message.get;
332: printlog(l_temp_msg);
333: printlog(v_mapping_tab(s).org_id || ':' ||v_mapping_tab(s).minisite_id);
334: END IF;
335: END LOOP;
347:
348: EXCEPTION
349:
350: WHEN invalid_str_org_input THEN
351: fnd_message.set_name('IBE','IBE_BI_INVALID_ORG_MSITE_ERR');
352: l_temp_msg := fnd_message.get;
353: printLog(l_temp_msg);
354: printlog(' ');
355: printLog(rpad('*',80,'*'));
348: EXCEPTION
349:
350: WHEN invalid_str_org_input THEN
351: fnd_message.set_name('IBE','IBE_BI_INVALID_ORG_MSITE_ERR');
352: l_temp_msg := fnd_message.get;
353: printLog(l_temp_msg);
354: printlog(' ');
355: printLog(rpad('*',80,'*'));
356: printlog(' ');
1048: AND run_sequence = 0;
1049:
1050:
1051:
1052: fnd_message.set_name('IBE','IBE_BI_MIGRATION_REPORT');
1053: l_temp_msg := fnd_message.get;
1054: printOutput(l_temp_msg);
1055: printOutput(rpad('=',80,'='));
1056: printOutput(' ');
1049:
1050:
1051:
1052: fnd_message.set_name('IBE','IBE_BI_MIGRATION_REPORT');
1053: l_temp_msg := fnd_message.get;
1054: printOutput(l_temp_msg);
1055: printOutput(rpad('=',80,'='));
1056: printOutput(' ');
1057: fnd_message.set_name('IBE','IBE_BI_CONC_PROG_PARAMETERS');
1053: l_temp_msg := fnd_message.get;
1054: printOutput(l_temp_msg);
1055: printOutput(rpad('=',80,'='));
1056: printOutput(' ');
1057: fnd_message.set_name('IBE','IBE_BI_CONC_PROG_PARAMETERS');
1058: l_temp_msg := fnd_message.get;
1059: printOutput(l_temp_msg);
1060: printOutput(rpad('-',60,'-'));
1061: printOutput(' ');
1054: printOutput(l_temp_msg);
1055: printOutput(rpad('=',80,'='));
1056: printOutput(' ');
1057: fnd_message.set_name('IBE','IBE_BI_CONC_PROG_PARAMETERS');
1058: l_temp_msg := fnd_message.get;
1059: printOutput(l_temp_msg);
1060: printOutput(rpad('-',60,'-'));
1061: printOutput(' ');
1062:
1059: printOutput(l_temp_msg);
1060: printOutput(rpad('-',60,'-'));
1061: printOutput(' ');
1062:
1063: fnd_message.set_name('IBE','IBE_BI_REPORT_PARAMETERS');
1064: l_temp_msg := fnd_message.get;
1065: fnd_message.set_name('IBE','IBE_BI_REPORT_PARAMETER_VALS');
1066: l_temp_msg1 := fnd_message.get;
1067: printOutput(RPAD(l_temp_msg ,45)|| ' ' || l_temp_msg1);
1060: printOutput(rpad('-',60,'-'));
1061: printOutput(' ');
1062:
1063: fnd_message.set_name('IBE','IBE_BI_REPORT_PARAMETERS');
1064: l_temp_msg := fnd_message.get;
1065: fnd_message.set_name('IBE','IBE_BI_REPORT_PARAMETER_VALS');
1066: l_temp_msg1 := fnd_message.get;
1067: printOutput(RPAD(l_temp_msg ,45)|| ' ' || l_temp_msg1);
1068: printOutput(RPAD('-',45,'-')|| ' ' || lPAD('-',14,'-'));
1061: printOutput(' ');
1062:
1063: fnd_message.set_name('IBE','IBE_BI_REPORT_PARAMETERS');
1064: l_temp_msg := fnd_message.get;
1065: fnd_message.set_name('IBE','IBE_BI_REPORT_PARAMETER_VALS');
1066: l_temp_msg1 := fnd_message.get;
1067: printOutput(RPAD(l_temp_msg ,45)|| ' ' || l_temp_msg1);
1068: printOutput(RPAD('-',45,'-')|| ' ' || lPAD('-',14,'-'));
1069:
1062:
1063: fnd_message.set_name('IBE','IBE_BI_REPORT_PARAMETERS');
1064: l_temp_msg := fnd_message.get;
1065: fnd_message.set_name('IBE','IBE_BI_REPORT_PARAMETER_VALS');
1066: l_temp_msg1 := fnd_message.get;
1067: printOutput(RPAD(l_temp_msg ,45)|| ' ' || l_temp_msg1);
1068: printOutput(RPAD('-',45,'-')|| ' ' || lPAD('-',14,'-'));
1069:
1070: fnd_message.set_name('IBE','IBE_BI_RUNNING_MODE');
1066: l_temp_msg1 := fnd_message.get;
1067: printOutput(RPAD(l_temp_msg ,45)|| ' ' || l_temp_msg1);
1068: printOutput(RPAD('-',45,'-')|| ' ' || lPAD('-',14,'-'));
1069:
1070: fnd_message.set_name('IBE','IBE_BI_RUNNING_MODE');
1071: l_temp_msg := fnd_message.get;
1072: for rec_mode_lookup in c_lookup('IBE_BI_MIG_MODE',p_running_mode) loop
1073: l_temp_mode := rec_mode_lookup.meaning;
1074: end loop;
1067: printOutput(RPAD(l_temp_msg ,45)|| ' ' || l_temp_msg1);
1068: printOutput(RPAD('-',45,'-')|| ' ' || lPAD('-',14,'-'));
1069:
1070: fnd_message.set_name('IBE','IBE_BI_RUNNING_MODE');
1071: l_temp_msg := fnd_message.get;
1072: for rec_mode_lookup in c_lookup('IBE_BI_MIG_MODE',p_running_mode) loop
1073: l_temp_mode := rec_mode_lookup.meaning;
1074: end loop;
1075: printOutput( RPAD(l_temp_msg,45,' ') || ' ' || l_temp_mode);
1073: l_temp_mode := rec_mode_lookup.meaning;
1074: end loop;
1075: printOutput( RPAD(l_temp_msg,45,' ') || ' ' || l_temp_mode);
1076:
1077: fnd_message.set_name('IBE','IBE_BI_USE_MIG_RULES');
1078: l_temp_msg := fnd_message.get;
1079: for rec_rule_lookup in c_lookup('IBE_BI_MIG_RULE',p_auto_defaulting_flag) loop
1080: l_temp_rule := rec_rule_lookup.meaning;
1081: end loop;
1074: end loop;
1075: printOutput( RPAD(l_temp_msg,45,' ') || ' ' || l_temp_mode);
1076:
1077: fnd_message.set_name('IBE','IBE_BI_USE_MIG_RULES');
1078: l_temp_msg := fnd_message.get;
1079: for rec_rule_lookup in c_lookup('IBE_BI_MIG_RULE',p_auto_defaulting_flag) loop
1080: l_temp_rule := rec_rule_lookup.meaning;
1081: end loop;
1082: printOutput( RPAD(l_temp_msg,45,' ') || ' ' || l_temp_rule);
1081: end loop;
1082: printOutput( RPAD(l_temp_msg,45,' ') || ' ' || l_temp_rule);
1083:
1084: if p_override_minisite_flag = 'Y' then
1085: fnd_message.set_name('IBE','IBE_BI_UPD_CARTS_WITH_STORE_ID');
1086: l_temp_msg := fnd_message.get;
1087: for rec_yesno_lookup in c_lookup('YES_NO',p_override_minisite_flag) loop
1088: l_temp_yesno := rec_yesno_lookup.meaning;
1089: end loop;
1082: printOutput( RPAD(l_temp_msg,45,' ') || ' ' || l_temp_rule);
1083:
1084: if p_override_minisite_flag = 'Y' then
1085: fnd_message.set_name('IBE','IBE_BI_UPD_CARTS_WITH_STORE_ID');
1086: l_temp_msg := fnd_message.get;
1087: for rec_yesno_lookup in c_lookup('YES_NO',p_override_minisite_flag) loop
1088: l_temp_yesno := rec_yesno_lookup.meaning;
1089: end loop;
1090: printOutput( RPAD(l_temp_msg,45,' ') || ' ' || l_temp_yesno);
1089: end loop;
1090: printOutput( RPAD(l_temp_msg,45,' ') || ' ' || l_temp_yesno);
1091: end if;
1092:
1093: fnd_message.set_name('IBE','IBE_BI_ORG_STR_INPUT');
1094: l_temp_msg := fnd_message.get;
1095: printOutput( RPAD(l_temp_msg,45) || ' ' || nvl(p_string_in,'< >'));
1096: printOutput(' ');
1097:
1090: printOutput( RPAD(l_temp_msg,45,' ') || ' ' || l_temp_yesno);
1091: end if;
1092:
1093: fnd_message.set_name('IBE','IBE_BI_ORG_STR_INPUT');
1094: l_temp_msg := fnd_message.get;
1095: printOutput( RPAD(l_temp_msg,45) || ' ' || nvl(p_string_in,'< >'));
1096: printOutput(' ');
1097:
1098: fnd_message.set_name('IBE','IBE_BI_USER_ORG_STR_MAP');
1094: l_temp_msg := fnd_message.get;
1095: printOutput( RPAD(l_temp_msg,45) || ' ' || nvl(p_string_in,'< >'));
1096: printOutput(' ');
1097:
1098: fnd_message.set_name('IBE','IBE_BI_USER_ORG_STR_MAP');
1099: l_temp_msg := fnd_message.get;
1100: printOutput(l_temp_msg );
1101: printOutput(rpad('-',60,'-'));
1102: fnd_message.set_name('IBE','IBE_BI_ORGANIZATION_IDENTIFIER');
1095: printOutput( RPAD(l_temp_msg,45) || ' ' || nvl(p_string_in,'< >'));
1096: printOutput(' ');
1097:
1098: fnd_message.set_name('IBE','IBE_BI_USER_ORG_STR_MAP');
1099: l_temp_msg := fnd_message.get;
1100: printOutput(l_temp_msg );
1101: printOutput(rpad('-',60,'-'));
1102: fnd_message.set_name('IBE','IBE_BI_ORGANIZATION_IDENTIFIER');
1103: l_temp_msg := fnd_message.get;
1098: fnd_message.set_name('IBE','IBE_BI_USER_ORG_STR_MAP');
1099: l_temp_msg := fnd_message.get;
1100: printOutput(l_temp_msg );
1101: printOutput(rpad('-',60,'-'));
1102: fnd_message.set_name('IBE','IBE_BI_ORGANIZATION_IDENTIFIER');
1103: l_temp_msg := fnd_message.get;
1104:
1105: fnd_message.set_name('IBE','IBE_BI_ORGANIZATION_NAME');
1106: l_temp_msg1 := fnd_message.get;
1099: l_temp_msg := fnd_message.get;
1100: printOutput(l_temp_msg );
1101: printOutput(rpad('-',60,'-'));
1102: fnd_message.set_name('IBE','IBE_BI_ORGANIZATION_IDENTIFIER');
1103: l_temp_msg := fnd_message.get;
1104:
1105: fnd_message.set_name('IBE','IBE_BI_ORGANIZATION_NAME');
1106: l_temp_msg1 := fnd_message.get;
1107:
1101: printOutput(rpad('-',60,'-'));
1102: fnd_message.set_name('IBE','IBE_BI_ORGANIZATION_IDENTIFIER');
1103: l_temp_msg := fnd_message.get;
1104:
1105: fnd_message.set_name('IBE','IBE_BI_ORGANIZATION_NAME');
1106: l_temp_msg1 := fnd_message.get;
1107:
1108: fnd_message.set_name('IBE','IBE_BI_STORE_IDENTIFIER');
1109: l_temp_msg2 := fnd_message.get;
1102: fnd_message.set_name('IBE','IBE_BI_ORGANIZATION_IDENTIFIER');
1103: l_temp_msg := fnd_message.get;
1104:
1105: fnd_message.set_name('IBE','IBE_BI_ORGANIZATION_NAME');
1106: l_temp_msg1 := fnd_message.get;
1107:
1108: fnd_message.set_name('IBE','IBE_BI_STORE_IDENTIFIER');
1109: l_temp_msg2 := fnd_message.get;
1110:
1104:
1105: fnd_message.set_name('IBE','IBE_BI_ORGANIZATION_NAME');
1106: l_temp_msg1 := fnd_message.get;
1107:
1108: fnd_message.set_name('IBE','IBE_BI_STORE_IDENTIFIER');
1109: l_temp_msg2 := fnd_message.get;
1110:
1111: fnd_message.set_name('IBE','IBE_BI_STORE_NAME');
1112: l_temp_msg3 := fnd_message.get;
1105: fnd_message.set_name('IBE','IBE_BI_ORGANIZATION_NAME');
1106: l_temp_msg1 := fnd_message.get;
1107:
1108: fnd_message.set_name('IBE','IBE_BI_STORE_IDENTIFIER');
1109: l_temp_msg2 := fnd_message.get;
1110:
1111: fnd_message.set_name('IBE','IBE_BI_STORE_NAME');
1112: l_temp_msg3 := fnd_message.get;
1113:
1107:
1108: fnd_message.set_name('IBE','IBE_BI_STORE_IDENTIFIER');
1109: l_temp_msg2 := fnd_message.get;
1110:
1111: fnd_message.set_name('IBE','IBE_BI_STORE_NAME');
1112: l_temp_msg3 := fnd_message.get;
1113:
1114: if v_mapping_tab.first is not null then
1115:
1108: fnd_message.set_name('IBE','IBE_BI_STORE_IDENTIFIER');
1109: l_temp_msg2 := fnd_message.get;
1110:
1111: fnd_message.set_name('IBE','IBE_BI_STORE_NAME');
1112: l_temp_msg3 := fnd_message.get;
1113:
1114: if v_mapping_tab.first is not null then
1115:
1116: printOutput(RPAD(l_temp_msg ,20) || ' ' || RPAD(l_temp_msg1 ,20) || ' ' || RPAD(l_temp_msg2 ,20) || l_temp_msg3);
1129: END LOOP;
1130: end if;
1131: printOutput(' ');
1132: printOutput(' ');
1133: fnd_message.set_name('IBE','IBE_BI_MIGRATION_SUMMARY');
1134: l_temp_msg := fnd_message.get;
1135: printOutput(l_temp_msg);
1136: printOutput(rpad('=',80,'='));
1137: printOutput(' ');
1130: end if;
1131: printOutput(' ');
1132: printOutput(' ');
1133: fnd_message.set_name('IBE','IBE_BI_MIGRATION_SUMMARY');
1134: l_temp_msg := fnd_message.get;
1135: printOutput(l_temp_msg);
1136: printOutput(rpad('=',80,'='));
1137: printOutput(' ');
1138:
1135: printOutput(l_temp_msg);
1136: printOutput(rpad('=',80,'='));
1137: printOutput(' ');
1138:
1139: fnd_message.set_name('IBE','IBE_BI_NO_OF_CARTS_FOUND');
1140: l_temp_msg := fnd_message.get;
1141: printOutput(l_temp_msg ||' '|| nvl(l_tot_found,0));
1142: fnd_message.set_name('IBE','IBE_BI_NO_OF_CARTS_LEFT');
1143: l_temp_msg := fnd_message.get;
1136: printOutput(rpad('=',80,'='));
1137: printOutput(' ');
1138:
1139: fnd_message.set_name('IBE','IBE_BI_NO_OF_CARTS_FOUND');
1140: l_temp_msg := fnd_message.get;
1141: printOutput(l_temp_msg ||' '|| nvl(l_tot_found,0));
1142: fnd_message.set_name('IBE','IBE_BI_NO_OF_CARTS_LEFT');
1143: l_temp_msg := fnd_message.get;
1144: printOutput(l_temp_msg || ' ' ||nvl(l_tot_left,0));
1138:
1139: fnd_message.set_name('IBE','IBE_BI_NO_OF_CARTS_FOUND');
1140: l_temp_msg := fnd_message.get;
1141: printOutput(l_temp_msg ||' '|| nvl(l_tot_found,0));
1142: fnd_message.set_name('IBE','IBE_BI_NO_OF_CARTS_LEFT');
1143: l_temp_msg := fnd_message.get;
1144: printOutput(l_temp_msg || ' ' ||nvl(l_tot_left,0));
1145: printOutput(' ');
1146:
1139: fnd_message.set_name('IBE','IBE_BI_NO_OF_CARTS_FOUND');
1140: l_temp_msg := fnd_message.get;
1141: printOutput(l_temp_msg ||' '|| nvl(l_tot_found,0));
1142: fnd_message.set_name('IBE','IBE_BI_NO_OF_CARTS_LEFT');
1143: l_temp_msg := fnd_message.get;
1144: printOutput(l_temp_msg || ' ' ||nvl(l_tot_left,0));
1145: printOutput(' ');
1146:
1147:
1144: printOutput(l_temp_msg || ' ' ||nvl(l_tot_left,0));
1145: printOutput(' ');
1146:
1147:
1148: fnd_message.set_name('IBE','IBE_BI_METHOD_TO_FIND_STR');
1149: l_temp_msg := fnd_message.get;
1150: fnd_message.set_name('IBE','IBE_BI_NO_OF_CARTS');
1151: l_temp_msg1 := fnd_message.get;
1152:
1145: printOutput(' ');
1146:
1147:
1148: fnd_message.set_name('IBE','IBE_BI_METHOD_TO_FIND_STR');
1149: l_temp_msg := fnd_message.get;
1150: fnd_message.set_name('IBE','IBE_BI_NO_OF_CARTS');
1151: l_temp_msg1 := fnd_message.get;
1152:
1153:
1146:
1147:
1148: fnd_message.set_name('IBE','IBE_BI_METHOD_TO_FIND_STR');
1149: l_temp_msg := fnd_message.get;
1150: fnd_message.set_name('IBE','IBE_BI_NO_OF_CARTS');
1151: l_temp_msg1 := fnd_message.get;
1152:
1153:
1154: printOutput(RPAD(l_temp_msg,45,' ') || ' ' || l_temp_msg1);
1147:
1148: fnd_message.set_name('IBE','IBE_BI_METHOD_TO_FIND_STR');
1149: l_temp_msg := fnd_message.get;
1150: fnd_message.set_name('IBE','IBE_BI_NO_OF_CARTS');
1151: l_temp_msg1 := fnd_message.get;
1152:
1153:
1154: printOutput(RPAD(l_temp_msg,45,' ') || ' ' || l_temp_msg1);
1155: printOutput(RPAD('-',45,'-') || ' ' || LPAD('-',14,'-'));
1152:
1153:
1154: printOutput(RPAD(l_temp_msg,45,' ') || ' ' || l_temp_msg1);
1155: printOutput(RPAD('-',45,'-') || ' ' || LPAD('-',14,'-'));
1156: fnd_message.set_name('IBE','IBE_BI_MIGRATION_LINE');
1157: l_temp_msg1 := fnd_message.get;
1158: printOutput(RPAD(l_temp_msg1,45,' ') || ' ' || nvl(l_cnt_line,0));
1159: fnd_message.set_name('IBE','IBE_BI_MIGRATION_ORG');
1160: l_temp_msg1 := fnd_message.get;
1153:
1154: printOutput(RPAD(l_temp_msg,45,' ') || ' ' || l_temp_msg1);
1155: printOutput(RPAD('-',45,'-') || ' ' || LPAD('-',14,'-'));
1156: fnd_message.set_name('IBE','IBE_BI_MIGRATION_LINE');
1157: l_temp_msg1 := fnd_message.get;
1158: printOutput(RPAD(l_temp_msg1,45,' ') || ' ' || nvl(l_cnt_line,0));
1159: fnd_message.set_name('IBE','IBE_BI_MIGRATION_ORG');
1160: l_temp_msg1 := fnd_message.get;
1161: printOutput(RPAD(l_temp_msg1,45,' ') || ' ' || nvl(l_cnt_org,0));
1155: printOutput(RPAD('-',45,'-') || ' ' || LPAD('-',14,'-'));
1156: fnd_message.set_name('IBE','IBE_BI_MIGRATION_LINE');
1157: l_temp_msg1 := fnd_message.get;
1158: printOutput(RPAD(l_temp_msg1,45,' ') || ' ' || nvl(l_cnt_line,0));
1159: fnd_message.set_name('IBE','IBE_BI_MIGRATION_ORG');
1160: l_temp_msg1 := fnd_message.get;
1161: printOutput(RPAD(l_temp_msg1,45,' ') || ' ' || nvl(l_cnt_org,0));
1162: fnd_message.set_name('IBE','IBE_BI_MIGRATION_PRICE');
1163: l_temp_msg1 := fnd_message.get;
1156: fnd_message.set_name('IBE','IBE_BI_MIGRATION_LINE');
1157: l_temp_msg1 := fnd_message.get;
1158: printOutput(RPAD(l_temp_msg1,45,' ') || ' ' || nvl(l_cnt_line,0));
1159: fnd_message.set_name('IBE','IBE_BI_MIGRATION_ORG');
1160: l_temp_msg1 := fnd_message.get;
1161: printOutput(RPAD(l_temp_msg1,45,' ') || ' ' || nvl(l_cnt_org,0));
1162: fnd_message.set_name('IBE','IBE_BI_MIGRATION_PRICE');
1163: l_temp_msg1 := fnd_message.get;
1164: printOutput(RPAD(l_temp_msg1,45,' ') || ' ' || nvl(l_cnt_price,0));
1158: printOutput(RPAD(l_temp_msg1,45,' ') || ' ' || nvl(l_cnt_line,0));
1159: fnd_message.set_name('IBE','IBE_BI_MIGRATION_ORG');
1160: l_temp_msg1 := fnd_message.get;
1161: printOutput(RPAD(l_temp_msg1,45,' ') || ' ' || nvl(l_cnt_org,0));
1162: fnd_message.set_name('IBE','IBE_BI_MIGRATION_PRICE');
1163: l_temp_msg1 := fnd_message.get;
1164: printOutput(RPAD(l_temp_msg1,45,' ') || ' ' || nvl(l_cnt_price,0));
1165: fnd_message.set_name('IBE','IBE_BI_MIGRATION_MANUAL');
1166: l_temp_msg1 := fnd_message.get;
1159: fnd_message.set_name('IBE','IBE_BI_MIGRATION_ORG');
1160: l_temp_msg1 := fnd_message.get;
1161: printOutput(RPAD(l_temp_msg1,45,' ') || ' ' || nvl(l_cnt_org,0));
1162: fnd_message.set_name('IBE','IBE_BI_MIGRATION_PRICE');
1163: l_temp_msg1 := fnd_message.get;
1164: printOutput(RPAD(l_temp_msg1,45,' ') || ' ' || nvl(l_cnt_price,0));
1165: fnd_message.set_name('IBE','IBE_BI_MIGRATION_MANUAL');
1166: l_temp_msg1 := fnd_message.get;
1167: printOutput(RPAD(l_temp_msg1,45,' ') || ' ' || nvl(l_cnt_manual,0));
1161: printOutput(RPAD(l_temp_msg1,45,' ') || ' ' || nvl(l_cnt_org,0));
1162: fnd_message.set_name('IBE','IBE_BI_MIGRATION_PRICE');
1163: l_temp_msg1 := fnd_message.get;
1164: printOutput(RPAD(l_temp_msg1,45,' ') || ' ' || nvl(l_cnt_price,0));
1165: fnd_message.set_name('IBE','IBE_BI_MIGRATION_MANUAL');
1166: l_temp_msg1 := fnd_message.get;
1167: printOutput(RPAD(l_temp_msg1,45,' ') || ' ' || nvl(l_cnt_manual,0));
1168: printOutput(' ');
1169: printOutput(' ');
1162: fnd_message.set_name('IBE','IBE_BI_MIGRATION_PRICE');
1163: l_temp_msg1 := fnd_message.get;
1164: printOutput(RPAD(l_temp_msg1,45,' ') || ' ' || nvl(l_cnt_price,0));
1165: fnd_message.set_name('IBE','IBE_BI_MIGRATION_MANUAL');
1166: l_temp_msg1 := fnd_message.get;
1167: printOutput(RPAD(l_temp_msg1,45,' ') || ' ' || nvl(l_cnt_manual,0));
1168: printOutput(' ');
1169: printOutput(' ');
1170:
1167: printOutput(RPAD(l_temp_msg1,45,' ') || ' ' || nvl(l_cnt_manual,0));
1168: printOutput(' ');
1169: printOutput(' ');
1170:
1171: fnd_message.set_name('IBE','IBE_BI_EXCEPTION_REPORT');
1172: l_temp_msg := fnd_message.get;
1173: printOutput(l_temp_msg );
1174: printOutput(rpad('=',80,'='));
1175: printOutput(' ');
1168: printOutput(' ');
1169: printOutput(' ');
1170:
1171: fnd_message.set_name('IBE','IBE_BI_EXCEPTION_REPORT');
1172: l_temp_msg := fnd_message.get;
1173: printOutput(l_temp_msg );
1174: printOutput(rpad('=',80,'='));
1175: printOutput(' ');
1176: fnd_message.set_name('IBE','IBE_BI_EXCEPTION_REPORT_DETAIL');
1172: l_temp_msg := fnd_message.get;
1173: printOutput(l_temp_msg );
1174: printOutput(rpad('=',80,'='));
1175: printOutput(' ');
1176: fnd_message.set_name('IBE','IBE_BI_EXCEPTION_REPORT_DETAIL');
1177: l_temp_msg := fnd_message.get;
1178: printOutput(l_temp_msg );
1179: printOutput(rpad('-',60,'-'));
1180: printOutput(' ');
1173: printOutput(l_temp_msg );
1174: printOutput(rpad('=',80,'='));
1175: printOutput(' ');
1176: fnd_message.set_name('IBE','IBE_BI_EXCEPTION_REPORT_DETAIL');
1177: l_temp_msg := fnd_message.get;
1178: printOutput(l_temp_msg );
1179: printOutput(rpad('-',60,'-'));
1180: printOutput(' ');
1181:
1179: printOutput(rpad('-',60,'-'));
1180: printOutput(' ');
1181:
1182:
1183: fnd_message.set_name('IBE','IBE_BI_NO_OF_CARTS');
1184: l_temp_msg := fnd_message.get;
1185: fnd_message.set_name('IBE','IBE_BI_ORGANIZATION_IDENTIFIER');
1186: l_temp_msg1 := fnd_message.get;
1187: fnd_message.set_name('IBE','IBE_BI_ORGANIZATION_NAME');
1180: printOutput(' ');
1181:
1182:
1183: fnd_message.set_name('IBE','IBE_BI_NO_OF_CARTS');
1184: l_temp_msg := fnd_message.get;
1185: fnd_message.set_name('IBE','IBE_BI_ORGANIZATION_IDENTIFIER');
1186: l_temp_msg1 := fnd_message.get;
1187: fnd_message.set_name('IBE','IBE_BI_ORGANIZATION_NAME');
1188: l_temp_msg2 := fnd_message.get;
1181:
1182:
1183: fnd_message.set_name('IBE','IBE_BI_NO_OF_CARTS');
1184: l_temp_msg := fnd_message.get;
1185: fnd_message.set_name('IBE','IBE_BI_ORGANIZATION_IDENTIFIER');
1186: l_temp_msg1 := fnd_message.get;
1187: fnd_message.set_name('IBE','IBE_BI_ORGANIZATION_NAME');
1188: l_temp_msg2 := fnd_message.get;
1189:
1182:
1183: fnd_message.set_name('IBE','IBE_BI_NO_OF_CARTS');
1184: l_temp_msg := fnd_message.get;
1185: fnd_message.set_name('IBE','IBE_BI_ORGANIZATION_IDENTIFIER');
1186: l_temp_msg1 := fnd_message.get;
1187: fnd_message.set_name('IBE','IBE_BI_ORGANIZATION_NAME');
1188: l_temp_msg2 := fnd_message.get;
1189:
1190: printOutput(RPAD(l_temp_msg ,20,' ') || ' ' || RPAD(l_temp_msg1,25,' ')||' '||l_temp_msg2);
1183: fnd_message.set_name('IBE','IBE_BI_NO_OF_CARTS');
1184: l_temp_msg := fnd_message.get;
1185: fnd_message.set_name('IBE','IBE_BI_ORGANIZATION_IDENTIFIER');
1186: l_temp_msg1 := fnd_message.get;
1187: fnd_message.set_name('IBE','IBE_BI_ORGANIZATION_NAME');
1188: l_temp_msg2 := fnd_message.get;
1189:
1190: printOutput(RPAD(l_temp_msg ,20,' ') || ' ' || RPAD(l_temp_msg1,25,' ')||' '||l_temp_msg2);
1191: printOutput(RPAD('-',20,'-') || ' '||RPAD('-',25,'-') || ' ' || lPAD('-',33,'-'));
1184: l_temp_msg := fnd_message.get;
1185: fnd_message.set_name('IBE','IBE_BI_ORGANIZATION_IDENTIFIER');
1186: l_temp_msg1 := fnd_message.get;
1187: fnd_message.set_name('IBE','IBE_BI_ORGANIZATION_NAME');
1188: l_temp_msg2 := fnd_message.get;
1189:
1190: printOutput(RPAD(l_temp_msg ,20,' ') || ' ' || RPAD(l_temp_msg1,25,' ')||' '||l_temp_msg2);
1191: printOutput(RPAD('-',20,'-') || ' '||RPAD('-',25,'-') || ' ' || lPAD('-',33,'-'));
1192:
1234:
1235: BEGIN
1236:
1237:
1238: fnd_message.set_name('IBE','IBE_BI_ORG_STR_IDENTIFIER');
1239: l_temp_msg := fnd_message.get;
1240: printOutput(l_temp_msg);
1241: printOutput(RPAD('=' ,80 , '='));
1242: printOutput(' ');
1235: BEGIN
1236:
1237:
1238: fnd_message.set_name('IBE','IBE_BI_ORG_STR_IDENTIFIER');
1239: l_temp_msg := fnd_message.get;
1240: printOutput(l_temp_msg);
1241: printOutput(RPAD('=' ,80 , '='));
1242: printOutput(' ');
1243: fnd_message.set_name('IBE','IBE_BI_ORGANIZATION_IDENTIFIER');
1239: l_temp_msg := fnd_message.get;
1240: printOutput(l_temp_msg);
1241: printOutput(RPAD('=' ,80 , '='));
1242: printOutput(' ');
1243: fnd_message.set_name('IBE','IBE_BI_ORGANIZATION_IDENTIFIER');
1244: l_temp_msg := fnd_message.get;
1245: fnd_message.set_name('IBE','IBE_BI_ORGANIZATION_NAME');
1246: l_temp_msg1 := fnd_message.get;
1247:
1240: printOutput(l_temp_msg);
1241: printOutput(RPAD('=' ,80 , '='));
1242: printOutput(' ');
1243: fnd_message.set_name('IBE','IBE_BI_ORGANIZATION_IDENTIFIER');
1244: l_temp_msg := fnd_message.get;
1245: fnd_message.set_name('IBE','IBE_BI_ORGANIZATION_NAME');
1246: l_temp_msg1 := fnd_message.get;
1247:
1248:
1241: printOutput(RPAD('=' ,80 , '='));
1242: printOutput(' ');
1243: fnd_message.set_name('IBE','IBE_BI_ORGANIZATION_IDENTIFIER');
1244: l_temp_msg := fnd_message.get;
1245: fnd_message.set_name('IBE','IBE_BI_ORGANIZATION_NAME');
1246: l_temp_msg1 := fnd_message.get;
1247:
1248:
1249:
1242: printOutput(' ');
1243: fnd_message.set_name('IBE','IBE_BI_ORGANIZATION_IDENTIFIER');
1244: l_temp_msg := fnd_message.get;
1245: fnd_message.set_name('IBE','IBE_BI_ORGANIZATION_NAME');
1246: l_temp_msg1 := fnd_message.get;
1247:
1248:
1249:
1250:
1256: END LOOP;
1257:
1258:
1259: printOutput(' ');
1260: fnd_message.set_name('IBE','IBE_BI_STORE_IDENTIFIER');
1261: l_temp_msg := fnd_message.get;
1262: fnd_message.set_name('IBE','IBE_BI_STORE_NAME');
1263: l_temp_msg1 := fnd_message.get;
1264:
1257:
1258:
1259: printOutput(' ');
1260: fnd_message.set_name('IBE','IBE_BI_STORE_IDENTIFIER');
1261: l_temp_msg := fnd_message.get;
1262: fnd_message.set_name('IBE','IBE_BI_STORE_NAME');
1263: l_temp_msg1 := fnd_message.get;
1264:
1265: printOutput(RPAD(l_temp_msg1,45,' ') || ' ' || l_temp_msg);
1258:
1259: printOutput(' ');
1260: fnd_message.set_name('IBE','IBE_BI_STORE_IDENTIFIER');
1261: l_temp_msg := fnd_message.get;
1262: fnd_message.set_name('IBE','IBE_BI_STORE_NAME');
1263: l_temp_msg1 := fnd_message.get;
1264:
1265: printOutput(RPAD(l_temp_msg1,45,' ') || ' ' || l_temp_msg);
1266: printOutput(RPAD('-',45,'-') || ' ' ||lPAD('-',24,'-') );
1259: printOutput(' ');
1260: fnd_message.set_name('IBE','IBE_BI_STORE_IDENTIFIER');
1261: l_temp_msg := fnd_message.get;
1262: fnd_message.set_name('IBE','IBE_BI_STORE_NAME');
1263: l_temp_msg1 := fnd_message.get;
1264:
1265: printOutput(RPAD(l_temp_msg1,45,' ') || ' ' || l_temp_msg);
1266: printOutput(RPAD('-',45,'-') || ' ' ||lPAD('-',24,'-') );
1267: