DBA Data[Home] [Help]

APPS.CSI_INTERFACE_PKG dependencies on FND_MSG_PUB

Line 73: fnd_msg_pub.add;

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');
77: fnd_message.set_token('TXN_TYPE_ID',p_transaction_type_id);

Line 78: 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
82: WHEN fnd_api.g_exc_error THEN

Line 647: fnd_msg_pub.add;

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

Line 2397: fnd_msg_pub.add;

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 */
2401: END IF;

Line 2763: fnd_msg_pub.add;

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;
2767: x_source_line_rec.owner_party_account_id := l_partner_rec.end_customer_id;

Line 2785: fnd_msg_pub.add;

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

Line 2795: fnd_msg_pub.add;

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

Line 2805: fnd_msg_pub.add;

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

Line 2815: fnd_msg_pub.add;

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

Line 2825: fnd_msg_pub.add;

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

Line 2846: fnd_msg_pub.add;

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

Line 2856: fnd_msg_pub.add;

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

Line 2866: fnd_msg_pub.add;

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

Line 2876: fnd_msg_pub.add;

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

Line 2886: fnd_msg_pub.add;

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

Line 3216: fnd_msg_pub.add;

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:
3220: debug(' location_type_code :'||l_location_type_code);

Line 3460: fnd_msg_pub.add;

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;
3464: ELSE

Line 3472: fnd_msg_pub.add;

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;
3476: ELSE

Line 4400: fnd_msg_pub.add;

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:
4404: debug('src_status_id :'||l_sub_type_rec.src_status_id);

Line 4953: fnd_msg_pub.add;

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;
4957: debug('Error in Interface_IB: '||x_return_message);

Line 5321: fnd_msg_pub.add;

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
5325: IF l_inst_hdr_tbl.count = 1 THEN

Line 5336: fnd_msg_pub.add;

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;
5340:

Line 5420: fnd_msg_pub.add;

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:
5424: IF l_location_id is null THEN

Line 5434: fnd_msg_pub.add;

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;
5438: