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

Line 1016: return fnd_message.GET_STRING('SQLAP','OIE_ALL_OTHER');

1012: return null;
1013: END IF;
1014:
1015: IF p_role_id = -1 THEN
1016: return fnd_message.GET_STRING('SQLAP','OIE_ALL_OTHER');
1017: END IF;
1018:
1019: IF p_role_code = 'JOB_GROUP' THEN
1020:

Line 1084: FND_MESSAGE.SET_NAME ('SQLAP', 'OIE_POL_THRESHOLD_BETWEEN');

1080:
1081: /*------------------------------------------------------------+
1082: | Fetch the message "Between RANGE_LOW and RANGE_HIGH" |
1083: +------------------------------------------------------------*/
1084: FND_MESSAGE.SET_NAME ('SQLAP', 'OIE_POL_THRESHOLD_BETWEEN');
1085:
1086: /*-------------------------------------------------------+
1087: | Replace tokens with the values passed in as parameter |
1088: +-------------------------------------------------------*/

Line 1090: FND_MESSAGE.SET_TOKEN ('RANGE_LOW', p_range_low+.1);

1086: /*-------------------------------------------------------+
1087: | Replace tokens with the values passed in as parameter |
1088: +-------------------------------------------------------*/
1089: if (p_category_code = c_MILEAGE and p_range_low <> 0) then
1090: FND_MESSAGE.SET_TOKEN ('RANGE_LOW', p_range_low+.1);
1091: elsif (p_category_code = c_PER_DIEM and p_range_low <> 0) then
1092: -- FND_MESSAGE.SET_TOKEN ('RANGE_LOW', p_range_low+.01);
1093: FND_MESSAGE.SET_TOKEN ('RANGE_LOW',
1094: format_minutes_to_hour_minutes(p_range_low+1));

Line 1092: -- FND_MESSAGE.SET_TOKEN ('RANGE_LOW', p_range_low+.01);

1088: +-------------------------------------------------------*/
1089: if (p_category_code = c_MILEAGE and p_range_low <> 0) then
1090: FND_MESSAGE.SET_TOKEN ('RANGE_LOW', p_range_low+.1);
1091: elsif (p_category_code = c_PER_DIEM and p_range_low <> 0) then
1092: -- FND_MESSAGE.SET_TOKEN ('RANGE_LOW', p_range_low+.01);
1093: FND_MESSAGE.SET_TOKEN ('RANGE_LOW',
1094: format_minutes_to_hour_minutes(p_range_low+1));
1095: else
1096: FND_MESSAGE.SET_TOKEN ('RANGE_LOW', p_range_low);

Line 1093: FND_MESSAGE.SET_TOKEN ('RANGE_LOW',

1089: if (p_category_code = c_MILEAGE and p_range_low <> 0) then
1090: FND_MESSAGE.SET_TOKEN ('RANGE_LOW', p_range_low+.1);
1091: elsif (p_category_code = c_PER_DIEM and p_range_low <> 0) then
1092: -- FND_MESSAGE.SET_TOKEN ('RANGE_LOW', p_range_low+.01);
1093: FND_MESSAGE.SET_TOKEN ('RANGE_LOW',
1094: format_minutes_to_hour_minutes(p_range_low+1));
1095: else
1096: FND_MESSAGE.SET_TOKEN ('RANGE_LOW', p_range_low);
1097: end if;

Line 1096: FND_MESSAGE.SET_TOKEN ('RANGE_LOW', p_range_low);

1092: -- FND_MESSAGE.SET_TOKEN ('RANGE_LOW', p_range_low+.01);
1093: FND_MESSAGE.SET_TOKEN ('RANGE_LOW',
1094: format_minutes_to_hour_minutes(p_range_low+1));
1095: else
1096: FND_MESSAGE.SET_TOKEN ('RANGE_LOW', p_range_low);
1097: end if;
1098:
1099: -- FND_MESSAGE.SET_TOKEN ('RANGE_HIGH' , p_range_high);
1100: if (p_category_code = c_PER_DIEM) then

Line 1099: -- FND_MESSAGE.SET_TOKEN ('RANGE_HIGH' , p_range_high);

1095: else
1096: FND_MESSAGE.SET_TOKEN ('RANGE_LOW', p_range_low);
1097: end if;
1098:
1099: -- FND_MESSAGE.SET_TOKEN ('RANGE_HIGH' , p_range_high);
1100: if (p_category_code = c_PER_DIEM) then
1101: FND_MESSAGE.SET_TOKEN ('RANGE_HIGH',
1102: format_minutes_to_hour_minutes(p_range_high));
1103: else

Line 1101: FND_MESSAGE.SET_TOKEN ('RANGE_HIGH',

1097: end if;
1098:
1099: -- FND_MESSAGE.SET_TOKEN ('RANGE_HIGH' , p_range_high);
1100: if (p_category_code = c_PER_DIEM) then
1101: FND_MESSAGE.SET_TOKEN ('RANGE_HIGH',
1102: format_minutes_to_hour_minutes(p_range_high));
1103: else
1104: FND_MESSAGE.SET_TOKEN ('RANGE_HIGH' , p_range_high);
1105: end if;

Line 1104: FND_MESSAGE.SET_TOKEN ('RANGE_HIGH' , p_range_high);

1100: if (p_category_code = c_PER_DIEM) then
1101: FND_MESSAGE.SET_TOKEN ('RANGE_HIGH',
1102: format_minutes_to_hour_minutes(p_range_high));
1103: else
1104: FND_MESSAGE.SET_TOKEN ('RANGE_HIGH' , p_range_high);
1105: end if;
1106:
1107: return FND_MESSAGE.get;
1108: ELSIF p_range_low is not null THEN

Line 1107: return FND_MESSAGE.get;

1103: else
1104: FND_MESSAGE.SET_TOKEN ('RANGE_HIGH' , p_range_high);
1105: end if;
1106:
1107: return FND_MESSAGE.get;
1108: ELSIF p_range_low is not null THEN
1109:
1110: /*--------------------------------------------------+
1111: | Fetch the message "Greater Than RANGE_LOW" |

Line 1113: FND_MESSAGE.SET_NAME ('SQLAP', 'OIE_POL_THRESHOLD_GREATER');

1109:
1110: /*--------------------------------------------------+
1111: | Fetch the message "Greater Than RANGE_LOW" |
1112: +--------------------------------------------------*/
1113: FND_MESSAGE.SET_NAME ('SQLAP', 'OIE_POL_THRESHOLD_GREATER');
1114:
1115: /*-------------------------------------------------------+
1116: | Replace tokens with the values passed in as parameter |
1117: +-------------------------------------------------------*/

Line 1119: FND_MESSAGE.SET_TOKEN ('RANGE_LOW',

1115: /*-------------------------------------------------------+
1116: | Replace tokens with the values passed in as parameter |
1117: +-------------------------------------------------------*/
1118: if (p_category_code = c_PER_DIEM) then
1119: FND_MESSAGE.SET_TOKEN ('RANGE_LOW',
1120: format_minutes_to_hour_minutes(p_range_low));
1121: else
1122: FND_MESSAGE.SET_TOKEN ('RANGE_LOW', p_range_low);
1123: end if;

Line 1122: FND_MESSAGE.SET_TOKEN ('RANGE_LOW', p_range_low);

1118: if (p_category_code = c_PER_DIEM) then
1119: FND_MESSAGE.SET_TOKEN ('RANGE_LOW',
1120: format_minutes_to_hour_minutes(p_range_low));
1121: else
1122: FND_MESSAGE.SET_TOKEN ('RANGE_LOW', p_range_low);
1123: end if;
1124: return FND_MESSAGE.get;
1125:
1126: ELSE

Line 1124: return FND_MESSAGE.get;

1120: format_minutes_to_hour_minutes(p_range_low));
1121: else
1122: FND_MESSAGE.SET_TOKEN ('RANGE_LOW', p_range_low);
1123: end if;
1124: return FND_MESSAGE.get;
1125:
1126: ELSE
1127: return null;
1128: END IF;

Line 3840: decode(p_schedule_period_name, null, fnd_message.GET_STRING('SQLAP','OIE_POL_PERIODS_NEW_PERIOD'), substrb(fnd_message.GET_STRING('SQLAP','OIE_POL_COPY_OF')||' '||p_schedule_period_name, 1, C_PolicyNameMaxLength)) AS SCHEDULE_PERIOD_NAME,

3836: LAST_UPDATED_BY
3837: )
3838: select
3839: l_schedule_period_id AS SCHEDULE_PERIOD_ID,
3840: decode(p_schedule_period_name, null, fnd_message.GET_STRING('SQLAP','OIE_POL_PERIODS_NEW_PERIOD'), substrb(fnd_message.GET_STRING('SQLAP','OIE_POL_COPY_OF')||' '||p_schedule_period_name, 1, C_PolicyNameMaxLength)) AS SCHEDULE_PERIOD_NAME,
3841: p_policy_id AS POLICY_ID,
3842: p_start_date AS START_DATE,
3843: p_end_date AS END_DATE,
3844: p_rate_per_passenger AS RATE_PER_PASSENGER,

Line 4076: substrb(fnd_message.GET_STRING('SQLAP','OIE_POL_COPY_OF')||' '||POLICY_NAME, 1, C_PolicyNameMaxLength) AS POLICY_NAME,

4072: )
4073: select
4074: p_to_policy_id AS POLICY_ID,
4075: CATEGORY_CODE,
4076: substrb(fnd_message.GET_STRING('SQLAP','OIE_POL_COPY_OF')||' '||POLICY_NAME, 1, C_PolicyNameMaxLength) AS POLICY_NAME,
4077: DESCRIPTION,
4078: CURRENCY_CODE,
4079: BUSINESS_GROUP_ID,
4080: JOB_GROUP_ID,

Line 4832: | This function returns the fnd message which has a single token

4828: /*========================================================================
4829: | PUBLIC PROCEDURE getSingleTokenMessage
4830: |
4831: | DESCRIPTION
4832: | This function returns the fnd message which has a single token
4833: |
4834: | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
4835: | Called from BC4J and is used in the JRAD for setting column headers
4836: |

Line 4840: | p_message_name IN FND Message Name

Line 4841: | p_token IN FND Message Token

Line 4842: | p_token_value IN FND Message Token Value

Line 4858: fnd_message.set_name('SQLAP', p_message_name);

4854: IF ( p_message_name IS NULL OR p_token IS NULL ) THEN
4855: RETURN NULL;
4856: END IF;
4857:
4858: fnd_message.set_name('SQLAP', p_message_name);
4859: fnd_message.set_token( p_token, p_token_value);
4860:
4861: RETURN fnd_message.get;
4862:

Line 4859: fnd_message.set_token( p_token, p_token_value);

4855: RETURN NULL;
4856: END IF;
4857:
4858: fnd_message.set_name('SQLAP', p_message_name);
4859: fnd_message.set_token( p_token, p_token_value);
4860:
4861: RETURN fnd_message.get;
4862:
4863: END getSingleTokenMessage;

Line 4861: RETURN fnd_message.get;

4857:
4858: fnd_message.set_name('SQLAP', p_message_name);
4859: fnd_message.set_token( p_token, p_token_value);
4860:
4861: RETURN fnd_message.get;
4862:
4863: END getSingleTokenMessage;
4864:
4865: