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

Line 65: oe_debug_pub.add('Constraint on UPDATE of all columns!');

61: INTO l_column_name
62: FROM oe_pc_constraints
63: WHERE constraint_id = l_constraint_id;
64: if l_column_name is null and x_on_operation_action = 0 then
65: oe_debug_pub.add('Constraint on UPDATE of all columns!');
66: RAISE FND_API.G_EXC_ERROR;
67: end if;
68: END IF;
69:

Line 88: OE_DEBUG_PUB.add('Action performed code : '||x_on_operation_action,1);

84: END IF;
85: /* End Versioning */
86:
87: /*
88: OE_DEBUG_PUB.add('Action performed code : '||x_on_operation_action,1);
89:
90: IF l_result = OE_PC_GLOBALS.YES THEN
91: IF x_on_operation_action = 1 THEN
92: IF p_column_name = 'ORDERED_QUANTITY' THEN

Line 93: oe_debug_pub.add('Setting Cancellation Flag to True',1);

89:
90: IF l_result = OE_PC_GLOBALS.YES THEN
91: IF x_on_operation_action = 1 THEN
92: IF p_column_name = 'ORDERED_QUANTITY' THEN
93: oe_debug_pub.add('Setting Cancellation Flag to True',1);
94: oe_sales_can_util.G_REQUIRE_REASON := TRUE;
95: END IF;
96: END IF;
97: END IF;

Line 105: OE_DEBUG_PUB.add('Audit Trail enabled ',5);

101: -- Code level should be OM-H and
102: -- if Audit Trail enabled
103: IF g_is_caller_defaulting='N' THEN
104: IF l_code_level >= '110508' and nvl(l_audit_trail_enabled,'D') <> 'D' THEN
105: OE_DEBUG_PUB.add('Audit Trail enabled ',5);
106: IF l_audit_trail_enabled = 'B' THEN -- capture only for booked orders
107: OE_DEBUG_PUB.add('Audit Trail enabled for booked orders only ...',5);
108:
109: IF p_record.booked_flag = 'Y' THEN

Line 107: OE_DEBUG_PUB.add('Audit Trail enabled for booked orders only ...',5);

103: IF g_is_caller_defaulting='N' THEN
104: IF l_code_level >= '110508' and nvl(l_audit_trail_enabled,'D') <> 'D' THEN
105: OE_DEBUG_PUB.add('Audit Trail enabled ',5);
106: IF l_audit_trail_enabled = 'B' THEN -- capture only for booked orders
107: OE_DEBUG_PUB.add('Audit Trail enabled for booked orders only ...',5);
108:
109: IF p_record.booked_flag = 'Y' THEN
110: IF l_result = OE_PC_GLOBALS.YES THEN
111: l_history_captured := FALSE;

Line 120: OE_DEBUG_PUB.add('While capturing history : '||sqlerrm,1);

116: l_history_captured := TRUE;
117: END IF;
118: END LOOP;
119: EXCEPTION WHEN OTHERS THEN
120: OE_DEBUG_PUB.add('While capturing history : '||sqlerrm,1);
121: NULL;
122: END;
123: IF NOT l_history_captured THEN
124: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;

Line 126: oe_debug_pub.add('Line Security, attribute change requires reason',1);

122: END;
123: IF NOT l_history_captured THEN
124: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;
125: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'R';
126: oe_debug_pub.add('Line Security, attribute change requires reason',1);
127: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
128: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
129: END IF;
130: ELSIF x_on_operation_action = 2 THEN

Line 138: OE_DEBUG_PUB.add('While capturing history : '||sqlerrm,1);

134: l_history_captured := TRUE;
135: END IF;
136: END LOOP;
137: EXCEPTION WHEN OTHERS THEN
138: OE_DEBUG_PUB.add('While capturing history : '||sqlerrm,1);
139: NULL;
140: END;
141: IF NOT l_history_captured THEN
142: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;

Line 144: oe_debug_pub.add('Line Security, attribute change requires history',7);

140: END;
141: IF NOT l_history_captured THEN
142: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;
143: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'H';
144: oe_debug_pub.add('Line Security, attribute change requires history',7);
145: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
146: oe_debug_pub.add('Line Security, attribute change requires history',7);
147: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';
148: END IF;

Line 146: oe_debug_pub.add('Line Security, attribute change requires history',7);

142: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;
143: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'H';
144: oe_debug_pub.add('Line Security, attribute change requires history',7);
145: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
146: oe_debug_pub.add('Line Security, attribute change requires history',7);
147: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';
148: END IF;
149: END IF;
150: END IF;

Line 165: OE_DEBUG_PUB.add('While capturing history : '||sqlerrm,1);

161: l_history_captured := TRUE;
162: END IF;
163: END LOOP;
164: EXCEPTION WHEN OTHERS THEN
165: OE_DEBUG_PUB.add('While capturing history : '||sqlerrm,1);
166: NULL;
167: END;
168: IF NOT l_history_captured THEN
169: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;

Line 171: oe_debug_pub.add('Line Security, attribute change requires reason',1);

167: END;
168: IF NOT l_history_captured THEN
169: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;
170: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'R';
171: oe_debug_pub.add('Line Security, attribute change requires reason',1);
172: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
173: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
174: END IF;
175: ELSIF x_on_operation_action = 2 THEN

Line 183: OE_DEBUG_PUB.add('While capturing history : '||sqlerrm,1);

179: l_history_captured := TRUE;
180: END IF;
181: END LOOP;
182: EXCEPTION WHEN OTHERS THEN
183: OE_DEBUG_PUB.add('While capturing history : '||sqlerrm,1);
184: NULL;
185: END;
186: IF NOT l_history_captured THEN
187: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;

Line 189: oe_debug_pub.add('Line Security, attribute change requires history',7);

185: END;
186: IF NOT l_history_captured THEN
187: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;
188: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'H';
189: oe_debug_pub.add('Line Security, attribute change requires history',7);
190: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
191: oe_debug_pub.add('Line Security, attribute change requires history',7);
192: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';
193: END IF;

Line 191: oe_debug_pub.add('Line Security, attribute change requires history',7);

187: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;
188: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'H';
189: oe_debug_pub.add('Line Security, attribute change requires history',7);
190: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
191: oe_debug_pub.add('Line Security, attribute change requires history',7);
192: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';
193: END IF;
194: END IF;
195: END IF;

Line 199: OE_DEBUG_PUB.add('Audit Trail is disabled..',5);

195: END IF;
196: END IF;
197: END IF;
198: ELSE
199: OE_DEBUG_PUB.add('Audit Trail is disabled..',5);
200: END IF;
201: END IF;
202: */
203: /* End AuditTrail */

Line 2188: oe_debug_pub.add('Enter OE_Blanket_Line_Security.Entity',1);

2184: l_on_operation_action NUMBER;
2185: l_rowtype_rec OE_AK_BLANKET_LINES_V%ROWTYPE;
2186: BEGIN
2187:
2188: oe_debug_pub.add('Enter OE_Blanket_Line_Security.Entity',1);
2189:
2190: -- Initializing return status to SUCCESS
2191: x_return_status := FND_API.G_RET_STS_SUCCESS;
2192:

Line 2200: oe_debug_pub.add('Invalid operation',1);

2196: l_operation := OE_PC_GLOBALS.UPDATE_OP;
2197: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
2198: l_operation := OE_PC_GLOBALS.DELETE_OP;
2199: ELSE
2200: oe_debug_pub.add('Invalid operation',1);
2201: RAISE FND_API.G_EXC_ERROR;
2202: END IF;
2203:
2204: OE_Blanket_Util.Line_API_Rec_To_Rowtype_Rec

Line 2217: oe_debug_pub.add('Exit OE_Blanket_Line_Security.Entity',1);

2213: ,p_record => l_rowtype_rec
2214: ,x_on_operation_action => l_on_operation_action
2215: );
2216:
2217: oe_debug_pub.add('Exit OE_Blanket_Line_Security.Entity',1);
2218:
2219: EXCEPTION
2220: WHEN FND_API.G_EXC_ERROR THEN
2221: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2249: oe_debug_pub.add('Enter OE_Blanket_Line_Security.Attributes',1);

2245: l_column_name VARCHAR2(30);
2246: l_active_flag VARCHAR2(1);
2247: l_check_all_cols_constraint VARCHAR2(1);
2248: BEGIN
2249: oe_debug_pub.add('Enter OE_Blanket_Line_Security.Attributes',1);
2250:
2251: -- Initializing return status to SUCCESS
2252: x_return_status := FND_API.G_RET_STS_SUCCESS;
2253:

Line 2285: oe_debug_pub.add('Invalid operation',1);

2281:
2282: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2283: l_operation := OE_PC_GLOBALS.UPDATE_OP;
2284: ELSE
2285: oe_debug_pub.add('Invalid operation',1);
2286: RAISE FND_API.G_EXC_ERROR;
2287: END IF;
2288:
2289: OE_Blanket_Util.Line_API_Rec_To_Rowtype_Rec

Line 3316: oe_debug_pub.add('Exit OE_Blanket_Line_Security.Attributes',1);

3312: END IF;
3313:
3314: END IF;
3315:
3316: oe_debug_pub.add('Exit OE_Blanket_Line_Security.Attributes',1);
3317:
3318: EXCEPTION
3319: WHEN FND_API.G_EXC_ERROR THEN
3320: x_return_status := FND_API.G_RET_STS_ERROR;