APPS.ASP_CONTACT_PREF_SECURITY_PUB dependencies on FND_API

Line 21: --l_value_varchar2 VARCHAR2(1) := FND_API.G_MISS_CHAR;

17: l_category VARCHAR2(64) ;
18: l_preference_code VARCHAR2(64) ;
19: l_object_version_number NUMBER;
20:
21: --l_value_varchar2 VARCHAR2(1) := FND_API.G_MISS_CHAR;
22: --l_value_number NUMBER := FND_API.G_MISS_NUM;
23: --l_value_date DATE := FND_API.G_MISS_DATE;
24:
25: l_return_status VARCHAR2(1);

Line 22: --l_value_number NUMBER := FND_API.G_MISS_NUM;

18: l_preference_code VARCHAR2(64) ;
19: l_object_version_number NUMBER;
20:
21: --l_value_varchar2 VARCHAR2(1) := FND_API.G_MISS_CHAR;
22: --l_value_number NUMBER := FND_API.G_MISS_NUM;
23: --l_value_date DATE := FND_API.G_MISS_DATE;
24:
25: l_return_status VARCHAR2(1);
26: l_msg_count NUMBER;

Line 23: --l_value_date DATE := FND_API.G_MISS_DATE;

19: l_object_version_number NUMBER;
20:
21: --l_value_varchar2 VARCHAR2(1) := FND_API.G_MISS_CHAR;
22: --l_value_number NUMBER := FND_API.G_MISS_NUM;
23: --l_value_date DATE := FND_API.G_MISS_DATE;
24:
25: l_return_status VARCHAR2(1);
26: l_msg_count NUMBER;
27: l_msg_data VARCHAR2(2000);

Line 193: WHEN fnd_api.g_exc_error

189: l_count := 0;
190: end if;
191:
192: EXCEPTION
193: WHEN fnd_api.g_exc_error
194: THEN
195: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
196: WHEN fnd_api.g_exc_unexpected_error
197: THEN

Line 196: WHEN fnd_api.g_exc_unexpected_error

192: EXCEPTION
193: WHEN fnd_api.g_exc_error
194: THEN
195: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
196: WHEN fnd_api.g_exc_unexpected_error
197: THEN
198: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
199: WHEN OTHERS
200: THEN

Line 236: WHEN fnd_api.g_exc_error

232: end if;
233:
234:
235: EXCEPTION
236: WHEN fnd_api.g_exc_error
237: THEN
238: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
239: WHEN fnd_api.g_exc_unexpected_error
240: THEN

Line 239: WHEN fnd_api.g_exc_unexpected_error

235: EXCEPTION
236: WHEN fnd_api.g_exc_error
237: THEN
238: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
239: WHEN fnd_api.g_exc_unexpected_error
240: THEN
241: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
242: WHEN OTHERS
243: THEN

Line 277: WHEN fnd_api.g_exc_error

273: end if;
274:
275:
276: EXCEPTION
277: WHEN fnd_api.g_exc_error
278: THEN
279: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
280: WHEN fnd_api.g_exc_unexpected_error
281: THEN

Line 280: WHEN fnd_api.g_exc_unexpected_error

276: EXCEPTION
277: WHEN fnd_api.g_exc_error
278: THEN
279: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
280: WHEN fnd_api.g_exc_unexpected_error
281: THEN
282: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
283: WHEN OTHERS
284: THEN

Line 294: WHEN fnd_api.g_exc_error

290: commit;
291: END IF;
292:
293: EXCEPTION
294: WHEN fnd_api.g_exc_error
295: THEN
296: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
297: WHEN fnd_api.g_exc_unexpected_error
298: THEN

Line 297: WHEN fnd_api.g_exc_unexpected_error

293: EXCEPTION
294: WHEN fnd_api.g_exc_error
295: THEN
296: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
297: WHEN fnd_api.g_exc_unexpected_error
298: THEN
299: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
300: WHEN OTHERS
301: THEN