1 PACKAGE BODY igs_fi_imp_lockbox_txns AS
2 /* $Header: IGSFI58B.pls 115.30 2003/05/28 08:56:01 shtatiko ship $ */
3
4 /******************************************************************
5 Created By :Sanjeeb Rakshit
6 Date Created By :25-APR-2001
7 Purpose :This package implements one procedure which insert rows to credits table
8 from interface table if everything is fine else updates the interface table
9 and writes appropriate message in the log file.
10 remarks :
11 Change History
12 Who When What
13 shtatiko 28-MAY-2003 Enh# 2831582, Obsoleted this process.
14 schodava 09-Apr-2003 Enh#2831554. Modification as a part of the Internal Credits API Build
15 vvutukur 20-Jan-2003 Bug#2727223.Modification done in procedure import_lockbox.
16 vvutukur 17-Jna-2003 Bug#2743483.Modifications done in procedure import_lockbox.
17 vchappid 31-Dec-2002 Bug# 2707089, For import_lockbox interface processes, fnd_stats.gather_table_stats
18 has to be invoked for gathering the statistics.
19 shtatiko 09-dec-2002 Enh# 2584741, Modified import_lockbox.
20 vvutukur 21-Nov-2002 Enh#2584986.Modifications done in import_lockbox.Modified functions get_log_line,
21 get_cur_desc.
22 pathipat 24-SEP-2002 Enh Bug: 2564643:
23 1. Removed references to subaccount_id as the column is being obsoleted (in cursors cur_fei
24 and cur_subaccount and in log)
25 2. Obsoleted function get_sac_name() as its used only for validating subaccount_id
26 3. Removed paramter p_subaccount_id from call to igs_fi_Credits_api_pub.create_credit()
27 4. Removed reference to subaccount_id from call to igs_fi_crd_int_pkg.update_row()
28 5. Changed message from IGS_FI_SBAC_NOT_FOR_EFF_DT to IGS_FI_CAPI_CR_TYPE_INVALID (for log)
29
30 smadathi 24-Jun-2002 Bug 2404720. Modified the import_lockbox procedure.
31 agairola 09-May-2002 Modified the import_lockbox process for the bug fix 2357948
32 agairola 24-APR-2002 The following modifications were done as part of Bug fix 2336504
33 1. Modified the Cursor cur_fei to remove the parameters for Credit Instrument
34 and credit type and also removed them from the Where clause
35 2. Added the parameter logging
36 3. The log file was modified to display the data in different lines
37 4. In the call to credits API, the values of the input
38 parameters Credit Instrument and Credit type were passed.
39 5. code for validation of the subaccount was optimised.
40 6. Functions get_pers_num, get_cr_type,get_sac_name, get_log_line and
41 get_cur_desc were introduced for modularisation of code.
42 7. Modified the concurrent program specification to remove Credit Class parameter
43 sarakshi 28-Feb-2002 modified message logging of person to party_id, bug:2238362
44 sykrishn 04-FEB-2002 call to credits api modified to include new params as part of SFCR020 build
45 Bug 2191470
46 Related changes w-r-t-o credit_source - removing the parameter and passing the same as null to credits API
47
48 sarakshi 31-Jan-2002 In the call to the credit's API adding a new parameter p_invoice_id as a part of
49 SFCR003 , bug:2195715.
50 ******************************************************************/
51
52 PROCEDURE import_lockbox( errbuf OUT NOCOPY VARCHAR2,
53 retcode OUT NOCOPY NUMBER,
54 p_receipt_lockbox_number igs_fi_crd_int_all.receipt_lockbox_number%TYPE ,
55 p_credit_instrument igs_fi_crd_int_all.credit_instrument%TYPE ,
56 p_credit_type_id igs_fi_crd_int_all.credit_type_id%TYPE ,
57 p_org_id NUMBER
58 ) AS
59
60 /******************************************************************
61 Created By :Sanjeeb Rakshit
62 Date Created By :25-APR-2001
63 Purpose :This procedure looks at the credit interface table.
64 If the transaction is defined as a valid transaction ,
65 this gets imported in the credit table in student finance
66 .Once data is successfully imported to credit table ,it would
67 be deleted from the interface table.Insertion of data to
68 credits table the credits table is taken care by the credits API.
69 remarks :
70 Change History
71 Who When What
72 shtatiko 28-MAY-2003 Enh# 2831582, This process has been obsoleted.
73 schodava 09-Apr-2003 Enh#2831554. Modified the call to Public Credits API to Private Credits API.
74 vvutukur 20-Jan-2003 Bug#2727223.Logged Status also in the log file as Error, when the currency in the Credits Interface Table does not
75 match with the currency set up in the System Options Form.
76 vvutukur 17-Jan-2003 Bug#2743483.Added code for the process to error out if Oracle Financials is not Installed, since this process
77 is valid only when Oracle Financials is Installed.
78 vchappid 31-Dec-2002 Bug# 2707089, For import_lockbox interface processes, fnd_stats.gather_table_stats
79 has to be invoked for gathering the statistics.
80 shtatiko 09-DEC-2002 Enh# 2584741, Modified cur_subaccount cursor and modified call to
81 igs_fi_credits_api_pub.create_credit.
82 vvutukur 21-Nov-2002 Enh#2584986.Modified the calls to igs_fi_credits_api_pub.create_credit,
83 igs_fi_crd_int_pkg.update_row to include p_d_gl_date.Passed p_exchange_rate as 1 in the
84 call to credits api as only local currency that is setup in System Options Form only
85 will be passed to credits api from this call.
86 pathipat 24-SEP-2002 Enh Bug: 2564643:
87 1. Removed references to subaccount_id as the column is being obsoleted (in cursors cur_fei
88 and cur_subaccount and in log)
89 2. Removed paramter p_subaccount_id from call to igs_fi_Credits_api_pub.create_credit()
90 3. Removed reference to subaccount_id from call to igs_fi_crd_int_pkg.update_row()
91 4. Removed DEFAULT NULL for p_receipt_lockbox_number igs_fi_crd_int_all.receipt_lockbox_number%TYPE
92 to prevent gscc warning (as it is already present in spec).
93
94 smadathi 24-Jun-2002 Bug 2404720.The cursor cur_subaccount select is modified to fetch description
95 column along with the other columns. The call to igs_fi_credits_api_pub.create_credit
96 was modified to pass this description value to the formal parameter p_description
97 agairola 09-May-2002 The following modifications were done as part of bug fix 2357948
98 1. Modified the cursor cur_fei to include the Sub Account and the
99 effective start date and end date.
100 2. Modified the cursor cur_subaccount to fetch the Effective Start
101 date and end date.
102 3. Modified the code to fetch the SubAccount for the credit type before
103 the cursor to select the data from the Credits Interface table
104 4. Removed the code inside the cur_fei loop for subaccount validations as this
105 is being done before the cursor cur_fei is opened.
106 5. Modified the code to remove the extra UPDATE_ROW call for updating the status
107 to error for the table IGS_FI_CRD_INT
108 agairola 24-APR-2002 The following modifications were done as part of Bug fix 2336504
109 1. Modified the Cursor cur_fei to remove the parameters for Credit Instrument
110 and credit type and also removed them from the Where clause
111 2. Added the parameter logging
112 3. The log file was modified to display the data in different lines
113 4. In the call to credits API, the values of the input
114 parameters Credit Instrument and Credit type were passed.
115 5. code for validation of the subaccount was optimised.
116 sarakshi 31-Jan-2002 In the call to the credit's API adding a new parameter p_invoice_id as a part of
117 SFCR003 , bug:2195715.
118 ******************************************************************/
119
120 BEGIN
121
122 /*
123 * Enh# 2831582, Lockbox design introduces a new Lockbox functionality
124 * detached from Oracle Receivables (AR) Module.
125 * Due to this change, the existing processes related to import lockbox transactions from AR is obsolesced.
126 */
127 fnd_message.set_name('IGS', 'IGS_GE_OBSOLETE_JOB');
128 fnd_file.put_line( fnd_file.LOG, fnd_message.get());
129 retcode := 0;
130
131 END import_lockbox;
132
133 -- end of package body
134 END igs_fi_imp_lockbox_txns;