DBA Data[Home] [Help]

APPS.CSI_PROCESS_TXN_PVT dependencies on FND_MESSAGE

Line 43: fnd_message.set_name('CSI','CSI_INT_DEST_SUBINV_INVALID');

39: WHERE organization_id = p_organization_id
40: AND secondary_inventory_name = p_subinventory_code;
41: EXCEPTION
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;

Line 44: fnd_message.set_token('INV_ORG_ID',p_organization_id);

40: AND secondary_inventory_name = p_subinventory_code;
41: EXCEPTION
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;

Line 45: fnd_message.set_token('SUBINV_ID',p_subinventory_code);

41: EXCEPTION
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:

Line 58: fnd_message.set_name('CSI','CSI_INT_DEST_ORG_ID_INVALID');

54: FROM hr_organization_units
55: WHERE organization_id = p_organization_id;
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;

Line 59: fnd_message.set_token('INV_ORG_ID',p_organization_id);

55: WHERE organization_id = p_organization_id;
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;

Line 142: fnd_message.set_name('CSI','CSI_INT_SUB_TYPE_REC_MISSING');

138:
139: EXCEPTION
140: WHEN no_data_found THEN
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:

Line 143: fnd_message.set_token('SUB_TYPE_ID',p_sub_type_id);

139: EXCEPTION
140: WHEN no_data_found THEN
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;

Line 144: fnd_message.set_token('TRANSACTION_TYPE_ID',p_txn_type_id);

140: WHEN no_data_found THEN
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;

Line 191: fnd_message.set_name('CSI','CSI_TXN_SRC_REF_NOT_FOUND');

187: SELECT decode(p_reference_type,'P','Parent','N','Non Source','S','Source')
188: INTO l_reference_code
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;

Line 192: fnd_message.set_token('REF_TYPE',l_reference_code);

188: INTO l_reference_code
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:

Line 262: fnd_message.set_name('CSI','CSI_INT_INV_PTY_ID');

258: p_txn_i_parties_tbl(l_p_ind).party_id <> l_internal_party_id
259: )
260: THEN
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;

Line 263: fnd_message.set_token('PARTY_ID',p_txn_i_parties_tbl(l_p_ind).party_id);

259: )
260: THEN
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:

Line 264: fnd_message.set_token('INTERNAL_PARTY_ID',l_internal_party_id);

260: THEN
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;

Line 277: fnd_message.set_name('CSI','CSI_TXN_OWNER_NOT_FOUND');

273: END LOOP;
274: END IF;
275:
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;

Line 278: fnd_message.set_token('INDEX',l_i_ind);

274: END IF;
275:
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;

Line 279: fnd_message.set_token('ITEM_ID',p_txn_instances_tbl(l_i_ind).inventory_item_id);

275:
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:

Line 451: fnd_message.set_name('CSI','CSI_INT_ITEM_ID_MISSING');

447:
448: EXCEPTION
449: WHEN no_data_found THEN
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;

Line 452: fnd_message.set_token('INVENTORY_ITEM_ID',p_inventory_item_id);

448: EXCEPTION
449: WHEN no_data_found THEN
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;

Line 453: fnd_message.set_token('INV_ORGANIZATION_ID',p_organization_id);

449: WHEN no_data_found THEN
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:

Line 547: fnd_message.set_name('CSI','CSI_TXN_SERIAL_NUM_MISSING');

543: THEN
544:
545: IF nvl(p_instance_rec.serial_number, fnd_api.g_miss_char) = fnd_api.g_miss_char 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;

Line 548: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);

544:
545: IF nvl(p_instance_rec.serial_number, fnd_api.g_miss_char) = fnd_api.g_miss_char 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:

Line 549: fnd_message.set_token('INV_ORG_ID',p_instance_rec.inv_organization_id);

545: IF nvl(p_instance_rec.serial_number, fnd_api.g_miss_char) = fnd_api.g_miss_char 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;

Line 560: fnd_message.set_name('CSI','CSI_TXN_LOT_NUM_MISSING');

556:
557: -- lot control
558: IF p_item_attr_rec.lot_control_flag = 'Y' THEN
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;

Line 561: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);

557: -- lot control
558: IF p_item_attr_rec.lot_control_flag = 'Y' THEN
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;

Line 562: fnd_message.set_token('INV_ORG_ID',p_instance_rec.inv_organization_id);

558: IF p_item_attr_rec.lot_control_flag = 'Y' THEN
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;

Line 571: fnd_message.set_name('CSI','CSI_TXN_ITEM_REV_MISSING');

567:
568: -- revision control
569: IF p_item_attr_rec.revision_control_flag = 'Y' THEN
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;

Line 572: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);

568: -- revision control
569: IF p_item_attr_rec.revision_control_flag = 'Y' THEN
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;

Line 573: fnd_message.set_token('INV_ORG_ID',p_instance_rec.inv_organization_id);

569: IF p_item_attr_rec.revision_control_flag = 'Y' THEN
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;

Line 584: fnd_message.set_name('CSI','CSI_TXN_LOCATOR_MISSING');

580: /*
581: -- elliminated this validation as core API does this
582: IF p_item_attr_rec.locator_control_flag = 'Y' THEN
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;

Line 585: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);

581: -- elliminated this validation as core API does this
582: IF p_item_attr_rec.locator_control_flag = 'Y' THEN
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;

Line 586: fnd_message.set_token('INV_ORG_ID',p_instance_rec.inv_organization_id);

582: IF p_item_attr_rec.locator_control_flag = 'Y' THEN
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;

Line 1111: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');

1107: /* receive from customer */
1108: IF p_in_out_flag = 'IN' and l_change_owner = 'Y' THEN
1109: x_instance_id := fnd_api.g_miss_num;
1110: ELSE
1111: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
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);

Line 1112: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);

1108: IF p_in_out_flag = 'IN' and l_change_owner = 'Y' THEN
1109: x_instance_id := fnd_api.g_miss_num;
1110: ELSE
1111: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
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;

Line 1113: fnd_message.set_token('INV_ORG_ID',p_instance_rec.inv_organization_id);

1109: x_instance_id := fnd_api.g_miss_num;
1110: ELSE
1111: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
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;

Line 1114: fnd_message.set_token('SUBINV',p_instance_rec.inv_subinventory_name);

1110: ELSE
1111: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
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;

Line 1115: fnd_message.set_token('LOCATOR',p_instance_rec.inv_locator_id);

1111: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
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:

Line 1126: fnd_message.set_name('CSI','CSI_TXN_INST_NOT_FOUND');

1122: EXCEPTION
1123: WHEN skip_instance_search THEN
1124: x_return_status := fnd_api.g_ret_sts_success;
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;

Line 1127: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);

1123: WHEN skip_instance_search THEN
1124: x_return_status := fnd_api.g_ret_sts_success;
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:

Line 1128: fnd_message.set_token('INV_ORG_ID',p_instance_rec.inv_organization_id);

1124: x_return_status := fnd_api.g_ret_sts_success;
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

Line 1221: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');

1217: ELSIF l_instance_header_tbl.COUNT = 1 THEN
1218: x_instance_id := l_instance_header_tbl(1).instance_id;
1219: ELSE
1220:
1221: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1222: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);
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);

Line 1222: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);

1218: x_instance_id := l_instance_header_tbl(1).instance_id;
1219: ELSE
1220:
1221: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1222: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);
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:

Line 1223: fnd_message.set_token('INV_ORG_ID',p_dest_location_rec.inv_organization_id);

1219: ELSE
1220:
1221: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1222: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);
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;

Line 1224: fnd_message.set_token('SUBINV',p_dest_location_rec.inv_subinventory_name);

1220:
1221: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1222: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);
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;

Line 1225: fnd_message.set_token('LOCATOR',p_dest_location_rec.inv_locator_id);

1221: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
1222: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);
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:

Line 1234: fnd_message.set_name('CSI','CSI_TXN_INST_NOT_FOUND');

1230: END IF;
1231:
1232: EXCEPTION
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;

Line 1235: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_id);

1231:
1232: EXCEPTION
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:

Line 1236: fnd_message.set_token('INV_ORG_ID',p_instance_rec.inv_organization_id);

1232: EXCEPTION
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