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

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

53: x_Aud_Tbl_Name VARCHAR2(240);
54: x_Msg_Flag VARCHAR2(240);
55: x_seqassid INTEGER;
56:
57: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
58: BEGIN
59:
60: -- Check whether order type exists in global table
61:

Line 472: OE_DEBUG_PUB.ADD('Validation failed for IB_INSTALLED_AT_LOCATION in OEBLHDRB.pls');

468:
469: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
470: THEN
471:
472: OE_DEBUG_PUB.ADD('Validation failed for IB_INSTALLED_AT_LOCATION in OEBLHDRB.pls');
473: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'IB_INSTALLED_AT_LOCATION');
474:
475: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
476: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

Line 524: OE_DEBUG_PUB.ADD('Validation failed for IB_INSTALLED_AT_LOCATION in OEBLHDRB.pls');

520:
521: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
522: THEN
523:
524: OE_DEBUG_PUB.ADD('Validation failed for IB_INSTALLED_AT_LOCATION in OEBLHDRB.pls');
525: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'IB_INSTALLED_AT_LOCATION');
526:
527: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
528: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

Line 581: OE_DEBUG_PUB.ADD('Validation failed for IB_CURRENT_LOCATION in OEBLHDRB.pls');

577:
578: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
579: THEN
580:
581: OE_DEBUG_PUB.ADD('Validation failed for IB_CURRENT_LOCATION in OEBLHDRB.pls');
582: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'IB_CURRENT_LOCATION');
583:
584: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
585: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

Line 623: oe_debug_pub.add('Enter OE_VALIDATE_HEADER.CHECK_BOOK_REQD',1);

619: l_set_of_books_rec OE_Order_Cache.Set_Of_Books_Rec_Type;
620: l_c_index NUMBER;
621: BEGIN
622:
623: oe_debug_pub.add('Enter OE_VALIDATE_HEADER.CHECK_BOOK_REQD',1);
624:
625: -- Check for the following required fields on a booked order:
626: -- Order Number, Sold To Org, Invoice To Org,
627: -- Price List, Tax Exempt Flag, Sales Person, Order Date

Line 812: oe_debug_pub.add('Exiting OE_VALIDATE_HEADER.CHECK_BOOK_REQD',1);

808: */
809:
810: END IF; -- END of checks related to payment type
811:
812: oe_debug_pub.add('Exiting OE_VALIDATE_HEADER.CHECK_BOOK_REQD',1);
813: EXCEPTION
814: WHEN OTHERS THEN
815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
816: IF oe_bulk_msg_pub.check_msg_level (oe_bulk_msg_pub.G_MSG_LVL_UNEXP_ERROR)

Line 855: oe_debug_pub.add('Invoice To cache returns no data found');

851: := OE_Bulk_Cache.G_INVOICE_TO_TBL(l_c_index).order_type_id;
852: -- Invalid invoice to - error message populated during validation
853: EXCEPTION
854: WHEN NO_DATA_FOUND THEN
855: oe_debug_pub.add('Invoice To cache returns no data found');
856: x_return_status := FND_API.G_RET_STS_ERROR;
857: END;
858:
859: END IF;

Line 874: oe_debug_pub.add('Ship To cache returns no data found');

870:
871: -- Invalid ship to - error message populated during validation
872: EXCEPTION
873: WHEN NO_DATA_FOUND THEN
874: oe_debug_pub.add('Ship To cache returns no data found');
875: x_return_status := FND_API.G_RET_STS_ERROR;
876: END;
877:
878: END IF;

Line 910: oe_debug_pub.add('Agreement cache returns no data found');

906:
907: -- Invalid agreement - error message populated during validation
908: EXCEPTION
909: WHEN NO_DATA_FOUND THEN
910: oe_debug_pub.add('Agreement cache returns no data found');
911: x_return_status := FND_API.G_RET_STS_ERROR;
912: END;
913:
914: END IF;

Line 919: oe_debug_pub.add('load ship to cache');

915:
916: -- Default attributes that have ship to as the first source
917: -- or is the next source after agreement.
918:
919: oe_debug_pub.add('load ship to cache');
920: IF p_header_rec.ship_to_org_id(p_index) IS NOT NULL
921: AND ( p_header_rec.fob_point_code(p_index) IS NULL
922: OR p_header_rec.freight_terms_code(p_index) IS NULL
923: OR p_header_rec.demand_class_code(p_index) IS NULL

Line 957: oe_debug_pub.add('Ship To cache returns no data found');

953:
954: -- Invalid ship to - error message populated during validation
955: EXCEPTION
956: WHEN NO_DATA_FOUND THEN
957: oe_debug_pub.add('Ship To cache returns no data found');
958: x_return_status := FND_API.G_RET_STS_ERROR;
959: END;
960:
961: END IF;

Line 966: oe_debug_pub.add('load invoice to cache');

962:
963: -- Default attributes that have invoice to as the first source
964: -- or is the next source after agreement, ship to.
965:
966: oe_debug_pub.add('load invoice to cache');
967: IF p_header_rec.invoice_to_org_id(p_index) IS NOT NULL
968: AND ( p_header_rec.price_list_id(p_index) IS NULL
969: OR p_header_rec.payment_term_id(p_index) IS NULL )
970: THEN

Line 986: oe_debug_pub.add('Invoice to cache returns no data found');

982:
983: -- Invalid invoice to - error message populated during validation
984: EXCEPTION
985: WHEN NO_DATA_FOUND THEN
986: oe_debug_pub.add('Invoice to cache returns no data found');
987: x_return_status := FND_API.G_RET_STS_ERROR;
988: END;
989:
990: END IF;

Line 1031: oe_debug_pub.add('Order Type cache returns no data found');

1027:
1028: -- Invalid order type - error message populated during validation
1029: EXCEPTION
1030: WHEN NO_DATA_FOUND THEN
1031: oe_debug_pub.add('Order Type cache returns no data found');
1032: x_return_status := FND_API.G_RET_STS_ERROR;
1033: END;
1034:
1035: END IF;

Line 1101: oe_debug_pub.add('Order Type cache returns no data found');

1097:
1098: -- Invalid order type - error message populated during validation
1099: EXCEPTION
1100: WHEN NO_DATA_FOUND THEN
1101: oe_debug_pub.add('Order Type cache returns no data found');
1102: -- Set order category for insert to succeed
1103: p_header_rec.order_category_code(p_index) := 'ORDER';
1104: x_return_status := FND_API.G_RET_STS_ERROR;
1105: END;

Line 1148: oe_debug_pub.add('others errors, Populate_Internal_Fields');

1144: EXCEPTION
1145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1147: WHEN OTHERS THEN
1148: oe_debug_pub.add('others errors, Populate_Internal_Fields');
1149: oe_debug_pub.add(substr(sqlerrm,1,200));
1150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1151: IF oe_bulk_msg_pub.check_msg_level(oe_bulk_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1152: THEN

Line 1149: oe_debug_pub.add(substr(sqlerrm,1,200));

1145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1147: WHEN OTHERS THEN
1148: oe_debug_pub.add('others errors, Populate_Internal_Fields');
1149: oe_debug_pub.add(substr(sqlerrm,1,200));
1150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1151: IF oe_bulk_msg_pub.check_msg_level(oe_bulk_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1152: THEN
1153: oe_bulk_msg_pub.add_exc_msg

Line 1378: oe_debug_pub.add('no data found in validate price list');

1374: RETURN TRUE;
1375:
1376: EXCEPTION
1377: WHEN NO_DATA_FOUND THEN
1378: oe_debug_pub.add('no data found in validate price list');
1379: RETURN FALSE;
1380: END Validate_Price_List;
1381:
1382:

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

1675: l_on_scheduling_hold BOOLEAN;
1676: l_scredit_index NUMBER := 1;
1677: l_gapless_sequence VARCHAR2(1) := 'N';
1678: l_hold_ii_flag VARCHAR2(1); -- Added to support out parameter
1679: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1680: l_header_rec_for_hold OE_Order_PUB.Header_Rec_Type; --ER#7479609
1681:
1682: BEGIN
1683: ctr := p_header_rec.header_id.COUNT;

Line 1712: oe_debug_pub.add('event code : '||p_header_rec.event_code(i));

1708: ELSE
1709: p_header_rec.event_code(i) := 'BATCH';
1710: END IF;
1711: If l_debug_level > 0 Then
1712: oe_debug_pub.add('event code : '||p_header_rec.event_code(i));
1713: End If;
1714: END IF;
1715: --PIB
1716:

Line 2768: oe_debug_pub.add('event code1 : '||p_header_rec.event_code(i));

2764: --PIB
2765: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' Then
2766: p_header_rec.event_code(i) := 'BATCH';
2767: If l_debug_level > 0 Then
2768: oe_debug_pub.add('event code1 : '||p_header_rec.event_code(i));
2769: End If;
2770: END IF;
2771: --PIB
2772:

Line 2785: oe_debug_pub.add('event code2 : '||p_header_rec.event_code(i));

2781: --PIB
2782: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' Then
2783: p_header_rec.event_code(i) := 'BATCH';
2784: If l_debug_level > 0 Then
2785: oe_debug_pub.add('event code2 : '||p_header_rec.event_code(i));
2786: End If;
2787: END IF;
2788: --PIB
2789: END IF;