DBA Data[Home] [Help]

APPS.AHL_FMP_MR_PUB dependencies on STANDARD

Line 35: -- Standard start of API savepoint

31: l_msg_data VARCHAR2(2000);
32: L_DEBUG_MODULE CONSTANT VARCHAR2(100) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
33:
34: BEGIN
35: -- Standard start of API savepoint
36: SAVEPOINT Create_Mr_SP;
37:
38: -- Standard call to check for call compatibility
39: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)

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

34: BEGIN
35: -- Standard start of API savepoint
36: SAVEPOINT Create_Mr_SP;
37:
38: -- Standard call to check for call compatibility
39: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
40: THEN
41: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
42: END IF;

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

350: IF FND_API.TO_BOOLEAN(p_commit) THEN
351: COMMIT WORK;
352: END IF;
353:
354: -- Standard call to get message count and if count is 1, get message info
355: FND_MSG_PUB.count_and_get
356: (
357: p_count => x_msg_count,
358: p_data => x_msg_data,

Line 437: -- Standard start of API savepoint

433:
434: l_mr_header_rec AHL_FMP_MR_HEADER_PVT.mr_header_rec := p_mr_header_rec;
435:
436: BEGIN
437: -- Standard start of API savepoint
438: SAVEPOINT Modify_Mr_SP;
439:
440: -- Standard call to check for call compatibility
441: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)

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

436: BEGIN
437: -- Standard start of API savepoint
438: SAVEPOINT Modify_Mr_SP;
439:
440: -- Standard call to check for call compatibility
441: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
442: THEN
443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
444: END IF;

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

755: IF FND_API.TO_BOOLEAN(p_commit) THEN
756: COMMIT WORK;
757: END IF;
758:
759: -- Standard call to get message count and if count is 1, get message info
760: FND_MSG_PUB.count_and_get
761: (
762: p_count => x_msg_count,
763: p_data => x_msg_data,

Line 811: -- standard IN params

807: END Modify_Mr;
808:
809: PROCEDURE Delete_Mr
810: (
811: -- standard IN params
812: p_api_version IN NUMBER,
813: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
814: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
815: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

Line 818: -- standard OUT params

814: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
815: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
816: p_default IN VARCHAR2 :=FND_API.G_FALSE,
817: p_module_type IN VARCHAR2 :=NULL,
818: -- standard OUT params
819: x_return_status OUT NOCOPY VARCHAR2,
820: x_msg_count OUT NOCOPY NUMBER,
821: x_msg_data OUT NOCOPY VARCHAR2,
822: -- procedure params

Line 840: -- Standard start of API savepoint

836:
837: l_mr_header_id NUMBER := p_mr_header_id;
838:
839: BEGIN
840: -- Standard start of API savepoint
841: SAVEPOINT Delete_Mr_SP;
842:
843: -- Standard call to check for call compatibility
844: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)

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

839: BEGIN
840: -- Standard start of API savepoint
841: SAVEPOINT Delete_Mr_SP;
842:
843: -- Standard call to check for call compatibility
844: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
845: THEN
846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
847: END IF;

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

937: IF FND_API.TO_BOOLEAN(p_commit) THEN
938: COMMIT WORK;
939: END IF;
940:
941: -- Standard call to get message count and if count is 1, get message info
942: FND_MSG_PUB.count_and_get
943: (
944: p_count => x_msg_count,
945: p_data => x_msg_data,

Line 993: -- standard IN params

989: END Delete_Mr;
990:
991: PROCEDURE Create_Mr_Revision
992: (
993: -- standard IN params
994: p_api_version IN NUMBER,
995: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
996: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
997: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

Line 1000: -- standard OUT params

996: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
997: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
998: p_default IN VARCHAR2 :=FND_API.G_FALSE,
999: p_module_type IN VARCHAR2 :=NULL,
1000: -- standard OUT params
1001: x_return_status OUT NOCOPY VARCHAR2,
1002: x_msg_count OUT NOCOPY NUMBER,
1003: x_msg_data OUT NOCOPY VARCHAR2,
1004: -- procedure params

Line 1023: -- Standard start of API savepoint

1019:
1020: l_mr_header_id NUMBER := p_mr_header_id;
1021:
1022: BEGIN
1023: -- Standard start of API savepoint
1024: SAVEPOINT Create_Mr_Revision_SP;
1025:
1026: -- Standard call to check for call compatibility
1027: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)

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

1022: BEGIN
1023: -- Standard start of API savepoint
1024: SAVEPOINT Create_Mr_Revision_SP;
1025:
1026: -- Standard call to check for call compatibility
1027: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1028: THEN
1029: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1030: END IF;

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

1122: IF FND_API.TO_BOOLEAN(p_commit) THEN
1123: COMMIT WORK;
1124: END IF;
1125:
1126: -- Standard call to get message count and if count is 1, get message info
1127: FND_MSG_PUB.count_and_get
1128: (
1129: p_count => x_msg_count,
1130: p_data => x_msg_data,

Line 1178: -- standard IN params

1174: END Create_Mr_Revision;
1175:
1176: PROCEDURE Initiate_Mr_Approval
1177: (
1178: -- standard IN params
1179: p_api_version IN NUMBER,
1180: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
1181: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
1182: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

Line 1185: -- standard OUT params

1181: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
1182: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
1183: p_default IN VARCHAR2 :=FND_API.G_FALSE,
1184: p_module_type IN VARCHAR2 :=NULL,
1185: -- standard OUT params
1186: x_return_status OUT NOCOPY VARCHAR2,
1187: x_msg_count OUT NOCOPY NUMBER,
1188: x_msg_data OUT NOCOPY VARCHAR2,
1189: -- procedure params

Line 1208: -- Standard start of API savepoint

1204:
1205: l_mr_header_id NUMBER := p_mr_header_id;
1206:
1207: BEGIN
1208: -- Standard start of API savepoint
1209: SAVEPOINT Initiate_Mr_Approval_SP;
1210:
1211: -- Standard call to check for call compatibility
1212: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)

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

1207: BEGIN
1208: -- Standard start of API savepoint
1209: SAVEPOINT Initiate_Mr_Approval_SP;
1210:
1211: -- Standard call to check for call compatibility
1212: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1213: THEN
1214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1215: END IF;

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

1306: IF FND_API.TO_BOOLEAN(p_commit) THEN
1307: COMMIT WORK;
1308: END IF;
1309:
1310: -- Standard call to get message count and if count is 1, get message info
1311: FND_MSG_PUB.count_and_get
1312: (
1313: p_count => x_msg_count,
1314: p_data => x_msg_data,

Line 1386: -- Standard start of API savepoint

1382: l_msg_data VARCHAR2(2000);
1383: L_DEBUG_MODULE CONSTANT VARCHAR2(100) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
1384:
1385: BEGIN
1386: -- Standard start of API savepoint
1387: SAVEPOINT Process_Mr_Route_Seq_SP;
1388:
1389: -- Standard call to check for call compatibility
1390: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)

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

1385: BEGIN
1386: -- Standard start of API savepoint
1387: SAVEPOINT Process_Mr_Route_Seq_SP;
1388:
1389: -- Standard call to check for call compatibility
1390: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1391: THEN
1392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1393: END IF;

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

1460: IF FND_API.TO_BOOLEAN(p_commit) THEN
1461: COMMIT WORK;
1462: END IF;
1463:
1464: -- Standard call to get message count and if count is 1, get message info
1465: FND_MSG_PUB.count_and_get
1466: (
1467: p_count => x_msg_count,
1468: p_data => x_msg_data,

Line 1516: -- standard IN params

1512: END Process_Mr_Route_Seq;
1513:
1514: PROCEDURE Process_Mr_Effectivities
1515: (
1516: -- standard IN params
1517: p_api_version IN NUMBER,
1518: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
1519: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
1520: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

Line 1523: -- standard OUT params

1519: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
1520: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
1521: p_default IN VARCHAR2 :=FND_API.G_FALSE,
1522: p_module_type IN VARCHAR2 :=NULL,
1523: -- standard OUT params
1524: x_return_status OUT NOCOPY VARCHAR2,
1525: x_msg_count OUT NOCOPY NUMBER,
1526: x_msg_data OUT NOCOPY VARCHAR2,
1527: -- procedure params

Line 1551: -- Standard start of API savepoint

1547: l_mr_header_id NUMBER := p_mr_header_id;
1548: l_mr_effectivity_id NUMBER := p_mr_effectivity_id;
1549:
1550: BEGIN
1551: -- Standard start of API savepoint
1552: SAVEPOINT Process_Mr_Effectivities_SP;
1553:
1554: -- Standard call to check for call compatibility
1555: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)

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

1550: BEGIN
1551: -- Standard start of API savepoint
1552: SAVEPOINT Process_Mr_Effectivities_SP;
1553:
1554: -- Standard call to check for call compatibility
1555: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1556: THEN
1557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1558: END IF;

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

1706: IF FND_API.TO_BOOLEAN(p_commit) THEN
1707: COMMIT WORK;
1708: END IF;
1709:
1710: -- Standard call to get message count and if count is 1, get message info
1711: FND_MSG_PUB.count_and_get
1712: (
1713: p_count => x_msg_count,
1714: p_data => x_msg_data,