DBA Data[Home] [Help]

APPS.OE_ORDER_PVT dependencies on OE_HEADER_PAYMENT_UTIL

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

1654:
1655: -- Set missing old record elements to NULL.
1656:
1657: IF l_debug_level > 0 THEN
1658: oe_debug_pub.add('Payment:before OE_Header_Payment_Util.Convert_Miss_To_Null', 5);
1659: END IF;
1660: OE_Header_Payment_Util.Convert_Miss_To_Null (l_old_Header_Payment_rec);
1661: IF l_debug_level > 0 THEN
1662: oe_debug_pub.add('Payment:after OE_Header_Payment_Util.Convert_Miss_To_Null', 5);

Line 1660: OE_Header_Payment_Util.Convert_Miss_To_Null (l_old_Header_Payment_rec);

1656:
1657: IF l_debug_level > 0 THEN
1658: oe_debug_pub.add('Payment:before OE_Header_Payment_Util.Convert_Miss_To_Null', 5);
1659: END IF;
1660: OE_Header_Payment_Util.Convert_Miss_To_Null (l_old_Header_Payment_rec);
1661: IF l_debug_level > 0 THEN
1662: oe_debug_pub.add('Payment:after OE_Header_Payment_Util.Convert_Miss_To_Null', 5);
1663: END IF;
1664:

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

1658: oe_debug_pub.add('Payment:before OE_Header_Payment_Util.Convert_Miss_To_Null', 5);
1659: END IF;
1660: OE_Header_Payment_Util.Convert_Miss_To_Null (l_old_Header_Payment_rec);
1661: IF l_debug_level > 0 THEN
1662: oe_debug_pub.add('Payment:after OE_Header_Payment_Util.Convert_Miss_To_Null', 5);
1663: END IF;
1664:
1665: ELSIF l_Header_Payment_rec.operation = OE_GLOBALS.G_OPR_UPDATE
1666: OR l_Header_Payment_rec.operation = OE_GLOBALS.G_OPR_DELETE

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

1674: OR l_old_Header_Payment_rec.payment_number IS NULL
1675: THEN
1676:
1677: IF l_debug_level > 0 THEN
1678: oe_debug_pub.add('Payment:before OE_Header_Payment_Util.Query_Row', 5);
1679: END IF;
1680: OE_Header_Payment_Util.Query_Row
1681: ( p_payment_number => l_Header_Payment_rec.payment_number
1682: , p_header_id => l_Header_Payment_rec.header_id

Line 1680: OE_Header_Payment_Util.Query_Row

1676:
1677: IF l_debug_level > 0 THEN
1678: oe_debug_pub.add('Payment:before OE_Header_Payment_Util.Query_Row', 5);
1679: END IF;
1680: OE_Header_Payment_Util.Query_Row
1681: ( p_payment_number => l_Header_Payment_rec.payment_number
1682: , p_header_id => l_Header_Payment_rec.header_id
1683: , x_header_payment_rec => l_old_Header_Payment_rec
1684: );

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

1682: , p_header_id => l_Header_Payment_rec.header_id
1683: , x_header_payment_rec => l_old_Header_Payment_rec
1684: );
1685: IF l_debug_level > 0 THEN
1686: oe_debug_pub.add('Payment:after OE_Header_Payment_Util.Query_Row', 5);
1687: END IF;
1688:
1689: ELSE
1690:

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

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

Line 1696: OE_Header_Payment_Util.Convert_Miss_To_Null (l_old_Header_Payment_rec);

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

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

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

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

1702:
1703: -- Complete new record from old
1704:
1705: IF l_debug_level > 0 THEN
1706: oe_debug_pub.add('Payment:before OE_Header_Payment_Util.Complete_Record', 5);
1707: END IF;
1708: OE_Header_Payment_Util.Complete_Record
1709: ( p_x_Header_Payment_rec => l_Header_Payment_rec
1710: , p_old_Header_Payment_rec => l_old_Header_Payment_rec

Line 1708: OE_Header_Payment_Util.Complete_Record

1704:
1705: IF l_debug_level > 0 THEN
1706: oe_debug_pub.add('Payment:before OE_Header_Payment_Util.Complete_Record', 5);
1707: END IF;
1708: OE_Header_Payment_Util.Complete_Record
1709: ( p_x_Header_Payment_rec => l_Header_Payment_rec
1710: , p_old_Header_Payment_rec => l_old_Header_Payment_rec
1711: );
1712: IF l_debug_level > 0 THEN

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

1709: ( p_x_Header_Payment_rec => l_Header_Payment_rec
1710: , p_old_Header_Payment_rec => l_old_Header_Payment_rec
1711: );
1712: IF l_debug_level > 0 THEN
1713: oe_debug_pub.add('Payment:after OE_Header_Payment_Util.Complete_Record', 5);
1714: END IF;
1715:
1716: OE_MSG_PUB.update_msg_context(
1717: p_entity_code => 'HEADER_PAYMENT'

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

1792:
1793: IF l_control_rec.clear_dependents THEN
1794:
1795: IF l_debug_level > 0 THEN
1796: oe_debug_pub.add('Payment:before OE_Header_Payment_Util.Clear_Dependent_Attr', 5);
1797: END IF;
1798: OE_Header_Payment_Util.Clear_Dependent_Attr
1799: ( p_x_Header_Payment_rec => l_Header_Payment_rec
1800: , p_old_Header_Payment_rec => l_old_Header_Payment_rec

Line 1798: OE_Header_Payment_Util.Clear_Dependent_Attr

1794:
1795: IF l_debug_level > 0 THEN
1796: oe_debug_pub.add('Payment:before OE_Header_Payment_Util.Clear_Dependent_Attr', 5);
1797: END IF;
1798: OE_Header_Payment_Util.Clear_Dependent_Attr
1799: ( p_x_Header_Payment_rec => l_Header_Payment_rec
1800: , p_old_Header_Payment_rec => l_old_Header_Payment_rec
1801: );
1802: IF l_debug_level > 0 THEN

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

1799: ( p_x_Header_Payment_rec => l_Header_Payment_rec
1800: , p_old_Header_Payment_rec => l_old_Header_Payment_rec
1801: );
1802: IF l_debug_level > 0 THEN
1803: oe_debug_pub.add('Payment:after OE_Header_Payment_Util.Clear_Dependent_Attr', 5);
1804: END IF;
1805:
1806: END IF;
1807:

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

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

Line 1834: OE_Header_Payment_Util.Apply_Attribute_Changes

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

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

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

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

1929: IF l_control_rec.write_to_db THEN
1930:
1931: /* Start Audit Trail */
1932: IF l_debug_level > 0 THEN
1933: oe_debug_pub.add('Payment:before Oe_Header_Payment_Util.Pre_Write_Process', 5);
1934: END IF;
1935: Oe_Header_Payment_Util.Pre_Write_Process
1936: (p_x_header_Payment_rec => l_header_payment_rec,
1937: p_old_header_payment_rec => l_old_header_payment_rec);

Line 1935: Oe_Header_Payment_Util.Pre_Write_Process

1931: /* Start Audit Trail */
1932: IF l_debug_level > 0 THEN
1933: oe_debug_pub.add('Payment:before Oe_Header_Payment_Util.Pre_Write_Process', 5);
1934: END IF;
1935: Oe_Header_Payment_Util.Pre_Write_Process
1936: (p_x_header_Payment_rec => l_header_payment_rec,
1937: p_old_header_payment_rec => l_old_header_payment_rec);
1938: IF l_debug_level > 0 THEN
1939: oe_debug_pub.add('Payment:after Oe_Header_Payment_Util.Pre_Write_Process', 5);

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

1935: Oe_Header_Payment_Util.Pre_Write_Process
1936: (p_x_header_Payment_rec => l_header_payment_rec,
1937: p_old_header_payment_rec => l_old_header_payment_rec);
1938: IF l_debug_level > 0 THEN
1939: oe_debug_pub.add('Payment:after Oe_Header_Payment_Util.Pre_Write_Process', 5);
1940: END IF;
1941: /* End AuditTrail */
1942:
1943: IF l_Header_Payment_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN

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

1941: /* End AuditTrail */
1942:
1943: IF l_Header_Payment_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
1944: IF l_debug_level > 0 THEN
1945: oe_debug_pub.add('Payment:before Oe_Header_Payment_Util.Delete_Row',5);
1946: END IF;
1947:
1948: OE_Header_Payment_Util.Delete_Row
1949: ( p_payment_number => l_Header_Payment_rec.payment_number

Line 1948: OE_Header_Payment_Util.Delete_Row

1944: IF l_debug_level > 0 THEN
1945: oe_debug_pub.add('Payment:before Oe_Header_Payment_Util.Delete_Row',5);
1946: END IF;
1947:
1948: OE_Header_Payment_Util.Delete_Row
1949: ( p_payment_number => l_Header_Payment_rec.payment_number
1950: , p_header_id => l_Header_Payment_rec.header_id
1951: );
1952: IF l_debug_level > 0 THEN

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

1949: ( p_payment_number => l_Header_Payment_rec.payment_number
1950: , p_header_id => l_Header_Payment_rec.header_id
1951: );
1952: IF l_debug_level > 0 THEN
1953: oe_debug_pub.add('Payment:after Oe_Header_Payment_Util.Delete_Row',5);
1954: END IF;
1955:
1956: ELSE
1957:

Line 1966: OE_Header_Payment_Util.Update_Row (l_Header_Payment_rec);

1962: l_Header_Payment_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1963:
1964: IF l_Header_Payment_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1965:
1966: OE_Header_Payment_Util.Update_Row (l_Header_Payment_rec);
1967:
1968: ELSIF l_Header_Payment_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1969:
1970: l_Header_Payment_rec.creation_date := SYSDATE;

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

1970: l_Header_Payment_rec.creation_date := SYSDATE;
1971: l_Header_Payment_rec.created_by := FND_GLOBAL.USER_ID;
1972:
1973: IF l_debug_level > 0 THEN
1974: oe_debug_pub.add('Payment:before Oe_Header_Payment_Util.Insert_Row', 5);
1975: END IF;
1976: OE_Header_Payment_Util.Insert_Row (l_Header_Payment_rec);
1977: IF l_debug_level > 0 THEN
1978: oe_debug_pub.add('Payment:after Oe_Header_Payment_Util.Insert_Row', 5);

Line 1976: OE_Header_Payment_Util.Insert_Row (l_Header_Payment_rec);

1972:
1973: IF l_debug_level > 0 THEN
1974: oe_debug_pub.add('Payment:before Oe_Header_Payment_Util.Insert_Row', 5);
1975: END IF;
1976: OE_Header_Payment_Util.Insert_Row (l_Header_Payment_rec);
1977: IF l_debug_level > 0 THEN
1978: oe_debug_pub.add('Payment:after Oe_Header_Payment_Util.Insert_Row', 5);
1979: END IF;
1980:

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

1974: oe_debug_pub.add('Payment:before Oe_Header_Payment_Util.Insert_Row', 5);
1975: END IF;
1976: OE_Header_Payment_Util.Insert_Row (l_Header_Payment_rec);
1977: IF l_debug_level > 0 THEN
1978: oe_debug_pub.add('Payment:after Oe_Header_Payment_Util.Insert_Row', 5);
1979: END IF;
1980:
1981: END IF;
1982:

Line 10660: OE_Header_Payment_Util.Lock_Row

10656: WHILE I IS NOT NULL LOOP
10657:
10658: IF p_x_Header_Payment_tbl(I).operation = OE_GLOBALS.G_OPR_LOCK THEN
10659:
10660: OE_Header_Payment_Util.Lock_Row
10661: ( p_x_Header_Payment_rec => p_x_Header_Payment_tbl(I)
10662: , x_return_status => l_return_status
10663: );
10664:

Line 11169: OE_Header_Payment_Util.Query_Rows

11165:
11166: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
11167: -- Get Header_Payment ( parent = header )
11168:
11169: OE_Header_Payment_Util.Query_Rows
11170: ( p_header_id => p_header_id
11171: , x_Header_Payment_tbl => x_Header_Payment_tbl
11172: );
11173: END IF;