DBA Data[Home] [Help]

APPS.WMS_UT_PKG dependencies on FND_API

Line 500: p_commit => fnd_api.g_false,

496:
497: print_debug('Processing transaction : ' || l_trx_hdr_id);
498: retval := INV_LPN_TRX_PUB.PROCESS_LPN_TRX(
499: p_trx_hdr_id => l_trx_hdr_id,
500: p_commit => fnd_api.g_false,
501: x_proc_msg => l_ret_msg,
502: p_proc_mode => 1,
503: p_process_trx => fnd_api.g_true,
504: p_atomic => fnd_api.g_true,

Line 503: p_process_trx => fnd_api.g_true,

499: p_trx_hdr_id => l_trx_hdr_id,
500: p_commit => fnd_api.g_false,
501: x_proc_msg => l_ret_msg,
502: p_proc_mode => 1,
503: p_process_trx => fnd_api.g_true,
504: p_atomic => fnd_api.g_true,
505: p_business_flow_code => NULL,
506: p_init_msg_list => TRUE);
507: print_debug('Done Processing transaction : ' || l_ret_msg);

Line 504: p_atomic => fnd_api.g_true,

500: p_commit => fnd_api.g_false,
501: x_proc_msg => l_ret_msg,
502: p_proc_mode => 1,
503: p_process_trx => fnd_api.g_true,
504: p_atomic => fnd_api.g_true,
505: p_business_flow_code => NULL,
506: p_init_msg_list => TRUE);
507: print_debug('Done Processing transaction : ' || l_ret_msg);
508: END LOOP;

Line 1060: , p_init_msg_lst => fnd_api.g_false

1056:
1057: print_debug('Rsv Dem line :' || l_demand_source_line_id);
1058: inv_reservation_pub.create_reservation(
1059: p_api_version_number => 1.0
1060: , p_init_msg_lst => fnd_api.g_false
1061: , x_return_status => l_return_status
1062: , x_msg_count => l_msg_count
1063: , x_msg_data => l_msg_data
1064: , p_rsv_rec => l_new_reservation

Line 1067: , p_partial_reservation_flag => fnd_api.g_true

1063: , x_msg_data => l_msg_data
1064: , p_rsv_rec => l_new_reservation
1065: , p_serial_number => l_rsvs_serials
1066: , x_serial_number => l_reserved_serials
1067: , p_partial_reservation_flag => fnd_api.g_true
1068: , p_force_reservation_flag => fnd_api.g_false
1069: , p_validation_flag => 'Q'
1070: , x_quantity_reserved => l_qty_succ_reserved
1071: , x_reservation_id => l_new_reservation_id

Line 1068: , p_force_reservation_flag => fnd_api.g_false

1064: , p_rsv_rec => l_new_reservation
1065: , p_serial_number => l_rsvs_serials
1066: , x_serial_number => l_reserved_serials
1067: , p_partial_reservation_flag => fnd_api.g_true
1068: , p_force_reservation_flag => fnd_api.g_false
1069: , p_validation_flag => 'Q'
1070: , x_quantity_reserved => l_qty_succ_reserved
1071: , x_reservation_id => l_new_reservation_id
1072: );

Line 1218: l_commit VARCHAR2(1) := FND_API.G_FALSE;

1214:
1215: l_return_status VARCHAR(10);
1216: l_msg_count NUMBER;
1217: l_msg_data VARCHAR2(200);
1218: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1219:
1220: l_update_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1221: l_reservations inv_reservation_global.mtl_reservation_tbl_type;
1222: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

Line 1281: p_init_msg_list => FND_API.G_FALSE,

1277:
1278: Inv_Move_Order_Pub.Create_Move_Order_Header
1279: (
1280: p_api_version_number => 1.0,
1281: p_init_msg_list => FND_API.G_FALSE,
1282: p_return_values => FND_API.G_TRUE,
1283: p_commit => l_commit,
1284: p_trohdr_rec => l_trohdr_rec,
1285: p_trohdr_val_rec => l_trohdr_val_rec,

Line 1282: p_return_values => FND_API.G_TRUE,

1278: Inv_Move_Order_Pub.Create_Move_Order_Header
1279: (
1280: p_api_version_number => 1.0,
1281: p_init_msg_list => FND_API.G_FALSE,
1282: p_return_values => FND_API.G_TRUE,
1283: p_commit => l_commit,
1284: p_trohdr_rec => l_trohdr_rec,
1285: p_trohdr_val_rec => l_trohdr_val_rec,
1286: x_trohdr_rec => l_trohdr_rec,

Line 1347: p_init_msg_list => FND_API.G_FALSE,

1343: print_debug('Calling create move order lines - ' || l_trolin_tbl.count);
1344: Inv_Move_Order_Pub.Create_Move_Order_Lines
1345: (
1346: p_api_version_number => 1.0,
1347: p_init_msg_list => FND_API.G_FALSE,
1348: p_return_values => FND_API.G_TRUE,
1349: p_commit => l_commit,
1350: x_return_status => l_return_status,
1351: x_msg_count => l_msg_count,

Line 1348: p_return_values => FND_API.G_TRUE,

1344: Inv_Move_Order_Pub.Create_Move_Order_Lines
1345: (
1346: p_api_version_number => 1.0,
1347: p_init_msg_list => FND_API.G_FALSE,
1348: p_return_values => FND_API.G_TRUE,
1349: p_commit => l_commit,
1350: x_return_status => l_return_status,
1351: x_msg_count => l_msg_count,
1352: x_msg_data => l_msg_data,

Line 1751: ,p_validate_only => FND_API.G_FALSE

1747:
1748: print_debug('Importing orders............... ' || l_orig_sys_tbl.first || '-' || l_orig_sys_tbl.last);
1749: OE_BULK_ORDER_PVT.Process_Batch(
1750: p_batch_id => l_request_id
1751: ,p_validate_only => FND_API.G_FALSE
1752: ,x_msg_count => l_msg_count
1753: ,x_msg_data => l_msg_data
1754: ,x_return_status => l_return_status);
1755: if l_msg_count > 2 then

Line 1788: if l_return_status = FND_API.G_RET_STS_ERROR then

1784: );
1785: print_debug(substr(l_msg_data,1,200));
1786: end loop;
1787:
1788: if l_return_status = FND_API.G_RET_STS_ERROR then
1789: print_debug('Expected error');
1790: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1791: print_debug('UNExpected error');
1792: end if;

Line 1790: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

1786: end loop;
1787:
1788: if l_return_status = FND_API.G_RET_STS_ERROR then
1789: print_debug('Expected error');
1790: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1791: print_debug('UNExpected error');
1792: end if;
1793: -- Setting end request date
1794: SELECT to_char(sysdate, 'MM/DD/RR hh:mi:ss')

Line 2053: l_commit VARCHAR2(1) := FND_API.G_FALSE;

2049:
2050: l_return_status VARCHAR(10);
2051: l_msg_count NUMBER;
2052: l_msg_data VARCHAR2(200);
2053: l_commit VARCHAR2(1) := FND_API.G_FALSE;
2054: l_flow VARCHAR2(10);
2055: l_wtt_tbl wms_rule_extn_pvt.g_suggestion_list_rec_type;
2056: l_simulation_mode number;
2057: l_simulation_id number;

Line 2078: , p_init_msg_list => fnd_api.g_false

2074:
2075: FOR i in 1..g_trolin_tbl.count LOOP
2076: wms_rule_extn_pvt.suggest_reservations(
2077: p_api_version => 1.0
2078: , p_init_msg_list => fnd_api.g_false
2079: , p_commit => fnd_api.g_false
2080: , p_validation_level => 0
2081: , x_return_status => l_return_status
2082: , x_msg_count => l_msg_count

Line 2079: , p_commit => fnd_api.g_false

2075: FOR i in 1..g_trolin_tbl.count LOOP
2076: wms_rule_extn_pvt.suggest_reservations(
2077: p_api_version => 1.0
2078: , p_init_msg_list => fnd_api.g_false
2079: , p_commit => fnd_api.g_false
2080: , p_validation_level => 0
2081: , x_return_status => l_return_status
2082: , x_msg_count => l_msg_count
2083: , x_msg_data => l_msg_data

Line 2172: p_init_msg_list => fnd_api.g_true,

2168: g_start_time := SYSDATE;
2169: wms_engine_pvt.create_suggestions
2170: (
2171: p_api_version => 1.0,
2172: p_init_msg_list => fnd_api.g_true,
2173: p_commit => fnd_api.g_false,
2174: p_validation_level => fnd_api.g_valid_level_full,
2175: x_return_status => l_return_status,
2176: x_msg_count => l_msg_count,

Line 2173: p_commit => fnd_api.g_false,

2169: wms_engine_pvt.create_suggestions
2170: (
2171: p_api_version => 1.0,
2172: p_init_msg_list => fnd_api.g_true,
2173: p_commit => fnd_api.g_false,
2174: p_validation_level => fnd_api.g_valid_level_full,
2175: x_return_status => l_return_status,
2176: x_msg_count => l_msg_count,
2177: x_msg_data => l_msg_data,

Line 2174: p_validation_level => fnd_api.g_valid_level_full,

2170: (
2171: p_api_version => 1.0,
2172: p_init_msg_list => fnd_api.g_true,
2173: p_commit => fnd_api.g_false,
2174: p_validation_level => fnd_api.g_valid_level_full,
2175: x_return_status => l_return_status,
2176: x_msg_count => l_msg_count,
2177: x_msg_data => l_msg_data,
2178: p_transaction_temp_id => g_trolin_tbl(i).line_id,

Line 2180: p_suggest_serial => fnd_api.g_true,

2176: x_msg_count => l_msg_count,
2177: x_msg_data => l_msg_data,
2178: p_transaction_temp_id => g_trolin_tbl(i).line_id,
2179: p_reservations => l_demand_rsvs_ordered,
2180: p_suggest_serial => fnd_api.g_true,
2181: p_simulation_mode => l_simulation_mode,
2182: p_simulation_id => l_simulation_id
2183: );
2184: ------------------------

Line 2650: -- INV_MO_ADMIN_PUB.cancel_line(1.0,'F','F',FND_API.G_VALID_LEVEL_FULL,c_rec.line_id,l_msg_count,l_msg_data,l_return_status);

2646:
2647: UPDATE wsh_delivery_details set move_order_line_id = NULL, released_status = 'R'
2648: WHERE move_order_line_id = c_rec.line_id;
2649:
2650: -- INV_MO_ADMIN_PUB.cancel_line(1.0,'F','F',FND_API.G_VALID_LEVEL_FULL,c_rec.line_id,l_msg_count,l_msg_data,l_return_status);
2651: END LOOP;
2652:
2653: DELETE FROM mtl_txn_request_lines
2654: WHERE organization_id = p_org_id