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

Line 54: if l_second = 0 then raise fnd_api.g_exc_error;

50:
51: l_search_for := ';';
52: l_second := INSTR(p_app_data, l_search_for, l_first);
53:
54: if l_second = 0 then raise fnd_api.g_exc_error;
55: end if;
56:
57: -- get x_YYYY
58: if l_second = LENGTH (p_app_data) then x_ZZZZ := NULL;

Line 68: if l_sub_string IS NULL then raise fnd_api.g_exc_error;

64: -- l_first = 1, l_second = 9
65: -- l_sub_string := SUBSTR('MI:12345;abc=343;xyz=143;', 4, 5) := '12345'
66: l_sub_string := SUBSTR(p_app_data, l_first + 3, l_second - l_first - 3);
67:
68: if l_sub_string IS NULL then raise fnd_api.g_exc_error;
69: end if;
70:
71: -- check if l_sub_string starts with IVR- and strip it out
72: l_sub_string := LTRIM (l_sub_string, 'IVR-');

Line 92: raise fnd_api.g_exc_error;

88:
89:
90: EXCEPTION
91: WHEN OTHERS THEN
92: raise fnd_api.g_exc_error;
93: END parseAppData;
94:
95: PROCEDURE create_IVR_Item
96: (

Line 98: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

94:
95: PROCEDURE create_IVR_Item
96: (
97: p_api_version IN NUMBER,
98: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
99: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
100: x_return_status out nocopy VARCHAR2,
101: x_msg_count out nocopy NUMBER,
102: x_msg_data out nocopy VARCHAR2,

Line 99: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

95: PROCEDURE create_IVR_Item
96: (
97: p_api_version IN NUMBER,
98: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
99: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
100: x_return_status out nocopy VARCHAR2,
101: x_msg_count out nocopy NUMBER,
102: x_msg_data out nocopy VARCHAR2,
103: p_start_date_time IN DATE DEFAULT null,

Line 128: x_return_status := fnd_api.g_ret_sts_success;

124: -- Standard start of API savepoint
125: SAVEPOINT create_ivr_pub;
126:
127: -- Initialize API return status to success
128: x_return_status := fnd_api.g_ret_sts_success;
129: x_app_data := NULL;
130:
131: -- Standard call to check for call compatibility
132: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,

Line 132: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,

128: x_return_status := fnd_api.g_ret_sts_success;
129: x_app_data := NULL;
130:
131: -- Standard call to check for call compatibility
132: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
133: l_api_name, g_pkg_name) THEN
134: RAISE fnd_api.g_exc_unexpected_error;
135: END IF;
136:

Line 134: RAISE fnd_api.g_exc_unexpected_error;

130:
131: -- Standard call to check for call compatibility
132: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
133: l_api_name, g_pkg_name) THEN
134: RAISE fnd_api.g_exc_unexpected_error;
135: END IF;
136:
137: -- Initialize message list if p_init_msg_list is set to TRUE
138: if (p_init_msg_list <> FND_API.G_FALSE) AND

Line 138: if (p_init_msg_list <> FND_API.G_FALSE) AND

134: RAISE fnd_api.g_exc_unexpected_error;
135: END IF;
136:
137: -- Initialize message list if p_init_msg_list is set to TRUE
138: if (p_init_msg_list <> FND_API.G_FALSE) AND
139: (p_init_msg_list <> FND_API.G_TRUE)
140: then l_init_msg_list := FND_API.G_FALSE;
141: else l_init_msg_list := p_init_msg_list;
142: end if;

Line 139: (p_init_msg_list <> FND_API.G_TRUE)

135: END IF;
136:
137: -- Initialize message list if p_init_msg_list is set to TRUE
138: if (p_init_msg_list <> FND_API.G_FALSE) AND
139: (p_init_msg_list <> FND_API.G_TRUE)
140: then l_init_msg_list := FND_API.G_FALSE;
141: else l_init_msg_list := p_init_msg_list;
142: end if;
143:

Line 140: then l_init_msg_list := FND_API.G_FALSE;

136:
137: -- Initialize message list if p_init_msg_list is set to TRUE
138: if (p_init_msg_list <> FND_API.G_FALSE) AND
139: (p_init_msg_list <> FND_API.G_TRUE)
140: then l_init_msg_list := FND_API.G_FALSE;
141: else l_init_msg_list := p_init_msg_list;
142: end if;
143:
144: IF fnd_api.to_boolean(l_init_msg_list) THEN

Line 144: IF fnd_api.to_boolean(l_init_msg_list) THEN

140: then l_init_msg_list := FND_API.G_FALSE;
141: else l_init_msg_list := p_init_msg_list;
142: end if;
143:
144: IF fnd_api.to_boolean(l_init_msg_list) THEN
145: fnd_msg_pub.initialize;
146: END IF;
147:
148: ----------------------------------------------------

Line 150: if ((p_commit <> FND_API.G_FALSE) AND

146: END IF;
147:
148: ----------------------------------------------------
149: -- Validation checks for incoming parameters
150: if ((p_commit <> FND_API.G_FALSE) AND
151: (p_commit <> FND_API.G_TRUE))
152: then l_commit := FND_API.G_FALSE;
153: else l_commit := p_commit;
154: end if;

Line 151: (p_commit <> FND_API.G_TRUE))

147:
148: ----------------------------------------------------
149: -- Validation checks for incoming parameters
150: if ((p_commit <> FND_API.G_FALSE) AND
151: (p_commit <> FND_API.G_TRUE))
152: then l_commit := FND_API.G_FALSE;
153: else l_commit := p_commit;
154: end if;
155:

Line 152: then l_commit := FND_API.G_FALSE;

148: ----------------------------------------------------
149: -- Validation checks for incoming parameters
150: if ((p_commit <> FND_API.G_FALSE) AND
151: (p_commit <> FND_API.G_TRUE))
152: then l_commit := FND_API.G_FALSE;
153: else l_commit := p_commit;
154: end if;
155:
156: -- procedure to check p_ivr_data format ??

Line 160: if (p_app_data <> fnd_api.g_miss_char) then

156: -- procedure to check p_ivr_data format ??
157:
158: -- by default do create media item
159: l_create_media_item := TRUE;
160: if (p_app_data <> fnd_api.g_miss_char) then
161:
162: parseAppData(
163: p_app_data => p_app_data,
164: x_YYYY => l_YYYY,

Line 180: p_commit => FND_API.G_FALSE,

176:
177: JTF_IH_PUB_W.OPEN_MEDIAITEM (
178: p_api_version => 1.0,
179: p_init_msg_list => l_init_msg_list,
180: p_commit => FND_API.G_FALSE,
181: p_resp_appl_id => 1,
182: p_resp_id => 1,
183: p_user_id => -1,
184: p_login_id => NULL,

Line 202: p_commit => FND_API.G_FALSE,

198: -- Call JTF_IH_PUB.Create_MediaLifecycle
199: JTF_IH_PUB_W.CREATE_MEDIALIFECYCLE (
200: p_api_version => '1.0',
201: p_init_msg_list => p_init_msg_list,
202: p_commit => FND_API.G_FALSE,
203: p_resp_appl_id => 1,
204: p_resp_id => 1,
205: p_user_id => -1,
206: p_login_id => NULL,

Line 240: IF fnd_api.to_boolean(l_commit) THEN

236:
237:
238: ---------------------------------------------------------
239: -- Standard check of p_commit
240: IF fnd_api.to_boolean(l_commit) THEN
241: COMMIT WORK;
242: END IF;
243:
244: -- return value

Line 270: WHEN fnd_api.g_exc_error THEN

266:
267:
268: ---------------------------------------------------------
269: EXCEPTION
270: WHEN fnd_api.g_exc_error THEN
271: ROLLBACK TO create_ivr_pub;
272: x_return_status := fnd_api.g_ret_sts_error;
273:
274: END create_IVR_Item;

Line 272: x_return_status := fnd_api.g_ret_sts_error;

268: ---------------------------------------------------------
269: EXCEPTION
270: WHEN fnd_api.g_exc_error THEN
271: ROLLBACK TO create_ivr_pub;
272: x_return_status := fnd_api.g_ret_sts_error;
273:
274: END create_IVR_Item;
275:
276: PROCEDURE callIVRTEST (p_app_data VARCHAR2)

Line 287: p_init_msg_list => FND_API.G_FALSE,

283: BEGIN
284:
285: CCT_IVR_PUB.create_ivr_item(
286: p_api_version => '1.0',
287: p_init_msg_list => FND_API.G_FALSE,
288: p_commit => FND_API.G_FALSE,
289: x_return_status => l_return_status,
290: x_msg_count => l_msg_count,
291: x_msg_data => l_msg_data,

Line 288: p_commit => FND_API.G_FALSE,

284:
285: CCT_IVR_PUB.create_ivr_item(
286: p_api_version => '1.0',
287: p_init_msg_list => FND_API.G_FALSE,
288: p_commit => FND_API.G_FALSE,
289: x_return_status => l_return_status,
290: x_msg_count => l_msg_count,
291: x_msg_data => l_msg_data,
292: p_start_date_time => sysdate,