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 1507: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1503:
1504: END IF;
1505:
1506:
1507: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1508: -- calling the public apis validate_delieverable
1509: -- validate_deliverable
1510: ams_deliverable_pub.validate_deliverable
1511: (

Line 1515: p_validation_mode => JTF_PLSQL_API.g_update,

1511: (
1512: p_api_version_number => l_api_version,
1513: p_init_msg_list => FND_API.g_false,
1514: p_validation_level => p_validation_level,
1515: p_validation_mode => JTF_PLSQL_API.g_update,
1516: x_return_status => l_return_status,
1517: x_msg_count => x_msg_count,
1518: x_msg_data => x_msg_data,
1519: p_deliv_rec => l_deliv_rec

Line 1526: p_validation_mode => JTF_PLSQL_API.g_update,

1522:
1523: /*
1524: check_deliv_items(
1525: p_deliv_rec => l_deliv_rec,
1526: p_validation_mode => JTF_PLSQL_API.g_update,
1527: x_return_status => l_return_status
1528: );
1529:
1530: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 1537: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

1533: RAISE FND_API.g_exc_error;
1534: END IF;
1535: END IF;
1536:
1537: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
1538:
1539: IF (AMS_DEBUG_HIGH_ON) THEN
1540: AMS_Utility_PVT.debug_message('check_deliv_record');
1541: END IF;

Line 2207: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

2203:
2204: AMS_Utility_PVT.debug_message(l_full_name||': check items');
2205: END IF;
2206:
2207: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
2208: check_deliv_items(
2209: p_deliv_rec => p_deliv_rec,
2210: p_validation_mode => p_validation_mode, --JTF_PLSQL_API.g_create,
2211: x_return_status => l_return_status

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

2206:
2207: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
2208: check_deliv_items(
2209: p_deliv_rec => p_deliv_rec,
2210: p_validation_mode => p_validation_mode, --JTF_PLSQL_API.g_create,
2211: x_return_status => l_return_status
2212: );
2213:
2214: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 2225: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record

2221: IF (AMS_DEBUG_HIGH_ON) THEN
2222: AMS_Utility_PVT.debug_message(l_full_name||': check record');
2223: END IF;
2224:
2225: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record
2226: AND p_validation_mode = JTF_PLSQL_API.g_create
2227: THEN
2228:
2229: check_deliv_record(

Line 2226: AND p_validation_mode = JTF_PLSQL_API.g_create

2222: AMS_Utility_PVT.debug_message(l_full_name||': check record');
2223: END IF;
2224:
2225: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record
2226: AND p_validation_mode = JTF_PLSQL_API.g_create
2227: THEN
2228:
2229: check_deliv_record(
2230: p_deliv_rec => p_deliv_rec,

Line 2240: ELSIF p_validation_level >= JTF_PLSQL_API.g_valid_level_record

2236: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2237: RAISE FND_API.g_exc_error;
2238: END IF;
2239:
2240: ELSIF p_validation_level >= JTF_PLSQL_API.g_valid_level_record
2241: AND p_validation_mode = JTF_PLSQL_API.g_update
2242: THEN
2243:
2244: check_deliv_record(

Line 2241: AND p_validation_mode = JTF_PLSQL_API.g_update

2237: RAISE FND_API.g_exc_error;
2238: END IF;
2239:
2240: ELSIF p_validation_level >= JTF_PLSQL_API.g_valid_level_record
2241: AND p_validation_mode = JTF_PLSQL_API.g_update
2242: THEN
2243:
2244: check_deliv_record(
2245: p_deliv_rec => p_deliv_rec,

Line 2502: IF p_validation_mode = JTF_PLSQL_API.g_create

2498: x_return_status := FND_API.g_ret_sts_success;
2499:
2500: -- For create_deliverable, when deliverable_id is passed in, we need to
2501: -- check if this deliverable_id is unique.
2502: IF p_validation_mode = JTF_PLSQL_API.g_create
2503: AND p_deliv_rec.deliverable_id IS NOT NULL
2504: THEN
2505: IF AMS_Utility_PVT.check_uniqueness(
2506: 'ams_deliverables_vl',

Line 2524: IF p_validation_mode = JTF_PLSQL_API.g_create

2520: IF (AMS_DEBUG_HIGH_ON) THEN
2521: AMS_Utility_PVT.debug_message(': start of check create '||p_deliv_rec.deliverable_name||' -'||p_deliv_rec.version);
2522: END IF;
2523: -- Check if deliverable_name/version is unique.
2524: IF p_validation_mode = JTF_PLSQL_API.g_create
2525: THEN
2526: l_uniq_flag := 'Y';
2527: OPEN c_check_uniq(p_deliv_rec.deliverable_name, p_deliv_rec.version);
2528: FETCH c_check_uniq INTO l_uniq_flag;

Line 2552: IF p_validation_mode = JTF_PLSQL_API.g_update

2548: END IF;
2549:
2550: -- check name and ver uniquiness in update mode
2551:
2552: IF p_validation_mode = JTF_PLSQL_API.g_update
2553: THEN
2554: l_uniq_flag_u := 'Y';
2555: OPEN c_check_uniq_u(p_deliv_rec.deliverable_name,p_deliv_rec.version,p_deliv_rec.deliverable_id);
2556: FETCH c_check_uniq_u INTO l_uniq_flag_u;

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

2570: RETURN;
2571: END IF;
2572: END IF;
2573:
2574: --IF p_validation_mode = JTF_PLSQL_API.g_create THEN
2575: -- l_valid_flag := AMS_Utility_PVT.check_uniqueness(
2576: -- 'ams_deliverabless_vl',
2577: -- 'deliverable_name = ''' || p_deliv_rec.deliverable_name ||
2578: -- '''AND version = ' || p_deliv_rec.version

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

2575: -- l_valid_flag := AMS_Utility_PVT.check_uniqueness(
2576: -- 'ams_deliverabless_vl',
2577: -- 'deliverable_name = ''' || p_deliv_rec.deliverable_name ||
2578: -- '''AND version = ' || p_deliv_rec.version
2579: --IF p_validation_mode = JTF_PLSQL_API.g_create THEN
2580: -- l_valid_flag := AMS_Utility_PVT.check_uniqueness(
2581: -- 'ams_deliverabless_vl',
2582: -- 'deliverable_name = ''' || p_deliv_rec.deliverable_name ||
2583: -- '''AND version = ' || p_deliv_rec.version

Line 2890: IF p_validation_mode = JTF_PLSQL_API.g_create

2886: x_return_status := FND_API.g_ret_sts_success;
2887:
2888: -- validation added for the public apis
2889:
2890: IF p_validation_mode = JTF_PLSQL_API.g_create
2891: THEN
2892: IF NVL(p_deliv_rec.inventory_flag,'N') = 'Y'
2893: THEN
2894: AMS_UTILITY_PVT.error_message('AMS_DELV_NO_INV_CRE');

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

3241: ---------------------------------------------------------------------
3242: PROCEDURE check_deliv_items
3243: (
3244: p_deliv_rec IN deliv_rec_type,
3245: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
3246: x_return_status OUT NOCOPY VARCHAR2
3247: )
3248: IS
3249: l_dummy NUMBER;