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.AMW_CONTROL_PVT dependencies on AMW_UTILITY_PVT

Line 19: G_OBJ_TYPE CONSTANT VARCHAR2(80) := AMW_UTILITY_PVT.GET_LOOKUP_MEANING('AMW_OBJECT_TYPE','CTRL');

15: g_pkg_name CONSTANT VARCHAR2 (30) := 'AMW_Control_PVT';
16: g_file_name CONSTANT VARCHAR2 (12) := 'amwvctlb.pls';
17: g_user_id NUMBER := fnd_global.user_id;
18: g_login_id NUMBER := fnd_global.conc_login_id;
19: G_OBJ_TYPE CONSTANT VARCHAR2(80) := AMW_UTILITY_PVT.GET_LOOKUP_MEANING('AMW_OBJECT_TYPE','CTRL');
20:
21: ---G_FALSE VARCHAr2(1) := FND_API.G_FALSE;
22: ---G_TRUE VARCHAr2(1) := FND_API.G_TRUE;
23:

Line 152: ---amw_utility_pvt.debug_message ('Private API: ' || l_api_name || 'start');

148: IF fnd_api.to_boolean (p_init_msg_list) THEN
149: fnd_msg_pub.initialize;
150: END IF;
151: -- Debug Message
152: ---amw_utility_pvt.debug_message ('Private API: ' || l_api_name || 'start');
153: amw_utility_pvt.debug_message (l_api_name || ' start');
154: -- Initialize API return status to SUCCESS
155: x_return_status := fnd_api.g_ret_sts_success;
156: l_control_rec := p_control_rec;

Line 153: amw_utility_pvt.debug_message (l_api_name || ' start');

149: fnd_msg_pub.initialize;
150: END IF;
151: -- Debug Message
152: ---amw_utility_pvt.debug_message ('Private API: ' || l_api_name || 'start');
153: amw_utility_pvt.debug_message (l_api_name || ' start');
154: -- Initialize API return status to SUCCESS
155: x_return_status := fnd_api.g_ret_sts_success;
156: l_control_rec := p_control_rec;
157: ---l_control_rec.requestor_id := p_party_id;

Line 167: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',

163: FETCH get_name
164: INTO l_get_name;
165: EXIT WHEN get_name%NOTFOUND;
166: IF (l_get_name.NAME = p_control_rec.NAME) THEN
167: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',
168: p_token_name => 'ITEM',
169: p_token_value => 'Control_Name');
170: --RAISE FND_API.G_EXC_ERROR;
171: l_control_exists := 1;

Line 179: ----amw_utility_pvt.debug_message('Validate_dm_model_rec: A Control can only be created in a Draft (''D'') status');

175: ----fnd_file.put_line (fnd_file.LOG,'Out of Get_Name cursor, l_control_exists: '||l_control_exists);
176:
177: IF (l_control_rec.approval_status IS NOT NULL AND
178: (l_control_rec.approval_status <> 'D' and l_control_rec.approval_status <> 'A')) THEN
179: ----amw_utility_pvt.debug_message('Validate_dm_model_rec: A Control can only be created in a Draft (''D'') status');
180: amw_utility_pvt.debug_message('Control_Status not ''D''');
181: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_INVALID_STATUS',
182: p_token_name => 'OBJ_TYPE',
183: p_token_value => G_OBJ_TYPE);

Line 180: amw_utility_pvt.debug_message('Control_Status not ''D''');

176:
177: IF (l_control_rec.approval_status IS NOT NULL AND
178: (l_control_rec.approval_status <> 'D' and l_control_rec.approval_status <> 'A')) THEN
179: ----amw_utility_pvt.debug_message('Validate_dm_model_rec: A Control can only be created in a Draft (''D'') status');
180: amw_utility_pvt.debug_message('Control_Status not ''D''');
181: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_INVALID_STATUS',
182: p_token_name => 'OBJ_TYPE',
183: p_token_value => G_OBJ_TYPE);
184:

Line 181: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_INVALID_STATUS',

177: IF (l_control_rec.approval_status IS NOT NULL AND
178: (l_control_rec.approval_status <> 'D' and l_control_rec.approval_status <> 'A')) THEN
179: ----amw_utility_pvt.debug_message('Validate_dm_model_rec: A Control can only be created in a Draft (''D'') status');
180: amw_utility_pvt.debug_message('Control_Status not ''D''');
181: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_INVALID_STATUS',
182: p_token_name => 'OBJ_TYPE',
183: p_token_value => G_OBJ_TYPE);
184:
185: x_return_status := fnd_api.g_ret_sts_error;

Line 270: ---amw_utility_pvt.error_message(p_message_name => 'More than one row for this Control can be revised.');

266: END LOOP;
267: CLOSE rev_enabled;
268: ----fnd_file.put_line (fnd_file.LOG,'Closed rev_enabled, l_revision_row_found: '||l_revision_row_found);
269: IF (l_revision_row_found > 1) THEN
270: ---amw_utility_pvt.error_message(p_message_name => 'More than one row for this Control can be revised.');
271: ---amw_utility_pvt.error_message(p_message_name => 'Needs only one revisable row');
272: amw_utility_pvt.error_message(p_message_name => 'AMW_UNEXPECT_ERROR',
273: p_token_name => 'OBJ_TYPE',
274: p_token_value => G_OBJ_TYPE);

Line 271: ---amw_utility_pvt.error_message(p_message_name => 'Needs only one revisable row');

267: CLOSE rev_enabled;
268: ----fnd_file.put_line (fnd_file.LOG,'Closed rev_enabled, l_revision_row_found: '||l_revision_row_found);
269: IF (l_revision_row_found > 1) THEN
270: ---amw_utility_pvt.error_message(p_message_name => 'More than one row for this Control can be revised.');
271: ---amw_utility_pvt.error_message(p_message_name => 'Needs only one revisable row');
272: amw_utility_pvt.error_message(p_message_name => 'AMW_UNEXPECT_ERROR',
273: p_token_name => 'OBJ_TYPE',
274: p_token_value => G_OBJ_TYPE);
275:

Line 272: amw_utility_pvt.error_message(p_message_name => 'AMW_UNEXPECT_ERROR',

268: ----fnd_file.put_line (fnd_file.LOG,'Closed rev_enabled, l_revision_row_found: '||l_revision_row_found);
269: IF (l_revision_row_found > 1) THEN
270: ---amw_utility_pvt.error_message(p_message_name => 'More than one row for this Control can be revised.');
271: ---amw_utility_pvt.error_message(p_message_name => 'Needs only one revisable row');
272: amw_utility_pvt.error_message(p_message_name => 'AMW_UNEXPECT_ERROR',
273: p_token_name => 'OBJ_TYPE',
274: p_token_value => G_OBJ_TYPE);
275:
276: x_return_status := fnd_api.g_ret_sts_error;

Line 285: amw_utility_pvt.error_message(p_message_name => 'AMW_INVALID_STATUS',

281: l_control_rec.latest_revision_flag := 'N';
282: l_control_rec.object_version_number := l_control_rec.object_version_number;
283: l_count := 0;
284: IF (l_control_rec.approval_status = 'R') THEN
285: amw_utility_pvt.error_message(p_message_name => 'AMW_INVALID_STATUS',
286: p_token_name => 'OBJ_TYPE',
287: p_token_value => G_OBJ_TYPE);
288:
289: x_return_status := fnd_api.g_ret_sts_error;

Line 293: amw_utility_pvt.error_message(p_message_name => 'AMW_PENDING_CHANGE_ERROR',

289: x_return_status := fnd_api.g_ret_sts_error;
290: RAISE fnd_api.g_exc_error;
291: END IF;
292: IF (l_approval_status = 'P') THEN
293: amw_utility_pvt.error_message(p_message_name => 'AMW_PENDING_CHANGE_ERROR',
294: p_token_name => 'OBJ_TYPE',
295: p_token_value => G_OBJ_TYPE);
296:
297: x_return_status := fnd_api.g_ret_sts_error;

Line 376: amw_utility_pvt.error_message(p_message_name => 'AMW_UNEXPECT_ERROR',

372: --create a new row for the revision with the appropriate statuses.
373: END IF;
374: END IF;
375: ELSIF (l_update_row_found > 1) THEN ----elsif for update status
376: amw_utility_pvt.error_message(p_message_name => 'AMW_UNEXPECT_ERROR',
377: p_token_name => 'OBJ_TYPE',
378: p_token_value => G_OBJ_TYPE);
379:
380: RAISE fnd_api.g_exc_error;

Line 434: amw_utility_pvt.error_message(p_message_name => 'AMW_INVALID_STATUS',

430: l_control_rec.approval_date := sysdate;
431: END IF;
432:
433: IF (l_control_rec.approval_status = 'R') THEN
434: amw_utility_pvt.error_message(p_message_name => 'AMW_INVALID_STATUS',
435: p_token_name => 'OBJ_TYPE',
436: p_token_value => G_OBJ_TYPE);
437: x_return_status := fnd_api.g_ret_sts_error;
438: RAISE fnd_api.g_exc_error;

Line 461: amw_utility_pvt.debug_message (l_api_name || ' end');

457: x_control_rev_id := l_control_rec.control_rev_id;
458: x_mode_affected := 'UPDATE_CONTROL';
459: END IF;
460: END IF;
461: amw_utility_pvt.debug_message (l_api_name || ' end');
462: -- Standard call to get message count and if count is 1, get message info.
463: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
464: EXCEPTION
465: WHEN fnd_api.g_exc_error THEN

Line 550: ---amw_utility_pvt.debug_message ('Private API: ' || l_api_name || 'start');

546: IF fnd_api.to_boolean (p_init_msg_list) THEN
547: fnd_msg_pub.initialize;
548: END IF;
549: -- Debug Message
550: ---amw_utility_pvt.debug_message ('Private API: ' || l_api_name || 'start');
551: amw_utility_pvt.debug_message (l_api_name || 'start');
552: -- Initialize API return status to SUCCESS
553: x_return_status := fnd_api.g_ret_sts_success;
554: -- Local variable initialization

Line 551: amw_utility_pvt.debug_message (l_api_name || 'start');

547: fnd_msg_pub.initialize;
548: END IF;
549: -- Debug Message
550: ---amw_utility_pvt.debug_message ('Private API: ' || l_api_name || 'start');
551: amw_utility_pvt.debug_message (l_api_name || 'start');
552: -- Initialize API return status to SUCCESS
553: x_return_status := fnd_api.g_ret_sts_success;
554: -- Local variable initialization
555: l_control_rec := p_control_rec;

Line 604: amw_utility_pvt.error_message(p_message_name => 'USER_PROFILE_MISSING');

600: -- =========================================================================
601: -- Validate Environment
602: -- =========================================================================
603: IF fnd_global.user_id IS NULL THEN
604: amw_utility_pvt.error_message(p_message_name => 'USER_PROFILE_MISSING');
605: RAISE fnd_api.g_exc_error;
606: END IF;
607: IF (p_validation_level >= fnd_api.g_valid_level_full) THEN
608: -- Debug message

Line 609: amw_utility_pvt.debug_message ('Private API: Validate_Control');

605: RAISE fnd_api.g_exc_error;
606: END IF;
607: IF (p_validation_level >= fnd_api.g_valid_level_full) THEN
608: -- Debug message
609: amw_utility_pvt.debug_message ('Private API: Validate_Control');
610: -- Invoke validation procedures
611: validate_control (p_mode => 'CREATE',
612: p_api_version_number => 1.0,
613: p_init_msg_list => fnd_api.g_false,

Line 625: amw_utility_pvt.debug_message ('Calling Create handler');

621: IF x_return_status <> fnd_api.g_ret_sts_success THEN
622: RAISE fnd_api.g_exc_error;
623: END IF;
624: -- Debug Message
625: amw_utility_pvt.debug_message ('Calling Create handler');
626: IF (l_control_rec.control_id IS NULL) THEN
627: l_control_id := l_control_id;
628: ELSE
629: l_control_id := l_control_rec.control_id;

Line 693: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',

689: --- NPANANDI 12.10.2004: ADDED BELOW FOR CTRL CLASSIFICATION
690: ,X_CLASSIFICATION => L_CONTROL_REC.CLASSIFICATION
691: );
692: IF x_return_status <> fnd_api.g_ret_sts_success THEN
693: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_EXE_ERROR',
694: p_token_name => 'OBJ_TYPE',
695: p_token_value => G_OBJ_TYPE);
696: RAISE fnd_api.g_exc_error;
697: END IF;

Line 707: amw_utility_pvt.debug_message (l_api_name || 'end');

703: COMMIT WORK;
704: END IF;
705: x_control_rev_id := l_control_rec.control_rev_id;
706: -- Debug Message
707: amw_utility_pvt.debug_message (l_api_name || 'end');
708: -- Standard call to get message count and if count is 1, get message info.
709: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
710: EXCEPTION
711: WHEN amw_utility_pvt.resource_locked THEN

Line 711: WHEN amw_utility_pvt.resource_locked THEN

707: amw_utility_pvt.debug_message (l_api_name || 'end');
708: -- Standard call to get message count and if count is 1, get message info.
709: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
710: EXCEPTION
711: WHEN amw_utility_pvt.resource_locked THEN
712: x_return_status := fnd_api.g_ret_sts_error;
713: amw_utility_pvt.error_message(p_message_name => 'AMW_API_RESOURCE_LOCKED');
714: WHEN fnd_api.g_exc_error THEN
715: ROLLBACK TO create_control_pvt;

Line 713: amw_utility_pvt.error_message(p_message_name => 'AMW_API_RESOURCE_LOCKED');

709: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
710: EXCEPTION
711: WHEN amw_utility_pvt.resource_locked THEN
712: x_return_status := fnd_api.g_ret_sts_error;
713: amw_utility_pvt.error_message(p_message_name => 'AMW_API_RESOURCE_LOCKED');
714: WHEN fnd_api.g_exc_error THEN
715: ROLLBACK TO create_control_pvt;
716: x_return_status := fnd_api.g_ret_sts_error;
717: -- Standard call to get message count and if count=1, get the message

Line 785: ----amw_utility_pvt.debug_message ('Private API: ' || l_api_name || 'start');

781: IF fnd_api.to_boolean (p_init_msg_list) THEN
782: fnd_msg_pub.initialize;
783: END IF;
784: -- Debug Message
785: ----amw_utility_pvt.debug_message ('Private API: ' || l_api_name || 'start');
786: amw_utility_pvt.debug_message (l_api_name || 'start');
787: -- Initialize API return status to SUCCESS
788: x_return_status := fnd_api.g_ret_sts_success;
789: -- Debug Message

Line 786: amw_utility_pvt.debug_message (l_api_name || 'start');

782: fnd_msg_pub.initialize;
783: END IF;
784: -- Debug Message
785: ----amw_utility_pvt.debug_message ('Private API: ' || l_api_name || 'start');
786: amw_utility_pvt.debug_message (l_api_name || 'start');
787: -- Initialize API return status to SUCCESS
788: x_return_status := fnd_api.g_ret_sts_success;
789: -- Debug Message
790:

Line 797: AMW_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',

793:
794: FETCH c_get_Control INTO l_ref_control_rec ;
795:
796: If ( c_get_Control%NOTFOUND) THEN
797: AMW_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
798: p_token_name => 'INFO',
799: p_token_value => 'Control') ;
800: RAISE FND_API.G_EXC_ERROR;
801: END IF;

Line 803: AMW_UTILITY_PVT.debug_message('Private API: - Close Cursor');

799: p_token_value => 'Control') ;
800: RAISE FND_API.G_EXC_ERROR;
801: END IF;
802: -- Debug Message
803: AMW_UTILITY_PVT.debug_message('Private API: - Close Cursor');
804: CLOSE c_get_Control;
805: */
806: --mpande comm
807: /*

Line 810: AMW_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',

806: --mpande comm
807: /*
808: If (l_tar_control_rec.object_version_number is NULL or
809: l_tar_control_rec.object_version_number = FND_API.G_MISS_NUM ) Then
810: AMW_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
811: p_token_name => 'COLUMN',
812: p_token_value => 'Last_Update_Date') ;
813: raise FND_API.G_EXC_ERROR;
814: End if;

Line 817: AMW_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',

813: raise FND_API.G_EXC_ERROR;
814: End if;
815: -- Check Whether record has been changed by someone else
816: If (l_tar_control_rec.object_version_number <> l_ref_control_rec.object_version_number) Then
817: AMW_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
818: p_token_name => 'INFO',
819: p_token_value => 'Control') ;
820: raise FND_API.G_EXC_ERROR;
821: End if;

Line 828: amw_utility_pvt.debug_message ('Calling Validate_Control');

824: l_control_rec.last_updated_by := g_user_id;
825: l_control_rec.last_update_login := g_login_id;
826: IF (p_validation_level >= fnd_api.g_valid_level_full) THEN
827: -- Debug message
828: amw_utility_pvt.debug_message ('Calling Validate_Control');
829: fnd_file.put_line (fnd_file.LOG,'$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$');
830: fnd_file.put_line (fnd_file.LOG,'l_control_rec.control_classification: '||l_control_rec.classification);
831: -- Invoke validation procedures
832: validate_control (p_mode => 'UPDATE',

Line 847: amw_utility_pvt.debug_message ('Calling Update handler');

843: IF x_return_status <> fnd_api.g_ret_sts_success THEN
844: RAISE fnd_api.g_exc_error;
845: END IF;
846: -- Debug Message
847: amw_utility_pvt.debug_message ('Calling Update handler');
848: amw_controls_pkg.update_row
849: (x_control_rev_id => l_control_rec.control_rev_id,
850: x_object_version_number => l_control_rec.object_version_number,
851: x_orig_system_reference => l_control_rec.orig_system_reference,

Line 914: --amw_utility_pvt.debug_message ('Private API: ' || l_api_name || 'end');

910: IF fnd_api.to_boolean (p_commit) THEN
911: COMMIT WORK;
912: END IF;
913: -- Debug Message
914: --amw_utility_pvt.debug_message ('Private API: ' || l_api_name || 'end');
915: amw_utility_pvt.debug_message (l_api_name || 'end');
916: -- Standard call to get message count and if count is 1, get message info.
917: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
918: EXCEPTION

Line 915: amw_utility_pvt.debug_message (l_api_name || 'end');

911: COMMIT WORK;
912: END IF;
913: -- Debug Message
914: --amw_utility_pvt.debug_message ('Private API: ' || l_api_name || 'end');
915: amw_utility_pvt.debug_message (l_api_name || 'end');
916: -- Standard call to get message count and if count is 1, get message info.
917: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
918: EXCEPTION
919: WHEN amw_utility_pvt.resource_locked THEN

Line 919: WHEN amw_utility_pvt.resource_locked THEN

915: amw_utility_pvt.debug_message (l_api_name || 'end');
916: -- Standard call to get message count and if count is 1, get message info.
917: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
918: EXCEPTION
919: WHEN amw_utility_pvt.resource_locked THEN
920: x_return_status := fnd_api.g_ret_sts_error;
921: amw_utility_pvt.error_message(p_message_name => 'AMW_API_RESOURCE_LOCKED');
922: WHEN fnd_api.g_exc_error THEN
923: ROLLBACK TO update_control_pvt;

Line 921: amw_utility_pvt.error_message(p_message_name => 'AMW_API_RESOURCE_LOCKED');

917: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
918: EXCEPTION
919: WHEN amw_utility_pvt.resource_locked THEN
920: x_return_status := fnd_api.g_ret_sts_error;
921: amw_utility_pvt.error_message(p_message_name => 'AMW_API_RESOURCE_LOCKED');
922: WHEN fnd_api.g_exc_error THEN
923: ROLLBACK TO update_control_pvt;
924: x_return_status := fnd_api.g_ret_sts_error;
925: -- Standard call to get message count and if count=1, get the message

Line 980: ----amw_utility_pvt.debug_message ('Private API: ' || l_api_name || 'start');

976: IF fnd_api.to_boolean (p_init_msg_list) THEN
977: fnd_msg_pub.initialize;
978: END IF;
979: -- Debug Message
980: ----amw_utility_pvt.debug_message ('Private API: ' || l_api_name || 'start');
981: amw_utility_pvt.debug_message (l_api_name || 'start');
982: -- Initialize API return status to SUCCESS
983: x_return_status := fnd_api.g_ret_sts_success;
984: --

Line 981: amw_utility_pvt.debug_message (l_api_name || 'start');

977: fnd_msg_pub.initialize;
978: END IF;
979: -- Debug Message
980: ----amw_utility_pvt.debug_message ('Private API: ' || l_api_name || 'start');
981: amw_utility_pvt.debug_message (l_api_name || 'start');
982: -- Initialize API return status to SUCCESS
983: x_return_status := fnd_api.g_ret_sts_success;
984: --
985: -- Api body

Line 988: ---amw_utility_pvt.debug_message ('Private API: Calling delete table handler');

984: --
985: -- Api body
986: --
987: -- Debug Message
988: ---amw_utility_pvt.debug_message ('Private API: Calling delete table handler');
989: amw_utility_pvt.debug_message ('Private API: Calling delete table handler');
990: -- Invoke table handler(AMW_CONTROLS_B_PKG.Delete_Row)
991: amw_controls_pkg.delete_row (x_control_rev_id => p_control_rev_id);
992: --

Line 989: amw_utility_pvt.debug_message ('Private API: Calling delete table handler');

985: -- Api body
986: --
987: -- Debug Message
988: ---amw_utility_pvt.debug_message ('Private API: Calling delete table handler');
989: amw_utility_pvt.debug_message ('Private API: Calling delete table handler');
990: -- Invoke table handler(AMW_CONTROLS_B_PKG.Delete_Row)
991: amw_controls_pkg.delete_row (x_control_rev_id => p_control_rev_id);
992: --
993: -- End of API body

Line 1001: ---amw_utility_pvt.debug_message ('Private API: ' || l_api_name || 'end');

997: IF fnd_api.to_boolean (p_commit) THEN
998: COMMIT WORK;
999: END IF;
1000: -- Debug Message
1001: ---amw_utility_pvt.debug_message ('Private API: ' || l_api_name || 'end');
1002: amw_utility_pvt.debug_message (l_api_name || ' end');
1003: -- Standard call to get message count and if count is 1, get message info.
1004: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1005: EXCEPTION

Line 1002: amw_utility_pvt.debug_message (l_api_name || ' end');

998: COMMIT WORK;
999: END IF;
1000: -- Debug Message
1001: ---amw_utility_pvt.debug_message ('Private API: ' || l_api_name || 'end');
1002: amw_utility_pvt.debug_message (l_api_name || ' end');
1003: -- Standard call to get message count and if count is 1, get message info.
1004: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1005: EXCEPTION
1006: WHEN amw_utility_pvt.resource_locked THEN

Line 1006: WHEN amw_utility_pvt.resource_locked THEN

1002: amw_utility_pvt.debug_message (l_api_name || ' end');
1003: -- Standard call to get message count and if count is 1, get message info.
1004: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1005: EXCEPTION
1006: WHEN amw_utility_pvt.resource_locked THEN
1007: x_return_status := fnd_api.g_ret_sts_error;
1008: -----amw_utility_pvt.error_message(p_message_name => 'AMW_API_RESOURCE_LOCKED');
1009: amw_utility_pvt.error_message(p_message_name => 'AMW_API_RESOURCE_LOCKED');
1010: WHEN fnd_api.g_exc_error THEN

Line 1008: -----amw_utility_pvt.error_message(p_message_name => 'AMW_API_RESOURCE_LOCKED');

1004: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1005: EXCEPTION
1006: WHEN amw_utility_pvt.resource_locked THEN
1007: x_return_status := fnd_api.g_ret_sts_error;
1008: -----amw_utility_pvt.error_message(p_message_name => 'AMW_API_RESOURCE_LOCKED');
1009: amw_utility_pvt.error_message(p_message_name => 'AMW_API_RESOURCE_LOCKED');
1010: WHEN fnd_api.g_exc_error THEN
1011: ROLLBACK TO delete_control_pvt;
1012: x_return_status := fnd_api.g_ret_sts_error;

Line 1009: amw_utility_pvt.error_message(p_message_name => 'AMW_API_RESOURCE_LOCKED');

1005: EXCEPTION
1006: WHEN amw_utility_pvt.resource_locked THEN
1007: x_return_status := fnd_api.g_ret_sts_error;
1008: -----amw_utility_pvt.error_message(p_message_name => 'AMW_API_RESOURCE_LOCKED');
1009: amw_utility_pvt.error_message(p_message_name => 'AMW_API_RESOURCE_LOCKED');
1010: WHEN fnd_api.g_exc_error THEN
1011: ROLLBACK TO delete_control_pvt;
1012: x_return_status := fnd_api.g_ret_sts_error;
1013: -- Standard call to get message count and if count=1, get the message

Line 1061: ----amw_utility_pvt.debug_message ('Private API: ' || l_api_name || 'start');

1057: AND object_version_number = p_object_version
1058: FOR UPDATE NOWAIT;
1059: BEGIN
1060: -- Debug Message
1061: ----amw_utility_pvt.debug_message ('Private API: ' || l_api_name || 'start');
1062: amw_utility_pvt.debug_message (l_api_name || 'start');
1063: -- Initialize message list if p_init_msg_list is set to TRUE.
1064: IF fnd_api.to_boolean (p_init_msg_list) THEN
1065: fnd_msg_pub.initialize;

Line 1062: amw_utility_pvt.debug_message (l_api_name || 'start');

1058: FOR UPDATE NOWAIT;
1059: BEGIN
1060: -- Debug Message
1061: ----amw_utility_pvt.debug_message ('Private API: ' || l_api_name || 'start');
1062: amw_utility_pvt.debug_message (l_api_name || 'start');
1063: -- Initialize message list if p_init_msg_list is set to TRUE.
1064: IF fnd_api.to_boolean (p_init_msg_list) THEN
1065: fnd_msg_pub.initialize;
1066: END IF;

Line 1078: amw_utility_pvt.debug_message (l_full_name || ': start');

1074: END IF;
1075: -- Initialize API return status to SUCCESS
1076: x_return_status := fnd_api.g_ret_sts_success;
1077: ------------------------ lock -------------------------
1078: amw_utility_pvt.debug_message (l_full_name || ': start');
1079: OPEN c_control;
1080: FETCH c_control
1081: INTO l_control_rev_id;
1082: IF (c_control%NOTFOUND) THEN

Line 1096: amw_utility_pvt.debug_message (l_full_name || ': end');

1092: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
1093: p_count => x_msg_count,
1094: p_data => x_msg_data
1095: );
1096: amw_utility_pvt.debug_message (l_full_name || ': end');
1097: EXCEPTION
1098: WHEN amw_utility_pvt.resource_locked THEN
1099: x_return_status := fnd_api.g_ret_sts_error;
1100: amw_utility_pvt.error_message(p_message_name => 'AMW_API_RESOURCE_LOCKED');

Line 1098: WHEN amw_utility_pvt.resource_locked THEN

1094: p_data => x_msg_data
1095: );
1096: amw_utility_pvt.debug_message (l_full_name || ': end');
1097: EXCEPTION
1098: WHEN amw_utility_pvt.resource_locked THEN
1099: x_return_status := fnd_api.g_ret_sts_error;
1100: amw_utility_pvt.error_message(p_message_name => 'AMW_API_RESOURCE_LOCKED');
1101: WHEN fnd_api.g_exc_error THEN
1102: ROLLBACK TO lock_control_pvt;

Line 1100: amw_utility_pvt.error_message(p_message_name => 'AMW_API_RESOURCE_LOCKED');

1096: amw_utility_pvt.debug_message (l_full_name || ': end');
1097: EXCEPTION
1098: WHEN amw_utility_pvt.resource_locked THEN
1099: x_return_status := fnd_api.g_ret_sts_error;
1100: amw_utility_pvt.error_message(p_message_name => 'AMW_API_RESOURCE_LOCKED');
1101: WHEN fnd_api.g_exc_error THEN
1102: ROLLBACK TO lock_control_pvt;
1103: x_return_status := fnd_api.g_ret_sts_error;
1104: -- Standard call to get message count and if count=1, get the message

Line 1139: amw_utility_pvt.check_uniqueness ('AMW_CONTROLS_B','CONTROL_REV_ID = '''|| p_control_rec.control_rev_id|| '''');

1135: BEGIN
1136: x_return_status := fnd_api.g_ret_sts_success;
1137: IF p_validation_mode = 'CREATE' THEN
1138: l_valid_flag :=
1139: amw_utility_pvt.check_uniqueness ('AMW_CONTROLS_B','CONTROL_REV_ID = '''|| p_control_rec.control_rev_id|| '''');
1140: ELSE
1141: l_valid_flag :=
1142: amw_utility_pvt.check_uniqueness ('AMW_CONTROLS_B','CONTROL_REV_ID = '''|| p_control_rec.control_rev_id|| ''' AND CONTROL_REV_ID <> '|| p_control_rec.control_rev_id);
1143: END IF;

Line 1142: amw_utility_pvt.check_uniqueness ('AMW_CONTROLS_B','CONTROL_REV_ID = '''|| p_control_rec.control_rev_id|| ''' AND CONTROL_REV_ID <> '|| p_control_rec.control_rev_id);

1138: l_valid_flag :=
1139: amw_utility_pvt.check_uniqueness ('AMW_CONTROLS_B','CONTROL_REV_ID = '''|| p_control_rec.control_rev_id|| '''');
1140: ELSE
1141: l_valid_flag :=
1142: amw_utility_pvt.check_uniqueness ('AMW_CONTROLS_B','CONTROL_REV_ID = '''|| p_control_rec.control_rev_id|| ''' AND CONTROL_REV_ID <> '|| p_control_rec.control_rev_id);
1143: END IF;
1144: IF l_valid_flag = fnd_api.g_false THEN
1145: ---amw_utility_pvt.error_message(p_message_name => 'AMW_CONTROL_REV_ID_DUPLICATE');
1146: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_UNIQUE_ITEM_ERROR',

Line 1145: ---amw_utility_pvt.error_message(p_message_name => 'AMW_CONTROL_REV_ID_DUPLICATE');

1141: l_valid_flag :=
1142: amw_utility_pvt.check_uniqueness ('AMW_CONTROLS_B','CONTROL_REV_ID = '''|| p_control_rec.control_rev_id|| ''' AND CONTROL_REV_ID <> '|| p_control_rec.control_rev_id);
1143: END IF;
1144: IF l_valid_flag = fnd_api.g_false THEN
1145: ---amw_utility_pvt.error_message(p_message_name => 'AMW_CONTROL_REV_ID_DUPLICATE');
1146: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_UNIQUE_ITEM_ERROR',
1147: p_token_name => 'ITEM',
1148: p_token_value => 'Control_Rev_Id');
1149:

Line 1146: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_UNIQUE_ITEM_ERROR',

1142: amw_utility_pvt.check_uniqueness ('AMW_CONTROLS_B','CONTROL_REV_ID = '''|| p_control_rec.control_rev_id|| ''' AND CONTROL_REV_ID <> '|| p_control_rec.control_rev_id);
1143: END IF;
1144: IF l_valid_flag = fnd_api.g_false THEN
1145: ---amw_utility_pvt.error_message(p_message_name => 'AMW_CONTROL_REV_ID_DUPLICATE');
1146: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_UNIQUE_ITEM_ERROR',
1147: p_token_name => 'ITEM',
1148: p_token_value => 'Control_Rev_Id');
1149:
1150: x_return_status := fnd_api.g_ret_sts_error;

Line 1164: ---amw_utility_pvt.error_message(p_message_name => 'AMW_control_NO_control_id');

1160: x_return_status := fnd_api.g_ret_sts_success;
1161: IF p_validation_mode = 'CREATE' THEN
1162: IF p_control_rec.control_id = fnd_api.g_miss_num
1163: OR p_control_rec.control_id IS NULL THEN
1164: ---amw_utility_pvt.error_message(p_message_name => 'AMW_control_NO_control_id');
1165: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',
1166: p_token_name => 'ITEM',
1167: p_token_value => 'Control_Id');
1168:

Line 1165: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',

1161: IF p_validation_mode = 'CREATE' THEN
1162: IF p_control_rec.control_id = fnd_api.g_miss_num
1163: OR p_control_rec.control_id IS NULL THEN
1164: ---amw_utility_pvt.error_message(p_message_name => 'AMW_control_NO_control_id');
1165: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',
1166: p_token_name => 'ITEM',
1167: p_token_value => 'Control_Id');
1168:
1169: x_return_status := fnd_api.g_ret_sts_error;

Line 1174: ----amw_utility_pvt.error_message(p_message_name => 'AMW_ctrl_NO_last_update_date');

1170: RETURN;
1171: END IF;
1172: IF p_control_rec.last_update_date = fnd_api.g_miss_date
1173: OR p_control_rec.last_update_date IS NULL THEN
1174: ----amw_utility_pvt.error_message(p_message_name => 'AMW_ctrl_NO_last_update_date');
1175: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',
1176: p_token_name => 'ITEM',
1177: p_token_value => 'Last_Update_Date');
1178: x_return_status := fnd_api.g_ret_sts_error;

Line 1175: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',

1171: END IF;
1172: IF p_control_rec.last_update_date = fnd_api.g_miss_date
1173: OR p_control_rec.last_update_date IS NULL THEN
1174: ----amw_utility_pvt.error_message(p_message_name => 'AMW_ctrl_NO_last_update_date');
1175: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',
1176: p_token_name => 'ITEM',
1177: p_token_value => 'Last_Update_Date');
1178: x_return_status := fnd_api.g_ret_sts_error;
1179: RETURN;

Line 1184: AMW_Utility_PVT.Error_Message(p_message_name => 'AMW_control_NO_last_updated_by');

1180: END IF;
1181:
1182: /*
1183: IF p_control_rec.last_updated_by = FND_API.g_miss_num OR p_control_rec.last_updated_by IS NULL THEN
1184: AMW_Utility_PVT.Error_Message(p_message_name => 'AMW_control_NO_last_updated_by');
1185: x_return_status := FND_API.g_ret_sts_error;
1186: RETURN;
1187: END IF;
1188:

Line 1191: AMW_Utility_PVT.Error_Message(p_message_name => 'AMW_control_NO_creation_date');

1187: END IF;
1188:
1189:
1190: IF p_control_rec.creation_date = FND_API.g_miss_date OR p_control_rec.creation_date IS NULL THEN
1191: AMW_Utility_PVT.Error_Message(p_message_name => 'AMW_control_NO_creation_date');
1192: x_return_status := FND_API.g_ret_sts_error;
1193: RETURN;
1194: END IF;
1195:

Line 1198: AMW_Utility_PVT.Error_Message(p_message_name => 'AMW_control_NO_created_by');

1194: END IF;
1195:
1196:
1197: IF p_control_rec.created_by = FND_API.g_miss_num OR p_control_rec.created_by IS NULL THEN
1198: AMW_Utility_PVT.Error_Message(p_message_name => 'AMW_control_NO_created_by');
1199: x_return_status := FND_API.g_ret_sts_error;
1200: RETURN;
1201: END IF;
1202:

Line 1206: ----amw_utility_pvt.error_message(p_message_name => 'AMW_control_NO_control_rev_id');

1202:
1203: */
1204: IF p_control_rec.control_rev_id = fnd_api.g_miss_num
1205: OR p_control_rec.control_rev_id IS NULL THEN
1206: ----amw_utility_pvt.error_message(p_message_name => 'AMW_control_NO_control_rev_id');
1207: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',
1208: p_token_name => 'ITEM',
1209: p_token_value => 'Control_Rev_Id');
1210: x_return_status := fnd_api.g_ret_sts_error;

Line 1207: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',

1203: */
1204: IF p_control_rec.control_rev_id = fnd_api.g_miss_num
1205: OR p_control_rec.control_rev_id IS NULL THEN
1206: ----amw_utility_pvt.error_message(p_message_name => 'AMW_control_NO_control_rev_id');
1207: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',
1208: p_token_name => 'ITEM',
1209: p_token_value => 'Control_Rev_Id');
1210: x_return_status := fnd_api.g_ret_sts_error;
1211: RETURN;

Line 1215: ---amw_utility_pvt.error_message(p_message_name => 'AMW_control_NO_rev_num');

1211: RETURN;
1212: END IF;
1213: IF p_control_rec.rev_num = fnd_api.g_miss_num
1214: OR p_control_rec.rev_num IS NULL THEN
1215: ---amw_utility_pvt.error_message(p_message_name => 'AMW_control_NO_rev_num');
1216: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',
1217: p_token_name => 'ITEM',
1218: p_token_value => 'Rev_Num');
1219: x_return_status := fnd_api.g_ret_sts_error;

Line 1216: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',

1212: END IF;
1213: IF p_control_rec.rev_num = fnd_api.g_miss_num
1214: OR p_control_rec.rev_num IS NULL THEN
1215: ---amw_utility_pvt.error_message(p_message_name => 'AMW_control_NO_rev_num');
1216: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',
1217: p_token_name => 'ITEM',
1218: p_token_value => 'Rev_Num');
1219: x_return_status := fnd_api.g_ret_sts_error;
1220: RETURN;

Line 1225: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',

1221: END IF;
1222: ELSE ----Update mode checks
1223:
1224: IF p_control_rec.last_update_date IS NULL THEN
1225: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',
1226: p_token_name => 'ITEM',
1227: p_token_value => 'Last_Update_Date');
1228: x_return_status := fnd_api.g_ret_sts_error;
1229: RETURN;

Line 1232: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',

1228: x_return_status := fnd_api.g_ret_sts_error;
1229: RETURN;
1230: END IF;
1231: IF p_control_rec.control_rev_id IS NULL THEN
1232: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_REQUIRE_ITEM_ERROR',
1233: p_token_name => 'ITEM',
1234: p_token_value => 'Control_Rev_Id');
1235: x_return_status := fnd_api.g_ret_sts_error;
1236: RETURN;

Line 1257: ---amw_utility_pvt.CHECK_LOOKUP_EXISTS();

1253: ) IS
1254: BEGIN
1255: x_return_status := fnd_api.g_ret_sts_success;
1256: -- Enter custom code here
1257: ---amw_utility_pvt.CHECK_LOOKUP_EXISTS();
1258: END check_control_lookup_items;
1259:
1260: PROCEDURE check_control_items (
1261: p_control_rec IN control_rec_type,

Line 1657: ---amw_utility_pvt.debug_message ('Private API: ' || l_api_name || 'start');

1653: RAISE fnd_api.g_exc_unexpected_error;
1654: END IF;
1655: END IF;
1656: -- Debug Message
1657: ---amw_utility_pvt.debug_message ('Private API: ' || l_api_name || 'start');
1658: amw_utility_pvt.debug_message (l_api_name || 'start');
1659: -- Initialize API return status to SUCCESS
1660: x_return_status := fnd_api.g_ret_sts_success;
1661: -- Debug Message

Line 1658: amw_utility_pvt.debug_message (l_api_name || 'start');

1654: END IF;
1655: END IF;
1656: -- Debug Message
1657: ---amw_utility_pvt.debug_message ('Private API: ' || l_api_name || 'start');
1658: amw_utility_pvt.debug_message (l_api_name || 'start');
1659: -- Initialize API return status to SUCCESS
1660: x_return_status := fnd_api.g_ret_sts_success;
1661: -- Debug Message
1662: ---amw_utility_pvt.debug_message ('Private API: ' || l_api_name || 'end');

Line 1662: ---amw_utility_pvt.debug_message ('Private API: ' || l_api_name || 'end');

1658: amw_utility_pvt.debug_message (l_api_name || 'start');
1659: -- Initialize API return status to SUCCESS
1660: x_return_status := fnd_api.g_ret_sts_success;
1661: -- Debug Message
1662: ---amw_utility_pvt.debug_message ('Private API: ' || l_api_name || 'end');
1663: amw_utility_pvt.debug_message (l_api_name || 'end');
1664: -- Standard call to get message count and if count is 1, get message info.
1665: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1666: EXCEPTION

Line 1663: amw_utility_pvt.debug_message (l_api_name || 'end');

1659: -- Initialize API return status to SUCCESS
1660: x_return_status := fnd_api.g_ret_sts_success;
1661: -- Debug Message
1662: ---amw_utility_pvt.debug_message ('Private API: ' || l_api_name || 'end');
1663: amw_utility_pvt.debug_message (l_api_name || 'end');
1664: -- Standard call to get message count and if count is 1, get message info.
1665: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1666: EXCEPTION
1667: WHEN amw_utility_pvt.resource_locked THEN

Line 1667: WHEN amw_utility_pvt.resource_locked THEN

1663: amw_utility_pvt.debug_message (l_api_name || 'end');
1664: -- Standard call to get message count and if count is 1, get message info.
1665: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1666: EXCEPTION
1667: WHEN amw_utility_pvt.resource_locked THEN
1668: x_return_status := fnd_api.g_ret_sts_error;
1669: amw_utility_pvt.error_message(p_message_name => 'AMW_API_RESOURCE_LOCKED');
1670: WHEN fnd_api.g_exc_error THEN
1671: ROLLBACK TO validate_control;

Line 1669: amw_utility_pvt.error_message(p_message_name => 'AMW_API_RESOURCE_LOCKED');

1665: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1666: EXCEPTION
1667: WHEN amw_utility_pvt.resource_locked THEN
1668: x_return_status := fnd_api.g_ret_sts_error;
1669: amw_utility_pvt.error_message(p_message_name => 'AMW_API_RESOURCE_LOCKED');
1670: WHEN fnd_api.g_exc_error THEN
1671: ROLLBACK TO validate_control;
1672: x_return_status := fnd_api.g_ret_sts_error;
1673: -- Standard call to get message count and if count=1, get the message

Line 1719: amw_utility_pvt.debug_message ('Validate_conrol_rec starts');

1715: -- If data not valid
1716: -- THEN
1717: -- x_return_status := FND_API.G_RET_STS_ERROR;
1718: -- Debug Message
1719: amw_utility_pvt.debug_message ('Validate_conrol_rec starts');
1720: IF (p_control_rec.NAME IS NULL OR p_control_rec.NAME = '') THEN
1721: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_WEBADI_REQUIRED_ERROR',
1722: p_token_name => 'ITEM',
1723: p_token_value => 'Control Name');

Line 1721: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_WEBADI_REQUIRED_ERROR',

1717: -- x_return_status := FND_API.G_RET_STS_ERROR;
1718: -- Debug Message
1719: amw_utility_pvt.debug_message ('Validate_conrol_rec starts');
1720: IF (p_control_rec.NAME IS NULL OR p_control_rec.NAME = '') THEN
1721: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_WEBADI_REQUIRED_ERROR',
1722: p_token_name => 'ITEM',
1723: p_token_value => 'Control Name');
1724: x_return_status := fnd_api.g_ret_sts_error;
1725: END IF;

Line 1729: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_WEBADI_REQUIRED_ERROR',

1725: END IF;
1726: IF ( p_control_rec.description IS NULL
1727: OR TRIM (p_control_rec.description) = ''
1728: ) THEN
1729: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_WEBADI_REQUIRED_ERROR',
1730: p_token_name => 'ITEM',
1731: p_token_value => 'Control Description');
1732: x_return_status := fnd_api.g_ret_sts_error;
1733: END IF;

Line 1737: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_WEBADI_REQUIRED_ERROR',

1733: END IF;
1734: IF ( p_control_rec.control_type IS NULL
1735: OR TRIM (p_control_rec.control_type) = ''
1736: ) THEN
1737: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_WEBADI_REQUIRED_ERROR',
1738: p_token_name => 'ITEM',
1739: p_token_value => 'Control Type');
1740: x_return_status := fnd_api.g_ret_sts_error;
1741: ELSE

Line 1742: IF fnd_api.to_boolean(amw_utility_pvt.check_lookup_exists ('AMW_LOOKUPS','AMW_CONTROL_TYPE',p_control_rec.control_type)) THEN

1738: p_token_name => 'ITEM',
1739: p_token_value => 'Control Type');
1740: x_return_status := fnd_api.g_ret_sts_error;
1741: ELSE
1742: IF fnd_api.to_boolean(amw_utility_pvt.check_lookup_exists ('AMW_LOOKUPS','AMW_CONTROL_TYPE',p_control_rec.control_type)) THEN
1743: amw_utility_pvt.debug_message('AMW_Valid_Control_Type');
1744: ELSE
1745: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_WEBADI_VALID_ERROR',
1746: p_token_name => 'ITEM',

Line 1743: amw_utility_pvt.debug_message('AMW_Valid_Control_Type');

1739: p_token_value => 'Control Type');
1740: x_return_status := fnd_api.g_ret_sts_error;
1741: ELSE
1742: IF fnd_api.to_boolean(amw_utility_pvt.check_lookup_exists ('AMW_LOOKUPS','AMW_CONTROL_TYPE',p_control_rec.control_type)) THEN
1743: amw_utility_pvt.debug_message('AMW_Valid_Control_Type');
1744: ELSE
1745: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_WEBADI_VALID_ERROR',
1746: p_token_name => 'ITEM',
1747: p_token_value => 'Control Type');

Line 1745: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_WEBADI_VALID_ERROR',

1741: ELSE
1742: IF fnd_api.to_boolean(amw_utility_pvt.check_lookup_exists ('AMW_LOOKUPS','AMW_CONTROL_TYPE',p_control_rec.control_type)) THEN
1743: amw_utility_pvt.debug_message('AMW_Valid_Control_Type');
1744: ELSE
1745: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_WEBADI_VALID_ERROR',
1746: p_token_name => 'ITEM',
1747: p_token_value => 'Control Type');
1748: x_return_status := fnd_api.g_ret_sts_error;
1749: END IF;

Line 1754: IF (amw_utility_pvt.check_lookup_exists ('AMW_LOOKUPS','AMW_CONTROL_LOCATION',p_control_rec.control_location) = fnd_api.g_false

1750: END IF;
1751: IF ( p_control_rec.control_location IS NOT NULL
1752: OR p_control_rec.control_location <> ''
1753: ) THEN
1754: IF (amw_utility_pvt.check_lookup_exists ('AMW_LOOKUPS','AMW_CONTROL_LOCATION',p_control_rec.control_location) = fnd_api.g_false
1755: ) THEN
1756: amw_utility_pvt.debug_message('AMW_Control_Location_Invalid');
1757: x_return_status := fnd_api.g_ret_sts_error;
1758: END IF;

Line 1756: amw_utility_pvt.debug_message('AMW_Control_Location_Invalid');

1752: OR p_control_rec.control_location <> ''
1753: ) THEN
1754: IF (amw_utility_pvt.check_lookup_exists ('AMW_LOOKUPS','AMW_CONTROL_LOCATION',p_control_rec.control_location) = fnd_api.g_false
1755: ) THEN
1756: amw_utility_pvt.debug_message('AMW_Control_Location_Invalid');
1757: x_return_status := fnd_api.g_ret_sts_error;
1758: END IF;
1759: END IF;
1760:

Line 1766: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_WEBADI_REQUIRED_ERROR',

1762: --Bug 4670522 : Removed the 'Required' check
1763: /* IF ( p_control_rec.classification IS NULL
1764: OR TRIM (p_control_rec.classification) = ''
1765: ) THEN
1766: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_WEBADI_REQUIRED_ERROR',
1767: p_token_name => 'ITEM',
1768: p_token_value => 'Control Classification');
1769: x_return_status := fnd_api.g_ret_sts_error;
1770: END IF;

Line 1773: amw_utility_pvt.debug_message ('Validate_dm_model_rec ends');

1769: x_return_status := fnd_api.g_ret_sts_error;
1770: END IF;
1771: */
1772: -- Debug Message
1773: amw_utility_pvt.debug_message ('Validate_dm_model_rec ends');
1774: -- Standard call to get message count and if count is 1, get message info.
1775: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1776: END validate_control_rec;
1777: END amw_control_pvt;