[Home] [Help]
90: --will result in deletion of the starting job reservations
91: --Write warning into concurrent log
92: fnd_message.set_name('WSM','WSM_RSV_UPD_ASSY');
93: l_msg_data := fnd_message.get;
94: fnd_file.put_line(fnd_file.log,l_msg_data);
95:
96: l_return_status := FND_API.G_RET_STS_SUCCESS;
97: l_msg_count := 0;
98: l_msg_data := null;
166: If p_resulting_jobs_tbl(p_sj_also_rj_index).split_has_update_assy = 1 then
167: --Write warning into concurrent log
168: fnd_message.set_name('WSM','WSM_RSV_UPD_ASSY');
169: l_msg_data := fnd_message.get;
170: fnd_file.put_line(fnd_file.log,l_msg_data);
171:
172: l_return_status := FND_API.G_RET_STS_SUCCESS;
173: l_msg_count := 0;
174: l_msg_data := null;
235: IF l_rsvd_qty > p_resulting_jobs_tbl(p_sj_also_rj_index).net_quantity then
236: --Write warning into concurrent log
237: fnd_message.set_name('WSM','WSM_RSV_SPLIT');
238: l_msg_data := fnd_message.get;
239: fnd_file.put_line(fnd_file.log,l_msg_data);
240:
241: l_mtl_rsv_rec.action := 0;
242: l_mtl_rsv_rec.organization_id := p_starting_jobs_tbl(p_starting_jobs_tbl.first).organization_id;
243: l_mtl_rsv_rec.inventory_item_id := p_starting_jobs_tbl(p_starting_jobs_tbl.first).primary_item_id;
299: Else --parent job not resulting job
300: --Write warning into concurrent log
301: fnd_message.set_name('WSM','WSM_RSV_SPLIT');
302: l_msg_data := fnd_message.get;
303: fnd_file.put_line(fnd_file.log,l_msg_data);
304:
305: l_return_status := FND_API.G_RET_STS_SUCCESS;
306: l_msg_count := 0;
307: l_msg_data := null;
464: Else
465: --Write warning into concurrent log
466: fnd_message.set_name('WSM','WSM_RSV_MERGE');
467: l_msg_data := fnd_message.get;
468: fnd_file.put_line(fnd_file.log,l_msg_data);
469:
470: l_rsv_old.supply_source_header_id := p_starting_jobs_tbl(l_counter).wip_entity_id;
471: l_rsv_old.inventory_item_id := p_starting_jobs_tbl(l_counter).primary_item_id;
472: l_rsv_old.organization_id := p_starting_jobs_tbl(l_counter).organization_id;
693: ) ;
694: If l_rsvd_qty > p_net_qty then
695: fnd_message.set_name('WSM','WSM_NET_QTY_LOW');
696: l_msg_data := fnd_message.get;
697: fnd_file.put_line(fnd_file.log,l_msg_data);
698:
699: l_mtl_rsv_rec.action := 0;
700: l_mtl_rsv_rec.organization_id := p_org_id;
701: l_mtl_rsv_rec.inventory_item_id := p_inventory_item_id;
1012: If p_new_net_qty < p_old_net_qty and p_status_type <> 7 and p_new_net_qty <>0 then
1013: -- In case of interface,Write to WIE 'Note: Available quantity of the job is below the net quantity.'
1014: fnd_message.set_name('WSM','WSM_NET_QTY_LOW');
1015: l_msg_data := fnd_message.get;
1016: fnd_file.put_line(fnd_file.log,l_msg_data);
1017:
1018: --l_mtl_rsv_rec.action := 1;
1019: --l_mtl_rsv_rec.organization_id := p_org_id;
1020: --l_mtl_rsv_rec.inventory_item_id := p_inventory_item_id;
1098: Elsif p_status_type = 7 then
1099: --In case of interface, Write to WIE 'Note: Job is reserved against sales order(s). Cancelling the job will result in deletion of Job's reservations.'
1100: fnd_message.set_name('WSM','WSM_RSV_JOB_CANCEL');
1101: l_msg_data := fnd_message.get;
1102: fnd_file.put_line(fnd_file.log,l_msg_data);
1103:
1104: l_return_status := FND_API.G_RET_STS_SUCCESS;
1105: l_msg_count := 0;
1106: l_msg_data := null;
1169: elsif p_new_net_qty =0 and p_status_type <> 7 then -- Added for bug 5290496: START
1170: -- In case of interface,Write to WIE 'Note: Available quantity of the job is below the net quantity.'
1171: fnd_message.set_name('WSM','WSM_NET_QTY_LOW');
1172: l_msg_data := fnd_message.get;
1173: fnd_file.put_line(fnd_file.log,l_msg_data);
1174: l_return_status := FND_API.G_RET_STS_SUCCESS;
1175: l_msg_count := 0;
1176: l_msg_data := null;
1177: