[Home] [Help]
994: IF pLower_Supplytype = 2 THEN
995:
996: IF PG_DEBUG <> 0 THEN
997: oe_debug_pub.add ('get_child_configurations: ' || 'Config children alone' ,1);
998: cto_wip_workflow_api_pk.cto_debug('get_child_configurations: ','Config children alone' );
999: END IF;
1000:
1001:
1002: OPEN c_config_items;
1195: ELSIF pLower_Supplytype = 3 THEN
1196:
1197:
1198: If PG_DEBUG <> 0 Then
1199: cto_wip_workflow_api_pk.cto_debug('get_child_configurations: ','Config and ato item children' );
1200: End if;
1201: OPEN c_config_and_ato_items;
1202:
1203: l_stmt_num := 70;
1604:
1605:
1606:
1607: IF PG_DEBUG <> 0 Then
1608: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','after process flow schedule');
1609: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','ietm index'|| pflow_sch_details(1).t_item_details_index);
1610: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','item_id '||l_x_flow_schedule_rec.primary_item_id );
1611: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','scheudle_number'|| pflow_sch_details(1).schedule_number);
1612: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','wipentity id'|| pflow_sch_details(1).wip_entity_id);
1605:
1606:
1607: IF PG_DEBUG <> 0 Then
1608: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','after process flow schedule');
1609: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','ietm index'|| pflow_sch_details(1).t_item_details_index);
1610: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','item_id '||l_x_flow_schedule_rec.primary_item_id );
1611: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','scheudle_number'|| pflow_sch_details(1).schedule_number);
1612: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','wipentity id'|| pflow_sch_details(1).wip_entity_id);
1613: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','schedule start date'||pflow_sch_details(1).scheduled_start_date );
1606:
1607: IF PG_DEBUG <> 0 Then
1608: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','after process flow schedule');
1609: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','ietm index'|| pflow_sch_details(1).t_item_details_index);
1610: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','item_id '||l_x_flow_schedule_rec.primary_item_id );
1611: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','scheudle_number'|| pflow_sch_details(1).schedule_number);
1612: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','wipentity id'|| pflow_sch_details(1).wip_entity_id);
1613: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','schedule start date'||pflow_sch_details(1).scheduled_start_date );
1614: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','planned qty'|| pflow_sch_details(1).planned_quantity);
1607: IF PG_DEBUG <> 0 Then
1608: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','after process flow schedule');
1609: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','ietm index'|| pflow_sch_details(1).t_item_details_index);
1610: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','item_id '||l_x_flow_schedule_rec.primary_item_id );
1611: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','scheudle_number'|| pflow_sch_details(1).schedule_number);
1612: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','wipentity id'|| pflow_sch_details(1).wip_entity_id);
1613: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','schedule start date'||pflow_sch_details(1).scheduled_start_date );
1614: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','planned qty'|| pflow_sch_details(1).planned_quantity);
1615: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','scheudle_completion_date'|| pflow_sch_details(1).scheduled_completion_date);
1608: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','after process flow schedule');
1609: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','ietm index'|| pflow_sch_details(1).t_item_details_index);
1610: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','item_id '||l_x_flow_schedule_rec.primary_item_id );
1611: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','scheudle_number'|| pflow_sch_details(1).schedule_number);
1612: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','wipentity id'|| pflow_sch_details(1).wip_entity_id);
1613: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','schedule start date'||pflow_sch_details(1).scheduled_start_date );
1614: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','planned qty'|| pflow_sch_details(1).planned_quantity);
1615: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','scheudle_completion_date'|| pflow_sch_details(1).scheduled_completion_date);
1616:
1609: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','ietm index'|| pflow_sch_details(1).t_item_details_index);
1610: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','item_id '||l_x_flow_schedule_rec.primary_item_id );
1611: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','scheudle_number'|| pflow_sch_details(1).schedule_number);
1612: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','wipentity id'|| pflow_sch_details(1).wip_entity_id);
1613: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','schedule start date'||pflow_sch_details(1).scheduled_start_date );
1614: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','planned qty'|| pflow_sch_details(1).planned_quantity);
1615: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','scheudle_completion_date'|| pflow_sch_details(1).scheduled_completion_date);
1616:
1617: End if;
1610: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','item_id '||l_x_flow_schedule_rec.primary_item_id );
1611: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','scheudle_number'|| pflow_sch_details(1).schedule_number);
1612: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','wipentity id'|| pflow_sch_details(1).wip_entity_id);
1613: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','schedule start date'||pflow_sch_details(1).scheduled_start_date );
1614: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','planned qty'|| pflow_sch_details(1).planned_quantity);
1615: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','scheudle_completion_date'|| pflow_sch_details(1).scheduled_completion_date);
1616:
1617: End if;
1618:
1611: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','scheudle_number'|| pflow_sch_details(1).schedule_number);
1612: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','wipentity id'|| pflow_sch_details(1).wip_entity_id);
1613: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','schedule start date'||pflow_sch_details(1).scheduled_start_date );
1614: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','planned qty'|| pflow_sch_details(1).planned_quantity);
1615: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','scheudle_completion_date'|| pflow_sch_details(1).scheduled_completion_date);
1616:
1617: End if;
1618:
1619:
1834: oe_debug_pub.add(' SUPPLY FOR ORDER NUMBER = ' || l_order_number || 'LINE_ID = ' || l_order_line_id ,1);
1835: oe_debug_pub.add('-----------------------------------------------------------------------------------------',1);
1836:
1837: --CTO DEBUG FILE
1838: cto_wip_workflow_api_pk.cto_debug ('get_mlsupply_details',' SUPPLY FOR ORDER NUMBER = ' || l_order_number || 'LINE_ID = ' || l_order_line_id );
1839: cto_wip_workflow_api_pk.cto_debug ('get_mlsupply_details','-----------------------------------------------------------------------------------------');
1840:
1841:
1842: oe_debug_pub.add('INDEX--'||'PARENT_INDEX--'||'ITEM_ID--'||'ITEM_NAME--'||'ITEM_QTY--'||'NEEDED_ITEM_QTY--'||
1835: oe_debug_pub.add('-----------------------------------------------------------------------------------------',1);
1836:
1837: --CTO DEBUG FILE
1838: cto_wip_workflow_api_pk.cto_debug ('get_mlsupply_details',' SUPPLY FOR ORDER NUMBER = ' || l_order_number || 'LINE_ID = ' || l_order_line_id );
1839: cto_wip_workflow_api_pk.cto_debug ('get_mlsupply_details','-----------------------------------------------------------------------------------------');
1840:
1841:
1842: oe_debug_pub.add('INDEX--'||'PARENT_INDEX--'||'ITEM_ID--'||'ITEM_NAME--'||'ITEM_QTY--'||'NEEDED_ITEM_QTY--'||
1843: 'CONFIG/ATO--'||'JOB_START_DATE--'||'JOB_COMPLETION_DATE--'||'SOURCED--'||'DISCREATE/FLOW/BUY--'||'COMMENTS',1);
1842: oe_debug_pub.add('INDEX--'||'PARENT_INDEX--'||'ITEM_ID--'||'ITEM_NAME--'||'ITEM_QTY--'||'NEEDED_ITEM_QTY--'||
1843: 'CONFIG/ATO--'||'JOB_START_DATE--'||'JOB_COMPLETION_DATE--'||'SOURCED--'||'DISCREATE/FLOW/BUY--'||'COMMENTS',1);
1844:
1845:
1846: cto_wip_workflow_api_pk.cto_debug ('get_mlsupply_details','INDEX--'||'PARENT_INDEX--'||'ITEM_ID--'||'ITEM_NAME--'||'ITEM_QTY--'||'NEEDED_ITEM_QTY--'||
1847: 'CONFIG/ATO--'||'JOB_START_DATE--'||'JOB_COMPLETION_DATE--'||'SOURCED--'||'DISCREATE/FLOW/BUY--'
1848: ||'COMMENTS');
1849: End if;
1850: OPEN c_supply_details;
1918: l_needed_item_qty||' -- '||l_config_ato||' -- '||to_char(l_job_st_date,'mm/dd/yyyy hh24:mi:ss')||' -- '||
1919: to_char(l_job_completion_date,'mm/dd/yyyy hh24:mi:ss')||' -- '||l_sourced||' --'||l_supply_type||' -- '||l_comments,1);
1920:
1921:
1922: cto_wip_workflow_api_pk.cto_debug ('get_mlsupply_details',l_item_index||' -- '||l_parent_index||' -- '||l_item_id||' -- '||l_item_name||' -- '||
1923: l_item_quantity||' -- '||l_needed_item_qty||' -- '||l_config_ato||' -- '||
1924: to_char(l_job_st_date,'mm/dd/yyyy hh24:mi:ss')||' -- '||to_char(l_job_completion_date,'mm/dd/yyyy hh24:mi:ss')||
1925: ' -- '||l_sourced||' --'||l_supply_type||' -- '||l_comments );
1926:
1931: OPEN c_flow_supply;
1932: If PG_DEBUG <> 0 Then
1933: oe_debug_pub.add('INDEX(from above)--'||'SCHEDULE_NUMBER--'||'SCHEDULE_START_DATE--'||'SCHEDULE_COMPLETION_DATE--'||'PARENT_SCHEDULE_NUM(if flow parent)',1);
1934:
1935: cto_wip_workflow_api_pk.cto_debug ('get_mlsupply_details','INDEX(from above)--'||'SCHEDULE_NUMBER--'||'SCHEDULE_START_DATE--'||'SCHEDULE_COMPLETION_DATE--'||'PARENT_SCHEDULE_NUM(if flow parent)');
1936:
1937: End if;
1938: LOOP
1939: FETCH c_flow_supply into l_item_index,
1947: oe_debug_pub.add(l_item_index||' -- '||l_schedule_number||' -- '||to_char(l_scheduled_start_date,'mm/dd/yyyy hh24:mi:ss')||' -- '||
1948: to_char(l_scheduled_completion_date,'mm/dd/yyyy hh24:mi:ss')||' -- '||l_synch_schedule_num,1);
1949:
1950:
1951: cto_wip_workflow_api_pk.cto_debug ('get_mlsupply_details',l_item_index||' -- '||l_schedule_number||' -- '||
1952: to_char(l_scheduled_start_date,'mm/dd/yyyy hh24:mi:ss')||' -- '||
1953: to_char(l_scheduled_completion_date,'mm/dd/yyyy hh24:mi:ss')||' -- '||l_synch_schedule_num );
1954:
1955: End if;
2115: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2116:
2117:
2118: If PG_DEBUG <> 0 Then
2119: cto_wip_workflow_api_pk.cto_debug('Create_sub_assembly_jobs','Inside create sub-assembly jobs');
2120: cto_wip_workflow_api_pk.cto_debug('Create_sub_assembly_jobs','FOR LINE ID '||p_Top_Assembly_LineId );
2121: End if;
2122:
2123: l_stmt_num := 140;
2116:
2117:
2118: If PG_DEBUG <> 0 Then
2119: cto_wip_workflow_api_pk.cto_debug('Create_sub_assembly_jobs','Inside create sub-assembly jobs');
2120: cto_wip_workflow_api_pk.cto_debug('Create_sub_assembly_jobs','FOR LINE ID '||p_Top_Assembly_LineId );
2121: End if;
2122:
2123: l_stmt_num := 140;
2124:
2185: l_mlsupply_items(1).processing_lead_time := l_processing_lead_time;
2186: l_mlsupply_items(1).job_completion_date := l_schedule_ship_date;
2187:
2188: If PG_DEBUG <> 0 Then
2189: cto_wip_workflow_api_pk.cto_debug('Create_sub_assembly_jobs','Entered top-most item details into table');
2190: End if;
2191:
2192: IF(l_cfm_routing_flag = 1) THEN --if top most parent = flow
2193:
2321: END IF; --top most parent details
2322:
2323: l_stmt_num := 190;
2324: If PG_DEBUG <> 0 Then
2325: cto_wip_workflow_api_pk.cto_debug('Create_sub_assembly_jobs','Before calling get_child_configurations' );
2326: End if;
2327: get_child_configurations
2328: (
2329: pParentItemId =>l_mlsupply_items(1).item_id,
2738: --flow schedule creation
2739:
2740: l_stmt_num := 210;
2741: If PG_DEBUG <> 0 Then
2742: cto_wip_workflow_api_pk.cto_debug ('create_sub_assembly_jobs','calling create flow schedule for'|| l_mlsupply_items(l_index).item_id);
2743:
2744: oe_debug_pub.add('create_subassembly_jobs: ' || 'calling create flow schedule for'|| l_mlsupply_items(l_index).item_id);
2745: END IF;
2746:
3161: --reomve this part at end of UT
3162: If PG_DEBUG <> 0 Then
3163: oe_debug_pub.add ('DEBUG EMSSAEG AFTER COMPLETION DATE CALCULATION',1);
3164:
3165: cto_wip_workflow_api_pk.cto_debug('Completion date debug messages','after completion date calculations');
3166: End if;
3167: --displaying children
3168: IF (l_mlsupply_items.count > 0) THEN --checks for uninitialized collection --bugfix2308063
3169:
3201: 'FLOW_END_IDX=>'||l_mlsupply_items(l_index).flow_end_index
3202: );
3203:
3204: If PG_DEBUG <> 0 Then
3205: cto_wip_workflow_api_pk.cto_debug ('Create_sub_assembly_jobs','idx=>'||l_mlsupply_items(l_index).t_item_details_index || '--' ||
3206: 'name=>'||l_mlsupply_items(l_index).item_name||'--' ||
3207: 'qty=>'||l_mlsupply_items(l_index).item_quantity||'--'||
3208: 'qty=>'||l_mlsupply_items(l_index).needed_item_qty||'--'||
3209: 'LT%=>'||l_mlsupply_items(l_index).OPERATION_LEAD_TIME_PERCENT||'--'||
3295:
3296: l_stmt_num := 260;
3297:
3298: If PG_DEBUG <> 0 Then
3299: cto_wip_workflow_api_pk.cto_debug ('create_sub_assembly_jobs','insert po_interafce'|| l_mlsupply_items(l_index).item_id);
3300: cto_wip_workflow_api_pk.cto_debug ('create_sub_assembly_jobs','need by date'|| to_char(l_mlsupply_items(l_index).job_completion_date,'mm/dd/yy/ hh:mi:ss'));
3301: cto_wip_workflow_api_pk.cto_debug ('create_sub_assembly_jobs','need aty'||l_mlsupply_items(l_index).needed_item_qty);
3302: End if;
3303:
3296: l_stmt_num := 260;
3297:
3298: If PG_DEBUG <> 0 Then
3299: cto_wip_workflow_api_pk.cto_debug ('create_sub_assembly_jobs','insert po_interafce'|| l_mlsupply_items(l_index).item_id);
3300: cto_wip_workflow_api_pk.cto_debug ('create_sub_assembly_jobs','need by date'|| to_char(l_mlsupply_items(l_index).job_completion_date,'mm/dd/yy/ hh:mi:ss'));
3301: cto_wip_workflow_api_pk.cto_debug ('create_sub_assembly_jobs','need aty'||l_mlsupply_items(l_index).needed_item_qty);
3302: End if;
3303:
3304: IF PG_DEBUG <> 0 THEN
3297:
3298: If PG_DEBUG <> 0 Then
3299: cto_wip_workflow_api_pk.cto_debug ('create_sub_assembly_jobs','insert po_interafce'|| l_mlsupply_items(l_index).item_id);
3300: cto_wip_workflow_api_pk.cto_debug ('create_sub_assembly_jobs','need by date'|| to_char(l_mlsupply_items(l_index).job_completion_date,'mm/dd/yy/ hh:mi:ss'));
3301: cto_wip_workflow_api_pk.cto_debug ('create_sub_assembly_jobs','need aty'||l_mlsupply_items(l_index).needed_item_qty);
3302: End if;
3303:
3304: IF PG_DEBUG <> 0 THEN
3305: oe_debug_pub.add('create_subassembly_jobs: ' || 'insert po_interafce'|| l_mlsupply_items(l_index).item_id);
3701: ROLLBACK TO REBUILD;
3702: else
3703: IF PG_DEBUG <> 0 THEN
3704: oe_debug_pub.add('create_subassembly_jobs: ' || 'REQUEST ID Inserted in WJSI for children : ' || l_requestId);
3705: cto_wip_workflow_api_pk.cto_debug ('Requets id is=> ', l_requestId);
3706:
3707: l_token(1).token_name := 'REQUEST_ID';
3708: l_token(1).token_value := l_requestId;
3709: