1 PACKAGE BODY igs_fi_tran_lockbox_txns AS
2 /* $Header: IGSFI55B.pls 115.24 2003/05/28 08:52:46 shtatiko ship $ */
3
4 /***************************************************************
5 Created By : bayadav
6 Date Created By : 2001/04/25
7 Purpose : To upload data from 'AR_CASH_RECEIPTS' AR Cash Receipts
8 table into 'IGS_FI_CRD_INT_ALL' credit interface table
9 Known Limitations,Enhancements or Remarks:
10 Change History :
11 Who When What
12 shtatiko 28-MAY-2003 Enh# 2831582, This process has been obsoleted and removed all the local procedures as they are no longer be used
13 SYKRISHN 05/MAR/2003 Bug Fix 2727192 ~ Validation for Transaction Dates parameter introduced
14 vvutukur 17-Jan-2003 Bug#2743483.Modifications done in procedure transfer_lockbox.
15 vvutukur 21-Nov-2002 Enh#2584986.Added new parameter p_d_gl_date parameter to the procedure transfer_lockbox.
16 Also modified get_cur_desc.Removed local function lookup_desc and its call in get_log_line.
17 pathipat 24-SEP-2002 Enh Bug# 2564643: subaccount_id column made obsolete in IGS_FI_CRD_INT and IGS_FI_SA_LOCKBOXES
18 In TRANSFER_LOCKBOX() proc, removed local variables for subaccount_id and removed it in INSERT_ROW().
19 Removed cursor c_subaccount_id and its usage thereafter.
20 Removed all DEFAULT NULL in proc transfer_lockbox()
21
22 vchappid 13-Jun-2002 Bug#2411529, Incorrectly used message name has been modified
23
24 agairola 27-May-2002 For the bugs 2383820,2336344, created private function get_pers_grp_code
25 for fetching the Person id Group code to be displayed. Also
26 modified the log file parameter logging.
27
28 vvutukur 24-May-2002 For bugs.2383820,2336344,created private functions get_log_line,get_cur_desc,
29 get_cust_acct_num,get_pers_num and called them in transfer_lockbox main procedure
30 to show log in multiline.Shown customer account number also in the log.Modified cursor
31 c_ar_cash_rec, used BETWEEN instead of handling cp_txn_date_low,cp_txn_date_high values
32 individually for checking with receipt date(for the improvement of code).
33
34 agairola 24-May-2002 For bug 2383846, while inserting record in the Credits Interface table
35 passing NULL to Attribute_Category in transfer_lockbox procedure
36
37 vvutukur 17-May-2002 bug#2372093.Modified transfer_lockbox procedure to add validation for p_lockbox_num.
38
39 sarakshi 28-Feb-2002 bug:2238362,replaced PERSON to PARTY_ID in logging a message in log file
40
41 sykrishn 19-FEB-02 Changes as part of SFCR023 - 2227831 - Changes to transfer_lockbox procedure
42 Removed Cursor c_ar_cash_rec_all_att as it not used anywhere
43
44 jbegum 15 Feb 02 As part of Enh bug #2222272
45 Selecting the org_id from the control table prior to importing the lockbox
46 transactions from Accounts Receivable to Student Finance
47
48 ***************************************************************/
49
50 PROCEDURE transfer_lockbox( ERRBUF OUT NOCOPY VARCHAR2,
51 RETCODE OUT NOCOPY NUMBER,
52 p_person_id IN igs_pe_person_v.person_id%TYPE ,
53 p_person_id_group IN igs_pe_persid_group_v.group_id%TYPE ,
54 p_lockbox_num IN ar_lockboxes.lockbox_number%TYPE,
55 p_txn_date_low IN VARCHAR2 ,
56 p_txn_date_high IN VARCHAR2 ,
57 p_org_id IN NUMBER,
58 p_d_gl_date IN VARCHAR2
59 )AS
60 /***************************************************************
61 Created By : bayadav
62 Date Created By : 2001/04/25
63 Purpose : To upload data from 'AR_CASH_RECEIPTS' AR Cash Receipts
64 table into 'IGS_FI_CRD_INT_ALL' credit interface table
65 Known Limitations,Enhancements or Remarks:
66 Change History :
67 Who When What
68 shtatiko 28-MAY-2003 Enh# 2831582, This process has been obsoleted.
69 sykrishn 5-mar-03 Bug 2727192 - Added Transaction Dates validation
70 vvutukur 17-Jna-2003 Bug#2743483.Added code for the process to error out if Oracle Financials is not Installed, since this process
71 is valid only when Oracle Financials is Installed.
72 vvutukur 21-Nov-2002 Enh#2584986.Added new parameter p_d_gl_date and corresponding validations.
73 pathipat 24-SEP-2002 Enh Bug# 2564643: subaccount_id column made obsolete in IGS_FI_CRD_INT and IGS_FI_SA_LOCKBOXES
74 Removed local variables for subaccount_id and removed it in INSERT_ROW().
75 Removed cursor c_subaccount_id and its usage thereafter.
76 Removed all 'DEFAULT NULL' (DEFAULT present only in spec)
77
78 vchappid 13-Jun-2002 Bug#2411529, Incorrectly used message name has been modified
79 agairola 27-May-2002 For the bugs 2383820,2336344, modified the log file parameter logging.
80 vvutukur 24-May-2002 For bugs 2383820,2336344.modified code to show log file output in multiline.
81 Modified such that parameters are logged first and then show log file in multiline
82 format. Modified l_indicator logic such that it shows all records that are transferred
83 to credits interface table.Called function get_cust_acct_num to show cutomer account name.
84 agairola 24-May-2002 For bug 2383846, while inserting record in the Credits Interface table
85 passing NULL to Attribute_Category
86 vvutukur 17-May-2002 Added cursor cur_lockbox validation if p_lockbox_num is not null.
87 thrown message IGS_FI_CAPI_INVALID_LOCKBOX if p_lockbox_num parameter
88 is invalid.bug#2372093.
89 sykrishn 19-FEB-2002 As part of Enh 2227831
90 Made p_lockbox_num mandatory Param
91 Removed code which executes when p_lockbox_num is NULL (no longer required)
92
93 jbegum 15 Feb 02 As part of Enh bug #2222272
94 Selecting the org_id from the control table prior to importing the lockbox
95 transactions from Accounts Receivable to Student Finance.
96 Also modified the CURSOR c_control_lockbox_attr
97
98 ***************************************************************/
99
100 BEGIN
101
102 /*
103 * Enh# 2831582, Lockbox design introduces a new Lockbox functionality
104 * detached from Oracle Receivables (AR) Module.
105 * Due to this change, the existing processes related to transfer lockbox transactions to AR is obsolesced.
106 */
107 fnd_message.set_name('IGS', 'IGS_GE_OBSOLETE_JOB');
108 fnd_file.put_line( fnd_file.LOG, fnd_message.get());
109 retcode := 0;
110
111 END transfer_lockbox;
112 END igs_fi_tran_lockbox_txns;