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.CN_PRD_QUOTA_PVT dependencies on FND_API

Line 13: -- Default = FND_API.G_FALSE

9: -- Pre-reqs : None.
10: -- Parameters :
11: -- IN : p_api_version IN NUMBER Required
12: -- p_init_msg_list IN VARCHAR2 Optional
13: -- Default = FND_API.G_FALSE
14: -- p_commit IN VARCHAR2 Optional
15: -- Default = FND_API.G_FALSE
16: -- p_validation_level IN NUMBER Optional
17: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 15: -- Default = FND_API.G_FALSE

11: -- IN : p_api_version IN NUMBER Required
12: -- p_init_msg_list IN VARCHAR2 Optional
13: -- Default = FND_API.G_FALSE
14: -- p_commit IN VARCHAR2 Optional
15: -- Default = FND_API.G_FALSE
16: -- p_validation_level IN NUMBER Optional
17: -- Default = FND_API.G_VALID_LEVEL_FULL
18: -- p_prd_quota IN prd_quota_rec_type
19: -- OUT : x_return_status OUT VARCHAR2(1)

Line 17: -- Default = FND_API.G_VALID_LEVEL_FULL

13: -- Default = FND_API.G_FALSE
14: -- p_commit IN VARCHAR2 Optional
15: -- Default = FND_API.G_FALSE
16: -- p_validation_level IN NUMBER Optional
17: -- Default = FND_API.G_VALID_LEVEL_FULL
18: -- p_prd_quota IN prd_quota_rec_type
19: -- OUT : x_return_status OUT VARCHAR2(1)
20: -- x_msg_count OUT NUMBER
21: -- x_msg_data OUT VARCHAR2(2000)

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

24: --
25: -- End of comments
26: PROCEDURE update_period_quota (
27: p_api_version IN NUMBER,
28: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
29: p_commit IN VARCHAR2 := fnd_api.g_false,
30: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
31: p_prd_quota IN OUT NOCOPY prd_quota_rec_type,
32: x_return_status OUT NOCOPY VARCHAR2,

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

25: -- End of comments
26: PROCEDURE update_period_quota (
27: p_api_version IN NUMBER,
28: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
29: p_commit IN VARCHAR2 := fnd_api.g_false,
30: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
31: p_prd_quota IN OUT NOCOPY prd_quota_rec_type,
32: x_return_status OUT NOCOPY VARCHAR2,
33: x_msg_count OUT NOCOPY NUMBER,

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

26: PROCEDURE update_period_quota (
27: p_api_version IN NUMBER,
28: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
29: p_commit IN VARCHAR2 := fnd_api.g_false,
30: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
31: p_prd_quota IN OUT NOCOPY prd_quota_rec_type,
32: x_return_status OUT NOCOPY VARCHAR2,
33: x_msg_count OUT NOCOPY NUMBER,
34: x_msg_data OUT NOCOPY VARCHAR2

Line 64: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

60: -- Standard Start of API savepoint
61: SAVEPOINT update_prd_quota;
62:
63: -- Standard call to check for call compatibility.
64: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
65: THEN
66: RAISE fnd_api.g_exc_unexpected_error;
67: END IF;
68:

Line 66: RAISE fnd_api.g_exc_unexpected_error;

62:
63: -- Standard call to check for call compatibility.
64: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
65: THEN
66: RAISE fnd_api.g_exc_unexpected_error;
67: END IF;
68:
69: -- Initialize message list if p_init_msg_list is set to TRUE.
70: IF fnd_api.to_boolean (p_init_msg_list)

Line 70: IF fnd_api.to_boolean (p_init_msg_list)

66: RAISE fnd_api.g_exc_unexpected_error;
67: END IF;
68:
69: -- Initialize message list if p_init_msg_list is set to TRUE.
70: IF fnd_api.to_boolean (p_init_msg_list)
71: THEN
72: fnd_msg_pub.initialize;
73: END IF;
74:

Line 76: x_return_status := fnd_api.g_ret_sts_success;

72: fnd_msg_pub.initialize;
73: END IF;
74:
75: -- Initialize API return status to success
76: x_return_status := fnd_api.g_ret_sts_success;
77:
78: SELECT COUNT (*)
79: INTO l_temp_count
80: FROM cn_period_quotas

Line 99: RAISE fnd_api.g_exc_error;

95: fnd_message.set_token ('INPUT5', ' ');
96: fnd_msg_pub.ADD;
97: END IF;
98:
99: RAISE fnd_api.g_exc_error;
100: END IF;
101:
102: -- API body
103: OPEN l_old_prd_quota_cr;

Line 117: RAISE fnd_api.g_exc_error;

113: THEN
114: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
115: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('ORGANIZATION', 'PE_OBJECT_TYPE'));
116: fnd_msg_pub.ADD;
117: RAISE fnd_api.g_exc_error;
118: END IF;
119: END IF;
120:
121: -- 3. check object version number

Line 126: RAISE fnd_api.g_exc_error;

122: IF l_old_prd_quota.object_version_number <> p_prd_quota.object_version_number
123: THEN
124: fnd_message.set_name ('CN', 'CN_RECORD_CHANGED');
125: fnd_msg_pub.ADD;
126: RAISE fnd_api.g_exc_error;
127: END IF;
128:
129: p_prd_quota.last_update_date := SYSDATE;
130: p_prd_quota.last_update_login := fnd_global.login_id;

Line 153: IF fnd_api.to_boolean (p_commit)

149: cn_period_quotas_pkg.sync_ITD_values (x_quota_id => p_prd_quota.quota_id);
150:
151: -- End of API body.
152: -- Standard check of p_commit.
153: IF fnd_api.to_boolean (p_commit)
154: THEN
155: COMMIT WORK;
156: END IF;
157:

Line 159: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

155: COMMIT WORK;
156: END IF;
157:
158: -- Standard call to get message count and if count is 1, get message info.
159: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
160: EXCEPTION
161: WHEN fnd_api.g_exc_error
162: THEN
163: ROLLBACK TO update_prd_quota;

Line 161: WHEN fnd_api.g_exc_error

157:
158: -- Standard call to get message count and if count is 1, get message info.
159: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
160: EXCEPTION
161: WHEN fnd_api.g_exc_error
162: THEN
163: ROLLBACK TO update_prd_quota;
164: x_return_status := fnd_api.g_ret_sts_error;
165: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 164: x_return_status := fnd_api.g_ret_sts_error;

160: EXCEPTION
161: WHEN fnd_api.g_exc_error
162: THEN
163: ROLLBACK TO update_prd_quota;
164: x_return_status := fnd_api.g_ret_sts_error;
165: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
166: WHEN fnd_api.g_exc_unexpected_error
167: THEN
168: ROLLBACK TO update_prd_quota;

Line 165: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

161: WHEN fnd_api.g_exc_error
162: THEN
163: ROLLBACK TO update_prd_quota;
164: x_return_status := fnd_api.g_ret_sts_error;
165: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
166: WHEN fnd_api.g_exc_unexpected_error
167: THEN
168: ROLLBACK TO update_prd_quota;
169: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 166: WHEN fnd_api.g_exc_unexpected_error

162: THEN
163: ROLLBACK TO update_prd_quota;
164: x_return_status := fnd_api.g_ret_sts_error;
165: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
166: WHEN fnd_api.g_exc_unexpected_error
167: THEN
168: ROLLBACK TO update_prd_quota;
169: x_return_status := fnd_api.g_ret_sts_unexp_error;
170: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 169: x_return_status := fnd_api.g_ret_sts_unexp_error;

165: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
166: WHEN fnd_api.g_exc_unexpected_error
167: THEN
168: ROLLBACK TO update_prd_quota;
169: x_return_status := fnd_api.g_ret_sts_unexp_error;
170: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
171: WHEN OTHERS
172: THEN
173: ROLLBACK TO update_prd_quota;

Line 170: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

166: WHEN fnd_api.g_exc_unexpected_error
167: THEN
168: ROLLBACK TO update_prd_quota;
169: x_return_status := fnd_api.g_ret_sts_unexp_error;
170: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
171: WHEN OTHERS
172: THEN
173: ROLLBACK TO update_prd_quota;
174: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 174: x_return_status := fnd_api.g_ret_sts_unexp_error;

170: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
171: WHEN OTHERS
172: THEN
173: ROLLBACK TO update_prd_quota;
174: x_return_status := fnd_api.g_ret_sts_unexp_error;
175:
176: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
177: THEN
178: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 181: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

177: THEN
178: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
179: END IF;
180:
181: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
182: END update_period_quota;
183:
184: END cn_prd_quota_pvt;