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

Line 80: x_return_status := fnd_api.g_ret_sts_success;

76: IF g_debug <= gme_debug.g_log_procedure THEN
77: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
78: || l_api_name);
79: END IF;
80: x_return_status := fnd_api.g_ret_sts_success;
81: l_user_id := p_user_id ;
82: l_org_id := p_org_id ;
83: l_object_id := p_object_id ;
84: l_object_type := p_object_type;

Line 172: x_return_status := fnd_api.g_ret_sts_error ;

168:
169: -- message that user is not defined in hrms
170: fnd_message.set_name ('INV', 'INV_INT_USRCODE');
171: fnd_msg_pub.ADD;
172: x_return_status := fnd_api.g_ret_sts_error ;
173: RETURN 0;
174:
175: WHEN NO_CERTIFICATE_REQ THEN
176:

Line 182: x_return_status := fnd_api.g_ret_sts_error ;*/

178: RETURN 1;
179: /*WHEN NO_COMPETENCE_DEFINED THEN
180: -- this object has no competence for certification
181: RETURN 0;
182: x_return_status := fnd_api.g_ret_sts_error ;*/
183: WHEN NO_COMPETENCE or no_certificate THEN
184: IF l_opert_cert_hdr.override = 1 THEN
185: RETURN 0;
186: ELSE

Line 194: x_return_status := fnd_api.g_ret_sts_unexp_error;

190:
191: WHEN OTHERS THEN
192: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
193: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
194: x_return_status := fnd_api.g_ret_sts_unexp_error;
195: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
196: RETURN 0;
197: END check_certification;
198:

Line 291: x_return_status := fnd_api.g_ret_sts_success;

287: IF g_debug <= gme_debug.g_log_procedure THEN
288: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
289: || l_api_name);
290: END IF;
291: x_return_status := fnd_api.g_ret_sts_success;
292:
293: l_user_id := p_user_id ;
294: l_org_id := p_org_id ;
295: l_header_id := p_header_id ;

Line 321: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

317: get_rec.qualification_id,
318: get_rec.qualification_type,
319: get_rec.PROFICIENCY_LEVEL_ID, x_return_status);
320: --dbms_output.put_line('l_trans_detail_id '||l_trans_detail_id);
321: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
322: RAISE fnd_api.g_exc_error;
323: END IF;
324: END LOOP;
325:

Line 322: RAISE fnd_api.g_exc_error;

318: get_rec.qualification_type,
319: get_rec.PROFICIENCY_LEVEL_ID, x_return_status);
320: --dbms_output.put_line('l_trans_detail_id '||l_trans_detail_id);
321: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
322: RAISE fnd_api.g_exc_error;
323: END IF;
324: END LOOP;
325:
326: EXCEPTION

Line 327: WHEN FND_API.g_exc_error THEN

323: END IF;
324: END LOOP;
325:
326: EXCEPTION
327: WHEN FND_API.g_exc_error THEN
328:
329: x_return_status := fnd_api.g_ret_sts_error;
330:
331: WHEN OTHERS THEN

Line 329: x_return_status := fnd_api.g_ret_sts_error;

325:
326: EXCEPTION
327: WHEN FND_API.g_exc_error THEN
328:
329: x_return_status := fnd_api.g_ret_sts_error;
330:
331: WHEN OTHERS THEN
332: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
333: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

Line 334: x_return_status := fnd_api.g_ret_sts_unexp_error;

330:
331: WHEN OTHERS THEN
332: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
333: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
334: x_return_status := fnd_api.g_ret_sts_unexp_error;
335:
336: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
337:
338:

Line 357: x_return_status := fnd_api.g_ret_sts_success;

353:
354:
355: BEGIN
356: -- Initially let us assign the return status to success
357: x_return_status := fnd_api.g_ret_sts_success;
358:
359: l_Operator_certificate_id := p_Operator_certificate_id ;
360: l_EVENT_KEY := p_EVENT_KEY ;
361: l_EVENT_NAME := p_EVENT_NAME ;

Line 373: WHEN FND_API.g_exc_error THEN

369:
370: END IF;
371:
372: EXCEPTION
373: WHEN FND_API.g_exc_error THEN
374:
375: x_return_status := fnd_api.g_ret_sts_error;
376: WHEN OTHERS THEN
377: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');

Line 375: x_return_status := fnd_api.g_ret_sts_error;

371:
372: EXCEPTION
373: WHEN FND_API.g_exc_error THEN
374:
375: x_return_status := fnd_api.g_ret_sts_error;
376: WHEN OTHERS THEN
377: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
378: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
379: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 379: x_return_status := fnd_api.g_ret_sts_unexp_error;

375: x_return_status := fnd_api.g_ret_sts_error;
376: WHEN OTHERS THEN
377: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
378: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
379: x_return_status := fnd_api.g_ret_sts_unexp_error;
380:
381:
382: END Update_erecord;
383:

Line 413: x_return_status := fnd_api.g_ret_sts_success;

409: Operator_certificate_id,TRANSACTION_ID
410: FROM GMO_OPERATOR_CERT_TRANS
411: WHERE operator_certificate_id = p_Operator_certificate_id;
412: BEGIN
413: x_return_status := fnd_api.g_ret_sts_success;
414: FOR get_rec IN CUR_GET_CERT_RECORD LOOP
415: update GMO_OPERATOR_CERT_TRANS
416: set EVENT_NAME = nvl(p_EVENT_NAME,get_rec.EVENT_NAME)
417: , EVENT_KEY = nvl(p_EVENT_KEY,get_rec.EVENT_KEY)

Line 427: WHEN FND_API.g_exc_error THEN

423: where operator_certificate_id = get_rec.operator_certificate_id ;
424:
425: END LOOP;
426: EXCEPTION
427: WHEN FND_API.g_exc_error THEN
428: x_return_status := fnd_api.g_ret_sts_error;
429: WHEN OTHERS THEN
430: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
431: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

Line 428: x_return_status := fnd_api.g_ret_sts_error;

424:
425: END LOOP;
426: EXCEPTION
427: WHEN FND_API.g_exc_error THEN
428: x_return_status := fnd_api.g_ret_sts_error;
429: WHEN OTHERS THEN
430: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
431: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
432: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 432: x_return_status := fnd_api.g_ret_sts_unexp_error;

428: x_return_status := fnd_api.g_ret_sts_error;
429: WHEN OTHERS THEN
430: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
431: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
432: x_return_status := fnd_api.g_ret_sts_unexp_error;
433: END update_cert_record;
434:
435:
436: PROCEDURE cert_details (

Line 485: x_return_status := fnd_api.g_ret_sts_success;

481: l_LAST_UPDATE_LOGIN NUMBER;
482:
483: BEGIN
484: -- Initially let us assign the return status to success
485: x_return_status := fnd_api.g_ret_sts_success;
486:
487: l_HEADER_ID := p_HEADER_ID ;
488: l_TRANSACTION_ID := p_TRANSACTION_ID ;
489: l_USER_ID := p_USER_ID ;

Line 531: IF (l_return_status = fnd_api.g_ret_sts_error) THEN

527: ,p_last_updated_by => l_last_updated_by
528: ,P_LAST_UPDATE_LOGIN => l_LAST_UPDATE_LOGIN
529: ,x_return_Status => l_return_status);
530: -- check for return status
531: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
532: RAISE fnd_api.g_exc_error;
533: END IF;
534: -- dbms_output.put_line('l_op_cert_id '||l_operator_certificate_id);
535: SELECT organization_id into l_org_id

Line 532: RAISE fnd_api.g_exc_error;

528: ,P_LAST_UPDATE_LOGIN => l_LAST_UPDATE_LOGIN
529: ,x_return_Status => l_return_status);
530: -- check for return status
531: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
532: RAISE fnd_api.g_exc_error;
533: END IF;
534: -- dbms_output.put_line('l_op_cert_id '||l_operator_certificate_id);
535: SELECT organization_id into l_org_id
536: FROM gmo_opert_cert_header

Line 546: IF (l_return_status = fnd_api.g_ret_sts_error) THEN

542: ,p_header_id => l_header_id
543: ,p_operator_certificate_id =>l_operator_certificate_id
544: ,p_eff_date => l_eff_date
545: ,x_return_status => l_return_status);
546: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
547: RAISE fnd_api.g_exc_error;
548: END IF;
549: gmo_opert_cert_gtmp_dbl.INSERT_ROW (
550: p_ERECORD_ID => l_erecord_id

Line 547: RAISE fnd_api.g_exc_error;

543: ,p_operator_certificate_id =>l_operator_certificate_id
544: ,p_eff_date => l_eff_date
545: ,x_return_status => l_return_status);
546: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
547: RAISE fnd_api.g_exc_error;
548: END IF;
549: gmo_opert_cert_gtmp_dbl.INSERT_ROW (
550: p_ERECORD_ID => l_erecord_id
551: ,p_operator_certificate_id => l_operator_certificate_id

Line 556: IF (l_return_status = fnd_api.g_ret_sts_error) THEN

552: ,p_EVENT_KEY => l_event_key
553: ,p_EVENT_NAME => l_event_name
554: ,x_return_status => l_return_status ) ;
555:
556: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
557: RAISE fnd_api.g_exc_error;
558: END IF;
559: END IF;
560:

Line 557: RAISE fnd_api.g_exc_error;

553: ,p_EVENT_NAME => l_event_name
554: ,x_return_status => l_return_status ) ;
555:
556: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
557: RAISE fnd_api.g_exc_error;
558: END IF;
559: END IF;
560:
561:

Line 564: WHEN FND_API.g_exc_error THEN

560:
561:
562: p_operator_certificate_id := l_operator_certificate_id;
563: EXCEPTION
564: WHEN FND_API.g_exc_error THEN
565: x_return_status := fnd_api.g_ret_sts_error;
566: WHEN OTHERS THEN
567: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
568: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

Line 565: x_return_status := fnd_api.g_ret_sts_error;

561:
562: p_operator_certificate_id := l_operator_certificate_id;
563: EXCEPTION
564: WHEN FND_API.g_exc_error THEN
565: x_return_status := fnd_api.g_ret_sts_error;
566: WHEN OTHERS THEN
567: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
568: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
569: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 569: x_return_status := fnd_api.g_ret_sts_unexp_error;

565: x_return_status := fnd_api.g_ret_sts_error;
566: WHEN OTHERS THEN
567: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
568: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
569: x_return_status := fnd_api.g_ret_sts_unexp_error;
570:
571: END cert_details;
572:
573: END gmo_oper_cert_pub;