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 90: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

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

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

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

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

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

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

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

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

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

Line 189: WHEN OZF_Utility_PVT.resource_locked THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 390: WHEN OZF_Utility_PVT.resource_locked THEN

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

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

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

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

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

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

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

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

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

Line 503: WHEN OZF_Utility_PVT.resource_locked THEN

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

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

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

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

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

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

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

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

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

Line 621: WHEN OZF_Utility_PVT.resource_locked THEN

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

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

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

Line 671: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

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

Line 676: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 825: IF OZF_Utility_PVT.check_fk_exists(

821: --- checking the qp_list_header_id
822: IF p_related_lines_rec.qp_list_header_id <> FND_API.G_MISS_NUM
823: AND p_related_lines_rec.qp_list_header_id IS NOT NULL
824: THEN
825: IF OZF_Utility_PVT.check_fk_exists(
826: 'qp_list_headers_b'
827: ,'list_header_id'
828: ,p_related_lines_rec.qp_list_header_id) = FND_API.g_false
829: THEN

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

826: 'qp_list_headers_b'
827: ,'list_header_id'
828: ,p_related_lines_rec.qp_list_header_id) = FND_API.g_false
829: THEN
830: OZF_Utility_PVT.Error_Message('OZF_OFFR_BAD_QP_LIST_HEADER_ID');
831: x_return_status := FND_API.g_ret_sts_error;
832: RETURN;
833: END IF;
834: END IF;

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

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

Line 841: IF OZF_Utility_PVT.check_fk_exists(

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

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

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

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

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

Line 857: IF OZF_Utility_PVT.check_fk_exists(

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1181: WHEN OZF_Utility_PVT.resource_locked THEN

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

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

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

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

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