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.OKS_WF_K_PROCESS_PVT dependencies on FND_MESSAGE

Line 95: FUNCTION get_fnd_message RETURN VARCHAR2 IS

91: NegStatusUpdateException EXCEPTION;
92: ActionNotAllowedException EXCEPTION;
93: AlreadyPublishedException EXCEPTION;
94:
95: FUNCTION get_fnd_message RETURN VARCHAR2 IS
96: i NUMBER := 0;
97: l_return_status VARCHAR2(1);
98: l_msg_count NUMBER;
99: l_msg_data VARCHAR2(2000);

Line 119: END get_fnd_message;

115: l_mesg := l_mesg || ':' || i || ':' || l_msg_data;
116: END IF;
117: END LOOP;
118: RETURN l_mesg;
119: END get_fnd_message;
120:
121: FUNCTION replace_token
122: (
123: p_message IN VARCHAR2,

Line 470: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');

466: x_return_status := G_RET_STS_SUCCESS;
467: x_template_defined_yn := 'N';
468:
469: IF p_contract_id IS NULL THEN
470: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
471: FND_MESSAGE.SET_TOKEN('HDR_ID','null');
472: FND_MSG_PUB.add;
473: RAISE FND_API.G_EXC_ERROR;
474: END IF;

Line 471: FND_MESSAGE.SET_TOKEN('HDR_ID','null');

467: x_template_defined_yn := 'N';
468:
469: IF p_contract_id IS NULL THEN
470: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
471: FND_MESSAGE.SET_TOKEN('HDR_ID','null');
472: FND_MSG_PUB.add;
473: RAISE FND_API.G_EXC_ERROR;
474: END IF;
475: okc_context.set_okc_org_context(p_chr_id => p_contract_id);

Line 643: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,get_fnd_message);

639: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
640: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
641: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
642: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.ERROR');
643: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,get_fnd_message);
644: END IF;
645: WHEN OTHERS THEN
646: x_return_status := G_RET_STS_UNEXP_ERROR;
647: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 678: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');

674: IF p_item_key IS NULL THEN
675: IF p_contract_id IS NOT NULL THEN
676: l_item_key := get_wf_item_key(p_contract_id);
677: ELSE
678: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
679: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);
680: FND_MSG_PUB.add;
681: RAISE FND_API.G_EXC_ERROR;
682: END IF;

Line 679: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);

675: IF p_contract_id IS NOT NULL THEN
676: l_item_key := get_wf_item_key(p_contract_id);
677: ELSE
678: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
679: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);
680: FND_MSG_PUB.add;
681: RAISE FND_API.G_EXC_ERROR;
682: END IF;
683: ELSE

Line 887: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');

883: -- Initialize API return status to success
884: x_return_status := FND_API.G_RET_STS_SUCCESS;
885:
886: IF p_contract_id IS NULL THEN
887: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
888: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);
889: FND_MSG_PUB.add;
890: RAISE FND_API.G_EXC_ERROR;
891: END IF;

Line 888: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);

884: x_return_status := FND_API.G_RET_STS_SUCCESS;
885:
886: IF p_contract_id IS NULL THEN
887: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
888: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);
889: FND_MSG_PUB.add;
890: RAISE FND_API.G_EXC_ERROR;
891: END IF;
892:

Line 896: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');

892:
893: IF p_item_key IS NULL THEN
894: l_item_key := get_wf_item_key(p_contract_id => p_contract_id);
895: IF l_item_key IS NULL THEN
896: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
897: FND_MSG_PUB.add;
898: RAISE FND_API.G_EXC_ERROR;
899: END IF;
900: ELSE

Line 948: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,get_fnd_message);

944: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
945: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
946: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
947: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.ERROR');
948: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,get_fnd_message);
949: END IF;
950: WHEN OTHERS THEN
951: x_return_status := G_RET_STS_UNEXP_ERROR;
952: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1005: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');

1001:
1002: IF p_item_key IS NULL THEN
1003: l_item_key := get_wf_item_key(p_contract_id);
1004: IF l_item_key IS NULL THEN
1005: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
1006: FND_MSG_PUB.add;
1007: RAISE FND_API.G_EXC_ERROR;
1008: END IF;
1009: ELSE

Line 1076: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

1072: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1073: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1074: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
1075: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');
1076: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
1077: END IF;
1078: x_return_status := G_RET_STS_ERROR ;
1079:
1080: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1085: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

1081: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1082: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1083: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
1084: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');
1085: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
1086: END IF;
1087: x_return_status := G_RET_STS_UNEXP_ERROR ;
1088:
1089: WHEN OTHERS THEN

Line 1126: fnd_message.set_name(G_APP_NAME,'OKS_INVALID_NEG_STATUS');

1122: FETCH l_NegotiationStatus_csr INTO l_negotiation_status;
1123: CLOSE l_NegotiationStatus_csr;
1124:
1125: IF l_negotiation_status IS NULL THEN
1126: fnd_message.set_name(G_APP_NAME,'OKS_INVALID_NEG_STATUS');
1127: fnd_msg_pub.add;
1128: RAISE FND_API.G_EXC_ERROR;
1129: END IF;
1130:

Line 1287: fnd_message.set_name(G_APP_NAME,'OKS_NO_QTO_CONTACT');

1283: FETCH l_QToContact_csr INTO l_contact_id;
1284: CLOSE l_QToContact_csr;
1285:
1286: IF l_contact_id IS NULL THEN
1287: fnd_message.set_name(G_APP_NAME,'OKS_NO_QTO_CONTACT');
1288: fnd_msg_pub.add;
1289: RAISE FND_API.G_EXC_ERROR;
1290: END IF;
1291:

Line 1297: fnd_message.set_name(G_APP_NAME,'OKS_NO_QTO_EMAIL');

1293: FETCH l_emailAddress_csr INTO l_qto_email;
1294: CLOSE l_emailAddress_csr;
1295:
1296: IF l_qto_email IS NULL THEN
1297: fnd_message.set_name(G_APP_NAME,'OKS_NO_QTO_EMAIL');
1298: fnd_msg_pub.add;
1299: RAISE FND_API.G_EXC_ERROR;
1300: END IF;
1301:

Line 1464: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');

1460: FETCH l_kdetails_csr INTO l_kdetails_rec;
1461: l_rownotfound := l_kdetails_csr%NOTFOUND;
1462: CLOSE l_kdetails_csr;
1463: IF l_rownotfound THEN
1464: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
1465: FND_MESSAGE.SET_TOKEN('HDR_ID',p_notif_attr.CONTRACT_ID);
1466: FND_MSG_PUB.add;
1467: RAISE FND_API.G_EXC_ERROR;
1468: END IF;

Line 1465: FND_MESSAGE.SET_TOKEN('HDR_ID',p_notif_attr.CONTRACT_ID);

1461: l_rownotfound := l_kdetails_csr%NOTFOUND;
1462: CLOSE l_kdetails_csr;
1463: IF l_rownotfound THEN
1464: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
1465: FND_MESSAGE.SET_TOKEN('HDR_ID',p_notif_attr.CONTRACT_ID);
1466: FND_MSG_PUB.add;
1467: RAISE FND_API.G_EXC_ERROR;
1468: END IF;
1469:

Line 1631: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_ACCEPTED');

1627: 'Notification Type: '|| p_notif_attr.NTF_TYPE);
1628: END IF;
1629:
1630: IF p_notif_attr.NTF_TYPE = G_NTF_TYPE_ACCEPT THEN
1631: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_ACCEPTED');
1632: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
1633: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);
1634: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);
1635: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);

Line 1632: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);

1628: END IF;
1629:
1630: IF p_notif_attr.NTF_TYPE = G_NTF_TYPE_ACCEPT THEN
1631: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_ACCEPTED');
1632: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
1633: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);
1634: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);
1635: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);
1636: l_notif_subject := FND_MESSAGE.GET;

Line 1633: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);

1629:
1630: IF p_notif_attr.NTF_TYPE = G_NTF_TYPE_ACCEPT THEN
1631: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_ACCEPTED');
1632: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
1633: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);
1634: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);
1635: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);
1636: l_notif_subject := FND_MESSAGE.GET;
1637:

Line 1634: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);

1630: IF p_notif_attr.NTF_TYPE = G_NTF_TYPE_ACCEPT THEN
1631: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_ACCEPTED');
1632: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
1633: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);
1634: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);
1635: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);
1636: l_notif_subject := FND_MESSAGE.GET;
1637:
1638: ELSIF p_notif_attr.NTF_TYPE = G_NTF_TYPE_DECLINE THEN

Line 1635: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);

1631: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_ACCEPTED');
1632: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
1633: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);
1634: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);
1635: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);
1636: l_notif_subject := FND_MESSAGE.GET;
1637:
1638: ELSIF p_notif_attr.NTF_TYPE = G_NTF_TYPE_DECLINE THEN
1639: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_DECLINED');

Line 1636: l_notif_subject := FND_MESSAGE.GET;

1632: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
1633: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);
1634: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);
1635: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);
1636: l_notif_subject := FND_MESSAGE.GET;
1637:
1638: ELSIF p_notif_attr.NTF_TYPE = G_NTF_TYPE_DECLINE THEN
1639: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_DECLINED');
1640: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);

Line 1639: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_DECLINED');

1635: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);
1636: l_notif_subject := FND_MESSAGE.GET;
1637:
1638: ELSIF p_notif_attr.NTF_TYPE = G_NTF_TYPE_DECLINE THEN
1639: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_DECLINED');
1640: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
1641: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);
1642: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);
1643: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);

Line 1640: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);

1636: l_notif_subject := FND_MESSAGE.GET;
1637:
1638: ELSIF p_notif_attr.NTF_TYPE = G_NTF_TYPE_DECLINE THEN
1639: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_DECLINED');
1640: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
1641: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);
1642: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);
1643: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);
1644: l_notif_subject := FND_MESSAGE.GET;

Line 1641: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);

1637:
1638: ELSIF p_notif_attr.NTF_TYPE = G_NTF_TYPE_DECLINE THEN
1639: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_DECLINED');
1640: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
1641: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);
1642: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);
1643: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);
1644: l_notif_subject := FND_MESSAGE.GET;
1645:

Line 1642: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);

1638: ELSIF p_notif_attr.NTF_TYPE = G_NTF_TYPE_DECLINE THEN
1639: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_DECLINED');
1640: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
1641: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);
1642: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);
1643: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);
1644: l_notif_subject := FND_MESSAGE.GET;
1645:
1646: ELSIF p_notif_attr.NTF_TYPE = G_NTF_TYPE_RENEWED THEN

Line 1643: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);

1639: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_DECLINED');
1640: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
1641: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);
1642: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);
1643: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);
1644: l_notif_subject := FND_MESSAGE.GET;
1645:
1646: ELSIF p_notif_attr.NTF_TYPE = G_NTF_TYPE_RENEWED THEN
1647: -- Reset notification type since notification doesn't have any special region

Line 1644: l_notif_subject := FND_MESSAGE.GET;

1640: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
1641: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);
1642: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);
1643: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);
1644: l_notif_subject := FND_MESSAGE.GET;
1645:
1646: ELSIF p_notif_attr.NTF_TYPE = G_NTF_TYPE_RENEWED THEN
1647: -- Reset notification type since notification doesn't have any special region
1648: -- to be rendered.

Line 1661: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_RENEWED');

1657: OPEN l_old_k_num(p_notif_attr.CONTRACT_ID);
1658: FETCH l_old_k_num INTO l_old_k_number;
1659: CLOSE l_old_k_num;
1660:
1661: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_RENEWED');
1662: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_old_k_number);
1663: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);
1664: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);
1665: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);

Line 1662: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_old_k_number);

1658: FETCH l_old_k_num INTO l_old_k_number;
1659: CLOSE l_old_k_num;
1660:
1661: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_RENEWED');
1662: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_old_k_number);
1663: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);
1664: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);
1665: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);
1666: l_notif_subject := FND_MESSAGE.GET;

Line 1663: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);

1659: CLOSE l_old_k_num;
1660:
1661: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_RENEWED');
1662: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_old_k_number);
1663: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);
1664: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);
1665: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);
1666: l_notif_subject := FND_MESSAGE.GET;
1667:

Line 1664: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);

1660:
1661: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_RENEWED');
1662: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_old_k_number);
1663: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);
1664: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);
1665: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);
1666: l_notif_subject := FND_MESSAGE.GET;
1667:
1668: ELSIF p_notif_attr.NTF_TYPE = G_NTF_TYPE_ERROR THEN

Line 1665: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);

1661: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_RENEWED');
1662: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_old_k_number);
1663: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);
1664: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);
1665: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);
1666: l_notif_subject := FND_MESSAGE.GET;
1667:
1668: ELSIF p_notif_attr.NTF_TYPE = G_NTF_TYPE_ERROR THEN
1669: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_WF_ERROR');

Line 1666: l_notif_subject := FND_MESSAGE.GET;

1662: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_old_k_number);
1663: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);
1664: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);
1665: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);
1666: l_notif_subject := FND_MESSAGE.GET;
1667:
1668: ELSIF p_notif_attr.NTF_TYPE = G_NTF_TYPE_ERROR THEN
1669: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_WF_ERROR');
1670: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);

Line 1669: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_WF_ERROR');

1665: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);
1666: l_notif_subject := FND_MESSAGE.GET;
1667:
1668: ELSIF p_notif_attr.NTF_TYPE = G_NTF_TYPE_ERROR THEN
1669: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_WF_ERROR');
1670: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
1671: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);
1672: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);
1673: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);

Line 1670: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);

1666: l_notif_subject := FND_MESSAGE.GET;
1667:
1668: ELSIF p_notif_attr.NTF_TYPE = G_NTF_TYPE_ERROR THEN
1669: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_WF_ERROR');
1670: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
1671: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);
1672: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);
1673: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);
1674: l_notif_subject := FND_MESSAGE.GET;

Line 1671: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);

1667:
1668: ELSIF p_notif_attr.NTF_TYPE = G_NTF_TYPE_ERROR THEN
1669: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_WF_ERROR');
1670: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
1671: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);
1672: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);
1673: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);
1674: l_notif_subject := FND_MESSAGE.GET;
1675:

Line 1672: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);

1668: ELSIF p_notif_attr.NTF_TYPE = G_NTF_TYPE_ERROR THEN
1669: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_WF_ERROR');
1670: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
1671: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);
1672: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);
1673: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);
1674: l_notif_subject := FND_MESSAGE.GET;
1675:
1676: ELSIF p_notif_attr.NTF_TYPE = G_NTF_TYPE_MESSAGE THEN

Line 1673: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);

1669: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_WF_ERROR');
1670: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
1671: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);
1672: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);
1673: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);
1674: l_notif_subject := FND_MESSAGE.GET;
1675:
1676: ELSIF p_notif_attr.NTF_TYPE = G_NTF_TYPE_MESSAGE THEN
1677:

Line 1674: l_notif_subject := FND_MESSAGE.GET;

1670: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
1671: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);
1672: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);
1673: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);
1674: l_notif_subject := FND_MESSAGE.GET;
1675:
1676: ELSIF p_notif_attr.NTF_TYPE = G_NTF_TYPE_MESSAGE THEN
1677:
1678: OPEN l_qtocontact_name_csr(p_notif_attr.CONTRACT_ID);

Line 1682: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_REQUEST_ASSIST');

1678: OPEN l_qtocontact_name_csr(p_notif_attr.CONTRACT_ID);
1679: FETCH l_qtocontact_name_csr INTO l_qtocontact_name;
1680: CLOSE l_qtocontact_name_csr;
1681:
1682: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_REQUEST_ASSIST');
1683: FND_MESSAGE.SET_TOKEN('QTO_CONTACT',l_qtocontact_name);
1684: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
1685: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);
1686: l_notif_subject := FND_MESSAGE.GET;

Line 1683: FND_MESSAGE.SET_TOKEN('QTO_CONTACT',l_qtocontact_name);

1679: FETCH l_qtocontact_name_csr INTO l_qtocontact_name;
1680: CLOSE l_qtocontact_name_csr;
1681:
1682: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_REQUEST_ASSIST');
1683: FND_MESSAGE.SET_TOKEN('QTO_CONTACT',l_qtocontact_name);
1684: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
1685: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);
1686: l_notif_subject := FND_MESSAGE.GET;
1687:

Line 1684: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);

1680: CLOSE l_qtocontact_name_csr;
1681:
1682: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_REQUEST_ASSIST');
1683: FND_MESSAGE.SET_TOKEN('QTO_CONTACT',l_qtocontact_name);
1684: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
1685: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);
1686: l_notif_subject := FND_MESSAGE.GET;
1687:
1688: ELSIF p_notif_attr.NTF_TYPE = G_NTF_TYPE_QA_FAIL THEN

Line 1685: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);

1681:
1682: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_REQUEST_ASSIST');
1683: FND_MESSAGE.SET_TOKEN('QTO_CONTACT',l_qtocontact_name);
1684: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
1685: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);
1686: l_notif_subject := FND_MESSAGE.GET;
1687:
1688: ELSIF p_notif_attr.NTF_TYPE = G_NTF_TYPE_QA_FAIL THEN
1689: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_QA_FAIL');

Line 1686: l_notif_subject := FND_MESSAGE.GET;

1682: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_REQUEST_ASSIST');
1683: FND_MESSAGE.SET_TOKEN('QTO_CONTACT',l_qtocontact_name);
1684: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
1685: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);
1686: l_notif_subject := FND_MESSAGE.GET;
1687:
1688: ELSIF p_notif_attr.NTF_TYPE = G_NTF_TYPE_QA_FAIL THEN
1689: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_QA_FAIL');
1690: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);

Line 1689: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_QA_FAIL');

1685: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);
1686: l_notif_subject := FND_MESSAGE.GET;
1687:
1688: ELSIF p_notif_attr.NTF_TYPE = G_NTF_TYPE_QA_FAIL THEN
1689: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_QA_FAIL');
1690: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
1691: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);
1692: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);
1693: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);

Line 1690: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);

1686: l_notif_subject := FND_MESSAGE.GET;
1687:
1688: ELSIF p_notif_attr.NTF_TYPE = G_NTF_TYPE_QA_FAIL THEN
1689: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_QA_FAIL');
1690: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
1691: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);
1692: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);
1693: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);
1694: l_notif_subject := FND_MESSAGE.GET;

Line 1691: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);

1687:
1688: ELSIF p_notif_attr.NTF_TYPE = G_NTF_TYPE_QA_FAIL THEN
1689: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_QA_FAIL');
1690: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
1691: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);
1692: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);
1693: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);
1694: l_notif_subject := FND_MESSAGE.GET;
1695:

Line 1692: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);

1688: ELSIF p_notif_attr.NTF_TYPE = G_NTF_TYPE_QA_FAIL THEN
1689: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_QA_FAIL');
1690: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
1691: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);
1692: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);
1693: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);
1694: l_notif_subject := FND_MESSAGE.GET;
1695:
1696: ELSIF p_notif_attr.NTF_TYPE = G_NTF_TYPE_QUOTE_PB THEN

Line 1693: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);

1689: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_QA_FAIL');
1690: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
1691: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);
1692: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);
1693: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);
1694: l_notif_subject := FND_MESSAGE.GET;
1695:
1696: ELSIF p_notif_attr.NTF_TYPE = G_NTF_TYPE_QUOTE_PB THEN
1697: -- Reset notification type since notification doesn't have any special region

Line 1694: l_notif_subject := FND_MESSAGE.GET;

1690: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
1691: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);
1692: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);
1693: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);
1694: l_notif_subject := FND_MESSAGE.GET;
1695:
1696: ELSIF p_notif_attr.NTF_TYPE = G_NTF_TYPE_QUOTE_PB THEN
1697: -- Reset notification type since notification doesn't have any special region
1698: -- to be rendered.

Line 1707: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_QPUB_SUCCESS');

1703: aname => 'NTF_TYPE',
1704: avalue => NULL
1705: );
1706:
1707: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_QPUB_SUCCESS');
1708: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
1709: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);
1710: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);
1711: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);

Line 1708: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);

1704: avalue => NULL
1705: );
1706:
1707: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_QPUB_SUCCESS');
1708: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
1709: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);
1710: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);
1711: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);
1712: l_notif_subject := FND_MESSAGE.GET;

Line 1709: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);

1705: );
1706:
1707: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_QPUB_SUCCESS');
1708: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
1709: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);
1710: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);
1711: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);
1712: l_notif_subject := FND_MESSAGE.GET;
1713:

Line 1710: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);

1706:
1707: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_QPUB_SUCCESS');
1708: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
1709: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);
1710: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);
1711: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);
1712: l_notif_subject := FND_MESSAGE.GET;
1713:
1714: ELSIF p_notif_attr.NTF_TYPE = G_NTF_TYPE_ACTIVE THEN

Line 1711: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);

1707: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_QPUB_SUCCESS');
1708: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
1709: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);
1710: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);
1711: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);
1712: l_notif_subject := FND_MESSAGE.GET;
1713:
1714: ELSIF p_notif_attr.NTF_TYPE = G_NTF_TYPE_ACTIVE THEN
1715: -- Reset notification type since notification doesn't have any special region

Line 1712: l_notif_subject := FND_MESSAGE.GET;

1708: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
1709: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);
1710: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);
1711: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);
1712: l_notif_subject := FND_MESSAGE.GET;
1713:
1714: ELSIF p_notif_attr.NTF_TYPE = G_NTF_TYPE_ACTIVE THEN
1715: -- Reset notification type since notification doesn't have any special region
1716: -- to be rendered.

Line 1725: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_ACTIVATED');

1721: aname => 'NTF_TYPE',
1722: avalue => NULL
1723: );
1724:
1725: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_ACTIVATED');
1726: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
1727: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);
1728: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);
1729: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);

Line 1726: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);

1722: avalue => NULL
1723: );
1724:
1725: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_ACTIVATED');
1726: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
1727: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);
1728: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);
1729: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);
1730: l_notif_subject := FND_MESSAGE.GET;

Line 1727: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);

1723: );
1724:
1725: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_ACTIVATED');
1726: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
1727: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);
1728: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);
1729: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);
1730: l_notif_subject := FND_MESSAGE.GET;
1731:

Line 1728: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);

1724:
1725: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_ACTIVATED');
1726: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
1727: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);
1728: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);
1729: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);
1730: l_notif_subject := FND_MESSAGE.GET;
1731:
1732: ELSE

Line 1729: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);

1725: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NTF_SUB_ACTIVATED');
1726: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
1727: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);
1728: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);
1729: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);
1730: l_notif_subject := FND_MESSAGE.GET;
1731:
1732: ELSE
1733: RAISE FND_API.G_EXC_ERROR;

Line 1730: l_notif_subject := FND_MESSAGE.GET;

1726: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
1727: FND_MESSAGE.SET_TOKEN('K_AMOUNT',l_kdetails_rec.estimated_amount);
1728: FND_MESSAGE.SET_TOKEN('CURRENCY',l_kdetails_rec.currency_code);
1729: FND_MESSAGE.SET_TOKEN('CUST_NAME',l_party_name);
1730: l_notif_subject := FND_MESSAGE.GET;
1731:
1732: ELSE
1733: RAISE FND_API.G_EXC_ERROR;
1734: END IF;

Line 1781: FND_MESSAGE.CLEAR;

1777: aname => 'MESSAGE' || l_counter,
1778: avalue => l_msg_data
1779: );
1780: END LOOP;
1781: FND_MESSAGE.CLEAR;
1782: END IF;
1783: -- Messages are passed so assign them to wf message attibutes.
1784: ELSE
1785: IF p_notif_attr.MESSAGE1 IS NOT NULL THEN

Line 1905: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,get_fnd_message);

1901: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1902: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1903: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
1904: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.ERROR');
1905: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,get_fnd_message);
1906: END IF;
1907: WHEN OTHERS THEN
1908: x_return_status := G_RET_STS_UNEXP_ERROR;
1909: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 2037: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');

2033: -- Initialize API return status to success
2034: x_return_status := G_RET_STS_SUCCESS;
2035:
2036: IF p_email_attr.CONTRACT_ID IS NULL THEN
2037: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
2038: FND_MESSAGE.SET_TOKEN('HDR_ID','null');
2039: FND_MSG_PUB.add;
2040: RAISE FND_API.G_EXC_ERROR;
2041: END IF;

Line 2038: FND_MESSAGE.SET_TOKEN('HDR_ID','null');

2034: x_return_status := G_RET_STS_SUCCESS;
2035:
2036: IF p_email_attr.CONTRACT_ID IS NULL THEN
2037: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
2038: FND_MESSAGE.SET_TOKEN('HDR_ID','null');
2039: FND_MSG_PUB.add;
2040: RAISE FND_API.G_EXC_ERROR;
2041: END IF;
2042:

Line 2093: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_EMAIL_NOT_FOUND');

2089: CLOSE l_email_csr;
2090:
2091: IF l_rownotfound THEN
2092: -- Sender email is not found
2093: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_EMAIL_NOT_FOUND');
2094: FND_MESSAGE.SET_TOKEN('USER_NAME',l_salesrep_name);
2095: FND_MSG_PUB.add;
2096: RAISE FND_API.G_EXC_ERROR;
2097: END IF;

Line 2094: FND_MESSAGE.SET_TOKEN('USER_NAME',l_salesrep_name);

2090:
2091: IF l_rownotfound THEN
2092: -- Sender email is not found
2093: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_EMAIL_NOT_FOUND');
2094: FND_MESSAGE.SET_TOKEN('USER_NAME',l_salesrep_name);
2095: FND_MSG_PUB.add;
2096: RAISE FND_API.G_EXC_ERROR;
2097: END IF;
2098: ELSE

Line 2113: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');

2109: -- Get item key in order to retrieve contract information
2110: IF p_email_attr.ITEM_KEY IS NULL THEN
2111: l_item_key := get_wf_item_key(p_contract_id => p_email_attr.CONTRACT_ID);
2112: IF l_item_key IS NULL THEN
2113: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
2114: FND_MSG_PUB.add;
2115: RAISE FND_API.G_EXC_ERROR;
2116: END IF;
2117: ELSE

Line 2440: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,get_fnd_message);

2436: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2437: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2438: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
2439: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.ERROR');
2440: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,get_fnd_message);
2441: END IF;
2442: WHEN OTHERS THEN
2443: x_return_status := G_RET_STS_UNEXP_ERROR;
2444: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 2527: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');

2523:
2524: IF p_item_key IS NULL THEN
2525: l_item_key := get_wf_item_key(p_contract_id);
2526: IF l_item_key IS NULL THEN
2527: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
2528: FND_MSG_PUB.add;
2529: RAISE FND_API.G_EXC_ERROR;
2530: END IF;
2531: ELSE

Line 2741: fnd_message.set_name(G_APP_NAME,'OKS_INVALID_CUST_ACPT_ACTION');

2737: RAISE FND_API.G_EXC_ERROR;
2738: END IF;
2739: ELSE
2740: -- invalid activity
2741: fnd_message.set_name(G_APP_NAME,'OKS_INVALID_CUST_ACPT_ACTION');
2742: fnd_message.set_token('K_NUMBER',get_concat_k_number(p_contract_id));
2743: fnd_msg_pub.add;
2744: RAISE FND_API.G_EXC_ERROR;
2745: END IF;

Line 2742: fnd_message.set_token('K_NUMBER',get_concat_k_number(p_contract_id));

2738: END IF;
2739: ELSE
2740: -- invalid activity
2741: fnd_message.set_name(G_APP_NAME,'OKS_INVALID_CUST_ACPT_ACTION');
2742: fnd_message.set_token('K_NUMBER',get_concat_k_number(p_contract_id));
2743: fnd_msg_pub.add;
2744: RAISE FND_API.G_EXC_ERROR;
2745: END IF;
2746:

Line 2766: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

2762: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2763: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2764: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
2765: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');
2766: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
2767: END IF;
2768: x_return_status := G_RET_STS_ERROR;
2769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2770: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

Line 2775: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

2771: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2772: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2773: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
2774: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');
2775: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
2776: END IF;
2777: x_return_status := G_RET_STS_UNEXP_ERROR ;
2778: WHEN OTHERS THEN
2779: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

Line 2879: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');

2875:
2876: IF p_item_key IS NULL THEN
2877: l_item_key := get_wf_item_key(p_contract_id);
2878: IF l_item_key IS NULL THEN
2879: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
2880: FND_MSG_PUB.add;
2881: RAISE FND_API.G_EXC_ERROR;
2882: END IF;
2883: ELSE

Line 3112: FND_MESSAGE.set_name('OKS','OKS_CANT_CANCEL_K'); -- set the message here

3108: ELSIF x_return_status = G_RET_STS_ERROR THEN
3109: RAISE FND_API.G_EXC_ERROR;
3110: END IF;
3111: ELSE
3112: FND_MESSAGE.set_name('OKS','OKS_CANT_CANCEL_K'); -- set the message here
3113: FND_MESSAGE.set_token('K_NUMBER',get_concat_k_number(p_contract_id));
3114: fnd_msg_pub.add;
3115: RAISE FND_API.G_EXC_ERROR;
3116: END IF;

Line 3113: FND_MESSAGE.set_token('K_NUMBER',get_concat_k_number(p_contract_id));

3109: RAISE FND_API.G_EXC_ERROR;
3110: END IF;
3111: ELSE
3112: FND_MESSAGE.set_name('OKS','OKS_CANT_CANCEL_K'); -- set the message here
3113: FND_MESSAGE.set_token('K_NUMBER',get_concat_k_number(p_contract_id));
3114: fnd_msg_pub.add;
3115: RAISE FND_API.G_EXC_ERROR;
3116: END IF;
3117: ELSE

Line 3119: fnd_message.set_name(G_APP_NAME,'OKS_INVALID_CUST_DCLN_ACTION');

3115: RAISE FND_API.G_EXC_ERROR;
3116: END IF;
3117: ELSE
3118: -- invalid activity
3119: fnd_message.set_name(G_APP_NAME,'OKS_INVALID_CUST_DCLN_ACTION');
3120: fnd_message.set_token('K_NUMBER',get_concat_k_number(p_contract_id));
3121: fnd_msg_pub.add;
3122: RAISE FND_API.G_EXC_ERROR;
3123: END IF;

Line 3120: fnd_message.set_token('K_NUMBER',get_concat_k_number(p_contract_id));

3116: END IF;
3117: ELSE
3118: -- invalid activity
3119: fnd_message.set_name(G_APP_NAME,'OKS_INVALID_CUST_DCLN_ACTION');
3120: fnd_message.set_token('K_NUMBER',get_concat_k_number(p_contract_id));
3121: fnd_msg_pub.add;
3122: RAISE FND_API.G_EXC_ERROR;
3123: END IF;
3124:

Line 3145: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

3141: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3142: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3143: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
3144: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');
3145: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
3146: END IF;
3147: x_return_status := G_RET_STS_ERROR;
3148: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3149: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

Line 3154: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

3150: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3151: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3152: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
3153: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');
3154: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
3155: END IF;
3156: x_return_status := G_RET_STS_UNEXP_ERROR ;
3157: WHEN OTHERS THEN
3158: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

Line 3239: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');

3235:
3236: IF p_item_key IS NULL THEN
3237: l_item_key := get_wf_item_key(p_contract_id);
3238: IF l_item_key IS NULL THEN
3239: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
3240: FND_MSG_PUB.add;
3241: RAISE FND_API.G_EXC_ERROR;
3242: END IF;
3243: ELSE

Line 3362: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_CREATE_ADHOC_USER_FAILED');

3358: parent_orig_system => null,
3359: parent_orig_system_id => null);
3360: EXCEPTION
3361: WHEN OTHERS THEN
3362: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_CREATE_ADHOC_USER_FAILED');
3363: FND_MESSAGE.set_token('USER_NAME',l_user_tbl(k));
3364: FND_MESSAGE.set_token('SQL_ERROR',SQLERRM);
3365: FND_MSG_PUB.add;
3366: RAISE FND_API.G_EXC_ERROR;

Line 3363: FND_MESSAGE.set_token('USER_NAME',l_user_tbl(k));

3359: parent_orig_system_id => null);
3360: EXCEPTION
3361: WHEN OTHERS THEN
3362: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_CREATE_ADHOC_USER_FAILED');
3363: FND_MESSAGE.set_token('USER_NAME',l_user_tbl(k));
3364: FND_MESSAGE.set_token('SQL_ERROR',SQLERRM);
3365: FND_MSG_PUB.add;
3366: RAISE FND_API.G_EXC_ERROR;
3367: END;

Line 3364: FND_MESSAGE.set_token('SQL_ERROR',SQLERRM);

3360: EXCEPTION
3361: WHEN OTHERS THEN
3362: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_CREATE_ADHOC_USER_FAILED');
3363: FND_MESSAGE.set_token('USER_NAME',l_user_tbl(k));
3364: FND_MESSAGE.set_token('SQL_ERROR',SQLERRM);
3365: FND_MSG_PUB.add;
3366: RAISE FND_API.G_EXC_ERROR;
3367: END;
3368:

Line 3408: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_CREATE_ADHOC_ROLE_FAILED');

3404: owner_tag => null
3405: );
3406: EXCEPTION
3407: WHEN OTHERS THEN
3408: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_CREATE_ADHOC_ROLE_FAILED');
3409: FND_MESSAGE.set_token('ROLE_NAME',l_role_name);
3410: FND_MESSAGE.set_token('SQL_ERROR',SQLERRM);
3411: FND_MSG_PUB.add;
3412: RAISE FND_API.G_EXC_ERROR;

Line 3409: FND_MESSAGE.set_token('ROLE_NAME',l_role_name);

3405: );
3406: EXCEPTION
3407: WHEN OTHERS THEN
3408: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_CREATE_ADHOC_ROLE_FAILED');
3409: FND_MESSAGE.set_token('ROLE_NAME',l_role_name);
3410: FND_MESSAGE.set_token('SQL_ERROR',SQLERRM);
3411: FND_MSG_PUB.add;
3412: RAISE FND_API.G_EXC_ERROR;
3413: END;

Line 3410: FND_MESSAGE.set_token('SQL_ERROR',SQLERRM);

3406: EXCEPTION
3407: WHEN OTHERS THEN
3408: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_CREATE_ADHOC_ROLE_FAILED');
3409: FND_MESSAGE.set_token('ROLE_NAME',l_role_name);
3410: FND_MESSAGE.set_token('SQL_ERROR',SQLERRM);
3411: FND_MSG_PUB.add;
3412: RAISE FND_API.G_EXC_ERROR;
3413: END;
3414:

Line 3460: fnd_message.set_name(G_APP_NAME,'OKS_IH_SUBJECT_CUST_ASS');

3456: RAISE FND_API.G_EXC_ERROR;
3457: END IF;
3458:
3459: -- log interaction history
3460: fnd_message.set_name(G_APP_NAME,'OKS_IH_SUBJECT_CUST_ASS');
3461: l_interaction_subject := fnd_message.get;
3462:
3463: fnd_message.set_name(G_APP_NAME,'OKS_IH_MESSAGE_CUST_ASS');
3464: fnd_message.set_token('K_NUMBER',get_concat_k_number(p_contract_id));

Line 3461: l_interaction_subject := fnd_message.get;

3457: END IF;
3458:
3459: -- log interaction history
3460: fnd_message.set_name(G_APP_NAME,'OKS_IH_SUBJECT_CUST_ASS');
3461: l_interaction_subject := fnd_message.get;
3462:
3463: fnd_message.set_name(G_APP_NAME,'OKS_IH_MESSAGE_CUST_ASS');
3464: fnd_message.set_token('K_NUMBER',get_concat_k_number(p_contract_id));
3465: fnd_message.set_token('SUBJECT',p_subject);

Line 3463: fnd_message.set_name(G_APP_NAME,'OKS_IH_MESSAGE_CUST_ASS');

3459: -- log interaction history
3460: fnd_message.set_name(G_APP_NAME,'OKS_IH_SUBJECT_CUST_ASS');
3461: l_interaction_subject := fnd_message.get;
3462:
3463: fnd_message.set_name(G_APP_NAME,'OKS_IH_MESSAGE_CUST_ASS');
3464: fnd_message.set_token('K_NUMBER',get_concat_k_number(p_contract_id));
3465: fnd_message.set_token('SUBJECT',p_subject);
3466: fnd_message.set_token('MESSAGE',p_message);
3467: l_interaction_message := fnd_message.get;

Line 3464: fnd_message.set_token('K_NUMBER',get_concat_k_number(p_contract_id));

3460: fnd_message.set_name(G_APP_NAME,'OKS_IH_SUBJECT_CUST_ASS');
3461: l_interaction_subject := fnd_message.get;
3462:
3463: fnd_message.set_name(G_APP_NAME,'OKS_IH_MESSAGE_CUST_ASS');
3464: fnd_message.set_token('K_NUMBER',get_concat_k_number(p_contract_id));
3465: fnd_message.set_token('SUBJECT',p_subject);
3466: fnd_message.set_token('MESSAGE',p_message);
3467: l_interaction_message := fnd_message.get;
3468:

Line 3465: fnd_message.set_token('SUBJECT',p_subject);

3461: l_interaction_subject := fnd_message.get;
3462:
3463: fnd_message.set_name(G_APP_NAME,'OKS_IH_MESSAGE_CUST_ASS');
3464: fnd_message.set_token('K_NUMBER',get_concat_k_number(p_contract_id));
3465: fnd_message.set_token('SUBJECT',p_subject);
3466: fnd_message.set_token('MESSAGE',p_message);
3467: l_interaction_message := fnd_message.get;
3468:
3469: IF p_cc_email IS NULL THEN

Line 3466: fnd_message.set_token('MESSAGE',p_message);

3462:
3463: fnd_message.set_name(G_APP_NAME,'OKS_IH_MESSAGE_CUST_ASS');
3464: fnd_message.set_token('K_NUMBER',get_concat_k_number(p_contract_id));
3465: fnd_message.set_token('SUBJECT',p_subject);
3466: fnd_message.set_token('MESSAGE',p_message);
3467: l_interaction_message := fnd_message.get;
3468:
3469: IF p_cc_email IS NULL THEN
3470: l_role_email := l_salesrep_email;

Line 3467: l_interaction_message := fnd_message.get;

3463: fnd_message.set_name(G_APP_NAME,'OKS_IH_MESSAGE_CUST_ASS');
3464: fnd_message.set_token('K_NUMBER',get_concat_k_number(p_contract_id));
3465: fnd_message.set_token('SUBJECT',p_subject);
3466: fnd_message.set_token('MESSAGE',p_message);
3467: l_interaction_message := fnd_message.get;
3468:
3469: IF p_cc_email IS NULL THEN
3470: l_role_email := l_salesrep_email;
3471: ELSE

Line 3528: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_REQ_ASST_ACTION');

3524: END IF;
3525:
3526: ELSE
3527: -- invalid activity
3528: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_REQ_ASST_ACTION');
3529: fnd_message.set_token('K_NUMBER',get_concat_k_number(p_contract_id));
3530: FND_MSG_PUB.add;
3531: RAISE FND_API.G_EXC_ERROR;
3532: END IF;

Line 3529: fnd_message.set_token('K_NUMBER',get_concat_k_number(p_contract_id));

3525:
3526: ELSE
3527: -- invalid activity
3528: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_REQ_ASST_ACTION');
3529: fnd_message.set_token('K_NUMBER',get_concat_k_number(p_contract_id));
3530: FND_MSG_PUB.add;
3531: RAISE FND_API.G_EXC_ERROR;
3532: END IF;
3533:

Line 3554: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

3550: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3551: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3552: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
3553: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');
3554: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
3555: END IF;
3556: x_return_status := G_RET_STS_ERROR;
3557: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3558: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

Line 3563: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

3559: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3560: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3561: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
3562: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');
3563: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
3564: END IF;
3565: x_return_status := G_RET_STS_UNEXP_ERROR ;
3566: WHEN OTHERS THEN
3567: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

Line 3683: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

3679: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3680: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3681: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
3682: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');
3683: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
3684: END IF;
3685: x_return_status := G_RET_STS_ERROR;
3686: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3687: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

Line 3692: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

3688: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3689: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3690: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
3691: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');
3692: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
3693: END IF;
3694: x_return_status := G_RET_STS_UNEXP_ERROR ;
3695: WHEN OTHERS THEN
3696: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

Line 3876: l_msg_data := get_fnd_message;

3872: END IF; -- (funcmode = 'TIMEOUT')
3873:
3874: EXCEPTION
3875: WHEN FND_API.G_EXC_ERROR THEN
3876: l_msg_data := get_fnd_message;
3877: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3878: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
3879: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.FND_API.G_EXC_ERROR'
3880: ||' Itemtype: '||NVL(itemtype,'NULL')||' Itemkey: '||NVL(itemkey,'NULL'));

Line 4005: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');

4001: ' p_notif_subject: ' || p_notif_subject);
4002: END IF;
4003:
4004: IF p_contract_id IS NULL THEN
4005: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
4006: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);
4007: FND_MSG_PUB.add;
4008: RAISE FND_API.G_EXC_ERROR;
4009: END IF;

Line 4006: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);

4002: END IF;
4003:
4004: IF p_contract_id IS NULL THEN
4005: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
4006: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);
4007: FND_MSG_PUB.add;
4008: RAISE FND_API.G_EXC_ERROR;
4009: END IF;
4010:

Line 4065: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,get_fnd_message);

4061: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4062: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4063: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
4064: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.ERROR');
4065: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,get_fnd_message);
4066: END IF;
4067: WHEN OTHERS THEN
4068: x_return_status := G_RET_STS_UNEXP_ERROR;
4069: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 4204: l_msg_data := get_fnd_message;

4200: END IF; -- (funcmode = 'TIMEOUT')
4201:
4202: EXCEPTION
4203: WHEN FND_API.G_EXC_ERROR THEN
4204: l_msg_data := get_fnd_message;
4205: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4206: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
4207: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.FND_API.G_EXC_ERROR'
4208: ||' Itemtype: '||NVL(itemtype,'NULL')||' Itemkey: '||NVL(itemkey,'NULL'));

Line 4454: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');

4450: -- Initialize API return status to success
4451: x_return_status := G_RET_STS_SUCCESS;
4452:
4453: IF p_wf_attributes.contract_id IS NULL THEN
4454: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
4455: FND_MESSAGE.SET_TOKEN('HDR_ID','NULL');
4456: FND_MSG_PUB.add;
4457: RAISE FND_API.G_EXC_ERROR;
4458: END IF;

Line 4455: FND_MESSAGE.SET_TOKEN('HDR_ID','NULL');

4451: x_return_status := G_RET_STS_SUCCESS;
4452:
4453: IF p_wf_attributes.contract_id IS NULL THEN
4454: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
4455: FND_MESSAGE.SET_TOKEN('HDR_ID','NULL');
4456: FND_MSG_PUB.add;
4457: RAISE FND_API.G_EXC_ERROR;
4458: END IF;
4459:

Line 4679: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NO_WF_PROCESS');

4675: 'Workflow process not created for the contract ' ||
4676: NVL(l_contract_number,'NULL')||
4677: ' Please check the workflow background engine');
4678: END IF;
4679: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NO_WF_PROCESS');
4680: FND_MESSAGE.SET_TOKEN('CONTRACT_NUMBER',l_contract_number);
4681: FND_MSG_PUB.add;
4682: RAISE FND_API.G_EXC_ERROR;
4683: ELSE

Line 4680: FND_MESSAGE.SET_TOKEN('CONTRACT_NUMBER',l_contract_number);

4676: NVL(l_contract_number,'NULL')||
4677: ' Please check the workflow background engine');
4678: END IF;
4679: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NO_WF_PROCESS');
4680: FND_MESSAGE.SET_TOKEN('CONTRACT_NUMBER',l_contract_number);
4681: FND_MSG_PUB.add;
4682: RAISE FND_API.G_EXC_ERROR;
4683: ELSE
4684: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 4707: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

4703: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4704: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4705: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
4706: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');
4707: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
4708: END IF;
4709: x_return_status := G_RET_STS_ERROR;
4710: WHEN OTHERS THEN
4711: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

Line 4786: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');

4782: -- Initialize API return status to success
4783: x_return_status := G_RET_STS_SUCCESS;
4784:
4785: IF p_contract_id IS NULL THEN
4786: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
4787: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);
4788: FND_MSG_PUB.add;
4789: RAISE FND_API.G_EXC_ERROR;
4790: END IF;

Line 4787: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);

4783: x_return_status := G_RET_STS_SUCCESS;
4784:
4785: IF p_contract_id IS NULL THEN
4786: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
4787: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);
4788: FND_MSG_PUB.add;
4789: RAISE FND_API.G_EXC_ERROR;
4790: END IF;
4791:

Line 4795: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');

4791:
4792: IF p_item_key IS NULL THEN
4793: l_item_key := get_wf_item_key(p_contract_id => p_contract_id);
4794: IF l_item_key IS NULL THEN
4795: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
4796: FND_MSG_PUB.add;
4797: RAISE FND_API.G_EXC_ERROR;
4798: END IF;
4799: ELSE

Line 4837: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_RE_PUBLISH_ACTION');

4833: ELSIF x_return_status = G_RET_STS_ERROR THEN
4834: RAISE FND_API.G_EXC_ERROR;
4835: END IF;
4836: ELSE
4837: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_RE_PUBLISH_ACTION');
4838: FND_MESSAGE.set_token('K_NUMBER',get_concat_k_number(p_contract_id));
4839: FND_MSG_PUB.add;
4840: RAISE FND_API.G_EXC_ERROR;
4841: END IF;

Line 4838: FND_MESSAGE.set_token('K_NUMBER',get_concat_k_number(p_contract_id));

4834: RAISE FND_API.G_EXC_ERROR;
4835: END IF;
4836: ELSE
4837: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_RE_PUBLISH_ACTION');
4838: FND_MESSAGE.set_token('K_NUMBER',get_concat_k_number(p_contract_id));
4839: FND_MSG_PUB.add;
4840: RAISE FND_API.G_EXC_ERROR;
4841: END IF;
4842:

Line 4862: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

4858: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4859: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4860: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
4861: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');
4862: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
4863: END IF;
4864: x_return_status := G_RET_STS_ERROR;
4865: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4866: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

Line 4871: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

4867: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4868: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4869: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
4870: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');
4871: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
4872: END IF;
4873: x_return_status := G_RET_STS_UNEXP_ERROR ;
4874: WHEN OTHERS THEN
4875: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

Line 4948: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');

4944: -- Initialize API return status to success
4945: x_return_status := G_RET_STS_SUCCESS;
4946:
4947: IF p_contract_id IS NULL THEN
4948: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
4949: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);
4950: FND_MSG_PUB.add;
4951: RAISE FND_API.G_EXC_ERROR;
4952: END IF;

Line 4949: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);

4945: x_return_status := G_RET_STS_SUCCESS;
4946:
4947: IF p_contract_id IS NULL THEN
4948: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
4949: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);
4950: FND_MSG_PUB.add;
4951: RAISE FND_API.G_EXC_ERROR;
4952: END IF;
4953:

Line 4957: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');

4953:
4954: IF p_item_key IS NULL THEN
4955: l_item_key := get_wf_item_key(p_contract_id => p_contract_id);
4956: IF l_item_key IS NULL THEN
4957: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
4958: FND_MSG_PUB.add;
4959: RAISE FND_API.G_EXC_ERROR;
4960: END IF;
4961: ELSE

Line 5020: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

5016: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5017: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5018: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
5019: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');
5020: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
5021: END IF;
5022: x_return_status := G_RET_STS_ERROR;
5023: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5024: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

Line 5029: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

5025: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5026: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5027: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
5028: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');
5029: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
5030: END IF;
5031: x_return_status := G_RET_STS_UNEXP_ERROR ;
5032: WHEN OTHERS THEN
5033: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

Line 5535: l_msg_data := get_fnd_message;

5531: END IF; -- (funcmode = 'TIMEOUT')
5532:
5533: EXCEPTION
5534: WHEN FND_API.G_EXC_ERROR THEN
5535: l_msg_data := get_fnd_message;
5536: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5537: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
5538: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'Error: Itemtype: '
5539: ||NVL(itemtype,'NULL')||' Itemkey: '||NVL(itemkey,'NULL'));

Line 5672: l_msg_data := get_fnd_message;

5668: END IF; -- (funcmode = 'TIMEOUT')
5669:
5670: EXCEPTION
5671: WHEN FND_API.G_EXC_ERROR THEN
5672: l_msg_data := get_fnd_message;
5673: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5674: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
5675: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'Error: Itemtype: '
5676: ||NVL(itemtype,'NULL')||' Itemkey: '||NVL(itemkey,'NULL'));

Line 5863: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');

5859: -- Initialize API return status to success
5860: x_return_status := FND_API.G_RET_STS_SUCCESS;
5861:
5862: IF p_contract_id IS NULL THEN
5863: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
5864: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);
5865: FND_MSG_PUB.add;
5866: RAISE FND_API.G_EXC_ERROR;
5867: END IF;

Line 5864: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);

5860: x_return_status := FND_API.G_RET_STS_SUCCESS;
5861:
5862: IF p_contract_id IS NULL THEN
5863: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
5864: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);
5865: FND_MSG_PUB.add;
5866: RAISE FND_API.G_EXC_ERROR;
5867: END IF;
5868:

Line 5872: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');

5868:
5869: IF p_item_key IS NULL THEN
5870: l_item_key := get_wf_item_key(p_contract_id => p_contract_id);
5871: IF l_item_key IS NULL THEN
5872: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
5873: FND_MSG_PUB.add;
5874: RAISE FND_API.G_EXC_ERROR;
5875: END IF;
5876: ELSE

Line 5894: FND_MESSAGE.set_name(G_APP_NAME,'OKS_WAIT_CUST_ACCEPTANCE');

5890:
5891: IF x_activity_name = G_SALESREP_ACTION THEN
5892: x_return_status := G_RET_STS_SUCCESS;
5893: ELSIF x_activity_name = G_CUST_ACTION THEN
5894: FND_MESSAGE.set_name(G_APP_NAME,'OKS_WAIT_CUST_ACCEPTANCE');
5895: FND_MESSAGE.SET_TOKEN('K_NUMBER',get_concat_k_number(p_contract_id));
5896: FND_MSG_PUB.add;
5897: x_return_status := G_RET_STS_WARNING;
5898: x_activity_name := G_CUST_ACTION;

Line 5895: FND_MESSAGE.SET_TOKEN('K_NUMBER',get_concat_k_number(p_contract_id));

5891: IF x_activity_name = G_SALESREP_ACTION THEN
5892: x_return_status := G_RET_STS_SUCCESS;
5893: ELSIF x_activity_name = G_CUST_ACTION THEN
5894: FND_MESSAGE.set_name(G_APP_NAME,'OKS_WAIT_CUST_ACCEPTANCE');
5895: FND_MESSAGE.SET_TOKEN('K_NUMBER',get_concat_k_number(p_contract_id));
5896: FND_MSG_PUB.add;
5897: x_return_status := G_RET_STS_WARNING;
5898: x_activity_name := G_CUST_ACTION;
5899: ELSE

Line 5900: FND_MESSAGE.set_name(G_APP_NAME,'OKS_SUBMIT_APRVL_NOT_ALWD');

5896: FND_MSG_PUB.add;
5897: x_return_status := G_RET_STS_WARNING;
5898: x_activity_name := G_CUST_ACTION;
5899: ELSE
5900: FND_MESSAGE.set_name(G_APP_NAME,'OKS_SUBMIT_APRVL_NOT_ALWD');
5901: FND_MESSAGE.SET_TOKEN('K_NUMBER',get_concat_k_number(p_contract_id));
5902: FND_MSG_PUB.add;
5903: RAISE FND_API.G_EXC_ERROR;
5904: END IF;

Line 5901: FND_MESSAGE.SET_TOKEN('K_NUMBER',get_concat_k_number(p_contract_id));

5897: x_return_status := G_RET_STS_WARNING;
5898: x_activity_name := G_CUST_ACTION;
5899: ELSE
5900: FND_MESSAGE.set_name(G_APP_NAME,'OKS_SUBMIT_APRVL_NOT_ALWD');
5901: FND_MESSAGE.SET_TOKEN('K_NUMBER',get_concat_k_number(p_contract_id));
5902: FND_MSG_PUB.add;
5903: RAISE FND_API.G_EXC_ERROR;
5904: END IF;
5905: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 5925: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,get_fnd_message);

5921: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5922: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5923: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
5924: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.ERROR');
5925: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,get_fnd_message);
5926: END IF;
5927: WHEN OTHERS THEN
5928: x_return_status := G_RET_STS_UNEXP_ERROR;
5929: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 6125: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');

6121: -- Initialize API return status to success
6122: x_return_status := G_RET_STS_SUCCESS;
6123:
6124: IF p_contract_id IS NULL THEN
6125: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
6126: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);
6127: FND_MSG_PUB.add;
6128: RAISE FND_API.G_EXC_ERROR;
6129: END IF;

Line 6126: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);

6122: x_return_status := G_RET_STS_SUCCESS;
6123:
6124: IF p_contract_id IS NULL THEN
6125: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
6126: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);
6127: FND_MSG_PUB.add;
6128: RAISE FND_API.G_EXC_ERROR;
6129: END IF;
6130:

Line 6141: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');

6137:
6138: IF p_item_key IS NULL THEN
6139: l_item_key := get_wf_item_key(p_contract_id => p_contract_id);
6140: IF l_item_key IS NULL THEN
6141: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
6142: FND_MSG_PUB.add;
6143: RAISE FND_API.G_EXC_ERROR;
6144: END IF;
6145: ELSE

Line 6178: FND_MESSAGE.set_name(G_APP_NAME,'OKS_SUBMIT_APPROVAL_NOT_ALLOWED');

6174: p_item_type => G_ITEM_TYPE
6175: ,p_item_key => l_item_key
6176: );
6177: IF l_activity_name NOT IN (G_SALESREP_ACTION, G_CUST_ACTION) THEN
6178: FND_MESSAGE.set_name(G_APP_NAME,'OKS_SUBMIT_APPROVAL_NOT_ALLOWED');
6179: FND_MSG_PUB.add;
6180: RAISE FND_API.G_EXC_ERROR;
6181: ELSIF l_activity_name = G_CUST_ACTION THEN
6182:

Line 6372: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

6368: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6369: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6370: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
6371: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');
6372: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
6373: END IF;
6374: x_return_status := G_RET_STS_ERROR;
6375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6376: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

Line 6381: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

6377: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6378: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6379: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
6380: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');
6381: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
6382: END IF;
6383: x_return_status := G_RET_STS_UNEXP_ERROR ;
6384: WHEN OTHERS THEN
6385: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

Line 6463: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');

6459: -- Initialize API return status to success
6460: x_return_status := G_RET_STS_SUCCESS;
6461:
6462: IF p_contract_id IS NULL THEN
6463: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
6464: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);
6465: FND_MSG_PUB.add;
6466: RAISE FND_API.G_EXC_ERROR;
6467: END IF;

Line 6464: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);

6460: x_return_status := G_RET_STS_SUCCESS;
6461:
6462: IF p_contract_id IS NULL THEN
6463: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
6464: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);
6465: FND_MSG_PUB.add;
6466: RAISE FND_API.G_EXC_ERROR;
6467: END IF;
6468:

Line 6494: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');

6490:
6491: IF p_item_key IS NULL THEN
6492: l_item_key := get_wf_item_key(p_contract_id => p_contract_id);
6493: IF l_item_key IS NULL THEN
6494: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
6495: FND_MSG_PUB.add;
6496: RAISE FND_API.G_EXC_ERROR;
6497: END IF;
6498: ELSE

Line 6578: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

6574: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6575: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6576: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
6577: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');
6578: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
6579: END IF;
6580: x_return_status := G_RET_STS_ERROR;
6581: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6582: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

Line 6587: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

6583: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6584: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6585: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
6586: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');
6587: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
6588: END IF;
6589: x_return_status := G_RET_STS_UNEXP_ERROR ;
6590: WHEN OTHERS THEN
6591: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

Line 6694: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVALID_QA_CHECKLIST');

6690: OPEN l_qa_csr (l_contract_id);
6691: FETCH l_qa_csr INTO l_qa_rec;
6692: IF l_qa_csr%NOTFOUND OR l_qa_rec.qcl_id IS NULL THEN
6693: CLOSE l_qa_csr;
6694: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVALID_QA_CHECKLIST');
6695: IF l_qa_rec.contract_number_modifier IS NOT NULL THEN
6696: FND_MESSAGE.SET_TOKEN('CONTRACT_NUM',l_qa_rec.contract_number ||' - ' ||
6697: l_qa_rec.contract_number_modifier);
6698: ELSE

Line 6696: FND_MESSAGE.SET_TOKEN('CONTRACT_NUM',l_qa_rec.contract_number ||' - ' ||

6692: IF l_qa_csr%NOTFOUND OR l_qa_rec.qcl_id IS NULL THEN
6693: CLOSE l_qa_csr;
6694: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVALID_QA_CHECKLIST');
6695: IF l_qa_rec.contract_number_modifier IS NOT NULL THEN
6696: FND_MESSAGE.SET_TOKEN('CONTRACT_NUM',l_qa_rec.contract_number ||' - ' ||
6697: l_qa_rec.contract_number_modifier);
6698: ELSE
6699: FND_MESSAGE.SET_TOKEN('CONTRACT_NUM',l_qa_rec.contract_number);
6700: END IF;

Line 6699: FND_MESSAGE.SET_TOKEN('CONTRACT_NUM',l_qa_rec.contract_number);

6695: IF l_qa_rec.contract_number_modifier IS NOT NULL THEN
6696: FND_MESSAGE.SET_TOKEN('CONTRACT_NUM',l_qa_rec.contract_number ||' - ' ||
6697: l_qa_rec.contract_number_modifier);
6698: ELSE
6699: FND_MESSAGE.SET_TOKEN('CONTRACT_NUM',l_qa_rec.contract_number);
6700: END IF;
6701: FND_MSG_PUB.add;
6702: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6703: FND_LOG.STRING(FND_LOG.LEVEL_ERROR ,G_MODULE||l_api_name,'Invalid QA checklist ');

Line 6806: avalue => substr(get_fnd_message,1,1500)

6802: (
6803: itemtype => itemtype,
6804: itemkey => itemkey,
6805: aname => 'MESSAGE' || l_msg_ctr,
6806: avalue => substr(get_fnd_message,1,1500)
6807: );
6808: l_msg_ctr := l_msg_ctr + 1;
6809: END IF;
6810:

Line 6941: l_msg_data := get_fnd_message;

6937: END IF; -- (funcmode = 'TIMEOUT')
6938: EXCEPTION
6939: WHEN FND_API.G_EXC_ERROR THEN
6940: resultout := 'COMPLETE:F';
6941: l_msg_data := get_fnd_message;
6942: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6943: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
6944: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'Error: Itemtype: '
6945: ||NVL(itemtype,'NULL')||' Itemkey: '||NVL(itemkey,'NULL'));

Line 6966: l_notif_attr_rec.SUBJECT := substr(get_fnd_message,1,200);

6962: l_notif_attr_rec.ITEM_KEY := itemkey;
6963: l_notif_attr_rec.PERFORMER := NULL;
6964: l_notif_attr_rec.NTF_TYPE := G_NTF_TYPE_QA_FAIL;
6965: l_notif_attr_rec.NTF_SUBJECT := NULL;
6966: l_notif_attr_rec.SUBJECT := substr(get_fnd_message,1,200);
6967: l_notif_attr_rec.ACCEPT_DECLINE_BY := NULL;
6968: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6969: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
6970: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||

Line 7272: l_msg_data := get_fnd_message;

7268: END IF; -- (funcmode = 'TIMEOUT')
7269:
7270: EXCEPTION
7271: WHEN FND_API.G_EXC_ERROR THEN
7272: l_msg_data := get_fnd_message;
7273: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7274: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
7275: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'Error: Itemtype: '
7276: ||NVL(itemtype,'NULL')||' Itemkey: '||NVL(itemkey,'NULL'));

Line 7396: l_msg_data := get_fnd_message;

7392: END IF; -- (funcmode = 'TIMEOUT')
7393:
7394: EXCEPTION
7395: WHEN FND_API.G_EXC_ERROR THEN
7396: l_msg_data := get_fnd_message;
7397: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7398: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
7399: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'Error: Itemtype: '
7400: ||NVL(itemtype,'NULL')||' Itemkey: '||NVL(itemkey,'NULL'));

Line 7553: l_msg_data := get_fnd_message;

7549: END IF; -- (funcmode = 'TIMEOUT')
7550:
7551: EXCEPTION
7552: WHEN NegStatusUpdateException THEN
7553: l_msg_data := get_fnd_message;
7554: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7555: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
7556: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.NegStatusUpdateException'
7557: ||' Itemtype: '||NVL(itemtype,'NULL')||' Itemkey: '||NVL(itemkey,'NULL'));

Line 7569: l_msg_data := get_fnd_message;

7565: arg2 => itemkey,
7566: arg3 => l_msg_data
7567: );
7568: WHEN FND_API.G_EXC_ERROR THEN
7569: l_msg_data := get_fnd_message;
7570: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7571: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
7572: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'Error: Itemtype: '
7573: ||NVL(itemtype,'NULL')||' Itemkey: '||NVL(itemkey,'NULL'));

Line 7988: l_msg_data := get_fnd_message;

7984: END IF; -- (funcmode = 'TIMEOUT')
7985: EXCEPTION
7986: WHEN FND_API.G_EXC_ERROR THEN
7987: resultout := 'COMPLETE:ERROR';
7988: l_msg_data := get_fnd_message;
7989: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7990: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
7991: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'Error: Itemtype: '
7992: ||NVL(itemtype,'NULL')||' Itemkey: '||NVL(itemkey,'NULL'));

Line 8098: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');

8094: -- Initialize API return status to success
8095: x_return_status := G_RET_STS_SUCCESS;
8096:
8097: IF p_contract_id IS NULL THEN
8098: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
8099: FND_MESSAGE.SET_TOKEN('HDR_ID','NULL');
8100: FND_MSG_PUB.add;
8101: RAISE FND_API.G_EXC_ERROR;
8102: END IF;

Line 8099: FND_MESSAGE.SET_TOKEN('HDR_ID','NULL');

8095: x_return_status := G_RET_STS_SUCCESS;
8096:
8097: IF p_contract_id IS NULL THEN
8098: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
8099: FND_MESSAGE.SET_TOKEN('HDR_ID','NULL');
8100: FND_MSG_PUB.add;
8101: RAISE FND_API.G_EXC_ERROR;
8102: END IF;
8103:

Line 8107: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');

8103:
8104: IF p_item_key IS NULL THEN
8105: l_item_key := get_wf_item_key(p_contract_id => p_contract_id);
8106: IF l_item_key IS NULL THEN
8107: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
8108: FND_MSG_PUB.add;
8109: RAISE FND_API.G_EXC_ERROR;
8110: END IF;
8111: ELSE

Line 8167: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INV_SALESREP_ACPT_ACTION');

8163: p_item_type => G_ITEM_TYPE
8164: ,p_item_key => l_item_key
8165: );
8166: IF l_activity_name NOT IN (G_SALESREP_ACTION, G_CUST_ACTION) THEN
8167: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INV_SALESREP_ACPT_ACTION');
8168: FND_MSG_PUB.add;
8169: RAISE FND_API.G_EXC_ERROR;
8170: END IF;
8171:

Line 8216: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

8212: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
8213: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8214: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
8215: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');
8216: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
8217: END IF;
8218: x_return_status := G_RET_STS_ERROR;
8219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8220: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

Line 8225: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

8221: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
8222: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8223: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
8224: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');
8225: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
8226: END IF;
8227: x_return_status := G_RET_STS_UNEXP_ERROR ;
8228: WHEN OTHERS THEN
8229: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

Line 8331: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');

8327: -- Initialize API return status to success
8328: x_return_status := FND_API.G_RET_STS_SUCCESS;
8329:
8330: IF p_contract_id IS NULL THEN
8331: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
8332: FND_MESSAGE.SET_TOKEN('HDR_ID','NULL');
8333: FND_MSG_PUB.add;
8334: RAISE FND_API.G_EXC_ERROR;
8335: END IF;

Line 8332: FND_MESSAGE.SET_TOKEN('HDR_ID','NULL');

8328: x_return_status := FND_API.G_RET_STS_SUCCESS;
8329:
8330: IF p_contract_id IS NULL THEN
8331: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
8332: FND_MESSAGE.SET_TOKEN('HDR_ID','NULL');
8333: FND_MSG_PUB.add;
8334: RAISE FND_API.G_EXC_ERROR;
8335: END IF;
8336:

Line 8340: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');

8336:
8337: IF p_item_key IS NULL THEN
8338: l_item_key := get_wf_item_key(p_contract_id => p_contract_id);
8339: IF l_item_key IS NULL THEN
8340: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
8341: FND_MSG_PUB.add;
8342: RAISE FND_API.G_EXC_ERROR;
8343: END IF;
8344: ELSE

Line 8561: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

8557: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
8558: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8559: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
8560: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');
8561: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
8562: END IF;
8563: x_return_status := G_RET_STS_ERROR;
8564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8565: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

Line 8569: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

8565: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
8566: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8567: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
8568: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');
8569: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
8570: END IF;
8571: x_return_status := G_RET_STS_UNEXP_ERROR ;
8572: WHEN OTHERS THEN
8573: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

Line 8798: l_msg_data := get_fnd_message;

8794: END IF; -- (funcmode = 'TIMEOUT')
8795: EXCEPTION
8796: WHEN FND_API.G_EXC_ERROR THEN
8797: resultout := 'COMPLETE:F';
8798: l_msg_data := get_fnd_message;
8799: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8800: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
8801: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'Error: Itemtype: '
8802: ||NVL(itemtype,'NULL')||' Itemkey: '||NVL(itemkey,'NULL'));

Line 8815: l_msg_data := get_fnd_message;

8811: arg3 => l_msg_data
8812: );
8813: WHEN others THEN
8814: resultout := 'COMPLETE:F';
8815: l_msg_data := get_fnd_message;
8816: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8817: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
8818: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
8819: ||SQLCODE||', sqlerrm = '||SQLERRM);