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 277: raise FND_API.G_EXC_ERROR;

273: if (c_type <> 'BLOB') then
274: log('The publication item does not contain the BLOB column.'||
275: ' Please chose the right'
276: ||' publication item to custom.');
277: raise FND_API.G_EXC_ERROR;
278: end if;
279:
280: if (l_pk_num + l_col_num < l_cols_count -1 ) then
281: l_count := l_pk_num + l_col_num;

Line 328: WHEN FND_API.G_EXC_ERROR THEN

324: where item_id = P_pub_item_name;
325: commit;
326:
327: EXCEPTION
328: WHEN FND_API.G_EXC_ERROR THEN
329: Rollback to customize_pub_item_PVT;
330: x_return_status := FND_API.G_RET_STS_ERROR;
331: FND_MSG_PUB.Count_And_Get
332: (

Line 330: x_return_status := FND_API.G_RET_STS_ERROR;

326:
327: EXCEPTION
328: WHEN FND_API.G_EXC_ERROR THEN
329: Rollback to customize_pub_item_PVT;
330: x_return_status := FND_API.G_RET_STS_ERROR;
331: FND_MSG_PUB.Count_And_Get
332: (
333: p_count => x_msg_count,
334: p_data => x_error_message

Line 336: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

332: (
333: p_count => x_msg_count,
334: p_data => x_error_message
335: );
336: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
337: Rollback to customize_pub_item_PVT;
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
339: FND_MSG_PUB.Count_And_Get
340: (

Line 338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

334: p_data => x_error_message
335: );
336: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
337: Rollback to customize_pub_item_PVT;
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
339: FND_MSG_PUB.Count_And_Get
340: (
341: p_count => x_msg_count,
342: p_data => x_error_message

Line 346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

342: p_data => x_error_message
343: );
344: WHEN OTHERS THEN
345: Rollback to customize_pub_item_PVT;
346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
347: if FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
348: then
349: FND_MSG_PUB.Add_Exc_Msg
350: (

Line 372: RETURN FND_API.G_RET_STS_SUCCESS;

368: begin
369: log (pCmd);
370: execute immediate pCmd;
371:
372: RETURN FND_API.G_RET_STS_SUCCESS;
373: EXCEPTION
374: when OTHERS then
375: fnd_message.set_name('ASG','SQL COMMAND FAIL!');
376: fnd_msg_pub.Add;

Line 379: RETURN FND_API.G_RET_STS_ERROR;

375: fnd_message.set_name('ASG','SQL COMMAND FAIL!');
376: fnd_msg_pub.Add;
377: log ( substr(sqlerrm, 1, 200));
378: Raise;
379: RETURN FND_API.G_RET_STS_ERROR;
380: end;
381:
382: FUNCTION generate_where (collist in varchar2)
383: RETURN VARCHAR2

Line 497: RAISE FND_API.G_EXC_ERROR;

493: ||' attribute'
494: ||to_char(l_cnt);
495: ELSIF ((l_cnt <> LAST_COL_NUM ) AND (COL_TYPE = 'BLOB') ) THEN
496: log('Exception: BLOB type Column must be the last column!');
497: RAISE FND_API.G_EXC_ERROR;
498: ELSIF ((l_cnt = LAST_COL_NUM ) AND (COL_TYPE = 'BLOB') ) THEN
499: LAST_COL_NAME := l_type_col;
500: IS_BLOB_INCLUDED := 'Y';
501: END IF;

Line 520: RAISE FND_API.G_EXC_ERROR;

516: ||' attribute'
517: ||to_char(l_cnt);
518: ELSIF ((l_cnt <> LAST_COL_NUM ) AND (COL_TYPE = 'BLOB') ) THEN
519: log('Exception: BLOB type Column must be the last column!');
520: RAISE FND_API.G_EXC_ERROR;
521: ELSIF ((l_cnt = LAST_COL_NUM ) AND (COL_TYPE = 'BLOB') ) THEN
522: IS_BLOB_INCLUDED := 'Y';
523: LAST_COL_NAME := l_type_col;
524: END IF;

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

554:
555: -- make sure to check the boolean to return varchar2
556: PROCEDURE mark_dirty (
557: p_api_version_number IN NUMBER,
558: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
559: p_pub_item IN VARCHAR2,
560: p_accessList IN asg_download.access_list,
561: p_userid_list IN asg_download.user_list,
562: p_dmlList IN asg_download.dml_list,

Line 577: if NOT FND_API.Compatible_API_Call

573: -- Standard Start of API savepoint
574: SAVEPOINT mark_dirty1;
575:
576: -- Standard call to check for call compatibility.
577: if NOT FND_API.Compatible_API_Call
578: (
579: l_api_version_number,
580: p_api_version_number,
581: l_api_name,

Line 585: raise FND_API.G_EXC_UNEXPECTED_ERROR;

581: l_api_name,
582: G_PKG_NAME
583: )
584: then
585: raise FND_API.G_EXC_UNEXPECTED_ERROR;
586: end if;
587:
588: -- Initialize message list if p_init_msg_list is set to TRUE.
589: if FND_API.to_Boolean( p_init_msg_list)

Line 589: if FND_API.to_Boolean( p_init_msg_list)

585: raise FND_API.G_EXC_UNEXPECTED_ERROR;
586: end if;
587:
588: -- Initialize message list if p_init_msg_list is set to TRUE.
589: if FND_API.to_Boolean( p_init_msg_list)
590: then
591: FND_MSG_PUB.initialize;
592: end if;
593:

Line 595: x_return_status := FND_API.G_RET_STS_SUCCESS;

591: FND_MSG_PUB.initialize;
592: end if;
593:
594: -- Initialize API return status to success
595: x_return_status := FND_API.G_RET_STS_SUCCESS;
596:
597: l_ret := asg_download.mark_dirty(p_pub_item,
598: p_accessList,
599: p_userid_list,

Line 604: x_return_status := FND_API.G_RET_STS_SUCCESS;

600: p_dmlList,
601: p_timestamp);
602: if (l_ret = TRUE )
603: then
604: x_return_status := FND_API.G_RET_STS_SUCCESS;
605: else
606: x_return_status := FND_API.G_RET_STS_ERROR;
607: raise FND_API.G_EXC_UNEXPECTED_ERROR;
608: END IF;

Line 606: x_return_status := FND_API.G_RET_STS_ERROR;

602: if (l_ret = TRUE )
603: then
604: x_return_status := FND_API.G_RET_STS_SUCCESS;
605: else
606: x_return_status := FND_API.G_RET_STS_ERROR;
607: raise FND_API.G_EXC_UNEXPECTED_ERROR;
608: END IF;
609:
610: EXCEPTION

Line 607: raise FND_API.G_EXC_UNEXPECTED_ERROR;

603: then
604: x_return_status := FND_API.G_RET_STS_SUCCESS;
605: else
606: x_return_status := FND_API.G_RET_STS_ERROR;
607: raise FND_API.G_EXC_UNEXPECTED_ERROR;
608: END IF;
609:
610: EXCEPTION
611: WHEN FND_API.G_EXC_ERROR THEN

Line 611: WHEN FND_API.G_EXC_ERROR THEN

607: raise FND_API.G_EXC_UNEXPECTED_ERROR;
608: END IF;
609:
610: EXCEPTION
611: WHEN FND_API.G_EXC_ERROR THEN
612: Rollback to mark_dirty1;
613: x_return_status := FND_API.G_RET_STS_ERROR;
614:
615: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 613: x_return_status := FND_API.G_RET_STS_ERROR;

609:
610: EXCEPTION
611: WHEN FND_API.G_EXC_ERROR THEN
612: Rollback to mark_dirty1;
613: x_return_status := FND_API.G_RET_STS_ERROR;
614:
615: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
616: Rollback to mark_dirty1;
617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 615: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

611: WHEN FND_API.G_EXC_ERROR THEN
612: Rollback to mark_dirty1;
613: x_return_status := FND_API.G_RET_STS_ERROR;
614:
615: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
616: Rollback to mark_dirty1;
617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
618:
619: WHEN OTHERS THEN

Line 617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

613: x_return_status := FND_API.G_RET_STS_ERROR;
614:
615: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
616: Rollback to mark_dirty1;
617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
618:
619: WHEN OTHERS THEN
620: Rollback to mark_dirty1;
621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
618:
619: WHEN OTHERS THEN
620: Rollback to mark_dirty1;
621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
622:
623: END ;
624:
625: PROCEDURE mark_dirty (

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

623: END ;
624:
625: PROCEDURE mark_dirty (
626: p_api_version_number IN NUMBER,
627: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
628: p_pub_item IN VARCHAR2,
629: p_accessList IN asg_download.access_list,
630: p_userid_list IN asg_download.user_list,
631: p_dml_type IN CHAR,

Line 646: if NOT FND_API.Compatible_API_Call

642: -- Standard Start of API savepoint
643: SAVEPOINT mark_dirty2;
644:
645: -- Standard call to check for call compatibility.
646: if NOT FND_API.Compatible_API_Call
647: (
648: l_api_version_number,
649: p_api_version_number,
650: l_api_name,

Line 654: raise FND_API.G_EXC_UNEXPECTED_ERROR;

650: l_api_name,
651: G_PKG_NAME
652: )
653: then
654: raise FND_API.G_EXC_UNEXPECTED_ERROR;
655: end if;
656:
657: -- Initialize message list if p_init_msg_list is set to TRUE.
658: if FND_API.to_Boolean( p_init_msg_list)

Line 658: if FND_API.to_Boolean( p_init_msg_list)

654: raise FND_API.G_EXC_UNEXPECTED_ERROR;
655: end if;
656:
657: -- Initialize message list if p_init_msg_list is set to TRUE.
658: if FND_API.to_Boolean( p_init_msg_list)
659: then
660: FND_MSG_PUB.initialize;
661: end if;
662: -- Initialize API return status to success

Line 663: x_return_status := FND_API.G_RET_STS_SUCCESS;

659: then
660: FND_MSG_PUB.initialize;
661: end if;
662: -- Initialize API return status to success
663: x_return_status := FND_API.G_RET_STS_SUCCESS;
664:
665: l_ret := asg_download.mark_dirty(p_pub_item,
666: p_accessList,
667: p_userid_list,

Line 672: x_return_status := FND_API.G_RET_STS_SUCCESS;

668: p_dml_type,
669: p_timestamp);
670: if (l_ret = TRUE )
671: then
672: x_return_status := FND_API.G_RET_STS_SUCCESS;
673: else
674: x_return_status := FND_API.G_RET_STS_ERROR;
675: END IF;
676:

Line 674: x_return_status := FND_API.G_RET_STS_ERROR;

670: if (l_ret = TRUE )
671: then
672: x_return_status := FND_API.G_RET_STS_SUCCESS;
673: else
674: x_return_status := FND_API.G_RET_STS_ERROR;
675: END IF;
676:
677:
678: EXCEPTION

Line 679: WHEN FND_API.G_EXC_ERROR THEN

675: END IF;
676:
677:
678: EXCEPTION
679: WHEN FND_API.G_EXC_ERROR THEN
680: Rollback to mark_dirty2;
681: x_return_status := FND_API.G_RET_STS_ERROR;
682:
683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 681: x_return_status := FND_API.G_RET_STS_ERROR;

677:
678: EXCEPTION
679: WHEN FND_API.G_EXC_ERROR THEN
680: Rollback to mark_dirty2;
681: x_return_status := FND_API.G_RET_STS_ERROR;
682:
683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
684: Rollback to mark_dirty2;
685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

679: WHEN FND_API.G_EXC_ERROR THEN
680: Rollback to mark_dirty2;
681: x_return_status := FND_API.G_RET_STS_ERROR;
682:
683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
684: Rollback to mark_dirty2;
685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
686:
687: WHEN OTHERS THEN

Line 685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

681: x_return_status := FND_API.G_RET_STS_ERROR;
682:
683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
684: Rollback to mark_dirty2;
685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
686:
687: WHEN OTHERS THEN
688: Rollback to mark_dirty2;
689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
686:
687: WHEN OTHERS THEN
688: Rollback to mark_dirty2;
689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
690:
691: END ;
692:
693:

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

693:
694:
695: PROCEDURE mark_dirty (
696: p_api_version_number IN NUMBER,
697: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
698: p_pub_item IN VARCHAR2,
699: p_accessid IN NUMBER,
700: p_userid IN NUMBER,
701: p_dml IN CHAR,

Line 716: if NOT FND_API.Compatible_API_Call

712: -- Standard Start of API savepoint
713: SAVEPOINT mark_dirty3;
714:
715: -- Standard call to check for call compatibility.
716: if NOT FND_API.Compatible_API_Call
717: (
718: l_api_version_number,
719: p_api_version_number,
720: l_api_name,

Line 724: raise FND_API.G_EXC_UNEXPECTED_ERROR;

720: l_api_name,
721: G_PKG_NAME
722: )
723: then
724: raise FND_API.G_EXC_UNEXPECTED_ERROR;
725: end if;
726:
727: -- Initialize message list if p_init_msg_list is set to TRUE.
728: if FND_API.to_Boolean( p_init_msg_list)

Line 728: if FND_API.to_Boolean( p_init_msg_list)

724: raise FND_API.G_EXC_UNEXPECTED_ERROR;
725: end if;
726:
727: -- Initialize message list if p_init_msg_list is set to TRUE.
728: if FND_API.to_Boolean( p_init_msg_list)
729: then
730: FND_MSG_PUB.initialize;
731: end if;
732:

Line 734: x_return_status := FND_API.G_RET_STS_SUCCESS;

730: FND_MSG_PUB.initialize;
731: end if;
732:
733: -- Initialize API return status to success
734: x_return_status := FND_API.G_RET_STS_SUCCESS;
735:
736: l_ret := asg_download.mark_dirty(p_pub_item,
737: p_accessid,
738: p_userid,

Line 743: x_return_status := FND_API.G_RET_STS_SUCCESS;

739: p_dml,
740: p_timestamp);
741: if (l_ret = TRUE )
742: then
743: x_return_status := FND_API.G_RET_STS_SUCCESS;
744: else
745: x_return_status := FND_API.G_RET_STS_ERROR;
746: END IF;
747:

Line 745: x_return_status := FND_API.G_RET_STS_ERROR;

741: if (l_ret = TRUE )
742: then
743: x_return_status := FND_API.G_RET_STS_SUCCESS;
744: else
745: x_return_status := FND_API.G_RET_STS_ERROR;
746: END IF;
747:
748:
749: EXCEPTION

Line 750: WHEN FND_API.G_EXC_ERROR THEN

746: END IF;
747:
748:
749: EXCEPTION
750: WHEN FND_API.G_EXC_ERROR THEN
751: Rollback to mark_dirty3;
752: x_return_status := FND_API.G_RET_STS_ERROR;
753:
754: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 752: x_return_status := FND_API.G_RET_STS_ERROR;

748:
749: EXCEPTION
750: WHEN FND_API.G_EXC_ERROR THEN
751: Rollback to mark_dirty3;
752: x_return_status := FND_API.G_RET_STS_ERROR;
753:
754: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
755: Rollback to mark_dirty3;
756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 754: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

750: WHEN FND_API.G_EXC_ERROR THEN
751: Rollback to mark_dirty3;
752: x_return_status := FND_API.G_RET_STS_ERROR;
753:
754: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
755: Rollback to mark_dirty3;
756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
757:
758: WHEN OTHERS THEN

Line 756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

752: x_return_status := FND_API.G_RET_STS_ERROR;
753:
754: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
755: Rollback to mark_dirty3;
756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
757:
758: WHEN OTHERS THEN
759: Rollback to mark_dirty3;
760: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 760: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
757:
758: WHEN OTHERS THEN
759: Rollback to mark_dirty3;
760: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
761:
762: END ;
763:
764:

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

763:
764:
765: PROCEDURE mark_dirty (
766: p_api_version_number IN NUMBER,
767: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
768: p_pub_item IN VARCHAR2,
769: p_accessid IN NUMBER,
770: p_userid IN NUMBER,
771: p_dml IN CHAR,

Line 788: if NOT FND_API.Compatible_API_Call

784: -- Standard Start of API savepoint
785: SAVEPOINT mark_dirty4;
786:
787: -- Standard call to check for call compatibility.
788: if NOT FND_API.Compatible_API_Call
789: (
790: l_api_version_number,
791: p_api_version_number,
792: l_api_name,

Line 796: raise FND_API.G_EXC_UNEXPECTED_ERROR;

792: l_api_name,
793: G_PKG_NAME
794: )
795: then
796: raise FND_API.G_EXC_UNEXPECTED_ERROR;
797: end if;
798:
799: -- Initialize message list if p_init_msg_list is set to TRUE.
800: if FND_API.to_Boolean( p_init_msg_list)

Line 800: if FND_API.to_Boolean( p_init_msg_list)

796: raise FND_API.G_EXC_UNEXPECTED_ERROR;
797: end if;
798:
799: -- Initialize message list if p_init_msg_list is set to TRUE.
800: if FND_API.to_Boolean( p_init_msg_list)
801: then
802: FND_MSG_PUB.initialize;
803: end if;
804:

Line 806: x_return_status := FND_API.G_RET_STS_SUCCESS;

802: FND_MSG_PUB.initialize;
803: end if;
804:
805: -- Initialize API return status to success
806: x_return_status := FND_API.G_RET_STS_SUCCESS;
807:
808: l_ret := asg_download.mark_dirty(p_pub_item,
809: p_accessid,
810: p_userid,

Line 816: x_return_status := FND_API.G_RET_STS_SUCCESS;

812: p_timestamp,
813: p_pkvalues);
814: if (l_ret = TRUE )
815: then
816: x_return_status := FND_API.G_RET_STS_SUCCESS;
817: else
818: x_return_status := FND_API.G_RET_STS_ERROR;
819: END IF;
820:

Line 818: x_return_status := FND_API.G_RET_STS_ERROR;

814: if (l_ret = TRUE )
815: then
816: x_return_status := FND_API.G_RET_STS_SUCCESS;
817: else
818: x_return_status := FND_API.G_RET_STS_ERROR;
819: END IF;
820:
821:
822:

Line 824: WHEN FND_API.G_EXC_ERROR THEN

820:
821:
822:
823: EXCEPTION
824: WHEN FND_API.G_EXC_ERROR THEN
825: Rollback to mark_dirty4;
826: x_return_status := FND_API.G_RET_STS_ERROR;
827:
828: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 826: x_return_status := FND_API.G_RET_STS_ERROR;

822:
823: EXCEPTION
824: WHEN FND_API.G_EXC_ERROR THEN
825: Rollback to mark_dirty4;
826: x_return_status := FND_API.G_RET_STS_ERROR;
827:
828: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
829: Rollback to mark_dirty4;
830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 828: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

824: WHEN FND_API.G_EXC_ERROR THEN
825: Rollback to mark_dirty4;
826: x_return_status := FND_API.G_RET_STS_ERROR;
827:
828: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
829: Rollback to mark_dirty4;
830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
831:
832: WHEN OTHERS THEN

Line 830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

826: x_return_status := FND_API.G_RET_STS_ERROR;
827:
828: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
829: Rollback to mark_dirty4;
830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
831:
832: WHEN OTHERS THEN
833: Rollback to mark_dirty4;
834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
831:
832: WHEN OTHERS THEN
833: Rollback to mark_dirty4;
834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
835:
836: END ;
837:
838:

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

837:
838:
839: PROCEDURE mark_dirty (
840: p_api_version_number IN NUMBER,
841: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
842: p_pub_item IN VARCHAR2,
843: p_accessList IN asg_download.access_list,
844: p_userid_list IN asg_download.user_list,
845: p_dml_type IN CHAR,

Line 858: if NOT FND_API.Compatible_API_Call

854: -- Standard Start of API savepoint
855: SAVEPOINT mark_dirty5;
856:
857: -- Standard call to check for call compatibility.
858: if NOT FND_API.Compatible_API_Call
859: (
860: l_api_version_number,
861: p_api_version_number,
862: l_api_name,

Line 866: raise FND_API.G_EXC_UNEXPECTED_ERROR;

862: l_api_name,
863: G_PKG_NAME
864: )
865: then
866: raise FND_API.G_EXC_UNEXPECTED_ERROR;
867: end if;
868:
869: -- Initialize message list if p_init_msg_list is set to TRUE.
870: if FND_API.to_Boolean( p_init_msg_list)

Line 870: if FND_API.to_Boolean( p_init_msg_list)

866: raise FND_API.G_EXC_UNEXPECTED_ERROR;
867: end if;
868:
869: -- Initialize message list if p_init_msg_list is set to TRUE.
870: if FND_API.to_Boolean( p_init_msg_list)
871: then
872: FND_MSG_PUB.initialize;
873: end if;
874:

Line 876: x_return_status := FND_API.G_RET_STS_SUCCESS;

872: FND_MSG_PUB.initialize;
873: end if;
874:
875: -- Initialize API return status to success
876: x_return_status := FND_API.G_RET_STS_SUCCESS;
877:
878: l_ret := asg_download.mark_dirty(p_pub_item,
879: p_accessList,
880: p_userid_list,

Line 886: x_return_status := FND_API.G_RET_STS_SUCCESS;

882: p_timestamp,
883: p_bulk_flag);
884: if (l_ret = TRUE )
885: then
886: x_return_status := FND_API.G_RET_STS_SUCCESS;
887: else
888: x_return_status := FND_API.G_RET_STS_ERROR;
889: END IF;
890:

Line 888: x_return_status := FND_API.G_RET_STS_ERROR;

884: if (l_ret = TRUE )
885: then
886: x_return_status := FND_API.G_RET_STS_SUCCESS;
887: else
888: x_return_status := FND_API.G_RET_STS_ERROR;
889: END IF;
890:
891:
892: EXCEPTION

Line 893: WHEN FND_API.G_EXC_ERROR THEN

889: END IF;
890:
891:
892: EXCEPTION
893: WHEN FND_API.G_EXC_ERROR THEN
894: Rollback to mark_dirty5;
895: x_return_status := FND_API.G_RET_STS_ERROR;
896:
897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 895: x_return_status := FND_API.G_RET_STS_ERROR;

891:
892: EXCEPTION
893: WHEN FND_API.G_EXC_ERROR THEN
894: Rollback to mark_dirty5;
895: x_return_status := FND_API.G_RET_STS_ERROR;
896:
897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
898: Rollback to mark_dirty5;
899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

893: WHEN FND_API.G_EXC_ERROR THEN
894: Rollback to mark_dirty5;
895: x_return_status := FND_API.G_RET_STS_ERROR;
896:
897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
898: Rollback to mark_dirty5;
899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
900:
901: WHEN OTHERS THEN

Line 899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

895: x_return_status := FND_API.G_RET_STS_ERROR;
896:
897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
898: Rollback to mark_dirty5;
899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
900:
901: WHEN OTHERS THEN
902: Rollback to mark_dirty5;
903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
900:
901: WHEN OTHERS THEN
902: Rollback to mark_dirty5;
903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
904:
905: END ;
906:
907: