DBA Data[Home] [Help]

APPS.PA_CONTROL_ITEMS_WORKFLOW dependencies on PA_DEBUG

Line 1170: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

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 );

Line 1173: pa_debug.set_curr_function( p_function => 'START_NOTIFICATION_WF',

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

Line 1180: pa_debug.g_err_stage:= 'Validating input parameters';

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;

Line 1181: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

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);

Line 1182: pa_debug.g_err_stage:= 'p_item_type = '|| p_item_type;

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;

Line 1183: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

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);

Line 1184: pa_debug.g_err_stage:= 'p_process_name = '|| p_process_name;

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;

Line 1185: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

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);

Line 1186: pa_debug.g_err_stage:= 'p_ci_id = '|| p_ci_id;

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;

Line 1187: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

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:

Line 1188: pa_debug.g_err_stage:= 'p_action_id = '|| p_action_id;

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

Line 1189: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

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

Line 1226: pa_debug.g_err_stage:= 'x_item_key = '|| x_item_key;

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

Line 1227: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

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

Line 1251: pa_debug.g_err_stage:= 'Error calling pa_control_item_workflow.SET_WORKFLOW_ATTRIBUTES';

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');

Line 1252: pa_debug.write('START_NOTIFICATION_WF: ' || l_module_name,pa_debug.g_err_stage,l_debug_level5);

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;

Line 1261: pa_debug.g_err_stage:= 'returned from pa_control_items_workflow.set_workflow_attributes';

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:

Line 1262: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

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

Line 1295: pa_debug.g_err_stage:= 'Exiting START_NOTIFICATION_WF';

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

Line 1296: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

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:

Line 1297: pa_debug.reset_curr_function;

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

Line 1323: pa_debug.reset_curr_function;

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:

Line 1344: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;

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;

Line 1345: pa_debug.write(l_module_name,pa_debug.g_err_stage,

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;

Line 1347: pa_debug.reset_curr_function;

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:

Line 1616: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

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 );

Line 1619: pa_debug.set_curr_function( p_function => 'set_workflow_attributes',

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

Line 1630: pa_debug.g_err_stage:= 'Validating input parameters';

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;

Line 1631: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

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);

Line 1632: pa_debug.g_err_stage:= 'p_item_type = '|| p_item_type;

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;

Line 1633: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);

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);

Line 1634: pa_debug.g_err_stage:= 'p_process_name = '|| p_process_name;

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;

Line 1635: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);

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

Line 1636: pa_debug.g_err_stage:= 'p_ci_id = '|| p_ci_id;

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

Line 1637: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);

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)

Line 2040: pa_debug.g_err_stage:= 'notification sent to :'||PartyId_Tbl(l_loop_var1);

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;

Line 2041: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

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;

Line 2121: pa_debug.g_err_stage:= 'Exiting set_workflow_attributes';

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

Line 2122: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

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:

Line 2123: pa_debug.reset_curr_function;

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

Line 2169: pa_debug.reset_curr_function;

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:

Line 2210: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;

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;

Line 2211: pa_debug.write(l_module_name,pa_debug.g_err_stage,

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;

Line 2213: pa_debug.reset_curr_function;

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:

Line 2288: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_WORKFLOW.CLOSE_CI_ACTION');

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,

Line 2550: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_WORKFLOW.KEEP_OPEN');

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