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

Line 4933: OE_ORDER_UTIL.Update_Global_Picture

4929: -- jolin start
4930: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
4931:
4932: -- call notification framework to get header index position
4933: OE_ORDER_UTIL.Update_Global_Picture
4934: (p_Upd_New_Rec_If_Exists =>FALSE
4935: , p_header_rec => l_header_rec
4936: , p_old_header_rec => l_old_header_rec
4937: , p_header_id => l_header_rec.header_id

Line 4951: OE_ORDER_UTIL.g_header_rec.payment_amount:=

4947:
4948: IF l_notify_index is not null then
4949: -- modify Global Picture
4950:
4951: OE_ORDER_UTIL.g_header_rec.payment_amount:=
4952: l_header_rec.payment_amount;
4953: OE_ORDER_UTIL.g_header_rec.credit_card_approval_code:=
4954: l_header_rec.credit_card_approval_code;
4955: OE_ORDER_UTIL.g_header_rec.credit_card_approval_date:=

Line 4953: OE_ORDER_UTIL.g_header_rec.credit_card_approval_code:=

4949: -- modify Global Picture
4950:
4951: OE_ORDER_UTIL.g_header_rec.payment_amount:=
4952: l_header_rec.payment_amount;
4953: OE_ORDER_UTIL.g_header_rec.credit_card_approval_code:=
4954: l_header_rec.credit_card_approval_code;
4955: OE_ORDER_UTIL.g_header_rec.credit_card_approval_date:=
4956: l_header_rec.credit_card_approval_date;
4957: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;

Line 4955: OE_ORDER_UTIL.g_header_rec.credit_card_approval_date:=

4951: OE_ORDER_UTIL.g_header_rec.payment_amount:=
4952: l_header_rec.payment_amount;
4953: OE_ORDER_UTIL.g_header_rec.credit_card_approval_code:=
4954: l_header_rec.credit_card_approval_code;
4955: OE_ORDER_UTIL.g_header_rec.credit_card_approval_date:=
4956: l_header_rec.credit_card_approval_date;
4957: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
4958: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
4959: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;

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

4953: OE_ORDER_UTIL.g_header_rec.credit_card_approval_code:=
4954: l_header_rec.credit_card_approval_code;
4955: OE_ORDER_UTIL.g_header_rec.credit_card_approval_date:=
4956: l_header_rec.credit_card_approval_date;
4957: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
4958: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
4959: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
4960: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;
4961:

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

4954: l_header_rec.credit_card_approval_code;
4955: OE_ORDER_UTIL.g_header_rec.credit_card_approval_date:=
4956: l_header_rec.credit_card_approval_date;
4957: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
4958: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
4959: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
4960: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;
4961:
4962: IF l_debug_level > 0 THEN

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

4955: OE_ORDER_UTIL.g_header_rec.credit_card_approval_date:=
4956: l_header_rec.credit_card_approval_date;
4957: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
4958: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
4959: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
4960: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;
4961:
4962: IF l_debug_level > 0 THEN
4963: oe_debug_pub.add( 'GLOBAL HDR PAYMENT_AMOUNT IS: ' || OE_ORDER_UTIL.G_HEADER_REC.PAYMENT_AMOUNT , 1 ) ;

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

4956: l_header_rec.credit_card_approval_date;
4957: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
4958: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
4959: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
4960: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;
4961:
4962: IF l_debug_level > 0 THEN
4963: oe_debug_pub.add( 'GLOBAL HDR PAYMENT_AMOUNT IS: ' || OE_ORDER_UTIL.G_HEADER_REC.PAYMENT_AMOUNT , 1 ) ;
4964: END IF;

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

4959: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
4960: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;
4961:
4962: IF l_debug_level > 0 THEN
4963: oe_debug_pub.add( 'GLOBAL HDR PAYMENT_AMOUNT IS: ' || OE_ORDER_UTIL.G_HEADER_REC.PAYMENT_AMOUNT , 1 ) ;
4964: END IF;
4965: IF l_debug_level > 0 THEN
4966: oe_debug_pub.add( 'GLOBAL HDR CC APPROVAL_CODE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.CREDIT_CARD_APPROVAL_CODE , 1 ) ;
4967: END IF;

Line 4966: oe_debug_pub.add( 'GLOBAL HDR CC APPROVAL_CODE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.CREDIT_CARD_APPROVAL_CODE , 1 ) ;

4962: IF l_debug_level > 0 THEN
4963: oe_debug_pub.add( 'GLOBAL HDR PAYMENT_AMOUNT IS: ' || OE_ORDER_UTIL.G_HEADER_REC.PAYMENT_AMOUNT , 1 ) ;
4964: END IF;
4965: IF l_debug_level > 0 THEN
4966: oe_debug_pub.add( 'GLOBAL HDR CC APPROVAL_CODE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.CREDIT_CARD_APPROVAL_CODE , 1 ) ;
4967: END IF;
4968: IF l_debug_level > 0 THEN
4969: oe_debug_pub.add( 'GLOBAL HDR CC APPROVAL_DATE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.CREDIT_CARD_APPROVAL_DATE , 1 ) ;
4970: END IF;

Line 4969: oe_debug_pub.add( 'GLOBAL HDR CC APPROVAL_DATE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.CREDIT_CARD_APPROVAL_DATE , 1 ) ;

4965: IF l_debug_level > 0 THEN
4966: oe_debug_pub.add( 'GLOBAL HDR CC APPROVAL_CODE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.CREDIT_CARD_APPROVAL_CODE , 1 ) ;
4967: END IF;
4968: IF l_debug_level > 0 THEN
4969: oe_debug_pub.add( 'GLOBAL HDR CC APPROVAL_DATE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.CREDIT_CARD_APPROVAL_DATE , 1 ) ;
4970: END IF;
4971:
4972: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4973: RAISE FND_API.G_EXC_ERROR;

Line 7261: IF OE_ORDER_UTIL.G_Precision IS NULL THEN

7257: BEGIN
7258: -- bug#5946168 added round function
7259: -- Select the Tax Total and Outbound Extended Price
7260: --7010350
7261: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
7262: Is_fmt:= OE_ORDER_UTIL.Get_Precision(p_header_id=>p_header_id);
7263:
7264: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
7265: OE_ORDER_UTIL.G_Precision:=2;

Line 7262: Is_fmt:= OE_ORDER_UTIL.Get_Precision(p_header_id=>p_header_id);

7258: -- bug#5946168 added round function
7259: -- Select the Tax Total and Outbound Extended Price
7260: --7010350
7261: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
7262: Is_fmt:= OE_ORDER_UTIL.Get_Precision(p_header_id=>p_header_id);
7263:
7264: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
7265: OE_ORDER_UTIL.G_Precision:=2;
7266: END IF;

Line 7264: IF OE_ORDER_UTIL.G_Precision IS NULL THEN

7260: --7010350
7261: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
7262: Is_fmt:= OE_ORDER_UTIL.Get_Precision(p_header_id=>p_header_id);
7263:
7264: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
7265: OE_ORDER_UTIL.G_Precision:=2;
7266: END IF;
7267: END IF;
7268: --7010350

Line 7265: OE_ORDER_UTIL.G_Precision:=2;

7261: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
7262: Is_fmt:= OE_ORDER_UTIL.Get_Precision(p_header_id=>p_header_id);
7263:
7264: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
7265: OE_ORDER_UTIL.G_Precision:=2;
7266: END IF;
7267: END IF;
7268: --7010350
7269:

Line 7271: SUM(ROUND(nvl(ool.tax_value,0),OE_ORDER_UTIL.G_Precision))

7267: END IF;
7268: --7010350
7269:
7270: SELECT
7271: SUM(ROUND(nvl(ool.tax_value,0),OE_ORDER_UTIL.G_Precision))
7272: , SUM(ROUND(nvl(ool.Ordered_Quantity,0)
7273: *(ool.unit_selling_price),OE_ORDER_UTIL.G_Precision))
7274: INTO
7275: l_tax_total

Line 7273: *(ool.unit_selling_price),OE_ORDER_UTIL.G_Precision))

7269:
7270: SELECT
7271: SUM(ROUND(nvl(ool.tax_value,0),OE_ORDER_UTIL.G_Precision))
7272: , SUM(ROUND(nvl(ool.Ordered_Quantity,0)
7273: *(ool.unit_selling_price),OE_ORDER_UTIL.G_Precision))
7274: INTO
7275: l_tax_total
7276: , l_order_total
7277: FROM oe_order_lines_all ool

Line 7293: SELECT SUM(ROUND(nvl(op.commitment_applied_amount,0),OE_ORDER_UTIL.G_Precision))

7289: OR mti.invoice_enabled_flag = 'N'));
7290:
7291: IF OE_Commitment_Pvt.Do_Commitment_Sequencing THEN
7292: -- Select the committment applied amount if Commitment Sequencing "On"
7293: SELECT SUM(ROUND(nvl(op.commitment_applied_amount,0),OE_ORDER_UTIL.G_Precision))
7294: INTO l_commitment_total
7295: FROM oe_payments op,
7296: oe_order_lines_all ool --bug3225795
7297: WHERE op.header_id = p_header_id

Line 7312: SELECT SUM(ROUND(nvl(ool.Ordered_Quantity,0) * (ool.unit_selling_price),OE_ORDER_UTIL.G_Precision))

7308: AND (mti.invoiceable_item_flag = 'N'
7309: OR mti.invoice_enabled_flag = 'N'));
7310: ELSE
7311: -- Select the Outbound Extended Price for lines that have committment
7312: SELECT SUM(ROUND(nvl(ool.Ordered_Quantity,0) * (ool.unit_selling_price),OE_ORDER_UTIL.G_Precision))
7313: INTO l_commitment_total
7314: FROM oe_order_lines_all ool
7315: WHERE ool.header_id = p_header_id
7316: AND ool.commitment_id is not null

Line 7333: ROUND(DECODE(P.CREDIT_OR_CHARGE_FLAG,'C',(-1) * P.OPERAND,P.OPERAND),OE_ORDER_UTIL.G_Precision)

7329:
7330: -- Select the Outbound Charges Total
7331:
7332: SELECT SUM(
7333: ROUND(DECODE(P.CREDIT_OR_CHARGE_FLAG,'C',(-1) * P.OPERAND,P.OPERAND),OE_ORDER_UTIL.G_Precision)
7334: )
7335: INTO l_chgs_wo_line_id
7336: FROM OE_PRICE_ADJUSTMENTS P
7337: WHERE P.HEADER_ID = p_header_id

Line 7351: ),OE_ORDER_UTIL.G_Precision)

7347: (-1) * (L.ORDERED_QUANTITY*P.ADJUSTED_AMOUNT)),
7348: DECODE(P.ARITHMETIC_OPERATOR, 'LUMPSUM',
7349: P.OPERAND,
7350: (L.ORDERED_QUANTITY*P.ADJUSTED_AMOUNT))
7351: ),OE_ORDER_UTIL.G_Precision)
7352: )
7353: INTO l_chgs_w_line_id
7354: FROM OE_PRICE_ADJUSTMENTS P,
7355: OE_ORDER_LINES_ALL L

Line 7571: OE_ORDER_UTIL.Update_Global_Picture

7567:
7568: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
7569:
7570: -- call notification framework to get header index position
7571: OE_ORDER_UTIL.Update_Global_Picture
7572: (p_Upd_New_Rec_If_Exists =>FALSE
7573: , p_header_rec => l_header_rec
7574: , p_old_header_rec => l_old_header_rec
7575: , p_header_id => l_header_rec.header_id

Line 7589: OE_ORDER_UTIL.g_header_rec.payment_amount:=

7585:
7586: IF l_notify_index is not null then
7587: -- modify Global Picture
7588:
7589: OE_ORDER_UTIL.g_header_rec.payment_amount:=
7590: l_header_rec.payment_amount;
7591: OE_ORDER_UTIL.g_header_rec.credit_card_approval_code:=
7592: l_header_rec.credit_card_approval_code;
7593: OE_ORDER_UTIL.g_header_rec.credit_card_approval_date:=

Line 7591: OE_ORDER_UTIL.g_header_rec.credit_card_approval_code:=

7587: -- modify Global Picture
7588:
7589: OE_ORDER_UTIL.g_header_rec.payment_amount:=
7590: l_header_rec.payment_amount;
7591: OE_ORDER_UTIL.g_header_rec.credit_card_approval_code:=
7592: l_header_rec.credit_card_approval_code;
7593: OE_ORDER_UTIL.g_header_rec.credit_card_approval_date:=
7594: l_header_rec.credit_card_approval_date;
7595: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;

Line 7593: OE_ORDER_UTIL.g_header_rec.credit_card_approval_date:=

7589: OE_ORDER_UTIL.g_header_rec.payment_amount:=
7590: l_header_rec.payment_amount;
7591: OE_ORDER_UTIL.g_header_rec.credit_card_approval_code:=
7592: l_header_rec.credit_card_approval_code;
7593: OE_ORDER_UTIL.g_header_rec.credit_card_approval_date:=
7594: l_header_rec.credit_card_approval_date;
7595: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
7596: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
7597: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;

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

7591: OE_ORDER_UTIL.g_header_rec.credit_card_approval_code:=
7592: l_header_rec.credit_card_approval_code;
7593: OE_ORDER_UTIL.g_header_rec.credit_card_approval_date:=
7594: l_header_rec.credit_card_approval_date;
7595: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
7596: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
7597: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
7598: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;
7599:

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

7592: l_header_rec.credit_card_approval_code;
7593: OE_ORDER_UTIL.g_header_rec.credit_card_approval_date:=
7594: l_header_rec.credit_card_approval_date;
7595: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
7596: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
7597: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
7598: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;
7599:
7600: IF l_debug_level > 0 THEN

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

7593: OE_ORDER_UTIL.g_header_rec.credit_card_approval_date:=
7594: l_header_rec.credit_card_approval_date;
7595: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
7596: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
7597: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
7598: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;
7599:
7600: IF l_debug_level > 0 THEN
7601: oe_debug_pub.add( 'GLOBAL HDR PAYMENT_AMOUNT IS: ' || OE_ORDER_UTIL.G_HEADER_REC.PAYMENT_AMOUNT , 1 ) ;

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

7594: l_header_rec.credit_card_approval_date;
7595: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
7596: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
7597: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
7598: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;
7599:
7600: IF l_debug_level > 0 THEN
7601: oe_debug_pub.add( 'GLOBAL HDR PAYMENT_AMOUNT IS: ' || OE_ORDER_UTIL.G_HEADER_REC.PAYMENT_AMOUNT , 1 ) ;
7602: END IF;

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

7597: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
7598: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;
7599:
7600: IF l_debug_level > 0 THEN
7601: oe_debug_pub.add( 'GLOBAL HDR PAYMENT_AMOUNT IS: ' || OE_ORDER_UTIL.G_HEADER_REC.PAYMENT_AMOUNT , 1 ) ;
7602: END IF;
7603: IF l_debug_level > 0 THEN
7604: oe_debug_pub.add( 'GLOBAL HDR CC APPROVAL_CODE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.CREDIT_CARD_APPROVAL_CODE , 1 ) ;
7605: END IF;

Line 7604: oe_debug_pub.add( 'GLOBAL HDR CC APPROVAL_CODE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.CREDIT_CARD_APPROVAL_CODE , 1 ) ;

7600: IF l_debug_level > 0 THEN
7601: oe_debug_pub.add( 'GLOBAL HDR PAYMENT_AMOUNT IS: ' || OE_ORDER_UTIL.G_HEADER_REC.PAYMENT_AMOUNT , 1 ) ;
7602: END IF;
7603: IF l_debug_level > 0 THEN
7604: oe_debug_pub.add( 'GLOBAL HDR CC APPROVAL_CODE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.CREDIT_CARD_APPROVAL_CODE , 1 ) ;
7605: END IF;
7606: IF l_debug_level > 0 THEN
7607: oe_debug_pub.add( 'GLOBAL HDR CC APPROVAL_DATE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.CREDIT_CARD_APPROVAL_DATE , 1 ) ;
7608: END IF;

Line 7607: oe_debug_pub.add( 'GLOBAL HDR CC APPROVAL_DATE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.CREDIT_CARD_APPROVAL_DATE , 1 ) ;

7603: IF l_debug_level > 0 THEN
7604: oe_debug_pub.add( 'GLOBAL HDR CC APPROVAL_CODE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.CREDIT_CARD_APPROVAL_CODE , 1 ) ;
7605: END IF;
7606: IF l_debug_level > 0 THEN
7607: oe_debug_pub.add( 'GLOBAL HDR CC APPROVAL_DATE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.CREDIT_CARD_APPROVAL_DATE , 1 ) ;
7608: END IF;
7609:
7610: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
7611: RAISE FND_API.G_EXC_ERROR;