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_INVOICE_PUB dependencies on OE_ORDER_UTIL

Line 4776: OE_ORDER_UTIL.Update_Global_Picture

4772: -- jolin start
4773: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
4774:
4775: -- call notification framework to get header adj index position
4776: OE_ORDER_UTIL.Update_Global_Picture
4777: (p_Upd_New_Rec_If_Exists =>FALSE
4778: , p_hdr_adj_rec => l_Header_Adj_tbl(1)
4779: , p_old_hdr_adj_rec => l_Old_Header_Adj_tbl(1)
4780: , p_hdr_adj_id => l_Header_Adj_tbl(1).price_adjustment_id

Line 4791: OE_ORDER_UTIL.g_old_header_adj_tbl(l_notify_index) := l_old_header_adj_tbl(1);

4787: END IF;
4788:
4789: IF l_notify_index is not null then
4790: -- modify Global Picture
4791: OE_ORDER_UTIL.g_old_header_adj_tbl(l_notify_index) := l_old_header_adj_tbl(1);
4792: OE_ORDER_UTIL.g_header_adj_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_header_adj_tbl(l_notify_index);
4793: OE_ORDER_UTIL.g_header_adj_tbl(l_notify_index).invoiced_amount:=
4794: l_Header_Adj_tbl(1).invoiced_amount;
4795: OE_ORDER_UTIL.g_header_adj_tbl(l_notify_index).invoiced_flag:=

Line 4792: OE_ORDER_UTIL.g_header_adj_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_header_adj_tbl(l_notify_index);

4788:
4789: IF l_notify_index is not null then
4790: -- modify Global Picture
4791: OE_ORDER_UTIL.g_old_header_adj_tbl(l_notify_index) := l_old_header_adj_tbl(1);
4792: OE_ORDER_UTIL.g_header_adj_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_header_adj_tbl(l_notify_index);
4793: OE_ORDER_UTIL.g_header_adj_tbl(l_notify_index).invoiced_amount:=
4794: l_Header_Adj_tbl(1).invoiced_amount;
4795: OE_ORDER_UTIL.g_header_adj_tbl(l_notify_index).invoiced_flag:=
4796: l_Header_Adj_tbl(1).invoiced_flag;

Line 4793: OE_ORDER_UTIL.g_header_adj_tbl(l_notify_index).invoiced_amount:=

4789: IF l_notify_index is not null then
4790: -- modify Global Picture
4791: OE_ORDER_UTIL.g_old_header_adj_tbl(l_notify_index) := l_old_header_adj_tbl(1);
4792: OE_ORDER_UTIL.g_header_adj_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_header_adj_tbl(l_notify_index);
4793: OE_ORDER_UTIL.g_header_adj_tbl(l_notify_index).invoiced_amount:=
4794: l_Header_Adj_tbl(1).invoiced_amount;
4795: OE_ORDER_UTIL.g_header_adj_tbl(l_notify_index).invoiced_flag:=
4796: l_Header_Adj_tbl(1).invoiced_flag;
4797: OE_ORDER_UTIL.g_header_adj_tbl(l_notify_index).lock_control:=

Line 4795: OE_ORDER_UTIL.g_header_adj_tbl(l_notify_index).invoiced_flag:=

4791: OE_ORDER_UTIL.g_old_header_adj_tbl(l_notify_index) := l_old_header_adj_tbl(1);
4792: OE_ORDER_UTIL.g_header_adj_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_header_adj_tbl(l_notify_index);
4793: OE_ORDER_UTIL.g_header_adj_tbl(l_notify_index).invoiced_amount:=
4794: l_Header_Adj_tbl(1).invoiced_amount;
4795: OE_ORDER_UTIL.g_header_adj_tbl(l_notify_index).invoiced_flag:=
4796: l_Header_Adj_tbl(1).invoiced_flag;
4797: OE_ORDER_UTIL.g_header_adj_tbl(l_notify_index).lock_control:=
4798: l_header_adj_tbl(1).lock_control;
4799: OE_ORDER_UTIL.g_header_adj_tbl(l_notify_index).last_update_date:=

Line 4797: OE_ORDER_UTIL.g_header_adj_tbl(l_notify_index).lock_control:=

4793: OE_ORDER_UTIL.g_header_adj_tbl(l_notify_index).invoiced_amount:=
4794: l_Header_Adj_tbl(1).invoiced_amount;
4795: OE_ORDER_UTIL.g_header_adj_tbl(l_notify_index).invoiced_flag:=
4796: l_Header_Adj_tbl(1).invoiced_flag;
4797: OE_ORDER_UTIL.g_header_adj_tbl(l_notify_index).lock_control:=
4798: l_header_adj_tbl(1).lock_control;
4799: OE_ORDER_UTIL.g_header_adj_tbl(l_notify_index).last_update_date:=
4800: l_header_adj_tbl(1).last_update_date;
4801: OE_ORDER_UTIL.g_header_adj_tbl(l_notify_index).header_id:=

Line 4799: OE_ORDER_UTIL.g_header_adj_tbl(l_notify_index).last_update_date:=

4795: OE_ORDER_UTIL.g_header_adj_tbl(l_notify_index).invoiced_flag:=
4796: l_Header_Adj_tbl(1).invoiced_flag;
4797: OE_ORDER_UTIL.g_header_adj_tbl(l_notify_index).lock_control:=
4798: l_header_adj_tbl(1).lock_control;
4799: OE_ORDER_UTIL.g_header_adj_tbl(l_notify_index).last_update_date:=
4800: l_header_adj_tbl(1).last_update_date;
4801: OE_ORDER_UTIL.g_header_adj_tbl(l_notify_index).header_id:=
4802: l_header_adj_tbl(1).header_id;
4803: OE_ORDER_UTIL.g_header_adj_tbl(l_notify_index).line_id:=

Line 4801: OE_ORDER_UTIL.g_header_adj_tbl(l_notify_index).header_id:=

4797: OE_ORDER_UTIL.g_header_adj_tbl(l_notify_index).lock_control:=
4798: l_header_adj_tbl(1).lock_control;
4799: OE_ORDER_UTIL.g_header_adj_tbl(l_notify_index).last_update_date:=
4800: l_header_adj_tbl(1).last_update_date;
4801: OE_ORDER_UTIL.g_header_adj_tbl(l_notify_index).header_id:=
4802: l_header_adj_tbl(1).header_id;
4803: OE_ORDER_UTIL.g_header_adj_tbl(l_notify_index).line_id:=
4804: l_header_adj_tbl(1).line_id;
4805:

Line 4803: OE_ORDER_UTIL.g_header_adj_tbl(l_notify_index).line_id:=

4799: OE_ORDER_UTIL.g_header_adj_tbl(l_notify_index).last_update_date:=
4800: l_header_adj_tbl(1).last_update_date;
4801: OE_ORDER_UTIL.g_header_adj_tbl(l_notify_index).header_id:=
4802: l_header_adj_tbl(1).header_id;
4803: OE_ORDER_UTIL.g_header_adj_tbl(l_notify_index).line_id:=
4804: l_header_adj_tbl(1).line_id;
4805:
4806: IF l_debug_level > 0 THEN
4807: oe_debug_pub.add( 'GLOBAL HDR ADJ INVOICED_FLAG IS: ' || OE_ORDER_UTIL.G_HEADER_ADJ_TBL ( L_NOTIFY_INDEX ) .INVOICED_FLAG , 1 ) ;

Line 4807: oe_debug_pub.add( 'GLOBAL HDR ADJ INVOICED_FLAG IS: ' || OE_ORDER_UTIL.G_HEADER_ADJ_TBL ( L_NOTIFY_INDEX ) .INVOICED_FLAG , 1 ) ;

4803: OE_ORDER_UTIL.g_header_adj_tbl(l_notify_index).line_id:=
4804: l_header_adj_tbl(1).line_id;
4805:
4806: IF l_debug_level > 0 THEN
4807: oe_debug_pub.add( 'GLOBAL HDR ADJ INVOICED_FLAG IS: ' || OE_ORDER_UTIL.G_HEADER_ADJ_TBL ( L_NOTIFY_INDEX ) .INVOICED_FLAG , 1 ) ;
4808: oe_debug_pub.add( 'GLOBAL HDR ADJ LOCK_CONTROL IS: ' || OE_ORDER_UTIL.G_HEADER_ADJ_TBL ( L_NOTIFY_INDEX ) .LOCK_CONTROL , 1 ) ;
4809:
4810: END IF;
4811:

Line 4808: oe_debug_pub.add( 'GLOBAL HDR ADJ LOCK_CONTROL IS: ' || OE_ORDER_UTIL.G_HEADER_ADJ_TBL ( L_NOTIFY_INDEX ) .LOCK_CONTROL , 1 ) ;

4804: l_header_adj_tbl(1).line_id;
4805:
4806: IF l_debug_level > 0 THEN
4807: oe_debug_pub.add( 'GLOBAL HDR ADJ INVOICED_FLAG IS: ' || OE_ORDER_UTIL.G_HEADER_ADJ_TBL ( L_NOTIFY_INDEX ) .INVOICED_FLAG , 1 ) ;
4808: oe_debug_pub.add( 'GLOBAL HDR ADJ LOCK_CONTROL IS: ' || OE_ORDER_UTIL.G_HEADER_ADJ_TBL ( L_NOTIFY_INDEX ) .LOCK_CONTROL , 1 ) ;
4809:
4810: END IF;
4811:
4812: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 7550: OE_ORDER_UTIL.Update_Global_Picture

7546: -- jolin start
7547: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
7548:
7549: -- call notification framework to get this line's index position
7550: OE_ORDER_UTIL.Update_Global_Picture
7551: (p_Upd_New_Rec_If_Exists =>FALSE
7552: , p_line_rec => l_line_tbl(1)
7553: , p_old_line_rec => l_old_line_tbl(1)
7554: , p_line_id => l_line_tbl(1).line_id

Line 7571: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index) := l_old_line_tbl(1);

7567: END IF;
7568:
7569: IF l_notify_index is not null then
7570: -- modify Global Picture
7571: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index) := l_old_line_tbl(1);
7572: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
7573: OE_ORDER_UTIL.g_line_tbl(l_notify_index).invoice_interface_status_code:=
7574: l_line_tbl(1).invoice_interface_status_code;
7575: OE_ORDER_UTIL.g_line_tbl(l_notify_index).invoiced_quantity:=

Line 7572: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);

7568:
7569: IF l_notify_index is not null then
7570: -- modify Global Picture
7571: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index) := l_old_line_tbl(1);
7572: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
7573: OE_ORDER_UTIL.g_line_tbl(l_notify_index).invoice_interface_status_code:=
7574: l_line_tbl(1).invoice_interface_status_code;
7575: OE_ORDER_UTIL.g_line_tbl(l_notify_index).invoiced_quantity:=
7576: l_line_tbl(1).invoiced_quantity;

Line 7573: OE_ORDER_UTIL.g_line_tbl(l_notify_index).invoice_interface_status_code:=

7569: IF l_notify_index is not null then
7570: -- modify Global Picture
7571: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index) := l_old_line_tbl(1);
7572: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
7573: OE_ORDER_UTIL.g_line_tbl(l_notify_index).invoice_interface_status_code:=
7574: l_line_tbl(1).invoice_interface_status_code;
7575: OE_ORDER_UTIL.g_line_tbl(l_notify_index).invoiced_quantity:=
7576: l_line_tbl(1).invoiced_quantity;
7577: OE_ORDER_UTIL.g_line_tbl(l_notify_index).flow_status_code:=

Line 7575: OE_ORDER_UTIL.g_line_tbl(l_notify_index).invoiced_quantity:=

7571: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index) := l_old_line_tbl(1);
7572: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
7573: OE_ORDER_UTIL.g_line_tbl(l_notify_index).invoice_interface_status_code:=
7574: l_line_tbl(1).invoice_interface_status_code;
7575: OE_ORDER_UTIL.g_line_tbl(l_notify_index).invoiced_quantity:=
7576: l_line_tbl(1).invoiced_quantity;
7577: OE_ORDER_UTIL.g_line_tbl(l_notify_index).flow_status_code:=
7578: l_line_tbl(1).flow_status_code;
7579: OE_ORDER_UTIL.g_line_tbl(l_notify_index).calculate_price_flag:=

Line 7577: OE_ORDER_UTIL.g_line_tbl(l_notify_index).flow_status_code:=

7573: OE_ORDER_UTIL.g_line_tbl(l_notify_index).invoice_interface_status_code:=
7574: l_line_tbl(1).invoice_interface_status_code;
7575: OE_ORDER_UTIL.g_line_tbl(l_notify_index).invoiced_quantity:=
7576: l_line_tbl(1).invoiced_quantity;
7577: OE_ORDER_UTIL.g_line_tbl(l_notify_index).flow_status_code:=
7578: l_line_tbl(1).flow_status_code;
7579: OE_ORDER_UTIL.g_line_tbl(l_notify_index).calculate_price_flag:=
7580: l_line_tbl(1).calculate_price_flag;
7581: OE_ORDER_UTIL.g_line_tbl(l_notify_index).lock_control:=

Line 7579: OE_ORDER_UTIL.g_line_tbl(l_notify_index).calculate_price_flag:=

7575: OE_ORDER_UTIL.g_line_tbl(l_notify_index).invoiced_quantity:=
7576: l_line_tbl(1).invoiced_quantity;
7577: OE_ORDER_UTIL.g_line_tbl(l_notify_index).flow_status_code:=
7578: l_line_tbl(1).flow_status_code;
7579: OE_ORDER_UTIL.g_line_tbl(l_notify_index).calculate_price_flag:=
7580: l_line_tbl(1).calculate_price_flag;
7581: OE_ORDER_UTIL.g_line_tbl(l_notify_index).lock_control:=
7582: l_line_tbl(1).lock_control;
7583: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date:=

Line 7581: OE_ORDER_UTIL.g_line_tbl(l_notify_index).lock_control:=

7577: OE_ORDER_UTIL.g_line_tbl(l_notify_index).flow_status_code:=
7578: l_line_tbl(1).flow_status_code;
7579: OE_ORDER_UTIL.g_line_tbl(l_notify_index).calculate_price_flag:=
7580: l_line_tbl(1).calculate_price_flag;
7581: OE_ORDER_UTIL.g_line_tbl(l_notify_index).lock_control:=
7582: l_line_tbl(1).lock_control;
7583: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date:=
7584: l_line_tbl(1).last_update_date;
7585: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id:=

Line 7583: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date:=

7579: OE_ORDER_UTIL.g_line_tbl(l_notify_index).calculate_price_flag:=
7580: l_line_tbl(1).calculate_price_flag;
7581: OE_ORDER_UTIL.g_line_tbl(l_notify_index).lock_control:=
7582: l_line_tbl(1).lock_control;
7583: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date:=
7584: l_line_tbl(1).last_update_date;
7585: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id:=
7586: l_line_tbl(1).line_id;
7587: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id:=

Line 7585: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id:=

7581: OE_ORDER_UTIL.g_line_tbl(l_notify_index).lock_control:=
7582: l_line_tbl(1).lock_control;
7583: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date:=
7584: l_line_tbl(1).last_update_date;
7585: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id:=
7586: l_line_tbl(1).line_id;
7587: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id:=
7588: l_line_tbl(1).header_id;
7589:

Line 7587: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id:=

7583: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date:=
7584: l_line_tbl(1).last_update_date;
7585: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id:=
7586: l_line_tbl(1).line_id;
7587: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id:=
7588: l_line_tbl(1).header_id;
7589:
7590: IF l_debug_level > 0 THEN
7591: oe_debug_pub.add( 'GLOBAL LINE INVOICED_QUANTITY IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .INVOICED_QUANTITY , 1 ) ;

Line 7591: oe_debug_pub.add( 'GLOBAL LINE INVOICED_QUANTITY IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .INVOICED_QUANTITY , 1 ) ;

7587: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id:=
7588: l_line_tbl(1).header_id;
7589:
7590: IF l_debug_level > 0 THEN
7591: oe_debug_pub.add( 'GLOBAL LINE INVOICED_QUANTITY IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .INVOICED_QUANTITY , 1 ) ;
7592: oe_debug_pub.add( 'GLOBAL LINE CALCULATE_PRICE_FLAG IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .CALCULATE_PRICE_FLAG , 1 ) ;
7593: oe_debug_pub.add( 'GLOBAL LINE INVOICE_INTERFACE_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .INVOICE_INTERFACE_STATUS_CODE , 1 ) ;
7594: oe_debug_pub.add( 'GLOBAL LINE FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE , 1 ) ;
7595: END IF;

Line 7592: oe_debug_pub.add( 'GLOBAL LINE CALCULATE_PRICE_FLAG IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .CALCULATE_PRICE_FLAG , 1 ) ;

7588: l_line_tbl(1).header_id;
7589:
7590: IF l_debug_level > 0 THEN
7591: oe_debug_pub.add( 'GLOBAL LINE INVOICED_QUANTITY IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .INVOICED_QUANTITY , 1 ) ;
7592: oe_debug_pub.add( 'GLOBAL LINE CALCULATE_PRICE_FLAG IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .CALCULATE_PRICE_FLAG , 1 ) ;
7593: oe_debug_pub.add( 'GLOBAL LINE INVOICE_INTERFACE_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .INVOICE_INTERFACE_STATUS_CODE , 1 ) ;
7594: oe_debug_pub.add( 'GLOBAL LINE FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE , 1 ) ;
7595: END IF;
7596:

Line 7593: oe_debug_pub.add( 'GLOBAL LINE INVOICE_INTERFACE_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .INVOICE_INTERFACE_STATUS_CODE , 1 ) ;

7589:
7590: IF l_debug_level > 0 THEN
7591: oe_debug_pub.add( 'GLOBAL LINE INVOICED_QUANTITY IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .INVOICED_QUANTITY , 1 ) ;
7592: oe_debug_pub.add( 'GLOBAL LINE CALCULATE_PRICE_FLAG IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .CALCULATE_PRICE_FLAG , 1 ) ;
7593: oe_debug_pub.add( 'GLOBAL LINE INVOICE_INTERFACE_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .INVOICE_INTERFACE_STATUS_CODE , 1 ) ;
7594: oe_debug_pub.add( 'GLOBAL LINE FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE , 1 ) ;
7595: END IF;
7596:
7597: -- Process requests is TRUE so still need to call it, but don't need to notify

Line 7594: oe_debug_pub.add( 'GLOBAL LINE FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE , 1 ) ;

7590: IF l_debug_level > 0 THEN
7591: oe_debug_pub.add( 'GLOBAL LINE INVOICED_QUANTITY IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .INVOICED_QUANTITY , 1 ) ;
7592: oe_debug_pub.add( 'GLOBAL LINE CALCULATE_PRICE_FLAG IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .CALCULATE_PRICE_FLAG , 1 ) ;
7593: oe_debug_pub.add( 'GLOBAL LINE INVOICE_INTERFACE_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .INVOICE_INTERFACE_STATUS_CODE , 1 ) ;
7594: oe_debug_pub.add( 'GLOBAL LINE FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE , 1 ) ;
7595: END IF;
7596:
7597: -- Process requests is TRUE so still need to call it, but don't need to notify
7598: IF l_debug_level > 0 THEN