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 190: WHEN fnd_api.g_exc_error

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

Line 193: WHEN fnd_api.g_exc_unexpected_error

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

Line 231: WHEN fnd_api.g_exc_error

227: end if;
228:
229:
230: EXCEPTION
231: WHEN fnd_api.g_exc_error
232: THEN
233: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
234: WHEN fnd_api.g_exc_unexpected_error
235: THEN

Line 234: WHEN fnd_api.g_exc_unexpected_error

230: EXCEPTION
231: WHEN fnd_api.g_exc_error
232: THEN
233: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
234: WHEN fnd_api.g_exc_unexpected_error
235: THEN
236: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
237: WHEN OTHERS
238: THEN

Line 272: WHEN fnd_api.g_exc_error

268: end if;
269:
270:
271: EXCEPTION
272: WHEN fnd_api.g_exc_error
273: THEN
274: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
275: WHEN fnd_api.g_exc_unexpected_error
276: THEN

Line 275: WHEN fnd_api.g_exc_unexpected_error

271: EXCEPTION
272: WHEN fnd_api.g_exc_error
273: THEN
274: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
275: WHEN fnd_api.g_exc_unexpected_error
276: THEN
277: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
278: WHEN OTHERS
279: THEN

Line 288: WHEN fnd_api.g_exc_error

284:
285: commit;
286:
287: EXCEPTION
288: WHEN fnd_api.g_exc_error
289: THEN
290: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
291: WHEN fnd_api.g_exc_unexpected_error
292: THEN

Line 291: WHEN fnd_api.g_exc_unexpected_error

287: EXCEPTION
288: WHEN fnd_api.g_exc_error
289: THEN
290: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
291: WHEN fnd_api.g_exc_unexpected_error
292: THEN
293: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
294: WHEN OTHERS
295: THEN