[Home] [Help]
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:
109: IF l_location_id is null THEN
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;
123:
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;
208:
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:
256: END IF;
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;
328:
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:
343: END IF;
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:
522: -- Serial Tagging ER 9977630
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;
654:
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:
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;
678:
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;
691: */
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:
1329: END IF;
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
1344: x_return_status := fnd_api.g_ret_sts_error;
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:
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
1503: x_return_status := fnd_api.g_ret_sts_error;
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:
3836: /* this routine derived the primary key references of the child */
4184:
4185: WHEN others THEN
4186: x_return_status := fnd_api.g_ret_sts_error;
4187:
4188: fnd_msg_pub.add_exc_msg(
4189: p_pkg_name => g_pkg_name,
4190: p_procedure_name => l_current_procedure);
4191:
4192: END process_ib;
4385:
4386: WHEN others THEN
4387: x_return_status := fnd_api.g_ret_sts_error;
4388:
4389: fnd_msg_pub.add_exc_msg(
4390: p_pkg_name => g_pkg_name,
4391: p_procedure_name => l_current_procedure);
4392:
4393: END process_relation;