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_MSG_PUB

Line 321: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

317: RETURN FALSE;
318: END IF;
319: EXCEPTION
320: WHEN OTHERS THEN
321: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
322: IF l_debug_level > 0 THEN
323: oe_debug_pub.add( 'RETURN_LINE: WHEN OTHERS EXCEPTION ' , 1 ) ;
324: END IF;
325: OE_MSG_PUB.Add_Exc_Msg

Line 325: OE_MSG_PUB.Add_Exc_Msg

321: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
322: IF l_debug_level > 0 THEN
323: oe_debug_pub.add( 'RETURN_LINE: WHEN OTHERS EXCEPTION ' , 1 ) ;
324: END IF;
325: OE_MSG_PUB.Add_Exc_Msg
326: ( G_PKG_NAME
327: , 'Return_Line'
328: );
329: END IF;

Line 558: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

554: RETURN FALSE;
555: END IF;
556: EXCEPTION
557: WHEN OTHERS THEN
558: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
559: THEN
560: IF l_debug_level > 0 THEN
561: oe_debug_pub.add( 'SHIPPPING_INFO_AVAILABLE: WHEN OTHERS EXCEPTION ' , 1 ) ;
562: END IF;

Line 563: OE_MSG_PUB.Add_Exc_Msg

559: THEN
560: IF l_debug_level > 0 THEN
561: oe_debug_pub.add( 'SHIPPPING_INFO_AVAILABLE: WHEN OTHERS EXCEPTION ' , 1 ) ;
562: END IF;
563: OE_MSG_PUB.Add_Exc_Msg
564: ( G_PKG_NAME
565: , 'Shippping_info_Available'
566: );
567: END IF;

Line 703: OE_MSG_PUB.ADD;

699: IF l_debug_level > 0 THEN
700: oe_debug_pub.add( 'NOT ABLE TO RETRIEVE CUST PRODUCT LINE ID' ) ;
701: END IF;
702: FND_MESSAGE.SET_NAME('ONT','ONT_NO_CUST_PROD_LINE');
703: OE_MSG_PUB.ADD;
704: RAISE NO_DATA_FOUND;
705: END IF;
706: end commenting for bug# 5032978 */
707: l_service_reference_line_id := NULL;

Line 813: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

809: WHEN NO_DATA_FOUND THEN
810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
811: --RAISE FND_API.G_EXC_ERROR;
812: WHEN OTHERS THEN
813: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
814: THEN
815: IF l_debug_level > 0 THEN
816: oe_debug_pub.add( 'LINE_INVOICEABLE: WHEN OTHERS EXCEPTION '||SQLERRM , 1 ) ;
817: END IF;

Line 818: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME ,'Line_Invoiceable');

814: THEN
815: IF l_debug_level > 0 THEN
816: oe_debug_pub.add( 'LINE_INVOICEABLE: WHEN OTHERS EXCEPTION '||SQLERRM , 1 ) ;
817: END IF;
818: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME ,'Line_Invoiceable');
819: END IF;
820: END Line_Invoiceable;
821:
822: PROCEDURE Check_Invoicing_Holds

Line 856: OE_MSG_PUB.ADD;

852: IF ( l_hold_return_status = FND_API.G_RET_STS_SUCCESS AND
853: l_hold_result_out = FND_API.G_TRUE )
854: THEN
855: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_HOLD');
856: OE_MSG_PUB.ADD;
857: x_return_status := FND_API.G_RET_STS_ERROR;
858: IF l_debug_level > 0 THEN
859: oe_debug_pub.add( 'A Line level Invoicing hold or generic hold found ( 1 ) , Return status : '||X_RETURN_STATUS , 1 ) ;
860: END IF;

Line 879: OE_MSG_PUB.ADD;

875: IF ( l_hold_return_status = FND_API.G_RET_STS_SUCCESS AND
876: l_hold_result_out = FND_API.G_TRUE )
877: THEN
878: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_HOLD');
879: OE_MSG_PUB.ADD;
880: x_return_status := FND_API.G_RET_STS_ERROR;
881: IF l_debug_level > 0 THEN
882: oe_debug_pub.add( 'A Header level Invoicing hold or generic hold found ( 2 ) , Return status '||X_RETURN_STATUS , 1 ) ;
883: END IF;

Line 901: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME ,'Check_Invoicing_Holds');

897: THEN
898: IF l_debug_level > 0 THEN
899: oe_debug_pub.add( 'Check_Invoicing_Holds: WHEN OTHERS EXCEPTION '||SQLERRM , 1 ) ;
900: END IF;
901: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME ,'Check_Invoicing_Holds');
902: END IF;
903: END Check_Invoicing_Holds;
904:
905: FUNCTION Show_Detail_Discounts

Line 2354: OE_MSG_PUB.ADD;

2350: IF l_debug_level > 0 THEN
2351: oe_debug_pub.add( 'QUANTITY TO INVOICE AT ( 4 ) = ' || TO_CHAR ( X_REGULAR_QTY_TO_INVOICE ) , 5 ) ;
2352: END IF;
2353: FND_MESSAGE.SET_NAME('ONT','OE_MANUAL_INVOICE_OVERSHIP_QTY');
2354: OE_MSG_PUB.ADD;
2355: IF l_debug_level > 0 THEN
2356: oe_debug_pub.add( 'EXIT CALCUALTE_QTY_TO_INVOICE ( 4 ) : '||X_REGULAR_QTY_TO_INVOICE , 5 ) ;
2357: END IF;
2358: RETURN;

Line 2618: OE_MSG_PUB.ADD;

2614: -- Check For all Required Attributes
2615: IF p_interface_line_rec.Batch_Source_Name IS NULL THEN
2616: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');
2617: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Batch_Source_Name');
2618: OE_MSG_PUB.ADD;
2619: IF l_debug_level > 0 THEN
2620: oe_debug_pub.add( 'REQUIRED ATTRIBUTE BATCH SOURCE NAME IS MISSING' , 1 ) ;
2621: END IF;
2622: RETURN FALSE;

Line 2626: OE_MSG_PUB.ADD;

2622: RETURN FALSE;
2623: ELSIF p_interface_line_rec.Set_Of_Books_Id IS NULL THEN
2624: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');
2625: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Set_Of_Books_Id');
2626: OE_MSG_PUB.ADD;
2627: IF l_debug_level > 0 THEN
2628: oe_debug_pub.add( 'REQUIRED ATTRIBUTE SET OF BOOKS ID IS MISSING ' , 1 ) ;
2629: END IF;
2630: RETURN FALSE;

Line 2634: OE_MSG_PUB.ADD;

2630: RETURN FALSE;
2631: ELSIF p_interface_line_rec.Line_Type IS NULL THEN
2632: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');
2633: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Line_Type');
2634: OE_MSG_PUB.ADD;
2635: IF l_debug_level > 0 THEN
2636: oe_debug_pub.add( 'REQUIRED ATTRIBUTE LINE TYPE IS MISSING' , 1 ) ;
2637: END IF;
2638: RETURN FALSE;

Line 2642: OE_MSG_PUB.ADD;

2638: RETURN FALSE;
2639: ELSIF p_interface_line_rec.Description IS NULL THEN
2640: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');
2641: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Description');
2642: OE_MSG_PUB.ADD;
2643: IF l_debug_level > 0 THEN
2644: oe_debug_pub.add( 'REQUIRED ATTRIBUTE DESCRIPTION IS MISSING' , 1 ) ;
2645: END IF;
2646: RETURN FALSE;

Line 2650: OE_MSG_PUB.ADD;

2646: RETURN FALSE;
2647: ELSIF p_interface_line_rec.Currency_Code IS NULL THEN
2648: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');
2649: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Currency_Code');
2650: OE_MSG_PUB.ADD;
2651: IF l_debug_level > 0 THEN
2652: oe_debug_pub.add( 'REQUIRED ATTRIBUTE CURRENCY CODE IS MISSING' , 1 ) ;
2653: END IF;
2654: RETURN FALSE;

Line 2658: OE_MSG_PUB.ADD;

2654: RETURN FALSE;
2655: ELSIF p_interface_line_rec.Conversion_Type IS NULL THEN
2656: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');
2657: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Conversion_Type');
2658: OE_MSG_PUB.ADD;
2659: IF l_debug_level > 0 THEN
2660: oe_debug_pub.add( 'REQUIRED ATTRIBUTE CONVERSION TYPE IS MISSING' , 1 ) ;
2661: END IF;
2662: RETURN FALSE;

Line 2668: OE_MSG_PUB.ADD;

2664: (p_interface_line_rec.Cust_Trx_Type_Id IS NULL OR
2665: p_interface_line_rec.Cust_Trx_Type_Id = 0) THEN
2666: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');
2667: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Cust_Trx_Type_Id');
2668: OE_MSG_PUB.ADD;
2669: IF l_debug_level > 0 THEN
2670: oe_debug_pub.add( 'REQUIRED ATTRIBUTE CUSTOMER TRX TYPE ID IS MISSING' , 1 ) ;
2671: END IF;
2672: RETURN FALSE;

Line 2681: OE_MSG_PUB.ADD;

2677: END IF;
2678: RETURN FALSE;
2679: ELSIF p_interface_line_rec.customer_bank_account_id = -1 THEN
2680: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');
2681: OE_MSG_PUB.ADD;
2682: IF l_debug_level > 0 THEN
2683: oe_debug_pub.add( 'REQUIRED ATTRIBUTE CUSTOMER CREDIT CARD BANK ACCOUNT IS MISSING' , 1 ) ;
2684: END IF;
2685: RETURN FALSE;

Line 2689: OE_MSG_PUB.ADD;

2685: RETURN FALSE;
2686: ELSIF p_interface_line_rec.customer_bank_account_id > 0
2687: AND p_interface_line_rec.receipt_method_id IS NULL THEN
2688: FND_MESSAGE.SET_NAME('ONT','OE_VPM_NO_PAY_METHOD');
2689: OE_MSG_PUB.ADD;
2690: IF l_debug_level > 0 THEN
2691: oe_debug_pub.add( 'REQUIRED ATTRIBUTE PAYMENT METHOD IS MISSING' , 1 ) ;
2692: END IF;
2693: RETURN FALSE;

Line 2698: OE_MSG_PUB.ADD;

2694: -- bug 8494362 start
2695: ELSIF p_interface_line_rec.INTERFACE_LINE_CONTEXT IS NULL THEN
2696: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');
2697: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Interface Line Context');
2698: OE_MSG_PUB.ADD;
2699: IF l_debug_level > 0 THEN
2700: oe_debug_pub.add( 'REQUIRED ATTRIBUTE INTERFACE_LINE_CONTEXT IS MISSING' , 1 ) ;
2701: END IF;
2702: RETURN FALSE;

Line 2857: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2853: WHEN OTHERS THEN
2854: IF l_debug_level > 0 THEN
2855: oe_debug_pub.add( 'EXCEPTION , QUERY LINE SALES CREDITS '||SQLERRM , 1 ) ;
2856: END IF;
2857: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2858: THEN
2859: oe_msg_pub.Add_Exc_Msg
2860: ( G_PKG_NAME
2861: , 'Query_Line_Scredits'

Line 2859: oe_msg_pub.Add_Exc_Msg

2855: oe_debug_pub.add( 'EXCEPTION , QUERY LINE SALES CREDITS '||SQLERRM , 1 ) ;
2856: END IF;
2857: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2858: THEN
2859: oe_msg_pub.Add_Exc_Msg
2860: ( G_PKG_NAME
2861: , 'Query_Line_Scredits'
2862: );
2863: END IF;

Line 2975: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2971: WHEN OTHERS THEN
2972: IF l_debug_level > 0 THEN
2973: oe_debug_pub.add( 'EXCEPTION , QUERY HEADER SALES CREDITS ( ) ' , 5 ) ;
2974: END IF;
2975: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2976: THEN
2977: oe_msg_pub.Add_Exc_Msg
2978: ( G_PKG_NAME
2979: , 'Query_Header_Scredits'

Line 2977: oe_msg_pub.Add_Exc_Msg

2973: oe_debug_pub.add( 'EXCEPTION , QUERY HEADER SALES CREDITS ( ) ' , 5 ) ;
2974: END IF;
2975: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2976: THEN
2977: oe_msg_pub.Add_Exc_Msg
2978: ( G_PKG_NAME
2979: , 'Query_Header_Scredits'
2980: );
2981: END IF;

Line 3615: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3611: err_msg := 'Error while inserting to RA_INTERFACE_LINES_ALL :\n '|| SQLERRM;
3612: IF l_debug_level > 0 THEN
3613: oe_debug_pub.add( ERR_MSG || ' SQLCODE: '||TO_CHAR ( SQLCODE ) , 1 ) ;
3614: END IF;
3615: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3616: OE_MSG_PUB.Add_Exc_Msg
3617: ( G_PKG_NAME
3618: , 'Insert_Line'
3619: );

Line 3616: OE_MSG_PUB.Add_Exc_Msg

3612: IF l_debug_level > 0 THEN
3613: oe_debug_pub.add( ERR_MSG || ' SQLCODE: '||TO_CHAR ( SQLCODE ) , 1 ) ;
3614: END IF;
3615: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3616: OE_MSG_PUB.Add_Exc_Msg
3617: ( G_PKG_NAME
3618: , 'Insert_Line'
3619: );
3620: END IF;

Line 4056: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4052: EXCEPTION WHEN OTHERS THEN
4053: IF l_debug_level > 0 THEN
4054: oe_debug_pub.add( 'UNABLE TO INSERT SALES CREDIT RECORDS -> '||SQLERRM , 1 ) ;
4055: END IF;
4056: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4057: OE_MSG_PUB.Add_Exc_Msg
4058: ( G_PKG_NAME
4059: , 'Insert_Salescredit'
4060: );

Line 4057: OE_MSG_PUB.Add_Exc_Msg

4053: IF l_debug_level > 0 THEN
4054: oe_debug_pub.add( 'UNABLE TO INSERT SALES CREDIT RECORDS -> '||SQLERRM , 1 ) ;
4055: END IF;
4056: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4057: OE_MSG_PUB.Add_Exc_Msg
4058: ( G_PKG_NAME
4059: , 'Insert_Salescredit'
4060: );
4061: END IF;

Line 4284: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4280: IF l_debug_level > 0 THEN
4281: oe_debug_pub.add( 'EXCEPTION INTERFACE_SALES_CREDITS ( ) '||SQLERRM , 1 ) ;
4282: END IF;
4283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4284: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4285: THEN
4286: OE_MSG_PUB.Add_Exc_Msg
4287: ( G_PKG_NAME
4288: , 'Interface_SalesCredits');

Line 4286: OE_MSG_PUB.Add_Exc_Msg

4282: END IF;
4283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4284: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4285: THEN
4286: OE_MSG_PUB.Add_Exc_Msg
4287: ( G_PKG_NAME
4288: , 'Interface_SalesCredits');
4289: END IF;
4290: END Interface_SalesCredits;

Line 4349: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4345: WHEN OTHERS THEN
4346: IF l_debug_level > 0 THEN
4347: oe_debug_pub.add( 'EXCEPTION , INTERFACE SALES CREDITS FOR FREIGHT '||SQLERRM , 1 ) ;
4348: END IF;
4349: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4350: THEN
4351: OE_MSG_PUB.Add_Exc_Msg
4352: ( G_PKG_NAME
4353: , 'Interface_scredits_for_freight'

Line 4351: OE_MSG_PUB.Add_Exc_Msg

4347: oe_debug_pub.add( 'EXCEPTION , INTERFACE SALES CREDITS FOR FREIGHT '||SQLERRM , 1 ) ;
4348: END IF;
4349: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4350: THEN
4351: OE_MSG_PUB.Add_Exc_Msg
4352: ( G_PKG_NAME
4353: , 'Interface_scredits_for_freight'
4354: );
4355: END IF;

Line 4535: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4531: EXCEPTION WHEN OTHERS THEN
4532: IF l_debug_level > 0 THEN
4533: oe_debug_pub.add( 'UNABLE TO INSERT CONTINGENCY RECORDS -> '||SQLERRM , 1 ) ;
4534: END IF;
4535: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4536: OE_MSG_PUB.Add_Exc_Msg
4537: ( G_PKG_NAME
4538: , 'Insert_Contingency'
4539: );

Line 4536: OE_MSG_PUB.Add_Exc_Msg

4532: IF l_debug_level > 0 THEN
4533: oe_debug_pub.add( 'UNABLE TO INSERT CONTINGENCY RECORDS -> '||SQLERRM , 1 ) ;
4534: END IF;
4535: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4536: OE_MSG_PUB.Add_Exc_Msg
4537: ( G_PKG_NAME
4538: , 'Insert_Contingency'
4539: );
4540: END IF;

Line 4596: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4592: IF l_debug_level > 0 THEN
4593: oe_debug_pub.add( 'EXCEPTION INTERFACE_CONTINGENCIES ( ) '||SQLERRM , 1 ) ;
4594: END IF;
4595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4596: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4597: THEN
4598: OE_MSG_PUB.Add_Exc_Msg
4599: ( G_PKG_NAME
4600: , 'Interface_Contingencies');

Line 4598: OE_MSG_PUB.Add_Exc_Msg

4594: END IF;
4595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4596: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4597: THEN
4598: OE_MSG_PUB.Add_Exc_Msg
4599: ( G_PKG_NAME
4600: , 'Interface_Contingencies');
4601: END IF;
4602: END Interface_Contingencies;

Line 4688: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4684: WHEN OTHERS THEN
4685: IF l_debug_level > 0 THEN
4686: oe_debug_pub.add( 'EXCEPTION , ROUNDING DIFFERENCE '||SQLERRM , 1 ) ;
4687: END IF;
4688: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4689: THEN
4690: OE_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,'Get_Rounding_Diff');
4691: END IF;
4692: END Get_Rounding_Diff;

Line 4690: OE_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,'Get_Rounding_Diff');

4686: oe_debug_pub.add( 'EXCEPTION , ROUNDING DIFFERENCE '||SQLERRM , 1 ) ;
4687: END IF;
4688: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4689: THEN
4690: OE_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,'Get_Rounding_Diff');
4691: END IF;
4692: END Get_Rounding_Diff;
4693:
4694: PROCEDURE Interface_Detail_Discounts

Line 4939: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4935: oe_debug_pub.add( 'EXCEPTION IN INTERFACE_DETAIL_DISCOUNTS '||SQLERRM , 1 ) ;
4936: END IF;
4937: -- Fix for the bug 2187074
4938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4939: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4940: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Interface_Detail_Discounts');
4941: END IF;
4942:
4943: END Interface_Detail_Discounts;

Line 4940: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Interface_Detail_Discounts');

4936: END IF;
4937: -- Fix for the bug 2187074
4938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4939: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4940: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Interface_Detail_Discounts');
4941: END IF;
4942:
4943: END Interface_Detail_Discounts;
4944:

Line 5092: OE_MSG_PUB.Add_Exc_Msg

5088: WHEN OTHERS THEN
5089: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5090: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5091: THEN
5092: OE_MSG_PUB.Add_Exc_Msg
5093: ( G_PKG_NAME
5094: , 'Update_Invoiced_flag'
5095: );
5096: END IF;

Line 5199: OE_MSG_PUB.ADD;

5195: EXCEPTION
5196: WHEN NO_DATA_FOUND THEN
5197: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
5198: FND_MESSAGE.SET_NAME('ONT','ONT_FREIGHT_ITEM_REQUIRED');
5199: OE_MSG_PUB.ADD;
5200: END IF;
5201:
5202: RAISE FND_API.G_EXC_ERROR;
5203: END;

Line 5854: OE_MSG_PUB.Add_Exc_Msg

5850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5851: IF FND_MSG_PUB.Check_Msg_Level
5852: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5853: THEN
5854: OE_MSG_PUB.Add_Exc_Msg
5855: ( G_PKG_NAME
5856: , 'Interface_Freight_Charges'
5857: );
5858: END IF;

Line 6908: OE_MSG_PUB.ADD;

6904: IF p_x_interface_line_rec.accounting_rule_duration IS NULL THEN
6905: IF p_line_rec.service_start_date IS NULL OR p_line_rec.service_end_date IS NULL THEN
6906: -- bug# 4190312 post message and complete with status INCOMPLETE
6907: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ACCT_RULE_DURATION');
6908: OE_MSG_PUB.ADD;
6909: IF l_debug_level > 0 THEN
6910: oe_debug_pub.add( 'SERVICE START DATE OR SERVICE END DATE IS NULL' , 3 ) ;
6911: END IF;
6912: p_x_interface_line_rec.ACCOUNTING_RULE_DURATION := -1;

Line 6960: OE_MSG_PUB.ADD;

6956: FND_MESSAGE.SET_TOKEN('START_DATE', p_line_rec.service_start_date);
6957: --FND_MESSAGE.SET_TOKEN('END_DATE', p_line_rec.service_end_date); -- sol_ord_er #16014165
6958: FND_MESSAGE.SET_TOKEN('END_DATE', NVL(p_line_rec.service_first_period_enddate,p_line_rec.service_end_date));
6959: FND_MESSAGE.SET_TOKEN('CALENDAR_NAME', l_calendar_name);
6960: OE_MSG_PUB.ADD;
6961: IF l_debug_level > 0 THEN
6962: oe_debug_pub.add('Atleast one or more dates ('||l_unmapped_date||') within the date range that are not associated with any adjustment period.');
6963: END IF;
6964: END IF;

Line 6974: OE_MSG_PUB.ADD;

6970: FND_MESSAGE.SET_TOKEN('START_DATE', p_line_rec.service_start_date);
6971: --FND_MESSAGE.SET_TOKEN('END_DATE', p_line_rec.service_end_date); -- sol_ord_er #16014165
6972: FND_MESSAGE.SET_TOKEN('END_DATE', NVL(p_line_rec.service_first_period_enddate,p_line_rec.service_end_date));
6973: FND_MESSAGE.SET_TOKEN('CALENDAR_NAME', l_calendar_name);
6974: OE_MSG_PUB.ADD;
6975: IF l_debug_level > 0 THEN
6976: oe_debug_pub.add( 'ERROR IN GL_CALENDAR_PKG.Get_Num_Periods_In_Date_Range ; ERROR => '||SQLERRM , 1 ) ;
6977: END IF;
6978: END;

Line 7182: OE_MSG_PUB.ADD;

7178: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
7179: l_parent_line_id := l_order_line_id;
7180: ELSE
7181: FND_MESSAGE.SET_NAME('ONT','ONT_NO_CUST_PROD_LINE');
7182: OE_MSG_PUB.ADD;
7183: END IF;
7184: ELSE -- not a customer product
7185: l_parent_line_id := p_line_rec.service_reference_line_id;
7186: END IF;

Line 8056: OE_MSG_PUB.Add_Exc_Msg

8052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8053: IF FND_MSG_PUB.Check_Msg_Level
8054: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8055: THEN
8056: OE_MSG_PUB.Add_Exc_Msg
8057: ( G_PKG_NAME
8058: , 'Update_Invoice_Attributes'
8059: );
8060: END IF;

Line 8620: OE_MSG_PUB.ADD;

8616: END IF;
8617: --Customer Acceptance
8618: IF l_line_rejected AND p_line_rec.line_category_code = 'RETURN' THEN
8619: FND_MESSAGE.SET_NAME('ONT','ONT_RMA_NO_CREDIT');
8620: OE_MSG_PUB.ADD;
8621: END IF;
8622: --Customer Acceptance
8623: RETURN;
8624: END IF;

Line 8650: OE_MSG_PUB.ADD;

8646: ,'RFR-PENDING'
8647: ,x_return_status);
8648: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
8649: FND_MESSAGE.SET_NAME('ONT','OE_INVOICE_WAIT_FOR_RFR');
8650: OE_MSG_PUB.ADD;
8651: END IF;
8652: END IF;
8653: IF l_debug_level > 0 THEN
8654: oe_debug_pub.add( 'REQUEST_ID AFTER INSERTING '||P_X_INTERFACE_LINE_REC.REQUEST_ID , 5 ) ;

Line 8773: OE_MSG_PUB.ADD;

8769: ,'RFR-PENDING'
8770: ,x_return_status);
8771: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
8772: FND_MESSAGE.SET_NAME('ONT','OE_INVOICE_WAIT_FOR_RFR');
8773: OE_MSG_PUB.ADD;
8774: END IF;
8775: ELSE
8776: Update_Invoice_Attributes(p_line_rec
8777: ,p_x_interface_line_rec

Line 8827: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

8823: IF l_debug_level > 0 THEN
8824: oe_debug_pub.add( 'OTHER EXCEPTION. EXITING INTERFACE_SINGLE_LINE : '||SQLERRM , 1 ) ;
8825: oe_debug_pub.add( 'RETURN STATUS :'||X_RETURN_STATUS||' OUT RESULT : '||X_RESULT_OUT , 5 ) ;
8826: END IF;
8827: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8828: OE_MSG_PUB.Add_Exc_Msg
8829: ( G_PKG_NAME
8830: , 'Interface_Single_line'
8831: );

Line 8828: OE_MSG_PUB.Add_Exc_Msg

8824: oe_debug_pub.add( 'OTHER EXCEPTION. EXITING INTERFACE_SINGLE_LINE : '||SQLERRM , 1 ) ;
8825: oe_debug_pub.add( 'RETURN STATUS :'||X_RETURN_STATUS||' OUT RESULT : '||X_RESULT_OUT , 5 ) ;
8826: END IF;
8827: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8828: OE_MSG_PUB.Add_Exc_Msg
8829: ( G_PKG_NAME
8830: , 'Interface_Single_line'
8831: );
8832: END IF;

Line 8939: --bug 5336623 Commented the following call to OE_MSG_PUB.set_msg_context

8935: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN
8936: SAVEPOINT INVOICE_INTERFACE;
8937: END IF;
8938:
8939: --bug 5336623 Commented the following call to OE_MSG_PUB.set_msg_context
8940: --Exception management begin
8941: /* OE_MSG_PUB.set_msg_context(
8942: p_entity_code => 'LINE'
8943: ,p_entity_id => p_line_id

Line 8941: /* OE_MSG_PUB.set_msg_context(

8937: END IF;
8938:
8939: --bug 5336623 Commented the following call to OE_MSG_PUB.set_msg_context
8940: --Exception management begin
8941: /* OE_MSG_PUB.set_msg_context(
8942: p_entity_code => 'LINE'
8943: ,p_entity_id => p_line_id
8944: ,p_line_id => p_line_id ); */
8945: --Exception management end

Line 8975: OE_MSG_PUB.set_msg_context(

8971: IF p_itemtype = OE_GLOBALS.G_WFI_HDR THEN
8972: p_header_id := l_line_rec.header_id;
8973: END IF;
8974: -- Set message context
8975: OE_MSG_PUB.set_msg_context(
8976: p_entity_code => 'LINE'
8977: ,p_entity_id => l_line_rec.line_id
8978: ,p_header_id => l_line_rec.header_id
8979: ,p_line_id => l_line_rec.line_id

Line 9011: OE_MSG_PUB.Add;

9007: x_return_status := FND_API.G_RET_STS_ERROR;
9008: l_line_rec.return_status := FND_API.G_RET_STS_ERROR;
9009: l_line_rec.line_id := null;
9010: FND_MESSAGE.Set_Name('ONT', 'OE_LINE_LOCKED');
9011: OE_MSG_PUB.Add;
9012: RAISE FND_API.G_EXC_ERROR;
9013: */
9014:
9015: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN

Line 9028: OE_MSG_PUB.Add;

9024: END IF;
9025: x_result_out := NULL;
9026: x_return_status := 'DEFERRED';
9027: FND_MESSAGE.Set_Name('ONT', 'OE_LINE_LOCKED');
9028: OE_MSG_PUB.Add;
9029: RETURN;
9030: --- bug# 7600960 : end
9031:
9032: WHEN NO_DATA_FOUND THEN

Line 9450: OE_MSG_PUB.ADD;

9446: END IF;
9447: --Customer Acceptance
9448: IF l_line_rejected AND l_line_rec.line_category_code = 'RETURN' THEN
9449: FND_MESSAGE.SET_NAME('ONT','ONT_RMA_NO_CREDIT');
9450: OE_MSG_PUB.ADD;
9451: END IF;
9452: --Customer Acceptance
9453: RETURN;
9454: END IF;

Line 9637: OE_MSG_PUB.ADD;

9633: WHERE dl.delivery_id = l_delivery_line_id;
9634: END IF;
9635: FND_MESSAGE.SET_NAME('ONT','OE_INVOICE_WAIT_FOR_DELIVERY');
9636: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',l_delivery_name);
9637: OE_MSG_PUB.ADD;
9638: END IF;
9639: IF l_debug_level > 0 THEN
9640: oe_debug_pub.add( 'INTERFACE STATUS : '||L_LINE_REC.INVOICE_INTERFACE_STATUS_CODE , 5 ) ;
9641: oe_debug_pub.add( 'X_RETURN_STATUS : '||X_RETURN_STATUS , 5 ) ;

Line 9806: OE_MSG_PUB.ADD;

9802: ,'RFR-PENDING'
9803: ,x_return_status);
9804: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
9805: FND_MESSAGE.SET_NAME('ONT','OE_INVOICE_WAIT_FOR_RFR');
9806: OE_MSG_PUB.ADD;
9807: END IF;
9808: IF l_debug_level > 0 THEN
9809: oe_debug_pub.add( 'RFR: L_LINE_REC.INTERFACE_STATUS '||L_LINE_REC.INVOICE_INTERFACE_STATUS_CODE , 5 ) ;
9810: oe_debug_pub.add( 'RFR: X_RETURN_STATUS :'||X_RETURN_STATUS , 5 ) ;

Line 10082: OE_MSG_PUB.Count_And_Get

10078: Update_line_flow_status(l_line_rec.line_id,l_flow_status_code,
10079: l_line_rec.order_source_id); -- 8541809
10080: END IF;
10081:
10082: OE_MSG_PUB.Count_And_Get
10083: ( p_count => x_msg_count
10084: , p_data => x_msg_data
10085: );
10086: x_return_status := FND_API.G_RET_STS_ERROR;

Line 10094: OE_MSG_PUB.Count_And_Get

10090: END IF;
10091: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN
10092: ROLLBACK TO INVOICE_INTERFACE;
10093: END IF;
10094: OE_MSG_PUB.Count_And_Get
10095: ( p_count => x_msg_count
10096: , p_data => x_msg_data
10097: );
10098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 10115: OE_MSG_PUB.Add_Exc_Msg

10111: END IF;
10112: IF FND_MSG_PUB.Check_Msg_Level
10113: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
10114: THEN
10115: OE_MSG_PUB.Add_Exc_Msg
10116: ( G_PKG_NAME
10117: , 'Interface_Line'
10118: );
10119: END IF;

Line 10120: OE_MSG_PUB.Count_And_Get

10116: ( G_PKG_NAME
10117: , 'Interface_Line'
10118: );
10119: END IF;
10120: OE_MSG_PUB.Count_And_Get
10121: ( p_count => x_msg_count
10122: , p_data => x_msg_data
10123: );
10124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 10270: OE_MSG_PUB.Count_And_Get

10266: END IF;
10267: Update_header_flow_status(p_header_id,l_flow_status_code);
10268: END IF;
10269:
10270: OE_MSG_PUB.Count_And_Get
10271: ( p_count => x_msg_count
10272: , p_data => x_msg_data
10273: );
10274: x_return_status := FND_API.G_RET_STS_ERROR;

Line 10283: OE_MSG_PUB.Count_And_Get

10279: IF (order_line_cursor%ISOPEN) THEN
10280: CLOSE order_line_cursor;
10281: END IF;
10282: ROLLBACK TO HEADER_INVOICE_INTERFACE;
10283: OE_MSG_PUB.Count_And_Get
10284: ( p_count => x_msg_count
10285: , p_data => x_msg_data
10286: );
10287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 10297: IF OE_MSG_PUB.Check_Msg_Level

10293: IF (order_line_cursor%ISOPEN) THEN
10294: CLOSE order_line_cursor;
10295: END IF;
10296: ROLLBACK TO HEADER_INVOICE_INTERFACE;
10297: IF OE_MSG_PUB.Check_Msg_Level
10298: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
10299: THEN
10300: OE_MSG_PUB.Add_Exc_Msg
10301: ( G_PKG_NAME

Line 10298: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

10294: CLOSE order_line_cursor;
10295: END IF;
10296: ROLLBACK TO HEADER_INVOICE_INTERFACE;
10297: IF OE_MSG_PUB.Check_Msg_Level
10298: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
10299: THEN
10300: OE_MSG_PUB.Add_Exc_Msg
10301: ( G_PKG_NAME
10302: , 'Interface_Header'

Line 10300: OE_MSG_PUB.Add_Exc_Msg

10296: ROLLBACK TO HEADER_INVOICE_INTERFACE;
10297: IF OE_MSG_PUB.Check_Msg_Level
10298: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
10299: THEN
10300: OE_MSG_PUB.Add_Exc_Msg
10301: ( G_PKG_NAME
10302: , 'Interface_Header'
10303: );
10304: END IF;

Line 10305: OE_MSG_PUB.Count_And_Get

10301: ( G_PKG_NAME
10302: , 'Interface_Header'
10303: );
10304: END IF;
10305: OE_MSG_PUB.Count_And_Get
10306: ( p_count => x_msg_count
10307: , p_data => x_msg_data
10308: );
10309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 10342: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);

10338:
10339: IF l_header_id IS NULL OR
10340: l_header_id = FND_API.G_MISS_NUM
10341: THEN
10342: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
10343: p_result := 0;
10344: END IF;
10345:
10346: -- 3740077 Added the If

Line 10428: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);

10424:
10425: IF l_header_id IS NULL OR
10426: l_header_id = FND_API.G_MISS_NUM
10427: THEN
10428: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
10429: p_result := 0;
10430: END IF;
10431:
10432: IF l_header_id is not null and

Line 10504: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);

10500:
10501: IF l_line_id IS NULL OR
10502: l_line_id = FND_API.G_MISS_NUM
10503: THEN
10504: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
10505: p_result := 0;
10506: END IF;
10507:
10508: BEGIN