1104: aname => 'AMS_OPERATOR');
1105:
1106: -- Create Message to Define the Check Condition met
1107: IF l_operator = 'BETWEEN' THEN
1108: FND_MESSAGE.Set_Name('AMS','AMS_TRIG_CHECK_BET_EXIST');
1109: FND_MESSAGE.Set_Token('CAMP_NAME', l_camp_name, FALSE);
1110: FND_MESSAGE.Set_Token('OPERATOR', l_operator, FALSE);
1111: FND_MESSAGE.Set_Token('VALUE', l_value, FALSE);
1112: FND_MESSAGE.Set_Token('HIGH_VALUE', l_high_value, FALSE);
1105:
1106: -- Create Message to Define the Check Condition met
1107: IF l_operator = 'BETWEEN' THEN
1108: FND_MESSAGE.Set_Name('AMS','AMS_TRIG_CHECK_BET_EXIST');
1109: FND_MESSAGE.Set_Token('CAMP_NAME', l_camp_name, FALSE);
1110: FND_MESSAGE.Set_Token('OPERATOR', l_operator, FALSE);
1111: FND_MESSAGE.Set_Token('VALUE', l_value, FALSE);
1112: FND_MESSAGE.Set_Token('HIGH_VALUE', l_high_value, FALSE);
1113: ELSE
1106: -- Create Message to Define the Check Condition met
1107: IF l_operator = 'BETWEEN' THEN
1108: FND_MESSAGE.Set_Name('AMS','AMS_TRIG_CHECK_BET_EXIST');
1109: FND_MESSAGE.Set_Token('CAMP_NAME', l_camp_name, FALSE);
1110: FND_MESSAGE.Set_Token('OPERATOR', l_operator, FALSE);
1111: FND_MESSAGE.Set_Token('VALUE', l_value, FALSE);
1112: FND_MESSAGE.Set_Token('HIGH_VALUE', l_high_value, FALSE);
1113: ELSE
1114: FND_MESSAGE.Set_Name('AMS','AMS_TRIG_CHECK_EXIST');
1107: IF l_operator = 'BETWEEN' THEN
1108: FND_MESSAGE.Set_Name('AMS','AMS_TRIG_CHECK_BET_EXIST');
1109: FND_MESSAGE.Set_Token('CAMP_NAME', l_camp_name, FALSE);
1110: FND_MESSAGE.Set_Token('OPERATOR', l_operator, FALSE);
1111: FND_MESSAGE.Set_Token('VALUE', l_value, FALSE);
1112: FND_MESSAGE.Set_Token('HIGH_VALUE', l_high_value, FALSE);
1113: ELSE
1114: FND_MESSAGE.Set_Name('AMS','AMS_TRIG_CHECK_EXIST');
1115: FND_MESSAGE.Set_Token('CAMP_NAME', l_camp_name, FALSE);
1108: FND_MESSAGE.Set_Name('AMS','AMS_TRIG_CHECK_BET_EXIST');
1109: FND_MESSAGE.Set_Token('CAMP_NAME', l_camp_name, FALSE);
1110: FND_MESSAGE.Set_Token('OPERATOR', l_operator, FALSE);
1111: FND_MESSAGE.Set_Token('VALUE', l_value, FALSE);
1112: FND_MESSAGE.Set_Token('HIGH_VALUE', l_high_value, FALSE);
1113: ELSE
1114: FND_MESSAGE.Set_Name('AMS','AMS_TRIG_CHECK_EXIST');
1115: FND_MESSAGE.Set_Token('CAMP_NAME', l_camp_name, FALSE);
1116: FND_MESSAGE.Set_Token('OPERATOR', l_operator, FALSE);
1110: FND_MESSAGE.Set_Token('OPERATOR', l_operator, FALSE);
1111: FND_MESSAGE.Set_Token('VALUE', l_value, FALSE);
1112: FND_MESSAGE.Set_Token('HIGH_VALUE', l_high_value, FALSE);
1113: ELSE
1114: FND_MESSAGE.Set_Name('AMS','AMS_TRIG_CHECK_EXIST');
1115: FND_MESSAGE.Set_Token('CAMP_NAME', l_camp_name, FALSE);
1116: FND_MESSAGE.Set_Token('OPERATOR', l_operator, FALSE);
1117: FND_MESSAGE.Set_Token('VALUE', l_value, FALSE);
1118: END IF ;
1111: FND_MESSAGE.Set_Token('VALUE', l_value, FALSE);
1112: FND_MESSAGE.Set_Token('HIGH_VALUE', l_high_value, FALSE);
1113: ELSE
1114: FND_MESSAGE.Set_Name('AMS','AMS_TRIG_CHECK_EXIST');
1115: FND_MESSAGE.Set_Token('CAMP_NAME', l_camp_name, FALSE);
1116: FND_MESSAGE.Set_Token('OPERATOR', l_operator, FALSE);
1117: FND_MESSAGE.Set_Token('VALUE', l_value, FALSE);
1118: END IF ;
1119:
1112: FND_MESSAGE.Set_Token('HIGH_VALUE', l_high_value, FALSE);
1113: ELSE
1114: FND_MESSAGE.Set_Name('AMS','AMS_TRIG_CHECK_EXIST');
1115: FND_MESSAGE.Set_Token('CAMP_NAME', l_camp_name, FALSE);
1116: FND_MESSAGE.Set_Token('OPERATOR', l_operator, FALSE);
1117: FND_MESSAGE.Set_Token('VALUE', l_value, FALSE);
1118: END IF ;
1119:
1120: l_message := FND_MESSAGE.Get;
1113: ELSE
1114: FND_MESSAGE.Set_Name('AMS','AMS_TRIG_CHECK_EXIST');
1115: FND_MESSAGE.Set_Token('CAMP_NAME', l_camp_name, FALSE);
1116: FND_MESSAGE.Set_Token('OPERATOR', l_operator, FALSE);
1117: FND_MESSAGE.Set_Token('VALUE', l_value, FALSE);
1118: END IF ;
1119:
1120: l_message := FND_MESSAGE.Get;
1121:
1116: FND_MESSAGE.Set_Token('OPERATOR', l_operator, FALSE);
1117: FND_MESSAGE.Set_Token('VALUE', l_value, FALSE);
1118: END IF ;
1119:
1120: l_message := FND_MESSAGE.Get;
1121:
1122: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
1123: itemkey => itemkey,
1124: aname => 'AMS_NTF_MESSAGE',
2033: OPEN c_resource ;
2034: FETCH c_resource INTO l_person_id ;
2035: IF c_resource%NOTFOUND THEN
2036: x_return_status := FND_API.G_RET_STS_ERROR;
2037: FND_MESSAGE.Set_Name('AMS','AMS_APPR_INVALID_RESOURCE_ID');
2038: FND_MSG_PUB.Add;
2039: END IF;
2040: CLOSE c_resource ;
2041: -- Pass the Employee ID to get the Role
2045: p_name => x_role_name,
2046: p_display_name => x_role_display_name );
2047: IF x_role_name is null then
2048: x_return_status := FND_API.G_RET_STS_ERROR;
2049: FND_MESSAGE.Set_Name('AMS','AMS_APPR_INVALID_ROLE');
2050: FND_MSG_PUB.Add;
2051: END IF;
2052: END Get_User_Role;
2053: