eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_RESALE_PVT dependencies on FND_API

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

32: -- NOTES
33: ---------------------------------------------------------------------
34: PROCEDURE Initiate_Payment (
35: p_api_version IN NUMBER
36: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
37: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
38: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
39: ,p_resale_batch_id IN NUMBER
40: ,x_return_status OUT NOCOPY VARCHAR2

Line 37: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

33: ---------------------------------------------------------------------
34: PROCEDURE Initiate_Payment (
35: p_api_version IN NUMBER
36: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
37: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
38: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
39: ,p_resale_batch_id IN NUMBER
40: ,x_return_status OUT NOCOPY VARCHAR2
41: ,x_msg_data OUT NOCOPY VARCHAR2

Line 38: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

34: PROCEDURE Initiate_Payment (
35: p_api_version IN NUMBER
36: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
37: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
38: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
39: ,p_resale_batch_id IN NUMBER
40: ,x_return_status OUT NOCOPY VARCHAR2
41: ,x_msg_data OUT NOCOPY VARCHAR2
42: ,x_msg_count OUT NOCOPY NUMBER

Line 59: IF NOT FND_API.Compatible_API_Call (

55: BEGIN
56: -- Standard begin of API savepoint
57: SAVEPOINT INITIATE_PAYMENT;
58: -- Standard call to check for call compatibility.
59: IF NOT FND_API.Compatible_API_Call (
60: l_api_version,
61: p_api_version,
62: l_api_name,
63: G_PKG_NAME)

Line 65: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

61: p_api_version,
62: l_api_name,
63: G_PKG_NAME)
64: THEN
65: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
66: END IF;
67:
68: -- Debug Message
69: IF OZF_DEBUG_HIGH_ON THEN

Line 74: IF FND_API.To_Boolean (p_init_msg_list) THEN

70: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': Start');
71: END IF;
72:
73: --Initialize message list if p_init_msg_list is TRUE.
74: IF FND_API.To_Boolean (p_init_msg_list) THEN
75: FND_MSG_PUB.initialize;
76: END IF;
77:
78: -- Initialize API return status to sucess

Line 79: x_return_status := FND_API.G_RET_STS_SUCCESS;

75: FND_MSG_PUB.initialize;
76: END IF;
77:
78: -- Initialize API return status to sucess
79: x_return_status := FND_API.G_RET_STS_SUCCESS;
80:
81: OPEN g_org_id_csr (p_resale_batch_id);
82: FETCH g_org_id_csr into l_org_id;
83: CLOSE g_org_id_csr;

Line 89: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

85: IF l_org_id is not null THEN
86: fnd_client_info.set_org_context(to_char(l_org_id));
87: ELSE
88: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_ORG_ID_NOTFOUND');
89: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
90: END IF;
91:
92: OPEN OZF_RESALE_COMMON_PVT.g_batch_type_csr(p_resale_batch_id);
93: FETCH OZF_RESALE_COMMON_PVT.g_batch_type_csr into l_batch_type;

Line 98: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

94: CLOSE OZF_RESALE_COMMON_PVT.g_batch_type_csr;
95:
96: IF l_batch_type is null THEN
97: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_BATCH_TYPE_NULL');
98: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
99: END IF;
100:
101: IF l_batch_type = OZF_RESALE_COMMON_PVT.G_CHARGEBACK THEN
102:

Line 105: ,p_init_msg_list => FND_API.G_FALSE

101: IF l_batch_type = OZF_RESALE_COMMON_PVT.G_CHARGEBACK THEN
102:
103: OZF_CHARGEBACK_PVT.Initiate_Payment(
104: p_api_version => 1
105: ,p_init_msg_list => FND_API.G_FALSE
106: ,p_commit => FND_API.G_FALSE
107: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL
108: ,p_resale_batch_id => p_resale_batch_id
109: ,x_return_status => l_return_status

Line 106: ,p_commit => FND_API.G_FALSE

102:
103: OZF_CHARGEBACK_PVT.Initiate_Payment(
104: p_api_version => 1
105: ,p_init_msg_list => FND_API.G_FALSE
106: ,p_commit => FND_API.G_FALSE
107: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL
108: ,p_resale_batch_id => p_resale_batch_id
109: ,x_return_status => l_return_status
110: ,x_msg_data => l_msg_data

Line 107: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL

103: OZF_CHARGEBACK_PVT.Initiate_Payment(
104: p_api_version => 1
105: ,p_init_msg_list => FND_API.G_FALSE
106: ,p_commit => FND_API.G_FALSE
107: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL
108: ,p_resale_batch_id => p_resale_batch_id
109: ,x_return_status => l_return_status
110: ,x_msg_data => l_msg_data
111: ,x_msg_count => l_msg_count

Line 114: IF l_return_status = FND_API.g_ret_sts_error THEN

110: ,x_msg_data => l_msg_data
111: ,x_msg_count => l_msg_count
112: );
113:
114: IF l_return_status = FND_API.g_ret_sts_error THEN
115: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_CHBK_PAYMNT_ERR');
116: RAISE FND_API.g_exc_error;
117: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
118: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_CHBK_PAYMNT_ERR');

Line 116: RAISE FND_API.g_exc_error;

112: );
113:
114: IF l_return_status = FND_API.g_ret_sts_error THEN
115: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_CHBK_PAYMNT_ERR');
116: RAISE FND_API.g_exc_error;
117: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
118: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_CHBK_PAYMNT_ERR');
119: RAISE FND_API.g_exc_unexpected_error;
120: END IF;

Line 117: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

113:
114: IF l_return_status = FND_API.g_ret_sts_error THEN
115: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_CHBK_PAYMNT_ERR');
116: RAISE FND_API.g_exc_error;
117: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
118: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_CHBK_PAYMNT_ERR');
119: RAISE FND_API.g_exc_unexpected_error;
120: END IF;
121: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_SPECIAL_PRICING THEN

Line 119: RAISE FND_API.g_exc_unexpected_error;

115: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_CHBK_PAYMNT_ERR');
116: RAISE FND_API.g_exc_error;
117: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
118: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_CHBK_PAYMNT_ERR');
119: RAISE FND_API.g_exc_unexpected_error;
120: END IF;
121: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_SPECIAL_PRICING THEN
122:
123: OZF_SPECIAL_PRICING_PVT.Initiate_Payment(

Line 125: ,p_init_msg_list => FND_API.G_FALSE

121: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_SPECIAL_PRICING THEN
122:
123: OZF_SPECIAL_PRICING_PVT.Initiate_Payment(
124: p_api_version => 1
125: ,p_init_msg_list => FND_API.G_FALSE
126: ,p_commit => FND_API.G_FALSE
127: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL
128: ,p_resale_batch_id => p_resale_batch_id
129: ,x_return_status => l_return_status

Line 126: ,p_commit => FND_API.G_FALSE

122:
123: OZF_SPECIAL_PRICING_PVT.Initiate_Payment(
124: p_api_version => 1
125: ,p_init_msg_list => FND_API.G_FALSE
126: ,p_commit => FND_API.G_FALSE
127: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL
128: ,p_resale_batch_id => p_resale_batch_id
129: ,x_return_status => l_return_status
130: ,x_msg_data => l_msg_data

Line 127: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL

123: OZF_SPECIAL_PRICING_PVT.Initiate_Payment(
124: p_api_version => 1
125: ,p_init_msg_list => FND_API.G_FALSE
126: ,p_commit => FND_API.G_FALSE
127: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL
128: ,p_resale_batch_id => p_resale_batch_id
129: ,x_return_status => l_return_status
130: ,x_msg_data => l_msg_data
131: ,x_msg_count => l_msg_count

Line 134: IF l_return_status = FND_API.g_ret_sts_error THEN

130: ,x_msg_data => l_msg_data
131: ,x_msg_count => l_msg_count
132: );
133:
134: IF l_return_status = FND_API.g_ret_sts_error THEN
135: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_SPP_PAYMNT_ERR');
136: RAISE FND_API.g_exc_error;
137: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
138: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_SPP_PAYMNT_ERR');

Line 136: RAISE FND_API.g_exc_error;

132: );
133:
134: IF l_return_status = FND_API.g_ret_sts_error THEN
135: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_SPP_PAYMNT_ERR');
136: RAISE FND_API.g_exc_error;
137: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
138: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_SPP_PAYMNT_ERR');
139: RAISE FND_API.g_exc_unexpected_error;
140: END IF;

Line 137: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

133:
134: IF l_return_status = FND_API.g_ret_sts_error THEN
135: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_SPP_PAYMNT_ERR');
136: RAISE FND_API.g_exc_error;
137: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
138: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_SPP_PAYMNT_ERR');
139: RAISE FND_API.g_exc_unexpected_error;
140: END IF;
141: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_TRACING THEN

Line 139: RAISE FND_API.g_exc_unexpected_error;

135: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_SPP_PAYMNT_ERR');
136: RAISE FND_API.g_exc_error;
137: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
138: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_SPP_PAYMNT_ERR');
139: RAISE FND_API.g_exc_unexpected_error;
140: END IF;
141: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_TRACING THEN
142:
143: OZF_TRACING_ORDER_PVT.Initiate_Payment(

Line 145: ,p_init_msg_list => FND_API.G_FALSE

141: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_TRACING THEN
142:
143: OZF_TRACING_ORDER_PVT.Initiate_Payment(
144: p_api_version => 1
145: ,p_init_msg_list => FND_API.G_FALSE
146: ,p_commit => FND_API.G_FALSE
147: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL
148: ,p_resale_batch_id => p_resale_batch_id
149: ,x_return_status => l_return_status

Line 146: ,p_commit => FND_API.G_FALSE

142:
143: OZF_TRACING_ORDER_PVT.Initiate_Payment(
144: p_api_version => 1
145: ,p_init_msg_list => FND_API.G_FALSE
146: ,p_commit => FND_API.G_FALSE
147: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL
148: ,p_resale_batch_id => p_resale_batch_id
149: ,x_return_status => l_return_status
150: ,x_msg_data => l_msg_data

Line 147: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL

143: OZF_TRACING_ORDER_PVT.Initiate_Payment(
144: p_api_version => 1
145: ,p_init_msg_list => FND_API.G_FALSE
146: ,p_commit => FND_API.G_FALSE
147: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL
148: ,p_resale_batch_id => p_resale_batch_id
149: ,x_return_status => l_return_status
150: ,x_msg_data => l_msg_data
151: ,x_msg_count => l_msg_count

Line 154: IF l_return_status = FND_API.g_ret_sts_error THEN

150: ,x_msg_data => l_msg_data
151: ,x_msg_count => l_msg_count
152: );
153:
154: IF l_return_status = FND_API.g_ret_sts_error THEN
155: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_TRAC_PAYMNT_ERR');
156: RAISE FND_API.g_exc_error;
157: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
158: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_TRAC_PAYMNT_ERR');

Line 156: RAISE FND_API.g_exc_error;

152: );
153:
154: IF l_return_status = FND_API.g_ret_sts_error THEN
155: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_TRAC_PAYMNT_ERR');
156: RAISE FND_API.g_exc_error;
157: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
158: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_TRAC_PAYMNT_ERR');
159: RAISE FND_API.g_exc_unexpected_error;
160: END IF;

Line 157: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

153:
154: IF l_return_status = FND_API.g_ret_sts_error THEN
155: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_TRAC_PAYMNT_ERR');
156: RAISE FND_API.g_exc_error;
157: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
158: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_TRAC_PAYMNT_ERR');
159: RAISE FND_API.g_exc_unexpected_error;
160: END IF;
161: END IF;

Line 159: RAISE FND_API.g_exc_unexpected_error;

155: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_TRAC_PAYMNT_ERR');
156: RAISE FND_API.g_exc_error;
157: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
158: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_TRAC_PAYMNT_ERR');
159: RAISE FND_API.g_exc_unexpected_error;
160: END IF;
161: END IF;
162:
163: -- Debug Message

Line 169: p_encoded => FND_API.G_FALSE,

165: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
166: END IF;
167: --Standard call to get message count and if count=1, get the message
168: FND_MSG_PUB.Count_And_Get (
169: p_encoded => FND_API.G_FALSE,
170: p_count => x_msg_count,
171: p_data => x_msg_data
172: );
173: x_return_status := l_return_status;

Line 176: WHEN FND_API.G_EXC_ERROR THEN

172: );
173: x_return_status := l_return_status;
174:
175: EXCEPTION
176: WHEN FND_API.G_EXC_ERROR THEN
177: ROLLBACK TO INITIATE_PAYMENT;
178: x_return_status := FND_API.G_RET_STS_ERROR;
179: -- Standard call to get message count and if count=1, get the message
180: FND_MSG_PUB.Count_And_Get (

Line 178: x_return_status := FND_API.G_RET_STS_ERROR;

174:
175: EXCEPTION
176: WHEN FND_API.G_EXC_ERROR THEN
177: ROLLBACK TO INITIATE_PAYMENT;
178: x_return_status := FND_API.G_RET_STS_ERROR;
179: -- Standard call to get message count and if count=1, get the message
180: FND_MSG_PUB.Count_And_Get (
181: p_encoded => FND_API.G_FALSE,
182: p_count => x_msg_count,

Line 181: p_encoded => FND_API.G_FALSE,

177: ROLLBACK TO INITIATE_PAYMENT;
178: x_return_status := FND_API.G_RET_STS_ERROR;
179: -- Standard call to get message count and if count=1, get the message
180: FND_MSG_PUB.Count_And_Get (
181: p_encoded => FND_API.G_FALSE,
182: p_count => x_msg_count,
183: p_data => x_msg_data
184: );
185: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 185: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

181: p_encoded => FND_API.G_FALSE,
182: p_count => x_msg_count,
183: p_data => x_msg_data
184: );
185: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
186: ROLLBACK TO INITIATE_PAYMENT;
187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
188: -- Standard call to get message count and if count=1, get the message
189: FND_MSG_PUB.Count_And_Get (

Line 187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

183: p_data => x_msg_data
184: );
185: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
186: ROLLBACK TO INITIATE_PAYMENT;
187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
188: -- Standard call to get message count and if count=1, get the message
189: FND_MSG_PUB.Count_And_Get (
190: p_encoded => FND_API.G_FALSE,
191: p_count => x_msg_count,

Line 190: p_encoded => FND_API.G_FALSE,

186: ROLLBACK TO INITIATE_PAYMENT;
187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
188: -- Standard call to get message count and if count=1, get the message
189: FND_MSG_PUB.Count_And_Get (
190: p_encoded => FND_API.G_FALSE,
191: p_count => x_msg_count,
192: p_data => x_msg_data
193: );
194: WHEN OTHERS THEN

Line 196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

192: p_data => x_msg_data
193: );
194: WHEN OTHERS THEN
195: ROLLBACK TO INITIATE_PAYMENT;
196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
197: -- Standard call to get message count and if count=1, get the message
198: FND_MSG_PUB.Count_And_Get (
199: p_encoded => FND_API.G_FALSE,
200: p_count => x_msg_count,

Line 199: p_encoded => FND_API.G_FALSE,

195: ROLLBACK TO INITIATE_PAYMENT;
196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
197: -- Standard call to get message count and if count=1, get the message
198: FND_MSG_PUB.Count_And_Get (
199: p_encoded => FND_API.G_FALSE,
200: p_count => x_msg_count,
201: p_data => x_msg_data
202: );
203: END Initiate_Payment;

Line 246: ,p_init_msg_list => FND_API.G_FALSE

242: itemkey => itemkey,
243: aname => 'RESALE_BATCH_ID');
244: Initiate_Payment (
245: p_api_version => 1.0
246: ,p_init_msg_list => FND_API.G_FALSE
247: ,p_commit => FND_API.G_FALSE
248: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
249: ,p_resale_batch_id => l_resale_batch_id
250: ,x_return_status => l_return_status

Line 247: ,p_commit => FND_API.G_FALSE

243: aname => 'RESALE_BATCH_ID');
244: Initiate_Payment (
245: p_api_version => 1.0
246: ,p_init_msg_list => FND_API.G_FALSE
247: ,p_commit => FND_API.G_FALSE
248: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
249: ,p_resale_batch_id => l_resale_batch_id
250: ,x_return_status => l_return_status
251: ,x_msg_data => l_msg_data

Line 248: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

244: Initiate_Payment (
245: p_api_version => 1.0
246: ,p_init_msg_list => FND_API.G_FALSE
247: ,p_commit => FND_API.G_FALSE
248: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
249: ,p_resale_batch_id => l_resale_batch_id
250: ,x_return_status => l_return_status
251: ,x_msg_data => l_msg_data
252: ,x_msg_count => l_msg_count

Line 257: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

253: );
254: IF OZF_DEBUG_LOW_ON THEN
255: OZF_UTILITY_PVT.debug_message('subscribe process iface is complete ');
256: END IF;
257: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
258: RAISE FND_API.G_EXC_ERROR;
259: END IF;
260: l_resultout := 'COMPLETE:Y';
261: ELSIF (funcmode = 'CANCEL') THEN

Line 258: RAISE FND_API.G_EXC_ERROR;

254: IF OZF_DEBUG_LOW_ON THEN
255: OZF_UTILITY_PVT.debug_message('subscribe process iface is complete ');
256: END IF;
257: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
258: RAISE FND_API.G_EXC_ERROR;
259: END IF;
260: l_resultout := 'COMPLETE:Y';
261: ELSIF (funcmode = 'CANCEL') THEN
262: l_resultout := 'COMPLETE:Y';

Line 272: WHEN FND_API.G_EXC_ERROR THEN

268: l_resultout := 'COMPLETE:Y';
269: END IF;
270: resultout := l_resultout;
271: EXCEPTION
272: WHEN FND_API.G_EXC_ERROR THEN
273: FND_MSG_PUB.count_and_get (
274: p_encoded => FND_API.g_false
275: ,p_count => l_msg_count
276: ,p_data => l_msg_data

Line 274: p_encoded => FND_API.g_false

270: resultout := l_resultout;
271: EXCEPTION
272: WHEN FND_API.G_EXC_ERROR THEN
273: FND_MSG_PUB.count_and_get (
274: p_encoded => FND_API.g_false
275: ,p_count => l_msg_count
276: ,p_data => l_msg_data
277: );
278:

Line 292: p_encoded => FND_API.G_TRUE

288: RETURN;
289:
290: WHEN OTHERS THEN
291: fnd_msg_pub.Count_And_Get(
292: p_encoded => FND_API.G_TRUE
293: ,p_count => l_msg_count
294: ,p_data => l_msg_data);
295: wf_core.context(G_PKG_NAME, l_api_name,l_msg_data);
296: raise;

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

309: -- NOTES
310: ---------------------------------------------------------------------
311: PROCEDURE Process_Iface (
312: p_api_version IN NUMBER
313: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
314: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
315: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
316: ,p_resale_batch_id IN NUMBER
317: ,x_return_status OUT NOCOPY VARCHAR2

Line 314: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

310: ---------------------------------------------------------------------
311: PROCEDURE Process_Iface (
312: p_api_version IN NUMBER
313: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
314: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
315: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
316: ,p_resale_batch_id IN NUMBER
317: ,x_return_status OUT NOCOPY VARCHAR2
318: ,x_msg_data OUT NOCOPY VARCHAR2

Line 315: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

311: PROCEDURE Process_Iface (
312: p_api_version IN NUMBER
313: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
314: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
315: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
316: ,p_resale_batch_id IN NUMBER
317: ,x_return_status OUT NOCOPY VARCHAR2
318: ,x_msg_data OUT NOCOPY VARCHAR2
319: ,x_msg_count OUT NOCOPY NUMBER

Line 373: IF NOT FND_API.Compatible_API_Call (

369: BEGIN
370: -- Standard begin of API savepoint
371: SAVEPOINT PROCESS_IFACE;
372: -- Standard call to check for call compatibility.
373: IF NOT FND_API.Compatible_API_Call (
374: l_api_version,
375: p_api_version,
376: l_api_name,
377: G_PKG_NAME)

Line 379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

375: p_api_version,
376: l_api_name,
377: G_PKG_NAME)
378: THEN
379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
380: END IF;
381:
382: --Initialize message list if p_init_msg_list is TRUE.
383: IF FND_API.To_Boolean (p_init_msg_list) THEN

Line 383: IF FND_API.To_Boolean (p_init_msg_list) THEN

379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
380: END IF;
381:
382: --Initialize message list if p_init_msg_list is TRUE.
383: IF FND_API.To_Boolean (p_init_msg_list) THEN
384: FND_MSG_PUB.initialize;
385: END IF;
386:
387: -- Debug Message

Line 393: x_return_status := FND_API.G_RET_STS_SUCCESS;

389: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': Start');
390: END IF;
391:
392: -- Initialize API return status to sucess
393: x_return_status := FND_API.G_RET_STS_SUCCESS;
394:
395: OPEN g_org_id_csr (p_resale_batch_id);
396: FETCH g_org_id_csr into l_org_id;
397: CLOSE g_org_id_csr;

Line 403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

399: IF l_org_id is not null THEN
400: fnd_client_info.set_org_context(to_char(l_org_id));
401: ELSE
402: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_ORG_ID_NOTFOUND');
403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
404: END IF;
405:
406: OPEN OZF_RESALE_COMMON_PVT.g_batch_type_csr(p_resale_batch_id);
407: FETCH OZF_RESALE_COMMON_PVT.g_batch_type_csr into l_batch_type;

Line 413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

409:
410: -- Make sure that batch type is not null
411: IF l_batch_type is null THEN
412: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_BATCH_TYPE_NULL');
413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
414: END IF;
415:
416: -- Remove any log associated with this batch
417: BEGIN

Line 424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

420: AND resale_id = p_resale_batch_id;
421: EXCEPTION
422: WHEN OTHERS THEN
423: OZF_UTILITY_PVT.error_message('OZF_RESALE_DEL_LOG_ERR');
424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
425: END;
426:
427: -- Varify the line information for this batch
428: OZF_RESALE_COMMON_PVT.Validate_batch(

Line 430: ,p_init_msg_list => FND_API.G_FALSE

426:
427: -- Varify the line information for this batch
428: OZF_RESALE_COMMON_PVT.Validate_batch(
429: p_api_version => 1
430: ,p_init_msg_list => FND_API.G_FALSE
431: ,p_commit => FND_API.G_FALSE
432: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
433: ,p_resale_batch_id => p_resale_batch_id
434: ,x_batch_status => l_batch_status

Line 431: ,p_commit => FND_API.G_FALSE

427: -- Varify the line information for this batch
428: OZF_RESALE_COMMON_PVT.Validate_batch(
429: p_api_version => 1
430: ,p_init_msg_list => FND_API.G_FALSE
431: ,p_commit => FND_API.G_FALSE
432: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
433: ,p_resale_batch_id => p_resale_batch_id
434: ,x_batch_status => l_batch_status
435: ,x_return_status => l_return_status

Line 432: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

428: OZF_RESALE_COMMON_PVT.Validate_batch(
429: p_api_version => 1
430: ,p_init_msg_list => FND_API.G_FALSE
431: ,p_commit => FND_API.G_FALSE
432: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
433: ,p_resale_batch_id => p_resale_batch_id
434: ,x_batch_status => l_batch_status
435: ,x_return_status => l_return_status
436: ,x_msg_data => l_msg_data

Line 440: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN

436: ,x_msg_data => l_msg_data
437: ,x_msg_count => l_msg_count
438: );
439:
440: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
441: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_BATCH_VALIDATE_ERR');
442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
443: END IF;
444:

Line 442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

438: );
439:
440: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
441: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_BATCH_VALIDATE_ERR');
442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
443: END IF;
444:
445: -- set disputed_code to null for the lines to be processed.
446: update ozf_resale_lines_int

Line 470: p_init_msg_list => FND_API.G_FALSE,

466: CLOSE open_lines_csr;
467: */
468: OZF_RESALE_COMMON_PVT.Update_Duplicates (
469: p_api_version => 1.0,
470: p_init_msg_list => FND_API.G_FALSE,
471: p_commit => FND_API.G_FALSE,
472: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
473: p_resale_batch_id => p_resale_batch_id,
474: p_resale_batch_type => l_batch_type,

Line 471: p_commit => FND_API.G_FALSE,

467: */
468: OZF_RESALE_COMMON_PVT.Update_Duplicates (
469: p_api_version => 1.0,
470: p_init_msg_list => FND_API.G_FALSE,
471: p_commit => FND_API.G_FALSE,
472: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
473: p_resale_batch_id => p_resale_batch_id,
474: p_resale_batch_type => l_batch_type,
475: p_batch_status => l_batch_status,

Line 472: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

468: OZF_RESALE_COMMON_PVT.Update_Duplicates (
469: p_api_version => 1.0,
470: p_init_msg_list => FND_API.G_FALSE,
471: p_commit => FND_API.G_FALSE,
472: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
473: p_resale_batch_id => p_resale_batch_id,
474: p_resale_batch_type => l_batch_type,
475: p_batch_status => l_batch_status,
476: x_batch_status => l_batch_status,

Line 481: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

477: x_return_status => l_return_status,
478: x_msg_count => l_msg_count,
479: x_msg_data => l_msg_data);
480: --
481: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
482: RAISE FND_API.G_EXC_ERROR;
483: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
485: END IF;

Line 482: RAISE FND_API.G_EXC_ERROR;

478: x_msg_count => l_msg_count,
479: x_msg_data => l_msg_data);
480: --
481: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
482: RAISE FND_API.G_EXC_ERROR;
483: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
485: END IF;
486:

Line 483: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

479: x_msg_data => l_msg_data);
480: --
481: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
482: RAISE FND_API.G_EXC_ERROR;
483: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
485: END IF;
486:
487: IF l_batch_status = OZF_RESALE_COMMON_PVT.G_BATCH_REJECTED THEN

Line 484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

480: --
481: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
482: RAISE FND_API.G_EXC_ERROR;
483: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
485: END IF;
486:
487: IF l_batch_status = OZF_RESALE_COMMON_PVT.G_BATCH_REJECTED THEN
488: IF OZF_DEBUG_LOW_ON THEN

Line 495: ,p_init_msg_list => FND_API.G_FALSE

491: ELSE
492: -- Varify the line information for this batch
493: OZF_RESALE_COMMON_PVT.Validate_Order_Record(
494: p_api_version => 1
495: ,p_init_msg_list => FND_API.G_FALSE
496: ,p_commit => FND_API.G_FALSE
497: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
498: ,p_resale_batch_id => p_resale_batch_id
499: ,x_return_status => l_return_status

Line 496: ,p_commit => FND_API.G_FALSE

492: -- Varify the line information for this batch
493: OZF_RESALE_COMMON_PVT.Validate_Order_Record(
494: p_api_version => 1
495: ,p_init_msg_list => FND_API.G_FALSE
496: ,p_commit => FND_API.G_FALSE
497: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
498: ,p_resale_batch_id => p_resale_batch_id
499: ,x_return_status => l_return_status
500: ,x_msg_data => l_msg_data

Line 497: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

493: OZF_RESALE_COMMON_PVT.Validate_Order_Record(
494: p_api_version => 1
495: ,p_init_msg_list => FND_API.G_FALSE
496: ,p_commit => FND_API.G_FALSE
497: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
498: ,p_resale_batch_id => p_resale_batch_id
499: ,x_return_status => l_return_status
500: ,x_msg_data => l_msg_data
501: ,x_msg_count => l_msg_count

Line 503: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN

499: ,x_return_status => l_return_status
500: ,x_msg_data => l_msg_data
501: ,x_msg_count => l_msg_count
502: );
503: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
504: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_VALIDATE_ERR');
505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
506: END IF;
507:

Line 505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

501: ,x_msg_count => l_msg_count
502: );
503: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
504: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_VALIDATE_ERR');
505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
506: END IF;
507:
508: -- Call different validation here.
509: -- calling chargeback validation for this batch

Line 513: ,p_init_msg_list => FND_API.G_FALSE

509: -- calling chargeback validation for this batch
510: IF l_batch_type = OZF_RESALE_COMMON_PVT.G_TP_ACCRUAL THEN
511: OZF_TP_ACCRUAL_PVT.Validate_Order_Record(
512: p_api_version => 1
513: ,p_init_msg_list => FND_API.G_FALSE
514: ,p_commit => FND_API.G_FALSE
515: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
516: ,p_resale_batch_id => p_resale_batch_id
517: ,p_caller_type => OZF_TP_ACCRUAL_PVT.G_IFACE_CALLER

Line 514: ,p_commit => FND_API.G_FALSE

510: IF l_batch_type = OZF_RESALE_COMMON_PVT.G_TP_ACCRUAL THEN
511: OZF_TP_ACCRUAL_PVT.Validate_Order_Record(
512: p_api_version => 1
513: ,p_init_msg_list => FND_API.G_FALSE
514: ,p_commit => FND_API.G_FALSE
515: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
516: ,p_resale_batch_id => p_resale_batch_id
517: ,p_caller_type => OZF_TP_ACCRUAL_PVT.G_IFACE_CALLER
518: ,x_return_status => l_return_status

Line 515: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

511: OZF_TP_ACCRUAL_PVT.Validate_Order_Record(
512: p_api_version => 1
513: ,p_init_msg_list => FND_API.G_FALSE
514: ,p_commit => FND_API.G_FALSE
515: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
516: ,p_resale_batch_id => p_resale_batch_id
517: ,p_caller_type => OZF_TP_ACCRUAL_PVT.G_IFACE_CALLER
518: ,x_return_status => l_return_status
519: ,x_msg_data => l_msg_data

Line 522: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN

518: ,x_return_status => l_return_status
519: ,x_msg_data => l_msg_data
520: ,x_msg_count => l_msg_count
521: );
522: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
523: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_TP_VALIDATE_ERR');
524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
525: END IF;
526: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_CHARGEBACK THEN

Line 524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

520: ,x_msg_count => l_msg_count
521: );
522: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
523: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_TP_VALIDATE_ERR');
524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
525: END IF;
526: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_CHARGEBACK THEN
527: OZF_CHARGEBACK_PVT.Validate_Order_Record(
528: p_api_version => 1

Line 529: ,p_init_msg_list => FND_API.G_FALSE

525: END IF;
526: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_CHARGEBACK THEN
527: OZF_CHARGEBACK_PVT.Validate_Order_Record(
528: p_api_version => 1
529: ,p_init_msg_list => FND_API.G_FALSE
530: ,p_commit => FND_API.G_FALSE
531: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
532: ,p_resale_batch_id => p_resale_batch_id
533: ,x_return_status => l_return_status

Line 530: ,p_commit => FND_API.G_FALSE

526: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_CHARGEBACK THEN
527: OZF_CHARGEBACK_PVT.Validate_Order_Record(
528: p_api_version => 1
529: ,p_init_msg_list => FND_API.G_FALSE
530: ,p_commit => FND_API.G_FALSE
531: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
532: ,p_resale_batch_id => p_resale_batch_id
533: ,x_return_status => l_return_status
534: ,x_msg_data => l_msg_data

Line 531: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

527: OZF_CHARGEBACK_PVT.Validate_Order_Record(
528: p_api_version => 1
529: ,p_init_msg_list => FND_API.G_FALSE
530: ,p_commit => FND_API.G_FALSE
531: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
532: ,p_resale_batch_id => p_resale_batch_id
533: ,x_return_status => l_return_status
534: ,x_msg_data => l_msg_data
535: ,x_msg_count => l_msg_count

Line 537: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN

533: ,x_return_status => l_return_status
534: ,x_msg_data => l_msg_data
535: ,x_msg_count => l_msg_count
536: );
537: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
538: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_CHBK_VALIDATE_ERR');
539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
540: END IF;
541: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_SPECIAL_PRICING THEN

Line 539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

535: ,x_msg_count => l_msg_count
536: );
537: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
538: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_CHBK_VALIDATE_ERR');
539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
540: END IF;
541: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_SPECIAL_PRICING THEN
542: OZF_SPECIAL_PRICING_PVT.Validate_Order_Record(
543: p_api_version => 1

Line 544: ,p_init_msg_list => FND_API.G_FALSE

540: END IF;
541: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_SPECIAL_PRICING THEN
542: OZF_SPECIAL_PRICING_PVT.Validate_Order_Record(
543: p_api_version => 1
544: ,p_init_msg_list => FND_API.G_FALSE
545: ,p_commit => FND_API.G_FALSE
546: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
547: ,p_resale_batch_id => p_resale_batch_id
548: ,x_return_status => l_return_status

Line 545: ,p_commit => FND_API.G_FALSE

541: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_SPECIAL_PRICING THEN
542: OZF_SPECIAL_PRICING_PVT.Validate_Order_Record(
543: p_api_version => 1
544: ,p_init_msg_list => FND_API.G_FALSE
545: ,p_commit => FND_API.G_FALSE
546: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
547: ,p_resale_batch_id => p_resale_batch_id
548: ,x_return_status => l_return_status
549: ,x_msg_data => l_msg_data

Line 546: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

542: OZF_SPECIAL_PRICING_PVT.Validate_Order_Record(
543: p_api_version => 1
544: ,p_init_msg_list => FND_API.G_FALSE
545: ,p_commit => FND_API.G_FALSE
546: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
547: ,p_resale_batch_id => p_resale_batch_id
548: ,x_return_status => l_return_status
549: ,x_msg_data => l_msg_data
550: ,x_msg_count => l_msg_count

Line 552: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN

548: ,x_return_status => l_return_status
549: ,x_msg_data => l_msg_data
550: ,x_msg_count => l_msg_count
551: );
552: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
553: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_SPP_VALIDATE_ERR');
554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
555: END IF;
556: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_TRACING THEN

Line 554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

550: ,x_msg_count => l_msg_count
551: );
552: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
553: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_SPP_VALIDATE_ERR');
554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
555: END IF;
556: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_TRACING THEN
557: OZF_TRACING_ORDER_PVT.Validate_Order_Record(
558: p_api_version => 1

Line 559: ,p_init_msg_list => FND_API.G_FALSE

555: END IF;
556: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_TRACING THEN
557: OZF_TRACING_ORDER_PVT.Validate_Order_Record(
558: p_api_version => 1
559: ,p_init_msg_list => FND_API.G_FALSE
560: ,p_commit => FND_API.G_FALSE
561: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
562: ,p_resale_batch_id => p_resale_batch_id
563: ,x_return_status => l_return_status

Line 560: ,p_commit => FND_API.G_FALSE

556: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_TRACING THEN
557: OZF_TRACING_ORDER_PVT.Validate_Order_Record(
558: p_api_version => 1
559: ,p_init_msg_list => FND_API.G_FALSE
560: ,p_commit => FND_API.G_FALSE
561: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
562: ,p_resale_batch_id => p_resale_batch_id
563: ,x_return_status => l_return_status
564: ,x_msg_data => l_msg_data

Line 561: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

557: OZF_TRACING_ORDER_PVT.Validate_Order_Record(
558: p_api_version => 1
559: ,p_init_msg_list => FND_API.G_FALSE
560: ,p_commit => FND_API.G_FALSE
561: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
562: ,p_resale_batch_id => p_resale_batch_id
563: ,x_return_status => l_return_status
564: ,x_msg_data => l_msg_data
565: ,x_msg_count => l_msg_count

Line 567: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN

563: ,x_return_status => l_return_status
564: ,x_msg_data => l_msg_data
565: ,x_msg_count => l_msg_count
566: );
567: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
568: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_TRAC_VALIDATE_ERR');
569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
570: END IF;
571: ELSE

Line 569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

565: ,x_msg_count => l_msg_count
566: );
567: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
568: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_TRAC_VALIDATE_ERR');
569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
570: END IF;
571: ELSE
572: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_WNG_BATCH_TYPE');
573: RAISE FND_API.g_exc_unexpected_error;

Line 573: RAISE FND_API.g_exc_unexpected_error;

569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
570: END IF;
571: ELSE
572: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_WNG_BATCH_TYPE');
573: RAISE FND_API.g_exc_unexpected_error;
574: END IF;
575:
576: /*
577: OPEN duplicate_count_csr (p_resale_batch_id);

Line 594: ,p_init_msg_list => FND_API.G_FALSE

590: */
591: IF l_batch_type = OZF_RESALE_COMMON_PVT.G_TP_ACCRUAL THEN
592: OZF_TP_ACCRUAL_PVT.Process_Order(
593: p_api_version => 1
594: ,p_init_msg_list => FND_API.G_FALSE
595: ,p_commit => FND_API.G_FALSE
596: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
597: ,p_resale_batch_id => p_resale_batch_id
598: ,x_return_status => l_return_status

Line 595: ,p_commit => FND_API.G_FALSE

591: IF l_batch_type = OZF_RESALE_COMMON_PVT.G_TP_ACCRUAL THEN
592: OZF_TP_ACCRUAL_PVT.Process_Order(
593: p_api_version => 1
594: ,p_init_msg_list => FND_API.G_FALSE
595: ,p_commit => FND_API.G_FALSE
596: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
597: ,p_resale_batch_id => p_resale_batch_id
598: ,x_return_status => l_return_status
599: ,x_msg_data => l_msg_data

Line 596: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

592: OZF_TP_ACCRUAL_PVT.Process_Order(
593: p_api_version => 1
594: ,p_init_msg_list => FND_API.G_FALSE
595: ,p_commit => FND_API.G_FALSE
596: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
597: ,p_resale_batch_id => p_resale_batch_id
598: ,x_return_status => l_return_status
599: ,x_msg_data => l_msg_data
600: ,x_msg_count => l_msg_count

Line 603: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN

599: ,x_msg_data => l_msg_data
600: ,x_msg_count => l_msg_count
601: );
602:
603: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
604: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_TP_PROC_ERR');
605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
606: END IF;
607: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_CHARGEBACK THEN

Line 605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

601: );
602:
603: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
604: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_TP_PROC_ERR');
605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
606: END IF;
607: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_CHARGEBACK THEN
608: OZF_CHARGEBACK_PVT.Process_Order(
609: p_api_version => 1

Line 610: ,p_init_msg_list => FND_API.G_FALSE

606: END IF;
607: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_CHARGEBACK THEN
608: OZF_CHARGEBACK_PVT.Process_Order(
609: p_api_version => 1
610: ,p_init_msg_list => FND_API.G_FALSE
611: ,p_commit => FND_API.G_FALSE
612: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
613: ,p_resale_batch_id => p_resale_batch_id
614: ,x_return_status => l_return_status

Line 611: ,p_commit => FND_API.G_FALSE

607: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_CHARGEBACK THEN
608: OZF_CHARGEBACK_PVT.Process_Order(
609: p_api_version => 1
610: ,p_init_msg_list => FND_API.G_FALSE
611: ,p_commit => FND_API.G_FALSE
612: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
613: ,p_resale_batch_id => p_resale_batch_id
614: ,x_return_status => l_return_status
615: ,x_msg_data => l_msg_data

Line 612: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

608: OZF_CHARGEBACK_PVT.Process_Order(
609: p_api_version => 1
610: ,p_init_msg_list => FND_API.G_FALSE
611: ,p_commit => FND_API.G_FALSE
612: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
613: ,p_resale_batch_id => p_resale_batch_id
614: ,x_return_status => l_return_status
615: ,x_msg_data => l_msg_data
616: ,x_msg_count => l_msg_count

Line 618: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN

614: ,x_return_status => l_return_status
615: ,x_msg_data => l_msg_data
616: ,x_msg_count => l_msg_count
617: );
618: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
619: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_CHBK_PROC_ERR');
620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
621: END IF;
622: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_SPECIAL_PRICING THEN

Line 620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

616: ,x_msg_count => l_msg_count
617: );
618: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
619: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_CHBK_PROC_ERR');
620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
621: END IF;
622: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_SPECIAL_PRICING THEN
623: OZF_SPECIAL_PRICING_PVT.Process_Order(
624: p_api_version => 1

Line 625: ,p_init_msg_list => FND_API.G_FALSE

621: END IF;
622: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_SPECIAL_PRICING THEN
623: OZF_SPECIAL_PRICING_PVT.Process_Order(
624: p_api_version => 1
625: ,p_init_msg_list => FND_API.G_FALSE
626: ,p_commit => FND_API.G_FALSE
627: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
628: ,p_resale_batch_id => p_resale_batch_id
629: ,x_return_status => l_return_status

Line 626: ,p_commit => FND_API.G_FALSE

622: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_SPECIAL_PRICING THEN
623: OZF_SPECIAL_PRICING_PVT.Process_Order(
624: p_api_version => 1
625: ,p_init_msg_list => FND_API.G_FALSE
626: ,p_commit => FND_API.G_FALSE
627: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
628: ,p_resale_batch_id => p_resale_batch_id
629: ,x_return_status => l_return_status
630: ,x_msg_data => l_msg_data

Line 627: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

623: OZF_SPECIAL_PRICING_PVT.Process_Order(
624: p_api_version => 1
625: ,p_init_msg_list => FND_API.G_FALSE
626: ,p_commit => FND_API.G_FALSE
627: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
628: ,p_resale_batch_id => p_resale_batch_id
629: ,x_return_status => l_return_status
630: ,x_msg_data => l_msg_data
631: ,x_msg_count => l_msg_count

Line 633: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN

629: ,x_return_status => l_return_status
630: ,x_msg_data => l_msg_data
631: ,x_msg_count => l_msg_count
632: );
633: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
634: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_SPP_PROC_ERR');
635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
636: END IF;
637: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_TRACING THEN

Line 635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

631: ,x_msg_count => l_msg_count
632: );
633: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
634: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_SPP_PROC_ERR');
635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
636: END IF;
637: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_TRACING THEN
638: OZF_TRACING_ORDER_PVT.Process_Order(
639: p_api_version => 1

Line 640: ,p_init_msg_list => FND_API.G_FALSE

636: END IF;
637: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_TRACING THEN
638: OZF_TRACING_ORDER_PVT.Process_Order(
639: p_api_version => 1
640: ,p_init_msg_list => FND_API.G_FALSE
641: ,p_commit => FND_API.G_FALSE
642: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
643: ,p_resale_batch_id => p_resale_batch_id
644: ,x_return_status => l_return_status

Line 641: ,p_commit => FND_API.G_FALSE

637: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_TRACING THEN
638: OZF_TRACING_ORDER_PVT.Process_Order(
639: p_api_version => 1
640: ,p_init_msg_list => FND_API.G_FALSE
641: ,p_commit => FND_API.G_FALSE
642: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
643: ,p_resale_batch_id => p_resale_batch_id
644: ,x_return_status => l_return_status
645: ,x_msg_data => l_msg_data

Line 642: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

638: OZF_TRACING_ORDER_PVT.Process_Order(
639: p_api_version => 1
640: ,p_init_msg_list => FND_API.G_FALSE
641: ,p_commit => FND_API.G_FALSE
642: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
643: ,p_resale_batch_id => p_resale_batch_id
644: ,x_return_status => l_return_status
645: ,x_msg_data => l_msg_data
646: ,x_msg_count => l_msg_count

Line 649: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN

645: ,x_msg_data => l_msg_data
646: ,x_msg_count => l_msg_count
647: );
648:
649: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
650: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_TRAC_PROC_ERR');
651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
652: END IF;
653: ELSE

Line 651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

647: );
648:
649: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
650: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_TRAC_PROC_ERR');
651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
652: END IF;
653: ELSE
654: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_WNG_BATCH_TYPE');
655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
652: END IF;
653: ELSE
654: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_WNG_BATCH_TYPE');
655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
656: END IF;
657: END IF; -- IF status is not rejected.
658:
659: -- Debug Message

Line 665: p_encoded => FND_API.G_FALSE,

661: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
662: END IF;
663: --Standard call to get message count and if count=1, get the message
664: FND_MSG_PUB.Count_And_Get (
665: p_encoded => FND_API.G_FALSE,
666: p_count => x_msg_count,
667: p_data => x_msg_data
668: );
669:

Line 671: WHEN FND_API.G_EXC_ERROR THEN

667: p_data => x_msg_data
668: );
669:
670: EXCEPTION
671: WHEN FND_API.G_EXC_ERROR THEN
672: x_return_status := FND_API.G_RET_STS_ERROR;
673: -- Standard call to get message count and if count=1, get the message
674: FND_MSG_PUB.Count_And_Get (
675: p_encoded => FND_API.G_FALSE,

Line 672: x_return_status := FND_API.G_RET_STS_ERROR;

668: );
669:
670: EXCEPTION
671: WHEN FND_API.G_EXC_ERROR THEN
672: x_return_status := FND_API.G_RET_STS_ERROR;
673: -- Standard call to get message count and if count=1, get the message
674: FND_MSG_PUB.Count_And_Get (
675: p_encoded => FND_API.G_FALSE,
676: p_count => x_msg_count,

Line 675: p_encoded => FND_API.G_FALSE,

671: WHEN FND_API.G_EXC_ERROR THEN
672: x_return_status := FND_API.G_RET_STS_ERROR;
673: -- Standard call to get message count and if count=1, get the message
674: FND_MSG_PUB.Count_And_Get (
675: p_encoded => FND_API.G_FALSE,
676: p_count => x_msg_count,
677: p_data => x_msg_data
678: );
679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

675: p_encoded => FND_API.G_FALSE,
676: p_count => x_msg_count,
677: p_data => x_msg_data
678: );
679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
681: -- Standard call to get message count and if count=1, get the message
682: FND_MSG_PUB.Count_And_Get (
683: p_encoded => FND_API.G_FALSE,

Line 680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

676: p_count => x_msg_count,
677: p_data => x_msg_data
678: );
679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
681: -- Standard call to get message count and if count=1, get the message
682: FND_MSG_PUB.Count_And_Get (
683: p_encoded => FND_API.G_FALSE,
684: p_count => x_msg_count,

Line 683: p_encoded => FND_API.G_FALSE,

679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
681: -- Standard call to get message count and if count=1, get the message
682: FND_MSG_PUB.Count_And_Get (
683: p_encoded => FND_API.G_FALSE,
684: p_count => x_msg_count,
685: p_data => x_msg_data
686: );
687: WHEN OTHERS THEN

Line 689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

685: p_data => x_msg_data
686: );
687: WHEN OTHERS THEN
688: ROLLBACK TO PROCESS_IFACE;
689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
690: -- Standard call to get message count and if count=1, get the message
691: FND_MSG_PUB.Count_And_Get (
692: p_encoded => FND_API.G_FALSE,
693: p_count => x_msg_count,

Line 692: p_encoded => FND_API.G_FALSE,

688: ROLLBACK TO PROCESS_IFACE;
689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
690: -- Standard call to get message count and if count=1, get the message
691: FND_MSG_PUB.Count_And_Get (
692: p_encoded => FND_API.G_FALSE,
693: p_count => x_msg_count,
694: p_data => x_msg_data
695: );
696: END Process_Iface;

Line 739: ,p_init_msg_list => FND_API.G_FALSE

735: itemkey => itemkey,
736: aname => 'RESALE_BATCH_ID');
737: Process_iface (
738: p_api_version => 1.0
739: ,p_init_msg_list => FND_API.G_FALSE
740: ,p_commit => FND_API.G_FALSE
741: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
742: ,p_resale_batch_id => l_resale_batch_id
743: ,x_return_status => l_return_status

Line 740: ,p_commit => FND_API.G_FALSE

736: aname => 'RESALE_BATCH_ID');
737: Process_iface (
738: p_api_version => 1.0
739: ,p_init_msg_list => FND_API.G_FALSE
740: ,p_commit => FND_API.G_FALSE
741: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
742: ,p_resale_batch_id => l_resale_batch_id
743: ,x_return_status => l_return_status
744: ,x_msg_data => l_msg_data

Line 741: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

737: Process_iface (
738: p_api_version => 1.0
739: ,p_init_msg_list => FND_API.G_FALSE
740: ,p_commit => FND_API.G_FALSE
741: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
742: ,p_resale_batch_id => l_resale_batch_id
743: ,x_return_status => l_return_status
744: ,x_msg_data => l_msg_data
745: ,x_msg_count => l_msg_count

Line 747: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

743: ,x_return_status => l_return_status
744: ,x_msg_data => l_msg_data
745: ,x_msg_count => l_msg_count
746: );
747: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
748: raise FND_API.G_EXC_ERROR;
749: END IF;
750: l_resultout := 'COMPLETE:Y';
751: ELSIF (funcmode = 'CANCEL') THEN

Line 748: raise FND_API.G_EXC_ERROR;

744: ,x_msg_data => l_msg_data
745: ,x_msg_count => l_msg_count
746: );
747: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
748: raise FND_API.G_EXC_ERROR;
749: END IF;
750: l_resultout := 'COMPLETE:Y';
751: ELSIF (funcmode = 'CANCEL') THEN
752: l_resultout := 'COMPLETE:Y';

Line 762: WHEN FND_API.G_EXC_ERROR THEN

758: l_resultout := 'COMPLETE:Y';
759: END IF;
760: resultout := l_resultout;
761: EXCEPTION
762: WHEN FND_API.G_EXC_ERROR THEN
763: FND_MSG_PUB.count_and_get (
764: p_encoded => FND_API.g_false
765: ,p_count => l_msg_count
766: ,p_data => l_msg_data

Line 764: p_encoded => FND_API.g_false

760: resultout := l_resultout;
761: EXCEPTION
762: WHEN FND_API.G_EXC_ERROR THEN
763: FND_MSG_PUB.count_and_get (
764: p_encoded => FND_API.g_false
765: ,p_count => l_msg_count
766: ,p_data => l_msg_data
767: );
768: WF_CORE.context(

Line 781: p_encoded => FND_API.G_TRUE

777: RETURN;
778:
779: WHEN OTHERS THEN
780: fnd_msg_pub.Count_And_Get(
781: p_encoded => FND_API.G_TRUE
782: ,p_count => l_msg_count
783: ,p_data => l_msg_data);
784:
785: wf_core.context(G_PKG_NAME, l_api_name,l_msg_data);

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

800: -- NOTES
801: ---------------------------------------------------------------------
802: PROCEDURE Process_Resale (
803: p_api_version IN NUMBER
804: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
805: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
806: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
807: ,p_resale_batch_id IN NUMBER
808: ,x_return_status OUT NOCOPY VARCHAR2

Line 805: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

801: ---------------------------------------------------------------------
802: PROCEDURE Process_Resale (
803: p_api_version IN NUMBER
804: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
805: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
806: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
807: ,p_resale_batch_id IN NUMBER
808: ,x_return_status OUT NOCOPY VARCHAR2
809: ,x_msg_data OUT NOCOPY VARCHAR2

Line 806: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

802: PROCEDURE Process_Resale (
803: p_api_version IN NUMBER
804: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
805: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
806: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
807: ,p_resale_batch_id IN NUMBER
808: ,x_return_status OUT NOCOPY VARCHAR2
809: ,x_msg_data OUT NOCOPY VARCHAR2
810: ,x_msg_count OUT NOCOPY NUMBER

Line 835: IF NOT FND_API.Compatible_API_Call (

831:
832: -- Standard begin of API savepoint
833: SAVEPOINT PROCESS_RESALE;
834: -- Standard call to check for call compatibility.
835: IF NOT FND_API.Compatible_API_Call (
836: l_api_version,
837: p_api_version,
838: l_api_name,
839: G_PKG_NAME)

Line 841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

837: p_api_version,
838: l_api_name,
839: G_PKG_NAME)
840: THEN
841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
842: END IF;
843:
844: --Initialize message list if p_init_msg_list is TRUE.
845: IF FND_API.To_Boolean (p_init_msg_list) THEN

Line 845: IF FND_API.To_Boolean (p_init_msg_list) THEN

841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
842: END IF;
843:
844: --Initialize message list if p_init_msg_list is TRUE.
845: IF FND_API.To_Boolean (p_init_msg_list) THEN
846: FND_MSG_PUB.initialize;
847: END IF;
848:
849: -- Initialize API return status to sucess

Line 850: x_return_status := FND_API.G_RET_STS_SUCCESS;

846: FND_MSG_PUB.initialize;
847: END IF;
848:
849: -- Initialize API return status to sucess
850: x_return_status := FND_API.G_RET_STS_SUCCESS;
851:
852:
853: -- Debug Message
854: IF OZF_DEBUG_HIGH_ON THEN

Line 862: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

858: IF p_resale_batch_id is null THEN
859: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_BATCH_ID_NULL');
860: FND_MESSAGE.set_name('OZF', 'OZF_RESALE_BATCH_ID_NULL');
861: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : '||FND_MESSAGE.get);
862: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
863: GOTO PROC_RESALE_END;
864: END IF;
865:
866: OPEN csr_batch_number(p_resale_batch_id);

Line 881: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

877: IF l_batch_type is null THEN
878: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_BATCH_TYPE_NULL');
879: FND_MESSAGE.set_name('OZF', 'OZF_RESALE_BATCH_TYPE_NULL');
880: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : '||FND_MESSAGE.get);
881: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
882: GOTO PROC_RESALE_END;
883: END IF;
884:
885: /*

Line 888: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

884:
885: /*
886: IF l_batch_type = OZF_RESALE_COMMON_PVT.G_TP_ACCRUAL THEN
887: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_DUP_PROCESS_TP');
888: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
889: END IF;
890: */
891:
892: -- Only third party accrual is available for resale processing.

Line 895: ,p_init_msg_list => FND_API.G_FALSE

891:
892: -- Only third party accrual is available for resale processing.
893: OZF_TP_ACCRUAL_PVT.process_resale(
894: p_api_version => 1
895: ,p_init_msg_list => FND_API.G_FALSE
896: ,p_commit => FND_API.G_FALSE
897: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL
898: ,p_resale_batch_id => p_resale_batch_id
899: ,x_return_status => l_return_status

Line 896: ,p_commit => FND_API.G_FALSE

892: -- Only third party accrual is available for resale processing.
893: OZF_TP_ACCRUAL_PVT.process_resale(
894: p_api_version => 1
895: ,p_init_msg_list => FND_API.G_FALSE
896: ,p_commit => FND_API.G_FALSE
897: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL
898: ,p_resale_batch_id => p_resale_batch_id
899: ,x_return_status => l_return_status
900: ,x_msg_data => l_msg_data

Line 897: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL

893: OZF_TP_ACCRUAL_PVT.process_resale(
894: p_api_version => 1
895: ,p_init_msg_list => FND_API.G_FALSE
896: ,p_commit => FND_API.G_FALSE
897: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL
898: ,p_resale_batch_id => p_resale_batch_id
899: ,x_return_status => l_return_status
900: ,x_msg_data => l_msg_data
901: ,x_msg_count => l_msg_count

Line 903: IF l_return_status = FND_API.g_ret_sts_error THEN

899: ,x_return_status => l_return_status
900: ,x_msg_data => l_msg_data
901: ,x_msg_count => l_msg_count
902: );
903: IF l_return_status = FND_API.g_ret_sts_error THEN
904: RAISE FND_API.g_exc_error;
905: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
906: RAISE FND_API.g_exc_unexpected_error;
907: END IF;

Line 904: RAISE FND_API.g_exc_error;

900: ,x_msg_data => l_msg_data
901: ,x_msg_count => l_msg_count
902: );
903: IF l_return_status = FND_API.g_ret_sts_error THEN
904: RAISE FND_API.g_exc_error;
905: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
906: RAISE FND_API.g_exc_unexpected_error;
907: END IF;
908:

Line 905: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

901: ,x_msg_count => l_msg_count
902: );
903: IF l_return_status = FND_API.g_ret_sts_error THEN
904: RAISE FND_API.g_exc_error;
905: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
906: RAISE FND_API.g_exc_unexpected_error;
907: END IF;
908:
909: <>

Line 906: RAISE FND_API.g_exc_unexpected_error;

902: );
903: IF l_return_status = FND_API.g_ret_sts_error THEN
904: RAISE FND_API.g_exc_error;
905: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
906: RAISE FND_API.g_exc_unexpected_error;
907: END IF;
908:
909: <>
910:

Line 917: p_encoded => FND_API.G_FALSE,

913: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
914: END IF;
915: --Standard call to get message count and if count=1, get the message
916: FND_MSG_PUB.Count_And_Get (
917: p_encoded => FND_API.G_FALSE,
918: p_count => x_msg_count,
919: p_data => x_msg_data
920: );
921: EXCEPTION

Line 922: WHEN FND_API.G_EXC_ERROR THEN

918: p_count => x_msg_count,
919: p_data => x_msg_data
920: );
921: EXCEPTION
922: WHEN FND_API.G_EXC_ERROR THEN
923: x_return_status := FND_API.G_RET_STS_ERROR;
924: -- Standard call to get message count and if count=1, get the message
925: FND_MSG_PUB.Count_And_Get (
926: p_encoded => FND_API.G_FALSE,

Line 923: x_return_status := FND_API.G_RET_STS_ERROR;

919: p_data => x_msg_data
920: );
921: EXCEPTION
922: WHEN FND_API.G_EXC_ERROR THEN
923: x_return_status := FND_API.G_RET_STS_ERROR;
924: -- Standard call to get message count and if count=1, get the message
925: FND_MSG_PUB.Count_And_Get (
926: p_encoded => FND_API.G_FALSE,
927: p_count => x_msg_count,

Line 926: p_encoded => FND_API.G_FALSE,

922: WHEN FND_API.G_EXC_ERROR THEN
923: x_return_status := FND_API.G_RET_STS_ERROR;
924: -- Standard call to get message count and if count=1, get the message
925: FND_MSG_PUB.Count_And_Get (
926: p_encoded => FND_API.G_FALSE,
927: p_count => x_msg_count,
928: p_data => x_msg_data
929: );
930: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 930: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

926: p_encoded => FND_API.G_FALSE,
927: p_count => x_msg_count,
928: p_data => x_msg_data
929: );
930: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
932: -- Standard call to get message count and if count=1, get the message
933: FND_MSG_PUB.Count_And_Get (
934: p_encoded => FND_API.G_FALSE,

Line 931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

927: p_count => x_msg_count,
928: p_data => x_msg_data
929: );
930: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
932: -- Standard call to get message count and if count=1, get the message
933: FND_MSG_PUB.Count_And_Get (
934: p_encoded => FND_API.G_FALSE,
935: p_count => x_msg_count,

Line 934: p_encoded => FND_API.G_FALSE,

930: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
932: -- Standard call to get message count and if count=1, get the message
933: FND_MSG_PUB.Count_And_Get (
934: p_encoded => FND_API.G_FALSE,
935: p_count => x_msg_count,
936: p_data => x_msg_data
937: );
938: WHEN OTHERS THEN

Line 940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

936: p_data => x_msg_data
937: );
938: WHEN OTHERS THEN
939: ROLLBACK TO PROCESS_RESALE;
940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
941: -- Standard call to get message count and if count=1, get the message
942: FND_MSG_PUB.Count_And_Get (
943: p_encoded => FND_API.G_FALSE,
944: p_count => x_msg_count,

Line 943: p_encoded => FND_API.G_FALSE,

939: ROLLBACK TO PROCESS_RESALE;
940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
941: -- Standard call to get message count and if count=1, get the message
942: FND_MSG_PUB.Count_And_Get (
943: p_encoded => FND_API.G_FALSE,
944: p_count => x_msg_count,
945: p_data => x_msg_data
946: );
947: END Process_Resale;

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

959: -- NOTES
960: ---------------------------------------------------------------------
961: PROCEDURE Process_Resale (
962: p_api_version IN NUMBER
963: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
964: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
965: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
966: ,p_start_date IN DATE
967: ,p_end_date IN DATE

Line 964: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

960: ---------------------------------------------------------------------
961: PROCEDURE Process_Resale (
962: p_api_version IN NUMBER
963: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
964: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
965: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
966: ,p_start_date IN DATE
967: ,p_end_date IN DATE
968: ,p_partner_cust_account_id IN NUMBER

Line 965: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

961: PROCEDURE Process_Resale (
962: p_api_version IN NUMBER
963: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
964: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
965: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
966: ,p_start_date IN DATE
967: ,p_end_date IN DATE
968: ,p_partner_cust_account_id IN NUMBER
969: ,x_return_status OUT NOCOPY VARCHAR2

Line 1015: IF NOT FND_API.Compatible_API_Call (

1011: BEGIN
1012: -- Standard begin of API savepoint
1013: SAVEPOINT PROCESS_RESALE_ALL;
1014: -- Standard call to check for call compatibility.
1015: IF NOT FND_API.Compatible_API_Call (
1016: l_api_version,
1017: p_api_version,
1018: l_api_name,
1019: G_PKG_NAME)

Line 1021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1017: p_api_version,
1018: l_api_name,
1019: G_PKG_NAME)
1020: THEN
1021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1022: END IF;
1023:
1024: --Initialize message list if p_init_msg_list is TRUE.
1025: IF FND_API.To_Boolean (p_init_msg_list) THEN

Line 1025: IF FND_API.To_Boolean (p_init_msg_list) THEN

1021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1022: END IF;
1023:
1024: --Initialize message list if p_init_msg_list is TRUE.
1025: IF FND_API.To_Boolean (p_init_msg_list) THEN
1026: FND_MSG_PUB.initialize;
1027: END IF;
1028:
1029: -- Initialize API return status to sucess

Line 1030: x_return_status := FND_API.G_RET_STS_SUCCESS;

1026: FND_MSG_PUB.initialize;
1027: END IF;
1028:
1029: -- Initialize API return status to sucess
1030: x_return_status := FND_API.G_RET_STS_SUCCESS;
1031:
1032: -- Debug Message
1033: IF OZF_DEBUG_HIGH_ON THEN
1034: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');

Line 1064: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1060: l_start_date > l_end_date THEN
1061: ozf_utility_pvt.error_message('OZF_RESALE_WNG_DATE_RANGE');
1062: FND_MESSAGE.set_name('OZF', 'OZF_RESALE_WNG_DATE_RANGE');
1063: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : '||FND_MESSAGE.get);
1064: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1065: GOTO PROC_RESALE_2_END;
1066: END IF;
1067: -- Bug 4518607 (-)
1068:

Line 1099: ,p_init_msg_list => FND_API.G_FALSE

1095: IF l_batch_id_tbl.exists(1) THEN
1096: FOR j in 1..l_batch_id_tbl.LAST LOOP
1097: process_resale(
1098: p_api_version => 1
1099: ,p_init_msg_list => FND_API.G_FALSE
1100: ,p_commit => FND_API.G_FALSE
1101: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL
1102: ,p_resale_batch_id => l_batch_id_tbl(j)
1103: ,x_return_status => l_return_status

Line 1100: ,p_commit => FND_API.G_FALSE

1096: FOR j in 1..l_batch_id_tbl.LAST LOOP
1097: process_resale(
1098: p_api_version => 1
1099: ,p_init_msg_list => FND_API.G_FALSE
1100: ,p_commit => FND_API.G_FALSE
1101: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL
1102: ,p_resale_batch_id => l_batch_id_tbl(j)
1103: ,x_return_status => l_return_status
1104: ,x_msg_data => l_msg_data

Line 1101: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL

1097: process_resale(
1098: p_api_version => 1
1099: ,p_init_msg_list => FND_API.G_FALSE
1100: ,p_commit => FND_API.G_FALSE
1101: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL
1102: ,p_resale_batch_id => l_batch_id_tbl(j)
1103: ,x_return_status => l_return_status
1104: ,x_msg_data => l_msg_data
1105: ,x_msg_count => l_msg_count

Line 1107: IF l_return_status = FND_API.g_ret_sts_error THEN

1103: ,x_return_status => l_return_status
1104: ,x_msg_data => l_msg_data
1105: ,x_msg_count => l_msg_count
1106: );
1107: IF l_return_status = FND_API.g_ret_sts_error THEN
1108: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
1109: RAISE FND_API.G_EXC_ERROR;
1110: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1111: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');

Line 1109: RAISE FND_API.G_EXC_ERROR;

1105: ,x_msg_count => l_msg_count
1106: );
1107: IF l_return_status = FND_API.g_ret_sts_error THEN
1108: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
1109: RAISE FND_API.G_EXC_ERROR;
1110: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1111: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
1112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1113: END IF;

Line 1110: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1106: );
1107: IF l_return_status = FND_API.g_ret_sts_error THEN
1108: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
1109: RAISE FND_API.G_EXC_ERROR;
1110: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1111: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
1112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1113: END IF;
1114: END LOOP;

Line 1112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1108: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
1109: RAISE FND_API.G_EXC_ERROR;
1110: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1111: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
1112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1113: END IF;
1114: END LOOP;
1115: ELSE
1116: IF OZF_DEBUG_LOW_ON THEN

Line 1131: p_encoded => FND_API.G_FALSE,

1127: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
1128: END IF;
1129: --Standard call to get message count and if count=1, get the message
1130: FND_MSG_PUB.Count_And_Get (
1131: p_encoded => FND_API.G_FALSE,
1132: p_count => x_msg_count,
1133: p_data => x_msg_data
1134: );
1135: EXCEPTION

Line 1136: WHEN FND_API.G_EXC_ERROR THEN

1132: p_count => x_msg_count,
1133: p_data => x_msg_data
1134: );
1135: EXCEPTION
1136: WHEN FND_API.G_EXC_ERROR THEN
1137: x_return_status := FND_API.G_RET_STS_ERROR;
1138: -- Standard call to get message count and if count=1, get the message
1139: FND_MSG_PUB.Count_And_Get (
1140: p_encoded => FND_API.G_FALSE,

Line 1137: x_return_status := FND_API.G_RET_STS_ERROR;

1133: p_data => x_msg_data
1134: );
1135: EXCEPTION
1136: WHEN FND_API.G_EXC_ERROR THEN
1137: x_return_status := FND_API.G_RET_STS_ERROR;
1138: -- Standard call to get message count and if count=1, get the message
1139: FND_MSG_PUB.Count_And_Get (
1140: p_encoded => FND_API.G_FALSE,
1141: p_count => x_msg_count,

Line 1140: p_encoded => FND_API.G_FALSE,

1136: WHEN FND_API.G_EXC_ERROR THEN
1137: x_return_status := FND_API.G_RET_STS_ERROR;
1138: -- Standard call to get message count and if count=1, get the message
1139: FND_MSG_PUB.Count_And_Get (
1140: p_encoded => FND_API.G_FALSE,
1141: p_count => x_msg_count,
1142: p_data => x_msg_data
1143: );
1144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1140: p_encoded => FND_API.G_FALSE,
1141: p_count => x_msg_count,
1142: p_data => x_msg_data
1143: );
1144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1146: -- Standard call to get message count and if count=1, get the message
1147: FND_MSG_PUB.Count_And_Get (
1148: p_encoded => FND_API.G_FALSE,

Line 1145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1141: p_count => x_msg_count,
1142: p_data => x_msg_data
1143: );
1144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1146: -- Standard call to get message count and if count=1, get the message
1147: FND_MSG_PUB.Count_And_Get (
1148: p_encoded => FND_API.G_FALSE,
1149: p_count => x_msg_count,

Line 1148: p_encoded => FND_API.G_FALSE,

1144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1146: -- Standard call to get message count and if count=1, get the message
1147: FND_MSG_PUB.Count_And_Get (
1148: p_encoded => FND_API.G_FALSE,
1149: p_count => x_msg_count,
1150: p_data => x_msg_data
1151: );
1152: WHEN OTHERS THEN

Line 1154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1150: p_data => x_msg_data
1151: );
1152: WHEN OTHERS THEN
1153: ROLLBACK TO PROCESS_RESALE_ALL;
1154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1155: -- Standard call to get message count and if count=1, get the message
1156: FND_MSG_PUB.Count_And_Get (
1157: p_encoded => FND_API.G_FALSE,
1158: p_count => x_msg_count,

Line 1157: p_encoded => FND_API.G_FALSE,

1153: ROLLBACK TO PROCESS_RESALE_ALL;
1154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1155: -- Standard call to get message count and if count=1, get the message
1156: FND_MSG_PUB.Count_And_Get (
1157: p_encoded => FND_API.G_FALSE,
1158: p_count => x_msg_count,
1159: p_data => x_msg_data
1160: );
1161: END Process_Resale;

Line 1218: ,p_init_msg_list => FND_API.G_FALSE

1214:
1215: IF p_resale_batch_id is NULL THEN
1216: Process_resale (
1217: p_api_version => 1.0
1218: ,p_init_msg_list => FND_API.G_FALSE
1219: ,p_commit => FND_API.G_FALSE
1220: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1221: ,p_start_date => p_start_date
1222: ,p_end_date => p_end_date

Line 1219: ,p_commit => FND_API.G_FALSE

1215: IF p_resale_batch_id is NULL THEN
1216: Process_resale (
1217: p_api_version => 1.0
1218: ,p_init_msg_list => FND_API.G_FALSE
1219: ,p_commit => FND_API.G_FALSE
1220: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1221: ,p_start_date => p_start_date
1222: ,p_end_date => p_end_date
1223: ,p_partner_cust_account_id => p_partner_cust_account_id

Line 1220: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1216: Process_resale (
1217: p_api_version => 1.0
1218: ,p_init_msg_list => FND_API.G_FALSE
1219: ,p_commit => FND_API.G_FALSE
1220: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1221: ,p_start_date => p_start_date
1222: ,p_end_date => p_end_date
1223: ,p_partner_cust_account_id => p_partner_cust_account_id
1224: ,x_return_status => l_return_status

Line 1228: IF l_return_status = FND_API.g_ret_sts_error THEN

1224: ,x_return_status => l_return_status
1225: ,x_msg_data => l_msg_data
1226: ,x_msg_count => l_msg_count
1227: );
1228: IF l_return_status = FND_API.g_ret_sts_error THEN
1229: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
1230: RAISE FND_API.g_exc_error;
1231: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1232: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');

Line 1230: RAISE FND_API.g_exc_error;

1226: ,x_msg_count => l_msg_count
1227: );
1228: IF l_return_status = FND_API.g_ret_sts_error THEN
1229: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
1230: RAISE FND_API.g_exc_error;
1231: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1232: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
1233: RAISE FND_API.g_exc_unexpected_error;
1234: END IF;

Line 1231: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1227: );
1228: IF l_return_status = FND_API.g_ret_sts_error THEN
1229: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
1230: RAISE FND_API.g_exc_error;
1231: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1232: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
1233: RAISE FND_API.g_exc_unexpected_error;
1234: END IF;
1235: ELSE

Line 1233: RAISE FND_API.g_exc_unexpected_error;

1229: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
1230: RAISE FND_API.g_exc_error;
1231: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1232: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
1233: RAISE FND_API.g_exc_unexpected_error;
1234: END IF;
1235: ELSE
1236: Process_resale (
1237: p_api_version => 1.0

Line 1238: ,p_init_msg_list => FND_API.G_FALSE

1234: END IF;
1235: ELSE
1236: Process_resale (
1237: p_api_version => 1.0
1238: ,p_init_msg_list => FND_API.G_FALSE
1239: ,p_commit => FND_API.G_FALSE
1240: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1241: ,p_resale_batch_id => p_resale_batch_id
1242: ,x_return_status => l_return_status

Line 1239: ,p_commit => FND_API.G_FALSE

1235: ELSE
1236: Process_resale (
1237: p_api_version => 1.0
1238: ,p_init_msg_list => FND_API.G_FALSE
1239: ,p_commit => FND_API.G_FALSE
1240: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1241: ,p_resale_batch_id => p_resale_batch_id
1242: ,x_return_status => l_return_status
1243: ,x_msg_data => l_msg_data

Line 1240: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1236: Process_resale (
1237: p_api_version => 1.0
1238: ,p_init_msg_list => FND_API.G_FALSE
1239: ,p_commit => FND_API.G_FALSE
1240: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1241: ,p_resale_batch_id => p_resale_batch_id
1242: ,x_return_status => l_return_status
1243: ,x_msg_data => l_msg_data
1244: ,x_msg_count => l_msg_count

Line 1246: IF l_return_status = FND_API.g_ret_sts_error THEN

1242: ,x_return_status => l_return_status
1243: ,x_msg_data => l_msg_data
1244: ,x_msg_count => l_msg_count
1245: );
1246: IF l_return_status = FND_API.g_ret_sts_error THEN
1247: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
1248: RAISE FND_API.g_exc_error;
1249: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1250: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');

Line 1248: RAISE FND_API.g_exc_error;

1244: ,x_msg_count => l_msg_count
1245: );
1246: IF l_return_status = FND_API.g_ret_sts_error THEN
1247: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
1248: RAISE FND_API.g_exc_error;
1249: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1250: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
1251: RAISE FND_API.g_exc_unexpected_error;
1252: END IF;

Line 1249: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1245: );
1246: IF l_return_status = FND_API.g_ret_sts_error THEN
1247: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
1248: RAISE FND_API.g_exc_error;
1249: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1250: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
1251: RAISE FND_API.g_exc_unexpected_error;
1252: END IF;
1253: END IF;

Line 1251: RAISE FND_API.g_exc_unexpected_error;

1247: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
1248: RAISE FND_API.g_exc_error;
1249: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1250: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
1251: RAISE FND_API.g_exc_unexpected_error;
1252: END IF;
1253: END IF;
1254:
1255: -- Debug Message

Line 1267: WHEN FND_API.g_exc_error THEN

1263:
1264: -- Write all messages to a log
1265: OZF_UTILITY_PVT.Write_Conc_Log;
1266: EXCEPTION
1267: WHEN FND_API.g_exc_error THEN
1268: OZF_UTILITY_PVT.Write_Conc_Log;
1269: ERRBUF := l_msg_data;
1270: RETCODE := 1;
1271:

Line 1272: WHEN FND_API.g_exc_unexpected_error THEN

1268: OZF_UTILITY_PVT.Write_Conc_Log;
1269: ERRBUF := l_msg_data;
1270: RETCODE := 1;
1271:
1272: WHEN FND_API.g_exc_unexpected_error THEN
1273: OZF_UTILITY_PVT.Write_Conc_Log;
1274: ERRBUF := l_msg_data;
1275: RETCODE := 2;
1276:

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

1294: --
1295: ---------------------------------------------------------------------
1296: PROCEDURE Purge(
1297: p_api_version IN NUMBER
1298: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1299: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1300: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1301: ,p_data_source_code IN VARCHAR2
1302: ,p_resale_batch_id IN NUMBER

Line 1299: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

1295: ---------------------------------------------------------------------
1296: PROCEDURE Purge(
1297: p_api_version IN NUMBER
1298: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1299: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1300: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1301: ,p_data_source_code IN VARCHAR2
1302: ,p_resale_batch_id IN NUMBER
1303: ,x_return_status OUT NOCOPY VARCHAR2

Line 1300: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

1296: PROCEDURE Purge(
1297: p_api_version IN NUMBER
1298: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1299: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1300: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1301: ,p_data_source_code IN VARCHAR2
1302: ,p_resale_batch_id IN NUMBER
1303: ,x_return_status OUT NOCOPY VARCHAR2
1304: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1316: IF NOT FND_API.Compatible_API_Call (

1312: BEGIN
1313: -- Standard begin of API savepoint
1314: SAVEPOINT Resale_Purge;
1315: -- Standard call to check for call compatibility.
1316: IF NOT FND_API.Compatible_API_Call (
1317: l_api_version,
1318: p_api_version,
1319: l_api_name,
1320: G_PKG_NAME)

Line 1322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1318: p_api_version,
1319: l_api_name,
1320: G_PKG_NAME)
1321: THEN
1322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1323: END IF;
1324:
1325: --Initialize message list if p_init_msg_list is TRUE.
1326: IF FND_API.To_Boolean (p_init_msg_list) THEN

Line 1326: IF FND_API.To_Boolean (p_init_msg_list) THEN

1322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1323: END IF;
1324:
1325: --Initialize message list if p_init_msg_list is TRUE.
1326: IF FND_API.To_Boolean (p_init_msg_list) THEN
1327: FND_MSG_PUB.initialize;
1328: END IF;
1329:
1330: -- Initialize API return status to sucess

Line 1331: x_return_status := FND_API.G_RET_STS_SUCCESS;

1327: FND_MSG_PUB.initialize;
1328: END IF;
1329:
1330: -- Initialize API return status to sucess
1331: x_return_status := FND_API.G_RET_STS_SUCCESS;
1332:
1333: -- Debug Message
1334: IF OZF_DEBUG_HIGH_ON THEN
1335: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');

Line 1357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1353: WHERE purge_flag IS NULL
1354: AND status_code = 'CLOSED';
1355: EXCEPTION
1356: WHEN OTHERS THEN
1357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1358: END;
1359: ELSE
1360: BEGIN
1361: DELETE FROM ozf_resale_lines_int_all a

Line 1378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1374: AND status_code = 'CLOSED'
1375: AND data_source_code = p_data_source_code;
1376: EXCEPTION
1377: WHEN OTHERS THEN
1378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1379: END;
1380: END IF;
1381: ELSE -- else (if p_batch_number is not null)
1382: -- Purge the records that have been successfully processed

Line 1400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1396: WHERE resale_batch_id = p_resale_batch_id
1397: AND status_code NOT IN ('CLOSED', 'PROCESSING', 'PENDING_PAYMENT');
1398: EXCEPTION
1399: WHEN OTHERS THEN
1400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1401: END;
1402: ELSE
1403: BEGIN
1404: DELETE FROM ozf_resale_lines_int_all a

Line 1420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1416: AND data_source_code = p_data_source_code
1417: AND status_code NOT IN ('CLOSED', 'PROCESSING', 'PENDING_PAYMENT');
1418: EXCEPTION
1419: WHEN OTHERS THEN
1420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1421: END;
1422: END IF;
1423: END IF;
1424:

Line 1432: p_encoded => FND_API.G_FALSE,

1428: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
1429: END IF;
1430: --Standard call to get message count and if count=1, get the message
1431: FND_MSG_PUB.Count_And_Get (
1432: p_encoded => FND_API.G_FALSE,
1433: p_count => x_msg_count,
1434: p_data => x_msg_data
1435: );
1436:

Line 1438: WHEN FND_API.G_EXC_ERROR THEN

1434: p_data => x_msg_data
1435: );
1436:
1437: EXCEPTION
1438: WHEN FND_API.G_EXC_ERROR THEN
1439: ROLLBACK TO Resale_Purge ;
1440:
1441: x_return_status := FND_API.G_RET_STS_ERROR;
1442: -- Standard call to get message count and if count=1, get the message

Line 1441: x_return_status := FND_API.G_RET_STS_ERROR;

1437: EXCEPTION
1438: WHEN FND_API.G_EXC_ERROR THEN
1439: ROLLBACK TO Resale_Purge ;
1440:
1441: x_return_status := FND_API.G_RET_STS_ERROR;
1442: -- Standard call to get message count and if count=1, get the message
1443: FND_MSG_PUB.Count_And_Get (
1444: p_encoded => FND_API.G_FALSE,
1445: p_count => x_msg_count,

Line 1444: p_encoded => FND_API.G_FALSE,

1440:
1441: x_return_status := FND_API.G_RET_STS_ERROR;
1442: -- Standard call to get message count and if count=1, get the message
1443: FND_MSG_PUB.Count_And_Get (
1444: p_encoded => FND_API.G_FALSE,
1445: p_count => x_msg_count,
1446: p_data => x_msg_data
1447: );
1448: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1448: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1444: p_encoded => FND_API.G_FALSE,
1445: p_count => x_msg_count,
1446: p_data => x_msg_data
1447: );
1448: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1449: ROLLBACK TO Resale_Purge;
1450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1451:
1452: -- Standard call to get message count and if count=1, get the message

Line 1450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1446: p_data => x_msg_data
1447: );
1448: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1449: ROLLBACK TO Resale_Purge;
1450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1451:
1452: -- Standard call to get message count and if count=1, get the message
1453: FND_MSG_PUB.Count_And_Get (
1454: p_encoded => FND_API.G_FALSE,

Line 1454: p_encoded => FND_API.G_FALSE,

1450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1451:
1452: -- Standard call to get message count and if count=1, get the message
1453: FND_MSG_PUB.Count_And_Get (
1454: p_encoded => FND_API.G_FALSE,
1455: p_count => x_msg_count,
1456: p_data => x_msg_data
1457: );
1458: WHEN OTHERS THEN

Line 1460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1456: p_data => x_msg_data
1457: );
1458: WHEN OTHERS THEN
1459: ROLLBACK TO Resale_Purge;
1460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1461:
1462: -- Standard call to get message count and if count=1, get the message
1463: FND_MSG_PUB.Count_And_Get (
1464: p_encoded => FND_API.G_FALSE,

Line 1464: p_encoded => FND_API.G_FALSE,

1460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1461:
1462: -- Standard call to get message count and if count=1, get the message
1463: FND_MSG_PUB.Count_And_Get (
1464: p_encoded => FND_API.G_FALSE,
1465: p_count => x_msg_count,
1466: p_data => x_msg_data
1467: );
1468: END Purge;

Line 1508: ,p_init_msg_list => FND_API.G_FALSE

1504: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- Start to purge processed order ---*/');
1505:
1506: Purge (
1507: p_api_version => 1.0
1508: ,p_init_msg_list => FND_API.G_FALSE
1509: ,p_commit => FND_API.G_FALSE
1510: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1511: ,p_data_source_code => p_data_source_code
1512: ,p_resale_batch_id => p_resale_batch_id

Line 1509: ,p_commit => FND_API.G_FALSE

1505:
1506: Purge (
1507: p_api_version => 1.0
1508: ,p_init_msg_list => FND_API.G_FALSE
1509: ,p_commit => FND_API.G_FALSE
1510: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1511: ,p_data_source_code => p_data_source_code
1512: ,p_resale_batch_id => p_resale_batch_id
1513: ,x_return_status => l_return_status

Line 1510: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1506: Purge (
1507: p_api_version => 1.0
1508: ,p_init_msg_list => FND_API.G_FALSE
1509: ,p_commit => FND_API.G_FALSE
1510: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1511: ,p_data_source_code => p_data_source_code
1512: ,p_resale_batch_id => p_resale_batch_id
1513: ,x_return_status => l_return_status
1514: ,x_msg_data => l_msg_data

Line 1517: IF l_return_status = FND_API.g_ret_sts_error THEN

1513: ,x_return_status => l_return_status
1514: ,x_msg_data => l_msg_data
1515: ,x_msg_count => l_msg_count
1516: );
1517: IF l_return_status = FND_API.g_ret_sts_error THEN
1518: ozf_utility_pvt.error_message('OZF_PURGE_CHG_INT_ERR');
1519: RAISE FND_API.g_exc_error;
1520: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1521: ozf_utility_pvt.error_message('OZF_PURGE_CHG_INT_ERR');

Line 1519: RAISE FND_API.g_exc_error;

1515: ,x_msg_count => l_msg_count
1516: );
1517: IF l_return_status = FND_API.g_ret_sts_error THEN
1518: ozf_utility_pvt.error_message('OZF_PURGE_CHG_INT_ERR');
1519: RAISE FND_API.g_exc_error;
1520: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1521: ozf_utility_pvt.error_message('OZF_PURGE_CHG_INT_ERR');
1522: RAISE FND_API.g_exc_unexpected_error;
1523: END IF;

Line 1520: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1516: );
1517: IF l_return_status = FND_API.g_ret_sts_error THEN
1518: ozf_utility_pvt.error_message('OZF_PURGE_CHG_INT_ERR');
1519: RAISE FND_API.g_exc_error;
1520: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1521: ozf_utility_pvt.error_message('OZF_PURGE_CHG_INT_ERR');
1522: RAISE FND_API.g_exc_unexpected_error;
1523: END IF;
1524:

Line 1522: RAISE FND_API.g_exc_unexpected_error;

1518: ozf_utility_pvt.error_message('OZF_PURGE_CHG_INT_ERR');
1519: RAISE FND_API.g_exc_error;
1520: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1521: ozf_utility_pvt.error_message('OZF_PURGE_CHG_INT_ERR');
1522: RAISE FND_API.g_exc_unexpected_error;
1523: END IF;
1524:
1525: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End of purge processed order ---*/');
1526:

Line 1535: WHEN FND_API.g_exc_error THEN

1531:
1532: -- Write all messages to a log
1533: OZF_UTILITY_PVT.Write_Conc_Log;
1534: EXCEPTION
1535: WHEN FND_API.g_exc_error THEN
1536: ROLLBACK TO Start_RESALE_Purge;
1537: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- Error happened during purge ---*/');
1538: OZF_UTILITY_PVT.Write_Conc_Log;
1539: ERRBUF := l_msg_data;

Line 1542: WHEN FND_API.g_exc_unexpected_error THEN

1538: OZF_UTILITY_PVT.Write_Conc_Log;
1539: ERRBUF := l_msg_data;
1540: RETCODE := 1;
1541:
1542: WHEN FND_API.g_exc_unexpected_error THEN
1543: ROLLBACK TO Start_RESALE_Purge;
1544: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- Error happened during purge ---*/');
1545: OZF_UTILITY_PVT.Write_Conc_Log;
1546: ERRBUF := l_msg_data;