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

Line 205: FND_MSG_PUB.add;

201: -- throw error "Please set up the profile value for AHL : Default WorkorderType".
202: IF l_DEFAULT_WORKORDER_TYPE IS NULL
203: THEN
204: FND_MESSAGE.set_name('AHL','AHL_PRD_NO_WORKORDER_TYPE');
205: FND_MSG_PUB.add;
206: RAISE FND_API.G_EXC_ERROR;
207: END IF;
208:
209: IF (p_visit_task_id IS NULL AND p_master_workorder_flag = 'Y' )

Line 220: FND_MSG_PUB.add;

216: FETCH get_ue_id_csr INTO l_ue_id;
217: IF (get_ue_id_csr%NOTFOUND) THEN
218: CLOSE get_ue_id_csr;
219: FND_MESSAGE.set_name('AHL','AHL_PRD_VISIT_TASK_NULL');
220: FND_MSG_PUB.add;
221: RAISE FND_API.G_EXC_ERROR;
222: END IF;
223: CLOSE get_ue_id_csr;
224:

Line 978: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );

974:
975: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
976: IF ( G_DEBUG = 'Y' ) THEN
977: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
978: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
979: END IF;
980:
981: RAISE FND_API.G_EXC_ERROR;
982: ELSE

Line 1009: FND_MSG_PUB.count_and_get

1005:
1006: WHEN FND_API.G_EXC_ERROR THEN
1007: ROLLBACK TO create_eam_workorder_PVT;
1008: x_return_status := FND_API.G_RET_STS_ERROR;
1009: FND_MSG_PUB.count_and_get
1010: (
1011: p_encoded => FND_API.G_FALSE,
1012: p_count => x_msg_count,
1013: p_data => x_msg_data

Line 1023: FND_MSG_PUB.count_and_get

1019:
1020: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1021: ROLLBACK TO create_eam_workorder_PVT;
1022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1023: FND_MSG_PUB.count_and_get
1024: (
1025: p_encoded => FND_API.G_FALSE,
1026: p_count => x_msg_count,
1027: p_data => x_msg_data

Line 1037: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

1033:
1034: WHEN OTHERS THEN
1035: ROLLBACK TO create_eam_workorder_PVT;
1036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1037: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1038: THEN
1039: FND_MSG_PUB.add_exc_msg
1040: (
1041: p_pkg_name => G_PKG_NAME,

Line 1039: FND_MSG_PUB.add_exc_msg

1035: ROLLBACK TO create_eam_workorder_PVT;
1036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1037: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1038: THEN
1039: FND_MSG_PUB.add_exc_msg
1040: (
1041: p_pkg_name => G_PKG_NAME,
1042: p_procedure_name => l_api_name,
1043: p_error_text => SUBSTRB(SQLERRM,1,240)

Line 1046: FND_MSG_PUB.count_and_get

1042: p_procedure_name => l_api_name,
1043: p_error_text => SUBSTRB(SQLERRM,1,240)
1044: );
1045: END IF;
1046: FND_MSG_PUB.count_and_get
1047: (
1048: p_encoded => FND_API.G_FALSE,
1049: p_count => x_msg_count,
1050: p_data => x_msg_data

Line 1244: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );

1240:
1241: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1242: IF ( G_DEBUG = 'Y' ) THEN
1243: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
1244: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
1245: END IF;
1246:
1247: RAISE FND_API.G_EXC_ERROR;
1248:

Line 1266: FND_MSG_PUB.count_and_get

1262:
1263: WHEN FND_API.G_EXC_ERROR THEN
1264: ROLLBACK TO update_job_operations_PVT;
1265: x_return_status := FND_API.G_RET_STS_ERROR;
1266: FND_MSG_PUB.count_and_get
1267: (
1268: p_encoded => FND_API.G_FALSE,
1269: p_count => x_msg_count,
1270: p_data => x_msg_data

Line 1280: FND_MSG_PUB.count_and_get

1276:
1277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1278: ROLLBACK TO update_job_operations_PVT;
1279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1280: FND_MSG_PUB.count_and_get
1281: (
1282: p_encoded => FND_API.G_FALSE,
1283: p_count => x_msg_count,
1284: p_data => x_msg_data

Line 1294: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

1290:
1291: WHEN OTHERS THEN
1292: ROLLBACK TO update_job_operations_PVT;
1293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1294: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1295: THEN
1296: FND_MSG_PUB.add_exc_msg
1297: (
1298: p_pkg_name => G_PKG_NAME,

Line 1296: FND_MSG_PUB.add_exc_msg

1292: ROLLBACK TO update_job_operations_PVT;
1293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1294: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1295: THEN
1296: FND_MSG_PUB.add_exc_msg
1297: (
1298: p_pkg_name => G_PKG_NAME,
1299: p_procedure_name => l_api_name,
1300: p_error_text => SUBSTRB(SQLERRM,1,240)

Line 1303: FND_MSG_PUB.count_and_get

1299: p_procedure_name => l_api_name,
1300: p_error_text => SUBSTRB(SQLERRM,1,240)
1301: );
1302: END IF;
1303: FND_MSG_PUB.count_and_get
1304: (
1305: p_encoded => FND_API.G_FALSE,
1306: p_count => x_msg_count,
1307: p_data => x_msg_data

Line 1442: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );

1438:
1439: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1440: IF ( G_DEBUG = 'Y' ) THEN
1441: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
1442: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
1443: END IF;
1444:
1445: RAISE FND_API.G_EXC_ERROR;
1446: END IF;

Line 1463: FND_MSG_PUB.count_and_get

1459:
1460: WHEN FND_API.G_EXC_ERROR THEN
1461: ROLLBACK TO process_material_req_PVT;
1462: x_return_status := FND_API.G_RET_STS_ERROR;
1463: FND_MSG_PUB.count_and_get
1464: (
1465: p_encoded => FND_API.G_FALSE,
1466: p_count => x_msg_count,
1467: p_data => x_msg_data

Line 1477: FND_MSG_PUB.count_and_get

1473:
1474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1475: ROLLBACK TO process_material_req_PVT;
1476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1477: FND_MSG_PUB.count_and_get
1478: (
1479: p_encoded => FND_API.G_FALSE,
1480: p_count => x_msg_count,
1481: p_data => x_msg_data

Line 1491: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

1487:
1488: WHEN OTHERS THEN
1489: ROLLBACK TO process_material_req_PVT;
1490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1491: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1492: THEN
1493: FND_MSG_PUB.add_exc_msg
1494: (
1495: p_pkg_name => G_PKG_NAME,

Line 1493: FND_MSG_PUB.add_exc_msg

1489: ROLLBACK TO process_material_req_PVT;
1490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1491: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1492: THEN
1493: FND_MSG_PUB.add_exc_msg
1494: (
1495: p_pkg_name => G_PKG_NAME,
1496: p_procedure_name => l_api_name,
1497: p_error_text => SUBSTRB(SQLERRM,1,240)

Line 1500: FND_MSG_PUB.count_and_get

1496: p_procedure_name => l_api_name,
1497: p_error_text => SUBSTRB(SQLERRM,1,240)
1498: );
1499: END IF;
1500: FND_MSG_PUB.count_and_get
1501: (
1502: p_encoded => FND_API.G_FALSE,
1503: p_count => x_msg_count,
1504: p_data => x_msg_data

Line 1639: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );

1635:
1636: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1637: IF ( G_DEBUG = 'Y' ) THEN
1638: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
1639: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
1640: END IF;
1641:
1642: RAISE FND_API.G_EXC_ERROR;
1643: END IF;

Line 1660: FND_MSG_PUB.count_and_get

1656:
1657: WHEN FND_API.G_EXC_ERROR THEN
1658: ROLLBACK TO process_resource_req_PVT;
1659: x_return_status := FND_API.G_RET_STS_ERROR;
1660: FND_MSG_PUB.count_and_get
1661: (
1662: p_encoded => FND_API.G_FALSE,
1663: p_count => x_msg_count,
1664: p_data => x_msg_data

Line 1674: FND_MSG_PUB.count_and_get

1670:
1671: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1672: ROLLBACK TO process_resource_req_PVT;
1673: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1674: FND_MSG_PUB.count_and_get
1675: (
1676: p_encoded => FND_API.G_FALSE,
1677: p_count => x_msg_count,
1678: p_data => x_msg_data

Line 1688: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

1684:
1685: WHEN OTHERS THEN
1686: ROLLBACK TO process_resource_req_PVT;
1687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1688: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1689: THEN
1690: FND_MSG_PUB.add_exc_msg
1691: (
1692: p_pkg_name => G_PKG_NAME,

Line 1690: FND_MSG_PUB.add_exc_msg

1686: ROLLBACK TO process_resource_req_PVT;
1687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1688: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1689: THEN
1690: FND_MSG_PUB.add_exc_msg
1691: (
1692: p_pkg_name => G_PKG_NAME,
1693: p_procedure_name => l_api_name,
1694: p_error_text => SUBSTRB(SQLERRM,1,240)

Line 1697: FND_MSG_PUB.count_and_get

1693: p_procedure_name => l_api_name,
1694: p_error_text => SUBSTRB(SQLERRM,1,240)
1695: );
1696: END IF;
1697: FND_MSG_PUB.count_and_get
1698: (
1699: p_encoded => FND_API.G_FALSE,
1700: p_count => x_msg_count,
1701: p_data => x_msg_data

Line 1836: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );

1832:
1833: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1834: IF ( G_DEBUG = 'Y' ) THEN
1835: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
1836: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
1837: END IF;
1838:
1839: RAISE FND_API.G_EXC_ERROR;
1840: END IF;

Line 1857: FND_MSG_PUB.count_and_get

1853:
1854: WHEN FND_API.G_EXC_ERROR THEN
1855: ROLLBACK TO process_resource_assign_PVT;
1856: x_return_status := FND_API.G_RET_STS_ERROR;
1857: FND_MSG_PUB.count_and_get
1858: (
1859: p_encoded => FND_API.G_FALSE,
1860: p_count => x_msg_count,
1861: p_data => x_msg_data

Line 1871: FND_MSG_PUB.count_and_get

1867:
1868: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1869: ROLLBACK TO process_resource_assign_PVT;
1870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1871: FND_MSG_PUB.count_and_get
1872: (
1873: p_encoded => FND_API.G_FALSE,
1874: p_count => x_msg_count,
1875: p_data => x_msg_data

Line 1885: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

1881:
1882: WHEN OTHERS THEN
1883: ROLLBACK TO process_resource_assign_PVT;
1884: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1885: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1886: THEN
1887: FND_MSG_PUB.add_exc_msg
1888: (
1889: p_pkg_name => G_PKG_NAME,

Line 1887: FND_MSG_PUB.add_exc_msg

1883: ROLLBACK TO process_resource_assign_PVT;
1884: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1885: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1886: THEN
1887: FND_MSG_PUB.add_exc_msg
1888: (
1889: p_pkg_name => G_PKG_NAME,
1890: p_procedure_name => l_api_name,
1891: p_error_text => SUBSTRB(SQLERRM,1,240)

Line 1894: FND_MSG_PUB.count_and_get

1890: p_procedure_name => l_api_name,
1891: p_error_text => SUBSTRB(SQLERRM,1,240)
1892: );
1893: END IF;
1894: FND_MSG_PUB.count_and_get
1895: (
1896: p_encoded => FND_API.G_FALSE,
1897: p_count => x_msg_count,
1898: p_data => x_msg_data

Line 2043: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );

2039:
2040: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2041: IF ( G_DEBUG = 'Y' ) THEN
2042: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
2043: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
2044: END IF;
2045:
2046: RAISE FND_API.G_EXC_ERROR;
2047:

Line 2051: FND_MSG_PUB.initialize;

2047:
2048: ELSE
2049: --Change made on Nov 17, 2005 by jeli due to bug 4742895.
2050: --Ignore messages in stack if return status is S after calls to EAM APIs.
2051: FND_MSG_PUB.initialize;
2052:
2053: IF ( G_DEBUG = 'Y' ) THEN
2054: AHL_DEBUG_PUB.debug( 'EAM process_master_child_wo API Successful' );
2055: AHL_DEBUG_PUB.debug( 'Input Workorder Table count : ' || p_x_eam_wo_tbl.COUNT );

Line 2063: FND_MSG_PUB.add;

2059: FOR i IN 1..l_out_eam_wo_tbl.COUNT LOOP
2060: IF ( l_out_eam_wo_tbl(i).wip_entity_id IS NULL ) THEN
2061: FND_MESSAGE.set_name('AHL','AHL_PRD_CREATE_WIP_JOB_FAILED');
2062: FND_MESSAGE.set_token('HEADER', l_out_eam_wo_tbl(i).header_id );
2063: FND_MSG_PUB.add;
2064:
2065: IF ( G_DEBUG = 'Y' ) THEN
2066: AHL_DEBUG_PUB.debug( 'No wip_entity_id generated for header_id:' || l_out_eam_wo_tbl(i).header_id );
2067: END IF;

Line 2079: l_msg_count := FND_MSG_PUB.count_msg;

2075:
2076: END IF;
2077: END LOOP;
2078:
2079: l_msg_count := FND_MSG_PUB.count_msg;
2080: IF l_msg_count > 0 THEN
2081: RAISE FND_API.G_EXC_ERROR;
2082: END IF;
2083:

Line 2100: FND_MSG_PUB.count_and_get

2096:
2097: WHEN FND_API.G_EXC_ERROR THEN
2098: ROLLBACK TO process_eam_workorders_PVT;
2099: x_return_status := FND_API.G_RET_STS_ERROR;
2100: FND_MSG_PUB.count_and_get
2101: (
2102: p_encoded => FND_API.G_FALSE,
2103: p_count => x_msg_count,
2104: p_data => x_msg_data

Line 2114: FND_MSG_PUB.count_and_get

2110:
2111: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2112: ROLLBACK TO process_eam_workorders_PVT;
2113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2114: FND_MSG_PUB.count_and_get
2115: (
2116: p_encoded => FND_API.G_FALSE,
2117: p_count => x_msg_count,
2118: p_data => x_msg_data

Line 2128: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

2124:
2125: WHEN OTHERS THEN
2126: ROLLBACK TO process_eam_workorders_PVT;
2127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2128: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
2129: THEN
2130: FND_MSG_PUB.add_exc_msg
2131: (
2132: p_pkg_name => G_PKG_NAME,

Line 2130: FND_MSG_PUB.add_exc_msg

2126: ROLLBACK TO process_eam_workorders_PVT;
2127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2128: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
2129: THEN
2130: FND_MSG_PUB.add_exc_msg
2131: (
2132: p_pkg_name => G_PKG_NAME,
2133: p_procedure_name => l_api_name,
2134: p_error_text => SUBSTRB(SQLERRM,1,240)

Line 2137: FND_MSG_PUB.count_and_get

2133: p_procedure_name => l_api_name,
2134: p_error_text => SUBSTRB(SQLERRM,1,240)
2135: );
2136: END IF;
2137: FND_MSG_PUB.count_and_get
2138: (
2139: p_encoded => FND_API.G_FALSE,
2140: p_count => x_msg_count,
2141: p_data => x_msg_data