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 DPP_UTILITY_PVT

Line 155: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_PROCEDURE, 'dpp.plsql.' || L_FULL_NAME, 'Public API: ' || L_API_NAME || ' started at: ' || to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));

151: RETCODE := 0;
152:
153: SAVEPOINT INITIATE_EXEC;
154:
155: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_PROCEDURE, 'dpp.plsql.' || L_FULL_NAME, 'Public API: ' || L_API_NAME || ' started at: ' || to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));
156:
157: --Initialize message list
158: FND_MSG_PUB.INITIALIZE;
159:

Line 169: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*Concurrent program executed for the transaction header id : '

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:
172:
173: l_supp_trade_profile_id := GET_PROCESS_SETUP_ID (get_approved_txn_rec.vendor_id, get_approved_txn_rec.vendor_site_id, P_IN_ORG_ID);

Line 191: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_AUTO_PROC_MSG || 'UPDTPO');

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
195: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_REC_PROC_MSG || 'UPDTPO');

Line 197: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_NO_REC_PROC_MSG || 'UPDTPO');

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
201: l_flag := TRUE;

Line 216: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_AUTO_PROC_MSG || 'INVC');

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
220: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_REC_PROC_MSG || 'INVC');

Line 222: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_NO_REC_PROC_MSG || 'INVC');

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
226: l_flag := TRUE;

Line 241: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_AUTO_PROC_MSG || 'UPDTLP');

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
245: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_REC_PROC_MSG || 'UPDTLP');

Line 247: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_NO_REC_PROC_MSG || 'UPDTLP');

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,
251: L_MSG_DATA, L_SUPP_TRADE_PROFILE_ID,P_IN_ORG_ID, GET_APPROVED_TXN_REC.TRANSACTION_HEADER_ID,GET_APPROVED_TXN_REC.TRANSACTION_NUMBER);

Line 377: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_ERROR, 'dpp.plsql.' || L_FULL_NAME, L_API_NAME || ' : Not a compatible API call.');

373:
374: -- Standard call to check for call compatibility.
375: IF NOT FND_API.COMPATIBLE_API_CALL (L_API_VERSION, P_API_VERSION, L_API_NAME, G_PKG_NAME)
376: THEN
377: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_ERROR, 'dpp.plsql.' || L_FULL_NAME, L_API_NAME || ' : Not a compatible API call.');
378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
379: END IF;
380:
381: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_PROCEDURE, 'dpp.plsql.' || L_FULL_NAME, L_API_NAME||': START');

Line 381: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_PROCEDURE, 'dpp.plsql.' || L_FULL_NAME, L_API_NAME||': START');

377: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_ERROR, 'dpp.plsql.' || L_FULL_NAME, L_API_NAME || ' : Not a compatible API call.');
378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
379: END IF;
380:
381: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_PROCEDURE, 'dpp.plsql.' || L_FULL_NAME, L_API_NAME||': START');
382:
383: --Initialize message list if p_init_msg_list is TRUE.
384: IF FND_API.TO_BOOLEAN (P_INIT_MSG_LIST) THEN
385: FND_MSG_PUB.INITIALIZE;

Line 406: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_AUTO_PROC_MSG || 'NTFYPO');

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
410: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_REC_PROC_MSG || 'NTFYPO');

Line 412: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_NO_REC_PROC_MSG || 'NYFYPO');

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;
416: FOR get_auto_flag_rec IN get_auto_flag_csr(p_supp_trade_profile_id, 'INPL', p_transaction_header_id) LOOP

Line 429: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_AUTO_PROC_MSG || 'INPL');

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
433: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_REC_PROC_MSG || 'INPL');

Line 435: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_NO_REC_PROC_MSG || 'INPL');

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;
439: FOR get_auto_flag_rec IN get_auto_flag_csr(p_supp_trade_profile_id, 'OUTPL', p_transaction_header_id) LOOP

Line 452: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_AUTO_PROC_MSG || 'OUTPL');

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
456: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_REC_PROC_MSG || 'OUTPL');

Line 458: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_NO_REC_PROC_MSG || 'OUTPL');

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;
462: FOR get_auto_flag_rec IN get_auto_flag_csr(p_supp_trade_profile_id, 'PROMO', p_transaction_header_id) LOOP

Line 475: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_AUTO_PROC_MSG || 'PROMO');

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
479: FND_FILE.PUT_LINE(FND_FILE.LOG, G_NO_REC_PROC_MSG || 'PROMO');

Line 481: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_NO_REC_PROC_MSG || 'PROMO');

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;
485:

Line 569: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_ERROR, 'dpp.plsql.' || L_FULL_NAME, L_API_NAME || ' : Not a compatible API call.');

565:
566: -- Standard call to check for call compatibility.
567: IF NOT FND_API.COMPATIBLE_API_CALL (L_API_VERSION, P_API_VERSION, L_API_NAME, G_PKG_NAME)
568: THEN
569: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_ERROR, 'dpp.plsql.' || L_FULL_NAME, L_API_NAME || ' : Not a compatible API call.');
570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
571: END IF;
572:
573: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_PROCEDURE, 'dpp.plsql.' || L_FULL_NAME, L_API_NAME||': START');

Line 573: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_PROCEDURE, 'dpp.plsql.' || L_FULL_NAME, L_API_NAME||': START');

569: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_ERROR, 'dpp.plsql.' || L_FULL_NAME, L_API_NAME || ' : Not a compatible API call.');
570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
571: END IF;
572:
573: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_PROCEDURE, 'dpp.plsql.' || L_FULL_NAME, L_API_NAME||': START');
574:
575: --Initialize message list if p_init_msg_list is TRUE.
576: IF FND_API.TO_BOOLEAN (P_INIT_MSG_LIST) THEN
577: FND_MSG_PUB.INITIALIZE;

Line 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);

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
612: WHEN FND_API.G_EXC_ERROR THEN

Line 689: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Supplier trade profile setup not available');

685: WHEN NO_DATA_FOUND THEN
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

Line 695: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Exception while fetching supp_trade_profile_id: ' || SQLERRM);

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);
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:

Line 743: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Exception while fetching from OZF_PROCESS_SETUP_ALL: ' || SQLERRM);

739: END IF;
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:

Line 775: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'No setup at supplier trade profile for vendor id : '

771:
772: --Check if the Process Setup is done for the Supplier, Supplier site and Operating Unit
773: IF NOT IS_PROCESS_SETUP(L_SUPP_TRADE_PROFILE_ID, P_ORG_ID) THEN
774: L_SUPP_TRADE_PROFILE_ID := NULL;
775: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'No setup at supplier trade profile for vendor id : '
776: || P_VENDOR_ID || ' at site id ' || P_VENDOR_SITE_ID || ', org id ' || P_ORG_ID);
777: --Check if setup is available at system parameter level
778: IF NOT IS_PROCESS_SETUP(NULL, P_ORG_ID) THEN
779: --Process Setup does not exist

Line 785: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'No price protection setup available for vendor id : '

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;
789: END IF;

Line 845: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Public API: ' || l_api_name || ' started at: ' || to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));

841: RETCODE := 0;
842:
843: SAVEPOINT INITIATE_NOTIF;
844:
845: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Public API: ' || l_api_name || ' started at: ' || to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));
846:
847: --Initialize message list
848: FND_MSG_PUB.INITIALIZE;
849:

Line 863: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, '*' || G_NO_DAYS_MSG || P_IN_ORG_ID);

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:
867: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, L_API_NAME || ' Number of days for auto notif:' || L_DAYS);

Line 867: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, L_API_NAME || ' Number of days for auto notif:' || L_DAYS);

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:
867: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, L_API_NAME || ' Number of days for auto notif:' || L_DAYS);
868:
869: IF L_DAYS >= 0
870: THEN
871: FOR get_txn_to_notify_rec IN get_txn_to_notify_csr(l_days) LOOP

Line 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);

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:
878: L_SUPP_TRADE_PROFILE_ID := GET_PROCESS_SETUP_ID(GET_TXN_TO_NOTIFY_REC.VENDOR_ID, GET_TXN_TO_NOTIFY_REC.VENDOR_SITE_ID, P_IN_ORG_ID);

Line 885: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_AUTO_EVT_SUCCESS_MSG );

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';
889: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE, p_count => l_msg_count, p_data => l_msg_data );

Line 906: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, '*' || G_NO_TXN_MSG || L_DAYS);

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;
910:

Line 1295: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Public API: ' || l_api_name || ' started at: ' || to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));

1291: -- Initialize message list
1292: FND_MSG_PUB.initialize;
1293:
1294:
1295: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Public API: ' || l_api_name || ' started at: ' || to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'));
1296:
1297: -- Initialize API return status to sucess
1298: errbuf := 'Success';
1299: retcode := 0;

Line 1511: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'No Price protection transactions effective today.');

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
1515: COMMIT;