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_AMV_ATTACHMENT_PUB dependencies on FND_API

Line 36: RETURN FND_API.g_true;

32:
33: EXECUTE IMMEDIATE l_sql INTO l_count;
34:
35: IF l_count = 0 THEN
36: RETURN FND_API.g_true;
37: ELSE
38: RETURN FND_API.g_false;
39: END IF;
40:

Line 38: RETURN FND_API.g_false;

34:
35: IF l_count = 0 THEN
36: RETURN FND_API.g_true;
37: ELSE
38: RETURN FND_API.g_false;
39: END IF;
40:
41: END check_uniqueness;
42: --------------------------------------------------------------------------

Line 68: RETURN FND_API.g_false;

64: END IF;
65:
66: EXECUTE IMMEDIATE l_sql INTO l_count;
67: IF l_count = 0 THEN
68: RETURN FND_API.g_false;
69: ELSE
70: RETURN FND_API.g_true;
71: END IF;
72: END check_fk_exists;

Line 70: RETURN FND_API.g_true;

66: EXECUTE IMMEDIATE l_sql INTO l_count;
67: IF l_count = 0 THEN
68: RETURN FND_API.g_false;
69: ELSE
70: RETURN FND_API.g_true;
71: END IF;
72: END check_fk_exists;
73: ---------------------------------------------------------------------
74: FUNCTION check_lookup_exists(

Line 90: RETURN FND_API.g_false;

86:
87: EXECUTE IMMEDIATE l_sql INTO l_count;
88:
89: IF l_count = 0 THEN
90: RETURN FND_API.g_false;
91: ELSE
92: RETURN FND_API.g_true;
93: END IF;
94:

Line 92: RETURN FND_API.g_true;

88:
89: IF l_count = 0 THEN
90: RETURN FND_API.g_false;
91: ELSE
92: RETURN FND_API.g_true;
93: END IF;
94:
95: END check_lookup_exists;
96: ---------------------------------------------------------------------

Line 103: RETURN FND_API.g_true;

99: p_value IN VARCHAR2
100: ) RETURN VARCHAR2 AS
101: BEGIN
102: IF p_value = 'Y' or p_value = 'N' THEN
103: RETURN FND_API.g_true;
104: ELSE
105: RETURN FND_API.g_false;
106: END IF;
107: END is_Y_or_N;

Line 105: RETURN FND_API.g_false;

101: BEGIN
102: IF p_value = 'Y' or p_value = 'N' THEN
103: RETURN FND_API.g_true;
104: ELSE
105: RETURN FND_API.g_false;
106: END IF;
107: END is_Y_or_N;
108: --------------------------------------------------------------------------
109: -- PROCEDURE

Line 121: x_return_status := FND_API.g_ret_sts_success;

117: p_act_attachment_rec IN act_attachment_rec_type,
118: x_return_status OUT NOCOPY VARCHAR2
119: ) AS
120: BEGIN
121: x_return_status := FND_API.g_ret_sts_success;
122:
123: -------------------- put required items here ---------------------
124:
125: --IF p_act_attachment_rec.xxx IS NULL THEN

Line 131: -- x_return_status := FND_API.g_ret_sts_error;

127: -- FND_MESSAGE.set_name('JTF', 'JTF_AMV_API_RECORD_NOT_FOUND');
128: -- FND_MSG_PUB.add;
129: -- END IF;
130:
131: -- x_return_status := FND_API.g_ret_sts_error;
132: -- RETURN;
133: --END IF;
134:
135: END check_act_attachment_req_items;

Line 154: x_return_status := FND_API.g_ret_sts_success;

150: ) AS
151: l_valid_flag VARCHAR2(1);
152: BEGIN
153:
154: x_return_status := FND_API.g_ret_sts_success;
155:
156: -- For create_act_attachment, when attachment_id is passed in, we
157: -- need to check if this attachment_id is unique.
158: IF p_validation_mode = JTF_PLSQL_API.g_create AND

Line 163: ) = FND_API.g_false THEN

159: p_act_attachment_rec.attachment_id IS NOT NULL THEN
160: IF check_uniqueness(
161: 'jtf_amv_attachments',
162: 'attachment_id = ' || p_act_attachment_rec.attachment_id
163: ) = FND_API.g_false THEN
164: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
165: FND_MESSAGE.set_name('JTF', 'JTF_AMV_ACT_ATTACH_DUPL_ID');
166: FND_MSG_PUB.add;
167: END IF;

Line 168: x_return_status := FND_API.g_ret_sts_error;

164: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
165: FND_MESSAGE.set_name('JTF', 'JTF_AMV_ACT_ATTACH_DUPL_ID');
166: FND_MSG_PUB.add;
167: END IF;
168: x_return_status := FND_API.g_ret_sts_error;
169: RETURN;
170: END IF;
171: END IF;
172:

Line 191: x_return_status := FND_API.g_ret_sts_success;

187: x_return_status OUT NOCOPY VARCHAR2
188: ) AS
189: BEGIN
190:
191: x_return_status := FND_API.g_ret_sts_success;
192:
193: /*
194: ----------------------- status_code ------------------------
195: IF p_act_attachment_rec.xxx <> FND_API.g_miss_num THEN

Line 195: IF p_act_attachment_rec.xxx <> FND_API.g_miss_num THEN

191: x_return_status := FND_API.g_ret_sts_success;
192:
193: /*
194: ----------------------- status_code ------------------------
195: IF p_act_attachment_rec.xxx <> FND_API.g_miss_num THEN
196: IF check_fk_exists(
197: 'ams_statuses_vl',
198: 'status_code',
199: 'p_act_attachment_rec.xxx'

Line 200: ) = FND_API.g_false

196: IF check_fk_exists(
197: 'ams_statuses_vl',
198: 'status_code',
199: 'p_act_attachment_rec.xxx'
200: ) = FND_API.g_false
201: THEN
202: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
203: THEN
204: FND_MESSAGE.set_name('JTF', 'JTF_AMV_ACT_ATTACH_BAD_XXX');

Line 208: x_return_status := FND_API.g_ret_sts_error;

204: FND_MESSAGE.set_name('JTF', 'JTF_AMV_ACT_ATTACH_BAD_XXX');
205: FND_MSG_PUB.add;
206: END IF;
207:
208: x_return_status := FND_API.g_ret_sts_error;
209: RETURN;
210: END IF;
211: END IF;
212: */

Line 231: x_return_status := FND_API.g_ret_sts_success;

227: x_return_status OUT NOCOPY VARCHAR2
228: ) AS
229: BEGIN
230:
231: x_return_status := FND_API.g_ret_sts_success;
232:
233: ----------------------- status_code ------------------------
234:
235: -- check other lookup codes

Line 255: x_return_status := FND_API.g_ret_sts_success;

251: )
252: IS
253: BEGIN
254:
255: x_return_status := FND_API.g_ret_sts_success;
256:
257: ----------------------- enabled_flag ------------------------
258: IF p_act_attachment_rec.enabled_flag <> FND_API.g_miss_char
259: AND p_act_attachment_rec.enabled_flag IS NOT NULL

Line 258: IF p_act_attachment_rec.enabled_flag <> FND_API.g_miss_char

254:
255: x_return_status := FND_API.g_ret_sts_success;
256:
257: ----------------------- enabled_flag ------------------------
258: IF p_act_attachment_rec.enabled_flag <> FND_API.g_miss_char
259: AND p_act_attachment_rec.enabled_flag IS NOT NULL
260: THEN
261: IF is_Y_or_N(p_act_attachment_rec.enabled_flag) = FND_API.g_false THEN
262: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 261: IF is_Y_or_N(p_act_attachment_rec.enabled_flag) = FND_API.g_false THEN

257: ----------------------- enabled_flag ------------------------
258: IF p_act_attachment_rec.enabled_flag <> FND_API.g_miss_char
259: AND p_act_attachment_rec.enabled_flag IS NOT NULL
260: THEN
261: IF is_Y_or_N(p_act_attachment_rec.enabled_flag) = FND_API.g_false THEN
262: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
263: THEN
264: FND_MESSAGE.set_name('JTF', 'JTF_AMV_ACT_ATTACH_BAD_FLAG');
265: FND_MSG_PUB.add;

Line 267: x_return_status := FND_API.g_ret_sts_error;

263: THEN
264: FND_MESSAGE.set_name('JTF', 'JTF_AMV_ACT_ATTACH_BAD_FLAG');
265: FND_MSG_PUB.add;
266: END IF;
267: x_return_status := FND_API.g_ret_sts_error;
268: RETURN;
269: END IF;
270: END IF;
271:

Line 273: IF p_act_attachment_rec.can_fulfill_electronic_flag <> FND_API.g_miss_char

269: END IF;
270: END IF;
271:
272: ----------------------- can_fulfill_electronic_flag ------------------------
273: IF p_act_attachment_rec.can_fulfill_electronic_flag <> FND_API.g_miss_char
274: AND p_act_attachment_rec.can_fulfill_electronic_flag IS NOT NULL
275: THEN
276: IF is_Y_or_N(p_act_attachment_rec.can_fulfill_electronic_flag)
277: = FND_API.g_false THEN

Line 277: = FND_API.g_false THEN

273: IF p_act_attachment_rec.can_fulfill_electronic_flag <> FND_API.g_miss_char
274: AND p_act_attachment_rec.can_fulfill_electronic_flag IS NOT NULL
275: THEN
276: IF is_Y_or_N(p_act_attachment_rec.can_fulfill_electronic_flag)
277: = FND_API.g_false THEN
278: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
279: FND_MESSAGE.set_name('JTF', 'JTF_AMV_BAD_CAN_FUL_ELEC');
280: FND_MSG_PUB.add;
281: END IF;

Line 282: x_return_status := FND_API.g_ret_sts_error;

278: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
279: FND_MESSAGE.set_name('JTF', 'JTF_AMV_BAD_CAN_FUL_ELEC');
280: FND_MSG_PUB.add;
281: END IF;
282: x_return_status := FND_API.g_ret_sts_error;
283: RETURN;
284: END IF;
285: END IF;
286: END check_act_attachment_fg_items;

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

298:
299: PROCEDURE create_act_attachment
300: (
301: p_api_version IN NUMBER,
302: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
303: p_commit IN VARCHAR2 := FND_API.g_false,
304: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
305:
306: x_return_status OUT NOCOPY VARCHAR2,

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

299: PROCEDURE create_act_attachment
300: (
301: p_api_version IN NUMBER,
302: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
303: p_commit IN VARCHAR2 := FND_API.g_false,
304: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
305:
306: x_return_status OUT NOCOPY VARCHAR2,
307: x_msg_count OUT NOCOPY NUMBER,

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

300: (
301: p_api_version IN NUMBER,
302: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
303: p_commit IN VARCHAR2 := FND_API.g_false,
304: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
305:
306: x_return_status OUT NOCOPY VARCHAR2,
307: x_msg_count OUT NOCOPY NUMBER,
308: x_msg_data OUT NOCOPY VARCHAR2,

Line 339: IF FND_API.to_boolean(p_init_msg_list) THEN

335: --
336: BEGIN
337: --------------------- initialize -----------------------
338: SAVEPOINT create_act_attachment;
339: IF FND_API.to_boolean(p_init_msg_list) THEN
340: FND_MSG_PUB.initialize;
341: END IF;
342: IF NOT FND_API.compatible_api_call
343: (

Line 342: IF NOT FND_API.compatible_api_call

338: SAVEPOINT create_act_attachment;
339: IF FND_API.to_boolean(p_init_msg_list) THEN
340: FND_MSG_PUB.initialize;
341: END IF;
342: IF NOT FND_API.compatible_api_call
343: (
344: l_api_version,
345: p_api_version,
346: l_api_name,

Line 349: RAISE FND_API.g_exc_unexpected_error;

345: p_api_version,
346: l_api_name,
347: g_pkg_name
348: ) THEN
349: RAISE FND_API.g_exc_unexpected_error;
350: END IF;
351: x_return_status := FND_API.g_ret_sts_success;
352:
353: ----------------------- validate -----------------------

Line 351: x_return_status := FND_API.g_ret_sts_success;

347: g_pkg_name
348: ) THEN
349: RAISE FND_API.g_exc_unexpected_error;
350: END IF;
351: x_return_status := FND_API.g_ret_sts_success;
352:
353: ----------------------- validate -----------------------
354: validate_act_attachment
355: (

Line 357: p_init_msg_list => FND_API.G_FALSE,

353: ----------------------- validate -----------------------
354: validate_act_attachment
355: (
356: p_api_version => l_api_version,
357: p_init_msg_list => FND_API.G_FALSE,
358: p_validation_level => p_validation_level,
359: x_return_status => l_return_status,
360: x_msg_count => x_msg_count,
361: x_msg_data => x_msg_data,

Line 365: IF l_return_status = FND_API.g_ret_sts_error THEN

361: x_msg_data => x_msg_data,
362: p_act_attachment_rec => l_act_attachment_rec
363: );
364:
365: IF l_return_status = FND_API.g_ret_sts_error THEN
366: RAISE FND_API.g_exc_error;
367: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
368: RAISE FND_API.g_exc_unexpected_error;
369: END IF;

Line 366: RAISE FND_API.g_exc_error;

362: p_act_attachment_rec => l_act_attachment_rec
363: );
364:
365: IF l_return_status = FND_API.g_ret_sts_error THEN
366: RAISE FND_API.g_exc_error;
367: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
368: RAISE FND_API.g_exc_unexpected_error;
369: END IF;
370: -------------------------- insert --------------------------

Line 367: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

363: );
364:
365: IF l_return_status = FND_API.g_ret_sts_error THEN
366: RAISE FND_API.g_exc_error;
367: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
368: RAISE FND_API.g_exc_unexpected_error;
369: END IF;
370: -------------------------- insert --------------------------
371: IF l_act_attachment_rec.attachment_id IS NULL THEN

Line 368: RAISE FND_API.g_exc_unexpected_error;

364:
365: IF l_return_status = FND_API.g_ret_sts_error THEN
366: RAISE FND_API.g_exc_error;
367: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
368: RAISE FND_API.g_exc_unexpected_error;
369: END IF;
370: -------------------------- insert --------------------------
371: IF l_act_attachment_rec.attachment_id IS NULL THEN
372: LOOP

Line 395: RAISE FND_API.G_EXC_ERROR;

391: FND_MESSAGE.Set_Token('ID',
392: to_char(nvl(l_act_attachment_rec.attachment_used_by_id,-1)));
393: FND_MSG_PUB.Add;
394: END IF;
395: RAISE FND_API.G_EXC_ERROR;
396: END IF;
397: CLOSE c_get_deli_type_code;
398: END IF;
399: -- Istore specific stuff.

Line 406: RAISE FND_API.G_EXC_ERROR;

402: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
403: FND_MESSAGE.Set_name('JTF','JTF_AMV_FILENAME_NULL');
404: FND_MSG_PUB.Add;
405: END IF;
406: RAISE FND_API.G_EXC_ERROR;
407: END IF;
408: IF (l_act_attachment_rec.attachment_used_by = G_USED_BY_ITEM AND
409: l_act_attachment_rec.display_url is null AND
410: l_deli_type_code = 'MEDIA') THEN

Line 415: RAISE FND_API.G_EXC_ERROR;

411: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
412: FND_MESSAGE.Set_name('JTF','JTF_AMV_DISPLAY_RUL_NULL');
413: FND_MSG_PUB.Add;
414: END IF;
415: RAISE FND_API.G_EXC_ERROR;
416: END IF;
417: END IF;
418: INSERT INTO jtf_amv_attachments
419: (

Line 536: IF FND_API.to_boolean(p_commit) THEN

532: where item_id = l_act_attachment_rec.attachment_used_by_id ;
533: END IF;
534: ------------------------- finish -------------------------------
535: x_act_attachment_id := l_act_attachment_rec.attachment_id;
536: IF FND_API.to_boolean(p_commit) THEN
537: COMMIT;
538: END IF;
539: FND_MSG_PUB.count_and_get
540: (

Line 541: p_encoded => FND_API.g_false,

537: COMMIT;
538: END IF;
539: FND_MSG_PUB.count_and_get
540: (
541: p_encoded => FND_API.g_false,
542: p_count => x_msg_count,
543: p_data => x_msg_data
544: );
545: EXCEPTION

Line 546: WHEN FND_API.g_exc_error THEN

542: p_count => x_msg_count,
543: p_data => x_msg_data
544: );
545: EXCEPTION
546: WHEN FND_API.g_exc_error THEN
547: ROLLBACK TO create_act_attachment;
548: x_return_status := FND_API.g_ret_sts_error;
549: FND_MSG_PUB.count_and_get(
550: p_encoded => FND_API.g_false,

Line 548: x_return_status := FND_API.g_ret_sts_error;

544: );
545: EXCEPTION
546: WHEN FND_API.g_exc_error THEN
547: ROLLBACK TO create_act_attachment;
548: x_return_status := FND_API.g_ret_sts_error;
549: FND_MSG_PUB.count_and_get(
550: p_encoded => FND_API.g_false,
551: p_count => x_msg_count,
552: p_data => x_msg_data

Line 550: p_encoded => FND_API.g_false,

546: WHEN FND_API.g_exc_error THEN
547: ROLLBACK TO create_act_attachment;
548: x_return_status := FND_API.g_ret_sts_error;
549: FND_MSG_PUB.count_and_get(
550: p_encoded => FND_API.g_false,
551: p_count => x_msg_count,
552: p_data => x_msg_data
553: );
554:

Line 555: WHEN FND_API.g_exc_unexpected_error THEN

551: p_count => x_msg_count,
552: p_data => x_msg_data
553: );
554:
555: WHEN FND_API.g_exc_unexpected_error THEN
556: ROLLBACK TO create_act_attachment;
557: x_return_status := FND_API.g_ret_sts_unexp_error ;
558: FND_MSG_PUB.count_and_get(
559: p_encoded => FND_API.g_false,

Line 557: x_return_status := FND_API.g_ret_sts_unexp_error ;

553: );
554:
555: WHEN FND_API.g_exc_unexpected_error THEN
556: ROLLBACK TO create_act_attachment;
557: x_return_status := FND_API.g_ret_sts_unexp_error ;
558: FND_MSG_PUB.count_and_get(
559: p_encoded => FND_API.g_false,
560: p_count => x_msg_count,
561: p_data => x_msg_data

Line 559: p_encoded => FND_API.g_false,

555: WHEN FND_API.g_exc_unexpected_error THEN
556: ROLLBACK TO create_act_attachment;
557: x_return_status := FND_API.g_ret_sts_unexp_error ;
558: FND_MSG_PUB.count_and_get(
559: p_encoded => FND_API.g_false,
560: p_count => x_msg_count,
561: p_data => x_msg_data
562: );
563:

Line 566: x_return_status := FND_API.g_ret_sts_unexp_error ;

562: );
563:
564: WHEN OTHERS THEN
565: ROLLBACK TO create_act_attachment;
566: x_return_status := FND_API.g_ret_sts_unexp_error ;
567: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
568: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
569: END IF;
570: FND_MSG_PUB.count_and_get(

Line 571: p_encoded => FND_API.g_false,

567: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
568: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
569: END IF;
570: FND_MSG_PUB.count_and_get(
571: p_encoded => FND_API.g_false,
572: p_count => x_msg_count,
573: p_data => x_msg_data
574: );
575: END create_act_attachment;

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

583: --------------------------------------------------------------------
584: PROCEDURE delete_act_attachment
585: (
586: p_api_version IN NUMBER,
587: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
588: p_commit IN VARCHAR2 := FND_API.g_false,
589: x_return_status OUT NOCOPY VARCHAR2,
590: x_msg_count OUT NOCOPY NUMBER,
591: x_msg_data OUT NOCOPY VARCHAR2,

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

584: PROCEDURE delete_act_attachment
585: (
586: p_api_version IN NUMBER,
587: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
588: p_commit IN VARCHAR2 := FND_API.g_false,
589: x_return_status OUT NOCOPY VARCHAR2,
590: x_msg_count OUT NOCOPY NUMBER,
591: x_msg_data OUT NOCOPY VARCHAR2,
592: p_act_attachment_id IN NUMBER,

Line 601: IF FND_API.to_boolean(p_init_msg_list) THEN

597: BEGIN
598:
599: --------------------- initialize -----------------------
600: SAVEPOINT delete_act_attachment;
601: IF FND_API.to_boolean(p_init_msg_list) THEN
602: FND_MSG_PUB.initialize;
603: END IF;
604: IF NOT FND_API.compatible_api_call(
605: l_api_version,

Line 604: IF NOT FND_API.compatible_api_call(

600: SAVEPOINT delete_act_attachment;
601: IF FND_API.to_boolean(p_init_msg_list) THEN
602: FND_MSG_PUB.initialize;
603: END IF;
604: IF NOT FND_API.compatible_api_call(
605: l_api_version,
606: p_api_version,
607: l_api_name,
608: g_pkg_name

Line 610: RAISE FND_API.g_exc_unexpected_error;

606: p_api_version,
607: l_api_name,
608: g_pkg_name
609: ) THEN
610: RAISE FND_API.g_exc_unexpected_error;
611: END IF;
612: x_return_status := FND_API.G_RET_STS_SUCCESS;
613:
614: ------------------------ delete ------------------------

Line 612: x_return_status := FND_API.G_RET_STS_SUCCESS;

608: g_pkg_name
609: ) THEN
610: RAISE FND_API.g_exc_unexpected_error;
611: END IF;
612: x_return_status := FND_API.G_RET_STS_SUCCESS;
613:
614: ------------------------ delete ------------------------
615: DELETE FROM jtf_amv_attachments
616: WHERE attachment_id = p_act_attachment_id

Line 624: RAISE FND_API.g_exc_error;

620: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
621: FND_MESSAGE.set_name('JTF', 'JTF_AMV_API_RECORD_NOT_FOUND');
622: FND_MSG_PUB.add;
623: END IF;
624: RAISE FND_API.g_exc_error;
625: END IF;
626:
627: -------------------- finish --------------------------
628: IF FND_API.to_boolean(p_commit) THEN

Line 628: IF FND_API.to_boolean(p_commit) THEN

624: RAISE FND_API.g_exc_error;
625: END IF;
626:
627: -------------------- finish --------------------------
628: IF FND_API.to_boolean(p_commit) THEN
629: COMMIT;
630: END IF;
631: FND_MSG_PUB.count_and_get(
632: p_encoded => FND_API.g_false,

Line 632: p_encoded => FND_API.g_false,

628: IF FND_API.to_boolean(p_commit) THEN
629: COMMIT;
630: END IF;
631: FND_MSG_PUB.count_and_get(
632: p_encoded => FND_API.g_false,
633: p_count => x_msg_count,
634: p_data => x_msg_data
635: );
636:

Line 639: WHEN FND_API.g_exc_error THEN

635: );
636:
637: EXCEPTION
638:
639: WHEN FND_API.g_exc_error THEN
640: ROLLBACK TO delete_act_attachment;
641: x_return_status := FND_API.g_ret_sts_error;
642: FND_MSG_PUB.count_and_get(
643: p_encoded => FND_API.g_false,

Line 641: x_return_status := FND_API.g_ret_sts_error;

637: EXCEPTION
638:
639: WHEN FND_API.g_exc_error THEN
640: ROLLBACK TO delete_act_attachment;
641: x_return_status := FND_API.g_ret_sts_error;
642: FND_MSG_PUB.count_and_get(
643: p_encoded => FND_API.g_false,
644: p_count => x_msg_count,
645: p_data => x_msg_data

Line 643: p_encoded => FND_API.g_false,

639: WHEN FND_API.g_exc_error THEN
640: ROLLBACK TO delete_act_attachment;
641: x_return_status := FND_API.g_ret_sts_error;
642: FND_MSG_PUB.count_and_get(
643: p_encoded => FND_API.g_false,
644: p_count => x_msg_count,
645: p_data => x_msg_data
646: );
647:

Line 648: WHEN FND_API.g_exc_unexpected_error THEN

644: p_count => x_msg_count,
645: p_data => x_msg_data
646: );
647:
648: WHEN FND_API.g_exc_unexpected_error THEN
649: ROLLBACK TO delete_act_attachment;
650: x_return_status := FND_API.g_ret_sts_unexp_error ;
651: FND_MSG_PUB.count_and_get(
652: p_encoded => FND_API.g_false,

Line 650: x_return_status := FND_API.g_ret_sts_unexp_error ;

646: );
647:
648: WHEN FND_API.g_exc_unexpected_error THEN
649: ROLLBACK TO delete_act_attachment;
650: x_return_status := FND_API.g_ret_sts_unexp_error ;
651: FND_MSG_PUB.count_and_get(
652: p_encoded => FND_API.g_false,
653: p_count => x_msg_count,
654: p_data => x_msg_data

Line 652: p_encoded => FND_API.g_false,

648: WHEN FND_API.g_exc_unexpected_error THEN
649: ROLLBACK TO delete_act_attachment;
650: x_return_status := FND_API.g_ret_sts_unexp_error ;
651: FND_MSG_PUB.count_and_get(
652: p_encoded => FND_API.g_false,
653: p_count => x_msg_count,
654: p_data => x_msg_data
655: );
656:

Line 659: x_return_status := FND_API.g_ret_sts_unexp_error ;

655: );
656:
657: WHEN OTHERS THEN
658: ROLLBACK TO delete_act_attachment;
659: x_return_status := FND_API.g_ret_sts_unexp_error ;
660:
661: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
662: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
663: END IF;

Line 666: p_encoded => FND_API.g_false,

662: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
663: END IF;
664:
665: FND_MSG_PUB.count_and_get(
666: p_encoded => FND_API.g_false,
667: p_count => x_msg_count,
668: p_data => x_msg_data
669: );
670: END delete_act_attachment;

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

680:
681: PROCEDURE update_act_attachment
682: (
683: p_api_version IN NUMBER,
684: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
685: p_commit IN VARCHAR2 := FND_API.g_false,
686: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
687:
688: x_return_status OUT NOCOPY VARCHAR2,

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

681: PROCEDURE update_act_attachment
682: (
683: p_api_version IN NUMBER,
684: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
685: p_commit IN VARCHAR2 := FND_API.g_false,
686: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
687:
688: x_return_status OUT NOCOPY VARCHAR2,
689: x_msg_count OUT NOCOPY NUMBER,

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

682: (
683: p_api_version IN NUMBER,
684: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
685: p_commit IN VARCHAR2 := FND_API.g_false,
686: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
687:
688: x_return_status OUT NOCOPY VARCHAR2,
689: x_msg_count OUT NOCOPY NUMBER,
690: x_msg_data OUT NOCOPY VARCHAR2,

Line 708: IF FND_API.to_boolean(p_init_msg_list) THEN

704: --
705: BEGIN
706: -------------------- initialize -------------------------
707: SAVEPOINT update_act_attachment;
708: IF FND_API.to_boolean(p_init_msg_list) THEN
709: FND_MSG_PUB.initialize;
710: END IF;
711: IF NOT FND_API.compatible_api_call
712: (

Line 711: IF NOT FND_API.compatible_api_call

707: SAVEPOINT update_act_attachment;
708: IF FND_API.to_boolean(p_init_msg_list) THEN
709: FND_MSG_PUB.initialize;
710: END IF;
711: IF NOT FND_API.compatible_api_call
712: (
713: l_api_version,
714: p_api_version,
715: l_api_name,

Line 718: RAISE FND_API.g_exc_unexpected_error;

714: p_api_version,
715: l_api_name,
716: g_pkg_name
717: ) THEN
718: RAISE FND_API.g_exc_unexpected_error;
719: END IF;
720: x_return_status := FND_API.G_RET_STS_SUCCESS;
721:
722: ----------------------- validate ----------------------

Line 720: x_return_status := FND_API.G_RET_STS_SUCCESS;

716: g_pkg_name
717: ) THEN
718: RAISE FND_API.g_exc_unexpected_error;
719: END IF;
720: x_return_status := FND_API.G_RET_STS_SUCCESS;
721:
722: ----------------------- validate ----------------------
723: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
724: check_act_attachment_items

Line 731: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

727: p_validation_mode => JTF_PLSQL_API.g_update,
728: x_return_status => l_return_status
729: );
730:
731: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
732: RAISE FND_API.g_exc_unexpected_error;
733: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
734: RAISE FND_API.g_exc_error;
735: END IF;

Line 732: RAISE FND_API.g_exc_unexpected_error;

728: x_return_status => l_return_status
729: );
730:
731: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
732: RAISE FND_API.g_exc_unexpected_error;
733: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
734: RAISE FND_API.g_exc_error;
735: END IF;
736: END IF;

Line 733: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

729: );
730:
731: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
732: RAISE FND_API.g_exc_unexpected_error;
733: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
734: RAISE FND_API.g_exc_error;
735: END IF;
736: END IF;
737:

Line 734: RAISE FND_API.g_exc_error;

730:
731: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
732: RAISE FND_API.g_exc_unexpected_error;
733: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
734: RAISE FND_API.g_exc_error;
735: END IF;
736: END IF;
737:
738: -- replace g_miss_char/num/date with current column values

Line 749: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

745: p_complete_rec => l_act_attachment_rec,
746: x_return_status => l_return_status
747: );
748:
749: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
750: RAISE FND_API.g_exc_unexpected_error;
751: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
752: RAISE FND_API.g_exc_error;
753: END IF;

Line 750: RAISE FND_API.g_exc_unexpected_error;

746: x_return_status => l_return_status
747: );
748:
749: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
750: RAISE FND_API.g_exc_unexpected_error;
751: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
752: RAISE FND_API.g_exc_error;
753: END IF;
754: END IF;

Line 751: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

747: );
748:
749: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
750: RAISE FND_API.g_exc_unexpected_error;
751: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
752: RAISE FND_API.g_exc_error;
753: END IF;
754: END IF;
755: IF (l_act_attachment_rec.attachment_used_by = G_USED_BY_ITEM) THEN

Line 752: RAISE FND_API.g_exc_error;

748:
749: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
750: RAISE FND_API.g_exc_unexpected_error;
751: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
752: RAISE FND_API.g_exc_error;
753: END IF;
754: END IF;
755: IF (l_act_attachment_rec.attachment_used_by = G_USED_BY_ITEM) THEN
756: OPEN c_get_deli_type_code(l_act_attachment_rec.attachment_used_by_id);

Line 766: RAISE FND_API.G_EXC_ERROR;

762: FND_MESSAGE.Set_Token('ID',
763: to_char(nvl(l_act_attachment_rec.attachment_used_by_id,-1)));
764: FND_MSG_PUB.Add;
765: END IF;
766: RAISE FND_API.G_EXC_ERROR;
767: END IF;
768: CLOSE c_get_deli_type_code;
769: END IF;
770: IF (l_act_attachment_rec.application_id = G_ISTORE_APPL_ID) THEN

Line 776: RAISE FND_API.G_EXC_ERROR;

772: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
773: FND_MESSAGE.Set_name('JTF','JTF_AMV_FILENAME_NULL');
774: FND_MSG_PUB.Add;
775: END IF;
776: RAISE FND_API.G_EXC_ERROR;
777: END IF;
778: IF (l_act_attachment_rec.attachment_used_by = G_USED_BY_ITEM AND
779: l_act_attachment_rec.display_url is null AND
780: l_deli_type_code = 'MEDIA') THEN

Line 785: RAISE FND_API.G_EXC_ERROR;

781: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
782: FND_MESSAGE.Set_name('JTF','JTF_AMV_DISPLAY_RUL_NULL');
783: FND_MSG_PUB.Add;
784: END IF;
785: RAISE FND_API.G_EXC_ERROR;
786: END IF;
787: END IF;
788: -------------------------- update --------------------
789: UPDATE jtf_amv_attachments SET

Line 848: RAISE FND_API.g_exc_error;

844: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
845: FND_MESSAGE.set_name('AMS', 'JTF_AMV_API_RECORD_NOT_FOUND');
846: FND_MSG_PUB.add;
847: END IF;
848: RAISE FND_API.g_exc_error;
849: END IF;
850:
851: IF (l_act_attachment_rec.attachment_used_by = G_USED_BY_ITEM) THEN
852: update jtf_amv_items_b

Line 859: IF FND_API.to_boolean(p_commit) THEN

855: last_update_login = FND_GLOBAL.conc_login_id
856: where item_id = l_act_attachment_rec.attachment_used_by_id;
857: END IF;
858: -------------------- finish --------------------------
859: IF FND_API.to_boolean(p_commit) THEN
860: COMMIT;
861: END IF;
862:
863: FND_MSG_PUB.count_and_get

Line 865: p_encoded => FND_API.g_false,

861: END IF;
862:
863: FND_MSG_PUB.count_and_get
864: (
865: p_encoded => FND_API.g_false,
866: p_count => x_msg_count,
867: p_data => x_msg_data
868: );
869:

Line 872: WHEN FND_API.g_exc_error THEN

868: );
869:
870: EXCEPTION
871:
872: WHEN FND_API.g_exc_error THEN
873: ROLLBACK TO update_act_attachment;
874: x_return_status := FND_API.g_ret_sts_error;
875: FND_MSG_PUB.count_and_get
876: (

Line 874: x_return_status := FND_API.g_ret_sts_error;

870: EXCEPTION
871:
872: WHEN FND_API.g_exc_error THEN
873: ROLLBACK TO update_act_attachment;
874: x_return_status := FND_API.g_ret_sts_error;
875: FND_MSG_PUB.count_and_get
876: (
877: p_encoded => FND_API.g_false,
878: p_count => x_msg_count,

Line 877: p_encoded => FND_API.g_false,

873: ROLLBACK TO update_act_attachment;
874: x_return_status := FND_API.g_ret_sts_error;
875: FND_MSG_PUB.count_and_get
876: (
877: p_encoded => FND_API.g_false,
878: p_count => x_msg_count,
879: p_data => x_msg_data
880: );
881:

Line 882: WHEN FND_API.g_exc_unexpected_error THEN

878: p_count => x_msg_count,
879: p_data => x_msg_data
880: );
881:
882: WHEN FND_API.g_exc_unexpected_error THEN
883: ROLLBACK TO update_act_attachment;
884: x_return_status := FND_API.g_ret_sts_unexp_error ;
885: FND_MSG_PUB.count_and_get
886: (

Line 884: x_return_status := FND_API.g_ret_sts_unexp_error ;

880: );
881:
882: WHEN FND_API.g_exc_unexpected_error THEN
883: ROLLBACK TO update_act_attachment;
884: x_return_status := FND_API.g_ret_sts_unexp_error ;
885: FND_MSG_PUB.count_and_get
886: (
887: p_encoded => FND_API.g_false,
888: p_count => x_msg_count,

Line 887: p_encoded => FND_API.g_false,

883: ROLLBACK TO update_act_attachment;
884: x_return_status := FND_API.g_ret_sts_unexp_error ;
885: FND_MSG_PUB.count_and_get
886: (
887: p_encoded => FND_API.g_false,
888: p_count => x_msg_count,
889: p_data => x_msg_data
890: );
891:

Line 894: x_return_status := FND_API.g_ret_sts_unexp_error ;

890: );
891:
892: WHEN OTHERS THEN
893: ROLLBACK TO update_act_attachment;
894: x_return_status := FND_API.g_ret_sts_unexp_error ;
895: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
896: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
897: END IF;
898: FND_MSG_PUB.count_and_get

Line 900: p_encoded => FND_API.g_false,

896: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
897: END IF;
898: FND_MSG_PUB.count_and_get
899: (
900: p_encoded => FND_API.g_false,
901: p_count => x_msg_count,
902: p_data => x_msg_data
903: );
904: END update_act_attachment;

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

911: --------------------------------------------------------------------
912: PROCEDURE lock_act_attachment
913: (
914: p_api_version IN NUMBER,
915: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
916:
917: x_return_status OUT NOCOPY VARCHAR2,
918: x_msg_count OUT NOCOPY NUMBER,
919: x_msg_data OUT NOCOPY VARCHAR2,

Line 938: IF FND_API.to_boolean(p_init_msg_list) THEN

934: FOR UPDATE OF attachment_id NOWAIT;
935:
936: BEGIN
937: -------------------- initialize ------------------------
938: IF FND_API.to_boolean(p_init_msg_list) THEN
939: FND_MSG_PUB.initialize;
940: END IF;
941:
942: IF NOT FND_API.compatible_api_call(

Line 942: IF NOT FND_API.compatible_api_call(

938: IF FND_API.to_boolean(p_init_msg_list) THEN
939: FND_MSG_PUB.initialize;
940: END IF;
941:
942: IF NOT FND_API.compatible_api_call(
943: l_api_version,
944: p_api_version,
945: l_api_name,
946: g_pkg_name

Line 948: RAISE FND_API.g_exc_unexpected_error;

944: p_api_version,
945: l_api_name,
946: g_pkg_name
947: ) THEN
948: RAISE FND_API.g_exc_unexpected_error;
949: END IF;
950:
951: x_return_status := FND_API.G_RET_STS_SUCCESS;
952:

Line 951: x_return_status := FND_API.G_RET_STS_SUCCESS;

947: ) THEN
948: RAISE FND_API.g_exc_unexpected_error;
949: END IF;
950:
951: x_return_status := FND_API.G_RET_STS_SUCCESS;
952:
953: ------------------------ lock -------------------------
954: OPEN c_act_attachment;
955: FETCH c_act_attachment INTO l_act_attachment_id;

Line 962: RAISE FND_API.g_exc_error;

958: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
959: FND_MESSAGE.set_name('AMS', 'JTF_AMV_API_RECORD_NOT_FOUND');
960: FND_MSG_PUB.add;
961: END IF;
962: RAISE FND_API.g_exc_error;
963: END IF;
964: CLOSE c_act_attachment;
965:
966: -------------------- finish --------------------------

Line 969: p_encoded => FND_API.g_false,

965:
966: -------------------- finish --------------------------
967: FND_MSG_PUB.count_and_get
968: (
969: p_encoded => FND_API.g_false,
970: p_count => x_msg_count,
971: p_data => x_msg_data
972: );
973:

Line 975: WHEN FND_API.g_exc_unexpected_error THEN

971: p_data => x_msg_data
972: );
973:
974: EXCEPTION
975: WHEN FND_API.g_exc_unexpected_error THEN
976: x_return_status := FND_API.g_ret_sts_unexp_error ;
977: FND_MSG_PUB.count_and_get(
978: p_encoded => FND_API.g_false,
979: p_count => x_msg_count,

Line 976: x_return_status := FND_API.g_ret_sts_unexp_error ;

972: );
973:
974: EXCEPTION
975: WHEN FND_API.g_exc_unexpected_error THEN
976: x_return_status := FND_API.g_ret_sts_unexp_error ;
977: FND_MSG_PUB.count_and_get(
978: p_encoded => FND_API.g_false,
979: p_count => x_msg_count,
980: p_data => x_msg_data

Line 978: p_encoded => FND_API.g_false,

974: EXCEPTION
975: WHEN FND_API.g_exc_unexpected_error THEN
976: x_return_status := FND_API.g_ret_sts_unexp_error ;
977: FND_MSG_PUB.count_and_get(
978: p_encoded => FND_API.g_false,
979: p_count => x_msg_count,
980: p_data => x_msg_data
981: );
982:

Line 984: x_return_status := FND_API.g_ret_sts_unexp_error ;

980: p_data => x_msg_data
981: );
982:
983: WHEN OTHERS THEN
984: x_return_status := FND_API.g_ret_sts_unexp_error ;
985: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
986: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
987: END IF;
988:

Line 990: p_encoded => FND_API.g_false,

986: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
987: END IF;
988:
989: FND_MSG_PUB.count_and_get(
990: p_encoded => FND_API.g_false,
991: p_count => x_msg_count,
992: p_data => x_msg_data
993: );
994:

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

1002: ----------------------------------------------------------------------
1003: PROCEDURE validate_act_attachment
1004: (
1005: p_api_version IN NUMBER,
1006: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1007: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1008:
1009: x_return_status OUT NOCOPY VARCHAR2,
1010: x_msg_count OUT NOCOPY NUMBER,

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

1003: PROCEDURE validate_act_attachment
1004: (
1005: p_api_version IN NUMBER,
1006: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1007: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1008:
1009: x_return_status OUT NOCOPY VARCHAR2,
1010: x_msg_count OUT NOCOPY NUMBER,
1011: x_msg_data OUT NOCOPY VARCHAR2,

Line 1021: IF FND_API.to_boolean(p_init_msg_list) THEN

1017: l_return_status VARCHAR2(1);
1018:
1019: BEGIN
1020: ----------------------- initialize --------------------
1021: IF FND_API.to_boolean(p_init_msg_list) THEN
1022: FND_MSG_PUB.initialize;
1023: END IF;
1024: IF NOT FND_API.compatible_api_call(
1025: l_api_version,

Line 1024: IF NOT FND_API.compatible_api_call(

1020: ----------------------- initialize --------------------
1021: IF FND_API.to_boolean(p_init_msg_list) THEN
1022: FND_MSG_PUB.initialize;
1023: END IF;
1024: IF NOT FND_API.compatible_api_call(
1025: l_api_version,
1026: p_api_version,
1027: l_api_name,
1028: g_pkg_name

Line 1030: RAISE FND_API.g_exc_unexpected_error;

1026: p_api_version,
1027: l_api_name,
1028: g_pkg_name
1029: ) THEN
1030: RAISE FND_API.g_exc_unexpected_error;
1031: END IF;
1032: x_return_status := FND_API.g_ret_sts_success;
1033:
1034: ---------------------- validate ------------------------

Line 1032: x_return_status := FND_API.g_ret_sts_success;

1028: g_pkg_name
1029: ) THEN
1030: RAISE FND_API.g_exc_unexpected_error;
1031: END IF;
1032: x_return_status := FND_API.g_ret_sts_success;
1033:
1034: ---------------------- validate ------------------------
1035: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1036: check_act_attachment_items

Line 1042: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1038: p_act_attachment_rec => p_act_attachment_rec,
1039: p_validation_mode => JTF_PLSQL_API.g_create,
1040: x_return_status => l_return_status
1041: );
1042: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1043: RAISE FND_API.g_exc_unexpected_error;
1044: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1045: RAISE FND_API.g_exc_error;
1046: END IF;

Line 1043: RAISE FND_API.g_exc_unexpected_error;

1039: p_validation_mode => JTF_PLSQL_API.g_create,
1040: x_return_status => l_return_status
1041: );
1042: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1043: RAISE FND_API.g_exc_unexpected_error;
1044: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1045: RAISE FND_API.g_exc_error;
1046: END IF;
1047: END IF;

Line 1044: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

1040: x_return_status => l_return_status
1041: );
1042: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1043: RAISE FND_API.g_exc_unexpected_error;
1044: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1045: RAISE FND_API.g_exc_error;
1046: END IF;
1047: END IF;
1048:

Line 1045: RAISE FND_API.g_exc_error;

1041: );
1042: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1043: RAISE FND_API.g_exc_unexpected_error;
1044: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1045: RAISE FND_API.g_exc_error;
1046: END IF;
1047: END IF;
1048:
1049: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

Line 1057: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1053: p_complete_rec => NULL,
1054: x_return_status => l_return_status
1055: );
1056:
1057: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1058: RAISE FND_API.g_exc_unexpected_error;
1059: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1060: RAISE FND_API.g_exc_error;
1061: END IF;

Line 1058: RAISE FND_API.g_exc_unexpected_error;

1054: x_return_status => l_return_status
1055: );
1056:
1057: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1058: RAISE FND_API.g_exc_unexpected_error;
1059: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1060: RAISE FND_API.g_exc_error;
1061: END IF;
1062: END IF;

Line 1059: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

1055: );
1056:
1057: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1058: RAISE FND_API.g_exc_unexpected_error;
1059: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1060: RAISE FND_API.g_exc_error;
1061: END IF;
1062: END IF;
1063:

Line 1060: RAISE FND_API.g_exc_error;

1056:
1057: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1058: RAISE FND_API.g_exc_unexpected_error;
1059: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1060: RAISE FND_API.g_exc_error;
1061: END IF;
1062: END IF;
1063:
1064: -------------------- finish --------------------------

Line 1067: p_encoded => FND_API.g_false,

1063:
1064: -------------------- finish --------------------------
1065: FND_MSG_PUB.count_and_get
1066: (
1067: p_encoded => FND_API.g_false,
1068: p_count => x_msg_count,
1069: p_data => x_msg_data
1070: );
1071:

Line 1074: WHEN FND_API.g_exc_error THEN

1070: );
1071:
1072: EXCEPTION
1073:
1074: WHEN FND_API.g_exc_error THEN
1075: x_return_status := FND_API.g_ret_sts_error;
1076: FND_MSG_PUB.count_and_get(
1077: p_encoded => FND_API.g_false,
1078: p_count => x_msg_count,

Line 1075: x_return_status := FND_API.g_ret_sts_error;

1071:
1072: EXCEPTION
1073:
1074: WHEN FND_API.g_exc_error THEN
1075: x_return_status := FND_API.g_ret_sts_error;
1076: FND_MSG_PUB.count_and_get(
1077: p_encoded => FND_API.g_false,
1078: p_count => x_msg_count,
1079: p_data => x_msg_data

Line 1077: p_encoded => FND_API.g_false,

1073:
1074: WHEN FND_API.g_exc_error THEN
1075: x_return_status := FND_API.g_ret_sts_error;
1076: FND_MSG_PUB.count_and_get(
1077: p_encoded => FND_API.g_false,
1078: p_count => x_msg_count,
1079: p_data => x_msg_data
1080: );
1081:

Line 1082: WHEN FND_API.g_exc_unexpected_error THEN

1078: p_count => x_msg_count,
1079: p_data => x_msg_data
1080: );
1081:
1082: WHEN FND_API.g_exc_unexpected_error THEN
1083: x_return_status := FND_API.g_ret_sts_unexp_error ;
1084: FND_MSG_PUB.count_and_get(
1085: p_encoded => FND_API.g_false,
1086: p_count => x_msg_count,

Line 1083: x_return_status := FND_API.g_ret_sts_unexp_error ;

1079: p_data => x_msg_data
1080: );
1081:
1082: WHEN FND_API.g_exc_unexpected_error THEN
1083: x_return_status := FND_API.g_ret_sts_unexp_error ;
1084: FND_MSG_PUB.count_and_get(
1085: p_encoded => FND_API.g_false,
1086: p_count => x_msg_count,
1087: p_data => x_msg_data

Line 1085: p_encoded => FND_API.g_false,

1081:
1082: WHEN FND_API.g_exc_unexpected_error THEN
1083: x_return_status := FND_API.g_ret_sts_unexp_error ;
1084: FND_MSG_PUB.count_and_get(
1085: p_encoded => FND_API.g_false,
1086: p_count => x_msg_count,
1087: p_data => x_msg_data
1088: );
1089:

Line 1091: x_return_status := FND_API.g_ret_sts_unexp_error;

1087: p_data => x_msg_data
1088: );
1089:
1090: WHEN OTHERS THEN
1091: x_return_status := FND_API.g_ret_sts_unexp_error;
1092: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1093: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1094: END IF;
1095:

Line 1097: p_encoded => FND_API.g_false,

1093: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1094: END IF;
1095:
1096: FND_MSG_PUB.count_and_get(
1097: p_encoded => FND_API.g_false,
1098: p_count => x_msg_count,
1099: p_data => x_msg_data
1100: );
1101: END validate_act_attachment;

Line 1124: IF x_return_status <> FND_API.g_ret_sts_success THEN

1120: p_act_attachment_rec => p_act_attachment_rec,
1121: x_return_status => x_return_status
1122: );
1123:
1124: IF x_return_status <> FND_API.g_ret_sts_success THEN
1125: RETURN;
1126: END IF;
1127:
1128: check_act_attachment_uk_items

Line 1135: IF x_return_status <> FND_API.g_ret_sts_success THEN

1131: p_validation_mode => p_validation_mode,
1132: x_return_status => x_return_status
1133: );
1134:
1135: IF x_return_status <> FND_API.g_ret_sts_success THEN
1136: RETURN;
1137: END IF;
1138:
1139: check_act_attachment_fk_items

Line 1145: IF x_return_status <> FND_API.g_ret_sts_success THEN

1141: p_act_attachment_rec => p_act_attachment_rec,
1142: x_return_status => x_return_status
1143: );
1144:
1145: IF x_return_status <> FND_API.g_ret_sts_success THEN
1146: RETURN;
1147: END IF;
1148:
1149: check_act_attachment_lk_items

Line 1155: IF x_return_status <> FND_API.g_ret_sts_success THEN

1151: p_act_attachment_rec => p_act_attachment_rec,
1152: x_return_status => x_return_status
1153: );
1154:
1155: IF x_return_status <> FND_API.g_ret_sts_success THEN
1156: RETURN;
1157: END IF;
1158:
1159: check_act_attachment_fg_items

Line 1165: IF x_return_status <> FND_API.g_ret_sts_success THEN

1161: p_act_attachment_rec => p_act_attachment_rec,
1162: x_return_status => x_return_status
1163: );
1164:
1165: IF x_return_status <> FND_API.g_ret_sts_success THEN
1166: RETURN;
1167: END IF;
1168:
1169: END check_act_attachment_items;

Line 1186: x_return_status := FND_API.g_ret_sts_success;

1182: x_return_status OUT NOCOPY VARCHAR2
1183: )
1184: IS
1185: BEGIN
1186: x_return_status := FND_API.g_ret_sts_success;
1187:
1188: -- do other record level checkings
1189:
1190: END check_act_attachment_record;

Line 1197: -- Initialize all attributes to be FND_API.g_miss_char/num/date.

1193: -- PROCEDURE
1194: -- miss_act_attachment_rec
1195: --
1196: -- PURPOSE
1197: -- Initialize all attributes to be FND_API.g_miss_char/num/date.
1198: -- History
1199: -- 06/20/00 rmajumda Assigning values to three more columns
1200: -- display_text,alternate_text and
1201: -- attachment_sub_type

Line 1210: x_act_attachment_rec.attachment_id := FND_API.g_miss_num;

1206: x_act_attachment_rec OUT NOCOPY act_attachment_rec_type
1207: ) AS
1208:
1209: BEGIN
1210: x_act_attachment_rec.attachment_id := FND_API.g_miss_num;
1211: x_act_attachment_rec.last_update_date := FND_API.g_miss_date;
1212: x_act_attachment_rec.last_updated_by := FND_API.g_miss_num;
1213: x_act_attachment_rec.creation_date := FND_API.g_miss_date;
1214: x_act_attachment_rec.created_by := FND_API.g_miss_num;

Line 1211: x_act_attachment_rec.last_update_date := FND_API.g_miss_date;

1207: ) AS
1208:
1209: BEGIN
1210: x_act_attachment_rec.attachment_id := FND_API.g_miss_num;
1211: x_act_attachment_rec.last_update_date := FND_API.g_miss_date;
1212: x_act_attachment_rec.last_updated_by := FND_API.g_miss_num;
1213: x_act_attachment_rec.creation_date := FND_API.g_miss_date;
1214: x_act_attachment_rec.created_by := FND_API.g_miss_num;
1215: x_act_attachment_rec.last_update_login := FND_API.g_miss_num;

Line 1212: x_act_attachment_rec.last_updated_by := FND_API.g_miss_num;

1208:
1209: BEGIN
1210: x_act_attachment_rec.attachment_id := FND_API.g_miss_num;
1211: x_act_attachment_rec.last_update_date := FND_API.g_miss_date;
1212: x_act_attachment_rec.last_updated_by := FND_API.g_miss_num;
1213: x_act_attachment_rec.creation_date := FND_API.g_miss_date;
1214: x_act_attachment_rec.created_by := FND_API.g_miss_num;
1215: x_act_attachment_rec.last_update_login := FND_API.g_miss_num;
1216: x_act_attachment_rec.object_version_number := FND_API.g_miss_num;

Line 1213: x_act_attachment_rec.creation_date := FND_API.g_miss_date;

1209: BEGIN
1210: x_act_attachment_rec.attachment_id := FND_API.g_miss_num;
1211: x_act_attachment_rec.last_update_date := FND_API.g_miss_date;
1212: x_act_attachment_rec.last_updated_by := FND_API.g_miss_num;
1213: x_act_attachment_rec.creation_date := FND_API.g_miss_date;
1214: x_act_attachment_rec.created_by := FND_API.g_miss_num;
1215: x_act_attachment_rec.last_update_login := FND_API.g_miss_num;
1216: x_act_attachment_rec.object_version_number := FND_API.g_miss_num;
1217: x_act_attachment_rec.owner_user_id := FND_API.g_miss_num;

Line 1214: x_act_attachment_rec.created_by := FND_API.g_miss_num;

1210: x_act_attachment_rec.attachment_id := FND_API.g_miss_num;
1211: x_act_attachment_rec.last_update_date := FND_API.g_miss_date;
1212: x_act_attachment_rec.last_updated_by := FND_API.g_miss_num;
1213: x_act_attachment_rec.creation_date := FND_API.g_miss_date;
1214: x_act_attachment_rec.created_by := FND_API.g_miss_num;
1215: x_act_attachment_rec.last_update_login := FND_API.g_miss_num;
1216: x_act_attachment_rec.object_version_number := FND_API.g_miss_num;
1217: x_act_attachment_rec.owner_user_id := FND_API.g_miss_num;
1218: x_act_attachment_rec.attachment_used_by_id := FND_API.g_miss_num;

Line 1215: x_act_attachment_rec.last_update_login := FND_API.g_miss_num;

1211: x_act_attachment_rec.last_update_date := FND_API.g_miss_date;
1212: x_act_attachment_rec.last_updated_by := FND_API.g_miss_num;
1213: x_act_attachment_rec.creation_date := FND_API.g_miss_date;
1214: x_act_attachment_rec.created_by := FND_API.g_miss_num;
1215: x_act_attachment_rec.last_update_login := FND_API.g_miss_num;
1216: x_act_attachment_rec.object_version_number := FND_API.g_miss_num;
1217: x_act_attachment_rec.owner_user_id := FND_API.g_miss_num;
1218: x_act_attachment_rec.attachment_used_by_id := FND_API.g_miss_num;
1219: x_act_attachment_rec.attachment_used_by := FND_API.g_miss_char;

Line 1216: x_act_attachment_rec.object_version_number := FND_API.g_miss_num;

1212: x_act_attachment_rec.last_updated_by := FND_API.g_miss_num;
1213: x_act_attachment_rec.creation_date := FND_API.g_miss_date;
1214: x_act_attachment_rec.created_by := FND_API.g_miss_num;
1215: x_act_attachment_rec.last_update_login := FND_API.g_miss_num;
1216: x_act_attachment_rec.object_version_number := FND_API.g_miss_num;
1217: x_act_attachment_rec.owner_user_id := FND_API.g_miss_num;
1218: x_act_attachment_rec.attachment_used_by_id := FND_API.g_miss_num;
1219: x_act_attachment_rec.attachment_used_by := FND_API.g_miss_char;
1220: x_act_attachment_rec.version := FND_API.g_miss_char;

Line 1217: x_act_attachment_rec.owner_user_id := FND_API.g_miss_num;

1213: x_act_attachment_rec.creation_date := FND_API.g_miss_date;
1214: x_act_attachment_rec.created_by := FND_API.g_miss_num;
1215: x_act_attachment_rec.last_update_login := FND_API.g_miss_num;
1216: x_act_attachment_rec.object_version_number := FND_API.g_miss_num;
1217: x_act_attachment_rec.owner_user_id := FND_API.g_miss_num;
1218: x_act_attachment_rec.attachment_used_by_id := FND_API.g_miss_num;
1219: x_act_attachment_rec.attachment_used_by := FND_API.g_miss_char;
1220: x_act_attachment_rec.version := FND_API.g_miss_char;
1221: x_act_attachment_rec.enabled_flag := FND_API.g_miss_char;

Line 1218: x_act_attachment_rec.attachment_used_by_id := FND_API.g_miss_num;

1214: x_act_attachment_rec.created_by := FND_API.g_miss_num;
1215: x_act_attachment_rec.last_update_login := FND_API.g_miss_num;
1216: x_act_attachment_rec.object_version_number := FND_API.g_miss_num;
1217: x_act_attachment_rec.owner_user_id := FND_API.g_miss_num;
1218: x_act_attachment_rec.attachment_used_by_id := FND_API.g_miss_num;
1219: x_act_attachment_rec.attachment_used_by := FND_API.g_miss_char;
1220: x_act_attachment_rec.version := FND_API.g_miss_char;
1221: x_act_attachment_rec.enabled_flag := FND_API.g_miss_char;
1222: x_act_attachment_rec.can_fulfill_electronic_flag := FND_API.g_miss_char;

Line 1219: x_act_attachment_rec.attachment_used_by := FND_API.g_miss_char;

1215: x_act_attachment_rec.last_update_login := FND_API.g_miss_num;
1216: x_act_attachment_rec.object_version_number := FND_API.g_miss_num;
1217: x_act_attachment_rec.owner_user_id := FND_API.g_miss_num;
1218: x_act_attachment_rec.attachment_used_by_id := FND_API.g_miss_num;
1219: x_act_attachment_rec.attachment_used_by := FND_API.g_miss_char;
1220: x_act_attachment_rec.version := FND_API.g_miss_char;
1221: x_act_attachment_rec.enabled_flag := FND_API.g_miss_char;
1222: x_act_attachment_rec.can_fulfill_electronic_flag := FND_API.g_miss_char;
1223: x_act_attachment_rec.file_id := FND_API.g_miss_num;

Line 1220: x_act_attachment_rec.version := FND_API.g_miss_char;

1216: x_act_attachment_rec.object_version_number := FND_API.g_miss_num;
1217: x_act_attachment_rec.owner_user_id := FND_API.g_miss_num;
1218: x_act_attachment_rec.attachment_used_by_id := FND_API.g_miss_num;
1219: x_act_attachment_rec.attachment_used_by := FND_API.g_miss_char;
1220: x_act_attachment_rec.version := FND_API.g_miss_char;
1221: x_act_attachment_rec.enabled_flag := FND_API.g_miss_char;
1222: x_act_attachment_rec.can_fulfill_electronic_flag := FND_API.g_miss_char;
1223: x_act_attachment_rec.file_id := FND_API.g_miss_num;
1224: x_act_attachment_rec.file_name := FND_API.g_miss_char;

Line 1221: x_act_attachment_rec.enabled_flag := FND_API.g_miss_char;

1217: x_act_attachment_rec.owner_user_id := FND_API.g_miss_num;
1218: x_act_attachment_rec.attachment_used_by_id := FND_API.g_miss_num;
1219: x_act_attachment_rec.attachment_used_by := FND_API.g_miss_char;
1220: x_act_attachment_rec.version := FND_API.g_miss_char;
1221: x_act_attachment_rec.enabled_flag := FND_API.g_miss_char;
1222: x_act_attachment_rec.can_fulfill_electronic_flag := FND_API.g_miss_char;
1223: x_act_attachment_rec.file_id := FND_API.g_miss_num;
1224: x_act_attachment_rec.file_name := FND_API.g_miss_char;
1225: x_act_attachment_rec.file_extension := FND_API.g_miss_char;

Line 1222: x_act_attachment_rec.can_fulfill_electronic_flag := FND_API.g_miss_char;

1218: x_act_attachment_rec.attachment_used_by_id := FND_API.g_miss_num;
1219: x_act_attachment_rec.attachment_used_by := FND_API.g_miss_char;
1220: x_act_attachment_rec.version := FND_API.g_miss_char;
1221: x_act_attachment_rec.enabled_flag := FND_API.g_miss_char;
1222: x_act_attachment_rec.can_fulfill_electronic_flag := FND_API.g_miss_char;
1223: x_act_attachment_rec.file_id := FND_API.g_miss_num;
1224: x_act_attachment_rec.file_name := FND_API.g_miss_char;
1225: x_act_attachment_rec.file_extension := FND_API.g_miss_char;
1226: x_act_attachment_rec.keywords := FND_API.g_miss_char;

Line 1223: x_act_attachment_rec.file_id := FND_API.g_miss_num;

1219: x_act_attachment_rec.attachment_used_by := FND_API.g_miss_char;
1220: x_act_attachment_rec.version := FND_API.g_miss_char;
1221: x_act_attachment_rec.enabled_flag := FND_API.g_miss_char;
1222: x_act_attachment_rec.can_fulfill_electronic_flag := FND_API.g_miss_char;
1223: x_act_attachment_rec.file_id := FND_API.g_miss_num;
1224: x_act_attachment_rec.file_name := FND_API.g_miss_char;
1225: x_act_attachment_rec.file_extension := FND_API.g_miss_char;
1226: x_act_attachment_rec.keywords := FND_API.g_miss_char;
1227: x_act_attachment_rec.document_id := FND_API.g_miss_num;

Line 1224: x_act_attachment_rec.file_name := FND_API.g_miss_char;

1220: x_act_attachment_rec.version := FND_API.g_miss_char;
1221: x_act_attachment_rec.enabled_flag := FND_API.g_miss_char;
1222: x_act_attachment_rec.can_fulfill_electronic_flag := FND_API.g_miss_char;
1223: x_act_attachment_rec.file_id := FND_API.g_miss_num;
1224: x_act_attachment_rec.file_name := FND_API.g_miss_char;
1225: x_act_attachment_rec.file_extension := FND_API.g_miss_char;
1226: x_act_attachment_rec.keywords := FND_API.g_miss_char;
1227: x_act_attachment_rec.document_id := FND_API.g_miss_num;
1228: x_act_attachment_rec.display_width := FND_API.g_miss_num;

Line 1225: x_act_attachment_rec.file_extension := FND_API.g_miss_char;

1221: x_act_attachment_rec.enabled_flag := FND_API.g_miss_char;
1222: x_act_attachment_rec.can_fulfill_electronic_flag := FND_API.g_miss_char;
1223: x_act_attachment_rec.file_id := FND_API.g_miss_num;
1224: x_act_attachment_rec.file_name := FND_API.g_miss_char;
1225: x_act_attachment_rec.file_extension := FND_API.g_miss_char;
1226: x_act_attachment_rec.keywords := FND_API.g_miss_char;
1227: x_act_attachment_rec.document_id := FND_API.g_miss_num;
1228: x_act_attachment_rec.display_width := FND_API.g_miss_num;
1229: x_act_attachment_rec.display_height := FND_API.g_miss_num;

Line 1226: x_act_attachment_rec.keywords := FND_API.g_miss_char;

1222: x_act_attachment_rec.can_fulfill_electronic_flag := FND_API.g_miss_char;
1223: x_act_attachment_rec.file_id := FND_API.g_miss_num;
1224: x_act_attachment_rec.file_name := FND_API.g_miss_char;
1225: x_act_attachment_rec.file_extension := FND_API.g_miss_char;
1226: x_act_attachment_rec.keywords := FND_API.g_miss_char;
1227: x_act_attachment_rec.document_id := FND_API.g_miss_num;
1228: x_act_attachment_rec.display_width := FND_API.g_miss_num;
1229: x_act_attachment_rec.display_height := FND_API.g_miss_num;
1230: x_act_attachment_rec.display_location := FND_API.g_miss_char;

Line 1227: x_act_attachment_rec.document_id := FND_API.g_miss_num;

1223: x_act_attachment_rec.file_id := FND_API.g_miss_num;
1224: x_act_attachment_rec.file_name := FND_API.g_miss_char;
1225: x_act_attachment_rec.file_extension := FND_API.g_miss_char;
1226: x_act_attachment_rec.keywords := FND_API.g_miss_char;
1227: x_act_attachment_rec.document_id := FND_API.g_miss_num;
1228: x_act_attachment_rec.display_width := FND_API.g_miss_num;
1229: x_act_attachment_rec.display_height := FND_API.g_miss_num;
1230: x_act_attachment_rec.display_location := FND_API.g_miss_char;
1231: x_act_attachment_rec.link_to := FND_API.g_miss_char;

Line 1228: x_act_attachment_rec.display_width := FND_API.g_miss_num;

1224: x_act_attachment_rec.file_name := FND_API.g_miss_char;
1225: x_act_attachment_rec.file_extension := FND_API.g_miss_char;
1226: x_act_attachment_rec.keywords := FND_API.g_miss_char;
1227: x_act_attachment_rec.document_id := FND_API.g_miss_num;
1228: x_act_attachment_rec.display_width := FND_API.g_miss_num;
1229: x_act_attachment_rec.display_height := FND_API.g_miss_num;
1230: x_act_attachment_rec.display_location := FND_API.g_miss_char;
1231: x_act_attachment_rec.link_to := FND_API.g_miss_char;
1232: x_act_attachment_rec.link_url := FND_API.g_miss_char;

Line 1229: x_act_attachment_rec.display_height := FND_API.g_miss_num;

1225: x_act_attachment_rec.file_extension := FND_API.g_miss_char;
1226: x_act_attachment_rec.keywords := FND_API.g_miss_char;
1227: x_act_attachment_rec.document_id := FND_API.g_miss_num;
1228: x_act_attachment_rec.display_width := FND_API.g_miss_num;
1229: x_act_attachment_rec.display_height := FND_API.g_miss_num;
1230: x_act_attachment_rec.display_location := FND_API.g_miss_char;
1231: x_act_attachment_rec.link_to := FND_API.g_miss_char;
1232: x_act_attachment_rec.link_url := FND_API.g_miss_char;
1233: x_act_attachment_rec.send_for_preview_flag := FND_API.g_miss_char;

Line 1230: x_act_attachment_rec.display_location := FND_API.g_miss_char;

1226: x_act_attachment_rec.keywords := FND_API.g_miss_char;
1227: x_act_attachment_rec.document_id := FND_API.g_miss_num;
1228: x_act_attachment_rec.display_width := FND_API.g_miss_num;
1229: x_act_attachment_rec.display_height := FND_API.g_miss_num;
1230: x_act_attachment_rec.display_location := FND_API.g_miss_char;
1231: x_act_attachment_rec.link_to := FND_API.g_miss_char;
1232: x_act_attachment_rec.link_url := FND_API.g_miss_char;
1233: x_act_attachment_rec.send_for_preview_flag := FND_API.g_miss_char;
1234: x_act_attachment_rec.attachment_type := FND_API.g_miss_char;

Line 1231: x_act_attachment_rec.link_to := FND_API.g_miss_char;

1227: x_act_attachment_rec.document_id := FND_API.g_miss_num;
1228: x_act_attachment_rec.display_width := FND_API.g_miss_num;
1229: x_act_attachment_rec.display_height := FND_API.g_miss_num;
1230: x_act_attachment_rec.display_location := FND_API.g_miss_char;
1231: x_act_attachment_rec.link_to := FND_API.g_miss_char;
1232: x_act_attachment_rec.link_url := FND_API.g_miss_char;
1233: x_act_attachment_rec.send_for_preview_flag := FND_API.g_miss_char;
1234: x_act_attachment_rec.attachment_type := FND_API.g_miss_char;
1235: x_act_attachment_rec.language_code := FND_API.g_miss_char;

Line 1232: x_act_attachment_rec.link_url := FND_API.g_miss_char;

1228: x_act_attachment_rec.display_width := FND_API.g_miss_num;
1229: x_act_attachment_rec.display_height := FND_API.g_miss_num;
1230: x_act_attachment_rec.display_location := FND_API.g_miss_char;
1231: x_act_attachment_rec.link_to := FND_API.g_miss_char;
1232: x_act_attachment_rec.link_url := FND_API.g_miss_char;
1233: x_act_attachment_rec.send_for_preview_flag := FND_API.g_miss_char;
1234: x_act_attachment_rec.attachment_type := FND_API.g_miss_char;
1235: x_act_attachment_rec.language_code := FND_API.g_miss_char;
1236: x_act_attachment_rec.application_id := FND_API.g_miss_num;

Line 1233: x_act_attachment_rec.send_for_preview_flag := FND_API.g_miss_char;

1229: x_act_attachment_rec.display_height := FND_API.g_miss_num;
1230: x_act_attachment_rec.display_location := FND_API.g_miss_char;
1231: x_act_attachment_rec.link_to := FND_API.g_miss_char;
1232: x_act_attachment_rec.link_url := FND_API.g_miss_char;
1233: x_act_attachment_rec.send_for_preview_flag := FND_API.g_miss_char;
1234: x_act_attachment_rec.attachment_type := FND_API.g_miss_char;
1235: x_act_attachment_rec.language_code := FND_API.g_miss_char;
1236: x_act_attachment_rec.application_id := FND_API.g_miss_num;
1237: x_act_attachment_rec.description := FND_API.g_miss_char;

Line 1234: x_act_attachment_rec.attachment_type := FND_API.g_miss_char;

1230: x_act_attachment_rec.display_location := FND_API.g_miss_char;
1231: x_act_attachment_rec.link_to := FND_API.g_miss_char;
1232: x_act_attachment_rec.link_url := FND_API.g_miss_char;
1233: x_act_attachment_rec.send_for_preview_flag := FND_API.g_miss_char;
1234: x_act_attachment_rec.attachment_type := FND_API.g_miss_char;
1235: x_act_attachment_rec.language_code := FND_API.g_miss_char;
1236: x_act_attachment_rec.application_id := FND_API.g_miss_num;
1237: x_act_attachment_rec.description := FND_API.g_miss_char;
1238: x_act_attachment_rec.default_style_sheet := FND_API.g_miss_char;

Line 1235: x_act_attachment_rec.language_code := FND_API.g_miss_char;

1231: x_act_attachment_rec.link_to := FND_API.g_miss_char;
1232: x_act_attachment_rec.link_url := FND_API.g_miss_char;
1233: x_act_attachment_rec.send_for_preview_flag := FND_API.g_miss_char;
1234: x_act_attachment_rec.attachment_type := FND_API.g_miss_char;
1235: x_act_attachment_rec.language_code := FND_API.g_miss_char;
1236: x_act_attachment_rec.application_id := FND_API.g_miss_num;
1237: x_act_attachment_rec.description := FND_API.g_miss_char;
1238: x_act_attachment_rec.default_style_sheet := FND_API.g_miss_char;
1239: x_act_attachment_rec.display_url := FND_API.g_miss_char;

Line 1236: x_act_attachment_rec.application_id := FND_API.g_miss_num;

1232: x_act_attachment_rec.link_url := FND_API.g_miss_char;
1233: x_act_attachment_rec.send_for_preview_flag := FND_API.g_miss_char;
1234: x_act_attachment_rec.attachment_type := FND_API.g_miss_char;
1235: x_act_attachment_rec.language_code := FND_API.g_miss_char;
1236: x_act_attachment_rec.application_id := FND_API.g_miss_num;
1237: x_act_attachment_rec.description := FND_API.g_miss_char;
1238: x_act_attachment_rec.default_style_sheet := FND_API.g_miss_char;
1239: x_act_attachment_rec.display_url := FND_API.g_miss_char;
1240: x_act_attachment_rec.display_rule_id := FND_API.g_miss_num;

Line 1237: x_act_attachment_rec.description := FND_API.g_miss_char;

1233: x_act_attachment_rec.send_for_preview_flag := FND_API.g_miss_char;
1234: x_act_attachment_rec.attachment_type := FND_API.g_miss_char;
1235: x_act_attachment_rec.language_code := FND_API.g_miss_char;
1236: x_act_attachment_rec.application_id := FND_API.g_miss_num;
1237: x_act_attachment_rec.description := FND_API.g_miss_char;
1238: x_act_attachment_rec.default_style_sheet := FND_API.g_miss_char;
1239: x_act_attachment_rec.display_url := FND_API.g_miss_char;
1240: x_act_attachment_rec.display_rule_id := FND_API.g_miss_num;
1241: x_act_attachment_rec.display_program := FND_API.g_miss_char;

Line 1238: x_act_attachment_rec.default_style_sheet := FND_API.g_miss_char;

1234: x_act_attachment_rec.attachment_type := FND_API.g_miss_char;
1235: x_act_attachment_rec.language_code := FND_API.g_miss_char;
1236: x_act_attachment_rec.application_id := FND_API.g_miss_num;
1237: x_act_attachment_rec.description := FND_API.g_miss_char;
1238: x_act_attachment_rec.default_style_sheet := FND_API.g_miss_char;
1239: x_act_attachment_rec.display_url := FND_API.g_miss_char;
1240: x_act_attachment_rec.display_rule_id := FND_API.g_miss_num;
1241: x_act_attachment_rec.display_program := FND_API.g_miss_char;
1242:

Line 1239: x_act_attachment_rec.display_url := FND_API.g_miss_char;

1235: x_act_attachment_rec.language_code := FND_API.g_miss_char;
1236: x_act_attachment_rec.application_id := FND_API.g_miss_num;
1237: x_act_attachment_rec.description := FND_API.g_miss_char;
1238: x_act_attachment_rec.default_style_sheet := FND_API.g_miss_char;
1239: x_act_attachment_rec.display_url := FND_API.g_miss_char;
1240: x_act_attachment_rec.display_rule_id := FND_API.g_miss_num;
1241: x_act_attachment_rec.display_program := FND_API.g_miss_char;
1242:
1243: x_act_attachment_rec.attribute_category := FND_API.g_miss_char;

Line 1240: x_act_attachment_rec.display_rule_id := FND_API.g_miss_num;

1236: x_act_attachment_rec.application_id := FND_API.g_miss_num;
1237: x_act_attachment_rec.description := FND_API.g_miss_char;
1238: x_act_attachment_rec.default_style_sheet := FND_API.g_miss_char;
1239: x_act_attachment_rec.display_url := FND_API.g_miss_char;
1240: x_act_attachment_rec.display_rule_id := FND_API.g_miss_num;
1241: x_act_attachment_rec.display_program := FND_API.g_miss_char;
1242:
1243: x_act_attachment_rec.attribute_category := FND_API.g_miss_char;
1244: x_act_attachment_rec.attribute1 := FND_API.g_miss_char;

Line 1241: x_act_attachment_rec.display_program := FND_API.g_miss_char;

1237: x_act_attachment_rec.description := FND_API.g_miss_char;
1238: x_act_attachment_rec.default_style_sheet := FND_API.g_miss_char;
1239: x_act_attachment_rec.display_url := FND_API.g_miss_char;
1240: x_act_attachment_rec.display_rule_id := FND_API.g_miss_num;
1241: x_act_attachment_rec.display_program := FND_API.g_miss_char;
1242:
1243: x_act_attachment_rec.attribute_category := FND_API.g_miss_char;
1244: x_act_attachment_rec.attribute1 := FND_API.g_miss_char;
1245: x_act_attachment_rec.attribute2 := FND_API.g_miss_char;

Line 1243: x_act_attachment_rec.attribute_category := FND_API.g_miss_char;

1239: x_act_attachment_rec.display_url := FND_API.g_miss_char;
1240: x_act_attachment_rec.display_rule_id := FND_API.g_miss_num;
1241: x_act_attachment_rec.display_program := FND_API.g_miss_char;
1242:
1243: x_act_attachment_rec.attribute_category := FND_API.g_miss_char;
1244: x_act_attachment_rec.attribute1 := FND_API.g_miss_char;
1245: x_act_attachment_rec.attribute2 := FND_API.g_miss_char;
1246: x_act_attachment_rec.attribute3 := FND_API.g_miss_char;
1247: x_act_attachment_rec.attribute4 := FND_API.g_miss_char;

Line 1244: x_act_attachment_rec.attribute1 := FND_API.g_miss_char;

1240: x_act_attachment_rec.display_rule_id := FND_API.g_miss_num;
1241: x_act_attachment_rec.display_program := FND_API.g_miss_char;
1242:
1243: x_act_attachment_rec.attribute_category := FND_API.g_miss_char;
1244: x_act_attachment_rec.attribute1 := FND_API.g_miss_char;
1245: x_act_attachment_rec.attribute2 := FND_API.g_miss_char;
1246: x_act_attachment_rec.attribute3 := FND_API.g_miss_char;
1247: x_act_attachment_rec.attribute4 := FND_API.g_miss_char;
1248: x_act_attachment_rec.attribute5 := FND_API.g_miss_char;

Line 1245: x_act_attachment_rec.attribute2 := FND_API.g_miss_char;

1241: x_act_attachment_rec.display_program := FND_API.g_miss_char;
1242:
1243: x_act_attachment_rec.attribute_category := FND_API.g_miss_char;
1244: x_act_attachment_rec.attribute1 := FND_API.g_miss_char;
1245: x_act_attachment_rec.attribute2 := FND_API.g_miss_char;
1246: x_act_attachment_rec.attribute3 := FND_API.g_miss_char;
1247: x_act_attachment_rec.attribute4 := FND_API.g_miss_char;
1248: x_act_attachment_rec.attribute5 := FND_API.g_miss_char;
1249: x_act_attachment_rec.attribute6 := FND_API.g_miss_char;

Line 1246: x_act_attachment_rec.attribute3 := FND_API.g_miss_char;

1242:
1243: x_act_attachment_rec.attribute_category := FND_API.g_miss_char;
1244: x_act_attachment_rec.attribute1 := FND_API.g_miss_char;
1245: x_act_attachment_rec.attribute2 := FND_API.g_miss_char;
1246: x_act_attachment_rec.attribute3 := FND_API.g_miss_char;
1247: x_act_attachment_rec.attribute4 := FND_API.g_miss_char;
1248: x_act_attachment_rec.attribute5 := FND_API.g_miss_char;
1249: x_act_attachment_rec.attribute6 := FND_API.g_miss_char;
1250: x_act_attachment_rec.attribute7 := FND_API.g_miss_char;

Line 1247: x_act_attachment_rec.attribute4 := FND_API.g_miss_char;

1243: x_act_attachment_rec.attribute_category := FND_API.g_miss_char;
1244: x_act_attachment_rec.attribute1 := FND_API.g_miss_char;
1245: x_act_attachment_rec.attribute2 := FND_API.g_miss_char;
1246: x_act_attachment_rec.attribute3 := FND_API.g_miss_char;
1247: x_act_attachment_rec.attribute4 := FND_API.g_miss_char;
1248: x_act_attachment_rec.attribute5 := FND_API.g_miss_char;
1249: x_act_attachment_rec.attribute6 := FND_API.g_miss_char;
1250: x_act_attachment_rec.attribute7 := FND_API.g_miss_char;
1251: x_act_attachment_rec.attribute8 := FND_API.g_miss_char;

Line 1248: x_act_attachment_rec.attribute5 := FND_API.g_miss_char;

1244: x_act_attachment_rec.attribute1 := FND_API.g_miss_char;
1245: x_act_attachment_rec.attribute2 := FND_API.g_miss_char;
1246: x_act_attachment_rec.attribute3 := FND_API.g_miss_char;
1247: x_act_attachment_rec.attribute4 := FND_API.g_miss_char;
1248: x_act_attachment_rec.attribute5 := FND_API.g_miss_char;
1249: x_act_attachment_rec.attribute6 := FND_API.g_miss_char;
1250: x_act_attachment_rec.attribute7 := FND_API.g_miss_char;
1251: x_act_attachment_rec.attribute8 := FND_API.g_miss_char;
1252: x_act_attachment_rec.attribute9 := FND_API.g_miss_char;

Line 1249: x_act_attachment_rec.attribute6 := FND_API.g_miss_char;

1245: x_act_attachment_rec.attribute2 := FND_API.g_miss_char;
1246: x_act_attachment_rec.attribute3 := FND_API.g_miss_char;
1247: x_act_attachment_rec.attribute4 := FND_API.g_miss_char;
1248: x_act_attachment_rec.attribute5 := FND_API.g_miss_char;
1249: x_act_attachment_rec.attribute6 := FND_API.g_miss_char;
1250: x_act_attachment_rec.attribute7 := FND_API.g_miss_char;
1251: x_act_attachment_rec.attribute8 := FND_API.g_miss_char;
1252: x_act_attachment_rec.attribute9 := FND_API.g_miss_char;
1253: x_act_attachment_rec.attribute10 := FND_API.g_miss_char;

Line 1250: x_act_attachment_rec.attribute7 := FND_API.g_miss_char;

1246: x_act_attachment_rec.attribute3 := FND_API.g_miss_char;
1247: x_act_attachment_rec.attribute4 := FND_API.g_miss_char;
1248: x_act_attachment_rec.attribute5 := FND_API.g_miss_char;
1249: x_act_attachment_rec.attribute6 := FND_API.g_miss_char;
1250: x_act_attachment_rec.attribute7 := FND_API.g_miss_char;
1251: x_act_attachment_rec.attribute8 := FND_API.g_miss_char;
1252: x_act_attachment_rec.attribute9 := FND_API.g_miss_char;
1253: x_act_attachment_rec.attribute10 := FND_API.g_miss_char;
1254: x_act_attachment_rec.attribute11 := FND_API.g_miss_char;

Line 1251: x_act_attachment_rec.attribute8 := FND_API.g_miss_char;

1247: x_act_attachment_rec.attribute4 := FND_API.g_miss_char;
1248: x_act_attachment_rec.attribute5 := FND_API.g_miss_char;
1249: x_act_attachment_rec.attribute6 := FND_API.g_miss_char;
1250: x_act_attachment_rec.attribute7 := FND_API.g_miss_char;
1251: x_act_attachment_rec.attribute8 := FND_API.g_miss_char;
1252: x_act_attachment_rec.attribute9 := FND_API.g_miss_char;
1253: x_act_attachment_rec.attribute10 := FND_API.g_miss_char;
1254: x_act_attachment_rec.attribute11 := FND_API.g_miss_char;
1255: x_act_attachment_rec.attribute12 := FND_API.g_miss_char;

Line 1252: x_act_attachment_rec.attribute9 := FND_API.g_miss_char;

1248: x_act_attachment_rec.attribute5 := FND_API.g_miss_char;
1249: x_act_attachment_rec.attribute6 := FND_API.g_miss_char;
1250: x_act_attachment_rec.attribute7 := FND_API.g_miss_char;
1251: x_act_attachment_rec.attribute8 := FND_API.g_miss_char;
1252: x_act_attachment_rec.attribute9 := FND_API.g_miss_char;
1253: x_act_attachment_rec.attribute10 := FND_API.g_miss_char;
1254: x_act_attachment_rec.attribute11 := FND_API.g_miss_char;
1255: x_act_attachment_rec.attribute12 := FND_API.g_miss_char;
1256: x_act_attachment_rec.attribute13 := FND_API.g_miss_char;

Line 1253: x_act_attachment_rec.attribute10 := FND_API.g_miss_char;

1249: x_act_attachment_rec.attribute6 := FND_API.g_miss_char;
1250: x_act_attachment_rec.attribute7 := FND_API.g_miss_char;
1251: x_act_attachment_rec.attribute8 := FND_API.g_miss_char;
1252: x_act_attachment_rec.attribute9 := FND_API.g_miss_char;
1253: x_act_attachment_rec.attribute10 := FND_API.g_miss_char;
1254: x_act_attachment_rec.attribute11 := FND_API.g_miss_char;
1255: x_act_attachment_rec.attribute12 := FND_API.g_miss_char;
1256: x_act_attachment_rec.attribute13 := FND_API.g_miss_char;
1257: x_act_attachment_rec.attribute14 := FND_API.g_miss_char;

Line 1254: x_act_attachment_rec.attribute11 := FND_API.g_miss_char;

1250: x_act_attachment_rec.attribute7 := FND_API.g_miss_char;
1251: x_act_attachment_rec.attribute8 := FND_API.g_miss_char;
1252: x_act_attachment_rec.attribute9 := FND_API.g_miss_char;
1253: x_act_attachment_rec.attribute10 := FND_API.g_miss_char;
1254: x_act_attachment_rec.attribute11 := FND_API.g_miss_char;
1255: x_act_attachment_rec.attribute12 := FND_API.g_miss_char;
1256: x_act_attachment_rec.attribute13 := FND_API.g_miss_char;
1257: x_act_attachment_rec.attribute14 := FND_API.g_miss_char;
1258: x_act_attachment_rec.attribute15 := FND_API.g_miss_char;

Line 1255: x_act_attachment_rec.attribute12 := FND_API.g_miss_char;

1251: x_act_attachment_rec.attribute8 := FND_API.g_miss_char;
1252: x_act_attachment_rec.attribute9 := FND_API.g_miss_char;
1253: x_act_attachment_rec.attribute10 := FND_API.g_miss_char;
1254: x_act_attachment_rec.attribute11 := FND_API.g_miss_char;
1255: x_act_attachment_rec.attribute12 := FND_API.g_miss_char;
1256: x_act_attachment_rec.attribute13 := FND_API.g_miss_char;
1257: x_act_attachment_rec.attribute14 := FND_API.g_miss_char;
1258: x_act_attachment_rec.attribute15 := FND_API.g_miss_char;
1259: x_act_attachment_rec.display_text := FND_API.g_miss_char;

Line 1256: x_act_attachment_rec.attribute13 := FND_API.g_miss_char;

1252: x_act_attachment_rec.attribute9 := FND_API.g_miss_char;
1253: x_act_attachment_rec.attribute10 := FND_API.g_miss_char;
1254: x_act_attachment_rec.attribute11 := FND_API.g_miss_char;
1255: x_act_attachment_rec.attribute12 := FND_API.g_miss_char;
1256: x_act_attachment_rec.attribute13 := FND_API.g_miss_char;
1257: x_act_attachment_rec.attribute14 := FND_API.g_miss_char;
1258: x_act_attachment_rec.attribute15 := FND_API.g_miss_char;
1259: x_act_attachment_rec.display_text := FND_API.g_miss_char;
1260: x_act_attachment_rec.alternate_text := FND_API.g_miss_char;

Line 1257: x_act_attachment_rec.attribute14 := FND_API.g_miss_char;

1253: x_act_attachment_rec.attribute10 := FND_API.g_miss_char;
1254: x_act_attachment_rec.attribute11 := FND_API.g_miss_char;
1255: x_act_attachment_rec.attribute12 := FND_API.g_miss_char;
1256: x_act_attachment_rec.attribute13 := FND_API.g_miss_char;
1257: x_act_attachment_rec.attribute14 := FND_API.g_miss_char;
1258: x_act_attachment_rec.attribute15 := FND_API.g_miss_char;
1259: x_act_attachment_rec.display_text := FND_API.g_miss_char;
1260: x_act_attachment_rec.alternate_text := FND_API.g_miss_char;
1261: x_act_attachment_rec.secured_flag := FND_API.g_miss_char;

Line 1258: x_act_attachment_rec.attribute15 := FND_API.g_miss_char;

1254: x_act_attachment_rec.attribute11 := FND_API.g_miss_char;
1255: x_act_attachment_rec.attribute12 := FND_API.g_miss_char;
1256: x_act_attachment_rec.attribute13 := FND_API.g_miss_char;
1257: x_act_attachment_rec.attribute14 := FND_API.g_miss_char;
1258: x_act_attachment_rec.attribute15 := FND_API.g_miss_char;
1259: x_act_attachment_rec.display_text := FND_API.g_miss_char;
1260: x_act_attachment_rec.alternate_text := FND_API.g_miss_char;
1261: x_act_attachment_rec.secured_flag := FND_API.g_miss_char;
1262: x_act_attachment_rec.attachment_sub_type := FND_API.g_miss_char;

Line 1259: x_act_attachment_rec.display_text := FND_API.g_miss_char;

1255: x_act_attachment_rec.attribute12 := FND_API.g_miss_char;
1256: x_act_attachment_rec.attribute13 := FND_API.g_miss_char;
1257: x_act_attachment_rec.attribute14 := FND_API.g_miss_char;
1258: x_act_attachment_rec.attribute15 := FND_API.g_miss_char;
1259: x_act_attachment_rec.display_text := FND_API.g_miss_char;
1260: x_act_attachment_rec.alternate_text := FND_API.g_miss_char;
1261: x_act_attachment_rec.secured_flag := FND_API.g_miss_char;
1262: x_act_attachment_rec.attachment_sub_type := FND_API.g_miss_char;
1263: END miss_act_attachment_rec;

Line 1260: x_act_attachment_rec.alternate_text := FND_API.g_miss_char;

1256: x_act_attachment_rec.attribute13 := FND_API.g_miss_char;
1257: x_act_attachment_rec.attribute14 := FND_API.g_miss_char;
1258: x_act_attachment_rec.attribute15 := FND_API.g_miss_char;
1259: x_act_attachment_rec.display_text := FND_API.g_miss_char;
1260: x_act_attachment_rec.alternate_text := FND_API.g_miss_char;
1261: x_act_attachment_rec.secured_flag := FND_API.g_miss_char;
1262: x_act_attachment_rec.attachment_sub_type := FND_API.g_miss_char;
1263: END miss_act_attachment_rec;
1264:

Line 1261: x_act_attachment_rec.secured_flag := FND_API.g_miss_char;

1257: x_act_attachment_rec.attribute14 := FND_API.g_miss_char;
1258: x_act_attachment_rec.attribute15 := FND_API.g_miss_char;
1259: x_act_attachment_rec.display_text := FND_API.g_miss_char;
1260: x_act_attachment_rec.alternate_text := FND_API.g_miss_char;
1261: x_act_attachment_rec.secured_flag := FND_API.g_miss_char;
1262: x_act_attachment_rec.attachment_sub_type := FND_API.g_miss_char;
1263: END miss_act_attachment_rec;
1264:
1265:

Line 1262: x_act_attachment_rec.attachment_sub_type := FND_API.g_miss_char;

1258: x_act_attachment_rec.attribute15 := FND_API.g_miss_char;
1259: x_act_attachment_rec.display_text := FND_API.g_miss_char;
1260: x_act_attachment_rec.alternate_text := FND_API.g_miss_char;
1261: x_act_attachment_rec.secured_flag := FND_API.g_miss_char;
1262: x_act_attachment_rec.attachment_sub_type := FND_API.g_miss_char;
1263: END miss_act_attachment_rec;
1264:
1265:
1266: ---------------------------------------------------------------------

Line 1297: RAISE FND_API.g_exc_error;

1293: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1294: FND_MESSAGE.set_name('JTF', 'JTF_AMV_API_RECORD_NOT_FOUND');
1295: FND_MSG_PUB.add;
1296: END IF;
1297: RAISE FND_API.g_exc_error;
1298: END IF;
1299: CLOSE c_act_attachment;
1300:
1301: IF p_act_attachment_rec.attachment_id = FND_API.g_miss_num THEN

Line 1301: IF p_act_attachment_rec.attachment_id = FND_API.g_miss_num THEN

1297: RAISE FND_API.g_exc_error;
1298: END IF;
1299: CLOSE c_act_attachment;
1300:
1301: IF p_act_attachment_rec.attachment_id = FND_API.g_miss_num THEN
1302: x_complete_rec.attachment_id := l_act_attachment_rec.attachment_id;
1303: END IF;
1304:
1305: IF p_act_attachment_rec.owner_user_id = FND_API.g_miss_num THEN

Line 1305: IF p_act_attachment_rec.owner_user_id = FND_API.g_miss_num THEN

1301: IF p_act_attachment_rec.attachment_id = FND_API.g_miss_num THEN
1302: x_complete_rec.attachment_id := l_act_attachment_rec.attachment_id;
1303: END IF;
1304:
1305: IF p_act_attachment_rec.owner_user_id = FND_API.g_miss_num THEN
1306: x_complete_rec.owner_user_id := l_act_attachment_rec.owner_user_id;
1307: END IF;
1308:
1309: IF p_act_attachment_rec.attachment_used_by_id = FND_API.g_miss_num THEN

Line 1309: IF p_act_attachment_rec.attachment_used_by_id = FND_API.g_miss_num THEN

1305: IF p_act_attachment_rec.owner_user_id = FND_API.g_miss_num THEN
1306: x_complete_rec.owner_user_id := l_act_attachment_rec.owner_user_id;
1307: END IF;
1308:
1309: IF p_act_attachment_rec.attachment_used_by_id = FND_API.g_miss_num THEN
1310: x_complete_rec.attachment_used_by_id := l_act_attachment_rec.attachment_used_by_id;
1311: END IF;
1312:
1313: IF p_act_attachment_rec.attachment_used_by = FND_API.g_miss_char THEN

Line 1313: IF p_act_attachment_rec.attachment_used_by = FND_API.g_miss_char THEN

1309: IF p_act_attachment_rec.attachment_used_by_id = FND_API.g_miss_num THEN
1310: x_complete_rec.attachment_used_by_id := l_act_attachment_rec.attachment_used_by_id;
1311: END IF;
1312:
1313: IF p_act_attachment_rec.attachment_used_by = FND_API.g_miss_char THEN
1314: x_complete_rec.attachment_used_by := l_act_attachment_rec.attachment_used_by;
1315: END IF;
1316:
1317: IF p_act_attachment_rec.version = FND_API.g_miss_char THEN

Line 1317: IF p_act_attachment_rec.version = FND_API.g_miss_char THEN

1313: IF p_act_attachment_rec.attachment_used_by = FND_API.g_miss_char THEN
1314: x_complete_rec.attachment_used_by := l_act_attachment_rec.attachment_used_by;
1315: END IF;
1316:
1317: IF p_act_attachment_rec.version = FND_API.g_miss_char THEN
1318: x_complete_rec.version := l_act_attachment_rec.version;
1319: END IF;
1320:
1321: IF p_act_attachment_rec.enabled_flag = FND_API.g_miss_char THEN

Line 1321: IF p_act_attachment_rec.enabled_flag = FND_API.g_miss_char THEN

1317: IF p_act_attachment_rec.version = FND_API.g_miss_char THEN
1318: x_complete_rec.version := l_act_attachment_rec.version;
1319: END IF;
1320:
1321: IF p_act_attachment_rec.enabled_flag = FND_API.g_miss_char THEN
1322: x_complete_rec.enabled_flag := l_act_attachment_rec.enabled_flag;
1323: END IF;
1324:
1325: IF p_act_attachment_rec.can_fulfill_electronic_flag = FND_API.g_miss_char THEN

Line 1325: IF p_act_attachment_rec.can_fulfill_electronic_flag = FND_API.g_miss_char THEN

1321: IF p_act_attachment_rec.enabled_flag = FND_API.g_miss_char THEN
1322: x_complete_rec.enabled_flag := l_act_attachment_rec.enabled_flag;
1323: END IF;
1324:
1325: IF p_act_attachment_rec.can_fulfill_electronic_flag = FND_API.g_miss_char THEN
1326: x_complete_rec.can_fulfill_electronic_flag := l_act_attachment_rec.can_fulfill_electronic_flag;
1327: END IF;
1328:
1329: IF p_act_attachment_rec.file_id = FND_API.g_miss_num THEN

Line 1329: IF p_act_attachment_rec.file_id = FND_API.g_miss_num THEN

1325: IF p_act_attachment_rec.can_fulfill_electronic_flag = FND_API.g_miss_char THEN
1326: x_complete_rec.can_fulfill_electronic_flag := l_act_attachment_rec.can_fulfill_electronic_flag;
1327: END IF;
1328:
1329: IF p_act_attachment_rec.file_id = FND_API.g_miss_num THEN
1330: x_complete_rec.file_id := l_act_attachment_rec.file_id;
1331: END IF;
1332:
1333: IF p_act_attachment_rec.file_name = FND_API.g_miss_char THEN

Line 1333: IF p_act_attachment_rec.file_name = FND_API.g_miss_char THEN

1329: IF p_act_attachment_rec.file_id = FND_API.g_miss_num THEN
1330: x_complete_rec.file_id := l_act_attachment_rec.file_id;
1331: END IF;
1332:
1333: IF p_act_attachment_rec.file_name = FND_API.g_miss_char THEN
1334: x_complete_rec.file_name := l_act_attachment_rec.file_name;
1335: END IF;
1336:
1337: IF p_act_attachment_rec.file_extension = FND_API.g_miss_char THEN

Line 1337: IF p_act_attachment_rec.file_extension = FND_API.g_miss_char THEN

1333: IF p_act_attachment_rec.file_name = FND_API.g_miss_char THEN
1334: x_complete_rec.file_name := l_act_attachment_rec.file_name;
1335: END IF;
1336:
1337: IF p_act_attachment_rec.file_extension = FND_API.g_miss_char THEN
1338: x_complete_rec.file_extension := l_act_attachment_rec.file_extension;
1339: END IF;
1340:
1341: IF p_act_attachment_rec.document_id = FND_API.g_miss_num THEN

Line 1341: IF p_act_attachment_rec.document_id = FND_API.g_miss_num THEN

1337: IF p_act_attachment_rec.file_extension = FND_API.g_miss_char THEN
1338: x_complete_rec.file_extension := l_act_attachment_rec.file_extension;
1339: END IF;
1340:
1341: IF p_act_attachment_rec.document_id = FND_API.g_miss_num THEN
1342: x_complete_rec.document_id := l_act_attachment_rec.document_id;
1343: END IF;
1344:
1345: IF p_act_attachment_rec.keywords = FND_API.g_miss_char THEN

Line 1345: IF p_act_attachment_rec.keywords = FND_API.g_miss_char THEN

1341: IF p_act_attachment_rec.document_id = FND_API.g_miss_num THEN
1342: x_complete_rec.document_id := l_act_attachment_rec.document_id;
1343: END IF;
1344:
1345: IF p_act_attachment_rec.keywords = FND_API.g_miss_char THEN
1346: x_complete_rec.keywords := l_act_attachment_rec.keywords;
1347: END IF;
1348:
1349: IF p_act_attachment_rec.display_width = FND_API.g_miss_num THEN

Line 1349: IF p_act_attachment_rec.display_width = FND_API.g_miss_num THEN

1345: IF p_act_attachment_rec.keywords = FND_API.g_miss_char THEN
1346: x_complete_rec.keywords := l_act_attachment_rec.keywords;
1347: END IF;
1348:
1349: IF p_act_attachment_rec.display_width = FND_API.g_miss_num THEN
1350: x_complete_rec.display_width := l_act_attachment_rec.display_width;
1351: END IF;
1352:
1353: IF p_act_attachment_rec.display_height = FND_API.g_miss_num THEN

Line 1353: IF p_act_attachment_rec.display_height = FND_API.g_miss_num THEN

1349: IF p_act_attachment_rec.display_width = FND_API.g_miss_num THEN
1350: x_complete_rec.display_width := l_act_attachment_rec.display_width;
1351: END IF;
1352:
1353: IF p_act_attachment_rec.display_height = FND_API.g_miss_num THEN
1354: x_complete_rec.display_height := l_act_attachment_rec.display_height;
1355: END IF;
1356:
1357: IF p_act_attachment_rec.display_location = FND_API.g_miss_char THEN

Line 1357: IF p_act_attachment_rec.display_location = FND_API.g_miss_char THEN

1353: IF p_act_attachment_rec.display_height = FND_API.g_miss_num THEN
1354: x_complete_rec.display_height := l_act_attachment_rec.display_height;
1355: END IF;
1356:
1357: IF p_act_attachment_rec.display_location = FND_API.g_miss_char THEN
1358: x_complete_rec.display_location := l_act_attachment_rec.display_location;
1359: END IF;
1360:
1361: IF p_act_attachment_rec.link_to = FND_API.g_miss_char THEN

Line 1361: IF p_act_attachment_rec.link_to = FND_API.g_miss_char THEN

1357: IF p_act_attachment_rec.display_location = FND_API.g_miss_char THEN
1358: x_complete_rec.display_location := l_act_attachment_rec.display_location;
1359: END IF;
1360:
1361: IF p_act_attachment_rec.link_to = FND_API.g_miss_char THEN
1362: x_complete_rec.link_to := l_act_attachment_rec.link_to;
1363: END IF;
1364:
1365: IF p_act_attachment_rec.link_url = FND_API.g_miss_char THEN

Line 1365: IF p_act_attachment_rec.link_url = FND_API.g_miss_char THEN

1361: IF p_act_attachment_rec.link_to = FND_API.g_miss_char THEN
1362: x_complete_rec.link_to := l_act_attachment_rec.link_to;
1363: END IF;
1364:
1365: IF p_act_attachment_rec.link_url = FND_API.g_miss_char THEN
1366: x_complete_rec.link_url := l_act_attachment_rec.link_url;
1367: END IF;
1368:
1369: IF p_act_attachment_rec.send_for_preview_flag = FND_API.g_miss_char THEN

Line 1369: IF p_act_attachment_rec.send_for_preview_flag = FND_API.g_miss_char THEN

1365: IF p_act_attachment_rec.link_url = FND_API.g_miss_char THEN
1366: x_complete_rec.link_url := l_act_attachment_rec.link_url;
1367: END IF;
1368:
1369: IF p_act_attachment_rec.send_for_preview_flag = FND_API.g_miss_char THEN
1370: x_complete_rec.send_for_preview_flag := l_act_attachment_rec.send_for_preview_flag;
1371: END IF;
1372:
1373: IF p_act_attachment_rec.attachment_type = FND_API.g_miss_char THEN

Line 1373: IF p_act_attachment_rec.attachment_type = FND_API.g_miss_char THEN

1369: IF p_act_attachment_rec.send_for_preview_flag = FND_API.g_miss_char THEN
1370: x_complete_rec.send_for_preview_flag := l_act_attachment_rec.send_for_preview_flag;
1371: END IF;
1372:
1373: IF p_act_attachment_rec.attachment_type = FND_API.g_miss_char THEN
1374: x_complete_rec.attachment_type := l_act_attachment_rec.attachment_type;
1375: END IF;
1376:
1377: IF p_act_attachment_rec.language_code = FND_API.g_miss_char THEN

Line 1377: IF p_act_attachment_rec.language_code = FND_API.g_miss_char THEN

1373: IF p_act_attachment_rec.attachment_type = FND_API.g_miss_char THEN
1374: x_complete_rec.attachment_type := l_act_attachment_rec.attachment_type;
1375: END IF;
1376:
1377: IF p_act_attachment_rec.language_code = FND_API.g_miss_char THEN
1378: x_complete_rec.language_code := l_act_attachment_rec.language_code;
1379: END IF;
1380:
1381: IF p_act_attachment_rec.application_id = FND_API.g_miss_num THEN

Line 1381: IF p_act_attachment_rec.application_id = FND_API.g_miss_num THEN

1377: IF p_act_attachment_rec.language_code = FND_API.g_miss_char THEN
1378: x_complete_rec.language_code := l_act_attachment_rec.language_code;
1379: END IF;
1380:
1381: IF p_act_attachment_rec.application_id = FND_API.g_miss_num THEN
1382: x_complete_rec.application_id := l_act_attachment_rec.application_id;
1383: END IF;
1384:
1385: IF p_act_attachment_rec.description = FND_API.g_miss_char THEN

Line 1385: IF p_act_attachment_rec.description = FND_API.g_miss_char THEN

1381: IF p_act_attachment_rec.application_id = FND_API.g_miss_num THEN
1382: x_complete_rec.application_id := l_act_attachment_rec.application_id;
1383: END IF;
1384:
1385: IF p_act_attachment_rec.description = FND_API.g_miss_char THEN
1386: x_complete_rec.description := l_act_attachment_rec.description;
1387: END IF;
1388:
1389: IF p_act_attachment_rec.default_style_sheet = FND_API.g_miss_char THEN

Line 1389: IF p_act_attachment_rec.default_style_sheet = FND_API.g_miss_char THEN

1385: IF p_act_attachment_rec.description = FND_API.g_miss_char THEN
1386: x_complete_rec.description := l_act_attachment_rec.description;
1387: END IF;
1388:
1389: IF p_act_attachment_rec.default_style_sheet = FND_API.g_miss_char THEN
1390: x_complete_rec.default_style_sheet := l_act_attachment_rec.default_style_sheet;
1391: END IF;
1392:
1393: IF p_act_attachment_rec.display_url = FND_API.g_miss_char THEN

Line 1393: IF p_act_attachment_rec.display_url = FND_API.g_miss_char THEN

1389: IF p_act_attachment_rec.default_style_sheet = FND_API.g_miss_char THEN
1390: x_complete_rec.default_style_sheet := l_act_attachment_rec.default_style_sheet;
1391: END IF;
1392:
1393: IF p_act_attachment_rec.display_url = FND_API.g_miss_char THEN
1394: x_complete_rec.display_url := l_act_attachment_rec.display_url;
1395: END IF;
1396:
1397: IF p_act_attachment_rec.display_rule_id = FND_API.g_miss_num THEN

Line 1397: IF p_act_attachment_rec.display_rule_id = FND_API.g_miss_num THEN

1393: IF p_act_attachment_rec.display_url = FND_API.g_miss_char THEN
1394: x_complete_rec.display_url := l_act_attachment_rec.display_url;
1395: END IF;
1396:
1397: IF p_act_attachment_rec.display_rule_id = FND_API.g_miss_num THEN
1398: x_complete_rec.display_rule_id := l_act_attachment_rec.display_rule_id;
1399: END IF;
1400:
1401: IF p_act_attachment_rec.display_program = FND_API.g_miss_char THEN

Line 1401: IF p_act_attachment_rec.display_program = FND_API.g_miss_char THEN

1397: IF p_act_attachment_rec.display_rule_id = FND_API.g_miss_num THEN
1398: x_complete_rec.display_rule_id := l_act_attachment_rec.display_rule_id;
1399: END IF;
1400:
1401: IF p_act_attachment_rec.display_program = FND_API.g_miss_char THEN
1402: x_complete_rec.display_program := l_act_attachment_rec.display_program;
1403: END IF;
1404:
1405: IF p_act_attachment_rec.attribute_category = FND_API.g_miss_char THEN

Line 1405: IF p_act_attachment_rec.attribute_category = FND_API.g_miss_char THEN

1401: IF p_act_attachment_rec.display_program = FND_API.g_miss_char THEN
1402: x_complete_rec.display_program := l_act_attachment_rec.display_program;
1403: END IF;
1404:
1405: IF p_act_attachment_rec.attribute_category = FND_API.g_miss_char THEN
1406: x_complete_rec.attribute_category := l_act_attachment_rec.attribute_category;
1407: END IF;
1408:
1409: IF p_act_attachment_rec.attribute1 = FND_API.g_miss_char THEN

Line 1409: IF p_act_attachment_rec.attribute1 = FND_API.g_miss_char THEN

1405: IF p_act_attachment_rec.attribute_category = FND_API.g_miss_char THEN
1406: x_complete_rec.attribute_category := l_act_attachment_rec.attribute_category;
1407: END IF;
1408:
1409: IF p_act_attachment_rec.attribute1 = FND_API.g_miss_char THEN
1410: x_complete_rec.attribute1 := l_act_attachment_rec.attribute1;
1411: END IF;
1412:
1413: IF p_act_attachment_rec.attribute2 = FND_API.g_miss_char THEN

Line 1413: IF p_act_attachment_rec.attribute2 = FND_API.g_miss_char THEN

1409: IF p_act_attachment_rec.attribute1 = FND_API.g_miss_char THEN
1410: x_complete_rec.attribute1 := l_act_attachment_rec.attribute1;
1411: END IF;
1412:
1413: IF p_act_attachment_rec.attribute2 = FND_API.g_miss_char THEN
1414: x_complete_rec.attribute2 := l_act_attachment_rec.attribute2;
1415: END IF;
1416:
1417: IF p_act_attachment_rec.attribute3 = FND_API.g_miss_char THEN

Line 1417: IF p_act_attachment_rec.attribute3 = FND_API.g_miss_char THEN

1413: IF p_act_attachment_rec.attribute2 = FND_API.g_miss_char THEN
1414: x_complete_rec.attribute2 := l_act_attachment_rec.attribute2;
1415: END IF;
1416:
1417: IF p_act_attachment_rec.attribute3 = FND_API.g_miss_char THEN
1418: x_complete_rec.attribute3 := l_act_attachment_rec.attribute3;
1419: END IF;
1420:
1421: IF p_act_attachment_rec.attribute4 = FND_API.g_miss_char THEN

Line 1421: IF p_act_attachment_rec.attribute4 = FND_API.g_miss_char THEN

1417: IF p_act_attachment_rec.attribute3 = FND_API.g_miss_char THEN
1418: x_complete_rec.attribute3 := l_act_attachment_rec.attribute3;
1419: END IF;
1420:
1421: IF p_act_attachment_rec.attribute4 = FND_API.g_miss_char THEN
1422: x_complete_rec.attribute4 := l_act_attachment_rec.attribute4;
1423: END IF;
1424:
1425: IF p_act_attachment_rec.attribute5 = FND_API.g_miss_char THEN

Line 1425: IF p_act_attachment_rec.attribute5 = FND_API.g_miss_char THEN

1421: IF p_act_attachment_rec.attribute4 = FND_API.g_miss_char THEN
1422: x_complete_rec.attribute4 := l_act_attachment_rec.attribute4;
1423: END IF;
1424:
1425: IF p_act_attachment_rec.attribute5 = FND_API.g_miss_char THEN
1426: x_complete_rec.attribute5 := l_act_attachment_rec.attribute5;
1427: END IF;
1428:
1429: IF p_act_attachment_rec.attribute6 = FND_API.g_miss_char THEN

Line 1429: IF p_act_attachment_rec.attribute6 = FND_API.g_miss_char THEN

1425: IF p_act_attachment_rec.attribute5 = FND_API.g_miss_char THEN
1426: x_complete_rec.attribute5 := l_act_attachment_rec.attribute5;
1427: END IF;
1428:
1429: IF p_act_attachment_rec.attribute6 = FND_API.g_miss_char THEN
1430: x_complete_rec.attribute6 := l_act_attachment_rec.attribute6;
1431: END IF;
1432:
1433: IF p_act_attachment_rec.attribute7 = FND_API.g_miss_char THEN

Line 1433: IF p_act_attachment_rec.attribute7 = FND_API.g_miss_char THEN

1429: IF p_act_attachment_rec.attribute6 = FND_API.g_miss_char THEN
1430: x_complete_rec.attribute6 := l_act_attachment_rec.attribute6;
1431: END IF;
1432:
1433: IF p_act_attachment_rec.attribute7 = FND_API.g_miss_char THEN
1434: x_complete_rec.attribute7 := l_act_attachment_rec.attribute7;
1435: END IF;
1436:
1437: IF p_act_attachment_rec.attribute8 = FND_API.g_miss_char THEN

Line 1437: IF p_act_attachment_rec.attribute8 = FND_API.g_miss_char THEN

1433: IF p_act_attachment_rec.attribute7 = FND_API.g_miss_char THEN
1434: x_complete_rec.attribute7 := l_act_attachment_rec.attribute7;
1435: END IF;
1436:
1437: IF p_act_attachment_rec.attribute8 = FND_API.g_miss_char THEN
1438: x_complete_rec.attribute8 := l_act_attachment_rec.attribute8;
1439: END IF;
1440:
1441: IF p_act_attachment_rec.attribute9 = FND_API.g_miss_char THEN

Line 1441: IF p_act_attachment_rec.attribute9 = FND_API.g_miss_char THEN

1437: IF p_act_attachment_rec.attribute8 = FND_API.g_miss_char THEN
1438: x_complete_rec.attribute8 := l_act_attachment_rec.attribute8;
1439: END IF;
1440:
1441: IF p_act_attachment_rec.attribute9 = FND_API.g_miss_char THEN
1442: x_complete_rec.attribute9 := l_act_attachment_rec.attribute9;
1443: END IF;
1444:
1445: IF p_act_attachment_rec.attribute10 = FND_API.g_miss_char THEN

Line 1445: IF p_act_attachment_rec.attribute10 = FND_API.g_miss_char THEN

1441: IF p_act_attachment_rec.attribute9 = FND_API.g_miss_char THEN
1442: x_complete_rec.attribute9 := l_act_attachment_rec.attribute9;
1443: END IF;
1444:
1445: IF p_act_attachment_rec.attribute10 = FND_API.g_miss_char THEN
1446: x_complete_rec.attribute10 := l_act_attachment_rec.attribute10;
1447: END IF;
1448:
1449: IF p_act_attachment_rec.attribute11 = FND_API.g_miss_char THEN

Line 1449: IF p_act_attachment_rec.attribute11 = FND_API.g_miss_char THEN

1445: IF p_act_attachment_rec.attribute10 = FND_API.g_miss_char THEN
1446: x_complete_rec.attribute10 := l_act_attachment_rec.attribute10;
1447: END IF;
1448:
1449: IF p_act_attachment_rec.attribute11 = FND_API.g_miss_char THEN
1450: x_complete_rec.attribute11 := l_act_attachment_rec.attribute11;
1451: END IF;
1452:
1453: IF p_act_attachment_rec.attribute12 = FND_API.g_miss_char THEN

Line 1453: IF p_act_attachment_rec.attribute12 = FND_API.g_miss_char THEN

1449: IF p_act_attachment_rec.attribute11 = FND_API.g_miss_char THEN
1450: x_complete_rec.attribute11 := l_act_attachment_rec.attribute11;
1451: END IF;
1452:
1453: IF p_act_attachment_rec.attribute12 = FND_API.g_miss_char THEN
1454: x_complete_rec.attribute12 := l_act_attachment_rec.attribute12;
1455: END IF;
1456:
1457: IF p_act_attachment_rec.attribute13 = FND_API.g_miss_char THEN

Line 1457: IF p_act_attachment_rec.attribute13 = FND_API.g_miss_char THEN

1453: IF p_act_attachment_rec.attribute12 = FND_API.g_miss_char THEN
1454: x_complete_rec.attribute12 := l_act_attachment_rec.attribute12;
1455: END IF;
1456:
1457: IF p_act_attachment_rec.attribute13 = FND_API.g_miss_char THEN
1458: x_complete_rec.attribute13 := l_act_attachment_rec.attribute13;
1459: END IF;
1460:
1461: IF p_act_attachment_rec.attribute14 = FND_API.g_miss_char THEN

Line 1461: IF p_act_attachment_rec.attribute14 = FND_API.g_miss_char THEN

1457: IF p_act_attachment_rec.attribute13 = FND_API.g_miss_char THEN
1458: x_complete_rec.attribute13 := l_act_attachment_rec.attribute13;
1459: END IF;
1460:
1461: IF p_act_attachment_rec.attribute14 = FND_API.g_miss_char THEN
1462: x_complete_rec.attribute14 := l_act_attachment_rec.attribute14;
1463: END IF;
1464:
1465: IF p_act_attachment_rec.attribute15 = FND_API.g_miss_char THEN

Line 1465: IF p_act_attachment_rec.attribute15 = FND_API.g_miss_char THEN

1461: IF p_act_attachment_rec.attribute14 = FND_API.g_miss_char THEN
1462: x_complete_rec.attribute14 := l_act_attachment_rec.attribute14;
1463: END IF;
1464:
1465: IF p_act_attachment_rec.attribute15 = FND_API.g_miss_char THEN
1466: x_complete_rec.attribute15 := l_act_attachment_rec.attribute15;
1467: END IF;
1468:
1469: IF p_act_attachment_rec.display_text = FND_API.g_miss_char THEN

Line 1469: IF p_act_attachment_rec.display_text = FND_API.g_miss_char THEN

1465: IF p_act_attachment_rec.attribute15 = FND_API.g_miss_char THEN
1466: x_complete_rec.attribute15 := l_act_attachment_rec.attribute15;
1467: END IF;
1468:
1469: IF p_act_attachment_rec.display_text = FND_API.g_miss_char THEN
1470: x_complete_rec.display_text := l_act_attachment_rec.display_text;
1471: END IF;
1472:
1473: IF p_act_attachment_rec.alternate_text = FND_API.g_miss_char THEN

Line 1473: IF p_act_attachment_rec.alternate_text = FND_API.g_miss_char THEN

1469: IF p_act_attachment_rec.display_text = FND_API.g_miss_char THEN
1470: x_complete_rec.display_text := l_act_attachment_rec.display_text;
1471: END IF;
1472:
1473: IF p_act_attachment_rec.alternate_text = FND_API.g_miss_char THEN
1474: x_complete_rec.alternate_text := l_act_attachment_rec.alternate_text;
1475: END IF;
1476:
1477: IF p_act_attachment_rec.secured_flag = FND_API.g_miss_char THEN

Line 1477: IF p_act_attachment_rec.secured_flag = FND_API.g_miss_char THEN

1473: IF p_act_attachment_rec.alternate_text = FND_API.g_miss_char THEN
1474: x_complete_rec.alternate_text := l_act_attachment_rec.alternate_text;
1475: END IF;
1476:
1477: IF p_act_attachment_rec.secured_flag = FND_API.g_miss_char THEN
1478: x_complete_rec.secured_flag := l_act_attachment_rec.secured_flag;
1479: END IF;
1480:
1481: IF p_act_attachment_rec.attachment_sub_type = FND_API.g_miss_char THEN

Line 1481: IF p_act_attachment_rec.attachment_sub_type = FND_API.g_miss_char THEN

1477: IF p_act_attachment_rec.secured_flag = FND_API.g_miss_char THEN
1478: x_complete_rec.secured_flag := l_act_attachment_rec.secured_flag;
1479: END IF;
1480:
1481: IF p_act_attachment_rec.attachment_sub_type = FND_API.g_miss_char THEN
1482: x_complete_rec.attachment_sub_type :=
1483: l_act_attachment_rec.attachment_sub_type ;
1484: END IF;
1485: