APPS.IEX_UWQ_POP_SUM_TBL_PVT dependencies on IEX_DEBUG_PUB

Line 1919: IEX_DEBUG_PUB.LOGMESSAGE('Exit after Updating ar_trx_bal_summary with reference_1 = 1...');

1915: FETCH c_cust_account_id_1 BULK COLLECT INTO
1916: l_cust_account_id_1 LIMIT G_BATCH_SIZE;
1917: IF l_cust_account_id_1.count = 0 THEN
1918:
1919: IEX_DEBUG_PUB.LOGMESSAGE('Exit after Updating ar_trx_bal_summary with reference_1 = 1...');
1920:
1921: CLOSE c_cust_account_id_1;
1922: EXIT;
1923: ELSE

Line 1933: IEX_DEBUG_PUB.LOGMESSAGE(SQL%ROWCOUNT || ' Rows updated in ar_trx_bal_summary with reference_1 = 1');

1929: l_cust_account_id_1.delete;
1930:
1931: commit;
1932:
1933: IEX_DEBUG_PUB.LOGMESSAGE(SQL%ROWCOUNT || ' Rows updated in ar_trx_bal_summary with reference_1 = 1');
1934:
1935: END IF;
1936: END LOOP;
1937: EXCEPTION

Line 1952: IEX_DEBUG_PUB.LOGMESSAGE('Exit after Updating ar_trx_bal_summary with reference_1 = 1 in Deadlock handler');

1948: LOOP
1949: FETCH c_cust_account_id_1 BULK COLLECT INTO
1950: l_cust_account_id_1 LIMIT G_BATCH_SIZE;
1951: IF l_cust_account_id_1.count = 0 THEN
1952: IEX_DEBUG_PUB.LOGMESSAGE('Exit after Updating ar_trx_bal_summary with reference_1 = 1 in Deadlock handler');
1953: CLOSE c_cust_account_id_1;
1954: EXIT;
1955: ELSE
1956: FOR i IN l_cust_account_id_1.first..l_cust_account_id_1.last

Line 1984: IEX_DEBUG_PUB.LOGMESSAGE(l_cust_account_id_1.count || ' rows updated in ar_trx_bal_summary with reference_1 = 1');

1980: END;
1981:
1982: END LOOP;
1983:
1984: IEX_DEBUG_PUB.LOGMESSAGE(l_cust_account_id_1.count || ' rows updated in ar_trx_bal_summary with reference_1 = 1');
1985: l_cust_account_id_1.delete;
1986: commit;
1987:
1988: END IF;

Line 1998: IEX_DEBUG_PUB.LOGMESSAGE(SQLERRM || ' Error while updating ar_trx_bal_summary with reference_1 = 1');

1994: end if;
1995: ROLLBACK;
1996:
1997: WHEN OTHERS THEN
1998: IEX_DEBUG_PUB.LOGMESSAGE(SQLERRM || ' Error while updating ar_trx_bal_summary with reference_1 = 1');
1999: END;
2000:
2001: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'Starting to update ar_trx_bal_summary with reference_1 = Null...');
2002: BEGIN

Line 2036: IEX_DEBUG_PUB.LOGMESSAGE('Exit after Updating ar_trx_bal_summary with reference_1 = null in Deadlock handler');

2032: LOOP
2033: FETCH c_cust_account_id_n BULK COLLECT INTO
2034: l_cust_account_id_n LIMIT G_BATCH_SIZE;
2035: IF l_cust_account_id_n.count = 0 THEN
2036: IEX_DEBUG_PUB.LOGMESSAGE('Exit after Updating ar_trx_bal_summary with reference_1 = null in Deadlock handler');
2037: CLOSE c_cust_account_id_n;
2038: EXIT;
2039: ELSE
2040: FOR i IN l_cust_account_id_n.first..l_cust_account_id_n.last

Line 2068: IEX_DEBUG_PUB.LOGMESSAGE(l_cust_account_id_1.count || ' rows updated in ar_trx_bal_summary with reference_1 = 1');

2064: END;
2065:
2066: END LOOP;
2067:
2068: IEX_DEBUG_PUB.LOGMESSAGE(l_cust_account_id_1.count || ' rows updated in ar_trx_bal_summary with reference_1 = 1');
2069: l_cust_account_id_1.delete;
2070: commit;
2071:
2072: END IF;