110: AND ledger_id = l_ledger_id
111: AND period_year = l_fiscal_year);
112: --
113: -- use apis to get the BALANCING segment info
114: -- fnd_flex_apis.get_qualifier_segnum gets the segment number
115: -- fnd_flex_apis.get_segment_info gets the column name
116: --
117: IF (FND_FLEX_APIS.get_qualifier_segnum(l_application_id,
118: l_id_flex_code,
111: AND period_year = l_fiscal_year);
112: --
113: -- use apis to get the BALANCING segment info
114: -- fnd_flex_apis.get_qualifier_segnum gets the segment number
115: -- fnd_flex_apis.get_segment_info gets the column name
116: --
117: IF (FND_FLEX_APIS.get_qualifier_segnum(l_application_id,
118: l_id_flex_code,
119: l_chart_of_accounts_id,
113: -- use apis to get the BALANCING segment info
114: -- fnd_flex_apis.get_qualifier_segnum gets the segment number
115: -- fnd_flex_apis.get_segment_info gets the column name
116: --
117: IF (FND_FLEX_APIS.get_qualifier_segnum(l_application_id,
118: l_id_flex_code,
119: l_chart_of_accounts_id,
120: 'GL_BALANCING',
121: l_segnum)) THEN
118: l_id_flex_code,
119: l_chart_of_accounts_id,
120: 'GL_BALANCING',
121: l_segnum)) THEN
122: IF (FND_FLEX_APIS.get_segment_info( l_application_id,
123: l_id_flex_code,
124: l_chart_of_accounts_id,
125: l_segnum,
126: l_balancing_segment_column,
135: --
136: -- Failure in get_segment_info
137: --
138: IF (debug_mode = 'Y') THEN
139: -- dbms_output.put_line('failure at FND_FLEX_APIS.get_segment_info for balancing segment');
140: NULL;
141: END IF;
142: raise segment_not_found;
143: END IF;
142: raise segment_not_found;
143: END IF;
144: ELSE
145: IF (debug_mode = 'Y') THEN
146: -- dbms_output.put_line('failure at FND_FLEX_APIS.get_qualifier segnum for balancing segment');
147: NULL;
148: END IF;
149: raise segment_not_found;
150: END IF;
149: raise segment_not_found;
150: END IF;
151: --
152: -- use apis to get the ACCOUNT segment info
153: -- fnd_flex_apis.get_qualifier_segnum gets the segment number
154: -- fnd_flex_apis.get_segment_info gets the column name
155: --
156: IF (FND_FLEX_APIS.get_qualifier_segnum( l_application_id,
157: l_id_flex_code,
150: END IF;
151: --
152: -- use apis to get the ACCOUNT segment info
153: -- fnd_flex_apis.get_qualifier_segnum gets the segment number
154: -- fnd_flex_apis.get_segment_info gets the column name
155: --
156: IF (FND_FLEX_APIS.get_qualifier_segnum( l_application_id,
157: l_id_flex_code,
158: l_chart_of_accounts_id,
152: -- use apis to get the ACCOUNT segment info
153: -- fnd_flex_apis.get_qualifier_segnum gets the segment number
154: -- fnd_flex_apis.get_segment_info gets the column name
155: --
156: IF (FND_FLEX_APIS.get_qualifier_segnum( l_application_id,
157: l_id_flex_code,
158: l_chart_of_accounts_id,
159: 'GL_ACCOUNT',
160: l_segnum)) THEN
157: l_id_flex_code,
158: l_chart_of_accounts_id,
159: 'GL_ACCOUNT',
160: l_segnum)) THEN
161: IF (FND_FLEX_APIS.get_segment_info (l_application_id,
162: l_id_flex_code,
163: l_chart_of_accounts_id,
164: l_segnum,
165: l_account_segment_column,
171: NULL;
172: END IF;
173: ELSE
174: IF (debug_mode = 'Y') THEN
175: -- dbms_output.put_line('failure at FND_FLEX_APIS.get_segment_info for account segment');
176: NULL;
177: END IF;
178: raise segment_not_found;
179: END IF;
178: raise segment_not_found;
179: END IF;
180: ELSE
181: IF (debug_mode = 'Y') THEN
182: -- dbms_output.put_line('failure at FND_FLEX_APIS.get_qualifier_segnum fore account segment');
183: NULL;
184: END IF;
185: raise segment_not_found;
186: END IF;