3137:
3138: END LOOP;
3139:
3140: CLOSE cur_cm_invoice;
3141: x_return_status :=FND_API.G_RET_STS_SUCCESS;
3142: EXCEPTION
3143: WHEN OTHERS THEN
3144: x_return_status :='E';
3145: IF g1_debug_mode = 'Y' THEN
3639:
3640:
3641: END IF;
3642:
3643: x_return_status :=FND_API.G_RET_STS_SUCCESS;
3644:
3645: EXCEPTION
3646: WHEN OTHERS THEN
3647: x_return_status := 'E';
3784: If l_Cust_Top_Task_Flag = 'Y' OR l_Inv_Method_Top_Task_Flag = 'Y' Then
3785: Delete From PA_Proj_Retn_Rules -- PA_Project_Retentions
3786: Where Project_ID = P_Project_ID
3787: And Task_ID = P_Task_ID;
3788: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
3789: End If;
3790:
3791: EXCEPTION
3792: WHEN OTHERS THEN