eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMW_RISK_TYPE_PVT dependencies on FND_API

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

25: -- IN
26: -- p_riskrev_id IN NUMBER Optional Default = null
27: -- p_risk_type_code IN VARCHAR2 Required
28: -- p_select_flag IN VARCHAR2 Required
29: -- p_commit IN VARCHAR2 Required Default = FND_API_G_FALSE
30: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
31: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
32: --
33: -- OUT

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

26: -- p_riskrev_id IN NUMBER Optional Default = null
27: -- p_risk_type_code IN VARCHAR2 Required
28: -- p_select_flag IN VARCHAR2 Required
29: -- p_commit IN VARCHAR2 Required Default = FND_API_G_FALSE
30: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
31: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
32: --
33: -- OUT
34: -- x_return_status OUT VARCHAR2

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

27: -- p_risk_type_code IN VARCHAR2 Required
28: -- p_select_flag IN VARCHAR2 Required
29: -- p_commit IN VARCHAR2 Required Default = FND_API_G_FALSE
30: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
31: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
32: --
33: -- OUT
34: -- x_return_status OUT VARCHAR2
35: -- x_msg_count OUT NUMBER

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

43: PROCEDURE insert_delete_risk_type (
44: p_risk_rev_id IN NUMBER := NULL,
45: p_risk_type_code IN VARCHAR2 := NULL,
46: p_select_flag IN VARCHAR2 := NULL,
47: p_commit IN VARCHAR2 := fnd_api.g_false,
48: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
49: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
50: p_api_version_number IN NUMBER,
51: x_return_status OUT NOCOPY VARCHAR2,

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

44: p_risk_rev_id IN NUMBER := NULL,
45: p_risk_type_code IN VARCHAR2 := NULL,
46: p_select_flag IN VARCHAR2 := NULL,
47: p_commit IN VARCHAR2 := fnd_api.g_false,
48: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
49: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
50: p_api_version_number IN NUMBER,
51: x_return_status OUT NOCOPY VARCHAR2,
52: x_msg_count OUT NOCOPY NUMBER,

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

45: p_risk_type_code IN VARCHAR2 := NULL,
46: p_select_flag IN VARCHAR2 := NULL,
47: p_commit IN VARCHAR2 := fnd_api.g_false,
48: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
49: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
50: p_api_version_number IN NUMBER,
51: x_return_status OUT NOCOPY VARCHAR2,
52: x_msg_count OUT NOCOPY NUMBER,
53: x_msg_data OUT NOCOPY VARCHAR2

Line 77: x_return_status := fnd_api.g_ret_sts_success;

73:
74: BEGIN
75:
76: SAVEPOINT amw_risk_type_pvt;
77: x_return_status := fnd_api.g_ret_sts_success;
78: -- Standard call to check for call compatibility.
79: IF NOT fnd_api.compatible_api_call (l_api_version_number,
80: p_api_version_number,
81: l_api_name,

Line 79: IF NOT fnd_api.compatible_api_call (l_api_version_number,

75:
76: SAVEPOINT amw_risk_type_pvt;
77: x_return_status := fnd_api.g_ret_sts_success;
78: -- Standard call to check for call compatibility.
79: IF NOT fnd_api.compatible_api_call (l_api_version_number,
80: p_api_version_number,
81: l_api_name,
82: g_pkg_name
83: ) THEN

Line 84: RAISE fnd_api.g_exc_unexpected_error;

80: p_api_version_number,
81: l_api_name,
82: g_pkg_name
83: ) THEN
84: RAISE fnd_api.g_exc_unexpected_error;
85: END IF;
86: -- Initialize message list if p_init_msg_list is set to TRUE.
87: IF fnd_api.to_boolean (p_init_msg_list) THEN
88: fnd_msg_pub.initialize;

Line 87: IF fnd_api.to_boolean (p_init_msg_list) THEN

83: ) THEN
84: RAISE fnd_api.g_exc_unexpected_error;
85: END IF;
86: -- Initialize message list if p_init_msg_list is set to TRUE.
87: IF fnd_api.to_boolean (p_init_msg_list) THEN
88: fnd_msg_pub.initialize;
89: END IF;
90: -- Debug Message
91: amw_utility_pvt.debug_message ('Private API: ' || l_api_name || 'start');

Line 93: x_return_status := fnd_api.g_ret_sts_success;

89: END IF;
90: -- Debug Message
91: amw_utility_pvt.debug_message ('Private API: ' || l_api_name || 'start');
92: -- Initialize API return status to SUCCESS
93: x_return_status := fnd_api.g_ret_sts_success;
94: /* Temporarily commenting out the validata session code ..... */
95: -- =========================================================================
96: -- Validate Environment
97: -- =========================================================================

Line 101: RAISE fnd_api.g_exc_error;

97: -- =========================================================================
98: IF fnd_global.user_id IS NULL THEN
99: amw_utility_pvt.error_message
100: (p_message_name => 'USER_PROFILE_MISSING');
101: RAISE fnd_api.g_exc_error;
102: END IF;
103:
104:
105: IF (p_select_flag = 'N') then

Line 156: IF x_return_status <> fnd_api.g_ret_sts_success THEN

152: -- =========================================================================
153: -- End Validate Environment
154: -- =========================================================================
155: -- End commenting the session validation code ....
156: IF x_return_status <> fnd_api.g_ret_sts_success THEN
157: RAISE fnd_api.g_exc_error;
158: END IF;
159: -- Standard check for p_commit
160: IF fnd_api.to_boolean (p_commit) THEN

Line 157: RAISE fnd_api.g_exc_error;

153: -- End Validate Environment
154: -- =========================================================================
155: -- End commenting the session validation code ....
156: IF x_return_status <> fnd_api.g_ret_sts_success THEN
157: RAISE fnd_api.g_exc_error;
158: END IF;
159: -- Standard check for p_commit
160: IF fnd_api.to_boolean (p_commit) THEN
161: COMMIT WORK;

Line 160: IF fnd_api.to_boolean (p_commit) THEN

156: IF x_return_status <> fnd_api.g_ret_sts_success THEN
157: RAISE fnd_api.g_exc_error;
158: END IF;
159: -- Standard check for p_commit
160: IF fnd_api.to_boolean (p_commit) THEN
161: COMMIT WORK;
162: END IF;
163: --Debug Message
164: amw_utility_pvt.debug_message ('Private API: ' || l_api_name || 'end');

Line 168: WHEN fnd_api.g_exc_error THEN

164: amw_utility_pvt.debug_message ('Private API: ' || l_api_name || 'end');
165: -- Standard call to get message count and if count is 1, get message info.
166: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
167: EXCEPTION
168: WHEN fnd_api.g_exc_error THEN
169: ROLLBACK TO amw_risk_type_pvt;
170: x_return_status := fnd_api.g_ret_sts_error;
171: -- Standard call to get message count and if count=1, get the message
172: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,

Line 170: x_return_status := fnd_api.g_ret_sts_error;

166: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
167: EXCEPTION
168: WHEN fnd_api.g_exc_error THEN
169: ROLLBACK TO amw_risk_type_pvt;
170: x_return_status := fnd_api.g_ret_sts_error;
171: -- Standard call to get message count and if count=1, get the message
172: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
173: p_count => x_msg_count,
174: p_data => x_msg_data

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

168: WHEN fnd_api.g_exc_error THEN
169: ROLLBACK TO amw_risk_type_pvt;
170: x_return_status := fnd_api.g_ret_sts_error;
171: -- Standard call to get message count and if count=1, get the message
172: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
173: p_count => x_msg_count,
174: p_data => x_msg_data
175: );
176: WHEN fnd_api.g_exc_unexpected_error THEN

Line 176: WHEN fnd_api.g_exc_unexpected_error THEN

172: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
173: p_count => x_msg_count,
174: p_data => x_msg_data
175: );
176: WHEN fnd_api.g_exc_unexpected_error THEN
177: ROLLBACK TO amw_risk_type_pvt;
178: x_return_status := fnd_api.g_ret_sts_unexp_error;
179: -- Standard call to get message count and if count=1, get the message
180: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,

Line 178: x_return_status := fnd_api.g_ret_sts_unexp_error;

174: p_data => x_msg_data
175: );
176: WHEN fnd_api.g_exc_unexpected_error THEN
177: ROLLBACK TO amw_risk_type_pvt;
178: x_return_status := fnd_api.g_ret_sts_unexp_error;
179: -- Standard call to get message count and if count=1, get the message
180: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
181: p_count => x_msg_count,
182: p_data => x_msg_data

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

176: WHEN fnd_api.g_exc_unexpected_error THEN
177: ROLLBACK TO amw_risk_type_pvt;
178: x_return_status := fnd_api.g_ret_sts_unexp_error;
179: -- Standard call to get message count and if count=1, get the message
180: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
181: p_count => x_msg_count,
182: p_data => x_msg_data
183: );
184: WHEN OTHERS THEN

Line 186: x_return_status := fnd_api.g_ret_sts_unexp_error;

182: p_data => x_msg_data
183: );
184: WHEN OTHERS THEN
185: ROLLBACK TO amw_risk_type_pvt;
186: x_return_status := fnd_api.g_ret_sts_unexp_error;
187: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
188: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
189: END IF;
190: -- Standard call to get message count and if count=1, get the message

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

187: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
188: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
189: END IF;
190: -- Standard call to get message count and if count=1, get the message
191: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
192: p_count => x_msg_count,
193: p_data => x_msg_data
194: );
195: END insert_delete_risk_type;

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

203: -- ===============================================================
204: PROCEDURE Revise_Risk_Type(
205: p_old_risk_rev_id IN NUMBER,
206: p_risk_rev_id IN NUMBER,
207: p_commit IN VARCHAR2 := fnd_api.g_false,
208: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
209: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
210: p_api_version_number IN NUMBER,
211: x_return_status OUT NOCOPY VARCHAR2,

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

204: PROCEDURE Revise_Risk_Type(
205: p_old_risk_rev_id IN NUMBER,
206: p_risk_rev_id IN NUMBER,
207: p_commit IN VARCHAR2 := fnd_api.g_false,
208: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
209: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
210: p_api_version_number IN NUMBER,
211: x_return_status OUT NOCOPY VARCHAR2,
212: x_msg_count OUT NOCOPY NUMBER,

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

205: p_old_risk_rev_id IN NUMBER,
206: p_risk_rev_id IN NUMBER,
207: p_commit IN VARCHAR2 := fnd_api.g_false,
208: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
209: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
210: p_api_version_number IN NUMBER,
211: x_return_status OUT NOCOPY VARCHAR2,
212: x_msg_count OUT NOCOPY NUMBER,
213: x_msg_data OUT NOCOPY VARCHAR2

Line 220: IF NOT fnd_api.compatible_api_call (l_api_version_number,

216: l_api_version_number CONSTANT NUMBER := 1.0;
217: BEGIN
218: SAVEPOINT amw_risk_type_revise;
219: -- Standard call to check for call compatibility.
220: IF NOT fnd_api.compatible_api_call (l_api_version_number,
221: p_api_version_number,
222: l_api_name,
223: g_pkg_name
224: ) THEN

Line 225: RAISE fnd_api.g_exc_unexpected_error;

221: p_api_version_number,
222: l_api_name,
223: g_pkg_name
224: ) THEN
225: RAISE fnd_api.g_exc_unexpected_error;
226: END IF;
227: -- Initialize message list if p_init_msg_list is set to TRUE.
228: IF fnd_api.to_boolean (p_init_msg_list) THEN
229: fnd_msg_pub.initialize;

Line 228: IF fnd_api.to_boolean (p_init_msg_list) THEN

224: ) THEN
225: RAISE fnd_api.g_exc_unexpected_error;
226: END IF;
227: -- Initialize message list if p_init_msg_list is set to TRUE.
228: IF fnd_api.to_boolean (p_init_msg_list) THEN
229: fnd_msg_pub.initialize;
230: END IF;
231: -- Debug Message
232: amw_utility_pvt.debug_message ('Private API: ' || l_api_name || 'start');

Line 234: x_return_status := fnd_api.g_ret_sts_success;

230: END IF;
231: -- Debug Message
232: amw_utility_pvt.debug_message ('Private API: ' || l_api_name || 'start');
233: -- Initialize API return status to SUCCESS
234: x_return_status := fnd_api.g_ret_sts_success;
235: IF fnd_global.user_id IS NULL THEN
236: amw_utility_pvt.error_message
237: (p_message_name => 'USER_PROFILE_MISSING');
238: RAISE fnd_api.g_exc_error;

Line 238: RAISE fnd_api.g_exc_error;

234: x_return_status := fnd_api.g_ret_sts_success;
235: IF fnd_global.user_id IS NULL THEN
236: amw_utility_pvt.error_message
237: (p_message_name => 'USER_PROFILE_MISSING');
238: RAISE fnd_api.g_exc_error;
239: END IF;
240:
241: -- carry over Risk Type Associations when Revising the Risk
242: IF p_old_risk_rev_id is not null AND p_risk_rev_id is not null THEN

Line 268: IF x_return_status <> fnd_api.g_ret_sts_success THEN

264: from AMW_RISK_TYPE old
265: where old.RISK_REV_ID = p_old_risk_rev_id;
266: END IF;
267:
268: IF x_return_status <> fnd_api.g_ret_sts_success THEN
269: RAISE fnd_api.g_exc_error;
270: END IF;
271: -- Standard check for p_commit
272: IF fnd_api.to_boolean (p_commit) THEN

Line 269: RAISE fnd_api.g_exc_error;

265: where old.RISK_REV_ID = p_old_risk_rev_id;
266: END IF;
267:
268: IF x_return_status <> fnd_api.g_ret_sts_success THEN
269: RAISE fnd_api.g_exc_error;
270: END IF;
271: -- Standard check for p_commit
272: IF fnd_api.to_boolean (p_commit) THEN
273: COMMIT WORK;

Line 272: IF fnd_api.to_boolean (p_commit) THEN

268: IF x_return_status <> fnd_api.g_ret_sts_success THEN
269: RAISE fnd_api.g_exc_error;
270: END IF;
271: -- Standard check for p_commit
272: IF fnd_api.to_boolean (p_commit) THEN
273: COMMIT WORK;
274: END IF;
275: --Debug Message
276: amw_utility_pvt.debug_message ('API: ' || l_api_name || 'end');

Line 280: WHEN fnd_api.g_exc_error THEN

276: amw_utility_pvt.debug_message ('API: ' || l_api_name || 'end');
277: -- Standard call to get message count and if count is 1, get message info.
278: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
279: EXCEPTION
280: WHEN fnd_api.g_exc_error THEN
281: ROLLBACK TO amw_risk_type_revise;
282: x_return_status := fnd_api.g_ret_sts_error;
283: -- Standard call to get message count and if count=1, get the message
284: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,

Line 282: x_return_status := fnd_api.g_ret_sts_error;

278: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
279: EXCEPTION
280: WHEN fnd_api.g_exc_error THEN
281: ROLLBACK TO amw_risk_type_revise;
282: x_return_status := fnd_api.g_ret_sts_error;
283: -- Standard call to get message count and if count=1, get the message
284: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
285: p_count => x_msg_count,
286: p_data => x_msg_data

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

280: WHEN fnd_api.g_exc_error THEN
281: ROLLBACK TO amw_risk_type_revise;
282: x_return_status := fnd_api.g_ret_sts_error;
283: -- Standard call to get message count and if count=1, get the message
284: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
285: p_count => x_msg_count,
286: p_data => x_msg_data
287: );
288: WHEN fnd_api.g_exc_unexpected_error THEN

Line 288: WHEN fnd_api.g_exc_unexpected_error THEN

284: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
285: p_count => x_msg_count,
286: p_data => x_msg_data
287: );
288: WHEN fnd_api.g_exc_unexpected_error THEN
289: ROLLBACK TO amw_risk_type_revise;
290: x_return_status := fnd_api.g_ret_sts_unexp_error;
291: -- Standard call to get message count and if count=1, get the message
292: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,

Line 290: x_return_status := fnd_api.g_ret_sts_unexp_error;

286: p_data => x_msg_data
287: );
288: WHEN fnd_api.g_exc_unexpected_error THEN
289: ROLLBACK TO amw_risk_type_revise;
290: x_return_status := fnd_api.g_ret_sts_unexp_error;
291: -- Standard call to get message count and if count=1, get the message
292: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
293: p_count => x_msg_count,
294: p_data => x_msg_data

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

288: WHEN fnd_api.g_exc_unexpected_error THEN
289: ROLLBACK TO amw_risk_type_revise;
290: x_return_status := fnd_api.g_ret_sts_unexp_error;
291: -- Standard call to get message count and if count=1, get the message
292: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
293: p_count => x_msg_count,
294: p_data => x_msg_data
295: );
296: WHEN OTHERS THEN

Line 298: x_return_status := fnd_api.g_ret_sts_unexp_error;

294: p_data => x_msg_data
295: );
296: WHEN OTHERS THEN
297: ROLLBACK TO amw_risk_type_revise;
298: x_return_status := fnd_api.g_ret_sts_unexp_error;
299: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
300: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
301: END IF;
302: -- Standard call to get message count and if count=1, get the message

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

299: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
300: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
301: END IF;
302: -- Standard call to get message count and if count=1, get the message
303: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
304: p_count => x_msg_count,
305: p_data => x_msg_data
306: );
307: