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 270: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

266: RETURN FALSE;
267: END IF;
268: EXCEPTION
269: WHEN OTHERS THEN
270: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
271: IF l_debug_level > 0 THEN
272: oe_debug_pub.add( 'RETURN_LINE: WHEN OTHERS EXCEPTION ' , 1 ) ;
273: END IF;
274: OE_MSG_PUB.Add_Exc_Msg

Line 274: OE_MSG_PUB.Add_Exc_Msg

270: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
271: IF l_debug_level > 0 THEN
272: oe_debug_pub.add( 'RETURN_LINE: WHEN OTHERS EXCEPTION ' , 1 ) ;
273: END IF;
274: OE_MSG_PUB.Add_Exc_Msg
275: ( G_PKG_NAME
276: , 'Return_Line'
277: );
278: END IF;

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

358: RETURN FALSE;
359: END IF;
360: EXCEPTION
361: WHEN OTHERS THEN
362: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
363: THEN
364: IF l_debug_level > 0 THEN
365: oe_debug_pub.add( 'SHIPPPING_INFO_AVAILABLE: WHEN OTHERS EXCEPTION ' , 1 ) ;
366: END IF;

Line 367: OE_MSG_PUB.Add_Exc_Msg

363: THEN
364: IF l_debug_level > 0 THEN
365: oe_debug_pub.add( 'SHIPPPING_INFO_AVAILABLE: WHEN OTHERS EXCEPTION ' , 1 ) ;
366: END IF;
367: OE_MSG_PUB.Add_Exc_Msg
368: ( G_PKG_NAME
369: , 'Shippping_info_Available'
370: );
371: END IF;

Line 497: OE_MSG_PUB.ADD;

493: IF l_debug_level > 0 THEN
494: oe_debug_pub.add( 'NOT ABLE TO RETRIEVE CUST PRODUCT LINE ID' ) ;
495: END IF;
496: FND_MESSAGE.SET_NAME('ONT','ONT_NO_CUST_PROD_LINE');
497: OE_MSG_PUB.ADD;
498: RAISE NO_DATA_FOUND;
499: END IF;
500: end commenting for bug# 5032978 */
501: l_service_reference_line_id := NULL;

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

603: WHEN NO_DATA_FOUND THEN
604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
605: --RAISE FND_API.G_EXC_ERROR;
606: WHEN OTHERS THEN
607: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
608: THEN
609: IF l_debug_level > 0 THEN
610: oe_debug_pub.add( 'LINE_INVOICEABLE: WHEN OTHERS EXCEPTION '||SQLERRM , 1 ) ;
611: END IF;

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

608: THEN
609: IF l_debug_level > 0 THEN
610: oe_debug_pub.add( 'LINE_INVOICEABLE: WHEN OTHERS EXCEPTION '||SQLERRM , 1 ) ;
611: END IF;
612: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME ,'Line_Invoiceable');
613: END IF;
614: END Line_Invoiceable;
615:
616: PROCEDURE Check_Invoicing_Holds

Line 650: OE_MSG_PUB.ADD;

646: IF ( l_hold_return_status = FND_API.G_RET_STS_SUCCESS AND
647: l_hold_result_out = FND_API.G_TRUE )
648: THEN
649: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_HOLD');
650: OE_MSG_PUB.ADD;
651: x_return_status := FND_API.G_RET_STS_ERROR;
652: IF l_debug_level > 0 THEN
653: oe_debug_pub.add( 'A Line level Invoicing hold or generic hold found ( 1 ) , Return status : '||X_RETURN_STATUS , 1 ) ;
654: END IF;

Line 673: OE_MSG_PUB.ADD;

669: IF ( l_hold_return_status = FND_API.G_RET_STS_SUCCESS AND
670: l_hold_result_out = FND_API.G_TRUE )
671: THEN
672: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_HOLD');
673: OE_MSG_PUB.ADD;
674: x_return_status := FND_API.G_RET_STS_ERROR;
675: IF l_debug_level > 0 THEN
676: oe_debug_pub.add( 'A Header level Invoicing hold or generic hold found ( 2 ) , Return status '||X_RETURN_STATUS , 1 ) ;
677: END IF;

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

691: THEN
692: IF l_debug_level > 0 THEN
693: oe_debug_pub.add( 'Check_Invoicing_Holds: WHEN OTHERS EXCEPTION '||SQLERRM , 1 ) ;
694: END IF;
695: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME ,'Check_Invoicing_Holds');
696: END IF;
697: END Check_Invoicing_Holds;
698:
699: FUNCTION Show_Detail_Discounts

Line 2137: OE_MSG_PUB.ADD;

2133: IF l_debug_level > 0 THEN
2134: oe_debug_pub.add( 'QUANTITY TO INVOICE AT ( 4 ) = ' || TO_CHAR ( X_REGULAR_QTY_TO_INVOICE ) , 5 ) ;
2135: END IF;
2136: FND_MESSAGE.SET_NAME('ONT','OE_MANUAL_INVOICE_OVERSHIP_QTY');
2137: OE_MSG_PUB.ADD;
2138: IF l_debug_level > 0 THEN
2139: oe_debug_pub.add( 'EXIT CALCUALTE_QTY_TO_INVOICE ( 4 ) : '||X_REGULAR_QTY_TO_INVOICE , 5 ) ;
2140: END IF;
2141: RETURN;

Line 2401: OE_MSG_PUB.ADD;

2397: -- Check For all Required Attributes
2398: IF p_interface_line_rec.Batch_Source_Name IS NULL THEN
2399: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');
2400: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Batch_Source_Name');
2401: OE_MSG_PUB.ADD;
2402: IF l_debug_level > 0 THEN
2403: oe_debug_pub.add( 'REQUIRED ATTRIBUTE BATCH SOURCE NAME IS MISSING' , 1 ) ;
2404: END IF;
2405: RETURN FALSE;

Line 2409: OE_MSG_PUB.ADD;

2405: RETURN FALSE;
2406: ELSIF p_interface_line_rec.Set_Of_Books_Id IS NULL THEN
2407: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');
2408: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Set_Of_Books_Id');
2409: OE_MSG_PUB.ADD;
2410: IF l_debug_level > 0 THEN
2411: oe_debug_pub.add( 'REQUIRED ATTRIBUTE SET OF BOOKS ID IS MISSING ' , 1 ) ;
2412: END IF;
2413: RETURN FALSE;

Line 2417: OE_MSG_PUB.ADD;

2413: RETURN FALSE;
2414: ELSIF p_interface_line_rec.Line_Type IS NULL THEN
2415: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');
2416: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Line_Type');
2417: OE_MSG_PUB.ADD;
2418: IF l_debug_level > 0 THEN
2419: oe_debug_pub.add( 'REQUIRED ATTRIBUTE LINE TYPE IS MISSING' , 1 ) ;
2420: END IF;
2421: RETURN FALSE;

Line 2425: OE_MSG_PUB.ADD;

2421: RETURN FALSE;
2422: ELSIF p_interface_line_rec.Description IS NULL THEN
2423: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');
2424: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Description');
2425: OE_MSG_PUB.ADD;
2426: IF l_debug_level > 0 THEN
2427: oe_debug_pub.add( 'REQUIRED ATTRIBUTE DESCRIPTION IS MISSING' , 1 ) ;
2428: END IF;
2429: RETURN FALSE;

Line 2433: OE_MSG_PUB.ADD;

2429: RETURN FALSE;
2430: ELSIF p_interface_line_rec.Currency_Code IS NULL THEN
2431: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');
2432: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Currency_Code');
2433: OE_MSG_PUB.ADD;
2434: IF l_debug_level > 0 THEN
2435: oe_debug_pub.add( 'REQUIRED ATTRIBUTE CURRENCY CODE IS MISSING' , 1 ) ;
2436: END IF;
2437: RETURN FALSE;

Line 2441: OE_MSG_PUB.ADD;

2437: RETURN FALSE;
2438: ELSIF p_interface_line_rec.Conversion_Type IS NULL THEN
2439: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');
2440: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Conversion_Type');
2441: OE_MSG_PUB.ADD;
2442: IF l_debug_level > 0 THEN
2443: oe_debug_pub.add( 'REQUIRED ATTRIBUTE CONVERSION TYPE IS MISSING' , 1 ) ;
2444: END IF;
2445: RETURN FALSE;

Line 2451: OE_MSG_PUB.ADD;

2447: (p_interface_line_rec.Cust_Trx_Type_Id IS NULL OR
2448: p_interface_line_rec.Cust_Trx_Type_Id = 0) THEN
2449: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_ATTR_REQUIRED');
2450: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Cust_Trx_Type_Id');
2451: OE_MSG_PUB.ADD;
2452: IF l_debug_level > 0 THEN
2453: oe_debug_pub.add( 'REQUIRED ATTRIBUTE CUSTOMER TRX TYPE ID IS MISSING' , 1 ) ;
2454: END IF;
2455: RETURN FALSE;

Line 2464: OE_MSG_PUB.ADD;

2460: END IF;
2461: RETURN FALSE;
2462: ELSIF p_interface_line_rec.customer_bank_account_id = -1 THEN
2463: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');
2464: OE_MSG_PUB.ADD;
2465: IF l_debug_level > 0 THEN
2466: oe_debug_pub.add( 'REQUIRED ATTRIBUTE CUSTOMER CREDIT CARD BANK ACCOUNT IS MISSING' , 1 ) ;
2467: END IF;
2468: RETURN FALSE;

Line 2472: OE_MSG_PUB.ADD;

2468: RETURN FALSE;
2469: ELSIF p_interface_line_rec.customer_bank_account_id > 0
2470: AND p_interface_line_rec.receipt_method_id IS NULL THEN
2471: FND_MESSAGE.SET_NAME('ONT','OE_VPM_NO_PAY_METHOD');
2472: OE_MSG_PUB.ADD;
2473: IF l_debug_level > 0 THEN
2474: oe_debug_pub.add( 'REQUIRED ATTRIBUTE PAYMENT METHOD IS MISSING' , 1 ) ;
2475: END IF;
2476: RETURN FALSE;

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

2626: WHEN OTHERS THEN
2627: IF l_debug_level > 0 THEN
2628: oe_debug_pub.add( 'EXCEPTION , QUERY LINE SALES CREDITS '||SQLERRM , 1 ) ;
2629: END IF;
2630: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2631: THEN
2632: oe_msg_pub.Add_Exc_Msg
2633: ( G_PKG_NAME
2634: , 'Query_Line_Scredits'

Line 2632: oe_msg_pub.Add_Exc_Msg

2628: oe_debug_pub.add( 'EXCEPTION , QUERY LINE SALES CREDITS '||SQLERRM , 1 ) ;
2629: END IF;
2630: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2631: THEN
2632: oe_msg_pub.Add_Exc_Msg
2633: ( G_PKG_NAME
2634: , 'Query_Line_Scredits'
2635: );
2636: END IF;

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

2744: WHEN OTHERS THEN
2745: IF l_debug_level > 0 THEN
2746: oe_debug_pub.add( 'EXCEPTION , QUERY HEADER SALES CREDITS ( ) ' , 5 ) ;
2747: END IF;
2748: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2749: THEN
2750: oe_msg_pub.Add_Exc_Msg
2751: ( G_PKG_NAME
2752: , 'Query_Header_Scredits'

Line 2750: oe_msg_pub.Add_Exc_Msg

2746: oe_debug_pub.add( 'EXCEPTION , QUERY HEADER SALES CREDITS ( ) ' , 5 ) ;
2747: END IF;
2748: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2749: THEN
2750: oe_msg_pub.Add_Exc_Msg
2751: ( G_PKG_NAME
2752: , 'Query_Header_Scredits'
2753: );
2754: END IF;

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

3382: err_msg := 'Error while inserting to RA_INTERFACE_LINES_ALL :\n '|| SQLERRM;
3383: IF l_debug_level > 0 THEN
3384: oe_debug_pub.add( ERR_MSG || ' SQLCODE: '||TO_CHAR ( SQLCODE ) , 1 ) ;
3385: END IF;
3386: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3387: OE_MSG_PUB.Add_Exc_Msg
3388: ( G_PKG_NAME
3389: , 'Insert_Line'
3390: );

Line 3387: OE_MSG_PUB.Add_Exc_Msg

3383: IF l_debug_level > 0 THEN
3384: oe_debug_pub.add( ERR_MSG || ' SQLCODE: '||TO_CHAR ( SQLCODE ) , 1 ) ;
3385: END IF;
3386: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3387: OE_MSG_PUB.Add_Exc_Msg
3388: ( G_PKG_NAME
3389: , 'Insert_Line'
3390: );
3391: END IF;

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

3823: EXCEPTION WHEN OTHERS THEN
3824: IF l_debug_level > 0 THEN
3825: oe_debug_pub.add( 'UNABLE TO INSERT SALES CREDIT RECORDS -> '||SQLERRM , 1 ) ;
3826: END IF;
3827: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3828: OE_MSG_PUB.Add_Exc_Msg
3829: ( G_PKG_NAME
3830: , 'Insert_Salescredit'
3831: );

Line 3828: OE_MSG_PUB.Add_Exc_Msg

3824: IF l_debug_level > 0 THEN
3825: oe_debug_pub.add( 'UNABLE TO INSERT SALES CREDIT RECORDS -> '||SQLERRM , 1 ) ;
3826: END IF;
3827: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3828: OE_MSG_PUB.Add_Exc_Msg
3829: ( G_PKG_NAME
3830: , 'Insert_Salescredit'
3831: );
3832: END IF;

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

4051: IF l_debug_level > 0 THEN
4052: oe_debug_pub.add( 'EXCEPTION INTERFACE_SALES_CREDITS ( ) '||SQLERRM , 1 ) ;
4053: END IF;
4054: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4055: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4056: THEN
4057: OE_MSG_PUB.Add_Exc_Msg
4058: ( G_PKG_NAME
4059: , 'Interface_SalesCredits');

Line 4057: OE_MSG_PUB.Add_Exc_Msg

4053: END IF;
4054: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4055: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4056: THEN
4057: OE_MSG_PUB.Add_Exc_Msg
4058: ( G_PKG_NAME
4059: , 'Interface_SalesCredits');
4060: END IF;
4061: END Interface_SalesCredits;

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

4116: WHEN OTHERS THEN
4117: IF l_debug_level > 0 THEN
4118: oe_debug_pub.add( 'EXCEPTION , INTERFACE SALES CREDITS FOR FREIGHT '||SQLERRM , 1 ) ;
4119: END IF;
4120: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4121: THEN
4122: OE_MSG_PUB.Add_Exc_Msg
4123: ( G_PKG_NAME
4124: , 'Interface_scredits_for_freight'

Line 4122: OE_MSG_PUB.Add_Exc_Msg

4118: oe_debug_pub.add( 'EXCEPTION , INTERFACE SALES CREDITS FOR FREIGHT '||SQLERRM , 1 ) ;
4119: END IF;
4120: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4121: THEN
4122: OE_MSG_PUB.Add_Exc_Msg
4123: ( G_PKG_NAME
4124: , 'Interface_scredits_for_freight'
4125: );
4126: END IF;

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

4302: EXCEPTION WHEN OTHERS THEN
4303: IF l_debug_level > 0 THEN
4304: oe_debug_pub.add( 'UNABLE TO INSERT CONTINGENCY RECORDS -> '||SQLERRM , 1 ) ;
4305: END IF;
4306: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4307: OE_MSG_PUB.Add_Exc_Msg
4308: ( G_PKG_NAME
4309: , 'Insert_Contingency'
4310: );

Line 4307: OE_MSG_PUB.Add_Exc_Msg

4303: IF l_debug_level > 0 THEN
4304: oe_debug_pub.add( 'UNABLE TO INSERT CONTINGENCY RECORDS -> '||SQLERRM , 1 ) ;
4305: END IF;
4306: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4307: OE_MSG_PUB.Add_Exc_Msg
4308: ( G_PKG_NAME
4309: , 'Insert_Contingency'
4310: );
4311: END IF;

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

4363: IF l_debug_level > 0 THEN
4364: oe_debug_pub.add( 'EXCEPTION INTERFACE_CONTINGENCIES ( ) '||SQLERRM , 1 ) ;
4365: END IF;
4366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4367: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4368: THEN
4369: OE_MSG_PUB.Add_Exc_Msg
4370: ( G_PKG_NAME
4371: , 'Interface_Contingencies');

Line 4369: OE_MSG_PUB.Add_Exc_Msg

4365: END IF;
4366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4367: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4368: THEN
4369: OE_MSG_PUB.Add_Exc_Msg
4370: ( G_PKG_NAME
4371: , 'Interface_Contingencies');
4372: END IF;
4373: END Interface_Contingencies;

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

4453: WHEN OTHERS THEN
4454: IF l_debug_level > 0 THEN
4455: oe_debug_pub.add( 'EXCEPTION , ROUNDING DIFFERENCE '||SQLERRM , 1 ) ;
4456: END IF;
4457: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4458: THEN
4459: OE_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,'Get_Rounding_Diff');
4460: END IF;
4461: END Get_Rounding_Diff;

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

4455: oe_debug_pub.add( 'EXCEPTION , ROUNDING DIFFERENCE '||SQLERRM , 1 ) ;
4456: END IF;
4457: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4458: THEN
4459: OE_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,'Get_Rounding_Diff');
4460: END IF;
4461: END Get_Rounding_Diff;
4462:
4463: PROCEDURE Interface_Detail_Discounts

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

4704: oe_debug_pub.add( 'EXCEPTION IN INTERFACE_DETAIL_DISCOUNTS '||SQLERRM , 1 ) ;
4705: END IF;
4706: -- Fix for the bug 2187074
4707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4708: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4709: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Interface_Detail_Discounts');
4710: END IF;
4711:
4712: END Interface_Detail_Discounts;

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

4705: END IF;
4706: -- Fix for the bug 2187074
4707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4708: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4709: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Interface_Detail_Discounts');
4710: END IF;
4711:
4712: END Interface_Detail_Discounts;
4713:

Line 4861: OE_MSG_PUB.Add_Exc_Msg

4857: WHEN OTHERS THEN
4858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4859: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4860: THEN
4861: OE_MSG_PUB.Add_Exc_Msg
4862: ( G_PKG_NAME
4863: , 'Update_Invoiced_flag'
4864: );
4865: END IF;

Line 4968: OE_MSG_PUB.ADD;

4964: EXCEPTION
4965: WHEN NO_DATA_FOUND THEN
4966: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
4967: FND_MESSAGE.SET_NAME('ONT','ONT_FREIGHT_ITEM_REQUIRED');
4968: OE_MSG_PUB.ADD;
4969: END IF;
4970:
4971: RAISE FND_API.G_EXC_ERROR;
4972: END;

Line 5610: OE_MSG_PUB.Add_Exc_Msg

5606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5607: IF FND_MSG_PUB.Check_Msg_Level
5608: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5609: THEN
5610: OE_MSG_PUB.Add_Exc_Msg
5611: ( G_PKG_NAME
5612: , 'Interface_Freight_Charges'
5613: );
5614: END IF;

Line 6635: OE_MSG_PUB.ADD;

6631: IF p_x_interface_line_rec.accounting_rule_duration IS NULL THEN
6632: IF p_line_rec.service_start_date IS NULL OR p_line_rec.service_end_date IS NULL THEN
6633: -- bug# 4190312 post message and complete with status INCOMPLETE
6634: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ACCT_RULE_DURATION');
6635: OE_MSG_PUB.ADD;
6636: IF l_debug_level > 0 THEN
6637: oe_debug_pub.add( 'SERVICE START DATE OR SERVICE END DATE IS NULL' , 3 ) ;
6638: END IF;
6639: p_x_interface_line_rec.ACCOUNTING_RULE_DURATION := -1;

Line 6677: FND_MESSAGE.SET_TOKEN('CALENDAR_NAME', l_calendar_name); OE_MSG_PUB.ADD;

6673: -- post message
6674: FND_MESSAGE.SET_NAME('ONT','ONT_GL_UNMAPPED_DATES');
6675: FND_MESSAGE.SET_TOKEN('START_DATE', p_line_rec.service_start_date);
6676: FND_MESSAGE.SET_TOKEN('END_DATE', p_line_rec.service_end_date);
6677: FND_MESSAGE.SET_TOKEN('CALENDAR_NAME', l_calendar_name); OE_MSG_PUB.ADD;
6678: IF l_debug_level > 0 THEN
6679: oe_debug_pub.add('Atleast one or more dates ('||l_unmapped_date||') within the date range that are not associated with any adjustment period.');
6680: END IF;
6681: END IF;

Line 6690: OE_MSG_PUB.ADD;

6686: FND_MESSAGE.SET_NAME('ONT','ONT_GL_UNMAPPED_DATES');
6687: FND_MESSAGE.SET_TOKEN('START_DATE', p_line_rec.service_start_date);
6688: FND_MESSAGE.SET_TOKEN('END_DATE', p_line_rec.service_end_date);
6689: FND_MESSAGE.SET_TOKEN('CALENDAR_NAME', l_calendar_name);
6690: OE_MSG_PUB.ADD;
6691: IF l_debug_level > 0 THEN
6692: oe_debug_pub.add( 'ERROR IN GL_CALENDAR_PKG.Get_Num_Periods_In_Date_Range ; ERROR => '||SQLERRM , 1 ) ;
6693: END IF;
6694: END;

Line 6897: OE_MSG_PUB.ADD;

6893: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
6894: l_parent_line_id := l_order_line_id;
6895: ELSE
6896: FND_MESSAGE.SET_NAME('ONT','ONT_NO_CUST_PROD_LINE');
6897: OE_MSG_PUB.ADD;
6898: END IF;
6899: ELSE -- not a customer product
6900: l_parent_line_id := p_line_rec.service_reference_line_id;
6901: END IF;

Line 7673: OE_MSG_PUB.Add_Exc_Msg

7669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7670: IF FND_MSG_PUB.Check_Msg_Level
7671: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7672: THEN
7673: OE_MSG_PUB.Add_Exc_Msg
7674: ( G_PKG_NAME
7675: , 'Update_Invoice_Attributes'
7676: );
7677: END IF;

Line 8216: OE_MSG_PUB.ADD;

8212: END IF;
8213: --Customer Acceptance
8214: IF l_line_rejected AND p_line_rec.line_category_code = 'RETURN' THEN
8215: FND_MESSAGE.SET_NAME('ONT','ONT_RMA_NO_CREDIT');
8216: OE_MSG_PUB.ADD;
8217: END IF;
8218: --Customer Acceptance
8219: RETURN;
8220: END IF;

Line 8246: OE_MSG_PUB.ADD;

8242: ,'RFR-PENDING'
8243: ,x_return_status);
8244: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
8245: FND_MESSAGE.SET_NAME('ONT','OE_INVOICE_WAIT_FOR_RFR');
8246: OE_MSG_PUB.ADD;
8247: END IF;
8248: END IF;
8249: IF l_debug_level > 0 THEN
8250: oe_debug_pub.add( 'REQUEST_ID AFTER INSERTING '||P_X_INTERFACE_LINE_REC.REQUEST_ID , 5 ) ;

Line 8359: OE_MSG_PUB.ADD;

8355: ,'RFR-PENDING'
8356: ,x_return_status);
8357: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
8358: FND_MESSAGE.SET_NAME('ONT','OE_INVOICE_WAIT_FOR_RFR');
8359: OE_MSG_PUB.ADD;
8360: END IF;
8361: ELSE
8362: Update_Invoice_Attributes(p_line_rec
8363: ,p_x_interface_line_rec

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

8409: IF l_debug_level > 0 THEN
8410: oe_debug_pub.add( 'OTHER EXCEPTION. EXITING INTERFACE_SINGLE_LINE : '||SQLERRM , 1 ) ;
8411: oe_debug_pub.add( 'RETURN STATUS :'||X_RETURN_STATUS||' OUT RESULT : '||X_RESULT_OUT , 5 ) ;
8412: END IF;
8413: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8414: OE_MSG_PUB.Add_Exc_Msg
8415: ( G_PKG_NAME
8416: , 'Interface_Single_line'
8417: );

Line 8414: OE_MSG_PUB.Add_Exc_Msg

8410: oe_debug_pub.add( 'OTHER EXCEPTION. EXITING INTERFACE_SINGLE_LINE : '||SQLERRM , 1 ) ;
8411: oe_debug_pub.add( 'RETURN STATUS :'||X_RETURN_STATUS||' OUT RESULT : '||X_RESULT_OUT , 5 ) ;
8412: END IF;
8413: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8414: OE_MSG_PUB.Add_Exc_Msg
8415: ( G_PKG_NAME
8416: , 'Interface_Single_line'
8417: );
8418: END IF;

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

8515: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN
8516: SAVEPOINT INVOICE_INTERFACE;
8517: END IF;
8518:
8519: --bug 5336623 Commented the following call to OE_MSG_PUB.set_msg_context
8520: --Exception management begin
8521: /* OE_MSG_PUB.set_msg_context(
8522: p_entity_code => 'LINE'
8523: ,p_entity_id => p_line_id

Line 8521: /* OE_MSG_PUB.set_msg_context(

8517: END IF;
8518:
8519: --bug 5336623 Commented the following call to OE_MSG_PUB.set_msg_context
8520: --Exception management begin
8521: /* OE_MSG_PUB.set_msg_context(
8522: p_entity_code => 'LINE'
8523: ,p_entity_id => p_line_id
8524: ,p_line_id => p_line_id ); */
8525: --Exception management end

Line 8555: OE_MSG_PUB.set_msg_context(

8551: IF p_itemtype = OE_GLOBALS.G_WFI_HDR THEN
8552: p_header_id := l_line_rec.header_id;
8553: END IF;
8554: -- Set message context
8555: OE_MSG_PUB.set_msg_context(
8556: p_entity_code => 'LINE'
8557: ,p_entity_id => l_line_rec.line_id
8558: ,p_header_id => l_line_rec.header_id
8559: ,p_line_id => l_line_rec.line_id

Line 8591: OE_MSG_PUB.Add;

8587: x_return_status := FND_API.G_RET_STS_ERROR;
8588: l_line_rec.return_status := FND_API.G_RET_STS_ERROR;
8589: l_line_rec.line_id := null;
8590: FND_MESSAGE.Set_Name('ONT', 'OE_LINE_LOCKED');
8591: OE_MSG_PUB.Add;
8592: RAISE FND_API.G_EXC_ERROR;
8593: */
8594:
8595: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN

Line 8608: OE_MSG_PUB.Add;

8604: END IF;
8605: x_result_out := NULL;
8606: x_return_status := 'DEFERRED';
8607: FND_MESSAGE.Set_Name('ONT', 'OE_LINE_LOCKED');
8608: OE_MSG_PUB.Add;
8609: RETURN;
8610: --- bug# 7600960 : end
8611:
8612:

Line 8890: OE_MSG_PUB.ADD;

8886: END IF;
8887: --Customer Acceptance
8888: IF l_line_rejected AND l_line_rec.line_category_code = 'RETURN' THEN
8889: FND_MESSAGE.SET_NAME('ONT','ONT_RMA_NO_CREDIT');
8890: OE_MSG_PUB.ADD;
8891: END IF;
8892: --Customer Acceptance
8893: RETURN;
8894: END IF;

Line 9077: OE_MSG_PUB.ADD;

9073: WHERE dl.delivery_id = l_delivery_line_id;
9074: END IF;
9075: FND_MESSAGE.SET_NAME('ONT','OE_INVOICE_WAIT_FOR_DELIVERY');
9076: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',l_delivery_name);
9077: OE_MSG_PUB.ADD;
9078: END IF;
9079: IF l_debug_level > 0 THEN
9080: oe_debug_pub.add( 'INTERFACE STATUS : '||L_LINE_REC.INVOICE_INTERFACE_STATUS_CODE , 5 ) ;
9081: oe_debug_pub.add( 'X_RETURN_STATUS : '||X_RETURN_STATUS , 5 ) ;

Line 9246: OE_MSG_PUB.ADD;

9242: ,'RFR-PENDING'
9243: ,x_return_status);
9244: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
9245: FND_MESSAGE.SET_NAME('ONT','OE_INVOICE_WAIT_FOR_RFR');
9246: OE_MSG_PUB.ADD;
9247: END IF;
9248: IF l_debug_level > 0 THEN
9249: oe_debug_pub.add( 'RFR: L_LINE_REC.INTERFACE_STATUS '||L_LINE_REC.INVOICE_INTERFACE_STATUS_CODE , 5 ) ;
9250: oe_debug_pub.add( 'RFR: X_RETURN_STATUS :'||X_RETURN_STATUS , 5 ) ;

Line 9520: OE_MSG_PUB.Count_And_Get

9516: END IF;
9517: Update_line_flow_status(l_line_rec.line_id,l_flow_status_code);
9518: END IF;
9519:
9520: OE_MSG_PUB.Count_And_Get
9521: ( p_count => x_msg_count
9522: , p_data => x_msg_data
9523: );
9524: x_return_status := FND_API.G_RET_STS_ERROR;

Line 9532: OE_MSG_PUB.Count_And_Get

9528: END IF;
9529: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN
9530: ROLLBACK TO INVOICE_INTERFACE;
9531: END IF;
9532: OE_MSG_PUB.Count_And_Get
9533: ( p_count => x_msg_count
9534: , p_data => x_msg_data
9535: );
9536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 9553: OE_MSG_PUB.Add_Exc_Msg

9549: END IF;
9550: IF FND_MSG_PUB.Check_Msg_Level
9551: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9552: THEN
9553: OE_MSG_PUB.Add_Exc_Msg
9554: ( G_PKG_NAME
9555: , 'Interface_Line'
9556: );
9557: END IF;

Line 9558: OE_MSG_PUB.Count_And_Get

9554: ( G_PKG_NAME
9555: , 'Interface_Line'
9556: );
9557: END IF;
9558: OE_MSG_PUB.Count_And_Get
9559: ( p_count => x_msg_count
9560: , p_data => x_msg_data
9561: );
9562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 9666: OE_MSG_PUB.Count_And_Get

9662: END IF;
9663: Update_header_flow_status(p_header_id,l_flow_status_code);
9664: END IF;
9665:
9666: OE_MSG_PUB.Count_And_Get
9667: ( p_count => x_msg_count
9668: , p_data => x_msg_data
9669: );
9670: x_return_status := FND_API.G_RET_STS_ERROR;

Line 9679: OE_MSG_PUB.Count_And_Get

9675: IF (order_line_cursor%ISOPEN) THEN
9676: CLOSE order_line_cursor;
9677: END IF;
9678: ROLLBACK TO HEADER_INVOICE_INTERFACE;
9679: OE_MSG_PUB.Count_And_Get
9680: ( p_count => x_msg_count
9681: , p_data => x_msg_data
9682: );
9683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 9693: IF OE_MSG_PUB.Check_Msg_Level

9689: IF (order_line_cursor%ISOPEN) THEN
9690: CLOSE order_line_cursor;
9691: END IF;
9692: ROLLBACK TO HEADER_INVOICE_INTERFACE;
9693: IF OE_MSG_PUB.Check_Msg_Level
9694: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9695: THEN
9696: OE_MSG_PUB.Add_Exc_Msg
9697: ( G_PKG_NAME

Line 9694: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

9690: CLOSE order_line_cursor;
9691: END IF;
9692: ROLLBACK TO HEADER_INVOICE_INTERFACE;
9693: IF OE_MSG_PUB.Check_Msg_Level
9694: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9695: THEN
9696: OE_MSG_PUB.Add_Exc_Msg
9697: ( G_PKG_NAME
9698: , 'Interface_Header'

Line 9696: OE_MSG_PUB.Add_Exc_Msg

9692: ROLLBACK TO HEADER_INVOICE_INTERFACE;
9693: IF OE_MSG_PUB.Check_Msg_Level
9694: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9695: THEN
9696: OE_MSG_PUB.Add_Exc_Msg
9697: ( G_PKG_NAME
9698: , 'Interface_Header'
9699: );
9700: END IF;

Line 9701: OE_MSG_PUB.Count_And_Get

9697: ( G_PKG_NAME
9698: , 'Interface_Header'
9699: );
9700: END IF;
9701: OE_MSG_PUB.Count_And_Get
9702: ( p_count => x_msg_count
9703: , p_data => x_msg_data
9704: );
9705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

9732:
9733: IF l_header_id IS NULL OR
9734: l_header_id = FND_API.G_MISS_NUM
9735: THEN
9736: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
9737: p_result := 0;
9738: END IF;
9739:
9740: -- 3740077 Added the If

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

9816:
9817: IF l_header_id IS NULL OR
9818: l_header_id = FND_API.G_MISS_NUM
9819: THEN
9820: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
9821: p_result := 0;
9822: END IF;
9823:
9824: IF l_header_id is not null and

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

9892:
9893: IF l_line_id IS NULL OR
9894: l_line_id = FND_API.G_MISS_NUM
9895: THEN
9896: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
9897: p_result := 0;
9898: END IF;
9899:
9900: BEGIN