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.IGC_CC_OPEN_INTERFACE_PKG dependencies on FND_LOG

Line 5: l_debug_level number:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1: PACKAGE BODY IGC_CC_OPEN_INTERFACE_PKG AS
2: /* $Header: IGCCOPIB.pls 120.15.12010000.3 2008/11/13 04:53:57 schakkin ship $ */
3:
4: --Bug 3199488 Start Block
5: l_debug_level number:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6:
7: l_state_level number:=FND_LOG.LEVEL_STATEMENT;
8: l_proc_level number:=FND_LOG.LEVEL_PROCEDURE;
9: l_event_level number:=FND_LOG.LEVEL_EVENT;

Line 7: l_state_level number:=FND_LOG.LEVEL_STATEMENT;

3:
4: --Bug 3199488 Start Block
5: l_debug_level number:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6:
7: l_state_level number:=FND_LOG.LEVEL_STATEMENT;
8: l_proc_level number:=FND_LOG.LEVEL_PROCEDURE;
9: l_event_level number:=FND_LOG.LEVEL_EVENT;
10: l_excep_level number:=FND_LOG.LEVEL_EXCEPTION;
11: l_error_level number:=FND_LOG.LEVEL_ERROR;

Line 8: l_proc_level number:=FND_LOG.LEVEL_PROCEDURE;

4: --Bug 3199488 Start Block
5: l_debug_level number:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6:
7: l_state_level number:=FND_LOG.LEVEL_STATEMENT;
8: l_proc_level number:=FND_LOG.LEVEL_PROCEDURE;
9: l_event_level number:=FND_LOG.LEVEL_EVENT;
10: l_excep_level number:=FND_LOG.LEVEL_EXCEPTION;
11: l_error_level number:=FND_LOG.LEVEL_ERROR;
12: l_unexp_level number:=FND_LOG.LEVEL_UNEXPECTED;

Line 9: l_event_level number:=FND_LOG.LEVEL_EVENT;

5: l_debug_level number:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6:
7: l_state_level number:=FND_LOG.LEVEL_STATEMENT;
8: l_proc_level number:=FND_LOG.LEVEL_PROCEDURE;
9: l_event_level number:=FND_LOG.LEVEL_EVENT;
10: l_excep_level number:=FND_LOG.LEVEL_EXCEPTION;
11: l_error_level number:=FND_LOG.LEVEL_ERROR;
12: l_unexp_level number:=FND_LOG.LEVEL_UNEXPECTED;
13: --Bug 3199488 End Block

Line 10: l_excep_level number:=FND_LOG.LEVEL_EXCEPTION;

6:
7: l_state_level number:=FND_LOG.LEVEL_STATEMENT;
8: l_proc_level number:=FND_LOG.LEVEL_PROCEDURE;
9: l_event_level number:=FND_LOG.LEVEL_EVENT;
10: l_excep_level number:=FND_LOG.LEVEL_EXCEPTION;
11: l_error_level number:=FND_LOG.LEVEL_ERROR;
12: l_unexp_level number:=FND_LOG.LEVEL_UNEXPECTED;
13: --Bug 3199488 End Block
14:

Line 11: l_error_level number:=FND_LOG.LEVEL_ERROR;

7: l_state_level number:=FND_LOG.LEVEL_STATEMENT;
8: l_proc_level number:=FND_LOG.LEVEL_PROCEDURE;
9: l_event_level number:=FND_LOG.LEVEL_EVENT;
10: l_excep_level number:=FND_LOG.LEVEL_EXCEPTION;
11: l_error_level number:=FND_LOG.LEVEL_ERROR;
12: l_unexp_level number:=FND_LOG.LEVEL_UNEXPECTED;
13: --Bug 3199488 End Block
14:
15: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IGC_CC_OPEN_INTERFACE_PKG';

Line 12: l_unexp_level number:=FND_LOG.LEVEL_UNEXPECTED;

8: l_proc_level number:=FND_LOG.LEVEL_PROCEDURE;
9: l_event_level number:=FND_LOG.LEVEL_EVENT;
10: l_excep_level number:=FND_LOG.LEVEL_EXCEPTION;
11: l_error_level number:=FND_LOG.LEVEL_ERROR;
12: l_unexp_level number:=FND_LOG.LEVEL_UNEXPECTED;
13: --Bug 3199488 End Block
14:
15: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IGC_CC_OPEN_INTERFACE_PKG';
16:

Line 1330: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.populate_pa_table.Msg1',

1326: --Output_Debug('Exp Org ' || g_pa_fc_pay_rec_tab( l_index ).expenditure_organization_id);
1327:
1328: -- bug 3199488, start block
1329: IF (l_state_level >= l_debug_level) THEN
1330: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.populate_pa_table.Msg1',
1331: 'Project Id ' || g_pa_fc_pay_rec_tab( l_index ).project_id);
1332: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.populate_pa_table.Msg2',
1333: 'task Id ' || g_pa_fc_pay_rec_tab( l_index ).task_id);
1334: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.populate_pa_table.Msg3',

Line 1332: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.populate_pa_table.Msg2',

1328: -- bug 3199488, start block
1329: IF (l_state_level >= l_debug_level) THEN
1330: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.populate_pa_table.Msg1',
1331: 'Project Id ' || g_pa_fc_pay_rec_tab( l_index ).project_id);
1332: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.populate_pa_table.Msg2',
1333: 'task Id ' || g_pa_fc_pay_rec_tab( l_index ).task_id);
1334: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.populate_pa_table.Msg3',
1335: 'Exp Type ' || g_pa_fc_pay_rec_tab( l_index ).expenditure_type);
1336: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.populate_pa_table.Msg4',

Line 1334: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.populate_pa_table.Msg3',

1330: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.populate_pa_table.Msg1',
1331: 'Project Id ' || g_pa_fc_pay_rec_tab( l_index ).project_id);
1332: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.populate_pa_table.Msg2',
1333: 'task Id ' || g_pa_fc_pay_rec_tab( l_index ).task_id);
1334: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.populate_pa_table.Msg3',
1335: 'Exp Type ' || g_pa_fc_pay_rec_tab( l_index ).expenditure_type);
1336: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.populate_pa_table.Msg4',
1337: 'Ecp date ' || g_pa_fc_pay_rec_tab( l_index ).expenditure_item_date);
1338: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.populate_pa_table.Msg5',

Line 1336: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.populate_pa_table.Msg4',

1332: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.populate_pa_table.Msg2',
1333: 'task Id ' || g_pa_fc_pay_rec_tab( l_index ).task_id);
1334: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.populate_pa_table.Msg3',
1335: 'Exp Type ' || g_pa_fc_pay_rec_tab( l_index ).expenditure_type);
1336: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.populate_pa_table.Msg4',
1337: 'Ecp date ' || g_pa_fc_pay_rec_tab( l_index ).expenditure_item_date);
1338: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.populate_pa_table.Msg5',
1339: 'Exp Org ' || g_pa_fc_pay_rec_tab( l_index ).expenditure_organization_id);
1340: END IF;

Line 1338: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.populate_pa_table.Msg5',

1334: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.populate_pa_table.Msg3',
1335: 'Exp Type ' || g_pa_fc_pay_rec_tab( l_index ).expenditure_type);
1336: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.populate_pa_table.Msg4',
1337: 'Ecp date ' || g_pa_fc_pay_rec_tab( l_index ).expenditure_item_date);
1338: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.populate_pa_table.Msg5',
1339: 'Exp Org ' || g_pa_fc_pay_rec_tab( l_index ).expenditure_organization_id);
1340: END IF;
1341: -- bug 3199488, end block
1342:

Line 1459: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.header_interface_main.Msg1',

1455: -- THEN
1456: -- Output_Debug('Starting Open Interface Import process');
1457: -- bug 3199488, start block
1458: IF (l_state_level >= l_debug_level) THEN
1459: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.header_interface_main.Msg1',
1460: 'Starting Open Interface Import process');
1461: END IF;
1462: -- bug 3199488, end block
1463: -- END IF;

Line 1923: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.header_interface_main.Msg2',

1919: -- END IF;
1920:
1921: -- bug 3199488, start block
1922: IF (l_state_level >= l_debug_level) THEN
1923: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.header_interface_main.Msg2',
1924: 'Calling PA_cc_enc_import_fck.Load_pkts for ' ||
1925: ' packet id '|| to_char( g_bc_packet_id_com) ||
1926: ' for commitment budget');
1927: END IF;

Line 1951: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.header_interface_main.Msg3',

1947: -- END IF;
1948:
1949: -- bug 3199488, start block
1950: IF (l_state_level >= l_debug_level) THEN
1951: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.header_interface_main.Msg3',
1952: 'Calling PA_cc_enc_import_fck.Pa_enc_import_fck for ' ||
1953: ' packet id '|| to_char( g_bc_packet_id_com) ||
1954: ' for commitment budget');
1955: END IF;

Line 1986: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.header_interface_main.Msg4',

1982: -- END IF;
1983:
1984: -- bug 3199488, start block
1985: IF (l_state_level >= l_debug_level) THEN
1986: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.header_interface_main.Msg4',
1987: 'PA_cc_enc_import_fck.Pa_enc_import_fck ' ||
1988: ' failed for packet id '||
1989: ' for commitment budget with error - ' ||
1990: l_error_msg);

Line 2020: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.header_interface_main.Msg5',

2016: -- END IF;
2017:
2018: -- bug 3199488, start block
2019: IF (l_state_level >= l_debug_level) THEN
2020: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.header_interface_main.Msg5',
2021: 'PA_cc_enc_import_fck.Load_Pkt ' ||
2022: ' failed for packet id '||
2023: ' for commitment budget with error - ' ||
2024: l_error_msg);

Line 2059: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.header_interface_main.Msg6',

2055: -- END IF;
2056:
2057: -- bug 3199488, start block
2058: IF (l_state_level >= l_debug_level) THEN
2059: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.header_interface_main.Msg6',
2060: 'Calling PA_cc_enc_import_fck.Load_pkts for ' ||
2061: ' packet id '|| to_char( g_bc_packet_id_pay) ||
2062: ' for standard budget');
2063: END IF;

Line 2087: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.header_interface_main.Msg7',

2083: -- END IF;
2084:
2085: -- bug 3199488, start block
2086: IF (l_state_level >= l_debug_level) THEN
2087: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.header_interface_main.Msg7',
2088: 'Calling PA_cc_enc_import_fck.Pa_enc_import_fck for ' ||
2089: ' packet id '|| to_char( g_bc_packet_id_pay) ||
2090: ' for standard budget');
2091: END IF;

Line 2121: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.header_interface_main.Msg8',

2117: -- END IF;
2118:
2119: -- bug 3199488, start block
2120: IF (l_state_level >= l_debug_level) THEN
2121: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.header_interface_main.Msg8',
2122: 'PA_cc_enc_import_fck.Pa_enc_import_fck ' ||
2123: ' failed for packet id '||
2124: to_char( g_bc_packet_id_pay) ||
2125: ' for standard budget with error - ' ||

Line 2159: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.header_interface_main.Msg9',

2155: -- END IF;
2156:
2157: -- bug 3199488, start block
2158: IF (l_state_level >= l_debug_level) THEN
2159: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.header_interface_main.Msg9',
2160: 'PA_cc_enc_import_fck.Load_Pkt ' ||
2161: ' failed for packet id '||
2162: to_char( g_bc_packet_id_pay) ||
2163: ' for standard budget with error - ' ||

Line 2206: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.header_interface_main.Msg10',

2202: -- END IF;
2203:
2204: -- bug 3199488, start block
2205: IF (l_state_level >= l_debug_level) THEN
2206: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.header_interface_main.Msg10',
2207: 'Calling PA_cc_enc_import_fck.Pa_enc_import_fck_tieback for ' ||
2208: ' packet id '|| to_char( g_bc_packet_id_com) ||
2209: ' for commitment budget');
2210: END IF;

Line 2234: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.header_interface_main.Msg11',

2230: -- END IF;
2231:
2232: -- bug 3199488, start block
2233: IF (l_state_level >= l_debug_level) THEN
2234: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.header_interface_main.Msg11',
2235: 'PA_cc_enc_import_fck.Pa_enc_import_fck_tieback '||
2236: ' failed for ' ||
2237: ' packet id '|| to_char( g_bc_packet_id_com) ||
2238: ' for commitment budget');

Line 2266: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.header_interface_main.Msg12',

2262: -- END IF;
2263:
2264: -- bug 3199488, start block
2265: IF (l_state_level >= l_debug_level) THEN
2266: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.header_interface_main.Msg12',
2267: 'Calling PA_cc_enc_import_fck.Pa_enc_import_fck_tieback for ' ||
2268: ' packet id '|| to_char( g_bc_packet_id_pay) ||
2269: ' for standard budget');
2270: END IF;

Line 2294: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.header_interface_main.Msg13',

2290: -- END IF;
2291:
2292: -- bug 3199488, start block
2293: IF (l_state_level >= l_debug_level) THEN
2294: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.header_interface_main.Msg13',
2295: 'PA_cc_enc_import_fck.Pa_enc_import_fck_tieback '||
2296: ' failed for ' ||
2297: ' packet id '|| to_char( g_bc_packet_id_pay) ||
2298: ' for payment budget');

Line 2412: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.header_interface_main.Msg14',

2408: --END IF;
2409:
2410: -- bug 3199488, start block
2411: IF (l_state_level >= l_debug_level) THEN
2412: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.header_interface_main.Msg14',
2413: 'Deleting rows from interface tables ..');
2414: END IF;
2415: -- bug 3199488, end block
2416:

Line 2442: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.header_interface_main.Excp1',

2438: -- fnd_file.put_line (FND_FILE.LOG,
2439: -- l_error_text);
2440: -- bug 3199488 start block
2441: IF (l_state_level >= l_debug_level) THEN
2442: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.header_interface_main.Excp1',
2443: l_error_text);
2444: END IF;
2445: -- bug 3199488, end block
2446: END LOOP;

Line 2462: FND_LOG.MESSAGE(l_unexp_level, 'igc.plsql.igc_cc_open_interface_pkg.header_interface_main.Unexp1',TRUE);

2458: IF (l_unexp_level >= l_debug_level) THEN
2459: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
2460: FND_MESSAGE.SET_TOKEN('CODE',sqlcode);
2461: FND_MESSAGE.SET_TOKEN('MSG',sqlerrm);
2462: FND_LOG.MESSAGE(l_unexp_level, 'igc.plsql.igc_cc_open_interface_pkg.header_interface_main.Unexp1',TRUE);
2463: END IF;
2464: -- bug 3199488, end block
2465:
2466: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,

Line 2478: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.header_interface_main.Excp2',

2474: -- fnd_file.put_line (FND_FILE.LOG,
2475: -- l_error_text);
2476: -- bug 3199488 start block
2477: IF (l_state_level >= l_debug_level) THEN
2478: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_open_interface_pkg.header_interface_main.Excp2',
2479: l_error_text);
2480: END IF;
2481: -- bug 3199488, end block
2482: END LOOP;

Line 3638: FND_LOG.MESSAGE(l_unexp_level, 'igc.plsql.igc_cc_open_interface_pkg.acct_line_interface_main.Unexp1',TRUE);

3634: IF (l_unexp_level >= l_debug_level) THEN
3635: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3636: FND_MESSAGE.SET_TOKEN('CODE',sqlcode);
3637: FND_MESSAGE.SET_TOKEN('MSG',sqlerrm);
3638: FND_LOG.MESSAGE(l_unexp_level, 'igc.plsql.igc_cc_open_interface_pkg.acct_line_interface_main.Unexp1',TRUE);
3639: END IF;
3640: -- bug 3199488, end block
3641: P_X_Error_Status := 'U';
3642:

Line 4668: FND_LOG.MESSAGE(l_unexp_level, 'igc.plsql.igc_cc_open_interface_pkg.det_pf_interface_main.Unexp1',TRUE);

4664: IF (l_unexp_level >= l_debug_level) THEN
4665: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
4666: FND_MESSAGE.SET_TOKEN('CODE',sqlcode);
4667: FND_MESSAGE.SET_TOKEN('MSG',sqlerrm);
4668: FND_LOG.MESSAGE(l_unexp_level, 'igc.plsql.igc_cc_open_interface_pkg.det_pf_interface_main.Unexp1',TRUE);
4669: END IF;
4670: -- bug 3199488, end block
4671: P_X_Error_Status := 'U';
4672: END;