DBA Data[Home] [Help]

APPS.AMS_ACTPARTNER_PVT dependencies on AMS_UTILITY_PVT

Line 95: AMS_Utility_PVT.debug_message(l_full_name ||': validate');

91:
92: ----------------------- validate -----------------------
93: IF (AMS_DEBUG_HIGH_ON) THEN
94:
95: AMS_Utility_PVT.debug_message(l_full_name ||': validate');
96: END IF;
97:
98: validate_act_partner
99: (

Line 118: AMS_Utility_PVT.debug_message(l_full_name ||': insert');

114:
115: -------------------------- insert --------------------------
116: IF (AMS_DEBUG_HIGH_ON) THEN
117:
118: AMS_Utility_PVT.debug_message(l_full_name ||': insert');
119: END IF;
120:
121: IF l_act_partner_rec.activity_partner_id IS NULL THEN
122: LOOP

Line 215: AMS_Utility_PVT.debug_message(l_full_name ||': call modify_object_attribute');

211: IF (AMS_DEBUG_HIGH_ON) THEN
212:
213:
214:
215: AMS_Utility_PVT.debug_message(l_full_name ||': call modify_object_attribute');
216:
217: END IF;
218:
219: IF l_return_status = FND_API.g_ret_sts_error THEN

Line 242: AMS_Utility_PVT.debug_message(l_full_name ||': end');

238: IF (AMS_DEBUG_HIGH_ON) THEN
239:
240:
241:
242: AMS_Utility_PVT.debug_message(l_full_name ||': end');
243:
244: END IF;
245:
246: EXCEPTION

Line 350: AMS_Utility_PVT.debug_message('check_act_partner_items');

346: IF (AMS_DEBUG_HIGH_ON) THEN
347:
348:
349:
350: AMS_Utility_PVT.debug_message('check_act_partner_items');
351:
352: END IF;
353:
354: check_act_partner_items(

Line 374: AMS_Utility_PVT.debug_message('check_act_partner_record');

370: IF (AMS_DEBUG_HIGH_ON) THEN
371:
372:
373:
374: AMS_Utility_PVT.debug_message('check_act_partner_record');
375:
376: END IF;
377:
378: check_act_partner_record(

Line 450: AMS_Utility_PVT.debug_message(l_full_name ||': end');

446: IF (AMS_DEBUG_HIGH_ON) THEN
447:
448:
449:
450: AMS_Utility_PVT.debug_message(l_full_name ||': end');
451:
452: END IF;
453:
454:

Line 460: AMS_Utility_PVT.debug_message('into exception block');

456:
457: WHEN FND_API.g_exc_error THEN
458: IF (AMS_DEBUG_HIGH_ON) THEN
459:
460: AMS_Utility_PVT.debug_message('into exception block');
461: END IF;
462:
463: ROLLBACK TO update_act_partner;
464: x_return_status := FND_API.g_ret_sts_error;

Line 570: AMS_Utility_PVT.debug_message(l_full_name||': start');

566: IF (AMS_DEBUG_HIGH_ON) THEN
567:
568:
569:
570: AMS_Utility_PVT.debug_message(l_full_name||': start');
571:
572: END IF;
573:
574: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 597: AMS_Utility_PVT.debug_message(p_act_partner_id ||': p_act_partner_id');

593:
594: ------------------------ delete ------------------------
595: IF (AMS_DEBUG_HIGH_ON) THEN
596:
597: AMS_Utility_PVT.debug_message(p_act_partner_id ||': p_act_partner_id');
598: END IF;
599: IF (AMS_DEBUG_HIGH_ON) THEN
600:
601: AMS_Utility_PVT.debug_message(p_object_version ||': p_object_version');

Line 601: AMS_Utility_PVT.debug_message(p_object_version ||': p_object_version');

597: AMS_Utility_PVT.debug_message(p_act_partner_id ||': p_act_partner_id');
598: END IF;
599: IF (AMS_DEBUG_HIGH_ON) THEN
600:
601: AMS_Utility_PVT.debug_message(p_object_version ||': p_object_version');
602: END IF;
603:
604: DELETE FROM ams_act_partners
605: WHERE activity_partner_id = p_act_partner_id

Line 633: AMS_Utility_PVT.debug_message(l_full_name ||': end');

629: IF (AMS_DEBUG_HIGH_ON) THEN
630:
631:
632:
633: AMS_Utility_PVT.debug_message(l_full_name ||': end');
634:
635: END IF;
636:
637: EXCEPTION

Line 715: AMS_Utility_PVT.debug_message(l_full_name||': start');

711:
712: -------------------- initialize ------------------------
713: IF (AMS_DEBUG_HIGH_ON) THEN
714:
715: AMS_Utility_PVT.debug_message(l_full_name||': start');
716: END IF;
717:
718: IF FND_API.to_boolean(p_init_msg_list) THEN
719: FND_MSG_PUB.initialize;

Line 736: AMS_Utility_PVT.debug_message(l_full_name||': lock');

732:
733: ------------------------ lock -------------------------
734: IF (AMS_DEBUG_HIGH_ON) THEN
735:
736: AMS_Utility_PVT.debug_message(l_full_name||': lock');
737: END IF;
738:
739: OPEN c_act_partner;
740: FETCH c_act_partner INTO l_act_partner_id;

Line 762: AMS_Utility_PVT.debug_message(l_full_name ||': end');

758: IF (AMS_DEBUG_HIGH_ON) THEN
759:
760:
761:
762: AMS_Utility_PVT.debug_message(l_full_name ||': end');
763:
764: END IF;
765:
766: EXCEPTION

Line 768: WHEN AMS_Utility_PVT.resource_locked THEN

764: END IF;
765:
766: EXCEPTION
767:
768: WHEN AMS_Utility_PVT.resource_locked THEN
769: x_return_status := FND_API.g_ret_sts_error;
770: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
771: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
772: FND_MSG_PUB.add;

Line 846: AMS_Utility_PVT.debug_message(l_full_name||': start');

842:
843: ----------------------- initialize --------------------
844: IF (AMS_DEBUG_HIGH_ON) THEN
845:
846: AMS_Utility_PVT.debug_message(l_full_name||': start');
847: END IF;
848:
849: IF FND_API.to_boolean(p_init_msg_list) THEN
850: FND_MSG_PUB.initialize;

Line 867: AMS_Utility_PVT.debug_message(l_full_name||': check items');

863:
864: ---------------------- validate ------------------------
865: IF (AMS_DEBUG_HIGH_ON) THEN
866:
867: AMS_Utility_PVT.debug_message(l_full_name||': check items');
868: END IF;
869:
870: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
871: check_act_partner_items(

Line 888: AMS_Utility_PVT.debug_message(l_full_name||': check record');

884: IF (AMS_DEBUG_HIGH_ON) THEN
885:
886:
887:
888: AMS_Utility_PVT.debug_message(l_full_name||': check record');
889:
890: END IF;
891:
892: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

Line 917: AMS_Utility_PVT.debug_message(l_full_name ||': end');

913: IF (AMS_DEBUG_HIGH_ON) THEN
914:
915:
916:
917: AMS_Utility_PVT.debug_message(l_full_name ||': end');
918:
919: END IF;
920:
921: EXCEPTION

Line 1161: AMS_Utility_PVT.debug_message('end cursor...');

1157: END IF;
1158: --CLOSE c_act_partner;
1159: IF (AMS_DEBUG_HIGH_ON) THEN
1160:
1161: AMS_Utility_PVT.debug_message('end cursor...');
1162: END IF;
1163:
1164: IF p_act_partner_rec.act_partner_used_by_id = FND_API.g_miss_num THEN
1165: x_complete_rec.act_partner_used_by_id := l_act_partner_rec.act_partner_used_by_id;

Line 1265: AMS_Utility_PVT.debug_message('end of complete_act_partner_rec...');

1261: x_complete_rec.attribute15 := l_act_partner_rec.attribute15;
1262: END IF;
1263: IF (AMS_DEBUG_HIGH_ON) THEN
1264:
1265: AMS_Utility_PVT.debug_message('end of complete_act_partner_rec...');
1266: END IF;
1267:
1268: END complete_act_partner_rec;
1269:

Line 1296: AMS_Utility_PVT.debug_message(':error message');

1292: l_arc_act_partner_used_by := p_arc_act_partner_used_by;
1293: l_act_partner_used_by_id := p_act_partner_used_by_id;
1294: IF (AMS_DEBUG_HIGH_ON) THEN
1295:
1296: AMS_Utility_PVT.debug_message(':error message');
1297: END IF;
1298: OPEN c_primary_flag(l_act_partner_used_by_id,l_arc_act_partner_used_by);
1299: FETCH c_primary_flag INTO l_flag;
1300: CLOSE c_primary_flag;

Line 1307: AMS_Utility_PVT.debug_message(':p_primary_flag = T');

1303: IF (p_primary_flag = 'Y') THEN
1304: -- dbms_output.put_line(':p_primary_flag = T');
1305: IF (AMS_DEBUG_HIGH_ON) THEN
1306:
1307: AMS_Utility_PVT.debug_message(':p_primary_flag = T');
1308: END IF;
1309: l_flagStatus := l_flagStatus + 1;
1310: END IF;
1311:

Line 1316: AMS_Utility_PVT.debug_message(':error message');

1312: IF (l_flagStatus >=2) THEN
1313: -- dbms_output.put_line(':error message');
1314: IF (AMS_DEBUG_HIGH_ON) THEN
1315:
1316: AMS_Utility_PVT.debug_message(':error message');
1317: END IF;
1318: --AMS_Utility_PVT.error_message ('AMS_ACT_INVALID_PRIMARY', 'PRIMARY_FLAG', p_primary_flag);
1319: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1320: FND_MESSAGE.set_name('AMS', 'AMS_ACT_INVALID_PRIMARY');

Line 1318: --AMS_Utility_PVT.error_message ('AMS_ACT_INVALID_PRIMARY', 'PRIMARY_FLAG', p_primary_flag);

1314: IF (AMS_DEBUG_HIGH_ON) THEN
1315:
1316: AMS_Utility_PVT.debug_message(':error message');
1317: END IF;
1318: --AMS_Utility_PVT.error_message ('AMS_ACT_INVALID_PRIMARY', 'PRIMARY_FLAG', p_primary_flag);
1319: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1320: FND_MESSAGE.set_name('AMS', 'AMS_ACT_INVALID_PRIMARY');
1321: FND_MSG_PUB.add;
1322: END IF;

Line 1341: IF AMS_Utility_PVT.check_uniqueness (

1337: BEGIN
1338: x_return_status := FND_API.g_ret_sts_success;
1339:
1340: -- validate uniqueness of arc_used_by, arc_used_by_id, and partner_id
1341: IF AMS_Utility_PVT.check_uniqueness (
1342: 'AMS_ACT_PARTNERS',
1343: 'arc_act_partner_used_by = ' || p_act_partner_rec.arc_act_partner_used_by ||
1344: ' AND act_partner_used_by_id = ' || p_act_partner_rec.act_partner_used_by_id ||
1345: ' AND partner_id = ' || p_act_partner_rec.partner_id

Line 1350: AMS_Utility_PVT.error_message ('AMS_ACTPART_DUP_ACTPARTNER', 'PARTNER_NAME', l_partner_name);

1346: ) = FND_API.g_false THEN
1347: OPEN c_partner_name (p_act_partner_rec.partner_id);
1348: FETCH c_partner_name INTO l_partner_name;
1349: CLOSE c_partner_name;
1350: AMS_Utility_PVT.error_message ('AMS_ACTPART_DUP_ACTPARTNER', 'PARTNER_NAME', l_partner_name);
1351: x_return_status := FND_API.g_ret_sts_error;
1352: END IF;
1353: END check_act_partner_uk_items;
1354: