DBA Data[Home] [Help]

APPS.PSB_HR_EXTRACT_DATA_PVT dependencies on FND_MESSAGE

Line 610: l_msg := FND_MESSAGE.Get;

606:
607: tf := FND_FLEX_EXT.GET_SEGMENTS('PER', 'POS', l_pos_id_flex_num, position_rec.position_definition_id, nsegs, segs);
608: if (tf = FALSE) then
609:
610: l_msg := FND_MESSAGE.Get;
611: FND_FILE.put_line(FND_FILE.LOG,'Invalid Segments HRMS Position: '||
612: position_rec.position_id);
613: FND_FILE.put_line(FND_FILE.LOG,l_msg);
614: FND_MESSAGE.SET_NAME('PSB','PSB_POS_DEFN_VALUE_ERROR');

Line 614: FND_MESSAGE.SET_NAME('PSB','PSB_POS_DEFN_VALUE_ERROR');

610: l_msg := FND_MESSAGE.Get;
611: FND_FILE.put_line(FND_FILE.LOG,'Invalid Segments HRMS Position: '||
612: position_rec.position_id);
613: FND_FILE.put_line(FND_FILE.LOG,l_msg);
614: FND_MESSAGE.SET_NAME('PSB','PSB_POS_DEFN_VALUE_ERROR');
615: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );
616: FND_MESSAGE.SET_TOKEN('ERR_MESG',l_msg);
617: FND_MSG_PUB.Add;
618: end if;

Line 615: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );

611: FND_FILE.put_line(FND_FILE.LOG,'Invalid Segments HRMS Position: '||
612: position_rec.position_id);
613: FND_FILE.put_line(FND_FILE.LOG,l_msg);
614: FND_MESSAGE.SET_NAME('PSB','PSB_POS_DEFN_VALUE_ERROR');
615: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );
616: FND_MESSAGE.SET_TOKEN('ERR_MESG',l_msg);
617: FND_MSG_PUB.Add;
618: end if;
619:

Line 616: FND_MESSAGE.SET_TOKEN('ERR_MESG',l_msg);

612: position_rec.position_id);
613: FND_FILE.put_line(FND_FILE.LOG,l_msg);
614: FND_MESSAGE.SET_NAME('PSB','PSB_POS_DEFN_VALUE_ERROR');
615: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );
616: FND_MESSAGE.SET_TOKEN('ERR_MESG',l_msg);
617: FND_MSG_PUB.Add;
618: end if;
619:
620: l_per_index := 1;

Line 3946: FND_MESSAGE.SET_NAME('PSB', 'PSB_ATTRIBUTE_VALUE_DATE_ERR');

3942: begin
3943: l_description := Fnd_Date.Date_to_Canonical(l_description);
3944: exception
3945: when OTHERS then
3946: FND_MESSAGE.SET_NAME('PSB', 'PSB_ATTRIBUTE_VALUE_DATE_ERR');
3947: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);
3948: l_message_text := fnd_message.get;
3949: RAISE_APPLICATION_ERROR(-20001,l_message_text);
3950: end;

Line 3947: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);

3943: l_description := Fnd_Date.Date_to_Canonical(l_description);
3944: exception
3945: when OTHERS then
3946: FND_MESSAGE.SET_NAME('PSB', 'PSB_ATTRIBUTE_VALUE_DATE_ERR');
3947: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);
3948: l_message_text := fnd_message.get;
3949: RAISE_APPLICATION_ERROR(-20001,l_message_text);
3950: end;
3951: end if;

Line 3948: l_message_text := fnd_message.get;

3944: exception
3945: when OTHERS then
3946: FND_MESSAGE.SET_NAME('PSB', 'PSB_ATTRIBUTE_VALUE_DATE_ERR');
3947: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);
3948: l_message_text := fnd_message.get;
3949: RAISE_APPLICATION_ERROR(-20001,l_message_text);
3950: end;
3951: end if;
3952:

Line 4034: FND_MESSAGE.SET_NAME('PSB', 'PSB_ATTRIBUTE_VALUE_NUMBER_ERR');

4030: exception
4031: when INVALID_NUMBER then
4032:
4033: -- Changed the exception part for Bug #4658351
4034: FND_MESSAGE.SET_NAME('PSB', 'PSB_ATTRIBUTE_VALUE_NUMBER_ERR');
4035: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);
4036: l_message_text := fnd_message.get;
4037: RAISE_APPLICATION_ERROR(-20000,l_message_text);
4038:

Line 4035: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);

4031: when INVALID_NUMBER then
4032:
4033: -- Changed the exception part for Bug #4658351
4034: FND_MESSAGE.SET_NAME('PSB', 'PSB_ATTRIBUTE_VALUE_NUMBER_ERR');
4035: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);
4036: l_message_text := fnd_message.get;
4037: RAISE_APPLICATION_ERROR(-20000,l_message_text);
4038:
4039: end;

Line 4036: l_message_text := fnd_message.get;

4032:
4033: -- Changed the exception part for Bug #4658351
4034: FND_MESSAGE.SET_NAME('PSB', 'PSB_ATTRIBUTE_VALUE_NUMBER_ERR');
4035: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);
4036: l_message_text := fnd_message.get;
4037: RAISE_APPLICATION_ERROR(-20000,l_message_text);
4038:
4039: end;
4040: elsif (attribute_rec.data_type = 'D') then

Line 4048: FND_MESSAGE.SET_NAME('PSB', 'PSB_ATTRIBUTE_VALUE_DATE_ERR');

4044: exception
4045: when OTHERS then -- Bug #4658351: Changed VALUE_ERROR to OTHERS
4046:
4047: -- Changed the exception part for Bug #4658351
4048: FND_MESSAGE.SET_NAME('PSB', 'PSB_ATTRIBUTE_VALUE_DATE_ERR');
4049: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);
4050: l_message_text := fnd_message.get;
4051: RAISE_APPLICATION_ERROR(-20001,l_message_text);
4052:

Line 4049: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);

4045: when OTHERS then -- Bug #4658351: Changed VALUE_ERROR to OTHERS
4046:
4047: -- Changed the exception part for Bug #4658351
4048: FND_MESSAGE.SET_NAME('PSB', 'PSB_ATTRIBUTE_VALUE_DATE_ERR');
4049: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);
4050: l_message_text := fnd_message.get;
4051: RAISE_APPLICATION_ERROR(-20001,l_message_text);
4052:
4053: end;

Line 4050: l_message_text := fnd_message.get;

4046:
4047: -- Changed the exception part for Bug #4658351
4048: FND_MESSAGE.SET_NAME('PSB', 'PSB_ATTRIBUTE_VALUE_DATE_ERR');
4049: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);
4050: l_message_text := fnd_message.get;
4051: RAISE_APPLICATION_ERROR(-20001,l_message_text);
4052:
4053: end;
4054: end if;

Line 5204: FND_MESSAGE.SET_NAME('PSB','PSB_ATTR_MAPPING_NOT_FOUND');

5200: end loop;
5201:
5202: /* Start bug #4302946 */
5203: IF (l_attr_link_type IS NULL) THEN
5204: FND_MESSAGE.SET_NAME('PSB','PSB_ATTR_MAPPING_NOT_FOUND');
5205: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);
5206: l_message_text := FND_MESSAGE.GET;
5207: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message_text);
5208: RAISE FND_API.G_EXC_ERROR;

Line 5205: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);

5201:
5202: /* Start bug #4302946 */
5203: IF (l_attr_link_type IS NULL) THEN
5204: FND_MESSAGE.SET_NAME('PSB','PSB_ATTR_MAPPING_NOT_FOUND');
5205: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);
5206: l_message_text := FND_MESSAGE.GET;
5207: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message_text);
5208: RAISE FND_API.G_EXC_ERROR;
5209: END IF;

Line 5206: l_message_text := FND_MESSAGE.GET;

5202: /* Start bug #4302946 */
5203: IF (l_attr_link_type IS NULL) THEN
5204: FND_MESSAGE.SET_NAME('PSB','PSB_ATTR_MAPPING_NOT_FOUND');
5205: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);
5206: l_message_text := FND_MESSAGE.GET;
5207: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message_text);
5208: RAISE FND_API.G_EXC_ERROR;
5209: END IF;
5210: /* End bug #4302946 */

Line 5347: FND_MESSAGE.SET_NAME('PSB','PSB_ATTR_MAPPING_NOT_FOUND');

5343: end loop;
5344:
5345: /* Start bug #4302946 */
5346: IF (l_attr_link_type IS NULL) THEN
5347: FND_MESSAGE.SET_NAME('PSB','PSB_ATTR_MAPPING_NOT_FOUND');
5348: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);
5349: l_message_text := FND_MESSAGE.GET;
5350: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message_text);
5351: RAISE FND_API.G_EXC_ERROR;

Line 5348: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);

5344:
5345: /* Start bug #4302946 */
5346: IF (l_attr_link_type IS NULL) THEN
5347: FND_MESSAGE.SET_NAME('PSB','PSB_ATTR_MAPPING_NOT_FOUND');
5348: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);
5349: l_message_text := FND_MESSAGE.GET;
5350: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message_text);
5351: RAISE FND_API.G_EXC_ERROR;
5352: END IF;

Line 5349: l_message_text := FND_MESSAGE.GET;

5345: /* Start bug #4302946 */
5346: IF (l_attr_link_type IS NULL) THEN
5347: FND_MESSAGE.SET_NAME('PSB','PSB_ATTR_MAPPING_NOT_FOUND');
5348: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);
5349: l_message_text := FND_MESSAGE.GET;
5350: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message_text);
5351: RAISE FND_API.G_EXC_ERROR;
5352: END IF;
5353: /* End bug #4302946 */

Line 5400: FND_MESSAGE.SET_NAME('PSB', 'PSB_ATTRIBUTE_VALUE_DATE_ERR');

5396: begin
5397: v_qsegment := Fnd_Date.Date_to_Canonical(v_qsegment);
5398: exception
5399: when OTHERS then
5400: FND_MESSAGE.SET_NAME('PSB', 'PSB_ATTRIBUTE_VALUE_DATE_ERR');
5401: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);
5402: l_message_text := fnd_message.get;
5403: RAISE_APPLICATION_ERROR(-20001,l_message_text);
5404: end;

Line 5401: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);

5397: v_qsegment := Fnd_Date.Date_to_Canonical(v_qsegment);
5398: exception
5399: when OTHERS then
5400: FND_MESSAGE.SET_NAME('PSB', 'PSB_ATTRIBUTE_VALUE_DATE_ERR');
5401: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);
5402: l_message_text := fnd_message.get;
5403: RAISE_APPLICATION_ERROR(-20001,l_message_text);
5404: end;
5405: end if;

Line 5402: l_message_text := fnd_message.get;

5398: exception
5399: when OTHERS then
5400: FND_MESSAGE.SET_NAME('PSB', 'PSB_ATTRIBUTE_VALUE_DATE_ERR');
5401: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);
5402: l_message_text := fnd_message.get;
5403: RAISE_APPLICATION_ERROR(-20001,l_message_text);
5404: end;
5405: end if;
5406:

Line 5513: FND_MESSAGE.SET_NAME('PSB','PSB_ATTR_MAPPING_NOT_FOUND');

5509: end loop;
5510:
5511: /* Start bug #4302946 */
5512: IF (l_attr_link_type IS NULL) THEN
5513: FND_MESSAGE.SET_NAME('PSB','PSB_ATTR_MAPPING_NOT_FOUND');
5514: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);
5515: l_message_text := FND_MESSAGE.GET;
5516: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message_text);
5517: RAISE FND_API.G_EXC_ERROR;

Line 5514: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);

5510:
5511: /* Start bug #4302946 */
5512: IF (l_attr_link_type IS NULL) THEN
5513: FND_MESSAGE.SET_NAME('PSB','PSB_ATTR_MAPPING_NOT_FOUND');
5514: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);
5515: l_message_text := FND_MESSAGE.GET;
5516: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message_text);
5517: RAISE FND_API.G_EXC_ERROR;
5518: END IF;

Line 5515: l_message_text := FND_MESSAGE.GET;

5511: /* Start bug #4302946 */
5512: IF (l_attr_link_type IS NULL) THEN
5513: FND_MESSAGE.SET_NAME('PSB','PSB_ATTR_MAPPING_NOT_FOUND');
5514: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);
5515: l_message_text := FND_MESSAGE.GET;
5516: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message_text);
5517: RAISE FND_API.G_EXC_ERROR;
5518: END IF;
5519: /* End bug #4302946 */

Line 5553: FND_MESSAGE.SET_NAME('PSB', 'PSB_ATTRIBUTE_VALUE_DATE_ERR');

5549: exception
5550: when OTHERS then -- Bug #4658351: Changed VALUE_ERROR to OTHERS
5551:
5552: -- Changed the exception part for Bug#4658351
5553: FND_MESSAGE.SET_NAME('PSB', 'PSB_ATTRIBUTE_VALUE_DATE_ERR');
5554: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);
5555: l_message_text := fnd_message.get;
5556: RAISE_APPLICATION_ERROR(-20001,l_message_text);
5557:

Line 5554: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);

5550: when OTHERS then -- Bug #4658351: Changed VALUE_ERROR to OTHERS
5551:
5552: -- Changed the exception part for Bug#4658351
5553: FND_MESSAGE.SET_NAME('PSB', 'PSB_ATTRIBUTE_VALUE_DATE_ERR');
5554: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);
5555: l_message_text := fnd_message.get;
5556: RAISE_APPLICATION_ERROR(-20001,l_message_text);
5557:
5558: end;

Line 5555: l_message_text := fnd_message.get;

5551:
5552: -- Changed the exception part for Bug#4658351
5553: FND_MESSAGE.SET_NAME('PSB', 'PSB_ATTRIBUTE_VALUE_DATE_ERR');
5554: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);
5555: l_message_text := fnd_message.get;
5556: RAISE_APPLICATION_ERROR(-20001,l_message_text);
5557:
5558: end;
5559: elsif (Emp_attribute_rec.data_type = 'N') then

Line 5567: FND_MESSAGE.SET_NAME('PSB', 'PSB_ATTRIBUTE_VALUE_NUMBER_ERR');

5563: exception
5564: when INVALID_NUMBER then
5565:
5566: -- Changed the exception part for Bug#4658351
5567: FND_MESSAGE.SET_NAME('PSB', 'PSB_ATTRIBUTE_VALUE_NUMBER_ERR');
5568: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);
5569: l_message_text := fnd_message.get;
5570: RAISE_APPLICATION_ERROR(-20000,l_message_text);
5571:

Line 5568: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);

5564: when INVALID_NUMBER then
5565:
5566: -- Changed the exception part for Bug#4658351
5567: FND_MESSAGE.SET_NAME('PSB', 'PSB_ATTRIBUTE_VALUE_NUMBER_ERR');
5568: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);
5569: l_message_text := fnd_message.get;
5570: RAISE_APPLICATION_ERROR(-20000,l_message_text);
5571:
5572: end;

Line 5569: l_message_text := fnd_message.get;

5565:
5566: -- Changed the exception part for Bug#4658351
5567: FND_MESSAGE.SET_NAME('PSB', 'PSB_ATTRIBUTE_VALUE_NUMBER_ERR');
5568: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);
5569: l_message_text := fnd_message.get;
5570: RAISE_APPLICATION_ERROR(-20000,l_message_text);
5571:
5572: end;
5573:

Line 7532: -- Calls FND_MESSAGE server package to set the Message Stack. This message is

7528: /* ----------------------------------------------------------------------- */
7529:
7530: -- Define a Message Token with a Value and set the Message Name
7531:
7532: -- Calls FND_MESSAGE server package to set the Message Stack. This message is
7533: -- retrieved by the calling program.
7534:
7535: PROCEDURE add_message(appname IN VARCHAR2,
7536: msgname IN VARCHAR2) AS

Line 7545: FND_MESSAGE.SET_NAME(appname, msgname);

7541:
7542: if ((appname is not null) and
7543: (msgname is not null)) then
7544:
7545: FND_MESSAGE.SET_NAME(appname, msgname);
7546:
7547: if no_msg_tokens is not null then
7548:
7549: for i in 1..no_msg_tokens loop

Line 7550: FND_MESSAGE.SET_TOKEN(msg_tok_names(i), msg_tok_val(i));

7546:
7547: if no_msg_tokens is not null then
7548:
7549: for i in 1..no_msg_tokens loop
7550: FND_MESSAGE.SET_TOKEN(msg_tok_names(i), msg_tok_val(i));
7551: end loop;
7552:
7553: end if;
7554: