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

Line 73: fnd_file.put_line(FND_FILE.LOG,' ');

69:
70: SELECT Trim(FND_PROFILE.VALUE('PO_EDA_FILES_LOCATION')) INTO v_out_dir FROM dual;
71: v_out_file := UTL_FILE.FOPEN(v_out_dir,p_clm_document_number||'_'||l_timestamp||'.idx', 'w',32000);
72:
73: fnd_file.put_line(FND_FILE.LOG,' ');
74: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
75: fnd_file.put_line(FND_FILE.LOG,'Output Directory: ' || v_out_dir);
76: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
77: fnd_file.put_line(FND_FILE.LOG,'CLM Document Number '||p_clm_document_number);

Line 74: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);

70: SELECT Trim(FND_PROFILE.VALUE('PO_EDA_FILES_LOCATION')) INTO v_out_dir FROM dual;
71: v_out_file := UTL_FILE.FOPEN(v_out_dir,p_clm_document_number||'_'||l_timestamp||'.idx', 'w',32000);
72:
73: fnd_file.put_line(FND_FILE.LOG,' ');
74: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
75: fnd_file.put_line(FND_FILE.LOG,'Output Directory: ' || v_out_dir);
76: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
77: fnd_file.put_line(FND_FILE.LOG,'CLM Document Number '||p_clm_document_number);
78: fnd_file.put_line(FND_FILE.LOG,'Is Mod '||P_IS_MOD);

Line 75: fnd_file.put_line(FND_FILE.LOG,'Output Directory: ' || v_out_dir);

71: v_out_file := UTL_FILE.FOPEN(v_out_dir,p_clm_document_number||'_'||l_timestamp||'.idx', 'w',32000);
72:
73: fnd_file.put_line(FND_FILE.LOG,' ');
74: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
75: fnd_file.put_line(FND_FILE.LOG,'Output Directory: ' || v_out_dir);
76: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
77: fnd_file.put_line(FND_FILE.LOG,'CLM Document Number '||p_clm_document_number);
78: fnd_file.put_line(FND_FILE.LOG,'Is Mod '||P_IS_MOD);
79: fnd_file.put_line(FND_FILE.LOG,'System Name '||p_system_name);

Line 76: fnd_file.put_line(FND_FILE.LOG,'Parameters ');

72:
73: fnd_file.put_line(FND_FILE.LOG,' ');
74: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
75: fnd_file.put_line(FND_FILE.LOG,'Output Directory: ' || v_out_dir);
76: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
77: fnd_file.put_line(FND_FILE.LOG,'CLM Document Number '||p_clm_document_number);
78: fnd_file.put_line(FND_FILE.LOG,'Is Mod '||P_IS_MOD);
79: fnd_file.put_line(FND_FILE.LOG,'System Name '||p_system_name);
80:

Line 77: fnd_file.put_line(FND_FILE.LOG,'CLM Document Number '||p_clm_document_number);

73: fnd_file.put_line(FND_FILE.LOG,' ');
74: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
75: fnd_file.put_line(FND_FILE.LOG,'Output Directory: ' || v_out_dir);
76: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
77: fnd_file.put_line(FND_FILE.LOG,'CLM Document Number '||p_clm_document_number);
78: fnd_file.put_line(FND_FILE.LOG,'Is Mod '||P_IS_MOD);
79: fnd_file.put_line(FND_FILE.LOG,'System Name '||p_system_name);
80:
81:

Line 78: fnd_file.put_line(FND_FILE.LOG,'Is Mod '||P_IS_MOD);

74: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
75: fnd_file.put_line(FND_FILE.LOG,'Output Directory: ' || v_out_dir);
76: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
77: fnd_file.put_line(FND_FILE.LOG,'CLM Document Number '||p_clm_document_number);
78: fnd_file.put_line(FND_FILE.LOG,'Is Mod '||P_IS_MOD);
79: fnd_file.put_line(FND_FILE.LOG,'System Name '||p_system_name);
80:
81:
82: p_draft_id := -1;

Line 79: fnd_file.put_line(FND_FILE.LOG,'System Name '||p_system_name);

75: fnd_file.put_line(FND_FILE.LOG,'Output Directory: ' || v_out_dir);
76: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
77: fnd_file.put_line(FND_FILE.LOG,'CLM Document Number '||p_clm_document_number);
78: fnd_file.put_line(FND_FILE.LOG,'Is Mod '||P_IS_MOD);
79: fnd_file.put_line(FND_FILE.LOG,'System Name '||p_system_name);
80:
81:
82: p_draft_id := -1;
83:

Line 95: fnd_file.put_line(FND_FILE.LOG,'p_doc_id '||p_doc_id);

91: CLOSE c_getdocdetails;
92:
93: END IF;
94:
95: fnd_file.put_line(FND_FILE.LOG,'p_doc_id '||p_doc_id);
96: fnd_file.put_line(FND_FILE.LOG,'p_draft_id '||p_draft_id);
97:
98: RecordID := p_doc_id;
99:

Line 96: fnd_file.put_line(FND_FILE.LOG,'p_draft_id '||p_draft_id);

92:
93: END IF;
94:
95: fnd_file.put_line(FND_FILE.LOG,'p_doc_id '||p_doc_id);
96: fnd_file.put_line(FND_FILE.LOG,'p_draft_id '||p_draft_id);
97:
98: RecordID := p_doc_id;
99:
100: OPEN c_isorderoffidv;

Line 104: fnd_file.put_line(FND_FILE.LOG,'l_isorderoffidv '||l_isorderoffidv);

100: OPEN c_isorderoffidv;
101: FETCH c_isorderoffidv INTO l_isorderoffidv;
102: CLOSE c_isorderoffidv;
103:
104: fnd_file.put_line(FND_FILE.LOG,'l_isorderoffidv '||l_isorderoffidv);
105:
106: IF l_isorderoffidv = 'N' THEN
107: ContractNumber := PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_HEADER_EXT_ATTRS',
108: pk1_value => p_doc_id,

Line 115: fnd_file.put_line(FND_FILE.LOG,'ContractNumber '||ContractNumber);

111: p_attr_int_name => 'DOC_NUMBER') ;
112:
113: ContractNumber := REPLACE(ContractNumber,'-','');
114:
115: fnd_file.put_line(FND_FILE.LOG,'ContractNumber '||ContractNumber);
116:
117: l_modiftype := PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_HEADER_EXT_ATTRS',
118: pk1_value => p_doc_id,
119: pk2_value => p_draft_id,

Line 123: fnd_file.put_line(FND_FILE.LOG,'l_modiftype '||l_modiftype);

119: pk2_value => p_draft_id,
120: p_attr_grp_int_name => 'DOD_AWD_MOD',
121: p_attr_int_name => 'MODIF_TYPE');
122:
123: fnd_file.put_line(FND_FILE.LOG,'l_modiftype '||l_modiftype);
124:
125: IF l_modiftype = 'ACO' THEN
126: ACOMod := 'A' || PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_HEADER_EXT_ATTRS',
127: pk1_value => p_doc_id,

Line 132: fnd_file.put_line(FND_FILE.LOG,'ACOMod '||ACOMod);

128: pk2_value => p_draft_id,
129: p_attr_grp_int_name => 'DOD_AWD_MOD',
130: p_attr_int_name => 'SERIAL_NUMBER') ;
131:
132: fnd_file.put_line(FND_FILE.LOG,'ACOMod '||ACOMod);
133:
134: ELSIF l_modiftype = 'PCO' THEN
135: PCOMod := 'P' || PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_HEADER_EXT_ATTRS',
136: pk1_value => p_doc_id,

Line 141: fnd_file.put_line(FND_FILE.LOG,'PCOMod '||PCOMod);

137: pk2_value => p_draft_id,
138: p_attr_grp_int_name => 'DOD_AWD_MOD',
139: p_attr_int_name => 'SERIAL_NUMBER') ;
140:
141: fnd_file.put_line(FND_FILE.LOG,'PCOMod '||PCOMod);
142:
143: END IF;
144:
145: ELSE

Line 154: fnd_file.put_line(FND_FILE.LOG,'ContractNumber '||ContractNumber);

150: p_attr_int_name => 'SOURCE_DOC_NUM') ;
151:
152: ContractNumber := REPLACE(ContractNumber,'-','');
153:
154: fnd_file.put_line(FND_FILE.LOG,'ContractNumber '||ContractNumber);
155:
156: l_modiftype := PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_HEADER_EXT_ATTRS',
157: pk1_value => p_doc_id,
158: pk2_value => p_draft_id,

Line 162: fnd_file.put_line(FND_FILE.LOG,'l_modiftype '||l_modiftype);

158: pk2_value => p_draft_id,
159: p_attr_grp_int_name => 'DOD_ORD_MOD',
160: p_attr_int_name => 'MODIF_TYPE');
161:
162: fnd_file.put_line(FND_FILE.LOG,'l_modiftype '||l_modiftype);
163:
164:
165: IF l_modiftype = 'ACO' THEN
166: ACOMod := 'A' || PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_HEADER_EXT_ATTRS',

Line 172: fnd_file.put_line(FND_FILE.LOG,'ACOMod '||ACOMod);

168: pk2_value => p_draft_id,
169: p_attr_grp_int_name => 'DOD_ORD_MOD',
170: p_attr_int_name => 'SERIAL_NUMBER') ;
171:
172: fnd_file.put_line(FND_FILE.LOG,'ACOMod '||ACOMod);
173:
174: ELSIF l_modiftype = 'PCO' THEN
175: PCOMod := 'P' || PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_HEADER_EXT_ATTRS',
176: pk1_value => p_doc_id,

Line 181: fnd_file.put_line(FND_FILE.LOG,'PCOMod '||PCOMod);

177: pk2_value => p_draft_id,
178: p_attr_grp_int_name => 'DOD_ORD_MOD',
179: p_attr_int_name => 'SERIAL_NUMBER') ;
180:
181: fnd_file.put_line(FND_FILE.LOG,'PCOMod '||PCOMod);
182:
183: END IF;
184:
185: END IF;

Line 193: fnd_file.put_line(FND_FILE.LOG,'DeliveryOrder '||DeliveryOrder);

189: pk1_value => p_doc_id,
190: pk2_value => p_draft_id,
191: p_attr_grp_int_name => 'DOD_ORD_OW',
192: p_attr_int_name => 'SERIAL_NUMBER') ;
193: fnd_file.put_line(FND_FILE.LOG,'DeliveryOrder '||DeliveryOrder);
194:
195: OPEN c_issuedate;
196: FETCH c_issuedate INTO IssueDate;
197: CLOSE c_issuedate;

Line 200: fnd_file.put_line(FND_FILE.LOG,'IssueDate '||IssueDateInChar);

196: FETCH c_issuedate INTO IssueDate;
197: CLOSE c_issuedate;
198: IssueDateInChar := to_char(IssueDate,'YYYYMMDD');
199:
200: fnd_file.put_line(FND_FILE.LOG,'IssueDate '||IssueDateInChar);
201:
202: IF P_IS_MOD = 'Y' THEN
203:
204: IssuingDoDAAC := PO_UDA_PUB.GET_ADDRESS_ATTR_VALUE(p_entity_code => 'PO_HEADER_EXT_ATTRS',

Line 221: fnd_file.put_line(FND_FILE.LOG,'IssuingDoDAAC '||IssuingDoDAAC);

217: p_attr_int_name => 'addresscode',
218: p_address_type => 'ISSUING_OFFICE') ;
219: END IF;
220:
221: fnd_file.put_line(FND_FILE.LOG,'IssuingDoDAAC '||IssuingDoDAAC);
222:
223: IF P_IS_MOD = 'Y' THEN
224:
225: AdminDoDAAC := PO_UDA_PUB.GET_ADDRESS_ATTR_VALUE(p_entity_code => 'PO_HEADER_EXT_ATTRS',

Line 242: fnd_file.put_line(FND_FILE.LOG,'AdminDoDAAC '||AdminDoDAAC);

238: p_attr_grp_int_name => 'addresses',
239: p_attr_int_name => 'addresscode',
240: p_address_type => 'ADMIN_OFFICE') ;
241: END IF;
242: fnd_file.put_line(FND_FILE.LOG,'AdminDoDAAC '||AdminDoDAAC);
243:
244:
245: PayingDoDAAC := PO_UDA_PUB.GET_ADDRESS_ATTR_VALUE(p_entity_code => 'PO_HEADER_EXT_ATTRS',
246: pk1_value => p_doc_id,

Line 253: fnd_file.put_line(FND_FILE.LOG,'PayingDoDAAC '||PayingDoDAAC);

249: p_attr_int_name => 'addresscode',
250: p_address_type => 'PAY_OFFICE') ;
251:
252:
253: fnd_file.put_line(FND_FILE.LOG,'PayingDoDAAC '||PayingDoDAAC);
254:
255:
256: CAGECode := PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_HEADER_EXT_ATTRS',
257: pk1_value => p_doc_id,

Line 261: fnd_file.put_line(FND_FILE.LOG,'CAGECode '||CAGECode);

257: pk1_value => p_doc_id,
258: pk2_value => p_draft_id,
259: p_attr_grp_int_name => 'SUPPLIER_DTLS',
260: p_attr_int_name => 'CAGE_CODE') ;
261: fnd_file.put_line(FND_FILE.LOG,'CAGECode '||CAGECode);
262:
263: DUNS := PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_HEADER_EXT_ATTRS',
264: pk1_value => p_doc_id,
265: pk2_value => p_draft_id,

Line 268: fnd_file.put_line(FND_FILE.LOG,'DUNS '||DUNS);

264: pk1_value => p_doc_id,
265: pk2_value => p_draft_id,
266: p_attr_grp_int_name => 'SUPPLIER_DTLS',
267: p_attr_int_name => 'DUNS_NUM') ;
268: fnd_file.put_line(FND_FILE.LOG,'DUNS '||DUNS);
269:
270: IF DUNS IS NULL THEN
271: DUNS := PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_HEADER_EXT_ATTRS',
272: pk1_value => p_doc_id,

Line 276: fnd_file.put_line(FND_FILE.LOG,'DUNS4 '||DUNS);

272: pk1_value => p_doc_id,
273: pk2_value => p_draft_id,
274: p_attr_grp_int_name => 'SUPPLIER_DTLS',
275: p_attr_int_name => 'DUNS_4_NUM') ;
276: fnd_file.put_line(FND_FILE.LOG,'DUNS4 '||DUNS);
277:
278: END IF;
279:
280: IndexDate := to_char(SYSDATE,'YYYYMMDDHH:MM:SS');

Line 282: fnd_file.put_line(FND_FILE.OUTPUT,TransactionCode ||','||

278: END IF;
279:
280: IndexDate := to_char(SYSDATE,'YYYYMMDDHH:MM:SS');
281:
282: fnd_file.put_line(FND_FILE.OUTPUT,TransactionCode ||','||
283: SystemName ||','||
284: RecordID ||','||
285: ContractNumber ||','||
286: DeliveryOrder ||','||

Line 318: fnd_file.put_line(FND_FILE.LOG,'Exception'||SQLERRM);

314:
315:
316: EXCEPTION WHEN OTHERS THEN
317:
318: fnd_file.put_line(FND_FILE.LOG,'Exception'||SQLERRM);
319:
320: END gen_eda_idx;
321:
322:

Line 552: fnd_file.put_line(FND_FILE.LOG,'batch size: '|| l_max_doc_in_batch);

548: when others then
549: l_max_doc_in_batch := 5;
550: end;
551:
552: fnd_file.put_line(FND_FILE.LOG,'batch size: '|| l_max_doc_in_batch);
553:
554: OPEN csr_get_doc_nbr;
555: FETCH csr_get_doc_nbr BULK COLLECT INTO l_doc_numbers;
556: CLOSE csr_get_doc_nbr;

Line 577: fnd_file.put_line(FND_FILE.LOG,'CLM Document Numbers collected');

573:
574:
575: FOR i IN l_batch_start..l_batch_end LOOP
576:
577: fnd_file.put_line(FND_FILE.LOG,'CLM Document Numbers collected');
578: fnd_file.put_line(FND_FILE.LOG,'CLM Document Numbers ' || l_doc_numbers(i));
579:
580: END LOOP ;
581:

Line 578: fnd_file.put_line(FND_FILE.LOG,'CLM Document Numbers ' || l_doc_numbers(i));

574:
575: FOR i IN l_batch_start..l_batch_end LOOP
576:
577: fnd_file.put_line(FND_FILE.LOG,'CLM Document Numbers collected');
578: fnd_file.put_line(FND_FILE.LOG,'CLM Document Numbers ' || l_doc_numbers(i));
579:
580: END LOOP ;
581:
582: IF req_data IS NULL THEN

Line 586: fnd_file.put_line(FND_FILE.LOG,' ');

582: IF req_data IS NULL THEN
583:
584:
585:
586: fnd_file.put_line(FND_FILE.LOG,' ');
587: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
588: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
589: fnd_file.put_line(FND_FILE.LOG,'Is Mod '||P_IS_MOD);
590: fnd_file.put_line(FND_FILE.LOG,'CLM Document Number '||p_clm_document_number);

Line 587: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);

583:
584:
585:
586: fnd_file.put_line(FND_FILE.LOG,' ');
587: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
588: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
589: fnd_file.put_line(FND_FILE.LOG,'Is Mod '||P_IS_MOD);
590: fnd_file.put_line(FND_FILE.LOG,'CLM Document Number '||p_clm_document_number);
591: fnd_file.put_line(FND_FILE.LOG,' ');

Line 588: fnd_file.put_line(FND_FILE.LOG,'Parameters ');

584:
585:
586: fnd_file.put_line(FND_FILE.LOG,' ');
587: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
588: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
589: fnd_file.put_line(FND_FILE.LOG,'Is Mod '||P_IS_MOD);
590: fnd_file.put_line(FND_FILE.LOG,'CLM Document Number '||p_clm_document_number);
591: fnd_file.put_line(FND_FILE.LOG,' ');
592: fnd_file.put_line(FND_FILE.LOG,'------Range Parameters------');

Line 589: fnd_file.put_line(FND_FILE.LOG,'Is Mod '||P_IS_MOD);

585:
586: fnd_file.put_line(FND_FILE.LOG,' ');
587: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
588: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
589: fnd_file.put_line(FND_FILE.LOG,'Is Mod '||P_IS_MOD);
590: fnd_file.put_line(FND_FILE.LOG,'CLM Document Number '||p_clm_document_number);
591: fnd_file.put_line(FND_FILE.LOG,' ');
592: fnd_file.put_line(FND_FILE.LOG,'------Range Parameters------');
593: fnd_file.put_line(FND_FILE.LOG,' ');

Line 590: fnd_file.put_line(FND_FILE.LOG,'CLM Document Number '||p_clm_document_number);

586: fnd_file.put_line(FND_FILE.LOG,' ');
587: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
588: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
589: fnd_file.put_line(FND_FILE.LOG,'Is Mod '||P_IS_MOD);
590: fnd_file.put_line(FND_FILE.LOG,'CLM Document Number '||p_clm_document_number);
591: fnd_file.put_line(FND_FILE.LOG,' ');
592: fnd_file.put_line(FND_FILE.LOG,'------Range Parameters------');
593: fnd_file.put_line(FND_FILE.LOG,' ');
594: fnd_file.put_line(FND_FILE.LOG,'CLM Document Number To '||p_clm_document_number2);

Line 591: fnd_file.put_line(FND_FILE.LOG,' ');

587: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
588: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
589: fnd_file.put_line(FND_FILE.LOG,'Is Mod '||P_IS_MOD);
590: fnd_file.put_line(FND_FILE.LOG,'CLM Document Number '||p_clm_document_number);
591: fnd_file.put_line(FND_FILE.LOG,' ');
592: fnd_file.put_line(FND_FILE.LOG,'------Range Parameters------');
593: fnd_file.put_line(FND_FILE.LOG,' ');
594: fnd_file.put_line(FND_FILE.LOG,'CLM Document Number To '||p_clm_document_number2);
595: fnd_file.put_line(FND_FILE.LOG,'Approved Date From'||p_approved_date);

Line 592: fnd_file.put_line(FND_FILE.LOG,'------Range Parameters------');

588: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
589: fnd_file.put_line(FND_FILE.LOG,'Is Mod '||P_IS_MOD);
590: fnd_file.put_line(FND_FILE.LOG,'CLM Document Number '||p_clm_document_number);
591: fnd_file.put_line(FND_FILE.LOG,' ');
592: fnd_file.put_line(FND_FILE.LOG,'------Range Parameters------');
593: fnd_file.put_line(FND_FILE.LOG,' ');
594: fnd_file.put_line(FND_FILE.LOG,'CLM Document Number To '||p_clm_document_number2);
595: fnd_file.put_line(FND_FILE.LOG,'Approved Date From'||p_approved_date);
596: fnd_file.put_line(FND_FILE.LOG,'Approved Date To '||p_approved_date2);

Line 593: fnd_file.put_line(FND_FILE.LOG,' ');

589: fnd_file.put_line(FND_FILE.LOG,'Is Mod '||P_IS_MOD);
590: fnd_file.put_line(FND_FILE.LOG,'CLM Document Number '||p_clm_document_number);
591: fnd_file.put_line(FND_FILE.LOG,' ');
592: fnd_file.put_line(FND_FILE.LOG,'------Range Parameters------');
593: fnd_file.put_line(FND_FILE.LOG,' ');
594: fnd_file.put_line(FND_FILE.LOG,'CLM Document Number To '||p_clm_document_number2);
595: fnd_file.put_line(FND_FILE.LOG,'Approved Date From'||p_approved_date);
596: fnd_file.put_line(FND_FILE.LOG,'Approved Date To '||p_approved_date2);
597: fnd_file.put_line(FND_FILE.LOG,'Effective Date From '||p_effective_date);

Line 594: fnd_file.put_line(FND_FILE.LOG,'CLM Document Number To '||p_clm_document_number2);

590: fnd_file.put_line(FND_FILE.LOG,'CLM Document Number '||p_clm_document_number);
591: fnd_file.put_line(FND_FILE.LOG,' ');
592: fnd_file.put_line(FND_FILE.LOG,'------Range Parameters------');
593: fnd_file.put_line(FND_FILE.LOG,' ');
594: fnd_file.put_line(FND_FILE.LOG,'CLM Document Number To '||p_clm_document_number2);
595: fnd_file.put_line(FND_FILE.LOG,'Approved Date From'||p_approved_date);
596: fnd_file.put_line(FND_FILE.LOG,'Approved Date To '||p_approved_date2);
597: fnd_file.put_line(FND_FILE.LOG,'Effective Date From '||p_effective_date);
598: fnd_file.put_line(FND_FILE.LOG,'Effective Date To '||p_effective_date2);

Line 595: fnd_file.put_line(FND_FILE.LOG,'Approved Date From'||p_approved_date);

591: fnd_file.put_line(FND_FILE.LOG,' ');
592: fnd_file.put_line(FND_FILE.LOG,'------Range Parameters------');
593: fnd_file.put_line(FND_FILE.LOG,' ');
594: fnd_file.put_line(FND_FILE.LOG,'CLM Document Number To '||p_clm_document_number2);
595: fnd_file.put_line(FND_FILE.LOG,'Approved Date From'||p_approved_date);
596: fnd_file.put_line(FND_FILE.LOG,'Approved Date To '||p_approved_date2);
597: fnd_file.put_line(FND_FILE.LOG,'Effective Date From '||p_effective_date);
598: fnd_file.put_line(FND_FILE.LOG,'Effective Date To '||p_effective_date2);
599: fnd_file.put_line(FND_FILE.LOG,'Document Status : '||p_doc_status);

Line 596: fnd_file.put_line(FND_FILE.LOG,'Approved Date To '||p_approved_date2);

592: fnd_file.put_line(FND_FILE.LOG,'------Range Parameters------');
593: fnd_file.put_line(FND_FILE.LOG,' ');
594: fnd_file.put_line(FND_FILE.LOG,'CLM Document Number To '||p_clm_document_number2);
595: fnd_file.put_line(FND_FILE.LOG,'Approved Date From'||p_approved_date);
596: fnd_file.put_line(FND_FILE.LOG,'Approved Date To '||p_approved_date2);
597: fnd_file.put_line(FND_FILE.LOG,'Effective Date From '||p_effective_date);
598: fnd_file.put_line(FND_FILE.LOG,'Effective Date To '||p_effective_date2);
599: fnd_file.put_line(FND_FILE.LOG,'Document Status : '||p_doc_status);
600: fnd_file.put_line(FND_FILE.LOG,'EDA Status : '||p_eda_status);

Line 597: fnd_file.put_line(FND_FILE.LOG,'Effective Date From '||p_effective_date);

593: fnd_file.put_line(FND_FILE.LOG,' ');
594: fnd_file.put_line(FND_FILE.LOG,'CLM Document Number To '||p_clm_document_number2);
595: fnd_file.put_line(FND_FILE.LOG,'Approved Date From'||p_approved_date);
596: fnd_file.put_line(FND_FILE.LOG,'Approved Date To '||p_approved_date2);
597: fnd_file.put_line(FND_FILE.LOG,'Effective Date From '||p_effective_date);
598: fnd_file.put_line(FND_FILE.LOG,'Effective Date To '||p_effective_date2);
599: fnd_file.put_line(FND_FILE.LOG,'Document Status : '||p_doc_status);
600: fnd_file.put_line(FND_FILE.LOG,'EDA Status : '||p_eda_status);
601:

Line 598: fnd_file.put_line(FND_FILE.LOG,'Effective Date To '||p_effective_date2);

594: fnd_file.put_line(FND_FILE.LOG,'CLM Document Number To '||p_clm_document_number2);
595: fnd_file.put_line(FND_FILE.LOG,'Approved Date From'||p_approved_date);
596: fnd_file.put_line(FND_FILE.LOG,'Approved Date To '||p_approved_date2);
597: fnd_file.put_line(FND_FILE.LOG,'Effective Date From '||p_effective_date);
598: fnd_file.put_line(FND_FILE.LOG,'Effective Date To '||p_effective_date2);
599: fnd_file.put_line(FND_FILE.LOG,'Document Status : '||p_doc_status);
600: fnd_file.put_line(FND_FILE.LOG,'EDA Status : '||p_eda_status);
601:
602: fnd_file.put_line(FND_FILE.LOG,' ');

Line 599: fnd_file.put_line(FND_FILE.LOG,'Document Status : '||p_doc_status);

595: fnd_file.put_line(FND_FILE.LOG,'Approved Date From'||p_approved_date);
596: fnd_file.put_line(FND_FILE.LOG,'Approved Date To '||p_approved_date2);
597: fnd_file.put_line(FND_FILE.LOG,'Effective Date From '||p_effective_date);
598: fnd_file.put_line(FND_FILE.LOG,'Effective Date To '||p_effective_date2);
599: fnd_file.put_line(FND_FILE.LOG,'Document Status : '||p_doc_status);
600: fnd_file.put_line(FND_FILE.LOG,'EDA Status : '||p_eda_status);
601:
602: fnd_file.put_line(FND_FILE.LOG,' ');
603: fnd_file.put_line(FND_FILE.LOG,'------Mandatory Parameters------');

Line 600: fnd_file.put_line(FND_FILE.LOG,'EDA Status : '||p_eda_status);

596: fnd_file.put_line(FND_FILE.LOG,'Approved Date To '||p_approved_date2);
597: fnd_file.put_line(FND_FILE.LOG,'Effective Date From '||p_effective_date);
598: fnd_file.put_line(FND_FILE.LOG,'Effective Date To '||p_effective_date2);
599: fnd_file.put_line(FND_FILE.LOG,'Document Status : '||p_doc_status);
600: fnd_file.put_line(FND_FILE.LOG,'EDA Status : '||p_eda_status);
601:
602: fnd_file.put_line(FND_FILE.LOG,' ');
603: fnd_file.put_line(FND_FILE.LOG,'------Mandatory Parameters------');
604: fnd_file.put_line(FND_FILE.LOG,' ');

Line 602: fnd_file.put_line(FND_FILE.LOG,' ');

598: fnd_file.put_line(FND_FILE.LOG,'Effective Date To '||p_effective_date2);
599: fnd_file.put_line(FND_FILE.LOG,'Document Status : '||p_doc_status);
600: fnd_file.put_line(FND_FILE.LOG,'EDA Status : '||p_eda_status);
601:
602: fnd_file.put_line(FND_FILE.LOG,' ');
603: fnd_file.put_line(FND_FILE.LOG,'------Mandatory Parameters------');
604: fnd_file.put_line(FND_FILE.LOG,' ');
605: fnd_file.put_line(FND_FILE.LOG,'Schema Version Used '||p_schemaversionused);
606: fnd_file.put_line(FND_FILE.LOG,'System Admin DODAAC '||p_systemadministratordodaac);

Line 603: fnd_file.put_line(FND_FILE.LOG,'------Mandatory Parameters------');

599: fnd_file.put_line(FND_FILE.LOG,'Document Status : '||p_doc_status);
600: fnd_file.put_line(FND_FILE.LOG,'EDA Status : '||p_eda_status);
601:
602: fnd_file.put_line(FND_FILE.LOG,' ');
603: fnd_file.put_line(FND_FILE.LOG,'------Mandatory Parameters------');
604: fnd_file.put_line(FND_FILE.LOG,' ');
605: fnd_file.put_line(FND_FILE.LOG,'Schema Version Used '||p_schemaversionused);
606: fnd_file.put_line(FND_FILE.LOG,'System Admin DODAAC '||p_systemadministratordodaac);
607: fnd_file.put_line(FND_FILE.LOG,'Data Template Code '||p_datatemplatecode);

Line 604: fnd_file.put_line(FND_FILE.LOG,' ');

600: fnd_file.put_line(FND_FILE.LOG,'EDA Status : '||p_eda_status);
601:
602: fnd_file.put_line(FND_FILE.LOG,' ');
603: fnd_file.put_line(FND_FILE.LOG,'------Mandatory Parameters------');
604: fnd_file.put_line(FND_FILE.LOG,' ');
605: fnd_file.put_line(FND_FILE.LOG,'Schema Version Used '||p_schemaversionused);
606: fnd_file.put_line(FND_FILE.LOG,'System Admin DODAAC '||p_systemadministratordodaac);
607: fnd_file.put_line(FND_FILE.LOG,'Data Template Code '||p_datatemplatecode);
608: fnd_file.put_line(FND_FILE.LOG,'DITPR Number '||p_ditprnumber);

Line 605: fnd_file.put_line(FND_FILE.LOG,'Schema Version Used '||p_schemaversionused);

601:
602: fnd_file.put_line(FND_FILE.LOG,' ');
603: fnd_file.put_line(FND_FILE.LOG,'------Mandatory Parameters------');
604: fnd_file.put_line(FND_FILE.LOG,' ');
605: fnd_file.put_line(FND_FILE.LOG,'Schema Version Used '||p_schemaversionused);
606: fnd_file.put_line(FND_FILE.LOG,'System Admin DODAAC '||p_systemadministratordodaac);
607: fnd_file.put_line(FND_FILE.LOG,'Data Template Code '||p_datatemplatecode);
608: fnd_file.put_line(FND_FILE.LOG,'DITPR Number '||p_ditprnumber);
609: fnd_file.put_line(FND_FILE.LOG,'Doc Purpose '||p_doc_purpose);

Line 606: fnd_file.put_line(FND_FILE.LOG,'System Admin DODAAC '||p_systemadministratordodaac);

602: fnd_file.put_line(FND_FILE.LOG,' ');
603: fnd_file.put_line(FND_FILE.LOG,'------Mandatory Parameters------');
604: fnd_file.put_line(FND_FILE.LOG,' ');
605: fnd_file.put_line(FND_FILE.LOG,'Schema Version Used '||p_schemaversionused);
606: fnd_file.put_line(FND_FILE.LOG,'System Admin DODAAC '||p_systemadministratordodaac);
607: fnd_file.put_line(FND_FILE.LOG,'Data Template Code '||p_datatemplatecode);
608: fnd_file.put_line(FND_FILE.LOG,'DITPR Number '||p_ditprnumber);
609: fnd_file.put_line(FND_FILE.LOG,'Doc Purpose '||p_doc_purpose);
610: fnd_file.put_line(FND_FILE.LOG,'System Name '||p_system_name);

Line 607: fnd_file.put_line(FND_FILE.LOG,'Data Template Code '||p_datatemplatecode);

603: fnd_file.put_line(FND_FILE.LOG,'------Mandatory Parameters------');
604: fnd_file.put_line(FND_FILE.LOG,' ');
605: fnd_file.put_line(FND_FILE.LOG,'Schema Version Used '||p_schemaversionused);
606: fnd_file.put_line(FND_FILE.LOG,'System Admin DODAAC '||p_systemadministratordodaac);
607: fnd_file.put_line(FND_FILE.LOG,'Data Template Code '||p_datatemplatecode);
608: fnd_file.put_line(FND_FILE.LOG,'DITPR Number '||p_ditprnumber);
609: fnd_file.put_line(FND_FILE.LOG,'Doc Purpose '||p_doc_purpose);
610: fnd_file.put_line(FND_FILE.LOG,'System Name '||p_system_name);
611:

Line 608: fnd_file.put_line(FND_FILE.LOG,'DITPR Number '||p_ditprnumber);

604: fnd_file.put_line(FND_FILE.LOG,' ');
605: fnd_file.put_line(FND_FILE.LOG,'Schema Version Used '||p_schemaversionused);
606: fnd_file.put_line(FND_FILE.LOG,'System Admin DODAAC '||p_systemadministratordodaac);
607: fnd_file.put_line(FND_FILE.LOG,'Data Template Code '||p_datatemplatecode);
608: fnd_file.put_line(FND_FILE.LOG,'DITPR Number '||p_ditprnumber);
609: fnd_file.put_line(FND_FILE.LOG,'Doc Purpose '||p_doc_purpose);
610: fnd_file.put_line(FND_FILE.LOG,'System Name '||p_system_name);
611:
612: l_req_ids :='reqids';

Line 609: fnd_file.put_line(FND_FILE.LOG,'Doc Purpose '||p_doc_purpose);

605: fnd_file.put_line(FND_FILE.LOG,'Schema Version Used '||p_schemaversionused);
606: fnd_file.put_line(FND_FILE.LOG,'System Admin DODAAC '||p_systemadministratordodaac);
607: fnd_file.put_line(FND_FILE.LOG,'Data Template Code '||p_datatemplatecode);
608: fnd_file.put_line(FND_FILE.LOG,'DITPR Number '||p_ditprnumber);
609: fnd_file.put_line(FND_FILE.LOG,'Doc Purpose '||p_doc_purpose);
610: fnd_file.put_line(FND_FILE.LOG,'System Name '||p_system_name);
611:
612: l_req_ids :='reqids';
613:

Line 610: fnd_file.put_line(FND_FILE.LOG,'System Name '||p_system_name);

606: fnd_file.put_line(FND_FILE.LOG,'System Admin DODAAC '||p_systemadministratordodaac);
607: fnd_file.put_line(FND_FILE.LOG,'Data Template Code '||p_datatemplatecode);
608: fnd_file.put_line(FND_FILE.LOG,'DITPR Number '||p_ditprnumber);
609: fnd_file.put_line(FND_FILE.LOG,'Doc Purpose '||p_doc_purpose);
610: fnd_file.put_line(FND_FILE.LOG,'System Name '||p_system_name);
611:
612: l_req_ids :='reqids';
613:
614: FOR i IN l_batch_start..l_batch_end LOOP

Line 616: fnd_file.put_line(FND_FILE.LOG,'CLM Document Numbers ' || l_doc_numbers(i));

612: l_req_ids :='reqids';
613:
614: FOR i IN l_batch_start..l_batch_end LOOP
615:
616: fnd_file.put_line(FND_FILE.LOG,'CLM Document Numbers ' || l_doc_numbers(i));
617: SELECT ismod INTO l_base_or_mod FROM po_eda_clm_doc_nbr_v WHERE CLM_DOCUMENT_NUMBER = l_doc_numbers(i);
618: p_timestamp := To_Char(SYSDATE,'YYYYMMDDHH24MISSSSS');
619: fnd_file.put_line(FND_FILE.LOG,'Time Stamp '||p_timestamp);
620:

Line 619: fnd_file.put_line(FND_FILE.LOG,'Time Stamp '||p_timestamp);

615:
616: fnd_file.put_line(FND_FILE.LOG,'CLM Document Numbers ' || l_doc_numbers(i));
617: SELECT ismod INTO l_base_or_mod FROM po_eda_clm_doc_nbr_v WHERE CLM_DOCUMENT_NUMBER = l_doc_numbers(i);
618: p_timestamp := To_Char(SYSDATE,'YYYYMMDDHH24MISSSSS');
619: fnd_file.put_line(FND_FILE.LOG,'Time Stamp '||p_timestamp);
620:
621: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------');
622: fnd_file.put_line(FND_FILE.LOG,'CLM Document Number :'||l_doc_numbers(i));
623: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------');

Line 621: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------');

617: SELECT ismod INTO l_base_or_mod FROM po_eda_clm_doc_nbr_v WHERE CLM_DOCUMENT_NUMBER = l_doc_numbers(i);
618: p_timestamp := To_Char(SYSDATE,'YYYYMMDDHH24MISSSSS');
619: fnd_file.put_line(FND_FILE.LOG,'Time Stamp '||p_timestamp);
620:
621: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------');
622: fnd_file.put_line(FND_FILE.LOG,'CLM Document Number :'||l_doc_numbers(i));
623: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------');
624:
625: ---------------------------------------------------------------------------------------------------------------

Line 622: fnd_file.put_line(FND_FILE.LOG,'CLM Document Number :'||l_doc_numbers(i));

618: p_timestamp := To_Char(SYSDATE,'YYYYMMDDHH24MISSSSS');
619: fnd_file.put_line(FND_FILE.LOG,'Time Stamp '||p_timestamp);
620:
621: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------');
622: fnd_file.put_line(FND_FILE.LOG,'CLM Document Number :'||l_doc_numbers(i));
623: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------');
624:
625: ---------------------------------------------------------------------------------------------------------------
626: ----- Submit 'Generate Index File for EDA' Concurrent program

Line 623: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------');

619: fnd_file.put_line(FND_FILE.LOG,'Time Stamp '||p_timestamp);
620:
621: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------');
622: fnd_file.put_line(FND_FILE.LOG,'CLM Document Number :'||l_doc_numbers(i));
623: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------');
624:
625: ---------------------------------------------------------------------------------------------------------------
626: ----- Submit 'Generate Index File for EDA' Concurrent program
627: ---------------------------------------------------------------------------------------------------------------

Line 642: fnd_file.put_line(FND_FILE.LOG,'Request Id of EDA Index File generation '||l_req_id);

638: argument3 => p_timestamp,
639: argument4 => p_system_name
640: );
641:
642: fnd_file.put_line(FND_FILE.LOG,'Request Id of EDA Index File generation '||l_req_id);
643:
644: IF l_req_ids = 'reqids' THEN
645: l_req_ids := l_req_ids || l_req_id;
646: ELSE

Line 669: fnd_file.put_line(FND_FILE.LOG,'Request Id of EDA XML File generation '||l_req_id);

665: argument6 => p_ditprnumber,
666: argument7 => p_doc_purpose,
667: argument8 => p_timestamp
668: );
669: fnd_file.put_line(FND_FILE.LOG,'Request Id of EDA XML File generation '||l_req_id);
670:
671: l_req_ids := l_req_ids || '~' || l_req_id;
672:
673:

Line 688: fnd_file.put_line(FND_FILE.LOG,'Request Id of EDA PDF File generation '||l_req_id);

684: argument1 => l_base_or_mod,
685: argument2 => l_doc_numbers(i),
686: argument3 => p_timestamp
687: );
688: fnd_file.put_line(FND_FILE.LOG,'Request Id of EDA PDF File generation '||l_req_id);
689:
690: l_req_ids := l_req_ids || '~' || l_req_id;
691:
692: COMMIT;

Line 724: fnd_file.put_line(FND_FILE.LOG,'Request Id ' || l_req_id || ' completed with phase '||v_phase);

720: dev_phase => v_request_phase,
721: dev_status => v_request_status,
722: message => v_message
723: );
724: fnd_file.put_line(FND_FILE.LOG,'Request Id ' || l_req_id || ' completed with phase '||v_phase);
725: fnd_file.put_line(FND_FILE.LOG,'Request Id ' || l_req_id || ' completed with status '||v_status);
726:
727: END LOOP;
728:

Line 725: fnd_file.put_line(FND_FILE.LOG,'Request Id ' || l_req_id || ' completed with status '||v_status);

721: dev_status => v_request_status,
722: message => v_message
723: );
724: fnd_file.put_line(FND_FILE.LOG,'Request Id ' || l_req_id || ' completed with phase '||v_phase);
725: fnd_file.put_line(FND_FILE.LOG,'Request Id ' || l_req_id || ' completed with status '||v_status);
726:
727: END LOOP;
728:
729:

Line 736: fnd_file.put_line(FND_FILE.LOG,'CLM Document Numbers ' || l_doc_numbers(i));

732:
733:
734: FOR i IN l_batch_start..l_batch_end LOOP
735:
736: fnd_file.put_line(FND_FILE.LOG,'CLM Document Numbers ' || l_doc_numbers(i));
737: SELECT ismod INTO l_base_or_mod FROM po_eda_clm_doc_nbr_v WHERE CLM_DOCUMENT_NUMBER = l_doc_numbers(i);
738: p_timestamp := To_Char(SYSDATE,'YYYYMMDDHH24MISSSSS');
739: fnd_file.put_line(FND_FILE.LOG,'Time Stamp '||p_timestamp);
740:

Line 739: fnd_file.put_line(FND_FILE.LOG,'Time Stamp '||p_timestamp);

735:
736: fnd_file.put_line(FND_FILE.LOG,'CLM Document Numbers ' || l_doc_numbers(i));
737: SELECT ismod INTO l_base_or_mod FROM po_eda_clm_doc_nbr_v WHERE CLM_DOCUMENT_NUMBER = l_doc_numbers(i);
738: p_timestamp := To_Char(SYSDATE,'YYYYMMDDHH24MISSSSS');
739: fnd_file.put_line(FND_FILE.LOG,'Time Stamp '||p_timestamp);
740:
741: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------');
742: fnd_file.put_line(FND_FILE.LOG,'CLM Document Number :'||l_doc_numbers(i));
743: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------');

Line 741: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------');

737: SELECT ismod INTO l_base_or_mod FROM po_eda_clm_doc_nbr_v WHERE CLM_DOCUMENT_NUMBER = l_doc_numbers(i);
738: p_timestamp := To_Char(SYSDATE,'YYYYMMDDHH24MISSSSS');
739: fnd_file.put_line(FND_FILE.LOG,'Time Stamp '||p_timestamp);
740:
741: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------');
742: fnd_file.put_line(FND_FILE.LOG,'CLM Document Number :'||l_doc_numbers(i));
743: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------');
744:
745:

Line 742: fnd_file.put_line(FND_FILE.LOG,'CLM Document Number :'||l_doc_numbers(i));

738: p_timestamp := To_Char(SYSDATE,'YYYYMMDDHH24MISSSSS');
739: fnd_file.put_line(FND_FILE.LOG,'Time Stamp '||p_timestamp);
740:
741: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------');
742: fnd_file.put_line(FND_FILE.LOG,'CLM Document Number :'||l_doc_numbers(i));
743: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------');
744:
745:
746: ------------------------------------------------------------------------------------------------------------

Line 743: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------');

739: fnd_file.put_line(FND_FILE.LOG,'Time Stamp '||p_timestamp);
740:
741: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------');
742: fnd_file.put_line(FND_FILE.LOG,'CLM Document Number :'||l_doc_numbers(i));
743: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------');
744:
745:
746: ------------------------------------------------------------------------------------------------------------
747: ----- Submit 'Generate Index File for EDA' Concurrent program

Line 763: fnd_file.put_line(FND_FILE.LOG,'Request Id of EDA Index File generation '||l_req_id);

759: argument3 => p_timestamp,
760: argument4 => p_system_name
761: );
762:
763: fnd_file.put_line(FND_FILE.LOG,'Request Id of EDA Index File generation '||l_req_id);
764:
765: IF l_req_ids = 'reqids' THEN
766: l_req_ids := l_req_ids || l_req_id;
767: ELSE

Line 790: fnd_file.put_line(FND_FILE.LOG,'Request Id of EDA XML File generation '||l_req_id);

786: argument6 => p_ditprnumber,
787: argument7 => p_doc_purpose,
788: argument8 => p_timestamp
789: );
790: fnd_file.put_line(FND_FILE.LOG,'Request Id of EDA XML File generation '||l_req_id);
791:
792: l_req_ids := l_req_ids || '~' || l_req_id;
793:
794:

Line 809: fnd_file.put_line(FND_FILE.LOG,'Request Id of EDA PDF File generation '||l_req_id);

805: argument1 => l_base_or_mod,
806: argument2 => l_doc_numbers(i),
807: argument3 => p_timestamp
808: );
809: fnd_file.put_line(FND_FILE.LOG,'Request Id of EDA PDF File generation '||l_req_id);
810:
811: l_req_ids := l_req_ids || '~' || l_req_id;
812:
813: COMMIT;

Line 857: fnd_file.put_line(FND_FILE.LOG,'Exception in gen_eda_files - Details '||SQLERRM);

853: END IF;
854:
855: EXCEPTION WHEN OTHERS THEN
856:
857: fnd_file.put_line(FND_FILE.LOG,'Exception in gen_eda_files - Details '||SQLERRM);
858:
859: END gen_eda_files;
860:
861: END po_eda_idx_file_gen;