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_MESSAGE

Line 55: FND_MESSAGE.SET_NAME('GME','GME_API_UNABLE_TO_GET_CONSTANT');

51: x_return_status := fnd_api.g_ret_sts_success;
52: EXCEPTION
53: WHEN missing_profile_option THEN
54: x_return_status := fnd_api.g_ret_sts_error;
55: FND_MESSAGE.SET_NAME('GME','GME_API_UNABLE_TO_GET_CONSTANT');
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;

Line 56: FND_MESSAGE.SET_TOKEN('CONSTANT_NAME','BOM:HOUR_UOM_CODE');

52: EXCEPTION
53: WHEN missing_profile_option THEN
54: x_return_status := fnd_api.g_ret_sts_error;
55: FND_MESSAGE.SET_NAME('GME','GME_API_UNABLE_TO_GET_CONSTANT');
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;

Line 65: FND_MESSAGE.SET_NAME('GME','GME_RSRC_USG_NT_CNV_SYUOM');

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');
66: FND_MESSAGE.SET_TOKEN('SY_UOM',l_hour_um);
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);

Line 66: FND_MESSAGE.SET_TOKEN('SY_UOM',l_hour_um);

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');
66: FND_MESSAGE.SET_TOKEN('SY_UOM',l_hour_um);
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;

Line 67: FND_MESSAGE.SET_TOKEN('RSRC_USG_UOM',p_trans_um);

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');
66: FND_MESSAGE.SET_TOKEN('SY_UOM',l_hour_um);
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;

Line 75: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

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);
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);

Line 76: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

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);
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;

Line 77: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);

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);
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;

Line 128: FND_MESSAGE.SET_NAME('GME','GME_API_UNABLE_TO_GET_CONSTANT');

124: x_usage := l_txn_usage;
125: EXCEPTION
126: WHEN missing_profile_option THEN
127: x_return_status := fnd_api.g_ret_sts_error;
128: FND_MESSAGE.SET_NAME('GME','GME_API_UNABLE_TO_GET_CONSTANT');
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;

Line 129: FND_MESSAGE.SET_TOKEN('CONSTANT_NAME','BOM:HOUR_UOM_CODE');

125: EXCEPTION
126: WHEN missing_profile_option THEN
127: x_return_status := fnd_api.g_ret_sts_error;
128: FND_MESSAGE.SET_NAME('GME','GME_API_UNABLE_TO_GET_CONSTANT');
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;

Line 138: FND_MESSAGE.SET_NAME('GME','GME_RSRC_USG_NT_CNV_SYUOM');

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');
139: FND_MESSAGE.SET_TOKEN('SY_UOM',l_hour_um);
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);

Line 139: FND_MESSAGE.SET_TOKEN('SY_UOM',l_hour_um);

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');
139: FND_MESSAGE.SET_TOKEN('SY_UOM',l_hour_um);
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;

Line 140: FND_MESSAGE.SET_TOKEN('RSRC_USG_UOM',p_trans_um);

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');
139: FND_MESSAGE.SET_TOKEN('SY_UOM',l_hour_um);
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;

Line 148: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

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);
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);

Line 149: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

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);
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;

Line 150: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);

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);
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;

Line 820: FND_MESSAGE.SET_NAME('GMO','GMO_UM_CONVERT_ERR');

816: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
817: exception
818: WHEN uom_conversion_err THEN
819: x_return_status:= fnd_api.g_ret_sts_error;
820: FND_MESSAGE.SET_NAME('GMO','GMO_UM_CONVERT_ERR');
821: FND_MESSAGE.SET_TOKEN('FROM_UOM',p_from_um);
822: FND_MESSAGE.SET_TOKEN('TO_UOM',p_to_um);
823: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
824: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_task_pvt.convert_um', FALSE);

Line 821: FND_MESSAGE.SET_TOKEN('FROM_UOM',p_from_um);

817: exception
818: WHEN uom_conversion_err THEN
819: x_return_status:= fnd_api.g_ret_sts_error;
820: FND_MESSAGE.SET_NAME('GMO','GMO_UM_CONVERT_ERR');
821: FND_MESSAGE.SET_TOKEN('FROM_UOM',p_from_um);
822: FND_MESSAGE.SET_TOKEN('TO_UOM',p_to_um);
823: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
824: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_task_pvt.convert_um', FALSE);
825: end if;

Line 822: FND_MESSAGE.SET_TOKEN('TO_UOM',p_to_um);

818: WHEN uom_conversion_err THEN
819: x_return_status:= fnd_api.g_ret_sts_error;
820: FND_MESSAGE.SET_NAME('GMO','GMO_UM_CONVERT_ERR');
821: FND_MESSAGE.SET_TOKEN('FROM_UOM',p_from_um);
822: FND_MESSAGE.SET_TOKEN('TO_UOM',p_to_um);
823: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
824: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_task_pvt.convert_um', FALSE);
825: end if;
826: FND_MSG_PUB.ADD;

Line 830: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

826: FND_MSG_PUB.ADD;
827: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
828: WHEN OTHERS THEN
829: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
830: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
831: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
832: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
833: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
834: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.convert_um', FALSE);

Line 831: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

827: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
828: WHEN OTHERS THEN
829: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
830: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
831: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
832: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
833: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
834: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.convert_um', FALSE);
835: end if;

Line 832: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);

828: WHEN OTHERS THEN
829: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
830: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
831: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
832: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
833: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
834: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.convert_um', FALSE);
835: end if;
836: FND_MSG_PUB.ADD;

Line 893: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ITEM');

889:
890: EXCEPTION
891: WHEN INVALID_ITEM THEN
892: x_return_status:= fnd_api.g_ret_sts_error;
893: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ITEM');
894: FND_MSG_PUB.ADD;
895: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
896: WHEN INCORRECT_FIXED_VALUE THEN
897: x_return_status:= fnd_api.g_ret_sts_error;

Line 898: FND_MESSAGE.SET_NAME('INV','INV_INCORRECT_FIXED_VALUE');

894: FND_MSG_PUB.ADD;
895: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
896: WHEN INCORRECT_FIXED_VALUE THEN
897: x_return_status:= fnd_api.g_ret_sts_error;
898: FND_MESSAGE.SET_NAME('INV','INV_INCORRECT_FIXED_VALUE');
899: FND_MSG_PUB.ADD;
900: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
901: WHEN INVALID_UOM_CONV THEN
902: x_return_status:= fnd_api.g_ret_sts_error;

Line 903: FND_MESSAGE.SET_NAME('INV','INV_INVALID_UOM_CONV');

899: FND_MSG_PUB.ADD;
900: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
901: WHEN INVALID_UOM_CONV THEN
902: x_return_status:= fnd_api.g_ret_sts_error;
903: FND_MESSAGE.SET_NAME('INV','INV_INVALID_UOM_CONV');
904: FND_MESSAGE.SET_TOKEN ('VALUE1',p_um);
905: FND_MESSAGE.SET_TOKEN ('VALUE2',p_sec_um);
906: FND_MSG_PUB.ADD;
907: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);

Line 904: FND_MESSAGE.SET_TOKEN ('VALUE1',p_um);

900: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
901: WHEN INVALID_UOM_CONV THEN
902: x_return_status:= fnd_api.g_ret_sts_error;
903: FND_MESSAGE.SET_NAME('INV','INV_INVALID_UOM_CONV');
904: FND_MESSAGE.SET_TOKEN ('VALUE1',p_um);
905: FND_MESSAGE.SET_TOKEN ('VALUE2',p_sec_um);
906: FND_MSG_PUB.ADD;
907: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
908: WHEN DEV_LOW_ERROR THEN

Line 905: FND_MESSAGE.SET_TOKEN ('VALUE2',p_sec_um);

901: WHEN INVALID_UOM_CONV THEN
902: x_return_status:= fnd_api.g_ret_sts_error;
903: FND_MESSAGE.SET_NAME('INV','INV_INVALID_UOM_CONV');
904: FND_MESSAGE.SET_TOKEN ('VALUE1',p_um);
905: FND_MESSAGE.SET_TOKEN ('VALUE2',p_sec_um);
906: FND_MSG_PUB.ADD;
907: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
908: WHEN DEV_LOW_ERROR THEN
909: x_return_status:= fnd_api.g_ret_sts_error;

Line 910: FND_MESSAGE.SET_NAME('INV','INV_DEVIATION_LO_ERR');

906: FND_MSG_PUB.ADD;
907: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
908: WHEN DEV_LOW_ERROR THEN
909: x_return_status:= fnd_api.g_ret_sts_error;
910: FND_MESSAGE.SET_NAME('INV','INV_DEVIATION_LO_ERR');
911: FND_MSG_PUB.ADD;
912: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
913: WHEN DEV_HIGH_ERROR THEN
914: x_return_status:= fnd_api.g_ret_sts_error;

Line 915: FND_MESSAGE.SET_NAME('INV','INV_DEVIATION_HI_ERR');

911: FND_MSG_PUB.ADD;
912: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
913: WHEN DEV_HIGH_ERROR THEN
914: x_return_status:= fnd_api.g_ret_sts_error;
915: FND_MESSAGE.SET_NAME('INV','INV_DEVIATION_HI_ERR');
916: FND_MSG_PUB.ADD;
917: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
918: WHEN OTHERS THEN
919: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

Line 920: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

916: FND_MSG_PUB.ADD;
917: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
918: WHEN OTHERS THEN
919: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
920: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
921: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
922: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
923: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
924: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.qty_within_deviation', FALSE);

Line 921: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

917: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
918: WHEN OTHERS THEN
919: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
920: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
921: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
922: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
923: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
924: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.qty_within_deviation', FALSE);
925: end if;

Line 922: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);

918: WHEN OTHERS THEN
919: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
920: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
921: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
922: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
923: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
924: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.qty_within_deviation', FALSE);
925: end if;
926: FND_MSG_PUB.ADD;

Line 956: FND_MESSAGE.SET_NAME('GMO','GMO_DISP_DISPENSE_NOT_REQ_ERR');

952: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
953: exception
954: when DISP_NOT_REQ_EXCEPTION then
955: x_return_status:= fnd_api.g_ret_sts_error;
956: FND_MESSAGE.SET_NAME('GMO','GMO_DISP_DISPENSE_NOT_REQ_ERR');
957: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
958: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_vbatch_task_pvt.get_dispense_um', FALSE);
959: end if;
960: FND_MSG_PUB.ADD;

Line 964: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

960: FND_MSG_PUB.ADD;
961: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
962: WHEN OTHERS THEN
963: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
964: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
965: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
966: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
967: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
968: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.get_dispense_um', FALSE);

Line 965: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

961: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
962: WHEN OTHERS THEN
963: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
964: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
965: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
966: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
967: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
968: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.get_dispense_um', FALSE);
969: end if;

Line 966: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);

962: WHEN OTHERS THEN
963: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
964: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
965: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
966: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
967: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
968: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.get_dispense_um', FALSE);
969: end if;
970: FND_MSG_PUB.ADD;

Line 997: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

993:
994: EXCEPTION
995: WHEN OTHERS THEN
996: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
997: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
998: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
999: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
1000: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1001: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.get_resource_txn_end_date', FALSE);

Line 998: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

994: EXCEPTION
995: WHEN OTHERS THEN
996: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
997: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
998: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
999: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
1000: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1001: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.get_resource_txn_end_date', FALSE);
1002: end if;

Line 999: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);

995: WHEN OTHERS THEN
996: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
997: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
998: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
999: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
1000: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1001: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.get_resource_txn_end_date', FALSE);
1002: end if;
1003: FND_MSG_PUB.ADD;

Line 1030: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

1026:
1027: EXCEPTION
1028: WHEN OTHERS THEN
1029: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
1030: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
1031: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
1032: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
1033: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1034: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.relieve_pending_lot', FALSE);

Line 1031: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

1027: EXCEPTION
1028: WHEN OTHERS THEN
1029: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
1030: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
1031: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
1032: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
1033: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1034: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.relieve_pending_lot', FALSE);
1035: end if;

Line 1032: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);

1028: WHEN OTHERS THEN
1029: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
1030: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
1031: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
1032: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
1033: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1034: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.relieve_pending_lot', FALSE);
1035: end if;
1036: FND_MSG_PUB.ADD;

Line 1095: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

1091:
1092: EXCEPTION
1093: WHEN OTHERS THEN
1094: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
1095: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
1096: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
1097: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
1098: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1099: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.create_material_transaction', FALSE);

Line 1096: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

1092: EXCEPTION
1093: WHEN OTHERS THEN
1094: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
1095: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
1096: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
1097: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
1098: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1099: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.create_material_transaction', FALSE);
1100: end if;

Line 1097: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);

1093: WHEN OTHERS THEN
1094: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
1095: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
1096: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
1097: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
1098: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1099: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.create_material_transaction', FALSE);
1100: end if;
1101: FND_MSG_PUB.ADD;

Line 1164: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

1160:
1161: EXCEPTION
1162: WHEN OTHERS THEN
1163: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
1164: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
1165: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
1166: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
1167: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1168: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.update_material_transaction', FALSE);

Line 1165: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

1161: EXCEPTION
1162: WHEN OTHERS THEN
1163: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
1164: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
1165: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
1166: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
1167: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1168: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.update_material_transaction', FALSE);
1169: end if;

Line 1166: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);

1162: WHEN OTHERS THEN
1163: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
1164: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
1165: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
1166: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
1167: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1168: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.update_material_transaction', FALSE);
1169: end if;
1170: FND_MSG_PUB.ADD;

Line 1229: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

1225:
1226: EXCEPTION
1227: WHEN OTHERS THEN
1228: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
1229: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
1230: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
1231: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
1232: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1233: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.delete_material_transaction', FALSE);

Line 1230: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

1226: EXCEPTION
1227: WHEN OTHERS THEN
1228: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
1229: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
1230: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
1231: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
1232: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1233: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.delete_material_transaction', FALSE);
1234: end if;

Line 1231: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);

1227: WHEN OTHERS THEN
1228: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
1229: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
1230: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
1231: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
1232: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1233: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.delete_material_transaction', FALSE);
1234: end if;
1235: FND_MSG_PUB.ADD;

Line 1319: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

1315: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
1316: EXCEPTION
1317: WHEN OTHERS THEN
1318: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
1319: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
1320: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
1321: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
1322: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1323: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.create_lot', FALSE);

Line 1320: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

1316: EXCEPTION
1317: WHEN OTHERS THEN
1318: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
1319: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
1320: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
1321: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
1322: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1323: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.create_lot', FALSE);
1324: end if;

Line 1321: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);

1317: WHEN OTHERS THEN
1318: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
1319: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
1320: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
1321: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
1322: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1323: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.create_lot', FALSE);
1324: end if;
1325: FND_MSG_PUB.ADD;

Line 1370: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

1366: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
1367: EXCEPTION
1368: WHEN OTHERS THEN
1369: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
1370: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
1371: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
1372: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
1373: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1374: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.generate_lot', FALSE);

Line 1371: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

1367: EXCEPTION
1368: WHEN OTHERS THEN
1369: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
1370: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
1371: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
1372: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
1373: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1374: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.generate_lot', FALSE);
1375: end if;

Line 1372: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);

1368: WHEN OTHERS THEN
1369: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
1370: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
1371: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
1372: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
1373: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1374: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.generate_lot', FALSE);
1375: end if;
1376: FND_MSG_PUB.ADD;