DBA Data[Home] [Help]

APPS.OKC_REP_CONTRACT_PROCESS_PVT dependencies on OKC_REP_UTIL_PVT

Line 125: 'Calling OKC_REP_UTIL_PVT.change_contract_status');

121: CLOSE contract_csr;
122:
123: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
124: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
125: 'Calling OKC_REP_UTIL_PVT.change_contract_status');
126: END IF;
127: -- Update the contract status and add a record in OKC_REP_CON_STATUS_HIST table.
128: OKC_REP_UTIL_PVT.change_contract_status(
129: p_api_version => 1.0,

Line 128: OKC_REP_UTIL_PVT.change_contract_status(

124: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
125: 'Calling OKC_REP_UTIL_PVT.change_contract_status');
126: END IF;
127: -- Update the contract status and add a record in OKC_REP_CON_STATUS_HIST table.
128: OKC_REP_UTIL_PVT.change_contract_status(
129: p_api_version => 1.0,
130: p_init_msg_list => FND_API.G_FALSE,
131: p_contract_id => p_contract_id,
132: p_contract_version => p_contract_version,

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

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

Line 155: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');

151:
152:
153: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
154: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
155: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
156: END IF;
157: -- Add a record in ONC_REP_CON_APPROVALS table.
158: OKC_REP_UTIL_PVT.add_approval_hist_record(
159: p_api_version => 1.0,

Line 158: OKC_REP_UTIL_PVT.add_approval_hist_record(

154: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
155: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
156: END IF;
157: -- Add a record in ONC_REP_CON_APPROVALS table.
158: OKC_REP_UTIL_PVT.add_approval_hist_record(
159: p_api_version => 1.0,
160: p_init_msg_list => FND_API.G_FALSE,
161: p_contract_id => p_contract_id,
162: p_contract_version => p_contract_version,

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

167: x_msg_count => x_msg_count,
168: x_return_status => x_return_status);
169: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
170: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
171: 'OKC_REP_UTIL_PVT.add_approval_hist_record return status is: '
172: || x_return_status);
173: END IF;
174: -------------------------------------------------------
175: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 4607: 'Calling OKC_REP_UTIL_PVT.change_contract_status');

4603: -----------------------------------------------------
4604:
4605: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4606: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4607: 'Calling OKC_REP_UTIL_PVT.change_contract_status');
4608: END IF;
4609: -- Update the contract status and add a record in OKC_REP_CON_STATUS_HIST table.
4610: OKC_REP_UTIL_PVT.change_contract_status(
4611: p_api_version => 1.0,

Line 4610: OKC_REP_UTIL_PVT.change_contract_status(

4606: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4607: 'Calling OKC_REP_UTIL_PVT.change_contract_status');
4608: END IF;
4609: -- Update the contract status and add a record in OKC_REP_CON_STATUS_HIST table.
4610: OKC_REP_UTIL_PVT.change_contract_status(
4611: p_api_version => 1.0,
4612: p_init_msg_list => FND_API.G_FALSE,
4613: p_contract_id => p_contract_id,
4614: p_contract_version => contract_rec.contract_version_num,

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

4620: x_return_status => x_return_status);
4621: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4622: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4623: g_module || l_api_name,
4624: 'Completed OKC_REP_UTIL_PVT.change_contract_status with return status: ' || x_return_status);
4625: END IF;
4626: -----------------------------------------------------
4627: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4628: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 5042: 'Calling OKC_REP_UTIL_PVT.change_contract_status');

5038: CLOSE contract_csr;
5039:
5040: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5041: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
5042: 'Calling OKC_REP_UTIL_PVT.change_contract_status');
5043: END IF;
5044: -- Update the contract status and add a record in OKC_REP_CON_STATUS_HIST table.
5045: OKC_REP_UTIL_PVT.change_contract_status(
5046: p_api_version => 1.0,

Line 5045: OKC_REP_UTIL_PVT.change_contract_status(

5041: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
5042: 'Calling OKC_REP_UTIL_PVT.change_contract_status');
5043: END IF;
5044: -- Update the contract status and add a record in OKC_REP_CON_STATUS_HIST table.
5045: OKC_REP_UTIL_PVT.change_contract_status(
5046: p_api_version => 1.0,
5047: p_init_msg_list => FND_API.G_FALSE,
5048: p_contract_id => p_contract_id,
5049: p_contract_version => l_contract_version,

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

5055: x_return_status => x_return_status);
5056:
5057: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5058: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
5059: 'OKC_REP_UTIL_PVT.change_contract_status return status is: '
5060: || x_return_status);
5061: END IF;
5062: -----------------------------------------------------
5063: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 5073: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');

5069:
5070: /*
5071: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5072: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
5073: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
5074: END IF;
5075: -- Add a record in OKC_REP_CON_SIGNATURES table.
5076: OKC_REP_UTIL_PVT.add_signature_hist_record(
5077: p_api_version => 1.0,

Line 5076: OKC_REP_UTIL_PVT.add_signature_hist_record(

5072: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
5073: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
5074: END IF;
5075: -- Add a record in OKC_REP_CON_SIGNATURES table.
5076: OKC_REP_UTIL_PVT.add_signature_hist_record(
5077: p_api_version => 1.0,
5078: p_init_msg_list => FND_API.G_FALSE,
5079: p_contract_id => p_contract_id,
5080: p_sequence_id => NULL ,

Line 5093: 'OKC_REP_UTIL_PVT.add_signature_hist_record return status is: '

5089:
5090:
5091: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5092: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
5093: 'OKC_REP_UTIL_PVT.add_signature_hist_record return status is: '
5094: || x_return_status);
5095: END IF;
5096: -------------------------------------------------------
5097: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 5420: 'Calling OKC_REP_UTIL_PVT.change_contract_status');

5416: -----------------------------------------------------
5417: IF (trunc(p_termination_date) <= trunc(sysdate)) THEN
5418: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5419: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
5420: 'Calling OKC_REP_UTIL_PVT.change_contract_status');
5421: END IF;
5422:
5423: -- Update the contract status and add a record in OKC_REP_CON_STATUS_HIST table.
5424: OKC_REP_UTIL_PVT.change_contract_status(

Line 5424: OKC_REP_UTIL_PVT.change_contract_status(

5420: 'Calling OKC_REP_UTIL_PVT.change_contract_status');
5421: END IF;
5422:
5423: -- Update the contract status and add a record in OKC_REP_CON_STATUS_HIST table.
5424: OKC_REP_UTIL_PVT.change_contract_status(
5425: p_api_version => 1.0,
5426: p_init_msg_list => FND_API.G_FALSE,
5427: p_contract_id => p_contract_id,
5428: p_contract_version => contract_rec.contract_version_num,

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

5434: x_return_status => x_return_status);
5435: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5436: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
5437: g_module || l_api_name,
5438: 'Completed OKC_REP_UTIL_PVT.change_contract_status with return status: ' || x_return_status);
5439: END IF;
5440: -----------------------------------------------------
5441: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5442: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 6239: 'Calling OKC_REP_UTIL_PVT.change_contract_status');

6235:
6236:
6237: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6238: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
6239: 'Calling OKC_REP_UTIL_PVT.change_contract_status');
6240: END IF;
6241:
6242: -- Update the contract status and add a record in OKC_REP_CON_STATUS_HIST table.
6243: OKC_REP_UTIL_PVT.change_contract_status(

Line 6243: OKC_REP_UTIL_PVT.change_contract_status(

6239: 'Calling OKC_REP_UTIL_PVT.change_contract_status');
6240: END IF;
6241:
6242: -- Update the contract status and add a record in OKC_REP_CON_STATUS_HIST table.
6243: OKC_REP_UTIL_PVT.change_contract_status(
6244: p_api_version => 1.0,
6245: p_init_msg_list => FND_API.G_FALSE,
6246: p_contract_id => p_contract_id,
6247: p_contract_version => p_contract_version,

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

6252: x_msg_count => x_msg_count,
6253: x_return_status => x_return_status);
6254: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6255: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
6256: 'OKC_REP_UTIL_PVT.change_contract_status return status is: '
6257: || x_return_status);
6258: END IF;
6259: -----------------------------------------------------
6260: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 6270: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');

6266:
6267:
6268: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6269: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
6270: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
6271: END IF;
6272:
6273: -- Add a record in ONC_REP_CON_APPROVALS table.
6274: OKC_REP_UTIL_PVT.add_approval_hist_record(

Line 6274: OKC_REP_UTIL_PVT.add_approval_hist_record(

6270: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
6271: END IF;
6272:
6273: -- Add a record in ONC_REP_CON_APPROVALS table.
6274: OKC_REP_UTIL_PVT.add_approval_hist_record(
6275: p_api_version => 1.0,
6276: p_init_msg_list => FND_API.G_FALSE,
6277: p_contract_id => p_contract_id,
6278: p_contract_version => p_contract_version,

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

6283: x_msg_count => x_msg_count,
6284: x_return_status => x_return_status);
6285: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6286: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
6287: 'OKC_REP_UTIL_PVT.add_approval_hist_record return status is: '
6288: || x_return_status);
6289: END IF;
6290: -------------------------------------------------------
6291: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN