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

Line 8: p_init_msg_list in varchar2 default fnd_api.g_false,

4: g_pkg_name constant varchar2(30) := 'ICX_SR_CUSTOM_PVT';
5:
6:
7: PROCEDURE sr_default(p_api_version in number,
8: p_init_msg_list in varchar2 default fnd_api.g_false,
9: p_simulate in varchar2 default fnd_api.g_false,
10: p_commit in varchar2 default fnd_api.g_false,
11: p_validation_level in number default fnd_api.g_valid_level_full,
12: p_return_status out varchar2,

Line 9: p_simulate in varchar2 default fnd_api.g_false,

5:
6:
7: PROCEDURE sr_default(p_api_version in number,
8: p_init_msg_list in varchar2 default fnd_api.g_false,
9: p_simulate in varchar2 default fnd_api.g_false,
10: p_commit in varchar2 default fnd_api.g_false,
11: p_validation_level in number default fnd_api.g_valid_level_full,
12: p_return_status out varchar2,
13: p_msg_count out number,

Line 10: p_commit in varchar2 default fnd_api.g_false,

6:
7: PROCEDURE sr_default(p_api_version in number,
8: p_init_msg_list in varchar2 default fnd_api.g_false,
9: p_simulate in varchar2 default fnd_api.g_false,
10: p_commit in varchar2 default fnd_api.g_false,
11: p_validation_level in number default fnd_api.g_valid_level_full,
12: p_return_status out varchar2,
13: p_msg_count out number,
14: p_msg_data out varchar2,

Line 11: p_validation_level in number default fnd_api.g_valid_level_full,

7: PROCEDURE sr_default(p_api_version in number,
8: p_init_msg_list in varchar2 default fnd_api.g_false,
9: p_simulate in varchar2 default fnd_api.g_false,
10: p_commit in varchar2 default fnd_api.g_false,
11: p_validation_level in number default fnd_api.g_valid_level_full,
12: p_return_status out varchar2,
13: p_msg_count out number,
14: p_msg_data out varchar2,
15: p_customer_id out number,

Line 47: if not fnd_api.Compatible_API_Call(l_api_version,

43: -- Standard start of API savepoint
44: SAVEPOINT SR_DEFAULT_PVT;
45:
46: -- Standard call to check for call compatibility
47: if not fnd_api.Compatible_API_Call(l_api_version,
48: p_api_version,
49: l_api_name,
50: g_pkg_name) then
51:

Line 52: raise fnd_api.g_exc_unexpected_error;

48: p_api_version,
49: l_api_name,
50: g_pkg_name) then
51:
52: raise fnd_api.g_exc_unexpected_error;
53: end if;
54:
55:
56: -- Initialize message list if p_init_msg_list is TRUE

Line 57: if fnd_api.to_boolean(p_init_msg_list) then

53: end if;
54:
55:
56: -- Initialize message list if p_init_msg_list is TRUE
57: if fnd_api.to_boolean(p_init_msg_list) then
58: fnd_msg_pub.initialize;
59: end if;
60:
61: -- Initialize API return status to success

Line 62: p_return_status := fnd_api.g_ret_sts_success;

58: fnd_msg_pub.initialize;
59: end if;
60:
61: -- Initialize API return status to success
62: p_return_status := fnd_api.g_ret_sts_success;
63:
64: -- *******************************************************************
65: -- API body
66: -- Put custom code here

Line 76: if fnd_api.to_boolean(p_simulate) then

72: -- *******************************************************************
73:
74:
75: -- Standard check of p_simulate and p_commit parameters
76: if fnd_api.to_boolean(p_simulate) then
77: ROLLBACK to SR_DEFAULT_PVT;
78:
79: elsif fnd_api.to_boolean(p_commit) then
80: COMMIT WORK;

Line 79: elsif fnd_api.to_boolean(p_commit) then

75: -- Standard check of p_simulate and p_commit parameters
76: if fnd_api.to_boolean(p_simulate) then
77: ROLLBACK to SR_DEFAULT_PVT;
78:
79: elsif fnd_api.to_boolean(p_commit) then
80: COMMIT WORK;
81:
82: end if;
83:

Line 89: when fnd_api.g_exc_error then

85: fnd_msg_pub.count_and_get(p_count => p_msg_count,
86: p_data => p_msg_data);
87:
88: exception
89: when fnd_api.g_exc_error then
90: ROLLBACK to SR_DEFAULT_PVT;
91: p_return_status := fnd_api.g_ret_sts_error;
92:
93: fnd_msg_pub.count_and_get(p_count => p_msg_count,

Line 91: p_return_status := fnd_api.g_ret_sts_error;

87:
88: exception
89: when fnd_api.g_exc_error then
90: ROLLBACK to SR_DEFAULT_PVT;
91: p_return_status := fnd_api.g_ret_sts_error;
92:
93: fnd_msg_pub.count_and_get(p_count => p_msg_count,
94: p_data => p_msg_data);
95:

Line 97: when fnd_api.g_exc_unexpected_error then

93: fnd_msg_pub.count_and_get(p_count => p_msg_count,
94: p_data => p_msg_data);
95:
96:
97: when fnd_api.g_exc_unexpected_error then
98: ROLLBACK to SR_DEFAULT_PVT;
99: p_return_status := fnd_api.g_ret_sts_unexp_error;
100:
101: fnd_msg_pub.count_and_get(p_count => p_msg_count,

Line 99: p_return_status := fnd_api.g_ret_sts_unexp_error;

95:
96:
97: when fnd_api.g_exc_unexpected_error then
98: ROLLBACK to SR_DEFAULT_PVT;
99: p_return_status := fnd_api.g_ret_sts_unexp_error;
100:
101: fnd_msg_pub.count_and_get(p_count => p_msg_count,
102: p_data => p_msg_data);
103:

Line 106: p_return_status := fnd_api.g_ret_sts_unexp_error;

102: p_data => p_msg_data);
103:
104: when others then
105: ROLLBACK to SR_DEFAULT_PVT;
106: p_return_status := fnd_api.g_ret_sts_unexp_error;
107:
108: if fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.g_msg_lvl_unexp_error) then
109: fnd_msg_pub.Add_Exc_Msg(g_pkg_name,
110: l_api_name);

Line 123: p_init_msg_list in varchar2 default fnd_api.g_false,

119:
120:
121:
122: PROCEDURE sr_validate(p_api_version in number,
123: p_init_msg_list in varchar2 default fnd_api.g_false,
124: p_simulate in varchar2 default fnd_api.g_false,
125: p_commit in varchar2 default fnd_api.g_false,
126: p_validation_level in number default fnd_api.g_valid_level_full,
127: p_submit_type in varchar2 default null,

Line 124: p_simulate in varchar2 default fnd_api.g_false,

120:
121:
122: PROCEDURE sr_validate(p_api_version in number,
123: p_init_msg_list in varchar2 default fnd_api.g_false,
124: p_simulate in varchar2 default fnd_api.g_false,
125: p_commit in varchar2 default fnd_api.g_false,
126: p_validation_level in number default fnd_api.g_valid_level_full,
127: p_submit_type in varchar2 default null,
128: p_incident_id in number default null,

Line 125: p_commit in varchar2 default fnd_api.g_false,

121:
122: PROCEDURE sr_validate(p_api_version in number,
123: p_init_msg_list in varchar2 default fnd_api.g_false,
124: p_simulate in varchar2 default fnd_api.g_false,
125: p_commit in varchar2 default fnd_api.g_false,
126: p_validation_level in number default fnd_api.g_valid_level_full,
127: p_submit_type in varchar2 default null,
128: p_incident_id in number default null,
129: p_request_number in varchar2 default null,

Line 126: p_validation_level in number default fnd_api.g_valid_level_full,

122: PROCEDURE sr_validate(p_api_version in number,
123: p_init_msg_list in varchar2 default fnd_api.g_false,
124: p_simulate in varchar2 default fnd_api.g_false,
125: p_commit in varchar2 default fnd_api.g_false,
126: p_validation_level in number default fnd_api.g_valid_level_full,
127: p_submit_type in varchar2 default null,
128: p_incident_id in number default null,
129: p_request_number in varchar2 default null,
130: p_customer_id in number default null,

Line 167: if not fnd_api.Compatible_API_Call(l_api_version,

163: -- Standard start of API savepoint
164: SAVEPOINT SR_VALIDATE_PVT;
165:
166: -- Standard call to check for call compatibility
167: if not fnd_api.Compatible_API_Call(l_api_version,
168: p_api_version,
169: l_api_name,
170: g_pkg_name) then
171:

Line 172: raise fnd_api.g_exc_unexpected_error;

168: p_api_version,
169: l_api_name,
170: g_pkg_name) then
171:
172: raise fnd_api.g_exc_unexpected_error;
173: end if;
174:
175:
176: -- Initialize message list if p_init_msg_list is TRUE

Line 177: if fnd_api.to_boolean(p_init_msg_list) then

173: end if;
174:
175:
176: -- Initialize message list if p_init_msg_list is TRUE
177: if fnd_api.to_boolean(p_init_msg_list) then
178: fnd_msg_pub.initialize;
179: end if;
180:
181: -- Initialize API return status to success

Line 182: p_return_status := fnd_api.g_ret_sts_success;

178: fnd_msg_pub.initialize;
179: end if;
180:
181: -- Initialize API return status to success
182: p_return_status := fnd_api.g_ret_sts_success;
183:
184: -- *******************************************************************
185: -- API body
186: -- Put custom code here

Line 196: if fnd_api.to_boolean(p_simulate) then

192: -- *******************************************************************
193:
194:
195: -- Standard check of p_simulate and p_commit parameters
196: if fnd_api.to_boolean(p_simulate) then
197: ROLLBACK to SR_VALIDATE_PVT;
198:
199: elsif fnd_api.to_boolean(p_commit) then
200: COMMIT WORK;

Line 199: elsif fnd_api.to_boolean(p_commit) then

195: -- Standard check of p_simulate and p_commit parameters
196: if fnd_api.to_boolean(p_simulate) then
197: ROLLBACK to SR_VALIDATE_PVT;
198:
199: elsif fnd_api.to_boolean(p_commit) then
200: COMMIT WORK;
201:
202: end if;
203:

Line 209: when fnd_api.g_exc_error then

205: fnd_msg_pub.count_and_get(p_count => p_msg_count,
206: p_data => p_msg_data);
207:
208: exception
209: when fnd_api.g_exc_error then
210: ROLLBACK to SR_VALIDATE_PVT;
211: p_return_status := fnd_api.g_ret_sts_error;
212:
213: fnd_msg_pub.count_and_get(p_count => p_msg_count,

Line 211: p_return_status := fnd_api.g_ret_sts_error;

207:
208: exception
209: when fnd_api.g_exc_error then
210: ROLLBACK to SR_VALIDATE_PVT;
211: p_return_status := fnd_api.g_ret_sts_error;
212:
213: fnd_msg_pub.count_and_get(p_count => p_msg_count,
214: p_data => p_msg_data);
215:

Line 217: when fnd_api.g_exc_unexpected_error then

213: fnd_msg_pub.count_and_get(p_count => p_msg_count,
214: p_data => p_msg_data);
215:
216:
217: when fnd_api.g_exc_unexpected_error then
218: ROLLBACK to SR_VALIDATE_PVT;
219: p_return_status := fnd_api.g_ret_sts_unexp_error;
220:
221: fnd_msg_pub.count_and_get(p_count => p_msg_count,

Line 219: p_return_status := fnd_api.g_ret_sts_unexp_error;

215:
216:
217: when fnd_api.g_exc_unexpected_error then
218: ROLLBACK to SR_VALIDATE_PVT;
219: p_return_status := fnd_api.g_ret_sts_unexp_error;
220:
221: fnd_msg_pub.count_and_get(p_count => p_msg_count,
222: p_data => p_msg_data);
223:

Line 226: p_return_status := fnd_api.g_ret_sts_unexp_error;

222: p_data => p_msg_data);
223:
224: when others then
225: ROLLBACK to SR_VALIDATE_PVT;
226: p_return_status := fnd_api.g_ret_sts_unexp_error;
227:
228: if fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.g_msg_lvl_unexp_error) then
229: fnd_msg_pub.Add_Exc_Msg(g_pkg_name,
230: l_api_name);