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.OZF_RELATED_LINES_PVT dependencies on OZF_UTILITY_PVT

Line 91: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

87: FND_MSG_PUB.initialize;
88: END IF;
89:
90: -- Debug Message
91: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
92:
93:
94: -- Initialize API return status to SUCCESS
95: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 123: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

119: -- =========================================================================
120:
121: IF FND_GLOBAL.User_Id IS NULL
122: THEN
123: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
124: RAISE FND_API.G_EXC_ERROR;
125: END IF;
126:
127: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

Line 130: OZF_UTILITY_PVT.debug_message('Private API: Validate_Related_Lines');

126:
127: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
128: THEN
129: -- Debug message
130: OZF_UTILITY_PVT.debug_message('Private API: Validate_Related_Lines');
131:
132: -- Invoke validation procedures
133: Validate_related_lines(
134: p_api_version_number => 1.0,

Line 149: OZF_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');

145: RAISE FND_API.G_EXC_ERROR;
146: END IF;
147:
148: -- Debug Message
149: OZF_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
150:
151: -- Invoke table handler(OZF_RELATED_DEAL_LINES_PKG.Insert_Row)
152: OZF_RELATED_DEAL_LINES_PKG.Insert_Row(
153: px_related_deal_lines_id => l_related_deal_lines_id,

Line 181: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

177: END IF;
178:
179:
180: -- Debug Message
181: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
182:
183: -- Standard call to get message count and if count is 1, get message info.
184: FND_MSG_PUB.Count_And_Get
185: (p_count => x_msg_count,

Line 190: WHEN OZF_Utility_PVT.resource_locked THEN

186: p_data => x_msg_data
187: );
188: EXCEPTION
189:
190: WHEN OZF_Utility_PVT.resource_locked THEN
191: x_return_status := FND_API.g_ret_sts_error;
192: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
193:
194: WHEN FND_API.G_EXC_ERROR THEN

Line 192: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

188: EXCEPTION
189:
190: WHEN OZF_Utility_PVT.resource_locked THEN
191: x_return_status := FND_API.g_ret_sts_error;
192: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
193:
194: WHEN FND_API.G_EXC_ERROR THEN
195: ROLLBACK TO CREATE_Related_Lines_PVT;
196: x_return_status := FND_API.G_RET_STS_ERROR;

Line 286: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

282: FND_MSG_PUB.initialize;
283: END IF;
284:
285: -- Debug Message
286: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
287:
288:
289: -- Initialize API return status to SUCCESS
290: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 293: OZF_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');

289: -- Initialize API return status to SUCCESS
290: x_return_status := FND_API.G_RET_STS_SUCCESS;
291:
292: -- Debug Message
293: OZF_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
294:
295: --/*
296: OPEN c_get_Related_Lines( l_tar_related_lines_rec.related_deal_lines_id);
297: FETCH c_get_Related_Lines INTO l_ref_related_lines_rec ;

Line 299: OZF_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',

295: --/*
296: OPEN c_get_Related_Lines( l_tar_related_lines_rec.related_deal_lines_id);
297: FETCH c_get_Related_Lines INTO l_ref_related_lines_rec ;
298: If ( c_get_Related_Lines%NOTFOUND) THEN
299: OZF_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
300: p_token_name => 'INFO',
301: p_token_value => 'Related_Lines') ;
302: RAISE FND_API.G_EXC_ERROR;
303: END IF;

Line 305: OZF_UTILITY_PVT.debug_message('Private API: - Close Cursor');

301: p_token_value => 'Related_Lines') ;
302: RAISE FND_API.G_EXC_ERROR;
303: END IF;
304: -- Debug Message
305: OZF_UTILITY_PVT.debug_message('Private API: - Close Cursor');
306: CLOSE c_get_Related_Lines;
307: --*/
308:
309:

Line 312: OZF_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',

308:
309:
310: If (l_tar_related_lines_rec.object_version_number is NULL or
311: l_tar_related_lines_rec.object_version_number = FND_API.G_MISS_NUM ) Then
312: OZF_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
313: p_token_name => 'COLUMN',
314: p_token_value => 'Last_Update_Date') ;
315: raise FND_API.G_EXC_ERROR;
316: End if;

Line 319: OZF_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',

315: raise FND_API.G_EXC_ERROR;
316: End if;
317: -- Check Whether record has been changed by someone else
318: If (l_tar_related_lines_rec.object_version_number <> l_ref_related_lines_rec.object_version_number) Then
319: OZF_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
320: p_token_name => 'INFO',
321: p_token_value => 'Related_Lines') ;
322: raise FND_API.G_EXC_ERROR;
323: End if;

Line 331: OZF_UTILITY_PVT.debug_message('Private API: Validate_Related_Lines');

327:
328: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
329: THEN
330: -- Debug message
331: OZF_UTILITY_PVT.debug_message('Private API: Validate_Related_Lines');
332:
333: -- Invoke validation procedures
334: Validate_related_lines(
335: p_api_version_number => 1.0,

Line 348: OZF_UTILITY_PVT.debug_message('Private API: Validate_Related_Lines ended successfully');

344:
345: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
346: RAISE FND_API.G_EXC_ERROR;
347: END IF;
348: OZF_UTILITY_PVT.debug_message('Private API: Validate_Related_Lines ended successfully');
349:
350: -- Debug Message
351: -- OZF_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
352:

Line 351: -- OZF_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');

347: END IF;
348: OZF_UTILITY_PVT.debug_message('Private API: Validate_Related_Lines ended successfully');
349:
350: -- Debug Message
351: -- OZF_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
352:
353: -- Invoke table handler(OZF_RELATED_DEAL_LINES_PKG.Update_Row)
354: OZF_UTILITY_PVT.debug_message('callin update row');
355: OZF_RELATED_DEAL_LINES_PKG.Update_Row(

Line 354: OZF_UTILITY_PVT.debug_message('callin update row');

350: -- Debug Message
351: -- OZF_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
352:
353: -- Invoke table handler(OZF_RELATED_DEAL_LINES_PKG.Update_Row)
354: OZF_UTILITY_PVT.debug_message('callin update row');
355: OZF_RELATED_DEAL_LINES_PKG.Update_Row(
356: p_related_deal_lines_id => p_related_lines_rec.related_deal_lines_id,
357: p_modifier_id => p_related_lines_rec.modifier_id,
358: p_related_modifier_id => p_related_lines_rec.related_modifier_id,

Line 373: OZF_UTILITY_PVT.debug_message('end update row');

369: p_estimate_qty_uom => p_related_lines_rec.estimate_qty_uom);
370: --
371: -- End of API body.
372: --
373: OZF_UTILITY_PVT.debug_message('end update row');
374: -- Standard check for p_commit
375: IF FND_API.to_Boolean( p_commit )
376: THEN
377: COMMIT WORK;

Line 382: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

378: END IF;
379:
380:
381: -- Debug Message
382: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
383:
384: -- Standard call to get message count and if count is 1, get message info.
385: FND_MSG_PUB.Count_And_Get
386: (p_count => x_msg_count,

Line 391: WHEN OZF_Utility_PVT.resource_locked THEN

387: p_data => x_msg_data
388: );
389: EXCEPTION
390:
391: WHEN OZF_Utility_PVT.resource_locked THEN
392: x_return_status := FND_API.g_ret_sts_error;
393: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
394:
395: WHEN FND_API.G_EXC_ERROR THEN

Line 393: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

389: EXCEPTION
390:
391: WHEN OZF_Utility_PVT.resource_locked THEN
392: x_return_status := FND_API.g_ret_sts_error;
393: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
394:
395: WHEN FND_API.G_EXC_ERROR THEN
396: ROLLBACK TO UPDATE_Related_Lines_PVT;
397: x_return_status := FND_API.G_RET_STS_ERROR;

Line 468: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

464: FND_MSG_PUB.initialize;
465: END IF;
466:
467: -- Debug Message
468: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
469:
470:
471: -- Initialize API return status to SUCCESS
472: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 478: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');

474: --
475: -- Api body
476: --
477: -- Debug Message
478: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
479:
480: -- Invoke table handler(OZF_RELATED_DEAL_LINES_PKG.Delete_Row)
481: OZF_RELATED_DEAL_LINES_PKG.Delete_Row(
482: p_RELATED_DEAL_LINES_ID => p_RELATED_DEAL_LINES_ID);

Line 495: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

491: END IF;
492:
493:
494: -- Debug Message
495: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
496:
497: -- Standard call to get message count and if count is 1, get message info.
498: FND_MSG_PUB.Count_And_Get
499: (p_count => x_msg_count,

Line 504: WHEN OZF_Utility_PVT.resource_locked THEN

500: p_data => x_msg_data
501: );
502: EXCEPTION
503:
504: WHEN OZF_Utility_PVT.resource_locked THEN
505: x_return_status := FND_API.g_ret_sts_error;
506: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
507:
508: WHEN FND_API.G_EXC_ERROR THEN

Line 506: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

502: EXCEPTION
503:
504: WHEN OZF_Utility_PVT.resource_locked THEN
505: x_return_status := FND_API.g_ret_sts_error;
506: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
507:
508: WHEN FND_API.G_EXC_ERROR THEN
509: ROLLBACK TO DELETE_Related_Lines_PVT;
510: x_return_status := FND_API.G_RET_STS_ERROR;

Line 574: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

570:
571: BEGIN
572:
573: -- Debug Message
574: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
575:
576: -- Initialize message list if p_init_msg_list is set to TRUE.
577: IF FND_API.to_Boolean( p_init_msg_list )
578: THEN

Line 598: OZF_Utility_PVT.debug_message(l_full_name||': start');

594:
595:
596: ------------------------ lock -------------------------
597:
598: OZF_Utility_PVT.debug_message(l_full_name||': start');
599: OPEN c_Related_Lines;
600:
601: FETCH c_Related_Lines INTO l_RELATED_DEAL_LINES_ID;
602:

Line 619: OZF_Utility_PVT.debug_message(l_full_name ||': end');

615: FND_MSG_PUB.count_and_get(
616: p_encoded => FND_API.g_false,
617: p_count => x_msg_count,
618: p_data => x_msg_data);
619: OZF_Utility_PVT.debug_message(l_full_name ||': end');
620: EXCEPTION
621:
622: WHEN OZF_Utility_PVT.resource_locked THEN
623: x_return_status := FND_API.g_ret_sts_error;

Line 622: WHEN OZF_Utility_PVT.resource_locked THEN

618: p_data => x_msg_data);
619: OZF_Utility_PVT.debug_message(l_full_name ||': end');
620: EXCEPTION
621:
622: WHEN OZF_Utility_PVT.resource_locked THEN
623: x_return_status := FND_API.g_ret_sts_error;
624: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
625:
626: WHEN FND_API.G_EXC_ERROR THEN

Line 624: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

620: EXCEPTION
621:
622: WHEN OZF_Utility_PVT.resource_locked THEN
623: x_return_status := FND_API.g_ret_sts_error;
624: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
625:
626: WHEN FND_API.G_EXC_ERROR THEN
627: ROLLBACK TO LOCK_Related_Lines_PVT;
628: x_return_status := FND_API.G_RET_STS_ERROR;

Line 672: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

668:
669: BEGIN
670: x_return_status := FND_API.g_ret_sts_success;
671: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
672: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
673: 'OZF_RELATED_DEAL_LINES',
674: 'RELATED_DEAL_LINES_ID = ''' || p_related_lines_rec.RELATED_DEAL_LINES_ID ||''''
675: );
676: ELSE

Line 677: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

673: 'OZF_RELATED_DEAL_LINES',
674: 'RELATED_DEAL_LINES_ID = ''' || p_related_lines_rec.RELATED_DEAL_LINES_ID ||''''
675: );
676: ELSE
677: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
678: 'OZF_RELATED_DEAL_LINES',
679: 'RELATED_DEAL_LINES_ID = ''' || p_related_lines_rec.RELATED_DEAL_LINES_ID ||
680: ''' AND RELATED_DEAL_LINES_ID <> ' || p_related_lines_rec.RELATED_DEAL_LINES_ID
681: );

Line 685: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_RLTD_DEAL_LINES_ID_DUP');

681: );
682: END IF;
683:
684: IF l_valid_flag = FND_API.g_false THEN
685: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_RLTD_DEAL_LINES_ID_DUP');
686: x_return_status := FND_API.g_ret_sts_error;
687: RETURN;
688: END IF;
689:

Line 706: OZF_UTILITY_PVT.debug_message(l_api_name||' - Start and related_deal_lines id is '||p_related_lines_rec.related_deal_lines_id);

702: x_return_status := FND_API.g_ret_sts_success;
703:
704: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
705:
706: OZF_UTILITY_PVT.debug_message(l_api_name||' - Start and related_deal_lines id is '||p_related_lines_rec.related_deal_lines_id);
707:
708: IF p_related_lines_rec.related_deal_lines_id = FND_API.g_miss_num
709: OR p_related_lines_rec.related_deal_lines_id IS NULL
710: THEN

Line 711: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_RLTD_LINES_NO_ID');

707:
708: IF p_related_lines_rec.related_deal_lines_id = FND_API.g_miss_num
709: OR p_related_lines_rec.related_deal_lines_id IS NULL
710: THEN
711: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_RLTD_LINES_NO_ID');
712: x_return_status := FND_API.g_ret_sts_error;
713: RETURN;
714: END IF;
715: OZF_UTILITY_PVT.debug_message(l_api_name||' - related_deal_lines_id ');

Line 715: OZF_UTILITY_PVT.debug_message(l_api_name||' - related_deal_lines_id ');

711: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_RLTD_LINES_NO_ID');
712: x_return_status := FND_API.g_ret_sts_error;
713: RETURN;
714: END IF;
715: OZF_UTILITY_PVT.debug_message(l_api_name||' - related_deal_lines_id ');
716:
717: IF p_related_lines_rec.modifier_id = FND_API.g_miss_num OR p_related_lines_rec.modifier_id IS NULL THEN
718: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_RLTD_LINES_NO_MODIFIER_ID');
719: x_return_status := FND_API.g_ret_sts_error;

Line 718: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_RLTD_LINES_NO_MODIFIER_ID');

714: END IF;
715: OZF_UTILITY_PVT.debug_message(l_api_name||' - related_deal_lines_id ');
716:
717: IF p_related_lines_rec.modifier_id = FND_API.g_miss_num OR p_related_lines_rec.modifier_id IS NULL THEN
718: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_RLTD_LINES_NO_MODIFIER_ID');
719: x_return_status := FND_API.g_ret_sts_error;
720: RETURN;
721: END IF;
722: /* commented by julou 09/07/2001 related_modifier_id are optional

Line 723: OZF_UTILITY_PVT.debug_message(l_api_name||' - modifier_id ');

719: x_return_status := FND_API.g_ret_sts_error;
720: RETURN;
721: END IF;
722: /* commented by julou 09/07/2001 related_modifier_id are optional
723: OZF_UTILITY_PVT.debug_message(l_api_name||' - modifier_id ');
724: IF p_related_lines_rec.related_modifier_id = FND_API.g_miss_num OR p_related_lines_rec.related_modifier_id IS NULL THEN
725: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_related_lines_NO_related_modifier_id');
726: x_return_status := FND_API.g_ret_sts_error;
727: RETURN;

Line 725: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_related_lines_NO_related_modifier_id');

721: END IF;
722: /* commented by julou 09/07/2001 related_modifier_id are optional
723: OZF_UTILITY_PVT.debug_message(l_api_name||' - modifier_id ');
724: IF p_related_lines_rec.related_modifier_id = FND_API.g_miss_num OR p_related_lines_rec.related_modifier_id IS NULL THEN
725: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_related_lines_NO_related_modifier_id');
726: x_return_status := FND_API.g_ret_sts_error;
727: RETURN;
728: END IF;
729: OZF_UTILITY_PVT.debug_message(l_api_name||' -related modifier_id ');

Line 729: OZF_UTILITY_PVT.debug_message(l_api_name||' -related modifier_id ');

725: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_related_lines_NO_related_modifier_id');
726: x_return_status := FND_API.g_ret_sts_error;
727: RETURN;
728: END IF;
729: OZF_UTILITY_PVT.debug_message(l_api_name||' -related modifier_id ');
730: */
731: /*
732: IF p_related_lines_rec.last_update_date = FND_API.g_miss_date OR p_related_lines_rec.last_update_date IS NULL THEN
733: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_related_lines_NO_last_update_date');

Line 733: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_related_lines_NO_last_update_date');

729: OZF_UTILITY_PVT.debug_message(l_api_name||' -related modifier_id ');
730: */
731: /*
732: IF p_related_lines_rec.last_update_date = FND_API.g_miss_date OR p_related_lines_rec.last_update_date IS NULL THEN
733: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_related_lines_NO_last_update_date');
734: x_return_status := FND_API.g_ret_sts_error;
735: RETURN;
736: END IF;
737:

Line 740: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_related_lines_NO_last_updated_by');

736: END IF;
737:
738:
739: IF p_related_lines_rec.last_updated_by = FND_API.g_miss_num OR p_related_lines_rec.last_updated_by IS NULL THEN
740: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_related_lines_NO_last_updated_by');
741: x_return_status := FND_API.g_ret_sts_error;
742: RETURN;
743: END IF;
744:

Line 747: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_related_lines_NO_creation_date');

743: END IF;
744:
745:
746: IF p_related_lines_rec.creation_date = FND_API.g_miss_date OR p_related_lines_rec.creation_date IS NULL THEN
747: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_related_lines_NO_creation_date');
748: x_return_status := FND_API.g_ret_sts_error;
749: RETURN;
750: END IF;
751:

Line 754: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_related_lines_NO_created_by');

750: END IF;
751:
752:
753: IF p_related_lines_rec.created_by = FND_API.g_miss_num OR p_related_lines_rec.created_by IS NULL THEN
754: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_related_lines_NO_created_by');
755: x_return_status := FND_API.g_ret_sts_error;
756: RETURN;
757: END IF;
758: */

Line 763: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_RLTD_LINES_NO_ID');

759: ELSE
760:
761:
762: IF p_related_lines_rec.related_deal_lines_id IS NULL THEN
763: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_RLTD_LINES_NO_ID');
764: x_return_status := FND_API.g_ret_sts_error;
765: RETURN;
766: END IF;
767:

Line 770: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_related_lines_NO_modifier_id');

766: END IF;
767:
768: /* comment julou 09/07/2001 modifier_id and related_modifier_id are optional now
769: IF p_related_lines_rec.modifier_id IS NULL THEN
770: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_related_lines_NO_modifier_id');
771: x_return_status := FND_API.g_ret_sts_error;
772: RETURN;
773: END IF;
774:

Line 777: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_related_lines_NO_related_modifier_id');

773: END IF;
774:
775:
776: IF p_related_lines_rec.related_modifier_id IS NULL THEN
777: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_related_lines_NO_related_modifier_id');
778: x_return_status := FND_API.g_ret_sts_error;
779: RETURN;
780: END IF;
781: */

Line 784: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_related_lines_NO_last_update_date');

780: END IF;
781: */
782: /*
783: IF p_related_lines_rec.last_update_date IS NULL THEN
784: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_related_lines_NO_last_update_date');
785: x_return_status := FND_API.g_ret_sts_error;
786: RETURN;
787: END IF;
788:

Line 791: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_related_lines_NO_last_updated_by');

787: END IF;
788:
789:
790: IF p_related_lines_rec.last_updated_by IS NULL THEN
791: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_related_lines_NO_last_updated_by');
792: x_return_status := FND_API.g_ret_sts_error;
793: RETURN;
794: END IF;
795:

Line 798: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_related_lines_NO_creation_date');

794: END IF;
795:
796:
797: IF p_related_lines_rec.creation_date IS NULL THEN
798: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_related_lines_NO_creation_date');
799: x_return_status := FND_API.g_ret_sts_error;
800: RETURN;
801: END IF;
802:

Line 805: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_related_lines_NO_created_by');

801: END IF;
802:
803:
804: IF p_related_lines_rec.created_by IS NULL THEN
805: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_related_lines_NO_created_by');
806: x_return_status := FND_API.g_ret_sts_error;
807: RETURN;
808: END IF; */
809: END IF;

Line 821: OZF_UTILITY_PVT.debug_message('Check_RELATED_LINES_fk_item - qp_list_header return status '||x_return_status);

817: IS
818: BEGIN
819: x_return_status := FND_API.g_ret_sts_success;
820:
821: OZF_UTILITY_PVT.debug_message('Check_RELATED_LINES_fk_item - qp_list_header return status '||x_return_status);
822: --- checking the qp_list_header_id
823: IF p_related_lines_rec.qp_list_header_id <> FND_API.G_MISS_NUM
824: AND p_related_lines_rec.qp_list_header_id IS NOT NULL
825: THEN

Line 826: IF OZF_Utility_PVT.check_fk_exists(

822: --- checking the qp_list_header_id
823: IF p_related_lines_rec.qp_list_header_id <> FND_API.G_MISS_NUM
824: AND p_related_lines_rec.qp_list_header_id IS NOT NULL
825: THEN
826: IF OZF_Utility_PVT.check_fk_exists(
827: 'qp_list_headers_all_b' -- Fix for bug # 14724414
828: ,'list_header_id'
829: ,p_related_lines_rec.qp_list_header_id) = FND_API.g_false
830: THEN

Line 831: OZF_Utility_PVT.Error_Message('OZF_OFFR_BAD_QP_LIST_HEADER_ID');

827: 'qp_list_headers_all_b' -- Fix for bug # 14724414
828: ,'list_header_id'
829: ,p_related_lines_rec.qp_list_header_id) = FND_API.g_false
830: THEN
831: OZF_Utility_PVT.Error_Message('OZF_OFFR_BAD_QP_LIST_HEADER_ID');
832: x_return_status := FND_API.g_ret_sts_error;
833: RETURN;
834: END IF;
835: END IF;

Line 838: OZF_UTILITY_PVT.debug_message('Check_RELATED_LINES_fk_item - modifier_id return status '||x_return_status);

834: END IF;
835: END IF;
836:
837: --- checking the modifier_id
838: OZF_UTILITY_PVT.debug_message('Check_RELATED_LINES_fk_item - modifier_id return status '||x_return_status);
839: IF p_related_lines_rec.modifier_id <> FND_API.G_MISS_NUM
840: AND p_related_lines_rec.modifier_id IS NOT NULL
841: THEN
842: IF OZF_Utility_PVT.check_fk_exists(

Line 842: IF OZF_Utility_PVT.check_fk_exists(

838: OZF_UTILITY_PVT.debug_message('Check_RELATED_LINES_fk_item - modifier_id return status '||x_return_status);
839: IF p_related_lines_rec.modifier_id <> FND_API.G_MISS_NUM
840: AND p_related_lines_rec.modifier_id IS NOT NULL
841: THEN
842: IF OZF_Utility_PVT.check_fk_exists(
843: 'qp_list_lines'
844: ,'list_line_id '
845: ,p_related_lines_rec.modifier_id) = FND_API.g_false
846: THEN

Line 847: OZF_Utility_PVT.Error_Message('OZF_OFFR_BAD_MODIFIER_ID');

843: 'qp_list_lines'
844: ,'list_line_id '
845: ,p_related_lines_rec.modifier_id) = FND_API.g_false
846: THEN
847: OZF_Utility_PVT.Error_Message('OZF_OFFR_BAD_MODIFIER_ID');
848: x_return_status := FND_API.g_ret_sts_error;
849: RETURN;
850: END IF;
851: END IF;

Line 854: OZF_UTILITY_PVT.debug_message('Check_RELATED_LINES_fk_item -reld modifier_id return status '||x_return_status);

850: END IF;
851: END IF;
852:
853: --- checking the related_modifier_id
854: OZF_UTILITY_PVT.debug_message('Check_RELATED_LINES_fk_item -reld modifier_id return status '||x_return_status);
855: IF p_related_lines_rec.related_modifier_id <> FND_API.G_MISS_NUM
856: AND p_related_lines_rec.related_modifier_id IS NOT NULL
857: THEN
858: IF OZF_Utility_PVT.check_fk_exists(

Line 858: IF OZF_Utility_PVT.check_fk_exists(

854: OZF_UTILITY_PVT.debug_message('Check_RELATED_LINES_fk_item -reld modifier_id return status '||x_return_status);
855: IF p_related_lines_rec.related_modifier_id <> FND_API.G_MISS_NUM
856: AND p_related_lines_rec.related_modifier_id IS NOT NULL
857: THEN
858: IF OZF_Utility_PVT.check_fk_exists(
859: 'qp_list_lines'
860: ,'list_line_id '
861: ,p_related_lines_rec.related_modifier_id) = FND_API.g_false
862: THEN

Line 863: OZF_Utility_PVT.Error_Message('OZF_OFFR_BAD_RLTD_MODIFIER_ID');

859: 'qp_list_lines'
860: ,'list_line_id '
861: ,p_related_lines_rec.related_modifier_id) = FND_API.g_false
862: THEN
863: OZF_Utility_PVT.Error_Message('OZF_OFFR_BAD_RLTD_MODIFIER_ID');
864: x_return_status := FND_API.g_ret_sts_error;
865: RETURN;
866: END IF;
867: END IF;

Line 892: OZF_UTILITY_PVT.debug_message('Check_RELATED_LINES_ _uk_Items - is first the return status '||x_return_status);

888: IS
889: BEGIN
890:
891: -- Check Items Uniqueness API calls
892: OZF_UTILITY_PVT.debug_message('Check_RELATED_LINES_ _uk_Items - is first the return status '||x_return_status);
893:
894: check_related_lines_uk_items(
895: p_related_lines_rec => p_related_lines_rec,
896: p_validation_mode => p_validation_mode,

Line 903: OZF_UTILITY_PVT.debug_message('Check_RELATED_LINES_req_Items - is the return status '||x_return_status);

899: RETURN;
900: END IF;
901:
902: -- Check Items Required/NOT NULL API calls
903: OZF_UTILITY_PVT.debug_message('Check_RELATED_LINES_req_Items - is the return status '||x_return_status);
904:
905: check_related_lines_req_items(
906: p_related_lines_rec => p_related_lines_rec,
907: p_validation_mode => p_validation_mode,

Line 914: OZF_UTILITY_PVT.debug_message('Check_RELATED_LINES_fk_Items - is first the return status '||x_return_status);

910: RETURN;
911: END IF;
912: -- Check Items Foreign Keys API calls
913:
914: OZF_UTILITY_PVT.debug_message('Check_RELATED_LINES_fk_Items - is first the return status '||x_return_status);
915:
916: check_related_lines_FK_items(
917: p_related_lines_rec => p_related_lines_rec,
918: x_return_status => x_return_status);

Line 923: OZF_UTILITY_PVT.debug_message('Check_RELATED_LINES_lkup items - is first the return status '||x_return_status);

919: IF x_return_status <> FND_API.g_ret_sts_success THEN
920: RETURN;
921: END IF;
922: -- Check Items Lookups
923: OZF_UTILITY_PVT.debug_message('Check_RELATED_LINES_lkup items - is first the return status '||x_return_status);
924: check_related_lines_Lkup_items(
925: p_related_lines_rec => p_related_lines_rec,
926: x_return_status => x_return_status);
927: IF x_return_status <> FND_API.g_ret_sts_success THEN

Line 931: OZF_UTILITY_PVT.debug_message('Check_RELATED_LINES_ finally return status '||x_return_status);

927: IF x_return_status <> FND_API.g_ret_sts_success THEN
928: RETURN;
929: END IF;
930:
931: OZF_UTILITY_PVT.debug_message('Check_RELATED_LINES_ finally return status '||x_return_status);
932:
933: END Check_related_lines_Items;
934:
935:

Line 1164: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

1160: END IF;
1161:
1162:
1163: -- Debug Message
1164: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1165:
1166:
1167: -- Initialize API return status to SUCCESS
1168: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1168: x_return_status := FND_API.G_RET_STS_SUCCESS;
1169:
1170:
1171: -- Debug Message
1172: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1173:
1174: -- Standard call to get message count and if count is 1, get message info.
1175: FND_MSG_PUB.Count_And_Get
1176: (p_count => x_msg_count,

Line 1179: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');

1175: FND_MSG_PUB.Count_And_Get
1176: (p_count => x_msg_count,
1177: p_data => x_msg_data
1178: );
1179: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
1180: EXCEPTION
1181:
1182: WHEN OZF_Utility_PVT.resource_locked THEN
1183: x_return_status := FND_API.g_ret_sts_error;

Line 1182: WHEN OZF_Utility_PVT.resource_locked THEN

1178: );
1179: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
1180: EXCEPTION
1181:
1182: WHEN OZF_Utility_PVT.resource_locked THEN
1183: x_return_status := FND_API.g_ret_sts_error;
1184: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1185:
1186: WHEN FND_API.G_EXC_ERROR THEN

Line 1184: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

1180: EXCEPTION
1181:
1182: WHEN OZF_Utility_PVT.resource_locked THEN
1183: x_return_status := FND_API.g_ret_sts_error;
1184: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1185:
1186: WHEN FND_API.G_EXC_ERROR THEN
1187: ROLLBACK TO VALIDATE_Related_Lines_;
1188: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1247: OZF_UTILITY_PVT.debug_message('Private API: Validate_related_lines_rec');

1243: -- THEN
1244: -- x_return_status := FND_API.G_RET_STS_ERROR;
1245:
1246: -- Debug Message
1247: OZF_UTILITY_PVT.debug_message('Private API: Validate_related_lines_rec');
1248: -- Standard call to get message count and if count is 1, get message info.
1249: FND_MSG_PUB.Count_And_Get
1250: (p_count => x_msg_count,
1251: p_data => x_msg_data