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_REASON_PVT dependencies on FND_MSG_PUB

Line 17: OZF_DEBUG_HIGH_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

13:
14: G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_Reason_PVT';
15: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfvreab.pls';
16:
17: OZF_DEBUG_HIGH_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
18:
19: -- Hint: Primary key needs to be returned.
20: PROCEDURE Create_reason(
21: P_Api_Version_Number IN NUMBER,

Line 58: FND_MSG_PUB.initialize;

54:
55: -- Initialize message list if p_init_msg_list is set to TRUE.
56: IF FND_API.to_Boolean( p_init_msg_list )
57: THEN
58: FND_MSG_PUB.initialize;
59: END IF;
60:
61: -- Debug Message
62: IF OZF_DEBUG_HIGH_ON THEN

Line 74: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

70: -- Validate Environment
71: -- ******************************************************************
72: IF FND_GLOBAL.User_Id IS NULL
73: THEN
74: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
75: THEN
76: FND_MESSAGE.Set_Name('OZF', 'OZF_USER_PROFILE_MISSING');
77: FND_MSG_PUB.ADD;
78: END IF;

Line 77: FND_MSG_PUB.ADD;

73: THEN
74: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
75: THEN
76: FND_MESSAGE.Set_Name('OZF', 'OZF_USER_PROFILE_MISSING');
77: FND_MSG_PUB.ADD;
78: END IF;
79: RAISE FND_API.G_EXC_ERROR;
80: END IF;
81:

Line 172: FND_MSG_PUB.Count_And_Get

168: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
169: END IF;
170:
171: -- Standard call to get message count and if count is 1, get message info.
172: FND_MSG_PUB.Count_And_Get
173: (p_count => x_msg_count,
174: p_data => x_msg_data
175: );
176: EXCEPTION

Line 181: FND_MSG_PUB.Count_And_Get (

177: WHEN FND_API.G_EXC_ERROR THEN
178: ROLLBACK TO CREATE_Reason_PVT;
179: x_return_status := FND_API.G_RET_STS_ERROR;
180: -- Standard call to get message count and if count=1, get the message
181: FND_MSG_PUB.Count_And_Get (
182: p_encoded => FND_API.G_FALSE,
183: p_count => x_msg_count,
184: p_data => x_msg_data
185: );

Line 190: FND_MSG_PUB.Count_And_Get (

186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
187: ROLLBACK TO CREATE_Reason_PVT;
188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
189: -- Standard call to get message count and if count=1, get the message
190: FND_MSG_PUB.Count_And_Get (
191: p_encoded => FND_API.G_FALSE,
192: p_count => x_msg_count,
193: p_data => x_msg_data
194: );

Line 198: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

194: );
195: WHEN OTHERS THEN
196: ROLLBACK TO CREATE_Reason_PVT;
197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
198: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
199: THEN
200: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
201: END IF;
202: -- Standard call to get message count and if count=1, get the message

Line 200: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

196: ROLLBACK TO CREATE_Reason_PVT;
197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
198: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
199: THEN
200: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
201: END IF;
202: -- Standard call to get message count and if count=1, get the message
203: FND_MSG_PUB.Count_And_Get (
204: p_encoded => FND_API.G_FALSE,

Line 203: FND_MSG_PUB.Count_And_Get (

199: THEN
200: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
201: END IF;
202: -- Standard call to get message count and if count=1, get the message
203: FND_MSG_PUB.Count_And_Get (
204: p_encoded => FND_API.G_FALSE,
205: p_count => x_msg_count,
206: p_data => x_msg_data
207: );

Line 291: FND_MSG_PUB.initialize;

287:
288: -- Initialize message list if p_init_msg_list is set to TRUE.
289: IF FND_API.to_Boolean( p_init_msg_list )
290: THEN
291: FND_MSG_PUB.initialize;
292: END IF;
293:
294: -- Debug Message
295: IF OZF_DEBUG_HIGH_ON THEN

Line 346: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

342: l_ref_reason_rec.ORDER_TYPE_ID,
343: l_ref_reason_rec.PARTNER_ACCESS_FLAG;
344:
345: If ( C_Get_reason%NOTFOUND) Then
346: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
347: THEN
348: FND_MESSAGE.Set_Name('OZF', 'OZF_API_RECORD_NOT_FOUND');
349: FND_MSG_PUB.Add;
350: END IF;

Line 349: FND_MSG_PUB.Add;

345: If ( C_Get_reason%NOTFOUND) Then
346: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
347: THEN
348: FND_MESSAGE.Set_Name('OZF', 'OZF_API_RECORD_NOT_FOUND');
349: FND_MSG_PUB.Add;
350: END IF;
351: raise FND_API.G_EXC_ERROR;
352: END IF;
353: -- Debug Message

Line 362: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

358:
359:
360: If (l_tar_reason_rec.object_version_number is NULL or
361: l_tar_reason_rec.object_version_number = FND_API.G_MISS_NUM ) Then
362: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
363: THEN
364: FND_MESSAGE.Set_Name('OZF', 'OZF_API_NO_OBJ_VER_NUM');
365: FND_MSG_PUB.ADD;
366: END IF;

Line 365: FND_MSG_PUB.ADD;

361: l_tar_reason_rec.object_version_number = FND_API.G_MISS_NUM ) Then
362: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
363: THEN
364: FND_MESSAGE.Set_Name('OZF', 'OZF_API_NO_OBJ_VER_NUM');
365: FND_MSG_PUB.ADD;
366: END IF;
367: raise FND_API.G_EXC_ERROR;
368: End if;
369:

Line 372: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

368: End if;
369:
370: -- Check Whether record has been changed by someone else
371: If (l_tar_reason_rec.object_version_number <> l_ref_reason_rec.object_version_number) Then
372: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
373: THEN
374: FND_MESSAGE.Set_Name('OZF', 'OZF_API_RESOURCE_LOCKED');
375: FND_MSG_PUB.ADD;
376: END IF;

Line 375: FND_MSG_PUB.ADD;

371: If (l_tar_reason_rec.object_version_number <> l_ref_reason_rec.object_version_number) Then
372: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
373: THEN
374: FND_MESSAGE.Set_Name('OZF', 'OZF_API_RESOURCE_LOCKED');
375: FND_MSG_PUB.ADD;
376: END IF;
377: raise FND_API.G_EXC_ERROR;
378: End if;
379:

Line 481: FND_MSG_PUB.Count_And_Get

477: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
478: END IF;
479:
480: -- Standard call to get message count and if count is 1, get message info.
481: FND_MSG_PUB.Count_And_Get
482: (p_count => x_msg_count,
483: p_data => x_msg_data
484: );
485: EXCEPTION

Line 490: FND_MSG_PUB.Count_And_Get (

486: WHEN FND_API.G_EXC_ERROR THEN
487: ROLLBACK TO UPDATE_Reason_PVT;
488: x_return_status := FND_API.G_RET_STS_ERROR;
489: -- Standard call to get message count and if count=1, get the message
490: FND_MSG_PUB.Count_And_Get (
491: p_encoded => FND_API.G_FALSE,
492: p_count => x_msg_count,
493: p_data => x_msg_data
494: );

Line 499: FND_MSG_PUB.Count_And_Get (

495: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
496: ROLLBACK TO UPDATE_Reason_PVT;
497: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
498: -- Standard call to get message count and if count=1, get the message
499: FND_MSG_PUB.Count_And_Get (
500: p_encoded => FND_API.G_FALSE,
501: p_count => x_msg_count,
502: p_data => x_msg_data
503: );

Line 507: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

503: );
504: WHEN OTHERS THEN
505: ROLLBACK TO UPDATE_Reason_PVT;
506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
507: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
508: THEN
509: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
510: END IF;
511: -- Standard call to get message count and if count=1, get the message

Line 509: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

505: ROLLBACK TO UPDATE_Reason_PVT;
506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
507: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
508: THEN
509: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
510: END IF;
511: -- Standard call to get message count and if count=1, get the message
512: FND_MSG_PUB.Count_And_Get (
513: p_encoded => FND_API.G_FALSE,

Line 512: FND_MSG_PUB.Count_And_Get (

508: THEN
509: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
510: END IF;
511: -- Standard call to get message count and if count=1, get the message
512: FND_MSG_PUB.Count_And_Get (
513: p_encoded => FND_API.G_FALSE,
514: p_count => x_msg_count,
515: p_data => x_msg_data
516: );

Line 558: FND_MSG_PUB.initialize;

554:
555: -- Initialize message list if p_init_msg_list is set to TRUE.
556: IF FND_API.to_Boolean( p_init_msg_list )
557: THEN
558: FND_MSG_PUB.initialize;
559: END IF;
560:
561: -- Debug Message
562: IF OZF_DEBUG_HIGH_ON THEN

Line 583: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

579: FETCH exist_reason_csr INTO l_reason_code_id;
580: CLOSE exist_reason_csr;
581:
582: IF l_reason_code_id IS NOT NULL THEN
583: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
584: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_REASON_ID_USED');
585: FND_MSG_PUB.add;
586: END IF;
587: RAISE FND_API.g_exc_error;

Line 585: FND_MSG_PUB.add;

581:
582: IF l_reason_code_id IS NOT NULL THEN
583: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
584: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_REASON_ID_USED');
585: FND_MSG_PUB.add;
586: END IF;
587: RAISE FND_API.g_exc_error;
588: END IF;
589:

Line 610: FND_MSG_PUB.Count_And_Get

606: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
607: END IF;
608:
609: -- Standard call to get message count and if count is 1, get message info.
610: FND_MSG_PUB.Count_And_Get
611: (p_count => x_msg_count,
612: p_data => x_msg_data
613: );
614: EXCEPTION

Line 619: FND_MSG_PUB.Count_And_Get (

615: WHEN FND_API.G_EXC_ERROR THEN
616: ROLLBACK TO DELETE_Reason_PVT;
617: x_return_status := FND_API.G_RET_STS_ERROR;
618: -- Standard call to get message count and if count=1, get the message
619: FND_MSG_PUB.Count_And_Get (
620: p_encoded => FND_API.G_FALSE,
621: p_count => x_msg_count,
622: p_data => x_msg_data
623: );

Line 628: FND_MSG_PUB.Count_And_Get (

624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
625: ROLLBACK TO DELETE_Reason_PVT;
626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
627: -- Standard call to get message count and if count=1, get the message
628: FND_MSG_PUB.Count_And_Get (
629: p_encoded => FND_API.G_FALSE,
630: p_count => x_msg_count,
631: p_data => x_msg_data
632: );

Line 636: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

632: );
633: WHEN OTHERS THEN
634: ROLLBACK TO DELETE_Reason_PVT;
635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
636: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
637: THEN
638: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
639: END IF;
640: -- Standard call to get message count and if count=1, get the message

Line 638: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

634: ROLLBACK TO DELETE_Reason_PVT;
635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
636: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
637: THEN
638: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
639: END IF;
640: -- Standard call to get message count and if count=1, get the message
641: FND_MSG_PUB.Count_And_Get (
642: p_encoded => FND_API.G_FALSE,

Line 641: FND_MSG_PUB.Count_And_Get (

637: THEN
638: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
639: END IF;
640: -- Standard call to get message count and if count=1, get the message
641: FND_MSG_PUB.Count_And_Get (
642: p_encoded => FND_API.G_FALSE,
643: p_count => x_msg_count,
644: p_data => x_msg_data
645: );

Line 731: FND_MSG_PUB.initialize;

727:
728: -- Initialize message list if p_init_msg_list is set to TRUE.
729: IF FND_API.to_Boolean( p_init_msg_list )
730: THEN
731: FND_MSG_PUB.initialize;
732: END IF;
733:
734: -- Debug Message
735: IF OZF_DEBUG_HIGH_ON THEN

Line 819: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

815: l_default_flag
816: );
817: EXCEPTION
818: WHEN OTHERS THEN
819: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
820: THEN
821: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ACTION_INSERT_ERROR');
822: FND_MSG_PUB.Add;
823: END IF;

Line 822: FND_MSG_PUB.Add;

818: WHEN OTHERS THEN
819: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
820: THEN
821: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ACTION_INSERT_ERROR');
822: FND_MSG_PUB.Add;
823: END IF;
824: raise FND_API.G_EXC_ERROR;
825: END;
826: -- UPDATE mode

Line 839: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

835:
836: -- Check Whether record has been changed by someone else
837: If (l_object_version_number <> p_action_tbl(i).object_version_number)
838: Then
839: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
840: THEN
841: FND_MESSAGE.Set_Name('OZF', 'OZF_API_RESOURCE_LOCKED');
842: FND_MSG_PUB.ADD;
843: END IF;

Line 842: FND_MSG_PUB.ADD;

838: Then
839: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
840: THEN
841: FND_MESSAGE.Set_Name('OZF', 'OZF_API_RESOURCE_LOCKED');
842: FND_MSG_PUB.ADD;
843: END IF;
844: raise FND_API.G_EXC_ERROR;
845: END IF;
846:

Line 867: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

863: , default_flag = p_action_tbl(i).default_flag
864: WHERE reason_type_id = l_reason_type_id;
865: EXCEPTION
866: WHEN OTHERS THEN
867: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
868: THEN
869: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ACTION_UPDATE_ERROR');
870: FND_MSG_PUB.Add;
871: END IF;

Line 870: FND_MSG_PUB.Add;

866: WHEN OTHERS THEN
867: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
868: THEN
869: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ACTION_UPDATE_ERROR');
870: FND_MSG_PUB.Add;
871: END IF;
872: raise FND_API.G_EXC_ERROR;
873: END;
874: END IF; -- end update

Line 895: FND_MSG_PUB.Count_And_Get

891: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
892: END IF;
893:
894: -- Standard call to get message count and if count is 1, get message info.
895: FND_MSG_PUB.Count_And_Get
896: (p_count => x_msg_count,
897: p_data => x_msg_data
898: );
899: EXCEPTION

Line 904: FND_MSG_PUB.Count_And_Get (

900: WHEN FND_API.G_EXC_ERROR THEN
901: ROLLBACK TO UPDATE_Actions_PVT;
902: x_return_status := FND_API.G_RET_STS_ERROR;
903: -- Standard call to get message count and if count=1, get the message
904: FND_MSG_PUB.Count_And_Get (
905: p_encoded => FND_API.G_FALSE,
906: p_count => x_msg_count,
907: p_data => x_msg_data
908: );

Line 913: FND_MSG_PUB.Count_And_Get (

909: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
910: ROLLBACK TO UPDATE_Actions_PVT;
911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
912: -- Standard call to get message count and if count=1, get the message
913: FND_MSG_PUB.Count_And_Get (
914: p_encoded => FND_API.G_FALSE,
915: p_count => x_msg_count,
916: p_data => x_msg_data
917: );

Line 921: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

917: );
918: WHEN OTHERS THEN
919: ROLLBACK TO UPDATE_Actions_PVT;
920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
921: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
922: THEN
923: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
924: END IF;
925: -- Standard call to get message count and if count=1, get the message

Line 923: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

919: ROLLBACK TO UPDATE_Actions_PVT;
920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
921: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
922: THEN
923: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
924: END IF;
925: -- Standard call to get message count and if count=1, get the message
926: FND_MSG_PUB.Count_And_Get (
927: p_encoded => FND_API.G_FALSE,

Line 926: FND_MSG_PUB.Count_And_Get (

922: THEN
923: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
924: END IF;
925: -- Standard call to get message count and if count=1, get the message
926: FND_MSG_PUB.Count_And_Get (
927: p_encoded => FND_API.G_FALSE,
928: p_count => x_msg_count,
929: p_data => x_msg_data
930: );

Line 993: FND_MSG_PUB.initialize;

989:
990: -- Initialize message list if p_init_msg_list is set to TRUE.
991: IF FND_API.to_Boolean( p_init_msg_list )
992: THEN
993: FND_MSG_PUB.initialize;
994: END IF;
995:
996: -- Debug Message
997: IF OZF_DEBUG_HIGH_ON THEN

Line 1019: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1015: WHERE reason_type_id = p_reason_type_id
1016: AND object_version_number = p_object_version_number;
1017:
1018: If (SQL%NOTFOUND) then
1019: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1020: THEN
1021: FND_MESSAGE.Set_Name('OZF', 'OZF_API_RESOURCE_LOCKED');
1022: FND_MSG_PUB.ADD;
1023: END IF;

Line 1022: FND_MSG_PUB.ADD;

1018: If (SQL%NOTFOUND) then
1019: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1020: THEN
1021: FND_MESSAGE.Set_Name('OZF', 'OZF_API_RESOURCE_LOCKED');
1022: FND_MSG_PUB.ADD;
1023: END IF;
1024: raise FND_API.G_EXC_ERROR;
1025: End If;
1026: --

Line 1043: FND_MSG_PUB.Count_And_Get

1039: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1040: END IF;
1041:
1042: -- Standard call to get message count and if count is 1, get message info.
1043: FND_MSG_PUB.Count_And_Get
1044: (p_count => x_msg_count,
1045: p_data => x_msg_data
1046: );
1047: EXCEPTION

Line 1052: FND_MSG_PUB.Count_And_Get (

1048: WHEN FND_API.G_EXC_ERROR THEN
1049: ROLLBACK TO DELETE_Action_PVT;
1050: x_return_status := FND_API.G_RET_STS_ERROR;
1051: -- Standard call to get message count and if count=1, get the message
1052: FND_MSG_PUB.Count_And_Get (
1053: p_encoded => FND_API.G_FALSE,
1054: p_count => x_msg_count,
1055: p_data => x_msg_data
1056: );

Line 1061: FND_MSG_PUB.Count_And_Get (

1057: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1058: ROLLBACK TO DELETE_Action_PVT;
1059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1060: -- Standard call to get message count and if count=1, get the message
1061: FND_MSG_PUB.Count_And_Get (
1062: p_encoded => FND_API.G_FALSE,
1063: p_count => x_msg_count,
1064: p_data => x_msg_data
1065: );

Line 1069: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1065: );
1066: WHEN OTHERS THEN
1067: ROLLBACK TO DELETE_Action_PVT;
1068: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1069: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1070: THEN
1071: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1072: END IF;
1073: -- Standard call to get message count and if count=1, get the message

Line 1071: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1067: ROLLBACK TO DELETE_Action_PVT;
1068: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1069: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1070: THEN
1071: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1072: END IF;
1073: -- Standard call to get message count and if count=1, get the message
1074: FND_MSG_PUB.Count_And_Get (
1075: p_encoded => FND_API.G_FALSE,

Line 1074: FND_MSG_PUB.Count_And_Get (

1070: THEN
1071: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1072: END IF;
1073: -- Standard call to get message count and if count=1, get the message
1074: FND_MSG_PUB.Count_And_Get (
1075: p_encoded => FND_API.G_FALSE,
1076: p_count => x_msg_count,
1077: p_data => x_msg_data
1078: );

Line 1189: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1185: OPEN c_reason(P_reason_Rec.reason_code_id);
1186: FETCH c_reason INTO l_reason_rec;
1187: IF c_reason%NOTFOUND THEN
1188: CLOSE c_reason;
1189: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1190: FND_MESSAGE.set_name('OZF','OZF_API_RECORD_NOT_FOUND');
1191: FND_MSG_PUB.add;
1192: END IF;
1193: RAISE FND_API.g_exc_error;

Line 1191: FND_MSG_PUB.add;

1187: IF c_reason%NOTFOUND THEN
1188: CLOSE c_reason;
1189: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1190: FND_MESSAGE.set_name('OZF','OZF_API_RECORD_NOT_FOUND');
1191: FND_MSG_PUB.add;
1192: END IF;
1193: RAISE FND_API.g_exc_error;
1194: END IF;
1195: CLOSE c_reason;

Line 1380: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1376: EXCEPTION
1377: WHEN FND_API.G_EXC_ERROR THEN
1378: x_return_status := FND_API.G_RET_STS_ERROR;
1379: WHEN OTHERS THEN
1380: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1381: FND_MESSAGE.set_name('OZF', 'OZF_REASON_COMPLETE_ERROR');
1382: FND_MSG_PUB.add;
1383: END IF;
1384: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 1382: FND_MSG_PUB.add;

1378: x_return_status := FND_API.G_RET_STS_ERROR;
1379: WHEN OTHERS THEN
1380: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1381: FND_MESSAGE.set_name('OZF', 'OZF_REASON_COMPLETE_ERROR');
1382: FND_MSG_PUB.add;
1383: END IF;
1384: x_return_status := FND_API.g_ret_sts_unexp_error;
1385:
1386:

Line 1420: FND_MSG_PUB.initialize;

1416:
1417: -- Initialize message list if p_init_msg_list is set to TRUE.
1418: IF FND_API.to_Boolean( p_init_msg_list )
1419: THEN
1420: FND_MSG_PUB.initialize;
1421: END IF;
1422: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1423: Check_reason_Items(
1424: p_reason_rec => p_reason_rec,

Line 1471: FND_MSG_PUB.Count_And_Get

1467: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1468: END IF;
1469:
1470: -- Standard call to get message count and if count is 1, get message info.
1471: FND_MSG_PUB.Count_And_Get
1472: (p_count => x_msg_count,
1473: p_data => x_msg_data
1474: );
1475: EXCEPTION

Line 1480: FND_MSG_PUB.Count_And_Get (

1476: WHEN FND_API.G_EXC_ERROR THEN
1477: ROLLBACK TO VALIDATE_Reason_;
1478: x_return_status := FND_API.G_RET_STS_ERROR;
1479: -- Standard call to get message count and if count=1, get the message
1480: FND_MSG_PUB.Count_And_Get (
1481: p_encoded => FND_API.G_FALSE,
1482: p_count => x_msg_count,
1483: p_data => x_msg_data
1484: );

Line 1489: FND_MSG_PUB.Count_And_Get (

1485: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1486: ROLLBACK TO VALIDATE_Reason_;
1487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1488: -- Standard call to get message count and if count=1, get the message
1489: FND_MSG_PUB.Count_And_Get (
1490: p_encoded => FND_API.G_FALSE,
1491: p_count => x_msg_count,
1492: p_data => x_msg_data
1493: );

Line 1497: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1493: );
1494: WHEN OTHERS THEN
1495: ROLLBACK TO VALIDATE_Reason_;
1496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1497: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1498: THEN
1499: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1500: END IF;
1501: -- Standard call to get message count and if count=1, get the message

Line 1499: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1495: ROLLBACK TO VALIDATE_Reason_;
1496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1497: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1498: THEN
1499: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1500: END IF;
1501: -- Standard call to get message count and if count=1, get the message
1502: FND_MSG_PUB.Count_And_Get (
1503: p_encoded => FND_API.G_FALSE,

Line 1502: FND_MSG_PUB.Count_And_Get (

1498: THEN
1499: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1500: END IF;
1501: -- Standard call to get message count and if count=1, get the message
1502: FND_MSG_PUB.Count_And_Get (
1503: p_encoded => FND_API.G_FALSE,
1504: p_count => x_msg_count,
1505: p_data => x_msg_data
1506: );

Line 1534: FND_MSG_PUB.initialize;

1530: BEGIN
1531: -- Initialize message list if p_init_msg_list is set to TRUE.
1532: IF FND_API.to_Boolean( p_init_msg_list )
1533: THEN
1534: FND_MSG_PUB.initialize;
1535: END IF;
1536:
1537: -- Initialize API return status to SUCCESS
1538: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1554: FND_MSG_PUB.ADD;

1550: IF( (l_reason_name IS NULL)
1551: OR (l_reason_name = FND_API.G_MISS_CHAR) )
1552: THEN
1553: FND_MESSAGE.Set_Name('OZF', 'OZF_REASON_NULL_NAME');
1554: FND_MSG_PUB.ADD;
1555: x_return_status := FND_API.G_RET_STS_ERROR;
1556: END IF;
1557:
1558: -- Check for null start date

Line 1563: FND_MSG_PUB.ADD;

1559: IF( (l_start_date IS NULL)
1560: OR (l_start_date = FND_API.G_MISS_DATE) )
1561: THEN
1562: FND_MESSAGE.Set_Name('OZF', 'OZF_REASON_NULL_STDATE');
1563: FND_MSG_PUB.ADD;
1564: x_return_status := FND_API.G_RET_STS_ERROR;
1565: END IF;
1566:
1567: -- End date validation.

Line 1574: FND_MSG_PUB.ADD;

1570: THEN
1571: IF( l_start_date > l_end_date )
1572: THEN
1573: FND_MESSAGE.Set_Name('OZF', 'OZF_REASON_STDATE_GT_ENDDATE');
1574: FND_MSG_PUB.ADD;
1575: x_return_status := FND_API.G_RET_STS_ERROR;
1576: END IF;
1577: END IF;
1578:

Line 1587: FND_MSG_PUB.add;

1583: CLOSE c_order_trx_type;
1584:
1585: IF l_dummy <> 1 THEN
1586: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_INVALID_OM_TRX_TYPE');
1587: FND_MSG_PUB.add;
1588: x_return_status := FND_API.G_RET_STS_ERROR;
1589: RETURN;
1590: END IF;
1591: END IF;

Line 1598: FND_MSG_PUB.Count_And_Get

1594: IF OZF_DEBUG_HIGH_ON THEN
1595: OZF_UTILITY_PVT.debug_message('API_INVALID_RECORD');
1596: END IF;
1597: -- Standard call to get message count and if count is 1, get message info.
1598: FND_MSG_PUB.Count_And_Get
1599: (p_count => x_msg_count,
1600: p_data => x_msg_data
1601: );
1602: END Validate_reason_Rec;