DBA Data[Home] [Help]

APPS.JAI_OPM_GMD_TRIGGER_PKG dependencies on JAI_CONSTANTS

Line 82: pv_return_code := jai_constants.successful ;

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

Line 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 ;

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);

Line 231: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Actual Output Quantity can not be changed' ; return ;

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 ;

Line 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 ;