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.

[Home] [Help]

APPS.IGS_FI_POSTING_PROCESS dependencies on IGS_FI_POSTING_INT

Line 16: | IGS_FI_Posting_INT. IF Oracle AR is installed then the data gets |

12: | NOTES |
13: | This is a batch process that collects all eligible transactions |
14: | for posting purposes from charges lines, credit activities and |
15: | application tables. The output is inserted into the |
16: | IGS_FI_Posting_INT. IF Oracle AR is installed then the data gets |
17: | transfered to the same. |
18: | |
19: | HISTORY |
20: | Who When What |

Line 92: | the IGS_FI_POSTING_INT_PKG.insert_row,|

88: | orig_appl_fee_ref to comments field of|
89: | RA_INTERFACE_LINES_ALL when |
90: | source_transaction_type is APPLFEE |
91: | Also added column orig_appl_fee_ref to|
92: | the IGS_FI_POSTING_INT_PKG.insert_row,|
93: | IGS_FI_POSTING_INT_PKG.update_row |
94: | agairola 22-Feb-2002 Added the modifications related to |
95: | Customer Account and also calling the |
96: | customer account creation procedure |

Line 93: | IGS_FI_POSTING_INT_PKG.update_row |

89: | RA_INTERFACE_LINES_ALL when |
90: | source_transaction_type is APPLFEE |
91: | Also added column orig_appl_fee_ref to|
92: | the IGS_FI_POSTING_INT_PKG.insert_row,|
93: | IGS_FI_POSTING_INT_PKG.update_row |
94: | agairola 22-Feb-2002 Added the modifications related to |
95: | Customer Account and also calling the |
96: | customer account creation procedure |
97: |

Line 110: | the IGS_FI_POSTING_INT_PKG.insert_row ,IGS_FI_POSTING_INT_PKG.update_row

106: | to derive customer account details for the local institution
107: | In the procedure transfer_posting added code to copy value of the field
108: | orig_appl_fee_ref to comments field of RA_INTERFACE_LINES_ALL when
109: | source_transaction_type is APPLFEE.Also added column orig_appl_fee_ref to
110: | the IGS_FI_POSTING_INT_PKG.insert_row ,IGS_FI_POSTING_INT_PKG.update_row
111: | jbegum 20 Feb 02 As part of Enh bug #2228910
112: Removed the source_transaction_id column from the IGS_FI_INVLN_INT_PKG.update_row
113: jbegum 16 Feb 02 As part of Enh bug #2222272
114: Set org id of transactions created

Line 142: g_n_posting_control_id igs_fi_posting_int_all.posting_control_id%TYPE;

138:
139: g_interface_attr igs_fi_control.interface_line_attribute%TYPE;
140:
141: -- Global Variable for posting control id
142: g_n_posting_control_id igs_fi_posting_int_all.posting_control_id%TYPE;
143:
144: -- For printing total records processed at end of log file.
145: g_n_rec_processed NUMBER := 0;
146:

Line 148: p_transaction_id IN igs_fi_posting_int_all.source_transaction_id%TYPE,

144: -- For printing total records processed at end of log file.
145: g_n_rec_processed NUMBER := 0;
146:
147: PROCEDURE derive_comments (
148: p_transaction_id IN igs_fi_posting_int_all.source_transaction_id%TYPE,
149: p_transaction_type IN igs_fi_posting_int_all.source_transaction_type%TYPE,
150: p_transaction_number OUT NOCOPY VARCHAR2,
151: p_comments OUT NOCOPY ra_interface_lines_all.comments%TYPE
152: );

Line 149: p_transaction_type IN igs_fi_posting_int_all.source_transaction_type%TYPE,

145: g_n_rec_processed NUMBER := 0;
146:
147: PROCEDURE derive_comments (
148: p_transaction_id IN igs_fi_posting_int_all.source_transaction_id%TYPE,
149: p_transaction_type IN igs_fi_posting_int_all.source_transaction_type%TYPE,
150: p_transaction_number OUT NOCOPY VARCHAR2,
151: p_comments OUT NOCOPY ra_interface_lines_all.comments%TYPE
152: );
153:

Line 250: PROCEDURE update_log_file(p_txn_date IN igs_fi_posting_int.transaction_date%TYPE,

246: fnd_message.get);
247: END IF;
248: END update_log_norec;
249:
250: PROCEDURE update_log_file(p_txn_date IN igs_fi_posting_int.transaction_date%TYPE,
251: p_amount IN igs_fi_posting_int.amount%TYPE,
252: p_txn_id IN igs_fi_posting_int.source_transaction_id%TYPE,
253: p_dr_acc_code IN igs_fi_posting_int.dr_account_cd%TYPE,
254: p_cr_acc_code IN igs_fi_posting_int.cr_account_cd%TYPE,

Line 251: p_amount IN igs_fi_posting_int.amount%TYPE,

247: END IF;
248: END update_log_norec;
249:
250: PROCEDURE update_log_file(p_txn_date IN igs_fi_posting_int.transaction_date%TYPE,
251: p_amount IN igs_fi_posting_int.amount%TYPE,
252: p_txn_id IN igs_fi_posting_int.source_transaction_id%TYPE,
253: p_dr_acc_code IN igs_fi_posting_int.dr_account_cd%TYPE,
254: p_cr_acc_code IN igs_fi_posting_int.cr_account_cd%TYPE,
255: p_src_txn_type IN igs_fi_posting_int.source_transaction_type%TYPE) AS

Line 252: p_txn_id IN igs_fi_posting_int.source_transaction_id%TYPE,

248: END update_log_norec;
249:
250: PROCEDURE update_log_file(p_txn_date IN igs_fi_posting_int.transaction_date%TYPE,
251: p_amount IN igs_fi_posting_int.amount%TYPE,
252: p_txn_id IN igs_fi_posting_int.source_transaction_id%TYPE,
253: p_dr_acc_code IN igs_fi_posting_int.dr_account_cd%TYPE,
254: p_cr_acc_code IN igs_fi_posting_int.cr_account_cd%TYPE,
255: p_src_txn_type IN igs_fi_posting_int.source_transaction_type%TYPE) AS
256:

Line 253: p_dr_acc_code IN igs_fi_posting_int.dr_account_cd%TYPE,

249:
250: PROCEDURE update_log_file(p_txn_date IN igs_fi_posting_int.transaction_date%TYPE,
251: p_amount IN igs_fi_posting_int.amount%TYPE,
252: p_txn_id IN igs_fi_posting_int.source_transaction_id%TYPE,
253: p_dr_acc_code IN igs_fi_posting_int.dr_account_cd%TYPE,
254: p_cr_acc_code IN igs_fi_posting_int.cr_account_cd%TYPE,
255: p_src_txn_type IN igs_fi_posting_int.source_transaction_type%TYPE) AS
256:
257: /******************************************************************

Line 254: p_cr_acc_code IN igs_fi_posting_int.cr_account_cd%TYPE,

250: PROCEDURE update_log_file(p_txn_date IN igs_fi_posting_int.transaction_date%TYPE,
251: p_amount IN igs_fi_posting_int.amount%TYPE,
252: p_txn_id IN igs_fi_posting_int.source_transaction_id%TYPE,
253: p_dr_acc_code IN igs_fi_posting_int.dr_account_cd%TYPE,
254: p_cr_acc_code IN igs_fi_posting_int.cr_account_cd%TYPE,
255: p_src_txn_type IN igs_fi_posting_int.source_transaction_type%TYPE) AS
256:
257: /******************************************************************
258: Created By : agairola

Line 255: p_src_txn_type IN igs_fi_posting_int.source_transaction_type%TYPE) AS

251: p_amount IN igs_fi_posting_int.amount%TYPE,
252: p_txn_id IN igs_fi_posting_int.source_transaction_id%TYPE,
253: p_dr_acc_code IN igs_fi_posting_int.dr_account_cd%TYPE,
254: p_cr_acc_code IN igs_fi_posting_int.cr_account_cd%TYPE,
255: p_src_txn_type IN igs_fi_posting_int.source_transaction_type%TYPE) AS
256:
257: /******************************************************************
258: Created By : agairola
259: Date Created By : 10-Apr-2002

Line 313: p_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,

309: fnd_file.new_line(fnd_file.log);
310: END update_log_file;
311:
312: PROCEDURE transfer_credit_act_txns(
313: p_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
314: p_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE,
315: p_d_gl_posted_date IN igs_fi_posting_int_all.accounting_date%TYPE
316: ) AS
317: /*

Line 314: p_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE,

310: END update_log_file;
311:
312: PROCEDURE transfer_credit_act_txns(
313: p_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
314: p_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE,
315: p_d_gl_posted_date IN igs_fi_posting_int_all.accounting_date%TYPE
316: ) AS
317: /*
318: || Created By : brajendr

Line 315: p_d_gl_posted_date IN igs_fi_posting_int_all.accounting_date%TYPE

311:
312: PROCEDURE transfer_credit_act_txns(
313: p_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
314: p_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE,
315: p_d_gl_posted_date IN igs_fi_posting_int_all.accounting_date%TYPE
316: ) AS
317: /*
318: || Created By : brajendr
319: || Created On : 24-Apr-2001

Line 324: || abshriva 12-May-2006 Enh#5217319 Precision Issue. Amount values being inserted into igs_fi_posting_int

320: || Purpose :
321: || Known limitations, enhancements or remarks :
322: || Change History :
323: || Who When What
324: || abshriva 12-May-2006 Enh#5217319 Precision Issue. Amount values being inserted into igs_fi_posting_int
325: || is now rounded off to currency precision
326: || shtatiko 09-Dec-2002 Modified to cursor to include conditions for dr_account_cd and cr_account_cd.
327: || ( BUG# 2584741 )
328: || Sykrishn 01-NOV/2002 Gl Interface TD modifications...

Line 337: || IGS_FI_POSTING_INT_PKG.insert_row

333: || no records being found and also for the common procedure
334: || for logging messages for bugs 2326595, 2309929, 2310806
335: || jbegum 25 Feb 02 As part of Enh bug # 2238226
336: || Added column orig_appl_fee_ref to the
337: || IGS_FI_POSTING_INT_PKG.insert_row
338: || (reverse chronological order - newest change first)
339: */
340:
341: -- Get all the credit activity records, where GL_DATE lies b/w the passed date ranges that are yet to be posted.

Line 345: CURSOR cur_credit_activities(cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,

341: -- Get all the credit activity records, where GL_DATE lies b/w the passed date ranges that are yet to be posted.
342:
343: -- Cursor is modified to include the check of credit and debit account codes
344: -- by shtatiko as part of Enh Bug# 2584741.
345: CURSOR cur_credit_activities(cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
346: cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS
347:
348: SELECT crac.rowid row_id, crac.*
349: FROM igs_fi_cr_activities crac

Line 346: cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS

342:
343: -- Cursor is modified to include the check of credit and debit account codes
344: -- by shtatiko as part of Enh Bug# 2584741.
345: CURSOR cur_credit_activities(cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
346: cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS
347:
348: SELECT crac.rowid row_id, crac.*
349: FROM igs_fi_cr_activities crac
350: WHERE crac.gl_date IS NOT NULL

Line 374: l_n_posting_id igs_fi_posting_int.posting_id%TYPE;

370: l_v_dr_account_cd igs_fi_cr_activities.dr_account_cd%TYPE;
371: l_n_amount igs_fi_cr_activities.amount%TYPE;
372:
373: l_v_posting_rowid ROWID;
374: l_n_posting_id igs_fi_posting_int.posting_id%TYPE;
375:
376: BEGIN
377:
378: FOR cr_act_rec IN cur_credit_activities( p_d_gl_date_start, p_d_gl_date_end) LOOP

Line 407: igs_fi_posting_int_pkg.insert_row (

403: l_n_posting_id := NULL;
404:
405: BEGIN
406: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision
407: igs_fi_posting_int_pkg.insert_row (
408: x_rowid => l_v_posting_rowid,
409: x_posting_control_id => g_n_posting_control_id,
410: x_posting_id => l_n_posting_id,
411: x_batch_name => NULL,

Line 479: fnd_message.set_token('NAME','IGS_FI_POSTING_INTERFACE.TRANSFER_CREDIT_ACT_TXNS');

475: EXCEPTION
476: WHEN OTHERS THEN
477: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXP');
478: --Unhandled Exception Raised in Procedure NAME
479: fnd_message.set_token('NAME','IGS_FI_POSTING_INTERFACE.TRANSFER_CREDIT_ACT_TXNS');
480: fnd_file.put_line( fnd_file.log, fnd_message.get() || sqlerrm);
481: app_exception.raise_exception;
482: END transfer_credit_act_txns;
483:

Line 486: p_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,

482: END transfer_credit_act_txns;
483:
484:
485: PROCEDURE transfer_appl_txns(
486: p_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
487: p_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE,
488: p_d_gl_posted_date IN igs_fi_posting_int_all.accounting_date%TYPE
489: ) AS
490: /*

Line 487: p_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE,

483:
484:
485: PROCEDURE transfer_appl_txns(
486: p_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
487: p_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE,
488: p_d_gl_posted_date IN igs_fi_posting_int_all.accounting_date%TYPE
489: ) AS
490: /*
491: || Created By : brajendr

Line 488: p_d_gl_posted_date IN igs_fi_posting_int_all.accounting_date%TYPE

484:
485: PROCEDURE transfer_appl_txns(
486: p_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
487: p_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE,
488: p_d_gl_posted_date IN igs_fi_posting_int_all.accounting_date%TYPE
489: ) AS
490: /*
491: || Created By : brajendr
492: || Created On : 24-Apr-2001

Line 497: || abshriva 12-May-2006 Enh#5217319 Precision Issue. Amount values being inserted into igs_fi_posting_int

493: || Purpose :
494: || Known limitations, enhancements or remarks :
495: || Change History :
496: || Who When What
497: || abshriva 12-May-2006 Enh#5217319 Precision Issue. Amount values being inserted into igs_fi_posting_int
498: || is now rounded off to currency precision
499: || Sykrishn 01-NOV/2002 Gl Interface TD modifications...
500: || The below history is nt valid as the local procedure is revamped completely
501: || agairola 21 Apr 2002 Initialised the lrec_posting_int

Line 508: || IGS_FI_POSTING_INT_PKG.insert_row

504: || no records being found and also for the common procedure
505: || for logging messages for bugs 2326595, 2309929, 2310806
506: || jbegum 25 Feb 02 As part of Enh bug # 2238226
507: || Added column orig_appl_fee_ref to the
508: || IGS_FI_POSTING_INT_PKG.insert_row
509: || (reverse chronological order - newest change first)
510: */
511:
512: -- Get all the credit activity records, where GL_DATE lies b/w the passedg date ranges that have not been posted.

Line 514: CURSOR cur_appl (cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,

510: */
511:
512: -- Get all the credit activity records, where GL_DATE lies b/w the passedg date ranges that have not been posted.
513:
514: CURSOR cur_appl (cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
515: cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS
516:
517: SELECT appl.rowid row_id, appl.*
518: FROM igs_fi_applications appl

Line 515: cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS

511:
512: -- Get all the credit activity records, where GL_DATE lies b/w the passedg date ranges that have not been posted.
513:
514: CURSOR cur_appl (cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
515: cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS
516:
517: SELECT appl.rowid row_id, appl.*
518: FROM igs_fi_applications appl
519: WHERE appl.gl_date IS NOT NULL

Line 540: l_n_posting_id igs_fi_posting_int.posting_id%TYPE;

536: l_v_cr_account_cd igs_fi_applications.cr_account_cd%TYPE;
537: l_v_dr_account_cd igs_fi_applications.dr_account_cd%TYPE;
538: l_n_amount igs_fi_applications.amount_applied%TYPE;
539: l_v_posting_rowid ROWID;
540: l_n_posting_id igs_fi_posting_int.posting_id%TYPE;
541: l_v_currency_cd igs_fi_credits.currency_cd%TYPE;
542:
543: BEGIN
544:

Line 572: igs_fi_posting_int_pkg.insert_row (

568: l_v_posting_rowid := NULL;
569: l_n_posting_id := NULL;
570: BEGIN
571: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision
572: igs_fi_posting_int_pkg.insert_row (
573: x_rowid => l_v_posting_rowid,
574: x_posting_control_id => g_n_posting_control_id,
575: x_posting_id => l_n_posting_id,
576: x_batch_name => NULL,

Line 645: fnd_message.set_token('NAME','IGS_FI_POSTING_INTERFACE.TRANSFER_APPL_TXNS');

641: EXCEPTION
642: WHEN OTHERS THEN
643: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXP');
644: --Unhandled Exception Raised in Procedure NAME
645: fnd_message.set_token('NAME','IGS_FI_POSTING_INTERFACE.TRANSFER_APPL_TXNS');
646: fnd_file.put_line( fnd_file.log, fnd_message.get() || sqlerrm);
647: app_exception.raise_exception;
648:
649: END transfer_appl_txns;

Line 653: p_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,

649: END transfer_appl_txns;
650:
651:
652: PROCEDURE transfer_chgs_txns(
653: p_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
654: p_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE,
655: p_d_gl_posted_date IN igs_fi_posting_int_all.accounting_date%TYPE
656: ) AS
657: /*

Line 654: p_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE,

650:
651:
652: PROCEDURE transfer_chgs_txns(
653: p_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
654: p_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE,
655: p_d_gl_posted_date IN igs_fi_posting_int_all.accounting_date%TYPE
656: ) AS
657: /*
658: || Created By : brajendr

Line 655: p_d_gl_posted_date IN igs_fi_posting_int_all.accounting_date%TYPE

651:
652: PROCEDURE transfer_chgs_txns(
653: p_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
654: p_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE,
655: p_d_gl_posted_date IN igs_fi_posting_int_all.accounting_date%TYPE
656: ) AS
657: /*
658: || Created By : brajendr
659: || Created On : 24-Apr-2001

Line 664: || abshriva 12-May-2006 Enh#5217319 Precision Issue. Amount values being inserted into igs_fi_posting_int

660: || Purpose :
661: || Known limitations, enhancements or remarks :
662: || Change History :
663: || Who When What
664: || abshriva 12-May-2006 Enh#5217319 Precision Issue. Amount values being inserted into igs_fi_posting_int
665: || and igs_fi_invln_int is now rounded off to currency precision
666: || svuppala 30-MAY-2005 Enh 3442712 - Done the TBH modifications by adding
667: || new columns Unit_Type_Id, Unit_Level in igs_fi_invln_int_all
668: || Sykrishn 01-NOV/2002 Gl Interface TD modifications...

Line 677: || IGS_FI_POSTING_INT_PKG.insert_row

673: || no records being found and also for the common procedure
674: || for logging messages for bugs 2326595, 2309929, 2310806
675: || jbegum 25 Feb 02 As part of Enh bug # 2238226
676: || Added column orig_appl_fee_ref to the
677: || IGS_FI_POSTING_INT_PKG.insert_row
678: || (reverse chronological order - newest change first)
679: */
680:
681: -- Get all the invoice lines records, where GL_DATE lies b/w the passedg date ranges that have not been posted.

Line 683: CURSOR cur_inv (cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,

679: */
680:
681: -- Get all the invoice lines records, where GL_DATE lies b/w the passedg date ranges that have not been posted.
682:
683: CURSOR cur_inv (cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
684: cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS
685: SELECT invln.rowid row_id, inv.invoice_creation_date, inv.currency_cd, invln.*
686: FROM igs_fi_invln_int_all invln,
687: igs_fi_inv_int_all inv

Line 684: cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS

680:
681: -- Get all the invoice lines records, where GL_DATE lies b/w the passedg date ranges that have not been posted.
682:
683: CURSOR cur_inv (cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
684: cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS
685: SELECT invln.rowid row_id, inv.invoice_creation_date, inv.currency_cd, invln.*
686: FROM igs_fi_invln_int_all invln,
687: igs_fi_inv_int_all inv
688: WHERE invln.gl_date IS NOT NULL

Line 705: l_n_posting_id igs_fi_posting_int.posting_id%TYPE;

701: l_v_cr_account_cd igs_fi_invln_int_all.rev_account_cd%TYPE;
702: l_v_dr_account_cd igs_fi_invln_int_all.rec_account_cd%TYPE;
703: l_n_amount igs_fi_invln_int_all.amount%TYPE;
704: l_v_posting_rowid ROWID;
705: l_n_posting_id igs_fi_posting_int.posting_id%TYPE;
706:
707: BEGIN
708:
709:

Line 732: igs_fi_posting_int_pkg.insert_row (

728: l_v_posting_rowid := NULL;
729: l_n_posting_id := NULL;
730: BEGIN
731: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision
732: igs_fi_posting_int_pkg.insert_row (
733: x_rowid => l_v_posting_rowid,
734: x_posting_control_id => g_n_posting_control_id,
735: x_posting_id => l_n_posting_id,
736: x_batch_name => NULL,

Line 835: fnd_message.set_token('NAME','IGS_FI_POSTING_INTERFACE.TRANSFER_CHGS_TXNS');

831: EXCEPTION
832: WHEN OTHERS THEN
833: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXP');
834: --Unhandled Exception Raised in Procedure NAME
835: fnd_message.set_token('NAME','IGS_FI_POSTING_INTERFACE.TRANSFER_CHGS_TXNS');
836: fnd_file.put_line( fnd_file.log, fnd_message.get() || sqlerrm);
837: app_exception.raise_exception;
838: END transfer_chgs_txns;
839:

Line 841: p_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,

837: app_exception.raise_exception;
838: END transfer_chgs_txns;
839:
840: PROCEDURE transfer_ad_appl_fee_txns(
841: p_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
842: p_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE,
843: p_d_gl_posted_date IN igs_fi_posting_int_all.accounting_date%TYPE
844: ) AS
845: /*

Line 842: p_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE,

838: END transfer_chgs_txns;
839:
840: PROCEDURE transfer_ad_appl_fee_txns(
841: p_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
842: p_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE,
843: p_d_gl_posted_date IN igs_fi_posting_int_all.accounting_date%TYPE
844: ) AS
845: /*
846: || Created By : SYKRISHN

Line 843: p_d_gl_posted_date IN igs_fi_posting_int_all.accounting_date%TYPE

839:
840: PROCEDURE transfer_ad_appl_fee_txns(
841: p_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
842: p_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE,
843: p_d_gl_posted_date IN igs_fi_posting_int_all.accounting_date%TYPE
844: ) AS
845: /*
846: || Created By : SYKRISHN
847: || Created On : 01-NOV/2002

Line 852: || abshriva 12-May-2006 Enh#5217319 Precision Issue. Amount values being inserted into igs_fi_posting_int

848: || Purpose :
849: || Known limitations, enhancements or remarks :
850: || Change History :
851: || Who When What
852: || abshriva 12-May-2006 Enh#5217319 Precision Issue. Amount values being inserted into igs_fi_posting_int
853: || is now rounded off to currency precision
854: || vvutukur 09-Oct-2003 Bug#3160036.Replaced call to igs_ad_app_req.update_row with
855: || call to igs_ad_gen_015.update_igs_ad_app_req.
856: || pathipat 14-Jun-2003 Enh 2831587 Credit Card Fund Transfer build

Line 867: CURSOR cur_adm_fee (cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,

863: -- Only posting control id needs to be checked in this case
864:
865:
866:
867: CURSOR cur_adm_fee (cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
868: cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS
869: SELECT adm.rowid row_id,adm.*
870: FROM igs_ad_app_req adm
871: WHERE adm.gl_date IS NOT NULL

Line 868: cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS

864:
865:
866:
867: CURSOR cur_adm_fee (cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
868: cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS
869: SELECT adm.rowid row_id,adm.*
870: FROM igs_ad_app_req adm
871: WHERE adm.gl_date IS NOT NULL
872: AND TRUNC(adm.gl_date) BETWEEN TRUNC(cp_d_gl_date_start) AND TRUNC(cp_d_gl_date_end)

Line 888: l_n_posting_id igs_fi_posting_int.posting_id%TYPE;

884: AND admission_appl_number = cp_admission_appl_number;
885:
886: l_b_exception_flag BOOLEAN := FALSE;
887: l_v_posting_rowid ROWID;
888: l_n_posting_id igs_fi_posting_int.posting_id%TYPE;
889: l_v_currency_cd igs_fi_control_all.currency_cd%TYPE := igs_fi_gen_gl.finp_ss_get_cur;
890: l_v_orig_appl_fee_ref igs_fi_posting_int_all.orig_appl_fee_ref%TYPE;
891: l_n_application_id igs_ad_appl.application_id%TYPE;
892:

Line 890: l_v_orig_appl_fee_ref igs_fi_posting_int_all.orig_appl_fee_ref%TYPE;

886: l_b_exception_flag BOOLEAN := FALSE;
887: l_v_posting_rowid ROWID;
888: l_n_posting_id igs_fi_posting_int.posting_id%TYPE;
889: l_v_currency_cd igs_fi_control_all.currency_cd%TYPE := igs_fi_gen_gl.finp_ss_get_cur;
890: l_v_orig_appl_fee_ref igs_fi_posting_int_all.orig_appl_fee_ref%TYPE;
891: l_n_application_id igs_ad_appl.application_id%TYPE;
892:
893: BEGIN
894:

Line 912: igs_fi_posting_int_pkg.insert_row (

908: l_v_posting_rowid := NULL;
909: l_n_posting_id := NULL;
910: BEGIN
911: -- Call to igs_fi_gen_gl.get_formatted_amount formats fee_amount by rounding off to currency precision
912: igs_fi_posting_int_pkg.insert_row (
913: x_rowid => l_v_posting_rowid,
914: x_posting_control_id => g_n_posting_control_id,
915: x_posting_id => l_n_posting_id,
916: x_batch_name => NULL,

Line 992: fnd_message.set_token('NAME','IGS_FI_POSTING_INTERFACE.TRANSFER_AD_APPL_FEE_TXNS');

988: EXCEPTION
989: WHEN OTHERS THEN
990: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXP');
991: --Unhandled Exception Raised in Procedure NAME
992: fnd_message.set_token('NAME','IGS_FI_POSTING_INTERFACE.TRANSFER_AD_APPL_FEE_TXNS');
993: fnd_file.put_line( fnd_file.log, fnd_message.get() || sqlerrm);
994: app_exception.raise_exception;
995: END transfer_ad_appl_fee_txns;
996:

Line 999: p_transaction_id IN igs_fi_posting_int_all.source_transaction_id%TYPE,

995: END transfer_ad_appl_fee_txns;
996:
997:
998: PROCEDURE derive_comments (
999: p_transaction_id IN igs_fi_posting_int_all.source_transaction_id%TYPE,
1000: p_transaction_type IN igs_fi_posting_int_all.source_transaction_type%TYPE,
1001: p_transaction_number OUT NOCOPY VARCHAR2,
1002: p_comments OUT NOCOPY ra_interface_lines_all.comments%TYPE
1003: ) AS

Line 1000: p_transaction_type IN igs_fi_posting_int_all.source_transaction_type%TYPE,

996:
997:
998: PROCEDURE derive_comments (
999: p_transaction_id IN igs_fi_posting_int_all.source_transaction_id%TYPE,
1000: p_transaction_type IN igs_fi_posting_int_all.source_transaction_type%TYPE,
1001: p_transaction_number OUT NOCOPY VARCHAR2,
1002: p_comments OUT NOCOPY ra_interface_lines_all.comments%TYPE
1003: ) AS
1004: /*

Line 1020: CURSOR cur_charge (cp_transaction_id IN igs_fi_posting_int_all.source_transaction_id%TYPE) IS

1016: || (reverse chronological order - newest change first)
1017: */
1018:
1019: --Cursor to fetch the invoice number for the passed invoice_id
1020: CURSOR cur_charge (cp_transaction_id IN igs_fi_posting_int_all.source_transaction_id%TYPE) IS
1021: SELECT inv.invoice_number
1022: FROM igs_fi_inv_int inv, igs_fi_invln_int invln
1023: WHERE invln.invoice_lines_id = cp_transaction_id
1024: AND inv.invoice_id = invln.invoice_id;

Line 1027: CURSOR cur_credit(cp_transaction_id IN igs_fi_posting_int_all.source_transaction_id%TYPE) IS

1023: WHERE invln.invoice_lines_id = cp_transaction_id
1024: AND inv.invoice_id = invln.invoice_id;
1025:
1026: --Cursor to fetch the credit number for the passed credit_id
1027: CURSOR cur_credit(cp_transaction_id IN igs_fi_posting_int_all.source_transaction_id%TYPE) IS
1028: SELECT crd.credit_number
1029: FROM igs_fi_credits crd,
1030: igs_fi_cr_activities cra
1031: WHERE cra.credit_activity_id = cp_transaction_id

Line 1035: CURSOR cur_appl(cp_transaction_id IN igs_fi_posting_int_all.source_transaction_id%TYPE) IS

1031: WHERE cra.credit_activity_id = cp_transaction_id
1032: AND crd.credit_id = cra.credit_id;
1033:
1034: --Cursor to fetch the credit id and invoice id for the passed application id
1035: CURSOR cur_appl(cp_transaction_id IN igs_fi_posting_int_all.source_transaction_id%TYPE) IS
1036: SELECT crd.credit_number,
1037: inv.invoice_number
1038: FROM igs_fi_applications app,
1039: igs_fi_credits crd,

Line 1143: p_batch_name IN igs_fi_posting_int_all.batch_name%TYPE,

1139:
1140: PROCEDURE transfer_posting(
1141: ERRBUF OUT NOCOPY VARCHAR2,
1142: RETCODE OUT NOCOPY NUMBER,
1143: p_batch_name IN igs_fi_posting_int_all.batch_name%TYPE,
1144: p_posting_date_low IN VARCHAR2,
1145: p_posting_date_high IN VARCHAR2,
1146: p_org_id IN igs_fi_posting_int_all.org_id%TYPE
1147: ) AS

Line 1146: p_org_id IN igs_fi_posting_int_all.org_id%TYPE

1142: RETCODE OUT NOCOPY NUMBER,
1143: p_batch_name IN igs_fi_posting_int_all.batch_name%TYPE,
1144: p_posting_date_low IN VARCHAR2,
1145: p_posting_date_high IN VARCHAR2,
1146: p_org_id IN igs_fi_posting_int_all.org_id%TYPE
1147: ) AS
1148: /*
1149: || Created By : brajendr
1150: || Created On : 24-Apr-2001

Line 1178: || IGS_FI_POSTING_INT_PKG.update_row

1174: || Added code to copy value of the field orig_appl_fee_ref to
1175: || comments field of RA_INTERFACE_LINES_ALL when
1176: || source_transaction_type is APPLFEE
1177: || Added column orig_appl_fee_ref to the
1178: || IGS_FI_POSTING_INT_PKG.update_row
1179: || sykrishn 19 Feb 02 As part of Enh bug #2227831
1180: || Changes related to get_customer_details
1181: || jbegum 16 Feb 02 As part of Enh bug #2222272
1182: || Set org id of transactions created