DBA Data[Home] [Help]

APPS.OZF_CLAIMS_HISTORY_PVT dependencies on STANDARD

Line 956: -- Standard Start of API savepoint

952: l_msg_data varchar2(2000);
953: l_msg_count number;
954:
955: BEGIN
956: -- Standard Start of API savepoint
957: SAVEPOINT CREATE_CLAIMS_HISTORY_PVT;
958: -- Standard call to check for call compatibility.
959: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
960: p_api_version_number,

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

954:
955: BEGIN
956: -- Standard Start of API savepoint
957: SAVEPOINT CREATE_CLAIMS_HISTORY_PVT;
958: -- Standard call to check for call compatibility.
959: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
960: p_api_version_number,
961: l_api_name,
962: G_PKG_NAME)

Line 1180: -- Standard check for p_commit

1176: END;
1177:
1178: x_claim_history_id := l_claim_history_id;
1179:
1180: -- Standard check for p_commit
1181: IF FND_API.to_Boolean( p_commit ) THEN
1182: COMMIT WORK;
1183: END IF;
1184:

Line 1191: -- Standard call to get message count and if count is 1, get message info.

1187: FND_MESSAGE.Set_Token('TEXT',l_api_name||': End');
1188: FND_MSG_PUB.Add;
1189: END IF;
1190:
1191: -- Standard call to get message count and if count is 1, get message info.
1192: FND_MSG_PUB.Count_And_Get(
1193: p_count => x_msg_count,
1194: p_data => x_msg_data
1195: );

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

1199: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1200: WHEN FND_API.G_EXC_ERROR THEN
1201: ROLLBACK TO CREATE_Claims_History_PVT;
1202: x_return_status := FND_API.G_RET_STS_ERROR;
1203: -- Standard call to get message count and if count=1, get the message
1204: FND_MSG_PUB.Count_And_Get (
1205: p_encoded => FND_API.G_FALSE,
1206: p_count => x_msg_count,
1207: p_data => x_msg_data

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

1208: );
1209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1210: ROLLBACK TO CREATE_Claims_History_PVT;
1211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1212: -- Standard call to get message count and if count=1, get the message
1213: FND_MSG_PUB.Count_And_Get (
1214: p_encoded => FND_API.G_FALSE,
1215: p_count => x_msg_count,
1216: p_data => x_msg_data

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

1220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1221: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1222: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1223: END IF;
1224: -- Standard call to get message count and if count=1, get the message
1225: FND_MSG_PUB.Count_And_Get (
1226: p_encoded => FND_API.G_FALSE,
1227: p_count => x_msg_count,
1228: p_data => x_msg_data

Line 2376: -- Standard Start of API savepoint

2372: FROM ozf_claims_history_all
2373: WHERE claim_history_id = p_claim_history_id;
2374:
2375: BEGIN
2376: -- Standard Start of API savepoint
2377: SAVEPOINT DELETE_CLAIMS_HISTORY_PVT;
2378:
2379: -- Standard call to check for call compatibility.
2380: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

2375: BEGIN
2376: -- Standard Start of API savepoint
2377: SAVEPOINT DELETE_CLAIMS_HISTORY_PVT;
2378:
2379: -- Standard call to check for call compatibility.
2380: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2381: p_api_version_number,
2382: l_api_name,
2383: G_PKG_NAME)

Line 2436: -- Standard check for p_commit

2432: --
2433: -- End of API body
2434: --
2435:
2436: -- Standard check for p_commit
2437: IF FND_API.to_Boolean( p_commit )
2438: THEN
2439: COMMIT WORK;
2440: END IF;

Line 2449: -- Standard call to get message count and if count is 1, get message info.

2445: FND_MESSAGE.Set_Token('TEXT',l_api_name||': End');
2446: FND_MSG_PUB.Add;
2447: END IF;
2448:
2449: -- Standard call to get message count and if count is 1, get message info.
2450: FND_MSG_PUB.Count_And_Get
2451: (p_count => x_msg_count,
2452: p_data => x_msg_data
2453: );

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

2454: EXCEPTION
2455: WHEN FND_API.G_EXC_ERROR THEN
2456: ROLLBACK TO DELETE_CLAIMS_HISTORY_PVT;
2457: x_return_status := FND_API.G_RET_STS_ERROR;
2458: -- Standard call to get message count and if count=1, get the message
2459: FND_MSG_PUB.Count_And_Get (
2460: p_encoded => FND_API.G_FALSE,
2461: p_count => x_msg_count,
2462: p_data => x_msg_data

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

2463: );
2464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2465: ROLLBACK TO DELETE_CLAIMS_HISTORY_PVT;
2466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2467: -- Standard call to get message count and if count=1, get the message
2468: FND_MSG_PUB.Count_And_Get (
2469: p_encoded => FND_API.G_FALSE,
2470: p_count => x_msg_count,
2471: p_data => x_msg_data

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

2476: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2477: THEN
2478: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2479: END IF;
2480: -- Standard call to get message count and if count=1, get the message
2481: FND_MSG_PUB.Count_And_Get (
2482: p_encoded => FND_API.G_FALSE,
2483: p_count => x_msg_count,
2484: p_data => x_msg_data

Line 2531: -- Standard Start of API savepoint

2527: where claim_history_id = p_id;
2528:
2529:
2530: BEGIN
2531: -- Standard Start of API savepoint
2532: SAVEPOINT UPDATE_CLAIMS_HISTORY_PVT;
2533:
2534: -- Standard call to check for call compatibility.
2535: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

2530: BEGIN
2531: -- Standard Start of API savepoint
2532: SAVEPOINT UPDATE_CLAIMS_HISTORY_PVT;
2533:
2534: -- Standard call to check for call compatibility.
2535: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2536: p_api_version_number,
2537: l_api_name,
2538: G_PKG_NAME)

Line 2765: -- Standard check for p_commit

2761: END IF;
2762: RAISE FND_API.g_exc_error;
2763: END;
2764:
2765: -- Standard check for p_commit
2766: IF FND_API.to_Boolean( p_commit )
2767: THEN
2768: COMMIT WORK;
2769: END IF;

Line 2779: -- Standard call to get message count and if count is 1, get message info.

2775: FND_MESSAGE.Set_Token('TEXT',l_api_name||': End');
2776: FND_MSG_PUB.Add;
2777: END IF;
2778:
2779: -- Standard call to get message count and if count is 1, get message info.
2780: FND_MSG_PUB.Count_And_Get
2781: (p_count => x_msg_count,
2782: p_data => x_msg_data
2783: );

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

2784: EXCEPTION
2785: WHEN FND_API.G_EXC_ERROR THEN
2786: ROLLBACK TO UPDATE_CLAIMS_HISTORY_PVT;
2787: x_return_status := FND_API.G_RET_STS_ERROR;
2788: -- Standard call to get message count and if count=1, get the message
2789: FND_MSG_PUB.Count_And_Get (
2790: p_encoded => FND_API.G_FALSE,
2791: p_count => x_msg_count,
2792: p_data => x_msg_data

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

2793: );
2794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2795: ROLLBACK TO UPDATE_CLAIMS_HISTORY_PVT;
2796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2797: -- Standard call to get message count and if count=1, get the message
2798: FND_MSG_PUB.Count_And_Get (
2799: p_encoded => FND_API.G_FALSE,
2800: p_count => x_msg_count,
2801: p_data => x_msg_data

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

2806: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2807: THEN
2808: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2809: END IF;
2810: -- Standard call to get message count and if count=1, get the message
2811: FND_MSG_PUB.Count_And_Get (
2812: p_encoded => FND_API.G_FALSE,
2813: p_count => x_msg_count,
2814: p_data => x_msg_data

Line 2847: -- Standard Start of API savepoint

2843: l_api_version_number CONSTANT NUMBER := 1.0;
2844: l_object_version_number NUMBER;
2845:
2846: BEGIN
2847: -- Standard Start of API savepoint
2848: SAVEPOINT VALIDATE_CLAIMS_HISTORY_PVT;
2849:
2850: -- Standard call to check for call compatibility.
2851: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

2846: BEGIN
2847: -- Standard Start of API savepoint
2848: SAVEPOINT VALIDATE_CLAIMS_HISTORY_PVT;
2849:
2850: -- Standard call to check for call compatibility.
2851: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2852: p_api_version_number,
2853: l_api_name,
2854: G_PKG_NAME)

Line 2892: -- Standard call to get message count and if count is 1, get message info.

2888: FND_MESSAGE.Set_Token('TEXT',l_api_name||': End');
2889: FND_MSG_PUB.Add;
2890: END IF;
2891:
2892: -- Standard call to get message count and if count is 1, get message info.
2893: FND_MSG_PUB.Count_And_Get
2894: (p_count => x_msg_count,
2895: p_data => x_msg_data
2896: );

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

2897: EXCEPTION
2898: WHEN FND_API.G_EXC_ERROR THEN
2899: ROLLBACK TO VALIDATE_CLAIMS_HISTORY_PVT;
2900: x_return_status := FND_API.G_RET_STS_ERROR;
2901: -- Standard call to get message count and if count=1, get the message
2902: FND_MSG_PUB.Count_And_Get (
2903: p_encoded => FND_API.G_FALSE,
2904: p_count => x_msg_count,
2905: p_data => x_msg_data

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

2906: );
2907: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2908: ROLLBACK TO VALIDATE_CLAIMS_HISTORY_PVT;
2909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2910: -- Standard call to get message count and if count=1, get the message
2911: FND_MSG_PUB.Count_And_Get (
2912: p_encoded => FND_API.G_FALSE,
2913: p_count => x_msg_count,
2914: p_data => x_msg_data

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

2919: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2920: THEN
2921: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2922: END IF;
2923: -- Standard call to get message count and if count=1, get the message
2924: FND_MSG_PUB.Count_And_Get (
2925: p_encoded => FND_API.G_FALSE,
2926: p_count => x_msg_count,
2927: p_data => x_msg_data