125: p_interest_type <> FND_API.G_MISS_CHAR)
126: THEN
127: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
128: THEN
129: FND_MESSAGE.Set_Name ('CSF', 'API_ATTRIBUTE_IGNORED');
130: FND_MESSAGE.Set_Token ('COLUMN', 'INTEREST_TYPE', FALSE);
131: FND_MSG_PUB.Add;
132: END IF;
133: END IF;
126: THEN
127: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
128: THEN
129: FND_MESSAGE.Set_Name ('CSF', 'API_ATTRIBUTE_IGNORED');
130: FND_MESSAGE.Set_Token ('COLUMN', 'INTEREST_TYPE', FALSE);
131: FND_MSG_PUB.Add;
132: END IF;
133: END IF;
134:
142: IF (l_interest_type_id IS NULL)
143: THEN
144: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
145: THEN
146: FND_MESSAGE.Set_Name ('CSF', 'API_ATTRIBUTE_CONVERSION_ERROR');
147: FND_MESSAGE.Set_Token ('COLUMN', 'INTEREST_TYPE', FALSE);
148: FND_MESSAGE.Set_Token('VALUE', p_interest_type, FALSE);
149: FND_MSG_PUB.Add;
150: END IF;
143: THEN
144: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
145: THEN
146: FND_MESSAGE.Set_Name ('CSF', 'API_ATTRIBUTE_CONVERSION_ERROR');
147: FND_MESSAGE.Set_Token ('COLUMN', 'INTEREST_TYPE', FALSE);
148: FND_MESSAGE.Set_Token('VALUE', p_interest_type, FALSE);
149: FND_MSG_PUB.Add;
150: END IF;
151:
144: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
145: THEN
146: FND_MESSAGE.Set_Name ('CSF', 'API_ATTRIBUTE_CONVERSION_ERROR');
147: FND_MESSAGE.Set_Token ('COLUMN', 'INTEREST_TYPE', FALSE);
148: FND_MESSAGE.Set_Token('VALUE', p_interest_type, FALSE);
149: FND_MSG_PUB.Add;
150: END IF;
151:
152: raise FND_API.G_EXC_ERROR;
159: -- If no interest type (value or id) exists, then this row is invalid
160: --
161: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
162: THEN
163: FND_MESSAGE.Set_Name ('CSF','API_MISSING_ID');
164: FND_MESSAGE.Set_Token ('COLUMN', 'INTEREST_TYPE', FALSE);
165: FND_MSG_PUB.Add;
166: END IF;
167:
160: --
161: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
162: THEN
163: FND_MESSAGE.Set_Name ('CSF','API_MISSING_ID');
164: FND_MESSAGE.Set_Token ('COLUMN', 'INTEREST_TYPE', FALSE);
165: FND_MSG_PUB.Add;
166: END IF;
167:
168: raise FND_API.G_EXC_ERROR;
180: p_primary_interest_code <> FND_API.G_MISS_CHAR)
181: THEN
182: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
183: THEN
184: FND_MESSAGE.Set_Name ('CSF','API_ATTRIBUTE_IGNORED');
185: FND_MESSAGE.Set_Token ('COLUMN', 'PRIMARY_INTEREST_CODE', FALSE);
186: FND_MSG_PUB.Add;
187: END IF;
188: END IF;
181: THEN
182: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
183: THEN
184: FND_MESSAGE.Set_Name ('CSF','API_ATTRIBUTE_IGNORED');
185: FND_MESSAGE.Set_Token ('COLUMN', 'PRIMARY_INTEREST_CODE', FALSE);
186: FND_MSG_PUB.Add;
187: END IF;
188: END IF;
189:
198: IF (l_interest_code_id IS NULL)
199: THEN
200: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
201: THEN
202: FND_MESSAGE.Set_Name ('CSF', 'API_ATTRIBUTE_CONVERSION_ERROR');
203: FND_MESSAGE.Set_Token ('COLUMN', 'PRIMARY_INTEREST_CODE', FALSE);
204: FND_MESSAGE.Set_Token('VALUE', p_primary_interest_code, FALSE);
205: FND_MSG_PUB.Add;
206: END IF;
199: THEN
200: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
201: THEN
202: FND_MESSAGE.Set_Name ('CSF', 'API_ATTRIBUTE_CONVERSION_ERROR');
203: FND_MESSAGE.Set_Token ('COLUMN', 'PRIMARY_INTEREST_CODE', FALSE);
204: FND_MESSAGE.Set_Token('VALUE', p_primary_interest_code, FALSE);
205: FND_MSG_PUB.Add;
206: END IF;
207:
200: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
201: THEN
202: FND_MESSAGE.Set_Name ('CSF', 'API_ATTRIBUTE_CONVERSION_ERROR');
203: FND_MESSAGE.Set_Token ('COLUMN', 'PRIMARY_INTEREST_CODE', FALSE);
204: FND_MESSAGE.Set_Token('VALUE', p_primary_interest_code, FALSE);
205: FND_MSG_PUB.Add;
206: END IF;
207:
208: p_return_status := FND_API.G_RET_STS_ERROR;
224: p_secondary_interest_code <> FND_API.G_MISS_CHAR)
225: THEN
226: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
227: THEN
228: FND_MESSAGE.Set_Name ('CSF', 'API_ATTRIBUTE_IGNORED');
229: FND_MESSAGE.Set_Token ('COLUMN', 'SECONDARY_INTEREST_CODE', FALSE);
230: FND_MSG_PUB.Add;
231: END IF;
232: END IF;
225: THEN
226: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
227: THEN
228: FND_MESSAGE.Set_Name ('CSF', 'API_ATTRIBUTE_IGNORED');
229: FND_MESSAGE.Set_Token ('COLUMN', 'SECONDARY_INTEREST_CODE', FALSE);
230: FND_MSG_PUB.Add;
231: END IF;
232: END IF;
233:
242: IF (l_secondary_interest_code_id IS NULL)
243: THEN
244: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
245: THEN
246: FND_MESSAGE.Set_Name ('CSF', 'API_ATTRIBUTE_CONVERSION_ERROR');
247: FND_MESSAGE.Set_Token ('COLUMN', 'SECONDARY_INTEREST_CODE', FALSE);
248: FND_MESSAGE.Set_Token('VALUE', p_secondary_interest_code, FALSE);
249: FND_MSG_PUB.Add;
250: END IF;
243: THEN
244: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
245: THEN
246: FND_MESSAGE.Set_Name ('CSF', 'API_ATTRIBUTE_CONVERSION_ERROR');
247: FND_MESSAGE.Set_Token ('COLUMN', 'SECONDARY_INTEREST_CODE', FALSE);
248: FND_MESSAGE.Set_Token('VALUE', p_secondary_interest_code, FALSE);
249: FND_MSG_PUB.Add;
250: END IF;
251: p_return_status := FND_API.G_RET_STS_ERROR;
244: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
245: THEN
246: FND_MESSAGE.Set_Name ('CSF', 'API_ATTRIBUTE_CONVERSION_ERROR');
247: FND_MESSAGE.Set_Token ('COLUMN', 'SECONDARY_INTEREST_CODE', FALSE);
248: FND_MESSAGE.Set_Token('VALUE', p_secondary_interest_code, FALSE);
249: FND_MSG_PUB.Add;
250: END IF;
251: p_return_status := FND_API.G_RET_STS_ERROR;
252:
1090: DBMS_SQL.close_cursor (v_cursorid);
1091:
1092: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1093: THEN
1094: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_RETURN_STATUS');
1095: fnd_message.set_token (
1096: 'P_PROCEDURE',
1097: i.hook_package || '.' || i.hook_api
1098: );
1091:
1092: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1093: THEN
1094: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_RETURN_STATUS');
1095: fnd_message.set_token (
1096: 'P_PROCEDURE',
1097: i.hook_package || '.' || i.hook_api
1098: );
1099: fnd_msg_pub.add;
1104: END IF;
1105:
1106: IF x_return_status IS NULL
1107: THEN
1108: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_RETURN_STATUS');
1109: fnd_msg_pub.add;
1110: x_return_status := fnd_api.g_ret_sts_unexp_error;
1111: RAISE fnd_api.g_exc_unexpected_error;
1112: END IF;
1116: THEN
1117: x_return_status := fnd_api.g_ret_sts_unexp_error;
1118: WHEN OTHERS
1119: THEN
1120: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1121: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
1122: fnd_msg_pub.add;
1123: x_return_status := fnd_api.g_ret_sts_unexp_error;
1124: END;
1117: x_return_status := fnd_api.g_ret_sts_unexp_error;
1118: WHEN OTHERS
1119: THEN
1120: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1121: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
1122: fnd_msg_pub.add;
1123: x_return_status := fnd_api.g_ret_sts_unexp_error;
1124: END;
1125: