DBA Data[Home] [Help]

APPS.WSH_ITM_RESUBMIT dependencies on WSH_ITM_RESUBMIT

Line 1: PACKAGE BODY WSH_ITM_RESUBMIT as

1: PACKAGE BODY WSH_ITM_RESUBMIT as
2: /* $Header: WSHITRSB.pls 120.1 2005/10/23 23:51:30 bradha noship $ */
3:
4: --
5: -- Package: WSH_ITM_RESUBMIT

Line 5: -- Package: WSH_ITM_RESUBMIT

1: PACKAGE BODY WSH_ITM_RESUBMIT as
2: /* $Header: WSHITRSB.pls 120.1 2005/10/23 23:51:30 bradha noship $ */
3:
4: --
5: -- Package: WSH_ITM_RESUBMIT
6: --
7: -- Purpose: To Resubmit requests for Adapter Processing.
8: --
9: --

Line 174: ROLLBACK TO WSH_ITM_RESUBMIT;

170:
171: EXCEPTION
172:
173: WHEN OTHERS THEN
174: ROLLBACK TO WSH_ITM_RESUBMIT;
175: WSH_UTIL_CORE.println(' Error while hadling the exceptions');
176:
177: END Handle_Exception;
178:

Line 181: -- Package: WSH_ITM_RESUBMIT

177: END Handle_Exception;
178:
179:
180: --
181: -- Package: WSH_ITM_RESUBMIT
182: --
183: -- Purpose: To Resubmit requests for Adapter Processing.
184: --
185: --

Line 428: SAVEPOINT WSH_ITM_RESUBMIT;

424:
425: LOOP --{
426:
427: --Issue a Savepoint
428: SAVEPOINT WSH_ITM_RESUBMIT;
429:
430: IF p_application_id = 660 THEN
431: IF DBMS_SQL.Fetch_Rows(l_cursorID) = 0 THEN
432: DBMS_SQL.Close_Cursor(l_cursorID);

Line 513: ROLLBACK TO WSH_ITM_RESUBMIT;

509: END IF;
510:
511: EXCEPTION
512: WHEN Response_Analyser_Failed THEN
513: ROLLBACK TO WSH_ITM_RESUBMIT;
514: WSH_UTIL_CORE.println('Processing Failed in Response Analyser');
515: END;
516: END IF;
517:

Line 538: ROLLBACK TO WSH_ITM_RESUBMIT;

534: EXCEPTION
535:
536: WHEN OTHERS THEN
537:
538: ROLLBACK TO WSH_ITM_RESUBMIT;
539: IF DBMS_SQL.IS_Open(l_cursorID) THEN
540: DBMS_SQL.Close_Cursor(l_cursorID);
541: END IF;
542: IF Get_Request_Control_ship%ISOPEN THEN

Line 555: END WSH_ITM_RESUBMIT;

551: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,'');
552:
553: END ITM_Resubmit_Requests;
554:
555: END WSH_ITM_RESUBMIT;