APPS.AMS_APPROVAL_DETAILS_PVT dependencies on FND_MSG_PUB

Line 64: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

60:
61: -- Global CONSTANTS
62: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AMS_Approval_Details_PVT';
63:
64: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
65: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
66: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
67:
68: FUNCTION compare_columns(

Line 65: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

61: -- Global CONSTANTS
62: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AMS_Approval_Details_PVT';
63:
64: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
65: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
66: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
67:
68: FUNCTION compare_columns(
69: p_approval_details_rec IN Approval_Details_Rec_Type

Line 66: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

62: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AMS_Approval_Details_PVT';
63:
64: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
65: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
66: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
67:
68: FUNCTION compare_columns(
69: p_approval_details_rec IN Approval_Details_Rec_Type
70: ) RETURN VARCHAR2; -- FND_API.g_true/g_false

Line 216: FND_MSG_PUB.initialize;

212:
213: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
214: END IF;
215: IF FND_API.to_boolean (p_init_msg_list) THEN
216: FND_MSG_PUB.initialize;
217: END IF;
218: IF NOT FND_API.compatible_api_call (
219: L_API_VERSION,
220: p_api_version,

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

231: Check_Unique_Rule(p_approval_details_rec => l_Approval_Details_rec,
232: x_exist_rule_name => l_exist_rule_name,
233: x_return_status => l_return_status);
234: IF l_return_status = FND_API.g_true THEN
235: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
236: FND_MESSAGE.set_name ('AMS', 'AMS_APPR_RULE_EXISTS');
237: FND_MESSAGE.set_token('EXIST_RULE_NAME', l_exist_rule_name);
238: FND_MSG_PUB.add;
239: END IF;

Line 238: FND_MSG_PUB.add;

234: IF l_return_status = FND_API.g_true THEN
235: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
236: FND_MESSAGE.set_name ('AMS', 'AMS_APPR_RULE_EXISTS');
237: FND_MESSAGE.set_token('EXIST_RULE_NAME', l_exist_rule_name);
238: FND_MSG_PUB.add;
239: END IF;
240: RAISE FND_API.g_exc_error;
241: END IF;
242:

Line 333: FND_MSG_PUB.count_and_get(

329: -- Standard check of p_commit.
330: IF FND_API.To_Boolean ( p_commit ) THEN
331: COMMIT WORK;
332: END IF;
333: FND_MSG_PUB.count_and_get(
334: p_encoded => FND_API.g_false,
335: p_count => x_msg_count,
336: p_data => x_msg_data
337: );

Line 347: FND_MSG_PUB.count_and_get(

343: EXCEPTION
344: WHEN FND_API.g_exc_error THEN
345: ROLLBACK TO Create_Approval_Details;
346: x_return_status := FND_API.g_ret_sts_error;
347: FND_MSG_PUB.count_and_get(
348: p_encoded => FND_API.g_false,
349: p_count => x_msg_count,
350: p_data => x_msg_data
351: );

Line 355: FND_MSG_PUB.count_and_get (

351: );
352: WHEN FND_API.g_exc_unexpected_error THEN
353: ROLLBACK TO Create_Approval_Details;
354: x_return_status := FND_API.g_ret_sts_unexp_error ;
355: FND_MSG_PUB.count_and_get (
356: p_encoded => FND_API.g_false,
357: p_count => x_msg_count,
358: p_data => x_msg_data
359: );

Line 363: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)

359: );
360: WHEN OTHERS THEN
361: ROLLBACK TO Create_Approval_Details;
362: x_return_status := FND_API.g_ret_sts_unexp_error ;
363: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
364: THEN
365: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
366: END IF;
367: FND_MSG_PUB.count_and_get (

Line 365: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

361: ROLLBACK TO Create_Approval_Details;
362: x_return_status := FND_API.g_ret_sts_unexp_error ;
363: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
364: THEN
365: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
366: END IF;
367: FND_MSG_PUB.count_and_get (
368: p_encoded => FND_API.g_false,
369: p_count => x_msg_count,

Line 367: FND_MSG_PUB.count_and_get (

363: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
364: THEN
365: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
366: END IF;
367: FND_MSG_PUB.count_and_get (
368: p_encoded => FND_API.g_false,
369: p_count => x_msg_count,
370: p_data => x_msg_data
371: );

Line 424: FND_MSG_PUB.initialize;

420:
421: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
422: END IF;
423: IF FND_API.to_boolean (p_init_msg_list) THEN
424: FND_MSG_PUB.initialize;
425: END IF;
426: IF NOT FND_API.compatible_api_call(
427: l_api_version,
428: p_api_version,

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

438: Check_Unique_Rule(p_approval_details_rec => l_Approval_Details_rec,
439: x_exist_rule_name => l_exist_rule_name,
440: x_return_status => l_return_status);
441: IF l_return_status = FND_API.g_true THEN
442: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
443: FND_MESSAGE.set_name ('AMS', 'AMS_APPR_RULE_EXISTS');
444: FND_MESSAGE.set_token('EXIST_RULE_NAME',l_exist_rule_name);
445: FND_MSG_PUB.add;
446: END IF;

Line 445: FND_MSG_PUB.add;

441: IF l_return_status = FND_API.g_true THEN
442: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
443: FND_MESSAGE.set_name ('AMS', 'AMS_APPR_RULE_EXISTS');
444: FND_MESSAGE.set_token('EXIST_RULE_NAME',l_exist_rule_name);
445: FND_MSG_PUB.add;
446: END IF;
447: RAISE FND_API.g_exc_error;
448: END IF;
449:

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

455: -- replace g_miss_char/num/date with current column values
456: Complete_approval_details_Rec(p_approval_details_rec,l_approval_details_Rec);
457: IF l_approval_details_Rec.seeded_flag = 'Y' THEN
458: IF compare_columns(l_approval_details_Rec) = FND_API.g_false THEN
459: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
460: FND_MESSAGE.set_name ('AMS', 'AMS_STATUS_SEED_DATA');
461: FND_MSG_PUB.add;
462: END IF;
463: RAISE FND_API.g_exc_error;

Line 461: FND_MSG_PUB.add;

457: IF l_approval_details_Rec.seeded_flag = 'Y' THEN
458: IF compare_columns(l_approval_details_Rec) = FND_API.g_false THEN
459: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
460: FND_MESSAGE.set_name ('AMS', 'AMS_STATUS_SEED_DATA');
461: FND_MSG_PUB.add;
462: END IF;
463: RAISE FND_API.g_exc_error;
464: END IF;
465: ELSE

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

501: OPEN c_rec_exists (l_Approval_Details_rec.approval_detail_id, p_Approval_Details_rec.OBJECT_VERSION_NUMBER);
502: FETCH c_rec_exists INTO l_dummy;
503: If c_rec_exists%NOTFOUND THEN
504: CLOSE c_rec_exists;
505: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
506: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
507: FND_MSG_PUB.add;
508: END IF;
509: RAISE FND_API.g_exc_error;

Line 507: FND_MSG_PUB.add;

503: If c_rec_exists%NOTFOUND THEN
504: CLOSE c_rec_exists;
505: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
506: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
507: FND_MSG_PUB.add;
508: END IF;
509: RAISE FND_API.g_exc_error;
510: else
511: CLOSE c_rec_exists;

Line 545: FND_MSG_PUB.count_and_get (

541: -------------------- finish --------------------------
542: IF FND_API.to_boolean (p_commit) THEN
543: COMMIT;
544: END IF;
545: FND_MSG_PUB.count_and_get (
546: p_encoded => FND_API.g_false,
547: p_count => x_msg_count,
548: p_data => x_msg_data
549: );

Line 559: FND_MSG_PUB.count_and_get (

555: EXCEPTION
556: WHEN FND_API.g_exc_error THEN
557: ROLLBACK TO Update_approval_details;
558: x_return_status := FND_API.g_ret_sts_error;
559: FND_MSG_PUB.count_and_get (
560: p_encoded => FND_API.g_false,
561: p_count => x_msg_count,
562: p_data => x_msg_data
563: );

Line 568: FND_MSG_PUB.count_and_get (

564:
565: WHEN FND_API.g_exc_unexpected_error THEN
566: ROLLBACK TO Update_approval_details;
567: x_return_status := FND_API.g_ret_sts_unexp_error ;
568: FND_MSG_PUB.count_and_get (
569: p_encoded => FND_API.g_false,
570: p_count => x_msg_count,
571: p_data => x_msg_data
572: );

Line 577: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)

573:
574: WHEN OTHERS THEN
575: ROLLBACK TO Update_approval_details;
576: x_return_status := FND_API.g_ret_sts_unexp_error ;
577: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
578: THEN
579: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
580: END IF;
581: FND_MSG_PUB.count_and_get (

Line 579: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

575: ROLLBACK TO Update_approval_details;
576: x_return_status := FND_API.g_ret_sts_unexp_error ;
577: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
578: THEN
579: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
580: END IF;
581: FND_MSG_PUB.count_and_get (
582: p_encoded => FND_API.g_false,
583: p_count => x_msg_count,

Line 581: FND_MSG_PUB.count_and_get (

577: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
578: THEN
579: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
580: END IF;
581: FND_MSG_PUB.count_and_get (
582: p_encoded => FND_API.g_false,
583: p_count => x_msg_count,
584: p_data => x_msg_data
585: );

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

635: OPEN c_approval_details;
636: FETCH c_approval_details INTO l_approval_details_rec;
637: IF c_approval_details%NOTFOUND THEN
638: CLOSE c_approval_details;
639: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
640: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
641: FND_MSG_PUB.add;
642: END IF;
643: RAISE FND_API.g_exc_error;

Line 641: FND_MSG_PUB.add;

637: IF c_approval_details%NOTFOUND THEN
638: CLOSE c_approval_details;
639: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
640: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
641: FND_MSG_PUB.add;
642: END IF;
643: RAISE FND_API.g_exc_error;
644: END IF;
645: CLOSE c_approval_details;

Line 653: FND_MSG_PUB.initialize;

649:
650: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
651: END IF;
652: IF FND_API.to_boolean (p_init_msg_list) THEN
653: FND_MSG_PUB.initialize;
654: END IF;
655: IF NOT FND_API.compatible_api_call (
656: l_api_version,
657: p_api_version,

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

671: IF l_approval_details_rec.seeded_flag='N'
672: THEN
673: AMS_APPROVAL_DETAILS_PKG.DELETE_ROW (p_approval_detail_id);
674: ELSE
675: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
676: FND_MESSAGE.set_name ('AMS', 'AMS_API_SEED_DATA');
677: FND_MSG_PUB.add;
678: RAISE FND_API.g_exc_error;
679: END IF;

Line 677: FND_MSG_PUB.add;

673: AMS_APPROVAL_DETAILS_PKG.DELETE_ROW (p_approval_detail_id);
674: ELSE
675: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
676: FND_MESSAGE.set_name ('AMS', 'AMS_API_SEED_DATA');
677: FND_MSG_PUB.add;
678: RAISE FND_API.g_exc_error;
679: END IF;
680: END IF;
681: -------------------- finish --------------------------

Line 685: FND_MSG_PUB.count_and_get (

681: -------------------- finish --------------------------
682: IF FND_API.to_boolean (p_commit) THEN
683: COMMIT;
684: END IF;
685: FND_MSG_PUB.count_and_get (
686: p_encoded => FND_API.g_false,
687: p_count => x_msg_count,
688: p_data => x_msg_data
689: );

Line 699: FND_MSG_PUB.count_and_get (

695: EXCEPTION
696: WHEN FND_API.g_exc_error THEN
697: ROLLBACK TO Delete_approval_details;
698: x_return_status := FND_API.g_ret_sts_error;
699: FND_MSG_PUB.count_and_get (
700: p_encoded => FND_API.g_false,
701: p_count => x_msg_count,
702: p_data => x_msg_data
703: );

Line 708: FND_MSG_PUB.count_and_get (

704:
705: WHEN FND_API.g_exc_unexpected_error THEN
706: ROLLBACK TO Delete_approval_details;
707: x_return_status := FND_API.g_ret_sts_unexp_error ;
708: FND_MSG_PUB.count_and_get (
709: p_encoded => FND_API.g_false,
710: p_count => x_msg_count,
711: p_data => x_msg_data
712: );

Line 717: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)

713:
714: WHEN OTHERS THEN
715: ROLLBACK TO Delete_approval_details;
716: x_return_status := FND_API.g_ret_sts_unexp_error ;
717: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
718: THEN
719: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
720: END IF;
721: FND_MSG_PUB.count_and_get (

Line 719: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

715: ROLLBACK TO Delete_approval_details;
716: x_return_status := FND_API.g_ret_sts_unexp_error ;
717: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
718: THEN
719: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
720: END IF;
721: FND_MSG_PUB.count_and_get (
722: p_encoded => FND_API.g_false,
723: p_count => x_msg_count,

Line 721: FND_MSG_PUB.count_and_get (

717: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
718: THEN
719: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
720: END IF;
721: FND_MSG_PUB.count_and_get (
722: p_encoded => FND_API.g_false,
723: p_count => x_msg_count,
724: p_data => x_msg_data
725: );

Line 802: FND_MSG_PUB.initialize;

798:
799: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
800: END IF;
801: IF FND_API.to_boolean (p_init_msg_list) THEN
802: FND_MSG_PUB.initialize;
803: END IF;
804: IF NOT FND_API.compatible_api_call (
805: l_api_version,
806: p_api_version,

Line 850: FND_MSG_PUB.count_and_get (

846: END IF;
847: -----------------check the start date <= end date ------
848:
849: -------------------- finish --------------------------
850: FND_MSG_PUB.count_and_get (
851: p_encoded => FND_API.g_false,
852: p_count => x_msg_count,
853: p_data => x_msg_data
854: );

Line 862: FND_MSG_PUB.count_and_get (

858: END IF;
859: EXCEPTION
860: WHEN FND_API.g_exc_error THEN
861: x_return_status := FND_API.g_ret_sts_error;
862: FND_MSG_PUB.count_and_get (
863: p_encoded => FND_API.g_false,
864: p_count => x_msg_count,
865: p_data => x_msg_data
866: );

Line 869: FND_MSG_PUB.count_and_get (

865: p_data => x_msg_data
866: );
867: WHEN FND_API.g_exc_unexpected_error THEN
868: x_return_status := FND_API.g_ret_sts_unexp_error ;
869: FND_MSG_PUB.count_and_get (
870: p_encoded => FND_API.g_false,
871: p_count => x_msg_count,
872: p_data => x_msg_data
873: );

Line 876: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)

872: p_data => x_msg_data
873: );
874: WHEN OTHERS THEN
875: x_return_status := FND_API.g_ret_sts_unexp_error;
876: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
877: THEN
878: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
879: END IF;
880: FND_MSG_PUB.count_and_get (

Line 878: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

874: WHEN OTHERS THEN
875: x_return_status := FND_API.g_ret_sts_unexp_error;
876: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
877: THEN
878: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
879: END IF;
880: FND_MSG_PUB.count_and_get (
881: p_encoded => FND_API.g_false,
882: p_count => x_msg_count,

Line 880: FND_MSG_PUB.count_and_get (

876: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
877: THEN
878: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
879: END IF;
880: FND_MSG_PUB.count_and_get (
881: p_encoded => FND_API.g_false,
882: p_count => x_msg_count,
883: p_data => x_msg_data
884: );

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

912: --IF p_validation_mode = JTF_PLSQL_API.g_create THEN --VMODUR 24-Jul-2002
913: --- some logic
914: If (p_approval_details_rec.start_date_active > p_approval_details_rec.end_date_active) THEN
915: --dbms_output.put_line('st > ed ');
916: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
917: FND_MESSAGE.set_name('AMS', 'AMS_APPR_DTL_SD_BFR_ED');
918: FND_MSG_PUB.add;
919: x_return_status := FND_API.g_ret_sts_error;
920: RETURN;

Line 918: FND_MSG_PUB.add;

914: If (p_approval_details_rec.start_date_active > p_approval_details_rec.end_date_active) THEN
915: --dbms_output.put_line('st > ed ');
916: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
917: FND_MESSAGE.set_name('AMS', 'AMS_APPR_DTL_SD_BFR_ED');
918: FND_MSG_PUB.add;
919: x_return_status := FND_API.g_ret_sts_error;
920: RETURN;
921: END IF;
922: END IF;

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

928: or p_approval_details_rec.approval_limit_from = FND_API.g_miss_num)
929: AND(p_approval_details_rec.approval_limit_to is NULL
930: OR p_approval_details_rec.approval_limit_to = FND_API.g_miss_num))THEN
931: -- dbms_output.put_line('AMS_APPR_BGT_NO_MIN_AMT');
932: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
933: FND_MESSAGE.set_name('AMS', 'AMS_APPR_BGT_NO_MIN_AMT');
934: FND_MSG_PUB.add;
935: x_return_status := FND_API.g_ret_sts_error;
936: RETURN;

Line 934: FND_MSG_PUB.add;

930: OR p_approval_details_rec.approval_limit_to = FND_API.g_miss_num))THEN
931: -- dbms_output.put_line('AMS_APPR_BGT_NO_MIN_AMT');
932: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
933: FND_MESSAGE.set_name('AMS', 'AMS_APPR_BGT_NO_MIN_AMT');
934: FND_MSG_PUB.add;
935: x_return_status := FND_API.g_ret_sts_error;
936: RETURN;
937: END IF;
938: END IF;

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

952: AND p_approval_details_rec.approval_limit_to <> FND_API.g_miss_num
953: AND p_approval_details_rec.approval_limit_to < 0
954: AND p_approval_details_rec.approval_object <> 'CLAM')
955: THEN
956: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
957: -- FND_MESSAGE.set_name('AMS', 'AMS_APPR_DTL_NO_CURR');
958: FND_MESSAGE.set_name('AMS', 'AMS_APPR_DTL_MAX_AMT_LS_ZERO');
959: FND_MSG_PUB.add;
960: x_return_status := FND_API.g_ret_sts_error;

Line 959: FND_MSG_PUB.add;

955: THEN
956: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
957: -- FND_MESSAGE.set_name('AMS', 'AMS_APPR_DTL_NO_CURR');
958: FND_MESSAGE.set_name('AMS', 'AMS_APPR_DTL_MAX_AMT_LS_ZERO');
959: FND_MSG_PUB.add;
960: x_return_status := FND_API.g_ret_sts_error;
961: RETURN;
962: END IF;
963: END IF;

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

974: AND p_approval_details_rec.approval_limit_from <> FND_API.g_miss_num
975: AND p_approval_details_rec.approval_limit_from < 0
976: AND p_approval_details_rec.approval_object <> 'CLAM')
977: THEN
978: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
979: FND_MESSAGE.set_name('AMS', 'AMS_APPR_DTL_MIN_AMT_LS_ZERO');
980: --dbms_output.put_line('AMS_APPR_DTL_MIN_AMT_LS_ZERO');
981: FND_MSG_PUB.add;
982: x_return_status := FND_API.g_ret_sts_error;

Line 981: FND_MSG_PUB.add;

977: THEN
978: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
979: FND_MESSAGE.set_name('AMS', 'AMS_APPR_DTL_MIN_AMT_LS_ZERO');
980: --dbms_output.put_line('AMS_APPR_DTL_MIN_AMT_LS_ZERO');
981: FND_MSG_PUB.add;
982: x_return_status := FND_API.g_ret_sts_error;
983: RETURN;
984: END IF;
985: END IF;

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

992:
993: END IF;
994: If (p_approval_details_rec.approval_limit_from >= p_approval_details_rec.approval_limit_to) THEN
995: --dbms_output.put_line('AMS_APPR_MIN_MAX_AMT_ERR');
996: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
997: FND_MESSAGE.set_name('AMS', 'AMS_APPR_MIN_MAX_AMT_ERR');
998: FND_MSG_PUB.add;
999: x_return_status := FND_API.g_ret_sts_error;
1000: RETURN;

Line 998: FND_MSG_PUB.add;

994: If (p_approval_details_rec.approval_limit_from >= p_approval_details_rec.approval_limit_to) THEN
995: --dbms_output.put_line('AMS_APPR_MIN_MAX_AMT_ERR');
996: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
997: FND_MESSAGE.set_name('AMS', 'AMS_APPR_MIN_MAX_AMT_ERR');
998: FND_MSG_PUB.add;
999: x_return_status := FND_API.g_ret_sts_error;
1000: RETURN;
1001: END IF;
1002: END IF;

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

1014: AND p_approval_details_rec.approval_limit_from <> FND_API.g_miss_num))
1015: AND (p_approval_details_rec.currency_code is NULL
1016: OR p_approval_details_rec.currency_code = FND_API.g_miss_char)) THEN
1017: --dbms_output.put_line('AMS_APPR_DTL_NO_CURR');
1018: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1019: FND_MESSAGE.set_name('AMS', 'AMS_APPR_DTL_NO_CURR');
1020: FND_MSG_PUB.add;
1021: x_return_status := FND_API.g_ret_sts_error;
1022: RETURN;

Line 1020: FND_MSG_PUB.add;

1016: OR p_approval_details_rec.currency_code = FND_API.g_miss_char)) THEN
1017: --dbms_output.put_line('AMS_APPR_DTL_NO_CURR');
1018: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1019: FND_MESSAGE.set_name('AMS', 'AMS_APPR_DTL_NO_CURR');
1020: FND_MSG_PUB.add;
1021: x_return_status := FND_API.g_ret_sts_error;
1022: RETURN;
1023: END IF;
1024: END IF;

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

1095: AMS_Utility_PVT.debug_message ('Inside Check_approval_details_Items9');
1096: END IF;
1097: If (p_approval_details_rec.start_date_active > p_approval_details_rec.end_date_active) THEN
1098: --dbms_output.put_line('st > ed ');
1099: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1100: FND_MESSAGE.set_name('AMS', 'AMS_APPR_DTL_SD_BFR_ED');
1101: FND_MSG_PUB.add;
1102: x_return_status := FND_API.g_ret_sts_error;
1103: RETURN;

Line 1101: FND_MSG_PUB.add;

1097: If (p_approval_details_rec.start_date_active > p_approval_details_rec.end_date_active) THEN
1098: --dbms_output.put_line('st > ed ');
1099: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1100: FND_MESSAGE.set_name('AMS', 'AMS_APPR_DTL_SD_BFR_ED');
1101: FND_MSG_PUB.add;
1102: x_return_status := FND_API.g_ret_sts_error;
1103: RETURN;
1104: END IF;
1105: END IF;

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

1112: or p_approval_details_rec.approval_limit_from = FND_API.g_miss_num)
1113: AND(p_approval_details_rec.approval_limit_to is NULL
1114: OR p_approval_details_rec.approval_limit_to = FND_API.g_miss_num))THEN
1115: -- dbms_output.put_line('AMS_APPR_BGT_NO_MIN_AMT');
1116: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1117: FND_MESSAGE.set_name('AMS', 'AMS_APPR_BGT_NO_MIN_AMT');
1118: FND_MSG_PUB.add;
1119: x_return_status := FND_API.g_ret_sts_error;
1120: RETURN;

Line 1118: FND_MSG_PUB.add;

1114: OR p_approval_details_rec.approval_limit_to = FND_API.g_miss_num))THEN
1115: -- dbms_output.put_line('AMS_APPR_BGT_NO_MIN_AMT');
1116: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1117: FND_MESSAGE.set_name('AMS', 'AMS_APPR_BGT_NO_MIN_AMT');
1118: FND_MSG_PUB.add;
1119: x_return_status := FND_API.g_ret_sts_error;
1120: RETURN;
1121: END IF;
1122: END IF;

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

1126: AMS_Utility_PVT.debug_message ('Inside Check_approval_details_Items11');
1127: END IF;
1128: If (p_approval_details_rec.approval_limit_from >= p_approval_details_rec.approval_limit_to) THEN
1129: --dbms_output.put_line('AMS_APPR_MIN_MAX_AMT_ERR');
1130: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1131: FND_MESSAGE.set_name('AMS', 'AMS_APPR_MIN_MAX_AMT_ERR');
1132: FND_MSG_PUB.add;
1133: x_return_status := FND_API.g_ret_sts_error;
1134: RETURN;

Line 1132: FND_MSG_PUB.add;

1128: If (p_approval_details_rec.approval_limit_from >= p_approval_details_rec.approval_limit_to) THEN
1129: --dbms_output.put_line('AMS_APPR_MIN_MAX_AMT_ERR');
1130: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1131: FND_MESSAGE.set_name('AMS', 'AMS_APPR_MIN_MAX_AMT_ERR');
1132: FND_MSG_PUB.add;
1133: x_return_status := FND_API.g_ret_sts_error;
1134: RETURN;
1135: END IF;
1136: END IF;

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

1144: AND p_approval_details_rec.approval_limit_from <> FND_API.g_miss_num))
1145: AND (p_approval_details_rec.currency_code is NULL
1146: OR p_approval_details_rec.currency_code = FND_API.g_miss_char)) THEN
1147: --dbms_output.put_line('AMS_APPR_DTL_NO_CURR');
1148: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1149: FND_MESSAGE.set_name('AMS', 'AMS_APPR_DTL_NO_CURR');
1150: FND_MSG_PUB.add;
1151: x_return_status := FND_API.g_ret_sts_error;
1152: RETURN;

Line 1150: FND_MSG_PUB.add;

1146: OR p_approval_details_rec.currency_code = FND_API.g_miss_char)) THEN
1147: --dbms_output.put_line('AMS_APPR_DTL_NO_CURR');
1148: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1149: FND_MESSAGE.set_name('AMS', 'AMS_APPR_DTL_NO_CURR');
1150: FND_MSG_PUB.add;
1151: x_return_status := FND_API.g_ret_sts_error;
1152: RETURN;
1153: END IF;
1154: END IF;

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

1196: end if;
1197: x_return_status := FND_API.G_RET_STS_SUCCESS;
1198: IF l_start_date_active IS NOT NULL AND l_end_date_active IS NOT NULL THEN
1199: IF l_start_date_active > l_end_date_active THEN
1200: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1201: FND_MESSAGE.set_name ('AMS', 'AMS_STATUS_FROMDT_GTR_TODT');
1202: FND_MSG_PUB.add;
1203: END IF;
1204: x_return_status := FND_API.g_ret_sts_error;

Line 1202: FND_MSG_PUB.add;

1198: IF l_start_date_active IS NOT NULL AND l_end_date_active IS NOT NULL THEN
1199: IF l_start_date_active > l_end_date_active THEN
1200: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1201: FND_MESSAGE.set_name ('AMS', 'AMS_STATUS_FROMDT_GTR_TODT');
1202: FND_MSG_PUB.add;
1203: END IF;
1204: x_return_status := FND_API.g_ret_sts_error;
1205: RETURN;
1206: END IF;

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

1276: OPEN c_approval_details;
1277: FETCH c_approval_details INTO l_approval_details_rec;
1278: IF c_approval_details%NOTFOUND THEN
1279: CLOSE c_approval_details;
1280: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1281: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1282: FND_MSG_PUB.add;
1283: END IF;
1284: RAISE FND_API.g_exc_error;

Line 1282: FND_MSG_PUB.add;

1278: IF c_approval_details%NOTFOUND THEN
1279: CLOSE c_approval_details;
1280: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1281: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1282: FND_MSG_PUB.add;
1283: END IF;
1284: RAISE FND_API.g_exc_error;
1285: END IF;
1286: CLOSE c_approval_details;

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

1529: ) IS
1530: BEGIN
1531:
1532: IF p_approval_details_rec.name IS NULL THEN
1533: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1534: FND_MESSAGE.set_name ('AMS', 'AMS_STATUS_NO_NAME');
1535: FND_MSG_PUB.add;
1536: END IF;
1537: x_return_status := FND_API.g_ret_sts_error;

Line 1535: FND_MSG_PUB.add;

1531:
1532: IF p_approval_details_rec.name IS NULL THEN
1533: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1534: FND_MESSAGE.set_name ('AMS', 'AMS_STATUS_NO_NAME');
1535: FND_MSG_PUB.add;
1536: END IF;
1537: x_return_status := FND_API.g_ret_sts_error;
1538: RETURN;
1539: END IF;

Line 1601: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1597: ''' AND approval_detail_id <> ' || p_approval_details_rec.approval_detail_id);
1598: END IF;
1599:
1600: IF l_valid_flag = FND_API.g_false THEN
1601: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1602: THEN
1603: FND_MESSAGE.set_name('AMS', 'AMS_APPR_DUPLICATE_ID');
1604: FND_MSG_PUB.add;
1605: END IF;

Line 1604: FND_MSG_PUB.add;

1600: IF l_valid_flag = FND_API.g_false THEN
1601: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1602: THEN
1603: FND_MESSAGE.set_name('AMS', 'AMS_APPR_DUPLICATE_ID');
1604: FND_MSG_PUB.add;
1605: END IF;
1606: x_return_status := FND_API.g_ret_sts_error;
1607: RETURN;
1608: END IF;

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

1626:
1627:
1628: IF l_valid_flag = '1' THEN
1629:
1630: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1631: IF (AMS_DEBUG_HIGH_ON) THEN
1632:
1633: AMS_UTILITY_PVT.debug_message('Check_Approval_Dtls_UK_Items: Inside error');
1634: END IF;

Line 1636: FND_MSG_PUB.add;

1632:
1633: AMS_UTILITY_PVT.debug_message('Check_Approval_Dtls_UK_Items: Inside error');
1634: END IF;
1635: FND_MESSAGE.set_name('AMS', 'AMS_DUP_NAME');
1636: FND_MSG_PUB.add;
1637: END IF;
1638: x_return_status := FND_API.g_ret_sts_error;
1639: RETURN;
1640: END IF;

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

1647: fetch c_appr_name2 into l_dummy;
1648: close c_appr_name2;
1649:
1650: IF l_dummy = 1 THEN
1651: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1652: FND_MESSAGE.set_name ('AMS', 'AMS_DUP_NAME');
1653: FND_MSG_PUB.add;
1654: END IF;
1655: x_return_status := FND_API.g_ret_sts_error;

Line 1653: FND_MSG_PUB.add;

1649:
1650: IF l_dummy = 1 THEN
1651: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1652: FND_MESSAGE.set_name ('AMS', 'AMS_DUP_NAME');
1653: FND_MSG_PUB.add;
1654: END IF;
1655: x_return_status := FND_API.g_ret_sts_error;
1656: RETURN;
1657: END IF;

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

1677: END IF;
1678:
1679:
1680: IF l_valid_flag = FND_API.g_false THEN
1681: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1682: FND_MESSAGE.set_name ('AMS', 'AMS_DUP_NAME');
1683: FND_MSG_PUB.add;
1684: END IF;
1685: x_return_status := FND_API.g_ret_sts_error;

Line 1683: FND_MSG_PUB.add;

1679:
1680: IF l_valid_flag = FND_API.g_false THEN
1681: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1682: FND_MESSAGE.set_name ('AMS', 'AMS_DUP_NAME');
1683: FND_MSG_PUB.add;
1684: END IF;
1685: x_return_status := FND_API.g_ret_sts_error;
1686: RETURN;
1687: END IF;

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

1750: x_return_status,
1751: l_meaning
1752: );
1753: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1754: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1755: FND_MESSAGE.set_name('AMS', 'AMS_BAD_APPROVAL_OBJECT_TYPE');
1756: FND_MSG_PUB.add;
1757: RETURN;
1758: END IF;

Line 1756: FND_MSG_PUB.add;

1752: );
1753: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1754: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1755: FND_MESSAGE.set_name('AMS', 'AMS_BAD_APPROVAL_OBJECT_TYPE');
1756: FND_MSG_PUB.add;
1757: RETURN;
1758: END IF;
1759: END IF;
1760: END IF;

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

1768: x_return_status,
1769: l_meaning
1770: );
1771: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1772: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1773: FND_MESSAGE.set_name('AMS', 'AMS_INVALID_APPROVAL_TYPE');
1774: FND_MSG_PUB.add;
1775: RETURN;
1776: END IF;

Line 1774: FND_MSG_PUB.add;

1770: );
1771: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1772: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1773: FND_MESSAGE.set_name('AMS', 'AMS_INVALID_APPROVAL_TYPE');
1774: FND_MSG_PUB.add;
1775: RETURN;
1776: END IF;
1777: END IF;
1778: END IF;

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

1794: open c_appr_objt_type_exists(to_number(p_approval_details_rec.approval_object_type));
1795: fetch c_appr_objt_type_exists INTO l_dummy;
1796: close c_appr_objt_type_exists;
1797: IF l_dummy <> 1 THEN
1798: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1799: FND_MESSAGE.set_name('AMS', 'AMS_BAD_APPROVAL_OBJECT_TYPE');
1800: FND_MSG_PUB.add;
1801: x_return_status := FND_API.g_ret_sts_error;
1802: RETURN;

Line 1800: FND_MSG_PUB.add;

1796: close c_appr_objt_type_exists;
1797: IF l_dummy <> 1 THEN
1798: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1799: FND_MESSAGE.set_name('AMS', 'AMS_BAD_APPROVAL_OBJECT_TYPE');
1800: FND_MSG_PUB.add;
1801: x_return_status := FND_API.g_ret_sts_error;
1802: RETURN;
1803: END IF;
1804: END IF;

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

1820: x_return_status,
1821: l_meaning
1822: );
1823: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1824: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1825: FND_MESSAGE.set_name('AMS', 'AMS_BAD_APPROVAL_OBJECT_TYPE');
1826: FND_MSG_PUB.add;
1827: RETURN;
1828: END IF;

Line 1826: FND_MSG_PUB.add;

1822: );
1823: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1824: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1825: FND_MESSAGE.set_name('AMS', 'AMS_BAD_APPROVAL_OBJECT_TYPE');
1826: FND_MSG_PUB.add;
1827: RETURN;
1828: END IF;
1829: END IF;
1830: END IF;

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

1843: x_return_status,
1844: l_meaning
1845: );
1846: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1847: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1848: FND_MESSAGE.set_name('AMS', 'AMS_APPR_NO_PRIORITY_LKUP');
1849: FND_MSG_PUB.add;
1850: RETURN;
1851: END IF;

Line 1849: FND_MSG_PUB.add;

1845: );
1846: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1847: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1848: FND_MESSAGE.set_name('AMS', 'AMS_APPR_NO_PRIORITY_LKUP');
1849: FND_MSG_PUB.add;
1850: RETURN;
1851: END IF;
1852: END IF;
1853: END IF;

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

1863: open c_cust_setup_id_c_exists(p_approval_details_rec.custom_setup_id);
1864: fetch c_cust_setup_id_c_exists INTO l_dummy;
1865: close c_cust_setup_id_c_exists;
1866: IF l_dummy <> 1 THEN
1867: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1868: FND_MESSAGE.set_name('AMS', 'AMS_BAD_CUSTOM_SETUP_ID');
1869: FND_MSG_PUB.add;
1870: x_return_status := FND_API.g_ret_sts_error;
1871: RETURN;

Line 1869: FND_MSG_PUB.add;

1865: close c_cust_setup_id_c_exists;
1866: IF l_dummy <> 1 THEN
1867: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1868: FND_MESSAGE.set_name('AMS', 'AMS_BAD_CUSTOM_SETUP_ID');
1869: FND_MSG_PUB.add;
1870: x_return_status := FND_API.g_ret_sts_error;
1871: RETURN;
1872: END IF;
1873: END IF;

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

1877: open c_cust_setup_id_exists(p_approval_details_rec.custom_setup_id, p_approval_details_rec.approval_object);
1878: fetch c_cust_setup_id_exists INTO l_dummy;
1879: close c_cust_setup_id_exists;
1880: IF l_dummy <> 1 THEN
1881: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1882: FND_MESSAGE.set_name('AMS', 'AMS_BAD_CUSTOM_SETUP_ID');
1883: FND_MSG_PUB.add;
1884: x_return_status := FND_API.g_ret_sts_error;
1885: RETURN;

Line 1883: FND_MSG_PUB.add;

1879: close c_cust_setup_id_exists;
1880: IF l_dummy <> 1 THEN
1881: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1882: FND_MESSAGE.set_name('AMS', 'AMS_BAD_CUSTOM_SETUP_ID');
1883: FND_MSG_PUB.add;
1884: x_return_status := FND_API.g_ret_sts_error;
1885: RETURN;
1886: END IF;
1887: END IF;

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

1897: p_approval_details_rec.business_group_id, 'BU') ;
1898: fetch c_get_org into l_count;
1899: close c_get_org;
1900: IF l_count = 0 then
1901: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1902: FND_MESSAGE.set_name('AMS', 'AMS_BAD_BU_ID');
1903: FND_MSG_PUB.add;
1904: x_return_status := FND_API.g_ret_sts_error;
1905: RETURN;

Line 1903: FND_MSG_PUB.add;

1899: close c_get_org;
1900: IF l_count = 0 then
1901: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1902: FND_MESSAGE.set_name('AMS', 'AMS_BAD_BU_ID');
1903: FND_MSG_PUB.add;
1904: x_return_status := FND_API.g_ret_sts_error;
1905: RETURN;
1906: END IF;
1907: END IF;

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

1915: p_approval_details_rec.business_group_id, '') ;
1916: fetch c_get_org into l_count;
1917: close c_get_org;
1918: IF l_count = 0 then
1919: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1920: FND_MESSAGE.set_name('AMS', 'AMS_BAD_ORG_ID');
1921: FND_MSG_PUB.add;
1922: x_return_status := FND_API.g_ret_sts_error;
1923: RETURN;

Line 1921: FND_MSG_PUB.add;

1917: close c_get_org;
1918: IF l_count = 0 then
1919: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1920: FND_MESSAGE.set_name('AMS', 'AMS_BAD_ORG_ID');
1921: FND_MSG_PUB.add;
1922: x_return_status := FND_API.g_ret_sts_error;
1923: RETURN;
1924: END IF;
1925: END IF;

Line 2183: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

2179: IF (AMS_DEBUG_HIGH_ON) THEN
2180: Ams_Utility_Pvt.debug_message('You cannot update the Approval Rule start date as it is already active');
2181: END IF;
2182:
2183: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2184: Fnd_Message.set_name('AMS', 'AMS_APRD_START_DATE_NO_UPDATE');
2185: Fnd_Msg_Pub.ADD;
2186: RETURN FND_API.g_true;
2187: END IF;

Line 2185: Fnd_Msg_Pub.ADD;

2181: END IF;
2182:
2183: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2184: Fnd_Message.set_name('AMS', 'AMS_APRD_START_DATE_NO_UPDATE');
2185: Fnd_Msg_Pub.ADD;
2186: RETURN FND_API.g_true;
2187: END IF;
2188:
2189: END IF;

Line 2199: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

2195:
2196: Ams_Utility_Pvt.debug_message('Approval Rule Start Date cannot be less than the system date');
2197: END IF;
2198:
2199: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2200: Fnd_Message.set_name('AMS', 'AMS_APRD_START_DATE_LT_SYSDATE');
2201: Fnd_Msg_Pub.ADD;
2202: RETURN FND_API.g_true;
2203: END IF;

Line 2201: Fnd_Msg_Pub.ADD;

2197: END IF;
2198:
2199: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2200: Fnd_Message.set_name('AMS', 'AMS_APRD_START_DATE_LT_SYSDATE');
2201: Fnd_Msg_Pub.ADD;
2202: RETURN FND_API.g_true;
2203: END IF;
2204: END IF;
2205:

Line 2221: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

2217:
2218: Ams_Utility_Pvt.debug_message('Approval Rule Start Date cannot be less than the system date');
2219: END IF;
2220:
2221: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2222: Fnd_Message.set_name('AMS', 'AMS_APRD_START_DATE_LT_SYSDATE');
2223: Fnd_Msg_Pub.ADD;
2224: RETURN FND_API.g_true;
2225: END IF;

Line 2223: Fnd_Msg_Pub.ADD;

2219: END IF;
2220:
2221: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2222: Fnd_Message.set_name('AMS', 'AMS_APRD_START_DATE_LT_SYSDATE');
2223: Fnd_Msg_Pub.ADD;
2224: RETURN FND_API.g_true;
2225: END IF;
2226: END IF;
2227:

Line 2237: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

2233:
2234: Ams_Utility_Pvt.debug_message('Approval Rule Start Date cannot be less than the system date');
2235: END IF;
2236:
2237: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2238: Fnd_Message.set_name('AMS', 'AMS_APRD_START_DATE_LT_SYSDATE');
2239: Fnd_Msg_Pub.ADD;
2240: RETURN FND_API.g_true;
2241: END IF;

Line 2239: Fnd_Msg_Pub.ADD;

2235: END IF;
2236:
2237: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2238: Fnd_Message.set_name('AMS', 'AMS_APRD_START_DATE_LT_SYSDATE');
2239: Fnd_Msg_Pub.ADD;
2240: RETURN FND_API.g_true;
2241: END IF;
2242: END IF;
2243:

Line 2250: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

2246:
2247: Ams_Utility_Pvt.debug_message('Approval Rule End Date cannot be less than the system date');
2248: END IF;
2249:
2250: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2251: Fnd_Message.set_name('AMS', 'AMS_APRD_END_DATE_LT_SYSDATE');
2252: Fnd_Msg_Pub.ADD;
2253: RETURN FND_API.g_true;
2254: END IF;

Line 2252: Fnd_Msg_Pub.ADD;

2248: END IF;
2249:
2250: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2251: Fnd_Message.set_name('AMS', 'AMS_APRD_END_DATE_LT_SYSDATE');
2252: Fnd_Msg_Pub.ADD;
2253: RETURN FND_API.g_true;
2254: END IF;
2255: END IF;
2256:

Line 2264: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

2260:
2261: Ams_Utility_Pvt.debug_message('Approval Rule END Date cannot be less than Start Date');
2262: END IF;
2263:
2264: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2265: Fnd_Message.set_name('AMS', 'AMS_APRD_ED_DATE_LT_ST_DATE');
2266: Fnd_Msg_Pub.ADD;
2267: RETURN FND_API.g_true;
2268: END IF;

Line 2266: Fnd_Msg_Pub.ADD;

2262: END IF;
2263:
2264: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2265: Fnd_Message.set_name('AMS', 'AMS_APRD_ED_DATE_LT_ST_DATE');
2266: Fnd_Msg_Pub.ADD;
2267: RETURN FND_API.g_true;
2268: END IF;
2269: END IF;
2270: END IF;

Line 2411: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

2407:
2408: Get_Approval_Rule_Name(p_approval_detail_id => v_approvalIds(1),
2409: x_rule_name => l_rule_name);
2410:
2411: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2412: Fnd_Message.set_name('AMS', 'AMS_APRD_DATE_OVERLAP');
2413: Fnd_Message.set_token('EXIST_RULE_NAME', l_rule_name);
2414: Fnd_Msg_Pub.ADD;
2415: RETURN FND_API.g_true;

Line 2414: Fnd_Msg_Pub.ADD;

2410:
2411: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2412: Fnd_Message.set_name('AMS', 'AMS_APRD_DATE_OVERLAP');
2413: Fnd_Message.set_token('EXIST_RULE_NAME', l_rule_name);
2414: Fnd_Msg_Pub.ADD;
2415: RETURN FND_API.g_true;
2416: END IF;
2417: END IF;
2418: --ELSIF (p_approval_details_rec.approval_type = 'BUDGET') THEN --- VMODUR 30-Oct-2003

Line 2427: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

2423: p_appoval_ids => v_approvalIds,
2424: x_exist_rule_name => l_rule_name,
2425: x_return_status => l_return_status);
2426: IF l_return_status = FND_API.g_true THEN
2427: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2428: Fnd_Message.set_name('AMS', 'AMS_APRD_MIN_MAX_AMT_OVERLAP');
2429: Fnd_Message.set_token('EXIST_RULE_NAME', l_rule_name);
2430: Fnd_Msg_Pub.ADD;
2431: RETURN FND_API.g_true;

Line 2430: Fnd_Msg_Pub.ADD;

2426: IF l_return_status = FND_API.g_true THEN
2427: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2428: Fnd_Message.set_name('AMS', 'AMS_APRD_MIN_MAX_AMT_OVERLAP');
2429: Fnd_Message.set_token('EXIST_RULE_NAME', l_rule_name);
2430: Fnd_Msg_Pub.ADD;
2431: RETURN FND_API.g_true;
2432: END IF;
2433: END IF;
2434: END IF;