DBA Data[Home] [Help]

APPS.CSP_PL_SHIP_UTIL dependencies on JTF_PLSQL_API

Line 12: -- klou 01/12/99 replace as_utility calls with jtf_plsql_api.

8: --
9: -- Modification History
10: -- Userid Date Comments
11: -- --------- ------ ------------------------------------------
12: -- klou 01/12/99 replace as_utility calls with jtf_plsql_api.
13: -- klou 01/04/99 created
14: --
15: -- Note :
16: -- End of comments

Line 519: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

515: fnd_msg_pub.count_and_get
516: ( p_count => x_msg_count
517: , p_data => x_msg_data);
518: WHEN FND_API.G_EXC_ERROR THEN
519: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
520: P_API_NAME => L_API_NAME
521: ,P_PKG_NAME => G_PKG_NAME
522: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
523: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 523: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

519: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
520: P_API_NAME => L_API_NAME
521: ,P_PKG_NAME => G_PKG_NAME
522: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
523: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
524: ,X_MSG_COUNT => X_MSG_COUNT
525: ,X_MSG_DATA => X_MSG_DATA
526: ,X_RETURN_STATUS => X_RETURN_STATUS);
527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 528: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

524: ,X_MSG_COUNT => X_MSG_COUNT
525: ,X_MSG_DATA => X_MSG_DATA
526: ,X_RETURN_STATUS => X_RETURN_STATUS);
527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
528: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
529: P_API_NAME => L_API_NAME
530: ,P_PKG_NAME => G_PKG_NAME
531: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
532: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 532: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

528: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
529: P_API_NAME => L_API_NAME
530: ,P_PKG_NAME => G_PKG_NAME
531: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
532: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
533: ,X_MSG_COUNT => X_MSG_COUNT
534: ,X_MSG_DATA => X_MSG_DATA
535: ,X_RETURN_STATUS => X_RETURN_STATUS);
536: WHEN OTHERS THEN

Line 741: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

737: fnd_msg_pub.count_and_get
738: ( p_count => x_msg_count
739: , p_data => x_msg_data);
740: WHEN FND_API.G_EXC_ERROR THEN
741: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
742: P_API_NAME => L_API_NAME
743: ,P_PKG_NAME => G_PKG_NAME
744: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
745: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 745: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

741: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
742: P_API_NAME => L_API_NAME
743: ,P_PKG_NAME => G_PKG_NAME
744: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
745: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
746: ,X_MSG_COUNT => X_MSG_COUNT
747: ,X_MSG_DATA => X_MSG_DATA
748: ,X_RETURN_STATUS => X_RETURN_STATUS);
749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 750: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

746: ,X_MSG_COUNT => X_MSG_COUNT
747: ,X_MSG_DATA => X_MSG_DATA
748: ,X_RETURN_STATUS => X_RETURN_STATUS);
749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
750: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
751: P_API_NAME => L_API_NAME
752: ,P_PKG_NAME => G_PKG_NAME
753: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
754: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 754: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

750: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
751: P_API_NAME => L_API_NAME
752: ,P_PKG_NAME => G_PKG_NAME
753: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
754: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
755: ,X_MSG_COUNT => X_MSG_COUNT
756: ,X_MSG_DATA => X_MSG_DATA
757: ,X_RETURN_STATUS => X_RETURN_STATUS);
758: WHEN OTHERS THEN

Line 1044: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1040: --for debugging purpose
1041: -- x_msg_data := l_msg_data;
1042:
1043: WHEN FND_API.G_EXC_ERROR THEN
1044: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1045: P_API_NAME => L_API_NAME
1046: ,P_PKG_NAME => G_PKG_NAME
1047: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1048: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 1048: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

1044: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1045: P_API_NAME => L_API_NAME
1046: ,P_PKG_NAME => G_PKG_NAME
1047: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1048: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1049: ,X_MSG_COUNT => X_MSG_COUNT
1050: ,X_MSG_DATA => X_MSG_DATA
1051: ,X_RETURN_STATUS => X_RETURN_STATUS);
1052:

Line 1054: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1050: ,X_MSG_DATA => X_MSG_DATA
1051: ,X_RETURN_STATUS => X_RETURN_STATUS);
1052:
1053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1054: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1055: P_API_NAME => L_API_NAME
1056: ,P_PKG_NAME => G_PKG_NAME
1057: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1058: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 1058: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

1054: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1055: P_API_NAME => L_API_NAME
1056: ,P_PKG_NAME => G_PKG_NAME
1057: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1058: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1059: ,X_MSG_COUNT => X_MSG_COUNT
1060: ,X_MSG_DATA => X_MSG_DATA
1061: ,X_RETURN_STATUS => X_RETURN_STATUS);
1062: