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_ARCHIVE_ENTITY_PVT dependencies on FND_FILE

Line 1792: fnd_file.put_line(FND_FILE.LOG,'Price List line used in formula.Do not archive : '||l_qp_list_lines_rec.list_line_id);

1788: IF l_cnt=0 THEN
1789: l_insert_flag :='Y';
1790: ELSE
1791: l_insert_flag :='N';
1792: fnd_file.put_line(FND_FILE.LOG,'Price List line used in formula.Do not archive : '||l_qp_list_lines_rec.list_line_id);
1793: l_err_count := l_err_count+1;
1794: END IF;
1795:
1796: IF l_insert_flag ='Y' THEN

Line 1802: fnd_file.put_line(FND_FILE.LOG,'COUPON or related BENEFIT line.Do not archive : '||l_qp_list_lines_rec.list_line_id);

1798: IF l_list_type_code = 'PRO' or l_list_type_code = 'DEL' THEN
1799: IF (l_qp_list_lines_rec.list_line_type_code = 'CIE') OR
1800: LINE_EXISTS_IN_RLTD(l_qp_list_lines_rec.list_line_id) THEN
1801: l_insert_flag :='N';
1802: fnd_file.put_line(FND_FILE.LOG,'COUPON or related BENEFIT line.Do not archive : '||l_qp_list_lines_rec.list_line_id);
1803: l_err_count := l_err_count+1;
1804: END IF;
1805: END IF;
1806: END IF;

Line 2319: -- fnd_file.put_line(FND_FILE.LOG,'JP TEST --' || l_id_count);

2315: AND list_line_id = l_qp_list_lines_rec.list_line_id and list_header_id = p_entity; */
2316: ---bug#13045009
2317:
2318: END LOOP; /* Cursor qp_pricing_attributes_cur LOOP */
2319: -- fnd_file.put_line(FND_FILE.LOG,'JP TEST --' || l_id_count);
2320: l_list_line_id_tbl(l_id_count) := l_qp_list_lines_rec.list_line_id;
2321: l_id_count := l_id_count+1;
2322:
2323: END IF; --Insert flag

Line 2325: fnd_file.put_line(FND_FILE.LOG,'Limit exists for this line and it cannot be archived : '||l_qp_list_lines_rec.list_line_id);

2321: l_id_count := l_id_count+1;
2322:
2323: END IF; --Insert flag
2324: ELSE --Limit exists
2325: fnd_file.put_line(FND_FILE.LOG,'Limit exists for this line and it cannot be archived : '||l_qp_list_lines_rec.list_line_id);
2326: l_err_count := l_err_count+1;
2327: END IF;
2328: END LOOP; /* Cursor qp_list_lines_cv LOOP */
2329: ---bug#13045009

Line 2428: fnd_file.put_line(FND_FILE.LOG, 'Number of list header records inserted into QP_ARCH_LIST_HEADERS_B: '|| g_count_header_b);

2424: insert into QP_ARCH_ROW_COUNTS (request_id,table_name,row_count) values (l_conc_request_id,'QP_ARCH_PRICING_ATTRIBUTES',g_count_pricing_att);
2425: insert into QP_ARCH_ROW_COUNTS (request_id,table_name,row_count) values (l_conc_request_id,'QP_ARCH_QUALIFIERS',g_count_qualifier);
2426: insert into QP_ARCH_ROW_COUNTS (request_id,table_name,row_count) values (l_conc_request_id,'QP_ARCH_RLTD_MODIFIERS',g_count_rldt);
2427:
2428: fnd_file.put_line(FND_FILE.LOG, 'Number of list header records inserted into QP_ARCH_LIST_HEADERS_B: '|| g_count_header_b);
2429: fnd_file.put_line(FND_FILE.LOG, 'Number of list header translation records inserted into QP_ARCH_LIST_HEADERS_TL: '|| g_count_header_tl);
2430: fnd_file.put_line(FND_FILE.LOG, 'Number of list header and line qualifiers inserted into QP_ARCH_QUALIFIERS: '|| g_count_qualifier);
2431: fnd_file.put_line(FND_FILE.LOG, 'Number of list lines archived into QP_ARCH_LIST_LINES: '|| g_count_list_line);
2432: fnd_file.put_line(FND_FILE.LOG, 'Number of list line pricing attributes archived into QP_ARCH_PRICING_ATTRIBUTES: '|| g_count_pricing_att);

Line 2429: fnd_file.put_line(FND_FILE.LOG, 'Number of list header translation records inserted into QP_ARCH_LIST_HEADERS_TL: '|| g_count_header_tl);

2425: insert into QP_ARCH_ROW_COUNTS (request_id,table_name,row_count) values (l_conc_request_id,'QP_ARCH_QUALIFIERS',g_count_qualifier);
2426: insert into QP_ARCH_ROW_COUNTS (request_id,table_name,row_count) values (l_conc_request_id,'QP_ARCH_RLTD_MODIFIERS',g_count_rldt);
2427:
2428: fnd_file.put_line(FND_FILE.LOG, 'Number of list header records inserted into QP_ARCH_LIST_HEADERS_B: '|| g_count_header_b);
2429: fnd_file.put_line(FND_FILE.LOG, 'Number of list header translation records inserted into QP_ARCH_LIST_HEADERS_TL: '|| g_count_header_tl);
2430: fnd_file.put_line(FND_FILE.LOG, 'Number of list header and line qualifiers inserted into QP_ARCH_QUALIFIERS: '|| g_count_qualifier);
2431: fnd_file.put_line(FND_FILE.LOG, 'Number of list lines archived into QP_ARCH_LIST_LINES: '|| g_count_list_line);
2432: fnd_file.put_line(FND_FILE.LOG, 'Number of list line pricing attributes archived into QP_ARCH_PRICING_ATTRIBUTES: '|| g_count_pricing_att);
2433: fnd_file.put_line(FND_FILE.LOG, 'Number of related lines archived into QP_ARCH_RLTD_MODIFIERS: '|| g_count_rldt);

Line 2430: fnd_file.put_line(FND_FILE.LOG, 'Number of list header and line qualifiers inserted into QP_ARCH_QUALIFIERS: '|| g_count_qualifier);

2426: insert into QP_ARCH_ROW_COUNTS (request_id,table_name,row_count) values (l_conc_request_id,'QP_ARCH_RLTD_MODIFIERS',g_count_rldt);
2427:
2428: fnd_file.put_line(FND_FILE.LOG, 'Number of list header records inserted into QP_ARCH_LIST_HEADERS_B: '|| g_count_header_b);
2429: fnd_file.put_line(FND_FILE.LOG, 'Number of list header translation records inserted into QP_ARCH_LIST_HEADERS_TL: '|| g_count_header_tl);
2430: fnd_file.put_line(FND_FILE.LOG, 'Number of list header and line qualifiers inserted into QP_ARCH_QUALIFIERS: '|| g_count_qualifier);
2431: fnd_file.put_line(FND_FILE.LOG, 'Number of list lines archived into QP_ARCH_LIST_LINES: '|| g_count_list_line);
2432: fnd_file.put_line(FND_FILE.LOG, 'Number of list line pricing attributes archived into QP_ARCH_PRICING_ATTRIBUTES: '|| g_count_pricing_att);
2433: fnd_file.put_line(FND_FILE.LOG, 'Number of related lines archived into QP_ARCH_RLTD_MODIFIERS: '|| g_count_rldt);
2434:

Line 2431: fnd_file.put_line(FND_FILE.LOG, 'Number of list lines archived into QP_ARCH_LIST_LINES: '|| g_count_list_line);

2427:
2428: fnd_file.put_line(FND_FILE.LOG, 'Number of list header records inserted into QP_ARCH_LIST_HEADERS_B: '|| g_count_header_b);
2429: fnd_file.put_line(FND_FILE.LOG, 'Number of list header translation records inserted into QP_ARCH_LIST_HEADERS_TL: '|| g_count_header_tl);
2430: fnd_file.put_line(FND_FILE.LOG, 'Number of list header and line qualifiers inserted into QP_ARCH_QUALIFIERS: '|| g_count_qualifier);
2431: fnd_file.put_line(FND_FILE.LOG, 'Number of list lines archived into QP_ARCH_LIST_LINES: '|| g_count_list_line);
2432: fnd_file.put_line(FND_FILE.LOG, 'Number of list line pricing attributes archived into QP_ARCH_PRICING_ATTRIBUTES: '|| g_count_pricing_att);
2433: fnd_file.put_line(FND_FILE.LOG, 'Number of related lines archived into QP_ARCH_RLTD_MODIFIERS: '|| g_count_rldt);
2434:
2435: IF (g_count_list_line > 0) THEN -- Invoke update_qualifiers only if number of list lines archived > 0.

Line 2432: fnd_file.put_line(FND_FILE.LOG, 'Number of list line pricing attributes archived into QP_ARCH_PRICING_ATTRIBUTES: '|| g_count_pricing_att);

2428: fnd_file.put_line(FND_FILE.LOG, 'Number of list header records inserted into QP_ARCH_LIST_HEADERS_B: '|| g_count_header_b);
2429: fnd_file.put_line(FND_FILE.LOG, 'Number of list header translation records inserted into QP_ARCH_LIST_HEADERS_TL: '|| g_count_header_tl);
2430: fnd_file.put_line(FND_FILE.LOG, 'Number of list header and line qualifiers inserted into QP_ARCH_QUALIFIERS: '|| g_count_qualifier);
2431: fnd_file.put_line(FND_FILE.LOG, 'Number of list lines archived into QP_ARCH_LIST_LINES: '|| g_count_list_line);
2432: fnd_file.put_line(FND_FILE.LOG, 'Number of list line pricing attributes archived into QP_ARCH_PRICING_ATTRIBUTES: '|| g_count_pricing_att);
2433: fnd_file.put_line(FND_FILE.LOG, 'Number of related lines archived into QP_ARCH_RLTD_MODIFIERS: '|| g_count_rldt);
2434:
2435: IF (g_count_list_line > 0) THEN -- Invoke update_qualifiers only if number of list lines archived > 0.
2436: fnd_file.put_line(FND_FILE.LOG, 'Before calling QP_MAINTAIN_DENORMALIZED_DATA.UPDATE_QUALIFIERS.');

Line 2433: fnd_file.put_line(FND_FILE.LOG, 'Number of related lines archived into QP_ARCH_RLTD_MODIFIERS: '|| g_count_rldt);

2429: fnd_file.put_line(FND_FILE.LOG, 'Number of list header translation records inserted into QP_ARCH_LIST_HEADERS_TL: '|| g_count_header_tl);
2430: fnd_file.put_line(FND_FILE.LOG, 'Number of list header and line qualifiers inserted into QP_ARCH_QUALIFIERS: '|| g_count_qualifier);
2431: fnd_file.put_line(FND_FILE.LOG, 'Number of list lines archived into QP_ARCH_LIST_LINES: '|| g_count_list_line);
2432: fnd_file.put_line(FND_FILE.LOG, 'Number of list line pricing attributes archived into QP_ARCH_PRICING_ATTRIBUTES: '|| g_count_pricing_att);
2433: fnd_file.put_line(FND_FILE.LOG, 'Number of related lines archived into QP_ARCH_RLTD_MODIFIERS: '|| g_count_rldt);
2434:
2435: IF (g_count_list_line > 0) THEN -- Invoke update_qualifiers only if number of list lines archived > 0.
2436: fnd_file.put_line(FND_FILE.LOG, 'Before calling QP_MAINTAIN_DENORMALIZED_DATA.UPDATE_QUALIFIERS.');
2437: /* This code will call the API to update the denormalized columns on QP_QUALIFIERS*/

Line 2436: fnd_file.put_line(FND_FILE.LOG, 'Before calling QP_MAINTAIN_DENORMALIZED_DATA.UPDATE_QUALIFIERS.');

2432: fnd_file.put_line(FND_FILE.LOG, 'Number of list line pricing attributes archived into QP_ARCH_PRICING_ATTRIBUTES: '|| g_count_pricing_att);
2433: fnd_file.put_line(FND_FILE.LOG, 'Number of related lines archived into QP_ARCH_RLTD_MODIFIERS: '|| g_count_rldt);
2434:
2435: IF (g_count_list_line > 0) THEN -- Invoke update_qualifiers only if number of list lines archived > 0.
2436: fnd_file.put_line(FND_FILE.LOG, 'Before calling QP_MAINTAIN_DENORMALIZED_DATA.UPDATE_QUALIFIERS.');
2437: /* This code will call the API to update the denormalized columns on QP_QUALIFIERS*/
2438: QP_MAINTAIN_DENORMALIZED_DATA.UPDATE_QUALIFIERS( ERR_BUFF => errbuf,
2439: RETCODE => retcode,
2440: P_LIST_HEADER_ID => p_entity);

Line 2441: fnd_file.put_line(FND_FILE.LOG, 'After calling QP_MAINTAIN_DENORMALIZED_DATA.UPDATE_QUALIFIERS. Return code: '|| retcode);

2437: /* This code will call the API to update the denormalized columns on QP_QUALIFIERS*/
2438: QP_MAINTAIN_DENORMALIZED_DATA.UPDATE_QUALIFIERS( ERR_BUFF => errbuf,
2439: RETCODE => retcode,
2440: P_LIST_HEADER_ID => p_entity);
2441: fnd_file.put_line(FND_FILE.LOG, 'After calling QP_MAINTAIN_DENORMALIZED_DATA.UPDATE_QUALIFIERS. Return code: '|| retcode);
2442:
2443: IF retcode = 2 THEN
2444: fnd_file.put_line(FND_FILE.LOG,'Error in Update of denormalized columns in QP_Qualifiers');
2445: ELSE

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

2440: P_LIST_HEADER_ID => p_entity);
2441: fnd_file.put_line(FND_FILE.LOG, 'After calling QP_MAINTAIN_DENORMALIZED_DATA.UPDATE_QUALIFIERS. Return code: '|| retcode);
2442:
2443: IF retcode = 2 THEN
2444: fnd_file.put_line(FND_FILE.LOG,'Error in Update of denormalized columns in QP_Qualifiers');
2445: ELSE
2446: fnd_file.put_line(FND_FILE.LOG,'Update of denormalized columns in QP_Qualifiers completed successfully');
2447: END IF;
2448: END IF;

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

2442:
2443: IF retcode = 2 THEN
2444: fnd_file.put_line(FND_FILE.LOG,'Error in Update of denormalized columns in QP_Qualifiers');
2445: ELSE
2446: fnd_file.put_line(FND_FILE.LOG,'Update of denormalized columns in QP_Qualifiers completed successfully');
2447: END IF;
2448: END IF;
2449:
2450: COMMIT;

Line 2452: fnd_file.put_line(FND_FILE.LOG, 'Number of list lines errored out and not processed: '|| l_err_count);

2448: END IF;
2449:
2450: COMMIT;
2451:
2452: fnd_file.put_line(FND_FILE.LOG, 'Number of list lines errored out and not processed: '|| l_err_count);
2453:
2454: IF l_err_count = 0 THEN
2455: fnd_file.put_line(FND_FILE.LOG,'Pricing entity archive completed successfully');
2456:

Line 2455: fnd_file.put_line(FND_FILE.LOG,'Pricing entity archive completed successfully');

2451:
2452: fnd_file.put_line(FND_FILE.LOG, 'Number of list lines errored out and not processed: '|| l_err_count);
2453:
2454: IF l_err_count = 0 THEN
2455: fnd_file.put_line(FND_FILE.LOG,'Pricing entity archive completed successfully');
2456:
2457: errbuf := '';
2458: retcode := 0;
2459:

Line 2465: fnd_file.put_line(FND_FILE.LOG,'Pricing entity archive completed successfully');

2461: INSERT_CRITERIA(p_archive_name,p_entity_type,p_source_system_code,p_entity,p_all_lines,p_product_context,
2462: p_product_attribute,p_product_attr_value_from,p_product_attr_value_to,p_start_date_active,
2463: p_end_date_active,p_creation_date,p_created_by,l_user_id,l_conc_request_id,'S');
2464: ELSE
2465: fnd_file.put_line(FND_FILE.LOG,'Pricing entity archive completed successfully');
2466: fnd_file.put_line(FND_FILE.LOG,'A few lines matching the archive criteria were not archived');
2467:
2468: errbuf := 'Few lines matching the criteria were not Archived';
2469: retcode := 0;

Line 2466: fnd_file.put_line(FND_FILE.LOG,'A few lines matching the archive criteria were not archived');

2462: p_product_attribute,p_product_attr_value_from,p_product_attr_value_to,p_start_date_active,
2463: p_end_date_active,p_creation_date,p_created_by,l_user_id,l_conc_request_id,'S');
2464: ELSE
2465: fnd_file.put_line(FND_FILE.LOG,'Pricing entity archive completed successfully');
2466: fnd_file.put_line(FND_FILE.LOG,'A few lines matching the archive criteria were not archived');
2467:
2468: errbuf := 'Few lines matching the criteria were not Archived';
2469: retcode := 0;
2470:

Line 2479: fnd_file.put_line(FND_FILE.LOG,'Pricing entity archive completed with Warnings');

2475: END IF; --l_err_count
2476:
2477: EXCEPTION
2478: WHEN NO_DATA_FOUND THEN
2479: fnd_file.put_line(FND_FILE.LOG,'Pricing entity archive completed with Warnings');
2480: fnd_file.put_line(FND_FILE.LOG,'No Data Found - 0 Records Archived');
2481:
2482: errbuf := 'No Data Found - 0 Records Archived';
2483: retcode := 1;

Line 2480: fnd_file.put_line(FND_FILE.LOG,'No Data Found - 0 Records Archived');

2476:
2477: EXCEPTION
2478: WHEN NO_DATA_FOUND THEN
2479: fnd_file.put_line(FND_FILE.LOG,'Pricing entity archive completed with Warnings');
2480: fnd_file.put_line(FND_FILE.LOG,'No Data Found - 0 Records Archived');
2481:
2482: errbuf := 'No Data Found - 0 Records Archived';
2483: retcode := 1;
2484:

Line 2490: fnd_file.put_line(FND_FILE.LOG,'Error in Pricing entity archive Routine ');

2486: INSERT_CRITERIA(p_archive_name,p_entity_type,p_source_system_code,p_entity,p_all_lines,p_product_context,
2487: p_product_attribute,p_product_attr_value_from,p_product_attr_value_to,p_start_date_active,
2488: p_end_date_active,p_creation_date,p_created_by,l_user_id,l_conc_request_id,'W');
2489: WHEN OTHERS THEN
2490: fnd_file.put_line(FND_FILE.LOG,'Error in Pricing entity archive Routine ');
2491: fnd_file.put_line(FND_FILE.LOG,substr(sqlerrm,1,300));
2492:
2493: retcode := 2;
2494:

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

2487: p_product_attribute,p_product_attr_value_from,p_product_attr_value_to,p_start_date_active,
2488: p_end_date_active,p_creation_date,p_created_by,l_user_id,l_conc_request_id,'W');
2489: WHEN OTHERS THEN
2490: fnd_file.put_line(FND_FILE.LOG,'Error in Pricing entity archive Routine ');
2491: fnd_file.put_line(FND_FILE.LOG,substr(sqlerrm,1,300));
2492:
2493: retcode := 2;
2494:
2495: --Call INSERT_CRITERIA to insert records into QP_ARCH_CRITERIA_HEADERS and QP_ARCH_CRITERIA_LINES