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.LNS_APPROVAL_ACTION_PUB dependencies on FND_MESSAGE

Line 100: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_DUPLICATE_COLUMN');

96: INTO l_dummy
97: FROM LNS_APPROVAL_ACTIONS
98: WHERE action_id = l_action_id;
99:
100: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_DUPLICATE_COLUMN');
101: FND_MESSAGE.SET_TOKEN('COLUMN', 'action_id');
102: FND_MSG_PUB.ADD;
103: RAISE FND_API.G_EXC_ERROR;
104:

Line 101: FND_MESSAGE.SET_TOKEN('COLUMN', 'action_id');

97: FROM LNS_APPROVAL_ACTIONS
98: WHERE action_id = l_action_id;
99:
100: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_DUPLICATE_COLUMN');
101: FND_MESSAGE.SET_TOKEN('COLUMN', 'action_id');
102: FND_MSG_PUB.ADD;
103: RAISE FND_API.G_EXC_ERROR;
104:
105: EXCEPTION

Line 208: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_RECORD_CHANGED');

204: p_object_version_number = l_object_version_number
205: )
206: )
207: THEN
208: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_RECORD_CHANGED');
209: FND_MESSAGE.SET_TOKEN('TABLE', 'lns_approval_actions');
210: FND_MSG_PUB.ADD;
211: RAISE FND_API.G_EXC_ERROR;
212: END IF;

Line 209: FND_MESSAGE.SET_TOKEN('TABLE', 'lns_approval_actions');

205: )
206: )
207: THEN
208: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_RECORD_CHANGED');
209: FND_MESSAGE.SET_TOKEN('TABLE', 'lns_approval_actions');
210: FND_MSG_PUB.ADD;
211: RAISE FND_API.G_EXC_ERROR;
212: END IF;
213:

Line 217: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');

213:
214: p_object_version_number := nvl(l_object_version_number, 1) + 1;
215:
216: EXCEPTION WHEN NO_DATA_FOUND THEN
217: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
218: FND_MESSAGE.SET_TOKEN('RECORD', 'approval action_rec');
219: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_approval_action_rec.action_id), 'null'));
220: FND_MSG_PUB.ADD;
221: RAISE FND_API.G_EXC_ERROR;

Line 218: FND_MESSAGE.SET_TOKEN('RECORD', 'approval action_rec');

214: p_object_version_number := nvl(l_object_version_number, 1) + 1;
215:
216: EXCEPTION WHEN NO_DATA_FOUND THEN
217: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
218: FND_MESSAGE.SET_TOKEN('RECORD', 'approval action_rec');
219: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_approval_action_rec.action_id), 'null'));
220: FND_MSG_PUB.ADD;
221: RAISE FND_API.G_EXC_ERROR;
222: END;

Line 219: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_approval_action_rec.action_id), 'null'));

215:
216: EXCEPTION WHEN NO_DATA_FOUND THEN
217: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
218: FND_MESSAGE.SET_TOKEN('RECORD', 'approval action_rec');
219: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_approval_action_rec.action_id), 'null'));
220: FND_MSG_PUB.ADD;
221: RAISE FND_API.G_EXC_ERROR;
222: END;
223:

Line 320: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');

316: WHERE ACTION_ID = p_action_id;
317:
318: EXCEPTION
319: WHEN NO_DATA_FOUND THEN
320: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
321: FND_MESSAGE.SET_TOKEN('RECORD', 'approval action_rec');
322: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_action_id), 'null'));
323: FND_MSG_PUB.ADD;
324: RAISE FND_API.G_EXC_ERROR;

Line 321: FND_MESSAGE.SET_TOKEN('RECORD', 'approval action_rec');

317:
318: EXCEPTION
319: WHEN NO_DATA_FOUND THEN
320: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
321: FND_MESSAGE.SET_TOKEN('RECORD', 'approval action_rec');
322: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_action_id), 'null'));
323: FND_MSG_PUB.ADD;
324: RAISE FND_API.G_EXC_ERROR;
325: END;

Line 322: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_action_id), 'null'));

318: EXCEPTION
319: WHEN NO_DATA_FOUND THEN
320: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
321: FND_MESSAGE.SET_TOKEN('RECORD', 'approval action_rec');
322: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_action_id), 'null'));
323: FND_MSG_PUB.ADD;
324: RAISE FND_API.G_EXC_ERROR;
325: END;
326: END IF;

Line 357: FND_MESSAGE.SET_NAME('LNS', 'LNS_NEGATIVE_NUMBER_ERROR');

353: OPEN C_Check_Fee_Violation (p_approval_action_rec.loan_id, l_install_number);
354: FETCH C_Check_Fee_Violation INTO l_dummy;
355: IF C_Check_Fee_Violation%FOUND THEN
356: x_return_status := FND_API.G_RET_STS_ERROR;
357: FND_MESSAGE.SET_NAME('LNS', 'LNS_NEGATIVE_NUMBER_ERROR');
358: FND_MSG_PUB.ADD;
359: CLOSE C_Check_Fee_Violation;
360: RAISE FND_API.G_EXC_ERROR;
361:

Line 576: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');

572: ,l_loan_needs_approval
573: ,l_secondary_status
574: ,l_customized;
575: IF C_Get_Loan_Info%NOTFOUND THEN
576: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
577: FND_MESSAGE.SET_TOKEN('RECORD', 'loan header');
578: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(l_loan_header_rec.loan_id), 'null'));
579: FND_MSG_PUB.ADD;
580: CLOSE C_Get_Loan_Info;

Line 577: FND_MESSAGE.SET_TOKEN('RECORD', 'loan header');

573: ,l_secondary_status
574: ,l_customized;
575: IF C_Get_Loan_Info%NOTFOUND THEN
576: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
577: FND_MESSAGE.SET_TOKEN('RECORD', 'loan header');
578: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(l_loan_header_rec.loan_id), 'null'));
579: FND_MSG_PUB.ADD;
580: CLOSE C_Get_Loan_Info;
581: l_last_api_called := 'C_Get_Loan_Info';

Line 578: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(l_loan_header_rec.loan_id), 'null'));

574: ,l_customized;
575: IF C_Get_Loan_Info%NOTFOUND THEN
576: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
577: FND_MESSAGE.SET_TOKEN('RECORD', 'loan header');
578: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(l_loan_header_rec.loan_id), 'null'));
579: FND_MSG_PUB.ADD;
580: CLOSE C_Get_Loan_Info;
581: l_last_api_called := 'C_Get_Loan_Info';
582: RAISE FND_API.G_EXC_ERROR;

Line 598: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_INVALID_STATUS');

594: IF l_status = 'INCOMPLETE' THEN
595: l_loan_header_rec.loan_status := 'PENDING';
596: l_loan_header_rec.secondary_status := FND_API.G_MISS_CHAR;
597: ELSE
598: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_INVALID_STATUS');
599: FND_MESSAGE.SET_TOKEN('VALUE', l_status);
600: FND_MSG_PUB.ADD;
601: RAISE FND_API.G_EXC_ERROR;
602: END IF;

Line 599: FND_MESSAGE.SET_TOKEN('VALUE', l_status);

595: l_loan_header_rec.loan_status := 'PENDING';
596: l_loan_header_rec.secondary_status := FND_API.G_MISS_CHAR;
597: ELSE
598: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_INVALID_STATUS');
599: FND_MESSAGE.SET_TOKEN('VALUE', l_status);
600: FND_MSG_PUB.ADD;
601: RAISE FND_API.G_EXC_ERROR;
602: END IF;
603:

Line 608: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_INVALID_STATUS');

604: ELSIF (l_approval_action_rec.action_type = 'SUBMIT_FOR_CONV') THEN
605: IF (l_status = 'ACTIVE' AND l_current_phase = 'OPEN' AND l_multiple_funding_flag = 'Y' AND l_open_to_term_flag = 'Y') THEN
606: l_loan_header_rec.secondary_status := 'PENDING_CONVERSION';
607: ELSE
608: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_INVALID_STATUS');
609: FND_MESSAGE.SET_TOKEN('VALUE', l_status);
610: FND_MSG_PUB.ADD;
611: RAISE FND_API.G_EXC_ERROR;
612: END IF;

Line 609: FND_MESSAGE.SET_TOKEN('VALUE', l_status);

605: IF (l_status = 'ACTIVE' AND l_current_phase = 'OPEN' AND l_multiple_funding_flag = 'Y' AND l_open_to_term_flag = 'Y') THEN
606: l_loan_header_rec.secondary_status := 'PENDING_CONVERSION';
607: ELSE
608: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_INVALID_STATUS');
609: FND_MESSAGE.SET_TOKEN('VALUE', l_status);
610: FND_MSG_PUB.ADD;
611: RAISE FND_API.G_EXC_ERROR;
612: END IF;
613:

Line 635: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_INVALID_STATUS');

631: l_last_api_called := 'LNS_FUNDING_PUB.CANCEL_DISB_SCHEDULE';
632: RAISE FND_API.G_EXC_ERROR;
633: END IF;
634: ELSE
635: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_INVALID_STATUS');
636: FND_MESSAGE.SET_TOKEN('VALUE', l_status);
637: FND_MSG_PUB.ADD;
638: RAISE FND_API.G_EXC_ERROR;
639: END IF;

Line 636: FND_MESSAGE.SET_TOKEN('VALUE', l_status);

632: RAISE FND_API.G_EXC_ERROR;
633: END IF;
634: ELSE
635: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_INVALID_STATUS');
636: FND_MESSAGE.SET_TOKEN('VALUE', l_status);
637: FND_MSG_PUB.ADD;
638: RAISE FND_API.G_EXC_ERROR;
639: END IF;
640:

Line 748: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_TERM_FAIL');

744:
745: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
746: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Successfully update LNS_TERMS');
747: ELSE
748: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_TERM_FAIL');
749: FND_MSG_PUB.Add;
750: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - LNS_TERMS_PUB.update_term failed with message: ' || FND_MSG_PUB.Get(p_encoded => 'F'));
751: l_last_api_called := 'LNS_TERMS_PUB.update_term';
752: RAISE FND_API.G_EXC_ERROR;

Line 793: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_INVALID_STATUS');

789: END IF;
790: /**********************End Permanent Conversion to Term Phase*************/
791:
792: ELSE
793: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_INVALID_STATUS');
794: FND_MESSAGE.SET_TOKEN('VALUE', l_status);
795: FND_MSG_PUB.ADD;
796: RAISE FND_API.G_EXC_ERROR;
797: END IF;

Line 794: FND_MESSAGE.SET_TOKEN('VALUE', l_status);

790: /**********************End Permanent Conversion to Term Phase*************/
791:
792: ELSE
793: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_INVALID_STATUS');
794: FND_MESSAGE.SET_TOKEN('VALUE', l_status);
795: FND_MSG_PUB.ADD;
796: RAISE FND_API.G_EXC_ERROR;
797: END IF;
798:

Line 829: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_INVALID_STATUS');

825: fetch prev_sec_status_cur into l_prev_sec_status;
826: close prev_sec_status_cur;
827: l_loan_header_rec.secondary_status := nvl(l_prev_sec_status,FND_API.G_MISS_CHAR);
828: ELSE
829: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_INVALID_STATUS');
830: FND_MESSAGE.SET_TOKEN('VALUE', l_status);
831: FND_MSG_PUB.ADD;
832: RAISE FND_API.G_EXC_ERROR;
833: END IF;

Line 830: FND_MESSAGE.SET_TOKEN('VALUE', l_status);

826: close prev_sec_status_cur;
827: l_loan_header_rec.secondary_status := nvl(l_prev_sec_status,FND_API.G_MISS_CHAR);
828: ELSE
829: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_INVALID_STATUS');
830: FND_MESSAGE.SET_TOKEN('VALUE', l_status);
831: FND_MSG_PUB.ADD;
832: RAISE FND_API.G_EXC_ERROR;
833: END IF;
834:

Line 867: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_INVALID_STATUS');

863: if l_current_phase = 'OPEN' AND l_multiple_funding_flag = 'Y' AND l_open_to_term_flag = 'Y' THEN
864: l_loan_header_rec.secondary_status := 'MORE_INFO_REQUESTED';
865: end if;
866: ELSE
867: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_INVALID_STATUS');
868: FND_MESSAGE.SET_TOKEN('VALUE', l_status);
869: FND_MSG_PUB.ADD;
870: RAISE FND_API.G_EXC_ERROR;
871: END IF;

Line 868: FND_MESSAGE.SET_TOKEN('VALUE', l_status);

864: l_loan_header_rec.secondary_status := 'MORE_INFO_REQUESTED';
865: end if;
866: ELSE
867: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_INVALID_STATUS');
868: FND_MESSAGE.SET_TOKEN('VALUE', l_status);
869: FND_MSG_PUB.ADD;
870: RAISE FND_API.G_EXC_ERROR;
871: END IF;
872: END IF;

Line 1064: FND_MESSAGE.SET_NAME('LNS', 'LNS_AGREEMENT_REQUEST_FAILED');

1060: ,l_loan_header_rec.loan_id);
1061:
1062: if l_request_id = 0 then
1063: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1064: FND_MESSAGE.SET_NAME('LNS', 'LNS_AGREEMENT_REQUEST_FAILED');
1065: FND_MSG_PUB.Add;
1066: l_last_api_called := 'FND_REQUEST.SUBMIT_REQUEST for Loan Agreement Report Generation';
1067: RAISE FND_API.G_EXC_ERROR;
1068: else

Line 1085: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');

1081: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'before rollback');
1082: ROLLBACK TO create_approval_action;
1083: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'after rollback');
1084: x_return_status := FND_API.G_RET_STS_ERROR;
1085: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1086: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
1087: FND_MSG_PUB.ADD;
1088: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1089: p_count => x_msg_count,

Line 1086: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);

1082: ROLLBACK TO create_approval_action;
1083: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'after rollback');
1084: x_return_status := FND_API.G_RET_STS_ERROR;
1085: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1086: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
1087: FND_MSG_PUB.ADD;
1088: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1089: p_count => x_msg_count,
1090: p_data => x_msg_data);

Line 1095: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');

1091:
1092: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1093: ROLLBACK TO create_approval_action;
1094: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1095: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1096: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
1097: FND_MSG_PUB.ADD;
1098: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1099: p_count => x_msg_count,

Line 1096: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);

1092: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1093: ROLLBACK TO create_approval_action;
1094: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1095: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1096: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
1097: FND_MSG_PUB.ADD;
1098: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1099: p_count => x_msg_count,
1100: p_data => x_msg_data);

Line 1105: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');

1101:
1102: WHEN OTHERS THEN
1103: ROLLBACK TO create_approval_action;
1104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1105: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1106: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1107: FND_MSG_PUB.ADD;
1108: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1109: p_count => x_msg_count,

Line 1106: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

1102: WHEN OTHERS THEN
1103: ROLLBACK TO create_approval_action;
1104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1105: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1106: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1107: FND_MSG_PUB.ADD;
1108: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1109: p_count => x_msg_count,
1110: p_data => x_msg_data);

Line 1212: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');

1208:
1209: WHEN OTHERS THEN
1210: ROLLBACK TO update_approval_action;
1211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1212: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1213: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1214: FND_MSG_PUB.ADD;
1215: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1216: p_count => x_msg_count,

Line 1213: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

1209: WHEN OTHERS THEN
1210: ROLLBACK TO update_approval_action;
1211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1212: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1213: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1214: FND_MSG_PUB.ADD;
1215: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1216: p_count => x_msg_count,
1217: p_data => x_msg_data);

Line 1304: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');

1300:
1301: WHEN OTHERS THEN
1302: ROLLBACK TO delete_approval_action;
1303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1304: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1305: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1306: FND_MSG_PUB.ADD;
1307: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1308: p_count => x_msg_count,

Line 1305: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

1301: WHEN OTHERS THEN
1302: ROLLBACK TO delete_approval_action;
1303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1304: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1305: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1306: FND_MSG_PUB.ADD;
1307: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1308: p_count => x_msg_count,
1309: p_data => x_msg_data);