1166:
1167: BEGIN
1168: x_msg_count := 0;
1169: x_return_status := FND_API.G_RET_STS_SUCCESS;
1170: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1171:
1172: IF l_debug_mode = 'Y' THEN
1173: pa_debug.set_curr_function( p_function => 'START_NOTIFICATION_WF',
1174: p_debug_mode => l_debug_mode );
1169: x_return_status := FND_API.G_RET_STS_SUCCESS;
1170: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1171:
1172: IF l_debug_mode = 'Y' THEN
1173: pa_debug.set_curr_function( p_function => 'START_NOTIFICATION_WF',
1174: p_debug_mode => l_debug_mode );
1175: END IF;
1176:
1177: -- Check for business rules violations
1176:
1177: -- Check for business rules violations
1178:
1179: IF l_debug_mode = 'Y' THEN
1180: pa_debug.g_err_stage:= 'Validating input parameters';
1181: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1182: pa_debug.g_err_stage:= 'p_item_type = '|| p_item_type;
1183: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1184: pa_debug.g_err_stage:= 'p_process_name = '|| p_process_name;
1177: -- Check for business rules violations
1178:
1179: IF l_debug_mode = 'Y' THEN
1180: pa_debug.g_err_stage:= 'Validating input parameters';
1181: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1182: pa_debug.g_err_stage:= 'p_item_type = '|| p_item_type;
1183: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1184: pa_debug.g_err_stage:= 'p_process_name = '|| p_process_name;
1185: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1178:
1179: IF l_debug_mode = 'Y' THEN
1180: pa_debug.g_err_stage:= 'Validating input parameters';
1181: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1182: pa_debug.g_err_stage:= 'p_item_type = '|| p_item_type;
1183: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1184: pa_debug.g_err_stage:= 'p_process_name = '|| p_process_name;
1185: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1186: pa_debug.g_err_stage:= 'p_ci_id = '|| p_ci_id;
1179: IF l_debug_mode = 'Y' THEN
1180: pa_debug.g_err_stage:= 'Validating input parameters';
1181: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1182: pa_debug.g_err_stage:= 'p_item_type = '|| p_item_type;
1183: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1184: pa_debug.g_err_stage:= 'p_process_name = '|| p_process_name;
1185: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1186: pa_debug.g_err_stage:= 'p_ci_id = '|| p_ci_id;
1187: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1180: pa_debug.g_err_stage:= 'Validating input parameters';
1181: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1182: pa_debug.g_err_stage:= 'p_item_type = '|| p_item_type;
1183: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1184: pa_debug.g_err_stage:= 'p_process_name = '|| p_process_name;
1185: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1186: pa_debug.g_err_stage:= 'p_ci_id = '|| p_ci_id;
1187: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1188: pa_debug.g_err_stage:= 'p_action_id = '|| p_action_id;
1181: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1182: pa_debug.g_err_stage:= 'p_item_type = '|| p_item_type;
1183: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1184: pa_debug.g_err_stage:= 'p_process_name = '|| p_process_name;
1185: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1186: pa_debug.g_err_stage:= 'p_ci_id = '|| p_ci_id;
1187: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1188: pa_debug.g_err_stage:= 'p_action_id = '|| p_action_id;
1189: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1182: pa_debug.g_err_stage:= 'p_item_type = '|| p_item_type;
1183: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1184: pa_debug.g_err_stage:= 'p_process_name = '|| p_process_name;
1185: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1186: pa_debug.g_err_stage:= 'p_ci_id = '|| p_ci_id;
1187: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1188: pa_debug.g_err_stage:= 'p_action_id = '|| p_action_id;
1189: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1190: END IF;
1183: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1184: pa_debug.g_err_stage:= 'p_process_name = '|| p_process_name;
1185: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1186: pa_debug.g_err_stage:= 'p_ci_id = '|| p_ci_id;
1187: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1188: pa_debug.g_err_stage:= 'p_action_id = '|| p_action_id;
1189: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1190: END IF;
1191:
1184: pa_debug.g_err_stage:= 'p_process_name = '|| p_process_name;
1185: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1186: pa_debug.g_err_stage:= 'p_ci_id = '|| p_ci_id;
1187: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1188: pa_debug.g_err_stage:= 'p_action_id = '|| p_action_id;
1189: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1190: END IF;
1191:
1192: IF (p_item_type IS NULL) OR
1185: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1186: pa_debug.g_err_stage:= 'p_ci_id = '|| p_ci_id;
1187: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1188: pa_debug.g_err_stage:= 'p_action_id = '|| p_action_id;
1189: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1190: END IF;
1191:
1192: IF (p_item_type IS NULL) OR
1193: (p_process_name IS NULL) OR
1222: x_item_key := To_char(l_item_key);
1223:
1224:
1225: IF l_debug_mode = 'Y' THEN
1226: pa_debug.g_err_stage:= 'x_item_key = '|| x_item_key;
1227: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1228: END IF;
1229: -- create the workflow process
1230: WF_ENGINE.CreateProcess(p_item_type
1223:
1224:
1225: IF l_debug_mode = 'Y' THEN
1226: pa_debug.g_err_stage:= 'x_item_key = '|| x_item_key;
1227: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1228: END IF;
1229: -- create the workflow process
1230: WF_ENGINE.CreateProcess(p_item_type
1231: ,x_item_key
1247:
1248:
1249: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1250: IF l_debug_mode = 'Y' THEN
1251: pa_debug.g_err_stage:= 'Error calling pa_control_item_workflow.SET_WORKFLOW_ATTRIBUTES';
1252: pa_debug.write('START_NOTIFICATION_WF: ' || l_module_name,pa_debug.g_err_stage,l_debug_level5);
1253:
1254: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1255: ,p_msg_name => 'PA_PR_CREATE_WF_FAILED');
1248:
1249: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1250: IF l_debug_mode = 'Y' THEN
1251: pa_debug.g_err_stage:= 'Error calling pa_control_item_workflow.SET_WORKFLOW_ATTRIBUTES';
1252: pa_debug.write('START_NOTIFICATION_WF: ' || l_module_name,pa_debug.g_err_stage,l_debug_level5);
1253:
1254: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1255: ,p_msg_name => 'PA_PR_CREATE_WF_FAILED');
1256: END IF;
1257: RAISE Invalid_Arg_Exc_CI;
1258: END IF;
1259:
1260: IF l_debug_mode = 'Y' THEN
1261: pa_debug.g_err_stage:= 'returned from pa_control_items_workflow.set_workflow_attributes';
1262: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1263: END IF;
1264:
1265:
1258: END IF;
1259:
1260: IF l_debug_mode = 'Y' THEN
1261: pa_debug.g_err_stage:= 'returned from pa_control_items_workflow.set_workflow_attributes';
1262: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1263: END IF;
1264:
1265:
1266: WF_ENGINE.StartProcess(p_item_type
1291: END IF;
1292:
1293:
1294: IF l_debug_mode = 'Y' THEN
1295: pa_debug.g_err_stage:= 'Exiting START_NOTIFICATION_WF';
1296: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1297: pa_debug.reset_curr_function;
1298: END IF;
1299: EXCEPTION
1292:
1293:
1294: IF l_debug_mode = 'Y' THEN
1295: pa_debug.g_err_stage:= 'Exiting START_NOTIFICATION_WF';
1296: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1297: pa_debug.reset_curr_function;
1298: END IF;
1299: EXCEPTION
1300:
1293:
1294: IF l_debug_mode = 'Y' THEN
1295: pa_debug.g_err_stage:= 'Exiting START_NOTIFICATION_WF';
1296: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1297: pa_debug.reset_curr_function;
1298: END IF;
1299: EXCEPTION
1300:
1301: WHEN Invalid_Arg_Exc_CI THEN
1319: ELSE
1320: x_msg_count := l_msg_count;
1321: END IF;
1322: IF l_debug_mode = 'Y' THEN
1323: pa_debug.reset_curr_function;
1324: END IF;
1325:
1326: RETURN;
1327:
1340: ,p_procedure_name => 'START_NOTIFICATION_WF'
1341: ,p_error_text => x_msg_data);
1342:
1343: IF l_debug_mode = 'Y' THEN
1344: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1345: pa_debug.write(l_module_name,pa_debug.g_err_stage,
1346: l_debug_level5);
1347: pa_debug.reset_curr_function;
1348: END IF;
1341: ,p_error_text => x_msg_data);
1342:
1343: IF l_debug_mode = 'Y' THEN
1344: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1345: pa_debug.write(l_module_name,pa_debug.g_err_stage,
1346: l_debug_level5);
1347: pa_debug.reset_curr_function;
1348: END IF;
1349: RAISE;
1343: IF l_debug_mode = 'Y' THEN
1344: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1345: pa_debug.write(l_module_name,pa_debug.g_err_stage,
1346: l_debug_level5);
1347: pa_debug.reset_curr_function;
1348: END IF;
1349: RAISE;
1350: END START_NOTIFICATION_WF;
1351:
1612: BEGIN
1613:
1614: x_msg_count := 0;
1615: x_return_status := FND_API.G_RET_STS_SUCCESS;
1616: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1617:
1618: IF l_debug_mode = 'Y' THEN
1619: pa_debug.set_curr_function( p_function => 'set_workflow_attributes',
1620: p_debug_mode => l_debug_mode );
1615: x_return_status := FND_API.G_RET_STS_SUCCESS;
1616: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1617:
1618: IF l_debug_mode = 'Y' THEN
1619: pa_debug.set_curr_function( p_function => 'set_workflow_attributes',
1620: p_debug_mode => l_debug_mode );
1621: END IF;
1622:
1623: -- Check for business rules violations
1626: l_action_process := false;
1627: end if;
1628:
1629: IF l_debug_mode = 'Y' THEN
1630: pa_debug.g_err_stage:= 'Validating input parameters';
1631: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1632: pa_debug.g_err_stage:= 'p_item_type = '|| p_item_type;
1633: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
1634: pa_debug.g_err_stage:= 'p_process_name = '|| p_process_name;
1627: end if;
1628:
1629: IF l_debug_mode = 'Y' THEN
1630: pa_debug.g_err_stage:= 'Validating input parameters';
1631: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1632: pa_debug.g_err_stage:= 'p_item_type = '|| p_item_type;
1633: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
1634: pa_debug.g_err_stage:= 'p_process_name = '|| p_process_name;
1635: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
1628:
1629: IF l_debug_mode = 'Y' THEN
1630: pa_debug.g_err_stage:= 'Validating input parameters';
1631: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1632: pa_debug.g_err_stage:= 'p_item_type = '|| p_item_type;
1633: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
1634: pa_debug.g_err_stage:= 'p_process_name = '|| p_process_name;
1635: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
1636: pa_debug.g_err_stage:= 'p_ci_id = '|| p_ci_id;
1629: IF l_debug_mode = 'Y' THEN
1630: pa_debug.g_err_stage:= 'Validating input parameters';
1631: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1632: pa_debug.g_err_stage:= 'p_item_type = '|| p_item_type;
1633: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
1634: pa_debug.g_err_stage:= 'p_process_name = '|| p_process_name;
1635: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
1636: pa_debug.g_err_stage:= 'p_ci_id = '|| p_ci_id;
1637: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
1630: pa_debug.g_err_stage:= 'Validating input parameters';
1631: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1632: pa_debug.g_err_stage:= 'p_item_type = '|| p_item_type;
1633: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
1634: pa_debug.g_err_stage:= 'p_process_name = '|| p_process_name;
1635: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
1636: pa_debug.g_err_stage:= 'p_ci_id = '|| p_ci_id;
1637: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
1638: END IF;
1631: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1632: pa_debug.g_err_stage:= 'p_item_type = '|| p_item_type;
1633: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
1634: pa_debug.g_err_stage:= 'p_process_name = '|| p_process_name;
1635: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
1636: pa_debug.g_err_stage:= 'p_ci_id = '|| p_ci_id;
1637: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
1638: END IF;
1639: IF (p_item_type IS NULL) OR
1632: pa_debug.g_err_stage:= 'p_item_type = '|| p_item_type;
1633: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
1634: pa_debug.g_err_stage:= 'p_process_name = '|| p_process_name;
1635: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
1636: pa_debug.g_err_stage:= 'p_ci_id = '|| p_ci_id;
1637: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
1638: END IF;
1639: IF (p_item_type IS NULL) OR
1640: (p_process_name IS NULL) OR
1633: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
1634: pa_debug.g_err_stage:= 'p_process_name = '|| p_process_name;
1635: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
1636: pa_debug.g_err_stage:= 'p_ci_id = '|| p_ci_id;
1637: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
1638: END IF;
1639: IF (p_item_type IS NULL) OR
1640: (p_process_name IS NULL) OR
1641: (p_ci_id IS NULL)
2036: l_loop_var1 := l_loop_var1 + 1;
2037:
2038: PartyId_Tbl(l_loop_var1) := x.party_id;
2039: IF l_debug_mode = 'Y' THEN
2040: pa_debug.g_err_stage:= 'notification sent to :'||PartyId_Tbl(l_loop_var1);
2041: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
2042: END IF;
2043: --Bug 3608031
2044: --l_loop_var1 := l_loop_var1 + 1;
2037:
2038: PartyId_Tbl(l_loop_var1) := x.party_id;
2039: IF l_debug_mode = 'Y' THEN
2040: pa_debug.g_err_stage:= 'notification sent to :'||PartyId_Tbl(l_loop_var1);
2041: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
2042: END IF;
2043: --Bug 3608031
2044: --l_loop_var1 := l_loop_var1 + 1;
2045: END IF;
2117: , l_role);
2118: END IF;
2119:
2120: IF l_debug_mode = 'Y' THEN
2121: pa_debug.g_err_stage:= 'Exiting set_workflow_attributes';
2122: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
2123: pa_debug.reset_curr_function;
2124: END IF;
2125: EXCEPTION
2118: END IF;
2119:
2120: IF l_debug_mode = 'Y' THEN
2121: pa_debug.g_err_stage:= 'Exiting set_workflow_attributes';
2122: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
2123: pa_debug.reset_curr_function;
2124: END IF;
2125: EXCEPTION
2126:
2119:
2120: IF l_debug_mode = 'Y' THEN
2121: pa_debug.g_err_stage:= 'Exiting set_workflow_attributes';
2122: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
2123: pa_debug.reset_curr_function;
2124: END IF;
2125: EXCEPTION
2126:
2127: WHEN Invalid_Arg_Exc_CI THEN
2165: ELSE
2166: x_msg_count := l_msg_count;
2167: END IF;
2168: IF l_debug_mode = 'Y' THEN
2169: pa_debug.reset_curr_function;
2170: END IF;
2171:
2172: RETURN;
2173:
2206: ,p_procedure_name => 'set_workflow_attributes'
2207: ,p_error_text => x_msg_data);
2208:
2209: IF l_debug_mode = 'Y' THEN
2210: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
2211: pa_debug.write(l_module_name,pa_debug.g_err_stage,
2212: l_debug_level5);
2213: pa_debug.reset_curr_function;
2214: END IF;
2207: ,p_error_text => x_msg_data);
2208:
2209: IF l_debug_mode = 'Y' THEN
2210: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
2211: pa_debug.write(l_module_name,pa_debug.g_err_stage,
2212: l_debug_level5);
2213: pa_debug.reset_curr_function;
2214: END IF;
2215: RAISE;
2209: IF l_debug_mode = 'Y' THEN
2210: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
2211: pa_debug.write(l_module_name,pa_debug.g_err_stage,
2212: l_debug_level5);
2213: pa_debug.reset_curr_function;
2214: END IF;
2215: RAISE;
2216: END set_workflow_attributes;
2217:
2284: where ci_action_id = l_ci_action_id;
2285:
2286: BEGIN
2287: -- Initialize the Error Stack
2288: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_WORKFLOW.CLOSE_CI_ACTION');
2289:
2290:
2291: l_ci_id := wf_engine.GetItemAttrNumber
2292: ( itemtype => itemtype,
2546: from pa_control_items
2547: where ci_id = l_ci_id;
2548: BEGIN
2549: -- Initialize the Error Stack
2550: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_WORKFLOW.KEEP_OPEN');
2551:
2552:
2553:
2554: l_ci_id := wf_engine.GetItemAttrNumber