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_PG_INVITE_HEADERS_PVT dependencies on PVX_UTILITY_PVT

Line 132: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

128:
129: -- Debug Message
130: IF (PV_DEBUG_HIGH_ON) THEN
131:
132: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
133: END IF;
134: --DBMS_OUTPUT.PUT_LINE('Private API: ' || l_api_name || 'start');
135:
136:

Line 147: PVX_UTility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

143: -- =========================================================================
144:
145: IF FND_GLOBAL.USER_ID IS NULL
146: THEN
147: PVX_UTility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
148: RAISE FND_API.G_EXC_ERROR;
149: END IF;
150:
151: --DBMS_OUTPUT.PUT_LINE('Control is before validation level');

Line 158: PVX_UTILITY_PVT.debug_message('Private API: Validate_Invite_Headers');

154: THEN
155: -- Debug message
156: IF (PV_DEBUG_HIGH_ON) THEN
157:
158: PVX_UTILITY_PVT.debug_message('Private API: Validate_Invite_Headers');
159: END IF;
160:
161: -- Invoke validation procedures
162: Validate_invite_headers(

Line 200: PVX_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');

196:
197: -- Debug Message
198: IF (PV_DEBUG_HIGH_ON) THEN
199:
200: PVX_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
201: END IF;
202:
203: --DBMS_OUTPUT.PUT_LINE('Private API: Calling create table handler');
204: -- Invoke table handler(Pv_Pg_Invite_Headers_Pkg.Insert_Row)

Line 245: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

241:
242: -- Debug Message
243: IF (PV_DEBUG_HIGH_ON) THEN
244:
245: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
246: END IF;
247:
248:
249: -- Standard call to get message count and if count is 1, get message info.

Line 256: WHEN PVX_UTility_PVT.resource_locked THEN

252: p_data => x_msg_data
253: );
254: EXCEPTION
255:
256: WHEN PVX_UTility_PVT.resource_locked THEN
257: x_return_status := FND_API.g_ret_sts_error;
258: PVX_UTility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
259:
260: WHEN FND_API.G_EXC_ERROR THEN

Line 258: PVX_UTility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

254: EXCEPTION
255:
256: WHEN PVX_UTility_PVT.resource_locked THEN
257: x_return_status := FND_API.g_ret_sts_error;
258: PVX_UTility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
259:
260: WHEN FND_API.G_EXC_ERROR THEN
261: ROLLBACK TO CREATE_Invite_Headers_PVT;
262: x_return_status := FND_API.G_RET_STS_ERROR;

Line 386: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

382:
383: -- Debug Message
384: IF (PV_DEBUG_HIGH_ON) THEN
385:
386: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
387: END IF;
388:
389:
390:

Line 397: PVX_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');

393:
394: -- Debug Message
395: IF (PV_DEBUG_HIGH_ON) THEN
396:
397: PVX_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
398: END IF;
399:
400: OPEN c_get_Invite_Headers( l_tar_invite_headers_rec.invite_header_id);
401:

Line 405: PVX_UTility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',

401:
402: FETCH c_get_Invite_Headers INTO l_ref_invite_headers_rec ;
403:
404: If ( c_get_Invite_Headers%NOTFOUND) THEN
405: PVX_UTility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
406: p_token_name => 'INFO',
407: p_token_value => 'Invite_Headers') ;
408: RAISE FND_API.G_EXC_ERROR;
409: END IF;

Line 413: PVX_UTILITY_PVT.debug_message('Private API: - Close Cursor');

409: END IF;
410: -- Debug Message
411: IF (PV_DEBUG_HIGH_ON) THEN
412:
413: PVX_UTILITY_PVT.debug_message('Private API: - Close Cursor');
414: END IF;
415: CLOSE c_get_Invite_Headers;
416:
417:

Line 420: PVX_UTility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',

416:
417:
418: If (l_tar_invite_headers_rec.object_version_number is NULL or
419: l_tar_invite_headers_rec.object_version_number = FND_API.G_MISS_NUM ) Then
420: PVX_UTility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
421: p_token_name => 'COLUMN',
422: p_token_value => 'Last_Update_Date') ;
423: raise FND_API.G_EXC_ERROR;
424: End if;

Line 427: PVX_UTility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',

423: raise FND_API.G_EXC_ERROR;
424: End if;
425: -- Check Whether record has been changed by someone else
426: If (l_tar_invite_headers_rec.object_version_number <> l_ref_invite_headers_rec.object_version_number) Then
427: PVX_UTility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
428: p_token_name => 'INFO',
429: p_token_value => 'Invite_Headers') ;
430: raise FND_API.G_EXC_ERROR;
431: End if;

Line 439: PVX_UTILITY_PVT.debug_message('Private API: Validate_Invite_Headers');

435: THEN
436: -- Debug message
437: IF (PV_DEBUG_HIGH_ON) THEN
438:
439: PVX_UTILITY_PVT.debug_message('Private API: Validate_Invite_Headers');
440: END IF;
441:
442: -- Invoke validation procedures
443: Validate_invite_headers(

Line 462: PVX_UTILITY_PVT.debug_message('Private API: Calling update table handler');

458:
459: -- Debug Message
460: IF (PV_DEBUG_HIGH_ON) THEN
461:
462: PVX_UTILITY_PVT.debug_message('Private API: Calling update table handler');
463: END IF;
464:
465: -- Invoke table handler(Pv_Pg_Invite_Headers_Pkg.Update_Row)
466: Pv_Pg_Invite_Headers_Pkg.Update_Row(

Line 496: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

492:
493: -- Debug Message
494: IF (PV_DEBUG_HIGH_ON) THEN
495:
496: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
497: END IF;
498:
499:
500: -- Standard call to get message count and if count is 1, get message info.

Line 507: WHEN PVX_UTility_PVT.resource_locked THEN

503: p_data => x_msg_data
504: );
505: EXCEPTION
506:
507: WHEN PVX_UTility_PVT.resource_locked THEN
508: x_return_status := FND_API.g_ret_sts_error;
509: PVX_UTility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
510:
511: WHEN FND_API.G_EXC_ERROR THEN

Line 509: PVX_UTility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

505: EXCEPTION
506:
507: WHEN PVX_UTility_PVT.resource_locked THEN
508: x_return_status := FND_API.g_ret_sts_error;
509: PVX_UTility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
510:
511: WHEN FND_API.G_EXC_ERROR THEN
512: ROLLBACK TO UPDATE_Invite_Headers_PVT;
513: x_return_status := FND_API.G_RET_STS_ERROR;

Line 623: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

619:
620: -- Debug Message
621: IF (PV_DEBUG_HIGH_ON) THEN
622:
623: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
624: END IF;
625:
626:
627:

Line 637: PVX_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');

633: --
634: -- Debug Message
635: IF (PV_DEBUG_HIGH_ON) THEN
636:
637: PVX_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
638: END IF;
639:
640: -- Invoke table handler(Pv_Pg_Invite_Headers_Pkg.Delete_Row)
641: Pv_Pg_Invite_Headers_Pkg.Delete_Row(

Line 658: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

654:
655: -- Debug Message
656: IF (PV_DEBUG_HIGH_ON) THEN
657:
658: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
659: END IF;
660:
661:
662: -- Standard call to get message count and if count is 1, get message info.

Line 669: WHEN PVX_UTility_PVT.resource_locked THEN

665: p_data => x_msg_data
666: );
667: EXCEPTION
668:
669: WHEN PVX_UTility_PVT.resource_locked THEN
670: x_return_status := FND_API.g_ret_sts_error;
671: PVX_UTility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
672:
673: WHEN FND_API.G_EXC_ERROR THEN

Line 671: PVX_UTility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

667: EXCEPTION
668:
669: WHEN PVX_UTility_PVT.resource_locked THEN
670: x_return_status := FND_API.g_ret_sts_error;
671: PVX_UTility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
672:
673: WHEN FND_API.G_EXC_ERROR THEN
674: ROLLBACK TO DELETE_Invite_Headers_PVT;
675: x_return_status := FND_API.G_RET_STS_ERROR;

Line 767: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

763:
764: -- Debug Message
765: IF (PV_DEBUG_HIGH_ON) THEN
766:
767: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
768: END IF;
769:
770:
771: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 805: PVX_UTility_PVT.debug_message(l_full_name ||': end');

801: p_count => x_msg_count,
802: p_data => x_msg_data);
803: IF (PV_DEBUG_HIGH_ON) THEN
804:
805: PVX_UTility_PVT.debug_message(l_full_name ||': end');
806: END IF;
807: EXCEPTION
808:
809: WHEN PVX_UTility_PVT.resource_locked THEN

Line 809: WHEN PVX_UTility_PVT.resource_locked THEN

805: PVX_UTility_PVT.debug_message(l_full_name ||': end');
806: END IF;
807: EXCEPTION
808:
809: WHEN PVX_UTility_PVT.resource_locked THEN
810: x_return_status := FND_API.g_ret_sts_error;
811: PVX_UTility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
812:
813: WHEN FND_API.G_EXC_ERROR THEN

Line 811: PVX_UTility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

807: EXCEPTION
808:
809: WHEN PVX_UTility_PVT.resource_locked THEN
810: x_return_status := FND_API.g_ret_sts_error;
811: PVX_UTility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
812:
813: WHEN FND_API.G_EXC_ERROR THEN
814: ROLLBACK TO LOCK_Invite_Headers_PVT;
815: x_return_status := FND_API.G_RET_STS_ERROR;

Line 863: l_valid_flag := PVX_UTility_PVT.check_uniqueness(

859: x_return_status := FND_API.g_ret_sts_success;
860: IF p_validation_mode = JTF_PLSQL_API.g_create
861: AND p_invite_headers_rec.INVITE_HEADER_ID IS NOT NULL
862: THEN
863: l_valid_flag := PVX_UTility_PVT.check_uniqueness(
864: 'pv_pg_invite_headers_b',
865: 'INVITE_HEADER_ID = ''' || p_invite_headers_rec.INVITE_HEADER_ID ||''''
866: );
867: END IF;

Line 870: PVX_UTility_PVT.Error_Message(p_message_name => 'Pv_Pg_Invite_HEADER_ID_DUPLICATE');

866: );
867: END IF;
868:
869: IF l_valid_flag = FND_API.g_false THEN
870: PVX_UTility_PVT.Error_Message(p_message_name => 'Pv_Pg_Invite_HEADER_ID_DUPLICATE');
871: x_return_status := FND_API.g_ret_sts_error;
872: END IF;
873:
874: END check_Invite_Headers_Uk_Items;

Line 891: PVX_UTility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'INVITE_HEADER_ID' );

887: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
888:
889:
890: IF p_invite_headers_rec.invite_header_id = FND_API.G_MISS_NUM OR p_invite_headers_rec.invite_header_id IS NULL THEN
891: PVX_UTility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'INVITE_HEADER_ID' );
892: x_return_status := FND_API.g_ret_sts_error;
893: END IF;
894:
895:

Line 897: PVX_UTility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );

893: END IF;
894:
895:
896: IF p_invite_headers_rec.object_version_number = FND_API.G_MISS_NUM OR p_invite_headers_rec.object_version_number IS NULL THEN
897: PVX_UTility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );
898: x_return_status := FND_API.g_ret_sts_error;
899: END IF;
900:
901:

Line 903: PVX_UTility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'INVITE_FOR_PROGRAM_ID' );

899: END IF;
900:
901:
902: IF p_invite_headers_rec.invite_for_program_id = FND_API.G_MISS_NUM OR p_invite_headers_rec.invite_for_program_id IS NULL THEN
903: PVX_UTility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'INVITE_FOR_PROGRAM_ID' );
904: x_return_status := FND_API.g_ret_sts_error;
905: END IF;
906:
907:

Line 909: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'PARTNER_ID' );

905: END IF;
906:
907:
908: IF p_invite_headers_rec.partner_id = FND_API.G_MISS_NUM OR p_invite_headers_rec.partner_id IS NULL THEN
909: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'PARTNER_ID' );
910: x_return_status := FND_API.g_ret_sts_error;
911: END IF;
912:
913: ELSE

Line 917: PVX_UTility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'INVITE_HEADER_ID' );

913: ELSE
914:
915:
916: IF p_invite_headers_rec.invite_header_id = FND_API.G_MISS_NUM THEN
917: PVX_UTility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'INVITE_HEADER_ID' );
918: x_return_status := FND_API.g_ret_sts_error;
919: END IF;
920:
921:

Line 923: PVX_UTility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );

919: END IF;
920:
921:
922: IF p_invite_headers_rec.object_version_number = FND_API.G_MISS_NUM THEN
923: PVX_UTility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );
924: x_return_status := FND_API.g_ret_sts_error;
925: END IF;
926:
927:

Line 929: PVX_UTility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'INVITE_FOR_PROGRAM_ID' );

925: END IF;
926:
927:
928: IF p_invite_headers_rec.invite_for_program_id = FND_API.G_MISS_NUM THEN
929: PVX_UTility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'INVITE_FOR_PROGRAM_ID' );
930: x_return_status := FND_API.g_ret_sts_error;
931: END IF;
932:
933: IF p_invite_headers_rec.partner_id = FND_API.G_MISS_NUM THEN

Line 934: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'PARTNER_ID' );

930: x_return_status := FND_API.g_ret_sts_error;
931: END IF;
932:
933: IF p_invite_headers_rec.partner_id = FND_API.G_MISS_NUM THEN
934: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'PARTNER_ID' );
935: x_return_status := FND_API.g_ret_sts_error;
936: END IF;
937:
938: END IF;

Line 1225: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

1221:
1222: -- Debug Message
1223: IF (PV_DEBUG_HIGH_ON) THEN
1224:
1225: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1226: END IF;
1227:
1228:
1229:

Line 1237: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

1233:
1234: -- Debug Message
1235: IF (PV_DEBUG_HIGH_ON) THEN
1236:
1237: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1238: END IF;
1239:
1240:
1241: -- Standard call to get message count and if count is 1, get message info.

Line 1248: WHEN PVX_UTility_PVT.resource_locked THEN

1244: p_data => x_msg_data
1245: );
1246: EXCEPTION
1247:
1248: WHEN PVX_UTility_PVT.resource_locked THEN
1249: x_return_status := FND_API.g_ret_sts_error;
1250: PVX_UTility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1251:
1252: WHEN FND_API.G_EXC_ERROR THEN

Line 1250: PVX_UTility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

1246: EXCEPTION
1247:
1248: WHEN PVX_UTility_PVT.resource_locked THEN
1249: x_return_status := FND_API.g_ret_sts_error;
1250: PVX_UTility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1251:
1252: WHEN FND_API.G_EXC_ERROR THEN
1253: ROLLBACK TO VALIDATE_Invite_Headers_;
1254: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1317: PVX_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');

1313:
1314: -- Debug Message
1315: IF (PV_DEBUG_HIGH_ON) THEN
1316:
1317: PVX_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1318: END IF;
1319: -- Standard call to get message count and if count is 1, get message info.
1320: FND_MSG_PUB.Count_And_Get
1321: (p_count => x_msg_count,