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.OKC_REP_UTIL_PVT dependencies on STANDARD

Line 69: AND t.document_type IN ('PA_BLANKET','PA_CONTRACT','PO_STANDARD')

65: FROM
66: po_headers_all h
67: ,okc_template_usages t
68: WHERE h.po_header_id = t.document_id
69: AND t.document_type IN ('PA_BLANKET','PA_CONTRACT','PO_STANDARD')
70: AND t.document_type = p_contract_type
71: AND h.po_header_id = p_contract_id;
72:
73: CURSOR neg_contract_csr(p_contract_id IN NUMBER, p_contract_type IN VARCHAR2) IS

Line 153: OR (p_contract_type = 'PO_STANDARD') THEN

149: END IF;
150:
151: IF (p_contract_type = 'PA_BLANKET')
152: OR (p_contract_type = 'PA_CONTRACT')
153: OR (p_contract_type = 'PO_STANDARD') THEN
154:
155: OPEN po_contract_csr(p_contract_id, p_contract_type);
156: FETCH po_contract_csr INTO l_org_id;
157: CLOSE po_contract_csr;

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

1423: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1424: 'p_mode = ' || p_mode);
1425: END IF;
1426:
1427: -- Standard call to check for call compatibility.
1428: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1430: END IF;
1431:

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

2243: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2244: 'p_contact_role_id = ' || p_contact_role_id);
2245: END IF;
2246:
2247: -- Standard call to check for call compatibility.
2248: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2250: END IF;
2251:

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

2596:
2597:
2598: END IF;
2599:
2600: -- Standard call to check for call compatibility.
2601: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2603: END IF;
2604:

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

2794: 'p_request_id = ' || p_request_id);
2795:
2796: END IF;
2797:
2798: -- Standard call to check for call compatibility.
2799: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2801: END IF;
2802:

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

3157: 'p_request_id = ' || p_request_id);
3158:
3159: END IF;
3160:
3161: -- Standard call to check for call compatibility.
3162: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3164: END IF;
3165:

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

3791: 'p_request_id = ' || p_request_id);
3792:
3793: END IF;
3794:
3795: -- Standard call to check for call compatibility.
3796: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3798: END IF;
3799:

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

4962: l_number_valid := -1;
4963:
4964: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_insert_batch_size = ' || l_insert_batch_size);
4965:
4966: -- Standard call to check for call compatibility.
4967: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4968: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4969: END IF;
4970:

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

5390: 'p_request_id = ' || p_request_id);
5391:
5392: END IF;
5393:
5394: -- Standard call to check for call compatibility.
5395: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
5396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5397: END IF;
5398:

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

5577:
5578:
5579: END IF;
5580:
5581: -- Standard call to check for call compatibility.
5582: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
5583: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5584: END IF;
5585:

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

6168: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6169: 'p_external_party_id is: ' || to_char(p_external_party_id));
6170: END IF;
6171:
6172: -- Standard call to check for call compatibility.
6173: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
6174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6175: END IF;
6176: -- Initialize message list if p_init_msg_list is set to TRUE.

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

6200: l_index := l_index + 1;
6201: END IF; -- (l_contact_email_address <> NULL)
6202: END LOOP;
6203:
6204: -- Standard call to get message count and if count is 1, get message info.
6205: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
6206:
6207: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6208: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

6336: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6337: 'p_external_party_id is: ' || to_char(p_external_party_id));
6338: END IF;
6339:
6340: -- Standard call to check for call compatibility.
6341: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
6342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6343: END IF;
6344: -- Initialize message list if p_init_msg_list is set to TRUE.

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

6367: l_index := l_index + 1;
6368: END IF; -- (l_contact_email_address <> NULL)
6369: END LOOP;
6370:
6371: -- Standard call to get message count and if count is 1, get message info.
6372: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
6373:
6374: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6375: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

6494: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6495: 'p_external_party_role is: ' || to_char(p_external_party_role));
6496: END IF;
6497:
6498: -- Standard call to check for call compatibility.
6499: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
6500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6501: END IF;
6502: -- Initialize message list if p_init_msg_list is set to TRUE.

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

6529: x_external_userlist => x_external_userlist);
6530: END IF;
6531:
6532:
6533: -- Standard call to get message count and if count is 1, get message info.
6534: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
6535:
6536: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6537: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

6647: l_api_name := 'ok_to_commit';
6648: l_ok_to_commit := FND_API.G_FALSE;
6649:
6650:
6651: -- Standard call to check for call compatibility.
6652: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
6653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6654: END IF;
6655:

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

6703: l_ok_to_commit := FND_API.G_TRUE;
6704: CLOSE l_contract_updatable_csr;
6705: END IF; -- (l_contract_updatable_csr%NOTFOUND)
6706: END IF; -- (p_validation_string is NULL)
6707: -- Standard call to get message count and if count is 1, get message info.
6708: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
6709: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6710: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
6711: '110: Leaving OKC_REP_UTIL_PVT.ok_to_commit');

Line 7098: -- Standard Start of API savepoint

7094: BEGIN
7095: l_api_name := 'sync_con_header_attributes';
7096: l_api_version := 1.0;
7097:
7098: -- Standard Start of API savepoint
7099: SAVEPOINT sync_con_header_attributes;
7100:
7101: -- Standard call to check for call compatibility.
7102: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

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

7097:
7098: -- Standard Start of API savepoint
7099: SAVEPOINT sync_con_header_attributes;
7100:
7101: -- Standard call to check for call compatibility.
7102: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
7103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7104: END IF;
7105:

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

7150: WHERE contract_id = p_contract_id;
7151:
7152: COMMIT WORK;
7153:
7154: -- Standard call to get message count and if count is 1, get message info.
7155: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
7156:
7157: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7158: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,