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

Line 166: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent program executed for the transaction header id : ' ||get_approved_txn_rec.transaction_header_id);

162:
163: --Get all the active transactions
164: FOR get_approved_txn_rec IN get_approved_txn_csr(p_in_txn_number) LOOP
165:
166: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent program executed for the transaction header id : ' ||get_approved_txn_rec.transaction_header_id);
167: FND_FILE.NEW_LINE(FND_FILE.LOG);
168:
169: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*Concurrent program executed for the transaction header id : '
170: ||get_approved_txn_rec.transaction_header_id);

Line 167: FND_FILE.NEW_LINE(FND_FILE.LOG);

163: --Get all the active transactions
164: FOR get_approved_txn_rec IN get_approved_txn_csr(p_in_txn_number) LOOP
165:
166: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent program executed for the transaction header id : ' ||get_approved_txn_rec.transaction_header_id);
167: FND_FILE.NEW_LINE(FND_FILE.LOG);
168:
169: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*Concurrent program executed for the transaction header id : '
170: ||get_approved_txn_rec.transaction_header_id);
171:

Line 189: FND_FILE.PUT_LINE(FND_FILE.LOG, G_AUTO_PROC_MSG || 'UPDTPO');

185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
186: END IF;
187: END LOOP;
188: ELSE
189: FND_FILE.PUT_LINE(FND_FILE.LOG, G_AUTO_PROC_MSG || 'UPDTPO');
190: FND_FILE.NEW_LINE(FND_FILE.LOG);
191: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_AUTO_PROC_MSG || 'UPDTPO');
192: END IF;
193: END LOOP;

Line 190: FND_FILE.NEW_LINE(FND_FILE.LOG);

186: END IF;
187: END LOOP;
188: ELSE
189: FND_FILE.PUT_LINE(FND_FILE.LOG, G_AUTO_PROC_MSG || 'UPDTPO');
190: FND_FILE.NEW_LINE(FND_FILE.LOG);
191: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_AUTO_PROC_MSG || 'UPDTPO');
192: END IF;
193: END LOOP;
194: IF NOT l_flag THEN

Line 195: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_REC_PROC_MSG || 'UPDTPO');

191: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_AUTO_PROC_MSG || 'UPDTPO');
192: END IF;
193: END LOOP;
194: IF NOT l_flag THEN
195: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_REC_PROC_MSG || 'UPDTPO');
196: FND_FILE.NEW_LINE(FND_FILE.LOG);
197: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_NO_REC_PROC_MSG || 'UPDTPO');
198: END IF;
199:

Line 196: FND_FILE.NEW_LINE(FND_FILE.LOG);

192: END IF;
193: END LOOP;
194: IF NOT l_flag THEN
195: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_REC_PROC_MSG || 'UPDTPO');
196: FND_FILE.NEW_LINE(FND_FILE.LOG);
197: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_NO_REC_PROC_MSG || 'UPDTPO');
198: END IF;
199:
200: FOR get_auto_flag_rec IN get_auto_flag_csr(l_supp_trade_profile_id, 'INVC', get_approved_txn_rec.transaction_header_id) LOOP

Line 214: FND_FILE.PUT_LINE(FND_FILE.LOG, G_AUTO_PROC_MSG || 'INVC');

210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
211: END IF;
212: END LOOP;
213: ELSE
214: FND_FILE.PUT_LINE(FND_FILE.LOG, G_AUTO_PROC_MSG || 'INVC');
215: FND_FILE.NEW_LINE(FND_FILE.LOG);
216: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_AUTO_PROC_MSG || 'INVC');
217: END IF;
218: END LOOP;

Line 215: FND_FILE.NEW_LINE(FND_FILE.LOG);

211: END IF;
212: END LOOP;
213: ELSE
214: FND_FILE.PUT_LINE(FND_FILE.LOG, G_AUTO_PROC_MSG || 'INVC');
215: FND_FILE.NEW_LINE(FND_FILE.LOG);
216: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_AUTO_PROC_MSG || 'INVC');
217: END IF;
218: END LOOP;
219: IF NOT l_flag THEN

Line 220: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_REC_PROC_MSG || 'INVC');

216: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_AUTO_PROC_MSG || 'INVC');
217: END IF;
218: END LOOP;
219: IF NOT l_flag THEN
220: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_REC_PROC_MSG || 'INVC');
221: FND_FILE.NEW_LINE(FND_FILE.LOG);
222: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_NO_REC_PROC_MSG || 'INVC');
223: END IF;
224:

Line 221: FND_FILE.NEW_LINE(FND_FILE.LOG);

217: END IF;
218: END LOOP;
219: IF NOT l_flag THEN
220: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_REC_PROC_MSG || 'INVC');
221: FND_FILE.NEW_LINE(FND_FILE.LOG);
222: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_NO_REC_PROC_MSG || 'INVC');
223: END IF;
224:
225: FOR get_auto_flag_rec IN get_auto_flag_csr(l_supp_trade_profile_id, 'UPDTLP', get_approved_txn_rec.transaction_header_id) LOOP

Line 239: FND_FILE.PUT_LINE(FND_FILE.LOG, G_AUTO_PROC_MSG || 'UPDTLP');

235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
236: END IF;
237: END LOOP;
238: ELSE
239: FND_FILE.PUT_LINE(FND_FILE.LOG, G_AUTO_PROC_MSG || 'UPDTLP');
240: FND_FILE.NEW_LINE(FND_FILE.LOG);
241: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_AUTO_PROC_MSG || 'UPDTLP');
242: END IF;
243: END LOOP;

Line 240: FND_FILE.NEW_LINE(FND_FILE.LOG);

236: END IF;
237: END LOOP;
238: ELSE
239: FND_FILE.PUT_LINE(FND_FILE.LOG, G_AUTO_PROC_MSG || 'UPDTLP');
240: FND_FILE.NEW_LINE(FND_FILE.LOG);
241: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_AUTO_PROC_MSG || 'UPDTLP');
242: END IF;
243: END LOOP;
244: IF NOT l_flag THEN

Line 245: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_REC_PROC_MSG || 'UPDTLP');

241: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_AUTO_PROC_MSG || 'UPDTLP');
242: END IF;
243: END LOOP;
244: IF NOT l_flag THEN
245: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_REC_PROC_MSG || 'UPDTLP');
246: FND_FILE.NEW_LINE(FND_FILE.LOG);
247: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_NO_REC_PROC_MSG || 'UPDTLP');
248: END IF;
249:

Line 246: FND_FILE.NEW_LINE(FND_FILE.LOG);

242: END IF;
243: END LOOP;
244: IF NOT l_flag THEN
245: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_REC_PROC_MSG || 'UPDTLP');
246: FND_FILE.NEW_LINE(FND_FILE.LOG);
247: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_NO_REC_PROC_MSG || 'UPDTLP');
248: END IF;
249:
250: EXECUTE_NOTIF_PROCESSES(L_API_VERSION, FND_API.G_FALSE, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL, L_RETURN_STATUS, L_MSG_COUNT,

Line 286: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || l_msg_data),1,4000));

282: l_msg_data := SUBSTR((l_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
283: END LOOP;
284: END IF;
285:
286: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || l_msg_data),1,4000));
287: FND_FILE.NEW_LINE(FND_FILE.LOG);
288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
289: ROLLBACK TO INITIATE_EXEC;
290: retcode := 2;

Line 287: FND_FILE.NEW_LINE(FND_FILE.LOG);

283: END LOOP;
284: END IF;
285:
286: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || l_msg_data),1,4000));
287: FND_FILE.NEW_LINE(FND_FILE.LOG);
288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
289: ROLLBACK TO INITIATE_EXEC;
290: retcode := 2;
291: errbuf := 'Error';

Line 299: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || l_msg_data),1,4000));

295: l_msg_data := SUBSTR((l_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
296: END LOOP;
297: END IF;
298:
299: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || l_msg_data),1,4000));
300: FND_FILE.NEW_LINE(FND_FILE.LOG);
301: WHEN OTHERS THEN
302: ROLLBACK TO INITIATE_EXEC;
303: retcode := 2;

Line 300: FND_FILE.NEW_LINE(FND_FILE.LOG);

296: END LOOP;
297: END IF;
298:
299: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || l_msg_data),1,4000));
300: FND_FILE.NEW_LINE(FND_FILE.LOG);
301: WHEN OTHERS THEN
302: ROLLBACK TO INITIATE_EXEC;
303: retcode := 2;
304: errbuf := 'Error';

Line 318: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || l_msg_data),1,4000));

314: l_msg_data := SUBSTR((l_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
315: END LOOP;
316: END IF;
317:
318: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || l_msg_data),1,4000));
319: FND_FILE.NEW_LINE(FND_FILE.LOG);
320:
321: END INITIATE_EXECUTIONPROCESS;
322:

Line 319: FND_FILE.NEW_LINE(FND_FILE.LOG);

315: END LOOP;
316: END IF;
317:
318: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || l_msg_data),1,4000));
319: FND_FILE.NEW_LINE(FND_FILE.LOG);
320:
321: END INITIATE_EXECUTIONPROCESS;
322:
323: ---------------------------------------------------------------------

Line 404: FND_FILE.PUT_LINE(FND_FILE.LOG, G_AUTO_PROC_MSG || 'NTFYPO');

400: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
402: END IF;
403: ELSE
404: FND_FILE.PUT_LINE(FND_FILE.LOG, G_AUTO_PROC_MSG || 'NTFYPO');
405: FND_FILE.NEW_LINE(FND_FILE.LOG);
406: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_AUTO_PROC_MSG || 'NTFYPO');
407: END IF;
408: END LOOP;

Line 405: FND_FILE.NEW_LINE(FND_FILE.LOG);

401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
402: END IF;
403: ELSE
404: FND_FILE.PUT_LINE(FND_FILE.LOG, G_AUTO_PROC_MSG || 'NTFYPO');
405: FND_FILE.NEW_LINE(FND_FILE.LOG);
406: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_AUTO_PROC_MSG || 'NTFYPO');
407: END IF;
408: END LOOP;
409: IF NOT l_flag THEN

Line 410: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_REC_PROC_MSG || 'NTFYPO');

406: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_AUTO_PROC_MSG || 'NTFYPO');
407: END IF;
408: END LOOP;
409: IF NOT l_flag THEN
410: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_REC_PROC_MSG || 'NTFYPO');
411: FND_FILE.NEW_LINE(FND_FILE.LOG);
412: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_NO_REC_PROC_MSG || 'NYFYPO');
413: END IF;
414:

Line 411: FND_FILE.NEW_LINE(FND_FILE.LOG);

407: END IF;
408: END LOOP;
409: IF NOT l_flag THEN
410: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_REC_PROC_MSG || 'NTFYPO');
411: FND_FILE.NEW_LINE(FND_FILE.LOG);
412: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_NO_REC_PROC_MSG || 'NYFYPO');
413: END IF;
414:
415: l_flag := FALSE;

Line 427: FND_FILE.PUT_LINE(FND_FILE.LOG, G_AUTO_PROC_MSG || 'INPL');

423: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
425: END IF;
426: ELSE
427: FND_FILE.PUT_LINE(FND_FILE.LOG, G_AUTO_PROC_MSG || 'INPL');
428: FND_FILE.NEW_LINE(FND_FILE.LOG);
429: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_AUTO_PROC_MSG || 'INPL');
430: END IF;
431: END LOOP;

Line 428: FND_FILE.NEW_LINE(FND_FILE.LOG);

424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
425: END IF;
426: ELSE
427: FND_FILE.PUT_LINE(FND_FILE.LOG, G_AUTO_PROC_MSG || 'INPL');
428: FND_FILE.NEW_LINE(FND_FILE.LOG);
429: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_AUTO_PROC_MSG || 'INPL');
430: END IF;
431: END LOOP;
432: IF NOT l_flag THEN

Line 433: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_REC_PROC_MSG || 'INPL');

429: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_AUTO_PROC_MSG || 'INPL');
430: END IF;
431: END LOOP;
432: IF NOT l_flag THEN
433: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_REC_PROC_MSG || 'INPL');
434: FND_FILE.NEW_LINE(FND_FILE.LOG);
435: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_NO_REC_PROC_MSG || 'INPL');
436: END IF;
437:

Line 434: FND_FILE.NEW_LINE(FND_FILE.LOG);

430: END IF;
431: END LOOP;
432: IF NOT l_flag THEN
433: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_REC_PROC_MSG || 'INPL');
434: FND_FILE.NEW_LINE(FND_FILE.LOG);
435: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_NO_REC_PROC_MSG || 'INPL');
436: END IF;
437:
438: l_flag := FALSE;

Line 450: FND_FILE.PUT_LINE(FND_FILE.LOG, G_AUTO_PROC_MSG || 'OUTPL');

446: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
448: END IF;
449: ELSE
450: FND_FILE.PUT_LINE(FND_FILE.LOG, G_AUTO_PROC_MSG || 'OUTPL');
451: FND_FILE.NEW_LINE(FND_FILE.LOG);
452: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_AUTO_PROC_MSG || 'OUTPL');
453: END IF;
454: END LOOP;

Line 451: FND_FILE.NEW_LINE(FND_FILE.LOG);

447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
448: END IF;
449: ELSE
450: FND_FILE.PUT_LINE(FND_FILE.LOG, G_AUTO_PROC_MSG || 'OUTPL');
451: FND_FILE.NEW_LINE(FND_FILE.LOG);
452: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_AUTO_PROC_MSG || 'OUTPL');
453: END IF;
454: END LOOP;
455: IF NOT l_flag THEN

Line 456: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_REC_PROC_MSG || 'OUTPL');

452: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_AUTO_PROC_MSG || 'OUTPL');
453: END IF;
454: END LOOP;
455: IF NOT l_flag THEN
456: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_REC_PROC_MSG || 'OUTPL');
457: FND_FILE.NEW_LINE(FND_FILE.LOG);
458: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_NO_REC_PROC_MSG || 'OUTPL');
459: END IF;
460:

Line 457: FND_FILE.NEW_LINE(FND_FILE.LOG);

453: END IF;
454: END LOOP;
455: IF NOT l_flag THEN
456: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_REC_PROC_MSG || 'OUTPL');
457: FND_FILE.NEW_LINE(FND_FILE.LOG);
458: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_NO_REC_PROC_MSG || 'OUTPL');
459: END IF;
460:
461: l_flag := FALSE;

Line 473: FND_FILE.PUT_LINE(FND_FILE.LOG, G_AUTO_PROC_MSG || 'PROMO');

469: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
471: END IF;
472: ELSE
473: FND_FILE.PUT_LINE(FND_FILE.LOG, G_AUTO_PROC_MSG || 'PROMO');
474: FND_FILE.NEW_LINE(FND_FILE.LOG);
475: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_AUTO_PROC_MSG || 'PROMO');
476: END IF;
477: END LOOP;

Line 474: FND_FILE.NEW_LINE(FND_FILE.LOG);

470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
471: END IF;
472: ELSE
473: FND_FILE.PUT_LINE(FND_FILE.LOG, G_AUTO_PROC_MSG || 'PROMO');
474: FND_FILE.NEW_LINE(FND_FILE.LOG);
475: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_AUTO_PROC_MSG || 'PROMO');
476: END IF;
477: END LOOP;
478: IF NOT l_flag THEN

Line 479: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_REC_PROC_MSG || 'PROMO');

475: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_AUTO_PROC_MSG || 'PROMO');
476: END IF;
477: END LOOP;
478: IF NOT l_flag THEN
479: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_REC_PROC_MSG || 'PROMO');
480: FND_FILE.NEW_LINE(FND_FILE.LOG);
481: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_NO_REC_PROC_MSG || 'PROMO');
482: END IF;
483:

Line 480: FND_FILE.NEW_LINE(FND_FILE.LOG);

476: END IF;
477: END LOOP;
478: IF NOT l_flag THEN
479: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_REC_PROC_MSG || 'PROMO');
480: FND_FILE.NEW_LINE(FND_FILE.LOG);
481: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_NO_REC_PROC_MSG || 'PROMO');
482: END IF;
483:
484: END LOOP;

Line 495: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || x_msg_data),1,4000));

491: FOR I IN 1..x_msg_count LOOP
492: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
493: END LOOP;
494: END IF;
495: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || x_msg_data),1,4000));
496: FND_FILE.NEW_LINE(FND_FILE.LOG);
497:
498: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
499: ROLLBACK TO EXECUTE_NOTIF;

Line 496: FND_FILE.NEW_LINE(FND_FILE.LOG);

492: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
493: END LOOP;
494: END IF;
495: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || x_msg_data),1,4000));
496: FND_FILE.NEW_LINE(FND_FILE.LOG);
497:
498: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
499: ROLLBACK TO EXECUTE_NOTIF;
500: FND_MSG_PUB.COUNT_AND_GET (P_ENCODED => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );

Line 506: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || x_msg_data),1,4000));

502: FOR I IN 1..x_msg_count LOOP
503: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
504: END LOOP;
505: END IF;
506: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || x_msg_data),1,4000));
507: FND_FILE.NEW_LINE(FND_FILE.LOG);
508:
509: WHEN OTHERS THEN
510: ROLLBACK TO EXECUTE_NOTIF;

Line 507: FND_FILE.NEW_LINE(FND_FILE.LOG);

503: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
504: END LOOP;
505: END IF;
506: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || x_msg_data),1,4000));
507: FND_FILE.NEW_LINE(FND_FILE.LOG);
508:
509: WHEN OTHERS THEN
510: ROLLBACK TO EXECUTE_NOTIF;
511: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

Line 523: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || x_msg_data),1,4000));

519: FOR I IN 1..x_msg_count LOOP
520: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
521: END LOOP;
522: END IF;
523: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || x_msg_data),1,4000));
524: FND_FILE.NEW_LINE(FND_FILE.LOG);
525:
526:
527: END EXECUTE_NOTIF_PROCESSES;

Line 524: FND_FILE.NEW_LINE(FND_FILE.LOG);

520: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
521: END LOOP;
522: END IF;
523: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || x_msg_data),1,4000));
524: FND_FILE.NEW_LINE(FND_FILE.LOG);
525:
526:
527: END EXECUTE_NOTIF_PROCESSES;
528:

Line 606: FND_FILE.PUT_LINE(FND_FILE.LOG,'Business event raised for the process code : ' || P_PROCESS_CODE);

602: RAISE FND_API.G_EXC_ERROR;
603: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
605: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS THEN
606: FND_FILE.PUT_LINE(FND_FILE.LOG,'Business event raised for the process code : ' || P_PROCESS_CODE);
607: FND_FILE.NEW_LINE(FND_FILE.LOG);
608: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*Business event raised for the process code : ' || P_PROCESS_CODE);
609: END IF;
610:

Line 607: FND_FILE.NEW_LINE(FND_FILE.LOG);

603: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
605: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS THEN
606: FND_FILE.PUT_LINE(FND_FILE.LOG,'Business event raised for the process code : ' || P_PROCESS_CODE);
607: FND_FILE.NEW_LINE(FND_FILE.LOG);
608: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*Business event raised for the process code : ' || P_PROCESS_CODE);
609: END IF;
610:
611: EXCEPTION

Line 620: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_EVT_MSG || P_PROCESS_CODE);

616: FOR I IN 1..x_msg_count LOOP
617: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
618: END LOOP;
619: END IF;
620: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_EVT_MSG || P_PROCESS_CODE);
621: FND_FILE.NEW_LINE(FND_FILE.LOG);
622: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || x_msg_data),1,4000));
623: FND_FILE.NEW_LINE(FND_FILE.LOG);
624:

Line 621: FND_FILE.NEW_LINE(FND_FILE.LOG);

617: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
618: END LOOP;
619: END IF;
620: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_EVT_MSG || P_PROCESS_CODE);
621: FND_FILE.NEW_LINE(FND_FILE.LOG);
622: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || x_msg_data),1,4000));
623: FND_FILE.NEW_LINE(FND_FILE.LOG);
624:
625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 622: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || x_msg_data),1,4000));

618: END LOOP;
619: END IF;
620: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_EVT_MSG || P_PROCESS_CODE);
621: FND_FILE.NEW_LINE(FND_FILE.LOG);
622: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || x_msg_data),1,4000));
623: FND_FILE.NEW_LINE(FND_FILE.LOG);
624:
625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
626: ROLLBACK TO EXEC_PROCESS;

Line 623: FND_FILE.NEW_LINE(FND_FILE.LOG);

619: END IF;
620: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_EVT_MSG || P_PROCESS_CODE);
621: FND_FILE.NEW_LINE(FND_FILE.LOG);
622: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || x_msg_data),1,4000));
623: FND_FILE.NEW_LINE(FND_FILE.LOG);
624:
625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
626: ROLLBACK TO EXEC_PROCESS;
627: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data );

Line 633: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_EVT_MSG || P_PROCESS_CODE);

629: FOR I IN 1..x_msg_count LOOP
630: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
631: END LOOP;
632: END IF;
633: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_EVT_MSG || P_PROCESS_CODE);
634: FND_FILE.NEW_LINE(FND_FILE.LOG);
635: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || x_msg_data),1,4000));
636: FND_FILE.NEW_LINE(FND_FILE.LOG);
637:

Line 634: FND_FILE.NEW_LINE(FND_FILE.LOG);

630: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
631: END LOOP;
632: END IF;
633: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_EVT_MSG || P_PROCESS_CODE);
634: FND_FILE.NEW_LINE(FND_FILE.LOG);
635: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || x_msg_data),1,4000));
636: FND_FILE.NEW_LINE(FND_FILE.LOG);
637:
638: WHEN OTHERS THEN

Line 635: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || x_msg_data),1,4000));

631: END LOOP;
632: END IF;
633: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_EVT_MSG || P_PROCESS_CODE);
634: FND_FILE.NEW_LINE(FND_FILE.LOG);
635: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || x_msg_data),1,4000));
636: FND_FILE.NEW_LINE(FND_FILE.LOG);
637:
638: WHEN OTHERS THEN
639: ROLLBACK TO EXEC_PROCESS;

Line 636: FND_FILE.NEW_LINE(FND_FILE.LOG);

632: END IF;
633: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_EVT_MSG || P_PROCESS_CODE);
634: FND_FILE.NEW_LINE(FND_FILE.LOG);
635: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || x_msg_data),1,4000));
636: FND_FILE.NEW_LINE(FND_FILE.LOG);
637:
638: WHEN OTHERS THEN
639: ROLLBACK TO EXEC_PROCESS;
640: FND_MESSAGE.SET_NAME('FND', 'SQL_PLSQL_ERROR');

Line 651: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_EVT_MSG || P_PROCESS_CODE);

647: FOR I IN 1..x_msg_count LOOP
648: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
649: END LOOP;
650: END IF;
651: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_EVT_MSG || P_PROCESS_CODE);
652: FND_FILE.NEW_LINE(FND_FILE.LOG);
653: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || x_msg_data),1,4000));
654: FND_FILE.NEW_LINE(FND_FILE.LOG);
655:

Line 652: FND_FILE.NEW_LINE(FND_FILE.LOG);

648: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
649: END LOOP;
650: END IF;
651: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_EVT_MSG || P_PROCESS_CODE);
652: FND_FILE.NEW_LINE(FND_FILE.LOG);
653: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || x_msg_data),1,4000));
654: FND_FILE.NEW_LINE(FND_FILE.LOG);
655:
656:

Line 653: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || x_msg_data),1,4000));

649: END LOOP;
650: END IF;
651: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_EVT_MSG || P_PROCESS_CODE);
652: FND_FILE.NEW_LINE(FND_FILE.LOG);
653: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || x_msg_data),1,4000));
654: FND_FILE.NEW_LINE(FND_FILE.LOG);
655:
656:
657: END EXECUTE_PROCESS;

Line 654: FND_FILE.NEW_LINE(FND_FILE.LOG);

650: END IF;
651: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_EVT_MSG || P_PROCESS_CODE);
652: FND_FILE.NEW_LINE(FND_FILE.LOG);
653: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || x_msg_data),1,4000));
654: FND_FILE.NEW_LINE(FND_FILE.LOG);
655:
656:
657: END EXECUTE_PROCESS;
658:

Line 690: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Supplier trade profile setup not available');

686: L_RET_ID := null;
687: fnd_message.set_name( 'DPP','DPP_SUPP_TRDPRFLS_MISSING_ERR');
688: fnd_msg_pub.add;
689: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Supplier trade profile setup not available');
690: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Supplier trade profile setup not available');
691: FND_FILE.NEW_LINE(FND_FILE.LOG);
692: RAISE FND_API.G_EXC_ERROR;
693: WHEN OTHERS THEN
694: L_RET_ID := null;

Line 691: FND_FILE.NEW_LINE(FND_FILE.LOG);

687: fnd_message.set_name( 'DPP','DPP_SUPP_TRDPRFLS_MISSING_ERR');
688: fnd_msg_pub.add;
689: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Supplier trade profile setup not available');
690: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Supplier trade profile setup not available');
691: FND_FILE.NEW_LINE(FND_FILE.LOG);
692: RAISE FND_API.G_EXC_ERROR;
693: WHEN OTHERS THEN
694: L_RET_ID := null;
695: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Exception while fetching supp_trade_profile_id: ' || SQLERRM);

Line 696: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception while fetching supp_trade_profile_id: ' || SQLERRM);

692: RAISE FND_API.G_EXC_ERROR;
693: WHEN OTHERS THEN
694: L_RET_ID := null;
695: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Exception while fetching supp_trade_profile_id: ' || SQLERRM);
696: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception while fetching supp_trade_profile_id: ' || SQLERRM);
697: FND_FILE.NEW_LINE(FND_FILE.LOG);
698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
699:
700: END GET_SUPPLIER_TRADE_PROFILE_ID;

Line 697: FND_FILE.NEW_LINE(FND_FILE.LOG);

693: WHEN OTHERS THEN
694: L_RET_ID := null;
695: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Exception while fetching supp_trade_profile_id: ' || SQLERRM);
696: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception while fetching supp_trade_profile_id: ' || SQLERRM);
697: FND_FILE.NEW_LINE(FND_FILE.LOG);
698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
699:
700: END GET_SUPPLIER_TRADE_PROFILE_ID;
701:

Line 744: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception while fetching from OZF_PROCESS_SETUP_ALL: ' || SQLERRM);

740:
741: EXCEPTION
742: WHEN OTHERS THEN
743: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Exception while fetching from OZF_PROCESS_SETUP_ALL: ' || SQLERRM);
744: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception while fetching from OZF_PROCESS_SETUP_ALL: ' || SQLERRM);
745: FND_FILE.NEW_LINE(FND_FILE.LOG);
746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
747:
748: END IS_PROCESS_SETUP;

Line 745: FND_FILE.NEW_LINE(FND_FILE.LOG);

741: EXCEPTION
742: WHEN OTHERS THEN
743: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Exception while fetching from OZF_PROCESS_SETUP_ALL: ' || SQLERRM);
744: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception while fetching from OZF_PROCESS_SETUP_ALL: ' || SQLERRM);
745: FND_FILE.NEW_LINE(FND_FILE.LOG);
746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
747:
748: END IS_PROCESS_SETUP;
749:

Line 782: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No price protection setup available for vendor id : '

778: IF NOT IS_PROCESS_SETUP(NULL, P_ORG_ID) THEN
779: --Process Setup does not exist
780: fnd_message.set_name( 'DPP','DPP_PROCESS_SETUP_MISSING_ERR');
781: fnd_msg_pub.add;
782: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No price protection setup available for vendor id : '
783: || P_VENDOR_ID || ' at site id ' || P_VENDOR_SITE_ID || ', org id ' || P_ORG_ID);
784: FND_FILE.NEW_LINE(FND_FILE.LOG);
785: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'No price protection setup available for vendor id : '
786: || P_VENDOR_ID || ' at site id ' || P_VENDOR_SITE_ID || ', org id ' || P_ORG_ID );

Line 784: FND_FILE.NEW_LINE(FND_FILE.LOG);

780: fnd_message.set_name( 'DPP','DPP_PROCESS_SETUP_MISSING_ERR');
781: fnd_msg_pub.add;
782: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No price protection setup available for vendor id : '
783: || P_VENDOR_ID || ' at site id ' || P_VENDOR_SITE_ID || ', org id ' || P_ORG_ID);
784: FND_FILE.NEW_LINE(FND_FILE.LOG);
785: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'No price protection setup available for vendor id : '
786: || P_VENDOR_ID || ' at site id ' || P_VENDOR_SITE_ID || ', org id ' || P_ORG_ID );
787: RAISE FND_API.G_EXC_ERROR;
788: END IF;

Line 861: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_DAYS_MSG || P_IN_ORG_ID);

857: EXCEPTION
858: WHEN NO_DATA_FOUND THEN
859: retcode := 2;
860: errbuf := 'Error';
861: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_DAYS_MSG || P_IN_ORG_ID);
862: FND_FILE.NEW_LINE(FND_FILE.LOG);
863: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, '*' || G_NO_DAYS_MSG || P_IN_ORG_ID);
864:
865: END;

Line 862: FND_FILE.NEW_LINE(FND_FILE.LOG);

858: WHEN NO_DATA_FOUND THEN
859: retcode := 2;
860: errbuf := 'Error';
861: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_DAYS_MSG || P_IN_ORG_ID);
862: FND_FILE.NEW_LINE(FND_FILE.LOG);
863: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, '*' || G_NO_DAYS_MSG || P_IN_ORG_ID);
864:
865: END;
866:

Line 872: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PRCSING_TXN_MSG || get_txn_to_notify_rec.transaction_number);

868:
869: IF L_DAYS >= 0
870: THEN
871: FOR get_txn_to_notify_rec IN get_txn_to_notify_csr(l_days) LOOP
872: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PRCSING_TXN_MSG || get_txn_to_notify_rec.transaction_number);
873: FND_FILE.NEW_LINE(FND_FILE.LOG);
874: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_PRCSING_TXN_MSG || get_txn_to_notify_rec.transaction_number);
875:
876: NO_TXN_FLAG := FALSE;

Line 873: FND_FILE.NEW_LINE(FND_FILE.LOG);

869: IF L_DAYS >= 0
870: THEN
871: FOR get_txn_to_notify_rec IN get_txn_to_notify_csr(l_days) LOOP
872: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PRCSING_TXN_MSG || get_txn_to_notify_rec.transaction_number);
873: FND_FILE.NEW_LINE(FND_FILE.LOG);
874: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_PRCSING_TXN_MSG || get_txn_to_notify_rec.transaction_number);
875:
876: NO_TXN_FLAG := FALSE;
877:

Line 883: FND_FILE.PUT_LINE(FND_FILE.LOG, G_AUTO_EVT_SUCCESS_MSG);

879: EXECUTE_NOTIF_PROCESSES(L_API_VERSION, FND_API.G_FALSE,FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL, L_RETURN_STATUS, L_MSG_COUNT, L_MSG_DATA,
880: l_supp_trade_profile_id,p_in_org_id, get_txn_to_notify_rec.transaction_header_id,get_txn_to_notify_rec.transaction_number);
881:
882: IF L_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS THEN
883: FND_FILE.PUT_LINE(FND_FILE.LOG, G_AUTO_EVT_SUCCESS_MSG);
884: FND_FILE.NEW_LINE(FND_FILE.LOG);
885: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_AUTO_EVT_SUCCESS_MSG );
886: ELSE
887: retcode := 1;

Line 884: FND_FILE.NEW_LINE(FND_FILE.LOG);

880: l_supp_trade_profile_id,p_in_org_id, get_txn_to_notify_rec.transaction_header_id,get_txn_to_notify_rec.transaction_number);
881:
882: IF L_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS THEN
883: FND_FILE.PUT_LINE(FND_FILE.LOG, G_AUTO_EVT_SUCCESS_MSG);
884: FND_FILE.NEW_LINE(FND_FILE.LOG);
885: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_AUTO_EVT_SUCCESS_MSG );
886: ELSE
887: retcode := 1;
888: errbuf := 'Warning';

Line 895: FND_FILE.PUT_LINE(FND_FILE.LOG,G_ERR_AUTO_NTF_MSG);

891: FOR I IN 1..l_msg_count LOOP
892: l_msg_data := SUBSTR((l_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
893: END LOOP;
894: END IF;
895: FND_FILE.PUT_LINE(FND_FILE.LOG,G_ERR_AUTO_NTF_MSG);
896: FND_FILE.NEW_LINE(FND_FILE.LOG);
897: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || l_msg_data),1,4000));
898: FND_FILE.NEW_LINE(FND_FILE.LOG);
899: END IF;

Line 896: FND_FILE.NEW_LINE(FND_FILE.LOG);

892: l_msg_data := SUBSTR((l_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
893: END LOOP;
894: END IF;
895: FND_FILE.PUT_LINE(FND_FILE.LOG,G_ERR_AUTO_NTF_MSG);
896: FND_FILE.NEW_LINE(FND_FILE.LOG);
897: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || l_msg_data),1,4000));
898: FND_FILE.NEW_LINE(FND_FILE.LOG);
899: END IF;
900:

Line 897: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || l_msg_data),1,4000));

893: END LOOP;
894: END IF;
895: FND_FILE.PUT_LINE(FND_FILE.LOG,G_ERR_AUTO_NTF_MSG);
896: FND_FILE.NEW_LINE(FND_FILE.LOG);
897: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || l_msg_data),1,4000));
898: FND_FILE.NEW_LINE(FND_FILE.LOG);
899: END IF;
900:
901: END LOOP;

Line 898: FND_FILE.NEW_LINE(FND_FILE.LOG);

894: END IF;
895: FND_FILE.PUT_LINE(FND_FILE.LOG,G_ERR_AUTO_NTF_MSG);
896: FND_FILE.NEW_LINE(FND_FILE.LOG);
897: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || l_msg_data),1,4000));
898: FND_FILE.NEW_LINE(FND_FILE.LOG);
899: END IF;
900:
901: END LOOP;
902:

Line 904: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_TXN_MSG || L_DAYS);

900:
901: END LOOP;
902:
903: IF NO_TXN_FLAG THEN
904: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_TXN_MSG || L_DAYS);
905: FND_FILE.NEW_LINE(FND_FILE.LOG);
906: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_NO_TXN_MSG || L_DAYS);
907: END IF;
908:

Line 905: FND_FILE.NEW_LINE(FND_FILE.LOG);

901: END LOOP;
902:
903: IF NO_TXN_FLAG THEN
904: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_TXN_MSG || L_DAYS);
905: FND_FILE.NEW_LINE(FND_FILE.LOG);
906: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_NO_TXN_MSG || L_DAYS);
907: END IF;
908:
909: END IF;

Line 925: FND_FILE.PUT_LINE(FND_FILE.LOG,G_ERR_AUTO_NTF_MSG);

921: FOR I IN 1..l_msg_count LOOP
922: l_msg_data := SUBSTR((l_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
923: END LOOP;
924: END IF;
925: FND_FILE.PUT_LINE(FND_FILE.LOG,G_ERR_AUTO_NTF_MSG);
926: FND_FILE.NEW_LINE(FND_FILE.LOG);
927: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || l_msg_data),1,4000));
928: FND_FILE.NEW_LINE(FND_FILE.LOG);
929:

Line 926: FND_FILE.NEW_LINE(FND_FILE.LOG);

922: l_msg_data := SUBSTR((l_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
923: END LOOP;
924: END IF;
925: FND_FILE.PUT_LINE(FND_FILE.LOG,G_ERR_AUTO_NTF_MSG);
926: FND_FILE.NEW_LINE(FND_FILE.LOG);
927: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || l_msg_data),1,4000));
928: FND_FILE.NEW_LINE(FND_FILE.LOG);
929:
930: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 927: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || l_msg_data),1,4000));

923: END LOOP;
924: END IF;
925: FND_FILE.PUT_LINE(FND_FILE.LOG,G_ERR_AUTO_NTF_MSG);
926: FND_FILE.NEW_LINE(FND_FILE.LOG);
927: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || l_msg_data),1,4000));
928: FND_FILE.NEW_LINE(FND_FILE.LOG);
929:
930: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
931: ROLLBACK TO INITIATE_NOTIF;

Line 928: FND_FILE.NEW_LINE(FND_FILE.LOG);

924: END IF;
925: FND_FILE.PUT_LINE(FND_FILE.LOG,G_ERR_AUTO_NTF_MSG);
926: FND_FILE.NEW_LINE(FND_FILE.LOG);
927: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || l_msg_data),1,4000));
928: FND_FILE.NEW_LINE(FND_FILE.LOG);
929:
930: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
931: ROLLBACK TO INITIATE_NOTIF;
932: retcode := 2;

Line 940: FND_FILE.PUT_LINE(FND_FILE.LOG, G_ERR_AUTO_NTF_MSG);

936: FOR I IN 1..l_msg_count LOOP
937: l_msg_data := SUBSTR((l_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
938: END LOOP;
939: END IF;
940: FND_FILE.PUT_LINE(FND_FILE.LOG, G_ERR_AUTO_NTF_MSG);
941: FND_FILE.NEW_LINE(FND_FILE.LOG);
942: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || l_msg_data),1,4000));
943: FND_FILE.NEW_LINE(FND_FILE.LOG);
944: WHEN OTHERS THEN

Line 941: FND_FILE.NEW_LINE(FND_FILE.LOG);

937: l_msg_data := SUBSTR((l_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
938: END LOOP;
939: END IF;
940: FND_FILE.PUT_LINE(FND_FILE.LOG, G_ERR_AUTO_NTF_MSG);
941: FND_FILE.NEW_LINE(FND_FILE.LOG);
942: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || l_msg_data),1,4000));
943: FND_FILE.NEW_LINE(FND_FILE.LOG);
944: WHEN OTHERS THEN
945: ROLLBACK TO INITIATE_NOTIF;

Line 942: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || l_msg_data),1,4000));

938: END LOOP;
939: END IF;
940: FND_FILE.PUT_LINE(FND_FILE.LOG, G_ERR_AUTO_NTF_MSG);
941: FND_FILE.NEW_LINE(FND_FILE.LOG);
942: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || l_msg_data),1,4000));
943: FND_FILE.NEW_LINE(FND_FILE.LOG);
944: WHEN OTHERS THEN
945: ROLLBACK TO INITIATE_NOTIF;
946: retcode := 2;

Line 943: FND_FILE.NEW_LINE(FND_FILE.LOG);

939: END IF;
940: FND_FILE.PUT_LINE(FND_FILE.LOG, G_ERR_AUTO_NTF_MSG);
941: FND_FILE.NEW_LINE(FND_FILE.LOG);
942: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || l_msg_data),1,4000));
943: FND_FILE.NEW_LINE(FND_FILE.LOG);
944: WHEN OTHERS THEN
945: ROLLBACK TO INITIATE_NOTIF;
946: retcode := 2;
947: errbuf := 'Error';

Line 960: FND_FILE.PUT_LINE(FND_FILE.LOG, G_ERR_AUTO_NTF_MSG);

956: FOR I IN 1..l_msg_count LOOP
957: l_msg_data := SUBSTR((l_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
958: END LOOP;
959: END IF;
960: FND_FILE.PUT_LINE(FND_FILE.LOG, G_ERR_AUTO_NTF_MSG);
961: FND_FILE.NEW_LINE(FND_FILE.LOG);
962: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || l_msg_data),1,4000));
963: FND_FILE.NEW_LINE(FND_FILE.LOG);
964:

Line 961: FND_FILE.NEW_LINE(FND_FILE.LOG);

957: l_msg_data := SUBSTR((l_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
958: END LOOP;
959: END IF;
960: FND_FILE.PUT_LINE(FND_FILE.LOG, G_ERR_AUTO_NTF_MSG);
961: FND_FILE.NEW_LINE(FND_FILE.LOG);
962: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || l_msg_data),1,4000));
963: FND_FILE.NEW_LINE(FND_FILE.LOG);
964:
965: END Initiate_Notification_Process;

Line 962: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || l_msg_data),1,4000));

958: END LOOP;
959: END IF;
960: FND_FILE.PUT_LINE(FND_FILE.LOG, G_ERR_AUTO_NTF_MSG);
961: FND_FILE.NEW_LINE(FND_FILE.LOG);
962: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || l_msg_data),1,4000));
963: FND_FILE.NEW_LINE(FND_FILE.LOG);
964:
965: END Initiate_Notification_Process;
966:

Line 963: FND_FILE.NEW_LINE(FND_FILE.LOG);

959: END IF;
960: FND_FILE.PUT_LINE(FND_FILE.LOG, G_ERR_AUTO_NTF_MSG);
961: FND_FILE.NEW_LINE(FND_FILE.LOG);
962: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || l_msg_data),1,4000));
963: FND_FILE.NEW_LINE(FND_FILE.LOG);
964:
965: END Initiate_Notification_Process;
966:
967: ---------------------------------------------------------------------

Line 1038: FND_FILE.PUT_LINE(FND_FILE.LOG,G_NO_SETUP_MSG);

1034: EXCEPTION
1035: WHEN FND_API.G_EXC_ERROR THEN
1036: ROLLBACK TO POPULATE_EXECUTIONPROCESS;
1037: x_return_status := FND_API.G_RET_STS_ERROR;
1038: FND_FILE.PUT_LINE(FND_FILE.LOG,G_NO_SETUP_MSG);
1039: FND_FILE.NEW_LINE(FND_FILE.LOG);
1040: -- Standard call to get message count and if count=1, get the message
1041: FND_MSG_PUB.Count_And_Get (
1042: p_encoded => FND_API.G_FALSE,

Line 1039: FND_FILE.NEW_LINE(FND_FILE.LOG);

1035: WHEN FND_API.G_EXC_ERROR THEN
1036: ROLLBACK TO POPULATE_EXECUTIONPROCESS;
1037: x_return_status := FND_API.G_RET_STS_ERROR;
1038: FND_FILE.PUT_LINE(FND_FILE.LOG,G_NO_SETUP_MSG);
1039: FND_FILE.NEW_LINE(FND_FILE.LOG);
1040: -- Standard call to get message count and if count=1, get the message
1041: FND_MSG_PUB.Count_And_Get (
1042: p_encoded => FND_API.G_FALSE,
1043: p_count => x_msg_count,

Line 1049: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error occured: ' || SQLERRM);

1045: );
1046: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1047: ROLLBACK TO POPULATE_EXECUTIONPROCESS;
1048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1049: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error occured: ' || SQLERRM);
1050: FND_FILE.NEW_LINE(FND_FILE.LOG);
1051: -- Standard call to get message count and if count=1, get the message
1052: FND_MSG_PUB.Count_And_Get (
1053: p_encoded => FND_API.G_FALSE,

Line 1050: FND_FILE.NEW_LINE(FND_FILE.LOG);

1046: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1047: ROLLBACK TO POPULATE_EXECUTIONPROCESS;
1048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1049: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error occured: ' || SQLERRM);
1050: FND_FILE.NEW_LINE(FND_FILE.LOG);
1051: -- Standard call to get message count and if count=1, get the message
1052: FND_MSG_PUB.Count_And_Get (
1053: p_encoded => FND_API.G_FALSE,
1054: p_count => x_msg_count,

Line 1060: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error occured: ' || SQLERRM);

1056: );
1057: WHEN OTHERS THEN
1058: ROLLBACK TO POPULATE_EXECUTIONPROCESS;
1059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1060: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error occured: ' || SQLERRM);
1061: FND_FILE.NEW_LINE(FND_FILE.LOG);
1062: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1063: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1064: END IF;

Line 1061: FND_FILE.NEW_LINE(FND_FILE.LOG);

1057: WHEN OTHERS THEN
1058: ROLLBACK TO POPULATE_EXECUTIONPROCESS;
1059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1060: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error occured: ' || SQLERRM);
1061: FND_FILE.NEW_LINE(FND_FILE.LOG);
1062: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1063: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1064: END IF;
1065: -- Standard call to get message count and if count=1, get the message

Line 1136: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception while checking if the transaction exists in DPP_EXECUTION_PROCESSES table: '||SQLERRM);

1132: FETCH get_exec_processes_cnt INTO l_exe_process_cnt;
1133: CLOSE get_exec_processes_cnt;
1134: EXCEPTION
1135: WHEN OTHERS THEN
1136: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception while checking if the transaction exists in DPP_EXECUTION_PROCESSES table: '||SQLERRM);
1137: FND_FILE.NEW_LINE(FND_FILE.LOG);
1138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1139: END;
1140:

Line 1137: FND_FILE.NEW_LINE(FND_FILE.LOG);

1133: CLOSE get_exec_processes_cnt;
1134: EXCEPTION
1135: WHEN OTHERS THEN
1136: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception while checking if the transaction exists in DPP_EXECUTION_PROCESSES table: '||SQLERRM);
1137: FND_FILE.NEW_LINE(FND_FILE.LOG);
1138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1139: END;
1140:
1141: IF l_exe_process_cnt > 0 THEN

Line 1147: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception while deleting the records from DPP_EXECUTION_PROCESSES table: ' || SQLERRM);

1143: DELETE FROM DPP_EXECUTION_PROCESSES
1144: WHERE transaction_header_id = p_txn_hdr_id;
1145: EXCEPTION
1146: WHEN OTHERS THEN
1147: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception while deleting the records from DPP_EXECUTION_PROCESSES table: ' || SQLERRM);
1148: FND_FILE.NEW_LINE(FND_FILE.LOG);
1149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1150: END;
1151: END IF;

Line 1148: FND_FILE.NEW_LINE(FND_FILE.LOG);

1144: WHERE transaction_header_id = p_txn_hdr_id;
1145: EXCEPTION
1146: WHEN OTHERS THEN
1147: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception while deleting the records from DPP_EXECUTION_PROCESSES table: ' || SQLERRM);
1148: FND_FILE.NEW_LINE(FND_FILE.LOG);
1149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1150: END;
1151: END IF;
1152:

Line 1175: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception while inserting into DPP_EXECUTION_PROCESSES: ' || SQLERRM);

1171: l_login_id
1172: );
1173: EXCEPTION
1174: WHEN OTHERS THEN
1175: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception while inserting into DPP_EXECUTION_PROCESSES: ' || SQLERRM);
1176: FND_FILE.NEW_LINE(FND_FILE.LOG);
1177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1178: END;
1179: END LOOP;

Line 1176: FND_FILE.NEW_LINE(FND_FILE.LOG);

1172: );
1173: EXCEPTION
1174: WHEN OTHERS THEN
1175: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception while inserting into DPP_EXECUTION_PROCESSES: ' || SQLERRM);
1176: FND_FILE.NEW_LINE(FND_FILE.LOG);
1177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1178: END;
1179: END LOOP;
1180:

Line 1185: FND_FILE.PUT_LINE(FND_FILE.LOG,G_NO_SETUP_MSG);

1181: EXCEPTION
1182: WHEN FND_API.G_EXC_ERROR THEN
1183: ROLLBACK TO InsertExecProcesses;
1184: x_return_status := FND_API.G_RET_STS_ERROR;
1185: FND_FILE.PUT_LINE(FND_FILE.LOG,G_NO_SETUP_MSG);
1186: FND_FILE.NEW_LINE(FND_FILE.LOG);
1187: -- Standard call to get message count and if count=1, get the message
1188: FND_MSG_PUB.Count_And_Get (
1189: p_encoded => FND_API.G_FALSE,

Line 1186: FND_FILE.NEW_LINE(FND_FILE.LOG);

1182: WHEN FND_API.G_EXC_ERROR THEN
1183: ROLLBACK TO InsertExecProcesses;
1184: x_return_status := FND_API.G_RET_STS_ERROR;
1185: FND_FILE.PUT_LINE(FND_FILE.LOG,G_NO_SETUP_MSG);
1186: FND_FILE.NEW_LINE(FND_FILE.LOG);
1187: -- Standard call to get message count and if count=1, get the message
1188: FND_MSG_PUB.Count_And_Get (
1189: p_encoded => FND_API.G_FALSE,
1190: p_count => x_msg_count,

Line 1196: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error occured: ' || SQLERRM);

1192: );
1193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1194: ROLLBACK TO InsertExecProcesses;
1195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1196: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error occured: ' || SQLERRM);
1197: FND_FILE.NEW_LINE(FND_FILE.LOG);
1198: -- Standard call to get message count and if count=1, get the message
1199: FND_MSG_PUB.Count_And_Get (
1200: p_encoded => FND_API.G_FALSE,

Line 1197: FND_FILE.NEW_LINE(FND_FILE.LOG);

1193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1194: ROLLBACK TO InsertExecProcesses;
1195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1196: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error occured: ' || SQLERRM);
1197: FND_FILE.NEW_LINE(FND_FILE.LOG);
1198: -- Standard call to get message count and if count=1, get the message
1199: FND_MSG_PUB.Count_And_Get (
1200: p_encoded => FND_API.G_FALSE,
1201: p_count => x_msg_count,

Line 1207: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error occured: ' || SQLERRM);

1203: );
1204: WHEN OTHERS THEN
1205: ROLLBACK TO InsertExecProcesses;
1206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1207: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error occured: ' || SQLERRM);
1208: FND_FILE.NEW_LINE(FND_FILE.LOG);
1209: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1210: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1211: END IF;

Line 1208: FND_FILE.NEW_LINE(FND_FILE.LOG);

1204: WHEN OTHERS THEN
1205: ROLLBACK TO InsertExecProcesses;
1206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1207: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error occured: ' || SQLERRM);
1208: FND_FILE.NEW_LINE(FND_FILE.LOG);
1209: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1210: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1211: END IF;
1212: -- Standard call to get message count and if count=1, get the message

Line 1357: fnd_file.put_line(fnd_file.log, l_msg_data);

1353: , x_final_approval_flag => l_final_approval_flag
1354: );
1355:
1356: IF l_return_status = Fnd_Api.g_ret_sts_error OR l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1357: fnd_file.put_line(fnd_file.log, l_msg_data);
1358: fnd_file.new_line(fnd_file.log);
1359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1360: END IF;
1361:

Line 1358: fnd_file.new_line(fnd_file.log);

1354: );
1355:
1356: IF l_return_status = Fnd_Api.g_ret_sts_error OR l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1357: fnd_file.put_line(fnd_file.log, l_msg_data);
1358: fnd_file.new_line(fnd_file.log);
1359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1360: END IF;
1361:
1362: EXCEPTION

Line 1365: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Transaction Number : ' || l_transaction_number || ' Ref. Document Number : ' || l_ref_document_number);

1361:
1362: EXCEPTION
1363: WHEN FND_API.G_EXC_ERROR THEN
1364: l_msg_data := fnd_message.get_string('DPP','DPP_AME_NO_APP');
1365: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Transaction Number : ' || l_transaction_number || ' Ref. Document Number : ' || l_ref_document_number);
1366: FND_FILE.NEW_LINE(FND_FILE.LOG);
1367: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Message : ' || l_msg_data);
1368: FND_FILE.NEW_LINE(FND_FILE.LOG);
1369: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1366: FND_FILE.NEW_LINE(FND_FILE.LOG);

1362: EXCEPTION
1363: WHEN FND_API.G_EXC_ERROR THEN
1364: l_msg_data := fnd_message.get_string('DPP','DPP_AME_NO_APP');
1365: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Transaction Number : ' || l_transaction_number || ' Ref. Document Number : ' || l_ref_document_number);
1366: FND_FILE.NEW_LINE(FND_FILE.LOG);
1367: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Message : ' || l_msg_data);
1368: FND_FILE.NEW_LINE(FND_FILE.LOG);
1369: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1370: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Transaction Number : ' || l_transaction_number || ' Ref. Document Number : ' || l_ref_document_number);

Line 1367: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Message : ' || l_msg_data);

1363: WHEN FND_API.G_EXC_ERROR THEN
1364: l_msg_data := fnd_message.get_string('DPP','DPP_AME_NO_APP');
1365: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Transaction Number : ' || l_transaction_number || ' Ref. Document Number : ' || l_ref_document_number);
1366: FND_FILE.NEW_LINE(FND_FILE.LOG);
1367: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Message : ' || l_msg_data);
1368: FND_FILE.NEW_LINE(FND_FILE.LOG);
1369: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1370: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Transaction Number : ' || l_transaction_number || ' Ref. Document Number : ' || l_ref_document_number);
1371: FND_FILE.NEW_LINE(FND_FILE.LOG);

Line 1368: FND_FILE.NEW_LINE(FND_FILE.LOG);

1364: l_msg_data := fnd_message.get_string('DPP','DPP_AME_NO_APP');
1365: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Transaction Number : ' || l_transaction_number || ' Ref. Document Number : ' || l_ref_document_number);
1366: FND_FILE.NEW_LINE(FND_FILE.LOG);
1367: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Message : ' || l_msg_data);
1368: FND_FILE.NEW_LINE(FND_FILE.LOG);
1369: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1370: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Transaction Number : ' || l_transaction_number || ' Ref. Document Number : ' || l_ref_document_number);
1371: FND_FILE.NEW_LINE(FND_FILE.LOG);
1372: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Message : ' || l_msg_data);

Line 1370: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Transaction Number : ' || l_transaction_number || ' Ref. Document Number : ' || l_ref_document_number);

1366: FND_FILE.NEW_LINE(FND_FILE.LOG);
1367: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Message : ' || l_msg_data);
1368: FND_FILE.NEW_LINE(FND_FILE.LOG);
1369: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1370: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Transaction Number : ' || l_transaction_number || ' Ref. Document Number : ' || l_ref_document_number);
1371: FND_FILE.NEW_LINE(FND_FILE.LOG);
1372: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Message : ' || l_msg_data);
1373: FND_FILE.NEW_LINE(FND_FILE.LOG);
1374: WHEN OTHERS THEN

Line 1371: FND_FILE.NEW_LINE(FND_FILE.LOG);

1367: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Message : ' || l_msg_data);
1368: FND_FILE.NEW_LINE(FND_FILE.LOG);
1369: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1370: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Transaction Number : ' || l_transaction_number || ' Ref. Document Number : ' || l_ref_document_number);
1371: FND_FILE.NEW_LINE(FND_FILE.LOG);
1372: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Message : ' || l_msg_data);
1373: FND_FILE.NEW_LINE(FND_FILE.LOG);
1374: WHEN OTHERS THEN
1375: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

Line 1372: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Message : ' || l_msg_data);

1368: FND_FILE.NEW_LINE(FND_FILE.LOG);
1369: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1370: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Transaction Number : ' || l_transaction_number || ' Ref. Document Number : ' || l_ref_document_number);
1371: FND_FILE.NEW_LINE(FND_FILE.LOG);
1372: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Message : ' || l_msg_data);
1373: FND_FILE.NEW_LINE(FND_FILE.LOG);
1374: WHEN OTHERS THEN
1375: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1376: fnd_message.set_token('ROUTINE', l_full_name);

Line 1373: FND_FILE.NEW_LINE(FND_FILE.LOG);

1369: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1370: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Transaction Number : ' || l_transaction_number || ' Ref. Document Number : ' || l_ref_document_number);
1371: FND_FILE.NEW_LINE(FND_FILE.LOG);
1372: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Message : ' || l_msg_data);
1373: FND_FILE.NEW_LINE(FND_FILE.LOG);
1374: WHEN OTHERS THEN
1375: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1376: fnd_message.set_token('ROUTINE', l_full_name);
1377: fnd_message.set_token('ERRNO', sqlcode);

Line 1405: fnd_file.put_line(fnd_file.log, ' Initiate_ExecutionProcess. retcode: ' || retcode || ' errbuf: ' || errbuf);

1401: l_transaction_number
1402: );
1403:
1404: IF G_DEBUG THEN
1405: fnd_file.put_line(fnd_file.log, ' Initiate_ExecutionProcess. retcode: ' || retcode || ' errbuf: ' || errbuf);
1406: END IF;
1407:
1408: IF retcode <> 0 THEN
1409: FND_FILE.PUT_LINE(fnd_file.log, 'Initiate_ExecutionProcess did not complete successfully for' );

Line 1409: FND_FILE.PUT_LINE(fnd_file.log, 'Initiate_ExecutionProcess did not complete successfully for' );

1405: fnd_file.put_line(fnd_file.log, ' Initiate_ExecutionProcess. retcode: ' || retcode || ' errbuf: ' || errbuf);
1406: END IF;
1407:
1408: IF retcode <> 0 THEN
1409: FND_FILE.PUT_LINE(fnd_file.log, 'Initiate_ExecutionProcess did not complete successfully for' );
1410: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Transaction Number : ' || l_transaction_number || ' Ref. Document Number : ' || l_ref_document_number);
1411: FND_FILE.NEW_LINE(FND_FILE.LOG);
1412: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Message : ' || errbuf);
1413: FND_FILE.NEW_LINE(FND_FILE.LOG);

Line 1410: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Transaction Number : ' || l_transaction_number || ' Ref. Document Number : ' || l_ref_document_number);

1406: END IF;
1407:
1408: IF retcode <> 0 THEN
1409: FND_FILE.PUT_LINE(fnd_file.log, 'Initiate_ExecutionProcess did not complete successfully for' );
1410: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Transaction Number : ' || l_transaction_number || ' Ref. Document Number : ' || l_ref_document_number);
1411: FND_FILE.NEW_LINE(FND_FILE.LOG);
1412: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Message : ' || errbuf);
1413: FND_FILE.NEW_LINE(FND_FILE.LOG);
1414: END IF;

Line 1411: FND_FILE.NEW_LINE(FND_FILE.LOG);

1407:
1408: IF retcode <> 0 THEN
1409: FND_FILE.PUT_LINE(fnd_file.log, 'Initiate_ExecutionProcess did not complete successfully for' );
1410: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Transaction Number : ' || l_transaction_number || ' Ref. Document Number : ' || l_ref_document_number);
1411: FND_FILE.NEW_LINE(FND_FILE.LOG);
1412: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Message : ' || errbuf);
1413: FND_FILE.NEW_LINE(FND_FILE.LOG);
1414: END IF;
1415:

Line 1412: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Message : ' || errbuf);

1408: IF retcode <> 0 THEN
1409: FND_FILE.PUT_LINE(fnd_file.log, 'Initiate_ExecutionProcess did not complete successfully for' );
1410: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Transaction Number : ' || l_transaction_number || ' Ref. Document Number : ' || l_ref_document_number);
1411: FND_FILE.NEW_LINE(FND_FILE.LOG);
1412: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Message : ' || errbuf);
1413: FND_FILE.NEW_LINE(FND_FILE.LOG);
1414: END IF;
1415:
1416: EXCEPTION

Line 1413: FND_FILE.NEW_LINE(FND_FILE.LOG);

1409: FND_FILE.PUT_LINE(fnd_file.log, 'Initiate_ExecutionProcess did not complete successfully for' );
1410: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Transaction Number : ' || l_transaction_number || ' Ref. Document Number : ' || l_ref_document_number);
1411: FND_FILE.NEW_LINE(FND_FILE.LOG);
1412: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Message : ' || errbuf);
1413: FND_FILE.NEW_LINE(FND_FILE.LOG);
1414: END IF;
1415:
1416: EXCEPTION
1417: WHEN OTHERS THEN

Line 1468: fnd_file.put_line(fnd_file.log, ' Update_HeaderLog. Return Status: ' || l_return_status || ' Error Msg: ' || l_msg_data);

1464: , p_transaction_header_id => l_transaction_header_id
1465: ) ;
1466:
1467: IF G_DEBUG THEN
1468: fnd_file.put_line(fnd_file.log, ' Update_HeaderLog. Return Status: ' || l_return_status || ' Error Msg: ' || l_msg_data);
1469: END IF;
1470:
1471: IF l_return_status = Fnd_Api.g_ret_sts_error THEN
1472: RAISE Fnd_Api.g_exc_error;

Line 1496: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invoked API to send WF Notifications to the '

1492: ,p_program_id => l_request_id
1493: );
1494:
1495: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1496: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invoked API to send WF Notifications to the '
1497: || 'Creator on the effective date of the Price Protection Transaction');
1498: FND_FILE.NEW_LINE(FND_FILE.LOG);
1499: ELSE
1500: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error while invoking API that sends WF Notifications to the '

Line 1498: FND_FILE.NEW_LINE(FND_FILE.LOG);

1494:
1495: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1496: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invoked API to send WF Notifications to the '
1497: || 'Creator on the effective date of the Price Protection Transaction');
1498: FND_FILE.NEW_LINE(FND_FILE.LOG);
1499: ELSE
1500: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error while invoking API that sends WF Notifications to the '
1501: ||'Creator on the effective date of the Price Protection Transaction');
1502: FND_FILE.NEW_LINE(FND_FILE.LOG);

Line 1500: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error while invoking API that sends WF Notifications to the '

1496: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invoked API to send WF Notifications to the '
1497: || 'Creator on the effective date of the Price Protection Transaction');
1498: FND_FILE.NEW_LINE(FND_FILE.LOG);
1499: ELSE
1500: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error while invoking API that sends WF Notifications to the '
1501: ||'Creator on the effective date of the Price Protection Transaction');
1502: FND_FILE.NEW_LINE(FND_FILE.LOG);
1503: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : '||l_msg_data),1,4000));
1504: FND_FILE.NEW_LINE(FND_FILE.LOG);

Line 1502: FND_FILE.NEW_LINE(FND_FILE.LOG);

1498: FND_FILE.NEW_LINE(FND_FILE.LOG);
1499: ELSE
1500: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error while invoking API that sends WF Notifications to the '
1501: ||'Creator on the effective date of the Price Protection Transaction');
1502: FND_FILE.NEW_LINE(FND_FILE.LOG);
1503: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : '||l_msg_data),1,4000));
1504: FND_FILE.NEW_LINE(FND_FILE.LOG);
1505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1506: END IF;

Line 1503: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : '||l_msg_data),1,4000));

1499: ELSE
1500: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error while invoking API that sends WF Notifications to the '
1501: ||'Creator on the effective date of the Price Protection Transaction');
1502: FND_FILE.NEW_LINE(FND_FILE.LOG);
1503: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : '||l_msg_data),1,4000));
1504: FND_FILE.NEW_LINE(FND_FILE.LOG);
1505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1506: END IF;
1507:

Line 1504: FND_FILE.NEW_LINE(FND_FILE.LOG);

1500: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error while invoking API that sends WF Notifications to the '
1501: ||'Creator on the effective date of the Price Protection Transaction');
1502: FND_FILE.NEW_LINE(FND_FILE.LOG);
1503: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : '||l_msg_data),1,4000));
1504: FND_FILE.NEW_LINE(FND_FILE.LOG);
1505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1506: END IF;
1507:
1508: ELSE

Line 1509: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No Price protection transactions effective today.');

1505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1506: END IF;
1507:
1508: ELSE
1509: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No Price protection transactions effective today.');
1510: FND_FILE.NEW_LINE(FND_FILE.LOG);
1511: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'No Price protection transactions effective today.');
1512: END IF;
1513:

Line 1510: FND_FILE.NEW_LINE(FND_FILE.LOG);

1506: END IF;
1507:
1508: ELSE
1509: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No Price protection transactions effective today.');
1510: FND_FILE.NEW_LINE(FND_FILE.LOG);
1511: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'No Price protection transactions effective today.');
1512: END IF;
1513:
1514: --Commit the changes

Line 1534: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || l_msg_data),1,4000));

1530: l_msg_data := SUBSTR((l_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
1531: END LOOP;
1532: END IF;
1533:
1534: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || l_msg_data),1,4000));
1535: FND_FILE.NEW_LINE(FND_FILE.LOG);
1536: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1537: ROLLBACK TO Change_Status;
1538: retcode := 2;

Line 1535: FND_FILE.NEW_LINE(FND_FILE.LOG);

1531: END LOOP;
1532: END IF;
1533:
1534: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || l_msg_data),1,4000));
1535: FND_FILE.NEW_LINE(FND_FILE.LOG);
1536: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1537: ROLLBACK TO Change_Status;
1538: retcode := 2;
1539: errbuf := 'Error';

Line 1552: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || l_msg_data),1,4000));

1548: l_msg_data := SUBSTR((l_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
1549: END LOOP;
1550: END IF;
1551:
1552: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || l_msg_data),1,4000));
1553: FND_FILE.NEW_LINE(FND_FILE.LOG);
1554: WHEN OTHERS THEN
1555: ROLLBACK TO Change_Status;
1556: retcode := 2;

Line 1553: FND_FILE.NEW_LINE(FND_FILE.LOG);

1549: END LOOP;
1550: END IF;
1551:
1552: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || l_msg_data),1,4000));
1553: FND_FILE.NEW_LINE(FND_FILE.LOG);
1554: WHEN OTHERS THEN
1555: ROLLBACK TO Change_Status;
1556: retcode := 2;
1557: errbuf := 'Error';

Line 1576: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || l_msg_data),1,4000));

1572: l_msg_data := SUBSTR((l_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
1573: END LOOP;
1574: END IF;
1575:
1576: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || l_msg_data),1,4000));
1577: FND_FILE.NEW_LINE(FND_FILE.LOG);
1578:
1579: END Change_Status;
1580:

Line 1577: FND_FILE.NEW_LINE(FND_FILE.LOG);

1573: END LOOP;
1574: END IF;
1575:
1576: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(('Error Message : ' || l_msg_data),1,4000));
1577: FND_FILE.NEW_LINE(FND_FILE.LOG);
1578:
1579: END Change_Status;
1580:
1581: ---------------------------------------------------------------------

Line 1673: fnd_file.put_line(fnd_file.log, ' Update_Status. Return Status: ' || l_return_status || ' Error Msg: ' || l_msg_data);

1669: , p_to_status => 'APPROVED'
1670: ) ;
1671:
1672: IF G_DEBUG THEN
1673: fnd_file.put_line(fnd_file.log, ' Update_Status. Return Status: ' || l_return_status || ' Error Msg: ' || l_msg_data);
1674: END IF;
1675:
1676: IF l_return_status = Fnd_Api.g_ret_sts_error THEN
1677: RAISE Fnd_Api.g_exc_error;

Line 1699: fnd_file.put_line(fnd_file.log, ' Initiate_ExecutionProcess. retcode: ' || retcode || ' errbuff: ' || errbuff);

1695: l_txn_number
1696: );
1697:
1698: IF G_DEBUG THEN
1699: fnd_file.put_line(fnd_file.log, ' Initiate_ExecutionProcess. retcode: ' || retcode || ' errbuff: ' || errbuff);
1700: END IF;
1701:
1702: IF retcode <> 0 THEN
1703: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1710: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Supplier Trade Profile or Process Setup not available');

1706: EXCEPTION
1707: WHEN FND_API.G_EXC_ERROR THEN
1708: ROLLBACK TO APPROVE_TRANSACTION;
1709: x_return_status := FND_API.G_RET_STS_ERROR;
1710: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Supplier Trade Profile or Process Setup not available');
1711: --FND_FILE.NEW_LINE(FND_FILE.LOG);
1712: -- Standard call to get message count and if count=1, get the message
1713: FND_MSG_PUB.Count_And_Get (
1714: p_encoded => FND_API.G_FALSE,

Line 1711: --FND_FILE.NEW_LINE(FND_FILE.LOG);

1707: WHEN FND_API.G_EXC_ERROR THEN
1708: ROLLBACK TO APPROVE_TRANSACTION;
1709: x_return_status := FND_API.G_RET_STS_ERROR;
1710: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Supplier Trade Profile or Process Setup not available');
1711: --FND_FILE.NEW_LINE(FND_FILE.LOG);
1712: -- Standard call to get message count and if count=1, get the message
1713: FND_MSG_PUB.Count_And_Get (
1714: p_encoded => FND_API.G_FALSE,
1715: p_count => x_msg_count,

Line 1721: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error occured: ' || SQLERRM);

1717: );
1718: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1719: ROLLBACK TO APPROVE_TRANSACTION;
1720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1721: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error occured: ' || SQLERRM);
1722: FND_FILE.NEW_LINE(FND_FILE.LOG);
1723: -- Standard call to get message count and if count=1, get the message
1724: FND_MSG_PUB.Count_And_Get (
1725: p_encoded => FND_API.G_FALSE,

Line 1722: FND_FILE.NEW_LINE(FND_FILE.LOG);

1718: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1719: ROLLBACK TO APPROVE_TRANSACTION;
1720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1721: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error occured: ' || SQLERRM);
1722: FND_FILE.NEW_LINE(FND_FILE.LOG);
1723: -- Standard call to get message count and if count=1, get the message
1724: FND_MSG_PUB.Count_And_Get (
1725: p_encoded => FND_API.G_FALSE,
1726: p_count => x_msg_count,

Line 1732: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error occured: ' || SQLERRM);

1728: );
1729: WHEN OTHERS THEN
1730: ROLLBACK TO APPROVE_TRANSACTION;
1731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1732: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error occured: ' || SQLERRM);
1733: FND_FILE.NEW_LINE(FND_FILE.LOG);
1734: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1735: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1736: END IF;

Line 1733: FND_FILE.NEW_LINE(FND_FILE.LOG);

1729: WHEN OTHERS THEN
1730: ROLLBACK TO APPROVE_TRANSACTION;
1731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1732: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error occured: ' || SQLERRM);
1733: FND_FILE.NEW_LINE(FND_FILE.LOG);
1734: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1735: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1736: END IF;
1737: -- Standard call to get message count and if count=1, get the message

Line 1825: fnd_file.put_line(fnd_file.log, ' Update_HeaderLog. Return Status: ' || l_return_status || ' Error Msg: ' || l_msg_data);

1821: , p_transaction_header_id => p_txn_hdr_id
1822: ) ;
1823:
1824: IF G_DEBUG THEN
1825: fnd_file.put_line(fnd_file.log, ' Update_HeaderLog. Return Status: ' || l_return_status || ' Error Msg: ' || l_msg_data);
1826: END IF;
1827:
1828: IF l_return_status = Fnd_Api.g_ret_sts_error THEN
1829: RAISE Fnd_Api.g_exc_error;

Line 1838: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Supplier Trade Profile or Process Setup not available');

1834: EXCEPTION
1835: WHEN FND_API.G_EXC_ERROR THEN
1836: ROLLBACK TO UPDATE_STATUS;
1837: x_return_status := FND_API.G_RET_STS_ERROR;
1838: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Supplier Trade Profile or Process Setup not available');
1839: --FND_FILE.NEW_LINE(FND_FILE.LOG);
1840: -- Standard call to get message count and if count=1, get the message
1841: FND_MSG_PUB.Count_And_Get (
1842: p_encoded => FND_API.G_FALSE,

Line 1839: --FND_FILE.NEW_LINE(FND_FILE.LOG);

1835: WHEN FND_API.G_EXC_ERROR THEN
1836: ROLLBACK TO UPDATE_STATUS;
1837: x_return_status := FND_API.G_RET_STS_ERROR;
1838: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Supplier Trade Profile or Process Setup not available');
1839: --FND_FILE.NEW_LINE(FND_FILE.LOG);
1840: -- Standard call to get message count and if count=1, get the message
1841: FND_MSG_PUB.Count_And_Get (
1842: p_encoded => FND_API.G_FALSE,
1843: p_count => x_msg_count,

Line 1849: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error occured: ' || SQLERRM);

1845: );
1846: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1847: ROLLBACK TO UPDATE_STATUS;
1848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1849: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error occured: ' || SQLERRM);
1850: FND_FILE.NEW_LINE(FND_FILE.LOG);
1851: -- Standard call to get message count and if count=1, get the message
1852: FND_MSG_PUB.Count_And_Get (
1853: p_encoded => FND_API.G_FALSE,

Line 1850: FND_FILE.NEW_LINE(FND_FILE.LOG);

1846: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1847: ROLLBACK TO UPDATE_STATUS;
1848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1849: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error occured: ' || SQLERRM);
1850: FND_FILE.NEW_LINE(FND_FILE.LOG);
1851: -- Standard call to get message count and if count=1, get the message
1852: FND_MSG_PUB.Count_And_Get (
1853: p_encoded => FND_API.G_FALSE,
1854: p_count => x_msg_count,

Line 1860: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error occured: ' || SQLERRM);

1856: );
1857: WHEN OTHERS THEN
1858: ROLLBACK TO UPDATE_STATUS;
1859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1860: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error occured: ' || SQLERRM);
1861: FND_FILE.NEW_LINE(FND_FILE.LOG);
1862: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1863: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1864: END IF;

Line 1861: FND_FILE.NEW_LINE(FND_FILE.LOG);

1857: WHEN OTHERS THEN
1858: ROLLBACK TO UPDATE_STATUS;
1859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1860: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error occured: ' || SQLERRM);
1861: FND_FILE.NEW_LINE(FND_FILE.LOG);
1862: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1863: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1864: END IF;
1865: -- Standard call to get message count and if count=1, get the message

Line 1945: FND_FILE.PUT_LINE(FND_FILE.LOG,' Begin Update HeaderLog');

1941: -- Initialize API return status to SUCCESS
1942: x_return_status := FND_API.G_RET_STS_SUCCESS;
1943:
1944: IF G_DEBUG THEN
1945: FND_FILE.PUT_LINE(FND_FILE.LOG,' Begin Update HeaderLog');
1946: END IF;
1947:
1948: SELECT fnd_profile.VALUE('DPP_AUDIT_ENABLED')
1949: INTO l_log_enabled

Line 1953: fnd_file.put_line(fnd_file.log, 'Audit Enabled ' || l_log_enabled );

1949: INTO l_log_enabled
1950: FROM dual;
1951:
1952: IF G_DEBUG THEN
1953: fnd_file.put_line(fnd_file.log, 'Audit Enabled ' || l_log_enabled );
1954: END IF;
1955:
1956: --Update Header history log
1957: IF l_log_enabled = 'Y' THEN

Line 2025: FND_FILE.PUT_LINE(FND_FILE.LOG,' End Update HeaderLog');

2021: ,p_txn_hdr_rec => l_txn_hdr_hist_rec
2022: );
2023:
2024: IF G_DEBUG THEN
2025: FND_FILE.PUT_LINE(FND_FILE.LOG,' End Update HeaderLog');
2026: END IF;
2027:
2028: IF l_return_status = Fnd_Api.g_ret_sts_error THEN
2029: RAISE Fnd_Api.g_exc_error;

Line 2049: FND_FILE.PUT_LINE(FND_FILE.LOG,' ' || x_msg_data);

2045: fnd_message.set_token('ERRNO', SQLCODE);
2046: fnd_message.set_token('REASON', sqlerrm);
2047: END IF;
2048: x_msg_data := fnd_message.get();
2049: FND_FILE.PUT_LINE(FND_FILE.LOG,' ' || x_msg_data);
2050: END Update_HeaderLog;
2051:
2052: END DPP_EXECUTIONPROCESS_PVT;