DBA Data[Home] [Help]

APPS.GMO_VBATCH_TASK_PVT dependencies on FND_API

Line 51: x_return_status := fnd_api.g_ret_sts_success;

47: ELSE
48: l_txn_usage := p_usage;
49: END IF;
50: x_end_date := p_start_date + (l_txn_usage/24);
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');

Line 54: x_return_status := fnd_api.g_ret_sts_error;

50: x_end_date := p_start_date + (l_txn_usage/24);
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);

Line 64: x_return_status:= fnd_api.g_ret_sts_error;

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

Line 74: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

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);
77: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
78: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 123: x_return_status := fnd_api.g_ret_sts_success;

119: END IF;
120: ELSE
121: l_txn_usage := l_usage_time;
122: END IF;
123: x_return_status := fnd_api.g_ret_sts_success;
124: x_usage := l_txn_usage;
125: EXCEPTION
126: WHEN missing_profile_option THEN
127: x_return_status := fnd_api.g_ret_sts_error;

Line 127: x_return_status := fnd_api.g_ret_sts_error;

123: x_return_status := fnd_api.g_ret_sts_success;
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);

Line 137: x_return_status:= fnd_api.g_ret_sts_error;

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

Line 147: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

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);
150: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
151: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 372: IF (x_return_status = fnd_api.g_ret_sts_success) then

368: p_rsrc_txn_gtmp_rec => l_resource_transaction_rec_in,
369: x_rsrc_txn_gtmp_rec => l_resource_transaction_rec_out,
370: x_return_status => x_return_status);
371:
372: IF (x_return_status = fnd_api.g_ret_sts_success) then
373: get_resource_transaction_arr(l_resource_transaction_rec_out, x_resource_transaction_rec);
374: end if;
375: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
376: END create_resource_transaction;

Line 645: p_commit => fnd_api.g_false,

641: begin
642: gme_api_pub.save_batch (
643: p_header_id => null,
644: p_table => p_table,
645: p_commit => fnd_api.g_false,
646: x_return_status => x_return_status,
647: p_clear_qty_cache =>FND_API.g_true
648: );
649: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);

Line 647: p_clear_qty_cache =>FND_API.g_true

643: p_header_id => null,
644: p_table => p_table,
645: p_commit => fnd_api.g_false,
646: x_return_status => x_return_status,
647: p_clear_qty_cache =>FND_API.g_true
648: );
649: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
650: end save_batch;
651:

Line 815: x_return_status := fnd_api.g_ret_sts_success;

811: if (x_to_qty = -99999) THEN
812: RAISE uom_conversion_err;
813: END IF;
814:
815: x_return_status := fnd_api.g_ret_sts_success;
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;

Line 819: x_return_status:= fnd_api.g_ret_sts_error;

815: x_return_status := fnd_api.g_ret_sts_success;
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

Line 829: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

825: end if;
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

Line 866: x_return_status := FND_API.G_RET_STS_SUCCESS;

862: l_msg_index_out NUMBER;
863:
864: BEGIN
865:
866: x_return_status := FND_API.G_RET_STS_SUCCESS;
867:
868: -- Validate the quantities within deviation
869: l_is_valid := INV_CONVERT.within_deviation(
870: p_organization_id => p_organization_id

Line 881: x_return_status := FND_API.G_RET_STS_ERROR;

877: , p_uom_code2 => p_sec_um);
878: IF (l_is_valid = 0)
879: THEN
880:
881: x_return_status := FND_API.G_RET_STS_ERROR;
882:
883: FND_MSG_PUB.Get(
884: p_msg_index => 1,
885: p_data => x_message_data,

Line 886: p_encoded => FND_API.G_FALSE,

882:
883: FND_MSG_PUB.Get(
884: p_msg_index => 1,
885: p_data => x_message_data,
886: p_encoded => FND_API.G_FALSE,
887: p_msg_index_out => l_msg_index_out);
888: END IF;
889:
890: EXCEPTION

Line 892: x_return_status:= fnd_api.g_ret_sts_error;

888: END IF;
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

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

Line 902: 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;
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;

Line 909: x_return_status:= fnd_api.g_ret_sts_error;

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

Line 914: 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;
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

Line 919: x_return_status := fnd_api.G_RET_STS_UNEXP_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;
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

Line 951: x_return_status := fnd_api.g_ret_sts_success;

947: if(l_dispense_config_row.config_id is null) then
948: RAISE DISP_NOT_REQ_EXCEPTION;
949: end if;
950: x_dispense_um := l_dispense_config_row.dispense_uom;
951: x_return_status := fnd_api.g_ret_sts_success;
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;

Line 955: x_return_status:= fnd_api.g_ret_sts_error;

951: x_return_status := fnd_api.g_ret_sts_success;
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;

Line 963: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

959: end if;
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

Line 996: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

992: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
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

Line 1029: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

1025: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
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

Line 1094: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

1090: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
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

Line 1163: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

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

Line 1228: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

1224: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
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

Line 1268: ,p_init_msg_list => fnd_api.g_true

1264: (
1265: p_lot_rec => l_lot_rec
1266: ,p_source => NULL
1267: ,p_api_version => 1.0
1268: ,p_init_msg_list => fnd_api.g_true
1269: ,p_commit => fnd_api.g_false
1270: ,p_validation_level => fnd_api.g_valid_level_full
1271: ,p_origin_txn_id => 1
1272: );

Line 1269: ,p_commit => fnd_api.g_false

1265: p_lot_rec => l_lot_rec
1266: ,p_source => NULL
1267: ,p_api_version => 1.0
1268: ,p_init_msg_list => fnd_api.g_true
1269: ,p_commit => fnd_api.g_false
1270: ,p_validation_level => fnd_api.g_valid_level_full
1271: ,p_origin_txn_id => 1
1272: );
1273: */

Line 1270: ,p_validation_level => fnd_api.g_valid_level_full

1266: ,p_source => NULL
1267: ,p_api_version => 1.0
1268: ,p_init_msg_list => fnd_api.g_true
1269: ,p_commit => fnd_api.g_false
1270: ,p_validation_level => fnd_api.g_valid_level_full
1271: ,p_origin_txn_id => 1
1272: );
1273: */
1274: inv_lot_api_pub.create_inv_lot(

Line 1318: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

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

Line 1357: p_init_msg_list => FND_API.G_FALSE,

1353: p_transaction_action_id => NULL,
1354: p_transaction_source_type_id => NULL,
1355: p_lot_number => NULL,
1356: p_api_version => 1.0,
1357: p_init_msg_list => FND_API.G_FALSE,
1358: p_commit => FND_API.G_FALSE,
1359: p_validation_level => NULL,
1360: p_parent_lot_number => null,
1361: x_return_status => x_return_status,

Line 1358: p_commit => FND_API.G_FALSE,

1354: p_transaction_source_type_id => NULL,
1355: p_lot_number => NULL,
1356: p_api_version => 1.0,
1357: p_init_msg_list => FND_API.G_FALSE,
1358: p_commit => FND_API.G_FALSE,
1359: p_validation_level => NULL,
1360: p_parent_lot_number => null,
1361: x_return_status => x_return_status,
1362: x_msg_count => x_message_count,

Line 1369: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

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