91: FND_FILE.PUT_LINE(FND_FILE.LOG, 'instance_code:'||p_instance_code||' dblink: '|| p_po_number ||', instance_id='||p_instance_id||', batch_id='||p_batch_id||',allow_release_flag ='||p_allow_release);
92:
93:
94: if p_allow_release = 1 THEN
95: mo_global.INIT('PO');
96: sql_stmt:=
97: ' select old_need_by_date,'||
98: ' new_need_by_date,'||
99: ' po_header_id,'||
318: OPEN cur_org(x_po_header_id);
319: FETCH cur_org INTO l_document_org_id;
320: CLOSE cur_org;
321:
322: l_access_mode := mo_global.Get_access_mode();
323: l_current_org_id := mo_global.get_current_org_id();
324:
325: mo_global.set_policy_context('S',l_document_org_id);
326:
319: FETCH cur_org INTO l_document_org_id;
320: CLOSE cur_org;
321:
322: l_access_mode := mo_global.Get_access_mode();
323: l_current_org_id := mo_global.get_current_org_id();
324:
325: mo_global.set_policy_context('S',l_document_org_id);
326:
327:
321:
322: l_access_mode := mo_global.Get_access_mode();
323: l_current_org_id := mo_global.get_current_org_id();
324:
325: mo_global.set_policy_context('S',l_document_org_id);
326:
327:
328: p_result :=po_reschedule_pkg.reschedule
329: (X_old_need_by_dates,
333: X_po_number,
334: X_shipment_nums,
335: X_estimated_pickup_dates,
336: X_ship_methods);
337: Mo_Global.Set_Policy_Context (p_access_mode => l_access_mode,
338: p_org_id => l_current_org_id);
339: exception when others then
340: FND_FILE.PUT_LINE(FND_FILE.LOG,' error while calling po_reschedule_pkg.reschedule '||sqlerrm);
341: Mo_Global.Set_Policy_Context (p_access_mode => l_access_mode,
337: Mo_Global.Set_Policy_Context (p_access_mode => l_access_mode,
338: p_org_id => l_current_org_id);
339: exception when others then
340: FND_FILE.PUT_LINE(FND_FILE.LOG,' error while calling po_reschedule_pkg.reschedule '||sqlerrm);
341: Mo_Global.Set_Policy_Context (p_access_mode => l_access_mode,
342: p_org_id => l_current_org_id);
343: show_po_details;
344: end;
345: