APPS.PQP_ERT_INS dependencies on PQP_ERT_SHD

Line 54: (p_rec in out nocopy pqp_ert_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure insert_dml
54: (p_rec in out nocopy pqp_ert_shd.g_rec_type
55: ) is
56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: --

Line 62: pqp_ert_shd.g_api_dml := true; -- Set the api dml status

58: --
59: Begin
60: hr_utility.set_location('Entering:'||l_proc, 5);
61: --
62: pqp_ert_shd.g_api_dml := true; -- Set the api dml status
63: --
64: -- Insert the row into: pqp_exception_reports_tl
65: --
66:

Line 108: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status

104: );
105:
106: END IF;
107: --
108: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status
109: --
110: hr_utility.set_location(' Leaving:'||l_proc, 10);
111: Exception
112: When hr_api.check_integrity_violated Then

Line 114: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status

110: hr_utility.set_location(' Leaving:'||l_proc, 10);
111: Exception
112: When hr_api.check_integrity_violated Then
113: -- A check constraint has been violated
114: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status
115: pqp_ert_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.parent_integrity_violated Then
118: -- Parent integrity has been violated

Line 115: pqp_ert_shd.constraint_error

111: Exception
112: When hr_api.check_integrity_violated Then
113: -- A check constraint has been violated
114: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status
115: pqp_ert_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.parent_integrity_violated Then
118: -- Parent integrity has been violated
119: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status

Line 119: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status

115: pqp_ert_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.parent_integrity_violated Then
118: -- Parent integrity has been violated
119: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status
120: pqp_ert_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.unique_integrity_violated Then
123: -- Unique integrity has been violated

Line 120: pqp_ert_shd.constraint_error

116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.parent_integrity_violated Then
118: -- Parent integrity has been violated
119: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status
120: pqp_ert_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.unique_integrity_violated Then
123: -- Unique integrity has been violated
124: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status

Line 124: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status

120: pqp_ert_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.unique_integrity_violated Then
123: -- Unique integrity has been violated
124: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status
125: pqp_ert_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When Others Then
128: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status

Line 125: pqp_ert_shd.constraint_error

121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.unique_integrity_violated Then
123: -- Unique integrity has been violated
124: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status
125: pqp_ert_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When Others Then
128: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status
129: Raise;

Line 128: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status

124: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status
125: pqp_ert_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When Others Then
128: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status
129: Raise;
130: End insert_dml;
131: --
132: -- ----------------------------------------------------------------------------

Line 170: (p_rec in out nocopy pqp_ert_shd.g_rec_type

166: --
167: -- {End Of Comments}
168: -- ----------------------------------------------------------------------------
169: Procedure pre_insert
170: (p_rec in out nocopy pqp_ert_shd.g_rec_type
171: ,p_exception_report_id in number
172: ) is
173: --
174: l_proc varchar2(72) := g_package||'pre_insert';

Line 217: (p_rec in pqp_ert_shd.g_rec_type

213: --
214: -- {End Of Comments}
215: -- ----------------------------------------------------------------------------
216: Procedure post_insert
217: (p_rec in pqp_ert_shd.g_rec_type
218: ) is
219: --
220: l_proc varchar2(72) := g_package||'post_insert';
221: --

Line 254: (p_rec in out nocopy pqp_ert_shd.g_rec_type

250: -- ----------------------------------------------------------------------------
251: -- |---------------------------------< ins >----------------------------------|
252: -- ----------------------------------------------------------------------------
253: Procedure ins
254: (p_rec in out nocopy pqp_ert_shd.g_rec_type
255: ,p_exception_report_id in number
256: ) is
257: --
258: l_proc varchar2(72) := g_package||'ins';

Line 299: l_rec pqp_ert_shd.g_rec_type;

295: ,p_language in varchar2
296: ,p_source_lang in varchar2
297: ) is
298: --
299: l_rec pqp_ert_shd.g_rec_type;
300: l_proc varchar2(72) := g_package||'ins';
301: --
302: Begin
303: hr_utility.set_location('Entering:'||l_proc, 5);

Line 309: pqp_ert_shd.convert_args

305: -- Call conversion function to turn arguments into the
306: -- p_rec structure.
307: --
308: l_rec :=
309: pqp_ert_shd.convert_args
310: (p_exception_report_id
311: ,p_exception_report_name
312: ,p_language
313: ,p_source_lang