DBA Data[Home] [Help]

APPS.IGS_PS_UNIT_OFR_OPT_PKG dependencies on FND_PROFILE

Line 1791: IF ((FND_PROFILE.VALUE('IGS_PS_CALL_NUMBER') = 'USER_DEFINED') AND (x_call_number IS NOT NULL) ) THEN

1787: END IF;
1788: CLOSE cur_teach_to_load;
1789:
1790: --check the call number uniqueness
1791: IF ((FND_PROFILE.VALUE('IGS_PS_CALL_NUMBER') = 'USER_DEFINED') AND (x_call_number IS NOT NULL) ) THEN
1792: IF NOT check_call_number(x_cal_type,x_ci_sequence_number,x_call_number,x_rowid) THEN
1793: Fnd_Message.Set_Name ('IGS', 'IGS_PS_DUPLICATE_CALL_NUMBER');
1794: IGS_GE_MSG_STACK.ADD;
1795: App_Exception.Raise_Exception;

Line 1806: IF ((FND_PROFILE.VALUE('IGS_PS_CALL_NUMBER') = 'USER_DEFINED') AND (x_call_number IS NOT NULL) ) THEN

1802: (new_references.call_number IS NULL)) THEN
1803: NULL;
1804: ELSE
1805: --check the call number uniqueness
1806: IF ((FND_PROFILE.VALUE('IGS_PS_CALL_NUMBER') = 'USER_DEFINED') AND (x_call_number IS NOT NULL) ) THEN
1807: IF NOT check_call_number(x_cal_type,x_ci_sequence_number,x_call_number,x_rowid) THEN
1808: Fnd_Message.Set_Name ('IGS', 'IGS_PS_DUPLICATE_CALL_NUMBER');
1809: IGS_GE_MSG_STACK.ADD;
1810: App_Exception.Raise_Exception;

Line 2178: IF FND_PROFILE.VALUE('IGS_PS_CALL_NUMBER') = 'AUTO' THEN

2174: x_abort_flag => x_abort_flag
2175: );
2176:
2177: --When the profile option is AUTO then use the sequence number to populate the call_number value
2178: IF FND_PROFILE.VALUE('IGS_PS_CALL_NUMBER') = 'AUTO' THEN
2179: x_call_number := get_call_number(new_references.cal_type, new_references.ci_sequence_number);
2180: IF x_call_number = -1 THEN
2181: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
2182: app_exception.raise_exception;