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.QP_COPY_PRICELIST_PVT dependencies on FND_FILE

Line 2102: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>category_set_id: '||nvl(p_category_set_id, 0));

2098: END IF;
2099:
2100: -- begin fix bug 4127037
2101: -- debug
2102: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>category_set_id: '||nvl(p_category_set_id, 0));
2103: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>category_id: '||nvl(p_category_id, 0));
2104:
2105: IF ( nvl(p_category_id, 0) <> 0 AND nvl(p_category_set_id, 0) <> 0) THEN
2106: l_select_stmt := l_select_stmt ||

Line 2103: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>category_id: '||nvl(p_category_id, 0));

2099:
2100: -- begin fix bug 4127037
2101: -- debug
2102: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>category_set_id: '||nvl(p_category_set_id, 0));
2103: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>category_id: '||nvl(p_category_id, 0));
2104:
2105: IF ( nvl(p_category_id, 0) <> 0 AND nvl(p_category_set_id, 0) <> 0) THEN
2106: l_select_stmt := l_select_stmt ||
2107: 'AND m.inventory_item_id IN

Line 2146: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||l_select_stmt);

2142: l_select_stmt := l_select_stmt || ') ';
2143: END IF;
2144:
2145: -- debug
2146: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||l_select_stmt);
2147:
2148: IF (p_category_id is null) and (p_category_set_id is null) then
2149: OPEN qp_list_lines_cv FOR l_select_stmt USING p_from_list_header_id;
2150: end if;

Line 2157: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'opened list_lines cursor');

2153: END IF;
2154: IF ( nvl(p_category_id, 0) = 0 AND nvl(p_category_set_id, 0) <> 0) THEN
2155: OPEN qp_list_lines_cv FOR l_select_stmt USING p_from_list_header_id,p_category_set_id;
2156: END IF;
2157: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'opened list_lines cursor');
2158:
2159: --This is the fetch loop
2160: LOOP
2161: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'inside loop ');

Line 2161: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'inside loop ');

2157: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'opened list_lines cursor');
2158:
2159: --This is the fetch loop
2160: LOOP
2161: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'inside loop ');
2162:
2163: --Insert each fetched record(Price List Line without Discount Line)
2164: --of the from_price_list into qp_list_lines(for the New Price List)
2165: --provided the segment values of the lines lie in the input ranges.

Line 2168: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'after fetch ');

2164: --of the from_price_list into qp_list_lines(for the New Price List)
2165: --provided the segment values of the lines lie in the input ranges.
2166:
2167: FETCH qp_list_lines_cv INTO l_qp_list_lines_rec;
2168: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'after fetch ');
2169: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'row count ' || qp_list_lines_cv%ROWCOUNT);
2170:
2171: EXIT WHEN qp_list_lines_cv%NOTFOUND;
2172: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'row count ' || qp_list_lines_cv%ROWCOUNT);

Line 2169: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'row count ' || qp_list_lines_cv%ROWCOUNT);

2165: --provided the segment values of the lines lie in the input ranges.
2166:
2167: FETCH qp_list_lines_cv INTO l_qp_list_lines_rec;
2168: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'after fetch ');
2169: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'row count ' || qp_list_lines_cv%ROWCOUNT);
2170:
2171: EXIT WHEN qp_list_lines_cv%NOTFOUND;
2172: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'row count ' || qp_list_lines_cv%ROWCOUNT);
2173:

Line 2172: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'row count ' || qp_list_lines_cv%ROWCOUNT);

2168: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'after fetch ');
2169: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'row count ' || qp_list_lines_cv%ROWCOUNT);
2170:
2171: EXIT WHEN qp_list_lines_cv%NOTFOUND;
2172: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'row count ' || qp_list_lines_cv%ROWCOUNT);
2173:
2174:
2175: /* Added for 3067774.When price listr line is end dated,its related lines e.g. child lines
2176: are still active. Cursor qp_list_lines_cv selects all active lines, therefore,

Line 2206: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'insert flag is ' || insert_flag);

2202: If l_cnt > 0 then
2203: insert_flag :='Y';
2204: End if;
2205: End if;
2206: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'insert flag is ' || insert_flag);
2207:
2208: If insert_flag ='Y' then /* end changes for bug3067774 */
2209:
2210:

Line 2400: fnd_file.put_line(FND_FILE.LOG,'Inserted line');

2396: ,to_char(l_qp_list_lines_rec.list_line_id) --7309992
2397: ,to_char(l_qp_list_lines_rec.list_header_id) --7309992
2398: --(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_list_header_id)
2399: );
2400: fnd_file.put_line(FND_FILE.LOG,'Inserted line');
2401: fnd_file.put_line(FND_FILE.LOG,'list_line_id ' || l_new_list_line_id);
2402: fnd_file.put_line(FND_FILE.LOG,'list_line_type_code ' || l_qp_list_lines_rec.list_line_type_code);
2403:
2404:

Line 2401: fnd_file.put_line(FND_FILE.LOG,'list_line_id ' || l_new_list_line_id);

2397: ,to_char(l_qp_list_lines_rec.list_header_id) --7309992
2398: --(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_list_header_id)
2399: );
2400: fnd_file.put_line(FND_FILE.LOG,'Inserted line');
2401: fnd_file.put_line(FND_FILE.LOG,'list_line_id ' || l_new_list_line_id);
2402: fnd_file.put_line(FND_FILE.LOG,'list_line_type_code ' || l_qp_list_lines_rec.list_line_type_code);
2403:
2404:
2405: /*If the list_line_rec is a Price Break Parent Line or Price Break Line then

Line 2402: fnd_file.put_line(FND_FILE.LOG,'list_line_type_code ' || l_qp_list_lines_rec.list_line_type_code);

2398: --(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_list_header_id)
2399: );
2400: fnd_file.put_line(FND_FILE.LOG,'Inserted line');
2401: fnd_file.put_line(FND_FILE.LOG,'list_line_id ' || l_new_list_line_id);
2402: fnd_file.put_line(FND_FILE.LOG,'list_line_type_code ' || l_qp_list_lines_rec.list_line_type_code);
2403:
2404:
2405: /*If the list_line_rec is a Price Break Parent Line or Price Break Line then
2406: store the old and new list line id in a mapping-array for later use*/

Line 2583: fnd_file.put_line(FND_FILE.LOG,'Inserted pricing attribute');

2579: ,to_char(l_new_pricing_attribute_id)
2580: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_new_list_line_id)
2581: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_list_header_id)
2582: );
2583: fnd_file.put_line(FND_FILE.LOG,'Inserted pricing attribute');
2584: fnd_file.put_line(FND_FILE.LOG,'product_attribute_context ' || l_qp_pricing_attributes_rec.product_attribute_context);
2585: fnd_file.put_line(FND_FILE.LOG,'product_attribute ' || l_qp_pricing_attributes_rec.product_attribute);
2586: fnd_file.put_line(FND_FILE.LOG,'product_attr_value ' || l_qp_pricing_attributes_rec.product_attr_value);
2587: fnd_file.put_line(FND_FILE.LOG,'product_uom_code ' || l_qp_pricing_attributes_rec.product_uom_code);

Line 2584: fnd_file.put_line(FND_FILE.LOG,'product_attribute_context ' || l_qp_pricing_attributes_rec.product_attribute_context);

2580: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_new_list_line_id)
2581: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_list_header_id)
2582: );
2583: fnd_file.put_line(FND_FILE.LOG,'Inserted pricing attribute');
2584: fnd_file.put_line(FND_FILE.LOG,'product_attribute_context ' || l_qp_pricing_attributes_rec.product_attribute_context);
2585: fnd_file.put_line(FND_FILE.LOG,'product_attribute ' || l_qp_pricing_attributes_rec.product_attribute);
2586: fnd_file.put_line(FND_FILE.LOG,'product_attr_value ' || l_qp_pricing_attributes_rec.product_attr_value);
2587: fnd_file.put_line(FND_FILE.LOG,'product_uom_code ' || l_qp_pricing_attributes_rec.product_uom_code);
2588:

Line 2585: fnd_file.put_line(FND_FILE.LOG,'product_attribute ' || l_qp_pricing_attributes_rec.product_attribute);

2581: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_list_header_id)
2582: );
2583: fnd_file.put_line(FND_FILE.LOG,'Inserted pricing attribute');
2584: fnd_file.put_line(FND_FILE.LOG,'product_attribute_context ' || l_qp_pricing_attributes_rec.product_attribute_context);
2585: fnd_file.put_line(FND_FILE.LOG,'product_attribute ' || l_qp_pricing_attributes_rec.product_attribute);
2586: fnd_file.put_line(FND_FILE.LOG,'product_attr_value ' || l_qp_pricing_attributes_rec.product_attr_value);
2587: fnd_file.put_line(FND_FILE.LOG,'product_uom_code ' || l_qp_pricing_attributes_rec.product_uom_code);
2588:
2589: END LOOP; /* Cursor qp_pricing_attributes_cur LOOP */

Line 2586: fnd_file.put_line(FND_FILE.LOG,'product_attr_value ' || l_qp_pricing_attributes_rec.product_attr_value);

2582: );
2583: fnd_file.put_line(FND_FILE.LOG,'Inserted pricing attribute');
2584: fnd_file.put_line(FND_FILE.LOG,'product_attribute_context ' || l_qp_pricing_attributes_rec.product_attribute_context);
2585: fnd_file.put_line(FND_FILE.LOG,'product_attribute ' || l_qp_pricing_attributes_rec.product_attribute);
2586: fnd_file.put_line(FND_FILE.LOG,'product_attr_value ' || l_qp_pricing_attributes_rec.product_attr_value);
2587: fnd_file.put_line(FND_FILE.LOG,'product_uom_code ' || l_qp_pricing_attributes_rec.product_uom_code);
2588:
2589: END LOOP; /* Cursor qp_pricing_attributes_cur LOOP */
2590: end if; --bug3067774

Line 2587: fnd_file.put_line(FND_FILE.LOG,'product_uom_code ' || l_qp_pricing_attributes_rec.product_uom_code);

2583: fnd_file.put_line(FND_FILE.LOG,'Inserted pricing attribute');
2584: fnd_file.put_line(FND_FILE.LOG,'product_attribute_context ' || l_qp_pricing_attributes_rec.product_attribute_context);
2585: fnd_file.put_line(FND_FILE.LOG,'product_attribute ' || l_qp_pricing_attributes_rec.product_attribute);
2586: fnd_file.put_line(FND_FILE.LOG,'product_attr_value ' || l_qp_pricing_attributes_rec.product_attr_value);
2587: fnd_file.put_line(FND_FILE.LOG,'product_uom_code ' || l_qp_pricing_attributes_rec.product_uom_code);
2588:
2589: END LOOP; /* Cursor qp_pricing_attributes_cur LOOP */
2590: end if; --bug3067774
2591: END LOOP; /* Cursor qp_list_lines_cv LOOP */

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

2689:
2690:
2691: if retcode = 2 then
2692: --error from update denormalized columns
2693: fnd_file.put_line(FND_FILE.LOG,'Error in Update of denormalized columns in QP_Qualifiers');
2694: else
2695: fnd_file.put_line(FND_FILE.LOG,'Update of denormalized columns in QP_Qualifiers completed successfully');
2696: end if;
2697:

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

2691: if retcode = 2 then
2692: --error from update denormalized columns
2693: fnd_file.put_line(FND_FILE.LOG,'Error in Update of denormalized columns in QP_Qualifiers');
2694: else
2695: fnd_file.put_line(FND_FILE.LOG,'Update of denormalized columns in QP_Qualifiers completed successfully');
2696: end if;
2697:
2698:
2699: --Upgrade Non-Continuous Price Breaks

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

2698:
2699: --Upgrade Non-Continuous Price Breaks
2700:
2701: IF l_non_cont_pbh_id_tbl.COUNT > 0 THEN
2702: fnd_file.put_line(FND_FILE.LOG,'New List Name : '||p_new_price_list_name);
2703:
2704: FOR i IN l_non_cont_pbh_id_tbl.FIRST..l_non_cont_pbh_id_tbl.LAST
2705: LOOP
2706:

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

2703:
2704: FOR i IN l_non_cont_pbh_id_tbl.FIRST..l_non_cont_pbh_id_tbl.LAST
2705: LOOP
2706:
2707: 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);
2708:
2709: qp_delayed_requests_PVT.log_request
2710: ( p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR
2711: , p_entity_id => l_non_cont_pbh_id_tbl(i).price_break_header_id

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

2727:
2728: END IF;
2729: commit;
2730:
2731: fnd_file.put_line(FND_FILE.LOG,'Price list copy completed successfully');
2732: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
2733: select min(list_line_id), max(list_line_id)
2734: into l_min_list_line_id, l_max_list_line_id
2735: from qp_list_lines

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

2753:
2754: WHEN OTHERS THEN
2755:
2756:
2757: fnd_file.put_line(FND_FILE.LOG,'Error in Copy Price list Routine ');
2758: fnd_file.put_line(FND_FILE.LOG,substr(sqlerrm,1,300));
2759: retcode := 2;
2760:
2761: END Copy_Price_List;

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

2754: WHEN OTHERS THEN
2755:
2756:
2757: fnd_file.put_line(FND_FILE.LOG,'Error in Copy Price list Routine ');
2758: fnd_file.put_line(FND_FILE.LOG,substr(sqlerrm,1,300));
2759: retcode := 2;
2760:
2761: END Copy_Price_List;
2762: