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

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

13: Procedure OELOGO(p_drop_ship_line_rec IN Drop_Ship_Line_Rec_Type,
14: p_mode IN VARCHAR2)
15: IS
16: --
17: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
18: --
19: BEGIN
20: IF (p_mode = G_MODE_CONCURRENT) THEN
21: fnd_file.put_line(FND_FILE.LOG, 'Line ID = '|| p_drop_ship_line_rec.line_id);

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

113: FROM OE_ORDER_LINES
114: WHERE LINE_ID = v_line_id;
115:
116: --
117: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
118: --
119: BEGIN
120: IF l_debug_level > 0 THEN
121: oe_debug_pub.add('Entering Purchase Release' , 1 ) ;

Line 121: oe_debug_pub.add('Entering Purchase Release' , 1 ) ;

117: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
118: --
119: BEGIN
120: IF l_debug_level > 0 THEN
121: oe_debug_pub.add('Entering Purchase Release' , 1 ) ;
122: END IF;
123:
124: IF NOT FND_API.Compatible_API_Call
125: ( l_api_version_number

Line 147: oe_debug_pub.add('User id => ' ||l_user_id,1);

143: l_org_id2 := FND_PROFILE.VALUE('OE_ORGANIZATION_ID');
144: l_org_id := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
145:
146: IF l_debug_level > 0 THEN
147: oe_debug_pub.add('User id => ' ||l_user_id,1);
148: oe_debug_pub.add('Responsibility id => ' ||l_resp_id,1);
149: oe_debug_pub.add('Application id => ' ||l_application_id,1);
150: oe_debug_pub.add('Organization id => ' ||l_org_id,1);
151: END IF;

Line 148: oe_debug_pub.add('Responsibility id => ' ||l_resp_id,1);

144: l_org_id := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
145:
146: IF l_debug_level > 0 THEN
147: oe_debug_pub.add('User id => ' ||l_user_id,1);
148: oe_debug_pub.add('Responsibility id => ' ||l_resp_id,1);
149: oe_debug_pub.add('Application id => ' ||l_application_id,1);
150: oe_debug_pub.add('Organization id => ' ||l_org_id,1);
151: END IF;
152:

Line 149: oe_debug_pub.add('Application id => ' ||l_application_id,1);

145:
146: IF l_debug_level > 0 THEN
147: oe_debug_pub.add('User id => ' ||l_user_id,1);
148: oe_debug_pub.add('Responsibility id => ' ||l_resp_id,1);
149: oe_debug_pub.add('Application id => ' ||l_application_id,1);
150: oe_debug_pub.add('Organization id => ' ||l_org_id,1);
151: END IF;
152:
153: l_old_header_id := 0;

Line 150: oe_debug_pub.add('Organization id => ' ||l_org_id,1);

146: IF l_debug_level > 0 THEN
147: oe_debug_pub.add('User id => ' ||l_user_id,1);
148: oe_debug_pub.add('Responsibility id => ' ||l_resp_id,1);
149: oe_debug_pub.add('Application id => ' ||l_application_id,1);
150: oe_debug_pub.add('Organization id => ' ||l_org_id,1);
151: END IF;
152:
153: l_old_header_id := 0;
154:

Line 159: oe_debug_pub.add('Processing Line ID : '||l_drop_ship_tbl(i).line_id,1);

155: FOR I IN 1..l_drop_ship_tbl.COUNT LOOP
156: BEGIN
157:
158: IF l_debug_level > 0 THEN
159: oe_debug_pub.add('Processing Line ID : '||l_drop_ship_tbl(i).line_id,1);
160: END IF;
161: l_drop_ship_line_rec := l_drop_ship_tbl(I);
162:
163:

Line 172: oe_debug_pub.add('User id => ' ||l_user_id,1);

168: l_application_id := wf_engine.GetItemAttrNumber( OE_GLOBALS.G_WFI_LIN , to_char(l_drop_ship_line_rec.line_id) , 'APPLICATION_ID');
169:
170:
171: IF l_debug_level > 0 THEN
172: oe_debug_pub.add('User id => ' ||l_user_id,1);
173: oe_debug_pub.add('Responsibility id => ' ||l_resp_id,1);
174: oe_debug_pub.add('Application id => ' ||l_application_id,1);
175: oe_debug_pub.add('Organization id => ' ||l_org_id,1);
176: END IF;

Line 173: oe_debug_pub.add('Responsibility id => ' ||l_resp_id,1);

169:
170:
171: IF l_debug_level > 0 THEN
172: oe_debug_pub.add('User id => ' ||l_user_id,1);
173: oe_debug_pub.add('Responsibility id => ' ||l_resp_id,1);
174: oe_debug_pub.add('Application id => ' ||l_application_id,1);
175: oe_debug_pub.add('Organization id => ' ||l_org_id,1);
176: END IF;
177:

Line 174: oe_debug_pub.add('Application id => ' ||l_application_id,1);

170:
171: IF l_debug_level > 0 THEN
172: oe_debug_pub.add('User id => ' ||l_user_id,1);
173: oe_debug_pub.add('Responsibility id => ' ||l_resp_id,1);
174: oe_debug_pub.add('Application id => ' ||l_application_id,1);
175: oe_debug_pub.add('Organization id => ' ||l_org_id,1);
176: END IF;
177:
178: /* End of bug 6118936 */

Line 175: oe_debug_pub.add('Organization id => ' ||l_org_id,1);

171: IF l_debug_level > 0 THEN
172: oe_debug_pub.add('User id => ' ||l_user_id,1);
173: oe_debug_pub.add('Responsibility id => ' ||l_resp_id,1);
174: oe_debug_pub.add('Application id => ' ||l_application_id,1);
175: oe_debug_pub.add('Organization id => ' ||l_org_id,1);
176: END IF;
177:
178: /* End of bug 6118936 */
179:

Line 183: oe_debug_pub.add('may need to freeze inc items',5);

179:
180:
181: IF FND_PROFILE.VALUE('ONT_INCLUDED_ITEM_FREEZE_METHOD') = OE_GLOBALS.G_IIFM_PICK_RELEASE THEN
182: IF l_debug_level > 0 THEN
183: oe_debug_pub.add('may need to freeze inc items',5);
184: END IF;
185:
186: SELECT item_type_code, ato_line_id
187: INTO l_item_type_code, l_ato_line_id

Line 199: oe_debug_pub.add('Freeze ret status '||l_return_status,5);

195:
196: l_return_status := OE_Config_Util.Freeze_Included_Items (l_drop_ship_line_rec.line_id);
197:
198: IF l_debug_level > 0 THEN
199: oe_debug_pub.add('Freeze ret status '||l_return_status,5);
200: END IF;
201:
202: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
203: RAISE Purchase_Release_Incomplete;

Line 218: oe_debug_pub.add('Source Type Code => '||l_drop_ship_line_rec.source_type_code,5);

214: END IF;
215: OELOGO(p_drop_ship_line_rec => l_drop_ship_line_rec,
216: p_mode => p_mode);
217: IF l_debug_level > 0 THEN
218: oe_debug_pub.add('Source Type Code => '||l_drop_ship_line_rec.source_type_code,5);
219: END IF;
220: IF (l_drop_ship_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_SERVICE) THEN
221: OPEN C_Payment_Type(l_drop_ship_line_rec.header_id);
222: FETCH C_Payment_Type INTO l_payment_type;

Line 227: oe_debug_pub.add('before calling verify payment ',1);

223: CLOSE C_Payment_Type;
224:
225: --IF l_payment_type = 'CREDIT_CARD' THEN
226: IF l_debug_level > 0 THEN
227: oe_debug_pub.add('before calling verify payment ',1);
228: END IF;
229: IF l_invoke_verify_payment = 'Y' THEN
230: IF l_debug_level > 0 THEN
231: oe_debug_pub.add('Before calling verify payment for header '||to_char(l_drop_ship_line_rec.header_id),1);

Line 231: oe_debug_pub.add('Before calling verify payment for header '||to_char(l_drop_ship_line_rec.header_id),1);

227: oe_debug_pub.add('before calling verify payment ',1);
228: END IF;
229: IF l_invoke_verify_payment = 'Y' THEN
230: IF l_debug_level > 0 THEN
231: oe_debug_pub.add('Before calling verify payment for header '||to_char(l_drop_ship_line_rec.header_id),1);
232: END IF;
233:
234: OE_VERIFY_PAYMENT_PUB.VERIFY_PAYMENT(
235: p_header_id => l_drop_ship_line_rec.header_id,

Line 246: oe_debug_pub.add('Exception: verify payment returns failure',1);

242: l_invoke_verify_payment := 'N';
243:
244: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
245: IF l_debug_level > 0 THEN
246: oe_debug_pub.add('Exception: verify payment returns failure',1);
247: END IF;
248: OE_MSG_PUB.Add_Text(p_message_text => l_msg_data);--bug4683857
249: OE_MSG_PUB.Save_API_Messages; --bug4683857
250: IF l_return_status = FND_API.G_RET_STS_ERROR then

Line 260: oe_debug_pub.add('After the call to verify payment ',5);

256: END IF;
257: --END IF; -- for 2412678
258:
259: IF l_debug_level > 0 THEN
260: oe_debug_pub.add('After the call to verify payment ',5);
261: END IF;
262:
263: /* Check if there are holds on this line or its header,
264: If yes, bypass this line */

Line 267: oe_debug_pub.add('Calling check holds including activity based holds',5);

263: /* Check if there are holds on this line or its header,
264: If yes, bypass this line */
265:
266: IF l_debug_level > 0 THEN
267: oe_debug_pub.add('Calling check holds including activity based holds',5);
268: END IF;
269: OE_Holds_PUB.Check_Holds
270: ( p_api_version => 1.0
271: ,p_init_msg_list => FND_API.G_FALSE

Line 286: oe_debug_pub.add('After calling check holds return status => '||l_return_status,1);

282: ,p_wf_activity => 'PUR_REL_THE_LINE'
283: ,x_result_out => l_result);
284:
285: IF l_debug_level > 0 THEN
286: oe_debug_pub.add('After calling check holds return status => '||l_return_status,1);
287: END IF;
288: IF l_debug_level > 0 THEN
289: oe_debug_pub.add('Return result => '||l_result,1);
290: END IF;

Line 289: oe_debug_pub.add('Return result => '||l_result,1);

285: IF l_debug_level > 0 THEN
286: oe_debug_pub.add('After calling check holds return status => '||l_return_status,1);
287: END IF;
288: IF l_debug_level > 0 THEN
289: oe_debug_pub.add('Return result => '||l_result,1);
290: END IF;
291:
292: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
293:

Line 317: oe_debug_pub.add('Exception, Deliver to Location is not setup correctly',1);

313: FND_MESSAGE.SET_NAME('ONT','OE_DS_NO_LOC_LINK');
314: OE_MSG_PUB.Add;
315: l_return_status := FND_API.G_RET_STS_ERROR;
316: IF l_debug_level > 0 THEN
317: oe_debug_pub.add('Exception, Deliver to Location is not setup correctly',1);
318: END IF;
319: RAISE Purchase_Release_Incomplete;
320: END IF;
321:

Line 323: oe_debug_pub.add('Deliver to location => ' || l_drop_ship_line_rec.deliver_to_location_id,1);

319: RAISE Purchase_Release_Incomplete;
320: END IF;
321:
322: IF l_debug_level > 0 THEN
323: oe_debug_pub.add('Deliver to location => ' || l_drop_ship_line_rec.deliver_to_location_id,1);
324: END IF;
325:
326: -- Check to see if the user who entered the order is a valid employee
327:

Line 329: oe_debug_pub.add('Employee id check '||l_drop_ship_line_rec.employee_id,1);

325:
326: -- Check to see if the user who entered the order is a valid employee
327:
328: IF l_debug_level > 0 THEN
329: oe_debug_pub.add('Employee id check '||l_drop_ship_line_rec.employee_id,1);
330: END IF;
331: OPEN C_Check_Employee_ID (l_drop_ship_line_rec.employee_id);
332: FETCH C_Check_Employee_ID INTO l_valid_employee;
333: CLOSE C_Check_Employee_ID;

Line 336: oe_debug_pub.add('Is this a valid employee ? '||l_valid_employee,1);

332: FETCH C_Check_Employee_ID INTO l_valid_employee;
333: CLOSE C_Check_Employee_ID;
334:
335: IF l_debug_level > 0 THEN
336: oe_debug_pub.add('Is this a valid employee ? '||l_valid_employee,1);
337: END IF;
338:
339: IF l_valid_employee is null THEN
340:

Line 342: oe_debug_pub.add('Invalid employee id. checking whether this is self-service order..',5);

338:
339: IF l_valid_employee is null THEN
340:
341: IF l_debug_level > 0 THEN
342: oe_debug_pub.add('Invalid employee id. checking whether this is self-service order..',5);
343: END IF;
344: --R12.MOAC
345: SELECT nvl(ORDER_SOURCE_ID,0),nvl(SOURCE_DOCUMENT_TYPE_ID,0),org_id
346: INTO l_order_source_id,l_source_document_type_id,l_ou_id

Line 351: oe_debug_pub.add('Order source id for this order is '||to_char ( l_order_source_id ) , 5 ) ;

347: FROM OE_ORDER_HEADERS_ALL
348: WHERE HEADER_ID = l_drop_ship_line_rec.header_id;
349:
350: IF l_debug_level > 0 THEN
351: oe_debug_pub.add('Order source id for this order is '||to_char ( l_order_source_id ) , 5 ) ;
352: oe_debug_pub.add('Source document type id for this order is '||to_char ( l_source_document_type_id ) , 5 ) ;
353: END IF;
354: IF l_order_source_id between 11 and 19 OR
355: l_source_document_type_id between 11 and 19 THEN -- 11 and 19 for self service orders

Line 352: oe_debug_pub.add('Source document type id for this order is '||to_char ( l_source_document_type_id ) , 5 ) ;

348: WHERE HEADER_ID = l_drop_ship_line_rec.header_id;
349:
350: IF l_debug_level > 0 THEN
351: oe_debug_pub.add('Order source id for this order is '||to_char ( l_order_source_id ) , 5 ) ;
352: oe_debug_pub.add('Source document type id for this order is '||to_char ( l_source_document_type_id ) , 5 ) ;
353: END IF;
354: IF l_order_source_id between 11 and 19 OR
355: l_source_document_type_id between 11 and 19 THEN -- 11 and 19 for self service orders
356: --R12.MOAC Start

Line 367: oe_debug_pub.add('Assigning employee id to this order as -> '||to_char ( l_temp_employee_id ),5);

363: */
364: l_temp_employee_id := Oe_Sys_Parameters.Value('ONT_EMP_ID_FOR_SS_ORDERS',l_ou_id);
365: --R12.MOAC End
366: IF l_debug_level > 0 THEN
367: oe_debug_pub.add('Assigning employee id to this order as -> '||to_char ( l_temp_employee_id ),5);
368: END IF;
369: l_drop_ship_line_rec.employee_id := l_temp_employee_id;
370: OPEN C_Check_Employee_ID (l_temp_employee_id);
371: FETCH C_Check_Employee_ID INTO l_valid_employee;

Line 376: oe_debug_pub.add('Employee id set for this order '||to_char ( l_drop_ship_line_rec.employee_id ),5);

372: CLOSE C_Check_Employee_ID;
373: END IF;
374: ELSE
375: IF l_debug_level > 0 THEN
376: oe_debug_pub.add('Employee id set for this order '||to_char ( l_drop_ship_line_rec.employee_id ),5);
377: END IF;
378: END IF;
379:
380: IF l_valid_employee is null THEN

Line 382: oe_debug_pub.add('No records found for this employee id',1);

378: END IF;
379:
380: IF l_valid_employee is null THEN
381: IF l_debug_level > 0 THEN
382: oe_debug_pub.add('No records found for this employee id',1);
383: END IF;
384: FND_MESSAGE.SET_NAME('ONT','OE_DS_NOT_VALID_EMP');
385: OE_MSG_PUB.Add;
386: RAISE Purchase_Release_Incomplete;

Line 397: OE_DEBUG_PUB.add('Item Purchase Enabled : '||item_purchase_enabled,1);

393: WHERE INVENTORY_ITEM_ID = l_drop_ship_line_rec.inventory_item_id
394: AND ORGANIZATION_ID = l_drop_ship_line_rec.ship_from_org_id;
395:
396: IF l_debug_level > 0 THEN
397: OE_DEBUG_PUB.add('Item Purchase Enabled : '||item_purchase_enabled,1);
398: END IF;
399:
400: IF nvl(item_purchase_enabled,'N') <> 'Y' THEN
401: FND_MESSAGE.SET_NAME('PO','PO_RI_INVALID_ITEM_SRC_VEND_P');

Line 404: OE_DEBUG_PUB.add('Exception, item is not purchasing enabled',1);

400: IF nvl(item_purchase_enabled,'N') <> 'Y' THEN
401: FND_MESSAGE.SET_NAME('PO','PO_RI_INVALID_ITEM_SRC_VEND_P');
402: OE_MSG_PUB.Add;
403: IF l_debug_level > 0 THEN
404: OE_DEBUG_PUB.add('Exception, item is not purchasing enabled',1);
405: END IF;
406: RAISE Purchase_Release_Incomplete;
407: END IF;
408:

Line 422: OE_DEBUG_PUB.add('Exception, Reqeust Date is either null or not valid',1);

418: -- raise error, request date cannot be null #2003381.
419: FND_MESSAGE.SET_NAME('ONT','OE_REQUEST_DATE_FOR_PR_REQD');
420: OE_MSG_PUB.Add;
421: IF l_debug_level > 0 THEN
422: OE_DEBUG_PUB.add('Exception, Reqeust Date is either null or not valid',1);
423: END IF;
424: RAISE Purchase_Release_Incomplete;
425: end if;
426: END IF;

Line 429: oe_debug_pub.add('Source type code ' || l_drop_ship_line_rec.source_type_code , 1 ) ;

425: end if;
426: END IF;
427:
428: IF l_debug_level > 0 THEN
429: oe_debug_pub.add('Source type code ' || l_drop_ship_line_rec.source_type_code , 1 ) ;
430: oe_debug_pub.add('Item type code ' || l_drop_ship_line_rec.item_type_code , 1 ) ;
431: END IF;
432:
433:

Line 430: oe_debug_pub.add('Item type code ' || l_drop_ship_line_rec.item_type_code , 1 ) ;

426: END IF;
427:
428: IF l_debug_level > 0 THEN
429: oe_debug_pub.add('Source type code ' || l_drop_ship_line_rec.source_type_code , 1 ) ;
430: oe_debug_pub.add('Item type code ' || l_drop_ship_line_rec.item_type_code , 1 ) ;
431: END IF;
432:
433:
434: IF NOT OE_GLOBALS.Equal(l_drop_ship_line_rec.source_type_code, OE_GLOBALS.G_SOURCE_EXTERNAL) THEN

Line 436: oe_debug_pub.add('Wrong source type '|| l_drop_ship_line_rec.line_id,3);

432:
433:
434: IF NOT OE_GLOBALS.Equal(l_drop_ship_line_rec.source_type_code, OE_GLOBALS.G_SOURCE_EXTERNAL) THEN
435: IF l_debug_level > 0 THEN
436: oe_debug_pub.add('Wrong source type '|| l_drop_ship_line_rec.line_id,3);
437: END IF;
438: l_drop_ship_line_rec.result := G_RES_NOT_APPLICABLE;
439: l_drop_ship_line_rec.return_status := FND_API.G_RET_STS_SUCCESS;
440: goto end_of_for_loop;

Line 449: oe_debug_pub.add('Non shippable!! '|| l_drop_ship_line_rec.line_id,3);

445: WHERE line_id = l_drop_ship_line_rec.line_id;
446:
447: IF nvl(l_shippable_flag, 'N') = 'N' THEN
448: IF l_debug_level > 0 THEN
449: oe_debug_pub.add('Non shippable!! '|| l_drop_ship_line_rec.line_id,3);
450: END IF;
451: l_drop_ship_line_rec.result := G_RES_NOT_APPLICABLE;
452: l_drop_ship_line_rec.return_status := FND_API.G_RET_STS_SUCCESS;
453: goto end_of_for_loop;

Line 460: oe_debug_pub.add('Updating sch ship date from request date',1);

456: --Fix for bug#2678070-Begin
457:
458: IF l_drop_ship_line_rec.schedule_ship_date is null THEN
459: IF l_debug_level > 0 THEN
460: oe_debug_pub.add('Updating sch ship date from request date',1);
461: END IF;
462:
463: -- Turning off Perform Scheduling Flag Before calling
464: -- this procedure since this procedure is calling Process Order

Line 500: oe_debug_pub.add('Now calling Process Order from OEXVDSPB',1);

496: l_control_rec.clear_api_cache := FALSE;
497: l_control_rec.clear_api_requests := FALSE;
498:
499: IF l_debug_level > 0 THEN
500: oe_debug_pub.add('Now calling Process Order from OEXVDSPB',1);
501: END IF;
502:
503: OE_ORDER_PVT.Lines
504: (p_validation_level => FND_API.G_VALID_LEVEL_NONE

Line 511: oe_debug_pub.add('After calling process lines' , 1 ) ;

507: ,p_x_old_line_tbl => l_old_line_tbl
508: ,x_return_status => l_return_status);
509:
510: IF l_debug_level > 0 THEN
511: oe_debug_pub.add('After calling process lines' , 1 ) ;
512: oe_debug_pub.add('Return Status ' || l_return_status , 1 ) ;
513: END IF;
514:
515: -- Bug# 4189838 Start

Line 512: oe_debug_pub.add('Return Status ' || l_return_status , 1 ) ;

508: ,x_return_status => l_return_status);
509:
510: IF l_debug_level > 0 THEN
511: oe_debug_pub.add('After calling process lines' , 1 ) ;
512: oe_debug_pub.add('Return Status ' || l_return_status , 1 ) ;
513: END IF;
514:
515: -- Bug# 4189838 Start
516: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';

Line 526: OE_DEBUG_PUB.add('Calling Process Request and Notify',1);

522: RAISE FND_API.G_EXC_ERROR;
523: END IF;
524:
525: IF l_debug_level > 0 THEN
526: OE_DEBUG_PUB.add('Calling Process Request and Notify',1);
527: END IF;
528:
529: OE_ORDER_PVT.Process_Requests_And_notify
530: ( p_process_requests => l_control_rec.process

Line 556: oe_debug_pub.add('Record already exists in drop ship table,Y OR N ? '||l_exists);

552: l_exists:='N';
553: when too_many_rows then
554: l_exists:='Y';
555: end;
556: oe_debug_pub.add('Record already exists in drop ship table,Y OR N ? '||l_exists);
557: if l_exists='N' then --added for bug 7433481
558:
559: SELECT oe_drop_ship_source_s.nextval
560: INTO l_drop_ship_source_id

Line 566: oe_debug_pub.add('Before inserting into Requisitions Interface Table' , 1 ) ;

562:
563: /* insert into po_requisition_interface table */
564:
565: IF l_debug_level > 0 THEN
566: oe_debug_pub.add('Before inserting into Requisitions Interface Table' , 1 ) ;
567: END IF;
568:
569: Insert_Into_Po_Req_Interface
570: (p_drop_ship_line_rec => l_drop_ship_line_rec

Line 581: oe_debug_pub.add('After inserting ',1);

577: ,p_drop_ship_source_id => l_drop_ship_source_id
578: );
579:
580: IF l_debug_level > 0 THEN
581: oe_debug_pub.add('After inserting ',1);
582: END IF;
583:
584: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
585: IF l_return_status = FND_API.G_RET_STS_ERROR then

Line 595: oe_debug_pub.add('Inserting Dropship Source Record',1);

591:
592: /* insert into oe_drop_ship_sources table */
593:
594: IF l_debug_level > 0 THEN
595: oe_debug_pub.add('Inserting Dropship Source Record',1);
596: END IF;
597:
598: Insert_Drop_Ship_Source
599: ( p_drop_ship_line_rec => l_drop_ship_line_rec

Line 610: oe_debug_pub.add('Inserted into Dropship Source Record', 1);

606: ,p_drop_ship_source_id => l_drop_ship_source_id
607: );
608:
609: IF l_debug_level > 0 THEN
610: oe_debug_pub.add('Inserted into Dropship Source Record', 1);
611: END IF;
612:
613: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
614: IF l_return_status = FND_API.G_RET_STS_ERROR then

Line 629: oe_debug_pub.add('Exception Purchase Release Incomplete',1);

625:
626: EXCEPTION
627: WHEN Purchase_Release_Incomplete THEN
628: IF l_debug_level > 0 THEN
629: oe_debug_pub.add('Exception Purchase Release Incomplete',1);
630: oe_debug_pub.add('Purchase Release activity is incomplete for line ID : '||l_drop_ship_line_rec.line_id,1);
631: END IF;
632: l_drop_ship_line_rec.return_status := FND_API.G_RET_STS_ERROR;
633: IF l_drop_ship_line_rec.result <> OE_Purchase_Release_PVT.G_RES_ONHOLD THEN

Line 630: oe_debug_pub.add('Purchase Release activity is incomplete for line ID : '||l_drop_ship_line_rec.line_id,1);

626: EXCEPTION
627: WHEN Purchase_Release_Incomplete THEN
628: IF l_debug_level > 0 THEN
629: oe_debug_pub.add('Exception Purchase Release Incomplete',1);
630: oe_debug_pub.add('Purchase Release activity is incomplete for line ID : '||l_drop_ship_line_rec.line_id,1);
631: END IF;
632: l_drop_ship_line_rec.return_status := FND_API.G_RET_STS_ERROR;
633: IF l_drop_ship_line_rec.result <> OE_Purchase_Release_PVT.G_RES_ONHOLD THEN
634: l_drop_ship_line_rec.result := OE_Purchase_Release_PVT.G_RES_INCOMPLETE;

Line 645: oe_debug_pub.add('AN EXPECTED ERROR RAISED..'||SQLERRM , 1 ) ;

641: l_drop_ship_line_rec.result := OE_Purchase_Release_PVT.G_RES_INCOMPLETE;
642: END IF;
643: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'Purchase_Release');
644: IF l_debug_level > 0 THEN
645: oe_debug_pub.add('AN EXPECTED ERROR RAISED..'||SQLERRM , 1 ) ;
646: END IF;
647: RAISE FND_API.G_EXC_ERROR; -- bug 4683857
648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
649: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'Purchase_Release');

Line 652: oe_debug_pub.add('AN UNEXPECTED ERROR RAISED..'||SQLERRM , 1 ) ;

648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
649: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'Purchase_Release');
650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
651: IF l_debug_level > 0 THEN
652: oe_debug_pub.add('AN UNEXPECTED ERROR RAISED..'||SQLERRM , 1 ) ;
653: END IF;
654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
655: WHEN OTHERS THEN
656: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 660: oe_debug_pub.add('OTHER ERROR RAISED..'||SQLERRM , 1 ) ;

656: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
657: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME , 'Purchase_Release');
658: END IF;
659: IF l_debug_level > 0 THEN
660: oe_debug_pub.add('OTHER ERROR RAISED..'||SQLERRM , 1 ) ;
661: END IF;
662: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
663: END;
664: <>

Line 670: oe_debug_pub.add('Exit Purchase Release for line ID : '||l_drop_ship_line_rec.line_id , 1 ) ;

666: l_old_header_id := l_drop_ship_line_rec.header_id;
667: END LOOP;
668: x_drop_ship_tbl := l_x_drop_ship_tbl;
669: IF l_debug_level > 0 THEN
670: oe_debug_pub.add('Exit Purchase Release for line ID : '||l_drop_ship_line_rec.line_id , 1 ) ;
671: END IF;
672:
673: EXCEPTION
674:

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

721: l_revision_control_code NUMBER;
722: l_ou_org_id NUMBER;
723:
724: --
725: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
726: --
727: BEGIN
728:
729: IF l_debug_level > 0 THEN

Line 730: oe_debug_pub.add( 'BEFORE INSERTING RECORDS INTO PO REQUISITIONS INTERFACE ' , 1 ) ;

726: --
727: BEGIN
728:
729: IF l_debug_level > 0 THEN
730: oe_debug_pub.add( 'BEFORE INSERTING RECORDS INTO PO REQUISITIONS INTERFACE ' , 1 ) ;
731: END IF;
732:
733: IF p_drop_ship_line_rec.project_id is not null AND
734: p_drop_ship_line_rec.project_id <> FND_API.G_MISS_NUM AND

Line 800: oe_debug_pub.add( 'ERROR WHILE RETRIEVING ITEM REVISION INFO '||SQLERRM , 1 ) ;

796: WHEN NO_DATA_FOUND THEN
797: l_item_revision := NULL;
798: WHEN OTHERS THEN
799: IF l_debug_level > 0 THEN
800: oe_debug_pub.add( 'ERROR WHILE RETRIEVING ITEM REVISION INFO '||SQLERRM , 1 ) ;
801: END IF;
802: l_item_revision := NULL;
803: END;
804: END IF;

Line 808: oe_debug_pub.add( '------------INSERTING VALUES: ----------' , 1 ) ;

804: END IF;
805: END IF;
806:
807: IF l_debug_level > 0 THEN
808: oe_debug_pub.add( '------------INSERTING VALUES: ----------' , 1 ) ;
809: oe_debug_pub.add( 'DESTINATION_ORGANIZATION_ID: '||P_DROP_SHIP_LINE_REC.SHIP_FROM_ORG_ID , 1 ) ;
810: oe_debug_pub.add( 'DELIVER_TO_LOCATION_ID : '||P_DROP_SHIP_LINE_REC.DELIVER_TO_LOCATION_ID , 1 ) ;
811: oe_debug_pub.add( 'DELIVER_TO_REQUESTOR_ID : '||P_DROP_SHIP_LINE_REC.EMPLOYEE_ID , 1 ) ;
812: oe_debug_pub.add( 'NEED_BY_DATE : '||L_SCHEDULE_SHIP_DATE , 1 ) ;

Line 809: oe_debug_pub.add( 'DESTINATION_ORGANIZATION_ID: '||P_DROP_SHIP_LINE_REC.SHIP_FROM_ORG_ID , 1 ) ;

805: END IF;
806:
807: IF l_debug_level > 0 THEN
808: oe_debug_pub.add( '------------INSERTING VALUES: ----------' , 1 ) ;
809: oe_debug_pub.add( 'DESTINATION_ORGANIZATION_ID: '||P_DROP_SHIP_LINE_REC.SHIP_FROM_ORG_ID , 1 ) ;
810: oe_debug_pub.add( 'DELIVER_TO_LOCATION_ID : '||P_DROP_SHIP_LINE_REC.DELIVER_TO_LOCATION_ID , 1 ) ;
811: oe_debug_pub.add( 'DELIVER_TO_REQUESTOR_ID : '||P_DROP_SHIP_LINE_REC.EMPLOYEE_ID , 1 ) ;
812: oe_debug_pub.add( 'NEED_BY_DATE : '||L_SCHEDULE_SHIP_DATE , 1 ) ;
813: oe_debug_pub.add( 'LAST_UPDATED_BY : '||P_USER_ID , 1 ) ;

Line 810: oe_debug_pub.add( 'DELIVER_TO_LOCATION_ID : '||P_DROP_SHIP_LINE_REC.DELIVER_TO_LOCATION_ID , 1 ) ;

806:
807: IF l_debug_level > 0 THEN
808: oe_debug_pub.add( '------------INSERTING VALUES: ----------' , 1 ) ;
809: oe_debug_pub.add( 'DESTINATION_ORGANIZATION_ID: '||P_DROP_SHIP_LINE_REC.SHIP_FROM_ORG_ID , 1 ) ;
810: oe_debug_pub.add( 'DELIVER_TO_LOCATION_ID : '||P_DROP_SHIP_LINE_REC.DELIVER_TO_LOCATION_ID , 1 ) ;
811: oe_debug_pub.add( 'DELIVER_TO_REQUESTOR_ID : '||P_DROP_SHIP_LINE_REC.EMPLOYEE_ID , 1 ) ;
812: oe_debug_pub.add( 'NEED_BY_DATE : '||L_SCHEDULE_SHIP_DATE , 1 ) ;
813: oe_debug_pub.add( 'LAST_UPDATED_BY : '||P_USER_ID , 1 ) ;
814: oe_debug_pub.add( 'LAST_UPDATE_LOGIN : '||P_LOGIN_ID , 1 ) ;

Line 811: oe_debug_pub.add( 'DELIVER_TO_REQUESTOR_ID : '||P_DROP_SHIP_LINE_REC.EMPLOYEE_ID , 1 ) ;

807: IF l_debug_level > 0 THEN
808: oe_debug_pub.add( '------------INSERTING VALUES: ----------' , 1 ) ;
809: oe_debug_pub.add( 'DESTINATION_ORGANIZATION_ID: '||P_DROP_SHIP_LINE_REC.SHIP_FROM_ORG_ID , 1 ) ;
810: oe_debug_pub.add( 'DELIVER_TO_LOCATION_ID : '||P_DROP_SHIP_LINE_REC.DELIVER_TO_LOCATION_ID , 1 ) ;
811: oe_debug_pub.add( 'DELIVER_TO_REQUESTOR_ID : '||P_DROP_SHIP_LINE_REC.EMPLOYEE_ID , 1 ) ;
812: oe_debug_pub.add( 'NEED_BY_DATE : '||L_SCHEDULE_SHIP_DATE , 1 ) ;
813: oe_debug_pub.add( 'LAST_UPDATED_BY : '||P_USER_ID , 1 ) ;
814: oe_debug_pub.add( 'LAST_UPDATE_LOGIN : '||P_LOGIN_ID , 1 ) ;
815: oe_debug_pub.add( 'DESTINATION_TYPE_CODE : '||L_DESTINATION_TYPE_CODE , 1 ) ;

Line 812: oe_debug_pub.add( 'NEED_BY_DATE : '||L_SCHEDULE_SHIP_DATE , 1 ) ;

808: oe_debug_pub.add( '------------INSERTING VALUES: ----------' , 1 ) ;
809: oe_debug_pub.add( 'DESTINATION_ORGANIZATION_ID: '||P_DROP_SHIP_LINE_REC.SHIP_FROM_ORG_ID , 1 ) ;
810: oe_debug_pub.add( 'DELIVER_TO_LOCATION_ID : '||P_DROP_SHIP_LINE_REC.DELIVER_TO_LOCATION_ID , 1 ) ;
811: oe_debug_pub.add( 'DELIVER_TO_REQUESTOR_ID : '||P_DROP_SHIP_LINE_REC.EMPLOYEE_ID , 1 ) ;
812: oe_debug_pub.add( 'NEED_BY_DATE : '||L_SCHEDULE_SHIP_DATE , 1 ) ;
813: oe_debug_pub.add( 'LAST_UPDATED_BY : '||P_USER_ID , 1 ) ;
814: oe_debug_pub.add( 'LAST_UPDATE_LOGIN : '||P_LOGIN_ID , 1 ) ;
815: oe_debug_pub.add( 'DESTINATION_TYPE_CODE : '||L_DESTINATION_TYPE_CODE , 1 ) ;
816: oe_debug_pub.add( 'QUANTITY : '||P_DROP_SHIP_LINE_REC.OPEN_QUANTITY , 1 ) ;

Line 813: oe_debug_pub.add( 'LAST_UPDATED_BY : '||P_USER_ID , 1 ) ;

809: oe_debug_pub.add( 'DESTINATION_ORGANIZATION_ID: '||P_DROP_SHIP_LINE_REC.SHIP_FROM_ORG_ID , 1 ) ;
810: oe_debug_pub.add( 'DELIVER_TO_LOCATION_ID : '||P_DROP_SHIP_LINE_REC.DELIVER_TO_LOCATION_ID , 1 ) ;
811: oe_debug_pub.add( 'DELIVER_TO_REQUESTOR_ID : '||P_DROP_SHIP_LINE_REC.EMPLOYEE_ID , 1 ) ;
812: oe_debug_pub.add( 'NEED_BY_DATE : '||L_SCHEDULE_SHIP_DATE , 1 ) ;
813: oe_debug_pub.add( 'LAST_UPDATED_BY : '||P_USER_ID , 1 ) ;
814: oe_debug_pub.add( 'LAST_UPDATE_LOGIN : '||P_LOGIN_ID , 1 ) ;
815: oe_debug_pub.add( 'DESTINATION_TYPE_CODE : '||L_DESTINATION_TYPE_CODE , 1 ) ;
816: oe_debug_pub.add( 'QUANTITY : '||P_DROP_SHIP_LINE_REC.OPEN_QUANTITY , 1 ) ;
817: oe_debug_pub.add( 'AUTHORIZATION_STATUS : '||L_AUTHORIZATION_STATUS , 1 ) ;

Line 814: oe_debug_pub.add( 'LAST_UPDATE_LOGIN : '||P_LOGIN_ID , 1 ) ;

810: oe_debug_pub.add( 'DELIVER_TO_LOCATION_ID : '||P_DROP_SHIP_LINE_REC.DELIVER_TO_LOCATION_ID , 1 ) ;
811: oe_debug_pub.add( 'DELIVER_TO_REQUESTOR_ID : '||P_DROP_SHIP_LINE_REC.EMPLOYEE_ID , 1 ) ;
812: oe_debug_pub.add( 'NEED_BY_DATE : '||L_SCHEDULE_SHIP_DATE , 1 ) ;
813: oe_debug_pub.add( 'LAST_UPDATED_BY : '||P_USER_ID , 1 ) ;
814: oe_debug_pub.add( 'LAST_UPDATE_LOGIN : '||P_LOGIN_ID , 1 ) ;
815: oe_debug_pub.add( 'DESTINATION_TYPE_CODE : '||L_DESTINATION_TYPE_CODE , 1 ) ;
816: oe_debug_pub.add( 'QUANTITY : '||P_DROP_SHIP_LINE_REC.OPEN_QUANTITY , 1 ) ;
817: oe_debug_pub.add( 'AUTHORIZATION_STATUS : '||L_AUTHORIZATION_STATUS , 1 ) ;
818: oe_debug_pub.add( 'PREPARER_ID : '||P_DROP_SHIP_LINE_REC.EMPLOYEE_ID , 1 ) ;

Line 815: oe_debug_pub.add( 'DESTINATION_TYPE_CODE : '||L_DESTINATION_TYPE_CODE , 1 ) ;

811: oe_debug_pub.add( 'DELIVER_TO_REQUESTOR_ID : '||P_DROP_SHIP_LINE_REC.EMPLOYEE_ID , 1 ) ;
812: oe_debug_pub.add( 'NEED_BY_DATE : '||L_SCHEDULE_SHIP_DATE , 1 ) ;
813: oe_debug_pub.add( 'LAST_UPDATED_BY : '||P_USER_ID , 1 ) ;
814: oe_debug_pub.add( 'LAST_UPDATE_LOGIN : '||P_LOGIN_ID , 1 ) ;
815: oe_debug_pub.add( 'DESTINATION_TYPE_CODE : '||L_DESTINATION_TYPE_CODE , 1 ) ;
816: oe_debug_pub.add( 'QUANTITY : '||P_DROP_SHIP_LINE_REC.OPEN_QUANTITY , 1 ) ;
817: oe_debug_pub.add( 'AUTHORIZATION_STATUS : '||L_AUTHORIZATION_STATUS , 1 ) ;
818: oe_debug_pub.add( 'PREPARER_ID : '||P_DROP_SHIP_LINE_REC.EMPLOYEE_ID , 1 ) ;
819: oe_debug_pub.add( 'ITEM_ID : '||P_DROP_SHIP_LINE_REC.INVENTORY_ITEM_ID , 1 ) ;

Line 816: oe_debug_pub.add( 'QUANTITY : '||P_DROP_SHIP_LINE_REC.OPEN_QUANTITY , 1 ) ;

812: oe_debug_pub.add( 'NEED_BY_DATE : '||L_SCHEDULE_SHIP_DATE , 1 ) ;
813: oe_debug_pub.add( 'LAST_UPDATED_BY : '||P_USER_ID , 1 ) ;
814: oe_debug_pub.add( 'LAST_UPDATE_LOGIN : '||P_LOGIN_ID , 1 ) ;
815: oe_debug_pub.add( 'DESTINATION_TYPE_CODE : '||L_DESTINATION_TYPE_CODE , 1 ) ;
816: oe_debug_pub.add( 'QUANTITY : '||P_DROP_SHIP_LINE_REC.OPEN_QUANTITY , 1 ) ;
817: oe_debug_pub.add( 'AUTHORIZATION_STATUS : '||L_AUTHORIZATION_STATUS , 1 ) ;
818: oe_debug_pub.add( 'PREPARER_ID : '||P_DROP_SHIP_LINE_REC.EMPLOYEE_ID , 1 ) ;
819: oe_debug_pub.add( 'ITEM_ID : '||P_DROP_SHIP_LINE_REC.INVENTORY_ITEM_ID , 1 ) ;
820: oe_debug_pub.add( 'STOCK ENABLED FLAG : '||L_STOCK_ENABLED_FLAG , 1 ) ;

Line 817: oe_debug_pub.add( 'AUTHORIZATION_STATUS : '||L_AUTHORIZATION_STATUS , 1 ) ;

813: oe_debug_pub.add( 'LAST_UPDATED_BY : '||P_USER_ID , 1 ) ;
814: oe_debug_pub.add( 'LAST_UPDATE_LOGIN : '||P_LOGIN_ID , 1 ) ;
815: oe_debug_pub.add( 'DESTINATION_TYPE_CODE : '||L_DESTINATION_TYPE_CODE , 1 ) ;
816: oe_debug_pub.add( 'QUANTITY : '||P_DROP_SHIP_LINE_REC.OPEN_QUANTITY , 1 ) ;
817: oe_debug_pub.add( 'AUTHORIZATION_STATUS : '||L_AUTHORIZATION_STATUS , 1 ) ;
818: oe_debug_pub.add( 'PREPARER_ID : '||P_DROP_SHIP_LINE_REC.EMPLOYEE_ID , 1 ) ;
819: oe_debug_pub.add( 'ITEM_ID : '||P_DROP_SHIP_LINE_REC.INVENTORY_ITEM_ID , 1 ) ;
820: oe_debug_pub.add( 'STOCK ENABLED FLAG : '||L_STOCK_ENABLED_FLAG , 1 ) ;
821: oe_debug_pub.add( 'CHARGE_ACCOUNT_ID : '||P_DROP_SHIP_LINE_REC.CHARGE_ACCOUNT_ID , 1 ) ;

Line 818: oe_debug_pub.add( 'PREPARER_ID : '||P_DROP_SHIP_LINE_REC.EMPLOYEE_ID , 1 ) ;

814: oe_debug_pub.add( 'LAST_UPDATE_LOGIN : '||P_LOGIN_ID , 1 ) ;
815: oe_debug_pub.add( 'DESTINATION_TYPE_CODE : '||L_DESTINATION_TYPE_CODE , 1 ) ;
816: oe_debug_pub.add( 'QUANTITY : '||P_DROP_SHIP_LINE_REC.OPEN_QUANTITY , 1 ) ;
817: oe_debug_pub.add( 'AUTHORIZATION_STATUS : '||L_AUTHORIZATION_STATUS , 1 ) ;
818: oe_debug_pub.add( 'PREPARER_ID : '||P_DROP_SHIP_LINE_REC.EMPLOYEE_ID , 1 ) ;
819: oe_debug_pub.add( 'ITEM_ID : '||P_DROP_SHIP_LINE_REC.INVENTORY_ITEM_ID , 1 ) ;
820: oe_debug_pub.add( 'STOCK ENABLED FLAG : '||L_STOCK_ENABLED_FLAG , 1 ) ;
821: oe_debug_pub.add( 'CHARGE_ACCOUNT_ID : '||P_DROP_SHIP_LINE_REC.CHARGE_ACCOUNT_ID , 1 ) ;
822: oe_debug_pub.add( 'INTERFACE_SOURCE_LINE_ID : '||P_DROP_SHIP_SOURCE_ID , 1 ) ;

Line 819: oe_debug_pub.add( 'ITEM_ID : '||P_DROP_SHIP_LINE_REC.INVENTORY_ITEM_ID , 1 ) ;

815: oe_debug_pub.add( 'DESTINATION_TYPE_CODE : '||L_DESTINATION_TYPE_CODE , 1 ) ;
816: oe_debug_pub.add( 'QUANTITY : '||P_DROP_SHIP_LINE_REC.OPEN_QUANTITY , 1 ) ;
817: oe_debug_pub.add( 'AUTHORIZATION_STATUS : '||L_AUTHORIZATION_STATUS , 1 ) ;
818: oe_debug_pub.add( 'PREPARER_ID : '||P_DROP_SHIP_LINE_REC.EMPLOYEE_ID , 1 ) ;
819: oe_debug_pub.add( 'ITEM_ID : '||P_DROP_SHIP_LINE_REC.INVENTORY_ITEM_ID , 1 ) ;
820: oe_debug_pub.add( 'STOCK ENABLED FLAG : '||L_STOCK_ENABLED_FLAG , 1 ) ;
821: oe_debug_pub.add( 'CHARGE_ACCOUNT_ID : '||P_DROP_SHIP_LINE_REC.CHARGE_ACCOUNT_ID , 1 ) ;
822: oe_debug_pub.add( 'INTERFACE_SOURCE_LINE_ID : '||P_DROP_SHIP_SOURCE_ID , 1 ) ;
823: oe_debug_pub.add( 'PROJECT_ID : '||P_DROP_SHIP_LINE_REC.PROJECT_ID , 1 ) ;

Line 820: oe_debug_pub.add( 'STOCK ENABLED FLAG : '||L_STOCK_ENABLED_FLAG , 1 ) ;

816: oe_debug_pub.add( 'QUANTITY : '||P_DROP_SHIP_LINE_REC.OPEN_QUANTITY , 1 ) ;
817: oe_debug_pub.add( 'AUTHORIZATION_STATUS : '||L_AUTHORIZATION_STATUS , 1 ) ;
818: oe_debug_pub.add( 'PREPARER_ID : '||P_DROP_SHIP_LINE_REC.EMPLOYEE_ID , 1 ) ;
819: oe_debug_pub.add( 'ITEM_ID : '||P_DROP_SHIP_LINE_REC.INVENTORY_ITEM_ID , 1 ) ;
820: oe_debug_pub.add( 'STOCK ENABLED FLAG : '||L_STOCK_ENABLED_FLAG , 1 ) ;
821: oe_debug_pub.add( 'CHARGE_ACCOUNT_ID : '||P_DROP_SHIP_LINE_REC.CHARGE_ACCOUNT_ID , 1 ) ;
822: oe_debug_pub.add( 'INTERFACE_SOURCE_LINE_ID : '||P_DROP_SHIP_SOURCE_ID , 1 ) ;
823: oe_debug_pub.add( 'PROJECT_ID : '||P_DROP_SHIP_LINE_REC.PROJECT_ID , 1 ) ;
824: oe_debug_pub.add( 'TASK_ID : '||P_DROP_SHIP_LINE_REC.TASK_ID , 1 ) ;

Line 821: oe_debug_pub.add( 'CHARGE_ACCOUNT_ID : '||P_DROP_SHIP_LINE_REC.CHARGE_ACCOUNT_ID , 1 ) ;

817: oe_debug_pub.add( 'AUTHORIZATION_STATUS : '||L_AUTHORIZATION_STATUS , 1 ) ;
818: oe_debug_pub.add( 'PREPARER_ID : '||P_DROP_SHIP_LINE_REC.EMPLOYEE_ID , 1 ) ;
819: oe_debug_pub.add( 'ITEM_ID : '||P_DROP_SHIP_LINE_REC.INVENTORY_ITEM_ID , 1 ) ;
820: oe_debug_pub.add( 'STOCK ENABLED FLAG : '||L_STOCK_ENABLED_FLAG , 1 ) ;
821: oe_debug_pub.add( 'CHARGE_ACCOUNT_ID : '||P_DROP_SHIP_LINE_REC.CHARGE_ACCOUNT_ID , 1 ) ;
822: oe_debug_pub.add( 'INTERFACE_SOURCE_LINE_ID : '||P_DROP_SHIP_SOURCE_ID , 1 ) ;
823: oe_debug_pub.add( 'PROJECT_ID : '||P_DROP_SHIP_LINE_REC.PROJECT_ID , 1 ) ;
824: oe_debug_pub.add( 'TASK_ID : '||P_DROP_SHIP_LINE_REC.TASK_ID , 1 ) ;
825: oe_debug_pub.add( 'END_ITEM_UNIT_NUMBER : '||P_DROP_SHIP_LINE_REC.END_ITEM_UNIT_NUMBER , 1 ) ;

Line 822: oe_debug_pub.add( 'INTERFACE_SOURCE_LINE_ID : '||P_DROP_SHIP_SOURCE_ID , 1 ) ;

818: oe_debug_pub.add( 'PREPARER_ID : '||P_DROP_SHIP_LINE_REC.EMPLOYEE_ID , 1 ) ;
819: oe_debug_pub.add( 'ITEM_ID : '||P_DROP_SHIP_LINE_REC.INVENTORY_ITEM_ID , 1 ) ;
820: oe_debug_pub.add( 'STOCK ENABLED FLAG : '||L_STOCK_ENABLED_FLAG , 1 ) ;
821: oe_debug_pub.add( 'CHARGE_ACCOUNT_ID : '||P_DROP_SHIP_LINE_REC.CHARGE_ACCOUNT_ID , 1 ) ;
822: oe_debug_pub.add( 'INTERFACE_SOURCE_LINE_ID : '||P_DROP_SHIP_SOURCE_ID , 1 ) ;
823: oe_debug_pub.add( 'PROJECT_ID : '||P_DROP_SHIP_LINE_REC.PROJECT_ID , 1 ) ;
824: oe_debug_pub.add( 'TASK_ID : '||P_DROP_SHIP_LINE_REC.TASK_ID , 1 ) ;
825: oe_debug_pub.add( 'END_ITEM_UNIT_NUMBER : '||P_DROP_SHIP_LINE_REC.END_ITEM_UNIT_NUMBER , 1 ) ;
826: oe_debug_pub.add( 'PROJECT_ACCOUNTING_CONTEXT : '||L_PROJECT_ACCOUNTING_CONTEXT , 1 ) ;

Line 823: oe_debug_pub.add( 'PROJECT_ID : '||P_DROP_SHIP_LINE_REC.PROJECT_ID , 1 ) ;

819: oe_debug_pub.add( 'ITEM_ID : '||P_DROP_SHIP_LINE_REC.INVENTORY_ITEM_ID , 1 ) ;
820: oe_debug_pub.add( 'STOCK ENABLED FLAG : '||L_STOCK_ENABLED_FLAG , 1 ) ;
821: oe_debug_pub.add( 'CHARGE_ACCOUNT_ID : '||P_DROP_SHIP_LINE_REC.CHARGE_ACCOUNT_ID , 1 ) ;
822: oe_debug_pub.add( 'INTERFACE_SOURCE_LINE_ID : '||P_DROP_SHIP_SOURCE_ID , 1 ) ;
823: oe_debug_pub.add( 'PROJECT_ID : '||P_DROP_SHIP_LINE_REC.PROJECT_ID , 1 ) ;
824: oe_debug_pub.add( 'TASK_ID : '||P_DROP_SHIP_LINE_REC.TASK_ID , 1 ) ;
825: oe_debug_pub.add( 'END_ITEM_UNIT_NUMBER : '||P_DROP_SHIP_LINE_REC.END_ITEM_UNIT_NUMBER , 1 ) ;
826: oe_debug_pub.add( 'PROJECT_ACCOUNTING_CONTEXT : '||L_PROJECT_ACCOUNTING_CONTEXT , 1 ) ;
827: oe_debug_pub.add( 'UNIT LIST PRICE : '||TO_CHAR ( P_DROP_SHIP_LINE_REC.UNIT_LIST_PRICE ) , 1 ) ;

Line 824: oe_debug_pub.add( 'TASK_ID : '||P_DROP_SHIP_LINE_REC.TASK_ID , 1 ) ;

820: oe_debug_pub.add( 'STOCK ENABLED FLAG : '||L_STOCK_ENABLED_FLAG , 1 ) ;
821: oe_debug_pub.add( 'CHARGE_ACCOUNT_ID : '||P_DROP_SHIP_LINE_REC.CHARGE_ACCOUNT_ID , 1 ) ;
822: oe_debug_pub.add( 'INTERFACE_SOURCE_LINE_ID : '||P_DROP_SHIP_SOURCE_ID , 1 ) ;
823: oe_debug_pub.add( 'PROJECT_ID : '||P_DROP_SHIP_LINE_REC.PROJECT_ID , 1 ) ;
824: oe_debug_pub.add( 'TASK_ID : '||P_DROP_SHIP_LINE_REC.TASK_ID , 1 ) ;
825: oe_debug_pub.add( 'END_ITEM_UNIT_NUMBER : '||P_DROP_SHIP_LINE_REC.END_ITEM_UNIT_NUMBER , 1 ) ;
826: oe_debug_pub.add( 'PROJECT_ACCOUNTING_CONTEXT : '||L_PROJECT_ACCOUNTING_CONTEXT , 1 ) ;
827: oe_debug_pub.add( 'UNIT LIST PRICE : '||TO_CHAR ( P_DROP_SHIP_LINE_REC.UNIT_LIST_PRICE ) , 1 ) ;
828: oe_debug_pub.add( 'DESTINATION TYPE CODE : '||L_DESTINATION_TYPE_CODE , 1 ) ;

Line 825: oe_debug_pub.add( 'END_ITEM_UNIT_NUMBER : '||P_DROP_SHIP_LINE_REC.END_ITEM_UNIT_NUMBER , 1 ) ;

821: oe_debug_pub.add( 'CHARGE_ACCOUNT_ID : '||P_DROP_SHIP_LINE_REC.CHARGE_ACCOUNT_ID , 1 ) ;
822: oe_debug_pub.add( 'INTERFACE_SOURCE_LINE_ID : '||P_DROP_SHIP_SOURCE_ID , 1 ) ;
823: oe_debug_pub.add( 'PROJECT_ID : '||P_DROP_SHIP_LINE_REC.PROJECT_ID , 1 ) ;
824: oe_debug_pub.add( 'TASK_ID : '||P_DROP_SHIP_LINE_REC.TASK_ID , 1 ) ;
825: oe_debug_pub.add( 'END_ITEM_UNIT_NUMBER : '||P_DROP_SHIP_LINE_REC.END_ITEM_UNIT_NUMBER , 1 ) ;
826: oe_debug_pub.add( 'PROJECT_ACCOUNTING_CONTEXT : '||L_PROJECT_ACCOUNTING_CONTEXT , 1 ) ;
827: oe_debug_pub.add( 'UNIT LIST PRICE : '||TO_CHAR ( P_DROP_SHIP_LINE_REC.UNIT_LIST_PRICE ) , 1 ) ;
828: oe_debug_pub.add( 'DESTINATION TYPE CODE : '||L_DESTINATION_TYPE_CODE , 1 ) ;
829: oe_debug_pub.add( 'ITEM REVISION : '||L_ITEM_REVISION , 1 ) ;

Line 826: oe_debug_pub.add( 'PROJECT_ACCOUNTING_CONTEXT : '||L_PROJECT_ACCOUNTING_CONTEXT , 1 ) ;

822: oe_debug_pub.add( 'INTERFACE_SOURCE_LINE_ID : '||P_DROP_SHIP_SOURCE_ID , 1 ) ;
823: oe_debug_pub.add( 'PROJECT_ID : '||P_DROP_SHIP_LINE_REC.PROJECT_ID , 1 ) ;
824: oe_debug_pub.add( 'TASK_ID : '||P_DROP_SHIP_LINE_REC.TASK_ID , 1 ) ;
825: oe_debug_pub.add( 'END_ITEM_UNIT_NUMBER : '||P_DROP_SHIP_LINE_REC.END_ITEM_UNIT_NUMBER , 1 ) ;
826: oe_debug_pub.add( 'PROJECT_ACCOUNTING_CONTEXT : '||L_PROJECT_ACCOUNTING_CONTEXT , 1 ) ;
827: oe_debug_pub.add( 'UNIT LIST PRICE : '||TO_CHAR ( P_DROP_SHIP_LINE_REC.UNIT_LIST_PRICE ) , 1 ) ;
828: oe_debug_pub.add( 'DESTINATION TYPE CODE : '||L_DESTINATION_TYPE_CODE , 1 ) ;
829: oe_debug_pub.add( 'ITEM REVISION : '||L_ITEM_REVISION , 1 ) ;
830: END IF;

Line 827: oe_debug_pub.add( 'UNIT LIST PRICE : '||TO_CHAR ( P_DROP_SHIP_LINE_REC.UNIT_LIST_PRICE ) , 1 ) ;

823: oe_debug_pub.add( 'PROJECT_ID : '||P_DROP_SHIP_LINE_REC.PROJECT_ID , 1 ) ;
824: oe_debug_pub.add( 'TASK_ID : '||P_DROP_SHIP_LINE_REC.TASK_ID , 1 ) ;
825: oe_debug_pub.add( 'END_ITEM_UNIT_NUMBER : '||P_DROP_SHIP_LINE_REC.END_ITEM_UNIT_NUMBER , 1 ) ;
826: oe_debug_pub.add( 'PROJECT_ACCOUNTING_CONTEXT : '||L_PROJECT_ACCOUNTING_CONTEXT , 1 ) ;
827: oe_debug_pub.add( 'UNIT LIST PRICE : '||TO_CHAR ( P_DROP_SHIP_LINE_REC.UNIT_LIST_PRICE ) , 1 ) ;
828: oe_debug_pub.add( 'DESTINATION TYPE CODE : '||L_DESTINATION_TYPE_CODE , 1 ) ;
829: oe_debug_pub.add( 'ITEM REVISION : '||L_ITEM_REVISION , 1 ) ;
830: END IF;
831:

Line 828: oe_debug_pub.add( 'DESTINATION TYPE CODE : '||L_DESTINATION_TYPE_CODE , 1 ) ;

824: oe_debug_pub.add( 'TASK_ID : '||P_DROP_SHIP_LINE_REC.TASK_ID , 1 ) ;
825: oe_debug_pub.add( 'END_ITEM_UNIT_NUMBER : '||P_DROP_SHIP_LINE_REC.END_ITEM_UNIT_NUMBER , 1 ) ;
826: oe_debug_pub.add( 'PROJECT_ACCOUNTING_CONTEXT : '||L_PROJECT_ACCOUNTING_CONTEXT , 1 ) ;
827: oe_debug_pub.add( 'UNIT LIST PRICE : '||TO_CHAR ( P_DROP_SHIP_LINE_REC.UNIT_LIST_PRICE ) , 1 ) ;
828: oe_debug_pub.add( 'DESTINATION TYPE CODE : '||L_DESTINATION_TYPE_CODE , 1 ) ;
829: oe_debug_pub.add( 'ITEM REVISION : '||L_ITEM_REVISION , 1 ) ;
830: END IF;
831:
832: IF l_debug_level > 0 THEN

Line 829: oe_debug_pub.add( 'ITEM REVISION : '||L_ITEM_REVISION , 1 ) ;

825: oe_debug_pub.add( 'END_ITEM_UNIT_NUMBER : '||P_DROP_SHIP_LINE_REC.END_ITEM_UNIT_NUMBER , 1 ) ;
826: oe_debug_pub.add( 'PROJECT_ACCOUNTING_CONTEXT : '||L_PROJECT_ACCOUNTING_CONTEXT , 1 ) ;
827: oe_debug_pub.add( 'UNIT LIST PRICE : '||TO_CHAR ( P_DROP_SHIP_LINE_REC.UNIT_LIST_PRICE ) , 1 ) ;
828: oe_debug_pub.add( 'DESTINATION TYPE CODE : '||L_DESTINATION_TYPE_CODE , 1 ) ;
829: oe_debug_pub.add( 'ITEM REVISION : '||L_ITEM_REVISION , 1 ) ;
830: END IF;
831:
832: IF l_debug_level > 0 THEN
833: oe_debug_pub.add( '----------------------' , 1 ) ;

Line 833: oe_debug_pub.add( '----------------------' , 1 ) ;

829: oe_debug_pub.add( 'ITEM REVISION : '||L_ITEM_REVISION , 1 ) ;
830: END IF;
831:
832: IF l_debug_level > 0 THEN
833: oe_debug_pub.add( '----------------------' , 1 ) ;
834: END IF;
835:
836: -- Fix for bug2058542
837: l_source_code :=fnd_profile.value('ONT_SOURCE_CODE');

Line 925: oe_debug_pub.add( 'END OF INSERT_INTO_PO_REQ_INTERFACE' , 1 ) ;

921: p_drop_ship_line_rec.item_description,
922: l_ou_org_id);
923:
924: IF l_debug_level > 0 THEN
925: oe_debug_pub.add( 'END OF INSERT_INTO_PO_REQ_INTERFACE' , 1 ) ;
926: END IF;
927: x_return_status := FND_API.G_RET_STS_SUCCESS;
928:
929: EXCEPTION

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

959: ,p_drop_ship_source_id IN NUMBER
960: )
961: IS
962: --
963: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
964: --
965: BEGIN
966:
967: IF l_debug_level > 0 THEN

Line 968: oe_debug_pub.add( 'START OF INSERT_DROP_SHIP_SOURCE' , 1 ) ;

964: --
965: BEGIN
966:
967: IF l_debug_level > 0 THEN
968: oe_debug_pub.add( 'START OF INSERT_DROP_SHIP_SOURCE' , 1 ) ;
969: END IF;
970:
971:
972: INSERT INTO oe_drop_ship_sources

Line 998: oe_debug_pub.add( 'END OF INSERT_DROP_SHIP_SOURCE' , 1 ) ;

994: p_org_id
995: );
996:
997: IF l_debug_level > 0 THEN
998: oe_debug_pub.add( 'END OF INSERT_DROP_SHIP_SOURCE' , 1 ) ;
999: END IF;
1000:
1001: x_return_status := FND_API.G_RET_STS_SUCCESS;
1002:

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

1027:
1028: IS
1029: l_drop_ship_line_rec Drop_Ship_Line_Rec_Type;
1030: --
1031: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1032: --
1033: BEGIN
1034: l_drop_ship_line_rec := p_drop_ship_line_rec;
1035:

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

1112: l_uom2_code VARCHAR2(25);
1113: l_preferred_grade VARCHAR2(150);
1114:
1115: --
1116: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1117: --
1118: BEGIN
1119: IF l_debug_level > 0 THEN
1120: oe_debug_pub.add( 'ENTERING GET_ELIGIBLE_LINES' , 1 ) ;

Line 1120: oe_debug_pub.add( 'ENTERING GET_ELIGIBLE_LINES' , 1 ) ;

1116: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1117: --
1118: BEGIN
1119: IF l_debug_level > 0 THEN
1120: oe_debug_pub.add( 'ENTERING GET_ELIGIBLE_LINES' , 1 ) ;
1121: END IF;
1122: l_line_id := p_line_id;
1123: l_line_count := 0;
1124: OPEN eligible_lines_cursor(p_line_id => l_line_id);

Line 1165: oe_debug_pub.add( 'EXITING GET_ELIGIBLE_LINES' , 1 ) ;

1161: END LOOP;
1162: CLOSE eligible_lines_cursor;
1163: x_drop_ship_tbl := l_drop_ship_tbl;
1164: IF l_debug_level > 0 THEN
1165: oe_debug_pub.add( 'EXITING GET_ELIGIBLE_LINES' , 1 ) ;
1166: END IF;
1167:
1168: EXCEPTION
1169:

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

1270: --l_po_status VARCHAR2(4100);
1271: l_process_flag VARCHAR2(30);
1272: l_line_num VARCHAR2(30);
1273:
1274: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1275: l_source_code VARCHAR2(30) := FND_PROFILE.Value('ONT_SOURCE_CODE');
1276: --bug 4411054
1277: l_po_status_rec PO_STATUS_REC_TYPE;
1278: l_autorization_status VARCHAR2(30);

Line 1283: OE_DEBUG_PUB.Add('Entering Process_DropShip_CMS_Requests...', 2);

1279:
1280: BEGIN
1281:
1282: IF l_debug_level > 0 THEN
1283: OE_DEBUG_PUB.Add('Entering Process_DropShip_CMS_Requests...', 2);
1284: OE_DEBUG_PUB.Add('No of Records:'|| p_request_tbl.count , 2);
1285: END IF;
1286:
1287: I := p_request_tbl.FIRST;

Line 1284: OE_DEBUG_PUB.Add('No of Records:'|| p_request_tbl.count , 2);

1280: BEGIN
1281:
1282: IF l_debug_level > 0 THEN
1283: OE_DEBUG_PUB.Add('Entering Process_DropShip_CMS_Requests...', 2);
1284: OE_DEBUG_PUB.Add('No of Records:'|| p_request_tbl.count , 2);
1285: END IF;
1286:
1287: I := p_request_tbl.FIRST;
1288:

Line 1307: OE_DEBUG_PUB.Add('After Initializing Local Variable', 2);

1303: l_ds_old_ship_to_location_id := NULL;
1304: l_ds_new_ship_to_location_id := NULL;
1305: l_ds_ship_to_location_id := NULL;
1306:
1307: OE_DEBUG_PUB.Add('After Initializing Local Variable', 2);
1308:
1309: SELECT requisition_header_id,po_header_id,
1310: requisition_line_id,po_line_id,
1311: line_location_id,po_release_id,drop_ship_source_id

Line 1327: OE_DEBUG_PUB.Add('Line Id:'||p_request_tbl(I).entity_id,2);

1323: l_po_created := 'Y';
1324: END IF;
1325:
1326: IF l_debug_level > 0 THEN
1327: OE_DEBUG_PUB.Add('Line Id:'||p_request_tbl(I).entity_id,2);
1328: OE_DEBUG_PUB.Add('Req Created: '||l_req_created,2);
1329: OE_DEBUG_PUB.Add('PO Created: '||l_po_created,2);
1330: END IF;
1331:

Line 1328: OE_DEBUG_PUB.Add('Req Created: '||l_req_created,2);

1324: END IF;
1325:
1326: IF l_debug_level > 0 THEN
1327: OE_DEBUG_PUB.Add('Line Id:'||p_request_tbl(I).entity_id,2);
1328: OE_DEBUG_PUB.Add('Req Created: '||l_req_created,2);
1329: OE_DEBUG_PUB.Add('PO Created: '||l_po_created,2);
1330: END IF;
1331:
1332: IF l_req_created = 'Y' THEN

Line 1329: OE_DEBUG_PUB.Add('PO Created: '||l_po_created,2);

1325:
1326: IF l_debug_level > 0 THEN
1327: OE_DEBUG_PUB.Add('Line Id:'||p_request_tbl(I).entity_id,2);
1328: OE_DEBUG_PUB.Add('Req Created: '||l_req_created,2);
1329: OE_DEBUG_PUB.Add('PO Created: '||l_po_created,2);
1330: END IF;
1331:
1332: IF l_req_created = 'Y' THEN
1333: -- 3579735

Line 1334: oe_debug_pub.add(' Extending req hdr ', 1);

1330: END IF;
1331:
1332: IF l_req_created = 'Y' THEN
1333: -- 3579735
1334: oe_debug_pub.add(' Extending req hdr ', 1);
1335: l_req_header_id.extend;
1336: l_req_line_id.extend;
1337: l_po_header_id.extend;
1338: l_po_release_id.extend;

Line 1377: OE_DEBUG_PUB.Add('Compare the Old and New CMS Parameters...', 2);

1373: */
1374: END IF;
1375:
1376: IF l_debug_level > 0 THEN
1377: OE_DEBUG_PUB.Add('Compare the Old and New CMS Parameters...', 2);
1378: OE_DEBUG_PUB.Add('Operation Performed:'||p_request_tbl(I).param15, 2);
1379: END IF;
1380:
1381: IF p_request_tbl(I).param15 = 'UPDATE' THEN

Line 1378: OE_DEBUG_PUB.Add('Operation Performed:'||p_request_tbl(I).param15, 2);

1374: END IF;
1375:
1376: IF l_debug_level > 0 THEN
1377: OE_DEBUG_PUB.Add('Compare the Old and New CMS Parameters...', 2);
1378: OE_DEBUG_PUB.Add('Operation Performed:'||p_request_tbl(I).param15, 2);
1379: END IF;
1380:
1381: IF p_request_tbl(I).param15 = 'UPDATE' THEN
1382:

Line 1401: OE_DEBUG_PUB.Add('----Ordered Quantity Changed----', 2);

1397: END IF;
1398:
1399:
1400: IF l_debug_level > 0 THEN
1401: OE_DEBUG_PUB.Add('----Ordered Quantity Changed----', 2);
1402: OE_DEBUG_PUB.Add('Old :'||p_request_tbl(I).param1||
1403: ' New :'||p_request_tbl(I).param8,1);
1404: OE_DEBUG_PUB.Add('--------------------------------', 2);
1405: END IF;

Line 1402: OE_DEBUG_PUB.Add('Old :'||p_request_tbl(I).param1||

1398:
1399:
1400: IF l_debug_level > 0 THEN
1401: OE_DEBUG_PUB.Add('----Ordered Quantity Changed----', 2);
1402: OE_DEBUG_PUB.Add('Old :'||p_request_tbl(I).param1||
1403: ' New :'||p_request_tbl(I).param8,1);
1404: OE_DEBUG_PUB.Add('--------------------------------', 2);
1405: END IF;
1406:

Line 1404: OE_DEBUG_PUB.Add('--------------------------------', 2);

1400: IF l_debug_level > 0 THEN
1401: OE_DEBUG_PUB.Add('----Ordered Quantity Changed----', 2);
1402: OE_DEBUG_PUB.Add('Old :'||p_request_tbl(I).param1||
1403: ' New :'||p_request_tbl(I).param8,1);
1404: OE_DEBUG_PUB.Add('--------------------------------', 2);
1405: END IF;
1406:
1407: END IF;
1408:

Line 1417: OE_DEBUG_PUB.Add('----Ordered Quantity UOM Changed----', 2);

1413: l_ds_ordered_quantity_uom := p_request_tbl(I).param9;
1414: END IF;
1415:
1416: IF l_debug_level > 0 THEN
1417: OE_DEBUG_PUB.Add('----Ordered Quantity UOM Changed----', 2);
1418: OE_DEBUG_PUB.Add('Old:'||p_request_tbl(I).param2||
1419: 'New:'||p_request_tbl(I).param9,1);
1420: OE_DEBUG_PUB.Add('--------------------------------', 2);
1421: END IF;

Line 1418: OE_DEBUG_PUB.Add('Old:'||p_request_tbl(I).param2||

1414: END IF;
1415:
1416: IF l_debug_level > 0 THEN
1417: OE_DEBUG_PUB.Add('----Ordered Quantity UOM Changed----', 2);
1418: OE_DEBUG_PUB.Add('Old:'||p_request_tbl(I).param2||
1419: 'New:'||p_request_tbl(I).param9,1);
1420: OE_DEBUG_PUB.Add('--------------------------------', 2);
1421: END IF;
1422:

Line 1420: OE_DEBUG_PUB.Add('--------------------------------', 2);

1416: IF l_debug_level > 0 THEN
1417: OE_DEBUG_PUB.Add('----Ordered Quantity UOM Changed----', 2);
1418: OE_DEBUG_PUB.Add('Old:'||p_request_tbl(I).param2||
1419: 'New:'||p_request_tbl(I).param9,1);
1420: OE_DEBUG_PUB.Add('--------------------------------', 2);
1421: END IF;
1422:
1423:
1424: END IF;

Line 1453: OE_DEBUG_PUB.Add('----Ship To Location Changed----', 2);

1449: END IF;
1450:
1451:
1452: IF l_debug_level > 0 THEN
1453: OE_DEBUG_PUB.Add('----Ship To Location Changed----', 2);
1454: OE_DEBUG_PUB.Add('Old:'||l_ds_old_ship_to_location_id||
1455: ' New:'||l_ds_new_ship_to_location_id,1);
1456: OE_DEBUG_PUB.Add('--------------------------------', 2);
1457: END IF;

Line 1454: OE_DEBUG_PUB.Add('Old:'||l_ds_old_ship_to_location_id||

1450:
1451:
1452: IF l_debug_level > 0 THEN
1453: OE_DEBUG_PUB.Add('----Ship To Location Changed----', 2);
1454: OE_DEBUG_PUB.Add('Old:'||l_ds_old_ship_to_location_id||
1455: ' New:'||l_ds_new_ship_to_location_id,1);
1456: OE_DEBUG_PUB.Add('--------------------------------', 2);
1457: END IF;
1458:

Line 1456: OE_DEBUG_PUB.Add('--------------------------------', 2);

1452: IF l_debug_level > 0 THEN
1453: OE_DEBUG_PUB.Add('----Ship To Location Changed----', 2);
1454: OE_DEBUG_PUB.Add('Old:'||l_ds_old_ship_to_location_id||
1455: ' New:'||l_ds_new_ship_to_location_id,1);
1456: OE_DEBUG_PUB.Add('--------------------------------', 2);
1457: END IF;
1458:
1459: END IF;
1460:

Line 1481: OE_DEBUG_PUB.Add('----Secondary Quantity Changed----', 2);

1477: END IF;
1478:
1479:
1480: IF l_debug_level > 0 THEN
1481: OE_DEBUG_PUB.Add('----Secondary Quantity Changed----', 2);
1482: OE_DEBUG_PUB.Add('Old:'||p_request_tbl(I).param4||
1483: ' New:'||p_request_tbl(I).param11,1);
1484: OE_DEBUG_PUB.Add('--------------------------------', 2);
1485: END IF;

Line 1482: OE_DEBUG_PUB.Add('Old:'||p_request_tbl(I).param4||

1478:
1479:
1480: IF l_debug_level > 0 THEN
1481: OE_DEBUG_PUB.Add('----Secondary Quantity Changed----', 2);
1482: OE_DEBUG_PUB.Add('Old:'||p_request_tbl(I).param4||
1483: ' New:'||p_request_tbl(I).param11,1);
1484: OE_DEBUG_PUB.Add('--------------------------------', 2);
1485: END IF;
1486:

Line 1484: OE_DEBUG_PUB.Add('--------------------------------', 2);

1480: IF l_debug_level > 0 THEN
1481: OE_DEBUG_PUB.Add('----Secondary Quantity Changed----', 2);
1482: OE_DEBUG_PUB.Add('Old:'||p_request_tbl(I).param4||
1483: ' New:'||p_request_tbl(I).param11,1);
1484: OE_DEBUG_PUB.Add('--------------------------------', 2);
1485: END IF;
1486:
1487: END IF;
1488:

Line 1498: OE_DEBUG_PUB.Add('----Secondary Quantity UOM Changed----', 2);

1494: l_ds_ordered_quantity_uom2 := p_request_tbl(I).param12;
1495: END IF;
1496:
1497: IF l_debug_level > 0 THEN
1498: OE_DEBUG_PUB.Add('----Secondary Quantity UOM Changed----', 2);
1499: OE_DEBUG_PUB.Add('Old:'||p_request_tbl(I).param5||
1500: 'New:'||p_request_tbl(I).param12,1);
1501: OE_DEBUG_PUB.Add('--------------------------------------', 2);
1502: END IF;

Line 1499: OE_DEBUG_PUB.Add('Old:'||p_request_tbl(I).param5||

1495: END IF;
1496:
1497: IF l_debug_level > 0 THEN
1498: OE_DEBUG_PUB.Add('----Secondary Quantity UOM Changed----', 2);
1499: OE_DEBUG_PUB.Add('Old:'||p_request_tbl(I).param5||
1500: 'New:'||p_request_tbl(I).param12,1);
1501: OE_DEBUG_PUB.Add('--------------------------------------', 2);
1502: END IF;
1503:

Line 1501: OE_DEBUG_PUB.Add('--------------------------------------', 2);

1497: IF l_debug_level > 0 THEN
1498: OE_DEBUG_PUB.Add('----Secondary Quantity UOM Changed----', 2);
1499: OE_DEBUG_PUB.Add('Old:'||p_request_tbl(I).param5||
1500: 'New:'||p_request_tbl(I).param12,1);
1501: OE_DEBUG_PUB.Add('--------------------------------------', 2);
1502: END IF;
1503:
1504: END IF;
1505:

Line 1514: OE_DEBUG_PUB.Add('----Preferred Grade Changed----', 2);

1510: l_ds_preferred_grade := p_request_tbl(I).param13;
1511: END IF;
1512:
1513: IF l_debug_level > 0 THEN
1514: OE_DEBUG_PUB.Add('----Preferred Grade Changed----', 2);
1515: OE_DEBUG_PUB.Add('Old:'||p_request_tbl(I).param6||
1516: 'New:'||p_request_tbl(I).param13,1);
1517: OE_DEBUG_PUB.Add('--------------------------------', 2);
1518: END IF;

Line 1515: OE_DEBUG_PUB.Add('Old:'||p_request_tbl(I).param6||

1511: END IF;
1512:
1513: IF l_debug_level > 0 THEN
1514: OE_DEBUG_PUB.Add('----Preferred Grade Changed----', 2);
1515: OE_DEBUG_PUB.Add('Old:'||p_request_tbl(I).param6||
1516: 'New:'||p_request_tbl(I).param13,1);
1517: OE_DEBUG_PUB.Add('--------------------------------', 2);
1518: END IF;
1519:

Line 1517: OE_DEBUG_PUB.Add('--------------------------------', 2);

1513: IF l_debug_level > 0 THEN
1514: OE_DEBUG_PUB.Add('----Preferred Grade Changed----', 2);
1515: OE_DEBUG_PUB.Add('Old:'||p_request_tbl(I).param6||
1516: 'New:'||p_request_tbl(I).param13,1);
1517: OE_DEBUG_PUB.Add('--------------------------------', 2);
1518: END IF;
1519:
1520:
1521: END IF;

Line 1552: OE_DEBUG_PUB.Add('----Schedule Ship Date Changed----', 2);

1548:
1549: END IF;
1550:
1551: IF l_debug_level > 0 THEN
1552: OE_DEBUG_PUB.Add('----Schedule Ship Date Changed----', 2);
1553: /*****Begin changes for bug#6918700*********/
1554: /* OE_DEBUG_PUB.Add('Old:'||p_request_tbl(I).param7||
1555: 'New:'||p_request_tbl(I).param14,1);
1556: */

Line 1554: /* OE_DEBUG_PUB.Add('Old:'||p_request_tbl(I).param7||

1550:
1551: IF l_debug_level > 0 THEN
1552: OE_DEBUG_PUB.Add('----Schedule Ship Date Changed----', 2);
1553: /*****Begin changes for bug#6918700*********/
1554: /* OE_DEBUG_PUB.Add('Old:'||p_request_tbl(I).param7||
1555: 'New:'||p_request_tbl(I).param14,1);
1556: */
1557: OE_DEBUG_PUB.Add('Old:'||p_request_tbl(I).date_param1||
1558: 'New:'||p_request_tbl(I).date_param2,1);

Line 1557: OE_DEBUG_PUB.Add('Old:'||p_request_tbl(I).date_param1||

1553: /*****Begin changes for bug#6918700*********/
1554: /* OE_DEBUG_PUB.Add('Old:'||p_request_tbl(I).param7||
1555: 'New:'||p_request_tbl(I).param14,1);
1556: */
1557: OE_DEBUG_PUB.Add('Old:'||p_request_tbl(I).date_param1||
1558: 'New:'||p_request_tbl(I).date_param2,1);
1559: /*****End changes for bug#6918700*********/
1560: OE_DEBUG_PUB.Add('--------------------------------', 2);
1561: END IF;

Line 1560: OE_DEBUG_PUB.Add('--------------------------------', 2);

1556: */
1557: OE_DEBUG_PUB.Add('Old:'||p_request_tbl(I).date_param1||
1558: 'New:'||p_request_tbl(I).date_param2,1);
1559: /*****End changes for bug#6918700*********/
1560: OE_DEBUG_PUB.Add('--------------------------------', 2);
1561: END IF;
1562:
1563: END IF;
1564:

Line 1575: OE_DEBUG_PUB.Add('Check PO Status : '|| l_po_status, 2);

1571: (x_po_header_id => l_pur_header_id
1572: ));
1573:
1574: IF l_debug_level > 0 THEN
1575: OE_DEBUG_PUB.Add('Check PO Status : '|| l_po_status, 2);
1576: END IF;
1577: */
1578: PO_DOCUMENT_CHECKS_GRP.PO_STATUS_CHECK
1579: (p_api_version => 1.0

Line 1590: OE_DEBUG_PUB.Add('Sucess call from PO_DOCUMENT_CHECKS_GRP.po_status_check',2);

1586: IF(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1587: l_autorization_status := l_po_status_rec.authorization_status(1);
1588:
1589: IF l_debug_level > 0 THEN
1590: OE_DEBUG_PUB.Add('Sucess call from PO_DOCUMENT_CHECKS_GRP.po_status_check',2);
1591: OE_DEBUG_PUB.Add('Check PO Status : '|| l_autorization_status, 2);
1592: END IF;
1593: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1591: OE_DEBUG_PUB.Add('Check PO Status : '|| l_autorization_status, 2);

1587: l_autorization_status := l_po_status_rec.authorization_status(1);
1588:
1589: IF l_debug_level > 0 THEN
1590: OE_DEBUG_PUB.Add('Sucess call from PO_DOCUMENT_CHECKS_GRP.po_status_check',2);
1591: OE_DEBUG_PUB.Add('Check PO Status : '|| l_autorization_status, 2);
1592: END IF;
1593: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1595: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1611: OE_DEBUG_PUB.Add('----Ref Data Elem Changed----', 2);

1607: l_sales_order_updated_date(l_count) := sysdate;
1608: l_changed_flag := 'Y';
1609:
1610: IF l_debug_level > 0 THEN
1611: OE_DEBUG_PUB.Add('----Ref Data Elem Changed----', 2);
1612: OE_DEBUG_PUB.Add('Req:'||l_req_created||'PO:'||l_po_created||
1613: 'Release:'||l_pur_release_id, 2);
1614: OE_DEBUG_PUB.Add('--------------------------------', 2);
1615: END IF;

Line 1612: OE_DEBUG_PUB.Add('Req:'||l_req_created||'PO:'||l_po_created||

1608: l_changed_flag := 'Y';
1609:
1610: IF l_debug_level > 0 THEN
1611: OE_DEBUG_PUB.Add('----Ref Data Elem Changed----', 2);
1612: OE_DEBUG_PUB.Add('Req:'||l_req_created||'PO:'||l_po_created||
1613: 'Release:'||l_pur_release_id, 2);
1614: OE_DEBUG_PUB.Add('--------------------------------', 2);
1615: END IF;
1616:

Line 1614: OE_DEBUG_PUB.Add('--------------------------------', 2);

1610: IF l_debug_level > 0 THEN
1611: OE_DEBUG_PUB.Add('----Ref Data Elem Changed----', 2);
1612: OE_DEBUG_PUB.Add('Req:'||l_req_created||'PO:'||l_po_created||
1613: 'Release:'||l_pur_release_id, 2);
1614: OE_DEBUG_PUB.Add('--------------------------------', 2);
1615: END IF;
1616:
1617: END IF;
1618:

Line 1634: OE_DEBUG_PUB.Add('After Querying: '||l_drop_ship_id, 2);

1630: WHERE interface_source_line_id = l_drop_ship_id
1631: AND interface_source_code = l_source_code;
1632:
1633: IF l_debug_level > 0 THEN
1634: OE_DEBUG_PUB.Add('After Querying: '||l_drop_ship_id, 2);
1635: END IF;
1636:
1637: SELECT RTRIM(line_number || '.' ||
1638: shipment_number || '.' ||

Line 1669: OE_DEBUG_PUB.Add('After Updating PO_Requisitions_Interface_All..', 2);

1665: WHERE interface_source_line_id = l_drop_ship_id
1666: AND interface_source_code = l_source_code;
1667:
1668: IF l_debug_level > 0 THEN
1669: OE_DEBUG_PUB.Add('After Updating PO_Requisitions_Interface_All..', 2);
1670: END IF;
1671:
1672: ELSIF l_process_flag = 'ERROR' THEN
1673: FND_MESSAGE.SET_NAME('ONT','ONT_DS_LINE_IN_ERROR');

Line 1694: oe_debug_pub.add('1 extending can req hdr ', 1);

1690: END IF; -- Update
1691:
1692: IF p_request_tbl(I).param15 = 'CANCEL' THEN
1693:
1694: oe_debug_pub.add('1 extending can req hdr ', 1);
1695: -- 3579735
1696: --l_can_req_header_id.extend(l_can_count);
1697: --l_can_req_line_id.extend(l_can_count);
1698: --l_can_po_header_id.extend(l_can_count);

Line 1722: OE_DEBUG_PUB.add('No po req interface records for this line',1);

1718: EXCEPTION
1719: WHEN NO_DATA_FOUND THEN
1720: -- #5262032, no data found when the req interface records deleted
1721: IF l_debug_level > 0 THEN
1722: OE_DEBUG_PUB.add('No po req interface records for this line',1);
1723: END IF;
1724: END;
1725:
1726:

Line 1728: OE_DEBUG_PUB.Add('After Querying,dropship_id: '||l_drop_ship_id||' ,process_flag:'||l_process_flag, 2);

1724: END;
1725:
1726:
1727: IF l_debug_level > 0 THEN
1728: OE_DEBUG_PUB.Add('After Querying,dropship_id: '||l_drop_ship_id||' ,process_flag:'||l_process_flag, 2);
1729: END IF;
1730:
1731: Begin
1732: SELECT RTRIM(line_number || '.' ||

Line 1756: OE_DEBUG_PUB.Add('After Deleting: '||l_drop_ship_id, 2);

1752: WHERE interface_source_line_id = l_drop_ship_id
1753: AND interface_source_code = l_source_code;
1754:
1755: IF l_debug_level > 0 THEN
1756: OE_DEBUG_PUB.Add('After Deleting: '||l_drop_ship_id, 2);
1757: END IF;
1758:
1759: ELSIF l_process_flag = 'ERROR' THEN
1760: FND_MESSAGE.SET_NAME('ONT','ONT_DS_LINE_IN_ERROR');

Line 1771: oe_debug_pub.add('assigning values to cancel records', 1);

1767: RAISE FND_API.G_EXC_ERROR;
1768: END IF;
1769:
1770: ELSE
1771: oe_debug_pub.add('assigning values to cancel records', 1);
1772: l_can_req_header_id(l_can_count) := l_requisition_header_id;
1773: l_can_req_line_id(l_can_count) := l_requisition_line_id;
1774: l_can_po_header_id(l_can_count) := l_pur_header_id;
1775: l_can_po_line_id(l_can_count) := l_pur_line_id;

Line 1785: oe_debug_pub.add('not a dropship request ', 1);

1781:
1782: END IF;
1783:
1784: ELSE
1785: oe_debug_pub.add('not a dropship request ', 1);
1786: END IF; -- Dropship CMS
1787:
1788:
1789: I := p_request_tbl.NEXT(I);

Line 1796: OE_DEBUG_PUB.Add('Before Calling Update_Req_PO...',2) ;

1792:
1793: IF l_count > 1 THEN
1794:
1795: IF l_debug_level > 0 THEN
1796: OE_DEBUG_PUB.Add('Before Calling Update_Req_PO...',2) ;
1797: OE_DEBUG_PUB.Add('No of Req Records PO: '||to_char(l_count -1),2) ;
1798: END IF;
1799: --
1800:

Line 1797: OE_DEBUG_PUB.Add('No of Req Records PO: '||to_char(l_count -1),2) ;

1793: IF l_count > 1 THEN
1794:
1795: IF l_debug_level > 0 THEN
1796: OE_DEBUG_PUB.Add('Before Calling Update_Req_PO...',2) ;
1797: OE_DEBUG_PUB.Add('No of Req Records PO: '||to_char(l_count -1),2) ;
1798: END IF;
1799: --
1800:
1801: PO_OM_INTEGRATION_GRP.Update_Req_PO

Line 1821: OE_DEBUG_PUB.Add(' After Calling update_req_po...'||l_return_status,2) ;

1817: ,x_msg_data => l_msg_data
1818: );
1819:
1820: IF l_debug_level > 0 THEN
1821: OE_DEBUG_PUB.Add(' After Calling update_req_po...'||l_return_status,2) ;
1822: OE_DEBUG_PUB.Add(' Message Count:'||l_msg_count,2) ;
1823: OE_DEBUG_PUB.Add(' Message Data:'||l_msg_data,2) ;
1824: END IF;
1825:

Line 1822: OE_DEBUG_PUB.Add(' Message Count:'||l_msg_count,2) ;

1818: );
1819:
1820: IF l_debug_level > 0 THEN
1821: OE_DEBUG_PUB.Add(' After Calling update_req_po...'||l_return_status,2) ;
1822: OE_DEBUG_PUB.Add(' Message Count:'||l_msg_count,2) ;
1823: OE_DEBUG_PUB.Add(' Message Data:'||l_msg_data,2) ;
1824: END IF;
1825:
1826: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1823: OE_DEBUG_PUB.Add(' Message Data:'||l_msg_data,2) ;

1819:
1820: IF l_debug_level > 0 THEN
1821: OE_DEBUG_PUB.Add(' After Calling update_req_po...'||l_return_status,2) ;
1822: OE_DEBUG_PUB.Add(' Message Count:'||l_msg_count,2) ;
1823: OE_DEBUG_PUB.Add(' Message Data:'||l_msg_data,2) ;
1824: END IF;
1825:
1826: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1827: OE_MSG_PUB.Transfer_Msg_Stack;

Line 1837: oe_debug_pub.add('Messages from Update PO;'||l_msg_data,1 ) ;

1833: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
1834: FOR I in 1..l_msg_count LOOP
1835: l_msg_data := OE_MSG_PUB.Get(I,'F');
1836: IF l_debug_level > 0 THEN
1837: oe_debug_pub.add('Messages from Update PO;'||l_msg_data,1 ) ;
1838: END IF;
1839: END LOOP;
1840:
1841: RAISE FND_API.G_EXC_ERROR;

Line 1849: OE_DEBUG_PUB.Add('Before Calling Cancel_Req_PO...',2) ;

1845:
1846: IF l_can_count > 1 THEN
1847:
1848: IF l_debug_level > 0 THEN
1849: OE_DEBUG_PUB.Add('Before Calling Cancel_Req_PO...',2) ;
1850: OE_DEBUG_PUB.Add
1851: ('No of Records for PO Cancellation...'||l_can_count ,2) ;
1852: END IF;
1853:

Line 1850: OE_DEBUG_PUB.Add

1846: IF l_can_count > 1 THEN
1847:
1848: IF l_debug_level > 0 THEN
1849: OE_DEBUG_PUB.Add('Before Calling Cancel_Req_PO...',2) ;
1850: OE_DEBUG_PUB.Add
1851: ('No of Records for PO Cancellation...'||l_can_count ,2) ;
1852: END IF;
1853:
1854: FOR I in l_can_req_header_id.FIRST..l_can_req_header_id.LAST

Line 1856: oe_debug_pub.add('req hdr '|| l_can_req_header_id(I), 1);

1852: END IF;
1853:
1854: FOR I in l_can_req_header_id.FIRST..l_can_req_header_id.LAST
1855: LOOP
1856: oe_debug_pub.add('req hdr '|| l_can_req_header_id(I), 1);
1857:
1858: -- added for bug 3946163
1859: -- The p_po_line_id shall be passed as NULL for all the lines that are
1860: -- attached to a blanket purchase agreement

Line 1881: OE_DEBUG_PUB.Add('After Calling Cancel_Req_PO: '||l_return_status,2) ;

1877: );
1878:
1879:
1880: IF l_debug_level > 0 THEN
1881: OE_DEBUG_PUB.Add('After Calling Cancel_Req_PO: '||l_return_status,2) ;
1882: OE_DEBUG_PUB.Add(' Message Count:'||l_msg_count,2) ;
1883: OE_DEBUG_PUB.Add(' Message Data:'||l_msg_data,2) ;
1884: END IF;
1885:

Line 1882: OE_DEBUG_PUB.Add(' Message Count:'||l_msg_count,2) ;

1878:
1879:
1880: IF l_debug_level > 0 THEN
1881: OE_DEBUG_PUB.Add('After Calling Cancel_Req_PO: '||l_return_status,2) ;
1882: OE_DEBUG_PUB.Add(' Message Count:'||l_msg_count,2) ;
1883: OE_DEBUG_PUB.Add(' Message Data:'||l_msg_data,2) ;
1884: END IF;
1885:
1886: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1883: OE_DEBUG_PUB.Add(' Message Data:'||l_msg_data,2) ;

1879:
1880: IF l_debug_level > 0 THEN
1881: OE_DEBUG_PUB.Add('After Calling Cancel_Req_PO: '||l_return_status,2) ;
1882: OE_DEBUG_PUB.Add(' Message Count:'||l_msg_count,2) ;
1883: OE_DEBUG_PUB.Add(' Message Data:'||l_msg_data,2) ;
1884: END IF;
1885:
1886: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1887: OE_MSG_PUB.Transfer_Msg_Stack;

Line 1897: oe_debug_pub.add('Messages from Cancel PO;'||l_msg_data,1 ) ;

1893: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
1894: FOR I in 1..l_msg_count LOOP
1895: l_msg_data := OE_MSG_PUB.Get(I,'F');
1896: IF l_debug_level > 0 THEN
1897: oe_debug_pub.add('Messages from Cancel PO;'||l_msg_data,1 ) ;
1898: END IF;
1899: END LOOP;
1900:
1901: IF l_debug_level > 0 THEN

Line 1902: OE_DEBUG_PUB.Add('Errors from Cancel_req_po: '||l_msg_data,2) ;

1898: END IF;
1899: END LOOP;
1900:
1901: IF l_debug_level > 0 THEN
1902: OE_DEBUG_PUB.Add('Errors from Cancel_req_po: '||l_msg_data,2) ;
1903: END IF;
1904:
1905: -- bug 5358405
1906: FND_MESSAGE.set_name('ONT','OE_CANCEL_FAILED');

Line 1929: OE_DEBUG_PUB.Add('Exiting Process_DropShip_CMS_Requests..:'||x_return_status);

1925: END LOOP;
1926: END IF;
1927:
1928: IF l_debug_level > 0 then
1929: OE_DEBUG_PUB.Add('Exiting Process_DropShip_CMS_Requests..:'||x_return_status);
1930: END IF;
1931:
1932: x_return_status := l_return_status;
1933:

Line 1937: OE_DEBUG_PUB.Add('Expected Error in Process_DropShip_CMS_Requests...',4);

1933:
1934: EXCEPTION
1935: WHEN FND_API.G_EXC_ERROR THEN
1936: IF l_debug_level > 0 THEN
1937: OE_DEBUG_PUB.Add('Expected Error in Process_DropShip_CMS_Requests...',4);
1938: END IF;
1939:
1940: x_return_status := FND_API.G_RET_STS_ERROR;
1941: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1943: OE_DEBUG_PUB.Add('UnExpected Error in Process_DropShip_CMS_Requests...'||sqlerrm,4);

1939:
1940: x_return_status := FND_API.G_RET_STS_ERROR;
1941: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1942: IF l_debug_level > 0 THEN
1943: OE_DEBUG_PUB.Add('UnExpected Error in Process_DropShip_CMS_Requests...'||sqlerrm,4);
1944: END IF;
1945:
1946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1947: WHEN OTHERS THEN