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.GR_ITEM_PROPERTIES_PUB dependencies on FND_MESSAGE

Line 241: FND_MESSAGE.SET_NAME('GR',

237: l_language_code := p_item_properties_tab(i).language_code;
238:
239:
240: IF l_action is NULL or l_action not in ('I','D','U') then
241: FND_MESSAGE.SET_NAME('GR',
242: 'GR_INVALID_ACTION');
243: RAISE loop_exception;
244: END IF;
245:

Line 249: FND_MESSAGE.SET_NAME('GR',

245:
246: IF l_organization is NULL and l_organization_id is NULL then
247: l_msg_token := 'organization or organization_id';
248: --GMD_API_PUB.Log_Message('GR_NULL_VALUE');
249: FND_MESSAGE.SET_NAME('GR',
250: 'GR_NULL_VALUE');
251: FND_MESSAGE.SET_TOKEN('CODE',
252: l_msg_token,
253: FALSE);

Line 251: FND_MESSAGE.SET_TOKEN('CODE',

247: l_msg_token := 'organization or organization_id';
248: --GMD_API_PUB.Log_Message('GR_NULL_VALUE');
249: FND_MESSAGE.SET_NAME('GR',
250: 'GR_NULL_VALUE');
251: FND_MESSAGE.SET_TOKEN('CODE',
252: l_msg_token,
253: FALSE);
254: RAISE loop_exception;
255: END IF;

Line 264: FND_MESSAGE.SET_NAME('GR',

260: FETCH c_get_org_id into lv_organization_id;
261: IF c_get_org_id%NOTFOUND THEN
262: CLOSE c_get_org_id;
263: l_msg_token := l_organization;
264: FND_MESSAGE.SET_NAME('GR',
265: 'GR_RECORD_NOT_FOUND');
266: FND_MESSAGE.SET_TOKEN('CODE',
267: l_msg_token,
268: FALSE);

Line 266: FND_MESSAGE.SET_TOKEN('CODE',

262: CLOSE c_get_org_id;
263: l_msg_token := l_organization;
264: FND_MESSAGE.SET_NAME('GR',
265: 'GR_RECORD_NOT_FOUND');
266: FND_MESSAGE.SET_TOKEN('CODE',
267: l_msg_token,
268: FALSE);
269: RAISE loop_exception;
270: END IF;

Line 279: FND_MESSAGE.SET_NAME('GR',

275:
276: IF l_item is NULL and l_inventory_item_id is NULL then
277: GMD_API_PUB.Log_Message('GR_INVALID_ITEM');
278: l_msg_token := l_item;
279: FND_MESSAGE.SET_NAME('GR',
280: 'GR_INVALID_ITEM');
281: FND_MESSAGE.SET_TOKEN('CODE',
282: l_msg_token,FALSE);
283: RAISE loop_exception;

Line 281: FND_MESSAGE.SET_TOKEN('CODE',

277: GMD_API_PUB.Log_Message('GR_INVALID_ITEM');
278: l_msg_token := l_item;
279: FND_MESSAGE.SET_NAME('GR',
280: 'GR_INVALID_ITEM');
281: FND_MESSAGE.SET_TOKEN('CODE',
282: l_msg_token,FALSE);
283: RAISE loop_exception;
284: END IF; -- IF l_item is NULL and l_inventory_item_id is NULL then
285:

Line 294: FND_MESSAGE.SET_NAME('GR',

290: IF c_get_org_id%NOTFOUND THEN
291:
292: CLOSE c_get_item_id;
293: l_msg_token := l_item;
294: FND_MESSAGE.SET_NAME('GR',
295: 'GR_RECORD_NOT_FOUND');
296: FND_MESSAGE.SET_TOKEN('CODE',
297: l_msg_token,
298: FALSE);

Line 296: FND_MESSAGE.SET_TOKEN('CODE',

292: CLOSE c_get_item_id;
293: l_msg_token := l_item;
294: FND_MESSAGE.SET_NAME('GR',
295: 'GR_RECORD_NOT_FOUND');
296: FND_MESSAGE.SET_TOKEN('CODE',
297: l_msg_token,
298: FALSE);
299: RAISE loop_exception;
300: END IF;

Line 313: FND_MESSAGE.SET_NAME('GR',

309: IF c_hazardous_material_flag%NOTFOUND THEN
310:
311: CLOSE c_hazardous_material_flag;
312: l_msg_token := l_item;
313: FND_MESSAGE.SET_NAME('GR',
314: 'GR_NOT_REG_ITEM');
315: FND_MESSAGE.SET_TOKEN('CODE',
316: l_msg_token,
317: FALSE);

Line 315: FND_MESSAGE.SET_TOKEN('CODE',

311: CLOSE c_hazardous_material_flag;
312: l_msg_token := l_item;
313: FND_MESSAGE.SET_NAME('GR',
314: 'GR_NOT_REG_ITEM');
315: FND_MESSAGE.SET_TOKEN('CODE',
316: l_msg_token,
317: FALSE);
318: RAISE loop_exception;
319: END IF;

Line 328: FND_MESSAGE.SET_NAME('GR',

324:
325: IF l_field_name_code is NULL then
326: --GMD_API_PUB.Log_Message('GR_NULL_VALUE');
327: l_msg_token := l_field_name_code;
328: FND_MESSAGE.SET_NAME('GR',
329: 'GR_NULL_VALUE');
330: FND_MESSAGE.SET_TOKEN('CODE',
331: l_msg_token,
332: FALSE);

Line 330: FND_MESSAGE.SET_TOKEN('CODE',

326: --GMD_API_PUB.Log_Message('GR_NULL_VALUE');
327: l_msg_token := l_field_name_code;
328: FND_MESSAGE.SET_NAME('GR',
329: 'GR_NULL_VALUE');
330: FND_MESSAGE.SET_TOKEN('CODE',
331: l_msg_token,
332: FALSE);
333: RAISE loop_exception;
334: END IF;

Line 345: FND_MESSAGE.SET_NAME('GR',

341: FETCH c_get_field_name INTO dummy;
342: IF c_get_field_name%NOTFOUND THEN
343: l_msg_token := l_field_name_code;
344: CLOSE c_get_field_name;
345: FND_MESSAGE.SET_NAME('GR',
346: 'GR_RECORD_NOT_FOUND');
347: FND_MESSAGE.SET_TOKEN('CODE',
348: l_msg_token,
349: FALSE);

Line 347: FND_MESSAGE.SET_TOKEN('CODE',

343: l_msg_token := l_field_name_code;
344: CLOSE c_get_field_name;
345: FND_MESSAGE.SET_NAME('GR',
346: 'GR_RECORD_NOT_FOUND');
347: FND_MESSAGE.SET_TOKEN('CODE',
348: l_msg_token,
349: FALSE);
350: RAISE loop_exception;
351: END IF;

Line 364: FND_MESSAGE.SET_NAME('GR',

360: FETCH c_get_property_id INTO dummy;
361: IF c_get_property_id%NOTFOUND THEN
362: l_msg_token := l_property_id;
363: CLOSE c_get_property_id;
364: FND_MESSAGE.SET_NAME('GR',
365: 'GR_RECORD_NOT_FOUND');
366: FND_MESSAGE.SET_TOKEN('CODE',
367: l_msg_token,
368: FALSE);

Line 366: FND_MESSAGE.SET_TOKEN('CODE',

362: l_msg_token := l_property_id;
363: CLOSE c_get_property_id;
364: FND_MESSAGE.SET_NAME('GR',
365: 'GR_RECORD_NOT_FOUND');
366: FND_MESSAGE.SET_TOKEN('CODE',
367: l_msg_token,
368: FALSE);
369: RAISE loop_exception;
370: END IF;

Line 379: FND_MESSAGE.SET_NAME('GR','GR_RECORD_NOT_FOUND');

375: FETCH Cur_get_seq_no INTO l_sequence_number;
376: IF Cur_get_seq_no%NOTFOUND THEN
377: l_msg_token := l_field_name_code || ' ' || l_property_id;
378: CLOSE Cur_get_seq_no;
379: FND_MESSAGE.SET_NAME('GR','GR_RECORD_NOT_FOUND');
380: FND_MESSAGE.SET_TOKEN('CODE',l_msg_token,FALSE);
381: RAISE loop_exception;
382:
383: END IF;

Line 380: FND_MESSAGE.SET_TOKEN('CODE',l_msg_token,FALSE);

376: IF Cur_get_seq_no%NOTFOUND THEN
377: l_msg_token := l_field_name_code || ' ' || l_property_id;
378: CLOSE Cur_get_seq_no;
379: FND_MESSAGE.SET_NAME('GR','GR_RECORD_NOT_FOUND');
380: FND_MESSAGE.SET_TOKEN('CODE',l_msg_token,FALSE);
381: RAISE loop_exception;
382:
383: END IF;
384: CLOSE Cur_get_seq_no;

Line 397: FND_MESSAGE.SET_NAME('GR',

393: OPEN c_val_fname;
394: FETCH c_val_fname INTO l_form_block;
395: IF c_val_fname%NOTFOUND THEN
396: close c_val_fname;
397: FND_MESSAGE.SET_NAME('GR',
398: 'GR_FNAME_NOT_ASSOC_PHRASE');
399: RAISE loop_exception;
400: END IF;
401: close c_val_fname;

Line 431: FND_MESSAGE.SET_NAME('GR','GR_PROPERTY_IND_INVALID');

427: --Property Type phrase is not used anymore.
428: IF (l_property_type_indicator = 'P') THEN
429: l_alpha_value := NULL;
430: l_msg_token := ' phrase code';
431: FND_MESSAGE.SET_NAME('GR','GR_PROPERTY_IND_INVALID');
432: FND_MESSAGE.SET_TOKEN('CODE',l_msg_token,FALSE);
433: RAISE loop_exception;
434: END IF;
435:

Line 432: FND_MESSAGE.SET_TOKEN('CODE',l_msg_token,FALSE);

428: IF (l_property_type_indicator = 'P') THEN
429: l_alpha_value := NULL;
430: l_msg_token := ' phrase code';
431: FND_MESSAGE.SET_NAME('GR','GR_PROPERTY_IND_INVALID');
432: FND_MESSAGE.SET_TOKEN('CODE',l_msg_token,FALSE);
433: RAISE loop_exception;
434: END IF;
435:
436: -- If the property is of type Safety Phrase or the field name is

Line 443: FND_MESSAGE.SET_NAME('GR',

439:
440: -- If the value for Phrase Code is null, an error message will be written to the log file.
441: IF l_phrase_code is null then
442: l_msg_token := ' phrase code';
443: FND_MESSAGE.SET_NAME('GR',
444: 'GR_NULL_VALUE');
445: FND_MESSAGE.SET_TOKEN('CODE',
446: l_msg_token,
447: FALSE);

Line 445: FND_MESSAGE.SET_TOKEN('CODE',

441: IF l_phrase_code is null then
442: l_msg_token := ' phrase code';
443: FND_MESSAGE.SET_NAME('GR',
444: 'GR_NULL_VALUE');
445: FND_MESSAGE.SET_TOKEN('CODE',
446: l_msg_token,
447: FALSE);
448: RAISE loop_exception;
449: END IF; -- IF l_phrase_code is null then

Line 459: FND_MESSAGE.SET_NAME('GR','GR_RECORD_NOT_FOUND');

455: FETCH c_get_safety_phrase_code INTO l_phrase_code2;
456: IF c_get_safety_phrase_code%NOTFOUND THEN
457: l_msg_token := l_phrase_code;
458: CLOSE c_get_safety_phrase_code;
459: FND_MESSAGE.SET_NAME('GR','GR_RECORD_NOT_FOUND');
460: FND_MESSAGE.SET_TOKEN('CODE',l_msg_token,FALSE);
461: RAISE loop_exception;
462: END IF;
463: CLOSE c_get_safety_phrase_code;

Line 460: FND_MESSAGE.SET_TOKEN('CODE',l_msg_token,FALSE);

456: IF c_get_safety_phrase_code%NOTFOUND THEN
457: l_msg_token := l_phrase_code;
458: CLOSE c_get_safety_phrase_code;
459: FND_MESSAGE.SET_NAME('GR','GR_RECORD_NOT_FOUND');
460: FND_MESSAGE.SET_TOKEN('CODE',l_msg_token,FALSE);
461: RAISE loop_exception;
462: END IF;
463: CLOSE c_get_safety_phrase_code;
464: END IF; -- IF l_property_type_indicator = 'S' or l_form_block = 'SAFETY_PHRASES' and l_action = 'I' THEN

Line 473: FND_MESSAGE.SET_NAME('GR',

469:
470: -- If the value for Phrase Code is null, an error message will be written to the log file.
471: IF l_phrase_code is null then
472: l_msg_token := ' phrase code';
473: FND_MESSAGE.SET_NAME('GR',
474: 'GR_NULL_VALUE');
475: FND_MESSAGE.SET_TOKEN('CODE',
476: l_msg_token,
477: FALSE);

Line 475: FND_MESSAGE.SET_TOKEN('CODE',

471: IF l_phrase_code is null then
472: l_msg_token := ' phrase code';
473: FND_MESSAGE.SET_NAME('GR',
474: 'GR_NULL_VALUE');
475: FND_MESSAGE.SET_TOKEN('CODE',
476: l_msg_token,
477: FALSE);
478: RAISE loop_exception;
479: END IF; -- IF l_phrase_code is null then

Line 488: FND_MESSAGE.SET_NAME('GR','GR_RECORD_NOT_FOUND');

484: FETCH c_get_risk_phrase_code INTO riskcode;
485: IF c_get_risk_phrase_code%NOTFOUND THEN
486: l_msg_token := l_phrase_code;
487: CLOSE c_get_risk_phrase_code;
488: FND_MESSAGE.SET_NAME('GR','GR_RECORD_NOT_FOUND');
489: FND_MESSAGE.SET_TOKEN('CODE',l_msg_token,FALSE);
490: RAISE loop_exception;
491: END IF;
492: CLOSE c_get_risk_phrase_code;

Line 489: FND_MESSAGE.SET_TOKEN('CODE',l_msg_token,FALSE);

485: IF c_get_risk_phrase_code%NOTFOUND THEN
486: l_msg_token := l_phrase_code;
487: CLOSE c_get_risk_phrase_code;
488: FND_MESSAGE.SET_NAME('GR','GR_RECORD_NOT_FOUND');
489: FND_MESSAGE.SET_TOKEN('CODE',l_msg_token,FALSE);
490: RAISE loop_exception;
491: END IF;
492: CLOSE c_get_risk_phrase_code;
493:

Line 502: FND_MESSAGE.SET_NAME('GR',

498:
499: -- If the value for Numeric Value is null, an error message will be written to the log file.
500: IF l_numeric_value is NULL then
501: l_msg_token := ' numeric value';
502: FND_MESSAGE.SET_NAME('GR',
503: 'GR_NULL_VALUE');
504: FND_MESSAGE.SET_TOKEN('TEXT',
505: l_msg_token,
506: FALSE);

Line 504: FND_MESSAGE.SET_TOKEN('TEXT',

500: IF l_numeric_value is NULL then
501: l_msg_token := ' numeric value';
502: FND_MESSAGE.SET_NAME('GR',
503: 'GR_NULL_VALUE');
504: FND_MESSAGE.SET_TOKEN('TEXT',
505: l_msg_token,
506: FALSE);
507: RAISE loop_exception;
508: END IF; -- IF l_numeric_value is NULL then

Line 516: FND_MESSAGE.SET_NAME('GR',

512: -- Validate the value for Alphanumeric Value against the property definition in the GR_PROPERTIES_B table.
513: -- Just the length An error message will be written to the log file if the value is invalid
514: IF (length(l_numeric_value) > l_length ) then
515: --l_msg_token := l_length;
516: FND_MESSAGE.SET_NAME('GR',
517: 'GR_LENGTH_INVALID');
518: FND_MESSAGE.SET_TOKEN('LENGTH', l_length);
519:
520: RAISE loop_exception;

Line 518: FND_MESSAGE.SET_TOKEN('LENGTH', l_length);

514: IF (length(l_numeric_value) > l_length ) then
515: --l_msg_token := l_length;
516: FND_MESSAGE.SET_NAME('GR',
517: 'GR_LENGTH_INVALID');
518: FND_MESSAGE.SET_TOKEN('LENGTH', l_length);
519:
520: RAISE loop_exception;
521: END IF; -- IF (length(l_numeric_value) > l_length ) then
522:

Line 525: FND_MESSAGE.SET_NAME('GR',

521: END IF; -- IF (length(l_numeric_value) > l_length ) then
522:
523:
524: IF l_numeric_value > l_range_max or l_numeric_value < l_range_min then
525: FND_MESSAGE.SET_NAME('GR',
526: 'GR_MIN_MAX_ERROR');
527: RAISE loop_exception;
528: END IF; -- IF l_numeric_value > l_range_max or l_numeric_value < l_range_min then
529:

Line 535: FND_MESSAGE.SET_NAME('GR',

531: l_calc_precision := (length(l_numeric_value - trunc(l_numeric_value))) - 1;
532: -- IF l_calc_precision <> l_precision THEN -- 01/15/09 7709185 replace with below
533: IF l_calc_precision > l_precision or l_calc_precision > 6 -- 8208515 table only will store up to 6 dec. places
534: THEN -- 01/15/09 7709185
535: FND_MESSAGE.SET_NAME('GR',
536: 'GR_PRECISION_INVALID');
537: RAISE loop_exception;
538: END IF; -- IF l_calc_precision <> l_precision THEN
539:

Line 544: FND_MESSAGE.SET_NAME('GR',

540: ELSIF l_property_type_indicator = 'A' then
541: -- If the value for Alphanumeric Value is null, an error message will be written to the log file
542: IF l_alpha_value is NULL then
543: l_msg_token := ' alphanumeric value';
544: FND_MESSAGE.SET_NAME('GR',
545: 'GR_NULL_VALUE');
546: FND_MESSAGE.SET_TOKEN('CODE',
547: l_msg_token,
548: FALSE);

Line 546: FND_MESSAGE.SET_TOKEN('CODE',

542: IF l_alpha_value is NULL then
543: l_msg_token := ' alphanumeric value';
544: FND_MESSAGE.SET_NAME('GR',
545: 'GR_NULL_VALUE');
546: FND_MESSAGE.SET_TOKEN('CODE',
547: l_msg_token,
548: FALSE);
549: RAISE loop_exception;
550: END IF; -- IF l_alpha_value is NULL then

Line 556: FND_MESSAGE.SET_NAME('GR',

552: -- Validate the value for Alphanumeric Value against the property definition in the GR_PROPERTIES_B table.
553: -- Just the length An error message will be written to the log file if the value is invalid
554: IF (length(l_alpha_value) > l_length ) then --
555: l_msg_token := (length(l_alpha_value));
556: FND_MESSAGE.SET_NAME('GR',
557: 'GR_LENGTH_INVALID');
558: FND_MESSAGE.SET_TOKEN('LENGTH', l_length);
559:
560: RAISE loop_exception;

Line 558: FND_MESSAGE.SET_TOKEN('LENGTH', l_length);

554: IF (length(l_alpha_value) > l_length ) then --
555: l_msg_token := (length(l_alpha_value));
556: FND_MESSAGE.SET_NAME('GR',
557: 'GR_LENGTH_INVALID');
558: FND_MESSAGE.SET_TOKEN('LENGTH', l_length);
559:
560: RAISE loop_exception;
561: END IF; -- IF (length(l_alpha_value) > l_length ) then
562:

Line 569: FND_MESSAGE.SET_NAME('GR',

565: -- If the value for date Value is null, an error message will be written to the log file
566:
567: IF p_item_properties_tab(i).date_value is NULL then
568: l_msg_token := ' date value';
569: FND_MESSAGE.SET_NAME('GR',
570: 'GR_NULL_VALUE');
571: FND_MESSAGE.SET_TOKEN('CODE',
572: l_msg_token,
573: FALSE);

Line 571: FND_MESSAGE.SET_TOKEN('CODE',

567: IF p_item_properties_tab(i).date_value is NULL then
568: l_msg_token := ' date value';
569: FND_MESSAGE.SET_NAME('GR',
570: 'GR_NULL_VALUE');
571: FND_MESSAGE.SET_TOKEN('CODE',
572: l_msg_token,
573: FALSE);
574: RAISE loop_exception;
575: END IF; -- IF l_date_value is NULL then

Line 585: FND_MESSAGE.SET_NAME('GMA',

581: l_date_value := p_item_properties_tab(i).date_value;
582:
583: exception
584: when others then
585: FND_MESSAGE.SET_NAME('GMA',
586: 'SY_BAD_DATEFORMAT');
587: RAISE loop_exception;
588: end;
589:

Line 595: FND_MESSAGE.SET_NAME('GR',

591:
592: -- If the value for alphanumeric Value is null, an error message will be written to the log file
593: IF l_alpha_value is NULL then
594: l_msg_token := ' alphanumeric value';
595: FND_MESSAGE.SET_NAME('GR',
596: 'GR_NULL_VALUE');
597: FND_MESSAGE.SET_TOKEN('CODE',
598: l_msg_token,
599: FALSE);

Line 597: FND_MESSAGE.SET_TOKEN('CODE',

593: IF l_alpha_value is NULL then
594: l_msg_token := ' alphanumeric value';
595: FND_MESSAGE.SET_NAME('GR',
596: 'GR_NULL_VALUE');
597: FND_MESSAGE.SET_TOKEN('CODE',
598: l_msg_token,
599: FALSE);
600: RAISE loop_exception;
601: END IF; -- IF l_alpha_value is NULL then

Line 608: FND_MESSAGE.SET_NAME('GR',

604: OPEN c_get_PROPERTY_values;
605: FETCH c_get_PROPERTY_values INTO dummy;
606: IF c_get_PROPERTY_values%NOTFOUND THEN
607: close c_get_PROPERTY_values;
608: FND_MESSAGE.SET_NAME('GR',
609: 'GR_ALPHA_INVALID');
610: FND_MSG_PUB.ADD;
611: RAISE loop_exception;
612: END IF;

Line 644: FND_MESSAGE.SET_NAME('GR','GR_RECORD_NOT_FOUND');

640: FETCH c_get_safety_phrase_code INTO l_phrase_code2;
641: IF c_get_safety_phrase_code%NOTFOUND THEN
642: l_msg_token := l_phrase_code;
643: CLOSE c_get_safety_phrase_code;
644: FND_MESSAGE.SET_NAME('GR','GR_RECORD_NOT_FOUND');
645: FND_MESSAGE.SET_TOKEN('CODE',l_msg_token,FALSE);
646: RAISE loop_exception;
647: END IF;
648: CLOSE c_get_safety_phrase_code;

Line 645: FND_MESSAGE.SET_TOKEN('CODE',l_msg_token,FALSE);

641: IF c_get_safety_phrase_code%NOTFOUND THEN
642: l_msg_token := l_phrase_code;
643: CLOSE c_get_safety_phrase_code;
644: FND_MESSAGE.SET_NAME('GR','GR_RECORD_NOT_FOUND');
645: FND_MESSAGE.SET_TOKEN('CODE',l_msg_token,FALSE);
646: RAISE loop_exception;
647: END IF;
648: CLOSE c_get_safety_phrase_code;
649:

Line 656: FND_MESSAGE.SET_NAME('GR',

652: IF c_get_item_safety_phrase%FOUND THEN
653:
654: CLOSE c_get_item_safety_phrase;
655: l_msg_token := l_phrase_code;
656: FND_MESSAGE.SET_NAME('GR',
657: 'GR_RECORD_EXISTS');
658: FND_MESSAGE.SET_TOKEN('CODE',
659: l_msg_token,
660: FALSE);

Line 658: FND_MESSAGE.SET_TOKEN('CODE',

654: CLOSE c_get_item_safety_phrase;
655: l_msg_token := l_phrase_code;
656: FND_MESSAGE.SET_NAME('GR',
657: 'GR_RECORD_EXISTS');
658: FND_MESSAGE.SET_TOKEN('CODE',
659: l_msg_token,
660: FALSE);
661: RAISE loop_exception;
662: END IF;

Line 694: FND_MESSAGE.SET_NAME('GR','GR_RECORD_NOT_FOUND');

690: FETCH c_get_risk_phrase_code INTO riskcode;
691: IF c_get_risk_phrase_code%NOTFOUND THEN
692: l_msg_token := l_phrase_code;
693: CLOSE c_get_risk_phrase_code;
694: FND_MESSAGE.SET_NAME('GR','GR_RECORD_NOT_FOUND');
695: FND_MESSAGE.SET_TOKEN('CODE',l_msg_token,FALSE);
696: RAISE loop_exception;
697: END IF;
698: CLOSE c_get_risk_phrase_code;

Line 695: FND_MESSAGE.SET_TOKEN('CODE',l_msg_token,FALSE);

691: IF c_get_risk_phrase_code%NOTFOUND THEN
692: l_msg_token := l_phrase_code;
693: CLOSE c_get_risk_phrase_code;
694: FND_MESSAGE.SET_NAME('GR','GR_RECORD_NOT_FOUND');
695: FND_MESSAGE.SET_TOKEN('CODE',l_msg_token,FALSE);
696: RAISE loop_exception;
697: END IF;
698: CLOSE c_get_risk_phrase_code;
699:

Line 709: FND_MESSAGE.SET_NAME('GR',

705: FETCH c_get_item_risk_phrase INTO l_phrase_code2;
706: IF c_get_item_risk_phrase%FOUND THEN
707: CLOSE c_get_item_risk_phrase;
708: l_msg_token := l_phrase_code;
709: FND_MESSAGE.SET_NAME('GR',
710: 'GR_RECORD_EXISTS');
711: FND_MESSAGE.SET_TOKEN('CODE',
712: l_msg_token,
713: FALSE);

Line 711: FND_MESSAGE.SET_TOKEN('CODE',

707: CLOSE c_get_item_risk_phrase;
708: l_msg_token := l_phrase_code;
709: FND_MESSAGE.SET_NAME('GR',
710: 'GR_RECORD_EXISTS');
711: FND_MESSAGE.SET_TOKEN('CODE',
712: l_msg_token,
713: FALSE);
714: RAISE loop_exception;
715: END IF;

Line 751: FND_MESSAGE.SET_NAME('GR','GR_RECORD_NOT_FOUND');

747: FETCH Cur_get_seq_no INTO l_sequence_number;
748: IF Cur_get_seq_no%NOTFOUND THEN
749: l_msg_token := l_field_name_code || ' ' || l_property_id;
750: CLOSE Cur_get_seq_no;
751: FND_MESSAGE.SET_NAME('GR','GR_RECORD_NOT_FOUND');
752: FND_MESSAGE.SET_TOKEN('CODE',l_msg_token,FALSE);
753: RAISE loop_exception;
754: END IF;
755: CLOSE Cur_get_seq_no;

Line 752: FND_MESSAGE.SET_TOKEN('CODE',l_msg_token,FALSE);

748: IF Cur_get_seq_no%NOTFOUND THEN
749: l_msg_token := l_field_name_code || ' ' || l_property_id;
750: CLOSE Cur_get_seq_no;
751: FND_MESSAGE.SET_NAME('GR','GR_RECORD_NOT_FOUND');
752: FND_MESSAGE.SET_TOKEN('CODE',l_msg_token,FALSE);
753: RAISE loop_exception;
754: END IF;
755: CLOSE Cur_get_seq_no;
756: END IF; -- IF l_property_id is not null then

Line 785: FND_MESSAGE.SET_NAME('GR',

781: IF return_status <> 'S' THEN
782:
783: l_oracle_error := APP_EXCEPTION.Get_Code;
784: l_code_block := l_code_block || ' ' || TO_CHAR(l_oracle_error);
785: FND_MESSAGE.SET_NAME('GR',
786: 'GR_NO_RECORD_INSERTED');
787: FND_MESSAGE.SET_TOKEN('CODE',
788: l_code_block,
789: FALSE);

Line 787: FND_MESSAGE.SET_TOKEN('CODE',

783: l_oracle_error := APP_EXCEPTION.Get_Code;
784: l_code_block := l_code_block || ' ' || TO_CHAR(l_oracle_error);
785: FND_MESSAGE.SET_NAME('GR',
786: 'GR_NO_RECORD_INSERTED');
787: FND_MESSAGE.SET_TOKEN('CODE',
788: l_code_block,
789: FALSE);
790: APP_EXCEPTION.Raise_Exception;
791:

Line 818: FND_MESSAGE.SET_NAME('GR',

814: inventory_item_id = l_inventory_item_id
815: and label_code = l_field_name_code
816: and property_id = l_property_id;
817: IF SQL%NOTFOUND THEN
818: FND_MESSAGE.SET_NAME('GR',
819: 'GR_RECORD_NOT_FOUND');
820: FND_MESSAGE.SET_TOKEN('CODE',
821: l_msg_token,
822: FALSE);

Line 820: FND_MESSAGE.SET_TOKEN('CODE',

816: and property_id = l_property_id;
817: IF SQL%NOTFOUND THEN
818: FND_MESSAGE.SET_NAME('GR',
819: 'GR_RECORD_NOT_FOUND');
820: FND_MESSAGE.SET_TOKEN('CODE',
821: l_msg_token,
822: FALSE);
823: l_msg_token := l_organization_id || ' ' || l_inventory_item_id || ' ' || l_phrase_code;
824: RAISE loop_exception;

Line 854: FND_MESSAGE.SET_NAME('GR','GR_RECORD_NOT_FOUND');

850: FETCH c_get_item_safety_phrase INTO l_phrase_code2;
851: IF c_get_item_safety_phrase%NOTFOUND THEN
852: CLOSE c_get_item_safety_phrase;
853: l_msg_token := l_phrase_code;
854: FND_MESSAGE.SET_NAME('GR','GR_RECORD_NOT_FOUND');
855: FND_MESSAGE.SET_TOKEN('CODE',l_msg_token,FALSE);
856: RAISE loop_exception;
857: END IF;
858: CLOSE c_get_item_safety_phrase;

Line 855: FND_MESSAGE.SET_TOKEN('CODE',l_msg_token,FALSE);

851: IF c_get_item_safety_phrase%NOTFOUND THEN
852: CLOSE c_get_item_safety_phrase;
853: l_msg_token := l_phrase_code;
854: FND_MESSAGE.SET_NAME('GR','GR_RECORD_NOT_FOUND');
855: FND_MESSAGE.SET_TOKEN('CODE',l_msg_token,FALSE);
856: RAISE loop_exception;
857: END IF;
858: CLOSE c_get_item_safety_phrase;
859:

Line 866: FND_MESSAGE.SET_NAME('GR',

862: inventory_item_id = l_inventory_item_id
863: and safety_phrase_code = l_phrase_code;
864: IF SQL%NOTFOUND THEN
865:
866: FND_MESSAGE.SET_NAME('GR',
867: 'GR_RECORD_NOT_FOUND');
868: FND_MESSAGE.SET_TOKEN('CODE',
869: l_msg_token,
870: FALSE);

Line 868: FND_MESSAGE.SET_TOKEN('CODE',

864: IF SQL%NOTFOUND THEN
865:
866: FND_MESSAGE.SET_NAME('GR',
867: 'GR_RECORD_NOT_FOUND');
868: FND_MESSAGE.SET_TOKEN('CODE',
869: l_msg_token,
870: FALSE);
871: l_msg_token := l_organization_id || ' ' || l_inventory_item_id || ' ' || l_phrase_code;
872:

Line 887: FND_MESSAGE.SET_NAME('GR','GR_RECORD_NOT_FOUND');

883: FETCH c_get_item_risk_phrase INTO l_phrase_code2;
884: IF c_get_item_risk_phrase%NOTFOUND THEN
885: CLOSE c_get_item_risk_phrase;
886: l_msg_token := l_phrase_code;
887: FND_MESSAGE.SET_NAME('GR','GR_RECORD_NOT_FOUND');
888: FND_MESSAGE.SET_TOKEN('CODE',l_msg_token,FALSE);
889: RAISE loop_exception;
890: END IF;
891: CLOSE c_get_item_risk_phrase;

Line 888: FND_MESSAGE.SET_TOKEN('CODE',l_msg_token,FALSE);

884: IF c_get_item_risk_phrase%NOTFOUND THEN
885: CLOSE c_get_item_risk_phrase;
886: l_msg_token := l_phrase_code;
887: FND_MESSAGE.SET_NAME('GR','GR_RECORD_NOT_FOUND');
888: FND_MESSAGE.SET_TOKEN('CODE',l_msg_token,FALSE);
889: RAISE loop_exception;
890: END IF;
891: CLOSE c_get_item_risk_phrase;
892:

Line 898: FND_MESSAGE.SET_NAME('GR',

894: WHERE organization_id = l_organization_id and
895: inventory_item_id = l_inventory_item_id
896: and risk_phrase_code = l_phrase_code;
897: IF SQL%NOTFOUND THEN
898: FND_MESSAGE.SET_NAME('GR',
899: 'GR_RECORD_NOT_FOUND');
900: FND_MESSAGE.SET_TOKEN('CODE',
901: l_msg_token,
902: FALSE);

Line 900: FND_MESSAGE.SET_TOKEN('CODE',

896: and risk_phrase_code = l_phrase_code;
897: IF SQL%NOTFOUND THEN
898: FND_MESSAGE.SET_NAME('GR',
899: 'GR_RECORD_NOT_FOUND');
900: FND_MESSAGE.SET_TOKEN('CODE',
901: l_msg_token,
902: FALSE);
903: l_msg_token := l_organization_id || ' ' || l_inventory_item_id || ' ' || l_phrase_code;
904: RAISE loop_exception;

Line 928: FND_MESSAGE.SET_NAME('GR',

924: IF return_status <> 'S' THEN
925:
926: l_oracle_error := APP_EXCEPTION.Get_Code;
927: l_code_block := l_code_block || ' ' || TO_CHAR(l_oracle_error);
928: FND_MESSAGE.SET_NAME('GR',
929: 'GR_NO_RECORD_INSERTED');
930: FND_MESSAGE.SET_TOKEN('CODE',
931: l_code_block,
932: FALSE);

Line 930: FND_MESSAGE.SET_TOKEN('CODE',

926: l_oracle_error := APP_EXCEPTION.Get_Code;
927: l_code_block := l_code_block || ' ' || TO_CHAR(l_oracle_error);
928: FND_MESSAGE.SET_NAME('GR',
929: 'GR_NO_RECORD_INSERTED');
930: FND_MESSAGE.SET_TOKEN('CODE',
931: l_code_block,
932: FALSE);
933: APP_EXCEPTION.Raise_Exception;
934:

Line 958: FND_MESSAGE.SET_NAME('GR',

954: gmi_reservation_util.println('- entering when others ');
955: x_return_status := 'U';
956: oracle_error := SQLCODE;
957: x_msg_data := SUBSTR(SQLERRM, 1, 200);
958: FND_MESSAGE.SET_NAME('GR',
959: 'GR_UNEXPECTED_ERROR');
960: FND_MESSAGE.SET_TOKEN('TEXT',
961: l_msg_token,
962: FALSE);

Line 960: FND_MESSAGE.SET_TOKEN('TEXT',

956: oracle_error := SQLCODE;
957: x_msg_data := SUBSTR(SQLERRM, 1, 200);
958: FND_MESSAGE.SET_NAME('GR',
959: 'GR_UNEXPECTED_ERROR');
960: FND_MESSAGE.SET_TOKEN('TEXT',
961: l_msg_token,
962: FALSE);
963: FND_MSG_PUB.ADD;
964: x_msg_data := FND_MESSAGE.Get;

Line 964: x_msg_data := FND_MESSAGE.Get;

960: FND_MESSAGE.SET_TOKEN('TEXT',
961: l_msg_token,
962: FALSE);
963: FND_MSG_PUB.ADD;
964: x_msg_data := FND_MESSAGE.Get;
965:
966: END;
967:
968: END LOOP; -- FOR i IN 1 .. p_item_properties_tab.count LOOP