eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_MM_MTL_MGT_PVT dependencies on STANDARD

Line 123: -- Standard OUT Parameters :

119: -- for the cMRO Workoder/Operation demand.
120: -- Pre-reqs :
121: -- Parameters :
122: --
123: -- Standard OUT Parameters :
124: -- x_return_status OUT VARCHAR2 Required
125: --
126: -- Check_Material_Aval Parameters :
127: -- p_schedule_material_id_tbl : Table containing Schedule material requirement id of the demand.

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

176:
177: -- Initialize API return status to success
178: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
179:
180: -- Standard call to check for call compatibility.
181: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION, P_API_VERSION, L_API_NAME, G_PKG_NAME) THEN
182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
183: END IF;
184:

Line 262: -- Standard OUT Parameters :

258: -- for the cMRO Workoder/Operation demand.
259: -- Pre-reqs :
260: -- Parameters :
261: --
262: -- Standard OUT Parameters :
263: -- x_return_status OUT VARCHAR2 Required
264: --
265: -- Check_Material_Aval Parameters :
266: -- p_schedule_material_id_tbl : Table containing Schedule material requirement id of the demand.

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

324:
325: -- Initialize API return status to success
326: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
327:
328: -- Standard call to check for call compatibility.
329: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION, P_API_VERSION, L_API_NAME, G_PKG_NAME) THEN
330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
331: END IF;
332:

Line 414: -- Standard IN Parameters :

410: --
411: -- Pre-reqs :
412: -- Parameters :
413: --
414: -- Standard IN Parameters :
415: -- p_api_version IN NUMBER Required
416: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
417: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
418: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 422: -- Standard OUT Parameters :

418: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
419: -- Based on this flag, the API will set the default attributes.
420: -- p_module_type In VARCHAR2 Default NULL
421: -- This will be null.
422: -- Standard OUT Parameters :
423: -- x_return_status OUT VARCHAR2 Required
424: -- x_msg_count OUT NUMBER Required
425: -- x_msg_data OUT VARCHAR2 Required
426: --

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

461:
462: -- Initialize API return status to success
463: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
464:
465: -- Standard call to check for call compatibility.
466: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION, P_API_VERSION, L_API_NAME, G_PKG_NAME) THEN
467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
468: END IF;
469:

Line 709: -- Standard start of API savepoint

705: l_mark_serial_success NUMBER;
706:
707: BEGIN
708:
709: -- Standard start of API savepoint
710: SAVEPOINT CREATE_MOVE_ORDER_SP;
711: IF (l_log_procedure >= l_log_current_level) THEN
712: FND_LOG.string(l_log_procedure, L_DEBUG || '.begin',
713: 'At the start of the PLSQL procedure CREATE_MOVE_ORDER');

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

715:
716: -- Initialize API return status to success
717: x_return_status := FND_API.G_RET_STS_SUCCESS;
718:
719: -- Standard call to check for call compatibility.
720: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
722: END IF;
723:

Line 1114: --Standard check for commit

1110: ELSE
1111: x_mo_hdr_id := l_to_hdr_rec.header_id;
1112: END IF;
1113:
1114: --Standard check for commit
1115: IF (FND_API.TO_BOOLEAN(p_commit) AND x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1116: COMMIT;
1117: END IF;
1118:

Line 1212: -- Standard start of API savepoint

1208: l_return_status VARCHAR2(1);
1209: l_err_msg VARCHAR2(2000);
1210: l_msg_index_out NUMBER;
1211: BEGIN
1212: -- Standard start of API savepoint
1213: SAVEPOINT FLAG_REQUIREMENTS_SP;
1214:
1215: --Initialize error message stack by default
1216: FND_MSG_PUB.Initialize;

Line 1312: --Standard check before commit, committing every call to SCHEDULE_MATERIALS

1308: --And reset counters
1309: i := 1;
1310: k := 1;
1311:
1312: --Standard check before commit, committing every call to SCHEDULE_MATERIALS
1313: IF(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1314: --Commit all changes and replace the old savepoint
1315: COMMIT;
1316: SAVEPOINT FLAG_REQUIREMENTS_SP;

Line 1367: --Standard check before commit

1363: END LOOP;
1364:
1365: END IF; -- l_p_sch_mtl_id_tbl IS NOT NULL
1366:
1367: --Standard check before commit
1368: IF(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1369: COMMIT;
1370: ELSE
1371: ROLLBACK TO FLAG_REQUIREMENTS_SP;

Line 1488: -- Standard Start of API savepoint

1484: l_workorder_name AHL_WORKORDERS.WORKORDER_NAME%TYPE;
1485:
1486: BEGIN
1487: --------------------Initialize ----------------------------------
1488: -- Standard Start of API savepoint
1489: SAVEPOINT Invoke_AOG_Upd_Notification;
1490: -- Initialize message list if p_init_msg_list is set to TRUE.
1491: IF FND_API.to_boolean(p_init_msg_list)
1492: THEN

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

1493: FND_MSG_PUB.initialize;
1494: END IF;
1495: -- Initialize API return status to success
1496: x_return_status := FND_API.G_RET_STS_SUCCESS;
1497: -- Standard call to check for call compatibility.
1498: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1499: p_api_version,
1500: l_api_name,G_PKG_NAME)
1501: THEN

Line 1645: -- Standard check of p_commit

1641: x_msg_count := l_msg_count;
1642: x_return_status := FND_API.G_RET_STS_ERROR;
1643: RAISE Fnd_Api.G_EXC_ERROR;
1644: END IF;
1645: -- Standard check of p_commit
1646: IF FND_API.TO_BOOLEAN(p_commit) THEN
1647: COMMIT;
1648: END IF;
1649: EXCEPTION

Line 1694: -- Standard IN Parameters :

1690: -- Type : Private
1691: -- Description : This procedure is called for creating Internal Sales Orders.
1692: -- Pre-reqs :
1693: --
1694: -- Standard IN Parameters :
1695: -- p_api_version NUMBER := 1.0
1696: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
1697: -- p_commit VARCHAR2 := FND_API.G_FALSE
1698: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL

Line 1700: -- Standard OUT Parameters :

1696: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
1697: -- p_commit VARCHAR2 := FND_API.G_FALSE
1698: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
1699: --
1700: -- Standard OUT Parameters :
1701: -- x_return_status VARCHAR2 Required
1702: -- x_msg_count NUMBER Required
1703: -- x_msg_data VARCHAR2 Required
1704: --

Line 1722: -- Standard IN params

1718: -- X_RESERVATION_ID NUMBER: The Reservation Id
1719: --
1720: -- End of Comments --
1721: PROCEDURE CREATE_INTERNAL_SALES_ORDER(
1722: -- Standard IN params
1723: P_API_VERSION IN NUMBER,
1724: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1725: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1726: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

Line 1727: -- Standard OUT params

1723: P_API_VERSION IN NUMBER,
1724: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1725: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1726: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1727: -- Standard OUT params
1728: X_MSG_COUNT OUT NOCOPY NUMBER,
1729: X_MSG_DATA OUT NOCOPY VARCHAR2,
1730: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1731: -- Procedure IN, OUT, IN/OUT params

Line 1940: -- Standard IN Parameters :

1936: -- Type : Private
1937: -- Description : This procedure is called for creating Internal Sales Orders.
1938: -- Pre-reqs :
1939: --
1940: -- Standard IN Parameters :
1941: -- p_api_version NUMBER := 1.0
1942: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
1943: -- p_commit VARCHAR2 := FND_API.G_FALSE
1944: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL

Line 1946: -- Standard OUT Parameters :

1942: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
1943: -- p_commit VARCHAR2 := FND_API.G_FALSE
1944: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
1945: --
1946: -- Standard OUT Parameters :
1947: -- x_return_status VARCHAR2 Required
1948: -- x_msg_count NUMBER Required
1949: -- x_msg_data VARCHAR2 Required
1950: --

Line 2048: -- standard check for API compatibility.

2044: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
2045: Fnd_Log.STRING(G_LEVEL_PROCEDURE, l_api_name,'Begin API');
2046: END IF;
2047:
2048: -- standard check for API compatibility.
2049: IF NOT Fnd_Api.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2050: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
2051: END IF;
2052: IF Fnd_Api.to_Boolean(p_init_msg_list) THEN

Line 2661: -- Standard OUT Parameters :

2657: -- Description : This procedure is called for creating reservation against the IR.
2658: -- Pre-reqs :
2659: --
2660: --
2661: -- Standard OUT Parameters :
2662: -- x_return_status VARCHAR2 Required
2663: -- x_msg_count NUMBER Required
2664: -- x_msg_data VARCHAR2 Required
2665: --

Line 2753: -- Standard IN Parameters :

2749: -- Type : Private
2750: -- Description : This procedure is called for creating Internal Sales Orders.
2751: -- Pre-reqs :
2752: --
2753: -- Standard IN Parameters :
2754: -- p_api_version NUMBER := 1.0
2755: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
2756: -- p_commit VARCHAR2 := FND_API.G_FALSE
2757: --

Line 2758: -- Standard OUT Parameters :

2754: -- p_api_version NUMBER := 1.0
2755: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
2756: -- p_commit VARCHAR2 := FND_API.G_FALSE
2757: --
2758: -- Standard OUT Parameters :
2759: -- x_return_status VARCHAR2 Required
2760: -- x_msg_count NUMBER Required
2761: -- x_msg_data VARCHAR2 Required
2762: --

Line 2937: -- Standard IN Parameters :

2933: -- Type : Private
2934: -- Description : This procedure is called for creating Internal Sales Orders.
2935: -- Pre-reqs :
2936: --
2937: -- Standard IN Parameters :
2938: -- p_api_version NUMBER := 1.0
2939: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
2940: -- p_commit VARCHAR2 := FND_API.G_FALSE
2941: --

Line 2942: -- Standard OUT Parameters :

2938: -- p_api_version NUMBER := 1.0
2939: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
2940: -- p_commit VARCHAR2 := FND_API.G_FALSE
2941: --
2942: -- Standard OUT Parameters :
2943: -- x_return_status VARCHAR2 Required
2944: -- x_msg_count NUMBER Required
2945: -- x_msg_data VARCHAR2 Required
2946: --

Line 3046: -- standard check for API compatibility.

3042: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
3043: fnd_log.string(G_LEVEL_PROCEDURE, l_api_name,'Begin API');
3044: END IF;
3045:
3046: -- standard check for API compatibility.
3047: IF NOT Fnd_Api.Compatible_API_Call
3048: (l_api_version,
3049: p_api_version,
3050: l_api_name,

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

3765:
3766: -- Initialize API return status to success
3767: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3768:
3769: -- Standard call to check for call compatibility.
3770: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION, P_API_VERSION, L_API_NAME, G_PKG_NAME) THEN
3771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3772: END IF;
3773:

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

3897:
3898: -- Initialize API return status to success
3899: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3900:
3901: -- Standard call to check for call compatibility.
3902: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION, P_API_VERSION, L_API_NAME, G_PKG_NAME) THEN
3903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3904: END IF;
3905:

Line 3993: -- 2. x_return_status - OUT Standard out parameter

3989: -- and the validation continued.
3990: -- Pre-reqs :
3991: -- Parameters :
3992: -- 1. p_x_mtltfr_rec - IN OUT Material Transfer Record Required
3993: -- 2. x_return_status - OUT Standard out parameter
3994: -- 3. x_msg_count - OUT Standard out parameter
3995: -- 4. x_msg_data - OUT Standard out parameter
3996: -- Validate_Record Parameters
3997: -- p_x_mtltfr_rec IN OUT Material Transfer Record Required

Line 3994: -- 3. x_msg_count - OUT Standard out parameter

3990: -- Pre-reqs :
3991: -- Parameters :
3992: -- 1. p_x_mtltfr_rec - IN OUT Material Transfer Record Required
3993: -- 2. x_return_status - OUT Standard out parameter
3994: -- 3. x_msg_count - OUT Standard out parameter
3995: -- 4. x_msg_data - OUT Standard out parameter
3996: -- Validate_Record Parameters
3997: -- p_x_mtltfr_rec IN OUT Material Transfer Record Required
3998: --

Line 3995: -- 4. x_msg_data - OUT Standard out parameter

3991: -- Parameters :
3992: -- 1. p_x_mtltfr_rec - IN OUT Material Transfer Record Required
3993: -- 2. x_return_status - OUT Standard out parameter
3994: -- 3. x_msg_count - OUT Standard out parameter
3995: -- 4. x_msg_data - OUT Standard out parameter
3996: -- Validate_Record Parameters
3997: -- p_x_mtltfr_rec IN OUT Material Transfer Record Required
3998: --
3999: -- End of Comments

Line 4020: -- 5. x_return_status - OUT Standard out parameter

4016: -- 1. p_x_mtltfr_rec - IN OUT Material Transfer Record Required
4017: -- 2. p_x_txn_hdr_id - IN OUT Transaction Header Id
4018: -- 3. p_x_txn_intf_id - IN OUT Transaction Interface Id
4019: -- 4. p_shipping_type - IN Shipping type
4020: -- 5. x_return_status - OUT Standard out parameter
4021: -- End of Comments
4022: -------------------------------------------------------------------------------------
4023: PROCEDURE Insert_Material
4024: (

Line 4048: -- Standard IN Parameters :

4044: --
4045: -- Pre-reqs : The item should be only serial controlled and should not be locator controlled
4046: -- in the source/destination organization.
4047: --
4048: -- Standard IN Parameters :
4049: -- p_api_version NUMBER := 1.0
4050: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
4051: -- p_commit VARCHAR2 := FND_API.G_FALSE
4052: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL

Line 4056: -- Standard OUT Parameters :

4052: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
4053: -- p_default VARCHAR2 := FND_API.G_FALSE
4054: -- p_module_type VARCHAR2 := NULL
4055: --
4056: -- Standard OUT Parameters :
4057: -- p_x_return_status VARCHAR2 Required
4058: -- p_x_msg_count NUMBER Required
4059: -- p_x_msg_data VARCHAR2 Required
4060: --

Line 4077: -- Standard IN params

4073: -- End of Comments --
4074: --------------------------------------------------------------------------------------------------------
4075: PROCEDURE Perform_Inter_Org_Transfer
4076: (
4077: -- Standard IN params
4078: p_api_version IN NUMBER := 1.0,
4079: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4080: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4081: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

Line 4084: -- Standard OUT params

4080: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4081: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4082: p_default IN VARCHAR2 := FND_API.G_FALSE,
4083: p_module_type IN VARCHAR2 := NULL,
4084: -- Standard OUT params
4085: x_return_status OUT NOCOPY VARCHAR2,
4086: x_msg_count OUT NOCOPY NUMBER,
4087: x_msg_data OUT NOCOPY VARCHAR2,
4088: -- Procedure IN, OUT, IN/OUT params

Line 4131: -- Standard start of API savepoint

4127: IF FND_API.To_Boolean(p_init_msg_list) THEN
4128: FND_MSG_PUB.Initialize;
4129: END IF;
4130:
4131: -- Standard start of API savepoint
4132: SAVEPOINT Perform_Inter_Org_Transfer;
4133: G_DEBUG_LINE_NUM := 15;
4134:
4135: -- Check whether the input table type is valid

Line 4337: -- Standard check of p_commit

4333: END IF;
4334: END IF;
4335: G_DEBUG_LINE_NUM := 90;
4336: -- Perform Commit
4337: -- Standard check of p_commit
4338: IF FND_API.To_Boolean(p_commit) THEN
4339: COMMIT ;
4340: END IF;
4341: IF (l_log_statement >= l_log_current_level) THEN

Line 4383: -- Standard IN Parameters :

4379: -- Description : This procedure is called for the actual transfer in inventory. This does
4380: -- perform any reservation
4381: -- Pre-reqs :
4382: --
4383: -- Standard IN Parameters :
4384: -- p_api_version NUMBER := 1.0
4385: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
4386: -- p_commit VARCHAR2 := FND_API.G_FALSE
4387: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL

Line 4391: -- Standard OUT Parameters :

4387: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
4388: -- p_default VARCHAR2 := FND_API.G_FALSE
4389: -- p_module_type VARCHAR2 := NULL
4390: --
4391: -- Standard OUT Parameters :
4392: -- x_return_status VARCHAR2 Required
4393: -- x_msg_count NUMBER Required
4394: -- x_msg_data VARCHAR2 Required
4395: --

Line 4408: -- Standard IN params

4404: -- End of Comments --
4405: ------------------------------------------------------------------------------------------------------
4406: PROCEDURE Perform_Inter_Org_Transfer_Inv
4407: (
4408: -- Standard IN params
4409: p_api_version IN NUMBER := 1.0,
4410: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4411: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4412: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

Line 4415: -- Standard OUT params

4411: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4412: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4413: p_default IN VARCHAR2 := FND_API.G_FALSE,
4414: p_module_type IN VARCHAR2 := NULL,
4415: -- Standard OUT params
4416: x_return_status OUT NOCOPY VARCHAR2,
4417: x_msg_count OUT NOCOPY NUMBER,
4418: x_msg_data OUT NOCOPY VARCHAR2,
4419: -- Procedure IN, OUT, IN/OUT params

Line 4422: -- Standard variables

4418: x_msg_data OUT NOCOPY VARCHAR2,
4419: -- Procedure IN, OUT, IN/OUT params
4420: p_x_mtltfr_tbl IN OUT NOCOPY Ahl_Mtltfr_Tbl_Type )
4421: IS
4422: -- Standard variables
4423: ----------------------
4424:
4425: -- Constants
4426: l_api_version CONSTANT NUMBER := 1.0;

Line 4474: -- Standard start of API savepoint

4470: IF (p_x_mtltfr_tbl IS NOT NULL) THEN
4471: FND_LOG.STRING(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':Input record count ='||p_x_mtltfr_tbl.COUNT);
4472: END IF;
4473: END IF;
4474: -- Standard start of API savepoint
4475: SAVEPOINT Perform_Inter_Org_Transfer_Inv;
4476: -- Standard call to check for call compatibility
4477: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4472: END IF;
4473: END IF;
4474: -- Standard start of API savepoint
4475: SAVEPOINT Perform_Inter_Org_Transfer_Inv;
4476: -- Standard call to check for call compatibility
4477: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4479: END IF;
4480: -- Initialize message list if p_init_msg_list is set to TRUE

Line 4715: -- Standard check of p_commit

4711: RAISE FND_API.G_EXC_ERROR;
4712: END IF;
4713: END IF;
4714: -- END of if which checks the count of transactions created
4715: -- Standard check of p_commit
4716: IF FND_API.To_Boolean(p_commit) THEN
4717: COMMIT ;
4718: END IF;
4719: EXCEPTION

Line 5667: -- Standard start of API savepoint

5663: ' AND NVL(io.operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id())';
5664:
5665: BEGIN
5666:
5667: -- Standard start of API savepoint
5668: SAVEPOINT FILTER_INSTANCES_SP;
5669:
5670: IF (l_log_procedure >= l_log_current_level) THEN
5671: FND_LOG.string(l_log_procedure, l_debug || '.begin','At the start of PLSQL procedure');

Line 5726: --Standard check for commit

5722: IF (l_log_statement >= l_log_current_level) THEN
5723: FND_LOG.string(l_log_statement, l_debug, 'Requirement is not position based, returning back');
5724: END IF;
5725:
5726: --Standard check for commit
5727: IF (FND_API.TO_BOOLEAN(p_commit) AND x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5728: COMMIT;
5729: END IF;
5730:

Line 5814: --Standard check for commit

5810: FND_LOG.string(l_log_statement, l_debug,
5811: 'No items match SB rules, returning without populating temp table');
5812: END IF;
5813:
5814: --Standard check for commit
5815: IF (FND_API.TO_BOOLEAN(p_commit) AND x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5816: COMMIT;
5817: END IF;
5818:

Line 5853: --Standard check for commit

5849: 'Alt items is not required and primary item is invalid.'
5850: || ' Returning back without temp table population.');
5851: END IF;
5852:
5853: --Standard check for commit
5854: IF (FND_API.TO_BOOLEAN(p_commit) AND x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5855: COMMIT;
5856: END IF;
5857:

Line 6105: --Standard check for commit

6101: --Return with out applying any build goal logic, if neither of Hard Limit or Soft Limit MR checks are required
6102: IF (p_demand_Record.Include_HardLimit_MRs <> 'Y'
6103: AND p_demand_Record.Include_SoftLimit_MRs <> 'Y') THEN
6104:
6105: --Standard check for commit
6106: IF (FND_API.TO_BOOLEAN(p_commit) AND x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6107: COMMIT;
6108: END IF;
6109:

Line 6213: --Standard check for commit

6209:
6210: END LOOP; -- END l_appl_inst_tbl LOOP
6211: END IF;
6212:
6213: --Standard check for commit
6214: IF (FND_API.TO_BOOLEAN(p_commit) AND x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6215: COMMIT;
6216: END IF;
6217:

Line 6309: -- Standard start of API savepoint

6305: L_API_VERSION CONSTANT NUMBER := 1.0;
6306: L_API_NAME CONSTANT VARCHAR2(30) := 'GET_AVAILABLE_QUANTITY';
6307: L_DEBUG CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
6308: BEGIN
6309: -- Standard start of API savepoint
6310: SAVEPOINT GET_AVAILABLE_QUANTITY;
6311: IF (L_LOG_PROCEDURE >= L_LOG_CURRENT_LEVEL) THEN
6312: FND_LOG.STRING(L_LOG_PROCEDURE, L_DEBUG || '.begin', 'At the start of the PLSQL procedure GET_AVAILABLE_QUANTITY');
6313: END IF;

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

6312: FND_LOG.STRING(L_LOG_PROCEDURE, L_DEBUG || '.begin', 'At the start of the PLSQL procedure GET_AVAILABLE_QUANTITY');
6313: END IF;
6314: -- Initialize API return status to success
6315: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
6316: -- Standard call to check for call compatibility.
6317: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION, P_API_VERSION, L_API_NAME, G_PKG_NAME) THEN
6318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6319: END IF;
6320: -- Initialize message list if p_init_msg_list = FND_API.G_TRUE

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

6363: END LOOP;
6364: FND_MESSAGE.SET_TOKEN('ATP_MSG', l_error_msg);
6365: X_Inv_Mtl_Avl_Tbl(1).ERROR_MESSAGE := FND_MESSAGE.GET();
6366: END IF;
6367: -- Standard call to get message count and if count is 1, get message info
6368: FND_MSG_PUB.count_and_get ( p_count => x_msg_count, p_data => x_msg_data, p_encoded => FND_API.G_FALSE );
6369: -- Log API exit point
6370: IF (L_LOG_PROCEDURE >= L_LOG_CURRENT_LEVEL) THEN
6371: FND_LOG.STRING(L_LOG_PROCEDURE, L_DEBUG || '.end', 'At the end of PLSQL procedure');

Line 6404: -- Standard IN Parameters :

6400: --
6401: -- Pre-reqs :
6402: -- Parameters :
6403: --
6404: -- Standard IN Parameters :
6405: -- p_api_version IN NUMBER Required
6406: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
6407: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
6408: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 6412: -- Standard OUT Parameters :

6408: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
6409: -- Based on this flag, the API will set the default attributes.
6410: -- p_module_type In VARCHAR2 Default NULL
6411: -- This will be null.
6412: -- Standard OUT Parameters :
6413: -- x_return_status OUT VARCHAR2 Required
6414: -- x_msg_count OUT NUMBER Required
6415: -- x_msg_data OUT VARCHAR2 Required
6416: --

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

6451:
6452: -- Initialize API return status to success
6453: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
6454:
6455: -- Standard call to check for call compatibility.
6456: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION, P_API_VERSION, L_API_NAME, G_PKG_NAME) THEN
6457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6458: END IF;
6459: