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

Line 34: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,

30:
31: PROCEDURE customize_pub_item
32: (
33: p_api_version_number IN NUMBER,
34: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
35: p_pub_item_name IN VARCHAR2,
36: p_base_table_name IN VARCHAR2,
37: p_primary_key_columns IN VARCHAR2,
38: p_data_columns IN VARCHAR2,

Line 74: if NOT FND_API.Compatible_API_Call

70:
71: -- Standard Start of API savepoint
72: SAVEPOINT customize_pub_item_PVT;
73: -- Standard call to check for call compatibility.
74: if NOT FND_API.Compatible_API_Call
75: (
76: l_api_version_number,
77: p_api_version_number,
78: l_api_name,

Line 82: raise FND_API.G_EXC_UNEXPECTED_ERROR;

78: l_api_name,
79: G_PKG_NAME
80: )
81: then
82: raise FND_API.G_EXC_UNEXPECTED_ERROR;
83: end if;
84:
85: -- Initialize message list if p_init_msg_list is set to TRUE.
86: if FND_API.to_Boolean( p_init_msg_list)

Line 86: if FND_API.to_Boolean( p_init_msg_list)

82: raise FND_API.G_EXC_UNEXPECTED_ERROR;
83: end if;
84:
85: -- Initialize message list if p_init_msg_list is set to TRUE.
86: if FND_API.to_Boolean( p_init_msg_list)
87: then
88: fND_MSG_PUB.initialize;
89: end if;
90: -- Initialize API return status to success

Line 91: x_return_status := FND_API.G_RET_STS_SUCCESS;

87: then
88: fND_MSG_PUB.initialize;
89: end if;
90: -- Initialize API return status to success
91: x_return_status := FND_API.G_RET_STS_SUCCESS;
92:
93: -- ***************************
94: -- A few items to check for
95: -- 0. check if the item is customable

Line 122: raise FND_API.G_EXC_ERROR;

118: -- this table does not exist
119: log(p_base_table_name || ' does not exists!');
120: fnd_message.set_name('ASG','TABLE_NOT EXISTS');
121: fnd_msg_pub.Add;
122: raise FND_API.G_EXC_ERROR;
123: end if;
124: else
125: */
126: if (p_base_table_name is NULL)

Line 131: raise FND_API.G_EXC_ERROR;

127: then
128: log('p_base_table_name Should not be NULL!');
129: fnd_message.set_name('ASG','NO BASE TABLE NAME');
130: fnd_msg_pub.Add;
131: raise FND_API.G_EXC_ERROR;
132: end if;
133:
134:
135: -- ****************

Line 149: raise FND_API.G_EXC_ERROR;

145: -- the custom flag is not Y
146: log(p_pub_item_name || ' is not for the customization!');
147: fnd_message.set_name('ASG','PUB ITEM NOT CUSTOMABLE');
148: fnd_msg_pub.Add;
149: raise FND_API.G_EXC_ERROR;
150: end if;
151:
152: -- *****************
153: -- check if primary_key_column input is null

Line 160: raise FND_API.G_EXC_ERROR;

156: then
157: log( 'p_primary_key_columns Should not be NULL!');
158: fnd_message.set_name('ASG','NULL PK COLUMNS');
159: fnd_msg_pub.Add;
160: raise FND_API.G_EXC_ERROR;
161: end if;
162:
163: -- ******************
164: -- check if the pub item is the right one to do this

Line 182: raise FND_API.G_EXC_ERROR;

178: then
179: log (' The Primary Keys number does not match with the pub item');
180: fnd_message.set_name('ASG','PK number _NOT matched');
181: fnd_msg_pub.Add;
182: raise FND_API.G_EXC_ERROR;
183: end if;
184:
185:
186: -- ***********

Line 201: raise FND_API.G_EXC_ERROR;

197: log (' The pub item base table cannot be changed while there is
198: record existing in the acc table!');
199: fnd_message.set_name('ASG','RECORDS EXISTING IN ACC TABLE');
200: fnd_msg_pub.Add;
201: raise FND_API.G_EXC_ERROR;
202: END IF;
203: END IF;
204:
205:

Line 253: raise FND_API.G_EXC_ERROR;

249: if (c_type <> 'BLOB') then
250: log('The publication item does not contain the BLOB column.'||
251: ' Please chose the right'
252: ||' publication item to custom.');
253: raise FND_API.G_EXC_ERROR;
254: end if;
255:
256: if (l_pk_num + l_col_num < l_cols_count -1 ) then
257: l_count := l_pk_num + l_col_num;

Line 304: WHEN FND_API.G_EXC_ERROR THEN

300: where item_id = P_pub_item_name;
301: commit;
302:
303: EXCEPTION
304: WHEN FND_API.G_EXC_ERROR THEN
305: Rollback to customize_pub_item_PVT;
306: x_return_status := FND_API.G_RET_STS_ERROR;
307: FND_MSG_PUB.Count_And_Get
308: (

Line 306: x_return_status := FND_API.G_RET_STS_ERROR;

302:
303: EXCEPTION
304: WHEN FND_API.G_EXC_ERROR THEN
305: Rollback to customize_pub_item_PVT;
306: x_return_status := FND_API.G_RET_STS_ERROR;
307: FND_MSG_PUB.Count_And_Get
308: (
309: p_count => x_msg_count,
310: p_data => x_error_message

Line 312: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

308: (
309: p_count => x_msg_count,
310: p_data => x_error_message
311: );
312: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
313: Rollback to customize_pub_item_PVT;
314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
315: FND_MSG_PUB.Count_And_Get
316: (

Line 314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

310: p_data => x_error_message
311: );
312: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
313: Rollback to customize_pub_item_PVT;
314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
315: FND_MSG_PUB.Count_And_Get
316: (
317: p_count => x_msg_count,
318: p_data => x_error_message

Line 322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

318: p_data => x_error_message
319: );
320: WHEN OTHERS THEN
321: Rollback to customize_pub_item_PVT;
322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
323: if FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
324: then
325: FND_MSG_PUB.Add_Exc_Msg
326: (

Line 348: RETURN FND_API.G_RET_STS_SUCCESS;

344: begin
345: log (pCmd);
346: execute immediate pCmd;
347:
348: RETURN FND_API.G_RET_STS_SUCCESS;
349: EXCEPTION
350: when OTHERS then
351: fnd_message.set_name('ASG','SQL COMMAND FAIL!');
352: fnd_msg_pub.Add;

Line 355: RETURN FND_API.G_RET_STS_ERROR;

351: fnd_message.set_name('ASG','SQL COMMAND FAIL!');
352: fnd_msg_pub.Add;
353: log ( substr(sqlerrm, 1, 200));
354: Raise;
355: RETURN FND_API.G_RET_STS_ERROR;
356: end;
357:
358: FUNCTION generate_where (collist in varchar2)
359: RETURN VARCHAR2

Line 462: RAISE FND_API.G_EXC_ERROR;

458: ||' attribute'
459: ||to_char(l_cnt);
460: ELSIF ((l_cnt <> LAST_COL_NUM ) AND (COL_TYPE = 'BLOB') ) THEN
461: log('Exception: BLOB type Column must be the last column!');
462: RAISE FND_API.G_EXC_ERROR;
463: ELSIF ((l_cnt = LAST_COL_NUM ) AND (COL_TYPE = 'BLOB') ) THEN
464: LAST_COL_NAME := l_type_col;
465: IS_BLOB_INCLUDED := 'Y';
466: END IF;

Line 485: RAISE FND_API.G_EXC_ERROR;

481: ||' attribute'
482: ||to_char(l_cnt);
483: ELSIF ((l_cnt <> LAST_COL_NUM ) AND (COL_TYPE = 'BLOB') ) THEN
484: log('Exception: BLOB type Column must be the last column!');
485: RAISE FND_API.G_EXC_ERROR;
486: ELSIF ((l_cnt = LAST_COL_NUM ) AND (COL_TYPE = 'BLOB') ) THEN
487: IS_BLOB_INCLUDED := 'Y';
488: LAST_COL_NAME := l_type_col;
489: END IF;

Line 523: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,

519:
520: -- make sure to check the boolean to return varchar2
521: PROCEDURE mark_dirty (
522: p_api_version_number IN NUMBER,
523: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
524: p_pub_item IN VARCHAR2,
525: p_accessList IN asg_download.access_list,
526: p_userid_list IN asg_download.user_list,
527: p_dmlList IN asg_download.dml_list,

Line 542: if NOT FND_API.Compatible_API_Call

538: -- Standard Start of API savepoint
539: SAVEPOINT mark_dirty1;
540:
541: -- Standard call to check for call compatibility.
542: if NOT FND_API.Compatible_API_Call
543: (
544: l_api_version_number,
545: p_api_version_number,
546: l_api_name,

Line 550: raise FND_API.G_EXC_UNEXPECTED_ERROR;

546: l_api_name,
547: G_PKG_NAME
548: )
549: then
550: raise FND_API.G_EXC_UNEXPECTED_ERROR;
551: end if;
552:
553: -- Initialize message list if p_init_msg_list is set to TRUE.
554: if FND_API.to_Boolean( p_init_msg_list)

Line 554: if FND_API.to_Boolean( p_init_msg_list)

550: raise FND_API.G_EXC_UNEXPECTED_ERROR;
551: end if;
552:
553: -- Initialize message list if p_init_msg_list is set to TRUE.
554: if FND_API.to_Boolean( p_init_msg_list)
555: then
556: FND_MSG_PUB.initialize;
557: end if;
558:

Line 560: x_return_status := FND_API.G_RET_STS_SUCCESS;

556: FND_MSG_PUB.initialize;
557: end if;
558:
559: -- Initialize API return status to success
560: x_return_status := FND_API.G_RET_STS_SUCCESS;
561:
562: l_ret := asg_download.mark_dirty(p_pub_item,
563: p_accessList,
564: p_userid_list,

Line 569: x_return_status := FND_API.G_RET_STS_SUCCESS;

565: p_dmlList,
566: p_timestamp);
567: if (l_ret = TRUE )
568: then
569: x_return_status := FND_API.G_RET_STS_SUCCESS;
570: else
571: x_return_status := FND_API.G_RET_STS_ERROR;
572: raise FND_API.G_EXC_UNEXPECTED_ERROR;
573: END IF;

Line 571: x_return_status := FND_API.G_RET_STS_ERROR;

567: if (l_ret = TRUE )
568: then
569: x_return_status := FND_API.G_RET_STS_SUCCESS;
570: else
571: x_return_status := FND_API.G_RET_STS_ERROR;
572: raise FND_API.G_EXC_UNEXPECTED_ERROR;
573: END IF;
574:
575: EXCEPTION

Line 572: raise FND_API.G_EXC_UNEXPECTED_ERROR;

568: then
569: x_return_status := FND_API.G_RET_STS_SUCCESS;
570: else
571: x_return_status := FND_API.G_RET_STS_ERROR;
572: raise FND_API.G_EXC_UNEXPECTED_ERROR;
573: END IF;
574:
575: EXCEPTION
576: WHEN FND_API.G_EXC_ERROR THEN

Line 576: WHEN FND_API.G_EXC_ERROR THEN

572: raise FND_API.G_EXC_UNEXPECTED_ERROR;
573: END IF;
574:
575: EXCEPTION
576: WHEN FND_API.G_EXC_ERROR THEN
577: Rollback to mark_dirty1;
578: x_return_status := FND_API.G_RET_STS_ERROR;
579:
580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 578: x_return_status := FND_API.G_RET_STS_ERROR;

574:
575: EXCEPTION
576: WHEN FND_API.G_EXC_ERROR THEN
577: Rollback to mark_dirty1;
578: x_return_status := FND_API.G_RET_STS_ERROR;
579:
580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
581: Rollback to mark_dirty1;
582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

576: WHEN FND_API.G_EXC_ERROR THEN
577: Rollback to mark_dirty1;
578: x_return_status := FND_API.G_RET_STS_ERROR;
579:
580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
581: Rollback to mark_dirty1;
582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
583:
584: WHEN OTHERS THEN

Line 582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

578: x_return_status := FND_API.G_RET_STS_ERROR;
579:
580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
581: Rollback to mark_dirty1;
582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
583:
584: WHEN OTHERS THEN
585: Rollback to mark_dirty1;
586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
583:
584: WHEN OTHERS THEN
585: Rollback to mark_dirty1;
586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
587:
588: END ;
589:
590: PROCEDURE mark_dirty (

Line 592: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,

588: END ;
589:
590: PROCEDURE mark_dirty (
591: p_api_version_number IN NUMBER,
592: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
593: p_pub_item IN VARCHAR2,
594: p_accessList IN asg_download.access_list,
595: p_userid_list IN asg_download.user_list,
596: p_dml_type IN CHAR,

Line 611: if NOT FND_API.Compatible_API_Call

607: -- Standard Start of API savepoint
608: SAVEPOINT mark_dirty2;
609:
610: -- Standard call to check for call compatibility.
611: if NOT FND_API.Compatible_API_Call
612: (
613: l_api_version_number,
614: p_api_version_number,
615: l_api_name,

Line 619: raise FND_API.G_EXC_UNEXPECTED_ERROR;

615: l_api_name,
616: G_PKG_NAME
617: )
618: then
619: raise FND_API.G_EXC_UNEXPECTED_ERROR;
620: end if;
621:
622: -- Initialize message list if p_init_msg_list is set to TRUE.
623: if FND_API.to_Boolean( p_init_msg_list)

Line 623: if FND_API.to_Boolean( p_init_msg_list)

619: raise FND_API.G_EXC_UNEXPECTED_ERROR;
620: end if;
621:
622: -- Initialize message list if p_init_msg_list is set to TRUE.
623: if FND_API.to_Boolean( p_init_msg_list)
624: then
625: FND_MSG_PUB.initialize;
626: end if;
627: -- Initialize API return status to success

Line 628: x_return_status := FND_API.G_RET_STS_SUCCESS;

624: then
625: FND_MSG_PUB.initialize;
626: end if;
627: -- Initialize API return status to success
628: x_return_status := FND_API.G_RET_STS_SUCCESS;
629:
630: l_ret := asg_download.mark_dirty(p_pub_item,
631: p_accessList,
632: p_userid_list,

Line 637: x_return_status := FND_API.G_RET_STS_SUCCESS;

633: p_dml_type,
634: p_timestamp);
635: if (l_ret = TRUE )
636: then
637: x_return_status := FND_API.G_RET_STS_SUCCESS;
638: else
639: x_return_status := FND_API.G_RET_STS_ERROR;
640: END IF;
641:

Line 639: x_return_status := FND_API.G_RET_STS_ERROR;

635: if (l_ret = TRUE )
636: then
637: x_return_status := FND_API.G_RET_STS_SUCCESS;
638: else
639: x_return_status := FND_API.G_RET_STS_ERROR;
640: END IF;
641:
642:
643: EXCEPTION

Line 644: WHEN FND_API.G_EXC_ERROR THEN

640: END IF;
641:
642:
643: EXCEPTION
644: WHEN FND_API.G_EXC_ERROR THEN
645: Rollback to mark_dirty2;
646: x_return_status := FND_API.G_RET_STS_ERROR;
647:
648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 646: x_return_status := FND_API.G_RET_STS_ERROR;

642:
643: EXCEPTION
644: WHEN FND_API.G_EXC_ERROR THEN
645: Rollback to mark_dirty2;
646: x_return_status := FND_API.G_RET_STS_ERROR;
647:
648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
649: Rollback to mark_dirty2;
650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

644: WHEN FND_API.G_EXC_ERROR THEN
645: Rollback to mark_dirty2;
646: x_return_status := FND_API.G_RET_STS_ERROR;
647:
648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
649: Rollback to mark_dirty2;
650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
651:
652: WHEN OTHERS THEN

Line 650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

646: x_return_status := FND_API.G_RET_STS_ERROR;
647:
648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
649: Rollback to mark_dirty2;
650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
651:
652: WHEN OTHERS THEN
653: Rollback to mark_dirty2;
654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
651:
652: WHEN OTHERS THEN
653: Rollback to mark_dirty2;
654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
655:
656: END ;
657:
658:

Line 662: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,

658:
659:
660: PROCEDURE mark_dirty (
661: p_api_version_number IN NUMBER,
662: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
663: p_pub_item IN VARCHAR2,
664: p_accessid IN NUMBER,
665: p_userid IN NUMBER,
666: p_dml IN CHAR,

Line 681: if NOT FND_API.Compatible_API_Call

677: -- Standard Start of API savepoint
678: SAVEPOINT mark_dirty3;
679:
680: -- Standard call to check for call compatibility.
681: if NOT FND_API.Compatible_API_Call
682: (
683: l_api_version_number,
684: p_api_version_number,
685: l_api_name,

Line 689: raise FND_API.G_EXC_UNEXPECTED_ERROR;

685: l_api_name,
686: G_PKG_NAME
687: )
688: then
689: raise FND_API.G_EXC_UNEXPECTED_ERROR;
690: end if;
691:
692: -- Initialize message list if p_init_msg_list is set to TRUE.
693: if FND_API.to_Boolean( p_init_msg_list)

Line 693: if FND_API.to_Boolean( p_init_msg_list)

689: raise FND_API.G_EXC_UNEXPECTED_ERROR;
690: end if;
691:
692: -- Initialize message list if p_init_msg_list is set to TRUE.
693: if FND_API.to_Boolean( p_init_msg_list)
694: then
695: FND_MSG_PUB.initialize;
696: end if;
697:

Line 699: x_return_status := FND_API.G_RET_STS_SUCCESS;

695: FND_MSG_PUB.initialize;
696: end if;
697:
698: -- Initialize API return status to success
699: x_return_status := FND_API.G_RET_STS_SUCCESS;
700:
701: l_ret := asg_download.mark_dirty(p_pub_item,
702: p_accessid,
703: p_userid,

Line 708: x_return_status := FND_API.G_RET_STS_SUCCESS;

704: p_dml,
705: p_timestamp);
706: if (l_ret = TRUE )
707: then
708: x_return_status := FND_API.G_RET_STS_SUCCESS;
709: else
710: x_return_status := FND_API.G_RET_STS_ERROR;
711: END IF;
712:

Line 710: x_return_status := FND_API.G_RET_STS_ERROR;

706: if (l_ret = TRUE )
707: then
708: x_return_status := FND_API.G_RET_STS_SUCCESS;
709: else
710: x_return_status := FND_API.G_RET_STS_ERROR;
711: END IF;
712:
713:
714: EXCEPTION

Line 715: WHEN FND_API.G_EXC_ERROR THEN

711: END IF;
712:
713:
714: EXCEPTION
715: WHEN FND_API.G_EXC_ERROR THEN
716: Rollback to mark_dirty3;
717: x_return_status := FND_API.G_RET_STS_ERROR;
718:
719: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 717: x_return_status := FND_API.G_RET_STS_ERROR;

713:
714: EXCEPTION
715: WHEN FND_API.G_EXC_ERROR THEN
716: Rollback to mark_dirty3;
717: x_return_status := FND_API.G_RET_STS_ERROR;
718:
719: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
720: Rollback to mark_dirty3;
721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 719: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

715: WHEN FND_API.G_EXC_ERROR THEN
716: Rollback to mark_dirty3;
717: x_return_status := FND_API.G_RET_STS_ERROR;
718:
719: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
720: Rollback to mark_dirty3;
721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
722:
723: WHEN OTHERS THEN

Line 721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

717: x_return_status := FND_API.G_RET_STS_ERROR;
718:
719: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
720: Rollback to mark_dirty3;
721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
722:
723: WHEN OTHERS THEN
724: Rollback to mark_dirty3;
725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
722:
723: WHEN OTHERS THEN
724: Rollback to mark_dirty3;
725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
726:
727: END ;
728:
729:

Line 732: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,

728:
729:
730: PROCEDURE mark_dirty (
731: p_api_version_number IN NUMBER,
732: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
733: p_pub_item IN VARCHAR2,
734: p_accessid IN NUMBER,
735: p_userid IN NUMBER,
736: p_dml IN CHAR,

Line 753: if NOT FND_API.Compatible_API_Call

749: -- Standard Start of API savepoint
750: SAVEPOINT mark_dirty4;
751:
752: -- Standard call to check for call compatibility.
753: if NOT FND_API.Compatible_API_Call
754: (
755: l_api_version_number,
756: p_api_version_number,
757: l_api_name,

Line 761: raise FND_API.G_EXC_UNEXPECTED_ERROR;

757: l_api_name,
758: G_PKG_NAME
759: )
760: then
761: raise FND_API.G_EXC_UNEXPECTED_ERROR;
762: end if;
763:
764: -- Initialize message list if p_init_msg_list is set to TRUE.
765: if FND_API.to_Boolean( p_init_msg_list)

Line 765: if FND_API.to_Boolean( p_init_msg_list)

761: raise FND_API.G_EXC_UNEXPECTED_ERROR;
762: end if;
763:
764: -- Initialize message list if p_init_msg_list is set to TRUE.
765: if FND_API.to_Boolean( p_init_msg_list)
766: then
767: FND_MSG_PUB.initialize;
768: end if;
769:

Line 771: x_return_status := FND_API.G_RET_STS_SUCCESS;

767: FND_MSG_PUB.initialize;
768: end if;
769:
770: -- Initialize API return status to success
771: x_return_status := FND_API.G_RET_STS_SUCCESS;
772:
773: l_ret := asg_download.mark_dirty(p_pub_item,
774: p_accessid,
775: p_userid,

Line 781: x_return_status := FND_API.G_RET_STS_SUCCESS;

777: p_timestamp,
778: p_pkvalues);
779: if (l_ret = TRUE )
780: then
781: x_return_status := FND_API.G_RET_STS_SUCCESS;
782: else
783: x_return_status := FND_API.G_RET_STS_ERROR;
784: END IF;
785:

Line 783: x_return_status := FND_API.G_RET_STS_ERROR;

779: if (l_ret = TRUE )
780: then
781: x_return_status := FND_API.G_RET_STS_SUCCESS;
782: else
783: x_return_status := FND_API.G_RET_STS_ERROR;
784: END IF;
785:
786:
787:

Line 789: WHEN FND_API.G_EXC_ERROR THEN

785:
786:
787:
788: EXCEPTION
789: WHEN FND_API.G_EXC_ERROR THEN
790: Rollback to mark_dirty4;
791: x_return_status := FND_API.G_RET_STS_ERROR;
792:
793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 791: x_return_status := FND_API.G_RET_STS_ERROR;

787:
788: EXCEPTION
789: WHEN FND_API.G_EXC_ERROR THEN
790: Rollback to mark_dirty4;
791: x_return_status := FND_API.G_RET_STS_ERROR;
792:
793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
794: Rollback to mark_dirty4;
795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

789: WHEN FND_API.G_EXC_ERROR THEN
790: Rollback to mark_dirty4;
791: x_return_status := FND_API.G_RET_STS_ERROR;
792:
793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
794: Rollback to mark_dirty4;
795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
796:
797: WHEN OTHERS THEN

Line 795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

791: x_return_status := FND_API.G_RET_STS_ERROR;
792:
793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
794: Rollback to mark_dirty4;
795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
796:
797: WHEN OTHERS THEN
798: Rollback to mark_dirty4;
799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
796:
797: WHEN OTHERS THEN
798: Rollback to mark_dirty4;
799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
800:
801: END ;
802:
803:

Line 806: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,

802:
803:
804: PROCEDURE mark_dirty (
805: p_api_version_number IN NUMBER,
806: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
807: p_pub_item IN VARCHAR2,
808: p_accessList IN asg_download.access_list,
809: p_userid_list IN asg_download.user_list,
810: p_dml_type IN CHAR,

Line 823: if NOT FND_API.Compatible_API_Call

819: -- Standard Start of API savepoint
820: SAVEPOINT mark_dirty5;
821:
822: -- Standard call to check for call compatibility.
823: if NOT FND_API.Compatible_API_Call
824: (
825: l_api_version_number,
826: p_api_version_number,
827: l_api_name,

Line 831: raise FND_API.G_EXC_UNEXPECTED_ERROR;

827: l_api_name,
828: G_PKG_NAME
829: )
830: then
831: raise FND_API.G_EXC_UNEXPECTED_ERROR;
832: end if;
833:
834: -- Initialize message list if p_init_msg_list is set to TRUE.
835: if FND_API.to_Boolean( p_init_msg_list)

Line 835: if FND_API.to_Boolean( p_init_msg_list)

831: raise FND_API.G_EXC_UNEXPECTED_ERROR;
832: end if;
833:
834: -- Initialize message list if p_init_msg_list is set to TRUE.
835: if FND_API.to_Boolean( p_init_msg_list)
836: then
837: FND_MSG_PUB.initialize;
838: end if;
839:

Line 841: x_return_status := FND_API.G_RET_STS_SUCCESS;

837: FND_MSG_PUB.initialize;
838: end if;
839:
840: -- Initialize API return status to success
841: x_return_status := FND_API.G_RET_STS_SUCCESS;
842:
843: l_ret := asg_download.mark_dirty(p_pub_item,
844: p_accessList,
845: p_userid_list,

Line 851: x_return_status := FND_API.G_RET_STS_SUCCESS;

847: p_timestamp,
848: p_bulk_flag);
849: if (l_ret = TRUE )
850: then
851: x_return_status := FND_API.G_RET_STS_SUCCESS;
852: else
853: x_return_status := FND_API.G_RET_STS_ERROR;
854: END IF;
855:

Line 853: x_return_status := FND_API.G_RET_STS_ERROR;

849: if (l_ret = TRUE )
850: then
851: x_return_status := FND_API.G_RET_STS_SUCCESS;
852: else
853: x_return_status := FND_API.G_RET_STS_ERROR;
854: END IF;
855:
856:
857: EXCEPTION

Line 858: WHEN FND_API.G_EXC_ERROR THEN

854: END IF;
855:
856:
857: EXCEPTION
858: WHEN FND_API.G_EXC_ERROR THEN
859: Rollback to mark_dirty5;
860: x_return_status := FND_API.G_RET_STS_ERROR;
861:
862: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 860: x_return_status := FND_API.G_RET_STS_ERROR;

856:
857: EXCEPTION
858: WHEN FND_API.G_EXC_ERROR THEN
859: Rollback to mark_dirty5;
860: x_return_status := FND_API.G_RET_STS_ERROR;
861:
862: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
863: Rollback to mark_dirty5;
864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 862: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

858: WHEN FND_API.G_EXC_ERROR THEN
859: Rollback to mark_dirty5;
860: x_return_status := FND_API.G_RET_STS_ERROR;
861:
862: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
863: Rollback to mark_dirty5;
864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
865:
866: WHEN OTHERS THEN

Line 864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

860: x_return_status := FND_API.G_RET_STS_ERROR;
861:
862: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
863: Rollback to mark_dirty5;
864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
865:
866: WHEN OTHERS THEN
867: Rollback to mark_dirty5;
868: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 868: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
865:
866: WHEN OTHERS THEN
867: Rollback to mark_dirty5;
868: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
869:
870: END ;
871:
872: