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.OCM_CREDIT_REQUEST_UPDATE_PUB dependencies on FND_API

Line 47: x_return_status := FND_API.G_RET_STS_SUCCESS;

43: END IF;
44:
45: SAVEPOINT UPDATE_CREDIT_REQ_PVT;
46:
47: x_return_status := FND_API.G_RET_STS_SUCCESS;
48: itemkey := p_credit_request_rec.credit_request_id;
49:
50: IF FND_API.to_Boolean( p_init_msg_list )
51: THEN

Line 50: IF FND_API.to_Boolean( p_init_msg_list )

46:
47: x_return_status := FND_API.G_RET_STS_SUCCESS;
48: itemkey := p_credit_request_rec.credit_request_id;
49:
50: IF FND_API.to_Boolean( p_init_msg_list )
51: THEN
52: FND_MSG_PUB.initialize;
53: END IF;
54:

Line 136: x_return_status := FND_API.G_RET_STS_ERROR;

132:
133: EXCEPTION
134: WHEN NO_DATA_FOUND THEN
135: x_msg_data := 'Invalid Requestor Id';
136: x_return_status := FND_API.G_RET_STS_ERROR;
137: return;
138: WHEN OTHERS THEN
139: x_msg_data := Sqlerrm;
140: x_return_status := FND_API.G_RET_STS_ERROR;

Line 140: x_return_status := FND_API.G_RET_STS_ERROR;

136: x_return_status := FND_API.G_RET_STS_ERROR;
137: return;
138: WHEN OTHERS THEN
139: x_msg_data := Sqlerrm;
140: x_return_status := FND_API.G_RET_STS_ERROR;
141: return;
142: END;
143: ELSIF p_credit_request_rec.requestor_type = 'FND_USER'
144: THEN

Line 153: x_return_status := FND_API.G_RET_STS_ERROR;

149:
150: EXCEPTION
151: WHEN NO_DATA_FOUND THEN
152: x_msg_data := 'Invalid User Id';
153: x_return_status := FND_API.G_RET_STS_ERROR;
154: return;
155: WHEN OTHERS THEN
156: x_msg_data := Sqlerrm;
157: x_return_status := FND_API.G_RET_STS_ERROR;

Line 157: x_return_status := FND_API.G_RET_STS_ERROR;

153: x_return_status := FND_API.G_RET_STS_ERROR;
154: return;
155: WHEN OTHERS THEN
156: x_msg_data := Sqlerrm;
157: x_return_status := FND_API.G_RET_STS_ERROR;
158: return;
159: END;
160: ELSE
161: x_msg_data := 'Invalid requestor';

Line 162: x_return_status := FND_API.G_RET_STS_ERROR;

158: return;
159: END;
160: ELSE
161: x_msg_data := 'Invalid requestor';
162: x_return_status := FND_API.G_RET_STS_ERROR;
163: return;
164:
165: END IF;
166: END IF;

Line 178: x_return_status := FND_API.G_RET_STS_ERROR;

174:
175: EXCEPTION
176: WHEN NO_DATA_FOUND THEN
177: x_msg_data := 'Invalid Credit Type';
178: x_return_status := FND_API.G_RET_STS_ERROR;
179: return;
180: WHEN OTHERS THEN
181: x_msg_data := Sqlerrm;
182: x_return_status := FND_API.G_RET_STS_ERROR;

Line 182: x_return_status := FND_API.G_RET_STS_ERROR;

178: x_return_status := FND_API.G_RET_STS_ERROR;
179: return;
180: WHEN OTHERS THEN
181: x_msg_data := Sqlerrm;
182: x_return_status := FND_API.G_RET_STS_ERROR;
183: return;
184:
185: END;
186: END IF;

Line 236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

232: debug ( 'OCM_CREDIT_REQUEST_UPDATE_PUB.UPDATE_CREDIT_REQUEST(-)');
233: END IF;
234: EXCEPTION
235: WHEN OTHERS THEN
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
237: ROLLBACK TO UPDATE_CREDIT_REQ_PVT;
238: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
239: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UPDATE_CREDIT_REQUEST : '||SQLERRM);
240: FND_MSG_PUB.Add;

Line 241: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

237: ROLLBACK TO UPDATE_CREDIT_REQ_PVT;
238: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
239: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','UPDATE_CREDIT_REQUEST : '||SQLERRM);
240: FND_MSG_PUB.Add;
241: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
242: p_count => x_msg_count,
243: p_data => x_msg_data
244: );
245:

Line 304: p_return_status := FND_API.G_RET_STS_SUCCESS;

300: IF pg_debug = 'Y'
301: THEN
302: debug ( 'OCM_CREDIT_REQUEST_UPDATE_PUB.GET_CREDIT_REQUEST_REC(+)');
303: END IF;
304: p_return_status := FND_API.G_RET_STS_SUCCESS;
305: -- Get credit request rec
306: SELECT credit_request_id,
307: APPLICATION_NUMBER,
308: APPLICATION_DATE,

Line 500: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

496: THEN
497: NULL;
498: WHEN OTHERS
499: THEN
500: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
501: p_error_msg := 'OCM_CREDIT_REQUEST_UPDATE_PUB.GET_CREDIT_REQUEST_REC '|| sqlerrm;
502:
503: END;
504:

Line 507: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,

503: END;
504:
505: PROCEDURE update_credit_request_status (
506: p_api_version IN NUMBER,
507: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
508: p_commit IN VARCHAR2,
509: p_validation_level IN VARCHAR2,
510: x_return_status OUT NOCOPY VARCHAR2,
511: x_msg_count OUT NOCOPY NUMBER,

Line 525: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

521: WHERE parent_credit_request_id = p_credit_request_id
522: AND status = 'SAVE';
523:
524: /* 6838491 */
525: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
526: l_msg_count NUMBER;
527: l_msg_data VARCHAR2(2000);
528: l_guar_credit_request_id ar_cmgt_credit_requests.credit_request_id%TYPE;
529: i NUMBER := 0;

Line 557: x_return_status := FND_API.G_RET_STS_SUCCESS;

553: debug ( 'OCM_CREDIT_REQUEST_UPDATE_PUB.update_credit_request_status(+)');
554: debug ( 'Credit request Id :' || to_char(p_credit_request_id));
555: debug ( 'Status :' || p_credit_request_status);
556: END IF;
557: x_return_status := FND_API.G_RET_STS_SUCCESS;
558:
559: SAVEPOINT UPDATE_CREDIT_REQ_STATUS;
560:
561: IF FND_API.to_Boolean( p_init_msg_list )

Line 561: IF FND_API.to_Boolean( p_init_msg_list )

557: x_return_status := FND_API.G_RET_STS_SUCCESS;
558:
559: SAVEPOINT UPDATE_CREDIT_REQ_STATUS;
560:
561: IF FND_API.to_Boolean( p_init_msg_list )
562: THEN
563: FND_MSG_PUB.initialize;
564: END IF;
565:

Line 569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

565:
566: -- first check the status in case it was passed
567: IF p_credit_request_status NOT IN ( 'SUBMIT', 'SAVE')
568: THEN
569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
570: x_msg_data := 'Invalid Status';
571: return;
572: END IF;
573:

Line 583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

579: WHERE credit_request_id = p_credit_request_id;
580:
581: EXCEPTION
582: WHEN NO_DATA_FOUND THEN
583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
584: x_msg_data := 'Invalid Credit Request Id';
585: return;
586: WHEN OTHERS THEN
587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
584: x_msg_data := 'Invalid Credit Request Id';
585: return;
586: WHEN OTHERS THEN
587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
588: x_msg_data := sqlerrm;
589: return;
590: END;
591:

Line 632: p_init_msg_list => FND_API.G_FALSE,

628: END IF;
629:
630: AR_CMGT_CREDIT_REQUEST_API.create_credit_request
631: (p_api_version => 1 ,
632: p_init_msg_list => FND_API.G_FALSE,
633: p_commit => FND_API.G_FALSE,
634: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
635: x_return_status => l_return_status ,
636: x_msg_count => l_msg_count ,

Line 633: p_commit => FND_API.G_FALSE,

629:
630: AR_CMGT_CREDIT_REQUEST_API.create_credit_request
631: (p_api_version => 1 ,
632: p_init_msg_list => FND_API.G_FALSE,
633: p_commit => FND_API.G_FALSE,
634: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
635: x_return_status => l_return_status ,
636: x_msg_count => l_msg_count ,
637: x_msg_data => l_msg_data ,

Line 634: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

630: AR_CMGT_CREDIT_REQUEST_API.create_credit_request
631: (p_api_version => 1 ,
632: p_init_msg_list => FND_API.G_FALSE,
633: p_commit => FND_API.G_FALSE,
634: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
635: x_return_status => l_return_status ,
636: x_msg_count => l_msg_count ,
637: x_msg_data => l_msg_data ,
638: p_application_number => NULL ,

Line 680: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

676: debug ( 'Processed guarantor party_id = ' || c_guar.party_id ||
677: ' credit_request_id = ' || l_guar_credit_request_id);
678: END IF;
679:
680: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
681: THEN
682: debug('Creating guarantor credit request failed');
683: x_return_status := l_return_status;
684: x_msg_data := l_msg_data;

Line 741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

737: END IF;
738:
739: EXCEPTION
740: WHEN OTHERS THEN
741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
742: x_msg_data := sqlerrm;
743: ROLLBACK TO UPDATE_CREDIT_REQ_STATUS;
744: return;
745: END;