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.57.12010000.2 2008/08/04 11:30:14 gnrajago 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 63: v_trx_excpt_cat fv_ipac_trx_all.exception_category%TYPE;

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

Line 64: v_trx_exception fv_ipac_trx_all.exception_category%TYPE;

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

Line 65: v_bulk_exception fv_ipac_trx_all.bulk_exception%TYPE;

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

Line 168: FROM fv_ipac_trx_all

164: AND rctl.created_by = fu.user_id(+)
165: AND rgld.set_of_books_id = v_set_of_books_id
166: AND NOT EXISTS
167: (SELECT 'X'
168: FROM fv_ipac_trx_all
169: WHERE set_of_books_id = v_set_of_books_id
170: AND org_id = v_org_id
171: AND customer_trx_id = p_customer_trx_id
172: AND trx_line_no = rctl.line_number

Line 187: FROM fv_ipac_trx_all fit

183: fit.customer_id,
184: fit.cash_receipt_id ,
185: fit.accounted_flag,
186: fit.cnt_nm
187: FROM fv_ipac_trx_all fit
188: WHERE fit.exclude_flag = 'N'
189: AND set_of_books_id = v_set_of_books_id
190: AND org_id = v_org_id
191: AND fit.report_flag = 'Y'

Line 226: FROM fv_ipac_trx_all

222: IS
223: SELECT customer_trx_id,
224: snd_app_sym,
225: sgl_acct_num
226: FROM fv_ipac_trx_all
227: WHERE unt_iss = '~RA'
228: AND set_of_books_id = v_set_of_books_id
229: AND org_id = v_org_id
230: AND report_flag = 'Y'

Line 241: FROM fv_ipac_trx_all trx

237: -- whose receipt is already created and SLA accounting generated successfully
238: CURSOR hdr_det(p_set_of_books_id NUMBER, p_org_id NUMBER)
239: IS
240: SELECT DISTINCT customer_trx_id
241: FROM fv_ipac_trx_all trx
242: WHERE set_of_books_id = p_set_of_books_id
243: AND org_id = p_org_id
244: AND processed_flag = 'N'
245: AND exclude_flag = 'N'

Line 282: FROM fv_ipac_trx_all fit,

278: fit.cash_receipt_id,
279: fit.sender_do_sym,
280: fit.sender_alc,
281: rct.comments comments
282: FROM fv_ipac_trx_all fit,
283: ra_customer_trx rct
284: WHERE fit.org_id = v_org_id
285: AND fit.set_of_books_id = v_set_of_books_id
286: AND fit.customer_trx_id = p_cust_trx_id

Line 349: -- from fv_ipac_trx_all

345:
346: -- -----------------------------------------------------------------------------
347: -- -----------------------------------------------------------------------------
348: -- Procedure to delete exception records
349: -- from fv_ipac_trx_all
350: PROCEDURE del_exception_recs
351: IS
352: l_module_name VARCHAR2(200) ;
353: BEGIN

Line 356: FROM fv_ipac_trx_all trx

352: l_module_name VARCHAR2(200) ;
353: BEGIN
354: l_module_name := g_module_name || 'del_exception_recs';
355: DELETE
356: FROM fv_ipac_trx_all trx
357: WHERE set_of_books_id = v_set_of_books_id
358: AND NVL(org_id,-99) = NVL(v_org_id,-99)
359: AND (report_flag = 'N'
360: OR ( report_flag = 'Y'

Line 382: FROM fv_ipac_trx_all

378: l_module_name VARCHAR2(200) ;
379: BEGIN
380: l_module_name := g_module_name || 'delete_records';
381: DELETE
382: FROM fv_ipac_trx_all
383: WHERE set_of_books_id = v_set_of_books_id
384: AND NVL(org_id,-99) = NVL(v_org_id,-99)
385: AND ipac_billing_id BETWEEN g_start_billing_id AND g_end_billing_id ;
386: EXCEPTION

Line 491: 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

487: -- -----------------------------------------------------------------------------
488: -- -----------------------------------------------------------------------------
489: -- Function to get the transaction exception category
490: -- based on the passed transaction record values
491: 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
492: IS
493: l_sgl_acct_num gl_code_combinations.segment1%TYPE;
494: BEGIN
495: v_trx_excpt_cat := NULL;

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

650: -- -----------------------------------------------------------------------------
651: -- -----------------------------------------------------------------------------
652:
653: -- Procedure to insert transaction records
654: PROCEDURE insert_trx_rec(ins_trx IN fv_ipac_trx_all%ROWTYPE)
655: IS
656: v_trx_billing_id NUMBER;
657: v_trx_excl_flag VARCHAR2(1) ;
658: v_trx_proc_flag VARCHAR2(1) ;

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

660: BEGIN
661: v_trx_excl_flag := 'N';
662: v_trx_proc_flag := 'N';
663: l_module_name := g_module_name || 'insert_trx_rec';
664: SELECT fv_ipac_billing_id_s.NEXTVAL INTO v_trx_billing_id FROM dual;
665: INSERT
666: INTO fv_ipac_trx_all
667: (
668: set_of_books_id,

Line 666: INTO fv_ipac_trx_all

662: v_trx_proc_flag := 'N';
663: l_module_name := g_module_name || 'insert_trx_rec';
664: SELECT fv_ipac_billing_id_s.NEXTVAL INTO v_trx_billing_id FROM dual;
665: INSERT
666: INTO fv_ipac_trx_all
667: (
668: set_of_books_id,
669: org_id,
670: run_date,

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

749: EXCEPTION
750: WHEN OTHERS THEN
751: errcode := SQLCODE;
752: errmsg := SQLERRM || ' -- Error in inserting the data into' ||
753: ' FV_IPAC_TRX_ALL table : Procedure :- insert_trx_rec';
754: RAISE;
755: END; -- insert_trx_rec
756:
757: -- -----------------------------------------------------------------------------

Line 982: FROM fv_ipac_trx_all

978: -- cursor to get the customer_trx_id and and treasury Symbol
979: CURSOR trx_cur IS
980: SELECT customer_trx_id ,
981: snd_app_sym
982: FROM fv_ipac_trx_all
983: WHERE processed_flag ='N'
984: AND set_of_books_id = v_set_of_books_id
985: AND org_id = v_org_id
986: AND exclude_flag ='N'

Line 999: FROM fv_ipac_trx_all

995: CURSOR trx_rec_cur (p_customer_trx_id NUMBER,
996: p_snd_app_sym VARCHAR2 )
997: IS SELECT trx_line_no,
998: SUM(amount) amount
999: FROM fv_ipac_trx_all
1000: WHERE org_id = v_org_id
1001: AND set_of_books_id = v_set_of_books_id
1002: AND processed_flag ='N'
1003: AND customer_trx_id = p_customer_trx_id

Line 1010: l_trx_rec FV_IPAC_TRX_ALL%ROWTYPE;

1006: AND unt_iss <> '~RA'
1007: AND set_of_books_id = v_set_of_books_id
1008: AND exclude_flag ='N'
1009: GROUP BY trx_line_no ;
1010: l_trx_rec FV_IPAC_TRX_ALL%ROWTYPE;
1011: l_module_name VARCHAR2(200) ;
1012: BEGIN
1013: l_module_name := g_module_name ||'equalize_rec_lines';
1014: FOR trx_rec IN trx_cur

Line 1020: FROM fv_ipac_trx_all

1016: FOR trx_rec_rec IN trx_rec_cur(trx_rec.customer_trx_id ,
1017: trx_rec.snd_app_sym )
1018: LOOP
1019: SELECT * INTO l_trx_rec
1020: FROM fv_ipac_trx_all
1021: WHERE org_id = v_org_id
1022: AND set_of_books_id = v_set_of_books_id
1023: AND customer_trx_id = trx_rec.customer_trx_id
1024: AND account_class = 'REC';

Line 1047: FROM fv_ipac_trx_all

1043: CURSOR trx_cur
1044: IS
1045: SELECT customer_trx_id ,
1046: snd_app_sym
1047: FROM fv_ipac_trx_all
1048: WHERE processed_flag ='N'
1049: AND org_id = v_org_id
1050: AND set_of_books_id = v_set_of_books_id
1051: AND exclude_flag ='N'

Line 1069: FROM fv_ipac_trx_all

1065: CURSOR trx_rec_cur (p_customer_trx_id NUMBER, p_snd_app_sym VARCHAR2 )
1066: IS
1067: SELECT trx_line_no,
1068: SUM(amount) amount
1069: FROM fv_ipac_trx_all
1070: WHERE org_id = v_org_id
1071: AND set_of_books_id = v_set_of_books_id
1072: AND processed_flag ='N'
1073: AND customer_trx_id = p_customer_trx_id

Line 1083: FROM fv_ipac_trx_all

1079: -- Cursor to count the no of accounts
1080: CURSOR trx_lines_cur (p_customer_trx_id NUMBER, P_snd_app_sym VARCHAR2 )
1081: IS
1082: SELECT COUNT(1) trx_count
1083: FROM fv_ipac_trx_all
1084: WHERE org_id = v_org_id
1085: AND set_of_books_id = v_set_of_books_id
1086: AND customer_trx_id = p_customer_trx_id
1087: AND snd_app_sym = p_snd_app_sym

Line 1106: FROM fv_ipac_trx_all

1102: SELECT SUM(DECODE(cr_dr_flag,'D',ABS(amount),0)) - SUM(DECODE(cr_dr_flag,'C',ABS(amount),0)),
1103: COUNT(sgl_acct_num)
1104: INTO l_amount,
1105: l_count_sgl_acct
1106: FROM fv_ipac_trx_all
1107: WHERE set_of_books_id = v_set_of_books_id
1108: AND org_id = v_org_id
1109: AND customer_trx_id = trx_rec.customer_trx_id
1110: AND (bulk_exception <> 'BUDGETARY'

Line 1115: UPDATE fv_ipac_trx_all

1111: AND bulk_exception IS NULL)
1112: AND unt_iss = '~RA'
1113: AND snd_app_sym = trx_rec.snd_app_sym;
1114: IF MOD(l_count_sgl_acct,2) = 0 AND l_amount <> 0 THEN
1115: UPDATE fv_ipac_trx_all
1116: SET bulk_exception = 'SGL_SUM_MISMATCH',
1117: report_flag ='N' ,
1118: amount =
1119: (SELECT SUM(amount)

Line 1120: FROM fv_ipac_trx_all

1116: SET bulk_exception = 'SGL_SUM_MISMATCH',
1117: report_flag ='N' ,
1118: amount =
1119: (SELECT SUM(amount)
1120: FROM fv_ipac_trx_all
1121: WHERE set_of_books_id = v_set_of_books_id
1122: AND org_id = v_org_id
1123: AND customer_trx_id =trx_rec.customer_trx_id
1124: AND ACCOUNT_CLASS <> 'REC'

Line 1141: UPDATE fv_ipac_trx_all

1137: l_total_count := 0;
1138: FOR trx_lines_rec IN trx_lines_cur(trx_rec.customer_trx_id , trx_rec.snd_app_sym )
1139: LOOP
1140: IF trx_lines_rec.trx_count > 8 THEN
1141: UPDATE fv_ipac_trx_all
1142: SET bulk_exception = 'EXCEED_DR_CR',
1143: report_flag ='N' ,
1144: amount =
1145: (SELECT SUM(amount)

Line 1146: FROM fv_ipac_trx_all

1142: SET bulk_exception = 'EXCEED_DR_CR',
1143: report_flag ='N' ,
1144: amount =
1145: (SELECT SUM(amount)
1146: FROM fv_ipac_trx_all
1147: WHERE set_of_books_id = v_set_of_books_id
1148: AND org_id = v_org_id
1149: AND customer_trx_id =trx_rec.customer_trx_id
1150: AND ACCOUNT_CLASS <> 'REC'

Line 1196: trx_rec fv_ipac_trx_all%ROWTYPE;

1192: message VARCHAR2(240);
1193: l_valid_flag VARCHAR2(1);
1194: l_ignore_budgetary_flag VARCHAR2(1);
1195: l_drcr_acct Gl_Ussgl_Account_Pairs.dr_account_segment_value%TYPE;
1196: trx_rec fv_ipac_trx_all%ROWTYPE;
1197: v_commitment_id ra_customer_trx_all.initial_customer_trx_id%TYPE;
1198: l_sgl_acct_num gl_code_combinations.segment1%TYPE;
1199: l_module_name VARCHAR2(200) ;
1200: l_bill_to_address_id Number;

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

1227: del_exception_recs;
1228: get_bal_seg_name;
1229: Fv_Utility.Log_Mesg(FND_LOG.LEVEL_STATEMENT,l_module_name, 'Default ALC is '||v_default_alc);
1230: --get the start of billing Id
1231: SELECT fv_ipac_billing_id_s.NEXTVAL+1 INTO g_start_billing_id FROM dual ;
1232: FOR trx_select_rec IN trx_select
1233: LOOP -- trx_select
1234: init_vars;
1235: v_receipt_method_id := trx_select_rec.receipt_method_id;

Line 1274: FROM fv_ipac_trx_all

1270: IF v_original_amount < v_paid_amount THEN
1271: trx_exception_flag := 'Y';
1272: END IF;
1273: DELETE
1274: FROM fv_ipac_trx_all
1275: WHERE customer_trx_id = trx_select_rec.customer_trx_id
1276: AND processed_flag = 'N'
1277: AND exclude_flag = 'N'
1278: AND cash_receipt_id IS NULL

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

1321: init_vars;
1322: END LOOP; -- detail_select
1323: END LOOP; -- trx_SELECT
1324: --get the end of billing id
1325: SELECT fv_ipac_billing_id_s.CURRVAL INTO g_end_billing_id FROM dual;
1326: -- To create REC line equal to a detail lines for each transaction
1327: -- equalize_rec_lines;
1328: -- UPDATE the fv_ipac_trx_all with report flag ='N'
1329: -- FOR each distibution line of a transaction

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

1324: --get the end of billing id
1325: SELECT fv_ipac_billing_id_s.CURRVAL INTO g_end_billing_id FROM dual;
1326: -- To create REC line equal to a detail lines for each transaction
1327: -- equalize_rec_lines;
1328: -- UPDATE the fv_ipac_trx_all with report flag ='N'
1329: -- FOR each distibution line of a transaction
1330: -- if any of the distibution line has an exception
1331: UPDATE fv_ipac_trx_all trx
1332: SET report_flag ='N'

Line 1331: UPDATE fv_ipac_trx_all trx

1327: -- equalize_rec_lines;
1328: -- UPDATE the fv_ipac_trx_all with report flag ='N'
1329: -- FOR each distibution line of a transaction
1330: -- if any of the distibution line has an exception
1331: UPDATE fv_ipac_trx_all trx
1332: SET report_flag ='N'
1333: WHERE org_id = v_org_id
1334: AND set_of_books_id = v_set_of_books_id
1335: AND report_flag <> 'N'

Line 1338: FROM fv_ipac_trx_all

1334: AND set_of_books_id = v_set_of_books_id
1335: AND report_flag <> 'N'
1336: AND EXISTS
1337: (SELECT 'X'
1338: FROM fv_ipac_trx_all
1339: WHERE org_id = v_org_id
1340: AND set_of_books_id = v_set_of_books_id
1341: AND customer_trx_id = trx.customer_trx_id
1342: AND report_flag = 'N'

Line 1431: FROM fv_ipac_trx_all trx

1427: IS
1428: CURSOR trx_hdr
1429: IS
1430: SELECT customer_trx_id
1431: FROM fv_ipac_trx_all trx
1432: WHERE set_of_books_id = lv_set_of_books_id
1433: AND org_id = v_org_id
1434: AND processed_flag = 'N'
1435: AND exclude_flag = 'N'

Line 1457: FROM fv_ipac_trx_all trx

1453:
1454: -- get the total no of customer transactions
1455: SELECT COUNT(DISTINCT(customer_trx_id||trn_set_id))
1456: INTO v_header_count
1457: FROM fv_ipac_trx_all trx
1458: WHERE set_of_books_id = lv_set_of_books_id
1459: AND org_id = v_org_id
1460: AND processed_flag = 'N'
1461: AND exclude_flag = 'N'

Line 1475: FROM fv_ipac_trx_all trx

1471:
1472: -- get the count of total ussgl accounts
1473: SELECT COUNT(1)
1474: INTO l_total_ussgl_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 trx_line_no is NOT NULL
1479: AND unt_iss = '~RA'

Line 1483: FROM fv_ipac_trx_all trx

1479: AND unt_iss = '~RA'
1480: AND bulk_exception is NULL
1481: AND customer_trx_id IN
1482: ( SELECT customer_trx_id
1483: FROM fv_ipac_trx_all trx
1484: WHERE set_of_books_id = lv_set_of_books_id
1485: AND org_id = v_org_id
1486: AND processed_flag = 'N'
1487: AND exclude_flag = 'N'

Line 1504: FROM fv_ipac_trx_all

1500: SELECT COUNT(1)
1501: INTO v_detail_count
1502: FROM
1503: (SELECT customer_trx_id
1504: FROM fv_ipac_trx_all
1505: WHERE processed_flag = 'N'
1506: AND set_of_books_id = lv_set_of_books_id
1507: AND org_id = v_org_id
1508: AND exclude_flag = 'N'

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

1547: v_statement VARCHAR2(2000);
1548: l_module_name VARCHAR2(200) ;
1549: BEGIN
1550: l_module_name := g_module_name || 'create_trx_header';
1551: -- Modified the format according to FV IPAC FY 2003-04
1552: v_statement :=
1553: 'SELECT ''H''||
1554: LPAD(SUBSTR(fit.sender_alc,1,8),8,''0'')||
1555: REPLACE(TO_CHAR(SUM(fit.amount),''FM099999999999D00''),

Line 1562: FROM fv_ipac_trx fit,

1558: RPAD(SUBSTR(fit.sender_do_sym,1,5),5,'' '') ||
1559: fit.trn_set_id ||
1560: RPAD(NVL(SUBSTR(rct.ct_reference, 1, 8), '' ''), 8, '' '')||
1561: RPAD('' '',2)
1562: FROM fv_ipac_trx fit,
1563: ra_customer_trx rct
1564: WHERE fit.set_of_books_id = :b_set_of_books_id
1565: AND rct.customer_trx_id = fit.customer_trx_id
1566: AND fit.processed_flag = ''N''

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

1587: l_module_name VARCHAR2(200) ;
1588: l_trx_detail_rec VARCHAR2(8000);
1589: BEGIN
1590: l_module_name := g_module_name || 'create_trx_dtl_rec';
1591: -- Modified the format According to FV IPAC FY 2003-04
1592: SELECT 'D' || RPAD(' ',16)||RPAD(' ',12)|| REPLACE(TO_CHAR(trx_details_rec.amount, 'FM099999999999D00'),'.','')||
1593: RPAD(SUBSTR(trx_details_rec.cnt_nm,1,60),60,' ') || RPAD(nvl(trx_details_rec.cnt_phn_nr,' '),17,' ')||RPAD(' ',6)||
1594: DECODE(trx_details_rec.contract_no,NULL,RPAD(' ',17), RPAD(SUBSTR(trx_details_rec.contract_no,1,17),17,' '))||
1595: DECODE(trx_details_rec.dpr_cd,NULL,' ', RPAD(SUBSTR(trx_details_rec.dpr_cd,1,2),2,' '))||

Line 1636: FROM fv_ipac_trx_all trx

1632: IS
1633: SELECT sgl_acct_num,
1634: amount,
1635: cr_dr_flag
1636: FROM fv_ipac_trx_all trx
1637: WHERE org_id = v_org_id
1638: AND set_of_books_id = v_set_of_books_id
1639: AND customer_trx_id = p_cust_trx_id
1640: AND unt_iss = '~RA'

Line 1809: UPDATE fv_ipac_trx_all

1805: IF x_retcode = 0 THEN
1806: -- Accounted flag is set for the distribution lines
1807: -- And since exceptions are generated again for these
1808: -- lines therefore we update them as null
1809: UPDATE fv_ipac_trx_all
1810: SET accounted_flag = 'Y',
1811: bulk_exception = NULL
1812: WHERE set_of_books_id = v_set_of_books_id
1813: AND org_id = v_org_id

Line 1921: -- the table fv_ipac_trx_all

1917:
1918: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1919: 'bl_seg_name='||bl_seg_name );
1920: -- Insertion of Receipt Accounting information into
1921: -- the table fv_ipac_trx_all
1922: v_bulk_exception := NULL;
1923:
1924: v_bulk_exception := get_sgl_exception( l_gl_account_num,
1925: l_sgl_acct_num);

Line 1928: INTO fv_ipac_trx_all

1924: v_bulk_exception := get_sgl_exception( l_gl_account_num,
1925: l_sgl_acct_num);
1926:
1927: INSERT
1928: INTO fv_ipac_trx_all
1929: (
1930: set_of_books_id,
1931: org_id,
1932: ipac_billing_id,

Line 1961: fv_ipac_billing_id_s.NEXTVAL,

1957: VALUES
1958: (
1959: v_set_of_books_id,
1960: v_org_id,
1961: fv_ipac_billing_id_s.NEXTVAL,
1962: l_amount,
1963: nvl(trx_receipt_rec.cnt_nm,-99),
1964: trx_receipt_rec.trx_number,
1965: trx_receipt_rec.trx_date,

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

1991:
1992: ELSE -- SLA Accounting Failed
1993: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1994: x_errbuf);
1995: -- Add a new row in fv_ipac_trx_all with unt_iss = '~RA'
1996: -- and bulk_exception = 'ACCOUNTING_NOT_CREATED'
1997: -- for the particular transaction
1998: INSERT
1999: INTO fv_ipac_trx_all

Line 1999: INTO fv_ipac_trx_all

1995: -- Add a new row in fv_ipac_trx_all with unt_iss = '~RA'
1996: -- and bulk_exception = 'ACCOUNTING_NOT_CREATED'
1997: -- for the particular transaction
1998: INSERT
1999: INTO fv_ipac_trx_all
2000: (
2001: set_of_books_id,
2002: org_id,
2003: ipac_billing_id,

Line 2028: fv_ipac_billing_id_s.NEXTVAL,

2024: VALUES
2025: (
2026: v_set_of_books_id,
2027: v_org_id,
2028: fv_ipac_billing_id_s.NEXTVAL,
2029: trx_receipt_rec.amount,
2030: '-99',
2031: trx_receipt_rec.trx_number,
2032: trx_receipt_rec.trx_date,

Line 2052: UPDATE fv_ipac_trx_all

2048: )
2049: ;
2050: -- Also Update all the detail records related to this
2051: -- transaction with accounted_flag = 'N'
2052: UPDATE fv_ipac_trx_all
2053: SET accounted_flag = 'N'
2054: WHERE set_of_books_id = v_set_of_books_id
2055: AND org_id = v_org_id
2056: AND customer_trx_id= trx_receipt_rec.customer_trx_id

Line 2069: UPDATE fv_ipac_trx_all

2065:
2066: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2067: 'Create_Receipt_Accounting - Unexpected Error, Calling Update');
2068:
2069: UPDATE fv_ipac_trx_all
2070: SET accounted_flag = '',
2071: bulk_exception = NULL
2072: WHERE set_of_books_id = v_set_of_books_id
2073: AND org_id = v_org_id

Line 2176: UPDATE fv_ipac_trx_all

2172:
2173:
2174: -- Updating all the detail records of the selected
2175: -- transaction for its created receipt and sender alc
2176: UPDATE fv_ipac_trx_all
2177: SET sender_alc = v_sender_alc,
2178: cash_receipt_id = x_cash_receipt_id,
2179: receipt_flag = 'Y'
2180: WHERE set_of_books_id = v_set_of_books_id

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

2228: p_gl_date,
2229: x_cash_receipt_id);
2230:
2231: ELSE -- If the create_and_apply receipt fails
2232: -- Add a new row in fv_ipac_trx_all with unt_iss = '~RA'
2233: -- and bulk_exception = 'RECEIPT_NOT_CREATED' for the particular
2234: -- transaction
2235:
2236: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

Line 2240: INTO fv_ipac_trx_all

2236: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2237: 'create_and_apply receipt fails');
2238:
2239: INSERT
2240: INTO fv_ipac_trx_all
2241: (
2242: set_of_books_id,
2243: org_id,
2244: ipac_billing_id,

Line 2268: fv_ipac_billing_id_s.NEXTVAL,

2264: VALUES
2265: (
2266: v_set_of_books_id,
2267: v_org_id,
2268: fv_ipac_billing_id_s.NEXTVAL,
2269: trx_receipt_rec.amount,
2270: '-99',
2271: trx_receipt_rec.trx_number,
2272: trx_receipt_rec.trx_date,

Line 2291: UPDATE fv_ipac_trx_all

2287: )
2288: ;
2289: -- Also Update all the detail records related to this
2290: -- transaction with receipt_flag = 'N'
2291: UPDATE fv_ipac_trx_all
2292: SET receipt_flag = 'N'
2293: WHERE set_of_books_id = v_set_of_books_id
2294: AND org_id = v_org_id
2295: AND customer_trx_id = trx_receipt_rec.customer_trx_id

Line 2539: FROM fv_ipac_trx_all

2535: 'v_coa_id = '||v_coa_id);
2536:
2537: SELECT count(1)
2538: INTO l_rec_count
2539: FROM fv_ipac_trx_all
2540: WHERE set_of_books_id = v_set_of_books_id
2541: AND org_id = v_org_id
2542: AND accounted_flag ='Y'
2543: AND report_flag ='Y'

Line 2584: UPDATE fv_ipac_trx_all

2580: ------------------------------------------------------
2581: END LOOP;
2582: -- In case the process of create_bulk_file is done
2583: -- successfully set the processed flag to 'Y'
2584: UPDATE fv_ipac_trx_all
2585: SET processed_flag = 'Y'
2586: WHERE set_of_books_id = v_set_of_books_id
2587: AND org_id = v_org_id
2588: AND bulk_exception IS NULL

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

2688: BEGIN
2689: v_org_id := mo_global.get_current_org_id;
2690:
2691: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2692: 'fv.plsql.fv_ipac','Org Id : '||v_org_id);
2693:
2694: fv_utility.get_ledger_info(v_org_id,
2695: v_set_of_books_id,
2696: v_coa_id ,

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

2696: v_coa_id ,
2697: parm_currency ,
2698: p_status );
2699:
2700: g_module_name := 'fv.plsql.fv_ipac.';
2701: flex_code := 'GL#';
2702: apps_id := 101;
2703: trx_exception_flag := 'N';
2704: --New JFMIP REQUIREMENT pay flag should be P