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_BLANKET_HEADER_SECURITY dependencies on OE_DEBUG_PUB

Line 25: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

21: l_column_name VARCHAR2(30);
22: l_audit_trail_enabled VARCHAR2(1) := OE_SYS_PARAMETERS.VALUE('AUDIT_TRAIL_ENABLE_FLAG');
23: l_code_level varchar2(6) := OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL;
24: --
25: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
26: --
27: BEGIN
28:
29: l_result := OE_PC_Constraints_Admin_PVT.Is_OP_constrained

Line 55: oe_debug_pub.add( 'CONSTRAINT ON UPDATE OF ALL COLUMNS!' ) ;

51: FROM oe_pc_constraints
52: WHERE constraint_id = l_constraint_id;
53: if l_column_name is null and x_on_operation_action = 0 then
54: IF l_debug_level > 0 THEN
55: oe_debug_pub.add( 'CONSTRAINT ON UPDATE OF ALL COLUMNS!' ) ;
56: END IF;
57: RAISE FND_API.G_EXC_ERROR;
58: end if;
59: END IF;

Line 88: oe_debug_pub.add( 'HEADER SECURITY , ATTRIBUTE CHANGE REQUIRES REASON' , 1 ) ;

84: IF l_result = OE_PC_GLOBALS.YES THEN
85: IF x_on_operation_action = 1 THEN
86: -- set OUT result to NOT CONSTRAINED
87: IF l_debug_level > 0 THEN
88: oe_debug_pub.add( 'HEADER SECURITY , ATTRIBUTE CHANGE REQUIRES REASON' , 1 ) ;
89: END IF;
90: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
91: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
92: ELSIF x_on_operation_action = 2 THEN

Line 96: oe_debug_pub.add( 'HEADER SECURITY , ATTRIBUTE CHANGE REQUIRES HISTORY' , 1 ) ;

92: ELSIF x_on_operation_action = 2 THEN
93: -- set OUT result to NOT CONSTRAINED
94: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
95: IF l_debug_level > 0 THEN
96: oe_debug_pub.add( 'HEADER SECURITY , ATTRIBUTE CHANGE REQUIRES HISTORY' , 1 ) ;
97: END IF;
98: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';
99: END IF;
100: END IF;

Line 108: oe_debug_pub.add( 'HEADER SECURITY , ATTRIBUTE CHANGE REQUIRES REASON' , 1 ) ;

104: IF l_result = OE_PC_GLOBALS.YES THEN
105: IF x_on_operation_action = 1 THEN
106: -- set OUT result to NOT CONSTRAINED
107: IF l_debug_level > 0 THEN
108: oe_debug_pub.add( 'HEADER SECURITY , ATTRIBUTE CHANGE REQUIRES REASON' , 1 ) ;
109: END IF;
110: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
111: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
112: ELSIF x_on_operation_action = 2 THEN

Line 116: oe_debug_pub.add( 'HEADER SECURITY , ATTRIBUTE CHANGE REQUIRES HISTORY' , 1 ) ;

112: ELSIF x_on_operation_action = 2 THEN
113: -- set OUT result to NOT CONSTRAINED
114: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
115: IF l_debug_level > 0 THEN
116: oe_debug_pub.add( 'HEADER SECURITY , ATTRIBUTE CHANGE REQUIRES HISTORY' , 1 ) ;
117: END IF;
118: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';
119: END IF;
120: END IF;

Line 1584: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1580: l_operation VARCHAR2(1);
1581: l_on_operation_action NUMBER;
1582: l_rowtype_rec OE_AK_BLANKET_HEADERS_V%ROWTYPE;
1583: --
1584: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1585: --
1586: BEGIN
1587: IF l_debug_level > 0 THEN
1588: oe_debug_pub.add( 'ENTER OE_BLANKET_HEADER_SECURITY.ENTITY' , 1 ) ;

Line 1588: oe_debug_pub.add( 'ENTER OE_BLANKET_HEADER_SECURITY.ENTITY' , 1 ) ;

1584: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1585: --
1586: BEGIN
1587: IF l_debug_level > 0 THEN
1588: oe_debug_pub.add( 'ENTER OE_BLANKET_HEADER_SECURITY.ENTITY' , 1 ) ;
1589: END IF;
1590:
1591: -- Initializing return status to SUCCESS
1592: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1602: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;

1598: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
1599: l_operation := OE_PC_GLOBALS.DELETE_OP;
1600: ELSE
1601: IF l_debug_level > 0 THEN
1602: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
1603: END IF;
1604: RAISE FND_API.G_EXC_ERROR;
1605: END IF;
1606:

Line 1619: oe_debug_pub.add( 'EXIT OE_BLANKET_HEADER_SECURITY.ENTITY' , 1 ) ;

1615: ,x_on_operation_action => l_on_operation_action
1616: );
1617:
1618: IF l_debug_level > 0 THEN
1619: oe_debug_pub.add( 'EXIT OE_BLANKET_HEADER_SECURITY.ENTITY' , 1 ) ;
1620: END IF;
1621:
1622: EXCEPTION
1623: WHEN OTHERS THEN

Line 1652: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1648: l_active_flag VARCHAR2(1);
1649: e_inacitve_pl EXCEPTION;
1650: l_check_all_cols_constraint VARCHAR2(1);
1651: --
1652: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1653: --
1654: BEGIN
1655: IF l_debug_level > 0 THEN
1656: oe_debug_pub.add( 'ENTER OE_BLANKET_HEADER_SECURITY.ATTRIBUTES' , 1 ) ;

Line 1656: oe_debug_pub.add( 'ENTER OE_BLANKET_HEADER_SECURITY.ATTRIBUTES' , 1 ) ;

1652: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1653: --
1654: BEGIN
1655: IF l_debug_level > 0 THEN
1656: oe_debug_pub.add( 'ENTER OE_BLANKET_HEADER_SECURITY.ATTRIBUTES' , 1 ) ;
1657: oe_debug_pub.add( 'new sold_to_org_id' || p_header_rec.sold_to_org_id ) ;
1658: oe_debug_pub.add( 'old sold_to_org_id' || p_old_header_rec.sold_to_org_id ) ;
1659: oe_debug_pub.add( 'new pl name ' || p_header_rec.new_price_list_name ) ;
1660: oe_debug_pub.add( 'old pl name ' || p_old_header_rec.new_price_list_name ) ;

Line 1657: oe_debug_pub.add( 'new sold_to_org_id' || p_header_rec.sold_to_org_id ) ;

1653: --
1654: BEGIN
1655: IF l_debug_level > 0 THEN
1656: oe_debug_pub.add( 'ENTER OE_BLANKET_HEADER_SECURITY.ATTRIBUTES' , 1 ) ;
1657: oe_debug_pub.add( 'new sold_to_org_id' || p_header_rec.sold_to_org_id ) ;
1658: oe_debug_pub.add( 'old sold_to_org_id' || p_old_header_rec.sold_to_org_id ) ;
1659: oe_debug_pub.add( 'new pl name ' || p_header_rec.new_price_list_name ) ;
1660: oe_debug_pub.add( 'old pl name ' || p_old_header_rec.new_price_list_name ) ;
1661: END IF;

Line 1658: oe_debug_pub.add( 'old sold_to_org_id' || p_old_header_rec.sold_to_org_id ) ;

1654: BEGIN
1655: IF l_debug_level > 0 THEN
1656: oe_debug_pub.add( 'ENTER OE_BLANKET_HEADER_SECURITY.ATTRIBUTES' , 1 ) ;
1657: oe_debug_pub.add( 'new sold_to_org_id' || p_header_rec.sold_to_org_id ) ;
1658: oe_debug_pub.add( 'old sold_to_org_id' || p_old_header_rec.sold_to_org_id ) ;
1659: oe_debug_pub.add( 'new pl name ' || p_header_rec.new_price_list_name ) ;
1660: oe_debug_pub.add( 'old pl name ' || p_old_header_rec.new_price_list_name ) ;
1661: END IF;
1662:

Line 1659: oe_debug_pub.add( 'new pl name ' || p_header_rec.new_price_list_name ) ;

1655: IF l_debug_level > 0 THEN
1656: oe_debug_pub.add( 'ENTER OE_BLANKET_HEADER_SECURITY.ATTRIBUTES' , 1 ) ;
1657: oe_debug_pub.add( 'new sold_to_org_id' || p_header_rec.sold_to_org_id ) ;
1658: oe_debug_pub.add( 'old sold_to_org_id' || p_old_header_rec.sold_to_org_id ) ;
1659: oe_debug_pub.add( 'new pl name ' || p_header_rec.new_price_list_name ) ;
1660: oe_debug_pub.add( 'old pl name ' || p_old_header_rec.new_price_list_name ) ;
1661: END IF;
1662:
1663: -- Initializing return status to SUCCESS

Line 1660: oe_debug_pub.add( 'old pl name ' || p_old_header_rec.new_price_list_name ) ;

1656: oe_debug_pub.add( 'ENTER OE_BLANKET_HEADER_SECURITY.ATTRIBUTES' , 1 ) ;
1657: oe_debug_pub.add( 'new sold_to_org_id' || p_header_rec.sold_to_org_id ) ;
1658: oe_debug_pub.add( 'old sold_to_org_id' || p_old_header_rec.sold_to_org_id ) ;
1659: oe_debug_pub.add( 'new pl name ' || p_header_rec.new_price_list_name ) ;
1660: oe_debug_pub.add( 'old pl name ' || p_old_header_rec.new_price_list_name ) ;
1661: END IF;
1662:
1663: -- Initializing return status to SUCCESS
1664: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1696: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;

1692: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1693: l_operation := OE_PC_GLOBALS.UPDATE_OP;
1694: ELSE
1695: IF l_debug_level > 0 THEN
1696: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
1697: END IF;
1698: RAISE FND_API.G_EXC_ERROR;
1699: END IF;
1700:

Line 1748: oe_debug_pub.add( 'WHEN OTHERS' , 2 ) ;

1744: RAISE e_inacitve_pl ;
1745:
1746: WHEN OTHERS THEN
1747: IF l_debug_level > 0 THEN
1748: oe_debug_pub.add( 'WHEN OTHERS' , 2 ) ;
1749: END IF;
1750: END;
1751: END IF;
1752:

Line 1938: oe_debug_pub.add( 'exiting price list check:' || l_result, 2 ) ;

1934: ,p_record => l_rowtype_rec
1935: ,x_on_operation_action => l_on_operation_action
1936: );
1937: IF l_debug_level > 0 THEN
1938: oe_debug_pub.add( 'exiting price list check:' || l_result, 2 ) ;
1939: END IF;
1940:
1941: IF l_result = OE_PC_GLOBALS.YES THEN
1942: -- set OUT result to CONSTRAINED

Line 2901: oe_debug_pub.add( 'SETTING CHECK ALL COLS CONSTRAINT TO:'||L_CHECK_ALL_COLS_CONSTRAINT ) ;

2897: END IF;
2898:
2899: IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN
2900: IF l_debug_level > 0 THEN
2901: oe_debug_pub.add( 'SETTING CHECK ALL COLS CONSTRAINT TO:'||L_CHECK_ALL_COLS_CONSTRAINT ) ;
2902: END IF;
2903: g_check_all_cols_constraint := l_check_all_cols_constraint;
2904: END IF;
2905:

Line 2911: oe_debug_pub.add( 'EXIT OE_BLANKET_HEADER_SECURITY.ATTRIBUTES' , 1 ) ;

2907: -- NOTE: Please add constraints check for new attributes before the
2908: -- descriptive flexfield attributes check.
2909:
2910: IF l_debug_level > 0 THEN
2911: oe_debug_pub.add( 'EXIT OE_BLANKET_HEADER_SECURITY.ATTRIBUTES' , 1 ) ;
2912: END IF;
2913:
2914: EXCEPTION
2915: WHEN e_inacitve_pl THEN