[Home] [Help]
42: WHEN no_data_found THEN
43: fnd_message.set_name('CSI','CSI_INT_DEST_SUBINV_INVALID');
44: fnd_message.set_token('INV_ORG_ID',p_organization_id);
45: fnd_message.set_token('SUBINV_ID',p_subinventory_code);
46: fnd_msg_pub.add;
47: RAISE fnd_api.g_exc_error;
48: END;
49:
50: IF l_location_id is null THEN
56: EXCEPTION
57: WHEN no_data_found THEN
58: fnd_message.set_name('CSI','CSI_INT_DEST_ORG_ID_INVALID');
59: fnd_message.set_token('INV_ORG_ID',p_organization_id);
60: fnd_msg_pub.add;
61: RAISE fnd_api.g_exc_error;
62: END;
63: END IF;
64:
141:
142: fnd_message.set_name('CSI','CSI_INT_SUB_TYPE_REC_MISSING');
143: fnd_message.set_token('SUB_TYPE_ID',p_sub_type_id);
144: fnd_message.set_token('TRANSACTION_TYPE_ID',p_txn_type_id);
145: fnd_msg_pub.add;
146:
147: x_return_status := fnd_api.g_ret_sts_error;
148: END get_sub_type_rec;
149:
189: FROM sys.dual;
190:
191: fnd_message.set_name('CSI','CSI_TXN_SRC_REF_NOT_FOUND');
192: fnd_message.set_token('REF_TYPE',l_reference_code);
193: fnd_msg_pub.add;
194:
195: RAISE fnd_api.g_exc_error;
196:
197: END IF;
261:
262: fnd_message.set_name('CSI','CSI_INT_INV_PTY_ID');
263: fnd_message.set_token('PARTY_ID',p_txn_i_parties_tbl(l_p_ind).party_id);
264: fnd_message.set_token('INTERNAL_PARTY_ID',l_internal_party_id);
265: fnd_msg_pub.add;
266: RAISE fnd_api.g_exc_error;
267:
268: END IF;
269:
276: IF NOT (l_owner_found) THEN
277: fnd_message.set_name('CSI','CSI_TXN_OWNER_NOT_FOUND');
278: fnd_message.set_token('INDEX',l_i_ind);
279: fnd_message.set_token('ITEM_ID',p_txn_instances_tbl(l_i_ind).inventory_item_id);
280: fnd_msg_pub.add;
281: RAISE fnd_api.g_exc_error;
282: END IF;
283:
284: END IF;
450:
451: fnd_message.set_name('CSI','CSI_INT_ITEM_ID_MISSING');
452: fnd_message.set_token('INVENTORY_ITEM_ID',p_inventory_item_id);
453: fnd_message.set_token('INV_ORGANIZATION_ID',p_organization_id);
454: fnd_msg_pub.add;
455: RAISE fnd_api.g_exc_error;
456: END;
457:
458: IF l_serial_code = 1 THEN
546:
547: fnd_message.set_name('CSI','CSI_TXN_SERIAL_NUM_MISSING');
548: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);
549: fnd_message.set_token('INV_ORG_ID',p_instance_rec.inv_organization_id);
550: fnd_msg_pub.add;
551: RAISE fnd_api.g_exc_error;
552:
553: END IF;
554:
559: IF nvl(p_instance_rec.lot_number, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN
560: fnd_message.set_name('CSI','CSI_TXN_LOT_NUM_MISSING');
561: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);
562: fnd_message.set_token('INV_ORG_ID',p_instance_rec.inv_organization_id);
563: fnd_msg_pub.add;
564: RAISE fnd_api.g_exc_error;
565: END IF;
566: END IF;
567:
570: IF nvl(p_instance_rec.inventory_revision, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN
571: fnd_message.set_name('CSI','CSI_TXN_ITEM_REV_MISSING');
572: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);
573: fnd_message.set_token('INV_ORG_ID',p_instance_rec.inv_organization_id);
574: fnd_msg_pub.add;
575: RAISE fnd_api.g_exc_error;
576: END IF;
577: END IF;
578:
583: IF nvl(p_instance_rec.inv_locator_id , fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
584: fnd_message.set_name('CSI','CSI_TXN_LOCATOR_MISSING');
585: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);
586: fnd_message.set_token('INV_ORG_ID',p_instance_rec.inv_organization_id);
587: fnd_msg_pub.add;
588: RAISE fnd_api.g_exc_error;
589: END IF;
590: END IF;
591: */
1112: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);
1113: fnd_message.set_token('INV_ORG_ID',p_instance_rec.inv_organization_id);
1114: fnd_message.set_token('SUBINV',p_instance_rec.inv_subinventory_name);
1115: fnd_message.set_token('LOCATOR',p_instance_rec.inv_locator_id);
1116: fnd_msg_pub.add;
1117: RAISE fnd_api.g_exc_error;
1118: END IF;
1119:
1120: END IF;
1125: WHEN instance_not_found THEN
1126: fnd_message.set_name('CSI','CSI_TXN_INST_NOT_FOUND');
1127: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);
1128: fnd_message.set_token('INV_ORG_ID',p_instance_rec.inv_organization_id);
1129: fnd_msg_pub.add;
1130: x_return_status := fnd_api.g_ret_sts_error;
1131:
1132: WHEN fnd_api.g_exc_error THEN
1133: x_return_status := fnd_api.g_ret_sts_error;
1223: fnd_message.set_token('INV_ORG_ID',p_dest_location_rec.inv_organization_id);
1224: fnd_message.set_token('SUBINV',p_dest_location_rec.inv_subinventory_name);
1225: fnd_message.set_token('LOCATOR',p_dest_location_rec.inv_locator_id);
1226:
1227: fnd_msg_pub.add;
1228: RAISE fnd_api.g_exc_error;
1229:
1230: END IF;
1231:
1233: WHEN instance_not_found THEN
1234: fnd_message.set_name('CSI','CSI_TXN_INST_NOT_FOUND');
1235: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);
1236: fnd_message.set_token('INV_ORG_ID',p_instance_rec.inv_organization_id);
1237: fnd_msg_pub.add;
1238: x_return_status := fnd_api.g_ret_sts_error;
1239:
1240: WHEN fnd_api.g_exc_error THEN
1241: x_return_status := fnd_api.g_ret_sts_error;
3820:
3821: WHEN others THEN
3822: x_return_status := fnd_api.g_ret_sts_error;
3823:
3824: fnd_msg_pub.add_exc_msg(
3825: p_pkg_name => g_pkg_name,
3826: p_procedure_name => l_current_procedure);
3827:
3828: END process_ib;
4021:
4022: WHEN others THEN
4023: x_return_status := fnd_api.g_ret_sts_error;
4024:
4025: fnd_msg_pub.add_exc_msg(
4026: p_pkg_name => g_pkg_name,
4027: p_procedure_name => l_current_procedure);
4028:
4029: END process_relation;