DBA Data[Home] [Help]

APPS.OZF_TP_ACCRUAL_PVT dependencies on STANDARD

Line 164: -- Standard begin of API savepoint

160: l_status_code varchar2(30);
161: l_org_id NUMBER;
162:
163: BEGIN
164: -- Standard begin of API savepoint
165: -- Standard call to check for call compatibility.
166: IF NOT FND_API.Compatible_API_Call (
167: l_api_version,
168: p_api_version,

Line 165: -- Standard call to check for call compatibility.

161: l_org_id NUMBER;
162:
163: BEGIN
164: -- Standard begin of API savepoint
165: -- Standard call to check for call compatibility.
166: IF NOT FND_API.Compatible_API_Call (
167: l_api_version,
168: p_api_version,
169: l_api_name,

Line 242: --Standard call to get message count and if count=1, get the message

238: IF OZF_DEBUG_HIGH_ON THEN
239: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
240: END IF;
241:
242: --Standard call to get message count and if count=1, get the message
243: FND_MSG_PUB.Count_And_Get (
244: p_encoded => FND_API.G_FALSE,
245: p_count => x_msg_count,
246: p_data => x_msg_data

Line 251: -- Standard call to get message count and if count=1, get the message

247: );
248: EXCEPTION
249: WHEN FND_API.G_EXC_ERROR THEN
250: x_return_status := FND_API.G_RET_STS_ERROR;
251: -- Standard call to get message count and if count=1, get the message
252: FND_MSG_PUB.Count_And_Get (
253: p_encoded => FND_API.G_FALSE,
254: p_count => x_msg_count,
255: p_data => x_msg_data

Line 259: -- Standard call to get message count and if count=1, get the message

255: p_data => x_msg_data
256: );
257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
259: -- Standard call to get message count and if count=1, get the message
260: FND_MSG_PUB.Count_And_Get (
261: p_encoded => FND_API.G_FALSE,
262: p_count => x_msg_count,
263: p_data => x_msg_data

Line 268: -- Standard call to get message count and if count=1, get the message

264: );
265: WHEN OTHERS THEN
266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
267:
268: -- Standard call to get message count and if count=1, get the message
269: FND_MSG_PUB.Count_And_Get (
270: p_encoded => FND_API.G_FALSE,
271: p_count => x_msg_count,
272: p_data => x_msg_data

Line 306: -- Standard BEGIN of API savepoint

302: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| l_api_name;
303: --
304:
305: BEGIN
306: -- Standard BEGIN of API savepoint
307: -- Standard call to check for call compatibility.
308: IF NOT FND_API.Compatible_API_Call (
309: l_api_version,
310: p_api_version,

Line 307: -- Standard call to check for call compatibility.

303: --
304:
305: BEGIN
306: -- Standard BEGIN of API savepoint
307: -- Standard call to check for call compatibility.
308: IF NOT FND_API.Compatible_API_Call (
309: l_api_version,
310: p_api_version,
311: l_api_name,

Line 427: --Standard call to get message count and if count=1, get the message

423: -- Debug Message
424: IF OZF_DEBUG_HIGH_ON THEN
425: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
426: END IF;
427: --Standard call to get message count and if count=1, get the message
428: FND_MSG_PUB.Count_And_Get (
429: p_encoded => FND_API.G_FALSE,
430: p_count => x_msg_count,
431: p_data => x_msg_data

Line 436: -- Standard call to get message count and if count=1, get the message

432: );
433: EXCEPTION
434: WHEN FND_API.G_EXC_ERROR THEN
435: x_return_status := FND_API.G_RET_STS_ERROR;
436: -- Standard call to get message count and if count=1, get the message
437: FND_MSG_PUB.Count_And_Get (
438: p_encoded => FND_API.G_FALSE,
439: p_count => x_msg_count,
440: p_data => x_msg_data

Line 444: -- Standard call to get message count and if count=1, get the message

440: p_data => x_msg_data
441: );
442: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
444: -- Standard call to get message count and if count=1, get the message
445: FND_MSG_PUB.Count_And_Get (
446: p_encoded => FND_API.G_FALSE,
447: p_count => x_msg_count,
448: p_data => x_msg_data

Line 453: -- Standard call to get message count and if count=1, get the message

449: );
450: WHEN OTHERS THEN
451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
452:
453: -- Standard call to get message count and if count=1, get the message
454: FND_MSG_PUB.Count_And_Get (
455: p_encoded => FND_API.G_FALSE,
456: p_count => x_msg_count,
457: p_data => x_msg_data

Line 2407: -- Standard BEGIN of API savepoint

2403: l_ozf_funds_new_tbl OZF_UTILITY_PVT.ozf_funds_table;
2404: x_fund_update_status VARCHAR2(30) := OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED;
2405: x_budget_update_status VARCHAR2(30) := OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED;
2406: BEGIN
2407: -- Standard BEGIN of API savepoint
2408: SAVEPOINT Process_Resale_Order;
2409: -- Standard call to check for call compatibility.
2410: IF NOT FND_API.Compatible_API_Call (
2411: l_api_version,

Line 2409: -- Standard call to check for call compatibility.

2405: x_budget_update_status VARCHAR2(30) := OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED;
2406: BEGIN
2407: -- Standard BEGIN of API savepoint
2408: SAVEPOINT Process_Resale_Order;
2409: -- Standard call to check for call compatibility.
2410: IF NOT FND_API.Compatible_API_Call (
2411: l_api_version,
2412: p_api_version,
2413: l_api_name,

Line 2997: --Standard call to get message count and if count=1, get the message

2993:
2994: IF OZF_DEBUG_HIGH_ON THEN
2995: OZF_UTILITY_PVT.debug_message(l_full_name||': End'|| x_return_status);
2996: END IF;
2997: --Standard call to get message count and if count=1, get the message
2998: FND_MSG_PUB.Count_And_Get (
2999: p_encoded => FND_API.G_FALSE,
3000: p_count => x_msg_count,
3001: p_data => x_msg_data

Line 3007: -- Standard call to get message count and if count=1, get the message

3003: EXCEPTION
3004: WHEN FND_API.G_EXC_ERROR THEN
3005: ROLLBACK TO Process_Resale_Order;
3006: x_return_status := FND_API.G_RET_STS_ERROR;
3007: -- Standard call to get message count and if count=1, get the message
3008: FND_MSG_PUB.Count_And_Get (
3009: p_encoded => FND_API.G_FALSE,
3010: p_count => x_msg_count,
3011: p_data => x_msg_data

Line 3017: -- Standard call to get message count and if count=1, get the message

3013: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3014: ROLLBACK TO Process_Resale_Order;
3015: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3016:
3017: -- Standard call to get message count and if count=1, get the message
3018: FND_MSG_PUB.Count_And_Get (
3019: p_encoded => FND_API.G_FALSE,
3020: p_count => x_msg_count,
3021: p_data => x_msg_data

Line 3027: -- Standard call to get message count and if count=1, get the message

3023: WHEN OTHERS THEN
3024: ROLLBACK TO Process_Resale_Order;
3025: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3026:
3027: -- Standard call to get message count and if count=1, get the message
3028: FND_MSG_PUB.Count_And_Get (
3029: p_encoded => FND_API.G_FALSE,
3030: p_count => x_msg_count,
3031: p_data => x_msg_data

Line 3066: -- Standard BEGIN of API savepoint

3062: l_msg_data VARCHAR2(2000);
3063: l_msg_count NUMBER;
3064:
3065: BEGIN
3066: -- Standard BEGIN of API savepoint
3067: SAVEPOINT PROCESS_TP_RESALE;
3068: -- Standard call to check for call compatibility.
3069: IF NOT FND_API.Compatible_API_Call (
3070: l_api_version,

Line 3068: -- Standard call to check for call compatibility.

3064:
3065: BEGIN
3066: -- Standard BEGIN of API savepoint
3067: SAVEPOINT PROCESS_TP_RESALE;
3068: -- Standard call to check for call compatibility.
3069: IF NOT FND_API.Compatible_API_Call (
3070: l_api_version,
3071: p_api_version,
3072: l_api_name,

Line 3149: --Standard call to get message count and if count=1, get the message

3145: -- Debug Message
3146: IF OZF_DEBUG_HIGH_ON THEN
3147: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
3148: END IF;
3149: --Standard call to get message count and if count=1, get the message
3150: FND_MSG_PUB.Count_And_Get (
3151: p_encoded => FND_API.G_FALSE,
3152: p_count => x_msg_count,
3153: p_data => x_msg_data

Line 3160: -- Standard call to get message count and if count=1, get the message

3156: EXCEPTION
3157: WHEN FND_API.G_EXC_ERROR THEN
3158: ROLLBACK TO PROCESS_TP_RESALE;
3159: x_return_status := FND_API.G_RET_STS_ERROR;
3160: -- Standard call to get message count and if count=1, get the message
3161: FND_MSG_PUB.Count_And_Get (
3162: p_encoded => FND_API.G_FALSE,
3163: p_count => x_msg_count,
3164: p_data => x_msg_data

Line 3170: -- Standard call to get message count and if count=1, get the message

3166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3167: ROLLBACK TO PROCESS_TP_RESALE;
3168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3169:
3170: -- Standard call to get message count and if count=1, get the message
3171: FND_MSG_PUB.Count_And_Get (
3172: p_encoded => FND_API.G_FALSE,
3173: p_count => x_msg_count,
3174: p_data => x_msg_data

Line 3180: -- Standard call to get message count and if count=1, get the message

3176: WHEN OTHERS THEN
3177: ROLLBACK TO PROCESS_TP_RESALE;
3178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3179:
3180: -- Standard call to get message count and if count=1, get the message
3181: FND_MSG_PUB.Count_And_Get (
3182: p_encoded => FND_API.G_FALSE,
3183: p_count => x_msg_count,
3184: p_data => x_msg_data

Line 3273: -- Standard BEGIN of API savepoint

3269:
3270: j NUMBER;
3271: k NUMBER;
3272: BEGIN
3273: -- Standard BEGIN of API savepoint
3274: SAVEPOINT TP_ACCRUAL_MV_IC;
3275: -- Standard call to check for call compatibility.
3276: IF NOT FND_API.Compatible_API_Call (
3277: l_api_version,

Line 3275: -- Standard call to check for call compatibility.

3271: k NUMBER;
3272: BEGIN
3273: -- Standard BEGIN of API savepoint
3274: SAVEPOINT TP_ACCRUAL_MV_IC;
3275: -- Standard call to check for call compatibility.
3276: IF NOT FND_API.Compatible_API_Call (
3277: l_api_version,
3278: p_api_version,
3279: l_api_name,

Line 3421: --Standard call to get message count and if count=1, get the message

3417: IF OZF_DEBUG_HIGH_ON THEN
3418: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
3419: END IF;
3420:
3421: --Standard call to get message count and if count=1, get the message
3422: FND_MSG_PUB.Count_And_Get (
3423: p_encoded => FND_API.G_FALSE,
3424: p_count => x_msg_count,
3425: p_data => x_msg_data

Line 3430: -- Standard call to get message count and if count=1, get the message

3426: );
3427: EXCEPTION
3428: WHEN FND_API.G_EXC_ERROR THEN
3429: x_return_status := FND_API.G_RET_STS_ERROR;
3430: -- Standard call to get message count and if count=1, get the message
3431: FND_MSG_PUB.Count_And_Get (
3432: p_encoded => FND_API.G_FALSE,
3433: p_count => x_msg_count,
3434: p_data => x_msg_data

Line 3439: -- Standard call to get message count and if count=1, get the message

3435: );
3436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3438:
3439: -- Standard call to get message count and if count=1, get the message
3440: FND_MSG_PUB.Count_And_Get (
3441: p_encoded => FND_API.G_FALSE,
3442: p_count => x_msg_count,
3443: p_data => x_msg_data

Line 3449: -- Standard call to get message count and if count=1, get the message

3445: WHEN OTHERS THEN
3446: ROLLBACK TO TP_ACCRUAL_MV_IC;
3447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3448:
3449: -- Standard call to get message count and if count=1, get the message
3450: FND_MSG_PUB.Count_And_Get (
3451: p_encoded => FND_API.G_FALSE,
3452: p_count => x_msg_count,
3453: p_data => x_msg_data

Line 3650: -- Standard BEGIN of API savepoint

3646: x_fund_update_status VARCHAR2(30) := OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED;
3647: x_budget_update_status VARCHAR2(30) := OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED;
3648: l_ozf_draft_accrual_rec ozf_draft_accrual_rec_type;
3649: BEGIN
3650: -- Standard BEGIN of API savepoint
3651: SAVEPOINT Process_Order;
3652: -- Standard call to check for call compatibility.
3653: IF NOT FND_API.Compatible_API_Call (
3654: l_api_version,

Line 3652: -- Standard call to check for call compatibility.

3648: l_ozf_draft_accrual_rec ozf_draft_accrual_rec_type;
3649: BEGIN
3650: -- Standard BEGIN of API savepoint
3651: SAVEPOINT Process_Order;
3652: -- Standard call to check for call compatibility.
3653: IF NOT FND_API.Compatible_API_Call (
3654: l_api_version,
3655: p_api_version,
3656: l_api_name,

Line 4581: --Standard call to get message count and if count=1, get the message

4577: -- Debug Message
4578: IF OZF_DEBUG_HIGH_ON THEN
4579: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': end');
4580: END IF;
4581: --Standard call to get message count and if count=1, get the message
4582: FND_MSG_PUB.Count_And_Get (
4583: p_encoded => FND_API.G_FALSE,
4584: p_count => x_msg_count,
4585: p_data => x_msg_data

Line 4592: -- Standard call to get message count and if count=1, get the message

4588: EXCEPTION
4589: WHEN FND_API.G_EXC_ERROR THEN
4590: ozf_utility_pvt.write_conc_log('ERROR in Process_Order');
4591: x_return_status := FND_API.G_RET_STS_ERROR;
4592: -- Standard call to get message count and if count=1, get the message
4593: FND_MSG_PUB.Count_And_Get (
4594: p_encoded => FND_API.G_FALSE,
4595: p_count => x_msg_count,
4596: p_data => x_msg_data

Line 4603: -- Standard call to get message count and if count=1, get the message

4599: ozf_utility_pvt.write_conc_log('UNEXP ERROR in Process_Order');
4600: --ROLLBACK TO Process_Order;
4601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4602:
4603: -- Standard call to get message count and if count=1, get the message
4604: FND_MSG_PUB.Count_And_Get (
4605: p_encoded => FND_API.G_FALSE,
4606: p_count => x_msg_count,
4607: p_data => x_msg_data

Line 4614: -- Standard call to get message count and if count=1, get the message

4610: ozf_utility_pvt.write_conc_log('OTHER ERROR in Process_Order ' || SQLERRM);
4611: --ROLLBACK TO Process_Order;
4612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4613:
4614: -- Standard call to get message count and if count=1, get the message
4615: FND_MSG_PUB.Count_And_Get (
4616: p_encoded => FND_API.G_FALSE,
4617: p_count => x_msg_count,
4618: p_data => x_msg_data

Line 4819: -- Standard BEGIN of API savepoint

4815: l_processed_lines_count NUMBER;
4816: -- TPA iN Draft Mode - end
4817:
4818: BEGIN
4819: -- Standard BEGIN of API savepoint
4820: SAVEPOINT Process_TP_ACCRUAL;
4821:
4822: -- new code - TPA iN Draft Mode
4823: l_return := fnd_installation.get_app_info('OZF', l_status, l_industry, l_schema);

Line 4825: -- Standard call to check for call compatibility.

4821:
4822: -- new code - TPA iN Draft Mode
4823: l_return := fnd_installation.get_app_info('OZF', l_status, l_industry, l_schema);
4824:
4825: -- Standard call to check for call compatibility.
4826: IF NOT FND_API.Compatible_API_Call (
4827: l_api_version,
4828: p_api_version,
4829: l_api_name,

Line 5667: --Standard call to get message count and if count=1, get the message

5663: -- Debug Message
5664: IF OZF_DEBUG_HIGH_ON THEN
5665: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
5666: END IF;
5667: --Standard call to get message count and if count=1, get the message
5668: FND_MSG_PUB.Count_And_Get (
5669: p_encoded => FND_API.G_FALSE,
5670: p_count => x_msg_count,
5671: p_data => x_msg_data

Line 5678: -- Standard call to get message count and if count=1, get the message

5674: EXCEPTION
5675: WHEN FND_API.G_EXC_ERROR THEN
5676: ozf_utility_pvt.write_conc_log('ERROR in Process_TP_ACCRUAL: '|| SQLERRM);
5677: x_return_status := FND_API.G_RET_STS_ERROR;
5678: -- Standard call to get message count and if count=1, get the message
5679: FND_MSG_PUB.Count_And_Get (
5680: p_encoded => FND_API.G_FALSE,
5681: p_count => x_msg_count,
5682: p_data => x_msg_data

Line 5688: -- Standard call to get message count and if count=1, get the message

5684: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5685: ozf_utility_pvt.write_conc_log('UNEXPECTED ERROR in Process_TP_ACCRUAL: '|| SQLERRM);
5686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5687:
5688: -- Standard call to get message count and if count=1, get the message
5689: FND_MSG_PUB.Count_And_Get (
5690: p_encoded => FND_API.G_FALSE,
5691: p_count => x_msg_count,
5692: p_data => x_msg_data

Line 5699: -- Standard call to get message count and if count=1, get the message

5695: ozf_utility_pvt.write_conc_log('OTHER ERROR in Process_TP_ACCRUAL: '|| SQLERRM);
5696: --ROLLBACK TO Process_TP_ACCRUAL;
5697: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5698:
5699: -- Standard call to get message count and if count=1, get the message
5700: FND_MSG_PUB.Count_And_Get (
5701: p_encoded => FND_API.G_FALSE,
5702: p_count => x_msg_count,
5703: p_data => x_msg_data