DBA Data[Home] [Help]

APPS.AHL_FMP_MR_PUB dependencies on STANDARD

Line 37: -- Standard start of API savepoint

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

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

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

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

395: IF FND_API.TO_BOOLEAN(p_commit) THEN
396: COMMIT WORK;
397: END IF;
398:
399: -- Standard call to get message count and if count is 1, get message info
400: FND_MSG_PUB.count_and_get
401: (
402: p_count => x_msg_count,
403: p_data => x_msg_data,

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

480:
481: -- Initialize API return status to success
482: x_return_status := FND_API.G_RET_STS_SUCCESS;
483:
484: -- Standard call to check for call compatibility
485: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
486: THEN
487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
488: END IF;

Line 492: -- standard IN params

488: END IF;
489:
490: AHL_FMP_MR_PUB.Create_Mr
491: (
492: -- standard IN params
493: p_api_version => 2.0,
494: p_init_msg_list => p_init_msg_list,
495: p_commit => p_commit,
496: p_validation_level => p_validation_level,

Line 499: -- standard OUT params

495: p_commit => p_commit,
496: p_validation_level => p_validation_level,
497: p_default => p_default,
498: p_module_type => p_module_type,
499: -- standard OUT params
500: x_return_status => x_return_status,
501: x_msg_count => x_msg_count,
502: x_msg_data => x_msg_data,
503: -- procedure params

Line 579: -- Standard start of API savepoint

575:
576: l_mr_header_rec AHL_FMP_MR_HEADER_PVT.mr_header_rec := p_mr_header_rec;
577:
578: BEGIN
579: -- Standard start of API savepoint
580: SAVEPOINT Modify_Mr_SP;
581:
582: -- Standard call to check for call compatibility
583: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)

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

578: BEGIN
579: -- Standard start of API savepoint
580: SAVEPOINT Modify_Mr_SP;
581:
582: -- Standard call to check for call compatibility
583: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
584: THEN
585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
586: END IF;

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

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

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

1022:
1023: -- Initialize API return status to success
1024: x_return_status := FND_API.G_RET_STS_SUCCESS;
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 1034: -- standard IN params

1030: END IF;
1031:
1032: AHL_FMP_MR_PUB.Modify_Mr
1033: (
1034: -- standard IN params
1035: p_api_version => 2.0,
1036: p_init_msg_list => p_init_msg_list,
1037: p_commit => p_commit,
1038: p_validation_level => p_validation_level,

Line 1041: -- standard OUT params

1037: p_commit => p_commit,
1038: p_validation_level => p_validation_level,
1039: p_default => p_default,
1040: p_module_type => p_module_type,
1041: -- standard OUT params
1042: x_return_status => x_return_status,
1043: x_msg_count => x_msg_count,
1044: x_msg_data => x_msg_data,
1045: -- procedure params

Line 1088: -- standard IN params

1084: END Modify_Mr;
1085:
1086: PROCEDURE Delete_Mr
1087: (
1088: -- standard IN params
1089: p_api_version IN NUMBER,
1090: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
1091: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
1092: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

Line 1095: -- standard OUT params

1091: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
1092: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
1093: p_default IN VARCHAR2 :=FND_API.G_FALSE,
1094: p_module_type IN VARCHAR2 :=NULL,
1095: -- standard OUT params
1096: x_return_status OUT NOCOPY VARCHAR2,
1097: x_msg_count OUT NOCOPY NUMBER,
1098: x_msg_data OUT NOCOPY VARCHAR2,
1099: -- procedure params

Line 1117: -- Standard start of API savepoint

1113:
1114: l_mr_header_id NUMBER := p_mr_header_id;
1115:
1116: BEGIN
1117: -- Standard start of API savepoint
1118: SAVEPOINT Delete_Mr_SP;
1119:
1120: -- Standard call to check for call compatibility
1121: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)

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

1116: BEGIN
1117: -- Standard start of API savepoint
1118: SAVEPOINT Delete_Mr_SP;
1119:
1120: -- Standard call to check for call compatibility
1121: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1122: THEN
1123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1124: END IF;

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

1214: IF FND_API.TO_BOOLEAN(p_commit) THEN
1215: COMMIT WORK;
1216: END IF;
1217:
1218: -- Standard call to get message count and if count is 1, get message info
1219: FND_MSG_PUB.count_and_get
1220: (
1221: p_count => x_msg_count,
1222: p_data => x_msg_data,

Line 1270: -- standard IN params

1266: END Delete_Mr;
1267:
1268: PROCEDURE Create_Mr_Revision
1269: (
1270: -- standard IN params
1271: p_api_version IN NUMBER,
1272: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
1273: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
1274: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

Line 1277: -- standard OUT params

1273: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
1274: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
1275: p_default IN VARCHAR2 :=FND_API.G_FALSE,
1276: p_module_type IN VARCHAR2 :=NULL,
1277: -- standard OUT params
1278: x_return_status OUT NOCOPY VARCHAR2,
1279: x_msg_count OUT NOCOPY NUMBER,
1280: x_msg_data OUT NOCOPY VARCHAR2,
1281: -- procedure params

Line 1300: -- Standard start of API savepoint

1296:
1297: l_mr_header_id NUMBER := p_mr_header_id;
1298:
1299: BEGIN
1300: -- Standard start of API savepoint
1301: SAVEPOINT Create_Mr_Revision_SP;
1302:
1303: -- Standard call to check for call compatibility
1304: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)

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

1299: BEGIN
1300: -- Standard start of API savepoint
1301: SAVEPOINT Create_Mr_Revision_SP;
1302:
1303: -- Standard call to check for call compatibility
1304: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1305: THEN
1306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1307: END IF;

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

1399: IF FND_API.TO_BOOLEAN(p_commit) THEN
1400: COMMIT WORK;
1401: END IF;
1402:
1403: -- Standard call to get message count and if count is 1, get message info
1404: FND_MSG_PUB.count_and_get
1405: (
1406: p_count => x_msg_count,
1407: p_data => x_msg_data,

Line 1455: -- standard IN params

1451: END Create_Mr_Revision;
1452:
1453: PROCEDURE Initiate_Mr_Approval
1454: (
1455: -- standard IN params
1456: p_api_version IN NUMBER,
1457: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
1458: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
1459: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

Line 1462: -- standard OUT params

1458: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
1459: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
1460: p_default IN VARCHAR2 :=FND_API.G_FALSE,
1461: p_module_type IN VARCHAR2 :=NULL,
1462: -- standard OUT params
1463: x_return_status OUT NOCOPY VARCHAR2,
1464: x_msg_count OUT NOCOPY NUMBER,
1465: x_msg_data OUT NOCOPY VARCHAR2,
1466: -- procedure params

Line 1485: -- Standard start of API savepoint

1481:
1482: l_mr_header_id NUMBER := p_mr_header_id;
1483:
1484: BEGIN
1485: -- Standard start of API savepoint
1486: SAVEPOINT Initiate_Mr_Approval_SP;
1487:
1488: -- Standard call to check for call compatibility
1489: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)

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

1484: BEGIN
1485: -- Standard start of API savepoint
1486: SAVEPOINT Initiate_Mr_Approval_SP;
1487:
1488: -- Standard call to check for call compatibility
1489: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1490: THEN
1491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1492: END IF;

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

1583: IF FND_API.TO_BOOLEAN(p_commit) THEN
1584: COMMIT WORK;
1585: END IF;
1586:
1587: -- Standard call to get message count and if count is 1, get message info
1588: FND_MSG_PUB.count_and_get
1589: (
1590: p_count => x_msg_count,
1591: p_data => x_msg_data,

Line 1663: -- Standard start of API savepoint

1659: l_msg_data VARCHAR2(2000);
1660: L_DEBUG_MODULE CONSTANT VARCHAR2(100) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
1661:
1662: BEGIN
1663: -- Standard start of API savepoint
1664: SAVEPOINT Process_Mr_Route_Seq_SP;
1665:
1666: -- Standard call to check for call compatibility
1667: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)

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

1662: BEGIN
1663: -- Standard start of API savepoint
1664: SAVEPOINT Process_Mr_Route_Seq_SP;
1665:
1666: -- Standard call to check for call compatibility
1667: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1668: THEN
1669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1670: END IF;

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

1737: IF FND_API.TO_BOOLEAN(p_commit) THEN
1738: COMMIT WORK;
1739: END IF;
1740:
1741: -- Standard call to get message count and if count is 1, get message info
1742: FND_MSG_PUB.count_and_get
1743: (
1744: p_count => x_msg_count,
1745: p_data => x_msg_data,

Line 1793: -- standard IN params

1789: END Process_Mr_Route_Seq;
1790:
1791: PROCEDURE Process_Mr_Effectivities
1792: (
1793: -- standard IN params
1794: p_api_version IN NUMBER,
1795: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
1796: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
1797: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

Line 1800: -- standard OUT params

1796: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
1797: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
1798: p_default IN VARCHAR2 :=FND_API.G_FALSE,
1799: p_module_type IN VARCHAR2 :=NULL,
1800: -- standard OUT params
1801: x_return_status OUT NOCOPY VARCHAR2,
1802: x_msg_count OUT NOCOPY NUMBER,
1803: x_msg_data OUT NOCOPY VARCHAR2,
1804: -- procedure params

Line 1829: -- Standard start of API savepoint

1825: l_mr_header_id NUMBER := p_mr_header_id;
1826: l_mr_effectivity_id NUMBER := p_mr_effectivity_id;
1827:
1828: BEGIN
1829: -- Standard start of API savepoint
1830: SAVEPOINT Process_Mr_Effectivities_SP;
1831:
1832: -- Standard call to check for call compatibility
1833: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)

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

1828: BEGIN
1829: -- Standard start of API savepoint
1830: SAVEPOINT Process_Mr_Effectivities_SP;
1831:
1832: -- Standard call to check for call compatibility
1833: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1834: THEN
1835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1836: END IF;

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

1985: IF FND_API.TO_BOOLEAN(p_commit) THEN
1986: COMMIT WORK;
1987: END IF;
1988:
1989: -- Standard call to get message count and if count is 1, get message info
1990: FND_MSG_PUB.count_and_get
1991: (
1992: p_count => x_msg_count,
1993: p_data => x_msg_data,