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 235: FND_MSG_PUB.ADD;

231: EXCEPTION
232: WHEN OTHERS THEN
233: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_HEADER_INSERT_ERR');
234: FND_MESSAGE.SET_TOKEN('JOB_NAME', l_job_header_rec.job_name );
235: FND_MSG_PUB.ADD;
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
237: RETURN;
238: END;
239:

Line 401: FND_MSG_PUB.ADD;

397: EXCEPTION
398: WHEN OTHERS THEN
399: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_HEADER_INSERT_ERR');
400: FND_MESSAGE.SET_TOKEN('JOB_NAME', l_job_header_rec.job_name );
401: FND_MSG_PUB.ADD;
402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
403: RETURN;
404: END;
405:

Line 478: FND_MSG_PUB.ADD;

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

Line 713: FND_MSG_PUB.ADD;

709: x_MTL_TXN_DTLS_TAB_TYPE(l_counter).supply_subinventory := fnd_profile.value('CSD_DEF_HV_SUBINV');
710: --message(fnd_profile.value('CSD_DEF_HV_SUBINV'));
711: IF x_MTL_TXN_DTLS_TAB_TYPE(l_counter).supply_subinventory IS NULL THEN
712: FND_MESSAGE.SET_NAME('CSD','CSD_DEF_SUB_INV_NULL');
713: FND_MSG_PUB.ADD;
714: RAISE FND_API.G_EXC_ERROR;
715: END IF;
716: x_MTL_TXN_DTLS_TAB_TYPE(l_counter).new_row := 'Y';
717:

Line 767: FND_MSG_PUB.ADD;

763: x_MTL_TXN_DTLS_TAB_TYPE(l_counter).supply_subinventory := fnd_profile.value('CSD_DEF_HV_SUBINV');
764: --message(fnd_profile.value('CSD_DEF_HV_SUBINV'));
765: IF x_MTL_TXN_DTLS_TAB_TYPE(l_counter).supply_subinventory IS NULL THEN
766: FND_MESSAGE.SET_NAME('CSD','CSD_DEF_SUB_INV_NULL');
767: FND_MSG_PUB.ADD;
768: RAISE FND_API.G_EXC_ERROR;
769: END IF;
770:
771: x_MTL_TXN_DTLS_TAB_TYPE(l_counter).supply_locator_id := NULL;

Line 949: FND_MSG_PUB.initialize;

945: END If;
946:
947: -- Initialize message list if p_init_msg_list is set to TRUE
948: IF FND_API.to_boolean(p_init_msg_list) THEN
949: FND_MSG_PUB.initialize;
950: END IF;
951:
952: -- Initialize API return status to success
953: x_return_status:=FND_API.G_RET_STS_SUCCESS;

Line 1068: FND_MSG_PUB.ADD;

1064: x_errorMsg => x_msg_data );
1065:
1066: if (x_return_status <> FND_API.G_RET_STS_SUCCESS ) then
1067: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_GEN_FAILURE');
1068: FND_MSG_PUB.ADD;
1069: RAISE FND_API.G_EXC_ERROR;
1070: end if;
1071:
1072: COMMIT;

Line 1144: FND_MSG_PUB.ADD;

1140: x_msg_count => x_msg_count,
1141: x_msg_data => x_msg_data);
1142: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1143: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_GEN_FAILURE');
1144: FND_MSG_PUB.ADD;
1145: RAISE FND_API.G_EXC_ERROR;
1146: END IF;
1147: end if;
1148:

Line 1201: FND_MSG_PUB.ADD;

1197: -- organization, So raise an error and exit
1198:
1199: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_NAME_EXISTS');
1200: FND_MESSAGE.SET_TOKEN('JOB_NAME', l_job_bill_routing_rec.job_name );
1201: FND_MSG_PUB.ADD;
1202: RAISE FND_API.G_EXC_ERROR;
1203: end if;
1204:
1205: ELSE

Line 1257: FND_MSG_PUB.ADD;

1253: x_errorMsg => x_msg_data );
1254:
1255: if (x_return_status <> FND_API.G_RET_STS_SUCCESS ) then
1256: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_GEN_FAILURE');
1257: FND_MSG_PUB.ADD;
1258: RAISE FND_API.G_EXC_ERROR;
1259: end if;
1260:
1261: COMMIT;

Line 1353: FND_MSG_PUB.ADD;

1349: x_msg_count => x_msg_count,
1350: x_msg_data => x_msg_data);
1351: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1352: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_GEN_FAILURE');
1353: FND_MSG_PUB.ADD;
1354: RAISE FND_API.G_EXC_ERROR;
1355: END IF;
1356: end if;
1357: -- COMMIT;

Line 1397: FND_MSG_PUB.ADD;

1393: -- request submission failed,
1394: -- add the error message to the message list and exit
1395:
1396: FND_MESSAGE.SET_NAME('CSD','CSD_CSDJSWIP_SUBMIT_FAILURE');
1397: FND_MSG_PUB.ADD;
1398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1399:
1400:
1401: IF ( l_stat_level >= l_debug_level ) then

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

1426: EXCEPTION
1427: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1428: ROLLBACK ;
1429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1430: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1431: p_count => x_msg_count,
1432: p_data => x_msg_data);
1433:
1434: IF ( FND_LOG.LEVEL_EXCEPTION >= l_debug_level ) then

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

1440:
1441: WHEN FND_API.G_EXC_ERROR THEN
1442: ROLLBACK ;
1443: x_return_status := FND_API.G_RET_STS_ERROR;
1444: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1445: p_count => x_msg_count,
1446: p_data => x_msg_data);
1447:
1448: IF ( FND_LOG.LEVEL_ERROR >= l_debug_level ) then

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

1454: WHEN OTHERS THEN
1455: ROLLBACK ;
1456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1457:
1458: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1459:
1460: -- Add Unexpected Error to Message List, here SQLERRM is used for
1461: -- getting the error
1462:

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

1459:
1460: -- Add Unexpected Error to Message List, here SQLERRM is used for
1461: -- getting the error
1462:
1463: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'CSD_WIP_JOB_PVT',
1464: p_procedure_name => 'submit_jobs');
1465: END IF;
1466:
1467: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

1463: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'CSD_WIP_JOB_PVT',
1464: p_procedure_name => 'submit_jobs');
1465: END IF;
1466:
1467: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1468: p_count => x_msg_count,
1469: p_data => x_msg_data);
1470:
1471: IF ( FND_LOG.LEVEL_EXCEPTION >= l_debug_level ) then

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

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

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

1871:
1872: -- Add Unexpected Error to Message List, here SQLERRM is used for
1873: -- getting the error
1874:
1875: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME ,
1876: p_procedure_name => l_procedure_name );
1877:
1878: -- Get the count of the Messages from the message list, if the count is 1
1879: -- get the message as well

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

1877:
1878: -- Get the count of the Messages from the message list, if the count is 1
1879: -- get the message as well
1880:
1881: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1882: p_count => l_msg_count,
1883: p_data => l_msg_data);
1884:
1885: IF l_msg_count = 1 THEN

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

1892: -- message list, retrieve the messages and write it to the log file
1893:
1894: FOR l_msg_ctr IN 1..l_msg_count
1895: LOOP
1896: l_msg_data := fnd_msg_pub.get(l_msg_ctr, FND_API.G_FALSE );
1897: fnd_file.put_line( fnd_file.log, l_msg_data);
1898: END LOOP;
1899:
1900: END IF;

Line 2014: FND_MSG_PUB.initialize;

2010: END IF;
2011:
2012: -- Initialize message list if p_init_msg_list is set to TRUE
2013: IF FND_API.to_boolean(p_init_msg_list) THEN
2014: FND_MSG_PUB.initialize;
2015: END IF;
2016:
2017: -- Initialize API return status to success
2018: x_return_status:=FND_API.G_RET_STS_SUCCESS;

Line 2028: FND_MSG_PUB.ADD;

2024:
2025: IF l_job_header_rec.organization_id is NULL THEN
2026:
2027: FND_MESSAGE.SET_NAME('CSD','CSD_DEF_REP_INV_NULL');
2028: FND_MSG_PUB.ADD;
2029: RAISE FND_API.G_EXC_ERROR;
2030: END IF;
2031:
2032:

Line 2041: FND_MSG_PUB.ADD;

2037:
2038: IF l_job_prefix IS NULL THEN
2039:
2040: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_PREFIX_NULL');
2041: FND_MSG_PUB.ADD;
2042: RAISE FND_API.G_EXC_ERROR;
2043: END IF;
2044:
2045: l_job_header_rec.class_code :=

Line 2051: FND_MSG_PUB.ADD;

2047:
2048: IF l_job_header_rec.class_code is NULL THEN
2049:
2050: FND_MESSAGE.SET_NAME('CSD','CSD_CLASS_CODE_NULL');
2051: FND_MSG_PUB.ADD;
2052: RAISE FND_API.G_EXC_ERROR;
2053: END IF;
2054:
2055: -- Assign the WIP Job Status lookup codes corresponding to Released -- and Unreleased Job status,

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

2385: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2386: ROLLBACK to CREATE_WIP_JOB_PVT ;
2387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2388:
2389: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2390: p_count => x_msg_count,
2391: p_data => x_msg_data);
2392:
2393: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

2401: ROLLBACK to CREATE_WIP_JOB_PVT ;
2402: x_return_status := FND_API.G_RET_STS_ERROR;
2403:
2404:
2405: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2406: p_count => x_msg_count,
2407: p_data => x_msg_data);
2408:
2409: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

2415: WHEN OTHERS THEN
2416: ROLLBACK to CREATE_WIP_JOB_PVT ;
2417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2418:
2419: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2420:
2421: -- Add Unexpected Error to Message List, here SQLERRM is used for
2422: -- getting the error
2423:

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

2420:
2421: -- Add Unexpected Error to Message List, here SQLERRM is used for
2422: -- getting the error
2423:
2424: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
2425: p_procedure_name => lc_api_name );
2426: END IF;
2427:
2428: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

2424: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
2425: p_procedure_name => lc_api_name );
2426: END IF;
2427:
2428: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2429: p_count => x_msg_count,
2430: p_data => x_msg_data);
2431:
2432: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 2475: FND_MSG_PUB.initialize;

2471: END IF;
2472:
2473: -- Initialize message list if p_init_msg_list is set to TRUE
2474: IF FND_API.to_boolean(p_init_msg_list) THEN
2475: FND_MSG_PUB.initialize;
2476: END IF;
2477:
2478: -- Initialize API return status to success
2479: x_return_status:=FND_API.G_RET_STS_SUCCESS;

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

2512: COMMIT WORK;
2513: EXCEPTION
2514: WHEN FND_API.G_EXC_ERROR THEN
2515: x_return_status := fnd_api.G_RET_STS_ERROR;
2516: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2517: p_count => x_msg_count,
2518: p_data => x_msg_data );
2519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2517: p_count => x_msg_count,
2518: p_data => x_msg_data );
2519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2521: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2522: p_count => x_msg_count,
2523: p_data => x_msg_data );
2524: WHEN OTHERS THEN
2525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2522: p_count => x_msg_count,
2523: p_data => x_msg_data );
2524: WHEN OTHERS THEN
2525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2526: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2527: p_count => x_msg_count,
2528: p_data => x_msg_data );
2529: END matrl_reqmnt_from_estms;
2530:

Line 2598: fnd_msg_pub.initialize;

2594: END IF;
2595:
2596: IF fnd_api.to_boolean(p_init_msg_list)
2597: THEN
2598: fnd_msg_pub.initialize;
2599: END IF;
2600:
2601: px_job_names := jtf_varchar2_table_100();
2602: