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_MSG_PUB

Line 141: FND_MSG_PUB.ADD;

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
145: when NO_DATA_FOUND then

Line 147: FND_MSG_PUB.ADD;

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:
151: end if; --end if (l_loan_participant_type = 'PRIMARY_BORROWER') then

Line 167: FND_MSG_PUB.ADD;

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:
171: END IF;

Line 192: FND_MSG_PUB.ADD;

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:
196: END IF;

Line 217: FND_MSG_PUB.ADD;

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:
221: END IF;

Line 241: FND_MSG_PUB.ADD;

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:
245: END IF;

Line 253: FND_MSG_PUB.ADD;

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;
257: end if;

Line 270: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

266: EXCEPTION
267: WHEN FND_API.G_EXC_ERROR THEN
268: --ROLLBACK TO validateParticipant;
269: x_return_status := FND_API.G_RET_STS_ERROR;
270: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
271:
272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
273: --ROLLBACK TO validateParticipant;
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 275: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

271:
272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
273: --ROLLBACK TO validateParticipant;
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
275: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
276:
277: WHEN OTHERS THEN
278: --ROLLBACK TO Validate_any_id_PVT;
279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 280: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

276:
277: WHEN OTHERS THEN
278: --ROLLBACK TO Validate_any_id_PVT;
279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
280: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
281:
282: END validateParticipant;
283:
284: PROCEDURE do_create_participant(p_loan_participant_rec IN OUT NOCOPY loan_participant_rec_type,

Line 417: FND_MSG_PUB.initialize;

413: SAVEPOINT createParticipant;
414:
415: -- initialize message list if l_init_msg_list is set to TRUE.
416: IF FND_API.to_Boolean(l_init_msg_list) THEN
417: FND_MSG_PUB.initialize;
418: END IF;
419: -- Get the default values of ContactPerson PartyId and ContactRel PartyId
420: getDefaultPrimaryContact(p_loan_participant_rec => l_loan_participant_rec,
421: x_return_status => l_return_status,

Line 445: FND_MSG_PUB.ADD;

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:
449: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 474: FND_MSG_PUB.ADD;

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:
478: if (l_loan_credit_review_flag = 'Y' and l_loan_status = 'INCOMPLETE' and (l_loan_sec_status is null OR l_loan_sec_status NOT IN ('IN_CREDIT_REVIEW','CREDIT_REVIEW_COMPLETE'))) then

Line 524: FND_MSG_PUB.ADD;

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:
528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 525: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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:
528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
529: x_return_status := FND_API.G_RET_STS_ERROR;

Line 532: FND_MSG_PUB.ADD;

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:
536: WHEN OTHERS THEN

Line 533: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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:
536: WHEN OTHERS THEN
537: x_return_status := FND_API.G_RET_STS_ERROR;

Line 540: FND_MSG_PUB.ADD;

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:
544: END createParticipant;

Line 541: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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:
544: END createParticipant;
545:

Line 581: FND_MSG_PUB.initialize;

577: END IF;
578:
579: -- initialize message list if l_init_msg_list is set to TRUE.
580: IF FND_API.to_Boolean(l_init_msg_list) THEN
581: FND_MSG_PUB.initialize;
582: END IF;
583:
584:
585: -- Get the default values of ContactPerson PartyId and ContactRel PartyId

Line 616: FND_MSG_PUB.ADD;

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:
620: x_object_version_number := nvl(x_object_version_number, 1) + 1;

Line 626: FND_MSG_PUB.ADD;

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:
630: if (p_validation_level = FND_API.G_VALID_LEVEL_FULL) then

Line 706: FND_MSG_PUB.ADD;

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:
710: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 707: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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:
710: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
711: x_return_status := FND_API.G_RET_STS_ERROR;

Line 714: FND_MSG_PUB.ADD;

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:
718: WHEN OTHERS THEN

Line 715: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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:
718: WHEN OTHERS THEN
719: x_return_status := FND_API.G_RET_STS_ERROR;

Line 722: FND_MSG_PUB.ADD;

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:
726: END updateParticipant;

Line 723: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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:
726: END updateParticipant;
727:

Line 852: FND_MSG_PUB.ADD;

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:
856: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 853: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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:
856: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
857: x_return_status := FND_API.G_RET_STS_ERROR;

Line 860: FND_MSG_PUB.ADD;

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:
864: WHEN OTHERS THEN

Line 861: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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:
864: WHEN OTHERS THEN
865: x_return_status := FND_API.G_RET_STS_ERROR;

Line 868: FND_MSG_PUB.ADD;

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:
872: END createAppealCreditRequest;

Line 869: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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:
872: END createAppealCreditRequest;
873:

Line 1007: FND_MSG_PUB.Add;

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;
1011: if (l_credit_request_type = 'RESUBMISSION') then

Line 1111: FND_MSG_PUB.Add;

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;
1115: end if;

Line 1130: FND_MSG_PUB.ADD;

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:
1134: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1131: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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:
1134: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1135: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1138: FND_MSG_PUB.ADD;

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:
1142: WHEN OTHERS THEN

Line 1139: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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:
1142: WHEN OTHERS THEN
1143: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1146: FND_MSG_PUB.ADD;

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:
1150: END createCreditRequest;

Line 1147: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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:
1150: END createCreditRequest;
1151:

Line 1219: FND_MSG_PUB.ADD;

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:
1223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1220: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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:
1223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1224: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1227: FND_MSG_PUB.ADD;

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:
1231: WHEN OTHERS THEN

Line 1228: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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:
1231: WHEN OTHERS THEN
1232: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1235: FND_MSG_PUB.ADD;

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;
1239:

Line 1236: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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;
1239:
1240: ----------------------------------------------------------------

Line 1327: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1323: COMMIT;
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:

Line 1329: FND_MSG_PUB.Add;

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;
1333:

Line 1337: FND_MSG_PUB.Add;

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;
1341: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');

Line 1612: FND_MSG_PUB.ADD;

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(),
1616: p_subscription_guid);