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

Line 56: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

52:
53: EXCEPTION
54:
55: WHEN OTHERS THEN
56: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
57: END getInviteHeaderId;
58:
59:
60: --------------------------------------------------------------------------

Line 138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

134: EXCEPTION
135: WHEN NO_DATA_FOUND THEN
136: RETURN FALSE;
137: WHEN OTHERS THEN
138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
139: END isGlobalEnrolled;
140:
141: PROCEDURE new_programs
142: (

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

140:
141: PROCEDURE new_programs
142: (
143: p_api_version_number IN NUMBER
144: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
145: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
146: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
147: ,p_partner_id IN NUMBER
148: ,p_member_type IN VARCHAR2

Line 145: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

141: PROCEDURE new_programs
142: (
143: p_api_version_number IN NUMBER
144: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
145: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
146: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
147: ,p_partner_id IN NUMBER
148: ,p_member_type IN VARCHAR2
149: ,p_isprereq_eval IN VARCHAR2 :='Y'

Line 146: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

142: (
143: p_api_version_number IN NUMBER
144: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
145: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
146: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
147: ,p_partner_id IN NUMBER
148: ,p_member_type IN VARCHAR2
149: ,p_isprereq_eval IN VARCHAR2 :='Y'
150: ,x_enrq_param_cur OUT NOCOPY enrq_param_ref

Line 283: IF NOT FND_API.Compatible_API_Call ( l_api_version_number

279:
280: l_cache VARCHAR2(1);
281: BEGIN
282: --Standard call to check for call compatibility.
283: IF NOT FND_API.Compatible_API_Call ( l_api_version_number
284: ,p_api_version_number
285: ,l_api_name
286: ,G_PKG_NAME
287: )

Line 290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

286: ,G_PKG_NAME
287: )
288:
289: THEN
290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
291: END IF;
292:
293: -- Initialize message list if p_init_msg_list is set to TRUE.
294: IF FND_API.to_Boolean( p_init_msg_list )

Line 294: IF FND_API.to_Boolean( p_init_msg_list )

290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
291: END IF;
292:
293: -- Initialize message list if p_init_msg_list is set to TRUE.
294: IF FND_API.to_Boolean( p_init_msg_list )
295: THEN
296: FND_MSG_PUB.initialize;
297: END IF;
298:

Line 305: x_return_status := FND_API.G_RET_STS_SUCCESS;

301: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
302: END IF;
303: -- Initialize API return status to SUCCESS
304:
305: x_return_status := FND_API.G_RET_STS_SUCCESS;
306: --l_query_str1:= 'SELECT ''X'' FROM pv_pg_elig_programs elig WHERE elig.partner_id=' || to_char(p_partner_id) || 'AND elig.program_id =';
307: l_query_str1:= 'SELECT ''X'' FROM pv_pg_elig_programs elig WHERE elig.partner_id=:1' || 'AND elig.program_id =:2';
308:
309: IF p_isprereq_eval='Y' THEN -- This check is to query the pre_req cache data as well

Line 456: IF FND_API.to_boolean(p_commit) THEN

452:
453: OPEN x_enrq_param_cur FOR SELECT * FROM TABLE( CAST (l_enrq_param_tbl AS PV_ENRL_REQ_PARAM_TBL)) order by upper(programname) asc;
454:
455: -- Check for commit
456: IF FND_API.to_boolean(p_commit) THEN
457: COMMIT;
458: END IF;
459:
460: EXCEPTION

Line 461: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

457: COMMIT;
458: END IF;
459:
460: EXCEPTION
461: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
463: -- Standard call to get message count and if count=1, get the message
464: FND_MSG_PUB.Count_And_Get (
465: p_encoded => FND_API.G_FALSE,

Line 462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

458: END IF;
459:
460: EXCEPTION
461: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
463: -- Standard call to get message count and if count=1, get the message
464: FND_MSG_PUB.Count_And_Get (
465: p_encoded => FND_API.G_FALSE,
466: p_count => x_msg_count,

Line 465: p_encoded => FND_API.G_FALSE,

461: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
463: -- Standard call to get message count and if count=1, get the message
464: FND_MSG_PUB.Count_And_Get (
465: p_encoded => FND_API.G_FALSE,
466: p_count => x_msg_count,
467: p_data => x_msg_data
468: );
469:

Line 471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

467: p_data => x_msg_data
468: );
469:
470: WHEN OTHERS THEN
471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
472: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
473: THEN
474: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
475: END IF;

Line 478: p_encoded => FND_API.G_FALSE,

474: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
475: END IF;
476: -- Standard call to get message count and if count=1, get the message
477: FND_MSG_PUB.Count_And_Get (
478: p_encoded => FND_API.G_FALSE,
479: p_count => x_msg_count,
480: p_data => x_msg_data
481: );
482: END new_programs;

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

484:
485: PROCEDURE renewable_programs
486: (
487: p_api_version_number IN NUMBER
488: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
489: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
490: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
491: ,p_partner_id IN NUMBER
492: ,p_member_type IN VARCHAR2

Line 489: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

485: PROCEDURE renewable_programs
486: (
487: p_api_version_number IN NUMBER
488: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
489: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
490: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
491: ,p_partner_id IN NUMBER
492: ,p_member_type IN VARCHAR2
493: ,p_isprereq_eval IN VARCHAR2 :='Y'

Line 490: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

486: (
487: p_api_version_number IN NUMBER
488: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
489: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
490: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
491: ,p_partner_id IN NUMBER
492: ,p_member_type IN VARCHAR2
493: ,p_isprereq_eval IN VARCHAR2 :='Y'
494: ,x_enrq_param_cur OUT NOCOPY enrq_param_ref

Line 628: IF NOT FND_API.Compatible_API_Call ( l_api_version_number

624:
625: BEGIN
626:
627: --Standard call to check for call compatibility.
628: IF NOT FND_API.Compatible_API_Call ( l_api_version_number
629: ,p_api_version_number
630: ,l_api_name
631: ,G_PKG_NAME
632: )

Line 635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

631: ,G_PKG_NAME
632: )
633:
634: THEN
635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
636: END IF;
637:
638: -- Initialize message list if p_init_msg_list is set to TRUE.
639: IF FND_API.to_Boolean( p_init_msg_list )

Line 639: IF FND_API.to_Boolean( p_init_msg_list )

635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
636: END IF;
637:
638: -- Initialize message list if p_init_msg_list is set to TRUE.
639: IF FND_API.to_Boolean( p_init_msg_list )
640: THEN
641: FND_MSG_PUB.initialize;
642: END IF;
643:

Line 649: x_return_status := FND_API.G_RET_STS_SUCCESS;

645: IF (PV_DEBUG_HIGH_ON) THEN
646: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
647: END IF;
648: -- Initialize API return status to SUCCESS
649: x_return_status := FND_API.G_RET_STS_SUCCESS;
650: --l_query_str1:= 'SELECT ''X'' FROM pv_pg_elig_programs elig WHERE elig.partner_id=' || to_char(p_partner_id) || 'AND elig.program_id =';
651: l_query_str1:= 'SELECT ''X'' FROM pv_pg_elig_programs elig WHERE elig.partner_id=:1' || 'AND elig.program_id =:2';
652: FOR rec_p in prgm_csr1(p_partner_id) LOOP
653: l_eligible_flag:=true;

Line 742: IF FND_API.to_boolean(p_commit) THEN

738: -- open ref cursor by querying l_enrq_param_tbl once all the programs related parameters are populated in l_enrq_param_tbl.
739: Open x_enrq_param_cur for select * from TABLE(cast (l_enrq_param_tbl as PV_ENRL_REQ_PARAM_TBL)) order by upper(programname) asc;
740:
741: -- Check for commit
742: IF FND_API.to_boolean(p_commit) THEN
743: COMMIT;
744: END IF;
745:
746: EXCEPTION

Line 747: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

743: COMMIT;
744: END IF;
745:
746: EXCEPTION
747: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
749: -- Standard call to get message count and if count=1, get the message
750: FND_MSG_PUB.Count_And_Get (
751: p_encoded => FND_API.G_FALSE,

Line 748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

744: END IF;
745:
746: EXCEPTION
747: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
749: -- Standard call to get message count and if count=1, get the message
750: FND_MSG_PUB.Count_And_Get (
751: p_encoded => FND_API.G_FALSE,
752: p_count => x_msg_count,

Line 751: p_encoded => FND_API.G_FALSE,

747: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
749: -- Standard call to get message count and if count=1, get the message
750: FND_MSG_PUB.Count_And_Get (
751: p_encoded => FND_API.G_FALSE,
752: p_count => x_msg_count,
753: p_data => x_msg_data
754: );
755:

Line 757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

753: p_data => x_msg_data
754: );
755:
756: WHEN OTHERS THEN
757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
758: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
759: THEN
760: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
761: END IF;

Line 764: p_encoded => FND_API.G_FALSE,

760: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
761: END IF;
762: -- Standard call to get message count and if count=1, get the message
763: FND_MSG_PUB.Count_And_Get (
764: p_encoded => FND_API.G_FALSE,
765: p_count => x_msg_count,
766: p_data => x_msg_data
767: );
768: END renewable_programs;

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

770:
771: PROCEDURE upgradable_programs
772: (
773: p_api_version_number IN NUMBER
774: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
775: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
776: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
777: ,p_partner_id IN NUMBER
778: ,p_member_type IN VARCHAR2

Line 775: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

771: PROCEDURE upgradable_programs
772: (
773: p_api_version_number IN NUMBER
774: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
775: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
776: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
777: ,p_partner_id IN NUMBER
778: ,p_member_type IN VARCHAR2
779: ,p_isprereq_eval IN VARCHAR2 :='Y'

Line 776: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

772: (
773: p_api_version_number IN NUMBER
774: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
775: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
776: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
777: ,p_partner_id IN NUMBER
778: ,p_member_type IN VARCHAR2
779: ,p_isprereq_eval IN VARCHAR2 :='Y'
780: ,x_enrq_param_cur OUT NOCOPY enrq_param_ref

Line 919: IF NOT FND_API.Compatible_API_Call ( l_api_version_number

915:
916: BEGIN
917:
918: --Standard call to check for call compatibility.
919: IF NOT FND_API.Compatible_API_Call ( l_api_version_number
920: ,p_api_version_number
921: ,l_api_name
922: ,G_PKG_NAME
923: )

Line 926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

922: ,G_PKG_NAME
923: )
924:
925: THEN
926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
927: END IF;
928:
929: -- Initialize message list if p_init_msg_list is set to TRUE.
930: IF FND_API.to_Boolean( p_init_msg_list )

Line 930: IF FND_API.to_Boolean( p_init_msg_list )

926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
927: END IF;
928:
929: -- Initialize message list if p_init_msg_list is set to TRUE.
930: IF FND_API.to_Boolean( p_init_msg_list )
931: THEN
932: FND_MSG_PUB.initialize;
933: END IF;
934:

Line 940: x_return_status := FND_API.G_RET_STS_SUCCESS;

936: IF (PV_DEBUG_HIGH_ON) THEN
937: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
938: END IF;
939: -- Initialize API return status to SUCCESS
940: x_return_status := FND_API.G_RET_STS_SUCCESS;
941: --l_query_str1:= 'SELECT ''X'' FROM pv_pg_elig_programs elig WHERE elig.partner_id=' || to_char(p_partner_id) || 'AND elig.program_id =';
942: l_query_str1:= 'SELECT ''X'' FROM pv_pg_elig_programs elig WHERE elig.partner_id=:1' || 'AND elig.program_id =:2';
943: FOR rec_prgm in upgrd_prgm_csr(p_partner_id) LOOP
944: l_eligible_flag:=true;

Line 1028: IF FND_API.to_boolean(p_commit) THEN

1024: --We'll query l_enrq_param_tbl once all the programs related parameters are populated in l_enrq_param_tbl.
1025: Open x_enrq_param_cur for select * from TABLE(cast (l_enrq_param_tbl as PV_ENRL_REQ_PARAM_TBL)) order by upper(programname) asc;
1026:
1027: -- Check for commit
1028: IF FND_API.to_boolean(p_commit) THEN
1029: COMMIT;
1030: END IF;
1031:
1032: EXCEPTION

Line 1033: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1029: COMMIT;
1030: END IF;
1031:
1032: EXCEPTION
1033: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1035: -- Standard call to get message count and if count=1, get the message
1036: FND_MSG_PUB.Count_And_Get (
1037: p_encoded => FND_API.G_FALSE,

Line 1034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1030: END IF;
1031:
1032: EXCEPTION
1033: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1035: -- Standard call to get message count and if count=1, get the message
1036: FND_MSG_PUB.Count_And_Get (
1037: p_encoded => FND_API.G_FALSE,
1038: p_count => x_msg_count,

Line 1037: p_encoded => FND_API.G_FALSE,

1033: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1035: -- Standard call to get message count and if count=1, get the message
1036: FND_MSG_PUB.Count_And_Get (
1037: p_encoded => FND_API.G_FALSE,
1038: p_count => x_msg_count,
1039: p_data => x_msg_data
1040: );
1041:

Line 1043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1039: p_data => x_msg_data
1040: );
1041:
1042: WHEN OTHERS THEN
1043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1044: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1045: THEN
1046: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1047: END IF;

Line 1050: p_encoded => FND_API.G_FALSE,

1046: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1047: END IF;
1048: -- Standard call to get message count and if count=1, get the message
1049: FND_MSG_PUB.Count_And_Get (
1050: p_encoded => FND_API.G_FALSE,
1051: p_count => x_msg_count,
1052: p_data => x_msg_data
1053: );
1054: END upgradable_programs;

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

1056:
1057: PROCEDURE incomplete_programs
1058: (
1059: p_api_version_number IN NUMBER
1060: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1061: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1062: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1063: ,p_partner_id IN NUMBER
1064: ,p_member_type IN VARCHAR2

Line 1061: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

1057: PROCEDURE incomplete_programs
1058: (
1059: p_api_version_number IN NUMBER
1060: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1061: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1062: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1063: ,p_partner_id IN NUMBER
1064: ,p_member_type IN VARCHAR2
1065: ,p_isprereq_eval IN VARCHAR2 :='Y'

Line 1062: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

1058: (
1059: p_api_version_number IN NUMBER
1060: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1061: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1062: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1063: ,p_partner_id IN NUMBER
1064: ,p_member_type IN VARCHAR2
1065: ,p_isprereq_eval IN VARCHAR2 :='Y'
1066: ,x_enrq_param_cur OUT NOCOPY enrq_param_ref

Line 1135: IF NOT FND_API.Compatible_API_Call ( l_api_version_number

1131:
1132: BEGIN
1133:
1134: --Standard call to check for call compatibility.
1135: IF NOT FND_API.Compatible_API_Call ( l_api_version_number
1136: ,p_api_version_number
1137: ,l_api_name
1138: ,G_PKG_NAME
1139: )

Line 1142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1138: ,G_PKG_NAME
1139: )
1140:
1141: THEN
1142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1143: END IF;
1144:
1145: -- Initialize message list if p_init_msg_list is set to TRUE.
1146: IF FND_API.to_Boolean( p_init_msg_list )

Line 1146: IF FND_API.to_Boolean( p_init_msg_list )

1142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1143: END IF;
1144:
1145: -- Initialize message list if p_init_msg_list is set to TRUE.
1146: IF FND_API.to_Boolean( p_init_msg_list )
1147: THEN
1148: FND_MSG_PUB.initialize;
1149: END IF;
1150:

Line 1156: x_return_status := FND_API.G_RET_STS_SUCCESS;

1152: IF (PV_DEBUG_HIGH_ON) THEN
1153: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1154: END IF;
1155: -- Initialize API return status to SUCCESS
1156: x_return_status := FND_API.G_RET_STS_SUCCESS;
1157:
1158: -- logic to get the list of new programs that partner is eligible to see goes here.
1159: --Add each of program, add the following parameter values to the following table
1160: --l_query_str1:= 'SELECT ''X'' FROM pv_pg_elig_programs elig WHERE elig.partner_id=' || to_char(p_partner_id) || 'AND elig.program_id =';

Line 1193: IF FND_API.to_boolean(p_commit) THEN

1189: --We'll query l_enrq_param_tbl once all the programs related parameters are populated in l_enrq_param_tbl.
1190: Open x_enrq_param_cur for select * from TABLE(cast (l_enrq_param_tbl as PV_ENRL_REQ_PARAM_TBL)) order by upper(programname) asc;
1191:
1192: -- Check for commit
1193: IF FND_API.to_boolean(p_commit) THEN
1194: COMMIT;
1195: END IF;
1196:
1197: EXCEPTION

Line 1198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1194: COMMIT;
1195: END IF;
1196:
1197: EXCEPTION
1198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1200: -- Standard call to get message count and if count=1, get the message
1201: FND_MSG_PUB.Count_And_Get (
1202: p_encoded => FND_API.G_FALSE,

Line 1199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1195: END IF;
1196:
1197: EXCEPTION
1198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1200: -- Standard call to get message count and if count=1, get the message
1201: FND_MSG_PUB.Count_And_Get (
1202: p_encoded => FND_API.G_FALSE,
1203: p_count => x_msg_count,

Line 1202: p_encoded => FND_API.G_FALSE,

1198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1200: -- Standard call to get message count and if count=1, get the message
1201: FND_MSG_PUB.Count_And_Get (
1202: p_encoded => FND_API.G_FALSE,
1203: p_count => x_msg_count,
1204: p_data => x_msg_data
1205: );
1206:

Line 1208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1204: p_data => x_msg_data
1205: );
1206:
1207: WHEN OTHERS THEN
1208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1209: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1210: THEN
1211: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1212: END IF;

Line 1215: p_encoded => FND_API.G_FALSE,

1211: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1212: END IF;
1213: -- Standard call to get message count and if count=1, get the message
1214: FND_MSG_PUB.Count_And_Get (
1215: p_encoded => FND_API.G_FALSE,
1216: p_count => x_msg_count,
1217: p_data => x_msg_data
1218: );
1219: END incomplete_programs;

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

1221:
1222: PROCEDURE newAndInCompletePrograms
1223: (
1224: p_api_version_number IN NUMBER
1225: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1226: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1227: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1228: ,p_partner_id IN NUMBER
1229: ,p_member_type IN VARCHAR2

Line 1226: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

1222: PROCEDURE newAndInCompletePrograms
1223: (
1224: p_api_version_number IN NUMBER
1225: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1226: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1227: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1228: ,p_partner_id IN NUMBER
1229: ,p_member_type IN VARCHAR2
1230: ,p_isprereq_eval IN VARCHAR2 :='Y'

Line 1227: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

1223: (
1224: p_api_version_number IN NUMBER
1225: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1226: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1227: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1228: ,p_partner_id IN NUMBER
1229: ,p_member_type IN VARCHAR2
1230: ,p_isprereq_eval IN VARCHAR2 :='Y'
1231: ,x_enrq_param_cur OUT NOCOPY enrq_param_ref

Line 1257: IF NOT FND_API.Compatible_API_Call ( l_api_version_number

1253: l_vad_invite VARCHAR2(1);
1254: counter NUMBER:=1;
1255: BEGIN
1256: --Standard call to check for call compatibility.
1257: IF NOT FND_API.Compatible_API_Call ( l_api_version_number
1258: ,p_api_version_number
1259: ,l_api_name
1260: ,G_PKG_NAME
1261: )

Line 1264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1260: ,G_PKG_NAME
1261: )
1262:
1263: THEN
1264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1265: END IF;
1266:
1267: -- Initialize message list if p_init_msg_list is set to TRUE.
1268: IF FND_API.to_Boolean( p_init_msg_list )

Line 1268: IF FND_API.to_Boolean( p_init_msg_list )

1264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1265: END IF;
1266:
1267: -- Initialize message list if p_init_msg_list is set to TRUE.
1268: IF FND_API.to_Boolean( p_init_msg_list )
1269: THEN
1270: FND_MSG_PUB.initialize;
1271: END IF;
1272:

Line 1278: x_return_status := FND_API.G_RET_STS_SUCCESS;

1274: IF (PV_DEBUG_HIGH_ON) THEN
1275: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1276: END IF;
1277: -- Initialize API return status to SUCCESS
1278: x_return_status := FND_API.G_RET_STS_SUCCESS;
1279: new_programs
1280: (
1281: p_api_version_number => p_api_version_number
1282: ,p_init_msg_list => p_init_msg_list

Line 1375: IF FND_API.to_boolean(p_commit) THEN

1371: OPEN x_enrq_param_cur FOR SELECT * FROM TABLE( CAST (l_nienrq_param_tbl AS PV_ENRL_REQ_PARAM_TBL)) order by upper(programname) asc;
1372:
1373:
1374: -- Check for commit
1375: IF FND_API.to_boolean(p_commit) THEN
1376: COMMIT;
1377: END IF;
1378:
1379: EXCEPTION

Line 1380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1376: COMMIT;
1377: END IF;
1378:
1379: EXCEPTION
1380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1382: -- Standard call to get message count and if count=1, get the message
1383: FND_MSG_PUB.Count_And_Get (
1384: p_encoded => FND_API.G_FALSE,

Line 1381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1377: END IF;
1378:
1379: EXCEPTION
1380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1382: -- Standard call to get message count and if count=1, get the message
1383: FND_MSG_PUB.Count_And_Get (
1384: p_encoded => FND_API.G_FALSE,
1385: p_count => x_msg_count,

Line 1384: p_encoded => FND_API.G_FALSE,

1380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1382: -- Standard call to get message count and if count=1, get the message
1383: FND_MSG_PUB.Count_And_Get (
1384: p_encoded => FND_API.G_FALSE,
1385: p_count => x_msg_count,
1386: p_data => x_msg_data
1387: );
1388:

Line 1390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1386: p_data => x_msg_data
1387: );
1388:
1389: WHEN OTHERS THEN
1390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1391: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1392: THEN
1393: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1394: END IF;

Line 1397: p_encoded => FND_API.G_FALSE,

1393: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1394: END IF;
1395: -- Standard call to get message count and if count=1, get the message
1396: FND_MSG_PUB.Count_And_Get (
1397: p_encoded => FND_API.G_FALSE,
1398: p_count => x_msg_count,
1399: p_data => x_msg_data
1400: );
1401: END newAndInCompletePrograms;

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

1402:
1403: PROCEDURE isPartnerEligible
1404: (
1405: p_api_version_number IN NUMBER
1406: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1407: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1408: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1409: , p_partner_id IN NUMBER
1410: , p_from_program_id IN NUMBER

Line 1407: , p_commit IN VARCHAR2 := FND_API.G_FALSE

1403: PROCEDURE isPartnerEligible
1404: (
1405: p_api_version_number IN NUMBER
1406: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1407: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1408: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1409: , p_partner_id IN NUMBER
1410: , p_from_program_id IN NUMBER
1411: , p_to_program_id IN NUMBER

Line 1408: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

1404: (
1405: p_api_version_number IN NUMBER
1406: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1407: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1408: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1409: , p_partner_id IN NUMBER
1410: , p_from_program_id IN NUMBER
1411: , p_to_program_id IN NUMBER
1412: , p_enrq_type IN VARCHAR -- permitted values here are 'NEW', 'UPGRADE' for 11.5.10.

Line 1581: IF NOT FND_API.Compatible_API_Call ( l_api_version_number

1577:
1578: BEGIN
1579: SAVEPOINT isPartnerEligible;
1580: --Standard call to check for call compatibility.
1581: IF NOT FND_API.Compatible_API_Call ( l_api_version_number
1582: ,p_api_version_number
1583: ,l_api_name
1584: ,G_PKG_NAME
1585: )

Line 1588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1584: ,G_PKG_NAME
1585: )
1586:
1587: THEN
1588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1589: END IF;
1590:
1591: -- Initialize message list if p_init_msg_list is set to TRUE.
1592: IF FND_API.to_Boolean( p_init_msg_list )

Line 1592: IF FND_API.to_Boolean( p_init_msg_list )

1588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1589: END IF;
1590:
1591: -- Initialize message list if p_init_msg_list is set to TRUE.
1592: IF FND_API.to_Boolean( p_init_msg_list )
1593: THEN
1594: FND_MSG_PUB.initialize;
1595: END IF;
1596:

Line 1602: x_return_status := FND_API.G_RET_STS_SUCCESS;

1598: IF (PV_DEBUG_HIGH_ON) THEN
1599: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1600: END IF;
1601: -- Initialize API return status to SUCCESS
1602: x_return_status := FND_API.G_RET_STS_SUCCESS;
1603: x_elig_flag := 'N';
1604:
1605: --l_query_str1:= 'SELECT ''X'' FROM pv_pg_elig_programs elig WHERE elig.partner_id=' || to_char(p_partner_id) || 'AND elig.program_id='|| to_char( p_to_program_id);
1606: l_query_str1:= 'SELECT ''X'' FROM pv_pg_elig_programs elig WHERE elig.partner_id=:1' || 'AND elig.program_id =:2';

Line 1680: IF FND_API.to_boolean(p_commit) THEN

1676: IF (PV_DEBUG_HIGH_ON) THEN
1677: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1678: END IF;
1679: -- Check for commit
1680: IF FND_API.to_boolean(p_commit) THEN
1681: COMMIT;
1682: END IF;
1683:
1684: EXCEPTION

Line 1685: WHEN FND_API.G_EXC_ERROR THEN

1681: COMMIT;
1682: END IF;
1683:
1684: EXCEPTION
1685: WHEN FND_API.G_EXC_ERROR THEN
1686: ROLLBACK TO isPartnerEligible;
1687: x_return_status := FND_API.G_RET_STS_ERROR;
1688: -- Standard call to get message count and if count=1, get the message
1689: FND_MSG_PUB.Count_And_Get (

Line 1687: x_return_status := FND_API.G_RET_STS_ERROR;

1683:
1684: EXCEPTION
1685: WHEN FND_API.G_EXC_ERROR THEN
1686: ROLLBACK TO isPartnerEligible;
1687: x_return_status := FND_API.G_RET_STS_ERROR;
1688: -- Standard call to get message count and if count=1, get the message
1689: FND_MSG_PUB.Count_And_Get (
1690: p_encoded => FND_API.G_FALSE,
1691: p_count => x_msg_count,

Line 1690: p_encoded => FND_API.G_FALSE,

1686: ROLLBACK TO isPartnerEligible;
1687: x_return_status := FND_API.G_RET_STS_ERROR;
1688: -- Standard call to get message count and if count=1, get the message
1689: FND_MSG_PUB.Count_And_Get (
1690: p_encoded => FND_API.G_FALSE,
1691: p_count => x_msg_count,
1692: p_data => x_msg_data
1693: );
1694: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1694: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1690: p_encoded => FND_API.G_FALSE,
1691: p_count => x_msg_count,
1692: p_data => x_msg_data
1693: );
1694: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1695: ROLLBACK TO isPartnerEligible;
1696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1697: -- Standard call to get message count and if count=1, get the message
1698: FND_MSG_PUB.Count_And_Get (

Line 1696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1692: p_data => x_msg_data
1693: );
1694: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1695: ROLLBACK TO isPartnerEligible;
1696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1697: -- Standard call to get message count and if count=1, get the message
1698: FND_MSG_PUB.Count_And_Get (
1699: p_encoded => FND_API.G_FALSE,
1700: p_count => x_msg_count,

Line 1699: p_encoded => FND_API.G_FALSE,

1695: ROLLBACK TO isPartnerEligible;
1696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1697: -- Standard call to get message count and if count=1, get the message
1698: FND_MSG_PUB.Count_And_Get (
1699: p_encoded => FND_API.G_FALSE,
1700: p_count => x_msg_count,
1701: p_data => x_msg_data
1702: );
1703: WHEN OTHERS THEN

Line 1705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1701: p_data => x_msg_data
1702: );
1703: WHEN OTHERS THEN
1704: ROLLBACK TO isPartnerEligible;
1705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1706: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1707: THEN
1708: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1709: END IF;

Line 1712: p_encoded => FND_API.G_FALSE,

1708: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1709: END IF;
1710: -- Standard call to get message count and if count=1, get the message
1711: FND_MSG_PUB.Count_And_Get (
1712: p_encoded => FND_API.G_FALSE,
1713: p_count => x_msg_count,
1714: p_data => x_msg_data
1715: );
1716: