DBA Data[Home] [Help]

APPS.WSMPLBMI dependencies on WSMPWROT

Line 5363: -- call WSMPWROT.POPULATE_WRO only if move/jump within routing

5359:
5360: l_stmt_num := 535;
5361:
5362: -- BA: CZH.BUGFIX 2350705
5363: -- call WSMPWROT.POPULATE_WRO only if move/jump within routing
5364: if(l_op_seq_id IS NOT NULL) then
5365: -- EA: CZH.BUGFIX 2350705
5366: --move enh changed p_txn_qty to l_new_op_txn_qty
5367: WSMPWROT.POPULATE_WRO (

Line 5367: WSMPWROT.POPULATE_WRO (

5363: -- call WSMPWROT.POPULATE_WRO only if move/jump within routing
5364: if(l_op_seq_id IS NOT NULL) then
5365: -- EA: CZH.BUGFIX 2350705
5366: --move enh changed p_txn_qty to l_new_op_txn_qty
5367: WSMPWROT.POPULATE_WRO (
5368: p_first_flag => 0, --l_first_flag,
5369: p_wip_entity_id => l_wip_entity_id,
5370: p_organization_id => p_org_id,
5371: p_assembly_item_id => l_primary_item_id,

Line 5382: -- use the error message returned from WSMPWROT.POPULATE_WRO

5378: x_err_msg => x_err_buf);
5379:
5380: l_stmt_num := 540;
5381: IF (x_return_code <> 0) THEN
5382: -- use the error message returned from WSMPWROT.POPULATE_WRO
5383:
5384: fnd_file.put_line(fnd_file.log, 'WSMPLBMI.custom_validation(stmt_num='
5385: ||l_stmt_num||') calling WSMPWROT.POPULATE_WRO: '||x_err_buf);
5386: return(x_return_code);

Line 5385: ||l_stmt_num||') calling WSMPWROT.POPULATE_WRO: '||x_err_buf);

5381: IF (x_return_code <> 0) THEN
5382: -- use the error message returned from WSMPWROT.POPULATE_WRO
5383:
5384: fnd_file.put_line(fnd_file.log, 'WSMPLBMI.custom_validation(stmt_num='
5385: ||l_stmt_num||') calling WSMPWROT.POPULATE_WRO: '||x_err_buf);
5386: return(x_return_code);
5387: ELSE
5388: if (l_debug = 'Y') then
5389: fnd_file.put_line(fnd_file.log, 'WSMPLBMI.custom_validation(stmt_num='||l_stmt_num

Line 5390: ||'): Returned success from WSMPWROT.POPULATE_WRO');

5386: return(x_return_code);
5387: ELSE
5388: if (l_debug = 'Y') then
5389: fnd_file.put_line(fnd_file.log, 'WSMPLBMI.custom_validation(stmt_num='||l_stmt_num
5390: ||'): Returned success from WSMPWROT.POPULATE_WRO');
5391: end if;
5392: END IF;
5393: -- BA: CZH.BUGFIX 2350705
5394: end if; -- if(l_op_seq_id IS NOT NULL)

Line 11125: x_group_id := WSMPWROT.GET_EXPLOSION_GROUP_ID;

11121: l_stmt_num := 330;
11122: DECLARE
11123: x_group_id NUMBER;
11124: BEGIN
11125: x_group_id := WSMPWROT.GET_EXPLOSION_GROUP_ID;
11126: DELETE from BOM_EXPLOSION_TEMP
11127: WHERE group_id = x_group_id;
11128:
11129: WSMPWROT.SET_EXPLOSION_GROUP_ID_NULL;

Line 11129: WSMPWROT.SET_EXPLOSION_GROUP_ID_NULL;

11125: x_group_id := WSMPWROT.GET_EXPLOSION_GROUP_ID;
11126: DELETE from BOM_EXPLOSION_TEMP
11127: WHERE group_id = x_group_id;
11128:
11129: WSMPWROT.SET_EXPLOSION_GROUP_ID_NULL;
11130: COMMIT;
11131: END;
11132: END IF;
11133: