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

Line 67: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.DEFAULT_ATTRIBUTES', 1);

63: IS
64: l_control_rec OE_GLOBALS.Control_Rec_Type;
65: l_return_status VARCHAR2(1);
66: BEGIN
67: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.DEFAULT_ATTRIBUTES', 1);
68:
69:
70:
71: -- Set the UI flag

Line 215: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.DEFAULT_ATTRIBUTES', 1);

211: ( p_count => x_msg_count
212: , p_data => x_msg_data
213: );
214:
215: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.DEFAULT_ATTRIBUTES', 1);
216:
217: EXCEPTION
218:
219: WHEN FND_API.G_EXC_ERROR THEN

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

288: IS
289: l_control_rec OE_GLOBALS.Control_Rec_Type;
290: l_return_status VARCHAR2(1);
291: l_date_format_mask VARCHAR2(30) := p_date_format_mask;
292: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
293: template_id NUMBER := x_header_rec.contract_template_id;
294: BEGIN
295:
296: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.CHANGE_ATTRIBUTES', 1);

Line 296: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.CHANGE_ATTRIBUTES', 1);

292: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
293: template_id NUMBER := x_header_rec.contract_template_id;
294: BEGIN
295:
296: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.CHANGE_ATTRIBUTES', 1);
297: oe_debug_pub.add('hash template id in change att start is '|| x_header_rec.contract_template_id);
298: -- Set the UI flag
299: OE_GLOBALS.G_UI_FLAG := TRUE;
300:

Line 297: oe_debug_pub.add('hash template id in change att start is '|| x_header_rec.contract_template_id);

293: template_id NUMBER := x_header_rec.contract_template_id;
294: BEGIN
295:
296: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.CHANGE_ATTRIBUTES', 1);
297: oe_debug_pub.add('hash template id in change att start is '|| x_header_rec.contract_template_id);
298: -- Set the UI flag
299: OE_GLOBALS.G_UI_FLAG := TRUE;
300:
301: -- Set control flags.

Line 325: oe_debug_pub.add('hash template id in change att after get_header is '|| x_header_rec.contract_template_id);

321: ( p_db_record => FALSE
322: , p_header_id => p_header_id
323: , x_header_rec => x_header_rec
324: );
325: oe_debug_pub.add('hash template id in change att after get_header is '|| x_header_rec.contract_template_id);
326: x_header_rec.contract_template_id :=template_id;
327: x_old_header_rec := x_header_rec;
328:
329: IF OE_CODE_CONTROL.Code_Release_Level >= '110509' THEN

Line 332: oe_debug_pub.add( 'Code Release is >= 11.5.9') ;

328:
329: IF OE_CODE_CONTROL.Code_Release_Level >= '110509' THEN
330:
331: IF l_debug_level > 0 THEN
332: oe_debug_pub.add( 'Code Release is >= 11.5.9') ;
333: END IF;
334:
335:
336: Copy_Attribute_To_Rec

Line 365: oe_debuG_pub.add('attri id'||p_attr_id);

361: -- COPY_ATTRIBUTE_TO_REC ALSO. THIS NEW PROCEDURE WILL REPLACE
362: -- THESE CALLS POST OM PACK I OR 11.5.9.
363:
364:
365: oe_debuG_pub.add('attri id'||p_attr_id);
366: oe_debug_pub.add('attr val ksur'||p_attr_value);
367: IF p_attr_id = OE_Header_Util.G_ACCOUNTING_RULE THEN
368: x_header_rec.accounting_rule_id := TO_NUMBER(p_attr_value);
369: ELSIF p_attr_id = OE_Header_Util.G_ACCOUNTING_RULE_DURATION THEN

Line 366: oe_debug_pub.add('attr val ksur'||p_attr_value);

362: -- THESE CALLS POST OM PACK I OR 11.5.9.
363:
364:
365: oe_debuG_pub.add('attri id'||p_attr_id);
366: oe_debug_pub.add('attr val ksur'||p_attr_value);
367: IF p_attr_id = OE_Header_Util.G_ACCOUNTING_RULE THEN
368: x_header_rec.accounting_rule_id := TO_NUMBER(p_attr_value);
369: ELSIF p_attr_id = OE_Header_Util.G_ACCOUNTING_RULE_DURATION THEN
370: x_header_rec.accounting_rule_duration := TO_NUMBER(p_attr_value);

Line 739: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.CHANGE_ATTRIBUTES'||x_header_rec.sold_to_phone_id, 1);

735: x_header_rec.operation := OE_GLOBALS.G_OPR_CREATE;
736: END IF;
737:
738: -- Call Oe_Order_Pvt.Header
739: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.CHANGE_ATTRIBUTES'||x_header_rec.sold_to_phone_id, 1);
740: oe_debug_pub.add('hash template id in change att before invoice is '|| x_header_rec.contract_template_id);
741: oe_debug_pub.add('Entering invoice'||x_header_rec.invoice_to_org_id, 1);
742: oe_debug_pub.add('Entering Invoice'||x_old_header_rec.invoice_to_org_id, 1);
743:

Line 740: oe_debug_pub.add('hash template id in change att before invoice is '|| x_header_rec.contract_template_id);

736: END IF;
737:
738: -- Call Oe_Order_Pvt.Header
739: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.CHANGE_ATTRIBUTES'||x_header_rec.sold_to_phone_id, 1);
740: oe_debug_pub.add('hash template id in change att before invoice is '|| x_header_rec.contract_template_id);
741: oe_debug_pub.add('Entering invoice'||x_header_rec.invoice_to_org_id, 1);
742: oe_debug_pub.add('Entering Invoice'||x_old_header_rec.invoice_to_org_id, 1);
743:
744: Oe_Order_Pvt.Header

Line 741: oe_debug_pub.add('Entering invoice'||x_header_rec.invoice_to_org_id, 1);

737:
738: -- Call Oe_Order_Pvt.Header
739: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.CHANGE_ATTRIBUTES'||x_header_rec.sold_to_phone_id, 1);
740: oe_debug_pub.add('hash template id in change att before invoice is '|| x_header_rec.contract_template_id);
741: oe_debug_pub.add('Entering invoice'||x_header_rec.invoice_to_org_id, 1);
742: oe_debug_pub.add('Entering Invoice'||x_old_header_rec.invoice_to_org_id, 1);
743:
744: Oe_Order_Pvt.Header
745: (

Line 742: oe_debug_pub.add('Entering Invoice'||x_old_header_rec.invoice_to_org_id, 1);

738: -- Call Oe_Order_Pvt.Header
739: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.CHANGE_ATTRIBUTES'||x_header_rec.sold_to_phone_id, 1);
740: oe_debug_pub.add('hash template id in change att before invoice is '|| x_header_rec.contract_template_id);
741: oe_debug_pub.add('Entering invoice'||x_header_rec.invoice_to_org_id, 1);
742: oe_debug_pub.add('Entering Invoice'||x_old_header_rec.invoice_to_org_id, 1);
743:
744: Oe_Order_Pvt.Header
745: (
746: p_validation_level => FND_API.G_VALID_LEVEL_NONE

Line 753: oe_debug_pub.add('Exiting invoice'||x_header_rec.invoice_to_org_id, 1);

749: , p_x_header_rec => x_header_rec
750: , p_x_old_header_rec => x_old_header_rec
751: , x_return_status => l_return_status
752: );
753: oe_debug_pub.add('Exiting invoice'||x_header_rec.invoice_to_org_id, 1);
754: oe_debug_pub.add('Exiting invoice'||x_old_header_rec.invoice_to_org_id, 1);
755: --oe_debug_pub.add('Holder name new'||x_header_rec.credit_card_holder_name);
756: --oe_debug_pub.add('Holder name old'||x_old_header_rec.credit_card_holder_name);
757:

Line 754: oe_debug_pub.add('Exiting invoice'||x_old_header_rec.invoice_to_org_id, 1);

750: , p_x_old_header_rec => x_old_header_rec
751: , x_return_status => l_return_status
752: );
753: oe_debug_pub.add('Exiting invoice'||x_header_rec.invoice_to_org_id, 1);
754: oe_debug_pub.add('Exiting invoice'||x_old_header_rec.invoice_to_org_id, 1);
755: --oe_debug_pub.add('Holder name new'||x_header_rec.credit_card_holder_name);
756: --oe_debug_pub.add('Holder name old'||x_old_header_rec.credit_card_holder_name);
757:
758: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 755: --oe_debug_pub.add('Holder name new'||x_header_rec.credit_card_holder_name);

751: , x_return_status => l_return_status
752: );
753: oe_debug_pub.add('Exiting invoice'||x_header_rec.invoice_to_org_id, 1);
754: oe_debug_pub.add('Exiting invoice'||x_old_header_rec.invoice_to_org_id, 1);
755: --oe_debug_pub.add('Holder name new'||x_header_rec.credit_card_holder_name);
756: --oe_debug_pub.add('Holder name old'||x_old_header_rec.credit_card_holder_name);
757:
758: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 756: --oe_debug_pub.add('Holder name old'||x_old_header_rec.credit_card_holder_name);

752: );
753: oe_debug_pub.add('Exiting invoice'||x_header_rec.invoice_to_org_id, 1);
754: oe_debug_pub.add('Exiting invoice'||x_old_header_rec.invoice_to_org_id, 1);
755: --oe_debug_pub.add('Holder name new'||x_header_rec.credit_card_holder_name);
756: --oe_debug_pub.add('Holder name old'||x_old_header_rec.credit_card_holder_name);
757:
758: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
760: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 783: oe_debug_pub.add('instr id in fhpmb'||x_header_rec.cc_instrument_id);

779: --OE_Default_Pvt package
780:
781: IF OE_Default_Pvt.g_default_instrument_id IS NOT NULL THEN
782: x_header_rec.cc_instrument_id := OE_Default_Pvt.g_default_instrument_id;
783: oe_debug_pub.add('instr id in fhpmb'||x_header_rec.cc_instrument_id);
784: --Setting the value of assignment id to null
785: --after passing the value to the library
786: OE_Default_Pvt.g_default_instrument_id := null;
787: END IF;

Line 791: oe_debug_pub.add('assign id in fhpmb'||x_header_rec.cc_instrument_assignment_id );

787: END IF;
788:
789: IF OE_Default_Pvt.g_default_instr_assignment_id IS NOT NULL THEN
790: x_header_rec.cc_instrument_assignment_id := OE_Default_Pvt.g_default_instr_assignment_id;
791: oe_debug_pub.add('assign id in fhpmb'||x_header_rec.cc_instrument_assignment_id );
792: --Setting the value of assignment id to null
793: --after passing the value to the library
794: OE_Default_Pvt.g_default_instr_assignment_id := null;
795: END IF;

Line 817: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.CHANGE_ATTRIBUTES', 1);

813: ( p_count => x_msg_count
814: , p_data => x_msg_data
815: );
816:
817: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.CHANGE_ATTRIBUTES', 1);
818:
819: EXCEPTION
820:
821: WHEN FND_API.G_EXC_ERROR THEN

Line 907: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.VALIDATE_AND_WRITE', 1);

903: BEGIN
904:
905: SAVEPOINT Header_Validate_And_Write;
906: OE_HEADER_UTIL.g_rollback_done := 'N'; -- bug 12759791
907: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.VALIDATE_AND_WRITE', 1);
908:
909: -- Set the UI flag
910: OE_GLOBALS.G_UI_FLAG := TRUE;
911:

Line 1024: oe_debug_pub.add('ksurendr Freight terms code after PO'||x_freight_terms_code, 1);

1020: (p_ship_method_code =>l_x_header_rec.shipping_method_code
1021: );
1022: --bug 4348011
1023: x_freight_terms_code := l_x_header_rec.freight_terms_code;
1024: oe_debug_pub.add('ksurendr Freight terms code after PO'||x_freight_terms_code, 1);
1025: x_freight_terms := OE_ID_TO_VALUE.Freight_Terms
1026: (p_freight_terms_code => l_x_header_rec.freight_terms_code);
1027: x_payment_term_id := l_x_header_rec.payment_term_id;
1028: x_payment_term := OE_ID_TO_VALUE.Payment_Term

Line 1053: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.VALIDATE_AND_WRITE', 1);

1049: ( p_count => x_msg_count
1050: , p_data => x_msg_data
1051: );
1052:
1053: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.VALIDATE_AND_WRITE', 1);
1054:
1055: EXCEPTION
1056:
1057: WHEN FND_API.G_EXC_ERROR THEN

Line 1129: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.DELETE_ROW', 1);

1125: l_return_status VARCHAR2(1);
1126: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1127: BEGIN
1128: SAVEPOINT Header_Delete;
1129: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.DELETE_ROW', 1);
1130:
1131: -- Set the UI flag
1132: OE_GLOBALS.G_UI_FLAG := TRUE;
1133:

Line 1199: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.DELETE_ROW', 1);

1195: ( p_count => x_msg_count
1196: , p_data => x_msg_data
1197: );
1198:
1199: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.DELETE_ROW', 1);
1200:
1201: EXCEPTION
1202:
1203: WHEN FND_API.G_EXC_ERROR THEN

Line 1266: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.PROCESS_ENTITY', 1);

1262: IS
1263: l_return_status VARCHAR2(1);
1264: BEGIN
1265:
1266: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.PROCESS_ENTITY', 1);
1267:
1268: -- Set the UI flag
1269: OE_GLOBALS.G_UI_FLAG := TRUE;
1270:

Line 1302: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.PROCESS_ENTITY', 1);

1298: ( p_count => x_msg_count
1299: , p_data => x_msg_data
1300: );
1301:
1302: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.PROCESS_ENTITY', 1);
1303:
1304: EXCEPTION
1305:
1306: WHEN FND_API.G_EXC_ERROR THEN

Line 1369: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.PROCESS_OBJECT', 1);

1365: l_return_status VARCHAR2(1);
1366: l_control_rec OE_GLOBALS.Control_Rec_Type;
1367: l_line_tbl oe_order_pub.line_tbl_type;
1368: BEGIN
1369: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.PROCESS_OBJECT', 1);
1370:
1371: OE_MSG_PUB.initialize;
1372:
1373: IF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >='110510' THEN

Line 1448: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.PROCESS_OBJECT', 1);

1444:
1445: OE_GLOBALS.G_UI_FLAG := FALSE;
1446: OE_GLOBALS.G_PROCESS_OBJECTS_FLAG := FALSE;
1447:
1448: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.PROCESS_OBJECT', 1);
1449:
1450: EXCEPTION
1451:
1452: WHEN FND_API.G_EXC_ERROR THEN

Line 1517: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.LOCK_ROW', 1);

1513: l_return_status VARCHAR2(1);
1514: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1515: BEGIN
1516:
1517: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.LOCK_ROW', 1);
1518:
1519: -- Load header record
1520:
1521: l_x_header_rec.lock_control := p_lock_control;

Line 1527: oe_debug_pub.add('header_id'|| l_x_header_rec.header_id, 1);

1523: l_x_header_rec.operation := OE_GLOBALS.G_OPR_LOCK; -- not req.
1524:
1525: -- Call OE_Header_Util.Lock_Row instead of Oe_Order_Pvt.Lock_order
1526:
1527: oe_debug_pub.add('header_id'|| l_x_header_rec.header_id, 1);
1528:
1529: OE_MSG_PUB.initialize;
1530: OE_Header_Util.Lock_Row
1531: ( x_return_status => l_return_status

Line 1564: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.LOCK_ROW', 1);

1560: ( p_count => x_msg_count
1561: , p_data => x_msg_data
1562: );
1563:
1564: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.LOCK_ROW', 1);
1565:
1566: EXCEPTION
1567: WHEN FND_API.G_EXC_ERROR THEN
1568:

Line 1622: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.WRITE_HEADER', 1);

1618: )
1619: IS
1620: BEGIN
1621:
1622: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.WRITE_HEADER', 1);
1623:
1624: g_header_rec := p_header_rec;
1625:
1626: IF p_db_record THEN

Line 1632: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.WRITE_HEADER', 1);

1628: g_db_header_rec := p_header_rec;
1629:
1630: END IF;
1631:
1632: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.WRITE_HEADER', 1);
1633:
1634: END Write_Header;
1635:
1636: PROCEDURE Get_header

Line 1645: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.GET_HEADER', 1);

1641: IS
1642:
1643: BEGIN
1644:
1645: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.GET_HEADER', 1);
1646:
1647: IF p_header_id <> NVL(g_header_rec.header_id,FND_API.G_MISS_NUM)
1648: THEN
1649:

Line 1675: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.GET_HEADER', 1);

1671: x_header_rec:= g_header_rec;
1672:
1673: END IF;
1674:
1675: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.GET_HEADER', 1);
1676:
1677: END Get_Header;
1678:
1679: PROCEDURE Clear_Header

Line 1683: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.CLEAR_HEADER', 1);

1679: PROCEDURE Clear_Header
1680: IS
1681: BEGIN
1682:
1683: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.CLEAR_HEADER', 1);
1684:
1685: g_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;
1686: g_db_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;
1687:

Line 1688: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.CLEAR_HEADER', 1);

1684:
1685: g_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;
1686: g_db_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;
1687:
1688: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.CLEAR_HEADER', 1);
1689:
1690: END Clear_Header;
1691:
1692:

Line 1722: oe_debug_pub.add('Request does not exist, reset versioning globals'); IF (NOT OE_Versioning_Util.Reset_Globals) THEN

1718: );
1719:
1720: IF OE_GLOBALS.G_ROLL_VERSION <> 'N' THEN
1721:
1722: oe_debug_pub.add('Request does not exist, reset versioning globals'); IF (NOT OE_Versioning_Util.Reset_Globals) THEN
1723: l_return_status := FND_API.G_RET_STS_ERROR;
1724: RETURN;
1725: END IF;
1726: END IF;

Line 1806: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.SALES_PERSON', 1);

1802: and line_id is null;
1803: l_count Number;
1804: Begin
1805:
1806: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.SALES_PERSON', 1);
1807:
1808: OE_MSG_PUB.initialize;
1809: x_return_status := FND_API.G_RET_STS_SUCCESS;
1810: p_multiple_sales_credits := 'N';

Line 1837: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.SALES_PERSON', 1);

1833: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1834: RAISE FND_API.G_EXC_ERROR;
1835: END IF;
1836:
1837: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.SALES_PERSON', 1);
1838:
1839: EXCEPTION
1840:
1841: WHEN FND_API.G_EXC_ERROR THEN

Line 1884: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.GET_FORM_STARTUP_VALUES', 1);

1880: FROM fnd_id_flex_structures
1881: WHERE id_flex_code = X_Id_Flex_Code;
1882: BEGIN
1883:
1884: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.GET_FORM_STARTUP_VALUES', 1);
1885:
1886: OPEN C_Item_Flex(Item_Id_Flex_Code);
1887: FETCH C_Item_Flex INTO Item_Id_Flex_Num;
1888: CLOSE C_Item_Flex;

Line 1890: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.GET_FORM_STARTUP_VALUES', 1);

1886: OPEN C_Item_Flex(Item_Id_Flex_Code);
1887: FETCH C_Item_Flex INTO Item_Id_Flex_Num;
1888: CLOSE C_Item_Flex;
1889:
1890: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.GET_FORM_STARTUP_VALUES', 1);
1891:
1892: EXCEPTION
1893: WHEN OTHERS THEN
1894: oe_debug_pub.add('In when others exception : OE_OE_FORM_HEADER.GET_FORM_STARTUP_VALUES', 1);

Line 1894: oe_debug_pub.add('In when others exception : OE_OE_FORM_HEADER.GET_FORM_STARTUP_VALUES', 1);

1890: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.GET_FORM_STARTUP_VALUES', 1);
1891:
1892: EXCEPTION
1893: WHEN OTHERS THEN
1894: oe_debug_pub.add('In when others exception : OE_OE_FORM_HEADER.GET_FORM_STARTUP_VALUES', 1);
1895: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1896: THEN
1897: OE_MSG_PUB.Add_Exc_Msg
1898: ( G_PKG_NAME ,

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

1983: x_check_number varchar2(100);
1984: l_return_status VARCHAR2(30) := NULL ;
1985: l_msg_count NUMBER := 0 ;
1986: l_msg_data VARCHAR2(2000) := NULL ;
1987: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1988: --R12 CC Encryption
1989:
1990: BEGIN
1991: if l_debug_level > 0 then

Line 1992: oe_debug_pub.add('Entering OE_OE_Form_Header.Populate_Control_Fields');

1988: --R12 CC Encryption
1989:
1990: BEGIN
1991: if l_debug_level > 0 then
1992: oe_debug_pub.add('Entering OE_OE_Form_Header.Populate_Control_Fields');
1993: oe_debug_pub.add('Header id'||p_header_rec_type.header_id);
1994: end if;
1995:
1996: IF p_header_rec_type.salesrep_id is not null THEN

Line 1993: oe_debug_pub.add('Header id'||p_header_rec_type.header_id);

1989:
1990: BEGIN
1991: if l_debug_level > 0 then
1992: oe_debug_pub.add('Entering OE_OE_Form_Header.Populate_Control_Fields');
1993: oe_debug_pub.add('Header id'||p_header_rec_type.header_id);
1994: end if;
1995:
1996: IF p_header_rec_type.salesrep_id is not null THEN
1997: BEGIN

Line 2568: oe_debug_pub.add('prepaid_amount: '||x_header_val_rec.prepaid_amount||' And commitment_amount: '||l_commitment_amount);

2564: EXCEPTION
2565: WHEN NO_DATA_FOUND THEN
2566: l_commitment_amount := 0;
2567: END;
2568: oe_debug_pub.add('prepaid_amount: '||x_header_val_rec.prepaid_amount||' And commitment_amount: '||l_commitment_amount);
2569: x_header_val_rec.pending_amount := NVL(x_header_val_rec.subtotal,0)+NVL(x_header_val_rec.charges,0)+NVL(x_header_val_rec.tax,0) - NVL(x_header_val_rec.prepaid_amount, 0) - l_commitment_amount;
2570: oe_debug_pub.add('pending_amount: '||x_header_val_rec.pending_amount);
2571: ELSE
2572: x_header_val_rec.pending_amount := NULL;

Line 2570: oe_debug_pub.add('pending_amount: '||x_header_val_rec.pending_amount);

2566: l_commitment_amount := 0;
2567: END;
2568: oe_debug_pub.add('prepaid_amount: '||x_header_val_rec.prepaid_amount||' And commitment_amount: '||l_commitment_amount);
2569: x_header_val_rec.pending_amount := NVL(x_header_val_rec.subtotal,0)+NVL(x_header_val_rec.charges,0)+NVL(x_header_val_rec.tax,0) - NVL(x_header_val_rec.prepaid_amount, 0) - l_commitment_amount;
2570: oe_debug_pub.add('pending_amount: '||x_header_val_rec.pending_amount);
2571: ELSE
2572: x_header_val_rec.pending_amount := NULL;
2573: END IF;
2574:

Line 2603: oe_debug_pub.add('payment_type_code in populate control fields'||p_header_rec_type.payment_type_code);

2599: END IF;
2600:
2601: --R12 CC Encryption
2602: if l_debug_level > 0 then
2603: oe_debug_pub.add('payment_type_code in populate control fields'||p_header_rec_type.payment_type_code);
2604: oe_debug_pub.add('Header id'||p_header_rec_type.header_id);
2605: end if;
2606:
2607: IF p_header_rec_type.payment_type_code IN ('CREDIT_CARD') THEN

Line 2604: oe_debug_pub.add('Header id'||p_header_rec_type.header_id);

2600:
2601: --R12 CC Encryption
2602: if l_debug_level > 0 then
2603: oe_debug_pub.add('payment_type_code in populate control fields'||p_header_rec_type.payment_type_code);
2604: oe_debug_pub.add('Header id'||p_header_rec_type.header_id);
2605: end if;
2606:
2607: IF p_header_rec_type.payment_type_code IN ('CREDIT_CARD') THEN
2608:

Line 2677: oe_debug_pub.add('After calling OE_Header_Util.Query_card_details');

2673: x_header_val_rec.instrument_security_code := l_instrument_security_code;
2674: x_header_val_rec.cc_instrument_id := l_instrument_id;
2675: x_header_val_rec.cc_instrument_assignment_id := l_instrument_assignment_id;
2676:
2677: oe_debug_pub.add('After calling OE_Header_Util.Query_card_details');
2678: oe_debug_pub.add('Security code'||x_header_val_rec.instrument_security_code);
2679: --oe_debug_pub.add('Credit card code in populate control fields'||x_header_val_rec.credit_card_code);
2680: BEGIN
2681: IF x_header_val_rec.credit_card_code is not null then

Line 2678: oe_debug_pub.add('Security code'||x_header_val_rec.instrument_security_code);

2674: x_header_val_rec.cc_instrument_id := l_instrument_id;
2675: x_header_val_rec.cc_instrument_assignment_id := l_instrument_assignment_id;
2676:
2677: oe_debug_pub.add('After calling OE_Header_Util.Query_card_details');
2678: oe_debug_pub.add('Security code'||x_header_val_rec.instrument_security_code);
2679: --oe_debug_pub.add('Credit card code in populate control fields'||x_header_val_rec.credit_card_code);
2680: BEGIN
2681: IF x_header_val_rec.credit_card_code is not null then
2682: x_header_val_rec.credit_card := OE_Id_To_Value.Credit_Card

Line 2679: --oe_debug_pub.add('Credit card code in populate control fields'||x_header_val_rec.credit_card_code);

2675: x_header_val_rec.cc_instrument_assignment_id := l_instrument_assignment_id;
2676:
2677: oe_debug_pub.add('After calling OE_Header_Util.Query_card_details');
2678: oe_debug_pub.add('Security code'||x_header_val_rec.instrument_security_code);
2679: --oe_debug_pub.add('Credit card code in populate control fields'||x_header_val_rec.credit_card_code);
2680: BEGIN
2681: IF x_header_val_rec.credit_card_code is not null then
2682: x_header_val_rec.credit_card := OE_Id_To_Value.Credit_Card
2683: ( p_credit_card_code => x_header_val_rec.credit_card_code

Line 2718: l_debug_level NUMBER := oe_debug_pub.g_debug_level; -- cc project

2714: FUNCTION Load_Set_Of_Books
2715: RETURN Set_Of_Books_Rec_Type
2716: IS
2717: l_set_of_books_id NUMBER := NULL;
2718: l_debug_level NUMBER := oe_debug_pub.g_debug_level; -- cc project
2719: BEGIN
2720: /* commenting below line for cc project*/
2721: -- OE_DEBUG_PUB.G_DEBUG_LEVEL:=0;
2722: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_SET_OF_BOOKS', 1);

Line 2721: -- OE_DEBUG_PUB.G_DEBUG_LEVEL:=0;

2717: l_set_of_books_id NUMBER := NULL;
2718: l_debug_level NUMBER := oe_debug_pub.g_debug_level; -- cc project
2719: BEGIN
2720: /* commenting below line for cc project*/
2721: -- OE_DEBUG_PUB.G_DEBUG_LEVEL:=0;
2722: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_SET_OF_BOOKS', 1);
2723:
2724: -- Get set_of_books_id from profile option.
2725:

Line 2722: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_SET_OF_BOOKS', 1);

2718: l_debug_level NUMBER := oe_debug_pub.g_debug_level; -- cc project
2719: BEGIN
2720: /* commenting below line for cc project*/
2721: -- OE_DEBUG_PUB.G_DEBUG_LEVEL:=0;
2722: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_SET_OF_BOOKS', 1);
2723:
2724: -- Get set_of_books_id from profile option.
2725:
2726: --l_set_of_books_id := FND_PROFILE.VALUE('OE_SET_OF_BOOKS_ID');

Line 2740: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_SET_OF_BOOKS', 1);

2736: FROM OE_GL_SETS_OF_BOOKS_V
2737: WHERE SET_OF_BOOKS_ID = l_set_of_books_id;
2738:
2739: END IF;
2740: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_SET_OF_BOOKS', 1);
2741:
2742: RETURN g_set_of_books_rec;
2743:
2744: EXCEPTION

Line 2824: OE_DEBUG_PUB.G_DEBUG_LEVEL:=0;

2820: PROCEDURE RESET_DEBUG_LEVEL
2821: IS
2822:
2823: BEGIN
2824: OE_DEBUG_PUB.G_DEBUG_LEVEL:=0;
2825:
2826: END RESET_DEBUG_LEVEL;
2827:
2828:

Line 2833: OE_DEBUG_PUB.G_DEBUG_LEVEL:=p_debug_level;

2829: PROCEDURE SET_DEBUG_LEVEL (p_debug_level IN NUMBER)
2830: IS
2831:
2832: BEGIN
2833: OE_DEBUG_PUB.G_DEBUG_LEVEL:=p_debug_level;
2834:
2835: END SET_DEBUG_LEVEL;
2836:
2837:

Line 2896: oe_debug_pub.add('Entering OE_OE_FOR_HEADER.Cascade Attribute');

2892: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
2893: --serla end
2894: BEGIN
2895: SAVEPOINT Header_Cascade_Attributes;
2896: oe_debug_pub.add('Entering OE_OE_FOR_HEADER.Cascade Attribute');
2897: IF NOT OE_Globals.Equal(
2898: p_header_rec.cust_po_number,
2899: p_old_db_header_rec.cust_po_number) OR
2900: NOT OE_Globals.Equal(

Line 3265: oe_debug_pub.add('Entering OE_OE_FOR_HEADER.Cascade Attribute-Before PO');

3261: END IF; -- Cascade Only if Line is Open
3262: END LOOP;
3263:
3264: END IF;
3265: oe_debug_pub.add('Entering OE_OE_FOR_HEADER.Cascade Attribute-Before PO');
3266:
3267: -- Added for cascading in Mass Change ER 7509356
3268: IF OE_MASS_CHANGE_PVT.IS_MASS_CHANGE = 'T' THEN
3269: l_init_msg_list := FND_API.G_FALSE;

Line 3304: oe_debug_pub.add('Entering OE_OE_FOR_HEADER.Cascade Attribute-After PO');

3300: , p_x_lot_serial_tbl => l_x_lot_serial_tbl
3301:
3302: );
3303:
3304: oe_debug_pub.add('Entering OE_OE_FOR_HEADER.Cascade Attribute-After PO');
3305:
3306:
3307: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3464: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.Create_Agreement', 1);

3460:
3461: BEGIN
3462:
3463:
3464: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.Create_Agreement', 1);
3465:
3466: p_Agreement_rec.name := p_agreement_name;
3467: p_agreement_rec.creation_date :=sysdate;
3468: p_agreement_rec.created_by := FND_GLOBAL.USER_ID;

Line 3482: oe_debug_pub.add('Before Process_Agreement', 1);

3478: p_agreement_rec.agreement_id := FND_API.G_MISS_NUM;
3479: p_agreement_rec.operation := QP_GLOBALS.G_OPR_CREATE;
3480: p_agreement_rec.price_list_id := p_price_list_id;
3481: p_agreement_rec.sold_to_org_id := p_sold_to_org_id;
3482: oe_debug_pub.add('Before Process_Agreement', 1);
3483:
3484: OE_Pricing_Cont_PUB.Process_Agreement
3485: ( p_api_version_number => 1.0
3486:

Line 3504: oe_debug_pub.add('After Process_Agreement', 1);

3500: , x_Price_LLine_val_tbl => x_price_list_line_val_tbl
3501: , x_Pricing_Attr_tbl => x_pricing_attr_tbl
3502: , x_Pricing_Attr_val_tbl => x_pricing_attr_val_tbl
3503: );
3504: oe_debug_pub.add('After Process_Agreement', 1);
3505:
3506:
3507: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3513: oe_debug_pub.add('Before Commit', 1);

3509: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3510: RAISE FND_API.G_EXC_ERROR;
3511:
3512: END IF;
3513: oe_debug_pub.add('Before Commit', 1);
3514:
3515: COMMIT;
3516: oe_debug_pub.add('After Commit', 1);
3517:

Line 3516: oe_debug_pub.add('After Commit', 1);

3512: END IF;
3513: oe_debug_pub.add('Before Commit', 1);
3514:
3515: COMMIT;
3516: oe_debug_pub.add('After Commit', 1);
3517:
3518: EXCEPTION
3519:
3520: WHEN FND_API.G_EXC_ERROR THEN

Line 3558: oe_debug_pub.add('hash before prn');

3554: PROCEDURE Clear_Global_PO_Cache IS
3555: l_return_status VARCHAR2(1);
3556: BEGIN
3557:
3558: oe_debug_pub.add('hash before prn');
3559:
3560: -- bug 3588660
3561: IF OE_CODE_CONTROL.Code_Release_Level >= '110508' THEN
3562:

Line 3573: oe_debug_pub.add('hash calling prn');

3569: OR OE_ORDER_UTIL.g_Line_Adj_tbl.count >0
3570: OR OE_ORDER_UTIL.g_Line_Scredit_tbl.count >0
3571: OR OE_ORDER_UTIL.g_Lot_Serial_tbl.count >0 ) THEN
3572:
3573: oe_debug_pub.add('hash calling prn');
3574:
3575: OE_Order_PVT.Process_Requests_And_Notify
3576: ( p_process_requests => TRUE
3577: , p_notify => FALSE

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

3615: )
3616: IS
3617: l_date_format_mask VARCHAR2(30) := p_date_format_mask;
3618: --
3619: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3620: --
3621: BEGIN
3622: IF p_attr_id = OE_Header_Util.G_ACCOUNTING_RULE THEN
3623: x_header_rec.accounting_rule_id := TO_NUMBER(p_attr_value);

Line 4038: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.Validate_Phone_Number', 1);

4034: l_phone_format Varchar2(300);
4035: l_AR_Sys_Param_Rec AR_SYSTEM_PARAMETERS_ALL%ROWTYPE;
4036:
4037: BEGIN
4038: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.Validate_Phone_Number', 1);
4039: IF OE_OE_FORM_HEADER.G_HZ_H_Installed IS NULL THEN
4040: SELECT COUNT(bug_id)
4041: INTO l_bug_count
4042: FROM ad_bugs where bug_number IN ('2116159','2239222','2488745');

Line 4049: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.Validate_Phone_Number-HZ Minipack'||OE_OE_FORM_HEADER.G_HZ_H_Installed, 1);

4045: ELSE
4046: OE_OE_FORM_HEADER.G_HZ_H_Installed:='N';
4047: END IF;
4048: END IF;
4049: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.Validate_Phone_Number-HZ Minipack'||OE_OE_FORM_HEADER.G_HZ_H_Installed, 1);
4050:
4051: IF OE_OE_FORM_HEADER.G_HZ_H_Installed='N' THEN
4052: x_valid:=TRUE;
4053: ELSE

Line 4093: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.Validate_Phone_Number-User Territory'||

4089: END IF;
4090: ELSE
4091: l_user_territory_code:=p_country_code;
4092: END IF;
4093: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.Validate_Phone_Number-User Territory'||
4094: l_user_territory_code, 1);
4095:
4096:
4097:

Line 4117: oe_debug_pub.add('Entering Validate_Phone_Number-1x'||l_total_count,1);

4113: select Count(territory_code)
4114: into l_total_count
4115: from hz_phone_formats
4116: where territory_code=l_user_territory_code;
4117: oe_debug_pub.add('Entering Validate_Phone_Number-1x'||l_total_count,1);
4118:
4119: IF l_count=0 AND l_total_count=0 THEN
4120: l_sql_stmt := 'SELECT Count(territory_code)'||
4121: ' FROM hz_phone_country_codes'||

Line 4132: oe_debug_pub.add('Entering Validate_Phone_Number-2x'||l_count,1);

4128: x_valid:=FALSE;
4129: ELSE
4130: x_valid:=TRUE;
4131: END IF;
4132: oe_debug_pub.add('Entering Validate_Phone_Number-2x'||l_count,1);
4133: ELSIF l_count=0 AND l_total_count<>0 THEN
4134: x_valid:=FALSE;
4135: ELSE
4136: x_valid:=TRUE;

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

4297: l_operation VARCHAR2(30);
4298: l_result NUMBER;
4299: l_rowtype_rec OE_AK_ORDER_HEADERS_V%ROWTYPE;
4300: l_action NUMBER;
4301: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4302: BEGIN
4303:
4304: IF l_debug_level > 0 THEN
4305: oe_debug_pub.add( 'ENTER OE_OE_FORM_HEADER.Check_Sec_Header_Attr' , 1 ) ;

Line 4305: oe_debug_pub.add( 'ENTER OE_OE_FORM_HEADER.Check_Sec_Header_Attr' , 1 ) ;

4301: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4302: BEGIN
4303:
4304: IF l_debug_level > 0 THEN
4305: oe_debug_pub.add( 'ENTER OE_OE_FORM_HEADER.Check_Sec_Header_Attr' , 1 ) ;
4306: END IF;
4307:
4308: IF p_column_name IS NOT NULL THEN
4309: -- Initializing return status to SUCCESS

Line 4359: oe_debug_pub.add( 'EXIT OE_OE_FORM_HEADER.Check_Sec_Header_Attr' , 1 ) ;

4355: ( p_count => x_msg_count
4356: , p_data => x_msg_data);
4357:
4358: IF l_debug_level > 0 THEN
4359: oe_debug_pub.add( 'EXIT OE_OE_FORM_HEADER.Check_Sec_Header_Attr' , 1 ) ;
4360: END IF;
4361:
4362: END Check_Sec_Header_Attr;
4363:

Line 4411: OE_DEBUG_PUB.ADD('Entering OE_OE_FORM_HEADER.Read_Cascadable_Fields',1);

4407:
4408:
4409: BEGIN
4410:
4411: OE_DEBUG_PUB.ADD('Entering OE_OE_FORM_HEADER.Read_Cascadable_Fields',1);
4412: l_lookup_code :='ACCOUNTING_RULE';
4413: open C_LOOKUP(l_lookup_code,l_lookup_type);
4414: fetch C_LOOKUP into l_enabled_flag;
4415: close C_LOOKUP;

Line 4607: OE_DEBUG_PUB.ADD('Exiting OE_OE_FORM_HEADER.Read_Cascadable_Fields',1);

4603: x_cascade_record:=p_cascade_record; -- Set the record
4604:
4605: x_cascade_record.p_cached:='Y'; -- Caching is done for this session
4606:
4607: OE_DEBUG_PUB.ADD('Exiting OE_OE_FORM_HEADER.Read_Cascadable_Fields',1);
4608:
4609: EXCEPTION
4610:
4611: WHEN NO_DATA_FOUND THEN