APPS.IEX_UWQ_POP_SUM_TBL_PVT dependencies on FND_FILE

Line 44: fnd_file.put_line(FND_FILE.LOG, p_msg);

40: if (p_msg_level >= G_MSG_LEVEL) then
41:
42: FND_LOG.STRING(p_msg_level, G_PKG_NAME, p_msg);
43: if FND_GLOBAL.Conc_Request_Id is not null then
44: fnd_file.put_line(FND_FILE.LOG, p_msg);
45: end if;
46:
47: end if;
48:

Line 1940: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Deadlock detected when updating ar_trx_bal_summary.reference to 1' || sqlerrm);

1936: END LOOP;
1937: EXCEPTION
1938:
1939: WHEN deadlock_detected THEN
1940: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Deadlock detected when updating ar_trx_bal_summary.reference to 1' || sqlerrm);
1941: LogMessage(FND_LOG.LEVEL_STATEMENT,' Deadlock detected when updating ar_trx_bal_summary.reference to 1.');
1942: ROLLBACK;
1943: l_cust_account_id_1.delete;
1944: if c_cust_account_id_1%ISOPEN then

Line 1966: FND_FILE.PUT_LINE(FND_FILE.LOG,'updated records '||sql%rowcount);

1962: UPDATE AR_TRX_BAL_SUMMARY
1963: SET REFERENCE_1 = '1'
1964: WHERE cust_account_id=l_cust_account_id1
1965: and REFERENCE_1 is null;
1966: FND_FILE.PUT_LINE(FND_FILE.LOG,'updated records '||sql%rowcount);
1967:
1968: CLOSE C_CUST_ACCOUNT_ID_DL1;
1969: EXCEPTION
1970: WHEN LOCKED_BY_ANOTHER_SESSION THEN

Line 1991: FND_FILE.PUT_LINE(FND_FILE.LOG,'Locked by another session when updating ar_trx_bal_summary.reference to 1');

1987:
1988: END IF;
1989: END LOOP;
1990: WHEN locked_by_another_session THEN
1991: FND_FILE.PUT_LINE(FND_FILE.LOG,'Locked by another session when updating ar_trx_bal_summary.reference to 1');
1992: if c_cust_account_id_1%ISOPEN then
1993: close c_cust_account_id_1;
1994: end if;
1995: ROLLBACK;

Line 2024: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Deadlock detected when updating ar_trx_bal_summary.reference to null' || sqlerrm);

2020: END IF;
2021: END LOOP;
2022: EXCEPTION
2023: WHEN deadlock_detected THEN
2024: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Deadlock detected when updating ar_trx_bal_summary.reference to null' || sqlerrm);
2025: LogMessage(FND_LOG.LEVEL_STATEMENT,' Deadlock detected when updating ar_trx_bal_summary.reference to null.');
2026: ROLLBACK;
2027: l_cust_account_id_n.delete;
2028: if c_cust_account_id_n%ISOPEN then

Line 2050: FND_FILE.PUT_LINE(FND_FILE.LOG,'updated records '||sql%rowcount);

2046: UPDATE AR_TRX_BAL_SUMMARY
2047: SET REFERENCE_1 = null
2048: WHERE cust_account_id=l_cust_account_id1
2049: and REFERENCE_1 = '1';
2050: FND_FILE.PUT_LINE(FND_FILE.LOG,'updated records '||sql%rowcount);
2051:
2052: CLOSE C_CUST_ACCOUNT_ID_DLN;
2053: EXCEPTION
2054: WHEN LOCKED_BY_ANOTHER_SESSION THEN

Line 2075: FND_FILE.PUT_LINE(FND_FILE.LOG,'Locked by another session when updating ar_trx_bal_summary.reference to 1');

2071:
2072: END IF;
2073: END LOOP;
2074: WHEN locked_by_another_session THEN
2075: FND_FILE.PUT_LINE(FND_FILE.LOG,'Locked by another session when updating ar_trx_bal_summary.reference to 1');
2076: if c_cust_account_id_1%ISOPEN then
2077: close c_cust_account_id_1;
2078: end if;
2079: ROLLBACK;

Line 3821: FND_FILE.PUT_LINE(FND_FILE.LOG, 'fetched records '||L_SITE_USE_ID.COUNT) ;

3817: L_COMPLETE_DELINQUENCIES,
3818: L_ACTIVE_DELINQUENCIES,
3819: L_ORG_ID
3820: limit l_max_fetches;
3821: FND_FILE.PUT_LINE(FND_FILE.LOG, 'fetched records '||L_SITE_USE_ID.COUNT) ;
3822: IF L_SITE_USE_ID.COUNT = 0 THEN
3823: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'End fetching time: c_billto_del_dln ' || to_char(sysdate, 'MM/DD/YYYY HH:MI:SS'));
3824: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'No records found - processing complete. Exiting the loop');
3825: EXIT;