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.CTO_SUBASSEMBLY_SUP_PK dependencies on CTO_WIP_WORKFLOW_API_PK

Line 1009: cto_wip_workflow_api_pk.cto_debug('get_child_configurations: ','Config children alone' );

1005: oe_debug_pub.add ('get_child_configurations: ' || 'Config children alone' ,1);
1006: --Bugfix 8913125: Added these messages.
1007: oe_debug_pub.add ('get_child_configurations: Parent Item:' || pParentItemId, 1);
1008: oe_debug_pub.add ('get_child_configurations: Org:' || pOrganization_id ,1);
1009: cto_wip_workflow_api_pk.cto_debug('get_child_configurations: ','Config children alone' );
1010: END IF;
1011:
1012:
1013: OPEN c_config_items;

Line 1218: cto_wip_workflow_api_pk.cto_debug('get_child_configurations: ','Config and ato item children' );

1214: ELSIF pLower_Supplytype = 3 THEN
1215:
1216:
1217: If PG_DEBUG <> 0 Then
1218: cto_wip_workflow_api_pk.cto_debug('get_child_configurations: ','Config and ato item children' );
1219: --Bugfix 8913125: Added these messages.
1220: oe_debug_pub.add ('get_child_configurations: Config and ato item children', 1);
1221: oe_debug_pub.add ('get_child_configurations: Parent Item:' || pParentItemId, 1);
1222: oe_debug_pub.add ('get_child_configurations: Org:' || pOrganization_id ,1);

Line 1646: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','after process flow schedule');

1642:
1643:
1644:
1645: IF PG_DEBUG <> 0 Then
1646: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','after process flow schedule');
1647: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','ietm index'|| pflow_sch_details(1).t_item_details_index);
1648: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','item_id '||l_x_flow_schedule_rec.primary_item_id );
1649: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','scheudle_number'|| pflow_sch_details(1).schedule_number);
1650: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','wipentity id'|| pflow_sch_details(1).wip_entity_id);

Line 1647: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','ietm index'|| pflow_sch_details(1).t_item_details_index);

1643:
1644:
1645: IF PG_DEBUG <> 0 Then
1646: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','after process flow schedule');
1647: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','ietm index'|| pflow_sch_details(1).t_item_details_index);
1648: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','item_id '||l_x_flow_schedule_rec.primary_item_id );
1649: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','scheudle_number'|| pflow_sch_details(1).schedule_number);
1650: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','wipentity id'|| pflow_sch_details(1).wip_entity_id);
1651: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','schedule start date'||pflow_sch_details(1).scheduled_start_date );

Line 1648: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','item_id '||l_x_flow_schedule_rec.primary_item_id );

1644:
1645: IF PG_DEBUG <> 0 Then
1646: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','after process flow schedule');
1647: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','ietm index'|| pflow_sch_details(1).t_item_details_index);
1648: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','item_id '||l_x_flow_schedule_rec.primary_item_id );
1649: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','scheudle_number'|| pflow_sch_details(1).schedule_number);
1650: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','wipentity id'|| pflow_sch_details(1).wip_entity_id);
1651: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','schedule start date'||pflow_sch_details(1).scheduled_start_date );
1652: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','planned qty'|| pflow_sch_details(1).planned_quantity);

Line 1649: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','scheudle_number'|| pflow_sch_details(1).schedule_number);

1645: IF PG_DEBUG <> 0 Then
1646: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','after process flow schedule');
1647: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','ietm index'|| pflow_sch_details(1).t_item_details_index);
1648: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','item_id '||l_x_flow_schedule_rec.primary_item_id );
1649: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','scheudle_number'|| pflow_sch_details(1).schedule_number);
1650: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','wipentity id'|| pflow_sch_details(1).wip_entity_id);
1651: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','schedule start date'||pflow_sch_details(1).scheduled_start_date );
1652: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','planned qty'|| pflow_sch_details(1).planned_quantity);
1653: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','scheudle_completion_date'|| pflow_sch_details(1).scheduled_completion_date);

Line 1650: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','wipentity id'|| pflow_sch_details(1).wip_entity_id);

1646: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','after process flow schedule');
1647: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','ietm index'|| pflow_sch_details(1).t_item_details_index);
1648: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','item_id '||l_x_flow_schedule_rec.primary_item_id );
1649: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','scheudle_number'|| pflow_sch_details(1).schedule_number);
1650: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','wipentity id'|| pflow_sch_details(1).wip_entity_id);
1651: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','schedule start date'||pflow_sch_details(1).scheduled_start_date );
1652: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','planned qty'|| pflow_sch_details(1).planned_quantity);
1653: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','scheudle_completion_date'|| pflow_sch_details(1).scheduled_completion_date);
1654:

Line 1651: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','schedule start date'||pflow_sch_details(1).scheduled_start_date );

1647: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','ietm index'|| pflow_sch_details(1).t_item_details_index);
1648: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','item_id '||l_x_flow_schedule_rec.primary_item_id );
1649: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','scheudle_number'|| pflow_sch_details(1).schedule_number);
1650: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','wipentity id'|| pflow_sch_details(1).wip_entity_id);
1651: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','schedule start date'||pflow_sch_details(1).scheduled_start_date );
1652: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','planned qty'|| pflow_sch_details(1).planned_quantity);
1653: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','scheudle_completion_date'|| pflow_sch_details(1).scheduled_completion_date);
1654:
1655: End if;

Line 1652: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','planned qty'|| pflow_sch_details(1).planned_quantity);

1648: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','item_id '||l_x_flow_schedule_rec.primary_item_id );
1649: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','scheudle_number'|| pflow_sch_details(1).schedule_number);
1650: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','wipentity id'|| pflow_sch_details(1).wip_entity_id);
1651: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','schedule start date'||pflow_sch_details(1).scheduled_start_date );
1652: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','planned qty'|| pflow_sch_details(1).planned_quantity);
1653: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','scheudle_completion_date'|| pflow_sch_details(1).scheduled_completion_date);
1654:
1655: End if;
1656:

Line 1653: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','scheudle_completion_date'|| pflow_sch_details(1).scheduled_completion_date);

1649: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','scheudle_number'|| pflow_sch_details(1).schedule_number);
1650: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','wipentity id'|| pflow_sch_details(1).wip_entity_id);
1651: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','schedule start date'||pflow_sch_details(1).scheduled_start_date );
1652: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','planned qty'|| pflow_sch_details(1).planned_quantity);
1653: cto_wip_workflow_api_pk.cto_debug('create_flow_subassembly','scheudle_completion_date'|| pflow_sch_details(1).scheduled_completion_date);
1654:
1655: End if;
1656:
1657:

Line 1862: cto_wip_workflow_api_pk.cto_debug ('get_mlsupply_details',' SUPPLY FOR ORDER NUMBER = ' || p_order_details_tab(order_details_cntr).order_number ||

1858: oe_debug_pub.add(' SUPPLY FOR ORDER NUMBER = ' || p_order_details_tab(order_details_cntr).order_number ||
1859: 'LINE_ID = ' || p_order_details_tab(order_details_cntr).order_line_id ,1);
1860: oe_debug_pub.add('-----------------------------------------------------------------------------------------',1);
1861: --CTO DEBUG FILE
1862: cto_wip_workflow_api_pk.cto_debug ('get_mlsupply_details',' SUPPLY FOR ORDER NUMBER = ' || p_order_details_tab(order_details_cntr).order_number ||
1863: 'LINE_ID = ' || p_order_details_tab(order_details_cntr).order_line_id );
1864: cto_wip_workflow_api_pk.cto_debug ('get_mlsupply_details','-----------------------------------------------------------------------------------------');
1865: oe_debug_pub.add('INDEX--'||'PARENT_INDEX--'||'ITEM_ID--'||'ITEM_NAME--'||'ITEM_QTY--'||
1866: 'NEEDED_ITEM_QTY--'|| 'CONFIG/ATO--'||'JOB_START_DATE--'||'JOB_COMPLETION_DATE--'||

Line 1864: cto_wip_workflow_api_pk.cto_debug ('get_mlsupply_details','-----------------------------------------------------------------------------------------');

1860: oe_debug_pub.add('-----------------------------------------------------------------------------------------',1);
1861: --CTO DEBUG FILE
1862: cto_wip_workflow_api_pk.cto_debug ('get_mlsupply_details',' SUPPLY FOR ORDER NUMBER = ' || p_order_details_tab(order_details_cntr).order_number ||
1863: 'LINE_ID = ' || p_order_details_tab(order_details_cntr).order_line_id );
1864: cto_wip_workflow_api_pk.cto_debug ('get_mlsupply_details','-----------------------------------------------------------------------------------------');
1865: oe_debug_pub.add('INDEX--'||'PARENT_INDEX--'||'ITEM_ID--'||'ITEM_NAME--'||'ITEM_QTY--'||
1866: 'NEEDED_ITEM_QTY--'|| 'CONFIG/ATO--'||'JOB_START_DATE--'||'JOB_COMPLETION_DATE--'||
1867: 'SOURCED--'||'DISCREATE/FLOW/BUY--'||'COMMENTS',1);
1868: cto_wip_workflow_api_pk.cto_debug ('get_mlsupply_details','INDEX--'||'PARENT_INDEX--'||'ITEM_ID--'||'ITEM_NAME--'||'ITEM_QTY--'||

Line 1868: cto_wip_workflow_api_pk.cto_debug ('get_mlsupply_details','INDEX--'||'PARENT_INDEX--'||'ITEM_ID--'||'ITEM_NAME--'||'ITEM_QTY--'||

1864: cto_wip_workflow_api_pk.cto_debug ('get_mlsupply_details','-----------------------------------------------------------------------------------------');
1865: oe_debug_pub.add('INDEX--'||'PARENT_INDEX--'||'ITEM_ID--'||'ITEM_NAME--'||'ITEM_QTY--'||
1866: 'NEEDED_ITEM_QTY--'|| 'CONFIG/ATO--'||'JOB_START_DATE--'||'JOB_COMPLETION_DATE--'||
1867: 'SOURCED--'||'DISCREATE/FLOW/BUY--'||'COMMENTS',1);
1868: cto_wip_workflow_api_pk.cto_debug ('get_mlsupply_details','INDEX--'||'PARENT_INDEX--'||'ITEM_ID--'||'ITEM_NAME--'||'ITEM_QTY--'||
1869: 'NEEDED_ITEM_QTY--'|| 'CONFIG/ATO--'||'JOB_START_DATE--'||'JOB_COMPLETION_DATE--'||
1870: 'SOURCED--'||'DISCREATE/FLOW/BUY--' ||'COMMENTS');
1871: END IF;
1872:

Line 1931: cto_wip_workflow_api_pk.cto_debug ('get_mlsupply_details',p_supply_details_tab(supply_details_cntr).item_index

1927: ||' -- '||l_sourced
1928: ||' --'||l_supply_type
1929: ||' -- '||p_supply_details_tab(supply_details_cntr).comments,1);
1930:
1931: cto_wip_workflow_api_pk.cto_debug ('get_mlsupply_details',p_supply_details_tab(supply_details_cntr).item_index
1932: ||' -- '||p_supply_details_tab(supply_details_cntr).parent_index
1933: ||' -- '||p_supply_details_tab(supply_details_cntr).item_id
1934: ||' -- '||p_supply_details_tab(supply_details_cntr).item_name
1935: ||' -- '|| p_supply_details_tab(supply_details_cntr).item_quantity

Line 1954: 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)');

1950:
1951: IF (p_flow_supply_tab.COUNT <> 0) THEN
1952: IF PG_DEBUG <> 0 THEN
1953: oe_debug_pub.add('INDEX(from above)--'||'SCHEDULE_NUMBER--'||'SCHEDULE_START_DATE--'||'SCHEDULE_COMPLETION_DATE--'||'PARENT_SCHEDULE_NUM(if flow parent)',1);
1954: 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)');
1955: END IF;
1956:
1957: FOR flow_supply_cntr IN 1..p_flow_supply_tab.COUNT
1958: LOOP

Line 1966: cto_wip_workflow_api_pk.cto_debug ('get_mlsupply_details',p_flow_supply_tab(flow_supply_cntr).item_index

1962: ||' -- '||TO_CHAR(p_flow_supply_tab(flow_supply_cntr).scheduled_start_date,'mm/dd/yyyy hh24:mi:ss')
1963: ||' -- '|| TO_CHAR(p_flow_supply_tab(flow_supply_cntr).scheduled_completion_date,'mm/dd/yyyy hh24:mi:ss')
1964: ||' -- '||p_flow_supply_tab(flow_supply_cntr).synch_schedule_num,1);
1965:
1966: cto_wip_workflow_api_pk.cto_debug ('get_mlsupply_details',p_flow_supply_tab(flow_supply_cntr).item_index
1967: ||' -- '||p_flow_supply_tab(flow_supply_cntr).schedule_number
1968: ||' -- '|| TO_CHAR(p_flow_supply_tab(flow_supply_cntr).scheduled_start_date,'mm/dd/yyyy hh24:mi:ss')
1969: ||' -- '|| TO_CHAR(p_flow_supply_tab(flow_supply_cntr).scheduled_completion_date,'mm/dd/yyyy hh24:mi:ss')
1970: ||' -- '||p_flow_supply_tab(flow_supply_cntr).synch_schedule_num );

Line 2127: cto_wip_workflow_api_pk.cto_debug('Create_sub_assembly_jobs','Inside create sub-assembly jobs');

2123: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2124:
2125:
2126: If PG_DEBUG <> 0 Then
2127: cto_wip_workflow_api_pk.cto_debug('Create_sub_assembly_jobs','Inside create sub-assembly jobs');
2128: cto_wip_workflow_api_pk.cto_debug('Create_sub_assembly_jobs','FOR LINE ID '||p_Top_Assembly_LineId );
2129: End if;
2130:
2131: l_stmt_num := 140;

Line 2128: cto_wip_workflow_api_pk.cto_debug('Create_sub_assembly_jobs','FOR LINE ID '||p_Top_Assembly_LineId );

2124:
2125:
2126: If PG_DEBUG <> 0 Then
2127: cto_wip_workflow_api_pk.cto_debug('Create_sub_assembly_jobs','Inside create sub-assembly jobs');
2128: cto_wip_workflow_api_pk.cto_debug('Create_sub_assembly_jobs','FOR LINE ID '||p_Top_Assembly_LineId );
2129: End if;
2130:
2131: l_stmt_num := 140;
2132:

Line 2197: cto_wip_workflow_api_pk.cto_debug('Create_sub_assembly_jobs','Entered top-most item details into table');

2193: l_mlsupply_items(1).processing_lead_time := l_processing_lead_time;
2194: l_mlsupply_items(1).job_completion_date := l_schedule_ship_date;
2195:
2196: If PG_DEBUG <> 0 Then
2197: cto_wip_workflow_api_pk.cto_debug('Create_sub_assembly_jobs','Entered top-most item details into table');
2198: End if;
2199:
2200: IF(l_cfm_routing_flag = 1) THEN --if top most parent = flow
2201:

Line 2333: cto_wip_workflow_api_pk.cto_debug('Create_sub_assembly_jobs','Before calling get_child_configurations' );

2329: END IF; --top most parent details
2330:
2331: l_stmt_num := 190;
2332: If PG_DEBUG <> 0 Then
2333: cto_wip_workflow_api_pk.cto_debug('Create_sub_assembly_jobs','Before calling get_child_configurations' );
2334: oe_debug_pub.add ('create_subassembly_jobs: ' || 'Before calling get_child_configurations',1);
2335: End if;
2336: get_child_configurations
2337: (

Line 2755: cto_wip_workflow_api_pk.cto_debug ('create_sub_assembly_jobs','calling create flow schedule for'|| l_mlsupply_items(l_index).item_id);

2751: --flow schedule creation
2752:
2753: l_stmt_num := 210;
2754: If PG_DEBUG <> 0 Then
2755: cto_wip_workflow_api_pk.cto_debug ('create_sub_assembly_jobs','calling create flow schedule for'|| l_mlsupply_items(l_index).item_id);
2756:
2757: oe_debug_pub.add('create_subassembly_jobs: ' || 'calling create flow schedule for'|| l_mlsupply_items(l_index).item_id);
2758: END IF;
2759:

Line 3178: cto_wip_workflow_api_pk.cto_debug('Completion date debug messages','after completion date calculations');

3174: --reomve this part at end of UT
3175: If PG_DEBUG <> 0 Then
3176: oe_debug_pub.add ('DEBUG EMSSAEG AFTER COMPLETION DATE CALCULATION',1);
3177:
3178: cto_wip_workflow_api_pk.cto_debug('Completion date debug messages','after completion date calculations');
3179: End if;
3180: --displaying children
3181: IF (l_mlsupply_items.count > 0) THEN --checks for uninitialized collection --bugfix2308063
3182:

Line 3218: cto_wip_workflow_api_pk.cto_debug ('Create_sub_assembly_jobs','idx=>'||l_mlsupply_items(l_index).t_item_details_index || '--' ||

3214: 'FLOW_END_IDX=>'||l_mlsupply_items(l_index).flow_end_index
3215: );
3216:
3217: If PG_DEBUG <> 0 Then
3218: cto_wip_workflow_api_pk.cto_debug ('Create_sub_assembly_jobs','idx=>'||l_mlsupply_items(l_index).t_item_details_index || '--' ||
3219: 'name=>'||l_mlsupply_items(l_index).item_name||'--' ||
3220: 'qty=>'||l_mlsupply_items(l_index).item_quantity||'--'||
3221: 'qty=>'||l_mlsupply_items(l_index).needed_item_qty||'--'||
3222: 'LT%=>'||l_mlsupply_items(l_index).OPERATION_LEAD_TIME_PERCENT||'--'||

Line 3312: cto_wip_workflow_api_pk.cto_debug ('create_sub_assembly_jobs','insert po_interafce'|| l_mlsupply_items(l_index).item_id);

3308:
3309: l_stmt_num := 260;
3310:
3311: If PG_DEBUG <> 0 Then
3312: cto_wip_workflow_api_pk.cto_debug ('create_sub_assembly_jobs','insert po_interafce'|| l_mlsupply_items(l_index).item_id);
3313: 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'));
3314: cto_wip_workflow_api_pk.cto_debug ('create_sub_assembly_jobs','need aty'||l_mlsupply_items(l_index).needed_item_qty);
3315: End if;
3316:

Line 3313: 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'));

3309: l_stmt_num := 260;
3310:
3311: If PG_DEBUG <> 0 Then
3312: cto_wip_workflow_api_pk.cto_debug ('create_sub_assembly_jobs','insert po_interafce'|| l_mlsupply_items(l_index).item_id);
3313: 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'));
3314: cto_wip_workflow_api_pk.cto_debug ('create_sub_assembly_jobs','need aty'||l_mlsupply_items(l_index).needed_item_qty);
3315: End if;
3316:
3317: IF PG_DEBUG <> 0 THEN

Line 3314: cto_wip_workflow_api_pk.cto_debug ('create_sub_assembly_jobs','need aty'||l_mlsupply_items(l_index).needed_item_qty);

3310:
3311: If PG_DEBUG <> 0 Then
3312: cto_wip_workflow_api_pk.cto_debug ('create_sub_assembly_jobs','insert po_interafce'|| l_mlsupply_items(l_index).item_id);
3313: 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'));
3314: cto_wip_workflow_api_pk.cto_debug ('create_sub_assembly_jobs','need aty'||l_mlsupply_items(l_index).needed_item_qty);
3315: End if;
3316:
3317: IF PG_DEBUG <> 0 THEN
3318: oe_debug_pub.add('create_subassembly_jobs: ' || 'insert po_interafce'|| l_mlsupply_items(l_index).item_id);

Line 3741: cto_wip_workflow_api_pk.cto_debug ('Requets id is=> ', l_requestId);

3737: ROLLBACK TO REBUILD;
3738: else
3739: IF PG_DEBUG <> 0 THEN
3740: oe_debug_pub.add('create_subassembly_jobs: ' || 'REQUEST ID Inserted in WJSI for children : ' || l_requestId);
3741: cto_wip_workflow_api_pk.cto_debug ('Requets id is=> ', l_requestId);
3742:
3743: l_token(1).token_name := 'REQUEST_ID';
3744: l_token(1).token_value := l_requestId;
3745: