DBA Data[Home] [Help]

APPS.JTF_IH_PUB dependencies on FND_MESSAGE

Line 95: FND_MESSAGE.SET_NAME('JTF','JTF_IH_API_INVALID_END_DATE');

91: -- jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_end_date_time, 'DD-MON-YYYY'),
92: -- 'end_date_time');
93: -- Enh# 2999069
94: --jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_end_date_time, 'DD-MON-RRRR HH:MI:SS'),'end_date_time');
95: FND_MESSAGE.SET_NAME('JTF','JTF_IH_API_INVALID_END_DATE');
96: FND_MESSAGE.SET_TOKEN('END_DATE', to_char(p_end_date_time, 'DD-MON-RRRR HH:MI:SS'));
97: FND_MESSAGE.SET_TOKEN('START_DATE', to_char(p_start_date_time, 'DD-MON-RRRR HH:MI:SS'));
98: FND_MSG_PUB.Add;
99: END IF;

Line 96: FND_MESSAGE.SET_TOKEN('END_DATE', to_char(p_end_date_time, 'DD-MON-RRRR HH:MI:SS'));

92: -- 'end_date_time');
93: -- Enh# 2999069
94: --jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_end_date_time, 'DD-MON-RRRR HH:MI:SS'),'end_date_time');
95: FND_MESSAGE.SET_NAME('JTF','JTF_IH_API_INVALID_END_DATE');
96: FND_MESSAGE.SET_TOKEN('END_DATE', to_char(p_end_date_time, 'DD-MON-RRRR HH:MI:SS'));
97: FND_MESSAGE.SET_TOKEN('START_DATE', to_char(p_start_date_time, 'DD-MON-RRRR HH:MI:SS'));
98: FND_MSG_PUB.Add;
99: END IF;
100: END Validate_StartEnd_Date;

Line 97: FND_MESSAGE.SET_TOKEN('START_DATE', to_char(p_start_date_time, 'DD-MON-RRRR HH:MI:SS'));

93: -- Enh# 2999069
94: --jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_end_date_time, 'DD-MON-RRRR HH:MI:SS'),'end_date_time');
95: FND_MESSAGE.SET_NAME('JTF','JTF_IH_API_INVALID_END_DATE');
96: FND_MESSAGE.SET_TOKEN('END_DATE', to_char(p_end_date_time, 'DD-MON-RRRR HH:MI:SS'));
97: FND_MESSAGE.SET_TOKEN('START_DATE', to_char(p_start_date_time, 'DD-MON-RRRR HH:MI:SS'));
98: FND_MSG_PUB.Add;
99: END IF;
100: END Validate_StartEnd_Date;
101:

Line 188: FND_MESSAGE.SET_NAME('JTF','JTF_IH_NO_PARTY_RELATIONSHIP');

184: RETURN;
185: EXCEPTION
186: WHEN NO_DATA_FOUND THEN
187: x_return_status := fnd_api.g_ret_sts_error;
188: FND_MESSAGE.SET_NAME('JTF','JTF_IH_NO_PARTY_RELATIONSHIP');
189: FND_MESSAGE.SET_TOKEN('PARTY', p_Party_ID);
190: FND_MSG_PUB.Add;
191: RETURN;
192: END;

Line 189: FND_MESSAGE.SET_TOKEN('PARTY', p_Party_ID);

185: EXCEPTION
186: WHEN NO_DATA_FOUND THEN
187: x_return_status := fnd_api.g_ret_sts_error;
188: FND_MESSAGE.SET_NAME('JTF','JTF_IH_NO_PARTY_RELATIONSHIP');
189: FND_MESSAGE.SET_TOKEN('PARTY', p_Party_ID);
190: FND_MSG_PUB.Add;
191: RETURN;
192: END;
193:

Line 221: FND_MESSAGE.SET_NAME('JTF','JTF_IH_NO_PARTY');

217: -- return an error.
218: --
219: IF s_Party_Type IS NULL THEN
220: x_return_status := fnd_api.g_ret_sts_error;
221: FND_MESSAGE.SET_NAME('JTF','JTF_IH_NO_PARTY');
222: FND_MESSAGE.SET_TOKEN('PARTY', p_int_val_rec.party_id);
223: FND_MSG_PUB.Add;
224: RETURN;
225: END IF;

Line 222: FND_MESSAGE.SET_TOKEN('PARTY', p_int_val_rec.party_id);

218: --
219: IF s_Party_Type IS NULL THEN
220: x_return_status := fnd_api.g_ret_sts_error;
221: FND_MESSAGE.SET_NAME('JTF','JTF_IH_NO_PARTY');
222: FND_MESSAGE.SET_TOKEN('PARTY', p_int_val_rec.party_id);
223: FND_MSG_PUB.Add;
224: RETURN;
225: END IF;
226:

Line 273: FND_MESSAGE.SET_NAME('JTF','JTF_IH_WRONG_PARTY_REL');

269: p_int_val_rec.contact_rel_party_id := NULL;
270: p_int_val_rec.contact_party_id := NULL;
271: ELSE
272: x_return_status := fnd_api.g_ret_sts_error;
273: FND_MESSAGE.SET_NAME('JTF','JTF_IH_WRONG_PARTY_REL');
274: FND_MESSAGE.SET_TOKEN('PARTY_ID', p_int_val_rec.party_id);
275: FND_MSG_PUB.Add;
276: RETURN;
277: END IF;

Line 274: FND_MESSAGE.SET_TOKEN('PARTY_ID', p_int_val_rec.party_id);

270: p_int_val_rec.contact_party_id := NULL;
271: ELSE
272: x_return_status := fnd_api.g_ret_sts_error;
273: FND_MESSAGE.SET_NAME('JTF','JTF_IH_WRONG_PARTY_REL');
274: FND_MESSAGE.SET_TOKEN('PARTY_ID', p_int_val_rec.party_id);
275: FND_MSG_PUB.Add;
276: RETURN;
277: END IF;
278: END IF;

Line 305: FND_MESSAGE.SET_NAME('JTF','JTF_IH_REQ_ITEM_MSG');

301: -- Reject invalid combinations
302: --
303: IF p_int_val_rec.primary_party_id IS NULL THEN
304: x_return_status := fnd_api.g_ret_sts_error;
305: FND_MESSAGE.SET_NAME('JTF','JTF_IH_REQ_ITEM_MSG');
306: FND_MESSAGE.SET_TOKEN('FIELDNAME', 'Primary_Party_ID');
307: FND_MSG_PUB.Add;
308: RETURN;
309: END IF;

Line 306: FND_MESSAGE.SET_TOKEN('FIELDNAME', 'Primary_Party_ID');

302: --
303: IF p_int_val_rec.primary_party_id IS NULL THEN
304: x_return_status := fnd_api.g_ret_sts_error;
305: FND_MESSAGE.SET_NAME('JTF','JTF_IH_REQ_ITEM_MSG');
306: FND_MESSAGE.SET_TOKEN('FIELDNAME', 'Primary_Party_ID');
307: FND_MSG_PUB.Add;
308: RETURN;
309: END IF;
310:

Line 317: FND_MESSAGE.SET_NAME('JTF','JTF_IH_INVALID_PARTY_COMB');

313: IF p_int_val_rec.Contact_Party_ID IS NULL AND
314: p_int_val_rec.Primary_Party_Id IS NOT NULL
315: AND p_int_val_rec.Contact_Rel_Party_ID IS NOT NULL THEN
316: x_return_status := fnd_api.g_ret_sts_error;
317: FND_MESSAGE.SET_NAME('JTF','JTF_IH_INVALID_PARTY_COMB');
318: FND_MSG_PUB.Add;
319: RETURN;
320: END IF;
321:

Line 331: FND_MESSAGE.SET_NAME('JTF','JTF_IH_NO_PARTY');

327: s_Party_Type := Get_Party_Type(p_int_val_rec.party_id);
328:
329: IF s_Party_Type IS NULL THEN
330: x_return_status := fnd_api.g_ret_sts_error;
331: FND_MESSAGE.SET_NAME('JTF','JTF_IH_NO_PARTY');
332: FND_MESSAGE.SET_TOKEN('PARTY', p_int_val_rec.party_id);
333: FND_MSG_PUB.Add;
334: RETURN;
335: END IF;

Line 332: FND_MESSAGE.SET_TOKEN('PARTY', p_int_val_rec.party_id);

328:
329: IF s_Party_Type IS NULL THEN
330: x_return_status := fnd_api.g_ret_sts_error;
331: FND_MESSAGE.SET_NAME('JTF','JTF_IH_NO_PARTY');
332: FND_MESSAGE.SET_TOKEN('PARTY', p_int_val_rec.party_id);
333: FND_MSG_PUB.Add;
334: RETURN;
335: END IF;
336:

Line 339: FND_MESSAGE.SET_NAME('JTF','JTF_IH_PARTIES_NOT_EQUAL');

335: END IF;
336:
337: IF s_Party_Type <> 'ORGANIZATION' THEN
338: x_return_status := fnd_api.g_ret_sts_error;
339: FND_MESSAGE.SET_NAME('JTF','JTF_IH_PARTIES_NOT_EQUAL');
340: FND_MESSAGE.SET_TOKEN('PARTY_ID', p_int_val_rec.party_id);
341: FND_MSG_PUB.Add;
342: RETURN;
343: END IF;

Line 340: FND_MESSAGE.SET_TOKEN('PARTY_ID', p_int_val_rec.party_id);

336:
337: IF s_Party_Type <> 'ORGANIZATION' THEN
338: x_return_status := fnd_api.g_ret_sts_error;
339: FND_MESSAGE.SET_NAME('JTF','JTF_IH_PARTIES_NOT_EQUAL');
340: FND_MESSAGE.SET_TOKEN('PARTY_ID', p_int_val_rec.party_id);
341: FND_MSG_PUB.Add;
342: RETURN;
343: END IF;
344: END IF;

Line 351: FND_MESSAGE.SET_NAME('JTF','JTF_IH_INVALID_PERSON_PARTY');

347: IF ((p_int_val_rec.contact_party_id IS NOT NULL) AND (p_int_val_rec.primary_party_id IS NOT NULL)) THEN
348: IF((Is_ContactPartyEmployeeOfOrg(p_int_val_rec.contact_party_id) = FALSE)
349: AND (p_int_val_rec.primary_party_id <> p_int_val_rec.contact_party_id)) THEN
350: x_return_status := fnd_api.g_ret_sts_error;
351: FND_MESSAGE.SET_NAME('JTF','JTF_IH_INVALID_PERSON_PARTY');
352: FND_MESSAGE.SET_TOKEN('P_PARTY_ID', p_int_val_rec.party_id);
353: FND_MESSAGE.SET_TOKEN('C_PARTY_ID', p_int_val_rec.contact_party_id);
354: FND_MSG_PUB.Add;
355: RETURN;

Line 352: FND_MESSAGE.SET_TOKEN('P_PARTY_ID', p_int_val_rec.party_id);

348: IF((Is_ContactPartyEmployeeOfOrg(p_int_val_rec.contact_party_id) = FALSE)
349: AND (p_int_val_rec.primary_party_id <> p_int_val_rec.contact_party_id)) THEN
350: x_return_status := fnd_api.g_ret_sts_error;
351: FND_MESSAGE.SET_NAME('JTF','JTF_IH_INVALID_PERSON_PARTY');
352: FND_MESSAGE.SET_TOKEN('P_PARTY_ID', p_int_val_rec.party_id);
353: FND_MESSAGE.SET_TOKEN('C_PARTY_ID', p_int_val_rec.contact_party_id);
354: FND_MSG_PUB.Add;
355: RETURN;
356: END IF;

Line 353: FND_MESSAGE.SET_TOKEN('C_PARTY_ID', p_int_val_rec.contact_party_id);

349: AND (p_int_val_rec.primary_party_id <> p_int_val_rec.contact_party_id)) THEN
350: x_return_status := fnd_api.g_ret_sts_error;
351: FND_MESSAGE.SET_NAME('JTF','JTF_IH_INVALID_PERSON_PARTY');
352: FND_MESSAGE.SET_TOKEN('P_PARTY_ID', p_int_val_rec.party_id);
353: FND_MESSAGE.SET_TOKEN('C_PARTY_ID', p_int_val_rec.contact_party_id);
354: FND_MSG_PUB.Add;
355: RETURN;
356: END IF;
357:

Line 363: FND_MESSAGE.SET_NAME('JTF','JTF_IH_NO_PARTY');

359: --
360: s_Party_Type := Get_Party_Type(p_int_val_rec.contact_party_id);
361: IF s_Party_Type IS NULL THEN
362: x_return_status := fnd_api.g_ret_sts_error;
363: FND_MESSAGE.SET_NAME('JTF','JTF_IH_NO_PARTY');
364: FND_MESSAGE.SET_TOKEN('PARTY', p_int_val_rec.contact_party_id);
365: FND_MSG_PUB.Add;
366: RETURN;
367: END IF;

Line 364: FND_MESSAGE.SET_TOKEN('PARTY', p_int_val_rec.contact_party_id);

360: s_Party_Type := Get_Party_Type(p_int_val_rec.contact_party_id);
361: IF s_Party_Type IS NULL THEN
362: x_return_status := fnd_api.g_ret_sts_error;
363: FND_MESSAGE.SET_NAME('JTF','JTF_IH_NO_PARTY');
364: FND_MESSAGE.SET_TOKEN('PARTY', p_int_val_rec.contact_party_id);
365: FND_MSG_PUB.Add;
366: RETURN;
367: END IF;
368: IF s_Party_Type <> 'PERSON' THEN

Line 370: FND_MESSAGE.SET_NAME('JTF','JTF_IH_NON_PERSON_CONTACT');

366: RETURN;
367: END IF;
368: IF s_Party_Type <> 'PERSON' THEN
369: x_return_status := fnd_api.g_ret_sts_error;
370: FND_MESSAGE.SET_NAME('JTF','JTF_IH_NON_PERSON_CONTACT');
371: FND_MESSAGE.SET_TOKEN('C_PARTY_ID', p_int_val_rec.contact_party_id);
372: FND_MSG_PUB.Add;
373: RETURN;
374: END IF;

Line 371: FND_MESSAGE.SET_TOKEN('C_PARTY_ID', p_int_val_rec.contact_party_id);

367: END IF;
368: IF s_Party_Type <> 'PERSON' THEN
369: x_return_status := fnd_api.g_ret_sts_error;
370: FND_MESSAGE.SET_NAME('JTF','JTF_IH_NON_PERSON_CONTACT');
371: FND_MESSAGE.SET_TOKEN('C_PARTY_ID', p_int_val_rec.contact_party_id);
372: FND_MSG_PUB.Add;
373: RETURN;
374: END IF;
375: x_return_status := fnd_api.g_ret_sts_success;

Line 383: FND_MESSAGE.SET_NAME('JTF','JTF_IH_NO_PARTY');

379: IF p_int_val_rec.contact_party_id IS NULL THEN -- Case# 3, 5
380: s_Party_Type := Get_Party_Type(p_int_val_rec.primary_party_id);
381: IF s_Party_Type IS NULL THEN
382: x_return_status := fnd_api.g_ret_sts_error;
383: FND_MESSAGE.SET_NAME('JTF','JTF_IH_NO_PARTY');
384: FND_MESSAGE.SET_TOKEN('PARTY', p_int_val_rec.primary_party_id);
385: FND_MSG_PUB.Add;
386: RETURN;
387: END IF;

Line 384: FND_MESSAGE.SET_TOKEN('PARTY', p_int_val_rec.primary_party_id);

380: s_Party_Type := Get_Party_Type(p_int_val_rec.primary_party_id);
381: IF s_Party_Type IS NULL THEN
382: x_return_status := fnd_api.g_ret_sts_error;
383: FND_MESSAGE.SET_NAME('JTF','JTF_IH_NO_PARTY');
384: FND_MESSAGE.SET_TOKEN('PARTY', p_int_val_rec.primary_party_id);
385: FND_MSG_PUB.Add;
386: RETURN;
387: END IF;
388: IF s_Party_Type <> 'ORGANIZATION' THEN

Line 390: FND_MESSAGE.SET_NAME('JTF','JTF_IH_INVALID_PERSON_PARTY');

386: RETURN;
387: END IF;
388: IF s_Party_Type <> 'ORGANIZATION' THEN
389: x_return_status := fnd_api.g_ret_sts_error;
390: FND_MESSAGE.SET_NAME('JTF','JTF_IH_INVALID_PERSON_PARTY');
391: FND_MESSAGE.SET_TOKEN('P_PARTY_ID', p_int_val_rec.primary_party_id);
392: FND_MESSAGE.SET_TOKEN('C_PARTY_ID', p_int_val_rec.contact_party_id);
393: FND_MSG_PUB.Add;
394: RETURN;

Line 391: FND_MESSAGE.SET_TOKEN('P_PARTY_ID', p_int_val_rec.primary_party_id);

387: END IF;
388: IF s_Party_Type <> 'ORGANIZATION' THEN
389: x_return_status := fnd_api.g_ret_sts_error;
390: FND_MESSAGE.SET_NAME('JTF','JTF_IH_INVALID_PERSON_PARTY');
391: FND_MESSAGE.SET_TOKEN('P_PARTY_ID', p_int_val_rec.primary_party_id);
392: FND_MESSAGE.SET_TOKEN('C_PARTY_ID', p_int_val_rec.contact_party_id);
393: FND_MSG_PUB.Add;
394: RETURN;
395: END IF;

Line 392: FND_MESSAGE.SET_TOKEN('C_PARTY_ID', p_int_val_rec.contact_party_id);

388: IF s_Party_Type <> 'ORGANIZATION' THEN
389: x_return_status := fnd_api.g_ret_sts_error;
390: FND_MESSAGE.SET_NAME('JTF','JTF_IH_INVALID_PERSON_PARTY');
391: FND_MESSAGE.SET_TOKEN('P_PARTY_ID', p_int_val_rec.primary_party_id);
392: FND_MESSAGE.SET_TOKEN('C_PARTY_ID', p_int_val_rec.contact_party_id);
393: FND_MSG_PUB.Add;
394: RETURN;
395: END IF;
396: x_return_status := fnd_api.g_ret_sts_success;

Line 421: FND_MESSAGE.SET_NAME('JTF','JTF_IH_NON_PERSON_CONTACT');

417: IF p_int_val_rec.contact_party_id = n_Object_ID THEN
418: -- The Contact is the object in the relationship
419: IF s_Object_Type <> 'PERSON' THEN
420: x_return_status := fnd_api.g_ret_sts_error;
421: FND_MESSAGE.SET_NAME('JTF','JTF_IH_NON_PERSON_CONTACT');
422: FND_MESSAGE.SET_TOKEN('C_PARTY_ID', p_int_val_rec.contact_party_id);
423: FND_MSG_PUB.Add;
424: RETURN;
425: END IF;

Line 422: FND_MESSAGE.SET_TOKEN('C_PARTY_ID', p_int_val_rec.contact_party_id);

418: -- The Contact is the object in the relationship
419: IF s_Object_Type <> 'PERSON' THEN
420: x_return_status := fnd_api.g_ret_sts_error;
421: FND_MESSAGE.SET_NAME('JTF','JTF_IH_NON_PERSON_CONTACT');
422: FND_MESSAGE.SET_TOKEN('C_PARTY_ID', p_int_val_rec.contact_party_id);
423: FND_MSG_PUB.Add;
424: RETURN;
425: END IF;
426:

Line 436: FND_MESSAGE.SET_NAME('JTF','JTF_IH_INVALID_PRIMARY_ID');

432: RETURN;
433: ELSE
434: -- The primary is not a PERSON or an ORGANIZATION
435: x_return_status := fnd_api.g_ret_sts_error;
436: FND_MESSAGE.SET_NAME('JTF','JTF_IH_INVALID_PRIMARY_ID');
437: FND_MESSAGE.SET_TOKEN('P_PARTY_ID', p_int_val_rec.primary_party_id);
438: FND_MSG_PUB.Add;
439: RETURN;
440: END IF;

Line 437: FND_MESSAGE.SET_TOKEN('P_PARTY_ID', p_int_val_rec.primary_party_id);

433: ELSE
434: -- The primary is not a PERSON or an ORGANIZATION
435: x_return_status := fnd_api.g_ret_sts_error;
436: FND_MESSAGE.SET_NAME('JTF','JTF_IH_INVALID_PRIMARY_ID');
437: FND_MESSAGE.SET_TOKEN('P_PARTY_ID', p_int_val_rec.primary_party_id);
438: FND_MSG_PUB.Add;
439: RETURN;
440: END IF;
441: ELSE

Line 444: FND_MESSAGE.SET_NAME('JTF','JTF_IH_PRIMARY_IS_NOT_REL');

440: END IF;
441: ELSE
442: -- The primary_Id is not part of the relationship
443: x_return_status := fnd_api.g_ret_sts_error;
444: FND_MESSAGE.SET_NAME('JTF','JTF_IH_PRIMARY_IS_NOT_REL');
445: FND_MESSAGE.SET_TOKEN('P_PARTY_ID', p_int_val_rec.primary_party_id);
446: FND_MESSAGE.SET_TOKEN('R_PARTY_ID', p_int_val_rec.contact_rel_party_id);
447: FND_MSG_PUB.Add;
448: RETURN;

Line 445: FND_MESSAGE.SET_TOKEN('P_PARTY_ID', p_int_val_rec.primary_party_id);

441: ELSE
442: -- The primary_Id is not part of the relationship
443: x_return_status := fnd_api.g_ret_sts_error;
444: FND_MESSAGE.SET_NAME('JTF','JTF_IH_PRIMARY_IS_NOT_REL');
445: FND_MESSAGE.SET_TOKEN('P_PARTY_ID', p_int_val_rec.primary_party_id);
446: FND_MESSAGE.SET_TOKEN('R_PARTY_ID', p_int_val_rec.contact_rel_party_id);
447: FND_MSG_PUB.Add;
448: RETURN;
449: END IF;

Line 446: FND_MESSAGE.SET_TOKEN('R_PARTY_ID', p_int_val_rec.contact_rel_party_id);

442: -- The primary_Id is not part of the relationship
443: x_return_status := fnd_api.g_ret_sts_error;
444: FND_MESSAGE.SET_NAME('JTF','JTF_IH_PRIMARY_IS_NOT_REL');
445: FND_MESSAGE.SET_TOKEN('P_PARTY_ID', p_int_val_rec.primary_party_id);
446: FND_MESSAGE.SET_TOKEN('R_PARTY_ID', p_int_val_rec.contact_rel_party_id);
447: FND_MSG_PUB.Add;
448: RETURN;
449: END IF;
450: ELSE

Line 457: FND_MESSAGE.SET_NAME('JTF','JTF_IH_NON_PERSON_CONTACT');

453: -- The contact_party_id is subject in the relationship
454: IF s_Subject_Type <> 'PERSON' THEN
455: -- The contact is not a Person
456: x_return_status := fnd_api.g_ret_sts_error;
457: FND_MESSAGE.SET_NAME('JTF','JTF_IH_NON_PERSON_CONTACT');
458: FND_MESSAGE.SET_TOKEN('C_PARTY_ID', p_int_val_rec.contact_party_id);
459: FND_MSG_PUB.Add;
460: RETURN;
461: END IF;

Line 458: FND_MESSAGE.SET_TOKEN('C_PARTY_ID', p_int_val_rec.contact_party_id);

454: IF s_Subject_Type <> 'PERSON' THEN
455: -- The contact is not a Person
456: x_return_status := fnd_api.g_ret_sts_error;
457: FND_MESSAGE.SET_NAME('JTF','JTF_IH_NON_PERSON_CONTACT');
458: FND_MESSAGE.SET_TOKEN('C_PARTY_ID', p_int_val_rec.contact_party_id);
459: FND_MSG_PUB.Add;
460: RETURN;
461: END IF;
462: IF p_int_val_rec.primary_party_id = n_Object_id THEN

Line 469: FND_MESSAGE.SET_NAME('JTF','JTF_IH_INVALID_PRIMARY_ID');

465: RETURN;
466: ELSE
467: -- The Primary is not part of the relatioship
468: x_return_status := fnd_api.g_ret_sts_error;
469: FND_MESSAGE.SET_NAME('JTF','JTF_IH_INVALID_PRIMARY_ID');
470: FND_MESSAGE.SET_TOKEN('P_PARTY_ID', p_int_val_rec.primary_party_id);
471: FND_MSG_PUB.Add;
472: RETURN;
473: END IF;

Line 470: FND_MESSAGE.SET_TOKEN('P_PARTY_ID', p_int_val_rec.primary_party_id);

466: ELSE
467: -- The Primary is not part of the relatioship
468: x_return_status := fnd_api.g_ret_sts_error;
469: FND_MESSAGE.SET_NAME('JTF','JTF_IH_INVALID_PRIMARY_ID');
470: FND_MESSAGE.SET_TOKEN('P_PARTY_ID', p_int_val_rec.primary_party_id);
471: FND_MSG_PUB.Add;
472: RETURN;
473: END IF;
474: ELSE

Line 477: FND_MESSAGE.SET_NAME('JTF','JTF_IH_PRIMARY_IS_NOT_REL');

473: END IF;
474: ELSE
475: -- The Primary is not part of the relatioship
476: x_return_status := fnd_api.g_ret_sts_error;
477: FND_MESSAGE.SET_NAME('JTF','JTF_IH_PRIMARY_IS_NOT_REL');
478: FND_MESSAGE.SET_TOKEN('P_PARTY_ID', p_int_val_rec.primary_party_id);
479: FND_MESSAGE.SET_TOKEN('R_PARTY_ID', p_int_val_rec.contact_rel_party_id);
480: FND_MSG_PUB.Add;
481: RETURN;

Line 478: FND_MESSAGE.SET_TOKEN('P_PARTY_ID', p_int_val_rec.primary_party_id);

474: ELSE
475: -- The Primary is not part of the relatioship
476: x_return_status := fnd_api.g_ret_sts_error;
477: FND_MESSAGE.SET_NAME('JTF','JTF_IH_PRIMARY_IS_NOT_REL');
478: FND_MESSAGE.SET_TOKEN('P_PARTY_ID', p_int_val_rec.primary_party_id);
479: FND_MESSAGE.SET_TOKEN('R_PARTY_ID', p_int_val_rec.contact_rel_party_id);
480: FND_MSG_PUB.Add;
481: RETURN;
482: END IF;

Line 479: FND_MESSAGE.SET_TOKEN('R_PARTY_ID', p_int_val_rec.contact_rel_party_id);

475: -- The Primary is not part of the relatioship
476: x_return_status := fnd_api.g_ret_sts_error;
477: FND_MESSAGE.SET_NAME('JTF','JTF_IH_PRIMARY_IS_NOT_REL');
478: FND_MESSAGE.SET_TOKEN('P_PARTY_ID', p_int_val_rec.primary_party_id);
479: FND_MESSAGE.SET_TOKEN('R_PARTY_ID', p_int_val_rec.contact_rel_party_id);
480: FND_MSG_PUB.Add;
481: RETURN;
482: END IF;
483: ELSE

Line 486: FND_MESSAGE.SET_NAME('JTF','JTF_IH_CONTACT_IS_NOT_REL');

482: END IF;
483: ELSE
484: -- The Contact is not part of the relationship
485: x_return_status := fnd_api.g_ret_sts_error;
486: FND_MESSAGE.SET_NAME('JTF','JTF_IH_CONTACT_IS_NOT_REL');
487: FND_MESSAGE.SET_TOKEN('C_PARTY_ID', p_int_val_rec.contact_party_id);
488: FND_MESSAGE.SET_TOKEN('R_PARTY_ID', p_int_val_rec.contact_rel_party_id);
489: FND_MSG_PUB.Add;
490: RETURN;

Line 487: FND_MESSAGE.SET_TOKEN('C_PARTY_ID', p_int_val_rec.contact_party_id);

483: ELSE
484: -- The Contact is not part of the relationship
485: x_return_status := fnd_api.g_ret_sts_error;
486: FND_MESSAGE.SET_NAME('JTF','JTF_IH_CONTACT_IS_NOT_REL');
487: FND_MESSAGE.SET_TOKEN('C_PARTY_ID', p_int_val_rec.contact_party_id);
488: FND_MESSAGE.SET_TOKEN('R_PARTY_ID', p_int_val_rec.contact_rel_party_id);
489: FND_MSG_PUB.Add;
490: RETURN;
491: END IF;

Line 488: FND_MESSAGE.SET_TOKEN('R_PARTY_ID', p_int_val_rec.contact_rel_party_id);

484: -- The Contact is not part of the relationship
485: x_return_status := fnd_api.g_ret_sts_error;
486: FND_MESSAGE.SET_NAME('JTF','JTF_IH_CONTACT_IS_NOT_REL');
487: FND_MESSAGE.SET_TOKEN('C_PARTY_ID', p_int_val_rec.contact_party_id);
488: FND_MESSAGE.SET_TOKEN('R_PARTY_ID', p_int_val_rec.contact_rel_party_id);
489: FND_MSG_PUB.Add;
490: RETURN;
491: END IF;
492: END IF;

Line 539: FND_MESSAGE.SET_NAME('JTF','JTF_IH_NO_PARTY');

535: -- Check, that Party_Id in the Interaction_Res has passed values.
536: --
537: IF p_int_val_rec.party_id IS NULL THEN
538: x_return_status := fnd_api.g_ret_sts_error;
539: FND_MESSAGE.SET_NAME('JTF','JTF_IH_NO_PARTY');
540: FND_MESSAGE.SET_TOKEN('PARTY', p_int_val_rec.party_id);
541: FND_MSG_PUB.Add;
542: RETURN;
543: ELSE

Line 540: FND_MESSAGE.SET_TOKEN('PARTY', p_int_val_rec.party_id);

536: --
537: IF p_int_val_rec.party_id IS NULL THEN
538: x_return_status := fnd_api.g_ret_sts_error;
539: FND_MESSAGE.SET_NAME('JTF','JTF_IH_NO_PARTY');
540: FND_MESSAGE.SET_TOKEN('PARTY', p_int_val_rec.party_id);
541: FND_MSG_PUB.Add;
542: RETURN;
543: ELSE
544:

Line 1510: FND_MESSAGE.SET_NAME('JTF','JTF_IH_API_INVALID_ACTIV_ID');

1506: BEGIN
1507: SELECT activity_id INTO n_Return FROM jtf_ih_activities WHERE activity_id = n_activity_id;
1508: -- If value is presend then return an error (invalid activity_id)
1509: IF n_Return IS NOT NULL THEN
1510: FND_MESSAGE.SET_NAME('JTF','JTF_IH_API_INVALID_ACTIV_ID');
1511: fnd_message.set_token('VALUE', n_activity_id);
1512: FND_MSG_PUB.Add;
1513: RETURN -1;
1514: END IF;

Line 1511: fnd_message.set_token('VALUE', n_activity_id);

1507: SELECT activity_id INTO n_Return FROM jtf_ih_activities WHERE activity_id = n_activity_id;
1508: -- If value is presend then return an error (invalid activity_id)
1509: IF n_Return IS NOT NULL THEN
1510: FND_MESSAGE.SET_NAME('JTF','JTF_IH_API_INVALID_ACTIV_ID');
1511: fnd_message.set_token('VALUE', n_activity_id);
1512: FND_MSG_PUB.Add;
1513: RETURN -1;
1514: END IF;
1515: EXCEPTION

Line 1553: FND_MESSAGE.SET_NAME('JTF','JTF_IH_API_INVALID_INTER_ID');

1549: BEGIN
1550: SELECT interaction_id INTO n_Return FROM jtf_ih_interactions WHERE interaction_id = n_interaction_id;
1551: -- If value is presend then return an error (invalid activity_id)
1552: IF n_Return IS NOT NULL THEN
1553: FND_MESSAGE.SET_NAME('JTF','JTF_IH_API_INVALID_INTER_ID');
1554: FND_MESSAGE.SET_TOKEN('VALUE', n_interaction_id);
1555: FND_MSG_PUB.Add;
1556: RETURN -1;
1557: END IF;

Line 1554: FND_MESSAGE.SET_TOKEN('VALUE', n_interaction_id);

1550: SELECT interaction_id INTO n_Return FROM jtf_ih_interactions WHERE interaction_id = n_interaction_id;
1551: -- If value is presend then return an error (invalid activity_id)
1552: IF n_Return IS NOT NULL THEN
1553: FND_MESSAGE.SET_NAME('JTF','JTF_IH_API_INVALID_INTER_ID');
1554: FND_MESSAGE.SET_TOKEN('VALUE', n_interaction_id);
1555: FND_MSG_PUB.Add;
1556: RETURN -1;
1557: END IF;
1558: EXCEPTION

Line 1595: FND_MESSAGE.SET_NAME('JTF','JTF_IH_API_INVALID_MEDIA_ID');

1591: BEGIN
1592: SELECT media_id INTO n_Return FROM jtf_ih_media_items WHERE media_id = n_media_id;
1593: -- If value is presend then return an error (invalid activity_id)
1594: IF n_Return IS NOT NULL THEN
1595: FND_MESSAGE.SET_NAME('JTF','JTF_IH_API_INVALID_MEDIA_ID');
1596: FND_MESSAGE.SET_TOKEN('VALUE', n_media_id);
1597: FND_MSG_PUB.Add;
1598: RETURN -1;
1599: END IF;

Line 1596: FND_MESSAGE.SET_TOKEN('VALUE', n_media_id);

1592: SELECT media_id INTO n_Return FROM jtf_ih_media_items WHERE media_id = n_media_id;
1593: -- If value is presend then return an error (invalid activity_id)
1594: IF n_Return IS NOT NULL THEN
1595: FND_MESSAGE.SET_NAME('JTF','JTF_IH_API_INVALID_MEDIA_ID');
1596: FND_MESSAGE.SET_TOKEN('VALUE', n_media_id);
1597: FND_MSG_PUB.Add;
1598: RETURN -1;
1599: END IF;
1600: EXCEPTION

Line 1638: FND_MESSAGE.SET_NAME('JTF','JTF_IH_API_INVALID_MILCS_ID');

1634: BEGIN
1635: SELECT milcs_id INTO n_Return FROM jtf_ih_media_item_lc_segs WHERE milcs_id = n_milcs_id;
1636: -- If value is presend then return an error (invalid activity_id)
1637: IF n_Return IS NOT NULL THEN
1638: FND_MESSAGE.SET_NAME('JTF','JTF_IH_API_INVALID_MILCS_ID');
1639: FND_MESSAGE.SET_TOKEN('VALUE', n_milcs_id);
1640: FND_MSG_PUB.Add;
1641: RETURN -1;
1642: END IF;

Line 1639: FND_MESSAGE.SET_TOKEN('VALUE', n_milcs_id);

1635: SELECT milcs_id INTO n_Return FROM jtf_ih_media_item_lc_segs WHERE milcs_id = n_milcs_id;
1636: -- If value is presend then return an error (invalid activity_id)
1637: IF n_Return IS NOT NULL THEN
1638: FND_MESSAGE.SET_NAME('JTF','JTF_IH_API_INVALID_MILCS_ID');
1639: FND_MESSAGE.SET_TOKEN('VALUE', n_milcs_id);
1640: FND_MSG_PUB.Add;
1641: RETURN -1;
1642: END IF;
1643: EXCEPTION

Line 2802: FND_MESSAGE.SET_NAME('JTF','JTF_IH_NO_ACTIVITY');

2798: --l_interaction_rec := p_interaction_rec;
2799: --l_activities_hk := p_activities;
2800:
2801: IF l_activities.count = 0 THEN
2802: FND_MESSAGE.SET_NAME('JTF','JTF_IH_NO_ACTIVITY');
2803: FND_MSG_PUB.Add;
2804: RAISE FND_API.G_EXC_ERROR;
2805: END IF;
2806:

Line 4588: fnd_message.set_name('JTF', 'JTF_IH_INT_UPDATE_NOT_ALLOW');

4584: --x_return_status := fnd_api.g_ret_sts_error;
4585: --jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name, to_char(p_Interaction_rec.interaction_id),'Active set to N for interaction');
4586: --Bug# 4477761 new error msg
4587: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
4588: fnd_message.set_name('JTF', 'JTF_IH_INT_UPDATE_NOT_ALLOW');
4589: fnd_message.set_token('INT_ID', to_char(p_Interaction_rec.interaction_id));
4590: fnd_msg_pub.add;
4591: END IF;
4592: RAISE fnd_api.g_exc_error;

Line 4589: fnd_message.set_token('INT_ID', to_char(p_Interaction_rec.interaction_id));

4585: --jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name, to_char(p_Interaction_rec.interaction_id),'Active set to N for interaction');
4586: --Bug# 4477761 new error msg
4587: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
4588: fnd_message.set_name('JTF', 'JTF_IH_INT_UPDATE_NOT_ALLOW');
4589: fnd_message.set_token('INT_ID', to_char(p_Interaction_rec.interaction_id));
4590: fnd_msg_pub.add;
4591: END IF;
4592: RAISE fnd_api.g_exc_error;
4593: END IF;

Line 5433: fnd_message.set_name('JTF', 'JTF_IH_NO_ACTIVITY');

5429: -- Bug# 1937894
5430: -- jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name, to_char(p_interaction_rec.interaction_id),
5431: -- 'activity_id');
5432: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
5433: fnd_message.set_name('JTF', 'JTF_IH_NO_ACTIVITY');
5434: fnd_message.set_token('API_NAME', l_api_name);
5435: fnd_msg_pub.add;
5436: END IF;
5437:

Line 5434: fnd_message.set_token('API_NAME', l_api_name);

5430: -- jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name, to_char(p_interaction_rec.interaction_id),
5431: -- 'activity_id');
5432: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
5433: fnd_message.set_name('JTF', 'JTF_IH_NO_ACTIVITY');
5434: fnd_message.set_token('API_NAME', l_api_name);
5435: fnd_msg_pub.add;
5436: END IF;
5437:
5438: -- DBMS_OUTPUT.PUT_LINE('Yes');

Line 6820: fnd_message.set_name('JTF', 'JTF_IH_ACT_UPDATE_NOT_ALLOW');

6816: --jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(p_activity_rec.activity_id),
6817: -- 'activity is currently set to N');
6818: --Bug# 4477761 new error msg
6819: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
6820: fnd_message.set_name('JTF', 'JTF_IH_ACT_UPDATE_NOT_ALLOW');
6821: fnd_message.set_token('ACT_ID', to_char(p_activity_rec.activity_id));
6822: fnd_msg_pub.add;
6823: END IF;
6824: RAISE fnd_api.g_exc_error ;

Line 6821: fnd_message.set_token('ACT_ID', to_char(p_activity_rec.activity_id));

6817: -- 'activity is currently set to N');
6818: --Bug# 4477761 new error msg
6819: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
6820: fnd_message.set_name('JTF', 'JTF_IH_ACT_UPDATE_NOT_ALLOW');
6821: fnd_message.set_token('ACT_ID', to_char(p_activity_rec.activity_id));
6822: fnd_msg_pub.add;
6823: END IF;
6824: RAISE fnd_api.g_exc_error ;
6825: END IF;

Line 7297: FND_MESSAGE.SET_NAME('JTF','JTF_IH_NO_DURATION_END_DATE');

7293: -- "Not specified required End_Date_Time and Duration"
7294: -- Bug# 2656975
7295: IF ((p_duration IS NULL) OR (p_duration = fnd_api.g_miss_num)) AND
7296: ((p_end_date_time IS NULL) OR (p_end_date_time = fnd_api.g_miss_date )) THEN
7297: FND_MESSAGE.SET_NAME('JTF','JTF_IH_NO_DURATION_END_DATE');
7298: FND_MSG_PUB.Add;
7299: RAISE fnd_api.g_exc_error;
7300: END IF;
7301: