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_AGREEMENT_UTIL dependencies on OE_AGREEMENT_UTIL

Line 1: PACKAGE BODY OE_Agreement_Util AS

1: PACKAGE BODY OE_Agreement_Util AS
2: /* $Header: OEXUAGRB.pls 120.2 2005/12/14 16:17:38 shulin noship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Agreement_Util';

2: /* $Header: OEXUAGRB.pls 120.2 2005/12/14 16:17:38 shulin noship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Agreement_Util';
7:
8: -- Procedure Clear_Dependent_Attr
9:
10: PROCEDURE Clear_Dependent_Attr

Line 20: oe_debug_pub.add('Entering OE_Agreement_Util.Clear_Dependent_Attr');

16: )
17: IS
18: BEGIN
19:
20: oe_debug_pub.add('Entering OE_Agreement_Util.Clear_Dependent_Attr');
21:
22: -- Load out record
23:
24: x_Agreement_rec := p_Agreement_rec;

Line 374: oe_debug_pub.add('Exiting OE_Agreement_Util.Clear_Dependent_Attr');

370: ELSIF p_attr_id = G_INVOICE_TO_CUSTOMER_ID THEN -- Added for bug#4029589
371: NULL;
372: END IF;
373:
374: oe_debug_pub.add('Exiting OE_Agreement_Util.Clear_Dependent_Attr');
375:
376: END Clear_Dependent_Attr;
377:
378: -- Procedure Apply_Attribute_Changes

Line 389: oe_debug_pub.add('Entering OE_Agreement_Util.Apply_Attribute_Changes');

385: )
386: IS
387: BEGIN
388:
389: oe_debug_pub.add('Entering OE_Agreement_Util.Apply_Attribute_Changes');
390:
391: -- Load out record
392:
393: x_Agreement_rec := p_Agreement_rec;

Line 643: oe_debug_pub.add('Exiting OE_Agreement_Util.Apply_Attribute_Changes');

639: IF NOT OE_GLOBALS.Equal(p_Agreement_rec.invoice_to_customer_id,p_old_Agreement_rec.invoice_to_customer_id)
640: THEN
641: NULL;
642: END IF;
643: oe_debug_pub.add('Exiting OE_Agreement_Util.Apply_Attribute_Changes');
644:
645: END Apply_Attribute_Changes;
646:
647: -- Function Complete_Record

Line 657: oe_debug_pub.add('Entering OE_Agreement_Util.Complete_Record');

653: IS
654: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type := p_Agreement_rec;
655: BEGIN
656:
657: oe_debug_pub.add('Entering OE_Agreement_Util.Complete_Record');
658:
659: IF l_Agreement_rec.accounting_rule_id = FND_API.G_MISS_NUM THEN
660: l_Agreement_rec.accounting_rule_id := p_old_Agreement_rec.accounting_rule_id;
661: END IF;

Line 854: oe_debug_pub.add('Exiting OE_Agreement_Util.Complete_Record');

850: IF l_Agreement_rec.invoice_to_customer_id = FND_API.G_MISS_NUM THEN
851: l_Agreement_rec.invoice_to_customer_id := p_old_Agreement_rec.invoice_to_customer_id;
852: END IF;
853:
854: oe_debug_pub.add('Exiting OE_Agreement_Util.Complete_Record');
855:
856: RETURN l_Agreement_rec;
857:
858: END Complete_Record;

Line 869: oe_debug_pub.add('Entering OE_Agreement_Util.Convert_Miss_To_Null');

865: IS
866: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type := p_Agreement_rec;
867: BEGIN
868:
869: oe_debug_pub.add('Entering OE_Agreement_Util.Convert_Miss_To_Null');
870:
871: IF l_Agreement_rec.accounting_rule_id = FND_API.G_MISS_NUM THEN
872: l_Agreement_rec.accounting_rule_id := NULL;
873: END IF;

Line 1068: oe_debug_pub.add('Exiting OE_Agreement_Util.Convert_Miss_To_Null');

1064: END IF;
1065:
1066: RETURN l_Agreement_rec;
1067:
1068: oe_debug_pub.add('Exiting OE_Agreement_Util.Convert_Miss_To_Null');
1069:
1070: END Convert_Miss_To_Null;
1071:
1072: -- Procedure Update_Row

Line 1080: oe_debug_pub.add('Entering OE_Agreement_Util.Update_Row');

1076: )
1077: IS
1078: BEGIN
1079:
1080: oe_debug_pub.add('Entering OE_Agreement_Util.Update_Row');
1081:
1082: IF QP_security.check_function( p_function_name => QP_Security.G_FUNCTION_UPDATE,
1083: p_instance_type => QP_Security.G_AGREEMENT_OBJECT,
1084: p_instance_pk1 => p_Agreement_rec.price_list_id) <> 'F' THEN

Line 1211: oe_debug_pub.add('Exiting OE_Agreement_Util.Update_Row');

1207: , TERM_ID = p_Agreement_rec.term_id
1208: WHERE AGREEMENT_ID = p_Agreement_rec.agreement_id
1209: ;
1210: */
1211: oe_debug_pub.add('Exiting OE_Agreement_Util.Update_Row');
1212:
1213: EXCEPTION
1214:
1215: WHEN OTHERS THEN

Line 1239: oe_debug_pub.add('Entering OE_Agreement_Util.Insert_Row');

1235: x_row_id VARCHAR2(240);
1236: x_result VARCHAR2(1);
1237: BEGIN
1238:
1239: oe_debug_pub.add('Entering OE_Agreement_Util.Insert_Row');
1240: --
1241:
1242: OE_AGREEMENTS_PKG.INSERT_ROW ( x_row_id
1243: , p_Agreement_rec.agreement_id

Line 1409: oe_debug_pub.add('Entering OE_Agreement_Util.Insert_Row');

1405: , p_Agreement_rec.term_id
1406: );
1407: */
1408:
1409: oe_debug_pub.add('Entering OE_Agreement_Util.Insert_Row');
1410:
1411: EXCEPTION
1412:
1413: WHEN OTHERS THEN

Line 1448: oe_debug_pub.add('Entering OE_Agreement_Util.Delete_Row');

1444:
1445:
1446: BEGIN
1447:
1448: oe_debug_pub.add('Entering OE_Agreement_Util.Delete_Row');
1449: /* IF (p_Price_List_Exists_Flag) THEN
1450: oe_debug_pub.add('p_Price_List_Exists_Flag :');
1451:
1452: --oe_debug_pub.add('p_Price_List_Exists_Flag :'||to_char(p_Price_List_Exists_Flag));

Line 1490: oe_debug_pub.add(' OE_Agreement_Util: Deleting price list for the Agreement');

1486: if l_Price_List_id is NOT NULL THEN
1487:
1488: Deletes the Price List Header
1489:
1490: oe_debug_pub.add(' OE_Agreement_Util: Deleting price list for the Agreement');
1491: QP_Price_List_Util.Delete_Row( l_Price_List_id );
1492: */
1493:
1494: /* Delete from qp_qualifiers table */

Line 1543: oe_debug_pub.add('Exiting OE_Agreement_Util.Delete_Row');

1539:
1540: end if;
1541:
1542:
1543: oe_debug_pub.add('Exiting OE_Agreement_Util.Delete_Row');
1544:
1545: EXCEPTION
1546: WHEN FND_API.G_EXC_ERROR THEN
1547: RAISE FND_API.G_EXC_ERROR;

Line 1572: oe_debug_pub.add('Entering OE_Agreement_Util.Query_Row');

1568: ) RETURN OE_Pricing_Cont_PUB.Agreement_Rec_Type
1569: IS
1570: BEGIN
1571:
1572: oe_debug_pub.add('Entering OE_Agreement_Util.Query_Row');
1573:
1574: RETURN Query_Rows
1575: ( p_agreement_id => p_agreement_id
1576: )(1);

Line 1578: oe_debug_pub.add('Exiting OE_Agreement_Util.Query_Row');

1574: RETURN Query_Rows
1575: ( p_agreement_id => p_agreement_id
1576: )(1);
1577:
1578: oe_debug_pub.add('Exiting OE_Agreement_Util.Query_Row');
1579:
1580: END Query_Row;
1581:
1582: -- Function Query_Rows

Line 1786: oe_debug_pub.add('Entering OE_Agreement_Util.Lock_Row');

1782: IS
1783: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1784: BEGIN
1785:
1786: oe_debug_pub.add('Entering OE_Agreement_Util.Lock_Row');
1787:
1788: OE_AGREEMENTS_PKG.UPDATE_ROW (
1789: p_Agreement_rec.agreement_id
1790: , p_Agreement_rec.tp_attribute2

Line 2223: oe_debug_pub.add('Entering OE_Agreement_Util.Lock_Row');

2219: END IF;
2220:
2221: END IF;
2222:
2223: oe_debug_pub.add('Entering OE_Agreement_Util.Lock_Row');
2224:
2225: EXCEPTION
2226:
2227: WHEN NO_DATA_FOUND THEN

Line 2277: oe_debug_pub.add('Entering OE_Agreement_Util.Get_Values');

2273: IS
2274: l_Agreement_val_rec OE_Pricing_Cont_PUB.Agreement_Val_Rec_Type;
2275: BEGIN
2276:
2277: oe_debug_pub.add('Entering OE_Agreement_Util.Get_Values');
2278:
2279: IF p_Agreement_rec.accounting_rule_id IS NOT NULL AND
2280: p_Agreement_rec.accounting_rule_id <> FND_API.G_MISS_NUM AND
2281: NOT OE_GLOBALS.Equal(p_Agreement_rec.accounting_rule_id,

Line 2456: oe_debug_pub.add('Exiting OE_Agreement_Util.Get_Values');

2452: --End code added by rchellam for OKC
2453:
2454: RETURN l_Agreement_val_rec;
2455:
2456: oe_debug_pub.add('Exiting OE_Agreement_Util.Get_Values');
2457:
2458: END Get_Values;
2459:
2460: -- Function Get_Ids

Line 2470: oe_debug_pub.add('Entering OE_Agreement_Util.Get_Ids');

2466: IS
2467: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
2468: BEGIN
2469:
2470: oe_debug_pub.add('Entering OE_Agreement_Util.Get_Ids');
2471:
2472: -- initialize return_status.
2473:
2474: l_Agreement_rec.return_status := FND_API.G_RET_STS_SUCCESS;

Line 2994: oe_debug_pub.add('Exiting OE_Agreement_Util.Get_Ids');

2990: --End code added by rchellam for OKC
2991:
2992: RETURN l_Agreement_rec;
2993:
2994: oe_debug_pub.add('Exiting OE_Agreement_Util.Get_Ids');
2995:
2996: END Get_Ids;
2997:
2998: END OE_Agreement_Util;

Line 2998: END OE_Agreement_Util;

2994: oe_debug_pub.add('Exiting OE_Agreement_Util.Get_Ids');
2995:
2996: END Get_Ids;
2997:
2998: END OE_Agreement_Util;