DBA Data[Home] [Help]

APPS.OE_ORDER_CLOSE_UTIL dependencies on OE_ORDER_UTIL

Line 257: OE_ORDER_UTIL.Update_Global_Picture

253: -- jolin start
254: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
255:
256: -- call notification framework to get header index position
257: OE_ORDER_UTIL.Update_Global_Picture
258: (p_Upd_New_Rec_If_Exists =>FALSE
259: , p_header_rec => l_header_rec
260: , p_old_header_rec => l_old_header_rec
261: , p_header_id => l_header_rec.header_id

Line 275: OE_ORDER_UTIL.g_header_rec.open_flag:= l_header_rec.open_flag;

271:
272: IF l_notify_index is not null then
273: -- modify Global Picture
274:
275: OE_ORDER_UTIL.g_header_rec.open_flag:= l_header_rec.open_flag;
276: OE_ORDER_UTIL.g_header_rec.flow_status_code:= l_header_rec.flow_status_code;
277: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
278: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
279: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;

Line 276: OE_ORDER_UTIL.g_header_rec.flow_status_code:= l_header_rec.flow_status_code;

272: IF l_notify_index is not null then
273: -- modify Global Picture
274:
275: OE_ORDER_UTIL.g_header_rec.open_flag:= l_header_rec.open_flag;
276: OE_ORDER_UTIL.g_header_rec.flow_status_code:= l_header_rec.flow_status_code;
277: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
278: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
279: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
280: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;

Line 277: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;

273: -- modify Global Picture
274:
275: OE_ORDER_UTIL.g_header_rec.open_flag:= l_header_rec.open_flag;
276: OE_ORDER_UTIL.g_header_rec.flow_status_code:= l_header_rec.flow_status_code;
277: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
278: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
279: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
280: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;
281:

Line 278: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;

274:
275: OE_ORDER_UTIL.g_header_rec.open_flag:= l_header_rec.open_flag;
276: OE_ORDER_UTIL.g_header_rec.flow_status_code:= l_header_rec.flow_status_code;
277: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
278: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
279: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
280: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;
281:
282: IF l_debug_level > 0 THEN

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

275: OE_ORDER_UTIL.g_header_rec.open_flag:= l_header_rec.open_flag;
276: OE_ORDER_UTIL.g_header_rec.flow_status_code:= l_header_rec.flow_status_code;
277: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
278: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
279: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
280: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;
281:
282: IF l_debug_level > 0 THEN
283: oe_debug_pub.add( 'GLOBAL HDR OPEN_FLAG IS: ' || OE_ORDER_UTIL.G_HEADER_REC.OPEN_FLAG , 1 ) ;

Line 280: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;

276: OE_ORDER_UTIL.g_header_rec.flow_status_code:= l_header_rec.flow_status_code;
277: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
278: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
279: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
280: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;
281:
282: IF l_debug_level > 0 THEN
283: oe_debug_pub.add( 'GLOBAL HDR OPEN_FLAG IS: ' || OE_ORDER_UTIL.G_HEADER_REC.OPEN_FLAG , 1 ) ;
284: END IF;

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

279: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
280: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;
281:
282: IF l_debug_level > 0 THEN
283: oe_debug_pub.add( 'GLOBAL HDR OPEN_FLAG IS: ' || OE_ORDER_UTIL.G_HEADER_REC.OPEN_FLAG , 1 ) ;
284: END IF;
285: IF l_debug_level > 0 THEN
286: oe_debug_pub.add( 'GLOBAL HDR FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE , 1 ) ;
287: END IF;

Line 286: oe_debug_pub.add( 'GLOBAL HDR FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE , 1 ) ;

282: IF l_debug_level > 0 THEN
283: oe_debug_pub.add( 'GLOBAL HDR OPEN_FLAG IS: ' || OE_ORDER_UTIL.G_HEADER_REC.OPEN_FLAG , 1 ) ;
284: END IF;
285: IF l_debug_level > 0 THEN
286: oe_debug_pub.add( 'GLOBAL HDR FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE , 1 ) ;
287: END IF;
288:
289: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
290: RAISE FND_API.G_EXC_ERROR;

Line 339: OE_ORDER_UTIL.RAISE_BUSINESS_EVENT(p_header_id => l_header_rec.header_id,

335:
336: -- Added following code to raise OIP status update event for Order Header during closure.
337: -- Call to the following procedure added for the bug 13930149
338: oe_debug_pub.add('RAISING OIP STATUS CHANGE BUSINESS EVENT FOR ORDER HEADER CLOSURE');
339: OE_ORDER_UTIL.RAISE_BUSINESS_EVENT(p_header_id => l_header_rec.header_id,
340: p_status => l_header_rec.flow_status_code);
341:
342: /********************GENESIS********************************
343: * Some statuses are not going through process order and *

Line 764: OE_ORDER_UTIL.Update_Global_Picture

760: -- jolin start
761: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
762:
763: -- call notification framework to get this line's index position
764: OE_ORDER_UTIL.Update_Global_Picture
765: (p_Upd_New_Rec_If_Exists =>FALSE
766: , p_line_rec => l_line_tbl(1)
767: , p_old_line_rec => l_old_line_tbl(1)
768: , p_line_id => l_line_tbl(1).line_id

Line 787: OE_ORDER_UTIL.g_line_tbl(l_notify_index).open_flag:= l_line_tbl(1).open_flag;

783: END IF;
784:
785: IF l_notify_index is not null then
786: -- modify Global Picture
787: OE_ORDER_UTIL.g_line_tbl(l_notify_index).open_flag:= l_line_tbl(1).open_flag;
788: OE_ORDER_UTIL.g_line_tbl(l_notify_index).calculate_price_flag:= l_line_tbl(1).calculate_price_flag;
789: OE_ORDER_UTIL.g_line_tbl(l_notify_index).flow_status_code:=l_line_tbl(1).flow_status_code;
790: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by:= l_line_tbl(1).last_updated_by;
791: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login:=l_line_tbl(1).last_update_login;

Line 788: OE_ORDER_UTIL.g_line_tbl(l_notify_index).calculate_price_flag:= l_line_tbl(1).calculate_price_flag;

784:
785: IF l_notify_index is not null then
786: -- modify Global Picture
787: OE_ORDER_UTIL.g_line_tbl(l_notify_index).open_flag:= l_line_tbl(1).open_flag;
788: OE_ORDER_UTIL.g_line_tbl(l_notify_index).calculate_price_flag:= l_line_tbl(1).calculate_price_flag;
789: OE_ORDER_UTIL.g_line_tbl(l_notify_index).flow_status_code:=l_line_tbl(1).flow_status_code;
790: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by:= l_line_tbl(1).last_updated_by;
791: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login:=l_line_tbl(1).last_update_login;
792: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date:=l_line_tbl(1).last_update_date;

Line 789: OE_ORDER_UTIL.g_line_tbl(l_notify_index).flow_status_code:=l_line_tbl(1).flow_status_code;

785: IF l_notify_index is not null then
786: -- modify Global Picture
787: OE_ORDER_UTIL.g_line_tbl(l_notify_index).open_flag:= l_line_tbl(1).open_flag;
788: OE_ORDER_UTIL.g_line_tbl(l_notify_index).calculate_price_flag:= l_line_tbl(1).calculate_price_flag;
789: OE_ORDER_UTIL.g_line_tbl(l_notify_index).flow_status_code:=l_line_tbl(1).flow_status_code;
790: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by:= l_line_tbl(1).last_updated_by;
791: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login:=l_line_tbl(1).last_update_login;
792: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date:=l_line_tbl(1).last_update_date;
793: OE_ORDER_UTIL.g_line_tbl(l_notify_index).lock_control:= l_line_tbl(1).lock_control;

Line 790: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by:= l_line_tbl(1).last_updated_by;

786: -- modify Global Picture
787: OE_ORDER_UTIL.g_line_tbl(l_notify_index).open_flag:= l_line_tbl(1).open_flag;
788: OE_ORDER_UTIL.g_line_tbl(l_notify_index).calculate_price_flag:= l_line_tbl(1).calculate_price_flag;
789: OE_ORDER_UTIL.g_line_tbl(l_notify_index).flow_status_code:=l_line_tbl(1).flow_status_code;
790: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by:= l_line_tbl(1).last_updated_by;
791: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login:=l_line_tbl(1).last_update_login;
792: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date:=l_line_tbl(1).last_update_date;
793: OE_ORDER_UTIL.g_line_tbl(l_notify_index).lock_control:= l_line_tbl(1).lock_control;
794:

Line 791: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login:=l_line_tbl(1).last_update_login;

787: OE_ORDER_UTIL.g_line_tbl(l_notify_index).open_flag:= l_line_tbl(1).open_flag;
788: OE_ORDER_UTIL.g_line_tbl(l_notify_index).calculate_price_flag:= l_line_tbl(1).calculate_price_flag;
789: OE_ORDER_UTIL.g_line_tbl(l_notify_index).flow_status_code:=l_line_tbl(1).flow_status_code;
790: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by:= l_line_tbl(1).last_updated_by;
791: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login:=l_line_tbl(1).last_update_login;
792: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date:=l_line_tbl(1).last_update_date;
793: OE_ORDER_UTIL.g_line_tbl(l_notify_index).lock_control:= l_line_tbl(1).lock_control;
794:
795: IF l_debug_level > 0 THEN

Line 792: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date:=l_line_tbl(1).last_update_date;

788: OE_ORDER_UTIL.g_line_tbl(l_notify_index).calculate_price_flag:= l_line_tbl(1).calculate_price_flag;
789: OE_ORDER_UTIL.g_line_tbl(l_notify_index).flow_status_code:=l_line_tbl(1).flow_status_code;
790: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by:= l_line_tbl(1).last_updated_by;
791: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login:=l_line_tbl(1).last_update_login;
792: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date:=l_line_tbl(1).last_update_date;
793: OE_ORDER_UTIL.g_line_tbl(l_notify_index).lock_control:= l_line_tbl(1).lock_control;
794:
795: IF l_debug_level > 0 THEN
796: oe_debug_pub.add( 'GLOBAL LINE OPEN_FLAG IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .OPEN_FLAG , 1 ) ;

Line 793: OE_ORDER_UTIL.g_line_tbl(l_notify_index).lock_control:= l_line_tbl(1).lock_control;

789: OE_ORDER_UTIL.g_line_tbl(l_notify_index).flow_status_code:=l_line_tbl(1).flow_status_code;
790: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by:= l_line_tbl(1).last_updated_by;
791: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login:=l_line_tbl(1).last_update_login;
792: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date:=l_line_tbl(1).last_update_date;
793: OE_ORDER_UTIL.g_line_tbl(l_notify_index).lock_control:= l_line_tbl(1).lock_control;
794:
795: IF l_debug_level > 0 THEN
796: oe_debug_pub.add( 'GLOBAL LINE OPEN_FLAG IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .OPEN_FLAG , 1 ) ;
797: END IF;

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

792: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date:=l_line_tbl(1).last_update_date;
793: OE_ORDER_UTIL.g_line_tbl(l_notify_index).lock_control:= l_line_tbl(1).lock_control;
794:
795: IF l_debug_level > 0 THEN
796: oe_debug_pub.add( 'GLOBAL LINE OPEN_FLAG IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .OPEN_FLAG , 1 ) ;
797: END IF;
798: IF l_debug_level > 0 THEN
799: oe_debug_pub.add( 'GLOBAL LINE CALCULATE_PRICE_FLAG IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .CALCULATE_PRICE_FLAG , 1 ) ;
800: END IF;

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

795: IF l_debug_level > 0 THEN
796: oe_debug_pub.add( 'GLOBAL LINE OPEN_FLAG IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .OPEN_FLAG , 1 ) ;
797: END IF;
798: IF l_debug_level > 0 THEN
799: oe_debug_pub.add( 'GLOBAL LINE CALCULATE_PRICE_FLAG IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .CALCULATE_PRICE_FLAG , 1 ) ;
800: END IF;
801: IF l_debug_level > 0 THEN
802: oe_debug_pub.add( 'GLOBAL LINE FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE , 1 ) ;
803: END IF;

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

798: IF l_debug_level > 0 THEN
799: oe_debug_pub.add( 'GLOBAL LINE CALCULATE_PRICE_FLAG IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .CALCULATE_PRICE_FLAG , 1 ) ;
800: END IF;
801: IF l_debug_level > 0 THEN
802: oe_debug_pub.add( 'GLOBAL LINE FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE , 1 ) ;
803: END IF;
804:
805:
806: -- Process requests is TRUE, but don't need to notify

Line 862: OE_ORDER_UTIL.RAISE_BUSINESS_EVENT(p_header_id => l_old_line_tbl(1).header_id,

858:
859: --- Adding the following code to raise OIP status change event during order line closure
860: -- change done for bug 13930149
861: oe_debug_pub.add('RAISING OIP STATUS CHANGE BUSINESS EVENT FOR ORDER LINE CLOSURE');
862: OE_ORDER_UTIL.RAISE_BUSINESS_EVENT(p_header_id => l_old_line_tbl(1).header_id,
863: p_line_id => p_line_id,
864: p_status => l_line_tbl(1).flow_status_code);
865: -- done with changes for bug 13930149
866: