DBA Data[Home] [Help]

APPS.CSI_WIP_TRXS_PKG dependencies on FND_MSG_PUB

Line 281: fnd_msg_pub.add;

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:
285: debug(' item : '||l_txn_ref.item);

Line 400: fnd_msg_pub.add;

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:
404: dump_mmt_tbl(l_mmt_tbl);

Line 2288: fnd_msg_pub.add;

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
2292: IF l_parent_serial_number is not null THEN

Line 3916: fnd_msg_pub.add;

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;
3919:
3920: END LOOP;

Line 4595: fnd_msg_pub.initialize;

4591: csi_utility_grp.check_ib_active;
4592:
4593: savepoint wip_comp_issue;
4594:
4595: fnd_msg_pub.initialize;
4596:
4597: --
4598: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
4599: csi_gen_utility_pvt.populate_install_param_rec;

Line 4648: fnd_msg_pub.add;

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;
4652: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4685: fnd_msg_pub.initialize;

4681: csi_utility_grp.check_ib_active;
4682:
4683: savepoint wip_assy_return;
4684:
4685: fnd_msg_pub.initialize;
4686:
4687: --
4688: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
4689: csi_gen_utility_pvt.populate_install_param_rec;

Line 4738: fnd_msg_pub.add;

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;
4742: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4778: fnd_msg_pub.initialize;

4774: csi_utility_grp.check_ib_active;
4775:
4776: savepoint wip_byproduct_return;
4777:
4778: fnd_msg_pub.initialize;
4779:
4780: --
4781: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
4782: csi_gen_utility_pvt.populate_install_param_rec;

Line 4831: fnd_msg_pub.add;

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;
4835: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4869: fnd_msg_pub.initialize;

4865: csi_utility_grp.check_ib_active;
4866:
4867: savepoint wip_neg_comp_return;
4868:
4869: fnd_msg_pub.initialize;
4870:
4871: --
4872: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
4873: csi_gen_utility_pvt.populate_install_param_rec;

Line 4922: fnd_msg_pub.add;

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;
4926: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 5661: fnd_msg_pub.add;

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

Line 5819: fnd_msg_pub.initialize;

5815: savepoint wip_component_receipt;
5816:
5817: x_return_status := fnd_api.g_ret_sts_success;
5818:
5819: fnd_msg_pub.initialize;
5820:
5821:
5822: csi_t_gen_utility_pvt.build_file_name(
5823: p_file_segment1 => 'csiwipcr',

Line 5946: fnd_msg_pub.add;

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;
5950: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 6166: fnd_msg_pub.initialize;

6162: savepoint wip_byproduct_completion;
6163:
6164: x_return_status := fnd_api.g_ret_sts_success;
6165:
6166: fnd_msg_pub.initialize;
6167:
6168: csi_t_gen_utility_pvt.build_file_name(
6169: p_file_segment1 => 'csiwipbc',
6170: p_file_segment2 => p_transaction_id);

Line 6335: fnd_msg_pub.add;

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;
6339: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 6396: fnd_msg_pub.initialize;

6392: savepoint wip_assy_completion;
6393:
6394: x_return_status := fnd_api.g_ret_sts_success;
6395:
6396: fnd_msg_pub.initialize;
6397:
6398: csi_t_gen_utility_pvt.build_file_name(
6399: p_file_segment1 => 'csiwipac',
6400: p_file_segment2 => p_transaction_id);

Line 6565: fnd_msg_pub.add;

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;
6569: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 7028: fnd_msg_pub.add;

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;
7031:
7032: END LOOP;