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_OSP_PO_REQ_PVT dependencies on STANDARD

Line 175: -- Standard IN Parameters :

171: -- Updates OSP table with request id, batch id and interface header id
172: -- Pre-reqs :
173: -- Parameters :
174: --
175: -- Standard IN Parameters :
176: -- p_api_version IN NUMBER Required
177: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
178: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
179: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 183: -- Standard OUT Parameters :

179: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
180: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
181: -- p_module_type IN VARCHAR2 Default NULL.
182: --
183: -- Standard OUT Parameters :
184: -- x_return_status OUT VARCHAR2 Required
185: -- x_msg_count OUT NUMBER Required
186: -- x_msg_data OUT VARCHAR2 Required
187: --

Line 287: -- Standard start of API savepoint

283: l_status VARCHAR2(30);
284:
285: BEGIN
286:
287: -- Standard start of API savepoint
288: SAVEPOINT Create_PO_Requisition_pvt;
289:
290: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
291: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');

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

290: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
291: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
292: END IF;
293:
294: -- Standard call to check for call compatibility
295: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
296: G_PKG_NAME) THEN
297: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
298: END IF;

Line 448: -- Standard check of p_commit

444: p_src_doc_type_code => G_DOC_TYPE_OSP,
445: p_dest_doc_id => l_batch_id,
446: p_dest_doc_type_code => G_DOC_TYPE_PO_REQ);
447:
448: -- Standard check of p_commit
449: IF FND_API.TO_BOOLEAN(p_commit) THEN
450: COMMIT WORK;
451: END IF;
452:

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

449: IF FND_API.TO_BOOLEAN(p_commit) THEN
450: COMMIT WORK;
451: END IF;
452:
453: -- Standard call to get message count and if count is 1, get message info
454: FND_MSG_PUB.Count_And_Get
455: ( p_count => x_msg_count,
456: p_data => x_msg_data,
457: p_encoded => fnd_api.g_false

Line 505: -- Standard IN Parameters :

501: -- 4. Handles Deleted Requisition Lines (Updates OSP Line status, deletes shipment lines)
502: -- Pre-reqs :
503: -- Parameters :
504: --
505: -- Standard IN Parameters :
506: -- p_api_version IN NUMBER Required
507: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
508: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
509: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 513: -- Standard OUT Parameters :

509: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
510: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
511: -- p_module_type IN VARCHAR2 Default NULL.
512: --
513: -- Standard OUT Parameters :
514: -- x_return_status OUT VARCHAR2 Required
515: -- x_msg_count OUT NUMBER Required
516: -- x_msg_data OUT VARCHAR2 Required
517: --

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

548:
549: -- No need of a Savepoint: Individual procedures commit or rollback
550: -- within themselves.
551:
552: -- Standard call to check for call compatibility
553: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
554: G_PKG_NAME) THEN
555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
556: END IF;

Line 636: -- Standard check of p_commit

632: IF x_msg_count > 0 THEN
633: RAISE FND_API.G_EXC_ERROR; --Note that commit might already have taken place
634: END IF;
635:
636: -- Standard check of p_commit
637: -- No need to commit: Individual procedures commit or rollback
638: -- within themselves.
639: -- IF FND_API.TO_BOOLEAN(p_commit) THEN
640: -- COMMIT WORK; --Note that commit might already have taken place

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

639: -- IF FND_API.TO_BOOLEAN(p_commit) THEN
640: -- COMMIT WORK; --Note that commit might already have taken place
641: -- END IF;
642:
643: -- Standard call to get message count and if count is 1, get message info
644: FND_MSG_PUB.Count_And_Get
645: ( p_count => x_msg_count,
646: p_data => x_msg_data,
647: p_encoded => fnd_api.g_false

Line 717: -- Standard IN Parameters :

713: -- REQUISITION_LINE_ID respectively for all submitted OSP Orders (for Requisitions).
714: -- Pre-reqs :
715: -- Parameters :
716: --
717: -- Standard IN Parameters :
718: -- p_api_version IN NUMBER Required
719: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
720: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
721: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 725: -- Standard OUT Parameters :

721: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
722: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
723: -- p_module_type IN VARCHAR2 Default NULL.
724: --
725: -- Standard OUT Parameters :
726: -- x_return_status OUT VARCHAR2 Required
727: -- x_msg_count OUT NUMBER Required
728: -- x_msg_data OUT VARCHAR2 Required
729: --

Line 768: -- Standard start of API savepoint

764: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
765: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
766: END IF;
767:
768: -- Standard start of API savepoint
769: SAVEPOINT Associate_All_New_Reqs_pvt;
770:
771: -- Standard call to check for call compatibility
772: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

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

767:
768: -- Standard start of API savepoint
769: SAVEPOINT Associate_All_New_Reqs_pvt;
770:
771: -- Standard call to check for call compatibility
772: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
773: G_PKG_NAME) THEN
774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
775: END IF;

Line 814: -- Standard check of p_commit

810: IF x_msg_count > 0 THEN
811: RAISE FND_API.G_EXC_ERROR;
812: END IF;
813:
814: -- Standard check of p_commit
815: IF FND_API.TO_BOOLEAN(p_commit) THEN
816: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
817: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to COMMIT work.');
818: END IF;

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

818: END IF;
819: COMMIT WORK;
820: END IF;
821:
822: -- Standard call to get message count and if count is 1, get message info
823: FND_MSG_PUB.Count_And_Get
824: ( p_count => x_msg_count,
825: p_data => x_msg_data,
826: p_encoded => fnd_api.g_false

Line 1893: -- Standard start of API savepoint

1889: BEGIN
1890: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1891: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
1892: END IF;
1893: -- Standard start of API savepoint
1894: SAVEPOINT Handle_Deleted_Req_Headers_pvt;
1895:
1896: -- Initialize API return status to success
1897: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2034: -- Standard start of API savepoint

2030: BEGIN
2031: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2032: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
2033: END IF;
2034: -- Standard start of API savepoint
2035: SAVEPOINT Handle_Cancelled_Req_Lines_pvt;
2036:
2037: -- Initialize API return status to success
2038: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2184: -- Standard start of API savepoint

2180: BEGIN
2181: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2182: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
2183: END IF;
2184: -- Standard start of API savepoint
2185: SAVEPOINT Handle_Deleted_Req_Lines_pvt;
2186:
2187: -- Initialize API return status to success
2188: x_return_status := FND_API.G_RET_STS_SUCCESS;