DBA Data[Home] [Help]

APPS.CSI_PROCESS_TXN_PVT dependencies on FND_MESSAGE

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

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;

Line 103: fnd_message.set_token('INV_ORG_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;
107: END;

Line 104: fnd_message.set_token('SUBINV_ID',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;
108:

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

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;

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

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;

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

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:

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

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;

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

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;

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

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;

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

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:

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

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;

Line 322: fnd_message.set_token('PARTY_ID',p_txn_i_parties_tbl(l_p_ind).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;
326:

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

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;

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

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;

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

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;

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

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:

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

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;

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

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;

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

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:

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

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;

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

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:

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

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;

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

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;

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

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;

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

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;

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

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;

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

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;

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

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;

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

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;

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

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;

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

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;

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

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);

Line 1321: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_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;

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

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;

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

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;

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

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:

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

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);

Line 1336: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_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;

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

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;

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

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:

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

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

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

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);

Line 1484: fnd_message.set_token('INV_ITEM_ID',p_instance_rec.inventory_item_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:

Line 1485: fnd_message.set_token('INV_ORG_ID',p_dest_location_rec.inv_organization_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:
1489: fnd_msg_pub.add;

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

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;

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

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:

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

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;

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

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:

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

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

Line 3830: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_QUANTITY');

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;

Line 3831: FND_MESSAGE.SET_TOKEN('QUANTITY',l_u_instance_rec.quantity);

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: