DBA Data[Home] [Help]

APPS.AHL_MC_RULE_STMT_PVT dependencies on STANDARD

Line 92: -- Standard call to check for call compatibility

88: --
89: BEGIN
90: -- Initialize Procedure return status to success
91: x_return_status := FND_API.G_RET_STS_SUCCESS;
92: -- Standard call to check for call compatibility
93: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
94: G_PKG_NAME) THEN
95: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
96: END IF;

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

363: x_msg_count := FND_MSG_PUB.count_msg;
364: IF x_msg_count > 0 THEN
365: RAISE FND_API.G_EXC_ERROR;
366: END IF;
367: -- Standard call to get message count and if count is 1, get message info
368: FND_MSG_PUB.Count_And_Get
369: ( p_count => x_msg_count,
370: p_data => x_msg_data,
371: p_encoded => fnd_api.g_false

Line 428: -- Standard start of API savepoint

424: l_api_version CONSTANT NUMBER := 1.0;
425: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Rule_Stmt';
426: --
427: BEGIN
428: -- Standard start of API savepoint
429: SAVEPOINT Insert_Rule_Stmt_pvt;
430: -- Initialize Procedure return status to success
431: x_return_status := FND_API.G_RET_STS_SUCCESS;
432: -- Standard call to check for call compatibility

Line 432: -- Standard call to check for call compatibility

428: -- Standard start of API savepoint
429: SAVEPOINT Insert_Rule_Stmt_pvt;
430: -- Initialize Procedure return status to success
431: x_return_status := FND_API.G_RET_STS_SUCCESS;
432: -- Standard call to check for call compatibility
433: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
434: G_PKG_NAME) THEN
435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
436: END IF;

Line 613: -- Standard check of p_commit

609: p_x_rule_stmt_rec.ATTRIBUTE15
610: )
611: RETURNING object_version_number INTO p_x_rule_stmt_rec.object_version_number;
612:
613: -- Standard check of p_commit
614: IF FND_API.TO_BOOLEAN(p_commit) THEN
615: COMMIT WORK;
616: END IF;
617: -- Standard call to get message count and if count is 1, get message info

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

613: -- Standard check of p_commit
614: IF FND_API.TO_BOOLEAN(p_commit) THEN
615: COMMIT WORK;
616: END IF;
617: -- Standard call to get message count and if count is 1, get message info
618: FND_MSG_PUB.Count_And_Get
619: ( p_count => x_msg_count,
620: p_data => x_msg_data,
621: p_encoded => fnd_api.g_false

Line 684: -- Standard start of API savepoint

680: l_old_rstmt_rec ahl_mc_rule_stmt_csr%ROWTYPE;
681: l_rule_stmt_rec AHL_MC_RULE_PVT.Rule_Stmt_Rec_Type;
682: --
683: BEGIN
684: -- Standard start of API savepoint
685: SAVEPOINT Update_Rule_Stmt_pvt;
686: -- Initialize Procedure return status to success
687: x_return_status := FND_API.G_RET_STS_SUCCESS;
688: -- Standard call to check for call compatibility

Line 688: -- Standard call to check for call compatibility

684: -- Standard start of API savepoint
685: SAVEPOINT Update_Rule_Stmt_pvt;
686: -- Initialize Procedure return status to success
687: x_return_status := FND_API.G_RET_STS_SUCCESS;
688: -- Standard call to check for call compatibility
689: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
690: G_PKG_NAME) THEN
691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
692: END IF;

Line 888: -- Standard check of p_commit

884: ATTRIBUTE14 = l_rule_stmt_rec.ATTRIBUTE14,
885: ATTRIBUTE15 = l_rule_stmt_rec.ATTRIBUTE15
886: WHERE RULE_STATEMENT_ID = l_rule_stmt_rec.rule_statement_id;
887:
888: -- Standard check of p_commit
889: IF FND_API.TO_BOOLEAN(p_commit) THEN
890: COMMIT WORK;
891: END IF;
892: -- Standard call to get message count and if count is 1, get message info

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

888: -- Standard check of p_commit
889: IF FND_API.TO_BOOLEAN(p_commit) THEN
890: COMMIT WORK;
891: END IF;
892: -- Standard call to get message count and if count is 1, get message info
893: FND_MSG_PUB.Count_And_Get
894: ( p_count => x_msg_count,
895: p_data => x_msg_data,
896: p_encoded => fnd_api.g_false);

Line 964: -- Standard start of API savepoint

960: l_new_subject_id NUMBER;
961: l_new_object_id NUMBER;
962: --
963: BEGIN
964: -- Standard start of API savepoint
965: SAVEPOINT Copy_Rule_Stmt_pvt;
966: -- Initialize Procedure return status to success
967: x_return_status := FND_API.G_RET_STS_SUCCESS;
968: -- Standard call to check for call compatibility

Line 968: -- Standard call to check for call compatibility

964: -- Standard start of API savepoint
965: SAVEPOINT Copy_Rule_Stmt_pvt;
966: -- Initialize Procedure return status to success
967: x_return_status := FND_API.G_RET_STS_SUCCESS;
968: -- Standard call to check for call compatibility
969: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
970: G_PKG_NAME) THEN
971: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
972: END IF;

Line 1178: -- Standard check of p_commit

1174: x_rule_stmt_id := l_rstmt_rec.rule_statement_id;
1175: END IF;
1176: CLOSE get_rule_stmt_csr;
1177:
1178: -- Standard check of p_commit
1179: IF FND_API.TO_BOOLEAN(p_commit) THEN
1180: COMMIT WORK;
1181: END IF;
1182: -- Standard call to get message count and if count is 1, get message info

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

1178: -- Standard check of p_commit
1179: IF FND_API.TO_BOOLEAN(p_commit) THEN
1180: COMMIT WORK;
1181: END IF;
1182: -- Standard call to get message count and if count is 1, get message info
1183: FND_MSG_PUB.Count_And_Get
1184: ( p_count => x_msg_count,
1185: p_data => x_msg_data,
1186: p_encoded => fnd_api.g_false

Line 1246: -- Standard start of API savepoint

1242: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Rule_Stmts';
1243: l_stmt_id NUMBER;
1244: --
1245: BEGIN
1246: -- Standard start of API savepoint
1247: SAVEPOINT Delete_Rule_Stmts_pvt;
1248: -- Initialize Procedure return status to success
1249: x_return_status := FND_API.G_RET_STS_SUCCESS;
1250: -- Standard call to check for call compatibility

Line 1250: -- Standard call to check for call compatibility

1246: -- Standard start of API savepoint
1247: SAVEPOINT Delete_Rule_Stmts_pvt;
1248: -- Initialize Procedure return status to success
1249: x_return_status := FND_API.G_RET_STS_SUCCESS;
1250: -- Standard call to check for call compatibility
1251: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1252: G_PKG_NAME) THEN
1253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1254: END IF;

Line 1281: -- Standard check of p_commit

1277:
1278: END LOOP;
1279: CLOSE ahl_rule_stmts_csr;
1280:
1281: -- Standard check of p_commit
1282: IF FND_API.TO_BOOLEAN(p_commit) THEN
1283: COMMIT WORK;
1284: END IF;
1285: -- Standard call to get message count and if count is 1, get message info

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

1281: -- Standard check of p_commit
1282: IF FND_API.TO_BOOLEAN(p_commit) THEN
1283: COMMIT WORK;
1284: END IF;
1285: -- Standard call to get message count and if count is 1, get message info
1286: FND_MSG_PUB.Count_And_Get
1287: ( p_count => x_msg_count,
1288: p_data => x_msg_data,
1289: p_encoded => fnd_api.g_false

Line 1556: -- Standard call to check for call compatibility

1552: --
1553: BEGIN
1554: -- Initialize Procedure return status to success
1555: x_return_status := FND_API.G_RET_STS_SUCCESS;
1556: -- Standard call to check for call compatibility
1557: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1558: G_PKG_NAME) THEN
1559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1560: END IF;

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

1626: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)THEN
1627: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,L_DEBUG_KEY||'.end','At the end of PLSQL procedure');
1628: END IF;
1629:
1630: -- Standard call to get message count and if count is 1, get message info
1631: FND_MSG_PUB.Count_And_Get
1632: ( p_count => x_msg_count,
1633: p_data => x_msg_data,
1634: p_encoded => fnd_api.g_false