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.AST_SEARCH_RESULT_PVT dependencies on JTF_PLSQL_API

Line 69: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'start');

65: FND_MSG_PUB.initialize;
66: END IF;
67:
68: -- Debug Message
69: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'start');
70:
71: -- Initialize API return status to SUCCESS
72: x_return_status := FND_API.G_RET_STS_SUCCESS;
73:

Line 104: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'end');

100: END IF;
101:
102:
103: -- Debug Message
104: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'end');
105:
106: -- Standard call to get message count and if count is 1, get message info.
107: FND_MSG_PUB.Count_And_Get
108: ( p_count => x_msg_count,

Line 114: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

110: );
111:
112: EXCEPTION
113: WHEN FND_API.G_EXC_ERROR THEN
114: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
115: P_API_NAME => L_API_NAME
116: ,P_PKG_NAME => G_PKG_NAME
117: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
118: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 118: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

114: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
115: P_API_NAME => L_API_NAME
116: ,P_PKG_NAME => G_PKG_NAME
117: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
118: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
119: ,X_MSG_COUNT => X_MSG_COUNT
120: ,X_MSG_DATA => X_MSG_DATA
121: ,X_RETURN_STATUS => X_RETURN_STATUS);
122:

Line 124: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

120: ,X_MSG_DATA => X_MSG_DATA
121: ,X_RETURN_STATUS => X_RETURN_STATUS);
122:
123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
124: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
125: P_API_NAME => L_API_NAME
126: ,P_PKG_NAME => G_PKG_NAME
127: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
128: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 128: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

124: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
125: P_API_NAME => L_API_NAME
126: ,P_PKG_NAME => G_PKG_NAME
127: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
128: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
129: ,X_MSG_COUNT => X_MSG_COUNT
130: ,X_MSG_DATA => X_MSG_DATA
131: ,X_RETURN_STATUS => X_RETURN_STATUS);
132:

Line 134: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

130: ,X_MSG_DATA => X_MSG_DATA
131: ,X_RETURN_STATUS => X_RETURN_STATUS);
132:
133: WHEN OTHERS THEN
134: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
135: P_API_NAME => L_API_NAME
136: ,P_PKG_NAME => G_PKG_NAME
137: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
138: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 137: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

133: WHEN OTHERS THEN
134: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
135: P_API_NAME => L_API_NAME
136: ,P_PKG_NAME => G_PKG_NAME
137: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
138: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
139: ,X_MSG_COUNT => X_MSG_COUNT
140: ,X_MSG_DATA => X_MSG_DATA
141: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 138: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

134: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
135: P_API_NAME => L_API_NAME
136: ,P_PKG_NAME => G_PKG_NAME
137: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
138: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
139: ,X_MSG_COUNT => X_MSG_COUNT
140: ,X_MSG_DATA => X_MSG_DATA
141: ,X_RETURN_STATUS => X_RETURN_STATUS);
142: End Create_search_result;

Line 185: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'start');

181: FND_MSG_PUB.initialize;
182: END IF;
183:
184: -- Debug Message
185: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'start');
186:
187: -- Initialize API return status to SUCCESS
188: x_return_status := FND_API.G_RET_STS_SUCCESS;
189:

Line 216: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'end');

212: END IF;
213:
214:
215: -- Debug Message
216: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'end');
217:
218: -- Standard call to get message count and if count is 1, get message info.
219: FND_MSG_PUB.Count_And_Get
220: ( p_count => x_msg_count,

Line 226: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

222: );
223:
224: EXCEPTION
225: WHEN FND_API.G_EXC_ERROR THEN
226: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
227: P_API_NAME => L_API_NAME
228: ,P_PKG_NAME => G_PKG_NAME
229: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
230: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 230: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

226: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
227: P_API_NAME => L_API_NAME
228: ,P_PKG_NAME => G_PKG_NAME
229: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
230: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
231: ,X_MSG_COUNT => X_MSG_COUNT
232: ,X_MSG_DATA => X_MSG_DATA
233: ,X_RETURN_STATUS => X_RETURN_STATUS);
234:

Line 236: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

232: ,X_MSG_DATA => X_MSG_DATA
233: ,X_RETURN_STATUS => X_RETURN_STATUS);
234:
235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
236: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
237: P_API_NAME => L_API_NAME
238: ,P_PKG_NAME => G_PKG_NAME
239: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
240: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 240: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

236: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
237: P_API_NAME => L_API_NAME
238: ,P_PKG_NAME => G_PKG_NAME
239: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
240: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
241: ,X_MSG_COUNT => X_MSG_COUNT
242: ,X_MSG_DATA => X_MSG_DATA
243: ,X_RETURN_STATUS => X_RETURN_STATUS);
244:

Line 246: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

242: ,X_MSG_DATA => X_MSG_DATA
243: ,X_RETURN_STATUS => X_RETURN_STATUS);
244:
245: WHEN OTHERS THEN
246: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
247: P_API_NAME => L_API_NAME
248: ,P_PKG_NAME => G_PKG_NAME
249: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
250: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 249: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

245: WHEN OTHERS THEN
246: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
247: P_API_NAME => L_API_NAME
248: ,P_PKG_NAME => G_PKG_NAME
249: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
250: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
251: ,X_MSG_COUNT => X_MSG_COUNT
252: ,X_MSG_DATA => X_MSG_DATA
253: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 250: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

246: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
247: P_API_NAME => L_API_NAME
248: ,P_PKG_NAME => G_PKG_NAME
249: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
250: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
251: ,X_MSG_COUNT => X_MSG_COUNT
252: ,X_MSG_DATA => X_MSG_DATA
253: ,X_RETURN_STATUS => X_RETURN_STATUS);
254: End Get_search_result;

Line 294: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'start');

290: FND_MSG_PUB.initialize;
291: END IF;
292:
293: -- Debug Message
294: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'start');
295:
296: -- Initialize API return status to SUCCESS
297: x_return_status := FND_API.G_RET_STS_SUCCESS;
298:

Line 321: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'end');

317: END IF;
318:
319:
320: -- Debug Message
321: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'end');
322:
323: -- Standard call to get message count and if count is 1, get message info.
324: FND_MSG_PUB.Count_And_Get
325: ( p_count => x_msg_count,

Line 331: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

327: );
328:
329: EXCEPTION
330: WHEN FND_API.G_EXC_ERROR THEN
331: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
332: P_API_NAME => L_API_NAME
333: ,P_PKG_NAME => G_PKG_NAME
334: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
335: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 335: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

331: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
332: P_API_NAME => L_API_NAME
333: ,P_PKG_NAME => G_PKG_NAME
334: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
335: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
336: ,X_MSG_COUNT => X_MSG_COUNT
337: ,X_MSG_DATA => X_MSG_DATA
338: ,X_RETURN_STATUS => X_RETURN_STATUS);
339:

Line 341: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

337: ,X_MSG_DATA => X_MSG_DATA
338: ,X_RETURN_STATUS => X_RETURN_STATUS);
339:
340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
341: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
342: P_API_NAME => L_API_NAME
343: ,P_PKG_NAME => G_PKG_NAME
344: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
345: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 345: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

341: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
342: P_API_NAME => L_API_NAME
343: ,P_PKG_NAME => G_PKG_NAME
344: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
345: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
346: ,X_MSG_COUNT => X_MSG_COUNT
347: ,X_MSG_DATA => X_MSG_DATA
348: ,X_RETURN_STATUS => X_RETURN_STATUS);
349:

Line 351: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

347: ,X_MSG_DATA => X_MSG_DATA
348: ,X_RETURN_STATUS => X_RETURN_STATUS);
349:
350: WHEN OTHERS THEN
351: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
352: P_API_NAME => L_API_NAME
353: ,P_PKG_NAME => G_PKG_NAME
354: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
355: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 354: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

350: WHEN OTHERS THEN
351: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
352: P_API_NAME => L_API_NAME
353: ,P_PKG_NAME => G_PKG_NAME
354: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
355: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
356: ,X_MSG_COUNT => X_MSG_COUNT
357: ,X_MSG_DATA => X_MSG_DATA
358: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 355: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

351: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
352: P_API_NAME => L_API_NAME
353: ,P_PKG_NAME => G_PKG_NAME
354: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
355: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
356: ,X_MSG_COUNT => X_MSG_COUNT
357: ,X_MSG_DATA => X_MSG_DATA
358: ,X_RETURN_STATUS => X_RETURN_STATUS);
359: END;

Line 434: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'end');

430: COMMIT WORK;
431: END IF;
432:
433: -- Debug Message
434: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'end');
435:
436: -- Standard call to get message count and if count is 1, get message info.
437: FND_MSG_PUB.Count_And_Get
438: ( p_count => x_msg_count,

Line 444: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

440: );
441:
442: EXCEPTION
443: WHEN FND_API.G_EXC_ERROR THEN
444: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
445: P_API_NAME => L_API_NAME
446: ,P_PKG_NAME => G_PKG_NAME
447: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
448: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 448: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

444: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
445: P_API_NAME => L_API_NAME
446: ,P_PKG_NAME => G_PKG_NAME
447: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
448: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
449: ,X_MSG_COUNT => X_MSG_COUNT
450: ,X_MSG_DATA => X_MSG_DATA
451: ,X_RETURN_STATUS => X_RETURN_STATUS);
452:

Line 454: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

450: ,X_MSG_DATA => X_MSG_DATA
451: ,X_RETURN_STATUS => X_RETURN_STATUS);
452:
453: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
454: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
455: P_API_NAME => L_API_NAME
456: ,P_PKG_NAME => G_PKG_NAME
457: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
458: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 458: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

454: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
455: P_API_NAME => L_API_NAME
456: ,P_PKG_NAME => G_PKG_NAME
457: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
458: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
459: ,X_MSG_COUNT => X_MSG_COUNT
460: ,X_MSG_DATA => X_MSG_DATA
461: ,X_RETURN_STATUS => X_RETURN_STATUS);
462:

Line 464: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

460: ,X_MSG_DATA => X_MSG_DATA
461: ,X_RETURN_STATUS => X_RETURN_STATUS);
462:
463: WHEN OTHERS THEN
464: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
465: P_API_NAME => L_API_NAME
466: ,P_PKG_NAME => G_PKG_NAME
467: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
468: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 467: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

463: WHEN OTHERS THEN
464: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
465: P_API_NAME => L_API_NAME
466: ,P_PKG_NAME => G_PKG_NAME
467: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
468: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
469: ,X_MSG_COUNT => X_MSG_COUNT
470: ,X_MSG_DATA => X_MSG_DATA
471: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 468: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

464: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
465: P_API_NAME => L_API_NAME
466: ,P_PKG_NAME => G_PKG_NAME
467: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
468: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
469: ,X_MSG_COUNT => X_MSG_COUNT
470: ,X_MSG_DATA => X_MSG_DATA
471: ,X_RETURN_STATUS => X_RETURN_STATUS);
472:

Line 534: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'end');

530: COMMIT WORK;
531: END IF;
532:
533: -- Debug Message
534: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'end');
535:
536: -- Standard call to get message count and if count is 1, get message info.
537: FND_MSG_PUB.Count_And_Get
538: ( p_count => x_msg_count,

Line 544: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

540: );
541:
542: EXCEPTION
543: WHEN FND_API.G_EXC_ERROR THEN
544: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
545: P_API_NAME => L_API_NAME
546: ,P_PKG_NAME => G_PKG_NAME
547: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
548: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 548: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

544: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
545: P_API_NAME => L_API_NAME
546: ,P_PKG_NAME => G_PKG_NAME
547: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
548: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
549: ,X_MSG_COUNT => X_MSG_COUNT
550: ,X_MSG_DATA => X_MSG_DATA
551: ,X_RETURN_STATUS => X_RETURN_STATUS);
552:

Line 554: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

550: ,X_MSG_DATA => X_MSG_DATA
551: ,X_RETURN_STATUS => X_RETURN_STATUS);
552:
553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
554: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
555: P_API_NAME => L_API_NAME
556: ,P_PKG_NAME => G_PKG_NAME
557: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
558: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 558: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

554: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
555: P_API_NAME => L_API_NAME
556: ,P_PKG_NAME => G_PKG_NAME
557: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
558: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
559: ,X_MSG_COUNT => X_MSG_COUNT
560: ,X_MSG_DATA => X_MSG_DATA
561: ,X_RETURN_STATUS => X_RETURN_STATUS);
562:

Line 564: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

560: ,X_MSG_DATA => X_MSG_DATA
561: ,X_RETURN_STATUS => X_RETURN_STATUS);
562:
563: WHEN OTHERS THEN
564: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
565: P_API_NAME => L_API_NAME
566: ,P_PKG_NAME => G_PKG_NAME
567: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
568: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 567: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

563: WHEN OTHERS THEN
564: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
565: P_API_NAME => L_API_NAME
566: ,P_PKG_NAME => G_PKG_NAME
567: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
568: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
569: ,X_MSG_COUNT => X_MSG_COUNT
570: ,X_MSG_DATA => X_MSG_DATA
571: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 568: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

564: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
565: P_API_NAME => L_API_NAME
566: ,P_PKG_NAME => G_PKG_NAME
567: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
568: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
569: ,X_MSG_COUNT => X_MSG_COUNT
570: ,X_MSG_DATA => X_MSG_DATA
571: ,X_RETURN_STATUS => X_RETURN_STATUS);
572: END;