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 1726: fnd_file.put_line(FND_FILE.LOG,'Price List line used in formula.Do not archive : '||l_qp_list_lines_rec.list_line_id);

1722: IF l_cnt=0 THEN
1723: l_insert_flag :='Y';
1724: ELSE
1725: l_insert_flag :='N';
1726: fnd_file.put_line(FND_FILE.LOG,'Price List line used in formula.Do not archive : '||l_qp_list_lines_rec.list_line_id);
1727: l_err_count := l_err_count+1;
1728: END IF;
1729:
1730: IF l_insert_flag ='Y' THEN

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

1732: IF l_list_type_code = 'PRO' or l_list_type_code = 'DEL' THEN
1733: IF (l_qp_list_lines_rec.list_line_type_code = 'CIE') OR
1734: LINE_EXISTS_IN_RLTD(l_qp_list_lines_rec.list_line_id) THEN
1735: l_insert_flag :='N';
1736: fnd_file.put_line(FND_FILE.LOG,'COUPON or related BENEFIT line.Do not archive : '||l_qp_list_lines_rec.list_line_id);
1737: l_err_count := l_err_count+1;
1738: END IF;
1739: END IF;
1740: END IF;

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

2250: END LOOP; /* Cursor qp_pricing_attributes_cur LOOP */
2251:
2252: END IF; --Insert flag
2253: ELSE --Limit exists
2254: 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);
2255: l_err_count := l_err_count+1;
2256: END IF;
2257: END LOOP; /* Cursor qp_list_lines_cv LOOP */
2258:

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

2348: 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);
2349: insert into QP_ARCH_ROW_COUNTS (request_id,table_name,row_count) values (l_conc_request_id,'QP_ARCH_QUALIFIERS',g_count_qualifier);
2350: insert into QP_ARCH_ROW_COUNTS (request_id,table_name,row_count) values (l_conc_request_id,'QP_ARCH_RLTD_MODIFIERS',g_count_rldt);
2351:
2352: fnd_file.put_line(FND_FILE.LOG, 'Number of list header records inserted into QP_ARCH_LIST_HEADERS_B: '|| g_count_header_b);
2353: fnd_file.put_line(FND_FILE.LOG, 'Number of list header translation records inserted into QP_ARCH_LIST_HEADERS_TL: '|| g_count_header_tl);
2354: fnd_file.put_line(FND_FILE.LOG, 'Number of list header and line qualifiers inserted into QP_ARCH_QUALIFIERS: '|| g_count_qualifier);
2355: fnd_file.put_line(FND_FILE.LOG, 'Number of list lines archived into QP_ARCH_LIST_LINES: '|| g_count_list_line);
2356: fnd_file.put_line(FND_FILE.LOG, 'Number of list line pricing attributes archived into QP_ARCH_PRICING_ATTRIBUTES: '|| g_count_pricing_att);

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

2349: insert into QP_ARCH_ROW_COUNTS (request_id,table_name,row_count) values (l_conc_request_id,'QP_ARCH_QUALIFIERS',g_count_qualifier);
2350: insert into QP_ARCH_ROW_COUNTS (request_id,table_name,row_count) values (l_conc_request_id,'QP_ARCH_RLTD_MODIFIERS',g_count_rldt);
2351:
2352: fnd_file.put_line(FND_FILE.LOG, 'Number of list header records inserted into QP_ARCH_LIST_HEADERS_B: '|| g_count_header_b);
2353: fnd_file.put_line(FND_FILE.LOG, 'Number of list header translation records inserted into QP_ARCH_LIST_HEADERS_TL: '|| g_count_header_tl);
2354: fnd_file.put_line(FND_FILE.LOG, 'Number of list header and line qualifiers inserted into QP_ARCH_QUALIFIERS: '|| g_count_qualifier);
2355: fnd_file.put_line(FND_FILE.LOG, 'Number of list lines archived into QP_ARCH_LIST_LINES: '|| g_count_list_line);
2356: fnd_file.put_line(FND_FILE.LOG, 'Number of list line pricing attributes archived into QP_ARCH_PRICING_ATTRIBUTES: '|| g_count_pricing_att);
2357: fnd_file.put_line(FND_FILE.LOG, 'Number of related lines archived into QP_ARCH_RLTD_MODIFIERS: '|| g_count_rldt);

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

2350: insert into QP_ARCH_ROW_COUNTS (request_id,table_name,row_count) values (l_conc_request_id,'QP_ARCH_RLTD_MODIFIERS',g_count_rldt);
2351:
2352: fnd_file.put_line(FND_FILE.LOG, 'Number of list header records inserted into QP_ARCH_LIST_HEADERS_B: '|| g_count_header_b);
2353: fnd_file.put_line(FND_FILE.LOG, 'Number of list header translation records inserted into QP_ARCH_LIST_HEADERS_TL: '|| g_count_header_tl);
2354: fnd_file.put_line(FND_FILE.LOG, 'Number of list header and line qualifiers inserted into QP_ARCH_QUALIFIERS: '|| g_count_qualifier);
2355: fnd_file.put_line(FND_FILE.LOG, 'Number of list lines archived into QP_ARCH_LIST_LINES: '|| g_count_list_line);
2356: fnd_file.put_line(FND_FILE.LOG, 'Number of list line pricing attributes archived into QP_ARCH_PRICING_ATTRIBUTES: '|| g_count_pricing_att);
2357: fnd_file.put_line(FND_FILE.LOG, 'Number of related lines archived into QP_ARCH_RLTD_MODIFIERS: '|| g_count_rldt);
2358:

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

2351:
2352: fnd_file.put_line(FND_FILE.LOG, 'Number of list header records inserted into QP_ARCH_LIST_HEADERS_B: '|| g_count_header_b);
2353: fnd_file.put_line(FND_FILE.LOG, 'Number of list header translation records inserted into QP_ARCH_LIST_HEADERS_TL: '|| g_count_header_tl);
2354: fnd_file.put_line(FND_FILE.LOG, 'Number of list header and line qualifiers inserted into QP_ARCH_QUALIFIERS: '|| g_count_qualifier);
2355: fnd_file.put_line(FND_FILE.LOG, 'Number of list lines archived into QP_ARCH_LIST_LINES: '|| g_count_list_line);
2356: fnd_file.put_line(FND_FILE.LOG, 'Number of list line pricing attributes archived into QP_ARCH_PRICING_ATTRIBUTES: '|| g_count_pricing_att);
2357: fnd_file.put_line(FND_FILE.LOG, 'Number of related lines archived into QP_ARCH_RLTD_MODIFIERS: '|| g_count_rldt);
2358:
2359: IF (g_count_list_line > 0) THEN -- Invoke update_qualifiers only if number of list lines archived > 0.

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

2352: fnd_file.put_line(FND_FILE.LOG, 'Number of list header records inserted into QP_ARCH_LIST_HEADERS_B: '|| g_count_header_b);
2353: fnd_file.put_line(FND_FILE.LOG, 'Number of list header translation records inserted into QP_ARCH_LIST_HEADERS_TL: '|| g_count_header_tl);
2354: fnd_file.put_line(FND_FILE.LOG, 'Number of list header and line qualifiers inserted into QP_ARCH_QUALIFIERS: '|| g_count_qualifier);
2355: fnd_file.put_line(FND_FILE.LOG, 'Number of list lines archived into QP_ARCH_LIST_LINES: '|| g_count_list_line);
2356: fnd_file.put_line(FND_FILE.LOG, 'Number of list line pricing attributes archived into QP_ARCH_PRICING_ATTRIBUTES: '|| g_count_pricing_att);
2357: fnd_file.put_line(FND_FILE.LOG, 'Number of related lines archived into QP_ARCH_RLTD_MODIFIERS: '|| g_count_rldt);
2358:
2359: IF (g_count_list_line > 0) THEN -- Invoke update_qualifiers only if number of list lines archived > 0.
2360: fnd_file.put_line(FND_FILE.LOG, 'Before calling QP_MAINTAIN_DENORMALIZED_DATA.UPDATE_QUALIFIERS.');

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

2353: fnd_file.put_line(FND_FILE.LOG, 'Number of list header translation records inserted into QP_ARCH_LIST_HEADERS_TL: '|| g_count_header_tl);
2354: fnd_file.put_line(FND_FILE.LOG, 'Number of list header and line qualifiers inserted into QP_ARCH_QUALIFIERS: '|| g_count_qualifier);
2355: fnd_file.put_line(FND_FILE.LOG, 'Number of list lines archived into QP_ARCH_LIST_LINES: '|| g_count_list_line);
2356: fnd_file.put_line(FND_FILE.LOG, 'Number of list line pricing attributes archived into QP_ARCH_PRICING_ATTRIBUTES: '|| g_count_pricing_att);
2357: fnd_file.put_line(FND_FILE.LOG, 'Number of related lines archived into QP_ARCH_RLTD_MODIFIERS: '|| g_count_rldt);
2358:
2359: IF (g_count_list_line > 0) THEN -- Invoke update_qualifiers only if number of list lines archived > 0.
2360: fnd_file.put_line(FND_FILE.LOG, 'Before calling QP_MAINTAIN_DENORMALIZED_DATA.UPDATE_QUALIFIERS.');
2361: /* This code will call the API to update the denormalized columns on QP_QUALIFIERS*/

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

2356: fnd_file.put_line(FND_FILE.LOG, 'Number of list line pricing attributes archived into QP_ARCH_PRICING_ATTRIBUTES: '|| g_count_pricing_att);
2357: fnd_file.put_line(FND_FILE.LOG, 'Number of related lines archived into QP_ARCH_RLTD_MODIFIERS: '|| g_count_rldt);
2358:
2359: IF (g_count_list_line > 0) THEN -- Invoke update_qualifiers only if number of list lines archived > 0.
2360: fnd_file.put_line(FND_FILE.LOG, 'Before calling QP_MAINTAIN_DENORMALIZED_DATA.UPDATE_QUALIFIERS.');
2361: /* This code will call the API to update the denormalized columns on QP_QUALIFIERS*/
2362: QP_MAINTAIN_DENORMALIZED_DATA.UPDATE_QUALIFIERS( ERR_BUFF => errbuf,
2363: RETCODE => retcode,
2364: P_LIST_HEADER_ID => p_entity);

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

2361: /* This code will call the API to update the denormalized columns on QP_QUALIFIERS*/
2362: QP_MAINTAIN_DENORMALIZED_DATA.UPDATE_QUALIFIERS( ERR_BUFF => errbuf,
2363: RETCODE => retcode,
2364: P_LIST_HEADER_ID => p_entity);
2365: fnd_file.put_line(FND_FILE.LOG, 'After calling QP_MAINTAIN_DENORMALIZED_DATA.UPDATE_QUALIFIERS. Return code: '|| retcode);
2366:
2367: IF retcode = 2 THEN
2368: fnd_file.put_line(FND_FILE.LOG,'Error in Update of denormalized columns in QP_Qualifiers');
2369: ELSE

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

2364: P_LIST_HEADER_ID => p_entity);
2365: fnd_file.put_line(FND_FILE.LOG, 'After calling QP_MAINTAIN_DENORMALIZED_DATA.UPDATE_QUALIFIERS. Return code: '|| retcode);
2366:
2367: IF retcode = 2 THEN
2368: fnd_file.put_line(FND_FILE.LOG,'Error in Update of denormalized columns in QP_Qualifiers');
2369: ELSE
2370: fnd_file.put_line(FND_FILE.LOG,'Update of denormalized columns in QP_Qualifiers completed successfully');
2371: END IF;
2372: END IF;

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

2366:
2367: IF retcode = 2 THEN
2368: fnd_file.put_line(FND_FILE.LOG,'Error in Update of denormalized columns in QP_Qualifiers');
2369: ELSE
2370: fnd_file.put_line(FND_FILE.LOG,'Update of denormalized columns in QP_Qualifiers completed successfully');
2371: END IF;
2372: END IF;
2373:
2374: COMMIT;

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

2372: END IF;
2373:
2374: COMMIT;
2375:
2376: fnd_file.put_line(FND_FILE.LOG, 'Number of list lines errored out and not processed: '|| l_err_count);
2377:
2378: IF l_err_count = 0 THEN
2379: fnd_file.put_line(FND_FILE.LOG,'Pricing entity archive completed successfully');
2380:

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

2375:
2376: fnd_file.put_line(FND_FILE.LOG, 'Number of list lines errored out and not processed: '|| l_err_count);
2377:
2378: IF l_err_count = 0 THEN
2379: fnd_file.put_line(FND_FILE.LOG,'Pricing entity archive completed successfully');
2380:
2381: errbuf := '';
2382: retcode := 0;
2383:

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

2385: INSERT_CRITERIA(p_archive_name,p_entity_type,p_source_system_code,p_entity,p_all_lines,p_product_context,
2386: p_product_attribute,p_product_attr_value_from,p_product_attr_value_to,p_start_date_active,
2387: p_end_date_active,p_creation_date,p_created_by,l_user_id,l_conc_request_id,'S');
2388: ELSE
2389: fnd_file.put_line(FND_FILE.LOG,'Pricing entity archive completed successfully');
2390: fnd_file.put_line(FND_FILE.LOG,'A few lines matching the archive criteria were not archived');
2391:
2392: errbuf := 'Few lines matching the criteria were not Archived';
2393: retcode := 0;

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

2386: p_product_attribute,p_product_attr_value_from,p_product_attr_value_to,p_start_date_active,
2387: p_end_date_active,p_creation_date,p_created_by,l_user_id,l_conc_request_id,'S');
2388: ELSE
2389: fnd_file.put_line(FND_FILE.LOG,'Pricing entity archive completed successfully');
2390: fnd_file.put_line(FND_FILE.LOG,'A few lines matching the archive criteria were not archived');
2391:
2392: errbuf := 'Few lines matching the criteria were not Archived';
2393: retcode := 0;
2394:

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

2399: END IF; --l_err_count
2400:
2401: EXCEPTION
2402: WHEN NO_DATA_FOUND THEN
2403: fnd_file.put_line(FND_FILE.LOG,'Pricing entity archive completed with Warnings');
2404: fnd_file.put_line(FND_FILE.LOG,'No Data Found - 0 Records Archived');
2405:
2406: errbuf := 'No Data Found - 0 Records Archived';
2407: retcode := 1;

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

2400:
2401: EXCEPTION
2402: WHEN NO_DATA_FOUND THEN
2403: fnd_file.put_line(FND_FILE.LOG,'Pricing entity archive completed with Warnings');
2404: fnd_file.put_line(FND_FILE.LOG,'No Data Found - 0 Records Archived');
2405:
2406: errbuf := 'No Data Found - 0 Records Archived';
2407: retcode := 1;
2408:

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

2410: INSERT_CRITERIA(p_archive_name,p_entity_type,p_source_system_code,p_entity,p_all_lines,p_product_context,
2411: p_product_attribute,p_product_attr_value_from,p_product_attr_value_to,p_start_date_active,
2412: p_end_date_active,p_creation_date,p_created_by,l_user_id,l_conc_request_id,'W');
2413: WHEN OTHERS THEN
2414: fnd_file.put_line(FND_FILE.LOG,'Error in Pricing entity archive Routine ');
2415: fnd_file.put_line(FND_FILE.LOG,substr(sqlerrm,1,300));
2416:
2417: retcode := 2;
2418:

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

2411: p_product_attribute,p_product_attr_value_from,p_product_attr_value_to,p_start_date_active,
2412: p_end_date_active,p_creation_date,p_created_by,l_user_id,l_conc_request_id,'W');
2413: WHEN OTHERS THEN
2414: fnd_file.put_line(FND_FILE.LOG,'Error in Pricing entity archive Routine ');
2415: fnd_file.put_line(FND_FILE.LOG,substr(sqlerrm,1,300));
2416:
2417: retcode := 2;
2418:
2419: --Call INSERT_CRITERIA to insert records into QP_ARCH_CRITERIA_HEADERS and QP_ARCH_CRITERIA_LINES