APPS.PON_EMD_VALIDATION_PKG dependencies on FND_API

Line 76: x_return_status := FND_API.G_RET_STS_SUCCESS; -- 'S'

72: END IF; --l_proc_level>=l_dbg_level
73:
74: -- initializilation of variables
75: l_card_number := p_card_number;
76: x_return_status := FND_API.G_RET_STS_SUCCESS; -- 'S'
77:
78: -- Standard call to check for call compatibility.
79: IF NOT FND_API.Compatible_API_Call(l_api_version,
80: p_api_version,

Line 79: IF NOT FND_API.Compatible_API_Call(l_api_version,

75: l_card_number := p_card_number;
76: x_return_status := FND_API.G_RET_STS_SUCCESS; -- 'S'
77:
78: -- Standard call to check for call compatibility.
79: IF NOT FND_API.Compatible_API_Call(l_api_version,
80: p_api_version,
81: l_api_name,
82: l_api_name) THEN
83: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 83: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

79: IF NOT FND_API.Compatible_API_Call(l_api_version,
80: p_api_version,
81: l_api_name,
82: l_api_name) THEN
83: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
84: END IF;
85:
86: -- Initialize message list if p_init_msg_list is set to TRUE.
87: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 87: IF FND_API.to_Boolean(p_init_msg_list) THEN

83: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
84: END IF;
85:
86: -- Initialize message list if p_init_msg_list is set to TRUE.
87: IF FND_API.to_Boolean(p_init_msg_list) THEN
88: FND_MSG_PUB.initialize();
89: END IF;
90:
91: -- Start credit card number validation

Line 93: x_return_status := FND_API.G_RET_STS_ERROR; -- 'E'

89: END IF;
90:
91: -- Start credit card number validation
92: IF (l_card_number IS NULL) THEN
93: x_return_status := FND_API.G_RET_STS_ERROR; -- 'E'
94: RETURN;
95: END IF;
96:
97: -- using the same logic as iby package to validate the format of CCNumber

Line 99: FND_API.G_FALSE,

95: END IF;
96:
97: -- using the same logic as iby package to validate the format of CCNumber
98: iby_cc_validate.StripCC(p_api_version,
99: FND_API.G_FALSE,
100: l_card_number,
101: lx_return_status,
102: lx_msg_count,
103: lx_msg_data,

Line 107: (lx_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN

103: lx_msg_data,
104: lx_cc_number);
105:
106: IF ((lx_cc_number IS NULL) OR
107: (lx_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
108: x_return_status := FND_API.G_RET_STS_ERROR; -- 'E'
109: RETURN;
110: END IF;
111:

Line 108: x_return_status := FND_API.G_RET_STS_ERROR; -- 'E'

104: lx_cc_number);
105:
106: IF ((lx_cc_number IS NULL) OR
107: (lx_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
108: x_return_status := FND_API.G_RET_STS_ERROR; -- 'E'
109: RETURN;
110: END IF;
111:
112: iby_cc_validate.Get_CC_Issuer_Range(lx_cc_number,

Line 120: x_return_status := FND_API.G_RET_STS_ERROR; -- 'E'

116: lx_digit_check);
117:
118: IF (lx_digit_check = 'Y') THEN
119: IF (MOD(iby_cc_validate.CheckCCDigits(lx_cc_number), 10) <> 0) THEN
120: x_return_status := FND_API.G_RET_STS_ERROR; -- 'E'
121: RETURN;
122: END IF; -- MOD(iby_cc_validate.CheckCCDigits(lx_cc_number),10) <> 0
123: END IF; -- lx_digit_check = 'Y'
124:

Line 188: x_return_status := FND_API.G_RET_STS_SUCCESS;

184: g_module_prefix || '.' || l_api_name || '.begin',
185: 'Enter procedure');
186: END IF; -- (l_proc_level>=l_dbg_level)
187:
188: x_return_status := FND_API.G_RET_STS_SUCCESS;
189:
190: BEGIN
191: SELECT Max(acr.cash_receipt_id), Max(arp.receivable_application_id)
192: INTO x_cash_receipt_id, x_receivable_app_id

Line 210: x_return_status := FND_API.G_RET_STS_ERROR;

206: AND arp.amount_applied > 0;
207: EXCEPTION
208: WHEN NO_DATA_FOUND THEN
209:
210: x_return_status := FND_API.G_RET_STS_ERROR;
211: FND_MESSAGE.SET_NAME('PON', 'RECEIPT_NOT_CRE_FOR_DEPOSIT');
212: FND_MESSAGE.SET_TOKEN('DEPOSIT_TRX_NUM', p_trx_number);
213: FND_MSG_PUB.ADD;
214: x_receipt_num := NULL;

Line 225: x_return_status := FND_API.G_RET_STS_ERROR;

221: Sqlcode || Sqlerrm);
222: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
223: RETURN;
224: WHEN TOO_MANY_ROWS THEN
225: x_return_status := FND_API.G_RET_STS_ERROR;
226: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
227: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
228: g_module_prefix || '.' || l_api_name ||
229: '.TOO_MANY_ROWS_Exception ',

Line 245: x_return_status := FND_API.G_RET_STS_ERROR;

241: AND acrh.current_record_flag = 'Y'
242: AND acr.cash_receipt_id = x_cash_receipt_id;
243: EXCEPTION
244: WHEN NO_DATA_FOUND THEN
245: x_return_status := FND_API.G_RET_STS_ERROR;
246: FND_MESSAGE.SET_NAME('PON', 'RECEIPT_NOT_CLEARED');
247: FND_MESSAGE.SET_TOKEN('DEPOSIT_TRX_NUM', p_trx_number);
248: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM', x_receipt_num);
249: FND_MSG_PUB.ADD;

Line 262: x_return_status := FND_API.G_RET_STS_ERROR;

258: Sqlcode || Sqlerrm);
259: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
260: RETURN;
261: WHEN TOO_MANY_ROWS THEN
262: x_return_status := FND_API.G_RET_STS_ERROR;
263: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
264: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
265: g_module_prefix || '.' || l_api_name ||
266: '.TOO_MANY_ROWS_Exception ',

Line 280: x_return_status := FND_API.G_RET_STS_ERROR;

276: 'Exit procedure');
277: END IF; -- (l_proc_level>=l_dbg_level)
278: EXCEPTION
279: WHEN NO_DATA_FOUND THEN
280: x_return_status := FND_API.G_RET_STS_ERROR;
281: x_receipt_num := NULL;
282: x_cash_receipt_id := NULL;
283: x_receipt_status := NULL;
284: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 291: x_return_status := FND_API.G_RET_STS_ERROR;

287: '.NO_DATA_FOUND_Exception ',
288: Sqlcode || Sqlerrm);
289: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
290: WHEN TOO_MANY_ROWS THEN
291: x_return_status := FND_API.G_RET_STS_ERROR;
292: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
293: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
294: g_module_prefix || '.' || l_api_name ||
295: '.TOO_MANY_ROWS_Exception ',