APPS.QP_LIMIT_TRANSACTIONS_PVT dependencies on FND_API

Line 76: IF l_debug = FND_API.G_TRUE THEN

72: ))); --bug#10130826;
73:
74: BEGIN
75: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
76: IF l_debug = FND_API.G_TRUE THEN
77: QP_PREQ_GRP.engine_debug('***Begin Procedure Delete*** ');
78: QP_PREQ_GRP.engine_debug('***Begin Procedure Delete***: price_event: '|| p_pricing_event_code);
79:
80: for cl in (select line.line_index, line.price_request_code, trx.list_header_id, trx.pricing_phase_id

Line 98: x_return_status := FND_API.G_RET_STS_SUCCESS;

94: END LOOP;
95: END LOOP;
96:
97: END IF;
98: x_return_status := FND_API.G_RET_STS_SUCCESS;
99:
100: FOR l_rec IN limit_trans_cur(p_pricing_event_code)
101: LOOP
102: IF l_debug = FND_API.G_TRUE THEN

Line 102: IF l_debug = FND_API.G_TRUE THEN

98: x_return_status := FND_API.G_RET_STS_SUCCESS;
99:
100: FOR l_rec IN limit_trans_cur(p_pricing_event_code)
101: LOOP
102: IF l_debug = FND_API.G_TRUE THEN
103: QP_PREQ_GRP.engine_debug('***Deleting LimitbalanceId: '||l_rec.limit_balance_id||' pricereqcode '||l_rec.price_request_code);
104: END IF;
105:
106: --For each transaction record selected in the cursor increment the

Line 126: IF l_debug = FND_API.G_TRUE THEN

122: AND price_request_code = l_rec.price_request_code;
123:
124: END LOOP; --Loop over records in limit_trans_cur
125:
126: IF l_debug = FND_API.G_TRUE THEN
127: QP_PREQ_GRP.engine_debug('***End Procedure Delete*** ');
128:
129: END IF;
130: EXCEPTION

Line 131: WHEN FND_API.G_EXC_ERROR THEN

127: QP_PREQ_GRP.engine_debug('***End Procedure Delete*** ');
128:
129: END IF;
130: EXCEPTION
131: WHEN FND_API.G_EXC_ERROR THEN
132:
133: x_return_status := FND_API.G_RET_STS_ERROR;
134:
135: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 133: x_return_status := FND_API.G_RET_STS_ERROR;

129: END IF;
130: EXCEPTION
131: WHEN FND_API.G_EXC_ERROR THEN
132:
133: x_return_status := FND_API.G_RET_STS_ERROR;
134:
135: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
136: THEN
137: FND_MESSAGE.SET_NAME('QP','QP_INVALID_FORMULA');

Line 142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

138: END IF;
139:
140: -- RAISE;
141:
142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
143:
144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
145:
146: -- RAISE;

Line 144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

140: -- RAISE;
141:
142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
143:
144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
145:
146: -- RAISE;
147:
148: WHEN OTHERS THEN

Line 149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

145:
146: -- RAISE;
147:
148: WHEN OTHERS THEN
149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
150:
151: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
152: THEN
153: FND_MSG_PUB.Add_Exc_Msg

Line 159: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

155: , 'Check Balance'
156: );
157: END IF;
158:
159: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
160:
161: END Delete;
162:
163: END QP_LIMIT_TRANSACTIONS_PVT;