275: END;
276:
277: EXCEPTION
278: WHEN no_data_found THEN
279: fnd_message.set_name('CSI','CSI_NO_INVENTORY_RECORDS');
280: fnd_message.set_token('MTL_TRANSACTION_ID',p_transaction_id);
281: fnd_msg_pub.add;
282: RAISE fnd_api.g_exc_error;
283: END;
276:
277: EXCEPTION
278: WHEN no_data_found THEN
279: fnd_message.set_name('CSI','CSI_NO_INVENTORY_RECORDS');
280: fnd_message.set_token('MTL_TRANSACTION_ID',p_transaction_id);
281: fnd_msg_pub.add;
282: RAISE fnd_api.g_exc_error;
283: END;
284:
394:
395: debug(' mmt_tbl.count : '||l_mmt_tbl.count);
396:
397: IF l_mmt_tbl.COUNT = 0 THEN
398: fnd_message.set_name('CSI','CSI_NO_INVENTORY_RECORDS');
399: fnd_message.set_token('MTL_TRANSACTION_ID',p_transaction_id);
400: fnd_msg_pub.add;
401: RAISE fnd_api.g_exc_error;
402: END IF;
395: debug(' mmt_tbl.count : '||l_mmt_tbl.count);
396:
397: IF l_mmt_tbl.COUNT = 0 THEN
398: fnd_message.set_name('CSI','CSI_NO_INVENTORY_RECORDS');
399: fnd_message.set_token('MTL_TRANSACTION_ID',p_transaction_id);
400: fnd_msg_pub.add;
401: RAISE fnd_api.g_exc_error;
402: END IF;
403:
2281: WHERE inventory_item_id = p_child_item_id
2282: and serial_number = p_child_serial_number;
2283: EXCEPTION
2284: WHEN NO_DATA_FOUND THEN
2285: fnd_message.set_name('CSI','CSI_PARENT_SRL_NOT_FOUND');
2286: fnd_message.set_token('INVENTORY_ITEM_ID',p_child_item_id);
2287: fnd_message.set_token('CHILD_SERIAL_NUM',p_child_serial_number);
2288: fnd_msg_pub.add;
2289: RAISE fnd_api.g_exc_error;
2282: and serial_number = p_child_serial_number;
2283: EXCEPTION
2284: WHEN NO_DATA_FOUND THEN
2285: fnd_message.set_name('CSI','CSI_PARENT_SRL_NOT_FOUND');
2286: fnd_message.set_token('INVENTORY_ITEM_ID',p_child_item_id);
2287: fnd_message.set_token('CHILD_SERIAL_NUM',p_child_serial_number);
2288: fnd_msg_pub.add;
2289: RAISE fnd_api.g_exc_error;
2290: END;
2283: EXCEPTION
2284: WHEN NO_DATA_FOUND THEN
2285: fnd_message.set_name('CSI','CSI_PARENT_SRL_NOT_FOUND');
2286: fnd_message.set_token('INVENTORY_ITEM_ID',p_child_item_id);
2287: fnd_message.set_token('CHILD_SERIAL_NUM',p_child_serial_number);
2288: fnd_msg_pub.add;
2289: RAISE fnd_api.g_exc_error;
2290: END;
2291: -- Bug#15980871
3908: END IF;
3909:
3910: IF NOT( l_processed_flag ) THEN
3911:
3912: fnd_message.set_name('CSI', 'CSI_WIP_PRIOR_TXN_FAILED');
3913: fnd_message.set_token('WIP_ENTITY_ID', p_wip_entity_id);
3914: fnd_message.set_token('MTL_TXN_ID', mtl_txn_rec.transaction_id);
3915:
3916: fnd_msg_pub.add;
3909:
3910: IF NOT( l_processed_flag ) THEN
3911:
3912: fnd_message.set_name('CSI', 'CSI_WIP_PRIOR_TXN_FAILED');
3913: fnd_message.set_token('WIP_ENTITY_ID', p_wip_entity_id);
3914: fnd_message.set_token('MTL_TXN_ID', mtl_txn_rec.transaction_id);
3915:
3916: fnd_msg_pub.add;
3917: RAISE fnd_api.g_exc_error;
3910: IF NOT( l_processed_flag ) THEN
3911:
3912: fnd_message.set_name('CSI', 'CSI_WIP_PRIOR_TXN_FAILED');
3913: fnd_message.set_token('WIP_ENTITY_ID', p_wip_entity_id);
3914: fnd_message.set_token('MTL_TXN_ID', mtl_txn_rec.transaction_id);
3915:
3916: fnd_msg_pub.add;
3917: RAISE fnd_api.g_exc_error;
3918: END IF;
4641: debug('Error(E) :'||l_error_rec.error_text);
4642:
4643: WHEN others then
4644: rollback to wip_comp_issue;
4645: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
4646: fnd_message.set_token('API_NAME',g_api_name);
4647: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 540));
4648: fnd_msg_pub.add;
4649:
4642:
4643: WHEN others then
4644: rollback to wip_comp_issue;
4645: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
4646: fnd_message.set_token('API_NAME',g_api_name);
4647: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 540));
4648: fnd_msg_pub.add;
4649:
4650: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
4643: WHEN others then
4644: rollback to wip_comp_issue;
4645: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
4646: fnd_message.set_token('API_NAME',g_api_name);
4647: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 540));
4648: fnd_msg_pub.add;
4649:
4650: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
4651: px_trx_error_rec := l_error_rec;
4731: debug('Error(E) :'||l_error_rec.error_text);
4732:
4733: WHEN others then
4734: rollback to wip_assy_return;
4735: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
4736: fnd_message.set_token('API_NAME',g_api_name);
4737: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 540));
4738: fnd_msg_pub.add;
4739:
4732:
4733: WHEN others then
4734: rollback to wip_assy_return;
4735: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
4736: fnd_message.set_token('API_NAME',g_api_name);
4737: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 540));
4738: fnd_msg_pub.add;
4739:
4740: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
4733: WHEN others then
4734: rollback to wip_assy_return;
4735: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
4736: fnd_message.set_token('API_NAME',g_api_name);
4737: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 540));
4738: fnd_msg_pub.add;
4739:
4740: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
4741: px_trx_error_rec := l_error_rec;
4824: debug('Error(E) :'||l_error_rec.error_text);
4825:
4826: WHEN others then
4827: rollback to wip_byproduct_return;
4828: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
4829: fnd_message.set_token('API_NAME',g_api_name);
4830: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 540));
4831: fnd_msg_pub.add;
4832:
4825:
4826: WHEN others then
4827: rollback to wip_byproduct_return;
4828: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
4829: fnd_message.set_token('API_NAME',g_api_name);
4830: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 540));
4831: fnd_msg_pub.add;
4832:
4833: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
4826: WHEN others then
4827: rollback to wip_byproduct_return;
4828: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
4829: fnd_message.set_token('API_NAME',g_api_name);
4830: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 540));
4831: fnd_msg_pub.add;
4832:
4833: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
4834: px_trx_error_rec := l_error_rec;
4915: debug('Error(E) :'||l_error_rec.error_text);
4916:
4917: WHEN others then
4918: rollback to wip_neg_comp_return;
4919: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
4920: fnd_message.set_token('API_NAME',g_api_name);
4921: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 540));
4922: fnd_msg_pub.add;
4923:
4916:
4917: WHEN others then
4918: rollback to wip_neg_comp_return;
4919: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
4920: fnd_message.set_token('API_NAME',g_api_name);
4921: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 540));
4922: fnd_msg_pub.add;
4923:
4924: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
4917: WHEN others then
4918: rollback to wip_neg_comp_return;
4919: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
4920: fnd_message.set_token('API_NAME',g_api_name);
4921: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 540));
4922: fnd_msg_pub.add;
4923:
4924: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
4925: px_trx_error_rec := l_error_rec;
5655: IF NVL(l_active_end_date, sysdate + 1) <= sysdate THEN
5656: l_relation_found := 'N';
5657: debug('l_relation_found after ignoring equal sysdate and l_active_end_date ' || l_relation_found);
5658: ELSE
5659: fnd_message.set_name('CSI', 'CSI_MAINT_JOB_RTN_DISALLOWED');
5660: fnd_message.set_token('PARENT_INSTANCE_ID', l_parent_instance_id);
5661: fnd_msg_pub.add;
5662: RAISE fnd_api.g_exc_error;
5663: END IF;-- NVL(l_active_end_date, sysdate + 1) = sysdate
5656: l_relation_found := 'N';
5657: debug('l_relation_found after ignoring equal sysdate and l_active_end_date ' || l_relation_found);
5658: ELSE
5659: fnd_message.set_name('CSI', 'CSI_MAINT_JOB_RTN_DISALLOWED');
5660: fnd_message.set_token('PARENT_INSTANCE_ID', l_parent_instance_id);
5661: fnd_msg_pub.add;
5662: RAISE fnd_api.g_exc_error;
5663: END IF;-- NVL(l_active_end_date, sysdate + 1) = sysdate
5664: END IF;
5939:
5940: WHEN others then
5941: rollback to wip_component_receipt;
5942:
5943: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
5944: fnd_message.set_token('API_NAME',g_api_name);
5945: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 255));
5946: fnd_msg_pub.add;
5947:
5940: WHEN others then
5941: rollback to wip_component_receipt;
5942:
5943: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
5944: fnd_message.set_token('API_NAME',g_api_name);
5945: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 255));
5946: fnd_msg_pub.add;
5947:
5948: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
5941: rollback to wip_component_receipt;
5942:
5943: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
5944: fnd_message.set_token('API_NAME',g_api_name);
5945: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 255));
5946: fnd_msg_pub.add;
5947:
5948: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
5949: px_trx_error_rec := l_error_rec;
6328:
6329: WHEN others then
6330: rollback to wip_byproduct_completion;
6331:
6332: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
6333: fnd_message.set_token('API_NAME',g_api_name);
6334: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 255));
6335: fnd_msg_pub.add;
6336:
6329: WHEN others then
6330: rollback to wip_byproduct_completion;
6331:
6332: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
6333: fnd_message.set_token('API_NAME',g_api_name);
6334: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 255));
6335: fnd_msg_pub.add;
6336:
6337: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
6330: rollback to wip_byproduct_completion;
6331:
6332: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
6333: fnd_message.set_token('API_NAME',g_api_name);
6334: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 255));
6335: fnd_msg_pub.add;
6336:
6337: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
6338: px_trx_error_rec := l_error_rec;
6558:
6559: WHEN others then
6560: rollback to wip_assy_completion;
6561:
6562: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
6563: fnd_message.set_token('API_NAME',g_api_name);
6564: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 255));
6565: fnd_msg_pub.add;
6566:
6559: WHEN others then
6560: rollback to wip_assy_completion;
6561:
6562: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
6563: fnd_message.set_token('API_NAME',g_api_name);
6564: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 255));
6565: fnd_msg_pub.add;
6566:
6567: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
6560: rollback to wip_assy_completion;
6561:
6562: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
6563: fnd_message.set_token('API_NAME',g_api_name);
6564: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 255));
6565: fnd_msg_pub.add;
6566:
6567: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
6568: px_trx_error_rec := l_error_rec;
7020: END IF;
7021:
7022: IF NOT( l_processed_flag ) THEN
7023:
7024: fnd_message.set_name('CSI', 'CSI_WIP_PRIOR_TXN_FAILED');
7025: fnd_message.set_token('WIP_ENTITY_ID', p_wip_entity_id);
7026: fnd_message.set_token('MTL_TXN_ID', mtl_txn_rec.transaction_id);
7027:
7028: fnd_msg_pub.add;
7021:
7022: IF NOT( l_processed_flag ) THEN
7023:
7024: fnd_message.set_name('CSI', 'CSI_WIP_PRIOR_TXN_FAILED');
7025: fnd_message.set_token('WIP_ENTITY_ID', p_wip_entity_id);
7026: fnd_message.set_token('MTL_TXN_ID', mtl_txn_rec.transaction_id);
7027:
7028: fnd_msg_pub.add;
7029: RAISE fnd_api.g_exc_error;
7022: IF NOT( l_processed_flag ) THEN
7023:
7024: fnd_message.set_name('CSI', 'CSI_WIP_PRIOR_TXN_FAILED');
7025: fnd_message.set_token('WIP_ENTITY_ID', p_wip_entity_id);
7026: fnd_message.set_token('MTL_TXN_ID', mtl_txn_rec.transaction_id);
7027:
7028: fnd_msg_pub.add;
7029: RAISE fnd_api.g_exc_error;
7030: END IF;