98: WHERE organization_id = p_organization_id
99: AND secondary_inventory_name = p_subinventory_code;
100: EXCEPTION
101: WHEN no_data_found THEN
102: fnd_message.set_name('CSI','CSI_INT_DEST_SUBINV_INVALID');
103: fnd_message.set_token('INV_ORG_ID',p_organization_id);
104: fnd_message.set_token('SUBINV_ID',p_subinventory_code);
105: fnd_msg_pub.add;
106: RAISE fnd_api.g_exc_error;
99: AND secondary_inventory_name = p_subinventory_code;
100: EXCEPTION
101: WHEN no_data_found THEN
102: fnd_message.set_name('CSI','CSI_INT_DEST_SUBINV_INVALID');
103: fnd_message.set_token('INV_ORG_ID',p_organization_id);
104: fnd_message.set_token('SUBINV_ID',p_subinventory_code);
105: fnd_msg_pub.add;
106: RAISE fnd_api.g_exc_error;
107: END;
100: EXCEPTION
101: WHEN no_data_found THEN
102: fnd_message.set_name('CSI','CSI_INT_DEST_SUBINV_INVALID');
103: fnd_message.set_token('INV_ORG_ID',p_organization_id);
104: fnd_message.set_token('SUBINV_ID',p_subinventory_code);
105: fnd_msg_pub.add;
106: RAISE fnd_api.g_exc_error;
107: END;
108:
113: FROM hr_organization_units
114: WHERE organization_id = p_organization_id;
115: EXCEPTION
116: WHEN no_data_found THEN
117: fnd_message.set_name('CSI','CSI_INT_DEST_ORG_ID_INVALID');
118: fnd_message.set_token('INV_ORG_ID',p_organization_id);
119: fnd_msg_pub.add;
120: RAISE fnd_api.g_exc_error;
121: END;
114: WHERE organization_id = p_organization_id;
115: EXCEPTION
116: WHEN no_data_found THEN
117: fnd_message.set_name('CSI','CSI_INT_DEST_ORG_ID_INVALID');
118: fnd_message.set_token('INV_ORG_ID',p_organization_id);
119: fnd_msg_pub.add;
120: RAISE fnd_api.g_exc_error;
121: END;
122: END IF;
197:
198: EXCEPTION
199: WHEN no_data_found THEN
200:
201: fnd_message.set_name('CSI','CSI_INT_SUB_TYPE_REC_MISSING');
202: fnd_message.set_token('SUB_TYPE_ID',p_sub_type_id);
203: fnd_message.set_token('TRANSACTION_TYPE_ID',p_txn_type_id);
204: fnd_msg_pub.add;
205:
198: EXCEPTION
199: WHEN no_data_found THEN
200:
201: fnd_message.set_name('CSI','CSI_INT_SUB_TYPE_REC_MISSING');
202: fnd_message.set_token('SUB_TYPE_ID',p_sub_type_id);
203: fnd_message.set_token('TRANSACTION_TYPE_ID',p_txn_type_id);
204: fnd_msg_pub.add;
205:
206: x_return_status := fnd_api.g_ret_sts_error;
199: WHEN no_data_found THEN
200:
201: fnd_message.set_name('CSI','CSI_INT_SUB_TYPE_REC_MISSING');
202: fnd_message.set_token('SUB_TYPE_ID',p_sub_type_id);
203: fnd_message.set_token('TRANSACTION_TYPE_ID',p_txn_type_id);
204: fnd_msg_pub.add;
205:
206: x_return_status := fnd_api.g_ret_sts_error;
207: END get_sub_type_rec;
246: SELECT decode(p_reference_type,'P','Parent','N','Non Source','S','Source')
247: INTO l_reference_code
248: FROM sys.dual;
249:
250: fnd_message.set_name('CSI','CSI_TXN_SRC_REF_NOT_FOUND');
251: fnd_message.set_token('REF_TYPE',l_reference_code);
252: fnd_msg_pub.add;
253:
254: RAISE fnd_api.g_exc_error;
247: INTO l_reference_code
248: FROM sys.dual;
249:
250: fnd_message.set_name('CSI','CSI_TXN_SRC_REF_NOT_FOUND');
251: fnd_message.set_token('REF_TYPE',l_reference_code);
252: fnd_msg_pub.add;
253:
254: RAISE fnd_api.g_exc_error;
255:
317: p_txn_i_parties_tbl(l_p_ind).party_id <> l_internal_party_id
318: )
319: THEN
320:
321: fnd_message.set_name('CSI','CSI_INT_INV_PTY_ID');
322: fnd_message.set_token('PARTY_ID',p_txn_i_parties_tbl(l_p_ind).party_id);
323: fnd_message.set_token('INTERNAL_PARTY_ID',l_internal_party_id);
324: fnd_msg_pub.add;
325: RAISE fnd_api.g_exc_error;
318: )
319: THEN
320:
321: fnd_message.set_name('CSI','CSI_INT_INV_PTY_ID');
322: fnd_message.set_token('PARTY_ID',p_txn_i_parties_tbl(l_p_ind).party_id);
323: fnd_message.set_token('INTERNAL_PARTY_ID',l_internal_party_id);
324: fnd_msg_pub.add;
325: RAISE fnd_api.g_exc_error;
326:
319: THEN
320:
321: fnd_message.set_name('CSI','CSI_INT_INV_PTY_ID');
322: fnd_message.set_token('PARTY_ID',p_txn_i_parties_tbl(l_p_ind).party_id);
323: fnd_message.set_token('INTERNAL_PARTY_ID',l_internal_party_id);
324: fnd_msg_pub.add;
325: RAISE fnd_api.g_exc_error;
326:
327: END IF;
332: END LOOP;
333: END IF;
334:
335: IF NOT (l_owner_found) THEN
336: fnd_message.set_name('CSI','CSI_TXN_OWNER_NOT_FOUND');
337: fnd_message.set_token('INDEX',l_i_ind);
338: fnd_message.set_token('ITEM_ID',p_txn_instances_tbl(l_i_ind).inventory_item_id);
339: fnd_msg_pub.add;
340: RAISE fnd_api.g_exc_error;
333: END IF;
334:
335: IF NOT (l_owner_found) THEN
336: fnd_message.set_name('CSI','CSI_TXN_OWNER_NOT_FOUND');
337: fnd_message.set_token('INDEX',l_i_ind);
338: fnd_message.set_token('ITEM_ID',p_txn_instances_tbl(l_i_ind).inventory_item_id);
339: fnd_msg_pub.add;
340: RAISE fnd_api.g_exc_error;
341: END IF;
334:
335: IF NOT (l_owner_found) THEN
336: fnd_message.set_name('CSI','CSI_TXN_OWNER_NOT_FOUND');
337: fnd_message.set_token('INDEX',l_i_ind);
338: fnd_message.set_token('ITEM_ID',p_txn_instances_tbl(l_i_ind).inventory_item_id);
339: fnd_msg_pub.add;
340: RAISE fnd_api.g_exc_error;
341: END IF;
342:
511:
512: EXCEPTION
513: WHEN no_data_found THEN
514:
515: fnd_message.set_name('CSI','CSI_INT_ITEM_ID_MISSING');
516: fnd_message.set_token('INVENTORY_ITEM_ID',p_inventory_item_id);
517: fnd_message.set_token('INV_ORGANIZATION_ID',p_organization_id);
518: fnd_msg_pub.add;
519: RAISE fnd_api.g_exc_error;
512: EXCEPTION
513: WHEN no_data_found THEN
514:
515: fnd_message.set_name('CSI','CSI_INT_ITEM_ID_MISSING');
516: fnd_message.set_token('INVENTORY_ITEM_ID',p_inventory_item_id);
517: fnd_message.set_token('INV_ORGANIZATION_ID',p_organization_id);
518: fnd_msg_pub.add;
519: RAISE fnd_api.g_exc_error;
520: END;
513: WHEN no_data_found THEN
514:
515: fnd_message.set_name('CSI','CSI_INT_ITEM_ID_MISSING');
516: fnd_message.set_token('INVENTORY_ITEM_ID',p_inventory_item_id);
517: fnd_message.set_token('INV_ORGANIZATION_ID',p_organization_id);
518: fnd_msg_pub.add;
519: RAISE fnd_api.g_exc_error;
520: END;
521:
643: THEN
644:
645: IF nvl(p_instance_rec.serial_number, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN
646:
647: fnd_message.set_name('CSI','CSI_TXN_SERIAL_NUM_MISSING');
648: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);
649: fnd_message.set_token('INV_ORG_ID',p_instance_rec.inv_organization_id);
650: fnd_msg_pub.add;
651: RAISE fnd_api.g_exc_error;
644:
645: IF nvl(p_instance_rec.serial_number, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN
646:
647: fnd_message.set_name('CSI','CSI_TXN_SERIAL_NUM_MISSING');
648: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);
649: fnd_message.set_token('INV_ORG_ID',p_instance_rec.inv_organization_id);
650: fnd_msg_pub.add;
651: RAISE fnd_api.g_exc_error;
652:
645: IF nvl(p_instance_rec.serial_number, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN
646:
647: fnd_message.set_name('CSI','CSI_TXN_SERIAL_NUM_MISSING');
648: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);
649: fnd_message.set_token('INV_ORG_ID',p_instance_rec.inv_organization_id);
650: fnd_msg_pub.add;
651: RAISE fnd_api.g_exc_error;
652:
653: END IF;
656:
657: -- lot control
658: IF p_item_attr_rec.lot_control_flag = 'Y' THEN
659: IF nvl(p_instance_rec.lot_number, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN
660: fnd_message.set_name('CSI','CSI_TXN_LOT_NUM_MISSING');
661: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);
662: fnd_message.set_token('INV_ORG_ID',p_instance_rec.inv_organization_id);
663: fnd_msg_pub.add;
664: RAISE fnd_api.g_exc_error;
657: -- lot control
658: IF p_item_attr_rec.lot_control_flag = 'Y' THEN
659: IF nvl(p_instance_rec.lot_number, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN
660: fnd_message.set_name('CSI','CSI_TXN_LOT_NUM_MISSING');
661: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);
662: fnd_message.set_token('INV_ORG_ID',p_instance_rec.inv_organization_id);
663: fnd_msg_pub.add;
664: RAISE fnd_api.g_exc_error;
665: END IF;
658: IF p_item_attr_rec.lot_control_flag = 'Y' THEN
659: IF nvl(p_instance_rec.lot_number, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN
660: fnd_message.set_name('CSI','CSI_TXN_LOT_NUM_MISSING');
661: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);
662: fnd_message.set_token('INV_ORG_ID',p_instance_rec.inv_organization_id);
663: fnd_msg_pub.add;
664: RAISE fnd_api.g_exc_error;
665: END IF;
666: END IF;
667:
668: -- revision control
669: IF p_item_attr_rec.revision_control_flag = 'Y' THEN
670: IF nvl(p_instance_rec.inventory_revision, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN
671: fnd_message.set_name('CSI','CSI_TXN_ITEM_REV_MISSING');
672: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);
673: fnd_message.set_token('INV_ORG_ID',p_instance_rec.inv_organization_id);
674: fnd_msg_pub.add;
675: RAISE fnd_api.g_exc_error;
668: -- revision control
669: IF p_item_attr_rec.revision_control_flag = 'Y' THEN
670: IF nvl(p_instance_rec.inventory_revision, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN
671: fnd_message.set_name('CSI','CSI_TXN_ITEM_REV_MISSING');
672: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);
673: fnd_message.set_token('INV_ORG_ID',p_instance_rec.inv_organization_id);
674: fnd_msg_pub.add;
675: RAISE fnd_api.g_exc_error;
676: END IF;
669: IF p_item_attr_rec.revision_control_flag = 'Y' THEN
670: IF nvl(p_instance_rec.inventory_revision, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN
671: fnd_message.set_name('CSI','CSI_TXN_ITEM_REV_MISSING');
672: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);
673: fnd_message.set_token('INV_ORG_ID',p_instance_rec.inv_organization_id);
674: fnd_msg_pub.add;
675: RAISE fnd_api.g_exc_error;
676: END IF;
677: END IF;
680: /*
681: -- elliminated this validation as core API does this
682: IF p_item_attr_rec.locator_control_flag = 'Y' THEN
683: IF nvl(p_instance_rec.inv_locator_id , fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
684: fnd_message.set_name('CSI','CSI_TXN_LOCATOR_MISSING');
685: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);
686: fnd_message.set_token('INV_ORG_ID',p_instance_rec.inv_organization_id);
687: fnd_msg_pub.add;
688: RAISE fnd_api.g_exc_error;
681: -- elliminated this validation as core API does this
682: IF p_item_attr_rec.locator_control_flag = 'Y' THEN
683: IF nvl(p_instance_rec.inv_locator_id , fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
684: fnd_message.set_name('CSI','CSI_TXN_LOCATOR_MISSING');
685: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);
686: fnd_message.set_token('INV_ORG_ID',p_instance_rec.inv_organization_id);
687: fnd_msg_pub.add;
688: RAISE fnd_api.g_exc_error;
689: END IF;
682: IF p_item_attr_rec.locator_control_flag = 'Y' THEN
683: IF nvl(p_instance_rec.inv_locator_id , fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
684: fnd_message.set_name('CSI','CSI_TXN_LOCATOR_MISSING');
685: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);
686: fnd_message.set_token('INV_ORG_ID',p_instance_rec.inv_organization_id);
687: fnd_msg_pub.add;
688: RAISE fnd_api.g_exc_error;
689: END IF;
690: END IF;
1316: /* receive from customer */
1317: IF p_in_out_flag = 'IN' and l_change_owner = 'Y' THEN
1318: x_instance_id := fnd_api.g_miss_num;
1319: ELSE
1320: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1321: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);
1322: fnd_message.set_token('INV_ORG_ID',p_instance_rec.inv_organization_id);
1323: fnd_message.set_token('SUBINV',p_instance_rec.inv_subinventory_name);
1324: fnd_message.set_token('LOCATOR',p_instance_rec.inv_locator_id);
1317: IF p_in_out_flag = 'IN' and l_change_owner = 'Y' THEN
1318: x_instance_id := fnd_api.g_miss_num;
1319: ELSE
1320: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1321: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);
1322: fnd_message.set_token('INV_ORG_ID',p_instance_rec.inv_organization_id);
1323: fnd_message.set_token('SUBINV',p_instance_rec.inv_subinventory_name);
1324: fnd_message.set_token('LOCATOR',p_instance_rec.inv_locator_id);
1325: fnd_msg_pub.add;
1318: x_instance_id := fnd_api.g_miss_num;
1319: ELSE
1320: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1321: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);
1322: fnd_message.set_token('INV_ORG_ID',p_instance_rec.inv_organization_id);
1323: fnd_message.set_token('SUBINV',p_instance_rec.inv_subinventory_name);
1324: fnd_message.set_token('LOCATOR',p_instance_rec.inv_locator_id);
1325: fnd_msg_pub.add;
1326: RAISE fnd_api.g_exc_error;
1319: ELSE
1320: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1321: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);
1322: fnd_message.set_token('INV_ORG_ID',p_instance_rec.inv_organization_id);
1323: fnd_message.set_token('SUBINV',p_instance_rec.inv_subinventory_name);
1324: fnd_message.set_token('LOCATOR',p_instance_rec.inv_locator_id);
1325: fnd_msg_pub.add;
1326: RAISE fnd_api.g_exc_error;
1327: END IF;
1320: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1321: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);
1322: fnd_message.set_token('INV_ORG_ID',p_instance_rec.inv_organization_id);
1323: fnd_message.set_token('SUBINV',p_instance_rec.inv_subinventory_name);
1324: fnd_message.set_token('LOCATOR',p_instance_rec.inv_locator_id);
1325: fnd_msg_pub.add;
1326: RAISE fnd_api.g_exc_error;
1327: END IF;
1328:
1331: EXCEPTION
1332: WHEN skip_instance_search THEN
1333: x_return_status := fnd_api.g_ret_sts_success;
1334: WHEN instance_not_found THEN
1335: fnd_message.set_name('CSI','CSI_TXN_INST_NOT_FOUND');
1336: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);
1337: fnd_message.set_token('INV_ORG_ID',p_instance_rec.inv_organization_id);
1338: fnd_message.set_token('SUBINV',p_instance_rec.inv_subinventory_name);
1339: fnd_message.set_token('LOCATOR',p_instance_rec.inv_locator_id);
1332: WHEN skip_instance_search THEN
1333: x_return_status := fnd_api.g_ret_sts_success;
1334: WHEN instance_not_found THEN
1335: fnd_message.set_name('CSI','CSI_TXN_INST_NOT_FOUND');
1336: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);
1337: fnd_message.set_token('INV_ORG_ID',p_instance_rec.inv_organization_id);
1338: fnd_message.set_token('SUBINV',p_instance_rec.inv_subinventory_name);
1339: fnd_message.set_token('LOCATOR',p_instance_rec.inv_locator_id);
1340: fnd_msg_pub.add;
1333: x_return_status := fnd_api.g_ret_sts_success;
1334: WHEN instance_not_found THEN
1335: fnd_message.set_name('CSI','CSI_TXN_INST_NOT_FOUND');
1336: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);
1337: fnd_message.set_token('INV_ORG_ID',p_instance_rec.inv_organization_id);
1338: fnd_message.set_token('SUBINV',p_instance_rec.inv_subinventory_name);
1339: fnd_message.set_token('LOCATOR',p_instance_rec.inv_locator_id);
1340: fnd_msg_pub.add;
1341: x_return_status := fnd_api.g_ret_sts_error;
1334: WHEN instance_not_found THEN
1335: fnd_message.set_name('CSI','CSI_TXN_INST_NOT_FOUND');
1336: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);
1337: fnd_message.set_token('INV_ORG_ID',p_instance_rec.inv_organization_id);
1338: fnd_message.set_token('SUBINV',p_instance_rec.inv_subinventory_name);
1339: fnd_message.set_token('LOCATOR',p_instance_rec.inv_locator_id);
1340: fnd_msg_pub.add;
1341: x_return_status := fnd_api.g_ret_sts_error;
1342:
1335: fnd_message.set_name('CSI','CSI_TXN_INST_NOT_FOUND');
1336: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);
1337: fnd_message.set_token('INV_ORG_ID',p_instance_rec.inv_organization_id);
1338: fnd_message.set_token('SUBINV',p_instance_rec.inv_subinventory_name);
1339: fnd_message.set_token('LOCATOR',p_instance_rec.inv_locator_id);
1340: fnd_msg_pub.add;
1341: x_return_status := fnd_api.g_ret_sts_error;
1342:
1343: WHEN fnd_api.g_exc_error THEN
1479: debug('only 1 of the '||l_instance_header_tbl.COUNT||' instances found is unexpired');
1480: x_instance_id := l_instance_header_tbl(l_unexpired_instance_index).instance_id;
1481: ELSE
1482:
1483: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1484: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);
1485: fnd_message.set_token('INV_ORG_ID',p_dest_location_rec.inv_organization_id);
1486: fnd_message.set_token('SUBINV',p_dest_location_rec.inv_subinventory_name);
1487: fnd_message.set_token('LOCATOR',p_dest_location_rec.inv_locator_id);
1480: x_instance_id := l_instance_header_tbl(l_unexpired_instance_index).instance_id;
1481: ELSE
1482:
1483: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1484: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);
1485: fnd_message.set_token('INV_ORG_ID',p_dest_location_rec.inv_organization_id);
1486: fnd_message.set_token('SUBINV',p_dest_location_rec.inv_subinventory_name);
1487: fnd_message.set_token('LOCATOR',p_dest_location_rec.inv_locator_id);
1488:
1481: ELSE
1482:
1483: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1484: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);
1485: fnd_message.set_token('INV_ORG_ID',p_dest_location_rec.inv_organization_id);
1486: fnd_message.set_token('SUBINV',p_dest_location_rec.inv_subinventory_name);
1487: fnd_message.set_token('LOCATOR',p_dest_location_rec.inv_locator_id);
1488:
1489: fnd_msg_pub.add;
1482:
1483: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1484: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);
1485: fnd_message.set_token('INV_ORG_ID',p_dest_location_rec.inv_organization_id);
1486: fnd_message.set_token('SUBINV',p_dest_location_rec.inv_subinventory_name);
1487: fnd_message.set_token('LOCATOR',p_dest_location_rec.inv_locator_id);
1488:
1489: fnd_msg_pub.add;
1490: RAISE fnd_api.g_exc_error;
1483: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1484: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);
1485: fnd_message.set_token('INV_ORG_ID',p_dest_location_rec.inv_organization_id);
1486: fnd_message.set_token('SUBINV',p_dest_location_rec.inv_subinventory_name);
1487: fnd_message.set_token('LOCATOR',p_dest_location_rec.inv_locator_id);
1488:
1489: fnd_msg_pub.add;
1490: RAISE fnd_api.g_exc_error;
1491:
1492: END IF;
1493:
1494: EXCEPTION
1495: WHEN instance_not_found THEN
1496: fnd_message.set_name('CSI','CSI_TXN_INST_NOT_FOUND');
1497: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);
1498: fnd_message.set_token('INV_ORG_ID',p_instance_rec.inv_organization_id);
1499: fnd_msg_pub.add;
1500: x_return_status := fnd_api.g_ret_sts_error;
1493:
1494: EXCEPTION
1495: WHEN instance_not_found THEN
1496: fnd_message.set_name('CSI','CSI_TXN_INST_NOT_FOUND');
1497: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);
1498: fnd_message.set_token('INV_ORG_ID',p_instance_rec.inv_organization_id);
1499: fnd_msg_pub.add;
1500: x_return_status := fnd_api.g_ret_sts_error;
1501:
1494: EXCEPTION
1495: WHEN instance_not_found THEN
1496: fnd_message.set_name('CSI','CSI_TXN_INST_NOT_FOUND');
1497: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);
1498: fnd_message.set_token('INV_ORG_ID',p_instance_rec.inv_organization_id);
1499: fnd_msg_pub.add;
1500: x_return_status := fnd_api.g_ret_sts_error;
1501:
1502: WHEN fnd_api.g_exc_error THEN
3826: l_u_instance_rec.quantity <> 1 THEN
3827: debug('Serial Number (' || p_instance_rec.serial_number || ') already issued to WIP Job');
3828: debug('Trying to update Serialized instance (' || p_instance_rec.serial_number
3829: ||') with quanity more than 1');
3830: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_QUANTITY');
3831: FND_MESSAGE.SET_TOKEN('QUANTITY',l_u_instance_rec.quantity);
3832: FND_MSG_PUB.Add;
3833: RAISE fnd_api.g_exc_error;
3834: END IF;
3827: debug('Serial Number (' || p_instance_rec.serial_number || ') already issued to WIP Job');
3828: debug('Trying to update Serialized instance (' || p_instance_rec.serial_number
3829: ||') with quanity more than 1');
3830: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_QUANTITY');
3831: FND_MESSAGE.SET_TOKEN('QUANTITY',l_u_instance_rec.quantity);
3832: FND_MSG_PUB.Add;
3833: RAISE fnd_api.g_exc_error;
3834: END IF;
3835: