APPS.QP_LIMIT_TRANSACTIONS_PVT dependencies on FND_API

Line 69: IF l_debug = FND_API.G_TRUE THEN

65: AND l.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW);
66:
67: BEGIN
68: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
69: IF l_debug = FND_API.G_TRUE THEN
70: QP_PREQ_GRP.engine_debug('***Begin Procedure Delete*** ');
71: QP_PREQ_GRP.engine_debug('***Begin Procedure Delete***: price_event: '|| p_pricing_event_code);
72:
73: for cl in (select line.line_index, line.price_request_code, trx.list_header_id, trx.pricing_phase_id

Line 91: x_return_status := FND_API.G_RET_STS_SUCCESS;

87: END LOOP;
88: END LOOP;
89:
90: END IF;
91: x_return_status := FND_API.G_RET_STS_SUCCESS;
92:
93: FOR l_rec IN limit_trans_cur(p_pricing_event_code)
94: LOOP
95: IF l_debug = FND_API.G_TRUE THEN

Line 95: IF l_debug = FND_API.G_TRUE THEN

91: x_return_status := FND_API.G_RET_STS_SUCCESS;
92:
93: FOR l_rec IN limit_trans_cur(p_pricing_event_code)
94: LOOP
95: IF l_debug = FND_API.G_TRUE THEN
96: QP_PREQ_GRP.engine_debug('***Deleting LimitbalanceId: '||l_rec.limit_balance_id||' pricereqcode '||l_rec.price_request_code);
97: END IF;
98:
99: --For each transaction record selected in the cursor increment the

Line 119: IF l_debug = FND_API.G_TRUE THEN

115: AND price_request_code = l_rec.price_request_code;
116:
117: END LOOP; --Loop over records in limit_trans_cur
118:
119: IF l_debug = FND_API.G_TRUE THEN
120: QP_PREQ_GRP.engine_debug('***End Procedure Delete*** ');
121:
122: END IF;
123: EXCEPTION

Line 124: WHEN FND_API.G_EXC_ERROR THEN

120: QP_PREQ_GRP.engine_debug('***End Procedure Delete*** ');
121:
122: END IF;
123: EXCEPTION
124: WHEN FND_API.G_EXC_ERROR THEN
125:
126: x_return_status := FND_API.G_RET_STS_ERROR;
127:
128: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 126: x_return_status := FND_API.G_RET_STS_ERROR;

122: END IF;
123: EXCEPTION
124: WHEN FND_API.G_EXC_ERROR THEN
125:
126: x_return_status := FND_API.G_RET_STS_ERROR;
127:
128: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
129: THEN
130: FND_MESSAGE.SET_NAME('QP','QP_INVALID_FORMULA');

Line 135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

131: END IF;
132:
133: -- RAISE;
134:
135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
136:
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
138:
139: -- RAISE;

Line 137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

133: -- RAISE;
134:
135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
136:
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
138:
139: -- RAISE;
140:
141: WHEN OTHERS THEN

Line 142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

138:
139: -- RAISE;
140:
141: WHEN OTHERS THEN
142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
143:
144: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
145: THEN
146: FND_MSG_PUB.Add_Exc_Msg

Line 152: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

148: , 'Check Balance'
149: );
150: END IF;
151:
152: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
153:
154: END Delete;
155:
156: END QP_LIMIT_TRANSACTIONS_PVT;