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_BULKLOAD_PKG

Line 168: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

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;
171:
172: x_status := -1;

Line 234: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

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);
237: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Attribute1', p_attribute1);
238: END IF;

Line 320: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

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);
323: END IF;
324:

Line 336: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

332: END IF;
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;

Line 392: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

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);
395: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Action', p_action);
396: END IF;

Line 514: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

510: END IF;
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

Line 521: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

517:
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

Line 533: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

529:
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.

Line 543: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

539: delete from qp_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:

Line 553: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

549: IF (p_action = 'DELETE') THEN
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

Line 569: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

565: DELETE FROM fte_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;

Line 636: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

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);
639: END IF;
640: x_status := -1;

Line 667: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

663: LOOP
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

Line 681: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

677: WHERE list_header_id = p_old_id
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

Line 853: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

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);
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);

Line 1374: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

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);
1377: END IF;
1378:

Line 1461: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

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);
1464: END IF;
1465:

Line 1581: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

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);
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);

Line 1589: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

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
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');

Line 1637: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

1633:
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),

Line 1651: IF (FTE_BULKLOAD_PKG.g_debug_on) 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
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;

Line 1685: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

1681: FTE_UTIL_PKG.Exit_Debug(l_module_name);
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));

Line 1706: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

1702: l_CURR_DETAILS_tbl(1).operation := QP_GLOBALS.G_OPR_CREATE;
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:

Line 1736: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

1732: FTE_UTIL_PKG.Exit_Debug(l_module_name);
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;