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 5006: OE_ORDER_UTIL.Update_Global_Picture

5002: -- jolin start
5003: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
5004:
5005: -- call notification framework to get header index position
5006: OE_ORDER_UTIL.Update_Global_Picture
5007: (p_Upd_New_Rec_If_Exists =>FALSE
5008: , p_header_rec => l_header_rec
5009: , p_old_header_rec => l_old_header_rec
5010: , p_header_id => l_header_rec.header_id

Line 5024: OE_ORDER_UTIL.g_header_rec.payment_amount:=

5020:
5021: IF l_notify_index is not null then
5022: -- modify Global Picture
5023:
5024: OE_ORDER_UTIL.g_header_rec.payment_amount:=
5025: l_header_rec.payment_amount;
5026: OE_ORDER_UTIL.g_header_rec.credit_card_approval_code:=
5027: l_header_rec.credit_card_approval_code;
5028: OE_ORDER_UTIL.g_header_rec.credit_card_approval_date:=

Line 5026: OE_ORDER_UTIL.g_header_rec.credit_card_approval_code:=

5022: -- modify Global Picture
5023:
5024: OE_ORDER_UTIL.g_header_rec.payment_amount:=
5025: l_header_rec.payment_amount;
5026: OE_ORDER_UTIL.g_header_rec.credit_card_approval_code:=
5027: l_header_rec.credit_card_approval_code;
5028: OE_ORDER_UTIL.g_header_rec.credit_card_approval_date:=
5029: l_header_rec.credit_card_approval_date;
5030: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;

Line 5028: OE_ORDER_UTIL.g_header_rec.credit_card_approval_date:=

5024: OE_ORDER_UTIL.g_header_rec.payment_amount:=
5025: l_header_rec.payment_amount;
5026: OE_ORDER_UTIL.g_header_rec.credit_card_approval_code:=
5027: l_header_rec.credit_card_approval_code;
5028: OE_ORDER_UTIL.g_header_rec.credit_card_approval_date:=
5029: l_header_rec.credit_card_approval_date;
5030: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
5031: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
5032: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;

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

5026: OE_ORDER_UTIL.g_header_rec.credit_card_approval_code:=
5027: l_header_rec.credit_card_approval_code;
5028: OE_ORDER_UTIL.g_header_rec.credit_card_approval_date:=
5029: l_header_rec.credit_card_approval_date;
5030: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
5031: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
5032: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
5033: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;
5034:

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

5027: l_header_rec.credit_card_approval_code;
5028: OE_ORDER_UTIL.g_header_rec.credit_card_approval_date:=
5029: l_header_rec.credit_card_approval_date;
5030: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
5031: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
5032: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
5033: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;
5034:
5035: IF l_debug_level > 0 THEN

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

5028: OE_ORDER_UTIL.g_header_rec.credit_card_approval_date:=
5029: l_header_rec.credit_card_approval_date;
5030: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
5031: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
5032: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
5033: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;
5034:
5035: IF l_debug_level > 0 THEN
5036: oe_debug_pub.add( 'GLOBAL HDR PAYMENT_AMOUNT IS: ' || OE_ORDER_UTIL.G_HEADER_REC.PAYMENT_AMOUNT , 1 ) ;

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

5029: l_header_rec.credit_card_approval_date;
5030: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
5031: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
5032: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
5033: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;
5034:
5035: IF l_debug_level > 0 THEN
5036: oe_debug_pub.add( 'GLOBAL HDR PAYMENT_AMOUNT IS: ' || OE_ORDER_UTIL.G_HEADER_REC.PAYMENT_AMOUNT , 1 ) ;
5037: END IF;

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

5032: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
5033: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;
5034:
5035: IF l_debug_level > 0 THEN
5036: oe_debug_pub.add( 'GLOBAL HDR PAYMENT_AMOUNT IS: ' || OE_ORDER_UTIL.G_HEADER_REC.PAYMENT_AMOUNT , 1 ) ;
5037: END IF;
5038: --IF l_debug_level > 0 THEN
5039: --oe_debug_pub.add( 'GLOBAL HDR CC APPROVAL_CODE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.CREDIT_CARD_APPROVAL_CODE , 1 ) ;
5040: --END IF;

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

5035: IF l_debug_level > 0 THEN
5036: oe_debug_pub.add( 'GLOBAL HDR PAYMENT_AMOUNT IS: ' || OE_ORDER_UTIL.G_HEADER_REC.PAYMENT_AMOUNT , 1 ) ;
5037: END IF;
5038: --IF l_debug_level > 0 THEN
5039: --oe_debug_pub.add( 'GLOBAL HDR CC APPROVAL_CODE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.CREDIT_CARD_APPROVAL_CODE , 1 ) ;
5040: --END IF;
5041: --IF l_debug_level > 0 THEN
5042: --oe_debug_pub.add( 'GLOBAL HDR CC APPROVAL_DATE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.CREDIT_CARD_APPROVAL_DATE , 1 ) ;
5043: --END IF;

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

5038: --IF l_debug_level > 0 THEN
5039: --oe_debug_pub.add( 'GLOBAL HDR CC APPROVAL_CODE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.CREDIT_CARD_APPROVAL_CODE , 1 ) ;
5040: --END IF;
5041: --IF l_debug_level > 0 THEN
5042: --oe_debug_pub.add( 'GLOBAL HDR CC APPROVAL_DATE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.CREDIT_CARD_APPROVAL_DATE , 1 ) ;
5043: --END IF;
5044:
5045: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5046: RAISE FND_API.G_EXC_ERROR;

Line 7378: IF OE_ORDER_UTIL.G_Precision IS NULL THEN

7374: oe_debug_pub.add( 'ENTERING OE_Verify_Payment_Pub.Get_Line_Total.' , 1 ) ;
7375: END IF;
7376:
7377: --8241416 start
7378: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
7379: Is_fmt:= OE_ORDER_UTIL.Get_Precision(p_header_id=>p_header_id);
7380:
7381: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
7382: OE_ORDER_UTIL.G_Precision:=2;

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

7375: END IF;
7376:
7377: --8241416 start
7378: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
7379: Is_fmt:= OE_ORDER_UTIL.Get_Precision(p_header_id=>p_header_id);
7380:
7381: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
7382: OE_ORDER_UTIL.G_Precision:=2;
7383: END IF;

Line 7381: IF OE_ORDER_UTIL.G_Precision IS NULL THEN

7377: --8241416 start
7378: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
7379: Is_fmt:= OE_ORDER_UTIL.Get_Precision(p_header_id=>p_header_id);
7380:
7381: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
7382: OE_ORDER_UTIL.G_Precision:=2;
7383: END IF;
7384: END IF;
7385: --8241416 end

Line 7382: OE_ORDER_UTIL.G_Precision:=2;

7378: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
7379: Is_fmt:= OE_ORDER_UTIL.Get_Precision(p_header_id=>p_header_id);
7380:
7381: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
7382: OE_ORDER_UTIL.G_Precision:=2;
7383: END IF;
7384: END IF;
7385: --8241416 end
7386:

Line 7487: ,OE_ORDER_UTIL.G_Precision ) --8241416

7483: DECODE(P.ARITHMETIC_OPERATOR, 'LUMPSUM',
7484: DECODE(L.ORDERED_QUANTITY,0,0,P.OPERAND),
7485: (L.ORDERED_QUANTITY* nvl(P.ADJUSTED_AMOUNT,0)))
7486: )
7487: ,OE_ORDER_UTIL.G_Precision ) --8241416
7488: )
7489: INTO l_charge_amount
7490: FROM OE_PRICE_ADJUSTMENTS P,
7491: OE_ORDER_LINES_ALL L

Line 7897: IF OE_ORDER_UTIL.G_Precision IS NULL THEN

7893: BEGIN
7894: -- bug#5946168 added round function
7895: -- Select the Tax Total and Outbound Extended Price
7896: --7010350
7897: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
7898: Is_fmt:= OE_ORDER_UTIL.Get_Precision(p_header_id=>p_header_id);
7899:
7900: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
7901: OE_ORDER_UTIL.G_Precision:=2;

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

7894: -- bug#5946168 added round function
7895: -- Select the Tax Total and Outbound Extended Price
7896: --7010350
7897: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
7898: Is_fmt:= OE_ORDER_UTIL.Get_Precision(p_header_id=>p_header_id);
7899:
7900: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
7901: OE_ORDER_UTIL.G_Precision:=2;
7902: END IF;

Line 7900: IF OE_ORDER_UTIL.G_Precision IS NULL THEN

7896: --7010350
7897: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
7898: Is_fmt:= OE_ORDER_UTIL.Get_Precision(p_header_id=>p_header_id);
7899:
7900: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
7901: OE_ORDER_UTIL.G_Precision:=2;
7902: END IF;
7903: END IF;
7904: --7010350

Line 7901: OE_ORDER_UTIL.G_Precision:=2;

7897: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
7898: Is_fmt:= OE_ORDER_UTIL.Get_Precision(p_header_id=>p_header_id);
7899:
7900: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
7901: OE_ORDER_UTIL.G_Precision:=2;
7902: END IF;
7903: END IF;
7904: --7010350
7905:

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

7903: END IF;
7904: --7010350
7905:
7906: SELECT
7907: SUM(ROUND(nvl(ool.tax_value,0),OE_ORDER_UTIL.G_Precision))
7908: /*, SUM(ROUND(nvl(ool.Ordered_Quantity,0)
7909: *(ool.unit_selling_price),OE_ORDER_UTIL.G_Precision)) */ -- sol_ord_er #16014165
7910: -- First Period Bill Amt should not consider ordered quantity
7911: ,SUM(ROUND(NVL(ool.service_first_period_amount,nvl(ool.Ordered_Quantity,0)*(ool.unit_selling_price)),OE_ORDER_UTIL.G_Precision))

Line 7909: (ool.unit_selling_price),OE_ORDER_UTIL.G_Precision)) / -- sol_ord_er #16014165

7905:
7906: SELECT
7907: SUM(ROUND(nvl(ool.tax_value,0),OE_ORDER_UTIL.G_Precision))
7908: /*, SUM(ROUND(nvl(ool.Ordered_Quantity,0)
7909: *(ool.unit_selling_price),OE_ORDER_UTIL.G_Precision)) */ -- sol_ord_er #16014165
7910: -- First Period Bill Amt should not consider ordered quantity
7911: ,SUM(ROUND(NVL(ool.service_first_period_amount,nvl(ool.Ordered_Quantity,0)*(ool.unit_selling_price)),OE_ORDER_UTIL.G_Precision))
7912: INTO
7913: l_tax_total

Line 7911: ,SUM(ROUND(NVL(ool.service_first_period_amount,nvl(ool.Ordered_Quantity,0)*(ool.unit_selling_price)),OE_ORDER_UTIL.G_Precision))

7907: SUM(ROUND(nvl(ool.tax_value,0),OE_ORDER_UTIL.G_Precision))
7908: /*, SUM(ROUND(nvl(ool.Ordered_Quantity,0)
7909: *(ool.unit_selling_price),OE_ORDER_UTIL.G_Precision)) */ -- sol_ord_er #16014165
7910: -- First Period Bill Amt should not consider ordered quantity
7911: ,SUM(ROUND(NVL(ool.service_first_period_amount,nvl(ool.Ordered_Quantity,0)*(ool.unit_selling_price)),OE_ORDER_UTIL.G_Precision))
7912: INTO
7913: l_tax_total
7914: , l_order_total
7915: FROM oe_order_lines_all ool

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

7928: OR mti.invoice_enabled_flag = 'N'));
7929:
7930: IF OE_Commitment_Pvt.Do_Commitment_Sequencing THEN
7931: -- Select the committment applied amount if Commitment Sequencing "On"
7932: SELECT SUM(ROUND(nvl(op.commitment_applied_amount,0),OE_ORDER_UTIL.G_Precision))
7933: INTO l_commitment_total
7934: FROM oe_payments op,
7935: oe_order_lines_all ool --bug3225795
7936: WHERE op.header_id = p_header_id

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

7947: AND (mti.invoiceable_item_flag = 'N'
7948: OR mti.invoice_enabled_flag = 'N'));
7949: ELSE
7950: -- Select the Outbound Extended Price for lines that have committment
7951: SELECT /*SUM(ROUND(nvl(ool.Ordered_Quantity,0) * (ool.unit_selling_price),OE_ORDER_UTIL.G_Precision)) */
7952: -- sol_ord_er #16014165
7953: -- First Period Bill Amt should not consider ordered quantity
7954: SUM(ROUND(NVL(ool.service_first_period_amount,nvl(ool.Ordered_Quantity,0)*(ool.unit_selling_price)),OE_ORDER_UTIL.G_Precision))
7955: INTO l_commitment_total

Line 7954: SUM(ROUND(NVL(ool.service_first_period_amount,nvl(ool.Ordered_Quantity,0)*(ool.unit_selling_price)),OE_ORDER_UTIL.G_Precision))

7950: -- Select the Outbound Extended Price for lines that have committment
7951: SELECT /*SUM(ROUND(nvl(ool.Ordered_Quantity,0) * (ool.unit_selling_price),OE_ORDER_UTIL.G_Precision)) */
7952: -- sol_ord_er #16014165
7953: -- First Period Bill Amt should not consider ordered quantity
7954: SUM(ROUND(NVL(ool.service_first_period_amount,nvl(ool.Ordered_Quantity,0)*(ool.unit_selling_price)),OE_ORDER_UTIL.G_Precision))
7955: INTO l_commitment_total
7956: FROM oe_order_lines_all ool
7957: WHERE ool.header_id = p_header_id
7958: AND ool.commitment_id is not null

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

7972:
7973: -- Select the Outbound Charges Total
7974:
7975: SELECT SUM(
7976: ROUND(DECODE(P.CREDIT_OR_CHARGE_FLAG,'C',(-1) * P.OPERAND,P.OPERAND),OE_ORDER_UTIL.G_Precision)
7977: )
7978: INTO l_chgs_wo_line_id
7979: FROM OE_PRICE_ADJUSTMENTS P
7980: WHERE P.HEADER_ID = p_header_id

Line 7994: ),OE_ORDER_UTIL.G_Precision)

7990: (-1) * (L.ORDERED_QUANTITY*P.ADJUSTED_AMOUNT)),
7991: DECODE(P.ARITHMETIC_OPERATOR, 'LUMPSUM',
7992: P.OPERAND,
7993: (L.ORDERED_QUANTITY*P.ADJUSTED_AMOUNT))
7994: ),OE_ORDER_UTIL.G_Precision)
7995: )
7996: INTO l_chgs_w_line_id
7997: FROM OE_PRICE_ADJUSTMENTS P,
7998: OE_ORDER_LINES_ALL L

Line 8215: OE_ORDER_UTIL.Update_Global_Picture

8211:
8212: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
8213:
8214: -- call notification framework to get header index position
8215: OE_ORDER_UTIL.Update_Global_Picture
8216: (p_Upd_New_Rec_If_Exists =>FALSE
8217: , p_header_rec => l_header_rec
8218: , p_old_header_rec => l_old_header_rec
8219: , p_header_id => l_header_rec.header_id

Line 8233: OE_ORDER_UTIL.g_header_rec.payment_amount:=

8229:
8230: IF l_notify_index is not null then
8231: -- modify Global Picture
8232:
8233: OE_ORDER_UTIL.g_header_rec.payment_amount:=
8234: l_header_rec.payment_amount;
8235: OE_ORDER_UTIL.g_header_rec.credit_card_approval_code:=
8236: l_header_rec.credit_card_approval_code;
8237: OE_ORDER_UTIL.g_header_rec.credit_card_approval_date:=

Line 8235: OE_ORDER_UTIL.g_header_rec.credit_card_approval_code:=

8231: -- modify Global Picture
8232:
8233: OE_ORDER_UTIL.g_header_rec.payment_amount:=
8234: l_header_rec.payment_amount;
8235: OE_ORDER_UTIL.g_header_rec.credit_card_approval_code:=
8236: l_header_rec.credit_card_approval_code;
8237: OE_ORDER_UTIL.g_header_rec.credit_card_approval_date:=
8238: l_header_rec.credit_card_approval_date;
8239: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;

Line 8237: OE_ORDER_UTIL.g_header_rec.credit_card_approval_date:=

8233: OE_ORDER_UTIL.g_header_rec.payment_amount:=
8234: l_header_rec.payment_amount;
8235: OE_ORDER_UTIL.g_header_rec.credit_card_approval_code:=
8236: l_header_rec.credit_card_approval_code;
8237: OE_ORDER_UTIL.g_header_rec.credit_card_approval_date:=
8238: l_header_rec.credit_card_approval_date;
8239: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
8240: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
8241: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;

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

8235: OE_ORDER_UTIL.g_header_rec.credit_card_approval_code:=
8236: l_header_rec.credit_card_approval_code;
8237: OE_ORDER_UTIL.g_header_rec.credit_card_approval_date:=
8238: l_header_rec.credit_card_approval_date;
8239: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
8240: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
8241: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
8242: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;
8243:

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

8236: l_header_rec.credit_card_approval_code;
8237: OE_ORDER_UTIL.g_header_rec.credit_card_approval_date:=
8238: l_header_rec.credit_card_approval_date;
8239: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
8240: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
8241: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
8242: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;
8243:
8244: IF l_debug_level > 0 THEN

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

8237: OE_ORDER_UTIL.g_header_rec.credit_card_approval_date:=
8238: l_header_rec.credit_card_approval_date;
8239: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
8240: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
8241: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
8242: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;
8243:
8244: IF l_debug_level > 0 THEN
8245: oe_debug_pub.add( 'GLOBAL HDR PAYMENT_AMOUNT IS: ' || OE_ORDER_UTIL.G_HEADER_REC.PAYMENT_AMOUNT , 1 ) ;

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

8238: l_header_rec.credit_card_approval_date;
8239: OE_ORDER_UTIL.g_header_rec.last_updated_by:=l_header_rec.last_updated_by;
8240: OE_ORDER_UTIL.g_header_rec.last_update_login:=l_header_rec.last_update_login;
8241: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
8242: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;
8243:
8244: IF l_debug_level > 0 THEN
8245: oe_debug_pub.add( 'GLOBAL HDR PAYMENT_AMOUNT IS: ' || OE_ORDER_UTIL.G_HEADER_REC.PAYMENT_AMOUNT , 1 ) ;
8246: END IF;

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

8241: OE_ORDER_UTIL.g_header_rec.last_update_date:=l_header_rec.last_update_date;
8242: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;
8243:
8244: IF l_debug_level > 0 THEN
8245: oe_debug_pub.add( 'GLOBAL HDR PAYMENT_AMOUNT IS: ' || OE_ORDER_UTIL.G_HEADER_REC.PAYMENT_AMOUNT , 1 ) ;
8246: END IF;
8247: IF l_debug_level > 0 THEN
8248: oe_debug_pub.add( 'GLOBAL HDR CC APPROVAL_CODE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.CREDIT_CARD_APPROVAL_CODE , 1 ) ;
8249: END IF;

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

8244: IF l_debug_level > 0 THEN
8245: oe_debug_pub.add( 'GLOBAL HDR PAYMENT_AMOUNT IS: ' || OE_ORDER_UTIL.G_HEADER_REC.PAYMENT_AMOUNT , 1 ) ;
8246: END IF;
8247: IF l_debug_level > 0 THEN
8248: oe_debug_pub.add( 'GLOBAL HDR CC APPROVAL_CODE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.CREDIT_CARD_APPROVAL_CODE , 1 ) ;
8249: END IF;
8250: IF l_debug_level > 0 THEN
8251: oe_debug_pub.add( 'GLOBAL HDR CC APPROVAL_DATE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.CREDIT_CARD_APPROVAL_DATE , 1 ) ;
8252: END IF;

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

8247: IF l_debug_level > 0 THEN
8248: oe_debug_pub.add( 'GLOBAL HDR CC APPROVAL_CODE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.CREDIT_CARD_APPROVAL_CODE , 1 ) ;
8249: END IF;
8250: IF l_debug_level > 0 THEN
8251: oe_debug_pub.add( 'GLOBAL HDR CC APPROVAL_DATE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.CREDIT_CARD_APPROVAL_DATE , 1 ) ;
8252: END IF;
8253:
8254: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8255: RAISE FND_API.G_EXC_ERROR;