eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_IBA_PS_RULEGRPS_B_PKG dependencies on FND_API

Line 67: DECODE( px_rulegroup_id, FND_API.g_miss_num, NULL, px_rulegroup_id),

63: creation_date,
64: last_updated_by,
65: object_version_number
66: ) VALUES (
67: DECODE( px_rulegroup_id, FND_API.g_miss_num, NULL, px_rulegroup_id),
68: DECODE( p_posting_id, FND_API.g_miss_num, NULL, p_posting_id),
69: DECODE( p_strategy_type, FND_API.g_miss_char, NULL, p_strategy_type),
70: DECODE( p_exec_priority, FND_API.g_miss_num, NULL, p_exec_priority),
71: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

Line 68: DECODE( p_posting_id, FND_API.g_miss_num, NULL, p_posting_id),

64: last_updated_by,
65: object_version_number
66: ) VALUES (
67: DECODE( px_rulegroup_id, FND_API.g_miss_num, NULL, px_rulegroup_id),
68: DECODE( p_posting_id, FND_API.g_miss_num, NULL, p_posting_id),
69: DECODE( p_strategy_type, FND_API.g_miss_char, NULL, p_strategy_type),
70: DECODE( p_exec_priority, FND_API.g_miss_num, NULL, p_exec_priority),
71: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
72: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

Line 69: DECODE( p_strategy_type, FND_API.g_miss_char, NULL, p_strategy_type),

65: object_version_number
66: ) VALUES (
67: DECODE( px_rulegroup_id, FND_API.g_miss_num, NULL, px_rulegroup_id),
68: DECODE( p_posting_id, FND_API.g_miss_num, NULL, p_posting_id),
69: DECODE( p_strategy_type, FND_API.g_miss_char, NULL, p_strategy_type),
70: DECODE( p_exec_priority, FND_API.g_miss_num, NULL, p_exec_priority),
71: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
72: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
73: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

Line 70: DECODE( p_exec_priority, FND_API.g_miss_num, NULL, p_exec_priority),

66: ) VALUES (
67: DECODE( px_rulegroup_id, FND_API.g_miss_num, NULL, px_rulegroup_id),
68: DECODE( p_posting_id, FND_API.g_miss_num, NULL, p_posting_id),
69: DECODE( p_strategy_type, FND_API.g_miss_char, NULL, p_strategy_type),
70: DECODE( p_exec_priority, FND_API.g_miss_num, NULL, p_exec_priority),
71: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
72: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
73: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
74: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

Line 71: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

67: DECODE( px_rulegroup_id, FND_API.g_miss_num, NULL, px_rulegroup_id),
68: DECODE( p_posting_id, FND_API.g_miss_num, NULL, p_posting_id),
69: DECODE( p_strategy_type, FND_API.g_miss_char, NULL, p_strategy_type),
70: DECODE( p_exec_priority, FND_API.g_miss_num, NULL, p_exec_priority),
71: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
72: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
73: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
74: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
75: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

Line 72: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

68: DECODE( p_posting_id, FND_API.g_miss_num, NULL, p_posting_id),
69: DECODE( p_strategy_type, FND_API.g_miss_char, NULL, p_strategy_type),
70: DECODE( p_exec_priority, FND_API.g_miss_num, NULL, p_exec_priority),
71: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
72: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
73: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
74: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
75: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
76: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));

Line 73: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

69: DECODE( p_strategy_type, FND_API.g_miss_char, NULL, p_strategy_type),
70: DECODE( p_exec_priority, FND_API.g_miss_num, NULL, p_exec_priority),
71: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
72: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
73: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
74: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
75: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
76: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));
77:

Line 74: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

70: DECODE( p_exec_priority, FND_API.g_miss_num, NULL, p_exec_priority),
71: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
72: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
73: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
74: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
75: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
76: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));
77:
78:

Line 75: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

71: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
72: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
73: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
74: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
75: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
76: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));
77:
78:
79: INSERT INTO AMS_IBA_PS_RULEGRPS_TL(

Line 76: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));

72: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
73: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
74: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
75: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
76: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));
77:
78:
79: INSERT INTO AMS_IBA_PS_RULEGRPS_TL(
80: RULEGROUP_NAME,

Line 94: decode( p_RULE_NAME, FND_API.G_MISS_CHAR, NULL, p_RULE_NAME),

90: SOURCE_LANG
91:
92: ) SELECT
93:
94: decode( p_RULE_NAME, FND_API.G_MISS_CHAR, NULL, p_RULE_NAME),
95: decode( p_RULE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_RULE_DESCRIPTION),
96: DECODE( px_rulegroup_id, FND_API.g_miss_num, NULL, px_rulegroup_id),
97: FND_GLOBAL.user_id,
98: SYSDATE,

Line 95: decode( p_RULE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_RULE_DESCRIPTION),

91:
92: ) SELECT
93:
94: decode( p_RULE_NAME, FND_API.G_MISS_CHAR, NULL, p_RULE_NAME),
95: decode( p_RULE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_RULE_DESCRIPTION),
96: DECODE( px_rulegroup_id, FND_API.g_miss_num, NULL, px_rulegroup_id),
97: FND_GLOBAL.user_id,
98: SYSDATE,
99: FND_GLOBAL.user_id,

Line 96: DECODE( px_rulegroup_id, FND_API.g_miss_num, NULL, px_rulegroup_id),

92: ) SELECT
93:
94: decode( p_RULE_NAME, FND_API.G_MISS_CHAR, NULL, p_RULE_NAME),
95: decode( p_RULE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_RULE_DESCRIPTION),
96: DECODE( px_rulegroup_id, FND_API.g_miss_num, NULL, px_rulegroup_id),
97: FND_GLOBAL.user_id,
98: SYSDATE,
99: FND_GLOBAL.user_id,
100: SYSDATE,

Line 102: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

98: SYSDATE,
99: FND_GLOBAL.user_id,
100: SYSDATE,
101: FND_GLOBAL.conc_login_id,
102: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
103: l.language_code,
104: USERENV('LANG')
105: FROM fnd_languages l
106: WHERE l.installed_flag in ('I', 'B')

Line 110: WHERE t.rulegroup_id = DECODE( px_rulegroup_id, FND_API.g_miss_num, NULL, px_rulegroup_id)

106: WHERE l.installed_flag in ('I', 'B')
107: AND NOT EXISTS(
108: SELECT NULL
109: FROM AMS_IBA_PS_RULEGRPS_TL t
110: WHERE t.rulegroup_id = DECODE( px_rulegroup_id, FND_API.g_miss_num, NULL, px_rulegroup_id)
111: AND t.language = l.language_code
112: );
113:
114: END Insert_Row;

Line 151: rulegroup_id = DECODE( p_rulegroup_id, FND_API.g_miss_num, rulegroup_id, p_rulegroup_id),

147: IS
148: BEGIN
149: Update AMS_IBA_PS_RULEGRPS_B
150: SET
151: rulegroup_id = DECODE( p_rulegroup_id, FND_API.g_miss_num, rulegroup_id, p_rulegroup_id),
152: posting_id = DECODE( p_posting_id, FND_API.g_miss_num, posting_id, p_posting_id),
153: strategy_type = DECODE( p_strategy_type, FND_API.g_miss_char, NULL, p_strategy_type),
154: exec_priority = DECODE( p_exec_priority, FND_API.g_miss_num, exec_priority, p_exec_priority),
155: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

Line 152: posting_id = DECODE( p_posting_id, FND_API.g_miss_num, posting_id, p_posting_id),

148: BEGIN
149: Update AMS_IBA_PS_RULEGRPS_B
150: SET
151: rulegroup_id = DECODE( p_rulegroup_id, FND_API.g_miss_num, rulegroup_id, p_rulegroup_id),
152: posting_id = DECODE( p_posting_id, FND_API.g_miss_num, posting_id, p_posting_id),
153: strategy_type = DECODE( p_strategy_type, FND_API.g_miss_char, NULL, p_strategy_type),
154: exec_priority = DECODE( p_exec_priority, FND_API.g_miss_num, exec_priority, p_exec_priority),
155: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
156: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

Line 153: strategy_type = DECODE( p_strategy_type, FND_API.g_miss_char, NULL, p_strategy_type),

149: Update AMS_IBA_PS_RULEGRPS_B
150: SET
151: rulegroup_id = DECODE( p_rulegroup_id, FND_API.g_miss_num, rulegroup_id, p_rulegroup_id),
152: posting_id = DECODE( p_posting_id, FND_API.g_miss_num, posting_id, p_posting_id),
153: strategy_type = DECODE( p_strategy_type, FND_API.g_miss_char, NULL, p_strategy_type),
154: exec_priority = DECODE( p_exec_priority, FND_API.g_miss_num, exec_priority, p_exec_priority),
155: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
156: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
157: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

Line 154: exec_priority = DECODE( p_exec_priority, FND_API.g_miss_num, exec_priority, p_exec_priority),

150: SET
151: rulegroup_id = DECODE( p_rulegroup_id, FND_API.g_miss_num, rulegroup_id, p_rulegroup_id),
152: posting_id = DECODE( p_posting_id, FND_API.g_miss_num, posting_id, p_posting_id),
153: strategy_type = DECODE( p_strategy_type, FND_API.g_miss_char, NULL, p_strategy_type),
154: exec_priority = DECODE( p_exec_priority, FND_API.g_miss_num, exec_priority, p_exec_priority),
155: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
156: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
157: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
158: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),

Line 155: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

151: rulegroup_id = DECODE( p_rulegroup_id, FND_API.g_miss_num, rulegroup_id, p_rulegroup_id),
152: posting_id = DECODE( p_posting_id, FND_API.g_miss_num, posting_id, p_posting_id),
153: strategy_type = DECODE( p_strategy_type, FND_API.g_miss_char, NULL, p_strategy_type),
154: exec_priority = DECODE( p_exec_priority, FND_API.g_miss_num, exec_priority, p_exec_priority),
155: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
156: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
157: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
158: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
159: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

Line 156: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

152: posting_id = DECODE( p_posting_id, FND_API.g_miss_num, posting_id, p_posting_id),
153: strategy_type = DECODE( p_strategy_type, FND_API.g_miss_char, NULL, p_strategy_type),
154: exec_priority = DECODE( p_exec_priority, FND_API.g_miss_num, exec_priority, p_exec_priority),
155: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
156: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
157: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
158: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
159: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
160: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number)

Line 157: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

153: strategy_type = DECODE( p_strategy_type, FND_API.g_miss_char, NULL, p_strategy_type),
154: exec_priority = DECODE( p_exec_priority, FND_API.g_miss_num, exec_priority, p_exec_priority),
155: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
156: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
157: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
158: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
159: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
160: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number)
161: WHERE RULEGROUP_ID = p_RULEGROUP_ID

Line 158: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),

154: exec_priority = DECODE( p_exec_priority, FND_API.g_miss_num, exec_priority, p_exec_priority),
155: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
156: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
157: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
158: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
159: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
160: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number)
161: WHERE RULEGROUP_ID = p_RULEGROUP_ID
162: AND object_version_number = p_object_version_number;

Line 159: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

155: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
156: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
157: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
158: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
159: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
160: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number)
161: WHERE RULEGROUP_ID = p_RULEGROUP_ID
162: AND object_version_number = p_object_version_number;
163:

Line 160: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number)

156: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
157: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
158: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
159: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
160: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number)
161: WHERE RULEGROUP_ID = p_RULEGROUP_ID
162: AND object_version_number = p_object_version_number;
163:
164: IF (SQL%NOTFOUND) THEN

Line 165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

161: WHERE RULEGROUP_ID = p_RULEGROUP_ID
162: AND object_version_number = p_object_version_number;
163:
164: IF (SQL%NOTFOUND) THEN
165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
166: END IF;
167:
168: UPDATE ams_iba_ps_rulegrps_tl SET
169: rulegroup_name = decode( p_rule_name, FND_API.G_MISS_CHAR, rulegroup_name, p_rule_name),

Line 169: rulegroup_name = decode( p_rule_name, FND_API.G_MISS_CHAR, rulegroup_name, p_rule_name),

165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
166: END IF;
167:
168: UPDATE ams_iba_ps_rulegrps_tl SET
169: rulegroup_name = decode( p_rule_name, FND_API.G_MISS_CHAR, rulegroup_name, p_rule_name),
170: rulegroup_description = decode( p_rule_description, FND_API.G_MISS_CHAR, rulegroup_description, p_rule_description),
171: last_update_date = SYSDATE,
172: last_updated_by = FND_GLOBAL.user_id,
173: last_update_login = FND_GLOBAL.conc_login_id,

Line 170: rulegroup_description = decode( p_rule_description, FND_API.G_MISS_CHAR, rulegroup_description, p_rule_description),

166: END IF;
167:
168: UPDATE ams_iba_ps_rulegrps_tl SET
169: rulegroup_name = decode( p_rule_name, FND_API.G_MISS_CHAR, rulegroup_name, p_rule_name),
170: rulegroup_description = decode( p_rule_description, FND_API.G_MISS_CHAR, rulegroup_description, p_rule_description),
171: last_update_date = SYSDATE,
172: last_updated_by = FND_GLOBAL.user_id,
173: last_update_login = FND_GLOBAL.conc_login_id,
174: source_lang = USERENV('LANG')

Line 179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

175: WHERE rulegroup_id = p_rulegroup_id
176: AND USERENV('LANG') IN (language, source_lang);
177:
178: IF (SQL%NOTFOUND) THEN
179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
180: END IF;
181:
182: END Update_Row;
183:

Line 210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

206: DELETE FROM AMS_IBA_PS_RULEGRPS_B
207: WHERE RULEGROUP_ID = p_RULEGROUP_ID;
208:
209: If (SQL%NOTFOUND) then
210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
211: End If;
212:
213: DELETE FROM AMS_IBA_PS_RULEGRPS_TL
214: WHERE RULEGROUP_ID = P_RULEGROUP_ID;

Line 217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

213: DELETE FROM AMS_IBA_PS_RULEGRPS_TL
214: WHERE RULEGROUP_ID = P_RULEGROUP_ID;
215:
216: If (SQL%NOTFOUND) then
217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
218: End If;
219:
220: DELETE FROM AMS_IBA_PS_RULES
221: WHERE RULEGROUP_ID = P_RULEGROUP_ID;

Line 224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

220: DELETE FROM AMS_IBA_PS_RULES
221: WHERE RULEGROUP_ID = P_RULEGROUP_ID;
222:
223: If (SQL%NOTFOUND) then
224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
225: End If;
226:
227: DELETE FROM AMS_IBA_PS_RL_ST_PARAMS
228: WHERE RULEGROUP_ID = P_RULEGROUP_ID;