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_UPDATE_BOM_RTG_PK dependencies on OE_DEBUG_PUB

Line 1706: oe_debug_pub.add('create_bom_ml:: Config bill id = '||lconfigbillid,1);

1702:
1703:
1704: /* begin Extend Effectivity Dates for Option Items with disable date */
1705:
1706: oe_debug_pub.add('create_bom_ml:: Config bill id = '||lconfigbillid,1);
1707:
1708: For debug_rec in debug_cur
1709: Loop
1710: WriteToLog('create_bom_ml: : Assembly_item_id = '||debug_rec.assembly_item_id,1);

Line 1881: oe_debug_pub.add('New Msg: ship_org_id_temp:' || ship_org_id_temp);

1877: item_id_temp
1878: from bom_cto_order_lines_upg
1879: where line_id = v_missed_line_id;
1880:
1881: oe_debug_pub.add('New Msg: ship_org_id_temp:' || ship_org_id_temp);
1882: oe_debug_pub.add('New Msg: item_id_temp:' || item_id_temp);
1883:
1884: exception
1885: when others then

Line 1882: oe_debug_pub.add('New Msg: item_id_temp:' || item_id_temp);

1878: from bom_cto_order_lines_upg
1879: where line_id = v_missed_line_id;
1880:
1881: oe_debug_pub.add('New Msg: ship_org_id_temp:' || ship_org_id_temp);
1882: oe_debug_pub.add('New Msg: item_id_temp:' || item_id_temp);
1883:
1884: exception
1885: when others then
1886: oe_debug_pub.add('Exception in debug code:' || sqlerrm);

Line 1886: oe_debug_pub.add('Exception in debug code:' || sqlerrm);

1882: oe_debug_pub.add('New Msg: item_id_temp:' || item_id_temp);
1883:
1884: exception
1885: when others then
1886: oe_debug_pub.add('Exception in debug code:' || sqlerrm);
1887: end;
1888:
1889: /*select substrb(msi.concatenated_segments,1,50),
1890: 'Not Available' ,

Line 3471: oe_debug_pub.add ('create_routing_ml: Copying the attachment on routing header.', 2);

3467: -- to config.
3468: lstmtNum := 395;
3469:
3470: IF PG_DEBUG <> 0 THEN
3471: oe_debug_pub.add ('create_routing_ml: Copying the attachment on routing header.', 2);
3472: oe_debug_pub.add ('create_routing_ml: Model routing_sequence_id:' || lItmRtgId, 2);
3473: END IF;
3474:
3475: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(

Line 3472: oe_debug_pub.add ('create_routing_ml: Model routing_sequence_id:' || lItmRtgId, 2);

3468: lstmtNum := 395;
3469:
3470: IF PG_DEBUG <> 0 THEN
3471: oe_debug_pub.add ('create_routing_ml: Copying the attachment on routing header.', 2);
3472: oe_debug_pub.add ('create_routing_ml: Model routing_sequence_id:' || lItmRtgId, 2);
3473: END IF;
3474:
3475: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
3476: X_from_entity_name =>'BOM_OPERATIONAL_ROUTINGS',

Line 6392: oe_debug_pub.add ('Component Code: ' || r1.component_code,1);

6388:
6389: FOR r1 in c_model_oc_oi_rows(pConfigBillId) LOOP
6390: IF r1.operation_seq_num = 1 AND instr(r1.component_code,'-',1,2)<>0 THEN
6391: IF PG_DEBUG <> 0 THEN -- 13079222
6392: oe_debug_pub.add ('Component Code: ' || r1.component_code,1);
6393: END IF;
6394: UPDATE bom_explosion_temp bet
6395: SET bet.operation_seq_num = (
6396: SELECT /*+ INDEX( BOM_EXPLOSION_TEMP BOM_EXPLOSION_TEMP_N11) */

Line 6729: oe_debug_pub.add (' The following components have overlapping dates ', 1);

6725: if( v_t_overlap_src_op_seq_num.count > 0 ) then
6726: for i in v_t_overlap_src_op_seq_num.first..v_t_overlap_src_op_seq_num.last
6727: loop
6728: IF PG_DEBUG <> 0 THEN
6729: oe_debug_pub.add (' The following components have overlapping dates ', 1);
6730: oe_debug_pub.add (' COMP ' || ' OP SEQ' || 'EFFECTIVITY DT ' || ' DISABLE DT ' || ' OVERLAPS ' ||
6731: ' OP SEQ' || 'EFFECTIVITY DT ' || ' DISABLE DT ' , 1);
6732: /*
6733: oe_debug_pub.add ( v_t_overlap_comp_item_id(i) ||

Line 6730: oe_debug_pub.add (' COMP ' || ' OP SEQ' || 'EFFECTIVITY DT ' || ' DISABLE DT ' || ' OVERLAPS ' ||

6726: for i in v_t_overlap_src_op_seq_num.first..v_t_overlap_src_op_seq_num.last
6727: loop
6728: IF PG_DEBUG <> 0 THEN
6729: oe_debug_pub.add (' The following components have overlapping dates ', 1);
6730: oe_debug_pub.add (' COMP ' || ' OP SEQ' || 'EFFECTIVITY DT ' || ' DISABLE DT ' || ' OVERLAPS ' ||
6731: ' OP SEQ' || 'EFFECTIVITY DT ' || ' DISABLE DT ' , 1);
6732: /*
6733: oe_debug_pub.add ( v_t_overlap_comp_item_id(i) ||
6734: ' ' || v_t_overlap_src_op_seq_num(i) ||

Line 6733: oe_debug_pub.add ( v_t_overlap_comp_item_id(i) ||

6729: oe_debug_pub.add (' The following components have overlapping dates ', 1);
6730: oe_debug_pub.add (' COMP ' || ' OP SEQ' || 'EFFECTIVITY DT ' || ' DISABLE DT ' || ' OVERLAPS ' ||
6731: ' OP SEQ' || 'EFFECTIVITY DT ' || ' DISABLE DT ' , 1);
6732: /*
6733: oe_debug_pub.add ( v_t_overlap_comp_item_id(i) ||
6734: ' ' || v_t_overlap_src_op_seq_num(i) ||
6735: ' ' || v_t_overlap_src_eff_date(i) ||
6736: ' ' || v_t_overlap_src_disable_date(i) ||
6737: ' OVERLAPS ' ||