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.XTR_AUTO_RECONCILIATION dependencies on UTL_FILE

Line 1686: WHERE name = 'utl_file_dir';

1682: ;
1683: CURSOR c_file_dir IS
1684: SELECT SUBSTR(value,1,DECODE(INSTR(value,','),0,LENGTH(value),INSTR(value,',')-1) )
1685: FROM v$parameter
1686: WHERE name = 'utl_file_dir';
1687: l_file utl_file.file_type;
1688: l_dirname VARCHAR2(1000);
1689: --
1690: begin

Line 1687: l_file utl_file.file_type;

1683: CURSOR c_file_dir IS
1684: SELECT SUBSTR(value,1,DECODE(INSTR(value,','),0,LENGTH(value),INSTR(value,',')-1) )
1685: FROM v$parameter
1686: WHERE name = 'utl_file_dir';
1687: l_file utl_file.file_type;
1688: l_dirname VARCHAR2(1000);
1689: --
1690: begin
1691:

Line 1695: l_file := utl_file.fopen(l_dirname,'xtraurec.log','w');

1691:
1692: OPEN c_file_dir;
1693: FETCH c_file_dir INTO l_dirname;
1694: CLOSE c_file_dir;
1695: l_file := utl_file.fopen(l_dirname,'xtraurec.log','w');
1696:
1697: --
1698: -- set parameteres
1699: --

Line 1851: utl_file.put_line (l_file,'>>----DDA_SUM_DATE');

1847: --dbms_output.put_line(' DDA_SUM_DATE date, amt, no-rec, net# '||l_s_date||' - '||l_sum_amt||' - '||l_num_recs||' - '||v_netoff_number);
1848:
1849: EXIT WHEN DDA_SUM_DATE%NOTFOUND;
1850: /***************/
1851: utl_file.put_line (l_file,'>>----DDA_SUM_DATE');
1852: utl_file.put_line (l_file,'>>----net#, date, amt no-recs '||v_netoff_number||' - '||l_s_date||' - '||l_sum_amt||' - '||l_num_Recs);
1853: utl_file.put_line (l_file,'>>------------------------------');
1854: /***************/
1855:

Line 1852: utl_file.put_line (l_file,'>>----net#, date, amt no-recs '||v_netoff_number||' - '||l_s_date||' - '||l_sum_amt||' - '||l_num_Recs);

1848:
1849: EXIT WHEN DDA_SUM_DATE%NOTFOUND;
1850: /***************/
1851: utl_file.put_line (l_file,'>>----DDA_SUM_DATE');
1852: utl_file.put_line (l_file,'>>----net#, date, amt no-recs '||v_netoff_number||' - '||l_s_date||' - '||l_sum_amt||' - '||l_num_Recs);
1853: utl_file.put_line (l_file,'>>------------------------------');
1854: /***************/
1855:
1856: if nvl(rec_det.DEBIT_AMOUNT,0) <> 0 then

Line 1853: utl_file.put_line (l_file,'>>------------------------------');

1849: EXIT WHEN DDA_SUM_DATE%NOTFOUND;
1850: /***************/
1851: utl_file.put_line (l_file,'>>----DDA_SUM_DATE');
1852: utl_file.put_line (l_file,'>>----net#, date, amt no-recs '||v_netoff_number||' - '||l_s_date||' - '||l_sum_amt||' - '||l_num_Recs);
1853: utl_file.put_line (l_file,'>>------------------------------');
1854: /***************/
1855:
1856: if nvl(rec_det.DEBIT_AMOUNT,0) <> 0 then
1857: if ((((-1) * rec_det.DEBIT_AMOUNT) = l_sum_amt and l_amount =

Line 1890: utl_file.put_line (l_file,'>>----DDA_SUM_DATE');

1886:
1887:
1888: If v_netoff_number is null then
1889: /***************/
1890: utl_file.put_line (l_file,'>>----DDA_SUM_DATE');
1891: utl_file.put_line (l_file,'>>---- inside IF ');
1892: utl_file.put_line (l_file,'>>------------------------------');
1893: /***************/
1894:

Line 1891: utl_file.put_line (l_file,'>>---- inside IF ');

1887:
1888: If v_netoff_number is null then
1889: /***************/
1890: utl_file.put_line (l_file,'>>----DDA_SUM_DATE');
1891: utl_file.put_line (l_file,'>>---- inside IF ');
1892: utl_file.put_line (l_file,'>>------------------------------');
1893: /***************/
1894:
1895: update XTR_DEAL_DATE_AMOUNTS

Line 1892: utl_file.put_line (l_file,'>>------------------------------');

1888: If v_netoff_number is null then
1889: /***************/
1890: utl_file.put_line (l_file,'>>----DDA_SUM_DATE');
1891: utl_file.put_line (l_file,'>>---- inside IF ');
1892: utl_file.put_line (l_file,'>>------------------------------');
1893: /***************/
1894:
1895: update XTR_DEAL_DATE_AMOUNTS
1896: set RECONCILED_REFERENCE = l_rec_nos,

Line 1933: utl_file.put_line (l_file,'>>----DDA_SUM_DATE');

1929: and PORTFOLIO_CODE like nvl(l_portfolio,'%')
1930: and ((date_type <>'FORCAST' and NVL(P_INCL_RTM, 'N')='N') or NVL(P_INCL_RTM, 'N')='Y');
1931: If SQL%FOUND then
1932: /***************/
1933: utl_file.put_line (l_file,'>>----DDA_SUM_DATE');
1934: utl_file.put_line (l_file,'>>---- UPD complete deal# '||rtrim(rec_det.particulars));
1935: utl_file.put_line (l_file,'>>------------------------------');
1936: /***************/
1937: For C2_Rec in C2(l_Rec_nos)

Line 1934: utl_file.put_line (l_file,'>>---- UPD complete deal# '||rtrim(rec_det.particulars));

1930: and ((date_type <>'FORCAST' and NVL(P_INCL_RTM, 'N')='N') or NVL(P_INCL_RTM, 'N')='Y');
1931: If SQL%FOUND then
1932: /***************/
1933: utl_file.put_line (l_file,'>>----DDA_SUM_DATE');
1934: utl_file.put_line (l_file,'>>---- UPD complete deal# '||rtrim(rec_det.particulars));
1935: utl_file.put_line (l_file,'>>------------------------------');
1936: /***************/
1937: For C2_Rec in C2(l_Rec_nos)
1938: Loop

Line 1935: utl_file.put_line (l_file,'>>------------------------------');

1931: If SQL%FOUND then
1932: /***************/
1933: utl_file.put_line (l_file,'>>----DDA_SUM_DATE');
1934: utl_file.put_line (l_file,'>>---- UPD complete deal# '||rtrim(rec_det.particulars));
1935: utl_file.put_line (l_file,'>>------------------------------');
1936: /***************/
1937: For C2_Rec in C2(l_Rec_nos)
1938: Loop
1939: Update Xtr_Settlement_Summary

Line 1943: utl_file.put_line(l_file, '>>----DDA_SUM_DATE ------');

1939: Update Xtr_Settlement_Summary
1940: Set status = 'R'
1941: Where settlement_number = C2_Rec.settlement_number;
1942: /***************/
1943: utl_file.put_line(l_file, '>>----DDA_SUM_DATE ------');
1944: utl_file.put_line(l_file, '>>----UPD settlement_summary complete settle# '||C2_Rec.settlement_number);
1945: utl_file.put_line(l_file, '>>------------------------------------');
1946: /**************/
1947: End Loop;

Line 1944: utl_file.put_line(l_file, '>>----UPD settlement_summary complete settle# '||C2_Rec.settlement_number);

1940: Set status = 'R'
1941: Where settlement_number = C2_Rec.settlement_number;
1942: /***************/
1943: utl_file.put_line(l_file, '>>----DDA_SUM_DATE ------');
1944: utl_file.put_line(l_file, '>>----UPD settlement_summary complete settle# '||C2_Rec.settlement_number);
1945: utl_file.put_line(l_file, '>>------------------------------------');
1946: /**************/
1947: End Loop;
1948: End if;

Line 1945: utl_file.put_line(l_file, '>>------------------------------------');

1941: Where settlement_number = C2_Rec.settlement_number;
1942: /***************/
1943: utl_file.put_line(l_file, '>>----DDA_SUM_DATE ------');
1944: utl_file.put_line(l_file, '>>----UPD settlement_summary complete settle# '||C2_Rec.settlement_number);
1945: utl_file.put_line(l_file, '>>------------------------------------');
1946: /**************/
1947: End Loop;
1948: End if;
1949: Else

Line 1951: utl_file.put_line (l_file,'>>----DDA_SUM_DATE');

1947: End Loop;
1948: End if;
1949: Else
1950: /***************/
1951: utl_file.put_line (l_file,'>>----DDA_SUM_DATE');
1952: utl_file.put_line (l_file,'>>---- inside ELSE ');
1953: utl_file.put_line (l_file,'>>------------------------------');
1954: /***************/
1955:

Line 1952: utl_file.put_line (l_file,'>>---- inside ELSE ');

1948: End if;
1949: Else
1950: /***************/
1951: utl_file.put_line (l_file,'>>----DDA_SUM_DATE');
1952: utl_file.put_line (l_file,'>>---- inside ELSE ');
1953: utl_file.put_line (l_file,'>>------------------------------');
1954: /***************/
1955:
1956: update XTR_DEAL_DATE_AMOUNTS

Line 1953: utl_file.put_line (l_file,'>>------------------------------');

1949: Else
1950: /***************/
1951: utl_file.put_line (l_file,'>>----DDA_SUM_DATE');
1952: utl_file.put_line (l_file,'>>---- inside ELSE ');
1953: utl_file.put_line (l_file,'>>------------------------------');
1954: /***************/
1955:
1956: update XTR_DEAL_DATE_AMOUNTS
1957: set RECONCILED_REFERENCE = l_rec_nos,

Line 1998: utl_file.put_line (l_file,'>>----DDA_SUM_DATE');

1994: and PORTFOLIO_CODE like nvl(l_portfolio,'%')
1995: and ((date_type <>'FORCAST' and NVL(P_INCL_RTM, 'N')='N') or NVL(P_INCL_RTM, 'N')='Y');
1996: If SQL%FOUND then
1997: /***************/
1998: utl_file.put_line (l_file,'>>----DDA_SUM_DATE');
1999: utl_file.put_line (l_file,'>>---- UPD complete deal# '||rtrim(rec_det.particulars));
2000: utl_file.put_line (l_file,'>>------------------------------');
2001: /***************/
2002: For C1_Rec in C1(v_netoff_number)

Line 1999: utl_file.put_line (l_file,'>>---- UPD complete deal# '||rtrim(rec_det.particulars));

1995: and ((date_type <>'FORCAST' and NVL(P_INCL_RTM, 'N')='N') or NVL(P_INCL_RTM, 'N')='Y');
1996: If SQL%FOUND then
1997: /***************/
1998: utl_file.put_line (l_file,'>>----DDA_SUM_DATE');
1999: utl_file.put_line (l_file,'>>---- UPD complete deal# '||rtrim(rec_det.particulars));
2000: utl_file.put_line (l_file,'>>------------------------------');
2001: /***************/
2002: For C1_Rec in C1(v_netoff_number)
2003: Loop

Line 2000: utl_file.put_line (l_file,'>>------------------------------');

1996: If SQL%FOUND then
1997: /***************/
1998: utl_file.put_line (l_file,'>>----DDA_SUM_DATE');
1999: utl_file.put_line (l_file,'>>---- UPD complete deal# '||rtrim(rec_det.particulars));
2000: utl_file.put_line (l_file,'>>------------------------------');
2001: /***************/
2002: For C1_Rec in C1(v_netoff_number)
2003: Loop
2004: Update Xtr_Settlement_Summary

Line 2008: utl_file.put_line(l_file, '>>----DDA ------');

2004: Update Xtr_Settlement_Summary
2005: Set status = 'R'
2006: Where settlement_summary_id = C1_Rec.net_ID;
2007: /***************/
2008: utl_file.put_line(l_file, '>>----DDA ------');
2009: utl_file.put_line(l_file, '>>----UPD settlement_summary complete netID '||C1_Rec.net_id);
2010: utl_file.put_line(l_file, '>>------------------------------------');
2011: /**************/
2012: End Loop;

Line 2009: utl_file.put_line(l_file, '>>----UPD settlement_summary complete netID '||C1_Rec.net_id);

2005: Set status = 'R'
2006: Where settlement_summary_id = C1_Rec.net_ID;
2007: /***************/
2008: utl_file.put_line(l_file, '>>----DDA ------');
2009: utl_file.put_line(l_file, '>>----UPD settlement_summary complete netID '||C1_Rec.net_id);
2010: utl_file.put_line(l_file, '>>------------------------------------');
2011: /**************/
2012: End Loop;
2013: End if;

Line 2010: utl_file.put_line(l_file, '>>------------------------------------');

2006: Where settlement_summary_id = C1_Rec.net_ID;
2007: /***************/
2008: utl_file.put_line(l_file, '>>----DDA ------');
2009: utl_file.put_line(l_file, '>>----UPD settlement_summary complete netID '||C1_Rec.net_id);
2010: utl_file.put_line(l_file, '>>------------------------------------');
2011: /**************/
2012: End Loop;
2013: End if;
2014: End if;

Line 2050: utl_file.put_line (l_file,'>>----not known');

2046:
2047: --dbms_output.put_line('bef UPD ');
2048: If v_netoff_number is null then
2049: /***************/
2050: utl_file.put_line (l_file,'>>----not known');
2051: utl_file.put_line (l_file,'>>---- inside IF '||v_netoff_number);
2052: utl_file.put_line (l_file,'>>------------------------------');
2053: /***************/
2054:

Line 2051: utl_file.put_line (l_file,'>>---- inside IF '||v_netoff_number);

2047: --dbms_output.put_line('bef UPD ');
2048: If v_netoff_number is null then
2049: /***************/
2050: utl_file.put_line (l_file,'>>----not known');
2051: utl_file.put_line (l_file,'>>---- inside IF '||v_netoff_number);
2052: utl_file.put_line (l_file,'>>------------------------------');
2053: /***************/
2054:
2055: update XTR_DEAL_DATE_AMOUNTS

Line 2052: utl_file.put_line (l_file,'>>------------------------------');

2048: If v_netoff_number is null then
2049: /***************/
2050: utl_file.put_line (l_file,'>>----not known');
2051: utl_file.put_line (l_file,'>>---- inside IF '||v_netoff_number);
2052: utl_file.put_line (l_file,'>>------------------------------');
2053: /***************/
2054:
2055: update XTR_DEAL_DATE_AMOUNTS
2056: set RECONCILED_REFERENCE = l_rec_nos,

Line 2094: utl_file.put_line (l_file,'>>----not known');

2090: and PORTFOLIO_CODE like nvl(l_portfolio,'%')
2091: and ((date_type <>'FORCAST' and NVL(P_INCL_RTM,'N')='N') or NVL(P_INCL_RTM, 'N')='Y');
2092: If SQL%FOUND then
2093: /***************/
2094: utl_file.put_line (l_file,'>>----not known');
2095: utl_file.put_line (l_file,'>>---- UPD complete ');
2096: utl_file.put_line (l_file,'>>------------------------------');
2097: /***************/
2098: For C2_Rec in C2(l_rec_nos)

Line 2095: utl_file.put_line (l_file,'>>---- UPD complete ');

2091: and ((date_type <>'FORCAST' and NVL(P_INCL_RTM,'N')='N') or NVL(P_INCL_RTM, 'N')='Y');
2092: If SQL%FOUND then
2093: /***************/
2094: utl_file.put_line (l_file,'>>----not known');
2095: utl_file.put_line (l_file,'>>---- UPD complete ');
2096: utl_file.put_line (l_file,'>>------------------------------');
2097: /***************/
2098: For C2_Rec in C2(l_rec_nos)
2099: Loop

Line 2096: utl_file.put_line (l_file,'>>------------------------------');

2092: If SQL%FOUND then
2093: /***************/
2094: utl_file.put_line (l_file,'>>----not known');
2095: utl_file.put_line (l_file,'>>---- UPD complete ');
2096: utl_file.put_line (l_file,'>>------------------------------');
2097: /***************/
2098: For C2_Rec in C2(l_rec_nos)
2099: Loop
2100: Update Xtr_Settlement_Summary

Line 2104: utl_file.put_line(l_file, '>>----DDA_SUM_DATE ------');

2100: Update Xtr_Settlement_Summary
2101: Set status = 'R'
2102: Where settlement_number = C2_Rec.settlement_number;
2103: /***************/
2104: utl_file.put_line(l_file, '>>----DDA_SUM_DATE ------');
2105: utl_file.put_line(l_file, '>>----UPD settlement_summary complete settle# '||C2_Rec.settlement_number);
2106: utl_file.put_line(l_file, '>>------------------------------------');
2107: /**************/
2108: End Loop;

Line 2105: utl_file.put_line(l_file, '>>----UPD settlement_summary complete settle# '||C2_Rec.settlement_number);

2101: Set status = 'R'
2102: Where settlement_number = C2_Rec.settlement_number;
2103: /***************/
2104: utl_file.put_line(l_file, '>>----DDA_SUM_DATE ------');
2105: utl_file.put_line(l_file, '>>----UPD settlement_summary complete settle# '||C2_Rec.settlement_number);
2106: utl_file.put_line(l_file, '>>------------------------------------');
2107: /**************/
2108: End Loop;
2109: End if;

Line 2106: utl_file.put_line(l_file, '>>------------------------------------');

2102: Where settlement_number = C2_Rec.settlement_number;
2103: /***************/
2104: utl_file.put_line(l_file, '>>----DDA_SUM_DATE ------');
2105: utl_file.put_line(l_file, '>>----UPD settlement_summary complete settle# '||C2_Rec.settlement_number);
2106: utl_file.put_line(l_file, '>>------------------------------------');
2107: /**************/
2108: End Loop;
2109: End if;
2110: Else

Line 2112: utl_file.put_line (l_file,'>>----not known');

2108: End Loop;
2109: End if;
2110: Else
2111: /***************/
2112: utl_file.put_line (l_file,'>>----not known');
2113: utl_file.put_line (l_file,'>>---- inside ELSE ');
2114: utl_file.put_line (l_file,'>>------------------------------');
2115: /***************/
2116:

Line 2113: utl_file.put_line (l_file,'>>---- inside ELSE ');

2109: End if;
2110: Else
2111: /***************/
2112: utl_file.put_line (l_file,'>>----not known');
2113: utl_file.put_line (l_file,'>>---- inside ELSE ');
2114: utl_file.put_line (l_file,'>>------------------------------');
2115: /***************/
2116:
2117: update XTR_DEAL_DATE_AMOUNTS

Line 2114: utl_file.put_line (l_file,'>>------------------------------');

2110: Else
2111: /***************/
2112: utl_file.put_line (l_file,'>>----not known');
2113: utl_file.put_line (l_file,'>>---- inside ELSE ');
2114: utl_file.put_line (l_file,'>>------------------------------');
2115: /***************/
2116:
2117: update XTR_DEAL_DATE_AMOUNTS
2118: set RECONCILED_REFERENCE = l_rec_nos,

Line 2160: utl_file.put_line (l_file,'>>----not known ---');

2156: and PORTFOLIO_CODE like nvl(l_portfolio,'%')
2157: and ((date_type <>'FORCAST' and NVL(P_INCL_RTM,'N')='N') or NVL(P_INCL_RTM, 'N')='Y');
2158: If SQL%FOUND then
2159: /***************/
2160: utl_file.put_line (l_file,'>>----not known ---');
2161: utl_file.put_line (l_file,'>>----UPD complete ');
2162: utl_file.put_line (l_file,'>>------------------------------');
2163: /***************/
2164: For C1_Rec in C1(v_netoff_number)

Line 2161: utl_file.put_line (l_file,'>>----UPD complete ');

2157: and ((date_type <>'FORCAST' and NVL(P_INCL_RTM,'N')='N') or NVL(P_INCL_RTM, 'N')='Y');
2158: If SQL%FOUND then
2159: /***************/
2160: utl_file.put_line (l_file,'>>----not known ---');
2161: utl_file.put_line (l_file,'>>----UPD complete ');
2162: utl_file.put_line (l_file,'>>------------------------------');
2163: /***************/
2164: For C1_Rec in C1(v_netoff_number)
2165: Loop

Line 2162: utl_file.put_line (l_file,'>>------------------------------');

2158: If SQL%FOUND then
2159: /***************/
2160: utl_file.put_line (l_file,'>>----not known ---');
2161: utl_file.put_line (l_file,'>>----UPD complete ');
2162: utl_file.put_line (l_file,'>>------------------------------');
2163: /***************/
2164: For C1_Rec in C1(v_netoff_number)
2165: Loop
2166: Update Xtr_Settlement_Summary

Line 2170: utl_file.put_line(l_file, '>>----DDA ------');

2166: Update Xtr_Settlement_Summary
2167: Set status = 'R'
2168: Where settlement_summary_id = C1_Rec.net_ID;
2169: /***************/
2170: utl_file.put_line(l_file, '>>----DDA ------');
2171: utl_file.put_line(l_file, '>>----UPD settlement_summary complete netID '||C1_Rec.net_id);
2172: utl_file.put_line(l_file, '>>------------------------------------');
2173: /**************/
2174: End Loop;

Line 2171: utl_file.put_line(l_file, '>>----UPD settlement_summary complete netID '||C1_Rec.net_id);

2167: Set status = 'R'
2168: Where settlement_summary_id = C1_Rec.net_ID;
2169: /***************/
2170: utl_file.put_line(l_file, '>>----DDA ------');
2171: utl_file.put_line(l_file, '>>----UPD settlement_summary complete netID '||C1_Rec.net_id);
2172: utl_file.put_line(l_file, '>>------------------------------------');
2173: /**************/
2174: End Loop;
2175:

Line 2172: utl_file.put_line(l_file, '>>------------------------------------');

2168: Where settlement_summary_id = C1_Rec.net_ID;
2169: /***************/
2170: utl_file.put_line(l_file, '>>----DDA ------');
2171: utl_file.put_line(l_file, '>>----UPD settlement_summary complete netID '||C1_Rec.net_id);
2172: utl_file.put_line(l_file, '>>------------------------------------');
2173: /**************/
2174: End Loop;
2175:
2176: End if;

Line 2205: utl_file.put_line (l_file,'>>----DDA_SUM_RANGE');

2201: --dbms_output.put_line('DDA_SUM_RANGE amt, no-recs, net# '||l_sum_amt||' - '||l_num_recs||' - '||v_netoff_number);
2202:
2203: EXIT WHEN DDA_SUM_RANGE%NOTFOUND;
2204: /***************/
2205: utl_file.put_line (l_file,'>>----DDA_SUM_RANGE');
2206: utl_file.put_line (l_file,'>>----deal#, sumrange, acct, party, curr '||l_deal_no||' - '||l_sum_range||' - '||p_account_number||' - '||rec_det.party_name||' - '||p_currency);
2207: utl_file.put_line (l_file, '>>--- value-date, l-days '||rec_det.value_date||' - '||l_days);
2208: utl_file.put_line (l_file,'>>----net#, amt, no-rec '||v_netoff_number||' - '||l_sum_amt||' - '||l_num_recs);
2209: utl_file.put_line (l_file,'>>------------------------------');

Line 2206: utl_file.put_line (l_file,'>>----deal#, sumrange, acct, party, curr '||l_deal_no||' - '||l_sum_range||' - '||p_account_number||' - '||rec_det.party_name||' - '||p_currency);

2202:
2203: EXIT WHEN DDA_SUM_RANGE%NOTFOUND;
2204: /***************/
2205: utl_file.put_line (l_file,'>>----DDA_SUM_RANGE');
2206: utl_file.put_line (l_file,'>>----deal#, sumrange, acct, party, curr '||l_deal_no||' - '||l_sum_range||' - '||p_account_number||' - '||rec_det.party_name||' - '||p_currency);
2207: utl_file.put_line (l_file, '>>--- value-date, l-days '||rec_det.value_date||' - '||l_days);
2208: utl_file.put_line (l_file,'>>----net#, amt, no-rec '||v_netoff_number||' - '||l_sum_amt||' - '||l_num_recs);
2209: utl_file.put_line (l_file,'>>------------------------------');
2210: /***************/

Line 2207: utl_file.put_line (l_file, '>>--- value-date, l-days '||rec_det.value_date||' - '||l_days);

2203: EXIT WHEN DDA_SUM_RANGE%NOTFOUND;
2204: /***************/
2205: utl_file.put_line (l_file,'>>----DDA_SUM_RANGE');
2206: utl_file.put_line (l_file,'>>----deal#, sumrange, acct, party, curr '||l_deal_no||' - '||l_sum_range||' - '||p_account_number||' - '||rec_det.party_name||' - '||p_currency);
2207: utl_file.put_line (l_file, '>>--- value-date, l-days '||rec_det.value_date||' - '||l_days);
2208: utl_file.put_line (l_file,'>>----net#, amt, no-rec '||v_netoff_number||' - '||l_sum_amt||' - '||l_num_recs);
2209: utl_file.put_line (l_file,'>>------------------------------');
2210: /***************/
2211:

Line 2208: utl_file.put_line (l_file,'>>----net#, amt, no-rec '||v_netoff_number||' - '||l_sum_amt||' - '||l_num_recs);

2204: /***************/
2205: utl_file.put_line (l_file,'>>----DDA_SUM_RANGE');
2206: utl_file.put_line (l_file,'>>----deal#, sumrange, acct, party, curr '||l_deal_no||' - '||l_sum_range||' - '||p_account_number||' - '||rec_det.party_name||' - '||p_currency);
2207: utl_file.put_line (l_file, '>>--- value-date, l-days '||rec_det.value_date||' - '||l_days);
2208: utl_file.put_line (l_file,'>>----net#, amt, no-rec '||v_netoff_number||' - '||l_sum_amt||' - '||l_num_recs);
2209: utl_file.put_line (l_file,'>>------------------------------');
2210: /***************/
2211:
2212: if nvl(rec_det.DEBIT_AMOUNT,0) <> 0 then

Line 2209: utl_file.put_line (l_file,'>>------------------------------');

2205: utl_file.put_line (l_file,'>>----DDA_SUM_RANGE');
2206: utl_file.put_line (l_file,'>>----deal#, sumrange, acct, party, curr '||l_deal_no||' - '||l_sum_range||' - '||p_account_number||' - '||rec_det.party_name||' - '||p_currency);
2207: utl_file.put_line (l_file, '>>--- value-date, l-days '||rec_det.value_date||' - '||l_days);
2208: utl_file.put_line (l_file,'>>----net#, amt, no-rec '||v_netoff_number||' - '||l_sum_amt||' - '||l_num_recs);
2209: utl_file.put_line (l_file,'>>------------------------------');
2210: /***************/
2211:
2212: if nvl(rec_det.DEBIT_AMOUNT,0) <> 0 then
2213: if ((((-1) * rec_det.DEBIT_AMOUNT) = l_sum_amt and l_amount =

Line 2243: utl_file.put_line (l_file,'>>----DDA_SUM_RANGE');

2239:
2240: --dbms_output.put_line('bef UPD');
2241: If v_netoff_number is null then
2242: /***************/
2243: utl_file.put_line (l_file,'>>----DDA_SUM_RANGE');
2244: utl_file.put_line (l_file,'>>---- inside IF ');
2245: utl_file.put_line (l_file,'>>------------------------------');
2246: /***************/
2247:

Line 2244: utl_file.put_line (l_file,'>>---- inside IF ');

2240: --dbms_output.put_line('bef UPD');
2241: If v_netoff_number is null then
2242: /***************/
2243: utl_file.put_line (l_file,'>>----DDA_SUM_RANGE');
2244: utl_file.put_line (l_file,'>>---- inside IF ');
2245: utl_file.put_line (l_file,'>>------------------------------');
2246: /***************/
2247:
2248: update XTR_DEAL_DATE_AMOUNTS

Line 2245: utl_file.put_line (l_file,'>>------------------------------');

2241: If v_netoff_number is null then
2242: /***************/
2243: utl_file.put_line (l_file,'>>----DDA_SUM_RANGE');
2244: utl_file.put_line (l_file,'>>---- inside IF ');
2245: utl_file.put_line (l_file,'>>------------------------------');
2246: /***************/
2247:
2248: update XTR_DEAL_DATE_AMOUNTS
2249: set RECONCILED_REFERENCE = l_rec_nos,

Line 2288: utl_file.put_line (l_file,'>>----DDA_SUM_RANGE');

2284: and PORTFOLIO_CODE like nvl(l_portfolio,'%')
2285: and ((date_type <>'FORCAST' and NVL(P_INCL_RTM, 'N')='N') or NVL(P_INCL_RTM, 'N')='Y');
2286: If SQL%FOUND then
2287: /***************/
2288: utl_file.put_line (l_file,'>>----DDA_SUM_RANGE');
2289: utl_file.put_line (l_file,'>>---- UPD complete rec#, rec-pass '||l_rec_nos||' - '||p_pass_code);
2290: utl_file.put_line (l_file,'>>------------------------------');
2291: /***************/
2292: For C2_Rec in C2(l_rec_nos)

Line 2289: utl_file.put_line (l_file,'>>---- UPD complete rec#, rec-pass '||l_rec_nos||' - '||p_pass_code);

2285: and ((date_type <>'FORCAST' and NVL(P_INCL_RTM, 'N')='N') or NVL(P_INCL_RTM, 'N')='Y');
2286: If SQL%FOUND then
2287: /***************/
2288: utl_file.put_line (l_file,'>>----DDA_SUM_RANGE');
2289: utl_file.put_line (l_file,'>>---- UPD complete rec#, rec-pass '||l_rec_nos||' - '||p_pass_code);
2290: utl_file.put_line (l_file,'>>------------------------------');
2291: /***************/
2292: For C2_Rec in C2(l_rec_nos)
2293: Loop

Line 2290: utl_file.put_line (l_file,'>>------------------------------');

2286: If SQL%FOUND then
2287: /***************/
2288: utl_file.put_line (l_file,'>>----DDA_SUM_RANGE');
2289: utl_file.put_line (l_file,'>>---- UPD complete rec#, rec-pass '||l_rec_nos||' - '||p_pass_code);
2290: utl_file.put_line (l_file,'>>------------------------------');
2291: /***************/
2292: For C2_Rec in C2(l_rec_nos)
2293: Loop
2294: Update Xtr_Settlement_Summary

Line 2298: utl_file.put_line (l_file,'>>----DDA');

2294: Update Xtr_Settlement_Summary
2295: Set status = 'R'
2296: Where settlement_number = C2_Rec.Settlement_Number;
2297: /***************/
2298: utl_file.put_line (l_file,'>>----DDA');
2299: utl_file.put_line (l_file,'>>---- UPD settlement_summary complete settle# '||c2_rec.settlement_number);
2300: utl_file.put_line (l_file,'>>------------------------------');
2301: /***************/
2302: End Loop;

Line 2299: utl_file.put_line (l_file,'>>---- UPD settlement_summary complete settle# '||c2_rec.settlement_number);

2295: Set status = 'R'
2296: Where settlement_number = C2_Rec.Settlement_Number;
2297: /***************/
2298: utl_file.put_line (l_file,'>>----DDA');
2299: utl_file.put_line (l_file,'>>---- UPD settlement_summary complete settle# '||c2_rec.settlement_number);
2300: utl_file.put_line (l_file,'>>------------------------------');
2301: /***************/
2302: End Loop;
2303: End if;

Line 2300: utl_file.put_line (l_file,'>>------------------------------');

2296: Where settlement_number = C2_Rec.Settlement_Number;
2297: /***************/
2298: utl_file.put_line (l_file,'>>----DDA');
2299: utl_file.put_line (l_file,'>>---- UPD settlement_summary complete settle# '||c2_rec.settlement_number);
2300: utl_file.put_line (l_file,'>>------------------------------');
2301: /***************/
2302: End Loop;
2303: End if;
2304: Else

Line 2306: utl_file.put_line (l_file,'>>----DDA_SUM_RANGE');

2302: End Loop;
2303: End if;
2304: Else
2305: /***************/
2306: utl_file.put_line (l_file,'>>----DDA_SUM_RANGE');
2307: utl_file.put_line (l_file,'>>---- inside ELSE net# '||v_netoff_number);
2308: utl_file.put_line (l_file,'>>------------------------------');
2309: /***************/
2310:

Line 2307: utl_file.put_line (l_file,'>>---- inside ELSE net# '||v_netoff_number);

2303: End if;
2304: Else
2305: /***************/
2306: utl_file.put_line (l_file,'>>----DDA_SUM_RANGE');
2307: utl_file.put_line (l_file,'>>---- inside ELSE net# '||v_netoff_number);
2308: utl_file.put_line (l_file,'>>------------------------------');
2309: /***************/
2310:
2311: update XTR_DEAL_DATE_AMOUNTS

Line 2308: utl_file.put_line (l_file,'>>------------------------------');

2304: Else
2305: /***************/
2306: utl_file.put_line (l_file,'>>----DDA_SUM_RANGE');
2307: utl_file.put_line (l_file,'>>---- inside ELSE net# '||v_netoff_number);
2308: utl_file.put_line (l_file,'>>------------------------------');
2309: /***************/
2310:
2311: update XTR_DEAL_DATE_AMOUNTS
2312: set RECONCILED_REFERENCE = l_rec_nos,

Line 2355: utl_file.put_line (l_file,'>>----DDA_SUM_RANGE');

2351: and PORTFOLIO_CODE like nvl(l_portfolio,'%')
2352: and ((date_type <>'FORCAST' and NVL(P_INCL_RTM, 'N')='N') or NVL(P_INCL_RTM, 'N')='Y');
2353: If SQL%FOUND then
2354: /***************/
2355: utl_file.put_line (l_file,'>>----DDA_SUM_RANGE');
2356: utl_file.put_line (l_file,'>>---- UPD complete deal# '||rtrim(rec_det.particulars));
2357: utl_file.put_line (l_file,'>>------------------------------');
2358: /***************/
2359: For C1_Rec in C1(v_netoff_number)

Line 2356: utl_file.put_line (l_file,'>>---- UPD complete deal# '||rtrim(rec_det.particulars));

2352: and ((date_type <>'FORCAST' and NVL(P_INCL_RTM, 'N')='N') or NVL(P_INCL_RTM, 'N')='Y');
2353: If SQL%FOUND then
2354: /***************/
2355: utl_file.put_line (l_file,'>>----DDA_SUM_RANGE');
2356: utl_file.put_line (l_file,'>>---- UPD complete deal# '||rtrim(rec_det.particulars));
2357: utl_file.put_line (l_file,'>>------------------------------');
2358: /***************/
2359: For C1_Rec in C1(v_netoff_number)
2360: Loop

Line 2357: utl_file.put_line (l_file,'>>------------------------------');

2353: If SQL%FOUND then
2354: /***************/
2355: utl_file.put_line (l_file,'>>----DDA_SUM_RANGE');
2356: utl_file.put_line (l_file,'>>---- UPD complete deal# '||rtrim(rec_det.particulars));
2357: utl_file.put_line (l_file,'>>------------------------------');
2358: /***************/
2359: For C1_Rec in C1(v_netoff_number)
2360: Loop
2361: Update Xtr_Settlement_Summary

Line 2365: utl_file.put_line(l_file, '>>----DDA ------');

2361: Update Xtr_Settlement_Summary
2362: Set status = 'R'
2363: Where settlement_summary_id = C1_Rec.net_ID;
2364: /***************/
2365: utl_file.put_line(l_file, '>>----DDA ------');
2366: utl_file.put_line(l_file, '>>----UPD settlement_summary complete netID '||C1_Rec.net_id);
2367: utl_file.put_line(l_file, '>>------------------------------------');
2368: /**************/
2369: End Loop;

Line 2366: utl_file.put_line(l_file, '>>----UPD settlement_summary complete netID '||C1_Rec.net_id);

2362: Set status = 'R'
2363: Where settlement_summary_id = C1_Rec.net_ID;
2364: /***************/
2365: utl_file.put_line(l_file, '>>----DDA ------');
2366: utl_file.put_line(l_file, '>>----UPD settlement_summary complete netID '||C1_Rec.net_id);
2367: utl_file.put_line(l_file, '>>------------------------------------');
2368: /**************/
2369: End Loop;
2370: End if;

Line 2367: utl_file.put_line(l_file, '>>------------------------------------');

2363: Where settlement_summary_id = C1_Rec.net_ID;
2364: /***************/
2365: utl_file.put_line(l_file, '>>----DDA ------');
2366: utl_file.put_line(l_file, '>>----UPD settlement_summary complete netID '||C1_Rec.net_id);
2367: utl_file.put_line(l_file, '>>------------------------------------');
2368: /**************/
2369: End Loop;
2370: End if;
2371: End if;

Line 2409: utl_file.put_line (l_file,'>>----2');

2405:
2406: --dbms_output.put_line('bef UPD ');
2407: If v_netoff_number is null then
2408: /***************/
2409: utl_file.put_line (l_file,'>>----2');
2410: utl_file.put_line (l_file,'>>----inside IF rec#, rec-pass '||l_rec_nos||' - '||p_pass_code);
2411: utl_file.put_line (l_file,'>>------------------------------');
2412: /***************/
2413:

Line 2410: utl_file.put_line (l_file,'>>----inside IF rec#, rec-pass '||l_rec_nos||' - '||p_pass_code);

2406: --dbms_output.put_line('bef UPD ');
2407: If v_netoff_number is null then
2408: /***************/
2409: utl_file.put_line (l_file,'>>----2');
2410: utl_file.put_line (l_file,'>>----inside IF rec#, rec-pass '||l_rec_nos||' - '||p_pass_code);
2411: utl_file.put_line (l_file,'>>------------------------------');
2412: /***************/
2413:
2414: update XTR_DEAL_DATE_AMOUNTS

Line 2411: utl_file.put_line (l_file,'>>------------------------------');

2407: If v_netoff_number is null then
2408: /***************/
2409: utl_file.put_line (l_file,'>>----2');
2410: utl_file.put_line (l_file,'>>----inside IF rec#, rec-pass '||l_rec_nos||' - '||p_pass_code);
2411: utl_file.put_line (l_file,'>>------------------------------');
2412: /***************/
2413:
2414: update XTR_DEAL_DATE_AMOUNTS
2415: set RECONCILED_REFERENCE = l_rec_nos,

Line 2455: utl_file.put_line (l_file,'>>----2');

2451: and PORTFOLIO_CODE like nvl(l_portfolio,'%')
2452: and ((date_type <>'FORCAST' and NVL(P_INCL_RTM, 'N')='N') or NVL(P_INCL_RTM, 'N')='Y');
2453: If SQL%FOUND then
2454: /***************/
2455: utl_file.put_line (l_file,'>>----2');
2456: utl_file.put_line (l_file,'>>---- UPD complete deal# '||rtrim(rec_det.particulars));
2457: utl_file.put_line (l_file,'>>------------------------------');
2458: /***************/
2459: For C2_Rec in C2(l_rec_nos)

Line 2456: utl_file.put_line (l_file,'>>---- UPD complete deal# '||rtrim(rec_det.particulars));

2452: and ((date_type <>'FORCAST' and NVL(P_INCL_RTM, 'N')='N') or NVL(P_INCL_RTM, 'N')='Y');
2453: If SQL%FOUND then
2454: /***************/
2455: utl_file.put_line (l_file,'>>----2');
2456: utl_file.put_line (l_file,'>>---- UPD complete deal# '||rtrim(rec_det.particulars));
2457: utl_file.put_line (l_file,'>>------------------------------');
2458: /***************/
2459: For C2_Rec in C2(l_rec_nos)
2460: Loop

Line 2457: utl_file.put_line (l_file,'>>------------------------------');

2453: If SQL%FOUND then
2454: /***************/
2455: utl_file.put_line (l_file,'>>----2');
2456: utl_file.put_line (l_file,'>>---- UPD complete deal# '||rtrim(rec_det.particulars));
2457: utl_file.put_line (l_file,'>>------------------------------');
2458: /***************/
2459: For C2_Rec in C2(l_rec_nos)
2460: Loop
2461: Update Xtr_Settlement_Summary

Line 2465: utl_file.put_line (l_file,'>>----DDA_SUM_RANGE');

2461: Update Xtr_Settlement_Summary
2462: Set status = 'R'
2463: Where settlement_number = C2_Rec.Settlement_Number;
2464: /***************/
2465: utl_file.put_line (l_file,'>>----DDA_SUM_RANGE');
2466: utl_file.put_line (l_file,'>>---- UPD settlement_summary complete settle# '||c2_rec.settlement_number);
2467: utl_file.put_line (l_file,'>>------------------------------');
2468: /***************/
2469: End Loop;

Line 2466: utl_file.put_line (l_file,'>>---- UPD settlement_summary complete settle# '||c2_rec.settlement_number);

2462: Set status = 'R'
2463: Where settlement_number = C2_Rec.Settlement_Number;
2464: /***************/
2465: utl_file.put_line (l_file,'>>----DDA_SUM_RANGE');
2466: utl_file.put_line (l_file,'>>---- UPD settlement_summary complete settle# '||c2_rec.settlement_number);
2467: utl_file.put_line (l_file,'>>------------------------------');
2468: /***************/
2469: End Loop;
2470: End if;

Line 2467: utl_file.put_line (l_file,'>>------------------------------');

2463: Where settlement_number = C2_Rec.Settlement_Number;
2464: /***************/
2465: utl_file.put_line (l_file,'>>----DDA_SUM_RANGE');
2466: utl_file.put_line (l_file,'>>---- UPD settlement_summary complete settle# '||c2_rec.settlement_number);
2467: utl_file.put_line (l_file,'>>------------------------------');
2468: /***************/
2469: End Loop;
2470: End if;
2471: Else

Line 2473: utl_file.put_line (l_file,'>>----2');

2469: End Loop;
2470: End if;
2471: Else
2472: /***************/
2473: utl_file.put_line (l_file,'>>----2');
2474: utl_file.put_line (l_file,'>>---- inside ELSE net#, rec#, rec-pass '||v_netoff_number||' - '||l_rec_nos||' - '||p_pass_code);
2475: utl_file.put_line (l_file,'>>------------------------------');
2476: /***************/
2477:

Line 2474: utl_file.put_line (l_file,'>>---- inside ELSE net#, rec#, rec-pass '||v_netoff_number||' - '||l_rec_nos||' - '||p_pass_code);

2470: End if;
2471: Else
2472: /***************/
2473: utl_file.put_line (l_file,'>>----2');
2474: utl_file.put_line (l_file,'>>---- inside ELSE net#, rec#, rec-pass '||v_netoff_number||' - '||l_rec_nos||' - '||p_pass_code);
2475: utl_file.put_line (l_file,'>>------------------------------');
2476: /***************/
2477:
2478: update XTR_DEAL_DATE_AMOUNTS

Line 2475: utl_file.put_line (l_file,'>>------------------------------');

2471: Else
2472: /***************/
2473: utl_file.put_line (l_file,'>>----2');
2474: utl_file.put_line (l_file,'>>---- inside ELSE net#, rec#, rec-pass '||v_netoff_number||' - '||l_rec_nos||' - '||p_pass_code);
2475: utl_file.put_line (l_file,'>>------------------------------');
2476: /***************/
2477:
2478: update XTR_DEAL_DATE_AMOUNTS
2479: set RECONCILED_REFERENCE = l_rec_nos,

Line 2521: utl_file.put_line (l_file,'>>----2');

2517: and PORTFOLIO_CODE like nvl(l_portfolio,'%')
2518: and ((date_type <>'FORCAST' and NVL(P_INCL_RTM, 'N')='N') or NVL(P_INCL_RTM, 'N')='Y');
2519: If SQL%FOUND then
2520: /***************/
2521: utl_file.put_line (l_file,'>>----2');
2522: utl_file.put_line (l_file,'>>---- UPD complete deal# '||rtrim(Rec_det.particulars));
2523: utl_file.put_line (l_file,'>>------------------------------');
2524: /***************/
2525: For C1_Rec in C1(v_netoff_number)

Line 2522: utl_file.put_line (l_file,'>>---- UPD complete deal# '||rtrim(Rec_det.particulars));

2518: and ((date_type <>'FORCAST' and NVL(P_INCL_RTM, 'N')='N') or NVL(P_INCL_RTM, 'N')='Y');
2519: If SQL%FOUND then
2520: /***************/
2521: utl_file.put_line (l_file,'>>----2');
2522: utl_file.put_line (l_file,'>>---- UPD complete deal# '||rtrim(Rec_det.particulars));
2523: utl_file.put_line (l_file,'>>------------------------------');
2524: /***************/
2525: For C1_Rec in C1(v_netoff_number)
2526: Loop

Line 2523: utl_file.put_line (l_file,'>>------------------------------');

2519: If SQL%FOUND then
2520: /***************/
2521: utl_file.put_line (l_file,'>>----2');
2522: utl_file.put_line (l_file,'>>---- UPD complete deal# '||rtrim(Rec_det.particulars));
2523: utl_file.put_line (l_file,'>>------------------------------');
2524: /***************/
2525: For C1_Rec in C1(v_netoff_number)
2526: Loop
2527: Update Xtr_Settlement_Summary

Line 2531: utl_file.put_line(l_file, '>>----DDA ------');

2527: Update Xtr_Settlement_Summary
2528: Set status = 'R'
2529: Where settlement_summary_id = C1_Rec.net_ID;
2530: /***************/
2531: utl_file.put_line(l_file, '>>----DDA ------');
2532: utl_file.put_line(l_file, '>>----UPD settlement_summary complete netID '||C1_Rec.net_id);
2533: utl_file.put_line(l_file, '>>------------------------------------');
2534: /**************/
2535: End Loop;

Line 2532: utl_file.put_line(l_file, '>>----UPD settlement_summary complete netID '||C1_Rec.net_id);

2528: Set status = 'R'
2529: Where settlement_summary_id = C1_Rec.net_ID;
2530: /***************/
2531: utl_file.put_line(l_file, '>>----DDA ------');
2532: utl_file.put_line(l_file, '>>----UPD settlement_summary complete netID '||C1_Rec.net_id);
2533: utl_file.put_line(l_file, '>>------------------------------------');
2534: /**************/
2535: End Loop;
2536: End if;

Line 2533: utl_file.put_line(l_file, '>>------------------------------------');

2529: Where settlement_summary_id = C1_Rec.net_ID;
2530: /***************/
2531: utl_file.put_line(l_file, '>>----DDA ------');
2532: utl_file.put_line(l_file, '>>----UPD settlement_summary complete netID '||C1_Rec.net_id);
2533: utl_file.put_line(l_file, '>>------------------------------------');
2534: /**************/
2535: End Loop;
2536: End if;
2537: End if;

Line 2564: utl_file.put_line (l_file,'>>----DDA');

2560: END IF;
2561: fetch DDA INTO l_sum_amt,l_num_recs,l_one_date, v_netoff_number;
2562: --dbms_output.put_line('DDA amt, no-recs, date, net# '||l_sum_amt||' - '||l_num_recs||' - '||l_one_date||' - '||v_netoff_number);
2563: /***************/
2564: utl_file.put_line (l_file,'>>----DDA');
2565: utl_file.put_line (l_file,'>>----net#, date, amt, no-recs '||v_netoff_number||' - '||l_one_date||' - '||l_sum_amt||' - '||l_num_recs);
2566: utl_file.put_line (l_file,'>>------------------------------');
2567: /***************/
2568:

Line 2565: utl_file.put_line (l_file,'>>----net#, date, amt, no-recs '||v_netoff_number||' - '||l_one_date||' - '||l_sum_amt||' - '||l_num_recs);

2561: fetch DDA INTO l_sum_amt,l_num_recs,l_one_date, v_netoff_number;
2562: --dbms_output.put_line('DDA amt, no-recs, date, net# '||l_sum_amt||' - '||l_num_recs||' - '||l_one_date||' - '||v_netoff_number);
2563: /***************/
2564: utl_file.put_line (l_file,'>>----DDA');
2565: utl_file.put_line (l_file,'>>----net#, date, amt, no-recs '||v_netoff_number||' - '||l_one_date||' - '||l_sum_amt||' - '||l_num_recs);
2566: utl_file.put_line (l_file,'>>------------------------------');
2567: /***************/
2568:
2569: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

Line 2566: utl_file.put_line (l_file,'>>------------------------------');

2562: --dbms_output.put_line('DDA amt, no-recs, date, net# '||l_sum_amt||' - '||l_num_recs||' - '||l_one_date||' - '||v_netoff_number);
2563: /***************/
2564: utl_file.put_line (l_file,'>>----DDA');
2565: utl_file.put_line (l_file,'>>----net#, date, amt, no-recs '||v_netoff_number||' - '||l_one_date||' - '||l_sum_amt||' - '||l_num_recs);
2566: utl_file.put_line (l_file,'>>------------------------------');
2567: /***************/
2568:
2569: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2570: xtr_debug_pkg.debug('P_RECONCILE: ' || 'value after fetch -----------------');

Line 2617: utl_file.put_line (l_file,'>>----DDA');

2613:
2614: --dbms_output.put_line('bef UPD ');
2615: If v_netoff_number is null then
2616: /***************/
2617: utl_file.put_line (l_file,'>>----DDA');
2618: utl_file.put_line (l_file,'>>---- inside IF , rec#, rec-pass '||l_rec_nos||' - '||p_pass_code);
2619: utl_file.put_line (l_file,'>>------------------------------');
2620: /***************/
2621:

Line 2618: utl_file.put_line (l_file,'>>---- inside IF , rec#, rec-pass '||l_rec_nos||' - '||p_pass_code);

2614: --dbms_output.put_line('bef UPD ');
2615: If v_netoff_number is null then
2616: /***************/
2617: utl_file.put_line (l_file,'>>----DDA');
2618: utl_file.put_line (l_file,'>>---- inside IF , rec#, rec-pass '||l_rec_nos||' - '||p_pass_code);
2619: utl_file.put_line (l_file,'>>------------------------------');
2620: /***************/
2621:
2622: update XTR_DEAL_DATE_AMOUNTS

Line 2619: utl_file.put_line (l_file,'>>------------------------------');

2615: If v_netoff_number is null then
2616: /***************/
2617: utl_file.put_line (l_file,'>>----DDA');
2618: utl_file.put_line (l_file,'>>---- inside IF , rec#, rec-pass '||l_rec_nos||' - '||p_pass_code);
2619: utl_file.put_line (l_file,'>>------------------------------');
2620: /***************/
2621:
2622: update XTR_DEAL_DATE_AMOUNTS
2623: set RECONCILED_REFERENCE = l_rec_nos,

Line 2671: utl_file.put_line (l_file,'>>----DDA');

2667: and ((date_type <>'FORCAST' and NVL(P_INCL_RTM, 'N')='N') or NVL(P_INCL_RTM, 'N')='Y')
2668: and rownum < 2; -- bug 5353780
2669: If SQL%FOUND then
2670: /***************/
2671: utl_file.put_line (l_file,'>>----DDA');
2672: utl_file.put_line (l_file,'>>---- UPD complete deal# '||rtrim(rec_det.particulars));
2673: utl_file.put_line (l_file,'>>------------------------------');
2674: /***************/
2675: For C2_Rec in C2(l_rec_nos)

Line 2672: utl_file.put_line (l_file,'>>---- UPD complete deal# '||rtrim(rec_det.particulars));

2668: and rownum < 2; -- bug 5353780
2669: If SQL%FOUND then
2670: /***************/
2671: utl_file.put_line (l_file,'>>----DDA');
2672: utl_file.put_line (l_file,'>>---- UPD complete deal# '||rtrim(rec_det.particulars));
2673: utl_file.put_line (l_file,'>>------------------------------');
2674: /***************/
2675: For C2_Rec in C2(l_rec_nos)
2676: Loop

Line 2673: utl_file.put_line (l_file,'>>------------------------------');

2669: If SQL%FOUND then
2670: /***************/
2671: utl_file.put_line (l_file,'>>----DDA');
2672: utl_file.put_line (l_file,'>>---- UPD complete deal# '||rtrim(rec_det.particulars));
2673: utl_file.put_line (l_file,'>>------------------------------');
2674: /***************/
2675: For C2_Rec in C2(l_rec_nos)
2676: Loop
2677: Update Xtr_Settlement_Summary

Line 2681: utl_file.put_line (l_file,'>>----DDA');

2677: Update Xtr_Settlement_Summary
2678: Set status = 'R'
2679: Where settlement_number = C2_Rec.Settlement_Number;
2680: /***************/
2681: utl_file.put_line (l_file,'>>----DDA');
2682: utl_file.put_line (l_file,'>>---- UPD settlement_summary complete settle# '||c2_rec.settlement_number);
2683: utl_file.put_line (l_file,'>>------------------------------');
2684: /***************/
2685: End Loop;

Line 2682: utl_file.put_line (l_file,'>>---- UPD settlement_summary complete settle# '||c2_rec.settlement_number);

2678: Set status = 'R'
2679: Where settlement_number = C2_Rec.Settlement_Number;
2680: /***************/
2681: utl_file.put_line (l_file,'>>----DDA');
2682: utl_file.put_line (l_file,'>>---- UPD settlement_summary complete settle# '||c2_rec.settlement_number);
2683: utl_file.put_line (l_file,'>>------------------------------');
2684: /***************/
2685: End Loop;
2686: End if;

Line 2683: utl_file.put_line (l_file,'>>------------------------------');

2679: Where settlement_number = C2_Rec.Settlement_Number;
2680: /***************/
2681: utl_file.put_line (l_file,'>>----DDA');
2682: utl_file.put_line (l_file,'>>---- UPD settlement_summary complete settle# '||c2_rec.settlement_number);
2683: utl_file.put_line (l_file,'>>------------------------------');
2684: /***************/
2685: End Loop;
2686: End if;
2687: Else

Line 2689: utl_file.put_line (l_file,'>>----DDA');

2685: End Loop;
2686: End if;
2687: Else
2688: /***************/
2689: utl_file.put_line (l_file,'>>----DDA');
2690: utl_file.put_line (l_file,'>>---- inside ELSE rec#, rec-pass '||l_rec_nos||' - '||p_pass_code);
2691: utl_file.put_line (l_file,'>>------------------------------');
2692: /***************/
2693:

Line 2690: utl_file.put_line (l_file,'>>---- inside ELSE rec#, rec-pass '||l_rec_nos||' - '||p_pass_code);

2686: End if;
2687: Else
2688: /***************/
2689: utl_file.put_line (l_file,'>>----DDA');
2690: utl_file.put_line (l_file,'>>---- inside ELSE rec#, rec-pass '||l_rec_nos||' - '||p_pass_code);
2691: utl_file.put_line (l_file,'>>------------------------------');
2692: /***************/
2693:
2694: update XTR_DEAL_DATE_AMOUNTS

Line 2691: utl_file.put_line (l_file,'>>------------------------------');

2687: Else
2688: /***************/
2689: utl_file.put_line (l_file,'>>----DDA');
2690: utl_file.put_line (l_file,'>>---- inside ELSE rec#, rec-pass '||l_rec_nos||' - '||p_pass_code);
2691: utl_file.put_line (l_file,'>>------------------------------');
2692: /***************/
2693:
2694: update XTR_DEAL_DATE_AMOUNTS
2695: set RECONCILED_REFERENCE = l_rec_nos,

Line 2748: utl_file.put_line (l_file,'>>----DDA -----');

2744: and PORTFOLIO_CODE like nvl(l_portfolio,'%')
2745: and ((date_type <>'FORCAST' and NVL(P_INCL_RTM, 'N')='N') or NVL(P_INCL_RTM, 'N')='Y');
2746: If SQL%FOUND then
2747: /***************/
2748: utl_file.put_line (l_file,'>>----DDA -----');
2749: utl_file.put_line (l_file,'>>---- UPD complete deal# '||rtrim(Rec_det.particulars));
2750: utl_file.put_line (l_file,'>>------------------------------');
2751: /***************/
2752: For C1_Rec in C1(v_netoff_number)

Line 2749: utl_file.put_line (l_file,'>>---- UPD complete deal# '||rtrim(Rec_det.particulars));

2745: and ((date_type <>'FORCAST' and NVL(P_INCL_RTM, 'N')='N') or NVL(P_INCL_RTM, 'N')='Y');
2746: If SQL%FOUND then
2747: /***************/
2748: utl_file.put_line (l_file,'>>----DDA -----');
2749: utl_file.put_line (l_file,'>>---- UPD complete deal# '||rtrim(Rec_det.particulars));
2750: utl_file.put_line (l_file,'>>------------------------------');
2751: /***************/
2752: For C1_Rec in C1(v_netoff_number)
2753: Loop

Line 2750: utl_file.put_line (l_file,'>>------------------------------');

2746: If SQL%FOUND then
2747: /***************/
2748: utl_file.put_line (l_file,'>>----DDA -----');
2749: utl_file.put_line (l_file,'>>---- UPD complete deal# '||rtrim(Rec_det.particulars));
2750: utl_file.put_line (l_file,'>>------------------------------');
2751: /***************/
2752: For C1_Rec in C1(v_netoff_number)
2753: Loop
2754: Update Xtr_Settlement_Summary

Line 2758: utl_file.put_line(l_file, '>>----DDA ------');

2754: Update Xtr_Settlement_Summary
2755: Set status = 'R'
2756: Where settlement_summary_id = C1_Rec.net_ID;
2757: /***************/
2758: utl_file.put_line(l_file, '>>----DDA ------');
2759: utl_file.put_line(l_file, '>>----UPD settlement_summary complete netID '||C1_Rec.net_id);
2760: utl_file.put_line(l_file, '>>------------------------------------');
2761: /**************/
2762: End Loop;

Line 2759: utl_file.put_line(l_file, '>>----UPD settlement_summary complete netID '||C1_Rec.net_id);

2755: Set status = 'R'
2756: Where settlement_summary_id = C1_Rec.net_ID;
2757: /***************/
2758: utl_file.put_line(l_file, '>>----DDA ------');
2759: utl_file.put_line(l_file, '>>----UPD settlement_summary complete netID '||C1_Rec.net_id);
2760: utl_file.put_line(l_file, '>>------------------------------------');
2761: /**************/
2762: End Loop;
2763: End if;

Line 2760: utl_file.put_line(l_file, '>>------------------------------------');

2756: Where settlement_summary_id = C1_Rec.net_ID;
2757: /***************/
2758: utl_file.put_line(l_file, '>>----DDA ------');
2759: utl_file.put_line(l_file, '>>----UPD settlement_summary complete netID '||C1_Rec.net_id);
2760: utl_file.put_line(l_file, '>>------------------------------------');
2761: /**************/
2762: End Loop;
2763: End if;
2764: End if;

Line 2800: utl_file.put_line (l_file,' ');

2796: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2797: xtr_debug_pkg.debug('END P_RECONCILE >>>>>>>>>>');
2798: END IF;
2799:
2800: utl_file.put_line (l_file,' ');
2801: utl_file.put_line (l_file,'>> Log file is located at '||l_dirname||'/xtraurec.log');
2802: utl_file.put_line (l_file,'>>----------------------------------------------------------------');
2803: utl_file.fclose(l_file);
2804:

Line 2801: utl_file.put_line (l_file,'>> Log file is located at '||l_dirname||'/xtraurec.log');

2797: xtr_debug_pkg.debug('END P_RECONCILE >>>>>>>>>>');
2798: END IF;
2799:
2800: utl_file.put_line (l_file,' ');
2801: utl_file.put_line (l_file,'>> Log file is located at '||l_dirname||'/xtraurec.log');
2802: utl_file.put_line (l_file,'>>----------------------------------------------------------------');
2803: utl_file.fclose(l_file);
2804:
2805: end P_RECONCILE;

Line 2802: utl_file.put_line (l_file,'>>----------------------------------------------------------------');

2798: END IF;
2799:
2800: utl_file.put_line (l_file,' ');
2801: utl_file.put_line (l_file,'>> Log file is located at '||l_dirname||'/xtraurec.log');
2802: utl_file.put_line (l_file,'>>----------------------------------------------------------------');
2803: utl_file.fclose(l_file);
2804:
2805: end P_RECONCILE;
2806:

Line 2803: utl_file.fclose(l_file);

2799:
2800: utl_file.put_line (l_file,' ');
2801: utl_file.put_line (l_file,'>> Log file is located at '||l_dirname||'/xtraurec.log');
2802: utl_file.put_line (l_file,'>>----------------------------------------------------------------');
2803: utl_file.fclose(l_file);
2804:
2805: end P_RECONCILE;
2806:
2807: END XTR_AUTO_RECONCILIATION;