DBA Data[Home] [Help]

APPS.CSD_RO_BULLETINS_PVT dependencies on FND_MESSAGE

Line 253: FND_MESSAGE.Set_Name('CSD', 'CSD_RO_BTNS_NO_RECORD_FOUND'); -- no record is returned for the query

249: l_ref_ro_bulletin_rec.last_update_login;
250:
251: IF ( cur_get_ro_bulletin%NOTFOUND) THEN
252: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
253: FND_MESSAGE.Set_Name('CSD', 'CSD_RO_BTNS_NO_RECORD_FOUND'); -- no record is returned for the query
254: FND_MESSAGE.set_token( 'BULLETIN_ID', p_ro_bulletin_rec.RO_BULLETIN_ID);
255: FND_MSG_PUB.Add;
256: END IF;
257: CLOSE cur_get_ro_bulletin;

Line 254: FND_MESSAGE.set_token( 'BULLETIN_ID', p_ro_bulletin_rec.RO_BULLETIN_ID);

250:
251: IF ( cur_get_ro_bulletin%NOTFOUND) THEN
252: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
253: FND_MESSAGE.Set_Name('CSD', 'CSD_RO_BTNS_NO_RECORD_FOUND'); -- no record is returned for the query
254: FND_MESSAGE.set_token( 'BULLETIN_ID', p_ro_bulletin_rec.RO_BULLETIN_ID);
255: FND_MSG_PUB.Add;
256: END IF;
257: CLOSE cur_get_ro_bulletin;
258: RAISE FND_API.G_EXC_ERROR;

Line 658: FND_MESSAGE.Set_Name('CSD', 'CSD_UPDATE_REPAIR_FAILED');

654: x_msg_data => x_msg_data
655: );
656: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
657: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
658: FND_MESSAGE.Set_Name('CSD', 'CSD_UPDATE_REPAIR_FAILED');
659: FND_MSG_PUB.Add;
660: END IF;
661: RAISE FND_API.G_EXC_ERROR;
662: END IF; --* end IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) *--

Line 720: FND_MESSAGE.Set_Name('CSD', 'CSD_RULE_MATCH_FAILED');

716: );
717:
718: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
719: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
720: FND_MESSAGE.Set_Name('CSD', 'CSD_RULE_MATCH_FAILED');
721: FND_MSG_PUB.Add;
722: END IF;
723: RAISE FND_API.G_EXC_ERROR;
724: END IF;

Line 769: FND_MESSAGE.Set_Name('CSD', 'CSD_CREATE_RO_BLTN_LINK_FAILED');

765: -- dbms_output.put_line('in LINK_BULLETINS_TO_RO ONE_REPAIR - after create new link, x_return_status = ' || x_return_status);
766: --** debug ends!!
767: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
768: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
769: FND_MESSAGE.Set_Name('CSD', 'CSD_CREATE_RO_BLTN_LINK_FAILED');
770: FND_MSG_PUB.Add;
771: END IF;
772: RAISE FND_API.G_EXC_ERROR;
773: END IF; -- end IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN --

Line 1057: FND_MESSAGE.Set_Name('CSD', 'CSD_CREATE_RO_BLTN_FAILED');

1053: x_msg_data => x_msg_data
1054: );
1055: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1056: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1057: FND_MESSAGE.Set_Name('CSD', 'CSD_CREATE_RO_BLTN_FAILED');
1058: FND_MSG_PUB.Add;
1059: END IF;
1060: RAISE FND_API.G_EXC_ERROR;
1061: END IF; --* end IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) *--

Line 1128: FND_MESSAGE.Set_Name('CSD', 'CSD_UPDATE_REPAIR_FAILED');

1124: x_msg_data => x_msg_data
1125: );
1126: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1127: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1128: FND_MESSAGE.Set_Name('CSD', 'CSD_UPDATE_REPAIR_FAILED');
1129: FND_MSG_PUB.Add;
1130: END IF;
1131: RAISE FND_API.G_EXC_ERROR;
1132: END IF; --* end IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) *--

Line 1626: fnd_message.set_name('CSD','CSD_SQL_ERROR');

1622: p_data => x_msg_data );
1623: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1624: --dbms_output.put_line('In FND_API.G_EXC_UNEXPECTED_ERROR exception');
1625: IF ( l_error_level >= G_debug_level) THEN
1626: fnd_message.set_name('CSD','CSD_SQL_ERROR');
1627: fnd_message.set_token('SQLERRM',SQLERRM);
1628: fnd_message.set_token('SQLCODE',SQLCODE);
1629: fnd_log.message(l_error_level,l_mod_name,FALSE);
1630: END If;

Line 1627: fnd_message.set_token('SQLERRM',SQLERRM);

1623: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1624: --dbms_output.put_line('In FND_API.G_EXC_UNEXPECTED_ERROR exception');
1625: IF ( l_error_level >= G_debug_level) THEN
1626: fnd_message.set_name('CSD','CSD_SQL_ERROR');
1627: fnd_message.set_token('SQLERRM',SQLERRM);
1628: fnd_message.set_token('SQLCODE',SQLCODE);
1629: fnd_log.message(l_error_level,l_mod_name,FALSE);
1630: END If;
1631: -- As we are committing the processed records in the inner APIs

Line 1628: fnd_message.set_token('SQLCODE',SQLCODE);

1624: --dbms_output.put_line('In FND_API.G_EXC_UNEXPECTED_ERROR exception');
1625: IF ( l_error_level >= G_debug_level) THEN
1626: fnd_message.set_name('CSD','CSD_SQL_ERROR');
1627: fnd_message.set_token('SQLERRM',SQLERRM);
1628: fnd_message.set_token('SQLCODE',SQLCODE);
1629: fnd_log.message(l_error_level,l_mod_name,FALSE);
1630: END If;
1631: -- As we are committing the processed records in the inner APIs
1632: -- so we rollback only if the p_commit='F'

Line 1643: fnd_message.set_name('CSD','CSD_SQL_ERROR');

1639: p_data => x_msg_data );
1640: WHEN OTHERS THEN
1641: --dbms_output.put_line('In OTHERS exception');
1642: IF ( l_error_level >= G_debug_level) THEN
1643: fnd_message.set_name('CSD','CSD_SQL_ERROR');
1644: fnd_message.set_token('SQLERRM',SQLERRM);
1645: fnd_message.set_token('SQLCODE',SQLCODE);
1646: fnd_log.message(l_error_level,l_mod_name,FALSE);
1647: END If;

Line 1644: fnd_message.set_token('SQLERRM',SQLERRM);

1640: WHEN OTHERS THEN
1641: --dbms_output.put_line('In OTHERS exception');
1642: IF ( l_error_level >= G_debug_level) THEN
1643: fnd_message.set_name('CSD','CSD_SQL_ERROR');
1644: fnd_message.set_token('SQLERRM',SQLERRM);
1645: fnd_message.set_token('SQLCODE',SQLCODE);
1646: fnd_log.message(l_error_level,l_mod_name,FALSE);
1647: END If;
1648: -- As we are committing the processed records in the inner APIs

Line 1645: fnd_message.set_token('SQLCODE',SQLCODE);

1641: --dbms_output.put_line('In OTHERS exception');
1642: IF ( l_error_level >= G_debug_level) THEN
1643: fnd_message.set_name('CSD','CSD_SQL_ERROR');
1644: fnd_message.set_token('SQLERRM',SQLERRM);
1645: fnd_message.set_token('SQLCODE',SQLCODE);
1646: fnd_log.message(l_error_level,l_mod_name,FALSE);
1647: END If;
1648: -- As we are committing the processed records in the inner APIs
1649: -- so we rollback only if the p_commit='F'

Line 1893: fnd_message.set_name('CSD','CSD_SQL_ERROR');

1889: p_data => x_msg_data );
1890: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1891: --dbms_output.put_line('In FND_API.G_EXC_UNEXPECTED_ERROR exception');
1892: IF ( l_error_level >= G_debug_level) THEN
1893: fnd_message.set_name('CSD','CSD_SQL_ERROR');
1894: fnd_message.set_token('SQLERRM',SQLERRM);
1895: fnd_message.set_token('SQLCODE',SQLCODE);
1896: fnd_log.message(l_error_level,l_mod_name,FALSE);
1897: END If;

Line 1894: fnd_message.set_token('SQLERRM',SQLERRM);

1890: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1891: --dbms_output.put_line('In FND_API.G_EXC_UNEXPECTED_ERROR exception');
1892: IF ( l_error_level >= G_debug_level) THEN
1893: fnd_message.set_name('CSD','CSD_SQL_ERROR');
1894: fnd_message.set_token('SQLERRM',SQLERRM);
1895: fnd_message.set_token('SQLCODE',SQLCODE);
1896: fnd_log.message(l_error_level,l_mod_name,FALSE);
1897: END If;
1898: ROLLBACK TO APPLY_BULLETIN_SCS_TO_RO;

Line 1895: fnd_message.set_token('SQLCODE',SQLCODE);

1891: --dbms_output.put_line('In FND_API.G_EXC_UNEXPECTED_ERROR exception');
1892: IF ( l_error_level >= G_debug_level) THEN
1893: fnd_message.set_name('CSD','CSD_SQL_ERROR');
1894: fnd_message.set_token('SQLERRM',SQLERRM);
1895: fnd_message.set_token('SQLCODE',SQLCODE);
1896: fnd_log.message(l_error_level,l_mod_name,FALSE);
1897: END If;
1898: ROLLBACK TO APPLY_BULLETIN_SCS_TO_RO;
1899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1906: fnd_message.set_name('CSD','CSD_SQL_ERROR');

1902: p_data => x_msg_data );
1903: WHEN OTHERS THEN
1904: -- dbms_output.put_line('In OTHERS exception' );
1905: IF ( l_error_level >= G_debug_level) THEN
1906: fnd_message.set_name('CSD','CSD_SQL_ERROR');
1907: fnd_message.set_token('SQLERRM',SQLERRM);
1908: fnd_message.set_token('SQLCODE',SQLCODE);
1909: fnd_log.message(l_error_level,l_mod_name,FALSE);
1910: END If;

Line 1907: fnd_message.set_token('SQLERRM',SQLERRM);

1903: WHEN OTHERS THEN
1904: -- dbms_output.put_line('In OTHERS exception' );
1905: IF ( l_error_level >= G_debug_level) THEN
1906: fnd_message.set_name('CSD','CSD_SQL_ERROR');
1907: fnd_message.set_token('SQLERRM',SQLERRM);
1908: fnd_message.set_token('SQLCODE',SQLCODE);
1909: fnd_log.message(l_error_level,l_mod_name,FALSE);
1910: END If;
1911: ROLLBACK TO APPLY_BULLETIN_SCS_TO_RO;

Line 1908: fnd_message.set_token('SQLCODE',SQLCODE);

1904: -- dbms_output.put_line('In OTHERS exception' );
1905: IF ( l_error_level >= G_debug_level) THEN
1906: fnd_message.set_name('CSD','CSD_SQL_ERROR');
1907: fnd_message.set_token('SQLERRM',SQLERRM);
1908: fnd_message.set_token('SQLCODE',SQLCODE);
1909: fnd_log.message(l_error_level,l_mod_name,FALSE);
1910: END If;
1911: ROLLBACK TO APPLY_BULLETIN_SCS_TO_RO;
1912: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;