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

Line 70: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

66:
67: PROCEDURE add_scope
68: (
69: p_api_version_number IN NUMBER := 1.0,
70: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
71: p_commit IN VARCHAR2 := FND_API.g_false,
72: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
73: p_entity_id IN NUMBER,
74: p_entity_type IN VARCHAR2,

Line 71: p_commit IN VARCHAR2 := FND_API.g_false,

67: PROCEDURE add_scope
68: (
69: p_api_version_number IN NUMBER := 1.0,
70: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
71: p_commit IN VARCHAR2 := FND_API.g_false,
72: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
73: p_entity_id IN NUMBER,
74: p_entity_type IN VARCHAR2,
75: p_sub_vs IN VARCHAR2,

Line 72: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

68: (
69: p_api_version_number IN NUMBER := 1.0,
70: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
71: p_commit IN VARCHAR2 := FND_API.g_false,
72: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
73: p_entity_id IN NUMBER,
74: p_entity_type IN VARCHAR2,
75: p_sub_vs IN VARCHAR2,
76: p_lob_vs IN VARCHAR2,

Line 169: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

165: --hier_name := 'SUHierarchy';
166: SAVEPOINT POPULATE_HIERARCHIES;
167:
168: -- Standard call to check for call compatibility.
169: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
170: p_api_version_number,
171: l_api_name,
172: G_PKG_NAME)
173: THEN

Line 174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

170: p_api_version_number,
171: l_api_name,
172: G_PKG_NAME)
173: THEN
174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
175: END IF;
176:
177: -- Initialize message list if p_init_msg_list is set to TRUE.
178: IF FND_API.to_Boolean( p_init_msg_list )

Line 178: IF FND_API.to_Boolean( p_init_msg_list )

174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
175: END IF;
176:
177: -- Initialize message list if p_init_msg_list is set to TRUE.
178: IF FND_API.to_Boolean( p_init_msg_list )
179: THEN
180: FND_MSG_PUB.initialize;
181: END IF;
182:

Line 184: x_return_status := FND_API.G_RET_STS_SUCCESS;

180: FND_MSG_PUB.initialize;
181: END IF;
182:
183: -- Initialize API return status to SUCCESS
184: x_return_status := FND_API.G_RET_STS_SUCCESS;
185:
186: -- Whenever there is a change to hierarchy, the system will delete the existing hierarchy and rebuild it.
187: -- To begin with mark all records in the table as DELETED
188: UPDATE AMW_ENTITY_HIERARCHIES

Line 665: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

661: END IF;
662:
663: EXCEPTION WHEN OTHERS THEN
664: ROLLBACK TO POPULATE_HIERARCHIES;
665: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
666:
667: FND_MSG_PUB.Add_Exc_Msg('AMW_SCOPE_PVT', 'add_scope');
668: FND_MSG_PUB.Count_And_Get(
669: p_encoded => FND_API.G_FALSE,

Line 669: p_encoded => FND_API.G_FALSE,

665: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
666:
667: FND_MSG_PUB.Add_Exc_Msg('AMW_SCOPE_PVT', 'add_scope');
668: FND_MSG_PUB.Count_And_Get(
669: p_encoded => FND_API.G_FALSE,
670: p_count => x_msg_count,
671: p_data => x_msg_data);
672:
673:

Line 999: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

995:
996: PROCEDURE populate_process_hierarchy
997: (
998: p_api_version_number IN NUMBER := 1.0,
999: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1000: p_commit IN VARCHAR2 := FND_API.g_false,
1001: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1002: p_entity_type IN VARCHAR2,
1003: p_entity_id IN NUMBER,

Line 1000: p_commit IN VARCHAR2 := FND_API.g_false,

996: PROCEDURE populate_process_hierarchy
997: (
998: p_api_version_number IN NUMBER := 1.0,
999: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1000: p_commit IN VARCHAR2 := FND_API.g_false,
1001: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1002: p_entity_type IN VARCHAR2,
1003: p_entity_id IN NUMBER,
1004: p_org_tbl IN org_tbl_type,

Line 1001: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

997: (
998: p_api_version_number IN NUMBER := 1.0,
999: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1000: p_commit IN VARCHAR2 := FND_API.g_false,
1001: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1002: p_entity_type IN VARCHAR2,
1003: p_entity_id IN NUMBER,
1004: p_org_tbl IN org_tbl_type,
1005: p_process_tbl IN process_tbl_type,

Line 1069: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1065: BEGIN
1066: SAVEPOINT populate_proc_hierarchy;
1067: -- Standard call to check for call compatibility.
1068:
1069: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1070: p_api_version_number,
1071: l_api_name,
1072: G_PKG_NAME)
1073: THEN

Line 1074: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1070: p_api_version_number,
1071: l_api_name,
1072: G_PKG_NAME)
1073: THEN
1074: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1075: END IF;
1076:
1077: -- Initialize message list if p_init_msg_list is set to TRUE.
1078: IF FND_API.to_Boolean( p_init_msg_list )

Line 1078: IF FND_API.to_Boolean( p_init_msg_list )

1074: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1075: END IF;
1076:
1077: -- Initialize message list if p_init_msg_list is set to TRUE.
1078: IF FND_API.to_Boolean( p_init_msg_list )
1079: THEN
1080: FND_MSG_PUB.initialize;
1081: END IF;
1082:

Line 1084: x_return_status := FND_API.G_RET_STS_SUCCESS;

1080: FND_MSG_PUB.initialize;
1081: END IF;
1082:
1083: -- Initialize API return status to SUCCESS
1084: x_return_status := FND_API.G_RET_STS_SUCCESS;
1085:
1086: /* DELETE FROM AMW_EXECUTION_SCOPE
1087: WHERE entity_id = p_entity_id
1088: AND entity_type = p_entity_type

Line 1474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1470: END LOOP;--each_rec IN 1..p_org_tbl.count
1471:
1472: EXCEPTION WHEN OTHERS THEN
1473: rollback to populate_proc_hierarchy;
1474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1475: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1476: FND_MSG_PUB.Count_And_Get(
1477: p_encoded => FND_API.G_FALSE,
1478: p_count => x_msg_count,

Line 1477: p_encoded => FND_API.G_FALSE,

1473: rollback to populate_proc_hierarchy;
1474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1475: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1476: FND_MSG_PUB.Count_And_Get(
1477: p_encoded => FND_API.G_FALSE,
1478: p_count => x_msg_count,
1479: p_data => x_msg_data);
1480:
1481: END populate_process_hierarchy;

Line 1553: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

1549: END Insert_Process;
1550:
1551: PROCEDURE build_project_audit_task (
1552: p_api_version_number IN NUMBER,
1553: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1554: p_commit IN VARCHAR2 := FND_API.g_false,
1555: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1556: p_audit_project_id IN NUMBER,
1557: l_ineff_controls IN BOOLEAN := false,

Line 1554: p_commit IN VARCHAR2 := FND_API.g_false,

1550:
1551: PROCEDURE build_project_audit_task (
1552: p_api_version_number IN NUMBER,
1553: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1554: p_commit IN VARCHAR2 := FND_API.g_false,
1555: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1556: p_audit_project_id IN NUMBER,
1557: l_ineff_controls IN BOOLEAN := false,
1558: p_source_project_id IN NUMBER := 0,

Line 1555: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

1551: PROCEDURE build_project_audit_task (
1552: p_api_version_number IN NUMBER,
1553: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1554: p_commit IN VARCHAR2 := FND_API.g_false,
1555: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1556: p_audit_project_id IN NUMBER,
1557: l_ineff_controls IN BOOLEAN := false,
1558: p_source_project_id IN NUMBER := 0,
1559: x_return_status OUT nocopy VARCHAR2,

Line 1618: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1614: -- Standard Start of API savepoint
1615: SAVEPOINT BUILD_AUDIT_TASK_PVT;
1616:
1617: -- Standard call to check for call compatibility.
1618: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1619: p_api_version_number,
1620: l_api_name,
1621: G_PKG_NAME) THEN
1622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1618: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1619: p_api_version_number,
1620: l_api_name,
1621: G_PKG_NAME) THEN
1622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1623: END IF;
1624:
1625:
1626: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1627: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1623: END IF;
1624:
1625:
1626: -- Initialize message list if p_init_msg_list is set to TRUE.
1627: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1628: FND_MSG_PUB.initialize;
1629: END IF;
1630:
1631: -- Initialize API return status to SUCCESS

Line 1632: x_return_status := FND_API.G_RET_STS_SUCCESS;

1628: FND_MSG_PUB.initialize;
1629: END IF;
1630:
1631: -- Initialize API return status to SUCCESS
1632: x_return_status := FND_API.G_RET_STS_SUCCESS;
1633:
1634:
1635: OPEN c_project;
1636: FETCH c_project INTO l_exists;

Line 2512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2508:
2509:
2510: EXCEPTION WHEN OTHERS THEN
2511: rollback to BUILD_AUDIT_TASK_PVT;
2512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2513: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name, l_api_name);
2514: FND_MSG_PUB.Count_And_Get(
2515: p_encoded => FND_API.G_FALSE,
2516: p_count => x_msg_count,

Line 2515: p_encoded => FND_API.G_FALSE,

2511: rollback to BUILD_AUDIT_TASK_PVT;
2512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2513: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name, l_api_name);
2514: FND_MSG_PUB.Count_And_Get(
2515: p_encoded => FND_API.G_FALSE,
2516: p_count => x_msg_count,
2517: p_data => x_msg_data);
2518: END build_project_audit_task;
2519:

Line 2606: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

2602:
2603: PROCEDURE populate_association_tables
2604: (
2605: p_api_version_number IN NUMBER := 1.0,
2606: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
2607: p_commit IN VARCHAR2 := FND_API.g_false,
2608: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
2609: p_entity_type IN VARCHAR2,
2610: p_entity_id IN NUMBER,

Line 2607: p_commit IN VARCHAR2 := FND_API.g_false,

2603: PROCEDURE populate_association_tables
2604: (
2605: p_api_version_number IN NUMBER := 1.0,
2606: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
2607: p_commit IN VARCHAR2 := FND_API.g_false,
2608: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
2609: p_entity_type IN VARCHAR2,
2610: p_entity_id IN NUMBER,
2611: x_return_status OUT nocopy VARCHAR2,

Line 2608: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

2604: (
2605: p_api_version_number IN NUMBER := 1.0,
2606: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
2607: p_commit IN VARCHAR2 := FND_API.g_false,
2608: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
2609: p_entity_type IN VARCHAR2,
2610: p_entity_id IN NUMBER,
2611: x_return_status OUT nocopy VARCHAR2,
2612: x_msg_count OUT nocopy NUMBER,

Line 2647: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

2643: -- Standard Start of API savepoint
2644: SAVEPOINT POPULATE_ASSOCIATIONS;
2645:
2646: -- Standard call to check for call compatibility.
2647: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2648: p_api_version_number,
2649: l_api_name,
2650: 'AMW_SCOPE_PVT') THEN
2651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2647: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2648: p_api_version_number,
2649: l_api_name,
2650: 'AMW_SCOPE_PVT') THEN
2651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2652: END IF;
2653:
2654:
2655: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2656: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2652: END IF;
2653:
2654:
2655: -- Initialize message list if p_init_msg_list is set to TRUE.
2656: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2657: FND_MSG_PUB.initialize;
2658: END IF;
2659:
2660: -- Initialize API return status to SUCCESS

Line 2661: x_return_status := FND_API.G_RET_STS_SUCCESS;

2657: FND_MSG_PUB.initialize;
2658: END IF;
2659:
2660: -- Initialize API return status to SUCCESS
2661: x_return_status := FND_API.G_RET_STS_SUCCESS;
2662:
2663: DELETE FROM AMW_RISK_ASSOCIATIONS ara
2664: WHERE object_type = p_entity_type
2665: AND pk1 = p_entity_id

Line 3126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3122: AND SCOPE_CHANGED_STATUS = 'C';
3123:
3124: EXCEPTION WHEN OTHERS THEN
3125: ROLLBACK TO POPULATE_ASSOCIATIONS;
3126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3127: FND_MSG_PUB.Add_Exc_Msg('AMW_SCOPE_PVT', l_api_name);
3128: FND_MSG_PUB.Count_And_Get(
3129: p_encoded => FND_API.G_FALSE,
3130: p_count => x_msg_count,

Line 3129: p_encoded => FND_API.G_FALSE,

3125: ROLLBACK TO POPULATE_ASSOCIATIONS;
3126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3127: FND_MSG_PUB.Add_Exc_Msg('AMW_SCOPE_PVT', l_api_name);
3128: FND_MSG_PUB.Count_And_Get(
3129: p_encoded => FND_API.G_FALSE,
3130: p_count => x_msg_count,
3131: p_data => x_msg_data);
3132: END populate_association_tables;
3133:

Line 3137: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

3133:
3134: PROCEDURE populate_scope
3135: (
3136: p_api_version_number IN NUMBER := 1.0,
3137: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
3138: p_commit IN VARCHAR2 := FND_API.g_false,
3139: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
3140: p_entity_id IN NUMBER,
3141: x_return_status OUT nocopy VARCHAR2,

Line 3138: p_commit IN VARCHAR2 := FND_API.g_false,

3134: PROCEDURE populate_scope
3135: (
3136: p_api_version_number IN NUMBER := 1.0,
3137: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
3138: p_commit IN VARCHAR2 := FND_API.g_false,
3139: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
3140: p_entity_id IN NUMBER,
3141: x_return_status OUT nocopy VARCHAR2,
3142: x_msg_count OUT nocopy NUMBER,

Line 3139: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

3135: (
3136: p_api_version_number IN NUMBER := 1.0,
3137: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
3138: p_commit IN VARCHAR2 := FND_API.g_false,
3139: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
3140: p_entity_id IN NUMBER,
3141: x_return_status OUT nocopy VARCHAR2,
3142: x_msg_count OUT nocopy NUMBER,
3143: x_msg_data OUT nocopy VARCHAR2

Line 3175: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

3171: BEGIN
3172: SAVEPOINT POPULATE_SCOPE;
3173:
3174: -- Standard call to check for call compatibility.
3175: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3176: p_api_version_number,
3177: l_api_name,
3178: G_PKG_NAME)
3179: THEN

Line 3180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3176: p_api_version_number,
3177: l_api_name,
3178: G_PKG_NAME)
3179: THEN
3180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3181: END IF;
3182:
3183: -- Initialize message list if p_init_msg_list is set to TRUE.
3184: IF FND_API.to_Boolean( p_init_msg_list )

Line 3184: IF FND_API.to_Boolean( p_init_msg_list )

3180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3181: END IF;
3182:
3183: -- Initialize message list if p_init_msg_list is set to TRUE.
3184: IF FND_API.to_Boolean( p_init_msg_list )
3185: THEN
3186: FND_MSG_PUB.initialize;
3187: END IF;
3188:

Line 3190: x_return_status := FND_API.G_RET_STS_SUCCESS;

3186: FND_MSG_PUB.initialize;
3187: END IF;
3188:
3189: -- Initialize API return status to SUCCESS
3190: x_return_status := FND_API.G_RET_STS_SUCCESS;
3191:
3192: l_sub_vs := FND_PROFILE.value('AMW_SUBSIDIARY_AUDIT_UNIT');
3193: l_lob_vs := FND_PROFILE.value('AMW_LOB_AUDIT_UNITS');
3194:

Line 3237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3233:
3234: EXCEPTION WHEN OTHERS
3235: THEN
3236: ROLLBACK TO POPULATE_SCOPE;
3237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3238: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3239: FND_MSG_PUB.Count_And_Get(
3240: p_encoded => FND_API.G_FALSE,
3241: p_count => x_msg_count,

Line 3240: p_encoded => FND_API.G_FALSE,

3236: ROLLBACK TO POPULATE_SCOPE;
3237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3238: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3239: FND_MSG_PUB.Count_And_Get(
3240: p_encoded => FND_API.G_FALSE,
3241: p_count => x_msg_count,
3242: p_data => x_msg_data);
3243:
3244: END populate_scope;

Line 3249: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

3245:
3246: PROCEDURE manage_processes
3247: (
3248: p_api_version_number IN NUMBER,
3249: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
3250: p_commit IN VARCHAR2 := FND_API.g_false,
3251: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
3252: p_entity_type IN VARCHAR2,
3253: p_entity_id IN NUMBER,

Line 3250: p_commit IN VARCHAR2 := FND_API.g_false,

3246: PROCEDURE manage_processes
3247: (
3248: p_api_version_number IN NUMBER,
3249: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
3250: p_commit IN VARCHAR2 := FND_API.g_false,
3251: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
3252: p_entity_type IN VARCHAR2,
3253: p_entity_id IN NUMBER,
3254: p_organization_id IN NUMBER,

Line 3251: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

3247: (
3248: p_api_version_number IN NUMBER,
3249: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
3250: p_commit IN VARCHAR2 := FND_API.g_false,
3251: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
3252: p_entity_type IN VARCHAR2,
3253: p_entity_id IN NUMBER,
3254: p_organization_id IN NUMBER,
3255: p_proc_hier_tbl IN PROC_HIER_TBL_TYPE,

Line 3304: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

3300: -- Standard Start of API savepoint
3301: SAVEPOINT MANAGE_PROCESSES_PVT;
3302:
3303: -- Standard call to check for call compatibility.
3304: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3305: p_api_version_number,
3306: l_api_name,
3307: G_PKG_NAME) THEN
3308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3304: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3305: p_api_version_number,
3306: l_api_name,
3307: G_PKG_NAME) THEN
3308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3309: END IF;
3310:
3311:
3312: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3313: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3309: END IF;
3310:
3311:
3312: -- Initialize message list if p_init_msg_list is set to TRUE.
3313: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3314: FND_MSG_PUB.initialize;
3315: END IF;
3316:
3317: -- Initialize API return status to SUCCESS

Line 3318: x_return_status := FND_API.G_RET_STS_SUCCESS;

3314: FND_MSG_PUB.initialize;
3315: END IF;
3316:
3317: -- Initialize API return status to SUCCESS
3318: x_return_status := FND_API.G_RET_STS_SUCCESS;
3319:
3320: OPEN c_scope_org;
3321: FETCH c_scope_org INTO l_subsidiary_vs, l_sub_code,l_lob_vs, l_lob_code;
3322: CLOSE c_scope_org;

Line 3450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3446: p_mode => 'ManageProc');
3447:
3448: EXCEPTION WHEN OTHERS THEN
3449: rollback to MANAGE_PROCESSES_PVT;
3450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3451: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name, l_api_name);
3452: FND_MSG_PUB.Count_And_Get(
3453: p_encoded => FND_API.G_FALSE,
3454: p_count => x_msg_count,

Line 3453: p_encoded => FND_API.G_FALSE,

3449: rollback to MANAGE_PROCESSES_PVT;
3450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3451: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name, l_api_name);
3452: FND_MSG_PUB.Count_And_Get(
3453: p_encoded => FND_API.G_FALSE,
3454: p_count => x_msg_count,
3455: p_data => x_msg_data);
3456: END Manage_Processes;
3457:

Line 3461: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

3457:
3458: PROCEDURE remove_from_scope
3459: (
3460: p_api_version_number IN NUMBER := 1.0,
3461: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
3462: p_commit IN VARCHAR2 := FND_API.g_false,
3463: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
3464: p_entity_type IN VARCHAR2,
3465: p_entity_id IN NUMBER,

Line 3462: p_commit IN VARCHAR2 := FND_API.g_false,

3458: PROCEDURE remove_from_scope
3459: (
3460: p_api_version_number IN NUMBER := 1.0,
3461: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
3462: p_commit IN VARCHAR2 := FND_API.g_false,
3463: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
3464: p_entity_type IN VARCHAR2,
3465: p_entity_id IN NUMBER,
3466: p_object_id IN NUMBER,

Line 3463: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

3459: (
3460: p_api_version_number IN NUMBER := 1.0,
3461: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
3462: p_commit IN VARCHAR2 := FND_API.g_false,
3463: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
3464: p_entity_type IN VARCHAR2,
3465: p_entity_id IN NUMBER,
3466: p_object_id IN NUMBER,
3467: p_object_type IN VARCHAR2,

Line 3522: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

3518:
3519: SAVEPOINT REMOVE_FROM_SCOPE;
3520:
3521: -- Standard call to check for call compatibility.
3522: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3523: p_api_version_number,
3524: l_api_name,
3525: G_PKG_NAME)
3526: THEN

Line 3527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3523: p_api_version_number,
3524: l_api_name,
3525: G_PKG_NAME)
3526: THEN
3527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3528: END IF;
3529:
3530: -- Initialize message list if p_init_msg_list is set to TRUE.
3531: IF FND_API.to_Boolean( p_init_msg_list )

Line 3531: IF FND_API.to_Boolean( p_init_msg_list )

3527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3528: END IF;
3529:
3530: -- Initialize message list if p_init_msg_list is set to TRUE.
3531: IF FND_API.to_Boolean( p_init_msg_list )
3532: THEN
3533: FND_MSG_PUB.initialize;
3534: END IF;
3535:

Line 3537: x_return_status := FND_API.G_RET_STS_SUCCESS;

3533: FND_MSG_PUB.initialize;
3534: END IF;
3535:
3536: -- Initialize API return status to SUCCESS
3537: x_return_status := FND_API.G_RET_STS_SUCCESS;
3538:
3539: --Step 0: Lock relevant rows
3540: OPEN get_relevant_rows;
3541: FETCH get_relevant_rows INTO l_exists;

Line 3662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3658:
3659: EXCEPTION WHEN OTHERS
3660: THEN
3661: ROLLBACK TO REMOVE_FROM_SCOPE;
3662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3663: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3664: FND_MSG_PUB.Count_And_Get
3665: (
3666: p_encoded => FND_API.G_FALSE,

Line 3666: p_encoded => FND_API.G_FALSE,

3662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3663: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3664: FND_MSG_PUB.Count_And_Get
3665: (
3666: p_encoded => FND_API.G_FALSE,
3667: p_count => x_msg_count,
3668: p_data => x_msg_data
3669: );
3670:

Line 3676: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

3672:
3673: PROCEDURE remove_orgs_from_scope
3674: (
3675: p_api_version_number IN NUMBER := 1.0,
3676: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
3677: p_commit IN VARCHAR2 := FND_API.g_false,
3678: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
3679: p_entity_type IN VARCHAR2,
3680: p_entity_id IN NUMBER,

Line 3677: p_commit IN VARCHAR2 := FND_API.g_false,

3673: PROCEDURE remove_orgs_from_scope
3674: (
3675: p_api_version_number IN NUMBER := 1.0,
3676: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
3677: p_commit IN VARCHAR2 := FND_API.g_false,
3678: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
3679: p_entity_type IN VARCHAR2,
3680: p_entity_id IN NUMBER,
3681: p_object_id IN NUMBER,

Line 3678: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

3674: (
3675: p_api_version_number IN NUMBER := 1.0,
3676: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
3677: p_commit IN VARCHAR2 := FND_API.g_false,
3678: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
3679: p_entity_type IN VARCHAR2,
3680: p_entity_id IN NUMBER,
3681: p_object_id IN NUMBER,
3682: x_return_status OUT nocopy VARCHAR2,

Line 3702: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

3698:
3699: SAVEPOINT REMOVE_ORGS_FROM_SCOPE;
3700:
3701: -- Standard call to check for call compatibility.
3702: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3703: p_api_version_number,
3704: l_api_name,
3705: G_PKG_NAME)
3706: THEN

Line 3707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3703: p_api_version_number,
3704: l_api_name,
3705: G_PKG_NAME)
3706: THEN
3707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3708: END IF;
3709:
3710: -- Initialize message list if p_init_msg_list is set to TRUE.
3711: IF FND_API.to_Boolean( p_init_msg_list )

Line 3711: IF FND_API.to_Boolean( p_init_msg_list )

3707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3708: END IF;
3709:
3710: -- Initialize message list if p_init_msg_list is set to TRUE.
3711: IF FND_API.to_Boolean( p_init_msg_list )
3712: THEN
3713: FND_MSG_PUB.initialize;
3714: END IF;
3715:

Line 3717: x_return_status := FND_API.G_RET_STS_SUCCESS;

3713: FND_MSG_PUB.initialize;
3714: END IF;
3715:
3716: -- Initialize API return status to SUCCESS
3717: x_return_status := FND_API.G_RET_STS_SUCCESS;
3718:
3719: --Step 1: Delete the node 'ORG' AND 'ORGANIZATION' from the hierarchy table
3720: DELETE FROM AMW_ENTITY_HIERARCHIES
3721: WHERE object_id = p_object_id

Line 3783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3779:
3780: EXCEPTION WHEN OTHERS
3781: THEN
3782: ROLLBACK TO REMOVE_ORGS_FROM_SCOPE;
3783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3784: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3785: FND_MSG_PUB.Count_And_Get(
3786: p_encoded => FND_API.G_FALSE,
3787: p_count => x_msg_count,

Line 3786: p_encoded => FND_API.G_FALSE,

3782: ROLLBACK TO REMOVE_ORGS_FROM_SCOPE;
3783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3784: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3785: FND_MSG_PUB.Count_And_Get(
3786: p_encoded => FND_API.G_FALSE,
3787: p_count => x_msg_count,
3788: p_data => x_msg_data);
3789:
3790: END remove_orgs_from_scope;