DBA Data[Home] [Help]

APPS.CTO_UPDATE_BOM_RTG_PK dependencies on OE_DEBUG_PUB

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

1643:
1644:
1645: /* begin Extend Effectivity Dates for Option Items with disable date */
1646:
1647: oe_debug_pub.add('create_bom_ml:: Config bill id = '||lconfigbillid,1);
1648:
1649: For debug_rec in debug_cur
1650: Loop
1651: WriteToLog('create_bom_ml: : Assembly_item_id = '||debug_rec.assembly_item_id,1);

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

6513: if( v_t_overlap_src_op_seq_num.count > 0 ) then
6514: for i in v_t_overlap_src_op_seq_num.first..v_t_overlap_src_op_seq_num.last
6515: loop
6516: IF PG_DEBUG <> 0 THEN
6517: oe_debug_pub.add (' The following components have overlapping dates ', 1);
6518: oe_debug_pub.add (' COMP ' || ' OP SEQ' || 'EFFECTIVITY DT ' || ' DISABLE DT ' || ' OVERLAPS ' ||
6519: ' OP SEQ' || 'EFFECTIVITY DT ' || ' DISABLE DT ' , 1);
6520: /*
6521: oe_debug_pub.add ( v_t_overlap_comp_item_id(i) ||

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

6514: for i in v_t_overlap_src_op_seq_num.first..v_t_overlap_src_op_seq_num.last
6515: loop
6516: IF PG_DEBUG <> 0 THEN
6517: oe_debug_pub.add (' The following components have overlapping dates ', 1);
6518: oe_debug_pub.add (' COMP ' || ' OP SEQ' || 'EFFECTIVITY DT ' || ' DISABLE DT ' || ' OVERLAPS ' ||
6519: ' OP SEQ' || 'EFFECTIVITY DT ' || ' DISABLE DT ' , 1);
6520: /*
6521: oe_debug_pub.add ( v_t_overlap_comp_item_id(i) ||
6522: ' ' || v_t_overlap_src_op_seq_num(i) ||

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

6517: oe_debug_pub.add (' The following components have overlapping dates ', 1);
6518: oe_debug_pub.add (' COMP ' || ' OP SEQ' || 'EFFECTIVITY DT ' || ' DISABLE DT ' || ' OVERLAPS ' ||
6519: ' OP SEQ' || 'EFFECTIVITY DT ' || ' DISABLE DT ' , 1);
6520: /*
6521: oe_debug_pub.add ( v_t_overlap_comp_item_id(i) ||
6522: ' ' || v_t_overlap_src_op_seq_num(i) ||
6523: ' ' || v_t_overlap_src_eff_date(i) ||
6524: ' ' || v_t_overlap_src_disable_date(i) ||
6525: ' OVERLAPS ' ||