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.FTE_RATE_CHART_PKG dependencies on FTE_UTIL_PKG

Line 103: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

99: g_region_flag := NULL;
100: g_region_linenum := NULL;
101:
102: EXCEPTION WHEN OTHERS THEN
103: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
104: p_msg => sqlerrm,
105: p_category => 'O');
106:
107: RAISE;

Line 166: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);

162:
163: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.CHECK_FACILITIES';
164:
165: BEGIN
166: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
167:
168: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
169: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'List Header ID', p_pricelist_id);
170: END IF;

Line 169: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'List Header ID', p_pricelist_id);

165: BEGIN
166: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
167:
168: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
169: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'List Header ID', p_pricelist_id);
170: END IF;
171:
172: x_status := -1;
173:

Line 180: x_error_msg := FTE_UTIL_PKG.GET_MSG('FTE_RC_ASSIGNED_TO_FC');

176: i := facility_codes%ROWCOUNT;
177: CLOSE facility_codes;
178:
179: IF ( i > 0 ) THEN
180: x_error_msg := FTE_UTIL_PKG.GET_MSG('FTE_RC_ASSIGNED_TO_FC');
181: FOR j IN 1..l_faccodes.COUNT LOOP
182: x_error_msg := x_error_msg || ' '||
183: FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_FACILITY_CODE',
184: p_tokens => STRINGARRAY('CODE'),

Line 183: FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_FACILITY_CODE',

179: IF ( i > 0 ) THEN
180: x_error_msg := FTE_UTIL_PKG.GET_MSG('FTE_RC_ASSIGNED_TO_FC');
181: FOR j IN 1..l_faccodes.COUNT LOOP
182: x_error_msg := x_error_msg || ' '||
183: FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_FACILITY_CODE',
184: p_tokens => STRINGARRAY('CODE'),
185: p_values => STRINGARRAY(l_faccodes(j)));
186: END LOOP;
187: x_status := 2;

Line 189: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

185: p_values => STRINGARRAY(l_faccodes(j)));
186: END LOOP;
187: x_status := 2;
188:
189: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
190: p_msg => x_error_msg,
191: p_category => 'F');
192:
193: END IF;

Line 195: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

191: p_category => 'F');
192:
193: END IF;
194:
195: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
196: RETURN x_status;
197:
198: EXCEPTION WHEN OTHERS THEN
199: IF (facility_codes%ISOPEN) THEN

Line 203: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

199: IF (facility_codes%ISOPEN) THEN
200: CLOSE facility_codes;
201: END IF;
202: x_error_msg := sqlerrm;
203: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
204: p_msg => x_error_msg,
205: p_category => 'O');
206: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
207: x_status := 1;

Line 206: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

202: x_error_msg := sqlerrm;
203: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
204: p_msg => x_error_msg,
205: p_category => 'O');
206: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
207: x_status := 1;
208: RETURN x_status;
209: END Check_Facilities;
210:

Line 232: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);

228: l_attribute1 VARCHAR2(50);
229: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.GET_PRICELIST_ID';
230:
231: BEGIN
232: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
233:
234: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
235: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Rate Chart Name', p_name);
236: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Carrier ID', p_carrier_id);

Line 235: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Rate Chart Name', p_name);

231: BEGIN
232: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
233:
234: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
235: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Rate Chart Name', p_name);
236: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Carrier ID', p_carrier_id);
237: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Attribute1', p_attribute1);
238: END IF;
239:

Line 236: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Carrier ID', p_carrier_id);

232: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
233:
234: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
235: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Rate Chart Name', p_name);
236: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Carrier ID', p_carrier_id);
237: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Attribute1', p_attribute1);
238: END IF;
239:
240: IF (p_carrier_id IS NULL) THEN

Line 237: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Attribute1', p_attribute1);

233:
234: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
235: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Rate Chart Name', p_name);
236: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Carrier ID', p_carrier_id);
237: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Attribute1', p_attribute1);
238: END IF;
239:
240: IF (p_carrier_id IS NULL) THEN
241: SELECT l.list_header_id, nvl(b.attribute1, 'FTE_RATE_CHART')

Line 260: FTE_UTIL_PKG.Exit_Debug(l_module_name);

256: AND q.qualifier_attr_value = Fnd_Number.Number_To_Canonical(p_Carrier_Id)
257: AND l.language = userenv('LANG');
258: END IF;
259:
260: FTE_UTIL_PKG.Exit_Debug(l_module_name);
261:
262: p_attribute1 := l_attribute1;
263:
264: RETURN l_list_header_id;

Line 268: FTE_UTIL_PKG.Exit_Debug(l_module_name);

264: RETURN l_list_header_id;
265: EXCEPTION
266: WHEN NO_DATA_FOUND THEN
267: --no rate chart with this 'rate chart name' and carrier found.
268: FTE_UTIL_PKG.Exit_Debug(l_module_name);
269: RETURN -1;
270: WHEN OTHERS THEN
271: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
272: p_msg => sqlerrm,

Line 271: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

267: --no rate chart with this 'rate chart name' and carrier found.
268: FTE_UTIL_PKG.Exit_Debug(l_module_name);
269: RETURN -1;
270: WHEN OTHERS THEN
271: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
272: p_msg => sqlerrm,
273: p_category => 'O');
274:
275: FTE_UTIL_PKG.Exit_Debug(l_module_name);

Line 275: FTE_UTIL_PKG.Exit_Debug(l_module_name);

271: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
272: p_msg => sqlerrm,
273: p_category => 'O');
274:
275: FTE_UTIL_PKG.Exit_Debug(l_module_name);
276: RAISE;
277: END Get_Pricelist_Id;
278:
279: -----------------------------------------------------------------------------

Line 318: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);

314: AND q.qualifier_attr_value = TO_CHAR(p_carrier_id)
315: AND ltl.language = userenv('LANG');
316:
317: BEGIN
318: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
319:
320: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
321: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Rate Chart Name', p_name);
322: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Carrier ID', p_carrier_id);

Line 321: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Rate Chart Name', p_name);

317: BEGIN
318: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
319:
320: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
321: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Rate Chart Name', p_name);
322: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Carrier ID', p_carrier_id);
323: END IF;
324:
325: x_status := -1;

Line 322: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Carrier ID', p_carrier_id);

318: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
319:
320: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
321: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Rate Chart Name', p_name);
322: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Carrier ID', p_carrier_id);
323: END IF;
324:
325: x_status := -1;
326:

Line 337: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'List header ID', l_list_header_id);

333:
334: CLOSE GET_CHART_INFO;
335:
336: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
337: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'List header ID', l_list_header_id);
338: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Start date ', l_start_date);
339: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'End date ', l_end_date);
340: END IF;
341:

Line 338: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Start date ', l_start_date);

334: CLOSE GET_CHART_INFO;
335:
336: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
337: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'List header ID', l_list_header_id);
338: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Start date ', l_start_date);
339: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'End date ', l_end_date);
340: END IF;
341:
342: FTE_UTIL_PKG.Exit_Debug(l_module_name);

Line 339: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'End date ', l_end_date);

335:
336: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
337: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'List header ID', l_list_header_id);
338: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Start date ', l_start_date);
339: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'End date ', l_end_date);
340: END IF;
341:
342: FTE_UTIL_PKG.Exit_Debug(l_module_name);
343: RETURN l_result;

Line 342: FTE_UTIL_PKG.Exit_Debug(l_module_name);

338: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Start date ', l_start_date);
339: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'End date ', l_end_date);
340: END IF;
341:
342: FTE_UTIL_PKG.Exit_Debug(l_module_name);
343: RETURN l_result;
344:
345: EXCEPTION
346: WHEN OTHERS THEN

Line 351: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

347: IF (GET_CHART_INFO%ISOPEN) THEN
348: CLOSE GET_CHART_INFO;
349: END IF;
350: x_error_msg := sqlerrm;
351: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
352: p_msg => x_error_msg,
353: p_category => 'O');
354:
355: FTE_UTIL_PKG.Exit_Debug(l_module_name);

Line 355: FTE_UTIL_PKG.Exit_Debug(l_module_name);

351: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
352: p_msg => x_error_msg,
353: p_category => 'O');
354:
355: FTE_UTIL_PKG.Exit_Debug(l_module_name);
356: x_status := 1;
357: RETURN NULL;
358: END GET_RATE_CHART_INFO;
359:

Line 390: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);

386: l_attribute1 VARCHAR2(50);
387: l_tokens STRINGARRAY := STRINGARRAY();
388:
389: BEGIN
390: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
391:
392: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
393: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'List header ID', p_list_header_id);
394: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Rate Chart Name', p_name);

Line 393: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'List header ID', p_list_header_id);

389: BEGIN
390: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
391:
392: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
393: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'List header ID', p_list_header_id);
394: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Rate Chart Name', p_name);
395: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Action', p_action);
396: END IF;
397:

Line 394: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Rate Chart Name', p_name);

390: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
391:
392: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
393: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'List header ID', p_list_header_id);
394: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Rate Chart Name', p_name);
395: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Action', p_action);
396: END IF;
397:
398: x_status := -1;

Line 395: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Action', p_action);

391:
392: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
393: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'List header ID', p_list_header_id);
394: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Rate Chart Name', p_name);
395: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Action', p_action);
396: END IF;
397:
398: x_status := -1;
399:

Line 405: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_PRICELIST_INVALID',

401: l_list_header_id := Get_Pricelist_Id(p_name => p_name,
402: p_carrier_id => NULL,
403: p_attribute1 => l_attribute1);
404: IF (l_list_header_id = -1) THEN
405: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_PRICELIST_INVALID',
406: p_tokens => STRINGARRAY('NAME'),
407: p_values => STRINGARRAY(p_name));
408:
409: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

Line 409: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

405: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_PRICELIST_INVALID',
406: p_tokens => STRINGARRAY('NAME'),
407: p_values => STRINGARRAY(p_name));
408:
409: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
410: p_msg => x_error_msg,
411: p_category => 'C',
412: p_line_number => p_line_number);
413:

Line 415: FTE_UTIL_PKG.Exit_Debug(l_module_name);

411: p_category => 'C',
412: p_line_number => p_line_number);
413:
414: x_status := 2;
415: FTE_UTIL_PKG.Exit_Debug(l_module_name);
416: RETURN;
417: END IF;
418:
419: IF (l_attribute1 <> g_chart_type OR l_attribute1 IS NULL) THEN

Line 424: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_RATE_CHART');

420: l_tokens.EXTEND;
421: l_tokens(l_tokens.COUNT) := p_name;
422: l_tokens.EXTEND;
423: IF (g_chart_type = 'FTE_RATE_CHART') THEN
424: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_RATE_CHART');
425: ELSIF (g_chart_type = 'TL_RATE_CHART') THEN
426: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_TL_RATE_CHART');
427: ELSIF (g_chart_type = 'LTL_RC') THEN
428: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_LTL_RATE_CHART');

Line 426: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_TL_RATE_CHART');

422: l_tokens.EXTEND;
423: IF (g_chart_type = 'FTE_RATE_CHART') THEN
424: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_RATE_CHART');
425: ELSIF (g_chart_type = 'TL_RATE_CHART') THEN
426: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_TL_RATE_CHART');
427: ELSIF (g_chart_type = 'LTL_RC') THEN
428: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_LTL_RATE_CHART');
429: ELSIF (g_chart_type = 'FAC_RATE_CHART') THEN
430: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_FAC_RATE_CHART');

Line 428: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_LTL_RATE_CHART');

424: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_RATE_CHART');
425: ELSIF (g_chart_type = 'TL_RATE_CHART') THEN
426: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_TL_RATE_CHART');
427: ELSIF (g_chart_type = 'LTL_RC') THEN
428: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_LTL_RATE_CHART');
429: ELSIF (g_chart_type = 'FAC_RATE_CHART') THEN
430: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_FAC_RATE_CHART');
431: ELSIF (g_chart_type = 'FTE_MODIFIER') THEN
432: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_CHARGES_DISCOUNTS');

Line 430: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_FAC_RATE_CHART');

426: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_TL_RATE_CHART');
427: ELSIF (g_chart_type = 'LTL_RC') THEN
428: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_LTL_RATE_CHART');
429: ELSIF (g_chart_type = 'FAC_RATE_CHART') THEN
430: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_FAC_RATE_CHART');
431: ELSIF (g_chart_type = 'FTE_MODIFIER') THEN
432: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_CHARGES_DISCOUNTS');
433: ELSIF (g_chart_type = 'FAC_MODIFIER') THEN
434: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_FAC_CHARGES');

Line 432: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_CHARGES_DISCOUNTS');

428: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_LTL_RATE_CHART');
429: ELSIF (g_chart_type = 'FAC_RATE_CHART') THEN
430: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_FAC_RATE_CHART');
431: ELSIF (g_chart_type = 'FTE_MODIFIER') THEN
432: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_CHARGES_DISCOUNTS');
433: ELSIF (g_chart_type = 'FAC_MODIFIER') THEN
434: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_FAC_CHARGES');
435: ELSIF (g_chart_type = 'TL_MODIFIER') THEN
436: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_TL_ACCESSORIALS');

Line 434: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_FAC_CHARGES');

430: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_FAC_RATE_CHART');
431: ELSIF (g_chart_type = 'FTE_MODIFIER') THEN
432: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_CHARGES_DISCOUNTS');
433: ELSIF (g_chart_type = 'FAC_MODIFIER') THEN
434: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_FAC_CHARGES');
435: ELSIF (g_chart_type = 'TL_MODIFIER') THEN
436: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_TL_ACCESSORIALS');
437: ELSIF (g_chart_type = 'MIN_MODIFIER') THEN
438: l_tokens(l_tokens.COUNT) := 'LTL and/or Parcel Modifier';

Line 436: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_TL_ACCESSORIALS');

432: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_CHARGES_DISCOUNTS');
433: ELSIF (g_chart_type = 'FAC_MODIFIER') THEN
434: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_FAC_CHARGES');
435: ELSIF (g_chart_type = 'TL_MODIFIER') THEN
436: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_TL_ACCESSORIALS');
437: ELSIF (g_chart_type = 'MIN_MODIFIER') THEN
438: l_tokens(l_tokens.COUNT) := 'LTL and/or Parcel Modifier';
439: ELSE
440: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_UNKNOWN_CHART');

Line 440: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_UNKNOWN_CHART');

436: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_TL_ACCESSORIALS');
437: ELSIF (g_chart_type = 'MIN_MODIFIER') THEN
438: l_tokens(l_tokens.COUNT) := 'LTL and/or Parcel Modifier';
439: ELSE
440: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_UNKNOWN_CHART');
441: END IF;
442:
443: l_tokens.EXTEND;
444: IF (l_attribute1 = 'FTE_RATE_CHART') THEN

Line 445: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_RATE_CHART');

441: END IF;
442:
443: l_tokens.EXTEND;
444: IF (l_attribute1 = 'FTE_RATE_CHART') THEN
445: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_RATE_CHART');
446: ELSIF (l_attribute1 = 'TL_RATE_CHART') THEN
447: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_TL_RATE_CHART');
448: ELSIF (l_attribute1 = 'LTL_RC') THEN
449: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_LTL_RATE_CHART');

Line 447: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_TL_RATE_CHART');

443: l_tokens.EXTEND;
444: IF (l_attribute1 = 'FTE_RATE_CHART') THEN
445: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_RATE_CHART');
446: ELSIF (l_attribute1 = 'TL_RATE_CHART') THEN
447: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_TL_RATE_CHART');
448: ELSIF (l_attribute1 = 'LTL_RC') THEN
449: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_LTL_RATE_CHART');
450: ELSIF (l_attribute1 = 'FAC_RATE_CHART') THEN
451: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_FAC_RATE_CHART');

Line 449: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_LTL_RATE_CHART');

445: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_RATE_CHART');
446: ELSIF (l_attribute1 = 'TL_RATE_CHART') THEN
447: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_TL_RATE_CHART');
448: ELSIF (l_attribute1 = 'LTL_RC') THEN
449: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_LTL_RATE_CHART');
450: ELSIF (l_attribute1 = 'FAC_RATE_CHART') THEN
451: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_FAC_RATE_CHART');
452: ELSIF (l_attribute1 = 'FTE_MODIFIER') THEN
453: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_CHARGES_DISCOUNTS');

Line 451: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_FAC_RATE_CHART');

447: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_TL_RATE_CHART');
448: ELSIF (l_attribute1 = 'LTL_RC') THEN
449: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_LTL_RATE_CHART');
450: ELSIF (l_attribute1 = 'FAC_RATE_CHART') THEN
451: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_FAC_RATE_CHART');
452: ELSIF (l_attribute1 = 'FTE_MODIFIER') THEN
453: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_CHARGES_DISCOUNTS');
454: ELSIF (l_attribute1 = 'FAC_MODIFIER') THEN
455: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_FAC_CHARGES');

Line 453: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_CHARGES_DISCOUNTS');

449: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_LTL_RATE_CHART');
450: ELSIF (l_attribute1 = 'FAC_RATE_CHART') THEN
451: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_FAC_RATE_CHART');
452: ELSIF (l_attribute1 = 'FTE_MODIFIER') THEN
453: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_CHARGES_DISCOUNTS');
454: ELSIF (l_attribute1 = 'FAC_MODIFIER') THEN
455: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_FAC_CHARGES');
456: ELSIF (l_attribute1 = 'TL_MODIFIER') THEN
457: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_TL_ACCESSORIALS');

Line 455: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_FAC_CHARGES');

451: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_FAC_RATE_CHART');
452: ELSIF (l_attribute1 = 'FTE_MODIFIER') THEN
453: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_CHARGES_DISCOUNTS');
454: ELSIF (l_attribute1 = 'FAC_MODIFIER') THEN
455: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_FAC_CHARGES');
456: ELSIF (l_attribute1 = 'TL_MODIFIER') THEN
457: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_TL_ACCESSORIALS');
458: ELSIF (l_attribute1 = 'MIN_MODIFIER') THEN
459: l_tokens(l_tokens.COUNT) := 'LTL and/or Parcel Modifier';

Line 457: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_TL_ACCESSORIALS');

453: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_CHARGES_DISCOUNTS');
454: ELSIF (l_attribute1 = 'FAC_MODIFIER') THEN
455: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_FAC_CHARGES');
456: ELSIF (l_attribute1 = 'TL_MODIFIER') THEN
457: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_TL_ACCESSORIALS');
458: ELSIF (l_attribute1 = 'MIN_MODIFIER') THEN
459: l_tokens(l_tokens.COUNT) := 'LTL and/or Parcel Modifier';
460: ELSE
461: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_UNKNOWN_CHART');

Line 461: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_UNKNOWN_CHART');

457: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_TL_ACCESSORIALS');
458: ELSIF (l_attribute1 = 'MIN_MODIFIER') THEN
459: l_tokens(l_tokens.COUNT) := 'LTL and/or Parcel Modifier';
460: ELSE
461: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_UNKNOWN_CHART');
462: END IF;
463:
464: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_DELETE_TYPE_WRONG',
465: p_tokens => STRINGARRAY('NAME', 'TYPE', 'ACTUAL'),

Line 464: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_DELETE_TYPE_WRONG',

460: ELSE
461: l_tokens(l_tokens.COUNT) := FTE_UTIL_PKG.GET_MSG('FTE_UNKNOWN_CHART');
462: END IF;
463:
464: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_DELETE_TYPE_WRONG',
465: p_tokens => STRINGARRAY('NAME', 'TYPE', 'ACTUAL'),
466: p_values => l_tokens);
467:
468: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

Line 468: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

464: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_DELETE_TYPE_WRONG',
465: p_tokens => STRINGARRAY('NAME', 'TYPE', 'ACTUAL'),
466: p_values => l_tokens);
467:
468: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
469: p_msg => x_error_msg,
470: p_category => 'D',
471: p_line_number => p_line_number);
472:

Line 474: FTE_UTIL_PKG.Exit_Debug(l_module_name);

470: p_category => 'D',
471: p_line_number => p_line_number);
472:
473: x_status := 2;
474: FTE_UTIL_PKG.Exit_Debug(l_module_name);
475: RETURN;
476: END IF;
477:
478: ELSE

Line 483: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_PRICELIST_INVALID',

479: l_list_header_id := p_list_header_id;
480: END IF;
481:
482: IF (l_list_header_id = -1) THEN
483: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_PRICELIST_INVALID',
484: p_tokens => STRINGARRAY('NAME'),
485: p_values => STRINGARRAY(p_name));
486:
487: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

Line 487: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

483: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_PRICELIST_INVALID',
484: p_tokens => STRINGARRAY('NAME'),
485: p_values => STRINGARRAY(p_name));
486:
487: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
488: p_msg => x_error_msg,
489: p_category => 'C',
490: p_line_number => p_line_number);
491:

Line 493: FTE_UTIL_PKG.Exit_Debug(l_module_name);

489: p_category => 'C',
490: p_line_number => p_line_number);
491:
492: x_status := 2;
493: FTE_UTIL_PKG.Exit_Debug(l_module_name);
494: RETURN;
495: ELSIF (p_action = 'DELETE') THEN
496: IF (g_chart_type = 'FAC_MODIFIER') THEN
497: x_status := Check_Facilities(l_list_header_id, x_status, x_error_msg);

Line 506: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

502: x_status => x_status,
503: x_error_msg => x_error_msg);
504:
505: IF (x_status <> -1) THEN
506: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
507: RETURN;
508: END IF;
509:
510: END IF;

Line 515: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Deleting data for Pricelist ID ' || l_list_header_id);

511: END IF;
512:
513: IF (x_status = -1) THEN
514: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
515: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Deleting data for Pricelist ID ' || l_list_header_id);
516: END IF;
517:
518: DELETE FROM qp_pricing_attributes
519: WHERE list_header_id = l_list_header_id;

Line 522: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Deleted ' || sql%rowcount || ' attributes.');

518: DELETE FROM qp_pricing_attributes
519: WHERE list_header_id = l_list_header_id;
520:
521: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
522: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Deleted ' || sql%rowcount || ' attributes.');
523: END IF;
524:
525: delete from qp_rltd_modifiers
526: where from_rltd_modifier_id in (select list_line_id

Line 534: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Deleted ' || sql%rowcount || ' List Lines.');

530: delete from qp_list_lines
531: where list_header_id = l_list_header_id;
532:
533: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
534: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Deleted ' || sql%rowcount || ' List Lines.');
535: END IF;
536:
537: --Note: For TL Rate Charts and Modifiers, we keep all the qualifiers.
538: IF (p_action = 'UPDATE' AND g_chart_type IN ('FTE_MODIFIER') AND p_delete_qualifier) THEN

Line 544: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Deleted ' || sql%rowcount || ' qualifiers.');

540: where list_header_id = l_list_header_id
541: and qualifier_context <> 'PARTY';
542:
543: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
544: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Deleted ' || sql%rowcount || ' qualifiers.');
545: END IF;
546: END IF;
547:
548: -- UPDATE doesn't delete from Headers and Qualifiers

Line 554: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Deleted ' || sql%rowcount || ' qualifiers.');

550: delete from qp_qualifiers
551: where list_header_id = l_list_header_id;
552:
553: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
554: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Deleted ' || sql%rowcount || ' qualifiers.');
555: END IF;
556:
557: delete from qp_list_headers_b
558: where list_header_id =l_list_header_id;

Line 570: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Deleted ' || sql%rowcount || ' prc_parameters.');

566: WHERE list_header_id = l_list_header_id
567: AND parameter_id in (57, 58, 59, 60);
568:
569: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
570: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Deleted ' || sql%rowcount || ' prc_parameters.');
571: END IF;
572:
573: END IF;
574: END IF;

Line 577: FTE_UTIL_PKG.Exit_Debug(l_module_name);

573: END IF;
574: END IF;
575: END IF;
576:
577: FTE_UTIL_PKG.Exit_Debug(l_module_name);
578: EXCEPTION WHEN OTHERS THEN
579: x_error_msg := sqlerrm;
580: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
581: p_msg => x_error_msg,

Line 580: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

576:
577: FTE_UTIL_PKG.Exit_Debug(l_module_name);
578: EXCEPTION WHEN OTHERS THEN
579: x_error_msg := sqlerrm;
580: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
581: p_msg => x_error_msg,
582: p_category => 'O',
583: p_line_number => p_line_number);
584: x_status := 1;

Line 585: FTE_UTIL_PKG.Exit_Debug(l_module_name);

581: p_msg => x_error_msg,
582: p_category => 'O',
583: p_line_number => p_line_number);
584: x_status := 1;
585: FTE_UTIL_PKG.Exit_Debug(l_module_name);
586: RETURN;
587: END DELETE_FROM_QP;
588:
589: -----------------------------------------------------------------------------

Line 634: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);

630: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.REPLACE_RATE_CHART';
631:
632: BEGIN
633:
634: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
635:
636: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
637: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Old Rate Chart Id', p_old_id);
638: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'New Name', p_new_name);

Line 637: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Old Rate Chart Id', p_old_id);

633:
634: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
635:
636: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
637: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Old Rate Chart Id', p_old_id);
638: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'New Name', p_new_name);
639: END IF;
640: x_status := -1;
641:

Line 638: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'New Name', p_new_name);

634: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
635:
636: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
637: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Old Rate Chart Id', p_old_id);
638: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'New Name', p_new_name);
639: END IF;
640: x_status := -1;
641:
642: BEGIN

Line 653: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

649:
650: EXCEPTION
651: WHEN OTHERS THEN
652: x_error_msg := sqlerrm;
653: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
654: p_msg => x_error_msg,
655: p_category => 'O');
656:
657: x_status := 2;

Line 658: FTE_UTIL_PKG.Exit_Debug(l_module_name);

654: p_msg => x_error_msg,
655: p_category => 'O');
656:
657: x_status := 2;
658: FTE_UTIL_PKG.Exit_Debug(l_module_name);
659: RETURN;
660: END;
661:
662: OPEN updated_lanes;

Line 668: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Update Lane ' || l_lane_id || ' with new rate chart id ' || l_new_id);

664: FETCH updated_lanes INTO l_lane_id;
665: EXIT WHEN updated_lanes%NOTFOUND;
666:
667: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
668: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Update Lane ' || l_lane_id || ' with new rate chart id ' || l_new_id);
669: END IF;
670:
671: -- Update FTE_LANE_RATE_CHARTS
672: UPDATE fte_lane_rate_charts

Line 682: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Update expiry date of old rate chart');

678: AND lane_id = l_lane_id;
679:
680: -- Update QP_LIST_HEADERS_B
681: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
682: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Update expiry date of old rate chart');
683: END IF;
684:
685: UPDATE qp_list_headers_b
686: SET end_date_active = LEAST(end_date_active, l_new_start_date-0.00001),

Line 701: x_error_msg := FTE_UTIL_PKG.GET_MSG('FTE_RC_REPLACE_OVERLAP');

697: x_status => x_status,
698: x_error_msg => x_error_msg);
699: IF (l_overlap) THEN
700: --x_error_msg := 'Rate Chart cannot be replace since the new one overlaps the existing ones';
701: x_error_msg := FTE_UTIL_PKG.GET_MSG('FTE_RC_REPLACE_OVERLAP');
702: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
703: p_msg => x_error_msg,
704: p_category => 'D');
705:

Line 702: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

698: x_error_msg => x_error_msg);
699: IF (l_overlap) THEN
700: --x_error_msg := 'Rate Chart cannot be replace since the new one overlaps the existing ones';
701: x_error_msg := FTE_UTIL_PKG.GET_MSG('FTE_RC_REPLACE_OVERLAP');
702: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
703: p_msg => x_error_msg,
704: p_category => 'D');
705:
706: x_status := 2;

Line 707: FTE_UTIL_PKG.Exit_Debug(l_module_name);

703: p_msg => x_error_msg,
704: p_category => 'D');
705:
706: x_status := 2;
707: FTE_UTIL_PKG.Exit_Debug(l_module_name);
708: return;
709: END IF;
710:
711: l_lane_rate_chart_tbl(1).lane_id := l_lane_id;

Line 725: FTE_UTIL_PKG.Exit_Debug(l_module_name);

721: x_error_msg => x_error_msg);
722:
723: END LOOP;
724: CLOSE updated_lanes;
725: FTE_UTIL_PKG.Exit_Debug(l_module_name);
726:
727: EXCEPTION
728: WHEN OTHERS THEN
729: IF (updated_lanes%ISOPEN) THEN

Line 733: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

729: IF (updated_lanes%ISOPEN) THEN
730: CLOSE updated_lanes;
731: END IF;
732: x_error_msg := sqlerrm;
733: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
734: p_msg => x_error_msg,
735: p_category => 'O');
736:
737: x_status := 2;

Line 738: FTE_UTIL_PKG.Exit_Debug(l_module_name);

734: p_msg => x_error_msg,
735: p_category => 'O');
736:
737: x_status := 2;
738: FTE_UTIL_PKG.Exit_Debug(l_module_name);
739: RETURN;
740: END Replace_Rate_Chart;
741:
742: -----------------------------------------------------------------------------

Line 851: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);

847: AT_LIST_LINE_NO NUMBER_TAB;
848: l_count NUMBER;
849:
850: BEGIN
851: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
852:
853: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
854: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of rate chart header', p_qp_list_header_tbl.COUNT);
855: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of rate chart line', p_qp_list_line_tbl.COUNT);

Line 854: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of rate chart header', p_qp_list_header_tbl.COUNT);

850: BEGIN
851: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
852:
853: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
854: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of rate chart header', p_qp_list_header_tbl.COUNT);
855: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of rate chart line', p_qp_list_line_tbl.COUNT);
856: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of qualifier', p_qp_qualifier_tbl.COUNT);
857: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of pricing attribute', p_qp_pricing_attrib_tbl.COUNT);
858: END IF;

Line 855: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of rate chart line', p_qp_list_line_tbl.COUNT);

851: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
852:
853: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
854: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of rate chart header', p_qp_list_header_tbl.COUNT);
855: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of rate chart line', p_qp_list_line_tbl.COUNT);
856: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of qualifier', p_qp_qualifier_tbl.COUNT);
857: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of pricing attribute', p_qp_pricing_attrib_tbl.COUNT);
858: END IF;
859: x_status := -1;

Line 856: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of qualifier', p_qp_qualifier_tbl.COUNT);

852:
853: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
854: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of rate chart header', p_qp_list_header_tbl.COUNT);
855: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of rate chart line', p_qp_list_line_tbl.COUNT);
856: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of qualifier', p_qp_qualifier_tbl.COUNT);
857: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of pricing attribute', p_qp_pricing_attrib_tbl.COUNT);
858: END IF;
859: x_status := -1;
860:

Line 857: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of pricing attribute', p_qp_pricing_attrib_tbl.COUNT);

853: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
854: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of rate chart header', p_qp_list_header_tbl.COUNT);
855: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of rate chart line', p_qp_list_line_tbl.COUNT);
856: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of qualifier', p_qp_qualifier_tbl.COUNT);
857: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of pricing attribute', p_qp_pricing_attrib_tbl.COUNT);
858: END IF;
859: x_status := -1;
860:
861: IF (p_qp_list_header_tbl.COUNT > 0) THEN

Line 932: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, '[Inserting rate chart header]');

928:
929: EXCEPTION
930: WHEN OTHERS THEN
931: x_error_msg := sqlerrm;
932: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, '[Inserting rate chart header]');
933: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
934: p_msg => x_error_msg,
935: p_category => 'O');
936:

Line 933: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

929: EXCEPTION
930: WHEN OTHERS THEN
931: x_error_msg := sqlerrm;
932: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, '[Inserting rate chart header]');
933: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
934: p_msg => x_error_msg,
935: p_category => 'O');
936:
937: x_status := 1;

Line 938: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

934: p_msg => x_error_msg,
935: p_category => 'O');
936:
937: x_status := 1;
938: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
939: p_qp_list_header_tbl.DELETE;
940: p_qp_list_line_tbl.DELETE;
941: p_qp_qualifier_tbl.DELETE;
942: p_qp_pricing_attrib_tbl.DELETE;

Line 992: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, '[Inserting qualifier]');

988: FND_GLOBAL.USER_ID);
989: EXCEPTION
990: WHEN OTHERS THEN
991: x_error_msg := sqlerrm;
992: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, '[Inserting qualifier]');
993: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
994: p_msg => x_error_msg,
995: p_category => 'O');
996:

Line 993: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

989: EXCEPTION
990: WHEN OTHERS THEN
991: x_error_msg := sqlerrm;
992: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, '[Inserting qualifier]');
993: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
994: p_msg => x_error_msg,
995: p_category => 'O');
996:
997: x_status := 1;

Line 998: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

994: p_msg => x_error_msg,
995: p_category => 'O');
996:
997: x_status := 1;
998: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
999: p_qp_list_header_tbl.DELETE;
1000: p_qp_list_line_tbl.DELETE;
1001: p_qp_qualifier_tbl.DELETE;
1002: p_qp_pricing_attrib_tbl.DELETE;

Line 1112: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, '[Inserting rate chart lines]');

1108: FND_GLOBAL.USER_ID);
1109: EXCEPTION
1110: WHEN OTHERS THEN
1111: x_error_msg := sqlerrm;
1112: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, '[Inserting rate chart lines]');
1113: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1114: p_msg => x_error_msg,
1115: p_category => 'O');
1116:

Line 1113: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

1109: EXCEPTION
1110: WHEN OTHERS THEN
1111: x_error_msg := sqlerrm;
1112: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, '[Inserting rate chart lines]');
1113: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1114: p_msg => x_error_msg,
1115: p_category => 'O');
1116:
1117: x_status := 1;

Line 1118: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

1114: p_msg => x_error_msg,
1115: p_category => 'O');
1116:
1117: x_status := 1;
1118: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
1119: p_qp_list_header_tbl.DELETE;
1120: p_qp_list_line_tbl.DELETE;
1121: p_qp_qualifier_tbl.DELETE;
1122: p_qp_pricing_attrib_tbl.DELETE;

Line 1133: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

1129: IF (g_region_flag IS NOT NULL AND g_process_id IS NOT NULL) THEN
1130: l_region_id := FTE_REGION_ZONE_LOADER.Get_Region_ID(p_region_info => G_region_info);
1131:
1132: IF (x_status <> -1) THEN
1133: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
1134: p_qp_list_header_tbl.DELETE;
1135: p_qp_list_line_tbl.DELETE;
1136: p_qp_qualifier_tbl.DELETE;
1137: p_qp_pricing_attrib_tbl.DELETE;

Line 1153: x_error_msg := Fte_Util_PKG.Get_Msg(p_name => 'FTE_CAT_REGION_UNKNOWN',

1149: x_status => x_status,
1150: x_error_msg => x_error_msg);
1151: ELSE
1152: x_status := 2;
1153: x_error_msg := Fte_Util_PKG.Get_Msg(p_name => 'FTE_CAT_REGION_UNKNOWN',
1154: p_tokens => STRINGARRAY('NAME'),
1155: p_values => STRINGARRAY(g_region_flag));
1156:
1157: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name, --check

Line 1157: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name, --check

1153: x_error_msg := Fte_Util_PKG.Get_Msg(p_name => 'FTE_CAT_REGION_UNKNOWN',
1154: p_tokens => STRINGARRAY('NAME'),
1155: p_values => STRINGARRAY(g_region_flag));
1156:
1157: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name, --check
1158: p_msg => x_error_msg,
1159: p_category => 'D');
1160:
1161: reset_region_info;

Line 1162: FTE_UTIL_PKG.Exit_Debug(l_module_name);

1158: p_msg => x_error_msg,
1159: p_category => 'D');
1160:
1161: reset_region_info;
1162: FTE_UTIL_PKG.Exit_Debug(l_module_name);
1163: p_qp_list_header_tbl.DELETE;
1164: p_qp_list_line_tbl.DELETE;
1165: p_qp_qualifier_tbl.DELETE;
1166: p_qp_pricing_attrib_tbl.DELETE;

Line 1243: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, '[Inserting attributes]');

1239:
1240: EXCEPTION
1241: WHEN OTHERS THEN
1242: x_error_msg := sqlerrm;
1243: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, '[Inserting attributes]');
1244: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1245: p_msg => x_error_msg,
1246: p_category => 'O');
1247: x_status := 1;

Line 1244: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

1240: EXCEPTION
1241: WHEN OTHERS THEN
1242: x_error_msg := sqlerrm;
1243: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, '[Inserting attributes]');
1244: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1245: p_msg => x_error_msg,
1246: p_category => 'O');
1247: x_status := 1;
1248: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

Line 1248: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);

1244: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1245: p_msg => x_error_msg,
1246: p_category => 'O');
1247: x_status := 1;
1248: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
1249: p_qp_list_header_tbl.DELETE;
1250: p_qp_list_line_tbl.DELETE;
1251: p_qp_qualifier_tbl.DELETE;
1252: p_qp_pricing_attrib_tbl.DELETE;

Line 1275: FTE_UTIL_PKG.Exit_Debug(l_module_name);

1271: p_qp_list_header_tbl.DELETE;
1272: p_qp_list_line_tbl.DELETE;
1273: p_qp_qualifier_tbl.DELETE;
1274: p_qp_pricing_attrib_tbl.DELETE;
1275: FTE_UTIL_PKG.Exit_Debug(l_module_name);
1276: return;
1277: END IF;
1278: --+
1279: -- For Generating Output file

Line 1281: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

1277: END IF;
1278: --+
1279: -- For Generating Output file
1280: --+
1281: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1282: p_msg_name => 'FTE_RATECHARTS_LOADED',
1283: p_category => NULL);
1284:
1285: FOR i in LH_NAME.FIRST..LH_NAME.LAST LOOP

Line 1287: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

1283: p_category => NULL);
1284:
1285: FOR i in LH_NAME.FIRST..LH_NAME.LAST LOOP
1286:
1287: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1288: p_msg => LH_NAME(i),
1289: p_category => NULL);
1290: END LOOP;
1291:

Line 1300: FTE_UTIL_PKG.Exit_Debug(l_module_name);

1296: p_qp_list_header_tbl.DELETE;
1297: p_qp_list_line_tbl.DELETE;
1298: p_qp_qualifier_tbl.DELETE;
1299: p_qp_pricing_attrib_tbl.DELETE;
1300: FTE_UTIL_PKG.Exit_Debug(l_module_name);
1301: EXCEPTION WHEN OTHERS THEN
1302: -- IF (GET_CURRENCY_HEADER_ID%ISOPEN) THEN
1303: -- CLOSE GET_CURRENCY_HEADER_ID;
1304: -- END IF;

Line 1307: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

1303: -- CLOSE GET_CURRENCY_HEADER_ID;
1304: -- END IF;
1305: x_error_msg := sqlerrm;
1306: x_status := 2;
1307: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1308: p_msg => x_error_msg,
1309: p_category => 'O');
1310:
1311: FTE_UTIL_PKG.Exit_Debug(l_module_name);

Line 1311: FTE_UTIL_PKG.Exit_Debug(l_module_name);

1307: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1308: p_msg => x_error_msg,
1309: p_category => 'O');
1310:
1311: FTE_UTIL_PKG.Exit_Debug(l_module_name);
1312: p_qp_list_header_tbl.DELETE;
1313: p_qp_list_line_tbl.DELETE;
1314: p_qp_qualifier_tbl.DELETE;
1315: p_qp_pricing_attrib_tbl.DELETE;

Line 1372: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);

1368: AND modc.language = userenv('LANG')
1369: ORDER BY rc.creation_date DESC;
1370:
1371: BEGIN
1372: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
1373:
1374: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1375: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'List Header ID', p_list_header_id);
1376: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Rate Chart Name', p_pricelist_name);

Line 1375: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'List Header ID', p_list_header_id);

1371: BEGIN
1372: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
1373:
1374: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1375: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'List Header ID', p_list_header_id);
1376: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Rate Chart Name', p_pricelist_name);
1377: END IF;
1378:
1379: IF (p_list_header_id IS NOT NULL) THEN

Line 1376: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Rate Chart Name', p_pricelist_name);

1372: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
1373:
1374: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1375: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'List Header ID', p_list_header_id);
1376: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Rate Chart Name', p_pricelist_name);
1377: END IF;
1378:
1379: IF (p_list_header_id IS NOT NULL) THEN
1380: OPEN Get_Modifiers_With_ID;

Line 1388: FTE_UTIL_PKG.Exit_Debug(l_module_name);

1384: OPEN Get_Modifiers_With_Name;
1385: FETCH Get_Modifiers_With_Name BULK COLLECT INTO l_mod_ids;
1386: CLOSE Get_Modifiers_With_Name;
1387: END IF;
1388: FTE_UTIL_PKG.Exit_Debug(l_module_name);
1389: return l_mod_ids;
1390: EXCEPTION WHEN OTHERS THEN
1391: IF (Get_Modifiers_With_Name%ISOPEN) THEN
1392: CLOSE Get_Modifiers_With_Name;

Line 1397: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

1393: END IF;
1394: IF (Get_Modifiers_With_ID%ISOPEN) THEN
1395: CLOSE Get_Modifiers_With_ID;
1396: END IF;
1397: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1398: p_msg => sqlerrm,
1399: p_category => 'O');
1400:
1401: FTE_UTIL_PKG.Exit_Debug(l_module_name);

Line 1401: FTE_UTIL_PKG.Exit_Debug(l_module_name);

1397: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1398: p_msg => sqlerrm,
1399: p_category => 'O');
1400:
1401: FTE_UTIL_PKG.Exit_Debug(l_module_name);
1402: RAISE;
1403: END Get_Assoc_Modifiers;
1404:
1405: -----------------------------------------------------------------------------

Line 1459: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);

1455: ORDER BY rc.creation_date DESC;
1456:
1457:
1458: BEGIN
1459: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
1460:
1461: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1462: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'List Header ID', p_list_header_id);
1463: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Modifier Name', p_modifier_name);

Line 1462: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'List Header ID', p_list_header_id);

1458: BEGIN
1459: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
1460:
1461: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1462: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'List Header ID', p_list_header_id);
1463: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Modifier Name', p_modifier_name);
1464: END IF;
1465:
1466: IF (p_list_header_id IS NOT NULL) THEN

Line 1463: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Modifier Name', p_modifier_name);

1459: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
1460:
1461: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1462: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'List Header ID', p_list_header_id);
1463: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Modifier Name', p_modifier_name);
1464: END IF;
1465:
1466: IF (p_list_header_id IS NOT NULL) THEN
1467: OPEN Get_Pricelists_With_ID;

Line 1476: FTE_UTIL_PKG.Exit_Debug(l_module_name);

1472: FETCH Get_Pricelists_With_Name BULK COLLECT INTO l_mod_ids;
1473: CLOSE Get_Pricelists_With_Name;
1474: END IF;
1475:
1476: FTE_UTIL_PKG.Exit_Debug(l_module_name);
1477: return L_MOD_IDS;
1478: EXCEPTION WHEN OTHERS THEN
1479: IF (Get_Pricelists_With_Name%ISOPEN) THEN
1480: CLOSE Get_Pricelists_With_Name;

Line 1485: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

1481: END IF;
1482: IF (Get_Pricelists_With_ID%ISOPEN) THEN
1483: CLOSE Get_Pricelists_With_ID;
1484: END IF;
1485: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1486: p_msg => sqlerrm,
1487: p_category => 'O');
1488:
1489: FTE_UTIL_PKG.Exit_Debug(l_module_name);

Line 1489: FTE_UTIL_PKG.Exit_Debug(l_module_name);

1485: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1486: p_msg => sqlerrm,
1487: p_category => 'O');
1488:
1489: FTE_UTIL_PKG.Exit_Debug(l_module_name);
1490: RAISE;
1491: END GET_ASSOC_PRICELISTS;
1492:
1493:

Line 1579: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);

1575: b.attribute1 = 'TL_RATE_CHART' AND
1576: lh.language = userenv('LANG');
1577:
1578: BEGIN
1579: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
1580:
1581: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1582: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Type of Chart', p_chart_type);
1583: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Process ID', p_process_id);

Line 1582: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Type of Chart', p_chart_type);

1578: BEGIN
1579: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
1580:
1581: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1582: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Type of Chart', p_chart_type);
1583: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Process ID', p_process_id);
1584: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of Chart Name', p_name.COUNT);
1585: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of Currency', p_currency.COUNT);
1586: END IF;

Line 1583: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Process ID', p_process_id);

1579: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
1580:
1581: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1582: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Type of Chart', p_chart_type);
1583: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Process ID', p_process_id);
1584: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of Chart Name', p_name.COUNT);
1585: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of Currency', p_currency.COUNT);
1586: END IF;
1587: x_status := -1;

Line 1584: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of Chart Name', p_name.COUNT);

1580:
1581: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1582: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Type of Chart', p_chart_type);
1583: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Process ID', p_process_id);
1584: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of Chart Name', p_name.COUNT);
1585: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of Currency', p_currency.COUNT);
1586: END IF;
1587: x_status := -1;
1588:

Line 1585: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of Currency', p_currency.COUNT);

1581: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1582: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Type of Chart', p_chart_type);
1583: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Process ID', p_process_id);
1584: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of Chart Name', p_name.COUNT);
1585: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of Currency', p_currency.COUNT);
1586: END IF;
1587: x_status := -1;
1588:
1589: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

Line 1590: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Calling QP_PRL_LOADER_PUB.Load_Price_List');

1586: END IF;
1587: x_status := -1;
1588:
1589: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1590: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Calling QP_PRL_LOADER_PUB.Load_Price_List');
1591: END IF;
1592:
1593: FND_PROFILE.PUT('QP_PRICING_TRANSACTION_ENTITY', 'LOGSTX');
1594: FND_PROFILE.PUT('QP_SOURCE_SYSTEM_CODE', 'FTE');

Line 1609: x_error_msg := FTE_UTIL_PKG.GET_MSG('FTE_CHART_TYPE_NULL');

1605: x_status => l_status,
1606: x_errors => l_sql_errors);
1607:
1608: ELSE
1609: x_error_msg := FTE_UTIL_PKG.GET_MSG('FTE_CHART_TYPE_NULL');
1610: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1611: p_msg => x_error_msg,
1612: p_category => 'O');
1613:

Line 1610: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

1606: x_errors => l_sql_errors);
1607:
1608: ELSE
1609: x_error_msg := FTE_UTIL_PKG.GET_MSG('FTE_CHART_TYPE_NULL');
1610: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1611: p_msg => x_error_msg,
1612: p_category => 'O');
1613:
1614: x_status := 2;

Line 1615: FTE_UTIL_PKG.Exit_Debug(l_module_name);

1611: p_msg => x_error_msg,
1612: p_category => 'O');
1613:
1614: x_status := 2;
1615: FTE_UTIL_PKG.Exit_Debug(l_module_name);
1616: RETURN;
1617:
1618: END IF;
1619:

Line 1622: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_QP_ERROR',

1618: END IF;
1619:
1620: --check for errors
1621: IF (l_status <> 'COMPLETED') THEN
1622: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_QP_ERROR',
1623: p_tokens => STRINGARRAY('STATUS', 'ERROR'),
1624: p_values => STRINGARRAY(l_status, substr(l_sql_errors, 0, 700)));
1625:
1626: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

Line 1626: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

1622: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_QP_ERROR',
1623: p_tokens => STRINGARRAY('STATUS', 'ERROR'),
1624: p_values => STRINGARRAY(l_status, substr(l_sql_errors, 0, 700)));
1625:
1626: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1627: p_msg => x_error_msg,
1628: p_category => 'O');
1629:
1630: x_status := 2;

Line 1631: FTE_UTIL_PKG.Exit_Debug(l_module_name);

1627: p_msg => x_error_msg,
1628: p_category => 'O');
1629:
1630: x_status := 2;
1631: FTE_UTIL_PKG.Exit_Debug(l_module_name);
1632: ELSE
1633:
1634: --For Parcel Rate Charts. Assumes that there is only one rate
1635: --chart in the spread sheet. **

Line 1638: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'REPLACING RATE CHART ');

1634: --For Parcel Rate Charts. Assumes that there is only one rate
1635: --chart in the spread sheet. **
1636: IF (LH_REPLACE_RC.COUNT > 0) THEN
1637: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1638: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'REPLACING RATE CHART ');
1639: END IF;
1640:
1641: Replace_Rate_Chart(p_old_id => LH_REPLACE_RC(1),
1642: p_new_name => LH_NEW_RC(1),

Line 1647: FTE_UTIL_PKG.Exit_Debug(l_module_name);

1643: x_status => x_status,
1644: x_error_msg => x_error_msg);
1645:
1646: IF (x_status <> -1) THEN
1647: FTE_UTIL_PKG.Exit_Debug(l_module_name);
1648: RETURN;
1649: END IF;
1650:
1651: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

Line 1652: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, LH_REPLACE_RC(1) || ' => ' || LH_NEW_RC(1));

1648: RETURN;
1649: END IF;
1650:
1651: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1652: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, LH_REPLACE_RC(1) || ' => ' || LH_NEW_RC(1));
1653: END IF;
1654: END IF;
1655: END IF;
1656:

Line 1676: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_MULTI_CURR_DISABLED');

1672: FETCH GET_CURRENCY_HEADER_ID INTO l_currency_header_id;
1673: CLOSE GET_CURRENCY_HEADER_ID;
1674:
1675: IF (l_currency_header_id IS NULL) THEN
1676: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_MULTI_CURR_DISABLED');
1677: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1678: p_msg => x_error_msg,
1679: p_category => 'B');
1680: x_status := 2;

Line 1677: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

1673: CLOSE GET_CURRENCY_HEADER_ID;
1674:
1675: IF (l_currency_header_id IS NULL) THEN
1676: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_MULTI_CURR_DISABLED');
1677: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1678: p_msg => x_error_msg,
1679: p_category => 'B');
1680: x_status := 2;
1681: FTE_UTIL_PKG.Exit_Debug(l_module_name);

Line 1681: FTE_UTIL_PKG.Exit_Debug(l_module_name);

1677: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1678: p_msg => x_error_msg,
1679: p_category => 'B');
1680: x_status := 2;
1681: FTE_UTIL_PKG.Exit_Debug(l_module_name);
1682: RETURN;
1683: END IF;
1684:
1685: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

Line 1686: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Currency Header Id', l_currency_header_id);

1682: RETURN;
1683: END IF;
1684:
1685: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1686: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Currency Header Id', l_currency_header_id);
1687: END IF;
1688:
1689: OPEN CONVERSION_EXIST(l_currency_header_id, p_currency(j));
1690: FETCH CONVERSION_EXIST INTO l_result;

Line 1707: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Calling Process Currency');

1703: l_CURR_DETAILS_tbl(1).selling_rounding_factor := -2;
1704:
1705: -- Call the Multi-Currency Conversion Public API to create the header and lines
1706: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1707: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Calling Process Currency');
1708: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Currency', p_currency(j));
1709: END IF;
1710:
1711: QP_Currency_PUB.Process_Currency( p_api_version_number => 1.0

Line 1708: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Currency', p_currency(j));

1704:
1705: -- Call the Multi-Currency Conversion Public API to create the header and lines
1706: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1707: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Calling Process Currency');
1708: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Currency', p_currency(j));
1709: END IF;
1710:
1711: QP_Currency_PUB.Process_Currency( p_api_version_number => 1.0
1712: , x_return_status => l_return_status

Line 1729: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

1725:
1726: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1727: x_status := 2;
1728: x_error_msg := x_msg_data;
1729: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1730: p_msg => x_error_msg,
1731: p_category => 'O');
1732: FTE_UTIL_PKG.Exit_Debug(l_module_name);
1733: RETURN;

Line 1732: FTE_UTIL_PKG.Exit_Debug(l_module_name);

1728: x_error_msg := x_msg_data;
1729: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1730: p_msg => x_error_msg,
1731: p_category => 'O');
1732: FTE_UTIL_PKG.Exit_Debug(l_module_name);
1733: RETURN;
1734: END IF;
1735:
1736: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

Line 1737: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Process Currency successfully');

1733: RETURN;
1734: END IF;
1735:
1736: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1737: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Process Currency successfully');
1738: END IF;
1739:
1740: END IF;
1741: END LOOP;

Line 1747: FTE_UTIL_PKG.Exit_Debug(l_module_name);

1743: END LOOP;
1744: END IF;
1745:
1746:
1747: FTE_UTIL_PKG.Exit_Debug(l_module_name);
1748: EXCEPTION
1749: WHEN OTHERS THEN
1750: IF (GET_CURRENCY_HEADER_ID%ISOPEN) THEN
1751: CLOSE GET_CURRENCY_HEADER_ID;

Line 1763: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

1759: CLOSE GET_MOD_PRICELIST;
1760: END IF;
1761:
1762: x_error_msg := sqlerrm;
1763: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1764: p_msg => x_error_msg,
1765: p_category => 'O');
1766:
1767: x_status := 2;

Line 1768: FTE_UTIL_PKG.Exit_Debug(l_module_name);

1764: p_msg => x_error_msg,
1765: p_category => 'O');
1766:
1767: x_status := 2;
1768: FTE_UTIL_PKG.Exit_Debug(l_module_name);
1769: END QP_API_CALL;
1770:
1771: END FTE_RATE_CHART_PKG;