APPS.IGS_UC_TRAN_PROCESSOR_PKG dependencies on FND_PROFILE

Line 175: IF fnd_profile.value('IGS_UC_HOLD_UCAS_TRANSACTION') = 'Y' THEN

171: p_ucas_cycle => p_ucas_cycle ,
172: p_transaction_toy => l_transaction_toy);
173:
174: -- If Hold Profile value set then hold flag value is Y
175: IF fnd_profile.value('IGS_UC_HOLD_UCAS_TRANSACTION') = 'Y' THEN
176: l_Hold := 'Y' ;
177: ELSE
178: l_hold := NVL(p_hold,'N');
179: END IF;

Line 252: IF l_error_code IS NOT NULL AND NVL(fnd_profile.value('IGS_UC_HOLD_UCAS_TRANSACTION'),'N') = 'N' THEN

248: p_comments_in_offer => l_comments_in_offer,
249: p_error_code => l_error_code);
250:
251: -- If transaction has an error then set the hold flag Y
252: IF l_error_code IS NOT NULL AND NVL(fnd_profile.value('IGS_UC_HOLD_UCAS_TRANSACTION'),'N') = 'N' THEN
253: -- get the hold profile value and update the transactions with hold flag Y
254: OPEN c_transactions(l_uc_tran_id);
255: FETCH c_transactions INTO l_transactions;
256: CLOSE c_transactions;

Line 397: IF l_error_code IS NOT NULL AND NVL(fnd_profile.value('IGS_UC_HOLD_UCAS_TRANSACTION'),'N') = 'N' THEN

393: p_comments_in_offer => l_comments_in_offer,
394: p_error_code => l_error_code);
395:
396: -- If transaction has an error then set the hold flag Y
397: IF l_error_code IS NOT NULL AND NVL(fnd_profile.value('IGS_UC_HOLD_UCAS_TRANSACTION'),'N') = 'N' THEN
398: -- get the hold profile value and update the transactions with hold flag Y
399: OPEN c_transactions(l_uc_tran_id);
400: FETCH c_transactions INTO l_transactions;
401: CLOSE c_transactions;

Line 847: l_hold := NVL(fnd_profile.value('IGS_UC_HOLD_UCAS_TRANSACTION'),'N');

843: -- If processing period is NOT claering then hold falg is Y
844: IF l_transaction_toy <> 'C' THEN
845: l_hold := 'Y';
846: ELSE
847: l_hold := NVL(fnd_profile.value('IGS_UC_HOLD_UCAS_TRANSACTION'),'N');
848: END IF;
849:
850: IF l_generate_tran = 'Y' THEN
851: P_return1 := 0;

Line 1008: l_hold := NVL(fnd_profile.value('IGS_UC_HOLD_UCAS_TRANSACTION'),'N');

1004: --If processing period is not claering then hold flag is Y
1005: IF l_transaction_toy <> 'C' THEN
1006: l_hold := 'Y';
1007: ELSE
1008: l_hold := NVL(fnd_profile.value('IGS_UC_HOLD_UCAS_TRANSACTION'),'N');
1009: END IF;
1010:
1011: igs_uc_transactions_pkg.insert_row (
1012: x_mode => p_mode, --jchakrab modified for 4380412

Line 1105: IF l_error_code IS NOT NULL AND NVL(fnd_profile.value('IGS_UC_HOLD_UCAS_TRANSACTION'),'N') = 'N' THEN

1101: p_comments_in_offer => l_comments_in_offer,
1102: p_error_code => l_error_code);
1103:
1104: -- If transaction has an error then set the hold flag Y
1105: IF l_error_code IS NOT NULL AND NVL(fnd_profile.value('IGS_UC_HOLD_UCAS_TRANSACTION'),'N') = 'N' THEN
1106: -- get the hold profile value and update the transactions with hold flag Y
1107: OPEN c_transactions(l_uc_tran_id);
1108: FETCH c_transactions INTO l_transactions;
1109: CLOSE c_transactions;

Line 1203: IF l_error_code IS NOT NULL AND NVL(fnd_profile.value('IGS_UC_HOLD_UCAS_TRANSACTION'),'N') = 'N' THEN

1199: p_comments_in_offer => l_comments_in_offer,
1200: p_error_code => l_error_code);
1201:
1202: -- If transaction has an error then set the hold flag Y
1203: IF l_error_code IS NOT NULL AND NVL(fnd_profile.value('IGS_UC_HOLD_UCAS_TRANSACTION'),'N') = 'N' THEN
1204: -- get the hold profile value and update the transactions with hold flag Y
1205: OPEN c_transactions(l_uc_tran_id);
1206: FETCH c_transactions INTO l_transactions;
1207: CLOSE c_transactions;

Line 1273: l_hold := NVL(fnd_profile.value('IGS_UC_HOLD_UCAS_TRANSACTION'),'N');

1269: -- If processing period is not extra then hold flag is Y
1270: IF l_transaction_toy <> 'E' THEN
1271: l_hold := 'Y';
1272: ELSE
1273: l_hold := NVL(fnd_profile.value('IGS_UC_HOLD_UCAS_TRANSACTION'),'N');
1274: END IF;
1275:
1276: igs_uc_transactions_pkg.insert_row (
1277: x_mode => p_mode, --jchakrab modified for 4380412