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.AMW_SETUP_RISK_TYPES_PVT dependencies on FND_API

Line 43: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

39: -- for the specified risk type and its descendant.
40: -- ===============================================================
41: PROCEDURE Delete_Risk_Types(
42: p_setup_risk_type_id IN NUMBER,
43: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
44: p_commit IN VARCHAR2 := FND_API.G_FALSE,
45: p_validate_only IN VARCHAR2 := FND_API.G_FALSE,
46: x_return_status OUT NOCOPY VARCHAR2,
47: x_msg_count OUT NOCOPY NUMBER,

Line 44: p_commit IN VARCHAR2 := FND_API.G_FALSE,

40: -- ===============================================================
41: PROCEDURE Delete_Risk_Types(
42: p_setup_risk_type_id IN NUMBER,
43: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
44: p_commit IN VARCHAR2 := FND_API.G_FALSE,
45: p_validate_only IN VARCHAR2 := FND_API.G_FALSE,
46: x_return_status OUT NOCOPY VARCHAR2,
47: x_msg_count OUT NOCOPY NUMBER,
48: x_msg_data OUT NOCOPY VARCHAR2

Line 45: p_validate_only IN VARCHAR2 := FND_API.G_FALSE,

41: PROCEDURE Delete_Risk_Types(
42: p_setup_risk_type_id IN NUMBER,
43: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
44: p_commit IN VARCHAR2 := FND_API.G_FALSE,
45: p_validate_only IN VARCHAR2 := FND_API.G_FALSE,
46: x_return_status OUT NOCOPY VARCHAR2,
47: x_msg_count OUT NOCOPY NUMBER,
48: x_msg_data OUT NOCOPY VARCHAR2
49: )IS

Line 59: IF p_commit = FND_API.G_TRUE THEN

55: i NUMBER;
56:
57: BEGIN
58: -- create savepoint if p_commit is true
59: IF p_commit = FND_API.G_TRUE THEN
60: SAVEPOINT Delete_Risk_Types_Save;
61: END IF;
62:
63: -- initialize message list if p_init_msg_list is set to true

Line 64: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then

60: SAVEPOINT Delete_Risk_Types_Save;
61: END IF;
62:
63: -- initialize message list if p_init_msg_list is set to true
64: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
65: fnd_msg_pub.initialize;
66: end if;
67:
68: l_setup_risk_type_id := p_setup_risk_type_id;

Line 101: WHEN FND_API.G_EXC_ERROR THEN

97:
98: END IF; -- end of if: l_risk_type_list
99:
100: EXCEPTION
101: WHEN FND_API.G_EXC_ERROR THEN
102: IF p_commit = FND_API.G_TRUE THEN
103: ROLLBACK TO Delete_Risk_Types_Save;
104: END IF;
105:

Line 102: IF p_commit = FND_API.G_TRUE THEN

98: END IF; -- end of if: l_risk_type_list
99:
100: EXCEPTION
101: WHEN FND_API.G_EXC_ERROR THEN
102: IF p_commit = FND_API.G_TRUE THEN
103: ROLLBACK TO Delete_Risk_Types_Save;
104: END IF;
105:
106: x_return_status := FND_API.G_RET_STS_ERROR;

Line 106: x_return_status := FND_API.G_RET_STS_ERROR;

102: IF p_commit = FND_API.G_TRUE THEN
103: ROLLBACK TO Delete_Risk_Types_Save;
104: END IF;
105:
106: x_return_status := FND_API.G_RET_STS_ERROR;
107:
108: fnd_msg_pub.count_and_get(p_count => x_msg_count,
109: p_data => x_msg_data);
110:

Line 112: IF p_commit = FND_API.G_TRUE THEN

108: fnd_msg_pub.count_and_get(p_count => x_msg_count,
109: p_data => x_msg_data);
110:
111: WHEN OTHERS THEN
112: IF p_commit = FND_API.G_TRUE THEN
113: ROLLBACK TO Delete_Risk_Types_Save;
114: END IF;
115:
116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

112: IF p_commit = FND_API.G_TRUE THEN
113: ROLLBACK TO Delete_Risk_Types_Save;
114: END IF;
115:
116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
117:
118: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AMW_SETUP_RISK_TYPES_PVT',
119: p_procedure_name => 'Delete_Risk_Types',
120: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 142: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

138: -- ===============================================================
139: PROCEDURE InValidate_Risk_Types(
140: p_setup_risk_type_id IN NUMBER,
141: p_end_date IN DATE,
142: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
143: p_commit IN VARCHAR2 := FND_API.G_FALSE,
144: p_validate_only IN VARCHAR2 := FND_API.G_FALSE,
145: x_return_status OUT NOCOPY VARCHAR2,
146: x_msg_count OUT NOCOPY NUMBER,

Line 143: p_commit IN VARCHAR2 := FND_API.G_FALSE,

139: PROCEDURE InValidate_Risk_Types(
140: p_setup_risk_type_id IN NUMBER,
141: p_end_date IN DATE,
142: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
143: p_commit IN VARCHAR2 := FND_API.G_FALSE,
144: p_validate_only IN VARCHAR2 := FND_API.G_FALSE,
145: x_return_status OUT NOCOPY VARCHAR2,
146: x_msg_count OUT NOCOPY NUMBER,
147: x_msg_data OUT NOCOPY VARCHAR2

Line 144: p_validate_only IN VARCHAR2 := FND_API.G_FALSE,

140: p_setup_risk_type_id IN NUMBER,
141: p_end_date IN DATE,
142: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
143: p_commit IN VARCHAR2 := FND_API.G_FALSE,
144: p_validate_only IN VARCHAR2 := FND_API.G_FALSE,
145: x_return_status OUT NOCOPY VARCHAR2,
146: x_msg_count OUT NOCOPY NUMBER,
147: x_msg_data OUT NOCOPY VARCHAR2
148: ) IS

Line 159: IF p_commit = FND_API.G_TRUE THEN

155: i NUMBER;
156:
157: BEGIN
158: -- create savepoint if p_commit is true
159: IF p_commit = FND_API.G_TRUE THEN
160: SAVEPOINT InValidate_Risk_Types_Save;
161: END IF;
162:
163: -- initialize message list if p_init_msg_list is set to true

Line 164: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then

160: SAVEPOINT InValidate_Risk_Types_Save;
161: END IF;
162:
163: -- initialize message list if p_init_msg_list is set to true
164: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
165: fnd_msg_pub.initialize;
166: end if;
167:
168: -- initialize return status to success

Line 169: x_return_status := fnd_api.g_ret_sts_success;

165: fnd_msg_pub.initialize;
166: end if;
167:
168: -- initialize return status to success
169: x_return_status := fnd_api.g_ret_sts_success;
170:
171:
172: l_setup_risk_type_id := p_setup_risk_type_id;
173: l_risk_type_list := GET_ALL_DESCENDANTS(l_setup_risk_type_id);

Line 193: WHEN FND_API.G_EXC_ERROR THEN

189: END LOOP; -- end of for
190: END IF; -- end of if: l_risk_type_list
191:
192: EXCEPTION
193: WHEN FND_API.G_EXC_ERROR THEN
194: IF p_commit = FND_API.G_TRUE THEN
195: ROLLBACK TO InValidate_Risk_Types_Save;
196: END IF;
197:

Line 194: IF p_commit = FND_API.G_TRUE THEN

190: END IF; -- end of if: l_risk_type_list
191:
192: EXCEPTION
193: WHEN FND_API.G_EXC_ERROR THEN
194: IF p_commit = FND_API.G_TRUE THEN
195: ROLLBACK TO InValidate_Risk_Types_Save;
196: END IF;
197:
198: x_return_status := FND_API.G_RET_STS_ERROR;

Line 198: x_return_status := FND_API.G_RET_STS_ERROR;

194: IF p_commit = FND_API.G_TRUE THEN
195: ROLLBACK TO InValidate_Risk_Types_Save;
196: END IF;
197:
198: x_return_status := FND_API.G_RET_STS_ERROR;
199:
200: fnd_msg_pub.count_and_get(p_count => x_msg_count,
201: p_data => x_msg_data);
202:

Line 204: IF p_commit = FND_API.G_TRUE THEN

200: fnd_msg_pub.count_and_get(p_count => x_msg_count,
201: p_data => x_msg_data);
202:
203: WHEN OTHERS THEN
204: IF p_commit = FND_API.G_TRUE THEN
205: ROLLBACK TO InValidate_Risk_Types_Save;
206: END IF;
207:
208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

204: IF p_commit = FND_API.G_TRUE THEN
205: ROLLBACK TO InValidate_Risk_Types_Save;
206: END IF;
207:
208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
209:
210: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AMW_SETUP_RISK_TYPES_PVT',
211: p_procedure_name => 'InValidate_Risk_Types',
212: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 364: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

360: -- Update the risk-riskTypes associations(store in table AMW_RISK_TYPE)
361: -- depending on the specified p_select_flag .
362: -- ===============================================================
363: PROCEDURE PROCESS_RISK_TYPE_ASSOCS (
364: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
365: p_commit IN VARCHAR2 := FND_API.G_FALSE,
366: p_validate_only IN VARCHAR2 := FND_API.G_FALSE,
367: p_select_flag IN VARCHAR2,
368: p_risk_rev_id IN NUMBER,

Line 365: p_commit IN VARCHAR2 := FND_API.G_FALSE,

361: -- depending on the specified p_select_flag .
362: -- ===============================================================
363: PROCEDURE PROCESS_RISK_TYPE_ASSOCS (
364: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
365: p_commit IN VARCHAR2 := FND_API.G_FALSE,
366: p_validate_only IN VARCHAR2 := FND_API.G_FALSE,
367: p_select_flag IN VARCHAR2,
368: p_risk_rev_id IN NUMBER,
369: p_risk_type_code IN VARCHAR2,

Line 366: p_validate_only IN VARCHAR2 := FND_API.G_FALSE,

362: -- ===============================================================
363: PROCEDURE PROCESS_RISK_TYPE_ASSOCS (
364: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
365: p_commit IN VARCHAR2 := FND_API.G_FALSE,
366: p_validate_only IN VARCHAR2 := FND_API.G_FALSE,
367: p_select_flag IN VARCHAR2,
368: p_risk_rev_id IN NUMBER,
369: p_risk_type_code IN VARCHAR2,
370: x_return_status OUT NOCOPY VARCHAR2,

Line 386: IF p_commit = FND_API.G_TRUE THEN

382:
383: BEGIN
384:
385: -- create savepoint if p_commit is true
386: IF p_commit = FND_API.G_TRUE THEN
387: SAVEPOINT setup_risk_type_assoc_save;
388: END IF;
389:
390: -- initialize message list if p_init_msg_list is set to true

Line 391: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then

387: SAVEPOINT setup_risk_type_assoc_save;
388: END IF;
389:
390: -- initialize message list if p_init_msg_list is set to true
391: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
392: fnd_msg_pub.initialize;
393: end if;
394:
395: -- initialize return status to success

Line 396: x_return_status := fnd_api.g_ret_sts_success;

392: fnd_msg_pub.initialize;
393: end if;
394:
395: -- initialize return status to success
396: x_return_status := fnd_api.g_ret_sts_success;
397:
398: delete from amw_risk_type
399: where risk_rev_id = p_risk_rev_id
400: and risk_type_code = p_risk_type_code;

Line 433: WHEN FND_API.G_EXC_ERROR THEN

429: l_object_version_number);
430:
431: end if;
432: EXCEPTION
433: WHEN FND_API.G_EXC_ERROR THEN
434: IF p_commit = FND_API.G_TRUE THEN
435: ROLLBACK TO setup_risk_type_assoc_save;
436: END IF;
437:

Line 434: IF p_commit = FND_API.G_TRUE THEN

430:
431: end if;
432: EXCEPTION
433: WHEN FND_API.G_EXC_ERROR THEN
434: IF p_commit = FND_API.G_TRUE THEN
435: ROLLBACK TO setup_risk_type_assoc_save;
436: END IF;
437:
438: x_return_status := FND_API.G_RET_STS_ERROR;

Line 438: x_return_status := FND_API.G_RET_STS_ERROR;

434: IF p_commit = FND_API.G_TRUE THEN
435: ROLLBACK TO setup_risk_type_assoc_save;
436: END IF;
437:
438: x_return_status := FND_API.G_RET_STS_ERROR;
439:
440: fnd_msg_pub.count_and_get(p_count => x_msg_count,
441: p_data => x_msg_data);
442:

Line 444: IF p_commit = FND_API.G_TRUE THEN

440: fnd_msg_pub.count_and_get(p_count => x_msg_count,
441: p_data => x_msg_data);
442:
443: WHEN OTHERS THEN
444: IF p_commit = FND_API.G_TRUE THEN
445: ROLLBACK TO setup_risk_type_assoc_save;
446: END IF;
447:
448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

444: IF p_commit = FND_API.G_TRUE THEN
445: ROLLBACK TO setup_risk_type_assoc_save;
446: END IF;
447:
448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
449:
450: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AMW_SETUP_RISK_TYPES_PVT',
451: p_procedure_name => 'PROCESS_RISK_TYPE_ASSOCS',
452: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 714: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

710: -- p_setup_risk_type and its descendants
711: -- are currently associated with risks in ame_risk_type table.
712: -- ===============================================================
713: PROCEDURE IS_ASSOC_TO_RISK (
714: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
715: p_commit IN VARCHAR2 := FND_API.G_FALSE,
716: p_validate_only IN VARCHAR2 := FND_API.G_FALSE,
717: p_setup_risk_type_id IN NUMBER,
718: x_is_assoc_to_risk OUT NOCOPY VARCHAR2,

Line 715: p_commit IN VARCHAR2 := FND_API.G_FALSE,

711: -- are currently associated with risks in ame_risk_type table.
712: -- ===============================================================
713: PROCEDURE IS_ASSOC_TO_RISK (
714: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
715: p_commit IN VARCHAR2 := FND_API.G_FALSE,
716: p_validate_only IN VARCHAR2 := FND_API.G_FALSE,
717: p_setup_risk_type_id IN NUMBER,
718: x_is_assoc_to_risk OUT NOCOPY VARCHAR2,
719: x_return_status OUT NOCOPY VARCHAR2,

Line 716: p_validate_only IN VARCHAR2 := FND_API.G_FALSE,

712: -- ===============================================================
713: PROCEDURE IS_ASSOC_TO_RISK (
714: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
715: p_commit IN VARCHAR2 := FND_API.G_FALSE,
716: p_validate_only IN VARCHAR2 := FND_API.G_FALSE,
717: p_setup_risk_type_id IN NUMBER,
718: x_is_assoc_to_risk OUT NOCOPY VARCHAR2,
719: x_return_status OUT NOCOPY VARCHAR2,
720: x_msg_count OUT NOCOPY NUMBER,

Line 743: IF p_commit = FND_API.G_TRUE THEN

739: and assoc.risk_type_code = rt.risk_type_code;
740:
741: BEGIN
742: -- create savepoint if p_commit is true
743: IF p_commit = FND_API.G_TRUE THEN
744: SAVEPOINT IS_ASSOC_TO_RISK_SAVE;
745: END IF;
746:
747: -- initialize message list if p_init_msg_list is set to true

Line 748: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then

744: SAVEPOINT IS_ASSOC_TO_RISK_SAVE;
745: END IF;
746:
747: -- initialize message list if p_init_msg_list is set to true
748: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
749: fnd_msg_pub.initialize;
750: end if;
751:
752: -- initialize return status to success

Line 753: x_return_status := fnd_api.g_ret_sts_success;

749: fnd_msg_pub.initialize;
750: end if;
751:
752: -- initialize return status to success
753: x_return_status := fnd_api.g_ret_sts_success;
754:
755: x_is_assoc_to_risk := 'N';
756: isAssociatedToRisk := 'N';
757: l_setup_risk_type_id := p_setup_risk_type_id;

Line 777: WHEN FND_API.G_EXC_ERROR THEN

773:
774: x_is_assoc_to_risk := isAssociatedToRisk;
775:
776: EXCEPTION
777: WHEN FND_API.G_EXC_ERROR THEN
778: IF p_commit = FND_API.G_TRUE THEN
779: ROLLBACK TO IS_ASSOC_TO_RISK_SAVE;
780: END IF;
781:

Line 778: IF p_commit = FND_API.G_TRUE THEN

774: x_is_assoc_to_risk := isAssociatedToRisk;
775:
776: EXCEPTION
777: WHEN FND_API.G_EXC_ERROR THEN
778: IF p_commit = FND_API.G_TRUE THEN
779: ROLLBACK TO IS_ASSOC_TO_RISK_SAVE;
780: END IF;
781:
782: x_return_status := FND_API.G_RET_STS_ERROR;

Line 782: x_return_status := FND_API.G_RET_STS_ERROR;

778: IF p_commit = FND_API.G_TRUE THEN
779: ROLLBACK TO IS_ASSOC_TO_RISK_SAVE;
780: END IF;
781:
782: x_return_status := FND_API.G_RET_STS_ERROR;
783:
784: fnd_msg_pub.count_and_get(p_count => x_msg_count,
785: p_data => x_msg_data);
786:

Line 788: IF p_commit = FND_API.G_TRUE THEN

784: fnd_msg_pub.count_and_get(p_count => x_msg_count,
785: p_data => x_msg_data);
786:
787: WHEN OTHERS THEN
788: IF p_commit = FND_API.G_TRUE THEN
789: ROLLBACK TO IS_ASSOC_TO_RISK_SAVE;
790: END IF;
791:
792: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 792: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

788: IF p_commit = FND_API.G_TRUE THEN
789: ROLLBACK TO IS_ASSOC_TO_RISK_SAVE;
790: END IF;
791:
792: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
793:
794: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AMW_SETUP_RISK_TYPES_PVT',
795: p_procedure_name => 'Delete_Risk_Types',
796: p_error_text => SUBSTRB(SQLERRM,1,240));