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_RISK_CTRL_COUNT_PVT dependencies on FND_API

Line 40: -- p_commit IN VARCHAR2 Required Default = FND_API_G_FALSE

36: -- p_process_id IN NUMBER Optional Default = null
37: -- p_organization_id IN NUMBER Optional Default = null
38: -- p_mode IN VARCHAR2 Required Default = 'ASSOCIATE'
39: -- p_apo_type IN apo_type Optional Default = null
40: -- p_commit IN VARCHAR2 Required Default = FND_API_G_FALSE
41: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
42: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
43: --
44: -- OUT

Line 41: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

37: -- p_organization_id IN NUMBER Optional Default = null
38: -- p_mode IN VARCHAR2 Required Default = 'ASSOCIATE'
39: -- p_apo_type IN apo_type Optional Default = null
40: -- p_commit IN VARCHAR2 Required Default = FND_API_G_FALSE
41: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
42: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
43: --
44: -- OUT
45: -- x_return_status OUT VARCHAR2

Line 42: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

38: -- p_mode IN VARCHAR2 Required Default = 'ASSOCIATE'
39: -- p_apo_type IN apo_type Optional Default = null
40: -- p_commit IN VARCHAR2 Required Default = FND_API_G_FALSE
41: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
42: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
43: --
44: -- OUT
45: -- x_return_status OUT VARCHAR2
46: -- x_msg_count OUT NUMBER

Line 61: p_commit IN VARCHAR2 := fnd_api.g_false,

57: p_control_id IN NUMBER := NULL,
58: p_process_organization_id IN NUMBER := NULL,
59: p_association_mode IN VARCHAR2 := 'ASSOCIATE',
60: p_object IN VARCHAR2 := 'RISK',
61: p_commit IN VARCHAR2 := fnd_api.g_false,
62: p_validation_level IN NUMBER
63: := fnd_api.g_valid_level_full,
64: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
65: p_api_version_number IN NUMBER,

Line 63: := fnd_api.g_valid_level_full,

59: p_association_mode IN VARCHAR2 := 'ASSOCIATE',
60: p_object IN VARCHAR2 := 'RISK',
61: p_commit IN VARCHAR2 := fnd_api.g_false,
62: p_validation_level IN NUMBER
63: := fnd_api.g_valid_level_full,
64: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
65: p_api_version_number IN NUMBER,
66: x_return_status OUT NOCOPY VARCHAR2,
67: x_msg_count OUT NOCOPY NUMBER,

Line 64: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

60: p_object IN VARCHAR2 := 'RISK',
61: p_commit IN VARCHAR2 := fnd_api.g_false,
62: p_validation_level IN NUMBER
63: := fnd_api.g_valid_level_full,
64: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
65: p_api_version_number IN NUMBER,
66: x_return_status OUT NOCOPY VARCHAR2,
67: x_msg_count OUT NOCOPY NUMBER,
68: x_msg_data OUT NOCOPY VARCHAR2

Line 314: -- x_return_status := fnd_api.g_ret_sts_success;

310: null;
311: -- ---Inserting process_id
312: -- ----commit;
313: -- SAVEPOINT get_process_hierarchy_pvt;
314: -- x_return_status := fnd_api.g_ret_sts_success;
315: -- -- Standard call to check for call compatibility.
316: -- IF NOT fnd_api.compatible_api_call (l_api_version_number,
317: -- p_api_version_number,
318: -- l_api_name,

Line 316: -- IF NOT fnd_api.compatible_api_call (l_api_version_number,

312: -- ----commit;
313: -- SAVEPOINT get_process_hierarchy_pvt;
314: -- x_return_status := fnd_api.g_ret_sts_success;
315: -- -- Standard call to check for call compatibility.
316: -- IF NOT fnd_api.compatible_api_call (l_api_version_number,
317: -- p_api_version_number,
318: -- l_api_name,
319: -- g_pkg_name
320: -- ) THEN

Line 321: -- RAISE fnd_api.g_exc_unexpected_error;

317: -- p_api_version_number,
318: -- l_api_name,
319: -- g_pkg_name
320: -- ) THEN
321: -- RAISE fnd_api.g_exc_unexpected_error;
322: -- END IF;
323: -- -- Initialize message list if p_init_msg_list is set to TRUE.
324: -- IF fnd_api.to_boolean (p_init_msg_list) THEN
325: -- fnd_msg_pub.initialize;

Line 324: -- IF fnd_api.to_boolean (p_init_msg_list) THEN

320: -- ) THEN
321: -- RAISE fnd_api.g_exc_unexpected_error;
322: -- END IF;
323: -- -- Initialize message list if p_init_msg_list is set to TRUE.
324: -- IF fnd_api.to_boolean (p_init_msg_list) THEN
325: -- fnd_msg_pub.initialize;
326: -- END IF;
327: -- -- Debug Message
328: -- amw_utility_pvt.debug_message ('Private API: ' || l_api_name || 'start');

Line 330: -- x_return_status := fnd_api.g_ret_sts_success;

326: -- END IF;
327: -- -- Debug Message
328: -- amw_utility_pvt.debug_message ('Private API: ' || l_api_name || 'start');
329: -- -- Initialize API return status to SUCCESS
330: -- x_return_status := fnd_api.g_ret_sts_success;
331: -- /* Temporarily commenting out the validata session code ..... */
332: -- -- =========================================================================
333: -- -- Validate Environment
334: -- -- =========================================================================

Line 338: -- RAISE fnd_api.g_exc_error;

334: -- -- =========================================================================
335: -- IF fnd_global.user_id IS NULL THEN
336: -- amw_utility_pvt.error_message
337: -- (p_message_name => 'USER_PROFILE_MISSING');
338: -- RAISE fnd_api.g_exc_error;
339: -- END IF;
340: -- IF (p_object = 'RISK') THEN
341: -- IF (p_process_id IS NULL) THEN
342: -- amw_utility_pvt.error_message

Line 344: -- RAISE fnd_api.g_exc_error;

340: -- IF (p_object = 'RISK') THEN
341: -- IF (p_process_id IS NULL) THEN
342: -- amw_utility_pvt.error_message
343: -- (p_message_name => 'AMW_NO_PROCESS_ID');
344: -- RAISE fnd_api.g_exc_error;
345: -- ELSIF (p_risk_id IS NULL) THEN
346: -- amw_utility_pvt.error_message
347: -- (p_message_name => 'AMW_NO_RISK_ID');
348: -- RAISE fnd_api.g_exc_error;

Line 348: -- RAISE fnd_api.g_exc_error;

344: -- RAISE fnd_api.g_exc_error;
345: -- ELSIF (p_risk_id IS NULL) THEN
346: -- amw_utility_pvt.error_message
347: -- (p_message_name => 'AMW_NO_RISK_ID');
348: -- RAISE fnd_api.g_exc_error;
349: -- END IF;
350: -- END IF;
351: -- IF (p_object = 'CONTROL') THEN
352: -- IF (p_risk_id IS NULL) THEN

Line 355: -- RAISE fnd_api.g_exc_error;

351: -- IF (p_object = 'CONTROL') THEN
352: -- IF (p_risk_id IS NULL) THEN
353: -- amw_utility_pvt.error_message
354: -- (p_message_name => 'AMW_NO_RISK_ID');
355: -- RAISE fnd_api.g_exc_error;
356: -- ELSIF (p_control_id IS NULL) THEN
357: -- amw_utility_pvt.error_message
358: -- (p_message_name => 'AMW_NO_CONTROL_ID');
359: -- RAISE fnd_api.g_exc_error;

Line 359: -- RAISE fnd_api.g_exc_error;

355: -- RAISE fnd_api.g_exc_error;
356: -- ELSIF (p_control_id IS NULL) THEN
357: -- amw_utility_pvt.error_message
358: -- (p_message_name => 'AMW_NO_CONTROL_ID');
359: -- RAISE fnd_api.g_exc_error;
360: -- END IF;
361: -- END IF;
362: -- IF (p_object = 'RISK_ORG') THEN
363: -- IF (p_process_organization_id IS NULL) THEN

Line 367: -- RAISE fnd_api.g_exc_error;

363: -- IF (p_process_organization_id IS NULL) THEN
364: -- amw_utility_pvt.error_message
365: -- (p_message_name => 'AMW_NO_ORG_ID'
366: -- );
367: -- RAISE fnd_api.g_exc_error;
368: -- END IF;
369: -- END IF;
370: -- IF (p_object = 'CONTROL_ORG') THEN
371: -- IF (p_process_organization_id IS NULL) THEN

Line 375: -- RAISE fnd_api.g_exc_error;

371: -- IF (p_process_organization_id IS NULL) THEN
372: -- amw_utility_pvt.error_message
373: -- (p_message_name => 'AMW_NO_ORG_ID'
374: -- );
375: -- RAISE fnd_api.g_exc_error;
376: -- ELSIF (p_risk_id IS NULL) THEN
377: -- amw_utility_pvt.error_message
378: -- (p_message_name => 'AMW_NO_RISK_ID');
379: -- RAISE fnd_api.g_exc_error;

Line 379: -- RAISE fnd_api.g_exc_error;

375: -- RAISE fnd_api.g_exc_error;
376: -- ELSIF (p_risk_id IS NULL) THEN
377: -- amw_utility_pvt.error_message
378: -- (p_message_name => 'AMW_NO_RISK_ID');
379: -- RAISE fnd_api.g_exc_error;
380: -- ELSIF (p_control_id IS NULL) THEN
381: -- amw_utility_pvt.error_message
382: -- (p_message_name => 'AMW_NO_CONTROL_ID');
383: -- RAISE fnd_api.g_exc_error;

Line 383: -- RAISE fnd_api.g_exc_error;

379: -- RAISE fnd_api.g_exc_error;
380: -- ELSIF (p_control_id IS NULL) THEN
381: -- amw_utility_pvt.error_message
382: -- (p_message_name => 'AMW_NO_CONTROL_ID');
383: -- RAISE fnd_api.g_exc_error;
384: -- END IF;
385: -- END IF;
386: --
387: --

Line 391: -- IF(p_validation_level >= FND_API.G_VALID_LEVEL_FULL)

387: --
388: --
389: -- --Commenting out the validation level for now ....
390: -- /***
391: -- IF(p_validation_level >= FND_API.G_VALID_LEVEL_FULL)
392: -- THEN
393: -- -- Invoke validation procedures
394: -- validate_apo_type(
395: -- p_api_version_number => 1.0,

Line 396: -- p_init_msg_list => FND_API.G_FALSE,

392: -- THEN
393: -- -- Invoke validation procedures
394: -- validate_apo_type(
395: -- p_api_version_number => 1.0,
396: -- p_init_msg_list => FND_API.G_FALSE,
397: -- p_validation_level => p_validation_level,
398: -- x_return_status => x_return_status,
399: -- x_msg_count => x_msg_count,
400: -- x_msg_data => x_msg_data);

Line 702: -- IF x_return_status <> fnd_api.g_ret_sts_success THEN

698: -- =========================================================================
699: -- End Validate Environment
700: -- =========================================================================
701: -- End commenting the session validation code ....
702: -- IF x_return_status <> fnd_api.g_ret_sts_success THEN
703: -- RAISE fnd_api.g_exc_error;
704: -- END IF;
705: -- -- Standard check for p_commit
706: -- IF fnd_api.to_boolean (p_commit) THEN

Line 703: -- RAISE fnd_api.g_exc_error;

699: -- End Validate Environment
700: -- =========================================================================
701: -- End commenting the session validation code ....
702: -- IF x_return_status <> fnd_api.g_ret_sts_success THEN
703: -- RAISE fnd_api.g_exc_error;
704: -- END IF;
705: -- -- Standard check for p_commit
706: -- IF fnd_api.to_boolean (p_commit) THEN
707: -- COMMIT WORK;

Line 706: -- IF fnd_api.to_boolean (p_commit) THEN

702: -- IF x_return_status <> fnd_api.g_ret_sts_success THEN
703: -- RAISE fnd_api.g_exc_error;
704: -- END IF;
705: -- -- Standard check for p_commit
706: -- IF fnd_api.to_boolean (p_commit) THEN
707: -- COMMIT WORK;
708: -- END IF;
709: -- --Debug Message
710: -- amw_utility_pvt.debug_message ('Private API: ' || l_api_name || 'end');

Line 714: -- WHEN fnd_api.g_exc_error THEN

710: -- amw_utility_pvt.debug_message ('Private API: ' || l_api_name || 'end');
711: -- -- Standard call to get message count and if count is 1, get message info.
712: -- fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
713: -- EXCEPTION
714: -- WHEN fnd_api.g_exc_error THEN
715: -- ROLLBACK TO get_process_hierarchy_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
718: -- fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,

Line 716: -- x_return_status := fnd_api.g_ret_sts_error;

712: -- fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
713: -- EXCEPTION
714: -- WHEN fnd_api.g_exc_error THEN
715: -- ROLLBACK TO get_process_hierarchy_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
718: -- fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
719: -- p_count => x_msg_count,
720: -- p_data => x_msg_data

Line 718: -- fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,

714: -- WHEN fnd_api.g_exc_error THEN
715: -- ROLLBACK TO get_process_hierarchy_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
718: -- fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
719: -- p_count => x_msg_count,
720: -- p_data => x_msg_data
721: -- );
722: -- WHEN fnd_api.g_exc_unexpected_error THEN

Line 722: -- WHEN fnd_api.g_exc_unexpected_error THEN

718: -- fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
719: -- p_count => x_msg_count,
720: -- p_data => x_msg_data
721: -- );
722: -- WHEN fnd_api.g_exc_unexpected_error THEN
723: -- ROLLBACK TO get_process_hierarchy_pvt;
724: -- x_return_status := fnd_api.g_ret_sts_unexp_error;
725: -- -- Standard call to get message count and if count=1, get the message
726: -- fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,

Line 724: -- x_return_status := fnd_api.g_ret_sts_unexp_error;

720: -- p_data => x_msg_data
721: -- );
722: -- WHEN fnd_api.g_exc_unexpected_error THEN
723: -- ROLLBACK TO get_process_hierarchy_pvt;
724: -- x_return_status := fnd_api.g_ret_sts_unexp_error;
725: -- -- Standard call to get message count and if count=1, get the message
726: -- fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
727: -- p_count => x_msg_count,
728: -- p_data => x_msg_data

Line 726: -- fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,

722: -- WHEN fnd_api.g_exc_unexpected_error THEN
723: -- ROLLBACK TO get_process_hierarchy_pvt;
724: -- x_return_status := fnd_api.g_ret_sts_unexp_error;
725: -- -- Standard call to get message count and if count=1, get the message
726: -- fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
727: -- p_count => x_msg_count,
728: -- p_data => x_msg_data
729: -- );
730: -- WHEN OTHERS THEN

Line 732: -- x_return_status := fnd_api.g_ret_sts_unexp_error;

728: -- p_data => x_msg_data
729: -- );
730: -- WHEN OTHERS THEN
731: -- ROLLBACK TO get_process_hierarchy_pvt;
732: -- x_return_status := fnd_api.g_ret_sts_unexp_error;
733: -- IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
734: -- fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
735: -- END IF;
736: -- -- Standard call to get message count and if count=1, get the message

Line 737: -- fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,

733: -- IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
734: -- fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
735: -- END IF;
736: -- -- Standard call to get message count and if count=1, get the message
737: -- fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
738: -- p_count => x_msg_count,
739: -- p_data => x_msg_data
740: -- );
741: END insert_risk_control_count;

Line 757: -- p_commit IN VARCHAR2 Required Default = FND_API_G_FALSE

753: -- IN
754: -- p_apo_type IN apo_type Optional Default = null
755: -- p_do_insert IN VARCHAR2 Optional Default = 'INSERT'
756: -- p_org_count IN NUMBER Optional Default = 0
757: -- p_commit IN VARCHAR2 Required Default = FND_API_G_FALSE
758: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
759: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
760: --
761: --

Line 758: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

754: -- p_apo_type IN apo_type Optional Default = null
755: -- p_do_insert IN VARCHAR2 Optional Default = 'INSERT'
756: -- p_org_count IN NUMBER Optional Default = 0
757: -- p_commit IN VARCHAR2 Required Default = FND_API_G_FALSE
758: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
759: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
760: --
761: --
762: -- OUT

Line 759: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

755: -- p_do_insert IN VARCHAR2 Optional Default = 'INSERT'
756: -- p_org_count IN NUMBER Optional Default = 0
757: -- p_commit IN VARCHAR2 Required Default = FND_API_G_FALSE
758: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
759: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
760: --
761: --
762: -- OUT
763: -- x_return_status OUT VARCHAR2

Line 774: -- p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

770: -- ==============================================================================
771: --/*
772: -- PROCEDURE validate_apo_type (
773: -- p_api_version_number IN NUMBER,
774: -- p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
775: -- p_validation_level IN NUMBER
776: -- := fnd_api.g_valid_level_full,
777: -- x_return_status OUT NOCOPY VARCHAR2,
778: -- x_msg_count OUT NOCOPY NUMBER,

Line 776: -- := fnd_api.g_valid_level_full,

772: -- PROCEDURE validate_apo_type (
773: -- p_api_version_number IN NUMBER,
774: -- p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
775: -- p_validation_level IN NUMBER
776: -- := fnd_api.g_valid_level_full,
777: -- x_return_status OUT NOCOPY VARCHAR2,
778: -- x_msg_count OUT NOCOPY NUMBER,
779: -- x_msg_data OUT NOCOPY VARCHAR2
780: -- ) IS

Line 790: -- IF NOT fnd_api.compatible_api_call (l_api_version_number,

786: --
787: -- -- Standard Start of API savepoint
788: -- SAVEPOINT validate_process_pvt;
789: -- -- Standard call to check for call compatibility.
790: -- IF NOT fnd_api.compatible_api_call (l_api_version_number,
791: -- p_api_version_number,
792: -- l_api_name,
793: -- g_pkg_name
794: -- ) THEN

Line 795: -- RAISE fnd_api.g_exc_unexpected_error;

791: -- p_api_version_number,
792: -- l_api_name,
793: -- g_pkg_name
794: -- ) THEN
795: -- RAISE fnd_api.g_exc_unexpected_error;
796: -- END IF;
797: -- -- Initialize message list if p_init_msg_list is set to TRUE.
798: -- IF fnd_api.to_boolean (p_init_msg_list) THEN
799: -- fnd_msg_pub.initialize;

Line 798: -- IF fnd_api.to_boolean (p_init_msg_list) THEN

794: -- ) THEN
795: -- RAISE fnd_api.g_exc_unexpected_error;
796: -- END IF;
797: -- -- Initialize message list if p_init_msg_list is set to TRUE.
798: -- IF fnd_api.to_boolean (p_init_msg_list) THEN
799: -- fnd_msg_pub.initialize;
800: -- END IF;
801: -- IF p_validation_level >= jtf_plsql_api.g_valid_level_item THEN
802: -- check_apo_row (p_validation_mode => jtf_plsql_api.g_update,

Line 805: -- IF x_return_status = fnd_api.g_ret_sts_error THEN

801: -- IF p_validation_level >= jtf_plsql_api.g_valid_level_item THEN
802: -- check_apo_row (p_validation_mode => jtf_plsql_api.g_update,
803: -- x_return_status => x_return_status
804: -- );
805: -- IF x_return_status = fnd_api.g_ret_sts_error THEN
806: -- RAISE fnd_api.g_exc_error;
807: -- ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
808: -- RAISE fnd_api.g_exc_unexpected_error;
809: -- END IF;

Line 806: -- RAISE fnd_api.g_exc_error;

802: -- check_apo_row (p_validation_mode => jtf_plsql_api.g_update,
803: -- x_return_status => x_return_status
804: -- );
805: -- IF x_return_status = fnd_api.g_ret_sts_error THEN
806: -- RAISE fnd_api.g_exc_error;
807: -- ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
808: -- RAISE fnd_api.g_exc_unexpected_error;
809: -- END IF;
810: -- END IF;

Line 807: -- ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

803: -- x_return_status => x_return_status
804: -- );
805: -- IF x_return_status = fnd_api.g_ret_sts_error THEN
806: -- RAISE fnd_api.g_exc_error;
807: -- ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
808: -- RAISE fnd_api.g_exc_unexpected_error;
809: -- END IF;
810: -- END IF;
811: -- -- Debug Message

Line 808: -- RAISE fnd_api.g_exc_unexpected_error;

804: -- );
805: -- IF x_return_status = fnd_api.g_ret_sts_error THEN
806: -- RAISE fnd_api.g_exc_error;
807: -- ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
808: -- RAISE fnd_api.g_exc_unexpected_error;
809: -- END IF;
810: -- END IF;
811: -- -- Debug Message
812: -- amw_utility_pvt.debug_message ('Private API: ' || l_api_name || 'start');

Line 814: -- x_return_status := fnd_api.g_ret_sts_success;

810: -- END IF;
811: -- -- Debug Message
812: -- amw_utility_pvt.debug_message ('Private API: ' || l_api_name || 'start');
813: -- -- Initialize API return status to SUCCESS
814: -- x_return_status := fnd_api.g_ret_sts_success;
815: -- -- Debug Message
816: -- amw_utility_pvt.debug_message ('Private API: ' || l_api_name || 'end');
817: -- -- Standard call to get message count and if count is 1, get message info.
818: -- fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 821: -- x_return_status := fnd_api.g_ret_sts_error;

817: -- -- Standard call to get message count and if count is 1, get message info.
818: -- fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
819: -- EXCEPTION
820: -- WHEN amw_utility_pvt.resource_locked THEN
821: -- x_return_status := fnd_api.g_ret_sts_error;
822: -- amw_utility_pvt.error_message
823: -- (p_message_name => 'AMW_API_RESOURCE_LOCKED');
824: -- WHEN fnd_api.g_exc_error THEN
825: -- ROLLBACK TO validate_process_pvt;

Line 824: -- WHEN fnd_api.g_exc_error THEN

820: -- WHEN amw_utility_pvt.resource_locked THEN
821: -- x_return_status := fnd_api.g_ret_sts_error;
822: -- amw_utility_pvt.error_message
823: -- (p_message_name => 'AMW_API_RESOURCE_LOCKED');
824: -- WHEN fnd_api.g_exc_error THEN
825: -- ROLLBACK TO validate_process_pvt;
826: -- x_return_status := fnd_api.g_ret_sts_error;
827: -- -- Standard call to get message count and if count=1, get the message
828: -- fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,

Line 826: -- x_return_status := fnd_api.g_ret_sts_error;

822: -- amw_utility_pvt.error_message
823: -- (p_message_name => 'AMW_API_RESOURCE_LOCKED');
824: -- WHEN fnd_api.g_exc_error THEN
825: -- ROLLBACK TO validate_process_pvt;
826: -- x_return_status := fnd_api.g_ret_sts_error;
827: -- -- Standard call to get message count and if count=1, get the message
828: -- fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
829: -- p_count => x_msg_count,
830: -- p_data => x_msg_data

Line 828: -- fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,

824: -- WHEN fnd_api.g_exc_error THEN
825: -- ROLLBACK TO validate_process_pvt;
826: -- x_return_status := fnd_api.g_ret_sts_error;
827: -- -- Standard call to get message count and if count=1, get the message
828: -- fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
829: -- p_count => x_msg_count,
830: -- p_data => x_msg_data
831: -- );
832: -- WHEN fnd_api.g_exc_unexpected_error THEN

Line 832: -- WHEN fnd_api.g_exc_unexpected_error THEN

828: -- fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
829: -- p_count => x_msg_count,
830: -- p_data => x_msg_data
831: -- );
832: -- WHEN fnd_api.g_exc_unexpected_error THEN
833: -- ROLLBACK TO validate_process_pvt;
834: -- x_return_status := fnd_api.g_ret_sts_unexp_error;
835: -- -- Standard call to get message count and if count=1, get the message
836: -- fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,

Line 834: -- x_return_status := fnd_api.g_ret_sts_unexp_error;

830: -- p_data => x_msg_data
831: -- );
832: -- WHEN fnd_api.g_exc_unexpected_error THEN
833: -- ROLLBACK TO validate_process_pvt;
834: -- x_return_status := fnd_api.g_ret_sts_unexp_error;
835: -- -- Standard call to get message count and if count=1, get the message
836: -- fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
837: -- p_count => x_msg_count,
838: -- p_data => x_msg_data

Line 836: -- fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,

832: -- WHEN fnd_api.g_exc_unexpected_error THEN
833: -- ROLLBACK TO validate_process_pvt;
834: -- x_return_status := fnd_api.g_ret_sts_unexp_error;
835: -- -- Standard call to get message count and if count=1, get the message
836: -- fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
837: -- p_count => x_msg_count,
838: -- p_data => x_msg_data
839: -- );
840: -- WHEN OTHERS THEN

Line 842: -- x_return_status := fnd_api.g_ret_sts_unexp_error;

838: -- p_data => x_msg_data
839: -- );
840: -- WHEN OTHERS THEN
841: -- ROLLBACK TO validate_process_pvt;
842: -- x_return_status := fnd_api.g_ret_sts_unexp_error;
843: -- IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
844: -- fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
845: -- END IF;
846: -- -- Standard call to get message count and if count=1, get the message

Line 847: -- fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,

843: -- IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
844: -- fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
845: -- END IF;
846: -- -- Standard call to get message count and if count=1, get the message
847: -- fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
848: -- p_count => x_msg_count,
849: -- p_data => x_msg_data
850: -- );
851: -- END validate_apo_type;

Line 880: -- x_return_status := fnd_api.g_ret_sts_success;

876: -- p_validation_mode IN VARCHAR2 := jtf_plsql_api.g_create,
877: -- x_return_status OUT NOCOPY VARCHAR2
878: -- ) IS
879: -- BEGIN
880: -- x_return_status := fnd_api.g_ret_sts_success;
881: -- /*
882: -- IF p_validation_mode = jtf_plsql_api.g_create THEN
883: -- IF 2 IS NULL THEN
884: -- amw_utility_pvt.error_message

Line 886: -- x_return_status := fnd_api.g_ret_sts_error;

882: -- IF p_validation_mode = jtf_plsql_api.g_create THEN
883: -- IF 2 IS NULL THEN
884: -- amw_utility_pvt.error_message
885: -- (p_message_name => 'AMW_NO_ORGANIZATION_ID');
886: -- x_return_status := fnd_api.g_ret_sts_error;
887: -- RETURN;
888: -- END IF;
889: -- IF 3 IS NULL THEN
890: -- amw_utility_pvt.error_message

Line 892: -- x_return_status := fnd_api.g_ret_sts_error;

888: -- END IF;
889: -- IF 3 IS NULL THEN
890: -- amw_utility_pvt.error_message
891: -- (p_message_name => 'AMW_NO_PROCESS_ID');
892: -- x_return_status := fnd_api.g_ret_sts_error;
893: -- RETURN;
894: -- END IF;
895: -- END IF;
896: --