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_PUB dependencies on OZF_PROCESS_SETUP_ALL

Line 63: OZF_PROCESS_SETUP_ALL opsa

59: CURSOR get_process_codes_csr (p_supp_trd_prf_id NUMBER)
60: IS
61: SELECT dppl.lookup_code
62: FROM dpp_lookups dppl,
63: OZF_PROCESS_SETUP_ALL opsa
64: WHERE dppl.lookup_type = 'DPP_EXECUTION_PROCESSES'
65: AND dppl.tag is not null
66: AND nvl(opsa.supp_trade_profile_id,0) = nvl(p_supp_trd_prf_id,0)
67: AND opsa.enabled_flag = 'Y'

Line 89: FROM OZF_PROCESS_SETUP_ALL

85:
86: CURSOR get_auto_flag_csr(p_supp_trd_prf_id NUMBER,
87: p_process_code VARCHAR2) IS
88: SELECT nvl(automatic_flag,'N') automatic_flag
89: FROM OZF_PROCESS_SETUP_ALL
90: WHERE nvl(supp_trade_profile_id,0) = nvl(p_supp_trd_prf_id,0)
91: AND process_code = p_process_code
92: AND enabled_flag = 'Y'
93: AND org_id = p_in_org_id;

Line 237: FND_FILE.PUT_LINE(FND_FILE.LOG,'No records found in OZF_PROCESS_SETUP_ALL table for the process code : UPDTPO');

233: END LOOP;
234: END IF;
235: END LOOP;
236: IF NOT l_flag THEN
237: FND_FILE.PUT_LINE(FND_FILE.LOG,'No records found in OZF_PROCESS_SETUP_ALL table for the process code : UPDTPO');
238: FND_FILE.NEW_LINE(FND_FILE.LOG);
239: END IF;
240: l_flag := FALSE;
241: FOR get_auto_flag_rec IN get_auto_flag_csr(l_supp_trade_profile_id,

Line 280: FND_FILE.PUT_LINE(FND_FILE.LOG,'No records found in OZF_PROCESS_SETUP_ALL table for the process code : NTFYPO');

276: END LOOP;
277: END IF;
278: END LOOP;
279: IF NOT l_flag THEN
280: FND_FILE.PUT_LINE(FND_FILE.LOG,'No records found in OZF_PROCESS_SETUP_ALL table for the process code : NTFYPO');
281: FND_FILE.NEW_LINE(FND_FILE.LOG);
282: END IF;
283: l_flag := FALSE;
284: FOR get_auto_flag_rec IN get_auto_flag_csr(l_supp_trade_profile_id,

Line 323: FND_FILE.PUT_LINE(FND_FILE.LOG,'No records found in OZF_PROCESS_SETUP_ALL table for the process code : INVC');

319: END LOOP;
320: END IF;
321: END LOOP;
322: IF NOT l_flag THEN
323: FND_FILE.PUT_LINE(FND_FILE.LOG,'No records found in OZF_PROCESS_SETUP_ALL table for the process code : INVC');
324: FND_FILE.NEW_LINE(FND_FILE.LOG);
325: END IF;
326: l_flag := FALSE;
327: FOR get_auto_flag_rec IN get_auto_flag_csr(l_supp_trade_profile_id,

Line 366: FND_FILE.PUT_LINE(FND_FILE.LOG,'No records found in OZF_PROCESS_SETUP_ALL table for the process code : UPDTLP');

362: END LOOP;
363: END IF;
364: END LOOP;
365: IF NOT l_flag THEN
366: FND_FILE.PUT_LINE(FND_FILE.LOG,'No records found in OZF_PROCESS_SETUP_ALL table for the process code : UPDTLP');
367: FND_FILE.NEW_LINE(FND_FILE.LOG);
368: END IF;
369: l_flag := FALSE;
370: FOR get_auto_flag_rec IN get_auto_flag_csr(l_supp_trade_profile_id,

Line 409: FND_FILE.PUT_LINE(FND_FILE.LOG,'No records found in OZF_PROCESS_SETUP_ALL table for the process code : INPL');

405: END LOOP;
406: END IF;
407: END LOOP;
408: IF NOT l_flag THEN
409: FND_FILE.PUT_LINE(FND_FILE.LOG,'No records found in OZF_PROCESS_SETUP_ALL table for the process code : INPL');
410: FND_FILE.NEW_LINE(FND_FILE.LOG);
411: END IF;
412: l_flag := FALSE;
413: FOR get_auto_flag_rec IN get_auto_flag_csr(l_supp_trade_profile_id,

Line 452: FND_FILE.PUT_LINE(FND_FILE.LOG,'No records found in OZF_PROCESS_SETUP_ALL table for the process code : OUTPL');

448: END LOOP;
449: END IF;
450: END LOOP;
451: IF NOT l_flag THEN
452: FND_FILE.PUT_LINE(FND_FILE.LOG,'No records found in OZF_PROCESS_SETUP_ALL table for the process code : OUTPL');
453: FND_FILE.NEW_LINE(FND_FILE.LOG);
454: END IF;
455: l_flag := FALSE;
456: FOR get_auto_flag_rec IN get_auto_flag_csr(l_supp_trade_profile_id,

Line 495: FND_FILE.PUT_LINE(FND_FILE.LOG,'No records found in OZF_PROCESS_SETUP_ALL table for the process code : PROMO');

491: END LOOP;
492: END IF;
493: END LOOP;
494: IF NOT l_flag THEN
495: FND_FILE.PUT_LINE(FND_FILE.LOG,'No records found in OZF_PROCESS_SETUP_ALL table for the process code : PROMO');
496: FND_FILE.NEW_LINE(FND_FILE.LOG);
497: END IF;
498: --Add here for POPINVDTLS and POPCUSTCLAIM as no setup is required.
499: IF l_setup_flag THEN

Line 558: FND_FILE.PUT_LINE(FND_FILE.LOG,'No setup found in OZF_PROCESS_SETUP_ALL table for the supplier of the

554: errbuff := 'Error';
555: END IF;
556: END LOOP;
557: ELSE
558: FND_FILE.PUT_LINE(FND_FILE.LOG,'No setup found in OZF_PROCESS_SETUP_ALL table for the supplier of the
559: transaction number '||l_txn_hdr_rec.Transaction_number);
560: FND_FILE.NEW_LINE(FND_FILE.LOG);
561: END IF;
562: END LOOP;