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 71: AND t.document_type IN ('PA_BLANKET','PA_CONTRACT','PO_STANDARD')

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

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

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

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

1681: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1682: 'p_mode = ' || p_mode);
1683: END IF;
1684:
1685: -- Standard call to check for call compatibility.
1686: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1687: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1688: END IF;
1689:

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

2501: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2502: 'p_contact_role_id = ' || p_contact_role_id);
2503: END IF;
2504:
2505: -- Standard call to check for call compatibility.
2506: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2508: END IF;
2509:

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

2854:
2855:
2856: END IF;
2857:
2858: -- Standard call to check for call compatibility.
2859: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2860: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2861: END IF;
2862:

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

3054: 'p_run_id = ' || p_run_id);
3055:
3056: END IF;
3057:
3058: -- Standard call to check for call compatibility.
3059: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3061: END IF;
3062:

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

3425: 'p_run_id = ' || p_run_id);
3426:
3427: END IF;
3428:
3429: -- Standard call to check for call compatibility.
3430: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3432: END IF;
3433:

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

4154: 'p_run_id = ' || p_run_id);
4155:
4156: END IF;
4157:
4158: -- Standard call to check for call compatibility.
4159: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4161: END IF;
4162:

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

5658: l_number_valid := -1;
5659:
5660: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_insert_batch_size = ' || l_insert_batch_size);
5661:
5662: -- Standard call to check for call compatibility.
5663: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
5664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5665: END IF;
5666:

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

6244: 'p_run_id = ' || p_run_id);
6245:
6246: END IF;
6247:
6248: -- Standard call to check for call compatibility.
6249: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
6250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6251: END IF;
6252:

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

6460:
6461:
6462: END IF;
6463:
6464: -- Standard call to check for call compatibility.
6465: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
6466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6467: END IF;
6468:

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

7051: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
7052: 'p_external_party_id is: ' || to_char(p_external_party_id));
7053: END IF;
7054:
7055: -- Standard call to check for call compatibility.
7056: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
7057: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7058: END IF;
7059: -- Initialize message list if p_init_msg_list is set to TRUE.

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

7083: l_index := l_index + 1;
7084: END IF; -- (l_contact_email_address <> NULL)
7085: END LOOP;
7086:
7087: -- Standard call to get message count and if count is 1, get message info.
7088: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
7089:
7090: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7091: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

7219: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
7220: 'p_external_party_id is: ' || to_char(p_external_party_id));
7221: END IF;
7222:
7223: -- Standard call to check for call compatibility.
7224: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
7225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7226: END IF;
7227: -- Initialize message list if p_init_msg_list is set to TRUE.

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

7250: l_index := l_index + 1;
7251: END IF; -- (l_contact_email_address <> NULL)
7252: END LOOP;
7253:
7254: -- Standard call to get message count and if count is 1, get message info.
7255: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
7256:
7257: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7258: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

7377: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
7378: 'p_external_party_role is: ' || to_char(p_external_party_role));
7379: END IF;
7380:
7381: -- Standard call to check for call compatibility.
7382: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
7383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7384: END IF;
7385: -- Initialize message list if p_init_msg_list is set to TRUE.

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

7412: x_external_userlist => x_external_userlist);
7413: END IF;
7414:
7415:
7416: -- Standard call to get message count and if count is 1, get message info.
7417: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
7418:
7419: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7420: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

7530: l_api_name := 'ok_to_commit';
7531: l_ok_to_commit := FND_API.G_FALSE;
7532:
7533:
7534: -- Standard call to check for call compatibility.
7535: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
7536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7537: END IF;
7538:

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

7586: l_ok_to_commit := FND_API.G_TRUE;
7587: CLOSE l_contract_updatable_csr;
7588: END IF; -- (l_contract_updatable_csr%NOTFOUND)
7589: END IF; -- (p_validation_string is NULL)
7590: -- Standard call to get message count and if count is 1, get message info.
7591: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
7592: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7593: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
7594: '110: Leaving OKC_REP_UTIL_PVT.ok_to_commit');

Line 8000: -- Standard Start of API savepoint

7996: BEGIN
7997: l_api_name := 'sync_con_header_attributes';
7998: l_api_version := 1.0;
7999:
8000: -- Standard Start of API savepoint
8001: SAVEPOINT sync_con_header_attributes;
8002:
8003: -- Standard call to check for call compatibility.
8004: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

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

7999:
8000: -- Standard Start of API savepoint
8001: SAVEPOINT sync_con_header_attributes;
8002:
8003: -- Standard call to check for call compatibility.
8004: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
8005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8006: END IF;
8007:

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

8052: WHERE contract_id = p_contract_id;
8053:
8054: COMMIT WORK;
8055:
8056: -- Standard call to get message count and if count is 1, get message info.
8057: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
8058:
8059: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8060: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

8494: 'p_run_id = ' || p_run_id);
8495:
8496: END IF;
8497:
8498: -- Standard call to check for call compatibility.
8499: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
8500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8501: END IF;
8502:

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

8976: 'p_run_id = ' || p_run_id);
8977:
8978: END IF;
8979:
8980: -- Standard call to check for call compatibility.
8981: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
8982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8983: END IF;
8984: