APPS.JAI_INV_ITEMS_PKG dependencies on JAI_CONSTANTS

Line 136: p_process_flag := jai_constants.expected_error;

132: +4245089
133: --------------------------------------------------------------------------------------------------------------------------------------------------*/
134:
135: IF p_regime_code IS NULL THEN
136: p_process_flag := jai_constants.expected_error;
137: p_process_msg := 'Regime cannot be null';
138: return ;
139: END IF;
140:

Line 142: p_process_flag := jai_constants.expected_error;

138: return ;
139: END IF;
140:
141: IF p_organization_id IS NULL THEN
142: p_process_flag := jai_constants.expected_error;
143: p_process_msg := 'Organization cannot be null';
144: return ;
145: END IF;
146:

Line 148: p_process_flag := jai_constants.expected_error;

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

Line 164: p_process_flag := jai_constants.expected_error;

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

Line 172: p_process_flag := jai_constants.expected_error;

168: -- END 5631784
169:
170:
171: IF lv_attribute_value IS NULL THEN
172: p_process_flag := jai_constants.expected_error;
173: p_process_msg := 'Given item is either not registered with template or does not have the given attribute';
174: ELSE
175: p_attribute_value := lv_attribute_value;
176: p_process_flag := jai_constants.successful;

Line 176: p_process_flag := jai_constants.successful;

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

Line 183: p_process_flag := jai_constants.unexpected_error;

179:
180: EXCEPTION
181: WHEN OTHERS THEN
182: p_attribute_value := null;
183: p_process_flag := jai_constants.unexpected_error;
184: p_process_msg := substr (sqlerrm,1,999) ;
185:
186: END jai_get_attrib;
187:

Line 527: AND regime_code = jai_constants.excise_regime ;

523: last_updated_by
524: from jai_rgm_item_attrib_v
525: where organization_id = cpn_organization_id
526: and inventory_item_id = cpn_inventory_item_id
527: AND regime_code = jai_constants.excise_regime ;
528:
529: begin
530: /* Get all the rows to be synchronized */
531: for rec_jmsi in cur_get_jmsi_row(p_synchronization_number)

Line 770: OPEN cur_get_item_regns (cpv_regime_code => jai_constants.excise_regime

766:
767:
768: /* Check if destination item already exists */
769:
770: OPEN cur_get_item_regns (cpv_regime_code => jai_constants.excise_regime
771: ,cpn_organization_id => ln_organization_id
772: ,cpn_inventory_item_id => ln_inventory_item_id
773: );
774:

Line 786: OPEN cur_get_item_regns (cpv_regime_code => jai_constants.excise_regime

782: END IF;
783:
784: /* Check if item specific registration exists for the source item */
785:
786: OPEN cur_get_item_regns (cpv_regime_code => jai_constants.excise_regime
787: ,cpn_organization_id => ln_source_organization_id
788: ,cpn_inventory_item_id => ln_source_inventory_item_id
789: );
790: FETCH cur_get_item_regns INTO ln_item_regns_id;

Line 810: ( p_regime_code => jai_constants.excise_regime

806: lt_attribs(lt_attribs.count).attribute_value := cur_attribs.attribute_value;
807: END LOOP;
808:
809: jai_inv_items_pkg.jai_create_item_regns
810: ( p_regime_code => jai_constants.excise_regime
811: ,p_organization_id => ln_organization_id
812: ,p_inventory_item_id => ln_inventory_item_id
813: ,p_tab_attributes => lt_attribs
814: );

Line 819: (cpv_regime_code => jai_constants.excise_regime

815: END IF; /* End of Item Specific Registration*/
816:
817: /* Check if source item is alredy registred with some template */
818: OPEN cur_get_template_id
819: (cpv_regime_code => jai_constants.excise_regime
820: ,cpn_organization_id => ln_organization_id
821: ,cpn_inventory_item_id => ln_inventory_item_id
822: );
823: FETCH cur_get_template_id INTO ln_dest_template_id;

Line 833: (cpv_regime_code => jai_constants.excise_regime

829: END IF;
830:
831: /* Check if source item is assigned to template */
832: OPEN cur_get_template_id
833: (cpv_regime_code => jai_constants.excise_regime
834: ,cpn_organization_id => ln_source_organization_id
835: ,cpn_inventory_item_id => ln_source_inventory_item_id
836: );
837: FETCH cur_get_template_id INTO ln_template_id;

Line 923: AND regime_code = jai_constants.excise_regime

919:
920: DELETE FROM JAI_RGM_ITM_REGNS
921: WHERE inventory_item_id = ln_inventory_item_id
922: AND organization_id = ln_organization_id
923: AND regime_code = jai_constants.excise_regime
924: RETURNING rgm_item_regns_id INTO ln_rgm_item_regns_id;
925:
926: IF ln_rgm_item_regns_id IS NOT NULL THEN
927: DELETE FROM JAI_RGM_ITM_TMPL_ATTRS

Line 940: AND rgtmp.regime_code = jai_constants.excise_regime

936: WHERE tirg.templ_org_regns_id = torg.templ_org_regns_id
937: AND torg.template_id = rgtmp.template_id
938: AND tirg.inventory_item_id = ln_inventory_item_id
939: AND torg.organization_id = ln_organization_id
940: AND rgtmp.regime_code = jai_constants.excise_regime
941: )
942: RETURNING templ_org_regns_id INTO ln_templ_org_regns_id ;
943:
944: /*