APPS.IBY_FD_EXTRACT_GEN_PVT dependencies on FND_MESSAGE

Line 1805: --specific xle message under creation fnd message used as workaround

1801: x_legal_information_rec.country,
1802: x_legal_information_rec.state;
1803:
1804: IF case1_legal_information_cur%NOTFOUND THEN
1805: --specific xle message under creation fnd message used as workaround
1806: FND_MESSAGE.SET_NAME('FND','FND_GRANTS_RECORD_NOT_FOUND');
1807: FND_MSG_PUB.Add;
1808: x_return_status := FND_API.G_RET_STS_ERROR;
1809: END IF;

Line 1806: FND_MESSAGE.SET_NAME('FND','FND_GRANTS_RECORD_NOT_FOUND');

1802: x_legal_information_rec.state;
1803:
1804: IF case1_legal_information_cur%NOTFOUND THEN
1805: --specific xle message under creation fnd message used as workaround
1806: FND_MESSAGE.SET_NAME('FND','FND_GRANTS_RECORD_NOT_FOUND');
1807: FND_MSG_PUB.Add;
1808: x_return_status := FND_API.G_RET_STS_ERROR;
1809: END IF;
1810:

Line 1835: --specific xle message under creation fnd message used as workaround

1831: x_legal_information_rec.country,
1832: x_legal_information_rec.state;
1833:
1834: IF case2_legal_information_cur%NOTFOUND THEN
1835: --specific xle message under creation fnd message used as workaround
1836: FND_MESSAGE.SET_NAME('FND','FND_GRANTS_RECORD_NOT_FOUND');
1837: FND_MSG_PUB.Add;
1838: x_return_status := FND_API.G_RET_STS_ERROR;
1839: END IF;

Line 1836: FND_MESSAGE.SET_NAME('FND','FND_GRANTS_RECORD_NOT_FOUND');

1832: x_legal_information_rec.state;
1833:
1834: IF case2_legal_information_cur%NOTFOUND THEN
1835: --specific xle message under creation fnd message used as workaround
1836: FND_MESSAGE.SET_NAME('FND','FND_GRANTS_RECORD_NOT_FOUND');
1837: FND_MSG_PUB.Add;
1838: x_return_status := FND_API.G_RET_STS_ERROR;
1839: END IF;
1840:

Line 4348: fnd_message.set_name('IBY', 'IBY_FD_SRA_EMAIL_SUBJ_2');

4344: FETCH l_payment_details_csr INTO l_pmt_ref, l_chk_num;
4345: CLOSE l_payment_details_csr;
4346:
4347: IF ( l_chk_num > 0 ) THEN
4348: fnd_message.set_name('IBY', 'IBY_FD_SRA_EMAIL_SUBJ_2');
4349: fnd_message.set_Token('PAPER_DOC_NUM',l_chk_num);
4350: l_email_sub := FND_MESSAGE.GET;
4351: ELSE
4352: fnd_message.set_name('IBY', 'IBY_FD_SRA_EMAIL_SUBJ');

Line 4349: fnd_message.set_Token('PAPER_DOC_NUM',l_chk_num);

4345: CLOSE l_payment_details_csr;
4346:
4347: IF ( l_chk_num > 0 ) THEN
4348: fnd_message.set_name('IBY', 'IBY_FD_SRA_EMAIL_SUBJ_2');
4349: fnd_message.set_Token('PAPER_DOC_NUM',l_chk_num);
4350: l_email_sub := FND_MESSAGE.GET;
4351: ELSE
4352: fnd_message.set_name('IBY', 'IBY_FD_SRA_EMAIL_SUBJ');
4353: fnd_message.set_Token('PMT_REF_NUM',l_pmt_ref);

Line 4350: l_email_sub := FND_MESSAGE.GET;

4346:
4347: IF ( l_chk_num > 0 ) THEN
4348: fnd_message.set_name('IBY', 'IBY_FD_SRA_EMAIL_SUBJ_2');
4349: fnd_message.set_Token('PAPER_DOC_NUM',l_chk_num);
4350: l_email_sub := FND_MESSAGE.GET;
4351: ELSE
4352: fnd_message.set_name('IBY', 'IBY_FD_SRA_EMAIL_SUBJ');
4353: fnd_message.set_Token('PMT_REF_NUM',l_pmt_ref);
4354: l_email_sub := FND_MESSAGE.GET;

Line 4352: fnd_message.set_name('IBY', 'IBY_FD_SRA_EMAIL_SUBJ');

4348: fnd_message.set_name('IBY', 'IBY_FD_SRA_EMAIL_SUBJ_2');
4349: fnd_message.set_Token('PAPER_DOC_NUM',l_chk_num);
4350: l_email_sub := FND_MESSAGE.GET;
4351: ELSE
4352: fnd_message.set_name('IBY', 'IBY_FD_SRA_EMAIL_SUBJ');
4353: fnd_message.set_Token('PMT_REF_NUM',l_pmt_ref);
4354: l_email_sub := FND_MESSAGE.GET;
4355: END IF;
4356:

Line 4353: fnd_message.set_Token('PMT_REF_NUM',l_pmt_ref);

4349: fnd_message.set_Token('PAPER_DOC_NUM',l_chk_num);
4350: l_email_sub := FND_MESSAGE.GET;
4351: ELSE
4352: fnd_message.set_name('IBY', 'IBY_FD_SRA_EMAIL_SUBJ');
4353: fnd_message.set_Token('PMT_REF_NUM',l_pmt_ref);
4354: l_email_sub := FND_MESSAGE.GET;
4355: END IF;
4356:
4357: RETURN l_email_sub;

Line 4354: l_email_sub := FND_MESSAGE.GET;

4350: l_email_sub := FND_MESSAGE.GET;
4351: ELSE
4352: fnd_message.set_name('IBY', 'IBY_FD_SRA_EMAIL_SUBJ');
4353: fnd_message.set_Token('PMT_REF_NUM',l_pmt_ref);
4354: l_email_sub := FND_MESSAGE.GET;
4355: END IF;
4356:
4357: RETURN l_email_sub;
4358: