1230: p_error_code := -1;
1231: fnd_message.set_name('WSM', 'WSM_KNBN_CARD_STS_FAIL');
1232: select meaning
1233: into translated_meaning
1234: from mfg_lookups
1235: where lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'
1236: and lookup_code = 5
1237: and upper(enabled_flag) = 'Y';
1238: fnd_message.set_token('STATUS',translated_meaning);
7128: fnd_message.set_name('WSM', 'WSM_KNBN_CARD_STS_FAIL');
7129:
7130: select meaning
7131: into translated_meaning
7132: from mfg_lookups
7133: where lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'
7134: and lookup_code = 7
7135: and upper(enabled_flag) = 'Y';
7136:
7495: fnd_file.put_line(fnd_file.output, 'Organization: '||org_code);
7496: fnd_file.put_line(fnd_file.output, 'Job_name: '|| v_wlji_job_name(v_index));
7497: select meaning
7498: into job_type_meaning
7499: from mfg_lookups
7500: where lookup_type = 'WIP_DISCRETE_JOB'
7501: and lookup_code = v_wlji_job_type(v_index);
7502: fnd_file.put_line(fnd_file.output, 'Job Type: '|| job_type_meaning);
7503:
7555: l_error_code := -1;
7556: fnd_message.set_name('WSM', 'WSM_KNBN_CARD_STS_FAIL');
7557: select meaning
7558: into translated_meaning
7559: from mfg_lookups
7560: where lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'
7561: and lookup_code = 7
7562: and upper(enabled_flag) = 'Y';
7563: