DBA Data[Home] [Help]

APPS.AMS_PS_RULE_PVT dependencies on JTF_PLSQL_API

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

1406:
1407:
1408: PROCEDURE check_ps_rules_uk_items(
1409: p_ps_rules_rec IN ps_rules_rec_type,
1410: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1411: x_return_status OUT NOCOPY VARCHAR2)
1412: IS
1413: l_valid_flag VARCHAR2(1);
1414:

Line 1417: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

1413: l_valid_flag VARCHAR2(1);
1414:
1415: BEGIN
1416: x_return_status := FND_API.g_ret_sts_success;
1417: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1418: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1419: 'AMS_IBA_PS_RULES',
1420: 'RULE_ID = ''' || p_ps_rules_rec.RULE_ID ||''''
1421: );

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

1436: END check_ps_rules_uk_items;
1437:
1438: PROCEDURE check_ps_rules_req_items(
1439: p_ps_rules_rec IN ps_rules_rec_type,
1440: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1441: x_return_status OUT NOCOPY VARCHAR2
1442: )
1443: IS
1444: BEGIN

Line 1447: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

1443: IS
1444: BEGIN
1445: x_return_status := FND_API.g_ret_sts_success;
1446:
1447: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1448:
1449:
1450: IF p_ps_rules_rec.created_by = FND_API.g_miss_num OR p_ps_rules_rec.created_by IS NULL THEN
1451: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_rules_NO_created_by');

Line 1997: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1993: IF FND_API.to_Boolean( p_init_msg_list )
1994: THEN
1995: FND_MSG_PUB.initialize;
1996: END IF;
1997: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1998: Check_ps_rules_Items(
1999: p_ps_rules_rec => p_ps_rules_rec,
2000: p_validation_mode => JTF_PLSQL_API.g_update,
2001: x_return_status => x_return_status

Line 2000: p_validation_mode => JTF_PLSQL_API.g_update,

1996: END IF;
1997: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1998: Check_ps_rules_Items(
1999: p_ps_rules_rec => p_ps_rules_rec,
2000: p_validation_mode => JTF_PLSQL_API.g_update,
2001: x_return_status => x_return_status
2002: );
2003:
2004: IF x_return_status = FND_API.G_RET_STS_ERROR THEN