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 957: fnd_message.set_name ( 'OTA','OTA_443166_OBJ_CHILD_DATE');

953: , v_end_date ) then
954: l_obj_off := ota_utility.Get_lookup_meaning('OTA_CATALOG_OBJECT_TYPE','O',810);
955: l_obj_act := ota_utility.Get_lookup_meaning('OTA_CATALOG_OBJECT_TYPE','H',810);
956: --
957: fnd_message.set_name ( 'OTA','OTA_443166_OBJ_CHILD_DATE');
958: fnd_message.set_token('OBJECT_NAME', l_obj_act );
959: fnd_message.set_token('CHILD_OBJECT', l_obj_off);
960: fnd_message.raise_error;
961: /*

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

954: l_obj_off := ota_utility.Get_lookup_meaning('OTA_CATALOG_OBJECT_TYPE','O',810);
955: l_obj_act := ota_utility.Get_lookup_meaning('OTA_CATALOG_OBJECT_TYPE','H',810);
956: --
957: fnd_message.set_name ( 'OTA','OTA_443166_OBJ_CHILD_DATE');
958: fnd_message.set_token('OBJECT_NAME', l_obj_act );
959: fnd_message.set_token('CHILD_OBJECT', l_obj_off);
960: fnd_message.raise_error;
961: /*
962: call_error_message( p_error_appl => 'OTA'

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

955: l_obj_act := ota_utility.Get_lookup_meaning('OTA_CATALOG_OBJECT_TYPE','H',810);
956: --
957: fnd_message.set_name ( 'OTA','OTA_443166_OBJ_CHILD_DATE');
958: fnd_message.set_token('OBJECT_NAME', l_obj_act );
959: fnd_message.set_token('CHILD_OBJECT', l_obj_off);
960: fnd_message.raise_error;
961: /*
962: call_error_message( p_error_appl => 'OTA'
963: , p_error_txt => 'OTA_13559_TAV_EVT_DATES'

Line 960: fnd_message.raise_error;

956: --
957: fnd_message.set_name ( 'OTA','OTA_443166_OBJ_CHILD_DATE');
958: fnd_message.set_token('OBJECT_NAME', l_obj_act );
959: fnd_message.set_token('CHILD_OBJECT', l_obj_off);
960: fnd_message.raise_error;
961: /*
962: call_error_message( p_error_appl => 'OTA'
963: , p_error_txt => 'OTA_13559_TAV_EVT_DATES'
964: );

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

1031: IF ( l_cat_start_date > p_start_date
1032: or l_cat_end_date < nvl(p_end_date, hr_api.g_eot)
1033: ) THEN
1034: --
1035: fnd_message.set_name ( 'OTA','OTA_13062_ACT_OUT_OF_CAT_DATES');
1036: fnd_message.raise_error;
1037: --
1038: End IF;
1039: ELSE

Line 1036: fnd_message.raise_error;

1032: or l_cat_end_date < nvl(p_end_date, hr_api.g_eot)
1033: ) THEN
1034: --
1035: fnd_message.set_name ( 'OTA','OTA_13062_ACT_OUT_OF_CAT_DATES');
1036: fnd_message.raise_error;
1037: --
1038: End IF;
1039: ELSE
1040: CLOSE cur_cat_start_end_date;

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

1841: null;
1842: elsif
1843: v_start_date > p_start_date-1 then
1844: /*
1845: fnd_message.set_name('OTA','OTA_13500_TAV_NO_CLOSE_DATE');
1846: fnd_message.raise_error;
1847: */
1848: null;
1849: else

Line 1846: fnd_message.raise_error;

1842: elsif
1843: v_start_date > p_start_date-1 then
1844: /*
1845: fnd_message.set_name('OTA','OTA_13500_TAV_NO_CLOSE_DATE');
1846: fnd_message.raise_error;
1847: */
1848: null;
1849: else
1850: --

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

1980: --
1981: close sel_latest_version;
1982: close sel_superseded_act;
1983: --
1984: fnd_message.set_name('OTA','OTA_13311_TAV_NO_CON_SUP');
1985: fnd_message.raise_error;
1986: --
1987: End if;
1988: --

Line 1985: fnd_message.raise_error;

1981: close sel_latest_version;
1982: close sel_superseded_act;
1983: --
1984: fnd_message.set_name('OTA','OTA_13311_TAV_NO_CON_SUP');
1985: fnd_message.raise_error;
1986: --
1987: End if;
1988: --
1989: close sel_superseded_act;

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

2060: hr_utility.set_location('Entering:'||l_proc, 15);
2061: open csr_order_line_exist;
2062: fetch csr_order_line_exist into l_exists;
2063: if csr_order_line_exist%found then
2064: fnd_message.set_name('OTA','OTA_13695_TAV_INV_EXIST');
2065: fnd_message.raise_error;
2066: end if;
2067: close csr_order_line_exist;
2068: hr_utility.set_location('Entering:'||l_proc, 20);

Line 2065: fnd_message.raise_error;

2061: open csr_order_line_exist;
2062: fetch csr_order_line_exist into l_exists;
2063: if csr_order_line_exist%found then
2064: fnd_message.set_name('OTA','OTA_13695_TAV_INV_EXIST');
2065: fnd_message.raise_error;
2066: end if;
2067: close csr_order_line_exist;
2068: hr_utility.set_location('Entering:'||l_proc, 20);
2069:

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

2076: hr_utility.set_location('Entering:'||l_proc, 25);
2077: open csr_order_line_exist;
2078: fetch csr_order_line_exist into l_exists;
2079: if csr_order_line_exist%found then
2080: fnd_message.set_name('OTA','OTA_13695_TAV_INV_EXIST');
2081: fnd_message.raise_error;
2082: end if;
2083: close csr_order_line_exist;
2084: hr_utility.set_location('Entering:'||l_proc, 30);

Line 2081: fnd_message.raise_error;

2077: open csr_order_line_exist;
2078: fetch csr_order_line_exist into l_exists;
2079: if csr_order_line_exist%found then
2080: fnd_message.set_name('OTA','OTA_13695_TAV_INV_EXIST');
2081: fnd_message.raise_error;
2082: end if;
2083: close csr_order_line_exist;
2084: hr_utility.set_location('Entering:'||l_proc, 30);
2085: end if;

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

2178: hr_utility.set_location('Entering:'||l_proc, 15);
2179: open csr_inventory;
2180: fetch csr_inventory into l_exists;
2181: if csr_inventory%notfound then
2182: fnd_message.set_name('OTA','OTA_13693_TAV_NO_INV');
2183: fnd_message.raise_error;
2184: end if;
2185: close csr_inventory;
2186: hr_utility.set_location('Entering:'||l_proc, 20);

Line 2183: fnd_message.raise_error;

2179: open csr_inventory;
2180: fetch csr_inventory into l_exists;
2181: if csr_inventory%notfound then
2182: fnd_message.set_name('OTA','OTA_13693_TAV_NO_INV');
2183: fnd_message.raise_error;
2184: end if;
2185: close csr_inventory;
2186: hr_utility.set_location('Entering:'||l_proc, 20);
2187: elsif p_inventory_item_id is not null and

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

2185: close csr_inventory;
2186: hr_utility.set_location('Entering:'||l_proc, 20);
2187: elsif p_inventory_item_id is not null and
2188: p_organization_id is null then
2189: fnd_message.set_name('OTA','OTA_13892_TAV_INV_COMB_INVALID');
2190: fnd_message.raise_error;
2191: elsif p_inventory_item_id is null and
2192: p_organization_id is not null then
2193: fnd_message.set_name('OTA','OTA_13892_TAV_INV_COMB_INVALID');

Line 2190: fnd_message.raise_error;

2186: hr_utility.set_location('Entering:'||l_proc, 20);
2187: elsif p_inventory_item_id is not null and
2188: p_organization_id is null then
2189: fnd_message.set_name('OTA','OTA_13892_TAV_INV_COMB_INVALID');
2190: fnd_message.raise_error;
2191: elsif p_inventory_item_id is null and
2192: p_organization_id is not null then
2193: fnd_message.set_name('OTA','OTA_13892_TAV_INV_COMB_INVALID');
2194: fnd_message.raise_error;

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

2189: fnd_message.set_name('OTA','OTA_13892_TAV_INV_COMB_INVALID');
2190: fnd_message.raise_error;
2191: elsif p_inventory_item_id is null and
2192: p_organization_id is not null then
2193: fnd_message.set_name('OTA','OTA_13892_TAV_INV_COMB_INVALID');
2194: fnd_message.raise_error;
2195:
2196: end if;
2197: --

Line 2194: fnd_message.raise_error;

2190: fnd_message.raise_error;
2191: elsif p_inventory_item_id is null and
2192: p_organization_id is not null then
2193: fnd_message.set_name('OTA','OTA_13892_TAV_INV_COMB_INVALID');
2194: fnd_message.raise_error;
2195:
2196: end if;
2197: --
2198: end if;

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

2205: open cur_offerings;
2206: fetch cur_offerings
2207: into l_num;
2208: if cur_offerings%found then
2209: fnd_message.set_name('OTA','OTA_443662_ACT_INVENTORY');
2210: fnd_message.raise_error;
2211: end if;
2212: close cur_offerings;
2213:

Line 2210: fnd_message.raise_error;

2206: fetch cur_offerings
2207: into l_num;
2208: if cur_offerings%found then
2209: fnd_message.set_name('OTA','OTA_443662_ACT_INVENTORY');
2210: fnd_message.raise_error;
2211: end if;
2212: close cur_offerings;
2213:
2214:

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

2215: open csr_enr; -- Bug 4401602
2216: fetch csr_enr
2217: into l_num;
2218: if csr_enr%found then
2219: fnd_message.set_name('OTA','OTA_443915_TAV_INV_ENR_EXITS');
2220: fnd_message.raise_error;
2221: end if;
2222: close csr_enr;
2223:

Line 2220: fnd_message.raise_error;

2216: fetch csr_enr
2217: into l_num;
2218: if csr_enr%found then
2219: fnd_message.set_name('OTA','OTA_443915_TAV_INV_ENR_EXITS');
2220: fnd_message.raise_error;
2221: end if;
2222: close csr_enr;
2223:
2224: