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.OKE_PRINT_FORM_PUB dependencies on FND_MSG_PUB

Line 180: FND_MSG_PUB.add_exc_msg

176: END LOOP;
177:
178: EXCEPTION
179: WHEN OTHERS THEN
180: FND_MSG_PUB.add_exc_msg
181: ( p_pkg_name => G_PKG_NAME
182: , p_procedure_name => 'CONVERT_VALUE_TO_ID' );
183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
184:

Line 255: FND_MSG_PUB.Add;

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
259: AND p_header_rec.Contract_Number IS NOT NULL ) THEN

Line 265: FND_MSG_PUB.Add;

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
269: --

Line 278: FND_MSG_PUB.Add;

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:
282: END IF;

Line 294: FND_MSG_PUB.Add;

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
298: --

Line 307: FND_MSG_PUB.Add;

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:
311: END IF;

Line 323: FND_MSG_PUB.Add;

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
327: --

Line 336: FND_MSG_PUB.Add;

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:
340: END IF;

Line 352: FND_MSG_PUB.Add;

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
356: AND p_header_rec.Status_Name IS NOT NULL ) THEN

Line 362: FND_MSG_PUB.Add;

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
366: --

Line 375: FND_MSG_PUB.Add;

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:
379: END IF;

Line 394: FND_MSG_PUB.Add;

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
398: --

Line 407: FND_MSG_PUB.Add;

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:
411: END IF;

Line 422: FND_MSG_PUB.Add;

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;
426:

Line 436: FND_MSG_PUB.Add;

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
440:

Line 447: FND_MSG_PUB.Add;

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:
451: END IF;

Line 461: FND_MSG_PUB.Add;

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:
465: ELSIF ( p_api_name = 'UPDATE_PRINT_FORM' ) THEN

Line 473: FND_MSG_PUB.Add;

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
477: AND p_header_rec.form_header_number IS NOT NULL ) THEN

Line 480: FND_MSG_PUB.Add;

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
484: OPEN pfhid;

Line 490: FND_MSG_PUB.Add;

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:
494: END IF;

Line 500: FND_MSG_PUB.add_exc_msg

496: END IF;
497:
498: EXCEPTION
499: WHEN OTHERS THEN
500: FND_MSG_PUB.add_exc_msg
501: ( p_pkg_name => G_PKG_NAME
502: , p_procedure_name => 'VALIDATE_DATA' );
503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
504:

Line 961: FND_MSG_PUB.add_exc_msg

957: x_return_status := FND_API.G_RET_STS_SUCCESS;
958:
959: EXCEPTION
960: WHEN OTHERS THEN
961: FND_MSG_PUB.add_exc_msg
962: ( p_pkg_name => G_PKG_NAME
963: , p_procedure_name => 'CREATE_FORM' );
964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
965:

Line 1308: FND_MSG_PUB.add_exc_msg

1304: x_return_status := FND_API.G_RET_STS_SUCCESS;
1305:
1306: EXCEPTION
1307: WHEN OTHERS THEN
1308: FND_MSG_PUB.add_exc_msg
1309: ( p_pkg_name => G_PKG_NAME
1310: , p_procedure_name => 'UPDATE_FORM' );
1311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1312:

Line 1380: FND_MSG_PUB.initialize;

1376: --
1377: -- Initialize the message table if requested.
1378: --
1379: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
1380: FND_MSG_PUB.initialize;
1381: END IF;
1382:
1383: --
1384: -- Set API return status to success

Line 1458: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1454: --
1455: -- Standard call to get message count and if count is 1, get message
1456: -- info
1457: --
1458: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1459: , p_data => x_msg_data );
1460:
1461: EXCEPTION
1462: WHEN FND_API.G_EXC_ERROR THEN

Line 1465: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1461: EXCEPTION
1462: WHEN FND_API.G_EXC_ERROR THEN
1463: ROLLBACK TO create_print_form_pub;
1464: x_return_status := FND_API.G_RET_STS_ERROR;
1465: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1466: , p_data => x_msg_data );
1467:
1468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1469: ROLLBACK TO create_print_form_pub;

Line 1471: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1467:
1468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1469: ROLLBACK TO create_print_form_pub;
1470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1471: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1472: , p_data => x_msg_data );
1473:
1474: WHEN OTHERS THEN
1475: ROLLBACK TO create_print_form_pub;

Line 1477: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1473:
1474: WHEN OTHERS THEN
1475: ROLLBACK TO create_print_form_pub;
1476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1477: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1478: FND_MSG_PUB.add_exc_msg
1479: ( p_pkg_name => G_PKG_NAME
1480: , p_procedure_name => l_api_name );
1481:

Line 1478: FND_MSG_PUB.add_exc_msg

1474: WHEN OTHERS THEN
1475: ROLLBACK TO create_print_form_pub;
1476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1477: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1478: FND_MSG_PUB.add_exc_msg
1479: ( p_pkg_name => G_PKG_NAME
1480: , p_procedure_name => l_api_name );
1481:
1482: END IF;

Line 1483: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1479: ( p_pkg_name => G_PKG_NAME
1480: , p_procedure_name => l_api_name );
1481:
1482: END IF;
1483: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1484: , p_data => x_msg_data );
1485:
1486: END create_print_form;
1487:

Line 1547: FND_MSG_PUB.initialize;

1543: --
1544: -- Initialize the message table if requested.
1545: --
1546: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
1547: FND_MSG_PUB.initialize;
1548: END IF;
1549:
1550: --
1551: -- Set API return status to success

Line 1624: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1620: --
1621: -- Standard call to get message count and if count is 1, get message
1622: -- info
1623: --
1624: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1625: , p_data => x_msg_data );
1626:
1627: EXCEPTION
1628: WHEN FND_API.G_EXC_ERROR THEN

Line 1631: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1627: EXCEPTION
1628: WHEN FND_API.G_EXC_ERROR THEN
1629: ROLLBACK TO update_print_form_pub;
1630: x_return_status := FND_API.G_RET_STS_ERROR;
1631: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1632: , p_data => x_msg_data );
1633:
1634: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1635: ROLLBACK TO update_print_form_pub;

Line 1637: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1633:
1634: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1635: ROLLBACK TO update_print_form_pub;
1636: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1637: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1638: , p_data => x_msg_data );
1639:
1640: WHEN OTHERS THEN
1641: ROLLBACK TO update_print_form_pub;

Line 1643: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1639:
1640: WHEN OTHERS THEN
1641: ROLLBACK TO update_print_form_pub;
1642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1643: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1644: FND_MSG_PUB.add_exc_msg
1645: ( p_pkg_name => G_PKG_NAME
1646: , p_procedure_name => l_api_name );
1647:

Line 1644: FND_MSG_PUB.add_exc_msg

1640: WHEN OTHERS THEN
1641: ROLLBACK TO update_print_form_pub;
1642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1643: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1644: FND_MSG_PUB.add_exc_msg
1645: ( p_pkg_name => G_PKG_NAME
1646: , p_procedure_name => l_api_name );
1647:
1648: END IF;

Line 1649: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1645: ( p_pkg_name => G_PKG_NAME
1646: , p_procedure_name => l_api_name );
1647:
1648: END IF;
1649: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1650: , p_data => x_msg_data );
1651:
1652: END update_print_form;
1653: