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

Line 25: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

21: based on input values passed by calling routines. */
22:
23: PROCEDURE create_team_usage
24: (P_API_VERSION IN NUMBER,
25: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
26: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
27: P_TEAM_ID IN JTF_RS_TEAM_USAGES.TEAM_ID%TYPE,
28: P_TEAM_NUMBER IN JTF_RS_TEAMS_VL.TEAM_NUMBER%TYPE,
29: P_USAGE IN JTF_RS_TEAM_USAGES.USAGE%TYPE,

Line 26: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

22:
23: PROCEDURE create_team_usage
24: (P_API_VERSION IN NUMBER,
25: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
26: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
27: P_TEAM_ID IN JTF_RS_TEAM_USAGES.TEAM_ID%TYPE,
28: P_TEAM_NUMBER IN JTF_RS_TEAMS_VL.TEAM_NUMBER%TYPE,
29: P_USAGE IN JTF_RS_TEAM_USAGES.USAGE%TYPE,
30: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 50: x_return_status := fnd_api.g_ret_sts_success;

46:
47:
48: SAVEPOINT create_rs_team_usage_pub;
49:
50: x_return_status := fnd_api.g_ret_sts_success;
51:
52: -- DBMS_OUTPUT.put_line('Started Create Resource Team Usage Pub ');
53:
54:

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

51:
52: -- DBMS_OUTPUT.put_line('Started Create Resource Team Usage Pub ');
53:
54:
55: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
56:
57: RAISE fnd_api.g_exc_unexpected_error;
58:
59: END IF;

Line 57: RAISE fnd_api.g_exc_unexpected_error;

53:
54:
55: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
56:
57: RAISE fnd_api.g_exc_unexpected_error;
58:
59: END IF;
60:
61:

Line 62: IF fnd_api.to_boolean(p_init_msg_list) THEN

58:
59: END IF;
60:
61:
62: IF fnd_api.to_boolean(p_init_msg_list) THEN
63:
64: fnd_msg_pub.initialize;
65:
66: END IF;

Line 80: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

76: );
77: -- added for NOCOPY
78: l_team_id := l_team_id_out;
79:
80: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
81:
82: x_return_status := fnd_api.g_ret_sts_unexp_error;
83:
84: RAISE fnd_api.g_exc_unexpected_error;

Line 82: x_return_status := fnd_api.g_ret_sts_unexp_error;

78: l_team_id := l_team_id_out;
79:
80: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
81:
82: x_return_status := fnd_api.g_ret_sts_unexp_error;
83:
84: RAISE fnd_api.g_exc_unexpected_error;
85:
86: END IF;

Line 84: RAISE fnd_api.g_exc_unexpected_error;

80: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
81:
82: x_return_status := fnd_api.g_ret_sts_unexp_error;
83:
84: RAISE fnd_api.g_exc_unexpected_error;
85:
86: END IF;
87:
88:

Line 98: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

94: x_return_status => x_return_status
95: );
96:
97:
98: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
99:
100: x_return_status := fnd_api.g_ret_sts_unexp_error;
101:
102: RAISE fnd_api.g_exc_unexpected_error;

Line 100: x_return_status := fnd_api.g_ret_sts_unexp_error;

96:
97:
98: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
99:
100: x_return_status := fnd_api.g_ret_sts_unexp_error;
101:
102: RAISE fnd_api.g_exc_unexpected_error;
103:
104: END IF;

Line 102: RAISE fnd_api.g_exc_unexpected_error;

98: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
99:
100: x_return_status := fnd_api.g_ret_sts_unexp_error;
101:
102: RAISE fnd_api.g_exc_unexpected_error;
103:
104: END IF;
105:
106:

Line 112: P_INIT_MSG_LIST => fnd_api.g_false,

108: /* Call the private procedure with the validated parameters. */
109:
110: jtf_rs_team_usages_pvt.create_team_usage
111: (P_API_VERSION => 1,
112: P_INIT_MSG_LIST => fnd_api.g_false,
113: P_COMMIT => fnd_api.g_false,
114: P_TEAM_ID => l_team_id,
115: P_USAGE => l_usage,
116: X_RETURN_STATUS => x_return_status,

Line 113: P_COMMIT => fnd_api.g_false,

109:
110: jtf_rs_team_usages_pvt.create_team_usage
111: (P_API_VERSION => 1,
112: P_INIT_MSG_LIST => fnd_api.g_false,
113: P_COMMIT => fnd_api.g_false,
114: P_TEAM_ID => l_team_id,
115: P_USAGE => l_usage,
116: X_RETURN_STATUS => x_return_status,
117: X_MSG_COUNT => x_msg_count,

Line 123: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

119: X_TEAM_USAGE_ID => x_team_usage_id
120: );
121:
122:
123: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
124:
125: -- dbms_output.put_line('Failed status from call to private procedure');
126:
127: RAISE fnd_api.g_exc_unexpected_error;

Line 127: RAISE fnd_api.g_exc_unexpected_error;

123: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
124:
125: -- dbms_output.put_line('Failed status from call to private procedure');
126:
127: RAISE fnd_api.g_exc_unexpected_error;
128:
129: END IF;
130:
131:

Line 132: IF fnd_api.to_boolean(p_commit) THEN

128:
129: END IF;
130:
131:
132: IF fnd_api.to_boolean(p_commit) THEN
133:
134: COMMIT WORK;
135:
136: END IF;

Line 144: WHEN fnd_api.g_exc_unexpected_error THEN

140:
141: EXCEPTION
142:
143:
144: WHEN fnd_api.g_exc_unexpected_error THEN
145:
146: -- DBMS_OUTPUT.put_line (' ========================================== ');
147:
148: -- DBMS_OUTPUT.put_line ('=========== Raised Unexpected Error ======= ======== ');

Line 152: x_return_status := fnd_api.g_ret_sts_unexp_error;

148: -- DBMS_OUTPUT.put_line ('=========== Raised Unexpected Error ======= ======== ');
149:
150: ROLLBACK TO create_rs_team_usage_pub;
151:
152: x_return_status := fnd_api.g_ret_sts_unexp_error;
153:
154: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
155:
156:

Line 167: x_return_status := fnd_api.g_ret_sts_unexp_error;

163: -- DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
164:
165: ROLLBACK TO create_rs_team_usage_pub;
166:
167: x_return_status := fnd_api.g_ret_sts_unexp_error;
168:
169: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
170:
171:

Line 181: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

177: based on input values passed by calling routines. */
178:
179: PROCEDURE delete_team_usage
180: (P_API_VERSION IN NUMBER,
181: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
182: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
183: P_TEAM_ID IN JTF_RS_TEAM_USAGES.TEAM_ID%TYPE,
184: P_TEAM_NUMBER IN JTF_RS_TEAMS_VL.TEAM_NUMBER%TYPE,
185: P_USAGE IN JTF_RS_TEAM_USAGES.USAGE%TYPE,

Line 182: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

178:
179: PROCEDURE delete_team_usage
180: (P_API_VERSION IN NUMBER,
181: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
182: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
183: P_TEAM_ID IN JTF_RS_TEAM_USAGES.TEAM_ID%TYPE,
184: P_TEAM_NUMBER IN JTF_RS_TEAMS_VL.TEAM_NUMBER%TYPE,
185: P_USAGE IN JTF_RS_TEAM_USAGES.USAGE%TYPE,
186: P_OBJECT_VERSION_NUM IN JTF_RS_TEAM_USAGES.OBJECT_VERSION_NUMBER%TYPE,

Line 206: x_return_status := fnd_api.g_ret_sts_success;

202:
203:
204: SAVEPOINT delete_team_usage_pub;
205:
206: x_return_status := fnd_api.g_ret_sts_success;
207:
208: -- DBMS_OUTPUT.put_line(' Started Delete Team Usage Pub ');
209:
210:

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

207:
208: -- DBMS_OUTPUT.put_line(' Started Delete Team Usage Pub ');
209:
210:
211: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
212:
213: RAISE fnd_api.g_exc_unexpected_error;
214:
215: END IF;

Line 213: RAISE fnd_api.g_exc_unexpected_error;

209:
210:
211: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
212:
213: RAISE fnd_api.g_exc_unexpected_error;
214:
215: END IF;
216:
217:

Line 218: IF fnd_api.to_boolean(p_init_msg_list) THEN

214:
215: END IF;
216:
217:
218: IF fnd_api.to_boolean(p_init_msg_list) THEN
219:
220: fnd_msg_pub.initialize;
221:
222: END IF;

Line 238: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

234: );
235: -- added for NOCOPY
236: l_team_id := l_team_id_out;
237:
238: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
239:
240: x_return_status := fnd_api.g_ret_sts_unexp_error;
241:
242: RAISE fnd_api.g_exc_unexpected_error;

Line 240: x_return_status := fnd_api.g_ret_sts_unexp_error;

236: l_team_id := l_team_id_out;
237:
238: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
239:
240: x_return_status := fnd_api.g_ret_sts_unexp_error;
241:
242: RAISE fnd_api.g_exc_unexpected_error;
243:
244: END IF;

Line 242: RAISE fnd_api.g_exc_unexpected_error;

238: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
239:
240: x_return_status := fnd_api.g_ret_sts_unexp_error;
241:
242: RAISE fnd_api.g_exc_unexpected_error;
243:
244: END IF;
245:
246: END; /* End of Resource Team Validation */

Line 258: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

254: x_return_status => x_return_status
255: );
256:
257:
258: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
259:
260: x_return_status := fnd_api.g_ret_sts_unexp_error;
261:
262: RAISE fnd_api.g_exc_unexpected_error;

Line 260: x_return_status := fnd_api.g_ret_sts_unexp_error;

256:
257:
258: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
259:
260: x_return_status := fnd_api.g_ret_sts_unexp_error;
261:
262: RAISE fnd_api.g_exc_unexpected_error;
263:
264: END IF;

Line 262: RAISE fnd_api.g_exc_unexpected_error;

258: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
259:
260: x_return_status := fnd_api.g_ret_sts_unexp_error;
261:
262: RAISE fnd_api.g_exc_unexpected_error;
263:
264: END IF;
265:
266:

Line 272: P_INIT_MSG_LIST => fnd_api.g_false,

268: /* Call the private procedure for delete */
269:
270: jtf_rs_team_usages_pvt.delete_team_usage
271: (P_API_VERSION => 1,
272: P_INIT_MSG_LIST => fnd_api.g_false,
273: P_COMMIT => fnd_api.g_false,
274: P_TEAM_ID => l_team_id,
275: P_USAGE => l_usage,
276: P_OBJECT_VERSION_NUM => p_object_version_num,

Line 273: P_COMMIT => fnd_api.g_false,

269:
270: jtf_rs_team_usages_pvt.delete_team_usage
271: (P_API_VERSION => 1,
272: P_INIT_MSG_LIST => fnd_api.g_false,
273: P_COMMIT => fnd_api.g_false,
274: P_TEAM_ID => l_team_id,
275: P_USAGE => l_usage,
276: P_OBJECT_VERSION_NUM => p_object_version_num,
277: X_RETURN_STATUS => x_return_status,

Line 283: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

279: X_MSG_DATA => x_msg_data
280: );
281:
282:
283: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
284:
285: -- dbms_output.put_line('Failed status from call to private procedure');
286:
287: RAISE fnd_api.g_exc_unexpected_error;

Line 287: RAISE fnd_api.g_exc_unexpected_error;

283: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
284:
285: -- dbms_output.put_line('Failed status from call to private procedure');
286:
287: RAISE fnd_api.g_exc_unexpected_error;
288:
289: END IF;
290:
291:

Line 292: IF fnd_api.to_boolean(p_commit) THEN

288:
289: END IF;
290:
291:
292: IF fnd_api.to_boolean(p_commit) THEN
293:
294: COMMIT WORK;
295:
296: END IF;

Line 304: WHEN fnd_api.g_exc_unexpected_error THEN

300:
301: EXCEPTION
302:
303:
304: WHEN fnd_api.g_exc_unexpected_error THEN
305:
306: -- DBMS_OUTPUT.put_line (' ========================================== ');
307:
308: -- DBMS_OUTPUT.put_line ('=========== Raised Unexpected Error ======= ======== ');

Line 312: x_return_status := fnd_api.g_ret_sts_unexp_error;

308: -- DBMS_OUTPUT.put_line ('=========== Raised Unexpected Error ======= ======== ');
309:
310: ROLLBACK TO delete_team_usage_pub;
311:
312: x_return_status := fnd_api.g_ret_sts_unexp_error;
313:
314: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
315:
316:

Line 327: x_return_status := fnd_api.g_ret_sts_unexp_error;

323: -- DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
324:
325: ROLLBACK TO delete_team_usage_pub;
326:
327: x_return_status := fnd_api.g_ret_sts_unexp_error;
328:
329: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
330:
331: