49: END IF;
50:
51:
52: -- Initializing Global Debug Variable.
53: aso_debug_pub.g_debug_flag := NVL(FND_PROFILE.VALUE('ASO_ENABLE_DEBUG'),'N');
54:
55: -- Initialize API return status to SUCCESS
56: x_return_status := FND_API.G_RET_STS_SUCCESS;
57:
62: -- call user hooks - Pre processing
63:
64: -- customer pre processing
65:
66: IF aso_debug_pub.g_debug_flag = 'Y' THEN
67: aso_debug_pub.add('Credit_Check_CUHK: Before Customer Pre Hook................. ', 1, 'Y');
68: END IF;
69:
70: IF (JTF_USR_HKS.ok_to_execute(G_PKG_NAME, l_api_name, 'B', 'C')) THEN
63:
64: -- customer pre processing
65:
66: IF aso_debug_pub.g_debug_flag = 'Y' THEN
67: aso_debug_pub.add('Credit_Check_CUHK: Before Customer Pre Hook................. ', 1, 'Y');
68: END IF;
69:
70: IF (JTF_USR_HKS.ok_to_execute(G_PKG_NAME, l_api_name, 'B', 'C')) THEN
71: ASO_CREDIT_CHECK_CUHK.credit_check_PRE(
76: X_RETURN_STATUS => x_return_status,
77: X_MSG_COUNT => x_msg_count,
78: X_MSG_DATA => x_msg_data
79: );
80: IF aso_debug_pub.g_debug_flag = 'Y' THEN
81: aso_debug_pub.add('Credit_Check_CUHK: after CREDIT_CHECK_CUHK Pre hook return_status: '||x_return_status, 1, 'Y');
82: END IF;
83:
84: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
77: X_MSG_COUNT => x_msg_count,
78: X_MSG_DATA => x_msg_data
79: );
80: IF aso_debug_pub.g_debug_flag = 'Y' THEN
81: aso_debug_pub.add('Credit_Check_CUHK: after CREDIT_CHECK_CUHK Pre hook return_status: '||x_return_status, 1, 'Y');
82: END IF;
83:
84: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
85: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
96: END IF;
97: END IF; -- customer hook
98:
99: -- vertical pre hook
100: IF aso_debug_pub.g_debug_flag = 'Y' THEN
101: aso_debug_pub.add('Credit_Check_VUHK: Before Vertical Pre Hook................. ', 1, 'Y');
102: END IF;
103:
104: IF (JTF_USR_HKS.ok_to_execute(G_PKG_NAME, l_api_name, 'B', 'V')) THEN
97: END IF; -- customer hook
98:
99: -- vertical pre hook
100: IF aso_debug_pub.g_debug_flag = 'Y' THEN
101: aso_debug_pub.add('Credit_Check_VUHK: Before Vertical Pre Hook................. ', 1, 'Y');
102: END IF;
103:
104: IF (JTF_USR_HKS.ok_to_execute(G_PKG_NAME, l_api_name, 'B', 'V')) THEN
105: ASO_CREDIT_CHECK_VUHK.Credit_Check_PRE(
110: X_RETURN_STATUS => x_return_status,
111: X_MSG_COUNT => x_msg_count,
112: X_MSG_DATA => x_msg_data
113: );
114: IF aso_debug_pub.g_debug_flag = 'Y' THEN
115: aso_debug_pub.add('Credit_Check_VUHK: after CREDIT_CHECK_VUHK Pre hook return_status: '||x_return_status, 1, 'Y');
116: END IF;
117:
118: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
111: X_MSG_COUNT => x_msg_count,
112: X_MSG_DATA => x_msg_data
113: );
114: IF aso_debug_pub.g_debug_flag = 'Y' THEN
115: aso_debug_pub.add('Credit_Check_VUHK: after CREDIT_CHECK_VUHK Pre hook return_status: '||x_return_status, 1, 'Y');
116: END IF;
117:
118: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
119: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
130: END IF;
131: END IF;
132:
133: -- Public API Call.
134: IF aso_debug_pub.g_debug_flag = 'Y' THEN
135: aso_debug_pub.add('Credit_Check_PUB: Before CREDIT_CHECK................. ', 1, 'Y');
136: END IF;
137:
138: ASO_CREDIT_CHECK_PVT.CREDIT_CHECK(
131: END IF;
132:
133: -- Public API Call.
134: IF aso_debug_pub.g_debug_flag = 'Y' THEN
135: aso_debug_pub.add('Credit_Check_PUB: Before CREDIT_CHECK................. ', 1, 'Y');
136: END IF;
137:
138: ASO_CREDIT_CHECK_PVT.CREDIT_CHECK(
139: P_API_VERSION => 1.0,
146: X_MSG_COUNT => x_msg_count,
147: X_MSG_DATA => x_msg_data
148: );
149:
150: IF aso_debug_pub.g_debug_flag = 'Y' THEN
151: aso_debug_pub.add('Credit_Check_PUB: after CREDIT_CHECK return_status: '||x_return_status, 1, 'Y');
152: END IF;
153:
154: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
147: X_MSG_DATA => x_msg_data
148: );
149:
150: IF aso_debug_pub.g_debug_flag = 'Y' THEN
151: aso_debug_pub.add('Credit_Check_PUB: after CREDIT_CHECK return_status: '||x_return_status, 1, 'Y');
152: END IF;
153:
154: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
159:
160: -- call user hooks - Post Processing.
161:
162: -- customer post processing
163: IF aso_debug_pub.g_debug_flag = 'Y' THEN
164: aso_debug_pub.add('Credit_Check_CUHK: Before Customer Post Hook................. ', 1, 'Y');
165: END IF;
166:
167: IF (JTF_USR_HKS.ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'C')) THEN
160: -- call user hooks - Post Processing.
161:
162: -- customer post processing
163: IF aso_debug_pub.g_debug_flag = 'Y' THEN
164: aso_debug_pub.add('Credit_Check_CUHK: Before Customer Post Hook................. ', 1, 'Y');
165: END IF;
166:
167: IF (JTF_USR_HKS.ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'C')) THEN
168: ASO_CREDIT_CHECK_CUHK.Credit_Check_POST(
175: X_RETURN_STATUS => x_return_status,
176: X_MSG_COUNT => x_msg_count,
177: X_MSG_DATA => x_msg_data
178: );
179: IF aso_debug_pub.g_debug_flag = 'Y' THEN
180: aso_debug_pub.add('Credit_Check_CUHK: after CREDIT_CHECK_CUHK Post hook return_status: '||x_return_status, 1, 'Y');
181: END IF;
182:
183: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
176: X_MSG_COUNT => x_msg_count,
177: X_MSG_DATA => x_msg_data
178: );
179: IF aso_debug_pub.g_debug_flag = 'Y' THEN
180: aso_debug_pub.add('Credit_Check_CUHK: after CREDIT_CHECK_CUHK Post hook return_status: '||x_return_status, 1, 'Y');
181: END IF;
182:
183: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
184: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
196: END IF; -- customer hook
197:
198: -- vertical post hook
199:
200: IF aso_debug_pub.g_debug_flag = 'Y' THEN
201: aso_debug_pub.add('Credit_Check_VUHK: Before Vertical Post Hook................. ', 1, 'Y');
202: END IF;
203:
204: IF (JTF_USR_HKS.ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'V')) THEN
197:
198: -- vertical post hook
199:
200: IF aso_debug_pub.g_debug_flag = 'Y' THEN
201: aso_debug_pub.add('Credit_Check_VUHK: Before Vertical Post Hook................. ', 1, 'Y');
202: END IF;
203:
204: IF (JTF_USR_HKS.ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'V')) THEN
205: ASO_CREDIT_CHECK_VUHK.Credit_check_POST(
212: X_RETURN_STATUS => x_return_status,
213: X_MSG_COUNT => x_msg_count,
214: X_MSG_DATA => x_msg_data
215: );
216: IF aso_debug_pub.g_debug_flag = 'Y' THEN
217: aso_debug_pub.add('Credit_Check_VUHK: after CREDIT_CHECK_VUHK Post hook return_status: '||x_return_status, 1, 'Y');
218: END IF;
219: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
220: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
213: X_MSG_COUNT => x_msg_count,
214: X_MSG_DATA => x_msg_data
215: );
216: IF aso_debug_pub.g_debug_flag = 'Y' THEN
217: aso_debug_pub.add('Credit_Check_VUHK: after CREDIT_CHECK_VUHK Post hook return_status: '||x_return_status, 1, 'Y');
218: END IF;
219: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
220: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
221: FND_MESSAGE.Set_Name('ASO', 'ASO_ERROR_RETURNED');