60:
61:
62: begin
63:
64: -- Standard Start of API savepoint
65: SAVEPOINT getItemError_pvt;
66:
67: -- Init values
68: l_api_name :='getItemError';
69: l_api_version_number :=1.0;
70: G_ACTIVE := 'Y';
71: G_DIR := 'asc';
72:
73: -- Standard call to check for call compatibility.
74: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
75: 1.0,
76: l_api_name,
77: G_PKG_NAME)
222: end if;
223: END IF;
224:
225: --------------------------
226: -- Standard Check Of p_commit.
227: IF FND_API.To_Boolean(p_commit) THEN
228: COMMIT WORK;
229: END IF;
230: -- Standard callto get message count and if count is 1, get message info.
226: -- Standard Check Of p_commit.
227: IF FND_API.To_Boolean(p_commit) THEN
228: COMMIT WORK;
229: END IF;
230: -- Standard callto get message count and if count is 1, get message info.
231: FND_MSG_PUB.Count_And_Get
232: ( p_encoded => FND_API.G_TRUE,
233: p_count => x_msg_count,
234: p_data => x_msg_data
279:
280:
281: begin
282:
283: -- Standard Start of API savepoint
284: SAVEPOINT clearOutboxErrors_pvt;
285:
286: -- Init values
287: l_api_name :='clearOutboxErrors';
286: -- Init values
287: l_api_name :='clearOutboxErrors';
288: l_api_version_number :=1.0;
289:
290: -- Standard call to check for call compatibility.
291: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
292: 1.0,
293: l_api_name,
294: G_PKG_NAME)
316: end loop;
317: end if;
318: end if;
319: --------------------------
320: -- Standard Check Of p_commit.
321: IF FND_API.To_Boolean(p_commit) THEN
322: COMMIT WORK;
323: END IF;
324: -- Standard callto get message count and if count is 1, get message info.
320: -- Standard Check Of p_commit.
321: IF FND_API.To_Boolean(p_commit) THEN
322: COMMIT WORK;
323: END IF;
324: -- Standard callto get message count and if count is 1, get message info.
325: FND_MSG_PUB.Count_And_Get
326: ( p_encoded => FND_API.G_TRUE,
327: p_count => x_msg_count,
328: p_data => x_msg_data
372:
373:
374: begin
375:
376: -- Standard Start of API savepoint
377: SAVEPOINT purgeOutboxErrors_pvt;
378:
379: --Init values
380: l_api_name :='purgeOutboxErrors';
378:
379: --Init values
380: l_api_name :='purgeOutboxErrors';
381: l_api_version_number :=1.0;
382: -- Standard call to check for call compatibility.
383: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
384: 1.0,
385: l_api_name,
386: G_PKG_NAME)
430: end loop;
431: end if;
432: end if;
433: --------------------------
434: -- Standard Check Of p_commit.
435: IF FND_API.To_Boolean(p_commit) THEN
436: COMMIT WORK;
437: END IF;
438: -- Standard callto get message count and if count is 1, get message info.
434: -- Standard Check Of p_commit.
435: IF FND_API.To_Boolean(p_commit) THEN
436: COMMIT WORK;
437: END IF;
438: -- Standard callto get message count and if count is 1, get message info.
439: FND_MSG_PUB.Count_And_Get
440: ( p_encoded => FND_API.G_TRUE,
441: p_count => x_msg_count,
442: p_data => x_msg_data
514:
515:
516: begin
517:
518: -- Standard Start of API savepoint
519: SAVEPOINT getOpItem_pvt;
520:
521: --Init values
522: l_api_name :='getOpItem';
521: --Init values
522: l_api_name :='getOpItem';
523: l_api_version_number :=1.0;
524:
525: -- Standard call to check for call compatibility.
526: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
527: 1.0,
528: l_api_name,
529: G_PKG_NAME)
672: v_master_acct_name);
673:
674:
675: --------------------------
676: -- Standard Check Of p_commit.
677: IF FND_API.To_Boolean(p_commit) THEN
678: COMMIT WORK;
679: END IF;
680: -- Standard callto get message count and if count is 1, get message info.
676: -- Standard Check Of p_commit.
677: IF FND_API.To_Boolean(p_commit) THEN
678: COMMIT WORK;
679: END IF;
680: -- Standard callto get message count and if count is 1, get message info.
681: FND_MSG_PUB.Count_And_Get
682: ( p_encoded => FND_API.G_TRUE,
683: p_count => x_msg_count,
684: p_data => x_msg_data
742: l_th_fail VARCHAR2(200);
743:
744: begin
745:
746: -- Standard Start of API savepoint
747: SAVEPOINT getThreadStatus_pvt;
748:
749: -- Standard call to check for call compatibility.
750: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
745:
746: -- Standard Start of API savepoint
747: SAVEPOINT getThreadStatus_pvt;
748:
749: -- Standard call to check for call compatibility.
750: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
751: 1.0,
752: l_api_name,
753: G_PKG_NAME)
784:
785:
786:
787: --------------------------
788: -- Standard Check Of p_commit.
789: IF FND_API.To_Boolean(p_commit) THEN
790: COMMIT WORK;
791: END IF;
792: -- Standard callto get message count and if count is 1, get message info.
788: -- Standard Check Of p_commit.
789: IF FND_API.To_Boolean(p_commit) THEN
790: COMMIT WORK;
791: END IF;
792: -- Standard callto get message count and if count is 1, get message info.
793: FND_MSG_PUB.Count_And_Get
794: ( p_encoded => FND_API.G_TRUE,
795: p_count => x_msg_count,
796: p_data => x_msg_data
853:
854: IEM_MDT_PROC_EX EXCEPTION;
855: begin
856:
857: -- Standard Start of API savepoint
858: SAVEPOINT pushbackToRework_pvt;
859:
860: -- Init values
861: l_api_name :='pushbackToRework';
860: -- Init values
861: l_api_name :='pushbackToRework';
862: l_api_version_number :=1.0;
863:
864: -- Standard call to check for call compatibility.
865: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
866: 1.0,
867: l_api_name,
868: G_PKG_NAME)
966: end if; -- message not auto-replied
967: end loop;
968:
969: --------------------------
970: -- Standard Check Of p_commit.
971: IF FND_API.To_Boolean(p_commit) THEN
972: COMMIT WORK;
973: END IF;
974: -- Standard callto get message count and if count is 1, get message info.
970: -- Standard Check Of p_commit.
971: IF FND_API.To_Boolean(p_commit) THEN
972: COMMIT WORK;
973: END IF;
974: -- Standard callto get message count and if count is 1, get message info.
975: FND_MSG_PUB.Count_And_Get
976: ( p_encoded => FND_API.G_TRUE,
977: p_count => x_msg_count,
978: p_data => x_msg_data