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.

[Home] [Help]

APPS.CSD_HV_WIP_JOB_PVT dependencies on WIP_MOVE_TXN_INTERFACE

Line 1263: p_wip_move_txn_interface_rec IN wip_move_txn_interface%ROWTYPE,

1259:
1260:
1261: PROCEDURE insert_wip_move_txn
1262: (
1263: p_wip_move_txn_interface_rec IN wip_move_txn_interface%ROWTYPE,
1264: x_return_status OUT NOCOPY VARCHAR2
1265: )
1266: IS
1267:

Line 1325: --insert into table wip_move_txn_interface

1321: l_last_update_login := fnd_global.login_id;
1322:
1323:
1324:
1325: --insert into table wip_move_txn_interface
1326: BEGIN
1327: insert into wip_move_txn_interface(
1328: transaction_id,
1329: last_update_date,

Line 1327: insert into wip_move_txn_interface(

1323:
1324:
1325: --insert into table wip_move_txn_interface
1326: BEGIN
1327: insert into wip_move_txn_interface(
1328: transaction_id,
1329: last_update_date,
1330: last_updated_by,
1331: last_updated_by_name,

Line 1348: p_wip_move_txn_interface_rec.transaction_id,

1344: to_intraoperation_step_type,
1345: transaction_quantity,
1346: transaction_uom
1347: ) values (
1348: p_wip_move_txn_interface_rec.transaction_id,
1349: l_last_update_date, /* last_update_date */
1350: l_last_updated_by, /* last_updated_by */
1351: l_last_updated_by_name, /* last_updated_by_name */
1352: l_creation_date, /* creation_date */

Line 1355: p_wip_move_txn_interface_rec.group_id, /* group_id */

1351: l_last_updated_by_name, /* last_updated_by_name */
1352: l_creation_date, /* creation_date */
1353: l_created_by, /* created_by */
1354: l_created_by_name, /* created_by_name */
1355: p_wip_move_txn_interface_rec.group_id, /* group_id */
1356: l_process_phase, /* process phase */
1357: l_process_status, /* process status */
1358: p_wip_move_txn_interface_rec.organization_id,
1359: p_wip_move_txn_interface_rec.wip_entity_name,

Line 1358: p_wip_move_txn_interface_rec.organization_id,

1354: l_created_by_name, /* created_by_name */
1355: p_wip_move_txn_interface_rec.group_id, /* group_id */
1356: l_process_phase, /* process phase */
1357: l_process_status, /* process status */
1358: p_wip_move_txn_interface_rec.organization_id,
1359: p_wip_move_txn_interface_rec.wip_entity_name,
1360: p_wip_move_txn_interface_rec.transaction_date,
1361: p_wip_move_txn_interface_rec.fm_operation_seq_num,
1362: p_wip_move_txn_interface_rec.fm_intraoperation_step_type,

Line 1359: p_wip_move_txn_interface_rec.wip_entity_name,

1355: p_wip_move_txn_interface_rec.group_id, /* group_id */
1356: l_process_phase, /* process phase */
1357: l_process_status, /* process status */
1358: p_wip_move_txn_interface_rec.organization_id,
1359: p_wip_move_txn_interface_rec.wip_entity_name,
1360: p_wip_move_txn_interface_rec.transaction_date,
1361: p_wip_move_txn_interface_rec.fm_operation_seq_num,
1362: p_wip_move_txn_interface_rec.fm_intraoperation_step_type,
1363: p_wip_move_txn_interface_rec.to_operation_seq_num,

Line 1360: p_wip_move_txn_interface_rec.transaction_date,

1356: l_process_phase, /* process phase */
1357: l_process_status, /* process status */
1358: p_wip_move_txn_interface_rec.organization_id,
1359: p_wip_move_txn_interface_rec.wip_entity_name,
1360: p_wip_move_txn_interface_rec.transaction_date,
1361: p_wip_move_txn_interface_rec.fm_operation_seq_num,
1362: p_wip_move_txn_interface_rec.fm_intraoperation_step_type,
1363: p_wip_move_txn_interface_rec.to_operation_seq_num,
1364: p_wip_move_txn_interface_rec.to_intraoperation_step_type,

Line 1361: p_wip_move_txn_interface_rec.fm_operation_seq_num,

1357: l_process_status, /* process status */
1358: p_wip_move_txn_interface_rec.organization_id,
1359: p_wip_move_txn_interface_rec.wip_entity_name,
1360: p_wip_move_txn_interface_rec.transaction_date,
1361: p_wip_move_txn_interface_rec.fm_operation_seq_num,
1362: p_wip_move_txn_interface_rec.fm_intraoperation_step_type,
1363: p_wip_move_txn_interface_rec.to_operation_seq_num,
1364: p_wip_move_txn_interface_rec.to_intraoperation_step_type,
1365: p_wip_move_txn_interface_rec.transaction_quantity,

Line 1362: p_wip_move_txn_interface_rec.fm_intraoperation_step_type,

1358: p_wip_move_txn_interface_rec.organization_id,
1359: p_wip_move_txn_interface_rec.wip_entity_name,
1360: p_wip_move_txn_interface_rec.transaction_date,
1361: p_wip_move_txn_interface_rec.fm_operation_seq_num,
1362: p_wip_move_txn_interface_rec.fm_intraoperation_step_type,
1363: p_wip_move_txn_interface_rec.to_operation_seq_num,
1364: p_wip_move_txn_interface_rec.to_intraoperation_step_type,
1365: p_wip_move_txn_interface_rec.transaction_quantity,
1366: p_wip_move_txn_interface_rec.transaction_uom

Line 1363: p_wip_move_txn_interface_rec.to_operation_seq_num,

1359: p_wip_move_txn_interface_rec.wip_entity_name,
1360: p_wip_move_txn_interface_rec.transaction_date,
1361: p_wip_move_txn_interface_rec.fm_operation_seq_num,
1362: p_wip_move_txn_interface_rec.fm_intraoperation_step_type,
1363: p_wip_move_txn_interface_rec.to_operation_seq_num,
1364: p_wip_move_txn_interface_rec.to_intraoperation_step_type,
1365: p_wip_move_txn_interface_rec.transaction_quantity,
1366: p_wip_move_txn_interface_rec.transaction_uom
1367: );

Line 1364: p_wip_move_txn_interface_rec.to_intraoperation_step_type,

1360: p_wip_move_txn_interface_rec.transaction_date,
1361: p_wip_move_txn_interface_rec.fm_operation_seq_num,
1362: p_wip_move_txn_interface_rec.fm_intraoperation_step_type,
1363: p_wip_move_txn_interface_rec.to_operation_seq_num,
1364: p_wip_move_txn_interface_rec.to_intraoperation_step_type,
1365: p_wip_move_txn_interface_rec.transaction_quantity,
1366: p_wip_move_txn_interface_rec.transaction_uom
1367: );
1368:

Line 1365: p_wip_move_txn_interface_rec.transaction_quantity,

1361: p_wip_move_txn_interface_rec.fm_operation_seq_num,
1362: p_wip_move_txn_interface_rec.fm_intraoperation_step_type,
1363: p_wip_move_txn_interface_rec.to_operation_seq_num,
1364: p_wip_move_txn_interface_rec.to_intraoperation_step_type,
1365: p_wip_move_txn_interface_rec.transaction_quantity,
1366: p_wip_move_txn_interface_rec.transaction_uom
1367: );
1368:
1369:

Line 1366: p_wip_move_txn_interface_rec.transaction_uom

1362: p_wip_move_txn_interface_rec.fm_intraoperation_step_type,
1363: p_wip_move_txn_interface_rec.to_operation_seq_num,
1364: p_wip_move_txn_interface_rec.to_intraoperation_step_type,
1365: p_wip_move_txn_interface_rec.transaction_quantity,
1366: p_wip_move_txn_interface_rec.transaction_uom
1367: );
1368:
1369:
1370: EXCEPTION

Line 2146: -- Constants used for inserting into wip_move_txn_interface

2142: -- lc_validation_phase CONSTANT NUMBER := 1;
2143:
2144:
2145:
2146: -- Constants used for inserting into wip_move_txn_interface
2147:
2148: lc_queue CONSTANT NUMBER := 1;
2149: lc_to_move CONSTANT NUMBER := 3;
2150: lc_error_process_status CONSTANT NUMBER := 3;

Line 2153: -- Record to hold wip_move_txn_interface

2149: lc_to_move CONSTANT NUMBER := 3;
2150: lc_error_process_status CONSTANT NUMBER := 3;
2151:
2152:
2153: -- Record to hold wip_move_txn_interface
2154:
2155: l_wip_move_txn_interface_rec wip_move_txn_interface%ROWTYPE;
2156:
2157:

Line 2155: l_wip_move_txn_interface_rec wip_move_txn_interface%ROWTYPE;

2151:
2152:
2153: -- Record to hold wip_move_txn_interface
2154:
2155: l_wip_move_txn_interface_rec wip_move_txn_interface%ROWTYPE;
2156:
2157:
2158: /* l_process_phase NUMBER;
2159: l_material_transaction_id NUMBER; */

Line 2177: select 'exists' from wip_move_txn_interface where

2173: SELECT wip_transactions_s.nextval from dual;
2174:
2175:
2176: Cursor check_mv_interface_errors ( c_group_id NUMBER ) IS
2177: select 'exists' from wip_move_txn_interface where
2178: group_id = c_group_id
2179: and process_status = lc_error_process_status;
2180:
2181: -- swai: bug 5330060

Line 2240: -- fetch get_transaction_id into l_wip_move_txn_interface_rec.transaction_id;

2236:
2237:
2238: -- generate transaction_id
2239: open get_transaction_id;
2240: -- fetch get_transaction_id into l_wip_move_txn_interface_rec.transaction_id;
2241: fetch get_transaction_id into l_wip_move_txn_interface_rec.group_id;
2242: close get_transaction_id;
2243:
2244: -- l_wip_move_txn_interface_rec.group_id := l_wip_move_txn_interface_rec.transaction_id;

Line 2241: fetch get_transaction_id into l_wip_move_txn_interface_rec.group_id;

2237:
2238: -- generate transaction_id
2239: open get_transaction_id;
2240: -- fetch get_transaction_id into l_wip_move_txn_interface_rec.transaction_id;
2241: fetch get_transaction_id into l_wip_move_txn_interface_rec.group_id;
2242: close get_transaction_id;
2243:
2244: -- l_wip_move_txn_interface_rec.group_id := l_wip_move_txn_interface_rec.transaction_id;
2245: l_wip_move_txn_interface_rec.transaction_date := sysdate;

Line 2244: -- l_wip_move_txn_interface_rec.group_id := l_wip_move_txn_interface_rec.transaction_id;

2240: -- fetch get_transaction_id into l_wip_move_txn_interface_rec.transaction_id;
2241: fetch get_transaction_id into l_wip_move_txn_interface_rec.group_id;
2242: close get_transaction_id;
2243:
2244: -- l_wip_move_txn_interface_rec.group_id := l_wip_move_txn_interface_rec.transaction_id;
2245: l_wip_move_txn_interface_rec.transaction_date := sysdate;
2246: l_wip_move_txn_interface_rec.fm_intraoperation_step_type := lc_queue;
2247:
2248:

Line 2245: l_wip_move_txn_interface_rec.transaction_date := sysdate;

2241: fetch get_transaction_id into l_wip_move_txn_interface_rec.group_id;
2242: close get_transaction_id;
2243:
2244: -- l_wip_move_txn_interface_rec.group_id := l_wip_move_txn_interface_rec.transaction_id;
2245: l_wip_move_txn_interface_rec.transaction_date := sysdate;
2246: l_wip_move_txn_interface_rec.fm_intraoperation_step_type := lc_queue;
2247:
2248:
2249: -- swai: bug 5330060

Line 2246: l_wip_move_txn_interface_rec.fm_intraoperation_step_type := lc_queue;

2242: close get_transaction_id;
2243:
2244: -- l_wip_move_txn_interface_rec.group_id := l_wip_move_txn_interface_rec.transaction_id;
2245: l_wip_move_txn_interface_rec.transaction_date := sysdate;
2246: l_wip_move_txn_interface_rec.fm_intraoperation_step_type := lc_queue;
2247:
2248:
2249: -- swai: bug 5330060
2250: -- updated logic within for loop

Line 2254: l_wip_move_txn_interface_rec.organization_id := p_mv_txn_dtls_tbl(mv_ctr).organization_id;

2250: -- updated logic within for loop
2251: FOR mv_ctr in p_mv_txn_dtls_tbl.FIRST.. p_mv_txn_dtls_tbl.LAST
2252: LOOP
2253:
2254: l_wip_move_txn_interface_rec.organization_id := p_mv_txn_dtls_tbl(mv_ctr).organization_id;
2255: l_wip_move_txn_interface_rec.wip_entity_name := p_mv_txn_dtls_tbl(mv_ctr).wip_entity_name;
2256: l_wip_move_txn_interface_rec.transaction_uom := p_mv_txn_dtls_tbl(mv_ctr).transaction_uom;
2257: l_wip_move_txn_interface_rec.to_operation_seq_num := nvl(p_mv_txn_dtls_tbl(mv_ctr).to_operation_seq_num,
2258: p_mv_txn_dtls_tbl(mv_ctr).fm_operation_seq_num ) ;

Line 2255: l_wip_move_txn_interface_rec.wip_entity_name := p_mv_txn_dtls_tbl(mv_ctr).wip_entity_name;

2251: FOR mv_ctr in p_mv_txn_dtls_tbl.FIRST.. p_mv_txn_dtls_tbl.LAST
2252: LOOP
2253:
2254: l_wip_move_txn_interface_rec.organization_id := p_mv_txn_dtls_tbl(mv_ctr).organization_id;
2255: l_wip_move_txn_interface_rec.wip_entity_name := p_mv_txn_dtls_tbl(mv_ctr).wip_entity_name;
2256: l_wip_move_txn_interface_rec.transaction_uom := p_mv_txn_dtls_tbl(mv_ctr).transaction_uom;
2257: l_wip_move_txn_interface_rec.to_operation_seq_num := nvl(p_mv_txn_dtls_tbl(mv_ctr).to_operation_seq_num,
2258: p_mv_txn_dtls_tbl(mv_ctr).fm_operation_seq_num ) ;
2259: -- if the to operation seq is 0, then it's the last operation,

Line 2256: l_wip_move_txn_interface_rec.transaction_uom := p_mv_txn_dtls_tbl(mv_ctr).transaction_uom;

2252: LOOP
2253:
2254: l_wip_move_txn_interface_rec.organization_id := p_mv_txn_dtls_tbl(mv_ctr).organization_id;
2255: l_wip_move_txn_interface_rec.wip_entity_name := p_mv_txn_dtls_tbl(mv_ctr).wip_entity_name;
2256: l_wip_move_txn_interface_rec.transaction_uom := p_mv_txn_dtls_tbl(mv_ctr).transaction_uom;
2257: l_wip_move_txn_interface_rec.to_operation_seq_num := nvl(p_mv_txn_dtls_tbl(mv_ctr).to_operation_seq_num,
2258: p_mv_txn_dtls_tbl(mv_ctr).fm_operation_seq_num ) ;
2259: -- if the to operation seq is 0, then it's the last operation,
2260: -- make sure the to step type is to_move, otherwise, it's in queue.

Line 2257: l_wip_move_txn_interface_rec.to_operation_seq_num := nvl(p_mv_txn_dtls_tbl(mv_ctr).to_operation_seq_num,

2253:
2254: l_wip_move_txn_interface_rec.organization_id := p_mv_txn_dtls_tbl(mv_ctr).organization_id;
2255: l_wip_move_txn_interface_rec.wip_entity_name := p_mv_txn_dtls_tbl(mv_ctr).wip_entity_name;
2256: l_wip_move_txn_interface_rec.transaction_uom := p_mv_txn_dtls_tbl(mv_ctr).transaction_uom;
2257: l_wip_move_txn_interface_rec.to_operation_seq_num := nvl(p_mv_txn_dtls_tbl(mv_ctr).to_operation_seq_num,
2258: p_mv_txn_dtls_tbl(mv_ctr).fm_operation_seq_num ) ;
2259: -- if the to operation seq is 0, then it's the last operation,
2260: -- make sure the to step type is to_move, otherwise, it's in queue.
2261: if (p_mv_txn_dtls_tbl(mv_ctr).to_operation_seq_num is null) then

Line 2262: l_wip_move_txn_interface_rec.to_intraoperation_step_type := lc_to_move;

2258: p_mv_txn_dtls_tbl(mv_ctr).fm_operation_seq_num ) ;
2259: -- if the to operation seq is 0, then it's the last operation,
2260: -- make sure the to step type is to_move, otherwise, it's in queue.
2261: if (p_mv_txn_dtls_tbl(mv_ctr).to_operation_seq_num is null) then
2262: l_wip_move_txn_interface_rec.to_intraoperation_step_type := lc_to_move;
2263: else
2264: l_wip_move_txn_interface_rec.to_intraoperation_step_type := lc_queue;
2265: end if;
2266:

Line 2264: l_wip_move_txn_interface_rec.to_intraoperation_step_type := lc_queue;

2260: -- make sure the to step type is to_move, otherwise, it's in queue.
2261: if (p_mv_txn_dtls_tbl(mv_ctr).to_operation_seq_num is null) then
2262: l_wip_move_txn_interface_rec.to_intraoperation_step_type := lc_to_move;
2263: else
2264: l_wip_move_txn_interface_rec.to_intraoperation_step_type := lc_queue;
2265: end if;
2266:
2267: -- if we are completing more than one operation for the same job, make
2268: -- the quantities are passed forward. Currently, do not allow the user

Line 2276: l_wip_move_txn_interface_rec.transaction_quantity := p_mv_txn_dtls_tbl(mv_ctr).transaction_quantity +

2272: FND_MESSAGE.SET_NAME('CSD','CSD_OP_COMP_SEQ_ERROR');
2273: FND_MSG_PUB.ADD;
2274: RAISE FND_API.G_EXC_ERROR;
2275: ELSE
2276: l_wip_move_txn_interface_rec.transaction_quantity := p_mv_txn_dtls_tbl(mv_ctr).transaction_quantity +
2277: l_prev_transaction_quantity;
2278: END IF;
2279: ELSE
2280: l_wip_move_txn_interface_rec.transaction_quantity := p_mv_txn_dtls_tbl(mv_ctr).transaction_quantity;

Line 2280: l_wip_move_txn_interface_rec.transaction_quantity := p_mv_txn_dtls_tbl(mv_ctr).transaction_quantity;

2276: l_wip_move_txn_interface_rec.transaction_quantity := p_mv_txn_dtls_tbl(mv_ctr).transaction_quantity +
2277: l_prev_transaction_quantity;
2278: END IF;
2279: ELSE
2280: l_wip_move_txn_interface_rec.transaction_quantity := p_mv_txn_dtls_tbl(mv_ctr).transaction_quantity;
2281: END IF;
2282:
2283: -- use the values passed in if there are items to be transacted. Otherwise,
2284: -- we will attempt to find the appropriate from operation with an item that

Line 2286: IF (l_wip_move_txn_interface_rec.transaction_quantity > 0) then

2282:
2283: -- use the values passed in if there are items to be transacted. Otherwise,
2284: -- we will attempt to find the appropriate from operation with an item that
2285: -- can be moved
2286: IF (l_wip_move_txn_interface_rec.transaction_quantity > 0) then
2287: l_wip_move_txn_interface_rec.fm_operation_seq_num := p_mv_txn_dtls_tbl(mv_ctr).fm_operation_seq_num;
2288: ELSE
2289: -- find the operation with a qty to complete, set the from operation to this
2290: open get_valid_previous_op (p_mv_txn_dtls_tbl(mv_ctr).wip_entity_id,

Line 2287: l_wip_move_txn_interface_rec.fm_operation_seq_num := p_mv_txn_dtls_tbl(mv_ctr).fm_operation_seq_num;

2283: -- use the values passed in if there are items to be transacted. Otherwise,
2284: -- we will attempt to find the appropriate from operation with an item that
2285: -- can be moved
2286: IF (l_wip_move_txn_interface_rec.transaction_quantity > 0) then
2287: l_wip_move_txn_interface_rec.fm_operation_seq_num := p_mv_txn_dtls_tbl(mv_ctr).fm_operation_seq_num;
2288: ELSE
2289: -- find the operation with a qty to complete, set the from operation to this
2290: open get_valid_previous_op (p_mv_txn_dtls_tbl(mv_ctr).wip_entity_id,
2291: p_mv_txn_dtls_tbl(mv_ctr).fm_operation_seq_num);

Line 2293: l_wip_move_txn_interface_rec.fm_operation_seq_num,

2289: -- find the operation with a qty to complete, set the from operation to this
2290: open get_valid_previous_op (p_mv_txn_dtls_tbl(mv_ctr).wip_entity_id,
2291: p_mv_txn_dtls_tbl(mv_ctr).fm_operation_seq_num);
2292: fetch get_valid_previous_op into
2293: l_wip_move_txn_interface_rec.fm_operation_seq_num,
2294: l_qty_in_queue,
2295: l_qty_to_move;
2296: close get_valid_previous_op;
2297:

Line 2300: l_wip_move_txn_interface_rec.fm_intraoperation_step_type := lc_queue;

2296: close get_valid_previous_op;
2297:
2298: -- depending on where the item is, set the qty and from step type accordingly.
2299: if l_qty_in_queue > 0 then
2300: l_wip_move_txn_interface_rec.fm_intraoperation_step_type := lc_queue;
2301: l_wip_move_txn_interface_rec.transaction_quantity := l_qty_in_queue;
2302: elsif (l_qty_to_move > 0) then
2303: l_wip_move_txn_interface_rec.fm_intraoperation_step_type := lc_to_move;
2304: l_wip_move_txn_interface_rec.transaction_quantity := l_qty_to_move;

Line 2301: l_wip_move_txn_interface_rec.transaction_quantity := l_qty_in_queue;

2297:
2298: -- depending on where the item is, set the qty and from step type accordingly.
2299: if l_qty_in_queue > 0 then
2300: l_wip_move_txn_interface_rec.fm_intraoperation_step_type := lc_queue;
2301: l_wip_move_txn_interface_rec.transaction_quantity := l_qty_in_queue;
2302: elsif (l_qty_to_move > 0) then
2303: l_wip_move_txn_interface_rec.fm_intraoperation_step_type := lc_to_move;
2304: l_wip_move_txn_interface_rec.transaction_quantity := l_qty_to_move;
2305: end if;

Line 2303: l_wip_move_txn_interface_rec.fm_intraoperation_step_type := lc_to_move;

2299: if l_qty_in_queue > 0 then
2300: l_wip_move_txn_interface_rec.fm_intraoperation_step_type := lc_queue;
2301: l_wip_move_txn_interface_rec.transaction_quantity := l_qty_in_queue;
2302: elsif (l_qty_to_move > 0) then
2303: l_wip_move_txn_interface_rec.fm_intraoperation_step_type := lc_to_move;
2304: l_wip_move_txn_interface_rec.transaction_quantity := l_qty_to_move;
2305: end if;
2306: END IF;
2307:

Line 2304: l_wip_move_txn_interface_rec.transaction_quantity := l_qty_to_move;

2300: l_wip_move_txn_interface_rec.fm_intraoperation_step_type := lc_queue;
2301: l_wip_move_txn_interface_rec.transaction_quantity := l_qty_in_queue;
2302: elsif (l_qty_to_move > 0) then
2303: l_wip_move_txn_interface_rec.fm_intraoperation_step_type := lc_to_move;
2304: l_wip_move_txn_interface_rec.transaction_quantity := l_qty_to_move;
2305: end if;
2306: END IF;
2307:
2308: -- set the variables to compare in the next loop iteration

Line 2310: l_prev_to_operation_seq_num := l_wip_move_txn_interface_rec.to_operation_seq_num;

2306: END IF;
2307:
2308: -- set the variables to compare in the next loop iteration
2309: l_prev_wip_entity_id := p_mv_txn_dtls_tbl(mv_ctr).wip_entity_id;
2310: l_prev_to_operation_seq_num := l_wip_move_txn_interface_rec.to_operation_seq_num;
2311: l_prev_transaction_quantity := l_wip_move_txn_interface_rec.transaction_quantity;
2312:
2313: --insert into table wip_move_txn_interface
2314: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 2311: l_prev_transaction_quantity := l_wip_move_txn_interface_rec.transaction_quantity;

2307:
2308: -- set the variables to compare in the next loop iteration
2309: l_prev_wip_entity_id := p_mv_txn_dtls_tbl(mv_ctr).wip_entity_id;
2310: l_prev_to_operation_seq_num := l_wip_move_txn_interface_rec.to_operation_seq_num;
2311: l_prev_transaction_quantity := l_wip_move_txn_interface_rec.transaction_quantity;
2312:
2313: --insert into table wip_move_txn_interface
2314: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2315: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,

Line 2313: --insert into table wip_move_txn_interface

2309: l_prev_wip_entity_id := p_mv_txn_dtls_tbl(mv_ctr).wip_entity_id;
2310: l_prev_to_operation_seq_num := l_wip_move_txn_interface_rec.to_operation_seq_num;
2311: l_prev_transaction_quantity := l_wip_move_txn_interface_rec.transaction_quantity;
2312:
2313: --insert into table wip_move_txn_interface
2314: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2315: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
2316: lc_mod_name||'beforecallinsertwipmvtxn',
2317: 'Just before calling insert_wip_move_txn');

Line 2320: insert_wip_move_txn( p_wip_move_txn_interface_rec => l_wip_move_txn_interface_rec,

2316: lc_mod_name||'beforecallinsertwipmvtxn',
2317: 'Just before calling insert_wip_move_txn');
2318: END IF;
2319:
2320: insert_wip_move_txn( p_wip_move_txn_interface_rec => l_wip_move_txn_interface_rec,
2321: x_return_status => x_return_status );
2322:
2323: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2343: wip_movProc_grp.processInterface(p_movTxnID => l_wip_move_txn_interface_rec.transaction_id,

2339: 'Just before calling INV_TXN_MANAGER_PUB.process_Transactions');
2340: END IF;
2341:
2342: /*
2343: wip_movProc_grp.processInterface(p_movTxnID => l_wip_move_txn_interface_rec.transaction_id,
2344: p_procPhase => l_process_phase,
2345: p_txnHdrID => l_material_transaction_id,
2346: p_mtlMode => WIP_CONSTANTS.ONLINE,
2347: p_cplTxnID => NULL,

Line 2354: wip_movProc_grp.processInterface(p_groupID => l_wip_move_txn_interface_rec.group_id,

2350: x_errorMsg => x_msg_data);
2351:
2352: */
2353:
2354: wip_movProc_grp.processInterface(p_groupID => l_wip_move_txn_interface_rec.group_id,
2355: p_commit => FND_API.G_FALSE,
2356: x_returnStatus => x_return_status ) ;
2357:
2358: -- Need to get errors from error table and pass it back

Line 2361: open check_mv_interface_errors ( l_wip_move_txn_interface_rec.group_id );

2357:
2358: -- Need to get errors from error table and pass it back
2359:
2360:
2361: open check_mv_interface_errors ( l_wip_move_txn_interface_rec.group_id );
2362: fetch check_mv_interface_errors into l_error_exists;
2363: close check_mv_interface_errors ;
2364:
2365: