DBA Data[Home] [Help]

APPS.CSI_ORDER_FULFILL_PUB dependencies on FND_MESSAGE

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

116: FROM csi_ib_txn_types
117: WHERE sub_type_id = p_sub_type_id;
118: EXCEPTION
119: WHEN no_data_found THEN
120: fnd_message.set_name('CSI','CSI_INT_SUB_TYPE_REC_MISSING');
121: fnd_message.set_token('SUB_TYPE_ID', p_sub_type_id);
122: fnd_message.set_token('TRANSACTION_TYPE_ID', p_transaction_type_id);
123: fnd_msg_pub.add;
124: RAISE fnd_api.g_exc_error;

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

117: WHERE sub_type_id = p_sub_type_id;
118: EXCEPTION
119: WHEN no_data_found THEN
120: fnd_message.set_name('CSI','CSI_INT_SUB_TYPE_REC_MISSING');
121: fnd_message.set_token('SUB_TYPE_ID', p_sub_type_id);
122: fnd_message.set_token('TRANSACTION_TYPE_ID', p_transaction_type_id);
123: fnd_msg_pub.add;
124: RAISE fnd_api.g_exc_error;
125: END;

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

118: EXCEPTION
119: WHEN no_data_found THEN
120: fnd_message.set_name('CSI','CSI_INT_SUB_TYPE_REC_MISSING');
121: fnd_message.set_token('SUB_TYPE_ID', p_sub_type_id);
122: fnd_message.set_token('TRANSACTION_TYPE_ID', p_transaction_type_id);
123: fnd_msg_pub.add;
124: RAISE fnd_api.g_exc_error;
125: END;
126: x_sub_type_rec := l_sub_type_rec;

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

1571:
1572: EXCEPTION
1573: WHEN no_data_found THEN
1574: x_return_status := fnd_api.g_ret_sts_error;
1575: FND_MESSAGE.set_name('CSI','CSI_INVALID_TXN_TYPE_ID');
1576: FND_MSG_PUB.add;
1577: WHEN too_many_rows THEN
1578: x_return_status := fnd_api.g_ret_sts_error;
1579: FND_MESSAGE.set_name('CSI','CSI_INVALID_TXN_TYPE_ID');

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

1575: FND_MESSAGE.set_name('CSI','CSI_INVALID_TXN_TYPE_ID');
1576: FND_MSG_PUB.add;
1577: WHEN too_many_rows THEN
1578: x_return_status := fnd_api.g_ret_sts_error;
1579: FND_MESSAGE.set_name('CSI','CSI_INVALID_TXN_TYPE_ID');
1580: FND_MSG_PUB.add;
1581: END get_txn_sub_type_id;
1582:
1583: /* This routine splits the transaction details in to quantity one each */

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

2348: l_end_customer_id := p_order_line_rec.sold_to_org_id;
2349: END IF;
2350:
2351: IF nvl(l_end_customer_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
2352: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
2353: fnd_msg_pub.add;
2354: RAISE fnd_api.g_exc_error;
2355: END IF;
2356:

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

2377: ELSIF l_partner_rec.ib_current_location = 'BILL_TO' THEN
2378: l_current_site_use_id := p_order_line_rec.invoice_to_org_id;
2379: END IF;
2380: IF nvl(l_current_site_use_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
2381: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
2382: fnd_msg_pub.add;
2383: RAISE fnd_api.g_exc_error;
2384: END IF;
2385:

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

2407: ELSIF l_partner_rec.ib_installed_at_location = 'BILL_TO' THEN
2408: l_install_site_use_id := p_order_line_rec.invoice_to_org_id;
2409: END IF;
2410: IF nvl(l_install_site_use_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
2411: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
2412: fnd_msg_pub.add;
2413: RAISE fnd_api.g_exc_error;
2414: END IF;
2415:

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

2735: (active_end_date > sysdate));
2736: END IF;
2737: EXCEPTION
2738: WHEN no_data_found THEN
2739: fnd_message.set_name('CSI','CSI_INT_INV_INSTA_PTY_ID');
2740: fnd_message.set_token('INSTANCE_ID',l_u_instance_rec.instance_id);
2741: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',l_pty_dtl_tbl(l_p_ind).relationship_type_code);
2742: fnd_msg_pub.add;
2743: IF l_pty_dtl_tbl(l_p_ind).relationship_type_code = 'OWNER' THEN

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

2736: END IF;
2737: EXCEPTION
2738: WHEN no_data_found THEN
2739: fnd_message.set_name('CSI','CSI_INT_INV_INSTA_PTY_ID');
2740: fnd_message.set_token('INSTANCE_ID',l_u_instance_rec.instance_id);
2741: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',l_pty_dtl_tbl(l_p_ind).relationship_type_code);
2742: fnd_msg_pub.add;
2743: IF l_pty_dtl_tbl(l_p_ind).relationship_type_code = 'OWNER' THEN
2744: x_return_status := fnd_api.g_ret_sts_error;

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

2737: EXCEPTION
2738: WHEN no_data_found THEN
2739: fnd_message.set_name('CSI','CSI_INT_INV_INSTA_PTY_ID');
2740: fnd_message.set_token('INSTANCE_ID',l_u_instance_rec.instance_id);
2741: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',l_pty_dtl_tbl(l_p_ind).relationship_type_code);
2742: fnd_msg_pub.add;
2743: IF l_pty_dtl_tbl(l_p_ind).relationship_type_code = 'OWNER' THEN
2744: x_return_status := fnd_api.g_ret_sts_error;
2745: raise fnd_api.g_exc_error;

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

2746: ELSE
2747: l_pty_dtl_tbl(l_pc_ind).contact_party_id := l_ind;
2748: END IF;
2749: WHEN too_many_rows THEN
2750: fnd_message.set_name('CSI','CSI_INT_MANY_INSTA_PTY_FOUND');
2751: fnd_message.set_token('INSTANCE_ID',l_u_instance_rec.instance_id);
2752: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',l_pty_dtl_tbl(l_p_ind).relationship_type_code);
2753: fnd_msg_pub.add;
2754: x_return_status := fnd_api.g_ret_sts_error;

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

2747: l_pty_dtl_tbl(l_pc_ind).contact_party_id := l_ind;
2748: END IF;
2749: WHEN too_many_rows THEN
2750: fnd_message.set_name('CSI','CSI_INT_MANY_INSTA_PTY_FOUND');
2751: fnd_message.set_token('INSTANCE_ID',l_u_instance_rec.instance_id);
2752: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',l_pty_dtl_tbl(l_p_ind).relationship_type_code);
2753: fnd_msg_pub.add;
2754: x_return_status := fnd_api.g_ret_sts_error;
2755: raise fnd_api.g_exc_error;

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

2748: END IF;
2749: WHEN too_many_rows THEN
2750: fnd_message.set_name('CSI','CSI_INT_MANY_INSTA_PTY_FOUND');
2751: fnd_message.set_token('INSTANCE_ID',l_u_instance_rec.instance_id);
2752: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',l_pty_dtl_tbl(l_p_ind).relationship_type_code);
2753: fnd_msg_pub.add;
2754: x_return_status := fnd_api.g_ret_sts_error;
2755: raise fnd_api.g_exc_error;
2756: END;

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

3000: END IF;
3001:
3002: IF NOT(l_instances_found) THEN
3003:
3004: fnd_message.set_name('CSI', 'CSI_NO_WIP_COMP_INSTANCE');
3005: fnd_message.set_token('INV_ITEM_ID', p_inventory_item_id);
3006: fnd_message.set_token('WIP_ENTITY_ID', p_wip_entity_id);
3007: fnd_msg_pub.add;
3008:

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

3001:
3002: IF NOT(l_instances_found) THEN
3003:
3004: fnd_message.set_name('CSI', 'CSI_NO_WIP_COMP_INSTANCE');
3005: fnd_message.set_token('INV_ITEM_ID', p_inventory_item_id);
3006: fnd_message.set_token('WIP_ENTITY_ID', p_wip_entity_id);
3007: fnd_msg_pub.add;
3008:
3009: RAISE fnd_api.g_exc_error;

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

3002: IF NOT(l_instances_found) THEN
3003:
3004: fnd_message.set_name('CSI', 'CSI_NO_WIP_COMP_INSTANCE');
3005: fnd_message.set_token('INV_ITEM_ID', p_inventory_item_id);
3006: fnd_message.set_token('WIP_ENTITY_ID', p_wip_entity_id);
3007: fnd_msg_pub.add;
3008:
3009: RAISE fnd_api.g_exc_error;
3010: END IF;

Line 5248: FND_MESSAGE.SET_NAME('CSI','CSI_API_CORE_BOM_EXPL_ERROR');

5244: debug (' Bom explosion error code > 0 '|| l_Error_Code ||' '||l_err_msg);
5245: ELSIF l_Error_Code > 0 THEN
5246: debug (' Bom explosion error code < 0'|| l_Error_Code ||' '||l_err_msg);
5247: END IF;
5248: FND_MESSAGE.SET_NAME('CSI','CSI_API_CORE_BOM_EXPL_ERROR');
5249: FND_MSG_PUB.Add;
5250: x_return_status := fnd_api.g_ret_sts_error;
5251: RAISE FND_API.G_EXC_ERROR;
5252: END IF; -- error

Line 5385: --FND_MESSAGE.SET_NAME('CSI','CSI_API_CORE_BOM_EXPL_ERROR');

5381: debug (' Bom explosion error code > 0 '|| l_Error_Code ||' '||l_err_msg);
5382: ELSIF l_Error_Code > 0 THEN
5383: debug (' Bom explosion error code < 0'|| l_Error_Code ||' '||l_err_msg);
5384: END IF;
5385: --FND_MESSAGE.SET_NAME('CSI','CSI_API_CORE_BOM_EXPL_ERROR');
5386: --FND_MSG_PUB.Add;
5387: --x_return_status := fnd_api.g_ret_sts_error;
5388: RAISE FND_API.G_EXC_ERROR;
5389: END IF;

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

7348: EXCEPTION
7349: WHEN fnd_api.g_exc_error THEN
7350: x_return_status := fnd_api.g_ret_sts_error;
7351: WHEN others then
7352: fnd_message.set_name ('FND','FND_GENERIC_MESSAGE');
7353: fnd_message.set_token('MESSAGE', substr(sqlerrm, 1, 300));
7354: fnd_msg_pub.add;
7355: x_return_status := fnd_api.g_ret_sts_error;
7356: END process_ato_option_nsrl;

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

7349: WHEN fnd_api.g_exc_error THEN
7350: x_return_status := fnd_api.g_ret_sts_error;
7351: WHEN others then
7352: fnd_message.set_name ('FND','FND_GENERIC_MESSAGE');
7353: fnd_message.set_token('MESSAGE', substr(sqlerrm, 1, 300));
7354: fnd_msg_pub.add;
7355: x_return_status := fnd_api.g_ret_sts_error;
7356: END process_ato_option_nsrl;
7357:

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

7864: x_return_status := fnd_api.g_ret_sts_success;
7865: WHEN fnd_api.g_exc_error THEN
7866: x_return_status := fnd_api.g_ret_sts_error;
7867: WHEN others then
7868: fnd_message.set_name ('FND','FND_GENERIC_MESSAGE');
7869: fnd_message.set_token('MESSAGE', substr(sqlerrm, 1, 300));
7870: fnd_msg_pub.add;
7871: x_return_status := fnd_api.g_ret_sts_error;
7872: END process_ato_option_srl;

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

7865: WHEN fnd_api.g_exc_error THEN
7866: x_return_status := fnd_api.g_ret_sts_error;
7867: WHEN others then
7868: fnd_message.set_name ('FND','FND_GENERIC_MESSAGE');
7869: fnd_message.set_token('MESSAGE', substr(sqlerrm, 1, 300));
7870: fnd_msg_pub.add;
7871: x_return_status := fnd_api.g_ret_sts_error;
7872: END process_ato_option_srl;
7873:

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

8237: -- addtl. check since the TLD rec will have the OM Master / Vldn Orgn
8238: -- as the inv_organization_id on it for Fulfillments.
8239: l_vld_orgn_id := l_instance_rec.vld_organization_id;
8240: ELSE
8241: fnd_message.set_name('CSI','CSI_INVALID_VLD_MAST_COMB');
8242: fnd_msg_pub.add;
8243: RAISE fnd_api.g_exc_error;
8244: END IF;
8245: END IF;

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

8281: <> fnd_api.g_miss_date THEN
8282: debug('Active End date :'||l_line_dtl_tbl(1).active_end_date
8283: || 'provided on transaction line detail: '
8284: || l_line_dtl_tbl(1).txn_line_detail_id);
8285: fnd_message.set_name('CSI','CSI_TXN_INVALID_INST_REF');
8286: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);
8287: fnd_msg_pub.add;
8288: RAISE fnd_api.g_exc_error;
8289: ELSIF l_inst_loc_type

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

8282: debug('Active End date :'||l_line_dtl_tbl(1).active_end_date
8283: || 'provided on transaction line detail: '
8284: || l_line_dtl_tbl(1).txn_line_detail_id);
8285: fnd_message.set_name('CSI','CSI_TXN_INVALID_INST_REF');
8286: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);
8287: fnd_msg_pub.add;
8288: RAISE fnd_api.g_exc_error;
8289: ELSIF l_inst_loc_type
8290: NOT IN ( 'INVENTORY','HZ_PARTY_SITES', 'HZ_LOCATIONS', 'VENDOR_SITE', 'INTERNAL_SITE')

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

8289: ELSIF l_inst_loc_type
8290: NOT IN ( 'INVENTORY','HZ_PARTY_SITES', 'HZ_LOCATIONS', 'VENDOR_SITE', 'INTERNAL_SITE')
8291: THEN
8292: debug('Location type code is :'||l_inst_loc_type);
8293: fnd_message.set_name('CSI', 'CSI_TXN_SRC_LOC_INVALID');
8294: fnd_message.set_token('LOC_CODE', l_inst_loc_type);
8295: fnd_message.set_token('SRC_NAME', 'Conversion to a Customer Ownership ');
8296: fnd_msg_pub.add;
8297: RAISE fnd_api.g_exc_error;

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

8290: NOT IN ( 'INVENTORY','HZ_PARTY_SITES', 'HZ_LOCATIONS', 'VENDOR_SITE', 'INTERNAL_SITE')
8291: THEN
8292: debug('Location type code is :'||l_inst_loc_type);
8293: fnd_message.set_name('CSI', 'CSI_TXN_SRC_LOC_INVALID');
8294: fnd_message.set_token('LOC_CODE', l_inst_loc_type);
8295: fnd_message.set_token('SRC_NAME', 'Conversion to a Customer Ownership ');
8296: fnd_msg_pub.add;
8297: RAISE fnd_api.g_exc_error;
8298: -- allow only externally located

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

8291: THEN
8292: debug('Location type code is :'||l_inst_loc_type);
8293: fnd_message.set_name('CSI', 'CSI_TXN_SRC_LOC_INVALID');
8294: fnd_message.set_token('LOC_CODE', l_inst_loc_type);
8295: fnd_message.set_token('SRC_NAME', 'Conversion to a Customer Ownership ');
8296: fnd_msg_pub.add;
8297: RAISE fnd_api.g_exc_error;
8298: -- allow only externally located
8299: END IF;

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

8303: IF l_inst_owner_type <> l_td_owner_type THEN
8304: -- let's trap as an error currently so that it prevents
8305: -- ownership changes from HZ_PARTY TO PO_VENDOR or etc etc
8306: debug('Owner Change.');
8307: fnd_message.set_name('CSI', 'CSI_API_INVALID_PARTY_SOURCE');
8308: fnd_message.set_token('PARTY_SOURCE_TABLE', l_td_owner_type);
8309: fnd_msg_pub.add;
8310: RAISE fnd_api.g_exc_error;
8311: ELSIF l_td_owner_id <> l_inst_owner_id THEN

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

8304: -- let's trap as an error currently so that it prevents
8305: -- ownership changes from HZ_PARTY TO PO_VENDOR or etc etc
8306: debug('Owner Change.');
8307: fnd_message.set_name('CSI', 'CSI_API_INVALID_PARTY_SOURCE');
8308: fnd_message.set_token('PARTY_SOURCE_TABLE', l_td_owner_type);
8309: fnd_msg_pub.add;
8310: RAISE fnd_api.g_exc_error;
8311: ELSIF l_td_owner_id <> l_inst_owner_id THEN
8312: IF l_ownership_override = 'Y' THEN

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

8312: IF l_ownership_override = 'Y' THEN
8313: debug('Ownership Change and is allowed.');
8314: ELSE
8315: debug('Ownership Change but is not setup:'||l_ownership_override);
8316: fnd_message.set_name('CSI', 'CSI_SHIP_OWNER_MISMATCH');
8317: fnd_message.set_token('OLD_PARTY_ID',l_inst_owner_id);
8318: fnd_message.set_token('NEW_PARTY_ID',l_td_owner_id);
8319: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);
8320: fnd_msg_pub.add;

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

8313: debug('Ownership Change and is allowed.');
8314: ELSE
8315: debug('Ownership Change but is not setup:'||l_ownership_override);
8316: fnd_message.set_name('CSI', 'CSI_SHIP_OWNER_MISMATCH');
8317: fnd_message.set_token('OLD_PARTY_ID',l_inst_owner_id);
8318: fnd_message.set_token('NEW_PARTY_ID',l_td_owner_id);
8319: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);
8320: fnd_msg_pub.add;
8321: RAISE fnd_api.g_exc_error;

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

8314: ELSE
8315: debug('Ownership Change but is not setup:'||l_ownership_override);
8316: fnd_message.set_name('CSI', 'CSI_SHIP_OWNER_MISMATCH');
8317: fnd_message.set_token('OLD_PARTY_ID',l_inst_owner_id);
8318: fnd_message.set_token('NEW_PARTY_ID',l_td_owner_id);
8319: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);
8320: fnd_msg_pub.add;
8321: RAISE fnd_api.g_exc_error;
8322: END IF;

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

8315: debug('Ownership Change but is not setup:'||l_ownership_override);
8316: fnd_message.set_name('CSI', 'CSI_SHIP_OWNER_MISMATCH');
8317: fnd_message.set_token('OLD_PARTY_ID',l_inst_owner_id);
8318: fnd_message.set_token('NEW_PARTY_ID',l_td_owner_id);
8319: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);
8320: fnd_msg_pub.add;
8321: RAISE fnd_api.g_exc_error;
8322: END IF;
8323: END IF;

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

8333: THEN -- end customer exists
8334: -- for normal NON-partner order, checks for ownership override will be
8335: -- done anyway later in update_install_base since we do not have party_id here
8336: debug('Ownership Change but is not setup:'||l_ownership_override);
8337: fnd_message.set_name('CSI', 'CSI_SHIP_OWNER_MISMATCH');
8338: fnd_message.set_token('OLD_PARTY_ID',l_inst_owner_id);
8339: fnd_message.set_token('NEW_PARTY_ID',l_td_owner_id);
8340: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);
8341: fnd_msg_pub.add;

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

8334: -- for normal NON-partner order, checks for ownership override will be
8335: -- done anyway later in update_install_base since we do not have party_id here
8336: debug('Ownership Change but is not setup:'||l_ownership_override);
8337: fnd_message.set_name('CSI', 'CSI_SHIP_OWNER_MISMATCH');
8338: fnd_message.set_token('OLD_PARTY_ID',l_inst_owner_id);
8339: fnd_message.set_token('NEW_PARTY_ID',l_td_owner_id);
8340: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);
8341: fnd_msg_pub.add;
8342: RAISE fnd_api.g_exc_error;

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

8335: -- done anyway later in update_install_base since we do not have party_id here
8336: debug('Ownership Change but is not setup:'||l_ownership_override);
8337: fnd_message.set_name('CSI', 'CSI_SHIP_OWNER_MISMATCH');
8338: fnd_message.set_token('OLD_PARTY_ID',l_inst_owner_id);
8339: fnd_message.set_token('NEW_PARTY_ID',l_td_owner_id);
8340: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);
8341: fnd_msg_pub.add;
8342: RAISE fnd_api.g_exc_error;
8343: END IF;

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

8336: debug('Ownership Change but is not setup:'||l_ownership_override);
8337: fnd_message.set_name('CSI', 'CSI_SHIP_OWNER_MISMATCH');
8338: fnd_message.set_token('OLD_PARTY_ID',l_inst_owner_id);
8339: fnd_message.set_token('NEW_PARTY_ID',l_td_owner_id);
8340: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);
8341: fnd_msg_pub.add;
8342: RAISE fnd_api.g_exc_error;
8343: END IF;
8344: END IF;

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

8349: debug('Original Instance Qty : '||l_instance_rec.quantity);
8350: debug('Qty being processed : '||l_line_dtl_tbl(1).quantity);
8351: -- check if the quantity is greater than the instance quantity
8352: IF p_line_dtl_tbl(l_td_ind).quantity > l_instance_rec.quantity THEN
8353: fnd_message.set_name('CSI','CSI_INT_QTY_CHK_FAILED');
8354: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);
8355: fnd_msg_pub.add;
8356: RAISE fnd_api.g_exc_error;
8357: ELSIF l_line_dtl_tbl(1).quantity < l_instance_rec.quantity THEN

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

8350: debug('Qty being processed : '||l_line_dtl_tbl(1).quantity);
8351: -- check if the quantity is greater than the instance quantity
8352: IF p_line_dtl_tbl(l_td_ind).quantity > l_instance_rec.quantity THEN
8353: fnd_message.set_name('CSI','CSI_INT_QTY_CHK_FAILED');
8354: fnd_message.set_token('INSTANCE_ID',l_instance_rec.instance_id);
8355: fnd_msg_pub.add;
8356: RAISE fnd_api.g_exc_error;
8357: ELSIF l_line_dtl_tbl(1).quantity < l_instance_rec.quantity THEN
8358: -- split the instance and process....

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

8678: x_return_message := csi_t_gen_utility_pvt.dump_error_stack;
8679: rollback to cz_fulfillment;
8680: debug(x_return_message);
8681: WHEN others THEN
8682: fnd_message.set_name ('FND', 'FND_GENERIC_MESSAGE');
8683: fnd_message.set_token('MESSAGE', 'OTHERS Error :'||substr(sqlerrm, 1, 300));
8684: fnd_msg_pub.add;
8685: x_return_status := fnd_api.g_ret_sts_error;
8686: x_return_message := csi_t_gen_utility_pvt.dump_error_stack;

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

8679: rollback to cz_fulfillment;
8680: debug(x_return_message);
8681: WHEN others THEN
8682: fnd_message.set_name ('FND', 'FND_GENERIC_MESSAGE');
8683: fnd_message.set_token('MESSAGE', 'OTHERS Error :'||substr(sqlerrm, 1, 300));
8684: fnd_msg_pub.add;
8685: x_return_status := fnd_api.g_ret_sts_error;
8686: x_return_message := csi_t_gen_utility_pvt.dump_error_stack;
8687: rollback to cz_fulfillment;

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

8792: l_p_tld_tbl(1).quantity := p_order_line_rec.fulfilled_quantity;
8793: END IF;
8794: ELSE
8795: IF p_order_line_rec.fulfilled_quantity <> l_src_tld_total_qty THEN
8796: fnd_message.set_name ('CSI', 'CSI_FULFILL_TLD_QTY_MISMATCH');
8797: fnd_message.set_token('FULFILLED_QTY', p_order_line_rec.fulfilled_quantity);
8798: fnd_message.set_token('TOT_TLD_QTY', l_src_tld_total_qty);
8799: fnd_msg_pub.add;
8800: END IF;

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

8793: END IF;
8794: ELSE
8795: IF p_order_line_rec.fulfilled_quantity <> l_src_tld_total_qty THEN
8796: fnd_message.set_name ('CSI', 'CSI_FULFILL_TLD_QTY_MISMATCH');
8797: fnd_message.set_token('FULFILLED_QTY', p_order_line_rec.fulfilled_quantity);
8798: fnd_message.set_token('TOT_TLD_QTY', l_src_tld_total_qty);
8799: fnd_msg_pub.add;
8800: END IF;
8801: END IF;

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

8794: ELSE
8795: IF p_order_line_rec.fulfilled_quantity <> l_src_tld_total_qty THEN
8796: fnd_message.set_name ('CSI', 'CSI_FULFILL_TLD_QTY_MISMATCH');
8797: fnd_message.set_token('FULFILLED_QTY', p_order_line_rec.fulfilled_quantity);
8798: fnd_message.set_token('TOT_TLD_QTY', l_src_tld_total_qty);
8799: fnd_msg_pub.add;
8800: END IF;
8801: END IF;
8802:

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

8826: /*
8827:
8828: EXCEPTION
8829: WHEN no_data_found then
8830: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');
8831: fnd_message.set_token('LOCATION_ID', px_default_info_rec.current_party_site_id);
8832: fnd_msg_pub.add;
8833: raise fnd_api.g_exc_error;
8834: WHEN too_many_rows then

Line 8831: fnd_message.set_token('LOCATION_ID', px_default_info_rec.current_party_site_id);

8827:
8828: EXCEPTION
8829: WHEN no_data_found then
8830: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');
8831: fnd_message.set_token('LOCATION_ID', px_default_info_rec.current_party_site_id);
8832: fnd_msg_pub.add;
8833: raise fnd_api.g_exc_error;
8834: WHEN too_many_rows then
8835: debug('Many Party sites found');

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

8861: /*
8862:
8863: EXCEPTION
8864: WHEN no_data_found then
8865: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');
8866: fnd_message.set_token('LOCATION_ID', px_default_info_rec.install_party_site_id);
8867: fnd_msg_pub.add;
8868: raise fnd_api.g_exc_error;
8869: WHEN too_many_rows then

Line 8866: fnd_message.set_token('LOCATION_ID', px_default_info_rec.install_party_site_id);

8862:
8863: EXCEPTION
8864: WHEN no_data_found then
8865: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');
8866: fnd_message.set_token('LOCATION_ID', px_default_info_rec.install_party_site_id);
8867: fnd_msg_pub.add;
8868: raise fnd_api.g_exc_error;
8869: WHEN too_many_rows then
8870: debug('Many Party sites found');

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

9259: WHERE header_id = l_order_line_rec.header_id;
9260:
9261: EXCEPTION
9262: WHEN no_data_found THEN
9263: fnd_message.set_name('CSI','CSI_INT_OE_LINE_ID_INVALID');
9264: fnd_message.set_token('OE_LINE_ID', p_order_line_id);
9265: fnd_msg_pub.add;
9266: RAISE fnd_api.g_exc_error;
9267: END;

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

9260:
9261: EXCEPTION
9262: WHEN no_data_found THEN
9263: fnd_message.set_name('CSI','CSI_INT_OE_LINE_ID_INVALID');
9264: fnd_message.set_token('OE_LINE_ID', p_order_line_id);
9265: fnd_msg_pub.add;
9266: RAISE fnd_api.g_exc_error;
9267: END;
9268:

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

9330: THEN
9331: l_order_line_rec.fulfilled_quantity := l_order_line_rec.shipped_quantity;
9332: ELSE
9333: IF l_order_line_rec.fulfilled_quantity <= 0 THEN
9334: fnd_message.set_name('CSI', 'CSI_ORDER_LINE_NOT_FULFILLED');
9335: fnd_message.set_token('FULFILLED_QUANTITY', l_order_line_rec.fulfilled_quantity);
9336: fnd_msg_pub.add;
9337: RAISE fnd_api.g_exc_error;
9338: END IF;

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

9331: l_order_line_rec.fulfilled_quantity := l_order_line_rec.shipped_quantity;
9332: ELSE
9333: IF l_order_line_rec.fulfilled_quantity <= 0 THEN
9334: fnd_message.set_name('CSI', 'CSI_ORDER_LINE_NOT_FULFILLED');
9335: fnd_message.set_token('FULFILLED_QUANTITY', l_order_line_rec.fulfilled_quantity);
9336: fnd_msg_pub.add;
9337: RAISE fnd_api.g_exc_error;
9338: END IF;
9339: END IF;

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

9360: AND HCAS.cust_acct_site_id = HCSU.cust_acct_site_id;
9361: l_default_info_rec.current_party_site_id := l_party_site_id;
9362: EXCEPTION
9363: WHEN no_data_found THEN
9364: fnd_message.set_name('CSI','CSI_TXN_SITE_USE_INVALID');
9365: fnd_message.set_token('SITE_USE_ID',l_current_site_use_id);
9366: fnd_message.set_token('SITE_USE_CODE','SITE_USE_ID');
9367: fnd_msg_pub.add;
9368: RAISE fnd_api.g_exc_error;

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

9361: l_default_info_rec.current_party_site_id := l_party_site_id;
9362: EXCEPTION
9363: WHEN no_data_found THEN
9364: fnd_message.set_name('CSI','CSI_TXN_SITE_USE_INVALID');
9365: fnd_message.set_token('SITE_USE_ID',l_current_site_use_id);
9366: fnd_message.set_token('SITE_USE_CODE','SITE_USE_ID');
9367: fnd_msg_pub.add;
9368: RAISE fnd_api.g_exc_error;
9369: END;

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

9362: EXCEPTION
9363: WHEN no_data_found THEN
9364: fnd_message.set_name('CSI','CSI_TXN_SITE_USE_INVALID');
9365: fnd_message.set_token('SITE_USE_ID',l_current_site_use_id);
9366: fnd_message.set_token('SITE_USE_CODE','SITE_USE_ID');
9367: fnd_msg_pub.add;
9368: RAISE fnd_api.g_exc_error;
9369: END;
9370: END IF;

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

9379: AND HCAS.cust_acct_site_id = HCSU.cust_acct_site_id;
9380: l_default_info_rec.install_party_site_id := l_party_site_id;
9381: EXCEPTION
9382: WHEN no_data_found THEN
9383: fnd_message.set_name('CSI','CSI_TXN_SITE_USE_INVALID');
9384: fnd_message.set_token('SITE_USE_ID',l_install_site_use_id);
9385: fnd_message.set_token('SITE_USE_CODE','SITE_USE_ID');
9386: fnd_msg_pub.add;
9387: RAISE fnd_api.g_exc_error;

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

9380: l_default_info_rec.install_party_site_id := l_party_site_id;
9381: EXCEPTION
9382: WHEN no_data_found THEN
9383: fnd_message.set_name('CSI','CSI_TXN_SITE_USE_INVALID');
9384: fnd_message.set_token('SITE_USE_ID',l_install_site_use_id);
9385: fnd_message.set_token('SITE_USE_CODE','SITE_USE_ID');
9386: fnd_msg_pub.add;
9387: RAISE fnd_api.g_exc_error;
9388: END;

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

9381: EXCEPTION
9382: WHEN no_data_found THEN
9383: fnd_message.set_name('CSI','CSI_TXN_SITE_USE_INVALID');
9384: fnd_message.set_token('SITE_USE_ID',l_install_site_use_id);
9385: fnd_message.set_token('SITE_USE_CODE','SITE_USE_ID');
9386: fnd_msg_pub.add;
9387: RAISE fnd_api.g_exc_error;
9388: END;
9389: END IF;

Line 9496: fnd_message.set_name('CSI','CSI_PENDING_SHIPMENT_LINES');

9492: -- Shipment line part of the order is not interfaced either line is
9493: -- in csi_txn_error or ship confirm didnt happen. In both cases
9494: -- block fulfilment processing
9495: debug('Shipment Line Not Interfaced to IB. Blocking Fulfillment till Shipment successfully completes');
9496: fnd_message.set_name('CSI','CSI_PENDING_SHIPMENT_LINES');
9497: fnd_msg_pub.add;
9498: RAISE fnd_api.g_exc_error;
9499: ELSE
9500: -- Shipment line interfaced so proceed with fulfilment line processing

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

10115: l_default_info_rec.transaction_line_id := l_transaction_line_id;
10116:
10117: IF l_processing_status = 'PROCESSED' THEN
10118: debug('This transaction detail is already PROCESSED.');
10119: fnd_message.set_name('CSI', 'CSI_TXN_SRC_ALREADY_PROCESSED');
10120: fnd_message.set_token('SRC_TBL', l_src_txn_table);
10121: fnd_message.set_token('SRC_ID', p_order_line_id);
10122: fnd_msg_pub.add;
10123: RAISE fnd_api.g_exc_error;

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

10116:
10117: IF l_processing_status = 'PROCESSED' THEN
10118: debug('This transaction detail is already PROCESSED.');
10119: fnd_message.set_name('CSI', 'CSI_TXN_SRC_ALREADY_PROCESSED');
10120: fnd_message.set_token('SRC_TBL', l_src_txn_table);
10121: fnd_message.set_token('SRC_ID', p_order_line_id);
10122: fnd_msg_pub.add;
10123: RAISE fnd_api.g_exc_error;
10124: END IF;

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

10117: IF l_processing_status = 'PROCESSED' THEN
10118: debug('This transaction detail is already PROCESSED.');
10119: fnd_message.set_name('CSI', 'CSI_TXN_SRC_ALREADY_PROCESSED');
10120: fnd_message.set_token('SRC_TBL', l_src_txn_table);
10121: fnd_message.set_token('SRC_ID', p_order_line_id);
10122: fnd_msg_pub.add;
10123: RAISE fnd_api.g_exc_error;
10124: END IF;
10125:

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

10428: p_error_message => l_error_message );
10429:
10430: WHEN others THEN
10431: rollback to order_fulfillment;
10432: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
10433: fnd_message.set_token('MESSAGE',substr(sqlerrm,1,540));
10434: fnd_msg_pub.add;
10435:
10436: x_return_status := fnd_api.g_ret_sts_error;

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

10429:
10430: WHEN others THEN
10431: rollback to order_fulfillment;
10432: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
10433: fnd_message.set_token('MESSAGE',substr(sqlerrm,1,540));
10434: fnd_msg_pub.add;
10435:
10436: x_return_status := fnd_api.g_ret_sts_error;
10437: l_error_message := csi_t_gen_utility_pvt.dump_error_stack;

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

10594: debug('DUP_VAL_ON_INDEX detected while creating Transaction Detail-Hdr.');
10595: l_continue := FALSE;
10596: WHEN others THEN
10597:
10598: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
10599: fnd_message.set_token('MESSAGE','insert_row failed '||sqlerrm);
10600: fnd_msg_pub.add;
10601: raise fnd_api.g_exc_error;
10602: END;

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

10595: l_continue := FALSE;
10596: WHEN others THEN
10597:
10598: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
10599: fnd_message.set_token('MESSAGE','insert_row failed '||sqlerrm);
10600: fnd_msg_pub.add;
10601: raise fnd_api.g_exc_error;
10602: END;
10603: END ;

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

10619: WHERE c.cust_acct_site_id = u.cust_acct_site_id
10620: AND u.site_use_id = x_order_shipment_tbl(i).ib_current_loc_id;
10621: EXCEPTION
10622: WHEN no_data_found THEN
10623: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');
10624: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_current_loc_id);
10625: fnd_msg_pub.add;
10626: raise fnd_api.g_exc_error;
10627: WHEN too_many_rows THEN

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

10620: AND u.site_use_id = x_order_shipment_tbl(i).ib_current_loc_id;
10621: EXCEPTION
10622: WHEN no_data_found THEN
10623: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');
10624: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_current_loc_id);
10625: fnd_msg_pub.add;
10626: raise fnd_api.g_exc_error;
10627: WHEN too_many_rows THEN
10628: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');

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

10624: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_current_loc_id);
10625: fnd_msg_pub.add;
10626: raise fnd_api.g_exc_error;
10627: WHEN too_many_rows THEN
10628: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');
10629: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_current_loc_id);
10630: fnd_msg_pub.add;
10631: raise fnd_api.g_exc_error;
10632: END;

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

10625: fnd_msg_pub.add;
10626: raise fnd_api.g_exc_error;
10627: WHEN too_many_rows THEN
10628: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');
10629: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_current_loc_id);
10630: fnd_msg_pub.add;
10631: raise fnd_api.g_exc_error;
10632: END;
10633:

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

10645: WHERE c.cust_acct_site_id = u.cust_acct_site_id
10646: AND u.site_use_id = x_order_shipment_tbl(i).ib_install_loc_id;
10647: EXCEPTION
10648: WHEN no_data_found THEN
10649: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');
10650: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_install_loc_id);
10651: fnd_msg_pub.add;
10652: raise fnd_api.g_exc_error;
10653: WHEN too_many_rows THEN

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

10646: AND u.site_use_id = x_order_shipment_tbl(i).ib_install_loc_id;
10647: EXCEPTION
10648: WHEN no_data_found THEN
10649: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');
10650: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_install_loc_id);
10651: fnd_msg_pub.add;
10652: raise fnd_api.g_exc_error;
10653: WHEN too_many_rows THEN
10654: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');

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

10650: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_install_loc_id);
10651: fnd_msg_pub.add;
10652: raise fnd_api.g_exc_error;
10653: WHEN too_many_rows THEN
10654: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');
10655: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_install_loc_id);
10656: fnd_msg_pub.add;
10657: raise fnd_api.g_exc_error;
10658: END;

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

10651: fnd_msg_pub.add;
10652: raise fnd_api.g_exc_error;
10653: WHEN too_many_rows THEN
10654: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');
10655: fnd_message.set_token('LOCATION_ID', x_order_shipment_tbl(i).ib_install_loc_id);
10656: fnd_msg_pub.add;
10657: raise fnd_api.g_exc_error;
10658: END;
10659: END IF;

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

11115:
11116: IF l_partner_rec.IB_OWNER = 'END_CUSTOMER'
11117: THEN
11118: IF l_partner_rec.END_CUSTOMER_ID is null Then
11119: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
11120: fnd_msg_pub.add;
11121: raise fnd_api.g_exc_error;
11122: ELSE
11123: mmt_rec.ib_owner := l_partner_rec.ib_owner;

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

11137: IF mmt_rec.ib_install_loc = 'END_CUSTOMER'
11138: THEN
11139: IF l_partner_rec.end_customer_site_use_id is null
11140: THEN
11141: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
11142: fnd_msg_pub.add;
11143: raise fnd_api.g_exc_error;
11144: ELSE
11145: mmt_rec.ib_install_loc_id := l_partner_rec.end_customer_site_use_id;

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

11147: ELSIF mmt_rec.ib_install_loc = 'SHIP_TO'
11148: THEN
11149: IF mmt_rec.ship_to_org_id is null
11150: THEN
11151: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
11152: fnd_msg_pub.add;
11153: raise fnd_api.g_exc_error;
11154: ELSE
11155: mmt_rec.ib_install_loc_id := mmt_rec.ship_to_org_id;

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

11157: ELSIF mmt_rec.ib_install_loc = 'SOLD_TO'
11158: THEN
11159: IF l_partner_rec.SOLD_TO_SITE_USE_ID is null -- 3412544 mmt_rec.sold_to_org_id is null
11160: THEN
11161: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
11162: fnd_msg_pub.add;
11163: raise fnd_api.g_exc_error;
11164: ELSE
11165: mmt_rec.ib_install_loc_id := l_partner_rec.SOLD_TO_SITE_USE_ID; -- 3412544 mmt_rec.sold_to_org_id;

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

11167: ELSIF mmt_rec.ib_install_loc = 'DELIVER_TO'
11168: THEN
11169: IF mmt_rec.deliver_to_org_id is null
11170: THEN
11171: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
11172: fnd_msg_pub.add;
11173: raise fnd_api.g_exc_error;
11174: ELSE
11175: mmt_rec.ib_install_loc_id := mmt_rec.deliver_to_org_id;

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

11177: ELSIF mmt_rec.ib_install_loc = 'BILL_TO'
11178: THEN
11179: IF mmt_rec.invoice_to_org_id is null
11180: THEN
11181: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
11182: fnd_msg_pub.add;
11183: raise fnd_api.g_exc_error;
11184: ELSE
11185: mmt_rec.ib_install_loc_id := mmt_rec.invoice_to_org_id;

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

11198: IF mmt_rec.ib_current_loc = 'END_CUSTOMER'
11199: THEN
11200: IF l_partner_rec.end_customer_site_use_id is null
11201: THEN
11202: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
11203: fnd_msg_pub.add;
11204: raise fnd_api.g_exc_error;
11205: ELSE
11206: mmt_rec.ib_current_loc_id := l_partner_rec.end_customer_site_use_id;

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

11208: ELSIF mmt_rec.ib_current_loc = 'SHIP_TO'
11209: THEN
11210: IF mmt_rec.ship_to_org_id is null
11211: THEN
11212: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
11213: fnd_msg_pub.add;
11214: raise fnd_api.g_exc_error;
11215: ELSE
11216: mmt_rec.ib_current_loc_id := mmt_rec.ship_to_org_id;

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

11218: ELSIF mmt_rec.ib_current_loc = 'SOLD_TO'
11219: THEN
11220: IF l_partner_rec.SOLD_TO_SITE_USE_ID is null -- 3412544 mmt_rec.sold_to_org_id is null
11221: THEN
11222: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
11223: fnd_msg_pub.add;
11224: raise fnd_api.g_exc_error;
11225: ELSE
11226: mmt_rec.ib_current_loc_id := l_partner_rec.SOLD_TO_SITE_USE_ID; -- 3412544 mmt_rec.sold_to_org_id;

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

11228: ELSIF mmt_rec.ib_current_loc = 'DELIVER_TO'
11229: THEN
11230: IF mmt_rec.deliver_to_org_id is null
11231: THEN
11232: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
11233: fnd_msg_pub.add;
11234: raise fnd_api.g_exc_error;
11235: ELSE
11236: mmt_rec.ib_current_loc_id := mmt_rec.deliver_to_org_id;

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

11238: ELSIF mmt_rec.ib_current_loc = 'BILL_TO'
11239: THEN
11240: IF mmt_rec.invoice_to_org_id is null
11241: THEN
11242: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
11243: fnd_msg_pub.add;
11244: raise fnd_api.g_exc_error;
11245: ELSE
11246: mmt_rec.ib_current_loc_id := mmt_rec.invoice_to_org_id;

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

11479: debug('Error(E) :'||l_error_message);
11480: px_trx_error_rec := l_error_rec;
11481:
11482: WHEN others THEN
11483: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
11484: fnd_message.set_token('MESSAGE',substr(sqlerrm,1,540));
11485: fnd_msg_pub.add;
11486:
11487: x_return_status := fnd_api.g_ret_sts_error;

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

11480: px_trx_error_rec := l_error_rec;
11481:
11482: WHEN others THEN
11483: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
11484: fnd_message.set_token('MESSAGE',substr(sqlerrm,1,540));
11485: fnd_msg_pub.add;
11486:
11487: x_return_status := fnd_api.g_ret_sts_error;
11488: l_error_rec.source_id := p_mtl_txn_id; -- For 4168922