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.ASO_SECURITY_INT dependencies on ASO_DEBUG_PUB

Line 49: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

45:
46: BEGIN
47:
48:
49: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
50:
51:
52: -- API body
53: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 53: IF aso_debug_pub.g_debug_flag = 'Y' THEN

49: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
50:
51:
52: -- API body
53: IF aso_debug_pub.g_debug_flag = 'Y' THEN
54: aso_debug_pub.add('ASO_SECURITY_INT: ****** Start of Get_Quote_Access API ******', 1, 'Y');
55: END IF;
56: l_access_level := 'NONE';
57: l_profile_access := 'N';

Line 54: aso_debug_pub.add('ASO_SECURITY_INT: Start of Get_Quote_Access API ', 1, 'Y');

50:
51:
52: -- API body
53: IF aso_debug_pub.g_debug_flag = 'Y' THEN
54: aso_debug_pub.add('ASO_SECURITY_INT: ****** Start of Get_Quote_Access API ******', 1, 'Y');
55: END IF;
56: l_access_level := 'NONE';
57: l_profile_access := 'N';
58:

Line 59: IF aso_debug_pub.g_debug_flag = 'Y' THEN

55: END IF;
56: l_access_level := 'NONE';
57: l_profile_access := 'N';
58:
59: IF aso_debug_pub.g_debug_flag = 'Y' THEN
60: aso_debug_pub.add('ASO_SECURITY_INT: Get_Quote_Access: P_RESOURCE_ID: ' || P_RESOURCE_ID, 1, 'Y');
61: aso_debug_pub.add('ASO_SECURITY_INT: Get_Quote_Access: P_QUOTE_NUMBER: ' || P_QUOTE_NUMBER, 1, 'Y');
62: END IF;
63:

Line 60: aso_debug_pub.add('ASO_SECURITY_INT: Get_Quote_Access: P_RESOURCE_ID: ' || P_RESOURCE_ID, 1, 'Y');

56: l_access_level := 'NONE';
57: l_profile_access := 'N';
58:
59: IF aso_debug_pub.g_debug_flag = 'Y' THEN
60: aso_debug_pub.add('ASO_SECURITY_INT: Get_Quote_Access: P_RESOURCE_ID: ' || P_RESOURCE_ID, 1, 'Y');
61: aso_debug_pub.add('ASO_SECURITY_INT: Get_Quote_Access: P_QUOTE_NUMBER: ' || P_QUOTE_NUMBER, 1, 'Y');
62: END IF;
63:
64: FOR c_direct_access_rec IN C_direct_access(p_quote_number, p_resource_id) LOOP

Line 61: aso_debug_pub.add('ASO_SECURITY_INT: Get_Quote_Access: P_QUOTE_NUMBER: ' || P_QUOTE_NUMBER, 1, 'Y');

57: l_profile_access := 'N';
58:
59: IF aso_debug_pub.g_debug_flag = 'Y' THEN
60: aso_debug_pub.add('ASO_SECURITY_INT: Get_Quote_Access: P_RESOURCE_ID: ' || P_RESOURCE_ID, 1, 'Y');
61: aso_debug_pub.add('ASO_SECURITY_INT: Get_Quote_Access: P_QUOTE_NUMBER: ' || P_QUOTE_NUMBER, 1, 'Y');
62: END IF;
63:
64: FOR c_direct_access_rec IN C_direct_access(p_quote_number, p_resource_id) LOOP
65: IF c_direct_access_rec.update_access_flag = 'Y' THEN

Line 67: IF aso_debug_pub.g_debug_flag = 'Y' THEN

63:
64: FOR c_direct_access_rec IN C_direct_access(p_quote_number, p_resource_id) LOOP
65: IF c_direct_access_rec.update_access_flag = 'Y' THEN
66:
67: IF aso_debug_pub.g_debug_flag = 'Y' THEN
68: aso_debug_pub.add('ASO_SECURITY_INT: Get_Quote_Access: resource has direct UPDATE access', 1, 'Y');
69: END IF;
70:
71: RETURN 'UPDATE';

Line 68: aso_debug_pub.add('ASO_SECURITY_INT: Get_Quote_Access: resource has direct UPDATE access', 1, 'Y');

64: FOR c_direct_access_rec IN C_direct_access(p_quote_number, p_resource_id) LOOP
65: IF c_direct_access_rec.update_access_flag = 'Y' THEN
66:
67: IF aso_debug_pub.g_debug_flag = 'Y' THEN
68: aso_debug_pub.add('ASO_SECURITY_INT: Get_Quote_Access: resource has direct UPDATE access', 1, 'Y');
69: END IF;
70:
71: RETURN 'UPDATE';
72: ELSE

Line 73: IF aso_debug_pub.g_debug_flag = 'Y' THEN

69: END IF;
70:
71: RETURN 'UPDATE';
72: ELSE
73: IF aso_debug_pub.g_debug_flag = 'Y' THEN
74: aso_debug_pub.add('ASO_SECURITY_INT: Get_Quote_Access: resource has direct READ access', 1, 'Y');
75: END IF;
76: l_access_level := 'READ';
77: END IF;

Line 74: aso_debug_pub.add('ASO_SECURITY_INT: Get_Quote_Access: resource has direct READ access', 1, 'Y');

70:
71: RETURN 'UPDATE';
72: ELSE
73: IF aso_debug_pub.g_debug_flag = 'Y' THEN
74: aso_debug_pub.add('ASO_SECURITY_INT: Get_Quote_Access: resource has direct READ access', 1, 'Y');
75: END IF;
76: l_access_level := 'READ';
77: END IF;
78: END LOOP;

Line 85: IF aso_debug_pub.g_debug_flag = 'Y' THEN

81: l_profile_access := 'Y';
82: END IF;
83:
84: FOR c_manager_access_rec IN C_manager_access(p_resource_id, p_quote_number) LOOP
85: IF aso_debug_pub.g_debug_flag = 'Y' THEN
86: aso_debug_pub.add('ASO_SECURITY_INT: Get_Quote_Access: resource is manager', 1, 'Y');
87: END IF;
88:
89: l_access_level := 'READ';

Line 86: aso_debug_pub.add('ASO_SECURITY_INT: Get_Quote_Access: resource is manager', 1, 'Y');

82: END IF;
83:
84: FOR c_manager_access_rec IN C_manager_access(p_resource_id, p_quote_number) LOOP
85: IF aso_debug_pub.g_debug_flag = 'Y' THEN
86: aso_debug_pub.add('ASO_SECURITY_INT: Get_Quote_Access: resource is manager', 1, 'Y');
87: END IF;
88:
89: l_access_level := 'READ';
90: IF l_profile_access = 'Y' OR c_manager_access_rec.UPDATE_ACCESS_FLAG = 'Y' THEN

Line 91: IF aso_debug_pub.g_debug_flag = 'Y' THEN

87: END IF;
88:
89: l_access_level := 'READ';
90: IF l_profile_access = 'Y' OR c_manager_access_rec.UPDATE_ACCESS_FLAG = 'Y' THEN
91: IF aso_debug_pub.g_debug_flag = 'Y' THEN
92: aso_debug_pub.add('ASO_SECURITY_INT: Get_Quote_Access: resource has profile UPDATE access OR subordinate of resource has direct UPDATE access', 1, 'Y');
93: aso_debug_pub.add('ASO_SECURITY_INT: Get_Quote_Access: profile access: ' || l_profile_access, 1, 'Y');
94: aso_debug_pub.add('ASO_SECURITY_INT: Get_Quote_Access: subordinate access: ' || c_manager_access_rec.UPDATE_ACCESS_FLAG, 1, 'Y');
95: END IF;

Line 92: aso_debug_pub.add('ASO_SECURITY_INT: Get_Quote_Access: resource has profile UPDATE access OR subordinate of resource has direct UPDATE access', 1, 'Y');

88:
89: l_access_level := 'READ';
90: IF l_profile_access = 'Y' OR c_manager_access_rec.UPDATE_ACCESS_FLAG = 'Y' THEN
91: IF aso_debug_pub.g_debug_flag = 'Y' THEN
92: aso_debug_pub.add('ASO_SECURITY_INT: Get_Quote_Access: resource has profile UPDATE access OR subordinate of resource has direct UPDATE access', 1, 'Y');
93: aso_debug_pub.add('ASO_SECURITY_INT: Get_Quote_Access: profile access: ' || l_profile_access, 1, 'Y');
94: aso_debug_pub.add('ASO_SECURITY_INT: Get_Quote_Access: subordinate access: ' || c_manager_access_rec.UPDATE_ACCESS_FLAG, 1, 'Y');
95: END IF;
96:

Line 93: aso_debug_pub.add('ASO_SECURITY_INT: Get_Quote_Access: profile access: ' || l_profile_access, 1, 'Y');

89: l_access_level := 'READ';
90: IF l_profile_access = 'Y' OR c_manager_access_rec.UPDATE_ACCESS_FLAG = 'Y' THEN
91: IF aso_debug_pub.g_debug_flag = 'Y' THEN
92: aso_debug_pub.add('ASO_SECURITY_INT: Get_Quote_Access: resource has profile UPDATE access OR subordinate of resource has direct UPDATE access', 1, 'Y');
93: aso_debug_pub.add('ASO_SECURITY_INT: Get_Quote_Access: profile access: ' || l_profile_access, 1, 'Y');
94: aso_debug_pub.add('ASO_SECURITY_INT: Get_Quote_Access: subordinate access: ' || c_manager_access_rec.UPDATE_ACCESS_FLAG, 1, 'Y');
95: END IF;
96:
97: RETURN 'UPDATE';

Line 94: aso_debug_pub.add('ASO_SECURITY_INT: Get_Quote_Access: subordinate access: ' || c_manager_access_rec.UPDATE_ACCESS_FLAG, 1, 'Y');

90: IF l_profile_access = 'Y' OR c_manager_access_rec.UPDATE_ACCESS_FLAG = 'Y' THEN
91: IF aso_debug_pub.g_debug_flag = 'Y' THEN
92: aso_debug_pub.add('ASO_SECURITY_INT: Get_Quote_Access: resource has profile UPDATE access OR subordinate of resource has direct UPDATE access', 1, 'Y');
93: aso_debug_pub.add('ASO_SECURITY_INT: Get_Quote_Access: profile access: ' || l_profile_access, 1, 'Y');
94: aso_debug_pub.add('ASO_SECURITY_INT: Get_Quote_Access: subordinate access: ' || c_manager_access_rec.UPDATE_ACCESS_FLAG, 1, 'Y');
95: END IF;
96:
97: RETURN 'UPDATE';
98: END IF;

Line 102: IF aso_debug_pub.g_debug_flag = 'Y' THEN

98: END IF;
99: END LOOP;
100:
101: -- End of API body
102: IF aso_debug_pub.g_debug_flag = 'Y' THEN
103: aso_debug_pub.add('ASO_SECURITY_INT: Get_Quote_Access: End of API body', 1, 'Y');
104: END IF;
105: RETURN l_access_level;
106:

Line 103: aso_debug_pub.add('ASO_SECURITY_INT: Get_Quote_Access: End of API body', 1, 'Y');

99: END LOOP;
100:
101: -- End of API body
102: IF aso_debug_pub.g_debug_flag = 'Y' THEN
103: aso_debug_pub.add('ASO_SECURITY_INT: Get_Quote_Access: End of API body', 1, 'Y');
104: END IF;
105: RETURN l_access_level;
106:
107: END Get_Quote_Access;

Line 180: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

176:
177: -- Initialize API return status to success
178: x_return_status := FND_API.G_RET_STS_SUCCESS;
179:
180: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
181: IF aso_debug_pub.g_debug_flag = 'Y' THEN
182: aso_debug_pub.add('ASO_SECURITY_INT: ****** Start of Add_Resource API ******', 1, 'Y');
183: aso_debug_pub.add('Add_Resource: p_call_from_oafwk_flag: ' || p_call_from_oafwk_flag);
184: aso_debug_pub.add('Add_Resource: p_qte_access_tbl.count: ' || p_qte_access_tbl.count);

Line 181: IF aso_debug_pub.g_debug_flag = 'Y' THEN

177: -- Initialize API return status to success
178: x_return_status := FND_API.G_RET_STS_SUCCESS;
179:
180: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
181: IF aso_debug_pub.g_debug_flag = 'Y' THEN
182: aso_debug_pub.add('ASO_SECURITY_INT: ****** Start of Add_Resource API ******', 1, 'Y');
183: aso_debug_pub.add('Add_Resource: p_call_from_oafwk_flag: ' || p_call_from_oafwk_flag);
184: aso_debug_pub.add('Add_Resource: p_qte_access_tbl.count: ' || p_qte_access_tbl.count);
185: END IF;

Line 182: aso_debug_pub.add('ASO_SECURITY_INT: Start of Add_Resource API ', 1, 'Y');

178: x_return_status := FND_API.G_RET_STS_SUCCESS;
179:
180: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
181: IF aso_debug_pub.g_debug_flag = 'Y' THEN
182: aso_debug_pub.add('ASO_SECURITY_INT: ****** Start of Add_Resource API ******', 1, 'Y');
183: aso_debug_pub.add('Add_Resource: p_call_from_oafwk_flag: ' || p_call_from_oafwk_flag);
184: aso_debug_pub.add('Add_Resource: p_qte_access_tbl.count: ' || p_qte_access_tbl.count);
185: END IF;
186:

Line 183: aso_debug_pub.add('Add_Resource: p_call_from_oafwk_flag: ' || p_call_from_oafwk_flag);

179:
180: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
181: IF aso_debug_pub.g_debug_flag = 'Y' THEN
182: aso_debug_pub.add('ASO_SECURITY_INT: ****** Start of Add_Resource API ******', 1, 'Y');
183: aso_debug_pub.add('Add_Resource: p_call_from_oafwk_flag: ' || p_call_from_oafwk_flag);
184: aso_debug_pub.add('Add_Resource: p_qte_access_tbl.count: ' || p_qte_access_tbl.count);
185: END IF;
186:
187: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 184: aso_debug_pub.add('Add_Resource: p_qte_access_tbl.count: ' || p_qte_access_tbl.count);

180: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
181: IF aso_debug_pub.g_debug_flag = 'Y' THEN
182: aso_debug_pub.add('ASO_SECURITY_INT: ****** Start of Add_Resource API ******', 1, 'Y');
183: aso_debug_pub.add('Add_Resource: p_call_from_oafwk_flag: ' || p_call_from_oafwk_flag);
184: aso_debug_pub.add('Add_Resource: p_qte_access_tbl.count: ' || p_qte_access_tbl.count);
185: END IF;
186:
187: -- Initialize message list if p_init_msg_list is set to TRUE.
188: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 228: IF aso_debug_pub.g_debug_flag = 'Y' THEN

224: end if;
225:
226: IF l_qte_access_tbl(i).access_id IS NOT NULL AND l_qte_access_tbl(i).access_id <> FND_API.G_MISS_NUM THEN
227:
228: IF aso_debug_pub.g_debug_flag = 'Y' THEN
229: aso_debug_pub.add('Add_Resource: LOOP for access_id: ' || l_qte_access_tbl(i).access_id);
230: END IF;
231:
232: if (nvl(p_call_from_oafwk_flag, 'N') = fnd_api.g_false)

Line 229: aso_debug_pub.add('Add_Resource: LOOP for access_id: ' || l_qte_access_tbl(i).access_id);

225:
226: IF l_qte_access_tbl(i).access_id IS NOT NULL AND l_qte_access_tbl(i).access_id <> FND_API.G_MISS_NUM THEN
227:
228: IF aso_debug_pub.g_debug_flag = 'Y' THEN
229: aso_debug_pub.add('Add_Resource: LOOP for access_id: ' || l_qte_access_tbl(i).access_id);
230: END IF;
231:
232: if (nvl(p_call_from_oafwk_flag, 'N') = fnd_api.g_false)
233: OR ((nvl(p_call_from_oafwk_flag, 'N') = fnd_api.g_true) and (l_qte_access_tbl(i).operation_code = 'UPDATE')) then

Line 265: IF aso_debug_pub.g_debug_flag = 'Y' THEN

261: IF l_qte_access_tbl(i).quote_number IS NOT NULL AND l_qte_access_tbl(i).quote_number <> FND_API.G_MISS_NUM THEN
262:
263: IF l_qte_access_tbl(i).resource_id IS NOT NULL AND l_qte_access_tbl(i).resource_id <> FND_API.G_MISS_NUM THEN
264:
265: IF aso_debug_pub.g_debug_flag = 'Y' THEN
266: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: LOOP for resource_id: ' || l_qte_access_tbl(i).resource_id, 1, 'Y');
267: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: LOOP for quote_number: ' || l_qte_access_tbl(i).quote_number, 1, 'Y');
268: END IF;
269:

Line 266: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: LOOP for resource_id: ' || l_qte_access_tbl(i).resource_id, 1, 'Y');

262:
263: IF l_qte_access_tbl(i).resource_id IS NOT NULL AND l_qte_access_tbl(i).resource_id <> FND_API.G_MISS_NUM THEN
264:
265: IF aso_debug_pub.g_debug_flag = 'Y' THEN
266: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: LOOP for resource_id: ' || l_qte_access_tbl(i).resource_id, 1, 'Y');
267: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: LOOP for quote_number: ' || l_qte_access_tbl(i).quote_number, 1, 'Y');
268: END IF;
269:
270: FOR l_access_rec IN C_existing_resource(l_qte_access_tbl(i).quote_number, l_qte_access_tbl(i).resource_id) LOOP

Line 267: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: LOOP for quote_number: ' || l_qte_access_tbl(i).quote_number, 1, 'Y');

263: IF l_qte_access_tbl(i).resource_id IS NOT NULL AND l_qte_access_tbl(i).resource_id <> FND_API.G_MISS_NUM THEN
264:
265: IF aso_debug_pub.g_debug_flag = 'Y' THEN
266: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: LOOP for resource_id: ' || l_qte_access_tbl(i).resource_id, 1, 'Y');
267: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: LOOP for quote_number: ' || l_qte_access_tbl(i).quote_number, 1, 'Y');
268: END IF;
269:
270: FOR l_access_rec IN C_existing_resource(l_qte_access_tbl(i).quote_number, l_qte_access_tbl(i).resource_id) LOOP
271: l_qte_access_tbl(i).access_id := l_access_rec.access_id;

Line 279: IF aso_debug_pub.g_debug_flag = 'Y' THEN

275: END IF;
276: END IF;
277: END IF;
278:
279: IF aso_debug_pub.g_debug_flag = 'Y' THEN
280: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: l_access_id: ' || l_access_id, 1, 'Y');
281: END IF;
282:
283: IF nvl(p_call_from_oafwk_flag, 'N') = fnd_api.g_false THEN

Line 280: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: l_access_id: ' || l_access_id, 1, 'Y');

276: END IF;
277: END IF;
278:
279: IF aso_debug_pub.g_debug_flag = 'Y' THEN
280: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: l_access_id: ' || l_access_id, 1, 'Y');
281: END IF;
282:
283: IF nvl(p_call_from_oafwk_flag, 'N') = fnd_api.g_false THEN
284:

Line 294: IF aso_debug_pub.g_debug_flag = 'Y' THEN

290: END IF;
291:
292: END IF;
293:
294: IF aso_debug_pub.g_debug_flag = 'Y' THEN
295: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: l_qte_access_tbl(i).operation_code: ' || l_qte_access_tbl(i).operation_code, 1, 'Y');
296: END IF;
297:
298: IF l_qte_access_tbl(i).operation_code = 'CREATE' THEN

Line 295: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: l_qte_access_tbl(i).operation_code: ' || l_qte_access_tbl(i).operation_code, 1, 'Y');

291:
292: END IF;
293:
294: IF aso_debug_pub.g_debug_flag = 'Y' THEN
295: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: l_qte_access_tbl(i).operation_code: ' || l_qte_access_tbl(i).operation_code, 1, 'Y');
296: END IF;
297:
298: IF l_qte_access_tbl(i).operation_code = 'CREATE' THEN
299:

Line 306: IF aso_debug_pub.g_debug_flag = 'Y' THEN

302: FETCH C_existing_resource INTO l_exist_access_id;
303: IF C_existing_resource%FOUND THEN
304: x_return_status := fnd_api.g_ret_sts_error;
305:
306: IF aso_debug_pub.g_debug_flag = 'Y' THEN
307: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: duplicate resource: ' || l_exist_access_id, 1, 'Y');
308: END IF;
309: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
310: FND_MESSAGE.Set_Name('ASO', 'ASO_DUPLICATE_RESOURCE_ID');

Line 307: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: duplicate resource: ' || l_exist_access_id, 1, 'Y');

303: IF C_existing_resource%FOUND THEN
304: x_return_status := fnd_api.g_ret_sts_error;
305:
306: IF aso_debug_pub.g_debug_flag = 'Y' THEN
307: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: duplicate resource: ' || l_exist_access_id, 1, 'Y');
308: END IF;
309: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
310: FND_MESSAGE.Set_Name('ASO', 'ASO_DUPLICATE_RESOURCE_ID');
311: FND_MSG_PUB.Add;

Line 323: IF aso_debug_pub.g_debug_flag = 'Y' THEN

319: -- 4535602
320:
321: l_quote_number := l_qte_access_tbl(i).QUOTE_NUMBER;
322:
323: IF aso_debug_pub.g_debug_flag = 'Y' THEN
324: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: before Insert_Row: counter: ' || i, 1, 'Y');
325: END IF;
326:
327: ASO_QUOTE_ACCESSES_PKG.Insert_Row(

Line 324: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: before Insert_Row: counter: ' || i, 1, 'Y');

320:
321: l_quote_number := l_qte_access_tbl(i).QUOTE_NUMBER;
322:
323: IF aso_debug_pub.g_debug_flag = 'Y' THEN
324: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: before Insert_Row: counter: ' || i, 1, 'Y');
325: END IF;
326:
327: ASO_QUOTE_ACCESSES_PKG.Insert_Row(
328: px_ACCESS_ID => l_qte_access_tbl(i).access_id,

Line 373: IF aso_debug_pub.g_debug_flag = 'Y' THEN

369: );
370:
371: X_Qte_Access_Tbl(i).access_id := l_qte_access_tbl(i).access_id;
372:
373: IF aso_debug_pub.g_debug_flag = 'Y' THEN
374: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: after Insert_Row: x_qte_access_tbl('||i||').access_id: ' || x_qte_access_tbl(i).access_id, 1, 'Y');
375: END IF;
376:
377: ELSIF l_qte_access_tbl(i).operation_code = 'UPDATE' THEN

Line 374: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: after Insert_Row: x_qte_access_tbl('||i||').access_id: ' || x_qte_access_tbl(i).access_id, 1, 'Y');

370:
371: X_Qte_Access_Tbl(i).access_id := l_qte_access_tbl(i).access_id;
372:
373: IF aso_debug_pub.g_debug_flag = 'Y' THEN
374: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: after Insert_Row: x_qte_access_tbl('||i||').access_id: ' || x_qte_access_tbl(i).access_id, 1, 'Y');
375: END IF;
376:
377: ELSIF l_qte_access_tbl(i).operation_code = 'UPDATE' THEN
378:

Line 379: IF aso_debug_pub.g_debug_flag = 'Y' THEN

375: END IF;
376:
377: ELSIF l_qte_access_tbl(i).operation_code = 'UPDATE' THEN
378:
379: IF aso_debug_pub.g_debug_flag = 'Y' THEN
380: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: before Update_Row: counter: ' || i, 1, 'Y');
381: END IF;
382:
383: ASO_QUOTE_ACCESSES_PKG.Update_Row(

Line 380: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: before Update_Row: counter: ' || i, 1, 'Y');

376:
377: ELSIF l_qte_access_tbl(i).operation_code = 'UPDATE' THEN
378:
379: IF aso_debug_pub.g_debug_flag = 'Y' THEN
380: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: before Update_Row: counter: ' || i, 1, 'Y');
381: END IF;
382:
383: ASO_QUOTE_ACCESSES_PKG.Update_Row(
384: p_ACCESS_ID => l_qte_access_tbl(i).access_id,

Line 429: IF aso_debug_pub.g_debug_flag = 'Y' THEN

425: );
426:
427: X_Qte_Access_Tbl(i).access_id := l_qte_access_tbl(i).access_id;
428:
429: IF aso_debug_pub.g_debug_flag = 'Y' THEN
430: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: after Update_Row: x_qte_access_tbl('||i||').access_id: ' || x_qte_access_tbl(i).access_id, 1, 'Y');
431: END IF;
432:
433: FOR l_resource_rec IN C_resource(l_qte_access_tbl(i).access_id) LOOP

Line 430: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: after Update_Row: x_qte_access_tbl('||i||').access_id: ' || x_qte_access_tbl(i).access_id, 1, 'Y');

426:
427: X_Qte_Access_Tbl(i).access_id := l_qte_access_tbl(i).access_id;
428:
429: IF aso_debug_pub.g_debug_flag = 'Y' THEN
430: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: after Update_Row: x_qte_access_tbl('||i||').access_id: ' || x_qte_access_tbl(i).access_id, 1, 'Y');
431: END IF;
432:
433: FOR l_resource_rec IN C_resource(l_qte_access_tbl(i).access_id) LOOP
434: l_quote_number := l_resource_rec.quote_number;

Line 439: IF aso_debug_pub.g_debug_flag = 'Y' THEN

435: l_resource_id := l_resource_rec.resource_id;
436: l_resource_grp_id := l_resource_rec.resource_grp_id;
437: l_update_access_flag := l_resource_rec.update_access_flag;
438:
439: IF aso_debug_pub.g_debug_flag = 'Y' THEN
440: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: *** C_resource LOOP variables ***', 1, 'Y');
441: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: l_quote_number: ' || l_quote_number, 1, 'Y');
442: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: l_resource_id: ' || l_resource_id, 1, 'Y');
443: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: l_resource_grp_id: ' || l_resource_grp_id, 1, 'Y');

Line 440: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: * C_resource LOOP variables *', 1, 'Y');

436: l_resource_grp_id := l_resource_rec.resource_grp_id;
437: l_update_access_flag := l_resource_rec.update_access_flag;
438:
439: IF aso_debug_pub.g_debug_flag = 'Y' THEN
440: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: *** C_resource LOOP variables ***', 1, 'Y');
441: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: l_quote_number: ' || l_quote_number, 1, 'Y');
442: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: l_resource_id: ' || l_resource_id, 1, 'Y');
443: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: l_resource_grp_id: ' || l_resource_grp_id, 1, 'Y');
444: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: l_update_access_flag: ' || l_update_access_flag, 1, 'Y');

Line 441: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: l_quote_number: ' || l_quote_number, 1, 'Y');

437: l_update_access_flag := l_resource_rec.update_access_flag;
438:
439: IF aso_debug_pub.g_debug_flag = 'Y' THEN
440: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: *** C_resource LOOP variables ***', 1, 'Y');
441: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: l_quote_number: ' || l_quote_number, 1, 'Y');
442: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: l_resource_id: ' || l_resource_id, 1, 'Y');
443: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: l_resource_grp_id: ' || l_resource_grp_id, 1, 'Y');
444: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: l_update_access_flag: ' || l_update_access_flag, 1, 'Y');
445: END IF;

Line 442: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: l_resource_id: ' || l_resource_id, 1, 'Y');

438:
439: IF aso_debug_pub.g_debug_flag = 'Y' THEN
440: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: *** C_resource LOOP variables ***', 1, 'Y');
441: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: l_quote_number: ' || l_quote_number, 1, 'Y');
442: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: l_resource_id: ' || l_resource_id, 1, 'Y');
443: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: l_resource_grp_id: ' || l_resource_grp_id, 1, 'Y');
444: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: l_update_access_flag: ' || l_update_access_flag, 1, 'Y');
445: END IF;
446: END LOOP;

Line 443: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: l_resource_grp_id: ' || l_resource_grp_id, 1, 'Y');

439: IF aso_debug_pub.g_debug_flag = 'Y' THEN
440: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: *** C_resource LOOP variables ***', 1, 'Y');
441: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: l_quote_number: ' || l_quote_number, 1, 'Y');
442: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: l_resource_id: ' || l_resource_id, 1, 'Y');
443: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: l_resource_grp_id: ' || l_resource_grp_id, 1, 'Y');
444: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: l_update_access_flag: ' || l_update_access_flag, 1, 'Y');
445: END IF;
446: END LOOP;
447:

Line 444: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: l_update_access_flag: ' || l_update_access_flag, 1, 'Y');

440: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: *** C_resource LOOP variables ***', 1, 'Y');
441: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: l_quote_number: ' || l_quote_number, 1, 'Y');
442: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: l_resource_id: ' || l_resource_id, 1, 'Y');
443: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: l_resource_grp_id: ' || l_resource_grp_id, 1, 'Y');
444: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: l_update_access_flag: ' || l_update_access_flag, 1, 'Y');
445: END IF;
446: END LOOP;
447:
448: FOR l_primary_resource_rec IN C_primary_resource(l_quote_number) LOOP

Line 453: IF aso_debug_pub.g_debug_flag = 'Y' THEN

449: l_primary_resource_id := l_primary_resource_rec.resource_id;
450: l_primary_resource_grp_id := l_primary_resource_rec.resource_grp_id;
451: l_qte_header_rec.quote_header_id := l_primary_resource_rec.quote_header_id;
452:
453: IF aso_debug_pub.g_debug_flag = 'Y' THEN
454: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: *** C_primary_resource LOOP variables ***', 1, 'Y');
455: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: l_primary_resource_id: ' || l_primary_resource_id, 1, 'Y');
456: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: l_primary_resource_grp_id: ' || l_primary_resource_grp_id, 1, 'Y');
457: END IF;

Line 454: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: * C_primary_resource LOOP variables *', 1, 'Y');

450: l_primary_resource_grp_id := l_primary_resource_rec.resource_grp_id;
451: l_qte_header_rec.quote_header_id := l_primary_resource_rec.quote_header_id;
452:
453: IF aso_debug_pub.g_debug_flag = 'Y' THEN
454: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: *** C_primary_resource LOOP variables ***', 1, 'Y');
455: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: l_primary_resource_id: ' || l_primary_resource_id, 1, 'Y');
456: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: l_primary_resource_grp_id: ' || l_primary_resource_grp_id, 1, 'Y');
457: END IF;
458:

Line 455: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: l_primary_resource_id: ' || l_primary_resource_id, 1, 'Y');

451: l_qte_header_rec.quote_header_id := l_primary_resource_rec.quote_header_id;
452:
453: IF aso_debug_pub.g_debug_flag = 'Y' THEN
454: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: *** C_primary_resource LOOP variables ***', 1, 'Y');
455: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: l_primary_resource_id: ' || l_primary_resource_id, 1, 'Y');
456: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: l_primary_resource_grp_id: ' || l_primary_resource_grp_id, 1, 'Y');
457: END IF;
458:
459: END LOOP;

Line 456: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: l_primary_resource_grp_id: ' || l_primary_resource_grp_id, 1, 'Y');

452:
453: IF aso_debug_pub.g_debug_flag = 'Y' THEN
454: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: *** C_primary_resource LOOP variables ***', 1, 'Y');
455: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: l_primary_resource_id: ' || l_primary_resource_id, 1, 'Y');
456: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: l_primary_resource_grp_id: ' || l_primary_resource_grp_id, 1, 'Y');
457: END IF;
458:
459: END LOOP;
460:

Line 465: IF aso_debug_pub.g_debug_flag = 'Y' THEN

461: IF l_primary_resource_id = l_resource_id THEN
462: IF l_update_access_flag <> 'Y' THEN
463: x_return_status := FND_API.G_RET_STS_ERROR;
464:
465: IF aso_debug_pub.g_debug_flag = 'Y' THEN
466: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: trying to set primary resource update_access_flag other than Y', 1, 'Y');
467: END IF;
468: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
469: FND_MESSAGE.Set_Name('ASO', 'ASO_SEC_ADD_INVALID_ACCESS');

Line 466: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: trying to set primary resource update_access_flag other than Y', 1, 'Y');

462: IF l_update_access_flag <> 'Y' THEN
463: x_return_status := FND_API.G_RET_STS_ERROR;
464:
465: IF aso_debug_pub.g_debug_flag = 'Y' THEN
466: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: trying to set primary resource update_access_flag other than Y', 1, 'Y');
467: END IF;
468: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
469: FND_MESSAGE.Set_Name('ASO', 'ASO_SEC_ADD_INVALID_ACCESS');
470: FND_MSG_PUB.Add;

Line 476: IF aso_debug_pub.g_debug_flag = 'Y' THEN

472: RAISE FND_API.G_EXC_ERROR;
473: ELSE
474: IF l_resource_grp_id IS NOT NULL AND l_resource_grp_id <> FND_API.G_MISS_NUM THEN
475: IF l_primary_resource_grp_id <> l_resource_grp_id THEN
476: IF aso_debug_pub.g_debug_flag = 'Y' THEN
477: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: before update ASO_QUOTE_HEADERS_ALL', 1, 'Y');
478: END IF;
479:
480: UPDATE ASO_QUOTE_HEADERS_ALL

Line 477: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: before update ASO_QUOTE_HEADERS_ALL', 1, 'Y');

473: ELSE
474: IF l_resource_grp_id IS NOT NULL AND l_resource_grp_id <> FND_API.G_MISS_NUM THEN
475: IF l_primary_resource_grp_id <> l_resource_grp_id THEN
476: IF aso_debug_pub.g_debug_flag = 'Y' THEN
477: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: before update ASO_QUOTE_HEADERS_ALL', 1, 'Y');
478: END IF;
479:
480: UPDATE ASO_QUOTE_HEADERS_ALL
481: SET resource_grp_id = l_resource_grp_id,

Line 489: IF aso_debug_pub.g_debug_flag = 'Y' THEN

485: WHERE quote_number = l_quote_number
486: AND max_version_flag = 'Y';
487:
488: IF SQL%ROWCOUNT = 0 THEN
489: IF aso_debug_pub.g_debug_flag = 'Y' THEN
490: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: inside update ASO_QUOTE_HEADERS_ALL: SQL%ROWCOUNT = 0', 1, 'Y');
491: END IF;
492: x_return_status := FND_API.G_RET_STS_ERROR;
493: RAISE FND_API.G_EXC_ERROR;

Line 490: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: inside update ASO_QUOTE_HEADERS_ALL: SQL%ROWCOUNT = 0', 1, 'Y');

486: AND max_version_flag = 'Y';
487:
488: IF SQL%ROWCOUNT = 0 THEN
489: IF aso_debug_pub.g_debug_flag = 'Y' THEN
490: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: inside update ASO_QUOTE_HEADERS_ALL: SQL%ROWCOUNT = 0', 1, 'Y');
491: END IF;
492: x_return_status := FND_API.G_RET_STS_ERROR;
493: RAISE FND_API.G_EXC_ERROR;
494: END IF;

Line 496: IF aso_debug_pub.g_debug_flag = 'Y' THEN

492: x_return_status := FND_API.G_RET_STS_ERROR;
493: RAISE FND_API.G_EXC_ERROR;
494: END IF;
495:
496: IF aso_debug_pub.g_debug_flag = 'Y' THEN
497: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: after update ASO_QUOTE_HEADERS_ALL', 1, 'Y');
498: END IF;
499:
500: END IF;

Line 497: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: after update ASO_QUOTE_HEADERS_ALL', 1, 'Y');

493: RAISE FND_API.G_EXC_ERROR;
494: END IF;
495:
496: IF aso_debug_pub.g_debug_flag = 'Y' THEN
497: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: after update ASO_QUOTE_HEADERS_ALL', 1, 'Y');
498: END IF;
499:
500: END IF;
501: END IF;

Line 505: IF aso_debug_pub.g_debug_flag = 'Y' THEN

501: END IF;
502: END IF;
503: END IF;
504:
505: IF aso_debug_pub.g_debug_flag = 'Y' THEN
506: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: after Update_Row: x_qte_access_tbl('||i||').access_id:: ' || x_qte_access_tbl(i).access_id, 1, 'Y');
507: END IF;
508:
509: END IF;

Line 506: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: after Update_Row: x_qte_access_tbl('||i||').access_id:: ' || x_qte_access_tbl(i).access_id, 1, 'Y');

502: END IF;
503: END IF;
504:
505: IF aso_debug_pub.g_debug_flag = 'Y' THEN
506: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: after Update_Row: x_qte_access_tbl('||i||').access_id:: ' || x_qte_access_tbl(i).access_id, 1, 'Y');
507: END IF;
508:
509: END IF;
510:

Line 513: IF aso_debug_pub.g_debug_flag = 'Y' THEN

509: END IF;
510:
511: END LOOP;
512:
513: IF aso_debug_pub.g_debug_flag = 'Y' THEN
514: aso_debug_pub.add('ASO_SECURITY_INT: End of Add_Resource: before update ASO_QUOTE_HEADERS_ALL', 1, 'Y');
515: aso_debug_pub.add('ASO_SECURITY_INT: End of Add_Resource: l_quote_number: '||l_quote_number, 1, 'Y');
516: END IF;
517:

Line 514: aso_debug_pub.add('ASO_SECURITY_INT: End of Add_Resource: before update ASO_QUOTE_HEADERS_ALL', 1, 'Y');

510:
511: END LOOP;
512:
513: IF aso_debug_pub.g_debug_flag = 'Y' THEN
514: aso_debug_pub.add('ASO_SECURITY_INT: End of Add_Resource: before update ASO_QUOTE_HEADERS_ALL', 1, 'Y');
515: aso_debug_pub.add('ASO_SECURITY_INT: End of Add_Resource: l_quote_number: '||l_quote_number, 1, 'Y');
516: END IF;
517:
518: UPDATE ASO_QUOTE_HEADERS_ALL

Line 515: aso_debug_pub.add('ASO_SECURITY_INT: End of Add_Resource: l_quote_number: '||l_quote_number, 1, 'Y');

511: END LOOP;
512:
513: IF aso_debug_pub.g_debug_flag = 'Y' THEN
514: aso_debug_pub.add('ASO_SECURITY_INT: End of Add_Resource: before update ASO_QUOTE_HEADERS_ALL', 1, 'Y');
515: aso_debug_pub.add('ASO_SECURITY_INT: End of Add_Resource: l_quote_number: '||l_quote_number, 1, 'Y');
516: END IF;
517:
518: UPDATE ASO_QUOTE_HEADERS_ALL
519: SET last_update_date = sysdate,

Line 526: IF aso_debug_pub.g_debug_flag = 'Y' THEN

522: WHERE quote_number = l_quote_number AND
523: max_version_flag = 'Y';
524:
525: IF SQL%ROWCOUNT = 0 THEN
526: IF aso_debug_pub.g_debug_flag = 'Y' THEN
527: aso_debug_pub.add('ASO_SECURITY_INT: End of Add_Resource: after update ASO_QUOTE_HEADERS_ALL: SQL%ROWCOUNT = 0', 1, 'Y');
528: END IF;
529: x_return_status := FND_API.G_RET_STS_ERROR;
530: RAISE FND_API.G_EXC_ERROR;

Line 527: aso_debug_pub.add('ASO_SECURITY_INT: End of Add_Resource: after update ASO_QUOTE_HEADERS_ALL: SQL%ROWCOUNT = 0', 1, 'Y');

523: max_version_flag = 'Y';
524:
525: IF SQL%ROWCOUNT = 0 THEN
526: IF aso_debug_pub.g_debug_flag = 'Y' THEN
527: aso_debug_pub.add('ASO_SECURITY_INT: End of Add_Resource: after update ASO_QUOTE_HEADERS_ALL: SQL%ROWCOUNT = 0', 1, 'Y');
528: END IF;
529: x_return_status := FND_API.G_RET_STS_ERROR;
530: RAISE FND_API.G_EXC_ERROR;
531: END IF;

Line 538: IF aso_debug_pub.g_debug_flag = 'Y' THEN

534: -- Release 12 TAP Changes
535: -- Girish Sachdeva 8/30/2005
536: -- Adding the call to insert record in the ASO_CHANGED_QUOTES
537:
538: IF aso_debug_pub.g_debug_flag = 'Y' THEN
539: aso_debug_pub.add('ASO_SECURITY_INT.Add_Resource : Calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || l_quote_number, 1, 'Y');
540: END IF;
541:
542: -- Call to insert record in ASO_CHANGED_QUOTES

Line 539: aso_debug_pub.add('ASO_SECURITY_INT.Add_Resource : Calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || l_quote_number, 1, 'Y');

535: -- Girish Sachdeva 8/30/2005
536: -- Adding the call to insert record in the ASO_CHANGED_QUOTES
537:
538: IF aso_debug_pub.g_debug_flag = 'Y' THEN
539: aso_debug_pub.add('ASO_SECURITY_INT.Add_Resource : Calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || l_quote_number, 1, 'Y');
540: END IF;
541:
542: -- Call to insert record in ASO_CHANGED_QUOTES
543: ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(l_quote_number);

Line 548: IF aso_debug_pub.g_debug_flag = 'Y' THEN

544:
545: -- Change END
546:
547: -- End of API body
548: IF aso_debug_pub.g_debug_flag = 'Y' THEN
549: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: End of API body', 1, 'Y');
550: END IF;
551:
552: -- Standard check of p_commit.

Line 549: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: End of API body', 1, 'Y');

545: -- Change END
546:
547: -- End of API body
548: IF aso_debug_pub.g_debug_flag = 'Y' THEN
549: aso_debug_pub.add('ASO_SECURITY_INT: Add_Resource: End of API body', 1, 'Y');
550: END IF;
551:
552: -- Standard check of p_commit.
553: IF FND_API.To_Boolean(p_commit) THEN

Line 621: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

617:
618: l_call_from_oafwk_flag varchar2(1) := fnd_api.g_false;
619:
620: Begin
621: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
622:
623: IF aso_debug_pub.g_debug_flag = 'Y' THEN
624: aso_debug_pub.add('ASO_SECURITY_INT: ****** Start of Add_Resource API not overloaded ******', 1, 'Y');
625: END IF;

Line 623: IF aso_debug_pub.g_debug_flag = 'Y' THEN

619:
620: Begin
621: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
622:
623: IF aso_debug_pub.g_debug_flag = 'Y' THEN
624: aso_debug_pub.add('ASO_SECURITY_INT: ****** Start of Add_Resource API not overloaded ******', 1, 'Y');
625: END IF;
626:
627: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 624: aso_debug_pub.add('ASO_SECURITY_INT: Start of Add_Resource API not overloaded ', 1, 'Y');

620: Begin
621: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
622:
623: IF aso_debug_pub.g_debug_flag = 'Y' THEN
624: aso_debug_pub.add('ASO_SECURITY_INT: ****** Start of Add_Resource API not overloaded ******', 1, 'Y');
625: END IF;
626:
627: IF aso_debug_pub.g_debug_flag = 'Y' THEN
628: aso_debug_pub.add('ASO_SECURITY_INT: Before call to Add_Resource overloaded procedure', 1, 'Y');

Line 627: IF aso_debug_pub.g_debug_flag = 'Y' THEN

623: IF aso_debug_pub.g_debug_flag = 'Y' THEN
624: aso_debug_pub.add('ASO_SECURITY_INT: ****** Start of Add_Resource API not overloaded ******', 1, 'Y');
625: END IF;
626:
627: IF aso_debug_pub.g_debug_flag = 'Y' THEN
628: aso_debug_pub.add('ASO_SECURITY_INT: Before call to Add_Resource overloaded procedure', 1, 'Y');
629: END IF;
630:
631: ASO_SECURITY_INT.Add_Resource(

Line 628: aso_debug_pub.add('ASO_SECURITY_INT: Before call to Add_Resource overloaded procedure', 1, 'Y');

624: aso_debug_pub.add('ASO_SECURITY_INT: ****** Start of Add_Resource API not overloaded ******', 1, 'Y');
625: END IF;
626:
627: IF aso_debug_pub.g_debug_flag = 'Y' THEN
628: aso_debug_pub.add('ASO_SECURITY_INT: Before call to Add_Resource overloaded procedure', 1, 'Y');
629: END IF;
630:
631: ASO_SECURITY_INT.Add_Resource(
632: P_INIT_MSG_LIST => P_INIT_MSG_LIST,

Line 641: IF aso_debug_pub.g_debug_flag = 'Y' THEN

637: X_RETURN_STATUS => x_return_status,
638: X_msg_count => X_msg_count,
639: X_msg_data => X_msg_data );
640:
641: IF aso_debug_pub.g_debug_flag = 'Y' THEN
642: aso_debug_pub.add('ASO_SECURITY_INT: After call to Add_Resource overloaded procedure', 1, 'Y');
643: END IF;
644:
645: End Add_Resource;

Line 642: aso_debug_pub.add('ASO_SECURITY_INT: After call to Add_Resource overloaded procedure', 1, 'Y');

638: X_msg_count => X_msg_count,
639: X_msg_data => X_msg_data );
640:
641: IF aso_debug_pub.g_debug_flag = 'Y' THEN
642: aso_debug_pub.add('ASO_SECURITY_INT: After call to Add_Resource overloaded procedure', 1, 'Y');
643: END IF;
644:
645: End Add_Resource;
646:

Line 695: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

691: l_quote_number NUMBER;
692: l_access_id NUMBER;
693:
694: BEGIN
695: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
696: IF aso_debug_pub.g_debug_flag = 'Y' THEN
697: aso_debug_pub.add('ASO_SECURITY_INT: ****** Start of Delete_Resource API ******', 1, 'Y');
698: END IF;
699:

Line 696: IF aso_debug_pub.g_debug_flag = 'Y' THEN

692: l_access_id NUMBER;
693:
694: BEGIN
695: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
696: IF aso_debug_pub.g_debug_flag = 'Y' THEN
697: aso_debug_pub.add('ASO_SECURITY_INT: ****** Start of Delete_Resource API ******', 1, 'Y');
698: END IF;
699:
700: -- Standard Start of API savepoint

Line 697: aso_debug_pub.add('ASO_SECURITY_INT: Start of Delete_Resource API ', 1, 'Y');

693:
694: BEGIN
695: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
696: IF aso_debug_pub.g_debug_flag = 'Y' THEN
697: aso_debug_pub.add('ASO_SECURITY_INT: ****** Start of Delete_Resource API ******', 1, 'Y');
698: END IF;
699:
700: -- Standard Start of API savepoint
701: SAVEPOINT Delete_Resource_INT;

Line 721: IF aso_debug_pub.g_debug_flag = 'Y' THEN

717: l_quote_number := FND_API.G_MISS_NUM;
718: l_access_id := FND_API.G_MISS_NUM;
719:
720: IF P_Qte_Access_Tbl(i).access_id IS NOT NULL AND P_Qte_Access_Tbl(i).access_id <> FND_API.G_MISS_NUM THEN
721: IF aso_debug_pub.g_debug_flag = 'Y' THEN
722: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: LOOP for access_id: ' || P_Qte_Access_Tbl(i).access_id, 1, 'Y');
723: END IF;
724:
725: l_access_id := P_Qte_Access_Tbl(i).access_id;

Line 722: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: LOOP for access_id: ' || P_Qte_Access_Tbl(i).access_id, 1, 'Y');

718: l_access_id := FND_API.G_MISS_NUM;
719:
720: IF P_Qte_Access_Tbl(i).access_id IS NOT NULL AND P_Qte_Access_Tbl(i).access_id <> FND_API.G_MISS_NUM THEN
721: IF aso_debug_pub.g_debug_flag = 'Y' THEN
722: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: LOOP for access_id: ' || P_Qte_Access_Tbl(i).access_id, 1, 'Y');
723: END IF;
724:
725: l_access_id := P_Qte_Access_Tbl(i).access_id;
726:

Line 775: IF aso_debug_pub.g_debug_flag = 'Y' THEN

771: END LOOP;
772:
773: end if;
774:
775: IF aso_debug_pub.g_debug_flag = 'Y' THEN
776: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: LOOP for resource_id: ' || P_Qte_Access_Tbl(i).resource_id, 1, 'Y');
777: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: LOOP for quote_number: ' || P_Qte_Access_Tbl(i).quote_number, 1, 'Y');
778: END IF;
779:

Line 776: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: LOOP for resource_id: ' || P_Qte_Access_Tbl(i).resource_id, 1, 'Y');

772:
773: end if;
774:
775: IF aso_debug_pub.g_debug_flag = 'Y' THEN
776: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: LOOP for resource_id: ' || P_Qte_Access_Tbl(i).resource_id, 1, 'Y');
777: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: LOOP for quote_number: ' || P_Qte_Access_Tbl(i).quote_number, 1, 'Y');
778: END IF;
779:
780: FOR l_access_rec IN C_existing_resource(P_Qte_Access_Tbl(i).quote_number, P_Qte_Access_Tbl(i).resource_id) LOOP

Line 777: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: LOOP for quote_number: ' || P_Qte_Access_Tbl(i).quote_number, 1, 'Y');

773: end if;
774:
775: IF aso_debug_pub.g_debug_flag = 'Y' THEN
776: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: LOOP for resource_id: ' || P_Qte_Access_Tbl(i).resource_id, 1, 'Y');
777: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: LOOP for quote_number: ' || P_Qte_Access_Tbl(i).quote_number, 1, 'Y');
778: END IF;
779:
780: FOR l_access_rec IN C_existing_resource(P_Qte_Access_Tbl(i).quote_number, P_Qte_Access_Tbl(i).resource_id) LOOP
781: l_access_id := l_access_rec.access_id;

Line 788: IF aso_debug_pub.g_debug_flag = 'Y' THEN

784: END IF;
785: END IF;
786: END IF;
787:
788: IF aso_debug_pub.g_debug_flag = 'Y' THEN
789: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: count: ' || P_Qte_Access_Tbl.count);
790: END IF;
791:
792: IF l_access_id IS NOT NULL AND l_access_id <> FND_API.G_MISS_NUM THEN

Line 789: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: count: ' || P_Qte_Access_Tbl.count);

785: END IF;
786: END IF;
787:
788: IF aso_debug_pub.g_debug_flag = 'Y' THEN
789: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: count: ' || P_Qte_Access_Tbl.count);
790: END IF;
791:
792: IF l_access_id IS NOT NULL AND l_access_id <> FND_API.G_MISS_NUM THEN
793:

Line 798: IF aso_debug_pub.g_debug_flag = 'Y' THEN

794: FOR l_resource_rec IN C_resource(l_access_id) LOOP
795: l_quote_number := l_resource_rec.quote_number;
796: l_resource_id := l_resource_rec.resource_id;
797:
798: IF aso_debug_pub.g_debug_flag = 'Y' THEN
799: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: *** C_resource LOOP variables ***');
800: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: l_quote_number: ' || l_quote_number);
801: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: l_resource_id: ' || l_resource_id);
802: END IF;

Line 799: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: * C_resource LOOP variables *');

795: l_quote_number := l_resource_rec.quote_number;
796: l_resource_id := l_resource_rec.resource_id;
797:
798: IF aso_debug_pub.g_debug_flag = 'Y' THEN
799: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: *** C_resource LOOP variables ***');
800: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: l_quote_number: ' || l_quote_number);
801: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: l_resource_id: ' || l_resource_id);
802: END IF;
803: END LOOP;

Line 800: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: l_quote_number: ' || l_quote_number);

796: l_resource_id := l_resource_rec.resource_id;
797:
798: IF aso_debug_pub.g_debug_flag = 'Y' THEN
799: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: *** C_resource LOOP variables ***');
800: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: l_quote_number: ' || l_quote_number);
801: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: l_resource_id: ' || l_resource_id);
802: END IF;
803: END LOOP;
804:

Line 801: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: l_resource_id: ' || l_resource_id);

797:
798: IF aso_debug_pub.g_debug_flag = 'Y' THEN
799: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: *** C_resource LOOP variables ***');
800: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: l_quote_number: ' || l_quote_number);
801: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: l_resource_id: ' || l_resource_id);
802: END IF;
803: END LOOP;
804:
805: IF l_quote_number IS NOT NULL AND l_quote_number <> FND_API.G_MISS_NUM THEN

Line 810: IF aso_debug_pub.g_debug_flag = 'Y' THEN

806:
807: FOR l_primary_resource_rec IN C_primary_resource(l_quote_number) LOOP
808: l_primary_resource_id := l_primary_resource_rec.resource_id;
809:
810: IF aso_debug_pub.g_debug_flag = 'Y' THEN
811: aso_debug_pub.add('Delete_Resource: *** C_primary_resource LOOP variables ***');
812: aso_debug_pub.add('Delete_Resource: l_primary_resource_id: ' || l_primary_resource_id);
813: END IF;
814: END LOOP;

Line 811: aso_debug_pub.add('Delete_Resource: * C_primary_resource LOOP variables *');

807: FOR l_primary_resource_rec IN C_primary_resource(l_quote_number) LOOP
808: l_primary_resource_id := l_primary_resource_rec.resource_id;
809:
810: IF aso_debug_pub.g_debug_flag = 'Y' THEN
811: aso_debug_pub.add('Delete_Resource: *** C_primary_resource LOOP variables ***');
812: aso_debug_pub.add('Delete_Resource: l_primary_resource_id: ' || l_primary_resource_id);
813: END IF;
814: END LOOP;
815:

Line 812: aso_debug_pub.add('Delete_Resource: l_primary_resource_id: ' || l_primary_resource_id);

808: l_primary_resource_id := l_primary_resource_rec.resource_id;
809:
810: IF aso_debug_pub.g_debug_flag = 'Y' THEN
811: aso_debug_pub.add('Delete_Resource: *** C_primary_resource LOOP variables ***');
812: aso_debug_pub.add('Delete_Resource: l_primary_resource_id: ' || l_primary_resource_id);
813: END IF;
814: END LOOP;
815:
816: IF l_primary_resource_id = l_resource_id THEN

Line 819: IF aso_debug_pub.g_debug_flag = 'Y' THEN

815:
816: IF l_primary_resource_id = l_resource_id THEN
817: x_return_status := FND_API.G_RET_STS_ERROR;
818:
819: IF aso_debug_pub.g_debug_flag = 'Y' THEN
820: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: trying to delete primary salesrep', 1, 'Y');
821: END IF;
822:
823: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 820: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: trying to delete primary salesrep', 1, 'Y');

816: IF l_primary_resource_id = l_resource_id THEN
817: x_return_status := FND_API.G_RET_STS_ERROR;
818:
819: IF aso_debug_pub.g_debug_flag = 'Y' THEN
820: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: trying to delete primary salesrep', 1, 'Y');
821: END IF;
822:
823: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
824: FND_MESSAGE.Set_Name('ASO', 'ASO_SEC_DELETE_PRIMARY_RES');

Line 830: IF aso_debug_pub.g_debug_flag = 'Y' THEN

826: END IF;
827: RAISE FND_API.G_EXC_ERROR;
828: ELSE
829:
830: IF aso_debug_pub.g_debug_flag = 'Y' THEN
831: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: before Delete_Row: l_access_id: ' || l_access_id, 1, 'Y');
832:
833: END IF;
834:

Line 831: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: before Delete_Row: l_access_id: ' || l_access_id, 1, 'Y');

827: RAISE FND_API.G_EXC_ERROR;
828: ELSE
829:
830: IF aso_debug_pub.g_debug_flag = 'Y' THEN
831: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: before Delete_Row: l_access_id: ' || l_access_id, 1, 'Y');
832:
833: END IF;
834:
835: ASO_QUOTE_ACCESSES_PKG.Delete_Row(

Line 839: IF aso_debug_pub.g_debug_flag = 'Y' THEN

835: ASO_QUOTE_ACCESSES_PKG.Delete_Row(
836: p_ACCESS_ID => l_access_id
837: );
838:
839: IF aso_debug_pub.g_debug_flag = 'Y' THEN
840: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: after Delete_Row', 1, 'Y');
841: END IF;
842:
843: END IF;

Line 840: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: after Delete_Row', 1, 'Y');

836: p_ACCESS_ID => l_access_id
837: );
838:
839: IF aso_debug_pub.g_debug_flag = 'Y' THEN
840: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: after Delete_Row', 1, 'Y');
841: END IF;
842:
843: END IF;
844:

Line 848: IF aso_debug_pub.g_debug_flag = 'Y' THEN

844:
845: ELSE
846: x_return_status := FND_API.G_RET_STS_ERROR;
847:
848: IF aso_debug_pub.g_debug_flag = 'Y' THEN
849: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: trying to delete a non-existent entry', 1, 'Y');
850:
851: END IF;
852: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 849: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: trying to delete a non-existent entry', 1, 'Y');

845: ELSE
846: x_return_status := FND_API.G_RET_STS_ERROR;
847:
848: IF aso_debug_pub.g_debug_flag = 'Y' THEN
849: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: trying to delete a non-existent entry', 1, 'Y');
850:
851: END IF;
852: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
853: FND_MESSAGE.Set_Name('ASO', 'ASO_SEC_DELETE_INVALID_ID');

Line 862: IF aso_debug_pub.g_debug_flag = 'Y' THEN

858:
859: ELSE
860: x_return_status := FND_API.G_RET_STS_ERROR;
861:
862: IF aso_debug_pub.g_debug_flag = 'Y' THEN
863: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: trying to delete without passing enough info', 1, 'Y');
864: END IF;
865:
866: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 863: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: trying to delete without passing enough info', 1, 'Y');

859: ELSE
860: x_return_status := FND_API.G_RET_STS_ERROR;
861:
862: IF aso_debug_pub.g_debug_flag = 'Y' THEN
863: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: trying to delete without passing enough info', 1, 'Y');
864: END IF;
865:
866: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
867: FND_MESSAGE.Set_Name('ASO', 'ASO_SEC_DELETE_INSUFFICIENT');

Line 875: IF aso_debug_pub.g_debug_flag = 'Y' THEN

871: END IF;
872:
873: END LOOP;
874:
875: IF aso_debug_pub.g_debug_flag = 'Y' THEN
876: aso_debug_pub.add('ASO_SECURITY_INT: End of Delete_Resource: before update ASO_QUOTE_HEADERS_ALL', 1, 'Y');
877: END IF;
878:
879: UPDATE ASO_QUOTE_HEADERS_ALL

Line 876: aso_debug_pub.add('ASO_SECURITY_INT: End of Delete_Resource: before update ASO_QUOTE_HEADERS_ALL', 1, 'Y');

872:
873: END LOOP;
874:
875: IF aso_debug_pub.g_debug_flag = 'Y' THEN
876: aso_debug_pub.add('ASO_SECURITY_INT: End of Delete_Resource: before update ASO_QUOTE_HEADERS_ALL', 1, 'Y');
877: END IF;
878:
879: UPDATE ASO_QUOTE_HEADERS_ALL
880: SET last_update_date = sysdate,

Line 887: IF aso_debug_pub.g_debug_flag = 'Y' THEN

883: WHERE quote_number = l_quote_number AND
884: max_version_flag = 'Y';
885:
886: IF SQL%ROWCOUNT = 0 THEN
887: IF aso_debug_pub.g_debug_flag = 'Y' THEN
888: aso_debug_pub.add('ASO_SECURITY_INT: End of Delete_Resource: after update ASO_QUOTE_HEADERS_ALL: SQL%ROWCOUNT = 0', 1, 'Y');
889: END IF;
890: x_return_status := FND_API.G_RET_STS_ERROR;
891: RAISE FND_API.G_EXC_ERROR;

Line 888: aso_debug_pub.add('ASO_SECURITY_INT: End of Delete_Resource: after update ASO_QUOTE_HEADERS_ALL: SQL%ROWCOUNT = 0', 1, 'Y');

884: max_version_flag = 'Y';
885:
886: IF SQL%ROWCOUNT = 0 THEN
887: IF aso_debug_pub.g_debug_flag = 'Y' THEN
888: aso_debug_pub.add('ASO_SECURITY_INT: End of Delete_Resource: after update ASO_QUOTE_HEADERS_ALL: SQL%ROWCOUNT = 0', 1, 'Y');
889: END IF;
890: x_return_status := FND_API.G_RET_STS_ERROR;
891: RAISE FND_API.G_EXC_ERROR;
892: END IF;

Line 899: IF aso_debug_pub.g_debug_flag = 'Y' THEN

895: -- Release 12 TAP Changes
896: -- Girish Sachdeva 8/30/2005
897: -- Adding the call to insert record in the ASO_CHANGED_QUOTES
898:
899: IF aso_debug_pub.g_debug_flag = 'Y' THEN
900: aso_debug_pub.add('ASO_SECURITY_INT.Delete_Resource : Calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || l_quote_number, 1, 'Y');
901: end if;
902:
903: -- Call to insert record in ASO_CHANGED_QUOTES

Line 900: aso_debug_pub.add('ASO_SECURITY_INT.Delete_Resource : Calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || l_quote_number, 1, 'Y');

896: -- Girish Sachdeva 8/30/2005
897: -- Adding the call to insert record in the ASO_CHANGED_QUOTES
898:
899: IF aso_debug_pub.g_debug_flag = 'Y' THEN
900: aso_debug_pub.add('ASO_SECURITY_INT.Delete_Resource : Calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || l_quote_number, 1, 'Y');
901: end if;
902:
903: -- Call to insert record in ASO_CHANGED_QUOTES
904: ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(l_quote_number);

Line 909: IF aso_debug_pub.g_debug_flag = 'Y' THEN

905:
906: -- Change END
907:
908: -- End of API body
909: IF aso_debug_pub.g_debug_flag = 'Y' THEN
910: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: End of API body', 1, 'Y');
911: END IF;
912: -- Standard check of p_commit.
913: IF FND_API.To_Boolean(p_commit) THEN

Line 910: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: End of API body', 1, 'Y');

906: -- Change END
907:
908: -- End of API body
909: IF aso_debug_pub.g_debug_flag = 'Y' THEN
910: aso_debug_pub.add('ASO_SECURITY_INT: Delete_Resource: End of API body', 1, 'Y');
911: END IF;
912: -- Standard check of p_commit.
913: IF FND_API.To_Boolean(p_commit) THEN
914: COMMIT WORK;

Line 1008: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1004: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
1005: l_obsolete_status varchar2(1);
1006: BEGIN
1007:
1008: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1009: aso_debug_pub.add('ASO_SECURITY_INT: ****** Start of Add_SalesRep_QuoteCreator API ******', 1, 'Y');
1010: END IF;
1011:
1012: -- Standard Start of API savepoint

Line 1009: aso_debug_pub.add('ASO_SECURITY_INT: Start of Add_SalesRep_QuoteCreator API ', 1, 'Y');

1005: l_obsolete_status varchar2(1);
1006: BEGIN
1007:
1008: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1009: aso_debug_pub.add('ASO_SECURITY_INT: ****** Start of Add_SalesRep_QuoteCreator API ******', 1, 'Y');
1010: END IF;
1011:
1012: -- Standard Start of API savepoint
1013: SAVEPOINT Add_SalesRep_QuoteCreator_INT;

Line 1045: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1041: l_qte_access_rec.batch_price_flag := p_qte_header_rec.batch_price_flag;
1042:
1043: --bug 5131904
1044: OPEN C_get_resource_role (p_qte_header_rec.resource_id);
1045: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1046: aso_debug_pub.add('ASO_SECURITY_INT: Add_SalesRep_QuoteCreator:trying to get role from resource ', 1, 'N');
1047: END IF;
1048:
1049: FETCH C_get_resource_role INTO l_qte_access_rec.ROLE_ID;

Line 1046: aso_debug_pub.add('ASO_SECURITY_INT: Add_SalesRep_QuoteCreator:trying to get role from resource ', 1, 'N');

1042:
1043: --bug 5131904
1044: OPEN C_get_resource_role (p_qte_header_rec.resource_id);
1045: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1046: aso_debug_pub.add('ASO_SECURITY_INT: Add_SalesRep_QuoteCreator:trying to get role from resource ', 1, 'N');
1047: END IF;
1048:
1049: FETCH C_get_resource_role INTO l_qte_access_rec.ROLE_ID;
1050:

Line 1051: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1047: END IF;
1048:
1049: FETCH C_get_resource_role INTO l_qte_access_rec.ROLE_ID;
1050:
1051: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1052: aso_debug_pub.add('ASO_SECURITY_INT: Add_SalesRep_QuoteCreator: l_qte_access_rec.ROLE_ID: '|| l_qte_access_rec.ROLE_ID, 1, 'N');
1053: END IF;
1054:
1055: CLOSE C_get_resource_role;

Line 1052: aso_debug_pub.add('ASO_SECURITY_INT: Add_SalesRep_QuoteCreator: l_qte_access_rec.ROLE_ID: '|| l_qte_access_rec.ROLE_ID, 1, 'N');

1048:
1049: FETCH C_get_resource_role INTO l_qte_access_rec.ROLE_ID;
1050:
1051: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1052: aso_debug_pub.add('ASO_SECURITY_INT: Add_SalesRep_QuoteCreator: l_qte_access_rec.ROLE_ID: '|| l_qte_access_rec.ROLE_ID, 1, 'N');
1053: END IF;
1054:
1055: CLOSE C_get_resource_role;
1056:

Line 1060: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1056:
1057: -- if the resource does not have a group, get it from the QOT Params
1058: IF (l_qte_access_rec.ROLE_ID IS NULL OR l_qte_access_rec.ROLE_ID = FND_API.G_MISS_NUM) THEN
1059: l_qte_access_rec.ROLE_ID := aso_utility_pvt.get_ou_attribute_value(aso_utility_pvt.G_DEFAULT_SALES_ROLE,p_qte_header_rec.org_id);
1060: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1061: aso_debug_pub.add('ASO_SECURITY_INT: Add_SalesRep_QuoteCreator: getting role from QOT PARAMS ', 1, 'N');
1062: aso_debug_pub.add('ASO_SECURITY_INT: Add_SalesRep_QuoteCreator: l_qte_access_rec.ROLE_ID: '|| l_qte_access_rec.ROLE_ID, 1, 'N');
1063: END IF;
1064: END IF;

Line 1061: aso_debug_pub.add('ASO_SECURITY_INT: Add_SalesRep_QuoteCreator: getting role from QOT PARAMS ', 1, 'N');

1057: -- if the resource does not have a group, get it from the QOT Params
1058: IF (l_qte_access_rec.ROLE_ID IS NULL OR l_qte_access_rec.ROLE_ID = FND_API.G_MISS_NUM) THEN
1059: l_qte_access_rec.ROLE_ID := aso_utility_pvt.get_ou_attribute_value(aso_utility_pvt.G_DEFAULT_SALES_ROLE,p_qte_header_rec.org_id);
1060: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1061: aso_debug_pub.add('ASO_SECURITY_INT: Add_SalesRep_QuoteCreator: getting role from QOT PARAMS ', 1, 'N');
1062: aso_debug_pub.add('ASO_SECURITY_INT: Add_SalesRep_QuoteCreator: l_qte_access_rec.ROLE_ID: '|| l_qte_access_rec.ROLE_ID, 1, 'N');
1063: END IF;
1064: END IF;
1065:

Line 1062: aso_debug_pub.add('ASO_SECURITY_INT: Add_SalesRep_QuoteCreator: l_qte_access_rec.ROLE_ID: '|| l_qte_access_rec.ROLE_ID, 1, 'N');

1058: IF (l_qte_access_rec.ROLE_ID IS NULL OR l_qte_access_rec.ROLE_ID = FND_API.G_MISS_NUM) THEN
1059: l_qte_access_rec.ROLE_ID := aso_utility_pvt.get_ou_attribute_value(aso_utility_pvt.G_DEFAULT_SALES_ROLE,p_qte_header_rec.org_id);
1060: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1061: aso_debug_pub.add('ASO_SECURITY_INT: Add_SalesRep_QuoteCreator: getting role from QOT PARAMS ', 1, 'N');
1062: aso_debug_pub.add('ASO_SECURITY_INT: Add_SalesRep_QuoteCreator: l_qte_access_rec.ROLE_ID: '|| l_qte_access_rec.ROLE_ID, 1, 'N');
1063: END IF;
1064: END IF;
1065:
1066:

Line 1069: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1065:
1066:
1067: l_qte_access_tbl(1) := l_qte_access_rec;
1068:
1069: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1070: aso_debug_pub.add('ASO_SECURITY_INT: Add_SalesRep_QuoteCreator: before Add_Resource: p_qte_header_rec.resource_id: ' || p_qte_header_rec.resource_id, 1, 'N');
1071: aso_debug_pub.add('ASO_SECURITY_INT: Add_SalesRep_QuoteCreator: before Add_resource: p_qte_header_rec.resource_grp_id: ' || p_qte_header_rec.resource_grp_id, 1, 'N');
1072:
1073: END IF;

Line 1070: aso_debug_pub.add('ASO_SECURITY_INT: Add_SalesRep_QuoteCreator: before Add_Resource: p_qte_header_rec.resource_id: ' || p_qte_header_rec.resource_id, 1, 'N');

1066:
1067: l_qte_access_tbl(1) := l_qte_access_rec;
1068:
1069: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1070: aso_debug_pub.add('ASO_SECURITY_INT: Add_SalesRep_QuoteCreator: before Add_Resource: p_qte_header_rec.resource_id: ' || p_qte_header_rec.resource_id, 1, 'N');
1071: aso_debug_pub.add('ASO_SECURITY_INT: Add_SalesRep_QuoteCreator: before Add_resource: p_qte_header_rec.resource_grp_id: ' || p_qte_header_rec.resource_grp_id, 1, 'N');
1072:
1073: END IF;
1074:

Line 1071: aso_debug_pub.add('ASO_SECURITY_INT: Add_SalesRep_QuoteCreator: before Add_resource: p_qte_header_rec.resource_grp_id: ' || p_qte_header_rec.resource_grp_id, 1, 'N');

1067: l_qte_access_tbl(1) := l_qte_access_rec;
1068:
1069: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1070: aso_debug_pub.add('ASO_SECURITY_INT: Add_SalesRep_QuoteCreator: before Add_Resource: p_qte_header_rec.resource_id: ' || p_qte_header_rec.resource_id, 1, 'N');
1071: aso_debug_pub.add('ASO_SECURITY_INT: Add_SalesRep_QuoteCreator: before Add_resource: p_qte_header_rec.resource_grp_id: ' || p_qte_header_rec.resource_grp_id, 1, 'N');
1072:
1073: END IF;
1074:
1075: FOR c_user_resource_rec IN C_user_resource_id(G_USER_ID) LOOP

Line 1081: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1077:
1078: l_qte_access_tbl(2) := l_qte_access_rec;
1079: l_qte_access_tbl(2).RESOURCE_ID := c_user_resource_rec.resource_id;
1080:
1081: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1082: aso_debug_pub.add('ASO_SECURITY_INT: Add_SalesRep_QuoteCreator: Before calling Get_Profile_Obsolete_Status', 1, 'N');
1083: END IF;
1084:
1085: l_obsolete_status := aso_utility_pvt.Get_Profile_Obsolete_Status(p_profile_name => 'AST_DEFAULT_ROLE_AND_GROUP',

Line 1082: aso_debug_pub.add('ASO_SECURITY_INT: Add_SalesRep_QuoteCreator: Before calling Get_Profile_Obsolete_Status', 1, 'N');

1078: l_qte_access_tbl(2) := l_qte_access_rec;
1079: l_qte_access_tbl(2).RESOURCE_ID := c_user_resource_rec.resource_id;
1080:
1081: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1082: aso_debug_pub.add('ASO_SECURITY_INT: Add_SalesRep_QuoteCreator: Before calling Get_Profile_Obsolete_Status', 1, 'N');
1083: END IF;
1084:
1085: l_obsolete_status := aso_utility_pvt.Get_Profile_Obsolete_Status(p_profile_name => 'AST_DEFAULT_ROLE_AND_GROUP',
1086: p_application_id => 521);

Line 1088: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1084:
1085: l_obsolete_status := aso_utility_pvt.Get_Profile_Obsolete_Status(p_profile_name => 'AST_DEFAULT_ROLE_AND_GROUP',
1086: p_application_id => 521);
1087:
1088: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1089: aso_debug_pub.add('After calling Get_Profile_Obsolete_Status: l_obsolete_status: ' || l_obsolete_status, 1, 'N');
1090: END IF;
1091:
1092: if l_obsolete_status = 'T' then

Line 1089: aso_debug_pub.add('After calling Get_Profile_Obsolete_Status: l_obsolete_status: ' || l_obsolete_status, 1, 'N');

1085: l_obsolete_status := aso_utility_pvt.Get_Profile_Obsolete_Status(p_profile_name => 'AST_DEFAULT_ROLE_AND_GROUP',
1086: p_application_id => 521);
1087:
1088: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1089: aso_debug_pub.add('After calling Get_Profile_Obsolete_Status: l_obsolete_status: ' || l_obsolete_status, 1, 'N');
1090: END IF;
1091:
1092: if l_obsolete_status = 'T' then
1093:

Line 1096: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1092: if l_obsolete_status = 'T' then
1093:
1094: c_profile_value := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
1095:
1096: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1097: aso_debug_pub.add('c_profile_value: ' || c_profile_value, 1, 'N');
1098: END IF;
1099:
1100: l_qte_access_tbl(2).RESOURCE_GRP_ID := SUBSTR(c_profile_value, 1, INSTR(c_profile_value,'(')-1);

Line 1097: aso_debug_pub.add('c_profile_value: ' || c_profile_value, 1, 'N');

1093:
1094: c_profile_value := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
1095:
1096: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1097: aso_debug_pub.add('c_profile_value: ' || c_profile_value, 1, 'N');
1098: END IF;
1099:
1100: l_qte_access_tbl(2).RESOURCE_GRP_ID := SUBSTR(c_profile_value, 1, INSTR(c_profile_value,'(')-1);
1101:

Line 1102: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1098: END IF;
1099:
1100: l_qte_access_tbl(2).RESOURCE_GRP_ID := SUBSTR(c_profile_value, 1, INSTR(c_profile_value,'(')-1);
1101:
1102: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1103: aso_debug_pub.add('l_qte_access_tbl(2).RESOURCE_GRP_ID: ' || l_qte_access_tbl(2).RESOURCE_GRP_ID, 1, 'N');
1104: END IF;
1105:
1106: if l_qte_access_tbl(2).RESOURCE_GRP_ID is null then

Line 1103: aso_debug_pub.add('l_qte_access_tbl(2).RESOURCE_GRP_ID: ' || l_qte_access_tbl(2).RESOURCE_GRP_ID, 1, 'N');

1099:
1100: l_qte_access_tbl(2).RESOURCE_GRP_ID := SUBSTR(c_profile_value, 1, INSTR(c_profile_value,'(')-1);
1101:
1102: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1103: aso_debug_pub.add('l_qte_access_tbl(2).RESOURCE_GRP_ID: ' || l_qte_access_tbl(2).RESOURCE_GRP_ID, 1, 'N');
1104: END IF;
1105:
1106: if l_qte_access_tbl(2).RESOURCE_GRP_ID is null then
1107:

Line 1110: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1106: if l_qte_access_tbl(2).RESOURCE_GRP_ID is null then
1107:
1108: c_profile_value := FND_PROFILE.Value_Specific( 'AST_DEFAULT_GROUP', G_USER_ID, NULL, 521);
1109:
1110: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1111: aso_debug_pub.add('c_profile_value: ' || c_profile_value, 1, 'N');
1112: END IF;
1113:
1114: l_qte_access_tbl(2).RESOURCE_GRP_ID := to_number(c_profile_value);

Line 1111: aso_debug_pub.add('c_profile_value: ' || c_profile_value, 1, 'N');

1107:
1108: c_profile_value := FND_PROFILE.Value_Specific( 'AST_DEFAULT_GROUP', G_USER_ID, NULL, 521);
1109:
1110: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1111: aso_debug_pub.add('c_profile_value: ' || c_profile_value, 1, 'N');
1112: END IF;
1113:
1114: l_qte_access_tbl(2).RESOURCE_GRP_ID := to_number(c_profile_value);
1115:

Line 1116: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1112: END IF;
1113:
1114: l_qte_access_tbl(2).RESOURCE_GRP_ID := to_number(c_profile_value);
1115:
1116: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1117: aso_debug_pub.add('l_qte_access_tbl(2).RESOURCE_GRP_ID: ' || l_qte_access_tbl(2).RESOURCE_GRP_ID, 1, 'N');
1118: END IF;
1119:
1120: end if;

Line 1117: aso_debug_pub.add('l_qte_access_tbl(2).RESOURCE_GRP_ID: ' || l_qte_access_tbl(2).RESOURCE_GRP_ID, 1, 'N');

1113:
1114: l_qte_access_tbl(2).RESOURCE_GRP_ID := to_number(c_profile_value);
1115:
1116: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1117: aso_debug_pub.add('l_qte_access_tbl(2).RESOURCE_GRP_ID: ' || l_qte_access_tbl(2).RESOURCE_GRP_ID, 1, 'N');
1118: END IF;
1119:
1120: end if;
1121:

Line 1126: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1122: else
1123:
1124: c_profile_value := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
1125:
1126: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1127: aso_debug_pub.add('c_profile_value: ' || c_profile_value, 1, 'N');
1128: END IF;
1129:
1130: l_qte_access_tbl(2).RESOURCE_GRP_ID := SUBSTR(c_profile_value, 1, INSTR(c_profile_value,'(')-1);

Line 1127: aso_debug_pub.add('c_profile_value: ' || c_profile_value, 1, 'N');

1123:
1124: c_profile_value := FND_PROFILE.Value_Specific( 'ASF_DEFAULT_GROUP_ROLE', G_USER_ID, NULL, 522);
1125:
1126: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1127: aso_debug_pub.add('c_profile_value: ' || c_profile_value, 1, 'N');
1128: END IF;
1129:
1130: l_qte_access_tbl(2).RESOURCE_GRP_ID := SUBSTR(c_profile_value, 1, INSTR(c_profile_value,'(')-1);
1131:

Line 1132: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1128: END IF;
1129:
1130: l_qte_access_tbl(2).RESOURCE_GRP_ID := SUBSTR(c_profile_value, 1, INSTR(c_profile_value,'(')-1);
1131:
1132: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1133: aso_debug_pub.add('l_qte_access_tbl(2).RESOURCE_GRP_ID: ' || l_qte_access_tbl(2).RESOURCE_GRP_ID, 1, 'N');
1134: END IF;
1135:
1136: if l_qte_access_tbl(2).RESOURCE_GRP_ID is null then

Line 1133: aso_debug_pub.add('l_qte_access_tbl(2).RESOURCE_GRP_ID: ' || l_qte_access_tbl(2).RESOURCE_GRP_ID, 1, 'N');

1129:
1130: l_qte_access_tbl(2).RESOURCE_GRP_ID := SUBSTR(c_profile_value, 1, INSTR(c_profile_value,'(')-1);
1131:
1132: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1133: aso_debug_pub.add('l_qte_access_tbl(2).RESOURCE_GRP_ID: ' || l_qte_access_tbl(2).RESOURCE_GRP_ID, 1, 'N');
1134: END IF;
1135:
1136: if l_qte_access_tbl(2).RESOURCE_GRP_ID is null then
1137:

Line 1140: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1136: if l_qte_access_tbl(2).RESOURCE_GRP_ID is null then
1137:
1138: c_profile_value := FND_PROFILE.Value_Specific( 'AST_DEFAULT_ROLE_AND_GROUP', G_USER_ID, NULL, 521);
1139:
1140: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1141: aso_debug_pub.add('c_profile_value: ' || c_profile_value, 1, 'N');
1142: END IF;
1143:
1144: l_qte_access_tbl(2).RESOURCE_GRP_ID := substr(c_profile_value, instr(c_profile_value,':', -1) + 1, length(c_profile_value));

Line 1141: aso_debug_pub.add('c_profile_value: ' || c_profile_value, 1, 'N');

1137:
1138: c_profile_value := FND_PROFILE.Value_Specific( 'AST_DEFAULT_ROLE_AND_GROUP', G_USER_ID, NULL, 521);
1139:
1140: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1141: aso_debug_pub.add('c_profile_value: ' || c_profile_value, 1, 'N');
1142: END IF;
1143:
1144: l_qte_access_tbl(2).RESOURCE_GRP_ID := substr(c_profile_value, instr(c_profile_value,':', -1) + 1, length(c_profile_value));
1145:

Line 1146: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1142: END IF;
1143:
1144: l_qte_access_tbl(2).RESOURCE_GRP_ID := substr(c_profile_value, instr(c_profile_value,':', -1) + 1, length(c_profile_value));
1145:
1146: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1147: aso_debug_pub.add('l_qte_access_tbl(2).RESOURCE_GRP_ID: ' || l_qte_access_tbl(2).RESOURCE_GRP_ID, 1, 'N');
1148: END IF;
1149:
1150: end if;

Line 1147: aso_debug_pub.add('l_qte_access_tbl(2).RESOURCE_GRP_ID: ' || l_qte_access_tbl(2).RESOURCE_GRP_ID, 1, 'N');

1143:
1144: l_qte_access_tbl(2).RESOURCE_GRP_ID := substr(c_profile_value, instr(c_profile_value,':', -1) + 1, length(c_profile_value));
1145:
1146: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1147: aso_debug_pub.add('l_qte_access_tbl(2).RESOURCE_GRP_ID: ' || l_qte_access_tbl(2).RESOURCE_GRP_ID, 1, 'N');
1148: END IF;
1149:
1150: end if;
1151:

Line 1155: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1151:
1152: end if;
1153:
1154:
1155: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1156: aso_debug_pub.add('ASO_SECURITY_INT: Add_SalesRep_QuoteCreator: before Add_Resource: c_user_resource_rec.resource_id: ' || c_user_resource_rec.resource_id, 1, 'N');
1157: aso_debug_pub.add('ASO_SECURITY_INT: Add_SalesRep_QuoteCreator: before Add_Resource: l_qte_access_tbl(2).RESOURCE_GRP_ID: ' || l_qte_access_tbl(2).RESOURCE_GRP_ID, 1, 'N');
1158: END IF;
1159:

Line 1156: aso_debug_pub.add('ASO_SECURITY_INT: Add_SalesRep_QuoteCreator: before Add_Resource: c_user_resource_rec.resource_id: ' || c_user_resource_rec.resource_id, 1, 'N');

1152: end if;
1153:
1154:
1155: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1156: aso_debug_pub.add('ASO_SECURITY_INT: Add_SalesRep_QuoteCreator: before Add_Resource: c_user_resource_rec.resource_id: ' || c_user_resource_rec.resource_id, 1, 'N');
1157: aso_debug_pub.add('ASO_SECURITY_INT: Add_SalesRep_QuoteCreator: before Add_Resource: l_qte_access_tbl(2).RESOURCE_GRP_ID: ' || l_qte_access_tbl(2).RESOURCE_GRP_ID, 1, 'N');
1158: END IF;
1159:
1160: END IF;

Line 1157: aso_debug_pub.add('ASO_SECURITY_INT: Add_SalesRep_QuoteCreator: before Add_Resource: l_qte_access_tbl(2).RESOURCE_GRP_ID: ' || l_qte_access_tbl(2).RESOURCE_GRP_ID, 1, 'N');

1153:
1154:
1155: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1156: aso_debug_pub.add('ASO_SECURITY_INT: Add_SalesRep_QuoteCreator: before Add_Resource: c_user_resource_rec.resource_id: ' || c_user_resource_rec.resource_id, 1, 'N');
1157: aso_debug_pub.add('ASO_SECURITY_INT: Add_SalesRep_QuoteCreator: before Add_Resource: l_qte_access_tbl(2).RESOURCE_GRP_ID: ' || l_qte_access_tbl(2).RESOURCE_GRP_ID, 1, 'N');
1158: END IF;
1159:
1160: END IF;
1161:

Line 1164: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1160: END IF;
1161:
1162: END LOOP;
1163:
1164: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1165: aso_debug_pub.add('ASO_SECURITY_INT: Add_SalesRep_QuoteCreator: before Add_Resource', 1, 'Y');
1166: END IF;
1167:
1168: ASO_SECURITY_INT.Add_Resource(

Line 1165: aso_debug_pub.add('ASO_SECURITY_INT: Add_SalesRep_QuoteCreator: before Add_Resource', 1, 'Y');

1161:
1162: END LOOP;
1163:
1164: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1165: aso_debug_pub.add('ASO_SECURITY_INT: Add_SalesRep_QuoteCreator: before Add_Resource', 1, 'Y');
1166: END IF;
1167:
1168: ASO_SECURITY_INT.Add_Resource(
1169: P_INIT_MSG_LIST => FND_API.G_FALSE,

Line 1180: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1176: );
1177:
1178: l_qte_access_tbl := lx_qte_access_tbl;
1179:
1180: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1181: aso_debug_pub.add('ASO_SECURITY_INT: Add_SalesRep_QuoteCreator: after Add_Resource: x_return_status: ' || x_return_status, 1, 'Y');
1182: END IF;
1183:
1184: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1181: aso_debug_pub.add('ASO_SECURITY_INT: Add_SalesRep_QuoteCreator: after Add_Resource: x_return_status: ' || x_return_status, 1, 'Y');

1177:
1178: l_qte_access_tbl := lx_qte_access_tbl;
1179:
1180: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1181: aso_debug_pub.add('ASO_SECURITY_INT: Add_SalesRep_QuoteCreator: after Add_Resource: x_return_status: ' || x_return_status, 1, 'Y');
1182: END IF;
1183:
1184: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1185: RAISE FND_API.G_EXC_ERROR;

Line 1192: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1188: END IF;
1189:
1190: -- End of API body
1191:
1192: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1193: aso_debug_pub.add('ASO_SECURITY_INT: Add_SalesRep_QuoteCreator: End of API body', 1, 'Y');
1194: END IF;
1195: -- Standard check of p_commit.
1196: IF FND_API.To_Boolean(p_commit) THEN

Line 1193: aso_debug_pub.add('ASO_SECURITY_INT: Add_SalesRep_QuoteCreator: End of API body', 1, 'Y');

1189:
1190: -- End of API body
1191:
1192: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1193: aso_debug_pub.add('ASO_SECURITY_INT: Add_SalesRep_QuoteCreator: End of API body', 1, 'Y');
1194: END IF;
1195: -- Standard check of p_commit.
1196: IF FND_API.To_Boolean(p_commit) THEN
1197: COMMIT WORK;