APPS.IEC_CPN_RLSE_STTGY_PVT dependencies on FND_API

Line 188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

184: END;
185:
186: EXCEPTION
187: WHEN OTHERS THEN
188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
189: END GET_UNAVAILABLE_REASON;
190:
191:
192: PROCEDURE IS_SCHEDULE_ACTIVE

Line 201: X_ACTIVE := FND_API.G_RET_STS_ERROR;

197: l_schedule_id NUMBER;
198: BEGIN
199:
200: -- Return success for now..
201: X_ACTIVE := FND_API.G_RET_STS_ERROR;
202:
203: Begin
204: EXECUTE IMMEDIATE 'select unique SCHEDULE_ID ' ||
205: ' from IEC_G_EXECUTING_LISTS_V ' ||

Line 210: X_ACTIVE := FND_API.G_RET_STS_SUCCESS;

206: ' where SCHEDULE_ID = :1 '
207: INTO l_schedule_id
208: USING P_SCHEDULE_ID;
209:
210: X_ACTIVE := FND_API.G_RET_STS_SUCCESS;
211:
212: Exception
213: when NO_DATA_FOUND then
214: return;

Line 250: X_RESULT := FND_API.G_RET_STS_SUCCESS;

246: , P_QUOTA
247: , P_QUOTA_RESET
248: , P_SUBSET_ID;
249:
250: X_RESULT := FND_API.G_RET_STS_SUCCESS;
251: commit;
252:
253: END UPDATE_SUBSET_RT_INFO;
254:

Line 277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

273: WHERE RETURNS_ID = P_RETURNS_ID_TAB(j);
274:
275: EXCEPTION
276: WHEN OTHERS THEN
277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
278: END CHECK_OUT_ENTRIES;
279:
280: PROCEDURE GET_CUST_CALLBACKS
281: (P_SERVER_ID IN NUMBER

Line 335: X_RETURN_CODE := FND_API.G_RET_STS_SUCCESS;

331: BEGIN
332: ---------------------------------------------------------
333: -- Initialize the status string to send back to success.
334: ---------------------------------------------------------
335: X_RETURN_CODE := FND_API.G_RET_STS_SUCCESS;
336:
337: l_returns_id_tab := SYSTEM.NUMBER_TBL_TYPE();
338:
339: ---------------------------------------------------------

Line 510: X_RETURN_CODE := FND_API.G_RET_STS_SUCCESS;

506:
507: ---------------------------------------------------------
508: -- Initialize the status string to send back to success.
509: ---------------------------------------------------------
510: X_RETURN_CODE := FND_API.G_RET_STS_SUCCESS;
511:
512: ---------------------------------------------------------
513: -- Check to see if the campaign is locked.
514: ---------------------------------------------------------

Line 666: X_RETURN_CODE := FND_API.G_RET_STS_SUCCESS;

662:
663: BEGIN
664:
665: -- Init defaults -
666: X_RETURN_CODE := FND_API.G_RET_STS_SUCCESS;
667: l_index := X_RETURNS_ID_TAB.COUNT;
668:
669: OPEN l_entry_query_cursor(P_SUBSET_ID);
670:

Line 807: X_RETURN_CODE := FND_API.G_RET_STS_SUCCESS;

803: BEGIN
804: l_has_records := -1;
805:
806: -- Init defaults -
807: X_RETURN_CODE := FND_API.G_RET_STS_SUCCESS;
808: l_list_count := P_COUNT;
809: l_entry_index := X_RETURNS_ID_TAB.COUNT;
810:
811: -------------------------------------------------------------------

Line 1117: IF ( X_RETURN_CODE <> FND_API.G_RET_STS_SUCCESS )

1113: , P_VIEW_NAME => P_VIEW_NAME
1114: , X_RETURN_CODE => X_RETURN_CODE
1115: , X_RETURNS_ID_TAB => l_reg_RETURNS_ID_TAB );
1116:
1117: IF ( X_RETURN_CODE <> FND_API.G_RET_STS_SUCCESS )
1118: THEN
1119: exit;
1120: END IF;
1121:

Line 1308: X_RETURN_CODE := FND_API.G_RET_STS_SUCCESS;

1304:
1305: ---------------------------------------------------------
1306: -- Initialize the status string to send back to success.
1307: ---------------------------------------------------------
1308: X_RETURN_CODE := FND_API.G_RET_STS_SUCCESS;
1309:
1310: ---------------------------------------------------------
1311: -- Make sure all parameters are passed in.
1312: ---------------------------------------------------------

Line 1337: IF( l_return_code <> FND_API.G_RET_STS_SUCCESS )

1333: ---------------------------------------------------------
1334: IS_SCHEDULE_ACTIVE( P_SCHED_ID
1335: , l_return_code );
1336:
1337: IF( l_return_code <> FND_API.G_RET_STS_SUCCESS )
1338: THEN
1339: X_RETURN_CODE := SCHEDULE_IS_NOT_ACTIVE;
1340: return;
1341: END IF;

Line 1376: if( l_result_code <> FND_API.G_RET_STS_SUCCESS )

1372: , P_RLSE_CTRL_ALG_ID => P_RLSE_CTRL_ALG_ID
1373: , X_RETURN_CODE => l_result_code
1374: , X_RETURNS_ID_TAB => l_returns_id_tab );
1375:
1376: if( l_result_code <> FND_API.G_RET_STS_SUCCESS )
1377: then
1378: IEC_COMMON_UTIL_PVT.UNLOCK_SCHEDULE( P_SOURCE_ID => G_SOURCE_ID
1379: , P_SCHED_ID => P_SCHED_ID
1380: , P_SERVER_ID => P_SERVER_ID