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

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

Line 2393: fnd_message.set_name('CSI','CSI_TXN_CZ_INVALID_DATA');

2389: EXCEPTION
2390: WHEN no_data_found THEN
2391: l_tld_tbl(l_ind).instance_id := fnd_api.g_miss_num;
2392: l_tld_tbl(l_ind).instance_exists_flag := 'N';
2393: fnd_message.set_name('CSI','CSI_TXN_CZ_INVALID_DATA');
2394: fnd_message.set_token('INST_HDR_ID',l_tld_tbl(l_ind).config_inst_hdr_id);
2395: fnd_message.set_token('INST_REV_NBR',l_tld_tbl(l_ind).config_inst_rev_num);
2396: fnd_message.set_token('CONFIG_ITEM_ID',l_tld_tbl(l_ind).config_inst_item_id);
2397: fnd_msg_pub.add;

Line 2394: fnd_message.set_token('INST_HDR_ID',l_tld_tbl(l_ind).config_inst_hdr_id);

2390: WHEN no_data_found THEN
2391: l_tld_tbl(l_ind).instance_id := fnd_api.g_miss_num;
2392: l_tld_tbl(l_ind).instance_exists_flag := 'N';
2393: fnd_message.set_name('CSI','CSI_TXN_CZ_INVALID_DATA');
2394: fnd_message.set_token('INST_HDR_ID',l_tld_tbl(l_ind).config_inst_hdr_id);
2395: fnd_message.set_token('INST_REV_NBR',l_tld_tbl(l_ind).config_inst_rev_num);
2396: fnd_message.set_token('CONFIG_ITEM_ID',l_tld_tbl(l_ind).config_inst_item_id);
2397: fnd_msg_pub.add;
2398: RAISE fnd_api.g_exc_error;

Line 2395: fnd_message.set_token('INST_REV_NBR',l_tld_tbl(l_ind).config_inst_rev_num);

2391: l_tld_tbl(l_ind).instance_id := fnd_api.g_miss_num;
2392: l_tld_tbl(l_ind).instance_exists_flag := 'N';
2393: fnd_message.set_name('CSI','CSI_TXN_CZ_INVALID_DATA');
2394: fnd_message.set_token('INST_HDR_ID',l_tld_tbl(l_ind).config_inst_hdr_id);
2395: fnd_message.set_token('INST_REV_NBR',l_tld_tbl(l_ind).config_inst_rev_num);
2396: fnd_message.set_token('CONFIG_ITEM_ID',l_tld_tbl(l_ind).config_inst_item_id);
2397: fnd_msg_pub.add;
2398: RAISE fnd_api.g_exc_error;
2399: END;

Line 2396: fnd_message.set_token('CONFIG_ITEM_ID',l_tld_tbl(l_ind).config_inst_item_id);

2392: l_tld_tbl(l_ind).instance_exists_flag := 'N';
2393: fnd_message.set_name('CSI','CSI_TXN_CZ_INVALID_DATA');
2394: fnd_message.set_token('INST_HDR_ID',l_tld_tbl(l_ind).config_inst_hdr_id);
2395: fnd_message.set_token('INST_REV_NBR',l_tld_tbl(l_ind).config_inst_rev_num);
2396: fnd_message.set_token('CONFIG_ITEM_ID',l_tld_tbl(l_ind).config_inst_item_id);
2397: fnd_msg_pub.add;
2398: RAISE fnd_api.g_exc_error;
2399: END;
2400: /* End fix for Bug 3502896 */

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

2758: x_partner_order_rec => l_partner_rec);
2759:
2760: IF l_partner_rec.IB_OWNER = 'END_CUSTOMER' THEN
2761: IF l_partner_rec.END_CUSTOMER_ID is null Then
2762: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
2763: fnd_msg_pub.add;
2764: raise fnd_api.g_exc_error;
2765: ELSE
2766: l_ib_owner := l_partner_rec.ib_owner;

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

2780: IF x_source_line_rec.ib_install_loc = 'END_CUSTOMER'
2781: THEN
2782: IF l_partner_rec.end_customer_site_use_id is null
2783: THEN
2784: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
2785: fnd_msg_pub.add;
2786: raise fnd_api.g_exc_error;
2787: ELSE
2788: x_source_line_rec.ib_install_loc_id := l_partner_rec.end_customer_site_use_id;

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

2790: ELSIF x_source_line_rec.ib_install_loc = 'SHIP_TO'
2791: THEN
2792: IF x_source_line_rec.ship_to_address_id is null
2793: THEN
2794: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
2795: fnd_msg_pub.add;
2796: raise fnd_api.g_exc_error;
2797: ELSE
2798: x_source_line_rec.ib_install_loc_id := x_source_line_rec.ship_to_address_id;

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

2800: ELSIF x_source_line_rec.ib_install_loc = 'SOLD_TO'
2801: THEN
2802: IF l_partner_rec.SOLD_TO_SITE_USE_ID is null -- 3412544 x_source_line_rec.sold_to_org_id is null
2803: THEN
2804: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
2805: fnd_msg_pub.add;
2806: raise fnd_api.g_exc_error;
2807: ELSE
2808: 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 2814: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');

2810: ELSIF x_source_line_rec.ib_install_loc = 'DELIVER_TO'
2811: THEN
2812: IF x_source_line_rec.deliver_to_org_id is null
2813: THEN
2814: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
2815: fnd_msg_pub.add;
2816: raise fnd_api.g_exc_error;
2817: ELSE
2818: x_source_line_rec.ib_install_loc_id := x_source_line_rec.deliver_to_org_id;

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

2820: ELSIF x_source_line_rec.ib_install_loc = 'BILL_TO'
2821: THEN
2822: IF x_source_line_rec.bill_to_address_id is null
2823: THEN
2824: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
2825: fnd_msg_pub.add;
2826: raise fnd_api.g_exc_error;
2827: ELSE
2828: x_source_line_rec.ib_install_loc_id := x_source_line_rec.bill_to_address_id;

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

2841: IF x_source_line_rec.ib_current_loc = 'END_CUSTOMER'
2842: THEN
2843: IF l_partner_rec.end_customer_site_use_id is null
2844: THEN
2845: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
2846: fnd_msg_pub.add;
2847: raise fnd_api.g_exc_error;
2848: ELSE
2849: x_source_line_rec.ib_current_loc_id := l_partner_rec.end_customer_site_use_id;

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

2851: ELSIF x_source_line_rec.ib_current_loc = 'SHIP_TO'
2852: THEN
2853: IF x_source_line_rec.ship_to_address_id is null
2854: THEN
2855: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
2856: fnd_msg_pub.add;
2857: raise fnd_api.g_exc_error;
2858: ELSE
2859: x_source_line_rec.ib_current_loc_id := x_source_line_rec.ship_to_address_id;

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

2861: ELSIF x_source_line_rec.ib_current_loc = 'SOLD_TO'
2862: THEN
2863: IF l_partner_rec.SOLD_TO_SITE_USE_ID is null -- 3412544 x_source_line_rec.sold_to_org_id is null
2864: THEN
2865: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
2866: fnd_msg_pub.add;
2867: raise fnd_api.g_exc_error;
2868: ELSE
2869: 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 2875: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');

2871: ELSIF x_source_line_rec.ib_current_loc = 'DELIVER_TO'
2872: THEN
2873: IF x_source_line_rec.deliver_to_org_id is null
2874: THEN
2875: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
2876: fnd_msg_pub.add;
2877: raise fnd_api.g_exc_error;
2878: ELSE
2879: x_source_line_rec.ib_current_loc_id := x_source_line_rec.deliver_to_org_id;

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

2881: ELSIF x_source_line_rec.ib_current_loc = 'BILL_TO'
2882: THEN
2883: IF x_source_line_rec.bill_to_address_id is null
2884: THEN
2885: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
2886: fnd_msg_pub.add;
2887: raise fnd_api.g_exc_error;
2888: ELSE
2889: x_source_line_rec.ib_current_loc_id := x_source_line_rec.bill_to_address_id;

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

3208: END;
3209: END LOOP;
3210:
3211: IF NOT(l_partner_location_found) THEN
3212: fnd_message.set_name('CSI', 'CSI_NETWORK_PARTNER_NOT_FOUND');
3213: fnd_message.set_token('INST_HDR_ID', p_instance_key.inst_hdr_id);
3214: fnd_message.set_token('INST_ITEM_ID', p_instance_key.inst_item_id);
3215: fnd_message.set_token('INST_REV_NUM', p_instance_key.inst_rev_num);
3216: fnd_msg_pub.add;

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

3209: END LOOP;
3210:
3211: IF NOT(l_partner_location_found) THEN
3212: fnd_message.set_name('CSI', 'CSI_NETWORK_PARTNER_NOT_FOUND');
3213: fnd_message.set_token('INST_HDR_ID', p_instance_key.inst_hdr_id);
3214: fnd_message.set_token('INST_ITEM_ID', p_instance_key.inst_item_id);
3215: fnd_message.set_token('INST_REV_NUM', p_instance_key.inst_rev_num);
3216: fnd_msg_pub.add;
3217: RAISE fnd_api.g_exc_error;

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

3210:
3211: IF NOT(l_partner_location_found) THEN
3212: fnd_message.set_name('CSI', 'CSI_NETWORK_PARTNER_NOT_FOUND');
3213: fnd_message.set_token('INST_HDR_ID', p_instance_key.inst_hdr_id);
3214: fnd_message.set_token('INST_ITEM_ID', p_instance_key.inst_item_id);
3215: fnd_message.set_token('INST_REV_NUM', p_instance_key.inst_rev_num);
3216: fnd_msg_pub.add;
3217: RAISE fnd_api.g_exc_error;
3218: END IF;

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

3211: IF NOT(l_partner_location_found) THEN
3212: fnd_message.set_name('CSI', 'CSI_NETWORK_PARTNER_NOT_FOUND');
3213: fnd_message.set_token('INST_HDR_ID', p_instance_key.inst_hdr_id);
3214: fnd_message.set_token('INST_ITEM_ID', p_instance_key.inst_item_id);
3215: fnd_message.set_token('INST_REV_NUM', p_instance_key.inst_rev_num);
3216: fnd_msg_pub.add;
3217: RAISE fnd_api.g_exc_error;
3218: END IF;
3219:

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

3453: AND ((active_end_date is null ) OR
3454: (active_end_date > sysdate));
3455: EXCEPTION
3456: WHEN no_data_found THEN
3457: fnd_message.set_name('CSI','CSI_INT_INV_INSTA_PTY_ID');
3458: fnd_message.set_token('INSTANCE_ID',l_i_rec.instance_id);
3459: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_txn_party_tbl(l_p_ind).relationship_type_code);
3460: fnd_msg_pub.add;
3461: IF p_txn_party_tbl(l_p_ind).relationship_type_code = 'OWNER' THEN

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

3454: (active_end_date > sysdate));
3455: EXCEPTION
3456: WHEN no_data_found THEN
3457: fnd_message.set_name('CSI','CSI_INT_INV_INSTA_PTY_ID');
3458: fnd_message.set_token('INSTANCE_ID',l_i_rec.instance_id);
3459: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_txn_party_tbl(l_p_ind).relationship_type_code);
3460: fnd_msg_pub.add;
3461: IF p_txn_party_tbl(l_p_ind).relationship_type_code = 'OWNER' THEN
3462: x_return_status := fnd_api.g_ret_sts_error;

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

3455: EXCEPTION
3456: WHEN no_data_found THEN
3457: fnd_message.set_name('CSI','CSI_INT_INV_INSTA_PTY_ID');
3458: fnd_message.set_token('INSTANCE_ID',l_i_rec.instance_id);
3459: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_txn_party_tbl(l_p_ind).relationship_type_code);
3460: fnd_msg_pub.add;
3461: IF p_txn_party_tbl(l_p_ind).relationship_type_code = 'OWNER' THEN
3462: x_return_status := fnd_api.g_ret_sts_error;
3463: raise fnd_api.g_exc_error;

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

3465: p_txn_party_tbl(l_pc_ind).contact_party_id := p_ind;
3466: debug('relationship_type_code :'||p_txn_party_tbl(l_p_ind).relationship_type_code);
3467: END IF;
3468: WHEN too_many_rows THEN
3469: fnd_message.set_name('CSI','CSI_INT_MANY_INSTA_PTY_FOUND');
3470: fnd_message.set_token('INSTANCE_ID',l_i_rec.instance_id);
3471: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_txn_party_tbl(l_p_ind).relationship_type_code);
3472: fnd_msg_pub.add;
3473: x_return_status := fnd_api.g_ret_sts_error;

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

3466: debug('relationship_type_code :'||p_txn_party_tbl(l_p_ind).relationship_type_code);
3467: END IF;
3468: WHEN too_many_rows THEN
3469: fnd_message.set_name('CSI','CSI_INT_MANY_INSTA_PTY_FOUND');
3470: fnd_message.set_token('INSTANCE_ID',l_i_rec.instance_id);
3471: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_txn_party_tbl(l_p_ind).relationship_type_code);
3472: fnd_msg_pub.add;
3473: x_return_status := fnd_api.g_ret_sts_error;
3474: raise fnd_api.g_exc_error;

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

3467: END IF;
3468: WHEN too_many_rows THEN
3469: fnd_message.set_name('CSI','CSI_INT_MANY_INSTA_PTY_FOUND');
3470: fnd_message.set_token('INSTANCE_ID',l_i_rec.instance_id);
3471: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_txn_party_tbl(l_p_ind).relationship_type_code);
3472: fnd_msg_pub.add;
3473: x_return_status := fnd_api.g_ret_sts_error;
3474: raise fnd_api.g_exc_error;
3475: END;

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

4393: WHERE transaction_type_id = px_txn_line_rec.source_transaction_type_id
4394: AND sub_type_id = px_txn_line_dtl_tbl(l_td_ind).sub_type_id;
4395: EXCEPTION
4396: WHEN no_data_found THEN
4397: fnd_message.set_name('CSI', 'CSI_INT_SUB_TYPE_REC_MISSING');
4398: fnd_message.set_token('SUB_TYPE_ID', px_txn_line_dtl_tbl(l_td_ind).sub_type_id);
4399: fnd_message.set_token('TRANSACTION_TYPE_ID',px_txn_line_rec.source_transaction_type_id);
4400: fnd_msg_pub.add;
4401: RAISE fnd_api.g_exc_error;

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

4394: AND sub_type_id = px_txn_line_dtl_tbl(l_td_ind).sub_type_id;
4395: EXCEPTION
4396: WHEN no_data_found THEN
4397: fnd_message.set_name('CSI', 'CSI_INT_SUB_TYPE_REC_MISSING');
4398: fnd_message.set_token('SUB_TYPE_ID', px_txn_line_dtl_tbl(l_td_ind).sub_type_id);
4399: fnd_message.set_token('TRANSACTION_TYPE_ID',px_txn_line_rec.source_transaction_type_id);
4400: fnd_msg_pub.add;
4401: RAISE fnd_api.g_exc_error;
4402: END;

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

4395: EXCEPTION
4396: WHEN no_data_found THEN
4397: fnd_message.set_name('CSI', 'CSI_INT_SUB_TYPE_REC_MISSING');
4398: fnd_message.set_token('SUB_TYPE_ID', px_txn_line_dtl_tbl(l_td_ind).sub_type_id);
4399: fnd_message.set_token('TRANSACTION_TYPE_ID',px_txn_line_rec.source_transaction_type_id);
4400: fnd_msg_pub.add;
4401: RAISE fnd_api.g_exc_error;
4402: END;
4403:

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

4947: x_return_message := csi_t_gen_utility_pvt.dump_error_stack;
4948: debug('Error in Interface_IB: '||x_return_message);
4949: WHEN others THEN
4950:
4951: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
4952: fnd_message.set_token('MESSAGE', substr(sqlerrm, 1, 240));
4953: fnd_msg_pub.add;
4954:
4955: x_return_status := fnd_api.g_ret_sts_unexp_error ;

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

4948: debug('Error in Interface_IB: '||x_return_message);
4949: WHEN others THEN
4950:
4951: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
4952: fnd_message.set_token('MESSAGE', substr(sqlerrm, 1, 240));
4953: fnd_msg_pub.add;
4954:
4955: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4956: x_return_message := csi_t_gen_utility_pvt.dump_error_stack;

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

5312: l_mtl_tbl(l_ind).negative_instance_flag := 'Y';
5313: l_mtl_tbl(l_ind).instance_id := null;
5314: l_mtl_tbl(l_ind).object_version_num := null;
5315: ELSE
5316: fnd_message.set_name('CSI','CSI_INT_INV_INST_NOT_FOUND');
5317: fnd_message.set_token('INV_ITEM_ID',l_mtl_tbl(l_ind).inventory_item_id);
5318: fnd_message.set_token('INV_ORG_ID', l_mtl_tbl(l_ind).organization_id);
5319: fnd_message.set_token('SUBINV', l_mtl_tbl(l_ind).subinventory_code);
5320: fnd_message.set_token('LOCATOR', l_mtl_tbl(l_ind).locator_id);

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

5313: l_mtl_tbl(l_ind).instance_id := null;
5314: l_mtl_tbl(l_ind).object_version_num := null;
5315: ELSE
5316: fnd_message.set_name('CSI','CSI_INT_INV_INST_NOT_FOUND');
5317: fnd_message.set_token('INV_ITEM_ID',l_mtl_tbl(l_ind).inventory_item_id);
5318: fnd_message.set_token('INV_ORG_ID', l_mtl_tbl(l_ind).organization_id);
5319: fnd_message.set_token('SUBINV', l_mtl_tbl(l_ind).subinventory_code);
5320: fnd_message.set_token('LOCATOR', l_mtl_tbl(l_ind).locator_id);
5321: fnd_msg_pub.add;

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

5314: l_mtl_tbl(l_ind).object_version_num := null;
5315: ELSE
5316: fnd_message.set_name('CSI','CSI_INT_INV_INST_NOT_FOUND');
5317: fnd_message.set_token('INV_ITEM_ID',l_mtl_tbl(l_ind).inventory_item_id);
5318: fnd_message.set_token('INV_ORG_ID', l_mtl_tbl(l_ind).organization_id);
5319: fnd_message.set_token('SUBINV', l_mtl_tbl(l_ind).subinventory_code);
5320: fnd_message.set_token('LOCATOR', l_mtl_tbl(l_ind).locator_id);
5321: fnd_msg_pub.add;
5322: RAISE fnd_api.g_exc_error;

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

5315: ELSE
5316: fnd_message.set_name('CSI','CSI_INT_INV_INST_NOT_FOUND');
5317: fnd_message.set_token('INV_ITEM_ID',l_mtl_tbl(l_ind).inventory_item_id);
5318: fnd_message.set_token('INV_ORG_ID', l_mtl_tbl(l_ind).organization_id);
5319: fnd_message.set_token('SUBINV', l_mtl_tbl(l_ind).subinventory_code);
5320: fnd_message.set_token('LOCATOR', l_mtl_tbl(l_ind).locator_id);
5321: fnd_msg_pub.add;
5322: RAISE fnd_api.g_exc_error;
5323: END IF;

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

5316: fnd_message.set_name('CSI','CSI_INT_INV_INST_NOT_FOUND');
5317: fnd_message.set_token('INV_ITEM_ID',l_mtl_tbl(l_ind).inventory_item_id);
5318: fnd_message.set_token('INV_ORG_ID', l_mtl_tbl(l_ind).organization_id);
5319: fnd_message.set_token('SUBINV', l_mtl_tbl(l_ind).subinventory_code);
5320: fnd_message.set_token('LOCATOR', l_mtl_tbl(l_ind).locator_id);
5321: fnd_msg_pub.add;
5322: RAISE fnd_api.g_exc_error;
5323: END IF;
5324: ELSE

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

5327: l_mtl_tbl(l_ind).object_version_num := l_inst_hdr_tbl(1).object_version_number;
5328: debug(' instance_id : '||l_mtl_tbl(l_ind).instance_id);
5329: debug(' instance_ovn : '||l_mtl_tbl(l_ind).object_version_num);
5330: ELSE
5331: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
5332: fnd_message.set_token('INV_ITEM_ID',l_mtl_tbl(l_ind).inventory_item_id);
5333: fnd_message.set_token('INV_ORG_ID', l_mtl_tbl(l_ind).organization_id);
5334: fnd_message.set_token('SUBINV', l_mtl_tbl(l_ind).subinventory_code);
5335: fnd_message.set_token('LOCATOR', l_mtl_tbl(l_ind).locator_id);

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

5328: debug(' instance_id : '||l_mtl_tbl(l_ind).instance_id);
5329: debug(' instance_ovn : '||l_mtl_tbl(l_ind).object_version_num);
5330: ELSE
5331: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
5332: fnd_message.set_token('INV_ITEM_ID',l_mtl_tbl(l_ind).inventory_item_id);
5333: fnd_message.set_token('INV_ORG_ID', l_mtl_tbl(l_ind).organization_id);
5334: fnd_message.set_token('SUBINV', l_mtl_tbl(l_ind).subinventory_code);
5335: fnd_message.set_token('LOCATOR', l_mtl_tbl(l_ind).locator_id);
5336: fnd_msg_pub.add;

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

5329: debug(' instance_ovn : '||l_mtl_tbl(l_ind).object_version_num);
5330: ELSE
5331: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
5332: fnd_message.set_token('INV_ITEM_ID',l_mtl_tbl(l_ind).inventory_item_id);
5333: fnd_message.set_token('INV_ORG_ID', l_mtl_tbl(l_ind).organization_id);
5334: fnd_message.set_token('SUBINV', l_mtl_tbl(l_ind).subinventory_code);
5335: fnd_message.set_token('LOCATOR', l_mtl_tbl(l_ind).locator_id);
5336: fnd_msg_pub.add;
5337: RAISE fnd_api.g_exc_error;

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

5330: ELSE
5331: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
5332: fnd_message.set_token('INV_ITEM_ID',l_mtl_tbl(l_ind).inventory_item_id);
5333: fnd_message.set_token('INV_ORG_ID', l_mtl_tbl(l_ind).organization_id);
5334: fnd_message.set_token('SUBINV', l_mtl_tbl(l_ind).subinventory_code);
5335: fnd_message.set_token('LOCATOR', l_mtl_tbl(l_ind).locator_id);
5336: fnd_msg_pub.add;
5337: RAISE fnd_api.g_exc_error;
5338: END IF;

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

5331: fnd_message.set_name('CSI','CSI_TXN_MULT_INST_FOUND');
5332: fnd_message.set_token('INV_ITEM_ID',l_mtl_tbl(l_ind).inventory_item_id);
5333: fnd_message.set_token('INV_ORG_ID', l_mtl_tbl(l_ind).organization_id);
5334: fnd_message.set_token('SUBINV', l_mtl_tbl(l_ind).subinventory_code);
5335: fnd_message.set_token('LOCATOR', l_mtl_tbl(l_ind).locator_id);
5336: fnd_msg_pub.add;
5337: RAISE fnd_api.g_exc_error;
5338: END IF;
5339: END IF;

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

5413: WHERE organization_id = p_organization_id
5414: AND secondary_inventory_name = p_subinventory_code;
5415: EXCEPTION
5416: WHEN no_data_found THEN
5417: fnd_message.set_name('CSI','CSI_INT_DEST_SUBINV_INVALID');
5418: fnd_message.set_token('INV_ORG_ID',p_organization_id);
5419: fnd_message.set_token('SUBINV_ID',p_subinventory_code);
5420: fnd_msg_pub.add;
5421: RAISE fnd_api.g_exc_error;

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

5414: AND secondary_inventory_name = p_subinventory_code;
5415: EXCEPTION
5416: WHEN no_data_found THEN
5417: fnd_message.set_name('CSI','CSI_INT_DEST_SUBINV_INVALID');
5418: fnd_message.set_token('INV_ORG_ID',p_organization_id);
5419: fnd_message.set_token('SUBINV_ID',p_subinventory_code);
5420: fnd_msg_pub.add;
5421: RAISE fnd_api.g_exc_error;
5422: END;

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

5415: EXCEPTION
5416: WHEN no_data_found THEN
5417: fnd_message.set_name('CSI','CSI_INT_DEST_SUBINV_INVALID');
5418: fnd_message.set_token('INV_ORG_ID',p_organization_id);
5419: fnd_message.set_token('SUBINV_ID',p_subinventory_code);
5420: fnd_msg_pub.add;
5421: RAISE fnd_api.g_exc_error;
5422: END;
5423:

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

5428: FROM hr_organization_units
5429: WHERE organization_id = p_organization_id;
5430: EXCEPTION
5431: WHEN no_data_found THEN
5432: fnd_message.set_name('CSI','CSI_INT_DEST_ORG_ID_INVALID');
5433: fnd_message.set_token('INV_ORG_ID',p_organization_id);
5434: fnd_msg_pub.add;
5435: RAISE fnd_api.g_exc_error;
5436: END;

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

5429: WHERE organization_id = p_organization_id;
5430: EXCEPTION
5431: WHEN no_data_found THEN
5432: fnd_message.set_name('CSI','CSI_INT_DEST_ORG_ID_INVALID');
5433: fnd_message.set_token('INV_ORG_ID',p_organization_id);
5434: fnd_msg_pub.add;
5435: RAISE fnd_api.g_exc_error;
5436: END;
5437: END IF;