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 645: fnd_msg_pub.add;

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

Line 2729: fnd_msg_pub.add;

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

Line 2751: fnd_msg_pub.add;

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

Line 2761: fnd_msg_pub.add;

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

Line 2771: fnd_msg_pub.add;

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

Line 2781: fnd_msg_pub.add;

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

Line 2791: fnd_msg_pub.add;

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

Line 2812: fnd_msg_pub.add;

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

Line 2822: fnd_msg_pub.add;

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

Line 2832: fnd_msg_pub.add;

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

Line 2842: fnd_msg_pub.add;

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

Line 2852: fnd_msg_pub.add;

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

Line 3182: fnd_msg_pub.add;

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

Line 3367: fnd_msg_pub.add;

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

Line 3379: fnd_msg_pub.add;

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

Line 4294: fnd_msg_pub.add;

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

Line 4846: fnd_msg_pub.add;

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

Line 5214: fnd_msg_pub.add;

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

Line 5229: fnd_msg_pub.add;

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

Line 5313: fnd_msg_pub.add;

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

Line 5327: fnd_msg_pub.add;

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