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:
890: DBMS_SQL.close_cursor (v_cursorid);
891:
892: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
893: THEN
894: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_RETURN_STATUS');
895: fnd_message.set_token (
896: 'P_PROCEDURE',
897: i.hook_package || '.' || i.hook_api
898: );
891:
892: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
893: THEN
894: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_RETURN_STATUS');
895: fnd_message.set_token (
896: 'P_PROCEDURE',
897: i.hook_package || '.' || i.hook_api
898: );
899: fnd_msg_pub.add;
904: END IF;
905:
906: IF x_return_status IS NULL
907: THEN
908: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_RETURN_STATUS');
909: fnd_msg_pub.add;
910: x_return_status := fnd_api.g_ret_sts_unexp_error;
911: RAISE fnd_api.g_exc_unexpected_error;
912: END IF;
916: THEN
917: x_return_status := fnd_api.g_ret_sts_unexp_error;
918: WHEN OTHERS
919: THEN
920: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
921: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
922: fnd_msg_pub.add;
923: x_return_status := fnd_api.g_ret_sts_unexp_error;
924: END;
917: x_return_status := fnd_api.g_ret_sts_unexp_error;
918: WHEN OTHERS
919: THEN
920: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
921: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
922: fnd_msg_pub.add;
923: x_return_status := fnd_api.g_ret_sts_unexp_error;
924: END;
925: End CSF_DEBRIEF_PUB;