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

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

87: AND nvl(ordered_quantity, 0) > 0
88: ORDER BY orig_sys_line_ref, orig_sys_shipment_ref;
89:
90: --
91: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
92: --
93: BEGIN
94:
95: l_header_rec := p_header_rec;

Line 121: oe_debug_pub.add( 'DERIVED CUSTOMER KEY PROFILE SETTING = '||l_customer_key_profile ) ;

117: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then
118: fnd_profile.get('ONT_INCLUDE_CUST_IN_OI_KEY', l_customer_key_profile);
119: l_customer_key_profile := nvl(l_customer_key_profile, 'N');
120: IF l_debug_level > 0 THEN
121: oe_debug_pub.add( 'DERIVED CUSTOMER KEY PROFILE SETTING = '||l_customer_key_profile ) ;
122: END IF;
123: End If;
124:
125:

Line 132: oe_debug_pub.add( 'BEFORE SETTING MESSAGE CONTEXT' ) ;

128: Set message context
129: -----------------------------------------------------------
130: */
131: IF l_debug_level > 0 THEN
132: oe_debug_pub.add( 'BEFORE SETTING MESSAGE CONTEXT' ) ;
133: END IF;
134:
135: OE_MSG_PUB.set_msg_context(
136: p_entity_code => 'HEADER'

Line 159: oe_debug_pub.add( 'BEFORE VALIDATING CHANGE SEQUENCE' ) ;

155: Validate change sequence
156: -----------------------------------------------------------
157: */
158: IF l_debug_level > 0 THEN
159: oe_debug_pub.add( 'BEFORE VALIDATING CHANGE SEQUENCE' ) ;
160: END IF;
161:
162: IF l_header_rec.force_apply_flag = 'Y' THEN
163: IF l_debug_level > 0 THEN

Line 164: oe_debug_pub.add( 'FORCE APPLY FLAG IS SET, NOT CHECKING EXISTENCE OF CHANGE_SEQUENCE' ) ;

160: END IF;
161:
162: IF l_header_rec.force_apply_flag = 'Y' THEN
163: IF l_debug_level > 0 THEN
164: oe_debug_pub.add( 'FORCE APPLY FLAG IS SET, NOT CHECKING EXISTENCE OF CHANGE_SEQUENCE' ) ;
165: END IF;
166: ELSE
167: IF l_header_rec.operation IN (OE_Globals.G_OPR_CREATE,
168: OE_Globals.G_OPR_INSERT)

Line 172: oe_debug_pub.add( 'CHANGE SEQUENCE NOT REQUIRED FOR NEW ORDERS... ' ) ;

168: OE_Globals.G_OPR_INSERT)
169: THEN
170: IF nvl(l_header_rec.change_sequence, ' ') <> ' ' THEN
171: IF l_debug_level > 0 THEN
172: oe_debug_pub.add( 'CHANGE SEQUENCE NOT REQUIRED FOR NEW ORDERS... ' ) ;
173: END IF;
174: FND_MESSAGE.SET_NAME('ONT','OE_OI_CHANGE_SEQUENCE');
175: OE_MSG_PUB.Add;
176: p_return_status := FND_API.G_RET_STS_ERROR;

Line 182: oe_debug_pub.add( 'CHANGE SEQUENCE NOT REQUIRED FOR DELETING EXISTING ORDERS... ' ) ;

178:
179: ELSIF l_header_rec.operation = OE_Globals.G_OPR_DELETE THEN
180: IF nvl(l_header_rec.change_sequence, ' ') <> ' ' THEN
181: IF l_debug_level > 0 THEN
182: oe_debug_pub.add( 'CHANGE SEQUENCE NOT REQUIRED FOR DELETING EXISTING ORDERS... ' ) ;
183: END IF;
184: FND_MESSAGE.SET_NAME('ONT','OE_OI_CHANGE_SEQUENCE');
185: OE_MSG_PUB.Add;
186: p_return_status := FND_API.G_RET_STS_ERROR;

Line 192: oe_debug_pub.add( 'CHANGE SEQUENCE REQUIRED FOR CHANGES TO AN EXISTING ORDER... ' ) ;

188:
189: ELSIF l_header_rec.operation = OE_Globals.G_OPR_UPDATE THEN
190: IF nvl(l_header_rec.change_sequence,' ') = ' ' THEN
191: IF l_debug_level > 0 THEN
192: oe_debug_pub.add( 'CHANGE SEQUENCE REQUIRED FOR CHANGES TO AN EXISTING ORDER... ' ) ;
193: END IF;
194: FND_MESSAGE.SET_NAME('ONT','OE_OI_CHANGE_SEQUENCE');
195: OE_MSG_PUB.Add;
196: p_return_status := FND_API.G_RET_STS_ERROR;

Line 204: oe_debug_pub.add( 'BEFORE VALIDATING CHANGE OUT NOCOPY OF SEQUENCE' ) ;

200:
201: -----------------------------------------------------------
202: */
203: IF l_debug_level > 0 THEN
204: oe_debug_pub.add( 'BEFORE VALIDATING CHANGE OUT NOCOPY OF SEQUENCE' ) ;
205:
206: END IF;
207:
208: BEGIN

Line 224: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;

220:
221: EXCEPTION
222: WHEN OTHERS THEN
223: IF l_debug_level > 0 THEN
224: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
225: END IF;
226:
227: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
228: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 242: oe_debug_pub.add( 'BEFORE DEFAULTING SHIP-TO-LOCATION FOR ALL OPEN SHIPMENTS' ) ;

238: code at the header level has changed.
239: -----------------------------------------------------------
240: */
241: IF l_debug_level > 0 THEN
242: oe_debug_pub.add( 'BEFORE DEFAULTING SHIP-TO-LOCATION FOR ALL OPEN SHIPMENTS' ) ;
243: END IF;
244:
245: IF l_header_rec.operation = OE_Globals.G_OPR_UPDATE AND -- update operation
246: nvl(l_header_rec.change_sequence,' ') <> ' ' AND -- new code not null

Line 252: oe_debug_pub.add( 'BEFORE READING ALL OPEN SHIPMENTS' ) ;

248: nvl(l_header_rec.ship_to_org_id, FND_API.G_MISS_NUM) <>
249: nvl(l_header_ship_to_org_id, FND_API.G_MISS_NUM) -- new code not same as old
250: THEN
251: IF l_debug_level > 0 THEN
252: oe_debug_pub.add( 'BEFORE READING ALL OPEN SHIPMENTS' ) ;
253: END IF;
254:
255: OPEN l_line_cursor;
256: LOOP

Line 303: oe_debug_pub.add( 'LINE DOES NOT EXIST. CREATING A NEW LINE...' ) ;

299: END LOOP;
300:
301: IF l_line_exists = 'N' THEN
302: IF l_debug_level > 0 THEN
303: oe_debug_pub.add( 'LINE DOES NOT EXIST. CREATING A NEW LINE...' ) ;
304: END IF;
305:
306: l_line_count := l_line_tbl.count + 1;
307: l_line_tbl(l_line_count).operation:= OE_Globals.G_OPR_UPDATE;

Line 318: oe_debug_pub.add( 'COUNT: '||TO_CHAR ( L_LINE_COUNT ) ) ;

314: l_line_tbl(l_line_count).shipment_number:= l_shipment_number;
315: l_line_tbl(l_line_count).option_number := l_option_number;
316: l_line_tbl(l_line_count).ship_to_org_id := l_header_rec.ship_to_org_id;
317: IF l_debug_level > 0 THEN
318: oe_debug_pub.add( 'COUNT: '||TO_CHAR ( L_LINE_COUNT ) ) ;
319: END IF;
320: IF l_debug_level > 0 THEN
321: oe_debug_pub.add( 'ORIG_SYS_LINE_REF: '||L_ORIG_SYS_LINE_REF ) ;
322: END IF;

Line 321: oe_debug_pub.add( 'ORIG_SYS_LINE_REF: '||L_ORIG_SYS_LINE_REF ) ;

317: IF l_debug_level > 0 THEN
318: oe_debug_pub.add( 'COUNT: '||TO_CHAR ( L_LINE_COUNT ) ) ;
319: END IF;
320: IF l_debug_level > 0 THEN
321: oe_debug_pub.add( 'ORIG_SYS_LINE_REF: '||L_ORIG_SYS_LINE_REF ) ;
322: END IF;
323: IF l_debug_level > 0 THEN
324: oe_debug_pub.add( 'LINE_ID: '||L_LINE_ID ) ;
325: END IF;

Line 324: oe_debug_pub.add( 'LINE_ID: '||L_LINE_ID ) ;

320: IF l_debug_level > 0 THEN
321: oe_debug_pub.add( 'ORIG_SYS_LINE_REF: '||L_ORIG_SYS_LINE_REF ) ;
322: END IF;
323: IF l_debug_level > 0 THEN
324: oe_debug_pub.add( 'LINE_ID: '||L_LINE_ID ) ;
325: END IF;
326: IF l_debug_level > 0 THEN
327: oe_debug_pub.add( 'SHIP_TO_ORG_ID: '||L_HEADER_REC.SHIP_TO_ORG_ID ) ;
328: END IF;

Line 327: oe_debug_pub.add( 'SHIP_TO_ORG_ID: '||L_HEADER_REC.SHIP_TO_ORG_ID ) ;

323: IF l_debug_level > 0 THEN
324: oe_debug_pub.add( 'LINE_ID: '||L_LINE_ID ) ;
325: END IF;
326: IF l_debug_level > 0 THEN
327: oe_debug_pub.add( 'SHIP_TO_ORG_ID: '||L_HEADER_REC.SHIP_TO_ORG_ID ) ;
328: END IF;
329: END IF;
330: END IF;
331: END LOOP;

Line 363: oe_debug_pub.add( 'CLEARING THE SHIP_TO_ORG IN HEADER' ) ;

359: p_header_val_rec.ship_to_location := NULL;
360: END IF;
361:
362: IF l_debug_level > 0 THEN
363: oe_debug_pub.add( 'CLEARING THE SHIP_TO_ORG IN HEADER' ) ;
364: END IF;
365: END IF;
366: --
367: IF (nvl(l_header_rec.INVOICE_TO_ORG_ID,FND_API.G_MISS_NUM)

Line 395: oe_debug_pub.add( 'CLEARING THE INVOICE_TO IN HEADER' ) ;

391: <> FND_API.G_MISS_CHAR) THEN
392: p_header_val_rec.invoice_to_location := NULL;
393: END IF;
394: IF l_debug_level > 0 THEN
395: oe_debug_pub.add( 'CLEARING THE INVOICE_TO IN HEADER' ) ;
396: END IF;
397: END IF;
398: BEGIN
399: FOR I IN 1..l_line_tbl.count

Line 431: oe_debug_pub.add( 'CLEARING THE SHIP_TO_ORG IN LINE' ) ;

427: END IF;
428:
429: --
430: IF l_debug_level > 0 THEN
431: oe_debug_pub.add( 'CLEARING THE SHIP_TO_ORG IN LINE' ) ;
432: END IF;
433: END IF;
434:
435: IF (nvl(l_line_tbl(I).INVOICE_TO_ORG_ID,FND_API.G_MISS_NUM)

Line 465: oe_debug_pub.add( 'CLEARING THE INVOICE_TO_ORG IN LINE' ) ;

461: END IF;
462:
463: --
464: IF l_debug_level > 0 THEN
465: oe_debug_pub.add( 'CLEARING THE INVOICE_TO_ORG IN LINE' ) ;
466: END IF;
467: END IF;
468: END LOOP;
469: EXCEPTION