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

Line 15: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

11: -------------------------------------------------------------------------------
12: PROCEDURE create_postal_code
13: (
14: p_api_version IN NUMBER,
15: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
16: p_commit IN VARCHAR2 := FND_API.g_false,
17: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
18:
19: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 16: p_commit IN VARCHAR2 := FND_API.g_false,

12: PROCEDURE create_postal_code
13: (
14: p_api_version IN NUMBER,
15: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
16: p_commit IN VARCHAR2 := FND_API.g_false,
17: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
18:
19: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
20: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 17: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

13: (
14: p_api_version IN NUMBER,
15: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
16: p_commit IN VARCHAR2 := FND_API.g_false,
17: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
18:
19: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
20: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
21: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 48: IF FND_API.to_boolean(p_init_msg_list) THEN

44: BEGIN
45: -- initialize
46: SAVEPOINT create_postal_code;
47:
48: IF FND_API.to_boolean(p_init_msg_list) THEN
49: FND_MSG_PUB.initialize;
50: END IF;
51:
52: JTF_Utility_PVT.debug_message(l_full_name || ': start');

Line 54: IF NOT FND_API.compatible_api_call

50: END IF;
51:
52: JTF_Utility_PVT.debug_message(l_full_name || ': start');
53:
54: IF NOT FND_API.compatible_api_call
55: (
56: l_api_version,
57: p_api_version,
58: l_api_name,

Line 62: RAISE FND_API.g_exc_unexpected_error;

58: l_api_name,
59: g_pkg_name
60: )
61: THEN
62: RAISE FND_API.g_exc_unexpected_error;
63: END IF;
64:
65: x_return_status := FND_API.g_ret_sts_success;
66:

Line 65: x_return_status := FND_API.g_ret_sts_success;

61: THEN
62: RAISE FND_API.g_exc_unexpected_error;
63: END IF;
64:
65: x_return_status := FND_API.g_ret_sts_success;
66:
67: -- validate
68: JTF_Utility_PVT.debug_message(l_full_name || ': validate');
69:

Line 81: IF l_return_status = FND_API.g_ret_sts_error THEN

77: x_msg_data => x_msg_data,
78: p_postal_code_rec => l_postal_code_rec
79: );
80:
81: IF l_return_status = FND_API.g_ret_sts_error THEN
82: RAISE FND_API.g_exc_error;
83: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
84: RAISE FND_API.g_exc_unexpected_error;
85: END IF;

Line 82: RAISE FND_API.g_exc_error;

78: p_postal_code_rec => l_postal_code_rec
79: );
80:
81: IF l_return_status = FND_API.g_ret_sts_error THEN
82: RAISE FND_API.g_exc_error;
83: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
84: RAISE FND_API.g_exc_unexpected_error;
85: END IF;
86:

Line 83: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

79: );
80:
81: IF l_return_status = FND_API.g_ret_sts_error THEN
82: RAISE FND_API.g_exc_error;
83: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
84: RAISE FND_API.g_exc_unexpected_error;
85: END IF;
86:
87: -- generate an unique ID if it is not parsed in

Line 84: RAISE FND_API.g_exc_unexpected_error;

80:
81: IF l_return_status = FND_API.g_ret_sts_error THEN
82: RAISE FND_API.g_exc_error;
83: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
84: RAISE FND_API.g_exc_unexpected_error;
85: END IF;
86:
87: -- generate an unique ID if it is not parsed in
88: IF l_postal_code_rec.location_postal_code_id IS NULL THEN

Line 143: IF FND_API.to_boolean(p_commit) THEN

139:
140: -- finish
141: x_postal_code_id := l_postal_code_rec.location_postal_code_id;
142:
143: IF FND_API.to_boolean(p_commit) THEN
144: COMMIT;
145: END IF;
146:
147: FND_MSG_PUB.count_and_get

Line 149: p_encoded => FND_API.g_false,

145: END IF;
146:
147: FND_MSG_PUB.count_and_get
148: (
149: p_encoded => FND_API.g_false,
150: p_count => x_msg_count,
151: p_data => x_msg_data
152: );
153:

Line 158: WHEN FND_API.g_exc_error THEN

154: JTF_Utility_PVT.debug_message(l_full_name||': end');
155:
156: EXCEPTION
157:
158: WHEN FND_API.g_exc_error THEN
159: ROLLBACK TO create_postal_code;
160: x_return_status := FND_API.g_ret_sts_error;
161: FND_MSG_PUB.count_and_get
162: (

Line 160: x_return_status := FND_API.g_ret_sts_error;

156: EXCEPTION
157:
158: WHEN FND_API.g_exc_error THEN
159: ROLLBACK TO create_postal_code;
160: x_return_status := FND_API.g_ret_sts_error;
161: FND_MSG_PUB.count_and_get
162: (
163: p_encoded => FND_API.g_false,
164: p_count => x_msg_count,

Line 163: p_encoded => FND_API.g_false,

159: ROLLBACK TO create_postal_code;
160: x_return_status := FND_API.g_ret_sts_error;
161: FND_MSG_PUB.count_and_get
162: (
163: p_encoded => FND_API.g_false,
164: p_count => x_msg_count,
165: p_data => x_msg_data
166: );
167:

Line 168: WHEN FND_API.g_exc_unexpected_error THEN

164: p_count => x_msg_count,
165: p_data => x_msg_data
166: );
167:
168: WHEN FND_API.g_exc_unexpected_error THEN
169: ROLLBACK TO create_postal_code;
170: x_return_status := FND_API.g_ret_sts_unexp_error;
171: FND_MSG_PUB.count_and_get
172: (

Line 170: x_return_status := FND_API.g_ret_sts_unexp_error;

166: );
167:
168: WHEN FND_API.g_exc_unexpected_error THEN
169: ROLLBACK TO create_postal_code;
170: x_return_status := FND_API.g_ret_sts_unexp_error;
171: FND_MSG_PUB.count_and_get
172: (
173: p_encoded => FND_API.g_false,
174: p_count => x_msg_count,

Line 173: p_encoded => FND_API.g_false,

169: ROLLBACK TO create_postal_code;
170: x_return_status := FND_API.g_ret_sts_unexp_error;
171: FND_MSG_PUB.count_and_get
172: (
173: p_encoded => FND_API.g_false,
174: p_count => x_msg_count,
175: p_data => x_msg_data
176: );
177:

Line 180: x_return_status :=FND_API.g_ret_sts_unexp_error;

176: );
177:
178: WHEN OTHERS THEN
179: ROLLBACK TO create_postal_code;
180: x_return_status :=FND_API.g_ret_sts_unexp_error;
181: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
182: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
183: END IF;
184: FND_MSG_PUB.count_and_get

Line 186: p_encoded => FND_API.g_false,

182: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
183: END IF;
184: FND_MSG_PUB.count_and_get
185: (
186: p_encoded => FND_API.g_false,
187: p_count => x_msg_count,
188: p_data => x_msg_data
189: );
190:

Line 203: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

199: -------------------------------------------------------------------------------
200: PROCEDURE update_postal_code
201: (
202: p_api_version IN NUMBER,
203: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
204: p_commit IN VARCHAR2 := FND_API.g_false,
205: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
206:
207: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 204: p_commit IN VARCHAR2 := FND_API.g_false,

200: PROCEDURE update_postal_code
201: (
202: p_api_version IN NUMBER,
203: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
204: p_commit IN VARCHAR2 := FND_API.g_false,
205: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
206:
207: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
208: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 205: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

201: (
202: p_api_version IN NUMBER,
203: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
204: p_commit IN VARCHAR2 := FND_API.g_false,
205: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
206:
207: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
208: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
209: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 227: IF FND_API.to_boolean(p_init_msg_list) THEN

223:
224: -- initialize
225: SAVEPOINT update_postal_code;
226:
227: IF FND_API.to_boolean(p_init_msg_list) THEN
228: FND_MSG_PUB.initialize;
229: END IF;
230:
231: JTF_Utility_PVT.debug_message(l_full_name || ': start');

Line 233: IF NOT FND_API.compatible_api_call

229: END IF;
230:
231: JTF_Utility_PVT.debug_message(l_full_name || ': start');
232:
233: IF NOT FND_API.compatible_api_call
234: (
235: l_api_version,
236: p_api_version,
237: l_api_name,

Line 241: RAISE FND_API.g_exc_unexpected_error;

237: l_api_name,
238: g_pkg_name
239: )
240: THEN
241: RAISE FND_API.g_exc_unexpected_error;
242: END IF;
243:
244: x_return_status := FND_API.g_ret_sts_success;
245:

Line 244: x_return_status := FND_API.g_ret_sts_success;

240: THEN
241: RAISE FND_API.g_exc_unexpected_error;
242: END IF;
243:
244: x_return_status := FND_API.g_ret_sts_success;
245:
246: -- complete the record
247: complete_rec
248: (

Line 265: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

261: x_return_status => l_return_status,
262: p_postal_code_rec => l_postal_code_rec
263: );
264:
265: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
266: RAISE FND_API.g_exc_unexpected_error;
267: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
268: RAISE FND_API.g_exc_error;
269: END IF;

Line 266: RAISE FND_API.g_exc_unexpected_error;

262: p_postal_code_rec => l_postal_code_rec
263: );
264:
265: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
266: RAISE FND_API.g_exc_unexpected_error;
267: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
268: RAISE FND_API.g_exc_error;
269: END IF;
270: END IF;

Line 267: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

263: );
264:
265: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
266: RAISE FND_API.g_exc_unexpected_error;
267: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
268: RAISE FND_API.g_exc_error;
269: END IF;
270: END IF;
271:

Line 268: RAISE FND_API.g_exc_error;

264:
265: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
266: RAISE FND_API.g_exc_unexpected_error;
267: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
268: RAISE FND_API.g_exc_error;
269: END IF;
270: END IF;
271:
272: -- record level

Line 282: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

278: p_complete_rec => l_postal_code_rec,
279: x_return_status => l_return_status
280: );
281:
282: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
283: RAISE FND_API.g_exc_unexpected_error;
284: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
285: RAISE FND_API.g_exc_error;
286: END IF;

Line 283: RAISE FND_API.g_exc_unexpected_error;

279: x_return_status => l_return_status
280: );
281:
282: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
283: RAISE FND_API.g_exc_unexpected_error;
284: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
285: RAISE FND_API.g_exc_error;
286: END IF;
287: END IF;

Line 284: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

280: );
281:
282: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
283: RAISE FND_API.g_exc_unexpected_error;
284: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
285: RAISE FND_API.g_exc_error;
286: END IF;
287: END IF;
288: END IF;

Line 285: RAISE FND_API.g_exc_error;

281:
282: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
283: RAISE FND_API.g_exc_unexpected_error;
284: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
285: RAISE FND_API.g_exc_error;
286: END IF;
287: END IF;
288: END IF;
289:

Line 320: RAISE FND_API.g_exc_error;

316: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
317: FND_MESSAGE.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');
318: FND_MSG_PUB.add;
319: END IF;
320: RAISE FND_API.g_exc_error;
321: END IF;
322:
323: -- finish
324: IF FND_API.to_boolean(p_commit) THEN

Line 324: IF FND_API.to_boolean(p_commit) THEN

320: RAISE FND_API.g_exc_error;
321: END IF;
322:
323: -- finish
324: IF FND_API.to_boolean(p_commit) THEN
325: COMMIT;
326: END IF;
327:
328: FND_MSG_PUB.count_and_get

Line 330: P_ENCODED => FND_API.g_false,

326: END IF;
327:
328: FND_MSG_PUB.count_and_get
329: (
330: P_ENCODED => FND_API.g_false,
331: p_count => x_msg_count,
332: p_data => x_msg_data
333: );
334:

Line 339: WHEN FND_API.g_exc_error THEN

335: JTF_Utility_PVT.debug_message(l_full_name || ': end');
336:
337: EXCEPTION
338:
339: WHEN FND_API.g_exc_error THEN
340: ROLLBACK TO update_postal_code;
341: x_return_status := FND_API.g_ret_sts_error;
342: FND_MSG_PUB.count_and_get
343: (

Line 341: x_return_status := FND_API.g_ret_sts_error;

337: EXCEPTION
338:
339: WHEN FND_API.g_exc_error THEN
340: ROLLBACK TO update_postal_code;
341: x_return_status := FND_API.g_ret_sts_error;
342: FND_MSG_PUB.count_and_get
343: (
344: p_encoded => FND_API.g_false,
345: p_count => x_msg_count,

Line 344: p_encoded => FND_API.g_false,

340: ROLLBACK TO update_postal_code;
341: x_return_status := FND_API.g_ret_sts_error;
342: FND_MSG_PUB.count_and_get
343: (
344: p_encoded => FND_API.g_false,
345: p_count => x_msg_count,
346: p_data => x_msg_data
347: );
348:

Line 349: WHEN FND_API.g_exc_unexpected_error THEN

345: p_count => x_msg_count,
346: p_data => x_msg_data
347: );
348:
349: WHEN FND_API.g_exc_unexpected_error THEN
350: ROLLBACK TO update_postal_code;
351: x_return_status := FND_API.g_ret_sts_unexp_error;
352: FND_MSG_PUB.count_and_get
353: (

Line 351: x_return_status := FND_API.g_ret_sts_unexp_error;

347: );
348:
349: WHEN FND_API.g_exc_unexpected_error THEN
350: ROLLBACK TO update_postal_code;
351: x_return_status := FND_API.g_ret_sts_unexp_error;
352: FND_MSG_PUB.count_and_get
353: (
354: p_encoded => FND_API.g_false,
355: p_count => x_msg_count,

Line 354: p_encoded => FND_API.g_false,

350: ROLLBACK TO update_postal_code;
351: x_return_status := FND_API.g_ret_sts_unexp_error;
352: FND_MSG_PUB.count_and_get
353: (
354: p_encoded => FND_API.g_false,
355: p_count => x_msg_count,
356: p_data => x_msg_data
357: );
358:

Line 361: x_return_status :=FND_API.g_ret_sts_unexp_error;

357: );
358:
359: WHEN OTHERS THEN
360: ROLLBACK TO update_postal_code;
361: x_return_status :=FND_API.g_ret_sts_unexp_error;
362: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
363: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
364: END IF;
365: FND_MSG_PUB.count_and_get

Line 367: p_encoded => FND_API.g_false,

363: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
364: END IF;
365: FND_MSG_PUB.count_and_get
366: (
367: p_encoded => FND_API.g_false,
368: p_count => x_msg_count,
369: p_data => x_msg_data
370: );
371:

Line 384: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

380: -------------------------------------------------------------------------------
381: PROCEDURE delete_postal_code
382: (
383: p_api_version IN NUMBER,
384: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
385: p_commit IN VARCHAR2 := FND_API.g_false,
386:
387: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
388: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 385: p_commit IN VARCHAR2 := FND_API.g_false,

381: PROCEDURE delete_postal_code
382: (
383: p_api_version IN NUMBER,
384: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
385: p_commit IN VARCHAR2 := FND_API.g_false,
386:
387: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
388: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
389: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 404: IF FND_API.to_boolean(p_init_msg_list) THEN

400: BEGIN
401: -- initialize
402: SAVEPOINT delete_postal_code;
403:
404: IF FND_API.to_boolean(p_init_msg_list) THEN
405: FND_MSG_PUB.initialize;
406: END IF;
407:
408: JTF_Utility_PVT.debug_message(l_full_name || ': start');

Line 410: IF NOT FND_API.compatible_api_call

406: END IF;
407:
408: JTF_Utility_PVT.debug_message(l_full_name || ': start');
409:
410: IF NOT FND_API.compatible_api_call
411: (
412: l_api_version,
413: p_api_version,
414: l_api_name,

Line 418: RAISE FND_API.g_exc_unexpected_error;

414: l_api_name,
415: g_pkg_name
416: )
417: THEN
418: RAISE FND_API.g_exc_unexpected_error;
419: END IF;
420:
421: x_return_status := FND_API.g_ret_sts_success;
422:

Line 421: x_return_status := FND_API.g_ret_sts_success;

417: THEN
418: RAISE FND_API.g_exc_unexpected_error;
419: END IF;
420:
421: x_return_status := FND_API.g_ret_sts_success;
422:
423: -- delete
424: JTF_Utility_PVT.debug_message(l_full_name || ': delete');
425:

Line 435: RAISE FND_API.g_exc_error;

431: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
432: FND_MESSAGE.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');
433: FND_MSG_PUB.add;
434: END IF;
435: RAISE FND_API.g_exc_error;
436: END IF;
437:
438: -- finish
439: IF FND_API.to_boolean(p_commit) THEN

Line 439: IF FND_API.to_boolean(p_commit) THEN

435: RAISE FND_API.g_exc_error;
436: END IF;
437:
438: -- finish
439: IF FND_API.to_boolean(p_commit) THEN
440: COMMIT;
441: END IF;
442:
443: FND_MSG_PUB.count_and_get

Line 445: P_ENCODED => FND_API.g_false,

441: END IF;
442:
443: FND_MSG_PUB.count_and_get
444: (
445: P_ENCODED => FND_API.g_false,
446: p_count => x_msg_count,
447: p_data => x_msg_data
448: );
449:

Line 454: WHEN FND_API.g_exc_error THEN

450: JTF_Utility_PVT.debug_message(l_full_name || ': end');
451:
452: EXCEPTION
453:
454: WHEN FND_API.g_exc_error THEN
455: ROLLBACK TO delete_postal_code;
456: x_return_status := FND_API.g_ret_sts_error;
457: FND_MSG_PUB.count_and_get
458: (

Line 456: x_return_status := FND_API.g_ret_sts_error;

452: EXCEPTION
453:
454: WHEN FND_API.g_exc_error THEN
455: ROLLBACK TO delete_postal_code;
456: x_return_status := FND_API.g_ret_sts_error;
457: FND_MSG_PUB.count_and_get
458: (
459: p_encoded => FND_API.g_false,
460: p_count => x_msg_count,

Line 459: p_encoded => FND_API.g_false,

455: ROLLBACK TO delete_postal_code;
456: x_return_status := FND_API.g_ret_sts_error;
457: FND_MSG_PUB.count_and_get
458: (
459: p_encoded => FND_API.g_false,
460: p_count => x_msg_count,
461: p_data => x_msg_data
462: );
463:

Line 464: WHEN FND_API.g_exc_unexpected_error THEN

460: p_count => x_msg_count,
461: p_data => x_msg_data
462: );
463:
464: WHEN FND_API.g_exc_unexpected_error THEN
465: ROLLBACK TO delete_postal_code;
466: x_return_status := FND_API.g_ret_sts_unexp_error;
467: FND_MSG_PUB.count_and_get
468: (

Line 466: x_return_status := FND_API.g_ret_sts_unexp_error;

462: );
463:
464: WHEN FND_API.g_exc_unexpected_error THEN
465: ROLLBACK TO delete_postal_code;
466: x_return_status := FND_API.g_ret_sts_unexp_error;
467: FND_MSG_PUB.count_and_get
468: (
469: p_encoded => FND_API.g_false,
470: p_count => x_msg_count,

Line 469: p_encoded => FND_API.g_false,

465: ROLLBACK TO delete_postal_code;
466: x_return_status := FND_API.g_ret_sts_unexp_error;
467: FND_MSG_PUB.count_and_get
468: (
469: p_encoded => FND_API.g_false,
470: p_count => x_msg_count,
471: p_data => x_msg_data
472: );
473:

Line 476: x_return_status :=FND_API.g_ret_sts_unexp_error;

472: );
473:
474: WHEN OTHERS THEN
475: ROLLBACK TO delete_postal_code;
476: x_return_status :=FND_API.g_ret_sts_unexp_error;
477: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
478: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
479: END IF;
480: FND_MSG_PUB.count_and_get

Line 482: p_encoded => FND_API.g_false,

478: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
479: END IF;
480: FND_MSG_PUB.count_and_get
481: (
482: p_encoded => FND_API.g_false,
483: p_count => x_msg_count,
484: p_data => x_msg_data
485: );
486:

Line 499: P_init_msg_list IN VARCHAR2 := FND_API.g_false,

495: -------------------------------------------------------------------------------
496: PROCEDURE lock_postal_code
497: (
498: p_api_version IN NUMBER,
499: P_init_msg_list IN VARCHAR2 := FND_API.g_false,
500:
501: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
502: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
503: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 526: IF FND_API.to_boolean(p_init_msg_list) THEN

522: BEGIN
523: -- initialize
524: JTF_Utility_PVT.debug_message(l_full_name || ': start');
525:
526: IF FND_API.to_boolean(p_init_msg_list) THEN
527: FND_MSG_PUB.initialize;
528: END IF;
529:
530: IF NOT FND_API.compatible_api_call

Line 530: IF NOT FND_API.compatible_api_call

526: IF FND_API.to_boolean(p_init_msg_list) THEN
527: FND_MSG_PUB.initialize;
528: END IF;
529:
530: IF NOT FND_API.compatible_api_call
531: (
532: l_api_version,
533: p_api_version,
534: l_api_name,

Line 538: RAISE FND_API.g_exc_unexpected_error;

534: l_api_name,
535: g_pkg_name
536: )
537: THEN
538: RAISE FND_API.g_exc_unexpected_error;
539: END IF;
540:
541: x_return_status := FND_API.g_ret_sts_success;
542:

Line 541: x_return_status := FND_API.g_ret_sts_success;

537: THEN
538: RAISE FND_API.g_exc_unexpected_error;
539: END IF;
540:
541: x_return_status := FND_API.g_ret_sts_success;
542:
543: -- lock
544: JTF_Utility_PVT.debug_message(l_full_name || ': lock');
545:

Line 554: RAISE FND_API.g_exc_error;

550: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
551: FND_MESSAGE.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');
552: FND_MSG_PUB.add;
553: END IF;
554: RAISE FND_API.g_exc_error;
555: END IF;
556: CLOSE c_postal_code;
557:
558: -- finish

Line 561: p_encoded => FND_API.g_false,

557:
558: -- finish
559: FND_MSG_PUB.count_and_get
560: (
561: p_encoded => FND_API.g_false,
562: p_count => x_msg_count,
563: p_data => x_msg_data
564: );
565:

Line 571: x_return_status := FND_API.g_ret_sts_error;

567:
568: EXCEPTION
569:
570: WHEN JTF_Utility_PVT.resource_locked THEN
571: x_return_status := FND_API.g_ret_sts_error;
572: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
573: FND_MESSAGE.set_name('JTF', 'JTF_API_RESOURCE_LOCKED');
574: FND_MSG_PUB.add;
575: END IF;

Line 578: p_encoded => FND_API.g_false,

574: FND_MSG_PUB.add;
575: END IF;
576: FND_MSG_PUB.count_and_get
577: (
578: p_encoded => FND_API.g_false,
579: p_count => x_msg_count,
580: p_data => x_msg_data
581: );
582:

Line 583: WHEN FND_API.g_exc_error THEN

579: p_count => x_msg_count,
580: p_data => x_msg_data
581: );
582:
583: WHEN FND_API.g_exc_error THEN
584: x_return_status := FND_API.g_ret_sts_error;
585: FND_MSG_PUB.count_and_get
586: (
587: p_encoded => FND_API.g_false,

Line 584: x_return_status := FND_API.g_ret_sts_error;

580: p_data => x_msg_data
581: );
582:
583: WHEN FND_API.g_exc_error THEN
584: x_return_status := FND_API.g_ret_sts_error;
585: FND_MSG_PUB.count_and_get
586: (
587: p_encoded => FND_API.g_false,
588: p_count => x_msg_count,

Line 587: p_encoded => FND_API.g_false,

583: WHEN FND_API.g_exc_error THEN
584: x_return_status := FND_API.g_ret_sts_error;
585: FND_MSG_PUB.count_and_get
586: (
587: p_encoded => FND_API.g_false,
588: p_count => x_msg_count,
589: p_data => x_msg_data
590: );
591:

Line 592: WHEN FND_API.g_exc_unexpected_error THEN

588: p_count => x_msg_count,
589: p_data => x_msg_data
590: );
591:
592: WHEN FND_API.g_exc_unexpected_error THEN
593: x_return_status := FND_API.g_ret_sts_unexp_error;
594: FND_MSG_PUB.count_and_get
595: (
596: p_encoded => FND_API.g_false,

Line 593: x_return_status := FND_API.g_ret_sts_unexp_error;

589: p_data => x_msg_data
590: );
591:
592: WHEN FND_API.g_exc_unexpected_error THEN
593: x_return_status := FND_API.g_ret_sts_unexp_error;
594: FND_MSG_PUB.count_and_get
595: (
596: p_encoded => FND_API.g_false,
597: p_count => x_msg_count,

Line 596: p_encoded => FND_API.g_false,

592: WHEN FND_API.g_exc_unexpected_error THEN
593: x_return_status := FND_API.g_ret_sts_unexp_error;
594: FND_MSG_PUB.count_and_get
595: (
596: p_encoded => FND_API.g_false,
597: p_count => x_msg_count,
598: p_data => x_msg_data
599: );
600:

Line 602: x_return_status :=FND_API.g_ret_sts_unexp_error;

598: p_data => x_msg_data
599: );
600:
601: WHEN OTHERS THEN
602: x_return_status :=FND_API.g_ret_sts_unexp_error;
603: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
604: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
605: END IF;
606: FND_MSG_PUB.count_and_get

Line 608: p_encoded => FND_API.g_false,

604: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
605: END IF;
606: FND_MSG_PUB.count_and_get
607: (
608: p_encoded => FND_API.g_false,
609: p_count => x_msg_count,
610: p_data => x_msg_data
611: );
612:

Line 626: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

622: --------------------------------------------------------------------
623: PROCEDURE validate_postal_code
624: (
625: p_api_version IN NUMBER,
626: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
627: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
628:
629: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
630: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 627: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

623: PROCEDURE validate_postal_code
624: (
625: p_api_version IN NUMBER,
626: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
627: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
628:
629: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
630: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
631: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 648: IF NOT FND_API.compatible_api_call

644:
645: ----------------------- initialize --------------------
646: JTF_Utility_PVT.debug_message(l_full_name||': start');
647:
648: IF NOT FND_API.compatible_api_call
649: (
650: l_api_version,
651: p_api_version,
652: l_api_name,

Line 656: RAISE FND_API.g_exc_unexpected_error;

652: l_api_name,
653: g_pkg_name
654: )
655: THEN
656: RAISE FND_API.g_exc_unexpected_error;
657: END IF;
658:
659: x_return_status := FND_API.g_ret_sts_success;
660:

Line 659: x_return_status := FND_API.g_ret_sts_success;

655: THEN
656: RAISE FND_API.g_exc_unexpected_error;
657: END IF;
658:
659: x_return_status := FND_API.g_ret_sts_success;
660:
661: ---------------------- validate ------------------------
662: -- item level
663: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

Line 672: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

668: x_return_status => l_return_status,
669: p_postal_code_rec => p_postal_code_rec
670: );
671:
672: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
673: RAISE FND_API.g_exc_unexpected_error;
674: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
675: RAISE FND_API.g_exc_error;
676: END IF;

Line 673: RAISE FND_API.g_exc_unexpected_error;

669: p_postal_code_rec => p_postal_code_rec
670: );
671:
672: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
673: RAISE FND_API.g_exc_unexpected_error;
674: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
675: RAISE FND_API.g_exc_error;
676: END IF;
677: END IF;

Line 674: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

670: );
671:
672: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
673: RAISE FND_API.g_exc_unexpected_error;
674: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
675: RAISE FND_API.g_exc_error;
676: END IF;
677: END IF;
678:

Line 675: RAISE FND_API.g_exc_error;

671:
672: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
673: RAISE FND_API.g_exc_unexpected_error;
674: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
675: RAISE FND_API.g_exc_error;
676: END IF;
677: END IF;
678:
679: -- record level

Line 689: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

685: p_complete_rec => p_postal_code_rec,
686: x_return_status => l_return_status
687: );
688:
689: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
690: RAISE FND_API.g_exc_unexpected_error;
691: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
692: RAISE FND_API.g_exc_error;
693: END IF;

Line 690: RAISE FND_API.g_exc_unexpected_error;

686: x_return_status => l_return_status
687: );
688:
689: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
690: RAISE FND_API.g_exc_unexpected_error;
691: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
692: RAISE FND_API.g_exc_error;
693: END IF;
694: END IF;

Line 691: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

687: );
688:
689: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
690: RAISE FND_API.g_exc_unexpected_error;
691: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
692: RAISE FND_API.g_exc_error;
693: END IF;
694: END IF;
695:

Line 692: RAISE FND_API.g_exc_error;

688:
689: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
690: RAISE FND_API.g_exc_unexpected_error;
691: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
692: RAISE FND_API.g_exc_error;
693: END IF;
694: END IF;
695:
696: -------------------- finish --------------------------

Line 699: p_encoded => FND_API.g_false,

695:
696: -------------------- finish --------------------------
697: FND_MSG_PUB.count_and_get
698: (
699: p_encoded => FND_API.g_false,
700: p_count => x_msg_count,
701: p_data => x_msg_data
702: );
703:

Line 707: WHEN FND_API.g_exc_error THEN

703:
704: JTF_Utility_PVT.debug_message(l_full_name ||': end');
705:
706: EXCEPTION
707: WHEN FND_API.g_exc_error THEN
708: x_return_status := FND_API.g_ret_sts_error;
709: FND_MSG_PUB.count_and_get
710: (
711: p_encoded => FND_API.g_false,

Line 708: x_return_status := FND_API.g_ret_sts_error;

704: JTF_Utility_PVT.debug_message(l_full_name ||': end');
705:
706: EXCEPTION
707: WHEN FND_API.g_exc_error THEN
708: x_return_status := FND_API.g_ret_sts_error;
709: FND_MSG_PUB.count_and_get
710: (
711: p_encoded => FND_API.g_false,
712: p_count => x_msg_count,

Line 711: p_encoded => FND_API.g_false,

707: WHEN FND_API.g_exc_error THEN
708: x_return_status := FND_API.g_ret_sts_error;
709: FND_MSG_PUB.count_and_get
710: (
711: p_encoded => FND_API.g_false,
712: p_count => x_msg_count,
713: p_data => x_msg_data
714: );
715:

Line 716: WHEN FND_API.g_exc_unexpected_error THEN

712: p_count => x_msg_count,
713: p_data => x_msg_data
714: );
715:
716: WHEN FND_API.g_exc_unexpected_error THEN
717: x_return_status := FND_API.g_ret_sts_unexp_error ;
718: FND_MSG_PUB.count_and_get
719: (
720: p_encoded => FND_API.g_false,

Line 717: x_return_status := FND_API.g_ret_sts_unexp_error ;

713: p_data => x_msg_data
714: );
715:
716: WHEN FND_API.g_exc_unexpected_error THEN
717: x_return_status := FND_API.g_ret_sts_unexp_error ;
718: FND_MSG_PUB.count_and_get
719: (
720: p_encoded => FND_API.g_false,
721: p_count => x_msg_count,

Line 720: p_encoded => FND_API.g_false,

716: WHEN FND_API.g_exc_unexpected_error THEN
717: x_return_status := FND_API.g_ret_sts_unexp_error ;
718: FND_MSG_PUB.count_and_get
719: (
720: p_encoded => FND_API.g_false,
721: p_count => x_msg_count,
722: p_data => x_msg_data
723: );
724:

Line 726: x_return_status := FND_API.g_ret_sts_unexp_error;

722: p_data => x_msg_data
723: );
724:
725: WHEN OTHERS THEN
726: x_return_status := FND_API.g_ret_sts_unexp_error;
727: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
728: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
729: END IF;
730:

Line 733: p_encoded => FND_API.g_false,

729: END IF;
730:
731: FND_MSG_PUB.count_and_get
732: (
733: p_encoded => FND_API.g_false,
734: p_count => x_msg_count,
735: p_data => x_msg_data
736: );
737:

Line 763: x_return_status := FND_API.g_ret_sts_success;

759: BEGIN
760: -- initialize
761: JTF_Utility_PVT.debug_message(l_full_name || ': start');
762:
763: x_return_status := FND_API.g_ret_sts_success;
764:
765: -- check required items
766: JTF_Utility_PVT.debug_message(l_full_name || ': check required items');
767: check_req_items

Line 774: IF x_return_status <> FND_API.g_ret_sts_success THEN

770: p_postal_code_rec => p_postal_code_rec,
771: x_return_status => x_return_status
772: );
773:
774: IF x_return_status <> FND_API.g_ret_sts_success THEN
775: RETURN;
776: END IF;
777:
778: -- check foreign key items

Line 786: IF x_return_status <> FND_API.g_ret_sts_success THEN

782: p_postal_code_rec => p_postal_code_rec,
783: x_return_status => x_return_status
784: );
785:
786: IF x_return_status <> FND_API.g_ret_sts_success THEN
787: RETURN;
788: END IF;
789:
790: END check_items;

Line 809: x_return_status := FND_API.g_ret_sts_success;

805: IS
806:
807: BEGIN
808:
809: x_return_status := FND_API.g_ret_sts_success;
810:
811: -- check location_postal_code_id
812: IF p_postal_code_rec.location_postal_code_id IS NULL
813: AND p_validation_mode = JTF_PLSQL_API.g_update

Line 820: x_return_status := FND_API.g_ret_sts_error;

816: FND_MESSAGE.set_name('JTF', 'JTF_LOC_POS_NO_LOC_POS_CODE_ID');
817: FND_MSG_PUB.add;
818: END IF;
819:
820: x_return_status := FND_API.g_ret_sts_error;
821: RETURN;
822: END IF;
823:
824: -- check object_version_number

Line 833: x_return_status := FND_API.g_ret_sts_error;

829: FND_MESSAGE.set_name('JTF', 'JTF_API_NO_OBJ_VER_NUM');
830: FND_MSG_PUB.add;
831: END IF;
832:
833: x_return_status := FND_API.g_ret_sts_error;
834: RETURN;
835: END IF;
836:
837: -- check location_area_id

Line 844: x_return_status := FND_API.g_ret_sts_error;

840: FND_MESSAGE.set_name('JTF', 'JTF_LOC_POS_NO_LOC_AREA_ID');
841: FND_MSG_PUB.add;
842: END IF;
843:
844: x_return_status := FND_API.g_ret_sts_error;
845: RETURN;
846: END IF;
847:
848: -- check start_date_active

Line 855: x_return_status := FND_API.g_ret_sts_error;

851: FND_MESSAGE.set_name('JTF', 'JTF_LOC_POS_NO_START_DATES');
852: FND_MSG_PUB.add;
853: END IF;
854:
855: x_return_status := FND_API.g_ret_sts_error;
856: RETURN;
857: END IF;
858:
859: END check_req_items;

Line 879: x_return_status := FND_API.g_ret_sts_success;

875: l_fk_flag VARCHAR2(1);
876:
877: BEGIN
878:
879: x_return_status := FND_API.g_ret_sts_success;
880:
881: IF p_postal_code_rec.location_area_id IS NOT NULL THEN
882: l_fk_flag := JTF_Utility_PVT.check_fk_exists
883: (

Line 889: IF l_fk_flag = FND_API.g_false THEN

885: 'location_area_id',
886: p_postal_code_rec.location_area_id
887: );
888:
889: IF l_fk_flag = FND_API.g_false THEN
890: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
891: FND_MESSAGE.set_name('JTF', 'JTF_LOC_POS_BAD_LOC_AREA_ID');
892: FND_MSG_PUB.add;
893: END IF;

Line 895: x_return_status := FND_API.g_ret_sts_error;

891: FND_MESSAGE.set_name('JTF', 'JTF_LOC_POS_BAD_LOC_AREA_ID');
892: FND_MSG_PUB.add;
893: END IF;
894:
895: x_return_status := FND_API.g_ret_sts_error;
896: RETURN;
897: END IF;
898: END IF;
899:

Line 923: x_return_status := FND_API.g_ret_sts_success;

919: l_end_date DATE;
920:
921: BEGIN
922:
923: x_return_status := FND_API.g_ret_sts_success;
924:
925: -- check that start_date_active <= end_date_active
926: IF p_complete_rec.start_date_active <> FND_API.g_miss_date
927: AND p_complete_rec.end_date_active <> FND_API.g_miss_date

Line 926: IF p_complete_rec.start_date_active <> FND_API.g_miss_date

922:
923: x_return_status := FND_API.g_ret_sts_success;
924:
925: -- check that start_date_active <= end_date_active
926: IF p_complete_rec.start_date_active <> FND_API.g_miss_date
927: AND p_complete_rec.end_date_active <> FND_API.g_miss_date
928: AND p_complete_rec.end_date_active IS NOT NULL
929: THEN
930: l_start_date := p_complete_rec.start_date_active;

Line 927: AND p_complete_rec.end_date_active <> FND_API.g_miss_date

923: x_return_status := FND_API.g_ret_sts_success;
924:
925: -- check that start_date_active <= end_date_active
926: IF p_complete_rec.start_date_active <> FND_API.g_miss_date
927: AND p_complete_rec.end_date_active <> FND_API.g_miss_date
928: AND p_complete_rec.end_date_active IS NOT NULL
929: THEN
930: l_start_date := p_complete_rec.start_date_active;
931: l_end_date := p_complete_rec.end_date_active;

Line 938: x_return_status := FND_API.g_ret_sts_error;

934: FND_MESSAGE.set_name('JTF', 'JTF_START_DATE_AFTER_END_DATE');
935: FND_MSG_PUB.add;
936: END IF;
937:
938: x_return_status := FND_API.g_ret_sts_error;
939: RETURN;
940: END IF;
941: END IF;
942:

Line 977: RAISE FND_API.g_exc_error;

973: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
974: FND_MESSAGE.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');
975: FND_MSG_PUB.add;
976: END IF;
977: RAISE FND_API.g_exc_error;
978: END IF;
979: CLOSE c_postal_code;
980:
981: IF p_postal_code_rec.orig_system_ref = FND_API.g_miss_char THEN

Line 981: IF p_postal_code_rec.orig_system_ref = FND_API.g_miss_char THEN

977: RAISE FND_API.g_exc_error;
978: END IF;
979: CLOSE c_postal_code;
980:
981: IF p_postal_code_rec.orig_system_ref = FND_API.g_miss_char THEN
982: x_complete_rec.orig_system_ref := l_postal_code_rec.orig_system_ref;
983: END IF;
984:
985: IF p_postal_code_rec.orig_system_id = FND_API.g_miss_num THEN

Line 985: IF p_postal_code_rec.orig_system_id = FND_API.g_miss_num THEN

981: IF p_postal_code_rec.orig_system_ref = FND_API.g_miss_char THEN
982: x_complete_rec.orig_system_ref := l_postal_code_rec.orig_system_ref;
983: END IF;
984:
985: IF p_postal_code_rec.orig_system_id = FND_API.g_miss_num THEN
986: x_complete_rec.orig_system_id := l_postal_code_rec.orig_system_id;
987: END IF;
988:
989: IF p_postal_code_rec.location_area_id = FND_API.g_miss_num THEN

Line 989: IF p_postal_code_rec.location_area_id = FND_API.g_miss_num THEN

985: IF p_postal_code_rec.orig_system_id = FND_API.g_miss_num THEN
986: x_complete_rec.orig_system_id := l_postal_code_rec.orig_system_id;
987: END IF;
988:
989: IF p_postal_code_rec.location_area_id = FND_API.g_miss_num THEN
990: x_complete_rec.location_area_id := l_postal_code_rec.location_area_id;
991: END IF;
992:
993: IF p_postal_code_rec.start_date_active = FND_API.g_miss_date THEN

Line 993: IF p_postal_code_rec.start_date_active = FND_API.g_miss_date THEN

989: IF p_postal_code_rec.location_area_id = FND_API.g_miss_num THEN
990: x_complete_rec.location_area_id := l_postal_code_rec.location_area_id;
991: END IF;
992:
993: IF p_postal_code_rec.start_date_active = FND_API.g_miss_date THEN
994: x_complete_rec.start_date_active := l_postal_code_rec.start_date_active;
995: END IF;
996:
997: IF p_postal_code_rec.end_date_active = FND_API.g_miss_date THEN

Line 997: IF p_postal_code_rec.end_date_active = FND_API.g_miss_date THEN

993: IF p_postal_code_rec.start_date_active = FND_API.g_miss_date THEN
994: x_complete_rec.start_date_active := l_postal_code_rec.start_date_active;
995: END IF;
996:
997: IF p_postal_code_rec.end_date_active = FND_API.g_miss_date THEN
998: x_complete_rec.end_date_active := l_postal_code_rec.end_date_active;
999: END IF;
1000:
1001: IF p_postal_code_rec.postal_code_start = FND_API.g_miss_char THEN

Line 1001: IF p_postal_code_rec.postal_code_start = FND_API.g_miss_char THEN

997: IF p_postal_code_rec.end_date_active = FND_API.g_miss_date THEN
998: x_complete_rec.end_date_active := l_postal_code_rec.end_date_active;
999: END IF;
1000:
1001: IF p_postal_code_rec.postal_code_start = FND_API.g_miss_char THEN
1002: x_complete_rec.postal_code_start := l_postal_code_rec.postal_code_start;
1003: END IF;
1004:
1005: IF p_postal_code_rec.postal_code_end = FND_API.g_miss_char THEN

Line 1005: IF p_postal_code_rec.postal_code_end = FND_API.g_miss_char THEN

1001: IF p_postal_code_rec.postal_code_start = FND_API.g_miss_char THEN
1002: x_complete_rec.postal_code_start := l_postal_code_rec.postal_code_start;
1003: END IF;
1004:
1005: IF p_postal_code_rec.postal_code_end = FND_API.g_miss_char THEN
1006: x_complete_rec.postal_code_end := l_postal_code_rec.postal_code_end;
1007: END IF;
1008:
1009: END complete_rec;

Line 1027: x_postal_code_rec.location_postal_code_id := FND_API.g_miss_num;

1023: IS
1024:
1025: BEGIN
1026:
1027: x_postal_code_rec.location_postal_code_id := FND_API.g_miss_num;
1028: x_postal_code_rec.last_update_date := FND_API.g_miss_date;
1029: x_postal_code_rec.last_updated_by := FND_API.g_miss_num;
1030: x_postal_code_rec.creation_date := FND_API.g_miss_date;
1031: x_postal_code_rec.created_by := FND_API.g_miss_num;

Line 1028: x_postal_code_rec.last_update_date := FND_API.g_miss_date;

1024:
1025: BEGIN
1026:
1027: x_postal_code_rec.location_postal_code_id := FND_API.g_miss_num;
1028: x_postal_code_rec.last_update_date := FND_API.g_miss_date;
1029: x_postal_code_rec.last_updated_by := FND_API.g_miss_num;
1030: x_postal_code_rec.creation_date := FND_API.g_miss_date;
1031: x_postal_code_rec.created_by := FND_API.g_miss_num;
1032: x_postal_code_rec.last_update_login := FND_API.g_miss_num;

Line 1029: x_postal_code_rec.last_updated_by := FND_API.g_miss_num;

1025: BEGIN
1026:
1027: x_postal_code_rec.location_postal_code_id := FND_API.g_miss_num;
1028: x_postal_code_rec.last_update_date := FND_API.g_miss_date;
1029: x_postal_code_rec.last_updated_by := FND_API.g_miss_num;
1030: x_postal_code_rec.creation_date := FND_API.g_miss_date;
1031: x_postal_code_rec.created_by := FND_API.g_miss_num;
1032: x_postal_code_rec.last_update_login := FND_API.g_miss_num;
1033: x_postal_code_rec.object_version_number := FND_API.g_miss_num;

Line 1030: x_postal_code_rec.creation_date := FND_API.g_miss_date;

1026:
1027: x_postal_code_rec.location_postal_code_id := FND_API.g_miss_num;
1028: x_postal_code_rec.last_update_date := FND_API.g_miss_date;
1029: x_postal_code_rec.last_updated_by := FND_API.g_miss_num;
1030: x_postal_code_rec.creation_date := FND_API.g_miss_date;
1031: x_postal_code_rec.created_by := FND_API.g_miss_num;
1032: x_postal_code_rec.last_update_login := FND_API.g_miss_num;
1033: x_postal_code_rec.object_version_number := FND_API.g_miss_num;
1034: x_postal_code_rec.orig_system_ref := FND_API.g_miss_char;

Line 1031: x_postal_code_rec.created_by := FND_API.g_miss_num;

1027: x_postal_code_rec.location_postal_code_id := FND_API.g_miss_num;
1028: x_postal_code_rec.last_update_date := FND_API.g_miss_date;
1029: x_postal_code_rec.last_updated_by := FND_API.g_miss_num;
1030: x_postal_code_rec.creation_date := FND_API.g_miss_date;
1031: x_postal_code_rec.created_by := FND_API.g_miss_num;
1032: x_postal_code_rec.last_update_login := FND_API.g_miss_num;
1033: x_postal_code_rec.object_version_number := FND_API.g_miss_num;
1034: x_postal_code_rec.orig_system_ref := FND_API.g_miss_char;
1035: x_postal_code_rec.orig_system_id := FND_API.g_miss_num;

Line 1032: x_postal_code_rec.last_update_login := FND_API.g_miss_num;

1028: x_postal_code_rec.last_update_date := FND_API.g_miss_date;
1029: x_postal_code_rec.last_updated_by := FND_API.g_miss_num;
1030: x_postal_code_rec.creation_date := FND_API.g_miss_date;
1031: x_postal_code_rec.created_by := FND_API.g_miss_num;
1032: x_postal_code_rec.last_update_login := FND_API.g_miss_num;
1033: x_postal_code_rec.object_version_number := FND_API.g_miss_num;
1034: x_postal_code_rec.orig_system_ref := FND_API.g_miss_char;
1035: x_postal_code_rec.orig_system_id := FND_API.g_miss_num;
1036: x_postal_code_rec.location_area_id := FND_API.g_miss_num;

Line 1033: x_postal_code_rec.object_version_number := FND_API.g_miss_num;

1029: x_postal_code_rec.last_updated_by := FND_API.g_miss_num;
1030: x_postal_code_rec.creation_date := FND_API.g_miss_date;
1031: x_postal_code_rec.created_by := FND_API.g_miss_num;
1032: x_postal_code_rec.last_update_login := FND_API.g_miss_num;
1033: x_postal_code_rec.object_version_number := FND_API.g_miss_num;
1034: x_postal_code_rec.orig_system_ref := FND_API.g_miss_char;
1035: x_postal_code_rec.orig_system_id := FND_API.g_miss_num;
1036: x_postal_code_rec.location_area_id := FND_API.g_miss_num;
1037: x_postal_code_rec.start_date_active := FND_API.g_miss_date;

Line 1034: x_postal_code_rec.orig_system_ref := FND_API.g_miss_char;

1030: x_postal_code_rec.creation_date := FND_API.g_miss_date;
1031: x_postal_code_rec.created_by := FND_API.g_miss_num;
1032: x_postal_code_rec.last_update_login := FND_API.g_miss_num;
1033: x_postal_code_rec.object_version_number := FND_API.g_miss_num;
1034: x_postal_code_rec.orig_system_ref := FND_API.g_miss_char;
1035: x_postal_code_rec.orig_system_id := FND_API.g_miss_num;
1036: x_postal_code_rec.location_area_id := FND_API.g_miss_num;
1037: x_postal_code_rec.start_date_active := FND_API.g_miss_date;
1038: x_postal_code_rec.end_date_active := FND_API.g_miss_date;

Line 1035: x_postal_code_rec.orig_system_id := FND_API.g_miss_num;

1031: x_postal_code_rec.created_by := FND_API.g_miss_num;
1032: x_postal_code_rec.last_update_login := FND_API.g_miss_num;
1033: x_postal_code_rec.object_version_number := FND_API.g_miss_num;
1034: x_postal_code_rec.orig_system_ref := FND_API.g_miss_char;
1035: x_postal_code_rec.orig_system_id := FND_API.g_miss_num;
1036: x_postal_code_rec.location_area_id := FND_API.g_miss_num;
1037: x_postal_code_rec.start_date_active := FND_API.g_miss_date;
1038: x_postal_code_rec.end_date_active := FND_API.g_miss_date;
1039: x_postal_code_rec.postal_code_start := FND_API.g_miss_char;

Line 1036: x_postal_code_rec.location_area_id := FND_API.g_miss_num;

1032: x_postal_code_rec.last_update_login := FND_API.g_miss_num;
1033: x_postal_code_rec.object_version_number := FND_API.g_miss_num;
1034: x_postal_code_rec.orig_system_ref := FND_API.g_miss_char;
1035: x_postal_code_rec.orig_system_id := FND_API.g_miss_num;
1036: x_postal_code_rec.location_area_id := FND_API.g_miss_num;
1037: x_postal_code_rec.start_date_active := FND_API.g_miss_date;
1038: x_postal_code_rec.end_date_active := FND_API.g_miss_date;
1039: x_postal_code_rec.postal_code_start := FND_API.g_miss_char;
1040: x_postal_code_rec.postal_code_end := FND_API.g_miss_char;

Line 1037: x_postal_code_rec.start_date_active := FND_API.g_miss_date;

1033: x_postal_code_rec.object_version_number := FND_API.g_miss_num;
1034: x_postal_code_rec.orig_system_ref := FND_API.g_miss_char;
1035: x_postal_code_rec.orig_system_id := FND_API.g_miss_num;
1036: x_postal_code_rec.location_area_id := FND_API.g_miss_num;
1037: x_postal_code_rec.start_date_active := FND_API.g_miss_date;
1038: x_postal_code_rec.end_date_active := FND_API.g_miss_date;
1039: x_postal_code_rec.postal_code_start := FND_API.g_miss_char;
1040: x_postal_code_rec.postal_code_end := FND_API.g_miss_char;
1041:

Line 1038: x_postal_code_rec.end_date_active := FND_API.g_miss_date;

1034: x_postal_code_rec.orig_system_ref := FND_API.g_miss_char;
1035: x_postal_code_rec.orig_system_id := FND_API.g_miss_num;
1036: x_postal_code_rec.location_area_id := FND_API.g_miss_num;
1037: x_postal_code_rec.start_date_active := FND_API.g_miss_date;
1038: x_postal_code_rec.end_date_active := FND_API.g_miss_date;
1039: x_postal_code_rec.postal_code_start := FND_API.g_miss_char;
1040: x_postal_code_rec.postal_code_end := FND_API.g_miss_char;
1041:
1042: END init_rec;

Line 1039: x_postal_code_rec.postal_code_start := FND_API.g_miss_char;

1035: x_postal_code_rec.orig_system_id := FND_API.g_miss_num;
1036: x_postal_code_rec.location_area_id := FND_API.g_miss_num;
1037: x_postal_code_rec.start_date_active := FND_API.g_miss_date;
1038: x_postal_code_rec.end_date_active := FND_API.g_miss_date;
1039: x_postal_code_rec.postal_code_start := FND_API.g_miss_char;
1040: x_postal_code_rec.postal_code_end := FND_API.g_miss_char;
1041:
1042: END init_rec;
1043:

Line 1040: x_postal_code_rec.postal_code_end := FND_API.g_miss_char;

1036: x_postal_code_rec.location_area_id := FND_API.g_miss_num;
1037: x_postal_code_rec.start_date_active := FND_API.g_miss_date;
1038: x_postal_code_rec.end_date_active := FND_API.g_miss_date;
1039: x_postal_code_rec.postal_code_start := FND_API.g_miss_char;
1040: x_postal_code_rec.postal_code_end := FND_API.g_miss_char;
1041:
1042: END init_rec;
1043:
1044: END JTF_Loc_Postal_Codes_PVT;