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 445: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_PARTY_TYPE');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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