78: v_file_name varchar2(30);
79: ln_po_id number;
80:
81: BEGIN
82: pv_return_code := jai_constants.successful ;
83: /*------------------------------------------------------------------------------------------------------------
84: Change History :
85: ------------------------------------------------------------------------------------------------------------
86: 1 26/04/2003 Sriram - bug # 2808732
162: last_update_date = sysdate
163: WHERE rowid = l_rowid;
164: END IF;
165: ELSIF l_btch_stat IN (3,4) AND pr_new.line_type = -1 AND l_noninv_ind = 0 THEN
166: /* RAISE_APPLICATION_ERROR('-20009','Actual Quantity can not be changed'); */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Actual Quantity can not be changed' ; return ;
167: ELSIF l_btch_stat = 2 AND pr_new.line_type = 1 THEN -- made the comparison against the l_btch_stat to 3 from 2 for OPM J completion - sriram - bug # 2808732
168: l_rcpt_qty := pr_new.actual_qty - pr_old.actual_qty;
169:
170: OPEN c_get_location_id (ln_po_id);
227: );
228:
229: ELSIF l_btch_stat = 4 AND pr_new.line_type = 1 THEN
230: /* RAISE_APPLICATION_ERROR('-20011','Actual Output Quantity can not be changed');
231: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Actual Output Quantity can not be changed' ; return ;
232: END IF;
233: ELSIF pr_old.actual_qty > pr_new.actual_qty THEN
234: /* RAISE_APPLICATION_ERROR('-20012','You can not reduce the Actual Quantity');
235: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'You can not reduce the Actual Quantity' ; return ;
231: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Actual Output Quantity can not be changed' ; return ;
232: END IF;
233: ELSIF pr_old.actual_qty > pr_new.actual_qty THEN
234: /* RAISE_APPLICATION_ERROR('-20012','You can not reduce the Actual Quantity');
235: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'You can not reduce the Actual Quantity' ; return ;
236: END IF ;
237: END ARU_T1 ;
238:
239: END JAI_OPM_GMD_TRIGGER_PKG ;