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.OE_ORDER_WF_UTIL dependencies on OE_ORDER_UTIL

Line 1490: oe_debug_pub.add('UFSC: GLOBAL RECURSION WITHOUT EXCEPTION: ' || OE_ORDER_UTIL.G_RECURSION_WITHOUT_EXCEPTION) ;

1486:
1487: BEGIN
1488: IF l_debug_level > 0 THEN
1489: oe_debug_pub.add('ENTERING UPDATE_FLOW_STATUS_CODE' , 5 ) ;
1490: oe_debug_pub.add('UFSC: GLOBAL RECURSION WITHOUT EXCEPTION: ' || OE_ORDER_UTIL.G_RECURSION_WITHOUT_EXCEPTION) ;
1491: oe_debug_pub.add('UFSC: GLOBAL CACHE BOOKED FLAG' || OE_ORDER_CACHE.G_HEADER_REC.BOOKED_FLAG ) ;
1492: oe_debug_pub.add('UFSC: GLOBAL PICTURE HEADER BOOKED FLAG' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_FLAG ) ;
1493: oe_debug_pub.add('UFSC: COUNT OF NEW LINE TABLE= '|| OE_ORDER_UTIL.G_LINE_TBL.COUNT ) ;
1494: oe_debug_pub.add('UFSC: COUNT OF OLD LINE TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_TBL.COUNT ) ;

Line 1492: oe_debug_pub.add('UFSC: GLOBAL PICTURE HEADER BOOKED FLAG' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_FLAG ) ;

1488: IF l_debug_level > 0 THEN
1489: oe_debug_pub.add('ENTERING UPDATE_FLOW_STATUS_CODE' , 5 ) ;
1490: oe_debug_pub.add('UFSC: GLOBAL RECURSION WITHOUT EXCEPTION: ' || OE_ORDER_UTIL.G_RECURSION_WITHOUT_EXCEPTION) ;
1491: oe_debug_pub.add('UFSC: GLOBAL CACHE BOOKED FLAG' || OE_ORDER_CACHE.G_HEADER_REC.BOOKED_FLAG ) ;
1492: oe_debug_pub.add('UFSC: GLOBAL PICTURE HEADER BOOKED FLAG' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_FLAG ) ;
1493: oe_debug_pub.add('UFSC: COUNT OF NEW LINE TABLE= '|| OE_ORDER_UTIL.G_LINE_TBL.COUNT ) ;
1494: oe_debug_pub.add('UFSC: COUNT OF OLD LINE TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_TBL.COUNT ) ;
1495: oe_debug_pub.add('UFSC: COUNT OF NEW LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_LINE_ADJ_TBL.COUNT ) ;
1496: oe_debug_pub.add('UFSC: COUNT OF OLD LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_ADJ_TBL.COUNT ) ;

Line 1493: oe_debug_pub.add('UFSC: COUNT OF NEW LINE TABLE= '|| OE_ORDER_UTIL.G_LINE_TBL.COUNT ) ;

1489: oe_debug_pub.add('ENTERING UPDATE_FLOW_STATUS_CODE' , 5 ) ;
1490: oe_debug_pub.add('UFSC: GLOBAL RECURSION WITHOUT EXCEPTION: ' || OE_ORDER_UTIL.G_RECURSION_WITHOUT_EXCEPTION) ;
1491: oe_debug_pub.add('UFSC: GLOBAL CACHE BOOKED FLAG' || OE_ORDER_CACHE.G_HEADER_REC.BOOKED_FLAG ) ;
1492: oe_debug_pub.add('UFSC: GLOBAL PICTURE HEADER BOOKED FLAG' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_FLAG ) ;
1493: oe_debug_pub.add('UFSC: COUNT OF NEW LINE TABLE= '|| OE_ORDER_UTIL.G_LINE_TBL.COUNT ) ;
1494: oe_debug_pub.add('UFSC: COUNT OF OLD LINE TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_TBL.COUNT ) ;
1495: oe_debug_pub.add('UFSC: COUNT OF NEW LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_LINE_ADJ_TBL.COUNT ) ;
1496: oe_debug_pub.add('UFSC: COUNT OF OLD LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_ADJ_TBL.COUNT ) ;
1497: oe_debug_pub.add('UFSC: COUNT OF NEW HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_HEADER_ADJ_TBL.COUNT ) ;

Line 1494: oe_debug_pub.add('UFSC: COUNT OF OLD LINE TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_TBL.COUNT ) ;

1490: oe_debug_pub.add('UFSC: GLOBAL RECURSION WITHOUT EXCEPTION: ' || OE_ORDER_UTIL.G_RECURSION_WITHOUT_EXCEPTION) ;
1491: oe_debug_pub.add('UFSC: GLOBAL CACHE BOOKED FLAG' || OE_ORDER_CACHE.G_HEADER_REC.BOOKED_FLAG ) ;
1492: oe_debug_pub.add('UFSC: GLOBAL PICTURE HEADER BOOKED FLAG' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_FLAG ) ;
1493: oe_debug_pub.add('UFSC: COUNT OF NEW LINE TABLE= '|| OE_ORDER_UTIL.G_LINE_TBL.COUNT ) ;
1494: oe_debug_pub.add('UFSC: COUNT OF OLD LINE TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_TBL.COUNT ) ;
1495: oe_debug_pub.add('UFSC: COUNT OF NEW LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_LINE_ADJ_TBL.COUNT ) ;
1496: oe_debug_pub.add('UFSC: COUNT OF OLD LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_ADJ_TBL.COUNT ) ;
1497: oe_debug_pub.add('UFSC: COUNT OF NEW HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_HEADER_ADJ_TBL.COUNT ) ;
1498: oe_debug_pub.add('UFSC: COUNT OF OLD HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_ADJ_TBL.COUNT ) ;

Line 1495: oe_debug_pub.add('UFSC: COUNT OF NEW LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_LINE_ADJ_TBL.COUNT ) ;

1491: oe_debug_pub.add('UFSC: GLOBAL CACHE BOOKED FLAG' || OE_ORDER_CACHE.G_HEADER_REC.BOOKED_FLAG ) ;
1492: oe_debug_pub.add('UFSC: GLOBAL PICTURE HEADER BOOKED FLAG' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_FLAG ) ;
1493: oe_debug_pub.add('UFSC: COUNT OF NEW LINE TABLE= '|| OE_ORDER_UTIL.G_LINE_TBL.COUNT ) ;
1494: oe_debug_pub.add('UFSC: COUNT OF OLD LINE TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_TBL.COUNT ) ;
1495: oe_debug_pub.add('UFSC: COUNT OF NEW LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_LINE_ADJ_TBL.COUNT ) ;
1496: oe_debug_pub.add('UFSC: COUNT OF OLD LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_ADJ_TBL.COUNT ) ;
1497: oe_debug_pub.add('UFSC: COUNT OF NEW HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_HEADER_ADJ_TBL.COUNT ) ;
1498: oe_debug_pub.add('UFSC: COUNT OF OLD HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_ADJ_TBL.COUNT ) ;
1499: oe_debug_pub.add('UFSC: COUNT OF NEW HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_HEADER_SCREDIT_TBL.COUNT ) ;

Line 1496: oe_debug_pub.add('UFSC: COUNT OF OLD LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_ADJ_TBL.COUNT ) ;

1492: oe_debug_pub.add('UFSC: GLOBAL PICTURE HEADER BOOKED FLAG' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_FLAG ) ;
1493: oe_debug_pub.add('UFSC: COUNT OF NEW LINE TABLE= '|| OE_ORDER_UTIL.G_LINE_TBL.COUNT ) ;
1494: oe_debug_pub.add('UFSC: COUNT OF OLD LINE TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_TBL.COUNT ) ;
1495: oe_debug_pub.add('UFSC: COUNT OF NEW LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_LINE_ADJ_TBL.COUNT ) ;
1496: oe_debug_pub.add('UFSC: COUNT OF OLD LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_ADJ_TBL.COUNT ) ;
1497: oe_debug_pub.add('UFSC: COUNT OF NEW HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_HEADER_ADJ_TBL.COUNT ) ;
1498: oe_debug_pub.add('UFSC: COUNT OF OLD HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_ADJ_TBL.COUNT ) ;
1499: oe_debug_pub.add('UFSC: COUNT OF NEW HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_HEADER_SCREDIT_TBL.COUNT ) ;
1500: oe_debug_pub.add('UFSC: COUNT OF OLD HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_SCREDIT_TBL.COUNT ) ;

Line 1497: oe_debug_pub.add('UFSC: COUNT OF NEW HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_HEADER_ADJ_TBL.COUNT ) ;

1493: oe_debug_pub.add('UFSC: COUNT OF NEW LINE TABLE= '|| OE_ORDER_UTIL.G_LINE_TBL.COUNT ) ;
1494: oe_debug_pub.add('UFSC: COUNT OF OLD LINE TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_TBL.COUNT ) ;
1495: oe_debug_pub.add('UFSC: COUNT OF NEW LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_LINE_ADJ_TBL.COUNT ) ;
1496: oe_debug_pub.add('UFSC: COUNT OF OLD LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_ADJ_TBL.COUNT ) ;
1497: oe_debug_pub.add('UFSC: COUNT OF NEW HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_HEADER_ADJ_TBL.COUNT ) ;
1498: oe_debug_pub.add('UFSC: COUNT OF OLD HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_ADJ_TBL.COUNT ) ;
1499: oe_debug_pub.add('UFSC: COUNT OF NEW HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_HEADER_SCREDIT_TBL.COUNT ) ;
1500: oe_debug_pub.add('UFSC: COUNT OF OLD HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_SCREDIT_TBL.COUNT ) ;
1501: oe_debug_pub.add('UFSC: COUNT OF NEW LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_LINE_SCREDIT_TBL.COUNT ) ;

Line 1498: oe_debug_pub.add('UFSC: COUNT OF OLD HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_ADJ_TBL.COUNT ) ;

1494: oe_debug_pub.add('UFSC: COUNT OF OLD LINE TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_TBL.COUNT ) ;
1495: oe_debug_pub.add('UFSC: COUNT OF NEW LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_LINE_ADJ_TBL.COUNT ) ;
1496: oe_debug_pub.add('UFSC: COUNT OF OLD LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_ADJ_TBL.COUNT ) ;
1497: oe_debug_pub.add('UFSC: COUNT OF NEW HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_HEADER_ADJ_TBL.COUNT ) ;
1498: oe_debug_pub.add('UFSC: COUNT OF OLD HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_ADJ_TBL.COUNT ) ;
1499: oe_debug_pub.add('UFSC: COUNT OF NEW HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_HEADER_SCREDIT_TBL.COUNT ) ;
1500: oe_debug_pub.add('UFSC: COUNT OF OLD HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_SCREDIT_TBL.COUNT ) ;
1501: oe_debug_pub.add('UFSC: COUNT OF NEW LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_LINE_SCREDIT_TBL.COUNT ) ;
1502: oe_debug_pub.add('UFSC: COUNT OF OLD LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_SCREDIT_TBL.COUNT ) ;

Line 1499: oe_debug_pub.add('UFSC: COUNT OF NEW HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_HEADER_SCREDIT_TBL.COUNT ) ;

1495: oe_debug_pub.add('UFSC: COUNT OF NEW LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_LINE_ADJ_TBL.COUNT ) ;
1496: oe_debug_pub.add('UFSC: COUNT OF OLD LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_ADJ_TBL.COUNT ) ;
1497: oe_debug_pub.add('UFSC: COUNT OF NEW HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_HEADER_ADJ_TBL.COUNT ) ;
1498: oe_debug_pub.add('UFSC: COUNT OF OLD HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_ADJ_TBL.COUNT ) ;
1499: oe_debug_pub.add('UFSC: COUNT OF NEW HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_HEADER_SCREDIT_TBL.COUNT ) ;
1500: oe_debug_pub.add('UFSC: COUNT OF OLD HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_SCREDIT_TBL.COUNT ) ;
1501: oe_debug_pub.add('UFSC: COUNT OF NEW LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_LINE_SCREDIT_TBL.COUNT ) ;
1502: oe_debug_pub.add('UFSC: COUNT OF OLD LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_SCREDIT_TBL.COUNT ) ;
1503: oe_debug_pub.add('UFSC: COUNT OF NEW LOT SERIAL TABLE= '|| OE_ORDER_UTIL.G_LOT_SERIAL_TBL.COUNT ) ;

Line 1500: oe_debug_pub.add('UFSC: COUNT OF OLD HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_SCREDIT_TBL.COUNT ) ;

1496: oe_debug_pub.add('UFSC: COUNT OF OLD LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_ADJ_TBL.COUNT ) ;
1497: oe_debug_pub.add('UFSC: COUNT OF NEW HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_HEADER_ADJ_TBL.COUNT ) ;
1498: oe_debug_pub.add('UFSC: COUNT OF OLD HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_ADJ_TBL.COUNT ) ;
1499: oe_debug_pub.add('UFSC: COUNT OF NEW HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_HEADER_SCREDIT_TBL.COUNT ) ;
1500: oe_debug_pub.add('UFSC: COUNT OF OLD HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_SCREDIT_TBL.COUNT ) ;
1501: oe_debug_pub.add('UFSC: COUNT OF NEW LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_LINE_SCREDIT_TBL.COUNT ) ;
1502: oe_debug_pub.add('UFSC: COUNT OF OLD LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_SCREDIT_TBL.COUNT ) ;
1503: oe_debug_pub.add('UFSC: COUNT OF NEW LOT SERIAL TABLE= '|| OE_ORDER_UTIL.G_LOT_SERIAL_TBL.COUNT ) ;
1504: oe_debug_pub.add('UFSC: COUNT OF OLD LOT SERIAL TABLE= '|| OE_ORDER_UTIL.G_OLD_LOT_SERIAL_TBL.COUNT ) ;

Line 1501: oe_debug_pub.add('UFSC: COUNT OF NEW LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_LINE_SCREDIT_TBL.COUNT ) ;

1497: oe_debug_pub.add('UFSC: COUNT OF NEW HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_HEADER_ADJ_TBL.COUNT ) ;
1498: oe_debug_pub.add('UFSC: COUNT OF OLD HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_ADJ_TBL.COUNT ) ;
1499: oe_debug_pub.add('UFSC: COUNT OF NEW HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_HEADER_SCREDIT_TBL.COUNT ) ;
1500: oe_debug_pub.add('UFSC: COUNT OF OLD HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_SCREDIT_TBL.COUNT ) ;
1501: oe_debug_pub.add('UFSC: COUNT OF NEW LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_LINE_SCREDIT_TBL.COUNT ) ;
1502: oe_debug_pub.add('UFSC: COUNT OF OLD LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_SCREDIT_TBL.COUNT ) ;
1503: oe_debug_pub.add('UFSC: COUNT OF NEW LOT SERIAL TABLE= '|| OE_ORDER_UTIL.G_LOT_SERIAL_TBL.COUNT ) ;
1504: oe_debug_pub.add('UFSC: COUNT OF OLD LOT SERIAL TABLE= '|| OE_ORDER_UTIL.G_OLD_LOT_SERIAL_TBL.COUNT ) ;
1505: END IF;

Line 1502: oe_debug_pub.add('UFSC: COUNT OF OLD LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_SCREDIT_TBL.COUNT ) ;

1498: oe_debug_pub.add('UFSC: COUNT OF OLD HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_ADJ_TBL.COUNT ) ;
1499: oe_debug_pub.add('UFSC: COUNT OF NEW HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_HEADER_SCREDIT_TBL.COUNT ) ;
1500: oe_debug_pub.add('UFSC: COUNT OF OLD HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_SCREDIT_TBL.COUNT ) ;
1501: oe_debug_pub.add('UFSC: COUNT OF NEW LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_LINE_SCREDIT_TBL.COUNT ) ;
1502: oe_debug_pub.add('UFSC: COUNT OF OLD LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_SCREDIT_TBL.COUNT ) ;
1503: oe_debug_pub.add('UFSC: COUNT OF NEW LOT SERIAL TABLE= '|| OE_ORDER_UTIL.G_LOT_SERIAL_TBL.COUNT ) ;
1504: oe_debug_pub.add('UFSC: COUNT OF OLD LOT SERIAL TABLE= '|| OE_ORDER_UTIL.G_OLD_LOT_SERIAL_TBL.COUNT ) ;
1505: END IF;
1506:

Line 1503: oe_debug_pub.add('UFSC: COUNT OF NEW LOT SERIAL TABLE= '|| OE_ORDER_UTIL.G_LOT_SERIAL_TBL.COUNT ) ;

1499: oe_debug_pub.add('UFSC: COUNT OF NEW HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_HEADER_SCREDIT_TBL.COUNT ) ;
1500: oe_debug_pub.add('UFSC: COUNT OF OLD HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_SCREDIT_TBL.COUNT ) ;
1501: oe_debug_pub.add('UFSC: COUNT OF NEW LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_LINE_SCREDIT_TBL.COUNT ) ;
1502: oe_debug_pub.add('UFSC: COUNT OF OLD LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_SCREDIT_TBL.COUNT ) ;
1503: oe_debug_pub.add('UFSC: COUNT OF NEW LOT SERIAL TABLE= '|| OE_ORDER_UTIL.G_LOT_SERIAL_TBL.COUNT ) ;
1504: oe_debug_pub.add('UFSC: COUNT OF OLD LOT SERIAL TABLE= '|| OE_ORDER_UTIL.G_OLD_LOT_SERIAL_TBL.COUNT ) ;
1505: END IF;
1506:
1507: SAVEPOINT UPDATE_FLOW_STATUS_CODE;

Line 1504: oe_debug_pub.add('UFSC: COUNT OF OLD LOT SERIAL TABLE= '|| OE_ORDER_UTIL.G_OLD_LOT_SERIAL_TBL.COUNT ) ;

1500: oe_debug_pub.add('UFSC: COUNT OF OLD HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_SCREDIT_TBL.COUNT ) ;
1501: oe_debug_pub.add('UFSC: COUNT OF NEW LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_LINE_SCREDIT_TBL.COUNT ) ;
1502: oe_debug_pub.add('UFSC: COUNT OF OLD LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_SCREDIT_TBL.COUNT ) ;
1503: oe_debug_pub.add('UFSC: COUNT OF NEW LOT SERIAL TABLE= '|| OE_ORDER_UTIL.G_LOT_SERIAL_TBL.COUNT ) ;
1504: oe_debug_pub.add('UFSC: COUNT OF OLD LOT SERIAL TABLE= '|| OE_ORDER_UTIL.G_OLD_LOT_SERIAL_TBL.COUNT ) ;
1505: END IF;
1506:
1507: SAVEPOINT UPDATE_FLOW_STATUS_CODE;
1508:

Line 1599: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,

1595: (p_validation_entity_id => OE_PC_GLOBALS.G_ENTITY_HEADER);
1596:
1597: -- added for notification framework
1598: -- calling notification framework to get index position
1599: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,
1600: p_old_header_rec => l_old_header_rec,
1601: p_Header_rec => l_header_rec,
1602: p_header_id => p_header_id,
1603: x_index => l_index,

Line 1618: OE_ORDER_UTIL.g_header_rec := OE_ORDER_UTIL.g_old_header_rec;

1614: END IF;
1615:
1616: IF l_index is not NULL THEN
1617: -- update global picture directly
1618: OE_ORDER_UTIL.g_header_rec := OE_ORDER_UTIL.g_old_header_rec;
1619: OE_ORDER_UTIL.g_header_rec.flow_status_code:=p_flow_status_code;
1620: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
1621: OE_ORDER_UTIL.g_header_rec.operation:=OE_GLOBALS.G_OPR_UPDATE;
1622: IF l_debug_level > 0 THEN

Line 1619: OE_ORDER_UTIL.g_header_rec.flow_status_code:=p_flow_status_code;

1615:
1616: IF l_index is not NULL THEN
1617: -- update global picture directly
1618: OE_ORDER_UTIL.g_header_rec := OE_ORDER_UTIL.g_old_header_rec;
1619: OE_ORDER_UTIL.g_header_rec.flow_status_code:=p_flow_status_code;
1620: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
1621: OE_ORDER_UTIL.g_header_rec.operation:=OE_GLOBALS.G_OPR_UPDATE;
1622: IF l_debug_level > 0 THEN
1623: oe_debug_pub.add( 'GLOBAL HEADER FLOW STATUS IS: ' || OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE,1);

Line 1620: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;

1616: IF l_index is not NULL THEN
1617: -- update global picture directly
1618: OE_ORDER_UTIL.g_header_rec := OE_ORDER_UTIL.g_old_header_rec;
1619: OE_ORDER_UTIL.g_header_rec.flow_status_code:=p_flow_status_code;
1620: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
1621: OE_ORDER_UTIL.g_header_rec.operation:=OE_GLOBALS.G_OPR_UPDATE;
1622: IF l_debug_level > 0 THEN
1623: oe_debug_pub.add( 'GLOBAL HEADER FLOW STATUS IS: ' || OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE,1);
1624: oe_debug_pub.add( 'GLOBAL HEADER OPERATION IS: ' || OE_ORDER_UTIL.G_HEADER_REC.OPERATION,1);

Line 1621: OE_ORDER_UTIL.g_header_rec.operation:=OE_GLOBALS.G_OPR_UPDATE;

1617: -- update global picture directly
1618: OE_ORDER_UTIL.g_header_rec := OE_ORDER_UTIL.g_old_header_rec;
1619: OE_ORDER_UTIL.g_header_rec.flow_status_code:=p_flow_status_code;
1620: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
1621: OE_ORDER_UTIL.g_header_rec.operation:=OE_GLOBALS.G_OPR_UPDATE;
1622: IF l_debug_level > 0 THEN
1623: oe_debug_pub.add( 'GLOBAL HEADER FLOW STATUS IS: ' || OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE,1);
1624: oe_debug_pub.add( 'GLOBAL HEADER OPERATION IS: ' || OE_ORDER_UTIL.G_HEADER_REC.OPERATION,1);
1625: END IF;

Line 1623: oe_debug_pub.add( 'GLOBAL HEADER FLOW STATUS IS: ' || OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE,1);

1619: OE_ORDER_UTIL.g_header_rec.flow_status_code:=p_flow_status_code;
1620: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
1621: OE_ORDER_UTIL.g_header_rec.operation:=OE_GLOBALS.G_OPR_UPDATE;
1622: IF l_debug_level > 0 THEN
1623: oe_debug_pub.add( 'GLOBAL HEADER FLOW STATUS IS: ' || OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE,1);
1624: oe_debug_pub.add( 'GLOBAL HEADER OPERATION IS: ' || OE_ORDER_UTIL.G_HEADER_REC.OPERATION,1);
1625: END IF;
1626: END IF;
1627: -- bug 4732614

Line 1624: oe_debug_pub.add( 'GLOBAL HEADER OPERATION IS: ' || OE_ORDER_UTIL.G_HEADER_REC.OPERATION,1);

1620: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
1621: OE_ORDER_UTIL.g_header_rec.operation:=OE_GLOBALS.G_OPR_UPDATE;
1622: IF l_debug_level > 0 THEN
1623: oe_debug_pub.add( 'GLOBAL HEADER FLOW STATUS IS: ' || OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE,1);
1624: oe_debug_pub.add( 'GLOBAL HEADER OPERATION IS: ' || OE_ORDER_UTIL.G_HEADER_REC.OPERATION,1);
1625: END IF;
1626: END IF;
1627: -- bug 4732614
1628: IF l_debug_level > 0 THEN

Line 1877: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,

1873: l_line_tbl(1).lock_control := l_line_tbl(1).lock_control + 1;
1874:
1875: -- added for notification framework
1876: -- calling notification framework to get index position
1877: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,
1878: p_header_id => l_line_tbl(1).header_id,
1879: p_old_line_rec => l_old_line_tbl(1),
1880: p_line_rec =>l_line_tbl(1),
1881: p_line_id => p_line_id,

Line 1899: OE_ORDER_UTIL.g_old_line_tbl(l_index) := l_old_line_tbl(1); --Added for bug 5842114

1895:
1896: -- update global picture directly
1897: -- First copy the old picture to the new and then update the
1898: -- changed columns for the new global table.
1899: OE_ORDER_UTIL.g_old_line_tbl(l_index) := l_old_line_tbl(1); --Added for bug 5842114
1900: OE_ORDER_UTIL.g_line_tbl(l_index) := OE_ORDER_UTIL.g_old_line_tbl(l_index);
1901: OE_ORDER_UTIL.g_line_tbl(l_index).flow_status_code:=p_flow_status_code;
1902: OE_ORDER_UTIL.g_line_tbl(l_index).lock_control:=l_line_tbl(1).lock_control;
1903: OE_ORDER_UTIL.g_line_tbl(l_index).line_id:=l_line_tbl(1).line_id;

Line 1900: OE_ORDER_UTIL.g_line_tbl(l_index) := OE_ORDER_UTIL.g_old_line_tbl(l_index);

1896: -- update global picture directly
1897: -- First copy the old picture to the new and then update the
1898: -- changed columns for the new global table.
1899: OE_ORDER_UTIL.g_old_line_tbl(l_index) := l_old_line_tbl(1); --Added for bug 5842114
1900: OE_ORDER_UTIL.g_line_tbl(l_index) := OE_ORDER_UTIL.g_old_line_tbl(l_index);
1901: OE_ORDER_UTIL.g_line_tbl(l_index).flow_status_code:=p_flow_status_code;
1902: OE_ORDER_UTIL.g_line_tbl(l_index).lock_control:=l_line_tbl(1).lock_control;
1903: OE_ORDER_UTIL.g_line_tbl(l_index).line_id:=l_line_tbl(1).line_id;
1904: OE_ORDER_UTIL.g_line_tbl(l_index).header_id:=l_line_tbl(1).header_id;

Line 1901: OE_ORDER_UTIL.g_line_tbl(l_index).flow_status_code:=p_flow_status_code;

1897: -- First copy the old picture to the new and then update the
1898: -- changed columns for the new global table.
1899: OE_ORDER_UTIL.g_old_line_tbl(l_index) := l_old_line_tbl(1); --Added for bug 5842114
1900: OE_ORDER_UTIL.g_line_tbl(l_index) := OE_ORDER_UTIL.g_old_line_tbl(l_index);
1901: OE_ORDER_UTIL.g_line_tbl(l_index).flow_status_code:=p_flow_status_code;
1902: OE_ORDER_UTIL.g_line_tbl(l_index).lock_control:=l_line_tbl(1).lock_control;
1903: OE_ORDER_UTIL.g_line_tbl(l_index).line_id:=l_line_tbl(1).line_id;
1904: OE_ORDER_UTIL.g_line_tbl(l_index).header_id:=l_line_tbl(1).header_id;
1905: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_date:=l_line_tbl(1).last_update_date;

Line 1902: OE_ORDER_UTIL.g_line_tbl(l_index).lock_control:=l_line_tbl(1).lock_control;

1898: -- changed columns for the new global table.
1899: OE_ORDER_UTIL.g_old_line_tbl(l_index) := l_old_line_tbl(1); --Added for bug 5842114
1900: OE_ORDER_UTIL.g_line_tbl(l_index) := OE_ORDER_UTIL.g_old_line_tbl(l_index);
1901: OE_ORDER_UTIL.g_line_tbl(l_index).flow_status_code:=p_flow_status_code;
1902: OE_ORDER_UTIL.g_line_tbl(l_index).lock_control:=l_line_tbl(1).lock_control;
1903: OE_ORDER_UTIL.g_line_tbl(l_index).line_id:=l_line_tbl(1).line_id;
1904: OE_ORDER_UTIL.g_line_tbl(l_index).header_id:=l_line_tbl(1).header_id;
1905: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_date:=l_line_tbl(1).last_update_date;
1906: OE_ORDER_UTIL.g_line_tbl(l_index).operation:=OE_GLOBALS.G_OPR_UPDATE;

Line 1903: OE_ORDER_UTIL.g_line_tbl(l_index).line_id:=l_line_tbl(1).line_id;

1899: OE_ORDER_UTIL.g_old_line_tbl(l_index) := l_old_line_tbl(1); --Added for bug 5842114
1900: OE_ORDER_UTIL.g_line_tbl(l_index) := OE_ORDER_UTIL.g_old_line_tbl(l_index);
1901: OE_ORDER_UTIL.g_line_tbl(l_index).flow_status_code:=p_flow_status_code;
1902: OE_ORDER_UTIL.g_line_tbl(l_index).lock_control:=l_line_tbl(1).lock_control;
1903: OE_ORDER_UTIL.g_line_tbl(l_index).line_id:=l_line_tbl(1).line_id;
1904: OE_ORDER_UTIL.g_line_tbl(l_index).header_id:=l_line_tbl(1).header_id;
1905: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_date:=l_line_tbl(1).last_update_date;
1906: OE_ORDER_UTIL.g_line_tbl(l_index).operation:=OE_GLOBALS.G_OPR_UPDATE;
1907: IF l_debug_level > 0 THEN

Line 1904: OE_ORDER_UTIL.g_line_tbl(l_index).header_id:=l_line_tbl(1).header_id;

1900: OE_ORDER_UTIL.g_line_tbl(l_index) := OE_ORDER_UTIL.g_old_line_tbl(l_index);
1901: OE_ORDER_UTIL.g_line_tbl(l_index).flow_status_code:=p_flow_status_code;
1902: OE_ORDER_UTIL.g_line_tbl(l_index).lock_control:=l_line_tbl(1).lock_control;
1903: OE_ORDER_UTIL.g_line_tbl(l_index).line_id:=l_line_tbl(1).line_id;
1904: OE_ORDER_UTIL.g_line_tbl(l_index).header_id:=l_line_tbl(1).header_id;
1905: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_date:=l_line_tbl(1).last_update_date;
1906: OE_ORDER_UTIL.g_line_tbl(l_index).operation:=OE_GLOBALS.G_OPR_UPDATE;
1907: IF l_debug_level > 0 THEN
1908: oe_debug_pub.add( 'GLOBAL LINE FLOW STATUS IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_INDEX ) .FLOW_STATUS_CODE , 1 ) ;

Line 1905: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_date:=l_line_tbl(1).last_update_date;

1901: OE_ORDER_UTIL.g_line_tbl(l_index).flow_status_code:=p_flow_status_code;
1902: OE_ORDER_UTIL.g_line_tbl(l_index).lock_control:=l_line_tbl(1).lock_control;
1903: OE_ORDER_UTIL.g_line_tbl(l_index).line_id:=l_line_tbl(1).line_id;
1904: OE_ORDER_UTIL.g_line_tbl(l_index).header_id:=l_line_tbl(1).header_id;
1905: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_date:=l_line_tbl(1).last_update_date;
1906: OE_ORDER_UTIL.g_line_tbl(l_index).operation:=OE_GLOBALS.G_OPR_UPDATE;
1907: IF l_debug_level > 0 THEN
1908: oe_debug_pub.add( 'GLOBAL LINE FLOW STATUS IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_INDEX ) .FLOW_STATUS_CODE , 1 ) ;
1909: oe_debug_pub.add( 'GLOBAL LINE OPERATION IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_INDEX ) .OPERATION , 1 ) ;

Line 1906: OE_ORDER_UTIL.g_line_tbl(l_index).operation:=OE_GLOBALS.G_OPR_UPDATE;

1902: OE_ORDER_UTIL.g_line_tbl(l_index).lock_control:=l_line_tbl(1).lock_control;
1903: OE_ORDER_UTIL.g_line_tbl(l_index).line_id:=l_line_tbl(1).line_id;
1904: OE_ORDER_UTIL.g_line_tbl(l_index).header_id:=l_line_tbl(1).header_id;
1905: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_date:=l_line_tbl(1).last_update_date;
1906: OE_ORDER_UTIL.g_line_tbl(l_index).operation:=OE_GLOBALS.G_OPR_UPDATE;
1907: IF l_debug_level > 0 THEN
1908: oe_debug_pub.add( 'GLOBAL LINE FLOW STATUS IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_INDEX ) .FLOW_STATUS_CODE , 1 ) ;
1909: oe_debug_pub.add( 'GLOBAL LINE OPERATION IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_INDEX ) .OPERATION , 1 ) ;
1910: END IF;

Line 1908: oe_debug_pub.add( 'GLOBAL LINE FLOW STATUS IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_INDEX ) .FLOW_STATUS_CODE , 1 ) ;

1904: OE_ORDER_UTIL.g_line_tbl(l_index).header_id:=l_line_tbl(1).header_id;
1905: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_date:=l_line_tbl(1).last_update_date;
1906: OE_ORDER_UTIL.g_line_tbl(l_index).operation:=OE_GLOBALS.G_OPR_UPDATE;
1907: IF l_debug_level > 0 THEN
1908: oe_debug_pub.add( 'GLOBAL LINE FLOW STATUS IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_INDEX ) .FLOW_STATUS_CODE , 1 ) ;
1909: oe_debug_pub.add( 'GLOBAL LINE OPERATION IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_INDEX ) .OPERATION , 1 ) ;
1910: END IF;
1911: END IF;
1912: -- bug 4732614

Line 1909: oe_debug_pub.add( 'GLOBAL LINE OPERATION IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_INDEX ) .OPERATION , 1 ) ;

1905: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_date:=l_line_tbl(1).last_update_date;
1906: OE_ORDER_UTIL.g_line_tbl(l_index).operation:=OE_GLOBALS.G_OPR_UPDATE;
1907: IF l_debug_level > 0 THEN
1908: oe_debug_pub.add( 'GLOBAL LINE FLOW STATUS IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_INDEX ) .FLOW_STATUS_CODE , 1 ) ;
1909: oe_debug_pub.add( 'GLOBAL LINE OPERATION IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_INDEX ) .OPERATION , 1 ) ;
1910: END IF;
1911: END IF;
1912: -- bug 4732614
1913: IF l_debug_level > 0 THEN

Line 2026: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,

2022: (p_validation_entity_id => OE_PC_GLOBALS.G_ENTITY_HEADER);
2023:
2024: -- added for notification framework
2025: -- calling notification framework to get index position
2026: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,
2027: p_old_header_rec => l_old_header_rec,
2028: p_Header_rec =>l_header_rec,
2029: p_header_id => p_header_id,
2030: x_index => l_index,

Line 2044: OE_ORDER_UTIL.g_header_rec := OE_ORDER_UTIL.g_old_header_rec;

2040: END IF;
2041:
2042: IF l_index is not NULL THEN
2043: -- update global picture directly
2044: OE_ORDER_UTIL.g_header_rec := OE_ORDER_UTIL.g_old_header_rec;
2045: OE_ORDER_UTIL.g_header_rec.flow_status_code:=p_flow_status_code;
2046: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
2047: OE_ORDER_UTIL.g_header_rec.operation:=OE_GLOBALS.G_OPR_UPDATE;
2048: IF l_debug_level > 0 THEN

Line 2045: OE_ORDER_UTIL.g_header_rec.flow_status_code:=p_flow_status_code;

2041:
2042: IF l_index is not NULL THEN
2043: -- update global picture directly
2044: OE_ORDER_UTIL.g_header_rec := OE_ORDER_UTIL.g_old_header_rec;
2045: OE_ORDER_UTIL.g_header_rec.flow_status_code:=p_flow_status_code;
2046: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
2047: OE_ORDER_UTIL.g_header_rec.operation:=OE_GLOBALS.G_OPR_UPDATE;
2048: IF l_debug_level > 0 THEN
2049: oe_debug_pub.add( 'GLOBAL HEADER FLOW STATUS IS: ' || OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE , 1 ) ;

Line 2046: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;

2042: IF l_index is not NULL THEN
2043: -- update global picture directly
2044: OE_ORDER_UTIL.g_header_rec := OE_ORDER_UTIL.g_old_header_rec;
2045: OE_ORDER_UTIL.g_header_rec.flow_status_code:=p_flow_status_code;
2046: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
2047: OE_ORDER_UTIL.g_header_rec.operation:=OE_GLOBALS.G_OPR_UPDATE;
2048: IF l_debug_level > 0 THEN
2049: oe_debug_pub.add( 'GLOBAL HEADER FLOW STATUS IS: ' || OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE , 1 ) ;
2050: oe_debug_pub.add( 'GLOBAL HEADER OPERATION IS: ' || OE_ORDER_UTIL.G_HEADER_REC.OPERATION , 1 ) ;

Line 2047: OE_ORDER_UTIL.g_header_rec.operation:=OE_GLOBALS.G_OPR_UPDATE;

2043: -- update global picture directly
2044: OE_ORDER_UTIL.g_header_rec := OE_ORDER_UTIL.g_old_header_rec;
2045: OE_ORDER_UTIL.g_header_rec.flow_status_code:=p_flow_status_code;
2046: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
2047: OE_ORDER_UTIL.g_header_rec.operation:=OE_GLOBALS.G_OPR_UPDATE;
2048: IF l_debug_level > 0 THEN
2049: oe_debug_pub.add( 'GLOBAL HEADER FLOW STATUS IS: ' || OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE , 1 ) ;
2050: oe_debug_pub.add( 'GLOBAL HEADER OPERATION IS: ' || OE_ORDER_UTIL.G_HEADER_REC.OPERATION , 1 ) ;
2051: END IF;

Line 2049: oe_debug_pub.add( 'GLOBAL HEADER FLOW STATUS IS: ' || OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE , 1 ) ;

2045: OE_ORDER_UTIL.g_header_rec.flow_status_code:=p_flow_status_code;
2046: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
2047: OE_ORDER_UTIL.g_header_rec.operation:=OE_GLOBALS.G_OPR_UPDATE;
2048: IF l_debug_level > 0 THEN
2049: oe_debug_pub.add( 'GLOBAL HEADER FLOW STATUS IS: ' || OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE , 1 ) ;
2050: oe_debug_pub.add( 'GLOBAL HEADER OPERATION IS: ' || OE_ORDER_UTIL.G_HEADER_REC.OPERATION , 1 ) ;
2051: END IF;
2052: END IF;
2053: -- bug 4732614

Line 2050: oe_debug_pub.add( 'GLOBAL HEADER OPERATION IS: ' || OE_ORDER_UTIL.G_HEADER_REC.OPERATION , 1 ) ;

2046: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
2047: OE_ORDER_UTIL.g_header_rec.operation:=OE_GLOBALS.G_OPR_UPDATE;
2048: IF l_debug_level > 0 THEN
2049: oe_debug_pub.add( 'GLOBAL HEADER FLOW STATUS IS: ' || OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE , 1 ) ;
2050: oe_debug_pub.add( 'GLOBAL HEADER OPERATION IS: ' || OE_ORDER_UTIL.G_HEADER_REC.OPERATION , 1 ) ;
2051: END IF;
2052: END IF;
2053: -- bug 4732614
2054: IF l_debug_level > 0 THEN

Line 2088: oe_debug_pub.add('UFSC: GLOBAL RECURSION WITHOUT EXCEPTION: ' || OE_ORDER_UTIL.G_RECURSION_WITHOUT_EXCEPTION) ;

2084: OE_PC_Constraints_Admin_PVT.Clear_Cached_Results;
2085:
2086: IF l_debug_level > 0 THEN
2087: oe_debug_pub.add('ENTERING UPDATE_FLOW_STATUS_CODE' , 5 ) ;
2088: oe_debug_pub.add('UFSC: GLOBAL RECURSION WITHOUT EXCEPTION: ' || OE_ORDER_UTIL.G_RECURSION_WITHOUT_EXCEPTION) ;
2089: oe_debug_pub.add('UFSC: GLOBAL CACHE BOOKED FLAG' || OE_ORDER_CACHE.G_HEADER_REC.BOOKED_FLAG ) ;
2090: oe_debug_pub.add('UFSC: GLOBAL PICTURE HEADER BOOKED FLAG' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_FLAG ) ;
2091: oe_debug_pub.add('UFSC: COUNT OF NEW LINE TABLE= '|| OE_ORDER_UTIL.G_LINE_TBL.COUNT ) ;
2092: oe_debug_pub.add('UFSC: COUNT OF OLD LINE TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_TBL.COUNT ) ;

Line 2090: oe_debug_pub.add('UFSC: GLOBAL PICTURE HEADER BOOKED FLAG' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_FLAG ) ;

2086: IF l_debug_level > 0 THEN
2087: oe_debug_pub.add('ENTERING UPDATE_FLOW_STATUS_CODE' , 5 ) ;
2088: oe_debug_pub.add('UFSC: GLOBAL RECURSION WITHOUT EXCEPTION: ' || OE_ORDER_UTIL.G_RECURSION_WITHOUT_EXCEPTION) ;
2089: oe_debug_pub.add('UFSC: GLOBAL CACHE BOOKED FLAG' || OE_ORDER_CACHE.G_HEADER_REC.BOOKED_FLAG ) ;
2090: oe_debug_pub.add('UFSC: GLOBAL PICTURE HEADER BOOKED FLAG' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_FLAG ) ;
2091: oe_debug_pub.add('UFSC: COUNT OF NEW LINE TABLE= '|| OE_ORDER_UTIL.G_LINE_TBL.COUNT ) ;
2092: oe_debug_pub.add('UFSC: COUNT OF OLD LINE TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_TBL.COUNT ) ;
2093: oe_debug_pub.add('UFSC: COUNT OF NEW LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_LINE_ADJ_TBL.COUNT ) ;
2094: oe_debug_pub.add('UFSC: COUNT OF OLD LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_ADJ_TBL.COUNT ) ;

Line 2091: oe_debug_pub.add('UFSC: COUNT OF NEW LINE TABLE= '|| OE_ORDER_UTIL.G_LINE_TBL.COUNT ) ;

2087: oe_debug_pub.add('ENTERING UPDATE_FLOW_STATUS_CODE' , 5 ) ;
2088: oe_debug_pub.add('UFSC: GLOBAL RECURSION WITHOUT EXCEPTION: ' || OE_ORDER_UTIL.G_RECURSION_WITHOUT_EXCEPTION) ;
2089: oe_debug_pub.add('UFSC: GLOBAL CACHE BOOKED FLAG' || OE_ORDER_CACHE.G_HEADER_REC.BOOKED_FLAG ) ;
2090: oe_debug_pub.add('UFSC: GLOBAL PICTURE HEADER BOOKED FLAG' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_FLAG ) ;
2091: oe_debug_pub.add('UFSC: COUNT OF NEW LINE TABLE= '|| OE_ORDER_UTIL.G_LINE_TBL.COUNT ) ;
2092: oe_debug_pub.add('UFSC: COUNT OF OLD LINE TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_TBL.COUNT ) ;
2093: oe_debug_pub.add('UFSC: COUNT OF NEW LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_LINE_ADJ_TBL.COUNT ) ;
2094: oe_debug_pub.add('UFSC: COUNT OF OLD LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_ADJ_TBL.COUNT ) ;
2095: oe_debug_pub.add('UFSC: COUNT OF NEW HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_HEADER_ADJ_TBL.COUNT ) ;

Line 2092: oe_debug_pub.add('UFSC: COUNT OF OLD LINE TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_TBL.COUNT ) ;

2088: oe_debug_pub.add('UFSC: GLOBAL RECURSION WITHOUT EXCEPTION: ' || OE_ORDER_UTIL.G_RECURSION_WITHOUT_EXCEPTION) ;
2089: oe_debug_pub.add('UFSC: GLOBAL CACHE BOOKED FLAG' || OE_ORDER_CACHE.G_HEADER_REC.BOOKED_FLAG ) ;
2090: oe_debug_pub.add('UFSC: GLOBAL PICTURE HEADER BOOKED FLAG' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_FLAG ) ;
2091: oe_debug_pub.add('UFSC: COUNT OF NEW LINE TABLE= '|| OE_ORDER_UTIL.G_LINE_TBL.COUNT ) ;
2092: oe_debug_pub.add('UFSC: COUNT OF OLD LINE TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_TBL.COUNT ) ;
2093: oe_debug_pub.add('UFSC: COUNT OF NEW LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_LINE_ADJ_TBL.COUNT ) ;
2094: oe_debug_pub.add('UFSC: COUNT OF OLD LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_ADJ_TBL.COUNT ) ;
2095: oe_debug_pub.add('UFSC: COUNT OF NEW HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_HEADER_ADJ_TBL.COUNT ) ;
2096: oe_debug_pub.add('UFSC: COUNT OF OLD HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_ADJ_TBL.COUNT ) ;

Line 2093: oe_debug_pub.add('UFSC: COUNT OF NEW LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_LINE_ADJ_TBL.COUNT ) ;

2089: oe_debug_pub.add('UFSC: GLOBAL CACHE BOOKED FLAG' || OE_ORDER_CACHE.G_HEADER_REC.BOOKED_FLAG ) ;
2090: oe_debug_pub.add('UFSC: GLOBAL PICTURE HEADER BOOKED FLAG' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_FLAG ) ;
2091: oe_debug_pub.add('UFSC: COUNT OF NEW LINE TABLE= '|| OE_ORDER_UTIL.G_LINE_TBL.COUNT ) ;
2092: oe_debug_pub.add('UFSC: COUNT OF OLD LINE TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_TBL.COUNT ) ;
2093: oe_debug_pub.add('UFSC: COUNT OF NEW LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_LINE_ADJ_TBL.COUNT ) ;
2094: oe_debug_pub.add('UFSC: COUNT OF OLD LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_ADJ_TBL.COUNT ) ;
2095: oe_debug_pub.add('UFSC: COUNT OF NEW HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_HEADER_ADJ_TBL.COUNT ) ;
2096: oe_debug_pub.add('UFSC: COUNT OF OLD HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_ADJ_TBL.COUNT ) ;
2097: oe_debug_pub.add('UFSC: COUNT OF NEW HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_HEADER_SCREDIT_TBL.COUNT ) ;

Line 2094: oe_debug_pub.add('UFSC: COUNT OF OLD LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_ADJ_TBL.COUNT ) ;

2090: oe_debug_pub.add('UFSC: GLOBAL PICTURE HEADER BOOKED FLAG' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_FLAG ) ;
2091: oe_debug_pub.add('UFSC: COUNT OF NEW LINE TABLE= '|| OE_ORDER_UTIL.G_LINE_TBL.COUNT ) ;
2092: oe_debug_pub.add('UFSC: COUNT OF OLD LINE TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_TBL.COUNT ) ;
2093: oe_debug_pub.add('UFSC: COUNT OF NEW LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_LINE_ADJ_TBL.COUNT ) ;
2094: oe_debug_pub.add('UFSC: COUNT OF OLD LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_ADJ_TBL.COUNT ) ;
2095: oe_debug_pub.add('UFSC: COUNT OF NEW HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_HEADER_ADJ_TBL.COUNT ) ;
2096: oe_debug_pub.add('UFSC: COUNT OF OLD HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_ADJ_TBL.COUNT ) ;
2097: oe_debug_pub.add('UFSC: COUNT OF NEW HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_HEADER_SCREDIT_TBL.COUNT ) ;
2098: oe_debug_pub.add('UFSC: COUNT OF OLD HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_SCREDIT_TBL.COUNT ) ;

Line 2095: oe_debug_pub.add('UFSC: COUNT OF NEW HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_HEADER_ADJ_TBL.COUNT ) ;

2091: oe_debug_pub.add('UFSC: COUNT OF NEW LINE TABLE= '|| OE_ORDER_UTIL.G_LINE_TBL.COUNT ) ;
2092: oe_debug_pub.add('UFSC: COUNT OF OLD LINE TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_TBL.COUNT ) ;
2093: oe_debug_pub.add('UFSC: COUNT OF NEW LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_LINE_ADJ_TBL.COUNT ) ;
2094: oe_debug_pub.add('UFSC: COUNT OF OLD LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_ADJ_TBL.COUNT ) ;
2095: oe_debug_pub.add('UFSC: COUNT OF NEW HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_HEADER_ADJ_TBL.COUNT ) ;
2096: oe_debug_pub.add('UFSC: COUNT OF OLD HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_ADJ_TBL.COUNT ) ;
2097: oe_debug_pub.add('UFSC: COUNT OF NEW HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_HEADER_SCREDIT_TBL.COUNT ) ;
2098: oe_debug_pub.add('UFSC: COUNT OF OLD HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_SCREDIT_TBL.COUNT ) ;
2099: oe_debug_pub.add('UFSC: COUNT OF NEW LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_LINE_SCREDIT_TBL.COUNT ) ;

Line 2096: oe_debug_pub.add('UFSC: COUNT OF OLD HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_ADJ_TBL.COUNT ) ;

2092: oe_debug_pub.add('UFSC: COUNT OF OLD LINE TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_TBL.COUNT ) ;
2093: oe_debug_pub.add('UFSC: COUNT OF NEW LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_LINE_ADJ_TBL.COUNT ) ;
2094: oe_debug_pub.add('UFSC: COUNT OF OLD LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_ADJ_TBL.COUNT ) ;
2095: oe_debug_pub.add('UFSC: COUNT OF NEW HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_HEADER_ADJ_TBL.COUNT ) ;
2096: oe_debug_pub.add('UFSC: COUNT OF OLD HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_ADJ_TBL.COUNT ) ;
2097: oe_debug_pub.add('UFSC: COUNT OF NEW HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_HEADER_SCREDIT_TBL.COUNT ) ;
2098: oe_debug_pub.add('UFSC: COUNT OF OLD HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_SCREDIT_TBL.COUNT ) ;
2099: oe_debug_pub.add('UFSC: COUNT OF NEW LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_LINE_SCREDIT_TBL.COUNT ) ;
2100: oe_debug_pub.add('UFSC: COUNT OF OLD LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_SCREDIT_TBL.COUNT ) ;

Line 2097: oe_debug_pub.add('UFSC: COUNT OF NEW HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_HEADER_SCREDIT_TBL.COUNT ) ;

2093: oe_debug_pub.add('UFSC: COUNT OF NEW LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_LINE_ADJ_TBL.COUNT ) ;
2094: oe_debug_pub.add('UFSC: COUNT OF OLD LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_ADJ_TBL.COUNT ) ;
2095: oe_debug_pub.add('UFSC: COUNT OF NEW HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_HEADER_ADJ_TBL.COUNT ) ;
2096: oe_debug_pub.add('UFSC: COUNT OF OLD HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_ADJ_TBL.COUNT ) ;
2097: oe_debug_pub.add('UFSC: COUNT OF NEW HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_HEADER_SCREDIT_TBL.COUNT ) ;
2098: oe_debug_pub.add('UFSC: COUNT OF OLD HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_SCREDIT_TBL.COUNT ) ;
2099: oe_debug_pub.add('UFSC: COUNT OF NEW LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_LINE_SCREDIT_TBL.COUNT ) ;
2100: oe_debug_pub.add('UFSC: COUNT OF OLD LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_SCREDIT_TBL.COUNT ) ;
2101: oe_debug_pub.add('UFSC: COUNT OF NEW LOT SERIAL TABLE= '|| OE_ORDER_UTIL.G_LOT_SERIAL_TBL.COUNT ) ;

Line 2098: oe_debug_pub.add('UFSC: COUNT OF OLD HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_SCREDIT_TBL.COUNT ) ;

2094: oe_debug_pub.add('UFSC: COUNT OF OLD LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_ADJ_TBL.COUNT ) ;
2095: oe_debug_pub.add('UFSC: COUNT OF NEW HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_HEADER_ADJ_TBL.COUNT ) ;
2096: oe_debug_pub.add('UFSC: COUNT OF OLD HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_ADJ_TBL.COUNT ) ;
2097: oe_debug_pub.add('UFSC: COUNT OF NEW HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_HEADER_SCREDIT_TBL.COUNT ) ;
2098: oe_debug_pub.add('UFSC: COUNT OF OLD HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_SCREDIT_TBL.COUNT ) ;
2099: oe_debug_pub.add('UFSC: COUNT OF NEW LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_LINE_SCREDIT_TBL.COUNT ) ;
2100: oe_debug_pub.add('UFSC: COUNT OF OLD LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_SCREDIT_TBL.COUNT ) ;
2101: oe_debug_pub.add('UFSC: COUNT OF NEW LOT SERIAL TABLE= '|| OE_ORDER_UTIL.G_LOT_SERIAL_TBL.COUNT ) ;
2102: oe_debug_pub.add('UFSC: COUNT OF OLD LOT SERIAL TABLE= '|| OE_ORDER_UTIL.G_OLD_LOT_SERIAL_TBL.COUNT ) ;

Line 2099: oe_debug_pub.add('UFSC: COUNT OF NEW LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_LINE_SCREDIT_TBL.COUNT ) ;

2095: oe_debug_pub.add('UFSC: COUNT OF NEW HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_HEADER_ADJ_TBL.COUNT ) ;
2096: oe_debug_pub.add('UFSC: COUNT OF OLD HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_ADJ_TBL.COUNT ) ;
2097: oe_debug_pub.add('UFSC: COUNT OF NEW HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_HEADER_SCREDIT_TBL.COUNT ) ;
2098: oe_debug_pub.add('UFSC: COUNT OF OLD HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_SCREDIT_TBL.COUNT ) ;
2099: oe_debug_pub.add('UFSC: COUNT OF NEW LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_LINE_SCREDIT_TBL.COUNT ) ;
2100: oe_debug_pub.add('UFSC: COUNT OF OLD LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_SCREDIT_TBL.COUNT ) ;
2101: oe_debug_pub.add('UFSC: COUNT OF NEW LOT SERIAL TABLE= '|| OE_ORDER_UTIL.G_LOT_SERIAL_TBL.COUNT ) ;
2102: oe_debug_pub.add('UFSC: COUNT OF OLD LOT SERIAL TABLE= '|| OE_ORDER_UTIL.G_OLD_LOT_SERIAL_TBL.COUNT ) ;
2103: oe_debug_pub.add('EXITING UPDATE_FLOW_STATUS_CODE' , 5 ) ;

Line 2100: oe_debug_pub.add('UFSC: COUNT OF OLD LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_SCREDIT_TBL.COUNT ) ;

2096: oe_debug_pub.add('UFSC: COUNT OF OLD HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_ADJ_TBL.COUNT ) ;
2097: oe_debug_pub.add('UFSC: COUNT OF NEW HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_HEADER_SCREDIT_TBL.COUNT ) ;
2098: oe_debug_pub.add('UFSC: COUNT OF OLD HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_SCREDIT_TBL.COUNT ) ;
2099: oe_debug_pub.add('UFSC: COUNT OF NEW LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_LINE_SCREDIT_TBL.COUNT ) ;
2100: oe_debug_pub.add('UFSC: COUNT OF OLD LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_SCREDIT_TBL.COUNT ) ;
2101: oe_debug_pub.add('UFSC: COUNT OF NEW LOT SERIAL TABLE= '|| OE_ORDER_UTIL.G_LOT_SERIAL_TBL.COUNT ) ;
2102: oe_debug_pub.add('UFSC: COUNT OF OLD LOT SERIAL TABLE= '|| OE_ORDER_UTIL.G_OLD_LOT_SERIAL_TBL.COUNT ) ;
2103: oe_debug_pub.add('EXITING UPDATE_FLOW_STATUS_CODE' , 5 ) ;
2104: END IF;

Line 2101: oe_debug_pub.add('UFSC: COUNT OF NEW LOT SERIAL TABLE= '|| OE_ORDER_UTIL.G_LOT_SERIAL_TBL.COUNT ) ;

2097: oe_debug_pub.add('UFSC: COUNT OF NEW HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_HEADER_SCREDIT_TBL.COUNT ) ;
2098: oe_debug_pub.add('UFSC: COUNT OF OLD HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_SCREDIT_TBL.COUNT ) ;
2099: oe_debug_pub.add('UFSC: COUNT OF NEW LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_LINE_SCREDIT_TBL.COUNT ) ;
2100: oe_debug_pub.add('UFSC: COUNT OF OLD LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_SCREDIT_TBL.COUNT ) ;
2101: oe_debug_pub.add('UFSC: COUNT OF NEW LOT SERIAL TABLE= '|| OE_ORDER_UTIL.G_LOT_SERIAL_TBL.COUNT ) ;
2102: oe_debug_pub.add('UFSC: COUNT OF OLD LOT SERIAL TABLE= '|| OE_ORDER_UTIL.G_OLD_LOT_SERIAL_TBL.COUNT ) ;
2103: oe_debug_pub.add('EXITING UPDATE_FLOW_STATUS_CODE' , 5 ) ;
2104: END IF;
2105:

Line 2102: oe_debug_pub.add('UFSC: COUNT OF OLD LOT SERIAL TABLE= '|| OE_ORDER_UTIL.G_OLD_LOT_SERIAL_TBL.COUNT ) ;

2098: oe_debug_pub.add('UFSC: COUNT OF OLD HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_SCREDIT_TBL.COUNT ) ;
2099: oe_debug_pub.add('UFSC: COUNT OF NEW LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_LINE_SCREDIT_TBL.COUNT ) ;
2100: oe_debug_pub.add('UFSC: COUNT OF OLD LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_SCREDIT_TBL.COUNT ) ;
2101: oe_debug_pub.add('UFSC: COUNT OF NEW LOT SERIAL TABLE= '|| OE_ORDER_UTIL.G_LOT_SERIAL_TBL.COUNT ) ;
2102: oe_debug_pub.add('UFSC: COUNT OF OLD LOT SERIAL TABLE= '|| OE_ORDER_UTIL.G_OLD_LOT_SERIAL_TBL.COUNT ) ;
2103: oe_debug_pub.add('EXITING UPDATE_FLOW_STATUS_CODE' , 5 ) ;
2104: END IF;
2105:
2106: EXCEPTION

Line 2446: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,

2442: (p_validation_entity_id => OE_PC_GLOBALS.G_ENTITY_HEADER);
2443:
2444: -- added for notification framework
2445: -- calling notification framework to get index position
2446: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,
2447: p_old_header_rec => l_old_header_rec,
2448: p_Header_rec =>l_header_rec,
2449: p_header_id => l_header_id,
2450: x_index => l_index,

Line 2465: OE_ORDER_UTIL.g_header_rec := OE_ORDER_UTIL.g_old_header_rec;

2461: END IF;
2462:
2463: IF l_index is not NULL THEN
2464: -- update global picture directly
2465: OE_ORDER_UTIL.g_header_rec := OE_ORDER_UTIL.g_old_header_rec;
2466: IF p_flow_status_code is not null THEN
2467: OE_ORDER_UTIL.g_header_rec.flow_status_code:=p_flow_status_code;
2468: END IF;
2469: IF p_open_flag is not null THEN

Line 2467: OE_ORDER_UTIL.g_header_rec.flow_status_code:=p_flow_status_code;

2463: IF l_index is not NULL THEN
2464: -- update global picture directly
2465: OE_ORDER_UTIL.g_header_rec := OE_ORDER_UTIL.g_old_header_rec;
2466: IF p_flow_status_code is not null THEN
2467: OE_ORDER_UTIL.g_header_rec.flow_status_code:=p_flow_status_code;
2468: END IF;
2469: IF p_open_flag is not null THEN
2470: OE_ORDER_UTIL.g_header_rec.open_flag:=p_open_flag;
2471: END IF;

Line 2470: OE_ORDER_UTIL.g_header_rec.open_flag:=p_open_flag;

2466: IF p_flow_status_code is not null THEN
2467: OE_ORDER_UTIL.g_header_rec.flow_status_code:=p_flow_status_code;
2468: END IF;
2469: IF p_open_flag is not null THEN
2470: OE_ORDER_UTIL.g_header_rec.open_flag:=p_open_flag;
2471: END IF;
2472: IF p_draft_submitted_flag is not null THEN
2473: OE_ORDER_UTIL.g_header_rec.draft_submitted_flag:=p_draft_submitted_flag;
2474: END IF;

Line 2473: OE_ORDER_UTIL.g_header_rec.draft_submitted_flag:=p_draft_submitted_flag;

2469: IF p_open_flag is not null THEN
2470: OE_ORDER_UTIL.g_header_rec.open_flag:=p_open_flag;
2471: END IF;
2472: IF p_draft_submitted_flag is not null THEN
2473: OE_ORDER_UTIL.g_header_rec.draft_submitted_flag:=p_draft_submitted_flag;
2474: END IF;
2475: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
2476: OE_ORDER_UTIL.g_header_rec.operation:=OE_GLOBALS.G_OPR_UPDATE;
2477: IF l_debug_level > 0 THEN

Line 2475: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;

2471: END IF;
2472: IF p_draft_submitted_flag is not null THEN
2473: OE_ORDER_UTIL.g_header_rec.draft_submitted_flag:=p_draft_submitted_flag;
2474: END IF;
2475: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
2476: OE_ORDER_UTIL.g_header_rec.operation:=OE_GLOBALS.G_OPR_UPDATE;
2477: IF l_debug_level > 0 THEN
2478: oe_debug_pub.add( 'GLOBAL HEADER FLOW STATUS IS: ' || OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE , 1 );
2479: oe_debug_pub.add( 'GLOBAL HEADER OPEN_FLAG IS: ' || OE_ORDER_UTIL.G_HEADER_REC.OPEN_FLAG , 1 );

Line 2476: OE_ORDER_UTIL.g_header_rec.operation:=OE_GLOBALS.G_OPR_UPDATE;

2472: IF p_draft_submitted_flag is not null THEN
2473: OE_ORDER_UTIL.g_header_rec.draft_submitted_flag:=p_draft_submitted_flag;
2474: END IF;
2475: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
2476: OE_ORDER_UTIL.g_header_rec.operation:=OE_GLOBALS.G_OPR_UPDATE;
2477: IF l_debug_level > 0 THEN
2478: oe_debug_pub.add( 'GLOBAL HEADER FLOW STATUS IS: ' || OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE , 1 );
2479: oe_debug_pub.add( 'GLOBAL HEADER OPEN_FLAG IS: ' || OE_ORDER_UTIL.G_HEADER_REC.OPEN_FLAG , 1 );
2480: oe_debug_pub.add( 'GLOBAL HEADER DRAFT_SUBMITTED_FLAG IS: ' || OE_ORDER_UTIL.G_HEADER_REC.DRAFT_SUBMITTED_FLAG , 1 );

Line 2478: oe_debug_pub.add( 'GLOBAL HEADER FLOW STATUS IS: ' || OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE , 1 );

2474: END IF;
2475: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
2476: OE_ORDER_UTIL.g_header_rec.operation:=OE_GLOBALS.G_OPR_UPDATE;
2477: IF l_debug_level > 0 THEN
2478: oe_debug_pub.add( 'GLOBAL HEADER FLOW STATUS IS: ' || OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE , 1 );
2479: oe_debug_pub.add( 'GLOBAL HEADER OPEN_FLAG IS: ' || OE_ORDER_UTIL.G_HEADER_REC.OPEN_FLAG , 1 );
2480: oe_debug_pub.add( 'GLOBAL HEADER DRAFT_SUBMITTED_FLAG IS: ' || OE_ORDER_UTIL.G_HEADER_REC.DRAFT_SUBMITTED_FLAG , 1 );
2481: oe_debug_pub.add( 'GLOBAL HEADER OPERATION IS: ' || OE_ORDER_UTIL.G_HEADER_REC.OPERATION , 1 ) ;
2482: END IF;

Line 2479: oe_debug_pub.add( 'GLOBAL HEADER OPEN_FLAG IS: ' || OE_ORDER_UTIL.G_HEADER_REC.OPEN_FLAG , 1 );

2475: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
2476: OE_ORDER_UTIL.g_header_rec.operation:=OE_GLOBALS.G_OPR_UPDATE;
2477: IF l_debug_level > 0 THEN
2478: oe_debug_pub.add( 'GLOBAL HEADER FLOW STATUS IS: ' || OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE , 1 );
2479: oe_debug_pub.add( 'GLOBAL HEADER OPEN_FLAG IS: ' || OE_ORDER_UTIL.G_HEADER_REC.OPEN_FLAG , 1 );
2480: oe_debug_pub.add( 'GLOBAL HEADER DRAFT_SUBMITTED_FLAG IS: ' || OE_ORDER_UTIL.G_HEADER_REC.DRAFT_SUBMITTED_FLAG , 1 );
2481: oe_debug_pub.add( 'GLOBAL HEADER OPERATION IS: ' || OE_ORDER_UTIL.G_HEADER_REC.OPERATION , 1 ) ;
2482: END IF;
2483: END IF;

Line 2480: oe_debug_pub.add( 'GLOBAL HEADER DRAFT_SUBMITTED_FLAG IS: ' || OE_ORDER_UTIL.G_HEADER_REC.DRAFT_SUBMITTED_FLAG , 1 );

2476: OE_ORDER_UTIL.g_header_rec.operation:=OE_GLOBALS.G_OPR_UPDATE;
2477: IF l_debug_level > 0 THEN
2478: oe_debug_pub.add( 'GLOBAL HEADER FLOW STATUS IS: ' || OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE , 1 );
2479: oe_debug_pub.add( 'GLOBAL HEADER OPEN_FLAG IS: ' || OE_ORDER_UTIL.G_HEADER_REC.OPEN_FLAG , 1 );
2480: oe_debug_pub.add( 'GLOBAL HEADER DRAFT_SUBMITTED_FLAG IS: ' || OE_ORDER_UTIL.G_HEADER_REC.DRAFT_SUBMITTED_FLAG , 1 );
2481: oe_debug_pub.add( 'GLOBAL HEADER OPERATION IS: ' || OE_ORDER_UTIL.G_HEADER_REC.OPERATION , 1 ) ;
2482: END IF;
2483: END IF;
2484: -- bug 4732614

Line 2481: oe_debug_pub.add( 'GLOBAL HEADER OPERATION IS: ' || OE_ORDER_UTIL.G_HEADER_REC.OPERATION , 1 ) ;

2477: IF l_debug_level > 0 THEN
2478: oe_debug_pub.add( 'GLOBAL HEADER FLOW STATUS IS: ' || OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE , 1 );
2479: oe_debug_pub.add( 'GLOBAL HEADER OPEN_FLAG IS: ' || OE_ORDER_UTIL.G_HEADER_REC.OPEN_FLAG , 1 );
2480: oe_debug_pub.add( 'GLOBAL HEADER DRAFT_SUBMITTED_FLAG IS: ' || OE_ORDER_UTIL.G_HEADER_REC.DRAFT_SUBMITTED_FLAG , 1 );
2481: oe_debug_pub.add( 'GLOBAL HEADER OPERATION IS: ' || OE_ORDER_UTIL.G_HEADER_REC.OPERATION , 1 ) ;
2482: END IF;
2483: END IF;
2484: -- bug 4732614
2485: IF l_debug_level > 0 THEN

Line 3467: IF ( nvl(Oe_Order_Util.G_Precision,0) = 0 ) THEN

3463: select org_id into l_org_id from oe_order_headers_all where header_id = l_transaction_id;
3464: MO_GLOBAL.set_policy_context('S', l_org_id);
3465:
3466: -- Bug 6275663
3467: IF ( nvl(Oe_Order_Util.G_Precision,0) = 0 ) THEN
3468: l_prec_inited := Oe_Order_Util.Get_Precision (p_header_id => l_transaction_id);
3469: END IF;
3470:
3471: -- set fnd message titles for tables

Line 3468: l_prec_inited := Oe_Order_Util.Get_Precision (p_header_id => l_transaction_id);

3464: MO_GLOBAL.set_policy_context('S', l_org_id);
3465:
3466: -- Bug 6275663
3467: IF ( nvl(Oe_Order_Util.G_Precision,0) = 0 ) THEN
3468: l_prec_inited := Oe_Order_Util.Get_Precision (p_header_id => l_transaction_id);
3469: END IF;
3470:
3471: -- set fnd message titles for tables
3472: l_msg_quote := FND_MESSAGE.Get_String('ONT', 'OE_NTF_QUOTE');

Line 3502: l_order_margin_percent := Round(l_order_margin_percent, Oe_Order_Util.G_Precision); -- Bug 6275663

3498: OE_MARGIN_PVT.Get_Order_Margin ( p_header_id => l_transaction_id,
3499: x_order_margin_percent => l_order_margin_percent,
3500: x_order_margin_amount => l_order_margin_amount);
3501:
3502: l_order_margin_percent := Round(l_order_margin_percent, Oe_Order_Util.G_Precision); -- Bug 6275663
3503:
3504:
3505:
3506: select /* MOAC_SQL_CHANGE */ headers.CREATION_DATE,shipto.name,

Line 3665: l_line_margin_percent := Round(l_line_margin_percent, Oe_Order_Util.G_Precision); -- Bug 6275663

3661: x_unit_cost => l_unit_cost,
3662: x_unit_margin_amount => l_unit_margin_amount,
3663: x_margin_percent => l_line_margin_percent);
3664:
3665: l_line_margin_percent := Round(l_line_margin_percent, Oe_Order_Util.G_Precision); -- Bug 6275663
3666:
3667:
3668: l_document := l_document || '' || nvl(l_line.line_num, '&' || 'nbsp') || '';
3669: l_document := l_document || '' || nvl(l_line.item, '&' || 'nbsp') || '';