DBA Data[Home] [Help]

APPS.OKE_PRINT_FORM_PUB dependencies on FND_MESSAGE

Line 253: FND_MESSAGE.Set_Name('OKE','OKE_API_MISSING_VALUE');

249: AND p_header_rec.Contract_Number IS NULL ) THEN
250: --
251: -- Make sure either ID or number is provided
252: --
253: FND_MESSAGE.Set_Name('OKE','OKE_API_MISSING_VALUE');
254: FND_MESSAGE.Set_Token('VALUE' , 'CONTRACT_HEADER_ID');
255: FND_MSG_PUB.Add;
256: x_return_status := FND_API.G_RET_STS_ERROR;
257:

Line 254: FND_MESSAGE.Set_Token('VALUE' , 'CONTRACT_HEADER_ID');

250: --
251: -- Make sure either ID or number is provided
252: --
253: FND_MESSAGE.Set_Name('OKE','OKE_API_MISSING_VALUE');
254: FND_MESSAGE.Set_Token('VALUE' , 'CONTRACT_HEADER_ID');
255: FND_MSG_PUB.Add;
256: x_return_status := FND_API.G_RET_STS_ERROR;
257:
258: ELSIF ( p_header_rec.Contract_Header_ID IS NULL

Line 263: FND_MESSAGE.Set_Name('OKE','OKE_API_INVALID_VALUE');

259: AND p_header_rec.Contract_Number IS NOT NULL ) THEN
260: --
261: -- Check to see if number is valid
262: --
263: FND_MESSAGE.Set_Name('OKE','OKE_API_INVALID_VALUE');
264: FND_MESSAGE.Set_Token('VALUE' , 'CONTRACT_NUMBER');
265: FND_MSG_PUB.Add;
266: x_return_status := FND_API.G_RET_STS_ERROR;
267:

Line 264: FND_MESSAGE.Set_Token('VALUE' , 'CONTRACT_NUMBER');

260: --
261: -- Check to see if number is valid
262: --
263: FND_MESSAGE.Set_Name('OKE','OKE_API_INVALID_VALUE');
264: FND_MESSAGE.Set_Token('VALUE' , 'CONTRACT_NUMBER');
265: FND_MSG_PUB.Add;
266: x_return_status := FND_API.G_RET_STS_ERROR;
267:
268: ELSIF ( p_header_rec.Contract_Header_ID IS NOT NULL ) THEN

Line 276: FND_MESSAGE.Set_Name('OKE','OKE_API_INVALID_VALUE');

272: OPEN kh;
273: FETCH kh INTO l_row_exists;
274: CLOSE kh;
275: IF ( l_row_exists = 0 ) THEN
276: FND_MESSAGE.Set_Name('OKE','OKE_API_INVALID_VALUE');
277: FND_MESSAGE.Set_Token('VALUE' , 'CONTRACT_HEADER_ID');
278: FND_MSG_PUB.Add;
279: x_return_status := FND_API.G_RET_STS_ERROR;
280: END IF;

Line 277: FND_MESSAGE.Set_Token('VALUE' , 'CONTRACT_HEADER_ID');

273: FETCH kh INTO l_row_exists;
274: CLOSE kh;
275: IF ( l_row_exists = 0 ) THEN
276: FND_MESSAGE.Set_Name('OKE','OKE_API_INVALID_VALUE');
277: FND_MESSAGE.Set_Token('VALUE' , 'CONTRACT_HEADER_ID');
278: FND_MSG_PUB.Add;
279: x_return_status := FND_API.G_RET_STS_ERROR;
280: END IF;
281:

Line 292: FND_MESSAGE.Set_Name('OKE','OKE_API_INVALID_VALUE');

288: AND p_header_rec.Contract_Line_Number IS NOT NULL ) THEN
289: --
290: -- Check to see if number is valid
291: --
292: FND_MESSAGE.Set_Name('OKE','OKE_API_INVALID_VALUE');
293: FND_MESSAGE.Set_Token('VALUE' , 'CONTRACT_LINE_NUMBER');
294: FND_MSG_PUB.Add;
295: x_return_status := FND_API.G_RET_STS_ERROR;
296:

Line 293: FND_MESSAGE.Set_Token('VALUE' , 'CONTRACT_LINE_NUMBER');

289: --
290: -- Check to see if number is valid
291: --
292: FND_MESSAGE.Set_Name('OKE','OKE_API_INVALID_VALUE');
293: FND_MESSAGE.Set_Token('VALUE' , 'CONTRACT_LINE_NUMBER');
294: FND_MSG_PUB.Add;
295: x_return_status := FND_API.G_RET_STS_ERROR;
296:
297: ELSIF ( p_header_rec.Contract_Line_ID IS NOT NULL ) THEN

Line 305: FND_MESSAGE.Set_Name('OKE','OKE_API_INVALID_VALUE');

301: OPEN kl;
302: FETCH kl INTO l_row_exists;
303: CLOSE kl;
304: IF ( l_row_exists = 0 ) THEN
305: FND_MESSAGE.Set_Name('OKE','OKE_API_INVALID_VALUE');
306: FND_MESSAGE.Set_Token('VALUE' , 'CONTRACT_LINE_ID');
307: FND_MSG_PUB.Add;
308: x_return_status := FND_API.G_RET_STS_ERROR;
309: END IF;

Line 306: FND_MESSAGE.Set_Token('VALUE' , 'CONTRACT_LINE_ID');

302: FETCH kl INTO l_row_exists;
303: CLOSE kl;
304: IF ( l_row_exists = 0 ) THEN
305: FND_MESSAGE.Set_Name('OKE','OKE_API_INVALID_VALUE');
306: FND_MESSAGE.Set_Token('VALUE' , 'CONTRACT_LINE_ID');
307: FND_MSG_PUB.Add;
308: x_return_status := FND_API.G_RET_STS_ERROR;
309: END IF;
310:

Line 321: FND_MESSAGE.Set_Name('OKE','OKE_API_INVALID_VALUE');

317: AND p_header_rec.Deliverable_Number IS NOT NULL ) THEN
318: --
319: -- Check to see if deliverable number is valid
320: --
321: FND_MESSAGE.Set_Name('OKE','OKE_API_INVALID_VALUE');
322: FND_MESSAGE.Set_Token('VALUE' , 'DELIVERABLE_NUMBER');
323: FND_MSG_PUB.Add;
324: x_return_status := FND_API.G_RET_STS_ERROR;
325:

Line 322: FND_MESSAGE.Set_Token('VALUE' , 'DELIVERABLE_NUMBER');

318: --
319: -- Check to see if deliverable number is valid
320: --
321: FND_MESSAGE.Set_Name('OKE','OKE_API_INVALID_VALUE');
322: FND_MESSAGE.Set_Token('VALUE' , 'DELIVERABLE_NUMBER');
323: FND_MSG_PUB.Add;
324: x_return_status := FND_API.G_RET_STS_ERROR;
325:
326: ELSIF ( p_header_rec.Deliverable_ID IS NOT NULL ) THEN

Line 334: FND_MESSAGE.Set_Name('OKE','OKE_API_INVALID_VALUE');

330: OPEN kd;
331: FETCH kd INTO l_row_exists;
332: CLOSE kd;
333: IF ( l_row_exists = 0 ) THEN
334: FND_MESSAGE.Set_Name('OKE','OKE_API_INVALID_VALUE');
335: FND_MESSAGE.Set_Token('VALUE' , 'DELIVERABLE_ID');
336: FND_MSG_PUB.Add;
337: x_return_status := FND_API.G_RET_STS_ERROR;
338: END IF;

Line 335: FND_MESSAGE.Set_Token('VALUE' , 'DELIVERABLE_ID');

331: FETCH kd INTO l_row_exists;
332: CLOSE kd;
333: IF ( l_row_exists = 0 ) THEN
334: FND_MESSAGE.Set_Name('OKE','OKE_API_INVALID_VALUE');
335: FND_MESSAGE.Set_Token('VALUE' , 'DELIVERABLE_ID');
336: FND_MSG_PUB.Add;
337: x_return_status := FND_API.G_RET_STS_ERROR;
338: END IF;
339:

Line 350: FND_MESSAGE.Set_Name('OKE','OKE_API_MISSING_VALUE');

346: AND p_header_rec.Status_Name IS NULL ) THEN
347: --
348: -- Make sure either Code or Name is provided
349: --
350: FND_MESSAGE.Set_Name('OKE','OKE_API_MISSING_VALUE');
351: FND_MESSAGE.Set_Token('VALUE' , 'STATUS_CODE');
352: FND_MSG_PUB.Add;
353: x_return_status := FND_API.G_RET_STS_ERROR;
354:

Line 351: FND_MESSAGE.Set_Token('VALUE' , 'STATUS_CODE');

347: --
348: -- Make sure either Code or Name is provided
349: --
350: FND_MESSAGE.Set_Name('OKE','OKE_API_MISSING_VALUE');
351: FND_MESSAGE.Set_Token('VALUE' , 'STATUS_CODE');
352: FND_MSG_PUB.Add;
353: x_return_status := FND_API.G_RET_STS_ERROR;
354:
355: ELSIF ( p_header_rec.Status_Code IS NULL

Line 360: FND_MESSAGE.Set_Name('OKE','OKE_API_INVALID_VALUE');

356: AND p_header_rec.Status_Name IS NOT NULL ) THEN
357: --
358: -- Check to see if name is valid
359: --
360: FND_MESSAGE.Set_Name('OKE','OKE_API_INVALID_VALUE');
361: FND_MESSAGE.Set_Token('VALUE' , 'STATUS_NAME');
362: FND_MSG_PUB.Add;
363: x_return_status := FND_API.G_RET_STS_ERROR;
364:

Line 361: FND_MESSAGE.Set_Token('VALUE' , 'STATUS_NAME');

357: --
358: -- Check to see if name is valid
359: --
360: FND_MESSAGE.Set_Name('OKE','OKE_API_INVALID_VALUE');
361: FND_MESSAGE.Set_Token('VALUE' , 'STATUS_NAME');
362: FND_MSG_PUB.Add;
363: x_return_status := FND_API.G_RET_STS_ERROR;
364:
365: ELSIF ( p_header_rec.Status_Code IS NOT NULL ) THEN

Line 373: FND_MESSAGE.Set_Name('OKE','OKE_API_INVALID_VALUE');

369: OPEN sts;
370: FETCH sts INTO l_row_exists;
371: CLOSE sts;
372: IF ( l_row_exists = 0 ) THEN
373: FND_MESSAGE.Set_Name('OKE','OKE_API_INVALID_VALUE');
374: FND_MESSAGE.Set_Token('VALUE' , 'STATUS_CODE');
375: FND_MSG_PUB.Add;
376: x_return_status := FND_API.G_RET_STS_ERROR;
377: END IF;

Line 374: FND_MESSAGE.Set_Token('VALUE' , 'STATUS_CODE');

370: FETCH sts INTO l_row_exists;
371: CLOSE sts;
372: IF ( l_row_exists = 0 ) THEN
373: FND_MESSAGE.Set_Name('OKE','OKE_API_INVALID_VALUE');
374: FND_MESSAGE.Set_Token('VALUE' , 'STATUS_CODE');
375: FND_MSG_PUB.Add;
376: x_return_status := FND_API.G_RET_STS_ERROR;
377: END IF;
378:

Line 392: FND_MESSAGE.Set_Name('OKE','OKE_API_MISSING_VALUE');

388: IF ( p_header_rec.Print_Form_Code IS NULL ) THEN
389: --
390: -- Make sure either Code or Name is provided
391: --
392: FND_MESSAGE.Set_Name('OKE','OKE_API_MISSING_VALUE');
393: FND_MESSAGE.Set_Token('VALUE' , 'PRINT_FORM_CODE');
394: FND_MSG_PUB.Add;
395: x_return_status := FND_API.G_RET_STS_ERROR;
396:

Line 393: FND_MESSAGE.Set_Token('VALUE' , 'PRINT_FORM_CODE');

389: --
390: -- Make sure either Code or Name is provided
391: --
392: FND_MESSAGE.Set_Name('OKE','OKE_API_MISSING_VALUE');
393: FND_MESSAGE.Set_Token('VALUE' , 'PRINT_FORM_CODE');
394: FND_MSG_PUB.Add;
395: x_return_status := FND_API.G_RET_STS_ERROR;
396:
397: ELSIF ( p_header_rec.Print_Form_Code IS NOT NULL ) THEN

Line 405: FND_MESSAGE.Set_Name('OKE','OKE_API_INVALID_VALUE');

401: OPEN pf;
402: FETCH pf INTO l_row_exists;
403: CLOSE pf;
404: IF ( l_row_exists = 0 ) THEN
405: FND_MESSAGE.Set_Name('OKE','OKE_API_INVALID_VALUE');
406: FND_MESSAGE.Set_Token('VALUE' , 'PRINT_FORM_CODE');
407: FND_MSG_PUB.Add;
408: x_return_status := FND_API.G_RET_STS_ERROR;
409: END IF;

Line 406: FND_MESSAGE.Set_Token('VALUE' , 'PRINT_FORM_CODE');

402: FETCH pf INTO l_row_exists;
403: CLOSE pf;
404: IF ( l_row_exists = 0 ) THEN
405: FND_MESSAGE.Set_Name('OKE','OKE_API_INVALID_VALUE');
406: FND_MESSAGE.Set_Token('VALUE' , 'PRINT_FORM_CODE');
407: FND_MSG_PUB.Add;
408: x_return_status := FND_API.G_RET_STS_ERROR;
409: END IF;
410:

Line 420: FND_MESSAGE.Set_Name('OKE','OKE_API_MISSING_VALUE');

416: IF ( p_header_rec.Form_Date IS NULL ) THEN
417: --
418: -- Make sure Form date is provided
419: --
420: FND_MESSAGE.Set_Name('OKE','OKE_API_MISSING_VALUE');
421: FND_MESSAGE.Set_Token('VALUE' , 'FORM_DATE');
422: FND_MSG_PUB.Add;
423: x_return_status := FND_API.G_RET_STS_ERROR;
424:

Line 421: FND_MESSAGE.Set_Token('VALUE' , 'FORM_DATE');

417: --
418: -- Make sure Form date is provided
419: --
420: FND_MESSAGE.Set_Name('OKE','OKE_API_MISSING_VALUE');
421: FND_MESSAGE.Set_Token('VALUE' , 'FORM_DATE');
422: FND_MSG_PUB.Add;
423: x_return_status := FND_API.G_RET_STS_ERROR;
424:
425: END IF;

Line 434: FND_MESSAGE.Set_Name('OKE','OKE_API_MISSING_VALUE');

430: IF ( p_header_rec.Form_Header_Number IS NULL ) THEN
431: --
432: -- Make sure Form Header Number is provided
433: --
434: FND_MESSAGE.Set_Name('OKE','OKE_API_MISSING_VALUE');
435: FND_MESSAGE.Set_Token('VALUE' , 'FORM_DATE');
436: FND_MSG_PUB.Add;
437: x_return_status := FND_API.G_RET_STS_ERROR;
438:

Line 435: FND_MESSAGE.Set_Token('VALUE' , 'FORM_DATE');

431: --
432: -- Make sure Form Header Number is provided
433: --
434: FND_MESSAGE.Set_Name('OKE','OKE_API_MISSING_VALUE');
435: FND_MESSAGE.Set_Token('VALUE' , 'FORM_DATE');
436: FND_MSG_PUB.Add;
437: x_return_status := FND_API.G_RET_STS_ERROR;
438:
439: ELSE

Line 445: FND_MESSAGE.Set_Name('OKE','OKE_API_DUPLICATE_VALUE');

441: OPEN pfhnum;
442: FETCH pfhnum INTO l_row_exists;
443: CLOSE pfhnum;
444: IF ( l_row_exists > 0 ) THEN
445: FND_MESSAGE.Set_Name('OKE','OKE_API_DUPLICATE_VALUE');
446: FND_MESSAGE.Set_Token('VALUE' , 'FORM_HEADER_NUMBER');
447: FND_MSG_PUB.Add;
448: x_return_status := FND_API.G_RET_STS_ERROR;
449: END IF;

Line 446: FND_MESSAGE.Set_Token('VALUE' , 'FORM_HEADER_NUMBER');

442: FETCH pfhnum INTO l_row_exists;
443: CLOSE pfhnum;
444: IF ( l_row_exists > 0 ) THEN
445: FND_MESSAGE.Set_Name('OKE','OKE_API_DUPLICATE_VALUE');
446: FND_MESSAGE.Set_Token('VALUE' , 'FORM_HEADER_NUMBER');
447: FND_MSG_PUB.Add;
448: x_return_status := FND_API.G_RET_STS_ERROR;
449: END IF;
450:

Line 460: FND_MESSAGE.Set_Name('OKE','OKE_FORM_INVALID_FOR_CONTRACT');

456: OPEN kpf;
457: FETCH kpf INTO l_row_exists;
458: CLOSE kpf;
459: IF ( l_row_exists = 0 ) THEN
460: FND_MESSAGE.Set_Name('OKE','OKE_FORM_INVALID_FOR_CONTRACT');
461: FND_MSG_PUB.Add;
462: x_return_status := FND_API.G_RET_STS_ERROR;
463: END IF;
464:

Line 471: FND_MESSAGE.Set_Name('OKE','OKE_API_MISSING_VALUE');

467: -- Make sure an existing instance is specified
468: --
469: IF ( p_header_rec.form_header_id IS NULL
470: AND p_header_rec.form_header_number IS NULL ) THEN
471: FND_MESSAGE.Set_Name('OKE','OKE_API_MISSING_VALUE');
472: FND_MESSAGE.Set_Token('VALUE','FORM_HEADER_NUMBER');
473: FND_MSG_PUB.Add;
474: x_return_status := FND_API.G_RET_STS_ERROR;
475:

Line 472: FND_MESSAGE.Set_Token('VALUE','FORM_HEADER_NUMBER');

468: --
469: IF ( p_header_rec.form_header_id IS NULL
470: AND p_header_rec.form_header_number IS NULL ) THEN
471: FND_MESSAGE.Set_Name('OKE','OKE_API_MISSING_VALUE');
472: FND_MESSAGE.Set_Token('VALUE','FORM_HEADER_NUMBER');
473: FND_MSG_PUB.Add;
474: x_return_status := FND_API.G_RET_STS_ERROR;
475:
476: ELSIF ( p_header_rec.form_header_id IS NULL

Line 478: FND_MESSAGE.Set_Name('OKE','OKE_API_INVALID_VALUE');

474: x_return_status := FND_API.G_RET_STS_ERROR;
475:
476: ELSIF ( p_header_rec.form_header_id IS NULL
477: AND p_header_rec.form_header_number IS NOT NULL ) THEN
478: FND_MESSAGE.Set_Name('OKE','OKE_API_INVALID_VALUE');
479: FND_MESSAGE.Set_Token('VALUE','FORM_HEADER_NUMBER');
480: FND_MSG_PUB.Add;
481: x_return_status := FND_API.G_RET_STS_ERROR;
482:

Line 479: FND_MESSAGE.Set_Token('VALUE','FORM_HEADER_NUMBER');

475:
476: ELSIF ( p_header_rec.form_header_id IS NULL
477: AND p_header_rec.form_header_number IS NOT NULL ) THEN
478: FND_MESSAGE.Set_Name('OKE','OKE_API_INVALID_VALUE');
479: FND_MESSAGE.Set_Token('VALUE','FORM_HEADER_NUMBER');
480: FND_MSG_PUB.Add;
481: x_return_status := FND_API.G_RET_STS_ERROR;
482:
483: ELSE

Line 488: FND_MESSAGE.Set_Name('OKE','OKE_API_INVALID_VALUE');

484: OPEN pfhid;
485: FETCH pfhid INTO l_row_exists;
486: CLOSE pfhid;
487: IF ( l_row_exists = 0 ) THEN
488: FND_MESSAGE.Set_Name('OKE','OKE_API_INVALID_VALUE');
489: FND_MESSAGE.Set_Token('VALUE','FORM_HEADER_ID');
490: FND_MSG_PUB.Add;
491: x_return_status := FND_API.G_RET_STS_ERROR;
492: END IF;

Line 489: FND_MESSAGE.Set_Token('VALUE','FORM_HEADER_ID');

485: FETCH pfhid INTO l_row_exists;
486: CLOSE pfhid;
487: IF ( l_row_exists = 0 ) THEN
488: FND_MESSAGE.Set_Name('OKE','OKE_API_INVALID_VALUE');
489: FND_MESSAGE.Set_Token('VALUE','FORM_HEADER_ID');
490: FND_MSG_PUB.Add;
491: x_return_status := FND_API.G_RET_STS_ERROR;
492: END IF;
493: