DBA Data[Home] [Help]

APPS.OE_ORDER_PVT dependencies on OE_HEADER_PAYMENT_UTIL

Line 1695: oe_debug_pub.add('Payment:before OE_Header_Payment_Util.Convert_Miss_To_Null', 5);

1691:
1692: -- Set missing old record elements to NULL.
1693:
1694: IF l_debug_level > 0 THEN
1695: oe_debug_pub.add('Payment:before OE_Header_Payment_Util.Convert_Miss_To_Null', 5);
1696: END IF;
1697: OE_Header_Payment_Util.Convert_Miss_To_Null (l_old_Header_Payment_rec);
1698: IF l_debug_level > 0 THEN
1699: oe_debug_pub.add('Payment:after OE_Header_Payment_Util.Convert_Miss_To_Null', 5);

Line 1697: OE_Header_Payment_Util.Convert_Miss_To_Null (l_old_Header_Payment_rec);

1693:
1694: IF l_debug_level > 0 THEN
1695: oe_debug_pub.add('Payment:before OE_Header_Payment_Util.Convert_Miss_To_Null', 5);
1696: END IF;
1697: OE_Header_Payment_Util.Convert_Miss_To_Null (l_old_Header_Payment_rec);
1698: IF l_debug_level > 0 THEN
1699: oe_debug_pub.add('Payment:after OE_Header_Payment_Util.Convert_Miss_To_Null', 5);
1700: END IF;
1701:

Line 1699: oe_debug_pub.add('Payment:after OE_Header_Payment_Util.Convert_Miss_To_Null', 5);

1695: oe_debug_pub.add('Payment:before OE_Header_Payment_Util.Convert_Miss_To_Null', 5);
1696: END IF;
1697: OE_Header_Payment_Util.Convert_Miss_To_Null (l_old_Header_Payment_rec);
1698: IF l_debug_level > 0 THEN
1699: oe_debug_pub.add('Payment:after OE_Header_Payment_Util.Convert_Miss_To_Null', 5);
1700: END IF;
1701:
1702: ELSIF l_Header_Payment_rec.operation = OE_GLOBALS.G_OPR_UPDATE
1703: OR l_Header_Payment_rec.operation = OE_GLOBALS.G_OPR_DELETE

Line 1715: oe_debug_pub.add('Payment:before OE_Header_Payment_Util.Query_Row', 5);

1711: OR l_old_Header_Payment_rec.payment_number IS NULL
1712: THEN
1713:
1714: IF l_debug_level > 0 THEN
1715: oe_debug_pub.add('Payment:before OE_Header_Payment_Util.Query_Row', 5);
1716: END IF;
1717: OE_Header_Payment_Util.Query_Row
1718: ( p_payment_number => l_Header_Payment_rec.payment_number
1719: , p_header_id => l_Header_Payment_rec.header_id

Line 1717: OE_Header_Payment_Util.Query_Row

1713:
1714: IF l_debug_level > 0 THEN
1715: oe_debug_pub.add('Payment:before OE_Header_Payment_Util.Query_Row', 5);
1716: END IF;
1717: OE_Header_Payment_Util.Query_Row
1718: ( p_payment_number => l_Header_Payment_rec.payment_number
1719: , p_header_id => l_Header_Payment_rec.header_id
1720: , x_header_payment_rec => l_old_Header_Payment_rec
1721: );

Line 1723: oe_debug_pub.add('Payment:after OE_Header_Payment_Util.Query_Row', 5);

1719: , p_header_id => l_Header_Payment_rec.header_id
1720: , x_header_payment_rec => l_old_Header_Payment_rec
1721: );
1722: IF l_debug_level > 0 THEN
1723: oe_debug_pub.add('Payment:after OE_Header_Payment_Util.Query_Row', 5);
1724: END IF;
1725:
1726: ELSE
1727:

Line 1731: oe_debug_pub.add('Payment:before OE_Header_Payment_Util.Convert_Miss_To_Null', 5);

1727:
1728: -- Set missing old record elements to NULL.
1729:
1730: IF l_debug_level > 0 THEN
1731: oe_debug_pub.add('Payment:before OE_Header_Payment_Util.Convert_Miss_To_Null', 5);
1732: END IF;
1733: OE_Header_Payment_Util.Convert_Miss_To_Null (l_old_Header_Payment_rec);
1734: IF l_debug_level > 0 THEN
1735: oe_debug_pub.add('Payment:after OE_Header_Payment_Util.Convert_Miss_To_Null', 5);

Line 1733: OE_Header_Payment_Util.Convert_Miss_To_Null (l_old_Header_Payment_rec);

1729:
1730: IF l_debug_level > 0 THEN
1731: oe_debug_pub.add('Payment:before OE_Header_Payment_Util.Convert_Miss_To_Null', 5);
1732: END IF;
1733: OE_Header_Payment_Util.Convert_Miss_To_Null (l_old_Header_Payment_rec);
1734: IF l_debug_level > 0 THEN
1735: oe_debug_pub.add('Payment:after OE_Header_Payment_Util.Convert_Miss_To_Null', 5);
1736: END IF;
1737:

Line 1735: oe_debug_pub.add('Payment:after OE_Header_Payment_Util.Convert_Miss_To_Null', 5);

1731: oe_debug_pub.add('Payment:before OE_Header_Payment_Util.Convert_Miss_To_Null', 5);
1732: END IF;
1733: OE_Header_Payment_Util.Convert_Miss_To_Null (l_old_Header_Payment_rec);
1734: IF l_debug_level > 0 THEN
1735: oe_debug_pub.add('Payment:after OE_Header_Payment_Util.Convert_Miss_To_Null', 5);
1736: END IF;
1737:
1738: END IF;
1739:

Line 1743: oe_debug_pub.add('Payment:before OE_Header_Payment_Util.Complete_Record', 5);

1739:
1740: -- Complete new record from old
1741:
1742: IF l_debug_level > 0 THEN
1743: oe_debug_pub.add('Payment:before OE_Header_Payment_Util.Complete_Record', 5);
1744: END IF;
1745: OE_Header_Payment_Util.Complete_Record
1746: ( p_x_Header_Payment_rec => l_Header_Payment_rec
1747: , p_old_Header_Payment_rec => l_old_Header_Payment_rec

Line 1745: OE_Header_Payment_Util.Complete_Record

1741:
1742: IF l_debug_level > 0 THEN
1743: oe_debug_pub.add('Payment:before OE_Header_Payment_Util.Complete_Record', 5);
1744: END IF;
1745: OE_Header_Payment_Util.Complete_Record
1746: ( p_x_Header_Payment_rec => l_Header_Payment_rec
1747: , p_old_Header_Payment_rec => l_old_Header_Payment_rec
1748: );
1749: IF l_debug_level > 0 THEN

Line 1750: oe_debug_pub.add('Payment:after OE_Header_Payment_Util.Complete_Record', 5);

1746: ( p_x_Header_Payment_rec => l_Header_Payment_rec
1747: , p_old_Header_Payment_rec => l_old_Header_Payment_rec
1748: );
1749: IF l_debug_level > 0 THEN
1750: oe_debug_pub.add('Payment:after OE_Header_Payment_Util.Complete_Record', 5);
1751: END IF;
1752:
1753: OE_MSG_PUB.update_msg_context(
1754: p_entity_code => 'HEADER_PAYMENT'

Line 1833: oe_debug_pub.add('Payment:before OE_Header_Payment_Util.Clear_Dependent_Attr', 5);

1829:
1830: IF l_control_rec.clear_dependents THEN
1831:
1832: IF l_debug_level > 0 THEN
1833: oe_debug_pub.add('Payment:before OE_Header_Payment_Util.Clear_Dependent_Attr', 5);
1834: END IF;
1835: OE_Header_Payment_Util.Clear_Dependent_Attr
1836: ( p_x_Header_Payment_rec => l_Header_Payment_rec
1837: , p_old_Header_Payment_rec => l_old_Header_Payment_rec

Line 1835: OE_Header_Payment_Util.Clear_Dependent_Attr

1831:
1832: IF l_debug_level > 0 THEN
1833: oe_debug_pub.add('Payment:before OE_Header_Payment_Util.Clear_Dependent_Attr', 5);
1834: END IF;
1835: OE_Header_Payment_Util.Clear_Dependent_Attr
1836: ( p_x_Header_Payment_rec => l_Header_Payment_rec
1837: , p_old_Header_Payment_rec => l_old_Header_Payment_rec
1838: );
1839: IF l_debug_level > 0 THEN

Line 1840: oe_debug_pub.add('Payment:after OE_Header_Payment_Util.Clear_Dependent_Attr', 5);

1836: ( p_x_Header_Payment_rec => l_Header_Payment_rec
1837: , p_old_Header_Payment_rec => l_old_Header_Payment_rec
1838: );
1839: IF l_debug_level > 0 THEN
1840: oe_debug_pub.add('Payment:after OE_Header_Payment_Util.Clear_Dependent_Attr', 5);
1841: END IF;
1842:
1843: END IF;
1844:

Line 1869: oe_debug_pub.add('Payment:before OE_Header_Payment_Util.Apply_Attribute_Changes', 5);

1865: IF l_control_rec.change_attributes
1866: THEN
1867:
1868: IF l_debug_level > 0 THEN
1869: oe_debug_pub.add('Payment:before OE_Header_Payment_Util.Apply_Attribute_Changes', 5);
1870: END IF;
1871: OE_Header_Payment_Util.Apply_Attribute_Changes
1872: ( p_x_Header_Payment_rec => l_Header_Payment_rec
1873: , p_old_Header_Payment_rec => l_old_Header_Payment_rec

Line 1871: OE_Header_Payment_Util.Apply_Attribute_Changes

1867:
1868: IF l_debug_level > 0 THEN
1869: oe_debug_pub.add('Payment:before OE_Header_Payment_Util.Apply_Attribute_Changes', 5);
1870: END IF;
1871: OE_Header_Payment_Util.Apply_Attribute_Changes
1872: ( p_x_Header_Payment_rec => l_Header_Payment_rec
1873: , p_old_Header_Payment_rec => l_old_Header_Payment_rec
1874: );
1875: IF l_debug_level > 0 THEN

Line 1876: oe_debug_pub.add('Payment:after OE_Header_Payment_Util.Apply_Attribute_Changes', 5);

1872: ( p_x_Header_Payment_rec => l_Header_Payment_rec
1873: , p_old_Header_Payment_rec => l_old_Header_Payment_rec
1874: );
1875: IF l_debug_level > 0 THEN
1876: oe_debug_pub.add('Payment:after OE_Header_Payment_Util.Apply_Attribute_Changes', 5);
1877: END IF;
1878:
1879: END IF;
1880:

Line 1970: oe_debug_pub.add('Payment:before Oe_Header_Payment_Util.Pre_Write_Process', 5);

1966: IF l_control_rec.write_to_db THEN
1967:
1968: /* Start Audit Trail */
1969: IF l_debug_level > 0 THEN
1970: oe_debug_pub.add('Payment:before Oe_Header_Payment_Util.Pre_Write_Process', 5);
1971: END IF;
1972: Oe_Header_Payment_Util.Pre_Write_Process
1973: (p_x_header_Payment_rec => l_header_payment_rec,
1974: p_old_header_payment_rec => l_old_header_payment_rec);

Line 1972: Oe_Header_Payment_Util.Pre_Write_Process

1968: /* Start Audit Trail */
1969: IF l_debug_level > 0 THEN
1970: oe_debug_pub.add('Payment:before Oe_Header_Payment_Util.Pre_Write_Process', 5);
1971: END IF;
1972: Oe_Header_Payment_Util.Pre_Write_Process
1973: (p_x_header_Payment_rec => l_header_payment_rec,
1974: p_old_header_payment_rec => l_old_header_payment_rec);
1975: IF l_debug_level > 0 THEN
1976: oe_debug_pub.add('Payment:after Oe_Header_Payment_Util.Pre_Write_Process', 5);

Line 1976: oe_debug_pub.add('Payment:after Oe_Header_Payment_Util.Pre_Write_Process', 5);

1972: Oe_Header_Payment_Util.Pre_Write_Process
1973: (p_x_header_Payment_rec => l_header_payment_rec,
1974: p_old_header_payment_rec => l_old_header_payment_rec);
1975: IF l_debug_level > 0 THEN
1976: oe_debug_pub.add('Payment:after Oe_Header_Payment_Util.Pre_Write_Process', 5);
1977: END IF;
1978: /* End AuditTrail */
1979:
1980: IF l_Header_Payment_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN

Line 1982: oe_debug_pub.add('Payment:before Oe_Header_Payment_Util.Delete_Row',5);

1978: /* End AuditTrail */
1979:
1980: IF l_Header_Payment_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
1981: IF l_debug_level > 0 THEN
1982: oe_debug_pub.add('Payment:before Oe_Header_Payment_Util.Delete_Row',5);
1983: END IF;
1984:
1985: OE_Header_Payment_Util.Delete_Row
1986: ( p_payment_number => l_Header_Payment_rec.payment_number

Line 1985: OE_Header_Payment_Util.Delete_Row

1981: IF l_debug_level > 0 THEN
1982: oe_debug_pub.add('Payment:before Oe_Header_Payment_Util.Delete_Row',5);
1983: END IF;
1984:
1985: OE_Header_Payment_Util.Delete_Row
1986: ( p_payment_number => l_Header_Payment_rec.payment_number
1987: , p_header_id => l_Header_Payment_rec.header_id
1988: );
1989: IF l_debug_level > 0 THEN

Line 1990: oe_debug_pub.add('Payment:after Oe_Header_Payment_Util.Delete_Row',5);

1986: ( p_payment_number => l_Header_Payment_rec.payment_number
1987: , p_header_id => l_Header_Payment_rec.header_id
1988: );
1989: IF l_debug_level > 0 THEN
1990: oe_debug_pub.add('Payment:after Oe_Header_Payment_Util.Delete_Row',5);
1991: END IF;
1992:
1993: ELSE
1994:

Line 2003: OE_Header_Payment_Util.Update_Row (l_Header_Payment_rec);

1999: l_Header_Payment_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
2000:
2001: IF l_Header_Payment_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2002:
2003: OE_Header_Payment_Util.Update_Row (l_Header_Payment_rec);
2004:
2005: ELSIF l_Header_Payment_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2006:
2007: l_Header_Payment_rec.creation_date := SYSDATE;

Line 2011: oe_debug_pub.add('Payment:before Oe_Header_Payment_Util.Insert_Row', 5);

2007: l_Header_Payment_rec.creation_date := SYSDATE;
2008: l_Header_Payment_rec.created_by := FND_GLOBAL.USER_ID;
2009:
2010: IF l_debug_level > 0 THEN
2011: oe_debug_pub.add('Payment:before Oe_Header_Payment_Util.Insert_Row', 5);
2012: END IF;
2013: OE_Header_Payment_Util.Insert_Row (l_Header_Payment_rec);
2014: IF l_debug_level > 0 THEN
2015: oe_debug_pub.add('Payment:after Oe_Header_Payment_Util.Insert_Row', 5);

Line 2013: OE_Header_Payment_Util.Insert_Row (l_Header_Payment_rec);

2009:
2010: IF l_debug_level > 0 THEN
2011: oe_debug_pub.add('Payment:before Oe_Header_Payment_Util.Insert_Row', 5);
2012: END IF;
2013: OE_Header_Payment_Util.Insert_Row (l_Header_Payment_rec);
2014: IF l_debug_level > 0 THEN
2015: oe_debug_pub.add('Payment:after Oe_Header_Payment_Util.Insert_Row', 5);
2016: END IF;
2017:

Line 2015: oe_debug_pub.add('Payment:after Oe_Header_Payment_Util.Insert_Row', 5);

2011: oe_debug_pub.add('Payment:before Oe_Header_Payment_Util.Insert_Row', 5);
2012: END IF;
2013: OE_Header_Payment_Util.Insert_Row (l_Header_Payment_rec);
2014: IF l_debug_level > 0 THEN
2015: oe_debug_pub.add('Payment:after Oe_Header_Payment_Util.Insert_Row', 5);
2016: END IF;
2017:
2018: END IF;
2019:

Line 10889: OE_Header_Payment_Util.Lock_Row

10885: WHILE I IS NOT NULL LOOP
10886:
10887: IF p_x_Header_Payment_tbl(I).operation = OE_GLOBALS.G_OPR_LOCK THEN
10888:
10889: OE_Header_Payment_Util.Lock_Row
10890: ( p_x_Header_Payment_rec => p_x_Header_Payment_tbl(I)
10891: , x_return_status => l_return_status
10892: );
10893:

Line 11398: OE_Header_Payment_Util.Query_Rows

11394:
11395: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
11396: -- Get Header_Payment ( parent = header )
11397:
11398: OE_Header_Payment_Util.Query_Rows
11399: ( p_header_id => p_header_id
11400: , x_Header_Payment_tbl => x_Header_Payment_tbl
11401: );
11402: END IF;