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 PA_CC_ENC_IMPORT_FCK

Line 38: -- We use PA PLSQL table definition PA_CC_ENC_IMPORT_FCK.FC_Rec_Table, which has

34:
35:
36: -- Bug 2871052, created the following PLSQL tables for inserting into
37: -- the pa_bc_packets table.
38: -- We use PA PLSQL table definition PA_CC_ENC_IMPORT_FCK.FC_Rec_Table, which has
39: -- the following structure :-
40: -- TYPE fc_rec_table IS RECORD (
41: -- packet_id pa_bc_packets.packet_id%type,
42: -- bc_packet_id pa_bc_packets.bc_packet_id%type,

Line 87: g_pa_fc_com_rec_tab PA_CC_ENC_IMPORT_FCK.FC_Rec_Table;

83: -- creation_date pa_bc_packets.creation_date%type,
84: -- last_update_login pa_bc_packets.last_update_login%type );
85:
86: -- This is a table of records to check funds in the commitment budget.
87: g_pa_fc_com_rec_tab PA_CC_ENC_IMPORT_FCK.FC_Rec_Table;
88:
89: -- This is a table of records to check funds in the payment budget.
90: g_pa_fc_pay_rec_tab PA_CC_ENC_IMPORT_FCK.FC_Rec_Table;
91:

Line 90: g_pa_fc_pay_rec_tab PA_CC_ENC_IMPORT_FCK.FC_Rec_Table;

86: -- This is a table of records to check funds in the commitment budget.
87: g_pa_fc_com_rec_tab PA_CC_ENC_IMPORT_FCK.FC_Rec_Table;
88:
89: -- This is a table of records to check funds in the payment budget.
90: g_pa_fc_pay_rec_tab PA_CC_ENC_IMPORT_FCK.FC_Rec_Table;
91:
92: g_pa_fc_com_counter NUMBER := 0;
93: g_pa_fc_pay_counter NUMBER := 0;
94: g_bc_packet_id_com NUMBER;

Line 1916: -- Output_Debug('Calling PA_cc_enc_import_fck.Load_pkts for ' ||

1912: l_pa_cb_funds_check_pass := TRUE;
1913:
1914: -- IF g_debug_flag = 'Y'
1915: -- THEN
1916: -- Output_Debug('Calling PA_cc_enc_import_fck.Load_pkts for ' ||
1917: -- ' packet id '|| to_char( g_bc_packet_id_com) ||
1918: -- ' for commitment budget');
1919: -- END IF;
1920:

Line 1924: 'Calling PA_cc_enc_import_fck.Load_pkts for ' ||

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;
1928: -- bug 3199488, end block

Line 1932: PA_cc_enc_import_fck.Load_pkts(

1928: -- bug 3199488, end block
1929:
1930: -- Call PA API to insert rows in pa_bc_packets
1931: -- This API loads the rows in an autonomous mode.
1932: PA_cc_enc_import_fck.Load_pkts(
1933: p_calling_module => 'CCTRXIMPORT',
1934: p_ext_budget_type => 'CC',
1935: p_packet_id => g_bc_packet_id_com,
1936: p_fc_rec_tab => g_pa_fc_com_rec_tab,

Line 1944: -- Output_Debug('Calling PA_cc_enc_import_fck.Pa_enc_import_fck for ' ||

1940: IF l_return_status = 'S'
1941: THEN
1942: -- IF g_debug_flag = 'Y'
1943: -- THEN
1944: -- Output_Debug('Calling PA_cc_enc_import_fck.Pa_enc_import_fck for ' ||
1945: -- ' packet id '|| to_char( g_bc_packet_id_com) ||
1946: -- ' for commitment budget');
1947: -- END IF;
1948:

Line 1952: 'Calling PA_cc_enc_import_fck.Pa_enc_import_fck for ' ||

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;
1956: -- bug 3199488, end block

Line 1959: pa_cc_enc_import_fck.Pa_enc_import_fck(

1955: END IF;
1956: -- bug 3199488, end block
1957:
1958: -- Call PA Funds checker for all commitment records.
1959: pa_cc_enc_import_fck.Pa_enc_import_fck(
1960: p_calling_module => 'CCTRXIMPORT',
1961: p_ext_budget_type => 'CC',
1962: p_conc_flag => 'Y',
1963: p_set_of_book_id => l_current_set_of_books_id,

Line 1977: -- Output_Debug('PA_cc_enc_import_fck.Pa_enc_import_fck ' ||

1973: l_pa_cb_funds_check_pass := FALSE;
1974:
1975: -- IF g_debug_flag = 'Y'
1976: -- THEN
1977: -- Output_Debug('PA_cc_enc_import_fck.Pa_enc_import_fck ' ||
1978: -- ' failed for packet id '||
1979: -- to_char( g_bc_packet_id_com) ||
1980: -- ' for commitment budget with error - ' ||
1981: -- l_error_msg);

Line 1987: 'PA_cc_enc_import_fck.Pa_enc_import_fck ' ||

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);
1991: END IF;

Line 2011: -- Output_Debug('PA_cc_enc_import_fck.Load_Pkt ' ||

2007: ELSE -- insert into pa_bc_packet unsuccessfull.
2008: l_pa_cb_funds_check_pass := FALSE;
2009: -- IF g_debug_flag = 'Y'
2010: -- THEN
2011: -- Output_Debug('PA_cc_enc_import_fck.Load_Pkt ' ||
2012: -- ' failed for packet id '||
2013: -- to_char( g_bc_packet_id_com) ||
2014: -- ' for commitment budget with error - ' ||
2015: -- l_error_msg);

Line 2021: 'PA_cc_enc_import_fck.Load_Pkt ' ||

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);
2025: END IF;

Line 2052: -- Output_Debug('Calling PA_cc_enc_import_fck.Load_pkts for ' ||

2048: THEN
2049: l_pa_sb_funds_check_pass := TRUE;
2050: -- IF g_debug_flag = 'Y'
2051: -- THEN
2052: -- Output_Debug('Calling PA_cc_enc_import_fck.Load_pkts for ' ||
2053: -- ' packet id '|| to_char( g_bc_packet_id_pay) ||
2054: -- ' for standard budget');
2055: -- END IF;
2056:

Line 2060: 'Calling PA_cc_enc_import_fck.Load_pkts for ' ||

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;
2064: -- bug 3199488, end block

Line 2068: PA_cc_enc_import_fck.Load_pkts(

2064: -- bug 3199488, end block
2065:
2066: -- Call PA API to insert rows in pa_bc_packets
2067: -- This is done in autonomous mode
2068: PA_cc_enc_import_fck.Load_pkts(
2069: p_calling_module => 'CCTRXIMPORT',
2070: p_ext_budget_type => 'GL',
2071: p_packet_id => g_bc_packet_id_pay,
2072: p_fc_rec_tab => g_pa_fc_pay_rec_tab,

Line 2080: -- Output_Debug('Calling PA_cc_enc_import_fck.Pa_enc_import_fck for ' ||

2076: IF l_return_status = 'S'
2077: THEN
2078: -- IF g_debug_flag = 'Y'
2079: -- THEN
2080: -- Output_Debug('Calling PA_cc_enc_import_fck.Pa_enc_import_fck for ' ||
2081: -- ' packet id '|| to_char( g_bc_packet_id_pay) ||
2082: -- ' for standard budget');
2083: -- END IF;
2084:

Line 2088: 'Calling PA_cc_enc_import_fck.Pa_enc_import_fck for ' ||

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;
2092: -- bug 3199488, end block

Line 2095: pa_cc_enc_import_fck.Pa_enc_import_fck(

2091: END IF;
2092: -- bug 3199488, end block
2093:
2094: -- Call PA Funds checker for all payment records.
2095: pa_cc_enc_import_fck.Pa_enc_import_fck(
2096: p_calling_module => 'CCTRXIMPORT',
2097: p_ext_budget_type => 'GL',
2098: p_conc_flag => 'Y',
2099: p_set_of_book_id => l_current_set_of_books_id,

Line 2112: -- Output_Debug('PA_cc_enc_import_fck.Pa_enc_import_fck ' ||

2108: l_pa_sb_funds_check_pass := FALSE;
2109:
2110: -- IF g_debug_flag = 'Y'
2111: -- THEN
2112: -- Output_Debug('PA_cc_enc_import_fck.Pa_enc_import_fck ' ||
2113: -- ' failed for packet id '||
2114: -- to_char( g_bc_packet_id_pay) ||
2115: -- ' for standard budget with error - ' ||
2116: -- l_error_msg);

Line 2122: 'PA_cc_enc_import_fck.Pa_enc_import_fck ' ||

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 - ' ||
2126: l_error_msg);

Line 2150: -- Output_Debug('PA_cc_enc_import_fck.Load_Pkt ' ||

2146: l_pa_sb_funds_check_pass := FALSE;
2147:
2148: -- IF g_debug_flag = 'Y'
2149: -- THEN
2150: -- Output_Debug('PA_cc_enc_import_fck.Load_Pkt ' ||
2151: -- ' failed for packet id '||
2152: -- to_char( g_bc_packet_id_pay) ||
2153: -- ' for standard budget with error - ' ||
2154: -- l_error_msg);

Line 2160: 'PA_cc_enc_import_fck.Load_Pkt ' ||

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 - ' ||
2164: l_error_msg);

Line 2199: -- Output_Debug('Calling PA_cc_enc_import_fck.Pa_enc_import_fck_tieback for ' ||

2195: IF g_pa_cb_funds_check_required
2196: THEN
2197: -- IF g_debug_flag = 'Y'
2198: -- THEN
2199: -- Output_Debug('Calling PA_cc_enc_import_fck.Pa_enc_import_fck_tieback for ' ||
2200: -- ' packet id '|| to_char( g_bc_packet_id_com) ||
2201: -- ' for commitment budget');
2202: -- END IF;
2203:

Line 2207: 'Calling PA_cc_enc_import_fck.Pa_enc_import_fck_tieback for ' ||

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;
2211: -- bug 3199488, end block

Line 2213: PA_CC_enc_import_fck.Pa_enc_import_fck_tieback

2209: ' for commitment budget');
2210: END IF;
2211: -- bug 3199488, end block
2212:
2213: PA_CC_enc_import_fck.Pa_enc_import_fck_tieback
2214: (p_calling_module => 'CCTRXIMPORT',
2215: p_ext_budget_type => 'CC',
2216: p_packet_id => g_bc_packet_id_com,
2217: p_mode => 'R',

Line 2226: -- Output_Debug('PA_cc_enc_import_fck.Pa_enc_import_fck_tieback '||

2222: IF l_return_status <> 'S'
2223: THEN
2224: -- IF g_debug_flag = 'Y'
2225: -- THEN
2226: -- Output_Debug('PA_cc_enc_import_fck.Pa_enc_import_fck_tieback '||
2227: -- ' failed for ' ||
2228: -- ' packet id '|| to_char( g_bc_packet_id_com) ||
2229: -- ' for commitment budget');
2230: -- END IF;

Line 2235: 'PA_cc_enc_import_fck.Pa_enc_import_fck_tieback '||

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');
2239: END IF;

Line 2259: -- Output_Debug('Calling PA_cc_enc_import_fck.Pa_enc_import_fck_tieback for ' ||

2255: IF g_pa_sb_funds_check_required
2256: THEN
2257: -- IF g_debug_flag = 'Y'
2258: -- THEN
2259: -- Output_Debug('Calling PA_cc_enc_import_fck.Pa_enc_import_fck_tieback for ' ||
2260: -- ' packet id '|| to_char( g_bc_packet_id_pay) ||
2261: -- ' for standard budget');
2262: -- END IF;
2263:

Line 2267: 'Calling PA_cc_enc_import_fck.Pa_enc_import_fck_tieback for ' ||

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;
2271: -- bug 3199488, end block

Line 2273: PA_CC_enc_import_fck.Pa_enc_import_fck_tieback

2269: ' for standard budget');
2270: END IF;
2271: -- bug 3199488, end block
2272:
2273: PA_CC_enc_import_fck.Pa_enc_import_fck_tieback
2274: (p_calling_module => 'CCTRXIMPORT',
2275: p_ext_budget_type => 'GL',
2276: p_packet_id => g_bc_packet_id_pay,
2277: p_mode => 'R',

Line 2286: -- Output_Debug('PA_cc_enc_import_fck.Pa_enc_import_fck_tieback '||

2282: IF l_return_status <> 'S'
2283: THEN
2284: -- IF g_debug_flag = 'Y'
2285: -- THEN
2286: -- Output_Debug('PA_cc_enc_import_fck.Pa_enc_import_fck_tieback '||
2287: -- ' failed for ' ||
2288: -- ' packet id '|| to_char( g_bc_packet_id_pay) ||
2289: -- ' for payment budget');
2290: -- END IF;

Line 2295: 'PA_cc_enc_import_fck.Pa_enc_import_fck_tieback '||

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');
2299: END IF;

Line 2494: PA_CC_enc_import_fck.Pa_enc_import_fck_tieback

2490: -- Bug 2871052
2491: IF g_pa_cb_funds_check_required
2492: THEN
2493: -- Call PA tieback API.
2494: PA_CC_enc_import_fck.Pa_enc_import_fck_tieback
2495: (p_calling_module => 'CCTRXIMPORT',
2496: p_ext_budget_type => 'CC',
2497: p_packet_id => g_bc_packet_id_com,
2498: p_mode => 'R',

Line 2506: PA_CC_enc_import_fck.Pa_enc_import_fck_tieback

2502: END IF;
2503:
2504: IF g_pa_sb_funds_check_required
2505: THEN
2506: PA_CC_enc_import_fck.Pa_enc_import_fck_tieback
2507: (p_calling_module => 'CCTRXIMPORT',
2508: p_ext_budget_type => 'GL',
2509: p_packet_id => g_bc_packet_id_pay,
2510: p_mode => 'R',