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

Line 85: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod:p_style_id: '||p_style_id);

81: IS
82: l_style_id_tbl PO_TBL_NUMBER;
83: BEGIN
84: l_style_id_tbl := PO_TBL_NUMBER();
85: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod:p_style_id: '||p_style_id);
86:
87: -- If style_id is null then locks are created for ALL style_id's having
88: -- enable_conc_mod_for_styleId='modification' and CONC_MODS_ENABLED_FLAG='N'
89:

Line 109: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod:l_style_id_tbl('||i||')'||l_style_id_tbl(i));

105: WHERE NVL(CONC_MODS_ENABLED_FLAG,'N') = 'N'
106: AND CHANGE_PROCESS_TYPE = 'MODIFICATION');
107:
108: FOR i in 1.. l_style_id_tbl.COUNT LOOP
109: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod:l_style_id_tbl('||i||')'||l_style_id_tbl(i));
110: END LOOP;
111: END IF;
112:
113: FOR i IN 1.. l_style_id_tbl.COUNT LOOP

Line 162: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:p_style_id: '||p_style_id);

158: l_temp_entity_name_tbl :=PO_TBL_VARCHAR30();
159: l_temp_entity_pk2_tbl :=PO_TBL_VARCHAR240();
160: l_temp_entity_pk3_tbl :=PO_TBL_VARCHAR240();
161: l_temp_entity_pk4_tbl :=PO_TBL_VARCHAR240();
162: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:p_style_id: '||p_style_id);
163: --commit or rollback to savepoint and exit
164: SAVEPOINT update_sp;
165: -- collect draft_id for all open modifications having the given style_id
166:

Line 180: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:l_draft_id_tbl('||i||')'||l_draft_id_tbl(i));

176: 'PRE-APPROVED','SUPPLIER SIGN');
177:
178:
179: FOR i in 1.. l_draft_id_tbl.COUNT LOOP
180: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:l_draft_id_tbl('||i||')'||l_draft_id_tbl(i));
181: END LOOP;
182:
183: FOR i IN 1 .. l_draft_id_tbl.COUNT LOOP
184:

Line 215: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Update Lines Start');

211: FROM po_lines_draft_all pola
212: WHERE pola.draft_id= l_draft_id_tbl(i);
213:
214: -- update tables
215: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Update Lines Start');
216:
217: l_entity_pk1_tbl:=merge_tbl_varchar240(l_entity_pk1_tbl,l_temp_entity_pk1_tbl);
218: l_entity_name_tbl := merge_tbl_varchar30(l_entity_name_tbl,l_temp_entity_name_tbl);
219: l_entity_pk2_tbl:=merge_tbl_varchar240(l_entity_pk2_tbl,l_temp_entity_pk2_tbl);

Line 223: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Update Lines END');

219: l_entity_pk2_tbl:=merge_tbl_varchar240(l_entity_pk2_tbl,l_temp_entity_pk2_tbl);
220: l_entity_pk3_tbl:=merge_tbl_varchar240(l_entity_pk3_tbl,l_temp_entity_pk3_tbl);
221: l_entity_pk4_tbl:=merge_tbl_varchar240(l_entity_pk4_tbl,l_temp_entity_pk4_tbl);
222:
223: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Update Lines END');
224: --end
225:
226: SELECT polla.line_location_id ,
227: PO_DRAFTS_PVT.G_LOCK_SHIPMENT_ENTITY ,

Line 241: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Update SHIPMENT Start');

237: FROM PO_LINE_LOCATIONS_DRAFT_ALL polla
238: WHERE polla.draft_id= l_draft_id_tbl(i);
239:
240: -- update tables
241: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Update SHIPMENT Start');
242:
243: l_entity_pk1_tbl:=merge_tbl_varchar240(l_entity_pk1_tbl,l_temp_entity_pk1_tbl);
244: l_entity_name_tbl := merge_tbl_varchar30(l_entity_name_tbl,l_temp_entity_name_tbl);
245: l_entity_pk2_tbl:=merge_tbl_varchar240(l_entity_pk2_tbl,l_temp_entity_pk2_tbl);

Line 249: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Update SHIPMENT End');

245: l_entity_pk2_tbl:=merge_tbl_varchar240(l_entity_pk2_tbl,l_temp_entity_pk2_tbl);
246: l_entity_pk3_tbl:=merge_tbl_varchar240(l_entity_pk3_tbl,l_temp_entity_pk3_tbl);
247: l_entity_pk4_tbl:=merge_tbl_varchar240(l_entity_pk4_tbl,l_temp_entity_pk4_tbl);
248:
249: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Update SHIPMENT End');
250: --end
251:
252: SELECT pod.po_distribution_id,
253: PO_DRAFTS_PVT.G_LOCK_DIST_ENTITY ,

Line 267: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Update DISTRIBUTION Start');

263: FROM PO_DISTRIBUTIONS_DRAFT_ALL pod
264: WHERE pod.draft_id= l_draft_id_tbl(i);
265:
266: -- update tables
267: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Update DISTRIBUTION Start');
268:
269: l_entity_pk1_tbl:=merge_tbl_varchar240(l_entity_pk1_tbl,l_temp_entity_pk1_tbl);
270: l_entity_name_tbl := merge_tbl_varchar30(l_entity_name_tbl,l_temp_entity_name_tbl);
271: l_entity_pk2_tbl:=merge_tbl_varchar240(l_entity_pk2_tbl,l_temp_entity_pk2_tbl);

Line 275: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Update DISTRIBUTION End');

271: l_entity_pk2_tbl:=merge_tbl_varchar240(l_entity_pk2_tbl,l_temp_entity_pk2_tbl);
272: l_entity_pk3_tbl:=merge_tbl_varchar240(l_entity_pk3_tbl,l_temp_entity_pk3_tbl);
273: l_entity_pk4_tbl:=merge_tbl_varchar240(l_entity_pk4_tbl,l_temp_entity_pk4_tbl);
274:
275: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Update DISTRIBUTION End');
276: --end
277:
278: SELECT phbd.po_header_id ,
279: PO_DRAFTS_PVT.G_LOCK_ADDRESS_ENTITY ,

Line 299: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Update UDA-ADDRESS Start');

295: AND ag.multi_row = 'Y')
296: AND phbd.draft_id= l_draft_id_tbl(i);
297:
298: -- update tables
299: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Update UDA-ADDRESS Start');
300: l_entity_pk1_tbl:=merge_tbl_varchar240(l_entity_pk1_tbl,l_temp_entity_pk1_tbl);
301: l_entity_name_tbl := merge_tbl_varchar30(l_entity_name_tbl,l_temp_entity_name_tbl);
302: l_entity_pk2_tbl:=merge_tbl_varchar240(l_entity_pk2_tbl,l_temp_entity_pk2_tbl);
303: l_entity_pk3_tbl:=merge_tbl_varchar240(l_entity_pk3_tbl,l_temp_entity_pk3_tbl);

Line 305: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Update UDA-ADDRESS End');

301: l_entity_name_tbl := merge_tbl_varchar30(l_entity_name_tbl,l_temp_entity_name_tbl);
302: l_entity_pk2_tbl:=merge_tbl_varchar240(l_entity_pk2_tbl,l_temp_entity_pk2_tbl);
303: l_entity_pk3_tbl:=merge_tbl_varchar240(l_entity_pk3_tbl,l_temp_entity_pk3_tbl);
304: l_entity_pk4_tbl:=merge_tbl_varchar240(l_entity_pk4_tbl,l_temp_entity_pk4_tbl);
305: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Update UDA-ADDRESS End');
306: --end
307:
308: FOR i in 1.. l_entity_pk1_tbl.COUNT LOOP
309: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:l_entity_pk1_tbl('||i||')'||l_entity_pk1_tbl(i));

Line 309: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:l_entity_pk1_tbl('||i||')'||l_entity_pk1_tbl(i));

305: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Update UDA-ADDRESS End');
306: --end
307:
308: FOR i in 1.. l_entity_pk1_tbl.COUNT LOOP
309: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:l_entity_pk1_tbl('||i||')'||l_entity_pk1_tbl(i));
310: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:l_entity_name_tbl('||i||')'||l_entity_name_tbl(i));
311: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:l_entity_pk2_tbl('||i||')'||l_entity_pk2_tbl(i));
312: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:l_entity_pk3_tbl('||i||')'||l_entity_pk3_tbl(i));
313: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:l_entity_pk4_tbl('||i||')'||l_entity_pk4_tbl(i));

Line 310: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:l_entity_name_tbl('||i||')'||l_entity_name_tbl(i));

306: --end
307:
308: FOR i in 1.. l_entity_pk1_tbl.COUNT LOOP
309: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:l_entity_pk1_tbl('||i||')'||l_entity_pk1_tbl(i));
310: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:l_entity_name_tbl('||i||')'||l_entity_name_tbl(i));
311: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:l_entity_pk2_tbl('||i||')'||l_entity_pk2_tbl(i));
312: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:l_entity_pk3_tbl('||i||')'||l_entity_pk3_tbl(i));
313: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:l_entity_pk4_tbl('||i||')'||l_entity_pk4_tbl(i));
314: END LOOP;

Line 311: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:l_entity_pk2_tbl('||i||')'||l_entity_pk2_tbl(i));

307:
308: FOR i in 1.. l_entity_pk1_tbl.COUNT LOOP
309: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:l_entity_pk1_tbl('||i||')'||l_entity_pk1_tbl(i));
310: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:l_entity_name_tbl('||i||')'||l_entity_name_tbl(i));
311: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:l_entity_pk2_tbl('||i||')'||l_entity_pk2_tbl(i));
312: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:l_entity_pk3_tbl('||i||')'||l_entity_pk3_tbl(i));
313: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:l_entity_pk4_tbl('||i||')'||l_entity_pk4_tbl(i));
314: END LOOP;
315:

Line 312: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:l_entity_pk3_tbl('||i||')'||l_entity_pk3_tbl(i));

308: FOR i in 1.. l_entity_pk1_tbl.COUNT LOOP
309: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:l_entity_pk1_tbl('||i||')'||l_entity_pk1_tbl(i));
310: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:l_entity_name_tbl('||i||')'||l_entity_name_tbl(i));
311: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:l_entity_pk2_tbl('||i||')'||l_entity_pk2_tbl(i));
312: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:l_entity_pk3_tbl('||i||')'||l_entity_pk3_tbl(i));
313: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:l_entity_pk4_tbl('||i||')'||l_entity_pk4_tbl(i));
314: END LOOP;
315:
316: --calling PO_DRAFTS_PVT.lock_entities

Line 313: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:l_entity_pk4_tbl('||i||')'||l_entity_pk4_tbl(i));

309: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:l_entity_pk1_tbl('||i||')'||l_entity_pk1_tbl(i));
310: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:l_entity_name_tbl('||i||')'||l_entity_name_tbl(i));
311: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:l_entity_pk2_tbl('||i||')'||l_entity_pk2_tbl(i));
312: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:l_entity_pk3_tbl('||i||')'||l_entity_pk3_tbl(i));
313: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:l_entity_pk4_tbl('||i||')'||l_entity_pk4_tbl(i));
314: END LOOP;
315:
316: --calling PO_DRAFTS_PVT.lock_entities
317: PO_DRAFTS_PVT.lock_entities(

Line 350: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Number of Rows Updated PO_HEADERS_DRAFT_ALL'||SQL%ROWCOUNT);

346: SET phd.OLD_AMOUNT_LIMIT = ( SELECT phb.AMOUNT_LIMIT
347: FROM PO_HEADERS_ALL phb
348: WHERE phb.po_header_id=phd.po_header_id)
349: WHERE phd.draft_id=l_draft_id_tbl(i);
350: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Number of Rows Updated PO_HEADERS_DRAFT_ALL'||SQL%ROWCOUNT);
351:
352: UPDATE PO_LINES_DRAFT_ALL phd
353: SET phd.OLD_AMOUNT = ( SELECT phb.AMOUNT
354: FROM PO_LINES_ALL phb

Line 357: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Number of Rows Updated PO_LINES_DRAFT_ALL'||SQL%ROWCOUNT);

353: SET phd.OLD_AMOUNT = ( SELECT phb.AMOUNT
354: FROM PO_LINES_ALL phb
355: WHERE phb.po_line_id= phd.po_line_id)
356: WHERE phd.draft_id=l_draft_id_tbl(i);
357: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Number of Rows Updated PO_LINES_DRAFT_ALL'||SQL%ROWCOUNT);
358:
359: UPDATE PO_LINE_LOCATIONS_DRAFT_ALL phd
360: SET phd.OLD_AMOUNT = ( SELECT phb.AMOUNT
361: FROM PO_LINE_LOCATIONS_ALL phb

Line 364: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Number of Rows Updated PO_LINE_LOCATIONS_DRAFT_ALL'||SQL%ROWCOUNT);

360: SET phd.OLD_AMOUNT = ( SELECT phb.AMOUNT
361: FROM PO_LINE_LOCATIONS_ALL phb
362: WHERE phb.line_location_id= phd.line_location_id)
363: WHERE phd.draft_id=l_draft_id_tbl(i);
364: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Number of Rows Updated PO_LINE_LOCATIONS_DRAFT_ALL'||SQL%ROWCOUNT);
365:
366: UPDATE PO_DISTRIBUTIONS_DRAFT_ALL phd
367: SET phd.OLD_AMOUNT_ORDERED = ( SELECT phb.AMOUNT_ORDERED
368: FROM PO_DISTRIBUTIONS_ALL phb

Line 371: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Number of Rows Updated PO_DISTRIBUTIONS_DRAFT_ALL'||SQL%ROWCOUNT);

367: SET phd.OLD_AMOUNT_ORDERED = ( SELECT phb.AMOUNT_ORDERED
368: FROM PO_DISTRIBUTIONS_ALL phb
369: WHERE phb.po_distribution_id= phd.po_distribution_id)
370: WHERE phd.draft_id=l_draft_id_tbl(i);
371: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Number of Rows Updated PO_DISTRIBUTIONS_DRAFT_ALL'||SQL%ROWCOUNT);
372:
373: UPDATE PO_DRAFTS phd
374: SET phd.AGENT_ID = ( SELECT phb.AGENT_ID
375: FROM PO_HEADERS_ALL phb

Line 378: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Number of Rows Updated PO_DRAFTS'||SQL%ROWCOUNT);

374: SET phd.AGENT_ID = ( SELECT phb.AGENT_ID
375: FROM PO_HEADERS_ALL phb
376: WHERE phb.po_header_id=phd.document_id)
377: WHERE phd.draft_id=l_draft_id_tbl(i);
378: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Number of Rows Updated PO_DRAFTS'||SQL%ROWCOUNT);
379:
380: IF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
381: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId: FAILED for draft_id:'||l_draft_id_tbl(i)
382: ||' for style_id:'||p_style_id);

Line 381: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId: FAILED for draft_id:'||l_draft_id_tbl(i)

377: WHERE phd.draft_id=l_draft_id_tbl(i);
378: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Number of Rows Updated PO_DRAFTS'||SQL%ROWCOUNT);
379:
380: IF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
381: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId: FAILED for draft_id:'||l_draft_id_tbl(i)
382: ||' for style_id:'||p_style_id);
383: FND_FILE.put_line(FND_FILE.output,'Failed to upgrade Modifications for the document style : '||p_style_id);
384: FND_FILE.put_line(FND_FILE.output,'Please check the log file for more details.');
385: ROLLBACK TO UPDATE_SP;

Line 383: FND_FILE.put_line(FND_FILE.output,'Failed to upgrade Modifications for the document style : '||p_style_id);

379:
380: IF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
381: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId: FAILED for draft_id:'||l_draft_id_tbl(i)
382: ||' for style_id:'||p_style_id);
383: FND_FILE.put_line(FND_FILE.output,'Failed to upgrade Modifications for the document style : '||p_style_id);
384: FND_FILE.put_line(FND_FILE.output,'Please check the log file for more details.');
385: ROLLBACK TO UPDATE_SP;
386: RETURN ;
387: ELSE

Line 384: FND_FILE.put_line(FND_FILE.output,'Please check the log file for more details.');

380: IF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
381: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId: FAILED for draft_id:'||l_draft_id_tbl(i)
382: ||' for style_id:'||p_style_id);
383: FND_FILE.put_line(FND_FILE.output,'Failed to upgrade Modifications for the document style : '||p_style_id);
384: FND_FILE.put_line(FND_FILE.output,'Please check the log file for more details.');
385: ROLLBACK TO UPDATE_SP;
386: RETURN ;
387: ELSE
388: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId: SUCCESSFUL for draft_id:'||l_draft_id_tbl(i)

Line 388: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId: SUCCESSFUL for draft_id:'||l_draft_id_tbl(i)

384: FND_FILE.put_line(FND_FILE.output,'Please check the log file for more details.');
385: ROLLBACK TO UPDATE_SP;
386: RETURN ;
387: ELSE
388: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId: SUCCESSFUL for draft_id:'||l_draft_id_tbl(i)
389: ||' for style_id:'||p_style_id);
390: COMMIT;
391: END IF;
392:

Line 399: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Number of Rows Updated PO_DOC_STYLE_HEADERS'||SQL%ROWCOUNT);

395: --set PO_DOC_STYLE_HEADERS.CONC_MODS_ENABLED_FLAG to Y
396: UPDATE PO_DOC_STYLE_HEADERS
397: SET CONC_MODS_ENABLED_FLAG='Y'
398: WHERE style_id=p_style_id;
399: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Number of Rows Updated PO_DOC_STYLE_HEADERS'||SQL%ROWCOUNT);
400: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId: SUCCESFUL for STYLE_ID:'||p_style_id);
401: FND_FILE.put_line(FND_FILE.output,'Successfully upgraded Modifications for the document style x'||p_style_id);
402: COMMIT;
403:

Line 400: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId: SUCCESFUL for STYLE_ID:'||p_style_id);

396: UPDATE PO_DOC_STYLE_HEADERS
397: SET CONC_MODS_ENABLED_FLAG='Y'
398: WHERE style_id=p_style_id;
399: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Number of Rows Updated PO_DOC_STYLE_HEADERS'||SQL%ROWCOUNT);
400: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId: SUCCESFUL for STYLE_ID:'||p_style_id);
401: FND_FILE.put_line(FND_FILE.output,'Successfully upgraded Modifications for the document style x'||p_style_id);
402: COMMIT;
403:
404: EXCEPTION

Line 401: FND_FILE.put_line(FND_FILE.output,'Successfully upgraded Modifications for the document style x'||p_style_id);

397: SET CONC_MODS_ENABLED_FLAG='Y'
398: WHERE style_id=p_style_id;
399: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Number of Rows Updated PO_DOC_STYLE_HEADERS'||SQL%ROWCOUNT);
400: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId: SUCCESFUL for STYLE_ID:'||p_style_id);
401: FND_FILE.put_line(FND_FILE.output,'Successfully upgraded Modifications for the document style x'||p_style_id);
402: COMMIT;
403:
404: EXCEPTION
405: WHEN OTHERS THEN

Line 406: FND_FILE.put_line(FND_FILE.log,('An error was encountered Errorcode- '||SQLCODE||' -Errormessage- '||SQLERRM));

402: COMMIT;
403:
404: EXCEPTION
405: WHEN OTHERS THEN
406: FND_FILE.put_line(FND_FILE.log,('An error was encountered Errorcode- '||SQLCODE||' -Errormessage- '||SQLERRM));
407: FND_FILE.put_line(FND_FILE.output,('An exception Errorcode- '||SQLCODE||' occured check the logs for further details'));
408: END enable_conc_mod_for_styleId;
409:
410:

Line 407: FND_FILE.put_line(FND_FILE.output,('An exception Errorcode- '||SQLCODE||' occured check the logs for further details'));

403:
404: EXCEPTION
405: WHEN OTHERS THEN
406: FND_FILE.put_line(FND_FILE.log,('An error was encountered Errorcode- '||SQLCODE||' -Errormessage- '||SQLERRM));
407: FND_FILE.put_line(FND_FILE.output,('An exception Errorcode- '||SQLCODE||' occured check the logs for further details'));
408: END enable_conc_mod_for_styleId;
409:
410:
411: -------------------------------------------------------------------------------

Line 438: FND_FILE.put_line(FND_FILE.log,'creating attachment level locks for draft id '||p_draft_id);

434: l_attachment_lock_type VARCHAR2(1) := 'P';
435:
436: BEGIN
437:
438: FND_FILE.put_line(FND_FILE.log,'creating attachment level locks for draft id '||p_draft_id);
439:
440: --Iterate through the loop to check if any attachments exist
441: FOR itr IN 1..p_entity_name_tbl.Count() LOOP
442: