DBA Data[Home] [Help]

APPS.OKC_REP_CONTRACT_PROCESS_PVT dependencies on OKC_REP_UTIL_PVT

Line 97: 'Calling OKC_REP_UTIL_PVT.change_contract_status');

93: CLOSE contract_csr;
94:
95: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
96: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
97: 'Calling OKC_REP_UTIL_PVT.change_contract_status');
98: END IF;
99: -- Update the contract status and add a record in OKC_REP_CON_STATUS_HIST table.
100: OKC_REP_UTIL_PVT.change_contract_status(
101: p_api_version => 1.0,

Line 100: OKC_REP_UTIL_PVT.change_contract_status(

96: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
97: 'Calling OKC_REP_UTIL_PVT.change_contract_status');
98: END IF;
99: -- Update the contract status and add a record in OKC_REP_CON_STATUS_HIST table.
100: OKC_REP_UTIL_PVT.change_contract_status(
101: p_api_version => 1.0,
102: p_init_msg_list => FND_API.G_FALSE,
103: p_contract_id => p_contract_id,
104: p_contract_version => p_contract_version,

Line 113: 'OKC_REP_UTIL_PVT.change_contract_status return status is: '

109: x_msg_count => x_msg_count,
110: x_return_status => x_return_status);
111: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
112: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
113: 'OKC_REP_UTIL_PVT.change_contract_status return status is: '
114: || x_return_status);
115: END IF;
116: -----------------------------------------------------
117: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 127: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');

123:
124:
125: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
126: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
127: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
128: END IF;
129: -- Add a record in ONC_REP_CON_APPROVALS table.
130: OKC_REP_UTIL_PVT.add_approval_hist_record(
131: p_api_version => 1.0,

Line 130: OKC_REP_UTIL_PVT.add_approval_hist_record(

126: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
127: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
128: END IF;
129: -- Add a record in ONC_REP_CON_APPROVALS table.
130: OKC_REP_UTIL_PVT.add_approval_hist_record(
131: p_api_version => 1.0,
132: p_init_msg_list => FND_API.G_FALSE,
133: p_contract_id => p_contract_id,
134: p_contract_version => p_contract_version,

Line 143: 'OKC_REP_UTIL_PVT.add_approval_hist_record return status is: '

139: x_msg_count => x_msg_count,
140: x_return_status => x_return_status);
141: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
142: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
143: 'OKC_REP_UTIL_PVT.add_approval_hist_record return status is: '
144: || x_return_status);
145: END IF;
146: -------------------------------------------------------
147: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 4100: 'Calling OKC_REP_UTIL_PVT.change_contract_status');

4096: -----------------------------------------------------
4097:
4098: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4099: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4100: 'Calling OKC_REP_UTIL_PVT.change_contract_status');
4101: END IF;
4102: -- Update the contract status and add a record in OKC_REP_CON_STATUS_HIST table.
4103: OKC_REP_UTIL_PVT.change_contract_status(
4104: p_api_version => 1.0,

Line 4103: OKC_REP_UTIL_PVT.change_contract_status(

4099: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4100: 'Calling OKC_REP_UTIL_PVT.change_contract_status');
4101: END IF;
4102: -- Update the contract status and add a record in OKC_REP_CON_STATUS_HIST table.
4103: OKC_REP_UTIL_PVT.change_contract_status(
4104: p_api_version => 1.0,
4105: p_init_msg_list => FND_API.G_FALSE,
4106: p_contract_id => p_contract_id,
4107: p_contract_version => contract_rec.contract_version_num,

Line 4117: 'Completed OKC_REP_UTIL_PVT.change_contract_status with return status: ' || x_return_status);

4113: x_return_status => x_return_status);
4114: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4115: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4116: g_module || l_api_name,
4117: 'Completed OKC_REP_UTIL_PVT.change_contract_status with return status: ' || x_return_status);
4118: END IF;
4119: -----------------------------------------------------
4120: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4121: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 4518: 'Calling OKC_REP_UTIL_PVT.change_contract_status');

4514: -----------------------------------------------------
4515: IF (trunc(p_termination_date) <= trunc(sysdate)) THEN
4516: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4517: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4518: 'Calling OKC_REP_UTIL_PVT.change_contract_status');
4519: END IF;
4520:
4521: -- Update the contract status and add a record in OKC_REP_CON_STATUS_HIST table.
4522: OKC_REP_UTIL_PVT.change_contract_status(

Line 4522: OKC_REP_UTIL_PVT.change_contract_status(

4518: 'Calling OKC_REP_UTIL_PVT.change_contract_status');
4519: END IF;
4520:
4521: -- Update the contract status and add a record in OKC_REP_CON_STATUS_HIST table.
4522: OKC_REP_UTIL_PVT.change_contract_status(
4523: p_api_version => 1.0,
4524: p_init_msg_list => FND_API.G_FALSE,
4525: p_contract_id => p_contract_id,
4526: p_contract_version => contract_rec.contract_version_num,

Line 4536: 'Completed OKC_REP_UTIL_PVT.change_contract_status with return status: ' || x_return_status);

4532: x_return_status => x_return_status);
4533: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4534: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4535: g_module || l_api_name,
4536: 'Completed OKC_REP_UTIL_PVT.change_contract_status with return status: ' || x_return_status);
4537: END IF;
4538: -----------------------------------------------------
4539: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4540: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 5256: 'Calling OKC_REP_UTIL_PVT.change_contract_status');

5252:
5253:
5254: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5255: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
5256: 'Calling OKC_REP_UTIL_PVT.change_contract_status');
5257: END IF;
5258:
5259: -- Update the contract status and add a record in OKC_REP_CON_STATUS_HIST table.
5260: OKC_REP_UTIL_PVT.change_contract_status(

Line 5260: OKC_REP_UTIL_PVT.change_contract_status(

5256: 'Calling OKC_REP_UTIL_PVT.change_contract_status');
5257: END IF;
5258:
5259: -- Update the contract status and add a record in OKC_REP_CON_STATUS_HIST table.
5260: OKC_REP_UTIL_PVT.change_contract_status(
5261: p_api_version => 1.0,
5262: p_init_msg_list => FND_API.G_FALSE,
5263: p_contract_id => p_contract_id,
5264: p_contract_version => p_contract_version,

Line 5273: 'OKC_REP_UTIL_PVT.change_contract_status return status is: '

5269: x_msg_count => x_msg_count,
5270: x_return_status => x_return_status);
5271: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5272: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
5273: 'OKC_REP_UTIL_PVT.change_contract_status return status is: '
5274: || x_return_status);
5275: END IF;
5276: -----------------------------------------------------
5277: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 5287: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');

5283:
5284:
5285: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5286: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
5287: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
5288: END IF;
5289:
5290: -- Add a record in ONC_REP_CON_APPROVALS table.
5291: OKC_REP_UTIL_PVT.add_approval_hist_record(

Line 5291: OKC_REP_UTIL_PVT.add_approval_hist_record(

5287: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
5288: END IF;
5289:
5290: -- Add a record in ONC_REP_CON_APPROVALS table.
5291: OKC_REP_UTIL_PVT.add_approval_hist_record(
5292: p_api_version => 1.0,
5293: p_init_msg_list => FND_API.G_FALSE,
5294: p_contract_id => p_contract_id,
5295: p_contract_version => p_contract_version,

Line 5304: 'OKC_REP_UTIL_PVT.add_approval_hist_record return status is: '

5300: x_msg_count => x_msg_count,
5301: x_return_status => x_return_status);
5302: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5303: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
5304: 'OKC_REP_UTIL_PVT.add_approval_hist_record return status is: '
5305: || x_return_status);
5306: END IF;
5307: -------------------------------------------------------
5308: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN