DBA Data[Home] [Help]

APPS.RRS_SITE_UTILS dependencies on FND_MESSAGE

Line 506: FND_MESSAGE.SET_NAME('RRS','RRS_UPD_LOC_FAILED');

502:
503: if sql%rowcount = 0 THEN
504: x_return_status := 'E';
505: x_msg_count := 1;
506: FND_MESSAGE.SET_NAME('RRS','RRS_UPD_LOC_FAILED');
507: FND_MESSAGE.SET_TOKEN('LOCATION_ID',p_loc_id);
508: x_msg_data := FND_MESSAGE.GET;
509: END IF;
510:

Line 507: FND_MESSAGE.SET_TOKEN('LOCATION_ID',p_loc_id);

503: if sql%rowcount = 0 THEN
504: x_return_status := 'E';
505: x_msg_count := 1;
506: FND_MESSAGE.SET_NAME('RRS','RRS_UPD_LOC_FAILED');
507: FND_MESSAGE.SET_TOKEN('LOCATION_ID',p_loc_id);
508: x_msg_data := FND_MESSAGE.GET;
509: END IF;
510:
511: EXCEPTION

Line 508: x_msg_data := FND_MESSAGE.GET;

504: x_return_status := 'E';
505: x_msg_count := 1;
506: FND_MESSAGE.SET_NAME('RRS','RRS_UPD_LOC_FAILED');
507: FND_MESSAGE.SET_TOKEN('LOCATION_ID',p_loc_id);
508: x_msg_data := FND_MESSAGE.GET;
509: END IF;
510:
511: EXCEPTION
512: when others then

Line 555: FND_MESSAGE.SET_NAME('RRS','RRS_INVALID_OBJ_VALUE');

551:
552: IF (sql%rowcount = 0) THEN
553: x_return_status := 'E';
554: x_msg_count := 1;
555: FND_MESSAGE.SET_NAME('RRS','RRS_INVALID_OBJ_VALUE');
556: FND_MESSAGE.SET_TOKEN('OBJECT_NAME','LOCATION');
557: FND_MESSAGE.SET_TOKEN('OBJECT_VALUE',p_loc_id);
558: x_msg_data := FND_MESSAGE.GET;
559: END IF;

Line 556: FND_MESSAGE.SET_TOKEN('OBJECT_NAME','LOCATION');

552: IF (sql%rowcount = 0) THEN
553: x_return_status := 'E';
554: x_msg_count := 1;
555: FND_MESSAGE.SET_NAME('RRS','RRS_INVALID_OBJ_VALUE');
556: FND_MESSAGE.SET_TOKEN('OBJECT_NAME','LOCATION');
557: FND_MESSAGE.SET_TOKEN('OBJECT_VALUE',p_loc_id);
558: x_msg_data := FND_MESSAGE.GET;
559: END IF;
560:

Line 557: FND_MESSAGE.SET_TOKEN('OBJECT_VALUE',p_loc_id);

553: x_return_status := 'E';
554: x_msg_count := 1;
555: FND_MESSAGE.SET_NAME('RRS','RRS_INVALID_OBJ_VALUE');
556: FND_MESSAGE.SET_TOKEN('OBJECT_NAME','LOCATION');
557: FND_MESSAGE.SET_TOKEN('OBJECT_VALUE',p_loc_id);
558: x_msg_data := FND_MESSAGE.GET;
559: END IF;
560:
561: IF x_latitude IS NULL THEN

Line 558: x_msg_data := FND_MESSAGE.GET;

554: x_msg_count := 1;
555: FND_MESSAGE.SET_NAME('RRS','RRS_INVALID_OBJ_VALUE');
556: FND_MESSAGE.SET_TOKEN('OBJECT_NAME','LOCATION');
557: FND_MESSAGE.SET_TOKEN('OBJECT_VALUE',p_loc_id);
558: x_msg_data := FND_MESSAGE.GET;
559: END IF;
560:
561: IF x_latitude IS NULL THEN
562: x_null_flag := 'T';

Line 604: FND_MESSAGE.SET_NAME('RRS','RRS_INVALID_OBJ_VALUE');

600:
601: IF (sql%rowcount = 0) THEN
602: x_return_status := 'E';
603: x_msg_count := 1;
604: FND_MESSAGE.SET_NAME('RRS','RRS_INVALID_OBJ_VALUE');
605: FND_MESSAGE.SET_TOKEN('OBJECT_NAME','LOCATION');
606: FND_MESSAGE.SET_TOKEN('OBJECT_VALUE',p_loc_id);
607: x_msg_data := FND_MESSAGE.GET;
608: ELSE

Line 605: FND_MESSAGE.SET_TOKEN('OBJECT_NAME','LOCATION');

601: IF (sql%rowcount = 0) THEN
602: x_return_status := 'E';
603: x_msg_count := 1;
604: FND_MESSAGE.SET_NAME('RRS','RRS_INVALID_OBJ_VALUE');
605: FND_MESSAGE.SET_TOKEN('OBJECT_NAME','LOCATION');
606: FND_MESSAGE.SET_TOKEN('OBJECT_VALUE',p_loc_id);
607: x_msg_data := FND_MESSAGE.GET;
608: ELSE
609:

Line 606: FND_MESSAGE.SET_TOKEN('OBJECT_VALUE',p_loc_id);

602: x_return_status := 'E';
603: x_msg_count := 1;
604: FND_MESSAGE.SET_NAME('RRS','RRS_INVALID_OBJ_VALUE');
605: FND_MESSAGE.SET_TOKEN('OBJECT_NAME','LOCATION');
606: FND_MESSAGE.SET_TOKEN('OBJECT_VALUE',p_loc_id);
607: x_msg_data := FND_MESSAGE.GET;
608: ELSE
609:
610: UPDATE hz_locations

Line 607: x_msg_data := FND_MESSAGE.GET;

603: x_msg_count := 1;
604: FND_MESSAGE.SET_NAME('RRS','RRS_INVALID_OBJ_VALUE');
605: FND_MESSAGE.SET_TOKEN('OBJECT_NAME','LOCATION');
606: FND_MESSAGE.SET_TOKEN('OBJECT_VALUE',p_loc_id);
607: x_msg_data := FND_MESSAGE.GET;
608: ELSE
609:
610: UPDATE hz_locations
611: SET geometry_source = l_default_geosource