eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMO_VBATCH_TASK_PVT dependencies on FND_MSG_PUB

Line 60: FND_MSG_PUB.ADD;

56: FND_MESSAGE.SET_TOKEN('CONSTANT_NAME','BOM:HOUR_UOM_CODE');
57: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
58: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_task_pvt.get_resource_txn_end_date', FALSE);
59: end if;
60: FND_MSG_PUB.ADD;
61: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
62:
63: WHEN uom_conversion_err THEN
64: x_return_status:= fnd_api.g_ret_sts_error;

Line 61: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);

57: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
58: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_task_pvt.get_resource_txn_end_date', FALSE);
59: end if;
60: FND_MSG_PUB.ADD;
61: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
62:
63: WHEN uom_conversion_err THEN
64: x_return_status:= fnd_api.g_ret_sts_error;
65: FND_MESSAGE.SET_NAME('GME','GME_RSRC_USG_NT_CNV_SYUOM');

Line 71: FND_MSG_PUB.ADD;

67: FND_MESSAGE.SET_TOKEN('RSRC_USG_UOM',p_trans_um);
68: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
69: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_task_pvt.get_resource_txn_end_date', FALSE);
70: end if;
71: FND_MSG_PUB.ADD;
72: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
73: WHEN OTHERS THEN
74: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
75: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

Line 72: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);

68: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
69: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_task_pvt.get_resource_txn_end_date', FALSE);
70: end if;
71: FND_MSG_PUB.ADD;
72: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
73: WHEN OTHERS THEN
74: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
75: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
76: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

Line 81: FND_MSG_PUB.ADD;

77: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
78: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
79: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.get_resource_txn_end_date', FALSE);
80: end if;
81: FND_MSG_PUB.ADD;
82: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
83: END get_resource_txn_end_date;
84:
85: procedure get_resource_txn_usage(

Line 82: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);

78: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
79: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.get_resource_txn_end_date', FALSE);
80: end if;
81: FND_MSG_PUB.ADD;
82: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
83: END get_resource_txn_end_date;
84:
85: procedure get_resource_txn_usage(
86: p_start_date IN DATE

Line 133: FND_MSG_PUB.ADD;

129: FND_MESSAGE.SET_TOKEN('CONSTANT_NAME','BOM:HOUR_UOM_CODE');
130: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
131: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_task_pvt.get_resource_txn_usage', FALSE);
132: end if;
133: FND_MSG_PUB.ADD;
134: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
135:
136: WHEN uom_conversion_err THEN
137: x_return_status:= fnd_api.g_ret_sts_error;

Line 134: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);

130: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
131: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_task_pvt.get_resource_txn_usage', FALSE);
132: end if;
133: FND_MSG_PUB.ADD;
134: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
135:
136: WHEN uom_conversion_err THEN
137: x_return_status:= fnd_api.g_ret_sts_error;
138: FND_MESSAGE.SET_NAME('GME','GME_RSRC_USG_NT_CNV_SYUOM');

Line 144: FND_MSG_PUB.ADD;

140: FND_MESSAGE.SET_TOKEN('RSRC_USG_UOM',p_trans_um);
141: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
142: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_task_pvt.get_resource_txn_usage', FALSE);
143: end if;
144: FND_MSG_PUB.ADD;
145: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
146: WHEN OTHERS THEN
147: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
148: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

Line 145: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);

141: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
142: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_task_pvt.get_resource_txn_usage', FALSE);
143: end if;
144: FND_MSG_PUB.ADD;
145: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
146: WHEN OTHERS THEN
147: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
148: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
149: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

Line 154: FND_MSG_PUB.ADD;

150: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
151: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
152: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.get_resource_txn_usage', FALSE);
153: end if;
154: FND_MSG_PUB.ADD;
155: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
156: END get_resource_txn_usage;
157:
158: procedure get_resource_transaction_arr

Line 155: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);

151: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
152: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.get_resource_txn_usage', FALSE);
153: end if;
154: FND_MSG_PUB.ADD;
155: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
156: END get_resource_txn_usage;
157:
158: procedure get_resource_transaction_arr
159: (

Line 379: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);

375: SET actual_rsrc_count = p_actual_resource_count
376: WHERE BATCHSTEP_RESOURCE_ID=l_resource_transaction_rec_in.LINE_ID;
377: get_resource_transaction_arr(l_resource_transaction_rec_out, x_resource_transaction_rec);
378: end if;
379: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
380: END create_resource_transaction;
381:
382: procedure update_resource_transaction (
383: p_resource_transaction_rec IN fnd_table_of_varchar2_255

Line 404: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);

400: x_return_status => x_return_status);
401: UPDATE GME_BATCH_STEP_RESOURCES
402: SET actual_rsrc_count = p_actual_resource_count
403: WHERE BATCHSTEP_RESOURCE_ID=l_resource_transaction_rec_in.LINE_ID;
404: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
405: END update_resource_transaction;
406:
407: procedure delete_resource_transaction (
408: p_resource_transaction_rec IN fnd_table_of_varchar2_255

Line 426: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);

422: gme_api_grp.delete_resource_txn (
423: p_rsrc_txn_gtmp_rec => l_resource_transaction_rec_in,
424: x_return_status => x_return_status);
425:
426: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
427: END delete_resource_transaction;
428:
429: procedure setup_resource_transaction(
430: p_org_id NUMBER,

Line 448: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);

444: x_return_status := 'E';
445: end if;
446: select * into l_batch_record from gme_batch_header where batch_id = p_batch_id;
447: gme_trans_engine_util.load_rsrc_trans (p_batch_row =>l_batch_record, x_rsc_row_count => l_rsrc_row_count, x_return_status => x_return_status);
448: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
449: END setup_resource_transaction;
450:
451: procedure update_process_parameter
452: (

Line 639: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);

635: x_process_param_rec.extend;
636: x_process_param_rec(49) := l_process_param_rec_out.DEVICE_ID ;
637:
638:
639: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
640:
641: END update_process_parameter;
642:
643: procedure save_batch (

Line 657: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);

653: p_commit => fnd_api.g_false,
654: x_return_status => x_return_status,
655: p_clear_qty_cache =>FND_API.g_true
656: );
657: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
658: end save_batch;
659:
660:
661: procedure get_material_transactions(

Line 705: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);

701: ,p_batch_id => p_batch_id
702: ,x_txns_cur => x_mmt_cur
703: ,x_return_status => x_return_status
704: );
705: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
706:
707: end get_material_transactions;
708:
709: procedure get_lot_transactions(

Line 724: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);

720: p_transaction_id => p_transaction_id
721: ,x_lot_txns_cur => x_lt_cur
722: ,x_return_status => x_return_status
723: );
724: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
725: end get_lot_transactions;
726:
727: procedure get_material_reservations(
728: p_organization_id IN NUMBER

Line 767: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);

763: ,x_resvns_cur => x_res_cur
764: ,x_return_status => x_return_status
765: );
766:
767: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
768:
769: end get_material_reservations;
770:
771: procedure get_material_pplots(

Line 789: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);

785: ,x_pplot_cur => x_pplot_cur
786: ,x_return_status => x_return_status
787: );
788:
789: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
790: end get_material_pplots;
791:
792:
793: procedure convert_um (

Line 824: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);

820: RAISE uom_conversion_err;
821: END IF;
822:
823: x_return_status := fnd_api.g_ret_sts_success;
824: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
825: exception
826: WHEN uom_conversion_err THEN
827: x_return_status:= fnd_api.g_ret_sts_error;
828: FND_MESSAGE.SET_NAME('GMO','GMO_UM_CONVERT_ERR');

Line 834: FND_MSG_PUB.ADD;

830: FND_MESSAGE.SET_TOKEN('TO_UOM',p_to_um);
831: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
832: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_task_pvt.convert_um', FALSE);
833: end if;
834: FND_MSG_PUB.ADD;
835: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
836: WHEN OTHERS THEN
837: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
838: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

Line 835: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);

831: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
832: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_task_pvt.convert_um', FALSE);
833: end if;
834: FND_MSG_PUB.ADD;
835: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
836: WHEN OTHERS THEN
837: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
838: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
839: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

Line 844: FND_MSG_PUB.ADD;

840: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
841: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
842: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.convert_um', FALSE);
843: end if;
844: FND_MSG_PUB.ADD;
845: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
846:
847: end convert_um;
848:

Line 845: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);

841: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
842: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.convert_um', FALSE);
843: end if;
844: FND_MSG_PUB.ADD;
845: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
846:
847: end convert_um;
848:
849: procedure qty_within_deviation (

Line 891: FND_MSG_PUB.Get(

887: THEN
888:
889: x_return_status := FND_API.G_RET_STS_ERROR;
890:
891: FND_MSG_PUB.Get(
892: p_msg_index => 1,
893: p_data => x_message_data,
894: p_encoded => FND_API.G_FALSE,
895: p_msg_index_out => l_msg_index_out);

Line 902: FND_MSG_PUB.ADD;

898: EXCEPTION
899: WHEN INVALID_ITEM THEN
900: x_return_status:= fnd_api.g_ret_sts_error;
901: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ITEM');
902: FND_MSG_PUB.ADD;
903: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
904: WHEN INCORRECT_FIXED_VALUE THEN
905: x_return_status:= fnd_api.g_ret_sts_error;
906: FND_MESSAGE.SET_NAME('INV','INV_INCORRECT_FIXED_VALUE');

Line 903: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);

899: WHEN INVALID_ITEM THEN
900: x_return_status:= fnd_api.g_ret_sts_error;
901: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ITEM');
902: FND_MSG_PUB.ADD;
903: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
904: WHEN INCORRECT_FIXED_VALUE THEN
905: x_return_status:= fnd_api.g_ret_sts_error;
906: FND_MESSAGE.SET_NAME('INV','INV_INCORRECT_FIXED_VALUE');
907: FND_MSG_PUB.ADD;

Line 907: FND_MSG_PUB.ADD;

903: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
904: WHEN INCORRECT_FIXED_VALUE THEN
905: x_return_status:= fnd_api.g_ret_sts_error;
906: FND_MESSAGE.SET_NAME('INV','INV_INCORRECT_FIXED_VALUE');
907: FND_MSG_PUB.ADD;
908: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
909: WHEN INVALID_UOM_CONV THEN
910: x_return_status:= fnd_api.g_ret_sts_error;
911: FND_MESSAGE.SET_NAME('INV','INV_INVALID_UOM_CONV');

Line 908: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);

904: WHEN INCORRECT_FIXED_VALUE THEN
905: x_return_status:= fnd_api.g_ret_sts_error;
906: FND_MESSAGE.SET_NAME('INV','INV_INCORRECT_FIXED_VALUE');
907: FND_MSG_PUB.ADD;
908: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
909: WHEN INVALID_UOM_CONV THEN
910: x_return_status:= fnd_api.g_ret_sts_error;
911: FND_MESSAGE.SET_NAME('INV','INV_INVALID_UOM_CONV');
912: FND_MESSAGE.SET_TOKEN ('VALUE1',p_um);

Line 914: FND_MSG_PUB.ADD;

910: x_return_status:= fnd_api.g_ret_sts_error;
911: FND_MESSAGE.SET_NAME('INV','INV_INVALID_UOM_CONV');
912: FND_MESSAGE.SET_TOKEN ('VALUE1',p_um);
913: FND_MESSAGE.SET_TOKEN ('VALUE2',p_sec_um);
914: FND_MSG_PUB.ADD;
915: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
916: WHEN DEV_LOW_ERROR THEN
917: x_return_status:= fnd_api.g_ret_sts_error;
918: FND_MESSAGE.SET_NAME('INV','INV_DEVIATION_LO_ERR');

Line 915: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);

911: FND_MESSAGE.SET_NAME('INV','INV_INVALID_UOM_CONV');
912: FND_MESSAGE.SET_TOKEN ('VALUE1',p_um);
913: FND_MESSAGE.SET_TOKEN ('VALUE2',p_sec_um);
914: FND_MSG_PUB.ADD;
915: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
916: WHEN DEV_LOW_ERROR THEN
917: x_return_status:= fnd_api.g_ret_sts_error;
918: FND_MESSAGE.SET_NAME('INV','INV_DEVIATION_LO_ERR');
919: FND_MSG_PUB.ADD;

Line 919: FND_MSG_PUB.ADD;

915: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
916: WHEN DEV_LOW_ERROR THEN
917: x_return_status:= fnd_api.g_ret_sts_error;
918: FND_MESSAGE.SET_NAME('INV','INV_DEVIATION_LO_ERR');
919: FND_MSG_PUB.ADD;
920: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
921: WHEN DEV_HIGH_ERROR THEN
922: x_return_status:= fnd_api.g_ret_sts_error;
923: FND_MESSAGE.SET_NAME('INV','INV_DEVIATION_HI_ERR');

Line 920: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);

916: WHEN DEV_LOW_ERROR THEN
917: x_return_status:= fnd_api.g_ret_sts_error;
918: FND_MESSAGE.SET_NAME('INV','INV_DEVIATION_LO_ERR');
919: FND_MSG_PUB.ADD;
920: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
921: WHEN DEV_HIGH_ERROR THEN
922: x_return_status:= fnd_api.g_ret_sts_error;
923: FND_MESSAGE.SET_NAME('INV','INV_DEVIATION_HI_ERR');
924: FND_MSG_PUB.ADD;

Line 924: FND_MSG_PUB.ADD;

920: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
921: WHEN DEV_HIGH_ERROR THEN
922: x_return_status:= fnd_api.g_ret_sts_error;
923: FND_MESSAGE.SET_NAME('INV','INV_DEVIATION_HI_ERR');
924: FND_MSG_PUB.ADD;
925: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
926: WHEN OTHERS THEN
927: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
928: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

Line 925: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);

921: WHEN DEV_HIGH_ERROR THEN
922: x_return_status:= fnd_api.g_ret_sts_error;
923: FND_MESSAGE.SET_NAME('INV','INV_DEVIATION_HI_ERR');
924: FND_MSG_PUB.ADD;
925: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
926: WHEN OTHERS THEN
927: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
928: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
929: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

Line 934: FND_MSG_PUB.ADD;

930: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
931: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
932: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.qty_within_deviation', FALSE);
933: end if;
934: FND_MSG_PUB.ADD;
935: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
936: END qty_within_deviation;
937:
938: procedure get_dispense_um(

Line 935: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);

931: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
932: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.qty_within_deviation', FALSE);
933: end if;
934: FND_MSG_PUB.ADD;
935: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
936: END qty_within_deviation;
937:
938: procedure get_dispense_um(
939: p_material_detail_id IN NUMBER

Line 960: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);

956: RAISE DISP_NOT_REQ_EXCEPTION;
957: end if;
958: x_dispense_um := l_dispense_config_row.dispense_uom;
959: x_return_status := fnd_api.g_ret_sts_success;
960: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
961: exception
962: when DISP_NOT_REQ_EXCEPTION then
963: x_return_status:= fnd_api.g_ret_sts_error;
964: FND_MESSAGE.SET_NAME('GMO','GMO_DISP_DISPENSE_NOT_REQ_ERR');

Line 968: FND_MSG_PUB.ADD;

964: FND_MESSAGE.SET_NAME('GMO','GMO_DISP_DISPENSE_NOT_REQ_ERR');
965: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
966: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_task_pvt.get_dispense_um', FALSE);
967: end if;
968: FND_MSG_PUB.ADD;
969: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
970: WHEN OTHERS THEN
971: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
972: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

Line 969: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);

965: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
966: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_task_pvt.get_dispense_um', FALSE);
967: end if;
968: FND_MSG_PUB.ADD;
969: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
970: WHEN OTHERS THEN
971: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
972: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
973: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

Line 978: FND_MSG_PUB.ADD;

974: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
975: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
976: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.get_dispense_um', FALSE);
977: end if;
978: FND_MSG_PUB.ADD;
979: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
980:
981: end get_dispense_um;
982:

Line 979: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);

975: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
976: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.get_dispense_um', FALSE);
977: end if;
978: FND_MSG_PUB.ADD;
979: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
980:
981: end get_dispense_um;
982:
983: procedure relieve_reservation(

Line 1000: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);

996: ,p_prim_relieve_qty => p_prim_relieve_quantity
997: ,x_return_status => x_return_status
998: );
999:
1000: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
1001:
1002: EXCEPTION
1003: WHEN OTHERS THEN
1004: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

Line 1011: FND_MSG_PUB.ADD;

1007: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
1008: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1009: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.get_resource_txn_end_date', FALSE);
1010: end if;
1011: FND_MSG_PUB.ADD;
1012: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
1013: END relieve_reservation;
1014:
1015: procedure relieve_pending_lot(

Line 1012: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);

1008: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1009: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.get_resource_txn_end_date', FALSE);
1010: end if;
1011: FND_MSG_PUB.ADD;
1012: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
1013: END relieve_reservation;
1014:
1015: procedure relieve_pending_lot(
1016: p_pending_lot_id IN NUMBER

Line 1033: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);

1029: ,p_secondary_quantity => p_secondary_quantity
1030: ,x_return_status => x_return_status
1031: );
1032:
1033: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
1034:
1035: EXCEPTION
1036: WHEN OTHERS THEN
1037: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

Line 1044: FND_MSG_PUB.ADD;

1040: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
1041: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1042: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.relieve_pending_lot', FALSE);
1043: end if;
1044: FND_MSG_PUB.ADD;
1045: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
1046: END relieve_pending_lot;
1047:
1048:

Line 1045: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);

1041: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1042: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.relieve_pending_lot', FALSE);
1043: end if;
1044: FND_MSG_PUB.ADD;
1045: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
1046: END relieve_pending_lot;
1047:
1048:
1049: procedure create_material_transaction(

Line 1232: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);

1228: ELSE
1229: ROLLBACK TO create_transaction;
1230: END IF;
1231:
1232: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
1233:
1234: EXCEPTION
1235: WHEN OTHERS THEN
1236: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

Line 1243: FND_MSG_PUB.ADD;

1239: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
1240: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1241: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.create_material_transaction', FALSE);
1242: end if;
1243: FND_MSG_PUB.ADD;
1244: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
1245: END create_material_transaction;
1246:
1247:

Line 1244: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);

1240: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1241: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.create_material_transaction', FALSE);
1242: end if;
1243: FND_MSG_PUB.ADD;
1244: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
1245: END create_material_transaction;
1246:
1247:
1248:

Line 1307: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);

1303: IF(x_return_status <> 'S') THEN
1304: ROLLBACK TO update_transaction;
1305: END IF;
1306:
1307: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
1308:
1309:
1310: EXCEPTION
1311: WHEN OTHERS THEN

Line 1319: FND_MSG_PUB.ADD;

1315: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
1316: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1317: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.update_material_transaction', FALSE);
1318: end if;
1319: FND_MSG_PUB.ADD;
1320: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
1321: END update_material_transaction;
1322:
1323:

Line 1320: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);

1316: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1317: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.update_material_transaction', FALSE);
1318: end if;
1319: FND_MSG_PUB.ADD;
1320: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
1321: END update_material_transaction;
1322:
1323:
1324: procedure delete_material_transaction(

Line 1373: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);

1369: p_transaction_id => l_mtl_txn_rec.TRANSACTION_INTERFACE_ID,
1370: x_return_status => x_return_status
1371: );
1372:
1373: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
1374:
1375: EXCEPTION
1376: WHEN OTHERS THEN
1377: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

Line 1384: FND_MSG_PUB.ADD;

1380: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
1381: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1382: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.delete_material_transaction', FALSE);
1383: end if;
1384: FND_MSG_PUB.ADD;
1385: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
1386: END delete_material_transaction;
1387:
1388: procedure create_lot(

Line 1385: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);

1381: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1382: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.delete_material_transaction', FALSE);
1383: end if;
1384: FND_MSG_PUB.ADD;
1385: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
1386: END delete_material_transaction;
1387:
1388: procedure create_lot(
1389: p_lot_rec IN fnd_table_of_varchar2_255

Line 1464: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);

1460: , p_supplier_lot_number => NULL
1461: , p_vendor_name => NULL
1462: , p_source => NULL
1463: ) ;
1464: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
1465: EXCEPTION
1466: WHEN OTHERS THEN
1467: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
1468: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

Line 1474: FND_MSG_PUB.ADD;

1470: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
1471: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1472: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.create_lot', FALSE);
1473: end if;
1474: FND_MSG_PUB.ADD;
1475: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
1476: END create_lot;
1477:
1478: procedure generate_lot(

Line 1475: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);

1471: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1472: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.create_lot', FALSE);
1473: end if;
1474: FND_MSG_PUB.ADD;
1475: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
1476: END create_lot;
1477:
1478: procedure generate_lot(
1479: p_organization_id IN NUMBER

Line 1515: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);

1511: x_msg_count => x_message_count,
1512: x_msg_data => x_message_data
1513: );
1514:
1515: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
1516: EXCEPTION
1517: WHEN OTHERS THEN
1518: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
1519: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

Line 1525: FND_MSG_PUB.ADD;

1521: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
1522: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1523: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.generate_lot', FALSE);
1524: end if;
1525: FND_MSG_PUB.ADD;
1526: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
1527: END generate_lot;
1528:
1529: procedure get_lot_event_key (

Line 1526: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);

1522: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1523: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.generate_lot', FALSE);
1524: end if;
1525: FND_MSG_PUB.ADD;
1526: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
1527: END generate_lot;
1528:
1529: procedure get_lot_event_key (
1530: p_organization_id IN NUMBER

Line 1674: FND_MSG_PUB.ADD;

1670: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
1671: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1672: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'release raised exception', FALSE);
1673: end if;
1674: FND_MSG_PUB.ADD;
1675: --FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message);
1676:
1677: WHEN COMPLETE_EXCEPTION THEN
1678: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

Line 1675: --FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message);

1671: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1672: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'release raised exception', FALSE);
1673: end if;
1674: FND_MSG_PUB.ADD;
1675: --FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message);
1676:
1677: WHEN COMPLETE_EXCEPTION THEN
1678: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
1679: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);

Line 1683: FND_MSG_PUB.ADD;

1679: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
1680: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1681: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'complete raised exception', FALSE);
1682: end if;
1683: FND_MSG_PUB.ADD;
1684: --FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message);
1685:
1686: WHEN OTHERS THEN
1687: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

Line 1684: --FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message);

1680: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1681: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'complete raised exception', FALSE);
1682: end if;
1683: FND_MSG_PUB.ADD;
1684: --FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message);
1685:
1686: WHEN OTHERS THEN
1687: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
1688: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);

Line 1692: FND_MSG_PUB.ADD;

1688: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
1689: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1690: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'Other exception', FALSE);
1691: end if;
1692: FND_MSG_PUB.ADD;
1693: --FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message);
1694:
1695:
1696: END release_or_complete_step;

Line 1693: --FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message);

1689: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1690: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'Other exception', FALSE);
1691: end if;
1692: FND_MSG_PUB.ADD;
1693: --FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message);
1694:
1695:
1696: END release_or_complete_step;
1697: PROCEDURE get_origination_date