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 1041: return fnd_message.GET_STRING('SQLAP','OIE_ALL_OTHER');

1037: return null;
1038: END IF;
1039:
1040: IF p_role_id = -1 THEN
1041: return fnd_message.GET_STRING('SQLAP','OIE_ALL_OTHER');
1042: END IF;
1043:
1044: IF p_role_code = 'JOB_GROUP' THEN
1045:

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

1105:
1106: /*------------------------------------------------------------+
1107: | Fetch the message "Between RANGE_LOW and RANGE_HIGH" |
1108: +------------------------------------------------------------*/
1109: FND_MESSAGE.SET_NAME ('SQLAP', 'OIE_POL_THRESHOLD_BETWEEN');
1110:
1111: /*-------------------------------------------------------+
1112: | Replace tokens with the values passed in as parameter |
1113: +-------------------------------------------------------*/

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

1111: /*-------------------------------------------------------+
1112: | Replace tokens with the values passed in as parameter |
1113: +-------------------------------------------------------*/
1114: if (p_category_code = c_MILEAGE and p_range_low <> 0) then
1115: FND_MESSAGE.SET_TOKEN ('RANGE_LOW', p_range_low+.1);
1116: elsif (p_category_code = c_PER_DIEM and p_range_low <> 0) then
1117: -- FND_MESSAGE.SET_TOKEN ('RANGE_LOW', p_range_low+.01);
1118: FND_MESSAGE.SET_TOKEN ('RANGE_LOW',
1119: format_minutes_to_hour_minutes(p_range_low+1));

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

1113: +-------------------------------------------------------*/
1114: if (p_category_code = c_MILEAGE and p_range_low <> 0) then
1115: FND_MESSAGE.SET_TOKEN ('RANGE_LOW', p_range_low+.1);
1116: elsif (p_category_code = c_PER_DIEM and p_range_low <> 0) then
1117: -- FND_MESSAGE.SET_TOKEN ('RANGE_LOW', p_range_low+.01);
1118: FND_MESSAGE.SET_TOKEN ('RANGE_LOW',
1119: format_minutes_to_hour_minutes(p_range_low+1));
1120: else
1121: FND_MESSAGE.SET_TOKEN ('RANGE_LOW', p_range_low);

Line 1118: FND_MESSAGE.SET_TOKEN ('RANGE_LOW',

1114: if (p_category_code = c_MILEAGE and p_range_low <> 0) then
1115: FND_MESSAGE.SET_TOKEN ('RANGE_LOW', p_range_low+.1);
1116: elsif (p_category_code = c_PER_DIEM and p_range_low <> 0) then
1117: -- FND_MESSAGE.SET_TOKEN ('RANGE_LOW', p_range_low+.01);
1118: FND_MESSAGE.SET_TOKEN ('RANGE_LOW',
1119: format_minutes_to_hour_minutes(p_range_low+1));
1120: else
1121: FND_MESSAGE.SET_TOKEN ('RANGE_LOW', p_range_low);
1122: end if;

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

1117: -- FND_MESSAGE.SET_TOKEN ('RANGE_LOW', p_range_low+.01);
1118: FND_MESSAGE.SET_TOKEN ('RANGE_LOW',
1119: format_minutes_to_hour_minutes(p_range_low+1));
1120: else
1121: FND_MESSAGE.SET_TOKEN ('RANGE_LOW', p_range_low);
1122: end if;
1123:
1124: -- FND_MESSAGE.SET_TOKEN ('RANGE_HIGH' , p_range_high);
1125: if (p_category_code = c_PER_DIEM) then

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

1120: else
1121: FND_MESSAGE.SET_TOKEN ('RANGE_LOW', p_range_low);
1122: end if;
1123:
1124: -- FND_MESSAGE.SET_TOKEN ('RANGE_HIGH' , p_range_high);
1125: if (p_category_code = c_PER_DIEM) then
1126: FND_MESSAGE.SET_TOKEN ('RANGE_HIGH',
1127: format_minutes_to_hour_minutes(p_range_high));
1128: else

Line 1126: FND_MESSAGE.SET_TOKEN ('RANGE_HIGH',

1122: end if;
1123:
1124: -- FND_MESSAGE.SET_TOKEN ('RANGE_HIGH' , p_range_high);
1125: if (p_category_code = c_PER_DIEM) then
1126: FND_MESSAGE.SET_TOKEN ('RANGE_HIGH',
1127: format_minutes_to_hour_minutes(p_range_high));
1128: else
1129: FND_MESSAGE.SET_TOKEN ('RANGE_HIGH' , p_range_high);
1130: end if;

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

1125: if (p_category_code = c_PER_DIEM) then
1126: FND_MESSAGE.SET_TOKEN ('RANGE_HIGH',
1127: format_minutes_to_hour_minutes(p_range_high));
1128: else
1129: FND_MESSAGE.SET_TOKEN ('RANGE_HIGH' , p_range_high);
1130: end if;
1131:
1132: return FND_MESSAGE.get;
1133: ELSIF p_range_low is not null THEN

Line 1132: return FND_MESSAGE.get;

1128: else
1129: FND_MESSAGE.SET_TOKEN ('RANGE_HIGH' , p_range_high);
1130: end if;
1131:
1132: return FND_MESSAGE.get;
1133: ELSIF p_range_low is not null THEN
1134:
1135: /*--------------------------------------------------+
1136: | Fetch the message "Greater Than RANGE_LOW" |

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

1134:
1135: /*--------------------------------------------------+
1136: | Fetch the message "Greater Than RANGE_LOW" |
1137: +--------------------------------------------------*/
1138: FND_MESSAGE.SET_NAME ('SQLAP', 'OIE_POL_THRESHOLD_GREATER');
1139:
1140: /*-------------------------------------------------------+
1141: | Replace tokens with the values passed in as parameter |
1142: +-------------------------------------------------------*/

Line 1144: FND_MESSAGE.SET_TOKEN ('RANGE_LOW',

1140: /*-------------------------------------------------------+
1141: | Replace tokens with the values passed in as parameter |
1142: +-------------------------------------------------------*/
1143: if (p_category_code = c_PER_DIEM) then
1144: FND_MESSAGE.SET_TOKEN ('RANGE_LOW',
1145: format_minutes_to_hour_minutes(p_range_low));
1146: else
1147: FND_MESSAGE.SET_TOKEN ('RANGE_LOW', p_range_low);
1148: end if;

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

1143: if (p_category_code = c_PER_DIEM) then
1144: FND_MESSAGE.SET_TOKEN ('RANGE_LOW',
1145: format_minutes_to_hour_minutes(p_range_low));
1146: else
1147: FND_MESSAGE.SET_TOKEN ('RANGE_LOW', p_range_low);
1148: end if;
1149: return FND_MESSAGE.get;
1150:
1151: ELSE

Line 1149: return FND_MESSAGE.get;

1145: format_minutes_to_hour_minutes(p_range_low));
1146: else
1147: FND_MESSAGE.SET_TOKEN ('RANGE_LOW', p_range_low);
1148: end if;
1149: return FND_MESSAGE.get;
1150:
1151: ELSE
1152: return null;
1153: END IF;

Line 3902: 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,

3898: REIMBURSEMENT_PERCENTAGE
3899: )
3900: select
3901: l_schedule_period_id AS SCHEDULE_PERIOD_ID,
3902: 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,
3903: p_policy_id AS POLICY_ID,
3904: p_start_date AS START_DATE,
3905: p_end_date AS END_DATE,
3906: p_rate_per_passenger AS RATE_PER_PASSENGER,

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

4139: )
4140: select
4141: p_to_policy_id AS POLICY_ID,
4142: CATEGORY_CODE,
4143: substrb(fnd_message.GET_STRING('SQLAP','OIE_POL_COPY_OF')||' '||POLICY_NAME, 1, C_PolicyNameMaxLength) AS POLICY_NAME,
4144: DESCRIPTION,
4145: CURRENCY_CODE,
4146: BUSINESS_GROUP_ID,
4147: JOB_GROUP_ID,

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

4899: /*========================================================================
4900: | PUBLIC PROCEDURE getSingleTokenMessage
4901: |
4902: | DESCRIPTION
4903: | This function returns the fnd message which has a single token
4904: |
4905: | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
4906: | Called from BC4J and is used in the JRAD for setting column headers
4907: |

Line 4911: | p_message_name IN FND Message Name

Line 4912: | p_token IN FND Message Token

Line 4913: | p_token_value IN FND Message Token Value

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

4925: IF ( p_message_name IS NULL OR p_token IS NULL ) THEN
4926: RETURN NULL;
4927: END IF;
4928:
4929: fnd_message.set_name('SQLAP', p_message_name);
4930: fnd_message.set_token( p_token, p_token_value);
4931:
4932: RETURN fnd_message.get;
4933:

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

4926: RETURN NULL;
4927: END IF;
4928:
4929: fnd_message.set_name('SQLAP', p_message_name);
4930: fnd_message.set_token( p_token, p_token_value);
4931:
4932: RETURN fnd_message.get;
4933:
4934: END getSingleTokenMessage;

Line 4932: RETURN fnd_message.get;

4928:
4929: fnd_message.set_name('SQLAP', p_message_name);
4930: fnd_message.set_token( p_token, p_token_value);
4931:
4932: RETURN fnd_message.get;
4933:
4934: END getSingleTokenMessage;
4935:
4936:

Line 7562: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

7558:
7559: EXCEPTION
7560: WHEN OTHERS THEN
7561: BEGIN
7562: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
7563: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
7564: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
7565: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
7566: APP_EXCEPTION.RAISE_EXCEPTION;

Line 7563: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

7559: EXCEPTION
7560: WHEN OTHERS THEN
7561: BEGIN
7562: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
7563: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
7564: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
7565: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
7566: APP_EXCEPTION.RAISE_EXCEPTION;
7567: END;

Line 7564: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);

7560: WHEN OTHERS THEN
7561: BEGIN
7562: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
7563: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
7564: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
7565: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
7566: APP_EXCEPTION.RAISE_EXCEPTION;
7567: END;
7568:

Line 7565: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

7561: BEGIN
7562: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
7563: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
7564: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
7565: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
7566: APP_EXCEPTION.RAISE_EXCEPTION;
7567: END;
7568:
7569: END performDuplicateDetection;