147:
148: -- check whether any records exists for the applicant choices
149: IF (c_app_choices%NOTFOUND) THEN
150: CLOSE c_app_choices;
151: fnd_message.set_name('IGS','IGS_UC_DEC_REP_NOT_FOUND');
152: fnd_message.set_token('APPNO', l_alt_appl_id);
153: fnd_message.set_token('CHOICENO', TO_CHAR(lv_choice_no));
154: igs_ge_msg_stack.add;
155: RETURN;
148: -- check whether any records exists for the applicant choices
149: IF (c_app_choices%NOTFOUND) THEN
150: CLOSE c_app_choices;
151: fnd_message.set_name('IGS','IGS_UC_DEC_REP_NOT_FOUND');
152: fnd_message.set_token('APPNO', l_alt_appl_id);
153: fnd_message.set_token('CHOICENO', TO_CHAR(lv_choice_no));
154: igs_ge_msg_stack.add;
155: RETURN;
156: ELSE
149: IF (c_app_choices%NOTFOUND) THEN
150: CLOSE c_app_choices;
151: fnd_message.set_name('IGS','IGS_UC_DEC_REP_NOT_FOUND');
152: fnd_message.set_token('APPNO', l_alt_appl_id);
153: fnd_message.set_token('CHOICENO', TO_CHAR(lv_choice_no));
154: igs_ge_msg_stack.add;
155: RETURN;
156: ELSE
157: -- get the system code for the applicant.
170: OPEN system_name_cur(l_system_code);
171: FETCH system_name_cur INTO l_system_name;
172: CLOSE system_name_cur;
173:
174: fnd_message.set_name('IGS','IGS_UC_DECISION_MAP_NOT_FOUND');
175: fnd_message.set_token('SYS_NAME',l_system_name );
176: fnd_message.set_token('ADM_OUTSTAT', lv_out_come_status);
177: igs_ge_msg_stack.add;
178: RETURN;
171: FETCH system_name_cur INTO l_system_name;
172: CLOSE system_name_cur;
173:
174: fnd_message.set_name('IGS','IGS_UC_DECISION_MAP_NOT_FOUND');
175: fnd_message.set_token('SYS_NAME',l_system_name );
176: fnd_message.set_token('ADM_OUTSTAT', lv_out_come_status);
177: igs_ge_msg_stack.add;
178: RETURN;
179: END IF;
172: CLOSE system_name_cur;
173:
174: fnd_message.set_name('IGS','IGS_UC_DECISION_MAP_NOT_FOUND');
175: fnd_message.set_token('SYS_NAME',l_system_name );
176: fnd_message.set_token('ADM_OUTSTAT', lv_out_come_status);
177: igs_ge_msg_stack.add;
178: RETURN;
179: END IF;
180: CLOSE ucas_decision_cd_cur;
259: p_uc_tran_id => p_uc_tran_id,
260: p_validate_error_cd => l_validate_error_cd
261: );
262: ELSE
263: fnd_message.set_name('IGS','IGS_UC_CREATE_TRANSACTION');
264: igs_ge_msg_stack.add;
265: RETURN;
266: END IF;
267:
283: ELSIF l_decision IN ('C','I') AND l_reply IN ('F','I') THEN
284: -- Call the transaction builder with RD transaction.
285: l_transaction_type := 'RD';
286: ELSE
287: fnd_message.set_name('IGS','IGS_UC_CREATE_TRANSACTION');
288: igs_ge_msg_stack.add;
289: RETURN;
290: END IF;
291:
309: -- Call the transaction builder with RW
310: l_transaction_type := 'RW';
311:
312: ELSE
313: fnd_message.set_name('IGS','IGS_UC_CREATE_TRANSACTION');
314: igs_ge_msg_stack.add;
315: RETURN;
316: END IF;
317:
324: -- Call the transaction builder with LA
325: l_transaction_type := 'LA';
326:
327: ELSE
328: fnd_message.set_name('IGS','IGS_UC_CREATE_TRANSACTION');
329: igs_ge_msg_stack.add;
330: RETURN;
331: END IF;
332:
330: RETURN;
331: END IF;
332:
333: ELSE
334: fnd_message.set_name('IGS','IGS_UC_CREATE_TRANSACTION');
335: igs_ge_msg_stack.add;
336: RETURN;
337: END IF; -- End if for system status
338:
370: END IF;
371: CLOSE c_app_choices;
372:
373: IF (lv_return1 = 1) THEN
374: fnd_message.set_name('IGS',lv_return2);
375: igs_ge_msg_stack.add;
376: END IF;
377:
378: EXCEPTION
379: WHEN OTHERS THEN
380: -- Incase if there is any exception, the rollback is limited to only ucas transaction.
381: -- changes as per bug# 2459877.
382: ROLLBACK TO ucas_transactions;
383: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
384: fnd_message.set_token('NAME','IGS_UC_TRX_GEN_HOOK.CREATE_UCAS_TRANSACTIONS');
385: igs_ge_msg_stack.add;
386: END create_ucas_transactions;
387:
380: -- Incase if there is any exception, the rollback is limited to only ucas transaction.
381: -- changes as per bug# 2459877.
382: ROLLBACK TO ucas_transactions;
383: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
384: fnd_message.set_token('NAME','IGS_UC_TRX_GEN_HOOK.CREATE_UCAS_TRANSACTIONS');
385: igs_ge_msg_stack.add;
386: END create_ucas_transactions;
387:
388: END igs_uc_trx_gen_hook;