DBA Data[Home] [Help]

APPS.AMS_WEB_TRACK_PVT dependencies on JTF_PLSQL_API

Line 162: p_validation_mode => JTF_PLSQL_API.g_create,

158: Validate_web_track(
159: p_api_version_number => 1.0,
160: p_init_msg_list => FND_API.G_FALSE,
161: p_validation_level => p_validation_level,
162: p_validation_mode => JTF_PLSQL_API.g_create,
163: p_web_track_rec => p_web_track_rec,
164: x_return_status => x_return_status,
165: x_msg_count => x_msg_count,
166: x_msg_data => x_msg_data);

Line 441: p_validation_mode => JTF_PLSQL_API.g_update,

437: Validate_web_track(
438: p_api_version_number => 1.0,
439: p_init_msg_list => FND_API.G_FALSE,
440: p_validation_level => p_validation_level,
441: p_validation_mode => JTF_PLSQL_API.g_update,
442: p_web_track_rec => p_web_track_rec,
443: x_return_status => x_return_status,
444: x_msg_count => x_msg_count,
445: x_msg_data => x_msg_data);

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

833:
834:
835: PROCEDURE check_Web_Track_Uk_Items(
836: p_web_track_rec IN web_track_rec_type,
837: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
838: x_return_status OUT NOCOPY VARCHAR2)
839: IS
840: l_valid_flag VARCHAR2(1);
841:

Line 844: IF p_validation_mode = JTF_PLSQL_API.g_create

840: l_valid_flag VARCHAR2(1);
841:
842: BEGIN
843: x_return_status := FND_API.g_ret_sts_success;
844: IF p_validation_mode = JTF_PLSQL_API.g_create
845: AND p_web_track_rec.web_tracking_id IS NOT NULL
846: THEN
847: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
848: 'ams_web_tracking',

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

860:
861:
862: PROCEDURE check_Web_Track_Req_Items(
863: p_web_track_rec IN web_track_rec_type,
864: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
865: x_return_status OUT NOCOPY VARCHAR2
866: )
867: IS
868: BEGIN

Line 873: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

869: x_return_status := FND_API.g_ret_sts_success;
870: --insert_log_mesg('check_Web_Track_Req_Items');
871: --insert_log_mesg(x_return_status);
872:
873: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
874:
875: --insert_log_mesg('Web Tracking Id ::::'||p_web_track_rec.web_tracking_id);
876:
877: -- IF p_web_track_rec.web_tracking_id = FND_API.G_MISS_NUM OR p_web_track_rec.web_tracking_id IS NULL THEN

Line 1242: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1238: FND_MSG_PUB.initialize;
1239: END IF;
1240: --insert_log_mesg('Private API: Validate_Web_Track');
1241:
1242: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1243: --insert_log_mesg('Check_web_track_Items');
1244: Check_web_track_Items(
1245: p_web_track_rec => p_web_track_rec,
1246: p_validation_mode => p_validation_mode,

Line 1258: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

1254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1255: END IF;
1256: END IF;
1257:
1258: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1259: --insert_log_mesg('before Default_Web_Track_Items');
1260: Default_Web_Track_Items (p_web_track_rec => p_web_track_rec ,
1261: x_web_track_rec => l_web_track_rec) ;
1262: END IF ;

Line 1271: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1267: x_complete_rec => l_web_track_rec
1268: );
1269: --insert_log_mesg('Complete_web_track_Rec');
1270:
1271: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1272: Validate_web_track_Rec(
1273: p_api_version_number => 1.0,
1274: p_init_msg_list => FND_API.G_FALSE,
1275: x_return_status => x_return_status,

Line 1507: p_validation_mode => JTF_PLSQL_API.g_create,

1503: Validate_web_recomms(
1504: p_api_version_number => 1.0,
1505: p_init_msg_list => FND_API.G_FALSE,
1506: p_validation_level => p_validation_level,
1507: p_validation_mode => JTF_PLSQL_API.g_create,
1508: p_web_recomms_rec => p_web_recomms_rec,
1509: x_return_status => x_return_status,
1510: x_msg_count => x_msg_count,
1511: x_msg_data => x_msg_data);

Line 1777: p_validation_mode => JTF_PLSQL_API.g_update,

1773: Validate_web_recomms(
1774: p_api_version_number => 1.0,
1775: p_init_msg_list => FND_API.G_FALSE,
1776: p_validation_level => p_validation_level,
1777: p_validation_mode => JTF_PLSQL_API.g_update,
1778: p_web_recomms_rec => p_web_recomms_rec,
1779: x_return_status => x_return_status,
1780: x_msg_count => x_msg_count,
1781: x_msg_data => x_msg_data);

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

2171:
2172:
2173: PROCEDURE check_Web_Recomms_Uk_Items(
2174: p_web_recomms_rec IN web_recomms_rec_type,
2175: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
2176: x_return_status OUT NOCOPY VARCHAR2)
2177: IS
2178: l_valid_flag VARCHAR2(1);
2179:

Line 2182: IF p_validation_mode = JTF_PLSQL_API.g_create

2178: l_valid_flag VARCHAR2(1);
2179:
2180: BEGIN
2181: x_return_status := FND_API.g_ret_sts_success;
2182: IF p_validation_mode = JTF_PLSQL_API.g_create
2183: AND p_web_recomms_rec.web_recomm_id IS NOT NULL
2184: THEN
2185: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
2186: 'ams_web_recomms',

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

2198:
2199:
2200: PROCEDURE check_Web_Recomms_Req_Items(
2201: p_web_recomms_rec IN web_recomms_rec_type,
2202: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
2203: x_return_status OUT NOCOPY VARCHAR2
2204: )
2205: IS
2206: BEGIN

Line 2209: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

2205: IS
2206: BEGIN
2207: x_return_status := FND_API.g_ret_sts_success;
2208:
2209: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
2210:
2211:
2212: -- IF p_web_recomms_rec.web_recomm_id = FND_API.G_MISS_NUM OR p_web_recomms_rec.web_recomm_id IS NULL THEN
2213: -- AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'WEB_RECOMM_ID' );

Line 2549: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

2545: FND_MSG_PUB.initialize;
2546: END IF;
2547:
2548:
2549: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
2550: Check_web_recomms_Items(
2551: p_web_recomms_rec => p_web_recomms_rec,
2552: p_validation_mode => p_validation_mode,
2553: x_return_status => x_return_status

Line 2563: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

2559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2560: END IF;
2561: END IF;
2562:
2563: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
2564: Default_Web_Recomms_Items (p_web_recomms_rec => p_web_recomms_rec ,
2565: x_web_recomms_rec => l_web_recomms_rec) ;
2566: END IF ;
2567:

Line 2574: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

2570: p_web_recomms_rec => l_web_recomms_rec,
2571: x_complete_rec => l_web_recomms_rec
2572: );
2573:
2574: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
2575: Validate_web_recomms_Rec(
2576: p_api_version_number => 1.0,
2577: p_init_msg_list => FND_API.G_FALSE,
2578: x_return_status => x_return_status,