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.FV_IPAC dependencies on FV_IPAC

Line 1: PACKAGE BODY fv_ipac AS

1: PACKAGE BODY fv_ipac AS
2: --$Header: FVIPPROB.pls 120.68 2011/09/14 17:48:04 snama ship $
3: --IPAC FY2003-04
4: gbl_gl_segment_name VARCHAR2(30);
5: gbl_gl_acc_value_set_id NUMBER;

Line 31: parm_contact_name fv_ipac_trx_all.cnt_nm%TYPE;

27: parm_customer_id hz_parties.party_id%TYPE;
28: parm_trx_date_low DATE;
29: parm_trx_date_high DATE;
30: parm_currency ra_customer_trx.invoice_currency_code%TYPE;
31: parm_contact_name fv_ipac_trx_all.cnt_nm%TYPE;
32: parm_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE;
33: parm_org_id fv_operating_units.org_id%TYPE;
34: parm_contact_ph_no VARCHAR2(17);
35: -- ------------------------------------

Line 62: v_trx_excpt_cat fv_ipac_trx_all.exception_category%TYPE;

58: v_receipt_method_id NUMBER;
59: v_original_amount NUMBER;
60: v_paid_amount NUMBER;
61: trx_exception_flag VARCHAR2(1) ;
62: v_trx_excpt_cat fv_ipac_trx_all.exception_category%TYPE;
63: v_trx_exception fv_ipac_trx_all.exception_category%TYPE;
64: v_bulk_exception fv_ipac_trx_all.bulk_exception%TYPE;
65: v_pay_flag VARCHAR2(1) ;
66: v_invoice_currency ra_customer_trx.invoice_currency_code%TYPE;

Line 63: v_trx_exception fv_ipac_trx_all.exception_category%TYPE;

59: v_original_amount NUMBER;
60: v_paid_amount NUMBER;
61: trx_exception_flag VARCHAR2(1) ;
62: v_trx_excpt_cat fv_ipac_trx_all.exception_category%TYPE;
63: v_trx_exception fv_ipac_trx_all.exception_category%TYPE;
64: v_bulk_exception fv_ipac_trx_all.bulk_exception%TYPE;
65: v_pay_flag VARCHAR2(1) ;
66: v_invoice_currency ra_customer_trx.invoice_currency_code%TYPE;
67: -- Variables to populate who columns

Line 64: v_bulk_exception fv_ipac_trx_all.bulk_exception%TYPE;

60: v_paid_amount NUMBER;
61: trx_exception_flag VARCHAR2(1) ;
62: v_trx_excpt_cat fv_ipac_trx_all.exception_category%TYPE;
63: v_trx_exception fv_ipac_trx_all.exception_category%TYPE;
64: v_bulk_exception fv_ipac_trx_all.bulk_exception%TYPE;
65: v_pay_flag VARCHAR2(1) ;
66: v_invoice_currency ra_customer_trx.invoice_currency_code%TYPE;
67: -- Variables to populate who columns
68: v_created_by NUMBER(15);

Line 173: FROM fv_ipac_trx_all

169: AND arp.org_id = v_org_id
170: AND arp.customer_trx_id = rgld.customer_trx_id
171: AND NOT EXISTS
172: (SELECT 'X'
173: FROM fv_ipac_trx_all
174: WHERE set_of_books_id = v_set_of_books_id
175: AND org_id = v_org_id
176: AND customer_trx_id = p_customer_trx_id
177: AND trx_line_no = rctl.line_number

Line 194: FROM fv_ipac_trx_all fit

190: fit.cash_receipt_id ,
191: fit.accounted_flag,
192: fit.cnt_nm,
193: fit.trn_set_id
194: FROM fv_ipac_trx_all fit
195: WHERE fit.exclude_flag = 'N'
196: AND set_of_books_id = v_set_of_books_id
197: AND org_id = v_org_id
198: AND fit.report_flag = 'Y'

Line 234: FROM fv_ipac_trx_all

230: IS
231: SELECT customer_trx_id,
232: snd_app_sym,
233: sgl_acct_num
234: FROM fv_ipac_trx_all
235: WHERE unt_iss = '~RA'
236: AND set_of_books_id = v_set_of_books_id
237: AND org_id = v_org_id
238: AND report_flag = 'Y'

Line 249: FROM fv_ipac_trx_all trx

245: -- whose receipt is already created and SLA accounting generated successfully
246: CURSOR hdr_det(p_set_of_books_id NUMBER, p_org_id NUMBER)
247: IS
248: SELECT DISTINCT customer_trx_id
249: FROM fv_ipac_trx_all trx
250: WHERE set_of_books_id = p_set_of_books_id
251: AND org_id = p_org_id
252: AND processed_flag = 'N'
253: AND exclude_flag = 'N'

Line 290: FROM fv_ipac_trx_all fit,

286: fit.cash_receipt_id,
287: fit.sender_do_sym,
288: fit.sender_alc,
289: rct.comments comments
290: FROM fv_ipac_trx_all fit,
291: ra_customer_trx rct
292: WHERE fit.org_id = v_org_id
293: AND fit.set_of_books_id = v_set_of_books_id
294: AND fit.customer_trx_id = p_cust_trx_id

Line 357: -- from fv_ipac_trx_all

353:
354: -- -----------------------------------------------------------------------------
355: -- -----------------------------------------------------------------------------
356: -- Procedure to delete exception records
357: -- from fv_ipac_trx_all
358: PROCEDURE del_exception_recs
359: IS
360: l_module_name VARCHAR2(200) ;
361: BEGIN

Line 364: FROM fv_ipac_trx_all trx

360: l_module_name VARCHAR2(200) ;
361: BEGIN
362: l_module_name := g_module_name || 'del_exception_recs';
363: DELETE
364: FROM fv_ipac_trx_all trx
365: WHERE set_of_books_id = v_set_of_books_id
366: AND NVL(org_id,-99) = NVL(v_org_id,-99)
367: AND (report_flag = 'N'
368: OR ( report_flag = 'Y'

Line 390: FROM fv_ipac_trx_all

386: l_module_name VARCHAR2(200) ;
387: BEGIN
388: l_module_name := g_module_name || 'delete_records';
389: DELETE
390: FROM fv_ipac_trx_all
391: WHERE set_of_books_id = v_set_of_books_id
392: AND NVL(org_id,-99) = NVL(v_org_id,-99)
393: AND ipac_billing_id BETWEEN g_start_billing_id AND g_end_billing_id ;
394: EXCEPTION

Line 499: FUNCTION get_trx_exception( transaction_rec IN OUT NOCOPY fv_ipac_trx_all%ROWTYPE, p_cust_trx_line_id NUMBER, p_bill_to_address_id NUMBER) RETURN VARCHAR2

495: -- -----------------------------------------------------------------------------
496: -- -----------------------------------------------------------------------------
497: -- Function to get the transaction exception category
498: -- based on the passed transaction record values
499: FUNCTION get_trx_exception( transaction_rec IN OUT NOCOPY fv_ipac_trx_all%ROWTYPE, p_cust_trx_line_id NUMBER, p_bill_to_address_id NUMBER) RETURN VARCHAR2
500: IS
501: l_sgl_acct_num gl_code_combinations.segment1%TYPE;
502: BEGIN
503: v_trx_excpt_cat := NULL;

Line 670: PROCEDURE insert_trx_rec(ins_trx IN fv_ipac_trx_all%ROWTYPE)

666: -- -----------------------------------------------------------------------------
667: -- -----------------------------------------------------------------------------
668:
669: -- Procedure to insert transaction records
670: PROCEDURE insert_trx_rec(ins_trx IN fv_ipac_trx_all%ROWTYPE)
671: IS
672: v_trx_billing_id NUMBER;
673: v_trx_excl_flag VARCHAR2(1) ;
674: v_trx_proc_flag VARCHAR2(1) ;

Line 680: SELECT fv_ipac_billing_id_s.NEXTVAL INTO v_trx_billing_id FROM dual;

676: BEGIN
677: v_trx_excl_flag := 'N';
678: v_trx_proc_flag := 'N';
679: l_module_name := g_module_name || 'insert_trx_rec';
680: SELECT fv_ipac_billing_id_s.NEXTVAL INTO v_trx_billing_id FROM dual;
681: INSERT
682: INTO fv_ipac_trx_all
683: (
684: set_of_books_id,

Line 682: INTO fv_ipac_trx_all

678: v_trx_proc_flag := 'N';
679: l_module_name := g_module_name || 'insert_trx_rec';
680: SELECT fv_ipac_billing_id_s.NEXTVAL INTO v_trx_billing_id FROM dual;
681: INSERT
682: INTO fv_ipac_trx_all
683: (
684: set_of_books_id,
685: org_id,
686: run_date,

Line 769: ' FV_IPAC_TRX_ALL table : Procedure :- insert_trx_rec';

765: EXCEPTION
766: WHEN OTHERS THEN
767: errcode := SQLCODE;
768: errmsg := SQLERRM || ' -- Error in inserting the data into' ||
769: ' FV_IPAC_TRX_ALL table : Procedure :- insert_trx_rec';
770: RAISE;
771: END; -- insert_trx_rec
772:
773: -- -----------------------------------------------------------------------------

Line 998: FROM fv_ipac_trx_all

994: -- cursor to get the customer_trx_id and and treasury Symbol
995: CURSOR trx_cur IS
996: SELECT customer_trx_id ,
997: snd_app_sym
998: FROM fv_ipac_trx_all
999: WHERE processed_flag ='N'
1000: AND set_of_books_id = v_set_of_books_id
1001: AND org_id = v_org_id
1002: AND exclude_flag ='N'

Line 1015: FROM fv_ipac_trx_all

1011: CURSOR trx_rec_cur (p_customer_trx_id NUMBER,
1012: p_snd_app_sym VARCHAR2 )
1013: IS SELECT trx_line_no,
1014: SUM(amount) amount
1015: FROM fv_ipac_trx_all
1016: WHERE org_id = v_org_id
1017: AND set_of_books_id = v_set_of_books_id
1018: AND processed_flag ='N'
1019: AND customer_trx_id = p_customer_trx_id

Line 1026: l_trx_rec FV_IPAC_TRX_ALL%ROWTYPE;

1022: AND unt_iss <> '~RA'
1023: AND set_of_books_id = v_set_of_books_id
1024: AND exclude_flag ='N'
1025: GROUP BY trx_line_no ;
1026: l_trx_rec FV_IPAC_TRX_ALL%ROWTYPE;
1027: l_module_name VARCHAR2(200) ;
1028: BEGIN
1029: l_module_name := g_module_name ||'equalize_rec_lines';
1030: FOR trx_rec IN trx_cur

Line 1036: FROM fv_ipac_trx_all

1032: FOR trx_rec_rec IN trx_rec_cur(trx_rec.customer_trx_id ,
1033: trx_rec.snd_app_sym )
1034: LOOP
1035: SELECT * INTO l_trx_rec
1036: FROM fv_ipac_trx_all
1037: WHERE org_id = v_org_id
1038: AND set_of_books_id = v_set_of_books_id
1039: AND customer_trx_id = trx_rec.customer_trx_id
1040: AND account_class = 'REC';

Line 1063: FROM fv_ipac_trx_all

1059: CURSOR trx_cur
1060: IS
1061: SELECT customer_trx_id ,
1062: snd_app_sym
1063: FROM fv_ipac_trx_all
1064: WHERE processed_flag ='N'
1065: AND org_id = v_org_id
1066: AND set_of_books_id = v_set_of_books_id
1067: AND exclude_flag ='N'

Line 1085: FROM fv_ipac_trx_all

1081: CURSOR trx_rec_cur (p_customer_trx_id NUMBER, p_snd_app_sym VARCHAR2 )
1082: IS
1083: SELECT trx_line_no,
1084: SUM(amount) amount
1085: FROM fv_ipac_trx_all
1086: WHERE org_id = v_org_id
1087: AND set_of_books_id = v_set_of_books_id
1088: AND processed_flag ='N'
1089: AND customer_trx_id = p_customer_trx_id

Line 1099: FROM fv_ipac_trx_all

1095: -- Cursor to count the no of accounts
1096: CURSOR trx_lines_cur (p_customer_trx_id NUMBER, P_snd_app_sym VARCHAR2 )
1097: IS
1098: SELECT COUNT(1) trx_count
1099: FROM fv_ipac_trx_all
1100: WHERE org_id = v_org_id
1101: AND set_of_books_id = v_set_of_books_id
1102: AND customer_trx_id = p_customer_trx_id
1103: AND snd_app_sym = p_snd_app_sym

Line 1122: FROM fv_ipac_trx_all

1118: SELECT SUM(DECODE(cr_dr_flag,'D',ABS(amount),0)) - SUM(DECODE(cr_dr_flag,'C',ABS(amount),0)),
1119: COUNT(sgl_acct_num)
1120: INTO l_amount,
1121: l_count_sgl_acct
1122: FROM fv_ipac_trx_all
1123: WHERE set_of_books_id = v_set_of_books_id
1124: AND org_id = v_org_id
1125: AND customer_trx_id = trx_rec.customer_trx_id
1126: AND (bulk_exception <> 'BUDGETARY'

Line 1131: UPDATE fv_ipac_trx_all

1127: AND bulk_exception IS NULL)
1128: AND unt_iss = '~RA'
1129: AND snd_app_sym = trx_rec.snd_app_sym;
1130: IF MOD(l_count_sgl_acct,2) = 0 AND l_amount <> 0 THEN
1131: UPDATE fv_ipac_trx_all
1132: SET bulk_exception = 'SGL_SUM_MISMATCH',
1133: report_flag ='N' ,
1134: amount =
1135: (SELECT SUM(amount)

Line 1136: FROM fv_ipac_trx_all

1132: SET bulk_exception = 'SGL_SUM_MISMATCH',
1133: report_flag ='N' ,
1134: amount =
1135: (SELECT SUM(amount)
1136: FROM fv_ipac_trx_all
1137: WHERE set_of_books_id = v_set_of_books_id
1138: AND org_id = v_org_id
1139: AND customer_trx_id =trx_rec.customer_trx_id
1140: AND ACCOUNT_CLASS <> 'REC'

Line 1157: UPDATE fv_ipac_trx_all

1153: l_total_count := 0;
1154: FOR trx_lines_rec IN trx_lines_cur(trx_rec.customer_trx_id , trx_rec.snd_app_sym )
1155: LOOP
1156: IF trx_lines_rec.trx_count > 8 THEN
1157: UPDATE fv_ipac_trx_all
1158: SET bulk_exception = 'EXCEED_DR_CR',
1159: report_flag ='N' ,
1160: amount =
1161: (SELECT SUM(amount)

Line 1162: FROM fv_ipac_trx_all

1158: SET bulk_exception = 'EXCEED_DR_CR',
1159: report_flag ='N' ,
1160: amount =
1161: (SELECT SUM(amount)
1162: FROM fv_ipac_trx_all
1163: WHERE set_of_books_id = v_set_of_books_id
1164: AND org_id = v_org_id
1165: AND customer_trx_id =trx_rec.customer_trx_id
1166: AND ACCOUNT_CLASS <> 'REC'

Line 1212: trx_rec fv_ipac_trx_all%ROWTYPE;

1208: message VARCHAR2(240);
1209: l_valid_flag VARCHAR2(1);
1210: l_ignore_budgetary_flag VARCHAR2(1);
1211: l_drcr_acct Gl_Ussgl_Account_Pairs.dr_account_segment_value%TYPE;
1212: trx_rec fv_ipac_trx_all%ROWTYPE;
1213: v_commitment_id ra_customer_trx_all.initial_customer_trx_id%TYPE;
1214: l_sgl_acct_num gl_code_combinations.segment1%TYPE;
1215: l_module_name VARCHAR2(200) ;
1216: l_bill_to_address_id Number;

Line 1247: SELECT fv_ipac_billing_id_s.NEXTVAL+1 INTO g_start_billing_id FROM dual ;

1243: del_exception_recs;
1244: get_bal_seg_name;
1245:
1246: --get the start of billing Id
1247: SELECT fv_ipac_billing_id_s.NEXTVAL+1 INTO g_start_billing_id FROM dual ;
1248: FOR trx_select_rec IN trx_select
1249: LOOP -- trx_select
1250: init_vars;
1251: v_receipt_method_id := trx_select_rec.receipt_method_id;

Line 1290: FROM fv_ipac_trx_all

1286: IF v_original_amount < v_paid_amount THEN
1287: trx_exception_flag := 'Y';
1288: END IF;
1289: DELETE
1290: FROM fv_ipac_trx_all
1291: WHERE customer_trx_id = trx_select_rec.customer_trx_id
1292: AND processed_flag = 'N'
1293: AND exclude_flag = 'N'
1294: AND cash_receipt_id IS NULL

Line 1341: SELECT fv_ipac_billing_id_s.CURRVAL INTO g_end_billing_id FROM dual;

1337: init_vars;
1338: END LOOP; -- detail_select
1339: END LOOP; -- trx_SELECT
1340: --get the end of billing id
1341: SELECT fv_ipac_billing_id_s.CURRVAL INTO g_end_billing_id FROM dual;
1342: -- To create REC line equal to a detail lines for each transaction
1343: -- equalize_rec_lines;
1344: -- UPDATE the fv_ipac_trx_all with report flag ='N'
1345: -- FOR each distibution line of a transaction

Line 1344: -- UPDATE the fv_ipac_trx_all with report flag ='N'

1340: --get the end of billing id
1341: SELECT fv_ipac_billing_id_s.CURRVAL INTO g_end_billing_id FROM dual;
1342: -- To create REC line equal to a detail lines for each transaction
1343: -- equalize_rec_lines;
1344: -- UPDATE the fv_ipac_trx_all with report flag ='N'
1345: -- FOR each distibution line of a transaction
1346: -- if any of the distibution line has an exception
1347: UPDATE fv_ipac_trx_all trx
1348: SET report_flag ='N'

Line 1347: UPDATE fv_ipac_trx_all trx

1343: -- equalize_rec_lines;
1344: -- UPDATE the fv_ipac_trx_all with report flag ='N'
1345: -- FOR each distibution line of a transaction
1346: -- if any of the distibution line has an exception
1347: UPDATE fv_ipac_trx_all trx
1348: SET report_flag ='N'
1349: WHERE org_id = v_org_id
1350: AND set_of_books_id = v_set_of_books_id
1351: AND report_flag <> 'N'

Line 1354: FROM fv_ipac_trx_all

1350: AND set_of_books_id = v_set_of_books_id
1351: AND report_flag <> 'N'
1352: AND EXISTS
1353: (SELECT 'X'
1354: FROM fv_ipac_trx_all
1355: WHERE org_id = v_org_id
1356: AND set_of_books_id = v_set_of_books_id
1357: AND customer_trx_id = trx.customer_trx_id
1358: AND report_flag = 'N'

Line 1448: FROM fv_ipac_trx_all trx

1444: IS
1445: CURSOR trx_hdr
1446: IS
1447: SELECT customer_trx_id
1448: FROM fv_ipac_trx_all trx
1449: WHERE set_of_books_id = lv_set_of_books_id
1450: AND org_id = v_org_id
1451: AND processed_flag = 'N'
1452: AND exclude_flag = 'N'

Line 1475: FROM fv_ipac_trx_all trx

1471:
1472: -- get the total no of customer transactions
1473: SELECT COUNT(DISTINCT(customer_trx_id||trn_set_id))
1474: INTO v_header_count
1475: FROM fv_ipac_trx_all trx
1476: WHERE set_of_books_id = lv_set_of_books_id
1477: AND org_id = v_org_id
1478: AND processed_flag = 'N'
1479: AND exclude_flag = 'N'

Line 1493: FROM fv_ipac_trx_all trx

1489:
1490: -- get the count of total ussgl accounts
1491: SELECT COUNT(1)
1492: INTO l_total_ussgl_count
1493: FROM fv_ipac_trx_all trx
1494: WHERE set_of_books_id = lv_set_of_books_id
1495: AND org_id = v_org_id
1496: AND trx_line_no is NOT NULL
1497: AND unt_iss = '~RA'

Line 1501: FROM fv_ipac_trx_all trx

1497: AND unt_iss = '~RA'
1498: AND bulk_exception is NULL
1499: AND customer_trx_id IN
1500: ( SELECT customer_trx_id
1501: FROM fv_ipac_trx_all trx
1502: WHERE set_of_books_id = lv_set_of_books_id
1503: AND org_id = v_org_id
1504: AND processed_flag = 'N'
1505: AND exclude_flag = 'N'

Line 1530: FROM fv_ipac_trx_all

1526: SELECT COUNT(1)
1527: INTO v_detail_count
1528: FROM
1529: (SELECT customer_trx_id
1530: FROM fv_ipac_trx_all
1531: WHERE processed_flag = 'N'
1532: AND set_of_books_id = lv_set_of_books_id
1533: AND org_id = v_org_id
1534: AND exclude_flag = 'N'

Line 1559: lpad(FV_IPAC_AR_BATCH_HDR_S.nextval,3,'0')

1555:
1556: --Added for Bug 12839610
1557: SELECT lpad(lv_sender_alc,8,'0')||
1558: to_char(sysdate,'YYYYMMDD')||
1559: lpad(FV_IPAC_AR_BATCH_HDR_S.nextval,3,'0')
1560: INTO l_file_id
1561: FROM DUAL;
1562:
1563: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

Line 1592: -- Modified the format according to FV IPAC FY 2003-04

1588: v_statement VARCHAR2(2000);
1589: l_module_name VARCHAR2(200) ;
1590: BEGIN
1591: l_module_name := g_module_name || 'create_trx_header';
1592: -- Modified the format according to FV IPAC FY 2003-04
1593: v_statement :=
1594: 'SELECT ''H''||
1595: LPAD(SUBSTR(fit.sender_alc,1,8),8,''0'')||
1596: REPLACE(TO_CHAR(SUM(fit.amount),''FM099999999999D00''),

Line 1603: FROM fv_ipac_trx fit,

1599: RPAD(SUBSTR(fit.sender_do_sym,1,5),5,'' '') ||
1600: fit.trn_set_id ||
1601: RPAD(NVL(SUBSTR(rct.ct_reference, 1, 8), '' ''), 8, '' '')||
1602: RPAD('' '',2)
1603: FROM fv_ipac_trx fit,
1604: ra_customer_trx rct
1605: WHERE fit.set_of_books_id = :b_set_of_books_id
1606: AND rct.customer_trx_id = fit.customer_trx_id
1607: AND fit.processed_flag = ''N''

Line 1632: -- Modified the format According to FV IPAC FY 2003-04

1628: l_module_name VARCHAR2(200) ;
1629: l_trx_detail_rec VARCHAR2(8000);
1630: BEGIN
1631: l_module_name := g_module_name || 'create_trx_dtl_rec';
1632: -- Modified the format According to FV IPAC FY 2003-04
1633: SELECT 'D' || RPAD(' ',16)||RPAD(' ',12)|| REPLACE(TO_CHAR(trx_details_rec.amount, 'FM099999999999D00'),'.','')||
1634: RPAD(SUBSTR(trx_details_rec.cnt_nm,1,60),60,' ') || RPAD(nvl(trx_details_rec.cnt_phn_nr,' '),17,' ')||RPAD(' ',6)||
1635: DECODE(trx_details_rec.contract_no,NULL,RPAD(' ',17), RPAD(SUBSTR(trx_details_rec.contract_no,1,17),17,' '))||
1636: DECODE(trx_details_rec.dpr_cd,NULL,' ', RPAD(SUBSTR(trx_details_rec.dpr_cd,1,2),2,' '))||

Line 1677: FROM fv_ipac_trx_all trx

1673: IS
1674: SELECT sgl_acct_num,
1675: amount,
1676: cr_dr_flag
1677: FROM fv_ipac_trx_all trx
1678: WHERE org_id = v_org_id
1679: AND set_of_books_id = v_set_of_books_id
1680: AND customer_trx_id = p_cust_trx_id
1681: AND unt_iss = '~RA'

Line 1851: UPDATE fv_ipac_trx_all

1847: IF x_retcode = 0 THEN
1848: -- Accounted flag is set for the distribution lines
1849: -- And since exceptions are generated again for these
1850: -- lines therefore we update them as null
1851: UPDATE fv_ipac_trx_all
1852: SET accounted_flag = 'Y',
1853: bulk_exception = NULL
1854: WHERE set_of_books_id = v_set_of_books_id
1855: AND org_id = v_org_id

Line 1963: -- the table fv_ipac_trx_all

1959:
1960: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1961: 'bl_seg_name='||bl_seg_name );
1962: -- Insertion of Receipt Accounting information into
1963: -- the table fv_ipac_trx_all
1964: v_bulk_exception := NULL;
1965:
1966: v_bulk_exception := get_sgl_exception( l_gl_account_num,
1967: l_sgl_acct_num);

Line 1970: INTO fv_ipac_trx_all

1966: v_bulk_exception := get_sgl_exception( l_gl_account_num,
1967: l_sgl_acct_num);
1968:
1969: INSERT
1970: INTO fv_ipac_trx_all
1971: (
1972: set_of_books_id,
1973: org_id,
1974: ipac_billing_id,

Line 2004: fv_ipac_billing_id_s.NEXTVAL,

2000: VALUES
2001: (
2002: v_set_of_books_id,
2003: v_org_id,
2004: fv_ipac_billing_id_s.NEXTVAL,
2005: l_amount,
2006: nvl(trx_receipt_rec.cnt_nm,-99),
2007: trx_receipt_rec.trx_number,
2008: trx_receipt_rec.trx_date,

Line 2039: -- Add a new row in fv_ipac_trx_all with unt_iss = '~RA'

2035:
2036: ELSE -- SLA Accounting Failed
2037: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2038: x_errbuf);
2039: -- Add a new row in fv_ipac_trx_all with unt_iss = '~RA'
2040: -- and bulk_exception = 'ACCOUNTING_NOT_CREATED'
2041: -- for the particular transaction
2042: INSERT
2043: INTO fv_ipac_trx_all

Line 2043: INTO fv_ipac_trx_all

2039: -- Add a new row in fv_ipac_trx_all with unt_iss = '~RA'
2040: -- and bulk_exception = 'ACCOUNTING_NOT_CREATED'
2041: -- for the particular transaction
2042: INSERT
2043: INTO fv_ipac_trx_all
2044: (
2045: set_of_books_id,
2046: org_id,
2047: ipac_billing_id,

Line 2073: fv_ipac_billing_id_s.NEXTVAL,

2069: VALUES
2070: (
2071: v_set_of_books_id,
2072: v_org_id,
2073: fv_ipac_billing_id_s.NEXTVAL,
2074: trx_receipt_rec.amount,
2075: '-99',
2076: trx_receipt_rec.trx_number,
2077: trx_receipt_rec.trx_date,

Line 2098: UPDATE fv_ipac_trx_all

2094: )
2095: ;
2096: -- Also Update all the detail records related to this
2097: -- transaction with accounted_flag = 'N'
2098: UPDATE fv_ipac_trx_all
2099: SET accounted_flag = 'N'
2100: WHERE set_of_books_id = v_set_of_books_id
2101: AND org_id = v_org_id
2102: AND customer_trx_id= trx_receipt_rec.customer_trx_id

Line 2117: UPDATE fv_ipac_trx_all

2113:
2114: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2115: 'Create_Receipt_Accounting - Unexpected Error, Calling Update');
2116:
2117: UPDATE fv_ipac_trx_all
2118: SET accounted_flag = '',
2119: bulk_exception = NULL
2120: WHERE set_of_books_id = v_set_of_books_id
2121: AND org_id = v_org_id

Line 2240: UPDATE fv_ipac_trx_all

2236:
2237:
2238: -- Updating all the detail records of the selected
2239: -- transaction for its created receipt and sender alc
2240: UPDATE fv_ipac_trx_all
2241: SET sender_alc = v_sender_alc,
2242: cash_receipt_id = x_cash_receipt_id,
2243: receipt_flag = 'Y'
2244: WHERE set_of_books_id = v_set_of_books_id

Line 2296: -- Add a new row in fv_ipac_trx_all with unt_iss = '~RA'

2292: p_gl_date,
2293: x_cash_receipt_id);
2294:
2295: ELSE -- If the create_and_apply receipt fails
2296: -- Add a new row in fv_ipac_trx_all with unt_iss = '~RA'
2297: -- and bulk_exception = 'RECEIPT_NOT_CREATED' for the particular
2298: -- transaction
2299:
2300: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

Line 2304: INTO fv_ipac_trx_all

2300: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2301: 'create_and_apply receipt fails');
2302:
2303: INSERT
2304: INTO fv_ipac_trx_all
2305: (
2306: set_of_books_id,
2307: org_id,
2308: ipac_billing_id,

Line 2333: fv_ipac_billing_id_s.NEXTVAL,

2329: VALUES
2330: (
2331: v_set_of_books_id,
2332: v_org_id,
2333: fv_ipac_billing_id_s.NEXTVAL,
2334: trx_receipt_rec.amount,
2335: '-99',
2336: trx_receipt_rec.trx_number,
2337: trx_receipt_rec.trx_date,

Line 2357: UPDATE fv_ipac_trx_all

2353: )
2354: ;
2355: -- Also Update all the detail records related to this
2356: -- transaction with receipt_flag = 'N'
2357: UPDATE fv_ipac_trx_all
2358: SET receipt_flag = 'N'
2359: WHERE set_of_books_id = v_set_of_books_id
2360: AND org_id = v_org_id
2361: AND customer_trx_id = trx_receipt_rec.customer_trx_id

Line 2610: FROM fv_ipac_trx_all

2606: 'v_coa_id = '||v_coa_id);
2607:
2608: SELECT count(1)
2609: INTO l_rec_count
2610: FROM fv_ipac_trx_all
2611: WHERE set_of_books_id = v_set_of_books_id
2612: AND org_id = v_org_id
2613: AND accounted_flag ='Y'
2614: AND report_flag ='Y'

Line 2655: UPDATE fv_ipac_trx_all

2651: ------------------------------------------------------
2652: END LOOP;
2653: -- In case the process of create_bulk_file is done
2654: -- successfully set the processed flag to 'Y'
2655: UPDATE fv_ipac_trx_all
2656: SET processed_flag = 'Y'
2657: WHERE set_of_books_id = v_set_of_books_id
2658: AND org_id = v_org_id
2659: AND bulk_exception IS NULL

Line 2763: 'fv.plsql.fv_ipac','Org Id : '||v_org_id);

2759: BEGIN
2760: v_org_id := mo_global.get_current_org_id;
2761:
2762: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2763: 'fv.plsql.fv_ipac','Org Id : '||v_org_id);
2764:
2765: fv_utility.get_ledger_info(v_org_id,
2766: v_set_of_books_id,
2767: v_coa_id ,

Line 2771: g_module_name := 'fv.plsql.fv_ipac.';

2767: v_coa_id ,
2768: parm_currency ,
2769: p_status );
2770:
2771: g_module_name := 'fv.plsql.fv_ipac.';
2772: flex_code := 'GL#';
2773: apps_id := 101;
2774: trx_exception_flag := 'N';
2775: --New JFMIP REQUIREMENT pay flag should be P