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 2509: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');

2505:
2506: IF p_item_key IS NULL THEN
2507: l_item_key := get_wf_item_key(p_contract_id);
2508: IF l_item_key IS NULL THEN
2509: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
2510: FND_MSG_PUB.add;
2511: RAISE FND_API.G_EXC_ERROR;
2512: END IF;
2513: ELSE

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

2681: RAISE FND_API.G_EXC_ERROR;
2682: END IF;
2683: ELSE
2684: -- invalid activity
2685: fnd_message.set_name(G_APP_NAME,'OKS_INVALID_CUST_ACPT_ACTION');
2686: fnd_message.set_token('K_NUMBER',get_concat_k_number(p_contract_id));
2687: fnd_msg_pub.add;
2688: RAISE FND_API.G_EXC_ERROR;
2689: END IF;

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

2682: END IF;
2683: ELSE
2684: -- invalid activity
2685: fnd_message.set_name(G_APP_NAME,'OKS_INVALID_CUST_ACPT_ACTION');
2686: fnd_message.set_token('K_NUMBER',get_concat_k_number(p_contract_id));
2687: fnd_msg_pub.add;
2688: RAISE FND_API.G_EXC_ERROR;
2689: END IF;
2690:

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

2706: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2707: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2708: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
2709: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');
2710: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
2711: END IF;
2712: x_return_status := G_RET_STS_ERROR;
2713: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2714: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

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

2715: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2716: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2717: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
2718: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');
2719: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
2720: END IF;
2721: x_return_status := G_RET_STS_UNEXP_ERROR ;
2722: WHEN OTHERS THEN
2723: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

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

2797:
2798: IF p_item_key IS NULL THEN
2799: l_item_key := get_wf_item_key(p_contract_id);
2800: IF l_item_key IS NULL THEN
2801: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
2802: FND_MSG_PUB.add;
2803: RAISE FND_API.G_EXC_ERROR;
2804: END IF;
2805: ELSE

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

2992: ELSIF x_return_status = G_RET_STS_ERROR THEN
2993: RAISE FND_API.G_EXC_ERROR;
2994: END IF;
2995: ELSE
2996: FND_MESSAGE.set_name('OKS','OKS_CANT_CANCEL_K'); -- set the message here
2997: FND_MESSAGE.set_token('K_NUMBER',get_concat_k_number(p_contract_id));
2998: fnd_msg_pub.add;
2999: RAISE FND_API.G_EXC_ERROR;
3000: END IF;

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

2993: RAISE FND_API.G_EXC_ERROR;
2994: END IF;
2995: ELSE
2996: FND_MESSAGE.set_name('OKS','OKS_CANT_CANCEL_K'); -- set the message here
2997: FND_MESSAGE.set_token('K_NUMBER',get_concat_k_number(p_contract_id));
2998: fnd_msg_pub.add;
2999: RAISE FND_API.G_EXC_ERROR;
3000: END IF;
3001: ELSE

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

2999: RAISE FND_API.G_EXC_ERROR;
3000: END IF;
3001: ELSE
3002: -- invalid activity
3003: fnd_message.set_name(G_APP_NAME,'OKS_INVALID_CUST_DCLN_ACTION');
3004: fnd_message.set_token('K_NUMBER',get_concat_k_number(p_contract_id));
3005: fnd_msg_pub.add;
3006: RAISE FND_API.G_EXC_ERROR;
3007: END IF;

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

3000: END IF;
3001: ELSE
3002: -- invalid activity
3003: fnd_message.set_name(G_APP_NAME,'OKS_INVALID_CUST_DCLN_ACTION');
3004: fnd_message.set_token('K_NUMBER',get_concat_k_number(p_contract_id));
3005: fnd_msg_pub.add;
3006: RAISE FND_API.G_EXC_ERROR;
3007: END IF;
3008:

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

3025: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3026: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3027: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
3028: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');
3029: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
3030: END IF;
3031: x_return_status := G_RET_STS_ERROR;
3032: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3033: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

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

3034: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3035: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3036: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
3037: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');
3038: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
3039: END IF;
3040: x_return_status := G_RET_STS_UNEXP_ERROR ;
3041: WHEN OTHERS THEN
3042: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

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

3119:
3120: IF p_item_key IS NULL THEN
3121: l_item_key := get_wf_item_key(p_contract_id);
3122: IF l_item_key IS NULL THEN
3123: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
3124: FND_MSG_PUB.add;
3125: RAISE FND_API.G_EXC_ERROR;
3126: END IF;
3127: ELSE

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

3242: parent_orig_system => null,
3243: parent_orig_system_id => null);
3244: EXCEPTION
3245: WHEN OTHERS THEN
3246: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_CREATE_ADHOC_USER_FAILED');
3247: FND_MESSAGE.set_token('USER_NAME',l_user_tbl(k));
3248: FND_MESSAGE.set_token('SQL_ERROR',SQLERRM);
3249: FND_MSG_PUB.add;
3250: RAISE FND_API.G_EXC_ERROR;

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

3243: parent_orig_system_id => null);
3244: EXCEPTION
3245: WHEN OTHERS THEN
3246: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_CREATE_ADHOC_USER_FAILED');
3247: FND_MESSAGE.set_token('USER_NAME',l_user_tbl(k));
3248: FND_MESSAGE.set_token('SQL_ERROR',SQLERRM);
3249: FND_MSG_PUB.add;
3250: RAISE FND_API.G_EXC_ERROR;
3251: END;

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

3244: EXCEPTION
3245: WHEN OTHERS THEN
3246: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_CREATE_ADHOC_USER_FAILED');
3247: FND_MESSAGE.set_token('USER_NAME',l_user_tbl(k));
3248: FND_MESSAGE.set_token('SQL_ERROR',SQLERRM);
3249: FND_MSG_PUB.add;
3250: RAISE FND_API.G_EXC_ERROR;
3251: END;
3252:

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

3288: owner_tag => null
3289: );
3290: EXCEPTION
3291: WHEN OTHERS THEN
3292: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_CREATE_ADHOC_ROLE_FAILED');
3293: FND_MESSAGE.set_token('ROLE_NAME',l_role_name);
3294: FND_MESSAGE.set_token('SQL_ERROR',SQLERRM);
3295: FND_MSG_PUB.add;
3296: RAISE FND_API.G_EXC_ERROR;

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

3289: );
3290: EXCEPTION
3291: WHEN OTHERS THEN
3292: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_CREATE_ADHOC_ROLE_FAILED');
3293: FND_MESSAGE.set_token('ROLE_NAME',l_role_name);
3294: FND_MESSAGE.set_token('SQL_ERROR',SQLERRM);
3295: FND_MSG_PUB.add;
3296: RAISE FND_API.G_EXC_ERROR;
3297: END;

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

3290: EXCEPTION
3291: WHEN OTHERS THEN
3292: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_CREATE_ADHOC_ROLE_FAILED');
3293: FND_MESSAGE.set_token('ROLE_NAME',l_role_name);
3294: FND_MESSAGE.set_token('SQL_ERROR',SQLERRM);
3295: FND_MSG_PUB.add;
3296: RAISE FND_API.G_EXC_ERROR;
3297: END;
3298:

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

3340: RAISE FND_API.G_EXC_ERROR;
3341: END IF;
3342:
3343: -- log interaction history
3344: fnd_message.set_name(G_APP_NAME,'OKS_IH_SUBJECT_CUST_ASS');
3345: l_interaction_subject := fnd_message.get;
3346:
3347: fnd_message.set_name(G_APP_NAME,'OKS_IH_MESSAGE_CUST_ASS');
3348: fnd_message.set_token('K_NUMBER',get_concat_k_number(p_contract_id));

Line 3345: l_interaction_subject := fnd_message.get;

3341: END IF;
3342:
3343: -- log interaction history
3344: fnd_message.set_name(G_APP_NAME,'OKS_IH_SUBJECT_CUST_ASS');
3345: l_interaction_subject := fnd_message.get;
3346:
3347: fnd_message.set_name(G_APP_NAME,'OKS_IH_MESSAGE_CUST_ASS');
3348: fnd_message.set_token('K_NUMBER',get_concat_k_number(p_contract_id));
3349: fnd_message.set_token('SUBJECT',p_subject);

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

3343: -- log interaction history
3344: fnd_message.set_name(G_APP_NAME,'OKS_IH_SUBJECT_CUST_ASS');
3345: l_interaction_subject := fnd_message.get;
3346:
3347: fnd_message.set_name(G_APP_NAME,'OKS_IH_MESSAGE_CUST_ASS');
3348: fnd_message.set_token('K_NUMBER',get_concat_k_number(p_contract_id));
3349: fnd_message.set_token('SUBJECT',p_subject);
3350: fnd_message.set_token('MESSAGE',p_message);
3351: l_interaction_message := fnd_message.get;

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

3344: fnd_message.set_name(G_APP_NAME,'OKS_IH_SUBJECT_CUST_ASS');
3345: l_interaction_subject := fnd_message.get;
3346:
3347: fnd_message.set_name(G_APP_NAME,'OKS_IH_MESSAGE_CUST_ASS');
3348: fnd_message.set_token('K_NUMBER',get_concat_k_number(p_contract_id));
3349: fnd_message.set_token('SUBJECT',p_subject);
3350: fnd_message.set_token('MESSAGE',p_message);
3351: l_interaction_message := fnd_message.get;
3352:

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

3345: l_interaction_subject := fnd_message.get;
3346:
3347: fnd_message.set_name(G_APP_NAME,'OKS_IH_MESSAGE_CUST_ASS');
3348: fnd_message.set_token('K_NUMBER',get_concat_k_number(p_contract_id));
3349: fnd_message.set_token('SUBJECT',p_subject);
3350: fnd_message.set_token('MESSAGE',p_message);
3351: l_interaction_message := fnd_message.get;
3352:
3353: IF p_cc_email IS NULL THEN

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

3346:
3347: fnd_message.set_name(G_APP_NAME,'OKS_IH_MESSAGE_CUST_ASS');
3348: fnd_message.set_token('K_NUMBER',get_concat_k_number(p_contract_id));
3349: fnd_message.set_token('SUBJECT',p_subject);
3350: fnd_message.set_token('MESSAGE',p_message);
3351: l_interaction_message := fnd_message.get;
3352:
3353: IF p_cc_email IS NULL THEN
3354: l_role_email := l_salesrep_email;

Line 3351: l_interaction_message := fnd_message.get;

3347: fnd_message.set_name(G_APP_NAME,'OKS_IH_MESSAGE_CUST_ASS');
3348: fnd_message.set_token('K_NUMBER',get_concat_k_number(p_contract_id));
3349: fnd_message.set_token('SUBJECT',p_subject);
3350: fnd_message.set_token('MESSAGE',p_message);
3351: l_interaction_message := fnd_message.get;
3352:
3353: IF p_cc_email IS NULL THEN
3354: l_role_email := l_salesrep_email;
3355: ELSE

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

3408: END IF;
3409:
3410: ELSE
3411: -- invalid activity
3412: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_REQ_ASST_ACTION');
3413: fnd_message.set_token('K_NUMBER',get_concat_k_number(p_contract_id));
3414: FND_MSG_PUB.add;
3415: RAISE FND_API.G_EXC_ERROR;
3416: END IF;

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

3409:
3410: ELSE
3411: -- invalid activity
3412: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_REQ_ASST_ACTION');
3413: fnd_message.set_token('K_NUMBER',get_concat_k_number(p_contract_id));
3414: FND_MSG_PUB.add;
3415: RAISE FND_API.G_EXC_ERROR;
3416: END IF;
3417:

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

3434: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3435: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3436: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
3437: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');
3438: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
3439: END IF;
3440: x_return_status := G_RET_STS_ERROR;
3441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3442: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

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

3443: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3444: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3445: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
3446: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');
3447: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
3448: END IF;
3449: x_return_status := G_RET_STS_UNEXP_ERROR ;
3450: WHEN OTHERS THEN
3451: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

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

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

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

3570: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3571: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3572: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
3573: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');
3574: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
3575: END IF;
3576: x_return_status := G_RET_STS_UNEXP_ERROR ;
3577: WHEN OTHERS THEN
3578: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

Line 3758: l_msg_data := get_fnd_message;

3754: END IF; -- (funcmode = 'TIMEOUT')
3755:
3756: EXCEPTION
3757: WHEN FND_API.G_EXC_ERROR THEN
3758: l_msg_data := get_fnd_message;
3759: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3760: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
3761: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.FND_API.G_EXC_ERROR'
3762: ||' Itemtype: '||NVL(itemtype,'NULL')||' Itemkey: '||NVL(itemkey,'NULL'));

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

3883: ' p_notif_subject: ' || p_notif_subject);
3884: END IF;
3885:
3886: IF p_contract_id IS NULL THEN
3887: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
3888: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);
3889: FND_MSG_PUB.add;
3890: RAISE FND_API.G_EXC_ERROR;
3891: END IF;

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

3884: END IF;
3885:
3886: IF p_contract_id IS NULL THEN
3887: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
3888: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);
3889: FND_MSG_PUB.add;
3890: RAISE FND_API.G_EXC_ERROR;
3891: END IF;
3892:

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

3943: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3944: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3945: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
3946: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.ERROR');
3947: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,get_fnd_message);
3948: END IF;
3949: WHEN OTHERS THEN
3950: x_return_status := G_RET_STS_UNEXP_ERROR;
3951: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 4086: l_msg_data := get_fnd_message;

4082: END IF; -- (funcmode = 'TIMEOUT')
4083:
4084: EXCEPTION
4085: WHEN FND_API.G_EXC_ERROR THEN
4086: l_msg_data := get_fnd_message;
4087: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4088: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
4089: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.FND_API.G_EXC_ERROR'
4090: ||' Itemtype: '||NVL(itemtype,'NULL')||' Itemkey: '||NVL(itemkey,'NULL'));

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

4323: -- Initialize API return status to success
4324: x_return_status := G_RET_STS_SUCCESS;
4325:
4326: IF p_wf_attributes.contract_id IS NULL THEN
4327: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
4328: FND_MESSAGE.SET_TOKEN('HDR_ID','NULL');
4329: FND_MSG_PUB.add;
4330: RAISE FND_API.G_EXC_ERROR;
4331: END IF;

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

4324: x_return_status := G_RET_STS_SUCCESS;
4325:
4326: IF p_wf_attributes.contract_id IS NULL THEN
4327: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
4328: FND_MESSAGE.SET_TOKEN('HDR_ID','NULL');
4329: FND_MSG_PUB.add;
4330: RAISE FND_API.G_EXC_ERROR;
4331: END IF;
4332:

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

4548: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4549: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4550: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
4551: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');
4552: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
4553: END IF;
4554: x_return_status := G_RET_STS_ERROR;
4555: WHEN OTHERS THEN
4556: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

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

4627: -- Initialize API return status to success
4628: x_return_status := G_RET_STS_SUCCESS;
4629:
4630: IF p_contract_id IS NULL THEN
4631: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
4632: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);
4633: FND_MSG_PUB.add;
4634: RAISE FND_API.G_EXC_ERROR;
4635: END IF;

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

4628: x_return_status := G_RET_STS_SUCCESS;
4629:
4630: IF p_contract_id IS NULL THEN
4631: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
4632: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);
4633: FND_MSG_PUB.add;
4634: RAISE FND_API.G_EXC_ERROR;
4635: END IF;
4636:

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

4636:
4637: IF p_item_key IS NULL THEN
4638: l_item_key := get_wf_item_key(p_contract_id => p_contract_id);
4639: IF l_item_key IS NULL THEN
4640: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
4641: FND_MSG_PUB.add;
4642: RAISE FND_API.G_EXC_ERROR;
4643: END IF;
4644: ELSE

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

4678: ELSIF x_return_status = G_RET_STS_ERROR THEN
4679: RAISE FND_API.G_EXC_ERROR;
4680: END IF;
4681: ELSE
4682: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_RE_PUBLISH_ACTION');
4683: FND_MESSAGE.set_token('K_NUMBER',get_concat_k_number(p_contract_id));
4684: FND_MSG_PUB.add;
4685: RAISE FND_API.G_EXC_ERROR;
4686: END IF;

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

4679: RAISE FND_API.G_EXC_ERROR;
4680: END IF;
4681: ELSE
4682: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_RE_PUBLISH_ACTION');
4683: FND_MESSAGE.set_token('K_NUMBER',get_concat_k_number(p_contract_id));
4684: FND_MSG_PUB.add;
4685: RAISE FND_API.G_EXC_ERROR;
4686: END IF;
4687:

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 FND_API.G_EXC_UNEXPECTED_ERROR THEN
4711: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

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

4712: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4713: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4714: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
4715: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');
4716: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
4717: END IF;
4718: x_return_status := G_RET_STS_UNEXP_ERROR ;
4719: WHEN OTHERS THEN
4720: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

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

4789: -- Initialize API return status to success
4790: x_return_status := G_RET_STS_SUCCESS;
4791:
4792: IF p_contract_id IS NULL THEN
4793: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
4794: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);
4795: FND_MSG_PUB.add;
4796: RAISE FND_API.G_EXC_ERROR;
4797: END IF;

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

4790: x_return_status := G_RET_STS_SUCCESS;
4791:
4792: IF p_contract_id IS NULL THEN
4793: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
4794: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);
4795: FND_MSG_PUB.add;
4796: RAISE FND_API.G_EXC_ERROR;
4797: END IF;
4798:

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

4798:
4799: IF p_item_key IS NULL THEN
4800: l_item_key := get_wf_item_key(p_contract_id => p_contract_id);
4801: IF l_item_key IS NULL THEN
4802: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
4803: FND_MSG_PUB.add;
4804: RAISE FND_API.G_EXC_ERROR;
4805: END IF;
4806: ELSE

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

4850: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4851: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4852: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
4853: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');
4854: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
4855: END IF;
4856: x_return_status := G_RET_STS_ERROR;
4857: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4858: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

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

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

Line 5369: l_msg_data := get_fnd_message;

5365: END IF; -- (funcmode = 'TIMEOUT')
5366:
5367: EXCEPTION
5368: WHEN FND_API.G_EXC_ERROR THEN
5369: l_msg_data := get_fnd_message;
5370: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5371: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
5372: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'Error: Itemtype: '
5373: ||NVL(itemtype,'NULL')||' Itemkey: '||NVL(itemkey,'NULL'));

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

5555: -- Initialize API return status to success
5556: x_return_status := FND_API.G_RET_STS_SUCCESS;
5557:
5558: IF p_contract_id IS NULL THEN
5559: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
5560: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);
5561: FND_MSG_PUB.add;
5562: RAISE FND_API.G_EXC_ERROR;
5563: END IF;

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

5556: x_return_status := FND_API.G_RET_STS_SUCCESS;
5557:
5558: IF p_contract_id IS NULL THEN
5559: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
5560: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);
5561: FND_MSG_PUB.add;
5562: RAISE FND_API.G_EXC_ERROR;
5563: END IF;
5564:

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

5564:
5565: IF p_item_key IS NULL THEN
5566: l_item_key := get_wf_item_key(p_contract_id => p_contract_id);
5567: IF l_item_key IS NULL THEN
5568: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
5569: FND_MSG_PUB.add;
5570: RAISE FND_API.G_EXC_ERROR;
5571: END IF;
5572: ELSE

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

5586:
5587: IF x_activity_name = G_SALESREP_ACTION THEN
5588: x_return_status := G_RET_STS_SUCCESS;
5589: ELSIF x_activity_name = G_CUST_ACTION THEN
5590: FND_MESSAGE.set_name(G_APP_NAME,'OKS_WAIT_CUST_ACCEPTANCE');
5591: FND_MESSAGE.SET_TOKEN('K_NUMBER',get_concat_k_number(p_contract_id));
5592: FND_MSG_PUB.add;
5593: x_return_status := G_RET_STS_WARNING;
5594: x_activity_name := G_CUST_ACTION;

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

5587: IF x_activity_name = G_SALESREP_ACTION THEN
5588: x_return_status := G_RET_STS_SUCCESS;
5589: ELSIF x_activity_name = G_CUST_ACTION THEN
5590: FND_MESSAGE.set_name(G_APP_NAME,'OKS_WAIT_CUST_ACCEPTANCE');
5591: FND_MESSAGE.SET_TOKEN('K_NUMBER',get_concat_k_number(p_contract_id));
5592: FND_MSG_PUB.add;
5593: x_return_status := G_RET_STS_WARNING;
5594: x_activity_name := G_CUST_ACTION;
5595: ELSE

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

5592: FND_MSG_PUB.add;
5593: x_return_status := G_RET_STS_WARNING;
5594: x_activity_name := G_CUST_ACTION;
5595: ELSE
5596: FND_MESSAGE.set_name(G_APP_NAME,'OKS_SUBMIT_APRVL_NOT_ALWD');
5597: FND_MESSAGE.SET_TOKEN('K_NUMBER',get_concat_k_number(p_contract_id));
5598: FND_MSG_PUB.add;
5599: RAISE FND_API.G_EXC_ERROR;
5600: END IF;

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

5593: x_return_status := G_RET_STS_WARNING;
5594: x_activity_name := G_CUST_ACTION;
5595: ELSE
5596: FND_MESSAGE.set_name(G_APP_NAME,'OKS_SUBMIT_APRVL_NOT_ALWD');
5597: FND_MESSAGE.SET_TOKEN('K_NUMBER',get_concat_k_number(p_contract_id));
5598: FND_MSG_PUB.add;
5599: RAISE FND_API.G_EXC_ERROR;
5600: END IF;
5601: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

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

5617: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5618: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5619: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
5620: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.ERROR');
5621: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,get_fnd_message);
5622: END IF;
5623: WHEN OTHERS THEN
5624: x_return_status := G_RET_STS_UNEXP_ERROR;
5625: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

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

5817: -- Initialize API return status to success
5818: x_return_status := G_RET_STS_SUCCESS;
5819:
5820: IF p_contract_id IS NULL THEN
5821: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
5822: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);
5823: FND_MSG_PUB.add;
5824: RAISE FND_API.G_EXC_ERROR;
5825: END IF;

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

5818: x_return_status := G_RET_STS_SUCCESS;
5819:
5820: IF p_contract_id IS NULL THEN
5821: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
5822: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);
5823: FND_MSG_PUB.add;
5824: RAISE FND_API.G_EXC_ERROR;
5825: END IF;
5826:

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

5833:
5834: IF p_item_key IS NULL THEN
5835: l_item_key := get_wf_item_key(p_contract_id => p_contract_id);
5836: IF l_item_key IS NULL THEN
5837: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
5838: FND_MSG_PUB.add;
5839: RAISE FND_API.G_EXC_ERROR;
5840: END IF;
5841: ELSE

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

5870: p_item_type => G_ITEM_TYPE
5871: ,p_item_key => l_item_key
5872: );
5873: IF l_activity_name NOT IN (G_SALESREP_ACTION, G_CUST_ACTION) THEN
5874: FND_MESSAGE.set_name(G_APP_NAME,'OKS_SUBMIT_APPROVAL_NOT_ALLOWED');
5875: FND_MSG_PUB.add;
5876: RAISE FND_API.G_EXC_ERROR;
5877: ELSIF l_activity_name = G_CUST_ACTION THEN
5878:

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

6064: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6065: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6066: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
6067: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');
6068: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
6069: END IF;
6070: x_return_status := G_RET_STS_ERROR;
6071: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6072: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

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

6073: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6074: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6075: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
6076: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');
6077: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
6078: END IF;
6079: x_return_status := G_RET_STS_UNEXP_ERROR ;
6080: WHEN OTHERS THEN
6081: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

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

6155: -- Initialize API return status to success
6156: x_return_status := G_RET_STS_SUCCESS;
6157:
6158: IF p_contract_id IS NULL THEN
6159: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
6160: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);
6161: FND_MSG_PUB.add;
6162: RAISE FND_API.G_EXC_ERROR;
6163: END IF;

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

6156: x_return_status := G_RET_STS_SUCCESS;
6157:
6158: IF p_contract_id IS NULL THEN
6159: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
6160: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);
6161: FND_MSG_PUB.add;
6162: RAISE FND_API.G_EXC_ERROR;
6163: END IF;
6164:

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

6186:
6187: IF p_item_key IS NULL THEN
6188: l_item_key := get_wf_item_key(p_contract_id => p_contract_id);
6189: IF l_item_key IS NULL THEN
6190: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
6191: FND_MSG_PUB.add;
6192: RAISE FND_API.G_EXC_ERROR;
6193: END IF;
6194: ELSE

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

6270: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6271: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6272: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
6273: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');
6274: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
6275: END IF;
6276: x_return_status := G_RET_STS_ERROR;
6277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6278: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

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

6279: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6280: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6281: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
6282: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');
6283: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
6284: END IF;
6285: x_return_status := G_RET_STS_UNEXP_ERROR ;
6286: WHEN OTHERS THEN
6287: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

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

6386: OPEN l_qa_csr (l_contract_id);
6387: FETCH l_qa_csr INTO l_qa_rec;
6388: IF l_qa_csr%NOTFOUND OR l_qa_rec.qcl_id IS NULL THEN
6389: CLOSE l_qa_csr;
6390: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVALID_QA_CHECKLIST');
6391: IF l_qa_rec.contract_number_modifier IS NOT NULL THEN
6392: FND_MESSAGE.SET_TOKEN('CONTRACT_NUM',l_qa_rec.contract_number ||' - ' ||
6393: l_qa_rec.contract_number_modifier);
6394: ELSE

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

6388: IF l_qa_csr%NOTFOUND OR l_qa_rec.qcl_id IS NULL THEN
6389: CLOSE l_qa_csr;
6390: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVALID_QA_CHECKLIST');
6391: IF l_qa_rec.contract_number_modifier IS NOT NULL THEN
6392: FND_MESSAGE.SET_TOKEN('CONTRACT_NUM',l_qa_rec.contract_number ||' - ' ||
6393: l_qa_rec.contract_number_modifier);
6394: ELSE
6395: FND_MESSAGE.SET_TOKEN('CONTRACT_NUM',l_qa_rec.contract_number);
6396: END IF;

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

6391: IF l_qa_rec.contract_number_modifier IS NOT NULL THEN
6392: FND_MESSAGE.SET_TOKEN('CONTRACT_NUM',l_qa_rec.contract_number ||' - ' ||
6393: l_qa_rec.contract_number_modifier);
6394: ELSE
6395: FND_MESSAGE.SET_TOKEN('CONTRACT_NUM',l_qa_rec.contract_number);
6396: END IF;
6397: FND_MSG_PUB.add;
6398: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6399: FND_LOG.STRING(FND_LOG.LEVEL_ERROR ,G_MODULE||l_api_name,'Invalid QA checklist ');

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

6498: (
6499: itemtype => itemtype,
6500: itemkey => itemkey,
6501: aname => 'MESSAGE' || l_msg_ctr,
6502: avalue => substr(get_fnd_message,1,1500)
6503: );
6504: l_msg_ctr := l_msg_ctr + 1;
6505: END IF;
6506:

Line 6637: l_msg_data := get_fnd_message;

6633: END IF; -- (funcmode = 'TIMEOUT')
6634: EXCEPTION
6635: WHEN FND_API.G_EXC_ERROR THEN
6636: resultout := 'COMPLETE:F';
6637: l_msg_data := get_fnd_message;
6638: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6639: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
6640: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'Error: Itemtype: '
6641: ||NVL(itemtype,'NULL')||' Itemkey: '||NVL(itemkey,'NULL'));

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

6658: l_notif_attr_rec.ITEM_KEY := itemkey;
6659: l_notif_attr_rec.PERFORMER := NULL;
6660: l_notif_attr_rec.NTF_TYPE := G_NTF_TYPE_QA_FAIL;
6661: l_notif_attr_rec.NTF_SUBJECT := NULL;
6662: l_notif_attr_rec.SUBJECT := substr(get_fnd_message,1,200);
6663: l_notif_attr_rec.ACCEPT_DECLINE_BY := NULL;
6664: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6665: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
6666: 'OKS_WF_K_PROCESS_PVT.set_notification_attributes('||

Line 6968: l_msg_data := get_fnd_message;

6964: END IF; -- (funcmode = 'TIMEOUT')
6965:
6966: EXCEPTION
6967: WHEN FND_API.G_EXC_ERROR THEN
6968: l_msg_data := get_fnd_message;
6969: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6970: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
6971: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'Error: Itemtype: '
6972: ||NVL(itemtype,'NULL')||' Itemkey: '||NVL(itemkey,'NULL'));

Line 7092: l_msg_data := get_fnd_message;

7088: END IF; -- (funcmode = 'TIMEOUT')
7089:
7090: EXCEPTION
7091: WHEN FND_API.G_EXC_ERROR THEN
7092: l_msg_data := get_fnd_message;
7093: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7094: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
7095: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'Error: Itemtype: '
7096: ||NVL(itemtype,'NULL')||' Itemkey: '||NVL(itemkey,'NULL'));

Line 7249: l_msg_data := get_fnd_message;

7245: END IF; -- (funcmode = 'TIMEOUT')
7246:
7247: EXCEPTION
7248: WHEN NegStatusUpdateException THEN
7249: l_msg_data := get_fnd_message;
7250: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7251: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
7252: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.NegStatusUpdateException'
7253: ||' Itemtype: '||NVL(itemtype,'NULL')||' Itemkey: '||NVL(itemkey,'NULL'));

Line 7265: l_msg_data := get_fnd_message;

7261: arg2 => itemkey,
7262: arg3 => l_msg_data
7263: );
7264: WHEN FND_API.G_EXC_ERROR THEN
7265: l_msg_data := get_fnd_message;
7266: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7267: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
7268: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'Error: Itemtype: '
7269: ||NVL(itemtype,'NULL')||' Itemkey: '||NVL(itemkey,'NULL'));

Line 7684: l_msg_data := get_fnd_message;

7680: END IF; -- (funcmode = 'TIMEOUT')
7681: EXCEPTION
7682: WHEN FND_API.G_EXC_ERROR THEN
7683: resultout := 'COMPLETE:ERROR';
7684: l_msg_data := get_fnd_message;
7685: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7686: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
7687: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'Error: Itemtype: '
7688: ||NVL(itemtype,'NULL')||' Itemkey: '||NVL(itemkey,'NULL'));

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

7790: -- Initialize API return status to success
7791: x_return_status := G_RET_STS_SUCCESS;
7792:
7793: IF p_contract_id IS NULL THEN
7794: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
7795: FND_MESSAGE.SET_TOKEN('HDR_ID','NULL');
7796: FND_MSG_PUB.add;
7797: RAISE FND_API.G_EXC_ERROR;
7798: END IF;

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

7791: x_return_status := G_RET_STS_SUCCESS;
7792:
7793: IF p_contract_id IS NULL THEN
7794: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
7795: FND_MESSAGE.SET_TOKEN('HDR_ID','NULL');
7796: FND_MSG_PUB.add;
7797: RAISE FND_API.G_EXC_ERROR;
7798: END IF;
7799:

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

7799:
7800: IF p_item_key IS NULL THEN
7801: l_item_key := get_wf_item_key(p_contract_id => p_contract_id);
7802: IF l_item_key IS NULL THEN
7803: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
7804: FND_MSG_PUB.add;
7805: RAISE FND_API.G_EXC_ERROR;
7806: END IF;
7807: ELSE

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

7859: p_item_type => G_ITEM_TYPE
7860: ,p_item_key => l_item_key
7861: );
7862: IF l_activity_name NOT IN (G_SALESREP_ACTION, G_CUST_ACTION) THEN
7863: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INV_SALESREP_ACPT_ACTION');
7864: FND_MSG_PUB.add;
7865: RAISE FND_API.G_EXC_ERROR;
7866: END IF;
7867:

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

7908: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
7909: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7910: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
7911: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');
7912: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
7913: END IF;
7914: x_return_status := G_RET_STS_ERROR;
7915: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7916: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

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

7917: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
7918: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7919: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
7920: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');
7921: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
7922: END IF;
7923: x_return_status := G_RET_STS_UNEXP_ERROR ;
7924: WHEN OTHERS THEN
7925: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

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

8023: -- Initialize API return status to success
8024: x_return_status := FND_API.G_RET_STS_SUCCESS;
8025:
8026: IF p_contract_id IS NULL THEN
8027: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
8028: FND_MESSAGE.SET_TOKEN('HDR_ID','NULL');
8029: FND_MSG_PUB.add;
8030: RAISE FND_API.G_EXC_ERROR;
8031: END IF;

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

8024: x_return_status := FND_API.G_RET_STS_SUCCESS;
8025:
8026: IF p_contract_id IS NULL THEN
8027: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
8028: FND_MESSAGE.SET_TOKEN('HDR_ID','NULL');
8029: FND_MSG_PUB.add;
8030: RAISE FND_API.G_EXC_ERROR;
8031: END IF;
8032:

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

8032:
8033: IF p_item_key IS NULL THEN
8034: l_item_key := get_wf_item_key(p_contract_id => p_contract_id);
8035: IF l_item_key IS NULL THEN
8036: FND_MESSAGE.set_name(G_APP_NAME,'OKS_INVALID_WF_ITEM_KEY');
8037: FND_MSG_PUB.add;
8038: RAISE FND_API.G_EXC_ERROR;
8039: END IF;
8040: ELSE

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

8253: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
8254: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8255: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
8256: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');
8257: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
8258: END IF;
8259: x_return_status := G_RET_STS_ERROR;
8260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8261: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

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

8261: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
8262: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8263: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
8264: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');
8265: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
8266: END IF;
8267: x_return_status := G_RET_STS_UNEXP_ERROR ;
8268: WHEN OTHERS THEN
8269: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

Line 8494: l_msg_data := get_fnd_message;

8490: END IF; -- (funcmode = 'TIMEOUT')
8491: EXCEPTION
8492: WHEN FND_API.G_EXC_ERROR THEN
8493: resultout := 'COMPLETE:F';
8494: l_msg_data := get_fnd_message;
8495: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8496: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
8497: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'Error: Itemtype: '
8498: ||NVL(itemtype,'NULL')||' Itemkey: '||NVL(itemkey,'NULL'));

Line 8511: l_msg_data := get_fnd_message;

8507: arg3 => l_msg_data
8508: );
8509: WHEN others THEN
8510: resultout := 'COMPLETE:F';
8511: l_msg_data := get_fnd_message;
8512: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8513: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
8514: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
8515: ||SQLCODE||', sqlerrm = '||SQLERRM);