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

Line 26: OE_DEBUG_PUB.Add('Entering OE_CNCL_VALIDATE_LINE.Check_Book_Reqd_Attributes',1);

22: l_line_type_rec OE_Order_Cache.Line_Type_Rec_Type;
23: l_item_type_code VARCHAR2(30);
24: BEGIN
25:
26: OE_DEBUG_PUB.Add('Entering OE_CNCL_VALIDATE_LINE.Check_Book_Reqd_Attributes',1);
27: -- Check for fields required on a booked order line
28:
29: IF p_line_rec.sold_to_org_id IS NULL THEN
30: x_return_status := FND_API.G_RET_STS_ERROR;

Line 186: oe_debug_pub.add('calc tax flag 2 : ' || l_line_type_rec.calculate_tax_flag );

182: -- (i.e. Tax_exempt_flag = 'R'-Required.)
183: -- 2. The calculate tax flag on customer transaction type for this line
184: -- type is set to Yes.
185:
186: oe_debug_pub.add('calc tax flag 2 : ' || l_line_type_rec.calculate_tax_flag );
187:
188: l_line_type_rec := OE_Order_Cache.Load_Line_Type(p_line_rec.line_type_id);
189:
190: -- fix for bug 1701388 - commented the following code

Line 247: OE_DEBUG_PUB.Add('Entering OE_CNCL_VALIDATE_LINE.Check_Book_Reqd_Attributes',1);

243: OE_MSG_PUB.ADD;
244: END IF;
245: END IF;
246:
247: OE_DEBUG_PUB.Add('Entering OE_CNCL_VALIDATE_LINE.Check_Book_Reqd_Attributes',1);
248:
249: EXCEPTION
250: WHEN OTHERS THEN
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 294: OE_DEBUG_PUB.Add('Entering OE_CNCL_VALIDATE_LINE.Validate_Decimal_Quantity',1);

290: l_validated_quantity NUMBER;
291: l_primary_quantity NUMBER;
292: l_qty_return_status VARCHAR2(1);
293: BEGIN
294: OE_DEBUG_PUB.Add('Entering OE_CNCL_VALIDATE_LINE.Validate_Decimal_Quantity',1);
295: -- validate input quantity
296: IF (p_input_quantity is not null AND
297: p_input_quantity <> FND_API.G_MISS_NUM) THEN
298:

Line 300: oe_debug_pub.add('input quantity is decimal',2);

296: IF (p_input_quantity is not null AND
297: p_input_quantity <> FND_API.G_MISS_NUM) THEN
298:
299: IF trunc(p_input_quantity) <> p_input_quantity THEN
300: oe_debug_pub.add('input quantity is decimal',2);
301:
302: IF p_item_type_code is not NULL THEN
303:
304: IF p_item_type_code IN ('MODEL', 'OPTION', 'KIT',

Line 306: oe_debug_pub.add('item is config related with decimal qty',2);

302: IF p_item_type_code is not NULL THEN
303:
304: IF p_item_type_code IN ('MODEL', 'OPTION', 'KIT',
305: 'CLASS','INCLUDED', 'CONFIG') THEN
306: oe_debug_pub.add('item is config related with decimal qty',2);
307: FND_MESSAGE.SET_NAME('ONT', 'OE_CONFIG_NO_DECIMALS');
308: OE_MSG_PUB.Add;
309: x_return_status := FND_API.G_RET_STS_ERROR;
310:

Line 313: oe_debug_pub.add('before calling inv decimals api',2);

309: x_return_status := FND_API.G_RET_STS_ERROR;
310:
311: ELSE
312:
313: oe_debug_pub.add('before calling inv decimals api',2);
314: inv_decimals_pub.validate_quantity(
315: p_item_id => p_item_id,
316: p_organization_id =>
317: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID'),

Line 325: oe_debug_pub.add('inv decimal api return ' || l_qty_return_status,2);

321: x_primary_quantity => l_primary_quantity,
322: x_return_status => l_qty_return_status);
323:
324: IF l_qty_return_status = 'W' or l_qty_return_status = 'E' THEN
325: oe_debug_pub.add('inv decimal api return ' || l_qty_return_status,2);
326: oe_debug_pub.add('input_qty ' || p_input_quantity,2);
327: oe_debug_pub.add('l_pri_qty ' || l_primary_quantity,2);
328: oe_debug_pub.add('l_val_qty ' || l_validated_quantity,2);
329: /* bug 2926436 */

Line 326: oe_debug_pub.add('input_qty ' || p_input_quantity,2);

322: x_return_status => l_qty_return_status);
323:
324: IF l_qty_return_status = 'W' or l_qty_return_status = 'E' THEN
325: oe_debug_pub.add('inv decimal api return ' || l_qty_return_status,2);
326: oe_debug_pub.add('input_qty ' || p_input_quantity,2);
327: oe_debug_pub.add('l_pri_qty ' || l_primary_quantity,2);
328: oe_debug_pub.add('l_val_qty ' || l_validated_quantity,2);
329: /* bug 2926436 */
330: IF l_qty_return_status = 'W' THEN

Line 327: oe_debug_pub.add('l_pri_qty ' || l_primary_quantity,2);

323:
324: IF l_qty_return_status = 'W' or l_qty_return_status = 'E' THEN
325: oe_debug_pub.add('inv decimal api return ' || l_qty_return_status,2);
326: oe_debug_pub.add('input_qty ' || p_input_quantity,2);
327: oe_debug_pub.add('l_pri_qty ' || l_primary_quantity,2);
328: oe_debug_pub.add('l_val_qty ' || l_validated_quantity,2);
329: /* bug 2926436 */
330: IF l_qty_return_status = 'W' THEN
331: fnd_message.set_name('ONT', 'OE_DECIMAL_MAX_PRECISION');

Line 328: oe_debug_pub.add('l_val_qty ' || l_validated_quantity,2);

324: IF l_qty_return_status = 'W' or l_qty_return_status = 'E' THEN
325: oe_debug_pub.add('inv decimal api return ' || l_qty_return_status,2);
326: oe_debug_pub.add('input_qty ' || p_input_quantity,2);
327: oe_debug_pub.add('l_pri_qty ' || l_primary_quantity,2);
328: oe_debug_pub.add('l_val_qty ' || l_validated_quantity,2);
329: /* bug 2926436 */
330: IF l_qty_return_status = 'W' THEN
331: fnd_message.set_name('ONT', 'OE_DECIMAL_MAX_PRECISION');
332: END IF;

Line 344: OE_DEBUG_PUB.Add('Exiting OE_CNCL_VALIDATE_LINE.Validate_Decimal_Quantity',1);

340: END IF; -- item_type_code is null
341: END IF; -- if not decimal qty
342: END IF; -- quantity is null
343:
344: OE_DEBUG_PUB.Add('Exiting OE_CNCL_VALIDATE_LINE.Validate_Decimal_Quantity',1);
345: END Validate_Decimal_Quantity;
346:
347:
348: Procedure Validate_Line_Type(p_line_rec IN oe_order_pub.line_rec_type)

Line 385: OE_DEBUG_PUB.Add('Entering OE_CNCL_VALIDATE_LINE.Validate_Line_Type',1);

381:
382:
383: BEGIN
384:
385: OE_DEBUG_PUB.Add('Entering OE_CNCL_VALIDATE_LINE.Validate_Line_Type',1);
386:
387: IF p_line_rec.ITEM_TYPE_CODE = OE_GLOBALS.G_ITEM_CONFIG THEN
388:
389: l_new_wf_item_type := OE_Order_WF_Util.get_wf_item_type(p_line_rec);

Line 402: oe_debug_pub.add('No explicit assignment exists',2);

398: INTO lexists;
399: CLOSE find_config_assign;
400:
401: IF lexists IS NULL THEN
402: oe_debug_pub.add('No explicit assignment exists',2);
403: FND_MESSAGE.SET_NAME('ONT','OE_EXP_ASSIGN_REQ');
404: OE_MSG_PUB.ADD;
405: RAISE FND_API.G_EXC_ERROR;
406: END IF;

Line 410: OE_DEBUG_PUB.Add('Exiting OE_CNCL_VALIDATE_LINE.Validate_Line_Type',1);

406: END IF;
407:
408: END IF;
409:
410: OE_DEBUG_PUB.Add('Exiting OE_CNCL_VALIDATE_LINE.Validate_Line_Type',1);
411: EXCEPTION
412: WHEN NO_DATA_FOUND THEN
413: FND_MESSAGE.SET_NAME('ONT','OE_FLOW_CNT_CHANGE');
414: OE_MSG_PUB.ADD;

Line 441: OE_DEBUG_PUB.Add('Entering OE_CNCL_VALIDATE_LINE.Validate_Receiving_Org',1);

437: IS
438: l_validate VARCHAR2(1) := 'Y';
439: l_dummy VARCHAR2(10);
440: BEGIN
441: OE_DEBUG_PUB.Add('Entering OE_CNCL_VALIDATE_LINE.Validate_Receiving_Org',1);
442: SELECT null
443: INTO l_dummy
444: FROM mtl_system_items msi,
445: org_organization_definitions org

Line 453: OE_DEBUG_PUB.Add('Exiting OE_CNCL_VALIDATE_LINE.Validate_Receiving_Org',1);

449: AND org.set_of_books_id= ( SELECT fsp.set_of_books_id
450: FROM financials_system_parameters fsp)
451: AND ROWNUM=1 ;
452:
453: OE_DEBUG_PUB.Add('Exiting OE_CNCL_VALIDATE_LINE.Validate_Receiving_Org',1);
454: RETURN TRUE;
455: EXCEPTION
456: WHEN NO_DATA_FOUND THEN
457: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');

Line 477: oe_debug_pub.add('Entering Validate_Item_Warehouse',1);

473: IS
474: l_validate VARCHAR2(1) := 'Y';
475: l_dummy VARCHAR2(10);
476: BEGIN
477: oe_debug_pub.add('Entering Validate_Item_Warehouse',1);
478: -- The customer_order_enabled_flag for config item
479: -- is set to 'N'
480:
481: IF p_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED OR

Line 506: oe_debug_pub.add('Exiting Validate_Item_Warehouse',1);

502: AND org.organization_id= msi.organization_id
503: AND org.organization_id= p_ship_from_org_id
504: AND rownum=1;
505: END IF;
506: oe_debug_pub.add('Exiting Validate_Item_Warehouse',1);
507: RETURN TRUE;
508:
509: EXCEPTION
510: WHEN NO_DATA_FOUND THEN

Line 511: oe_debug_pub.add('RR: No data found',1);

507: RETURN TRUE;
508:
509: EXCEPTION
510: WHEN NO_DATA_FOUND THEN
511: oe_debug_pub.add('RR: No data found',1);
512:
513: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');
514: OE_MSG_PUB.add;
515: RETURN FALSE;

Line 518: oe_debug_pub.add('RR: OTHERS',1);

514: OE_MSG_PUB.add;
515: RETURN FALSE;
516:
517: WHEN OTHERS THEN
518: oe_debug_pub.add('RR: OTHERS',1);
519: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');
520: OE_MSG_PUB.add;
521: RETURN FALSE;
522:

Line 533: oe_debug_pub.add('Entering Validate_Task',1);

529: IS
530: l_dummy VARCHAR2(10);
531: BEGIN
532:
533: oe_debug_pub.add('Entering Validate_Task',1);
534: SELECT 'VALID'
535: INTO l_dummy
536: FROM mtl_task_v
537: WHERE project_id = p_project_id

Line 540: oe_debug_pub.add('Exiting Validate_Task',1);

536: FROM mtl_task_v
537: WHERE project_id = p_project_id
538: AND task_id = p_task_id;
539:
540: oe_debug_pub.add('Exiting Validate_Task',1);
541: RETURN TRUE;
542:
543: EXCEPTION
544:

Line 557: oe_debug_pub.add('Entering Validate_task_reqd',1);

553: RETURN BOOLEAN
554: IS
555: l_project_control_level NUMBER;
556: BEGIN
557: oe_debug_pub.add('Entering Validate_task_reqd',1);
558:
559: -- If project control level in MTL_PARAMETERS for the warehouse
560: -- is set to 'Task', then project references on the order must
561: -- consist of both Project and Task.

Line 570: oe_debug_pub.add('Exiting Validate_task_reqd',1);

566: WHERE ORGANIZATION_ID = p_ship_from_org_id;
567:
568: IF l_project_control_level = 2 -- control level is 'Task'
569: THEN
570: oe_debug_pub.add('Exiting Validate_task_reqd',1);
571: RETURN TRUE;
572: ELSE
573: oe_debug_pub.add('Exiting Validate_task_reqd',1);
574: RETURN FALSE;

Line 573: oe_debug_pub.add('Exiting Validate_task_reqd',1);

569: THEN
570: oe_debug_pub.add('Exiting Validate_task_reqd',1);
571: RETURN TRUE;
572: ELSE
573: oe_debug_pub.add('Exiting Validate_task_reqd',1);
574: RETURN FALSE;
575: END IF;
576:
577: EXCEPTION

Line 594: oe_debug_pub.add('Entering Validate_Item_Fields',1);

590: RETURN BOOLEAN
591: IS
592: l_dummy VARCHAR2(10);
593: BEGIN
594: oe_debug_pub.add('Entering Validate_Item_Fields',1);
595: oe_debug_pub.add('p_inventory_item_id: '||p_inventory_item_id);
596: oe_debug_pub.add('p_ordered_item_id: '||p_ordered_item_id);
597: oe_debug_pub.add('p_item_identifier_type: '||p_item_identifier_type);
598: oe_debug_pub.add('p_ordered_item: '||p_ordered_item);

Line 595: oe_debug_pub.add('p_inventory_item_id: '||p_inventory_item_id);

591: IS
592: l_dummy VARCHAR2(10);
593: BEGIN
594: oe_debug_pub.add('Entering Validate_Item_Fields',1);
595: oe_debug_pub.add('p_inventory_item_id: '||p_inventory_item_id);
596: oe_debug_pub.add('p_ordered_item_id: '||p_ordered_item_id);
597: oe_debug_pub.add('p_item_identifier_type: '||p_item_identifier_type);
598: oe_debug_pub.add('p_ordered_item: '||p_ordered_item);
599: oe_debug_pub.add('p_sold_to_org_id: '||p_sold_to_org_id);

Line 596: oe_debug_pub.add('p_ordered_item_id: '||p_ordered_item_id);

592: l_dummy VARCHAR2(10);
593: BEGIN
594: oe_debug_pub.add('Entering Validate_Item_Fields',1);
595: oe_debug_pub.add('p_inventory_item_id: '||p_inventory_item_id);
596: oe_debug_pub.add('p_ordered_item_id: '||p_ordered_item_id);
597: oe_debug_pub.add('p_item_identifier_type: '||p_item_identifier_type);
598: oe_debug_pub.add('p_ordered_item: '||p_ordered_item);
599: oe_debug_pub.add('p_sold_to_org_id: '||p_sold_to_org_id);
600: IF nvl(p_item_identifier_type, 'INT') = 'INT' THEN

Line 597: oe_debug_pub.add('p_item_identifier_type: '||p_item_identifier_type);

593: BEGIN
594: oe_debug_pub.add('Entering Validate_Item_Fields',1);
595: oe_debug_pub.add('p_inventory_item_id: '||p_inventory_item_id);
596: oe_debug_pub.add('p_ordered_item_id: '||p_ordered_item_id);
597: oe_debug_pub.add('p_item_identifier_type: '||p_item_identifier_type);
598: oe_debug_pub.add('p_ordered_item: '||p_ordered_item);
599: oe_debug_pub.add('p_sold_to_org_id: '||p_sold_to_org_id);
600: IF nvl(p_item_identifier_type, 'INT') = 'INT' THEN
601: SELECT 'valid'

Line 598: oe_debug_pub.add('p_ordered_item: '||p_ordered_item);

594: oe_debug_pub.add('Entering Validate_Item_Fields',1);
595: oe_debug_pub.add('p_inventory_item_id: '||p_inventory_item_id);
596: oe_debug_pub.add('p_ordered_item_id: '||p_ordered_item_id);
597: oe_debug_pub.add('p_item_identifier_type: '||p_item_identifier_type);
598: oe_debug_pub.add('p_ordered_item: '||p_ordered_item);
599: oe_debug_pub.add('p_sold_to_org_id: '||p_sold_to_org_id);
600: IF nvl(p_item_identifier_type, 'INT') = 'INT' THEN
601: SELECT 'valid'
602: INTO l_dummy

Line 599: oe_debug_pub.add('p_sold_to_org_id: '||p_sold_to_org_id);

595: oe_debug_pub.add('p_inventory_item_id: '||p_inventory_item_id);
596: oe_debug_pub.add('p_ordered_item_id: '||p_ordered_item_id);
597: oe_debug_pub.add('p_item_identifier_type: '||p_item_identifier_type);
598: oe_debug_pub.add('p_ordered_item: '||p_ordered_item);
599: oe_debug_pub.add('p_sold_to_org_id: '||p_sold_to_org_id);
600: IF nvl(p_item_identifier_type, 'INT') = 'INT' THEN
601: SELECT 'valid'
602: INTO l_dummy
603: FROM mtl_system_items_vl

Line 639: oe_debug_pub.add('Exiting Validate_Item_Fields',1);

635: AND items.cross_reference = p_ordered_item;
636: END IF;
637: END IF;
638:
639: oe_debug_pub.add('Exiting Validate_Item_Fields',1);
640: RETURN TRUE;
641:
642: EXCEPTION
643: WHEN NO_DATA_FOUND THEN

Line 644: oe_debug_pub.add('Validate_Item_Fields: No data found',1);

640: RETURN TRUE;
641:
642: EXCEPTION
643: WHEN NO_DATA_FOUND THEN
644: oe_debug_pub.add('Validate_Item_Fields: No data found',1);
645: IF nvl(p_item_identifier_type, 'INT') = 'INT' THEN
646: oe_debug_pub.add('Invalid internal item');
647: ELSIF nvl(p_item_identifier_type, 'INT') = 'CUST' THEN
648: oe_debug_pub.add('Invalid Customer Item');

Line 646: oe_debug_pub.add('Invalid internal item');

642: EXCEPTION
643: WHEN NO_DATA_FOUND THEN
644: oe_debug_pub.add('Validate_Item_Fields: No data found',1);
645: IF nvl(p_item_identifier_type, 'INT') = 'INT' THEN
646: oe_debug_pub.add('Invalid internal item');
647: ELSIF nvl(p_item_identifier_type, 'INT') = 'CUST' THEN
648: oe_debug_pub.add('Invalid Customer Item');
649: ELSE
650: oe_debug_pub.add('Invalid Generic Item');

Line 648: oe_debug_pub.add('Invalid Customer Item');

644: oe_debug_pub.add('Validate_Item_Fields: No data found',1);
645: IF nvl(p_item_identifier_type, 'INT') = 'INT' THEN
646: oe_debug_pub.add('Invalid internal item');
647: ELSIF nvl(p_item_identifier_type, 'INT') = 'CUST' THEN
648: oe_debug_pub.add('Invalid Customer Item');
649: ELSE
650: oe_debug_pub.add('Invalid Generic Item');
651: END IF;
652: RETURN FALSE;

Line 650: oe_debug_pub.add('Invalid Generic Item');

646: oe_debug_pub.add('Invalid internal item');
647: ELSIF nvl(p_item_identifier_type, 'INT') = 'CUST' THEN
648: oe_debug_pub.add('Invalid Customer Item');
649: ELSE
650: oe_debug_pub.add('Invalid Generic Item');
651: END IF;
652: RETURN FALSE;
653: WHEN OTHERS THEN
654: oe_debug_pub.add('Validate_Item_Fields: When Others',1);

Line 654: oe_debug_pub.add('Validate_Item_Fields: When Others',1);

650: oe_debug_pub.add('Invalid Generic Item');
651: END IF;
652: RETURN FALSE;
653: WHEN OTHERS THEN
654: oe_debug_pub.add('Validate_Item_Fields: When Others',1);
655: RETURN FALSE;
656: END Validate_Item_Fields;
657:
658: FUNCTION Validate_Return_Item_Mismatch

Line 666: oe_debug_pub.add('Entering Validate_Return_Item_Mismatch',1);

662: IS
663: l_ref_inventory_item_id NUMBER;
664: l_profile VARCHAR2(1);
665: BEGIN
666: oe_debug_pub.add('Entering Validate_Return_Item_Mismatch',1);
667:
668: IF (p_reference_line_id IS NULL) THEN
669: RETURN TRUE;
670: END IF;

Line 695: oe_debug_pub.add('Exiting Validate_Return_Item_Mismatch',1);

691: END IF;
692:
693: END IF;
694:
695: oe_debug_pub.add('Exiting Validate_Return_Item_Mismatch',1);
696: RETURN TRUE;
697:
698: EXCEPTION
699: WHEN NO_DATA_FOUND THEN

Line 700: oe_debug_pub.add('Validate_Return_Item_Mismatch: No data found',1);

696: RETURN TRUE;
697:
698: EXCEPTION
699: WHEN NO_DATA_FOUND THEN
700: oe_debug_pub.add('Validate_Return_Item_Mismatch: No data found',1);
701: RETURN FALSE;
702: WHEN OTHERS THEN
703: oe_debug_pub.add('Validate_Return_Item_Mismatch: When Others',1);
704: RETURN FALSE;

Line 703: oe_debug_pub.add('Validate_Return_Item_Mismatch: When Others',1);

699: WHEN NO_DATA_FOUND THEN
700: oe_debug_pub.add('Validate_Return_Item_Mismatch: No data found',1);
701: RETURN FALSE;
702: WHEN OTHERS THEN
703: oe_debug_pub.add('Validate_Return_Item_Mismatch: When Others',1);
704: RETURN FALSE;
705: END Validate_Return_Item_Mismatch;
706:
707: FUNCTION Validate_Return_Fulfilled_Line

Line 717: oe_debug_pub.add('Entering Validate return fulfilled line',1);

713: l_ref_shipped_quantity NUMBER;
714: l_ref_inv_iface_status VARCHAR2(30);
715: l_profile VARCHAR2(1);
716: BEGIN
717: oe_debug_pub.add('Entering Validate return fulfilled line',1);
718:
719: IF (p_reference_line_id IS NULL) THEN
720: RETURN TRUE;
721: END IF;

Line 765: oe_debug_pub.add('Exiting Validate return fulfilled line',1);

761: END IF;
762:
763: END IF;
764:
765: oe_debug_pub.add('Exiting Validate return fulfilled line',1);
766: RETURN TRUE;
767:
768: EXCEPTION
769: WHEN NO_DATA_FOUND THEN

Line 770: oe_debug_pub.add('Validate_Return_Fulfilled_Line: No data found',1);

766: RETURN TRUE;
767:
768: EXCEPTION
769: WHEN NO_DATA_FOUND THEN
770: oe_debug_pub.add('Validate_Return_Fulfilled_Line: No data found',1);
771: RETURN FALSE;
772: WHEN OTHERS THEN
773: oe_debug_pub.add('Validate_Return_Fulfilled_Line: When Others',1);
774: RETURN FALSE;

Line 773: oe_debug_pub.add('Validate_Return_Fulfilled_Line: When Others',1);

769: WHEN NO_DATA_FOUND THEN
770: oe_debug_pub.add('Validate_Return_Fulfilled_Line: No data found',1);
771: RETURN FALSE;
772: WHEN OTHERS THEN
773: oe_debug_pub.add('Validate_Return_Fulfilled_Line: When Others',1);
774: RETURN FALSE;
775: END Validate_Return_Fulfilled_Line;
776:
777: FUNCTION Validate_Return_Item

Line 784: oe_debug_pub.add('Entering Validate_Return_Item',1);

780: RETURN BOOLEAN
781: IS
782: l_returnable_flag Varchar2(1);
783: BEGIN
784: oe_debug_pub.add('Entering Validate_Return_Item',1);
785:
786: SELECT nvl(returnable_flag,'Y')
787: INTO l_returnable_flag
788: FROM mtl_system_items

Line 801: oe_debug_pub.add('Validate_Return_Item: No data found',1);

797: RETURN FALSE;
798:
799: EXCEPTION
800: WHEN NO_DATA_FOUND THEN
801: oe_debug_pub.add('Validate_Return_Item: No data found',1);
802: RETURN FALSE;
803: WHEN OTHERS THEN
804: oe_debug_pub.add('Validate_Return_Item: When Others',1);
805: RETURN FALSE;

Line 804: oe_debug_pub.add('Validate_Return_Item: When Others',1);

800: WHEN NO_DATA_FOUND THEN
801: oe_debug_pub.add('Validate_Return_Item: No data found',1);
802: RETURN FALSE;
803: WHEN OTHERS THEN
804: oe_debug_pub.add('Validate_Return_Item: When Others',1);
805: RETURN FALSE;
806: END Validate_Return_Item;
807:
808: FUNCTION Validate_Return_Reference

Line 814: oe_debug_pub.add('Enter Validate_Return_Reference',1);

810: RETURN BOOLEAN
811: IS
812: l_booked_flag Varchar2(1);
813: BEGIN
814: oe_debug_pub.add('Enter Validate_Return_Reference',1);
815:
816: SELECT nvl(booked_flag,'N')
817: INTO l_booked_flag
818: FROM oe_order_lines

Line 829: oe_debug_pub.add('Exit Validate_Return_Reference',1);

825: fnd_message.set_name('ONT', 'OE_RETURN_UNBOOKED_ORDER');
826: OE_MSG_PUB.Add;
827: END IF;
828:
829: oe_debug_pub.add('Exit Validate_Return_Reference',1);
830: RETURN FALSE;
831:
832: EXCEPTION
833: WHEN NO_DATA_FOUND THEN

Line 834: oe_debug_pub.add('Validate_Return_Reference: No data found',1);

830: RETURN FALSE;
831:
832: EXCEPTION
833: WHEN NO_DATA_FOUND THEN
834: oe_debug_pub.add('Validate_Return_Reference: No data found',1);
835: fnd_message.set_name('ONT', 'OE_RETURN_INVALID_SO_LINE');
836: OE_MSG_PUB.Add;
837: RETURN FALSE;
838: WHEN OTHERS THEN

Line 839: oe_debug_pub.add('Validate_Return_Reference: When Others',1);

835: fnd_message.set_name('ONT', 'OE_RETURN_INVALID_SO_LINE');
836: OE_MSG_PUB.Add;
837: RETURN FALSE;
838: WHEN OTHERS THEN
839: oe_debug_pub.add('Validate_Return_Reference: When Others',1);
840: fnd_message.set_name('ONT', 'OE_RETURN_INVALID_SO_LINE');
841: OE_MSG_PUB.Add;
842: RETURN FALSE;
843: END Validate_Return_Reference;

Line 881: oe_debug_pub.add('Entering Validate_ship_to_org',1);

877: AND ROWNUM = 1;
878:
879: BEGIN
880:
881: oe_debug_pub.add('Entering Validate_ship_to_org',1);
882: oe_debug_pub.add('ship_to_org_id :'||to_char(p_ship_to_org_id),2);
883:
884: --lcustomer_relations := FND_PROFILE.VALUE('ONT_CUSTOMER_RELATIONSHIPS');
885: lcustomer_relations := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');

Line 882: oe_debug_pub.add('ship_to_org_id :'||to_char(p_ship_to_org_id),2);

878:
879: BEGIN
880:
881: oe_debug_pub.add('Entering Validate_ship_to_org',1);
882: oe_debug_pub.add('ship_to_org_id :'||to_char(p_ship_to_org_id),2);
883:
884: --lcustomer_relations := FND_PROFILE.VALUE('ONT_CUSTOMER_RELATIONSHIPS');
885: lcustomer_relations := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');
886:

Line 896: oe_debug_pub.add('Exiting Validate_ship_to_org',1);

892: Where customer_id = p_sold_to_org_id
893: AND site_use_id = p_ship_to_org_id
894: AND status = 'A';
895:
896: oe_debug_pub.add('Exiting Validate_ship_to_org',1);
897: RETURN TRUE;
898: ELSIF lcustomer_relations = 'Y' THEN
899:
900: /*Select /*MOAC_SQL_NO_CHANGE 'VALID'

Line 928: oe_debug_pub.add

924:
925: /* added the following ELSIF condition to fix the bug 2002486 */
926:
927: ELSIF nvl(lcustomer_relations,'N') = 'A' THEN
928: oe_debug_pub.add
929: ('Cr: A',2);
930:
931: SELECT 'VALID'
932: INTO l_dummy

Line 958: oe_debug_pub.add('Entering OE_CNCL_VALIDATE_LINE.Validate_Deliver_To_Org',1);

954: lcustomer_relations varchar2(1);
955:
956: BEGIN
957:
958: oe_debug_pub.add('Entering OE_CNCL_VALIDATE_LINE.Validate_Deliver_To_Org',1);
959: oe_debug_pub.add('deliver_to_org_id :'||to_char(p_deliver_to_org_id),2);
960: lcustomer_relations := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');
961:
962: IF nvl(lcustomer_relations,'N') = 'N' THEN

Line 959: oe_debug_pub.add('deliver_to_org_id :'||to_char(p_deliver_to_org_id),2);

955:
956: BEGIN
957:
958: oe_debug_pub.add('Entering OE_CNCL_VALIDATE_LINE.Validate_Deliver_To_Org',1);
959: oe_debug_pub.add('deliver_to_org_id :'||to_char(p_deliver_to_org_id),2);
960: lcustomer_relations := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');
961:
962: IF nvl(lcustomer_relations,'N') = 'N' THEN
963: SELECT 'VALID'

Line 970: oe_debug_pub.add('Exiting OE_CNCL_VALIDATE_LINE.Validate_Deliver_To_Org',1);

966: WHERE customer_id = p_sold_to_org_id
967: AND site_use_id = p_deliver_to_org_id
968: AND status = 'A';
969:
970: oe_debug_pub.add('Exiting OE_CNCL_VALIDATE_LINE.Validate_Deliver_To_Org',1);
971: RETURN TRUE;
972:
973: ELSIF lcustomer_relations = 'Y' THEN
974: oe_debug_pub.add('Cr: Yes Line Deliver',2);

Line 974: oe_debug_pub.add('Cr: Yes Line Deliver',2);

970: oe_debug_pub.add('Exiting OE_CNCL_VALIDATE_LINE.Validate_Deliver_To_Org',1);
971: RETURN TRUE;
972:
973: ELSIF lcustomer_relations = 'Y' THEN
974: oe_debug_pub.add('Cr: Yes Line Deliver',2);
975:
976: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
977: Into l_dummy
978: FROM HZ_CUST_SITE_USES_ALL SITE,

Line 993: oe_debug_pub.add('Exiting OE_CNCL_VALIDATE_LINE.Validate_Deliver_To_Org',1);

989: AND R.RELATED_CUST_ACCOUNT_ID = p_sold_to_org_id
990: and R.ship_to_flag = 'Y')
991: AND ROWNUM = 1;
992:
993: oe_debug_pub.add('Exiting OE_CNCL_VALIDATE_LINE.Validate_Deliver_To_Org',1);
994: RETURN TRUE;
995:
996: ELSIF lcustomer_relations = 'A' THEN
997:

Line 1003: oe_debug_pub.add('Exiting OE_CNCL_VALIDATE_LINE.Validate_Deliver_To_Org',1);

999: INTO l_dummy
1000: FROM HZ_CUST_SITE_USES SITE
1001: WHERE SITE.SITE_USE_ID =p_deliver_to_org_id;
1002:
1003: oe_debug_pub.add('Exiting OE_CNCL_VALIDATE_LINE.Validate_Deliver_To_Org',1);
1004: RETURN TRUE;
1005:
1006:
1007: END IF;

Line 1010: oe_debug_pub.add('Exiting OE_CNCL_VALIDATE_LINE.Validate_Deliver_To_Org',1);

1006:
1007: END IF;
1008:
1009:
1010: oe_debug_pub.add('Exiting OE_CNCL_VALIDATE_LINE.Validate_Deliver_To_Org',1);
1011:
1012: EXCEPTION
1013:
1014: WHEN OTHERS THEN

Line 1033: oe_debug_pub.add('entering validate_source_type', 3);

1029: IS
1030: l_purchasing_enabled_flag VARCHAR2(1);
1031: BEGIN
1032:
1033: oe_debug_pub.add('entering validate_source_type', 3);
1034:
1035: IF OE_GLOBALS.Equal(p_line_rec.source_type_code,
1036: OE_GLOBALS.G_SOURCE_EXTERNAL) THEN
1037:

Line 1043: oe_debug_pub.add('servie / part of smc model', 4);

1039: THEN
1040: IF p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE OR
1041: p_line_rec.ship_model_complete_flag = 'Y'
1042: THEN
1043: oe_debug_pub.add('servie / part of smc model', 4);
1044: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_NOT_VALID_ITEM');
1045: FND_MESSAGE.SET_TOKEN('ITEM', p_line_rec.ordered_item);
1046: OE_MSG_PUB.Add;
1047: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1050: oe_debug_pub.add('validate line: pack H new logic DS', 1);

1046: OE_MSG_PUB.Add;
1047: x_return_status := FND_API.G_RET_STS_ERROR;
1048: RETURN;
1049: ELSE
1050: oe_debug_pub.add('validate line: pack H new logic DS', 1);
1051: END IF;
1052: ELSE
1053: IF (p_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_STANDARD) THEN
1054: oe_debug_pub.add('Cannot dropship non-standard item',2);

Line 1054: oe_debug_pub.add('Cannot dropship non-standard item',2);

1050: oe_debug_pub.add('validate line: pack H new logic DS', 1);
1051: END IF;
1052: ELSE
1053: IF (p_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_STANDARD) THEN
1054: oe_debug_pub.add('Cannot dropship non-standard item',2);
1055: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_NOT_ALLOWED');
1056: OE_MSG_PUB.Add;
1057: x_return_status := FND_API.G_RET_STS_ERROR;
1058: RETURN;

Line 1066: oe_debug_pub.add('Cannot insert external line to set',2);

1062:
1063: IF p_line_rec.ship_set_id is not null OR
1064: p_line_rec.arrival_set_id is not null THEN
1065:
1066: oe_debug_pub.add('Cannot insert external line to set',2);
1067: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_SET_INS_FAILED');
1068: OE_MSG_PUB.Add;
1069: x_return_status := FND_API.G_RET_STS_ERROR;
1070: RETURN;

Line 1103: oe_debug_pub.add('leaving validate_source_type', 3);

1099: END IF;
1100:
1101: END IF;
1102:
1103: oe_debug_pub.add('leaving validate_source_type', 3);
1104:
1105: EXCEPTION
1106: WHEN OTHERS THEN
1107: oe_debug_pub.add('error in Validate_Source_Type');

Line 1107: oe_debug_pub.add('error in Validate_Source_Type');

1103: oe_debug_pub.add('leaving validate_source_type', 3);
1104:
1105: EXCEPTION
1106: WHEN OTHERS THEN
1107: oe_debug_pub.add('error in Validate_Source_Type');
1108: RAISE;
1109: END Validate_Source_Type;
1110:
1111:

Line 1137: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level; -- INVCONV

1133: l_order_quantity_uom VARCHAR2(3);
1134: lcustomer_relations varchar2(1) := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');
1135: l_list_type_code VARCHAR2(30);
1136:
1137: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level; -- INVCONV
1138: l_tracking_quantity_ind VARCHAR2(30); -- INVCONV
1139: l_secondary_default_ind VARCHAR2(30); -- INVCONV
1140: l_secondary_uom_code varchar2(3) := NULL; -- INVCONV
1141: l_buffer VARCHAR2(2000); -- INVCONV

Line 1224: oe_debug_pub.add('Enter OE_CNCL_VALIDATE_LINE.ENTITY',1);

1220: and rownum = 1 ;
1221:
1222: BEGIN
1223:
1224: oe_debug_pub.add('Enter OE_CNCL_VALIDATE_LINE.ENTITY',1);
1225:
1226:
1227: -----------------------------------------------------------
1228: -- Check required attributes.

Line 1231: oe_debug_pub.add('1 '||l_return_status, 1);

1227: -----------------------------------------------------------
1228: -- Check required attributes.
1229: -----------------------------------------------------------
1230:
1231: oe_debug_pub.add('1 '||l_return_status, 1);
1232:
1233: oe_debug_pub.add('2 '||l_return_status, 1);
1234: IF p_line_rec.inventory_item_id IS NULL
1235: THEN

Line 1233: oe_debug_pub.add('2 '||l_return_status, 1);

1229: -----------------------------------------------------------
1230:
1231: oe_debug_pub.add('1 '||l_return_status, 1);
1232:
1233: oe_debug_pub.add('2 '||l_return_status, 1);
1234: IF p_line_rec.inventory_item_id IS NULL
1235: THEN
1236:
1237: l_return_status := FND_API.G_RET_STS_ERROR;

Line 1246: oe_debug_pub.add('3 '||l_return_status, 1);

1242: OE_MSG_PUB.Add;
1243:
1244: END IF;
1245:
1246: oe_debug_pub.add('3 '||l_return_status, 1);
1247: IF p_line_rec.line_type_id IS NULL
1248: THEN
1249:
1250: l_return_status := FND_API.G_RET_STS_ERROR;

Line 1276: oe_debug_pub.add('5 '||l_return_status, 1);

1272: -- Check conditionally required attributes here.
1273: --------------------------------------------------------------
1274:
1275: -- For return lines, Return_Reason_Code is required
1276: oe_debug_pub.add('5 '||l_return_status, 1);
1277: IF p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE
1278: and p_line_rec.return_reason_code is NULL
1279: THEN
1280: l_return_status := FND_API.G_RET_STS_ERROR;

Line 1290: oe_debug_pub.add('6 '||l_return_status, 1);

1286:
1287: END IF;
1288:
1289:
1290: oe_debug_pub.add('6 '||l_return_status, 1);
1291:
1292: -- subinventory
1293: oe_debug_pub.add('Entity: subinventory - ' || p_line_rec.subinventory);
1294:

Line 1293: oe_debug_pub.add('Entity: subinventory - ' || p_line_rec.subinventory);

1289:
1290: oe_debug_pub.add('6 '||l_return_status, 1);
1291:
1292: -- subinventory
1293: oe_debug_pub.add('Entity: subinventory - ' || p_line_rec.subinventory);
1294:
1295: IF p_line_rec.subinventory is not null THEN
1296: IF p_line_rec.source_type_code = 'INTERNAL' OR
1297: p_line_rec.source_type_code is null THEN

Line 1298: oe_debug_pub.add('Entity Validateion: subinventory', 1);

1294:
1295: IF p_line_rec.subinventory is not null THEN
1296: IF p_line_rec.source_type_code = 'INTERNAL' OR
1297: p_line_rec.source_type_code is null THEN
1298: oe_debug_pub.add('Entity Validateion: subinventory', 1);
1299: IF p_line_rec.ship_from_org_id is null THEN
1300: l_return_status := FND_API.G_RET_STS_ERROR;
1301: fnd_message.set_name('ONT', 'OE_ATTRIBUTE_REQUIRED');
1302: fnd_message.set_token('ATTRIBUTE',OE_Order_UTIL.Get_Attribute_Name('SHIP_FROM_ORG_ID'));

Line 1314: oe_debug_pub.add('Entity: done subinv validation', 1);

1310: END IF;
1311:
1312: -- end subinventory
1313:
1314: oe_debug_pub.add('Entity: done subinv validation', 1);
1315:
1316: -- If line is booked, then check for the attributes required on booked lines
1317: -- Fix bug 1277092: this check not required for fully cancelled lines
1318: IF p_line_rec.booked_flag = 'Y'

Line 1341: oe_debug_pub.add('Primary and Secondary X-VAL start', 1);

1337:
1338: -- OPM 02/JUN/00 START
1339: -- For an item with tracking in Primary and secondary , check qty1/2 both present and sync'd -- INVCONV
1340: -- =====================================================================
1341: oe_debug_pub.add('Primary and Secondary X-VAL start', 1);
1342:
1343: OPEN c_item( p_line_rec.ship_from_org_id,
1344: p_line_rec.inventory_item_id
1345: );

Line 1372: oe_debug_pub.add('Primary and Secondary X-VAL - tracking_quantity_ind PS', 2);

1368: THEN
1369: */
1370: IF l_tracking_quantity_ind = 'PS' then
1371: -- IF l_item_rec.dualum_ind in (1,2,3) THEN INVCONV
1372: oe_debug_pub.add('Primary and Secondary X-VAL - tracking_quantity_ind PS', 2);
1373:
1374: IF (p_line_rec.ordered_quantity <> FND_API.G_MISS_NUM OR
1375: p_line_rec.ordered_quantity IS NOT NULL) AND
1376: (p_line_rec.ordered_quantity2 = FND_API.G_MISS_NUM OR

Line 1379: oe_debug_pub.add('Primary and Secondary X-VAL qty 1 not empty', 2);

1375: p_line_rec.ordered_quantity IS NOT NULL) AND
1376: (p_line_rec.ordered_quantity2 = FND_API.G_MISS_NUM OR
1377: p_line_rec.ordered_quantity2 IS NULL) THEN
1378:
1379: oe_debug_pub.add('Primary and Secondary X-VAL qty 1 not empty', 2);
1380:
1381: l_return_status := FND_API.G_RET_STS_ERROR;
1382: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1383: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ordered_Quantity2');

Line 1399: oe_debug_pub.add('Primary and Secondary X-VAL - tolerance check', 2);

1395: END IF; -- IF l_item_rec.tracking_quantity_ind = 'PS' IF l_item_rec.dualum_ind in (1,2,3) THEN
1396:
1397: /* If qty1/qty2 both populated, check tolerances
1398: ================================================*/
1399: oe_debug_pub.add('Primary and Secondary X-VAL - tolerance check', 2);
1400:
1401: IF l_secondary_default_ind in ('N','D') then -- INVCONV
1402: -- IF l_item_rec.dualum_ind in (2,3) THEN
1403: IF (p_line_rec.ordered_quantity <> FND_API.G_MISS_NUM AND

Line 1423: oe_debug_pub.add('Primary and Secondary X-VAL - tolerance error 1' ,1);

1419:
1420: IF l_return = 0
1421: then
1422: IF l_debug_level > 0 THEN
1423: oe_debug_pub.add('Primary and Secondary X-VAL - tolerance error 1' ,1);
1424: END IF;
1425:
1426: l_buffer := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST, -- INVCONV
1427: p_encoded => 'F');

Line 1430: oe_debug_pub.add(l_buffer,1);

1426: l_buffer := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST, -- INVCONV
1427: p_encoded => 'F');
1428: oe_msg_pub.add_text(p_message_text => l_buffer);
1429: IF l_debug_level > 0 THEN
1430: oe_debug_pub.add(l_buffer,1);
1431: END IF;
1432: l_return_status := FND_API.G_RET_STS_ERROR;
1433:
1434: else

Line 1436: oe_debug_pub.add('Primary and Secondary X-VAL - No tolerance error ',1);

1432: l_return_status := FND_API.G_RET_STS_ERROR;
1433:
1434: else
1435: IF l_debug_level > 0 THEN
1436: oe_debug_pub.add('Primary and Secondary X-VAL - No tolerance error ',1);
1437: END IF;
1438: END IF; -- IF l_return = 0
1439:
1440:

Line 1506: oe_debug_pub.add('Source Type is Internal',1);

1502:
1503: IF p_line_rec.source_type_code = OE_GLOBALS.G_SOURCE_INTERNAL
1504: or p_line_rec.source_type_code is null
1505: THEN
1506: oe_debug_pub.add('Source Type is Internal',1);
1507:
1508: IF p_line_rec.line_category_code = 'RETURN' THEN
1509: l_item_type_code := OE_LINE_UTIL.Get_Return_item_type_code(
1510: p_line_rec);

Line 1526: oe_debug_pub.add('Source Type is External',1);

1522: THEN
1523: l_return_status := FND_API.G_RET_STS_ERROR;
1524: END IF;
1525: ELSE
1526: oe_debug_pub.add('Source Type is External',1);
1527: IF NOT Validate_Receiving_Org
1528: (p_line_rec.inventory_item_id,
1529: p_line_rec.ship_from_org_id)
1530: THEN

Line 1566: oe_debug_pub.add('decimal1',2);

1562:
1563: -- start decimal qty validation
1564: IF p_line_rec.inventory_item_id is not null THEN
1565:
1566: oe_debug_pub.add('decimal1',2);
1567: IF p_line_rec.order_quantity_uom is not null THEN
1568:
1569: -- validate ordered quantity
1570: Validate_Decimal_Quantity

Line 1720: OE_DEBUG_PUB.Add('Before calling Validate Proj References',1);

1716: p_date := NVL(p_line_rec.schedule_arrival_date,
1717: p_line_rec.request_date);
1718: END IF;
1719:
1720: OE_DEBUG_PUB.Add('Before calling Validate Proj References',1);
1721:
1722: result := PJM_PROJECT.VALIDATE_PROJ_REFERENCES
1723: ( X_inventory_org_id => p_line_rec.ship_from_org_id
1724: , X_operating_unit => p_line_rec.org_id

Line 1732: OE_DEBUG_PUB.Add('Validate Proj References Error:'||

1728: , X_date2 => NULL
1729: , X_calling_function =>'OEXVCLNB'
1730: , X_error_code => errcode
1731: );
1732: OE_DEBUG_PUB.Add('Validate Proj References Error:'||
1733: errcode,1);
1734: OE_DEBUG_PUB.Add('Validate Proj References Result:'||
1735: result,1);
1736:

Line 1734: OE_DEBUG_PUB.Add('Validate Proj References Result:'||

1730: , X_error_code => errcode
1731: );
1732: OE_DEBUG_PUB.Add('Validate Proj References Error:'||
1733: errcode,1);
1734: OE_DEBUG_PUB.Add('Validate Proj References Result:'||
1735: result,1);
1736:
1737: IF result <> PJM_PROJECT.G_VALIDATE_SUCCESS THEN
1738: OE_MSG_PUB.Transfer_Msg_Stack;

Line 1742: OE_DEBUG_PUB.add(l_msg_data,1);

1738: OE_MSG_PUB.Transfer_Msg_Stack;
1739: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
1740: FOR I in 1..l_msg_count loop
1741: l_msg_data := OE_MSG_PUB.Get(I,'F');
1742: OE_DEBUG_PUB.add(l_msg_data,1);
1743: END LOOP;
1744: END IF;
1745:
1746: IF result = PJM_PROJECT.G_VALIDATE_FAILURE THEN

Line 1748: OE_DEBUG_PUB.Add('PJM Validation API returned with Errors',1);

1744: END IF;
1745:
1746: IF result = PJM_PROJECT.G_VALIDATE_FAILURE THEN
1747: l_return_status := FND_API.G_RET_STS_ERROR;
1748: OE_DEBUG_PUB.Add('PJM Validation API returned with Errors',1);
1749: ELSIF result = PJM_PROJECT.G_VALIDATE_WARNING THEN
1750: OE_DEBUG_PUB.Add('PJM Validation API returned with Warnings',1);
1751: END IF;
1752:

Line 1750: OE_DEBUG_PUB.Add('PJM Validation API returned with Warnings',1);

1746: IF result = PJM_PROJECT.G_VALIDATE_FAILURE THEN
1747: l_return_status := FND_API.G_RET_STS_ERROR;
1748: OE_DEBUG_PUB.Add('PJM Validation API returned with Errors',1);
1749: ELSIF result = PJM_PROJECT.G_VALIDATE_WARNING THEN
1750: OE_DEBUG_PUB.Add('PJM Validation API returned with Warnings',1);
1751: END IF;
1752:
1753:
1754:

Line 1814: oe_debug_pub.add('10 '||l_return_status, 1);

1810: */
1811:
1812: -- End Item Unit number logic.
1813:
1814: oe_debug_pub.add('10 '||l_return_status, 1);
1815: IF (p_line_rec.inventory_item_id IS NOT NULL) AND
1816: (p_line_rec.ship_from_org_id IS NOT NULL) AND
1817: (p_line_rec.end_item_unit_number IS NULL) THEN
1818:

Line 1846: oe_debug_pub.add('11 '||l_return_status, 1);

1842:
1843: -- Donot allow to update project and task when a option/class is under ATO
1844: -- Model.
1845:
1846: oe_debug_pub.add('11 '||l_return_status, 1);
1847:
1848: /*IF p_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1849:
1850: IF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR

Line 1866: oe_debug_pub.add('12-1 '||l_return_status, 1);

1862: -- End of PJM validation.
1863: */
1864:
1865: -- Validate if item, item_identifier_type, inventory_item combination is valid
1866: oe_debug_pub.add('12-1 '||l_return_status, 1);
1867: IF p_line_rec.inventory_item_id IS NOT NULL THEN
1868:
1869: IF NOT Validate_Item_Fields
1870: ( p_line_rec.inventory_item_id

Line 1883: oe_debug_pub.add('12 '||l_return_status, 1);

1879: END IF;
1880:
1881: END IF;
1882:
1883: oe_debug_pub.add('12 '||l_return_status, 1);
1884: -- Validate if return item and item on referenced sales order line mismatch
1885: IF (p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE and
1886: p_line_rec.reference_line_id is not null and
1887: p_line_rec.inventory_item_id IS NOT NULL)

Line 1900: oe_debug_pub.add('13 '||l_return_status, 1);

1896: OE_MSG_PUB.add;
1897: END IF;
1898: END IF;
1899:
1900: oe_debug_pub.add('13 '||l_return_status, 1);
1901:
1902: -- Validate if returning a fulfilled sales order line
1903: IF (p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE and
1904: p_line_rec.reference_line_id is not null)

Line 1917: oe_debug_pub.add('14 '||l_return_status, 1);

1913: END IF;
1914:
1915: END IF;
1916:
1917: oe_debug_pub.add('14 '||l_return_status, 1);
1918:
1919: -- Validate if item on the Return is Returnable
1920: IF (p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE and
1921: p_line_rec.inventory_item_id IS NOT NULL)

Line 1933: oe_debug_pub.add('14_1 '||l_return_status, 1);

1929: END IF;
1930: END IF;
1931:
1932:
1933: oe_debug_pub.add('14_1 '||l_return_status, 1);
1934:
1935: -- Validate if Reference SO Line is Valid
1936: IF (p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE and
1937: p_line_rec.reference_line_id is not null)

Line 1946: oe_debug_pub.add('14_2 '||l_return_status, 1);

1942: l_return_status := FND_API.G_RET_STS_ERROR;
1943: END IF;
1944: END IF;
1945:
1946: oe_debug_pub.add('14_2 '||l_return_status, 1);
1947:
1948: -- Validate the quantity = 1 on RMA for Serial Number reference
1949: IF (p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE and
1950: p_line_rec.reference_line_id is not null and

Line 1960: oe_debug_pub.add('14_3 '||l_return_status, 1);

1956: OE_MSG_PUB.Add;
1957: END IF;
1958:
1959:
1960: oe_debug_pub.add('14_3 '||l_return_status, 1);
1961:
1962: -- Validation of Ship To Org Id.
1963: IF p_line_rec.ship_to_org_id IS NOT NULL
1964:

Line 1986: oe_debug_pub.add('ship_to_contact_id :'||to_char(p_line_rec.ship_to_contact_id),2);

1982:
1983: THEN
1984:
1985: BEGIN
1986: oe_debug_pub.add('ship_to_contact_id :'||to_char(p_line_rec.ship_to_contact_id),2);
1987:
1988: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
1989: INTO l_dummy
1990: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE

Line 2047: oe_debug_pub.add('deliver_to_contact_id :'||to_char(p_line_rec.deliver_to_contact_id),2);

2043:
2044: THEN
2045:
2046: BEGIN
2047: oe_debug_pub.add('deliver_to_contact_id :'||to_char(p_line_rec.deliver_to_contact_id),2);
2048:
2049: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
2050: INTO l_dummy
2051: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE

Line 2090: oe_debug_pub.add('invoice_to_org_id :'||to_char(p_line_rec.invoice_to_org_id),2);

2086:
2087: THEN
2088:
2089: BEGIN
2090: oe_debug_pub.add('invoice_to_org_id :'||to_char(p_line_rec.invoice_to_org_id),2);
2091: --lcustomer_relations := FND_PROFILE.VALUE('ONT_CUSTOMER_RELATIONSHIPS');
2092:
2093: IF nvl(lcustomer_relations,'N') = 'N' THEN
2094:

Line 2129: oe_debug_pub.add

2125:
2126: /* added the following ELSIF condition to fix the bug 2002486 */
2127:
2128: ELSIF nvl(lcustomer_relations,'N') = 'A' THEN
2129: oe_debug_pub.add
2130: ('Cr: A',2);
2131:
2132: SELECT 'VALID'
2133: INTO l_dummy

Line 2166: oe_debug_pub.add('invoice_to_contact_id :'||to_char(p_line_rec.invoice_to_contact_id),2);

2162:
2163: THEN
2164:
2165: BEGIN
2166: oe_debug_pub.add('invoice_to_contact_id :'||to_char(p_line_rec.invoice_to_contact_id),2);
2167:
2168: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
2169: INTO l_dummy
2170: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE

Line 2431: oe_debug_pub.add('primary uom: '|| l_uom, 1);

2427: AND organization_id = nvl(p_line_rec.ship_from_org_id,
2428: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID'));
2429:
2430:
2431: oe_debug_pub.add('primary uom: '|| l_uom, 1);
2432: oe_debug_pub.add('uom entered: '||p_line_rec.order_quantity_uom , 1);
2433:
2434: IF l_uom <> p_line_rec.order_quantity_uom
2435: THEN

Line 2432: oe_debug_pub.add('uom entered: '||p_line_rec.order_quantity_uom , 1);

2428: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID'));
2429:
2430:
2431: oe_debug_pub.add('primary uom: '|| l_uom, 1);
2432: oe_debug_pub.add('uom entered: '||p_line_rec.order_quantity_uom , 1);
2433:
2434: IF l_uom <> p_line_rec.order_quantity_uom
2435: THEN
2436: oe_debug_pub.add('uom other than primary uom is entered', 1);

Line 2436: oe_debug_pub.add('uom other than primary uom is entered', 1);

2432: oe_debug_pub.add('uom entered: '||p_line_rec.order_quantity_uom , 1);
2433:
2434: IF l_uom <> p_line_rec.order_quantity_uom
2435: THEN
2436: oe_debug_pub.add('uom other than primary uom is entered', 1);
2437:
2438: fnd_message.set_name('ONT','OE_INVALID_ORDER_QUANTITY_UOM');
2439: fnd_message.set_token('ITEM',p_line_rec.ordered_item );
2440: fnd_message.set_token('UOM', l_uom);

Line 2446: oe_debug_pub.add('OEXLLINB, no_data_found in uom validation', 1);

2442: RAISE FND_API.G_EXC_ERROR;
2443: END IF;
2444: EXCEPTION
2445: when no_data_found then
2446: oe_debug_pub.add('OEXLLINB, no_data_found in uom validation', 1);
2447: RAISE FND_API.G_EXC_ERROR;
2448: END;
2449:
2450: ELSE -- not ato related, validate item, uom combination

Line 2461: oe_debug_pub.add('uom/item combination invalid',2);

2457: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID'));
2458:
2459:
2460: IF l_uom_count = 0 THEN
2461: oe_debug_pub.add('uom/item combination invalid',2);
2462: fnd_message.set_name('ONT', 'OE_INVALID_ITEM_UOM');
2463: OE_MSG_PUB.Add;
2464: RAISE FND_API.G_EXC_ERROR;
2465: END IF;

Line 2526: oe_debug_pub.add('Invalid Agreement +price_list_id combination',2);

2522: l_price_list_name := l_price_list_id;
2523: END;
2524: fnd_message.set_Token('PRICE_LIST2', l_price_list_name);
2525: OE_MSG_PUB.Add;
2526: oe_debug_pub.add('Invalid Agreement +price_list_id combination',2);
2527: raise FND_API.G_EXC_ERROR;
2528: END IF;
2529: END IF; -- end of if l_list_type_code <> 'PRL'
2530:

Line 2541: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);

2537: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
2538: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
2539: fnd_message.set_Token('CUSTOMER_ID', p_line_rec.sold_to_org_id);
2540: OE_MSG_PUB.Add;
2541: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);
2542: RAISE FND_API.G_EXC_ERROR;
2543: ELSIF lcustomer_relations = 'Y' THEN
2544:
2545: BEGIN

Line 2557: oe_debug_pub.add('Linda -- l_dummy is: '||l_dummy,2);

2553: AND CUST_ACCOUNT_ID = l_sold_to_org
2554:
2555: );
2556:
2557: oe_debug_pub.add('Linda -- l_dummy is: '||l_dummy,2);
2558: /* Replaced ra_customer_relationships with HZ Table to fix the bug 1888440 */
2559:
2560: EXCEPTION
2561: WHEN NO_DATA_FOUND THEN

Line 2567: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);

2563: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
2564: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
2565: fnd_message.set_Token('CUSTOMER_ID', p_line_rec.sold_to_org_id);
2566: OE_MSG_PUB.Add;
2567: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);
2568: RAISE FND_API.G_EXC_ERROR;
2569: END;
2570: END IF;
2571: END IF;

Line 2581: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);

2577: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
2578: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
2579: fnd_message.set_Token('CUSTOMER_ID', l_sold_to_org);
2580: OE_MSG_PUB.Add;
2581: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);
2582: RAISE FND_API.G_EXC_ERROR;
2583: END;
2584: END IF; -- Agreement has changed
2585:

Line 2594: oe_debug_pub.add('Pricing date is '||p_line_rec.pricing_date,2);

2590:
2591:
2592: -- Allow only the non agreement price_lists
2593: BEGIN
2594: oe_debug_pub.add('Pricing date is '||p_line_rec.pricing_date,2);
2595: -- modified by lkxu: to select from qp_list_headers_vl instead
2596: -- of from qp_price_lists_v to select only PRL type list headers.
2597:
2598: SELECT name

Line 2610: oe_debug_pub.add('Invalid non agreement price list ',2);

2606: fnd_message.set_name('ONT', 'OE_INVALID_NONAGR_PLIST');
2607: fnd_message.set_Token('PRICE_LIST1', p_line_rec.price_list_id);
2608: fnd_message.set_Token('PRICING_DATE', p_line_rec.pricing_date);
2609: OE_MSG_PUB.Add;
2610: oe_debug_pub.add('Invalid non agreement price list ',2);
2611: RAISE FND_API.G_EXC_ERROR;
2612: END;
2613:
2614: --END IF; -- Price list or pricing date has changed

Line 2617: oe_debug_pub.add('15 '||l_return_status ,1);

2613:
2614: --END IF; -- Price list or pricing date has changed
2615: END IF;
2616:
2617: oe_debug_pub.add('15 '||l_return_status ,1);
2618:
2619: -- Line number validation.
2620: -- Allow line number updates only on Model, Standard, Kit,
2621: --and stand alone service line.

Line 2646: oe_debug_pub.add('16 '||l_return_status ,1);

2642:
2643: END IF;
2644: */
2645:
2646: oe_debug_pub.add('16 '||l_return_status ,1);
2647:
2648: /*IF p_line_rec.top_model_line_id is not null AND
2649: p_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
2650: p_line_rec.ordered_quantity = 0

Line 2652: oe_debug_pub.add

2648: /*IF p_line_rec.top_model_line_id is not null AND
2649: p_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
2650: p_line_rec.ordered_quantity = 0
2651: THEN
2652: oe_debug_pub.add
2653: ('qty of a configuration related line 0'|| p_line_rec.item_type_code, 1);
2654: END IF;
2655: */
2656:

Line 2657: oe_debug_pub.add('OEXLLINB, RR:T2',1);

2653: ('qty of a configuration related line 0'|| p_line_rec.item_type_code, 1);
2654: END IF;
2655: */
2656:
2657: oe_debug_pub.add('OEXLLINB, RR:T2',1);
2658: oe_debug_pub.add('17 '||l_return_status ,1);
2659:
2660: -- Validate ordered quantity for OTA lines. OTA Lines are
2661: -- identified by item_type_code of training. The ordered

Line 2658: oe_debug_pub.add('17 '||l_return_status ,1);

2654: END IF;
2655: */
2656:
2657: oe_debug_pub.add('OEXLLINB, RR:T2',1);
2658: oe_debug_pub.add('17 '||l_return_status ,1);
2659:
2660: -- Validate ordered quantity for OTA lines. OTA Lines are
2661: -- identified by item_type_code of training. The ordered
2662: -- quantity cannot be greater than 1 for OTA lines.

Line 2670: oe_debug_pub.add('Ordered Qty cannot be greater than 1 for OTA lines',

2666:
2667: IF (l_is_ota_line) AND
2668: p_line_rec.ordered_quantity > 1 then
2669:
2670: oe_debug_pub.add('Ordered Qty cannot be greater than 1 for OTA lines',
2671: 1);
2672: l_return_status := FND_API.G_RET_STS_ERROR;
2673: FND_Message.Set_Name('ONT', 'OE_OTA_INVALID_QTY');
2674: oe_msg_pub.add;

Line 2716: oe_debug_pub.add('18 '||l_return_status ,1);

2712: END IF;
2713:
2714: END IF;
2715:
2716: oe_debug_pub.add('18 '||l_return_status ,1);
2717: x_return_status := l_return_status;
2718:
2719: -- Done validating entity
2720: oe_debug_pub.add('Exit OE_CNCL_VALIDATE_LINE.ENTITY',1);

Line 2720: oe_debug_pub.add('Exit OE_CNCL_VALIDATE_LINE.ENTITY',1);

2716: oe_debug_pub.add('18 '||l_return_status ,1);
2717: x_return_status := l_return_status;
2718:
2719: -- Done validating entity
2720: oe_debug_pub.add('Exit OE_CNCL_VALIDATE_LINE.ENTITY',1);
2721: EXCEPTION
2722:
2723: WHEN FND_API.G_EXC_ERROR THEN
2724:

Line 2757: oe_debug_pub.add('Enter procedure OE_CNCL_VALIDATE_line.Attributes',1);

2753: l_return_status VARCHAR2(1);
2754: l_line_rec OE_Order_PUB.Line_Rec_Type := OE_Order_PUB.G_MISS_LINE_REC;
2755: l_type_code VARCHAR2(30);
2756: BEGIN
2757: oe_debug_pub.add('Enter procedure OE_CNCL_VALIDATE_line.Attributes',1);
2758:
2759: x_return_status := FND_API.G_RET_STS_SUCCESS;
2760: l_return_status := FND_API.G_RET_STS_SUCCESS;
2761:

Line 3262: oe_debug_pub.add('before flex: '||x_return_status,2);

3258: END IF;
3259: END IF;
3260: END IF;
3261:
3262: oe_debug_pub.add('before flex: '||x_return_status,2);
3263: IF p_x_line_rec.attribute1 IS NOT NULL
3264: OR p_x_line_rec.attribute10 IS NOT NULL
3265: OR p_x_line_rec.attribute11 IS NOT NULL
3266: OR p_x_line_rec.attribute12 IS NOT NULL

Line 3286: oe_debug_pub.add('Before calling line_desc_flex',2);

3282: OR p_x_line_rec.attribute9 IS NOT NULL
3283: OR p_x_line_rec.context IS NOT NULL
3284: THEN
3285:
3286: oe_debug_pub.add('Before calling line_desc_flex',2);
3287: IF NOT OE_CNCL_Validate.Line_Desc_Flex
3288: (p_context => p_x_line_rec.context
3289: ,p_attribute1 => p_x_line_rec.attribute1
3290: ,p_attribute2 => p_x_line_rec.attribute2

Line 3363: oe_debug_pub.add('After line_desc_flex ' || x_return_status,2);

3359: x_return_status := FND_API.G_RET_STS_ERROR;
3360: END IF;
3361: END IF;
3362:
3363: oe_debug_pub.add('After line_desc_flex ' || x_return_status,2);
3364:
3365:
3366:
3367: END IF;

Line 3395: OE_DEBUG_PUB.ADD('Before G_line_desc_flex',2);

3391: THEN
3392:
3393:
3394:
3395: OE_DEBUG_PUB.ADD('Before G_line_desc_flex',2);
3396: IF NOT OE_CNCL_Validate.G_Line_Desc_Flex
3397: (p_context => p_x_line_rec.global_attribute_category
3398: ,p_attribute1 => p_x_line_rec.global_attribute1
3399: ,p_attribute2 => p_x_line_rec.global_attribute2

Line 3470: OE_DEBUG_PUB.ADD('After G_Line_desc_flex ' || x_return_status,2);

3466: x_return_status := FND_API.G_RET_STS_ERROR;
3467: END IF;
3468: END IF;
3469:
3470: OE_DEBUG_PUB.ADD('After G_Line_desc_flex ' || x_return_status,2);
3471:
3472: END IF;
3473:
3474: IF p_x_line_rec.industry_attribute1 IS NOT NULL

Line 3615: oe_debug_pub.add('After I_line_desc_flex ' || x_return_status,2);

3611: x_return_status := FND_API.G_RET_STS_ERROR;
3612: END IF;
3613: END IF;
3614:
3615: oe_debug_pub.add('After I_line_desc_flex ' || x_return_status,2);
3616:
3617: END IF;
3618:
3619: /* Trading Partner Attributes */

Line 3701: --oe_debug_pub.add('After TP_line_desc_flex ' || x_return_status);

3697: x_return_status := FND_API.G_RET_STS_ERROR;
3698: END IF;
3699: END IF;
3700:
3701: --oe_debug_pub.add('After TP_line_desc_flex ' || x_return_status);
3702:
3703: END IF;
3704: /* Trading Partner */
3705:

Line 3726: oe_debug_pub.add('Before calling Return line_desc_flex',2);

3722: OR p_x_line_rec.return_context IS NOT NULL
3723: THEN
3724:
3725:
3726: oe_debug_pub.add('Before calling Return line_desc_flex',2);
3727: IF NOT OE_CNCL_Validate.R_Line_Desc_Flex
3728: (p_context => p_x_line_rec.Return_context
3729: ,p_attribute1 => p_x_line_rec.Return_attribute1
3730: ,p_attribute2 => p_x_line_rec.Return_attribute2

Line 3788: oe_debug_pub.add('After Return line_desc_flex ' || x_return_status,2);

3784: x_return_status := FND_API.G_RET_STS_ERROR;
3785: END IF;
3786: END IF;
3787:
3788: oe_debug_pub.add('After Return line_desc_flex ' || x_return_status,2);
3789:
3790:
3791:
3792: END IF;

Line 3829: oe_debug_pub.add('Exiting procedure OE_CNCL_VALIDATE_line.Attributes',1);

3825: IF NOT OE_CNCL_Validate.commitment(p_x_line_rec.commitment_id) THEN
3826: x_return_status := FND_API.G_RET_STS_ERROR;
3827: END IF;
3828: END IF;
3829: oe_debug_pub.add('Exiting procedure OE_CNCL_VALIDATE_line.Attributes',1);
3830:
3831: EXCEPTION
3832:
3833: WHEN FND_API.G_EXC_ERROR THEN

Line 3863: oe_debug_pub.add('In OEXVCLINB: Function Get_Item_Type',1);

3859: l_item_type_code VARCHAR2(30) := NULL;
3860: l_item_rec OE_ORDER_CACHE.item_rec_type;
3861: BEGIN
3862:
3863: oe_debug_pub.add('In OEXVCLINB: Function Get_Item_Type',1);
3864: oe_debug_pub.add('The INV Item is'||to_char(p_line_rec.inventory_item_id),1);
3865:
3866: IF p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN
3867: RETURN OE_GLOBALS.G_ITEM_STANDARD;

Line 3864: oe_debug_pub.add('The INV Item is'||to_char(p_line_rec.inventory_item_id),1);

3860: l_item_rec OE_ORDER_CACHE.item_rec_type;
3861: BEGIN
3862:
3863: oe_debug_pub.add('In OEXVCLINB: Function Get_Item_Type',1);
3864: oe_debug_pub.add('The INV Item is'||to_char(p_line_rec.inventory_item_id),1);
3865:
3866: IF p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN
3867: RETURN OE_GLOBALS.G_ITEM_STANDARD;
3868: ELSIF p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR

Line 3878: oe_debug_pub.add('Bom Item Type is ' || l_item_rec.bom_item_type);

3874: l_item_rec :=
3875: OE_Order_Cache.Load_Item (p_line_rec.inventory_item_id
3876: ,p_line_rec.ship_from_org_id);
3877:
3878: oe_debug_pub.add('Bom Item Type is ' || l_item_rec.bom_item_type);
3879:
3880: IF l_item_rec.bom_item_type = 1
3881: -- MODEL items and ato's under pto have bom_item_type = 1
3882: THEN

Line 3887: oe_debug_pub.add

3883:
3884: IF nvl(p_line_rec.top_model_line_ref, 0) <>
3885: nvl(p_line_rec.orig_sys_line_ref, 0)
3886: THEN
3887: oe_debug_pub.add
3888: ('Returning CLASS as the Item Type for ato subconfig',1);
3889: --Procedure to check change in item_type_code
3890: RETURN OE_GLOBALS.G_ITEM_CLASS;
3891: END IF;

Line 3893: oe_debug_pub.add('Returning MODEL as the Item Type',1);

3889: --Procedure to check change in item_type_code
3890: RETURN OE_GLOBALS.G_ITEM_CLASS;
3891: END IF;
3892:
3893: oe_debug_pub.add('Returning MODEL as the Item Type',1);
3894: --Procedure to check change in item_type_code
3895: RETURN OE_GLOBALS.G_ITEM_MODEL;
3896:
3897: ELSIF l_item_rec.bom_item_type = 2

Line 3899: oe_debug_pub.add('Returning CLASS as the Item Type',1);

3895: RETURN OE_GLOBALS.G_ITEM_MODEL;
3896:
3897: ELSIF l_item_rec.bom_item_type = 2
3898: THEN
3899: oe_debug_pub.add('Returning CLASS as the Item Type',1);
3900: -- Only CLASS items have bom_item_type = 2
3901: --Procedure to check change in item_type_code
3902: RETURN OE_GLOBALS.G_ITEM_CLASS;
3903: ELSIF l_item_rec.bom_item_type = 4 and

Line 3907: oe_debug_pub.add('Bom 4 and flag = N');

3903: ELSIF l_item_rec.bom_item_type = 4 and
3904: l_item_rec.service_item_flag = 'N'
3905: THEN
3906:
3907: oe_debug_pub.add('Bom 4 and flag = N');
3908: -- Following 3 items can have bom_item_type = 4 :
3909: -- STANDARD item, OPTION item and a KIT
3910: -- We will distinguish an item to be a kit by seeing if
3911: -- it has a record in bom_bill_of_materials.

Line 3917: oe_debug_pub.add

3913: -- before they come to defaulting. Thus we use it to distinguish
3914: -- between a standard and an option item.
3915: -- ato_item's item_type_code will be standard
3916:
3917: oe_debug_pub.add
3918: ('item Org ' || OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID'));
3919: oe_debug_pub.add('inventory_item_id ' || p_line_rec.inventory_item_id);
3920: BEGIN
3921: SELECT OE_GLOBALS.G_ITEM_KIT

Line 3919: oe_debug_pub.add('inventory_item_id ' || p_line_rec.inventory_item_id);

3915: -- ato_item's item_type_code will be standard
3916:
3917: oe_debug_pub.add
3918: ('item Org ' || OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID'));
3919: oe_debug_pub.add('inventory_item_id ' || p_line_rec.inventory_item_id);
3920: BEGIN
3921: SELECT OE_GLOBALS.G_ITEM_KIT
3922: INTO l_item_type_code
3923: FROM mtl_system_items

Line 3929: oe_debug_pub.add(' Before calling check 1');

3925: = OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID')
3926: AND inventory_item_id = p_line_rec.inventory_item_id
3927: AND pick_components_flag = 'Y';
3928:
3929: oe_debug_pub.add(' Before calling check 1');
3930: --Procedure to check change in item_type_code
3931: RETURN l_item_type_code;
3932: EXCEPTION
3933: WHEN NO_DATA_FOUND THEN

Line 3934: oe_debug_pub.add('get_item_type no data found, bom_item_type : 4', 1);

3930: --Procedure to check change in item_type_code
3931: RETURN l_item_type_code;
3932: EXCEPTION
3933: WHEN NO_DATA_FOUND THEN
3934: oe_debug_pub.add('get_item_type no data found, bom_item_type : 4', 1);
3935: IF (p_line_rec.top_model_line_ref is not null AND
3936: p_line_rec.top_model_line_ref <> FND_API.G_MISS_CHAR)
3937: OR
3938: (p_line_rec.top_model_line_index is not null AND

Line 3942: oe_debug_pub.add(' Before calling check 2');

3938: (p_line_rec.top_model_line_index is not null AND
3939: p_line_rec.top_model_line_index <> FND_API.G_MISS_NUM)
3940:
3941: THEN
3942: oe_debug_pub.add(' Before calling check 2');
3943: RETURN OE_GLOBALS.G_ITEM_OPTION;
3944: ELSE
3945: oe_debug_pub.add(' Before calling check 3');
3946: RETURN OE_GLOBALS.G_ITEM_STANDARD;

Line 3945: oe_debug_pub.add(' Before calling check 3');

3941: THEN
3942: oe_debug_pub.add(' Before calling check 2');
3943: RETURN OE_GLOBALS.G_ITEM_OPTION;
3944: ELSE
3945: oe_debug_pub.add(' Before calling check 3');
3946: RETURN OE_GLOBALS.G_ITEM_STANDARD;
3947: END IF;
3948: END;
3949:

Line 3953: oe_debug_pub.add('Service item flag is: ' || l_item_rec.service_item_flag);

3949:
3950: ELSIF l_item_rec.service_item_flag = 'Y' and
3951: l_item_rec.bom_item_type = 4
3952: THEN
3953: oe_debug_pub.add('Service item flag is: ' || l_item_rec.service_item_flag);
3954: RETURN OE_GLOBALS.G_ITEM_SERVICE;
3955:
3956: END IF;
3957:

Line 3960: oe_debug_pub.add('Exiting OEXVCLNB: Function Get_Item_Type');

3956: END IF;
3957:
3958: RETURN null;
3959:
3960: oe_debug_pub.add('Exiting OEXVCLNB: Function Get_Item_Type');
3961:
3962: EXCEPTION
3963:
3964: WHEN NO_DATA_FOUND THEN

Line 3965: oe_debug_pub.add(' Before calling check 4');

3961:
3962: EXCEPTION
3963:
3964: WHEN NO_DATA_FOUND THEN
3965: oe_debug_pub.add(' Before calling check 4');
3966: l_item_type_code := OE_GLOBALS.G_ITEM_STANDARD;
3967: RETURN l_item_type_code;
3968:
3969: WHEN OTHERS THEN