eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_INTERFACE_PKG dependencies on FND_MESSAGE

Line 71: fnd_message.set_name('CSI', 'CSI_DFLT_SUB_TYPE_MISSING');

67: WHERE transaction_type_id = p_transaction_type_id
68: AND default_flag = 'Y';
69: EXCEPTION
70: WHEN no_data_found THEN
71: fnd_message.set_name('CSI', 'CSI_DFLT_SUB_TYPE_MISSING');
72: fnd_message.set_token('TXN_TYPE_ID',p_transaction_type_id);
73: fnd_msg_pub.add;
74: RAISE fnd_api.g_exc_error;
75: WHEN too_many_rows THEN

Line 72: fnd_message.set_token('TXN_TYPE_ID',p_transaction_type_id);

68: AND default_flag = 'Y';
69: EXCEPTION
70: WHEN no_data_found THEN
71: fnd_message.set_name('CSI', 'CSI_DFLT_SUB_TYPE_MISSING');
72: fnd_message.set_token('TXN_TYPE_ID',p_transaction_type_id);
73: fnd_msg_pub.add;
74: RAISE fnd_api.g_exc_error;
75: WHEN too_many_rows THEN
76: fnd_message.set_name('CSI', 'CSI_MANY_DFLT_SUB_TYPES');

Line 76: fnd_message.set_name('CSI', 'CSI_MANY_DFLT_SUB_TYPES');

72: fnd_message.set_token('TXN_TYPE_ID',p_transaction_type_id);
73: fnd_msg_pub.add;
74: RAISE fnd_api.g_exc_error;
75: WHEN too_many_rows THEN
76: fnd_message.set_name('CSI', 'CSI_MANY_DFLT_SUB_TYPES');
77: fnd_message.set_token('TXN_TYPE_ID',p_transaction_type_id);
78: fnd_msg_pub.add;
79: RAISE fnd_api.g_exc_error;
80: END;

Line 77: fnd_message.set_token('TXN_TYPE_ID',p_transaction_type_id);

73: fnd_msg_pub.add;
74: RAISE fnd_api.g_exc_error;
75: WHEN too_many_rows THEN
76: fnd_message.set_name('CSI', 'CSI_MANY_DFLT_SUB_TYPES');
77: fnd_message.set_token('TXN_TYPE_ID',p_transaction_type_id);
78: fnd_msg_pub.add;
79: RAISE fnd_api.g_exc_error;
80: END;
81: EXCEPTION

Line 644: fnd_message.set_name('CSI','CSI_FND_INVALID_SCHEMA_ERROR');

640: -- For Bug 3431768
641: l_return := FND_INSTALLATION.get_app_info('INV',l_status,l_industry,l_oracle_schema);
642:
643: IF NOT l_return THEN
644: fnd_message.set_name('CSI','CSI_FND_INVALID_SCHEMA_ERROR');
645: fnd_msg_pub.add;
646: RAISE fnd_api.g_exc_error;
647: END IF;
648: -- End fix for Bug 3431768

Line 2728: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');

2724: x_partner_order_rec => l_partner_rec);
2725:
2726: IF l_partner_rec.IB_OWNER = 'END_CUSTOMER' THEN
2727: IF l_partner_rec.END_CUSTOMER_ID is null Then
2728: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
2729: fnd_msg_pub.add;
2730: raise fnd_api.g_exc_error;
2731: ELSE
2732: l_ib_owner := l_partner_rec.ib_owner;

Line 2750: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');

2746: IF x_source_line_rec.ib_install_loc = 'END_CUSTOMER'
2747: THEN
2748: IF l_partner_rec.end_customer_site_use_id is null
2749: THEN
2750: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
2751: fnd_msg_pub.add;
2752: raise fnd_api.g_exc_error;
2753: ELSE
2754: x_source_line_rec.ib_install_loc_id := l_partner_rec.end_customer_site_use_id;

Line 2760: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');

2756: ELSIF x_source_line_rec.ib_install_loc = 'SHIP_TO'
2757: THEN
2758: IF x_source_line_rec.ship_to_address_id is null
2759: THEN
2760: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
2761: fnd_msg_pub.add;
2762: raise fnd_api.g_exc_error;
2763: ELSE
2764: x_source_line_rec.ib_install_loc_id := x_source_line_rec.ship_to_address_id;

Line 2770: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');

2766: ELSIF x_source_line_rec.ib_install_loc = 'SOLD_TO'
2767: THEN
2768: IF l_partner_rec.SOLD_TO_SITE_USE_ID is null -- 3412544 x_source_line_rec.sold_to_org_id is null
2769: THEN
2770: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
2771: fnd_msg_pub.add;
2772: raise fnd_api.g_exc_error;
2773: ELSE
2774: x_source_line_rec.ib_install_loc_id := l_partner_rec.SOLD_TO_SITE_USE_ID; -- 3412544 x_source_line_rec.sold_to_org_id;

Line 2780: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');

2776: ELSIF x_source_line_rec.ib_install_loc = 'DELIVER_TO'
2777: THEN
2778: IF x_source_line_rec.deliver_to_org_id is null
2779: THEN
2780: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
2781: fnd_msg_pub.add;
2782: raise fnd_api.g_exc_error;
2783: ELSE
2784: x_source_line_rec.ib_install_loc_id := x_source_line_rec.deliver_to_org_id;

Line 2790: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');

2786: ELSIF x_source_line_rec.ib_install_loc = 'BILL_TO'
2787: THEN
2788: IF x_source_line_rec.bill_to_address_id is null
2789: THEN
2790: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
2791: fnd_msg_pub.add;
2792: raise fnd_api.g_exc_error;
2793: ELSE
2794: x_source_line_rec.ib_install_loc_id := x_source_line_rec.bill_to_address_id;

Line 2811: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');

2807: IF x_source_line_rec.ib_current_loc = 'END_CUSTOMER'
2808: THEN
2809: IF l_partner_rec.end_customer_site_use_id is null
2810: THEN
2811: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
2812: fnd_msg_pub.add;
2813: raise fnd_api.g_exc_error;
2814: ELSE
2815: x_source_line_rec.ib_current_loc_id := l_partner_rec.end_customer_site_use_id;

Line 2821: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');

2817: ELSIF x_source_line_rec.ib_current_loc = 'SHIP_TO'
2818: THEN
2819: IF x_source_line_rec.ship_to_address_id is null
2820: THEN
2821: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
2822: fnd_msg_pub.add;
2823: raise fnd_api.g_exc_error;
2824: ELSE
2825: x_source_line_rec.ib_current_loc_id := x_source_line_rec.ship_to_address_id;

Line 2831: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');

2827: ELSIF x_source_line_rec.ib_current_loc = 'SOLD_TO'
2828: THEN
2829: IF l_partner_rec.SOLD_TO_SITE_USE_ID is null -- 3412544 x_source_line_rec.sold_to_org_id is null
2830: THEN
2831: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
2832: fnd_msg_pub.add;
2833: raise fnd_api.g_exc_error;
2834: ELSE
2835: x_source_line_rec.ib_current_loc_id := l_partner_rec.SOLD_TO_SITE_USE_ID; -- 3412544 x_source_line_rec.sold_to_org_id;

Line 2841: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');

2837: ELSIF x_source_line_rec.ib_current_loc = 'DELIVER_TO'
2838: THEN
2839: IF x_source_line_rec.deliver_to_org_id is null
2840: THEN
2841: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
2842: fnd_msg_pub.add;
2843: raise fnd_api.g_exc_error;
2844: ELSE
2845: x_source_line_rec.ib_current_loc_id := x_source_line_rec.deliver_to_org_id;

Line 2851: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');

2847: ELSIF x_source_line_rec.ib_current_loc = 'BILL_TO'
2848: THEN
2849: IF x_source_line_rec.bill_to_address_id is null
2850: THEN
2851: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
2852: fnd_msg_pub.add;
2853: raise fnd_api.g_exc_error;
2854: ELSE
2855: x_source_line_rec.ib_current_loc_id := x_source_line_rec.bill_to_address_id;

Line 3178: fnd_message.set_name('CSI', 'CSI_NETWORK_PARTNER_NOT_FOUND');

3174: END;
3175: END LOOP;
3176:
3177: IF NOT(l_partner_location_found) THEN
3178: fnd_message.set_name('CSI', 'CSI_NETWORK_PARTNER_NOT_FOUND');
3179: fnd_message.set_token('INST_HDR_ID', p_instance_key.inst_hdr_id);
3180: fnd_message.set_token('INST_ITEM_ID', p_instance_key.inst_item_id);
3181: fnd_message.set_token('INST_REV_NUM', p_instance_key.inst_rev_num);
3182: fnd_msg_pub.add;

Line 3179: fnd_message.set_token('INST_HDR_ID', p_instance_key.inst_hdr_id);

3175: END LOOP;
3176:
3177: IF NOT(l_partner_location_found) THEN
3178: fnd_message.set_name('CSI', 'CSI_NETWORK_PARTNER_NOT_FOUND');
3179: fnd_message.set_token('INST_HDR_ID', p_instance_key.inst_hdr_id);
3180: fnd_message.set_token('INST_ITEM_ID', p_instance_key.inst_item_id);
3181: fnd_message.set_token('INST_REV_NUM', p_instance_key.inst_rev_num);
3182: fnd_msg_pub.add;
3183: RAISE fnd_api.g_exc_error;

Line 3180: fnd_message.set_token('INST_ITEM_ID', p_instance_key.inst_item_id);

3176:
3177: IF NOT(l_partner_location_found) THEN
3178: fnd_message.set_name('CSI', 'CSI_NETWORK_PARTNER_NOT_FOUND');
3179: fnd_message.set_token('INST_HDR_ID', p_instance_key.inst_hdr_id);
3180: fnd_message.set_token('INST_ITEM_ID', p_instance_key.inst_item_id);
3181: fnd_message.set_token('INST_REV_NUM', p_instance_key.inst_rev_num);
3182: fnd_msg_pub.add;
3183: RAISE fnd_api.g_exc_error;
3184: END IF;

Line 3181: fnd_message.set_token('INST_REV_NUM', p_instance_key.inst_rev_num);

3177: IF NOT(l_partner_location_found) THEN
3178: fnd_message.set_name('CSI', 'CSI_NETWORK_PARTNER_NOT_FOUND');
3179: fnd_message.set_token('INST_HDR_ID', p_instance_key.inst_hdr_id);
3180: fnd_message.set_token('INST_ITEM_ID', p_instance_key.inst_item_id);
3181: fnd_message.set_token('INST_REV_NUM', p_instance_key.inst_rev_num);
3182: fnd_msg_pub.add;
3183: RAISE fnd_api.g_exc_error;
3184: END IF;
3185:

Line 3364: fnd_message.set_name('CSI','CSI_INT_INV_INSTA_PTY_ID');

3360: AND ((active_end_date is null ) OR
3361: (active_end_date > sysdate));
3362: EXCEPTION
3363: WHEN no_data_found THEN
3364: fnd_message.set_name('CSI','CSI_INT_INV_INSTA_PTY_ID');
3365: fnd_message.set_token('INSTANCE_ID',l_i_rec.instance_id);
3366: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_txn_party_tbl(l_p_ind).relationship_type_code);
3367: fnd_msg_pub.add;
3368: IF p_txn_party_tbl(l_p_ind).relationship_type_code = 'OWNER' THEN

Line 3365: fnd_message.set_token('INSTANCE_ID',l_i_rec.instance_id);

3361: (active_end_date > sysdate));
3362: EXCEPTION
3363: WHEN no_data_found THEN
3364: fnd_message.set_name('CSI','CSI_INT_INV_INSTA_PTY_ID');
3365: fnd_message.set_token('INSTANCE_ID',l_i_rec.instance_id);
3366: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_txn_party_tbl(l_p_ind).relationship_type_code);
3367: fnd_msg_pub.add;
3368: IF p_txn_party_tbl(l_p_ind).relationship_type_code = 'OWNER' THEN
3369: x_return_status := fnd_api.g_ret_sts_error;

Line 3366: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_txn_party_tbl(l_p_ind).relationship_type_code);

3362: EXCEPTION
3363: WHEN no_data_found THEN
3364: fnd_message.set_name('CSI','CSI_INT_INV_INSTA_PTY_ID');
3365: fnd_message.set_token('INSTANCE_ID',l_i_rec.instance_id);
3366: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_txn_party_tbl(l_p_ind).relationship_type_code);
3367: fnd_msg_pub.add;
3368: IF p_txn_party_tbl(l_p_ind).relationship_type_code = 'OWNER' THEN
3369: x_return_status := fnd_api.g_ret_sts_error;
3370: raise fnd_api.g_exc_error;

Line 3376: fnd_message.set_name('CSI','CSI_INT_MANY_INSTA_PTY_FOUND');

3372: p_txn_party_tbl(l_pc_ind).contact_party_id := p_ind;
3373: debug('relationship_type_code :'||p_txn_party_tbl(l_p_ind).relationship_type_code);
3374: END IF;
3375: WHEN too_many_rows THEN
3376: fnd_message.set_name('CSI','CSI_INT_MANY_INSTA_PTY_FOUND');
3377: fnd_message.set_token('INSTANCE_ID',l_i_rec.instance_id);
3378: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_txn_party_tbl(l_p_ind).relationship_type_code);
3379: fnd_msg_pub.add;
3380: x_return_status := fnd_api.g_ret_sts_error;

Line 3377: fnd_message.set_token('INSTANCE_ID',l_i_rec.instance_id);

3373: debug('relationship_type_code :'||p_txn_party_tbl(l_p_ind).relationship_type_code);
3374: END IF;
3375: WHEN too_many_rows THEN
3376: fnd_message.set_name('CSI','CSI_INT_MANY_INSTA_PTY_FOUND');
3377: fnd_message.set_token('INSTANCE_ID',l_i_rec.instance_id);
3378: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_txn_party_tbl(l_p_ind).relationship_type_code);
3379: fnd_msg_pub.add;
3380: x_return_status := fnd_api.g_ret_sts_error;
3381: raise fnd_api.g_exc_error;

Line 3378: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_txn_party_tbl(l_p_ind).relationship_type_code);

3374: END IF;
3375: WHEN too_many_rows THEN
3376: fnd_message.set_name('CSI','CSI_INT_MANY_INSTA_PTY_FOUND');
3377: fnd_message.set_token('INSTANCE_ID',l_i_rec.instance_id);
3378: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_txn_party_tbl(l_p_ind).relationship_type_code);
3379: fnd_msg_pub.add;
3380: x_return_status := fnd_api.g_ret_sts_error;
3381: raise fnd_api.g_exc_error;
3382: END;

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

4287: WHERE transaction_type_id = px_txn_line_rec.source_transaction_type_id
4288: AND sub_type_id = px_txn_line_dtl_tbl(l_td_ind).sub_type_id;
4289: EXCEPTION
4290: WHEN no_data_found THEN
4291: fnd_message.set_name('CSI', 'CSI_INT_SUB_TYPE_REC_MISSING');
4292: fnd_message.set_token('SUB_TYPE_ID', px_txn_line_dtl_tbl(l_td_ind).sub_type_id);
4293: fnd_message.set_token('TRANSACTION_TYPE_ID',px_txn_line_rec.source_transaction_type_id);
4294: fnd_msg_pub.add;
4295: RAISE fnd_api.g_exc_error;

Line 4292: fnd_message.set_token('SUB_TYPE_ID', px_txn_line_dtl_tbl(l_td_ind).sub_type_id);

4288: AND sub_type_id = px_txn_line_dtl_tbl(l_td_ind).sub_type_id;
4289: EXCEPTION
4290: WHEN no_data_found THEN
4291: fnd_message.set_name('CSI', 'CSI_INT_SUB_TYPE_REC_MISSING');
4292: fnd_message.set_token('SUB_TYPE_ID', px_txn_line_dtl_tbl(l_td_ind).sub_type_id);
4293: fnd_message.set_token('TRANSACTION_TYPE_ID',px_txn_line_rec.source_transaction_type_id);
4294: fnd_msg_pub.add;
4295: RAISE fnd_api.g_exc_error;
4296: END;

Line 4293: fnd_message.set_token('TRANSACTION_TYPE_ID',px_txn_line_rec.source_transaction_type_id);

4289: EXCEPTION
4290: WHEN no_data_found THEN
4291: fnd_message.set_name('CSI', 'CSI_INT_SUB_TYPE_REC_MISSING');
4292: fnd_message.set_token('SUB_TYPE_ID', px_txn_line_dtl_tbl(l_td_ind).sub_type_id);
4293: fnd_message.set_token('TRANSACTION_TYPE_ID',px_txn_line_rec.source_transaction_type_id);
4294: fnd_msg_pub.add;
4295: RAISE fnd_api.g_exc_error;
4296: END;
4297:

Line 4844: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

4840: x_return_message := csi_t_gen_utility_pvt.dump_error_stack;
4841: debug('Error in Interface_IB: '||x_return_message);
4842: WHEN others THEN
4843:
4844: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
4845: fnd_message.set_token('MESSAGE', substr(sqlerrm, 1, 240));
4846: fnd_msg_pub.add;
4847:
4848: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 4845: fnd_message.set_token('MESSAGE', substr(sqlerrm, 1, 240));

4841: debug('Error in Interface_IB: '||x_return_message);
4842: WHEN others THEN
4843:
4844: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
4845: fnd_message.set_token('MESSAGE', substr(sqlerrm, 1, 240));
4846: fnd_msg_pub.add;
4847:
4848: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4849: x_return_message := csi_t_gen_utility_pvt.dump_error_stack;

Line 5209: fnd_message.set_name('CSI','CSI_INT_INV_INST_NOT_FOUND');

5205: l_mtl_tbl(l_ind).negative_instance_flag := 'Y';
5206: l_mtl_tbl(l_ind).instance_id := null;
5207: l_mtl_tbl(l_ind).object_version_num := null;
5208: ELSE
5209: fnd_message.set_name('CSI','CSI_INT_INV_INST_NOT_FOUND');
5210: fnd_message.set_token('INV_ITEM_ID',l_mtl_tbl(l_ind).inventory_item_id);
5211: fnd_message.set_token('INV_ORG_ID', l_mtl_tbl(l_ind).organization_id);
5212: fnd_message.set_token('SUBINV', l_mtl_tbl(l_ind).subinventory_code);
5213: fnd_message.set_token('LOCATOR', l_mtl_tbl(l_ind).locator_id);

Line 5210: fnd_message.set_token('INV_ITEM_ID',l_mtl_tbl(l_ind).inventory_item_id);

5206: l_mtl_tbl(l_ind).instance_id := null;
5207: l_mtl_tbl(l_ind).object_version_num := null;
5208: ELSE
5209: fnd_message.set_name('CSI','CSI_INT_INV_INST_NOT_FOUND');
5210: fnd_message.set_token('INV_ITEM_ID',l_mtl_tbl(l_ind).inventory_item_id);
5211: fnd_message.set_token('INV_ORG_ID', l_mtl_tbl(l_ind).organization_id);
5212: fnd_message.set_token('SUBINV', l_mtl_tbl(l_ind).subinventory_code);
5213: fnd_message.set_token('LOCATOR', l_mtl_tbl(l_ind).locator_id);
5214: fnd_msg_pub.add;

Line 5211: fnd_message.set_token('INV_ORG_ID', l_mtl_tbl(l_ind).organization_id);

5207: l_mtl_tbl(l_ind).object_version_num := null;
5208: ELSE
5209: fnd_message.set_name('CSI','CSI_INT_INV_INST_NOT_FOUND');
5210: fnd_message.set_token('INV_ITEM_ID',l_mtl_tbl(l_ind).inventory_item_id);
5211: fnd_message.set_token('INV_ORG_ID', l_mtl_tbl(l_ind).organization_id);
5212: fnd_message.set_token('SUBINV', l_mtl_tbl(l_ind).subinventory_code);
5213: fnd_message.set_token('LOCATOR', l_mtl_tbl(l_ind).locator_id);
5214: fnd_msg_pub.add;
5215: RAISE fnd_api.g_exc_error;

Line 5212: fnd_message.set_token('SUBINV', l_mtl_tbl(l_ind).subinventory_code);

5208: ELSE
5209: fnd_message.set_name('CSI','CSI_INT_INV_INST_NOT_FOUND');
5210: fnd_message.set_token('INV_ITEM_ID',l_mtl_tbl(l_ind).inventory_item_id);
5211: fnd_message.set_token('INV_ORG_ID', l_mtl_tbl(l_ind).organization_id);
5212: fnd_message.set_token('SUBINV', l_mtl_tbl(l_ind).subinventory_code);
5213: fnd_message.set_token('LOCATOR', l_mtl_tbl(l_ind).locator_id);
5214: fnd_msg_pub.add;
5215: RAISE fnd_api.g_exc_error;
5216: END IF;

Line 5213: fnd_message.set_token('LOCATOR', l_mtl_tbl(l_ind).locator_id);

5209: fnd_message.set_name('CSI','CSI_INT_INV_INST_NOT_FOUND');
5210: fnd_message.set_token('INV_ITEM_ID',l_mtl_tbl(l_ind).inventory_item_id);
5211: fnd_message.set_token('INV_ORG_ID', l_mtl_tbl(l_ind).organization_id);
5212: fnd_message.set_token('SUBINV', l_mtl_tbl(l_ind).subinventory_code);
5213: fnd_message.set_token('LOCATOR', l_mtl_tbl(l_ind).locator_id);
5214: fnd_msg_pub.add;
5215: RAISE fnd_api.g_exc_error;
5216: END IF;
5217: ELSE

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

5220: l_mtl_tbl(l_ind).object_version_num := l_inst_hdr_tbl(1).object_version_number;
5221: debug(' instance_id : '||l_mtl_tbl(l_ind).instance_id);
5222: debug(' instance_ovn : '||l_mtl_tbl(l_ind).object_version_num);
5223: ELSE
5224: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
5225: fnd_message.set_token('INV_ITEM_ID',l_mtl_tbl(l_ind).inventory_item_id);
5226: fnd_message.set_token('INV_ORG_ID', l_mtl_tbl(l_ind).organization_id);
5227: fnd_message.set_token('SUBINV', l_mtl_tbl(l_ind).subinventory_code);
5228: fnd_message.set_token('LOCATOR', l_mtl_tbl(l_ind).locator_id);

Line 5225: fnd_message.set_token('INV_ITEM_ID',l_mtl_tbl(l_ind).inventory_item_id);

5221: debug(' instance_id : '||l_mtl_tbl(l_ind).instance_id);
5222: debug(' instance_ovn : '||l_mtl_tbl(l_ind).object_version_num);
5223: ELSE
5224: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
5225: fnd_message.set_token('INV_ITEM_ID',l_mtl_tbl(l_ind).inventory_item_id);
5226: fnd_message.set_token('INV_ORG_ID', l_mtl_tbl(l_ind).organization_id);
5227: fnd_message.set_token('SUBINV', l_mtl_tbl(l_ind).subinventory_code);
5228: fnd_message.set_token('LOCATOR', l_mtl_tbl(l_ind).locator_id);
5229: fnd_msg_pub.add;

Line 5226: fnd_message.set_token('INV_ORG_ID', l_mtl_tbl(l_ind).organization_id);

5222: debug(' instance_ovn : '||l_mtl_tbl(l_ind).object_version_num);
5223: ELSE
5224: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
5225: fnd_message.set_token('INV_ITEM_ID',l_mtl_tbl(l_ind).inventory_item_id);
5226: fnd_message.set_token('INV_ORG_ID', l_mtl_tbl(l_ind).organization_id);
5227: fnd_message.set_token('SUBINV', l_mtl_tbl(l_ind).subinventory_code);
5228: fnd_message.set_token('LOCATOR', l_mtl_tbl(l_ind).locator_id);
5229: fnd_msg_pub.add;
5230: RAISE fnd_api.g_exc_error;

Line 5227: fnd_message.set_token('SUBINV', l_mtl_tbl(l_ind).subinventory_code);

5223: ELSE
5224: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
5225: fnd_message.set_token('INV_ITEM_ID',l_mtl_tbl(l_ind).inventory_item_id);
5226: fnd_message.set_token('INV_ORG_ID', l_mtl_tbl(l_ind).organization_id);
5227: fnd_message.set_token('SUBINV', l_mtl_tbl(l_ind).subinventory_code);
5228: fnd_message.set_token('LOCATOR', l_mtl_tbl(l_ind).locator_id);
5229: fnd_msg_pub.add;
5230: RAISE fnd_api.g_exc_error;
5231: END IF;

Line 5228: fnd_message.set_token('LOCATOR', l_mtl_tbl(l_ind).locator_id);

5224: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
5225: fnd_message.set_token('INV_ITEM_ID',l_mtl_tbl(l_ind).inventory_item_id);
5226: fnd_message.set_token('INV_ORG_ID', l_mtl_tbl(l_ind).organization_id);
5227: fnd_message.set_token('SUBINV', l_mtl_tbl(l_ind).subinventory_code);
5228: fnd_message.set_token('LOCATOR', l_mtl_tbl(l_ind).locator_id);
5229: fnd_msg_pub.add;
5230: RAISE fnd_api.g_exc_error;
5231: END IF;
5232: END IF;

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

5306: WHERE organization_id = p_organization_id
5307: AND secondary_inventory_name = p_subinventory_code;
5308: EXCEPTION
5309: WHEN no_data_found THEN
5310: fnd_message.set_name('CSI','CSI_INT_DEST_SUBINV_INVALID');
5311: fnd_message.set_token('INV_ORG_ID',p_organization_id);
5312: fnd_message.set_token('SUBINV_ID',p_subinventory_code);
5313: fnd_msg_pub.add;
5314: RAISE fnd_api.g_exc_error;

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

5307: AND secondary_inventory_name = p_subinventory_code;
5308: EXCEPTION
5309: WHEN no_data_found THEN
5310: fnd_message.set_name('CSI','CSI_INT_DEST_SUBINV_INVALID');
5311: fnd_message.set_token('INV_ORG_ID',p_organization_id);
5312: fnd_message.set_token('SUBINV_ID',p_subinventory_code);
5313: fnd_msg_pub.add;
5314: RAISE fnd_api.g_exc_error;
5315: END;

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

5308: EXCEPTION
5309: WHEN no_data_found THEN
5310: fnd_message.set_name('CSI','CSI_INT_DEST_SUBINV_INVALID');
5311: fnd_message.set_token('INV_ORG_ID',p_organization_id);
5312: fnd_message.set_token('SUBINV_ID',p_subinventory_code);
5313: fnd_msg_pub.add;
5314: RAISE fnd_api.g_exc_error;
5315: END;
5316:

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

5321: FROM hr_organization_units
5322: WHERE organization_id = p_organization_id;
5323: EXCEPTION
5324: WHEN no_data_found THEN
5325: fnd_message.set_name('CSI','CSI_INT_DEST_ORG_ID_INVALID');
5326: fnd_message.set_token('INV_ORG_ID',p_organization_id);
5327: fnd_msg_pub.add;
5328: RAISE fnd_api.g_exc_error;
5329: END;

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

5322: WHERE organization_id = p_organization_id;
5323: EXCEPTION
5324: WHEN no_data_found THEN
5325: fnd_message.set_name('CSI','CSI_INT_DEST_ORG_ID_INVALID');
5326: fnd_message.set_token('INV_ORG_ID',p_organization_id);
5327: fnd_msg_pub.add;
5328: RAISE fnd_api.g_exc_error;
5329: END;
5330: END IF;