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 828: FND_MESSAGE.SET_NAME('GMO','GMO_UM_CONVERT_ERR');

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');
829: FND_MESSAGE.SET_TOKEN('FROM_UOM',p_from_um);
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);

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

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');
829: FND_MESSAGE.SET_TOKEN('FROM_UOM',p_from_um);
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;

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

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');
829: FND_MESSAGE.SET_TOKEN('FROM_UOM',p_from_um);
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;

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

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

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

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

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

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

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

897:
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;

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

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

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

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

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

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

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

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

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

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

Line 923: FND_MESSAGE.SET_NAME('INV','INV_DEVIATION_HI_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;
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;

Line 928: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_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);
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);

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

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

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

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

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

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

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

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

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

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

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

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

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

1001:
1002: EXCEPTION
1003: WHEN OTHERS THEN
1004: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
1005: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
1006: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
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);

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

1002: EXCEPTION
1003: WHEN OTHERS THEN
1004: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
1005: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
1006: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
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;

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

1003: WHEN OTHERS THEN
1004: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
1005: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
1006: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
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;

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

1034:
1035: EXCEPTION
1036: WHEN OTHERS THEN
1037: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
1038: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
1039: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
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);

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

1035: EXCEPTION
1036: WHEN OTHERS THEN
1037: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
1038: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
1039: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
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;

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

1036: WHEN OTHERS THEN
1037: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
1038: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
1039: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
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;

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

1233:
1234: EXCEPTION
1235: WHEN OTHERS THEN
1236: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
1237: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
1238: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
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);

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

1234: EXCEPTION
1235: WHEN OTHERS THEN
1236: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
1237: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
1238: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
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;

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

1235: WHEN OTHERS THEN
1236: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
1237: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
1238: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
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;

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

1309:
1310: EXCEPTION
1311: WHEN OTHERS THEN
1312: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
1313: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
1314: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
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);

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

1310: EXCEPTION
1311: WHEN OTHERS THEN
1312: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
1313: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
1314: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
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;

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

1311: WHEN OTHERS THEN
1312: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
1313: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
1314: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
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;

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

1374:
1375: EXCEPTION
1376: WHEN OTHERS THEN
1377: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
1378: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
1379: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
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);

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

1375: EXCEPTION
1376: WHEN OTHERS THEN
1377: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
1378: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
1379: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
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;

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

1376: WHEN OTHERS THEN
1377: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
1378: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
1379: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
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;

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

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');
1469: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
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);

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

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');
1469: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
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;

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

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');
1469: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
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;

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

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');
1520: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
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);

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

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');
1520: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
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;

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

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');
1520: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
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;

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

1665: END IF;
1666:
1667: EXCEPTION
1668: WHEN RELEASE_EXCEPTION THEN
1669: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
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;

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

1666:
1667: EXCEPTION
1668: WHEN RELEASE_EXCEPTION THEN
1669: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
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;

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

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

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

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

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

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

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

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