DBA Data[Home] [Help]

APPS.CS_KB_SYNC_INDEX_PKG dependencies on FND_API

Line 124: l_return_status VARCHAR2(1) := fnd_api.G_RET_STS_ERROR;

120: ( x_request_id OUT NOCOPY NUMBER,
121: x_return_status OUT NOCOPY VARCHAR2 )
122: is
123: l_request_id NUMBER;
124: l_return_status VARCHAR2(1) := fnd_api.G_RET_STS_ERROR;
125: begin
126: -- bug 3359609
127: Request_Sync_Set_index(l_request_id,
128: l_return_status);

Line 129: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS

125: begin
126: -- bug 3359609
127: Request_Sync_Set_index(l_request_id,
128: l_return_status);
129: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS
130: THEN
131: RAISE Sync_Set_Index_Error;
132: END IF;
133:

Line 136: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS

132: END IF;
133:
134: Request_Sync_Element_Index(l_request_id,
135: l_return_status);
136: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS
137: THEN
138: RAISE Sync_Element_Index_Error;
139: END IF;
140: x_request_id := l_request_id;

Line 146: x_return_status := fnd_api.G_RET_STS_ERROR;

142:
143: exception
144: when others then
145: x_request_id := 0;
146: x_return_status := fnd_api.G_RET_STS_ERROR;
147: end Request_Sync_KM_Indexes;
148:
149:
150: /*

Line 167: l_return_status VARCHAR2(1) := fnd_api.G_RET_STS_ERROR;

163: l_request_id NUMBER;
164: l_CS_appsname VARCHAR2(2) := 'CS';
165: l_mark_idx_progname VARCHAR2(30) := 'CS_KB_MARK_IDX_ON_SEC_CHG';
166: -- l_num_pending_requests NUMBER := 0;
167: l_return_status VARCHAR2(1) := fnd_api.G_RET_STS_ERROR;
168: begin
169:
170: l_request_id :=
171: fnd_request.submit_request

Line 183: l_return_status := fnd_api.G_RET_STS_SUCCESS;

179: argument3 => p_parameter2 );
180:
181: if( l_request_id > 0 )
182: then
183: l_return_status := fnd_api.G_RET_STS_SUCCESS;
184: else
185: l_return_status := fnd_api.G_RET_STS_ERROR;
186: end if;
187:

Line 185: l_return_status := fnd_api.G_RET_STS_ERROR;

181: if( l_request_id > 0 )
182: then
183: l_return_status := fnd_api.G_RET_STS_SUCCESS;
184: else
185: l_return_status := fnd_api.G_RET_STS_ERROR;
186: end if;
187:
188: x_request_id := l_request_id;
189: x_return_status := l_return_status;

Line 193: x_return_status := fnd_api.G_RET_STS_ERROR;

189: x_return_status := l_return_status;
190: exception
191: when others then
192: x_request_id := 0;
193: x_return_status := fnd_api.G_RET_STS_ERROR;
194: end Request_Mark_Idx_on_Sec_Change;
195:
196:
197: /*

Line 755: l_return_status VARCHAR2(1) := fnd_api.G_RET_STS_ERROR;

751: l_sync_idx_progname VARCHAR2(100) := 'CS_KB_SYNC_SOLUTIONS_INDEX';
752: l_sync_mode VARCHAR2(1) := 'S';
753: l_pending_phase_code VARCHAR2(1) := 'P';
754: l_num_pending_requests NUMBER := 0;
755: l_return_status VARCHAR2(1) := fnd_api.G_RET_STS_ERROR;
756: begin
757:
758: -- Detect how many Pending, but not scheduled, KM Sync-Index
759: -- concurrent program requests there are.

Line 789: l_return_status := fnd_api.G_RET_STS_SUCCESS;

785: argument1 => l_sync_mode );
786:
787: if( l_request_id > 0 )
788: then
789: l_return_status := fnd_api.G_RET_STS_SUCCESS;
790: end if;
791: else
792: -- There is already a pending request, so just return success
793: l_request_id := 0;

Line 794: l_return_status := fnd_api.G_RET_STS_SUCCESS;

790: end if;
791: else
792: -- There is already a pending request, so just return success
793: l_request_id := 0;
794: l_return_status := fnd_api.G_RET_STS_SUCCESS;
795: end if;
796:
797: x_request_id := l_request_id;
798: x_return_status := l_return_status;

Line 802: x_return_status := fnd_api.G_RET_STS_ERROR;

798: x_return_status := l_return_status;
799: EXCEPTION
800: WHEN OTHERS THEN
801: x_request_id := 0;
802: x_return_status := fnd_api.G_RET_STS_ERROR;
803: END Request_Sync_Set_Index;
804:
805:
806: /*

Line 823: l_return_status VARCHAR2(1) := fnd_api.G_RET_STS_ERROR;

819: l_sync_idx_progname VARCHAR2(100) := 'CS_KB_SYNC_STATEMENTS_INDEX';
820: l_sync_mode VARCHAR2(1) := 'S';
821: l_pending_phase_code VARCHAR2(1) := 'P';
822: l_num_pending_requests NUMBER := 0;
823: l_return_status VARCHAR2(1) := fnd_api.G_RET_STS_ERROR;
824: BEGIN
825:
826: -- Detect how many Pending, but not scheduled, KM Sync-Index
827: -- concurrent program requests there are.

Line 857: l_return_status := fnd_api.G_RET_STS_SUCCESS;

853: argument1 => l_sync_mode );
854:
855: if( l_request_id > 0 )
856: then
857: l_return_status := fnd_api.G_RET_STS_SUCCESS;
858: end if;
859: else
860: -- There is already a pending request, so just return success
861: l_request_id := 0;

Line 862: l_return_status := fnd_api.G_RET_STS_SUCCESS;

858: end if;
859: else
860: -- There is already a pending request, so just return success
861: l_request_id := 0;
862: l_return_status := fnd_api.G_RET_STS_SUCCESS;
863: end if;
864:
865: x_request_id := l_request_id;
866: x_return_status := l_return_status;

Line 870: x_return_status := fnd_api.G_RET_STS_ERROR;

866: x_return_status := l_return_status;
867: EXCEPTION
868: WHEN OTHERS THEN
869: x_request_id := 0;
870: x_return_status := fnd_api.G_RET_STS_ERROR;
871: END Request_Sync_Element_Index;
872:
873:
874: end CS_KB_SYNC_INDEX_PKG;