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_PARTICIPANTS_PUB dependencies on FND_MESSAGE

Line 140: FND_MESSAGE.SET_NAME('LNS', 'LNS_BORROWER_NO_BILL_TO');

136: CLOSE c_site_uses;
137:
138: --dbms_output.put_line('Site use number is ' || l_num_acct_site_uses);
139: if l_valid_acct_site_party <> 'Y' then
140: FND_MESSAGE.SET_NAME('LNS', 'LNS_BORROWER_NO_BILL_TO');
141: FND_MSG_PUB.ADD;
142: RAISE FND_API.G_EXC_ERROR;
143: end if;
144: exception

Line 146: FND_MESSAGE.SET_NAME('LNS', 'LNS_BORROWER_NO_BILL_TO');

142: RAISE FND_API.G_EXC_ERROR;
143: end if;
144: exception
145: when NO_DATA_FOUND then
146: FND_MESSAGE.SET_NAME('LNS', 'LNS_BORROWER_NO_BILL_TO');
147: FND_MSG_PUB.ADD;
148: RAISE FND_API.G_EXC_ERROR;
149: End;
150:

Line 164: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

160: P_TABLE_NAME => 'LNS_LOAN_HEADERS_ALL');
161: --dbms_output.put_line('output');
162:
163: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
164: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
165: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
166: FND_MESSAGE.SET_TOKEN('VALUE', l_loan_id);
167: FND_MSG_PUB.ADD;
168: RAISE FND_API.G_EXC_ERROR;

Line 165: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');

161: --dbms_output.put_line('output');
162:
163: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
164: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
165: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
166: FND_MESSAGE.SET_TOKEN('VALUE', l_loan_id);
167: FND_MSG_PUB.ADD;
168: RAISE FND_API.G_EXC_ERROR;
169: end if;

Line 166: FND_MESSAGE.SET_TOKEN('VALUE', l_loan_id);

162:
163: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
164: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
165: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
166: FND_MESSAGE.SET_TOKEN('VALUE', l_loan_id);
167: FND_MSG_PUB.ADD;
168: RAISE FND_API.G_EXC_ERROR;
169: end if;
170:

Line 189: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

185: P_TABLE_NAME => 'HZ_PARTIES');
186: --dbms_output.put_line('output2');
187:
188: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
189: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
190: FND_MESSAGE.SET_TOKEN('PARAMETER', 'HZ_PARTY_ID');
191: FND_MESSAGE.SET_TOKEN('VALUE', l_hz_party_id);
192: FND_MSG_PUB.ADD;
193: RAISE FND_API.G_EXC_ERROR;

Line 190: FND_MESSAGE.SET_TOKEN('PARAMETER', 'HZ_PARTY_ID');

186: --dbms_output.put_line('output2');
187:
188: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
189: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
190: FND_MESSAGE.SET_TOKEN('PARAMETER', 'HZ_PARTY_ID');
191: FND_MESSAGE.SET_TOKEN('VALUE', l_hz_party_id);
192: FND_MSG_PUB.ADD;
193: RAISE FND_API.G_EXC_ERROR;
194: end if;

Line 191: FND_MESSAGE.SET_TOKEN('VALUE', l_hz_party_id);

187:
188: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
189: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
190: FND_MESSAGE.SET_TOKEN('PARAMETER', 'HZ_PARTY_ID');
191: FND_MESSAGE.SET_TOKEN('VALUE', l_hz_party_id);
192: FND_MSG_PUB.ADD;
193: RAISE FND_API.G_EXC_ERROR;
194: end if;
195:

Line 214: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

210: P_LOOKUP_VIEW => 'LNS_LOOKUPS');
211: --dbms_output.put_line('output3');
212:
213: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
214: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
215: FND_MESSAGE.SET_TOKEN('PARAMETER', 'PARTICIPANT_TYPE');
216: FND_MESSAGE.SET_TOKEN('VALUE', l_loan_participant_type);
217: FND_MSG_PUB.ADD;
218: RAISE FND_API.G_EXC_ERROR;

Line 215: FND_MESSAGE.SET_TOKEN('PARAMETER', 'PARTICIPANT_TYPE');

211: --dbms_output.put_line('output3');
212:
213: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
214: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
215: FND_MESSAGE.SET_TOKEN('PARAMETER', 'PARTICIPANT_TYPE');
216: FND_MESSAGE.SET_TOKEN('VALUE', l_loan_participant_type);
217: FND_MSG_PUB.ADD;
218: RAISE FND_API.G_EXC_ERROR;
219: end if;

Line 216: FND_MESSAGE.SET_TOKEN('VALUE', l_loan_participant_type);

212:
213: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
214: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
215: FND_MESSAGE.SET_TOKEN('PARAMETER', 'PARTICIPANT_TYPE');
216: FND_MESSAGE.SET_TOKEN('VALUE', l_loan_participant_type);
217: FND_MSG_PUB.ADD;
218: RAISE FND_API.G_EXC_ERROR;
219: end if;
220:

Line 238: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

234: P_TABLE_NAME => 'HZ_CUST_ACCOUNTS');
235: --dbms_output.put_line('output5');
236:
237: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
238: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
239: FND_MESSAGE.SET_TOKEN('PARAMETER', 'CUST_ACCOUNT_ID');
240: FND_MESSAGE.SET_TOKEN('VALUE', l_cust_account_id);
241: FND_MSG_PUB.ADD;
242: RAISE FND_API.G_EXC_ERROR;

Line 239: FND_MESSAGE.SET_TOKEN('PARAMETER', 'CUST_ACCOUNT_ID');

235: --dbms_output.put_line('output5');
236:
237: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
238: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
239: FND_MESSAGE.SET_TOKEN('PARAMETER', 'CUST_ACCOUNT_ID');
240: FND_MESSAGE.SET_TOKEN('VALUE', l_cust_account_id);
241: FND_MSG_PUB.ADD;
242: RAISE FND_API.G_EXC_ERROR;
243: end if;

Line 240: FND_MESSAGE.SET_TOKEN('VALUE', l_cust_account_id);

236:
237: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
238: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
239: FND_MESSAGE.SET_TOKEN('PARAMETER', 'CUST_ACCOUNT_ID');
240: FND_MESSAGE.SET_TOKEN('VALUE', l_cust_account_id);
241: FND_MSG_PUB.ADD;
242: RAISE FND_API.G_EXC_ERROR;
243: end if;
244:

Line 252: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_ACTIVE_DATE');

248:
249: if l_start_date is not null then
250: if l_end_date is not null then
251: if trunc(l_start_date) > trunc(l_end_date) then
252: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_ACTIVE_DATE');
253: FND_MSG_PUB.ADD;
254: RAISE FND_API.G_EXC_ERROR;
255: end if;
256: end if;

Line 444: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_PARTY_TYPE');

440: fetch c_get_party_type into l_party_type;
441: close c_get_party_type;
442:
443: if (l_party_type <> l_loan_party_type OR l_party_type NOT IN ('ORGANIZATION','PERSON')) then
444: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_PARTY_TYPE');
445: FND_MSG_PUB.ADD;
446: RAISE FND_API.G_EXC_ERROR;
447: end if;
448:

Line 473: FND_MESSAGE.SET_NAME('LNS', 'LNS_PARTICIPANT_DUP_PARTY');

469: l_dup_party_count := 0;
470: OPEN CheckDupParty(l_loan_id,l_hz_party_id);
471: FETCH CheckDupParty INTO l_dup_party_count;
472: IF (l_dup_party_count > 0) THEN
473: FND_MESSAGE.SET_NAME('LNS', 'LNS_PARTICIPANT_DUP_PARTY');
474: FND_MSG_PUB.ADD;
475: RAISE FND_API.G_EXC_ERROR;
476: END IF;
477:

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

518:
519: Exception
520: WHEN FND_API.G_EXC_ERROR THEN
521: x_return_status := FND_API.G_RET_STS_ERROR;
522: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
523: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
524: FND_MSG_PUB.ADD;
525: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
526: ROLLBACK TO createParticipant;

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

519: Exception
520: WHEN FND_API.G_EXC_ERROR THEN
521: x_return_status := FND_API.G_RET_STS_ERROR;
522: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
523: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
524: FND_MSG_PUB.ADD;
525: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
526: ROLLBACK TO createParticipant;
527:

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

526: ROLLBACK TO createParticipant;
527:
528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
529: x_return_status := FND_API.G_RET_STS_ERROR;
530: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
531: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
532: FND_MSG_PUB.ADD;
533: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
534: ROLLBACK TO createParticipant;

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

527:
528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
529: x_return_status := FND_API.G_RET_STS_ERROR;
530: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
531: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
532: FND_MSG_PUB.ADD;
533: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
534: ROLLBACK TO createParticipant;
535:

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

534: ROLLBACK TO createParticipant;
535:
536: WHEN OTHERS THEN
537: x_return_status := FND_API.G_RET_STS_ERROR;
538: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
539: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
540: FND_MSG_PUB.ADD;
541: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
542: ROLLBACK TO createParticipant;

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

535:
536: WHEN OTHERS THEN
537: x_return_status := FND_API.G_RET_STS_ERROR;
538: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
539: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
540: FND_MSG_PUB.ADD;
541: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
542: ROLLBACK TO createParticipant;
543:

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

610: x_object_version_number = l_object_version
611: )
612: )
613: THEN
614: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_RECORD_CHANGED');
615: FND_MESSAGE.SET_TOKEN('TABLE', 'lns_participants');
616: FND_MSG_PUB.ADD;
617: RAISE FND_API.G_EXC_ERROR;
618: END IF;

Line 615: FND_MESSAGE.SET_TOKEN('TABLE', 'lns_participants');

611: )
612: )
613: THEN
614: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_RECORD_CHANGED');
615: FND_MESSAGE.SET_TOKEN('TABLE', 'lns_participants');
616: FND_MSG_PUB.ADD;
617: RAISE FND_API.G_EXC_ERROR;
618: END IF;
619:

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

619:
620: x_object_version_number := nvl(x_object_version_number, 1) + 1;
621:
622: EXCEPTION WHEN NO_DATA_FOUND THEN
623: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
624: FND_MESSAGE.SET_TOKEN('RECORD', 'loan participant');
625: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_loan_participant_rec.participant_id), 'null'));
626: FND_MSG_PUB.ADD;
627: RAISE FND_API.G_EXC_ERROR;

Line 624: FND_MESSAGE.SET_TOKEN('RECORD', 'loan participant');

620: x_object_version_number := nvl(x_object_version_number, 1) + 1;
621:
622: EXCEPTION WHEN NO_DATA_FOUND THEN
623: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
624: FND_MESSAGE.SET_TOKEN('RECORD', 'loan participant');
625: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_loan_participant_rec.participant_id), 'null'));
626: FND_MSG_PUB.ADD;
627: RAISE FND_API.G_EXC_ERROR;
628: END;

Line 625: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_loan_participant_rec.participant_id), 'null'));

621:
622: EXCEPTION WHEN NO_DATA_FOUND THEN
623: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
624: FND_MESSAGE.SET_TOKEN('RECORD', 'loan participant');
625: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_loan_participant_rec.participant_id), 'null'));
626: FND_MSG_PUB.ADD;
627: RAISE FND_API.G_EXC_ERROR;
628: END;
629:

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

700:
701: Exception
702: WHEN FND_API.G_EXC_ERROR THEN
703: x_return_status := FND_API.G_RET_STS_ERROR;
704: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
705: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
706: FND_MSG_PUB.ADD;
707: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
708: ROLLBACK TO updateParticipant;

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

701: Exception
702: WHEN FND_API.G_EXC_ERROR THEN
703: x_return_status := FND_API.G_RET_STS_ERROR;
704: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
705: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
706: FND_MSG_PUB.ADD;
707: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
708: ROLLBACK TO updateParticipant;
709:

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

708: ROLLBACK TO updateParticipant;
709:
710: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
711: x_return_status := FND_API.G_RET_STS_ERROR;
712: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
713: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
714: FND_MSG_PUB.ADD;
715: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
716: ROLLBACK TO updateParticipant;

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

709:
710: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
711: x_return_status := FND_API.G_RET_STS_ERROR;
712: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
713: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
714: FND_MSG_PUB.ADD;
715: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
716: ROLLBACK TO updateParticipant;
717:

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

716: ROLLBACK TO updateParticipant;
717:
718: WHEN OTHERS THEN
719: x_return_status := FND_API.G_RET_STS_ERROR;
720: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
721: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
722: FND_MSG_PUB.ADD;
723: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
724: ROLLBACK TO updateParticipant;

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

717:
718: WHEN OTHERS THEN
719: x_return_status := FND_API.G_RET_STS_ERROR;
720: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
721: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
722: FND_MSG_PUB.ADD;
723: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
724: ROLLBACK TO updateParticipant;
725:

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

846:
847: EXCEPTION
848: WHEN FND_API.G_EXC_ERROR THEN
849: x_return_status := FND_API.G_RET_STS_ERROR;
850: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
851: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
852: FND_MSG_PUB.ADD;
853: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
854: ROLLBACK TO createAppealCreditRequest;

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

847: EXCEPTION
848: WHEN FND_API.G_EXC_ERROR THEN
849: x_return_status := FND_API.G_RET_STS_ERROR;
850: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
851: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
852: FND_MSG_PUB.ADD;
853: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
854: ROLLBACK TO createAppealCreditRequest;
855:

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

854: ROLLBACK TO createAppealCreditRequest;
855:
856: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
857: x_return_status := FND_API.G_RET_STS_ERROR;
858: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
859: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
860: FND_MSG_PUB.ADD;
861: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
862: ROLLBACK TO createAppealCreditRequest;

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

855:
856: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
857: x_return_status := FND_API.G_RET_STS_ERROR;
858: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
859: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
860: FND_MSG_PUB.ADD;
861: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
862: ROLLBACK TO createAppealCreditRequest;
863:

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

862: ROLLBACK TO createAppealCreditRequest;
863:
864: WHEN OTHERS THEN
865: x_return_status := FND_API.G_RET_STS_ERROR;
866: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
867: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
868: FND_MSG_PUB.ADD;
869: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
870: ROLLBACK TO createAppealCreditRequest;

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

863:
864: WHEN OTHERS THEN
865: x_return_status := FND_API.G_RET_STS_ERROR;
866: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
867: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
868: FND_MSG_PUB.ADD;
869: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
870: ROLLBACK TO createAppealCreditRequest;
871:

Line 1006: FND_MESSAGE.Set_Name('LNS', 'LNS_CREDIT_REQUEST_API_FAILED');

1002: x_return_status := l_return_status;
1003: x_msg_count := l_msg_count;
1004: x_msg_data := l_msg_data;
1005: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1006: FND_MESSAGE.Set_Name('LNS', 'LNS_CREDIT_REQUEST_API_FAILED');
1007: FND_MSG_PUB.Add;
1008: RAISE FND_API.G_EXC_ERROR;
1009: else
1010: p_loan_participant_rec.CREDIT_REQUEST_ID := l_credit_request_id;

Line 1110: FND_MESSAGE.Set_Name('LNS', 'LNS_G_CRDT_REQ_API_FAILED');

1106: x_return_status := l_return_status;
1107: x_msg_count := l_msg_count;
1108: x_msg_data := l_msg_data;
1109: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1110: FND_MESSAGE.Set_Name('LNS', 'LNS_G_CRDT_REQ_API_FAILED');
1111: FND_MSG_PUB.Add;
1112: RAISE FND_API.G_EXC_ERROR;
1113: else
1114: p_loan_participant_rec.CREDIT_REQUEST_ID := l_credit_request_id;

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

1124:
1125: EXCEPTION
1126: WHEN FND_API.G_EXC_ERROR THEN
1127: x_return_status := FND_API.G_RET_STS_ERROR;
1128: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1129: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
1130: FND_MSG_PUB.ADD;
1131: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1132: ROLLBACK TO createCreditRequest;

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

1125: EXCEPTION
1126: WHEN FND_API.G_EXC_ERROR THEN
1127: x_return_status := FND_API.G_RET_STS_ERROR;
1128: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1129: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
1130: FND_MSG_PUB.ADD;
1131: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1132: ROLLBACK TO createCreditRequest;
1133:

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

1132: ROLLBACK TO createCreditRequest;
1133:
1134: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1135: x_return_status := FND_API.G_RET_STS_ERROR;
1136: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1137: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
1138: FND_MSG_PUB.ADD;
1139: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1140: ROLLBACK TO createCreditRequest;

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

1133:
1134: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1135: x_return_status := FND_API.G_RET_STS_ERROR;
1136: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1137: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
1138: FND_MSG_PUB.ADD;
1139: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1140: ROLLBACK TO createCreditRequest;
1141:

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

1140: ROLLBACK TO createCreditRequest;
1141:
1142: WHEN OTHERS THEN
1143: x_return_status := FND_API.G_RET_STS_ERROR;
1144: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1145: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
1146: FND_MSG_PUB.ADD;
1147: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1148: ROLLBACK TO createCreditRequest;

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

1141:
1142: WHEN OTHERS THEN
1143: x_return_status := FND_API.G_RET_STS_ERROR;
1144: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1145: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
1146: FND_MSG_PUB.ADD;
1147: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1148: ROLLBACK TO createCreditRequest;
1149:

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

1213: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
1214: EXCEPTION
1215: WHEN FND_API.G_EXC_ERROR THEN
1216: x_return_status := FND_API.G_RET_STS_ERROR;
1217: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1218: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
1219: FND_MSG_PUB.ADD;
1220: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1221: ROLLBACK TO denormalizePrimaryInfo;

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

1214: EXCEPTION
1215: WHEN FND_API.G_EXC_ERROR THEN
1216: x_return_status := FND_API.G_RET_STS_ERROR;
1217: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1218: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
1219: FND_MSG_PUB.ADD;
1220: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1221: ROLLBACK TO denormalizePrimaryInfo;
1222:

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

1221: ROLLBACK TO denormalizePrimaryInfo;
1222:
1223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1224: x_return_status := FND_API.G_RET_STS_ERROR;
1225: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1226: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
1227: FND_MSG_PUB.ADD;
1228: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1229: ROLLBACK TO denormalizePrimaryInfo;

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

1222:
1223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1224: x_return_status := FND_API.G_RET_STS_ERROR;
1225: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1226: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
1227: FND_MSG_PUB.ADD;
1228: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1229: ROLLBACK TO denormalizePrimaryInfo;
1230:

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

1229: ROLLBACK TO denormalizePrimaryInfo;
1230:
1231: WHEN OTHERS THEN
1232: x_return_status := FND_API.G_RET_STS_ERROR;
1233: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1234: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
1235: FND_MSG_PUB.ADD;
1236: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1237: ROLLBACK TO denormalizePrimaryInfo;

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

1230:
1231: WHEN OTHERS THEN
1232: x_return_status := FND_API.G_RET_STS_ERROR;
1233: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1234: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
1235: FND_MSG_PUB.ADD;
1236: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1237: ROLLBACK TO denormalizePrimaryInfo;
1238: End denormalizePrimaryInfo;

Line 1328: FND_MESSAGE.Set_Name('LNS', 'LNS_CRDT_REQ_SUBMIT_API_FAILED');

1324:
1325: else
1326:
1327: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1328: FND_MESSAGE.Set_Name('LNS', 'LNS_CRDT_REQ_SUBMIT_API_FAILED');
1329: FND_MSG_PUB.Add;
1330: RAISE FND_API.G_EXC_ERROR;
1331:
1332: end if;

Line 1336: FND_MESSAGE.Set_Name('LNS', 'LNS_CREDIT_REQUEST_NOT_FOUND');

1332: end if;
1333:
1334: else
1335:
1336: FND_MESSAGE.Set_Name('LNS', 'LNS_CREDIT_REQUEST_NOT_FOUND');
1337: FND_MSG_PUB.Add;
1338: RAISE FND_API.G_EXC_ERROR;
1339:
1340: end if;

Line 1611: FND_MESSAGE.SET_TOKEN( 'GENERIC_TEXT' ,SQLERRM );

1607: RETURN l_wf_return_status;
1608:
1609: EXCEPTION
1610: WHEN OTHERS THEN
1611: FND_MESSAGE.SET_TOKEN( 'GENERIC_TEXT' ,SQLERRM );
1612: FND_MSG_PUB.ADD;
1613: WF_CORE.CONTEXT(G_PKG_NAME,
1614: 'OCM_WORKFLOW_CREDIT_RECO_EVENT',
1615: p_event.getEventName(),