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 169: x_return_status := fnd_api.g_ret_sts_error ;

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

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

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

Line 191: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 288: x_return_status := fnd_api.g_ret_sts_success;

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

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

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

Line 319: RAISE fnd_api.g_exc_error;

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

Line 324: WHEN FND_API.g_exc_error THEN

320: END IF;
321: END LOOP;
322:
323: EXCEPTION
324: WHEN FND_API.g_exc_error THEN
325:
326: x_return_status := fnd_api.g_ret_sts_error;
327:
328: WHEN OTHERS THEN

Line 326: x_return_status := fnd_api.g_ret_sts_error;

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

Line 331: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 354: x_return_status := fnd_api.g_ret_sts_success;

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

Line 370: WHEN FND_API.g_exc_error THEN

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

Line 372: x_return_status := fnd_api.g_ret_sts_error;

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

Line 376: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 410: x_return_status := fnd_api.g_ret_sts_success;

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

Line 424: WHEN FND_API.g_exc_error THEN

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

Line 425: x_return_status := fnd_api.g_ret_sts_error;

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

Line 429: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 482: x_return_status := fnd_api.g_ret_sts_success;

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

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

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

Line 529: RAISE fnd_api.g_exc_error;

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

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

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

Line 544: RAISE fnd_api.g_exc_error;

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

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

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

Line 554: RAISE fnd_api.g_exc_error;

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

Line 561: WHEN FND_API.g_exc_error THEN

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

Line 562: x_return_status := fnd_api.g_ret_sts_error;

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

Line 566: x_return_status := fnd_api.g_ret_sts_unexp_error;

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