DBA Data[Home] [Help]

APPS.QP_COPY_MODIFIERS_PVT dependencies on FND_FILE

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

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

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

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

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

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

Line 1609: 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);

1605:
1606: FOR i IN l_non_cont_pbh_id_tbl.FIRST..l_non_cont_pbh_id_tbl.LAST
1607: LOOP
1608:
1609: 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);
1610:
1611: qp_delayed_requests_PVT.log_request
1612: ( p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR
1613: , p_entity_id => l_non_cont_pbh_id_tbl(i).price_break_header_id

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

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

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

1679:
1680: EXCEPTION
1681:
1682: WHEN OTHERS THEN
1683: fnd_file.put_line(FND_FILE.LOG,'Error in Copy Price list Routine ');
1684: fnd_file.put_line(FND_FILE.LOG,substr(sqlerrm,1,300));
1685: retcode := 2;
1686:
1687: END Copy_Discounts;

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

1680: EXCEPTION
1681:
1682: WHEN OTHERS THEN
1683: fnd_file.put_line(FND_FILE.LOG,'Error in Copy Price list Routine ');
1684: fnd_file.put_line(FND_FILE.LOG,substr(sqlerrm,1,300));
1685: retcode := 2;
1686:
1687: END Copy_Discounts;
1688: