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

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

78: )IS
79: l_delivery_line_id NUMBER := NULL;
80: l_line_rec OE_Order_Pub.Line_Rec_Type;
81: --
82: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
83: --
84: BEGIN
85: IF l_debug_level > 0 THEN
86: oe_debug_pub.add( 'ENTER OE_AR_Acceptance_GRP.GET_INTERFACE_ATTRIBUTES PROCEDURE ' , 5 ) ;

Line 86: oe_debug_pub.add( 'ENTER OE_AR_Acceptance_GRP.GET_INTERFACE_ATTRIBUTES PROCEDURE ' , 5 ) ;

82: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
83: --
84: BEGIN
85: IF l_debug_level > 0 THEN
86: oe_debug_pub.add( 'ENTER OE_AR_Acceptance_GRP.GET_INTERFACE_ATTRIBUTES PROCEDURE ' , 5 ) ;
87: END IF;
88:
89: IF (p_line_id is NULL OR p_line_id = FND_API.G_MISS_NUM) THEN
90: IF l_debug_level > 0 THEN

Line 91: oe_debug_pub.add( 'Get_Interface_Attributes:Line id is null hence return' , 5 ) ;

87: END IF;
88:
89: IF (p_line_id is NULL OR p_line_id = FND_API.G_MISS_NUM) THEN
90: IF l_debug_level > 0 THEN
91: oe_debug_pub.add( 'Get_Interface_Attributes:Line id is null hence return' , 5 ) ;
92: END IF;
93: RETURN;
94: ELSE
95: BEGIN

Line 101: oe_debug_pub.add( 'Get_Interface_Attributes: NO DATA FOUND FOR LINE ID:'||p_line_id , 5 ) ;

97:
98: EXCEPTION
99: WHEN NO_DATA_FOUND THEN
100: IF l_debug_level > 0 THEN
101: oe_debug_pub.add( 'Get_Interface_Attributes: NO DATA FOUND FOR LINE ID:'||p_line_id , 5 ) ;
102: END IF;
103: x_line_flex_rec.INTERFACE_LINE_CONTEXT := NULL;
104: x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE1 := NULL;
105: x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE2 := NULL;

Line 127: oe_debug_pub.add( 'Get_Interface_Attributes: This line is not invoice interfaced, hence return. LINE ID:'||p_line_id , 5 ) ;

123: END IF;
124:
125: IF nvl(l_line_rec.invoiced_quantity, 0) = 0 THEN
126: IF l_debug_level > 0 THEN
127: oe_debug_pub.add( 'Get_Interface_Attributes: This line is not invoice interfaced, hence return. LINE ID:'||p_line_id , 5 ) ;
128:
129: END IF;
130: x_line_flex_rec.INTERFACE_LINE_CONTEXT := NULL;
131: x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE1 := NULL;

Line 169: oe_debug_pub.add( 'Get_Interface_Attributes: HEADER_ID :'||l_line_rec.header_id , 5 ) ;

165: AND tt.transaction_type_id = oh.order_type_id
166: AND oh.header_id = l_line_rec.header_id;
167:
168: IF l_debug_level > 0 THEN
169: oe_debug_pub.add( 'Get_Interface_Attributes: HEADER_ID :'||l_line_rec.header_id , 5 ) ;
170: END IF;
171:
172: -- Populate delivery number and Waybill number
173: IF OE_Invoice_PUB.Shipping_info_Available(l_line_rec) THEN

Line 175: oe_debug_pub.add( 'Get_Interface_Attributes:Shipping_info_Available: TRUE', 5 ) ;

171:
172: -- Populate delivery number and Waybill number
173: IF OE_Invoice_PUB.Shipping_info_Available(l_line_rec) THEN
174: IF l_debug_level > 0 THEN
175: oe_debug_pub.add( 'Get_Interface_Attributes:Shipping_info_Available: TRUE', 5 ) ;
176: END IF;
177: IF l_line_rec.item_type_code NOT In ('MODEL','CLASS','KIT') THEN
178: IF l_debug_level > 0 THEN
179: oe_debug_pub.add( 'Get_Interface_Attributes: ITEM NOT A MODEL/CLASS/KIT', 5 ) ;

Line 179: oe_debug_pub.add( 'Get_Interface_Attributes: ITEM NOT A MODEL/CLASS/KIT', 5 ) ;

175: oe_debug_pub.add( 'Get_Interface_Attributes:Shipping_info_Available: TRUE', 5 ) ;
176: END IF;
177: IF l_line_rec.item_type_code NOT In ('MODEL','CLASS','KIT') THEN
178: IF l_debug_level > 0 THEN
179: oe_debug_pub.add( 'Get_Interface_Attributes: ITEM NOT A MODEL/CLASS/KIT', 5 ) ;
180: END IF;
181: BEGIN
182: SELECT min(dl.delivery_id)
183: INTO l_delivery_line_id

Line 195: oe_debug_pub.add( 'Get_Interface_Attributes: DELIVERY DETAILS NOT FOUND FOR THIS LINE' , 1 ) ;

191:
192: EXCEPTION
193: WHEN NO_DATA_FOUND THEN
194: IF l_debug_level > 0 THEN
195: oe_debug_pub.add( 'Get_Interface_Attributes: DELIVERY DETAILS NOT FOUND FOR THIS LINE' , 1 ) ;
196: END IF;
197: x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE3 := '0';
198: x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE4 := '0';
199: END;

Line 203: oe_debug_pub.add( 'Get_Interface_Attributes:ITEM IS A MODEL/CLASS/KIT' , 5 ) ;

199: END;
200: ELSE
201: -- IF l_line_rec.item_type_code In ('MODEL','CLASS','KIT') THEN
202: IF l_debug_level > 0 THEN
203: oe_debug_pub.add( 'Get_Interface_Attributes:ITEM IS A MODEL/CLASS/KIT' , 5 ) ;
204: END IF;
205: BEGIN
206: SELECT min(dl.delivery_id)
207: INTO l_delivery_line_id

Line 218: oe_debug_pub.add( 'Get_Interface_Attributes:DELIVERY DETAILS NOT FOUND FOR THIS LINE' , 1 ) ;

214: AND dd.top_model_line_id = l_line_rec.line_id;
215: EXCEPTION
216: WHEN NO_DATA_FOUND THEN
217: IF l_debug_level > 0 THEN
218: oe_debug_pub.add( 'Get_Interface_Attributes:DELIVERY DETAILS NOT FOUND FOR THIS LINE' , 1 ) ;
219: END IF;
220: x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE3 := '0';
221: x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE4 := '0';
222: END;

Line 236: oe_debug_pub.add('Get_Interface_Attributes:DELIVERY NUM:'||X_LINE_FLEX_REC.INTERFACE_LINE_ATTRIBUTE3,5);

232: FROM wsh_new_deliveries dl
233: WHERE dl.delivery_id = l_delivery_line_id;
234:
235: IF l_debug_level > 0 THEN
236: oe_debug_pub.add('Get_Interface_Attributes:DELIVERY NUM:'||X_LINE_FLEX_REC.INTERFACE_LINE_ATTRIBUTE3,5);
237: oe_debug_pub.add('Get_Interface_Attributes:WAYBILL NUM:'||X_LINE_FLEX_REC.INTERFACE_LINE_ATTRIBUTE4 ,5);
238: END IF;
239: EXCEPTION
240: WHEN NO_DATA_FOUND THEN

Line 237: oe_debug_pub.add('Get_Interface_Attributes:WAYBILL NUM:'||X_LINE_FLEX_REC.INTERFACE_LINE_ATTRIBUTE4 ,5);

233: WHERE dl.delivery_id = l_delivery_line_id;
234:
235: IF l_debug_level > 0 THEN
236: oe_debug_pub.add('Get_Interface_Attributes:DELIVERY NUM:'||X_LINE_FLEX_REC.INTERFACE_LINE_ATTRIBUTE3,5);
237: oe_debug_pub.add('Get_Interface_Attributes:WAYBILL NUM:'||X_LINE_FLEX_REC.INTERFACE_LINE_ATTRIBUTE4 ,5);
238: END IF;
239: EXCEPTION
240: WHEN NO_DATA_FOUND THEN
241: IF l_debug_level > 0 THEN

Line 242: oe_debug_pub.add( 'Get_Interface_Attributes:NO DETAILS FOUND FOR DELIVERY AND WAYBILL NUMBER' , 5 );

238: END IF;
239: EXCEPTION
240: WHEN NO_DATA_FOUND THEN
241: IF l_debug_level > 0 THEN
242: oe_debug_pub.add( 'Get_Interface_Attributes:NO DETAILS FOUND FOR DELIVERY AND WAYBILL NUMBER' , 5 );
243: END IF;
244: x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE3 := '0';
245: x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE4 := '0';
246: END;

Line 249: oe_debug_pub.add( 'Get_Interface_Attributes:NON SHIPPABLE OR RETURN LINE ' , 5 ) ;

245: x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE4 := '0';
246: END;
247: ELSE -- for Returns and non shippable lines
248: IF l_debug_level > 0 THEN
249: oe_debug_pub.add( 'Get_Interface_Attributes:NON SHIPPABLE OR RETURN LINE ' , 5 ) ;
250: END IF;
251: x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE3 := '0';
252: x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE4 := '0';
253: END IF;

Line 262: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE1:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE1);

258: x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE6 := to_char(p_line_id);
259: x_return_status := FND_API.G_RET_STS_SUCCESS;
260:
261: IF l_debug_level > 0 THEN
262: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE1:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE1);
263: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE2:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE2);
264: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE3:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE3);
265: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE4:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE4);
266: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE5:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE5);

Line 263: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE2:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE2);

259: x_return_status := FND_API.G_RET_STS_SUCCESS;
260:
261: IF l_debug_level > 0 THEN
262: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE1:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE1);
263: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE2:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE2);
264: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE3:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE3);
265: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE4:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE4);
266: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE5:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE5);
267: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE6:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE6);

Line 264: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE3:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE3);

260:
261: IF l_debug_level > 0 THEN
262: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE1:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE1);
263: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE2:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE2);
264: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE3:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE3);
265: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE4:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE4);
266: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE5:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE5);
267: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE6:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE6);
268: oe_debug_pub.add( 'EXIT OE_AR_Acceptance_GRP.GET_INTERFACE_ATTRIBUTES PROCEDURE',5) ;

Line 265: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE4:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE4);

261: IF l_debug_level > 0 THEN
262: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE1:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE1);
263: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE2:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE2);
264: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE3:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE3);
265: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE4:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE4);
266: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE5:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE5);
267: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE6:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE6);
268: oe_debug_pub.add( 'EXIT OE_AR_Acceptance_GRP.GET_INTERFACE_ATTRIBUTES PROCEDURE',5) ;
269: END IF;

Line 266: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE5:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE5);

262: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE1:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE1);
263: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE2:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE2);
264: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE3:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE3);
265: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE4:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE4);
266: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE5:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE5);
267: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE6:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE6);
268: oe_debug_pub.add( 'EXIT OE_AR_Acceptance_GRP.GET_INTERFACE_ATTRIBUTES PROCEDURE',5) ;
269: END IF;
270:

Line 267: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE6:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE6);

263: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE2:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE2);
264: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE3:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE3);
265: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE4:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE4);
266: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE5:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE5);
267: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE6:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE6);
268: oe_debug_pub.add( 'EXIT OE_AR_Acceptance_GRP.GET_INTERFACE_ATTRIBUTES PROCEDURE',5) ;
269: END IF;
270:
271: END Get_Interface_Attributes;

Line 268: oe_debug_pub.add( 'EXIT OE_AR_Acceptance_GRP.GET_INTERFACE_ATTRIBUTES PROCEDURE',5) ;

264: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE3:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE3);
265: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE4:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE4);
266: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE5:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE5);
267: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE6:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE6);
268: oe_debug_pub.add( 'EXIT OE_AR_Acceptance_GRP.GET_INTERFACE_ATTRIBUTES PROCEDURE',5) ;
269: END IF;
270:
271: END Get_Interface_Attributes;
272: