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_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 373: IF (x_return_status = fnd_api.g_ret_sts_success) then

369: p_rsrc_txn_gtmp_rec => l_resource_transaction_rec_in,
370: x_rsrc_txn_gtmp_rec => l_resource_transaction_rec_out,
371: x_return_status => x_return_status);
372:
373: IF (x_return_status = fnd_api.g_ret_sts_success) then
374: UPDATE GME_BATCH_STEP_RESOURCES
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);

Line 653: p_commit => fnd_api.g_false,

649: begin
650: gme_api_pub.save_batch (
651: p_header_id => null,
652: p_table => p_table,
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);

Line 655: p_clear_qty_cache =>FND_API.g_true

651: p_header_id => null,
652: p_table => p_table,
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:

Line 823: x_return_status := fnd_api.g_ret_sts_success;

819: if (x_to_qty = -99999) THEN
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;

Line 827: x_return_status:= fnd_api.g_ret_sts_error;

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

Line 837: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

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

Line 874: x_return_status := FND_API.G_RET_STS_SUCCESS;

870: l_msg_index_out NUMBER;
871:
872: BEGIN
873:
874: x_return_status := FND_API.G_RET_STS_SUCCESS;
875:
876: -- Validate the quantities within deviation
877: l_is_valid := INV_CONVERT.within_deviation(
878: p_organization_id => p_organization_id

Line 889: x_return_status := FND_API.G_RET_STS_ERROR;

885: , p_uom_code2 => p_sec_um);
886: IF (l_is_valid = 0)
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,

Line 894: p_encoded => FND_API.G_FALSE,

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);
896: END IF;
897:
898: EXCEPTION

Line 900: x_return_status:= fnd_api.g_ret_sts_error;

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

Line 905: 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;
908: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
909: WHEN INVALID_UOM_CONV THEN

Line 910: 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);
913: FND_MESSAGE.SET_TOKEN ('VALUE2',p_sec_um);
914: FND_MSG_PUB.ADD;

Line 917: x_return_status:= fnd_api.g_ret_sts_error;

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;
920: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
921: WHEN DEV_HIGH_ERROR THEN

Line 922: 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;
925: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
926: WHEN OTHERS THEN

Line 927: x_return_status := fnd_api.G_RET_STS_UNEXP_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);
930: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
931: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 959: x_return_status := fnd_api.g_ret_sts_success;

955: if(l_dispense_config_row.config_id is null) then
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;

Line 963: x_return_status:= fnd_api.g_ret_sts_error;

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

Line 971: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

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

Line 1004: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

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

Line 1037: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

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

Line 1236: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

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

Line 1312: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

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

Line 1377: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

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

Line 1417: ,p_init_msg_list => fnd_api.g_true

1413: (
1414: p_lot_rec => l_lot_rec
1415: ,p_source => NULL
1416: ,p_api_version => 1.0
1417: ,p_init_msg_list => fnd_api.g_true
1418: ,p_commit => fnd_api.g_false
1419: ,p_validation_level => fnd_api.g_valid_level_full
1420: ,p_origin_txn_id => 1
1421: );

Line 1418: ,p_commit => fnd_api.g_false

1414: p_lot_rec => l_lot_rec
1415: ,p_source => NULL
1416: ,p_api_version => 1.0
1417: ,p_init_msg_list => fnd_api.g_true
1418: ,p_commit => fnd_api.g_false
1419: ,p_validation_level => fnd_api.g_valid_level_full
1420: ,p_origin_txn_id => 1
1421: );
1422: */

Line 1419: ,p_validation_level => fnd_api.g_valid_level_full

1415: ,p_source => NULL
1416: ,p_api_version => 1.0
1417: ,p_init_msg_list => fnd_api.g_true
1418: ,p_commit => fnd_api.g_false
1419: ,p_validation_level => fnd_api.g_valid_level_full
1420: ,p_origin_txn_id => 1
1421: );
1422: */
1423: inv_lot_api_pub.create_inv_lot(

Line 1467: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

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

Line 1506: p_init_msg_list => FND_API.G_FALSE,

1502: p_transaction_action_id => NULL,
1503: p_transaction_source_type_id => NULL,
1504: p_lot_number => NULL,
1505: p_api_version => 1.0,
1506: p_init_msg_list => FND_API.G_FALSE,
1507: p_commit => FND_API.G_FALSE,
1508: p_validation_level => NULL,
1509: p_parent_lot_number => null,
1510: x_return_status => x_return_status,

Line 1507: p_commit => FND_API.G_FALSE,

1503: p_transaction_source_type_id => NULL,
1504: p_lot_number => NULL,
1505: p_api_version => 1.0,
1506: p_init_msg_list => FND_API.G_FALSE,
1507: p_commit => FND_API.G_FALSE,
1508: p_validation_level => NULL,
1509: p_parent_lot_number => null,
1510: x_return_status => x_return_status,
1511: x_msg_count => x_message_count,

Line 1518: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

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

Line 1617: ,p_init_msg_list => fnd_api.g_false

1613:
1614: gme_api_pub.release_step(
1615: p_api_version => 2.0
1616: ,p_validation_level => gme_common_pvt.g_max_errors
1617: ,p_init_msg_list => fnd_api.g_false
1618: ,p_commit => fnd_api.g_false
1619: ,p_save_batch => fnd_api.g_false
1620: ,x_message_count => x_message_count
1621: ,x_message_list => x_message

Line 1618: ,p_commit => fnd_api.g_false

1614: gme_api_pub.release_step(
1615: p_api_version => 2.0
1616: ,p_validation_level => gme_common_pvt.g_max_errors
1617: ,p_init_msg_list => fnd_api.g_false
1618: ,p_commit => fnd_api.g_false
1619: ,p_save_batch => fnd_api.g_false
1620: ,x_message_count => x_message_count
1621: ,x_message_list => x_message
1622: ,x_return_status => x_return_status

Line 1619: ,p_save_batch => fnd_api.g_false

1615: p_api_version => 2.0
1616: ,p_validation_level => gme_common_pvt.g_max_errors
1617: ,p_init_msg_list => fnd_api.g_false
1618: ,p_commit => fnd_api.g_false
1619: ,p_save_batch => fnd_api.g_false
1620: ,x_message_count => x_message_count
1621: ,x_message_list => x_message
1622: ,x_return_status => x_return_status
1623: ,p_batch_step_rec => l_batch_step_details

Line 1626: ,p_ignore_exception => fnd_api.g_false

1622: ,x_return_status => x_return_status
1623: ,p_batch_step_rec => l_batch_step_details
1624: ,p_batch_no => l_batch_header.batch_no
1625: ,p_org_code => l_batch_header.plant_code
1626: ,p_ignore_exception => fnd_api.g_false
1627: ,p_validate_flexfields => fnd_api.g_false
1628: ,x_batch_step_rec => x_batch_step_rec
1629: ,x_exception_material_tbl => vo_exception_material_tbl
1630: );

Line 1627: ,p_validate_flexfields => fnd_api.g_false

1623: ,p_batch_step_rec => l_batch_step_details
1624: ,p_batch_no => l_batch_header.batch_no
1625: ,p_org_code => l_batch_header.plant_code
1626: ,p_ignore_exception => fnd_api.g_false
1627: ,p_validate_flexfields => fnd_api.g_false
1628: ,x_batch_step_rec => x_batch_step_rec
1629: ,x_exception_material_tbl => vo_exception_material_tbl
1630: );
1631:

Line 1644: ,p_init_msg_list => fnd_api.g_false

1640:
1641: gme_api_pub.complete_step(
1642: p_api_version => 2.0
1643: ,p_validation_level => gme_common_pvt.g_max_errors
1644: ,p_init_msg_list => fnd_api.g_false
1645: ,p_commit => fnd_api.g_false
1646: ,p_save_batch => fnd_api.g_false
1647: ,x_message_count => x_message_count
1648: ,x_message_list => x_message

Line 1645: ,p_commit => fnd_api.g_false

1641: gme_api_pub.complete_step(
1642: p_api_version => 2.0
1643: ,p_validation_level => gme_common_pvt.g_max_errors
1644: ,p_init_msg_list => fnd_api.g_false
1645: ,p_commit => fnd_api.g_false
1646: ,p_save_batch => fnd_api.g_false
1647: ,x_message_count => x_message_count
1648: ,x_message_list => x_message
1649: ,x_return_status => x_return_status

Line 1646: ,p_save_batch => fnd_api.g_false

1642: p_api_version => 2.0
1643: ,p_validation_level => gme_common_pvt.g_max_errors
1644: ,p_init_msg_list => fnd_api.g_false
1645: ,p_commit => fnd_api.g_false
1646: ,p_save_batch => fnd_api.g_false
1647: ,x_message_count => x_message_count
1648: ,x_message_list => x_message
1649: ,x_return_status => x_return_status
1650: ,p_batch_step_rec => l_batch_step_details

Line 1653: ,p_ignore_exception => fnd_api.g_false

1649: ,x_return_status => x_return_status
1650: ,p_batch_step_rec => l_batch_step_details
1651: ,p_batch_no => l_batch_header.batch_no
1652: ,p_org_code => l_batch_header.plant_code
1653: ,p_ignore_exception => fnd_api.g_false
1654: ,p_validate_flexfields => fnd_api.g_false
1655: ,x_batch_step_rec => x_batch_step_rec
1656: ,x_exception_material_tbl => vo_exception_material_tbl
1657:

Line 1654: ,p_validate_flexfields => fnd_api.g_false

1650: ,p_batch_step_rec => l_batch_step_details
1651: ,p_batch_no => l_batch_header.batch_no
1652: ,p_org_code => l_batch_header.plant_code
1653: ,p_ignore_exception => fnd_api.g_false
1654: ,p_validate_flexfields => fnd_api.g_false
1655: ,x_batch_step_rec => x_batch_step_rec
1656: ,x_exception_material_tbl => vo_exception_material_tbl
1657:
1658: );

Line 1707: x_return_status := FND_API.G_RET_STS_SUCCESS;

1703: ,x_return_status OUT NOCOPY VARCHAR2
1704: ) IS
1705: orig_date DATE;
1706: BEGIN
1707: x_return_status := FND_API.G_RET_STS_SUCCESS;
1708: BEGIN /*begin segment 2 */
1709: SELECT Nvl(origination_date,p_transaction_date)
1710: INTO x_orig_date
1711: FROM mtl_lot_numbers

Line 1724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1720: END;
1721: EXCEPTION
1722: WHEN OTHERS THEN
1723: x_orig_date := NULL;
1724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1725: END get_origination_date;
1726: end GMO_VBATCH_TASK_PVT;