[Home] [Help]
35:
36:
37: If p_organization_code is null then
38:
39: FND_FILE.put_line(FND_FILE.LOG, 'Organization Code : ALL Organizations');
40:
41: select organization_id
42: Bulk Collect
43: into l_all_orgs
56: end loop;
57:
58: else
59:
60: FND_FILE.put_line(FND_FILE.LOG, 'Organization Code : '||p_organization_code);
61:
62: select organization_id
63: into p_organization_id
64: from MTL_PARAMETERS
163: end if;
164:
165: if l_good_health = 0 OR l_bad_health = 0 then
166:
167: FND_FILE.put_line(FND_FILE.LOG, 'Please setup Good and Bad Inventory Health for the Pull Sequence '||c_ps_activity.pull_sequence_id);
168: -- dbms_output.put_line('Please run the Actual Demand Calculation first');
169: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', 'Warning: Setup missing for Good and Bad Inventory Health ');
170: l_continue_processing := 'N';
171:
286: from mtl_kanban_pull_sequences
287: where INV_HEALTH_STATUS = 1
288: and organization_id = p_organization_id;
289:
290: FND_FILE.put_line(FND_FILE.LOG, 'Total rows with Bad Health are : '||l_row_count);
291: -- dbms_output.put_line('Total rows with Good Health are : '||l_row_count);
292:
293: select count(*)
294: into l_row_count
295: from mtl_kanban_pull_sequences
296: where INV_HEALTH_STATUS = 2
297: and organization_id = p_organization_id;
298:
299: FND_FILE.put_line(FND_FILE.LOG, 'Total rows with Warning Health are : '||l_row_count);
300: -- dbms_output.put_line('Total rows with Warning Health are : '||l_row_count);
301:
302: select count(*)
303: into l_row_count
304: from mtl_kanban_pull_sequences
305: where INV_HEALTH_STATUS = 3
306: and organization_id = p_organization_id;
307:
308: FND_FILE.put_line(FND_FILE.LOG, 'Total rows with Good Health are : '||l_row_count);
309: -- dbms_output.put_line('Total rows with Bad Health are : '||l_row_count);
310: end of testing */
311:
312: end;