DBA Data[Home] [Help]

APPS.QA_DEVICE_PUB dependencies on FND_MESSAGE

Line 90: fnd_message.set_name('QA', 'QA_API_INVALID_USER');

86: x_return_status := fnd_api.g_ret_sts_success;
87:
88: l_user_id := get_user_id(p_user_name);
89: IF l_user_id = -1 THEN
90: fnd_message.set_name('QA', 'QA_API_INVALID_USER');
91: fnd_msg_pub.add();
92: raise fnd_api.g_exc_error;
93: END IF;
94:

Line 107: fnd_message.set_name('QA', 'QA_DEV_INSERT_FAILED');

103: WHERE device_name = p_device_name
104: AND device_source = p_device_source;
105:
106: IF sql%rowcount = 0 THEN
107: fnd_message.set_name('QA', 'QA_DEV_INSERT_FAILED');
108: fnd_message.set_token('DEVNAME',p_device_name);
109: fnd_msg_pub.add();
110: raise fnd_api.g_exc_error;
111: END IF;

Line 108: fnd_message.set_token('DEVNAME',p_device_name);

104: AND device_source = p_device_source;
105:
106: IF sql%rowcount = 0 THEN
107: fnd_message.set_name('QA', 'QA_DEV_INSERT_FAILED');
108: fnd_message.set_token('DEVNAME',p_device_name);
109: fnd_msg_pub.add();
110: raise fnd_api.g_exc_error;
111: END IF;
112:

Line 133: fnd_message.set_name('QA', 'QA_DEV_INSERT_FAILED');

129: p_data => x_msg_data
130: );
131:
132: WHEN others THEN
133: fnd_message.set_name('QA', 'QA_DEV_INSERT_FAILED');
134: fnd_message.set_token('DEVNAME',p_device_name);
135: fnd_msg_pub.add();
136: x_return_status := fnd_api.g_ret_sts_error;
137: fnd_msg_pub.count_and_get(

Line 134: fnd_message.set_token('DEVNAME',p_device_name);

130: );
131:
132: WHEN others THEN
133: fnd_message.set_name('QA', 'QA_DEV_INSERT_FAILED');
134: fnd_message.set_token('DEVNAME',p_device_name);
135: fnd_msg_pub.add();
136: x_return_status := fnd_api.g_ret_sts_error;
137: fnd_msg_pub.count_and_get(
138: p_count => x_msg_count,

Line 185: fnd_message.set_name('QA', 'QA_API_INVALID_USER');

181: x_return_status := fnd_api.g_ret_sts_success;
182:
183: l_user_id := get_user_id(p_user_name);
184: IF l_user_id = -1 THEN
185: fnd_message.set_name('QA', 'QA_API_INVALID_USER');
186: fnd_msg_pub.add();
187: raise fnd_api.g_exc_error;
188: END IF;
189:

Line 194: fnd_message.set_name('QA', 'QA_DEV_INCOMPLETE_DATA');

190: -- Check if data for all devices has been passed.
191: IF p_device_name.COUNT <> p_device_data.COUNT
192: OR p_device_name.COUNT <> p_device_event_time.COUNT
193: OR p_device_name.COUNT <> p_quality_code.COUNT THEN
194: fnd_message.set_name('QA', 'QA_DEV_INCOMPLETE_DATA');
195: fnd_msg_pub.add();
196: raise fnd_api.g_exc_error;
197: END IF;
198:

Line 227: fnd_message.set_name('QA', 'QA_DEV_INSERT_FAILED');

223: COMMIT;
224: END IF;
225:
226: IF l_err_device_names IS NOT NULL THEN
227: fnd_message.set_name('QA', 'QA_DEV_INSERT_FAILED');
228: fnd_message.set_token('DEVNAME',l_err_device_names);
229: fnd_msg_pub.add();
230: raise fnd_api.g_exc_error;
231: END IF;

Line 228: fnd_message.set_token('DEVNAME',l_err_device_names);

224: END IF;
225:
226: IF l_err_device_names IS NOT NULL THEN
227: fnd_message.set_name('QA', 'QA_DEV_INSERT_FAILED');
228: fnd_message.set_token('DEVNAME',l_err_device_names);
229: fnd_msg_pub.add();
230: raise fnd_api.g_exc_error;
231: END IF;
232: EXCEPTION

Line 256: fnd_message.set_name('QA', 'QA_DEV_INSERT_FAILED');

252: ELSE
253: l_err_device_names := l_err_device_names || ',' || p_device_name(SQL%BULK_EXCEPTIONS(err_cntr).ERROR_INDEX);
254: END IF;
255: END LOOP;
256: fnd_message.set_name('QA', 'QA_DEV_INSERT_FAILED');
257: fnd_message.set_token('DEVNAME',l_err_device_names);
258: fnd_msg_pub.add();
259: x_return_status := fnd_api.g_ret_sts_error;
260: fnd_msg_pub.count_and_get(

Line 257: fnd_message.set_token('DEVNAME',l_err_device_names);

253: l_err_device_names := l_err_device_names || ',' || p_device_name(SQL%BULK_EXCEPTIONS(err_cntr).ERROR_INDEX);
254: END IF;
255: END LOOP;
256: fnd_message.set_name('QA', 'QA_DEV_INSERT_FAILED');
257: fnd_message.set_token('DEVNAME',l_err_device_names);
258: fnd_msg_pub.add();
259: x_return_status := fnd_api.g_ret_sts_error;
260: fnd_msg_pub.count_and_get(
261: p_count => x_msg_count,

Line 304: fnd_message.set_name('QA', 'QA_API_INVALID_USER');

300: x_return_status := fnd_api.g_ret_sts_success;
301:
302: l_user_id := get_user_id(p_user_name);
303: IF l_user_id = -1 THEN
304: fnd_message.set_name('QA', 'QA_API_INVALID_USER');
305: fnd_msg_pub.add();
306: raise fnd_api.g_exc_error;
307: END IF;
308:

Line 311: fnd_message.set_name('QA', 'QA_DEV_INCOMPLETE_DATA');

307: END IF;
308:
309: -- Check if data for all devices has been passed.
310: IF p_device_name.COUNT <> p_device_desc.COUNT OR p_device_name.COUNT <> p_expiration.COUNT THEN
311: fnd_message.set_name('QA', 'QA_DEV_INCOMPLETE_DATA');
312: fnd_msg_pub.add();
313: raise fnd_api.g_exc_error;
314: END IF;
315:

Line 455: fnd_message.set_name('QA', 'QA_API_INVALID_USER');

451: x_return_status := fnd_api.g_ret_sts_success;
452:
453: l_user_id := get_user_id(p_user_name);
454: IF l_user_id = -1 THEN
455: fnd_message.set_name('QA', 'QA_API_INVALID_USER');
456: fnd_msg_pub.add();
457: raise fnd_api.g_exc_error;
458: END IF;
459: