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 128: oe_debug_pub.add( 'Get_Interface_Attributes: This line is not invoice interfaced, hence return. LINE ID:'||p_line_id , 5 ) ;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 265: oe_debug_pub.add('l_line_rec.REVREC_SIGNATURE_DATE' || l_line_rec.REVREC_SIGNATURE_DATE , 5 );

261:
262: -- Bug 8293484 Start
263: x_line_flex_rec.acceptance_date:=l_line_rec.REVREC_SIGNATURE_DATE;
264:
265: oe_debug_pub.add('l_line_rec.REVREC_SIGNATURE_DATE' || l_line_rec.REVREC_SIGNATURE_DATE , 5 );
266: oe_debug_pub.add('x_line_flex_rec.acceptance_date' || x_line_flex_rec.acceptance_date , 5 );
267: -- Bug 8293484 End
268:
269: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 266: oe_debug_pub.add('x_line_flex_rec.acceptance_date' || x_line_flex_rec.acceptance_date , 5 );

262: -- Bug 8293484 Start
263: x_line_flex_rec.acceptance_date:=l_line_rec.REVREC_SIGNATURE_DATE;
264:
265: oe_debug_pub.add('l_line_rec.REVREC_SIGNATURE_DATE' || l_line_rec.REVREC_SIGNATURE_DATE , 5 );
266: oe_debug_pub.add('x_line_flex_rec.acceptance_date' || x_line_flex_rec.acceptance_date , 5 );
267: -- Bug 8293484 End
268:
269: x_return_status := FND_API.G_RET_STS_SUCCESS;
270:

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

268:
269: x_return_status := FND_API.G_RET_STS_SUCCESS;
270:
271: IF l_debug_level > 0 THEN
272: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE1:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE1);
273: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE2:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE2);
274: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE3:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE3);
275: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE4:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE4);
276: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE5:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE5);

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

269: x_return_status := FND_API.G_RET_STS_SUCCESS;
270:
271: IF l_debug_level > 0 THEN
272: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE1:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE1);
273: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE2:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE2);
274: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE3:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE3);
275: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE4:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE4);
276: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE5:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE5);
277: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE6:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE6);

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

270:
271: IF l_debug_level > 0 THEN
272: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE1:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE1);
273: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE2:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE2);
274: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE3:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE3);
275: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE4:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE4);
276: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE5:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE5);
277: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE6:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE6);
278: oe_debug_pub.add( 'EXIT OE_AR_Acceptance_GRP.GET_INTERFACE_ATTRIBUTES PROCEDURE',5) ;

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

271: IF l_debug_level > 0 THEN
272: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE1:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE1);
273: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE2:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE2);
274: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE3:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE3);
275: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE4:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE4);
276: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE5:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE5);
277: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE6:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE6);
278: oe_debug_pub.add( 'EXIT OE_AR_Acceptance_GRP.GET_INTERFACE_ATTRIBUTES PROCEDURE',5) ;
279: END IF;

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

272: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE1:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE1);
273: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE2:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE2);
274: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE3:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE3);
275: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE4:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE4);
276: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE5:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE5);
277: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE6:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE6);
278: oe_debug_pub.add( 'EXIT OE_AR_Acceptance_GRP.GET_INTERFACE_ATTRIBUTES PROCEDURE',5) ;
279: END IF;
280:

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

273: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE2:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE2);
274: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE3:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE3);
275: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE4:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE4);
276: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE5:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE5);
277: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE6:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE6);
278: oe_debug_pub.add( 'EXIT OE_AR_Acceptance_GRP.GET_INTERFACE_ATTRIBUTES PROCEDURE',5) ;
279: END IF;
280:
281: END Get_Interface_Attributes;

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

274: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE3:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE3);
275: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE4:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE4);
276: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE5:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE5);
277: oe_debug_pub.add('INTERFACE_LINE_ATTRIBUTE6:'||x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE6);
278: oe_debug_pub.add( 'EXIT OE_AR_Acceptance_GRP.GET_INTERFACE_ATTRIBUTES PROCEDURE',5) ;
279: END IF;
280:
281: END Get_Interface_Attributes;
282: