DBA Data[Home] [Help]

APPS.CSI_WIP_TRXS_PKG dependencies on FND_MESSAGE

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

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;

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

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:

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

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;

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

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:

Line 2285: fnd_message.set_name('CSI','CSI_PARENT_SRL_NOT_FOUND');

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;

Line 2286: fnd_message.set_token('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;
2290: END;

Line 2287: fnd_message.set_token('CHILD_SERIAL_NUM',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;
2291: -- Bug#15980871

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

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;

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

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;

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

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;

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

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:

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

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;

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

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;

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

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:

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

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;

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

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;

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

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:

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

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;

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

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;

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

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:

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

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;

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

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;

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

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

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

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;

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

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:

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

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;

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

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;

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

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:

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

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;

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

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;

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

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:

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

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;

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

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;

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

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;

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

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;

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

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;