158: END IF;
159:
160: EXCEPTION
161: WHEN OTHERS THEN
162: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');
163: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
164: FND_MSG_PUB.ADD;
165:
166: IF okl_key_csr%ISOPEN THEN
159:
160: EXCEPTION
161: WHEN OTHERS THEN
162: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');
163: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
164: FND_MSG_PUB.ADD;
165:
166: IF okl_key_csr%ISOPEN THEN
167: CLOSE okl_key_csr;
314:
315:
316: EXCEPTION
317: WHEN OTHERS THEN
318: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');
319: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
320: FND_MSG_PUB.ADD;
321:
322: IF okl_key_csr%ISOPEN THEN
315:
316: EXCEPTION
317: WHEN OTHERS THEN
318: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');
319: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
320: FND_MSG_PUB.ADD;
321:
322: IF okl_key_csr%ISOPEN THEN
323: CLOSE okl_key_csr;
1947:
1948:
1949: l_delivery_mode := 'EMAIL';--fnd_profile.value('OKL_DELIVERY_MODE'); -- ansethur changed the delivery mode
1950:
1951: fnd_message.set_name ('OKL','OKL_XML_WF_SUB');
1952: l_message_sub:=fnd_message.get;
1953: fnd_message.set_name ('OKL','OKL_XML_WF_BODY');
1954: l_message_body:=fnd_message.get;
1955:
1948:
1949: l_delivery_mode := 'EMAIL';--fnd_profile.value('OKL_DELIVERY_MODE'); -- ansethur changed the delivery mode
1950:
1951: fnd_message.set_name ('OKL','OKL_XML_WF_SUB');
1952: l_message_sub:=fnd_message.get;
1953: fnd_message.set_name ('OKL','OKL_XML_WF_BODY');
1954: l_message_body:=fnd_message.get;
1955:
1956: okl_am_wf.get_notification_agent(
1949: l_delivery_mode := 'EMAIL';--fnd_profile.value('OKL_DELIVERY_MODE'); -- ansethur changed the delivery mode
1950:
1951: fnd_message.set_name ('OKL','OKL_XML_WF_SUB');
1952: l_message_sub:=fnd_message.get;
1953: fnd_message.set_name ('OKL','OKL_XML_WF_BODY');
1954: l_message_body:=fnd_message.get;
1955:
1956: okl_am_wf.get_notification_agent(
1957: itemtype => itemtype
1950:
1951: fnd_message.set_name ('OKL','OKL_XML_WF_SUB');
1952: l_message_sub:=fnd_message.get;
1953: fnd_message.set_name ('OKL','OKL_XML_WF_BODY');
1954: l_message_body:=fnd_message.get;
1955:
1956: okl_am_wf.get_notification_agent(
1957: itemtype => itemtype
1958: , itemkey => itemkey