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_ORDER_FULFILL_PUB dependencies on FND_MESSAGE

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

93: FROM csi_ib_txn_types
94: WHERE sub_type_id = p_sub_type_id;
95: EXCEPTION
96: WHEN no_data_found THEN
97: fnd_message.set_name('CSI','CSI_INT_SUB_TYPE_REC_MISSING');
98: fnd_message.set_token('SUB_TYPE_ID', p_sub_type_id);
99: fnd_message.set_token('TRANSACTION_TYPE_ID', p_transaction_type_id);
100: fnd_msg_pub.add;
101: RAISE fnd_api.g_exc_error;

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

94: WHERE sub_type_id = p_sub_type_id;
95: EXCEPTION
96: WHEN no_data_found THEN
97: fnd_message.set_name('CSI','CSI_INT_SUB_TYPE_REC_MISSING');
98: fnd_message.set_token('SUB_TYPE_ID', p_sub_type_id);
99: fnd_message.set_token('TRANSACTION_TYPE_ID', p_transaction_type_id);
100: fnd_msg_pub.add;
101: RAISE fnd_api.g_exc_error;
102: END;

Line 99: fnd_message.set_token('TRANSACTION_TYPE_ID', p_transaction_type_id);

95: EXCEPTION
96: WHEN no_data_found THEN
97: fnd_message.set_name('CSI','CSI_INT_SUB_TYPE_REC_MISSING');
98: fnd_message.set_token('SUB_TYPE_ID', p_sub_type_id);
99: fnd_message.set_token('TRANSACTION_TYPE_ID', p_transaction_type_id);
100: fnd_msg_pub.add;
101: RAISE fnd_api.g_exc_error;
102: END;
103: x_sub_type_rec := l_sub_type_rec;

Line 1535: FND_MESSAGE.set_name('CSI','CSI_INVALID_TXN_TYPE_ID');

1531:
1532: EXCEPTION
1533: WHEN no_data_found THEN
1534: x_return_status := fnd_api.g_ret_sts_error;
1535: FND_MESSAGE.set_name('CSI','CSI_INVALID_TXN_TYPE_ID');
1536: FND_MSG_PUB.add;
1537: WHEN too_many_rows THEN
1538: x_return_status := fnd_api.g_ret_sts_error;
1539: FND_MESSAGE.set_name('CSI','CSI_INVALID_TXN_TYPE_ID');

Line 1539: FND_MESSAGE.set_name('CSI','CSI_INVALID_TXN_TYPE_ID');

1535: FND_MESSAGE.set_name('CSI','CSI_INVALID_TXN_TYPE_ID');
1536: FND_MSG_PUB.add;
1537: WHEN too_many_rows THEN
1538: x_return_status := fnd_api.g_ret_sts_error;
1539: FND_MESSAGE.set_name('CSI','CSI_INVALID_TXN_TYPE_ID');
1540: FND_MSG_PUB.add;
1541: END get_txn_sub_type_id;
1542:
1543: /* This routine splits the transaction details in to quantity one each */

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

2308: l_end_customer_id := p_order_line_rec.sold_to_org_id;
2309: END IF;
2310:
2311: IF nvl(l_end_customer_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
2312: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
2313: fnd_msg_pub.add;
2314: RAISE fnd_api.g_exc_error;
2315: END IF;
2316:

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

2337: ELSIF l_partner_rec.ib_current_location = 'BILL_TO' THEN
2338: l_current_site_use_id := p_order_line_rec.invoice_to_org_id;
2339: END IF;
2340: IF nvl(l_current_site_use_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
2341: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
2342: fnd_msg_pub.add;
2343: RAISE fnd_api.g_exc_error;
2344: END IF;
2345:

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

2367: ELSIF l_partner_rec.ib_installed_at_location = 'BILL_TO' THEN
2368: l_install_site_use_id := p_order_line_rec.invoice_to_org_id;
2369: END IF;
2370: IF nvl(l_install_site_use_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
2371: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
2372: fnd_msg_pub.add;
2373: RAISE fnd_api.g_exc_error;
2374: END IF;
2375:

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

2695: (active_end_date > sysdate));
2696: END IF;
2697: EXCEPTION
2698: WHEN no_data_found THEN
2699: fnd_message.set_name('CSI','CSI_INT_INV_INSTA_PTY_ID');
2700: fnd_message.set_token('INSTANCE_ID',l_u_instance_rec.instance_id);
2701: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',l_pty_dtl_tbl(l_p_ind).relationship_type_code);
2702: fnd_msg_pub.add;
2703: IF l_pty_dtl_tbl(l_p_ind).relationship_type_code = 'OWNER' THEN

Line 2700: fnd_message.set_token('INSTANCE_ID',l_u_instance_rec.instance_id);

2696: END IF;
2697: EXCEPTION
2698: WHEN no_data_found THEN
2699: fnd_message.set_name('CSI','CSI_INT_INV_INSTA_PTY_ID');
2700: fnd_message.set_token('INSTANCE_ID',l_u_instance_rec.instance_id);
2701: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',l_pty_dtl_tbl(l_p_ind).relationship_type_code);
2702: fnd_msg_pub.add;
2703: IF l_pty_dtl_tbl(l_p_ind).relationship_type_code = 'OWNER' THEN
2704: x_return_status := fnd_api.g_ret_sts_error;

Line 2701: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',l_pty_dtl_tbl(l_p_ind).relationship_type_code);

2697: EXCEPTION
2698: WHEN no_data_found THEN
2699: fnd_message.set_name('CSI','CSI_INT_INV_INSTA_PTY_ID');
2700: fnd_message.set_token('INSTANCE_ID',l_u_instance_rec.instance_id);
2701: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',l_pty_dtl_tbl(l_p_ind).relationship_type_code);
2702: fnd_msg_pub.add;
2703: IF l_pty_dtl_tbl(l_p_ind).relationship_type_code = 'OWNER' THEN
2704: x_return_status := fnd_api.g_ret_sts_error;
2705: raise fnd_api.g_exc_error;

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

2706: ELSE
2707: l_pty_dtl_tbl(l_pc_ind).contact_party_id := l_ind;
2708: END IF;
2709: WHEN too_many_rows THEN
2710: fnd_message.set_name('CSI','CSI_INT_MANY_INSTA_PTY_FOUND');
2711: fnd_message.set_token('INSTANCE_ID',l_u_instance_rec.instance_id);
2712: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',l_pty_dtl_tbl(l_p_ind).relationship_type_code);
2713: fnd_msg_pub.add;
2714: x_return_status := fnd_api.g_ret_sts_error;

Line 2711: fnd_message.set_token('INSTANCE_ID',l_u_instance_rec.instance_id);

2707: l_pty_dtl_tbl(l_pc_ind).contact_party_id := l_ind;
2708: END IF;
2709: WHEN too_many_rows THEN
2710: fnd_message.set_name('CSI','CSI_INT_MANY_INSTA_PTY_FOUND');
2711: fnd_message.set_token('INSTANCE_ID',l_u_instance_rec.instance_id);
2712: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',l_pty_dtl_tbl(l_p_ind).relationship_type_code);
2713: fnd_msg_pub.add;
2714: x_return_status := fnd_api.g_ret_sts_error;
2715: raise fnd_api.g_exc_error;

Line 2712: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',l_pty_dtl_tbl(l_p_ind).relationship_type_code);

2708: END IF;
2709: WHEN too_many_rows THEN
2710: fnd_message.set_name('CSI','CSI_INT_MANY_INSTA_PTY_FOUND');
2711: fnd_message.set_token('INSTANCE_ID',l_u_instance_rec.instance_id);
2712: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',l_pty_dtl_tbl(l_p_ind).relationship_type_code);
2713: fnd_msg_pub.add;
2714: x_return_status := fnd_api.g_ret_sts_error;
2715: raise fnd_api.g_exc_error;
2716: END;

Line 2958: fnd_message.set_name('CSI', 'CSI_NO_WIP_COMP_INSTANCE');

2954: END IF;
2955:
2956: IF NOT(l_instances_found) THEN
2957:
2958: fnd_message.set_name('CSI', 'CSI_NO_WIP_COMP_INSTANCE');
2959: fnd_message.set_token('INV_ITEM_ID', p_inventory_item_id);
2960: fnd_message.set_token('WIP_ENTITY_ID', p_wip_entity_id);
2961: fnd_msg_pub.add;
2962:

Line 2959: fnd_message.set_token('INV_ITEM_ID', p_inventory_item_id);

2955:
2956: IF NOT(l_instances_found) THEN
2957:
2958: fnd_message.set_name('CSI', 'CSI_NO_WIP_COMP_INSTANCE');
2959: fnd_message.set_token('INV_ITEM_ID', p_inventory_item_id);
2960: fnd_message.set_token('WIP_ENTITY_ID', p_wip_entity_id);
2961: fnd_msg_pub.add;
2962:
2963: RAISE fnd_api.g_exc_error;

Line 2960: fnd_message.set_token('WIP_ENTITY_ID', p_wip_entity_id);

2956: IF NOT(l_instances_found) THEN
2957:
2958: fnd_message.set_name('CSI', 'CSI_NO_WIP_COMP_INSTANCE');
2959: fnd_message.set_token('INV_ITEM_ID', p_inventory_item_id);
2960: fnd_message.set_token('WIP_ENTITY_ID', p_wip_entity_id);
2961: fnd_msg_pub.add;
2962:
2963: RAISE fnd_api.g_exc_error;
2964: END IF;

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

6578: EXCEPTION
6579: WHEN fnd_api.g_exc_error THEN
6580: x_return_status := fnd_api.g_ret_sts_error;
6581: WHEN others then
6582: fnd_message.set_name ('FND','FND_GENERIC_MESSAGE');
6583: fnd_message.set_token('MESSAGE', substr(sqlerrm, 1, 300));
6584: fnd_msg_pub.add;
6585: x_return_status := fnd_api.g_ret_sts_error;
6586: END process_ato_option_nsrl;

Line 6583: fnd_message.set_token('MESSAGE', substr(sqlerrm, 1, 300));

6579: WHEN fnd_api.g_exc_error THEN
6580: x_return_status := fnd_api.g_ret_sts_error;
6581: WHEN others then
6582: fnd_message.set_name ('FND','FND_GENERIC_MESSAGE');
6583: fnd_message.set_token('MESSAGE', substr(sqlerrm, 1, 300));
6584: fnd_msg_pub.add;
6585: x_return_status := fnd_api.g_ret_sts_error;
6586: END process_ato_option_nsrl;
6587:

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

7073: x_return_status := fnd_api.g_ret_sts_success;
7074: WHEN fnd_api.g_exc_error THEN
7075: x_return_status := fnd_api.g_ret_sts_error;
7076: WHEN others then
7077: fnd_message.set_name ('FND','FND_GENERIC_MESSAGE');
7078: fnd_message.set_token('MESSAGE', substr(sqlerrm, 1, 300));
7079: fnd_msg_pub.add;
7080: x_return_status := fnd_api.g_ret_sts_error;
7081: END process_ato_option_srl;

Line 7078: fnd_message.set_token('MESSAGE', substr(sqlerrm, 1, 300));

7074: WHEN fnd_api.g_exc_error THEN
7075: x_return_status := fnd_api.g_ret_sts_error;
7076: WHEN others then
7077: fnd_message.set_name ('FND','FND_GENERIC_MESSAGE');
7078: fnd_message.set_token('MESSAGE', substr(sqlerrm, 1, 300));
7079: fnd_msg_pub.add;
7080: x_return_status := fnd_api.g_ret_sts_error;
7081: END process_ato_option_srl;
7082:

Line 7444: fnd_message.set_name('CSI','CSI_INVALID_VLD_MAST_COMB');

7440: -- addtl. check since the TLD rec will have the OM Master / Vldn Orgn
7441: -- as the inv_organization_id on it for Fulfillments.
7442: l_vld_orgn_id := l_instance_rec.vld_organization_id;
7443: ELSE
7444: fnd_message.set_name('CSI','CSI_INVALID_VLD_MAST_COMB');
7445: fnd_msg_pub.add;
7446: RAISE fnd_api.g_exc_error;
7447: END IF;
7448: END IF;

Line 7488: fnd_message.set_name('CSI','CSI_TXN_INVALID_INST_REF');

7484: <> fnd_api.g_miss_date THEN
7485: debug('Active End date :'||l_line_dtl_tbl(1).active_end_date
7486: || 'provided on transaction line detail: '
7487: || l_line_dtl_tbl(1).txn_line_detail_id);
7488: fnd_message.set_name('CSI','CSI_TXN_INVALID_INST_REF');
7489: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);
7490: fnd_msg_pub.add;
7491: RAISE fnd_api.g_exc_error;
7492: ELSIF l_inst_loc_type

Line 7489: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);

7485: debug('Active End date :'||l_line_dtl_tbl(1).active_end_date
7486: || 'provided on transaction line detail: '
7487: || l_line_dtl_tbl(1).txn_line_detail_id);
7488: fnd_message.set_name('CSI','CSI_TXN_INVALID_INST_REF');
7489: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);
7490: fnd_msg_pub.add;
7491: RAISE fnd_api.g_exc_error;
7492: ELSIF l_inst_loc_type
7493: NOT IN ( 'INVENTORY','HZ_PARTY_SITES', 'HZ_LOCATIONS', 'VENDOR_SITE', 'INTERNAL_SITE')

Line 7496: fnd_message.set_name('CSI', 'CSI_TXN_SRC_LOC_INVALID');

7492: ELSIF l_inst_loc_type
7493: NOT IN ( 'INVENTORY','HZ_PARTY_SITES', 'HZ_LOCATIONS', 'VENDOR_SITE', 'INTERNAL_SITE')
7494: THEN
7495: debug('Location type code is :'||l_inst_loc_type);
7496: fnd_message.set_name('CSI', 'CSI_TXN_SRC_LOC_INVALID');
7497: fnd_message.set_token('LOC_CODE', l_inst_loc_type);
7498: fnd_message.set_token('SRC_NAME', 'Conversion to a Customer Ownership ');
7499: fnd_msg_pub.add;
7500: RAISE fnd_api.g_exc_error;

Line 7497: fnd_message.set_token('LOC_CODE', l_inst_loc_type);

7493: NOT IN ( 'INVENTORY','HZ_PARTY_SITES', 'HZ_LOCATIONS', 'VENDOR_SITE', 'INTERNAL_SITE')
7494: THEN
7495: debug('Location type code is :'||l_inst_loc_type);
7496: fnd_message.set_name('CSI', 'CSI_TXN_SRC_LOC_INVALID');
7497: fnd_message.set_token('LOC_CODE', l_inst_loc_type);
7498: fnd_message.set_token('SRC_NAME', 'Conversion to a Customer Ownership ');
7499: fnd_msg_pub.add;
7500: RAISE fnd_api.g_exc_error;
7501: -- allow only externally located

Line 7498: fnd_message.set_token('SRC_NAME', 'Conversion to a Customer Ownership ');

7494: THEN
7495: debug('Location type code is :'||l_inst_loc_type);
7496: fnd_message.set_name('CSI', 'CSI_TXN_SRC_LOC_INVALID');
7497: fnd_message.set_token('LOC_CODE', l_inst_loc_type);
7498: fnd_message.set_token('SRC_NAME', 'Conversion to a Customer Ownership ');
7499: fnd_msg_pub.add;
7500: RAISE fnd_api.g_exc_error;
7501: -- allow only externally located
7502: END IF;

Line 7510: fnd_message.set_name('CSI', 'CSI_API_INVALID_PARTY_SOURCE');

7506: IF l_inst_owner_type <> l_td_owner_type THEN
7507: -- let's trap as an error currently so that it prevents
7508: -- ownership changes from HZ_PARTY TO PO_VENDOR or etc etc
7509: debug('Owner Change.');
7510: fnd_message.set_name('CSI', 'CSI_API_INVALID_PARTY_SOURCE');
7511: fnd_message.set_token('PARTY_SOURCE_TABLE', l_td_owner_type);
7512: fnd_msg_pub.add;
7513: RAISE fnd_api.g_exc_error;
7514: ELSIF l_td_owner_id <> l_inst_owner_id THEN

Line 7511: fnd_message.set_token('PARTY_SOURCE_TABLE', l_td_owner_type);

7507: -- let's trap as an error currently so that it prevents
7508: -- ownership changes from HZ_PARTY TO PO_VENDOR or etc etc
7509: debug('Owner Change.');
7510: fnd_message.set_name('CSI', 'CSI_API_INVALID_PARTY_SOURCE');
7511: fnd_message.set_token('PARTY_SOURCE_TABLE', l_td_owner_type);
7512: fnd_msg_pub.add;
7513: RAISE fnd_api.g_exc_error;
7514: ELSIF l_td_owner_id <> l_inst_owner_id THEN
7515: IF l_ownership_override = 'Y' THEN

Line 7519: fnd_message.set_name('CSI', 'CSI_SHIP_OWNER_MISMATCH');

7515: IF l_ownership_override = 'Y' THEN
7516: debug('Ownership Change and is allowed.');
7517: ELSE
7518: debug('Ownership Change but is not setup:'||l_ownership_override);
7519: fnd_message.set_name('CSI', 'CSI_SHIP_OWNER_MISMATCH');
7520: fnd_message.set_token('OLD_PARTY_ID',l_inst_owner_id);
7521: fnd_message.set_token('NEW_PARTY_ID',l_td_owner_id);
7522: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);
7523: fnd_msg_pub.add;

Line 7520: fnd_message.set_token('OLD_PARTY_ID',l_inst_owner_id);

7516: debug('Ownership Change and is allowed.');
7517: ELSE
7518: debug('Ownership Change but is not setup:'||l_ownership_override);
7519: fnd_message.set_name('CSI', 'CSI_SHIP_OWNER_MISMATCH');
7520: fnd_message.set_token('OLD_PARTY_ID',l_inst_owner_id);
7521: fnd_message.set_token('NEW_PARTY_ID',l_td_owner_id);
7522: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);
7523: fnd_msg_pub.add;
7524: RAISE fnd_api.g_exc_error;

Line 7521: fnd_message.set_token('NEW_PARTY_ID',l_td_owner_id);

7517: ELSE
7518: debug('Ownership Change but is not setup:'||l_ownership_override);
7519: fnd_message.set_name('CSI', 'CSI_SHIP_OWNER_MISMATCH');
7520: fnd_message.set_token('OLD_PARTY_ID',l_inst_owner_id);
7521: fnd_message.set_token('NEW_PARTY_ID',l_td_owner_id);
7522: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);
7523: fnd_msg_pub.add;
7524: RAISE fnd_api.g_exc_error;
7525: END IF;

Line 7522: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);

7518: debug('Ownership Change but is not setup:'||l_ownership_override);
7519: fnd_message.set_name('CSI', 'CSI_SHIP_OWNER_MISMATCH');
7520: fnd_message.set_token('OLD_PARTY_ID',l_inst_owner_id);
7521: fnd_message.set_token('NEW_PARTY_ID',l_td_owner_id);
7522: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);
7523: fnd_msg_pub.add;
7524: RAISE fnd_api.g_exc_error;
7525: END IF;
7526: END IF;

Line 7540: fnd_message.set_name('CSI', 'CSI_SHIP_OWNER_MISMATCH');

7536: THEN -- end customer exists
7537: -- for normal NON-partner order, checks for ownership override will be
7538: -- done anyway later in update_install_base since we do not have party_id here
7539: debug('Ownership Change but is not setup:'||l_ownership_override);
7540: fnd_message.set_name('CSI', 'CSI_SHIP_OWNER_MISMATCH');
7541: fnd_message.set_token('OLD_PARTY_ID',l_inst_owner_id);
7542: fnd_message.set_token('NEW_PARTY_ID',l_td_owner_id);
7543: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);
7544: fnd_msg_pub.add;

Line 7541: fnd_message.set_token('OLD_PARTY_ID',l_inst_owner_id);

7537: -- for normal NON-partner order, checks for ownership override will be
7538: -- done anyway later in update_install_base since we do not have party_id here
7539: debug('Ownership Change but is not setup:'||l_ownership_override);
7540: fnd_message.set_name('CSI', 'CSI_SHIP_OWNER_MISMATCH');
7541: fnd_message.set_token('OLD_PARTY_ID',l_inst_owner_id);
7542: fnd_message.set_token('NEW_PARTY_ID',l_td_owner_id);
7543: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);
7544: fnd_msg_pub.add;
7545: RAISE fnd_api.g_exc_error;

Line 7542: fnd_message.set_token('NEW_PARTY_ID',l_td_owner_id);

7538: -- done anyway later in update_install_base since we do not have party_id here
7539: debug('Ownership Change but is not setup:'||l_ownership_override);
7540: fnd_message.set_name('CSI', 'CSI_SHIP_OWNER_MISMATCH');
7541: fnd_message.set_token('OLD_PARTY_ID',l_inst_owner_id);
7542: fnd_message.set_token('NEW_PARTY_ID',l_td_owner_id);
7543: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);
7544: fnd_msg_pub.add;
7545: RAISE fnd_api.g_exc_error;
7546: END IF;

Line 7543: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);

7539: debug('Ownership Change but is not setup:'||l_ownership_override);
7540: fnd_message.set_name('CSI', 'CSI_SHIP_OWNER_MISMATCH');
7541: fnd_message.set_token('OLD_PARTY_ID',l_inst_owner_id);
7542: fnd_message.set_token('NEW_PARTY_ID',l_td_owner_id);
7543: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);
7544: fnd_msg_pub.add;
7545: RAISE fnd_api.g_exc_error;
7546: END IF;
7547: END IF;

Line 7556: fnd_message.set_name('CSI','CSI_INT_QTY_CHK_FAILED');

7552: debug('Original Instance Qty : '||l_instance_rec.quantity);
7553: debug('Qty being processed : '||l_line_dtl_tbl(1).quantity);
7554: -- check if the quantity is greater than the instance quantity
7555: IF p_line_dtl_tbl(l_td_ind).quantity > l_instance_rec.quantity THEN
7556: fnd_message.set_name('CSI','CSI_INT_QTY_CHK_FAILED');
7557: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);
7558: fnd_msg_pub.add;
7559: RAISE fnd_api.g_exc_error;
7560: ELSIF l_line_dtl_tbl(1).quantity < l_instance_rec.quantity THEN

Line 7557: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);

7553: debug('Qty being processed : '||l_line_dtl_tbl(1).quantity);
7554: -- check if the quantity is greater than the instance quantity
7555: IF p_line_dtl_tbl(l_td_ind).quantity > l_instance_rec.quantity THEN
7556: fnd_message.set_name('CSI','CSI_INT_QTY_CHK_FAILED');
7557: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);
7558: fnd_msg_pub.add;
7559: RAISE fnd_api.g_exc_error;
7560: ELSIF l_line_dtl_tbl(1).quantity < l_instance_rec.quantity THEN
7561: -- split the instance and process....

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

7881: x_return_message := csi_t_gen_utility_pvt.dump_error_stack;
7882: rollback to cz_fulfillment;
7883: debug(x_return_message);
7884: WHEN others THEN
7885: fnd_message.set_name ('FND', 'FND_GENERIC_MESSAGE');
7886: fnd_message.set_token('MESSAGE', 'OTHERS Error :'||substr(sqlerrm, 1, 300));
7887: fnd_msg_pub.add;
7888: x_return_status := fnd_api.g_ret_sts_error;
7889: x_return_message := csi_t_gen_utility_pvt.dump_error_stack;

Line 7886: fnd_message.set_token('MESSAGE', 'OTHERS Error :'||substr(sqlerrm, 1, 300));

7882: rollback to cz_fulfillment;
7883: debug(x_return_message);
7884: WHEN others THEN
7885: fnd_message.set_name ('FND', 'FND_GENERIC_MESSAGE');
7886: fnd_message.set_token('MESSAGE', 'OTHERS Error :'||substr(sqlerrm, 1, 300));
7887: fnd_msg_pub.add;
7888: x_return_status := fnd_api.g_ret_sts_error;
7889: x_return_message := csi_t_gen_utility_pvt.dump_error_stack;
7890: rollback to cz_fulfillment;

Line 7996: fnd_message.set_name ('CSI', 'CSI_FULFILL_TLD_QTY_MISMATCH');

7992: l_p_tld_tbl(1).quantity := p_order_line_rec.fulfilled_quantity;
7993: END IF;
7994: ELSE
7995: IF p_order_line_rec.fulfilled_quantity <> l_src_tld_total_qty THEN
7996: fnd_message.set_name ('CSI', 'CSI_FULFILL_TLD_QTY_MISMATCH');
7997: fnd_message.set_token('FULFILLED_QTY', p_order_line_rec.fulfilled_quantity);
7998: fnd_message.set_token('TOT_TLD_QTY', l_src_tld_total_qty);
7999: fnd_msg_pub.add;
8000: END IF;

Line 7997: fnd_message.set_token('FULFILLED_QTY', p_order_line_rec.fulfilled_quantity);

7993: END IF;
7994: ELSE
7995: IF p_order_line_rec.fulfilled_quantity <> l_src_tld_total_qty THEN
7996: fnd_message.set_name ('CSI', 'CSI_FULFILL_TLD_QTY_MISMATCH');
7997: fnd_message.set_token('FULFILLED_QTY', p_order_line_rec.fulfilled_quantity);
7998: fnd_message.set_token('TOT_TLD_QTY', l_src_tld_total_qty);
7999: fnd_msg_pub.add;
8000: END IF;
8001: END IF;

Line 7998: fnd_message.set_token('TOT_TLD_QTY', l_src_tld_total_qty);

7994: ELSE
7995: IF p_order_line_rec.fulfilled_quantity <> l_src_tld_total_qty THEN
7996: fnd_message.set_name ('CSI', 'CSI_FULFILL_TLD_QTY_MISMATCH');
7997: fnd_message.set_token('FULFILLED_QTY', p_order_line_rec.fulfilled_quantity);
7998: fnd_message.set_token('TOT_TLD_QTY', l_src_tld_total_qty);
7999: fnd_msg_pub.add;
8000: END IF;
8001: END IF;
8002:

Line 8342: fnd_message.set_name('CSI','CSI_INT_OE_LINE_ID_INVALID');

8338: WHERE header_id = l_order_line_rec.header_id;
8339:
8340: EXCEPTION
8341: WHEN no_data_found THEN
8342: fnd_message.set_name('CSI','CSI_INT_OE_LINE_ID_INVALID');
8343: fnd_message.set_token('OE_LINE_ID', p_order_line_id);
8344: fnd_msg_pub.add;
8345: RAISE fnd_api.g_exc_error;
8346: END;

Line 8343: fnd_message.set_token('OE_LINE_ID', p_order_line_id);

8339:
8340: EXCEPTION
8341: WHEN no_data_found THEN
8342: fnd_message.set_name('CSI','CSI_INT_OE_LINE_ID_INVALID');
8343: fnd_message.set_token('OE_LINE_ID', p_order_line_id);
8344: fnd_msg_pub.add;
8345: RAISE fnd_api.g_exc_error;
8346: END;
8347:

Line 8413: fnd_message.set_name('CSI', 'CSI_ORDER_LINE_NOT_FULFILLED');

8409: THEN
8410: l_order_line_rec.fulfilled_quantity := l_order_line_rec.shipped_quantity;
8411: ELSE
8412: IF l_order_line_rec.fulfilled_quantity <= 0 THEN
8413: fnd_message.set_name('CSI', 'CSI_ORDER_LINE_NOT_FULFILLED');
8414: fnd_message.set_token('FULFILLED_QUANTITY', l_order_line_rec.fulfilled_quantity);
8415: fnd_msg_pub.add;
8416: RAISE fnd_api.g_exc_error;
8417: END IF;

Line 8414: fnd_message.set_token('FULFILLED_QUANTITY', l_order_line_rec.fulfilled_quantity);

8410: l_order_line_rec.fulfilled_quantity := l_order_line_rec.shipped_quantity;
8411: ELSE
8412: IF l_order_line_rec.fulfilled_quantity <= 0 THEN
8413: fnd_message.set_name('CSI', 'CSI_ORDER_LINE_NOT_FULFILLED');
8414: fnd_message.set_token('FULFILLED_QUANTITY', l_order_line_rec.fulfilled_quantity);
8415: fnd_msg_pub.add;
8416: RAISE fnd_api.g_exc_error;
8417: END IF;
8418: END IF;

Line 8443: fnd_message.set_name('CSI','CSI_TXN_SITE_USE_INVALID');

8439: AND HCAS.cust_acct_site_id = HCSU.cust_acct_site_id;
8440: l_default_info_rec.current_party_site_id := l_party_site_id;
8441: EXCEPTION
8442: WHEN no_data_found THEN
8443: fnd_message.set_name('CSI','CSI_TXN_SITE_USE_INVALID');
8444: fnd_message.set_token('SITE_USE_ID',l_current_site_use_id);
8445: fnd_message.set_token('SITE_USE_CODE','SITE_USE_ID');
8446: fnd_msg_pub.add;
8447: RAISE fnd_api.g_exc_error;

Line 8444: fnd_message.set_token('SITE_USE_ID',l_current_site_use_id);

8440: l_default_info_rec.current_party_site_id := l_party_site_id;
8441: EXCEPTION
8442: WHEN no_data_found THEN
8443: fnd_message.set_name('CSI','CSI_TXN_SITE_USE_INVALID');
8444: fnd_message.set_token('SITE_USE_ID',l_current_site_use_id);
8445: fnd_message.set_token('SITE_USE_CODE','SITE_USE_ID');
8446: fnd_msg_pub.add;
8447: RAISE fnd_api.g_exc_error;
8448: END;

Line 8445: fnd_message.set_token('SITE_USE_CODE','SITE_USE_ID');

8441: EXCEPTION
8442: WHEN no_data_found THEN
8443: fnd_message.set_name('CSI','CSI_TXN_SITE_USE_INVALID');
8444: fnd_message.set_token('SITE_USE_ID',l_current_site_use_id);
8445: fnd_message.set_token('SITE_USE_CODE','SITE_USE_ID');
8446: fnd_msg_pub.add;
8447: RAISE fnd_api.g_exc_error;
8448: END;
8449: END IF;

Line 8462: fnd_message.set_name('CSI','CSI_TXN_SITE_USE_INVALID');

8458: AND HCAS.cust_acct_site_id = HCSU.cust_acct_site_id;
8459: l_default_info_rec.install_party_site_id := l_party_site_id;
8460: EXCEPTION
8461: WHEN no_data_found THEN
8462: fnd_message.set_name('CSI','CSI_TXN_SITE_USE_INVALID');
8463: fnd_message.set_token('SITE_USE_ID',l_install_site_use_id);
8464: fnd_message.set_token('SITE_USE_CODE','SITE_USE_ID');
8465: fnd_msg_pub.add;
8466: RAISE fnd_api.g_exc_error;

Line 8463: fnd_message.set_token('SITE_USE_ID',l_install_site_use_id);

8459: l_default_info_rec.install_party_site_id := l_party_site_id;
8460: EXCEPTION
8461: WHEN no_data_found THEN
8462: fnd_message.set_name('CSI','CSI_TXN_SITE_USE_INVALID');
8463: fnd_message.set_token('SITE_USE_ID',l_install_site_use_id);
8464: fnd_message.set_token('SITE_USE_CODE','SITE_USE_ID');
8465: fnd_msg_pub.add;
8466: RAISE fnd_api.g_exc_error;
8467: END;

Line 8464: fnd_message.set_token('SITE_USE_CODE','SITE_USE_ID');

8460: EXCEPTION
8461: WHEN no_data_found THEN
8462: fnd_message.set_name('CSI','CSI_TXN_SITE_USE_INVALID');
8463: fnd_message.set_token('SITE_USE_ID',l_install_site_use_id);
8464: fnd_message.set_token('SITE_USE_CODE','SITE_USE_ID');
8465: fnd_msg_pub.add;
8466: RAISE fnd_api.g_exc_error;
8467: END;
8468: END IF;

Line 9109: fnd_message.set_name('CSI', 'CSI_TXN_SRC_ALREADY_PROCESSED');

9105: l_default_info_rec.transaction_line_id := l_transaction_line_id;
9106:
9107: IF l_processing_status = 'PROCESSED' THEN
9108: debug('This transaction detail is already PROCESSED.');
9109: fnd_message.set_name('CSI', 'CSI_TXN_SRC_ALREADY_PROCESSED');
9110: fnd_message.set_token('SRC_TBL', l_src_txn_table);
9111: fnd_message.set_token('SRC_ID', p_order_line_id);
9112: fnd_msg_pub.add;
9113: RAISE fnd_api.g_exc_error;

Line 9110: fnd_message.set_token('SRC_TBL', l_src_txn_table);

9106:
9107: IF l_processing_status = 'PROCESSED' THEN
9108: debug('This transaction detail is already PROCESSED.');
9109: fnd_message.set_name('CSI', 'CSI_TXN_SRC_ALREADY_PROCESSED');
9110: fnd_message.set_token('SRC_TBL', l_src_txn_table);
9111: fnd_message.set_token('SRC_ID', p_order_line_id);
9112: fnd_msg_pub.add;
9113: RAISE fnd_api.g_exc_error;
9114: END IF;

Line 9111: fnd_message.set_token('SRC_ID', p_order_line_id);

9107: IF l_processing_status = 'PROCESSED' THEN
9108: debug('This transaction detail is already PROCESSED.');
9109: fnd_message.set_name('CSI', 'CSI_TXN_SRC_ALREADY_PROCESSED');
9110: fnd_message.set_token('SRC_TBL', l_src_txn_table);
9111: fnd_message.set_token('SRC_ID', p_order_line_id);
9112: fnd_msg_pub.add;
9113: RAISE fnd_api.g_exc_error;
9114: END IF;
9115:

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

9412: p_error_message => l_error_message );
9413:
9414: WHEN others THEN
9415: rollback to order_fulfillment;
9416: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
9417: fnd_message.set_token('MESSAGE',substr(sqlerrm,1,540));
9418: fnd_msg_pub.add;
9419:
9420: x_return_status := fnd_api.g_ret_sts_error;

Line 9417: fnd_message.set_token('MESSAGE',substr(sqlerrm,1,540));

9413:
9414: WHEN others THEN
9415: rollback to order_fulfillment;
9416: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
9417: fnd_message.set_token('MESSAGE',substr(sqlerrm,1,540));
9418: fnd_msg_pub.add;
9419:
9420: x_return_status := fnd_api.g_ret_sts_error;
9421: l_error_message := csi_t_gen_utility_pvt.dump_error_stack;

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

9578: debug('DUP_VAL_ON_INDEX detected while creating Transaction Detail-Hdr.');
9579: l_continue := FALSE;
9580: WHEN others THEN
9581:
9582: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
9583: fnd_message.set_token('MESSAGE','insert_row failed '||sqlerrm);
9584: fnd_msg_pub.add;
9585: raise fnd_api.g_exc_error;
9586: END;

Line 9583: fnd_message.set_token('MESSAGE','insert_row failed '||sqlerrm);

9579: l_continue := FALSE;
9580: WHEN others THEN
9581:
9582: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
9583: fnd_message.set_token('MESSAGE','insert_row failed '||sqlerrm);
9584: fnd_msg_pub.add;
9585: raise fnd_api.g_exc_error;
9586: END;
9587: END ;

Line 9607: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');

9603: WHERE c.cust_acct_site_id = u.cust_acct_site_id
9604: AND u.site_use_id = x_order_shipment_tbl(i).ib_current_loc_id;
9605: EXCEPTION
9606: WHEN no_data_found THEN
9607: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');
9608: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_current_loc_id);
9609: fnd_msg_pub.add;
9610: raise fnd_api.g_exc_error;
9611: WHEN too_many_rows THEN

Line 9608: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_current_loc_id);

9604: AND u.site_use_id = x_order_shipment_tbl(i).ib_current_loc_id;
9605: EXCEPTION
9606: WHEN no_data_found THEN
9607: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');
9608: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_current_loc_id);
9609: fnd_msg_pub.add;
9610: raise fnd_api.g_exc_error;
9611: WHEN too_many_rows THEN
9612: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');

Line 9612: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');

9608: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_current_loc_id);
9609: fnd_msg_pub.add;
9610: raise fnd_api.g_exc_error;
9611: WHEN too_many_rows THEN
9612: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');
9613: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_current_loc_id);
9614: fnd_msg_pub.add;
9615: raise fnd_api.g_exc_error;
9616: END;

Line 9613: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_current_loc_id);

9609: fnd_msg_pub.add;
9610: raise fnd_api.g_exc_error;
9611: WHEN too_many_rows THEN
9612: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');
9613: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_current_loc_id);
9614: fnd_msg_pub.add;
9615: raise fnd_api.g_exc_error;
9616: END;
9617:

Line 9633: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');

9629: WHERE c.cust_acct_site_id = u.cust_acct_site_id
9630: AND u.site_use_id = x_order_shipment_tbl(i).ib_install_loc_id;
9631: EXCEPTION
9632: WHEN no_data_found THEN
9633: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');
9634: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_install_loc_id);
9635: fnd_msg_pub.add;
9636: raise fnd_api.g_exc_error;
9637: WHEN too_many_rows THEN

Line 9634: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_install_loc_id);

9630: AND u.site_use_id = x_order_shipment_tbl(i).ib_install_loc_id;
9631: EXCEPTION
9632: WHEN no_data_found THEN
9633: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');
9634: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_install_loc_id);
9635: fnd_msg_pub.add;
9636: raise fnd_api.g_exc_error;
9637: WHEN too_many_rows THEN
9638: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');

Line 9638: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');

9634: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_install_loc_id);
9635: fnd_msg_pub.add;
9636: raise fnd_api.g_exc_error;
9637: WHEN too_many_rows THEN
9638: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');
9639: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_install_loc_id);
9640: fnd_msg_pub.add;
9641: raise fnd_api.g_exc_error;
9642: END;

Line 9639: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_install_loc_id);

9635: fnd_msg_pub.add;
9636: raise fnd_api.g_exc_error;
9637: WHEN too_many_rows THEN
9638: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');
9639: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_install_loc_id);
9640: fnd_msg_pub.add;
9641: raise fnd_api.g_exc_error;
9642: END;
9643: END IF;

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

10099:
10100: IF l_partner_rec.IB_OWNER = 'END_CUSTOMER'
10101: THEN
10102: IF l_partner_rec.END_CUSTOMER_ID is null Then
10103: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
10104: fnd_msg_pub.add;
10105: raise fnd_api.g_exc_error;
10106: ELSE
10107: mmt_rec.ib_owner := l_partner_rec.ib_owner;

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

10121: IF mmt_rec.ib_install_loc = 'END_CUSTOMER'
10122: THEN
10123: IF l_partner_rec.end_customer_site_use_id is null
10124: THEN
10125: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
10126: fnd_msg_pub.add;
10127: raise fnd_api.g_exc_error;
10128: ELSE
10129: mmt_rec.ib_install_loc_id := l_partner_rec.end_customer_site_use_id;

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

10131: ELSIF mmt_rec.ib_install_loc = 'SHIP_TO'
10132: THEN
10133: IF mmt_rec.ship_to_org_id is null
10134: THEN
10135: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
10136: fnd_msg_pub.add;
10137: raise fnd_api.g_exc_error;
10138: ELSE
10139: mmt_rec.ib_install_loc_id := mmt_rec.ship_to_org_id;

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

10141: ELSIF mmt_rec.ib_install_loc = 'SOLD_TO'
10142: THEN
10143: IF l_partner_rec.SOLD_TO_SITE_USE_ID is null -- 3412544 mmt_rec.sold_to_org_id is null
10144: THEN
10145: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
10146: fnd_msg_pub.add;
10147: raise fnd_api.g_exc_error;
10148: ELSE
10149: mmt_rec.ib_install_loc_id := l_partner_rec.SOLD_TO_SITE_USE_ID; -- 3412544 mmt_rec.sold_to_org_id;

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

10151: ELSIF mmt_rec.ib_install_loc = 'DELIVER_TO'
10152: THEN
10153: IF mmt_rec.deliver_to_org_id is null
10154: THEN
10155: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
10156: fnd_msg_pub.add;
10157: raise fnd_api.g_exc_error;
10158: ELSE
10159: mmt_rec.ib_install_loc_id := mmt_rec.deliver_to_org_id;

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

10161: ELSIF mmt_rec.ib_install_loc = 'BILL_TO'
10162: THEN
10163: IF mmt_rec.invoice_to_org_id is null
10164: THEN
10165: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
10166: fnd_msg_pub.add;
10167: raise fnd_api.g_exc_error;
10168: ELSE
10169: mmt_rec.ib_install_loc_id := mmt_rec.invoice_to_org_id;

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

10182: IF mmt_rec.ib_current_loc = 'END_CUSTOMER'
10183: THEN
10184: IF l_partner_rec.end_customer_site_use_id is null
10185: THEN
10186: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
10187: fnd_msg_pub.add;
10188: raise fnd_api.g_exc_error;
10189: ELSE
10190: mmt_rec.ib_current_loc_id := l_partner_rec.end_customer_site_use_id;

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

10192: ELSIF mmt_rec.ib_current_loc = 'SHIP_TO'
10193: THEN
10194: IF mmt_rec.ship_to_org_id is null
10195: THEN
10196: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
10197: fnd_msg_pub.add;
10198: raise fnd_api.g_exc_error;
10199: ELSE
10200: mmt_rec.ib_current_loc_id := mmt_rec.ship_to_org_id;

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

10202: ELSIF mmt_rec.ib_current_loc = 'SOLD_TO'
10203: THEN
10204: IF l_partner_rec.SOLD_TO_SITE_USE_ID is null -- 3412544 mmt_rec.sold_to_org_id is null
10205: THEN
10206: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
10207: fnd_msg_pub.add;
10208: raise fnd_api.g_exc_error;
10209: ELSE
10210: mmt_rec.ib_current_loc_id := l_partner_rec.SOLD_TO_SITE_USE_ID; -- 3412544 mmt_rec.sold_to_org_id;

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

10212: ELSIF mmt_rec.ib_current_loc = 'DELIVER_TO'
10213: THEN
10214: IF mmt_rec.deliver_to_org_id is null
10215: THEN
10216: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
10217: fnd_msg_pub.add;
10218: raise fnd_api.g_exc_error;
10219: ELSE
10220: mmt_rec.ib_current_loc_id := mmt_rec.deliver_to_org_id;

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

10222: ELSIF mmt_rec.ib_current_loc = 'BILL_TO'
10223: THEN
10224: IF mmt_rec.invoice_to_org_id is null
10225: THEN
10226: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
10227: fnd_msg_pub.add;
10228: raise fnd_api.g_exc_error;
10229: ELSE
10230: mmt_rec.ib_current_loc_id := mmt_rec.invoice_to_org_id;

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

10463: debug('Error(E) :'||l_error_message);
10464: px_trx_error_rec := l_error_rec;
10465:
10466: WHEN others THEN
10467: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
10468: fnd_message.set_token('MESSAGE',substr(sqlerrm,1,540));
10469: fnd_msg_pub.add;
10470:
10471: x_return_status := fnd_api.g_ret_sts_error;

Line 10468: fnd_message.set_token('MESSAGE',substr(sqlerrm,1,540));

10464: px_trx_error_rec := l_error_rec;
10465:
10466: WHEN others THEN
10467: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
10468: fnd_message.set_token('MESSAGE',substr(sqlerrm,1,540));
10469: fnd_msg_pub.add;
10470:
10471: x_return_status := fnd_api.g_ret_sts_error;
10472: l_error_rec.source_id := p_mtl_txn_id; -- For 4168922