APPS.PSB_BUDGET_GROUPS_PVT dependencies on PSB_ERROR_MESSAGES

Line 937: delete from PSB_ERROR_MESSAGES

933: ) THEN
934:
935: Output_Message_To_Table(p_budget_group_id => p_budget_group_id);
936: ELSE
937: delete from PSB_ERROR_MESSAGES
938: where source_process = 'VALIDATE_BUDGET_HIERARCHY'
939: and process_id = p_budget_group_id;
940: -- to delete previous error for the budget group
941: END IF;

Line 3641: DELETE PSB_ERROR_MESSAGES

3637: /* Start bug 4030864 */
3638: IF l_missing_accts.count > 0 THEN
3639: l_count := l_count + 1;
3640: IF l_count = 1 THEN
3641: DELETE PSB_ERROR_MESSAGES
3642: WHERE SOURCE_PROCESS = 'VALIDATE_BUDGET_HIERARCHY'
3643: AND process_id = p_top_budget_group_id;
3644: END IF;
3645: END IF;

Line 4010: delete from PSB_ERROR_MESSAGES

4006:
4007: BEGIN
4008: /* Start bug no 4030864 */
4009: IF PSB_MESSAGE_S.l_batch_error_flag = FALSE THEN
4010: delete from PSB_ERROR_MESSAGES
4011: where source_process = 'VALIDATE_BUDGET_HIERARCHY'
4012: and process_id = p_budget_group_id;
4013: END IF;
4014: /* End bug no 4030864 */

Line 4038: FROM psb_error_messages

4034:
4035: -- end of session
4036: FOR l_max_seq_rec IN (
4037: SELECT max(sequence_number) + 1 max_seq
4038: FROM psb_error_messages
4039: WHERE process_id = p_budget_group_id
4040: AND source_process = 'VALIDATE_BUDGET_HIERARCHY')
4041: LOOP
4042: l_max_sequence_number := l_max_seq_rec.max_seq;

Line 4046: UPDATE psb_error_messages

4042: l_max_sequence_number := l_max_seq_rec.max_seq;
4043: END LOOP;
4044:
4045: IF l_max_sequence_number > 0 THEN
4046: UPDATE psb_error_messages
4047: SET sequence_number = (l_max_sequence_number - sequence_number)
4048: WHERE process_id = p_budget_group_id
4049: AND source_process = 'VALIDATE_BUDGET_HIERARCHY';
4050: END IF;