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 2374: -- Standard Start of API savepoint

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

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

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

Line 2434: -- Standard check for p_commit

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

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

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

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

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

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

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

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

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

Line 2529: -- Standard Start of API savepoint

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

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

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

Line 2763: -- Standard check for p_commit

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

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

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

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

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

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

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

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

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

Line 2845: -- Standard Start of API savepoint

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

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

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

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

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

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

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

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

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

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

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