159: CLOSE c_is_upgrade_customer;
160:
161: IF l_is_upgrade_customer = 0 THEN
162:
163: FND_MESSAGE.SET_NAME('JG','JG_ZZ_VAT_PRE_REP_PROC_NREQ');
164: fnd_file.put_line(fnd_file.log,FND_MESSAGE.GET);
165: return;
166:
167: END IF;
160:
161: IF l_is_upgrade_customer = 0 THEN
162:
163: FND_MESSAGE.SET_NAME('JG','JG_ZZ_VAT_PRE_REP_PROC_NREQ');
164: fnd_file.put_line(fnd_file.log,FND_MESSAGE.GET);
165: return;
166:
167: END IF;
168:
228:
229: END IF; -- IF p_reporting_level = 'LEDGER' THEN
230:
231: IF l_last_reported_period IS NOT NULL THEN
232: FND_MESSAGE.SET_NAME('JG','JG_ZZ_VAT_PRE_REP_PROC_RAN');
233: errbuf := FND_MESSAGE.GET;
234: retcode := 2;
235: RETURN;
236:
229: END IF; -- IF p_reporting_level = 'LEDGER' THEN
230:
231: IF l_last_reported_period IS NOT NULL THEN
232: FND_MESSAGE.SET_NAME('JG','JG_ZZ_VAT_PRE_REP_PROC_RAN');
233: errbuf := FND_MESSAGE.GET;
234: retcode := 2;
235: RETURN;
236:
237: ELSIF l_last_reported_period IS NULL AND l_is_mgr_trx_exist IS NOT NULL THEN
235: RETURN;
236:
237: ELSIF l_last_reported_period IS NULL AND l_is_mgr_trx_exist IS NOT NULL THEN
238:
239: FND_MESSAGE.SET_NAME('JG','JG_ZZ_VAT_PRE_REP_PROC_NREQ');
240: errbuf := FND_MESSAGE.GET;
241: retcode := 2;
242: RETURN;
243:
236:
237: ELSIF l_last_reported_period IS NULL AND l_is_mgr_trx_exist IS NOT NULL THEN
238:
239: FND_MESSAGE.SET_NAME('JG','JG_ZZ_VAT_PRE_REP_PROC_NREQ');
240: errbuf := FND_MESSAGE.GET;
241: retcode := 2;
242: RETURN;
243:
244: END IF;