DBA Data[Home] [Help]

APPS.OKC_REP_WF_PVT dependencies on OKC_REP_UTIL_PVT

Line 1048: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');

1044: g_module || l_api_name,
1045: 'Approver action is : ' || G_WF_STATUS_APPROVED);
1046: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1047: g_module || l_api_name,
1048: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1049: END IF;
1050: OKC_REP_UTIL_PVT.add_approval_hist_record(
1051: p_api_version => 1.0,
1052: p_init_msg_list => FND_API.G_FALSE,

Line 1050: OKC_REP_UTIL_PVT.add_approval_hist_record(

1046: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1047: g_module || l_api_name,
1048: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1049: END IF;
1050: OKC_REP_UTIL_PVT.add_approval_hist_record(
1051: p_api_version => 1.0,
1052: p_init_msg_list => FND_API.G_FALSE,
1053: p_contract_id => l_contract_id,
1054: p_contract_version => l_contract_version,

Line 1064: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);

1060: x_return_status => l_return_status);
1061: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1062: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1063: g_module || l_api_name,
1064: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1065: END IF;
1066: -------------------------------------------------------
1067: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1068: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1090: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');

1086: g_module || l_api_name,
1087: 'Approver action is : ' || G_WF_STATUS_REJECTED);
1088: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1089: g_module || l_api_name,
1090: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1091: END IF;
1092: OKC_REP_UTIL_PVT.add_approval_hist_record(
1093: p_api_version => 1.0,
1094: p_init_msg_list => FND_API.G_FALSE,

Line 1092: OKC_REP_UTIL_PVT.add_approval_hist_record(

1088: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1089: g_module || l_api_name,
1090: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1091: END IF;
1092: OKC_REP_UTIL_PVT.add_approval_hist_record(
1093: p_api_version => 1.0,
1094: p_init_msg_list => FND_API.G_FALSE,
1095: p_contract_id => l_contract_id,
1096: p_contract_version => l_contract_version,

Line 1106: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);

1102: x_return_status => l_return_status);
1103: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1104: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1105: g_module || l_api_name,
1106: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1107: END IF;
1108: -------------------------------------------------------
1109: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1110: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1164: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');

1160: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1161: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, g_module || l_api_name,
1162: 'In OKC_REP_WF_PVT.update_ame_status funcmode=TIMEOUT');
1163: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,g_module || l_api_name,
1164: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1165: END IF;
1166: OKC_REP_UTIL_PVT.add_approval_hist_record(
1167: p_api_version => 1.0,
1168: p_init_msg_list => FND_API.G_FALSE,

Line 1166: OKC_REP_UTIL_PVT.add_approval_hist_record(

1162: 'In OKC_REP_WF_PVT.update_ame_status funcmode=TIMEOUT');
1163: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,g_module || l_api_name,
1164: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1165: END IF;
1166: OKC_REP_UTIL_PVT.add_approval_hist_record(
1167: p_api_version => 1.0,
1168: p_init_msg_list => FND_API.G_FALSE,
1169: p_contract_id => l_contract_id,
1170: p_contract_version => l_contract_version,

Line 1180: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);

1176: x_return_status => l_return_status);
1177: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1178: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1179: g_module || l_api_name,
1180: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1181: END IF;
1182: -------------------------------------------------------
1183: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1184: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1405: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');

1401: g_module || l_api_name,
1402: 'Approver action is : ' || G_WF_STATUS_APPROVED);
1403: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1404: g_module || l_api_name,
1405: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1406: END IF;
1407: OKC_REP_UTIL_PVT.add_approval_hist_record(
1408: p_api_version => 1.0,
1409: p_init_msg_list => FND_API.G_FALSE,

Line 1407: OKC_REP_UTIL_PVT.add_approval_hist_record(

1403: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1404: g_module || l_api_name,
1405: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1406: END IF;
1407: OKC_REP_UTIL_PVT.add_approval_hist_record(
1408: p_api_version => 1.0,
1409: p_init_msg_list => FND_API.G_FALSE,
1410: p_contract_id => l_contract_id,
1411: p_contract_version => l_contract_version,

Line 1421: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);

1417: x_return_status => l_return_status);
1418: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1419: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1420: g_module || l_api_name,
1421: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1422: END IF;
1423: -------------------------------------------------------
1424: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1425: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1453: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');

1449: g_module || l_api_name,
1450: 'Approver action is : ' || G_WF_STATUS_REJECTED);
1451: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1452: g_module || l_api_name,
1453: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1454: END IF;
1455: OKC_REP_UTIL_PVT.add_approval_hist_record(
1456: p_api_version => 1.0,
1457: p_init_msg_list => FND_API.G_FALSE,

Line 1455: OKC_REP_UTIL_PVT.add_approval_hist_record(

1451: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1452: g_module || l_api_name,
1453: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1454: END IF;
1455: OKC_REP_UTIL_PVT.add_approval_hist_record(
1456: p_api_version => 1.0,
1457: p_init_msg_list => FND_API.G_FALSE,
1458: p_contract_id => l_contract_id,
1459: p_contract_version => l_contract_version,

Line 1469: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);

1465: x_return_status => l_return_status);
1466: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1467: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1468: g_module || l_api_name,
1469: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1470: END IF;
1471: -------------------------------------------------------
1472: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1473: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1501: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');

1497: g_module || l_api_name,
1498: 'Approver action is : ' || G_WF_APPROVE_FORWARD);
1499: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1500: g_module || l_api_name,
1501: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1502: END IF;
1503:
1504:
1505: l_forwardTo := wf_notification.GetAttrText(WF_ENGINE.context_nid, 'FORWARD_TO_USERNAME_RESPONSE');

Line 1513: OKC_REP_UTIL_PVT.add_approval_hist_record(

1509: app_exception.raise_exception;
1510: end if;
1511:
1512:
1513: OKC_REP_UTIL_PVT.add_approval_hist_record(
1514: p_api_version => 1.0,
1515: p_init_msg_list => FND_API.G_FALSE,
1516: p_contract_id => l_contract_id,
1517: p_contract_version => l_contract_version,

Line 1527: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);

1523: x_return_status => l_return_status);
1524: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1525: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1526: g_module || l_api_name,
1527: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1528: END IF;
1529: -------------------------------------------------------
1530: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1531: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1553: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');

1549: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1550: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,
1551: 'Approver action is : ' || l_action_code);
1552: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,
1553: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1554: END IF;
1555: l_action_code:= G_WF_APPROVE_FORWARD;
1556: OKC_REP_UTIL_PVT.add_approval_hist_record(
1557: p_api_version => 1.0,

Line 1556: OKC_REP_UTIL_PVT.add_approval_hist_record(

1552: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,
1553: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1554: END IF;
1555: l_action_code:= G_WF_APPROVE_FORWARD;
1556: OKC_REP_UTIL_PVT.add_approval_hist_record(
1557: p_api_version => 1.0,
1558: p_init_msg_list => FND_API.G_FALSE,
1559: p_contract_id => l_contract_id,
1560: p_contract_version => l_contract_version,

Line 1570: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);

1566: x_return_status => l_return_status,
1567: p_forward_user_id => l_recipient_id);
1568: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1569: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,
1570: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1571: END IF;
1572:
1573: -------------------------------------------------------
1574: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1635: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');

1631: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1632: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, g_module || l_api_name,
1633: 'In OKC_REP_WF_PVT.update_ame_status funcmode=TIMEOUT');
1634: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,g_module || l_api_name,
1635: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1636: END IF;
1637: OKC_REP_UTIL_PVT.add_approval_hist_record(
1638: p_api_version => 1.0,
1639: p_init_msg_list => FND_API.G_FALSE,

Line 1637: OKC_REP_UTIL_PVT.add_approval_hist_record(

1633: 'In OKC_REP_WF_PVT.update_ame_status funcmode=TIMEOUT');
1634: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,g_module || l_api_name,
1635: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1636: END IF;
1637: OKC_REP_UTIL_PVT.add_approval_hist_record(
1638: p_api_version => 1.0,
1639: p_init_msg_list => FND_API.G_FALSE,
1640: p_contract_id => l_contract_id,
1641: p_contract_version => l_contract_version,

Line 1651: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);

1647: x_return_status => l_return_status);
1648: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1649: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1650: g_module || l_api_name,
1651: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1652: END IF;
1653: -------------------------------------------------------
1654: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1655: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1704: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');

1700: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1701: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,
1702: 'Approver action is : ' || l_action_code);
1703: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,
1704: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1705: END IF;
1706: OKC_REP_UTIL_PVT.add_approval_hist_record(
1707: p_api_version => 1.0,
1708: p_init_msg_list => FND_API.G_FALSE,

Line 1706: OKC_REP_UTIL_PVT.add_approval_hist_record(

1702: 'Approver action is : ' || l_action_code);
1703: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,
1704: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1705: END IF;
1706: OKC_REP_UTIL_PVT.add_approval_hist_record(
1707: p_api_version => 1.0,
1708: p_init_msg_list => FND_API.G_FALSE,
1709: p_contract_id => l_contract_id,
1710: p_contract_version => l_contract_version,

Line 1720: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);

1716: x_return_status => l_return_status,
1717: p_forward_user_id => l_recipient_id);
1718: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1719: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,
1720: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1721: END IF;
1722:
1723: -------------------------------------------------------
1724: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1870: 'Calling OKC_REP_UTIL_PVT.change_contract_status');

1866: 'Contract Version is: ' || to_char(l_contract_version));
1867: END IF;
1868: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1869: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1870: 'Calling OKC_REP_UTIL_PVT.change_contract_status');
1871: END IF;
1872: -- Update the contract status and add a record in OKC_REP_CON_STATUS_HIST table.
1873: OKC_REP_UTIL_PVT.change_contract_status(
1874: p_api_version => 1.0,

Line 1873: OKC_REP_UTIL_PVT.change_contract_status(

1869: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1870: 'Calling OKC_REP_UTIL_PVT.change_contract_status');
1871: END IF;
1872: -- Update the contract status and add a record in OKC_REP_CON_STATUS_HIST table.
1873: OKC_REP_UTIL_PVT.change_contract_status(
1874: p_api_version => 1.0,
1875: p_init_msg_list => FND_API.G_FALSE,
1876: p_contract_id => l_contract_id,
1877: p_contract_version => l_contract_version,

Line 1887: 'Completed OKC_REP_UTIL_PVT.change_contract_status with return status: ' || l_return_status);

1883: x_return_status => l_return_status);
1884: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1885: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1886: g_module || l_api_name,
1887: 'Completed OKC_REP_UTIL_PVT.change_contract_status with return status: ' || l_return_status);
1888: END IF;
1889:
1890: -----------------------------------------------------
1891: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2195: 'Calling OKC_REP_UTIL_PVT.change_contract_status');

2191: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2192: g_module || l_api_name,
2193: 'Contract Version is: ' || to_char(l_contract_version));
2194: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2195: 'Calling OKC_REP_UTIL_PVT.change_contract_status');
2196: END IF;
2197:
2198: -- Update the contract status and add a record in OKC_REP_CON_STATUS_HIST table.
2199: OKC_REP_UTIL_PVT.change_contract_status(

Line 2199: OKC_REP_UTIL_PVT.change_contract_status(

2195: 'Calling OKC_REP_UTIL_PVT.change_contract_status');
2196: END IF;
2197:
2198: -- Update the contract status and add a record in OKC_REP_CON_STATUS_HIST table.
2199: OKC_REP_UTIL_PVT.change_contract_status(
2200: p_api_version => 1.0,
2201: p_init_msg_list => FND_API.G_FALSE,
2202: p_contract_id => l_contract_id,
2203: p_contract_version => l_contract_version,

Line 2213: 'Completed OKC_REP_UTIL_PVT.change_contract_status with return status: ' || l_return_status);

2209: x_return_status => l_return_status);
2210: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2211: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2212: g_module || l_api_name,
2213: 'Completed OKC_REP_UTIL_PVT.change_contract_status with return status: ' || l_return_status);
2214: END IF;
2215: -----------------------------------------------------
2216: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2217: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;