5540:
5541: if p_prefix_operator = '<>' then
5542: begin
5543:
5544: l_userid := FND_GLOBAL.USER_ID;
5545: l_reqid := FND_GLOBAL.CONC_REQUEST_ID;
5546:
5547: for c_SalaryNeq_Rec in c_SalaryNeq loop
5548:
5541: if p_prefix_operator = '<>' then
5542: begin
5543:
5544: l_userid := FND_GLOBAL.USER_ID;
5545: l_reqid := FND_GLOBAL.CONC_REQUEST_ID;
5546:
5547: for c_SalaryNeq_Rec in c_SalaryNeq loop
5548:
5549: message_token('CONSTRAINT_SET', p_constraint_set_name);
5653:
5654: if p_prefix_operator = '<>' then
5655: begin
5656:
5657: l_userid := FND_GLOBAL.USER_ID;
5658: l_reqid := FND_GLOBAL.CONC_REQUEST_ID;
5659:
5660: for c_SalaryNeqAll_Rec in c_SalaryNeqAll loop
5661:
5654: if p_prefix_operator = '<>' then
5655: begin
5656:
5657: l_userid := FND_GLOBAL.USER_ID;
5658: l_reqid := FND_GLOBAL.CONC_REQUEST_ID;
5659:
5660: for c_SalaryNeqAll_Rec in c_SalaryNeqAll loop
5661:
5662: message_token('CONSTRAINT_SET', p_constraint_set_name);
5773: else
5774: p_constraint_validation_status := 'E';
5775: end if;
5776:
5777: l_userid := FND_GLOBAL.USER_ID;
5778: l_reqid := FND_GLOBAL.CONC_REQUEST_ID;
5779:
5780: message_token('CONSTRAINT_SET', p_constraint_set_name);
5781: message_token('THRESHOLD', p_constraint_threshold);
5774: p_constraint_validation_status := 'E';
5775: end if;
5776:
5777: l_userid := FND_GLOBAL.USER_ID;
5778: l_reqid := FND_GLOBAL.CONC_REQUEST_ID;
5779:
5780: message_token('CONSTRAINT_SET', p_constraint_set_name);
5781: message_token('THRESHOLD', p_constraint_threshold);
5782: message_token('CONSTRAINT', p_constraint_name);
6059: else
6060: p_constraint_validation_status := 'E';
6061: end if;
6062:
6063: l_userid := FND_GLOBAL.USER_ID;
6064: l_reqid := FND_GLOBAL.CONC_REQUEST_ID;
6065:
6066: message_token('CONSTRAINT_SET', p_constraint_set_name);
6067: message_token('THRESHOLD', p_constraint_threshold);
6060: p_constraint_validation_status := 'E';
6061: end if;
6062:
6063: l_userid := FND_GLOBAL.USER_ID;
6064: l_reqid := FND_GLOBAL.CONC_REQUEST_ID;
6065:
6066: message_token('CONSTRAINT_SET', p_constraint_set_name);
6067: message_token('THRESHOLD', p_constraint_threshold);
6068: message_token('CONSTRAINT', p_constraint_name);