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_WF_HIERARCHY_PKG dependencies on FND_API

Line 58: p_commit in varchar2 := FND_API.G_FALSE,

54: p_PROCESS_OWNER_ID IN NUMBER,
55: p_PROCESS_CATEGORY IN VARCHAR2,
56: p_APPLICATION_OWNER_ID IN NUMBER,
57: p_FINANCE_OWNER_ID IN NUMBER,
58: p_commit in varchar2 := FND_API.G_FALSE,
59: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
60: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
61: x_return_status out nocopy varchar2,
62: x_msg_count out nocopy number,

Line 59: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

55: p_PROCESS_CATEGORY IN VARCHAR2,
56: p_APPLICATION_OWNER_ID IN NUMBER,
57: p_FINANCE_OWNER_ID IN NUMBER,
58: p_commit in varchar2 := FND_API.G_FALSE,
59: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
60: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
61: x_return_status out nocopy varchar2,
62: x_msg_count out nocopy number,
63: x_msg_data out nocopy varchar2

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

56: p_APPLICATION_OWNER_ID IN NUMBER,
57: p_FINANCE_OWNER_ID IN NUMBER,
58: p_commit in varchar2 := FND_API.G_FALSE,
59: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
60: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
61: x_return_status out nocopy varchar2,
62: x_msg_count out nocopy number,
63: x_msg_data out nocopy varchar2
64: ) is

Line 110: x_return_status := FND_API.G_RET_STS_SUCCESS;

106:
107:
108: begin
109:
110: x_return_status := FND_API.G_RET_STS_SUCCESS;
111: IF FND_API.to_Boolean( p_init_msg_list ) THEN
112: FND_MSG_PUB.initialize;
113: END IF;
114: IF FND_GLOBAL.User_Id IS NULL THEN

Line 111: IF FND_API.to_Boolean( p_init_msg_list ) THEN

107:
108: begin
109:
110: x_return_status := FND_API.G_RET_STS_SUCCESS;
111: IF FND_API.to_Boolean( p_init_msg_list ) THEN
112: FND_MSG_PUB.initialize;
113: END IF;
114: IF FND_GLOBAL.User_Id IS NULL THEN
115: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

Line 116: RAISE FND_API.G_EXC_ERROR;

112: FND_MSG_PUB.initialize;
113: END IF;
114: IF FND_GLOBAL.User_Id IS NULL THEN
115: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
116: RAISE FND_API.G_EXC_ERROR;
117: END IF;
118:
119: select fnd_profile.value('AMW_SET_STD_PROCESS') into l_std_process_flag from dual;
120:

Line 301: x_return_status := FND_API.G_RET_STS_ERROR;

297: exception
298:
299: WHEN amw_deadlock_detected THEN
300: ROLLBACK;
301: x_return_status := FND_API.G_RET_STS_ERROR;
302: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
303:
304: WHEN FND_API.G_EXC_ERROR THEN
305: ROLLBACK;

Line 302: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

298:
299: WHEN amw_deadlock_detected THEN
300: ROLLBACK;
301: x_return_status := FND_API.G_RET_STS_ERROR;
302: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
303:
304: WHEN FND_API.G_EXC_ERROR THEN
305: ROLLBACK;
306: x_return_status := FND_API.G_RET_STS_ERROR;

Line 304: WHEN FND_API.G_EXC_ERROR THEN

300: ROLLBACK;
301: x_return_status := FND_API.G_RET_STS_ERROR;
302: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
303:
304: WHEN FND_API.G_EXC_ERROR THEN
305: ROLLBACK;
306: x_return_status := FND_API.G_RET_STS_ERROR;
307: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
308:

Line 306: x_return_status := FND_API.G_RET_STS_ERROR;

302: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
303:
304: WHEN FND_API.G_EXC_ERROR THEN
305: ROLLBACK;
306: x_return_status := FND_API.G_RET_STS_ERROR;
307: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
308:
309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
310: ROLLBACK;

Line 307: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

303:
304: WHEN FND_API.G_EXC_ERROR THEN
305: ROLLBACK;
306: x_return_status := FND_API.G_RET_STS_ERROR;
307: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
308:
309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
310: ROLLBACK;
311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

305: ROLLBACK;
306: x_return_status := FND_API.G_RET_STS_ERROR;
307: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
308:
309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
310: ROLLBACK;
311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
312: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
313:

Line 311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

307: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
308:
309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
310: ROLLBACK;
311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
312: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
313:
314: WHEN OTHERS THEN
315: ROLLBACK;

Line 312: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

308:
309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
310: ROLLBACK;
311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
312: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
313:
314: WHEN OTHERS THEN
315: ROLLBACK;
316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

312: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
313:
314: WHEN OTHERS THEN
315: ROLLBACK;
316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
317: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
318: THEN
319: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
320: END IF;

Line 321: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

317: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
318: THEN
319: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
320: END IF;
321: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
322:
323: end write_amw_process;
324:
325:

Line 1121: p_commit in varchar2 := FND_API.G_FALSE,

1117: -- directly under the root node.
1118: procedure associate_org_process(
1119: p_process_id in number,
1120: p_org_id in number,
1121: p_commit in varchar2 := FND_API.G_FALSE,
1122: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1123: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1124: x_return_status out nocopy varchar2,
1125: x_msg_count out nocopy number,

Line 1122: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1118: procedure associate_org_process(
1119: p_process_id in number,
1120: p_org_id in number,
1121: p_commit in varchar2 := FND_API.G_FALSE,
1122: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1123: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1124: x_return_status out nocopy varchar2,
1125: x_msg_count out nocopy number,
1126: x_msg_data out nocopy varchar2) is

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

1119: p_process_id in number,
1120: p_org_id in number,
1121: p_commit in varchar2 := FND_API.G_FALSE,
1122: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1123: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1124: x_return_status out nocopy varchar2,
1125: x_msg_count out nocopy number,
1126: x_msg_data out nocopy varchar2) is
1127:

Line 1137: x_return_status := FND_API.G_RET_STS_SUCCESS;

1133: l_msg_count number;
1134: l_msg_data varchar2(4000);
1135:
1136: begin
1137: x_return_status := FND_API.G_RET_STS_SUCCESS;
1138: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1139: FND_MSG_PUB.initialize;
1140: END IF;
1141: IF FND_GLOBAL.User_Id IS NULL THEN

Line 1138: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1134: l_msg_data varchar2(4000);
1135:
1136: begin
1137: x_return_status := FND_API.G_RET_STS_SUCCESS;
1138: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1139: FND_MSG_PUB.initialize;
1140: END IF;
1141: IF FND_GLOBAL.User_Id IS NULL THEN
1142: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

Line 1143: RAISE FND_API.G_EXC_ERROR;

1139: FND_MSG_PUB.initialize;
1140: END IF;
1141: IF FND_GLOBAL.User_Id IS NULL THEN
1142: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
1143: RAISE FND_API.G_EXC_ERROR;
1144: END IF;
1145:
1146: begin
1147:

Line 1199: WHEN FND_API.G_EXC_ERROR THEN

1195: reset_proc_org_risk_ctrl_count(p_org_id);
1196: reset_org_count;
1197:
1198: exception
1199: WHEN FND_API.G_EXC_ERROR THEN
1200: ROLLBACK;
1201: x_return_status := FND_API.G_RET_STS_ERROR;
1202: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1203:

Line 1201: x_return_status := FND_API.G_RET_STS_ERROR;

1197:
1198: exception
1199: WHEN FND_API.G_EXC_ERROR THEN
1200: ROLLBACK;
1201: x_return_status := FND_API.G_RET_STS_ERROR;
1202: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1203:
1204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1205: ROLLBACK;

Line 1202: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1198: exception
1199: WHEN FND_API.G_EXC_ERROR THEN
1200: ROLLBACK;
1201: x_return_status := FND_API.G_RET_STS_ERROR;
1202: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1203:
1204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1205: ROLLBACK;
1206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1200: ROLLBACK;
1201: x_return_status := FND_API.G_RET_STS_ERROR;
1202: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1203:
1204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1205: ROLLBACK;
1206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1207: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1208:

Line 1206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1202: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1203:
1204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1205: ROLLBACK;
1206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1207: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1208:
1209: WHEN amw_deadlock_detected THEN
1210: ROLLBACK;

Line 1207: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1203:
1204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1205: ROLLBACK;
1206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1207: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1208:
1209: WHEN amw_deadlock_detected THEN
1210: ROLLBACK;
1211: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1211: x_return_status := FND_API.G_RET_STS_ERROR;

1207: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1208:
1209: WHEN amw_deadlock_detected THEN
1210: ROLLBACK;
1211: x_return_status := FND_API.G_RET_STS_ERROR;
1212: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1213:
1214: WHEN OTHERS THEN
1215: ROLLBACK;

Line 1212: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1208:
1209: WHEN amw_deadlock_detected THEN
1210: ROLLBACK;
1211: x_return_status := FND_API.G_RET_STS_ERROR;
1212: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1213:
1214: WHEN OTHERS THEN
1215: ROLLBACK;
1216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1212: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1213:
1214: WHEN OTHERS THEN
1215: ROLLBACK;
1216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1217: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1218: THEN
1219: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1220: END IF;

Line 1221: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1217: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1218: THEN
1219: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1220: END IF;
1221: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1222:
1223: end associate_org_process;
1224:
1225: --npanandi commented this on 10/18/2004, for syncing between the version

Line 1238: p_commit in varchar2 := FND_API.G_FALSE,

1234: p_batch_id in number := null,
1235: p_rcm_org_intf_id in number := null,
1236: p_risk_id in number := null,
1237: p_control_id in number := null,
1238: p_commit in varchar2 := FND_API.G_FALSE,
1239: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1240: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1241: x_return_status out nocopy varchar2,
1242: x_msg_count out nocopy number,

Line 1239: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1235: p_rcm_org_intf_id in number := null,
1236: p_risk_id in number := null,
1237: p_control_id in number := null,
1238: p_commit in varchar2 := FND_API.G_FALSE,
1239: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1240: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1241: x_return_status out nocopy varchar2,
1242: x_msg_count out nocopy number,
1243: x_msg_data out nocopy varchar2) is

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

1236: p_risk_id in number := null,
1237: p_control_id in number := null,
1238: p_commit in varchar2 := FND_API.G_FALSE,
1239: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1240: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1241: x_return_status out nocopy varchar2,
1242: x_msg_count out nocopy number,
1243: x_msg_data out nocopy varchar2) is
1244:

Line 1254: x_return_status := FND_API.G_RET_STS_SUCCESS;

1250: l_msg_count number;
1251: l_msg_data varchar2(4000);
1252:
1253: begin
1254: x_return_status := FND_API.G_RET_STS_SUCCESS;
1255: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1256: FND_MSG_PUB.initialize;
1257: END IF;
1258: IF FND_GLOBAL.User_Id IS NULL THEN

Line 1255: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1251: l_msg_data varchar2(4000);
1252:
1253: begin
1254: x_return_status := FND_API.G_RET_STS_SUCCESS;
1255: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1256: FND_MSG_PUB.initialize;
1257: END IF;
1258: IF FND_GLOBAL.User_Id IS NULL THEN
1259: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

Line 1260: RAISE FND_API.G_EXC_ERROR;

1256: FND_MSG_PUB.initialize;
1257: END IF;
1258: IF FND_GLOBAL.User_Id IS NULL THEN
1259: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
1260: RAISE FND_API.G_EXC_ERROR;
1261: END IF;
1262:
1263: fnd_file.put_line(fnd_file.LOG, 'INSIDE ASSOCIATE_ORG_PROCESS');
1264: fnd_file.put_line(fnd_file.LOG, 'p_process_id: '||p_process_id);

Line 1335: WHEN FND_API.G_EXC_ERROR THEN

1331: reset_proc_org_risk_ctrl_count(p_org_id);
1332: reset_org_count;
1333:
1334: exception
1335: WHEN FND_API.G_EXC_ERROR THEN
1336: ROLLBACK;
1337: x_return_status := FND_API.G_RET_STS_ERROR;
1338: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1339:

Line 1337: x_return_status := FND_API.G_RET_STS_ERROR;

1333:
1334: exception
1335: WHEN FND_API.G_EXC_ERROR THEN
1336: ROLLBACK;
1337: x_return_status := FND_API.G_RET_STS_ERROR;
1338: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1339:
1340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1341: ROLLBACK;

Line 1338: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1334: exception
1335: WHEN FND_API.G_EXC_ERROR THEN
1336: ROLLBACK;
1337: x_return_status := FND_API.G_RET_STS_ERROR;
1338: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1339:
1340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1341: ROLLBACK;
1342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1336: ROLLBACK;
1337: x_return_status := FND_API.G_RET_STS_ERROR;
1338: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1339:
1340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1341: ROLLBACK;
1342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1343: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1344:

Line 1342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1338: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1339:
1340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1341: ROLLBACK;
1342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1343: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1344:
1345: WHEN amw_deadlock_detected THEN
1346: ROLLBACK;

Line 1343: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1339:
1340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1341: ROLLBACK;
1342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1343: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1344:
1345: WHEN amw_deadlock_detected THEN
1346: ROLLBACK;
1347: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1347: x_return_status := FND_API.G_RET_STS_ERROR;

1343: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1344:
1345: WHEN amw_deadlock_detected THEN
1346: ROLLBACK;
1347: x_return_status := FND_API.G_RET_STS_ERROR;
1348: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1349:
1350: WHEN OTHERS THEN
1351: ROLLBACK;

Line 1348: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1344:
1345: WHEN amw_deadlock_detected THEN
1346: ROLLBACK;
1347: x_return_status := FND_API.G_RET_STS_ERROR;
1348: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1349:
1350: WHEN OTHERS THEN
1351: ROLLBACK;
1352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1348: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1349:
1350: WHEN OTHERS THEN
1351: ROLLBACK;
1352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1353: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1354: THEN
1355: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1356: END IF;

Line 1357: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1353: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1354: THEN
1355: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1356: END IF;
1357: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1358:
1359: end associate_org_process;
1360: **/
1361: ------------------------------------------------------------------------------------------------------------

Line 1446: p_commit in varchar2 := FND_API.G_FALSE,

1442: -- disassociate api for each.
1443: procedure disassociate_process_org(
1444: p_process_id in number,
1445: p_org_id in number,
1446: p_commit in varchar2 := FND_API.G_FALSE,
1447: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1448: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1449: x_return_status out nocopy varchar2,
1450: x_msg_count out nocopy number,

Line 1447: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1443: procedure disassociate_process_org(
1444: p_process_id in number,
1445: p_org_id in number,
1446: p_commit in varchar2 := FND_API.G_FALSE,
1447: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1448: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1449: x_return_status out nocopy varchar2,
1450: x_msg_count out nocopy number,
1451: x_msg_data out nocopy varchar2) is

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

1444: p_process_id in number,
1445: p_org_id in number,
1446: p_commit in varchar2 := FND_API.G_FALSE,
1447: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1448: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1449: x_return_status out nocopy varchar2,
1450: x_msg_count out nocopy number,
1451: x_msg_data out nocopy varchar2) is
1452:

Line 1459: x_return_status := FND_API.G_RET_STS_SUCCESS;

1455: l_apo_type AMW_PROC_ORG_HIERARCHY_PVT.apo_type;
1456:
1457: begin
1458:
1459: x_return_status := FND_API.G_RET_STS_SUCCESS;
1460: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1461: FND_MSG_PUB.initialize;
1462: END IF;
1463: IF FND_GLOBAL.User_Id IS NULL THEN

Line 1460: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1456:
1457: begin
1458:
1459: x_return_status := FND_API.G_RET_STS_SUCCESS;
1460: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1461: FND_MSG_PUB.initialize;
1462: END IF;
1463: IF FND_GLOBAL.User_Id IS NULL THEN
1464: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

Line 1465: RAISE FND_API.G_EXC_ERROR;

1461: FND_MSG_PUB.initialize;
1462: END IF;
1463: IF FND_GLOBAL.User_Id IS NULL THEN
1464: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
1465: RAISE FND_API.G_EXC_ERROR;
1466: END IF;
1467:
1468: -- first disassociate the process itself, then loop through the org hierarchy
1469: l_apo_type.process_id := p_process_id;

Line 1499: WHEN FND_API.G_EXC_ERROR THEN

1495: reset_proc_org_risk_ctrl_count(p_org_id);
1496: reset_org_count;
1497:
1498: exception
1499: WHEN FND_API.G_EXC_ERROR THEN
1500: ROLLBACK;
1501: x_return_status := FND_API.G_RET_STS_ERROR;
1502: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1503:

Line 1501: x_return_status := FND_API.G_RET_STS_ERROR;

1497:
1498: exception
1499: WHEN FND_API.G_EXC_ERROR THEN
1500: ROLLBACK;
1501: x_return_status := FND_API.G_RET_STS_ERROR;
1502: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1503:
1504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1505: ROLLBACK;

Line 1502: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1498: exception
1499: WHEN FND_API.G_EXC_ERROR THEN
1500: ROLLBACK;
1501: x_return_status := FND_API.G_RET_STS_ERROR;
1502: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1503:
1504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1505: ROLLBACK;
1506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1500: ROLLBACK;
1501: x_return_status := FND_API.G_RET_STS_ERROR;
1502: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1503:
1504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1505: ROLLBACK;
1506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1507: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1508:

Line 1506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1502: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1503:
1504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1505: ROLLBACK;
1506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1507: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1508:
1509: WHEN amw_deadlock_detected THEN
1510: ROLLBACK;

Line 1507: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1503:
1504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1505: ROLLBACK;
1506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1507: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1508:
1509: WHEN amw_deadlock_detected THEN
1510: ROLLBACK;
1511: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1511: x_return_status := FND_API.G_RET_STS_ERROR;

1507: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1508:
1509: WHEN amw_deadlock_detected THEN
1510: ROLLBACK;
1511: x_return_status := FND_API.G_RET_STS_ERROR;
1512: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1513:
1514:
1515: WHEN OTHERS THEN

Line 1512: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1508:
1509: WHEN amw_deadlock_detected THEN
1510: ROLLBACK;
1511: x_return_status := FND_API.G_RET_STS_ERROR;
1512: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1513:
1514:
1515: WHEN OTHERS THEN
1516: ROLLBACK;

Line 1517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1513:
1514:
1515: WHEN OTHERS THEN
1516: ROLLBACK;
1517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1518: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1519: THEN
1520: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1521: END IF;

Line 1522: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1518: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1519: THEN
1520: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1521: END IF;
1522: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1523:
1524:
1525: end disassociate_process_org;
1526:

Line 1603: p_commit in varchar2 := FND_API.G_FALSE,

1599: p_child_process_id in number,
1600: p_org_id in number,
1601: p_exception_yes in varchar2,
1602: p_process_owner_party_id in number,
1603: p_commit in varchar2 := FND_API.G_FALSE,
1604: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1605: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1606: x_return_status out nocopy varchar2,
1607: x_msg_count out nocopy number,

Line 1604: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1600: p_org_id in number,
1601: p_exception_yes in varchar2,
1602: p_process_owner_party_id in number,
1603: p_commit in varchar2 := FND_API.G_FALSE,
1604: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1605: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1606: x_return_status out nocopy varchar2,
1607: x_msg_count out nocopy number,
1608: x_msg_data out nocopy varchar2

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

1601: p_exception_yes in varchar2,
1602: p_process_owner_party_id in number,
1603: p_commit in varchar2 := FND_API.G_FALSE,
1604: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1605: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1606: x_return_status out nocopy varchar2,
1607: x_msg_count out nocopy number,
1608: x_msg_data out nocopy varchar2
1609: ) is

Line 1627: x_return_status := FND_API.G_RET_STS_SUCCESS;

1623: l_child_disp_name varchar2(100);
1624: l_org_name varchar2(100);
1625:
1626: begin
1627: x_return_status := FND_API.G_RET_STS_SUCCESS;
1628: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1629: FND_MSG_PUB.initialize;
1630: END IF;
1631: IF FND_GLOBAL.User_Id IS NULL THEN

Line 1628: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1624: l_org_name varchar2(100);
1625:
1626: begin
1627: x_return_status := FND_API.G_RET_STS_SUCCESS;
1628: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1629: FND_MSG_PUB.initialize;
1630: END IF;
1631: IF FND_GLOBAL.User_Id IS NULL THEN
1632: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

Line 1633: RAISE FND_API.G_EXC_ERROR;

1629: FND_MSG_PUB.initialize;
1630: END IF;
1631: IF FND_GLOBAL.User_Id IS NULL THEN
1632: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
1633: RAISE FND_API.G_EXC_ERROR;
1634: END IF;
1635:
1636: if p_process_owner_party_id <> 0 then
1637:

Line 1770: WHEN FND_API.G_EXC_ERROR THEN

1766: reset_proc_org_risk_ctrl_count(p_org_id);
1767: reset_org_count;
1768:
1769: exception
1770: WHEN FND_API.G_EXC_ERROR THEN
1771: ROLLBACK;
1772: x_return_status := FND_API.G_RET_STS_ERROR;
1773: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1774:

Line 1772: x_return_status := FND_API.G_RET_STS_ERROR;

1768:
1769: exception
1770: WHEN FND_API.G_EXC_ERROR THEN
1771: ROLLBACK;
1772: x_return_status := FND_API.G_RET_STS_ERROR;
1773: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1774:
1775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1776: ROLLBACK;

Line 1773: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1769: exception
1770: WHEN FND_API.G_EXC_ERROR THEN
1771: ROLLBACK;
1772: x_return_status := FND_API.G_RET_STS_ERROR;
1773: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1774:
1775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1776: ROLLBACK;
1777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1771: ROLLBACK;
1772: x_return_status := FND_API.G_RET_STS_ERROR;
1773: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1774:
1775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1776: ROLLBACK;
1777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1778: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1779:

Line 1777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1773: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1774:
1775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1776: ROLLBACK;
1777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1778: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1779:
1780: WHEN amw_deadlock_detected THEN
1781: ROLLBACK;

Line 1778: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1774:
1775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1776: ROLLBACK;
1777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1778: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1779:
1780: WHEN amw_deadlock_detected THEN
1781: ROLLBACK;
1782: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1782: x_return_status := FND_API.G_RET_STS_ERROR;

1778: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1779:
1780: WHEN amw_deadlock_detected THEN
1781: ROLLBACK;
1782: x_return_status := FND_API.G_RET_STS_ERROR;
1783: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1784:
1785: WHEN OTHERS THEN
1786: ROLLBACK;

Line 1783: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1779:
1780: WHEN amw_deadlock_detected THEN
1781: ROLLBACK;
1782: x_return_status := FND_API.G_RET_STS_ERROR;
1783: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1784:
1785: WHEN OTHERS THEN
1786: ROLLBACK;
1787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1783: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1784:
1785: WHEN OTHERS THEN
1786: ROLLBACK;
1787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1788: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1789: THEN
1790: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1791: END IF;

Line 1792: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1788: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1789: THEN
1790: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1791: END IF;
1792: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1793:
1794: end modify_org_relation;
1795:
1796:

Line 1844: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1840: x_msg_count => x_msg_count ,
1841: x_msg_data => x_msg_data);
1842:
1843: FND_FILE.PUT_LINE(FND_FILE.LOG,'Return Status :' || x_return_status || ':'||x_msg_count||':'||x_msg_data);
1844: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1845: ROLLBACK;
1846: retcode := 2;
1847: IF x_msg_count <> 1 THEN
1848: FND_MSG_PUB.GET(p_encoded => FND_API.G_FALSE, p_data => x_msg_data, p_msg_index_out => l_msg_index_out);

Line 1848: FND_MSG_PUB.GET(p_encoded => FND_API.G_FALSE, p_data => x_msg_data, p_msg_index_out => l_msg_index_out);

1844: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1845: ROLLBACK;
1846: retcode := 2;
1847: IF x_msg_count <> 1 THEN
1848: FND_MSG_PUB.GET(p_encoded => FND_API.G_FALSE, p_data => x_msg_data, p_msg_index_out => l_msg_index_out);
1849: END IF;
1850: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error: '|| x_msg_data);
1851: errbuf := SUBSTR(x_msg_data,1,1000);
1852: ELSE

Line 1991: p_commit in varchar2 := FND_API.G_FALSE,

1987:
1988: procedure refresh_process_org (
1989: p_process_id in number,
1990: p_org_id in number,
1991: p_commit in varchar2 := FND_API.G_FALSE,
1992: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1993: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1994: x_return_status out nocopy varchar2,
1995: x_msg_count out nocopy number,

Line 1992: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1988: procedure refresh_process_org (
1989: p_process_id in number,
1990: p_org_id in number,
1991: p_commit in varchar2 := FND_API.G_FALSE,
1992: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1993: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1994: x_return_status out nocopy varchar2,
1995: x_msg_count out nocopy number,
1996: x_msg_data out nocopy varchar2

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

1989: p_process_id in number,
1990: p_org_id in number,
1991: p_commit in varchar2 := FND_API.G_FALSE,
1992: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1993: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1994: x_return_status out nocopy varchar2,
1995: x_msg_count out nocopy number,
1996: x_msg_data out nocopy varchar2
1997: ) is

Line 2025: x_return_status := FND_API.G_RET_STS_SUCCESS;

2021: (select distinct new_pk1 from amw_exceptions_b where ((new_pk2 = l_pid and object_type in ('PROCESS','RISK','CONTROL'))or (object_type = 'PROCESS' and new_pk3 = l_pid)) and new_pk1 is not null);
2022:
2023:
2024: begin
2025: x_return_status := FND_API.G_RET_STS_SUCCESS;
2026: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2027: FND_MSG_PUB.initialize;
2028: END IF;
2029: IF FND_GLOBAL.User_Id IS NULL THEN

Line 2026: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2022:
2023:
2024: begin
2025: x_return_status := FND_API.G_RET_STS_SUCCESS;
2026: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2027: FND_MSG_PUB.initialize;
2028: END IF;
2029: IF FND_GLOBAL.User_Id IS NULL THEN
2030: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

Line 2031: RAISE FND_API.G_EXC_ERROR;

2027: FND_MSG_PUB.initialize;
2028: END IF;
2029: IF FND_GLOBAL.User_Id IS NULL THEN
2030: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
2031: RAISE FND_API.G_EXC_ERROR;
2032: END IF;
2033:
2034: if p_org_id = -1 then
2035:

Line 2097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2093:
2094: exception
2095: WHEN amw_exception THEN
2096: ROLLBACK;
2097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2098: x_msg_count := l_msg_count;
2099: x_msg_data := l_msg_data;
2100:
2101: WHEN FND_API.G_EXC_ERROR THEN

Line 2101: WHEN FND_API.G_EXC_ERROR THEN

2097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2098: x_msg_count := l_msg_count;
2099: x_msg_data := l_msg_data;
2100:
2101: WHEN FND_API.G_EXC_ERROR THEN
2102: ROLLBACK;
2103: x_return_status := FND_API.G_RET_STS_ERROR;
2104: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2105:

Line 2103: x_return_status := FND_API.G_RET_STS_ERROR;

2099: x_msg_data := l_msg_data;
2100:
2101: WHEN FND_API.G_EXC_ERROR THEN
2102: ROLLBACK;
2103: x_return_status := FND_API.G_RET_STS_ERROR;
2104: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2105:
2106: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2107: ROLLBACK;

Line 2104: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

2100:
2101: WHEN FND_API.G_EXC_ERROR THEN
2102: ROLLBACK;
2103: x_return_status := FND_API.G_RET_STS_ERROR;
2104: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2105:
2106: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2107: ROLLBACK;
2108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2106: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2102: ROLLBACK;
2103: x_return_status := FND_API.G_RET_STS_ERROR;
2104: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2105:
2106: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2107: ROLLBACK;
2108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2109: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2110:

Line 2108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2104: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2105:
2106: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2107: ROLLBACK;
2108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2109: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2110:
2111: WHEN amw_deadlock_detected THEN
2112: ROLLBACK;

Line 2109: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

2105:
2106: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2107: ROLLBACK;
2108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2109: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2110:
2111: WHEN amw_deadlock_detected THEN
2112: ROLLBACK;
2113: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2113: x_return_status := FND_API.G_RET_STS_ERROR;

2109: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2110:
2111: WHEN amw_deadlock_detected THEN
2112: ROLLBACK;
2113: x_return_status := FND_API.G_RET_STS_ERROR;
2114: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2115:
2116: WHEN OTHERS THEN
2117: ROLLBACK;

Line 2114: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

2110:
2111: WHEN amw_deadlock_detected THEN
2112: ROLLBACK;
2113: x_return_status := FND_API.G_RET_STS_ERROR;
2114: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2115:
2116: WHEN OTHERS THEN
2117: ROLLBACK;
2118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2114: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2115:
2116: WHEN OTHERS THEN
2117: ROLLBACK;
2118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2119: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2120: THEN
2121: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
2122: END IF;

Line 2123: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

2119: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2120: THEN
2121: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
2122: END IF;
2123: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2124:
2125: end refresh_process_org;
2126:
2127:

Line 2134: p_commit in varchar2 := FND_API.G_FALSE,

2130:
2131: procedure refresh_process_org (
2132: p_process_id in number,
2133: p_org_string in varchar,
2134: p_commit in varchar2 := FND_API.G_FALSE,
2135: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2136: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2137: x_return_status out nocopy varchar2,
2138: x_msg_count out nocopy number,

Line 2135: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2131: procedure refresh_process_org (
2132: p_process_id in number,
2133: p_org_string in varchar,
2134: p_commit in varchar2 := FND_API.G_FALSE,
2135: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2136: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2137: x_return_status out nocopy varchar2,
2138: x_msg_count out nocopy number,
2139: x_msg_data out nocopy varchar2

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

2132: p_process_id in number,
2133: p_org_string in varchar,
2134: p_commit in varchar2 := FND_API.G_FALSE,
2135: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2136: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2137: x_return_status out nocopy varchar2,
2138: x_msg_count out nocopy number,
2139: x_msg_data out nocopy varchar2
2140: ) is

Line 2154: x_return_status := FND_API.G_RET_STS_SUCCESS;

2150: l_org_string varchar2(4000);
2151: orgid number;
2152:
2153: begin
2154: x_return_status := FND_API.G_RET_STS_SUCCESS;
2155: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2156: FND_MSG_PUB.initialize;
2157: END IF;
2158: IF FND_GLOBAL.User_Id IS NULL THEN

Line 2155: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2151: orgid number;
2152:
2153: begin
2154: x_return_status := FND_API.G_RET_STS_SUCCESS;
2155: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2156: FND_MSG_PUB.initialize;
2157: END IF;
2158: IF FND_GLOBAL.User_Id IS NULL THEN
2159: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

Line 2160: RAISE FND_API.G_EXC_ERROR;

2156: FND_MSG_PUB.initialize;
2157: END IF;
2158: IF FND_GLOBAL.User_Id IS NULL THEN
2159: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
2160: RAISE FND_API.G_EXC_ERROR;
2161: END IF;
2162:
2163: l_org_string := p_org_string;
2164: while LENGTH(l_org_string) <> 0 loop

Line 2190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2186:
2187: exception
2188: WHEN amw_exception THEN
2189: ROLLBACK;
2190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2191: x_msg_count := l_msg_count;
2192: x_msg_data := l_msg_data;
2193:
2194: WHEN FND_API.G_EXC_ERROR THEN

Line 2194: WHEN FND_API.G_EXC_ERROR THEN

2190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2191: x_msg_count := l_msg_count;
2192: x_msg_data := l_msg_data;
2193:
2194: WHEN FND_API.G_EXC_ERROR THEN
2195: ROLLBACK;
2196: x_return_status := FND_API.G_RET_STS_ERROR;
2197: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2198:

Line 2196: x_return_status := FND_API.G_RET_STS_ERROR;

2192: x_msg_data := l_msg_data;
2193:
2194: WHEN FND_API.G_EXC_ERROR THEN
2195: ROLLBACK;
2196: x_return_status := FND_API.G_RET_STS_ERROR;
2197: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2198:
2199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2200: ROLLBACK;

Line 2197: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

2193:
2194: WHEN FND_API.G_EXC_ERROR THEN
2195: ROLLBACK;
2196: x_return_status := FND_API.G_RET_STS_ERROR;
2197: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2198:
2199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2200: ROLLBACK;
2201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2195: ROLLBACK;
2196: x_return_status := FND_API.G_RET_STS_ERROR;
2197: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2198:
2199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2200: ROLLBACK;
2201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2202: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2203:

Line 2201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2197: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2198:
2199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2200: ROLLBACK;
2201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2202: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2203:
2204: WHEN amw_deadlock_detected THEN
2205: ROLLBACK;

Line 2202: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

2198:
2199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2200: ROLLBACK;
2201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2202: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2203:
2204: WHEN amw_deadlock_detected THEN
2205: ROLLBACK;
2206: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2206: x_return_status := FND_API.G_RET_STS_ERROR;

2202: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2203:
2204: WHEN amw_deadlock_detected THEN
2205: ROLLBACK;
2206: x_return_status := FND_API.G_RET_STS_ERROR;
2207: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2208:
2209: WHEN OTHERS THEN
2210: ROLLBACK;

Line 2207: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

2203:
2204: WHEN amw_deadlock_detected THEN
2205: ROLLBACK;
2206: x_return_status := FND_API.G_RET_STS_ERROR;
2207: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2208:
2209: WHEN OTHERS THEN
2210: ROLLBACK;
2211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2207: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2208:
2209: WHEN OTHERS THEN
2210: ROLLBACK;
2211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2212: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2213: THEN
2214: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
2215: END IF;

Line 2216: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);

2212: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2213: THEN
2214: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
2215: END IF;
2216: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
2217:
2218: end refresh_process_org;
2219:
2220:

Line 2252: x_return_status := FND_API.G_RET_STS_SUCCESS;

2248: v_parent_pid t_parent_pid;
2249:
2250: begin
2251:
2252: x_return_status := FND_API.G_RET_STS_SUCCESS;
2253:
2254: open c_parents(p_org_id, p_process_id);
2255: loop
2256: fetch c_parents bulk collect into v_parent_pid;

Line 2334: x_return_status := FND_API.G_RET_STS_ERROR;

2330: exception
2331:
2332: WHEN amw_deadlock_detected THEN
2333: ROLLBACK;
2334: x_return_status := FND_API.G_RET_STS_ERROR;
2335: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2336:
2337: WHEN amw_exception THEN
2338: ROLLBACK;

Line 2335: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

2331:
2332: WHEN amw_deadlock_detected THEN
2333: ROLLBACK;
2334: x_return_status := FND_API.G_RET_STS_ERROR;
2335: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2336:
2337: WHEN amw_exception THEN
2338: ROLLBACK;
2339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2335: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2336:
2337: WHEN amw_exception THEN
2338: ROLLBACK;
2339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2340: x_msg_count := l_msg_count;
2341: x_msg_data := l_msg_data;
2342:
2343: WHEN OTHERS THEN

Line 2345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2341: x_msg_data := l_msg_data;
2342:
2343: WHEN OTHERS THEN
2344: ROLLBACK;
2345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2346: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
2347:
2348: end refresh_process_per_org;
2349:

Line 2346: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);

2342:
2343: WHEN OTHERS THEN
2344: ROLLBACK;
2345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2346: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
2347:
2348: end refresh_process_per_org;
2349:
2350:

Line 2395: x_return_status := FND_API.G_RET_STS_SUCCESS;

2391: x_msg_data out nocopy varchar2)
2392: is
2393: l_dummy number;
2394: begin
2395: x_return_status := FND_API.G_RET_STS_SUCCESS;
2396:
2397: select 1 into l_dummy
2398: from amw_process_organization
2399: where process_id = p_process_id

Line 2413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2409:
2410: WHEN OTHERS THEN
2411: ROLLBACK;
2412: p_out := 0;
2413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2414: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
2415:
2416: end check_org_exist;
2417:

Line 2414: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);

2410: WHEN OTHERS THEN
2411: ROLLBACK;
2412: p_out := 0;
2413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2414: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
2415:
2416: end check_org_exist;
2417:
2418:

Line 2433: x_return_status := FND_API.G_RET_STS_SUCCESS;

2429: x_msg_count out nocopy number,
2430: x_msg_data out nocopy varchar2)
2431: is
2432: begin
2433: x_return_status := FND_API.G_RET_STS_SUCCESS;
2434: p_out := 0;
2435: end check_cert_exist;
2436:
2437: ------------------------------------------------------------------------------------------------------------

Line 2452: x_return_status := FND_API.G_RET_STS_SUCCESS;

2448: x_msg_count out nocopy number,
2449: x_msg_data out nocopy varchar2)
2450: is
2451: begin
2452: x_return_status := FND_API.G_RET_STS_SUCCESS;
2453: p_out := 0;
2454: end check_cert_exist;
2455:
2456:

Line 2485: x_return_status := FND_API.G_RET_STS_SUCCESS;

2481: p_cert_out number := 0;
2482: amw_exception exception;
2483:
2484: begin
2485: x_return_status := FND_API.G_RET_STS_SUCCESS;
2486:
2487: check_org_exist( p_process_id => p_process_id,
2488: p_out => p_org_out,
2489: x_return_status => l_return_status,

Line 2520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2516:
2517: exception
2518: WHEN amw_exception THEN
2519: ROLLBACK;
2520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2521: x_msg_count := l_msg_count;
2522: x_msg_data := l_msg_data;
2523:
2524: WHEN OTHERS THEN

Line 2526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2522: x_msg_data := l_msg_data;
2523:
2524: WHEN OTHERS THEN
2525: ROLLBACK;
2526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2527: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
2528:
2529: end check_org_cert_exist;
2530:

Line 2527: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);

2523:
2524: WHEN OTHERS THEN
2525: ROLLBACK;
2526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2527: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
2528:
2529: end check_org_cert_exist;
2530:
2531:

Line 2876: p_init_msg_list VARCHAR2(10) := FND_API.G_FALSE;

2872: x_msg_data out nocopy varchar2)
2873: is
2874:
2875: L_API_NAME CONSTANT VARCHAR2(30) := 'synch_hierarchy_amw_process';
2876: p_init_msg_list VARCHAR2(10) := FND_API.G_FALSE;
2877:
2878: type t_amwp_name is table of amw_process.name%type;
2879: v_amwp_name t_amwp_name;
2880: type t_amwp_pid is table of amw_process.process_id%type;

Line 2951: x_return_status := FND_API.G_RET_STS_SUCCESS;

2947: amw_processing_exception exception;
2948:
2949:
2950: begin
2951: x_return_status := FND_API.G_RET_STS_SUCCESS;
2952: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2953: FND_MSG_PUB.initialize;
2954: END IF;
2955: IF FND_GLOBAL.User_Id IS NULL THEN

Line 2952: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2948:
2949:
2950: begin
2951: x_return_status := FND_API.G_RET_STS_SUCCESS;
2952: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2953: FND_MSG_PUB.initialize;
2954: END IF;
2955: IF FND_GLOBAL.User_Id IS NULL THEN
2956: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

Line 2957: RAISE FND_API.G_EXC_ERROR;

2953: FND_MSG_PUB.initialize;
2954: END IF;
2955: IF FND_GLOBAL.User_Id IS NULL THEN
2956: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
2957: RAISE FND_API.G_EXC_ERROR;
2958: END IF;
2959:
2960: -- go through amw_process, see if the process does NOT exist as a child of ALL Process
2961: -- in wf, in that case, delete the row from amw_process. This is to take care of

Line 3120: IF x_return_status1 <> FND_API.G_RET_STS_SUCCESS THEN

3116: x_msg_count => x_msg_count1,
3117: x_msg_data => x_msg_data1);
3118:
3119: -- kosriniv begin :- Check the return status, and if error then raise the amw_processing_exception to handle it.
3120: IF x_return_status1 <> FND_API.G_RET_STS_SUCCESS THEN
3121: RAISE amw_processing_exception;
3122: END IF;
3123: -- kosriniv end
3124: v_index1 := v_org.next(v_index1);

Line 3197: x_return_status := FND_API.G_RET_STS_ERROR;

3193: exception
3194:
3195: WHEN amw_deadlock_detected THEN
3196: ROLLBACK;
3197: x_return_status := FND_API.G_RET_STS_ERROR;
3198: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3199:
3200: WHEN FND_API.G_EXC_ERROR THEN
3201: ROLLBACK;

Line 3198: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

3194:
3195: WHEN amw_deadlock_detected THEN
3196: ROLLBACK;
3197: x_return_status := FND_API.G_RET_STS_ERROR;
3198: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3199:
3200: WHEN FND_API.G_EXC_ERROR THEN
3201: ROLLBACK;
3202: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3200: WHEN FND_API.G_EXC_ERROR THEN

3196: ROLLBACK;
3197: x_return_status := FND_API.G_RET_STS_ERROR;
3198: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3199:
3200: WHEN FND_API.G_EXC_ERROR THEN
3201: ROLLBACK;
3202: x_return_status := FND_API.G_RET_STS_ERROR;
3203: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3204:

Line 3202: x_return_status := FND_API.G_RET_STS_ERROR;

3198: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3199:
3200: WHEN FND_API.G_EXC_ERROR THEN
3201: ROLLBACK;
3202: x_return_status := FND_API.G_RET_STS_ERROR;
3203: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3204:
3205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3206: ROLLBACK;

Line 3203: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

3199:
3200: WHEN FND_API.G_EXC_ERROR THEN
3201: ROLLBACK;
3202: x_return_status := FND_API.G_RET_STS_ERROR;
3203: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3204:
3205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3206: ROLLBACK;
3207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3201: ROLLBACK;
3202: x_return_status := FND_API.G_RET_STS_ERROR;
3203: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3204:
3205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3206: ROLLBACK;
3207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3208: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3209:

Line 3207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3203: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3204:
3205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3206: ROLLBACK;
3207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3208: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3209:
3210:
3211: -- kosriniv begin :- Handle amw_processing_exception

Line 3208: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

3204:
3205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3206: ROLLBACK;
3207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3208: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3209:
3210:
3211: -- kosriniv begin :- Handle amw_processing_exception
3212: WHEN amw_processing_exception THEN

Line 3223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3219: -- kosriniv end.
3220:
3221: WHEN OTHERS THEN
3222: ROLLBACK;
3223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3224: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3225: THEN
3226: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
3227: END IF;

Line 3228: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

3224: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3225: THEN
3226: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
3227: END IF;
3228: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3229:
3230: end adhoc_synch_hier_amw_proc;
3231:
3232: ------------------------------------------------------------------------------------------------------------

Line 3243: p_init_msg_list VARCHAR2(10) := FND_API.G_FALSE;

3239: x_msg_data out nocopy varchar2)
3240: is
3241:
3242: L_API_NAME CONSTANT VARCHAR2(30) := 'old_synch_hier_amw_process';
3243: p_init_msg_list VARCHAR2(10) := FND_API.G_FALSE;
3244:
3245: type t_amwp_name is table of amw_process.name%type;
3246: v_amwp_name t_amwp_name;
3247: type t_amwp_pid is table of amw_process.process_id%type;

Line 3292: x_return_status := FND_API.G_RET_STS_SUCCESS;

3288: amw_processing_exception exception;
3289:
3290:
3291: begin
3292: x_return_status := FND_API.G_RET_STS_SUCCESS;
3293: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3294: FND_MSG_PUB.initialize;
3295: END IF;
3296: IF FND_GLOBAL.User_Id IS NULL THEN

Line 3293: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3289:
3290:
3291: begin
3292: x_return_status := FND_API.G_RET_STS_SUCCESS;
3293: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3294: FND_MSG_PUB.initialize;
3295: END IF;
3296: IF FND_GLOBAL.User_Id IS NULL THEN
3297: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

Line 3298: RAISE FND_API.G_EXC_ERROR;

3294: FND_MSG_PUB.initialize;
3295: END IF;
3296: IF FND_GLOBAL.User_Id IS NULL THEN
3297: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
3298: RAISE FND_API.G_EXC_ERROR;
3299: END IF;
3300:
3301: -- go through amw_process, see if the process does NOT exist as a child of ALL Process
3302: -- in wf, in that case, delete the row from amw_process. This is to take care of

Line 3373: IF x_return_status1 <> FND_API.G_RET_STS_SUCCESS THEN

3369: x_msg_count => x_msg_count1,
3370: x_msg_data => x_msg_data1);
3371:
3372: -- kosriniv begin :- Check the return status, and if error then raise the amw_processing_exception to handle it.
3373: IF x_return_status1 <> FND_API.G_RET_STS_SUCCESS THEN
3374: RAISE amw_processing_exception;
3375: END IF;
3376: -- kosriniv end
3377: v_index1 := v_org.next(v_index1);

Line 3450: x_return_status := FND_API.G_RET_STS_ERROR;

3446: exception
3447:
3448: WHEN amw_deadlock_detected THEN
3449: ROLLBACK;
3450: x_return_status := FND_API.G_RET_STS_ERROR;
3451: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3452:
3453: WHEN FND_API.G_EXC_ERROR THEN
3454: ROLLBACK;

Line 3451: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

3447:
3448: WHEN amw_deadlock_detected THEN
3449: ROLLBACK;
3450: x_return_status := FND_API.G_RET_STS_ERROR;
3451: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3452:
3453: WHEN FND_API.G_EXC_ERROR THEN
3454: ROLLBACK;
3455: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3453: WHEN FND_API.G_EXC_ERROR THEN

3449: ROLLBACK;
3450: x_return_status := FND_API.G_RET_STS_ERROR;
3451: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3452:
3453: WHEN FND_API.G_EXC_ERROR THEN
3454: ROLLBACK;
3455: x_return_status := FND_API.G_RET_STS_ERROR;
3456: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3457:

Line 3455: x_return_status := FND_API.G_RET_STS_ERROR;

3451: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3452:
3453: WHEN FND_API.G_EXC_ERROR THEN
3454: ROLLBACK;
3455: x_return_status := FND_API.G_RET_STS_ERROR;
3456: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3457:
3458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3459: ROLLBACK;

Line 3456: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

3452:
3453: WHEN FND_API.G_EXC_ERROR THEN
3454: ROLLBACK;
3455: x_return_status := FND_API.G_RET_STS_ERROR;
3456: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3457:
3458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3459: ROLLBACK;
3460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3454: ROLLBACK;
3455: x_return_status := FND_API.G_RET_STS_ERROR;
3456: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3457:
3458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3459: ROLLBACK;
3460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3461: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3462:

Line 3460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3456: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3457:
3458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3459: ROLLBACK;
3460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3461: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3462:
3463:
3464: -- kosriniv begin :- Handle amw_processing_exception

Line 3461: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

3457:
3458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3459: ROLLBACK;
3460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3461: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3462:
3463:
3464: -- kosriniv begin :- Handle amw_processing_exception
3465: WHEN amw_processing_exception THEN

Line 3476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3472: -- kosriniv end.
3473:
3474: WHEN OTHERS THEN
3475: ROLLBACK;
3476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3477: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3478: THEN
3479: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
3480: END IF;

Line 3481: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

3477: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3478: THEN
3479: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
3480: END IF;
3481: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3482:
3483: end old_synch_hier_amw_process;
3484:
3485: