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

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

109: END IF;
110:
111: -- Debug Message
112: IF (PV_DEBUG_HIGH_ON) THEN
113: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
114: END IF;
115:
116: -- Initialize API return status to SUCCESS
117: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 125: PVX_UTILITY_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

121: -- =========================================================================
122:
123: IF FND_GLOBAL.USER_ID IS NULL
124: THEN
125: PVX_UTILITY_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
126: RAISE FND_API.G_EXC_ERROR;
127: END IF;
128:
129: -- Local variable initialization

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

140:
141:
142: -- Debug Message
143: IF (PV_DEBUG_HIGH_ON) THEN
144: PVX_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
145: END IF;
146:
147: -- Invoke table handler(Pv_BTCH_Chg_Prtnrs_Pkg.Insert_Row)
148: PV_BATCH_CHG_PRTNR_PKG.Insert_Row(

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

181:
182:
183: -- Debug Message
184: IF (PV_DEBUG_HIGH_ON) THEN
185: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
186: END IF;
187:
188:
189: -- Standard call to get message count and if count is 1, get message info.

Line 196: WHEN PVX_UTILITY_PVT.resource_locked THEN

192: p_data => x_msg_data
193: );
194: EXCEPTION
195:
196: WHEN PVX_UTILITY_PVT.resource_locked THEN
197: x_return_status := FND_API.g_ret_sts_error;
198: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
199:
200: WHEN FND_API.G_EXC_ERROR THEN

Line 198: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

194: EXCEPTION
195:
196: WHEN PVX_UTILITY_PVT.resource_locked THEN
197: x_return_status := FND_API.g_ret_sts_error;
198: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
199:
200: WHEN FND_API.G_EXC_ERROR THEN
201: ROLLBACK TO Create_Batch_Chg_Partners;
202: x_return_status := FND_API.G_RET_STS_ERROR;

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

327:
328:
329: -- Debug Message
330: IF (PV_DEBUG_HIGH_ON) THEN
331: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
332: END IF;
333:
334:
335:

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

337: x_return_status := FND_API.G_RET_STS_SUCCESS;
338:
339: -- Debug Message
340: IF (PV_DEBUG_HIGH_ON) THEN
341: PVX_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
342: END IF;
343:
344: OPEN c_get_BTCH_Chg_Prtnrs( l_tar_BTCH_Chg_Prtnrs_rec.partner_id);
345:

Line 349: PVX_UTILITY_PVT.Error_Message(

345:
346: FETCH c_get_BTCH_Chg_Prtnrs INTO l_ref_BTCH_Chg_Prtnrs_rec ;
347:
348: IF ( c_get_BTCH_Chg_Prtnrs%NOTFOUND) THEN
349: PVX_UTILITY_PVT.Error_Message(
350: p_message_name => 'API_MISSING_UPDATE_TARGET',
351: p_token_name => 'INFO',
352: p_token_value => 'PV_TAP_BATCH_CHG_PARTNERS') ;
353: RAISE FND_API.G_EXC_ERROR;

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

354: END IF;
355:
356: -- Debug Message
357: IF (PV_DEBUG_HIGH_ON) THEN
358: PVX_UTILITY_PVT.debug_message('Private API: - Close Cursor');
359: END IF;
360:
361: CLOSE c_get_BTCH_Chg_Prtnrs;
362:

Line 366: PVX_UTILITY_PVT.Error_Message(

362:
363:
364: If (l_tar_btch_Chg_Prtnrs_rec.object_version_number is NULL or
365: l_tar_btch_Chg_Prtnrs_rec.object_version_number = FND_API.G_MISS_NUM ) Then
366: PVX_UTILITY_PVT.Error_Message(
367: p_message_name => 'API_VERSION_MISSING',
368: p_token_name => 'COLUMN',
369: p_token_value => 'object_version_number') ;
370: raise FND_API.G_EXC_ERROR;

Line 375: PVX_UTILITY_PVT.Error_Message(

371: End if;
372:
373: -- Chk Whether record has been changed by someone else
374: IF (l_tar_BTCH_Chg_Prtnrs_rec.object_version_number <> l_ref_BTCH_Chg_Prtnrs_rec.object_version_number) THEN
375: PVX_UTILITY_PVT.Error_Message(
376: p_message_name => 'API_RECORD_CHANGED',
377: p_token_name => 'INFO',
378: p_token_value => 'BTCH_Chg_Prtnrs') ;
379: raise FND_API.G_EXC_ERROR;

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

404: END IF;
405:
406: -- Debug Message
407: IF (PV_DEBUG_HIGH_ON) THEN
408: PVX_UTILITY_PVT.debug_message('Private API: Calling update table handler');
409: END IF;
410:
411: -- Invoke table handler(Pv_BTCH_Chg_Prtnrs_Pkg.Update_Row)
412: PV_BATCH_CHG_PRTNR_PKG.Update_Row(

Line 426: PVX_UTILITY_PVT.debug_message('+++++++++++++++++++++++++++++++++x_return_status =>'||x_return_status);

422: p_processed_flag => p_batch_chg_prtnrs_rec.processed_flag,
423: p_vad_partner_id => p_batch_chg_prtnrs_rec.vad_partner_id,
424: x_return_status => x_return_status );
425:
426: PVX_UTILITY_PVT.debug_message('+++++++++++++++++++++++++++++++++x_return_status =>'||x_return_status);
427:
428: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
429: RAISE FND_API.G_EXC_ERROR;
430: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

443: END IF;
444:
445: -- Debug Message
446: IF (PV_DEBUG_HIGH_ON) THEN
447: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
448: END IF;
449:
450: -- Standard call to get message count and if count is 1, get message info.
451: FND_MSG_PUB.Count_And_Get

Line 457: WHEN PVX_UTILITY_PVT.resource_locked THEN

453: p_data => x_msg_data
454: );
455: EXCEPTION
456:
457: WHEN PVX_UTILITY_PVT.resource_locked THEN
458: x_return_status := FND_API.g_ret_sts_error;
459: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
460:
461: WHEN FND_API.G_EXC_ERROR THEN

Line 459: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

455: EXCEPTION
456:
457: WHEN PVX_UTILITY_PVT.resource_locked THEN
458: x_return_status := FND_API.g_ret_sts_error;
459: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
460:
461: WHEN FND_API.G_EXC_ERROR THEN
462: ROLLBACK TO UPDATE_BTCH_Chg_Prtnrs_PVT;
463: x_return_status := FND_API.G_RET_STS_ERROR;

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

573:
574:
575: -- Debug Message
576: IF (PV_DEBUG_HIGH_ON) THEN
577: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
578: END IF;
579:
580: -- Initialize API return status to SUCCESS
581: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

585: --
586:
587: -- Debug Message
588: IF (PV_DEBUG_HIGH_ON) THEN
589: PVX_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
590: END IF;
591:
592: -- Invoke table handler(Pv_BTCH_Chg_Prtnrs_Pkg.Delete_Row)
593: PV_BATCH_CHG_PRTNR_PKG.Delete_Row(

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

612: END IF;
613:
614: -- Debug Message
615: IF (PV_DEBUG_HIGH_ON) THEN
616: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
617: END IF;
618:
619: -- Standard call to get message count and if count is 1, get message info.
620: FND_MSG_PUB.Count_And_Get

Line 627: WHEN PVX_UTILITY_PVT.resource_locked THEN

623: );
624:
625: EXCEPTION
626:
627: WHEN PVX_UTILITY_PVT.resource_locked THEN
628: x_return_status := FND_API.g_ret_sts_error;
629: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
630:
631: WHEN FND_API.G_EXC_ERROR THEN

Line 629: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

625: EXCEPTION
626:
627: WHEN PVX_UTILITY_PVT.resource_locked THEN
628: x_return_status := FND_API.g_ret_sts_error;
629: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
630:
631: WHEN FND_API.G_EXC_ERROR THEN
632: ROLLBACK TO DELETE_BTCH_Chg_Prtnrs_PVT;
633: x_return_status := FND_API.G_RET_STS_ERROR;

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

725: BEGIN
726:
727: -- Debug Message
728: IF (PV_DEBUG_HIGH_ON) THEN
729: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
730: END IF;
731:
732:
733: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 770: PVX_UTILITY_PVT.debug_message(l_full_name ||': end');

766: p_data => x_msg_data);
767:
768: -- Debug Message
769: IF (PV_DEBUG_HIGH_ON) THEN
770: PVX_UTILITY_PVT.debug_message(l_full_name ||': end');
771: END IF;
772:
773: EXCEPTION
774:

Line 775: WHEN PVX_UTILITY_PVT.resource_locked THEN

771: END IF;
772:
773: EXCEPTION
774:
775: WHEN PVX_UTILITY_PVT.resource_locked THEN
776: x_return_status := FND_API.g_ret_sts_error;
777: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
778:
779: WHEN FND_API.G_EXC_ERROR THEN

Line 777: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

773: EXCEPTION
774:
775: WHEN PVX_UTILITY_PVT.resource_locked THEN
776: x_return_status := FND_API.g_ret_sts_error;
777: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
778:
779: WHEN FND_API.G_EXC_ERROR THEN
780: ROLLBACK TO LOCK_BTCH_Chg_Prtnrs_PVT;
781: x_return_status := FND_API.G_RET_STS_ERROR;

Line 833: l_valid_flag := PVX_UTILITY_PVT.Check_uniqueness(

829: x_return_status := FND_API.g_ret_sts_success;
830: IF p_validation_mode = JTF_PLSQL_API.g_create
831: AND p_batch_chg_prtnrs_rec.partner_id IS NOT NULL
832: THEN
833: l_valid_flag := PVX_UTILITY_PVT.Check_uniqueness(
834: 'pv_tap_batch_chg_partners',
835: 'partner_id = ''' || p_batch_chg_prtnrs_rec.partner_id ||''''
836: );
837: END IF;

Line 861: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'PARTNER_ID' );

857: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
858:
859: -- Check for required column PARTNER_ID
860: IF p_batch_chg_prtnrs_rec.partner_id = FND_API.G_MISS_NUM OR p_batch_chg_prtnrs_rec.partner_id IS NULL THEN
861: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'PARTNER_ID' );
862: x_return_status := FND_API.g_ret_sts_error;
863: END IF;
864:
865: ELSE

Line 869: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'PARTNER_ID' );

865: ELSE
866:
867: -- Check for required column PARTNER_ID
868: IF p_batch_chg_prtnrs_rec.partner_id = FND_API.G_MISS_NUM THEN
869: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'PARTNER_ID' );
870: x_return_status := FND_API.g_ret_sts_error;
871: END IF;
872:
873: END IF;

Line 901: PVX_UTILITY_PVT.Error_Message('PV_PARTNER_NOT_ACTIVE');

897: FETCH l_chk_partner_active_csr INTO l_partner_active;
898:
899: IF l_chk_partner_active_csr%NOTFOUND THEN
900: CLOSE l_chk_partner_active_csr ;
901: PVX_UTILITY_PVT.Error_Message('PV_PARTNER_NOT_ACTIVE');
902: x_return_status := FND_API.g_ret_sts_error;
903: ELSE
904: CLOSE l_chk_partner_active_csr ;
905: END IF;

Line 1116: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'Start');

1112: END IF;
1113:
1114: -- Debug Message
1115: IF (PV_DEBUG_HIGH_ON) THEN
1116: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'Start');
1117: END IF;
1118:
1119: -- Initialize message list if p_init_msg_list is set to TRUE.
1120: IF FND_API.to_Boolean( p_init_msg_list )

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

1168: END IF;
1169:
1170: -- Debug Message
1171: IF (PV_DEBUG_HIGH_ON) THEN
1172: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1173: END IF;
1174:
1175:
1176: -- Standard call to get message count and if count is 1, get message info.

Line 1183: WHEN PVX_UTILITY_PVT.resource_locked THEN

1179: p_data => x_msg_data
1180: );
1181: EXCEPTION
1182:
1183: WHEN PVX_UTILITY_PVT.resource_locked THEN
1184: x_return_status := FND_API.g_ret_sts_error;
1185: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1186:
1187: WHEN FND_API.G_EXC_ERROR THEN

Line 1185: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

1181: EXCEPTION
1182:
1183: WHEN PVX_UTILITY_PVT.resource_locked THEN
1184: x_return_status := FND_API.g_ret_sts_error;
1185: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1186:
1187: WHEN FND_API.G_EXC_ERROR THEN
1188: ROLLBACK TO VALIDATE_BTCH_Chg_Prtnrs_;
1189: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1253: PVX_UTILITY_PVT.Error_Message('PV_INVALID_FLAG');

1249: -- x_return_status := FND_API.G_RET_STS_ERROR;
1250:
1251: IF ( NOT( p_batch_chg_prtnrs_rec.processed_flag = 'P' OR
1252: p_batch_chg_prtnrs_rec.processed_flag = 'S')) THEN
1253: PVX_UTILITY_PVT.Error_Message('PV_INVALID_FLAG');
1254: x_return_status := FND_API.G_RET_STS_ERROR;
1255: END IF;
1256:
1257: -- Debug Message

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

1255: END IF;
1256:
1257: -- Debug Message
1258: IF (PV_DEBUG_HIGH_ON) THEN
1259: PVX_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1260: END IF;
1261:
1262: -- Standard call to get message count and if count is 1, get message info.
1263: FND_MSG_PUB.Count_And_Get