DBA Data[Home] [Help]

APPS.CSD_RO_BULLETINS_PVT dependencies on JTF_PLSQL_API

Line 117: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

113:
114: EXCEPTION
115: WHEN FND_API.G_EXC_ERROR THEN
116: x_return_status := FND_API.G_RET_STS_ERROR;
117: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
118: P_API_NAME => c_API_NAME
119: ,P_PKG_NAME => G_PKG_NAME
120: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
121: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 121: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

117: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
118: P_API_NAME => c_API_NAME
119: ,P_PKG_NAME => G_PKG_NAME
120: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
121: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
122: ,X_MSG_COUNT => X_MSG_COUNT
123: ,X_MSG_DATA => X_MSG_DATA
124: ,X_RETURN_STATUS => X_RETURN_STATUS);
125:

Line 128: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

124: ,X_RETURN_STATUS => X_RETURN_STATUS);
125:
126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
127: x_return_status := FND_API.G_RET_STS_ERROR;
128: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
129: P_API_NAME => c_API_NAME
130: ,P_PKG_NAME => G_PKG_NAME
131: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
132: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 132: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

128: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
129: P_API_NAME => c_API_NAME
130: ,P_PKG_NAME => G_PKG_NAME
131: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
132: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
133: ,X_MSG_COUNT => X_MSG_COUNT
134: ,X_MSG_DATA => X_MSG_DATA
135: ,X_RETURN_STATUS => X_RETURN_STATUS);
136:

Line 139: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

135: ,X_RETURN_STATUS => X_RETURN_STATUS);
136:
137: WHEN OTHERS THEN
138: x_return_status := FND_API.G_RET_STS_ERROR;
139: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
140: P_API_NAME => c_API_NAME
141: ,P_PKG_NAME => G_PKG_NAME
142: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
143: ,P_SQLCODE => SQLCODE

Line 142: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

138: x_return_status := FND_API.G_RET_STS_ERROR;
139: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
140: P_API_NAME => c_API_NAME
141: ,P_PKG_NAME => G_PKG_NAME
142: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
143: ,P_SQLCODE => SQLCODE
144: ,P_SQLERRM => SQLERRM
145: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
146: ,X_MSG_COUNT => X_MSG_COUNT

Line 145: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

141: ,P_PKG_NAME => G_PKG_NAME
142: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
143: ,P_SQLCODE => SQLCODE
144: ,P_SQLERRM => SQLERRM
145: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
146: ,X_MSG_COUNT => X_MSG_COUNT
147: ,X_MSG_DATA => X_MSG_DATA
148: ,X_RETURN_STATUS => X_RETURN_STATUS);
149: END CREATE_RO_BULLETIN;

Line 298: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

294:
295: EXCEPTION
296: WHEN FND_API.G_EXC_ERROR THEN
297: x_return_status := FND_API.G_RET_STS_ERROR;
298: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
299: P_API_NAME => c_API_NAME
300: ,P_PKG_NAME => G_PKG_NAME
301: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
302: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 302: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

298: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
299: P_API_NAME => c_API_NAME
300: ,P_PKG_NAME => G_PKG_NAME
301: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
302: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
303: ,X_MSG_COUNT => X_MSG_COUNT
304: ,X_MSG_DATA => X_MSG_DATA
305: ,X_RETURN_STATUS => X_RETURN_STATUS);
306:

Line 309: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

305: ,X_RETURN_STATUS => X_RETURN_STATUS);
306:
307: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
308: x_return_status := FND_API.G_RET_STS_ERROR;
309: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
310: P_API_NAME => c_API_NAME
311: ,P_PKG_NAME => G_PKG_NAME
312: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
313: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 313: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

309: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
310: P_API_NAME => c_API_NAME
311: ,P_PKG_NAME => G_PKG_NAME
312: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
313: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
314: ,X_MSG_COUNT => X_MSG_COUNT
315: ,X_MSG_DATA => X_MSG_DATA
316: ,X_RETURN_STATUS => X_RETURN_STATUS);
317:

Line 320: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

316: ,X_RETURN_STATUS => X_RETURN_STATUS);
317:
318: WHEN OTHERS THEN
319: x_return_status := FND_API.G_RET_STS_ERROR;
320: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
321: P_API_NAME => c_API_NAME
322: ,P_PKG_NAME => G_PKG_NAME
323: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
324: ,P_SQLCODE => SQLCODE

Line 323: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

319: x_return_status := FND_API.G_RET_STS_ERROR;
320: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
321: P_API_NAME => c_API_NAME
322: ,P_PKG_NAME => G_PKG_NAME
323: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
324: ,P_SQLCODE => SQLCODE
325: ,P_SQLERRM => SQLERRM
326: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
327: ,X_MSG_COUNT => X_MSG_COUNT

Line 326: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

322: ,P_PKG_NAME => G_PKG_NAME
323: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
324: ,P_SQLCODE => SQLCODE
325: ,P_SQLERRM => SQLERRM
326: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
327: ,X_MSG_COUNT => X_MSG_COUNT
328: ,X_MSG_DATA => X_MSG_DATA
329: ,X_RETURN_STATUS => X_RETURN_STATUS);
330: END UPDATE_RO_BULLETIN;

Line 414: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

410:
411: EXCEPTION
412: WHEN FND_API.G_EXC_ERROR THEN
413: x_return_status := FND_API.G_RET_STS_ERROR;
414: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
415: P_API_NAME => c_API_NAME
416: ,P_PKG_NAME => G_PKG_NAME
417: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
418: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 418: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

414: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
415: P_API_NAME => c_API_NAME
416: ,P_PKG_NAME => G_PKG_NAME
417: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
418: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
419: ,X_MSG_COUNT => X_MSG_COUNT
420: ,X_MSG_DATA => X_MSG_DATA
421: ,X_RETURN_STATUS => X_RETURN_STATUS);
422:

Line 425: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

421: ,X_RETURN_STATUS => X_RETURN_STATUS);
422:
423: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
424: x_return_status := FND_API.G_RET_STS_ERROR;
425: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
426: P_API_NAME => c_API_NAME
427: ,P_PKG_NAME => G_PKG_NAME
428: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
429: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 429: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

425: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
426: P_API_NAME => c_API_NAME
427: ,P_PKG_NAME => G_PKG_NAME
428: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
429: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
430: ,X_MSG_COUNT => X_MSG_COUNT
431: ,X_MSG_DATA => X_MSG_DATA
432: ,X_RETURN_STATUS => X_RETURN_STATUS);
433:

Line 436: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

432: ,X_RETURN_STATUS => X_RETURN_STATUS);
433:
434: WHEN OTHERS THEN
435: x_return_status := FND_API.G_RET_STS_ERROR;
436: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
437: P_API_NAME => c_API_NAME
438: ,P_PKG_NAME => G_PKG_NAME
439: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
440: ,P_SQLCODE => SQLCODE

Line 439: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

435: x_return_status := FND_API.G_RET_STS_ERROR;
436: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
437: P_API_NAME => c_API_NAME
438: ,P_PKG_NAME => G_PKG_NAME
439: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
440: ,P_SQLCODE => SQLCODE
441: ,P_SQLERRM => SQLERRM
442: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
443: ,X_MSG_COUNT => X_MSG_COUNT

Line 442: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

438: ,P_PKG_NAME => G_PKG_NAME
439: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
440: ,P_SQLCODE => SQLCODE
441: ,P_SQLERRM => SQLERRM
442: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
443: ,X_MSG_COUNT => X_MSG_COUNT
444: ,X_MSG_DATA => X_MSG_DATA
445: ,X_RETURN_STATUS => X_RETURN_STATUS);
446: End DELETE_RO_BULLETIN;

Line 529: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

525:
526: EXCEPTION
527: WHEN FND_API.G_EXC_ERROR THEN
528: x_return_status := FND_API.G_RET_STS_ERROR;
529: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
530: P_API_NAME => c_API_NAME
531: ,P_PKG_NAME => G_PKG_NAME
532: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
533: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 533: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

529: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
530: P_API_NAME => c_API_NAME
531: ,P_PKG_NAME => G_PKG_NAME
532: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
533: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
534: ,X_MSG_COUNT => X_MSG_COUNT
535: ,X_MSG_DATA => X_MSG_DATA
536: ,X_RETURN_STATUS => X_RETURN_STATUS);
537:

Line 540: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

536: ,X_RETURN_STATUS => X_RETURN_STATUS);
537:
538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
539: x_return_status := FND_API.G_RET_STS_ERROR;
540: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
541: P_API_NAME => c_API_NAME
542: ,P_PKG_NAME => G_PKG_NAME
543: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
544: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 544: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

540: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
541: P_API_NAME => c_API_NAME
542: ,P_PKG_NAME => G_PKG_NAME
543: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
544: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
545: ,X_MSG_COUNT => X_MSG_COUNT
546: ,X_MSG_DATA => X_MSG_DATA
547: ,X_RETURN_STATUS => X_RETURN_STATUS);
548:

Line 551: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

547: ,X_RETURN_STATUS => X_RETURN_STATUS);
548:
549: WHEN OTHERS THEN
550: x_return_status := FND_API.G_RET_STS_ERROR;
551: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
552: P_API_NAME => c_API_NAME
553: ,P_PKG_NAME => G_PKG_NAME
554: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
555: ,P_SQLCODE => SQLCODE

Line 554: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

550: x_return_status := FND_API.G_RET_STS_ERROR;
551: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
552: P_API_NAME => c_API_NAME
553: ,P_PKG_NAME => G_PKG_NAME
554: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
555: ,P_SQLCODE => SQLCODE
556: ,P_SQLERRM => SQLERRM
557: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
558: ,X_MSG_COUNT => X_MSG_COUNT

Line 557: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

553: ,P_PKG_NAME => G_PKG_NAME
554: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
555: ,P_SQLCODE => SQLCODE
556: ,P_SQLERRM => SQLERRM
557: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
558: ,X_MSG_COUNT => X_MSG_COUNT
559: ,X_MSG_DATA => X_MSG_DATA
560: ,X_RETURN_STATUS => X_RETURN_STATUS);
561: END LOCK_RO_BULLETIN;

Line 794: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

790:
791: EXCEPTION
792: WHEN FND_API.G_EXC_ERROR THEN
793: x_return_status := FND_API.G_RET_STS_ERROR;
794: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
795: P_API_NAME => c_API_NAME
796: ,P_PKG_NAME => G_PKG_NAME
797: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
798: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 798: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

794: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
795: P_API_NAME => c_API_NAME
796: ,P_PKG_NAME => G_PKG_NAME
797: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
798: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
799: ,X_MSG_COUNT => X_MSG_COUNT
800: ,X_MSG_DATA => X_MSG_DATA
801: ,X_RETURN_STATUS => X_RETURN_STATUS);
802:

Line 805: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

801: ,X_RETURN_STATUS => X_RETURN_STATUS);
802:
803: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
804: x_return_status := FND_API.G_RET_STS_ERROR;
805: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
806: P_API_NAME => c_API_NAME
807: ,P_PKG_NAME => G_PKG_NAME
808: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
809: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 809: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

805: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
806: P_API_NAME => c_API_NAME
807: ,P_PKG_NAME => G_PKG_NAME
808: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
809: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
810: ,X_MSG_COUNT => X_MSG_COUNT
811: ,X_MSG_DATA => X_MSG_DATA
812: ,X_RETURN_STATUS => X_RETURN_STATUS);
813:

Line 816: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

812: ,X_RETURN_STATUS => X_RETURN_STATUS);
813:
814: WHEN OTHERS THEN
815: x_return_status := FND_API.G_RET_STS_ERROR;
816: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
817: P_API_NAME => c_API_NAME
818: ,P_PKG_NAME => G_PKG_NAME
819: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
820: ,P_SQLCODE => SQLCODE

Line 819: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

815: x_return_status := FND_API.G_RET_STS_ERROR;
816: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
817: P_API_NAME => c_API_NAME
818: ,P_PKG_NAME => G_PKG_NAME
819: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
820: ,P_SQLCODE => SQLCODE
821: ,P_SQLERRM => SQLERRM
822: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
823: ,X_MSG_COUNT => X_MSG_COUNT

Line 822: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

818: ,P_PKG_NAME => G_PKG_NAME
819: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
820: ,P_SQLCODE => SQLCODE
821: ,P_SQLERRM => SQLERRM
822: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
823: ,X_MSG_COUNT => X_MSG_COUNT
824: ,X_MSG_DATA => X_MSG_DATA
825: ,X_RETURN_STATUS => X_RETURN_STATUS);
826: END LINK_BULLETINS_TO_RO;

Line 1199: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1195: --** debug starts!!
1196: --dbms_output.put_line('in CREATE_NEW_RO_BULLETIN_LINK exception 1 ');
1197: --** debug ends!!
1198:
1199: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1200: P_API_NAME => c_API_NAME
1201: ,P_PKG_NAME => G_PKG_NAME
1202: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1203: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1203: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1199: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1200: P_API_NAME => c_API_NAME
1201: ,P_PKG_NAME => G_PKG_NAME
1202: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1203: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1204: ,X_MSG_COUNT => X_MSG_COUNT
1205: ,X_MSG_DATA => X_MSG_DATA
1206: ,X_RETURN_STATUS => X_RETURN_STATUS);
1207:

Line 1214: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1210: --** debug starts!!
1211: --dbms_output.put_line('in CREATE_NEW_RO_BULLETIN_LINK exception 2 ');
1212: --** debug ends!!
1213:
1214: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1215: P_API_NAME => c_API_NAME
1216: ,P_PKG_NAME => G_PKG_NAME
1217: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1218: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1218: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1214: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1215: P_API_NAME => c_API_NAME
1216: ,P_PKG_NAME => G_PKG_NAME
1217: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1218: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1219: ,X_MSG_COUNT => X_MSG_COUNT
1220: ,X_MSG_DATA => X_MSG_DATA
1221: ,X_RETURN_STATUS => X_RETURN_STATUS);
1222:

Line 1229: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1225: --** debug starts!!
1226: --dbms_output.put_line('in CREATE_NEW_RO_BULLETIN_LINK exception 3 ');
1227: --** debug ends!!
1228:
1229: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1230: P_API_NAME => c_API_NAME
1231: ,P_PKG_NAME => G_PKG_NAME
1232: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1233: ,P_SQLCODE => SQLCODE

Line 1232: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

1228:
1229: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1230: P_API_NAME => c_API_NAME
1231: ,P_PKG_NAME => G_PKG_NAME
1232: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1233: ,P_SQLCODE => SQLCODE
1234: ,P_SQLERRM => SQLERRM
1235: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1236: ,X_MSG_COUNT => X_MSG_COUNT

Line 1235: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1231: ,P_PKG_NAME => G_PKG_NAME
1232: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1233: ,P_SQLCODE => SQLCODE
1234: ,P_SQLERRM => SQLERRM
1235: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1236: ,X_MSG_COUNT => X_MSG_COUNT
1237: ,X_MSG_DATA => X_MSG_DATA
1238: ,X_RETURN_STATUS => X_RETURN_STATUS);
1239: END CREATE_NEW_RO_BULLETIN_LINK;