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 119: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

358: IF l_order_source_id between 11 and 19 OR
359: l_source_document_type_id between 11 and 19 THEN -- 11 and 19 for self service orders
360: l_temp_employee_id := Oe_Sys_Parameters.Value('ONT_EMP_ID_FOR_SS_ORDERS',l_ou_id);
361: IF l_debug_level > 0 THEN
362: oe_debug_pub.add('Assigning employee id to this order as -> '||to_char ( l_temp_employee_id ),5);
363: END IF;
364: l_drop_ship_line_rec.employee_id := l_temp_employee_id;
365: OPEN C_Check_Employee_ID (l_temp_employee_id);
366: FETCH C_Check_Employee_ID INTO l_valid_employee;

Line 371: Oe_debug_pub.add('Non self service order line with invalid employee...', 5);

367: CLOSE C_Check_Employee_ID;
368: ------ Start: Code changes for ER 4099922
369: ELSE
370: IF l_debug_level > 0 THEN
371: Oe_debug_pub.add('Non self service order line with invalid employee...', 5);
372: END IF;
373: l_temp_employee_id := Oe_Sys_Parameters.Value('ONT_EMP_ID_DEFAULT', l_ou_id);
374:
375: IF l_debug_level > 0 THEN

Line 376: oe_debug_pub.add('Assigning employee ID as -> '|| l_temp_employee_id, 5);

372: END IF;
373: l_temp_employee_id := Oe_Sys_Parameters.Value('ONT_EMP_ID_DEFAULT', l_ou_id);
374:
375: IF l_debug_level > 0 THEN
376: oe_debug_pub.add('Assigning employee ID as -> '|| l_temp_employee_id, 5);
377: END IF;
378:
379: IF l_debug_level > 0 THEN
380: oe_debug_pub.add('Checking for validity of employee: ' || l_temp_employee_id, 5);

Line 380: oe_debug_pub.add('Checking for validity of employee: ' || l_temp_employee_id, 5);

376: oe_debug_pub.add('Assigning employee ID as -> '|| l_temp_employee_id, 5);
377: END IF;
378:
379: IF l_debug_level > 0 THEN
380: oe_debug_pub.add('Checking for validity of employee: ' || l_temp_employee_id, 5);
381: END IF;
382:
383: IF l_temp_employee_id IS NOT NULL THEN
384: l_drop_ship_line_rec.employee_id := To_Number(l_temp_employee_id);

Line 390: oe_debug_pub.ADD('l_valid_employee: ' || l_valid_employee, 5);

386: FETCH C_Check_Employee_ID INTO l_valid_employee;
387: CLOSE C_Check_Employee_ID;
388: END IF;
389: IF l_debug_level > 0 THEN
390: oe_debug_pub.ADD('l_valid_employee: ' || l_valid_employee, 5);
391: END IF;
392: ------- End: Code changes for ER 4099922
393: END IF; -- On check for l_order_source_id being selfservice or not.
394: ELSE

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

392: ------- End: Code changes for ER 4099922
393: END IF; -- On check for l_order_source_id being selfservice or not.
394: ELSE
395: IF l_debug_level > 0 THEN
396: oe_debug_pub.add('Employee id set for this order '||to_char ( l_drop_ship_line_rec.employee_id ),5);
397: END IF;
398: END IF; -- On check for l_valid_employee being NULL or not.
399:
400: IF l_valid_employee is null THEN

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

398: END IF; -- On check for l_valid_employee being NULL or not.
399:
400: IF l_valid_employee is null THEN
401: IF l_debug_level > 0 THEN
402: oe_debug_pub.add('No records found for this employee id',1);
403: END IF;
404: FND_MESSAGE.SET_NAME('ONT','OE_DS_NOT_VALID_EMP');
405: -- Bug 13557724
406: SELECT Full_Name INTO l_inv_emp_full_name

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

428: WHERE INVENTORY_ITEM_ID = l_drop_ship_line_rec.inventory_item_id
429: AND ORGANIZATION_ID = l_drop_ship_line_rec.ship_from_org_id;
430:
431: IF l_debug_level > 0 THEN
432: OE_DEBUG_PUB.add('Item Purchase Enabled : '||item_purchase_enabled,1);
433: END IF;
434:
435: IF nvl(item_purchase_enabled,'N') <> 'Y' THEN
436: FND_MESSAGE.SET_NAME('PO','PO_RI_INVALID_ITEM_SRC_VEND_P');

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

435: IF nvl(item_purchase_enabled,'N') <> 'Y' THEN
436: FND_MESSAGE.SET_NAME('PO','PO_RI_INVALID_ITEM_SRC_VEND_P');
437: OE_MSG_PUB.Add;
438: IF l_debug_level > 0 THEN
439: OE_DEBUG_PUB.add('Exception, item is not purchasing enabled',1);
440: END IF;
441: RAISE Purchase_Release_Incomplete;
442: END IF;
443:

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

453: -- raise error, request date cannot be null #2003381.
454: FND_MESSAGE.SET_NAME('ONT','OE_REQUEST_DATE_FOR_PR_REQD');
455: OE_MSG_PUB.Add;
456: IF l_debug_level > 0 THEN
457: OE_DEBUG_PUB.add('Exception, Reqeust Date is either null or not valid',1);
458: END IF;
459: RAISE Purchase_Release_Incomplete;
460: end if;
461: END IF;

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

460: end if;
461: END IF;
462:
463: IF l_debug_level > 0 THEN
464: oe_debug_pub.add('Source type code ' || l_drop_ship_line_rec.source_type_code , 1 ) ;
465: oe_debug_pub.add('Item type code ' || l_drop_ship_line_rec.item_type_code , 1 ) ;
466: END IF;
467:
468:

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

461: END IF;
462:
463: IF l_debug_level > 0 THEN
464: oe_debug_pub.add('Source type code ' || l_drop_ship_line_rec.source_type_code , 1 ) ;
465: oe_debug_pub.add('Item type code ' || l_drop_ship_line_rec.item_type_code , 1 ) ;
466: END IF;
467:
468:
469: IF NOT OE_GLOBALS.Equal(l_drop_ship_line_rec.source_type_code, OE_GLOBALS.G_SOURCE_EXTERNAL) THEN

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

467:
468:
469: IF NOT OE_GLOBALS.Equal(l_drop_ship_line_rec.source_type_code, OE_GLOBALS.G_SOURCE_EXTERNAL) THEN
470: IF l_debug_level > 0 THEN
471: oe_debug_pub.add('Wrong source type '|| l_drop_ship_line_rec.line_id,3);
472: END IF;
473: l_drop_ship_line_rec.result := G_RES_NOT_APPLICABLE;
474: l_drop_ship_line_rec.return_status := FND_API.G_RET_STS_SUCCESS;
475: goto end_of_for_loop;

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

480: WHERE line_id = l_drop_ship_line_rec.line_id;
481:
482: IF nvl(l_shippable_flag, 'N') = 'N' THEN
483: IF l_debug_level > 0 THEN
484: oe_debug_pub.add('Non shippable!! '|| l_drop_ship_line_rec.line_id,3);
485: END IF;
486: l_drop_ship_line_rec.result := G_RES_NOT_APPLICABLE;
487: l_drop_ship_line_rec.return_status := FND_API.G_RET_STS_SUCCESS;
488: goto end_of_for_loop;

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

491: --Fix for bug#2678070-Begin
492:
493: IF l_drop_ship_line_rec.schedule_ship_date is null THEN
494: IF l_debug_level > 0 THEN
495: oe_debug_pub.add('Updating sch ship date from request date',1);
496: END IF;
497:
498: -- Turning off Perform Scheduling Flag Before calling
499: -- this procedure since this procedure is calling Process Order

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

531: l_control_rec.clear_api_cache := FALSE;
532: l_control_rec.clear_api_requests := FALSE;
533:
534: IF l_debug_level > 0 THEN
535: oe_debug_pub.add('Now calling Process Order from OEXVDSPB',1);
536: END IF;
537:
538: OE_ORDER_PVT.Lines
539: (p_validation_level => FND_API.G_VALID_LEVEL_NONE

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

542: ,p_x_old_line_tbl => l_old_line_tbl
543: ,x_return_status => l_return_status);
544:
545: IF l_debug_level > 0 THEN
546: oe_debug_pub.add('After calling process lines' , 1 ) ;
547: oe_debug_pub.add('Return Status ' || l_return_status , 1 ) ;
548: END IF;
549:
550: -- Bug# 4189838 Start

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

543: ,x_return_status => l_return_status);
544:
545: IF l_debug_level > 0 THEN
546: oe_debug_pub.add('After calling process lines' , 1 ) ;
547: oe_debug_pub.add('Return Status ' || l_return_status , 1 ) ;
548: END IF;
549:
550: -- Bug# 4189838 Start
551: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';

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

557: RAISE FND_API.G_EXC_ERROR;
558: END IF;
559:
560: IF l_debug_level > 0 THEN
561: OE_DEBUG_PUB.add('Calling Process Request and Notify',1);
562: END IF;
563:
564: OE_ORDER_PVT.Process_Requests_And_notify
565: ( p_process_requests => l_control_rec.process

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

587: l_exists:='N';
588: when too_many_rows then
589: l_exists:='Y';
590: end;
591: oe_debug_pub.add('Record already exists in drop ship table,Y OR N ? '||l_exists);
592: if l_exists='N' then --added for bug 7433481
593:
594: SELECT oe_drop_ship_source_s.nextval
595: INTO l_drop_ship_source_id

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

597:
598: /* insert into po_requisition_interface table */
599:
600: IF l_debug_level > 0 THEN
601: oe_debug_pub.add('Before inserting into Requisitions Interface Table' , 1 ) ;
602: END IF;
603:
604: Insert_Into_Po_Req_Interface
605: (p_drop_ship_line_rec => l_drop_ship_line_rec

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

612: ,p_drop_ship_source_id => l_drop_ship_source_id
613: );
614:
615: IF l_debug_level > 0 THEN
616: oe_debug_pub.add('After inserting ',1);
617: END IF;
618:
619: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
620: IF l_return_status = FND_API.G_RET_STS_ERROR then

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

626:
627: /* insert into oe_drop_ship_sources table */
628:
629: IF l_debug_level > 0 THEN
630: oe_debug_pub.add('Inserting Dropship Source Record',1);
631: END IF;
632:
633: Insert_Drop_Ship_Source
634: ( p_drop_ship_line_rec => l_drop_ship_line_rec

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

641: ,p_drop_ship_source_id => l_drop_ship_source_id
642: );
643:
644: IF l_debug_level > 0 THEN
645: oe_debug_pub.add('Inserted into Dropship Source Record', 1);
646: END IF;
647:
648: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
649: IF l_return_status = FND_API.G_RET_STS_ERROR then

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

660:
661: EXCEPTION
662: WHEN Purchase_Release_Incomplete THEN
663: IF l_debug_level > 0 THEN
664: oe_debug_pub.add('Exception Purchase Release Incomplete',1);
665: oe_debug_pub.add('Purchase Release activity is incomplete for line ID : '||l_drop_ship_line_rec.line_id,1);
666: END IF;
667: l_drop_ship_line_rec.return_status := FND_API.G_RET_STS_ERROR;
668: IF l_drop_ship_line_rec.result <> OE_Purchase_Release_PVT.G_RES_ONHOLD THEN

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

661: EXCEPTION
662: WHEN Purchase_Release_Incomplete THEN
663: IF l_debug_level > 0 THEN
664: oe_debug_pub.add('Exception Purchase Release Incomplete',1);
665: oe_debug_pub.add('Purchase Release activity is incomplete for line ID : '||l_drop_ship_line_rec.line_id,1);
666: END IF;
667: l_drop_ship_line_rec.return_status := FND_API.G_RET_STS_ERROR;
668: IF l_drop_ship_line_rec.result <> OE_Purchase_Release_PVT.G_RES_ONHOLD THEN
669: l_drop_ship_line_rec.result := OE_Purchase_Release_PVT.G_RES_INCOMPLETE;

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

676: l_drop_ship_line_rec.result := OE_Purchase_Release_PVT.G_RES_INCOMPLETE;
677: END IF;
678: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'Purchase_Release');
679: IF l_debug_level > 0 THEN
680: oe_debug_pub.add('AN EXPECTED ERROR RAISED..'||SQLERRM , 1 ) ;
681: END IF;
682: RAISE FND_API.G_EXC_ERROR; -- bug 4683857
683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
684: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'Purchase_Release');

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

683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
684: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'Purchase_Release');
685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
686: IF l_debug_level > 0 THEN
687: oe_debug_pub.add('AN UNEXPECTED ERROR RAISED..'||SQLERRM , 1 ) ;
688: END IF;
689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
690: WHEN OTHERS THEN
691: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

691: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
692: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME , 'Purchase_Release');
693: END IF;
694: IF l_debug_level > 0 THEN
695: oe_debug_pub.add('OTHER ERROR RAISED..'||SQLERRM , 1 ) ;
696: END IF;
697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
698: END;
699: <>

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

701: l_old_header_id := l_drop_ship_line_rec.header_id;
702: END LOOP;
703: x_drop_ship_tbl := l_x_drop_ship_tbl;
704: IF l_debug_level > 0 THEN
705: oe_debug_pub.add('Exit Purchase Release for line ID : '||l_drop_ship_line_rec.line_id , 1 ) ;
706: END IF;
707:
708: EXCEPTION
709:

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

756: l_revision_control_code NUMBER;
757: l_ou_org_id NUMBER;
758:
759: --
760: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
761: --
762: BEGIN
763:
764: IF l_debug_level > 0 THEN

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

761: --
762: BEGIN
763:
764: IF l_debug_level > 0 THEN
765: oe_debug_pub.add( 'BEFORE INSERTING RECORDS INTO PO REQUISITIONS INTERFACE ' , 1 ) ;
766: END IF;
767:
768: IF p_drop_ship_line_rec.project_id is not null AND
769: p_drop_ship_line_rec.project_id <> FND_API.G_MISS_NUM AND

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

831: WHEN NO_DATA_FOUND THEN
832: l_item_revision := NULL;
833: WHEN OTHERS THEN
834: IF l_debug_level > 0 THEN
835: oe_debug_pub.add( 'ERROR WHILE RETRIEVING ITEM REVISION INFO '||SQLERRM , 1 ) ;
836: END IF;
837: l_item_revision := NULL;
838: END;
839: END IF;

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

839: END IF;
840: END IF;
841:
842: IF l_debug_level > 0 THEN
843: oe_debug_pub.add( '------------INSERTING VALUES: ----------' , 1 ) ;
844: oe_debug_pub.add( 'DESTINATION_ORGANIZATION_ID: '||P_DROP_SHIP_LINE_REC.SHIP_FROM_ORG_ID , 1 ) ;
845: oe_debug_pub.add( 'DELIVER_TO_LOCATION_ID : '||P_DROP_SHIP_LINE_REC.DELIVER_TO_LOCATION_ID , 1 ) ;
846: oe_debug_pub.add( 'DELIVER_TO_REQUESTOR_ID : '||P_DROP_SHIP_LINE_REC.EMPLOYEE_ID , 1 ) ;
847: oe_debug_pub.add( 'NEED_BY_DATE : '||L_SCHEDULE_SHIP_DATE , 1 ) ;

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

840: END IF;
841:
842: IF l_debug_level > 0 THEN
843: oe_debug_pub.add( '------------INSERTING VALUES: ----------' , 1 ) ;
844: oe_debug_pub.add( 'DESTINATION_ORGANIZATION_ID: '||P_DROP_SHIP_LINE_REC.SHIP_FROM_ORG_ID , 1 ) ;
845: oe_debug_pub.add( 'DELIVER_TO_LOCATION_ID : '||P_DROP_SHIP_LINE_REC.DELIVER_TO_LOCATION_ID , 1 ) ;
846: oe_debug_pub.add( 'DELIVER_TO_REQUESTOR_ID : '||P_DROP_SHIP_LINE_REC.EMPLOYEE_ID , 1 ) ;
847: oe_debug_pub.add( 'NEED_BY_DATE : '||L_SCHEDULE_SHIP_DATE , 1 ) ;
848: oe_debug_pub.add( 'LAST_UPDATED_BY : '||P_USER_ID , 1 ) ;

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

841:
842: IF l_debug_level > 0 THEN
843: oe_debug_pub.add( '------------INSERTING VALUES: ----------' , 1 ) ;
844: oe_debug_pub.add( 'DESTINATION_ORGANIZATION_ID: '||P_DROP_SHIP_LINE_REC.SHIP_FROM_ORG_ID , 1 ) ;
845: oe_debug_pub.add( 'DELIVER_TO_LOCATION_ID : '||P_DROP_SHIP_LINE_REC.DELIVER_TO_LOCATION_ID , 1 ) ;
846: oe_debug_pub.add( 'DELIVER_TO_REQUESTOR_ID : '||P_DROP_SHIP_LINE_REC.EMPLOYEE_ID , 1 ) ;
847: oe_debug_pub.add( 'NEED_BY_DATE : '||L_SCHEDULE_SHIP_DATE , 1 ) ;
848: oe_debug_pub.add( 'LAST_UPDATED_BY : '||P_USER_ID , 1 ) ;
849: oe_debug_pub.add( 'LAST_UPDATE_LOGIN : '||P_LOGIN_ID , 1 ) ;

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

842: IF l_debug_level > 0 THEN
843: oe_debug_pub.add( '------------INSERTING VALUES: ----------' , 1 ) ;
844: oe_debug_pub.add( 'DESTINATION_ORGANIZATION_ID: '||P_DROP_SHIP_LINE_REC.SHIP_FROM_ORG_ID , 1 ) ;
845: oe_debug_pub.add( 'DELIVER_TO_LOCATION_ID : '||P_DROP_SHIP_LINE_REC.DELIVER_TO_LOCATION_ID , 1 ) ;
846: oe_debug_pub.add( 'DELIVER_TO_REQUESTOR_ID : '||P_DROP_SHIP_LINE_REC.EMPLOYEE_ID , 1 ) ;
847: oe_debug_pub.add( 'NEED_BY_DATE : '||L_SCHEDULE_SHIP_DATE , 1 ) ;
848: oe_debug_pub.add( 'LAST_UPDATED_BY : '||P_USER_ID , 1 ) ;
849: oe_debug_pub.add( 'LAST_UPDATE_LOGIN : '||P_LOGIN_ID , 1 ) ;
850: oe_debug_pub.add( 'DESTINATION_TYPE_CODE : '||L_DESTINATION_TYPE_CODE , 1 ) ;

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

843: oe_debug_pub.add( '------------INSERTING VALUES: ----------' , 1 ) ;
844: oe_debug_pub.add( 'DESTINATION_ORGANIZATION_ID: '||P_DROP_SHIP_LINE_REC.SHIP_FROM_ORG_ID , 1 ) ;
845: oe_debug_pub.add( 'DELIVER_TO_LOCATION_ID : '||P_DROP_SHIP_LINE_REC.DELIVER_TO_LOCATION_ID , 1 ) ;
846: oe_debug_pub.add( 'DELIVER_TO_REQUESTOR_ID : '||P_DROP_SHIP_LINE_REC.EMPLOYEE_ID , 1 ) ;
847: oe_debug_pub.add( 'NEED_BY_DATE : '||L_SCHEDULE_SHIP_DATE , 1 ) ;
848: oe_debug_pub.add( 'LAST_UPDATED_BY : '||P_USER_ID , 1 ) ;
849: oe_debug_pub.add( 'LAST_UPDATE_LOGIN : '||P_LOGIN_ID , 1 ) ;
850: oe_debug_pub.add( 'DESTINATION_TYPE_CODE : '||L_DESTINATION_TYPE_CODE , 1 ) ;
851: oe_debug_pub.add( 'QUANTITY : '||P_DROP_SHIP_LINE_REC.OPEN_QUANTITY , 1 ) ;

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

844: oe_debug_pub.add( 'DESTINATION_ORGANIZATION_ID: '||P_DROP_SHIP_LINE_REC.SHIP_FROM_ORG_ID , 1 ) ;
845: oe_debug_pub.add( 'DELIVER_TO_LOCATION_ID : '||P_DROP_SHIP_LINE_REC.DELIVER_TO_LOCATION_ID , 1 ) ;
846: oe_debug_pub.add( 'DELIVER_TO_REQUESTOR_ID : '||P_DROP_SHIP_LINE_REC.EMPLOYEE_ID , 1 ) ;
847: oe_debug_pub.add( 'NEED_BY_DATE : '||L_SCHEDULE_SHIP_DATE , 1 ) ;
848: oe_debug_pub.add( 'LAST_UPDATED_BY : '||P_USER_ID , 1 ) ;
849: oe_debug_pub.add( 'LAST_UPDATE_LOGIN : '||P_LOGIN_ID , 1 ) ;
850: oe_debug_pub.add( 'DESTINATION_TYPE_CODE : '||L_DESTINATION_TYPE_CODE , 1 ) ;
851: oe_debug_pub.add( 'QUANTITY : '||P_DROP_SHIP_LINE_REC.OPEN_QUANTITY , 1 ) ;
852: oe_debug_pub.add( 'AUTHORIZATION_STATUS : '||L_AUTHORIZATION_STATUS , 1 ) ;

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

845: oe_debug_pub.add( 'DELIVER_TO_LOCATION_ID : '||P_DROP_SHIP_LINE_REC.DELIVER_TO_LOCATION_ID , 1 ) ;
846: oe_debug_pub.add( 'DELIVER_TO_REQUESTOR_ID : '||P_DROP_SHIP_LINE_REC.EMPLOYEE_ID , 1 ) ;
847: oe_debug_pub.add( 'NEED_BY_DATE : '||L_SCHEDULE_SHIP_DATE , 1 ) ;
848: oe_debug_pub.add( 'LAST_UPDATED_BY : '||P_USER_ID , 1 ) ;
849: oe_debug_pub.add( 'LAST_UPDATE_LOGIN : '||P_LOGIN_ID , 1 ) ;
850: oe_debug_pub.add( 'DESTINATION_TYPE_CODE : '||L_DESTINATION_TYPE_CODE , 1 ) ;
851: oe_debug_pub.add( 'QUANTITY : '||P_DROP_SHIP_LINE_REC.OPEN_QUANTITY , 1 ) ;
852: oe_debug_pub.add( 'AUTHORIZATION_STATUS : '||L_AUTHORIZATION_STATUS , 1 ) ;
853: oe_debug_pub.add( 'PREPARER_ID : '||P_DROP_SHIP_LINE_REC.EMPLOYEE_ID , 1 ) ;

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

846: oe_debug_pub.add( 'DELIVER_TO_REQUESTOR_ID : '||P_DROP_SHIP_LINE_REC.EMPLOYEE_ID , 1 ) ;
847: oe_debug_pub.add( 'NEED_BY_DATE : '||L_SCHEDULE_SHIP_DATE , 1 ) ;
848: oe_debug_pub.add( 'LAST_UPDATED_BY : '||P_USER_ID , 1 ) ;
849: oe_debug_pub.add( 'LAST_UPDATE_LOGIN : '||P_LOGIN_ID , 1 ) ;
850: oe_debug_pub.add( 'DESTINATION_TYPE_CODE : '||L_DESTINATION_TYPE_CODE , 1 ) ;
851: oe_debug_pub.add( 'QUANTITY : '||P_DROP_SHIP_LINE_REC.OPEN_QUANTITY , 1 ) ;
852: oe_debug_pub.add( 'AUTHORIZATION_STATUS : '||L_AUTHORIZATION_STATUS , 1 ) ;
853: oe_debug_pub.add( 'PREPARER_ID : '||P_DROP_SHIP_LINE_REC.EMPLOYEE_ID , 1 ) ;
854: oe_debug_pub.add( 'ITEM_ID : '||P_DROP_SHIP_LINE_REC.INVENTORY_ITEM_ID , 1 ) ;

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

847: oe_debug_pub.add( 'NEED_BY_DATE : '||L_SCHEDULE_SHIP_DATE , 1 ) ;
848: oe_debug_pub.add( 'LAST_UPDATED_BY : '||P_USER_ID , 1 ) ;
849: oe_debug_pub.add( 'LAST_UPDATE_LOGIN : '||P_LOGIN_ID , 1 ) ;
850: oe_debug_pub.add( 'DESTINATION_TYPE_CODE : '||L_DESTINATION_TYPE_CODE , 1 ) ;
851: oe_debug_pub.add( 'QUANTITY : '||P_DROP_SHIP_LINE_REC.OPEN_QUANTITY , 1 ) ;
852: oe_debug_pub.add( 'AUTHORIZATION_STATUS : '||L_AUTHORIZATION_STATUS , 1 ) ;
853: oe_debug_pub.add( 'PREPARER_ID : '||P_DROP_SHIP_LINE_REC.EMPLOYEE_ID , 1 ) ;
854: oe_debug_pub.add( 'ITEM_ID : '||P_DROP_SHIP_LINE_REC.INVENTORY_ITEM_ID , 1 ) ;
855: oe_debug_pub.add( 'STOCK ENABLED FLAG : '||L_STOCK_ENABLED_FLAG , 1 ) ;

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

848: oe_debug_pub.add( 'LAST_UPDATED_BY : '||P_USER_ID , 1 ) ;
849: oe_debug_pub.add( 'LAST_UPDATE_LOGIN : '||P_LOGIN_ID , 1 ) ;
850: oe_debug_pub.add( 'DESTINATION_TYPE_CODE : '||L_DESTINATION_TYPE_CODE , 1 ) ;
851: oe_debug_pub.add( 'QUANTITY : '||P_DROP_SHIP_LINE_REC.OPEN_QUANTITY , 1 ) ;
852: oe_debug_pub.add( 'AUTHORIZATION_STATUS : '||L_AUTHORIZATION_STATUS , 1 ) ;
853: oe_debug_pub.add( 'PREPARER_ID : '||P_DROP_SHIP_LINE_REC.EMPLOYEE_ID , 1 ) ;
854: oe_debug_pub.add( 'ITEM_ID : '||P_DROP_SHIP_LINE_REC.INVENTORY_ITEM_ID , 1 ) ;
855: oe_debug_pub.add( 'STOCK ENABLED FLAG : '||L_STOCK_ENABLED_FLAG , 1 ) ;
856: oe_debug_pub.add( 'CHARGE_ACCOUNT_ID : '||P_DROP_SHIP_LINE_REC.CHARGE_ACCOUNT_ID , 1 ) ;

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

849: oe_debug_pub.add( 'LAST_UPDATE_LOGIN : '||P_LOGIN_ID , 1 ) ;
850: oe_debug_pub.add( 'DESTINATION_TYPE_CODE : '||L_DESTINATION_TYPE_CODE , 1 ) ;
851: oe_debug_pub.add( 'QUANTITY : '||P_DROP_SHIP_LINE_REC.OPEN_QUANTITY , 1 ) ;
852: oe_debug_pub.add( 'AUTHORIZATION_STATUS : '||L_AUTHORIZATION_STATUS , 1 ) ;
853: oe_debug_pub.add( 'PREPARER_ID : '||P_DROP_SHIP_LINE_REC.EMPLOYEE_ID , 1 ) ;
854: oe_debug_pub.add( 'ITEM_ID : '||P_DROP_SHIP_LINE_REC.INVENTORY_ITEM_ID , 1 ) ;
855: oe_debug_pub.add( 'STOCK ENABLED FLAG : '||L_STOCK_ENABLED_FLAG , 1 ) ;
856: oe_debug_pub.add( 'CHARGE_ACCOUNT_ID : '||P_DROP_SHIP_LINE_REC.CHARGE_ACCOUNT_ID , 1 ) ;
857: oe_debug_pub.add( 'INTERFACE_SOURCE_LINE_ID : '||P_DROP_SHIP_SOURCE_ID , 1 ) ;

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

850: oe_debug_pub.add( 'DESTINATION_TYPE_CODE : '||L_DESTINATION_TYPE_CODE , 1 ) ;
851: oe_debug_pub.add( 'QUANTITY : '||P_DROP_SHIP_LINE_REC.OPEN_QUANTITY , 1 ) ;
852: oe_debug_pub.add( 'AUTHORIZATION_STATUS : '||L_AUTHORIZATION_STATUS , 1 ) ;
853: oe_debug_pub.add( 'PREPARER_ID : '||P_DROP_SHIP_LINE_REC.EMPLOYEE_ID , 1 ) ;
854: oe_debug_pub.add( 'ITEM_ID : '||P_DROP_SHIP_LINE_REC.INVENTORY_ITEM_ID , 1 ) ;
855: oe_debug_pub.add( 'STOCK ENABLED FLAG : '||L_STOCK_ENABLED_FLAG , 1 ) ;
856: oe_debug_pub.add( 'CHARGE_ACCOUNT_ID : '||P_DROP_SHIP_LINE_REC.CHARGE_ACCOUNT_ID , 1 ) ;
857: oe_debug_pub.add( 'INTERFACE_SOURCE_LINE_ID : '||P_DROP_SHIP_SOURCE_ID , 1 ) ;
858: oe_debug_pub.add( 'PROJECT_ID : '||P_DROP_SHIP_LINE_REC.PROJECT_ID , 1 ) ;

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

851: oe_debug_pub.add( 'QUANTITY : '||P_DROP_SHIP_LINE_REC.OPEN_QUANTITY , 1 ) ;
852: oe_debug_pub.add( 'AUTHORIZATION_STATUS : '||L_AUTHORIZATION_STATUS , 1 ) ;
853: oe_debug_pub.add( 'PREPARER_ID : '||P_DROP_SHIP_LINE_REC.EMPLOYEE_ID , 1 ) ;
854: oe_debug_pub.add( 'ITEM_ID : '||P_DROP_SHIP_LINE_REC.INVENTORY_ITEM_ID , 1 ) ;
855: oe_debug_pub.add( 'STOCK ENABLED FLAG : '||L_STOCK_ENABLED_FLAG , 1 ) ;
856: oe_debug_pub.add( 'CHARGE_ACCOUNT_ID : '||P_DROP_SHIP_LINE_REC.CHARGE_ACCOUNT_ID , 1 ) ;
857: oe_debug_pub.add( 'INTERFACE_SOURCE_LINE_ID : '||P_DROP_SHIP_SOURCE_ID , 1 ) ;
858: oe_debug_pub.add( 'PROJECT_ID : '||P_DROP_SHIP_LINE_REC.PROJECT_ID , 1 ) ;
859: oe_debug_pub.add( 'TASK_ID : '||P_DROP_SHIP_LINE_REC.TASK_ID , 1 ) ;

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

852: oe_debug_pub.add( 'AUTHORIZATION_STATUS : '||L_AUTHORIZATION_STATUS , 1 ) ;
853: oe_debug_pub.add( 'PREPARER_ID : '||P_DROP_SHIP_LINE_REC.EMPLOYEE_ID , 1 ) ;
854: oe_debug_pub.add( 'ITEM_ID : '||P_DROP_SHIP_LINE_REC.INVENTORY_ITEM_ID , 1 ) ;
855: oe_debug_pub.add( 'STOCK ENABLED FLAG : '||L_STOCK_ENABLED_FLAG , 1 ) ;
856: oe_debug_pub.add( 'CHARGE_ACCOUNT_ID : '||P_DROP_SHIP_LINE_REC.CHARGE_ACCOUNT_ID , 1 ) ;
857: oe_debug_pub.add( 'INTERFACE_SOURCE_LINE_ID : '||P_DROP_SHIP_SOURCE_ID , 1 ) ;
858: oe_debug_pub.add( 'PROJECT_ID : '||P_DROP_SHIP_LINE_REC.PROJECT_ID , 1 ) ;
859: oe_debug_pub.add( 'TASK_ID : '||P_DROP_SHIP_LINE_REC.TASK_ID , 1 ) ;
860: oe_debug_pub.add( 'END_ITEM_UNIT_NUMBER : '||P_DROP_SHIP_LINE_REC.END_ITEM_UNIT_NUMBER , 1 ) ;

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

853: oe_debug_pub.add( 'PREPARER_ID : '||P_DROP_SHIP_LINE_REC.EMPLOYEE_ID , 1 ) ;
854: oe_debug_pub.add( 'ITEM_ID : '||P_DROP_SHIP_LINE_REC.INVENTORY_ITEM_ID , 1 ) ;
855: oe_debug_pub.add( 'STOCK ENABLED FLAG : '||L_STOCK_ENABLED_FLAG , 1 ) ;
856: oe_debug_pub.add( 'CHARGE_ACCOUNT_ID : '||P_DROP_SHIP_LINE_REC.CHARGE_ACCOUNT_ID , 1 ) ;
857: oe_debug_pub.add( 'INTERFACE_SOURCE_LINE_ID : '||P_DROP_SHIP_SOURCE_ID , 1 ) ;
858: oe_debug_pub.add( 'PROJECT_ID : '||P_DROP_SHIP_LINE_REC.PROJECT_ID , 1 ) ;
859: oe_debug_pub.add( 'TASK_ID : '||P_DROP_SHIP_LINE_REC.TASK_ID , 1 ) ;
860: oe_debug_pub.add( 'END_ITEM_UNIT_NUMBER : '||P_DROP_SHIP_LINE_REC.END_ITEM_UNIT_NUMBER , 1 ) ;
861: oe_debug_pub.add( 'PROJECT_ACCOUNTING_CONTEXT : '||L_PROJECT_ACCOUNTING_CONTEXT , 1 ) ;

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

854: oe_debug_pub.add( 'ITEM_ID : '||P_DROP_SHIP_LINE_REC.INVENTORY_ITEM_ID , 1 ) ;
855: oe_debug_pub.add( 'STOCK ENABLED FLAG : '||L_STOCK_ENABLED_FLAG , 1 ) ;
856: oe_debug_pub.add( 'CHARGE_ACCOUNT_ID : '||P_DROP_SHIP_LINE_REC.CHARGE_ACCOUNT_ID , 1 ) ;
857: oe_debug_pub.add( 'INTERFACE_SOURCE_LINE_ID : '||P_DROP_SHIP_SOURCE_ID , 1 ) ;
858: oe_debug_pub.add( 'PROJECT_ID : '||P_DROP_SHIP_LINE_REC.PROJECT_ID , 1 ) ;
859: oe_debug_pub.add( 'TASK_ID : '||P_DROP_SHIP_LINE_REC.TASK_ID , 1 ) ;
860: oe_debug_pub.add( 'END_ITEM_UNIT_NUMBER : '||P_DROP_SHIP_LINE_REC.END_ITEM_UNIT_NUMBER , 1 ) ;
861: oe_debug_pub.add( 'PROJECT_ACCOUNTING_CONTEXT : '||L_PROJECT_ACCOUNTING_CONTEXT , 1 ) ;
862: oe_debug_pub.add( 'UNIT LIST PRICE : '||TO_CHAR ( P_DROP_SHIP_LINE_REC.UNIT_LIST_PRICE ) , 1 ) ;

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

855: oe_debug_pub.add( 'STOCK ENABLED FLAG : '||L_STOCK_ENABLED_FLAG , 1 ) ;
856: oe_debug_pub.add( 'CHARGE_ACCOUNT_ID : '||P_DROP_SHIP_LINE_REC.CHARGE_ACCOUNT_ID , 1 ) ;
857: oe_debug_pub.add( 'INTERFACE_SOURCE_LINE_ID : '||P_DROP_SHIP_SOURCE_ID , 1 ) ;
858: oe_debug_pub.add( 'PROJECT_ID : '||P_DROP_SHIP_LINE_REC.PROJECT_ID , 1 ) ;
859: oe_debug_pub.add( 'TASK_ID : '||P_DROP_SHIP_LINE_REC.TASK_ID , 1 ) ;
860: oe_debug_pub.add( 'END_ITEM_UNIT_NUMBER : '||P_DROP_SHIP_LINE_REC.END_ITEM_UNIT_NUMBER , 1 ) ;
861: oe_debug_pub.add( 'PROJECT_ACCOUNTING_CONTEXT : '||L_PROJECT_ACCOUNTING_CONTEXT , 1 ) ;
862: oe_debug_pub.add( 'UNIT LIST PRICE : '||TO_CHAR ( P_DROP_SHIP_LINE_REC.UNIT_LIST_PRICE ) , 1 ) ;
863: oe_debug_pub.add( 'DESTINATION TYPE CODE : '||L_DESTINATION_TYPE_CODE , 1 ) ;

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

856: oe_debug_pub.add( 'CHARGE_ACCOUNT_ID : '||P_DROP_SHIP_LINE_REC.CHARGE_ACCOUNT_ID , 1 ) ;
857: oe_debug_pub.add( 'INTERFACE_SOURCE_LINE_ID : '||P_DROP_SHIP_SOURCE_ID , 1 ) ;
858: oe_debug_pub.add( 'PROJECT_ID : '||P_DROP_SHIP_LINE_REC.PROJECT_ID , 1 ) ;
859: oe_debug_pub.add( 'TASK_ID : '||P_DROP_SHIP_LINE_REC.TASK_ID , 1 ) ;
860: oe_debug_pub.add( 'END_ITEM_UNIT_NUMBER : '||P_DROP_SHIP_LINE_REC.END_ITEM_UNIT_NUMBER , 1 ) ;
861: oe_debug_pub.add( 'PROJECT_ACCOUNTING_CONTEXT : '||L_PROJECT_ACCOUNTING_CONTEXT , 1 ) ;
862: oe_debug_pub.add( 'UNIT LIST PRICE : '||TO_CHAR ( P_DROP_SHIP_LINE_REC.UNIT_LIST_PRICE ) , 1 ) ;
863: oe_debug_pub.add( 'DESTINATION TYPE CODE : '||L_DESTINATION_TYPE_CODE , 1 ) ;
864: oe_debug_pub.add( 'ITEM REVISION : '||L_ITEM_REVISION , 1 ) ;

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

857: oe_debug_pub.add( 'INTERFACE_SOURCE_LINE_ID : '||P_DROP_SHIP_SOURCE_ID , 1 ) ;
858: oe_debug_pub.add( 'PROJECT_ID : '||P_DROP_SHIP_LINE_REC.PROJECT_ID , 1 ) ;
859: oe_debug_pub.add( 'TASK_ID : '||P_DROP_SHIP_LINE_REC.TASK_ID , 1 ) ;
860: oe_debug_pub.add( 'END_ITEM_UNIT_NUMBER : '||P_DROP_SHIP_LINE_REC.END_ITEM_UNIT_NUMBER , 1 ) ;
861: oe_debug_pub.add( 'PROJECT_ACCOUNTING_CONTEXT : '||L_PROJECT_ACCOUNTING_CONTEXT , 1 ) ;
862: oe_debug_pub.add( 'UNIT LIST PRICE : '||TO_CHAR ( P_DROP_SHIP_LINE_REC.UNIT_LIST_PRICE ) , 1 ) ;
863: oe_debug_pub.add( 'DESTINATION TYPE CODE : '||L_DESTINATION_TYPE_CODE , 1 ) ;
864: oe_debug_pub.add( 'ITEM REVISION : '||L_ITEM_REVISION , 1 ) ;
865: END IF;

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

858: oe_debug_pub.add( 'PROJECT_ID : '||P_DROP_SHIP_LINE_REC.PROJECT_ID , 1 ) ;
859: oe_debug_pub.add( 'TASK_ID : '||P_DROP_SHIP_LINE_REC.TASK_ID , 1 ) ;
860: oe_debug_pub.add( 'END_ITEM_UNIT_NUMBER : '||P_DROP_SHIP_LINE_REC.END_ITEM_UNIT_NUMBER , 1 ) ;
861: oe_debug_pub.add( 'PROJECT_ACCOUNTING_CONTEXT : '||L_PROJECT_ACCOUNTING_CONTEXT , 1 ) ;
862: oe_debug_pub.add( 'UNIT LIST PRICE : '||TO_CHAR ( P_DROP_SHIP_LINE_REC.UNIT_LIST_PRICE ) , 1 ) ;
863: oe_debug_pub.add( 'DESTINATION TYPE CODE : '||L_DESTINATION_TYPE_CODE , 1 ) ;
864: oe_debug_pub.add( 'ITEM REVISION : '||L_ITEM_REVISION , 1 ) ;
865: END IF;
866:

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

859: oe_debug_pub.add( 'TASK_ID : '||P_DROP_SHIP_LINE_REC.TASK_ID , 1 ) ;
860: oe_debug_pub.add( 'END_ITEM_UNIT_NUMBER : '||P_DROP_SHIP_LINE_REC.END_ITEM_UNIT_NUMBER , 1 ) ;
861: oe_debug_pub.add( 'PROJECT_ACCOUNTING_CONTEXT : '||L_PROJECT_ACCOUNTING_CONTEXT , 1 ) ;
862: oe_debug_pub.add( 'UNIT LIST PRICE : '||TO_CHAR ( P_DROP_SHIP_LINE_REC.UNIT_LIST_PRICE ) , 1 ) ;
863: oe_debug_pub.add( 'DESTINATION TYPE CODE : '||L_DESTINATION_TYPE_CODE , 1 ) ;
864: oe_debug_pub.add( 'ITEM REVISION : '||L_ITEM_REVISION , 1 ) ;
865: END IF;
866:
867: IF l_debug_level > 0 THEN

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

860: oe_debug_pub.add( 'END_ITEM_UNIT_NUMBER : '||P_DROP_SHIP_LINE_REC.END_ITEM_UNIT_NUMBER , 1 ) ;
861: oe_debug_pub.add( 'PROJECT_ACCOUNTING_CONTEXT : '||L_PROJECT_ACCOUNTING_CONTEXT , 1 ) ;
862: oe_debug_pub.add( 'UNIT LIST PRICE : '||TO_CHAR ( P_DROP_SHIP_LINE_REC.UNIT_LIST_PRICE ) , 1 ) ;
863: oe_debug_pub.add( 'DESTINATION TYPE CODE : '||L_DESTINATION_TYPE_CODE , 1 ) ;
864: oe_debug_pub.add( 'ITEM REVISION : '||L_ITEM_REVISION , 1 ) ;
865: END IF;
866:
867: IF l_debug_level > 0 THEN
868: oe_debug_pub.add( '----------------------' , 1 ) ;

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

864: oe_debug_pub.add( 'ITEM REVISION : '||L_ITEM_REVISION , 1 ) ;
865: END IF;
866:
867: IF l_debug_level > 0 THEN
868: oe_debug_pub.add( '----------------------' , 1 ) ;
869: END IF;
870:
871: -- Fix for bug2058542
872: l_source_code :=fnd_profile.value('ONT_SOURCE_CODE');

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

956: p_drop_ship_line_rec.item_description,
957: l_ou_org_id);
958:
959: IF l_debug_level > 0 THEN
960: oe_debug_pub.add( 'END OF INSERT_INTO_PO_REQ_INTERFACE' , 1 ) ;
961: END IF;
962: x_return_status := FND_API.G_RET_STS_SUCCESS;
963:
964: EXCEPTION

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

994: ,p_drop_ship_source_id IN NUMBER
995: )
996: IS
997: --
998: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
999: --
1000: BEGIN
1001:
1002: IF l_debug_level > 0 THEN

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

999: --
1000: BEGIN
1001:
1002: IF l_debug_level > 0 THEN
1003: oe_debug_pub.add( 'START OF INSERT_DROP_SHIP_SOURCE' , 1 ) ;
1004: END IF;
1005:
1006:
1007: INSERT INTO oe_drop_ship_sources

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

1029: p_org_id
1030: );
1031:
1032: IF l_debug_level > 0 THEN
1033: oe_debug_pub.add( 'END OF INSERT_DROP_SHIP_SOURCE' , 1 ) ;
1034: END IF;
1035:
1036: x_return_status := FND_API.G_RET_STS_SUCCESS;
1037:

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

1062:
1063: IS
1064: l_drop_ship_line_rec Drop_Ship_Line_Rec_Type;
1065: --
1066: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1067: --
1068: BEGIN
1069: l_drop_ship_line_rec := p_drop_ship_line_rec;
1070:

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

1147: l_uom2_code VARCHAR2(25);
1148: l_preferred_grade VARCHAR2(150);
1149:
1150: --
1151: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1152: --
1153: BEGIN
1154: IF l_debug_level > 0 THEN
1155: oe_debug_pub.add( 'ENTERING GET_ELIGIBLE_LINES' , 1 ) ;

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

1151: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1152: --
1153: BEGIN
1154: IF l_debug_level > 0 THEN
1155: oe_debug_pub.add( 'ENTERING GET_ELIGIBLE_LINES' , 1 ) ;
1156: END IF;
1157: l_line_id := p_line_id;
1158: l_line_count := 0;
1159: OPEN eligible_lines_cursor(p_line_id => l_line_id);

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

1196: END LOOP;
1197: CLOSE eligible_lines_cursor;
1198: x_drop_ship_tbl := l_drop_ship_tbl;
1199: IF l_debug_level > 0 THEN
1200: oe_debug_pub.add( 'EXITING GET_ELIGIBLE_LINES' , 1 ) ;
1201: END IF;
1202:
1203: EXCEPTION
1204:

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

1305: --l_po_status VARCHAR2(4100);
1306: l_process_flag VARCHAR2(30);
1307: l_line_num VARCHAR2(30);
1308:
1309: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1310: l_source_code VARCHAR2(30) := FND_PROFILE.Value('ONT_SOURCE_CODE');
1311: --bug 4411054
1312: l_po_status_rec PO_STATUS_REC_TYPE;
1313: l_autorization_status VARCHAR2(30);

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

1314:
1315: BEGIN
1316:
1317: IF l_debug_level > 0 THEN
1318: OE_DEBUG_PUB.Add('Entering Process_DropShip_CMS_Requests...', 2);
1319: OE_DEBUG_PUB.Add('No of Records:'|| p_request_tbl.count , 2);
1320: END IF;
1321:
1322: I := p_request_tbl.FIRST;

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

1315: BEGIN
1316:
1317: IF l_debug_level > 0 THEN
1318: OE_DEBUG_PUB.Add('Entering Process_DropShip_CMS_Requests...', 2);
1319: OE_DEBUG_PUB.Add('No of Records:'|| p_request_tbl.count , 2);
1320: END IF;
1321:
1322: I := p_request_tbl.FIRST;
1323:

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

1338: l_ds_old_ship_to_location_id := NULL;
1339: l_ds_new_ship_to_location_id := NULL;
1340: l_ds_ship_to_location_id := NULL;
1341:
1342: OE_DEBUG_PUB.Add('After Initializing Local Variable', 2);
1343:
1344: SELECT requisition_header_id,po_header_id,
1345: requisition_line_id,po_line_id,
1346: line_location_id,po_release_id,drop_ship_source_id

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

1358: l_po_created := 'Y';
1359: END IF;
1360:
1361: IF l_debug_level > 0 THEN
1362: OE_DEBUG_PUB.Add('Line Id:'||p_request_tbl(I).entity_id,2);
1363: OE_DEBUG_PUB.Add('Req Created: '||l_req_created,2);
1364: OE_DEBUG_PUB.Add('PO Created: '||l_po_created,2);
1365: END IF;
1366:

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

1359: END IF;
1360:
1361: IF l_debug_level > 0 THEN
1362: OE_DEBUG_PUB.Add('Line Id:'||p_request_tbl(I).entity_id,2);
1363: OE_DEBUG_PUB.Add('Req Created: '||l_req_created,2);
1364: OE_DEBUG_PUB.Add('PO Created: '||l_po_created,2);
1365: END IF;
1366:
1367: IF l_req_created = 'Y' THEN

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

1360:
1361: IF l_debug_level > 0 THEN
1362: OE_DEBUG_PUB.Add('Line Id:'||p_request_tbl(I).entity_id,2);
1363: OE_DEBUG_PUB.Add('Req Created: '||l_req_created,2);
1364: OE_DEBUG_PUB.Add('PO Created: '||l_po_created,2);
1365: END IF;
1366:
1367: IF l_req_created = 'Y' THEN
1368: -- 3579735

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

1365: END IF;
1366:
1367: IF l_req_created = 'Y' THEN
1368: -- 3579735
1369: oe_debug_pub.add(' Extending req hdr ', 1);
1370: l_req_header_id.extend;
1371: l_req_line_id.extend;
1372: l_po_header_id.extend;
1373: l_po_release_id.extend;

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

1408: */
1409: END IF;
1410:
1411: IF l_debug_level > 0 THEN
1412: OE_DEBUG_PUB.Add('Compare the Old and New CMS Parameters...', 2);
1413: OE_DEBUG_PUB.Add('Operation Performed:'||p_request_tbl(I).param15, 2);
1414: END IF;
1415:
1416: IF p_request_tbl(I).param15 = 'UPDATE' THEN

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

1409: END IF;
1410:
1411: IF l_debug_level > 0 THEN
1412: OE_DEBUG_PUB.Add('Compare the Old and New CMS Parameters...', 2);
1413: OE_DEBUG_PUB.Add('Operation Performed:'||p_request_tbl(I).param15, 2);
1414: END IF;
1415:
1416: IF p_request_tbl(I).param15 = 'UPDATE' THEN
1417:

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

1432: END IF;
1433:
1434:
1435: IF l_debug_level > 0 THEN
1436: OE_DEBUG_PUB.Add('----Ordered Quantity Changed----', 2);
1437: OE_DEBUG_PUB.Add('Old :'||p_request_tbl(I).param1||
1438: ' New :'||p_request_tbl(I).param8,1);
1439: OE_DEBUG_PUB.Add('--------------------------------', 2);
1440: END IF;

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

1433:
1434:
1435: IF l_debug_level > 0 THEN
1436: OE_DEBUG_PUB.Add('----Ordered Quantity Changed----', 2);
1437: OE_DEBUG_PUB.Add('Old :'||p_request_tbl(I).param1||
1438: ' New :'||p_request_tbl(I).param8,1);
1439: OE_DEBUG_PUB.Add('--------------------------------', 2);
1440: END IF;
1441:

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

1435: IF l_debug_level > 0 THEN
1436: OE_DEBUG_PUB.Add('----Ordered Quantity Changed----', 2);
1437: OE_DEBUG_PUB.Add('Old :'||p_request_tbl(I).param1||
1438: ' New :'||p_request_tbl(I).param8,1);
1439: OE_DEBUG_PUB.Add('--------------------------------', 2);
1440: END IF;
1441:
1442: END IF;
1443:

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

1448: l_ds_ordered_quantity_uom := p_request_tbl(I).param9;
1449: END IF;
1450:
1451: IF l_debug_level > 0 THEN
1452: OE_DEBUG_PUB.Add('----Ordered Quantity UOM Changed----', 2);
1453: OE_DEBUG_PUB.Add('Old:'||p_request_tbl(I).param2||
1454: 'New:'||p_request_tbl(I).param9,1);
1455: OE_DEBUG_PUB.Add('--------------------------------', 2);
1456: END IF;

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

1449: END IF;
1450:
1451: IF l_debug_level > 0 THEN
1452: OE_DEBUG_PUB.Add('----Ordered Quantity UOM Changed----', 2);
1453: OE_DEBUG_PUB.Add('Old:'||p_request_tbl(I).param2||
1454: 'New:'||p_request_tbl(I).param9,1);
1455: OE_DEBUG_PUB.Add('--------------------------------', 2);
1456: END IF;
1457:

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

1451: IF l_debug_level > 0 THEN
1452: OE_DEBUG_PUB.Add('----Ordered Quantity UOM Changed----', 2);
1453: OE_DEBUG_PUB.Add('Old:'||p_request_tbl(I).param2||
1454: 'New:'||p_request_tbl(I).param9,1);
1455: OE_DEBUG_PUB.Add('--------------------------------', 2);
1456: END IF;
1457:
1458:
1459: END IF;

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

1484: END IF;
1485:
1486:
1487: IF l_debug_level > 0 THEN
1488: OE_DEBUG_PUB.Add('----Ship To Location Changed----', 2);
1489: OE_DEBUG_PUB.Add('Old:'||l_ds_old_ship_to_location_id||
1490: ' New:'||l_ds_new_ship_to_location_id,1);
1491: OE_DEBUG_PUB.Add('--------------------------------', 2);
1492: END IF;

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

1485:
1486:
1487: IF l_debug_level > 0 THEN
1488: OE_DEBUG_PUB.Add('----Ship To Location Changed----', 2);
1489: OE_DEBUG_PUB.Add('Old:'||l_ds_old_ship_to_location_id||
1490: ' New:'||l_ds_new_ship_to_location_id,1);
1491: OE_DEBUG_PUB.Add('--------------------------------', 2);
1492: END IF;
1493:

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

1487: IF l_debug_level > 0 THEN
1488: OE_DEBUG_PUB.Add('----Ship To Location Changed----', 2);
1489: OE_DEBUG_PUB.Add('Old:'||l_ds_old_ship_to_location_id||
1490: ' New:'||l_ds_new_ship_to_location_id,1);
1491: OE_DEBUG_PUB.Add('--------------------------------', 2);
1492: END IF;
1493:
1494: END IF;
1495:

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

1512: END IF;
1513:
1514:
1515: IF l_debug_level > 0 THEN
1516: OE_DEBUG_PUB.Add('----Secondary Quantity Changed----', 2);
1517: OE_DEBUG_PUB.Add('Old:'||p_request_tbl(I).param4||
1518: ' New:'||p_request_tbl(I).param11,1);
1519: OE_DEBUG_PUB.Add('--------------------------------', 2);
1520: END IF;

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

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

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

1515: IF l_debug_level > 0 THEN
1516: OE_DEBUG_PUB.Add('----Secondary Quantity Changed----', 2);
1517: OE_DEBUG_PUB.Add('Old:'||p_request_tbl(I).param4||
1518: ' New:'||p_request_tbl(I).param11,1);
1519: OE_DEBUG_PUB.Add('--------------------------------', 2);
1520: END IF;
1521:
1522: END IF;
1523:

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

1529: l_ds_ordered_quantity_uom2 := p_request_tbl(I).param12;
1530: END IF;
1531:
1532: IF l_debug_level > 0 THEN
1533: OE_DEBUG_PUB.Add('----Secondary Quantity UOM Changed----', 2);
1534: OE_DEBUG_PUB.Add('Old:'||p_request_tbl(I).param5||
1535: 'New:'||p_request_tbl(I).param12,1);
1536: OE_DEBUG_PUB.Add('--------------------------------------', 2);
1537: END IF;

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

1530: END IF;
1531:
1532: IF l_debug_level > 0 THEN
1533: OE_DEBUG_PUB.Add('----Secondary Quantity UOM Changed----', 2);
1534: OE_DEBUG_PUB.Add('Old:'||p_request_tbl(I).param5||
1535: 'New:'||p_request_tbl(I).param12,1);
1536: OE_DEBUG_PUB.Add('--------------------------------------', 2);
1537: END IF;
1538:

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

1532: IF l_debug_level > 0 THEN
1533: OE_DEBUG_PUB.Add('----Secondary Quantity UOM Changed----', 2);
1534: OE_DEBUG_PUB.Add('Old:'||p_request_tbl(I).param5||
1535: 'New:'||p_request_tbl(I).param12,1);
1536: OE_DEBUG_PUB.Add('--------------------------------------', 2);
1537: END IF;
1538:
1539: END IF;
1540:

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

1545: l_ds_preferred_grade := p_request_tbl(I).param13;
1546: END IF;
1547:
1548: IF l_debug_level > 0 THEN
1549: OE_DEBUG_PUB.Add('----Preferred Grade Changed----', 2);
1550: OE_DEBUG_PUB.Add('Old:'||p_request_tbl(I).param6||
1551: 'New:'||p_request_tbl(I).param13,1);
1552: OE_DEBUG_PUB.Add('--------------------------------', 2);
1553: END IF;

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

1546: END IF;
1547:
1548: IF l_debug_level > 0 THEN
1549: OE_DEBUG_PUB.Add('----Preferred Grade Changed----', 2);
1550: OE_DEBUG_PUB.Add('Old:'||p_request_tbl(I).param6||
1551: 'New:'||p_request_tbl(I).param13,1);
1552: OE_DEBUG_PUB.Add('--------------------------------', 2);
1553: END IF;
1554:

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

1548: IF l_debug_level > 0 THEN
1549: OE_DEBUG_PUB.Add('----Preferred Grade Changed----', 2);
1550: OE_DEBUG_PUB.Add('Old:'||p_request_tbl(I).param6||
1551: 'New:'||p_request_tbl(I).param13,1);
1552: OE_DEBUG_PUB.Add('--------------------------------', 2);
1553: END IF;
1554:
1555:
1556: END IF;

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

1583:
1584: END IF;
1585:
1586: IF l_debug_level > 0 THEN
1587: OE_DEBUG_PUB.Add('----Schedule Ship Date Changed----', 2);
1588: /*****Begin changes for bug#6918700*********/
1589: /* OE_DEBUG_PUB.Add('Old:'||p_request_tbl(I).param7||
1590: 'New:'||p_request_tbl(I).param14,1);
1591: */

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

1585:
1586: IF l_debug_level > 0 THEN
1587: OE_DEBUG_PUB.Add('----Schedule Ship Date Changed----', 2);
1588: /*****Begin changes for bug#6918700*********/
1589: /* OE_DEBUG_PUB.Add('Old:'||p_request_tbl(I).param7||
1590: 'New:'||p_request_tbl(I).param14,1);
1591: */
1592: OE_DEBUG_PUB.Add('Old:'||p_request_tbl(I).date_param1||
1593: 'New:'||p_request_tbl(I).date_param2,1);

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

1588: /*****Begin changes for bug#6918700*********/
1589: /* OE_DEBUG_PUB.Add('Old:'||p_request_tbl(I).param7||
1590: 'New:'||p_request_tbl(I).param14,1);
1591: */
1592: OE_DEBUG_PUB.Add('Old:'||p_request_tbl(I).date_param1||
1593: 'New:'||p_request_tbl(I).date_param2,1);
1594: /*****End changes for bug#6918700*********/
1595: OE_DEBUG_PUB.Add('--------------------------------', 2);
1596: END IF;

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

1591: */
1592: OE_DEBUG_PUB.Add('Old:'||p_request_tbl(I).date_param1||
1593: 'New:'||p_request_tbl(I).date_param2,1);
1594: /*****End changes for bug#6918700*********/
1595: OE_DEBUG_PUB.Add('--------------------------------', 2);
1596: END IF;
1597:
1598: END IF;
1599:

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

1606: (x_po_header_id => l_pur_header_id
1607: ));
1608:
1609: IF l_debug_level > 0 THEN
1610: OE_DEBUG_PUB.Add('Check PO Status : '|| l_po_status, 2);
1611: END IF;
1612: */
1613: PO_DOCUMENT_CHECKS_GRP.PO_STATUS_CHECK
1614: (p_api_version => 1.0

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

1621: IF(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1622: l_autorization_status := l_po_status_rec.authorization_status(1);
1623:
1624: IF l_debug_level > 0 THEN
1625: OE_DEBUG_PUB.Add('Sucess call from PO_DOCUMENT_CHECKS_GRP.po_status_check',2);
1626: OE_DEBUG_PUB.Add('Check PO Status : '|| l_autorization_status, 2);
1627: END IF;
1628: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1622: l_autorization_status := l_po_status_rec.authorization_status(1);
1623:
1624: IF l_debug_level > 0 THEN
1625: OE_DEBUG_PUB.Add('Sucess call from PO_DOCUMENT_CHECKS_GRP.po_status_check',2);
1626: OE_DEBUG_PUB.Add('Check PO Status : '|| l_autorization_status, 2);
1627: END IF;
1628: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1630: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

1642: l_sales_order_updated_date(l_count) := sysdate;
1643: l_changed_flag := 'Y';
1644:
1645: IF l_debug_level > 0 THEN
1646: OE_DEBUG_PUB.Add('----Ref Data Elem Changed----', 2);
1647: OE_DEBUG_PUB.Add('Req:'||l_req_created||'PO:'||l_po_created||
1648: 'Release:'||l_pur_release_id, 2);
1649: OE_DEBUG_PUB.Add('--------------------------------', 2);
1650: END IF;

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

1643: l_changed_flag := 'Y';
1644:
1645: IF l_debug_level > 0 THEN
1646: OE_DEBUG_PUB.Add('----Ref Data Elem Changed----', 2);
1647: OE_DEBUG_PUB.Add('Req:'||l_req_created||'PO:'||l_po_created||
1648: 'Release:'||l_pur_release_id, 2);
1649: OE_DEBUG_PUB.Add('--------------------------------', 2);
1650: END IF;
1651:

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

1645: IF l_debug_level > 0 THEN
1646: OE_DEBUG_PUB.Add('----Ref Data Elem Changed----', 2);
1647: OE_DEBUG_PUB.Add('Req:'||l_req_created||'PO:'||l_po_created||
1648: 'Release:'||l_pur_release_id, 2);
1649: OE_DEBUG_PUB.Add('--------------------------------', 2);
1650: END IF;
1651:
1652: END IF;
1653:

Line 1669: OE_DEBUG_PUB.Add('After Querying: '||l_drop_ship_id, 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 Querying: '||l_drop_ship_id, 2);
1670: END IF;
1671:
1672: SELECT RTRIM(line_number || '.' ||
1673: shipment_number || '.' ||

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

1700: WHERE interface_source_line_id = l_drop_ship_id
1701: AND interface_source_code = l_source_code;
1702:
1703: IF l_debug_level > 0 THEN
1704: OE_DEBUG_PUB.Add('After Updating PO_Requisitions_Interface_All..', 2);
1705: END IF;
1706:
1707: ELSIF l_process_flag = 'ERROR' THEN
1708: FND_MESSAGE.SET_NAME('ONT','ONT_DS_LINE_IN_ERROR');

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

1725: END IF; -- Update
1726:
1727: IF p_request_tbl(I).param15 = 'CANCEL' THEN
1728:
1729: oe_debug_pub.add('1 extending can req hdr ', 1);
1730: -- 3579735
1731: --l_can_req_header_id.extend(l_can_count);
1732: --l_can_req_line_id.extend(l_can_count);
1733: --l_can_po_header_id.extend(l_can_count);

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

1753: EXCEPTION
1754: WHEN NO_DATA_FOUND THEN
1755: -- #5262032, no data found when the req interface records deleted
1756: IF l_debug_level > 0 THEN
1757: OE_DEBUG_PUB.add('No po req interface records for this line',1);
1758: END IF;
1759: END;
1760:
1761:

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

1759: END;
1760:
1761:
1762: IF l_debug_level > 0 THEN
1763: OE_DEBUG_PUB.Add('After Querying,dropship_id: '||l_drop_ship_id||' ,process_flag:'||l_process_flag, 2);
1764: END IF;
1765:
1766: Begin
1767: SELECT RTRIM(line_number || '.' ||

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

1787: WHERE interface_source_line_id = l_drop_ship_id
1788: AND interface_source_code = l_source_code;
1789:
1790: IF l_debug_level > 0 THEN
1791: OE_DEBUG_PUB.Add('After Deleting: '||l_drop_ship_id, 2);
1792: END IF;
1793:
1794: ELSIF l_process_flag = 'ERROR' THEN
1795: FND_MESSAGE.SET_NAME('ONT','ONT_DS_LINE_IN_ERROR');

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

1802: RAISE FND_API.G_EXC_ERROR;
1803: END IF;
1804:
1805: ELSE
1806: oe_debug_pub.add('assigning values to cancel records', 1);
1807: l_can_req_header_id(l_can_count) := l_requisition_header_id;
1808: l_can_req_line_id(l_can_count) := l_requisition_line_id;
1809: l_can_po_header_id(l_can_count) := l_pur_header_id;
1810: l_can_po_line_id(l_can_count) := l_pur_line_id;

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

1816:
1817: END IF;
1818:
1819: ELSE
1820: oe_debug_pub.add('not a dropship request ', 1);
1821: END IF; -- Dropship CMS
1822:
1823:
1824: I := p_request_tbl.NEXT(I);

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

1827:
1828: IF l_count > 1 THEN
1829:
1830: IF l_debug_level > 0 THEN
1831: OE_DEBUG_PUB.Add('Before Calling Update_Req_PO...',2) ;
1832: OE_DEBUG_PUB.Add('No of Req Records PO: '||to_char(l_count -1),2) ;
1833: END IF;
1834: --
1835:

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

1828: IF l_count > 1 THEN
1829:
1830: IF l_debug_level > 0 THEN
1831: OE_DEBUG_PUB.Add('Before Calling Update_Req_PO...',2) ;
1832: OE_DEBUG_PUB.Add('No of Req Records PO: '||to_char(l_count -1),2) ;
1833: END IF;
1834: --
1835:
1836: PO_OM_INTEGRATION_GRP.Update_Req_PO

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

1852: ,x_msg_data => l_msg_data
1853: );
1854:
1855: IF l_debug_level > 0 THEN
1856: OE_DEBUG_PUB.Add(' After Calling update_req_po...'||l_return_status,2) ;
1857: OE_DEBUG_PUB.Add(' Message Count:'||l_msg_count,2) ;
1858: OE_DEBUG_PUB.Add(' Message Data:'||l_msg_data,2) ;
1859: END IF;
1860:

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

1853: );
1854:
1855: IF l_debug_level > 0 THEN
1856: OE_DEBUG_PUB.Add(' After Calling update_req_po...'||l_return_status,2) ;
1857: OE_DEBUG_PUB.Add(' Message Count:'||l_msg_count,2) ;
1858: OE_DEBUG_PUB.Add(' Message Data:'||l_msg_data,2) ;
1859: END IF;
1860:
1861: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

1854:
1855: IF l_debug_level > 0 THEN
1856: OE_DEBUG_PUB.Add(' After Calling update_req_po...'||l_return_status,2) ;
1857: OE_DEBUG_PUB.Add(' Message Count:'||l_msg_count,2) ;
1858: OE_DEBUG_PUB.Add(' Message Data:'||l_msg_data,2) ;
1859: END IF;
1860:
1861: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1862: OE_MSG_PUB.Transfer_Msg_Stack;

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

1868: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
1869: FOR I in 1..l_msg_count LOOP
1870: l_msg_data := OE_MSG_PUB.Get(I,'F');
1871: IF l_debug_level > 0 THEN
1872: oe_debug_pub.add('Messages from Update PO;'||l_msg_data,1 ) ;
1873: END IF;
1874: END LOOP;
1875:
1876: RAISE FND_API.G_EXC_ERROR;

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

1880:
1881: IF l_can_count > 1 THEN
1882:
1883: IF l_debug_level > 0 THEN
1884: OE_DEBUG_PUB.Add('Before Calling Cancel_Req_PO...',2) ;
1885: OE_DEBUG_PUB.Add
1886: ('No of Records for PO Cancellation...'||l_can_count ,2) ;
1887: END IF;
1888:

Line 1885: OE_DEBUG_PUB.Add

1881: IF l_can_count > 1 THEN
1882:
1883: IF l_debug_level > 0 THEN
1884: OE_DEBUG_PUB.Add('Before Calling Cancel_Req_PO...',2) ;
1885: OE_DEBUG_PUB.Add
1886: ('No of Records for PO Cancellation...'||l_can_count ,2) ;
1887: END IF;
1888:
1889: FOR I in l_can_req_header_id.FIRST..l_can_req_header_id.LAST

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

1887: END IF;
1888:
1889: FOR I in l_can_req_header_id.FIRST..l_can_req_header_id.LAST
1890: LOOP
1891: oe_debug_pub.add('req hdr '|| l_can_req_header_id(I), 1);
1892:
1893: -- added for bug 3946163
1894: -- The p_po_line_id shall be passed as NULL for all the lines that are
1895: -- attached to a blanket purchase agreement

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

1912: );
1913:
1914:
1915: IF l_debug_level > 0 THEN
1916: OE_DEBUG_PUB.Add('After Calling Cancel_Req_PO: '||l_return_status,2) ;
1917: OE_DEBUG_PUB.Add(' Message Count:'||l_msg_count,2) ;
1918: OE_DEBUG_PUB.Add(' Message Data:'||l_msg_data,2) ;
1919: END IF;
1920:

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

1913:
1914:
1915: IF l_debug_level > 0 THEN
1916: OE_DEBUG_PUB.Add('After Calling Cancel_Req_PO: '||l_return_status,2) ;
1917: OE_DEBUG_PUB.Add(' Message Count:'||l_msg_count,2) ;
1918: OE_DEBUG_PUB.Add(' Message Data:'||l_msg_data,2) ;
1919: END IF;
1920:
1921: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

1914:
1915: IF l_debug_level > 0 THEN
1916: OE_DEBUG_PUB.Add('After Calling Cancel_Req_PO: '||l_return_status,2) ;
1917: OE_DEBUG_PUB.Add(' Message Count:'||l_msg_count,2) ;
1918: OE_DEBUG_PUB.Add(' Message Data:'||l_msg_data,2) ;
1919: END IF;
1920:
1921: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1922: OE_MSG_PUB.Transfer_Msg_Stack;

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

1928: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
1929: FOR I in 1..l_msg_count LOOP
1930: l_msg_data := OE_MSG_PUB.Get(I,'F');
1931: IF l_debug_level > 0 THEN
1932: oe_debug_pub.add('Messages from Cancel PO;'||l_msg_data,1 ) ;
1933: END IF;
1934: END LOOP;
1935:
1936: IF l_debug_level > 0 THEN

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

1933: END IF;
1934: END LOOP;
1935:
1936: IF l_debug_level > 0 THEN
1937: OE_DEBUG_PUB.Add('Errors from Cancel_req_po: '||l_msg_data,2) ;
1938: END IF;
1939:
1940: -- bug 5358405
1941: FND_MESSAGE.set_name('ONT','OE_CANCEL_FAILED');

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

1960: END LOOP;
1961: END IF;
1962:
1963: IF l_debug_level > 0 then
1964: OE_DEBUG_PUB.Add('Exiting Process_DropShip_CMS_Requests..:'||x_return_status);
1965: END IF;
1966:
1967: x_return_status := l_return_status;
1968:

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

1968:
1969: EXCEPTION
1970: WHEN FND_API.G_EXC_ERROR THEN
1971: IF l_debug_level > 0 THEN
1972: OE_DEBUG_PUB.Add('Expected Error in Process_DropShip_CMS_Requests...',4);
1973: END IF;
1974:
1975: x_return_status := FND_API.G_RET_STS_ERROR;
1976: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1974:
1975: x_return_status := FND_API.G_RET_STS_ERROR;
1976: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1977: IF l_debug_level > 0 THEN
1978: OE_DEBUG_PUB.Add('UnExpected Error in Process_DropShip_CMS_Requests...'||sqlerrm,4);
1979: END IF;
1980:
1981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1982: WHEN OTHERS THEN