APPS.IGF_SE_PAYMENT_PUB dependencies on FND_API

Line 32: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

28: /** main procedure create_payment
29: *
30: */
31: PROCEDURE create_payment(
32: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
33: p_payment_rec IN payment_rec_type,
34: x_transaction_id OUT NOCOPY NUMBER,
35: x_return_status OUT NOCOPY VARCHAR2,
36: x_msg_count OUT NOCOPY NUMBER,

Line 45: IF FND_API.to_Boolean(p_init_msg_list) THEN

41: -- establish standard save point
42: SAVEPOINT create_payment;
43:
44: -- initialize message list if p_init_msg_list is set to TRUE.
45: IF FND_API.to_Boolean(p_init_msg_list) THEN
46: FND_MSG_PUB.initialize;
47: END IF;
48:
49: -- initialize API return status to success.

Line 50: x_return_status := FND_API.G_RET_STS_SUCCESS;

46: FND_MSG_PUB.initialize;
47: END IF;
48:
49: -- initialize API return status to success.
50: x_return_status := FND_API.G_RET_STS_SUCCESS;
51:
52: -- call local procedure to create the payment record
53: do_create_payment(p_payment_record => p_payment_rec,
54: x_transaction_id => x_transaction_id,

Line 57: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN

53: do_create_payment(p_payment_record => p_payment_rec,
54: x_transaction_id => x_transaction_id,
55: x_return_status => x_return_status);
56:
57: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
58: RAISE FND_API.G_EXC_ERROR;
59: END IF;
60:
61:

Line 58: RAISE FND_API.G_EXC_ERROR;

54: x_transaction_id => x_transaction_id,
55: x_return_status => x_return_status);
56:
57: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
58: RAISE FND_API.G_EXC_ERROR;
59: END IF;
60:
61:
62: EXCEPTION

Line 63: WHEN FND_API.G_EXC_ERROR THEN

59: END IF;
60:
61:
62: EXCEPTION
63: WHEN FND_API.G_EXC_ERROR THEN
64: ROLLBACK TO create_payment;
65:
66: x_return_status := FND_API.G_RET_STS_ERROR;
67:

Line 66: x_return_status := FND_API.G_RET_STS_ERROR;

62: EXCEPTION
63: WHEN FND_API.G_EXC_ERROR THEN
64: ROLLBACK TO create_payment;
65:
66: x_return_status := FND_API.G_RET_STS_ERROR;
67:
68: fnd_msg_pub.count_and_get(
69: p_encoded => fnd_api.g_false,
70: p_count => x_msg_count,

Line 69: p_encoded => fnd_api.g_false,

65:
66: x_return_status := FND_API.G_RET_STS_ERROR;
67:
68: fnd_msg_pub.count_and_get(
69: p_encoded => fnd_api.g_false,
70: p_count => x_msg_count,
71: p_data => x_msg_data);
72:
73: WHEN OTHERS THEN

Line 76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

72:
73: WHEN OTHERS THEN
74: ROLLBACK TO create_payment;
75:
76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
77:
78: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
79: fnd_message.set_token('NAME','IGF_SE_PAYMENT_PUB '||SQLERRM);
80: fnd_msg_pub.add;

Line 83: p_encoded => fnd_api.g_false,

79: fnd_message.set_token('NAME','IGF_SE_PAYMENT_PUB '||SQLERRM);
80: fnd_msg_pub.add;
81:
82: fnd_msg_pub.count_and_get(
83: p_encoded => fnd_api.g_false,
84: p_count => x_msg_count,
85: p_data => x_msg_data);
86:
87: END create_payment;

Line 137: RAISE FND_API.G_EXC_ERROR;

133: -- and not in the tbh as payroll id from ui is not mandatory
134: IF(p_payment_record.payroll_id IS NULL)THEN
135: fnd_message.set_name('IGF','IGF_SE_PAYROLL_ID_NULL');
136: fnd_msg_pub.add;
137: RAISE FND_API.G_EXC_ERROR;
138: END IF;
139:
140: -- check if the payroll id is already existing in the system, if so,
141: -- that payment information record should be updated, else a new payment

Line 183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

179: x_mode => 'R'
180: );
181: IF(l_transaction_id IS NULL)THEN
182:
183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
184: ELSE
185: x_transaction_id := l_transaction_id;
186: x_return_status := FND_API.G_RET_STS_SUCCESS;
187: END IF; -- end for transaction id is null condition

Line 186: x_return_status := FND_API.G_RET_STS_SUCCESS;

182:
183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
184: ELSE
185: x_transaction_id := l_transaction_id;
186: x_return_status := FND_API.G_RET_STS_SUCCESS;
187: END IF; -- end for transaction id is null condition
188: ELSE
189: fnd_message.set_name('IGF','IGF_SE_NO_VALID_FUND');
190:

Line 197: x_return_status := FND_API.G_RET_STS_ERROR;

193: FETCH c_pers_num INTO l_pers_num;
194: CLOSE c_pers_num;
195: fnd_message.set_token('PERSON_NUM',l_pers_num);
196: fnd_msg_pub.add;
197: x_return_status := FND_API.G_RET_STS_ERROR;
198: RAISE FND_API.G_EXC_ERROR;
199: END IF;
200: END IF; -- end of payroll exists check
201: END do_create_payment;

Line 198: RAISE FND_API.G_EXC_ERROR;

194: CLOSE c_pers_num;
195: fnd_message.set_token('PERSON_NUM',l_pers_num);
196: fnd_msg_pub.add;
197: x_return_status := FND_API.G_RET_STS_ERROR;
198: RAISE FND_API.G_EXC_ERROR;
199: END IF;
200: END IF; -- end of payroll exists check
201: END do_create_payment;
202: