DBA Data[Home] [Help]

APPS.OZF_REASON_PVT dependencies on OZF_UTILITY_PVT

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

59: END IF;
60:
61: -- Debug Message
62: IF OZF_DEBUG_HIGH_ON THEN
63: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
64: END IF;
65:
66: -- Initialize API return status to SUCCESS
67: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 86: OZF_UTILITY_PVT.debug_message('Private API: Validate_reason');

82: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
83: THEN
84: -- Debug message
85: IF OZF_DEBUG_HIGH_ON THEN
86: OZF_UTILITY_PVT.debug_message('Private API: Validate_reason');
87: END IF;
88:
89: -- Invoke validation procedures
90: Validate_reason(

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

103:
104:
105: -- Debug Message
106: IF OZF_DEBUG_HIGH_ON THEN
107: OZF_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
108: END IF;
109:
110: -- Pass org_id from UI
111: l_org_id := p_reason_rec.ORG_ID;

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

164:
165:
166: -- Debug Message
167: IF OZF_DEBUG_HIGH_ON THEN
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

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

292: END IF;
293:
294: -- Debug Message
295: IF OZF_DEBUG_HIGH_ON THEN
296: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
297: END IF;
298:
299:
300: -- Initialize API return status to SUCCESS

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

301: x_return_status := FND_API.G_RET_STS_SUCCESS;
302:
303: -- Debug Message
304: IF OZF_DEBUG_HIGH_ON THEN
305: OZF_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
306: END IF;
307:
308: Open C_Get_reason( l_tar_reason_rec.REASON_CODE_ID);
309: Fetch C_Get_reason into

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

351: raise FND_API.G_EXC_ERROR;
352: END IF;
353: -- Debug Message
354: IF OZF_DEBUG_HIGH_ON THEN
355: OZF_UTILITY_PVT.debug_message('Private API: - Close Cursor');
356: END IF;
357: Close C_Get_reason;
358:
359:

Line 392: OZF_UTILITY_PVT.debug_message('Private API: Before Validate');

388: RAISE FND_API.g_exc_unexpected_error;
389: END IF;
390:
391: IF OZF_DEBUG_HIGH_ON THEN
392: OZF_UTILITY_PVT.debug_message('Private API: Before Validate');
393: END IF;
394: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
395: THEN
396: -- Debug message

Line 398: OZF_UTILITY_PVT.debug_message('Private API: Validate_reason');

394: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
395: THEN
396: -- Debug message
397: IF OZF_DEBUG_HIGH_ON THEN
398: OZF_UTILITY_PVT.debug_message('Private API: Validate_reason');
399: END IF;
400:
401: -- Invoke validation procedures
402: Validate_reason(

Line 416: OZF_UTILITY_PVT.debug_message('Private API: After Validate');

412: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
413: RAISE FND_API.G_EXC_ERROR;
414: END IF;
415: IF OZF_DEBUG_HIGH_ON THEN
416: OZF_UTILITY_PVT.debug_message('Private API: After Validate');
417: END IF;
418:
419:
420:

Line 423: OZF_UTILITY_PVT.debug_message('Private API:Calling update table handler');

419:
420:
421: -- Debug Message
422: IF OZF_DEBUG_HIGH_ON THEN
423: OZF_UTILITY_PVT.debug_message('Private API:Calling update table handler');
424: END IF;
425:
426: l_object_version_number := l_reason_rec.OBJECT_VERSION_NUMBER + 1;
427:

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

473:
474:
475: -- Debug Message
476: IF OZF_DEBUG_HIGH_ON THEN
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

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

559: END IF;
560:
561: -- Debug Message
562: IF OZF_DEBUG_HIGH_ON THEN
563: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
564: END IF;
565:
566:
567: -- Initialize API return status to SUCCESS

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

571: -- Api body
572: --
573: -- Debug Message
574: IF OZF_DEBUG_HIGH_ON THEN
575: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
576: END IF;
577:
578: OPEN exist_reason_csr(p_reason_code_id);
579: FETCH exist_reason_csr INTO l_reason_code_id;

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

602:
603:
604: -- Debug Message
605: IF OZF_DEBUG_HIGH_ON THEN
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

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

732: END IF;
733:
734: -- Debug Message
735: IF OZF_DEBUG_HIGH_ON THEN
736: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
737: END IF;
738:
739:
740: -- Initialize API return status to SUCCESS

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

887:
888:
889: -- Debug Message
890: IF OZF_DEBUG_HIGH_ON THEN
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

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

994: END IF;
995:
996: -- Debug Message
997: IF OZF_DEBUG_HIGH_ON THEN
998: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
999: END IF;
1000:
1001:
1002: -- Initialize API return status to SUCCESS

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

1006: -- Api body
1007: --
1008: -- Debug Message
1009: IF OZF_DEBUG_HIGH_ON THEN
1010: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1011: END IF;
1012:
1013: -- Invoke table handler(OZF_reason_codes_All_PKG.Delete_Row)
1014: DELETE FROM ozf_reasons

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

1035:
1036:
1037: -- Debug Message
1038: IF OZF_DEBUG_HIGH_ON THEN
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

Line 1111: OZF_UTILITY_PVT.debug_message('Inside Check_unique_Action - p_validation_mode' || p_validation_mode);

1107: BEGIN
1108: x_return_status := FND_API.G_RET_STS_SUCCESS;
1109:
1110: IF OZF_DEBUG_HIGH_ON THEN
1111: OZF_UTILITY_PVT.debug_message('Inside Check_unique_Action - p_validation_mode' || p_validation_mode);
1112:
1113: OZF_UTILITY_PVT.debug_message('P_action_Rec.TASK_TEMPLATE_GROUP_ID :'|| P_action_Rec.TASK_TEMPLATE_GROUP_ID);
1114: END IF;
1115:

Line 1113: OZF_UTILITY_PVT.debug_message('P_action_Rec.TASK_TEMPLATE_GROUP_ID :'|| P_action_Rec.TASK_TEMPLATE_GROUP_ID);

1109:
1110: IF OZF_DEBUG_HIGH_ON THEN
1111: OZF_UTILITY_PVT.debug_message('Inside Check_unique_Action - p_validation_mode' || p_validation_mode);
1112:
1113: OZF_UTILITY_PVT.debug_message('P_action_Rec.TASK_TEMPLATE_GROUP_ID :'|| P_action_Rec.TASK_TEMPLATE_GROUP_ID);
1114: END IF;
1115:
1116: IF( p_validation_mode = JTF_PLSQL_API.g_create )
1117: THEN

Line 1118: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

1114: END IF;
1115:
1116: IF( p_validation_mode = JTF_PLSQL_API.g_create )
1117: THEN
1118: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
1119: 'OZF_REASONS',
1120: ' TASK_TEMPLATE_GROUP_ID ='||' '||P_action_Rec.TASK_TEMPLATE_GROUP_ID ||''||
1121: ' AND REASON_CODE_ID = '||' '|| P_action_Rec.REASON_CODE_ID
1122: );

Line 1126: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_DUPLICATE_ACTION');

1122: );
1123: END IF;
1124:
1125: IF l_valid_flag = FND_API.g_false THEN
1126: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_DUPLICATE_ACTION');
1127: x_return_status := FND_API.g_ret_sts_error;
1128: RETURN;
1129: END IF;
1130:

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

1453:
1454:
1455: -- Debug Message
1456: IF OZF_DEBUG_HIGH_ON THEN
1457: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1458: END IF;
1459:
1460:
1461: -- Initialize API return status to SUCCESS

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

1463:
1464:
1465: -- Debug Message
1466: IF OZF_DEBUG_HIGH_ON THEN
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

Line 1595: OZF_UTILITY_PVT.debug_message('API_INVALID_RECORD');

1591: END IF;
1592:
1593: -- Debug Message
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,