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.PVX_UTILITY_PVT dependencies on FND_API

Line 64: RETURN FND_API.g_false;

60: l_count := 0;
61: END;
62:
63: IF l_count = 0 THEN
64: RETURN FND_API.g_false;
65: ELSE
66: RETURN FND_API.g_true;
67: END IF;
68:

Line 66: RETURN FND_API.g_true;

62:
63: IF l_count = 0 THEN
64: RETURN FND_API.g_false;
65: ELSE
66: RETURN FND_API.g_true;
67: END IF;
68:
69: END check_fk_exists;
70:

Line 85: is_vendor_admin varchar2(1):=FND_API.g_false;

81: RETURN VARCHAR2
82: IS
83:
84: l_temp varchar2(1);
85: is_vendor_admin varchar2(1):=FND_API.g_false;
86:
87: CURSOR isvendor_csr(p_res_id NUMBER) IS
88: SELECT 'Y'
89: FROM jtf_rs_role_relations role_reln, jtf_rs_roles_vl rl

Line 103: is_vendor_admin:=FND_API.g_true;

99: BEGIN
100: OPEN isvendor_csr(p_resource_id);
101: FETCH isvendor_csr into l_temp;
102: IF isvendor_csr%FOUND THEN
103: is_vendor_admin:=FND_API.g_true;
104: END IF;
105: CLOSE isvendor_csr;
106:
107: RETURN is_vendor_admin ;

Line 144: RETURN FND_API.g_false;

140: l_count := 0;
141: END;
142:
143: IF l_count = 0 THEN
144: RETURN FND_API.g_false;
145: ELSE
146: RETURN FND_API.g_true;
147: END IF;
148:

Line 146: RETURN FND_API.g_true;

142:
143: IF l_count = 0 THEN
144: RETURN FND_API.g_false;
145: ELSE
146: RETURN FND_API.g_true;
147: END IF;
148:
149: END check_lookup_exists;
150:

Line 229: RETURN FND_API.g_true;

225: l_count := 0;
226: END;
227:
228: IF l_count = 0 THEN
229: RETURN FND_API.g_true;
230: ELSE
231: RETURN FND_API.g_false;
232: END IF;
233:

Line 231: RETURN FND_API.g_false;

227:
228: IF l_count = 0 THEN
229: RETURN FND_API.g_true;
230: ELSE
231: RETURN FND_API.g_false;
232: END IF;
233:
234: END check_uniqueness;
235:

Line 249: RETURN FND_API.g_true;

245: RETURN VARCHAR2
246: IS
247: BEGIN
248: IF p_value = 'Y' or p_value = 'N' THEN
249: RETURN FND_API.g_true;
250: ELSE
251: RETURN FND_API.g_false;
252: END IF;
253: END is_Y_or_N;

Line 251: RETURN FND_API.g_false;

247: BEGIN
248: IF p_value = 'Y' or p_value = 'N' THEN
249: RETURN FND_API.g_true;
250: ELSE
251: RETURN FND_API.g_false;
252: END IF;
253: END is_Y_or_N;
254:
255:

Line 309: l_msg := FND_MSG_PUB.get(i, FND_API.g_false);

305: l_msg VARCHAR2(2000);
306: BEGIN
307: l_count := FND_MSG_PUB.count_msg;
308: FOR i IN 1 .. l_count LOOP
309: l_msg := FND_MSG_PUB.get(i, FND_API.g_false);
310: -- holiu: remove since adchkdrv does not like it
311: -- DBMS_OUTPUT.put_line('(' || i || ') ' || l_msg);
312: END LOOP;
313: END display_messages;

Line 333: x_return_status := FND_API.G_RET_STS_ERROR;

329: OPEN c_meaning;
330: FETCH c_meaning INTO x_meaning;
331: IF c_meaning%NOTFOUND THEN
332: CLOSE c_meaning;
333: x_return_status := FND_API.G_RET_STS_ERROR;
334: x_meaning:= NULL;
335: ELSE
336: x_return_status := FND_API.G_RET_STS_SUCCESS;
337: END IF;

Line 336: x_return_status := FND_API.G_RET_STS_SUCCESS;

332: CLOSE c_meaning;
333: x_return_status := FND_API.G_RET_STS_ERROR;
334: x_meaning:= NULL;
335: ELSE
336: x_return_status := FND_API.G_RET_STS_SUCCESS;
337: END IF;
338: EXCEPTION
339: WHEN OTHERS THEN
340: IF c_meaning%ISOPEN THEN

Line 343: x_return_status := FND_API.G_RET_STS_ERROR;

339: WHEN OTHERS THEN
340: IF c_meaning%ISOPEN THEN
341: CLOSE c_meaning;
342: END IF;
343: x_return_status := FND_API.G_RET_STS_ERROR;
344: x_meaning := NULL;
345: END get_lookup_meaning;
346:
347:

Line 373: x_return_status := FND_API.G_RET_STS_SUCCESS;

369: -- where TIMEZONE_ID = l_time_id;
370:
371: BEGIN
372: -- Initialize API return status to success
373: x_return_status := FND_API.G_RET_STS_SUCCESS;
374: l_sys_time_id := FND_PROFILE.VALUE('AMS_SYSTEM_TIMEZONE_ID');
375: OPEN c_get_name(l_sys_time_id);
376: FETCH c_get_name into l_sys_name;
377: IF (c_get_name%NOTFOUND) THEN

Line 379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

375: OPEN c_get_name(l_sys_time_id);
376: FETCH c_get_name into l_sys_name;
377: IF (c_get_name%NOTFOUND) THEN
378: CLOSE c_get_name;
379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
380: return;
381: END IF;
382: CLOSE c_get_name;
383:

Line 391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

387: WHEN NO_DATA_FOUND THEN
388: IF (c_get_name%ISOPEN) THEN
389: CLOSE c_get_name;
390: END IF;
391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
392: END get_System_Timezone;
393:
394: ---------------------------------------------------------------------
395: -- PROCEDURE

Line 419: x_return_status := FND_API.G_RET_STS_SUCCESS;

415: -- where TIMEZONE_ID = l_time_id;
416:
417: BEGIN
418: -- Initialize API return status to success
419: x_return_status := FND_API.G_RET_STS_SUCCESS;
420: l_user_time_id := FND_PROFILE.VALUE('AMS_USER_TIMEZONE_ID');
421: OPEN get_name(l_user_time_id);
422: FETCH get_name into l_user_time_name;
423: IF (get_name%NOTFOUND) THEN

Line 425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

421: OPEN get_name(l_user_time_id);
422: FETCH get_name into l_user_time_name;
423: IF (get_name%NOTFOUND) THEN
424: CLOSE get_name;
425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
426: return;
427: END IF;
428: CLOSE get_name;
429:

Line 437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

433: WHEN NO_DATA_FOUND THEN
434: IF (get_name%ISOPEN) THEN
435: CLOSE get_name;
436: END IF;
437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
438: END get_User_Timezone;
439:
440: -------------------------------------------------------------------------------------------------
441: -- PROCEDURE

Line 449: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

445: -- This procedure will take the user timezone and the input time, depending on the parameter
446: -- p_convert_type it will convert the input time to System timezone or sent Usertimezone
447: ---------------------------------------------------------------------------------------------------
448: PROCEDURE Convert_Timezone(
449: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
450: x_return_status OUT NOCOPY VARCHAR2,
451: x_msg_count OUT NOCOPY NUMBER,
452: x_msg_data OUT NOCOPY VARCHAR2,
453:

Line 472: x_return_status := FND_API.G_RET_STS_SUCCESS;

468: l_to_timezone_id NUMBEr ;
469: BEGIN
470:
471: -- Initialize API return status to success
472: x_return_status := FND_API.G_RET_STS_SUCCESS;
473:
474: get_System_Timezone(
475: l_return_status,
476: l_sys_time_id,

Line 479: IF (l_return_status = FND_API.G_RET_STS_ERROR OR

475: l_return_status,
476: l_sys_time_id,
477: l_sys_time_name);
478:
479: IF (l_return_status = FND_API.G_RET_STS_ERROR OR
480: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
481: THEN
482: x_return_status := l_return_status;
483: RETURN;

Line 480: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

476: l_sys_time_id,
477: l_sys_time_name);
478:
479: IF (l_return_status = FND_API.G_RET_STS_ERROR OR
480: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
481: THEN
482: x_return_status := l_return_status;
483: RETURN;
484: END IF;

Line 496: IF (l_return_status = FND_API.G_RET_STS_ERROR OR

492: x_user_time_name => l_user_time_name
493: ) ;
494: END IF;
495:
496: IF (l_return_status = FND_API.G_RET_STS_ERROR OR
497: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
498: THEN
499: x_return_status := l_return_status;
500: RETURN;

Line 497: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

493: ) ;
494: END IF;
495:
496: IF (l_return_status = FND_API.G_RET_STS_ERROR OR
497: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
498: THEN
499: x_return_status := l_return_status;
500: RETURN;
501: END IF;

Line 578: RAISE FND_API.g_exc_unexpected_error;

574: -- operator.
575: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
576: FND_MESSAGE.set_name('AMS', 'AMS_UTIL_NO_WHERE_OPERATOR');
577: FND_MSG_PUB.add;
578: RAISE FND_API.g_exc_unexpected_error;
579: END IF;
580: ELSIF l_eq_pos > 0 AND l_not_pos = 0 THEN
581: l_curr_pos := l_eq_pos;
582: x_col_val_tbl(i).col_op := '=';

Line 749: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,

745: p_access_level_flag IN VARCHAR2 DEFAULT 'V',
746: p_interaction_level IN NUMBER DEFAULT G_INTERACTION_LEVEL_10,
747: p_comments IN VARCHAR2 DEFAULT NULL,
748: p_log_params_tbl IN PVX_UTILITY_PVT.log_params_tbl_type,
749: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
750: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
751: x_return_status OUT NOCOPY VARCHAR2,
752: x_msg_count OUT NOCOPY NUMBER,
753: x_msg_data OUT NOCOPY VARCHAR2

Line 750: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,

746: p_interaction_level IN NUMBER DEFAULT G_INTERACTION_LEVEL_10,
747: p_comments IN VARCHAR2 DEFAULT NULL,
748: p_log_params_tbl IN PVX_UTILITY_PVT.log_params_tbl_type,
749: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
750: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
751: x_return_status OUT NOCOPY VARCHAR2,
752: x_msg_count OUT NOCOPY NUMBER,
753: x_msg_data OUT NOCOPY VARCHAR2
754: )

Line 764: x_object_version_number NUMBER := FND_API.G_MISS_NUM;

760: l_history_code VARCHAR2(30);
761: l_entity_history_log_id NUMBER;
762: l_history_log_param_id NUMBER;
763:
764: x_object_version_number NUMBER := FND_API.G_MISS_NUM;
765: --x1_entity_history_log_id NUMBER :=1;
766: --x1_object_version_number NUMBER(9) := 1;
767:
768: CURSOR c_id IS

Line 792: IF FND_API.to_Boolean( p_init_msg_list )

788: /* Standard Start of API savepoint */
789: SAVEPOINT history_log_sp;
790:
791: -- Initialize message list if p_init_msg_list is set to TRUE.
792: IF FND_API.to_Boolean( p_init_msg_list )
793: THEN
794: FND_MSG_PUB.initialize;
795: END IF;
796:

Line 797: x_return_status := FND_API.g_ret_sts_success;

793: THEN
794: FND_MSG_PUB.initialize;
795: END IF;
796:
797: x_return_status := FND_API.g_ret_sts_success;
798:
799: l_lookup_type := 'PV_INTERACTION_OBJECT_TYPE';--'AMS_SYS_ARC_QUALIFIER';
800: l_lookup_code := p_arc_history_for_entity_code;
801:

Line 807: IF NOT FND_API.to_boolean(l_lookup_exists) THEN

803: l_lookup_exists := PVX_UTILITY_PVT.check_lookup_exists( p_lookup_table_name => 'PV_LOOKUPS',
804: p_lookup_type => l_lookup_type,
805: p_lookup_code => l_lookup_code );
806:
807: IF NOT FND_API.to_boolean(l_lookup_exists) THEN
808: x_return_status := FND_API.g_ret_sts_error;
809: FND_MESSAGE.set_name('PV', 'PV_INVALID_LOOKUP_CODE');
810: FND_MESSAGE.set_token('LOOKUP_TYPE', l_lookup_type );
811: FND_MESSAGE.set_token('LOOKUP_CODE', l_lookup_code );

Line 808: x_return_status := FND_API.g_ret_sts_error;

804: p_lookup_type => l_lookup_type,
805: p_lookup_code => l_lookup_code );
806:
807: IF NOT FND_API.to_boolean(l_lookup_exists) THEN
808: x_return_status := FND_API.g_ret_sts_error;
809: FND_MESSAGE.set_name('PV', 'PV_INVALID_LOOKUP_CODE');
810: FND_MESSAGE.set_token('LOOKUP_TYPE', l_lookup_type );
811: FND_MESSAGE.set_token('LOOKUP_CODE', l_lookup_code );
812: FND_MSG_PUB.add;

Line 815: IF x_return_status = FND_API.g_ret_sts_error THEN

811: FND_MESSAGE.set_token('LOOKUP_CODE', l_lookup_code );
812: FND_MSG_PUB.add;
813: END IF;
814:
815: IF x_return_status = FND_API.g_ret_sts_error THEN
816: RAISE FND_API.g_exc_error;
817: END IF;
818:
819: l_lookup_type := 'PV_HISTORY_CATEGORY';

Line 816: RAISE FND_API.g_exc_error;

812: FND_MSG_PUB.add;
813: END IF;
814:
815: IF x_return_status = FND_API.g_ret_sts_error THEN
816: RAISE FND_API.g_exc_error;
817: END IF;
818:
819: l_lookup_type := 'PV_HISTORY_CATEGORY';
820: l_lookup_code := p_history_category_code;

Line 829: IF NOT FND_API.to_boolean(l_history_code) THEN

825: p_lookup_code => l_lookup_code );
826:
827:
828:
829: IF NOT FND_API.to_boolean(l_history_code) THEN
830: x_return_status := FND_API.g_ret_sts_error;
831: FND_MESSAGE.set_name('PV', 'PV_INVALID_LOOKUP_CODE');
832: FND_MESSAGE.set_token('LOOKUP_TYPE',l_lookup_type );
833: FND_MESSAGE.set_token('LOOKUP_CODE',l_lookup_code );

Line 830: x_return_status := FND_API.g_ret_sts_error;

826:
827:
828:
829: IF NOT FND_API.to_boolean(l_history_code) THEN
830: x_return_status := FND_API.g_ret_sts_error;
831: FND_MESSAGE.set_name('PV', 'PV_INVALID_LOOKUP_CODE');
832: FND_MESSAGE.set_token('LOOKUP_TYPE',l_lookup_type );
833: FND_MESSAGE.set_token('LOOKUP_CODE',l_lookup_code );
834: FND_MSG_PUB.add;

Line 837: IF x_return_status = FND_API.g_ret_sts_error THEN

833: FND_MESSAGE.set_token('LOOKUP_CODE',l_lookup_code );
834: FND_MSG_PUB.add;
835: END IF;
836:
837: IF x_return_status = FND_API.g_ret_sts_error THEN
838: RAISE FND_API.g_exc_error;
839: END IF;
840:
841:

Line 838: RAISE FND_API.g_exc_error;

834: FND_MSG_PUB.add;
835: END IF;
836:
837: IF x_return_status = FND_API.g_ret_sts_error THEN
838: RAISE FND_API.g_exc_error;
839: END IF;
840:
841:
842: OPEN c_message_code(p_message_code);

Line 846: x_return_status := FND_API.g_ret_sts_error;

842: OPEN c_message_code(p_message_code);
843: FETCH c_message_code INTO l_exists;
844: IF c_message_code%NOTFOUND THEN
845: CLOSE c_message_code;
846: x_return_status := FND_API.g_ret_sts_error;
847: FND_MESSAGE.set_name('PV', 'PV_INVALID_MESSAGE_CODE');
848: FND_MESSAGE.set_token('MESSAGE_CODE',p_message_code );
849: FND_MSG_PUB.add;
850: RAISE FND_API.g_exc_error;

Line 850: RAISE FND_API.g_exc_error;

846: x_return_status := FND_API.g_ret_sts_error;
847: FND_MESSAGE.set_name('PV', 'PV_INVALID_MESSAGE_CODE');
848: FND_MESSAGE.set_token('MESSAGE_CODE',p_message_code );
849: FND_MSG_PUB.add;
850: RAISE FND_API.g_exc_error;
851: ELSE
852: CLOSE c_message_code;
853: END IF;
854:

Line 906: ( p_encoded => FND_API.G_FALSE,

902:
903:
904:
905: FND_MSG_PUB.Count_And_Get
906: ( p_encoded => FND_API.G_FALSE,
907: p_count => x_msg_count,
908: p_data => x_msg_data
909: );
910:

Line 912: IF FND_API.to_Boolean( p_commit ) THEN

908: p_data => x_msg_data
909: );
910:
911: -- Standard check for p_commit
912: IF FND_API.to_Boolean( p_commit ) THEN
913: COMMIT WORK;
914: END IF;
915:
916: EXCEPTION

Line 917: WHEN FND_API.g_exc_error THEN

913: COMMIT WORK;
914: END IF;
915:
916: EXCEPTION
917: WHEN FND_API.g_exc_error THEN
918: ROLLBACK TO history_log_sp;
919: x_return_status := FND_API.g_ret_sts_error;
920: FND_MSG_PUB.count_and_get (
921: p_encoded => FND_API.g_false

Line 919: x_return_status := FND_API.g_ret_sts_error;

915:
916: EXCEPTION
917: WHEN FND_API.g_exc_error THEN
918: ROLLBACK TO history_log_sp;
919: x_return_status := FND_API.g_ret_sts_error;
920: FND_MSG_PUB.count_and_get (
921: p_encoded => FND_API.g_false
922: ,p_count => x_msg_count
923: ,p_data => x_msg_data

Line 921: p_encoded => FND_API.g_false

917: WHEN FND_API.g_exc_error THEN
918: ROLLBACK TO history_log_sp;
919: x_return_status := FND_API.g_ret_sts_error;
920: FND_MSG_PUB.count_and_get (
921: p_encoded => FND_API.g_false
922: ,p_count => x_msg_count
923: ,p_data => x_msg_data
924: );
925:

Line 926: WHEN FND_API.g_exc_unexpected_error THEN

922: ,p_count => x_msg_count
923: ,p_data => x_msg_data
924: );
925:
926: WHEN FND_API.g_exc_unexpected_error THEN
927: ROLLBACK TO history_log_sp;
928: x_return_status := FND_API.g_ret_sts_unexp_error ;
929: FND_MSG_PUB.count_and_get (
930: p_encoded => FND_API.g_false

Line 928: x_return_status := FND_API.g_ret_sts_unexp_error ;

924: );
925:
926: WHEN FND_API.g_exc_unexpected_error THEN
927: ROLLBACK TO history_log_sp;
928: x_return_status := FND_API.g_ret_sts_unexp_error ;
929: FND_MSG_PUB.count_and_get (
930: p_encoded => FND_API.g_false
931: ,p_count => x_msg_count
932: ,p_data => x_msg_data

Line 930: p_encoded => FND_API.g_false

926: WHEN FND_API.g_exc_unexpected_error THEN
927: ROLLBACK TO history_log_sp;
928: x_return_status := FND_API.g_ret_sts_unexp_error ;
929: FND_MSG_PUB.count_and_get (
930: p_encoded => FND_API.g_false
931: ,p_count => x_msg_count
932: ,p_data => x_msg_data
933: );
934: WHEN OTHERS THEN

Line 936: x_return_status := FND_API.g_ret_sts_unexp_error ;

932: ,p_data => x_msg_data
933: );
934: WHEN OTHERS THEN
935: ROLLBACK TO history_log_sp;
936: x_return_status := FND_API.g_ret_sts_unexp_error ;
937: FND_MSG_PUB.count_and_get(
938: p_encoded => FND_API.g_false
939: ,p_count => x_msg_count
940: ,p_data => x_msg_data

Line 938: p_encoded => FND_API.g_false

934: WHEN OTHERS THEN
935: ROLLBACK TO history_log_sp;
936: x_return_status := FND_API.g_ret_sts_unexp_error ;
937: FND_MSG_PUB.count_and_get(
938: p_encoded => FND_API.g_false
939: ,p_count => x_msg_count
940: ,p_data => x_msg_data
941: );
942: END create_history_log;