796: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
797: G_MODULE||l_api_name,
798: '110: Invalid Template Id: '||p_template_id);
799: END IF;
800: FND_MESSAGE.set_name('OKC','OKC_XPRT_INVALID_TEMPLATE');
801: RAISE FND_API.G_EXC_ERROR;
802: END IF;
803:
804: CLOSE csr_template_dtls;
823: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
824: G_MODULE||l_api_name,
825: '110: Template Model Does Not Exists : '||l_template_name);
826: END IF;
827: FND_MESSAGE.set_name('OKC','OKC_XPRT_INVALID_TMPL_MODEL');
828: FND_MESSAGE.set_token('TEMPLATE_NAME',l_template_name);
829: RAISE FND_API.G_EXC_ERROR;
830: END IF;
831:
824: G_MODULE||l_api_name,
825: '110: Template Model Does Not Exists : '||l_template_name);
826: END IF;
827: FND_MESSAGE.set_name('OKC','OKC_XPRT_INVALID_TMPL_MODEL');
828: FND_MESSAGE.set_token('TEMPLATE_NAME',l_template_name);
829: RAISE FND_API.G_EXC_ERROR;
830: END IF;
831:
832: CLOSE csr_template_model_id;
1716: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1717: G_MODULE||l_api_name,
1718: '110: Invalid Template Id: '||p_template_id);
1719: END IF;
1720: FND_MESSAGE.set_name('OKC','OKC_XPRT_INVALID_TEMPLATE');
1721: RAISE FND_API.G_EXC_ERROR;
1722: END IF;
1723:
1724: CLOSE csr_template_dtls;
1976:
1977: x_return_status := G_RET_STS_SUCCESS;
1978:
1979: -- Set Extension rule name
1980: FND_MESSAGE.set_name('OKC','OKC_XPRT_XTN_RULE_NAME');
1981: l_rule_name := FND_MESSAGE.get; -- Get Extension rule name from OKC_XPRT_XTN_RULE_NAME message
1982:
1983: -- Set Extension rule description
1984: FND_MESSAGE.set_name('OKC','OKC_XPRT_XTN_RULE_DESC');
1977: x_return_status := G_RET_STS_SUCCESS;
1978:
1979: -- Set Extension rule name
1980: FND_MESSAGE.set_name('OKC','OKC_XPRT_XTN_RULE_NAME');
1981: l_rule_name := FND_MESSAGE.get; -- Get Extension rule name from OKC_XPRT_XTN_RULE_NAME message
1982:
1983: -- Set Extension rule description
1984: FND_MESSAGE.set_name('OKC','OKC_XPRT_XTN_RULE_DESC');
1985: l_rule_description := FND_MESSAGE.get; -- Get Extension rule description from OKC_XPRT_XTN_RULE_DESC message
1980: FND_MESSAGE.set_name('OKC','OKC_XPRT_XTN_RULE_NAME');
1981: l_rule_name := FND_MESSAGE.get; -- Get Extension rule name from OKC_XPRT_XTN_RULE_NAME message
1982:
1983: -- Set Extension rule description
1984: FND_MESSAGE.set_name('OKC','OKC_XPRT_XTN_RULE_DESC');
1985: l_rule_description := FND_MESSAGE.get; -- Get Extension rule description from OKC_XPRT_XTN_RULE_DESC message
1986:
1987:
1988: OPEN csr_intents;
1981: l_rule_name := FND_MESSAGE.get; -- Get Extension rule name from OKC_XPRT_XTN_RULE_NAME message
1982:
1983: -- Set Extension rule description
1984: FND_MESSAGE.set_name('OKC','OKC_XPRT_XTN_RULE_DESC');
1985: l_rule_description := FND_MESSAGE.get; -- Get Extension rule description from OKC_XPRT_XTN_RULE_DESC message
1986:
1987:
1988: OPEN csr_intents;
1989: LOOP
2415:
2416: x_return_status := G_RET_STS_SUCCESS;
2417:
2418: -- Set Extension rule name
2419: FND_MESSAGE.set_name('OKC','OKC_XPRT_XTN_RULE_NAME');
2420: l_rule_name := FND_MESSAGE.get; -- Get Extension rule name from OKC_XPRT_XTN_RULE_NAME message
2421:
2422: -- Set Extension rule description
2423: FND_MESSAGE.set_name('OKC','OKC_XPRT_XTN_RULE_DESC');
2416: x_return_status := G_RET_STS_SUCCESS;
2417:
2418: -- Set Extension rule name
2419: FND_MESSAGE.set_name('OKC','OKC_XPRT_XTN_RULE_NAME');
2420: l_rule_name := FND_MESSAGE.get; -- Get Extension rule name from OKC_XPRT_XTN_RULE_NAME message
2421:
2422: -- Set Extension rule description
2423: FND_MESSAGE.set_name('OKC','OKC_XPRT_XTN_RULE_DESC');
2424: l_rule_description := FND_MESSAGE.get; -- Get Extension rule description from OKC_XPRT_XTN_RULE_DESC message
2419: FND_MESSAGE.set_name('OKC','OKC_XPRT_XTN_RULE_NAME');
2420: l_rule_name := FND_MESSAGE.get; -- Get Extension rule name from OKC_XPRT_XTN_RULE_NAME message
2421:
2422: -- Set Extension rule description
2423: FND_MESSAGE.set_name('OKC','OKC_XPRT_XTN_RULE_DESC');
2424: l_rule_description := FND_MESSAGE.get; -- Get Extension rule description from OKC_XPRT_XTN_RULE_DESC message
2425:
2426:
2427: OPEN csr_intents;
2420: l_rule_name := FND_MESSAGE.get; -- Get Extension rule name from OKC_XPRT_XTN_RULE_NAME message
2421:
2422: -- Set Extension rule description
2423: FND_MESSAGE.set_name('OKC','OKC_XPRT_XTN_RULE_DESC');
2424: l_rule_description := FND_MESSAGE.get; -- Get Extension rule description from OKC_XPRT_XTN_RULE_DESC message
2425:
2426:
2427: OPEN csr_intents;
2428: LOOP