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.JAI_CMN_RGM_TERMS_PKG dependencies on JAI_CONSTANTS

Line 198: p_process_flag := jai_constants.expected_error;

194: */
195:
196: IF NVL(p_term_id,0) = 0 THEN
197:
198: p_process_flag := jai_constants.expected_error;
199: p_process_msg := 'jai_rgm_claims_pkg.prepare_term_schedules => Term Id cannot be NULL' ;
200: return;
201:
202: END IF;

Line 206: p_process_flag := jai_constants.expected_error;

202: END IF;
203:
204: IF NVL(p_amount,-1) <= 0 THEN
205:
206: p_process_flag := jai_constants.expected_error;
207: p_process_msg := 'jai_rgm_claims_pkg.prepare_term_schedules => Amount should not be NULL or Zero or Negative' ;
208: return;
209:
210: END IF ;

Line 230: p_process_flag := jai_constants.expected_error ;

226: lv_frequency_day ;
227:
228: IF NOT ( cur_term_details % FOUND ) THEN
229:
230: p_process_flag := jai_constants.expected_error ;
231: p_process_msg := 'jai_rgm_claims_pkg.prepare_term_schedules => Term is not defined in jai_rgm_terms' ;
232: return ;
233:
234: END IF ;

Line 248: p_process_flag := jai_constants.expected_error;

244: ln_instalment_amt := p_amount / lv_no_of_instalments ;
245:
246: ELSE
247:
248: p_process_flag := jai_constants.expected_error;
249: p_process_msg := 'jai_rgm_claims_pkg.prepare_term_schedules => Instalment Frequency is zero or negative ';
250: return;
251:
252: END IF ;

Line 346: p_process_flag := jai_constants.successful ;

342: ) ;
343:
344: END LOOP ;
345:
346: p_process_flag := jai_constants.successful ;
347: return ;
348:
349: EXCEPTION
350: WHEN OTHERS THEN

Line 351: p_process_flag := jai_constants.unexpected_error ;

347: return ;
348:
349: EXCEPTION
350: WHEN OTHERS THEN
351: p_process_flag := jai_constants.unexpected_error ;
352: p_process_msg := 'Error Occured in jai_rgm_claims_pkg.prepare_term_schedules - ' || substr(sqlerrm,1,900) ;
353:
354: END generate_term_schedules ;
355:

Line 439: p_process_flag := jai_constants.expected_error;

435: */
436:
437: IF p_regime_id IS NULL THEN
438:
439: p_process_flag := jai_constants.expected_error;
440: p_process_msg := 'jai_rgm_claims_pkg.get_term_id => Regime ID cannot be NULL' ;
441: return;
442:
443: END IF;

Line 447: p_process_flag := jai_constants.expected_error;

443: END IF;
444:
445: IF p_item_id IS NULL THEN
446:
447: p_process_flag := jai_constants.expected_error;
448: p_process_msg := 'jai_rgm_claims_pkg.get_term_id => Item ID cannot be NULL' ;
449: return;
450:
451: END IF ;

Line 455: p_process_flag := jai_constants.expected_error;

451: END IF ;
452:
453: IF p_organization_id IS NULL THEN
454:
455: p_process_flag := jai_constants.expected_error;
456: p_process_msg := 'jai_rgm_claims_pkg.get_term_id => Organization ID cannot be NULL' ;
457: return;
458:
459: END IF ;

Line 463: p_process_flag := jai_constants.expected_error;

459: END IF ;
460:
461: IF p_party_type IS NULL THEN
462:
463: p_process_flag := jai_constants.expected_error;
464: p_process_msg := 'jai_rgm_claims_pkg.get_term_id => Party Type cannot be NULL' ;
465: return;
466:
467: END IF ;

Line 472: p_process_flag := jai_constants.expected_error;

468:
469:
470: IF p_location_id IS NULL THEN
471:
472: p_process_flag := jai_constants.expected_error;
473: p_process_msg := 'jai_rgm_claims_pkg.get_term_id => Location ID cannot be NULL' ;
474: return;
475:
476: END IF ;

Line 505: IF ( lv_reg_item_class IS NULL ) OR ( lv_process_flag <> jai_constants.successful ) THEN

501: p_process_flag => lv_process_flag ,
502: p_process_msg => lv_process_msg
503: );
504:
505: IF ( lv_reg_item_class IS NULL ) OR ( lv_process_flag <> jai_constants.successful ) THEN
506:
507: p_process_flag := jai_constants.expected_error;
508: p_process_msg := 'jai_rgm_claims_pkg.get_term_id => jai_inv_items_pkg.jai_get_attrib => p_process_flag :: lv_process_msg' ;
509: return;

Line 507: p_process_flag := jai_constants.expected_error;

503: );
504:
505: IF ( lv_reg_item_class IS NULL ) OR ( lv_process_flag <> jai_constants.successful ) THEN
506:
507: p_process_flag := jai_constants.expected_error;
508: p_process_msg := 'jai_rgm_claims_pkg.get_term_id => jai_inv_items_pkg.jai_get_attrib => p_process_flag :: lv_process_msg' ;
509: return;
510:
511: END IF ;

Line 526: p_process_flag := jai_constants.expected_error ;

522: CLOSE cur_term_id ;
523:
524: IF p_term_id IS NULL THEN
525:
526: p_process_flag := jai_constants.expected_error ;
527: p_process_msg := 'jai_rgm_claims_pkg.get_term_id => No term defined' ;
528: RETURN ;
529:
530: END IF ;

Line 532: p_process_flag := jai_constants.successful ;

528: RETURN ;
529:
530: END IF ;
531:
532: p_process_flag := jai_constants.successful ;
533: p_process_msg := NULL;
534:
535: EXCEPTION
536: WHEN others THEN

Line 538: p_process_flag := jai_constants.unexpected_error;

534:
535: EXCEPTION
536: WHEN others THEN
537:
538: p_process_flag := jai_constants.unexpected_error;
539: p_process_msg := 'JAI_CMN_RG_OTHERS.get_term_id => Error Occured : ' || substr(sqlerrm,1,1000) ;
540:
541: END get_term_id ;
542:

Line 568: p_process_flag := jai_constants.expected_error;

564: */
565:
566: IF p_term_id IS NULL THEN
567:
568: p_process_flag := jai_constants.expected_error;
569: p_process_msg := 'jai_rgm_claims_pkg.set_term_in_use_flag => Term ID cannot be NULL' ;
570: return;
571:
572: END IF;

Line 578: p_process_flag := jai_constants.expected_error;

574: OPEN cur_term_flag ( cp_term_id => p_term_id );
575: FETCH cur_term_flag INTO lv_term_in_use_flag ;
576: IF NOT ( cur_term_flag%FOUND ) THEN
577:
578: p_process_flag := jai_constants.expected_error;
579: p_process_msg := 'jai_rgm_claims_pkg.set_term_in_use_flag => Term ID does not exist in database' ;
580: CLOSE cur_term_flag ;
581: return;
582:

Line 597: p_process_flag := jai_constants.successful ;

593: WHERE term_id = p_term_id ;
594:
595: END IF ;
596:
597: p_process_flag := jai_constants.successful ;
598: p_process_msg := NULL;
599:
600: EXCEPTION
601: WHEN others THEN

Line 603: p_process_flag := jai_constants.unexpected_error;

599:
600: EXCEPTION
601: WHEN others THEN
602:
603: p_process_flag := jai_constants.unexpected_error;
604: p_process_msg := 'JAI_CMN_RG_OTHERS.set_term_in_use_flag => Error Occured : ' || substr(sqlerrm,1,1000) ;
605:
606: END set_term_in_use ;
607: