DBA Data[Home] [Help]

APPS.CSI_WIP_TRXS_PKG dependencies on FND_MSG_PUB

Line 279: fnd_msg_pub.add;

275: EXCEPTION
276: WHEN no_data_found THEN
277: fnd_message.set_name('CSI','CSI_NO_INVENTORY_RECORDS');
278: fnd_message.set_token('MTL_TRANSACTION_ID',p_transaction_id);
279: fnd_msg_pub.add;
280: RAISE fnd_api.g_exc_error;
281: END;
282:
283: debug(' item : '||l_txn_ref.item);

Line 386: fnd_msg_pub.add;

382:
383: IF l_mmt_tbl.COUNT = 0 THEN
384: fnd_message.set_name('CSI','CSI_NO_INVENTORY_RECORDS');
385: fnd_message.set_token('MTL_TRANSACTION_ID',p_transaction_id);
386: fnd_msg_pub.add;
387: RAISE fnd_api.g_exc_error;
388: END IF;
389:
390: dump_mmt_tbl(l_mmt_tbl);

Line 3781: fnd_msg_pub.add;

3777: fnd_message.set_name('CSI', 'CSI_WIP_PRIOR_TXN_FAILED');
3778: fnd_message.set_token('WIP_ENTITY_ID', p_wip_entity_id);
3779: fnd_message.set_token('MTL_TXN_ID', mtl_txn_rec.transaction_id);
3780:
3781: fnd_msg_pub.add;
3782: RAISE fnd_api.g_exc_error;
3783: END IF;
3784:
3785: END LOOP;

Line 4460: fnd_msg_pub.initialize;

4456: csi_utility_grp.check_ib_active;
4457:
4458: savepoint wip_comp_issue;
4459:
4460: fnd_msg_pub.initialize;
4461:
4462: --
4463: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
4464: csi_gen_utility_pvt.populate_install_param_rec;

Line 4513: fnd_msg_pub.add;

4509: rollback to wip_comp_issue;
4510: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
4511: fnd_message.set_token('API_NAME',g_api_name);
4512: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 540));
4513: fnd_msg_pub.add;
4514:
4515: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
4516: px_trx_error_rec := l_error_rec;
4517: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4550: fnd_msg_pub.initialize;

4546: csi_utility_grp.check_ib_active;
4547:
4548: savepoint wip_assy_return;
4549:
4550: fnd_msg_pub.initialize;
4551:
4552: --
4553: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
4554: csi_gen_utility_pvt.populate_install_param_rec;

Line 4603: fnd_msg_pub.add;

4599: rollback to wip_assy_return;
4600: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
4601: fnd_message.set_token('API_NAME',g_api_name);
4602: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 540));
4603: fnd_msg_pub.add;
4604:
4605: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
4606: px_trx_error_rec := l_error_rec;
4607: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4643: fnd_msg_pub.initialize;

4639: csi_utility_grp.check_ib_active;
4640:
4641: savepoint wip_byproduct_return;
4642:
4643: fnd_msg_pub.initialize;
4644:
4645: --
4646: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
4647: csi_gen_utility_pvt.populate_install_param_rec;

Line 4696: fnd_msg_pub.add;

4692: rollback to wip_byproduct_return;
4693: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
4694: fnd_message.set_token('API_NAME',g_api_name);
4695: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 540));
4696: fnd_msg_pub.add;
4697:
4698: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
4699: px_trx_error_rec := l_error_rec;
4700: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4734: fnd_msg_pub.initialize;

4730: csi_utility_grp.check_ib_active;
4731:
4732: savepoint wip_neg_comp_return;
4733:
4734: fnd_msg_pub.initialize;
4735:
4736: --
4737: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
4738: csi_gen_utility_pvt.populate_install_param_rec;

Line 4787: fnd_msg_pub.add;

4783: rollback to wip_neg_comp_return;
4784: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
4785: fnd_message.set_token('API_NAME',g_api_name);
4786: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 540));
4787: fnd_msg_pub.add;
4788:
4789: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
4790: px_trx_error_rec := l_error_rec;
4791: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 5472: fnd_msg_pub.add;

5468: END;
5469: IF l_relation_found = 'Y' THEN
5470: fnd_message.set_name('CSI', 'CSI_MAINT_JOB_RTN_DISALLOWED');
5471: fnd_message.set_token('PARENT_INSTANCE_ID', l_parent_instance_id);
5472: fnd_msg_pub.add;
5473: RAISE fnd_api.g_exc_error;
5474: END IF;
5475: END IF;
5476:

Line 5613: fnd_msg_pub.initialize;

5609: savepoint wip_component_receipt;
5610:
5611: x_return_status := fnd_api.g_ret_sts_success;
5612:
5613: fnd_msg_pub.initialize;
5614:
5615:
5616: csi_t_gen_utility_pvt.build_file_name(
5617: p_file_segment1 => 'csiwipcr',

Line 5740: fnd_msg_pub.add;

5736:
5737: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
5738: fnd_message.set_token('API_NAME',g_api_name);
5739: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 255));
5740: fnd_msg_pub.add;
5741:
5742: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
5743: px_trx_error_rec := l_error_rec;
5744: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 5960: fnd_msg_pub.initialize;

5956: savepoint wip_byproduct_completion;
5957:
5958: x_return_status := fnd_api.g_ret_sts_success;
5959:
5960: fnd_msg_pub.initialize;
5961:
5962: csi_t_gen_utility_pvt.build_file_name(
5963: p_file_segment1 => 'csiwipbc',
5964: p_file_segment2 => p_transaction_id);

Line 6129: fnd_msg_pub.add;

6125:
6126: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
6127: fnd_message.set_token('API_NAME',g_api_name);
6128: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 255));
6129: fnd_msg_pub.add;
6130:
6131: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
6132: px_trx_error_rec := l_error_rec;
6133: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 6190: fnd_msg_pub.initialize;

6186: savepoint wip_assy_completion;
6187:
6188: x_return_status := fnd_api.g_ret_sts_success;
6189:
6190: fnd_msg_pub.initialize;
6191:
6192: csi_t_gen_utility_pvt.build_file_name(
6193: p_file_segment1 => 'csiwipac',
6194: p_file_segment2 => p_transaction_id);

Line 6359: fnd_msg_pub.add;

6355:
6356: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
6357: fnd_message.set_token('API_NAME',g_api_name);
6358: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 255));
6359: fnd_msg_pub.add;
6360:
6361: l_error_rec.error_text := csi_t_gen_utility_pvt.dump_error_stack;
6362: px_trx_error_rec := l_error_rec;
6363: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 6822: fnd_msg_pub.add;

6818: fnd_message.set_name('CSI', 'CSI_WIP_PRIOR_TXN_FAILED');
6819: fnd_message.set_token('WIP_ENTITY_ID', p_wip_entity_id);
6820: fnd_message.set_token('MTL_TXN_ID', mtl_txn_rec.transaction_id);
6821:
6822: fnd_msg_pub.add;
6823: RAISE fnd_api.g_exc_error;
6824: END IF;
6825:
6826: END LOOP;