eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_INV_ITEMS_PKG dependencies on JAI_CONSTANTS

Line 141: p_process_flag := jai_constants.expected_error;

137: +4245089
138: --------------------------------------------------------------------------------------------------------------------------------------------------*/
139:
140: IF p_regime_code IS NULL THEN
141: p_process_flag := jai_constants.expected_error;
142: p_process_msg := 'Regime cannot be null';
143: return ;
144: END IF;
145:

Line 147: p_process_flag := jai_constants.expected_error;

143: return ;
144: END IF;
145:
146: IF p_organization_id IS NULL THEN
147: p_process_flag := jai_constants.expected_error;
148: p_process_msg := 'Organization cannot be null';
149: return ;
150: END IF;
151:

Line 153: p_process_flag := jai_constants.expected_error;

149: return ;
150: END IF;
151:
152: IF p_inventory_item_id IS NULL THEN
153: p_process_flag := jai_constants.expected_error;
154: p_process_msg := 'Item cannot be null';
155: return ;
156: END IF;
157:

Line 169: p_process_flag := jai_constants.expected_error;

165: OPEN C_GET_ITEM_NAME;
166: FETCH C_GET_ITEM_NAME INTO LV_ITEM_NAME;
167: CLOSE C_GET_ITEM_NAME;
168:
169: p_process_flag := jai_constants.expected_error;
170: p_process_msg := 'Cannot find item classification for "'||p_regime_code||'" regime and "'|| lv_item_name || '" item of '||p_organization_id ||' organization(id)';
171: RETURN ;
172: END IF ;
173: -- END 5631784

Line 177: p_process_flag := jai_constants.expected_error;

173: -- END 5631784
174:
175:
176: IF lv_attribute_value IS NULL THEN
177: p_process_flag := jai_constants.expected_error;
178: p_process_msg := 'Given item is either not registered with template or does not have the given attribute';
179: ELSE
180: p_attribute_value := lv_attribute_value;
181: p_process_flag := jai_constants.successful;

Line 181: p_process_flag := jai_constants.successful;

177: p_process_flag := jai_constants.expected_error;
178: p_process_msg := 'Given item is either not registered with template or does not have the given attribute';
179: ELSE
180: p_attribute_value := lv_attribute_value;
181: p_process_flag := jai_constants.successful;
182: p_process_msg := null;
183: END IF;
184:
185: EXCEPTION

Line 188: p_process_flag := jai_constants.unexpected_error;

184:
185: EXCEPTION
186: WHEN OTHERS THEN
187: p_attribute_value := null;
188: p_process_flag := jai_constants.unexpected_error;
189: p_process_msg := substr (sqlerrm,1,999) ;
190:
191: END jai_get_attrib;
192:

Line 532: AND regime_code = jai_constants.excise_regime ;

528: last_updated_by
529: from jai_rgm_item_attrib_v
530: where organization_id = cpn_organization_id
531: and inventory_item_id = cpn_inventory_item_id
532: AND regime_code = jai_constants.excise_regime ;
533:
534: begin
535: /* Get all the rows to be synchronized */
536: for rec_jmsi in cur_get_jmsi_row(p_synchronization_number)

Line 778: OPEN cur_get_item_regns (cpv_regime_code => lv_regime_code --replaced jai_constants.excise_regime for bug#9191274

774:
775:
776: /* Check if destination item already exists */
777:
778: OPEN cur_get_item_regns (cpv_regime_code => lv_regime_code --replaced jai_constants.excise_regime for bug#9191274
779: ,cpn_organization_id => ln_organization_id
780: ,cpn_inventory_item_id => ln_inventory_item_id
781: );
782:

Line 794: OPEN cur_get_item_regns (cpv_regime_code => lv_regime_code --replaced jai_constants.excise_regime for bug#9191274

790: END IF;
791:
792: /* Check if item specific registration exists for the source item */
793:
794: OPEN cur_get_item_regns (cpv_regime_code => lv_regime_code --replaced jai_constants.excise_regime for bug#9191274
795: ,cpn_organization_id => ln_source_organization_id
796: ,cpn_inventory_item_id => ln_source_inventory_item_id
797: );
798: FETCH cur_get_item_regns INTO ln_item_regns_id;

Line 818: ( p_regime_code => lv_regime_code --replaced jai_constants.excise_regime for bug#9191274

814: lt_attribs(lt_attribs.count).attribute_value := cur_attribs.attribute_value;
815: END LOOP;
816:
817: jai_inv_items_pkg.jai_create_item_regns
818: ( p_regime_code => lv_regime_code --replaced jai_constants.excise_regime for bug#9191274
819: ,p_organization_id => ln_organization_id
820: ,p_inventory_item_id => ln_inventory_item_id
821: ,p_tab_attributes => lt_attribs
822: );

Line 827: (cpv_regime_code => lv_regime_code --replaced jai_constants.excise_regime for bug#9191274

823: END IF; /* End of Item Specific Registration*/
824:
825: /* Check if source item is alredy registred with some template */
826: OPEN cur_get_template_id
827: (cpv_regime_code => lv_regime_code --replaced jai_constants.excise_regime for bug#9191274
828: ,cpn_organization_id => ln_organization_id
829: ,cpn_inventory_item_id => ln_inventory_item_id
830: );
831: FETCH cur_get_template_id INTO ln_dest_template_id;

Line 841: (cpv_regime_code => lv_regime_code --replaced jai_constants.excise_regime for bug#9191274

837: END IF;
838:
839: /* Check if source item is assigned to template */
840: OPEN cur_get_template_id
841: (cpv_regime_code => lv_regime_code --replaced jai_constants.excise_regime for bug#9191274
842: ,cpn_organization_id => ln_source_organization_id
843: ,cpn_inventory_item_id => ln_source_inventory_item_id
844: );
845: FETCH cur_get_template_id INTO ln_template_id;

Line 864: IF lv_regime_code = jai_constants.excise_regime THEN

860: For Excise regime create a copy record in the JAI_INV_ITM_SETUPS
861: from the source item
862: */
863: --added the IF condition for bug#9191274
864: IF lv_regime_code = jai_constants.excise_regime THEN
865: INSERT INTO JAI_INV_ITM_SETUPS
866: (
867: inventory_item_id
868: , organization_id

Line 934: AND regime_code = jai_constants.excise_regime

930:
931: DELETE FROM JAI_RGM_ITM_REGNS
932: WHERE inventory_item_id = ln_inventory_item_id
933: AND organization_id = ln_organization_id
934: AND regime_code = jai_constants.excise_regime
935: RETURNING rgm_item_regns_id INTO ln_rgm_item_regns_id;
936:
937: IF ln_rgm_item_regns_id IS NOT NULL THEN
938: DELETE FROM JAI_RGM_ITM_TMPL_ATTRS

Line 951: AND rgtmp.regime_code = jai_constants.excise_regime

947: WHERE tirg.templ_org_regns_id = torg.templ_org_regns_id
948: AND torg.template_id = rgtmp.template_id
949: AND tirg.inventory_item_id = ln_inventory_item_id
950: AND torg.organization_id = ln_organization_id
951: AND rgtmp.regime_code = jai_constants.excise_regime
952: )
953: RETURNING templ_org_regns_id INTO ln_templ_org_regns_id ;
954:
955: /*