[Home] [Help]
76: This Trigger is created to validate whether Localization setups exist for
77: the Organization/Location combination.
78:
79: 2. 07/06/2004 Nagaraj.s for Bug#3655330. Version : 619.2
80: In case of change in destination type for standard routing, the location
81: would still be null as a result of which the setups are checked and the error
82: is thrown up. This scenario of change in destination type is not supported
83: by Localization yet and hence a message in such a scenario is :
84: Localization does not support change in destination type
93: GL Sources and GL Categories got changed. Refer bug for the details
94:
95: 6. 20-Feb-2007 CSahoo for Bug#5592114. File Version 120.3
96: Forward Porting of 11i BUG#5592023
97: Modified the code not to error during RECEIVE trx of Standard Routing changed to Direct delivery
98: + enhanced this trigger to execute for direct delivery case also
99:
100: 14-may-07 kunkumar made changes for Budget and ST by IO and Build issues resolved
101:
150: THEN
151: IF pr_new.transaction_type = 'RECEIVE' THEN
152: RETURN;
153: ELSIF pr_new.transaction_type = 'DELIVER' THEN
154: lv_scenario := 'STANDARD_TO_DIRECT'; /* go ahead to validate the IL Setup */
155: END IF;
156:
157: ELSIF pr_new.transaction_type = 'DELIVER' THEN
158: RETURN; -- no need of this check for deliver case except for above
168: close chk_org_setup_is_present;
169:
170: if nvl(v_orgn_setup_count,0) = 0 then
171: /* Start, added by CSahoo Bug#5592114 */
172: if lv_scenario = 'STANDARD_TO_DIRECT' then
173: open c_get_location_id(pr_new.organization_id, pr_new.subinventory);
174: fetch c_get_location_id into ln_location_id;
175: close c_get_location_id;
176:
198: close c_fetch_shipment_line_info;
199:
200: --3655330
201: if pr_new.source_document_code in ('PO') and v_destination_type_code='INVENTORY' then
202: fnd_file.put_line(fnd_file.log, 'Cannot process records.The change of destination type for standard/inspection routing is not supported by Localization');
203: app_exception.raise_exception( exception_type => 'APP' ,
204: exception_code => -20120 ,
205: exception_text => 'Localization does not support change in destination type'
206: );
358:
359: 10. 15/10/2003 Nagaraj.s for Bug#3162928. Version : 616.2
360: One more Condition is added in the Trigger to allow
361: "To handle Deliver RTR RTV" to fire in case of an
362: RMA Receipt/standard Delivery.
363:
364: 11. 08/01/2004 Nagaraj.s for Bug#3354415. Version : 618.1
365: The call to ja_in_set_rcv_process_flags is now having one more parameter
366: p_attribute5. Hence this would result into an Dependency. This is being
376:
377: if the attribute_category is a null value and attribute2 is a not null value
378: it is being set to NULL and passed on to the jai_rcv_tax_pkg.default_taxes_onto_line procedure.
379:
380: If the value is not one of the India Localization standard ones, then we entering the
381: values in a JAI_CMN_ERRORS_T and are returing the control.
382:
383: The 'INR' check which was commented is now un-commented so that code returns in cases where
384: in Non-INR set of books , no processing occurs..