DBA Data[Home] [Help]

APPS.CSI_WIP_TRXS_PKG dependencies on FND_MESSAGE

Line 277: fnd_message.set_name('CSI','CSI_NO_INVENTORY_RECORDS');

273: END;
274:
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;

Line 278: fnd_message.set_token('MTL_TRANSACTION_ID',p_transaction_id);

274:
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:

Line 384: fnd_message.set_name('CSI','CSI_NO_INVENTORY_RECORDS');

380:
381: debug(' mmt_tbl.count : '||l_mmt_tbl.count);
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;

Line 385: fnd_message.set_token('MTL_TRANSACTION_ID',p_transaction_id);

381: debug(' mmt_tbl.count : '||l_mmt_tbl.count);
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:

Line 3777: fnd_message.set_name('CSI', 'CSI_WIP_PRIOR_TXN_FAILED');

3773: END IF;
3774:
3775: IF NOT( l_processed_flag ) THEN
3776:
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;

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

3774:
3775: IF NOT( l_processed_flag ) THEN
3776:
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;

Line 3779: fnd_message.set_token('MTL_TXN_ID', mtl_txn_rec.transaction_id);

3775: IF NOT( l_processed_flag ) THEN
3776:
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;

Line 4510: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');

4506: debug('Error(E) :'||l_error_rec.error_text);
4507:
4508: WHEN others then
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:

Line 4511: fnd_message.set_token('API_NAME',g_api_name);

4507:
4508: WHEN others then
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;

Line 4512: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 540));

4508: WHEN others then
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;

Line 4600: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');

4596: debug('Error(E) :'||l_error_rec.error_text);
4597:
4598: WHEN others then
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:

Line 4601: fnd_message.set_token('API_NAME',g_api_name);

4597:
4598: WHEN others then
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;

Line 4602: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 540));

4598: WHEN others then
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;

Line 4693: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');

4689: debug('Error(E) :'||l_error_rec.error_text);
4690:
4691: WHEN others then
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:

Line 4694: fnd_message.set_token('API_NAME',g_api_name);

4690:
4691: WHEN others then
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;

Line 4695: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 540));

4691: WHEN others then
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;

Line 4784: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');

4780: debug('Error(E) :'||l_error_rec.error_text);
4781:
4782: WHEN others then
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:

Line 4785: fnd_message.set_token('API_NAME',g_api_name);

4781:
4782: WHEN others then
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;

Line 4786: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 540));

4782: WHEN others then
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;

Line 5470: fnd_message.set_name('CSI', 'CSI_MAINT_JOB_RTN_DISALLOWED');

5466: WHEN no_data_found THEN
5467: l_relation_found := 'N';
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;

Line 5471: fnd_message.set_token('PARENT_INSTANCE_ID', l_parent_instance_id);

5467: l_relation_found := 'N';
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;

Line 5737: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');

5733:
5734: WHEN others then
5735: rollback to wip_component_receipt;
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:

Line 5738: fnd_message.set_token('API_NAME',g_api_name);

5734: WHEN others then
5735: rollback to wip_component_receipt;
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;

Line 5739: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 255));

5735: rollback to wip_component_receipt;
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;

Line 6126: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');

6122:
6123: WHEN others then
6124: rollback to wip_byproduct_completion;
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:

Line 6127: fnd_message.set_token('API_NAME',g_api_name);

6123: WHEN others then
6124: rollback to wip_byproduct_completion;
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;

Line 6128: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 255));

6124: rollback to wip_byproduct_completion;
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;

Line 6356: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');

6352:
6353: WHEN others then
6354: rollback to wip_assy_completion;
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:

Line 6357: fnd_message.set_token('API_NAME',g_api_name);

6353: WHEN others then
6354: rollback to wip_assy_completion;
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;

Line 6358: fnd_message.set_token('SQL_ERROR',substr(sqlerrm, 1, 255));

6354: rollback to wip_assy_completion;
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;

Line 6818: fnd_message.set_name('CSI', 'CSI_WIP_PRIOR_TXN_FAILED');

6814: END IF;
6815:
6816: IF NOT( l_processed_flag ) THEN
6817:
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;

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

6815:
6816: IF NOT( l_processed_flag ) THEN
6817:
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;

Line 6820: fnd_message.set_token('MTL_TXN_ID', mtl_txn_rec.transaction_id);

6816: IF NOT( l_processed_flag ) THEN
6817:
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;