DBA Data[Home] [Help]

APPS.JAI_OPM_GMD_TRIGGER_PKG dependencies on JAI_CONSTANTS

Line 84: pv_return_code := jai_constants.successful ;

80: v_file_name varchar2(30);
81: ln_po_id number;
82:
83: BEGIN
84: pv_return_code := jai_constants.successful ;
85: /*------------------------------------------------------------------------------------------------------------
86: Change History :
87: ------------------------------------------------------------------------------------------------------------
88: 1 26/04/2003 Sriram - bug # 2808732

Line 172: /* 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 ;

168: last_update_date = sysdate
169: WHERE rowid = l_rowid;
170: END IF;
171: ELSIF l_btch_stat IN (3,4) AND pr_new.line_type = -1 AND l_noninv_ind = 0 THEN
172: /* 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 ;
173: 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
174: l_rcpt_qty := pr_new.actual_qty - pr_old.actual_qty;
175:
176: OPEN c_get_location_id (ln_po_id);

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

233: );
234:
235: ELSIF l_btch_stat = 4 AND pr_new.line_type = 1 THEN
236: /* RAISE_APPLICATION_ERROR('-20011','Actual Output Quantity can not be changed');
237: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Actual Output Quantity can not be changed' ; return ;
238: END IF;
239: ELSIF pr_old.actual_qty > pr_new.actual_qty THEN
240: /* RAISE_APPLICATION_ERROR('-20012','You can not reduce the Actual Quantity');
241: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'You can not reduce the Actual Quantity' ; return ;

Line 241: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'You can not reduce the Actual Quantity' ; return ;

237: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Actual Output Quantity can not be changed' ; return ;
238: END IF;
239: ELSIF pr_old.actual_qty > pr_new.actual_qty THEN
240: /* RAISE_APPLICATION_ERROR('-20012','You can not reduce the Actual Quantity');
241: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'You can not reduce the Actual Quantity' ; return ;
242: END IF ;
243: END ARU_T1 ;
244:
245: END JAI_OPM_GMD_TRIGGER_PKG ;