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

Line 63: fnd_message.set_name ( p_error_appl ,p_error_txt);

59: hr_utility.set_location('Entering:'|| v_proc, 5);
60: --
61: -- ** TEMP ** Add error message with the following text.
62: --
63: fnd_message.set_name ( p_error_appl ,p_error_txt);
64: fnd_message.raise_error;
65: --
66: hr_utility.set_location(' Leaving:'|| v_proc, 10);
67: --

Line 64: fnd_message.raise_error;

60: --
61: -- ** TEMP ** Add error message with the following text.
62: --
63: fnd_message.set_name ( p_error_appl ,p_error_txt);
64: fnd_message.raise_error;
65: --
66: hr_utility.set_location(' Leaving:'|| v_proc, 10);
67: --
68: End call_error_message;

Line 91: -- fnd_message.set_name( 'OTA', OTA_TAV_');

87: hr_utility.set_location('Entering:'|| v_proc, 5);
88: --
89: -- ** TEMP ** Add warning message with the following text.
90: --
91: -- fnd_message.set_name( 'OTA', OTA_TAV_');
92: fnd_message.set_name( 'OTA', p_warning_txt);
93: fnd_message.raise_error;
94: --
95: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 92: fnd_message.set_name( 'OTA', p_warning_txt);

88: --
89: -- ** TEMP ** Add warning message with the following text.
90: --
91: -- fnd_message.set_name( 'OTA', OTA_TAV_');
92: fnd_message.set_name( 'OTA', p_warning_txt);
93: fnd_message.raise_error;
94: --
95: hr_utility.set_location(' Leaving:'|| v_proc, 10);
96: --

Line 93: fnd_message.raise_error;

89: -- ** TEMP ** Add warning message with the following text.
90: --
91: -- fnd_message.set_name( 'OTA', OTA_TAV_');
92: fnd_message.set_name( 'OTA', p_warning_txt);
93: fnd_message.raise_error;
94: --
95: hr_utility.set_location(' Leaving:'|| v_proc, 10);
96: --
97: End call_warning_message;

Line 169: fnd_message.set_name('OTA','OTA_13394_TAV_COST_ATTR');

165: --
166: if (p_budget_cost is not null or p_actual_cost is not null) and
167: p_budget_currency_code is null then
168: --
169: fnd_message.set_name('OTA','OTA_13394_TAV_COST_ATTR');
170: fnd_message.raise_error;
171: --
172: end if;
173: --

Line 170: fnd_message.raise_error;

166: if (p_budget_cost is not null or p_actual_cost is not null) and
167: p_budget_currency_code is null then
168: --
169: fnd_message.set_name('OTA','OTA_13394_TAV_COST_ATTR');
170: fnd_message.raise_error;
171: --
172: end if;
173: --
174: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 207: fnd_message.set_name('OTA','OTA_13422_TAV_PROF_CREDIT_VALS');

203: p_professional_credits is not null)
204: or (p_professional_credit_type is not null and
205: p_professional_credits is null) then
206: --
207: fnd_message.set_name('OTA','OTA_13422_TAV_PROF_CREDIT_VALS');
208: fnd_message.raise_error;
209: --
210: end if;
211: --

Line 208: fnd_message.raise_error;

204: or (p_professional_credit_type is not null and
205: p_professional_credits is null) then
206: --
207: fnd_message.set_name('OTA','OTA_13422_TAV_PROF_CREDIT_VALS');
208: fnd_message.raise_error;
209: --
210: end if;
211: --
212: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 951: fnd_message.set_name ( 'OTA','OTA_443166_OBJ_CHILD_DATE');

947: , p_end_date
948: , v_start_date
949: , v_end_date ) then
950: --
951: fnd_message.set_name ( 'OTA','OTA_443166_OBJ_CHILD_DATE');
952: fnd_message.set_token('OBJECT_NAME', l_obj_act );
953: fnd_message.set_token('CHILD_OBJECT', l_obj_off);
954: fnd_message.raise_error;
955: /*

Line 952: fnd_message.set_token('OBJECT_NAME', l_obj_act );

948: , v_start_date
949: , v_end_date ) then
950: --
951: fnd_message.set_name ( 'OTA','OTA_443166_OBJ_CHILD_DATE');
952: fnd_message.set_token('OBJECT_NAME', l_obj_act );
953: fnd_message.set_token('CHILD_OBJECT', l_obj_off);
954: fnd_message.raise_error;
955: /*
956: call_error_message( p_error_appl => 'OTA'

Line 953: fnd_message.set_token('CHILD_OBJECT', l_obj_off);

949: , v_end_date ) then
950: --
951: fnd_message.set_name ( 'OTA','OTA_443166_OBJ_CHILD_DATE');
952: fnd_message.set_token('OBJECT_NAME', l_obj_act );
953: fnd_message.set_token('CHILD_OBJECT', l_obj_off);
954: fnd_message.raise_error;
955: /*
956: call_error_message( p_error_appl => 'OTA'
957: , p_error_txt => 'OTA_13559_TAV_EVT_DATES'

Line 954: fnd_message.raise_error;

950: --
951: fnd_message.set_name ( 'OTA','OTA_443166_OBJ_CHILD_DATE');
952: fnd_message.set_token('OBJECT_NAME', l_obj_act );
953: fnd_message.set_token('CHILD_OBJECT', l_obj_off);
954: fnd_message.raise_error;
955: /*
956: call_error_message( p_error_appl => 'OTA'
957: , p_error_txt => 'OTA_13559_TAV_EVT_DATES'
958: );

Line 1029: fnd_message.set_name ( 'OTA','OTA_13062_ACT_OUT_OF_CAT_DATES');

1025: IF ( l_cat_start_date > p_start_date
1026: or l_cat_end_date < nvl(p_end_date, hr_api.g_eot)
1027: ) THEN
1028: --
1029: fnd_message.set_name ( 'OTA','OTA_13062_ACT_OUT_OF_CAT_DATES');
1030: fnd_message.raise_error;
1031: --
1032: End IF;
1033: ELSE

Line 1030: fnd_message.raise_error;

1026: or l_cat_end_date < nvl(p_end_date, hr_api.g_eot)
1027: ) THEN
1028: --
1029: fnd_message.set_name ( 'OTA','OTA_13062_ACT_OUT_OF_CAT_DATES');
1030: fnd_message.raise_error;
1031: --
1032: End IF;
1033: ELSE
1034: CLOSE cur_cat_start_end_date;

Line 1839: fnd_message.set_name('OTA','OTA_13500_TAV_NO_CLOSE_DATE');

1835: null;
1836: elsif
1837: v_start_date > p_start_date-1 then
1838: /*
1839: fnd_message.set_name('OTA','OTA_13500_TAV_NO_CLOSE_DATE');
1840: fnd_message.raise_error;
1841: */
1842: null;
1843: else

Line 1840: fnd_message.raise_error;

1836: elsif
1837: v_start_date > p_start_date-1 then
1838: /*
1839: fnd_message.set_name('OTA','OTA_13500_TAV_NO_CLOSE_DATE');
1840: fnd_message.raise_error;
1841: */
1842: null;
1843: else
1844: --

Line 1978: fnd_message.set_name('OTA','OTA_13311_TAV_NO_CON_SUP');

1974: --
1975: close sel_latest_version;
1976: close sel_superseded_act;
1977: --
1978: fnd_message.set_name('OTA','OTA_13311_TAV_NO_CON_SUP');
1979: fnd_message.raise_error;
1980: --
1981: End if;
1982: --

Line 1979: fnd_message.raise_error;

1975: close sel_latest_version;
1976: close sel_superseded_act;
1977: --
1978: fnd_message.set_name('OTA','OTA_13311_TAV_NO_CON_SUP');
1979: fnd_message.raise_error;
1980: --
1981: End if;
1982: --
1983: close sel_superseded_act;

Line 2058: fnd_message.set_name('OTA','OTA_13695_TAV_INV_EXIST');

2054: hr_utility.set_location('Entering:'||l_proc, 15);
2055: open csr_order_line_exist;
2056: fetch csr_order_line_exist into l_exists;
2057: if csr_order_line_exist%found then
2058: fnd_message.set_name('OTA','OTA_13695_TAV_INV_EXIST');
2059: fnd_message.raise_error;
2060: end if;
2061: close csr_order_line_exist;
2062: hr_utility.set_location('Entering:'||l_proc, 20);

Line 2059: fnd_message.raise_error;

2055: open csr_order_line_exist;
2056: fetch csr_order_line_exist into l_exists;
2057: if csr_order_line_exist%found then
2058: fnd_message.set_name('OTA','OTA_13695_TAV_INV_EXIST');
2059: fnd_message.raise_error;
2060: end if;
2061: close csr_order_line_exist;
2062: hr_utility.set_location('Entering:'||l_proc, 20);
2063:

Line 2074: fnd_message.set_name('OTA','OTA_13695_TAV_INV_EXIST');

2070: hr_utility.set_location('Entering:'||l_proc, 25);
2071: open csr_order_line_exist;
2072: fetch csr_order_line_exist into l_exists;
2073: if csr_order_line_exist%found then
2074: fnd_message.set_name('OTA','OTA_13695_TAV_INV_EXIST');
2075: fnd_message.raise_error;
2076: end if;
2077: close csr_order_line_exist;
2078: hr_utility.set_location('Entering:'||l_proc, 30);

Line 2075: fnd_message.raise_error;

2071: open csr_order_line_exist;
2072: fetch csr_order_line_exist into l_exists;
2073: if csr_order_line_exist%found then
2074: fnd_message.set_name('OTA','OTA_13695_TAV_INV_EXIST');
2075: fnd_message.raise_error;
2076: end if;
2077: close csr_order_line_exist;
2078: hr_utility.set_location('Entering:'||l_proc, 30);
2079: end if;

Line 2176: fnd_message.set_name('OTA','OTA_13693_TAV_NO_INV');

2172: hr_utility.set_location('Entering:'||l_proc, 15);
2173: open csr_inventory;
2174: fetch csr_inventory into l_exists;
2175: if csr_inventory%notfound then
2176: fnd_message.set_name('OTA','OTA_13693_TAV_NO_INV');
2177: fnd_message.raise_error;
2178: end if;
2179: close csr_inventory;
2180: hr_utility.set_location('Entering:'||l_proc, 20);

Line 2177: fnd_message.raise_error;

2173: open csr_inventory;
2174: fetch csr_inventory into l_exists;
2175: if csr_inventory%notfound then
2176: fnd_message.set_name('OTA','OTA_13693_TAV_NO_INV');
2177: fnd_message.raise_error;
2178: end if;
2179: close csr_inventory;
2180: hr_utility.set_location('Entering:'||l_proc, 20);
2181: elsif p_inventory_item_id is not null and

Line 2183: fnd_message.set_name('OTA','OTA_13892_TAV_INV_COMB_INVALID');

2179: close csr_inventory;
2180: hr_utility.set_location('Entering:'||l_proc, 20);
2181: elsif p_inventory_item_id is not null and
2182: p_organization_id is null then
2183: fnd_message.set_name('OTA','OTA_13892_TAV_INV_COMB_INVALID');
2184: fnd_message.raise_error;
2185: elsif p_inventory_item_id is null and
2186: p_organization_id is not null then
2187: fnd_message.set_name('OTA','OTA_13892_TAV_INV_COMB_INVALID');

Line 2184: fnd_message.raise_error;

2180: hr_utility.set_location('Entering:'||l_proc, 20);
2181: elsif p_inventory_item_id is not null and
2182: p_organization_id is null then
2183: fnd_message.set_name('OTA','OTA_13892_TAV_INV_COMB_INVALID');
2184: fnd_message.raise_error;
2185: elsif p_inventory_item_id is null and
2186: p_organization_id is not null then
2187: fnd_message.set_name('OTA','OTA_13892_TAV_INV_COMB_INVALID');
2188: fnd_message.raise_error;

Line 2187: fnd_message.set_name('OTA','OTA_13892_TAV_INV_COMB_INVALID');

2183: fnd_message.set_name('OTA','OTA_13892_TAV_INV_COMB_INVALID');
2184: fnd_message.raise_error;
2185: elsif p_inventory_item_id is null and
2186: p_organization_id is not null then
2187: fnd_message.set_name('OTA','OTA_13892_TAV_INV_COMB_INVALID');
2188: fnd_message.raise_error;
2189:
2190: end if;
2191: --

Line 2188: fnd_message.raise_error;

2184: fnd_message.raise_error;
2185: elsif p_inventory_item_id is null and
2186: p_organization_id is not null then
2187: fnd_message.set_name('OTA','OTA_13892_TAV_INV_COMB_INVALID');
2188: fnd_message.raise_error;
2189:
2190: end if;
2191: --
2192: end if;

Line 2203: fnd_message.set_name('OTA','OTA_443662_ACT_INVENTORY');

2199: open cur_offerings;
2200: fetch cur_offerings
2201: into l_num;
2202: if cur_offerings%found then
2203: fnd_message.set_name('OTA','OTA_443662_ACT_INVENTORY');
2204: fnd_message.raise_error;
2205: end if;
2206: close cur_offerings;
2207:

Line 2204: fnd_message.raise_error;

2200: fetch cur_offerings
2201: into l_num;
2202: if cur_offerings%found then
2203: fnd_message.set_name('OTA','OTA_443662_ACT_INVENTORY');
2204: fnd_message.raise_error;
2205: end if;
2206: close cur_offerings;
2207:
2208:

Line 2213: fnd_message.set_name('OTA','OTA_443915_TAV_INV_ENR_EXITS');

2209: open csr_enr; -- Bug 4401602
2210: fetch csr_enr
2211: into l_num;
2212: if csr_enr%found then
2213: fnd_message.set_name('OTA','OTA_443915_TAV_INV_ENR_EXITS');
2214: fnd_message.raise_error;
2215: end if;
2216: close csr_enr;
2217:

Line 2214: fnd_message.raise_error;

2210: fetch csr_enr
2211: into l_num;
2212: if csr_enr%found then
2213: fnd_message.set_name('OTA','OTA_443915_TAV_INV_ENR_EXITS');
2214: fnd_message.raise_error;
2215: end if;
2216: close csr_enr;
2217:
2218: