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.IGI_ITR_GL_INTERFACE_PKG dependencies on GL_INTERFACE

Line 1: PACKAGE BODY IGI_ITR_GL_INTERFACE_PKG AS

1: PACKAGE BODY IGI_ITR_GL_INTERFACE_PKG AS
2: -- $Header: igiitrpb.pls 120.10.12020000.1 2012/06/27 10:56:36 appldev ship $
3: Cursor C_period(
4: p_set_of_books_id IN igi_itr_charge_headers.set_of_books_id%type,
5: p_period_name IN igi_itr_charge_headers.it_period_name%type) IS

Line 115: Procedure Gl_Interface_Insert(

111: null;
112: End if;
113: End Writelog;
114:
115: Procedure Gl_Interface_Insert(
116: p_status IN gl_interface.status%type,
117: p_set_of_books_id IN gl_interface.set_of_books_id%type,
118: p_accounting_date IN gl_interface.accounting_date%type,
119: p_currency_code IN gl_interface.currency_code%type,

Line 116: p_status IN gl_interface.status%type,

112: End if;
113: End Writelog;
114:
115: Procedure Gl_Interface_Insert(
116: p_status IN gl_interface.status%type,
117: p_set_of_books_id IN gl_interface.set_of_books_id%type,
118: p_accounting_date IN gl_interface.accounting_date%type,
119: p_currency_code IN gl_interface.currency_code%type,
120: p_date_created IN gl_interface.date_created%type,

Line 117: p_set_of_books_id IN gl_interface.set_of_books_id%type,

113: End Writelog;
114:
115: Procedure Gl_Interface_Insert(
116: p_status IN gl_interface.status%type,
117: p_set_of_books_id IN gl_interface.set_of_books_id%type,
118: p_accounting_date IN gl_interface.accounting_date%type,
119: p_currency_code IN gl_interface.currency_code%type,
120: p_date_created IN gl_interface.date_created%type,
121: p_created_by IN gl_interface.created_by%type,

Line 118: p_accounting_date IN gl_interface.accounting_date%type,

114:
115: Procedure Gl_Interface_Insert(
116: p_status IN gl_interface.status%type,
117: p_set_of_books_id IN gl_interface.set_of_books_id%type,
118: p_accounting_date IN gl_interface.accounting_date%type,
119: p_currency_code IN gl_interface.currency_code%type,
120: p_date_created IN gl_interface.date_created%type,
121: p_created_by IN gl_interface.created_by%type,
122: p_actual_flag IN gl_interface.actual_flag%type,

Line 119: p_currency_code IN gl_interface.currency_code%type,

115: Procedure Gl_Interface_Insert(
116: p_status IN gl_interface.status%type,
117: p_set_of_books_id IN gl_interface.set_of_books_id%type,
118: p_accounting_date IN gl_interface.accounting_date%type,
119: p_currency_code IN gl_interface.currency_code%type,
120: p_date_created IN gl_interface.date_created%type,
121: p_created_by IN gl_interface.created_by%type,
122: p_actual_flag IN gl_interface.actual_flag%type,
123: p_user_je_category_name IN gl_interface.user_je_category_name%type,

Line 120: p_date_created IN gl_interface.date_created%type,

116: p_status IN gl_interface.status%type,
117: p_set_of_books_id IN gl_interface.set_of_books_id%type,
118: p_accounting_date IN gl_interface.accounting_date%type,
119: p_currency_code IN gl_interface.currency_code%type,
120: p_date_created IN gl_interface.date_created%type,
121: p_created_by IN gl_interface.created_by%type,
122: p_actual_flag IN gl_interface.actual_flag%type,
123: p_user_je_category_name IN gl_interface.user_je_category_name%type,
124: p_user_je_source_name IN gl_interface.user_je_source_name%type,

Line 121: p_created_by IN gl_interface.created_by%type,

117: p_set_of_books_id IN gl_interface.set_of_books_id%type,
118: p_accounting_date IN gl_interface.accounting_date%type,
119: p_currency_code IN gl_interface.currency_code%type,
120: p_date_created IN gl_interface.date_created%type,
121: p_created_by IN gl_interface.created_by%type,
122: p_actual_flag IN gl_interface.actual_flag%type,
123: p_user_je_category_name IN gl_interface.user_je_category_name%type,
124: p_user_je_source_name IN gl_interface.user_je_source_name%type,
125: p_entered_dr IN gl_interface.entered_dr%type,

Line 122: p_actual_flag IN gl_interface.actual_flag%type,

118: p_accounting_date IN gl_interface.accounting_date%type,
119: p_currency_code IN gl_interface.currency_code%type,
120: p_date_created IN gl_interface.date_created%type,
121: p_created_by IN gl_interface.created_by%type,
122: p_actual_flag IN gl_interface.actual_flag%type,
123: p_user_je_category_name IN gl_interface.user_je_category_name%type,
124: p_user_je_source_name IN gl_interface.user_je_source_name%type,
125: p_entered_dr IN gl_interface.entered_dr%type,
126: p_entered_cr IN gl_interface.entered_cr%type,

Line 123: p_user_je_category_name IN gl_interface.user_je_category_name%type,

119: p_currency_code IN gl_interface.currency_code%type,
120: p_date_created IN gl_interface.date_created%type,
121: p_created_by IN gl_interface.created_by%type,
122: p_actual_flag IN gl_interface.actual_flag%type,
123: p_user_je_category_name IN gl_interface.user_je_category_name%type,
124: p_user_je_source_name IN gl_interface.user_je_source_name%type,
125: p_entered_dr IN gl_interface.entered_dr%type,
126: p_entered_cr IN gl_interface.entered_cr%type,
127: p_accounted_dr IN gl_interface.accounted_dr%type,

Line 124: p_user_je_source_name IN gl_interface.user_je_source_name%type,

120: p_date_created IN gl_interface.date_created%type,
121: p_created_by IN gl_interface.created_by%type,
122: p_actual_flag IN gl_interface.actual_flag%type,
123: p_user_je_category_name IN gl_interface.user_je_category_name%type,
124: p_user_je_source_name IN gl_interface.user_je_source_name%type,
125: p_entered_dr IN gl_interface.entered_dr%type,
126: p_entered_cr IN gl_interface.entered_cr%type,
127: p_accounted_dr IN gl_interface.accounted_dr%type,
128: p_accounted_cr IN gl_interface.accounted_cr%type,

Line 125: p_entered_dr IN gl_interface.entered_dr%type,

121: p_created_by IN gl_interface.created_by%type,
122: p_actual_flag IN gl_interface.actual_flag%type,
123: p_user_je_category_name IN gl_interface.user_je_category_name%type,
124: p_user_je_source_name IN gl_interface.user_je_source_name%type,
125: p_entered_dr IN gl_interface.entered_dr%type,
126: p_entered_cr IN gl_interface.entered_cr%type,
127: p_accounted_dr IN gl_interface.accounted_dr%type,
128: p_accounted_cr IN gl_interface.accounted_cr%type,
129: p_transaction_date IN gl_interface.transaction_date%type,

Line 126: p_entered_cr IN gl_interface.entered_cr%type,

122: p_actual_flag IN gl_interface.actual_flag%type,
123: p_user_je_category_name IN gl_interface.user_je_category_name%type,
124: p_user_je_source_name IN gl_interface.user_je_source_name%type,
125: p_entered_dr IN gl_interface.entered_dr%type,
126: p_entered_cr IN gl_interface.entered_cr%type,
127: p_accounted_dr IN gl_interface.accounted_dr%type,
128: p_accounted_cr IN gl_interface.accounted_cr%type,
129: p_transaction_date IN gl_interface.transaction_date%type,
130: p_reference1 IN gl_interface.reference1%type,

Line 127: p_accounted_dr IN gl_interface.accounted_dr%type,

123: p_user_je_category_name IN gl_interface.user_je_category_name%type,
124: p_user_je_source_name IN gl_interface.user_je_source_name%type,
125: p_entered_dr IN gl_interface.entered_dr%type,
126: p_entered_cr IN gl_interface.entered_cr%type,
127: p_accounted_dr IN gl_interface.accounted_dr%type,
128: p_accounted_cr IN gl_interface.accounted_cr%type,
129: p_transaction_date IN gl_interface.transaction_date%type,
130: p_reference1 IN gl_interface.reference1%type,
131: p_reference4 IN gl_interface.reference4%type,

Line 128: p_accounted_cr IN gl_interface.accounted_cr%type,

124: p_user_je_source_name IN gl_interface.user_je_source_name%type,
125: p_entered_dr IN gl_interface.entered_dr%type,
126: p_entered_cr IN gl_interface.entered_cr%type,
127: p_accounted_dr IN gl_interface.accounted_dr%type,
128: p_accounted_cr IN gl_interface.accounted_cr%type,
129: p_transaction_date IN gl_interface.transaction_date%type,
130: p_reference1 IN gl_interface.reference1%type,
131: p_reference4 IN gl_interface.reference4%type,
132: p_reference6 IN gl_interface.reference6%type,

Line 129: p_transaction_date IN gl_interface.transaction_date%type,

125: p_entered_dr IN gl_interface.entered_dr%type,
126: p_entered_cr IN gl_interface.entered_cr%type,
127: p_accounted_dr IN gl_interface.accounted_dr%type,
128: p_accounted_cr IN gl_interface.accounted_cr%type,
129: p_transaction_date IN gl_interface.transaction_date%type,
130: p_reference1 IN gl_interface.reference1%type,
131: p_reference4 IN gl_interface.reference4%type,
132: p_reference6 IN gl_interface.reference6%type,
133: p_reference10 IN gl_interface.reference10%type,

Line 130: p_reference1 IN gl_interface.reference1%type,

126: p_entered_cr IN gl_interface.entered_cr%type,
127: p_accounted_dr IN gl_interface.accounted_dr%type,
128: p_accounted_cr IN gl_interface.accounted_cr%type,
129: p_transaction_date IN gl_interface.transaction_date%type,
130: p_reference1 IN gl_interface.reference1%type,
131: p_reference4 IN gl_interface.reference4%type,
132: p_reference6 IN gl_interface.reference6%type,
133: p_reference10 IN gl_interface.reference10%type,
134: p_reference21 IN gl_interface.reference21%type,

Line 131: p_reference4 IN gl_interface.reference4%type,

127: p_accounted_dr IN gl_interface.accounted_dr%type,
128: p_accounted_cr IN gl_interface.accounted_cr%type,
129: p_transaction_date IN gl_interface.transaction_date%type,
130: p_reference1 IN gl_interface.reference1%type,
131: p_reference4 IN gl_interface.reference4%type,
132: p_reference6 IN gl_interface.reference6%type,
133: p_reference10 IN gl_interface.reference10%type,
134: p_reference21 IN gl_interface.reference21%type,
135: p_reference22 IN gl_interface.reference22%type,

Line 132: p_reference6 IN gl_interface.reference6%type,

128: p_accounted_cr IN gl_interface.accounted_cr%type,
129: p_transaction_date IN gl_interface.transaction_date%type,
130: p_reference1 IN gl_interface.reference1%type,
131: p_reference4 IN gl_interface.reference4%type,
132: p_reference6 IN gl_interface.reference6%type,
133: p_reference10 IN gl_interface.reference10%type,
134: p_reference21 IN gl_interface.reference21%type,
135: p_reference22 IN gl_interface.reference22%type,
136: p_period_name IN gl_interface.period_name%type,

Line 133: p_reference10 IN gl_interface.reference10%type,

129: p_transaction_date IN gl_interface.transaction_date%type,
130: p_reference1 IN gl_interface.reference1%type,
131: p_reference4 IN gl_interface.reference4%type,
132: p_reference6 IN gl_interface.reference6%type,
133: p_reference10 IN gl_interface.reference10%type,
134: p_reference21 IN gl_interface.reference21%type,
135: p_reference22 IN gl_interface.reference22%type,
136: p_period_name IN gl_interface.period_name%type,
137: p_chart_of_accounts_id IN gl_interface.chart_of_accounts_id%type,

Line 134: p_reference21 IN gl_interface.reference21%type,

130: p_reference1 IN gl_interface.reference1%type,
131: p_reference4 IN gl_interface.reference4%type,
132: p_reference6 IN gl_interface.reference6%type,
133: p_reference10 IN gl_interface.reference10%type,
134: p_reference21 IN gl_interface.reference21%type,
135: p_reference22 IN gl_interface.reference22%type,
136: p_period_name IN gl_interface.period_name%type,
137: p_chart_of_accounts_id IN gl_interface.chart_of_accounts_id%type,
138: p_functional_currency_code IN gl_interface.functional_currency_code%type,

Line 135: p_reference22 IN gl_interface.reference22%type,

131: p_reference4 IN gl_interface.reference4%type,
132: p_reference6 IN gl_interface.reference6%type,
133: p_reference10 IN gl_interface.reference10%type,
134: p_reference21 IN gl_interface.reference21%type,
135: p_reference22 IN gl_interface.reference22%type,
136: p_period_name IN gl_interface.period_name%type,
137: p_chart_of_accounts_id IN gl_interface.chart_of_accounts_id%type,
138: p_functional_currency_code IN gl_interface.functional_currency_code%type,
139: p_code_combination_id IN gl_interface.code_combination_id%type,

Line 136: p_period_name IN gl_interface.period_name%type,

132: p_reference6 IN gl_interface.reference6%type,
133: p_reference10 IN gl_interface.reference10%type,
134: p_reference21 IN gl_interface.reference21%type,
135: p_reference22 IN gl_interface.reference22%type,
136: p_period_name IN gl_interface.period_name%type,
137: p_chart_of_accounts_id IN gl_interface.chart_of_accounts_id%type,
138: p_functional_currency_code IN gl_interface.functional_currency_code%type,
139: p_code_combination_id IN gl_interface.code_combination_id%type,
140: p_group_id IN gl_interface.group_id%type);

Line 137: p_chart_of_accounts_id IN gl_interface.chart_of_accounts_id%type,

133: p_reference10 IN gl_interface.reference10%type,
134: p_reference21 IN gl_interface.reference21%type,
135: p_reference22 IN gl_interface.reference22%type,
136: p_period_name IN gl_interface.period_name%type,
137: p_chart_of_accounts_id IN gl_interface.chart_of_accounts_id%type,
138: p_functional_currency_code IN gl_interface.functional_currency_code%type,
139: p_code_combination_id IN gl_interface.code_combination_id%type,
140: p_group_id IN gl_interface.group_id%type);
141:

Line 138: p_functional_currency_code IN gl_interface.functional_currency_code%type,

134: p_reference21 IN gl_interface.reference21%type,
135: p_reference22 IN gl_interface.reference22%type,
136: p_period_name IN gl_interface.period_name%type,
137: p_chart_of_accounts_id IN gl_interface.chart_of_accounts_id%type,
138: p_functional_currency_code IN gl_interface.functional_currency_code%type,
139: p_code_combination_id IN gl_interface.code_combination_id%type,
140: p_group_id IN gl_interface.group_id%type);
141:
142: PROCEDURE Init_Gl_Interface(

Line 139: p_code_combination_id IN gl_interface.code_combination_id%type,

135: p_reference22 IN gl_interface.reference22%type,
136: p_period_name IN gl_interface.period_name%type,
137: p_chart_of_accounts_id IN gl_interface.chart_of_accounts_id%type,
138: p_functional_currency_code IN gl_interface.functional_currency_code%type,
139: p_code_combination_id IN gl_interface.code_combination_id%type,
140: p_group_id IN gl_interface.group_id%type);
141:
142: PROCEDURE Init_Gl_Interface(
143: p_int_control IN OUT NOCOPY glcontrol,

Line 140: p_group_id IN gl_interface.group_id%type);

136: p_period_name IN gl_interface.period_name%type,
137: p_chart_of_accounts_id IN gl_interface.chart_of_accounts_id%type,
138: p_functional_currency_code IN gl_interface.functional_currency_code%type,
139: p_code_combination_id IN gl_interface.code_combination_id%type,
140: p_group_id IN gl_interface.group_id%type);
141:
142: PROCEDURE Init_Gl_Interface(
143: p_int_control IN OUT NOCOPY glcontrol,
144: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%type);

Line 142: PROCEDURE Init_Gl_Interface(

138: p_functional_currency_code IN gl_interface.functional_currency_code%type,
139: p_code_combination_id IN gl_interface.code_combination_id%type,
140: p_group_id IN gl_interface.group_id%type);
141:
142: PROCEDURE Init_Gl_Interface(
143: p_int_control IN OUT NOCOPY glcontrol,
144: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%type);
145:
146: PROCEDURE Insert_Control_Rec(

Line 185: l_reference_10 gl_interface.reference10%TYPE; --shsaxena for bug 2948237

181: l_period_year gl_period_statuses.period_year%type;
182: l_quarter_num gl_period_statuses.quarter_num%type;
183: l_charge_name igi_itr_charge_headers.name%type; --shsaxena for bug 294823
184: l_description igi_itr_charge_lines.description%type;
185: l_reference_10 gl_interface.reference10%TYPE; --shsaxena for bug 2948237
186: l_charge_service_id igi_itr_charge_lines.charge_service_id%type;
187: l_originator_id igi_itr_charge_headers.it_originator_id%type;
188: l_service_name igi_itr_service.name%type;
189: l_status_code varchar2(1);

Line 203: l_curr_calling_sequence := 'IGI_ITR_GL_INTERFACE_PKG.'||l_debug_loc;

199: l_curr_calling_sequence varchar2(2000);
200:
201: Begin
202: --------------------------------------------------------------------
203: l_curr_calling_sequence := 'IGI_ITR_GL_INTERFACE_PKG.'||l_debug_loc;
204: -- Retrieve system variables to be used by fundschecker --
205: --------------------------------------------------------------------
206: IGI_ITR_FUNDS_CONTROL_PKG.Fundscheck_Init(
207: l_chart_of_accounts_id,

Line 415: Gl_interface_insert(

411: And reversal_flag = 'N';
412:
413: l_reference_10 := substr(l_charge_name || ' ' || l_it_line_num || ' ' || l_service_name,1,100);
414:
415: Gl_interface_insert(
416: 'NEW',
417: p_set_of_books_id,
418: l_gl_encumbered_date,
419: l_currency_code,

Line 444: Gl_Interface_Insert(

440: l_currency_code,
441: l_ccid_dr,
442: null );
443:
444: Gl_Interface_Insert(
445: 'NEW',
446: p_set_of_books_id,
447: l_gl_encumbered_date,
448: l_currency_code,

Line 510: Gl_interface_insert(

506: l_gl_encumbered_date := sysdate;
507: End if;
508: */
509:
510: Gl_interface_insert(
511: 'NEW',
512: p_set_of_books_id,
513: l_gl_encumbered_date,
514: l_currency_code,

Line 539: Gl_Interface_Insert(

535: l_currency_code,
536: l_ccid_dr,
537: null );
538:
539: Gl_Interface_Insert(
540: 'NEW',
541: p_set_of_books_id,
542: l_gl_encumbered_date,
543: l_currency_code,

Line 587: Init_Gl_Interface(

583: End Loop;
584: Commit;
585:
586:
587: Init_Gl_Interface(
588: l_int_control,
589: p_set_of_books_id);
590:
591: Insert_Control_Rec(l_int_control);

Line 623: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrpb.IGI_ITR_GL_INTERFACE_PKG.Create_Actuals.msg1',TRUE);

619: IF ( l_unexp_level >= l_debug_level) THEN
620: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
621: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
622: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
623: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrpb.IGI_ITR_GL_INTERFACE_PKG.Create_Actuals.msg1',TRUE);
624: END IF;
625: End If;
626: APP_EXCEPTION.RAISE_EXCEPTION;
627: End Create_Actuals ;

Line 629: Procedure Init_Gl_Interface(

625: End If;
626: APP_EXCEPTION.RAISE_EXCEPTION;
627: End Create_Actuals ;
628:
629: Procedure Init_Gl_Interface(
630: p_int_control IN OUT NOCOPY glcontrol,
631: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%type) IS
632: l_debug_loc varchar2(30) := 'Init_Gl_Interface';
633: l_curr_calling_sequence varchar2(2000);

Line 632: l_debug_loc varchar2(30) := 'Init_Gl_Interface';

628:
629: Procedure Init_Gl_Interface(
630: p_int_control IN OUT NOCOPY glcontrol,
631: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%type) IS
632: l_debug_loc varchar2(30) := 'Init_Gl_Interface';
633: l_curr_calling_sequence varchar2(2000);
634: l_debug_info varchar2(100);
635: l_int_control_old glcontrol;
636: Begin

Line 638: l_curr_calling_sequence := 'IGI_ITR_GL_INTERFACE_PKG.'||l_debug_loc;

634: l_debug_info varchar2(100);
635: l_int_control_old glcontrol;
636: Begin
637: --------------------------------------------------------------------
638: l_curr_calling_sequence := 'IGI_ITR_GL_INTERFACE_PKG.'||l_debug_loc;
639: l_debug_info := 'Initializing GL Interface control variables';
640: --------------------------------------------------------------------
641:
642: /* ssemwal for NOCOPY */

Line 639: l_debug_info := 'Initializing GL Interface control variables';

635: l_int_control_old glcontrol;
636: Begin
637: --------------------------------------------------------------------
638: l_curr_calling_sequence := 'IGI_ITR_GL_INTERFACE_PKG.'||l_debug_loc;
639: l_debug_info := 'Initializing GL Interface control variables';
640: --------------------------------------------------------------------
641:
642: /* ssemwal for NOCOPY */
643: /* added l_int_control_old */

Line 649: NULL, -- Narayanan said comment it (GL_INTERFACE_CONTROL_S.nextval,)

645: l_int_control_old := p_int_control;
646:
647: Select gl_journal_import_s.Nextval,
648: p_set_of_books_id,
649: NULL, -- Narayanan said comment it (GL_INTERFACE_CONTROL_S.nextval,)
650: 'S',
651: 'Internal Trading'
652: Into
653: p_int_control.interface_run_id,

Line 671: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrpb.IGI_ITR_GL_INTERFACE_PKG.Init_Gl_Interface.msg2',TRUE);

667: IF ( l_unexp_level >= l_debug_level) THEN
668: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
669: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
670: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
671: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrpb.IGI_ITR_GL_INTERFACE_PKG.Init_Gl_Interface.msg2',TRUE);
672: END IF;
673: End If;
674: APP_EXCEPTION.RAISE_EXCEPTION;
675: End Init_Gl_Interface;

Line 675: End Init_Gl_Interface;

671: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrpb.IGI_ITR_GL_INTERFACE_PKG.Init_Gl_Interface.msg2',TRUE);
672: END IF;
673: End If;
674: APP_EXCEPTION.RAISE_EXCEPTION;
675: End Init_Gl_Interface;
676:
677: PROCEDURE Insert_Control_Rec(
678: p_int_control in glcontrol) IS
679: l_debug_loc varchar2(30) := 'Insert_Control_Rec';

Line 684: l_curr_calling_sequence := 'IGI_ITR_GL_INTERFACE_PKG.'||l_debug_loc;

680: l_curr_calling_sequence varchar2(2000);
681: l_debug_info varchar2(100);
682: BEGIN
683: --------------------------------------------------------------------
684: l_curr_calling_sequence := 'IGI_ITR_GL_INTERFACE_PKG.'||l_debug_loc;
685: l_debug_info := 'Inserting into gl_interface_control';
686: --------------------------------------------------------------------
687: Insert Into gl_interface_control(
688: je_source_name,

Line 685: l_debug_info := 'Inserting into gl_interface_control';

681: l_debug_info varchar2(100);
682: BEGIN
683: --------------------------------------------------------------------
684: l_curr_calling_sequence := 'IGI_ITR_GL_INTERFACE_PKG.'||l_debug_loc;
685: l_debug_info := 'Inserting into gl_interface_control';
686: --------------------------------------------------------------------
687: Insert Into gl_interface_control(
688: je_source_name,
689: status,

Line 687: Insert Into gl_interface_control(

683: --------------------------------------------------------------------
684: l_curr_calling_sequence := 'IGI_ITR_GL_INTERFACE_PKG.'||l_debug_loc;
685: l_debug_info := 'Inserting into gl_interface_control';
686: --------------------------------------------------------------------
687: Insert Into gl_interface_control(
688: je_source_name,
689: status,
690: interface_run_id,
691: group_id,

Line 710: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrpb.IGI_ITR_GL_INTERFACE_PKG.Insert_Control_Rec.msg3',TRUE);

706: IF ( l_unexp_level >= l_debug_level) THEN
707: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
708: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
709: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
710: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrpb.IGI_ITR_GL_INTERFACE_PKG.Insert_Control_Rec.msg3',TRUE);
711: END IF;
712: EnD If;
713: APP_EXCEPTION.RAISE_EXCEPTION;
714: End Insert_Control_Rec;

Line 716: Procedure Gl_Interface_Insert(

712: EnD If;
713: APP_EXCEPTION.RAISE_EXCEPTION;
714: End Insert_Control_Rec;
715:
716: Procedure Gl_Interface_Insert(
717: p_status IN gl_interface.status%type,
718: p_set_of_books_id IN gl_interface.set_of_books_id%type,
719: p_accounting_date IN gl_interface.accounting_date%type,
720: p_currency_code IN gl_interface.currency_code%type,

Line 717: p_status IN gl_interface.status%type,

713: APP_EXCEPTION.RAISE_EXCEPTION;
714: End Insert_Control_Rec;
715:
716: Procedure Gl_Interface_Insert(
717: p_status IN gl_interface.status%type,
718: p_set_of_books_id IN gl_interface.set_of_books_id%type,
719: p_accounting_date IN gl_interface.accounting_date%type,
720: p_currency_code IN gl_interface.currency_code%type,
721: p_date_created IN gl_interface.date_created%type,

Line 718: p_set_of_books_id IN gl_interface.set_of_books_id%type,

714: End Insert_Control_Rec;
715:
716: Procedure Gl_Interface_Insert(
717: p_status IN gl_interface.status%type,
718: p_set_of_books_id IN gl_interface.set_of_books_id%type,
719: p_accounting_date IN gl_interface.accounting_date%type,
720: p_currency_code IN gl_interface.currency_code%type,
721: p_date_created IN gl_interface.date_created%type,
722: p_created_by IN gl_interface.created_by%type,

Line 719: p_accounting_date IN gl_interface.accounting_date%type,

715:
716: Procedure Gl_Interface_Insert(
717: p_status IN gl_interface.status%type,
718: p_set_of_books_id IN gl_interface.set_of_books_id%type,
719: p_accounting_date IN gl_interface.accounting_date%type,
720: p_currency_code IN gl_interface.currency_code%type,
721: p_date_created IN gl_interface.date_created%type,
722: p_created_by IN gl_interface.created_by%type,
723: p_actual_flag IN gl_interface.actual_flag%type,

Line 720: p_currency_code IN gl_interface.currency_code%type,

716: Procedure Gl_Interface_Insert(
717: p_status IN gl_interface.status%type,
718: p_set_of_books_id IN gl_interface.set_of_books_id%type,
719: p_accounting_date IN gl_interface.accounting_date%type,
720: p_currency_code IN gl_interface.currency_code%type,
721: p_date_created IN gl_interface.date_created%type,
722: p_created_by IN gl_interface.created_by%type,
723: p_actual_flag IN gl_interface.actual_flag%type,
724: p_user_je_category_name IN gl_interface.user_je_category_name%type,

Line 721: p_date_created IN gl_interface.date_created%type,

717: p_status IN gl_interface.status%type,
718: p_set_of_books_id IN gl_interface.set_of_books_id%type,
719: p_accounting_date IN gl_interface.accounting_date%type,
720: p_currency_code IN gl_interface.currency_code%type,
721: p_date_created IN gl_interface.date_created%type,
722: p_created_by IN gl_interface.created_by%type,
723: p_actual_flag IN gl_interface.actual_flag%type,
724: p_user_je_category_name IN gl_interface.user_je_category_name%type,
725: p_user_je_source_name IN gl_interface.user_je_source_name%type,

Line 722: p_created_by IN gl_interface.created_by%type,

718: p_set_of_books_id IN gl_interface.set_of_books_id%type,
719: p_accounting_date IN gl_interface.accounting_date%type,
720: p_currency_code IN gl_interface.currency_code%type,
721: p_date_created IN gl_interface.date_created%type,
722: p_created_by IN gl_interface.created_by%type,
723: p_actual_flag IN gl_interface.actual_flag%type,
724: p_user_je_category_name IN gl_interface.user_je_category_name%type,
725: p_user_je_source_name IN gl_interface.user_je_source_name%type,
726: p_entered_dr IN gl_interface.entered_dr%type,

Line 723: p_actual_flag IN gl_interface.actual_flag%type,

719: p_accounting_date IN gl_interface.accounting_date%type,
720: p_currency_code IN gl_interface.currency_code%type,
721: p_date_created IN gl_interface.date_created%type,
722: p_created_by IN gl_interface.created_by%type,
723: p_actual_flag IN gl_interface.actual_flag%type,
724: p_user_je_category_name IN gl_interface.user_je_category_name%type,
725: p_user_je_source_name IN gl_interface.user_je_source_name%type,
726: p_entered_dr IN gl_interface.entered_dr%type,
727: p_entered_cr IN gl_interface.entered_cr%type,

Line 724: p_user_je_category_name IN gl_interface.user_je_category_name%type,

720: p_currency_code IN gl_interface.currency_code%type,
721: p_date_created IN gl_interface.date_created%type,
722: p_created_by IN gl_interface.created_by%type,
723: p_actual_flag IN gl_interface.actual_flag%type,
724: p_user_je_category_name IN gl_interface.user_je_category_name%type,
725: p_user_je_source_name IN gl_interface.user_je_source_name%type,
726: p_entered_dr IN gl_interface.entered_dr%type,
727: p_entered_cr IN gl_interface.entered_cr%type,
728: p_accounted_dr IN gl_interface.accounted_dr%type,

Line 725: p_user_je_source_name IN gl_interface.user_je_source_name%type,

721: p_date_created IN gl_interface.date_created%type,
722: p_created_by IN gl_interface.created_by%type,
723: p_actual_flag IN gl_interface.actual_flag%type,
724: p_user_je_category_name IN gl_interface.user_je_category_name%type,
725: p_user_je_source_name IN gl_interface.user_je_source_name%type,
726: p_entered_dr IN gl_interface.entered_dr%type,
727: p_entered_cr IN gl_interface.entered_cr%type,
728: p_accounted_dr IN gl_interface.accounted_dr%type,
729: p_accounted_cr IN gl_interface.accounted_cr%type,

Line 726: p_entered_dr IN gl_interface.entered_dr%type,

722: p_created_by IN gl_interface.created_by%type,
723: p_actual_flag IN gl_interface.actual_flag%type,
724: p_user_je_category_name IN gl_interface.user_je_category_name%type,
725: p_user_je_source_name IN gl_interface.user_je_source_name%type,
726: p_entered_dr IN gl_interface.entered_dr%type,
727: p_entered_cr IN gl_interface.entered_cr%type,
728: p_accounted_dr IN gl_interface.accounted_dr%type,
729: p_accounted_cr IN gl_interface.accounted_cr%type,
730: p_transaction_date IN gl_interface.transaction_date%type,

Line 727: p_entered_cr IN gl_interface.entered_cr%type,

723: p_actual_flag IN gl_interface.actual_flag%type,
724: p_user_je_category_name IN gl_interface.user_je_category_name%type,
725: p_user_je_source_name IN gl_interface.user_je_source_name%type,
726: p_entered_dr IN gl_interface.entered_dr%type,
727: p_entered_cr IN gl_interface.entered_cr%type,
728: p_accounted_dr IN gl_interface.accounted_dr%type,
729: p_accounted_cr IN gl_interface.accounted_cr%type,
730: p_transaction_date IN gl_interface.transaction_date%type,
731: p_reference1 IN gl_interface.reference1%type,

Line 728: p_accounted_dr IN gl_interface.accounted_dr%type,

724: p_user_je_category_name IN gl_interface.user_je_category_name%type,
725: p_user_je_source_name IN gl_interface.user_je_source_name%type,
726: p_entered_dr IN gl_interface.entered_dr%type,
727: p_entered_cr IN gl_interface.entered_cr%type,
728: p_accounted_dr IN gl_interface.accounted_dr%type,
729: p_accounted_cr IN gl_interface.accounted_cr%type,
730: p_transaction_date IN gl_interface.transaction_date%type,
731: p_reference1 IN gl_interface.reference1%type,
732: p_reference4 IN gl_interface.reference4%type,

Line 729: p_accounted_cr IN gl_interface.accounted_cr%type,

725: p_user_je_source_name IN gl_interface.user_je_source_name%type,
726: p_entered_dr IN gl_interface.entered_dr%type,
727: p_entered_cr IN gl_interface.entered_cr%type,
728: p_accounted_dr IN gl_interface.accounted_dr%type,
729: p_accounted_cr IN gl_interface.accounted_cr%type,
730: p_transaction_date IN gl_interface.transaction_date%type,
731: p_reference1 IN gl_interface.reference1%type,
732: p_reference4 IN gl_interface.reference4%type,
733: p_reference6 IN gl_interface.reference6%type,

Line 730: p_transaction_date IN gl_interface.transaction_date%type,

726: p_entered_dr IN gl_interface.entered_dr%type,
727: p_entered_cr IN gl_interface.entered_cr%type,
728: p_accounted_dr IN gl_interface.accounted_dr%type,
729: p_accounted_cr IN gl_interface.accounted_cr%type,
730: p_transaction_date IN gl_interface.transaction_date%type,
731: p_reference1 IN gl_interface.reference1%type,
732: p_reference4 IN gl_interface.reference4%type,
733: p_reference6 IN gl_interface.reference6%type,
734: p_reference10 IN gl_interface.reference10%type,

Line 731: p_reference1 IN gl_interface.reference1%type,

727: p_entered_cr IN gl_interface.entered_cr%type,
728: p_accounted_dr IN gl_interface.accounted_dr%type,
729: p_accounted_cr IN gl_interface.accounted_cr%type,
730: p_transaction_date IN gl_interface.transaction_date%type,
731: p_reference1 IN gl_interface.reference1%type,
732: p_reference4 IN gl_interface.reference4%type,
733: p_reference6 IN gl_interface.reference6%type,
734: p_reference10 IN gl_interface.reference10%type,
735: p_reference21 IN gl_interface.reference21%type,

Line 732: p_reference4 IN gl_interface.reference4%type,

728: p_accounted_dr IN gl_interface.accounted_dr%type,
729: p_accounted_cr IN gl_interface.accounted_cr%type,
730: p_transaction_date IN gl_interface.transaction_date%type,
731: p_reference1 IN gl_interface.reference1%type,
732: p_reference4 IN gl_interface.reference4%type,
733: p_reference6 IN gl_interface.reference6%type,
734: p_reference10 IN gl_interface.reference10%type,
735: p_reference21 IN gl_interface.reference21%type,
736: p_reference22 IN gl_interface.reference22%type,

Line 733: p_reference6 IN gl_interface.reference6%type,

729: p_accounted_cr IN gl_interface.accounted_cr%type,
730: p_transaction_date IN gl_interface.transaction_date%type,
731: p_reference1 IN gl_interface.reference1%type,
732: p_reference4 IN gl_interface.reference4%type,
733: p_reference6 IN gl_interface.reference6%type,
734: p_reference10 IN gl_interface.reference10%type,
735: p_reference21 IN gl_interface.reference21%type,
736: p_reference22 IN gl_interface.reference22%type,
737: p_period_name IN gl_interface.period_name%type,

Line 734: p_reference10 IN gl_interface.reference10%type,

730: p_transaction_date IN gl_interface.transaction_date%type,
731: p_reference1 IN gl_interface.reference1%type,
732: p_reference4 IN gl_interface.reference4%type,
733: p_reference6 IN gl_interface.reference6%type,
734: p_reference10 IN gl_interface.reference10%type,
735: p_reference21 IN gl_interface.reference21%type,
736: p_reference22 IN gl_interface.reference22%type,
737: p_period_name IN gl_interface.period_name%type,
738: p_chart_of_accounts_id IN gl_interface.chart_of_accounts_id%type,

Line 735: p_reference21 IN gl_interface.reference21%type,

731: p_reference1 IN gl_interface.reference1%type,
732: p_reference4 IN gl_interface.reference4%type,
733: p_reference6 IN gl_interface.reference6%type,
734: p_reference10 IN gl_interface.reference10%type,
735: p_reference21 IN gl_interface.reference21%type,
736: p_reference22 IN gl_interface.reference22%type,
737: p_period_name IN gl_interface.period_name%type,
738: p_chart_of_accounts_id IN gl_interface.chart_of_accounts_id%type,
739: p_functional_currency_code IN gl_interface.functional_currency_code%type,

Line 736: p_reference22 IN gl_interface.reference22%type,

732: p_reference4 IN gl_interface.reference4%type,
733: p_reference6 IN gl_interface.reference6%type,
734: p_reference10 IN gl_interface.reference10%type,
735: p_reference21 IN gl_interface.reference21%type,
736: p_reference22 IN gl_interface.reference22%type,
737: p_period_name IN gl_interface.period_name%type,
738: p_chart_of_accounts_id IN gl_interface.chart_of_accounts_id%type,
739: p_functional_currency_code IN gl_interface.functional_currency_code%type,
740: p_code_combination_id IN gl_interface.code_combination_id%type,

Line 737: p_period_name IN gl_interface.period_name%type,

733: p_reference6 IN gl_interface.reference6%type,
734: p_reference10 IN gl_interface.reference10%type,
735: p_reference21 IN gl_interface.reference21%type,
736: p_reference22 IN gl_interface.reference22%type,
737: p_period_name IN gl_interface.period_name%type,
738: p_chart_of_accounts_id IN gl_interface.chart_of_accounts_id%type,
739: p_functional_currency_code IN gl_interface.functional_currency_code%type,
740: p_code_combination_id IN gl_interface.code_combination_id%type,
741: p_group_id IN gl_interface.group_id%type) IS

Line 738: p_chart_of_accounts_id IN gl_interface.chart_of_accounts_id%type,

734: p_reference10 IN gl_interface.reference10%type,
735: p_reference21 IN gl_interface.reference21%type,
736: p_reference22 IN gl_interface.reference22%type,
737: p_period_name IN gl_interface.period_name%type,
738: p_chart_of_accounts_id IN gl_interface.chart_of_accounts_id%type,
739: p_functional_currency_code IN gl_interface.functional_currency_code%type,
740: p_code_combination_id IN gl_interface.code_combination_id%type,
741: p_group_id IN gl_interface.group_id%type) IS
742: l_debug_loc varchar2(30) := 'GL_interface';

Line 739: p_functional_currency_code IN gl_interface.functional_currency_code%type,

735: p_reference21 IN gl_interface.reference21%type,
736: p_reference22 IN gl_interface.reference22%type,
737: p_period_name IN gl_interface.period_name%type,
738: p_chart_of_accounts_id IN gl_interface.chart_of_accounts_id%type,
739: p_functional_currency_code IN gl_interface.functional_currency_code%type,
740: p_code_combination_id IN gl_interface.code_combination_id%type,
741: p_group_id IN gl_interface.group_id%type) IS
742: l_debug_loc varchar2(30) := 'GL_interface';
743: l_curr_calling_sequence varchar2(2000);

Line 740: p_code_combination_id IN gl_interface.code_combination_id%type,

736: p_reference22 IN gl_interface.reference22%type,
737: p_period_name IN gl_interface.period_name%type,
738: p_chart_of_accounts_id IN gl_interface.chart_of_accounts_id%type,
739: p_functional_currency_code IN gl_interface.functional_currency_code%type,
740: p_code_combination_id IN gl_interface.code_combination_id%type,
741: p_group_id IN gl_interface.group_id%type) IS
742: l_debug_loc varchar2(30) := 'GL_interface';
743: l_curr_calling_sequence varchar2(2000);
744: l_debug_info varchar2(100);

Line 741: p_group_id IN gl_interface.group_id%type) IS

737: p_period_name IN gl_interface.period_name%type,
738: p_chart_of_accounts_id IN gl_interface.chart_of_accounts_id%type,
739: p_functional_currency_code IN gl_interface.functional_currency_code%type,
740: p_code_combination_id IN gl_interface.code_combination_id%type,
741: p_group_id IN gl_interface.group_id%type) IS
742: l_debug_loc varchar2(30) := 'GL_interface';
743: l_curr_calling_sequence varchar2(2000);
744: l_debug_info varchar2(100);
745: Begin

Line 742: l_debug_loc varchar2(30) := 'GL_interface';

738: p_chart_of_accounts_id IN gl_interface.chart_of_accounts_id%type,
739: p_functional_currency_code IN gl_interface.functional_currency_code%type,
740: p_code_combination_id IN gl_interface.code_combination_id%type,
741: p_group_id IN gl_interface.group_id%type) IS
742: l_debug_loc varchar2(30) := 'GL_interface';
743: l_curr_calling_sequence varchar2(2000);
744: l_debug_info varchar2(100);
745: Begin
746: ----------------------------------------------------------------------

Line 747: l_curr_calling_sequence := 'IGI_ITR_GL_INTERFACE_PKG.' || l_debug_loc;

743: l_curr_calling_sequence varchar2(2000);
744: l_debug_info varchar2(100);
745: Begin
746: ----------------------------------------------------------------------
747: l_curr_calling_sequence := 'IGI_ITR_GL_INTERFACE_PKG.' || l_debug_loc;
748: l_debug_info := 'Inserting record into gl_interface';
749: ----------------------------------------------------------------------
750: Insert Into gl_interface(
751: status,

Line 748: l_debug_info := 'Inserting record into gl_interface';

744: l_debug_info varchar2(100);
745: Begin
746: ----------------------------------------------------------------------
747: l_curr_calling_sequence := 'IGI_ITR_GL_INTERFACE_PKG.' || l_debug_loc;
748: l_debug_info := 'Inserting record into gl_interface';
749: ----------------------------------------------------------------------
750: Insert Into gl_interface(
751: status,
752: set_of_books_id,

Line 750: Insert Into gl_interface(

746: ----------------------------------------------------------------------
747: l_curr_calling_sequence := 'IGI_ITR_GL_INTERFACE_PKG.' || l_debug_loc;
748: l_debug_info := 'Inserting record into gl_interface';
749: ----------------------------------------------------------------------
750: Insert Into gl_interface(
751: status,
752: set_of_books_id,
753: accounting_date,
754: currency_code,

Line 838: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrpb.IGI_ITR_GL_INTERFACE_PKG.Gl_Interface_Insert.msg4',TRUE);

834: IF ( l_unexp_level >= l_debug_level) THEN
835: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
836: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
837: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
838: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrpb.IGI_ITR_GL_INTERFACE_PKG.Gl_Interface_Insert.msg4',TRUE);
839: END IF;
840: End If;
841: APP_EXCEPTION.RAISE_EXCEPTION;
842: End Gl_Interface_Insert;

Line 842: End Gl_Interface_Insert;

838: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrpb.IGI_ITR_GL_INTERFACE_PKG.Gl_Interface_Insert.msg4',TRUE);
839: END IF;
840: End If;
841: APP_EXCEPTION.RAISE_EXCEPTION;
842: End Gl_Interface_Insert;
843:
844: END IGI_ITR_GL_INTERFACE_PKG;

Line 844: END IGI_ITR_GL_INTERFACE_PKG;

840: End If;
841: APP_EXCEPTION.RAISE_EXCEPTION;
842: End Gl_Interface_Insert;
843:
844: END IGI_ITR_GL_INTERFACE_PKG;