DBA Data[Home] [Help]

APPS.OZF_NA_DDN_RULE_PVT dependencies on OZF_UTILITY_PVT

Line 14: -- Mon Mar 29 2004:5/4 PM RSSHARMA Fixed bug # 3429608. Corrected debug to call local debug_message instead of ozf_utility_pvt.

10: --
11: -- NOTE
12: --
13: -- Wed Jan 14 2004:1/45 PM RSSHARMA Changed AMS_API_MISSING_FIELD messages to OZF_API_MISSING_FIELD
14: -- Mon Mar 29 2004:5/4 PM RSSHARMA Fixed bug # 3429608. Corrected debug to call local debug_message instead of ozf_utility_pvt.
15: -- Wed Oct 26 2005:2/8 PM RSSHARMA Fixed package hanging. Debug message was calling itself instead of ozf_utility_pvt.debug_message
16: -- End of Comments
17: -- ===============================================================
18:

Line 15: -- Wed Oct 26 2005:2/8 PM RSSHARMA Fixed package hanging. Debug message was calling itself instead of ozf_utility_pvt.debug_message

11: -- NOTE
12: --
13: -- Wed Jan 14 2004:1/45 PM RSSHARMA Changed AMS_API_MISSING_FIELD messages to OZF_API_MISSING_FIELD
14: -- Mon Mar 29 2004:5/4 PM RSSHARMA Fixed bug # 3429608. Corrected debug to call local debug_message instead of ozf_utility_pvt.
15: -- Wed Oct 26 2005:2/8 PM RSSHARMA Fixed package hanging. Debug message was calling itself instead of ozf_utility_pvt.debug_message
16: -- End of Comments
17: -- ===============================================================
18:
19:

Line 42: ozf_utility_pvt.debug_message(p_message_text);

38: )
39: IS
40: BEGIN
41: IF OZF_DEBUG_HIGH_ON THEN
42: ozf_utility_pvt.debug_message(p_message_text);
43: END IF;
44: END debug_message;
45:
46:

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

145: -- =========================================================================
146:
147: IF FND_GLOBAL.USER_ID IS NULL
148: THEN
149: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
150: RAISE FND_API.G_EXC_ERROR;
151: END IF;
152:
153:

Line 242: WHEN OZF_Utility_PVT.resource_locked THEN

238: p_data => x_msg_data
239: );
240: EXCEPTION
241:
242: WHEN OZF_Utility_PVT.resource_locked THEN
243: x_return_status := FND_API.g_ret_sts_error;
244: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
245:
246: WHEN FND_API.G_EXC_ERROR THEN

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

240: EXCEPTION
241:
242: WHEN OZF_Utility_PVT.resource_locked THEN
243: x_return_status := FND_API.g_ret_sts_error;
244: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
245:
246: WHEN FND_API.G_EXC_ERROR THEN
247: ROLLBACK TO CREATE_Na_Ddn_Rule_PVT;
248: x_return_status := FND_API.G_RET_STS_ERROR;

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

381:
382: FETCH c_get_Na_Ddn_Rule INTO l_ref_na_ddn_rule_rec ;
383:
384: If ( c_get_Na_Ddn_Rule%NOTFOUND) THEN
385: OZF_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
386: p_token_name => 'INFO',
387: p_token_value => 'Na_Ddn_Rule') ;
388: RAISE FND_API.G_EXC_ERROR;
389: END IF;

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

393:
394:
395: If (l_tar_na_ddn_rule_rec.object_version_number is NULL or
396: l_tar_na_ddn_rule_rec.object_version_number = FND_API.G_MISS_NUM ) Then
397: OZF_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
398: p_token_name => 'COLUMN',
399: p_token_value => 'Last_Update_Date') ;
400: raise FND_API.G_EXC_ERROR;
401: End if;

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

400: raise FND_API.G_EXC_ERROR;
401: End if;
402: -- Check Whether record has been changed by someone else
403: If (l_tar_na_ddn_rule_rec.object_version_number <> l_ref_na_ddn_rule_rec.object_version_number) Then
404: OZF_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
405: p_token_name => 'INFO',
406: p_token_value => 'Na_Ddn_Rule') ;
407: raise FND_API.G_EXC_ERROR;
408: End if;

Line 472: WHEN OZF_Utility_PVT.resource_locked THEN

468: p_data => x_msg_data
469: );
470: EXCEPTION
471:
472: WHEN OZF_Utility_PVT.resource_locked THEN
473: x_return_status := FND_API.g_ret_sts_error;
474: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
475:
476: WHEN FND_API.G_EXC_ERROR THEN

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

470: EXCEPTION
471:
472: WHEN OZF_Utility_PVT.resource_locked THEN
473: x_return_status := FND_API.g_ret_sts_error;
474: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
475:
476: WHEN FND_API.G_EXC_ERROR THEN
477: ROLLBACK TO UPDATE_Na_Ddn_Rule_PVT;
478: x_return_status := FND_API.G_RET_STS_ERROR;

Line 625: WHEN OZF_Utility_PVT.resource_locked THEN

621: p_data => x_msg_data
622: );
623: EXCEPTION
624:
625: WHEN OZF_Utility_PVT.resource_locked THEN
626: x_return_status := FND_API.g_ret_sts_error;
627: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
628:
629: WHEN FND_API.G_EXC_ERROR THEN

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

623: EXCEPTION
624:
625: WHEN OZF_Utility_PVT.resource_locked THEN
626: x_return_status := FND_API.g_ret_sts_error;
627: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
628:
629: WHEN FND_API.G_EXC_ERROR THEN
630: ROLLBACK TO DELETE_Na_Ddn_Rule_PVT;
631: x_return_status := FND_API.G_RET_STS_ERROR;

Line 759: WHEN OZF_Utility_PVT.resource_locked THEN

755: p_data => x_msg_data);
756: debug_message(l_full_name ||': end');
757: EXCEPTION
758:
759: WHEN OZF_Utility_PVT.resource_locked THEN
760: x_return_status := FND_API.g_ret_sts_error;
761: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
762:
763: WHEN FND_API.G_EXC_ERROR THEN

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

757: EXCEPTION
758:
759: WHEN OZF_Utility_PVT.resource_locked THEN
760: x_return_status := FND_API.g_ret_sts_error;
761: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
762:
763: WHEN FND_API.G_EXC_ERROR THEN
764: ROLLBACK TO LOCK_Na_Ddn_Rule_PVT;
765: x_return_status := FND_API.G_RET_STS_ERROR;

Line 813: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

809: x_return_status := FND_API.g_ret_sts_success;
810: IF p_validation_mode = JTF_PLSQL_API.g_create
811: AND p_na_ddn_rule_rec.na_deduction_rule_id IS NOT NULL
812: THEN
813: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
814: 'ozf_na_deduction_rules_b',
815: 'na_deduction_rule_id = ''' || p_na_ddn_rule_rec.na_deduction_rule_id ||''''
816: );
817: END IF;

Line 820: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_na_deduction_rule_id_DUPLICATE');

816: );
817: END IF;
818:
819: IF l_valid_flag = FND_API.g_false THEN
820: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_na_deduction_rule_id_DUPLICATE');
821: x_return_status := FND_API.g_ret_sts_error;
822: END IF;
823:
824: END check_Na_Ddn_Rule_Uk_Items;

Line 841: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'NA_DEDUCTION_RULE_ID' );

837: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
838:
839:
840: IF p_na_ddn_rule_rec.na_deduction_rule_id = FND_API.G_MISS_NUM OR p_na_ddn_rule_rec.na_deduction_rule_id IS NULL THEN
841: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'NA_DEDUCTION_RULE_ID' );
842: x_return_status := FND_API.g_ret_sts_error;
843: END IF;
844:
845:

Line 847: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'TRANSACTION_SOURCE_CODE' );

843: END IF;
844:
845:
846: IF p_na_ddn_rule_rec.transaction_source_code = FND_API.g_miss_char OR p_na_ddn_rule_rec.transaction_source_code IS NULL THEN
847: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'TRANSACTION_SOURCE_CODE' );
848: x_return_status := FND_API.g_ret_sts_error;
849: END IF;
850:
851:

Line 853: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'TRANSACTION_TYPE_CODE' );

849: END IF;
850:
851:
852: IF p_na_ddn_rule_rec.transaction_type_code = FND_API.g_miss_char OR p_na_ddn_rule_rec.transaction_type_code IS NULL THEN
853: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'TRANSACTION_TYPE_CODE' );
854: x_return_status := FND_API.g_ret_sts_error;
855: END IF;
856:
857:

Line 859: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'DEDUCTION_IDENTIFIER_ID' );

855: END IF;
856:
857:
858: IF p_na_ddn_rule_rec.deduction_identifier_id = FND_API.G_MISS_CHAR OR p_na_ddn_rule_rec.deduction_identifier_id IS NULL THEN
859: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'DEDUCTION_IDENTIFIER_ID' );
860: x_return_status := FND_API.g_ret_sts_error;
861: END IF;
862:
863: IF p_na_ddn_rule_rec.deduction_identifier_org_id = FND_API.G_MISS_NUM OR p_na_ddn_rule_rec.deduction_identifier_org_id IS NULL THEN

Line 864: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'DEDUCTION_IDENTIFIER_ORG_ID' );

860: x_return_status := FND_API.g_ret_sts_error;
861: END IF;
862:
863: IF p_na_ddn_rule_rec.deduction_identifier_org_id = FND_API.G_MISS_NUM OR p_na_ddn_rule_rec.deduction_identifier_org_id IS NULL THEN
864: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'DEDUCTION_IDENTIFIER_ORG_ID' );
865: x_return_status := FND_API.g_ret_sts_error;
866: END IF;
867:
868: /* IF p_na_ddn_rule_rec.object_version_number = FND_API.G_MISS_NUM OR p_na_ddn_rule_rec.object_version_number IS NULL THEN

Line 869: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );

865: x_return_status := FND_API.g_ret_sts_error;
866: END IF;
867:
868: /* IF p_na_ddn_rule_rec.object_version_number = FND_API.G_MISS_NUM OR p_na_ddn_rule_rec.object_version_number IS NULL THEN
869: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );
870: x_return_status := FND_API.g_ret_sts_error;
871: END IF;
872:
873:

Line 875: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATE_LOGIN' );

871: END IF;
872:
873:
874: IF p_na_ddn_rule_rec.last_update_login = FND_API.G_MISS_NUM OR p_na_ddn_rule_rec.last_update_login IS NULL THEN
875: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATE_LOGIN' );
876: x_return_status := FND_API.g_ret_sts_error;
877: END IF;
878: */
879:

Line 882: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'NA_DEDUCTION_RULE_ID' );

878: */
879:
880: ELSE
881: IF p_na_ddn_rule_rec.na_deduction_rule_id = FND_API.G_MISS_NUM THEN
882: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'NA_DEDUCTION_RULE_ID' );
883: x_return_status := FND_API.g_ret_sts_error;
884: END IF;
885:
886:

Line 888: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'TRANSACTION_SOURCE_CODE' );

884: END IF;
885:
886:
887: IF p_na_ddn_rule_rec.transaction_source_code = FND_API.g_miss_char THEN
888: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'TRANSACTION_SOURCE_CODE' );
889: x_return_status := FND_API.g_ret_sts_error;
890: END IF;
891:
892:

Line 894: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'TRANSACTION_TYPE_CODE' );

890: END IF;
891:
892:
893: IF p_na_ddn_rule_rec.transaction_type_code = FND_API.g_miss_char THEN
894: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'TRANSACTION_TYPE_CODE' );
895: x_return_status := FND_API.g_ret_sts_error;
896: END IF;
897:
898:

Line 900: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'DEDUCTION_IDENTIFIER_ID' );

896: END IF;
897:
898:
899: IF p_na_ddn_rule_rec.deduction_identifier_id = FND_API.G_MISS_CHAR THEN
900: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'DEDUCTION_IDENTIFIER_ID' );
901: x_return_status := FND_API.g_ret_sts_error;
902: END IF;
903:
904: IF p_na_ddn_rule_rec.deduction_identifier_org_id = FND_API.G_MISS_NUM THEN

Line 905: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'DEDUCTION_IDENTIFIER_ORG_ID' );

901: x_return_status := FND_API.g_ret_sts_error;
902: END IF;
903:
904: IF p_na_ddn_rule_rec.deduction_identifier_org_id = FND_API.G_MISS_NUM THEN
905: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'DEDUCTION_IDENTIFIER_ORG_ID' );
906: x_return_status := FND_API.g_ret_sts_error;
907: END IF;
908:
909: IF p_na_ddn_rule_rec.object_version_number = FND_API.G_MISS_NUM THEN

Line 910: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );

906: x_return_status := FND_API.g_ret_sts_error;
907: END IF;
908:
909: IF p_na_ddn_rule_rec.object_version_number = FND_API.G_MISS_NUM THEN
910: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );
911: x_return_status := FND_API.g_ret_sts_error;
912: END IF;
913:
914: /*

Line 916: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATE_LOGIN' );

912: END IF;
913:
914: /*
915: IF p_na_ddn_rule_rec.last_update_login = FND_API.G_MISS_NUM THEN
916: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATE_LOGIN' );
917: x_return_status := FND_API.g_ret_sts_error;
918: END IF;
919: END IF;
920: */

Line 1206: WHEN OZF_Utility_PVT.resource_locked THEN

1202: p_data => x_msg_data
1203: );
1204: EXCEPTION
1205:
1206: WHEN OZF_Utility_PVT.resource_locked THEN
1207: x_return_status := FND_API.g_ret_sts_error;
1208: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1209:
1210: WHEN FND_API.G_EXC_ERROR THEN

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

1204: EXCEPTION
1205:
1206: WHEN OZF_Utility_PVT.resource_locked THEN
1207: x_return_status := FND_API.g_ret_sts_error;
1208: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1209:
1210: WHEN FND_API.G_EXC_ERROR THEN
1211: ROLLBACK TO VALIDATE_Na_Ddn_Rule_;
1212: x_return_status := FND_API.G_RET_STS_ERROR;