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

Line 22: fnd_file.put_line(fnd_file.log, 'Start the export of Pricelists to the Interface table');

18: l_list_header_id number;
19:
20: BEGIN
21:
22: fnd_file.put_line(fnd_file.log, 'Start the export of Pricelists to the Interface table');
23: fnd_file.put_line(fnd_file.log, 'Price List ID From: '||to_char(list_from));
24: fnd_file.put_line(fnd_file.log, 'Price List ID TO : '||to_char(list_to));
25:
26: fnd_file.put_line(fnd_file.log, 'Interface Action Code: '||interface_action);

Line 23: fnd_file.put_line(fnd_file.log, 'Price List ID From: '||to_char(list_from));

19:
20: BEGIN
21:
22: fnd_file.put_line(fnd_file.log, 'Start the export of Pricelists to the Interface table');
23: fnd_file.put_line(fnd_file.log, 'Price List ID From: '||to_char(list_from));
24: fnd_file.put_line(fnd_file.log, 'Price List ID TO : '||to_char(list_to));
25:
26: fnd_file.put_line(fnd_file.log, 'Interface Action Code: '||interface_action);
27: if interface_action is not NULL and

Line 24: fnd_file.put_line(fnd_file.log, 'Price List ID TO : '||to_char(list_to));

20: BEGIN
21:
22: fnd_file.put_line(fnd_file.log, 'Start the export of Pricelists to the Interface table');
23: fnd_file.put_line(fnd_file.log, 'Price List ID From: '||to_char(list_from));
24: fnd_file.put_line(fnd_file.log, 'Price List ID TO : '||to_char(list_to));
25:
26: fnd_file.put_line(fnd_file.log, 'Interface Action Code: '||interface_action);
27: if interface_action is not NULL and
28: (interface_action = 'INSERT' or

Line 26: fnd_file.put_line(fnd_file.log, 'Interface Action Code: '||interface_action);

22: fnd_file.put_line(fnd_file.log, 'Start the export of Pricelists to the Interface table');
23: fnd_file.put_line(fnd_file.log, 'Price List ID From: '||to_char(list_from));
24: fnd_file.put_line(fnd_file.log, 'Price List ID TO : '||to_char(list_to));
25:
26: fnd_file.put_line(fnd_file.log, 'Interface Action Code: '||interface_action);
27: if interface_action is not NULL and
28: (interface_action = 'INSERT' or
29: interface_action = 'UPDATE' or
30: interface_action = 'DELETE') then

Line 35: fnd_file.put_line(fnd_file.log, 'G Interface Action Code: '||g_interface_action);

31: g_interface_action := interface_action;
32: else
33: g_interface_action := 'INSERT';
34: end if;
35: fnd_file.put_line(fnd_file.log, 'G Interface Action Code: '||g_interface_action);
36: OPEN C_PRIC_HEADER;
37: LOOP
38: FETCH C_PRIC_HEADER into l_list_header_id;
39:

Line 42: fnd_file.put_line(fnd_file.log, 'Processing Price List : '||to_char(l_list_header_id));

38: FETCH C_PRIC_HEADER into l_list_header_id;
39:
40: EXIT WHEN C_PRIC_HEADER%NOTFOUND;
41:
42: fnd_file.put_line(fnd_file.log, 'Processing Price List : '||to_char(l_list_header_id));
43: export_tmp_lists(
44: list_from => l_list_header_id,
45: p_entity_name => p_entity_name);
46: commit;

Line 47: fnd_file.put_line(fnd_file.log, 'END Processing Price List : '||to_char(l_list_header_id));

43: export_tmp_lists(
44: list_from => l_list_header_id,
45: p_entity_name => p_entity_name);
46: commit;
47: fnd_file.put_line(fnd_file.log, 'END Processing Price List : '||to_char(l_list_header_id));
48: END LOOP;
49: fnd_file.put_line(fnd_file.log, 'END Processing ');
50: END;
51:

Line 49: fnd_file.put_line(fnd_file.log, 'END Processing ');

45: p_entity_name => p_entity_name);
46: commit;
47: fnd_file.put_line(fnd_file.log, 'END Processing Price List : '||to_char(l_list_header_id));
48: END LOOP;
49: fnd_file.put_line(fnd_file.log, 'END Processing ');
50: END;
51:
52: PROCEDURE EXPORT_TMP_LISTS
53: (

Line 81: fnd_file.put_line(fnd_file.log, 'In EXPORT_TMP_LISTS ');

77: l_list_attrib_id number;
78: l_orig_sys_header_ref varchar2(50);
79:
80: BEGIN
81: fnd_file.put_line(fnd_file.log, 'In EXPORT_TMP_LISTS ');
82: l_PRICE_LIST_rec := QP_Price_List_Util.Query_Row
83: ( p_list_header_id => list_from
84: );
85: fnd_file.put_line(fnd_file.log, 'Inserting Pricelist '||l_PRICE_LIST_rec.name);

Line 85: fnd_file.put_line(fnd_file.log, 'Inserting Pricelist '||l_PRICE_LIST_rec.name);

81: fnd_file.put_line(fnd_file.log, 'In EXPORT_TMP_LISTS ');
82: l_PRICE_LIST_rec := QP_Price_List_Util.Query_Row
83: ( p_list_header_id => list_from
84: );
85: fnd_file.put_line(fnd_file.log, 'Inserting Pricelist '||l_PRICE_LIST_rec.name);
86: if g_interface_action = 'INSERT' then
87: l_orig_sys_header_ref := p_entity_name || l_PRICE_LIST_rec.list_header_id;
88: else
89: begin

Line 239: fnd_file.put_line(fnd_file.log, 'Inserted Pricelist ORIG_SYS_HEADER_REF'|| p_entity_name || l_PRICE_LIST_rec.list_header_id);

235: --added for MOAC - uncommented below for MOAC
236: ,l_PRICE_LIST_rec.org_id
237: ,l_PRICE_LIST_rec.global_flag);
238:
239: fnd_file.put_line(fnd_file.log, 'Inserted Pricelist ORIG_SYS_HEADER_REF'|| p_entity_name || l_PRICE_LIST_rec.list_header_id);
240:
241: OPEN C_PRIC_QUALIFIERS;
242: LOOP
243: FETCH C_PRIC_QUALIFIERS into l_list_qualifier_id;

Line 245: fnd_file.put_line(fnd_file.log, 'Processing Qualifier : '||to_char(l_list_qualifier_id));

241: OPEN C_PRIC_QUALIFIERS;
242: LOOP
243: FETCH C_PRIC_QUALIFIERS into l_list_qualifier_id;
244: EXIT WHEN C_PRIC_QUALIFIERS%NOTFOUND;
245: fnd_file.put_line(fnd_file.log, 'Processing Qualifier : '||to_char(l_list_qualifier_id));
246: export_tmp_qualifiers(
247: list_from => l_list_qualifier_id,
248: p_entity_name => p_entity_name);
249:

Line 251: fnd_file.put_line(fnd_file.log, 'END Processing Qualifier : '||to_char(l_list_qualifier_id));

247: list_from => l_list_qualifier_id,
248: p_entity_name => p_entity_name);
249:
250: END LOOP;
251: fnd_file.put_line(fnd_file.log, 'END Processing Qualifier : '||to_char(l_list_qualifier_id));
252:
253: OPEN C_PRIC_LINES;
254: LOOP
255: FETCH C_PRIC_LINES into l_list_line_id;

Line 257: fnd_file.put_line(fnd_file.log, 'Processing Price List line : '||to_char(l_list_line_id));

253: OPEN C_PRIC_LINES;
254: LOOP
255: FETCH C_PRIC_LINES into l_list_line_id;
256: EXIT WHEN C_PRIC_LINES%NOTFOUND;
257: fnd_file.put_line(fnd_file.log, 'Processing Price List line : '||to_char(l_list_line_id));
258: export_tmp_lines(
259: list_from => l_list_line_id,
260: p_entity_name => p_entity_name);
261:

Line 263: fnd_file.put_line(fnd_file.log, 'END Processing Price List Line: '||to_char(l_list_line_id));

259: list_from => l_list_line_id,
260: p_entity_name => p_entity_name);
261:
262: END LOOP;
263: fnd_file.put_line(fnd_file.log, 'END Processing Price List Line: '||to_char(l_list_line_id));
264:
265: OPEN C_PRIC_ATTRIBS;
266: LOOP
267: FETCH C_PRIC_ATTRIBS into l_list_attrib_id;

Line 269: fnd_file.put_line(fnd_file.log, 'Processing Product/Price Attribs : '||to_char(l_list_attrib_id));

265: OPEN C_PRIC_ATTRIBS;
266: LOOP
267: FETCH C_PRIC_ATTRIBS into l_list_attrib_id;
268: EXIT WHEN C_PRIC_ATTRIBS%NOTFOUND;
269: fnd_file.put_line(fnd_file.log, 'Processing Product/Price Attribs : '||to_char(l_list_attrib_id));
270: export_tmp_attribs(
271: list_from => l_list_attrib_id,
272: p_entity_name => p_entity_name);
273:

Line 275: fnd_file.put_line(fnd_file.log, 'END Processing Product/Price Attribs : '||to_char(l_list_attrib_id));

271: list_from => l_list_attrib_id,
272: p_entity_name => p_entity_name);
273:
274: END LOOP;
275: fnd_file.put_line(fnd_file.log, 'END Processing Product/Price Attribs : '||to_char(l_list_attrib_id));
276: END ;
277:
278: PROCEDURE EXPORT_TMP_QUALIFIERS
279: (

Line 290: fnd_file.put_line(fnd_file.log, 'In EXPORT_TMP_QUALIFIERS ');

286: l_orig_sys_line_ref varchar2(50);
287: l_orig_sys_qualifier_ref varchar2(50);
288:
289: Begin
290: fnd_file.put_line(fnd_file.log, 'In EXPORT_TMP_QUALIFIERS ');
291: l_QUALIFIER_rec := QP_QUALIFIERS_UTIL.Query_Row
292: ( p_qualifier_id => list_from
293: );
294: fnd_file.put_line(fnd_file.log, 'Inserting Qualifier '||to_char(l_QUALIFIER_rec.qualifier_id));

Line 294: fnd_file.put_line(fnd_file.log, 'Inserting Qualifier '||to_char(l_QUALIFIER_rec.qualifier_id));

290: fnd_file.put_line(fnd_file.log, 'In EXPORT_TMP_QUALIFIERS ');
291: l_QUALIFIER_rec := QP_QUALIFIERS_UTIL.Query_Row
292: ( p_qualifier_id => list_from
293: );
294: fnd_file.put_line(fnd_file.log, 'Inserting Qualifier '||to_char(l_QUALIFIER_rec.qualifier_id));
295: if g_interface_action = 'INSERT' then
296: l_orig_sys_qualifier_ref := p_entity_name || l_QUALIFIER_rec.qualifier_id;
297: l_orig_sys_header_ref := p_entity_name || l_QUALIFIER_rec.list_header_id;
298: else

Line 425: fnd_file.put_line(fnd_file.log, 'Inserted Qualifier '|| (p_entity_name || to_char(l_Qualifier_Rec.qualifier_id)));

421: ,l_orig_sys_header_ref --(p_entity_name || to_char(l_Qualifier_Rec.list_header_id))
422: ,l_orig_sys_qualifier_ref --(p_entity_name || to_char(l_Qualifier_Rec.qualifier_id))
423: ,NULL
424: ,l_Qualifier_Rec.QUALIFY_HIER_DESCENDENT_FLAG);
425: fnd_file.put_line(fnd_file.log, 'Inserted Qualifier '|| (p_entity_name || to_char(l_Qualifier_Rec.qualifier_id)));
426: end;
427:
428: PROCEDURE EXPORT_TMP_LINES
429: (

Line 440: fnd_file.put_line(fnd_file.log, 'In EXPORT_TMP_LINES ');

436: l_orig_sys_line_ref varchar2(50);
437: l_orig_sys_pricing_attr_ref varchar2(50);
438: l_price_break_header_ref varchar2(50);
439: Begin
440: fnd_file.put_line(fnd_file.log, 'In EXPORT_TMP_LINES ');
441: l_LINE_rec := QP_Price_List_Line_Util.Query_Row
442: ( p_list_line_id => list_from
443: );
444: fnd_file.put_line(fnd_file.log, 'Inserting Line '||to_char(l_LINE_rec.list_line_id));

Line 444: fnd_file.put_line(fnd_file.log, 'Inserting Line '||to_char(l_LINE_rec.list_line_id));

440: fnd_file.put_line(fnd_file.log, 'In EXPORT_TMP_LINES ');
441: l_LINE_rec := QP_Price_List_Line_Util.Query_Row
442: ( p_list_line_id => list_from
443: );
444: fnd_file.put_line(fnd_file.log, 'Inserting Line '||to_char(l_LINE_rec.list_line_id));
445: if g_interface_action = 'INSERT' then
446: l_orig_sys_line_ref := p_entity_name || l_LINE_rec.list_line_id;
447: l_orig_sys_header_ref := p_entity_name || l_LINE_rec.list_header_id;
448: if l_LINE_Rec.from_rltd_modifier_id is not NULL then

Line 674: fnd_file.put_line(fnd_file.log, 'Inserted Line '|| p_entity_name || to_char(l_LINE_Rec.list_line_id));

670: --, p_entity_name || to_char(l_LINE_Rec.list_header_id)
671: , l_LINE_Rec.RECURRING_VALUE
672: , NULL); --l_LINE_Rec.NET_AMOUNT_FLAG);
673:
674: fnd_file.put_line(fnd_file.log, 'Inserted Line '|| p_entity_name || to_char(l_LINE_Rec.list_line_id));
675:
676: end;
677:
678: PROCEDURE EXPORT_TMP_ATTRIBS

Line 689: fnd_file.put_line(fnd_file.log, 'In EXPORT_TMP_ATTRIBS ');

685: l_orig_sys_header_ref varchar2(50);
686: l_orig_sys_line_ref varchar2(50);
687: l_orig_sys_pricing_attr_ref varchar2(50);
688: begin
689: fnd_file.put_line(fnd_file.log, 'In EXPORT_TMP_ATTRIBS ');
690: l_attribs_rec := Qp_pll_pricing_attr_Util.Query_Row
691: ( p_pricing_attribute_id => list_from
692: );
693: fnd_file.put_line(fnd_file.log, 'Inserting Attribs '||to_char(l_attribs_rec.pricing_attribute_id));

Line 693: fnd_file.put_line(fnd_file.log, 'Inserting Attribs '||to_char(l_attribs_rec.pricing_attribute_id));

689: fnd_file.put_line(fnd_file.log, 'In EXPORT_TMP_ATTRIBS ');
690: l_attribs_rec := Qp_pll_pricing_attr_Util.Query_Row
691: ( p_pricing_attribute_id => list_from
692: );
693: fnd_file.put_line(fnd_file.log, 'Inserting Attribs '||to_char(l_attribs_rec.pricing_attribute_id));
694: if g_interface_action = 'INSERT' then
695: l_orig_sys_pricing_attr_ref := p_entity_name || l_attribs_rec.pricing_attribute_id;
696: l_orig_sys_line_ref := p_entity_name || l_attribs_rec.list_line_id;
697: l_orig_sys_header_ref := p_entity_name || l_attribs_rec.list_header_id;

Line 832: fnd_file.put_line(fnd_file.log, 'Inserting Attribs '||(p_entity_name || to_char(l_attribs_rec.pricing_attribute_id)));

828: ,l_ORIG_SYS_LINE_REF
829: ,l_ORIG_SYS_HEADER_REF);
830: --,(p_entity_name || to_char(l_attribs_rec.list_line_id)) --ORIG_SYS_LINE_REF
831: --,(p_entity_name || to_char(l_attribs_rec.list_header_id))); --ORIG_SYS_HEADER_REF);
832: fnd_file.put_line(fnd_file.log, 'Inserting Attribs '||(p_entity_name || to_char(l_attribs_rec.pricing_attribute_id)));
833:
834: end;
835:
836: END QP_BULK_EXPORT_TMP_PVT;