DBA Data[Home] [Help]

APPS.QP_COPY_MODIFIERS_PVT dependencies on FND_FILE

Line 1597: fnd_file.put_line(FND_FILE.LOG,'Error in Update of denormalized columns in QP_Qualifiers');

1593:
1594:
1595: if retcode = 2 then
1596: --error from update denormalized columns
1597: fnd_file.put_line(FND_FILE.LOG,'Error in Update of denormalized columns in QP_Qualifiers');
1598: else
1599: fnd_file.put_line(FND_FILE.LOG,'Update of denormalized columns in QP_Qualifiers completed successfully');
1600: end if;
1601:

Line 1599: fnd_file.put_line(FND_FILE.LOG,'Update of denormalized columns in QP_Qualifiers completed successfully');

1595: if retcode = 2 then
1596: --error from update denormalized columns
1597: fnd_file.put_line(FND_FILE.LOG,'Error in Update of denormalized columns in QP_Qualifiers');
1598: else
1599: fnd_file.put_line(FND_FILE.LOG,'Update of denormalized columns in QP_Qualifiers completed successfully');
1600: end if;
1601:
1602: --Upgrade Non-Continuous Price Breaks
1603:

Line 1605: fnd_file.put_line(FND_FILE.LOG,'New List Name : '||p_new_price_list_name);

1601:
1602: --Upgrade Non-Continuous Price Breaks
1603:
1604: IF l_non_cont_pbh_id_tbl.COUNT > 0 THEN
1605: fnd_file.put_line(FND_FILE.LOG,'New List Name : '||p_new_price_list_name);
1606:
1607: FOR i IN l_non_cont_pbh_id_tbl.FIRST..l_non_cont_pbh_id_tbl.LAST
1608: LOOP
1609:

Line 1610: fnd_file.put_line(FND_FILE.LOG,'Upgrading non-continuous price breaks to continuous price breaks for the product : '||l_non_cont_pbh_id_tbl(i).product_attr_value);

1606:
1607: FOR i IN l_non_cont_pbh_id_tbl.FIRST..l_non_cont_pbh_id_tbl.LAST
1608: LOOP
1609:
1610: fnd_file.put_line(FND_FILE.LOG,'Upgrading non-continuous price breaks to continuous price breaks for the product : '||l_non_cont_pbh_id_tbl(i).product_attr_value);
1611:
1612: qp_delayed_requests_PVT.log_request
1613: ( p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR
1614: , p_entity_id => l_non_cont_pbh_id_tbl(i).price_break_header_id

Line 1633: fnd_file.put_line(FND_FILE.LOG,'Price list copy completed successfully');

1629: , x_return_status => l_return_status);
1630:
1631: END IF;
1632:
1633: fnd_file.put_line(FND_FILE.LOG,'Price list copy completed successfully');
1634:
1635: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
1636: select min(list_line_id), max(list_line_id)
1637: into l_min_list_line_id, l_max_list_line_id

Line 1664: fnd_file.put_line(FND_FILE.LOG,'Error in Copy Price list Routine ');

1660:
1661: EXCEPTION
1662:
1663: WHEN OTHERS THEN
1664: fnd_file.put_line(FND_FILE.LOG,'Error in Copy Price list Routine ');
1665: fnd_file.put_line(FND_FILE.LOG,substr(sqlerrm,1,300));
1666: retcode := 2;
1667:
1668: END Copy_Discounts;

Line 1665: fnd_file.put_line(FND_FILE.LOG,substr(sqlerrm,1,300));

1661: EXCEPTION
1662:
1663: WHEN OTHERS THEN
1664: fnd_file.put_line(FND_FILE.LOG,'Error in Copy Price list Routine ');
1665: fnd_file.put_line(FND_FILE.LOG,substr(sqlerrm,1,300));
1666: retcode := 2;
1667:
1668: END Copy_Discounts;
1669: