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.AMS_DELIVERABLE_PVT dependencies on JTF_PLSQL_API

Line 348: --p_validation_mode => JTF_PLSQL_API.g_create,

344: (
345: p_api_version_number => l_api_version,
346: p_init_msg_list => FND_API.g_false,
347: p_validation_level => p_validation_level,
348: --p_validation_mode => JTF_PLSQL_API.g_create,
349: x_return_status => l_return_status,
350: x_msg_count => x_msg_count,
351: x_msg_data => x_msg_data,
352: p_deliv_rec => l_deliv_rec

Line 1494: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1490:
1491: END IF;
1492:
1493:
1494: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1495: -- calling the public apis validate_delieverable
1496: -- validate_deliverable
1497: ams_deliverable_pub.validate_deliverable
1498: (

Line 1502: p_validation_mode => JTF_PLSQL_API.g_update,

1498: (
1499: p_api_version_number => l_api_version,
1500: p_init_msg_list => FND_API.g_false,
1501: p_validation_level => p_validation_level,
1502: p_validation_mode => JTF_PLSQL_API.g_update,
1503: x_return_status => l_return_status,
1504: x_msg_count => x_msg_count,
1505: x_msg_data => x_msg_data,
1506: p_deliv_rec => l_deliv_rec

Line 1513: p_validation_mode => JTF_PLSQL_API.g_update,

1509:
1510: /*
1511: check_deliv_items(
1512: p_deliv_rec => l_deliv_rec,
1513: p_validation_mode => JTF_PLSQL_API.g_update,
1514: x_return_status => l_return_status
1515: );
1516:
1517: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 1524: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

1520: RAISE FND_API.g_exc_error;
1521: END IF;
1522: END IF;
1523:
1524: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
1525:
1526: IF (AMS_DEBUG_HIGH_ON) THEN
1527: AMS_Utility_PVT.debug_message('check_deliv_record');
1528: END IF;

Line 2194: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

2190:
2191: AMS_Utility_PVT.debug_message(l_full_name||': check items');
2192: END IF;
2193:
2194: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
2195: check_deliv_items(
2196: p_deliv_rec => p_deliv_rec,
2197: p_validation_mode => p_validation_mode, --JTF_PLSQL_API.g_create,
2198: x_return_status => l_return_status

Line 2197: p_validation_mode => p_validation_mode, --JTF_PLSQL_API.g_create,

2193:
2194: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
2195: check_deliv_items(
2196: p_deliv_rec => p_deliv_rec,
2197: p_validation_mode => p_validation_mode, --JTF_PLSQL_API.g_create,
2198: x_return_status => l_return_status
2199: );
2200:
2201: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 2212: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record

2208: IF (AMS_DEBUG_HIGH_ON) THEN
2209: AMS_Utility_PVT.debug_message(l_full_name||': check record');
2210: END IF;
2211:
2212: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record
2213: AND p_validation_mode = JTF_PLSQL_API.g_create
2214: THEN
2215:
2216: check_deliv_record(

Line 2213: AND p_validation_mode = JTF_PLSQL_API.g_create

2209: AMS_Utility_PVT.debug_message(l_full_name||': check record');
2210: END IF;
2211:
2212: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record
2213: AND p_validation_mode = JTF_PLSQL_API.g_create
2214: THEN
2215:
2216: check_deliv_record(
2217: p_deliv_rec => p_deliv_rec,

Line 2227: ELSIF p_validation_level >= JTF_PLSQL_API.g_valid_level_record

2223: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2224: RAISE FND_API.g_exc_error;
2225: END IF;
2226:
2227: ELSIF p_validation_level >= JTF_PLSQL_API.g_valid_level_record
2228: AND p_validation_mode = JTF_PLSQL_API.g_update
2229: THEN
2230:
2231: check_deliv_record(

Line 2228: AND p_validation_mode = JTF_PLSQL_API.g_update

2224: RAISE FND_API.g_exc_error;
2225: END IF;
2226:
2227: ELSIF p_validation_level >= JTF_PLSQL_API.g_valid_level_record
2228: AND p_validation_mode = JTF_PLSQL_API.g_update
2229: THEN
2230:
2231: check_deliv_record(
2232: p_deliv_rec => p_deliv_rec,

Line 2489: IF p_validation_mode = JTF_PLSQL_API.g_create

2485: x_return_status := FND_API.g_ret_sts_success;
2486:
2487: -- For create_deliverable, when deliverable_id is passed in, we need to
2488: -- check if this deliverable_id is unique.
2489: IF p_validation_mode = JTF_PLSQL_API.g_create
2490: AND p_deliv_rec.deliverable_id IS NOT NULL
2491: THEN
2492: IF AMS_Utility_PVT.check_uniqueness(
2493: 'ams_deliverables_vl',

Line 2511: IF p_validation_mode = JTF_PLSQL_API.g_create

2507: IF (AMS_DEBUG_HIGH_ON) THEN
2508: AMS_Utility_PVT.debug_message(': start of check create '||p_deliv_rec.deliverable_name||' -'||p_deliv_rec.version);
2509: END IF;
2510: -- Check if deliverable_name/version is unique.
2511: IF p_validation_mode = JTF_PLSQL_API.g_create
2512: THEN
2513: l_uniq_flag := 'Y';
2514: OPEN c_check_uniq(p_deliv_rec.deliverable_name, p_deliv_rec.version);
2515: FETCH c_check_uniq INTO l_uniq_flag;

Line 2539: IF p_validation_mode = JTF_PLSQL_API.g_update

2535: END IF;
2536:
2537: -- check name and ver uniquiness in update mode
2538:
2539: IF p_validation_mode = JTF_PLSQL_API.g_update
2540: THEN
2541: l_uniq_flag_u := 'Y';
2542: OPEN c_check_uniq_u(p_deliv_rec.deliverable_name,p_deliv_rec.version,p_deliv_rec.deliverable_id);
2543: FETCH c_check_uniq_u INTO l_uniq_flag_u;

Line 2561: --IF p_validation_mode = JTF_PLSQL_API.g_create THEN

2557: RETURN;
2558: END IF;
2559: END IF;
2560:
2561: --IF p_validation_mode = JTF_PLSQL_API.g_create THEN
2562: -- l_valid_flag := AMS_Utility_PVT.check_uniqueness(
2563: -- 'ams_deliverabless_vl',
2564: -- 'deliverable_name = ''' || p_deliv_rec.deliverable_name ||
2565: -- '''AND version = ' || p_deliv_rec.version

Line 2566: --IF p_validation_mode = JTF_PLSQL_API.g_create THEN

2562: -- l_valid_flag := AMS_Utility_PVT.check_uniqueness(
2563: -- 'ams_deliverabless_vl',
2564: -- 'deliverable_name = ''' || p_deliv_rec.deliverable_name ||
2565: -- '''AND version = ' || p_deliv_rec.version
2566: --IF p_validation_mode = JTF_PLSQL_API.g_create THEN
2567: -- l_valid_flag := AMS_Utility_PVT.check_uniqueness(
2568: -- 'ams_deliverabless_vl',
2569: -- 'deliverable_name = ''' || p_deliv_rec.deliverable_name ||
2570: -- '''AND version = ' || p_deliv_rec.version

Line 2877: IF p_validation_mode = JTF_PLSQL_API.g_create

2873: x_return_status := FND_API.g_ret_sts_success;
2874:
2875: -- validation added for the public apis
2876:
2877: IF p_validation_mode = JTF_PLSQL_API.g_create
2878: THEN
2879: IF NVL(p_deliv_rec.inventory_flag,'N') = 'Y'
2880: THEN
2881: AMS_UTILITY_PVT.error_message('AMS_DELV_NO_INV_CRE');

Line 3232: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,

3228: ---------------------------------------------------------------------
3229: PROCEDURE check_deliv_items
3230: (
3231: p_deliv_rec IN deliv_rec_type,
3232: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
3233: x_return_status OUT NOCOPY VARCHAR2
3234: )
3235: IS
3236: l_dummy NUMBER;