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.AP_PMT_CALLOUT_PKG dependencies on FND_FILE

Line 166: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Code : ' || SQLCODE);

162:
163: /* Start - BUG 14364091 - Logging */
164: EXCEPTION
165: WHEN OTHERS THEN
166: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Code : ' || SQLCODE);
167: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Msg : ' || SQLERRM);
168: FND_FILE.PUT_LINE(FND_FILE.LOG, G_MODULE_NAME || '.' || l_api_name || ' - ' || l_debug_info ||' - '||systimestamp);
169: APP_EXCEPTION.RAISE_EXCEPTION;
170: /* End - BUG 14364091 - Logging */

Line 167: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Msg : ' || SQLERRM);

163: /* Start - BUG 14364091 - Logging */
164: EXCEPTION
165: WHEN OTHERS THEN
166: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Code : ' || SQLCODE);
167: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Msg : ' || SQLERRM);
168: FND_FILE.PUT_LINE(FND_FILE.LOG, G_MODULE_NAME || '.' || l_api_name || ' - ' || l_debug_info ||' - '||systimestamp);
169: APP_EXCEPTION.RAISE_EXCEPTION;
170: /* End - BUG 14364091 - Logging */
171: end;

Line 168: FND_FILE.PUT_LINE(FND_FILE.LOG, G_MODULE_NAME || '.' || l_api_name || ' - ' || l_debug_info ||' - '||systimestamp);

164: EXCEPTION
165: WHEN OTHERS THEN
166: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Code : ' || SQLCODE);
167: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Msg : ' || SQLERRM);
168: FND_FILE.PUT_LINE(FND_FILE.LOG, G_MODULE_NAME || '.' || l_api_name || ' - ' || l_debug_info ||' - '||systimestamp);
169: APP_EXCEPTION.RAISE_EXCEPTION;
170: /* End - BUG 14364091 - Logging */
171: end;
172:

Line 268: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Code : ' || SQLCODE);

264: END LOOP;
265: /* Start - BUG 14364091 - Logging */
266: EXCEPTION
267: WHEN OTHERS THEN
268: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Code : ' || SQLCODE);
269: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Msg : ' || SQLERRM);
270: FND_FILE.PUT_LINE(FND_FILE.LOG, G_MODULE_NAME || '.' || l_api_name || ' - ' || l_debug_info ||' - '||systimestamp);
271: APP_EXCEPTION.RAISE_EXCEPTION;
272: /* End - BUG 14364091 - Logging */

Line 269: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Msg : ' || SQLERRM);

265: /* Start - BUG 14364091 - Logging */
266: EXCEPTION
267: WHEN OTHERS THEN
268: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Code : ' || SQLCODE);
269: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Msg : ' || SQLERRM);
270: FND_FILE.PUT_LINE(FND_FILE.LOG, G_MODULE_NAME || '.' || l_api_name || ' - ' || l_debug_info ||' - '||systimestamp);
271: APP_EXCEPTION.RAISE_EXCEPTION;
272: /* End - BUG 14364091 - Logging */
273:

Line 270: FND_FILE.PUT_LINE(FND_FILE.LOG, G_MODULE_NAME || '.' || l_api_name || ' - ' || l_debug_info ||' - '||systimestamp);

266: EXCEPTION
267: WHEN OTHERS THEN
268: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Code : ' || SQLCODE);
269: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Msg : ' || SQLERRM);
270: FND_FILE.PUT_LINE(FND_FILE.LOG, G_MODULE_NAME || '.' || l_api_name || ' - ' || l_debug_info ||' - '||systimestamp);
271: APP_EXCEPTION.RAISE_EXCEPTION;
272: /* End - BUG 14364091 - Logging */
273:
274: END assign_int_inv_sequence;

Line 591: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Code : ' || SQLCODE);

587:
588: /* Start - BUG 14364091 - Logging */
589: EXCEPTION
590: WHEN OTHERS THEN
591: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Code : ' || SQLCODE);
592: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Msg : ' || SQLERRM);
593: FND_FILE.PUT_LINE(FND_FILE.LOG, G_MODULE_NAME || '.' || l_api_name || ' - ' || l_debug_info ||' - '||systimestamp);
594: APP_EXCEPTION.RAISE_EXCEPTION;
595: /* End - BUG 14364091 - Logging */

Line 592: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Msg : ' || SQLERRM);

588: /* Start - BUG 14364091 - Logging */
589: EXCEPTION
590: WHEN OTHERS THEN
591: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Code : ' || SQLCODE);
592: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Msg : ' || SQLERRM);
593: FND_FILE.PUT_LINE(FND_FILE.LOG, G_MODULE_NAME || '.' || l_api_name || ' - ' || l_debug_info ||' - '||systimestamp);
594: APP_EXCEPTION.RAISE_EXCEPTION;
595: /* End - BUG 14364091 - Logging */
596: END assign_sequences;

Line 593: FND_FILE.PUT_LINE(FND_FILE.LOG, G_MODULE_NAME || '.' || l_api_name || ' - ' || l_debug_info ||' - '||systimestamp);

589: EXCEPTION
590: WHEN OTHERS THEN
591: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Code : ' || SQLCODE);
592: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Msg : ' || SQLERRM);
593: FND_FILE.PUT_LINE(FND_FILE.LOG, G_MODULE_NAME || '.' || l_api_name || ' - ' || l_debug_info ||' - '||systimestamp);
594: APP_EXCEPTION.RAISE_EXCEPTION;
595: /* End - BUG 14364091 - Logging */
596: END assign_sequences;
597:

Line 754: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Code : ' || SQLCODE);

750: IF c_checkrun_id%ISOPEN THEN
751: CLOSE c_checkrun_id;
752: END IF;
753: /* Start - BUG 14364091 - Logging */
754: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Code : ' || SQLCODE);
755: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Msg : ' || SQLERRM);
756: FND_FILE.PUT_LINE(FND_FILE.LOG, G_MODULE_NAME || '.' || l_api_name || ' - ' || l_debug_info ||' - '||systimestamp);
757: APP_EXCEPTION.RAISE_EXCEPTION;
758:

Line 755: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Msg : ' || SQLERRM);

751: CLOSE c_checkrun_id;
752: END IF;
753: /* Start - BUG 14364091 - Logging */
754: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Code : ' || SQLCODE);
755: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Msg : ' || SQLERRM);
756: FND_FILE.PUT_LINE(FND_FILE.LOG, G_MODULE_NAME || '.' || l_api_name || ' - ' || l_debug_info ||' - '||systimestamp);
757: APP_EXCEPTION.RAISE_EXCEPTION;
758:
759: /* End - BUG 14364091 - Logging */

Line 756: FND_FILE.PUT_LINE(FND_FILE.LOG, G_MODULE_NAME || '.' || l_api_name || ' - ' || l_debug_info ||' - '||systimestamp);

752: END IF;
753: /* Start - BUG 14364091 - Logging */
754: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Code : ' || SQLCODE);
755: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Msg : ' || SQLERRM);
756: FND_FILE.PUT_LINE(FND_FILE.LOG, G_MODULE_NAME || '.' || l_api_name || ' - ' || l_debug_info ||' - '||systimestamp);
757: APP_EXCEPTION.RAISE_EXCEPTION;
758:
759: /* End - BUG 14364091 - Logging */
760:

Line 1053: FND_FILE.PUT_LINE(FND_FILE.LOG, l_debug_info);

1049: BEGIN
1050: if p_prob_pmt_list.exists(1) then
1051: fnd_message.set_name('SQLAP', p_message_name);
1052: l_debug_info := fnd_message.get;
1053: FND_FILE.PUT_LINE(FND_FILE.LOG, l_debug_info);
1054:
1055: for i in l_prob_pmt_list.FIRST .. l_prob_pmt_list.LAST
1056: loop
1057: fnd_message.set_name('SQLAP', 'AP_IBY_PMT_MISMATCH_DETAIL');

Line 1064: FND_FILE.PUT_LINE(FND_FILE.LOG, l_debug_info);

1060: fnd_message.set_token('PAYMENT_INSTRUCTION_ID', l_prob_pmt_list(i).payment_instruction_id);
1061: fnd_message.set_token('INVOICE_ID', l_prob_pmt_list(i).invoice_id);
1062: fnd_message.set_token('PAYMENT_NUM', l_prob_pmt_list(i).payment_num);
1063: l_debug_info := fnd_message.get;
1064: FND_FILE.PUT_LINE(FND_FILE.LOG, l_debug_info);
1065: end loop;
1066: end if;
1067: END print_prob_pmt_detail;
1068:

Line 1085: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

1081:
1082:
1083:
1084: l_debug_info := 'get displayed Field';
1085: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1086: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1087: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1088: END IF;
1089:

Line 1121: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

1117: /* Initialize return status */
1118: x_return_status := FND_API.G_RET_STS_SUCCESS;
1119:
1120: l_debug_info := 'get_relevant_checkrun_ids';
1121: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1122: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1123: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1124: END IF;
1125:

Line 1138: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

1134:
1135: l_checkrun_id := l_checkrun_id_list(i);
1136:
1137: l_debug_info := 'l_checkrun_id: '||to_char(l_checkrun_id);
1138: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1139: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1140: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1141: END IF;
1142:

Line 1144: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

1140: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1141: END IF;
1142:
1143: l_debug_info := 'get_checkrun_info';
1144: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1145: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1146: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1147: END IF;
1148:

Line 1163: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

1159: FROM ap_inv_selection_criteria_all
1160: WHERE checkrun_id = l_checkrun_id;
1161:
1162: l_debug_info := 'get_terms';
1163: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1164: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1165: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1166: END IF;
1167:

Line 1184: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

1180:
1181: l_last_updated_by := to_number(FND_GLOBAL.USER_ID);
1182:
1183: l_debug_info := 'get_profiles';
1184: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1185: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1186: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1187: END IF;
1188: fnd_profile.get('UNIQUE:SEQ_NUMBERS',l_seq_num_profile);

Line 1194: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

1190:
1191: OPEN c_relevant_orgs(l_checkrun_id);
1192:
1193: l_debug_info := 'c_relevant_orgs';
1194: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1195: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1196: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1197: END IF;
1198:

Line 1204: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

1200: FETCH c_relevant_orgs INTO l_current_org_id;
1201: EXIT WHEN c_relevant_orgs%NOTFOUND;
1202:
1203: l_debug_info := 'l_current_org_id: '||to_char(l_current_org_id);
1204: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1205: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1206: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1207: END IF;
1208: l_debug_info := 'get_org_info';

Line 1209: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

1205: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1206: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1207: END IF;
1208: l_debug_info := 'get_org_info';
1209: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1210: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1211: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1212: END IF;
1213:

Line 1266: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

1262:
1263: IF l_auto_calculate_interest_flag = 'Y' THEN
1264:
1265: l_debug_info := 'do interest invoice insertions';
1266: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1267: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1268: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1269: END IF;
1270:

Line 1412: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

1408:
1409: l_interest_invoice_count := sql%rowcount;
1410:
1411: l_debug_info := 'do interest invoice line insertions';
1412: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1413: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1414: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1415: END IF;
1416:

Line 1495: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

1491: AND fcinv.currency_code = orig.invoice_currency_code;
1492:
1493:
1494: l_debug_info := 'do ap_create_batch_interest_dists';
1495: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1496: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1497: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1498: END IF;
1499:

Line 1518: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

1514:
1515:
1516:
1517: l_debug_info := 'INSERT INTO ap_payment_schedules_all';
1518: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1519: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1520: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1521: END IF;
1522:

Line 1600: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

1596:
1597:
1598:
1599: l_debug_info := 'INSERT INTO ap_invoice_relationships';
1600: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1601: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1602: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1603: END IF;
1604:

Line 1642: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

1638:
1639: IF l_batch_control_flag = 'Y' THEN
1640:
1641: l_debug_info := 'INSERT INTO ap_batches_all';
1642: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1643: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1644: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1645: END IF;
1646:

Line 1687: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

1683: /*bug8224330, transported the insert into ap_checks_all here, after the insertion of interest invoices related data
1684: into ap tables*/
1685:
1686: l_debug_info := 'insert into ap_checks_all';
1687: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1688: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1689: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1690: END IF;
1691:

Line 1891: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

1887: l_check_count := SQL%ROWCOUNT;
1888: l_total_check_count := l_check_count + l_total_check_count;
1889:
1890: l_debug_info := 'l_check_count: '||to_char(l_check_count);
1891: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1892:
1893: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1894: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1895: END IF;

Line 1898: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

1894: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1895: END IF;
1896:
1897: l_debug_info := 'l_total_check_count: '||to_char(l_total_check_count);
1898: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1899:
1900: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1901: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1902: END IF;

Line 1905: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

1901: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1902: END IF;
1903:
1904: l_debug_info := 'l_current_org_id: '||to_char(l_current_org_id);
1905: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1906: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1907: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1908: END IF;
1909:

Line 1912: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

1908: END IF;
1909:
1910:
1911: l_debug_info := 'create accounting';
1912: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1913: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1914: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1915: END IF;
1916:

Line 1929: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

1925:
1926: IF l_when_to_account_payment = 'CLEARING ONLY' THEN
1927:
1928: l_debug_info := 'AP_ACCOUNTING_EVENTS_PKG.update_pmt_batch_event_status';
1929: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1930: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1931: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1932: END IF;
1933:

Line 1945: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

1941:
1942: --bug8224330
1943:
1944: l_debug_info := 'UPDATE ap_selected_invoices_all';
1945: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1946: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1947: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1948: END IF;
1949:

Line 1967: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

1963:
1964: IF l_perform_awt_flag = 'Y' THEN
1965:
1966: l_debug_info := ' UPDATE ap_awt_temp_distributions_all';
1967: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1968: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1969: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1970: END IF;
1971:

Line 1995: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

1991: AND ibypmts.org_id = l_current_org_id);
1992:
1993:
1994: l_debug_info := 'AP_WITHHOLDING_PKG.AP_WITHHOLD_CONFIRM';
1995: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1996: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1997: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1998: END IF;
1999: AP_WITHHOLDING_PKG.AP_WITHHOLD_CONFIRM(l_checkrun_name,

Line 2012: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

2008: l_current_org_id,
2009: l_check_date);
2010:
2011: l_debug_info := 'DELETE FROM ap_awt_temp_distributions_all';
2012: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2013: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2014: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2015: END IF;
2016:

Line 2054: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

2050: payment_num_ps_l
2051: LIMIT 1000;
2052:
2053: l_debug_info := 'UPDATE ap_payment_schedules_all';
2054: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2055: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2056: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2057: END IF;
2058:

Line 2085: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

2081: CLOSE c_schedule_amounts;
2082:
2083: -- Bug 5658623. Cursor Processing for Performance
2084: l_debug_info := 'Opening Cursor for updating invoices via Forall';
2085: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2086: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2087: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2088: END IF;
2089:

Line 2108: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

2104: invoice_id_inv_l
2105: LIMIT 1000;
2106:
2107: l_debug_info := 'UPDATE ap_invoices_all';
2108: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2109: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2110: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2111: END IF;
2112:

Line 2130: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

2126:
2127:
2128:
2129: l_debug_info := 'insert into ap_invoice_payments_all';
2130: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2131: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2132: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2133: END IF;
2134:

Line 2364: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

2360: l_total_docs_count := l_docs_count + l_total_docs_count;
2361:
2362:
2363: l_debug_info := 'Call product specific subscription API for Payment Event';
2364: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2365:
2366: -- Added for Payment Request
2367: OPEN c_subscribed_payments;
2368: LOOP

Line 2374: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

2370: FETCH c_subscribed_payments INTO l_check_id, l_application_id;
2371: EXIT WHEN c_subscribed_payments%NOTFOUND;
2372:
2373: l_debug_info := 'AP_CHECKS_PKG.Subscribe_To_Payment_Event';
2374: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2375: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2376: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2377: END IF;
2378:

Line 2397: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

2393:
2394:
2395: IF L_Return_Status <> 'S' THEN
2396: l_debug_info := 'Status other than success during subscribe to payment event';
2397: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2398: END IF;
2399: EXCEPTION
2400: WHEN OTHERS THEN
2401: l_debug_info := 'Error returned during subscribe to payment event';

Line 2402: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

2398: END IF;
2399: EXCEPTION
2400: WHEN OTHERS THEN
2401: l_debug_info := 'Error returned during subscribe to payment event';
2402: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2403: fnd_file.put_line(FND_FILE.LOG,SQLERRM);
2404: END;
2405:
2406: END LOOP;

Line 2403: fnd_file.put_line(FND_FILE.LOG,SQLERRM);

2399: EXCEPTION
2400: WHEN OTHERS THEN
2401: l_debug_info := 'Error returned during subscribe to payment event';
2402: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2403: fnd_file.put_line(FND_FILE.LOG,SQLERRM);
2404: END;
2405:
2406: END LOOP;
2407: CLOSE c_subscribed_payments;

Line 2411: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

2407: CLOSE c_subscribed_payments;
2408:
2409:
2410: l_debug_info := 'AP_DBI_PKG.Insert_Payment_Confirm_DBI';
2411: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2412: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2413: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2414: END IF;
2415: AP_DBI_PKG.Insert_Payment_Confirm_DBI(

Line 2422: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

2418: p_key_table => 'AP_INVOICE_PAYMENTS_ALL',
2419: p_calling_sequence => l_current_calling_sequence );
2420:
2421: l_debug_info := 'AP_Accounting_Events_Pkg.Batch_Update_Payment_Info';
2422: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2423: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2424: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2425: END IF;
2426: AP_Accounting_Events_Pkg.Batch_Update_Payment_Info(

Line 2434: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

2430: p_calling_sequence=>l_current_calling_sequence);
2431:
2432: -- Bug 5658623. Cursor Processing for Performance
2433: l_debug_info := 'Opening Cursor for updating payment schedules via Forall';
2434: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2435: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2436: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2437: END IF;
2438:

Line 2603: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

2599: AND invoice_type_lookup_code <> 'INTEREST';
2600: */
2601: -- Bug 5512197. Adding the following for fnd logging
2602: l_debug_info := 'Sequential Numbering Option: '||l_seq_num_profile;
2603: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2604: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2605: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2606: END IF;
2607:

Line 2611: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

2607:
2608: IF l_seq_num_profile IN ('A','P') then
2609:
2610: l_debug_info := 'assign_sequences';
2611: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2612: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2613: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2614: END IF;
2615:

Line 2638: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

2634:
2635:
2636: IF l_seq_num_profile NOT IN ('A','P') and l_first_voucher_number is not null then
2637: l_debug_info := 'assign_vouchers';
2638: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2639: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2640: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2641: END IF;
2642: assign_vouchers(p_completed_pmts_group_id,

Line 2652: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

2648:
2649: if l_perform_awt_flag = 'Y' then
2650:
2651: l_debug_info := 'AP_WITHHOLDING_PKG.AP_WITHHOLD_CANCEL';
2652: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2653: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2654: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2655: END IF;
2656:

Line 2672: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

2668:
2669: END if;
2670:
2671: l_debug_info := 'AP_PAYMENT_EVENT_PKG.raise_payment_batch_events';
2672: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2673: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2674: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2675: END IF;
2676:

Line 2704: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

2700: /* Added for Bug#9459810 End */
2701:
2702:
2703: l_debug_info := 'DELETE FROM ap_selected_invoices_all';
2704: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2705: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2706: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2707: END IF;
2708:

Line 2727: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

2723: END LOOP; --loop for org_id's
2724: close c_relevant_orgs;
2725:
2726: l_debug_info := 'DELETE FROM ap_unselected_invoices_all';
2727: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2728: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2729: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2730: END IF;
2731:

Line 2749: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

2745: FROM iby_fd_docs_payable_v
2746: WHERE completed_pmts_group_id = p_completed_pmts_group_id;
2747:
2748: l_debug_info := '******AP-IBY COUNTS****************';
2749: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2750: fnd_file.put_line(FND_FILE.LOG,'IBY CHECK COUNT: '||TO_CHAR(l_iby_check_count)||' - '||systimestamp);
2751: fnd_file.put_line(FND_FILE.LOG,'IBY DOC COUNT: '||TO_CHAR(l_iby_docs_count)||' - '||systimestamp);
2752: fnd_file.put_line(FND_FILE.LOG,'AP CHECK COUNT: '||TO_CHAR(l_total_check_count)||' - '||systimestamp);
2753: fnd_file.put_line(FND_FILE.LOG,'AP DOCS COUNT: '||TO_CHAR(l_total_docs_count)||' - '||systimestamp);

Line 2750: fnd_file.put_line(FND_FILE.LOG,'IBY CHECK COUNT: '||TO_CHAR(l_iby_check_count)||' - '||systimestamp);

2746: WHERE completed_pmts_group_id = p_completed_pmts_group_id;
2747:
2748: l_debug_info := '******AP-IBY COUNTS****************';
2749: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2750: fnd_file.put_line(FND_FILE.LOG,'IBY CHECK COUNT: '||TO_CHAR(l_iby_check_count)||' - '||systimestamp);
2751: fnd_file.put_line(FND_FILE.LOG,'IBY DOC COUNT: '||TO_CHAR(l_iby_docs_count)||' - '||systimestamp);
2752: fnd_file.put_line(FND_FILE.LOG,'AP CHECK COUNT: '||TO_CHAR(l_total_check_count)||' - '||systimestamp);
2753: fnd_file.put_line(FND_FILE.LOG,'AP DOCS COUNT: '||TO_CHAR(l_total_docs_count)||' - '||systimestamp);
2754:

Line 2751: fnd_file.put_line(FND_FILE.LOG,'IBY DOC COUNT: '||TO_CHAR(l_iby_docs_count)||' - '||systimestamp);

2747:
2748: l_debug_info := '******AP-IBY COUNTS****************';
2749: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2750: fnd_file.put_line(FND_FILE.LOG,'IBY CHECK COUNT: '||TO_CHAR(l_iby_check_count)||' - '||systimestamp);
2751: fnd_file.put_line(FND_FILE.LOG,'IBY DOC COUNT: '||TO_CHAR(l_iby_docs_count)||' - '||systimestamp);
2752: fnd_file.put_line(FND_FILE.LOG,'AP CHECK COUNT: '||TO_CHAR(l_total_check_count)||' - '||systimestamp);
2753: fnd_file.put_line(FND_FILE.LOG,'AP DOCS COUNT: '||TO_CHAR(l_total_docs_count)||' - '||systimestamp);
2754:
2755:

Line 2752: fnd_file.put_line(FND_FILE.LOG,'AP CHECK COUNT: '||TO_CHAR(l_total_check_count)||' - '||systimestamp);

2748: l_debug_info := '******AP-IBY COUNTS****************';
2749: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2750: fnd_file.put_line(FND_FILE.LOG,'IBY CHECK COUNT: '||TO_CHAR(l_iby_check_count)||' - '||systimestamp);
2751: fnd_file.put_line(FND_FILE.LOG,'IBY DOC COUNT: '||TO_CHAR(l_iby_docs_count)||' - '||systimestamp);
2752: fnd_file.put_line(FND_FILE.LOG,'AP CHECK COUNT: '||TO_CHAR(l_total_check_count)||' - '||systimestamp);
2753: fnd_file.put_line(FND_FILE.LOG,'AP DOCS COUNT: '||TO_CHAR(l_total_docs_count)||' - '||systimestamp);
2754:
2755:
2756: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 2753: fnd_file.put_line(FND_FILE.LOG,'AP DOCS COUNT: '||TO_CHAR(l_total_docs_count)||' - '||systimestamp);

2749: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2750: fnd_file.put_line(FND_FILE.LOG,'IBY CHECK COUNT: '||TO_CHAR(l_iby_check_count)||' - '||systimestamp);
2751: fnd_file.put_line(FND_FILE.LOG,'IBY DOC COUNT: '||TO_CHAR(l_iby_docs_count)||' - '||systimestamp);
2752: fnd_file.put_line(FND_FILE.LOG,'AP CHECK COUNT: '||TO_CHAR(l_total_check_count)||' - '||systimestamp);
2753: fnd_file.put_line(FND_FILE.LOG,'AP DOCS COUNT: '||TO_CHAR(l_total_docs_count)||' - '||systimestamp);
2754:
2755:
2756: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2757: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

Line 2781: FND_FILE.PUT_LINE(FND_FILE.LOG, G_MODULE_NAME);

2777: --Bug 9074840 Add additional debug queries
2778:
2779: --As this is an error condition it will be written to the concurrent log
2780: --regardless of the runtime fnd log level.
2781: FND_FILE.PUT_LINE(FND_FILE.LOG, G_MODULE_NAME);
2782: l_debug_info := fnd_message.get;
2783: FND_FILE.PUT_LINE(FND_FILE.LOG, l_debug_info);
2784:
2785: OPEN c_prob_iby_payments;

Line 2783: FND_FILE.PUT_LINE(FND_FILE.LOG, l_debug_info);

2779: --As this is an error condition it will be written to the concurrent log
2780: --regardless of the runtime fnd log level.
2781: FND_FILE.PUT_LINE(FND_FILE.LOG, G_MODULE_NAME);
2782: l_debug_info := fnd_message.get;
2783: FND_FILE.PUT_LINE(FND_FILE.LOG, l_debug_info);
2784:
2785: OPEN c_prob_iby_payments;
2786: FETCH c_prob_iby_payments BULK COLLECT INTO l_prob_pmt_list;
2787: CLOSE c_prob_iby_payments;

Line 2806: FND_FILE.PUT_LINE(FND_FILE.LOG, l_debug_info);

2802: CLOSE c_prob_inv_pmts;
2803: print_prob_pmt_detail(l_prob_pmt_list, 'AP_IBY_PMT_MISMATCH_INV');
2804:
2805: l_debug_info := '*****************************************************************************';
2806: FND_FILE.PUT_LINE(FND_FILE.LOG, l_debug_info);
2807: FND_FILE.PUT_LINE(FND_FILE.LOG, G_MODULE_NAME);
2808: /* no longer necessary as the messages are only written to the log
2809: FND_MSG_PUB.ADD;
2810: FND_MSG_PUB.COUNT_AND_GET(

Line 2807: FND_FILE.PUT_LINE(FND_FILE.LOG, G_MODULE_NAME);

2803: print_prob_pmt_detail(l_prob_pmt_list, 'AP_IBY_PMT_MISMATCH_INV');
2804:
2805: l_debug_info := '*****************************************************************************';
2806: FND_FILE.PUT_LINE(FND_FILE.LOG, l_debug_info);
2807: FND_FILE.PUT_LINE(FND_FILE.LOG, G_MODULE_NAME);
2808: /* no longer necessary as the messages are only written to the log
2809: FND_MSG_PUB.ADD;
2810: FND_MSG_PUB.COUNT_AND_GET(
2811: p_count => x_msg_count,

Line 2835: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Code : ' || SQLCODE);

2831: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_current_calling_sequence);
2832: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2833:
2834: /* Start - BUG 14364091 - Logging */
2835: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Code : ' || SQLCODE);
2836: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Msg : ' || SQLERRM);
2837: FND_FILE.PUT_LINE(FND_FILE.LOG, G_MODULE_NAME || '.' || l_api_name || ' - ' || l_debug_info ||' - '||systimestamp);
2838: /* End - BUG 14364091 - Logging */
2839:

Line 2836: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Msg : ' || SQLERRM);

2832: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2833:
2834: /* Start - BUG 14364091 - Logging */
2835: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Code : ' || SQLCODE);
2836: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Msg : ' || SQLERRM);
2837: FND_FILE.PUT_LINE(FND_FILE.LOG, G_MODULE_NAME || '.' || l_api_name || ' - ' || l_debug_info ||' - '||systimestamp);
2838: /* End - BUG 14364091 - Logging */
2839:
2840:

Line 2837: FND_FILE.PUT_LINE(FND_FILE.LOG, G_MODULE_NAME || '.' || l_api_name || ' - ' || l_debug_info ||' - '||systimestamp);

2833:
2834: /* Start - BUG 14364091 - Logging */
2835: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Code : ' || SQLCODE);
2836: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Msg : ' || SQLERRM);
2837: FND_FILE.PUT_LINE(FND_FILE.LOG, G_MODULE_NAME || '.' || l_api_name || ' - ' || l_debug_info ||' - '||systimestamp);
2838: /* End - BUG 14364091 - Logging */
2839:
2840:
2841: APP_EXCEPTION.RAISE_EXCEPTION;

Line 2854: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Code : ' || SQLCODE);

2850: FND_MESSAGE.set_TOKEN('DEBUG_INFO',l_debug_info);
2851: END IF;
2852:
2853: /* Start - BUG 14364091 - Logging */
2854: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Code : ' || SQLCODE);
2855: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Msg : ' || SQLERRM);
2856: FND_FILE.PUT_LINE(FND_FILE.LOG, G_MODULE_NAME || '.' || l_api_name || ' - ' || l_debug_info ||' - '||systimestamp);
2857: /* End - BUG 14364091 - Logging */
2858:

Line 2855: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Msg : ' || SQLERRM);

2851: END IF;
2852:
2853: /* Start - BUG 14364091 - Logging */
2854: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Code : ' || SQLCODE);
2855: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Msg : ' || SQLERRM);
2856: FND_FILE.PUT_LINE(FND_FILE.LOG, G_MODULE_NAME || '.' || l_api_name || ' - ' || l_debug_info ||' - '||systimestamp);
2857: /* End - BUG 14364091 - Logging */
2858:
2859: APP_EXCEPTION.RAISE_EXCEPTION;

Line 2856: FND_FILE.PUT_LINE(FND_FILE.LOG, G_MODULE_NAME || '.' || l_api_name || ' - ' || l_debug_info ||' - '||systimestamp);

2852:
2853: /* Start - BUG 14364091 - Logging */
2854: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Code : ' || SQLCODE);
2855: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Msg : ' || SQLERRM);
2856: FND_FILE.PUT_LINE(FND_FILE.LOG, G_MODULE_NAME || '.' || l_api_name || ' - ' || l_debug_info ||' - '||systimestamp);
2857: /* End - BUG 14364091 - Logging */
2858:
2859: APP_EXCEPTION.RAISE_EXCEPTION;
2860: