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 2285: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>category_set_id: '||nvl(p_category_set_id, 0));

2281: END IF;
2282:
2283: -- begin fix bug 4127037
2284: -- debug
2285: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>category_set_id: '||nvl(p_category_set_id, 0));
2286: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>category_id: '||nvl(p_category_id, 0));
2287:
2288: IF ( nvl(p_category_id, 0) <> 0 AND nvl(p_category_set_id, 0) <> 0) THEN
2289: l_select_stmt := l_select_stmt ||

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

2282:
2283: -- begin fix bug 4127037
2284: -- debug
2285: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>category_set_id: '||nvl(p_category_set_id, 0));
2286: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>category_id: '||nvl(p_category_id, 0));
2287:
2288: IF ( nvl(p_category_id, 0) <> 0 AND nvl(p_category_set_id, 0) <> 0) THEN
2289: l_select_stmt := l_select_stmt ||
2290: 'AND m.inventory_item_id IN

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

2325: l_select_stmt := l_select_stmt || ') ';
2326: END IF;
2327:
2328: -- debug
2329: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||l_select_stmt);
2330:
2331: IF (p_category_id is null) and (p_category_set_id is null) then
2332: OPEN qp_list_lines_cv FOR l_select_stmt USING p_from_list_header_id;
2333: end if;

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

2336: END IF;
2337: IF ( nvl(p_category_id, 0) = 0 AND nvl(p_category_set_id, 0) <> 0) THEN
2338: OPEN qp_list_lines_cv FOR l_select_stmt USING p_from_list_header_id,p_category_set_id;
2339: END IF;
2340: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'opened list_lines cursor');
2341:
2342: --This is the fetch loop
2343: LOOP
2344: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'inside loop ');

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

2340: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'opened list_lines cursor');
2341:
2342: --This is the fetch loop
2343: LOOP
2344: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'inside loop ');
2345:
2346: --Insert each fetched record(Price List Line without Discount Line)
2347: --of the from_price_list into qp_list_lines(for the New Price List)
2348: --provided the segment values of the lines lie in the input ranges.

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

2347: --of the from_price_list into qp_list_lines(for the New Price List)
2348: --provided the segment values of the lines lie in the input ranges.
2349:
2350: FETCH qp_list_lines_cv INTO l_qp_list_lines_rec;
2351: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'after fetch ');
2352: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'row count ' || qp_list_lines_cv%ROWCOUNT);
2353:
2354: EXIT WHEN qp_list_lines_cv%NOTFOUND;
2355: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'row count ' || qp_list_lines_cv%ROWCOUNT);

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

2348: --provided the segment values of the lines lie in the input ranges.
2349:
2350: FETCH qp_list_lines_cv INTO l_qp_list_lines_rec;
2351: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'after fetch ');
2352: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'row count ' || qp_list_lines_cv%ROWCOUNT);
2353:
2354: EXIT WHEN qp_list_lines_cv%NOTFOUND;
2355: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'row count ' || qp_list_lines_cv%ROWCOUNT);
2356:

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

2351: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'after fetch ');
2352: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'row count ' || qp_list_lines_cv%ROWCOUNT);
2353:
2354: EXIT WHEN qp_list_lines_cv%NOTFOUND;
2355: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'row count ' || qp_list_lines_cv%ROWCOUNT);
2356:
2357:
2358: /* Added for 3067774.When price listr line is end dated,its related lines e.g. child lines
2359: are still active. Cursor qp_list_lines_cv selects all active lines, therefore,

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

2385: If l_cnt > 0 then
2386: insert_flag :='Y';
2387: End if;
2388: End if;
2389: fnd_file.put_line(FND_FILE.LOG,'>>>>>>>>>>>>>>>>'||'insert flag is ' || insert_flag);
2390:
2391: If insert_flag ='Y' then /* end changes for bug3067774 */
2392:
2393:

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

2579: --,to_char(l_qp_list_lines_rec.list_header_id) --7309992
2580: ,to_char(l_new_list_line_id) --bug#12423441
2581: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_list_header_id) --bug#12423441
2582: );
2583: fnd_file.put_line(FND_FILE.LOG,'Inserted line');
2584: fnd_file.put_line(FND_FILE.LOG,'list_line_id ' || l_new_list_line_id);
2585: fnd_file.put_line(FND_FILE.LOG,'list_line_type_code ' || l_qp_list_lines_rec.list_line_type_code);
2586:
2587:

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

2580: ,to_char(l_new_list_line_id) --bug#12423441
2581: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_list_header_id) --bug#12423441
2582: );
2583: fnd_file.put_line(FND_FILE.LOG,'Inserted line');
2584: fnd_file.put_line(FND_FILE.LOG,'list_line_id ' || l_new_list_line_id);
2585: fnd_file.put_line(FND_FILE.LOG,'list_line_type_code ' || l_qp_list_lines_rec.list_line_type_code);
2586:
2587:
2588: /*If the list_line_rec is a Price Break Parent Line or Price Break Line then

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

2581: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_list_header_id) --bug#12423441
2582: );
2583: fnd_file.put_line(FND_FILE.LOG,'Inserted line');
2584: fnd_file.put_line(FND_FILE.LOG,'list_line_id ' || l_new_list_line_id);
2585: fnd_file.put_line(FND_FILE.LOG,'list_line_type_code ' || l_qp_list_lines_rec.list_line_type_code);
2586:
2587:
2588: /*If the list_line_rec is a Price Break Parent Line or Price Break Line then
2589: store the old and new list line id in a mapping-array for later use*/

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

2762: ,to_char(l_new_pricing_attribute_id)
2763: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_new_list_line_id)
2764: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_list_header_id)
2765: );
2766: fnd_file.put_line(FND_FILE.LOG,'Inserted pricing attribute');
2767: fnd_file.put_line(FND_FILE.LOG,'product_attribute_context ' || l_qp_pricing_attributes_rec.product_attribute_context);
2768: fnd_file.put_line(FND_FILE.LOG,'product_attribute ' || l_qp_pricing_attributes_rec.product_attribute);
2769: fnd_file.put_line(FND_FILE.LOG,'product_attr_value ' || l_qp_pricing_attributes_rec.product_attr_value);
2770: fnd_file.put_line(FND_FILE.LOG,'product_uom_code ' || l_qp_pricing_attributes_rec.product_uom_code);

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

2763: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=l_new_list_line_id)
2764: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_list_header_id)
2765: );
2766: fnd_file.put_line(FND_FILE.LOG,'Inserted pricing attribute');
2767: fnd_file.put_line(FND_FILE.LOG,'product_attribute_context ' || l_qp_pricing_attributes_rec.product_attribute_context);
2768: fnd_file.put_line(FND_FILE.LOG,'product_attribute ' || l_qp_pricing_attributes_rec.product_attribute);
2769: fnd_file.put_line(FND_FILE.LOG,'product_attr_value ' || l_qp_pricing_attributes_rec.product_attr_value);
2770: fnd_file.put_line(FND_FILE.LOG,'product_uom_code ' || l_qp_pricing_attributes_rec.product_uom_code);
2771:

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

2764: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_new_list_header_id)
2765: );
2766: fnd_file.put_line(FND_FILE.LOG,'Inserted pricing attribute');
2767: fnd_file.put_line(FND_FILE.LOG,'product_attribute_context ' || l_qp_pricing_attributes_rec.product_attribute_context);
2768: fnd_file.put_line(FND_FILE.LOG,'product_attribute ' || l_qp_pricing_attributes_rec.product_attribute);
2769: fnd_file.put_line(FND_FILE.LOG,'product_attr_value ' || l_qp_pricing_attributes_rec.product_attr_value);
2770: fnd_file.put_line(FND_FILE.LOG,'product_uom_code ' || l_qp_pricing_attributes_rec.product_uom_code);
2771:
2772: END LOOP; /* Cursor qp_pricing_attributes_cur LOOP */

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

2765: );
2766: fnd_file.put_line(FND_FILE.LOG,'Inserted pricing attribute');
2767: fnd_file.put_line(FND_FILE.LOG,'product_attribute_context ' || l_qp_pricing_attributes_rec.product_attribute_context);
2768: fnd_file.put_line(FND_FILE.LOG,'product_attribute ' || l_qp_pricing_attributes_rec.product_attribute);
2769: fnd_file.put_line(FND_FILE.LOG,'product_attr_value ' || l_qp_pricing_attributes_rec.product_attr_value);
2770: fnd_file.put_line(FND_FILE.LOG,'product_uom_code ' || l_qp_pricing_attributes_rec.product_uom_code);
2771:
2772: END LOOP; /* Cursor qp_pricing_attributes_cur LOOP */
2773: end if; --bug3067774

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

2766: fnd_file.put_line(FND_FILE.LOG,'Inserted pricing attribute');
2767: fnd_file.put_line(FND_FILE.LOG,'product_attribute_context ' || l_qp_pricing_attributes_rec.product_attribute_context);
2768: fnd_file.put_line(FND_FILE.LOG,'product_attribute ' || l_qp_pricing_attributes_rec.product_attribute);
2769: fnd_file.put_line(FND_FILE.LOG,'product_attr_value ' || l_qp_pricing_attributes_rec.product_attr_value);
2770: fnd_file.put_line(FND_FILE.LOG,'product_uom_code ' || l_qp_pricing_attributes_rec.product_uom_code);
2771:
2772: END LOOP; /* Cursor qp_pricing_attributes_cur LOOP */
2773: end if; --bug3067774
2774: END LOOP; /* Cursor qp_list_lines_cv LOOP */

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

2874:
2875:
2876: if retcode = 2 then
2877: --error from update denormalized columns
2878: fnd_file.put_line(FND_FILE.LOG,'Error in Update of denormalized columns in QP_Qualifiers');
2879: else
2880: fnd_file.put_line(FND_FILE.LOG,'Update of denormalized columns in QP_Qualifiers completed successfully');
2881: end if;
2882:

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

2876: if retcode = 2 then
2877: --error from update denormalized columns
2878: fnd_file.put_line(FND_FILE.LOG,'Error in Update of denormalized columns in QP_Qualifiers');
2879: else
2880: fnd_file.put_line(FND_FILE.LOG,'Update of denormalized columns in QP_Qualifiers completed successfully');
2881: end if;
2882:
2883:
2884: --Upgrade Non-Continuous Price Breaks

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

2883:
2884: --Upgrade Non-Continuous Price Breaks
2885:
2886: IF (l_non_cont_pbh_id_tbl.COUNT > 0) and (nvl(FND_PROFILE.VALUE('QP_CONTINUOUS_PB'),'Y')= 'Y') THEN -- 14103598
2887: fnd_file.put_line(FND_FILE.LOG,'New List Name : '||p_new_price_list_name);
2888:
2889: FOR i IN l_non_cont_pbh_id_tbl.FIRST..l_non_cont_pbh_id_tbl.LAST
2890: LOOP
2891:

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

2888:
2889: FOR i IN l_non_cont_pbh_id_tbl.FIRST..l_non_cont_pbh_id_tbl.LAST
2890: LOOP
2891:
2892: 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);
2893:
2894: qp_delayed_requests_PVT.log_request
2895: ( p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR
2896: , p_entity_id => l_non_cont_pbh_id_tbl(i).price_break_header_id

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

2912:
2913: END IF;
2914: commit;
2915:
2916: fnd_file.put_line(FND_FILE.LOG,'Price list copy completed successfully');
2917: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
2918: select min(list_line_id), max(list_line_id)
2919: into l_min_list_line_id, l_max_list_line_id
2920: from qp_list_lines

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

2972:
2973: WHEN OTHERS THEN
2974:
2975:
2976: fnd_file.put_line(FND_FILE.LOG,'Error in Copy Price list Routine ');
2977: fnd_file.put_line(FND_FILE.LOG,substr(sqlerrm,1,300));
2978: retcode := 2;
2979:
2980: END Copy_Price_List;

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

2973: WHEN OTHERS THEN
2974:
2975:
2976: fnd_file.put_line(FND_FILE.LOG,'Error in Copy Price list Routine ');
2977: fnd_file.put_line(FND_FILE.LOG,substr(sqlerrm,1,300));
2978: retcode := 2;
2979:
2980: END Copy_Price_List;
2981: