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

Line 41: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CP : GENERATE_XML(OC) : START ');

37: (select concatenated_segments from mtl_system_items_kfv where inventory_item_id = OBJECT_ID and organization_id = Plant),2,
38: (select resources from cr_rsrc_dtl where resource_id = OBJECT_ID),3,
39: (select meaning from fnd_lookups where lookup_type = 'GMO_OC_TRANS_LOV' and lookup_code = OBJECT_ID),null) from dual;
40: BEGIN
41: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CP : GENERATE_XML(OC) : START ');
42: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Input Parameter - Plant :'||Plant||' and Object Type:'||Object_type||' and Object_id :'||Object_id||' From Date :'||FromDate||' To Date :'||ToDate||' Operator_id:'||Operator_id);
43: l_from_date := null;
44: l_to_date := null;
45:

Line 42: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Input Parameter - Plant :'||Plant||' and Object Type:'||Object_type||' and Object_id :'||Object_id||' From Date :'||FromDate||' To Date :'||ToDate||' Operator_id:'||Operator_id);

38: (select resources from cr_rsrc_dtl where resource_id = OBJECT_ID),3,
39: (select meaning from fnd_lookups where lookup_type = 'GMO_OC_TRANS_LOV' and lookup_code = OBJECT_ID),null) from dual;
40: BEGIN
41: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CP : GENERATE_XML(OC) : START ');
42: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Input Parameter - Plant :'||Plant||' and Object Type:'||Object_type||' and Object_id :'||Object_id||' From Date :'||FromDate||' To Date :'||ToDate||' Operator_id:'||Operator_id);
43: l_from_date := null;
44: l_to_date := null;
45:
46: IF(FromDate IS NOT NULL) THEN

Line 52: FND_FILE.PUT_LINE (FND_FILE.LOG,'l_from_date :'||l_from_date||'l_to_date :'||l_to_date);

48: END IF;
49: IF(ToDate IS NOT NULL) THEN
50: l_to_date := substr(ToDate,0,10);
51: END IF;
52: FND_FILE.PUT_LINE (FND_FILE.LOG,'l_from_date :'||l_from_date||'l_to_date :'||l_to_date);
53:
54: OPEN GET_ORG_NAME;
55: FETCH GET_ORG_NAME INTO l_org_name, l_org_code;
56: CLOSE GET_ORG_NAME;

Line 122: FND_FILE.put_line(FND_FILE.LOG,'SQL Query: '||l_argument_string);

118: l_argument_string := l_argument_string || ' and oc_hdr.Object_id =:c';
119: ELSE
120: l_argument_string := l_argument_string || ' and 1 =:c';
121: END IF;
122: FND_FILE.put_line(FND_FILE.LOG,'SQL Query: '||l_argument_string);
123:
124: IF(l_from_date IS NOT NULL) THEN
125: l_argument_string := l_argument_string || ' and TRUNC(oc_trans_hdr.creation_date) >=TO_DATE( :d , ''YYYY/MM/DD'')';
126: else

Line 141: FND_FILE.put_line(FND_FILE.LOG,'SQL Query'||l_argument_string);

137: ELSE
138: l_argument_string := l_argument_string || ' and 1 = :f';
139: END IF;
140:
141: FND_FILE.put_line(FND_FILE.LOG,'SQL Query'||l_argument_string);
142: OPEN l_refcur FOR l_argument_string
143: USING l_org_code, l_object_type, l_object, l_from_date, l_to_date,l_operator_name,l_org_name,Plant, nvl(object_type,1),nvl(object_id,1), nvl(l_from_date, 1), nvl(l_to_date,1),nvl(Operator_id,1);
144: FETCH l_refcur INTO l_result;
145: CLOSE l_refcur;

Line 150: FND_FILE.PUT(FND_FILE.LOG, 'Size'||l_len);

146:
147: l_limit:= 1;
148: l_final_clob := l_result.getClobVal();
149: l_len := DBMS_LOB.GETLENGTH (l_final_clob);
150: FND_FILE.PUT(FND_FILE.LOG, 'Size'||l_len);
151: LOOP
152: IF l_len > l_limit THEN
153: l_xml_data := DBMS_LOB.SUBSTR (l_final_clob,10,l_limit);
154: FND_FILE.PUT(FND_FILE.OUTPUT,l_xml_data);

Line 154: FND_FILE.PUT(FND_FILE.OUTPUT,l_xml_data);

150: FND_FILE.PUT(FND_FILE.LOG, 'Size'||l_len);
151: LOOP
152: IF l_len > l_limit THEN
153: l_xml_data := DBMS_LOB.SUBSTR (l_final_clob,10,l_limit);
154: FND_FILE.PUT(FND_FILE.OUTPUT,l_xml_data);
155: FND_FILE.PUT(FND_FILE.LOG,l_xml_data);
156: l_xml_data := NULL;
157: l_limit:= l_limit + 10;
158: ELSE

Line 155: FND_FILE.PUT(FND_FILE.LOG,l_xml_data);

151: LOOP
152: IF l_len > l_limit THEN
153: l_xml_data := DBMS_LOB.SUBSTR (l_final_clob,10,l_limit);
154: FND_FILE.PUT(FND_FILE.OUTPUT,l_xml_data);
155: FND_FILE.PUT(FND_FILE.LOG,l_xml_data);
156: l_xml_data := NULL;
157: l_limit:= l_limit + 10;
158: ELSE
159: l_xml_data := DBMS_LOB.SUBSTR (l_final_clob,10,l_limit);

Line 160: FND_FILE.PUT(FND_FILE.OUTPUT, l_xml_data);

156: l_xml_data := NULL;
157: l_limit:= l_limit + 10;
158: ELSE
159: l_xml_data := DBMS_LOB.SUBSTR (l_final_clob,10,l_limit);
160: FND_FILE.PUT(FND_FILE.OUTPUT, l_xml_data);
161: FND_FILE.PUT(FND_FILE.LOG,l_xml_data);
162: l_xml_data := NULL;
163: EXIT;
164: END IF;

Line 161: FND_FILE.PUT(FND_FILE.LOG,l_xml_data);

157: l_limit:= l_limit + 10;
158: ELSE
159: l_xml_data := DBMS_LOB.SUBSTR (l_final_clob,10,l_limit);
160: FND_FILE.PUT(FND_FILE.OUTPUT, l_xml_data);
161: FND_FILE.PUT(FND_FILE.LOG,l_xml_data);
162: l_xml_data := NULL;
163: EXIT;
164: END IF;
165: END LOOP;

Line 166: fnd_file.put_line(FND_FILE.LOG, 'CP : GENERATE_XML(OC) : FINISH ');

162: l_xml_data := NULL;
163: EXIT;
164: END IF;
165: END LOOP;
166: fnd_file.put_line(FND_FILE.LOG, 'CP : GENERATE_XML(OC) : FINISH ');
167: EXCEPTION
168: WHEN OTHERS THEN
169: fnd_file.put_line(fnd_file.log,SQLERRM);
170: fnd_file.new_line(fnd_file.log,2);

Line 169: fnd_file.put_line(fnd_file.log,SQLERRM);

165: END LOOP;
166: fnd_file.put_line(FND_FILE.LOG, 'CP : GENERATE_XML(OC) : FINISH ');
167: EXCEPTION
168: WHEN OTHERS THEN
169: fnd_file.put_line(fnd_file.log,SQLERRM);
170: fnd_file.new_line(fnd_file.log,2);
171: fnd_file.put_line(fnd_file.log, fnd_message.get_string('GMO', 'GMO_OPCERT_XML_ERR') );
172: RETURN;
173: END GENERATE_OC_TRANS_XML;

Line 170: fnd_file.new_line(fnd_file.log,2);

166: fnd_file.put_line(FND_FILE.LOG, 'CP : GENERATE_XML(OC) : FINISH ');
167: EXCEPTION
168: WHEN OTHERS THEN
169: fnd_file.put_line(fnd_file.log,SQLERRM);
170: fnd_file.new_line(fnd_file.log,2);
171: fnd_file.put_line(fnd_file.log, fnd_message.get_string('GMO', 'GMO_OPCERT_XML_ERR') );
172: RETURN;
173: END GENERATE_OC_TRANS_XML;
174: END GMO_OC_TRANS_PKG;

Line 171: fnd_file.put_line(fnd_file.log, fnd_message.get_string('GMO', 'GMO_OPCERT_XML_ERR') );

167: EXCEPTION
168: WHEN OTHERS THEN
169: fnd_file.put_line(fnd_file.log,SQLERRM);
170: fnd_file.new_line(fnd_file.log,2);
171: fnd_file.put_line(fnd_file.log, fnd_message.get_string('GMO', 'GMO_OPCERT_XML_ERR') );
172: RETURN;
173: END GENERATE_OC_TRANS_XML;
174: END GMO_OC_TRANS_PKG;