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

Line 230: FND_MSG_PUB.ADD;

226: EXCEPTION
227: WHEN OTHERS THEN
228: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_HEADER_INSERT_ERR');
229: FND_MESSAGE.SET_TOKEN('JOB_NAME', l_job_header_rec.job_name );
230: FND_MSG_PUB.ADD;
231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
232: RETURN;
233: END;
234:

Line 396: FND_MSG_PUB.ADD;

392: EXCEPTION
393: WHEN OTHERS THEN
394: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_HEADER_INSERT_ERR');
395: FND_MESSAGE.SET_TOKEN('JOB_NAME', l_job_header_rec.job_name );
396: FND_MSG_PUB.ADD;
397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
398: RETURN;
399: END;
400:

Line 473: FND_MSG_PUB.ADD;

469: -- is down, then add the message to the message list and exit
470:
471: IF (l_activep <= 0 OR l_activep1 <= 0) THEN
472: FND_MESSAGE.SET_NAME('CSD','CSD_CONC_MGR_DOWN');
473: FND_MSG_PUB.ADD;
474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
475: END IF;
476:
477:

Line 708: FND_MSG_PUB.ADD;

704: x_MTL_TXN_DTLS_TAB_TYPE(l_counter).supply_subinventory := fnd_profile.value('CSD_DEF_HV_SUBINV');
705: --message(fnd_profile.value('CSD_DEF_HV_SUBINV'));
706: IF x_MTL_TXN_DTLS_TAB_TYPE(l_counter).supply_subinventory IS NULL THEN
707: FND_MESSAGE.SET_NAME('CSD','CSD_DEF_SUB_INV_NULL');
708: FND_MSG_PUB.ADD;
709: RAISE FND_API.G_EXC_ERROR;
710: END IF;
711: x_MTL_TXN_DTLS_TAB_TYPE(l_counter).new_row := 'Y';
712:

Line 762: FND_MSG_PUB.ADD;

758: x_MTL_TXN_DTLS_TAB_TYPE(l_counter).supply_subinventory := fnd_profile.value('CSD_DEF_HV_SUBINV');
759: --message(fnd_profile.value('CSD_DEF_HV_SUBINV'));
760: IF x_MTL_TXN_DTLS_TAB_TYPE(l_counter).supply_subinventory IS NULL THEN
761: FND_MESSAGE.SET_NAME('CSD','CSD_DEF_SUB_INV_NULL');
762: FND_MSG_PUB.ADD;
763: RAISE FND_API.G_EXC_ERROR;
764: END IF;
765:
766: x_MTL_TXN_DTLS_TAB_TYPE(l_counter).supply_locator_id := NULL;

Line 942: FND_MSG_PUB.initialize;

938: END If;
939:
940: -- Initialize message list if p_init_msg_list is set to TRUE
941: IF FND_API.to_boolean(p_init_msg_list) THEN
942: FND_MSG_PUB.initialize;
943: END IF;
944:
945: -- Initialize API return status to success
946: x_return_status:=FND_API.G_RET_STS_SUCCESS;

Line 1061: FND_MSG_PUB.ADD;

1057: x_errorMsg => x_msg_data );
1058:
1059: if (x_return_status <> FND_API.G_RET_STS_SUCCESS ) then
1060: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_GEN_FAILURE');
1061: FND_MSG_PUB.ADD;
1062: RAISE FND_API.G_EXC_ERROR;
1063: end if;
1064:
1065: COMMIT;

Line 1115: FND_MSG_PUB.ADD;

1111: x_msg_count => x_msg_count,
1112: x_msg_data => x_msg_data);
1113: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1114: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_GEN_FAILURE');
1115: FND_MSG_PUB.ADD;
1116: RAISE FND_API.G_EXC_ERROR;
1117: END IF;
1118: end if;
1119:

Line 1172: FND_MSG_PUB.ADD;

1168: -- organization, So raise an error and exit
1169:
1170: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_NAME_EXISTS');
1171: FND_MESSAGE.SET_TOKEN('JOB_NAME', l_job_bill_routing_rec.job_name );
1172: FND_MSG_PUB.ADD;
1173: RAISE FND_API.G_EXC_ERROR;
1174: end if;
1175:
1176: ELSE

Line 1228: FND_MSG_PUB.ADD;

1224: x_errorMsg => x_msg_data );
1225:
1226: if (x_return_status <> FND_API.G_RET_STS_SUCCESS ) then
1227: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_GEN_FAILURE');
1228: FND_MSG_PUB.ADD;
1229: RAISE FND_API.G_EXC_ERROR;
1230: end if;
1231:
1232: COMMIT;

Line 1301: FND_MSG_PUB.ADD;

1297: x_msg_count => x_msg_count,
1298: x_msg_data => x_msg_data);
1299: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1300: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_GEN_FAILURE');
1301: FND_MSG_PUB.ADD;
1302: RAISE FND_API.G_EXC_ERROR;
1303: END IF;
1304: end if;
1305: -- COMMIT;

Line 1345: FND_MSG_PUB.ADD;

1341: -- request submission failed,
1342: -- add the error message to the message list and exit
1343:
1344: FND_MESSAGE.SET_NAME('CSD','CSD_CSDJSWIP_SUBMIT_FAILURE');
1345: FND_MSG_PUB.ADD;
1346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1347:
1348:
1349: IF ( l_stat_level >= l_debug_level ) then

Line 1378: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1374: EXCEPTION
1375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1376: ROLLBACK ;
1377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1378: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1379: p_count => x_msg_count,
1380: p_data => x_msg_data);
1381:
1382: IF ( FND_LOG.LEVEL_EXCEPTION >= l_debug_level ) then

Line 1392: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1388:
1389: WHEN FND_API.G_EXC_ERROR THEN
1390: ROLLBACK ;
1391: x_return_status := FND_API.G_RET_STS_ERROR;
1392: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1393: p_count => x_msg_count,
1394: p_data => x_msg_data);
1395:
1396: IF ( FND_LOG.LEVEL_ERROR >= l_debug_level ) then

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

1402: WHEN OTHERS THEN
1403: ROLLBACK ;
1404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1405:
1406: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1407:
1408: -- Add Unexpected Error to Message List, here SQLERRM is used for
1409: -- getting the error
1410:

Line 1411: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'CSD_WIP_JOB_PVT',

1407:
1408: -- Add Unexpected Error to Message List, here SQLERRM is used for
1409: -- getting the error
1410:
1411: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'CSD_WIP_JOB_PVT',
1412: p_procedure_name => 'submit_jobs');
1413: END IF;
1414:
1415: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 1415: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1411: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'CSD_WIP_JOB_PVT',
1412: p_procedure_name => 'submit_jobs');
1413: END IF;
1414:
1415: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1416: p_count => x_msg_count,
1417: p_data => x_msg_data);
1418:
1419: IF ( FND_LOG.LEVEL_EXCEPTION >= l_debug_level ) then

Line 1635: l_msg_data := fnd_msg_pub.get(l_msg_ctr, FND_API.G_FALSE );

1631: -- message list, retrieve the messages and write it to the log file
1632:
1633: FOR l_msg_ctr IN 1..l_msg_count
1634: LOOP
1635: l_msg_data := fnd_msg_pub.get(l_msg_ctr, FND_API.G_FALSE );
1636: fnd_file.put_line( fnd_file.log, l_msg_data);
1637: END LOOP;
1638:
1639: END IF;

Line 1709: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME ,

1705:
1706: -- Add Unexpected Error to Message List, here SQLERRM is used for
1707: -- getting the error
1708:
1709: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME ,
1710: p_procedure_name => l_procedure_name );
1711:
1712: -- Get the count of the Messages from the message list, if the count is 1
1713: -- get the message as well

Line 1715: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1711:
1712: -- Get the count of the Messages from the message list, if the count is 1
1713: -- get the message as well
1714:
1715: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1716: p_count => l_msg_count,
1717: p_data => l_msg_data);
1718:
1719: IF l_msg_count = 1 THEN

Line 1730: l_msg_data := fnd_msg_pub.get(l_msg_ctr, FND_API.G_FALSE );

1726: -- message list, retrieve the messages and write it to the log file
1727:
1728: FOR l_msg_ctr IN 1..l_msg_count
1729: LOOP
1730: l_msg_data := fnd_msg_pub.get(l_msg_ctr, FND_API.G_FALSE );
1731: fnd_file.put_line( fnd_file.log, l_msg_data);
1732: END LOOP;
1733:
1734: END IF;

Line 1845: FND_MSG_PUB.initialize;

1841: END IF;
1842:
1843: -- Initialize message list if p_init_msg_list is set to TRUE
1844: IF FND_API.to_boolean(p_init_msg_list) THEN
1845: FND_MSG_PUB.initialize;
1846: END IF;
1847:
1848: -- Initialize API return status to success
1849: x_return_status:=FND_API.G_RET_STS_SUCCESS;

Line 1859: FND_MSG_PUB.ADD;

1855:
1856: IF l_job_header_rec.organization_id is NULL THEN
1857:
1858: FND_MESSAGE.SET_NAME('CSD','CSD_DEF_REP_INV_NULL');
1859: FND_MSG_PUB.ADD;
1860: RAISE FND_API.G_EXC_ERROR;
1861: END IF;
1862:
1863:

Line 1872: FND_MSG_PUB.ADD;

1868:
1869: IF l_job_prefix IS NULL THEN
1870:
1871: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_PREFIX_NULL');
1872: FND_MSG_PUB.ADD;
1873: RAISE FND_API.G_EXC_ERROR;
1874: END IF;
1875:
1876: l_job_header_rec.class_code :=

Line 1882: FND_MSG_PUB.ADD;

1878:
1879: IF l_job_header_rec.class_code is NULL THEN
1880:
1881: FND_MESSAGE.SET_NAME('CSD','CSD_CLASS_CODE_NULL');
1882: FND_MSG_PUB.ADD;
1883: RAISE FND_API.G_EXC_ERROR;
1884: END IF;
1885:
1886: -- Assign the WIP Job Status lookup codes corresponding to Released -- and Unreleased Job status,

Line 2195: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

2191: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2192: ROLLBACK to CREATE_WIP_JOB_PVT ;
2193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2194:
2195: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2196: p_count => x_msg_count,
2197: p_data => x_msg_data);
2198:
2199: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 2211: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

2207: ROLLBACK to CREATE_WIP_JOB_PVT ;
2208: x_return_status := FND_API.G_RET_STS_ERROR;
2209:
2210:
2211: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2212: p_count => x_msg_count,
2213: p_data => x_msg_data);
2214:
2215: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

2221: WHEN OTHERS THEN
2222: ROLLBACK to CREATE_WIP_JOB_PVT ;
2223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2224:
2225: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2226:
2227: -- Add Unexpected Error to Message List, here SQLERRM is used for
2228: -- getting the error
2229:

Line 2230: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,

2226:
2227: -- Add Unexpected Error to Message List, here SQLERRM is used for
2228: -- getting the error
2229:
2230: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
2231: p_procedure_name => lc_api_name );
2232: END IF;
2233:
2234: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 2234: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

2230: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
2231: p_procedure_name => lc_api_name );
2232: END IF;
2233:
2234: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2235: p_count => x_msg_count,
2236: p_data => x_msg_data);
2237:
2238: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 2281: FND_MSG_PUB.initialize;

2277: END IF;
2278:
2279: -- Initialize message list if p_init_msg_list is set to TRUE
2280: IF FND_API.to_boolean(p_init_msg_list) THEN
2281: FND_MSG_PUB.initialize;
2282: END IF;
2283:
2284: -- Initialize API return status to success
2285: x_return_status:=FND_API.G_RET_STS_SUCCESS;

Line 2322: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2318: COMMIT WORK;
2319: EXCEPTION
2320: WHEN FND_API.G_EXC_ERROR THEN
2321: x_return_status := fnd_api.G_RET_STS_ERROR;
2322: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2323: p_count => x_msg_count,
2324: p_data => x_msg_data );
2325: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2327: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2323: p_count => x_msg_count,
2324: p_data => x_msg_data );
2325: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2327: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2328: p_count => x_msg_count,
2329: p_data => x_msg_data );
2330: WHEN OTHERS THEN
2331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2332: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2328: p_count => x_msg_count,
2329: p_data => x_msg_data );
2330: WHEN OTHERS THEN
2331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2332: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2333: p_count => x_msg_count,
2334: p_data => x_msg_data );
2335: END matrl_reqmnt_from_estms;
2336: