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

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

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

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

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

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

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

Line 63: p_commit in varchar2 := FND_API.G_FALSE,

59: p_organization_id in number := null,
60: p_mode in varchar2 := 'ASSOCIATE',
61: p_level in number := 0,
62: p_apo_type in apo_type := g_miss_apo_type,
63: p_commit in varchar2 := FND_API.G_FALSE,
64: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
65: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
66: x_return_status out nocopy varchar2,
67: x_msg_count out nocopy number,

Line 64: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

60: p_mode in varchar2 := 'ASSOCIATE',
61: p_level in number := 0,
62: p_apo_type in apo_type := g_miss_apo_type,
63: p_commit in varchar2 := FND_API.G_FALSE,
64: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
65: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
66: x_return_status out nocopy varchar2,
67: x_msg_count out nocopy number,
68: x_msg_data out nocopy varchar2

Line 65: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

61: p_level in number := 0,
62: p_apo_type in apo_type := g_miss_apo_type,
63: p_commit in varchar2 := FND_API.G_FALSE,
64: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
65: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
66: x_return_status out nocopy varchar2,
67: x_msg_count out nocopy number,
68: x_msg_data out nocopy varchar2
69: )

Line 110: x_return_status := FND_API.G_RET_STS_SUCCESS;

106: l_mode varchar2(30) := p_mode;
107:
108: begin
109: savepoint process_process_hierarchy_pub;
110: x_return_status := FND_API.G_RET_STS_SUCCESS;
111:
112: -- Initialize message list if p_init_msg_list is set to TRUE.
113: IF FND_API.to_Boolean( p_init_msg_list )
114: THEN

Line 113: IF FND_API.to_Boolean( p_init_msg_list )

109: savepoint process_process_hierarchy_pub;
110: x_return_status := FND_API.G_RET_STS_SUCCESS;
111:
112: -- Initialize message list if p_init_msg_list is set to TRUE.
113: IF FND_API.to_Boolean( p_init_msg_list )
114: THEN
115: FND_MSG_PUB.initialize;
116: END IF;
117:

Line 125: RAISE FND_API.G_EXC_ERROR;

121: -- =========================================================================
122: IF FND_GLOBAL.User_Id IS NULL
123: THEN
124: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
125: RAISE FND_API.G_EXC_ERROR;
126: END IF;
127:
128: IF(p_validation_level >= FND_API.G_VALID_LEVEL_FULL)
129: THEN

Line 128: IF(p_validation_level >= FND_API.G_VALID_LEVEL_FULL)

124: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
125: RAISE FND_API.G_EXC_ERROR;
126: END IF;
127:
128: IF(p_validation_level >= FND_API.G_VALID_LEVEL_FULL)
129: THEN
130: -- Debug message
131: AMW_UTILITY_PVT.debug_message('Private API: Validate_Process');
132:

Line 140: p_init_msg_list => FND_API.G_FALSE,

136: l_level := p_level;
137:
138: validate_apo_type(
139: p_api_version_number => 1.0,
140: p_init_msg_list => FND_API.G_FALSE,
141: p_validation_level => p_validation_level,
142: p_apo_type => l_apo_type,
143: x_return_status => x_return_status,
144: x_msg_count => x_msg_count,

Line 148: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

144: x_msg_count => x_msg_count,
145: x_msg_data => x_msg_data);
146: END IF;
147:
148: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
149: RAISE FND_API.G_EXC_ERROR;
150: END IF;
151: -- =========================================================================
152: -- End Validate Environment

Line 149: RAISE FND_API.G_EXC_ERROR;

145: x_msg_data => x_msg_data);
146: END IF;
147:
148: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
149: RAISE FND_API.G_EXC_ERROR;
150: END IF;
151: -- =========================================================================
152: -- End Validate Environment
153: -- =========================================================================

Line 160: RAISE FND_API.G_EXC_ERROR;

156:
157: if p_process_id is null or p_organization_id is null
158: then
159: -----------DBMS_OUTPUT.PUT_LINE ('ERROR -- exiting');
160: RAISE FND_API.G_EXC_ERROR;
161: end if;
162:
163: -- open c1;
164: -- loop

Line 196: x_return_status := FND_API.G_RET_STS_SUCCESS;

192: end if;
193:
194: for l_process_id in c1(p_process_id) loop
195: exit when c1%notfound;
196: x_return_status := FND_API.G_RET_STS_SUCCESS;
197:
198: ---dbms_output.put_line('child_process_id: '||l_process_id.child_process_id);
199:
200: associate_process_org(

Line 267: ---------dbms_output.put_line('FND_API.G_RET_STS_SUCCESS: '||FND_API.G_RET_STS_SUCCESS);

263: x_msg_count => x_msg_count,
264: x_msg_data => x_msg_data
265: );
266: --------dbms_output.put_line('Process_Process_Hierarchy x_return_status: '||x_return_status);
267: ---------dbms_output.put_line('FND_API.G_RET_STS_SUCCESS: '||FND_API.G_RET_STS_SUCCESS);
268:
269: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
270: RAISE FND_API.G_EXC_ERROR;
271: END IF;

Line 269: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

265: );
266: --------dbms_output.put_line('Process_Process_Hierarchy x_return_status: '||x_return_status);
267: ---------dbms_output.put_line('FND_API.G_RET_STS_SUCCESS: '||FND_API.G_RET_STS_SUCCESS);
268:
269: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
270: RAISE FND_API.G_EXC_ERROR;
271: END IF;
272: ****/
273:

Line 270: RAISE FND_API.G_EXC_ERROR;

266: --------dbms_output.put_line('Process_Process_Hierarchy x_return_status: '||x_return_status);
267: ---------dbms_output.put_line('FND_API.G_RET_STS_SUCCESS: '||FND_API.G_RET_STS_SUCCESS);
268:
269: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
270: RAISE FND_API.G_EXC_ERROR;
271: END IF;
272: ****/
273:
274: -- end loop;

Line 287: WHEN FND_API.G_EXC_ERROR THEN

283: p_data => x_msg_data
284: );
285:
286: exception
287: WHEN FND_API.G_EXC_ERROR THEN
288: ROLLBACK TO process_process_hierarchy_pub;
289: x_return_status := FND_API.G_RET_STS_ERROR;
290: -- Standard call to get message count and if count=1, get the message
291: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

Line 289: x_return_status := FND_API.G_RET_STS_ERROR;

285:
286: exception
287: WHEN FND_API.G_EXC_ERROR THEN
288: ROLLBACK TO process_process_hierarchy_pub;
289: x_return_status := FND_API.G_RET_STS_ERROR;
290: -- Standard call to get message count and if count=1, get the message
291: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
292:
293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 291: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

287: WHEN FND_API.G_EXC_ERROR THEN
288: ROLLBACK TO process_process_hierarchy_pub;
289: x_return_status := FND_API.G_RET_STS_ERROR;
290: -- Standard call to get message count and if count=1, get the message
291: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
292:
293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
294: ROLLBACK TO process_process_hierarchy_pub;
295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

289: x_return_status := FND_API.G_RET_STS_ERROR;
290: -- Standard call to get message count and if count=1, get the message
291: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
292:
293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
294: ROLLBACK TO process_process_hierarchy_pub;
295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
296: -- Standard call to get message count and if count=1, get the message
297: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

Line 295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

291: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
292:
293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
294: ROLLBACK TO process_process_hierarchy_pub;
295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
296: -- Standard call to get message count and if count=1, get the message
297: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
298:
299: WHEN OTHERS THEN

Line 297: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
294: ROLLBACK TO process_process_hierarchy_pub;
295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
296: -- Standard call to get message count and if count=1, get the message
297: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
298:
299: WHEN OTHERS THEN
300: ROLLBACK TO process_process_hierarchy_pub;
301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

297: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
298:
299: WHEN OTHERS THEN
300: ROLLBACK TO process_process_hierarchy_pub;
301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
302: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
303: THEN
304: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
305: END IF;

Line 307: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

303: THEN
304: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
305: END IF;
306: -- Standard call to get message count and if count=1, get the message
307: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
308: end process_process_hierarchy;
309:
310: -- ==============================================================================
311: -- Start of Comments

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

324: -- p_top_process_id IN NUMBER Optional Default = null
325: -- p_organization_id IN NUMBER Optional Default = null
326: -- p_parent_process_id IN NUMBER Optional Default = null
327: -- p_mode IN VARCHAR2 Required Default = 'ASSOCIATE'
328: -- p_commit IN VARCHAR2 Required Default = FND_API_G_FALSE
329: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
330: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
331: --
332: -- OUT

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

325: -- p_organization_id IN NUMBER Optional Default = null
326: -- p_parent_process_id IN NUMBER Optional Default = null
327: -- p_mode IN VARCHAR2 Required Default = 'ASSOCIATE'
328: -- p_commit IN VARCHAR2 Required Default = FND_API_G_FALSE
329: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
330: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
331: --
332: -- OUT
333: -- x_return_status OUT VARCHAR2

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

326: -- p_parent_process_id IN NUMBER Optional Default = null
327: -- p_mode IN VARCHAR2 Required Default = 'ASSOCIATE'
328: -- p_commit IN VARCHAR2 Required Default = FND_API_G_FALSE
329: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
330: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
331: --
332: -- OUT
333: -- x_return_status OUT VARCHAR2
334: -- x_msg_count OUT NUMBER

Line 356: p_commit in varchar2 := FND_API.G_FALSE,

352: p_risk_id in number := null,
353: p_control_id in number := null,
354: p_mode in varchar2 := 'ASSOCIATE',
355:
356: p_commit in varchar2 := FND_API.G_FALSE,
357: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
358: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
359:
360: x_return_status out nocopy varchar2,

Line 357: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

353: p_control_id in number := null,
354: p_mode in varchar2 := 'ASSOCIATE',
355:
356: p_commit in varchar2 := FND_API.G_FALSE,
357: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
358: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
359:
360: x_return_status out nocopy varchar2,
361: x_msg_count out nocopy number,

Line 358: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

354: p_mode in varchar2 := 'ASSOCIATE',
355:
356: p_commit in varchar2 := FND_API.G_FALSE,
357: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
358: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
359:
360: x_return_status out nocopy varchar2,
361: x_msg_count out nocopy number,
362: x_msg_data out nocopy varchar2

Line 422: x_return_status := FND_API.G_RET_STS_SUCCESS;

418: cc5_row cc5%rowtype;
419:
420: begin
421: savepoint associate_process_org_pvt;
422: x_return_status := FND_API.G_RET_STS_SUCCESS;
423:
424: ----DBMS_OUTPUT.PUT_LINE ( 'associate_process_org:' );
425: ----DBMS_OUTPUT.PUT_LINE ( 'top process id being passed to INSERT_IN_AMWPO:'|| p_top_process_id);
426:

Line 596: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

592: );
593:
594: ---------------------------dbms_output.put_line('Associate_Process_Org x_return_status: '||x_return_status);
595:
596: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
597: RAISE FND_API.G_EXC_ERROR;
598: END IF;
599:
600: AMW_UTILITY_PVT.debug_message('Private API: ' || L_API_NAME || 'end');

Line 597: RAISE FND_API.G_EXC_ERROR;

593:
594: ---------------------------dbms_output.put_line('Associate_Process_Org x_return_status: '||x_return_status);
595:
596: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
597: RAISE FND_API.G_EXC_ERROR;
598: END IF;
599:
600: AMW_UTILITY_PVT.debug_message('Private API: ' || L_API_NAME || 'end');
601:

Line 611: WHEN FND_API.G_EXC_ERROR THEN

607: end loop;
608: close c1;
609:
610: exception
611: WHEN FND_API.G_EXC_ERROR THEN
612: ROLLBACK TO associate_process_org_pvt;
613: x_return_status := FND_API.G_RET_STS_ERROR;
614: -- Standard call to get message count and if count=1, get the message
615: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

Line 613: x_return_status := FND_API.G_RET_STS_ERROR;

609:
610: exception
611: WHEN FND_API.G_EXC_ERROR THEN
612: ROLLBACK TO associate_process_org_pvt;
613: x_return_status := FND_API.G_RET_STS_ERROR;
614: -- Standard call to get message count and if count=1, get the message
615: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
616:
617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 615: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

611: WHEN FND_API.G_EXC_ERROR THEN
612: ROLLBACK TO associate_process_org_pvt;
613: x_return_status := FND_API.G_RET_STS_ERROR;
614: -- Standard call to get message count and if count=1, get the message
615: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
616:
617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
618: ROLLBACK TO associate_process_org_pvt;
619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

613: x_return_status := FND_API.G_RET_STS_ERROR;
614: -- Standard call to get message count and if count=1, get the message
615: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
616:
617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
618: ROLLBACK TO associate_process_org_pvt;
619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
620: -- Standard call to get message count and if count=1, get the message
621: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

Line 619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

615: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
616:
617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
618: ROLLBACK TO associate_process_org_pvt;
619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
620: -- Standard call to get message count and if count=1, get the message
621: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
622:
623: WHEN OTHERS THEN

Line 621: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
618: ROLLBACK TO associate_process_org_pvt;
619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
620: -- Standard call to get message count and if count=1, get the message
621: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
622:
623: WHEN OTHERS THEN
624: ROLLBACK TO associate_process_org_pvt;
625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

621: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
622:
623: WHEN OTHERS THEN
624: ROLLBACK TO associate_process_org_pvt;
625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
626: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
627: THEN
628: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
629: END IF;

Line 631: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

627: THEN
628: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
629: END IF;
630: -- Standard call to get message count and if count=1, get the message
631: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
632:
633: end associate_process_org;
634:
635: -- ==============================================================================

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

646: -- IN
647: -- p_apo_type IN apo_type Optional Default = null
648: -- p_do_insert IN VARCHAR2 Optional Default = 'INSERT'
649: -- p_org_count IN NUMBER Optional Default = 0
650: -- p_commit IN VARCHAR2 Required Default = FND_API_G_FALSE
651: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
652: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
653: --
654: --

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

647: -- p_apo_type IN apo_type Optional Default = null
648: -- p_do_insert IN VARCHAR2 Optional Default = 'INSERT'
649: -- p_org_count IN NUMBER Optional Default = 0
650: -- p_commit IN VARCHAR2 Required Default = FND_API_G_FALSE
651: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
652: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
653: --
654: --
655: -- OUT

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

648: -- p_do_insert IN VARCHAR2 Optional Default = 'INSERT'
649: -- p_org_count IN NUMBER Optional Default = 0
650: -- p_commit IN VARCHAR2 Required Default = FND_API_G_FALSE
651: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
652: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
653: --
654: --
655: -- OUT
656: -- x_return_status OUT VARCHAR2

Line 675: p_commit in varchar2 := FND_API.G_FALSE,

671: p_batch_id in number := null,
672: p_rcm_org_intf_id in number := null,
673: p_risk_id in number := null,
674: p_control_id in number := null,
675: p_commit in varchar2 := FND_API.G_FALSE,
676: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
677: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
678: x_return_status out nocopy varchar2,
679: x_msg_count out nocopy number,

Line 676: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

672: p_rcm_org_intf_id in number := null,
673: p_risk_id in number := null,
674: p_control_id in number := null,
675: p_commit in varchar2 := FND_API.G_FALSE,
676: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
677: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
678: x_return_status out nocopy varchar2,
679: x_msg_count out nocopy number,
680: x_msg_data out nocopy varchar2

Line 677: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

673: p_risk_id in number := null,
674: p_control_id in number := null,
675: p_commit in varchar2 := FND_API.G_FALSE,
676: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
677: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
678: x_return_status out nocopy varchar2,
679: x_msg_count out nocopy number,
680: x_msg_data out nocopy varchar2
681: )

Line 712: IF FND_API.to_Boolean( p_init_msg_list )

708:
709: ---------------------DBMS_OUTPUT.PUT_LINE ( 'top_process id: '|| p_apo_type.top_process_id);
710:
711: -- Initialize message list if p_init_msg_list is set to TRUE.
712: IF FND_API.to_Boolean( p_init_msg_list )
713: THEN
714: FND_MSG_PUB.initialize;
715: END IF;
716:

Line 920: ---DBMS_OUTPUT.PUT_LINE(FND_API.to_Boolean(p_commit));

916: last_update_login=G_LOGIN_ID
917: where process_id=p_apo_type.process_id; */
918: end if;
919:
920: ---DBMS_OUTPUT.PUT_LINE(FND_API.to_Boolean(p_commit));
921: -- Standard check for p_commit
922: IF FND_API.to_Boolean(p_commit)
923: THEN
924: COMMIT WORK;

Line 922: IF FND_API.to_Boolean(p_commit)

918: end if;
919:
920: ---DBMS_OUTPUT.PUT_LINE(FND_API.to_Boolean(p_commit));
921: -- Standard check for p_commit
922: IF FND_API.to_Boolean(p_commit)
923: THEN
924: COMMIT WORK;
925: END IF;
926:

Line 928: x_return_status := FND_API.G_RET_STS_SUCCESS;

924: COMMIT WORK;
925: END IF;
926:
927:
928: x_return_status := FND_API.G_RET_STS_SUCCESS;
929:
930: select process_organization_id into l_process_organization_id from amw_process_organization
931: where process_id=p_apo_type.process_id and organization_id=p_apo_type.organization_id;
932:

Line 983: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

979: x_msg_data => x_msg_data);
980: end if;
981:
982: ----------------------dbms_output.put_line('Process_AMW_Process_Org x_return_status: '||x_return_status);
983: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
984: RAISE FND_API.G_EXC_ERROR;
985: END IF;
986:
987: -- Debug Message

Line 984: RAISE FND_API.G_EXC_ERROR;

980: end if;
981:
982: ----------------------dbms_output.put_line('Process_AMW_Process_Org x_return_status: '||x_return_status);
983: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
984: RAISE FND_API.G_EXC_ERROR;
985: END IF;
986:
987: -- Debug Message
988: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');

Line 997: WHEN FND_API.G_EXC_ERROR THEN

993: p_data => x_msg_data
994: );
995:
996: exception
997: WHEN FND_API.G_EXC_ERROR THEN
998: ROLLBACK TO insert_in_amwpo_pvt;
999: x_return_status := FND_API.G_RET_STS_ERROR;
1000: -- Standard call to get message count and if count=1, get the message
1001: FND_MSG_PUB.Count_And_Get (

Line 999: x_return_status := FND_API.G_RET_STS_ERROR;

995:
996: exception
997: WHEN FND_API.G_EXC_ERROR THEN
998: ROLLBACK TO insert_in_amwpo_pvt;
999: x_return_status := FND_API.G_RET_STS_ERROR;
1000: -- Standard call to get message count and if count=1, get the message
1001: FND_MSG_PUB.Count_And_Get (
1002: p_encoded => FND_API.G_FALSE,
1003: p_count => x_msg_count,

Line 1002: p_encoded => FND_API.G_FALSE,

998: ROLLBACK TO insert_in_amwpo_pvt;
999: x_return_status := FND_API.G_RET_STS_ERROR;
1000: -- Standard call to get message count and if count=1, get the message
1001: FND_MSG_PUB.Count_And_Get (
1002: p_encoded => FND_API.G_FALSE,
1003: p_count => x_msg_count,
1004: p_data => x_msg_data
1005: );
1006:

Line 1007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1003: p_count => x_msg_count,
1004: p_data => x_msg_data
1005: );
1006:
1007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1008: ROLLBACK TO insert_in_amwpo_pvt;
1009: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1010: -- Standard call to get message count and if count=1, get the message
1011: FND_MSG_PUB.Count_And_Get (

Line 1009: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1005: );
1006:
1007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1008: ROLLBACK TO insert_in_amwpo_pvt;
1009: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1010: -- Standard call to get message count and if count=1, get the message
1011: FND_MSG_PUB.Count_And_Get (
1012: p_encoded => FND_API.G_FALSE,
1013: p_count => x_msg_count,

Line 1012: p_encoded => FND_API.G_FALSE,

1008: ROLLBACK TO insert_in_amwpo_pvt;
1009: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1010: -- Standard call to get message count and if count=1, get the message
1011: FND_MSG_PUB.Count_And_Get (
1012: p_encoded => FND_API.G_FALSE,
1013: p_count => x_msg_count,
1014: p_data => x_msg_data
1015: );
1016:

Line 1019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1015: );
1016:
1017: WHEN OTHERS THEN
1018: ROLLBACK TO insert_in_amwpo_pvt;
1019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1020: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1021: THEN
1022: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1023: END IF;

Line 1026: p_encoded => FND_API.G_FALSE,

1022: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1023: END IF;
1024: -- Standard call to get message count and if count=1, get the message
1025: FND_MSG_PUB.Count_And_Get (
1026: p_encoded => FND_API.G_FALSE,
1027: p_count => x_msg_count,
1028: p_data => x_msg_data
1029: );
1030: end process_amw_process_org;

Line 1040: p_commit in varchar2 := FND_API.G_FALSE,

1036: p_organization_id in number := null,
1037: p_process_id in number := null,
1038: p_risk_id in number := null,
1039: p_control_id in number := null,
1040: p_commit in varchar2 := FND_API.G_FALSE,
1041: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1042: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1043: x_return_status out nocopy varchar2,
1044: x_msg_count out nocopy number,

Line 1041: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1037: p_process_id in number := null,
1038: p_risk_id in number := null,
1039: p_control_id in number := null,
1040: p_commit in varchar2 := FND_API.G_FALSE,
1041: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1042: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1043: x_return_status out nocopy varchar2,
1044: x_msg_count out nocopy number,
1045: x_msg_data out nocopy varchar2

Line 1042: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1038: p_risk_id in number := null,
1039: p_control_id in number := null,
1040: p_commit in varchar2 := FND_API.G_FALSE,
1041: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1042: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1043: x_return_status out nocopy varchar2,
1044: x_msg_count out nocopy number,
1045: x_msg_data out nocopy varchar2
1046: )

Line 1074: RAISE FND_API.G_EXC_ERROR;

1070: L_API_NAME CONSTANT VARCHAR2(30) := 'PROCESS_AMW_RCM_ORG';
1071: begin
1072: IF FND_GLOBAL.User_Id IS NULL THEN
1073: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
1074: RAISE FND_API.G_EXC_ERROR;
1075: END IF;
1076:
1077: fnd_file.PUT_LINE( fnd_file.LOG, '%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&%^&');
1078: fnd_file.PUT_LINE( fnd_file.LOG, 'INSIDE PROCESS_AMW_RCM_ORG');

Line 1234: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1230: x_return_status => x_return_status,
1231: x_msg_count => x_msg_count,
1232: x_msg_data => x_msg_data);
1233:
1234: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1235: RAISE FND_API.G_EXC_ERROR;
1236: END IF;
1237: END IF;
1238:

Line 1235: RAISE FND_API.G_EXC_ERROR;

1231: x_msg_count => x_msg_count,
1232: x_msg_data => x_msg_data);
1233:
1234: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1235: RAISE FND_API.G_EXC_ERROR;
1236: END IF;
1237: END IF;
1238:
1239: exception

Line 1240: WHEN FND_API.G_EXC_ERROR THEN

1236: END IF;
1237: END IF;
1238:
1239: exception
1240: WHEN FND_API.G_EXC_ERROR THEN
1241: ROLLBACK;
1242: x_return_status := FND_API.G_RET_STS_ERROR;
1243: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1244:

Line 1242: x_return_status := FND_API.G_RET_STS_ERROR;

1238:
1239: exception
1240: WHEN FND_API.G_EXC_ERROR THEN
1241: ROLLBACK;
1242: x_return_status := FND_API.G_RET_STS_ERROR;
1243: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1244:
1245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1246: ROLLBACK;

Line 1243: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1239: exception
1240: WHEN FND_API.G_EXC_ERROR THEN
1241: ROLLBACK;
1242: x_return_status := FND_API.G_RET_STS_ERROR;
1243: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1244:
1245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1246: ROLLBACK;
1247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1241: ROLLBACK;
1242: x_return_status := FND_API.G_RET_STS_ERROR;
1243: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1244:
1245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1246: ROLLBACK;
1247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1248: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1249:

Line 1247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1243: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1244:
1245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1246: ROLLBACK;
1247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1248: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1249:
1250: WHEN OTHERS THEN
1251: ROLLBACK;

Line 1248: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1244:
1245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1246: ROLLBACK;
1247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1248: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1249:
1250: WHEN OTHERS THEN
1251: ROLLBACK;
1252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1248: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1249:
1250: WHEN OTHERS THEN
1251: ROLLBACK;
1252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1253: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1254: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1255: END IF;
1256: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

Line 1256: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1253: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1254: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1255: END IF;
1256: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1257:
1258: end process_amw_rcm_org;
1259:
1260: procedure process_amw_acct_assoc(

Line 1264: p_commit in varchar2 := FND_API.G_FALSE,

1260: procedure process_amw_acct_assoc(
1261: p_assoc_mode in varchar2 := 'ASSOCIATE',
1262: p_process_id in number,
1263: p_process_organization_id in number,
1264: p_commit in varchar2 := FND_API.G_FALSE,
1265: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1266: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1267: x_return_status out nocopy varchar2,
1268: x_msg_count out nocopy number,

Line 1265: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1261: p_assoc_mode in varchar2 := 'ASSOCIATE',
1262: p_process_id in number,
1263: p_process_organization_id in number,
1264: p_commit in varchar2 := FND_API.G_FALSE,
1265: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1266: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1267: x_return_status out nocopy varchar2,
1268: x_msg_count out nocopy number,
1269: x_msg_data out nocopy varchar2

Line 1266: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1262: p_process_id in number,
1263: p_process_organization_id in number,
1264: p_commit in varchar2 := FND_API.G_FALSE,
1265: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1266: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1267: x_return_status out nocopy varchar2,
1268: x_msg_count out nocopy number,
1269: x_msg_data out nocopy varchar2
1270: )

Line 1310: x_return_status := FND_API.G_RET_STS_SUCCESS;

1306:
1307: begin
1308: savepoint assoc_acct_pvt;
1309:
1310: x_return_status := FND_API.G_RET_STS_SUCCESS;
1311: -- Initialize message list if p_init_msg_list is set to TRUE.
1312: IF FND_API.to_Boolean( p_init_msg_list )
1313: THEN
1314: FND_MSG_PUB.initialize;

Line 1312: IF FND_API.to_Boolean( p_init_msg_list )

1308: savepoint assoc_acct_pvt;
1309:
1310: x_return_status := FND_API.G_RET_STS_SUCCESS;
1311: -- Initialize message list if p_init_msg_list is set to TRUE.
1312: IF FND_API.to_Boolean( p_init_msg_list )
1313: THEN
1314: FND_MSG_PUB.initialize;
1315: END IF;
1316:

Line 1324: RAISE FND_API.G_EXC_ERROR;

1320: -- =========================================================================
1321: IF FND_GLOBAL.User_Id IS NULL
1322: THEN
1323: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
1324: RAISE FND_API.G_EXC_ERROR;
1325: END IF;
1326:
1327: if p_assoc_mode = 'ASSOCIATE' then
1328: open c1;

Line 1372: ---IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1368: open c_id_exists(l_acct_assoc_ID);
1369: fetch c_id_exists into X_ROWID;
1370: close c_id_exists;
1371:
1372: ---IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1373: IF X_ROWID is null THEN
1374: RAISE FND_API.G_EXC_ERROR;
1375: END IF;
1376:

Line 1374: RAISE FND_API.G_EXC_ERROR;

1370: close c_id_exists;
1371:
1372: ---IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1373: IF X_ROWID is null THEN
1374: RAISE FND_API.G_EXC_ERROR;
1375: END IF;
1376:
1377: -- Standard check for p_commit
1378: IF FND_API.to_Boolean( p_commit )

Line 1378: IF FND_API.to_Boolean( p_commit )

1374: RAISE FND_API.G_EXC_ERROR;
1375: END IF;
1376:
1377: -- Standard check for p_commit
1378: IF FND_API.to_Boolean( p_commit )
1379: THEN
1380: COMMIT WORK;
1381: END IF;
1382: end if;

Line 1399: IF FND_API.to_Boolean( p_commit )

1395:
1396: ---------------------dbms_output.put_line('In amw_risk_associations: deleting');
1397:
1398: -- Standard check for p_commit
1399: IF FND_API.to_Boolean( p_commit )
1400: THEN
1401: COMMIT WORK;
1402: END IF;
1403:

Line 1404: x_return_status := FND_API.G_RET_STS_SUCCESS;

1400: THEN
1401: COMMIT WORK;
1402: END IF;
1403:
1404: x_return_status := FND_API.G_RET_STS_SUCCESS;
1405:
1406: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1407: RAISE FND_API.G_EXC_ERROR;
1408: END IF;

Line 1406: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1402: END IF;
1403:
1404: x_return_status := FND_API.G_RET_STS_SUCCESS;
1405:
1406: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1407: RAISE FND_API.G_EXC_ERROR;
1408: END IF;
1409: end loop;
1410: close c2;

Line 1407: RAISE FND_API.G_EXC_ERROR;

1403:
1404: x_return_status := FND_API.G_RET_STS_SUCCESS;
1405:
1406: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1407: RAISE FND_API.G_EXC_ERROR;
1408: END IF;
1409: end loop;
1410: close c2;
1411: end if;

Line 1425: WHEN FND_API.G_EXC_ERROR THEN

1421: p_data => x_msg_data
1422: );
1423:
1424: exception
1425: WHEN FND_API.G_EXC_ERROR THEN
1426: ROLLBACK TO assoc_acct_pvt;
1427: x_return_status := FND_API.G_RET_STS_ERROR;
1428: -- Standard call to get message count and if count=1, get the message
1429: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

Line 1427: x_return_status := FND_API.G_RET_STS_ERROR;

1423:
1424: exception
1425: WHEN FND_API.G_EXC_ERROR THEN
1426: ROLLBACK TO assoc_acct_pvt;
1427: x_return_status := FND_API.G_RET_STS_ERROR;
1428: -- Standard call to get message count and if count=1, get the message
1429: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1430:
1431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1429: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1425: WHEN FND_API.G_EXC_ERROR THEN
1426: ROLLBACK TO assoc_acct_pvt;
1427: x_return_status := FND_API.G_RET_STS_ERROR;
1428: -- Standard call to get message count and if count=1, get the message
1429: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1430:
1431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1432: ROLLBACK TO assoc_acct_pvt;
1433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1427: x_return_status := FND_API.G_RET_STS_ERROR;
1428: -- Standard call to get message count and if count=1, get the message
1429: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1430:
1431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1432: ROLLBACK TO assoc_acct_pvt;
1433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1434: -- Standard call to get message count and if count=1, get the message
1435: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

Line 1433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1429: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1430:
1431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1432: ROLLBACK TO assoc_acct_pvt;
1433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1434: -- Standard call to get message count and if count=1, get the message
1435: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1436:
1437: WHEN OTHERS THEN

Line 1435: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1432: ROLLBACK TO assoc_acct_pvt;
1433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1434: -- Standard call to get message count and if count=1, get the message
1435: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1436:
1437: WHEN OTHERS THEN
1438: ROLLBACK TO assoc_acct_pvt;
1439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1435: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1436:
1437: WHEN OTHERS THEN
1438: ROLLBACK TO assoc_acct_pvt;
1439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1440: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1441: THEN
1442: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1443: END IF;

Line 1445: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1441: THEN
1442: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1443: END IF;
1444: -- Standard call to get message count and if count=1, get the message
1445: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1446: end process_amw_acct_assoc;
1447:
1448: -- ==============================================================================
1449: -- Start of Comments

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

1459: -- IN
1460: -- p_assoc_mode IN VARCHAR2 Otional Default = 'ASSOCIATE'
1461: -- p_process_id IN number Required
1462: -- p_process_organization_id IN number Required
1463: -- p_commit IN VARCHAR2 Required Default = FND_API_G_FALSE
1464: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
1465: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
1466: -- OUT
1467: -- x_return_status OUT VARCHAR2

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

1460: -- p_assoc_mode IN VARCHAR2 Otional Default = 'ASSOCIATE'
1461: -- p_process_id IN number Required
1462: -- p_process_organization_id IN number Required
1463: -- p_commit IN VARCHAR2 Required Default = FND_API_G_FALSE
1464: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
1465: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
1466: -- OUT
1467: -- x_return_status OUT VARCHAR2
1468: -- x_msg_count OUT NUMBER

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

1461: -- p_process_id IN number Required
1462: -- p_process_organization_id IN number Required
1463: -- p_commit IN VARCHAR2 Required Default = FND_API_G_FALSE
1464: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
1465: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
1466: -- OUT
1467: -- x_return_status OUT VARCHAR2
1468: -- x_msg_count OUT NUMBER
1469: -- x_msg_data OUT VARCHAR2

Line 1481: p_commit in varchar2 := FND_API.G_FALSE,

1477: procedure process_amw_risk_assoc(
1478: p_assoc_mode in varchar2 := 'ASSOCIATE',
1479: p_process_id in number,
1480: p_process_organization_id in number,
1481: p_commit in varchar2 := FND_API.G_FALSE,
1482: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1483: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1484: x_return_status out nocopy varchar2,
1485: x_msg_count out nocopy number,

Line 1482: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1478: p_assoc_mode in varchar2 := 'ASSOCIATE',
1479: p_process_id in number,
1480: p_process_organization_id in number,
1481: p_commit in varchar2 := FND_API.G_FALSE,
1482: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1483: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1484: x_return_status out nocopy varchar2,
1485: x_msg_count out nocopy number,
1486: x_msg_data out nocopy varchar2

Line 1483: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1479: p_process_id in number,
1480: p_process_organization_id in number,
1481: p_commit in varchar2 := FND_API.G_FALSE,
1482: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1483: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1484: x_return_status out nocopy varchar2,
1485: x_msg_count out nocopy number,
1486: x_msg_data out nocopy varchar2
1487: )

Line 1522: x_return_status := FND_API.G_RET_STS_SUCCESS;

1518:
1519: begin
1520: savepoint assoc_risk_pvt;
1521:
1522: x_return_status := FND_API.G_RET_STS_SUCCESS;
1523: -- Initialize message list if p_init_msg_list is set to TRUE.
1524: IF FND_API.to_Boolean( p_init_msg_list )
1525: THEN
1526: FND_MSG_PUB.initialize;

Line 1524: IF FND_API.to_Boolean( p_init_msg_list )

1520: savepoint assoc_risk_pvt;
1521:
1522: x_return_status := FND_API.G_RET_STS_SUCCESS;
1523: -- Initialize message list if p_init_msg_list is set to TRUE.
1524: IF FND_API.to_Boolean( p_init_msg_list )
1525: THEN
1526: FND_MSG_PUB.initialize;
1527: END IF;
1528:

Line 1536: RAISE FND_API.G_EXC_ERROR;

1532: -- =========================================================================
1533: IF FND_GLOBAL.User_Id IS NULL
1534: THEN
1535: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
1536: RAISE FND_API.G_EXC_ERROR;
1537: END IF;
1538:
1539: if p_assoc_mode = 'ASSOCIATE' then
1540: open c1;

Line 1587: IF FND_API.to_Boolean( p_commit )

1583: ,l_ara_row.material,l_ara_row.material_value
1584: ---finished addition on 01/22/2004
1585: );
1586: -- Standard check for p_commit
1587: IF FND_API.to_Boolean( p_commit )
1588: THEN
1589: COMMIT WORK;
1590: END IF;
1591:

Line 1592: x_return_status := FND_API.G_RET_STS_SUCCESS;

1588: THEN
1589: COMMIT WORK;
1590: END IF;
1591:
1592: x_return_status := FND_API.G_RET_STS_SUCCESS;
1593:
1594: process_amw_control_assoc(
1595: p_assoc_mode => p_assoc_mode,
1596: p_risk_association_id => l_risk_association_id,

Line 1605: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1601: x_msg_count => x_msg_count,
1602: x_msg_data => x_msg_data
1603: );
1604:
1605: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1606: RAISE FND_API.G_EXC_ERROR;
1607: END IF;
1608: end if;
1609: end loop;

Line 1606: RAISE FND_API.G_EXC_ERROR;

1602: x_msg_data => x_msg_data
1603: );
1604:
1605: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1606: RAISE FND_API.G_EXC_ERROR;
1607: END IF;
1608: end if;
1609: end loop;
1610: close c1;

Line 1625: IF FND_API.to_Boolean( p_commit )

1621:
1622: ---------------------dbms_output.put_line('In amw_risk_associations: deleting');
1623:
1624: -- Standard check for p_commit
1625: IF FND_API.to_Boolean( p_commit )
1626: THEN
1627: COMMIT WORK;
1628: END IF;
1629:

Line 1630: x_return_status := FND_API.G_RET_STS_SUCCESS;

1626: THEN
1627: COMMIT WORK;
1628: END IF;
1629:
1630: x_return_status := FND_API.G_RET_STS_SUCCESS;
1631:
1632: process_amw_control_assoc(
1633: p_assoc_mode => p_assoc_mode,
1634: p_risk_association_id => l_update.risk_association_id,

Line 1643: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1639: x_msg_count => x_msg_count,
1640: x_msg_data => x_msg_data
1641: );
1642:
1643: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1644: RAISE FND_API.G_EXC_ERROR;
1645: END IF;
1646: end loop;
1647: close c2;

Line 1644: RAISE FND_API.G_EXC_ERROR;

1640: x_msg_data => x_msg_data
1641: );
1642:
1643: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1644: RAISE FND_API.G_EXC_ERROR;
1645: END IF;
1646: end loop;
1647: close c2;
1648: end if;

Line 1661: WHEN FND_API.G_EXC_ERROR THEN

1657: p_data => x_msg_data
1658: );
1659:
1660: exception
1661: WHEN FND_API.G_EXC_ERROR THEN
1662: ROLLBACK TO assoc_risk_pvt;
1663: x_return_status := FND_API.G_RET_STS_ERROR;
1664: -- Standard call to get message count and if count=1, get the message
1665: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

Line 1663: x_return_status := FND_API.G_RET_STS_ERROR;

1659:
1660: exception
1661: WHEN FND_API.G_EXC_ERROR THEN
1662: ROLLBACK TO assoc_risk_pvt;
1663: x_return_status := FND_API.G_RET_STS_ERROR;
1664: -- Standard call to get message count and if count=1, get the message
1665: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1666:
1667: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1665: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1661: WHEN FND_API.G_EXC_ERROR THEN
1662: ROLLBACK TO assoc_risk_pvt;
1663: x_return_status := FND_API.G_RET_STS_ERROR;
1664: -- Standard call to get message count and if count=1, get the message
1665: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1666:
1667: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1668: ROLLBACK TO assoc_risk_pvt;
1669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1667: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1663: x_return_status := FND_API.G_RET_STS_ERROR;
1664: -- Standard call to get message count and if count=1, get the message
1665: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1666:
1667: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1668: ROLLBACK TO assoc_risk_pvt;
1669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1670: -- Standard call to get message count and if count=1, get the message
1671: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

Line 1669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1665: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1666:
1667: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1668: ROLLBACK TO assoc_risk_pvt;
1669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1670: -- Standard call to get message count and if count=1, get the message
1671: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1672:
1673: WHEN OTHERS THEN

Line 1671: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1667: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1668: ROLLBACK TO assoc_risk_pvt;
1669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1670: -- Standard call to get message count and if count=1, get the message
1671: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1672:
1673: WHEN OTHERS THEN
1674: ROLLBACK TO assoc_risk_pvt;
1675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1671: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1672:
1673: WHEN OTHERS THEN
1674: ROLLBACK TO assoc_risk_pvt;
1675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1676: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1677: THEN
1678: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1679: END IF;

Line 1681: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1677: THEN
1678: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1679: END IF;
1680: -- Standard call to get message count and if count=1, get the message
1681: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1682: end process_amw_risk_assoc;
1683:
1684: -- ==============================================================================
1685: -- Start of Comments

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

1695: -- IN
1696: -- p_assoc_mode IN VARCHAR2 Otional Default = 'ASSOCIATE'
1697: -- p_risk_association_id IN number Required
1698: -- p_risk_id IN number Required
1699: -- p_commit IN VARCHAR2 Required Default = FND_API_G_FALSE
1700: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
1701: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
1702: -- OUT
1703: -- x_return_status OUT VARCHAR2

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

1696: -- p_assoc_mode IN VARCHAR2 Otional Default = 'ASSOCIATE'
1697: -- p_risk_association_id IN number Required
1698: -- p_risk_id IN number Required
1699: -- p_commit IN VARCHAR2 Required Default = FND_API_G_FALSE
1700: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
1701: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
1702: -- OUT
1703: -- x_return_status OUT VARCHAR2
1704: -- x_msg_count OUT NUMBER

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

1697: -- p_risk_association_id IN number Required
1698: -- p_risk_id IN number Required
1699: -- p_commit IN VARCHAR2 Required Default = FND_API_G_FALSE
1700: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
1701: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
1702: -- OUT
1703: -- x_return_status OUT VARCHAR2
1704: -- x_msg_count OUT NUMBER
1705: -- x_msg_data OUT VARCHAR2

Line 1717: p_commit in varchar2 := FND_API.G_FALSE,

1713: procedure process_amw_control_assoc(
1714: p_assoc_mode in varchar2 := 'ASSOCIATE',
1715: p_risk_association_id in number,
1716: p_risk_id in number,
1717: p_commit in varchar2 := FND_API.G_FALSE,
1718: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1719: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1720: x_return_status out nocopy varchar2,
1721: x_msg_count out nocopy number,

Line 1718: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1714: p_assoc_mode in varchar2 := 'ASSOCIATE',
1715: p_risk_association_id in number,
1716: p_risk_id in number,
1717: p_commit in varchar2 := FND_API.G_FALSE,
1718: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1719: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1720: x_return_status out nocopy varchar2,
1721: x_msg_count out nocopy number,
1722: x_msg_data out nocopy varchar2

Line 1719: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1715: p_risk_association_id in number,
1716: p_risk_id in number,
1717: p_commit in varchar2 := FND_API.G_FALSE,
1718: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1719: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1720: x_return_status out nocopy varchar2,
1721: x_msg_count out nocopy number,
1722: x_msg_data out nocopy varchar2
1723: )

Line 1754: x_return_status := FND_API.G_RET_STS_SUCCESS;

1750:
1751: begin
1752: savepoint assoc_control_pvt;
1753:
1754: x_return_status := FND_API.G_RET_STS_SUCCESS;
1755:
1756: -- Initialize message list if p_init_msg_list is set to TRUE.
1757: IF FND_API.to_Boolean( p_init_msg_list )
1758: THEN

Line 1757: IF FND_API.to_Boolean( p_init_msg_list )

1753:
1754: x_return_status := FND_API.G_RET_STS_SUCCESS;
1755:
1756: -- Initialize message list if p_init_msg_list is set to TRUE.
1757: IF FND_API.to_Boolean( p_init_msg_list )
1758: THEN
1759: FND_MSG_PUB.initialize;
1760: END IF;
1761:

Line 1768: RAISE FND_API.G_EXC_ERROR;

1764: -- =========================================================================
1765: IF FND_GLOBAL.User_Id IS NULL
1766: THEN
1767: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
1768: RAISE FND_API.G_EXC_ERROR;
1769: END IF;
1770:
1771: if p_assoc_mode = 'ASSOCIATE' then
1772: open c1;

Line 1804: IF FND_API.to_Boolean( p_commit )

1800: l_aca_row.attribute13,l_aca_row.attribute14,l_aca_row.attribute15,
1801: l_aca_row.security_group_id,1,
1802: l_aca_row.effective_date_from,l_aca_row.effective_date_to);
1803: -- Standard check for p_commit
1804: IF FND_API.to_Boolean( p_commit )
1805: THEN
1806: COMMIT WORK;
1807: END IF;
1808:

Line 1809: x_return_status := FND_API.G_RET_STS_SUCCESS;

1805: THEN
1806: COMMIT WORK;
1807: END IF;
1808:
1809: x_return_status := FND_API.G_RET_STS_SUCCESS;
1810:
1811: ----------------dbms_output.put_line('GOING TO INSERT_IN_AMW_AP_ASSOC: '|| l_control_association_id);
1812:
1813: process_amw_ap_assoc(

Line 1824: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1820: x_msg_count => x_msg_count,
1821: x_msg_data => x_msg_data
1822: );
1823:
1824: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1825: RAISE FND_API.G_EXC_ERROR;
1826: END IF;
1827: end if;
1828: end loop;

Line 1825: RAISE FND_API.G_EXC_ERROR;

1821: x_msg_data => x_msg_data
1822: );
1823:
1824: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1825: RAISE FND_API.G_EXC_ERROR;
1826: END IF;
1827: end if;
1828: end loop;
1829: close c1;

Line 1837: x_return_status := FND_API.G_RET_STS_SUCCESS;

1833: fetch c2 into l_update;
1834: exit when c2%notfound;
1835:
1836:
1837: x_return_status := FND_API.G_RET_STS_SUCCESS;
1838:
1839: process_amw_ap_assoc(
1840: p_assoc_mode => p_assoc_mode,
1841: p_control_association_id => l_update.control_association_id,

Line 1855: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1851: and object_type='RISK_ORG'
1852: and pk1=p_risk_association_id;
1853:
1854:
1855: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1856: RAISE FND_API.G_EXC_ERROR;
1857: END IF;
1858: -- Standard check for p_commit
1859: IF FND_API.to_Boolean( p_commit )

Line 1856: RAISE FND_API.G_EXC_ERROR;

1852: and pk1=p_risk_association_id;
1853:
1854:
1855: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1856: RAISE FND_API.G_EXC_ERROR;
1857: END IF;
1858: -- Standard check for p_commit
1859: IF FND_API.to_Boolean( p_commit )
1860: THEN

Line 1859: IF FND_API.to_Boolean( p_commit )

1855: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1856: RAISE FND_API.G_EXC_ERROR;
1857: END IF;
1858: -- Standard check for p_commit
1859: IF FND_API.to_Boolean( p_commit )
1860: THEN
1861: COMMIT WORK;
1862: END IF;
1863: end loop;

Line 1878: WHEN FND_API.G_EXC_ERROR THEN

1874: p_data => x_msg_data
1875: );
1876:
1877: exception
1878: WHEN FND_API.G_EXC_ERROR THEN
1879: ROLLBACK TO assoc_control_pvt;
1880: x_return_status := FND_API.G_RET_STS_ERROR;
1881: -- Standard call to get message count and if count=1, get the message
1882: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

Line 1880: x_return_status := FND_API.G_RET_STS_ERROR;

1876:
1877: exception
1878: WHEN FND_API.G_EXC_ERROR THEN
1879: ROLLBACK TO assoc_control_pvt;
1880: x_return_status := FND_API.G_RET_STS_ERROR;
1881: -- Standard call to get message count and if count=1, get the message
1882: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1883:
1884: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1882: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1878: WHEN FND_API.G_EXC_ERROR THEN
1879: ROLLBACK TO assoc_control_pvt;
1880: x_return_status := FND_API.G_RET_STS_ERROR;
1881: -- Standard call to get message count and if count=1, get the message
1882: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1883:
1884: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1885: ROLLBACK TO assoc_control_pvt;
1886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1884: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1880: x_return_status := FND_API.G_RET_STS_ERROR;
1881: -- Standard call to get message count and if count=1, get the message
1882: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1883:
1884: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1885: ROLLBACK TO assoc_control_pvt;
1886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1887: -- Standard call to get message count and if count=1, get the message
1888: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

Line 1886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1882: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1883:
1884: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1885: ROLLBACK TO assoc_control_pvt;
1886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1887: -- Standard call to get message count and if count=1, get the message
1888: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1889:
1890: WHEN OTHERS THEN

Line 1888: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1884: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1885: ROLLBACK TO assoc_control_pvt;
1886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1887: -- Standard call to get message count and if count=1, get the message
1888: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1889:
1890: WHEN OTHERS THEN
1891: ROLLBACK TO assoc_control_pvt;
1892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1888: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1889:
1890: WHEN OTHERS THEN
1891: ROLLBACK TO assoc_control_pvt;
1892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1893: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1894: THEN
1895: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1896: END IF;

Line 1898: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1894: THEN
1895: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1896: END IF;
1897: -- Standard call to get message count and if count=1, get the message
1898: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1899: end process_amw_control_assoc;
1900:
1901: -- ==============================================================================
1902: -- Start of Comments

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

1912: -- IN
1913: -- p_assoc_mode IN VARCHAR2 Otional Default = 'ASSOCIATE'
1914: -- p_control_association_id IN number Required
1915: -- p_control_id IN number Required
1916: -- p_commit IN VARCHAR2 Required Default = FND_API_G_FALSE
1917: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
1918: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
1919: -- OUT
1920: -- x_return_status OUT VARCHAR2

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

1913: -- p_assoc_mode IN VARCHAR2 Otional Default = 'ASSOCIATE'
1914: -- p_control_association_id IN number Required
1915: -- p_control_id IN number Required
1916: -- p_commit IN VARCHAR2 Required Default = FND_API_G_FALSE
1917: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
1918: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
1919: -- OUT
1920: -- x_return_status OUT VARCHAR2
1921: -- x_msg_count OUT NUMBER

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

1914: -- p_control_association_id IN number Required
1915: -- p_control_id IN number Required
1916: -- p_commit IN VARCHAR2 Required Default = FND_API_G_FALSE
1917: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
1918: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
1919: -- OUT
1920: -- x_return_status OUT VARCHAR2
1921: -- x_msg_count OUT NUMBER
1922: -- x_msg_data OUT VARCHAR2

Line 1934: p_commit in varchar2 := FND_API.G_FALSE,

1930: procedure process_amw_ap_assoc(
1931: p_assoc_mode in varchar2 := 'ASSOCIATE',
1932: p_control_association_id in number,
1933: p_control_id in number,
1934: p_commit in varchar2 := FND_API.G_FALSE,
1935: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1936: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1937: x_return_status out nocopy varchar2,
1938: x_msg_count out nocopy number,

Line 1935: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1931: p_assoc_mode in varchar2 := 'ASSOCIATE',
1932: p_control_association_id in number,
1933: p_control_id in number,
1934: p_commit in varchar2 := FND_API.G_FALSE,
1935: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1936: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1937: x_return_status out nocopy varchar2,
1938: x_msg_count out nocopy number,
1939: x_msg_data out nocopy varchar2

Line 1936: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1932: p_control_association_id in number,
1933: p_control_id in number,
1934: p_commit in varchar2 := FND_API.G_FALSE,
1935: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1936: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1937: x_return_status out nocopy varchar2,
1938: x_msg_count out nocopy number,
1939: x_msg_data out nocopy varchar2
1940: )

Line 1988: IF FND_API.to_Boolean( p_init_msg_list )

1984: begin
1985: savepoint assoc_ap_pvt;
1986:
1987: -- Initialize message list if p_init_msg_list is set to TRUE.
1988: IF FND_API.to_Boolean( p_init_msg_list )
1989: THEN
1990: FND_MSG_PUB.initialize;
1991: END IF;
1992:

Line 1999: RAISE FND_API.G_EXC_ERROR;

1995: -- =========================================================================
1996: IF FND_GLOBAL.User_Id IS NULL
1997: THEN
1998: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
1999: RAISE FND_API.G_EXC_ERROR;
2000: END IF;
2001:
2002: x_return_status := FND_API.G_RET_STS_SUCCESS;
2003:

Line 2002: x_return_status := FND_API.G_RET_STS_SUCCESS;

1998: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
1999: RAISE FND_API.G_EXC_ERROR;
2000: END IF;
2001:
2002: x_return_status := FND_API.G_RET_STS_SUCCESS;
2003:
2004:
2005: if p_assoc_mode = 'ASSOCIATE' then
2006: open c1;

Line 2059: IF FND_API.to_Boolean( p_commit )

2055: l_aaa_row.attribute15,l_aaa_row.security_group_id,1,
2056: l_aaa_row.design_effectiveness,l_aaa_row.op_effectiveness);
2057:
2058: -- Standard check for p_commit
2059: IF FND_API.to_Boolean( p_commit )
2060: THEN
2061: COMMIT WORK;
2062: END IF;
2063: end if;

Line 2079: IF FND_API.to_Boolean( p_commit )

2075: -- and object_type='CTRL_ORG' ;
2076: -- and pk1=p_control_association_id;
2077:
2078: -- Standard check for p_commit
2079: IF FND_API.to_Boolean( p_commit )
2080: THEN
2081: COMMIT WORK;
2082: END IF;
2083:

Line 2099: WHEN FND_API.G_EXC_ERROR THEN

2095: p_data => x_msg_data
2096: );
2097:
2098: exception
2099: WHEN FND_API.G_EXC_ERROR THEN
2100: ROLLBACK TO assoc_ap_pvt;
2101: x_return_status := FND_API.G_RET_STS_ERROR;
2102: -- Standard call to get message count and if count=1, get the message
2103: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

Line 2101: x_return_status := FND_API.G_RET_STS_ERROR;

2097:
2098: exception
2099: WHEN FND_API.G_EXC_ERROR THEN
2100: ROLLBACK TO assoc_ap_pvt;
2101: x_return_status := FND_API.G_RET_STS_ERROR;
2102: -- Standard call to get message count and if count=1, get the message
2103: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2104:
2105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2103: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

2099: WHEN FND_API.G_EXC_ERROR THEN
2100: ROLLBACK TO assoc_ap_pvt;
2101: x_return_status := FND_API.G_RET_STS_ERROR;
2102: -- Standard call to get message count and if count=1, get the message
2103: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2104:
2105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2106: ROLLBACK TO assoc_ap_pvt;
2107: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2101: x_return_status := FND_API.G_RET_STS_ERROR;
2102: -- Standard call to get message count and if count=1, get the message
2103: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2104:
2105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2106: ROLLBACK TO assoc_ap_pvt;
2107: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2108: -- Standard call to get message count and if count=1, get the message
2109: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

Line 2107: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2103: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2104:
2105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2106: ROLLBACK TO assoc_ap_pvt;
2107: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2108: -- Standard call to get message count and if count=1, get the message
2109: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2110:
2111: WHEN OTHERS THEN

Line 2109: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

2105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2106: ROLLBACK TO assoc_ap_pvt;
2107: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2108: -- Standard call to get message count and if count=1, get the message
2109: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2110:
2111: WHEN OTHERS THEN
2112: ROLLBACK TO assoc_ap_pvt;
2113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2109: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2110:
2111: WHEN OTHERS THEN
2112: ROLLBACK TO assoc_ap_pvt;
2113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2114: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2115: THEN
2116: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
2117: END IF;

Line 2119: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

2115: THEN
2116: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
2117: END IF;
2118: -- Standard call to get message count and if count=1, get the message
2119: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2120: end process_amw_ap_assoc;
2121:
2122: -- ==============================================================================
2123: -- Start of Comments

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

2134: -- p_process_id IN NUMBER Optional Default = null
2135: -- p_organization_id IN NUMBER Optional Default = null
2136: -- p_mode IN VARCHAR2 Required Default = 'ASSOCIATE'
2137: -- p_apo_type IN apo_type Optional Default = null
2138: -- p_commit IN VARCHAR2 Required Default = FND_API_G_FALSE
2139: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
2140: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
2141: --
2142: -- OUT

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

2135: -- p_organization_id IN NUMBER Optional Default = null
2136: -- p_mode IN VARCHAR2 Required Default = 'ASSOCIATE'
2137: -- p_apo_type IN apo_type Optional Default = null
2138: -- p_commit IN VARCHAR2 Required Default = FND_API_G_FALSE
2139: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
2140: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
2141: --
2142: -- OUT
2143: -- x_return_status OUT VARCHAR2

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

2136: -- p_mode IN VARCHAR2 Required Default = 'ASSOCIATE'
2137: -- p_apo_type IN apo_type Optional Default = null
2138: -- p_commit IN VARCHAR2 Required Default = FND_API_G_FALSE
2139: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
2140: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
2141: --
2142: -- OUT
2143: -- x_return_status OUT VARCHAR2
2144: -- x_msg_count OUT NUMBER

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

2155: p_organization_id IN NUMBER := NULL,
2156: p_risk_count in number := null,
2157: p_control_count in number := null,
2158: p_mode IN VARCHAR2 := 'ASSOCIATE',
2159: p_commit IN VARCHAR2 := fnd_api.g_false,
2160: x_return_status OUT NOCOPY VARCHAR2,
2161: x_msg_count OUT NOCOPY NUMBER,
2162: x_msg_data OUT NOCOPY VARCHAR2
2163: ) IS

Line 2210: x_return_status := fnd_api.g_ret_sts_success;

2206: -----to all the control_counts of upward processes
2207: BEGIN
2208: ---Inserting process_id
2209: SAVEPOINT process_hierarchy_count;
2210: x_return_status := fnd_api.g_ret_sts_success;
2211: -- Standard call to check for call compatibility.
2212:
2213: -- Debug Message
2214: amw_utility_pvt.debug_message ('Private API: ' || l_api_name || ' start');

Line 2217: x_return_status := fnd_api.g_ret_sts_success;

2213: -- Debug Message
2214: amw_utility_pvt.debug_message ('Private API: ' || l_api_name || ' start');
2215:
2216: -- Initialize API return status to SUCCESS
2217: x_return_status := fnd_api.g_ret_sts_success;
2218:
2219: /* Temporarily commenting out the validata session code ..... */
2220: -- =========================================================================
2221: -- Validate Environment

Line 2225: RAISE fnd_api.g_exc_error;

2221: -- Validate Environment
2222: -- =========================================================================
2223: IF fnd_global.user_id IS NULL THEN
2224: amw_utility_pvt.error_message(p_message_name => 'USER_PROFILE_MISSING');
2225: RAISE fnd_api.g_exc_error;
2226: END IF;
2227:
2228: amw_wf_hierarchy_pkg.reset_proc_org_risk_ctrl_count;
2229:

Line 2273: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2269: -- End Validate Environment
2270: -- =========================================================================
2271: -- End commenting the session validation code ....
2272: */
2273: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2274: RAISE fnd_api.g_exc_error;
2275: END IF;
2276:
2277: -- Standard check for p_commit

Line 2274: RAISE fnd_api.g_exc_error;

2270: -- =========================================================================
2271: -- End commenting the session validation code ....
2272: */
2273: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2274: RAISE fnd_api.g_exc_error;
2275: END IF;
2276:
2277: -- Standard check for p_commit
2278: IF fnd_api.to_boolean (p_commit) THEN

Line 2278: IF fnd_api.to_boolean (p_commit) THEN

2274: RAISE fnd_api.g_exc_error;
2275: END IF;
2276:
2277: -- Standard check for p_commit
2278: IF fnd_api.to_boolean (p_commit) THEN
2279: COMMIT WORK;
2280: END IF;
2281:
2282: --Debug Message

Line 2289: WHEN fnd_api.g_exc_error THEN

2285: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2286: p_data => x_msg_data);
2287:
2288: EXCEPTION
2289: WHEN fnd_api.g_exc_error THEN
2290: ROLLBACK TO process_hierarchy_count;
2291: x_return_status := fnd_api.g_ret_sts_error;
2292: -- Standard call to get message count and if count=1, get the message
2293: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,

Line 2291: x_return_status := fnd_api.g_ret_sts_error;

2287:
2288: EXCEPTION
2289: WHEN fnd_api.g_exc_error THEN
2290: ROLLBACK TO process_hierarchy_count;
2291: x_return_status := fnd_api.g_ret_sts_error;
2292: -- Standard call to get message count and if count=1, get the message
2293: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
2294: p_count => x_msg_count,
2295: p_data => x_msg_data

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

2289: WHEN fnd_api.g_exc_error THEN
2290: ROLLBACK TO process_hierarchy_count;
2291: x_return_status := fnd_api.g_ret_sts_error;
2292: -- Standard call to get message count and if count=1, get the message
2293: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
2294: p_count => x_msg_count,
2295: p_data => x_msg_data
2296: );
2297: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2297: WHEN fnd_api.g_exc_unexpected_error THEN

2293: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
2294: p_count => x_msg_count,
2295: p_data => x_msg_data
2296: );
2297: WHEN fnd_api.g_exc_unexpected_error THEN
2298: ROLLBACK TO process_hierarchy_count;
2299: x_return_status := fnd_api.g_ret_sts_unexp_error;
2300: -- Standard call to get message count and if count=1, get the message
2301: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,

Line 2299: x_return_status := fnd_api.g_ret_sts_unexp_error;

2295: p_data => x_msg_data
2296: );
2297: WHEN fnd_api.g_exc_unexpected_error THEN
2298: ROLLBACK TO process_hierarchy_count;
2299: x_return_status := fnd_api.g_ret_sts_unexp_error;
2300: -- Standard call to get message count and if count=1, get the message
2301: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
2302: p_count => x_msg_count,
2303: p_data => x_msg_data

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

2297: WHEN fnd_api.g_exc_unexpected_error THEN
2298: ROLLBACK TO process_hierarchy_count;
2299: x_return_status := fnd_api.g_ret_sts_unexp_error;
2300: -- Standard call to get message count and if count=1, get the message
2301: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
2302: p_count => x_msg_count,
2303: p_data => x_msg_data
2304: );
2305: WHEN OTHERS THEN

Line 2307: x_return_status := fnd_api.g_ret_sts_unexp_error;

2303: p_data => x_msg_data
2304: );
2305: WHEN OTHERS THEN
2306: ROLLBACK TO process_hierarchy_count;
2307: x_return_status := fnd_api.g_ret_sts_unexp_error;
2308: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2309: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2310: END IF;
2311: -- Standard call to get message count and if count=1, get the message

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

2308: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2309: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2310: END IF;
2311: -- Standard call to get message count and if count=1, get the message
2312: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
2313: p_count => x_msg_count,
2314: p_data => x_msg_data
2315: );
2316: END process_hierarchy_count;

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

2327: -- Parameters
2328: --
2329: -- IN
2330: -- p_api_version_number IN NUMBER REQUIRED
2331: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
2332: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
2333: -- p_apo_type IN apo_type Required
2334: --
2335: -- OUT

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

2328: --
2329: -- IN
2330: -- p_api_version_number IN NUMBER REQUIRED
2331: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
2332: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
2333: -- p_apo_type IN apo_type Required
2334: --
2335: -- OUT
2336: -- x_return_status OUT VARCHAR2

Line 2348: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2344: --
2345:
2346: PROCEDURE validate_apo_type(
2347: p_api_version_number IN NUMBER,
2348: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2349: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2350: p_apo_type IN apo_type,
2351: x_return_status OUT nocopy VARCHAR2,
2352: x_msg_count OUT nocopy NUMBER,

Line 2349: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2345:
2346: PROCEDURE validate_apo_type(
2347: p_api_version_number IN NUMBER,
2348: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2349: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2350: p_apo_type IN apo_type,
2351: x_return_status OUT nocopy VARCHAR2,
2352: x_msg_count OUT nocopy NUMBER,
2353: x_msg_data OUT nocopy VARCHAR2

Line 2366: IF NOT FND_API.Compatible_API_Call(l_api_version_number,p_api_version_number,l_api_name,G_PKG_NAME)

2362: -- Standard Start of API savepoint
2363: SAVEPOINT validate_process_pvt;
2364:
2365: -- Standard call to check for call compatibility.
2366: IF NOT FND_API.Compatible_API_Call(l_api_version_number,p_api_version_number,l_api_name,G_PKG_NAME)
2367: THEN
2368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2369: END IF;
2370:

Line 2368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2364:
2365: -- Standard call to check for call compatibility.
2366: IF NOT FND_API.Compatible_API_Call(l_api_version_number,p_api_version_number,l_api_name,G_PKG_NAME)
2367: THEN
2368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2369: END IF;
2370:
2371: -- Initialize message list if p_init_msg_list is set to TRUE.
2372: IF FND_API.to_Boolean( p_init_msg_list )

Line 2372: IF FND_API.to_Boolean( p_init_msg_list )

2368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2369: END IF;
2370:
2371: -- Initialize message list if p_init_msg_list is set to TRUE.
2372: IF FND_API.to_Boolean( p_init_msg_list )
2373: THEN
2374: FND_MSG_PUB.initialize;
2375: END IF;
2376:

Line 2384: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2380: p_validation_mode => JTF_PLSQL_API.g_update,
2381: x_return_status => x_return_status
2382: );
2383:
2384: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2385: RAISE FND_API.G_EXC_ERROR;
2386: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2388: END IF;

Line 2385: RAISE FND_API.G_EXC_ERROR;

2381: x_return_status => x_return_status
2382: );
2383:
2384: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2385: RAISE FND_API.G_EXC_ERROR;
2386: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2388: END IF;
2389: END IF;

Line 2386: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2382: );
2383:
2384: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2385: RAISE FND_API.G_EXC_ERROR;
2386: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2388: END IF;
2389: END IF;
2390:

Line 2387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2383:
2384: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2385: RAISE FND_API.G_EXC_ERROR;
2386: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2388: END IF;
2389: END IF;
2390:
2391: -- Debug Message

Line 2395: x_return_status := FND_API.G_RET_STS_SUCCESS;

2391: -- Debug Message
2392: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
2393:
2394: -- Initialize API return status to SUCCESS
2395: x_return_status := FND_API.G_RET_STS_SUCCESS;
2396:
2397: -- Debug Message
2398: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2399:

Line 2408: x_return_status := FND_API.g_ret_sts_error;

2404: );
2405: EXCEPTION
2406:
2407: WHEN AMW_Utility_PVT.resource_locked THEN
2408: x_return_status := FND_API.g_ret_sts_error;
2409: AMW_Utility_PVT.Error_Message(p_message_name => 'AMW_API_RESOURCE_LOCKED');
2410:
2411: WHEN FND_API.G_EXC_ERROR THEN
2412: ROLLBACK TO VALIDATE_Process_pvt;

Line 2411: WHEN FND_API.G_EXC_ERROR THEN

2407: WHEN AMW_Utility_PVT.resource_locked THEN
2408: x_return_status := FND_API.g_ret_sts_error;
2409: AMW_Utility_PVT.Error_Message(p_message_name => 'AMW_API_RESOURCE_LOCKED');
2410:
2411: WHEN FND_API.G_EXC_ERROR THEN
2412: ROLLBACK TO VALIDATE_Process_pvt;
2413: x_return_status := FND_API.G_RET_STS_ERROR;
2414: -- Standard call to get message count and if count=1, get the message
2415: FND_MSG_PUB.Count_And_Get (

Line 2413: x_return_status := FND_API.G_RET_STS_ERROR;

2409: AMW_Utility_PVT.Error_Message(p_message_name => 'AMW_API_RESOURCE_LOCKED');
2410:
2411: WHEN FND_API.G_EXC_ERROR THEN
2412: ROLLBACK TO VALIDATE_Process_pvt;
2413: x_return_status := FND_API.G_RET_STS_ERROR;
2414: -- Standard call to get message count and if count=1, get the message
2415: FND_MSG_PUB.Count_And_Get (
2416: p_encoded => FND_API.G_FALSE,
2417: p_count => x_msg_count,

Line 2416: p_encoded => FND_API.G_FALSE,

2412: ROLLBACK TO VALIDATE_Process_pvt;
2413: x_return_status := FND_API.G_RET_STS_ERROR;
2414: -- Standard call to get message count and if count=1, get the message
2415: FND_MSG_PUB.Count_And_Get (
2416: p_encoded => FND_API.G_FALSE,
2417: p_count => x_msg_count,
2418: p_data => x_msg_data
2419: );
2420:

Line 2421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2417: p_count => x_msg_count,
2418: p_data => x_msg_data
2419: );
2420:
2421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2422: ROLLBACK TO VALIDATE_Process_pvt;
2423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2424: -- Standard call to get message count and if count=1, get the message
2425: FND_MSG_PUB.Count_And_Get (

Line 2423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2419: );
2420:
2421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2422: ROLLBACK TO VALIDATE_Process_pvt;
2423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2424: -- Standard call to get message count and if count=1, get the message
2425: FND_MSG_PUB.Count_And_Get (
2426: p_encoded => FND_API.G_FALSE,
2427: p_count => x_msg_count,

Line 2426: p_encoded => FND_API.G_FALSE,

2422: ROLLBACK TO VALIDATE_Process_pvt;
2423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2424: -- Standard call to get message count and if count=1, get the message
2425: FND_MSG_PUB.Count_And_Get (
2426: p_encoded => FND_API.G_FALSE,
2427: p_count => x_msg_count,
2428: p_data => x_msg_data
2429: );
2430:

Line 2433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2429: );
2430:
2431: WHEN OTHERS THEN
2432: ROLLBACK TO VALIDATE_Process_pvt;
2433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2434: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2435: THEN
2436: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2437: END IF;

Line 2440: p_encoded => FND_API.G_FALSE,

2436: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2437: END IF;
2438: -- Standard call to get message count and if count=1, get the message
2439: FND_MSG_PUB.Count_And_Get (
2440: p_encoded => FND_API.G_FALSE,
2441: p_count => x_msg_count,
2442: p_data => x_msg_data
2443: );
2444: End validate_apo_type;

Line 2478: x_return_status := FND_API.g_ret_sts_success;

2474: )
2475: IS
2476:
2477: BEGIN
2478: x_return_status := FND_API.g_ret_sts_success;
2479:
2480: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
2481: IF p_apo_type.organization_id = FND_API.g_miss_num OR p_apo_type.organization_id IS NULL THEN
2482: AMW_Utility_PVT.Error_Message(p_message_name => 'AMW_process_organization_NO_organization_id');

Line 2481: IF p_apo_type.organization_id = FND_API.g_miss_num OR p_apo_type.organization_id IS NULL THEN

2477: BEGIN
2478: x_return_status := FND_API.g_ret_sts_success;
2479:
2480: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
2481: IF p_apo_type.organization_id = FND_API.g_miss_num OR p_apo_type.organization_id IS NULL THEN
2482: AMW_Utility_PVT.Error_Message(p_message_name => 'AMW_process_organization_NO_organization_id');
2483: x_return_status := FND_API.g_ret_sts_error;
2484: RETURN;
2485: END IF;

Line 2483: x_return_status := FND_API.g_ret_sts_error;

2479:
2480: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
2481: IF p_apo_type.organization_id = FND_API.g_miss_num OR p_apo_type.organization_id IS NULL THEN
2482: AMW_Utility_PVT.Error_Message(p_message_name => 'AMW_process_organization_NO_organization_id');
2483: x_return_status := FND_API.g_ret_sts_error;
2484: RETURN;
2485: END IF;
2486:
2487: IF p_apo_type.process_id = FND_API.g_miss_num OR p_apo_type.process_id IS NULL THEN

Line 2487: IF p_apo_type.process_id = FND_API.g_miss_num OR p_apo_type.process_id IS NULL THEN

2483: x_return_status := FND_API.g_ret_sts_error;
2484: RETURN;
2485: END IF;
2486:
2487: IF p_apo_type.process_id = FND_API.g_miss_num OR p_apo_type.process_id IS NULL THEN
2488: AMW_Utility_PVT.Error_Message(p_message_name => 'AMW_process_NO_process_id');
2489: x_return_status := FND_API.g_ret_sts_error;
2490: RETURN;
2491: END IF;

Line 2489: x_return_status := FND_API.g_ret_sts_error;

2485: END IF;
2486:
2487: IF p_apo_type.process_id = FND_API.g_miss_num OR p_apo_type.process_id IS NULL THEN
2488: AMW_Utility_PVT.Error_Message(p_message_name => 'AMW_process_NO_process_id');
2489: x_return_status := FND_API.g_ret_sts_error;
2490: RETURN;
2491: END IF;
2492: END IF;
2493: END check_apo_row;

Line 2519: ----raise FND_API.G_EXC_ERROR;

2515: loop
2516: fetch c1 into l_ppid;
2517: exit when c1%notfound;
2518: ---dbms_output.put_line('l_ppid.parent_process_id: '||
2519: ----raise FND_API.G_EXC_ERROR;
2520: if(l_ppid.end_date is null)then
2521: l_rpid := l_ppid.parent_process_id;
2522: exit;
2523: end if;

Line 2538: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2534: exception
2535:
2536: WHEN OTHERS THEN
2537: -- ROLLBACK TO assoc_ap_pvt;
2538: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2539: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2540: THEN
2541: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
2542: END IF;

Line 2546: -- FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

2542: END IF;
2543: ----dbms_output.put_line('EXCEPTION');
2544: RAISE;
2545: -- Standard call to get message count and if count=1, get the message
2546: -- FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2547: /*
2548: when no_data_found then
2549: return null;
2550: when others then