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

Line 5: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false

1: PACKAGE BODY jtf_task_resources_pub AS
2: /* $Header: jtfptkrb.pls 120.1.12000000.3 2007/08/06 12:14:22 rkamasam ship $ */
3: PROCEDURE create_task_rsrc_req(
4: p_api_version IN NUMBER
5: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
6: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
7: , p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
8: , p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
9: , p_task_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char

Line 6: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false

2: /* $Header: jtfptkrb.pls 120.1.12000000.3 2007/08/06 12:14:22 rkamasam ship $ */
3: PROCEDURE create_task_rsrc_req(
4: p_api_version IN NUMBER
5: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
6: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
7: , p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
8: , p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
9: , p_task_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
10: , p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num

Line 7: , p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num

3: PROCEDURE create_task_rsrc_req(
4: p_api_version IN NUMBER
5: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
6: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
7: , p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
8: , p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
9: , p_task_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
10: , p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num
11: , p_task_type_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char

Line 8: , p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char

4: p_api_version IN NUMBER
5: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
6: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
7: , p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
8: , p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
9: , p_task_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
10: , p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num
11: , p_task_type_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
12: , p_task_template_id IN NUMBER DEFAULT fnd_api.g_miss_num

Line 9: , p_task_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char

5: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
6: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
7: , p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
8: , p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
9: , p_task_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
10: , p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num
11: , p_task_type_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
12: , p_task_template_id IN NUMBER DEFAULT fnd_api.g_miss_num
13: , p_task_template_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char

Line 10: , p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num

6: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
7: , p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
8: , p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
9: , p_task_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
10: , p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num
11: , p_task_type_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
12: , p_task_template_id IN NUMBER DEFAULT fnd_api.g_miss_num
13: , p_task_template_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
14: , p_resource_type_code IN VARCHAR2

Line 11: , p_task_type_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char

7: , p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
8: , p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
9: , p_task_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
10: , p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num
11: , p_task_type_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
12: , p_task_template_id IN NUMBER DEFAULT fnd_api.g_miss_num
13: , p_task_template_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
14: , p_resource_type_code IN VARCHAR2
15: , p_required_units IN NUMBER

Line 12: , p_task_template_id IN NUMBER DEFAULT fnd_api.g_miss_num

8: , p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
9: , p_task_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
10: , p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num
11: , p_task_type_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
12: , p_task_template_id IN NUMBER DEFAULT fnd_api.g_miss_num
13: , p_task_template_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
14: , p_resource_type_code IN VARCHAR2
15: , p_required_units IN NUMBER
16: , p_enabled_flag IN VARCHAR2 DEFAULT jtf_task_utl.g_no

Line 13: , p_task_template_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char

9: , p_task_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
10: , p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num
11: , p_task_type_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
12: , p_task_template_id IN NUMBER DEFAULT fnd_api.g_miss_num
13: , p_task_template_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
14: , p_resource_type_code IN VARCHAR2
15: , p_required_units IN NUMBER
16: , p_enabled_flag IN VARCHAR2 DEFAULT jtf_task_utl.g_no
17: , x_return_status OUT NOCOPY VARCHAR2

Line 41: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

37: ) IS
38: --Declare the variables
39: l_api_version CONSTANT NUMBER := 1.0;
40: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_TASK_RSRC_REQ';
41: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
42: l_task_id jtf_tasks_b.task_id%TYPE := p_task_id;
43: l_task_number jtf_tasks_b.task_number%TYPE := p_task_number;
44: l_task_name jtf_tasks_tl.task_name%TYPE := p_task_name;
45: l_task_type_id jtf_task_types_b.task_type_id%TYPE := p_task_type_id;

Line 59: x_return_status := fnd_api.g_ret_sts_success;

55: --
56: BEGIN
57: SAVEPOINT create_task_rsrc_req;
58:
59: x_return_status := fnd_api.g_ret_sts_success;
60:
61: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
62: RAISE fnd_api.g_exc_unexpected_error;
63: END IF;

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

57: SAVEPOINT create_task_rsrc_req;
58:
59: x_return_status := fnd_api.g_ret_sts_success;
60:
61: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
62: RAISE fnd_api.g_exc_unexpected_error;
63: END IF;
64:
65: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 62: RAISE fnd_api.g_exc_unexpected_error;

58:
59: x_return_status := fnd_api.g_ret_sts_success;
60:
61: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
62: RAISE fnd_api.g_exc_unexpected_error;
63: END IF;
64:
65: IF fnd_api.to_boolean(p_init_msg_list) THEN
66: fnd_msg_pub.initialize;

Line 65: IF fnd_api.to_boolean(p_init_msg_list) THEN

61: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
62: RAISE fnd_api.g_exc_unexpected_error;
63: END IF;
64:
65: IF fnd_api.to_boolean(p_init_msg_list) THEN
66: fnd_msg_pub.initialize;
67: END IF;
68:
69: --Check for Required Parameters

Line 72: x_return_status := fnd_api.g_ret_sts_unexp_error;

68:
69: --Check for Required Parameters
70: --Resource subtype
71: IF l_resource_type_code IS NULL THEN
72: x_return_status := fnd_api.g_ret_sts_unexp_error;
73: fnd_message.set_name('JTF', 'JTF_TASK_NULL_RES_TYPE_CODE');
74: fnd_msg_pub.ADD;
75: RAISE fnd_api.g_exc_unexpected_error;
76: END IF;

Line 75: RAISE fnd_api.g_exc_unexpected_error;

71: IF l_resource_type_code IS NULL THEN
72: x_return_status := fnd_api.g_ret_sts_unexp_error;
73: fnd_message.set_name('JTF', 'JTF_TASK_NULL_RES_TYPE_CODE');
74: fnd_msg_pub.ADD;
75: RAISE fnd_api.g_exc_unexpected_error;
76: END IF;
77:
78: --Required Units
79: IF l_required_units IS NULL THEN

Line 80: x_return_status := fnd_api.g_ret_sts_unexp_error;

76: END IF;
77:
78: --Required Units
79: IF l_required_units IS NULL THEN
80: x_return_status := fnd_api.g_ret_sts_unexp_error;
81: fnd_message.set_name('JTF', 'JTF_TASK_NULL_REQ_UNIT');
82: fnd_msg_pub.ADD;
83: RAISE fnd_api.g_exc_unexpected_error;
84: END IF;

Line 83: RAISE fnd_api.g_exc_unexpected_error;

79: IF l_required_units IS NULL THEN
80: x_return_status := fnd_api.g_ret_sts_unexp_error;
81: fnd_message.set_name('JTF', 'JTF_TASK_NULL_REQ_UNIT');
82: fnd_msg_pub.ADD;
83: RAISE fnd_api.g_exc_unexpected_error;
84: END IF;
85:
86: --- Validate enabled flag
87: jtf_task_utl.validate_flag(

Line 89: , p_init_msg_list => fnd_api.g_false

85:
86: --- Validate enabled flag
87: jtf_task_utl.validate_flag(
88: p_api_name => l_api_name
89: , p_init_msg_list => fnd_api.g_false
90: , x_return_status => l_return_status
91: , p_flag_name => 'Enabled_Flag'
92: , p_flag_value => l_enabled_flag
93: );

Line 95: IF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN

91: , p_flag_name => 'Enabled_Flag'
92: , p_flag_value => l_enabled_flag
93: );
94:
95: IF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
96: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_FLAG');
97: fnd_message.set_token('ENABLED_FLAG', p_enabled_flag);
98: RAISE fnd_api.g_exc_unexpected_error;
99: END IF;

Line 98: RAISE fnd_api.g_exc_unexpected_error;

94:
95: IF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
96: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_FLAG');
97: fnd_message.set_token('ENABLED_FLAG', p_enabled_flag);
98: RAISE fnd_api.g_exc_unexpected_error;
99: END IF;
100:
101: ---- if Enabled flag is null,Task is not Active
102:

Line 106: IF (p_task_template_id <> fnd_api.g_miss_num OR p_task_template_name <> fnd_api.g_miss_char) THEN

102:
103: --Validations for Task_id ,Task_template_id and task_type _id
104: --based on the status of P_ENABLED_FLAG
105: IF l_enabled_flag IN(jtf_task_utl.g_yes, jtf_task_utl.g_no) THEN
106: IF (p_task_template_id <> fnd_api.g_miss_num OR p_task_template_name <> fnd_api.g_miss_char) THEN
107: SELECT DECODE(p_task_template_id, fnd_api.g_miss_num, NULL, p_task_template_id)
108: INTO l_task_template_id
109: FROM DUAL;
110:

Line 107: SELECT DECODE(p_task_template_id, fnd_api.g_miss_num, NULL, p_task_template_id)

103: --Validations for Task_id ,Task_template_id and task_type _id
104: --based on the status of P_ENABLED_FLAG
105: IF l_enabled_flag IN(jtf_task_utl.g_yes, jtf_task_utl.g_no) THEN
106: IF (p_task_template_id <> fnd_api.g_miss_num OR p_task_template_name <> fnd_api.g_miss_char) THEN
107: SELECT DECODE(p_task_template_id, fnd_api.g_miss_num, NULL, p_task_template_id)
108: INTO l_task_template_id
109: FROM DUAL;
110:
111: jtf_task_resources_pvt.validate_task_template(

Line 119: IF (l_return_status = fnd_api.g_ret_sts_error) THEN

115: , x_task_template_id => l_task_template_id
116: , x_task_name => l_task_template_name
117: );
118:
119: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
120: RAISE fnd_api.g_exc_error;
121: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
122: RAISE fnd_api.g_exc_unexpected_error;
123: END IF;

Line 120: RAISE fnd_api.g_exc_error;

116: , x_task_name => l_task_template_name
117: );
118:
119: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
120: RAISE fnd_api.g_exc_error;
121: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
122: RAISE fnd_api.g_exc_unexpected_error;
123: END IF;
124: ELSIF(

Line 121: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN

117: );
118:
119: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
120: RAISE fnd_api.g_exc_error;
121: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
122: RAISE fnd_api.g_exc_unexpected_error;
123: END IF;
124: ELSIF(
125: p_task_id <> fnd_api.g_miss_num

Line 122: RAISE fnd_api.g_exc_unexpected_error;

118:
119: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
120: RAISE fnd_api.g_exc_error;
121: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
122: RAISE fnd_api.g_exc_unexpected_error;
123: END IF;
124: ELSIF(
125: p_task_id <> fnd_api.g_miss_num
126: OR p_task_name <> fnd_api.g_miss_char

Line 125: p_task_id <> fnd_api.g_miss_num

121: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
122: RAISE fnd_api.g_exc_unexpected_error;
123: END IF;
124: ELSIF(
125: p_task_id <> fnd_api.g_miss_num
126: OR p_task_name <> fnd_api.g_miss_char
127: OR p_task_number <> fnd_api.g_miss_char
128: ) THEN
129: SELECT DECODE(p_task_id, fnd_api.g_miss_num, NULL, p_task_id)

Line 126: OR p_task_name <> fnd_api.g_miss_char

122: RAISE fnd_api.g_exc_unexpected_error;
123: END IF;
124: ELSIF(
125: p_task_id <> fnd_api.g_miss_num
126: OR p_task_name <> fnd_api.g_miss_char
127: OR p_task_number <> fnd_api.g_miss_char
128: ) THEN
129: SELECT DECODE(p_task_id, fnd_api.g_miss_num, NULL, p_task_id)
130: INTO l_task_id

Line 127: OR p_task_number <> fnd_api.g_miss_char

123: END IF;
124: ELSIF(
125: p_task_id <> fnd_api.g_miss_num
126: OR p_task_name <> fnd_api.g_miss_char
127: OR p_task_number <> fnd_api.g_miss_char
128: ) THEN
129: SELECT DECODE(p_task_id, fnd_api.g_miss_num, NULL, p_task_id)
130: INTO l_task_id
131: FROM DUAL;

Line 129: SELECT DECODE(p_task_id, fnd_api.g_miss_num, NULL, p_task_id)

125: p_task_id <> fnd_api.g_miss_num
126: OR p_task_name <> fnd_api.g_miss_char
127: OR p_task_number <> fnd_api.g_miss_char
128: ) THEN
129: SELECT DECODE(p_task_id, fnd_api.g_miss_num, NULL, p_task_id)
130: INTO l_task_id
131: FROM DUAL;
132:
133: SELECT DECODE(p_task_number, fnd_api.g_miss_char, NULL, p_task_number)

Line 133: SELECT DECODE(p_task_number, fnd_api.g_miss_char, NULL, p_task_number)

129: SELECT DECODE(p_task_id, fnd_api.g_miss_num, NULL, p_task_id)
130: INTO l_task_id
131: FROM DUAL;
132:
133: SELECT DECODE(p_task_number, fnd_api.g_miss_char, NULL, p_task_number)
134: INTO l_task_number
135: FROM DUAL;
136:
137: jtf_task_utl.validate_task(

Line 144: IF (l_return_status = fnd_api.g_ret_sts_error) THEN

140: , p_task_number => l_task_number
141: , x_task_id => l_task_id
142: );
143:
144: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
145: RAISE fnd_api.g_exc_error;
146: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
147: RAISE fnd_api.g_exc_unexpected_error;
148: END IF;

Line 145: RAISE fnd_api.g_exc_error;

141: , x_task_id => l_task_id
142: );
143:
144: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
145: RAISE fnd_api.g_exc_error;
146: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
147: RAISE fnd_api.g_exc_unexpected_error;
148: END IF;
149:

Line 146: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN

142: );
143:
144: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
145: RAISE fnd_api.g_exc_error;
146: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
147: RAISE fnd_api.g_exc_unexpected_error;
148: END IF;
149:
150: IF l_task_id IS NULL THEN

Line 147: RAISE fnd_api.g_exc_unexpected_error;

143:
144: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
145: RAISE fnd_api.g_exc_error;
146: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
147: RAISE fnd_api.g_exc_unexpected_error;
148: END IF;
149:
150: IF l_task_id IS NULL THEN
151: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 151: x_return_status := fnd_api.g_ret_sts_unexp_error;

147: RAISE fnd_api.g_exc_unexpected_error;
148: END IF;
149:
150: IF l_task_id IS NULL THEN
151: x_return_status := fnd_api.g_ret_sts_unexp_error;
152: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_TASK_ID');
153: fnd_message.set_token('TASK_ID', p_task_id);
154: fnd_msg_pub.ADD;
155: RAISE fnd_api.g_exc_unexpected_error;

Line 155: RAISE fnd_api.g_exc_unexpected_error;

151: x_return_status := fnd_api.g_ret_sts_unexp_error;
152: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_TASK_ID');
153: fnd_message.set_token('TASK_ID', p_task_id);
154: fnd_msg_pub.ADD;
155: RAISE fnd_api.g_exc_unexpected_error;
156: END IF;
157: ELSIF(p_task_type_id <> fnd_api.g_miss_num OR p_task_type_name <> fnd_api.g_miss_char) THEN
158: SELECT DECODE(p_task_type_id, fnd_api.g_miss_num, NULL, p_task_type_id)
159: INTO l_task_type_id

Line 157: ELSIF(p_task_type_id <> fnd_api.g_miss_num OR p_task_type_name <> fnd_api.g_miss_char) THEN

153: fnd_message.set_token('TASK_ID', p_task_id);
154: fnd_msg_pub.ADD;
155: RAISE fnd_api.g_exc_unexpected_error;
156: END IF;
157: ELSIF(p_task_type_id <> fnd_api.g_miss_num OR p_task_type_name <> fnd_api.g_miss_char) THEN
158: SELECT DECODE(p_task_type_id, fnd_api.g_miss_num, NULL, p_task_type_id)
159: INTO l_task_type_id
160: FROM DUAL;
161:

Line 158: SELECT DECODE(p_task_type_id, fnd_api.g_miss_num, NULL, p_task_type_id)

154: fnd_msg_pub.ADD;
155: RAISE fnd_api.g_exc_unexpected_error;
156: END IF;
157: ELSIF(p_task_type_id <> fnd_api.g_miss_num OR p_task_type_name <> fnd_api.g_miss_char) THEN
158: SELECT DECODE(p_task_type_id, fnd_api.g_miss_num, NULL, p_task_type_id)
159: INTO l_task_type_id
160: FROM DUAL;
161:
162: SELECT DECODE(p_task_type_name, fnd_api.g_miss_char, NULL, p_task_type_name)

Line 162: SELECT DECODE(p_task_type_name, fnd_api.g_miss_char, NULL, p_task_type_name)

158: SELECT DECODE(p_task_type_id, fnd_api.g_miss_num, NULL, p_task_type_id)
159: INTO l_task_type_id
160: FROM DUAL;
161:
162: SELECT DECODE(p_task_type_name, fnd_api.g_miss_char, NULL, p_task_type_name)
163: INTO l_task_type_name
164: FROM DUAL;
165:
166: jtf_task_resources_pvt.validate_task_type(

Line 174: IF (l_return_status = fnd_api.g_ret_sts_error) THEN

170: , x_task_type_id => l_task_type_id
171: , x_task_name => l_task_type_name
172: );
173:
174: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
175: RAISE fnd_api.g_exc_error;
176: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
177: RAISE fnd_api.g_exc_unexpected_error;
178: END IF;

Line 175: RAISE fnd_api.g_exc_error;

171: , x_task_name => l_task_type_name
172: );
173:
174: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
175: RAISE fnd_api.g_exc_error;
176: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
177: RAISE fnd_api.g_exc_unexpected_error;
178: END IF;
179:

Line 176: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN

172: );
173:
174: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
175: RAISE fnd_api.g_exc_error;
176: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
177: RAISE fnd_api.g_exc_unexpected_error;
178: END IF;
179:
180: IF l_task_type_id IS NULL THEN

Line 177: RAISE fnd_api.g_exc_unexpected_error;

173:
174: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
175: RAISE fnd_api.g_exc_error;
176: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
177: RAISE fnd_api.g_exc_unexpected_error;
178: END IF;
179:
180: IF l_task_type_id IS NULL THEN
181: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 181: x_return_status := fnd_api.g_ret_sts_unexp_error;

177: RAISE fnd_api.g_exc_unexpected_error;
178: END IF;
179:
180: IF l_task_type_id IS NULL THEN
181: x_return_status := fnd_api.g_ret_sts_unexp_error;
182: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_TYPE_ID');
183: fnd_message.set_token('TASK_ID', p_task_type_id);
184: fnd_msg_pub.ADD;
185: RAISE fnd_api.g_exc_unexpected_error;

Line 185: RAISE fnd_api.g_exc_unexpected_error;

181: x_return_status := fnd_api.g_ret_sts_unexp_error;
182: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_TYPE_ID');
183: fnd_message.set_token('TASK_ID', p_task_type_id);
184: fnd_msg_pub.ADD;
185: RAISE fnd_api.g_exc_unexpected_error;
186: END IF;
187: ELSIF (l_task_template_id IS NULL) AND(l_task_id IS NULL) AND(l_task_type_id IS NULL) THEN
188: x_return_status := fnd_api.g_ret_sts_unexp_error;
189: fnd_message.set_name('JTF', 'JTF_TASK_INV_INPUT');

Line 188: x_return_status := fnd_api.g_ret_sts_unexp_error;

184: fnd_msg_pub.ADD;
185: RAISE fnd_api.g_exc_unexpected_error;
186: END IF;
187: ELSIF (l_task_template_id IS NULL) AND(l_task_id IS NULL) AND(l_task_type_id IS NULL) THEN
188: x_return_status := fnd_api.g_ret_sts_unexp_error;
189: fnd_message.set_name('JTF', 'JTF_TASK_INV_INPUT');
190: fnd_msg_pub.ADD;
191: RAISE fnd_api.g_exc_unexpected_error;
192: ELSIF (l_task_template_id IS NOT NULL)

Line 191: RAISE fnd_api.g_exc_unexpected_error;

187: ELSIF (l_task_template_id IS NULL) AND(l_task_id IS NULL) AND(l_task_type_id IS NULL) THEN
188: x_return_status := fnd_api.g_ret_sts_unexp_error;
189: fnd_message.set_name('JTF', 'JTF_TASK_INV_INPUT');
190: fnd_msg_pub.ADD;
191: RAISE fnd_api.g_exc_unexpected_error;
192: ELSIF (l_task_template_id IS NOT NULL)
193: AND (l_task_id IS NOT NULL)
194: AND (l_task_type_id IS NOT NULL) THEN
195: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 195: x_return_status := fnd_api.g_ret_sts_unexp_error;

191: RAISE fnd_api.g_exc_unexpected_error;
192: ELSIF (l_task_template_id IS NOT NULL)
193: AND (l_task_id IS NOT NULL)
194: AND (l_task_type_id IS NOT NULL) THEN
195: x_return_status := fnd_api.g_ret_sts_unexp_error;
196: fnd_message.set_name('JTF', 'JTF_TASK_INV_INPUT');
197: fnd_msg_pub.ADD;
198: RAISE fnd_api.g_exc_unexpected_error;
199: ELSIF (l_task_template_id IS NOT NULL) AND(l_task_id IS NOT NULL) THEN

Line 198: RAISE fnd_api.g_exc_unexpected_error;

194: AND (l_task_type_id IS NOT NULL) THEN
195: x_return_status := fnd_api.g_ret_sts_unexp_error;
196: fnd_message.set_name('JTF', 'JTF_TASK_INV_INPUT');
197: fnd_msg_pub.ADD;
198: RAISE fnd_api.g_exc_unexpected_error;
199: ELSIF (l_task_template_id IS NOT NULL) AND(l_task_id IS NOT NULL) THEN
200: x_return_status := fnd_api.g_ret_sts_unexp_error;
201: fnd_message.set_name('JTF', 'JTF_TASK_INV_INPUT');
202: fnd_msg_pub.ADD;

Line 200: x_return_status := fnd_api.g_ret_sts_unexp_error;

196: fnd_message.set_name('JTF', 'JTF_TASK_INV_INPUT');
197: fnd_msg_pub.ADD;
198: RAISE fnd_api.g_exc_unexpected_error;
199: ELSIF (l_task_template_id IS NOT NULL) AND(l_task_id IS NOT NULL) THEN
200: x_return_status := fnd_api.g_ret_sts_unexp_error;
201: fnd_message.set_name('JTF', 'JTF_TASK_INV_INPUT');
202: fnd_msg_pub.ADD;
203: RAISE fnd_api.g_exc_unexpected_error;
204: ELSIF (l_task_id IS NOT NULL) AND(l_task_type_id IS NOT NULL) THEN

Line 203: RAISE fnd_api.g_exc_unexpected_error;

199: ELSIF (l_task_template_id IS NOT NULL) AND(l_task_id IS NOT NULL) THEN
200: x_return_status := fnd_api.g_ret_sts_unexp_error;
201: fnd_message.set_name('JTF', 'JTF_TASK_INV_INPUT');
202: fnd_msg_pub.ADD;
203: RAISE fnd_api.g_exc_unexpected_error;
204: ELSIF (l_task_id IS NOT NULL) AND(l_task_type_id IS NOT NULL) THEN
205: x_return_status := fnd_api.g_ret_sts_unexp_error;
206: fnd_message.set_name('JTF', 'JTF_TASK_INV_INPUT');
207: fnd_msg_pub.ADD;

Line 205: x_return_status := fnd_api.g_ret_sts_unexp_error;

201: fnd_message.set_name('JTF', 'JTF_TASK_INV_INPUT');
202: fnd_msg_pub.ADD;
203: RAISE fnd_api.g_exc_unexpected_error;
204: ELSIF (l_task_id IS NOT NULL) AND(l_task_type_id IS NOT NULL) THEN
205: x_return_status := fnd_api.g_ret_sts_unexp_error;
206: fnd_message.set_name('JTF', 'JTF_TASK_INV_INPUT');
207: fnd_msg_pub.ADD;
208: RAISE fnd_api.g_exc_unexpected_error;
209: ELSIF (l_task_template_id IS NOT NULL) AND(l_task_type_id IS NOT NULL) THEN

Line 208: RAISE fnd_api.g_exc_unexpected_error;

204: ELSIF (l_task_id IS NOT NULL) AND(l_task_type_id IS NOT NULL) THEN
205: x_return_status := fnd_api.g_ret_sts_unexp_error;
206: fnd_message.set_name('JTF', 'JTF_TASK_INV_INPUT');
207: fnd_msg_pub.ADD;
208: RAISE fnd_api.g_exc_unexpected_error;
209: ELSIF (l_task_template_id IS NOT NULL) AND(l_task_type_id IS NOT NULL) THEN
210: x_return_status := fnd_api.g_ret_sts_unexp_error;
211: fnd_message.set_name('JTF', 'JTF_TASK_INV_INPUT');
212: fnd_msg_pub.ADD;

Line 210: x_return_status := fnd_api.g_ret_sts_unexp_error;

206: fnd_message.set_name('JTF', 'JTF_TASK_INV_INPUT');
207: fnd_msg_pub.ADD;
208: RAISE fnd_api.g_exc_unexpected_error;
209: ELSIF (l_task_template_id IS NOT NULL) AND(l_task_type_id IS NOT NULL) THEN
210: x_return_status := fnd_api.g_ret_sts_unexp_error;
211: fnd_message.set_name('JTF', 'JTF_TASK_INV_INPUT');
212: fnd_msg_pub.ADD;
213: RAISE fnd_api.g_exc_unexpected_error;
214: END IF;

Line 213: RAISE fnd_api.g_exc_unexpected_error;

209: ELSIF (l_task_template_id IS NOT NULL) AND(l_task_type_id IS NOT NULL) THEN
210: x_return_status := fnd_api.g_ret_sts_unexp_error;
211: fnd_message.set_name('JTF', 'JTF_TASK_INV_INPUT');
212: fnd_msg_pub.ADD;
213: RAISE fnd_api.g_exc_unexpected_error;
214: END IF;
215:
216: IF NOT jtf_task_resources_pvt.validate_resource_type_code(p_resource_type_code => l_resource_type_code) THEN
217: fnd_message.set_name('JTF', 'JTF_TASK_INV_RES_TYP_COD');

Line 220: RAISE fnd_api.g_exc_error;

216: IF NOT jtf_task_resources_pvt.validate_resource_type_code(p_resource_type_code => l_resource_type_code) THEN
217: fnd_message.set_name('JTF', 'JTF_TASK_INV_RES_TYP_COD');
218: fnd_message.set_token('RESOURCE_CODE', p_resource_type_code);
219: --fnd_msg.add;
220: RAISE fnd_api.g_exc_error;
221: END IF;
222:
223: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
224: fnd_message.set_name('JTF', 'JTF_TASK_INV_RES_TYP_COD');

Line 223: IF (l_return_status = fnd_api.g_ret_sts_error) THEN

219: --fnd_msg.add;
220: RAISE fnd_api.g_exc_error;
221: END IF;
222:
223: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
224: fnd_message.set_name('JTF', 'JTF_TASK_INV_RES_TYP_COD');
225: fnd_message.set_token('RESOURCE_CODE', p_resource_type_code);
226: --fnd_msg.add;
227: RAISE fnd_api.g_exc_error;

Line 227: RAISE fnd_api.g_exc_error;

223: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
224: fnd_message.set_name('JTF', 'JTF_TASK_INV_RES_TYP_COD');
225: fnd_message.set_token('RESOURCE_CODE', p_resource_type_code);
226: --fnd_msg.add;
227: RAISE fnd_api.g_exc_error;
228: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
229: fnd_message.set_name('JTF', 'JTF_TASK_INV_RES_TYP_COD');
230: fnd_message.set_token('RESOURCE_CODE', p_resource_type_code);
231: --fnd_msg.add;

Line 228: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN

224: fnd_message.set_name('JTF', 'JTF_TASK_INV_RES_TYP_COD');
225: fnd_message.set_token('RESOURCE_CODE', p_resource_type_code);
226: --fnd_msg.add;
227: RAISE fnd_api.g_exc_error;
228: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
229: fnd_message.set_name('JTF', 'JTF_TASK_INV_RES_TYP_COD');
230: fnd_message.set_token('RESOURCE_CODE', p_resource_type_code);
231: --fnd_msg.add;
232: RAISE fnd_api.g_exc_unexpected_error;

Line 232: RAISE fnd_api.g_exc_unexpected_error;

228: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
229: fnd_message.set_name('JTF', 'JTF_TASK_INV_RES_TYP_COD');
230: fnd_message.set_token('RESOURCE_CODE', p_resource_type_code);
231: --fnd_msg.add;
232: RAISE fnd_api.g_exc_unexpected_error;
233: END IF;
234:
235: --Call to private API to insert into JTF_TASK_RESOURCE_REQ
236: jtf_task_resources_pvt.create_task_rsrc_req(

Line 238: , p_init_msg_list => fnd_api.g_false

234:
235: --Call to private API to insert into JTF_TASK_RESOURCE_REQ
236: jtf_task_resources_pvt.create_task_rsrc_req(
237: p_api_version => l_api_version
238: , p_init_msg_list => fnd_api.g_false
239: , p_commit => fnd_api.g_false
240: , p_task_id => l_task_id
241: , p_task_name => l_task_name
242: , p_task_number => l_task_number

Line 239: , p_commit => fnd_api.g_false

235: --Call to private API to insert into JTF_TASK_RESOURCE_REQ
236: jtf_task_resources_pvt.create_task_rsrc_req(
237: p_api_version => l_api_version
238: , p_init_msg_list => fnd_api.g_false
239: , p_commit => fnd_api.g_false
240: , p_task_id => l_task_id
241: , p_task_name => l_task_name
242: , p_task_number => l_task_number
243: , p_task_type_id => l_task_type_id

Line 273: IF (l_return_status = fnd_api.g_ret_sts_error) THEN

269: , p_attribute_category => p_attribute_category
270: );
271: END IF;
272:
273: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
274: RAISE fnd_api.g_exc_error;
275: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
276: RAISE fnd_api.g_exc_unexpected_error;
277: END IF;

Line 274: RAISE fnd_api.g_exc_error;

270: );
271: END IF;
272:
273: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
274: RAISE fnd_api.g_exc_error;
275: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
276: RAISE fnd_api.g_exc_unexpected_error;
277: END IF;
278:

Line 275: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN

271: END IF;
272:
273: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
274: RAISE fnd_api.g_exc_error;
275: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
276: RAISE fnd_api.g_exc_unexpected_error;
277: END IF;
278:
279: IF fnd_api.to_boolean(p_commit) THEN

Line 276: RAISE fnd_api.g_exc_unexpected_error;

272:
273: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
274: RAISE fnd_api.g_exc_error;
275: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
276: RAISE fnd_api.g_exc_unexpected_error;
277: END IF;
278:
279: IF fnd_api.to_boolean(p_commit) THEN
280: COMMIT WORK;

Line 279: IF fnd_api.to_boolean(p_commit) THEN

275: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
276: RAISE fnd_api.g_exc_unexpected_error;
277: END IF;
278:
279: IF fnd_api.to_boolean(p_commit) THEN
280: COMMIT WORK;
281: END IF;
282:
283: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 285: WHEN fnd_api.g_exc_error THEN

281: END IF;
282:
283: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
284: EXCEPTION
285: WHEN fnd_api.g_exc_error THEN
286: ROLLBACK TO create_task_rsrc_req;
287: x_return_status := fnd_api.g_ret_sts_error;
288: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
289: WHEN fnd_api.g_exc_unexpected_error THEN

Line 287: x_return_status := fnd_api.g_ret_sts_error;

283: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
284: EXCEPTION
285: WHEN fnd_api.g_exc_error THEN
286: ROLLBACK TO create_task_rsrc_req;
287: x_return_status := fnd_api.g_ret_sts_error;
288: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
289: WHEN fnd_api.g_exc_unexpected_error THEN
290: ROLLBACK TO create_task_rsrc_req;
291: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 289: WHEN fnd_api.g_exc_unexpected_error THEN

285: WHEN fnd_api.g_exc_error THEN
286: ROLLBACK TO create_task_rsrc_req;
287: x_return_status := fnd_api.g_ret_sts_error;
288: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
289: WHEN fnd_api.g_exc_unexpected_error THEN
290: ROLLBACK TO create_task_rsrc_req;
291: x_return_status := fnd_api.g_ret_sts_unexp_error;
292: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
293: WHEN OTHERS THEN

Line 291: x_return_status := fnd_api.g_ret_sts_unexp_error;

287: x_return_status := fnd_api.g_ret_sts_error;
288: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
289: WHEN fnd_api.g_exc_unexpected_error THEN
290: ROLLBACK TO create_task_rsrc_req;
291: x_return_status := fnd_api.g_ret_sts_unexp_error;
292: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
293: WHEN OTHERS THEN
294: ROLLBACK TO create_task_rsrc_req;
295: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 295: x_return_status := fnd_api.g_ret_sts_unexp_error;

291: x_return_status := fnd_api.g_ret_sts_unexp_error;
292: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
293: WHEN OTHERS THEN
294: ROLLBACK TO create_task_rsrc_req;
295: x_return_status := fnd_api.g_ret_sts_unexp_error;
296: /* if fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error )
297: then
298: fnd_msg_pub.add_exc_msg(g_pkg_name,l_api_name) ;
299: end if ;*/

Line 307: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false

303: --Procedure to Update the Task Resource Requirements
304: PROCEDURE update_task_rscr_req(
305: p_api_version IN NUMBER
306: , p_object_version_number IN OUT NOCOPY NUMBER
307: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
308: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
309: , p_resource_req_id IN NUMBER
310: , p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
311: , p_task_name IN VARCHAR2 DEFAULT NULL

Line 308: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false

304: PROCEDURE update_task_rscr_req(
305: p_api_version IN NUMBER
306: , p_object_version_number IN OUT NOCOPY NUMBER
307: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
308: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
309: , p_resource_req_id IN NUMBER
310: , p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
311: , p_task_name IN VARCHAR2 DEFAULT NULL
312: , p_task_number IN VARCHAR2 DEFAULT NULL

Line 310: , p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num

306: , p_object_version_number IN OUT NOCOPY NUMBER
307: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
308: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
309: , p_resource_req_id IN NUMBER
310: , p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
311: , p_task_name IN VARCHAR2 DEFAULT NULL
312: , p_task_number IN VARCHAR2 DEFAULT NULL
313: , p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num
314: , p_task_type_name IN VARCHAR2 DEFAULT NULL

Line 313: , p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num

309: , p_resource_req_id IN NUMBER
310: , p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
311: , p_task_name IN VARCHAR2 DEFAULT NULL
312: , p_task_number IN VARCHAR2 DEFAULT NULL
313: , p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num
314: , p_task_type_name IN VARCHAR2 DEFAULT NULL
315: , p_task_template_id IN NUMBER DEFAULT fnd_api.g_miss_num
316: , p_task_template_name IN VARCHAR2 DEFAULT NULL
317: , p_resource_type_code IN VARCHAR2

Line 315: , p_task_template_id IN NUMBER DEFAULT fnd_api.g_miss_num

311: , p_task_name IN VARCHAR2 DEFAULT NULL
312: , p_task_number IN VARCHAR2 DEFAULT NULL
313: , p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num
314: , p_task_type_name IN VARCHAR2 DEFAULT NULL
315: , p_task_template_id IN NUMBER DEFAULT fnd_api.g_miss_num
316: , p_task_template_name IN VARCHAR2 DEFAULT NULL
317: , p_resource_type_code IN VARCHAR2
318: , p_required_units IN NUMBER
319: , p_enabled_flag IN VARCHAR2 DEFAULT jtf_task_utl.g_no

Line 342: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

338: , p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
339: ) IS
340: l_api_version CONSTANT NUMBER := 1.0;
341: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TASK_RSRC_REQ';
342: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
343: l_task_id jtf_tasks_b.task_id%TYPE := p_task_id;
344: l_task_number jtf_tasks_b.task_number%TYPE := p_task_number;
345: l_task_name jtf_tasks_tl.task_name%TYPE := p_task_name;
346: l_task_type_id jtf_task_types_b.task_type_id%TYPE := p_task_type_id;

Line 360: SELECT DECODE(p_task_id, fnd_api.g_miss_num, task_id, p_task_id) task_id

356: l_resource_req_id NUMBER := p_resource_req_id;
357: l_rowid ROWID;
358:
359: CURSOR jtf_rsrc_req_cur IS
360: SELECT DECODE(p_task_id, fnd_api.g_miss_num, task_id, p_task_id) task_id
361: , DECODE(p_task_template_id, fnd_api.g_miss_num, task_template_id, p_task_template_id)
362: task_template_id
363: , p_task_type_id task_type_id
364: , p_resource_type_code resource_type_code

Line 361: , DECODE(p_task_template_id, fnd_api.g_miss_num, task_template_id, p_task_template_id)

357: l_rowid ROWID;
358:
359: CURSOR jtf_rsrc_req_cur IS
360: SELECT DECODE(p_task_id, fnd_api.g_miss_num, task_id, p_task_id) task_id
361: , DECODE(p_task_template_id, fnd_api.g_miss_num, task_template_id, p_task_template_id)
362: task_template_id
363: , p_task_type_id task_type_id
364: , p_resource_type_code resource_type_code
365: , p_required_units required_units

Line 367: , DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) attribute1

363: , p_task_type_id task_type_id
364: , p_resource_type_code resource_type_code
365: , p_required_units required_units
366: , enabled_flag
367: , DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) attribute1
368: , DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) attribute2
369: , DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) attribute3
370: , DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) attribute4
371: , DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) attribute5

Line 368: , DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) attribute2

364: , p_resource_type_code resource_type_code
365: , p_required_units required_units
366: , enabled_flag
367: , DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) attribute1
368: , DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) attribute2
369: , DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) attribute3
370: , DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) attribute4
371: , DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) attribute5
372: , DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) attribute6

Line 369: , DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) attribute3

365: , p_required_units required_units
366: , enabled_flag
367: , DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) attribute1
368: , DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) attribute2
369: , DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) attribute3
370: , DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) attribute4
371: , DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) attribute5
372: , DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) attribute6
373: , DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) attribute7

Line 370: , DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) attribute4

366: , enabled_flag
367: , DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) attribute1
368: , DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) attribute2
369: , DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) attribute3
370: , DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) attribute4
371: , DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) attribute5
372: , DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) attribute6
373: , DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) attribute7
374: , DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) attribute8

Line 371: , DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) attribute5

367: , DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) attribute1
368: , DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) attribute2
369: , DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) attribute3
370: , DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) attribute4
371: , DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) attribute5
372: , DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) attribute6
373: , DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) attribute7
374: , DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) attribute8
375: , DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) attribute9

Line 372: , DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) attribute6

368: , DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) attribute2
369: , DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) attribute3
370: , DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) attribute4
371: , DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) attribute5
372: , DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) attribute6
373: , DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) attribute7
374: , DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) attribute8
375: , DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) attribute9
376: , DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) attribute10

Line 373: , DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) attribute7

369: , DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) attribute3
370: , DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) attribute4
371: , DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) attribute5
372: , DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) attribute6
373: , DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) attribute7
374: , DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) attribute8
375: , DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) attribute9
376: , DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) attribute10
377: , DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) attribute11

Line 374: , DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) attribute8

370: , DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) attribute4
371: , DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) attribute5
372: , DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) attribute6
373: , DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) attribute7
374: , DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) attribute8
375: , DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) attribute9
376: , DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) attribute10
377: , DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) attribute11
378: , DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) attribute12

Line 375: , DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) attribute9

371: , DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) attribute5
372: , DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) attribute6
373: , DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) attribute7
374: , DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) attribute8
375: , DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) attribute9
376: , DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) attribute10
377: , DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) attribute11
378: , DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) attribute12
379: , DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) attribute13

Line 376: , DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) attribute10

372: , DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) attribute6
373: , DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) attribute7
374: , DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) attribute8
375: , DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) attribute9
376: , DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) attribute10
377: , DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) attribute11
378: , DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) attribute12
379: , DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) attribute13
380: , DECODE(p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14) attribute14

Line 377: , DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) attribute11

373: , DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) attribute7
374: , DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) attribute8
375: , DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) attribute9
376: , DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) attribute10
377: , DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) attribute11
378: , DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) attribute12
379: , DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) attribute13
380: , DECODE(p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14) attribute14
381: , DECODE(p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15) attribute15

Line 378: , DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) attribute12

374: , DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) attribute8
375: , DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) attribute9
376: , DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) attribute10
377: , DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) attribute11
378: , DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) attribute12
379: , DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) attribute13
380: , DECODE(p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14) attribute14
381: , DECODE(p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15) attribute15
382: , DECODE(

Line 379: , DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) attribute13

375: , DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) attribute9
376: , DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) attribute10
377: , DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) attribute11
378: , DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) attribute12
379: , DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) attribute13
380: , DECODE(p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14) attribute14
381: , DECODE(p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15) attribute15
382: , DECODE(
383: p_attribute_category

Line 380: , DECODE(p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14) attribute14

376: , DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) attribute10
377: , DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) attribute11
378: , DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) attribute12
379: , DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) attribute13
380: , DECODE(p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14) attribute14
381: , DECODE(p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15) attribute15
382: , DECODE(
383: p_attribute_category
384: , fnd_api.g_miss_char, attribute_category

Line 381: , DECODE(p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15) attribute15

377: , DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) attribute11
378: , DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) attribute12
379: , DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) attribute13
380: , DECODE(p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14) attribute14
381: , DECODE(p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15) attribute15
382: , DECODE(
383: p_attribute_category
384: , fnd_api.g_miss_char, attribute_category
385: , p_attribute_category

Line 384: , fnd_api.g_miss_char, attribute_category

380: , DECODE(p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14) attribute14
381: , DECODE(p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15) attribute15
382: , DECODE(
383: p_attribute_category
384: , fnd_api.g_miss_char, attribute_category
385: , p_attribute_category
386: ) attribute_category
387: FROM jtf_task_rsc_reqs
388: WHERE resource_req_id = p_resource_req_id;

Line 393: x_return_status := fnd_api.g_ret_sts_success;

389:
390: task_rsrc_req_rec jtf_rsrc_req_cur%ROWTYPE;
391: BEGIN
392: SAVEPOINT update_task_rsrc_req;
393: x_return_status := fnd_api.g_ret_sts_success;
394:
395: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
396: RAISE fnd_api.g_exc_unexpected_error;
397: END IF;

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

391: BEGIN
392: SAVEPOINT update_task_rsrc_req;
393: x_return_status := fnd_api.g_ret_sts_success;
394:
395: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
396: RAISE fnd_api.g_exc_unexpected_error;
397: END IF;
398:
399: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 396: RAISE fnd_api.g_exc_unexpected_error;

392: SAVEPOINT update_task_rsrc_req;
393: x_return_status := fnd_api.g_ret_sts_success;
394:
395: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
396: RAISE fnd_api.g_exc_unexpected_error;
397: END IF;
398:
399: IF fnd_api.to_boolean(p_init_msg_list) THEN
400: fnd_msg_pub.initialize;

Line 399: IF fnd_api.to_boolean(p_init_msg_list) THEN

395: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
396: RAISE fnd_api.g_exc_unexpected_error;
397: END IF;
398:
399: IF fnd_api.to_boolean(p_init_msg_list) THEN
400: fnd_msg_pub.initialize;
401: END IF;
402:
403: -- check if the resource requirement is invalid or null.

Line 407: x_return_status := fnd_api.g_ret_sts_unexp_error;

403: -- check if the resource requirement is invalid or null.
404: IF (l_resource_req_id IS NULL) THEN
405: fnd_message.set_name('JTF', 'JTF_TASK_NULL_RES_REQ_ID');
406: fnd_msg_pub.ADD;
407: x_return_status := fnd_api.g_ret_sts_unexp_error;
408: RAISE fnd_api.g_exc_unexpected_error;
409: END IF;
410:
411: OPEN jtf_rsrc_req_cur;

Line 408: RAISE fnd_api.g_exc_unexpected_error;

404: IF (l_resource_req_id IS NULL) THEN
405: fnd_message.set_name('JTF', 'JTF_TASK_NULL_RES_REQ_ID');
406: fnd_msg_pub.ADD;
407: x_return_status := fnd_api.g_ret_sts_unexp_error;
408: RAISE fnd_api.g_exc_unexpected_error;
409: END IF;
410:
411: OPEN jtf_rsrc_req_cur;
412:

Line 420: x_return_status := fnd_api.g_ret_sts_unexp_error;

416: IF jtf_rsrc_req_cur%NOTFOUND THEN
417: fnd_message.set_name('JTF', 'JTF_TASK_INV_RES_REQ_ID');
418: fnd_message.set_token('RESOURCE_REQ_ID', p_resource_req_id);
419: fnd_msg_pub.ADD;
420: x_return_status := fnd_api.g_ret_sts_unexp_error;
421: RAISE fnd_api.g_exc_unexpected_error;
422: END IF;
423:
424: ---enabled_flag

Line 421: RAISE fnd_api.g_exc_unexpected_error;

417: fnd_message.set_name('JTF', 'JTF_TASK_INV_RES_REQ_ID');
418: fnd_message.set_token('RESOURCE_REQ_ID', p_resource_req_id);
419: fnd_msg_pub.ADD;
420: x_return_status := fnd_api.g_ret_sts_unexp_error;
421: RAISE fnd_api.g_exc_unexpected_error;
422: END IF;
423:
424: ---enabled_flag
425: l_enabled_flag := task_rsrc_req_rec.enabled_flag;

Line 428: IF NOT(p_task_id = fnd_api.g_miss_num AND p_task_number = fnd_api.g_miss_char) THEN

424: ---enabled_flag
425: l_enabled_flag := task_rsrc_req_rec.enabled_flag;
426:
427: --- Validating for the task
428: IF NOT(p_task_id = fnd_api.g_miss_num AND p_task_number = fnd_api.g_miss_char) THEN
429: SELECT DECODE(p_task_id, fnd_api.g_miss_num, NULL, p_task_id)
430: INTO l_task_id
431: FROM DUAL;
432:

Line 429: SELECT DECODE(p_task_id, fnd_api.g_miss_num, NULL, p_task_id)

425: l_enabled_flag := task_rsrc_req_rec.enabled_flag;
426:
427: --- Validating for the task
428: IF NOT(p_task_id = fnd_api.g_miss_num AND p_task_number = fnd_api.g_miss_char) THEN
429: SELECT DECODE(p_task_id, fnd_api.g_miss_num, NULL, p_task_id)
430: INTO l_task_id
431: FROM DUAL;
432:
433: SELECT DECODE(p_task_number, fnd_api.g_miss_char, NULL, p_task_number)

Line 433: SELECT DECODE(p_task_number, fnd_api.g_miss_char, NULL, p_task_number)

429: SELECT DECODE(p_task_id, fnd_api.g_miss_num, NULL, p_task_id)
430: INTO l_task_id
431: FROM DUAL;
432:
433: SELECT DECODE(p_task_number, fnd_api.g_miss_char, NULL, p_task_number)
434: INTO l_task_number
435: FROM DUAL;
436:
437: IF (l_enabled_flag = fnd_api.g_true) THEN

Line 437: IF (l_enabled_flag = fnd_api.g_true) THEN

433: SELECT DECODE(p_task_number, fnd_api.g_miss_char, NULL, p_task_number)
434: INTO l_task_number
435: FROM DUAL;
436:
437: IF (l_enabled_flag = fnd_api.g_true) THEN
438: ---- Here the task id is assigned null, if the task id is NOT input,
439: --- because then task number could be input.
440:
441: --- This means task id is being updated.

Line 457: IF (l_return_status = fnd_api.g_ret_sts_error) THEN

453: , x_task_id => l_task_template_id
454: );
455: END IF;
456:
457: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
458: RAISE fnd_api.g_exc_error;
459: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
460: RAISE fnd_api.g_exc_unexpected_error;
461: END IF;

Line 458: RAISE fnd_api.g_exc_error;

454: );
455: END IF;
456:
457: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
458: RAISE fnd_api.g_exc_error;
459: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
460: RAISE fnd_api.g_exc_unexpected_error;
461: END IF;
462:

Line 459: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN

455: END IF;
456:
457: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
458: RAISE fnd_api.g_exc_error;
459: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
460: RAISE fnd_api.g_exc_unexpected_error;
461: END IF;
462:
463: IF l_task_id IS NULL THEN

Line 460: RAISE fnd_api.g_exc_unexpected_error;

456:
457: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
458: RAISE fnd_api.g_exc_error;
459: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
460: RAISE fnd_api.g_exc_unexpected_error;
461: END IF;
462:
463: IF l_task_id IS NULL THEN
464: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 464: x_return_status := fnd_api.g_ret_sts_unexp_error;

460: RAISE fnd_api.g_exc_unexpected_error;
461: END IF;
462:
463: IF l_task_id IS NULL THEN
464: x_return_status := fnd_api.g_ret_sts_unexp_error;
465: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_TASK_ID');
466: fnd_message.set_token('TASK_ID', p_task_id);
467: fnd_msg_pub.ADD;
468: RAISE fnd_api.g_exc_unexpected_error;

Line 468: RAISE fnd_api.g_exc_unexpected_error;

464: x_return_status := fnd_api.g_ret_sts_unexp_error;
465: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_TASK_ID');
466: fnd_message.set_token('TASK_ID', p_task_id);
467: fnd_msg_pub.ADD;
468: RAISE fnd_api.g_exc_unexpected_error;
469: END IF;
470: ELSE
471: l_task_id := task_rsrc_req_rec.task_id;
472: END IF;

Line 476: , p_init_msg_list => fnd_api.g_false

472: END IF;
473:
474: jtf_task_resources_pub.lock_task_resources(
475: p_api_version => 1.0
476: , p_init_msg_list => fnd_api.g_false
477: , p_commit => fnd_api.g_false
478: , p_resource_requirement_id => l_resource_req_id
479: , p_object_version_number => p_object_version_number
480: , x_return_status => x_return_status

Line 477: , p_commit => fnd_api.g_false

473:
474: jtf_task_resources_pub.lock_task_resources(
475: p_api_version => 1.0
476: , p_init_msg_list => fnd_api.g_false
477: , p_commit => fnd_api.g_false
478: , p_resource_requirement_id => l_resource_req_id
479: , p_object_version_number => p_object_version_number
480: , x_return_status => x_return_status
481: , x_msg_data => x_msg_data

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

481: , x_msg_data => x_msg_data
482: , x_msg_count => x_msg_count
483: );
484:
485: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
486: x_return_status := fnd_api.g_ret_sts_unexp_error;
487: RAISE fnd_api.g_exc_unexpected_error;
488: END IF;
489:

Line 486: x_return_status := fnd_api.g_ret_sts_unexp_error;

482: , x_msg_count => x_msg_count
483: );
484:
485: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
486: x_return_status := fnd_api.g_ret_sts_unexp_error;
487: RAISE fnd_api.g_exc_unexpected_error;
488: END IF;
489:
490: jtf_task_resources_pvt.update_task_rscr_req

Line 487: RAISE fnd_api.g_exc_unexpected_error;

483: );
484:
485: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
486: x_return_status := fnd_api.g_ret_sts_unexp_error;
487: RAISE fnd_api.g_exc_unexpected_error;
488: END IF;
489:
490: jtf_task_resources_pvt.update_task_rscr_req
491: (

Line 494: , p_init_msg_list => fnd_api.g_false

490: jtf_task_resources_pvt.update_task_rscr_req
491: (
492: p_api_version => 1.0
493: , p_object_version_number => p_object_version_number
494: , p_init_msg_list => fnd_api.g_false
495: , p_commit => fnd_api.g_false
496: , p_resource_req_id => l_resource_req_id
497: , p_task_id => l_task_id
498: , p_task_name => l_task_name

Line 495: , p_commit => fnd_api.g_false

491: (
492: p_api_version => 1.0
493: , p_object_version_number => p_object_version_number
494: , p_init_msg_list => fnd_api.g_false
495: , p_commit => fnd_api.g_false
496: , p_resource_req_id => l_resource_req_id
497: , p_task_id => l_task_id
498: , p_task_name => l_task_name
499: , p_task_number => NULL

Line 528: IF (l_return_status = fnd_api.g_ret_sts_error) THEN

524: , p_attribute15 => task_rsrc_req_rec.attribute15
525: , p_attribute_category => task_rsrc_req_rec.attribute_category
526: );
527:
528: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
529: RAISE fnd_api.g_exc_error;
530: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
531: RAISE fnd_api.g_exc_unexpected_error;
532: END IF;

Line 529: RAISE fnd_api.g_exc_error;

525: , p_attribute_category => task_rsrc_req_rec.attribute_category
526: );
527:
528: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
529: RAISE fnd_api.g_exc_error;
530: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
531: RAISE fnd_api.g_exc_unexpected_error;
532: END IF;
533:

Line 530: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN

526: );
527:
528: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
529: RAISE fnd_api.g_exc_error;
530: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
531: RAISE fnd_api.g_exc_unexpected_error;
532: END IF;
533:
534: IF fnd_api.to_boolean(p_commit) THEN

Line 531: RAISE fnd_api.g_exc_unexpected_error;

527:
528: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
529: RAISE fnd_api.g_exc_error;
530: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
531: RAISE fnd_api.g_exc_unexpected_error;
532: END IF;
533:
534: IF fnd_api.to_boolean(p_commit) THEN
535: COMMIT WORK;

Line 534: IF fnd_api.to_boolean(p_commit) THEN

530: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
531: RAISE fnd_api.g_exc_unexpected_error;
532: END IF;
533:
534: IF fnd_api.to_boolean(p_commit) THEN
535: COMMIT WORK;
536: END IF;
537:
538: IF jtf_rsrc_req_cur%ISOPEN THEN

Line 544: WHEN fnd_api.g_exc_error THEN

540: END IF;
541:
542: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
543: EXCEPTION
544: WHEN fnd_api.g_exc_error THEN
545: ROLLBACK TO update_task_rsrc_req;
546:
547: IF jtf_rsrc_req_cur%ISOPEN THEN
548: CLOSE jtf_rsrc_req_cur;

Line 551: x_return_status := fnd_api.g_ret_sts_error;

547: IF jtf_rsrc_req_cur%ISOPEN THEN
548: CLOSE jtf_rsrc_req_cur;
549: END IF;
550:
551: x_return_status := fnd_api.g_ret_sts_error;
552: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
553: WHEN fnd_api.g_exc_unexpected_error THEN
554: ROLLBACK TO update_task_rsrc_req;
555:

Line 553: WHEN fnd_api.g_exc_unexpected_error THEN

549: END IF;
550:
551: x_return_status := fnd_api.g_ret_sts_error;
552: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
553: WHEN fnd_api.g_exc_unexpected_error THEN
554: ROLLBACK TO update_task_rsrc_req;
555:
556: IF jtf_rsrc_req_cur%ISOPEN THEN
557: CLOSE jtf_rsrc_req_cur;

Line 560: x_return_status := fnd_api.g_ret_sts_unexp_error;

556: IF jtf_rsrc_req_cur%ISOPEN THEN
557: CLOSE jtf_rsrc_req_cur;
558: END IF;
559:
560: x_return_status := fnd_api.g_ret_sts_unexp_error;
561: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
562: WHEN OTHERS THEN
563: ROLLBACK TO update_task_rsrc_req;
564:

Line 569: x_return_status := fnd_api.g_ret_sts_unexp_error;

565: IF jtf_rsrc_req_cur%ISOPEN THEN
566: CLOSE jtf_rsrc_req_cur;
567: END IF;
568:
569: x_return_status := fnd_api.g_ret_sts_unexp_error;
570:
571: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
572: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
573: END IF;

Line 582: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false

578: --Procedure to Delete the Task Resource Requirements
579: PROCEDURE delete_task_rsrc_req(
580: p_api_version IN NUMBER
581: , p_object_version_number IN NUMBER
582: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
583: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
584: , p_resource_req_id IN NUMBER
585: , x_return_status OUT NOCOPY VARCHAR2
586: , x_msg_count OUT NOCOPY NUMBER

Line 583: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false

579: PROCEDURE delete_task_rsrc_req(
580: p_api_version IN NUMBER
581: , p_object_version_number IN NUMBER
582: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
583: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
584: , p_resource_req_id IN NUMBER
585: , x_return_status OUT NOCOPY VARCHAR2
586: , x_msg_count OUT NOCOPY NUMBER
587: , x_msg_data OUT NOCOPY VARCHAR2

Line 591: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

587: , x_msg_data OUT NOCOPY VARCHAR2
588: ) IS
589: l_api_version CONSTANT NUMBER := 1.0;
590: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_TASK_RSRC_REQ';
591: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
592: l_msg_data VARCHAR2(2000);
593: l_msg_count NUMBER;
594: l_resource_req_id jtf_task_rsc_reqs.resource_req_id%TYPE := p_resource_req_id;
595:

Line 604: x_return_status := fnd_api.g_ret_sts_success;

600:
601: x CHAR;
602: BEGIN
603: SAVEPOINT delete_task_rsrc_req;
604: x_return_status := fnd_api.g_ret_sts_success;
605:
606: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
607: RAISE fnd_api.g_exc_unexpected_error;
608: END IF;

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

602: BEGIN
603: SAVEPOINT delete_task_rsrc_req;
604: x_return_status := fnd_api.g_ret_sts_success;
605:
606: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
607: RAISE fnd_api.g_exc_unexpected_error;
608: END IF;
609:
610: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 607: RAISE fnd_api.g_exc_unexpected_error;

603: SAVEPOINT delete_task_rsrc_req;
604: x_return_status := fnd_api.g_ret_sts_success;
605:
606: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
607: RAISE fnd_api.g_exc_unexpected_error;
608: END IF;
609:
610: IF fnd_api.to_boolean(p_init_msg_list) THEN
611: fnd_msg_pub.initialize;

Line 610: IF fnd_api.to_boolean(p_init_msg_list) THEN

606: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
607: RAISE fnd_api.g_exc_unexpected_error;
608: END IF;
609:
610: IF fnd_api.to_boolean(p_init_msg_list) THEN
611: fnd_msg_pub.initialize;
612: END IF;
613:
614: ---- if resource req is null, then it is an error

Line 619: x_return_status := fnd_api.g_ret_sts_unexp_error;

615: IF (l_resource_req_id IS NULL) THEN
616: fnd_message.set_name('JTF', 'JTF_TASK_DELETING_RES_REQ_ID');
617: fnd_message.set_token('RESOURCE_REQ_ID', p_resource_req_id);
618: fnd_msg_pub.ADD;
619: x_return_status := fnd_api.g_ret_sts_unexp_error;
620: RAISE fnd_api.g_exc_unexpected_error;
621: END IF;
622:
623: ---- if resource req is NOT valid, then it is an error

Line 620: RAISE fnd_api.g_exc_unexpected_error;

616: fnd_message.set_name('JTF', 'JTF_TASK_DELETING_RES_REQ_ID');
617: fnd_message.set_token('RESOURCE_REQ_ID', p_resource_req_id);
618: fnd_msg_pub.ADD;
619: x_return_status := fnd_api.g_ret_sts_unexp_error;
620: RAISE fnd_api.g_exc_unexpected_error;
621: END IF;
622:
623: ---- if resource req is NOT valid, then it is an error
624: OPEN jtf_task_rsc_req_u_cur;

Line 633: x_return_status := fnd_api.g_ret_sts_unexp_error;

629: IF jtf_task_rsc_req_u_cur%NOTFOUND THEN
630: fnd_message.set_name('JTF', 'JTF_TASK_INV_RES_REQ_ID');
631: fnd_message.set_token('TASK_ID', p_resource_req_id);
632: fnd_msg_pub.ADD;
633: x_return_status := fnd_api.g_ret_sts_unexp_error;
634: RAISE fnd_api.g_exc_unexpected_error;
635: ELSE
636: jtf_task_resources_pub.lock_task_resources
637: (

Line 634: RAISE fnd_api.g_exc_unexpected_error;

630: fnd_message.set_name('JTF', 'JTF_TASK_INV_RES_REQ_ID');
631: fnd_message.set_token('TASK_ID', p_resource_req_id);
632: fnd_msg_pub.ADD;
633: x_return_status := fnd_api.g_ret_sts_unexp_error;
634: RAISE fnd_api.g_exc_unexpected_error;
635: ELSE
636: jtf_task_resources_pub.lock_task_resources
637: (
638: p_api_version => 1.0

Line 639: , p_init_msg_list => fnd_api.g_false

635: ELSE
636: jtf_task_resources_pub.lock_task_resources
637: (
638: p_api_version => 1.0
639: , p_init_msg_list => fnd_api.g_false
640: , p_commit => fnd_api.g_false
641: , p_resource_requirement_id => l_resource_req_id
642: , p_object_version_number => p_object_version_number
643: , x_return_status => x_return_status

Line 640: , p_commit => fnd_api.g_false

636: jtf_task_resources_pub.lock_task_resources
637: (
638: p_api_version => 1.0
639: , p_init_msg_list => fnd_api.g_false
640: , p_commit => fnd_api.g_false
641: , p_resource_requirement_id => l_resource_req_id
642: , p_object_version_number => p_object_version_number
643: , x_return_status => x_return_status
644: , x_msg_data => x_msg_data

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

644: , x_msg_data => x_msg_data
645: , x_msg_count => x_msg_count
646: );
647:
648: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
649: x_return_status := fnd_api.g_ret_sts_unexp_error;
650: RAISE fnd_api.g_exc_unexpected_error;
651: END IF;
652:

Line 649: x_return_status := fnd_api.g_ret_sts_unexp_error;

645: , x_msg_count => x_msg_count
646: );
647:
648: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
649: x_return_status := fnd_api.g_ret_sts_unexp_error;
650: RAISE fnd_api.g_exc_unexpected_error;
651: END IF;
652:
653: jtf_task_resources_pvt.delete_task_rsrc_req

Line 650: RAISE fnd_api.g_exc_unexpected_error;

646: );
647:
648: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
649: x_return_status := fnd_api.g_ret_sts_unexp_error;
650: RAISE fnd_api.g_exc_unexpected_error;
651: END IF;
652:
653: jtf_task_resources_pvt.delete_task_rsrc_req
654: (

Line 657: , p_init_msg_list => fnd_api.g_false

653: jtf_task_resources_pvt.delete_task_rsrc_req
654: (
655: p_api_version => l_api_version
656: , p_object_version_number => p_object_version_number
657: , p_init_msg_list => fnd_api.g_false
658: , p_commit => fnd_api.g_false
659: , p_resource_req_id => l_resource_req_id
660: , x_return_status => l_return_status
661: , x_msg_count => l_msg_count

Line 658: , p_commit => fnd_api.g_false

654: (
655: p_api_version => l_api_version
656: , p_object_version_number => p_object_version_number
657: , p_init_msg_list => fnd_api.g_false
658: , p_commit => fnd_api.g_false
659: , p_resource_req_id => l_resource_req_id
660: , x_return_status => l_return_status
661: , x_msg_count => l_msg_count
662: , x_msg_data => l_msg_data

Line 665: IF (l_return_status = fnd_api.g_ret_sts_error) THEN

661: , x_msg_count => l_msg_count
662: , x_msg_data => l_msg_data
663: );
664:
665: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
666: RAISE fnd_api.g_exc_error;
667: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
668: RAISE fnd_api.g_exc_unexpected_error;
669: END IF;

Line 666: RAISE fnd_api.g_exc_error;

662: , x_msg_data => l_msg_data
663: );
664:
665: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
666: RAISE fnd_api.g_exc_error;
667: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
668: RAISE fnd_api.g_exc_unexpected_error;
669: END IF;
670: END IF;

Line 667: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN

663: );
664:
665: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
666: RAISE fnd_api.g_exc_error;
667: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
668: RAISE fnd_api.g_exc_unexpected_error;
669: END IF;
670: END IF;
671:

Line 668: RAISE fnd_api.g_exc_unexpected_error;

664:
665: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
666: RAISE fnd_api.g_exc_error;
667: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
668: RAISE fnd_api.g_exc_unexpected_error;
669: END IF;
670: END IF;
671:
672: IF jtf_task_rsc_req_u_cur%ISOPEN THEN

Line 676: IF fnd_api.to_boolean(p_commit) THEN

672: IF jtf_task_rsc_req_u_cur%ISOPEN THEN
673: CLOSE jtf_task_rsc_req_u_cur;
674: END IF;
675:
676: IF fnd_api.to_boolean(p_commit) THEN
677: COMMIT WORK;
678: END IF;
679:
680: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 682: WHEN fnd_api.g_exc_error THEN

678: END IF;
679:
680: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
681: EXCEPTION
682: WHEN fnd_api.g_exc_error THEN
683: ROLLBACK TO delete_task_rsrc_req;
684:
685: IF jtf_task_rsc_req_u_cur%ISOPEN THEN
686: CLOSE jtf_task_rsc_req_u_cur;

Line 689: x_return_status := fnd_api.g_ret_sts_error;

685: IF jtf_task_rsc_req_u_cur%ISOPEN THEN
686: CLOSE jtf_task_rsc_req_u_cur;
687: END IF;
688:
689: x_return_status := fnd_api.g_ret_sts_error;
690: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
691: WHEN fnd_api.g_exc_unexpected_error THEN
692: ROLLBACK TO delete_task_rsrc_req;
693:

Line 691: WHEN fnd_api.g_exc_unexpected_error THEN

687: END IF;
688:
689: x_return_status := fnd_api.g_ret_sts_error;
690: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
691: WHEN fnd_api.g_exc_unexpected_error THEN
692: ROLLBACK TO delete_task_rsrc_req;
693:
694: IF jtf_task_rsc_req_u_cur%ISOPEN THEN
695: CLOSE jtf_task_rsc_req_u_cur;

Line 698: x_return_status := fnd_api.g_ret_sts_unexp_error;

694: IF jtf_task_rsc_req_u_cur%ISOPEN THEN
695: CLOSE jtf_task_rsc_req_u_cur;
696: END IF;
697:
698: x_return_status := fnd_api.g_ret_sts_unexp_error;
699: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
700: WHEN OTHERS THEN
701: ROLLBACK TO delete_task_rsrc_req;
702:

Line 707: x_return_status := fnd_api.g_ret_sts_unexp_error;

703: IF jtf_task_rsc_req_u_cur%ISOPEN THEN
704: CLOSE jtf_task_rsc_req_u_cur;
705: END IF;
706:
707: x_return_status := fnd_api.g_ret_sts_unexp_error;
708: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
709: END;
710:
711: --Procedure to get the Task Resource Req

Line 741: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

737: , x_total_returned OUT NOCOPY NUMBER
738: ) IS
739: l_api_version CONSTANT NUMBER := 1.0;
740: l_api_name CONSTANT VARCHAR2(30) := 'GET_TASK_RSRC_REQ';
741: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
742: l_msg_data VARCHAR2(2000);
743: l_msg_count NUMBER;
744: l_resource_type_code jtf_task_rsc_reqs.resource_type_code%TYPE := p_resource_type_code;
745: l_task_id jtf_task_rsc_reqs.task_id%TYPE := p_task_id;

Line 756: x_return_status := fnd_api.g_ret_sts_success;

752: l_task_template_name VARCHAR2(80) := p_task_template_name;
753: l_resource_req_id jtf_task_rsc_reqs.resource_req_id%TYPE := p_resource_req_id;
754: BEGIN
755: SAVEPOINT get_task_rsrc_req;
756: x_return_status := fnd_api.g_ret_sts_success;
757:
758: -- standard call to check for call compatibility
759: IF (NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name)) THEN
760: RAISE fnd_api.g_exc_unexpected_error;

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

755: SAVEPOINT get_task_rsrc_req;
756: x_return_status := fnd_api.g_ret_sts_success;
757:
758: -- standard call to check for call compatibility
759: IF (NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name)) THEN
760: RAISE fnd_api.g_exc_unexpected_error;
761: END IF;
762:
763: -- initialize message list i p_init_msg_list is set to true

Line 760: RAISE fnd_api.g_exc_unexpected_error;

756: x_return_status := fnd_api.g_ret_sts_success;
757:
758: -- standard call to check for call compatibility
759: IF (NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name)) THEN
760: RAISE fnd_api.g_exc_unexpected_error;
761: END IF;
762:
763: -- initialize message list i p_init_msg_list is set to true
764: IF (fnd_api.to_boolean(p_init_msg_list)) THEN

Line 764: IF (fnd_api.to_boolean(p_init_msg_list)) THEN

760: RAISE fnd_api.g_exc_unexpected_error;
761: END IF;
762:
763: -- initialize message list i p_init_msg_list is set to true
764: IF (fnd_api.to_boolean(p_init_msg_list)) THEN
765: fnd_msg_pub.initialize;
766: END IF;
767:
768: -- required parameters to control records returned

Line 774: RAISE fnd_api.g_exc_error;

770: -- p_query_or_next_code should be Q or N
771: IF (p_query_or_next_code NOT IN('Q', 'N')) OR(p_query_or_next_code IS NULL) THEN
772: fnd_message.set_name('JTF', 'JTF_TK_INV_QRY_NXT');
773: fnd_msg_pub.ADD;
774: RAISE fnd_api.g_exc_error;
775: END IF;
776:
777: -- p_show_all should be Y or N
778: IF (p_show_all NOT IN('Y', 'N')) OR(p_show_all IS NULL) THEN

Line 781: RAISE fnd_api.g_exc_error;

777: -- p_show_all should be Y or N
778: IF (p_show_all NOT IN('Y', 'N')) OR(p_show_all IS NULL) THEN
779: fnd_message.set_name('JTF', 'JTF_TK_INV_SHOW_ALL');
780: fnd_msg_pub.ADD;
781: RAISE fnd_api.g_exc_error;
782: END IF;
783:
784: IF (p_show_all = 'N') THEN
785: IF (p_start_pointer IS NULL) THEN

Line 788: RAISE fnd_api.g_exc_error;

784: IF (p_show_all = 'N') THEN
785: IF (p_start_pointer IS NULL) THEN
786: fnd_message.set_name('JTF', 'JTF_TK_NULL_STRT_PTR');
787: fnd_msg_pub.ADD;
788: RAISE fnd_api.g_exc_error;
789: END IF;
790:
791: IF (p_rec_wanted IS NULL) THEN
792: fnd_message.set_name('JTF', 'JTF_TK_NULL_REC_WANT');

Line 794: RAISE fnd_api.g_exc_error;

790:
791: IF (p_rec_wanted IS NULL) THEN
792: fnd_message.set_name('JTF', 'JTF_TK_NULL_REC_WANT');
793: fnd_msg_pub.ADD;
794: RAISE fnd_api.g_exc_error;
795: END IF;
796: END IF;
797:
798: jtf_task_resources_pvt.get_task_rsrc_req(

Line 826: WHEN fnd_api.g_exc_error THEN

822: , x_total_retrieved
823: , x_total_returned
824: );
825: EXCEPTION
826: WHEN fnd_api.g_exc_error THEN
827: ROLLBACK TO get_task_rsrc_req;
828: x_return_status := fnd_api.g_ret_sts_error;
829: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
830: WHEN fnd_api.g_exc_unexpected_error THEN

Line 828: x_return_status := fnd_api.g_ret_sts_error;

824: );
825: EXCEPTION
826: WHEN fnd_api.g_exc_error THEN
827: ROLLBACK TO get_task_rsrc_req;
828: x_return_status := fnd_api.g_ret_sts_error;
829: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
830: WHEN fnd_api.g_exc_unexpected_error THEN
831: ROLLBACK TO get_task_rsrc_req;
832: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 830: WHEN fnd_api.g_exc_unexpected_error THEN

826: WHEN fnd_api.g_exc_error THEN
827: ROLLBACK TO get_task_rsrc_req;
828: x_return_status := fnd_api.g_ret_sts_error;
829: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
830: WHEN fnd_api.g_exc_unexpected_error THEN
831: ROLLBACK TO get_task_rsrc_req;
832: x_return_status := fnd_api.g_ret_sts_unexp_error;
833: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
834: WHEN OTHERS THEN

Line 832: x_return_status := fnd_api.g_ret_sts_unexp_error;

828: x_return_status := fnd_api.g_ret_sts_error;
829: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
830: WHEN fnd_api.g_exc_unexpected_error THEN
831: ROLLBACK TO get_task_rsrc_req;
832: x_return_status := fnd_api.g_ret_sts_unexp_error;
833: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
834: WHEN OTHERS THEN
835: ROLLBACK TO get_task_rsrc_req;
836: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 836: x_return_status := fnd_api.g_ret_sts_unexp_error;

832: x_return_status := fnd_api.g_ret_sts_unexp_error;
833: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
834: WHEN OTHERS THEN
835: ROLLBACK TO get_task_rsrc_req;
836: x_return_status := fnd_api.g_ret_sts_unexp_error;
837:
838: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
839: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
840: END IF;

Line 847: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false

843: END;
844:
845: PROCEDURE lock_task_resources(
846: p_api_version IN NUMBER
847: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
848: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
849: , p_resource_requirement_id IN NUMBER
850: , p_object_version_number IN NUMBER
851: , x_return_status OUT NOCOPY VARCHAR2

Line 848: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false

844:
845: PROCEDURE lock_task_resources(
846: p_api_version IN NUMBER
847: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
848: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
849: , p_resource_requirement_id IN NUMBER
850: , p_object_version_number IN NUMBER
851: , x_return_status OUT NOCOPY VARCHAR2
852: , x_msg_data OUT NOCOPY VARCHAR2

Line 861: x_return_status := fnd_api.g_ret_sts_success;

857: resource_locked EXCEPTION;
858: PRAGMA EXCEPTION_INIT(resource_locked, -54);
859: BEGIN
860: SAVEPOINT lock_task_resources_pub;
861: x_return_status := fnd_api.g_ret_sts_success;
862:
863: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
864: RAISE fnd_api.g_exc_unexpected_error;
865: END IF;

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

859: BEGIN
860: SAVEPOINT lock_task_resources_pub;
861: x_return_status := fnd_api.g_ret_sts_success;
862:
863: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
864: RAISE fnd_api.g_exc_unexpected_error;
865: END IF;
866:
867: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 864: RAISE fnd_api.g_exc_unexpected_error;

860: SAVEPOINT lock_task_resources_pub;
861: x_return_status := fnd_api.g_ret_sts_success;
862:
863: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
864: RAISE fnd_api.g_exc_unexpected_error;
865: END IF;
866:
867: IF fnd_api.to_boolean(p_init_msg_list) THEN
868: fnd_msg_pub.initialize;

Line 867: IF fnd_api.to_boolean(p_init_msg_list) THEN

863: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
864: RAISE fnd_api.g_exc_unexpected_error;
865: END IF;
866:
867: IF fnd_api.to_boolean(p_init_msg_list) THEN
868: fnd_msg_pub.initialize;
869: END IF;
870:
871: x_return_status := fnd_api.g_ret_sts_success;

Line 871: x_return_status := fnd_api.g_ret_sts_success;

867: IF fnd_api.to_boolean(p_init_msg_list) THEN
868: fnd_msg_pub.initialize;
869: END IF;
870:
871: x_return_status := fnd_api.g_ret_sts_success;
872: jtf_task_rsc_reqs_pkg.lock_row(
873: x_resource_req_id => p_resource_requirement_id
874: , x_object_version_number => p_object_version_number
875: );

Line 882: x_return_status := fnd_api.g_ret_sts_unexp_error;

878: WHEN resource_locked THEN
879: ROLLBACK TO lock_task_resources_pub;
880: fnd_message.set_name('JTF', 'JTF_TASK_RESOURCE_LOCKED');
881: fnd_message.set_token('P_LOCKED_RESOURCE', 'Resources');
882: x_return_status := fnd_api.g_ret_sts_unexp_error;
883: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
884: WHEN fnd_api.g_exc_unexpected_error THEN
885: ROLLBACK TO lock_task_resources_pub;
886: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 884: WHEN fnd_api.g_exc_unexpected_error THEN

880: fnd_message.set_name('JTF', 'JTF_TASK_RESOURCE_LOCKED');
881: fnd_message.set_token('P_LOCKED_RESOURCE', 'Resources');
882: x_return_status := fnd_api.g_ret_sts_unexp_error;
883: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
884: WHEN fnd_api.g_exc_unexpected_error THEN
885: ROLLBACK TO lock_task_resources_pub;
886: x_return_status := fnd_api.g_ret_sts_unexp_error;
887: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
888: WHEN OTHERS THEN

Line 886: x_return_status := fnd_api.g_ret_sts_unexp_error;

882: x_return_status := fnd_api.g_ret_sts_unexp_error;
883: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
884: WHEN fnd_api.g_exc_unexpected_error THEN
885: ROLLBACK TO lock_task_resources_pub;
886: x_return_status := fnd_api.g_ret_sts_unexp_error;
887: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
888: WHEN OTHERS THEN
889: ROLLBACK TO lock_task_resources_pub;
890: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');

Line 892: x_return_status := fnd_api.g_ret_sts_unexp_error;

888: WHEN OTHERS THEN
889: ROLLBACK TO lock_task_resources_pub;
890: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
891: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
892: x_return_status := fnd_api.g_ret_sts_unexp_error;
893: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
894: END;
895: END;